home / nhsadmin

Current and historical records of membership of CCGs, Primary Care Trusts, Primary Care Groups by General Medical Practice

Data source: OUseful Databeat

45,684 rows sorted by Parent Organisation Code

View and edit SQL

This data as .json

Suggested facets: Amended Record Indicator

Link rowid Organisation Code Parent Organisation Code ▼ Parent Organisation Type Join Parent Date Left Parent Date Amended Record Indicator
701 A83005 00C W 2013-04-01 00:00:00   0
704 A83006 00C W 2013-04-01 00:00:00   0
719 A83010 00C W 2013-04-01 00:00:00   0
730 A83013 00C W 2013-04-01 00:00:00   0
801 A83031 00C W 2013-04-01 00:00:00   0
812 A83034 00C W 2013-04-01 00:00:00   0
831 A83040 00C W 2013-04-01 00:00:00   0
858 A83047 00C W 2013-04-01 00:00:00   0
861 A83048 00C W 2013-04-01 00:00:00   0
911 A83070 00C W 2013-04-01 00:00:00   0
1020 A83641 00C W 2013-04-01 00:00:00   0
36898 Y00136 00C W 2013-04-01 00:00:00   0
36912 Y00142 00C W 2013-04-01 00:00:00   0
37068 Y00218 00C W 2013-04-01 00:00:00   0
37430 Y00382 00C W 2013-04-01 00:00:00   0
38586 Y00891 00C W 2013-04-01 00:00:00   0
40404 Y02064 00C W 2013-04-01 00:00:00   0
41382 Y02607 00C W 2013-04-01 00:00:00 2014-06-30 00:00:00 0
43372 Y03603 00C W 2013-04-01 00:00:00 2013-11-30 00:00:00 0
43868 Y04031 00C W 2013-04-01 00:00:00   0
45600 Y05682 00C W 2017-02-09 00:00:00   0
690 A83001 00D W 2013-04-01 00:00:00   0
694 A83003 00D W 2013-04-01 00:00:00   0
698 A83004 00D W 2013-04-01 00:00:00   0
708 A83007 00D W 2013-04-01 00:00:00   0
712 A83008 00D W 2013-04-01 00:00:00   0
727 A83012 00D W 2013-04-01 00:00:00   0
738 A83015 00D W 2013-04-01 00:00:00   0
746 A83017 00D W 2013-04-01 00:00:00   0
754 A83019 00D W 2013-04-01 00:00:00   0
758 A83020 00D W 2013-04-01 00:00:00   0
762 A83021 00D W 2013-04-01 00:00:00   0
778 A83025 00D W 2013-04-01 00:00:00   0
805 A83032 00D W 2013-04-01 00:00:00   0
816 A83035 00D W 2013-04-01 00:00:00   0
824 A83037 00D W 2013-04-01 00:00:00   0
835 A83041 00D W 2013-04-01 00:00:00   0
839 A83042 00D W 2013-04-01 00:00:00   0
843 A83043 00D W 2013-04-01 00:00:00   0
847 A83044 00D W 2013-04-01 00:00:00   0
851 A83045 00D W 2013-04-01 00:00:00   0
855 A83046 00D W 2013-04-01 00:00:00   0
873 A83051 00D W 2013-04-01 00:00:00   0
877 A83052 00D W 2013-04-01 00:00:00   0
881 A83054 00D W 2013-04-01 00:00:00   0
889 A83057 00D W 2013-04-01 00:00:00   0
896 A83060 00D W 2013-04-01 00:00:00   0
900 A83061 00D W 2013-04-01 00:00:00   0
904 A83066 00D W 2013-04-01 00:00:00   0
908 A83068 00D W 2013-04-01 00:00:00 2016-12-31 00:00:00 0
915 A83071 00D W 2013-04-01 00:00:00   0
927 A83074 00D W 2013-04-01 00:00:00   0
931 A83075 00D W 2013-04-01 00:00:00   0
939 A83603 00D W 2013-04-01 00:00:00   0
949 A83610 00D W 2013-04-01 00:00:00   0
955 A83616 00D W 2013-04-01 00:00:00   0
967 A83619 00D W 2013-04-01 00:00:00   0
977 A83626 00D W 2013-04-01 00:00:00   0
981 A83627 00D W 2013-04-01 00:00:00   0
996 A83634 00D W 2013-04-01 00:00:00   0
1012 A83638 00D W 2013-04-01 00:00:00   0
1028 A83643 00D W 2013-04-01 00:00:00   0
36645 Y00017 00D W 2013-04-01 00:00:00   0
36842 Y00107 00D W 2013-04-01 00:00:00   0
38023 Y00643 00D W 2013-04-01 00:00:00   0
38120 Y00688 00D W 2013-04-01 00:00:00   0
38432 Y00824 00D W 2013-04-01 00:00:00   0
38536 Y00866 00D W 2013-04-01 00:00:00   0
38692 Y00943 00D W 2013-04-01 00:00:00   0
38859 Y01014 00D W 2013-04-01 00:00:00 2016-07-31 00:00:00 0
39931 Y01792 00D W 2013-04-01 00:00:00 2014-06-30 00:00:00 0
40488 Y02115 00D W 2013-04-01 00:00:00   0
40645 Y02203 00D W 2013-04-01 00:00:00   0
40907 Y02352 00D W 2013-04-01 00:00:00   0
41396 Y02614 00D W 2013-04-01 00:00:00   0
41543 Y02689 00D W 2015-03-05 00:00:00   0
42298 Y03093 00D W 2013-04-01 00:00:00 2016-05-31 00:00:00 0
43202 Y03525 00D W 2013-04-01 00:00:00 2016-07-31 00:00:00 0
43306 Y03574 00D W 2013-04-01 00:00:00   0
43789 Y03952 00D W 2013-04-01 00:00:00 2016-07-31 00:00:00 0
43869 Y04032 00D W 2013-04-01 00:00:00   0
44286 Y04430 00D W 2013-10-01 00:00:00   0
45017 Y05118 00D W 2015-08-19 00:00:00   0
45018 Y05119 00D W 2015-08-19 00:00:00   0
45019 Y05120 00D W 2015-08-19 00:00:00   0
45321 Y05411 00D W 2016-05-19 00:00:00   0
45330 Y05419 00D W 2016-05-25 00:00:00   0
45653 Y05735 00D W 2017-04-05 00:00:00   1
45654 Y05736 00D W 2017-04-05 00:00:00   1
45656 Y05738 00D W 2017-04-05 00:00:00   1
1193 A85001 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1198 A85002 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1203 A85003 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1208 A85004 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1213 A85005 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1218 A85006 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1223 A85007 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1228 A85008 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1233 A85009 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0
1238 A85010 00F W 2013-04-01 00:00:00 2015-03-31 00:00:00 0

Next page

CREATE TABLE "epcmem" (
"Organisation 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 171.625ms · Data source: OUseful Databeat