One Crown Data - L0 Crime Tables

The document shows the L0 tables from the Parquet files in Azure Synapse, showing only the first five rows.

This provides a useful overview of the data within the tables.

1. L0_CPP_stgCPPOffenceTerminalEntry

terminal_entry_id	offence_result_id	offence_terminal_entry_index	value	last_modified_ts	source_system_type_code
00242d19-9e76-4a4f-9d1b-0110307d0ce7	335c91ca-1514-4856-ba15-d8faf85a849c	6	lump sum within 14 days	2023-10-19 14:20:11	CPP
002dcccc-034a-4853-99ff-a5f4e312f046	55de259c-8e38-4471-87f4-f8733e6b44ec	4	Pay directly to court	2023-10-10 13:34:06	CPP
005e0dc3-3558-4f4b-8033-bad81377631d	4def13d6-8257-4f18-80c4-bd46e066d84a	15	293	2023-10-12 09:50:03	CPP
00e693d7-44f2-45d1-b36a-8ec0a9e75f52	829667ce-4016-4d13-9b46-e0cec08ac4c9	1	220	2023-10-20 11:49:31	CPP
01c4ad2b-b84b-4d35-a6d1-a0399fdc4382	7a047476-faf5-4170-8f71-6400f612fb11	4	Pay directly to court	2023-10-19 11:25:31	CPP

2. L0_CPP_stgCPPNonStandardIndependantProsecutor

id	authority_code	first_name	middle_name	last_name	address_line_1	address_line_2	address_line_3	address_line_4	address_line_5	address_line_1_welsh	address_line_2_welsh	address_line_3_welsh	address_line_4_welsh	address_line_5_welsh	post_code	home_telephone_number	work_telephone_number	mobile_phone_number	fax_number	email_address_primary	email_address_secondary	last_modified_ts	last_updated_ts	source_system_type_code
0abae9b6-57b5-376c-b104-6e28b069a0ac	CPS-EENS	NA	NA	NA	Carmelite House	St James’ Court	Whitefriars	Norwich	Norfolk	NA	NA	NA	NA	NA	NR3 1SL	NA	NA	NA	NA	NA	NA	2025-02-03 13:04:39	2025-02-03 13:04:39	CPP
0d19b46d-d245-3c37-a3a9-5a07c020bebb	WMIDPF	NA	NA	NA	West Midlands Police	Lloyd House	Colmore Circus, Queensway	Birmingham	NA	NA	NA	NA	NA	NA	B4 6NQ	NA	NA	NA	NA	WMP_CrownCourtAlerts@west-midlands.police.uk	NA	2025-02-01 15:10:44	2025-02-01 15:10:44	CPP
108763b2-fca2-37f1-bb58-785514e4e6ad	CPS-LN	NA	NA	NA	CPS	1st Floor	102 Petty France	London	NA	NA	NA	NA	NA	NA	SW1H 9EA	NA	NA	NA	NA	NA	NA	2025-01-31 18:04:29	2025-01-31 18:04:29	CPP
1675cad3-894c-32f1-8ced-a97c795155b5	SSXPF	NA	NA	NA	Shoreham Police Station	Ham Road	Shoreham-by-Sea	NA	NA	NA	NA	NA	NA	NA	BN43 6PA	NA	NA	NA	NA	CJU.Sussex@sussex.police.uk	NA	2025-02-03 09:06:41	2025-02-03 09:06:41	CPP
19e282b6-7c51-38a9-89f6-22fc1507627f	GMPF	NA	NA	NA	Greater Manchester Police Force HQ	Central Park	4 Northampton Road	Newton Heath	Manchester	NA	NA	NA	NA	NA	M40 5BR	NA	NA	NA	NA	CCCPNotifications@gmp.police.uk	NA	2025-02-03 17:27:38	2025-02-03 17:27:38	CPP

3. L0_CPP_stgCPPDefendantLanguageNeed

id	case_id	defendant_id	current_language	previous_language	last_modified_ts	last_updated_ts	need_type	source_system_type_code
0b0729c6-29c3-4c9c-afa4-8ee5cc4029a3	5495af57-2fb4-48de-b650-9c64f1ec54f1	bb821336-9b31-4d85-81f8-f23edeb75a9a	ENGLISH	NA	2024-10-25 12:30:55	2024-10-25 12:30:55	DOCUMENTATION	CPP
0dd649ae-4daa-4987-b490-0023a80ab67f	a8f20997-fb85-4498-84f6-08d9880a5d26	a4add8ab-054b-4d7f-915f-7eb3a988503b	ENGLISH	NA	2024-10-28 09:51:55	2024-10-28 09:51:55	DOCUMENTATION	CPP
10994c40-8e92-4a7e-bc69-21712484c898	625fe35b-834d-4ba9-8471-d52c2af66e1f	ee1c7642-fc2c-4a67-a7a0-6d2d3c872839	ENGLISH	NA	2024-10-25 08:37:15	2024-10-25 08:37:15	HEARING	CPP
13be627c-a433-4f05-b32a-0d71d4ae9f5b	b8b7ce32-15b0-4e6b-bf00-6b3b3622e96e	670b4908-5740-473c-8180-50575fce37e4	ENGLISH	NA	2024-10-25 09:32:20	2024-10-25 09:32:20	HEARING	CPP
1578932d-d022-4e92-9d2c-176191400e14	ae8c8cea-6197-44aa-8872-7f6d6931c7ad	222f8104-0fa9-40b9-8f7e-e91ee29b6343	ENGLISH	NA	2024-10-27 10:36:50	2024-10-27 10:36:51	DOCUMENTATION	CPP

4. L0_CPP_stgCPPApplicationCaseOffence

id	application_id	case_id	offence_id	source_system_type_code
3d2c5881-f68c-457f-8159-020d2c596b6e	212a9c84-aaec-4c0b-b701-39c5f6bcb029	5634512b-b13a-4b88-907c-7c13ea70d42a	e91bbc2d-a2bc-460e-954a-27da97f9450c	CPP
4ac70807-06d0-412f-b71a-fdebf4fb6100	b7d2a0e2-7099-48a9-b37e-1057561e47c1	2d5ea332-8e29-4d46-897f-a8a228cb8dcd	af2593c4-f62a-4701-9f17-99f95c0a888e	CPP
c5b9b316-4018-4a6c-90e2-059d64f1dcd1	2e65f7e1-d8e9-4394-8bf9-37499a3942f7	ef7688a0-599e-4239-a4d9-4b88ad63f103	32b2dc57-08af-43e3-8c8e-3232d00b564e	CPP
f2098727-8bb6-401b-b471-af4014098ff3	754a6ae0-b110-4c4e-940d-2318ec0be518	600ed641-5632-4d0a-a4d4-251d4a3f59c6	e8d9c1cb-4f3a-4116-bc3a-f720b4c0e2e6	CPP
0252b907-13d3-4393-b4bb-d56174a5c85a	c85964f9-ad55-459b-9d80-5cb4215181b1	f8ff18aa-28ef-4e47-b8cf-f18320bbbdb5	856ce452-fe8e-4643-93d8-f2bd2c13f57f	CPP

5. L0_CPP_stgCPPDefendantDefenceAssociation

id	defendant_id	organisation_id	organisation_name	user_id	representation_type	laa_contract_number	start_date	end_date	legal_aid_status	last_modified_ts	last_updated_ts	source_system_type_code
00074a30-446d-41eb-9141-39279a20b105	be47271f-8c20-46ff-be6e-d491eeb852fa	c3f787f1-c342-4f48-ab66-84c4781916ad	Teesside Law Limited	082c6822-1dc7-44c2-a875-ea93f883b4e9	REPRESENTATION_ORDER_APPLIED_FOR	NA	2025-02-03 14:55:59	NA	NA	2025-02-03 14:55:59	2025-02-03 14:55:59	CPP
000d9ddf-d56c-47af-886c-55d02055e963	1ad0229e-5d1b-43cd-b843-73d202036c44	866c1b19-9474-4bd9-8693-b3a460c4fb01	Smith Partnership	7ef2323b-2dc2-4be2-be66-c7ab4c0e0089	REPRESENTATION_ORDER	0U563Q	2025-01-31 11:46:24	NA	Granted	2025-01-31 11:46:30	2025-01-31 11:46:30	CPP
00116a03-4262-48f7-a62a-7de473590dac	0011d3ec-3bbe-4e5d-b4a4-3f7a4238f82b	785dc0f8-78da-45f9-bd46-6f96a3de8b0b	Bond Joseph Solicitors	ecddfd10-bff8-44a9-8860-db3d643dbe84	REPRESENTATION_ORDER_APPLIED_FOR	NA	2025-01-31 14:17:40	NA	NA	2025-01-31 14:17:40	2025-01-31 14:17:40	CPP
001b3c59-b08c-42ca-85c3-1f2c640dc271	db390d60-a93d-4668-bde6-88b1ca411c8f	825086ae-3b85-44be-a398-47e759175730	Hine Solicitors	7ef2323b-2dc2-4be2-be66-c7ab4c0e0089	REPRESENTATION_ORDER	2M107Y	2025-01-31 10:59:02	NA	Granted	2025-01-31 10:59:02	2025-01-31 10:59:02	CPP
0040fbbc-cfde-4cdf-b66a-ce595497932a	7664d57a-134f-41cd-8690-178e790275a2	aaaf75f5-7542-4aa5-8ec9-112a0b42d1c1	Reeds Solicitors	7ef2323b-2dc2-4be2-be66-c7ab4c0e0089	REPRESENTATION_ORDER	2M847C	2025-01-31 07:31:34	NA	Granted	2025-01-31 07:31:37	2025-01-31 07:31:37	CPP

6. L0_CPP_stgCPPFinancialMeans

id	defendant_id	income_amount	income_frequency	benefit_claimed	benefit_type	deduct_penalty_preference	upd_by_online_plea	last_modified_ts	last_updated_ts	source_system_type_code
0b333fcc-61ab-4e6f-a9fe-22888beac4e5	a329cc3d-c70f-47a2-b8ce-c7a9b6f24b23	NA	WEEKLY	NA	NA	NA	false	2021-12-06 16:11:51	2021-12-06 16:11:52	CPP
0f3e30b1-f7e5-40d1-a790-8e6bac7b4562	06894032-52b1-4a86-a4f2-d2ace9c4ca9c	400	MONTHLY	false	NA	NA	true	2021-12-11 13:57:30	2021-12-11 13:57:31	CPP
1df4bdb1-d43a-40db-bea1-592b9886e699	7c505fb0-31a7-45df-a9e3-587bbe6a59fd	240	MONTHLY	true	Universal credit	true	true	2021-12-25 19:13:40	2021-12-25 19:13:41	CPP
337f3276-e028-4ae4-b986-e688f8eefec3	b8b5eb32-be4b-4225-b909-2ad502acf124	350	WEEKLY	false	NA	NA	true	2021-12-07 12:47:50	2021-12-07 12:47:52	CPP
344eebaa-c54d-465a-911f-43486b8f152e	e204676d-9e51-404a-9d9a-4a1e883f6ad3	527	MONTHLY	true	Universal credit	true	true	2021-12-22 12:50:18	2021-12-22 12:50:18	CPP

7. L0_CPP_stgCPPSJPDecision

id	decision_id	session_id	case_id	last_modified_ts	saved_date_time	offence_decision_id	offence_decision_type	withdrawl_reason_id	adjournment_reason	adjourned_to	referral_reason_id	estimated_hearing_duration	listing_notes	welsh_hearing	interpreter_needed	interpreter_language	discharge_type	discharge_for_value	discharge_for_unit	fine	compensation	no_compensation_reason	guilty_plea_accounted	offence_detail_id	verdict	back_duty	excise_penalty	last_updated_ts	licence_endorsed	conviction_date	penalty_points_imposed	penalty_points_reason	additional_points_reason	disqualification	disqualification_type	disqualification_for_value	disqualification_for_unit	notional_penalty_points	source_system_type_code
0016f4f9-07ce-4a84-8740-55bf8edee423	94dc5388-59da-4e93-9f4d-af68bb4f2fb4	bd40d2c7-8d38-4896-b7fb-430cd702ada7	d2e465dc-75ea-4dfa-92ef-0e424b29ea87	2021-11-23 07:16:49	2021-11-23 07:16:48	46fd32c9-7eb0-4644-be35-ef93bdb8b973	WITHDRAW	93c6b978-4cad-31f0-a6d9-59cfd71c324a	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	7eabad9c-281c-4ce4-b686-720c0a5089c9	NO_VERDICT	NA	NA	2021-11-23 07:16:50	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	CPP
0025cc11-62be-4a3f-ab0d-f84e56a09084	f2393bd5-3f4e-4309-80b0-fca9061cf048	3a1aeeed-7702-47b7-b53f-5e7d7db74990	ae852fa0-b801-4e0b-a802-1414fe6a77fd	2023-01-24 10:38:27	2023-01-24 10:38:27	80161e54-a90c-43cf-9192-e4f4b6f2780a	FINANCIAL_PENALTY	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0	NA	true	1ef58f4e-0c51-43f4-8fbb-387f1bf75797	FOUND_GUILTY	10.00	293	2023-01-24 10:38:27	NA	2023-01-24	NA	NA	NA	NA	NA	NA	NA	NA	CPP
0027e23d-60e6-4072-ab0c-515736e3da7b	69f81b22-a77b-4a03-97e4-8c423a3fcd3d	d16ed028-89e0-4a5b-bcf6-19c4c9ce30b9	fa81dbc3-50d7-43f5-ae87-19e011c4bf2d	2024-11-27 11:24:42	2024-11-27 11:24:42	22a0d248-d484-4809-afa8-035036bff0c5	FINANCIAL_PENALTY	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0	NA	false	0f31bf89-8533-4d15-b42a-aa346f8e9548	PROVED_SJP	548.75	660	2024-11-27 11:24:42	NA	2024-11-27	NA	NA	NA	NA	NA	NA	NA	NA	CPP
002e962b-2447-4b41-987d-8e7ea759531d	559e83f3-1932-4d79-8195-1d4c3d2b3a3c	8b4b92c3-06ae-4c70-9e5c-312c91c394cc	e147d9a0-3c43-45a2-aea4-7822009d5ad4	2023-03-01 14:49:38	2023-03-01 14:49:37	62161fcb-cebd-42bf-8ec4-07bb3aa98227	FINANCIAL_PENALTY	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	220	0	NA	false	d71dc625-ba8d-4ac7-b299-f176e98e9fad	PROVED_SJP	NA	NA	2023-03-01 14:49:38	NA	2023-03-01	NA	NA	NA	NA	NA	NA	NA	NA	CPP
0033ed95-b019-4c19-81ac-5f4b851ba5bd	099526c0-332c-41c8-8b98-3f4252062dd1	4a5f9271-99cb-4530-94e4-c6ecb38e42cd	f8884fc1-d9a7-4356-9f6c-a4761622ae11	2024-04-22 10:39:30	2024-04-22 10:39:29	64d289ca-78e2-40a7-b199-c28319af1c0a	FINANCIAL_PENALTY	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0	NA	false	e07c89a9-2b6a-416c-aa27-6507dd59e8ef	PROVED_SJP	37.50	220	2024-04-22 10:39:30	NA	2024-04-22	NA	NA	NA	NA	NA	NA	NA	NA	CPP

8. L0_CPP_stgCPPHearingCaseApplication

id	case_id	application_id	hearing_id	last_updated_ts	last_modified_ts	ejected_flag	ejected_date	duplicate_flag	deleted_flag	source_system_type_code
00014ce0-5a91-465e-b4af-26ebbe474323	4aeec6fb-36e5-4b2a-9683-76ba43586e68	NA	00022d4f-92a7-47c2-ae56-e7178e00d2fc	2022-08-03 12:27:36	2022-08-03 12:27:36	NA	NA	NA	NA	CPP
0001d7b5-76bb-4e66-ab82-cccd5e9972c9	244d1a2f-4e40-4a22-b887-48fdf74ef375	NA	6b8296ba-8024-4a41-949e-9581dd6d655c	2023-10-13 11:52:34	2023-10-13 11:52:34	NA	NA	NA	NA	CPP
000987b4-05ce-467f-8d15-a4016e1ff95c	c3ff6878-41f1-4cdd-a4fb-237a148a61dc	NA	4e260f82-d688-44ee-8971-dca25eee2c0b	2024-08-16 14:12:05	2024-08-16 14:12:04	NA	NA	NA	NA	CPP
000d4364-5d85-4790-ac1f-e9e2a0aa02b2	ca6d40b0-a624-44a2-9434-0dc8b7b9f7ca	NA	5e739f52-402a-450a-84f8-737d14d4ef4f	2024-11-14 16:03:48	2024-11-14 16:03:48	NA	NA	NA	NA	CPP
001508ea-eefc-4565-9383-3cd8a816dd10	45f1042e-5c5f-4a19-af2c-5ed26ef828b8	NA	0478e021-5fc4-4737-a35a-8e4c1d4ea898	2024-02-27 14:56:39	2024-02-27 14:56:39	NA	NA	NA	NA	CPP

9. L0_CPP_stgCPPCourtSessionDetail

id	court_session_id	session_period	start_time	end_time	court_clerk_id	court_associate_id	legal_adviser_id	last_modified_ts	last_updated_ts	source_system_type_code
02bac1ac-85cc-40e9-9730-2abbb014597f	f8f40c5c-45f1-3aa4-8501-aec49d81aa8f	PM	14:00	15:30	NA	NA	e38018f6-46ff-4c0a-9971-db1265baed35	2022-09-27 09:22:05	2022-09-27 09:22:05	CPP
03ccb575-7df6-47f8-910a-a10e8eca0aa0	9f60ffe7-104e-3f62-ae63-c2c0b1d0a366	AM	NA	NA	b8d3e529-e141-4703-a727-fbd84a092a16	NA	NA	2022-10-20 08:14:36	2022-10-20 08:14:36	CPP
076f5747-0538-4024-a009-14e017a9a7a3	9ce82905-6e38-3932-9c70-a4a9445f8ba2	PM	NA	NA	NA	NA	b691e402-ce90-44e0-b0ff-b0367fc36f98	2022-10-05 15:26:36	2022-10-05 15:26:36	CPP
0d6d11b2-ba47-4f83-8cff-da485f013c9c	2ee3801b-6b3f-3e6e-873b-bb44d6e9ce63	AM	10:00	13:15	NA	NA	f32200e4-8948-4a28-b35a-95aa5c7457ee	2022-09-28 15:18:30	2022-09-28 15:18:30	CPP
0e57312f-1562-4e85-bcaf-ec9b46b446c9	119023dc-c5fe-3e1a-8339-d1cedc364752	AM	NA	NA	c94a11f5-01f2-405d-b5de-3debe7d58273	NA	NA	2022-10-12 07:49:20	2022-10-12 07:49:20	CPP

10. L0_CPP_stgCPPApplication

id	application_type_id	application_type_code	application_type	received_date	ref_num	parent_application_id	fee_paid_flag	fee_undertaking_attached_flag	fee_exempt_flag	payment_reference	decision_sought_by_date	application_status	out_of_time_reasons	removal_reason	last_modified_ts	ejected_flag	ejected_date	rejected_flag	rejected_date	rejected_reason	last_updated_ts	allegation_complaint_start_date	allegation_complaint_end_date	defendant_asn	summons_supplied	commissioner_of_oath	due_date	application_particulars	source_system_type_code
0021b635-0956-4782-b456-a8e14bd00493	31ba0827-18cb-369e-afdd-fb4cf4119346	PC00509	Further offence committed during youth offender panel referral period	2024-06-11	42MR1654124	NA	NA	NA	NA	NA	NA	FINALISED	NA	NA	2024-06-11 15:53:37	NA	NA	NA	NA	NA	2024-06-11 15:53:37	NA	NA	NA	NA	NA	NA	NA	CPP
004010b6-9c80-4da3-acbf-5155ca6c77e1	4e281610-96aa-3711-aecf-59df86b6c6bb	AP00501	Application within criminal proceedings	2024-06-27	20SW1305824	NA	NA	NA	NA	NA	NA	FINALISED	NA	NA	2024-06-27 14:49:02	NA	NA	NA	NA	NA	2024-06-27 14:49:02	NA	NA	NA	NA	false	NA	Application to adjourn case	CPP
00496014-bc88-45c9-ab94-d76c8f44d6c0	26c7e337-5697-3448-9b9b-f71a6a6e6b1f	BA76504	Application to vary conditions of bail	2024-06-12	10U40055224	NA	NA	NA	NA	NA	NA	FINALISED	NA	NA	2024-06-14 10:05:33	NA	NA	NA	NA	NA	2024-06-14 10:05:33	NA	NA	NA	NA	false	NA	NA	CPP
004a2ac4-5f32-49d2-a91b-332f56d1aa75	0a4937f3-20ce-380f-adf8-3f21c4719ffd	BA76511	Application for bail following committal/sending/transfer in custody to appear at Crown Court	2024-06-25	63CH0074124	NA	NA	NA	NA	NA	NA	LISTED	NA	NA	2024-06-25 09:39:21	NA	NA	NA	NA	NA	2024-06-25 09:39:22	NA	NA	NA	NA	false	NA	Bail app uploaded on 24.6.24 but not sent to CPS until 25.6.24.	CPP
00780389-178b-48b2-ab41-e64d78011b96	74b72f6f-414a-3464-a4a2-d91397b4c439	LA12505	Application for transfer of legal aid	2024-06-18	62WN0379424	NA	NA	NA	NA	NA	NA	FINALISED	NA	NA	2024-06-18 14:45:00	NA	NA	NA	NA	NA	2024-06-18 14:45:00	NA	NA	NA	NA	false	NA	Transfer legal Aid MAAT number 7914345 to Davies and Davies Solicitors	CPP

11. L0_CPP_stgCPPCourtSessionJudiciary

id	session_detail_id	judiciary_id	judiciary_name	is_bench_chairman	last_modified_ts	last_updated_ts	source_system_type_code
176809d7-6ba3-4aff-935c-72c5bf75d411	d8efb291-71b6-477a-927f-3dc31cd85d04	1d903502-3840-3685-8357-4d7e6a6aaf9d	NA	false	2021-11-01 16:29:34	2021-11-01 16:29:34	CPP
2507fa44-a895-4905-8f1c-9cc091eaa29c	dc7fa37d-2467-4864-9c50-fced194cdb88	ec400b87-1f77-3b88-b32c-c4e4f81752f6	NA	true	2021-11-01 14:50:50	2021-11-01 14:50:50	CPP
2cf2a57c-5df2-4be1-8c02-3b3249f23e05	bd9dfa33-15d6-4ae2-ac1f-28c6bb070714	ba28c7f6-2e09-3b90-b830-52c29844fcf8	NA	true	2021-11-19 15:03:43	2021-11-19 15:03:44	CPP
365356a0-2593-40fa-b6c4-f19915dbdccf	9141914d-1be3-4c56-9716-585f53804b3b	78eb6d78-e6bc-34e5-aea4-776ac7189718	NA	false	2021-11-12 08:25:29	2021-11-12 08:25:30	CPP
489a6f14-1562-49dc-8525-59c7e41bf315	c1a80d14-1cc4-4354-a478-778610d58b85	ce43799c-e397-43c6-8b0b-d036d268f096	NA	false	2021-11-18 23:26:40	2021-11-18 23:26:41	CPP

12. L0_CPP_stgCPPHearingResult

id	target_id	hearing_id	defendant_id	offence_detail_id	result_line_id	result_definition_id	result_label	result_level	ordered_date	shared_date	last_modified_ts	delegated_powers_user_id	delegated_powers_first_name	delegated_powers_last_name	amendment_date	amendment_reason_id	amendment_reason	deleted_flag	last_updated_ts	case_id	application_id	spi_out_flag	spi_out_ts	source_system_type_code
00000c210c43412f8fa995b101b8128d	6f4356d0cdde11eb924c49f0eb3d82bd	5ea5b74b614a4c1696bdac1d45aa03e7	49c82acc315c4783acd35c169fcb3818	12814cc3054c4f78a616844fa45f8ac0	00000c210c43412f8fa995b101b8128d	923f8b82d4b54c9b8b546d1ec8e16dd6	Account Consolidated	DEFENDANT	2021-06-15	2021-06-15	2021-06-15 14:12:03	NA	NA	NA	NA	NA	NA	FALSE	2021-06-15 14:12:04	aa8eef8d72ac4e79a92bcac5c8184f92	NA	TRUE	2021-06-15 14:12:03	CPP
0000381b-5ed4-40fe-bb09-36d7069b6501	d6ba69d2-6bc7-42c8-a332-ab1da4c79778	544a7f1d-17c1-459c-8006-247c97e44115	a9a998f4-5ecd-4ee4-8d1d-cf4fb940fa19	d6ba69d2-6bc7-42c8-a332-ab1da4c79778	0000381b-5ed4-40fe-bb09-36d7069b6501	8cf3b54b-bec8-4bcf-aac4-62561dcc8080	Bail conditions	OFFENCE	2024-08-17	2024-08-17	2024-08-17 10:52:09	NA	NA	NA	NA	NA	NA	false	2024-08-17 10:52:09	1582bca1-d37f-4d1e-9fac-fbce4961f1f1	NA	true	2024-08-17 10:52:09	CPP
0000842e-9016-4628-941f-66a95cbcb416	f7235be2-62d2-44db-94e7-6a7f60ff257f	734a32d1-8208-490e-b0cc-1af8a30557e5	c80c3f32-ef1a-4222-8fdd-14ec9be9d6ac	f7235be2-62d2-44db-94e7-6a7f60ff257f	0000842e-9016-4628-941f-66a95cbcb416	c3a39c2f-b056-442f-8dfc-604b5434f956	0: None or unknown	OFFENCE	2025-01-06	2025-01-06	2025-01-06 17:01:35	NA	NA	NA	NA	NA	NA	false	2025-01-06 17:01:35	19e7b6a4-3461-40c5-9477-d15a54be3472	NA	true	2025-01-06 17:01:35	CPP
0000a837-709d-406e-86e2-6372ff1f77dd	85d5d050-5813-4502-8d5a-1980b386b214	6d2ff1a9-8713-4f7c-b908-6416892ac2b1	c919e89d-7396-40d7-8ac2-dc4057345785	85d5d050-5813-4502-8d5a-1980b386b214	0000a837-709d-406e-86e2-6372ff1f77dd	2852b770-a7ad-11e8-98d0-529269fb1459	Forfeiture and destruction	OFFENCE	2024-07-16	2024-07-16	2024-07-16 10:38:46	NA	NA	NA	NA	NA	NA	false	2024-07-16 10:38:47	476cae71-61f0-4b21-9ead-80206746b545	NA	true	2024-07-16 10:38:46	CPP
0000c43a-4b6e-4bbf-aabc-4bc446cc2b40	0cd7b8ce-1f26-4e46-b130-7b839df807dd	bbc29d75-93b2-479f-b068-018fbed3b911	9d0568aa-3286-42e5-9b27-16882401f0ec	0cd7b8ce-1f26-4e46-b130-7b839df807dd	0000c43a-4b6e-4bbf-aabc-4bc446cc2b40	f00359b5-7303-403b-b59e-0b1a1daa89bc	Next hearing	OFFENCE	2023-04-20	2023-04-20	2023-04-20 10:28:22	NA	NA	NA	NA	NA	NA	false	2023-04-20 10:28:22	d37c9fbe-0d45-427b-b7ef-80a491156087	NA	NA	NA	CPP

13. L0_CPP_stgCPPHearingDefendantOffence

id	hearing_id	case_id	defendant_id	offence_id	last_modified_ts	last_updated_ts	youth_court_id	deleted_flag	source_system_type_code
00050112-a157-4614-86ad-c3909069e828	c3b6c1e7-3d9b-4aa6-8440-ded471cfee7a	e0a2b551-6975-4278-a155-c031c58ec55b	a5404c22-0284-4eab-b2c5-3823055f3f44	355069dd-f9bb-48ef-97c4-0145c0a580da	2025-02-03 11:36:28	2025-02-03 11:36:29	NA	NA	CPP
00066307-fdaa-40cd-a972-603ef704a113	2b0e3823-0b30-48ca-8f5d-50f64f6d6d56	463ff91b-a33e-4b72-bc69-e155f48ba75a	b445d4a4-0fdf-40a9-be52-019ab8f1e427	901b9faf-d65a-4429-a596-d5e2e3a7f640	2025-02-03 09:03:22	2025-02-03 09:03:22	NA	NA	CPP
0006cb36-e431-4ca6-899e-463da0575691	f48613a6-1a0d-4b96-8dae-8d86212bf638	9e72c553-d1d8-420b-b1b8-8ec83268a0cf	84fe4af3-d675-4095-b4a4-66c8acdfaf59	2feccae9-a5aa-4877-bb52-b3dc8bce3da6	2025-02-03 14:09:12	2025-02-03 14:09:12	NA	NA	CPP
0009e7f4-791d-4fc8-b2e0-faf40b9f8467	b2ec2cc3-eb08-44a3-8bea-a963506e7ccd	ace14c60-c51b-4bfe-b33c-1fdfab75ba66	9a732770-9a5e-4255-afc6-2e77f21d4437	b3c748af-d88c-4803-8ed4-3fba059699d6	2025-02-03 15:08:20	2025-02-03 15:08:20	NA	NA	CPP
001346dd-585f-49d1-bb59-b84d5a7c9028	de80ddd5-9c86-46b3-bc57-d918a0f55532	4dc05433-638a-40df-b102-b86b908337ec	92ad4293-9114-4b8a-a426-d1845ef6b954	648ea2da-6f30-482e-95f3-14640ca6c80b	2025-01-31 10:22:59	2025-01-31 10:22:59	NA	NA	CPP

14. L0_CPP_stgCPPCaseSoc

id	case_id	checked_by_id	checked_ts	last_modified_ts	last_updated_ts	source_system_type_code
4c491d4c-2700-42a9-b8e0-9810639e6a00	a30c645f-c76f-4fa1-a2ba-6cd69bd5f768	46eac71b-bc56-4d5a-813a-1f6bd7815fe5	2024-10-01 09:04:00	2024-10-01 09:04:00	2024-10-01 09:04:00	CPP
06903fbf-ed3f-40fc-a662-e54575a01694	0e306ab1-3a4f-4793-9aea-a4751aff73a8	46eac71b-bc56-4d5a-813a-1f6bd7815fe5	2024-10-01 08:57:39	2024-10-01 08:57:39	2024-10-01 08:57:39	CPP
e89451ed-5362-4e0e-bc3b-db137b5264b8	ef3a97c0-37b4-4965-88da-9da86ee8db19	46eac71b-bc56-4d5a-813a-1f6bd7815fe5	2024-10-01 08:54:41	2024-10-01 08:54:41	2024-10-01 08:54:41	CPP
d090d122-c99c-4c27-8323-255d504f487d	7a9f3a18-55fc-439f-846c-8b0be438d2f4	46eac71b-bc56-4d5a-813a-1f6bd7815fe5	2024-10-01 08:55:43	2024-10-01 08:55:43	2024-10-01 08:55:43	CPP
75aa55e1-ebf8-4891-84c6-8eb05e918877	51d13fb7-2ddb-459c-96f8-7cc6499077da	46eac71b-bc56-4d5a-813a-1f6bd7815fe5	2024-10-01 08:58:08	2024-10-01 08:58:08	2024-10-01 08:58:08	CPP

15. L0_CPP_stgCPPFinancialImposition

id	decision_id	case_id	costs	reason_for_no_cost	victim_surcharge	reason_for_no_surcharge	collection_order_made	total_sum	fine_transfer_to_court_code	fine_transfer_to_court_name	payment_type	not_attached_deducted_reason	deduct_from_benefits_reason	payment_reserved_terms	lumpsum_amount	lumpsum_within_days	lumpsum_payby_date	installment_amount	installment_start_date	installment_period	last_modified_ts	source_system_type_code
0011d773-9d79-4cad-aa63-6a5136bce2c9	c2e2809e-b877-428f-ab98-cd93b41f7ff5	b91e7804-a961-4a38-b5ed-7eecfcb63500	50	NA	60	NA	true	261.75	2577	South West London Magistrates’ Court	PAY_TO_COURT	No information from defendant	NA	false	NA	NA	NA	20	2024-11-10	MONTHLY	2024-10-10 14:19:48	CPP
0016f245-bd39-4b1d-87cc-628383e136ad	b32b2f0f-510b-4df9-ac17-835d4a926e4a	ef138259-fbee-4dd1-8608-9f59dd59608f	85	NA	NA	NA	true	313.75	2375	West Yorkshire Magistrates’ Court	PAY_TO_COURT	No information from defendant	NA	false	313.75	28	NA	NA	NA	NA	2024-10-04 10:32:56	CPP
00191746-1a4a-49ae-bdd5-e51ea7d99bad	bcccb23a-ed8d-4d5b-af0c-33e59fbe87b7	f5baf3e3-8b7c-485b-b235-4d8ca91a84cf	85	NA	NA	NA	true	335.00	1960	Central Kent Magistrates’ Court	PAY_TO_COURT	No information from defendant	NA	false	335.00	28	NA	NA	NA	NA	2024-10-10 10:41:27	CPP
001c8d42-643a-485d-85e6-d712f1dbe848	54d00dd3-d1f1-45e3-ada8-b80aadd18504	b64e34f9-3423-4252-aa71-1f7adce604b8	100	NA	88	NA	true	408.00	2577	South West London Magistrates’ Court	PAY_TO_COURT	No information from defendant	NA	false	408.00	28	NA	NA	NA	NA	2024-10-11 15:19:45	CPP
002f861f-81b9-4f9a-8f90-ea1178861c0b	428993d9-48ea-42bc-8b21-2dd03e50bf4e	84c5f478-4ee8-436e-ab02-64a7f2100e2f	85	NA	NA	NA	true	1299.17	2575	South East London Magistrates’ Court	PAY_TO_COURT	No information from defendant	NA	false	100.00	NA	NA	50	2024-11-08	MONTHLY	2024-10-11 14:24:51	CPP

16. L0_CPP_stgCPPCaseNotePinHistory

id	note_id	is_pinned	date_actioned	last_modified_ts	last_updated_ts	source_system_type_code
018e9da9-afe5-43ce-b500-476bf0ee3fee	b07c57a0-5f67-44e3-b56d-ef8e8e9073a3	true	2024-09-27	2024-09-27 15:00:36	2024-09-27 15:00:36	CPP
08edac08-c549-4b68-85ff-964e03bfb763	bce29d9d-0f93-4d88-bcc2-6e26e3c449b6	true	2024-09-27	2024-09-27 13:30:05	2024-09-27 13:30:05	CPP
14bcb98f-d5de-4d58-904f-c4c13e575f2d	77b5a1b0-c99e-48c3-a205-710d1a0edefa	true	2024-09-30	2024-09-30 15:06:35	2024-09-30 15:06:35	CPP
1ef82b02-0957-4c86-b46a-555ac7a41293	f2777424-8ae5-43d4-99b0-0806cc4f0302	false	2024-09-27	2024-09-27 08:48:06	2024-09-27 08:48:06	CPP
27fecf16-aa78-4e10-9e1d-a7634f60c7c6	01927a39-abed-43fe-8e2c-419ff84697f3	false	2024-09-30	2024-09-30 10:47:11	2024-09-30 10:47:11	CPP

17. L0_CPP_stgCPPApplicationPerson

id	person_id	application_id	applicant_synonym	applicant_type	prosecuting_authority_id	last_modified_ts	last_updated_ts	master_defendant_id	summons_required	notification_required	appt_notification_required	organisation_id	source_system_type_code
01f6eb93-db06-4f68-befc-ff07b59aa9c6	cab26646-3df1-4c59-a35d-e20547971cc2	9d4bb99a-8de3-4bad-bd96-60a11c02482a	NA	RESPONDENT_PERSON	NA	2024-09-06 09:39:42	2024-09-06 09:39:42	cab26646-3df1-4c59-a35d-e20547971cc2	false	true	false	NA	CPP
07c19e80-de28-483a-9d5e-7fe928777723	NA	afe7a0f6-eef7-4012-aeec-a5304b66ff80	NA	APPLICANT_PROSECUTOR	d2196b0a-094f-3ad3-82c0-8986c6b8c78b	2024-09-03 09:32:09	2024-09-03 09:32:09	NA	false	true	false	NA	CPP
0a9f1c95-a000-4900-9ea5-c6b8be38072d	NA	07575ec7-f874-4b16-936e-c563b7000593	NA	APPLICANT_PROSECUTOR	0d19b46d-d245-3c37-a3a9-5a07c020bebb	2024-09-05 10:44:09	2024-09-05 10:44:09	NA	false	false	false	NA	CPP
1669eac8-eaa1-4c4b-b145-b96a5c353036	NA	4cf3339f-4d96-4856-ad07-ae0819e89d47	NA	RESPONDENT_PROSECUTOR	7a045bd4-3813-39fa-aaa4-34f824d45b18	2024-09-03 10:27:27	2024-09-03 10:27:28	NA	false	true	false	NA	CPP
1a403e92-1e20-4eeb-ab5b-705699c7ba92	NA	27c8dcee-f4e4-421f-be11-cdd59157a163	NA	APPLICANT_PROSECUTOR	0d19b46d-d245-3c37-a3a9-5a07c020bebb	2024-09-05 11:45:38	2024-09-05 11:45:38	NA	false	false	false	NA	CPP

18. L0_CPP_stgCPPCourtSchedule

id	court_listing_profile_id	oucode	court_room_number	court_house_name	court_room_name	operational_unit	rota_business_type	court_session	session_start	panel	max_slot	max_duration_mins	available_slot	available_duration_mins	active	created_on	updated_on	court_room_id	source_system_type_code
000eed4c-626c-3fed-abc5-0bc97850f8ab	NA	B52MY00	2573	Taunton Magistrates’ Court	Courtroom 01	52	TRL	PM	2025-04-17	ADULT	0	240	0	60	false	2024-05-09 16:09:48	2024-09-02 19:00:39	23d799e0-2655-35a2-a282-7d0c60fb666f	CPP
000f0e48-84b2-38cd-96dc-2134ca73c969	CS3791976	B01CN00	443	Bromley Magistrates’ Court	Courtroom 01	1	REM	AM	2022-11-05	ADULT	0	0	0	0	true	2022-11-04 20:01:05	2022-11-04 20:01:05	2c2bacb7-1c0a-34e4-beb2-79d7f399a197	CPP
001fb539-c381-3949-8e69-2ddf41a9f8f2	CS2475818	B10JQ00	1765	North Shields Magistrates Court	Courtroom 03	10	REM	PM	2020-05-21	ADULT	0	0	0	0	True	2020-06-13 00:00:00	2020-06-13 00:00:00	9c29ce9f-92ed-3ffe-a4c1-fda8d0342113	CPP
001ff52f-6d7c-31fe-8313-20e7fd51d4d3	NA	B06OJ00	2804	Wigan Magistrates’ Court	Courtroom 08	6	TRL	AM	2025-06-17	ADULT	0	0	0	0	true	2024-09-12 19:00:44	2024-09-12 19:00:44	c90b2f8c-12b3-300a-a472-deb2dd75a8c9	CPP
002640cd-c643-35ee-a3ca-74f770fdf8b9	CS3306717	B47CL00	400	Brighton Magistrates’ Court	Courtroom 11	47	VLT	AD	2021-12-27	ADULT	20	0	20	0	true	2021-12-04 20:16:04	2021-12-04 20:16:04	99fb2a76-9790-3e2f-8dd7-39c4eca5b27b	CPP

19. L0_CPP_stgCPPProsecutionAuthorityChange

id	case_id	prev_prosecution_authority_id	curr_prosecution_authority_id	changed_date	last_modified_ts	last_updated_ts	source_system_type_code
00a86cfc-ffc3-4a2a-a86c-bc5f3d96fe88	9078f798-385f-4bee-92ec-acb82fa4d969	8f8024ca-ff7c-3829-a0d2-35d37492aebb	108763b2-fca2-37f1-bb58-785514e4e6ad	2024-08-10 07:40:56	2024-08-10 07:40:56	2024-08-10 07:40:56	CPP
0c7dbdf9-5782-4b4b-a70c-fe0c97cca404	3178f3de-2c65-400b-8fd6-e0902b8198cf	43acdccb-936a-3443-a7d6-280725233dd3	1c2a2913-8908-33fb-8833-0b6198fa9dc2	2024-08-10 06:28:49	2024-08-10 06:28:49	2024-08-10 06:28:49	CPP
1ca1e141-a09c-418c-a466-01db55c904c8	720ab6ec-0ed5-4b4b-bd6d-6b3c2f32bfdd	1675cad3-894c-32f1-8ced-a97c795155b5	3857a67c-b797-3424-ac9f-02bac90ab9d7	2024-08-09 11:42:59	2024-08-09 11:42:59	2024-08-09 11:42:59	CPP
206f5567-6f2d-469c-a60a-842a67249488	d9045310-8b40-4a8c-ba13-f70160d25314	8f8024ca-ff7c-3829-a0d2-35d37492aebb	108763b2-fca2-37f1-bb58-785514e4e6ad	2024-08-09 07:26:12	2024-08-09 07:26:12	2024-08-09 07:26:12	CPP
31efb643-dbee-48cd-9930-1ad0a9808a1b	e480956f-3b09-478a-95bb-f3da7068bde4	263eeafd-5846-3aff-a036-e3e3a9950894	44c25dc4-be90-3071-a989-51e9de4eb4b9	2024-08-09 08:23:45	2024-08-09 08:23:45	2024-08-09 08:23:45	CPP

20. L0_CPP_stgCPPOffenceDecision

offence_decision_id	sjp_session_id	offence_detail_id	cpp_result_id	created_ts	last_modified_ts	optlock	note	case_id	adjourned_at_ts	last_updated_ts	adjourned_to_date	source_system_type_code
0021d16f-7a6f-4302-aaba-3e457a54e510	bb756645-6ccf-42e5-b0d9-f447229b9560	6606e8ec-a9a6-4887-90c0-51fdaa635d30	ccc032c6-a4ee-464c-b0e4-a74ed2c7dbee	2025-01-16 12:54:27	2025-01-16 12:54:28	0	NA	NA	NA	2025-01-16 12:54:29	NA	CPP
002cf482-ee2d-4213-bfe7-89bc0d6597be	25c548e0-2b29-432e-b2b1-03ef353218ab	b02f72c3-e1c8-4c8e-b44b-66ce7a2661c2	d7542128-5636-43ca-9830-189b57d46dff	2019-10-16 14:26:38	2019-10-16 14:26:38	0	NA	NA	NA	2021-03-07 14:22:40	NA	CPP
003542d2-d139-40ea-ac3f-7d6ee7590e43	74017b8c-2b2e-4c21-8331-369b873c19ef	351f9494-fd0b-4053-a04a-c92a6f501515	7e7ab62f-cfa4-4faf-821a-b2ef2f10cdd2	2023-05-19 11:00:41	2023-05-19 11:00:43	0	NA	NA	NA	2023-05-19 11:00:44	NA	CPP
003a6559-dab6-4a4b-87f8-1cba297e37ea	a70260fb-6b1d-48ee-bc6e-12e3e34126fb	827f43e0-0826-4d1d-90e9-fcb09dbba7cc	eef83c5e-47a6-4902-a385-1afc09a67c08	2025-01-22 15:14:52	2025-01-22 15:14:53	0	NA	NA	NA	2025-01-22 15:14:53	NA	CPP
004876b7-ffbb-4b84-8742-ff610776301e	dbf2be52-9a88-4f9f-95d6-13217280ddb7	fd386da4-36a7-4db5-9aa7-7e1059092c41	0a9d0095-85f1-4712-8a06-0d8456305b77	2021-10-01 09:26:21	2022-02-23 16:32:02	0	NA	NA	NA	2022-02-23 16:35:34	NA	CPP

21. L0_CPP_stgCPPHearingEventLog

event_id	hearing_id	event_def_id	record_label	event_time	record_deleted	last_modified_ts	case_id	source_system_type_code
0000b728-aec8-4ff4-842d-83c8e78ad08b	ea4f8a97-3c72-4def-8b60-f226e15e793a	160ecb51-29ee-4954-bbbf-daab18a24fbb	Hearing paused	2024-12-04 12:50:18	false	2024-12-04 12:50:22	2b2723e6-c80b-4b9d-a46c-a3326582bbe2	CPP
0000ce7b-0c9b-4af6-a57f-88594dda68e2	b9a6c1da-64d0-485d-89fc-d80008edbd70	01c827bb-06e6-4b47-8934-38eb081526fa	Judge addresses Advocate	2023-10-09 14:08:38	true	2023-10-09 14:11:59	15259476-7aa9-4ee2-a73f-c5f35a065d42	CPP
000241fe-6f53-428a-8a68-4a21ac83a75a	59f94ff9-46fc-4f81-ba5e-e57ee9c2b1bb	7dac93bb-9686-4027-bd87-5c0205ae18d3	Prosecution addresses Judge	2024-01-26 11:45:37	true	2024-01-26 11:45:38	baec08f2-863c-48d4-a710-671a06d01fdc	CPP
000296e7-5e8b-40f2-a99b-64d04b222791	192b9c9b-d4f3-41bc-a70f-d6da44c7319e	7dac93bb-9686-4027-bd87-5c0205ae18d3	Prosecution addresses Judge	2024-03-12 11:34:43	true	2024-03-12 11:34:47	2fd9154a-d3b5-4040-a960-669fc6ee163a	CPP
0003a6a9-0753-44fc-90d9-c3affe05446d	71faf928-cfa2-4d02-b802-756efcadf54b	f21f3fb7-0610-4025-9662-80919e0afcef	Defence addresses Judge	2023-07-17 14:24:57	false	2023-07-17 14:25:10	564a1810-e5fe-4e32-bfa3-cd53065742d5	CPP

22. L0_CPP_stgCPPScanEnvelope

id	envelope_classfication	zip_file_name	zip_file_created_date	document_extracted_date	last_modified_ts	last_updated_ts	source_system_type_code
01e220cd-c253-4fad-b6f4-f4ffc22d0976	NA	2336591030415_19-12-2023-08-18-17.zip	2023-12-19 08:18:17	2023-12-19 08:22:04	2023-12-19 08:22:04	2023-12-19 08:22:05	CPP
10eab63d-9563-4783-83f6-5854907dc861	NA	2336291030368_18-12-2023-08-34-39.zip	2023-12-18 08:34:39	2023-12-18 08:37:20	2023-12-18 08:37:20	2023-12-18 08:37:21	CPP
16589618-ae55-4fb0-b053-902320f8d2c8	NA	2300991030062_27-12-2023-11-06-56.zip	2023-12-27 11:06:56	2023-12-27 11:09:51	2023-12-27 11:09:52	2023-12-27 11:09:52	CPP
1c0c193f-cca3-4e1d-a248-e61d0e737a82	NA	2300191030060_19-12-2023-09-59-36.zip	2023-12-19 09:59:36	2023-12-19 09:59:57	2023-12-19 09:59:57	2023-12-19 09:59:58	CPP
1c9978b9-b74f-41e3-8ac4-dde636d1a6ee	NA	2200191030082_19-12-2022-15-11-14.zip	2022-12-19 15:11:14	2022-12-19 15:12:13	2022-12-19 15:12:13	2022-12-19 15:12:14	CPP

23. L0_CPP_stgCPPCaseMarker

id	case_id	case_marker_rd_id	last_modified_ts	source_system_type_code
2c18ff65-490a-4135-9015-d765b8976d72	4fa7eb1d-104c-40b6-9d56-9845c0af1bd5	877ea509-85de-440b-b513-b8e2c82fa7ad	2024-12-19 21:17:01	CPP
3d42751e-bcc0-4d1b-96ab-95f0f487b909	125574a1-e8c6-455e-b21a-773df5504e8e	c19ad2d3-74ec-4b6b-92b3-a39a6039b867	2024-12-18 07:52:07	CPP
6a2f53a7-f37d-44b8-9cc9-c3cf3f7d0616	891bbdf8-5aa4-4a4d-ae0c-64f37a3ac628	c19ad2d3-74ec-4b6b-92b3-a39a6039b867	2024-12-22 21:19:46	CPP
717353e6-f038-4e92-8aba-47a0fc80288c	13248d28-fedd-49fc-898b-a8bf0b98e492	877ea509-85de-440b-b513-b8e2c82fa7ad	2024-12-19 14:45:01	CPP
99565e59-7773-46a2-b6e3-29bcfa4feafd	af3c15fa-49d2-481c-bdff-8d687cf0f435	877ea509-85de-440b-b513-b8e2c82fa7ad	2024-12-21 09:22:27	CPP

24. L0_CPP_stgCPPAllocatedListing

id	court_schedule_id	booking_id	hearing_id	oucode	court_room_id	rota_business_type	duration	created_on	updated_on	source_system_type_code
00019a8b-5dfc-46de-acf2-a40b7af8089a	edb59a14-76bf-32fc-b94b-6efa3120f03a	NA	70f50f8b-6b2b-4adc-bc96-cad87c9d5ec4	B05PK00	1428	NA	1	2023-12-11 09:19:35	2023-12-11 09:19:35	CPP
000559c7-210e-4b90-be21-f07e193a4787	75d1ba0b-2cfb-3999-b295-277b78f2cc18	NA	329c7b4c-598b-4588-8250-c88816c6a921	B43KB00	1874	NA	1	2022-09-05 13:54:42	2022-09-05 13:54:42	CPP
00059450-eb08-47fd-9e9f-b80b8b4fbf99	09cb067f-4fee-32ea-8a40-0c2ab6f1d19a	NA	8822ee1b-8b5f-432a-b690-00a420847279	B14LO00	2258	NA	1	2024-08-30 10:43:41	2024-08-30 10:43:41	CPP
00096dd7-e90e-421a-bf6b-92f3b9939056	f620114b-4206-3567-a4f2-0296cf5eb165	NA	0de30ca3-aecc-4efd-b076-0d013476a4cf	B63IE00	1466	NA	1	2024-01-03 10:06:53	2024-01-03 10:06:53	CPP
000b0ca4-dfd4-48ce-84e6-94959b0cdf77	0839625d-020b-3f72-93b4-070c8c8624d9	NA	94ef8cac-3f5c-4e2a-bb0c-d2e0871350f8	B41ME00	2401	NA	1	2023-07-14 13:37:15	2023-07-14 13:37:15	CPP

25. L0_CPP_stgCPPApplicationOrderDefendantOffence

id	court_order_id	defendant_id	offence_id	last_modified_ts	last_updated_ts	source_system_type_code
002f80b3-d432-4d73-9de2-c6da15ab7053	81fea180-55d7-48dd-8d88-3b84900712c0	32defd94-6ba8-4e6b-86dd-1ab6c9fafdd7	8424d547-d7d7-44ac-b115-d100b4813194	2024-09-03 11:40:21	2024-09-03 11:40:21	CPP
003afea3-5f54-4a20-8435-0c24b55c3152	9ae37658-bc00-4879-8968-307e90a51b7d	bf040029-8667-42ea-a4f6-f78cc3221511	254ded0f-17ae-4d79-acab-0e84c4f77531	2024-09-04 12:33:01	2024-09-04 12:33:01	CPP
004a5c2b-1abf-4c60-8ec2-29d3161899d6	3223559b-6fd4-4f4b-ae23-427ec99d33f4	1414e79e-63b7-4ef0-9734-c9767a818d29	8e89f136-a7ec-4ddf-8311-4b6eb77b11ae	2024-09-06 15:18:23	2024-09-06 15:18:23	CPP
0065dc4c-61e3-4a86-b2ff-80dc05f622a4	a0951287-dcf8-4a8b-86c5-508440a58001	a69ad2f8-eb29-46c1-9ee8-6081ff0ad41c	5a61bb73-ea5e-4cb0-8332-da998c7fe97c	2024-09-05 10:55:26	2024-09-05 10:55:27	CPP
0072eaa9-3727-4c0e-9433-665f4972ff24	e2c61a9b-baec-49e9-a6d3-0ad0821c14b2	2bbf43aa-e6a0-4554-b4ef-71178d62d85e	4ad31e38-196b-4880-b21a-5010bf372e18	2024-09-05 10:36:51	2024-09-05 10:36:51	CPP

26. L0_CPP_stgCPPDefendantAlias

id	defendant_id	title	first_name	middle_name	last_name	legal_entity_name	last_modified_ts	last_updated_ts	source_system_type_code
0e42102e-8823-457d-89bb-45165be3594e	be8a95ac-68d4-4630-927b-0af2a0fefd41	NA	TONY	NA	MCBRIDE	NA	2022-04-13 12:26:19	2022-04-13 12:26:20	CPP
0f0c6c0b-5618-4a74-bf04-297613696803	32a8e514-0e48-4a81-a407-fa708505e133	NA	JARSOLAN	NA	PIATEK	NA	2022-04-01 13:19:49	2022-04-01 13:19:49	CPP
0f914b74-b420-4671-bb30-d7945163c8b2	0ff7b0dc-e703-4c2c-9410-e94d4ab7ec49	NA	GABRIEL	NA	FORD	NA	2022-04-25 13:39:09	2022-04-25 13:39:10	CPP
13723a44-68aa-4170-b911-2b3d3a7c78ae	a4158d19-e13e-4fcf-854a-e5eba75b838b	NA	CRAIG	NA	FOSTER	NA	2022-02-16 16:38:01	2022-04-22 17:28:54	CPP
1f298a7c-3f99-4460-907b-882d20760856	e94dcbc0-71a7-47bc-91e0-7c9348da6244	NA	BERNARD	PIO	CASEY	NA	2022-04-06 09:17:26	2022-04-06 09:17:27	CPP

27. L0_CPP_stgCPPDefendantDetail

case_person_id	num_previous_convictions	irn	last_modified_ts	interpreter_language	employment_status	employer_info_deleted	financial_info_deleted	vehicle_operator_license_num	employer_payroll_ref	bail_status_code	bail_status_description	prosecution_authority_ref_num	cro_num	pnc_id	arrest_summons_number	witness_statement	witness_statement_welsh	mitigation	mitigation_welsh	bail_status_id	bail_condition	custody_time_limit	perceived_birth_year	driver_number	driver_license_code	driver_license_issue	custodial_establishment_id	custodial_establishment_name	last_updated_ts	offender_code	applied_prosecutor_costs	master_defendant_id	court_proceedings_initiated	created_ts	gob_account_num	division_code	custodial_establishment	hearing_language	source_system_type_code
00003b81-d258-4328-ab09-5e8a94f73b33	NA	NA	NA	NA	NA	false	false	NA	NA	A	Not applicable	2400000000001106104K	109409/12A	20120290149L	2400000000001106104K	NA	NA	NA	NA	86009c70-759d-3308-8de4-194886ff9a77	NOT TO ENTER CARDIFF CITY CENTRE AS DEFINED BY THE ATTACHED MAP, BETWEEN 1800 AND 0600NOT TO BE DRUNK IN A PUBLIC PLACE	NA	NA	JONES903187JP9DX	NA	NA	NA	NA	2024-09-24 14:26:07	NA	NA	00003b81-d258-4328-ab09-5e8a94f73b33	2024-08-31 08:37:43	2024-08-31 08:37:44	NA	NA	NA	ENGLISH	CPP
00009ed5-63a8-409e-b989-aa4ce06dba0a	0	NA	NA	NA	NA	false	false	NA	NA	NA	NA	G94DV00-20240806-48004285-YG02NBP	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	2024-08-07 08:31:04	NA	100	NA	NA	2024-08-07 08:31:04	NA	NA	NA	NA	CPP
0000a38c-c13c-4ec7-a540-80a239d631ca	NA	NA	NA	NA	NA	false	false	NA	NA	A	Not applicable	2200000000001146622D	57931/08V	20080141711E	2200000000001146622D	NA	NA	NA	NA	86009c70-759d-3308-8de4-194886ff9a77	NA	NA	NA	NA	NA	NA	NA	NA	2022-12-09 12:10:23	NA	NA	0000a38c-c13c-4ec7-a540-80a239d631ca	2022-11-23 12:12:36	2022-11-23 12:12:37	NA	NA	NA	ENGLISH	CPP
0000b034-460c-425e-b382-e64c7a888c92	NA	NA	NA	NA	NA	false	false	NA	NA	U	Unconditional bail	2400000000001445451Q	NA	20110315350N	2400000000001445451Q	NA	NA	NA	NA	eaf18bf8-9569-3656-a4ab-64299f9bd513	NA	NA	NA	NA	NA	NA	NA	NA	2024-12-18 16:38:59	NA	NA	0000b034-460c-425e-b382-e64c7a888c92	2024-11-13 15:29:24	2024-11-13 15:29:25	NA	NA	NA	ENGLISH	CPP
0000d6ac-766e-449c-9d9b-3f36311b10a4	NA	NA	NA	NA	NA	false	false	NA	NA	C	Custody	2400000000000975895D	33400/97L	19970065087X	2400000000000975895D	NA	NA	NA	NA	12e69486-4d01-3403-a50a-7419ca040635	NA	NA	NA	MCCAR705179P99CV	NA	NA	cbd83421-9c17-3fc2-8357-6f0eea1dc55a	HMP/YOI Wormwood Scrubs	2024-11-11 14:36:35	NA	NA	c03c9579-3e15-4a79-9398-c8eeec547a90	2024-08-02 14:41:43	2024-08-02 14:41:44	NA	NA	Prison	ENGLISH	CPP

28. L0_CPP_stgCPPSPIDefendantErrorDetail

id	error_id	error_code	error_key	error_value	error_recorded_date	last_modified_ts	last_updated_ts	source_system_type_code
0a935f93-ce8a-4820-8637-7da47b90204c	05d0be88-cbcb-4e4e-aae5-d921b120ed90	ALCOHOL_DRUG_LEVEL_METHOD_MISSING	offence_alcoholRelatedOffence_alcoholLevelMethod		2022-03-08 11:09:01	2022-03-08 11:09:01	2022-03-08 11:09:02	CPP
1e0acf63-8765-4366-888d-d04a51b0a83e	80129afb-acae-4b9c-9a8f-106d538dbd37	ALCOHOL_DRUG_LEVEL_AMOUNT_MISSING	offence_alcoholRelatedOffence_alcoholLevelAmount		2022-03-01 16:39:30	2022-03-01 16:39:30	2022-03-01 16:39:31	CPP
26ac10ab-9536-40ef-aadb-fae0ad31c139	2375b100-0bfe-40c5-bf24-5d99153bbee2	ALCOHOL_DRUG_LEVEL_AMOUNT_MISSING	offence_alcoholRelatedOffence_alcoholLevelAmount		2022-02-28 15:22:06	2022-02-28 15:22:06	2022-02-28 15:22:07	CPP
337eb3fa-4fde-4294-b0c3-de03b7e047c7	352ee16d-98e5-4059-bf5f-4ea873de0b9d	ALCOHOL_DRUG_LEVEL_AMOUNT_MISSING	offence_alcoholRelatedOffence_alcoholLevelAmount		2022-03-08 09:26:35	2022-03-08 09:26:35	2022-03-08 09:26:35	CPP
67299bde-ca07-4e9a-8269-705647d26fa2	c2b81abe-59cf-480b-856d-cf16132d8466	ALCOHOL_DRUG_LEVEL_METHOD_MISSING	offence_alcoholRelatedOffence_alcoholLevelMethod		2022-03-07 13:40:31	2022-03-07 13:40:31	2022-03-07 13:40:31	CPP

29. L0_CPP_stgCPPHearingResultPrompt

id	hearing_result_id	prompt_id	prompt_label	prompt_value_welsh	last_modified_ts	prompt_value	source_system_type_code
00000c3d-32d0-4f78-a7eb-5262036fe02c	602cd7f7-ae4f-4b4a-9254-bebbe5a78ef4	66868c04-72c4-46d9-a4fc-860a82107475	Courthouse address line 3	NA	2022-03-04 15:25:01	Surrey	CPP
00003eff-10e1-4709-b857-07dadeebffff	03eee22b-7c30-426c-95ff-1135cd8301d1	66868c04-72c4-46d9-a4fc-860a82107475	Courthouse address line 3	NA	2023-09-27 14:50:00	Durham	CPP
000052b5-d2bd-454c-ad38-2fc7330046c3	8ccae4fa-197c-4f4d-9cb8-cf2f8ceaa0c2	ea957761-0813-4a92-9e7c-b536654325f0	Imprisonment reasons	NA	2023-10-24 15:31:48	the offence(s) are so serious that only a custodial sentence can be justified	CPP
0000825e-260f-42cd-9c52-6dd35b8d4676	df631cbe-2c0b-4dc3-8b64-0195a77cc192	6927b6ac-4c85-4532-838d-88ac00ea83f9	Conveyor / custodian name organisation name	NA	2022-07-27 14:40:54	South West and Central Division NPS	CPP
0000b210-f129-4416-ba92-3ac9b8fec693	b8bcd1f0-f165-4f4b-9069-ed9b426daa20	c1116d12-dd35-4171-807a-2cb845357d22	Hearing type	NA	2023-06-22 11:29:08	Plea and Trial Preparation	CPP

30. L0_CPP_stgCPPDefenceAssociationAccessGrant

id	defendant_id	granter_user_id	grantee_user_id	grantee_org_id	grantee_org_name	permission_action	permission_object	access_granted_ts	access_removed_ts	last_modified_ts	last_updated_ts	source_system_type_code
01204bb2-301e-471c-b1dd-99b132d9b799	1c485455-b411-4150-832f-981651dede9c	977669eb-c519-4aa2-af3d-cf900d1fe7a5	eb64569f-bab8-4f4d-9088-f32a13d5e1b2	fa183031-e049-456f-bdbc-ec6dcf1150b1	Alexander Gallagher - freelance	View	DefenceClient	2023-10-30 11:23:57	2023-11-01 09:12:15	2023-10-30 11:23:57	2023-11-01 09:12:15	CPP
0129c9b2-fb86-48ed-bc91-7eea48a2f136	ceefd70b-1d2f-4a14-bc27-c6141d24e677	a3df363f-d477-40b9-9c78-90317517280d	e4c50e6d-d8a3-4826-aca9-0162aeb133b0	62d08090-9324-4823-8e4e-5bdca289514a	Mountford Chambers	View	DefenceClient	2023-11-20 21:36:36	NA	2023-11-20 21:36:36	2023-11-20 21:36:37	CPP
02b9f7ec-cf71-45f0-897c-6b88ffd6fa27	00fb5fc9-176e-45e4-8c64-0c41aaf00c27	d31525e2-0e34-4777-8a7c-302c39004e44	f825b3ae-868b-478f-82ad-15b334380385	c7394de0-8bb6-4381-a26e-8c2658e24d03	Morgan Has Solicitors	View	DefendantDocuments	2023-11-15 10:51:17	2023-11-15 11:18:04	2023-11-15 10:51:17	2023-11-15 11:18:04	CPP
03728cda-ed43-4d0c-bc2a-f61a4af3f96b	bc99c10c-22f3-48b1-9890-22594636bc7a	acbbf3fb-4384-4e39-b396-6db7346a32ad	13bf8a54-84c2-4b8a-9694-129fa269f21a	7d28bbf9-cd52-4730-af1f-6cb8c2d9a57b	GT Stewart Ltd.	Upload	DefendantDocuments	2023-09-25 09:47:15	NA	2023-09-25 09:47:15	2023-09-25 09:47:16	CPP
06563ba8-3ad0-40ad-98d7-a7ec1d389b0e	7671cf4d-17e7-4980-b3cb-b1f0c812d29a	7085022b-514b-40de-aa93-e7933c37a7f4	b4ba70dc-bc43-407f-9d19-8ab3e5c6779e	89c0385f-184b-43df-b474-aa641186e1d1	Red Lion Chambers	View	DefendantDocuments	2022-12-12 14:57:42	NA	2022-12-12 14:57:42	2022-12-12 14:57:42	CPP

31. L0_CPP_stgCPPHearingInterpreterIntermediary

id	hearing_id	defendant_id	hearing_role	first_name	last_name	full_name	last_modified_ts	record_deleted	last_updated_ts	representation_type	source_system_type_code
24de970a-b470-4f8a-9854-bfadc04fd191	44479348-5d4c-491b-b256-043af223462e	ac80e5a0-99fd-4eb2-8f9e-88ffe40c1d3f	INTERPRETER	Ranbeer	Singh	NA	2024-11-14 11:06:11	false	2024-11-14 11:06:11	DEFENDANTS	CPP
77c2f930-9344-4aba-b746-ed56e61d6f19	ba3ca97b-72b6-478e-8690-9379e631f969	6ee4e9da-bde3-4ddc-9a74-f178f59dc02f	INTERPRETER	Shpetim	Cela	NA	2024-11-13 13:21:35	false	2024-11-13 13:21:35	DEFENDANTS	CPP
607c4293-d98e-4ff5-83ae-e79aea10d39b	0f7c587b-1dfc-464c-a246-38ab6833d2da	2196e045-a471-4938-b667-19b52f4acaaa	INTERPRETER	Kristina	Stukkoite	NA	2024-11-15 10:42:03	false	2024-11-15 10:42:03	DEFENDANTS	CPP
e7bb56c2-cda0-454b-9c43-937277314733	809d5bfb-26f0-4813-9199-ab45345a083a	d8dd690e-fbb1-44cf-b938-66baa84d766e	INTERPRETER	Nitiyanantaselvi	Kanaratnam	NA	2024-11-15 12:39:26	false	2024-11-15 12:39:26	DEFENDANTS	CPP
fc0f1e1c-37af-40fd-b378-7dcc3a9cc676	075d11d5-2729-4dfe-b014-671264610d5e	0c1af64f-219a-46a9-9e9b-a5eee09a8f2a	INTERPRETER	Luciana	GHEORGHE	NA	2024-11-11 14:16:37	false	2024-11-11 14:16:37	DEFENDANTS	CPP

32. L0_CPP_stgCPPLegalEntity

id	entity_name	incorporation_number	registered_charity_number	address1	address2	address3	address4	address5	post_code	home_telephone	mobile	work_telephone	fax	email	email_secondary	last_modified_ts	last_updated_ts	source_system_type_code
34b08570-92b6-4257-8b6a-3b5268f8af12	SIPEC LIMITED	NA	NA	INTERNATIONAL HOUSE	10 BEAUFORT COURT	ADMIRALS WAY	LONDON	GREATER LONDON	E14 9XL	NA	NA	NA	NA	NA	NA	2023-09-29 10:46:31	2023-09-29 10:46:31	CPP
87c07090-8d1c-4889-9984-024619caef11	F P HURLEY & SONS	NA	NA	F P HURLEY AND SONS LTD	QUEENS ROAD SOUTH	BRIDGEND INDUSTRIAL ESTATE	BRIDGEND	NA	CF31 3UR	NA	NA	1656661151	NA	NA	NA	2023-10-02 08:29:28	2023-10-02 08:29:28	CPP
094f335c-d4b3-40fa-8056-d4439d2de6f1	CKW CONTRACTS LTD	NA	NA	2 ASPLEY CLOSE	FOUR ASHES	STAFFORDSHIRE	NA	NA	WV10 7DE	NA	NA	NA	NA	NA	NA	2023-11-27 08:58:12	2023-11-27 08:58:12	CPP
13833ad7-c532-4d7d-bc64-66f430406110	VANS DIRECT	NA	NA	348 348 SHIRLEY ROAD	SOUTHAMPTON	HAMPSHIRE	NA	NA	SO15 3HY	NA	2380777441	2380777441	NA	sales@vansdirect-uk.com	NA	2023-11-28 11:06:46	2023-11-28 11:06:46	CPP
4fd0e349-fcf6-4935-a427-7414fce35558	LINDE MATERIAL HANDLING (UK) LTD	NA	NA	LINDE MATERIAL HANDLING (UK) LTD	KINGSCLERE ROAD	BASINGSTOKE	HAMPSHIRE	NA	RG21 6XJ	NA	NA	NA	NA	NA	NA	2023-11-27 09:20:44	2023-11-27 09:20:44	CPP

33. L0_CPP_stgCPPCourtScheduleJudiciary

court_schedule_id	court_listing_profile_id	judiciary_id	rota_judiciary_id	title	forenames	surname	email	judiciary_type	is_bench_chairman	is_deputy	position	active	created_on	updated_on	source_system_type_code
000171f4-6958-399f-ac9a-bd535a1ca0e1	CS3501558	812a1562-7ae8-3640-8021-c744bb56e64b	MA4225	Mrs	Catherine Anne	Spencer-Lewis	catherine.spencer-lewis.jp@ejudiciary.net	Magistrate	false	true	RIGHT_WINGER	true	2022-05-09 05:18:27	2022-05-09 05:18:27	CPP
001697c4-613b-3444-8a91-8a5b1e58bf4d	CS3843020	83dc3b83-7952-42a1-97be-9f8c93a80253	MA25117	Miss	Laura Julia	Forrester	laura.forrester.jp@ejudiciary.net	Magistrate	false	true	LEFT_WINGER	true	2023-08-22 20:00:26	2023-08-22 20:00:26	CPP
0025b9a0-84c4-32a7-8ee4-5d994f4bf830	CS4085005	90fa69c8-2c06-39f1-abb7-39cf7ea53fe4	MA14512	Mr	Nigel James	Buckland	nigel.buckland.jp@ejudiciary.net	Magistrate	true	false	CHAIR	true	2023-10-12 20:01:35	2023-10-30 20:01:29	CPP
0040a781-1479-39aa-a6da-5bd80d68de69	CS3463198	b78baac8-cbde-338d-82dc-0214704330ce	MA11192	Mr	Clifford Serge	Piarroux	clifford.piarroux.jp@ejudiciary.net	Magistrate	false	true	LEFT_WINGER	true	2022-06-15 00:57:29	2022-06-15 00:57:29	CPP
00566978-81dd-3162-b860-07e34f3cffb2	CS3412867	a1280bb5-7e98-3da6-ad54-eb0f20cbb95e	MA2558	Mr	Timothy	Cole	timothy.cole.jp@ejudiciary.net	Magistrate	true	false	CHAIR	true	2022-06-25 00:58:15	2022-06-25 00:58:15	CPP

34. L0_CPP_stgCPPOffenceDetail

offence_detail_id	defendant_id	cjs_offence_code	offence_date	charge_date	created_ts	plea_initial	plea_method	initial_plea_date	changed_ts	ready_for_decision_ts	assigned_ts	resulted_ts	offence_status	libra_offence_date_code	seq_no	offence_wording	end_date	arrest_date	police_offence_id	prosecution_facts	compensation	pending_withdrawal	withdrawal_requested_date	last_modified_ts	offence_ref_id	information_date	order_index	offence_count	acquittal_date	vehicle_registration	alcohol_reading_amount	alcohol_reading_method_code	alcohol_reading_method_description	vehicle_code	offence_added_date	offence_wording_welsh	notified_plea_date	notified_plea_value	indicated_plea_date	indicated_plea_value	indicated_plea_source	hearing_plea_date	hearing_plea_value	conviction_date	laid_date	verdict_date	verdict_type_id	lesser_alternative_offence_id	proceedings_concluded_flag	intro_after_proceeding_flag	allocation_decision_date	mode_of_reason_id	mode_of_reason_desc	court_sentence_ind_id	court_sentence_ind_desc	laa_application_ref	laa_application_status_id	laa_application_status_date	laa_application_eff_start_date	laa_application_eff_end_date	laa_contract_num	offence_date_code	offence_location	prosecution_facts_welsh	custody_time_limit	custody_days_spent	offence_title	source_system_type_code
00007eaf-9a61-4e06-beeb-0e8d66a10167	2912be1d-7486-46ac-94d6-f5615f0761fa	RT88333	2022-11-02	2023-05-09	2023-05-09 06:59:05	NA	NA	NA	2023-11-10 13:42:18	NA	NA	NA	NA	NA	2	on 02/11/2022 at Gravesend in the County of Kent drove a motor vehicle namely a BMW 320d with index KU12WBG on a road namely Damigos Road, Gravesend while disqualified from holding or obtaining a driving licence	NA	2023-05-09	NA	NA	NA	NA	NA	2023-11-10 13:42:18	6c55c7e7-108c-3120-8e45-a8900f86d88e	NA	NA	0	NA	NA	NA	NA	NA	NA	2023-05-09	NA	NA	NA	NA	NA	NA	2023-07-20	GUILTY	NA	NA	NA	NA	NA	false	NA	2023-07-20	b8c37e33-defd-351c-b91e-1e03e51657da	Summary-only offence	NA	NA	7655813	98e86937-9652-32a3-a9fb-dbd01eda86a5	2023-07-14	2023-07-14	2023-07-14	2P418K	1	No location provided	NA	NA	NA	Drive whilst disqualified	CPP
000db938-6315-415d-85aa-149117294ea1	cb6206a7-21e0-41cc-9e44-506ffd60ff68	VE94015	2022-10-09	2023-02-17	2023-02-18 09:59:59	NA	NA	NA	NA	NA	NA	NA	NA	1	1	On 09/10/2022 you kept or used an unlicensed vehicle SV08RZY at COTTAGE GROVE, PO12 contrary to Section 29(1) of the Vehicle Excise and Registration Act 1994. The previous licence expired on 28/02/2022, and the annual rate of duty was £165.00.	NA	NA	NA	NA	NA	NA	NA	2023-02-18 09:59:59	29046a25-8dc5-4cd3-9a75-1a739ed0b2f1	NA	NA	NA	NA	NA	NA	NA	NA	NA	2023-02-18	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	1	COTTAGE GROVE, PO12	NA	NA	NA	Keep a vehicle without a valid vehicle licence	CPP
000fe1f3-4f47-4dc7-be91-ba5b072fa34c	b53cc2b2-865e-4e07-9c1a-9efa9dbfb956	TH68010	2023-12-29	2024-01-17	2024-01-17 01:32:11	NA	NA	NA	2024-02-16 12:23:27	NA	NA	NA	NA	NA	1	On 29/12/2023 at THE RANGE HOME AND LEISURE, CHALON WAY WEST, ST HELENS, ST HELENS UK WA10 1BF you stole air freshners to the value of £19.94 belonging to THE RANGE	NA	2024-01-16	NA	NA	NA	NA	NA	2024-02-16 12:23:27	c8b42f54-833a-37de-982e-e62fca7540dd	NA	NA	0	NA	NA	NA	NA	NA	NA	2024-01-17	NA	NA	NA	NA	NA	NA	2024-01-17	GUILTY	2024-01-17	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	7795877	b027921f-3176-3058-bc5f-cdffa2897e55	2024-01-18	2024-01-18	2024-01-18	0V920Q	5	THE RANGE HOME AND LEISURE, CHALON WAY WEST, ST HELENS, ST HELENS UK WA10 1BF (L	NA	NA	NA	Theft from a shop	CPP
0015ab15-4573-42b9-b462-58ce7f7b6d37	fd74052a-531d-411b-9b73-a6d26a9015e4	CJ67002	2022-08-16	2022-08-16	2022-08-16 08:33:46	NA	NA	NA	2022-10-14 08:39:05	NA	NA	NA	NA	NA	1	ON TUESDAY 16-AUGUST-2022 AT NEWCASTLE UPON TYNE IN A PUBLIC PLACE NAMELY DEAN STREET WERE GUILTY WHILST DRUNK OF DISORDERLY BEHAVIOUR. CONTRARY TO SECTION 91(1) OF THE CRIMINAL JUSTICE ACT 1967.	NA	2022-08-16	NA	NA	NA	NA	NA	2022-10-14 08:39:05	432746e9-c547-4127-b36e-0402bddfafb7	NA	NA	0	NA	NA	NA	NA	NA	NA	2022-08-16	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	7454748	98e86937-9652-32a3-a9fb-dbd01eda86a5	2022-10-14	2022-10-14	2022-10-14	1Q201L	1	SCOTSWOOD ROAD	NA	NA	NA	Drunk and disorderly in a public place	CPP
00172855-0631-439d-8072-8061f9346366	18ce5842-e176-4b3d-ad88-885feebf17de	RT88218	2024-05-13	2024-06-13	2024-06-13 15:02:28	NA	NA	NA	2024-07-04 10:46:55	NA	NA	NA	NA	NA	1	On 13/05/2024 at Hatfield in the county of Hertfordshire being the driver of a mechanically propelled vehicle namely NISSAN(UK) JUKE TEKNA index EY70EVJ owing to the presence of which on a road, namely Bishops Rise an accident occurred whereby personal injury was caused to another person, namely a refuse collector working in the road, failed to stop	NA	2024-06-13	NA	On 13/05/2024 at Hatfield in the county of Hertfordshire the defendant, being the driver of a mechanically propelled vehicle namely NISSAN(UK) JUKE TEKNA index EY70EVJ owing to the presence of which on a road, namely Bishops Rise an accident occurred whereby personal injury was caused to another person, namely a refuse collector working in the road, failed to stop.	NA	NA	NA	2024-07-04 10:46:55	319560b2-13b2-3be5-bc55-408ca6175b20	NA	NA	0	NA	EY70EVJ	NA	NA	NA	OTHER	2024-06-13	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	1	No location provided	NA	NA	NA	Driver of a vehicle fail to stop after a road accident	CPP

35. L0_CPP_stgCPPOffencePlea

id	case_id	offence_id	plea_method	plea_date	plea_type	mitigation	reason_not_guilty	last_modified_ts	cancelled_flag	allocation_decision_date	mode_of_reason_id	mode_of_reason_desc	court_sentence_ind_id	court_sentence_ind_desc	source_system_type_code
0007657d-bac5-4aad-9dc8-65885873b7c2	bd54388e-5b23-4cb8-b5bf-4d5052049b1d	ed571805-c6b7-4360-af17-c2f1305db934	IN_COURT	2022-08-12 00:00:00	GUILTY	NA	NA	2022-08-12 14:03:33	false	2022-08-12	b8c37e33-defd-351c-b91e-1e03e51657da	Summary-only offence	NA	NA	CPP
00095aef-1605-4803-ac92-03a544125323	60344906-484e-4a7c-bb97-12e73f76c9f6	488c96f7-4542-45c8-966b-a5da43a0fa80	ONLINE	2025-01-06 09:25:51	GUILTY	I had booked onto a speed awareness course and had attended the first 30mins of the course however I had a medical emergency and I was unable to complete the course and did not have enough time to rebook or a option to potentially extend at allowed time before court proceedings. This was with drive tech. There’s no excuse for speeding and I normally take more care. I have chosen a guilty plea as I cannot afford to fight this. It would be good to see the calibration records for the camera used by the PC. My financial situation is very poor at the moment I’m self employed and have not worked for 5 months please consider this when issuing the fine I already cannot afford my direct debits.	NA	2025-01-06 09:25:51	false	NA	NA	NA	NA	NA	CPP
000e528e-417d-4c18-973a-5a564407e94c	8b5cc1d5-0e15-490d-a3da-d1b6c5918e33	a2c03b82-9015-4068-8b5a-3c54f15b1b59	IN_COURT	2023-07-25 00:00:00	NOT_GUILTY	NA	NA	2023-07-25 14:59:28	false	2023-07-25	a4380923-dd65-3c19-9b16-31af7c829187	Defendant consents to summary trial	NA	NA	CPP
000e7faa-d3d3-481c-a805-026e440f5809	15ab9e02-5b02-4036-b830-3036a7dbe332	2447f232-dca0-49a7-8da2-7305c3c34b0d	IN_COURT	2023-02-23 00:00:00	GUILTY	NA	NA	2023-02-23 10:31:25	false	2023-01-05	b8c37e33-defd-351c-b91e-1e03e51657da	Summary-only offence	NA	NA	CPP
0010d027-8fb8-403c-9c0b-580d75bdaff1	7310b2e3-8e7e-401e-bbe4-120fc0701903	32774988-0dd2-4de5-b245-bd3977681115	IN_COURT	2024-02-21 00:00:00	GUILTY	NA	NA	2024-02-21 11:20:25	false	2024-02-21	b8c37e33-defd-351c-b91e-1e03e51657da	Summary-only offence	NA	NA	CPP

36. L0_CPP_stgCPPHearingDefenceCounsel

hearing_date_id	detail	hearing_id	last_modified_ts	last_updated_ts	source_system_type_code
00007429-0d48-3739-a9da-71005003956e	[{“id”:“ce811d3c-4edb-4c26-8285-0193d8253cae”,“firstName”:“PETE”,“lastName”:“RATCLIFF”,“status”:“J ALONE”}]	5a154c70-de9a-45d6-b2ea-2a224e20ac97	2024-06-12 11:41:59	2024-06-12 11:41:59	CPP
00007cde-3f01-3a4f-bb12-477c7d266eb2	[{“id”:“fe28e22c-6b25-41fc-b7c0-42d7ee4e9f36”,“firstName”:“Not”,“lastName”:“Represented”,“status”:“NR”}]	d4cc7124-dc26-499a-afc0-e68e00b1f0b1	2024-06-05 09:46:45	2024-06-05 09:48:28	CPP
0001a16b-0543-3749-aad7-cfd0c8e704e3	[{“id”:“73ac0562-252a-4c23-87b6-037e455b16cf”,“firstName”:“Neil”,“lastName”:“Gerrity”,“status”:“J Alone”},{“id”:“e9a5fecd-b017-4856-94ab-7669241e6bb9”,“firstName”:“Michael”,“lastName”:“Fullerton”,“status”:“J Alone”}]	8593c184-5bc1-4f2c-a0d9-b8eed124de44	2024-06-17 14:26:38	2024-06-17 14:28:10	CPP
00020458-91d3-36af-a038-10ed215cd404	[{“id”:“8b41df08-41eb-442e-a86d-568745c0ef26”,“firstName”:“Majid”,“lastName”:“Awan”,“status”:“Defence”}]	21f38845-2122-41e5-b550-59f2ff99704f	2024-06-25 09:40:07	2024-06-25 09:40:07	CPP
0003041d-e73c-3621-9932-46749f165520	[{“id”:“85fa759a-c864-4058-bbbf-66a01581a20b”,“firstName”:“Kaja”,“lastName”:“Reiff-Musgrove”,“status”:“Defence”}]	d6ab7039-ec66-4cb0-93fb-0728b99c8f2f	2024-06-14 11:55:26	2024-06-14 11:58:47	CPP

37. L0_CPP_stgCPPFinancialMeansOutgoing

id	financial_means_id	description	amount	last_modified_ts	last_updated_ts	source_system_type_code
0c22b375-c96a-422f-875d-a468300459a8	59cf063a-50ea-4e88-a38c-9d1a7a1eb2a5	NA	NA	2024-09-01 11:47:34	2024-09-01 11:47:35	CPP
1209f4c9-b405-45c7-b71f-940824e7905c	2aaa7eeb-bf5d-4177-aad6-856f03db82a6	Council Tax	245	2024-09-07 09:43:34	2024-09-07 09:43:35	CPP
199590c7-5e9e-4b32-95d5-ced772bd7f82	356a394b-4ad6-4e9d-9dc5-10d0e4201fe8	Travel Expenses	NA	2024-09-04 00:15:50	2024-09-04 00:15:50	CPP
1e43a250-b8bb-4e33-9bfa-ac7c19d44201	1c6ebb96-6e38-4f42-9607-9fe9d3ae69fd	Household Bills	350	2024-09-01 19:15:27	2024-09-01 19:15:27	CPP
21257f29-c227-4dc7-8c45-b02573877ec2	45904d6a-f34f-4f6d-a2fa-519bed0789f9	Council Tax	NA	2024-09-05 11:38:26	2024-09-05 11:38:27	CPP

38. L0_CPP_stgCPPHearing

id	judiciary_id	hearing_type_id	court_id	last_modified_ts	court_room_id	estimated_mins	jurisdiction_type	hearing_allocated_ts	hearing_initiated_ts	hearing_results_added_ts	last_updated_ts	hearing_language	box_hearing	hearing_listed_ts	week_commence_start_date	week_commence_end_date	week_commence_duration_wks	duplicate_flag	deleted_flag	week_commence_date_removed	source_system_type_code
0001abb9-dc16-40e9-93c3-f61e4aeac356	NA	ff7f05e1-8a65-39bf-8d65-f73ef9a4ebed	e6986943-68d9-36fc-bbd0-68fa32efdd4f	2024-11-08 10:26:06	e7cbd00e-484e-334a-b299-e69cc3f14cd8	0	MAGISTRATES	2024-11-08 09:03:06	2024-11-08 06:45:07	2024-11-08 10:26:00	2024-11-08 10:26:06	ENGLISH	false	2024-10-22 11:23:38	NA	NA	NA	NA	NA	NA	CPP
0002a713-c5af-47df-9a7f-031472423898	NA	bf8155e1-90b9-4080-b133-bfbad895d6e4	879ddc11-afd1-4f9a-b8fb-f466170ecdb2	2021-06-16 13:42:44	d0946b58-81e4-3cb4-8526-c4b2dc456045	60	MAGISTRATES	2021-06-16 11:34:40	2021-05-13 12:01:35	2021-06-16 13:42:37	2021-06-16 13:42:44	ENGLISH	false	2020-11-10 12:34:17	NA	NA	NA	NA	NA	false	CPP
0005bd03-ab88-4e87-a26a-9f503f4473f3	NA	bf8155e1-90b9-4080-b133-bfbad895d6e4	ac2a72fd-1131-3e18-a84f-0dfe82d70d7a	2023-09-21 08:52:37	ee257476-7eaa-3aaa-88fb-8457a3391a31	1440	CROWN	2023-09-21 08:52:37	2023-06-29 09:00:19	NA	2023-10-13 09:00:03	ENGLISH	false	2023-05-02 14:52:56	NA	NA	NA	true	NA	NA	CPP
000b1f0c-a623-444d-86fb-e30221ce68a3	NA	5ae4c090-0f70-4694-b4fc-707633d2b430	b78d02fe-8b45-30f5-8550-e5ee2cd51ec6	2024-12-11 11:54:54	272c4e0a-cdf4-3d60-aaf7-b689177c6a68	30	MAGISTRATES	2024-12-11 11:54:54	2024-12-11 11:49:40	NA	2024-12-11 11:54:54	ENGLISH	false	2024-12-11 11:49:38	NA	NA	NA	NA	NA	NA	CPP
0013fead-dfe3-4801-b000-3eaa2b5f0cf2	NA	bf8155e1-90b9-4080-b133-bfbad895d6e4	7c75ae61-a894-3304-a96c-6d1c7ea477a0	2023-03-16 15:36:18	2bd9fd96-661d-30ea-a856-4edf4ca98255	180	MAGISTRATES	2023-03-16 08:47:29	2023-03-02 13:21:28	2023-03-16 15:35:26	2023-03-16 15:36:18	ENGLISH	false	2023-03-02 13:21:27	NA	NA	NA	NA	NA	NA	CPP

39. L0_CPP_stgCPPHearingAttendance

id	hearing_date_id	attendant_id	attendant_type	last_modified_ts	record_deleted	last_updated_ts	attendance_type	source_system_type_code
00022127-e89d-4de4-b876-950089c40c82	6749a385-5b24-3670-acbc-fe804021cb5d	b363d6f6-60b8-4f97-885b-b5f6df5d2e8d	DEFENDANTS	2024-11-26 10:19:11	false	2024-11-26 10:19:11	IN_PERSON	CPP
00035962-6d15-4268-967d-396ba679481a	83dbe0d2-16f1-30da-bc56-82b84f58cb73	70ba9a28-bc4c-48c7-9e46-91c88fe9da86	DEFENDANTS	2023-09-22 10:57:41	false	2023-09-22 10:57:41	IN_PERSON	CPP
00059f1e-3a0f-40b8-aa4e-ca65dd313b61	f8bc4132-1ae8-3203-9563-5467d0c4c909	43908826-95c4-479c-8563-0ed41a56fa59	DEFENDANTS	2024-11-07 12:45:19	false	2024-11-07 12:45:19	NOT_PRESENT	CPP
0006841e-3a86-411a-87ed-72ec464cb996	6f723f4e-0dea-3dea-a46d-2e10c3f6949d	59d8fc9f-95e1-4f6f-ab28-9b1b5e0fb6aa	DEFENDANTS	2024-08-17 11:22:48	false	2024-08-17 11:22:48	IN_PERSON	CPP
0015d875-b2d6-4067-8242-278c82d36b0a	572c97dc-9934-3d96-a9b6-074297a23322	eddfa3de-ca84-4f68-97a5-ae9d253b2956	DEFENDANTS	2025-01-21 11:24:45	false	2025-01-21 11:24:45	IN_PERSON	CPP

40. L0_CPP_stgCPPHearingJudiciary

id	hearing_id	judiciary_id	judiciary_title	judiciary_initial	judiciary_last_name	bench_chairman	deputy	judiciary_role_type_id	judiciary_role_type	last_modified_ts	last_updated_ts	source_system_type_code
0001ed8d-346a-4a24-97be-a18d5831232c	b3895bd4-f3d5-46b8-a4a4-afecae5c30b5	5329d1db-d56a-3062-ab80-609ba5807ad2	Mrs	R	Winterson	true	false	5329d1db-d56a-3062-ab80-609ba5807ad2	Magistrate	2022-10-20 14:50:56	2022-10-20 14:50:57	CPP
000db2b7-344a-4500-9e76-3c2c08339378	d938b2ec-1f21-47ec-a133-656ee25a32f7	7f1e3490-fa03-30a5-9dc8-7bafff4cc527	NA	S	Taylor	NA	NA	7f1e3490-fa03-30a5-9dc8-7bafff4cc527	Circuit Judge	2023-05-26 12:19:22	2023-05-26 12:20:09	CPP
0011916b-f79e-473a-b04c-4efbd013930a	6a29a708-47ba-4daa-9d63-d49f234807ee	034e6e6d-f1c6-4f63-bb15-a13b6aca40be	Mr	R	Jones	false	true	034e6e6d-f1c6-4f63-bb15-a13b6aca40be	Magistrate	2022-01-31 15:00:38	2022-01-31 15:00:38	CPP
0016a6dd-bcf0-41c9-ac0b-f28e9071865e	4e1a9771-9bfe-41e2-84c9-c026a0bbbbe5	9a29fc79-1ed6-3e57-8d2c-66da249f0521	Mr	S	Vasey	false	true	9a29fc79-1ed6-3e57-8d2c-66da249f0521	Magistrate	2022-09-02 13:46:56	2022-09-02 13:46:56	CPP
001c119b-9f89-4c4e-b215-0fdf52645dba	bc716191-f507-46c7-a660-37117ad6e0b2	3a888d7c-b27c-4967-a17d-304bf87eb762	NA	J	Hamilton	true	false	3a888d7c-b27c-4967-a17d-304bf87eb762	District Judge (MC)	2023-10-20 14:00:33	2023-10-20 14:00:33	CPP

41. L0_CPP_stgCPPSJPSession

sjp_session_id	user_id	started_ts	updated_ts	ended_ts	magistrate	organisation_id	optlock	last_modified_ts	judicial_authority	court_house_code	last_updated_ts	source_system_type_code
006d06ac-3ff2-4eca-be94-a3c49c6efa41	099a6d48-38f2-4360-a3d1-b468ae209ea1	2024-09-08 08:10:59	NA	2024-09-08 08:47:22	NA	3b9a61dd-d484-3ee7-a0b8-5954aea415bc	1	2024-09-08 08:47:22	DELEGATED_POWERS	B13CC00	2024-09-08 08:47:22	CPP
007c9540-9399-44b9-a191-16b2599d9717	a7c0523e-2b72-4bc2-a7df-b5306f5acc91	2022-10-04 08:21:48	NA	NA	NA	1ab72b25-7073-355e-b835-32809842269d	0	2022-10-04 08:21:48	DELEGATED_POWERS	B52OC00	2022-10-04 08:21:49	CPP
00859ca8-beb7-4e88-948e-6e6913eb03ff	eff20e5f-233f-41f4-8ed4-7e3efda31ef0	2018-02-08 09:57:30	NA	NA	Alexander McLean	f8254db1-1683-483e-afb3-b87fde5a0a26	0	2018-02-08 09:57:30	MAGISTRATE	B01LY	2021-03-06 23:07:56	CPP
009180f5-4c4c-4d3d-bcc7-a30256ca4bcf	4f855c9d-0977-4d0c-943d-1b793a40eb7f	2024-03-18 12:31:46	NA	NA	NA	785339c1-af71-3322-a55b-ba255e0db1c2	0	2024-03-18 12:31:46	DELEGATED_POWERS	B40IM00	2024-03-18 12:31:47	CPP
00bdf600-00d6-4539-92e5-84fb4c044380	e8c95958-09fa-4a73-8ebc-f93c5c1ad32d	2023-03-03 14:02:42	NA	2023-03-03 14:59:04	Samson Chung	f28b088c-910b-30a3-9b89-977e2fab2a1f	1	2023-03-03 14:59:04	MAGISTRATE	B20NQ00	2023-03-03 14:59:04	CPP

42. L0_CPP_stgCPPSPIDefendantError

id	defendant_id	case_id	initiation_code	urn	police_system_id	last_modified_ts	last_updated_ts	source_system_type_code
5c2ff3ca-2c03-4da4-afef-00f9e859ec19	9a06a507-3af3-4706-b016-3aaa7867df9a	c14ae957-f2be-4702-9125-e1d4812e40af	C	47NC1715424	04701NicheRMS	2024-08-15 12:31:42	2024-08-15 12:31:42	CPP
d0adae3b-4be7-482d-8ae9-225d926c7215	86c6406b-9547-4b46-acb3-234fb2ea3868	224f505d-5bb2-4417-ba54-023e99b75598	Q	01QK1277124	00101PoliceCaseSystem	2024-08-14 10:39:55	2024-08-14 10:39:55	CPP
f020b405-4617-4d11-aea4-4ad300fdef36	dad7d22c-0e93-4ea2-b382-eaf3b3913666	02cd3787-d125-4b02-92e0-80818c6d3d5c	C	62EN0798924	06201NicheRMS	2024-08-13 06:36:12	2024-08-13 06:36:12	CPP
c73aa9cc-0539-47e4-9cdc-8f4b2e6380fa	5058d9b1-a362-4a68-8cf9-1698e1315c03	ebbee5e0-6b94-4255-a651-9d63440092f3	C	63CH0127824	06301NicheRMS	2024-08-14 07:26:01	2024-08-14 07:26:01	CPP
26cc92c0-9ecb-4061-980a-e9184ce490c9	a60d4c6d-b621-4d51-824f-e60a1c42dae8	9692a979-d83e-4f43-869a-2a8c6fc65327	Q	50DE0189724	05001NicheRMS	2024-08-15 09:46:01	2024-08-15 09:46:01	CPP

43. L0_CPP_stgCPPPerson

id	title	first_name	last_name	date_of_birth	nationality	disability	ethnicity	gender	address1	address2	address3	address4	post_code	home_telephone	mobile	work_telephone	fax	email	created_on	changed_on	optlock	national_insurance_number	last_modified_ts	address_updated	dob_updated	personal_name_updated	middle_name	nationality_id	additional_nationality_id	observed_ethnicity_id	self_defined_ethnicity_id	occupation	occupation_code	interpreter_language_needs	documentation_language_needs	specific_requirements	address5	email_secondary	person_sid	additional_name	additional_nationality	source_system_type_code
0002fe13-e0f4-412c-8445-857f15df6d91	Mr	Vladimir	Ogorodnik	1983-08-30	NA	NA	NA	Male	55 Gooseley Lane	NA	London		E6 6AW	NA	NA	NA	NA	NA	2022-12-01 10:26:37	NA	0	NA	2022-12-01 10:26:37	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	ee267586c52b3f5ea80668e84a665edcfd0f3f7a	NA	NA	CPP
000a4405-6a2b-444f-9753-072acb4c9164	Mr	IAN	COULTER	1959-11-24	NA	NA	NA	Not Specified	13 WHITE SCHOOL CLOSE	WHITEHAVEN	NA	NA	CA28 9BE	NA	NA	NA	NA	bertie.26@hotmail.co.uk	2024-12-12 10:34:27	NA	4	NA	2024-12-20 11:29:01	NA	NA	NA	NA	NA	NA	NA	NA	NA	0	NA	E	NA	NA	NA	b3d5c4a2f8d9a03938819719c73ebb2c4db7d8f2	NA	NA	CPP
000c1352-9150-4161-b3cd-fcb5cfdf08db	Mr	JOSS	BROWN	1970-12-18	NA	NA	NA	Not Specified	FLAT	61 HIGH STREET	HARTLEY WINTNEY	HOOK	RG27 8NY	NA	NA	NA	NA	NA	2024-05-17 09:31:21	NA	1	NA	2024-05-17 09:31:21	NA	NA	NA	NA	NA	NA	NA	NA	NA	0	NA	E	NA	NA	NA	5eec622fd1533f254f614463b9bbd13ee9b756ba	NA	NA	CPP
000cc25e-f1d1-4bda-b748-a20a8647246d	Mr	NATHAN	THORNTON	1998-02-25	NA	NA	W1	MALE	1	CROSLEY HOUSE	CROSLEY WOOD ROAD	BINGLEY	BD16 4QD	1535649052	7943132684	NA	NA	90866@shipley.ac.uk	NA	2023-05-22 12:23:26	1	NA	2023-05-22 12:23:26	NA	NA	NA	PHILLIP JOHNATHAN	NA	NA	c4ca4238-a0b9-3382-8dcc-509a6f75849b	c4ca4238-a0b9-3382-8dcc-509a6f75849b	Unemployed	0	NA	ENGLISH	NA	BRADFORD	NA	05c440932cf301cfcc8f3d9433383c99928cc973	JOHNATHAN	NA	CPP
00108d5b-6b97-4e94-b098-bb98cf0cd67a	Mr	DARREN	DOYLE	1992-09-07	NA	NA	W1	MALE	10A RUSHEY HEY ROAD	SOUTHDENE	KIRKBY	MERSEYSIDE	L32 8SW	NA	7795652312	NA	NA	NA	2022-07-22 07:02:13	2022-07-22 07:02:13	1	NA	2022-07-22 07:02:13	NA	NA	NA	JAMES	NA	NA	c4ca4238-a0b9-3382-8dcc-509a6f75849b	c4ca4238-a0b9-3382-8dcc-509a6f75849b	Unemployed	0	NA	ENGLISH	NA	NA	NA	2832aa9da6082d91e7b1c5265c0cac157a2e9003	NA	NA	CPP

44. L0_CPP_stgCPPCustodyStatus

id	case_id	defendant_id	status_description	last_modified_ts	last_updated_ts	offence_id	status_type	hearing_id	source_system_type_code
00145741-0daa-4988-833f-b49118fa2ddc	74b35988-8136-47ca-b141-49902bace24e	78e1c2f1-36ec-4089-84c8-d3c2fb7adbfb	Custody	2024-09-13 05:24:21	2024-09-13 05:24:21	NA	PRE HEARING	NA	CPP
003c5a29-d548-4ebc-a820-de972cdaa369	1b587eee-3bf4-4de2-93ef-0ba7a49903bf	9294bc42-ed8d-4816-9606-4371d9006965	Conditional bail	2023-06-27 13:52:31	2023-06-27 13:52:32	NA	PRE HEARING	NA	CPP
005419e2-98d3-437e-902b-ff955f54666b	f1b847fb-77ff-4dbc-9a9f-5ba37e414e3f	25cf612b-9a5f-48e4-a421-2ac6eb71bf30	Custody	2023-03-24 08:19:53	2023-03-24 08:19:53	NA	PRE HEARING	NA	CPP
007831a4-816d-428d-b169-d2174bc2f2b8	6e298307-0d94-4a46-9e32-904b1cba1042	f754407d-baa2-4eec-ba5e-5dd9d4d6538a	Custody	2023-09-27 21:44:27	2023-09-27 21:44:27	NA	PRE HEARING	NA	CPP
008142b4-6dff-4e7c-9c9d-4243b1b3c036	113dc780-ad3c-4f93-9f19-a7dccf79d106	3857d851-89ab-4506-b57f-2cd5df368f51	Custody	2024-09-22 13:34:53	2024-09-22 13:34:53	NA	PRE HEARING	NA	CPP

45. L0_CPP_stgCPPCaseDetail

id	urn	cpp_ucrn	prosecuting_authority	posting_dt	hearing_location	case_created_ts	reopened_dt	libra_case_number	reopened_in_libra_reason	completed	changed_ts	ready_for_decision_ts	assigned_ts	resulted_ts	case_status	completed_ts	completed_ts_id	completed_dt_id	libra_originating_org	referred	optlock	last_modified_ts	online_plea_received	session_type	case_priority	prosecution_authority_id	prosecution_authority_ref_num	originating_organisation	initiation_code	statement_of_facts_welsh	breach_proceedings_pending	appeal_proceedings_pending	ejected_date	ejected_reason	ejected_flag	last_updated_ts	summons_code	cps_organisation	case_class	police_force_code	prosecutor_informant	channel	enforcement_export_status	enforcement_exp_stat_upd_ts	assignee_id	statement_of_facts	source_system_type_code
0002322d-2172-4234-960d-e359056b7da7	35NT1810423	NA	CPS-EEEC	NA	NA	2023-10-24 10:29:23	NA	NA	NA	NA	NA	NA	NA	NA	ACTIVE	NA	NA	NA	NA	NA	3	2023-10-24 10:29:26	NA	NA	NA	3bf14803-01ed-3a98-8865-e9b56e62c3bc	NA	135NU00	C	NA	NA	NA	NA	NA	NA	2023-10-25 08:13:51	NA	A35AE00	NA	NA	Alec Wood	SPI	NA	NA	NA	NA	CPP
000cc2a4-393e-4351-83e3-3d70821b4e08	47WS2147424	V5PXV57QS9VB	SSXPF	2024-08-19	NA	2024-08-19 14:01:04	NA	NA	NA	true	2024-09-11 09:18:10	2024-09-11 00:01:01	2024-09-11 09:13:56	2024-09-11 09:18:10	COMPLETED	2024-09-11 09:18:10	918	20240911	NA	false	15	2024-09-11 22:05:21	NA	MAGISTRATE	MEDIUM	1675cad3-894c-32f1-8ced-a97c795155b5	NA	NA	J	NA	NA	NA	NA	NA	NA	2024-09-11 22:05:22	NA	NA	NA	NA	NA	SPI	NA	NA	6f086f97-ea36-40ef-889b-ab93983deca7	NA	CPP
00143dfc-d8e8-4cca-a60d-281637d79482	05A30215821	NA	CPS-MC	NA	NA	2021-11-22 10:04:29	NA	NA	NA	NA	NA	NA	NA	NA	ACTIVE	NA	NA	NA	NA	NA	5	2021-12-07 17:06:52	NA	NA	NA	52b27284-0686-4894-b1c7-7d4b634cacdb	NA	005E100	Q	NA	NA	NA	2021-12-07 17:06:52	Ejected 07/12/21 Authorised Emma Garston/Barbara Gooch Out of Scope	true	2021-12-07 17:06:52	NA	A05AQ00	NA	NA	NA	SPI	NA	NA	NA	NA	CPP
0019b533-25de-45b7-bf3d-2ee736c0f836	44230129BN65LFO	BM1M5PZWJN1J	DVLA	2022-10-31	NA	2022-11-01 15:05:38	NA	NA	NA	true	2022-11-28 15:12:42	2022-11-28 00:00:22	2022-11-28 15:11:02	2022-11-28 15:12:42	COMPLETED	2022-11-28 15:12:42	1512	20221128	NA	false	6	2022-11-29 00:11:16	NA	MAGISTRATE	LOW	6ae4b163-658b-3ae2-a66d-43401cac2f96	NA	NA	J	NA	NA	NA	NA	NA	NA	2022-11-29 00:11:24	NA	NA	NA	NA	NICKY WILLIAMS	CPPI	NA	NA	70935718-6fe5-48f1-a08c-4e56a9c3f46f	NA	CPP
001b6225-168b-49d4-8f1e-a44770c5df4a	43722525EJ54RVM	T1JWW35S13CK	DVLA	2022-06-27	NA	2022-06-28 09:50:30	NA	NA	NA	true	2022-08-08 12:45:15	2022-07-25 00:00:10	2022-08-08 12:44:01	2022-08-08 12:45:15	COMPLETED	2022-08-08 12:45:15	1245	20220808	NA	false	6	2022-08-09 09:22:44	NA	MAGISTRATE	LOW	6ae4b163-658b-3ae2-a66d-43401cac2f96	NA	NA	J	NA	NA	NA	NA	NA	NA	2022-08-09 09:22:45	NA	NA	NA	NA	STACEY PICTON	CPPI	NA	NA	5f16045f-8d07-4ef7-b31d-3816c754211e	NA	CPP

46. L0_CPP_stgCPPSPICaseErrorDetail

id	error_id	error_code	error_key	error_value	error_recorded_date	last_modified_ts	last_updated_ts	source_system_type_code
a99f7ea1-360d-452e-ac64-cca14b892bdd	266fc0a1-a6da-4ebf-af3a-51e8132f2fbd	CASE_MARKER_IS_INVALID	caseMarkers	COVI	2022-04-20 11:03:02	2022-04-20 11:03:02	2022-04-20 11:03:03	CPP
8432cce9-f5d9-4f31-be08-e7a874d47428	0c4149d8-a464-4e2f-8852-a4b66b2f8050	CASE_MARKER_IS_INVALID	caseMarkers	DVVI	2023-02-24 12:12:33	2023-02-24 12:12:33	2023-02-24 12:12:33	CPP
c64516d6-55f2-4436-8162-d60052318926	62e9fefd-4068-4396-99de-d24e3b0cb6f0	CASE_MARKER_IS_INVALID	caseMarkers	DVVIRA	2023-02-26 22:06:12	2023-02-26 22:06:12	2023-02-26 22:06:12	CPP
6444c992-73a8-43ce-9f68-90a65e0f964f	1a38f6e0-882f-4447-8a58-38106f4a7229	CASE_MARKER_IS_INVALID	caseMarkers	DVVI	2022-06-01 10:46:59	2022-06-01 10:46:59	2022-06-01 10:47:00	CPP
d8406018-865d-434a-ba00-dc89cb14d794	b38c1087-5110-4c24-a22c-a3ec390b761f	CASE_MARKER_IS_INVALID	caseMarkers	VIDV	2022-09-17 04:59:32	2022-09-17 04:59:32	2022-09-17 04:59:33	CPP

47. L0_CPP_stgCPPApplicationCourtOrder

id	application_id	master_defendant_id	order_type_id	label	order_date	start_date	end_date	ordering_court_id	ordering_hearing_id	sjp_order	subject_breach_proceeding	subject_variation_proceeding	source_system_type_code
1bc97e56-b91d-466d-adc0-695f91a4ad10	8926a559-c490-4edd-98b1-82a067ded9f3	2b343a21-396d-4a57-bed4-36406c0b2398	8b1cff00-a456-40da-9ce4-f11c20959084	Suspended sentence order - imprisonment	2021-12-09	2021-12-09	2028-12-09	0b9417b8-91b4-385d-9e01-069855777c4f	795e9951-9f0c-435d-8cc8-3507e56b5e05	false	true	true	CPP
1e02231a-1eb3-48ce-a27e-1413988e0292	13e931c6-1731-4d6b-a819-dfb98cfd23f6	8f62974f-f43a-479c-86ae-2c0eec72d8a8	554c2622-c1cc-459e-a98d-b7f317ab065c	Conditional discharge	2022-10-19	2022-10-19	2023-04-19	0140f84c-e7cb-3fba-96a1-1878b42ee546	2ac4dbb4-781f-490b-8994-5057e31bfcbc	false	true	false	CPP
3274ae59-0c7e-4ce9-955b-dc81e236749b	bce04388-86c3-40fb-905d-7f4fdb95158a	26d56ad7-2540-416b-bcc5-232999f3a4a9	418b3aa7-65ab-4a4a-bab9-2f96b698118c	Community order England / Wales	2022-02-26	2022-02-26	2023-08-25	07c2d726-005c-323d-896e-d243bd3b800f	f7ea1922-7868-4a6a-bdf3-46a4db994343	false	true	true	CPP
3a6a05a2-929f-4a26-8175-90bfbe6e0a60	7cfd3946-2f75-4a11-9307-edb9b9a08d03	3e168e79-761c-48d9-9920-56078035c153	554c2622-c1cc-459e-a98d-b7f317ab065c	Conditional discharge	2022-02-25	2022-02-25	2022-08-25	6f6e0a54-367d-31f5-94c6-87e6c473a8f9	76386d62-5b34-409d-bbee-70e08763baae	false	true	false	CPP
7d1a9d8e-98e5-4d3f-8501-f1023137b804	1b0ba8e3-60aa-496e-886c-a95da5cf7980	d025e631-4e52-45c4-9c6d-d907c528c8a3	418b3aa7-65ab-4a4a-bab9-2f96b698118c	Community order England / Wales	2021-12-14	2021-12-14	2022-02-08	9d5798b5-1fda-34cb-89de-3317f9b24c3e	ecd302b9-abcc-4c52-b8da-1c1da3ae0324	false	true	true	CPP

48. L0_CPP_stgCPPDefenceIDPCAccess

id	organisation_id	defendant_id	user_id	idpc_detail_id	access_ts	last_modified_ts	last_updated_ts	source_system_type_code
039e4012-0463-4faf-a205-1e239e4c2a48	52825655-a8a3-4570-af15-54987c6fcc83	f19405d1-21ef-4a12-8170-2dfc9e6762e3	f4465dc9-377a-4297-bd03-47feec684259	b6ce72d5-48e5-4ac6-b36b-742111b7a746	2024-08-20 09:04:21	2024-08-20 09:04:22	2024-08-20 09:04:22	CPP
0438827c-1d16-4fe4-8baf-c99db5dfccc4	249e8178-c3a6-40f5-9a30-5d05b59f97e5	afe271c6-3c8c-452a-99b2-cb3d50a9aa6c	1a05b0ce-c709-47f3-a0a8-adb0b6dcf197	a84ac07e-3db5-4e21-9992-baae98be45b7	2024-08-20 13:29:54	2024-08-20 13:29:54	2024-08-20 13:29:54	CPP
08545a76-942a-42ad-b8c3-c6171c497b4f	038e8ea7-58d3-45a7-9d06-77b479111adc	be26df76-4877-45cc-9a5b-a17b31080d81	770ff002-0068-4696-9ef2-627bdd3c350a	d8ec3933-423a-4003-bbde-9763bd48585c	2024-08-20 12:33:02	2024-08-20 12:33:02	2024-08-20 12:33:02	CPP
0d5d08ab-64cf-41cc-9a3d-cb5e21288f62	eb95a058-ecdf-461c-a865-09be97430477	31c8ac32-8c63-4243-848a-8108ebb067e7	12ae1f50-f616-4917-8a69-38ccc3744078	e7a00e78-6bad-4f66-9e06-bbed7dda9a12	2024-08-22 08:47:12	2024-08-22 08:47:12	2024-08-22 08:47:28	CPP
10708fbc-54ee-4246-a586-adfd55d5e34d	9ce58d77-419c-4d41-8e9d-9e4e6ba18648	ec9316d6-6e34-477a-bc3c-1655c4d93ff7	4d1c740f-e4b5-4d76-9a49-d99eaad4b7a0	0ba45ef0-6d82-4d77-9901-011b1a719e4c	2024-08-21 12:01:58	2024-08-21 12:01:58	2024-08-21 12:01:59	CPP

49. L0_CPP_stgCPPApplicationDocument

id	received_ts	upload_ts	document_id	document_name	sent_to_cps	financial_means_present	document_type_id	application_id	is_removed	is_cps_case	last_modified_ts	last_updated_ts	source_system_type_code
52423825-b77a-4ae8-b18a-97dfeddc7f21	2024-12-12	2024-12-12 10:54:00	9de395cb-1547-4a5a-9e91-fa6369c9f0f1	MG1-CASSON-HCC OFFICER	false	false	c81baeee-c7dc-396d-b4b5-c9b55aa1dbb1	9e4e732d-4cd5-444f-be35-d79b0649af5e	false	false	2024-12-12 10:54:00	2024-12-12 10:54:00	CPP
c68caa65-b224-46ff-9e33-3c1a721ec392	2024-11-15	2024-12-11 14:55:10	b142e7b0-b11b-4d4a-ae25-c76336cf9f62	Application	false	false	c81baeee-c7dc-396d-b4b5-c9b55aa1dbb1	cc2a6225-8f63-4d6b-8559-5ca65840b4e1	false	false	2024-12-11 14:55:10	2024-12-11 14:55:10	CPP
651924ae-c0bd-4dc2-99cf-7ca04427badc	2024-12-13	2024-12-13 13:09:05	1560a6e0-62cf-4ab6-8db6-c4d6289af69e	TO RESPONDENT (George Holden) - Notice of Hearing	false	false	c81baeee-c7dc-396d-b4b5-c9b55aa1dbb1	db9bc303-21e0-4284-b2de-62405fc13578	false	false	2024-12-13 13:09:05	2024-12-13 13:09:05	CPP
2ae2c210-2224-4438-8326-52dbc524f7a3	2024-12-12	2024-12-12 10:52:00	908f716f-8eb0-4d3c-909a-6812102fcd5e	MG11-JACKSON-Costa Coffee	false	false	c81baeee-c7dc-396d-b4b5-c9b55aa1dbb1	9e4e732d-4cd5-444f-be35-d79b0649af5e	false	false	2024-12-12 10:52:00	2024-12-12 10:52:00	CPP
da3a9e56-a192-4e0d-afdf-c71173e4dc5b	2024-12-12	2024-12-12 12:01:57	b5fb8233-38dc-4440-be4f-18b866b53782	Request to Withdraw from Solicitors	false	false	c81baeee-c7dc-396d-b4b5-c9b55aa1dbb1	5ac9232f-7ebf-4712-9e5c-79e87083ab85	false	false	2024-12-12 12:01:57	2024-12-12 12:01:57	CPP

50. L0_CPP_stgCPPCaseDefendantDocument

id	material_id	document_id	case_id	defendant_id	disassociated_flag	last_modified_ts	last_updated_ts	source_system_type_code
0004d1b7-4ac9-4939-b408-5af7a39e33cd	e19710d6-601f-49eb-a7a7-9e904280a63e	08edec25-a5b3-44e8-b315-805b9d58194b	61cf395d-8608-4265-a347-5b48f0621cec	099abddc-9b23-43d8-ad52-067b951d12ab	false	2025-02-02 17:38:51	2025-02-02 17:38:51	CPP
000bc8cf-40c2-494e-9515-3864e5e7ee2e	32ef9fa3-31e3-4464-a90c-1b99c0ad1e43	36696fe7-1380-414c-ad53-6f7842c4a659	5a37022e-635a-4d42-96dc-34742a99e677	140911cb-ad70-46a1-b081-62a12b2f81b1	false	2025-02-03 08:19:33	2025-02-03 08:19:33	CPP
002d4e05-850f-458f-bf80-8fc47d2f489f	8914fdac-844d-4cc5-91c8-eb3aaa832587	11fd6ba6-0de5-4c56-ae99-1f141a4f00cb	1fbb3994-0b87-4c8d-8ada-0470cd32d7bb	2727898f-49b3-4203-94f2-3afb2f42bdd7	false	2025-02-02 18:23:59	2025-02-02 18:23:59	CPP
0037b84b-ebbc-46c4-91d7-931d93965dc6	94ef996d-98e5-44f6-9557-025335b69047	71684d06-252c-487d-ad7a-16eae91f4bbf	fe73f832-d1c0-4124-af95-2adf413694b4	8bf6b2a3-202f-46cd-8c53-5635a2457317	false	2025-01-31 17:05:25	2025-01-31 17:05:25	CPP
00481375-a910-4d4e-bfc8-4378a05c84aa	460cfec2-abfa-4423-b441-72f23fe3cc53	eb861ec4-9085-42bd-b2ec-b66969a36283	d5221906-12ba-4dd0-9408-e9b141dddf17	1eaeb361-7301-4b27-9ee3-b2c694545671	false	2025-01-31 14:17:30	2025-01-31 14:17:31	CPP

51. L0_CPP_stgCPPHearingProsecutionCounsel

hearing_id	hearing_date_id	detail	last_modified_ts	last_updated_ts	source_system_type_code
00a76803-67f2-451d-984a-42ac75effc48	507d004f-d3c0-349a-96ae-cdb8ebb442b3	[{“id”:“d5679a53-e93a-493b-8f6f-95801b24abcf”,“firstName”:“Andrew”,“lastName”:“Brown”,“status”:“Junior Alone”}]	2022-02-16 11:44:09	2022-02-16 11:44:09	CPP
00febfc9-427c-4ca8-8102-0fa5a8286134	9547164d-d740-384b-a56f-9b14b175703b	[{“id”:“7ba0a456-e43c-405b-b6cc-0c23ccdf9e8d”,“firstName”:“Rachel”,“lastName”:“Glover”,“status”:“Junior”}]	2022-02-01 14:57:55	2022-02-01 14:57:56	CPP
01bfe34a-761c-4309-9cc0-0e73574238c4	80fd3a21-5960-3f8a-9490-5be9cc4a8acf	[{“id”:“edb830ee-ca1b-4f5e-8157-c07a7253757d”,“firstName”:“Mr”,“lastName”:“Wilkinson”,“status”:“CPS”}]	2022-02-14 14:49:57	2022-02-14 14:49:58	CPP
07b1342b-856d-449a-be57-e52dbcef179a	f3c557b2-932f-375d-bbb4-eafde03de5af	[{“id”:“2d65ca4d-2086-48a8-a3d3-a219f5a5fad3”,“firstName”:“MISS”,“lastName”:“WOOTTON”,“status”:“CPS”}]	2022-02-03 12:45:38	2022-02-03 12:45:38	CPP
096d9dc5-3919-4cfc-9d8a-15f78b82ab04	bd2d6080-c953-3ee6-b01a-9b9f5ca4b58e	[{“id”:“75969c5a-87ed-4cd4-b1f1-402a56a595b0”,“firstName”:“ALUN”,“lastName”:“WILLIAMS”,“status”:“PLP”}]	2022-02-02 13:41:56	2022-02-02 13:41:57	CPP

52. L0_CPP_stgCPPCorrespondenceLog

id	case_id	correspondence_type	correspondence_date	deleted_flag	last_modified_ts	last_updated_ts	correspondence_time	system_generated	deleted_by_id	delete_reason_desc	delete_reason_id	source_system_type_code
d8bb7df0-0e75-45bd-b4fd-54f9fc3dafec	316595fc-f9dd-4612-a1fb-0041c316a086	Email	2023-11-06	false	2023-11-09 08:54:21	2023-11-09 08:54:21	NA	false	NA	NA	NA	CPP
deecdfbf-e226-426e-be86-880f40ce6655	e9183816-bd10-4560-941c-0dad67f976f9	Post	NA	false	2023-11-24 15:15:37	2023-11-24 15:15:38	NA	true	NA	NA	NA	CPP
f0c1e404-f1a9-4ac2-84cc-c9e58e74bcee	a7c93fe5-7da3-40b5-a841-ee8083061bd2	Email	2023-11-23	false	2023-11-24 14:40:31	2023-11-24 14:40:31	NA	false	NA	NA	NA	CPP
a9c84d62-444d-4982-bfc3-4156c1693f41	096fc44c-19fc-41e6-8144-d2b7c6c593d3	Email	2023-11-14	false	2023-11-15 08:12:24	2023-11-15 08:12:24	NA	false	NA	NA	NA	CPP
e1a95590-cd4f-4ed1-9a62-abcf40027907	e7555780-e77e-45ab-8b3f-799e2d9d36b7	Email	2023-11-20	false	2023-11-20 12:57:50	2023-11-20 12:57:50	NA	false	NA	NA	NA	CPP

53. L0_CPP_stgCPPDefendantsMatched

id	defendant_id	matched_defendant_id	matched_flag	last_modified_ts	last_updated_ts	source_system_type_code
0eb8c44f-e32b-4107-8d68-1e2adb86ac7d	7d467e4b-b2da-4a96-bd60-472d76547747	e7b62b0c-db13-4e17-84e9-250637564d10	true	2022-03-24 09:33:40	2022-03-24 09:33:40	CPP
a154021a-1dd3-4e82-865d-6ba835069ece	bbc34360-29ef-4747-8e9e-baa37712e9a8	fe6929b3-a523-4259-a758-319495ac3449	true	2022-03-02 14:23:44	2022-03-02 14:23:44	CPP
b6846a4a-e730-4ba9-b707-52ed4793838a	201478b3-9f08-4016-a6e1-f99bba9f7f04	2a7ef2a9-4e15-43c5-b8a9-0e93432cd259	true	2022-03-09 19:30:25	2022-03-09 19:30:25	CPP
3184ee05-487d-4a27-bd49-df304dbf2c46	f3e89644-8dcc-49c7-9a20-dffdfed79136	59c03692-1076-4239-8ebb-86b06aa9dd1d	true	2022-06-18 10:43:46	2022-06-18 10:43:47	CPP
2f65e93a-002c-46dd-a225-308df114178e	57e68455-e213-43a0-b7b4-95a96fb5b43a	a4b5d3b6-739e-4d08-9e13-8d7a21c399d1	true	2022-04-11 06:41:31	2022-04-11 06:41:32	CPP

54. L0_CPP_stgCPPDefendantEmployer

id	defendant_id	employee_ref	employer_name	employer_phone	address1	address2	address3	address4	address5	postcode	upd_by_online_plea	last_modified_ts	incorporation_number	registered_charity_number	home_telephone	mobile	work_telephone	fax	email	email_secondary	last_updated_ts	source_system_type_code
03954637-da65-46aa-b1e8-a26119a0e8d6	53fbede3-8906-458b-8ff5-92a52e05ae9a	NA	Fitter	NA	D B Cargo	Lakeside Business Park	Carolina Way	Doncaster	NA	DN4 5PN	NA	2022-02-03 11:14:47	NA	NA	NA	NA	NA	NA	NA	NA	2022-02-03 11:14:47	CPP
e43408d1-7e2e-4e11-90a4-7c5deb6880fe	4011f83d-7790-4d41-9b05-5ca5215a7a6c	NA	KAMO INVESTMENTS	NA	1 SPRING MEWS	NA	NA	LONDON	NA	W1U 6AS	NA	2022-02-15 17:18:16	NA	NA	NA	NA	NA	NA	NA	NA	2022-02-15 17:18:16	CPP
4f5b7a75-2c29-44c8-be09-cd0fbb779750	fe6fda56-220d-4215-ae28-f8155af6a36e	NA	BHRUT	NA	Rom Valley Way	NA	Romford	NA	NA	RM7 0AG	true	2023-11-25 00:23:40	NA	NA	NA	NA	NA	NA	NA	NA	2023-11-25 00:23:41	CPP
d47edcbe-a93e-4e3e-9878-85e8ba1a2bc2	c9d06d40-a8aa-4d46-86b7-65a44688830c	045000115	Bonfiglioli UK Limited	NA	Unit 1, Calver Quay	Calver Road	Warrington	NA	NA	WA2 8UD	true	2023-11-11 11:41:13	NA	NA	NA	NA	NA	NA	NA	NA	2023-11-11 11:41:13	CPP
f0df830a-d11f-4680-a029-4cfca648e116	3502ba48-3ac7-47b6-9485-a39d50b0d34e	475/JB93558	Engage connect	NA	25 b old brewery lane	NA	henley on thames	NA	NA	RG9 2DE	true	2023-11-14 18:11:07	NA	NA	NA	NA	NA	NA	NA	NA	2023-11-14 18:11:07	CPP

55. L0_CPP_stgCPPHearingEffectiveness

id	hearing_id	trial_type_id	trial_type_code	trial_type	trial_type_description	effective_flag	last_modified_ts	source_system_type_code
003913c7-d82a-4500-8e56-cf39ce1514c4	bbd64571-c6ec-4f87-aa13-784d227d29cb	98f13708-2101-34c4-b568-7be6106a3b84	O2	Ineffective	Advocate fails to attend. Please record the name of the prosecutor and the reason for absence in the comment box.	false	2024-06-27 15:23:31	CPP
004c0f23-55ab-45f5-87fc-15b8c4a7ddf7	0bba102e-82d3-4a04-8daa-0e67c4603578	c4ca4238-a0b9-3382-8dcc-509a6f75849b	A	Cracked	On the date of trial the defendant, for the first time, enters a guilty plea which the prosecution accepts.	false	2024-12-09 14:44:20	CPP
008f9148-5350-40b1-9cca-e8452c7204b8	c048cfe2-f4c2-41ac-a459-f01420f4b965	NA	NA	NA	NA	true	2023-05-03 11:53:35	CPP
00ddaa69-65fc-4cdc-858a-ce1b33b03d13	9fbfaac4-e2a9-46b8-8f3e-4ee0412bf4b0	19ca14e7-ea63-38a4-ae0e-b13d585e4c22	W3	Ineffective	The case could not be heard for trial because it was a floating / backer / reserve case and was not reached because other cases did not drop out of the list.	false	2023-12-05 14:55:30	CPP
011d083a-9bb3-4550-ad5a-92a861e85fdb	249ece8a-81fa-46ca-a381-e8da7eea590f	c4ca4238-a0b9-3382-8dcc-509a6f75849b	A	Cracked	On the date of trial the defendant, for the first time, enters a guilty plea which the prosecution accepts.	false	2023-02-01 11:06:34	CPP

56. L0_CPP_stgCPPSPICaseError

id	case_id	initiation_code	originating_organisation	prosecuting_authority	urn	police_system_id	last_modified_ts	last_updated_ts	source_system_type_code
184e1c7a-d598-4e1c-b2bb-9c67db817fb0	23aed891-7f84-4336-811b-616df86243c1	Q	007EZ15	007EZ15	07EZ0317022	00701NicheRMS	2022-04-22 12:48:52	2022-04-22 12:48:53	CPP
243ab167-2a9f-4674-a61b-f82d5810a80c	267a5209-982a-407d-929e-c05b0e713a7d	Q	001HQ00	001HQ00	01XH0412921	00101PoliceCaseSystem	2022-03-31 19:34:49	2022-03-31 19:34:50	CPP
30ea729a-ccb2-4e71-9db6-1752c9c36b7e	e76f8e32-c77f-4143-8559-c82734d755e2	C	001HQ00	001HQ00	01TX0102822	00101PoliceCaseSystem	2022-04-02 11:27:32	2022-04-02 11:27:32	CPP
3cc51425-3ecd-482d-9417-d89ecca6b7a8	f8f54c6f-76e3-4122-af34-ea0d99acd93c	Q	152SG00	152SG00	52SG0238921	05201NicheRMS	2022-04-01 11:50:10	2022-04-01 11:50:11	CPP
626b9643-1554-483b-9a56-86b1f40512ac	eeb960a0-68c2-4d9d-9ba3-9b3b4c0a0466	C	121CL00	121CL00	21CL0771922	02101NicheRMS	2022-04-19 09:48:57	2022-04-19 09:48:57	CPP

57. L0_CPP_stgCPPHearingResultAdmendment

id	hearing_id	result_line_id	result_ref_id	prev_shared_date	curr_shared_date	amendment_date	amendment_reason_id	deleted_flag	last_modified_ts	last_updated_ts	source_system_type_code
0002d2e7-09d3-4307-aeda-f0fd011cf420	5858bb07-fd28-407b-88b4-6cd78228d699	b5a83a94-942a-434a-8d63-bbf2599136bd	e866cd11-6073-4fdf-a229-51c9d694e1d0	2024-07-26	NA	2024-08-02	ca8b8285-5fc7-3b36-aa78-ecdf5ac6dad0	false	2024-08-02 12:05:13	2024-08-02 12:05:13	CPP
000373de-b9d0-46e3-a104-7fedd9c79041	0332d666-46a6-4b2a-a5ae-afc93e2b3603	6cc06c97-c098-4bfa-8c65-278417c0a090	fbed768b-ee95-4434-87c8-e81cbc8d24c8	2024-08-19	NA	2024-08-21	ca8b8285-5fc7-3b36-aa78-ecdf5ac6dad0	false	2024-08-21 08:02:10	2024-08-21 08:02:10	CPP
0003ed91-864e-4ebe-978f-c048a16d763c	c0d2ec79-9081-44d7-9682-0b46835aa520	4017143c-d73c-4252-a3a0-2b9b1c15c41c	fbed768b-ee95-4434-87c8-e81cbc8d24c8	2024-11-01	NA	2024-11-01	a02018a1-915c-3343-95ad-abc5f99b339a	false	2024-11-01 16:29:45	2024-11-01 16:29:45	CPP
000510a7-97e3-42a0-9a57-d65a0ef54715	f10afa2d-c114-4550-90ae-5cc824572e6d	43d21246-6e30-4f3b-b8b2-edd777306a78	4c79ea50-6e14-4c47-8836-c0d0f647e45a	2024-11-28	NA	2024-11-28	ca8b8285-5fc7-3b36-aa78-ecdf5ac6dad0	false	2024-11-28 10:43:09	2024-11-28 10:43:09	CPP
0005aa0b-b96f-48f9-8545-196ea27587ce	315cbc20-410e-4e18-b6a6-20c44cb09e6a	e76cc09a-0d97-4773-b51e-e59c5301505b	d076bd4a-17d5-4720-899a-1c6f96e3b35f	2024-10-01	NA	2024-10-25	ca8b8285-5fc7-3b36-aa78-ecdf5ac6dad0	true	2024-10-25 09:59:38	2024-10-25 09:59:39	CPP

58. L0_CPP_stgCPPOffenceResult

offence_result_id	register_text	result_rd_id	offence_decision_id	is_collection_order_yn	last_modified_ts	verdict	result_code	last_updated_ts	source_system_type_code
0460a27d-a4f9-4177-872f-fdf9fe6be58e	£220	8da018ef-1f0d-4afb-acc2-7514ed6fd3a2	9c2f7d9d-7b4d-4fa2-90aa-0e88c5b09ee1	N	2022-03-10 15:41:24	NA	EXPEN	2022-03-10 15:41:25	CPP
0507a94a-dcba-461a-beac-e1d871bc1ba3	£34	58a12d7d-81f5-473a-8c7d-3d19cfe3e781	0ca0eb35-a456-409f-9e13-369c30478266	Y	2022-03-30 13:57:22	NA	FVS	2022-03-30 13:57:23	CPP
07083432-eb2a-409a-aa3e-46b6cfb52d7f	Pay directly to court. No information from defendant	bbabf61c-aa80-4b0f-8e93-77c873210217	21fb3500-e38b-4910-830e-c7de637bb15c	Y	2022-03-10 10:20:18	NA	COLLO	2022-03-10 10:20:19	CPP
07507458-971b-46eb-b5f3-7824dd456e71	£20.84	6b92cb52-24c8-4b44-b29f-82971a640bb0	17dcca55-10b7-4a6f-8ccc-c38806134d6f	N	2022-03-15 20:25:20	NA	FVEBD	2022-03-15 20:25:20	CPP
093f002e-ffb5-47f4-a59c-7522a1a88ede	£85	b6996db3-cafd-473a-9e94-9060478e5ccd	23e8384e-dd8e-4df1-96b8-67790042eadf	Y	2022-03-11 14:29:53	NA	FCOST	2022-03-11 14:29:53	CPP

59. L0_CPP_stgCPPCaseDocument

id	received_ts	upload_ts	document_id	document_name	sent_to_cps	financial_means_present	document_type_id	case_id	is_removed	is_cps_case	last_modified_ts	last_updated_ts	source_system_type_code
000039c5-af40-42a9-bb62-73f33c0cc539	2022-03-28 11:34:24	2022-03-28 11:34:44	843b3334-1bad-4c92-babe-7f170cdfc7fe	JORDAN HILL_Charges	false	false	460f7ec0-c002-11e8-a355-529269fb1459	186289b4-90a7-4753-bade-e579ddc057fd	false	false	2022-03-28 11:34:45	2022-03-28 11:34:45	CPP
00041f60-1a0a-444e-8fa9-c41daa8137ab	2023-01-17 10:12:49	2023-01-17 10:12:56	b09dda80-2ef4-45ba-a0d4-6441e3b7a305	Transcripts ABE interviews	false	false	460f937e-c002-11e8-a355-529269fb1459	2c6d10c4-f636-48f3-b072-1169fb4fa29e	false	false	2023-01-17 10:12:56	2023-01-17 10:12:57	CPP
000508a2-4030-4389-b792-9d3ce5979c7a	2023-04-14 08:47:04	2023-04-14 08:47:20	487d5d89-375c-4177-a367-58170ef1b43e	Michael WALTON	false	false	460f851e-c002-11e8-a355-529269fb1459	037c24ab-610d-41c9-b961-44dc8856cd76	false	false	2023-04-14 08:47:20	2023-04-14 08:47:20	CPP
00051a1e-bc50-4573-b481-817cbcca92db	2022-09-10 09:48:33	2022-09-10 09:48:38	29cb191e-cbe6-439b-9c1d-947ddf4624f3	Key Exhibits	false	false	460f8c80-c002-11e8-a355-529269fb1459	579fa2c1-3e83-494c-acf7-d06f9a447fa3	false	false	2022-09-10 09:48:38	2022-09-10 09:48:38	CPP
000649a7-31ff-43c3-af99-35291e7ee1d5	2021-11-29 00:00:00	2021-11-29 07:47:40	2905901d-fe83-48cc-b154-e7b8f2f4cb2c	PSR Stevens	false	false	460fb0ca-c002-11e8-a355-529269fb1459	13380bd4-b964-4689-b788-9a1e315fa18a	false	false	2021-11-29 07:47:40	2021-11-29 07:47:40	CPP

60. L0_CPP_stgCPPCaseLinkSplitMerge

id	case_id	linked_case_id	link_type	lsm_reference	last_modified_ts	last_updated_ts	source_system_type_code
972f9157-c5f4-41a8-8169-b71bb9909082	1084d84b-18ee-4527-9c02-23202fae2f67	688cab57-c68a-4503-96b7-6f0520e43606	LINK	NA	2024-08-09 11:58:46	2024-08-09 11:58:46	CPP
5dceca3d-9843-4d9d-9cc9-bb0d3a7a8341	758422d2-a13c-4ecf-8657-f67698c2ec53	4aa98639-3fbc-4255-bd9e-1b8105fe14aa	MERGE	01MP1108124	2024-08-09 13:16:23	2024-08-09 13:16:23	CPP
5348c8e4-e64b-47cc-a24a-ceb0d13f2bbf	6c5bac81-6053-4db8-a6db-b9f5f43cde28	63ee8e5b-11f8-491c-b2a9-d16da3c1282c	LINK	NA	2024-08-09 10:19:27	2024-08-09 10:19:27	CPP
50f1cdda-d36f-4213-8d81-3df82cb0b3ae	688cab57-c68a-4503-96b7-6f0520e43606	1084d84b-18ee-4527-9c02-23202fae2f67	LINK	NA	2024-08-09 11:58:46	2024-08-09 11:58:46	CPP
b7b00965-004e-40ec-a145-d951df65bb82	1084d84b-18ee-4527-9c02-23202fae2f67	a068a8d8-81d2-4623-8c61-73cdc29a3c91	LINK	NA	2024-08-09 11:59:46	2024-08-09 11:59:46	CPP

61. L0_CPP_stgCPPHearingDate

id	hearing_id	hearing_date	last_modified_ts	start_time	end_time	duration_mins	allocated_seq_num	listed_duration_mins	listed_sequence	last_updated_ts	reallocated_flag	court_id	court_room_id	cancelled_flag	source_system_type_code
0000f487-dcfc-301d-b83a-0572edaf8f84	e7b2f230-0e99-434d-876a-fd8d692dee10	2024-06-19	2024-06-18 08:09:48	2024-06-19 07:00:00	2024-06-19 07:30:00	30	1	30	0	2024-06-18 14:13:43	true	997a2349-58a9-38c8-a225-9346b30b03a9	4856d732-3ca7-3fdd-a361-e473ee8a3961	false	CPP
00016200-92cc-3de2-b529-a4c576ab23e5	a071a565-7751-401d-bbe9-5597b5f348f0	2024-10-07	2024-08-14 15:45:06	2024-10-07 09:30:00	2024-10-08 03:30:00	1080	0	NA	NA	2024-08-14 15:45:06	NA	ac2a72fd-1131-3e18-a84f-0dfe82d70d7a	NA	false	CPP
00036278-16bb-3af3-819b-caf096edfa32	138b4e4f-c579-4eba-82c1-1c6398dacb07	2023-08-29	2023-07-21 08:58:16	2023-08-29 13:00:00	2023-08-29 13:10:00	10	1	10	0	2023-08-09 14:50:00	true	dbb2a246-6d75-330c-83df-a13670e3f8fc	62035db2-11bd-375c-8f11-67987916088f	false	CPP
000677f2-7b36-3966-b90c-f55164bb0e17	5486028e-3d04-45f2-a25d-1ab7f5bae763	2024-03-12	2024-03-11 15:19:23	2024-03-12 10:00:00	2024-03-12 10:30:00	30	2	30	2	2024-03-12 12:27:26	NA	f4b70f24-131b-32a3-b901-342082bf9615	b1f12846-9cd8-38ed-abe2-152d79098588	false	CPP
00096df3-c8b0-3b38-9895-05efce42640a	6522baa9-4f23-49b0-9d98-8be1c38faa4c	2024-06-06	2024-06-06 08:01:52	2024-06-06 09:00:00	2024-06-06 09:30:00	30	6	30	6	2024-06-06 11:08:32	NA	328b735a-8c89-3ae8-9d47-139be8ff60af	c162359f-c8c9-3749-8864-d5d89ff77614	false	CPP

62. L0_CPP_stgCPPCaseNote

id	case_id	created_ts	note_detail	last_modified_ts	last_updated_ts	source_system_type_code
00319692-4a22-4a60-93cc-79875e7594f5	0928b514-fc2a-41e5-9e74-a75c8a507128	2023-04-05 11:42:38	CTSC: defendant copy of restraining order sent by email to prison	2023-04-05 11:42:38	2023-04-05 11:42:38	CPP
0076f45d-9619-43d9-a3db-d79e08f9a34a	cc738e2c-3af1-4e63-a8b6-8ae303a8958b	2023-04-25 08:12:04	CVP application form for witness two. Received on 25th April 2023 at 09.58.	2023-04-25 08:12:04	2023-04-25 08:12:04	CPP
00ab89a9-ce97-4d87-9081-308eb3d2d987	5df1398d-ee75-4d3b-92db-523d4fc5c3c1	2023-05-08 09:58:31	CTSC - IDPC Bundle received, attached to case materials.	2023-05-08 09:58:31	2023-05-08 09:58:31	CPP
01750ba4-8eea-456f-ac3d-5ad6dff4592b	74f0a6fe-ed19-4541-ac02-cced6a8d9136	2023-03-06 14:34:32	Bad Character Evidence uploaded and Court notified.	2023-03-06 14:34:32	2023-03-06 14:34:32	CPP
0217b56a-44e5-4558-8710-04094db61dde	c044bc07-1303-4e34-ac3a-be7c26e12ba7	2023-05-10 10:15:30	bad character application fwd to court and uploaded to case materials	2023-05-10 10:15:30	2023-05-10 10:15:30	CPP

63. L0_CPP_stgCPPScanDocument

id	envelope_id	document_name	file_name	prosecution_authority_id	prosecution_authority_code	case_urn	case_pti_urn	scanning_date	document_status	status_updated_date	last_modified_ts	flagged_for_followup_date	auto_actioned_date	manually_actioned_date	rejected_date	case_detail_updated_flag	case_detail_updated_date	actioned_by	expired_date	last_updated_ts	source_system_type_code
041172ea-2eb5-40b7-9b0b-86ef7ec7bf8b	b7ba9116-94d7-4e84-8d97-91e9b71f7b2c	Single Justice Procedure Notice - Plea (Single)	21356040110160001.pdf	GAEAA01	TVL	TVL506108357C	NA	2021-12-22 13:55:50	MANUALLY_ACTIONED	2021-12-23 10:12:44	2021-12-23 10:12:44	NA	NA	2021-12-23 10:12:44	NA	NA	NA	a291b51e-8641-4cff-9bba-4daad352e6ef	NA	2021-12-23 10:12:44	CPP
0c1393aa-14ce-44fe-835a-cf17641075bd	8c2f81ad-bbfd-4b45-94ed-27a60f0b2863	SJPMC100	21355040105920002.pdf	NA	NA	NA	NA	2021-12-21 10:11:56	MANUALLY_ACTIONED	2021-12-21 12:52:03	2021-12-21 12:52:03	NA	NA	2021-12-21 12:52:03	NA	NA	NA	a291b51e-8641-4cff-9bba-4daad352e6ef	NA	2021-12-21 12:52:03	CPP
1638f579-4a7d-43bd-adb4-8d04d3817c58	ac640f81-7734-482d-8fd3-e50921fd51b5	Single Justice Procedure Notice - Plea (Single)	21330040108920001.pdf	GAEAA01	TVL	TVL602107559C	NA	2021-11-26 13:13:27	AUTO_ACTIONED	2021-11-26 13:13:57	2021-11-26 13:13:59	NA	2021-11-26 13:13:57	NA	NA	true	2021-11-26 13:13:59	06e8e262-d672-4512-8fe0-7d4d65f89199	NA	2021-11-26 13:14:00	CPP
17a70110-cb53-4f4c-8ab3-6e35af1e3923	8a418dec-585d-419f-87d6-8ce676d30cb8	Single Justice Procedure Notice - Plea (Single)	21358040105450001.pdf	NA	NA	NA	NA	2021-12-24 10:13:43	MANUALLY_ACTIONED	2021-12-29 13:27:31	2021-12-29 13:27:31	NA	NA	2021-12-29 13:27:31	NA	NA	NA	a291b51e-8641-4cff-9bba-4daad352e6ef	NA	2021-12-29 13:27:32	CPP
27c3c7b6-3231-4dfa-b3ce-f259b4e158b6	903b9a99-4890-4831-8ae3-4db811fd6ce5	SJPN	21319900300210001.pdf	0440000	HIWPF	44FZ0242521	44FZ0242521	2021-11-02 12:00:40	AUTO_ACTIONED	2021-11-02 12:06:31	2021-11-02 12:06:31	NA	2021-11-02 12:06:31	NA	NA	NA	NA	06e8e262-d672-4512-8fe0-7d4d65f89199	NA	2021-11-02 12:06:31	CPP

64. L0_CPP_stgCPPUser

id	first_name	last_name	email	event_stream_version	created_on	changed_on	last_modified_ts	source_system_type_code
00bfefcf-3be9-4183-a68c-e703213ea588	Joseph	Sadler	Joseph.Sadler@met.police.uk	2	2024-02-14 17:46:13	2024-02-14 17:46:13	2024-02-14 17:46:13	CPP
00d9fd8a-a47e-4918-86d1-403d79e9b5cf	Siobhan	White	siobhan.white@chiverssolicitors.co.uk	2	2021-07-27 13:31:02	2021-07-27 13:31:02	2021-07-27 13:31:02	CPP
01b80320-e793-4b91-a8e3-89f29a8751c2	Sharon	Vickers	Sharon.Vickers.jp@ejudiciary.net	3	2023-05-15 08:56:21	2023-05-15 08:56:21	2023-05-15 08:56:21	CPP
029ac771-b7e8-4eb2-a5c1-3efcd3e82677	Sharon	Palmer	sharon.palmer@hampshire.police.uk	2	2021-11-09 09:10:48	2021-11-09 09:10:48	2021-11-09 09:10:48	CPP
036102ca-d4a8-4e6b-b537-a55eec3ab674	Sharon	Ford	sharon.ford@justice.gov.uk	9	2020-09-25 14:34:43	2021-12-13 12:21:23	2021-12-13 12:21:23	CPP

65. L0_CPP_stgCPPCasePerson

case_person_id	case_id	person_id	person_type	last_modified_ts	organisation_id	source_system_type_code
000123ff-835b-48a6-bd9a-6ea4fccb1e32	16689c09-3ca3-4a63-8bf4-7c78fbece087	000123ff-835b-48a6-bd9a-6ea4fccb1e32	DefendantDetail	2021-06-18 15:18:18	NA	CPP
0005affb-28be-41df-9543-84ff32f577d3	a5ebaaad-c753-4c88-9909-bd1b8a94aaed	0005affb-28be-41df-9543-84ff32f577d3	DefendantDetail	2024-01-22 12:19:27	NA	CPP
0011ab07-0c1e-4e43-8358-539637ebd394	4277807d-ff42-42b2-965e-afbbe20151d6	0011ab07-0c1e-4e43-8358-539637ebd394	DefendantDetail	2024-01-09 15:19:46	NA	CPP
0014bc8a-333b-4164-a8df-64c558f8b84f	6fd7a85f-4dd0-460e-9709-e820dd186490	0014bc8a-333b-4164-a8df-64c558f8b84f	DefendantDetail	2023-05-16 15:54:00	NA	CPP
0015a3c1-3ed4-4b90-b3c5-d08f1f06f275	91113aaa-0241-4d74-8b4f-6372a50cade2	0015a3c1-3ed4-4b90-b3c5-d08f1f06f275	DefendantDetail	2023-12-22 10:42:12	NA	CPP

66. L0_CPP_stgCPPCourtSession

id	court_id	court_room_id	session_date	last_modified_ts	last_updated_ts	source_system_type_code
0acf6e0d-3e09-39c4-8ef5-76c582801027	3be4e1f9-36a4-3080-bcb4-6da5975b4d6e	02b56f20-f70c-3b7b-9444-2f34d25df94d	2023-01-19	2023-01-19 12:13:44	2023-01-19 12:13:44	CPP
0c34919f-1751-3883-8439-fd77c6b3bb15	2c45bc8c-f4b3-3163-bf09-f32d80d4b6cb	23d799e0-2655-35a2-a282-7d0c60fb666f	2023-01-13	2023-01-13 15:05:21	2023-01-13 15:05:21	CPP
1f375c43-0d26-3ce6-ad72-5a8aa2285846	e2b8580f-5247-30f9-905f-4b8136b23318	31eae0ce-ed60-389f-b307-9bb07fdabd32	2023-01-05	2023-01-05 09:44:37	2023-01-05 09:44:37	CPP
2464ba3a-6387-336c-b01f-99aa82a37514	b78d02fe-8b45-30f5-8550-e5ee2cd51ec6	f3811fcd-baff-338b-a85e-830660e0ff6c	2023-01-19	2023-01-19 09:28:03	2023-01-19 09:28:04	CPP
422bb2ef-f2d7-3b94-8700-60a0f63c75ba	854248a4-d831-3ac0-a3b6-2f7993be81fb	e72ac892-3790-3a20-9762-b069d63b80be	2023-01-20	2023-01-20 09:28:31	2023-01-20 09:28:31	CPP

67. L0_CPP_stgCPPOrganisation

id	org_type	org_name	incorporation_number	registered_charity_number	address1	address2	address3	address4	address5	post_code	home_telephone	mobile	work_telephone	fax	email	email_secondary	last_modified_ts	last_updated_ts	related_to	source_system_type_code
063640f9-3998-4a6f-bab9-e70277022db7	APPLICATION_ORGANISATION	Midlands Division NPS	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	midlandsnps.court@justice.gov.uk	NA	2025-01-31 15:27:38	2025-01-31 15:27:38	APPLICANT	CPP
0737d50f-bb98-4648-9bad-d68efc90c6d6	APPLICATION_ORGANISATION	The Independent Criminal Law Specialists LLP	NA	NA	Peek House	20, Eastcheap	Monument	London	NA	EC3R 8EE	NA	NA	NA	NA	NA	NA	2025-02-03 10:09:46	2025-02-03 10:09:46	THIRDPARTY	CPP
0a3d8ec3-4354-4166-b45e-a48b0f33d29e	APPLICATION_ORGANISATION	Cartwright King Solicitors	NA	NA	The Old Post Office	Victoria Street	Derby	Derbyshire	NA	DE1 1EQ	NA	NA	NA	NA	NA	NA	2025-02-03 11:38:18	2025-02-03 11:41:53	APPLICANT	CPP
0b815ca0-a3bd-484b-ae21-ccf3f0e18fce	APPLICATION_ORGANISATION	Draycott Browne Solicitors Ltd	NA	NA	12 Oxford Court	Manchester	NA	NA	NA	M2 3WQ	1612282244	NA	NA	NA	manchestermagistratesdept@draycottbrowne.co.uk	NA	2025-02-03 13:12:30	2025-02-03 13:12:30	RESPONDENT	CPP
0d44a8b4-38e4-4eb3-85eb-5c29601e8285	APPLICATION_ORGANISATION	Thames Magistrates’ Court	NA	NA	58 Bow Road	London	NA	NA	NA	E3 4DJ	NA	NA	NA	NA	NA	NA	2025-01-31 17:02:48	2025-01-31 17:02:48	APPLICANT	CPP

68. L0_CPP_stgCPPOrganisationPerson

id	person_id	organisation_id	person_role	last_modified_ts	last_updated_ts	source_system_type_code
f428a232-2298-4f8a-a65c-8d077dd42d2f	f428a232-2298-4f8a-a65c-8d077dd42d2f	a40bce7b-7b4a-4acf-9815-c3b0081e0f4c	Senior Secretary	2024-09-03 10:20:59	2024-09-03 10:20:59	CPP
04fecd40-362a-4ea1-a06a-8ba650783676	04fecd40-362a-4ea1-a06a-8ba650783676	771c58c2-1415-467d-9597-c24db701dd10	Solicitor	2024-09-03 10:20:59	2024-09-03 10:20:59	CPP
aab73d79-fee6-4a7a-ad42-8db78359ac7a	aab73d79-fee6-4a7a-ad42-8db78359ac7a	b4ee9f3f-6059-4282-a5c9-92de36a9e85b	NA	2024-09-03 10:31:45	2024-09-03 10:31:45	CPP
ab1e996c-661d-4801-8111-a68739fe4fdd	ab1e996c-661d-4801-8111-a68739fe4fdd	e9c5da92-e361-4837-bd82-3ecd5a6fb546	NA	2024-08-30 11:37:58	2024-08-30 11:37:58	CPP
d3a55a7c-7c3c-433f-ae86-a3d1d26ee6c2	d3a55a7c-7c3c-433f-ae86-a3d1d26ee6c2	87050db5-c95d-41bd-8367-7bb7a2573772	NA	2024-09-02 14:59:07	2024-09-02 14:59:07	CPP