This data as json, CSV (advanced)
user_agent ✖
query_string ✖
content_type ✖
Link | rowid ▼ | start | method | path | query_string | user_agent | referer | accept_language | http_status | content_type | client_ip | duration | body_size |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48 | 48 | 1576529529.313341 | GET | /demo/requests 9 | ?_facet=path&_facet=content_type&_facet=query_string&_sort_desc=user_agent&_facet=user_agent 9 | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 2 | en-US,en;q=0.9 2 | 200 | text/html; charset=utf-8 1 | 127.0.0.1 | 0.041190147399902344 | 90640 | |
51 | 51 | 1576529538.975065 | GET | /demo/requests 9 | ?_facet=path&_facet=content_type&_facet=query_string&_sort_desc=user_agent&_facet=user_agent 9 | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Safari/605.1.15 3 | en-us 3 | 200 | text/html; charset=utf-8 1 | 127.0.0.1 | 0.04465222358703613 | 95319 |
JSON shape: default, array, newline-delimited
CREATE TABLE [requests] ( [start] FLOAT, [method] TEXT, [path] INTEGER REFERENCES [paths]([id]), [query_string] INTEGER REFERENCES [query_strings]([id]), [user_agent] INTEGER REFERENCES [user_agents]([id]), [referer] INTEGER REFERENCES [referers]([id]), [accept_language] INTEGER REFERENCES [accept_languages]([id]), [http_status] INTEGER, [content_type] INTEGER REFERENCES [content_types]([id]), [client_ip] TEXT, [duration] FLOAT, [body_size] INTEGER );