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,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
2433676 2433676 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   kindergarten                                                   31                                             31
2435125 2435125 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_1                                                   27                                             27
2436574 2436574 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_2                                                   37                                             37
2438023 2438023 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_3                                                   22                                             22
2439472 2439472 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_4                                                   18                                             18
2440921 2440921 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   28                                             28
2442370 2442370 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   38                                             38
2443819 2443819 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   20                                             20
2445268 2445268 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_8                                                   28                                             28
2446717 2446717 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_9                                                   0                                             0
2448166 2448166 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2449615 2449615 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_11                                                   0                                             0
2451064 2451064 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_12                                                   0                                             0
2452513 2452513 CT     school 903000 1000011   North Canaan School District 90300000626 1000111 North Canaan Elementary School Public Schools Regular School No Elementary PK 08 2019   pk_12_total 213 * 28   0 *     0   9   127 128     7             42   255 213   28   0       0   9   127 128     7       42   255
2432861 2432861 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   kindergarten                                                   22                                             22
2434310 2434310 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_1                                                   18                                             18
2435759 2435759 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_2                                                   16                                             16
2437208 2437208 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_3                                                   22                                             22
2438657 2438657 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_4                                                   21                                             21
2440106 2440106 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_5                                                   28                                             28
2441555 2441555 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   27                                             27
2443004 2443004 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_7                                                   0                                             0
2444453 2444453 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_8                                                   0                                             0
2445902 2445902 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_9                                                   0                                             0
2447351 2447351 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_10                                                   0                                             0
2448800 2448800 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_11                                                   0                                             0
2450249 2450249 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_12                                                   0                                             0
2451698 2451698 CT     school 900030 10011   Andover School District 90003010001 10111 Andover Elementary School Public Schools Regular School No Elementary PK 06 2019   pk_12_total 164 * 17   0 0     0   *   101 90     *             12   191 164   17   0 0     0       101 90             12   191
2433677 2433677 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   55                                             55
2433678 2433678 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   48                                             48
2433679 2433679 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   36                                             36
2433680 2433680 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   kindergarten                                                   53                                             53
2433681 2433681 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   kindergarten                                                   0                                             0
2433682 2433682 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   kindergarten                                                   0                                             0
2433683 2433683 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   kindergarten                                                   0                                             0
2435126 2435126 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   64                                             64
2435127 2435127 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   62                                             62
2435128 2435128 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   52                                             52
2435129 2435129 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_1                                                   55                                             55
2435130 2435130 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_1                                                   0                                             0
2435131 2435131 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435132 2435132 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_1                                                   0                                             0
2436575 2436575 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   63                                             63
2436576 2436576 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   60                                             60
2436577 2436577 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   47                                             47
2436578 2436578 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_2                                                   60                                             60
2436579 2436579 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2436580 2436580 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436581 2436581 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_2                                                   0                                             0
2438024 2438024 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   51                                             51
2438025 2438025 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   52                                             52
2438026 2438026 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   39                                             39
2438027 2438027 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_3                                                   66                                             66
2438028 2438028 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_3                                                   0                                             0
2438029 2438029 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_3                                                   0                                             0
2438030 2438030 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_3                                                   0                                             0
2439473 2439473 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   *                                              
2439474 2439474 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   61                                             61
2439475 2439475 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   *                                              
2439476 2439476 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   79                                             79
2439477 2439477 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_4                                                   0                                             0
2439478 2439478 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_4                                                   0                                             0
2439479 2439479 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_4                                                   0                                             0
2440922 2440922 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   52                                             52
2440923 2440923 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   49                                             49
2440924 2440924 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   55                                             55
2440925 2440925 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   69                                             69
2440926 2440926 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_5                                                   0                                             0
2440927 2440927 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_5                                                   0                                             0
2440928 2440928 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_5                                                   0                                             0
2442371 2442371 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442372 2442372 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442373 2442373 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442374 2442374 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_6                                                   0                                             0
2442375 2442375 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_6                                                   262                                             262
2442376 2442376 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_6                                                   0                                             0
2442377 2442377 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_6                                                   0                                             0
2443820 2443820 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443821 2443821 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443822 2443822 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443823 2443823 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_7                                                   0                                             0
2443824 2443824 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   233                                             233
2443825 2443825 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_7                                                   0                                             0
2443826 2443826 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_7                                                   0                                             0
2445269 2445269 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445270 2445270 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445271 2445271 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445272 2445272 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_8                                                   0                                             0
2445273 2445273 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_8                                                   236                                             236
2445274 2445274 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_8                                                   0                                             0
2445275 2445275 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_8                                                   0                                             0
2446718 2446718 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446719 2446719 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446720 2446720 CT     school 903030 1010011   North Haven School District 90303000630 1010211 Montowese Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446721 2446721 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_9                                                   0                                             0
2446722 2446722 CT     school 903030 1010011   North Haven School District 90303000632 1015211 North Haven Middle School Public Schools Regular School No Middle 06 08 2019   grade_9                                                   0                                             0
2446723 2446723 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_9                                                   278                                             278
2446724 2446724 CT     school   1010011   North Haven School District 90303001733 1010111 North Haven Transition Partnership Program           2019   grade_9                                                   0                                             0
2448167 2448167 CT     school 903030 1010011   North Haven School District 90303000627 1010811 Clintonville Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2448168 2448168 CT     school 903030 1010011   North Haven School District 90303000628 1010711 Green Acres Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   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]);