enrollments

Data source: Big Local News · About: Big Local

950 rows where grade = "grade_4", state = "MA" and year = 2020 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 950 ✖

grade ✖

  • grade_4 · 950 ✖
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
1366046 1366046 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_4 0 2 4 0   0     0   0   3 3 *                     6.0 0 2 4 0   0     0   0   3 3                 6
1366102 1366102 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_4 52 0 2 0   25     1   3   37 46 *                     83.0 52 0 2 0   25     1   3   37 46                 83
1366575 1366575 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_4 8 4 101 0   0     0   3   60 56 *                     116.0 8 4 101 0   0     0   3   60 56                 116
1366579 1366579 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_4 13 4 115 0   0     0   5   78 59 *                     137.0 13 4 115 0   0     0   5   78 59                 137
1366583 1366583 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_4 10 6 104 0   1     0   0   52 69 *                     121.0 10 6 104 0   1     0   0   52 69                 121
1366589 1366589 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_4 12 4 124 0   0     0   2   73 69 *                     142.0 12 4 124 0   0     0   2   73 69                 142
1366796 1366796 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_4 67 0 5 0   1     0   4   37 40 *                     77.0 67 0 5 0   1     0   4   37 40                 77
1366823 1366823 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2020   grade_4 26 7 17 0   2     0   4   24 32 *                     56.0 26 7 17 0   2     0   4   24 32                 56
1366828 1366828 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2020   grade_4 31 3 4 0   1     0   0   20 19 *                     39.0 31 3 4 0   1     0   0   20 19                 39
1366833 1366833 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2020   grade_4 35 4 6 0   0     0   5   19 31 *                     50.0 35 4 6 0   0     0   5   19 31                 50
1366838 1366838 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2020   grade_4 28 3 3 0   1     0   2   17 20 *                     37.0 28 3 3 0   1     0   2   17 20                 37
1367968 1367968 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_4 6 3 151 0   1     0   0   83 78 *                     161.0 6 3 151 0   1     0   0   83 78                 161
1367999 1367999 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_4 3 4 115 0   2     0   1   68 57 *                     125.0 3 4 115 0   2     0   1   68 57                 125
1368011 1368011 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_4 4 1 92 0   0     0   1   49 49 *                     98.0 4 1 92 0   0     0   1   49 49                 98
1368016 1368016 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_4 5 0 93 0   0     0   0   50 48 *                     98.0 5 0 93 0   0     0   0   50 48                 98
1368029 1368029 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2020   grade_4 2 0 71 0   0     0   0   45 28 *                     73.0 2 0 71 0   0     0   0   45 28                 73
1368526 1368526 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_4 6 7 91 1   9     0   2   60 56 *                     116.0 6 7 91 1   9     0   2   60 56                 116
1368556 1368556 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary 01 05 2020   grade_4 1 1 5 0   1     0   0   7 * *                     8.0 1 1 5 0   1     0   0   7                   8
1368581 1368581 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2020   grade_4 5 8 62 0   4     0   2   35 46 *                     81.0 5 8 62 0   4     0   2   35 46                 81
1368986 1368986 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_4 89 1 3 0   0     0   9   59 43 *                     102.0 89 1 3 0   0     0   9   59 43                 102
1368991 1368991 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2020   grade_4 94 2 3 0   0     0   9   57 51 *                     108.0 94 2 3 0   0     0   9   57 51                 108
1369097 1369097 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Granite Valley School   Regular School No Elementary 01 06 2020   grade_4 64 1 7 0   0     0   3   33 42 *                     75.0 64 1 7 0   0     0   3   33 42                 75
1369558 1369558 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2020   grade_4 42 3 15 0   3     0   1   28 36 *                     64.0 42 3 15 0   3     0   1   28 36                 64
1369565 1369565 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary 01 05 2020   grade_4 52 1 7 0   11     0   2   39 34 *                     73.0 52 1 7 0   11     0   2   39 34                 73
1369570 1369570 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2020   grade_4 35 0 5 0   2     0   1   27 16 *                     43.0 35 0 5 0   2     0   1   27 16                 43
1369575 1369575 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2020   grade_4 78 0 3 0   5     0   5   33 58 *                     91.0 78 0 3 0   5     0   5   33 58                 91
1369580 1369580 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2020   grade_4 56 0 12 0   2     0   3   38 35 *                     73.0 56 0 12 0   2     0   3   38 35                 73
1369752 1369752 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_4 24 9 19 0   1     1   1   23 32 *                     55.0 24 9 19 0   1     1   1   23 32                 55
1369757 1369757 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2020   grade_4 25 5 4 0   2     0   3   20 19 *                     39.0 25 5 4 0   2     0   3   20 19                 39
1369762 1369762 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2020   grade_4 60 4 6 0   7     0   4   39 42 *                     81.0 60 4 6 0   7     0   4   39 42                 81
1369767 1369767 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2020   grade_4 34 7 5 0   5     0   0   22 29 *                     51.0 34 7 5 0   5     0   0   22 29                 51
1370589 1370589 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_4 76 9 16 0   111     0   6   112 106 *                     218.0 76 9 16 0   111     0   6   112 106                 218
1370776 1370776 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2020   grade_4 1 2 7 0   0     0   0   9 1 *                     10.0 1 2 7 0   0     0   0   9 1                 10
1371846 1371846 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary 01 05 2020   grade_4 77 1 11 0   3     0   5   53 44 *                     97.0 77 1 11 0   3     0   5   53 44                 97
1371851 1371851 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2020   grade_4 24 2 13 0   6     0   1   25 21 *                     46.0 24 2 13 0   6     0   1   25 21                 46
1371856 1371856 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2020   grade_4 22 1 7 0   3     0   2   16 19 *                     35.0 22 1 7 0   3     0   2   16 19                 35
1373780 1373780 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_4 5 0 0 0   1     0   0   3 3 *                     6.0 5 0 0 0   1     0   0   3 3                 6
1365880 1365880 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_4 20 16 7 0   4     0   2   25 24 *                     49.0 20 16 7 0   4     0   2   25 24                 49
1366217 1366217 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_4 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1366861 1366861 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2020   grade_4 85 0 8 0   1     0   2   48 48 *                     96.0 85 0 8 0   1     0   2   48 48                 96
1367445 1367445 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2020   grade_4 107 8 53 0   7     0   14   88 101 *                     189.0 107 8 53 0   7     0   14   88 101                 189
1367522 1367522 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_4 84 0 5 0   13     1   7   55 55 *                     110.0 84 0 5 0   13     1   7   55 55                 110
1367527 1367527 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_4 100 2 3 0   21     0   2   69 59 *                     128.0 100 2 3 0   21     0   2   69 59                 128
1367607 1367607 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary 02 04 2020   grade_4 183 2 3 0   6     0   1   91 104 *                     195.0 183 2 3 0   6     0   1   91 104                 195
1367684 1367684 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_4 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368889 1368889 MA Norfolk   school 2507590 177   Medway 250759001015 1770015 Burke/Memorial Elementary School   Regular School No Elementary 02 04 2020   grade_4 156 5 3 0   2     1   5   91 81 *                     172.0 156 5 3 0   2     1   5   91 81                 172
1369656 1369656 MA Worcester   school 2508940 214   Northbridge 250894001447 2140001 W Edward Balmer   Regular School No Elementary 02 04 2020   grade_4 123 0 14 0   1     0   9   57 90 *                     147.0 123 0 14 0   1     0   9   57 90                 147
1369811 1369811 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2020   grade_4 102 3 19 0   0     0   9   72 61 *                     133.0 102 3 19 0   0     0   9   72 61                 133
1370744 1370744 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 02 05 2020   grade_4 28 0 36 0   1     0   1   30 36 *                     66.0 28 0 36 0   1     0   1   30 36                 66
1370761 1370761 MA Hampshire   school 2510920 278   South Hadley 251092002406 2780020 Mosier   Regular School No Elementary 02 04 2020   grade_4 109 1 20 0   1     0   2   73 60 *                     133.0 109 1 20 0   1     0   2   73 60                 133
1373053 1373053 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2020   grade_4 98 1 4 0   0     0   1   55 49 *                     104.0 98 1 4 0   0     0   1   55 49                 104
1373179 1373179 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2020   grade_4 147 14 6 0   5     0   5   89 88 *                     177.0 147 14 6 0   5     0   5   89 88                 177
1373294 1373294 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2020   grade_4 102 5 14 0   0     0   6   63 64 *                     127.0 102 5 14 0   0     0   6   63 64                 127
1373303 1373303 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No Elementary 02 04 2020   grade_4 125 1 8 0   3     0   2   79 60 *                     139.0 125 1 8 0   3     0   2   79 60                 139
1373411 1373411 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2020   grade_4 44 0 8 0   0     0   3   25 30 *                     55.0 44 0 8 0   0     0   3   25 30                 55
1373808 1373808 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_4 19 0 3 0   0     0   1   6 17 *                     23.0 19 0 3 0   0     0   1   6 17                 23
1364786 1364786 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_4 110 7 11 0   5     0   3   61 75 *                     136.0 110 7 11 0   5     0   3   61 75                 136
1364985 1364985 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2020   grade_4 131 5 28 0   32     0   7   100 103 *                     203.0 131 5 28 0   32     0   7   100 103                 203
1365047 1365047 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_4 162 6 25 0   4     0   6   107 96 *                     203.0 162 6 25 0   4     0   6   107 96                 203
1365107 1365107 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2020   grade_4 120 12 14 0   40     0   16   104 98 *                     202.0 120 12 14 0   40     0   16   104 98                 202
1365665 1365665 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_4 35 37 27 0   3     0   4   49 57 *                     106.0 35 37 27 0   3     0   4   49 57                 106
1365833 1365833 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_4 0 13 17 0   0     0   0   16 14 *                     30.0 0 13 17 0   0     0   0   16 14                 30
1366062 1366062 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne Intermediate School   Regular School No Elementary 03 05 2020   grade_4 138 5 17 1   1     2   7   80 91 *                     171.0 138 5 17 1   1     2   7   80 91                 171
1366077 1366077 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2020   grade_4 103 2 4 1   4     0   5   64 55 *                     119.0 103 2 4 1   4     0   5   64 55                 119
1366132 1366132 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2020   grade_4 65 2 5 0   0     0   5   43 34 *                     77.0 65 2 5 0   0     0   5   43 34                 77
1366707 1366707 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2020   grade_4 102 3 0 0   4     0   0   60 49 *                     109.0 102 3 0 0   4     0   0   60 49                 109
1366910 1366910 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2020   grade_4 196 2 8 0   0     0   7   105 108 *                     213.0 196 2 8 0   0     0   7   105 108                 213
1366928 1366928 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W. Mitchell School   Regular School No Elementary 03 06 2020   grade_4 142 7 4 1   3     0   7   88 76 *                     164.0 142 7 4 1   3     0   7   88 76                 164
1366970 1366970 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2020   grade_4 74 1 12 0   7     0   4   48 50 *                     98.0 74 1 12 0   7     0   4   48 50                 98
1366977 1366977 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No Elementary 03 05 2020   grade_4 70 3 9 0   4     0   4   46 44 *                     90.0 70 3 9 0   4     0   4   46 44                 90
1366999 1366999 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson Olmsted School   Regular School No Elementary 03 05 2020   grade_4 211 17 16 2   6     0   15   147 120 *                     267.0 211 17 16 2   6     0   15   147 120                 267
1367776 1367776 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2020   grade_4 180 3 11 1   25     0   8   126 102 *                     228.0 180 3 11 1   25     0   8   126 102                 228
1367957 1367957 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2020   grade_4 165 2 6 1   0     0   0   93 81 *                     174.0 165 2 6 1   0     0   0   93 81                 174
1367978 1367978 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_4 2 0 76 0   1     0   0   36 42 *                     79.0 2 0 76 0   1     0   0   36 42                 79
1368237 1368237 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2020   grade_4 110 2 3 0   14     0   3   59 73 *                     132.0 110 2 3 0   14     0   3   59 73                 132
1368447 1368447 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2020   grade_4 99 3 12 0   7     0   1   66 56 *                     122.0 99 3 12 0   7     0   1   66 56                 122
1368691 1368691 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No Elementary 03 05 2020   grade_4 194 10 20 0   27     0   17   152 116 *                     268.0 194 10 20 0   27     0   17   152 116                 268
1368704 1368704 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_4 166 6 18 0   0     0   14   107 97 *                     204.0 166 6 18 0   0     0   14   107 97                 204
1368798 1368798 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_4 84 6 10 8   2     0   10   60 60 *                     120.0 84 6 10 8   2     0   10   60 60                 120
1369008 1369008 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2020   grade_4 65 1 6 0   3     1   6   42 40 *                     82.0 65 1 6 0   3     1   6   42 40                 82
1369019 1369019 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2020   grade_4 204 11 105 1   8     0   15   177 167 *                     344.0 204 11 105 1   8     0   15   177 167                 344
1369123 1369123 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket Intermediate School   Regular School No Elementary 03 05 2020   grade_4 68 8 33 0   2     0   3   67 47 *                     114.0 68 8 33 0   2     0   3   67 47                 114
1369483 1369483 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2020   grade_4 141 0 7 0   2     0   3   84 69 *                     153.0 141 0 7 0   2     0   3   84 69                 153
1369796 1369796 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2020   grade_4 59 0 8 0   1     0   2   33 37 *                     70.0 59 0 8 0   1     0   2   33 37                 70
1370444 1370444 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_4 182 2 7 0   6     2   0   105 94 *                     199.0 182 2 7 0   6     2   0   105 94                 199
1370993 1370993 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield International Academy at Johnson   Regular School No Elementary 03 05 2020   grade_4 3 3 2 0   0     0   0   4 4 *                     8.0 3 3 2 0   0     0   0   4 4                 8
1371197 1371197 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2020   grade_4 98 0 3 0   2     0   5   56 52 *                     108.0 98 0 3 0   2     0   5   56 52                 108
1371232 1371232 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No Elementary 03 05 2020   grade_4 89 0 2 0   0     0   0   44 47 *                     91.0 89 0 2 0   0     0   0   44 47                 91
1371242 1371242 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Joseph G Luther   Regular School No Elementary 03 05 2020   grade_4 47 1 3 0   0     0   0   25 26 *                     51.0 47 1 3 0   0     0   0   25 26                 51
1371315 1371315 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 North Street   Regular School No Elementary 03 04 2020   grade_4 114 5 12 0   5     0   2   76 62 *                     138.0 114 5 12 0   5     0   2   76 62                 138
1371319 1371319 MA Middlesex   school 2511580 295   Tewksbury 251158001924 2950025 Louise Davy Trahan   Regular School No Elementary 03 04 2020   grade_4 92 1 2 0   2     0   5   45 57 *                     102.0 92 1 2 0   2     0   5   45 57                 102
1371530 1371530 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2020   grade_4 115 12 23 4   1     0   18   94 79 *                     173.0 115 12 23 4   1     0   18   94 79                 173
1371765 1371765 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2020   grade_4 91 0 1 0   39     0   5   61 75 *                     136.0 91 0 1 0   39     0   5   61 75                 136
1371768 1371768 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No Elementary 03 05 2020   grade_4 61 4 6 0   41     0   8   54 66 *                     120.0 61 4 6 0   41     0   8   54 66                 120
1371778 1371778 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2020   grade_4 72 2 5 0   34     0   4   64 53 *                     117.0 72 2 5 0   34     0   4   64 53                 117
1371826 1371826 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2020   grade_4 115 1 5 0   0     0   3   76 48 *                     124.0 115 1 5 0   0     0   3   76 48                 124
1372002 1372002 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Toy Town Elementary   Regular School No Elementary 03 05 2020   grade_4 76 1 8 0   1     0   4   53 37 *                     90.0 76 1 8 0   1     0   4   53 37                 90
1372059 1372059 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2020   grade_4 104 2 24 0   0     0   3   66 67 *                     133.0 104 2 24 0   0     0   3   66 67                 133
1373161 1373161 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_4 105 4 7 0   1     0   6   72 51 *                     123.0 105 4 7 0   1     0   6   72 51                 123
1373740 1373740 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No Elementary 03 06 2020   grade_4 61 0 4 0   0     0   2   32 35 *                     67.0 61 0 4 0   0     0   2   32 35                 67

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