enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 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
2443814 2443814 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2019   grade_7                                                   0                                             0
2443815 2443815 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2019   grade_7                                                   0                                             0
2443816 2443816 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   139                                             139
2443817 2443817 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443818 2443818 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2019   grade_7                                                   0                                             0
2749421 2749421 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_7                                                   0                                             0
2749422 2749422 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_7                                                   0                                             0
2749423 2749423 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   130                                             130
2749424 2749424 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_7                                                   0                                             0
2749425 2749425 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_7                                                   0                                             0
2769763 2769763 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_7                                                   0                                             0
2769764 2769764 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_7                                                   0                                             0
2769765 2769765 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   125                                             125
2769766 2769766 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769767 2769767 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_7                                                   0                                             0
2443813 2443813 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_7                                                   0                                             0
2749420 2749420 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2769762 2769762 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_7                                                   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
2749409 2749409 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2021   grade_7                                                   0                                             0
2749410 2749410 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
2749411 2749411 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
2749412 2749412 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
2749413 2749413 CT     school   970011   Newtown School District   970811 Program for Adaptive Learning Program           2021   grade_7                                                   0                                             0
2749414 2749414 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_7                                                   0                                             0
2749415 2749415 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_7                                                   0                                             0
2749416 2749416 CT     school   970011   Newtown School District   970711 Reaching Independence through Structured Education Program           2021   grade_7                                                   7                                             7
2749417 2749417 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2021   grade_7                                                   285                                             285
2749418 2749418 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2021   grade_7                                                   0                                             0
2749419 2749419 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2021   grade_7                                                   0                                             0
2769753 2769753 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2020   grade_7                                                   0                                             0
2769754 2769754 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_7                                                   0                                             0
2769755 2769755 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_7                                                   0                                             0
2769756 2769756 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_7                                                   0                                             0
2769757 2769757 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_7                                                   0                                             0
2769758 2769758 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_7                                                   0                                             0
2769759 2769759 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   grade_7                                                   339                                             339
2769760 2769760 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769761 2769761 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2020   grade_7                                                   0                                             0
2443791 2443791 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2019   grade_7                                                   0                                             0
2443792 2443792 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2019   grade_7                                                   0                                             0
2443793 2443793 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_7                                                   0                                             0
2443794 2443794 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   323                                             323
2443795 2443795 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443796 2443796 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2019   grade_7                                                   0                                             0
2749396 2749396 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2021   grade_7                                                   0                                             0
2749397 2749397 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2021   grade_7                                                   0                                             0
2749398 2749398 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_7                                                   0                                             0
2749399 2749399 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   282                                             282
2749400 2749400 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2021   grade_7                                                   0                                             0
2749401 2749401 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2021   grade_7                                                   0                                             0
2769740 2769740 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2020   grade_7                                                   0                                             0
2769741 2769741 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2020   grade_7                                                   0                                             0
2769742 2769742 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_7                                                   0                                             0
2769743 2769743 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   323                                             323
2769744 2769744 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2769745 2769745 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2020   grade_7                                                   0                                             0
2443782 2443782 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_7                                                   0                                             0
2443783 2443783 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443784 2443784 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2019   grade_7                                                   0                                             0
2443785 2443785 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_7                                                   0                                             0
2443786 2443786 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_7                                                   0                                             0
2443787 2443787 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_7                                                   88                                             88
2443788 2443788 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_7                                                   63                                             63
2443789 2443789 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_7                                                   73                                             73
2443790 2443790 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2749387 2749387 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_7                                                   0                                             0
2749388 2749388 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_7                                                   0                                             0
2749389 2749389 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2021   grade_7                                                   0                                             0
2749390 2749390 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_7                                                   0                                             0
2749391 2749391 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_7                                                   0                                             0
2749392 2749392 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_7                                                   119                                             119
2749393 2749393 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_7                                                   40                                             40
2749394 2749394 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_7                                                   50                                             50
2749395 2749395 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2021   grade_7                                                   0                                             0
2769731 2769731 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_7                                                   0                                             0
2769732 2769732 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_7                                                   0                                             0
2769733 2769733 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2020   grade_7                                                   0                                             0
2769734 2769734 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_7                                                   0                                             0
2769735 2769735 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_7                                                   0                                             0
2769736 2769736 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_7                                                   86                                             86
2769737 2769737 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_7                                                   53                                             53
2769738 2769738 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_7                                                   73                                             73
2769739 2769739 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2020   grade_7                                                   0                                             0
2443797 2443797 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2019   grade_7                                                   0                                             0
2443798 2443798 CT     school 902880 940011   Newington School District 90288000604 940211 Elizabeth Green School Public Schools Regular School No Elementary PK 04 2019   grade_7                                                   0                                             0
2443799 2443799 CT     school 902880 940011   Newington School District 90288000606 940811 John Paterson School Public Schools Regular School No Elementary PK 04 2019   grade_7                                                   0                                             0
2443800 2443800 CT     school 902880 940011   Newington School District 90288000612 940711 Ruth Chaffee School Public Schools Regular School No Elementary PK 04 2019   grade_7                                                   0                                             0
2443801 2443801 CT     school 902880 940011   Newington School District 90288001120 945311 John Wallace Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   178                                             178
2443802 2443802 CT     school 902880 940011   Newington School District 90288000608 945111 Martin Kellogg Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   160                                             160
2443803 2443803 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2749402 2749402 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2021   grade_7                                                   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]);