Data source: Big Local News · About: Big Local

889 rows where grade = "grade_5", state = "MA" and year = 2021 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2021 · 889

grade

  • grade_5 · 889
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
1673282 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673337 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree - Liberty   Regular School No Elementary 01 05 2021   grade_5 55 1 4 0   35     1   3   47 52 *                     99.0 55 1 4 0   35     1   3   47 52                 99
1673815 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_5 2 1 27 0   0     0   0   14 16 *                     30.0 2 1 27 0   0     0   0   14 16                 30
1674026 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth - Joseph Demello   Regular School No Elementary 01 05 2021   grade_5 62 0 5 0   1     0   4   35 37 *                     72.0 62 0 5 0   1     0   4   35 37                 72
1674053 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham - Avery   Regular School No Elementary 01 05 2021   grade_5 23 7 19 0   2     0   4   24 31 *                     55.0 23 7 19 0   2     0   4   24 31                 55
1674058 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham - Greenlodge   Regular School No Elementary 01 05 2021   grade_5 28 3 3 0   1     0   0   19 16 *                     35.0 28 3 3 0   1     0   0   19 16                 35
1674063 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Dedham - Oakdale   Regular School No Elementary 01 05 2021   grade_5 35 3 7 0   0     0   4   17 32 *                     49.0 35 3 7 0   0     0   4   17 32                 49
1674068 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Dedham - Riverdale   Regular School No Elementary 01 05 2021   grade_5 25 3 2 0   0     0   2   13 19 *                     32.0 25 3 2 0   0     0   2   13 19                 32
1674429 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_5 6 0 0 0   0     0   1   6 1 *                     7.0 6 0 0 0   0     0   1   6 1                 7
1675214 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_5 3 2 143 0   0     0   0   80 68 *                     148.0 3 2 143 0   0     0   0   80 68                 148
1675257 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence - Francis M Leahy   Regular School No Elementary 01 05 2021   grade_5 6 1 94 0   0     0   0   49 52 *                     101.0 6 1 94 0   0     0   0   49 52                 101
1675262 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_5 2 0 86 0   0     0   0   46 42 *                     88.0 2 0 86 0   0     0   0   46 42                 88
1675275 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_5 0 0 63 0   0     0   0   40 23 *                     63.0 0 0 63 0   0     0   0   40 23                 63
1675769 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn - Robert L Ford   Regular School No Elementary 01 05 2021   grade_5 6 6 88 1   9     0   2   59 53 *                     112.0 6 6 88 1   9     0   2   59 53                 112
1675799 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_5 2 1 3 0   1     0   1   7 * *                     8.0 2 1 3 0   1     0   1   7                   8
1675823 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Lynn - Tracy   Regular School No Elementary 01 05 2021   grade_5 4 8 64 0   5     0   1   38 44 *                     82.0 4 8 64 0   5     0   1   38 44                 82
1676235 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_5 95 1 3 0   0     0   8   58 49 *                     107.0 95 1 3 0   0     0   8   58 49                 107
1676240 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_5 96 2 2 0   0     0   8   56 52 *                     108.0 96 2 2 0   0     0   8   56 52                 108
1676345 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_5 62 1 7 0   0     0   3   32 41 *                     73.0 62 1 7 0   0     0   3   32 41                 73
1676806 MA Essex   school 2508700 211   North Andover 250870001393 2110001 North Andover - Atkinson   Regular School No Elementary 01 05 2021   grade_5 43 4 17 0   2     0   1   32 35 *                     67.0 43 4 17 0   2     0   1   32 35                 67
1676813 MA Essex   school 2508700 211   North Andover 250870001395 2110010 North Andover - Franklin   Regular School No Elementary 01 05 2021   grade_5 53 1 9 0   12     0   2   40 37 *                     77.0 53 1 9 0   12     0   2   40 37                 77
1676818 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_5 37 0 6 0   2     0   1   28 18 *                     46.0 37 0 6 0   2     0   1   28 18                 46
1676823 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover - Annie L Sargent School   Regular School No Elementary 01 05 2021   grade_5 74 0 3 0   5     0   5   32 55 *                     87.0 74 0 3 0   5     0   5   32 55                 87
1676828 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover - Thomson   Regular School No Elementary 01 05 2021   grade_5 53 0 10 0   2     0   3   37 31 *                     68.0 53 0 10 0   2     0   3   37 31                 68
1677000 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Norwood - Balch   Regular School No Elementary 01 05 2021   grade_5 21 8 20 0   1     0   1   23 28 *                     51.0 21 8 20 0   1     0   1   23 28                 51
1677005 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Norwood - Cornelius M Callahan   Regular School No Elementary 01 05 2021   grade_5 20 6 2 0   3     0   3   19 15 *                     34.0 20 6 2 0   3     0   3   19 15                 34
1677010 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 Norwood - F A Cleveland   Regular School No Elementary 01 05 2021   grade_5 58 4 7 0   6     0   4   39 40 *                     79.0 58 4 7 0   6     0   4   39 40                 79
1677015 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 Norwood - John P Oldham   Regular School No Elementary 01 05 2021   grade_5 34 8 10 0   5     0   0   25 32 *                     57.0 34 8 10 0   5     0   0   25 32                 57
1678033 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_5 1 2 8 0   0     0   0   10 1 *                     11.0 1 2 8 0   0     0   0   10 1                 11
1679101 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield - John R Fausey   Regular School No Elementary 01 05 2021   grade_5 77 1 12 0   3     0   5   51 47 *                     98.0 77 1 12 0   3     0   5   51 47                 98
1679106 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield - Memorial   Regular School No Elementary 01 05 2021   grade_5 19 2 13 0   8     0   1   20 23 *                     43.0 19 2 13 0   8     0   1   20 23                 43
1679111 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield - Mittineague   Regular School No Elementary 01 05 2021   grade_5 19 1 9 0   3     0   2   16 18 *                     34.0 19 1 9 0   3     0   2   16 18                 34
1673118 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_5 16 17 6 1   5     0   2   23 24 *                     47.0 16 17 6 1   5     0   2   23 24                 47
1673451 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_5 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674091 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas - Douglas Elementary School   Regular School No Elementary 02 05 2021   grade_5 84 0 8 0   1     0   2   47 48 *                     95.0 84 0 8 0   1     0   2   47 48                 95
1674773 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_5 88 0 4 0   12     1   7   58 54 *                     112.0 88 0 4 0   12     1   7   58 54                 112
1674778 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton - Millbury Street Elementary School   Regular School No Elementary 02 06 2021   grade_5 98 4 7 0   21     0   2   72 60 *                     132.0 98 4 7 0   21     0   2   72 60                 132
1677997 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 Southbridge - West Street   Regular School No Elementary 02 05 2021   grade_5 24 0 34 0   1     0   2   26 35 *                     61.0 24 0 34 0   1     0   2   26 35                 61
1680318 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster - Westminster Elementary   Regular School No Elementary 02 05 2021   grade_5 97 2 4 0   0     0   1   55 49 *                     104.0 97 2 4 0   0     0   1   55 49                 104
1680677 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Gill-Montague - Sheffield Elementary School   Regular School No Elementary 02 05 2021   grade_5 46 0 7 0   0     0   3   26 29 *                     56.0 46 0 7 0   0     0   3   26 29                 56
1681058 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin - Oakham Center   Regular School No Elementary 02 06 2021   grade_5 18 1 2 0   1     0   1   5 18 *                     23.0 18 1 2 0   1     0   1   5 18                 23
1672209 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland - David Mindess   Regular School No Elementary 03 05 2021   grade_5 131 5 32 0   33     0   7   105 103 *                     208.0 131 5 32 0   33     0   7   105 103                 208
1672271 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Auburn - Swanson Road Intermediate School   Regular School No Elementary 03 05 2021   grade_5 160 4 22 0   3     0   6   102 93 *                     195.0 160 4 22 0   3     0   6   102 93                 195
1672332 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford - Lt Job Lane School   Regular School No Elementary 03 05 2021   grade_5 117 13 12 0   41     0   16   104 95 *                     199.0 117 13 12 0   41     0   16   104 95                 199
1672899 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_5 36 29 21 0   4     0   4   43 51 *                     94.0 36 29 21 0   4     0   4   43 51                 94
1673071 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_5 0 9 14 0   0     0   0   10 13 *                     23.0 0 9 14 0   0     0   0   10 13                 23
1673299 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne - Bourne Intermediate School   Regular School No Elementary 03 05 2021   grade_5 126 5 15 1   2     0   6   69 86 *                     155.0 126 5 15 1   2     0   6   69 86                 155
1673314 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford - Spofford Pond   Regular School No Elementary 03 06 2021   grade_5 98 2 3 0   4     0   4   57 54 *                     111.0 98 2 3 0   4     0   4   57 54                 111
1673366 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster - Eddy Elementary   Regular School No Elementary 03 05 2021   grade_5 64 3 5 0   0     0   4   40 36 *                     76.0 64 3 5 0   0     0   4   40 36                 76
1673936 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Cohasset - Deer Hill   Regular School No Elementary 03 05 2021   grade_5 88 2 1 0   3     0   0   47 47 *                     94.0 88 2 1 0   3     0   0   47 47                 94
1674141 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Duxbury - Alden School   Regular School No Elementary 03 05 2021   grade_5 201 2 8 0   0     0   6   108 109 *                     217.0 201 2 8 0   0     0   6   108 109                 217
1674159 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater - Gordon W. Mitchell School   Regular School No Elementary 03 06 2021   grade_5 139 9 5 1   3     0   7   90 74 *                     164.0 139 9 5 1   3     0   7   90 74                 164
1674201 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 East Longmeadow - Mapleshade   Regular School No Elementary 03 05 2021   grade_5 70 1 13 0   7     0   5   50 46 *                     96.0 70 1 13 0   7     0   5   50 46                 96
1674208 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 East Longmeadow - Mountain View   Regular School No Elementary 03 05 2021   grade_5 69 4 9 0   6     0   4   48 44 *                     92.0 69 4 9 0   6     0   4   48 44                 92
1674229 MA Bristol   school 2504620 88   Easton 250462000983 880025 Easton - Richardson Olmsted School   Regular School No Elementary 03 05 2021   grade_5 213 19 16 2   6     0   15   150 121 *                     271.0 213 19 16 2   6     0   15   150 121                 271
1675022 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Holliston - Miller School   Regular School No Elementary 03 05 2021   grade_5 178 4 11 1   26     0   9   126 103 *                     229.0 178 4 11 1   26     0   9   126 103                 229
1675203 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston - Kingston Intermediate   Regular School No Elementary 03 06 2021   grade_5 156 0 5 1   0     0   0   89 73 *                     162.0 156 0 5 1   0     0   0   89 73                 162
1675224 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_5 1 0 72 0   2     0   0   38 36 *                     75.0 1 0 72 0   2     0   0   38 36                 75
1675483 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Littleton - Russell St Elementary   Regular School No Elementary 03 05 2021   grade_5 103 1 4 0   16     0   3   62 65 *                     127.0 103 1 4 0   16     0   3   62 65                 127
1675612 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_5 * * * *   *     *   *   1 * *                     2.0                         1                   2
1675689 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Lunenburg - Turkey Hill Elementary School   Regular School No Elementary 03 05 2021   grade_5 99 4 13 0   6     0   1   67 56 *                     123.0 99 4 13 0   6     0   1   67 56                 123
1675933 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Mansfield - Jordan/Jackson Elementary   Regular School No Elementary 03 05 2021   grade_5 191 11 22 0   27     0   17   155 113 *                     268.0 191 11 22 0   27     0   17   155 113                 268
1675946 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead - Village School   Regular School No Elementary 03 06 2021   grade_5 155 5 17 0   0     0   13   101 89 *                     190.0 155 5 17 0   0     0   13   101 89                 190
1676049 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_5 82 7 10 8   1     0   11   57 62 *                     119.0 82 7 10 8   1     0   11   57 62                 119
1676257 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton - Howe-Manning   Regular School No Elementary 03 06 2021   grade_5 67 1 5 0   2     1   5   41 40 *                     81.0 67 1 5 0   2     1   5   41 40                 81
1676268 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford - Woodland   Regular School No Elementary 03 05 2021   grade_5 194 11 103 3   7     0   14   171 161 *                     332.0 194 11 103 3   7     0   14   171 161                 332
1676371 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket - Nantucket Intermediate School   Regular School No Elementary 03 05 2021   grade_5 68 9 34 0   2     0   4   70 47 *                     117.0 68 9 34 0   2     0   4   70 47                 117
1676733 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk - Freeman-Kennedy School   Regular School No Elementary 03 06 2021   grade_5 131 0 7 0   2     0   4   80 64 *                     144.0 131 0 7 0   2     0   4   80 64                 144
1677044 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Orange - Dexter Park   Regular School No Elementary 03 06 2021   grade_5 60 0 7 0   1     0   2   32 38 *                     70.0 60 0 7 0   1     0   2   32 38                 70
1677696 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich - Oak Ridge   Regular School No Elementary 03 06 2021   grade_5 173 2 8 0   7     2   0   99 93 *                     192.0 173 2 8 0   7     2   0   99 93                 192
1678251 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield - Springfield International Academy at Johnson   Regular School No Elementary 03 05 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1678457 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton - Sutton Elementary   Regular School No Elementary 03 05 2021   grade_5 101 0 3 0   1     0   4   56 53 *                     109.0 101 0 3 0   1     0   4   56 53                 109
1678491 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Swansea - Elizabeth S Brown   Regular School No Elementary 03 05 2021   grade_5 90 0 2 0   0     0   0   47 45 *                     92.0 90 0 2 0   0     0   0   47 45                 92
1678501 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Swansea - Joseph G Luther   Regular School No Elementary 03 05 2021   grade_5 47 1 3 0   1     0   0   25 27 *                     52.0 47 1 3 0   1     0   0   25 27                 52
1679017 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Westford - Abbot Elementary   Regular School No Elementary 03 05 2021   grade_5 94 0 1 0   38     0   5   63 75 *                     138.0 94 0 1 0   38     0   5   63 75                 138
1679020 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Westford - Day Elementary   Regular School No Elementary 03 05 2021   grade_5 62 4 5 0   44     0   10   53 72 *                     125.0 62 4 5 0   44     0   10   53 72                 125
1679031 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 Westford - John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2021   grade_5 70 2 7 0   37     0   4   64 56 *                     120.0 70 2 7 0   37     0   4   64 56                 120
1679080 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport - Westport Elementary   Regular School No Elementary 03 06 2021   grade_5 113 1 6 0   0     0   3   76 47 *                     123.0 113 1 6 0   0     0   3   76 47                 123
1679263 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Winchendon - Toy Town Elementary   Regular School No Elementary 03 05 2021   grade_5 73 1 8 0   1     0   4   51 35 *                     87.0 73 1 8 0   1     0   4   51 35                 87
1679320 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Winthrop - Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2021   grade_5 102 2 23 0   0     0   3   65 65 *                     130.0 102 2 23 0   0     0   3   65 65                 130
1680425 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 Blackstone-Millville - A F Maloney   Regular School No Elementary 03 05 2021   grade_5 96 0 10 0   1     0   6   67 46 *                     113.0 96 0 10 0   1     0   6   67 46                 113
1680998 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Pentucket - Helen R Donaghue School   Regular School No Elementary 03 06 2021   grade_5 63 0 4 0   0     0   1   35 33 *                     68.0 63 0 4 0   0     0   1   35 33                 68
1681119 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District - Powder Mill School   Regular School No Elementary 03 06 2021   grade_5 107 2 3 0   0     0   0   55 57 *                     112.0 107 2 3 0   0     0   0   55 57                 112
1681252 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett - Glenwood Elementary School   Regular School No Elementary 03 05 2021   grade_5 112 4 10 1   1     0   3   59 72 *                     131.0 112 4 10 1   1     0   3   59 72                 131
1672317 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable - Barnstable United Elementary School   Regular School No Elementary 04 05 2021   grade_5 226 30 80 1   9     0   18   192 171 *                     364.0 226 30 80 1   9     0   18   192 171                 364
1672343 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Belchertown - Chestnut Hill Community School   Regular School No Middle 04 06 2021   grade_5 135 3 13 2   3     0   5   88 73 *                     161.0 135 3 13 2   3     0   5   88 73                 161
1672364 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham - Bellingham Memorial School   Regular School No Middle 04 07 2021   grade_5 126 4 7 0   3     0   3   74 69 *                     143.0 126 4 7 0   3     0   3   74 69                 143
1674954 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Haverhill - Tilton Upper Middle School   Regular School No Middle 04 06 2021   grade_5 36 4 53 0   0     0   0   43 50 *                     93.0 36 4 53 0   0     0   0   43 50                 93
1675059 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke - William R. Peck School   Regular School No Middle 04 08 2021   grade_5 2 1 38 0   0     0   0   23 18 *                     41.0 2 1 38 0   0     0   0   23 18                 41
1675130 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkinton - Hopkins Elementary School   Regular School No Elementary 04 05 2021   grade_5 190 1 10 1   82     0   13   145 152 *                     297.0 190 1 10 1   82     0   13   145 152                 297
1675473 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_5 24 4 13 0   1     0   3   18 27 *                     45.0 24 4 13 0   1     0   3   18 27                 45
1675675 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Ludlow - Veterans Park Elementary   Regular School No Elementary 04 05 2021   grade_5 128 3 28 0   1     1   7   78 90 *                     168.0 128 3 28 0   1     1   7   78 90                 168
1676061 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Mattapoisett - Old Hammondtown   Regular School No Middle 04 06 2021   grade_5 51 1 4 0   1     0   4   32 29 *                     61.0 51 1 4 0   1     0   4   32 29                 61
1676069 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard - Fowler School   Regular School No Middle 04 08 2021   grade_5 76 0 15 0   1     0   4   46 50 *                     96.0 76 0 15 0   1     0   4   46 50                 96
1676082 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Medfield - Dale Street   Regular School No Elementary 04 05 2021   grade_5 181 5 6 0   13     0   6   105 106 *                     211.0 181 5 6 0   13     0   6   105 106                 211
1676283 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Millbury - Raymond E. Shaw Elementary   Regular School No Middle 04 06 2021   grade_5 104 2 8 0   1     0   2   70 47 *                     117.0 104 2 8 0   1     0   2   70 47                 117
1676590 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_5 4 1 7 0   0     0   0   10 2 *                     12.0 4 1 7 0   0     0   0   10 2                 12
1676610 MA Essex   school 2508580 204   Newburyport 250858002624 2040030 Newburyport - Edward G. Molin Elementary School   Regular School No Elementary 04 05 2021   grade_5 135 1 10 0   0     0   1   77 70 *                     147.0 135 1 10 0   0     0   1   77 70                 147
1676966 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Norton - Henri A. Yelle   Regular School No Elementary 04 05 2021   grade_5 152 1 6 0   3     1   9   93 79 *                     172.0 152 1 6 0   3     1   9   93 79                 172
1677261 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Plainville - Beatrice H Wood Elementary   Regular School No Middle 04 06 2021   grade_5 68 6 9 0   1     0   4   50 38 *                     88.0 68 6 9 0   1     0   4   50 38                 88

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