Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/system_dimensions.sql

Created August 25, 2016 05:46
Show Gist options
  • Save doryokujin/0c4310933a66b78268bfcdb9e1bd0203 to your computer and use it in GitHub Desktop.
Save doryokujin/0c4310933a66b78268bfcdb9e1bd0203 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
system_dimensions.sql
+---------------------------+----------------+------------------------+-------------------------+---------------------------------+-------------------------------+---------------------------------+----------------+
| date_hour:timestamp | browser:string | browser_version:string | operating_system:string | operating_system_version:string | mobile_device_branding:string | mobile_device_info:string | pageviews:long |
+---------------------------+----------------+------------------------+-------------------------+---------------------------------+-------------------------------+---------------------------------+----------------+
| "2016-08-17 15:00:00 UTC" | "Chrome" | "51.0.2704.81" | "Android" | "5.0.2" | "Sony" | "Sony SO-02G Xperia Z3 Compact" | 2 |
| "2016-08-17 15:00:00 UTC" | "Chrome" | "52.0.2743.98" | "Android" | "5.0" | "Asus" | "Asus ASUS_Z00AD ZenFone 2" | 1 |
| "2016-08-17 15:00:00 UTC" | "Safari" | "9.0" | "iOS" | "9.2" | "Apple" | "Apple iPhone" | 1 |
| "2016-08-17 15:00:00 UTC" | "Safari" | "9.0" | "iOS" | "9.3.4" | "Apple" | "Apple iPhone" | 3 |
| "2016-08-17 16:00:00 UTC" | "Chrome" | "37.0.0.0" | "Android" | "5.0.2" | "DoCoMo" | "DoCoMo F-02G Arrows NX F-02G" | 1 |
| "2016-08-17 16:00:00 UTC" | "Chrome" | "42.0.2311.138" | "Android" | "5.0.2" | "Sharp" | "Sharp SH-04G Aquos Ever" | 1 |
| "2016-08-17 16:00:00 UTC" | "Chrome" | "52.0.2743.84" | "iOS" | "9.3.4" | "Apple" | "Apple iPhone" | 1 |
| "2016-08-17 16:00:00 UTC" | "Chrome" | "52.0.2743.98" | "Android" | "6.0.1" | "(not set)" | "(not set)" | 1 |
| "2016-08-17 16:00:00 UTC" | "Chrome" | "52.0.2743.98" | "Android" | "6.0.1" | "Sony" | "Sony S0-04G Xperia A4" | 1 |
| "2016-08-17 16:00:00 UTC" | "Safari" | "9.0" | "iOS" | "9.3.4" | "Apple" | "Apple iPhone" | 1 |
+---------------------------+----------------+------------------------+-------------------------+---------------------------------+-------------------------------+---------------------------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment