enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by native_american descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1126734 1126734 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_2 67 1 7 9   1     0   10   44 51                       95 67 1 7 9   1     0   10   44 51                 95
1126737 1126737 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_8 120 7 6 9   3     0   3   68 80                       148 120 7 6 9   3     0   3   68 80                 148
1126733 1126733 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_1 80 6 10 8   3     0   9   60 56                       116 80 6 10 8   3     0   9   60 56                 116
1126739 1126739 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_3 97 5 4 8   2     0   5   59 62                       121 97 5 4 8   2     0   5   59 62                 121
1126740 1126740 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_4 106 3 2 8   3     0   12   65 69                       134 106 3 2 8   3     0   12   65 69                 134
1127007 1127007 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_3 193 11 87 8   7     0   13   161 158                       319 193 11 87 8   7     0   13   161 158                 319
1127009 1127009 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_5 217 6 82 8   10     0   10   182 151                       333 217 6 82 8   10     0   10   182 151                 333
1132003 1132003 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_8 154 20 21 8   4     1   13   125 96                       221 154 20 21 8   4     1   13   125 96                 221
1124841 1124841 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   grade_3 33 4 1 7   1     0   5   33 18                       51 33 4 1 7   1     0   5   33 18                 51
1126736 1126736 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_7 105 4 4 7   3     1   5   71 58                       129 105 4 4 7   3     1   5   71 58                 129
1126741 1126741 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_5 83 3 3 6   2     0   5   60 42                       102 83 3 3 6   2     0   5   60 42                 102
1127013 1127013 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_8 205 9 76 6   6     0   11   168 145                       313 205 9 76 6   6     0   11   168 145                 313
1127015 1127015 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2017   grade_9 195 5 60 6   5     0   6   129 148                       277 195 5 60 6   5     0   6   129 148                 277
1127016 1127016 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2017   grade_10 186 7 68 6   10     0   4   147 134                       281 186 7 68 6   10     0   4   147 134                 281
1127385 1127385 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_10 160 62 268 6   7     2   22   299 228                       527 160 62 268 6   7     2   22   299 228                 527
1131991 1131991 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   kindergarten 72 10 5 6   1     1   6   57 44                       101 72 10 5 6   1     1   6   57 44                 101
1131996 1131996 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2017   grade_4 193 20 29 6   10     0   14   141 131                       272 193 20 29 6   10     0   14   141 131                 272
1131997 1131997 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2017   grade_5 170 18 30 6   5     0   13   113 129                       242 170 18 30 6   5     0   13   113 129                 242
1132000 1132000 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2017   grade_7 158 26 26 6   3     0   10   117 112                       229 158 26 26 6   3     0   10   117 112                 229
1132993 1132993 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 110 7 14 6   2     1   11   91 60                       151 110 7 14 6   2     1   11   91 60                 151
1122190 1122190 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2017   grade_3 153 3 20 5   25     0   8   110 104                       214 153 3 20 5   25     0   8   110 104                 214
1122327 1122327 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_10 273 28 34 5   12     3   17   175 197                       372 273 28 34 5   12     3   17   175 197                 372
1122328 1122328 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_11 273 35 47 5   16     2   15   197 196                       393 273 35 47 5   16     2   15   197 196                 393
1123970 1123970 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_9 197 136 70 5   49     1   33   241 250                       491 197 136 70 5   49     1   33   241 250                 491
1126482 1126482 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2017   grade_7 53 41 275 5   35     0   14   223 200                       423 53 41 275 5   35     0   14   223 200                 423
1126486 1126486 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_7 65 43 261 5   57     0   16   226 221                       447 65 43 261 5   57     0   16   226 221                 447
1126731 1126731 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   kindergarten 51 5 5 5   3     1   3   36 37                       73 51 5 5 5   3     1   3   36 37                 73
1126744 1126744 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   grade_9 91 6 4 5   2     0   5   60 53                       113 91 6 4 5   2     0   5   60 53                 113
1126999 1126999 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2017   grade_2 84 6 38 5   5     1   10   86 63                       149 84 6 38 5   5     1   10   86 63                 149
1131111 1131111 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_6 26 16 120 5   2     2   0   79 92                       171 26 16 120 5   2     2   0   79 92                 171
1132995 1132995 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2017   grade_12 117 9 13 5   1     0   4   90 59                       149 117 9 13 5   1     0   4   90 59                 149
1122188 1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
1122329 1122329 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_12 245 30 35 4   10     0   10   157 177                       334 245 30 35 4   10     0   10   157 177                 334
1123471 1123471 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2017   grade_3 69 1 2 4   2     0   6   38 46                       84 69 1 2 4   2     0   6   38 46                 84
1123699 1123699 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_9 216 739 183 4   29     3   49   687 536                       1223 216 739 183 4   29     3   49   687 536                 1223
1123700 1123700 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_10 218 642 115 4   27     1   41   515 533                       1048 218 642 115 4   27     1   41   515 533                 1048
1123701 1123701 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_11 169 633 111 4   31     2   28   494 484                       978 169 633 111 4   31     2   28   494 484                 978
1124847 1124847 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   grade_3 73 2 6 4   5     0   6   52 44                       96 73 2 6 4   5     0   6   52 44                 96
1124859 1124859 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_7 229 14 17 4   7     0   19   157 133                       290 229 14 17 4   7     0   19   157 133                 290
1124860 1124860 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_8 228 12 5 4   10     0   19   134 144                       278 228 12 5 4   10     0   19   134 144                 278
1125641 1125641 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2017   grade_10 76 0 2 4   0     0   2   40 44                       84 76 0 2 4   0     0   2   40 44                 84
1126670 1126670 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No Elementary KG 04 2017   grade_1 84 8 61 4   20     0   6   101 82                       183 84 8 61 4   20     0   6   101 82                 183
1126747 1126747 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   grade_12 85 1 5 4   2     0   5   59 43                       102 85 1 5 4   2     0   5   59 43                 102
1126978 1126978 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_6 211 5 10 4   6     0   9   111 134                       245 211 5 10 4   6     0   9   111 134                 245
1126982 1126982 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2017   grade_9 165 2 6 4   1     0   7   96 89                       185 165 2 6 4   1     0   7   96 89                 185
1127011 1127011 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2017   grade_6 228 9 92 4   12     0   11   178 178                       356 228 9 92 4   12     0   11   178 178                 356
1127017 1127017 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2017   grade_11 185 10 82 4   10     1   5   138 159                       297 185 10 82 4   10     1   5   138 159                 297
1127378 1127378 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_8 188 19 104 4   2     2   10   181 148                       329 188 19 104 4   2     2   10   181 148                 329
1127386 1127386 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_11 132 47 184 4   6     3   20   211 185                       396 132 47 184 4   6     3   20   211 185                 396
1127918 1127918 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2017   grade_4 39 1 7 4   1     0   5   30 27                       57 39 1 7 4   1     0   5   30 27                 57
1128261 1128261 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No High 09 12 2017   grade_12 210 3 3 4   2     2   9   130 103                       233 210 3 3 4   2     2   9   130 103                 233
1128497 1128497 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2017   grade_8 89 8 84 4   12     0   3   113 87                       200 89 8 84 4   12     0   3   113 87                 200
1128698 1128698 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_6 223 1 1 4   6     0   1   118 118                       236 223 1 1 4   6     0   1   118 118                 236
1128888 1128888 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten 109 5 22 4   83     0   9   122 110                       232 109 5 22 4   83     0   9   122 110                 232
1129981 1129981 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_8 137 8 13 4   2     0   18   96 86                       182 137 8 13 4   2     0   18   96 86                 182
1131988 1131988 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   grade_2 31 2 10 4   0     0   6   30 23                       53 31 2 10 4   0     0   6   30 23                 53
1132317 1132317 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2017   grade_11 117 5 10 4   3     0   12   76 75                       151 117 5 10 4   3     0   12   76 75                 151
1132826 1132826 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_1 33 0 1 4   0     0   1   23 16                       39 33 0 1 4   0     0   1   23 16                 39
1133025 1133025 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_12 229 16 139 4   82     0   19   251 238                       489 229 16 139 4   82     0   19   251 238                 489
1123302 1123302 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_11 48 27 281 3   6     0   3   212 156                       368 48 27 281 3   6     0   3   212 156                 368
1123303 1123303 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_12 56 30 257 3   6     0   2   192 162                       354 56 30 257 3   6     0   2   192 162                 354
1123313 1123313 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2017   grade_12 11 84 105 3   2     1   6   119 93                       212 11 84 105 3   2     1   6   119 93                 212
1123338 1123338 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_10 73 66 77 3   67     0   7   115 178                       293 73 66 77 3   67     0   7   115 178                 293
1123578 1123578 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_1 23 89 15 3   0     0   10   81 59                       140 23 89 15 3   0     0   10   81 59                 140
1123594 1123594 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2017   grade_3 19 55 75 3   1     0   8   84 77                       161 19 55 75 3   1     0   8   84 77                 161
1123595 1123595 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2017   grade_4 19 69 53 3   2     0   10   80 76                       156 19 69 53 3   2     0   10   80 76                 156
1123702 1123702 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_12 194 622 125 3   23     1   25   444 549                       993 194 622 125 3   23     1   25   444 549                 993
1123972 1123972 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_11 192 155 64 3   60     0   16   262 228                       490 192 155 64 3   60     0   16   262 228                 490
1124599 1124599 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_2 28 1 11 3   0     0   3   19 27                       46 28 1 11 3   0     0   3   19 27                 46
1124624 1124624 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_6 7 12 32 3   2     0   2   31 27                       58 7 12 32 3   2     0   2   31 27                 58
1124687 1124687 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2017   grade_12 156 114 189 3   19     0   5   265 221                       486 156 114 189 3   19     0   5   265 221                 486
1124822 1124822 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_9 344 45 150 3   30     0   25   298 299                       597 344 45 150 3   30     0   25   298 299                 597
1124830 1124830 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   kindergarten 39 3 4 3   0     0   3   30 22                       52 39 3 4 3   0     0   3   30 22                 52
1124834 1124834 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   grade_3 54 1 1 3   0     0   5   37 27                       64 54 1 1 3   0     0   5   37 27                 64
1124863 1124863 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   grade_10 170 7 9 3   9     0   9   97 110                       207 170 7 9 3   9     0   9   97 110                 207
1125173 1125173 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 West Parish   Regular School No Elementary KG 05 2017   grade_4 51 1 1 3   1     0   0   21 36                       57 51 1 1 3   1     0   0   21 36                 57
1126594 1126594 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_10 135 90 97 3   109     0   13   216 231                       447 135 90 97 3   109     0   13   216 231                 447
1126615 1126615 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2017   grade_12 313 5 6 3   11     1   4   169 174                       343 313 5 6 3   11     1   4   169 174                 343
1126719 1126719 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No Elementary PK 05 2017   grade_4 69 0 4 3   2     0   2   33 47                       80 69 0 4 3   2     0   2   33 47                 80
1126732 1126732 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   pre_kindergarten 23 1 1 3   0     0   2   22 8                       30 23 1 1 3   0     0   2   22 8                 30
1126783 1126783 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2017   grade_2 148 2 14 3   5     0   2   102 72                       174 148 2 14 3   5     0   2   102 72                 174
1126797 1126797 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 John J McGlynn Elementary School   Regular School No Elementary PK 05 2017   grade_1 53 10 11 3   10     0   3   39 51                       90 53 10 11 3   10     0   3   39 51                 90
1127374 1127374 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_8 113 48 102 3   4     2   21   146 147                       293 113 48 102 3   4     2   21   146 147                 293
1127376 1127376 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_6 205 32 132 3   6     0   28   211 195                       406 205 32 132 3   6     0   28   211 195                 406
1127384 1127384 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_9 189 86 270 3   3     1   23   317 258                       575 189 86 270 3   3     1   23   317 258                 575
1127387 1127387 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_12 219 66 206 3   7     2   13   251 265                       516 219 66 206 3   7     2   13   251 265                 516
1127542 1127542 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2017   grade_10 362 21 50 3   78     0   23   268 269                       537 362 21 50 3   78     0   23   268 269                 537
1127831 1127831 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary KG 03 2017   grade_2 86 1 1 3   1     0   4   47 49                       96 86 1 1 3   1     0   4   47 49                 96
1128701 1128701 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   grade_8 223 2 2 3   9     1   1   121 120                       241 223 2 2 3   9     1   1   121 120                 241
1129746 1129746 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_7 23 0 9 3   1     0   3   19 20                       39 23 0 9 3   1     0   3   19 20                 39
1129975 1129975 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2017   grade_3 153 22 12 3   2     0   24   93 123                       216 153 22 12 3   2     0   24   93 123                 216
1129980 1129980 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 08 2017   grade_7 148 15 9 3   1     0   15   92 99                       191 148 15 9 3   1     0   15   92 99                 191
1130021 1130021 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2017   grade_9 113 3 21 3   7     0   7   75 79                       154 113 3 21 3   7     0   7   75 79                 154
1130272 1130272 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_4 97 0 0 3   15     0   3   65 53                       118 97 0 0 3   15     0   3   65 53                 118
1130273 1130273 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   grade_5 100 1 0 3   16     0   3   58 65                       123 100 1 0 3   16     0   3   58 65                 123
1130718 1130718 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2017   grade_6 112 12 9 3   10     0   2   66 82                       148 112 12 9 3   10     0   2   66 82                 148
1131057 1131057 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2017   grade_11 82 60 164 3   30     0   10   173 176                       349 82 60 164 3   30     0   10   173 176                 349
1131112 1131112 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_7 14 10 146 3   1     0   0   85 89                       174 14 10 146 3   1     0   0   85 89                 174
1131185 1131185 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   grade_12 14 115 97 3   7     1   10   103 144                       247 14 115 97 3   7     1   10   103 144                 247
1131609 1131609 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   grade_10 169 6 15 3   9     1   11   84 130                       214 169 6 15 3   9     1   11   84 130                 214

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