enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,349 ✖

grade ✖

  • grade_11 · 1,349 ✖
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
2449658 2449658 CT     school 903120 1040011   Norwich School District 90312000678 1041511 Wequonnoc Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_11                                                   0                                             0
2450000 2450000 CT     school 904830 1510011   Waterbury School District 90483000990 1510811 Wendell L. Cross School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449178 2449178 CT     school 901680 560011   Granby School District 90168000293 560311 Wells Road Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_11                                                   0                                             0
2449266 2449266 CT     school 901920 640011   Hartford School District 90192000383 642011 Webster Micro Society Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_11                                                   0                                             0
2450062 2450062 CT     school 904920 1550011   West Hartford School District 90492001024 1551211 Webster Hill School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2450058 2450058 CT     school   1530011   Watertown School District   1530711 Watertown Transition Program at Post University             2019   grade_11                                                   0                                             0
2450057 2450057 CT     school   1530011   Watertown School District   1530811 Watertown Transition Academy Program           2019   grade_11                                                   0                                             0
2450056 2450056 CT     school 904890 1530011   Watertown School District 90489001008 1536111 Watertown High School Public Schools Regular School No High 09 12 2019   grade_11                                                   210                                             210
2450050 2450050 CT     school 904860 1520011   Waterford School District 90486001001 1526111 Waterford High School Public Schools Regular School No High 09 12 2019   grade_11                                                   222                                             222
2450049 2450049 CT     school   1520011   Waterford School District   1520911 Waterford Academy Program           2019   grade_11                                                   0                                             0
2449999 2449999 CT     school 904830 1510011   Waterbury School District 90483001638 1516711 Waterbury Career Academy Public Schools Regular School No High 09 12 2019   grade_11                                                   184                                             184
2450032 2450032 CT     school 904830 1510011   Waterbury School District 90483001395 1515011 Waterbury Arts Magnet School (Middle) Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2450039 2450039 CT     school 904830 1510011   Waterbury School District 90483001396 1516011 Waterbury Arts Magnet School (High) Public Schools Regular School No High 09 12 2019   grade_11                                                   109                                             109
2449364 2449364 CT     school 902310 770011   Manchester School District 90231000431 771411 Washington School   Regular School No Elementary KG 04 2019   grade_11                                                   0                                             0
2449998 2449998 CT     school 904830 1510011   Waterbury School District 90483000988 1512311 Washington School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2450083 2450083 CT     school 904950 1560011   West Haven School District 90495001040 1561211 Washington School Public Schools Regular School No Elementary PK 04 2019   grade_11                                                   0                                             0
2449718 2449718 CT     school 903530 2120012   Regional School District 12 90353000735 2120412 Washington Primary School Regional Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449400 2449400 CT     school 902400 800011   Meriden School District 90240001194 805411 Washington Middle School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2448899 2448899 CT     school 900450 150011   Bridgeport School District 90045000067 156311 Warren Harding High School Public Schools Regular School No High 09 12 2019   grade_11                                                   240                                             240
2449712 2449712 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2019   grade_11                                                   0                                             0
2449713 2449713 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2019   grade_11                                                   111                                             111
2448884 2448884 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2019   grade_11                                                   0                                             0
2449154 2449154 CT     school   510011   Fairfield School District   510311 Walter Fitzgerald Campus Program           2019   grade_11                                                   7                                             7
2449358 2449358 CT     school 902280 760011   Madison School District 90228001480 765211 Walter C. Polson Middle School Public Schools Regular School No Middle 07 08 2019   grade_11                                                   0                                             0
2449997 2449997 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449983 2449983 CT     school   1480011   Wallingford School District 90474001594 1489111 Wallingford Transition Academy Program           2019   grade_11                                                   0                                             0
2450031 2450031 CT     school   1510011   Waterbury School District   1514911 Wallace SCOPE Program           2019   grade_11                                                   0                                             0
2450030 2450030 CT     school   1510011   Waterbury School District   1515811 Wallace Bilingual Program           2019   grade_11                                                   0                                             0
2450029 2450029 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2019   grade_11                                                   0                                             0
2450165 2450165 CT     school 905280 1660011   Wolcott School District 90528001106 1660511 Wakelee School Public Schools Regular School No Elementary KG 05 2019   grade_11                                                   0                                             0
2449369 2449369 CT     school 902310 770011   Manchester School District 90231000430 771311 Waddell School Public Schools Regular School No Elementary KG 04 2019   grade_11                                                   0                                             0
2449745 2449745 CT     school   2160012   Regional School District 16 90353801747 2160412 WRHS Alternative Education Program Program           2019   grade_11                                                   *                                              
2449969 2449969 CT     school   1480011   Wallingford School District 90474001595 1489211 WISE Intermediate Program Program           2019   grade_11                                                   0                                             0
2450235 2450235 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201151 9002316 W. F. Kaynor Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_11                                                   186                                             186
2450142 2450142 CT     school 905190 1630011   Windham School District 90519001084 1630611 W. B. Sweeney School Public Schools Regular School No Elementary KG 05 2019   grade_11                                                   0                                             0
2449963 2449963 CT     school 904710 1470011   Voluntown School District 90471000949 1470111 Voluntown Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_11                                                   0                                             0
2449932 2449932 CT     school 904590 1430011   Torrington School District 90459001211 1431311 Vogel-Wetmore School Public Schools Regular School No Elementary KG 03 2019   grade_11                                                   0                                             0
2449432 2449432 CT     school   830011   Middletown School District 90249001765 831711 Virtual Learning Academy - MHS Program           2019   grade_11                                                   *                                              
2449662 2449662 CT     school   1040011   Norwich School District 90312001622 1049211 Virtual Learning Academy Program           2019   grade_11                                                   *                                              
2450210 2450210 CT     school   3470015   Unified School District #2   3470215 Virtual Academy Program           2019   grade_11                                                   0                                             0
2450234 2450234 CT     school 900002 9000016   Connecticut Technical Education and Career System 90000201150 9001816 Vinal Technical High School CT Technical Education and Career Schools Career and Technical School No High 09 12 2019   grade_11                                                   105                                             105
2448808 2448808 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2019   grade_11                                                   0                                             0
2449657 2449657 CT     school 903120 1040011   Norwich School District 90312000677 1041811 Veterans' Memorial School Public Schools Regular School No Elementary KG 05 2019   grade_11                                                   0                                             0
2449763 2449763 CT     school 903810 1180011   Ridgefield School District 90381000781 1180211 Veterans Park Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449368 2449368 CT     school 902310 770011   Manchester School District 90231000429 771211 Verplanck School Public Schools Regular School No Elementary KG 04 2019   grade_11                                                   0                                             0
2449960 2449960 CT     school 904680 1460011   Vernon School District 90468000947 1465111 Vernon Center Middle School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2449402 2449402 CT     school   800011   Meriden School District   801311 Venture Academy Program           2019   grade_11                                                   11                                             11
2449493 2449493 CT     school 902670 890011   New Britain School District 90267000527 891511 Vance Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_11                                                   0                                             0
2449693 2449693 CT     school 903390 1130011   Portland School District 90339000714 1130211 Valley View School Public Schools Regular School No Elementary PK 01 2019   grade_11                                                   0                                             0
2450190 2450190 CT     school 903630 2040012   Regional School District 04 90363000768 2046112 Valley Regional High School Regional Schools Regular School No High 09 12 2019   grade_11                                                   147                                             147
2449826 2449826 CT     school 904230 1310011   Southington School District 90423000841 1311411 Urbin T. Kelley School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2448958 2448958 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_11                                                   0                                             0
2449304 2449304 CT     school 901920 640011   Hartford School District 90192001381 646711 University High School of Science and Engineering Public Schools Regular School No High 09 12 2019   grade_11                                                   114                                             114
2449157 2449157 CT     school 901560 520011   Farmington School District 90156000276 520111 Union School Public Schools Regular School No Elementary KG 04 2019   grade_11                                                   0                                             0
2449951 2449951 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2019   grade_11                                                   0                                             0
2449656 2449656 CT     school 903120 1040011   Norwich School District 90312000676 1041911 Uncas Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_11                                                   0                                             0
2450166 2450166 CT     school 905280 1660011   Wolcott School District 90528001102 1665111 Tyrrell Middle School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2448968 2448968 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_11                                                   0                                             0
2449873 2449873 CT     school 904320 1350011   Stamford School District 90432000870 1355511 Turn of River School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2449670 2449670 CT     school 903210 1070011   Orange School District 90321000689 1070411 Turkey Hill School Public Schools Regular School No Elementary 01 06 2019   grade_11                                                   0                                             0
2449949 2449949 CT     school 904620 1440011   Trumbull School District 90462000937 1446111 Trumbull High School Public Schools Regular School No High 09 12 2019   grade_11                                                   482                                             482
2449939 2449939 CT     school   1440011   Trumbull School District 90462000683 1448011 Trumbull Early Childhood Education Center Program           2019   grade_11                                                   0                                             0
2449948 2449948 CT     school   1440011   Trumbull School District 90462001669 1440211 Trumbull Alternative School Program           2019   grade_11                                                   8                                             8
2449542 2449542 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2019   grade_11                                                   0                                             0
2449800 2449800 CT     school   1260011   Shelton School District   1260711 Transition Program Program           2019   grade_11                                                   0                                             0
2449003 2449003 CT     school   2430014   Cooperative Educational Services   2430214 Transition Learning Center Program           2019   grade_11                                                   0                                             0
2448833 2448833 CT     school   70011   Berlin School District   70311 Transition Academy Program           2019   grade_11                                                   0                                             0
2449213 2449213 CT     school   590011   Groton School District   591011 Transition Academy Program           2019   grade_11                                                   0                                             0
2449663 2449663 CT     school   1040011   Norwich School District   1041011 Transition Academy Program           2019   grade_11                                                   0                                             0
2450188 2450188 CT     school 900023 2780013   Trailblazers Academy District 90002300965 2785113 Trailblazers Academy   Regular School Yes Middle 06 08 2019   grade_11                                                   0                                             0
2449629 2449629 CT     school 903090 1030011   Norwalk School District 90309000660 1031411 Tracey Magnet School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449353 2449353 CT     school   760011   Madison School District 90228001549 769011 Town Campus Learning Center Program           2019   grade_11                                                   0                                             0
2449922 2449922 CT     school 904530 1410011   Thompson School District 90453000911 1416111 Tourtellotte Memorial High School Public Schools Regular School No High 09 12 2019   grade_11                                                   47                                             47
2449611 2449611 CT     school 902970 990011   North Branford School District 90297000623 990611 Totoket Valley Elementary School Public Schools Regular School No Elementary 03 05 2019   grade_11                                                   0                                             0
2449935 2449935 CT     school 904590 1430011   Torrington School District 90459000925 1435111 Torrington Middle School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2449936 2449936 CT     school 904590 1430011   Torrington School District 90459000924 1436111 Torrington High School Public Schools Regular School No High 09 12 2019   grade_11                                                   188                                             188
2449104 2449104 CT     school   2420014   EdAdvance   2420214 Torrington Alternative Program             2019   grade_11                                                   *                                              
2449931 2449931 CT     school 904590 1430011   Torrington School District 90459000923 1430911 Torringford School Public Schools Regular School No Elementary KG 03 2019   grade_11                                                   0                                             0
2449867 2449867 CT     school 904320 1350011   Stamford School District 90432000008 1351911 Toquam Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_11                                                   0                                             0
2449807 2449807 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2019   grade_11                                                   0                                             0
2449151 2449151 CT     school 901530 510011   Fairfield School District 90153000271 515111 Tomlinson Middle School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2449925 2449925 CT     school 904560 1420011   Tolland School District 90456000915 1425111 Tolland Middle School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2449924 2449924 CT     school 904560 1420011   Tolland School District 90456000913 1420211 Tolland Intermediate School Public Schools Regular School No Elementary 03 05 2019   grade_11                                                   0                                             0
2449926 2449926 CT     school 904560 1420011   Tolland School District 90456000914 1426111 Tolland High School Public Schools Regular School No High 09 12 2019   grade_11                                                   203                                             203
2449037 2449037 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2449820 2449820 CT     school 904170 1320011   South Windsor School District 90417000827 1325111 Timothy Edwards School Public Schools Regular School No Middle 06 08 2019   grade_11                                                   0                                             0
2449336 2449336 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_11                                                   35                                             35
2449921 2449921 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   grade_11                                                   0                                             0
2448822 2448822 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_11                                                   0                                             0
2449918 2449918 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2019   grade_11                                                   48                                             48
2449917 2449917 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2019   grade_11                                                   0                                             0
2449649 2449649 CT     school 903120 1040011   Norwich School District 90312000675 1041711 Thomas W. Mahan School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2448886 2448886 CT     school 900450 150011   Bridgeport School District 90045000069 151311 Thomas Hooker School Public Schools Regular School No Elementary KG 08 2019   grade_11                                                   0                                             0
2449391 2449391 CT     school 902400 800011   Meriden School District 90240000451 801011 Thomas Hooker School Public Schools Regular School No Elementary PK 05 2019   grade_11                                                   0                                             0
2448812 2448812 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_11                                                   0                                             0
2449795 2449795 CT     school   1260011   Shelton School District   1261211 Therapeutic Learning Center Program           2019   grade_11                                                   0                                             0
2449840 2449840 CT     school   1310011   Southington School District 90423001720 1311611 Therapeutic Educational Alternative Model (TEAM) Program           2019   grade_11                                                   0                                             0
2449000 2449000 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2019   grade_11                                                   17                                             17
2450247 2450247 CT     school 905373 9030022   The Woodstock Academy District 90537311223 9036122 The Woodstock Academy Endowed and Incorporated Academies Schools Regular School No High 09 12 2019   grade_11                                                   292                                             292
2448900 2448900 CT     school   150011   Bridgeport School District   152811 The Transition Academy Program           2019   grade_11                                                   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]);