enrollments

Data source: Big Local News · About: Big Local

1,449 rows where grade = "grade_4", 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_4 · 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
2439646 2439646 CT     school 904050 1260011   Shelton School District 90405000798 1260511 Elizabeth Shelton School Public Schools Regular School No Elementary PK 04 2019   grade_4                                                   98                                             98
2439719 2439719 CT     school 904320 1350011   Stamford School District 90432000860 1350611 Newfield School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   98                                             98
2439841 2439841 CT     school 904830 1510011   Waterbury School District 90483000966 1512111 B. W. Tinker School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   98                                             98
2440013 2440013 CT     school 905220 1640011   Windsor School District 90522001087 1640111 Clover Street School Public Schools Regular School No Elementary 03 05 2019   grade_4                                                   98                                             98
2439349 2439349 CT     school 902670 890011   New Britain School District 90267000524 891311 Smith Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   97                                             97
2439721 2439721 CT     school 904320 1350011   Stamford School District 90432000866 1351111 Springdale School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   97                                             97
2439107 2439107 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_4                                                   96                                             96
2439851 2439851 CT     school 904830 1510011   Waterbury School District 90483001131 1513311 Rotella Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   96                                             96
2439336 2439336 CT     school 902670 890011   New Britain School District 90267000510 891111 DiLoreto Elementary & Middle School Public Schools Regular School No Elementary PK 08 2019   grade_4                                                   95                                             95
2439715 2439715 CT     school 904320 1350011   Stamford School District 90432000865 1350911 Roxbury School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   95                                             95
2440030 2440030 CT     school 900212 2880013   Achievement First Hartford Academy District 90021201528 2880113 Achievement First Hartford Academy Public Charter Schools Regular School Yes Other KG 12 2019   grade_4                                                   95                                             95
2438761 2438761 CT     school 900510 170011   Bristol School District 90051000098 170511 Greene-Hills School Public Schools Regular School No Elementary PK 08 2019   grade_4                                                   94                                             94
2439493 2439493 CT     school 903090 1030011   Norwalk School District 90309000659 1032311 Silvermine Dual Language Magnet School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   94                                             94
2438956 2438956 CT     school 901410 460011   Easton School District 90141000234 460111 Samuel Staples Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   93                                             93
2439241 2439241 CT     school 902400 800011   Meriden School District 90240000442 800311 Hanover School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   93                                             93
2439243 2439243 CT     school 902400 800011   Meriden School District 90240000445 800511 John Barry School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   93                                             93
2439487 2439487 CT     school 903090 1030011   Norwalk School District 90309000648 1030711 Jefferson Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   93                                             93
2439854 2439854 CT     school 904830 1510011   Waterbury School District 90483000987 1512211 Walsh School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   93                                             93
2438659 2438659 CT     school 900060 20011   Ansonia School District 90006000005 20311 Mead School Public Schools Regular School No Elementary PK 06 2019   grade_4                                                   92                                             92
2439720 2439720 CT     school 904320 1350011   Stamford School District 90432000864 1350811 Rogers International School Public Schools Regular School No Elementary KG 08 2019   grade_4                                                   92                                             92
2438730 2438730 CT     school 900450 150011   Bridgeport School District 90045000087 153211 Geraldine Johnson School Public Schools Regular School No Elementary PK 08 2019   grade_4                                                   91                                             91
2438965 2438965 CT     school 901440 480011   Ellington School District 90144000239 480611 Windermere School Public Schools Regular School No Elementary PK 06 2019   grade_4                                                   91                                             91
2439551 2439551 CT     school 903390 1130011   Portland School District 90339000711 1130411 Gildersleeve School Public Schools Regular School No Elementary 02 04 2019   grade_4                                                   91                                             91
2439828 2439828 CT     school 904740 1480011   Wallingford School District 90474001213 1480311 Parker Farms School Public Schools Regular School No Elementary 03 05 2019   grade_4                                                   91                                             91
2440031 2440031 CT     school 900024 2790013   Amistad Academy District 90002400981 2795113 Amistad Academy Public Charter Schools Regular School Yes Other KG 12 2019   grade_4                                                   91                                             91
2438686 2438686 CT     school 900210 70011   Berlin School District 90021000020 70511 Mary E. Griswold School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   90                                             90
2438878 2438878 CT     school 901020 340011   Danbury School District 90102000163 341611 Stadley Rough School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   90                                             90
2439310 2439310 CT     school 902550 850011   Monroe School District 90255000488 850511 Fawn Hollow Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   90                                             90
2439830 2439830 CT     school 904740 1480011   Wallingford School District 90474000961 1480411 Rock Hill School Public Schools Regular School No Elementary 03 05 2019   grade_4                                                   90                                             90
2440029 2440029 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_4                                                   90                                             90
2438744 2438744 CT     school   150011   Bridgeport School District 90045001472 159011 Bridgeport Learning Center Program           2019   grade_4                                                   9                                             9
2439338 2439338 CT     school   890011   New Britain School District   891611 Gaffney KEY Elementary Program           2019   grade_4                                                   9                                             9
2439577 2439577 CT     school 903530 2120012   Regional School District 12 90353000734 2120112 The Burnham School Regional Schools Regular School No Elementary KG 05 2019   grade_4                                                   9                                             9
2439876 2439876 CT     school   1510011   Waterbury School District   1510111 Bunker Hill BDLC Program           2019   grade_4                                                   9                                             9
2438920 2438920 CT     school 901260 430011   East Hartford School District 90126000196 431011 Dr. Thomas S. O'Connell School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   89                                             89
2439492 2439492 CT     school 903090 1030011   Norwalk School District 90309000658 1031311 Rowayton School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   89                                             89
2439676 2439676 CT     school 904170 1320011   South Windsor School District 90417000825 1320211 Pleasant Valley School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   89                                             89
2439684 2439684 CT     school 904230 1310011   Southington School District 90423000829 1311511 Derynoski Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   89                                             89
2439718 2439718 CT     school 904320 1350011   Stamford School District 90432000858 1351211 Julia A. Stark School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   89                                             89
2438660 2438660 CT     school 900060 20011   Ansonia School District 90006001020 20811 Prendergast School Public Schools Regular School No Elementary KG 06 2019   grade_4                                                   88                                             88
2439327 2439327 CT     school 902640 880011   Naugatuck School District 90264001223 880311 Maple Hill School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   88                                             88
2439490 2439490 CT     school 903090 1030011   Norwalk School District 90309000649 1030811 Kendall Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   88                                             88
2439599 2439599 CT     school 903538 2160012   Regional School District 16 90353801811 2160512 Prospect Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_4                                                   88                                             88
2439848 2439848 CT     school 904830 1510011   Waterbury School District 90483000541 1513111 Maloney Interdistrict Magnet School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   88                                             88
2440027 2440027 CT     school 905370 1690011   Woodstock School District 90537001110 1690211 Woodstock Elementary School Public Schools Regular School No Elementary PK 04 2019   grade_4                                                   88                                             88
2438879 2438879 CT     school 901020 340011   Danbury School District 90102000159 341411 Ellsworth Avenue School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   87                                             87
2439047 2439047 CT     school 901710 570011   Greenwich School District 90171000304 570711 North Mianus School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   87                                             87
2439246 2439246 CT     school 902400 800011   Meriden School District 90240000450 800811 Roger Sherman School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   87                                             87
2439389 2439389 CT     school 902790 930011   New Haven School District 90279000554 931611 Fair Haven School Public Schools Regular School No Elementary PK 08 2019   grade_4                                                   87                                             87
2439641 2439641 CT     school 903990 1240011   Seymour School District 90399000790 1240111 Bungay School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   87                                             87
2439015 2439015 CT     school 901560 520011   Farmington School District 90156001206 520411 East Farms School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   86                                             86
2439869 2439869 CT     school 904830 1510011   Waterbury School District 90483000974 1511111 Margaret M. Generali Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   86                                             86
2439439 2439439 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_4                                                   85                                             85
2439460 2439460 CT     school 902910 970011   Newtown School District 90291000614 970311 Middle Gate Elementary School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   85                                             85
2439864 2439864 CT     school 904830 1510011   Waterbury School District 90483000975 1511411 F. J. Kingsbury School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   85                                             85
2439968 2439968 CT     school 905040 1580011   Westport School District 90504001363 1580811 Saugatuck Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   85                                             85
2438891 2438891 CT     school 901050 350011   Darien School District 90105000165 350211 Hindley Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   84                                             84
2439341 2439341 CT     school 902670 890011   New Britain School District 90267000513 890611 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   84                                             84
2439640 2439640 CT     school 903990 1240011   Seymour School District 90399001642 1240211 Chatfield-LoPresti School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   84                                             84
2438796 2438796 CT     school 900570 190011   Brooklyn School District 90057000113 190111 Brooklyn Elementary School Public Schools Regular School No Elementary PK 04 2019   grade_4                                                   83                                             83
2439024 2439024 CT     school 901620 540011   Glastonbury School District 90162000280 540211 Buttonball Lane School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   83                                             83
2439561 2439561 CT     school 903510 1170011   Redding School District 90351000722 1170111 Redding Elementary School Public Schools Regular School No Elementary PK 04 2019   grade_4                                                   83                                             83
2439572 2439572 CT     school 903520 2100012   Regional School District 10 90352000729 2100212 Lake Garda Elementary School Regional Schools Regular School No Elementary PK 04 2019   grade_4                                                   83                                             83
2439751 2439751 CT     school 904440 1380011   Stratford School District 90444000898 1381311 Eli Whitney School Public Schools Regular School No Elementary KG 06 2019   grade_4                                                   83                                             83
2439757 2439757 CT     school 904440 1380011   Stratford School District 90444000892 1381511 Stratford Academy - Johnson House Public Schools Regular School No Elementary 02 06 2019   grade_4                                                   83                                             83
2439800 2439800 CT     school 904620 1440011   Trumbull School District 90462000934 1440311 Middlebrook School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   83                                             83
2439966 2439966 CT     school 905040 1580011   Westport School District 90504001055 1580511 King's Highway Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   83                                             83
2439452 2439452 CT     school 902880 940011   Newington School District 90288000606 940811 John Paterson School Public Schools Regular School No Elementary PK 04 2019   grade_4                                                   82                                             82
2439491 2439491 CT     school 903090 1030011   Norwalk School District 90309000651 1032211 Marvin Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   82                                             82
2439660 2439660 CT     school 904110 1280011   Simsbury School District 90411000814 1280711 Squadron Line School Public Schools Regular School No Elementary PK 06 2019   grade_4                                                   82                                             82
2439844 2439844 CT     school 904830 1510011   Waterbury School District 90483000972 1510911 Driggs School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   82                                             82
2439967 2439967 CT     school 905040 1580011   Westport School District 90504001056 1580711 Long Lots School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   82                                             82
2438685 2438685 CT     school 900210 70011   Berlin School District 90021000018 70411 Emma Hart Willard School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   81                                             81
2439169 2439169 CT     school 902010 670011   Hebron School District 90201000388 670111 Hebron Elementary School Public Schools Regular School No Elementary 03 06 2019   grade_4                                                   81                                             81
2439591 2439591 CT     school 903537 2150012   Regional School District 15 90353700708 2150712 Long Meadow Elementary School Regional Schools Regular School No Elementary PK 05 2019   grade_4                                                   81                                             81
2439645 2439645 CT     school 904050 1260011   Shelton School District 90405000796 1261011 Booth Hill School Public Schools Regular School No Elementary PK 04 2019   grade_4                                                   81                                             81
2439739 2439739 CT     school 904380 1370011   Stonington School District 90438000876 1370511 Deans Mill School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   81                                             81
2439797 2439797 CT     school 904620 1440011   Trumbull School District 90462000929 1440811 Daniels Farm School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   81                                             81
2439853 2439853 CT     school 904830 1510011   Waterbury School District 90483000986 1512011 Sprague School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   81                                             81
2439212 2439212 CT     school 902280 760011   Madison School District 90228000410 760111 J. Milton Jeffrey Elementary School Public Schools Regular School No Elementary KG 04 2019   grade_4                                                   80                                             80
2439557 2439557 CT     school 903480 1160011   Putnam School District 90348000718 1160311 Putnam Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   80                                             80
2439996 2439996 CT     school 905190 1630011   Windham School District 90519001214 1630311 North Windham School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   80                                             80
2438665 2438665 CT     school   2440014   Area Cooperative Educational Services 90007001499 2449514 Village School Program           2019   grade_4                                                   8                                             8
2438857 2438857 CT     school   2430014   Cooperative Educational Services 90091001573 2439414 Therapeutic Day Program Program           2019   grade_4                                                   8                                             8
2438925 2438925 CT     school   430011   East Hartford School District 90126000205 439011 Woodland School Program           2019   grade_4                                                   8                                             8
2439476 2439476 CT     school 903030 1010011   North Haven School District 90303000633 1010311 Ridge Road Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   79                                             79
2439795 2439795 CT     school 904620 1440011   Trumbull School District 90462000927 1440111 Booth Hill School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   79                                             79
2438837 2438837 CT     school 900750 250011   Cheshire School District 90075000126 250611 Doolittle School Public Schools Regular School No Elementary 01 06 2019   grade_4                                                   78                                             78
2438895 2438895 CT     school 901050 350011   Darien School District 90105000498 350711 Holmes Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   78                                             78
2439026 2439026 CT     school 901620 540011   Glastonbury School District 90162000286 540611 Hopewell School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   78                                             78
2439311 2439311 CT     school 902550 850011   Monroe School District 90255000491 850311 Stepney Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   78                                             78
2439450 2439450 CT     school 902880 940011   Newington School District 90288000611 940611 Anna Reynolds School Public Schools Regular School No Elementary PK 04 2019   grade_4                                                   78                                             78
2439672 2439672 CT     school 904170 1320011   South Windsor School District 90417000822 1320711 Eli Terry School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   78                                             78
2439692 2439692 CT     school 904230 1310011   Southington School District 90423000840 1310911 Thalberg Elementary School Public Schools Regular School No Elementary KG 05 2019   grade_4                                                   78                                             78
2439713 2439713 CT     school 904320 1350011   Stamford School District 90432000859 1350511 K. T. Murphy School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   78                                             78
2439809 2439809 CT     school 904680 1460011   Vernon School District 90468000939 1461411 Center Road School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   78                                             78
2438735 2438735 CT     school 900450 150011   Bridgeport School District 90045000090 153611 John Winthrop School Public Schools Regular School No Elementary PK 08 2019   grade_4                                                   77                                             77
2438748 2438748 CT     school 900450 150011   Bridgeport School District 90045000074 152011 Madison School Public Schools Regular School No Elementary KG 06 2019   grade_4                                                   77                                             77
2438764 2438764 CT     school 900510 170011   Bristol School District 90051000105 171111 South Side School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   77                                             77
2438894 2438894 CT     school 901050 350011   Darien School District 90105000172 350611 Tokeneke Elementary School Public Schools Regular School No Elementary PK 05 2019   grade_4                                                   77                                             77

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