enrollments

Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 20,186 ✖
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
2448169 2448169 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2448170 2448170 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2448171 2448171 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_10                                                   0                                             0
2448172 2448172 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_10                                                   242                                             242
2448173 2448173 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_10                                                   0                                             0
2449616 2449616 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449617 2449617 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449618 2449618 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449619 2449619 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449620 2449620 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2449621 2449621 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_11                                                   260                                             260
2449622 2449622 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_11                                                   0                                             0
2451065 2451065 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451066 2451066 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451067 2451067 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451068 2451068 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451069 2451069 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_12                                                   0                                             0
2451070 2451070 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_12                                                   254                                             254
2451071 2451071 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_12                                                   8                                             8
2452514 2452514 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 275 13 28   * 11     0   *   174 160     8             18   334 275 13 28     11     0       174 160     8       18   334
2452515 2452515 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 272 19 31   0 43     0   15   184 196     31             53   380 272 19 31   0 43     0   15   184 196     31       53   380
2452516 2452516 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 208 * 28   * 19     0   6   142 124     11             28   266 208   28     19     0   6   142 124     11       28   266
2452517 2452517 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 297 18 36   0 26     *   *   193 195     12             41   388 297 18 36   0 26             193 195     12       41   388
2452518 2452518 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   pk_12_total 570 25 61   * 55     0   *   380 351     10             94   731 570 25 61     55     0       380 351     10       94   731
2452519 2452519 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   pk_12_total 827 38 73   * 64     *   29   528 506     11             117   1034 827 38 73     64         29   528 506     11       117   1034
2452520 2452520 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   pk_12_total * 0 *   0 *     0   0   * *     0             8   8   0     0       0   0           0       8   8
2433684 2433684 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   53                                             53
2433685 2433685 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   kindergarten                                                   0                                             0
2435133 2435133 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   54                                             54
2435134 2435134 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2436582 2436582 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   50                                             50
2436583 2436583 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_2                                                   0                                             0
2438031 2438031 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   57                                             57
2438032 2438032 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_3                                                   0                                             0
2439480 2439480 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   62                                             62
2439481 2439481 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_4                                                   0                                             0
2440929 2440929 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   57                                             57
2440930 2440930 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_5                                                   0                                             0
2442378 2442378 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442379 2442379 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_6                                                   62                                             62
2443827 2443827 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443828 2443828 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_7                                                   48                                             48
2445276 2445276 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445277 2445277 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_8                                                   61                                             61
2446725 2446725 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446726 2446726 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_9                                                   47                                             47
2448174 2448174 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2448175 2448175 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_10                                                   42                                             42
2449623 2449623 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449624 2449624 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_11                                                   49                                             49
2451072 2451072 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_12                                                   0                                             0
2451073 2451073 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_12                                                   46                                             46
2452521 2452521 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 05 2019   pk_12_total 325 6 20   * 10     *   *   188 181     0             42   369 325 6 20     10             188 181     0       42   369
2452522 2452522 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   pk_12_total 311 * 9   * 7     *   18   199 156     0             29   355 311   9     7         18   199 156     0       29   355
2433686 2433686 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   61                                             61
2433687 2433687 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   74                                             74
2433688 2433688 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   55                                             55
2433689 2433689 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   kindergarten                                                   0                                             0
2433690 2433690 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   77                                             77
2433691 2433691 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   66                                             66
2433692 2433692 CT     school 903090 1030011   Norwalk School District 90309000642 1030311 Columbus Magnet School Public Schools Regular School No Elementary KG 07 2019   kindergarten                                                   44                                             44
2433693 2433693 CT     school 903090 1030011   Norwalk School District 90309000643 1030411 Cranbury Elementary School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   80                                             80
2433694 2433694 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   74                                             74
2433695 2433695 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   73                                             73
2433696 2433696 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   101                                             101
2433697 2433697 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   88                                             88
2433698 2433698 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2019   kindergarten                                                   48                                             48
2433699 2433699 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2433700 2433700 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2433701 2433701 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2433702 2433702 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2433703 2433703 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2433704 2433704 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2433705 2433705 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2433706 2433706 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2019   kindergarten                                                   0                                             0
2435135 2435135 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   74                                             74
2435136 2435136 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   63                                             63
2435137 2435137 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   57                                             57
2435138 2435138 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_1                                                   0                                             0
2435139 2435139 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   61                                             61
2435140 2435140 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_1                                                   74                                             74
2435141 2435141 CT     school 903090 1030011   Norwalk School District 90309000642 1030311 Columbus Magnet School Public Schools Regular School No Elementary KG 07 2019   grade_1                                                   43                                             43
2435142 2435142 CT     school 903090 1030011   Norwalk School District 90309000643 1030411 Cranbury Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_1                                                   79                                             79
2435143 2435143 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_1                                                   65                                             65
2435144 2435144 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_1                                                   74                                             74
2435145 2435145 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2019   grade_1                                                   87                                             87
2435146 2435146 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_1                                                   83                                             83
2435147 2435147 CT     school 903090 1030011   Norwalk School District 90309000662 1032411 Wolfpit School Public Schools Regular School No Elementary KG 05 2019   grade_1                                                   54                                             54
2435148 2435148 CT     school 903090 1030011   Norwalk School District 90309000653 1035211 Nathan Hale Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2435149 2435149 CT     school 903090 1030011   Norwalk School District 90309000656 1035311 Ponus Ridge Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2435150 2435150 CT     school 903090 1030011   Norwalk School District 90309000657 1035511 Roton Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2435151 2435151 CT     school 903090 1030011   Norwalk School District 90309000661 1035411 West Rocks Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2435152 2435152 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435153 2435153 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435154 2435154 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435155 2435155 CT     school   1030011   Norwalk School District   1030611 Norwalk 18-21 Project SEARCH Program           2019   grade_1                                                   0                                             0
2436584 2436584 CT     school 903090 1030011   Norwalk School District 90309000640 1030211 Brookside Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   55                                             55
2436585 2436585 CT     school 903090 1030011   Norwalk School District 90309000645 1032011 Fox Run Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   73                                             73
2436586 2436586 CT     school 903090 1030011   Norwalk School District 90309000652 1032111 Naramake Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   48                                             48
2436587 2436587 CT     school 903090 1030011   Norwalk School District 90309001914 1030111 Norwalk Early Childhood Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_2                                                   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]);