home / nhsadmin

nhsadmin

Custom SQL query returning 101 rows

This data as .json

rowidPractitioner CodeParent Organisation CodeParent Organisation TypeJoin Parent DateLeft Parent DateAmended Record Indicator
1 G0102005 H81600 P 1974-04-01 00:00:00 1991-04-01 00:00:00 0
2 G0102926 D81001 P 1974-04-01 00:00:00 1991-12-31 00:00:00 0
3 G0105912 E83600 P 1974-04-01 00:00:00 1992-07-31 00:00:00 0
4 G0107031 P82013 P 1974-04-01 00:00:00 1991-05-25 00:00:00 0
5 G0107275 G85059 P 1974-04-01 00:00:00 1991-04-02 00:00:00 0
6 G0107275 H85681 P 1991-04-03 00:00:00 1996-04-17 00:00:00 0
7 G0107725 B81600 P 1974-04-01 00:00:00 1994-04-09 00:00:00 0
8 G0108018 H81083 P 1974-04-01 00:00:00 1992-01-02 00:00:00 0
9 G0108180 G85601 P 1974-04-01 00:00:00 1995-06-11 00:00:00 0
10 G0108324 A81001 P 1974-04-01 00:00:00 1991-07-01 00:00:00 0
11 G0108348 M85601 P 1974-04-01 00:00:00 1991-08-09 00:00:00 0
12 G0108867 L84040 P 1974-04-01 00:00:00 1993-04-27 00:00:00 0
13 G0108922 F83013 P 1974-04-01 00:00:00 1995-11-02 00:00:00 0
14 G0108953 G85003 P 1974-04-01 00:00:00 1992-03-31 00:00:00 0
15 G0109325 H85016 P 1974-04-01 00:00:00 1992-05-01 00:00:00 0
16 G0109459 H83001 P 1974-04-01 00:00:00 1995-07-27 00:00:00 0
17 G0109497 H84600 P 1974-04-01 00:00:00 1993-08-01 00:00:00 0
18 G0109590 F82006 P 1974-04-01 00:00:00 2003-02-28 00:00:00 0
19 G0109662 A83070 P 1974-04-01 00:00:00 1991-09-01 00:00:00 0
20 G0109693 M85009 P 1974-04-01 00:00:00 1991-05-06 00:00:00 0
21 G0109741 B86049 P 1974-04-01 00:00:00 1999-12-06 00:00:00 0
22 G0109772 M85004 P 1974-04-01 00:00:00 1992-06-30 00:00:00 0
23 G0109806 C81034 P 1974-04-01 00:00:00 1991-10-13 00:00:00 0
24 G0109923 P81600 P 1974-04-01 00:00:00 1992-03-31 00:00:00 0
25 G0109930 F82006 P 1974-04-01 00:00:00 1996-06-30 00:00:00 0
26 G0110017 N81006 P 1974-04-01 00:00:00 1995-07-31 00:00:00 0
27 G0110031 E84600 P 1974-04-01 00:00:00 1993-06-30 00:00:00 0
28 G0110062 F84041 P 1974-04-01 00:00:00 1991-12-31 00:00:00 0
29 G0110134 B81013 P 1974-04-01 00:00:00 1995-09-03 00:00:00 0
30 G0110158 A86017 P 1974-04-01 00:00:00 1994-07-03 00:00:00 0
31 G0110268 M82002 P 1974-04-01 00:00:00 1995-02-01 00:00:00 0
32 G0110361 F81036 P 1974-04-01 00:00:00 1994-03-31 00:00:00 0
33 G0110464 E82027 P 1974-04-01 00:00:00 1995-10-01 00:00:00 0
34 G0110529 C83634 P 1988-02-01 00:00:00 1993-10-04 00:00:00 0
35 G0110615 J82033 P 1974-04-01 00:00:00 1992-07-03 00:00:00 0
36 G0110691 G82013 P 1974-04-01 00:00:00 1995-09-01 00:00:00 0
37 G0201265 P84016 P 1974-04-01 00:00:00 1991-04-01 00:00:00 0
38 G0205582 P92010 P 1974-04-01 00:00:00 1991-04-01 00:00:00 0
39 G0215455 B87005 P 1974-04-01 00:00:00 1991-11-04 00:00:00 0
40 G0217433 E87604 P 1974-04-01 00:00:00 1991-04-01 00:00:00 0
41 G0218616 P86003 P 1974-04-01 00:00:00 1991-10-09 00:00:00 0
42 G0218843 P83005 P 1974-04-01 00:00:00 1992-05-02 00:00:00 0
43 G0219332 G81667 P 1974-04-01 00:00:00 1991-06-16 00:00:00 0
44 G0219741 B86022 P 1974-04-01 00:00:00 1992-06-30 00:00:00 0
45 G0220378 H82600 P 1974-04-01 00:00:00 1992-06-12 00:00:00 0
46 G0223072 B86007 P 1974-04-01 00:00:00 1991-11-10 00:00:00 0
47 G0224523 N82079 P 1974-04-01 00:00:00 1992-02-08 00:00:00 0
48 G0225225 K83069 P 1974-04-01 00:00:00 1995-09-02 00:00:00 0
49 G0225328 L82068 P 1985-08-16 00:00:00 1992-03-18 00:00:00 0
50 G0225483 P84052 P 1974-04-01 00:00:00 1992-06-30 00:00:00 0
51 G0225517 H83030 P 1974-04-01 00:00:00 1992-01-30 00:00:00 0
52 G0225610 B87029 P 1974-04-01 00:00:00 1991-06-30 00:00:00 0
53 G0225689 L81062 P 1974-04-01 00:00:00 1991-12-31 00:00:00 0
54 G0225706 P81082 P 1974-04-01 00:00:00 1993-12-31 00:00:00 0
55 G0226068 F85071 P 1974-04-01 00:00:00 1993-06-04 00:00:00 0
56 G0226288 G85005 P 1974-04-01 00:00:00 1992-06-01 00:00:00 0
57 G0226343 L82006 P 1974-04-01 00:00:00 1991-04-05 00:00:00 0
58 G0226680 E85033 P 1974-04-01 00:00:00 1995-12-25 00:00:00 0
59 G0227708 F86084 P 1974-04-01 00:00:00 1993-06-11 00:00:00 0
60 G0227825 L84003 P 1974-04-01 00:00:00 1992-04-05 00:00:00 0
61 G0228101 J81064 P 1974-04-01 00:00:00 1992-01-01 00:00:00 0
62 G0228383 H83600 P 1974-04-01 00:00:00 1998-07-01 00:00:00 0
63 G0228723 F81600 P 1974-04-01 00:00:00 1991-06-30 00:00:00 0
64 G0228967 M81005 P 1974-04-01 00:00:00 1994-04-01 00:00:00 0
65 G0228967 M81632 P 1994-04-02 00:00:00 1994-09-30 00:00:00 0
66 G0229023 B86603 P 1974-04-01 00:00:00 1991-09-30 00:00:00 0
67 G0229061 P92600 P 1974-04-01 00:00:00 1996-02-29 00:00:00 0
68 G0229171 C84002 P 1974-04-01 00:00:00 1994-06-04 00:00:00 0
69 G0229212 A86030 P 1974-04-01 00:00:00 1994-04-04 00:00:00 0
70 G0229236 W92002 P 1974-04-01 00:00:00 1991-09-30 00:00:00 0
71 G0229308 K81056 P 1974-04-01 00:00:00 1994-01-31 00:00:00 0
72 G0229391 F86602 P 1974-04-01 00:00:00 1995-05-28 00:00:00 0
73 G0229449 K83052 P 1974-04-01 00:00:00 1992-08-31 00:00:00 0
74 G0229456 N81020 P 1974-04-01 00:00:00 1993-10-02 00:00:00 0
75 G0229470 P81025 P 1974-04-01 00:00:00 1995-05-16 00:00:00 0
76 G0229487 K83004 P 1974-04-01 00:00:00 1993-03-31 00:00:00 0
77 G0229535 L81009 P 1974-04-01 00:00:00 1991-04-01 00:00:00 0
78 G0229597 B87004 P 1974-04-01 00:00:00 1993-10-03 00:00:00 0
79 G0229607 E83016 P 1974-04-01 00:00:00 1994-04-04 00:00:00 0
80 G0229676 G85008 P 1974-04-01 00:00:00 1993-04-30 00:00:00 0
81 G0229748 K84013 P 1974-04-01 00:00:00 1992-09-30 00:00:00 0
82 G0229755 W98006 P 1974-04-01 00:00:00 1993-10-03 00:00:00 0
83 G0229786 J83001 P 1974-04-01 00:00:00 1991-06-30 00:00:00 0
84 G0229841 A85016 P 1974-04-01 00:00:00 1991-09-30 00:00:00 0
85 G0229968 M85100 P 1974-04-01 00:00:00 1994-02-28 00:00:00 0
86 G0230038 B86004 P 1974-04-01 00:00:00 1998-11-08 00:00:00 0
87 G0230069 W93004 P 1974-04-01 00:00:00 1995-04-30 00:00:00 0
88 G0230076 M89015 P 1974-04-01 00:00:00 1992-03-31 00:00:00 0
89 G0230124 H81033 P 1974-04-01 00:00:00 1991-04-05 00:00:00 0
90 G0230155 N85040 P 1974-04-01 00:00:00 1992-09-30 00:00:00 0
91 G0230179 C88600 P 1974-04-01 00:00:00 1991-12-31 00:00:00 0
92 G0230186 G83007 P 1974-04-01 00:00:00 1991-06-30 00:00:00 0
93 G0230351 P84017 P 1974-04-01 00:00:00 1991-08-03 00:00:00 0
94 G0230409 B81003 P 1974-04-01 00:00:00 1994-08-09 00:00:00 0
95 G0230423 M85011 P 1974-04-01 00:00:00 1994-11-30 00:00:00 0
96 G0230526 M83600 P 1974-04-01 00:00:00 1994-03-31 00:00:00 0
97 G0230526 M81041 P 2006-09-01 00:00:00   0
98 G0230557 A81005 P 1974-04-01 00:00:00 1991-07-01 00:00:00 0
99 G0230650 E85600 P 1974-04-01 00:00:00 1998-11-16 00:00:00 0
100 G0230753 E82061 P 1974-04-01 00:00:00 1993-07-02 00:00:00 0
101 G0230856 A83040 P 1974-04-01 00:00:00 1992-01-05 00:00:00 0
Powered by Datasette · Query took 1.25ms · Data source: OUseful Databeat