enrollments

Data source: Big Local News · About: Big Local

20,454 rows where state = "CT" and year = 2020 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 20,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
2774154 2774154 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_10                                                   0                                             0
2774155 2774155 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_10                                                   0                                             0
2774156 2774156 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2020   grade_10                                                   0                                             0
2774157 2774157 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2020   grade_10                                                   278                                             278
2774158 2774158 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2020   grade_10                                                   0                                             0
2775613 2775613 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775614 2775614 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775615 2775615 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775616 2775616 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_11                                                   0                                             0
2775617 2775617 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2020   grade_11                                                   0                                             0
2775618 2775618 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2020   grade_11                                                   236                                             236
2775619 2775619 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2020   grade_11                                                   0                                             0
2777074 2777074 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777075 2777075 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777076 2777076 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777077 2777077 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_12                                                   0                                             0
2777078 2777078 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2020   grade_12                                                   0                                             0
2777079 2777079 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2020   grade_12                                                   264                                             264
2777080 2777080 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2020   grade_12                                                   13                                             13
2778535 2778535 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 261 10 40   * *     0   15   175 161     11             17   336 261 10 40           0   15   175 161     11       17   336
2778536 2778536 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 285 25 37   0 38     0   16   189 212     35             56   401 285 25 37   0 38     0   16   189 212     35       56   401
2778537 2778537 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 212 * 24   * 23     0   7   145 129     16             32   274 212   24     23     0   7   145 129     16       32   274
2778538 2778538 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2020   pk_12_total 276 26 47   * 28     0   *   195 203     15             42   398 276 26 47     28     0       195 203     15       42   398
2778539 2778539 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2020   pk_12_total 559 27 67   0 60     0   25   385 353     11             101   738 559 27 67   0 60     0   25   385 353     11       101   738
2778540 2778540 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2020   pk_12_total 778 43 85   * 63     0   *   502 498     12             108   1000 778 43 85     63     0       502 498     12       108   1000
2778541 2778541 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2020   pk_12_total 10 0 *   0 *     0   0   * *     0             13   13 10 0     0       0   0           0       13   13
2759549 2759549 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   kindergarten                                                   53                                             53
2759550 2759550 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   kindergarten                                                   0                                             0
2761010 2761010 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_1                                                   51                                             51
2761011 2761011 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_1                                                   0                                             0
2762471 2762471 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_2                                                   55                                             55
2762472 2762472 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_2                                                   0                                             0
2763932 2763932 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_3                                                   52                                             52
2763933 2763933 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_3                                                   0                                             0
2765393 2765393 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_4                                                   60                                             60
2765394 2765394 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_4                                                   0                                             0
2766854 2766854 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_5                                                   63                                             63
2766855 2766855 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_5                                                   0                                             0
2768315 2768315 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   56                                             56
2768316 2768316 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_6                                                   0                                             0
2769776 2769776 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_7                                                   0                                             0
2769777 2769777 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_7                                                   63                                             63
2771237 2771237 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_8                                                   0                                             0
2771238 2771238 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_8                                                   49                                             49
2772698 2772698 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
2772699 2772699 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_9                                                   54                                             54
2774159 2774159 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_10                                                   0                                             0
2774160 2774160 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_10                                                   53                                             53
2775620 2775620 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_11                                                   0                                             0
2775621 2775621 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_11                                                   47                                             47
2777081 2777081 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_12                                                   0                                             0
2777082 2777082 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   grade_12                                                   48                                             48
2778542 2778542 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   pk_12_total 377 8 21   6 11     *   *   217 210     0             42   427 377 8 21   6 11             217 210     0       42   427
2778543 2778543 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 07 12 2020   pk_12_total 269 * 12   * 6     *   18   175 139     0             27   314 269   12     6         18   175 139     0       27   314
2759551 2759551 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   60                                             60
2759552 2759552 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   66                                             66
2759553 2759553 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   74                                             74
2759554 2759554 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   79                                             79
2759555 2759555 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2020   kindergarten                                                   68                                             68
2759556 2759556 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
2759557 2759557 CT     school 903090 1030011   Norwalk School District 90309000642 1030311 Columbus Magnet School Public Schools Regular School No Elementary KG 08 2020   kindergarten                                                   44                                             44
2759558 2759558 CT     school 903090 1030011   Norwalk School District 90309000643 1030411 Cranbury Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   63                                             63
2759559 2759559 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   76                                             76
2759560 2759560 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   80                                             80
2759561 2759561 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   81                                             81
2759562 2759562 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   80                                             80
2759563 2759563 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2020   kindergarten                                                   52                                             52
2759564 2759564 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759565 2759565 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759566 2759566 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759567 2759567 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2020   kindergarten                                                   0                                             0
2759568 2759568 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759569 2759569 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759570 2759570 CT     school   1030011   Norwalk School District   1031011 Norwalk Alternative Opportunity Program Program           2020   kindergarten                                                   0                                             0
2759571 2759571 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759572 2759572 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2020   kindergarten                                                   0                                             0
2759573 2759573 CT     school   1030011   Norwalk School District   1031111 Norwalk 18-21 Next Steps (NNS) Program           2020   kindergarten                                                   0                                             0
2759574 2759574 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2020   kindergarten                                                   0                                             0
2761012 2761012 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_1                                                   65                                             65
2761013 2761013 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_1                                                   72                                             72
2761014 2761014 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_1                                                   68                                             68
2761015 2761015 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_1                                                   77                                             77
2761016 2761016 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_1                                                   52                                             52
2761017 2761017 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_1                                                   0                                             0
2761018 2761018 CT     school 903090 1030011   Norwalk School District 90309000642 1030311 Columbus Magnet School Public Schools Regular School No Elementary KG 08 2020   grade_1                                                   44                                             44
2761019 2761019 CT     school 903090 1030011   Norwalk School District 90309000643 1030411 Cranbury Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_1                                                   76                                             76
2761020 2761020 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_1                                                   72                                             72
2761021 2761021 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2020   grade_1                                                   98                                             98
2761022 2761022 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_1                                                   88                                             88
2761023 2761023 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_1                                                   80                                             80
2761024 2761024 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2020   grade_1                                                   41                                             41
2761025 2761025 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2761026 2761026 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2761027 2761027 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2761028 2761028 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2020   grade_1                                                   0                                             0
2761029 2761029 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2020   grade_1                                                   0                                             0
2761030 2761030 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   grade_1                                                   0                                             0
2761031 2761031 CT     school   1030011   Norwalk School District   1031011 Norwalk Alternative Opportunity Program Program           2020   grade_1                                                   0                                             0
2761032 2761032 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2020   grade_1                                                   0                                             0
2761033 2761033 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2020   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]);