enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,461 ✖

grade ✖

  • grade_6 · 1,461 ✖
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
2768224 2768224 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   99                                             99
2768391 2768391 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2020   grade_6                                                   99                                             99
2768418 2768418 CT     school 903535 2130012   Regional School District 13 90353500742 2130412 Middlefield Memorial School Regional Schools Regular School No Middle 04 06 2020   grade_6                                                   99                                             99
2768872 2768872 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_6                                                   99                                             99
2768873 2768873 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_6                                                   99                                             99
2768871 2768871 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   98                                             98
2767567 2767567 CT     school 900450 150011   Bridgeport School District 90045000053 154011 Blackham School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   97                                             97
2767642 2767642 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   97                                             97
2768849 2768849 CT     school 905250 1650011   Windsor Locks School District 90525001101 1655111 Windsor Locks Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   96                                             96
2768894 2768894 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 2020   grade_6                                                   96                                             96
2768010 2768010 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2020   grade_6                                                   94                                             94
2768874 2768874 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_6                                                   94                                             94
2768178 2768178 CT     school 902670 890011   New Britain School District 90267000510 891111 DiLoreto Elementary & Middle School Public Schools Regular School No Elementary KG 08 2020   grade_6                                                   93                                             93
2768558 2768558 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2020   grade_6                                                   93                                             93
2768832 2768832 CT     school 905160 1620011   Winchester School District 90516001080 1625111 Pearson School Public Schools Regular School No Elementary 03 06 2020   grade_6                                                   92                                             92
2768275 2768275 CT     school 902820 950011   New London School District 90282000596 955111 Bennie Dover Jackson Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   90                                             90
2767675 2767675 CT     school 900720 240011   Chaplin School District 90072000121 240211 Chaplin Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   9                                             9
2767501 2767501 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   88                                             88
2768449 2768449 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2020   grade_6                                                   88                                             88
2768500 2768500 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   88                                             88
2767573 2767573 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   87                                             87
2768401 2768401 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   87                                             87
2768594 2768594 CT     school 904440 1380011   Stratford School District 90444000892 1381511 Stratford Academy - Johnson House Public Schools Regular School No Elementary 02 06 2020   grade_6                                                   86                                             86
2768893 2768893 CT     school 900219 2940013   Great Oaks Charter School District 90021901782 2940113 Great Oaks Charter School Public Charter Schools Regular School Yes Secondary 06 11 2020   grade_6                                                   86                                             86
2767500 2767500 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   84                                             84
2768256 2768256 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2020   grade_6                                                   84                                             84
2768616 2768616 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   83                                             83
2768509 2768509 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   81                                             81
2768591 2768591 CT     school 904440 1380011   Stratford School District 90444000894 1380911 Nichols School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   81                                             81
2767830 2767830 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2020   grade_6                                                   8                                             8
2767579 2767579 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   79                                             79
2767807 2767807 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   79                                             79
2767993 2767993 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2020   grade_6                                                   79                                             79
2767582 2767582 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   78                                             78
2767808 2767808 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   77                                             77
2767755 2767755 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2020   grade_6                                                   76                                             76
2768589 2768589 CT     school 904440 1380011   Stratford School District 90444000898 1381311 Eli Whitney School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   76                                             76
2767752 2767752 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2020   grade_6                                                   75                                             75
2768013 2768013 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2020   grade_6                                                   75                                             75
2768233 2768233 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   75                                             75
2767578 2767578 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   74                                             74
2768220 2768220 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   74                                             74
2768360 2768360 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   74                                             74
2768815 2768815 CT     school 905070 1590011   Wethersfield School District 90507001064 1591111 Highcrest School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   74                                             74
2767794 2767794 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   71                                             71
2768587 2768587 CT     school 904440 1380011   Stratford School District 90444000887 1380311 Chapel School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   71                                             71
2767954 2767954 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   70                                             70
2767866 2767866 CT     school 901590 530011   Franklin School District 90159000278 530111 Franklin Elementary School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   7                                             7
2768713 2768713 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2020   grade_6                                                   7                                             7
2767680 2767680 CT     school 900750 250011   Cheshire School District 90075000129 250511 Norton School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   69                                             69
2767927 2767927 CT     school 901860 620011   Hamden School District 90186000336 621211 Bear Path School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   69                                             69
2767968 2767968 CT     school 901920 640011   Hartford School District 90192000384 642111 West Middle School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   69                                             69
2768231 2768231 CT     school 902790 930011   New Haven School District 90279001564 931911 Mauro-Sheridan Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   67                                             67
2767682 2767682 CT     school 900750 250011   Cheshire School District 90075000126 250611 Doolittle School Public Schools Regular School No Elementary 01 06 2020   grade_6                                                   66                                             66
2767948 2767948 CT     school 901920 640011   Hartford School District 90192001435 646911 Capital Preparatory Magnet School Public Schools Regular School No Other PK 12 2020   grade_6                                                   66                                             66
2768234 2768234 CT     school 902790 930011   New Haven School District 90279000581 932911 Truman School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   65                                             65
2768502 2768502 CT     school 904110 1280011   Simsbury School District 90411000812 1280611 Latimer Lane School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   65                                             65
2767509 2767509 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 2020   grade_6                                                   64                                             64
2767932 2767932 CT     school 901860 620011   Hamden School District 90186000349 621411 West Woods School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   64                                             64
2767973 2767973 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Elementary KG 08 2020   grade_6                                                   64                                             64
2768612 2768612 CT     school 904500 1400011   Thomaston School District 90450001117 1400211 Thomaston Center School Public Schools Regular School No Middle 04 06 2020   grade_6                                                   64                                             64
2768814 2768814 CT     school 905070 1590011   Wethersfield School District 90507001061 1590211 Emerson-Williams School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   64                                             64
2768888 2768888 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 2020   grade_6                                                   64                                             64
2767836 2767836 CT     school 901500 500011   Essex School District 90150000255 500111 Essex Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   63                                             63
2767949 2767949 CT     school 901920 640011   Hartford School District 90192000360 640711 Dwight-Bellizzi Dual Language Academy Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   63                                             63
2768210 2768210 CT     school 902760 920011   New Hartford School District 90276000538 920311 Ann Antolini School Public Schools Regular School No Elementary 03 06 2020   grade_6                                                   63                                             63
2768593 2768593 CT     school 904440 1380011   Stratford School District 90444000899 1381411 Wilcoxson School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   63                                             63
2768835 2768835 CT     school 905190 1630011   Windham School District 90519001640 1630411 Charles H. Barrows STEM Academy Public Schools Regular School No Elementary KG 08 2020   grade_6                                                   63                                             63
2767533 2767533 CT     school 900240 80011   Bethany School District 90024000022 80111 Bethany Community School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   62                                             62
2768045 2768045 CT     school 902220 740011   Litchfield School District 90222000407 740311 Litchfield Intermediate School Public Schools Regular School No Middle 04 06 2020   grade_6                                                   62                                             62
2768075 2768075 CT     school 902370 790011   Marlborough School District 90237000437 790111 Elmer Thienes-Mary Hall Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   62                                             62
2767550 2767550 CT     school 900360 120011   Bolton School District 90036000036 120111 Bolton Center School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   61                                             61
2767951 2767951 CT     school 901920 640011   Hartford School District 90192000366 640911 Environmental Sciences Magnet at Hooker School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   61                                             61
2768035 2768035 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   61                                             61
2768277 2768277 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 2020   grade_6                                                   61                                             61
2768877 2768877 CT     school 900221 2970013   Capital Preparatory Harbor School District 90022101803 2970113 Capital Preparatory Harbor School Public Charter Schools Regular School Yes Other KG 12 2020   grade_6                                                   61                                             61
2767662 2767662 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2020   grade_6                                                   6                                             6
2767663 2767663 CT     school   2410014   Capitol Region Education Council 90070001510 2419514 River Street School Birken Campus Program           2020   grade_6                                                   6                                             6
2767987 2767987 CT     school   640011   Hartford School District   640210 iGOAL 2 - Kennelly School Program           2020   grade_6                                                   6                                             6
2768023 2768023 CT     school   2450014   Learn 90345001680 2451114 Learn Intensive Program Program           2020   grade_6                                                   6                                             6
2768092 2768092 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2020   grade_6                                                   6                                             6
2768245 2768245 CT     school   930011   New Haven School District   937511 East Rock Self Contained MD Program           2020   grade_6                                                   6                                             6
2768882 2768882 CT     school   2530014   Eastern Connecticut Regional Educational Service Center (EASTCONN) 90136001156 2539014 EastConn Special Education Program           2020   grade_6                                                   6                                             6
2768364 2768364 CT     school 903210 1070011   Orange School District 90321000688 1070311 Race Brook School Public Schools Regular School No Elementary 01 06 2020   grade_6                                                   59                                             59
2768583 2768583 CT     school 904440 1380011   Stratford School District 90444000889 1380411 Franklin School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   59                                             59
2768584 2768584 CT     school 904440 1380011   Stratford School District 90444000895 1381011 Second Hill Lane School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   59                                             59
2768817 2768817 CT     school 905070 1590011   Wethersfield School District 90507001059 1590811 Alfred W. Hanmer School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   59                                             59
2767577 2767577 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   57                                             57
2768212 2768212 CT     school 902790 930011   New Haven School District 90279000542 930211 Barnard Environmental Magnet School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   57                                             57
2768504 2768504 CT     school 904110 1280011   Simsbury School District 90411000816 1280411 Tootin' Hills School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   57                                             57
2768211 2768211 CT     school 902790 930011   New Haven School District 90279000580 931511 Augusta Lewis Troup School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   56                                             56
2768315 2768315 CT     school 903060 1020011   North Stonington School District 90306000634 1020111 North Stonington Elementary School Public Schools Regular School No Elementary PK 06 2020   grade_6                                                   56                                             56
2768363 2768363 CT     school 903210 1070011   Orange School District 90321000687 1070511 Peck Place School Public Schools Regular School No Elementary 01 06 2020   grade_6                                                   56                                             56
2768685 2768685 CT     school 904830 1510011   Waterbury School District 90483000970 1512711 Carrington School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   56                                             56
2768818 2768818 CT     school 905070 1590011   Wethersfield School District 90507001060 1591011 Charles Wright School Public Schools Regular School No Elementary KG 06 2020   grade_6                                                   56                                             56
2767564 2767564 CT     school 900450 150011   Bridgeport School District 90045000049 150111 Barnum School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   55                                             55
2767584 2767584 CT     school 900450 150011   Bridgeport School District 90045000086 153011 Waltersville School Public Schools Regular School No Elementary PK 08 2020   grade_6                                                   55                                             55
2767955 2767955 CT     school 901920 640011   Hartford School District 90192000370 641111 Kinsella Magnet School of Performing Arts Public Schools Regular School No Other PK 12 2020   grade_6                                                   55                                             55
2767986 2767986 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2020   grade_6                                                   55                                             55
2767588 2767588 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2020   grade_6                                                   54                                             54

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