this post was submitted on 13 Sep 2024
15 points (100.0% liked)

Programming

423 readers
4 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



founded 1 year ago
MODERATORS
 

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)

top 7 comments
sorted by: hot top controversial new old
[–] verstra@programming.dev 10 points 2 months ago (3 children)

Maybe search for this on kaggle? Or scrape Wikipedia?

[–] dracs@programming.dev 7 points 2 months ago* (last edited 2 months ago)

Probably don't need to scrape it. Just query WikiData for it

https://wikidata.org

[–] henfredemars@infosec.pub 4 points 2 months ago

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.

[–] friendly_ghost 3 points 2 months ago

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

[–] MxRemy@piefed.social 6 points 2 months ago (1 children)

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?

[–] friendly_ghost 2 points 2 months ago

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.

[–] degen@midwest.social 5 points 2 months ago

Could take a subset and do ICANN lookups. Not sure about doing that at scale though.