enrollments

Data source: Big Local News · About: Big Local

20,216 rows where state = "CT" and year = 2021 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 20,116 ✖
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
2753761 2753761 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_10                                                   0                                             0
2753762 2753762 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_10                                                   0                                             0
2753763 2753763 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   grade_10                                                   0                                             0
2753764 2753764 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2021   grade_10                                                   218                                             218
2753765 2753765 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2021   grade_10                                                   0                                             0
2755203 2755203 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_11                                                   0                                             0
2755204 2755204 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_11                                                   0                                             0
2755205 2755205 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_11                                                   0                                             0
2755206 2755206 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_11                                                   0                                             0
2755207 2755207 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   grade_11                                                   0                                             0
2755208 2755208 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2021   grade_11                                                   262                                             262
2755209 2755209 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2021   grade_11                                                   0                                             0
2756647 2756647 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_12                                                   0                                             0
2756648 2756648 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_12                                                   0                                             0
2756649 2756649 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756650 2756650 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_12                                                   0                                             0
2756651 2756651 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   grade_12                                                   0                                             0
2756652 2756652 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2021   grade_12                                                   237                                             237
2756653 2756653 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2021   grade_12                                                   10                                             10
2758091 2758091 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 261 22 45   0 39     0   13   179 201     36             53   380 261 22 45   0 39     0   13   179 201     36       53   380
2758092 2758092 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2021   pk_12_total 258 31 41   * 27     0   *   192 187     13             47   379 258 31 41     27     0       192 187     13       47   379
2758093 2758093 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 265 15 36   * 9     0   *   178 157     11             16   335 265 15 36     9     0       178 157     11       16   335
2758094 2758094 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary KG 05 2021   pk_12_total 200 * 28   * 30     0   13   149 128     20             34   277 200   28     30     0   13   149 128     20       34   277
2758095 2758095 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2021   pk_12_total 551 26 72   0 57     0   33   369 370     16             95   739 551 26 72   0 57     0   33   369 370     16       95   739
2758096 2758096 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2021   pk_12_total 723 40 87   0 68     0   31   485 464     11             113   949 723 40 87   0 68     0   31   485 464     11       113   949
2758097 2758097 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2021   pk_12_total 7 * *   0 *     0   0   * *     0             10   10 7       0       0   0           0       10   10
2739326 2739326 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   kindergarten                                                   48                                             48
2739327 2739327 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   kindergarten                                                   0                                             0
2740770 2740770 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_1                                                   48                                             48
2740771 2740771 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_1                                                   0                                             0
2742214 2742214 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_2                                                   50                                             50
2742215 2742215 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_2                                                   0                                             0
2743658 2743658 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_3                                                   52                                             52
2743659 2743659 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_3                                                   0                                             0
2745102 2745102 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_4                                                   52                                             52
2745103 2745103 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_4                                                   0                                             0
2746546 2746546 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_5                                                   59                                             59
2746547 2746547 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_5                                                   0                                             0
2747990 2747990 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   58                                             58
2747991 2747991 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_6                                                   0                                             0
2749434 2749434 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_7                                                   0                                             0
2749435 2749435 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_7                                                   53                                             53
2750878 2750878 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_8                                                   0                                             0
2750879 2750879 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_8                                                   67                                             67
2752322 2752322 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_9                                                   0                                             0
2752323 2752323 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_9                                                   47                                             47
2753766 2753766 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
2753767 2753767 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_10                                                   54                                             54
2755210 2755210 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_11                                                   0                                             0
2755211 2755211 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_11                                                   50                                             50
2756654 2756654 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_12                                                   0                                             0
2756655 2756655 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   grade_12                                                   47                                             47
2758098 2758098 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2021   pk_12_total 338 11 22   * 7     *   0   194 190     0             42   384 338 11 22     7         0   194 190     0       42   384
2758099 2758099 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2021   pk_12_total 275 * 15   * *     0   15   162 156     0             25   318 275   15           0   15   162 156     0       25   318
2739328 2739328 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   66                                             66
2739329 2739329 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   61                                             61
2739330 2739330 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   52                                             52
2739331 2739331 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   68                                             68
2739332 2739332 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2021   kindergarten                                                   57                                             57
2739333 2739333 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
2739334 2739334 CT     school 903090 1030011   Norwalk School District 90309000642 1030311 Columbus Magnet School Public Schools Regular School No Elementary KG 08 2021   kindergarten                                                   40                                             40
2739335 2739335 CT     school 903090 1030011   Norwalk School District 90309000643 1030411 Cranbury Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   71                                             71
2739336 2739336 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   62                                             62
2739337 2739337 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   82                                             82
2739338 2739338 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   70                                             70
2739339 2739339 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   56                                             56
2739340 2739340 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2021   kindergarten                                                   52                                             52
2739341 2739341 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739342 2739342 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739343 2739343 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739344 2739344 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2021   kindergarten                                                   0                                             0
2739345 2739345 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739346 2739346 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739347 2739347 CT     school   1030011   Norwalk School District   1031011 Norwalk Alternative Opportunity Program Program           2021   kindergarten                                                   0                                             0
2739348 2739348 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739349 2739349 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2021   kindergarten                                                   0                                             0
2739350 2739350 CT     school   1030011   Norwalk School District   1031111 Norwalk 18-21 Next Steps (NNS) Program           2021   kindergarten                                                   0                                             0
2739351 2739351 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2021   kindergarten                                                   0                                             0
2740772 2740772 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   62                                             62
2740773 2740773 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   59                                             59
2740774 2740774 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   77                                             77
2740775 2740775 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   86                                             86
2740776 2740776 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2021   grade_1                                                   60                                             60
2740777 2740777 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2021   grade_1                                                   0                                             0
2740778 2740778 CT     school 903090 1030011   Norwalk School District 90309000642 1030311 Columbus Magnet School Public Schools Regular School No Elementary KG 08 2021   grade_1                                                   37                                             37
2740779 2740779 CT     school 903090 1030011   Norwalk School District 90309000643 1030411 Cranbury Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   62                                             62
2740780 2740780 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   75                                             75
2740781 2740781 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   83                                             83
2740782 2740782 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   85                                             85
2740783 2740783 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   85                                             85
2740784 2740784 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2021   grade_1                                                   53                                             53
2740785 2740785 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740786 2740786 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740787 2740787 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740788 2740788 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2021   grade_1                                                   0                                             0
2740789 2740789 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740790 2740790 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740791 2740791 CT     school   1030011   Norwalk School District   1031011 Norwalk Alternative Opportunity Program Program           2021   grade_1                                                   0                                             0
2740792 2740792 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2021   grade_1                                                   0                                             0
2740793 2740793 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2021   grade_1                                                   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]);