schools: enrollments: 19,213 rows where where state = "MD" sorted by total

Data source: Big Local News · About: Big Local

19,213 rows where state = "MD" sorted by total

Search:

descending

Link	rowid	state	admin_level	district_nces_id	district_state_id	district	school_nces_id	school_state_id	school	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total ▼	white_int	black_int	hispanic_int	asian_int	multiracial_int	total_int
1242617	1242617	MD	school	2400480	15	Montgomery	240048001635	587	PEP - Itinerant	Special Education School	No	Prekindergarten	PK	PK	2020	pk_12_total	43	18	16	*	16		*	100	43	18	16	16		100
1242859	1242859	MD	school	2400480	15	Montgomery	240048000780	780	Bel Pre Elementary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten								100						100
1242875	1242875	MD	school	2400480	15	Montgomery	240048000892	783	Kensington Parkwood Elementary	Regular School	No	Elementary	PK	05	2020	grade_5								100						100
1242950	1242950	MD	school	2400480	15	Montgomery	240048000848	797	Harmony Hills Elementary	Regular School	No	Elementary	PK	05	2020	grade_4								100						100
1243503	1243503	MD	school	2400510	16	Prince George's	240051001641	716	Northview Elementary	Regular School	No	Elementary	PK	05	2020	grade_3								100						100
1243533	1243533	MD	school	2400510	16	Prince George's	240051000500	729	Kingsford Elementary	Regular School	No	Elementary	PK	05	2020	grade_4								100						100
1243645	1243645	MD	school	2400510	16	Prince George's	240051000714	1014	Scotchtown Hills Elementary	Regular School	No	Elementary	PK	06	2020	grade_4								100						100
1243649	1243649	MD	school	2400510	16	Prince George's	240051001708	1015	Chesapeake Math and IT Public Charter	Regular School	Yes	Other	KG	12	2020	kindergarten								100						100
1243847	1243847	MD	school	2400510	16	Prince George's	240051000729	1309	William Paca Elementary	Regular School	No	Elementary	PK	05	2020	grade_4								100						100
1243933	1243933	MD	school	2400510	16	Prince George's	240051001726	1351	Chesapeake Math and IT South Public Charter	Regular School	Yes	Other	KG	12	2020	kindergarten								100						100
1243987	1243987	MD	school	2400510	16	Prince George's	240051001245	1416	Dora Kennedy French Immersion	Regular School	No	Elementary	KG	08	2020	grade_1								100						100
1244248	1244248	MD	school	2400510	16	Prince George's	240051001573	1731	Rosa L. Parks Elementary	Regular School	No	Elementary	PK	06	2020	grade_2								100						100
1245144	1245144	MD	school	2400660	21	Washington	240066001278	1802	Pangborn Elementary	Regular School	No	Elementary	PK	05	2020	grade_2								100						100
1245227	1245227	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2020	grade_9								100						100
1245265	1245265	MD	school	2400690	22	Wicomico	240069001304	515	Glen Avenue School	Regular School	No	Elementary	02	05	2020	grade_3								100						100
1245343	1245343	MD	school	2400690	22	Wicomico	240069001318	1501	Westside Primary	Regular School	No	Elementary	PK	01	2020	kindergarten								100						100
1245429	1245429	MD	school	2400720	23	Worcester	240072001325	901	Buckingham Elementary	Regular School	No	Elementary	PK	04	2020	grade_1								100						100
1245431	1245431	MD	school	2400720	23	Worcester	240072001325	901	Buckingham Elementary	Regular School	No	Elementary	PK	04	2020	grade_3								100						100
1245881	1245881	MD	school	2400090	30	Baltimore City	240009000282	105	Moravia Park Elementary	Regular School	No	Elementary	PK	05	2020	pre_kindergarten								100						100
1246185	1246185	MD	school	2400090	30	Baltimore City	240009000257	228	John Ruhrah Elementary/Middle	Regular School	No	Elementary	PK	08	2020	grade_8								100						100
1246300	1246300	MD	school	2400090	30	Baltimore City	240009000293	242	Northwood Elementary	Regular School	No	Elementary	PK	05	2020	grade_2								100						100
1246761	1246761	MD	school	2400090	30	Baltimore City	240009001559	422	New Era Academy	Regular School	No	High	09	12	2020	grade_10								100						100
1246788	1246788	MD	school	2400090	30	Baltimore City	240009001531	433	Renaissance Academy	Regular School	No	High	09	12	2020	grade_9								100						100
1310469	1310469	MD	school	2400060	2	Anne Arundel	240006001517	3362	Crofton Meadows Elementary	Regular School	No	Elementary	KG	05	2021	grade_1								100						100
1310473	1310473	MD	school	2400060	2	Anne Arundel	240006001517	3362	Crofton Meadows Elementary	Regular School	No	Elementary	KG	05	2021	grade_5								100						100
1310484	1310484	MD	school	2400060	2	Anne Arundel	240006000133	3382	Southgate Elementary	Regular School	No	Elementary	PK	05	2021	kindergarten								100						100
1310575	1310575	MD	school	2400060	2	Anne Arundel	240006000062	4122	Davidsonville Elementary	Regular School	No	Elementary	KG	05	2021	grade_1								100						100
1310717	1310717	MD	school	2400060	2	Anne Arundel	240006001724	6113	Monarch Global Academy PCS Laurel Campus	Regular School	No	Elementary	KG	08	2021	grade_5								100						100
1311259	1311259	MD	school	2400120	3	Baltimore County	240012001722	814	Mays Chapel Elementary	Regular School	No	Elementary	PK	05	2021	grade_3								100						100
1311450	1311450	MD	school	2400120	3	Baltimore County	240012000351	1106	Carney Elementary	Regular School	No	Elementary	PK	05	2021	kindergarten								100						100
1311459	1311459	MD	school	2400120	3	Baltimore County	240012000358	1107	Chapel Hill Elementary	Regular School	No	Elementary	KG	05	2021	grade_2								100						100
1311482	1311482	MD	school	2400120	3	Baltimore County	240012000397	1111	Gunpowder Elementary	Regular School	No	Elementary	KG	05	2021	grade_2								100						100
1311738	1311738	MD	school	2400120	3	Baltimore County	240012000489	1505	Victory Villa Elementary	Regular School	No	Elementary	PK	05	2021	grade_3								100						100
1311984	1311984	MD	school	2400150	4	Calvert	240015001655	208	Barstow Elementary	Regular School	No	Elementary	PK	05	2021	grade_2								100						100
1312212	1312212	MD	school	2400210	6	Carroll	240021090466	509	Piney Ridge Elementary	Regular School	No	Elementary	PK	05	2021	grade_5								100						100
1312598	1312598	MD	school	2400270	8	Charles	240027000141	109	Mary H. Matula Elementary School	Regular School	No	Elementary	PK	05	2021	grade_5								100						100
1312706	1312706	MD	school	2400270	8	Charles	240027000380	620	C. Paul Barnhart Elementary School	Regular School	No	Elementary	PK	05	2021	grade_3								100						100
1312744	1312744	MD	school	2400270	8	Charles	240027001656	626	Mary B. Neal Elementary School	Regular School	No	Elementary	PK	05	2021	grade_4								100						100
1313083	1313083	MD	school	2400330	10	Frederick	240033000643	903	New Market Elementary	Regular School	No	Elementary	PK	05	2021	kindergarten								100						100
1313248	1313248	MD	school	2400330	10	Frederick	240033000807	2306	Orchard Grove Elementary	Regular School	No	Elementary	PK	05	2021	grade_1								100						100
1313441	1313441	MD	school	2400390	12	Harford	240039000485	121	Emmorton Elementary	Regular School	No	Elementary	KG	05	2021	grade_3								100						100
1313951	1313951	MD	school	2400420	13	Howard	240042000488	305	Manor Woods Elementary	Regular School	No	Elementary	KG	05	2021	grade_3								100						100
1314137	1314137	MD	school	2400420	13	Howard	240042000758	604	Waterloo Elementary	Regular School	No	Elementary	PK	05	2021	grade_4								100						100
1314149	1314149	MD	school	2400420	13	Howard	240042000734	606	Hammond Elementary	Regular School	No	Elementary	KG	05	2021	grade_2								100						100
1314373	1314373	MD	school	2400480	15	Montgomery	240048001523	111	Captain James E. Daly Elementary	Regular School	No	Elementary	PK	05	2021	grade_2								100						100
1314521	1314521	MD	school	2400480	15	Montgomery	240048000786	226	Beverly Farms Elementary	Regular School	No	Elementary	PK	05	2021	grade_2								100						100
1314540	1314540	MD	school	2400480	15	Montgomery	240048000810	229	College Gardens Elementary	Regular School	No	Elementary	PK	05	2021	grade_2								100						100
1314654	1314654	MD	school	2400480	15	Montgomery	240048000854	305	Jackson Road Elementary	Regular School	No	Elementary	PK	05	2021	kindergarten								100						100
1314697	1314697	MD	school	2400480	15	Montgomery	240048000955	312	William Tyler Page Elementary	Regular School	No	Elementary	PK	05	2021	grade_2								100						100
1314737	1314737	MD	school	2400480	15	Montgomery	240048001510	334	Greencastle Elementary	Regular School	No	Elementary	PK	05	2021	grade_4								100						100
1314828	1314828	MD	school	2400480	15	Montgomery	240048000923	405	Somerset Elementary	Regular School	No	Elementary	PK	05	2021	grade_5								100						100
1314867	1314867	MD	school	2400480	15	Montgomery	240048000958	417	Wood Acres Elementary	Regular School	No	Elementary	PK	05	2021	grade_3								100						100
1315230	1315230	MD	school	2400480	15	Montgomery	240048000781	607	Bells Mill Elementary	Regular School	No	Elementary	PK	05	2021	grade_3								100						100
1315753	1315753	MD	school	2400510	16	Prince George's	240051001146	210	Rogers Heights Elementary	Regular School	No	Elementary	PK	06	2021	grade_4								100						100
1316162	1316162	MD	school	2400510	16	Prince George's	240051001180	914	Waldon Woods Elementary	Regular School	No	Elementary	PK	05	2021	grade_4								100						100
1316672	1316672	MD	school	2400510	16	Prince George's	240051001697	1518	Barack Obama Elementary	Regular School	No	Elementary	PK	05	2021	kindergarten								100						100
1316789	1316789	MD	school	2400510	16	Prince George's	240051000965	1714	Adelphi Elementary	Regular School	No	Elementary	PK	06	2021	grade_1								100						100
1316793	1316793	MD	school	2400510	16	Prince George's	240051000965	1714	Adelphi Elementary	Regular School	No	Elementary	PK	06	2021	grade_5								100						100
1316891	1316891	MD	school	2400510	16	Prince George's	240051001174	1814	Thomas G. Pullen School	Regular School	No	Elementary	KG	08	2021	grade_7								100						100
1316892	1316892	MD	school	2400510	16	Prince George's	240051001174	1814	Thomas G. Pullen School	Regular School	No	Elementary	KG	08	2021	grade_8								100						100
1317060	1317060	MD	school	2400510	16	Prince George's	240051001764	2023	Legend Public Charter School	Regular School	Yes	Elementary	KG	05	2021	kindergarten								100						100
1317061	1317061	MD	school	2400510	16	Prince George's	240051001764	2023	Legend Public Charter School	Regular School	Yes	Elementary	KG	05	2021	grade_1								100						100
1317062	1317062	MD	school	2400510	16	Prince George's	240051001764	2023	Legend Public Charter School	Regular School	Yes	Elementary	KG	05	2021	grade_2								100						100
1317069	1317069	MD	school	2400510	16	Prince George's	240051000512	2106	Greenbelt Elementary	Regular School	No	Elementary	PK	05	2021	grade_1								100						100
1317580	1317580	MD	school	2400660	21	Washington	240066001667	325	Rockland Woods Elementary	Regular School	No	Elementary	PK	05	2021	grade_5								100						100
1317582	1317582	MD	school	2400660	21	Washington	240066001707	328	Ruth Ann Monroe Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten								100						100
1318072	1318072	MD	school	2400090	30	Baltimore City	240009000264	12	Lakeland Elementary/Middle	Regular School	No	Elementary	PK	08	2021	grade_8								100						100
1318130	1318130	MD	school	2400090	30	Baltimore City	240009000180	27	Commodore John Rodgers Elementary/Middle	Regular School	No	Elementary	PK	08	2021	grade_8								100						100
1245177	1245177	MD	school	2400660	21	Washington	240066001293	2501	Western Heights Middle	Regular School	No	Middle	06	08	2020	pk_12_total	481	235	160		19		106	1001	481	235	160	19	106	1001
1317293	1317293	MD	school	2400600	18	Saint Mary's	240060001231	404	Margaret Brent Middle	Regular School	No	Middle	06	08	2021	pk_12_total	807	72	48	*	*	*	65	1002	807	72	48		65	1002
1243134	1243134	MD	school	2400510	16	Prince George's	240051001101	110	Martin Luther King Jr. Middle	Regular School	No	Middle	06	08	2020	pk_12_total	44	490	367	*	70	*	26	1003	44	490	367	70	26	1003
1242134	1242134	MD	school	2400480	15	Montgomery	240048090453	311	Francis Scott Key Middle	Regular School	No	Middle	06	08	2020	pk_12_total	27	437	420	*	90	*	26	1004	27	437	420	90	26	1004
1311659	1311659	MD	school	2400120	3	Baltimore County	240012000342	1356	Arbutus Middle	Regular School	No	Middle	06	08	2021	pk_12_total	522	205	46	*	140	*	83	1004	522	205	46	140	83	1004
1239866	1239866	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2020	pk_12_total	480	288	128	*	13	*	91	1005	480	288	128	13	91	1005
1237771	1237771	MD	school	2400060	2	Anne Arundel	240006000083	3112	Jessup Elementary	Regular School	No	Elementary	PK	05	2020	grade_4								101						101
1237874	1237874	MD	school	2400060	2	Anne Arundel	240006000069	3272	Four Seasons Elementary	Regular School	No	Elementary	PK	05	2020	grade_3								101						101
1237931	1237931	MD	school	2400060	2	Anne Arundel	240006000120	3392	Rippling Woods Elementary	Regular School	No	Elementary	PK	05	2020	grade_4								101						101
1238155	1238155	MD	school	2400060	2	Anne Arundel	240006001724	6113	Monarch Global Academy PCS Laurel Campus	Regular School	No	Elementary	KG	08	2020	grade_7								101						101
1238243	1238243	MD	school	2400120	3	Baltimore County	240012000353	101	Catonsville Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten								101						101
1238263	1238263	MD	school	2400120	3	Baltimore County	240012000495	103	Westowne Elementary	Regular School	No	Elementary	PK	05	2020	grade_4								101						101
1238307	1238307	MD	school	2400120	3	Baltimore County	240012000357	113	Chadwick Elementary	Regular School	No	Elementary	PK	05	2020	grade_1								101						101
1238559	1238559	MD	school	2400120	3	Baltimore County	240012000484	405	Timber Grove Elementary	Regular School	No	Elementary	PK	05	2020	grade_3								101						101
1238687	1238687	MD	school	2400120	3	Baltimore County	240012000452	811	Pinewood Elementary	Regular School	No	Elementary	PK	05	2020	grade_2								101						101
1238874	1238874	MD	school	2400120	3	Baltimore County	240012000467	1002	Jacksonville Elementary	Regular School	No	Elementary	KG	05	2020	grade_2								101						101
1238899	1238899	MD	school	2400120	3	Baltimore County	240012000351	1106	Carney Elementary	Regular School	No	Elementary	PK	05	2020	grade_4								101						101
1239476	1239476	MD	school	2400150	4	Calvert	240015000513	312	Mount Harmony Elementary	Regular School	No	Elementary	KG	05	2020	grade_4								101						101
1239522	1239522	MD	school	2400180	5	Caroline	240018000520	301	Denton Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten								101						101
1239661	1239661	MD	school	2400210	6	Carroll	240021090466	509	Piney Ridge Elementary	Regular School	No	Elementary	PK	05	2020	grade_4								101						101
1239670	1239670	MD	school	2400210	6	Carroll	240021000536	601	Manchester Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten								101						101
1240032	1240032	MD	school	2400270	8	Charles	240027000609	105	Walter J. Mitchell Elementary School	Regular School	No	Elementary	PK	05	2020	grade_5								101						101
1240157	1240157	MD	school	2400270	8	Charles	240027000380	620	C. Paul Barnhart Elementary School	Regular School	No	Elementary	PK	05	2020	grade_2								101						101
1240354	1240354	MD	school	2400330	10	Frederick	240033000628	108	Carroll Manor Elementary	Regular School	No	Elementary	PK	05	2020	grade_3								101						101
1240695	1240695	MD	school	2400330	10	Frederick	240033000807	2306	Orchard Grove Elementary	Regular School	No	Elementary	PK	05	2020	grade_1								101						101
1241056	1241056	MD	school	2400390	12	Harford	240039000698	333	Hickory Elementary	Regular School	No	Elementary	KG	05	2020	grade_1								101						101
1241239	1241239	MD	school	2400420	13	Howard	240042090448	103	Deep Run Elementary	Regular School	No	Elementary	PK	05	2020	grade_3								101						101
1241248	1241248	MD	school	2400420	13	Howard	240042000396	105	Rockburn Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten								101						101
1241579	1241579	MD	school	2400420	13	Howard	240042000758	604	Waterloo Elementary	Regular School	No	Elementary	PK	05	2020	grade_2								101						101
1241655	1241655	MD	school	2400420	13	Howard	240042000761	618	Laurel Woods Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten								101						101
1241977	1241977	MD	school	2400480	15	Montgomery	240048000810	229	College Gardens Elementary	Regular School	No	Elementary	PK	05	2020	grade_1								101						101
1242046	1242046	MD	school	2400480	15	Montgomery	240048000404	244	Thurgood Marshall Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten								101						101

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]);