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
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

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