enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_1" and state = "CT" sorted by ccd_school_high_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 4,254 ✖
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
2434710 2434710 CT     school 901740 580011   Griswold School District 90174001721 580111 Griswold Alternative School Public Schools Alternative School No High 09 12 2019   grade_1                                                   0                                             0
2434711 2434711 CT     school 901740 580011   Griswold School District 90174000311 586211 Griswold High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434722 2434722 CT     school 901770 590011   Groton School District 90177000318 596111 Robert E. Fitch High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434730 2434730 CT     school 901800 600011   Guilford School District 90180000332 606111 Guilford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434749 2434749 CT     school 901860 620011   Hamden School District 90186000339 626111 Hamden High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434756 2434756 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2019   grade_1                                                   33                                             33
2434763 2434763 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2019   grade_1                                                   47                                             47
2434783 2434783 CT     school 901920 640011   Hartford School District 90192001535 643611 Global Communications Academy Public Schools Regular School No Other KG 12 2019   grade_1                                                   64                                             64
2434796 2434796 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2434797 2434797 CT     school 901920 640011   Hartford School District 90192001295 645411 Hartford Magnet Trinity College Academy Public Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2434800 2434800 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2434804 2434804 CT     school 901920 640011   Hartford School District 90192001572 647111 Bulkeley High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434805 2434805 CT     school 901920 640011   Hartford School District 90192001403 647911 Great Path Academy at MCC Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434806 2434806 CT     school 901920 640011   Hartford School District 90192001574 647211 HPHS Engineering and Green Technology Academy   Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434807 2434807 CT     school 901920 640011   Hartford School District 90192001576 647411 HPHS Law and Government Academy   Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434808 2434808 CT     school 901920 640011   Hartford School District 90192001559 647511 HPHS Nursing and Health Sciences Academy   Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434809 2434809 CT     school 901920 640011   Hartford School District 90192001552 647611 High School, Inc.   Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434810 2434810 CT     school 901920 640011   Hartford School District 90192001562 647711 Journalism and Media Academy   Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434811 2434811 CT     school 901920 640011   Hartford School District 90192001479 646611 Pathways Academy of Technology and Design Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434814 2434814 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_1                                                   0                                             0
2434817 2434817 CT     school 901920 640011   Hartford School District 90192001522 646011 Culinary Arts Academy at Weaver High School   Regular School No High 11 12 2019   grade_1                                                   0                                             0
2434818 2434818 CT     school 901920 640011   Hartford School District 90192001650 643911 Capital Community College Magnet Academy   Regular School No High 12 12 2019   grade_1                                                   0                                             0
2434823 2434823 CT     school 900207 2860013   Highville Charter School District 90020700907 2860113 Highville Charter School Public Charter Schools Regular School Yes Other PK 12 2019   grade_1                                                   39                                             39
2434825 2434825 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   grade_1                                                   73                                             73
2434831 2434831 CT     school 902070 690011   Killingly School District 90207000392 696111 Killingly High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434843 2434843 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_1                                                   0                                             0
2434844 2434844 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_1                                                   0                                             0
2434846 2434846 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_1                                                   0                                             0
2434850 2434850 CT     school 902130 710011   Lebanon School District 90213000396 716211 Lyman Memorial High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434856 2434856 CT     school 902160 720011   Ledyard School District 90216000401 726111 Ledyard High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434862 2434862 CT     school 902220 740011   Litchfield School District 90222000406 746111 Litchfield High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434869 2434869 CT     school 902280 760011   Madison School District 90228000411 766111 Daniel Hand High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434885 2434885 CT     school 902310 770011   Manchester School District 90231000424 776111 Manchester High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434913 2434913 CT     school 902400 800011   Meriden School District 90240000441 806111 Francis T. Maloney High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434914 2434914 CT     school 902400 800011   Meriden School District 90240000449 806211 Orville H. Platt High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434941 2434941 CT     school 902490 830011   Middletown School District 90249000465 836211 Middletown High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434957 2434957 CT     school 902520 840011   Milford School District 90252000472 846211 Jonathan Law High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434958 2434958 CT     school 902520 840011   Milford School District 90252000473 846311 Joseph A. Foran High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434966 2434966 CT     school 902550 850011   Monroe School District 90255000489 856111 Masuk High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434973 2434973 CT     school 902580 860011   Montville School District 90258000495 866111 Montville High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2434986 2434986 CT     school 902640 880011   Naugatuck School District 90264000505 886111 Naugatuck High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435011 2435011 CT     school 902670 890011   New Britain School District 90267000521 896111 New Britain High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435018 2435018 CT     school 902700 900011   New Canaan School District 90270000531 906111 New Canaan High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435023 2435023 CT     school 902730 910011   New Fairfield School District 90273000537 916111 New Fairfield High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435074 2435074 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2435075 2435075 CT     school 902790 930011   New Haven School District 90279001207 936411 Cooperative High School - Inter-District Magnet Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435077 2435077 CT     school 902790 930011   New Haven School District 90279000558 936611 High School In The Community Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435078 2435078 CT     school 902790 930011   New Haven School District 90279000556 936311 Hill Regional Career High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435079 2435079 CT     school 902790 930011   New Haven School District 90279000563 936211 James Hillhouse High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435081 2435081 CT     school 902790 930011   New Haven School District 90279001485 936011 Metropolitan Business Academy Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435082 2435082 CT     school 902790 930011   New Haven School District 90279000547 937011 New Haven Academy Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435084 2435084 CT     school 902790 930011   New Haven School District 90279001216 936711 Sound School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435085 2435085 CT     school 902790 930011   New Haven School District 90279000585 936111 Wilbur Cross High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435095 2435095 CT     school 902820 950011   New London School District 90282001913 951311 Science and Technology Magnet School of Southeastern Connecticut Public Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2435096 2435096 CT     school 902820 950011   New London School District 90282000595 956111 New London High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435101 2435101 CT     school 902850 960011   New Milford School District 90285000602 966111 New Milford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435109 2435109 CT     school 902880 940011   Newington School District 90288000610 946111 Newington High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435117 2435117 CT     school 902910 970011   Newtown School District 90291000615 976111 Newtown High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435123 2435123 CT     school 902970 990011   North Branford School District 90297000621 996111 North Branford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435131 2435131 CT     school 903030 1010011   North Haven School District 90303000631 1016111 North Haven High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435134 2435134 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2435152 2435152 CT     school 903090 1030011   Norwalk School District 90309000638 1036211 Brien McMahon High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435153 2435153 CT     school 903090 1030011   Norwalk School District 90309001917 1030511 Center for Global Studies Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435154 2435154 CT     school 903090 1030011   Norwalk School District 90309000655 1036111 Norwalk High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435176 2435176 CT     school 903180 1060011   Old Saybrook School District 90318000684 1066111 Old Saybrook Senior High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435184 2435184 CT     school 903240 1080011   Oxford School District 90324001504 1086011 Oxford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435191 2435191 CT     school 903270 1090011   Plainfield School District 90327000695 1096111 Plainfield High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435196 2435196 CT     school 903300 1100011   Plainville School District 90330000703 1106111 Plainville High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435201 2435201 CT     school 903330 1110011   Plymouth School District 90333001199 1116111 Terryville High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435207 2435207 CT     school 903390 1130011   Portland School District 90339000712 1136111 Portland High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435212 2435212 CT     school 903480 1160011   Putnam School District 90348000719 1166111 Putnam High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435219 2435219 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_1                                                   0                                             0
2435223 2435223 CT     school 903515 2060012   Regional School District 06 90351500725 2066112 Wamogo Regional High School Regional Schools Regular School No High 07 12 2019   grade_1                                                   0                                             0
2435227 2435227 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_1                                                   0                                             0
2435231 2435231 CT     school 903530 2120012   Regional School District 12 90353001632 2120312 Shepaug Valley School Regional Schools Regular School No High 06 12 2019   grade_1                                                   0                                             0
2435237 2435237 CT     school 903535 2130012   Regional School District 13 90353500737 2136112 Coginchaug Regional High School Regional Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435242 2435242 CT     school 903536 2140012   Regional School District 14 90353600745 2146112 Nonnewaug High School Regional Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435250 2435250 CT     school 903537 2150012   Regional School District 15 90353700749 2156212 Pomperaug Regional High School Regional Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435256 2435256 CT     school 903538 2160012   Regional School District 16 90353801356 2166012 Woodland Regional High School Regional Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435261 2435261 CT     school 903539 2170012   Regional School District 17 90353900759 2176112 Haddam-Killingworth High School Regional Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435267 2435267 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_1                                                   0                                             0
2435283 2435283 CT     school 903810 1180011   Ridgefield School District 90381000779 1186111 Ridgefield High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435289 2435289 CT     school 903840 1190011   Rocky Hill School District 90384000785 1196111 Rocky Hill High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435296 2435296 CT     school 903990 1240011   Seymour School District 90399000793 1246111 Seymour High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435309 2435309 CT     school 904050 1260011   Shelton School District 90405000806 1266111 Shelton High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435319 2435319 CT     school 904110 1280011   Simsbury School District 90411000813 1286111 Simsbury High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435323 2435323 CT     school 904140 1290011   Somers School District 90414000819 1296111 Somers High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435331 2435331 CT     school 904170 1320011   South Windsor School District 90417000826 1320311 Alternative Education Program Program Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435332 2435332 CT     school 904170 1320011   South Windsor School District 90417000826 1326211 South Windsor High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435353 2435353 CT     school 904230 1310011   Southington School District 90423000838 1316211 Southington High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435356 2435356 CT     school 904260 1330011   Sprague School District 90426000842 1330111 Sayles School Public Schools Regular School No Other PK 12 2019   grade_1                                                   30                                             30
2435361 2435361 CT     school 904290 1340011   Stafford School District 90429000845 1346111 Stafford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435385 2435385 CT     school 904320 1350011   Stamford School District 90432000867 1356111 Stamford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435386 2435386 CT     school 904320 1350011   Stamford School District 90432001468 1356411 The Academy of Information, Technology & Engineering Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435387 2435387 CT     school 904320 1350011   Stamford School District 90432000871 1356311 Westhill High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435397 2435397 CT     school 904380 1370011   Stonington School District 90438000881 1376111 Stonington High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435417 2435417 CT     school 904440 1380011   Stratford School District 90444000885 1386211 Bunnell High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435420 2435420 CT     school 904440 1380011   Stratford School District 90444000897 1386111 Stratford High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435425 2435425 CT     school 904470 1390011   Suffield School District 90447000904 1396111 Suffield High School Public Schools Regular School No High 09 12 2019   grade_1                                                   0                                             0
2435428 2435428 CT     school 904500 1400011   Thomaston School District 90450000908 1406211 Thomaston High School Public Schools Regular School No High 07 12 2019   grade_1                                                   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]);