schools: enrollments: 60,956 rows where where state = "CT" sorted by ccd_school_low

Data source: Big Local News · About: Big Local

60,956 rows where state = "CT" sorted by ccd_school_low_grade descending

Search:

descending

Link	rowid	state	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	school_state_type	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade ▲	ccd_school_high_grade	year	grade	total	total_int
2432861	2432861	CT	school	900030	10011	Andover School District	90003010001	10111	Andover Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	22	22
2432863	2432863	CT	school	900060	20011	Ansonia School District	90006000005	20311	Mead School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	88	88
2432879	2432879	CT	school	900090	30011	Ashford School District	90009000010	30111	Ashford School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	36	36
2432886	2432886	CT	school	900150	50011	Barkhamsted School District	90015000015	50111	Barkhamsted Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	20	20
2432889	2432889	CT	school	900210	70011	Berlin School District	90021000018	70411	Emma Hart Willard School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	73	73
2432890	2432890	CT	school	900210	70011	Berlin School District	90021000020	70511	Mary E. Griswold School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	80	80
2432895	2432895	CT	school	900240	80011	Bethany School District	90024000022	80111	Bethany Community School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	46	46
2432896	2432896	CT	school	900270	90011	Bethel School District	90027000027	90111	Frank A. Berry School	Public Schools	Regular School	No	Elementary	PK	03	2019	kindergarten	86	86
2432903	2432903	CT	school	900330	110011	Bloomfield School District	90033001565	110811	Wintonbury Early Childhood Magnet School	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten	0	0
2432912	2432912	CT	school	900360	120011	Bolton School District	90036000036	120111	Bolton Center School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	46	46
2432915	2432915	CT	school	900390	130011	Bozrah School District	90039000038	130111	Fields Memorial School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	17	17
2432917	2432917	CT	school	900420	140011	Branford School District	90042001119	141611	John B. Sliney School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	59	59
2432918	2432918	CT	school	900420	140011	Branford School District	90042000043	141511	Mary R. Tisko School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	70	70
2432919	2432919	CT	school	900420	140011	Branford School District	90042000042	141411	Mary T. Murphy School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	78	78
2432923	2432923	CT	school	900215	2900013	Brass City Charter School District	90021501644	2900113	Brass City Charter School	Public Charter Schools	Regular School	Yes	Elementary	PK	06	2019	kindergarten	36	36
2432924	2432924	CT	school	900450	150011	Bridgeport School District	90045000085	154411	A.B. Skane Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten	0	0
2432925	2432925	CT	school	900450	150011	Bridgeport School District	90045000049	150111	Barnum School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	81	81
2432926	2432926	CT	school	900450	150011	Bridgeport School District	90045000051	150211	Beardsley School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	47	47
2432927	2432927	CT	school	900450	150011	Bridgeport School District	90045000052	150311	Black Rock School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	55	55
2432928	2432928	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	93	93
2432929	2432929	CT	school	900450	150011	Bridgeport School District	90045000054	150411	Bryant School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	60	60
2432930	2432930	CT	school	900450	150011	Bridgeport School District	90045000070	151411	Cesar Batalla School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	103	103
2432931	2432931	CT	school	900450	150011	Bridgeport School District	90045000075	152111	Classical Studies Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	48	48
2432932	2432932	CT	school	900450	150011	Bridgeport School District	90045000058	150511	Columbus School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	56	56
2432933	2432933	CT	school	900450	150011	Bridgeport School District	90045001918	153111	Geraldine Claytor Magnet Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	38	38
2432934	2432934	CT	school	900450	150011	Bridgeport School District	90045000087	153211	Geraldine Johnson School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	96	96
2432935	2432935	CT	school	900450	150011	Bridgeport School District	90045000066	151211	Hallen School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	39	39
2432936	2432936	CT	school	900450	150011	Bridgeport School District	90045001163	154511	High Horizons Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	45	45
2432937	2432937	CT	school	900450	150011	Bridgeport School District	90045001590	153711	Interdistrict Discovery Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	45	45
2432938	2432938	CT	school	900450	150011	Bridgeport School District	90045000076	152211	Jettie S. Tisdale School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	66	66
2432939	2432939	CT	school	900450	150011	Bridgeport School District	90045000090	153611	John Winthrop School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	62	62
2432940	2432940	CT	school	900450	150011	Bridgeport School District	90045000001	151011	Luis Munoz Marin School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	68	68
2432941	2432941	CT	school	900450	150011	Bridgeport School District	90045000071	151711	Park City Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	52	52
2432942	2432942	CT	school	900450	150011	Bridgeport School District	90045001161	154111	Paul Laurence Dunbar School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	49	49
2432943	2432943	CT	school	900450	150011	Bridgeport School District	90045000080	152511	Read School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	74	74
2432944	2432944	CT	school	900450	150011	Bridgeport School District	90045000081	152611	Roosevelt School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	61	61
2432945	2432945	CT	school	900450	150011	Bridgeport School District	90045000086	153011	Waltersville School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	58	58
2432946	2432946	CT	school	900450	150011	Bridgeport School District	90045000059	153911	Wilbur Cross School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	31	31
2432963	2432963	CT	school	900510	170011	Bristol School District	90051001774	170411	Bristol Early Childhood Center-BECC	Public Schools	Special Education School	No	Prekindergarten	PK	PK	2019	kindergarten	0	0
2432964	2432964	CT	school	900510	170011	Bristol School District	90051000097	171411	Ellen P. Hubbell School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	59	59
2432965	2432965	CT	school	900510	170011	Bristol School District	90051000098	170511	Greene-Hills School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	89	89
2432966	2432966	CT	school	900510	170011	Bristol School District	90051000099	171911	Ivy Drive School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	51	51
2432967	2432967	CT	school	900510	170011	Bristol School District	90051000103	171711	Mountain View School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	40	40
2432968	2432968	CT	school	900510	170011	Bristol School District	90051000105	171111	South Side School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	58	58
2432996	2432996	CT	school	900540	180011	Brookfield School District	90054000110	180311	Center Elementary School	Public Schools	Regular School	No	Elementary	PK	01	2019	kindergarten	153	153
2433000	2433000	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	96	96
2433002	2433002	CT	school	900660	220011	Canterbury School District	90066001188	220211	Canterbury Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	48	48
2433004	2433004	CT	school	900690	230011	Canton School District	90069000120	230211	Cherry Brook Primary School	Public Schools	Regular School	No	Elementary	PK	03	2019	kindergarten	101	101
2433009	2433009	CT	school	900700	2410014	Capitol Region Education Council	90070001629	2410714	Academy of Aerospace and Engineering Elementary	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	67	67
2433010	2433010	CT	school	900700	2410014	Capitol Region Education Council	90070001623	2410614	Ana Grace Academy of the Arts Elementary School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	65	65
2433011	2433011	CT	school	900700	2410014	Capitol Region Education Council	90070001597	2418114	Discovery Academy	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	69	69
2433012	2433012	CT	school	900700	2410014	Capitol Region Education Council	90070000072	2410114	Glastonbury/East Hartford Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	66	66
2433013	2433013	CT	school	900700	2410014	Capitol Region Education Council	90070001511	2410414	International Magnet School for Global Citizenship	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	68	68
2433014	2433014	CT	school	900700	2410014	Capitol Region Education Council	90070000210	2413114	Montessori Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	42	42
2433015	2433015	CT	school	900700	2410014	Capitol Region Education Council	90070001601	2410514	Museum Academy	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	67	67
2433016	2433016	CT	school	900700	2410014	Capitol Region Education Council	90070001516	2410314	Reggio Magnet School of the Arts	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	67	67
2433019	2433019	CT	school	900700	2410014	Capitol Region Education Council	90070001357	2410214	University of Hartford Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	67	67
2433036	2433036	CT	school	900720	240011	Chaplin School District	90072000121	240211	Chaplin Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	15	15
2433037	2433037	CT	school	900750	250011	Cheshire School District	90075011188	250211	Darcey School	Public Schools	Regular School	No	Elementary	PK	KG	2019	kindergarten	78	78
2433047	2433047	CT	school	900810	270011	Clinton School District	90081000132	270311	Lewin G. Joel Jr. School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	106	106
2433051	2433051	CT	school	900840	280011	Colchester School District	90084001444	280411	Colchester Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten	127	127
2433057	2433057	CT	school	900900	300011	Columbia School District	90090000139	300111	Horace W. Porter School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	45	45
2433060	2433060	CT	school	900910	2430014	Cooperative Educational Services	90091000340	2430114	Six-Six Magnet School	Regional Education Service Center Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	44	44
2433071	2433071	CT	school	900990	330011	Cromwell School District	90099000146	330211	Edna C. Stevens School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten	131	131
2433075	2433075	CT	school	901020	340011	Danbury School District	90102001634	340111	DPS Early Childhood Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten	0	0
2433076	2433076	CT	school	901020	340011	Danbury School District	90102000151	341111	Great Plain School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	41	41
2433077	2433077	CT	school	901020	340011	Danbury School District	90102000152	340211	Hayestown Avenue School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	73	73
2433078	2433078	CT	school	901020	340011	Danbury School District	90102000154	340511	Mill Ridge Primary School	Public Schools	Regular School	No	Elementary	PK	03	2019	kindergarten	102	102
2433079	2433079	CT	school	901020	340011	Danbury School District	90102000157	340811	Park Avenue School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	121	121
2433080	2433080	CT	school	901020	340011	Danbury School District	90102000158	341511	Pembroke School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	58	58
2433081	2433081	CT	school	901020	340011	Danbury School District	90102000161	341211	Shelter Rock School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	*
2433082	2433082	CT	school	901020	340011	Danbury School District	90102000163	341611	Stadley Rough School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	86	86
2433095	2433095	CT	school	901050	350011	Darien School District	90105000165	350211	Hindley Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	79	79
2433096	2433096	CT	school	901050	350011	Darien School District	90105000170	351311	Ox Ridge Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	57	57
2433097	2433097	CT	school	901050	350011	Darien School District	90105000171	350511	Royle Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	53	53
2433098	2433098	CT	school	901050	350011	Darien School District	90105000172	350611	Tokeneke Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	64	64
2433102	2433102	CT	school	901110	370011	Derby School District	90111001806	370111	Little Raiders University	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten	0	0
2433108	2433108	CT	school	901170	400011	East Granby School District	90117000180	400111	Allgrove School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten	59	59
2433112	2433112	CT	school	901200	410011	East Haddam School District	90120000184	410111	East Haddam Elementary School	Public Schools	Regular School	No	Elementary	PK	03	2019	kindergarten	69	69
2433115	2433115	CT	school	901230	420011	East Hampton School District	90123000189	420111	Memorial School	Public Schools	Regular School	No	Elementary	PK	03	2019	kindergarten	116	116
2433135	2433135	CT	school	901290	440011	East Haven School District	90129000214	440111	Deer Run School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten	85	85
2433136	2433136	CT	school	901290	440011	East Haven School District	90129001350	441811	Overbrook Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten	0	0
2433151	2433151	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	89	89
2433159	2433159	CT	school	901380	390011	Eastford School District	90138000232	390111	Eastford Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	25	25
2433160	2433160	CT	school	901410	460011	Easton School District	90141000234	460111	Samuel Staples Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	80	80
2433168	2433168	CT	school	901440	480011	Ellington School District	90144000236	480211	Crystal Lake School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	37	37
2433169	2433169	CT	school	901440	480011	Ellington School District	90144000239	480611	Windermere School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	87	87
2433175	2433175	CT	school	900216	2910013	Elm City Montessori School District	90021601683	2910113	Elm City Montessori School	Public Charter Schools	Regular School	Yes	Elementary	PK	04	2019	kindergarten	32	32
2433176	2433176	CT	school	901470	490011	Enfield School District	90147001915	492211	EPS Integrated Pre-Kindergarten	Program	Special Education School	No	Prekindergarten	PK	PK	2019	kindergarten	0	0
2433177	2433177	CT	school	901470	490011	Enfield School District	90147001810	491011	EPS PK STEAM Academy	Program	Regular School	No	Prekindergarten	PK	PK	2019	kindergarten	0	0
2433196	2433196	CT	school	901500	500011	Essex School District	90150000255	500111	Essex Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	kindergarten	31	31
2433197	2433197	CT	school	901530	510011	Fairfield School District	90153001378	510211	Burr Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	63	63
2433200	2433200	CT	school	901530	510011	Fairfield School District	90153000270	511411	Stratfield School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	59	59
2433226	2433226	CT	school	901590	530011	Franklin School District	90159000278	530111	Franklin Elementary School	Public Schools	Regular School	No	Elementary	PK	08	2019	kindergarten	13	13
2433238	2433238	CT	school	901680	560011	Granby School District	90168000290	560411	Kelly Lane Primary School	Public Schools	Regular School	No	Elementary	PK	02	2019	kindergarten	113	113
2433242	2433242	CT	school	901710	570011	Greenwich School District	90171000301	570511	Hamilton Avenue School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	55	55
2433243	2433243	CT	school	901710	570011	Greenwich School District	90171000305	570811	North Street School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	60	60
2433244	2433244	CT	school	901710	570011	Greenwich School District	90171000306	570911	Old Greenwich School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	63	63
2433245	2433245	CT	school	901710	570011	Greenwich School District	90171000107	571111	Parkway School	Public Schools	Regular School	No	Elementary	PK	05	2019	kindergarten	44	44
2433259	2433259	CT	school	901740	580011	Griswold School District	90174000310	580311	Griswold Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2019	kindergarten	136	136

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);