SQLite Web: archive.db

id	timestamp	session_id	relative_ms	event_type	x	y	delta_x	delta_y	button	click_count	key_code	modifiers	text_content	text_length	app_name	app_pid	window_title	browser_url	element_role	element_name	element_value	element_description	element_automation_id	element_bounds	frame_id	sync_id	machine_id	synced_at
48507	2026-04-16T14:18:41.381977+00:00	9b7c5415-eda0-4db6-9d45-49e7670207bb	5346759	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXTextArea		SELECT * FROM "frames" WHERE timestamp > ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
48544	2026-04-16T14:21:46.671883+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	89	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	AXTextArea	shell	2026-04-16T16:54:32.724028Z INFO screenpipe_engin ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
48548	2026-04-16T14:22:14.330099+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	27747	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Slack	5	Slack	3113	`NULL`	`NULL`	AXTextArea			`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
48552	2026-04-16T14:22:22.977927+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	36395	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	AXTextArea	shell	2026-04-16T16:54:32.724028Z INFO screenpipe_engin ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
50666	2026-04-16T15:18:27.371842+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	3400770	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXTextArea		SELECT * FROM "frames" WHERE timestamp > ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
50843	2026-04-16T15:29:14.509564+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4047907	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		I have a SQLite database, and I would like to crea ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
50851	2026-04-16T15:32:45.715194+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4259112	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXTextArea		SELECT * FROM "frames" WHERE timestamp > ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
50886	2026-04-16T15:34:30.266808+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4363663	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		Reply...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
50935	2026-04-16T15:38:42.753242+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4616151	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	AXTextArea	shell	Last login: Thu Apr 16 15:48:37 on ttys010 Poetry ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
50987	2026-04-16T15:42:35.172286+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4848570	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		Reply...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
50990	2026-04-16T15:42:38.381344+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4851779	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
50998	2026-04-16T15:42:50.859184+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4864257	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXButton		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51001	2026-04-16T15:42:52.161328+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4865559	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51018	2026-04-16T15:43:13.900955+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4887299	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXButton		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51021	2026-04-16T15:43:25.927143+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4899325	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51090	2026-04-16T15:43:40.623506+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	4914021	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		Reply...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51097	2026-04-16T15:46:10.970588+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5064368	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51112	2026-04-16T15:46:56.146995+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5109544	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXGroup		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51122	2026-04-16T15:48:43.511853+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5216909	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXWebArea		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51126	2026-04-16T15:48:55.518180+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5228915	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		Reply...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51129	2026-04-16T15:49:08.135301+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5241533	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXWebArea		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51136	2026-04-16T15:49:35.674812+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5269072	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXGroup		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51138	2026-04-16T15:49:51.601674+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5284999	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXLink	...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51144	2026-04-16T15:50:10.270710+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5303668	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXGroup		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51146	2026-04-16T15:50:21.360943+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5314758	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXWebArea		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51166	2026-04-16T15:51:23.973334+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5377370	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXGroup		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51169	2026-04-16T15:51:42.688788+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5396086	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXWebArea		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51174	2026-04-16T15:51:51.150117+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5404547	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		Reply...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51195	2026-04-16T15:52:40.024081+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5453421	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXWebArea		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51200	2026-04-16T15:52:46.093704+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5459491	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		Reply...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51219	2026-04-16T15:53:07.191956+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5480589	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51225	2026-04-16T15:53:10.942242+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5484339	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXGroup		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51232	2026-04-16T15:53:13.570538+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5486967	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51238	2026-04-16T15:53:27.043420+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5500440	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXGroup		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51245	2026-04-16T15:53:41.859241+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5515256	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51254	2026-04-16T15:53:46.811849+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5520209	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		lets ignore audio for now as it is disabled.	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51261	2026-04-16T15:55:19.590440+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5612987	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXWebArea		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51264	2026-04-16T15:55:24.797356+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5618194	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXGroup		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51293	2026-04-16T15:56:33.479027+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5686876	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51307	2026-04-16T15:56:48.148322+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5701545	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXButton		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51332	2026-04-16T15:59:50.942468+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5884363	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXWebArea		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51340	2026-04-16T16:00:13.224852+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5906646	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		Reply...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51342	2026-04-16T16:00:19.168655+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5912590	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXTextArea		SELECT * FROM "elements_fts" WHERE	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51344	2026-04-16T16:00:20.527019+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5913948	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		Reply...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51361	2026-04-16T16:00:50.922323+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5944344	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXTextArea		SELECT * FROM "elements_fts" WHERE	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51363	2026-04-16T16:00:52.990973+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5946412	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		ok so how does fts work and do I need to it search ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51365	2026-04-16T16:00:55.545887+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5948967	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Firefox	7	Firefox	2110	`NULL`	`NULL`	AXTextArea		SELECT * FROM "elements_fts" WHERE	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51367	2026-04-16T16:00:56.424501+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	5949846	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXTextArea		ok so how does fts work and do I need to it search ...	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51391	2026-04-16T16:03:04.571424+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	6077993	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	iTerm2	6	iTerm2	3199	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`
51399	2026-04-16T16:03:13.857675+00:00	12814e35-58e9-47de-8b51-d97fb023ee4a	6087279	app_switch	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	Claude	6	Claude	2336	`NULL`	`NULL`	AXButton		`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`	`NULL`