enrollments

Data source: Big Local News · About: Big Local

894 rows where grade = "grade_5", state = "MA" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 794 ✖

grade ✖

  • grade_5 · 794 ✖
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
1124640 1124640 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_5 51 14 50 2   6     1   2   59 67                       126 51 14 50 2   6     1   2   59 67                 126
1125955 1125955 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2017   grade_5 66 8 49 0   0     0   3   63 63                       126 66 8 49 0   0     0   3   63 63                 126
1131213 1131213 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2017   grade_5 5 18 100 0   2     0   1   66 60                       126 5 18 100 0   2     0   1   66 60                 126
1122791 1122791 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_5 26 39 51 0   7     0   4   71 56                       127 26 39 51 0   7     0   4   71 56                 127
1125785 1125785 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_5 2 1 124 0   0     0   0   66 61                       127 2 1 124 0   0     0   0   66 61                 127
1127310 1127310 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_5 72 12 35 1   1     0   6   76 51                       127 72 12 35 1   1     0   6   76 51                 127
1125914 1125914 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2017   grade_5 103 5 9 0   6     0   5   70 58                       128 103 5 9 0   6     0   5   70 58                 128
1128485 1128485 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   grade_5 67 3 49 0   5     0   4   63 65                       128 67 3 49 0   5     0   4   63 65                 128
1129527 1129527 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_5 110 2 8 0   3     0   5   68 60                       128 110 2 8 0   3     0   5   68 60                 128
1131306 1131306 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_5 32 40 48 0   5     0   3   68 60                       128 32 40 48 0   5     0   3   68 60                 128
1124650 1124650 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_5 35 23 58 1   11     0   1   64 65                       129 35 23 58 1   11     0   1   64 65                 129
1125217 1125217 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2017   grade_5 91 3 8 0   24     0   3   66 63                       129 91 3 8 0   24     0   3   66 63                 129
1130277 1130277 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No Elementary 03 05 2017   grade_5 75 2 0 0   50     0   2   61 68                       129 75 2 0 0   50     0   2   61 68                 129
1124417 1124417 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_5 120 1 3 0   2     0   4   78 52                       130 120 1 3 0   2     0   4   78 52                 130
1132526 1132526 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2017   grade_5 115 3 6 0   3     0   3   78 52                       130 115 3 6 0   3     0   3   78 52                 130
1123582 1123582 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_5 10 84 29 1   1     0   6   63 68                       131 10 84 29 1   1     0   6   63 68                 131
1125281 1125281 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_5 100 1 19 0   4     0   7   67 64                       131 100 1 19 0   4     0   7   67 64                 131
1126588 1126588 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2017   grade_5 38 28 39 1   26     0   0   57 75                       132 38 28 39 1   26     0   0   57 75                 132
1130063 1130063 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_5 81 5 32 0   4     0   11   72 61                       133 81 5 32 0   4     0   11   72 61                 133
1126099 1126099 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Russell St Elementary   Regular School No Elementary 03 05 2017   grade_5 116 4 3 0   7     0   4   58 76                       134 116 4 3 0   7     0   4   58 76                 134
1130561 1130561 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 West Intermediate   Regular School No Elementary 04 05 2017   grade_5 124 1 3 1   2     0   3   64 70                       134 124 1 3 1   2     0   3   64 70                 134
1132957 1132957 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary 03 05 2017   grade_5 127 1 3 0   3     0   0   69 65                       134 127 1 3 0   3     0   0   69 65                 134
1123653 1123653 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2017   grade_5 4 117 10 1   1     0   2   77 58                       135 4 117 10 1   1     0   2   77 58                 135
1125976 1125976 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2017   grade_5 63 11 53 0   3     0   5   73 62                       135 63 11 53 0   3     0   5   73 62                 135
1126265 1126265 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_5 37 11 46 0   33     0   8   63 72                       135 37 11 46 0   33     0   8   63 72                 135
1131915 1131915 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2017   grade_5 119 4 4 0   6     0   2   60 75                       135 119 4 4 0   6     0   2   60 75                 135
1132515 1132515 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_5 119 2 6 0   2     0   6   71 64                       135 119 2 6 0   2     0   6   71 64                 135
1123058 1123058 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2017   grade_5 9 25 23 0   74     0   5   66 70                       136 9 25 23 0   74     0   5   66 70                 136
1126920 1126920 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_5 82 0 40 0   7     0   7   69 67                       136 82 0 40 0   7     0   7   69 67                 136
1125743 1125743 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2017   grade_5 126 2 5 1   1     0   2   69 68                       137 126 2 5 1   1     0   2   69 68                 137
1130558 1130558 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 North Intermediate   Regular School No Elementary 04 05 2017   grade_5 120 3 4 0   3     0   7   78 59                       137 120 3 4 0   3     0   7   78 59                 137
1129077 1129077 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2017   grade_5 115 1 14 0   5     0   4   73 66                       139 115 1 14 0   5     0   4   73 66                 139
1132275 1132275 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   grade_5 13 0 0 0   0     0   1   6 8                       14 13 0 0 0   0     0   1   6 8                 14
1127698 1127698 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2017   grade_5 120 1 7 0   7     1   4   74 66                       140 120 1 7 0   7     1   4   74 66                 140
1124771 1124771 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2017   grade_5 84 11 26 0   9     0   11   82 59                       141 84 11 26 0   9     0   11   82 59                 141
1125767 1125767 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary KG 05 2017   grade_5 4 3 131 0   3     0   0   65 76                       141 4 3 131 0   3     0   0   65 76                 141
1126336 1126336 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Turkey Hill Elementary School   Regular School No Elementary 03 05 2017   grade_5 126 1 9 2   1     1   1   74 67                       141 126 1 9 2   1     1   1   74 67                 141
1132062 1132062 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2017   grade_5 120 2 14 0   3     0   3   67 75                       142 120 2 14 0   3     0   3   67 75                 142
1131486 1131486 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_5 64 31 11 0   31     0   6   66 77                       143 64 31 11 0   31     0   6   66 77                 143
1129796 1129796 MA Worcester   school 2511850 304   Uxbridge 251185002762 3040020 Whitin Elementary School   Regular School No Elementary 03 05 2017   grade_5 127 2 6 1   4     0   4   78 66                       144 127 2 6 1   4     0   4   78 66                 144
1122240 1122240 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_5 91 4 30 1   11     0   8   69 76                       145 91 4 30 1   11     0   8   69 76                 145
1124224 1124224 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_5 104 2 37 0   2     0   0   77 68                       145 104 2 37 0   2     0   0   77 68                 145
1126942 1126942 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_5 63 0 68 0   4     0   10   83 62                       145 63 0 68 0   4     0   10   83 62                 145
1127027 1127027 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Elementary 04 06 2017   grade_5 118 2 13 0   6     0   7   74 72                       146 118 2 13 0   6     0   7   74 72                 146
1126953 1126953 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2017   grade_5 71 0 62 0   4     0   10   73 74                       147 71 0 62 0   4     0   10   73 74                 147
1127954 1127954 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2017   grade_5 121 4 12 0   2     0   8   79 68                       147 121 4 12 0   2     0   8   79 68                 147
1130350 1130350 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2017   grade_5 133 0 8 0   0     0   6   76 71                       147 133 0 8 0   0     0   6   76 71                 147
1132026 1132026 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2017   grade_5 134 0 6 0   3     0   5   78 70                       148 134 0 6 0   3     0   5   78 70                 148
1132067 1132067 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_5 132 1 11 0   1     0   3   75 73                       148 132 1 11 0   1     0   3   75 73                 148
1132366 1132366 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_5 117 9 15 1   1     1   5   74 75                       149 117 9 15 1   1     1   5   74 75                 149
1122245 1122245 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_5 100 6 29 0   6     0   9   78 72                       150 100 6 29 0   6     0   9   78 72                 150
1131085 1131085 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Elementary 04 06 2017   grade_5 131 1 8 0   6     0   5   84 67                       151 131 1 8 0   6     0   5   84 67                 151
1129609 1129609 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2017   grade_5 121 5 21 0   3     0   2   78 74                       152 121 5 21 0   3     0   2   78 74                 152
1124104 1124104 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_5 11 2 138 1   1     0   0   84 69                       153 11 2 138 1   1     0   0   84 69                 153
1124109 1124109 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_5 9 6 135 0   3     0   1   70 84                       154 9 6 135 0   3     0   1   70 84                 154
1126280 1126280 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2017   grade_5 39 15 70 0   24     0   6   72 82                       154 39 15 70 0   24     0   6   72 82                 154
1130326 1130326 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No Elementary 04 05 2017   grade_5 113 9 8 0   16     0   11   85 72                       157 113 9 8 0   16     0   11   85 72                 157
1124099 1124099 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_5 14 10 132 0   1     0   2   92 67                       159 14 10 132 0   1     0   2   92 67                 159
1128584 1128584 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2017   grade_5 120 11 18 0   2     0   8   76 83                       159 120 11 18 0   2     0   8   76 83                 159
1122566 1122566 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_5 5 2 5 0   2     0   2   11 5                       16 5 2 5 0   2     0   2   11 5                 16
1123136 1123136 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_5 2 4 10 0   0     0   0   12 4                       16 2 4 10 0   0     0   0   12 4                 16
1132179 1132179 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2017   grade_5 14 0 0 0   0     0   2   8 8                       16 14 0 0 0   0     0   2   8 8                 16
1130648 1130648 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No Elementary 03 05 2017   grade_5 126 1 28 0   2     0   3   90 70                       160 126 1 28 0   2     0   3   90 70                 160
1129036 1129036 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Margaret A Neary   Regular School No Elementary 04 05 2017   grade_5 110 0 11 0   32     0   8   87 74                       161 110 0 11 0   32     0   8   87 74                 161
1125447 1125447 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_5 66 9 84 0   2     0   1   84 78                       162 66 9 84 0   2     0   1   84 78                 162
1127167 1127167 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2017   grade_5 127 4 5 1   20     0   5   77 85                       162 127 4 5 1   20     0   5   77 85                 162
1123474 1123474 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_5 147 2 10 1   1     0   2   83 80                       163 147 2 10 1   1     0   2   83 80                 163
1122235 1122235 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_5 112 5 25 0   9     0   13   85 79                       164 112 5 25 0   9     0   13   85 79                 164
1123596 1123596 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2017   grade_5 23 69 66 0   0     0   6   81 83                       164 23 69 66 0   0     0   6   81 83                 164
1126858 1126858 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2017   grade_5 151 3 5 0   2     0   4   80 85                       165 151 3 5 0   2     0   4   80 85                 165
1129464 1129464 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2017   grade_5 132 5 14 0   8     0   6   84 81                       165 132 5 14 0   8     0   6   84 81                 165
1126295 1126295 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2017   grade_5 21 6 45 0   90     0   4   85 81                       166 21 6 45 0   90     0   4   85 81                 166
1124892 1124892 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_5 52 8 85 1   8     0   13   89 78                       167 52 8 85 1   8     0   13   89 78                 167
1125385 1125385 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 05 2017   grade_5 136 9 19 0   2     0   2   89 79                       168 136 9 19 0   2     0   2   89 79                 168
1131110 1131110 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_5 19 4 138 1   3     1   2   87 81                       168 19 4 138 1   3     1   2   87 81                 168
1129693 1129693 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2017   grade_5 88 36 26 1   2     0   16   87 82                       169 88 36 26 1   2     0   16   87 82                 169
1126009 1126009 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_5 13 0 2 0   0     0   2   11 6                       17 13 0 2 0   0     0   2   11 6                 17
1127117 1127117 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_5 17 0 0 0   0     0   0   10 7                       17 17 0 0 0   0     0   0   10 7                 17
1132398 1132398 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_5 15 0 2 0   0     0   0   6 11                       17 15 0 2 0   0     0   0   6 11                 17
1124060 1124060 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_5 124 3 13 0   26     0   4   82 88                       170 124 3 13 0   26     0   4   82 88                 170
1127835 1127835 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2017   grade_5 143 3 9 1   5     0   11   76 96                       172 143 3 9 1   5     0   11   76 96                 172
1122030 1122030 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_5 150 3 14 0   3     1   2   79 94                       173 150 3 14 0   3     1   2   79 94                 173
1124880 1124880 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_5 52 8 91 0   13     0   10   89 85                       174 52 8 91 0   13     0   10   89 85                 174
1126531 1126531 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2017   grade_5 154 3 8 0   5     0   4   92 82                       174 154 3 8 0   5     0   4   92 82                 174
1132243 1132243 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002139 6800030 Soule Road   Regular School No Elementary 04 05 2017   grade_5 147 6 8 1   5     0   7   85 89                       174 147 6 8 1   5     0   7   85 89                 174
1126285 1126285 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2017   grade_5 62 12 70 0   27     0   4   94 81                       175 62 12 70 0   27     0   4   94 81                 175
1126270 1126270 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2017   grade_5 54 4 30 0   79     0   9   93 83                       176 54 4 30 0   79     0   9   93 83                 176
1122269 1122269 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2017   grade_5 149 3 13 0   7     0   5   96 81                       177 149 3 13 0   7     0   5   96 81                 177
1124499 1124499 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No Elementary 03 06 2017   grade_5 161 4 6 0   1     0   5   98 79                       177 161 4 6 0   1     0   5   98 79                 177
1124212 1124212 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_5 18 0 0 0   0     0   0   10 8                       18 18 0 0 0   0     0   0   10 8                 18
1128055 1128055 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_5 15 1 1 0   0     0   1   7 11                       18 15 1 1 0   0     0   1   7 11                 18
1128096 1128096 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   grade_5 17 0 0 0   0     0   1   12 6                       18 17 0 0 0   0     0   1   12 6                 18
1128904 1128904 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_5 17 0 0 0   0     0   1   6 12                       18 17 0 0 0   0     0   1   6 12                 18
1129765 1129765 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_5 15 0 2 0   0     0   1   8 10                       18 15 0 2 0   0     0   1   8 10                 18
1130316 1130316 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_5 17 0 0 0   0     0   1   11 7                       18 17 0 0 0   0     0   1   11 7                 18
1131454 1131454 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_5 15 2 0 0   0     0   1   7 11                       18 15 2 0 0   0     0   1   7 11                 18
1131948 1131948 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_5 17 0 0 0   0     0   1   8 10                       18 17 0 0 0   0     0   1   8 10                 18
1132750 1132750 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_5 17 0 1 0   0     0   0   11 7                       18 17 0 1 0   0     0   0   11 7                 18
1121954 1121954 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_5 169 1 7 0   3     0   0   97 83                       180 169 1 7 0   3     0   0   97 83                 180
1126318 1126318 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2017   grade_5 154 4 16 0   0     0   6   99 81                       180 154 4 16 0   0     0   6   99 81                 180

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