requests

11 rows where path = 2 and user_agent = 3

View and edit SQL

Link rowid start method path query_string user_agent referer accept_language http_status content_type client_ip duration body_size
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
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
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
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
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
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
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
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
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
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
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

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.777ms