enrollments

Data source: Big Local News · About: Big Local

4,354 rows where grade = "grade_6" and state = "CT" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,354 ✖
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 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
2747250 2747250 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   99                                             99
2747275 2747275 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   99                                             99
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
2442044 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
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
2441558 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 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 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 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
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
2441557 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
2748540 2748540 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   96                                             96
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
2442940 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
2747850 2747850 CT     school 902670 890011   New Britain School District 90267000510 891111 DiLoreto Elementary & Middle School Public Schools Regular School No Elementary KG 08 2021   grade_6                                                   95                                             95
2748539 2748539 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_6                                                   95                                             95
2748562 2748562 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 2021   grade_6                                                   95                                             95
2441659 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
2748065 2748065 CT     school 903390 1130011   Portland School District 90339001393 1130511 Brownstone Intermediate School Public Schools Regular School No Middle 05 06 2021   grade_6                                                   94                                             94
2748564 2748564 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 2021   grade_6                                                   94                                             94
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
2442486 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
2748266 2748266 CT     school 904440 1380011   Stratford School District 90444000892 1381511 Stratford Academy - Johnson House Public Schools Regular School No Elementary 02 06 2021   grade_6                                                   93                                             93
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
2747662 2747662 CT     school 901920 640011   Hartford School District 90192000358 642311 Burr Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   92                                             92
2748098 2748098 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2021   grade_6                                                   92                                             92
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
2441634 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 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 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 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
2747182 2747182 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   91                                             91
2747898 2747898 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   91                                             91
2748121 2748121 CT     school 903540 2180012   Regional School District 18 90354001123 2185112 Lyme-Old Lyme Middle School Regional Schools Regular School No Middle 06 08 2021   grade_6                                                   91                                             91
2442456 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 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
2747253 2747253 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   90                                             90
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
2748392 2748392 CT     school   1510011   Waterbury School District   1514411 Wallace BDLC Program           2021   grade_6                                                   9                                             9
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
2441622 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 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 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 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 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
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
2441628 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 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
2747244 2747244 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   87                                             87
2747669 2747669 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2021   grade_6                                                   87                                             87
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
2442094 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 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
2747416 2747416 CT     school 901110 370011   Derby School District 90111001578 375011 Derby Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   86                                             86
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
2747685 2747685 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2021   grade_6                                                   85                                             85
2748229 2748229 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2021   grade_6                                                   85                                             85
2748537 2748537 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   85                                             85
2442040 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 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
2747929 2747929 CT     school 902790 930011   New Haven School District 90279001519 931711 Engineering - Science University Magnet School Public Schools Regular School No High 06 12 2021   grade_6                                                   84                                             84
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
2442340 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
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
2442138 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 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 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
2747183 2747183 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2021   grade_6                                                   82                                             82
2747484 2747484 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   82                                             82
2747665 2747665 CT     school 901920 640011   Hartford School District 90192000369 641611 M. L. King, Jr. Middle School Public Schools Regular School No Middle 06 08 2021   grade_6                                                   81                                             81
2748288 2748288 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2021   grade_6                                                   81                                             81
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
2441735 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 2442640 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   grade_6                                                   80                                             80
2748172 2748172 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   80                                             80
2441752 2441752 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2019   grade_6                                                   8                                             8
2442127 2442127 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2019   grade_6                                                   8                                             8
2442154 2442154 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2019   grade_6                                                   8                                             8
2442467 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 2442779 CT     school   1510011   Waterbury School District   1512911 North End Autism Program           2019   grade_6                                                   8                                             8
2747367 2747367 CT     school   2430014   Cooperative Educational Services 90091001561 2439114 Preschool-Primary Learning Center (PLC) Program           2021   grade_6                                                   8                                             8
2747603 2747603 CT     school   620011   Hamden School District   620911 Bear Path IIC Program           2021   grade_6                                                   8                                             8
2747620 2747620 CT     school 901890 630011   Hampton School District 90189000351 630111 Hampton Elementary School Public Schools Regular School No Elementary PK 06 2021   grade_6                                                   8                                             8
2747864 2747864 CT     school   890011   New Britain School District   891711 Slade KEY Middle Program           2021   grade_6                                                   8                                             8
2748155 2748155 CT     school 904020 1250011   Sharon School District 90402000795 1250111 Sharon Center School Public Schools Regular School No Elementary PK 08 2021   grade_6                                                   8                                             8

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