requests

41 rows where user_agent = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: path, query_string, referer, content_type, body_size

Link rowid start method path query_string user_agent referer accept_language http_status content_type client_ip duration body_size
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
52 52 1576529539.038551 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0010790824890136719 6104
53 53 1576529539.1299012 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.0002028942108154297 0
54 54 1576529542.2622201 GET / 1   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.007745981216430664 1138
55 55 1576529542.2791722 GET /-/static/app.css 2 ?cbffc0 1 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 http://127.0.0.1:8855/ 1 en-us 3 200 text/css 2 127.0.0.1 0.0011739730834960938 6104
56 56 1576529542.4748769 GET /favicon.ico 3   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 http://127.0.0.1:8855/ 1 en-us 3 200 text/plain 3 127.0.0.1 0.00023293495178222656 0
57 57 1576529544.8808908 GET /demo/query_strings 10   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 http://127.0.0.1:8855/ 1 en-us 3 200 text/html; charset=utf-8 1 127.0.0.1 0.006421089172363281 8281
58 58 1576529544.893518 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0009810924530029297 6104
59 59 1576529544.951581 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.00018978118896484375 0
60 60 1576529549.5140412 GET /demo/query_strings.json 11   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 application/json; charset=utf-8 5 127.0.0.1 0.004565000534057617 1021
61 61 1576529549.5597491 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.0002548694610595703 0
62 62 1576529552.223166 GET /demo/query_strings.csv 12 ?_size=max 10 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/plain; charset=utf-8 6 127.0.0.1 0.004580974578857422 516
63 63 1576529552.247155 GET /favicon.ico 3   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 http://127.0.0.1:8855/demo/query_strings.csv?_size=max 3 en-us 3 200 text/plain 3 127.0.0.1 0.00021505355834960938 0
64 64 1576529554.180515 GET /demo 4   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.006307840347290039 3686
65 65 1576529554.193075 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0011761188507080078 6104
66 66 1576529554.19694 GET /-/static/sql-formatter-2.3.3.min.js 6   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 application/javascript 4 127.0.0.1 0.0075740814208984375 41376
67 67 1576529554.2007291 GET /-/static/codemirror-5.31.0-min.css 5   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/css 2 127.0.0.1 0.0066869258880615234 5920
68 68 1576529554.2018719 GET /-/static/codemirror-5.31.0-sql.min.js 7   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 application/javascript 4 127.0.0.1 0.010223150253295898 35366
69 69 1576529554.201552 GET /-/static/codemirror-5.31.0.js 8   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 application/javascript 4 127.0.0.1 0.022229909896850586 372736
70 70 1576529554.303811 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.00022292137145996094 0
71 71 1576529556.109 GET /demo/referers 13   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.005632877349853516 6731
72 72 1576529556.1214678 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0012710094451904297 6104
73 73 1576529556.13226 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.0002048015594482422 0
74 74 1576529562.3331468 GET /demo/requests 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.0391840934753418 115081
75 75 1576529562.381118 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0010509490966796875 6104
76 76 1576529562.419039 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.0001919269561767578 0
77 77 1576529566.54418 GET /demo/requests 9 ?_facet=accept_language 11 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.051586151123046875 120827
78 78 1576529566.601397 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0011970996856689453 6104
79 79 1576529566.649903 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.0002357959747314453 0
80 80 1576529568.598478 GET /demo/requests 9 ?_facet=accept_language&_facet=referer 12 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.04027295112609863 126647
81 81 1576529568.647962 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0010440349578857422 6104
82 82 1576529568.690929 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.00020599365234375 0
83 83 1576529571.151196 GET /demo/requests 9 ?_facet=referer 13 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.043524980545043945 129008
84 84 1576529571.201143 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.001194000244140625 6104
85 85 1576529571.243574 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.0003249645233154297 0
86 86 1576529572.248013 GET /demo/requests 9 ?_facet=referer&_facet=content_type 14 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.044042110443115234 135634
87 87 1576529572.2988968 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0015301704406738281 6104
88 88 1576529572.344661 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.00018787384033203125 0
89 89 1576529574.735533 GET /demo/requests 9 ?_facet=referer&_facet=content_type&_facet=accept_language 15 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.053102970123291016 141879
90 90 1576529574.7946932 GET /-/static/app.css 2 ?cbffc0 1 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/css 2 127.0.0.1 0.0015277862548828125 6104
91 91 1576529574.845899 GET /favicon.ico 3   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/plain 3 127.0.0.1 0.00019669532775878906 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);
Powered by Datasette · Query took 26.101ms