enrollments

Data source: Big Local News · About: Big Local

20,286 rows where state = "CT" and year = 2019 sorted by school_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
2435764 2435764 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2437213 2437213 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_3                                                   0                                             0
2438662 2438662 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_4                                                   0                                             0
2440111 2440111 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_5                                                   0                                             0
2441560 2441560 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_6                                                   0                                             0
2443009 2443009 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2444458 2444458 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2445907 2445907 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_9                                                   161                                             161
2447356 2447356 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_10                                                   107                                             107
2448805 2448805 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_11                                                   142                                             142
2450254 2450254 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   grade_12                                                   155                                             155
2451703 2451703 CT     school 900060 20011   Ansonia School District 90006010002 26111 Ansonia High School Public Schools Regular School No High 09 12 2019   pk_12_total 228 116 185   * *     10   15   302 263     19             126   565 228 116 185           10   15   302 263     19       126   565
2432879 2432879 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   36                                             36
2434328 2434328 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_1                                                   42                                             42
2435777 2435777 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_2                                                   35                                             35
2437226 2437226 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_3                                                   46                                             46
2438675 2438675 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_4                                                   41                                             41
2440124 2440124 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   46                                             46
2441573 2441573 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   31                                             31
2443022 2443022 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   41                                             41
2444471 2444471 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_8                                                   45                                             45
2445920 2445920 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_9                                                   0                                             0
2447369 2447369 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2448818 2448818 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_11                                                   0                                             0
2450267 2450267 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2451716 2451716 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 344 8 31   0 *     *   20   210 199     9             47   409 344 8 31   0           20   210 199     9       47   409
2432880 2432880 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   kindergarten                                                   0                                             0
2434329 2434329 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_1                                                   0                                             0
2435778 2435778 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_2                                                   0                                             0
2437227 2437227 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_3                                                   0                                             0
2438676 2438676 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_4                                                   0                                             0
2440125 2440125 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_5                                                   0                                             0
2441574 2441574 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_6                                                   0                                             0
2443023 2443023 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_7                                                   0                                             0
2444472 2444472 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_8                                                   0                                             0
2445921 2445921 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_9                                                   0                                             0
2447370 2447370 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_10                                                   0                                             0
2448819 2448819 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_11                                                   0                                             0
2450268 2450268 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_12                                                   0                                             0
2451717 2451717 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   pk_12_total 31 10 *   0 10     0   *   34 24     0             24   58 31 10     0 10     0       34 24     0       24   58
2432882 2432882 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   kindergarten                                                   101                                             101
2434331 2434331 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_1                                                   69                                             69
2435780 2435780 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_2                                                   114                                             114
2437229 2437229 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_3                                                   92                                             92
2438678 2438678 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   107                                             107
2440127 2440127 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_5                                                   0                                             0
2441576 2441576 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_6                                                   0                                             0
2443025 2443025 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_7                                                   0                                             0
2444474 2444474 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_8                                                   0                                             0
2445923 2445923 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_9                                                   0                                             0
2447372 2447372 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_10                                                   0                                             0
2448821 2448821 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_11                                                   0                                             0
2450270 2450270 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_12                                                   0                                             0
2451719 2451719 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 319 24 27   * 93     0   *   252 231     15             38   483 319 24 27     93     0       252 231     15       38   483
2432881 2432881 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   kindergarten                                                   105                                             105
2434330 2434330 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_1                                                   119                                             119
2435779 2435779 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_2                                                   122                                             122
2437228 2437228 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_3                                                   133                                             133
2438677 2438677 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   147                                             147
2440126 2440126 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_5                                                   0                                             0
2441575 2441575 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_6                                                   0                                             0
2443024 2443024 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_7                                                   0                                             0
2444473 2444473 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_8                                                   0                                             0
2445922 2445922 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_9                                                   0                                             0
2447371 2447371 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_10                                                   0                                             0
2448820 2448820 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_11                                                   0                                             0
2450269 2450269 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_12                                                   0                                             0
2451718 2451718 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 367 35 43   * 156     0   *   297 329     75             55   626 367 35 43     156     0       297 329     75       55   626
2432883 2432883 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   kindergarten                                                   0                                             0
2434332 2434332 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_1                                                   0                                             0
2435781 2435781 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_2                                                   0                                             0
2437230 2437230 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_3                                                   0                                             0
2438679 2438679 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_4                                                   0                                             0
2440128 2440128 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   242                                             242
2441577 2441577 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_6                                                   267                                             267
2443026 2443026 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_7                                                   0                                             0
2444475 2444475 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
2445924 2445924 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_9                                                   0                                             0
2447373 2447373 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_10                                                   0                                             0
2448822 2448822 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_11                                                   0                                             0
2450271 2450271 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_12                                                   0                                             0
2451720 2451720 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   pk_12_total 309 28 44   * 104     0   *   243 266     9             49   509 309 28 44     104     0       243 266     9       49   509
2432884 2432884 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   kindergarten                                                   0                                             0
2434333 2434333 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_1                                                   0                                             0
2435782 2435782 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_2                                                   0                                             0
2437231 2437231 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_3                                                   0                                             0
2438680 2438680 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_4                                                   0                                             0
2440129 2440129 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_5                                                   0                                             0
2441578 2441578 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_6                                                   0                                             0
2443027 2443027 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   238                                             238
2444476 2444476 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_8                                                   273                                             273
2445925 2445925 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_9                                                   0                                             0
2447374 2447374 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_10                                                   0                                             0
2448823 2448823 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_11                                                   0                                             0
2450272 2450272 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_12                                                   0                                             0
2451721 2451721 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   pk_12_total 339 21 34   0 96     0   21   251 260     6             48   511 339 21 34   0 96     0   21   251 260     6       48   511
2432885 2432885 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2434334 2434334 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435783 2435783 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2437232 2437232 CT     school 900120 40011   Avon School District 90012000011 46111 Avon High School Public Schools Regular School No High 09 12 2019   grade_3                                                   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]);