enrollments

Data source: Big Local News · About: Big Local

954 rows where grade = "grade_4", state = "MA" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 954 ✖

grade ✖

  • grade_4 · 954 ✖
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
2043625 2043625 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 05 2019   grade_4 2 0 8 0   0     0   0   9 1                       10.0 2 0 8 0   0     0   0   9 1                 10
2045459 2045459 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_4 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2045565 2045565 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2019   grade_4 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
2048847 2048847 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   grade_4 8 0 1 0   0     0   1   4 6                       10.0 8 0 1 0   0     0   1   4 6                 10
2042319 2042319 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2019   grade_4 38 4 48 0   2     1   7   53 47                       100.0 38 4 48 0   2     1   7   53 47                 100
2043365 2043365 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2019   grade_4 40 5 20 0   29     0   6   56 44                       100.0 40 5 20 0   29     0   6   56 44                 100
2043401 2043401 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_4 11 5 36 0   45     0   3   51 49                       100.0 11 5 36 0   45     0   3   51 49                 100
2043413 2043413 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2019   grade_4 20 5 13 0   59     0   3   49 51                       100.0 20 5 13 0   59     0   3   49 51                 100
2044224 2044224 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No Elementary KG 04 2019   grade_4 88 0 5 0   2     0   5   56 44                       100.0 88 0 5 0   2     0   5   56 44                 100
2044648 2044648 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_4 83 2 5 1   6     0   3   56 44                       100.0 83 2 5 1   6     0   3   56 44                 100
2046338 2046338 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2019   grade_4 74 13 6 1   2     0   4   44 56                       100.0 74 13 6 1   2     0   4   44 56                 100
2048695 2048695 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2019   grade_4 85 1 6 0   0     1   7   48 52                       100.0 85 1 6 0   0     1   7   48 52                 100
2040031 2040031 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2019   grade_4 64 8 16 0   3     0   10   53 48                       101.0 64 8 16 0   3     0   10   53 48                 101
2042041 2042041 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2019   grade_4 70 7 15 0   6     0   3   59 42                       101.0 70 7 15 0   6     0   3   59 42                 101
2043449 2043449 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2019   grade_4 15 2 33 0   45     0   6   60 41                       101.0 15 2 33 0   45     0   6   60 41                 101
2043714 2043714 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_4 27 18 38 0   14     0   4   48 53                       101.0 27 18 38 0   14     0   4   48 53                 101
2040378 2040378 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_4 28 21 48 0   3     0   2   44 58                       102.0 28 21 48 0   3     0   2   44 58                 102
2043705 2043705 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_4 33 22 13 0   29     0   5   52 50                       102.0 33 22 13 0   29     0   5   52 50                 102
2045626 2045626 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No Elementary KG 05 2019   grade_4 51 6 4 1   28     1   11   54 48                       102.0 51 6 4 1   28     1   11   54 48                 102
2044120 2044120 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 04 2019   grade_4 91 1 5 0   1     0   5   50 53                       103.0 91 1 5 0   1     0   5   50 53                 103
2039830 2039830 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_4 95 0 7 0   0     0   2   48 56                       104.0 95 0 7 0   0     0   2   48 56                 104
2043254 2043254 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2019   grade_4 44 7 5 0   48     0   0   55 49                       104.0 44 7 5 0   48     0   0   55 49                 104
2044024 2044024 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   grade_4 49 2 45 0   2     0   6   45 59                       104.0 49 2 45 0   2     0   6   45 59                 104
2046395 2046395 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Louise Davy Trahan   Regular School No Elementary 03 04 2019   grade_4 91 3 7 0   0     0   3   49 55                       104.0 91 3 7 0   0     0   3   49 55                 104
2048719 2048719 MA Middlesex   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2019   grade_4 87 2 4 0   7     0   4   50 54                       104.0 87 2 4 0   7     0   4   50 54                 104
2040702 2040702 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_4 2 59 41 0   1     0   2   49 56                       105.0 2 59 41 0   1     0   2   49 56                 105
2041621 2041621 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2019   grade_4 71 5 6 0   19     0   4   63 42                       105.0 71 5 6 0   19     0   4   63 42                 105
2041626 2041626 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2019   grade_4 77 0 9 1   10     0   8   52 53                       105.0 77 0 9 1   10     0   8   52 53                 105
2043208 2043208 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2019   grade_4 46 6 44 0   2     0   7   52 53                       105.0 46 6 44 0   2     0   7   52 53                 105
2043424 2043424 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary KG 05 2019   grade_4 49 5 40 0   7     0   4   65 40                       105.0 49 5 40 0   7     0   4   65 40                 105
2045676 2045676 MA Worcester   school 2510770 271   Shrewsbury 251077001718 2710035 Spring Street   Regular School No Elementary KG 04 2019   grade_4 60 4 12 0   24     0   5   54 51                       105.0 60 4 12 0   24     0   5   54 51                 105
2039916 2039916 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2019   grade_4 79 4 6 0   12     0   5   54 52                       106.0 79 4 6 0   12     0   5   54 52                 106
2041396 2041396 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   grade_4 48 1 13 0   35     0   9   56 50                       106.0 48 1 13 0   35     0   9   56 50                 106
2043272 2043272 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Fiske   Regular School No Elementary KG 05 2019   grade_4 54 6 7 0   33     0   6   56 50                       106.0 54 6 7 0   33     0   6   56 50                 106
2043419 2043419 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No Elementary PK 04 2019   grade_4 38 9 27 0   27     0   5   60 46                       106.0 38 9 27 0   27     0   5   60 46                 106
2044367 2044367 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2019   grade_4 69 9 20 0   0     0   8   53 53                       106.0 69 9 20 0   0     0   8   53 53                 106
2046273 2046273 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2019   grade_4 95 2 2 0   3     0   4   55 51                       106.0 95 2 2 0   3     0   4   55 51                 106
2048107 2048107 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_4 90 6 4 0   1     1   4   55 51                       106.0 90 6 4 0   1     1   4   55 51                 106
2042146 2042146 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_4 25 14 57 0   8     0   3   55 52                       107.0 25 14 57 0   8     0   3   55 52                 107
2042155 2042155 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_4 21 16 66 0   1     0   3   50 57                       107.0 21 16 66 0   1     0   3   50 57                 107
2043169 2043169 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2019   grade_4 86 5 8 2   3     0   3   56 51                       107.0 86 5 8 2   3     0   3   56 51                 107
2043370 2043370 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 07 2019   grade_4 26 9 39 0   27     0   6   47 60                       107.0 26 9 39 0   27     0   6   47 60                 107
2043732 2043732 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_4 44 21 20 0   19     0   3   59 48                       107.0 44 21 20 0   19     0   3   59 48                 107
2048332 2048332 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary PK 04 2019   grade_4 95 2 5 0   2     0   3   47 60                       107.0 95 2 5 0   2     0   3   47 60                 107
2041239 2041239 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2019   grade_4 17 72 7 0   2     0   10   58 50                       108.0 17 72 7 0   2     0   10   58 50                 108
2042205 2042205 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2019   grade_4 43 8 38 1   5     0   13   53 55                       108.0 43 8 38 1   5     0   13   53 55                 108
2044347 2044347 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2019   grade_4 51 8 39 1   0     0   9   57 51                       108.0 51 8 39 1   0     0   9   57 51                 108
2045202 2045202 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2019   grade_4 27 12 15 0   47     5   2   48 60                       108.0 27 12 15 0   47     5   2   48 60                 108
2048623 2048623 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2019   grade_4 90 3 7 1   0     0   7   52 56                       108.0 90 3 7 1   0     0   7   52 56                 108
2040405 2040405 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_4 1 91 11 1   2     0   3   60 49                       109.0 1 91 11 1   2     0   3   60 49                 109
2041233 2041233 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2019   grade_4 22 64 13 0   3     1   6   55 54                       109.0 22 64 13 0   3     1   6   55 54                 109
2047062 2047062 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 West Intermediate   Regular School No Elementary 04 05 2019   grade_4 88 2 10 0   5     0   4   54 55                       109.0 88 2 10 0   5     0   4   54 55                 109
2049077 2049077 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2019   grade_4 97 2 3 2   1     0   4   56 53                       109.0 97 2 3 2   1     0   4   56 53                 109
2048392 2048392 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_4 11 0 0 0   0     0   0   7 4                       11.0 11 0 0 0   0     0   0   7 4                 11
2049019 2049019 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2019   grade_4 8 0 1 0   0     0   2   6 5                       11.0 8 0 1 0   0     0   2   6 5                 11
2043807 2043807 MA Middlesex   school 2507320 170   Marlborough 250732001135 1700025 Richer   Regular School No Elementary KG 04 2019   grade_4 40 4 60 0   0     0   6   56 54                       110.0 40 4 60 0   0     0   6   56 54                 110
2047988 2047988 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_4 91 5 7 0   2     0   5   46 64                       110.0 91 5 7 0   2     0   5   46 64                 110
2049132 2049132 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2019   grade_4 99 0 6 0   2     0   3   58 52                       110.0 99 0 6 0   2     0   3   58 52                 110
2040522 2040522 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_4 28 28 35 0   15     0   5   60 51                       111.0 28 28 35 0   15     0   5   60 51                 111
2041220 2041220 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2019   grade_4 27 51 23 1   1     1   7   56 55                       111.0 27 51 23 1   1     1   7   56 55                 111
2041245 2041245 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_4 11 76 15 0   1     2   6   51 60                       111.0 11 76 15 0   1     2   6   51 60                 111
2044062 2044062 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2019   grade_4 102 4 2 1   0     0   2   48 63                       111.0 102 4 2 1   0     0   2   48 63                 111
2048774 2048774 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2019   grade_4 101 1 4 0   2     0   3   55 56                       111.0 101 1 4 0   2     0   3   55 56                 111
2041283 2041283 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2019   grade_4 13 72 19 0   0     1   7   53 59                       112.0 13 72 19 0   0     1   7   53 59                 112
2041712 2041712 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2019   grade_4 60 8 41 0   0     0   3   61 51                       112.0 60 8 41 0   0     0   3   61 51                 112
2043938 2043938 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2019   grade_4 70 14 14 0   10     0   4   57 55                       112.0 70 14 14 0   10     0   4   57 55                 112
2044057 2044057 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2019   grade_4 98 2 1 0   2     1   9   73 40                       113.0 98 2 1 0   2     1   9   73 40                 113
2045135 2045135 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2019   grade_4 101 4 4 0   0     0   4   65 48                       113.0 101 4 4 0   0     0   4   65 48                 113
2043202 2043202 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2019   grade_4 65 7 36 0   1     0   5   59 55                       114.0 65 7 36 0   1     0   5   59 55                 114
2039941 2039941 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_4 88 1 5 0   16     0   5   53 62                       115.0 88 1 5 0   16     0   5   53 62                 115
2041339 2041339 MA Middlesex   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2019   grade_4 55 7 8 0   38     0   7   61 54                       115.0 55 7 8 0   38     0   7   61 54                 115
2041879 2041879 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2019   grade_4 97 2 9 0   1     0   6   61 54                       115.0 97 2 9 0   1     0   6   61 54                 115
2043530 2043530 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2019   grade_4 98 0 11 0   0     1   5   57 58                       115.0 98 0 11 0   0     1   5   57 58                 115
2046433 2046433 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2019   grade_4 95 6 3 0   8     0   3   64 51                       115.0 95 6 3 0   8     0   3   64 51                 115
2040887 2040887 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_4 4 74 33 1   1     0   3   61 55                       116.0 4 74 33 1   1     0   3   61 55                 116
2043869 2043869 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_4 86 2 8 8   1     0   11   53 63                       116.0 86 2 8 8   1     0   11   53 63                 116
2047734 2047734 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_4 23 65 19 0   3     0   6   64 52                       116.0 23 65 19 0   3     0   6   64 52                 116
2047910 2047910 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2019   grade_4 2 86 26 0   0     0   2   58 58                       116.0 2 86 26 0   0     0   2   58 58                 116
2048453 2048453 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2019   grade_4 96 2 2 0   12     1   3   55 61                       116.0 96 2 2 0   12     1   3   55 61                 116
2041214 2041214 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   grade_4 8 76 23 1   0     0   9   62 55                       117.0 8 76 23 1   0     0   9   62 55                 117
2042198 2042198 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2019   grade_4 51 7 41 0   7     0   11   61 56                       117.0 51 7 41 0   7     0   11   61 56                 117
2043609 2043609 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2019   grade_4 3 19 86 0   5     1   3   55 62                       117.0 3 19 86 0   5     1   3   55 62                 117
2041596 2041596 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2019   grade_4 111 4 1 1   1     0   0   52 66                       118.0 111 4 1 1   1     0   0   52 66                 118
2044556 2044556 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2019   grade_4 106 0 7 0   4     0   1   65 53                       118.0 106 0 7 0   4     0   1   65 53                 118
2045916 2045916 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2019   grade_4 7 34 75 0   0     0   2   59 59                       118.0 7 34 75 0   0     0   2   59 59                 118
2044204 2044204 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2019   grade_4 87 2 4 1   18     1   6   67 52                       119.0 87 2 4 1   18     1   6   67 52                 119
2046229 2046229 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_4 99 2 8 2   2     0   6   68 51                       119.0 99 2 8 2   2     0   6   68 51                 119
2048942 2048942 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_4 105 1 6 1   1     0   5   63 56                       119.0 105 1 6 1   1     0   5   63 56                 119
2040419 2040419 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_4 4 0 8 0   0     0   0   7 5                       12.0 4 0 8 0   0     0   0   7 5                 12
2046426 2046426 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2019   grade_4 9 0 1 0   0     0   2   9 3                       12.0 9 0 1 0   0     0   2   9 3                 12
2040200 2040200 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2019   grade_4 98 2 0 0   14     0   6   63 57                       120.0 98 2 0 0   14     0   6   63 57                 120
2040752 2040752 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   grade_4 13 20 17 0   67     0   3   55 65                       120.0 13 20 17 0   67     0   3   55 65                 120
2046354 2046354 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No Elementary KG 04 2019   grade_4 67 21 22 0   2     0   8   68 52                       120.0 67 21 22 0   2     0   8   68 52                 120
2046852 2046852 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2019   grade_4 69 4 4 0   39     0   4   53 67                       120.0 69 4 4 0   39     0   4   53 67                 120
2045129 2045129 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2019   grade_4 102 1 4 0   2     0   12   63 58                       121.0 102 1 4 0   2     0   12   63 58                 121
2040562 2040562 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2019   grade_4 0 61 56 0   3     1   1   57 65                       122.0 0 61 56 0   3     1   1   57 65                 122
2042424 2042424 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   grade_4 36 4 79 0   1     0   2   50 72                       122.0 36 4 79 0   1     0   2   50 72                 122
2042758 2042758 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2019   grade_4 71 5 41 1   2     0   2   68 54                       122.0 71 5 41 1   2     0   2   68 54                 122
2044133 2044133 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2019   grade_4 109 3 2 0   5     0   3   67 55                       122.0 109 3 2 0   5     0   3   67 55                 122
2041777 2041777 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2019   grade_4 107 6 1 0   3     0   6   61 62                       123.0 107 6 1 0   3     0   6   61 62                 123

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