enrollments

Data source: Big Local News · About: Big Local

878 rows where grade = "grade_5", state = "MA" and year = 2019 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 878 ✖

grade ✖

  • grade_5 · 878 ✖
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
2040822 2040822 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_5 1 10 8 0   0     0   0   14 5                       19.0 1 10 8 0   0     0   0   14 5                 19
2041169 2041169 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2019   grade_5 52 4 4 0   31     0   1   43 49                       92.0 52 4 4 0   31     0   1   43 49                 92
2041654 2041654 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 05 2019   grade_5 0 0 39 0   0     0   0   16 23                       39.0 0 0 39 0   0     0   0   16 23                 39
2041867 2041867 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2019   grade_5 78 1 7 0   0     0   1   40 47                       87.0 78 1 7 0   0     0   1   40 47                 87
2041894 2041894 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2019   grade_5 39 5 16 0   1     0   5   35 31                       66.0 39 5 16 0   1     0   5   35 31                 66
2041899 2041899 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Greenlodge   Regular School No Elementary 01 05 2019   grade_5 51 2 6 0   1     0   1   33 28                       61.0 51 2 6 0   1     0   1   33 28                 61
2041904 2041904 MA Norfolk   school 2504050 73   Dedham 250405000552 730030 Oakdale   Regular School No Elementary 01 05 2019   grade_5 42 1 7 0   0     0   1   33 18                       51.0 42 1 7 0   0     0   1   33 18                 51
2041909 2041909 MA Norfolk   school 2504050 73   Dedham 250405000554 730045 Riverdale   Regular School No Elementary 01 05 2019   grade_5 29 2 2 0   1     0   4   21 17                       38.0 29 2 2 0   1     0   4   21 17                 38
2042769 2042769 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_5 * * * *   *     *   *   5 *                       5.0                         5                   5
2043053 2043053 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2019   grade_5 11 1 141 0   3     0   1   77 80                       157.0 11 1 141 0   3     0   1   77 80                 157
2043096 2043096 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_5 1 0 87 0   0     0   0   45 43                       88.0 1 0 87 0   0     0   0   45 43                 88
2043101 2043101 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_5 2 0 101 0   1     0   0   50 53                       104.0 2 0 101 0   1     0   0   50 53                 104
2043114 2043114 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 John K Tarbox   Regular School No Elementary 01 05 2019   grade_5 1 0 42 0   0     0   0   24 19                       43.0 1 0 42 0   0     0   0   24 19                 43
2043145 2043145 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_5 0 0 8 0   0     0   0   7 1                       8.0 0 0 8 0   0     0   0   7 1                 8
2043598 2043598 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2019   grade_5 4 4 67 0   6     0   3   36 48                       84.0 4 4 67 0   6     0   3   36 48                 84
2043650 2043650 MA Essex   school 2507110 163   Lynn 250711001085 1630100 Tracy   Regular School No Elementary 01 05 2019   grade_5 8 10 50 0   6     0   2   36 40                       76.0 8 10 50 0   6     0   2   36 40                 76
2044058 2044058 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2019   grade_5 108 2 4 0   0     0   12   56 70                       126.0 108 2 4 0   0     0   12   56 70                 126
2044063 2044063 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Mary K. Goode Elementary School   Regular School No Elementary 01 05 2019   grade_5 121 3 4 1   1     0   6   74 62                       136.0 121 3 4 1   1     0   6   74 62                 136
2044632 2044632 MA Essex   school 2508700 211   North Andover 250870001393 2110001 Atkinson   Regular School No Elementary 01 05 2019   grade_5 41 7 15 1   9     0   4   37 40                       77.0 41 7 15 1   9     0   4   37 40                 77
2044639 2044639 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No Elementary 01 05 2019   grade_5 61 1 7 1   10     0   4   43 41                       84.0 61 1 7 1   10     0   4   43 41                 84
2044644 2044644 MA Essex   school 2508700 211   North Andover 250870001396 2110015 Kittredge   Regular School No Elementary 01 05 2019   grade_5 33 2 2 0   5     0   3   26 19                       45.0 33 2 2 0   5     0   3   26 19                 45
2044649 2044649 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_5 74 1 7 0   8     0   4   40 54                       94.0 74 1 7 0   8     0   4   40 54                 94
2044654 2044654 MA Essex   school 2508700 211   North Andover 250870001399 2110020 Thomson   Regular School No Elementary 01 05 2019   grade_5 49 3 15 0   2     0   5   37 37                       74.0 49 3 15 0   2     0   5   37 37                 74
2044827 2044827 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2019   grade_5 32 4 14 0   2     0   2   29 25                       54.0 32 4 14 0   2     0   2   29 25                 54
2044832 2044832 MA Norfolk   school 2509060 220   Norwood 250906001462 2200010 Cornelius M Callahan   Regular School No Elementary 01 05 2019   grade_5 16 2 6 0   3     0   3   14 16                       30.0 16 2 6 0   3     0   3   14 16                 30
2044837 2044837 MA Norfolk   school 2509060 220   Norwood 250906001463 2200015 F A Cleveland   Regular School No Elementary 01 05 2019   grade_5 38 7 3 0   3     0   0   24 27                       51.0 38 7 3 0   3     0   0   24 27                 51
2044842 2044842 MA Norfolk   school 2509060 220   Norwood 250906001465 2200020 John P Oldham   Regular School No Elementary 01 05 2019   grade_5 38 7 6 0   1     0   2   29 25                       54.0 38 7 6 0   1     0   2   29 25                 54
2044847 2044847 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary 01 05 2019   grade_5 28 4 0 0   4     0   1   21 16                       37.0 28 4 0 0   4     0   1   21 16                 37
2045851 2045851 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2019   grade_5 2 4 10 0   0     0   0   15 1                       16.0 2 4 10 0   0     0   0   15 1                 16
2046926 2046926 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2019   grade_5 23 1 19 0   7     0   2   27 25                       52.0 23 1 19 0   7     0   2   27 25                 52
2046931 2046931 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2019   grade_5 19 0 5 0   2     0   4   13 17                       30.0 19 0 5 0   2     0   4   13 17                 30
2040878 2040878 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_5 0 28 15 0   0     0   2   22 23                       45.0 0 28 15 0   0     0   2   22 23                 45
2040925 2040925 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_5 9 15 12 0   2     0   3   24 17                       41.0 9 15 12 0   2     0   3   24 17                 41
2041931 2041931 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2019   grade_5 71 0 4 0   1     0   5   40 41                       81.0 71 0 4 0   1     0   5   40 41                 81
2042595 2042595 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_5 83 2 7 1   6     0   4   64 39                       103.0 83 2 7 1   6     0   4   64 39                 103
2042600 2042600 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_5 108 2 10 0   21     0   0   69 72                       141.0 108 2 10 0   21     0   0   69 72                 141
2043452 2043452 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_5 * * * *   *     *   *   3 *                       3.0                         3                   3
2045814 2045814 MA Worcester   school 2511010 277   Southbridge 251101001763 2770005 Charlton Street   Regular School No Elementary 02 05 2019   grade_5 28 2 42 0   2     0   7   34 47                       81.0 28 2 42 0   2     0   7   34 47                 81
2045821 2045821 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 02 05 2019   grade_5 28 2 56 0   0     0   3   41 48                       89.0 28 2 56 0   0     0   3   41 48                 89
2048127 2048127 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2019   grade_5 86 4 12 0   0     0   5   58 49                       107.0 86 4 12 0   0     0   5   58 49                 107
2048476 2048476 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2019   grade_5 41 0 10 0   0     1   3   33 22                       55.0 41 0 10 0   0     1   3   33 22                 55
2048875 2048875 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_5 22 0 2 0   0     0   0   13 11                       24.0 22 0 2 0   0     0   0   13 11                 24
2040013 2040013 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2019   grade_5 149 2 28 5   25     0   9   110 108                       218.0 149 2 28 5   25     0   9   110 108                 218
2040076 2040076 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2019   grade_5 171 6 15 0   5     0   8   85 120                       205.0 171 6 15 0   5     0   8   85 120                 205
2040133 2040133 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2019   grade_5 145 11 4 0   37     0   8   104 101                       205.0 145 11 4 0   37     0   8   104 101                 205
2040709 2040709 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_5 30 34 35 0   6     0   6   63 48                       111.0 30 34 35 0   6     0   6   63 48                 111
2041137 2041137 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_5 90 1 2 0   6     0   6   55 50                       105.0 90 1 2 0   6     0   6   55 50                 105
2041200 2041200 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2019   grade_5 76 1 4 0   1     0   3   44 41                       85.0 76 1 4 0   1     0   3   44 41                 85
2041286 2041286 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_5 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041778 2041778 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Deer Hill   Regular School No Elementary 03 05 2019   grade_5 134 3 1 0   1     0   0   70 69                       139.0 134 3 1 0   1     0   0   70 69                 139
2041981 2041981 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2019   grade_5 215 1 7 0   2     0   4   125 104                       229.0 215 1 7 0   2     0   4   125 104                 229
2042000 2042000 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W. Mitchell School   Regular School No Elementary 03 06 2019   grade_5 156 6 5 1   2     0   8   107 71                       178.0 156 6 5 1   2     0   8   107 71                 178
2042042 2042042 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2019   grade_5 80 4 4 0   15     0   2   46 59                       105.0 80 4 4 0   15     0   2   46 59                 105
2042049 2042049 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No Elementary 03 05 2019   grade_5 79 3 7 0   3     0   6   49 49                       98.0 79 3 7 0   3     0   6   49 49                 98
2042072 2042072 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson Olmsted School   Regular School No Elementary 03 05 2019   grade_5 220 13 13 0   14     0   7   136 131                       267.0 220 13 13 0   14     0   7   136 131                 267
2042858 2042858 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Miller School   Regular School No Elementary 03 05 2019   grade_5 187 3 17 0   16     0   7   116 114                       230.0 187 3 17 0   16     0   7   116 114                 230
2043042 2043042 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2019   grade_5 136 0 2 1   2     0   0   72 68                       141.0 136 0 2 1   2     0   0   72 68                 141
2043063 2043063 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_5 2 1 91 0   2     0   0   47 49                       96.0 2 1 91 0   2     0   0   47 49                 96
2043170 2043170 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2019   grade_5 103 9 12 0   1     0   1   71 55                       126.0 103 9 12 0   1     0   1   71 55                 126
2043322 2043322 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2019   grade_5 110 3 1 0   20     0   3   69 68                       137.0 110 3 1 0   20     0   3   69 68                 137
2043531 2043531 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2019   grade_5 119 2 5 0   3     1   6   72 64                       136.0 119 2 5 0   3     1   6   72 64                 136
2043758 2043758 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No Elementary 03 05 2019   grade_5 230 9 18 0   16     0   7   146 134                       280.0 230 9 18 0   16     0   7   146 134                 280
2043870 2043870 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_5 100 6 4 9   2     0   7   64 64                       128.0 100 6 4 9   2     0   7   64 64                 128
2044080 2044080 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2019   grade_5 83 1 5 0   5     0   8   50 52                       102.0 83 1 5 0   5     0   8   50 52                 102
2044091 2044091 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_5 190 11 95 8   11     0   14   178 151                       329.0 190 11 95 8   11     0   14   178 151                 329
2044195 2044195 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket Intermediate School   Regular School No Elementary 03 05 2019   grade_5 78 16 40 0   4     0   2   70 70                       140.0 78 16 40 0   4     0   2   70 70                 140
2044557 2044557 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2019   grade_5 126 1 3 0   1     0   4   77 58                       135.0 126 1 3 0   1     0   4   77 58                 135
2044870 2044870 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2019   grade_5 85 2 8 0   1     0   1   49 48                       97.0 85 2 8 0   1     0   1   49 48                 97
2045519 2045519 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2019   grade_5 189 4 5 2   8     0   2   106 104                       210.0 189 4 5 2   8     0   2   106 104                 210
2046069 2046069 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield International Academy at Johnson   Regular School No Elementary 03 05 2019   grade_5 2 3 3 0   1     0   0   3 6                       9.0 2 3 3 0   1     0   0   3 6                 9
2046274 2046274 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2019   grade_5 91 0 2 0   2     0   9   55 49                       104.0 91 0 2 0   2     0   9   55 49                 104
2046309 2046309 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No Elementary 03 05 2019   grade_5 100 0 0 0   3     0   0   45 58                       103.0 100 0 0 0   3     0   0   45 58                 103
2046319 2046319 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Joseph G Luther   Regular School No Elementary 03 05 2019   grade_5 61 0 3 1   0     0   1   27 39                       66.0 61 0 3 1   0     0   1   27 39                 66
2046840 2046840 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2019   grade_5 84 0 2 1   28     0   2   47 70                       117.0 84 0 2 1   28     0   2   47 70                 117
2046843 2046843 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No Elementary 03 05 2019   grade_5 57 0 4 0   39     0   4   51 53                       104.0 57 0 4 0   39     0   4   51 53                 104
2046853 2046853 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2019   grade_5 79 1 2 1   28     0   5   54 62                       116.0 79 1 2 1   28     0   5   54 62                 116
2046901 2046901 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2019   grade_5 101 0 5 0   0     0   7   67 46                       113.0 101 0 5 0   0     0   7   67 46                 113
2047077 2047077 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Toy Town Elementary   Regular School No Elementary 03 05 2019   grade_5 74 0 8 0   1     0   3   40 46                       86.0 74 0 8 0   1     0   3   40 46                 86
2047134 2047134 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2019   grade_5 128 3 30 1   1     0   3   87 79                       166.0 128 3 30 1   1     0   3   87 79                 166
2048222 2048222 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_5 86 3 9 0   2     0   5   50 55                       105.0 86 3 9 0   2     0   5   50 55                 105
2048801 2048801 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No Elementary 03 06 2019   grade_5 41 0 4 0   0     0   0   24 21                       45.0 41 0 4 0   0     0   0   24 21                 45
2048943 2048943 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_5 99 5 6 0   1     0   4   54 61                       115.0 99 5 6 0   1     0   4   54 61                 115
2049078 2049078 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2019   grade_5 93 3 5 0   5     0   5   55 56                       111.0 93 3 5 0   5     0   5   55 56                 111
2040119 2040119 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2019   grade_5 279 24 65 4   8     1   15   209 187                       396.0 279 24 65 4   8     1   15   209 187                 396
2040145 2040145 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Middle 04 06 2019   grade_5 162 2 8 1   2     0   3   83 95                       178.0 162 2 8 1   2     0   3   83 95                 178
2040167 2040167 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2019   grade_5 161 5 14 0   3     0   7   81 109                       190.0 161 5 14 0   3     0   7   81 109                 190
2042791 2042791 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_5 58 5 111 0   6     0   5   102 83                       185.0 58 5 111 0   6     0   5   102 83                 185
2042894 2042894 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_5 6 0 45 0   0     0   0   27 24                       51.0 6 0 45 0   0     0   0   27 24                 51
2042965 2042965 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No Elementary 04 05 2019   grade_5 195 2 15 1   48     0   16   147 130                       277.0 195 2 15 1   48     0   16   147 130                 277
2043312 2043312 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_5 45 6 14 0   1     0   5   34 37                       71.0 45 6 14 0   1     0   5   34 37                 71
2043516 2043516 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2019   grade_5 160 3 33 2   0     0   6   104 100                       204.0 160 3 33 2   0     0   6   104 100                 204
2043775 2043775 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Middle 04 06 2019   grade_5 165 6 15 0   3     0   8   98 99                       197.0 165 6 15 0   3     0   8   98 99                 197
2043882 2043882 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No Middle 04 06 2019   grade_5 62 1 1 0   1     0   2   40 27                       67.0 62 1 1 0   1     0   2   40 27                 67
2043890 2043890 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2019   grade_5 92 5 13 0   0     0   5   51 64                       115.0 92 5 13 0   0     0   5   51 64                 115
2043902 2043902 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2019   grade_5 162 1 14 0   5     0   6   97 91                       188.0 162 1 14 0   5     0   6   97 91                 188
2044106 2044106 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Middle 04 06 2019   grade_5 108 1 17 0   3     0   10   63 76                       139.0 108 1 17 0   3     0   10   63 76                 139
2044434 2044434 MA Essex   school 2508580 204   Newburyport 250858002624 2040030 Edward G. Molin Elementary School   Regular School No Elementary 04 05 2019   grade_5 166 3 1 0   3     0   1   90 84                       174.0 166 3 1 0   3     0   1   90 84                 174
2044793 2044793 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2019   grade_5 173 6 3 0   7     0   11   99 101                       200.0 173 6 3 0   7     0   11   99 101                 200
2045087 2045087 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2019   grade_5 84 2 11 1   5     0   4   52 55                       107.0 84 2 11 1   5     0   4   52 55                 107
2045805 2045805 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Margaret A Neary   Regular School No Elementary 04 05 2019   grade_5 83 2 12 0   24     0   8   64 65                       129.0 83 2 12 0   24     0   8   64 65                 129

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