Given 3 tables:
Bitcoin_News_EventsRegionsLocations
I would like to see the output of two joins:
- Bitcoin_News_Events + Region
- Bitcoin_News_Events + Locations
As a for instance, the recent article about Russia "banning" bitcoin circulation would highlight the region of russia on a map.
When articles mention US states that have protected bitcoin ownership, those articles would be retrievable from a region lookup.
Tools that might be used to implement this site:
- Postgresql
- PostGIS https://postgis.net
- Open Layers https://openlayers.org/
Hardest part is data cleaning. What source/API do you use to scrape for "news" ?
Do these sources have limits or require subscriptions?
How do you know an article is about a particular country/region?
Maybe the article doesn't mention any country by name, instead uses other tangential references like "Putin, Federal Reserve, etc."
You can just search Google News for "bitcoin [country name]"
You're absolutely right.
IMO, there's one angle: Use a language model
i'm sorry it's that angle... the alternative is "incentivize users to provide (only)
clean data"