Data source: Big Local News · About: Big Local

884 rows where grade = "grade_5", state = "MA" and year = 2020 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2020 · 884

grade

  • grade_5 · 884
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
1366047 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_5 0 4 4 0   0     0   0   6 2 *                     8.0 0 4 4 0   0     0   0   6 2                 8
1366103 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_5 58 2 4 0   28     0   2   46 48 *                     94.0 58 2 4 0   28     0   2   46 48                 94
1366584 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_5 1 0 38 0   0     0   1   17 23 *                     40.0 1 0 38 0   0     0   1   17 23                 40
1366797 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_5 78 0 2 0   1     0   7   42 46 *                     88.0 78 0 2 0   1     0   7   42 46                 88
1366824 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_5 29 7 14 1   4     0   2   26 31 *                     57.0 29 7 14 1   4     0   2   26 31                 57
1366829 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_5 51 4 2 0   1     0   3   36 25 *                     61.0 51 4 2 0   1     0   3   36 25                 61
1366834 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_5 40 5 8 0   1     0   5   28 31 *                     59.0 40 5 8 0   1     0   5   28 31                 59
1366839 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_5 20 3 10 0   1     0   0   15 19 *                     34.0 20 3 10 0   1     0   0   15 19                 34
1367969 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_5 4 1 131 0   3     0   0   84 54 *                     139.0 4 1 131 0   3     0   0   84 54                 139
1368012 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_5 1 0 98 0   0     0   0   55 44 *                     99.0 1 0 98 0   0     0   0   55 44                 99
1368017 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_5 3 0 84 0   1     0   0   50 37 *                     88.0 3 0 84 0   1     0   0   50 37                 88
1368030 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_5 1 0 56 0   0     0   0   30 26 *                     57.0 1 0 56 0   0     0   0   30 26                 57
1368527 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_5 3 9 62 0   7     0   2   44 39 *                     83.0 3 9 62 0   7     0   2   44 39                 83
1368557 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_5 3 0 5 0   0     0   0   7 * *                     8.0 3 0 5 0   0     0   0   7                   8
1368582 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2020   grade_5 4 11 48 0   2     0   8   35 38 *                     73.0 4 11 48 0   2     0   8   35 38                 73
1368987 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_5 96 2 2 0   2     0   14   75 41 *                     116.0 96 2 2 0   2     0   14   75 41                 116
1368992 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2020   grade_5 100 4 3 1   0     0   6   49 65 *                     114.0 100 4 3 1   0     0   6   49 65                 114
1369098 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Granite Valley School   Regular School No Elementary 01 06 2020   grade_5 67 3 1 0   0     1   3   35 39 *                     75.0 67 3 1 0   0     1   3   35 39                 75
1369559 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2020   grade_5 46 5 20 0   6     0   4   37 44 *                     81.0 46 5 20 0   6     0   4   37 44                 81
1369566 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary 01 05 2020   grade_5 62 3 5 1   11     0   2   53 31 *                     84.0 62 3 5 1   11     0   2   53 31                 84
1369571 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2020   grade_5 36 3 8 0   2     0   3   30 22 *                     52.0 36 3 8 0   2     0   3   30 22                 52
1369576 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2020   grade_5 85 3 5 1   7     0   3   57 47 *                     104.0 85 3 5 1   7     0   3   57 47                 104
1369581 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2020   grade_5 41 2 9 0   5     0   1   26 32 *                     58.0 41 2 9 0   5     0   1   26 32                 58
1369753 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_5 24 7 23 0   2     0   1   26 31 *                     57.0 24 7 23 0   2     0   1   26 31                 57
1369758 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2020   grade_5 30 5 5 0   0     0   1   24 17 *                     41.0 30 5 5 0   0     0   1   24 17                 41
1369763 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2020   grade_5 55 3 9 0   3     0   2   42 30 *                     72.0 55 3 9 0   3     0   2   42 30                 72
1369768 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2020   grade_5 31 4 5 0   2     0   1   22 21 *                     43.0 31 4 5 0   2     0   1   22 21                 43
1370777 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2020   grade_5 3 1 15 0   0     0   0   17 2 *                     19.0 3 1 15 0   0     0   0   17 2                 19
1371847 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary 01 05 2020   grade_5 65 4 17 0   4     0   1   56 35 *                     91.0 65 4 17 0   4     0   1   56 35                 91
1371852 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2020   grade_5 27 0 13 0   6     0   2   22 26 *                     48.0 27 0 13 0   6     0   2   22 26                 48
1371857 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2020   grade_5 24 2 8 0   1     0   0   16 19 *                     35.0 24 2 8 0   1     0   0   16 19                 35
1373781 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_5 10 0 1 0   0     0   0   6 5 *                     11.0 10 0 1 0   0     0   0   6 5                 11
1365881 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_5 18 14 11 0   4     0   0   26 21 *                     47.0 18 14 11 0   4     0   0   26 21                 47
1366862 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2020   grade_5 86 1 4 0   0     0   2   50 43 *                     93.0 86 1 4 0   0     0   2   50 43                 93
1367523 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_5 112 0 9 0   13     0   6   71 69 *                     140.0 112 0 9 0   13     0   6   71 69                 140
1367528 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_5 105 1 12 0   29     0   1   79 69 *                     148.0 105 1 12 0   29     0   1   79 69                 148
1367685 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_5 * * * *   *     *   *   4 * *                     5.0                         4                   5
1370745 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 02 05 2020   grade_5 30 1 44 0   1     0   1   41 36 *                     77.0 30 1 44 0   1     0   1   41 36                 77
1373054 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2020   grade_5 86 0 6 0   1     0   6   53 46 *                     99.0 86 0 6 0   1     0   6   53 46                 99
1373412 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2020   grade_5 46 0 5 0   0     0   4   30 25 *                     55.0 46 0 5 0   0     0   4   30 25                 55
1373809 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_5 31 0 1 0   0     0   0   9 23 *                     32.0 31 0 1 0   0     0   0   9 23                 32
1364986 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2020   grade_5 156 7 26 4   30     0   4   113 114 *                     227.0 156 7 26 4   30     0   4   113 114                 227
1365048 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_5 160 5 23 0   16     0   4   111 97 *                     208.0 160 5 23 0   16     0   4   111 97                 208
1365108 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2020   grade_5 141 13 9 0   43     0   7   105 108 *                     213.0 141 13 9 0   43     0   7   105 108                 213
1365666 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_5 37 35 48 0   5     0   1   63 63 *                     126.0 37 35 48 0   5     0   1   63 63                 126
1365834 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_5 0 19 14 0   1     0   3   24 13 *                     37.0 0 19 14 0   1     0   3   24 13                 37
1366063 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne Intermediate School   Regular School No Elementary 03 05 2020   grade_5 147 2 10 0   1     0   5   85 80 *                     165.0 147 2 10 0   1     0   5   85 80                 165
1366078 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2020   grade_5 84 1 2 0   6     0   3   54 42 *                     96.0 84 1 2 0   6     0   3   54 42                 96
1366133 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2020   grade_5 69 1 8 0   2     0   4   43 41 *                     84.0 69 1 8 0   2     0   4   43 41                 84
1366708 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2020   grade_5 107 5 1 0   3     0   6   61 61 *                     122.0 107 5 1 0   3     0   6   61 61                 122
1366911 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2020   grade_5 170 1 4 0   3     0   18   102 94 *                     196.0 170 1 4 0   3     0   18   102 94                 196
1366929 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W. Mitchell School   Regular School No Elementary 03 06 2020   grade_5 132 6 4 1   0     0   4   75 72 *                     147.0 132 6 4 1   0     0   4   75 72                 147
1366971 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2020   grade_5 73 7 14 0   6     0   4   61 42 *                     104.0 73 7 14 0   6     0   4   61 42                 104
1366978 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No Elementary 03 05 2020   grade_5 67 3 9 1   3     0   3   52 34 *                     86.0 67 3 9 1   3     0   3   52 34                 86
1367000 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson Olmsted School   Regular School No Elementary 03 05 2020   grade_5 230 24 19 0   9     1   9   150 142 *                     292.0 230 24 19 0   9     1   9   150 142                 292
1367777 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2020   grade_5 175 3 12 0   28     0   9   110 117 *                     227.0 175 3 12 0   28     0   9   110 117                 227
1367958 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2020   grade_5 137 3 5 1   0     0   1   76 71 *                     147.0 137 3 5 1   0     0   1   76 71                 147
1367979 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_5 4 0 74 0   1     0   0   33 46 *                     79.0 4 0 74 0   1     0   0   33 46                 79
1368238 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2020   grade_5 111 2 4 1   18     1   1   73 65 *                     138.0 111 2 4 1   18     1   1   73 65                 138
1368367 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_5 * * * *   *     *   *   1 * *                     1.0                         1                   1
1368448 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2020   grade_5 99 1 10 0   0     1   7   55 63 *                     118.0 99 1 10 0   0     1   7   55 63                 118
1368692 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No Elementary 03 05 2020   grade_5 204 15 8 0   20     0   11   138 120 *                     258.0 204 15 8 0   20     0   11   138 120                 258
1368705 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_5 183 9 16 0   5     0   9   125 97 *                     222.0 183 9 16 0   5     0   9   125 97                 222
1368799 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_5 86 2 8 8   2     0   11   56 61 *                     117.0 86 2 8 8   2     0   11   56 61                 117
1369009 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2020   grade_5 82 0 3 0   4     0   0   43 46 *                     89.0 82 0 3 0   4     0   0   43 46                 89
1369020 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2020   grade_5 199 11 93 8   4     1   17   180 153 *                     333.0 199 11 93 8   4     1   17   180 153                 333
1369124 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket Intermediate School   Regular School No Elementary 03 05 2020   grade_5 59 11 63 0   0     0   5   70 68 *                     138.0 59 11 63 0   0     0   5   70 68                 138
1369484 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2020   grade_5 105 0 6 0   4     0   1   63 53 *                     116.0 105 0 6 0   4     0   1   63 53                 116
1369797 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2020   grade_5 54 1 3 0   0     0   4   29 33 *                     62.0 54 1 3 0   0     0   4   29 33                 62
1370445 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_5 172 2 2 0   3     0   2   94 87 *                     181.0 172 2 2 0   3     0   2   94 87                 181
1370994 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield International Academy at Johnson   Regular School No Elementary 03 05 2020   grade_5 0 4 4 0   0     0   0   3 5 *                     8.0 0 4 4 0   0     0   0   3 5                 8
1371198 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2020   grade_5 96 2 2 0   3     0   3   56 50 *                     106.0 96 2 2 0   3     0   3   56 50                 106
1371233 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No Elementary 03 05 2020   grade_5 84 2 1 1   1     0   3   42 50 *                     92.0 84 2 1 1   1     0   3   42 50                 92
1371243 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Joseph G Luther   Regular School No Elementary 03 05 2020   grade_5 71 0 2 1   2     0   6   39 43 *                     82.0 71 0 2 1   2     0   6   39 43                 82
1371766 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2020   grade_5 99 1 1 0   27     0   6   65 69 *                     134.0 99 1 1 0   27     0   6   65 69                 134
1371769 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No Elementary 03 05 2020   grade_5 58 0 2 0   66     0   7   68 65 *                     133.0 58 0 2 0   66     0   7   68 65                 133
1371779 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2020   grade_5 74 1 3 0   40     0   4   53 69 *                     122.0 74 1 3 0   40     0   4   53 69                 122
1371827 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2020   grade_5 119 0 4 1   1     0   9   66 68 *                     134.0 119 0 4 1   1     0   9   66 68                 134
1372003 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Toy Town Elementary   Regular School No Elementary 03 05 2020   grade_5 73 2 7 0   3     0   0   52 33 *                     85.0 73 2 7 0   3     0   0   52 33                 85
1372060 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2020   grade_5 113 2 18 0   0     0   3   80 56 *                     136.0 113 2 18 0   0     0   3   80 56                 136
1373162 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_5 66 1 8 0   0     0   8   45 38 *                     83.0 66 1 8 0   0     0   8   45 38                 83
1373741 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No Elementary 03 06 2020   grade_5 43 0 5 0   0     0   3   27 24 *                     51.0 43 0 5 0   0     0   3   27 24                 51
1373871 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_5 111 1 7 1   1     0   6   70 57 *                     127.0 111 1 7 1   1     0   6   70 57                 127
1374004 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2020   grade_5 95 2 4 2   2     0   3   56 52 *                     108.0 95 2 4 2   2     0   3   56 52                 108
1365093 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2020   grade_5 269 35 72 2   6     0   26   220 190 *                     410.0 269 35 72 2   6     0   26   220 190                 410
1365119 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2020   grade_5 138 3 14 1   0     0   10   91 75 *                     166.0 138 3 14 1   0     0   10   91 75                 166
1365141 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2020   grade_5 142 5 11 0   2     0   4   78 86 *                     164.0 142 5 11 0   2     0   4   78 86                 164
1367709 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Tilton Upper Middle School   Regular School No Middle 04 06 2020   grade_5 10 1 19 0   3     0   1   21 13 *                     34.0 10 1 19 0   3     0   1   21 13                 34
1367813 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_5 4 1 51 0   1     0   0   30 27 *                     57.0 4 1 51 0   1     0   0   30 27                 57
1367885 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No Elementary 04 05 2020   grade_5 203 1 7 2   61     1   13   149 139 *                     288.0 203 1 7 2   61     1   13   149 139                 288
1368228 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_5 31 4 17 0   0     2   9   31 32 *                     63.0 31 4 17 0   0     2   9   31 32                 63
1368433 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2020   grade_5 136 3 22 0   3     0   7   75 96 *                     171.0 136 3 22 0   3     0   7   75 96                 171
1368811 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No Middle 04 06 2020   grade_5 51 0 2 0   1     0   1   26 29 *                     55.0 51 0 2 0   1     0   1   26 29                 55
1368819 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_5 64 2 11 1   2     0   8   43 45 *                     88.0 64 2 11 1   2     0   8   43 45                 88
1368831 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2020   grade_5 165 2 12 3   7     0   5   115 79 *                     194.0 165 2 12 3   7     0   5   115 79                 194
1369035 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Middle 04 06 2020   grade_5 110 8 6 0   10     1   9   70 74 *                     144.0 110 8 6 0   10     1   9   70 74                 144
1369342 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_5 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1369361 MA Essex   school 2508580 204   Newburyport 250858002624 2040030 Edward G. Molin Elementary School   Regular School No Elementary 04 05 2020   grade_5 134 1 7 0   3     0   1   70 76 *                     146.0 134 1 7 0   3     0   1   70 76                 146
1369719 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2020   grade_5 159 5 10 2   2     0   8   90 96 *                     186.0 159 5 10 2   2     0   8   90 96                 186
1370013 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2020   grade_5 73 5 6 0   4     0   1   43 46 *                     89.0 73 5 6 0   4     0   1   43 46                 89

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