enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_8" and state = "CT" sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 4,354 ✖
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
2445263 2445263 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2019   grade_8                                                   0                                             0
2445264 2445264 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2019   grade_8                                                   0                                             0
2445265 2445265 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   151                                             151
2445266 2445266 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2445267 2445267 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2019   grade_8                                                   0                                             0
2750865 2750865 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_8                                                   0                                             0
2750866 2750866 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_8                                                   0                                             0
2750867 2750867 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   123                                             123
2750868 2750868 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_8                                                   0                                             0
2750869 2750869 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_8                                                   0                                             0
2771224 2771224 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_8                                                   0                                             0
2771225 2771225 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_8                                                   0                                             0
2771226 2771226 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   133                                             133
2771227 2771227 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_8                                                   0                                             0
2771228 2771228 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_8                                                   0                                             0
2445262 2445262 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_8                                                   0                                             0
2750864 2750864 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_8                                                   0                                             0
2771223 2771223 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_8                                                   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
2750853 2750853 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2021   grade_8                                                   0                                             0
2750854 2750854 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_8                                                   0                                             0
2750855 2750855 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_8                                                   0                                             0
2750856 2750856 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_8                                                   0                                             0
2750857 2750857 CT     school   970011   Newtown School District   970811 Program for Adaptive Learning Program           2021   grade_8                                                   0                                             0
2750858 2750858 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_8                                                   0                                             0
2750859 2750859 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_8                                                   0                                             0
2750860 2750860 CT     school   970011   Newtown School District   970711 Reaching Independence through Structured Education Program           2021   grade_8                                                   *                                              
2750861 2750861 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2021   grade_8                                                   338                                             338
2750862 2750862 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2021   grade_8                                                   0                                             0
2750863 2750863 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2021   grade_8                                                   0                                             0
2771214 2771214 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2020   grade_8                                                   0                                             0
2771215 2771215 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_8                                                   0                                             0
2771216 2771216 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_8                                                   0                                             0
2771217 2771217 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_8                                                   0                                             0
2771218 2771218 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_8                                                   0                                             0
2771219 2771219 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_8                                                   0                                             0
2771220 2771220 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   grade_8                                                   341                                             341
2771221 2771221 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   grade_8                                                   0                                             0
2771222 2771222 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2020   grade_8                                                   0                                             0
2445240 2445240 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2019   grade_8                                                   0                                             0
2445241 2445241 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2019   grade_8                                                   0                                             0
2445242 2445242 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_8                                                   0                                             0
2445243 2445243 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   345                                             345
2445244 2445244 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2445245 2445245 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2019   grade_8                                                   0                                             0
2750840 2750840 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2021   grade_8                                                   0                                             0
2750841 2750841 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2021   grade_8                                                   0                                             0
2750842 2750842 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_8                                                   0                                             0
2750843 2750843 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   321                                             321
2750844 2750844 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2021   grade_8                                                   0                                             0
2750845 2750845 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2021   grade_8                                                   0                                             0
2771201 2771201 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2020   grade_8                                                   0                                             0
2771202 2771202 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2020   grade_8                                                   0                                             0
2771203 2771203 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_8                                                   0                                             0
2771204 2771204 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   324                                             324
2771205 2771205 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2020   grade_8                                                   0                                             0
2771206 2771206 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2020   grade_8                                                   0                                             0
2445231 2445231 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445232 2445232 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445233 2445233 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2019   grade_8                                                   0                                             0
2445234 2445234 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_8                                                   0                                             0
2445235 2445235 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_8                                                   0                                             0
2445236 2445236 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_8                                                   107                                             107
2445237 2445237 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_8                                                   52                                             52
2445238 2445238 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2019   grade_8                                                   62                                             62
2445239 2445239 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2750831 2750831 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2021   grade_8                                                   0                                             0
2750832 2750832 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_8                                                   0                                             0
2750833 2750833 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2021   grade_8                                                   0                                             0
2750834 2750834 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_8                                                   0                                             0
2750835 2750835 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_8                                                   0                                             0
2750836 2750836 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2021   grade_8                                                   111                                             111
2750837 2750837 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Secondary 06 11 2021   grade_8                                                   47                                             47
2750838 2750838 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2021   grade_8                                                   66                                             66
2750839 2750839 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2021   grade_8                                                   0                                             0
2771192 2771192 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2020   grade_8                                                   0                                             0
2771193 2771193 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_8                                                   0                                             0
2771194 2771194 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2020   grade_8                                                   0                                             0
2771195 2771195 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_8                                                   0                                             0
2771196 2771196 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_8                                                   0                                             0
2771197 2771197 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2020   grade_8                                                   90                                             90
2771198 2771198 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 10 2020   grade_8                                                   49                                             49
2771199 2771199 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2020   grade_8                                                   75                                             75
2771200 2771200 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2020   grade_8                                                   0                                             0
2445246 2445246 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2019   grade_8                                                   0                                             0
2445247 2445247 CT     school 902880 940011   Newington School District 90288000604 940211 Elizabeth Green School Public Schools Regular School No Elementary PK 04 2019   grade_8                                                   0                                             0
2445248 2445248 CT     school 902880 940011   Newington School District 90288000606 940811 John Paterson School Public Schools Regular School No Elementary PK 04 2019   grade_8                                                   0                                             0
2445249 2445249 CT     school 902880 940011   Newington School District 90288000612 940711 Ruth Chaffee School Public Schools Regular School No Elementary PK 04 2019   grade_8                                                   0                                             0
2445250 2445250 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   168                                             168
2445251 2445251 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2019   grade_8                                                   160                                             160
2445252 2445252 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2750846 2750846 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2021   grade_8                                                   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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