home / nhsadmin

Current and historical records of membership of practices by GPs

Data source: OUseful Databeat

123,680 rows

View and edit SQL

This data as .json

Link rowid Practitioner Code Parent Organisation Code Parent Organisation Type Join Parent Date Left Parent Date Amended Record Indicator
101 G0230856 A83040 P 1974-04-01 00:00:00 1992-01-05 00:00:00 0
102 G0230863 H81047 P 1974-04-01 00:00:00 1991-04-05 00:00:00 0
103 G0230870 J81601 P 1974-04-01 00:00:00 1995-03-31 00:00:00 0
104 G0230997 P81103 P 1974-04-01 00:00:00 1992-02-14 00:00:00 0
105 G0231015 A81007 P 1974-04-01 00:00:00 1994-04-06 00:00:00 0
106 G0231163 B86009 P 1974-04-01 00:00:00 1993-04-07 00:00:00 0
107 G0231235 G82031 P 1974-04-01 00:00:00 1992-04-05 00:00:00 0
108 G0231486 A86006 P 1974-04-01 00:00:00 1993-10-31 00:00:00 0
109 G0231606 F81006 P 1974-04-01 00:00:00 1993-01-01 00:00:00 0
110 G0231613 C85600 P 1974-04-01 00:00:00 1999-09-27 00:00:00 0
111 G0231620 H81026 P 1974-04-01 00:00:00 1994-03-31 00:00:00 0
112 G0231778 J82014 P 1974-04-01 00:00:00 1991-05-05 00:00:00 0
113 G0231833 L82009 P 1974-04-01 00:00:00 1995-03-31 00:00:00 0
114 G0231864 C82043 P 1974-04-01 00:00:00 1998-03-29 00:00:00 0
115 G0231905 N81011 P 1974-04-01 00:00:00 1997-06-30 00:00:00 0
116 G0231967 P84072 P 1988-11-01 00:00:00 1995-04-30 00:00:00 0
117 G0232009 H81021 P 1974-04-01 00:00:00 1994-08-07 00:00:00 0
118 G0232023 M85070 P 1974-04-01 00:00:00 1995-04-03 00:00:00 0
119 G0232126 J82190 P 1974-04-01 00:00:00 1996-06-30 00:00:00 0
120 G0232157 W91002 P 1974-04-01 00:00:00 1993-01-01 00:00:00 0
121 G0232171 M91004 P 1974-04-01 00:00:00 1992-04-01 00:00:00 0
122 G0232205 C88046 P 1974-04-01 00:00:00 1997-06-30 00:00:00 0
123 G0232229 M87007 P 1974-04-01 00:00:00 1997-05-05 00:00:00 0
124 G0232243 C82111 P 1974-04-01 00:00:00 1992-10-01 00:00:00 0
125 G0232267 M85101 P 1974-04-01 00:00:00 1993-04-02 00:00:00 0
126 G0232298 A84007 P 1974-04-01 00:00:00 1996-10-01 00:00:00 0
127 G0232449 M85102 P 1974-04-01 00:00:00 1998-10-08 00:00:00 0
128 G0232487 N81062 P 1974-04-01 00:00:00 1992-06-30 00:00:00 0
129 G0232494 F83602 P 1974-04-01 00:00:00 1998-05-04 00:00:00 0
130 G0232614 J81017 P 1974-04-01 00:00:00 2000-03-31 00:00:00 0
131 G0232621 F85071 P 1974-04-01 00:00:00 1995-04-06 00:00:00 0
132 G0232717 J82127 P 1974-04-01 00:00:00 1991-07-05 00:00:00 0
133 G0232779 E81003 P 1974-04-01 00:00:00 1998-01-14 00:00:00 0
134 G0232858 N85041 P 1974-04-01 00:00:00 1991-09-30 00:00:00 0
135 G0232872 B84600 P 1974-04-01 00:00:00 1992-09-30 00:00:00 0
136 G0232920 D81006 P 1974-04-01 00:00:00 1991-10-04 00:00:00 0
137 G0232944 H81100 P 1974-04-01 00:00:00 1993-08-15 00:00:00 0
138 G0233062 C88650 P 1990-10-08 00:00:00 1993-03-31 00:00:00 0
139 G0233062 C88653 P 1997-08-25 00:00:00 2002-04-03 00:00:00 0
140 G0233103 H82017 P 1974-04-01 00:00:00 1991-06-30 00:00:00 0
141 G0233110 G81067 P 1974-04-01 00:00:00 1993-04-08 00:00:00 0
142 G0233172 B81014 P 1974-04-01 00:00:00 1991-08-01 00:00:00 0
143 G0233220 M85101 P 1974-04-01 00:00:00 1993-04-02 00:00:00 0
144 G0233309 F86058 P 1974-04-01 00:00:00 1994-01-16 00:00:00 0
145 G0233354 M81048 P 1974-04-01 00:00:00 1993-07-05 00:00:00 0
146 G0233718 D83016 P 1974-04-01 00:00:00 1992-09-04 00:00:00 0
147 G0233756 E87005 P 1974-04-01 00:00:00 1991-10-01 00:00:00 0
148 G0233770 A83054 P 1974-04-01 00:00:00 1995-02-01 00:00:00 0
149 G0233952 P88002 P 1974-04-01 00:00:00 1998-10-09 00:00:00 0
150 G0234018 W91003 P 1974-04-01 00:00:00 1996-08-03 00:00:00 0
151 G0234063 H81036 P 1974-04-01 00:00:00 1999-09-30 00:00:00 0
152 G0306380 K84009 P 1974-04-01 00:00:00 1993-10-05 00:00:00 0
153 G0306380 K84009 P 2005-09-01 00:00:00   0
154 G0310161 D83048 P 1974-04-01 00:00:00 1991-05-02 00:00:00 0
155 G0312125 M85028 P 1974-04-01 00:00:00 1992-11-21 00:00:00 0
156 G0315070 L81009 P 1974-04-01 00:00:00 1991-04-01 00:00:00 0
157 G0315070 L81654 P 1991-04-02 00:00:00 1991-12-31 00:00:00 0
158 G0316442 G85604 P 1974-04-01 00:00:00 1994-01-12 00:00:00 0
159 G0316686 N82081 P 1974-04-01 00:00:00 1993-05-01 00:00:00 0
160 G0317993 K83001 P 1974-04-01 00:00:00 1992-09-30 00:00:00 0
161 G0318406 C82016 P 1974-04-01 00:00:00 1992-11-11 00:00:00 0
162 G0318736 M89011 P 1974-04-01 00:00:00 1991-12-31 00:00:00 0
163 G0318949 M85008 P 1974-04-01 00:00:00 1991-11-13 00:00:00 0
164 G0318949 M85776 P 1991-11-14 00:00:00 1993-12-10 00:00:00 0
165 G0319359 C84131 P 1990-02-01 00:00:00 1994-12-01 00:00:00 0
166 G0319689 G85031 P 1974-04-01 00:00:00 1993-08-28 00:00:00 0
167 G0320041 N82082 P 1974-04-01 00:00:00 1992-04-02 00:00:00 0
168 G0320319 B86044 P 1974-04-01 00:00:00 1991-06-30 00:00:00 0
169 G0320450 A89029 P 1974-04-01 00:00:00 1996-08-02 00:00:00 0
170 G0320663 W95007 P 1974-04-01 00:00:00 1995-01-09 00:00:00 0
171 G0320704 H85003 P 1974-04-01 00:00:00 1994-02-26 00:00:00 0
172 G0320780 E87607 P 1974-04-01 00:00:00 1994-12-21 00:00:00 0
173 G0320807 F85010 P 1974-04-01 00:00:00 1993-06-30 00:00:00 0
174 G0321028 F83018 P 1974-04-01 00:00:00 1997-06-30 00:00:00 0
175 G0321310 C81032 P 1974-04-01 00:00:00 1992-03-31 00:00:00 0
176 G0321372 M85025 P 1974-04-01 00:00:00 1991-09-30 00:00:00 0
177 G0321585 E82016 P 1974-04-01 00:00:00 1991-04-01 00:00:00 0
178 G0322115 B86604 P 1974-04-01 00:00:00 1997-02-04 00:00:00 0
179 G0322270 A84009 P 1974-04-01 00:00:00 1993-02-02 00:00:00 0
180 G0322304 P85008 P 1974-04-01 00:00:00 1992-01-06 00:00:00 0
181 G0322438 A85005 P 1974-04-01 00:00:00 1993-06-30 00:00:00 0
182 G0322490 E87608 P 1974-04-01 00:00:00 1994-10-16 00:00:00 0
183 G0322524 P82602 P 1974-04-01 00:00:00 1995-07-31 00:00:00 0
184 G0322720 C82601 P 1974-04-01 00:00:00 1993-11-22 00:00:00 0
185 G0323491 M87032 P 1988-10-01 00:00:00 1991-09-30 00:00:00 0
186 G0323549 E83053 P 1990-10-01 00:00:00 1994-04-01 00:00:00 0
187 G0323611 B83055 P 1990-04-09 00:00:00 1993-06-30 00:00:00 0
188 G0323783 C82053 P 1974-04-01 00:00:00 1992-04-07 00:00:00 0
189 G0323790 M84006 P 1974-04-01 00:00:00 1997-09-30 00:00:00 0
190 G0323831 K82068 P 1974-04-01 00:00:00 1991-04-01 00:00:00 0
191 G0323941 E85016 P 1974-04-01 00:00:00 1992-01-03 00:00:00 0
192 G0323972 F81212 P 1988-11-01 00:00:00 1997-03-13 00:00:00 0
193 G0324090 E82018 P 1974-04-01 00:00:00 1993-03-31 00:00:00 0
194 G0324148 E82124 P 1974-04-01 00:00:00 1991-04-05 00:00:00 0
195 G0324155 C83014 P 1974-04-01 00:00:00 1993-01-04 00:00:00 0
196 G0324162 E85060 P 1974-04-01 00:00:00 1992-12-31 00:00:00 0
197 G0324186 M82044 P 1974-04-01 00:00:00 1992-02-15 00:00:00 0
198 G0324272 N81024 P 1974-04-01 00:00:00 1993-03-31 00:00:00 0
199 G0324320 E87609 P 1974-04-01 00:00:00 1995-10-01 00:00:00 0
200 G0324423 F85009 P 1974-04-01 00:00:00 1992-04-06 00:00:00 0

Next page

CREATE TABLE "epracmem" (
"Practitioner Code" TEXT,
  "Parent Organisation Code" TEXT,
  "Parent Organisation Type" TEXT,
  "Join Parent Date" TIMESTAMP,
  "Left Parent Date" TIMESTAMP,
  "Amended Record Indicator" INTEGER
)
Powered by Datasette · Query took 142.305ms · Data source: OUseful Databeat