enrollments

Data source: Big Local News · About: Big Local

1,449 rows where grade = "grade_10", state = "CT" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,449 ✖

grade ✖

  • grade_10 · 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
2447358 2447358 CT     school   20011   Ansonia School District   20411 P.A.C.E. - PM (Positive And Creative Education - PM) Program           2019   grade_10                                                   *                                              
2447367 2447367 CT     school   2440014   Area Cooperative Educational Services   2449314 Whitney High School West             2019   grade_10                                                   *                                              
2447401 2447401 CT     school 900330 110011   Bloomfield School District 90033001619 116411 Learning Academy at Bloomfield   Alternative School No High 09 12 2019   grade_10                                                   *                                              
2447412 2447412 CT     school   140011   Branford School District 90042001742 140211 Branford High School Atlas Program Program           2019   grade_10                                                   *                                              
2447438 2447438 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2019   grade_10                                                   *                                              
2447470 2447470 CT     school   170011   Bristol School District 90051001429 179011 Alternative Special Education Program (ASEP) Program           2019   grade_10                                                   *                                              
2447510 2447510 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2019   grade_10                                                   *                                              
2447514 2447514 CT     school   2410014   Capitol Region Education Council 90070001489 2419214 Farmington Valley Regional Diagnostic Center Program           2019   grade_10                                                   *                                              
2447524 2447524 CT     school   2410014   Capitol Region Education Council   2419614 Lincoln Academy Regional Interdistrict Collaborative             2019   grade_10                                                   *                                              
2447534 2447534 CT     school   250011   Cheshire School District 90075001682 250911 Humiston Alternative School Program           2019   grade_10                                                   *                                              
2447559 2447559 CT     school   320011   Coventry School District 90096001787 320111 Coventry Academy Public Schools           2019   grade_10                                                   *                                              
2447596 2447596 CT     school   370011   Derby School District   370511 RAISE Academy Program           2019   grade_10                                                   *                                              
2447624 2447624 CT     school 901260 430011   East Hartford School District 90126001377 436411 Synergy Alternative Program Program Alternative School No High 10 12 2019   grade_10                                                   *                                              
2447638 2447638 CT     school   450011   East Lyme School District 90132001760 450611 Coastal Connections Program           2019   grade_10                                                   *                                              
2447653 2447653 CT     school   2420014   EdAdvance 90351201476 2429014 The ACCESS School at The Danuta M. Thibodeau Education Center Program           2019   grade_10                                                   *                                              
2447654 2447654 CT     school   2420014   EdAdvance   2420114 Steps Program           2019   grade_10                                                   *                                              
2447684 2447684 CT     school   490011   Enfield School District   490111 Enfield High - Adaptive Learning Program (ALP) Program           2019   grade_10                                                   *                                              
2447723 2447723 CT     school   540011   Glastonbury School District 90162001801 540111 Links Academy Program           2019   grade_10                                                   *                                              
2447747 2447747 CT     school   570011   Greenwich School District   571511 Windrose Program           2019   grade_10                                                   *                                              
2447751 2447751 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 09 12 2019   grade_10                                                   *                                              
2447761 2447761 CT     school   590011   Groton School District   590611 Apex Academy Program           2019   grade_10                                                   *                                              
2447762 2447762 CT     school   590011   Groton School District   590211 New Beginnings Alternative Program Program           2019   grade_10                                                   *                                              
2447853 2447853 CT     school   640011   Hartford School District 90192001770 648311 RISE - Bulkeley High School Program           2019   grade_10                                                   *                                              
2447857 2447857 CT     school   640011   Hartford School District   645011 iGOAL 2 - Weaver High School             2019   grade_10                                                   *                                              
2447882 2447882 CT     school   2450014   Learn   2451214 Learn ABA Program at Center School             2019   grade_10                                                   *                                              
2447928 2447928 CT     school   770011   Manchester School District 90231001717 770711 New Horizons Program           2019   grade_10                                                   *                                              
2447956 2447956 CT     school   800011   Meriden School District   802511 SOAR - PHS Program           2019   grade_10                                                   *                                              
2447957 2447957 CT     school   800011   Meriden School District   801911 TLC - PHS Program           2019   grade_10                                                   *                                              
2447958 2447958 CT     school   800011   Meriden School District   801611 TSC - MHS Program           2019   grade_10                                                   *                                              
2447960 2447960 CT     school   800011   Meriden School District   801811 STARS - HS Program           2019   grade_10                                                   *                                              
2447962 2447962 CT     school   800011   Meriden School District   802011 TLC - MHS Program           2019   grade_10                                                   *                                              
2447980 2447980 CT     school   830011   Middletown School District 90249001722 831811 MHS - Alternative Education Program 1 Program           2019   grade_10                                                   *                                              
2447981 2447981 CT     school   830011   Middletown School District   832211 MHS- Alternative Education Program 3 Program           2019   grade_10                                                   *                                              
2447983 2447983 CT     school   830011   Middletown School District 90249001765 831711 Virtual Learning Academy - MHS Program           2019   grade_10                                                   *                                              
2447984 2447984 CT     school   830011   Middletown School District 90249001657 831611 Evening Program - MHS Program           2019   grade_10                                                   *                                              
2447985 2447985 CT     school   830011   Middletown School District 90249001768 831911 MHS - Alternative Education Program 2 Program           2019   grade_10                                                   *                                              
2448028 2448028 CT     school   880011   Naugatuck School District   880911 Genesis Academy Program           2019   grade_10                                                   *                                              
2448117 2448117 CT     school   930011   New Haven School District   930110 Gateway to College Program Program           2019   grade_10                                                   *                                              
2448121 2448121 CT     school   930011   New Haven School District   930210 James Hillhouse Self Contained MD Program           2019   grade_10                                                   *                                              
2448127 2448127 CT     school   930011   New Haven School District   938511 Wilbur Cross Self Contained MD Program           2019   grade_10                                                   *                                              
2448213 2448213 CT     school   1040011   Norwich School District 90312001622 1049211 Virtual Learning Academy Program           2019   grade_10                                                   *                                              
2448292 2448292 CT     school   2150012   Regional School District 15   2150112 MIJ Program Program           2019   grade_10                                                   *                                              
2448296 2448296 CT     school   2160012   Regional School District 16 90353801747 2160412 WRHS Alternative Education Program Program           2019   grade_10                                                   *                                              
2448309 2448309 CT     school   2180012   Regional School District 18   2180412 Alternative Program Program           2019   grade_10                                                   *                                              
2448323 2448323 CT     school   1180011   Ridgefield School District 90381001763 1188011 Alternative High School Program           2019   grade_10                                                   *                                              
2448365 2448365 CT     school   1290011   Somers School District   1290511 Aspire Program           2019   grade_10                                                   *                                              
2448392 2448392 CT     school   1310011   Southington School District 90423001694 1311711 Achieve Program           2019   grade_10                                                   *                                              
2448397 2448397 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Other PK 12 2019   grade_10                                                   *                                              
2448403 2448403 CT     school   1340011   Stafford School District   1340211 Stafford Tutoring Program             2019   grade_10                                                   *                                              
2448460 2448460 CT     school   1380011   Stratford School District 90444001710 1382011 STEPS 9-12 Program           2019   grade_10                                                   *                                              
2448470 2448470 CT     school   1400011   Thomaston School District   1400311 PATHS Program           2019   grade_10                                                   *                                              
2448499 2448499 CT     school   1440011   Trumbull School District 90462001669 1440211 Trumbull Alternative School Program           2019   grade_10                                                   *                                              
2448531 2448531 CT     school   1480011   Wallingford School District   1480511 Education Enhancement Program             2019   grade_10                                                   *                                              
2448591 2448591 CT     school   1510011   Waterbury School District   1514511 Wilby Autism Program           2019   grade_10                                                   *                                              
2448629 2448629 CT     school   1550011   West Hartford School District 90492001791 1557311 REACH Program           2019   grade_10                                                   *                                              
2448645 2448645 CT     school   1560011   West Haven School District   1560711 Blended Program           2019   grade_10                                                   *                                              
2448702 2448702 CT     school   1650011   Windsor Locks School District 90525001709 1650611 Pine Meadow Academy Program           2019   grade_10                                                   *                                              
2448710 2448710 CT     school   1640011   Windsor School District   1640311 Spark Program           2019   grade_10                                                   *                                              
2448752 2448752 CT     school   2070012   Regional School District 07 90372001402 2079312 STEP Program           2019   grade_10                                                   *                                              
2448763 2448763 CT     school   3360015   Unified School District #1 90000300849 3362515 York Correctional Institution State Agency Facilities           2019   grade_10                                                   *                                              
2448764 2448764 CT     school   3360015   Unified School District #1 90000300347 3360315 Cheshire Correctional Institution State Agency Facilities           2019   grade_10                                                   *                                              
2448765 2448765 CT     school   3360015   Unified School District #1 90000300844 3362415 Corrigan/Radgowski Correctional Institution State Agency Facilities           2019   grade_10                                                   *                                              
2448766 2448766 CT     school   3360015   Unified School District #1 90000301349 3362615 Northern Correctional Institution State Agency Facilities           2019   grade_10                                                   *                                              
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
2447352 2447352 CT     school   20011   Ansonia School District   20911 Ansonia Public Schools Pre-K Program Program           2019   grade_10                                                   0                                             0
2447353 2447353 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2019   grade_10                                                   0                                             0
2447354 2447354 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2019   grade_10                                                   0                                             0
2447355 2447355 CT     school 900060 20011   Ansonia School District 90006010008 25111 Ansonia Middle School Public Schools Regular School No Middle 07 08 2019   grade_10                                                   0                                             0
2447359 2447359 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2019   grade_10                                                   0                                             0
2447360 2447360 CT     school   2440014   Area Cooperative Educational Services   2440214 ACES Mill Elementary School Program           2019   grade_10                                                   0                                             0
2447361 2447361 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_10                                                   0                                             0
2447362 2447362 CT     school   2440014   Area Cooperative Educational Services 90007001505 2449414 Mill Academy Program           2019   grade_10                                                   0                                             0
2447363 2447363 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_10                                                   0                                             0
2447368 2447368 CT     school   2440014   Area Cooperative Educational Services   2440114 CREATE at Whitney Academy Program           2019   grade_10                                                   0                                             0
2447369 2447369 CT     school 900090 30011   Ashford School District 90009000010 30111 Ashford School Public Schools Regular School No Elementary PK 08 2019   grade_10                                                   0                                             0
2447370 2447370 CT     school   40011   Avon School District 90012001737 40111 Avon Early Learning Center at Roaring Brook School Program           2019   grade_10                                                   0                                             0
2447371 2447371 CT     school 900120 40011   Avon School District 90012010010 40411 Pine Grove School Public Schools Regular School No Elementary KG 04 2019   grade_10                                                   0                                             0
2447372 2447372 CT     school 900120 40011   Avon School District 90012000013 40311 Roaring Brook School Public Schools Regular School No Elementary KG 04 2019   grade_10                                                   0                                             0
2447373 2447373 CT     school 900120 40011   Avon School District 90012001367 40511 Thompson Brook School Public Schools Regular School No Middle 05 06 2019   grade_10                                                   0                                             0
2447374 2447374 CT     school 900120 40011   Avon School District 90012000012 45111 Avon Middle School Public Schools Regular School No Middle 07 08 2019   grade_10                                                   0                                             0
2447376 2447376 CT     school 900150 50011   Barkhamsted School District 90015000015 50111 Barkhamsted Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_10                                                   0                                             0
2447377 2447377 CT     school   50011   Barkhamsted School District 90015001373 58011 Shared Services Integrated Preschool Program           2019   grade_10                                                   0                                             0
2447378 2447378 CT     school   50011   Barkhamsted School District   50211 Bridges at Barkhamsted Elementary School Program           2019   grade_10                                                   0                                             0
2447379 2447379 CT     school 900210 70011   Berlin School District 90021000018 70411 Emma Hart Willard School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2447380 2447380 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary PK 05 2019   grade_10                                                   0                                             0
2447381 2447381 CT     school 900210 70011   Berlin School District 90021000021 70111 Richard D. Hubbard School Public Schools Regular School No Elementary KG 05 2019   grade_10                                                   0                                             0
2447382 2447382 CT     school 900210 70011   Berlin School District 90021000017 75111 Catherine M. McGee Middle School Public Schools Regular School No Middle 06 08 2019   grade_10                                                   0                                             0
2447384 2447384 CT     school   70011   Berlin School District   70311 Transition Academy Program           2019   grade_10                                                   0                                             0
2447385 2447385 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2019   grade_10                                                   0                                             0
2447386 2447386 CT     school 900270 90011   Bethel School District 90027000027 90111 Frank A. Berry School Public Schools Regular School No Elementary PK 03 2019   grade_10                                                   0                                             0
2447387 2447387 CT     school 900270 90011   Bethel School District 90027000023 90411 Anna H. Rockwell School Public Schools Regular School No Elementary KG 03 2019   grade_10                                                   0                                             0
2447388 2447388 CT     school 900270 90011   Bethel School District 90027001118 90511 Ralph M. T. Johnson School Public Schools Regular School No Elementary 04 05 2019   grade_10                                                   0                                             0
2447389 2447389 CT     school 900270 90011   Bethel School District 90027000025 95111 Bethel Middle School Public Schools Regular School No Middle 06 08 2019   grade_10                                                   0                                             0
2447391 2447391 CT     school   90011   Bethel School District   90311 TASK Program           2019   grade_10                                                   0                                             0
2447392 2447392 CT     school   90011   Bethel School District   90211 Community Partnership Program Program           2019   grade_10                                                   0                                             0
2447393 2447393 CT     school 900330 110011   Bloomfield School District 90033001565 110811 Wintonbury Early Childhood Magnet School Public Schools Regular School No Prekindergarten PK PK 2019   grade_10                                                   0                                             0
2447394 2447394 CT     school 900330 110011   Bloomfield School District 90033000032 110611 Laurel School Public Schools Regular School No Elementary KG 02 2019   grade_10                                                   0                                             0
2447395 2447395 CT     school   110011   Bloomfield School District   110111 Steps to Success Program           2019   grade_10                                                   0                                             0
2447396 2447396 CT     school 900330 110011   Bloomfield School District 90033000033 110511 Metacomet School Public Schools Regular School No Elementary 03 04 2019   grade_10                                                   0                                             0
2447397 2447397 CT     school 900330 110011   Bloomfield School District 90033001375 110711 Carmen Arace Intermediate School Public Schools Regular School No Middle 05 06 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]);