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

Suggested facets: Amended Record Indicator

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 72.947ms · Data source: OUseful Databeat