enrollments
Data source: Big Local News · About: Big Local
20,286 rows where state = "CT" and year = 2019 sorted by district_state_id descending
This data as json, CSV (advanced)
grade ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2435117 | 2435117 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2435118 | 2435118 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2436559 | 2436559 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2436560 | 2436560 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_2 | 57 | 57 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436561 | 2436561 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_2 | 44 | 44 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436562 | 2436562 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_2 | 76 | 76 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436563 | 2436563 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_2 | 73 | 73 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436564 | 2436564 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436565 | 2436565 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436566 | 2436566 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2436567 | 2436567 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_2 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2438008 | 2438008 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_3 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2438009 | 2438009 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_3 | 71 | 71 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2438010 | 2438010 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_3 | 65 | 65 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2438011 | 2438011 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_3 | 72 | 72 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2438012 | 2438012 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_3 | 78 | 78 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2438013 | 2438013 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_3 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2438014 | 2438014 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_3 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2438015 | 2438015 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_3 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2438016 | 2438016 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_3 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2439457 | 2439457 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_4 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2439458 | 2439458 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_4 | 64 | 64 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2439459 | 2439459 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_4 | 53 | 53 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2439460 | 2439460 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_4 | 85 | 85 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2439461 | 2439461 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_4 | 76 | 76 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2439462 | 2439462 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_4 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2439463 | 2439463 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_4 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2439464 | 2439464 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_4 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2439465 | 2439465 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_4 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2440906 | 2440906 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_5 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2440907 | 2440907 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_5 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2440908 | 2440908 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_5 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2440909 | 2440909 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_5 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2440910 | 2440910 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_5 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2440911 | 2440911 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_5 | 285 | 285 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2440912 | 2440912 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_5 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2440913 | 2440913 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_5 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2440914 | 2440914 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_5 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442355 | 2442355 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_6 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2442356 | 2442356 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_6 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2442357 | 2442357 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_6 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2442358 | 2442358 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_6 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2442359 | 2442359 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_6 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2442360 | 2442360 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_6 | 339 | 339 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2442361 | 2442361 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_6 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2442362 | 2442362 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_6 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2442363 | 2442363 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_6 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443804 | 2443804 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2443805 | 2443805 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443806 | 2443806 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443807 | 2443807 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443808 | 2443808 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443809 | 2443809 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443810 | 2443810 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 337 | 337 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443811 | 2443811 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2443812 | 2443812 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2445253 | 2445253 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_8 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2445254 | 2445254 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_8 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2445255 | 2445255 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_8 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2445256 | 2445256 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_8 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2445257 | 2445257 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_8 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2445258 | 2445258 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_8 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2445259 | 2445259 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_8 | 344 | 344 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2445260 | 2445260 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_8 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2445261 | 2445261 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_8 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2446702 | 2446702 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2446703 | 2446703 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446704 | 2446704 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446705 | 2446705 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446706 | 2446706 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446707 | 2446707 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446708 | 2446708 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446709 | 2446709 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 360 | 360 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446710 | 2446710 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2448151 | 2448151 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_10 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2448152 | 2448152 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_10 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2448153 | 2448153 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_10 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2448154 | 2448154 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_10 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2448155 | 2448155 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_10 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2448156 | 2448156 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_10 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2448157 | 2448157 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_10 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2448158 | 2448158 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 382 | 382 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2448159 | 2448159 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_10 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2449600 | 2449600 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_11 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2449601 | 2449601 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_11 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2449602 | 2449602 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_11 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2449603 | 2449603 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_11 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2449604 | 2449604 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_11 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2449605 | 2449605 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_11 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2449606 | 2449606 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_11 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2449607 | 2449607 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 426 | 426 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2449608 | 2449608 | CT | school | 970011 | Newtown School District | 970611 | Newtown Community Partnership | Program | 2019 | grade_11 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2451049 | 2451049 | CT | school | 970011 | Newtown School District | 90291001391 | 978011 | Newtown Preschool | Program | 2019 | grade_12 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2451050 | 2451050 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_12 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2451051 | 2451051 | CT | school | 902910 | 970011 | Newtown School District | 90291001121 | 970411 | Head O'Meadow Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_12 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2451052 | 2451052 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_12 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2451053 | 2451053 | CT | school | 902910 | 970011 | Newtown School District | 90291000617 | 970211 | Sandy Hook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | grade_12 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2451054 | 2451054 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_12 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2451055 | 2451055 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_12 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2451056 | 2451056 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 407 | 407 |
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]);