Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
+---------------------------+----------------+------------------------+-------------------------+---------------------------------+-------------------------------+---------------------------------+----------------+
| 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