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,326 ✖
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
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
2761034 2761034 CT     school   1030011   Norwalk School District   1031111 Norwalk 18-21 Next Steps (NNS) Program           2020   grade_1                                                   0                                             0
2761035 2761035 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2020   grade_1                                                   0                                             0
2762473 2762473 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   76                                             76
2762474 2762474 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   65                                             65
2762475 2762475 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   74                                             74
2762476 2762476 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   66                                             66
2762477 2762477 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_2                                                   65                                             65
2762478 2762478 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2020   grade_2                                                   0                                             0
2762479 2762479 CT     school 903090 1030011   Norwalk School District 90309000642 1030311 Columbus Magnet School Public Schools Regular School No Elementary KG 08 2020   grade_2                                                   43                                             43
2762480 2762480 CT     school 903090 1030011   Norwalk School District 90309000643 1030411 Cranbury Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   81                                             81
2762481 2762481 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   70                                             70
2762482 2762482 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   80                                             80
2762483 2762483 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   81                                             81
2762484 2762484 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   70                                             70
2762485 2762485 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2020   grade_2                                                   56                                             56
2762486 2762486 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2020   grade_2                                                   0                                             0
2762487 2762487 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2020   grade_2                                                   0                                             0
2762488 2762488 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2020   grade_2                                                   0                                             0
2762489 2762489 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2020   grade_2                                                   0                                             0
2762490 2762490 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2020   grade_2                                                   0                                             0
2762491 2762491 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2020   grade_2                                                   0                                             0
2762492 2762492 CT     school   1030011   Norwalk School District   1031011 Norwalk Alternative Opportunity Program Program           2020   grade_2                                                   0                                             0
2762493 2762493 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2020   grade_2                                                   0                                             0
2762494 2762494 CT     school 903090 1030011   Norwalk School District 90309001923 1030911 P-TECH Norwalk Public Schools Regular School No High 09 12 2020   grade_2                                                   0                                             0
2762495 2762495 CT     school   1030011   Norwalk School District   1031111 Norwalk 18-21 Next Steps (NNS) Program           2020   grade_2                                                   0                                             0
2762496 2762496 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2020   grade_2                                                   0                                             0
2763934 2763934 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_3                                                   54                                             54
2763935 2763935 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2020   grade_3                                                   64                                             64

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