Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 1,449

grade

  • grade_6 · 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
2442287 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   99                                             99
2442044 CT     school 901920 640011   Hartford School District 90192000371 641211 McDonough Middle School Public Schools Regular School No Middle 06 08 2019   grade_6                                                   98                                             98
2441558 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   97                                             97
2442641 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   97                                             97
2442927 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2019   grade_6                                                   97                                             97
2442942 CT     school 900011 2650013   Interdistrict School for Arts and Comm District 90001100797 2655113 Interdistrict School For Arts And Communication Public Charter Schools Regular School Yes Middle 06 08 2019   grade_6                                                   97                                             97
2441557 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   96                                             96
2442940 CT     school 900033 2830013   Park City Prep Charter School District 90003301449 2835113 Park City Prep Charter School Public Charter Schools Regular School Yes Middle 05 08 2019   grade_6                                                   95                                             95
2441659 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   94                                             94
2442486 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2019   grade_6                                                   93                                             93
2441634 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   91                                             91
2442045 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2019   grade_6                                                   91                                             91
2442067 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2019   grade_6                                                   91                                             91
2442558 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   91                                             91
2442456 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2019   grade_6                                                   90                                             90
2442929 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   grade_6                                                   90                                             90
2441622 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   89                                             89
2441637 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   89                                             89
2442511 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_6                                                   89                                             89
2442618 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2019   grade_6                                                   89                                             89
2441846 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   88                                             88
2441628 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   87                                             87
2441863 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   87                                             87
2442094 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   86                                             86
2442420 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 04 08 2019   grade_6                                                   86                                             86
2442040 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   84                                             84
2442319 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_6                                                   84                                             84
2442340 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_6                                                   83                                             83
2442138 CT     school 902370 790011   Marlborough School District 90237000437 790111 Elmer Thienes-Mary Hall Elementary School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   82                                             82
2442338 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2019   grade_6                                                   82                                             82
2442889 CT     school 905160 1620011   Winchester School District 90516001080 1625111 Pearson School Public Schools Regular School No Elementary 03 06 2019   grade_6                                                   82                                             82
2441735 CT     school 900750 250011   Cheshire School District 90075000126 250611 Doolittle School Public Schools Regular School No Elementary 01 06 2019   grade_6                                                   80                                             80
2442640 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   grade_6                                                   80                                             80
2441752 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2019   grade_6                                                   8                                             8
2442127 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2019   grade_6                                                   8                                             8
2442154 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2019   grade_6                                                   8                                             8
2442467 CT     school 903515 2060012   Regional School District 06 90351500726 2060312 Warren Elementary School Regional Schools Regular School No Elementary PK 06 2019   grade_6                                                   8                                             8
2442779 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2019   grade_6                                                   8                                             8
2442272 CT     school 902760 920011   New Hartford School District 90276000538 920311 Ann Antolini School Public Schools Regular School No Elementary 03 06 2019   grade_6                                                   79                                             79
2442649 CT     school 904440 1380011   Stratford School District 90444000898 1381311 Eli Whitney School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   79                                             79
2441633 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   78                                             78
2442297 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   78                                             78
2442676 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   78                                             78
2442041 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2019   grade_6                                                   75                                             75
2442872 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   75                                             75
2441807 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2019   grade_6                                                   74                                             74
2441734 CT     school 900750 250011   Cheshire School District 90075000129 250511 Norton School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   73                                             73
2442282 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   73                                             73
2442296 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   73                                             73
2442648 CT     school 904440 1380011   Stratford School District 90444000887 1380311 Chapel School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   72                                             72
2441804 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2019   grade_6                                                   71                                             71
2441864 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   71                                             71
2441986 CT     school 901860 620011   Hamden School District 90186000348 621011 Spring Glen School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   70                                             70
2442008 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_6                                                   70                                             70
2442099 CT     school 902160 720011   Ledyard School District 90216000399 720311 Juliet W. Long School Public Schools Regular School No Elementary 03 06 2019   grade_6                                                   70                                             70
2441714 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2019   grade_6                                                   7                                             7
2442286 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2019   grade_6                                                   7                                             7
2442706 CT     school 904650 1450011   Union School District 90465000938 1450111 Union School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   7                                             7
2442777 CT     school   1510011   Waterbury School District 90483001418 1519111 Enlightenment School Program           2019   grade_6                                                   7                                             7
2442645 CT     school 904440 1380011   Stratford School District 90444000895 1381011 Second Hill Lane School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   68                                             68
2442937 CT     school 900214 2890013   Elm City College Preparatory School District 90021401548 2890113 Elm City College Preparatory School Public Charter Schools Regular School Yes Other KG 12 2019   grade_6                                                   68                                             68
2442423 CT     school 903210 1070011   Orange School District 90321000687 1070511 Peck Place School Public Schools Regular School No Elementary 01 06 2019   grade_6                                                   67                                             67
2442651 CT     school 904440 1380011   Stratford School District 90444000894 1380911 Nichols School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   67                                             67
2442672 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2019   grade_6                                                   67                                             67
2441695 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   66                                             66
2442562 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   66                                             66
2442007 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   65                                             65
2442027 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2019   grade_6                                                   64                                             64
2442339 CT     school 902820 950011   New London School District 90282001919 951411 New London Visual and Performing Arts Magnet School Public Schools Regular School No Middle 06 09 2019   grade_6                                                   64                                             64
2442559 CT     school 904110 1280011   Simsbury School District 90411000810 1280111 Central School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   64                                             64
2442892 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2019   grade_6                                                   64                                             64
2441589 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   63                                             63
2441646 CT     school 900450 150011   Bridgeport School District 90045000074 152011 Madison School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   63                                             63
2442070 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   grade_6                                                   63                                             63
2442291 CT     school 902790 930011   New Haven School District 90279001388 933011 King/Robinson Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   63                                             63
2441565 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_6                                                   62                                             62
2441638 CT     school 900450 150011   Bridgeport School District 90045000081 152611 Roosevelt School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   62                                             62
2442004 CT     school 901920 640011   Hartford School District 90192000366 640911 Environmental Sciences Magnet at Hooker School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   62                                             62
2442022 CT     school 901920 640011   Hartford School District 90192000384 642111 West Middle School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   62                                             62
2442379 CT     school 903060 1020011   North Stonington School District 90306000635 1026111 Wheeler High School Public Schools Regular School No High 06 12 2019   grade_6                                                   62                                             62
2442424 CT     school 903210 1070011   Orange School District 90321000688 1070311 Race Brook School Public Schools Regular School No Elementary 01 06 2019   grade_6                                                   62                                             62
2442882 CT     school 905100 1600011   Willington School District 90510001070 1605111 Hall Memorial School Public Schools Regular School No Middle 05 08 2019   grade_6                                                   62                                             62
2442098 CT     school 902160 720011   Ledyard School District 90216000400 720111 Ledyard Center School   Regular School No Elementary KG 06 2019   grade_6                                                   61                                             61
2442873 CT     school 905070 1590011   Wethersfield School District 90507001064 1591111 Highcrest School Public Schools Regular School No Elementary PK 06 2019   grade_6                                                   61                                             61
2441708 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_6                                                   6                                             6
2442593 CT     school   1310011   Southington School District 90423001668 1310511 EASE Program           2019   grade_6                                                   6                                             6
2442931 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2019   grade_6                                                   6                                             6
2441606 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   59                                             59
2441632 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   59                                             59
2441987 CT     school 901860 620011   Hamden School District 90186000349 621411 West Woods School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   59                                             59
2442105 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2019   grade_6                                                   59                                             59
2442875 CT     school 905070 1590011   Wethersfield School District 90507001060 1591011 Charles Wright School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   59                                             59
2442932 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2019   grade_6                                                   59                                             59
2441635 CT     school 900450 150011   Bridgeport School District 90045000071 151711 Park City Magnet School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   57                                             57
2441984 CT     school 901860 620011   Hamden School District 90186000345 621111 Ridge Hill School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   57                                             57
2442560 CT     school 904110 1280011   Simsbury School District 90411000812 1280611 Latimer Lane School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   57                                             57
2441645 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2019   grade_6                                                   56                                             56
2442023 CT     school 901920 640011   Hartford School District 90192000385 642211 Wish Museum School Public Schools Regular School No Elementary PK 08 2019   grade_6                                                   56                                             56
2442043 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2019   grade_6                                                   56                                             56
2442653 CT     school 904440 1380011   Stratford School District 90444000899 1381411 Wilcoxson School Public Schools Regular School No Elementary KG 06 2019   grade_6                                                   56                                             56

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