enrollments

Data source: Big Local News · About: Big Local

1,449 rows where grade = "grade_2", state = "CT" and year = 2019 sorted by school_state_type descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,449 ✖

grade ✖

  • grade_2 · 1,449 ✖
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
2437167 2437167 CT     school   3470015   Unified School District #2 90000400475 3470115 Children's Place School State Agency Facilities           2019   grade_2                                                   0                                             0
2437168 2437168 CT     school   3470015   Unified School District #2 90000400479 3470315 Riverview School State Agency Facilities           2019   grade_2                                                   0                                             0
2437170 2437170 CT     school   3360015   Unified School District #1 90000300404 3361115 Manson Youth Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2437171 2437171 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2437172 2437172 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2437173 2437173 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2437174 2437174 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2437175 2437175 CT     school   3360015   Unified School District #1 90000300361 3360615 Hartford Correctional Center State Agency Facilities           2019   grade_2                                                   0                                             0
2437176 2437176 CT     school   3360015   Unified School District #1 90000300469 3362215 MacDougall/Walker Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2437177 2437177 CT     school   3360015   Unified School District #1 90000300436 3361515 Willard/Cybulski Correctional Institution State Agency Facilities           2019   grade_2                                                   0                                             0
2437207 2437207 CT     school   3370015   Department of Mental Health and Addiction Services 90002701539 3370215 Connecticut Valley Hospital State Agency Facilities           2019   grade_2                                                   0                                             0
2436668 2436668 CT     school 903600 2010012   Regional School District 01 90360000766 2016112 Housatonic Valley Regional High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436669 2436669 CT     school 903515 2060012   Regional School District 06 90351500723 2060112 Goshen Center School Regional Schools Regular School No Elementary PK 06 2019   grade_2                                                   18                                             18
2436670 2436670 CT     school 903515 2060012   Regional School District 06 90351500724 2060212 James Morris School Regional Schools Regular School No Elementary PK 06 2019   grade_2                                                   15                                             15
2436671 2436671 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2019   grade_2                                                   8                                             8
2436672 2436672 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2019   grade_2                                                   0                                             0
2436673 2436673 CT     school 903520 2100012   Regional School District 10 90352000728 2100312 Harwinton Consolidated School Regional Schools Regular School No Elementary PK 04 2019   grade_2                                                   72                                             72
2436674 2436674 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2019   grade_2                                                   78                                             78
2436675 2436675 CT     school 903520 2100012   Regional School District 10 90352000727 2105112 Har-Bur Middle School Regional Schools Regular School No Middle 05 08 2019   grade_2                                                   0                                             0
2436676 2436676 CT     school 903520 2100012   Regional School District 10 90352000730 2106112 Lewis S. Mills High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436677 2436677 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2019   grade_2                                                   14                                             14
2436678 2436678 CT     school 903530 2120012   Regional School District 12 90353000731 2120212 Booth Free School Regional Schools Regular School No Elementary KG 05 2019   grade_2                                                   15                                             15
2436679 2436679 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2019   grade_2                                                   *                                              
2436680 2436680 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2019   grade_2                                                   0                                             0
2436682 2436682 CT     school 903535 2130012   Regional School District 13 90353500740 2130112 Frederick Brewster School Regional Schools Regular School No Elementary PK 03 2019   grade_2                                                   60                                             60
2436683 2436683 CT     school 903535 2130012   Regional School District 13 90353500741 2130512 John Lyman School Regional Schools Regular School No Elementary KG 04 2019   grade_2                                                   54                                             54
2436684 2436684 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2019   grade_2                                                   0                                             0
2436685 2436685 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 07 08 2019   grade_2                                                   0                                             0
2436686 2436686 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436688 2436688 CT     school 903536 2140012   Regional School District 14 90353600743 2140112 Bethlehem Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_2                                                   44                                             44
2436689 2436689 CT     school 903536 2140012   Regional School District 14 90353600744 2140212 Mitchell Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_2                                                   56                                             56
2436690 2436690 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2436691 2436691 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436693 2436693 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_2                                                   69                                             69
2436694 2436694 CT     school 903537 2150012   Regional School District 15 90353701200 2150612 Middlebury Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_2                                                   *                                              
2436695 2436695 CT     school 903537 2150012   Regional School District 15 90353701116 2150412 Gainfield Elementary School Regional Schools Regular School No Elementary KG 05 2019   grade_2                                                   56                                             56
2436696 2436696 CT     school 903537 2150012   Regional School District 15 90353700750 2150512 Pomperaug School Regional Schools Regular School No Elementary KG 05 2019   grade_2                                                   51                                             51
2436697 2436697 CT     school 903537 2150012   Regional School District 15 90353700748 2155212 Memorial Middle School Regional Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2436698 2436698 CT     school 903537 2150012   Regional School District 15 90353700751 2155112 Rochambeau Middle School Regional Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2436699 2436699 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436701 2436701 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_2                                                   96                                             96
2436702 2436702 CT     school 903538 2160012   Regional School District 16 90353800755 2160112 Laurel Ledge School Regional Schools Regular School No Elementary KG 05 2019   grade_2                                                   33                                             33
2436703 2436703 CT     school 903538 2160012   Regional School District 16 90353800756 2165112 Long River Middle School Regional Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2436705 2436705 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436706 2436706 CT     school 903539 2170012   Regional School District 17 90353900757 2170212 Burr District Elementary School Regional Schools Regular School No Elementary PK 04 2019   grade_2                                                   48                                             48
2436708 2436708 CT     school 903539 2170012   Regional School District 17 90353900760 2170312 Killingworth Elementary School Regional Schools Regular School No Elementary KG 04 2019   grade_2                                                   59                                             59
2436709 2436709 CT     school 903539 2170012   Regional School District 17 90353901201 2175112 Haddam-Killingworth Middle School Regional Schools Regular School No Middle 05 08 2019   grade_2                                                   0                                             0
2436710 2436710 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436712 2436712 CT     school 903540 2180012   Regional School District 18 90354000761 2180312 Center School Regional Schools Special Education School No Prekindergarten PK PK 2019   grade_2                                                   0                                             0
2436713 2436713 CT     school 903540 2180012   Regional School District 18 90354000762 2180112 Lyme Consolidated School Regional Schools Regular School No Elementary KG 05 2019   grade_2                                                   33                                             33
2436714 2436714 CT     school 903540 2180012   Regional School District 18 90354000764 2180212 Mile Creek School Regional Schools Regular School No Elementary KG 05 2019   grade_2                                                   34                                             34
2436715 2436715 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2436716 2436716 CT     school 903540 2180012   Regional School District 18 90354000763 2186112 Lyme-Old Lyme High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2437148 2437148 CT     school 903630 2040012   Regional School District 04 90363000767 2045112 John Winthrop Middle School Regional Schools Regular School No Middle 07 08 2019   grade_2                                                   0                                             0
2437149 2437149 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2437151 2437151 CT     school 903660 2050012   Regional School District 05 90366001114 2055112 Amity Middle School: Bethany Regional Schools Regular School No Middle 07 08 2019   grade_2                                                   0                                             0
2437152 2437152 CT     school 903660 2050012   Regional School District 05 90366000769 2055212 Amity Middle School: Orange Regional Schools Regular School No Middle 07 08 2019   grade_2                                                   0                                             0
2437153 2437153 CT     school 903660 2050012   Regional School District 05 90366000770 2056112 Amity Regional High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2437157 2437157 CT     school 903720 2070012   Regional School District 07 90372001226 2075112 Northwestern Regional Middle School Regional Schools Regular School No Middle 07 08 2019   grade_2                                                   0                                             0
2437159 2437159 CT     school 903720 2070012   Regional School District 07 90372000771 2076112 Northwestern Regional High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2437162 2437162 CT     school 903750 2080012   Regional School District 08 90375001210 2085112 RHAM Middle School Regional Schools Regular School No Middle 07 08 2019   grade_2                                                   0                                             0
2437163 2437163 CT     school 903750 2080012   Regional School District 08 90375000772 2086112 RHAM High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2437164 2437164 CT     school 903570 2110012   Regional School District 11 90357000765 2116112 Parish Hill High School Regional Schools Regular School No High 07 12 2019   grade_2                                                   0                                             0
2437200 2437200 CT     school 903780 2090012   Regional School District 09 90378000773 2096112 Joel Barlow High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2437201 2437201 CT     school 900005 2190012   Regional School District 19 90000501215 2196112 E. O. Smith High School Regional Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2435769 2435769 CT     school 900070 2440014   Area Cooperative Educational Services 90007000884 2440314 Wintergreen Interdistrict Magnet School Regional Education Service Center Schools Regular School No Elementary KG 08 2019   grade_2                                                   66                                             66
2435771 2435771 CT     school 900070 2440014   Area Cooperative Educational Services 90007001358 2445114 Thomas Edison Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2435907 2435907 CT     school 900700 2410014   Capitol Region Education Council 90070001629 2410714 Academy of Aerospace and Engineering Elementary Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   68                                             68
2435908 2435908 CT     school 900700 2410014   Capitol Region Education Council 90070001623 2410614 Ana Grace Academy of the Arts Elementary School Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   68                                             68
2435909 2435909 CT     school 900700 2410014   Capitol Region Education Council 90070001597 2418114 Discovery Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   68                                             68
2435910 2435910 CT     school 900700 2410014   Capitol Region Education Council 90070000072 2410114 Glastonbury/East Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   66                                             66
2435911 2435911 CT     school 900700 2410014   Capitol Region Education Council 90070001511 2410414 International Magnet School for Global Citizenship Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   64                                             64
2435912 2435912 CT     school 900700 2410014   Capitol Region Education Council 90070000210 2413114 Montessori Magnet School Regional Education Service Center Schools Regular School No Elementary PK 06 2019   grade_2                                                   42                                             42
2435913 2435913 CT     school 900700 2410014   Capitol Region Education Council 90070001601 2410514 Museum Academy Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   69                                             69
2435914 2435914 CT     school 900700 2410014   Capitol Region Education Council 90070001516 2410314 Reggio Magnet School of the Arts Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   68                                             68
2435917 2435917 CT     school 900700 2410014   Capitol Region Education Council 90070001357 2410214 University of Hartford Magnet School Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   66                                             66
2435923 2435923 CT     school 900700 2410014   Capitol Region Education Council 90070001513 2415114 Academy of Aerospace and Engineering Regional Education Service Center Schools Regular School No High 06 12 2019   grade_2                                                   0                                             0
2435924 2435924 CT     school 900700 2410014   Capitol Region Education Council 90070001592 2416514 Academy of Science and Innovation Regional Education Service Center Schools Regular School No High 06 12 2019   grade_2                                                   0                                             0
2435925 2435925 CT     school 900700 2410014   Capitol Region Education Council 90070001625 2415314 Greater Hartford Academy of the Arts Magnet Middle Regional Education Service Center Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2435926 2435926 CT     school 900700 2410014   Capitol Region Education Council 90070000880 2416114 Metropolitan Learning Center for Global and International Studies Regional Education Service Center Schools Regular School No High 06 12 2019   grade_2                                                   0                                             0
2435927 2435927 CT     school 900700 2410014   Capitol Region Education Council 90070001364 2415014 Two Rivers Magnet Middle School Regional Education Service Center Schools Regular School No Middle 06 08 2019   grade_2                                                   0                                             0
2435929 2435929 CT     school 900700 2410014   Capitol Region Education Council 90070001532 2415214 Civic Leadership High School Regional Education Service Center Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2435930 2435930 CT     school 900700 2410014   Capitol Region Education Council 90070001497 2416414 Greater Hartford Academy of the Arts High School - Full Day Regional Education Service Center Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2435958 2435958 CT     school 900910 2430014   Cooperative Educational Services 90091000340 2430114 Six-Six Magnet School Regional Education Service Center Schools Regular School No Elementary PK 08 2019   grade_2                                                   39                                             39
2436054 2436054 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001507 2536014 Arts at the Capitol Theater Magnet School (ACT) Regional Education Service Center Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436055 2436055 CT     school 901360 2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001530 2536114 Quinebaug Middle College Regional Education Service Center Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436282 2436282 CT     school 903450 2450014   Learn 90345001627 2450314 Riverside Magnet School at Goodwin University Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_2                                                   74                                             74
2436283 2436283 CT     school 903450 2450014   Learn 90345001430 2450214 The Friendship School Regional Education Service Center Schools Regular School No Elementary PK KG 2019   grade_2                                                   0                                             0
2436284 2436284 CT     school 903450 2450014   Learn 90345000079 2450114 Regional Multicultural Magnet School Regional Education Service Center Schools Regular School No Elementary KG 05 2019   grade_2                                                   88                                             88
2436292 2436292 CT     school 903450 2450014   Learn 90345001581 2456014 Connecticut River Academy at Goodwin University Regional Education Service Center Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436293 2436293 CT     school 903450 2450014   Learn 90345001606 2456114 Marine Science Magnet High School Regional Education Service Center Schools Regular School No High 09 12 2019   grade_2                                                   0                                             0
2436295 2436295 CT     school 903450 2450014   Learn 90345001617 2456214 Three Rivers Middle College Magnet School Regional Education Service Center Schools Regular School No High 11 12 2019   grade_2                                                   0                                             0
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
2435761 2435761 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2019   grade_2                                                   79                                             79
2435762 2435762 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2019   grade_2                                                   95                                             95
2435763 2435763 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2019   grade_2                                                   0                                             0
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
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
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
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

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