enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 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
2435120 2435120 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2019   grade_1                                                   111                                             111
2435121 2435121 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 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
2435123 2435123 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435124 2435124 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2019   grade_1                                                   0                                             0
2740757 2740757 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2021   grade_1                                                   124                                             124
2740758 2740758 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740759 2740759 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740760 2740760 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740761 2740761 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2021   grade_1                                                   0                                             0
2760997 2760997 CT     school 902970 990011   North Branford School District 90297000620 990411 Jerome Harrison School Public Schools Regular School No Elementary PK 02 2020   grade_1                                                   110                                             110
2760998 2760998 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2020   grade_1                                                   0                                             0
2760999 2760999 CT     school 902970 990011   North Branford School District 90297000622 995111 North Branford Intermediate School Public Schools Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2761000 2761000 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2020   grade_1                                                   0                                             0
2761001 2761001 CT     school   990011   North Branford School District 90297001621 999011 School to Work Program Program           2020   grade_1                                                   0                                             0
2435119 2435119 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_1                                                   9                                             9
2740756 2740756 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_1                                                   *                                              
2760996 2760996 CT     school 902940 980011   Norfolk School District 90294000618 980111 Botelle Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_1                                                   9                                             9
2435110 2435110 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2019   grade_1                                                   0                                             0
2435111 2435111 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2019   grade_1                                                   58                                             58
2435112 2435112 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2019   grade_1                                                   57                                             57
2435113 2435113 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2019   grade_1                                                   67                                             67
2435114 2435114 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2019   grade_1                                                   75                                             75
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
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
2740745 2740745 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2021   grade_1                                                   0                                             0
2740746 2740746 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   57                                             57
2740747 2740747 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   48                                             48
2740748 2740748 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   72                                             72
2740749 2740749 CT     school   970011   Newtown School District   970811 Program for Adaptive Learning Program           2021   grade_1                                                   0                                             0
2740750 2740750 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2021   grade_1                                                   67                                             67
2740751 2740751 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_1                                                   0                                             0
2740752 2740752 CT     school   970011   Newtown School District   970711 Reaching Independence through Structured Education Program           2021   grade_1                                                   0                                             0
2740753 2740753 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2021   grade_1                                                   0                                             0
2740754 2740754 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740755 2740755 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2021   grade_1                                                   0                                             0
2760987 2760987 CT     school   970011   Newtown School District 90291001391 978011 Newtown Preschool Program           2020   grade_1                                                   0                                             0
2760988 2760988 CT     school 902910 970011   Newtown School District 90291000613 970111 Hawley Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   60                                             60
2760989 2760989 CT     school 902910 970011   Newtown School District 90291001121 970411 Head O'Meadow Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   70                                             70
2760990 2760990 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   62                                             62
2760991 2760991 CT     school 902910 970011   Newtown School District 90291000617 970211 Sandy Hook Elementary School Public Schools Regular School No Elementary KG 04 2020   grade_1                                                   67                                             67
2760992 2760992 CT     school 902910 970011   Newtown School District 90291001487 970511 Reed Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_1                                                   0                                             0
2760993 2760993 CT     school 902910 970011   Newtown School District 90291000616 975111 Newtown Middle School Public Schools Regular School No Middle 07 08 2020   grade_1                                                   0                                             0
2760994 2760994 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2020   grade_1                                                   0                                             0
2760995 2760995 CT     school   970011   Newtown School District   970611 Newtown Community Partnership Program           2020   grade_1                                                   0                                             0
2435097 2435097 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2019   grade_1                                                   102                                             102
2435098 2435098 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2019   grade_1                                                   131                                             131
2435099 2435099 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 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
2435101 2435101 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435102 2435102 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2019   grade_1                                                   0                                             0
2740732 2740732 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2021   grade_1                                                   101                                             101
2740733 2740733 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2021   grade_1                                                   135                                             135
2740734 2740734 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2021   grade_1                                                   0                                             0
2740735 2740735 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740736 2740736 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740737 2740737 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2021   grade_1                                                   0                                             0
2760974 2760974 CT     school 902850 960011   New Milford School District 90285000599 960511 Hill And Plain School Public Schools Regular School No Elementary PK 02 2020   grade_1                                                   111                                             111
2760975 2760975 CT     school 902850 960011   New Milford School District 90285001168 960811 Northville Elementary School Public Schools Regular School No Elementary PK 02 2020   grade_1                                                   145                                             145
2760976 2760976 CT     school 902850 960011   New Milford School District 90285001372 960911 Sarah Noble Intermediate School Public Schools Regular School No Elementary 03 05 2020   grade_1                                                   0                                             0
2760977 2760977 CT     school 902850 960011   New Milford School District 90285000603 965211 Schaghticoke Middle School Public Schools Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2760978 2760978 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2020   grade_1                                                   0                                             0
2760979 2760979 CT     school   960011   New Milford School District 90285001577 969011 Litchfield Hills Transition Center Program           2020   grade_1                                                   0                                             0
2435088 2435088 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_1                                                   70                                             70
2435089 2435089 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   50                                             50
2435090 2435090 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2019   grade_1                                                   0                                             0
2435091 2435091 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_1                                                   88                                             88
2435092 2435092 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_1                                                   94                                             94
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
2435095 2435095 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_1                                                   0                                             0
2435096 2435096 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2740723 2740723 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_1                                                   86                                             86
2740724 2740724 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   48                                             48
2740725 2740725 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2021   grade_1                                                   0                                             0
2740726 2740726 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_1                                                   91                                             91
2740727 2740727 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_1                                                   94                                             94
2740728 2740728 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_1                                                   0                                             0
2740729 2740729 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_1                                                   0                                             0
2740730 2740730 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_1                                                   0                                             0
2740731 2740731 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2760965 2760965 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_1                                                   86                                             86
2760966 2760966 CT     school 902820 950011   New London School District 90282001685 950611 Harbor Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_1                                                   45                                             45
2760967 2760967 CT     school   950011   New London School District   950711 Pre-Kindergarten at Winthrop Program           2020   grade_1                                                   0                                             0
2760968 2760968 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_1                                                   84                                             84
2760969 2760969 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_1                                                   85                                             85
2760970 2760970 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_1                                                   0                                             0
2760971 2760971 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_1                                                   0                                             0
2760972 2760972 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_1                                                   0                                             0
2760973 2760973 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2020   grade_1                                                   0                                             0
2435103 2435103 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2019   grade_1                                                   70                                             70
2435104 2435104 CT     school 902880 940011   Newington School District 90288000604 940211 Elizabeth Green School Public Schools Regular School No Elementary PK 04 2019   grade_1                                                   60                                             60
2435105 2435105 CT     school 902880 940011   Newington School District 90288000606 940811 John Paterson School Public Schools Regular School No Elementary PK 04 2019   grade_1                                                   59                                             59
2435106 2435106 CT     school 902880 940011   Newington School District 90288000612 940711 Ruth Chaffee School Public Schools Regular School No Elementary PK 04 2019   grade_1                                                   59                                             59
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
2435109 2435109 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2740738 2740738 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2021   grade_1                                                   75                                             75

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