Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/geo_dimensions.sql

Created August 25, 2016 05:53
Show Gist options
  • Save doryokujin/545214d83bd8c79c618868a0f48ef388 to your computer and use it in GitHub Desktop.
Save doryokujin/545214d83bd8c79c618868a0f48ef388 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
geo_dimensions.sql
+---------------------------+----------------+--------------------+--------------+-------------+-----------------+------------------+----------------+
| date_hour:timestamp | country:string | region:string | metro:string | city:string | latitude:string | longitude:string | pageviews:long |
+---------------------------+----------------+--------------------+--------------+-------------+-----------------+------------------+----------------+
| "2016-08-17 15:00:00 UTC" | "Japan" | "Aichi Prefecture" | "(not set)" | "Nagoya" | "35.1814" | "136.9064" | 2 |
| "2016-08-17 15:00:00 UTC" | "Japan" | "Nara Prefecture" | "(not set)" | "Tenri" | "34.5966" | "135.8373" | 1 |
| "2016-08-17 15:00:00 UTC" | "Japan" | "Osaka Prefecture" | "(not set)" | "Osaka" | "34.6937" | "135.5022" | 1 |
| "2016-08-17 15:00:00 UTC" | "Japan" | "Tokyo" | "(not set)" | "Minato" | "35.6581" | "139.7516" | 4 |
| "2016-08-17 16:00:00 UTC" | "Japan" | "Chiba Prefecture" | "(not set)" | "Funabashi" | "35.6947" | "139.9826" | 1 |
| "2016-08-17 16:00:00 UTC" | "Japan" | "Chiba Prefecture" | "(not set)" | "Ichihara" | "35.4978" | "140.1157" | 1 |
| "2016-08-17 16:00:00 UTC" | "Japan" | "Chiba Prefecture" | "(not set)" | "Yachiyo" | "35.7225" | "140.0998" | 1 |
| "2016-08-17 16:00:00 UTC" | "Japan" | "Hokkaido" | "(not set)" | "Sapporo" | "43.0621" | "141.3544" | 1 |
| "2016-08-17 16:00:00 UTC" | "Japan" | "Osaka Prefecture" | "(not set)" | "Osaka" | "34.6937" | "135.5022" | 1 |
| "2016-08-17 16:00:00 UTC" | "Japan" | "Tokyo" | "(not set)" | "Koto" | "35.6729" | "139.8174" | 1 |
+---------------------------+----------------+--------------------+--------------+-------------+-----------------+------------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment