enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2019 · 20,286 ✖
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
2433279 2433279 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   kindergarten                                                   0                                             0
2434728 2434728 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_1                                                   0                                             0
2436177 2436177 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_2                                                   0                                             0
2437626 2437626 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_3                                                   0                                             0
2439075 2439075 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_4                                                   0                                             0
2440524 2440524 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_5                                                   223                                             223
2441973 2441973 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_6                                                   279                                             279
2443422 2443422 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_7                                                   0                                             0
2444871 2444871 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_8                                                   0                                             0
2446320 2446320 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_9                                                   0                                             0
2447769 2447769 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_10                                                   0                                             0
2449218 2449218 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_11                                                   0                                             0
2450667 2450667 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   grade_12                                                   0                                             0
2452116 2452116 CT     school 901800 600011   Guilford School District 90180000328 600711 A. Baldwin Middle School Public Schools Regular School No Middle 05 06 2019   pk_12_total 413 8 40   0 22     0   19   270 232     11             67   502 413 8 40   0 22     0   19   270 232     11       67   502
2434281 2434281 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   kindergarten                                                   0                                             0
2435730 2435730 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_1                                                   0                                             0
2437179 2437179 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_2                                                   0                                             0
2438628 2438628 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_3                                                   0                                             0
2440077 2440077 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_4                                                   0                                             0
2441526 2441526 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_5                                                   0                                             0
2442975 2442975 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_6                                                   0                                             0
2444424 2444424 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_7                                                   0                                             0
2445873 2445873 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_8                                                   0                                             0
2447322 2447322 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_9                                                   183                                             183
2448771 2448771 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_10                                                   195                                             195
2450220 2450220 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_11                                                   150                                             150
2451669 2451669 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_12                                                   149                                             149
2453118 2453118 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201136 9001516 A. I. Prince Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   pk_12_total 32 177 444   * 13     *   *   339 338     71             64   677 32 177 444     13             339 338     71       64   677
2433276 2433276 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   kindergarten                                                   52                                             52
2434725 2434725 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_1                                                   40                                             40
2436174 2436174 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_2                                                   58                                             58
2437623 2437623 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_3                                                   47                                             47
2439072 2439072 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   69                                             69
2440521 2440521 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_5                                                   0                                             0
2441970 2441970 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_6                                                   0                                             0
2443419 2443419 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_7                                                   0                                             0
2444868 2444868 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_8                                                   0                                             0
2446317 2446317 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_9                                                   0                                             0
2447766 2447766 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_10                                                   0                                             0
2449215 2449215 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_11                                                   0                                             0
2450664 2450664 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   grade_12                                                   0                                             0
2452113 2452113 CT     school 901800 600011   Guilford School District 90180000329 600611 A. W. Cox School Public Schools Regular School No Elementary KG 04 2019   pk_12_total 225 * 18   0 *     0   12   138 128     11             18   266 225   18   0       0   12   138 128     11       18   266
2433973 2433973 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   kindergarten                                                   129                                             129
2435422 2435422 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_1                                                   129                                             129
2436871 2436871 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_2                                                   133                                             133
2438320 2438320 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_3                                                   0                                             0
2439769 2439769 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_4                                                   0                                             0
2441218 2441218 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_5                                                   0                                             0
2442667 2442667 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_6                                                   0                                             0
2444116 2444116 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_7                                                   0                                             0
2445565 2445565 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_8                                                   0                                             0
2447014 2447014 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_9                                                   0                                             0
2448463 2448463 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_10                                                   0                                             0
2449912 2449912 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_11                                                   0                                             0
2451361 2451361 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   grade_12                                                   0                                             0
2452810 2452810 CT     school 904470 1390011   Suffield School District 90447000903 1390411 A. Ward Spaulding School Public Schools Regular School No Elementary PK 02 2019   pk_12_total 367 10 25   0 16     0   12   226 204     14             67   430 367 10 25   0 16     0   12   226 204     14       67   430
2432924 2432924 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   kindergarten                                                   0                                             0
2434373 2434373 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_1                                                   0                                             0
2435822 2435822 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_2                                                   0                                             0
2437271 2437271 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_3                                                   0                                             0
2438720 2438720 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_4                                                   0                                             0
2440169 2440169 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_5                                                   0                                             0
2441618 2441618 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_6                                                   0                                             0
2443067 2443067 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_7                                                   0                                             0
2444516 2444516 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_8                                                   0                                             0
2445965 2445965 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_9                                                   0                                             0
2447414 2447414 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_10                                                   0                                             0
2448863 2448863 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_11                                                   0                                             0
2450312 2450312 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   grade_12                                                   0                                             0
2451761 2451761 CT     school 900450 150011   Bridgeport School District 90045000085 154411 A.B. Skane Center Public Schools Regular School No Prekindergarten PK PK 2019   pk_12_total 41 63 107   0 *     0   *   145 81     0             127   226 41 63 107   0       0       145 81     0       127   226
2434037 2434037 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   kindergarten                                                   0                                             0
2435486 2435486 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_1                                                   0                                             0
2436935 2436935 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_2                                                   0                                             0
2438384 2438384 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_3                                                   0                                             0
2439833 2439833 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_4                                                   0                                             0
2441282 2441282 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_5                                                   0                                             0
2442731 2442731 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_6                                                   *                                              
2444180 2444180 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_7                                                   *                                              
2445629 2445629 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_8                                                   *                                              
2447078 2447078 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_9                                                   *                                              
2448527 2448527 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_10                                                   8                                             8
2449976 2449976 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_11                                                   *                                              
2451425 2451425 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   grade_12                                                   *                                              
2452874 2452874 CT     school   1480011   Wallingford School District   1489011 A.R.T.S. Academy             2019   pk_12_total 16 0 *   0 0     0   *   * *     0             21   21 16 0     0 0     0               0       21   21
2434182 2434182 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   kindergarten                                                   0                                             0
2435631 2435631 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_1                                                   *                                              
2437080 2437080 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_2                                                   *                                              
2438529 2438529 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_3                                                   0                                             0
2439978 2439978 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_4                                                   *                                              
2441427 2441427 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_5                                                   0                                             0
2442876 2442876 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_6                                                   0                                             0
2444325 2444325 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_7                                                   0                                             0
2445774 2445774 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_8                                                   0                                             0
2447223 2447223 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_9                                                   0                                             0
2448672 2448672 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_10                                                   0                                             0
2450121 2450121 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_11                                                   0                                             0
2451570 2451570 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   grade_12                                                   0                                             0
2453019 2453019 CT     school   1590011   Wethersfield School District   1590411 ABA Program           2019   pk_12_total 0 * *   0 0     0   *   * *     *             7   7 0       0 0     0                       7   7
2433953 2433953 CT     school   1380011   Stratford School District 90444001734 1380611 ABA - K-6 Program           2019   kindergarten                                                   *                                              
2435402 2435402 CT     school   1380011   Stratford School District 90444001734 1380611 ABA - K-6 Program           2019   grade_1                                                   *                                              

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