home / nhsadmin

nhsadmin

Custom SQL query returning 101 rows

This data as .json

rowidOrganisation CodeParent Organisation CodeParent Organisation TypeJoin Parent DateLeft Parent DateAmended Record Indicator
1 A81001 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
2 A81001 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
3 A81001 00K W 2013-04-01 00:00:00   0
4 A81002 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
5 A81002 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
6 A81002 00K W 2013-04-01 00:00:00   0
7 A81003 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
8 A81003 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
9 A81003 00K W 2013-04-01 00:00:00   0
10 A81004 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
11 A81004 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
12 A81004 00M W 2013-04-01 00:00:00   0
13 A81005 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
14 A81005 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
15 A81005 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
16 A81005 00M W 2013-04-01 00:00:00   0
17 A81006 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
18 A81006 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
19 A81006 00K W 2013-04-01 00:00:00   0
20 A81007 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
21 A81007 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
22 A81007 00K W 2013-04-01 00:00:00   0
23 A81008 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
24 A81008 5KM W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
25 A81008 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
26 A81008 00M W 2013-04-01 00:00:00   0
27 A81009 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
28 A81009 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
29 A81009 00M W 2013-04-01 00:00:00   0
30 A81010 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
31 A81010 5D9 W 2001-04-01 00:00:00 2012-09-30 00:00:00 0
32 A81011 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
33 A81011 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
34 A81011 00K W 2013-04-01 00:00:00   0
35 A81012 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
36 A81012 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
37 A81012 00M W 2013-04-01 00:00:00   0
38 A81013 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
39 A81013 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
40 A81013 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
41 A81013 00M W 2013-04-01 00:00:00   0
42 A81014 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
43 A81014 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
44 A81014 00K W 2013-04-01 00:00:00   0
45 A81015 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
46 A81015 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
47 A81015 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
48 A81015 00M W 2013-04-01 00:00:00   0
49 A81016 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
50 A81016 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
51 A81016 00M W 2013-04-01 00:00:00   0
52 A81017 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
53 A81017 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
54 A81017 00K W 2013-04-01 00:00:00   0
55 A81018 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
56 A81018 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
57 A81018 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
58 A81018 00M W 2013-04-01 00:00:00   0
59 A81019 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
60 A81019 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
61 A81019 00M W 2013-04-01 00:00:00   0
62 A81020 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
63 A81020 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
64 A81020 00M W 2013-04-01 00:00:00   0
65 A81021 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
66 A81021 5KM W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
67 A81021 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
68 A81021 00M W 2013-04-01 00:00:00   0
69 A81022 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
70 A81022 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
71 A81022 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
72 A81022 00M W 2013-04-01 00:00:00   0
73 A81023 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
74 A81023 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
75 A81023 00M W 2013-04-01 00:00:00   0
76 A81025 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
77 A81025 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
78 A81025 00K W 2013-04-01 00:00:00   0
79 A81026 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
80 A81026 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
81 A81026 00M W 2013-04-01 00:00:00   0
82 A81027 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
83 A81027 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
84 A81027 00K W 2013-04-01 00:00:00   0
85 A81029 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
86 A81029 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
87 A81029 00M W 2013-04-01 00:00:00   0
88 A81030 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
89 A81030 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
90 A81030 00M W 2013-04-01 00:00:00   0
91 A81031 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
92 A81031 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
93 A81031 00K W 2013-04-01 00:00:00   0
94 A81032 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
95 A81032 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
96 A81032 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
97 A81032 00M W 2013-04-01 00:00:00   0
98 A81033 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
99 A81033 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
100 A81033 00M W 2013-04-01 00:00:00   0
101 A81034 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
Powered by Datasette · Query took 1.288ms · Data source: OUseful Databeat