Google BigQuery, Freebase, Maps:...
summary
Using the Freebase dump (≈22 GB) loaded into BigQuery, the team runs SQL over 2 billion RDF triples to identify ~3 million people and ~2 million with recorded gender, finding roughly 3x more males than females and a modal Wikipedia age of 26. Queries that scan the dataset return in seconds, extracts produce country‑level birthplace counts, and results are rendered as GeoJSON overlays on Google Maps to show profession and regional imbalances.
AI-written summary · about
chapters (9)
- 0:00Introduction and motivation
- 4:00What is Freebase
- 12:54Introducing BigQuery
- 20:23Analyzing gender distribution
- 24:55Gender gap by profession
- 28:49Visualizing data on maps
- 33:06Building the gender maps demo
- 37:17Live map creation
- 49:08Q&A session
related talks
31mExploring open data with BigQuery
40mMigrating Freebase to Wikidata
06mGoogle BigQuery for enterprise
35mPowering Interactive Data Analysis with Google BigQuery
33mAnalyzing 33 million bike trips with BigQuery
40mProtecting sensitive data in huge datasets #bbuzz
34mGoogle BigQuery
30mAnalyzing 33 million bike trips with BigQuery