I realize this is an absolutely unhinged thing to ask for: Can anyone direct me to a large database of company names with websites (just those two columns), ideally 100K rows or more, that I can access for free? Basically this database if it had another column with the company name: https://github.com/cygenta/top10million (but doesn’t need to be anywhere near 10 million)
Maybe search for this on kaggle? Or scrape Wikipedia?
Thank you for recommending kaggle! I found just what I needed there (actually way more data than I needed!). Here’s what I went with, if it’s useful to anyone else: https://www.kaggle.com/datasets/mfrye0/bigpicture-company-dataset
Probably don’t need to scrape it. Just query WikiData for it
You don’t even need to scrape Wikipedia. Simply download all of Wikipedia text only and you could match on articles. It’s only like 20 GB or even less for certain database dumps.
A lot of public libraries offer access to ReferenceUSA through your library card. I vaguely remember that queries are pretty customizable on there, and exportable to various formats. Despite the generic name, it’s specifically for businesses. Would that work?
Thank you for this suggestion, I had never heard of it! I was able to access it via my library, and easily searched up companies with websites, but then it made me manually click which results to download (wouldn’t let me export the results as one large file). Keeping it bookmarked though, seems like a great resource for other use cases.
Could take a subset and do ICANN lookups. Not sure about doing that at scale though.
