enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 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
2443869 2443869 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 04 08 2019   grade_7                                                   99                                             99
2749111 2749111 CT     school 901920 640011   Hartford School District 90192000381 641911 Milner Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   99                                             99
2749984 2749984 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_7                                                   99                                             99
2769043 2769043 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   99                                             99
2444376 2444376 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_7                                                   97                                             97
2749537 2749537 CT     school 903535 2130012   Regional School District 13 90353500739 2135112 Frank Ward Strong School Regional Schools Regular School No Middle 06 08 2021   grade_7                                                   96                                             96
2749982 2749982 CT     school 900208 2850013   Achievement First Bridgeport Academy District 90020801493 2850113 Achievement First Bridgeport Academy Public Charter Schools Regular School Yes Other KG 12 2021   grade_7                                                   96                                             96
2770333 2770333 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_7                                                   96                                             96
2769065 2769065 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   95                                             95
2769910 2769910 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_7                                                   95                                             95
2770355 2770355 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_7                                                   95                                             95
2748729 2748729 CT     school 900510 170011   Bristol School District 90051001624 172011 West Bristol School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   94                                             94
2443108 2443108 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   93                                             93
2443494 2443494 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2019   grade_7                                                   93                                             93
2748757 2748757 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   93                                             93
2750008 2750008 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_7                                                   93                                             93
2769885 2769885 CT     school 903536 2140012   Regional School District 14 90353600746 2145112 Woodbury Middle School Regional Schools Regular School No Middle 06 08 2020   grade_7                                                   93                                             93
2770332 2770332 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   93                                             93
2443909 2443909 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   92                                             92
2444378 2444378 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   grade_7                                                   92                                             92
2750029 2750029 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2021   grade_7                                                   92                                             92
2443736 2443736 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   91                                             91
2443900 2443900 CT     school 903390 1130011   Portland School District 90339000713 1135111 Portland Middle School Public Schools Regular School No Middle 07 08 2019   grade_7                                                   91                                             91
2444067 2444067 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2019   grade_7                                                   91                                             91
2748688 2748688 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   91                                             91
2770019 2770019 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   91                                             91
2770335 2770335 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2020   grade_7                                                   91                                             91
2444391 2444391 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_7                                                   90                                             90
2749673 2749673 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   90                                             90
2750006 2750006 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_7                                                   90                                             90
2769496 2769496 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   90                                             90
2769821 2769821 CT     school 903180 1060011   Old Saybrook School District 90318000007 1065211 Old Saybrook Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   90                                             90
2769858 2769858 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2020   grade_7                                                   90                                             90
2443166 2443166 CT     school   2410014   Capitol Region Education Council 90070001495 2419314 River Street School Program           2019   grade_7                                                   9                                             9
2443702 2443702 CT     school   890011   New Britain School District   891711 Slade KEY Middle Program           2019   grade_7                                                   9                                             9
2748951 2748951 CT     school   490011   Enfield School District   490911 John F. Kennedy - Adaptive Learning Program (ALP) Program           2021   grade_7                                                   9                                             9
2749996 2749996 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2021   grade_7                                                   9                                             9
2769456 2769456 CT     school   640011   Hartford School District   640110 iGOAL 1 - Milner School Program           2020   grade_7                                                   9                                             9
2769525 2769525 CT     school   770011   Manchester School District   771511 Manchester Middle Academy Program           2020   grade_7                                                   9                                             9
2770341 2770341 CT     school 900930 310011   Cornwall School District 90093000140 310111 Cornwall Consolidated School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   9                                             9
2443077 2443077 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   89                                             89
2769038 2769038 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   89                                             89
2769717 2769717 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_7                                                   89                                             89
2443144 2443144 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   88                                             88
2443768 2443768 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_7                                                   88                                             88
2443787 2443787 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_7                                                   88                                             88
2444389 2444389 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_7                                                   88                                             88
2443960 2443960 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_7                                                   87                                             87
2443489 2443489 CT     school 901920 640011   Hartford School District 90192001616 643811 Betances STEM Magnet School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   86                                             86
2769736 2769736 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_7                                                   86                                             86
2769034 2769034 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   85                                             85
2769255 2769255 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   85                                             85
2769454 2769454 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2020   grade_7                                                   85                                             85
2770376 2770376 CT     school 905372 9020022   The Gilbert School District 90537201222 9026122 The Gilbert School Endowed and Incorporated Academies Schools Regular School No High 07 12 2020   grade_7                                                   85                                             85
2443082 2443082 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   84                                             84
2444375 2444375 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   84                                             84
2770353 2770353 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 2020   grade_7                                                   84                                             84
2443905 2443905 CT     school 903480 1160011   Putnam School District 90348000720 1165111 Putnam Middle School Public Schools Regular School No Middle 06 08 2019   grade_7                                                   83                                             83
2749109 2749109 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_7                                                   83                                             83
2749373 2749373 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_7                                                   83                                             83
2749565 2749565 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_7                                                   83                                             83
2443490 2443490 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2019   grade_7                                                   82                                             82
2444090 2444090 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   82                                             82
2770077 2770077 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2020   grade_7                                                   82                                             82
2749625 2749625 CT     school 904140 1290011   Somers School District 90414000818 1295111 Mabelle B. Avery Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   81                                             81
2749732 2749732 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   81                                             81
2769039 2769039 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   81                                             81
2443094 2443094 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2019   grade_7                                                   80                                             80
2769216 2769216 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_7                                                   80                                             80
2443128 2443128 CT     school   170011   Bristol School District   170811 Chippens Hilll Middle School Extended Resource Program           2019   grade_7                                                   8                                             8
2443603 2443603 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2019   grade_7                                                   8                                             8
2749208 2749208 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2021   grade_7                                                   8                                             8
2769553 2769553 CT     school   800011   Meriden School District   801211 STEPS - MS Program           2020   grade_7                                                   8                                             8
2770337 2770337 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   8                                             8
2443456 2443456 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   79                                             79
2749113 2749113 CT     school 901920 640011   Hartford School District 90192001370 646511 Sport and Medical Sciences Academy Public Schools Regular School No High 06 12 2021   grade_7                                                   79                                             79
2749338 2749338 CT     school 902790 930011   New Haven School District 90279000584 933111 Conte/West Hills Magnet School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   79                                             79
2749519 2749519 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2021   grade_7                                                   79                                             79
2443739 2443739 CT     school 902790 930011   New Haven School District 90279001386 930811 John S. Martinez Sea and Sky STEM School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   78                                             78
2444125 2444125 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   78                                             78
2443543 2443543 CT     school 902130 710011   Lebanon School District 90213000028 715111 Lebanon Middle School Public Schools Regular School No Middle 05 08 2019   grade_7                                                   77                                             77
2769415 2769415 CT     school 901920 640011   Hartford School District 90192000368 641011 Kennelly School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   77                                             77
2769681 2769681 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_7                                                   77                                             77
2769694 2769694 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2020   grade_7                                                   77                                             77
2748865 2748865 CT     school 901170 400011   East Granby School District 90117000182 405111 East Granby Middle School Public Schools Regular School No Middle 06 08 2021   grade_7                                                   76                                             76
2769049 2769049 CT     school 900450 150011   Bridgeport School District 90045001162 154211 James J. Curiale School Public Schools Regular School No Elementary KG 08 2020   grade_7                                                   76                                             76
2443457 2443457 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_7                                                   75                                             75
2443731 2443731 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_7                                                   75                                             75
2748868 2748868 CT     school 901200 410011   East Haddam School District 90120000198 415111 Nathan Hale-Ray Middle School Public Schools Regular School No Middle 04 08 2021   grade_7                                                   75                                             75
2749132 2749132 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2021   grade_7                                                   75                                             75
2443745 2443745 CT     school 902790 930011   New Haven School District 90279001387 931011 Ross/Woodward School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   74                                             74
2748692 2748692 CT     school 900450 150011   Bridgeport School District 90045000076 152211 Jettie S. Tisdale School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   74                                             74
2749107 2749107 CT     school 901920 640011   Hartford School District 90192001478 646411 Classical Magnet School Public Schools Regular School No High 06 12 2021   grade_7                                                   74                                             74
2443256 2443256 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_7                                                   73                                             73
2443789 2443789 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_7                                                   73                                             73
2444089 2444089 CT     school 904380 1370011   Stonington School District 90438000879 1375111 Pawcatuck Middle School   Regular School No Middle 05 08 2019   grade_7                                                   73                                             73
2748693 2748693 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   73                                             73
2748697 2748697 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2021   grade_7                                                   73                                             73
2769738 2769738 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_7                                                   73                                             73
2443086 2443086 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2019   grade_7                                                   72                                             72

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