enrollments
Data source: Big Local News · About: Big Local
1,449 rows where grade = "grade_1", state = "CT" and year = 2019 sorted by ccd_school_lvl descending
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | 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 | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2434910 | 2434910 | CT | school | 902400 | 800011 | Meriden School District | 90240001194 | 805411 | Washington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434937 | 2434937 | CT | school | 902490 | 830011 | Middletown School District | 90249000456 | 831511 | Keigwin Middle School | Public Schools | Regular School | No | Middle | 06 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434938 | 2434938 | CT | school | 902490 | 830011 | Middletown School District | 90249000459 | 835411 | Woodrow Wilson Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434954 | 2434954 | CT | school | 902520 | 840011 | Milford School District | 90252000484 | 845111 | East Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434955 | 2434955 | CT | school | 902520 | 840011 | Milford School District | 90252000468 | 845211 | Harborside Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434956 | 2434956 | CT | school | 902520 | 840011 | Milford School District | 90252000474 | 845311 | West Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434965 | 2434965 | CT | school | 902550 | 850011 | Monroe School District | 90255000920 | 855211 | Jockey Hollow School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434972 | 2434972 | CT | school | 902580 | 860011 | Montville School District | 90258000035 | 865111 | Leonard J. Tyl Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434983 | 2434983 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000502 | 880211 | Cross Street Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434984 | 2434984 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000504 | 880411 | Hillside Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2434985 | 2434985 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000501 | 885111 | City Hill Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435006 | 2435006 | CT | school | 902670 | 890011 | New Britain School District | 90267001445 | 895411 | House of Arts Letters and Science (HALS) Academy | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435007 | 2435007 | CT | school | 902670 | 890011 | New Britain School District | 90267000518 | 895311 | Pulaski Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435009 | 2435009 | CT | school | 902670 | 890011 | New Britain School District | 90267000522 | 895211 | Slade Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435017 | 2435017 | CT | school | 902700 | 900011 | New Canaan School District | 90270000532 | 905111 | Saxe Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435022 | 2435022 | CT | school | 902730 | 910011 | New Fairfield School District | 90273001224 | 915211 | New Fairfield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435073 | 2435073 | CT | school | 902790 | 930011 | New Haven School District | 90279000545 | 935511 | Betsy Ross Arts Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435093 | 2435093 | CT | school | 902820 | 950011 | New London School District | 90282000596 | 955111 | Bennie Dover Jackson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435094 | 2435094 | CT | school | 902820 | 950011 | New London School District | 90282001919 | 951411 | New London Visual and Performing Arts Magnet School | Public Schools | Regular School | No | Middle | 06 | 09 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435100 | 2435100 | CT | school | 902850 | 960011 | New Milford School District | 90285000603 | 965211 | Schaghticoke Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435107 | 2435107 | CT | school | 902880 | 940011 | Newington School District | 90288001120 | 945311 | John Wallace Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435108 | 2435108 | CT | school | 902880 | 940011 | Newington School District | 90288000608 | 945111 | Martin Kellogg Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435115 | 2435115 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435116 | 2435116 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435122 | 2435122 | CT | school | 902970 | 990011 | North Branford School District | 90297000622 | 995111 | North Branford Intermediate School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435130 | 2435130 | CT | school | 903030 | 1010011 | North Haven School District | 90303000632 | 1015211 | North Haven Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435148 | 2435148 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000653 | 1035211 | Nathan Hale Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435149 | 2435149 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000656 | 1035311 | Ponus Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435150 | 2435150 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000657 | 1035511 | Roton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435151 | 2435151 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000661 | 1035411 | West Rocks Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435169 | 2435169 | CT | school | 903120 | 1040011 | Norwich School District | 90312000670 | 1045111 | Kelly STEAM Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435171 | 2435171 | CT | school | 903120 | 1040011 | Norwich School District | 90312000674 | 1045211 | Teachers' Memorial Global Studies Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435175 | 2435175 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000007 | 1065211 | Old Saybrook Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435183 | 2435183 | CT | school | 903240 | 1080011 | Oxford School District | 90324000690 | 1085111 | Oxford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435190 | 2435190 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000693 | 1095111 | Plainfield Central School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435195 | 2435195 | CT | school | 903300 | 1100011 | Plainville School District | 90330000048 | 1105211 | Middle School of Plainville | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435200 | 2435200 | CT | school | 903330 | 1110011 | Plymouth School District | 90333000705 | 1115111 | Eli Terry Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435205 | 2435205 | CT | school | 903390 | 1130011 | Portland School District | 90339001393 | 1130511 | Brownstone Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435206 | 2435206 | CT | school | 903390 | 1130011 | Portland School District | 90339000713 | 1135111 | Portland Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435209 | 2435209 | CT | school | 903420 | 1140011 | Preston School District | 90342000717 | 1145111 | Preston Plains School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435211 | 2435211 | CT | school | 903480 | 1160011 | Putnam School District | 90348000720 | 1165111 | Putnam Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435215 | 2435215 | CT | school | 903510 | 1170011 | Redding School District | 90351000721 | 1175111 | John Read Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435226 | 2435226 | CT | school | 903520 | 2100012 | Regional School District 10 | 90352000727 | 2105112 | Har-Bur Middle School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435235 | 2435235 | CT | school | 903535 | 2130012 | Regional School District 13 | 90353500742 | 2130412 | Middlefield Memorial School | Regional Schools | Regular School | No | Middle | 04 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435236 | 2435236 | CT | school | 903535 | 2130012 | Regional School District 13 | 90353500739 | 2135112 | Frank Ward Strong School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435241 | 2435241 | CT | school | 903536 | 2140012 | Regional School District 14 | 90353600746 | 2145112 | Woodbury Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435248 | 2435248 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700748 | 2155212 | Memorial Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435249 | 2435249 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700751 | 2155112 | Rochambeau Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435254 | 2435254 | CT | school | 903538 | 2160012 | Regional School District 16 | 90353800756 | 2165112 | Long River Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435260 | 2435260 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353901201 | 2175112 | Haddam-Killingworth Middle School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435266 | 2435266 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354001123 | 2185112 | Lyme-Old Lyme Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435279 | 2435279 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000776 | 1185111 | East Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435280 | 2435280 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381001361 | 1185211 | Scotts Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435287 | 2435287 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000782 | 1195111 | Albert D. Griswold Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435295 | 2435295 | CT | school | 903990 | 1240011 | Seymour School District | 90399000794 | 1245111 | Seymour Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435307 | 2435307 | CT | school | 904050 | 1260011 | Shelton School District | 90405001584 | 1261111 | Perry Hill Elementary School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435308 | 2435308 | CT | school | 904050 | 1260011 | Shelton School District | 90405000801 | 1265111 | Intermediate School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435318 | 2435318 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000811 | 1285111 | Henry James Memorial School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435322 | 2435322 | CT | school | 904140 | 1290011 | Somers School District | 90414000818 | 1295111 | Mabelle B. Avery Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435330 | 2435330 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000827 | 1325111 | Timothy Edwards School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435347 | 2435347 | CT | school | 904230 | 1310011 | Southington School District | 90423000832 | 1315311 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435349 | 2435349 | CT | school | 904230 | 1310011 | Southington School District | 90423000833 | 1315111 | Joseph A. Depaolo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435360 | 2435360 | CT | school | 904290 | 1340011 | Stafford School District | 90429000061 | 1345211 | Stafford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435379 | 2435379 | CT | school | 904320 | 1350011 | Stamford School District | 90432000851 | 1355611 | Cloonan School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435380 | 2435380 | CT | school | 904320 | 1350011 | Stamford School District | 90432000853 | 1355311 | Dolan School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435381 | 2435381 | CT | school | 904320 | 1350011 | Stamford School District | 90432001353 | 1355811 | Rippowam Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435382 | 2435382 | CT | school | 904320 | 1350011 | Stamford School District | 90432000009 | 1355711 | Scofield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435383 | 2435383 | CT | school | 904320 | 1350011 | Stamford School District | 90432000870 | 1355511 | Turn of River School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435395 | 2435395 | CT | school | 904380 | 1370011 | Stonington School District | 90438000879 | 1375111 | Pawcatuck Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2435396 | 2435396 | CT | school | 904380 | 1370011 | Stonington School District | 90438000877 | 1375211 | Stonington Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435412 | 2435412 | CT | school | 904440 | 1380011 | Stratford School District | 90444000900 | 1385211 | David Wooster Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435413 | 2435413 | CT | school | 904440 | 1380011 | Stratford School District | 90444000888 | 1385311 | Harry B. Flood Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435424 | 2435424 | CT | school | 904470 | 1390011 | Suffield School District | 90447000902 | 1395111 | Suffield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435427 | 2435427 | CT | school | 904500 | 1400011 | Thomaston School District | 90450001117 | 1400211 | Thomaston Center School | Public Schools | Regular School | No | Middle | 04 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435431 | 2435431 | CT | school | 904530 | 1410011 | Thompson School District | 90453000910 | 1415111 | Thompson Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435435 | 2435435 | CT | school | 904560 | 1420011 | Tolland School District | 90456000915 | 1425111 | Tolland Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435445 | 2435445 | CT | school | 904590 | 1430011 | Torrington School District | 90459000925 | 1435111 | Torrington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435455 | 2435455 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000930 | 1445211 | Hillcrest Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435456 | 2435456 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000933 | 1445111 | Madison Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435470 | 2435470 | CT | school | 904680 | 1460011 | Vernon School District | 90468000947 | 1465111 | Vernon Center Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435487 | 2435487 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000951 | 1485211 | Dag Hammarskjold Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435489 | 2435489 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000954 | 1485311 | James H. Moran Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435530 | 2435530 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000991 | 1515211 | West Side Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435533 | 2435533 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000983 | 1515111 | Michael F. Wallace Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435537 | 2435537 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001115 | 1515311 | North End Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435542 | 2435542 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001395 | 1515011 | Waterbury Arts Magnet School (Middle) | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435558 | 2435558 | CT | school | 904860 | 1520011 | Waterford School District | 90486000994 | 1525111 | Clark Lane Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435565 | 2435565 | CT | school | 904890 | 1530011 | Watertown School District | 90489001007 | 1535111 | Swift Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435585 | 2435585 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001419 | 1555311 | Bristow Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435586 | 2435586 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435587 | 2435587 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001021 | 1555211 | Sedgwick Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435601 | 2435601 | CT | school | 904950 | 1560011 | West Haven School District | 90495001037 | 1565311 | Carrigan 5/6 Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435602 | 2435602 | CT | school | 904950 | 1560011 | West Haven School District | 90495001036 | 1565111 | Harry M. Bailey Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435608 | 2435608 | CT | school | 904980 | 1540011 | Westbrook School District | 90498001043 | 1545111 | Westbrook Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435612 | 2435612 | CT | school | 905010 | 1570011 | Weston School District | 90501001047 | 1575111 | Weston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435623 | 2435623 | CT | school | 905040 | 1580011 | Westport School District | 90504001048 | 1585111 | Bedford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435624 | 2435624 | CT | school | 905040 | 1580011 | Westport School District | 90504001052 | 1585311 | Coleytown Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435633 | 2435633 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001066 | 1595211 | Silas Deane Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435637 | 2435637 | CT | school | 905100 | 1600011 | Willington School District | 90510001070 | 1605111 | Hall Memorial School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435639 | 2435639 | CT | school | 905130 | 1610011 | Wilton School District | 90513001073 | 1615211 | Middlebrook School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_1 | 0 | 0 |
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]);