enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 1,449 ✖

grade ✖

  • grade_5 · 1,449 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▲ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2440405 2440405 CT     school 901410 460011   Easton School District 90141000234 460111 Samuel Staples Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   99                                             99
2440446 2440446 CT     school 901530 510011   Fairfield School District 90153000269 511311 Sherman School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   99                                             99
2440887 2440887 CT     school 902820 950011   New London School District 90282000594 950911 Nathan Hale Arts Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   99                                             99
2441372 2441372 CT     school 904920 1550011   West Hartford School District 90492001014 1550611 Duffy School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   99                                             99
2441477 2441477 CT     school 905370 1690011   Woodstock School District 90537000573 1695111 Woodstock Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   99                                             99
2441478 2441478 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_5                                                   99                                             99
2440631 2440631 CT     school 903450 2450014   Learn 90345000079 2450114 Regional Multicultural Magnet School Regional Education Service Center Schools Regular School No Elementary KG 05 2019   grade_5                                                   98                                             98
2441121 2441121 CT     school 904170 1320011   South Windsor School District 90417000822 1320711 Eli Terry School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   98                                             98
2441133 2441133 CT     school 904230 1310011   Southington School District 90423000829 1311511 Derynoski Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   98                                             98
2440884 2440884 CT     school 902820 950011   New London School District 90282000591 950311 C.B. Jennings International Elementary Magnet Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   97                                             97
2441048 2441048 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_5                                                   97                                             97
2441249 2441249 CT     school 904620 1440011   Trumbull School District 90462000934 1440311 Middlebrook School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   97                                             97
2441417 2441417 CT     school 905040 1580011   Westport School District 90504001363 1580811 Saugatuck Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   97                                             97
2441480 2441480 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   grade_5                                                   97                                             97
2440691 2440691 CT     school 902400 800011   Meriden School District 90240000443 800411 Israel Putnam School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   96                                             96
2441300 2441300 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   96                                             96
2440246 2440246 CT     school 900570 190011   Brooklyn School District 90057000114 195111 Brooklyn Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   95                                             95
2440785 2440785 CT     school 902670 890011   New Britain School District 90267000510 891111 DiLoreto Elementary & Middle School Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   95                                             95
2440759 2440759 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   94                                             94
2440838 2440838 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   93                                             93
2441081 2441081 CT     school 903840 1190011   Rocky Hill School District 90384000784 1190411 Myrtle H. Stevens School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   93                                             93
2441164 2441164 CT     school 904320 1350011   Stamford School District 90432000865 1350911 Roxbury School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   93                                             93
2441290 2441290 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   93                                             93
2441246 2441246 CT     school 904620 1440011   Trumbull School District 90462000929 1440811 Daniels Farm School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   92                                             92
2440109 2440109 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2019   grade_5                                                   91                                             91
2440328 2440328 CT     school 901020 340011   Danbury School District 90102000159 341411 Ellsworth Avenue School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   91                                             91
2440343 2440343 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   91                                             91
2440618 2440618 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2019   grade_5                                                   91                                             91
2440797 2440797 CT     school 902670 890011   New Britain School District 90267000523 891211 Smalley Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   91                                             91
2441318 2441318 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   91                                             91
2440798 2440798 CT     school 902670 890011   New Britain School District 90267000524 891311 Smith Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   90                                             90
2440939 2440939 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   90                                             90
2441169 2441169 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2019   grade_5                                                   90                                             90
2441206 2441206 CT     school 904440 1380011   Stratford School District 90444000892 1381511 Stratford Academy - Johnson House Public Schools Regular School No Elementary 02 06 2019   grade_5                                                   90                                             90
2440471 2440471 CT     school 901590 530011   Franklin School District 90159000278 530111 Franklin Elementary School Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   9                                             9
2440475 2440475 CT     school 901620 540011   Glastonbury School District 90162000286 540611 Hopewell School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   89                                             89
2440790 2440790 CT     school 902670 890011   New Britain School District 90267000513 890611 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   89                                             89
2441141 2441141 CT     school 904230 1310011   Southington School District 90423000840 1310911 Thalberg Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   89                                             89
2441359 2441359 CT     school 904890 1530011   Watertown School District 90489001003 1530311 Fletcher W. Judson School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   89                                             89
2440497 2440497 CT     school 901710 570011   Greenwich School District 90171000308 571011 Riverside School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   88                                             88
2440556 2440556 CT     school 901920 640011   Hartford School District 90192000636 643211 Expeditionary Learning Academy at Moylan School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   88                                             88
2440695 2440695 CT     school 902400 800011   Meriden School District 90240000450 800811 Roger Sherman School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   88                                             88
2441168 2441168 CT     school 904320 1350011   Stamford School District 90432000860 1350611 Newfield School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   88                                             88
2441244 2441244 CT     school 904620 1440011   Trumbull School District 90462000927 1440111 Booth Hill School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   88                                             88
2441462 2441462 CT     school 905220 1640011   Windsor School District 90522001087 1640111 Clover Street School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   88                                             88
2440188 2440188 CT     school 900450 150011   Bridgeport School District 90045000080 152511 Read School Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   87                                             87
2440489 2440489 CT     school 901710 570011   Greenwich School District 90171000306 570911 Old Greenwich School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   87                                             87
2441011 2441011 CT     school 903510 1170011   Redding School District 90351000721 1175111 John Read Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   87                                             87
2441162 2441162 CT     school 904320 1350011   Stamford School District 90432000859 1350511 K. T. Murphy School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   87                                             87
2441378 2441378 CT     school 904920 1550011   West Hartford School District 90492001026 1551511 Wolcott School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   87                                             87
2440326 2440326 CT     school 901020 340011   Danbury School District 90102000161 341211 Shelter Rock School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   86                                             86
2440453 2440453 CT     school 901530 510011   Fairfield School District 90153000609 511811 Osborn Hill School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   86                                             86
2440473 2440473 CT     school 901620 540011   Glastonbury School District 90162000280 540211 Buttonball Lane School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   86                                             86
2441040 2441040 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_5                                                   86                                             86
2441109 2441109 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2019   grade_5                                                   86                                             86
2441297 2441297 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   86                                             86
2440474 2440474 CT     school 901620 540011   Glastonbury School District 90162000284 540411 Hebron Avenue School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   85                                             85
2440799 2440799 CT     school 902670 890011   New Britain School District 90267000527 891511 Vance Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   85                                             85
2441082 2441082 CT     school 903840 1190011   Rocky Hill School District 90384000786 1190511 West Hill School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   85                                             85
2441090 2441090 CT     school 903990 1240011   Seymour School District 90399000790 1240111 Bungay School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   85                                             85
2441313 2441313 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   85                                             85
2440108 2440108 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2019   grade_5                                                   84                                             84
2440254 2440254 CT     school 900700 2410014   Capitol Region Education Council 90070001629 2410714 Academy of Aerospace and Engineering Elementary Regional Education Service Center Schools Regular School No Elementary PK 05 2019   grade_5                                                   84                                             84
2440650 2440650 CT     school 902160 720011   Ledyard School District 90216000399 720311 Juliet W. Long School Public Schools Regular School No Elementary 03 06 2019   grade_5                                                   84                                             84
2440690 2440690 CT     school 902400 800011   Meriden School District 90240000442 800311 Hanover School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   84                                             84
2440179 2440179 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   83                                             83
2441277 2441277 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   83                                             83
2441415 2441415 CT     school 905040 1580011   Westport School District 90504001055 1580511 King's Highway Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   83                                             83
2440134 2440134 CT     school 900210 70011   Berlin School District 90021000018 70411 Emma Hart Willard School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   82                                             82
2440135 2440135 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   82                                             82
2440341 2440341 CT     school 901050 350011   Darien School District 90105000170 351311 Ox Ridge Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   82                                             82
2440372 2440372 CT     school 901260 430011   East Hartford School District 90126000206 431811 Robert J. O'Brien School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   82                                             82
2440791 2440791 CT     school 902670 890011   New Britain School District 90267000509 890311 Chamberlain Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   82                                             82
2441117 2441117 CT     school 904140 1290011   Somers School District 90414000526 1290411 Somers Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   82                                             82
2441125 2441125 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   82                                             82
2441371 2441371 CT     school 904920 1550011   West Hartford School District 90492001011 1550411 Bugbee School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   82                                             82
2441414 2441414 CT     school 905040 1580011   Westport School District 90504000960 1580411 Green's Farms School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   82                                             82
2440491 2440491 CT     school 901710 570011   Greenwich School District 90171000296 570211 Cos Cob School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   81                                             81
2440621 2440621 CT     school 900007 2610013   Jumoke Academy District 90000700747 2610113 Jumoke Academy Public Charter Schools Regular School Yes Other PK 12 2019   grade_5                                                   81                                             81
2440760 2440760 CT     school 902550 850011   Monroe School District 90255000491 850311 Stepney Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   81                                             81
2441320 2441320 CT     school   1510011   Waterbury School District 90483000958 1519011 State Street School Program           2019   grade_5                                                   8                                             8
2441482 2441482 CT     school 900630 210011   Canaan School District 90063000115 210111 Lee H. Kellogg School Public Schools Regular School No Elementary KG 08 2019   grade_5                                                   8                                             8
2440185 2440185 CT     school 900450 150011   Bridgeport School District 90045000001 151011 Luis Munoz Marin School Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   79                                             79
2441250 2441250 CT     school 904620 1440011   Trumbull School District 90462000936 1440911 Tashua School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   79                                             79
2440340 2440340 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   78                                             78
2440344 2440344 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   78                                             78
2440397 2440397 CT     school 901350 470011   East Windsor School District 90135000230 475411 East Windsor Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   78                                             78
2440414 2440414 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2019   grade_5                                                   78                                             78
2440415 2440415 CT     school 901440 480011   Ellington School District 90144000235 480111 Center School Public Schools Regular School No Elementary KG 06 2019   grade_5                                                   78                                             78
2440450 2440450 CT     school 901530 510011   Fairfield School District 90153000262 510611 McKinley School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   78                                             78
2440452 2440452 CT     school 901530 510011   Fairfield School District 90153000264 511611 North Stratfield School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   78                                             78
2440553 2440553 CT     school 901920 640011   Hartford School District 90192000360 640711 Dwight-Bellizzi Dual Language Academy Public Schools Regular School No Elementary PK 08 2019   grade_5                                                   78                                             78
2440888 2440888 CT     school 902820 950011   New London School District 90282000597 950811 Winthrop STEM Elementary Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   78                                             78
2441192 2441192 CT     school 904380 1370011   Stonington School District 90438000877 1375211 Stonington Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   78                                             78
2441291 2441291 CT     school 904830 1510011   Waterbury School District 90483000969 1510611 Bunker Hill School Public Schools Regular School No Elementary PK 05 2019   grade_5                                                   78                                             78
2440354 2440354 CT     school 901170 400011   East Granby School District 90117000183 400211 R. Dudley Seymour School Public Schools Regular School No Elementary 03 05 2019   grade_5                                                   77                                             77
2440833 2440833 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_5                                                   77                                             77
2440942 2440942 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_5                                                   77                                             77
2441227 2441227 CT     school 904530 1410011   Thompson School District 90453000910 1415111 Thompson Middle School Public Schools Regular School No Middle 05 08 2019   grade_5                                                   77                                             77
2441199 2441199 CT     school 904440 1380011   Stratford School District 90444000887 1380311 Chapel School Public Schools Regular School No Elementary KG 06 2019   grade_5                                                   76                                             76

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