enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by native_american descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
932850 932850 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_12 278 22 27 6   15     0   12   171 189                       360 278 22 27 6   15     0   12   171 189                 360
935007 935007 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_9 183 10 5 6   9     0   10   101 122                       223 183 10 5 6   9     0   10   101 122                 223
936570 936570 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_8 103 6 4 6   3     0   5   65 62                       127 103 6 4 6   3     0   5   65 62                 127
936572 936572 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_4 85 2 4 6   2     0   5   62 42                       104 85 2 4 6   2     0   5   62 42                 104
936578 936578 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2016   grade_12 75 2 7 6   2     1   4   41 56                       97 75 2 7 6   2     1   4   41 56                 97
936774 936774 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No 2 06 08 2016   grade_8 229 3 10 6   0     0   7   129 126                       255 229 3 10 6   0     0   7   129 126                 255
936798 936798 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 08 2016   grade_7 209 9 72 6   5     0   10   163 148                       311 209 9 72 6   5     0   10   163 148                 311
941022 941022 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No 2 04 05 2016   grade_4 174 20 32 6   4     1   12   115 134                       249 174 20 32 6   4     1   12   115 134                 249
941864 941864 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 104 6 14 6   1     1   9   85 56                       141 104 6 14 6   1     1   9   85 56                 141
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
1368794 1368794 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_2 83 2 4 6   1     0   15   68 43 *                     111.0 83 2 4 6   1     0   15   68 43                 111
1368796 1368796 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_8 85 4 4 6   3     0   7   59 50 *                     109.0 85 4 4 6   3     0   7   59 50                 109
1368802 1368802 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_10 86 5 5 6   3     1   10   64 52 *                     116.0 86 5 5 6   3     1   10   64 52                 116
1369001 1369001 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2020   grade_12 158 3 5 6   0     0   6   93 85 *                     178.0 158 3 5 6   0     0   6   93 85                 178
1369023 1369023 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2020   grade_8 212 6 95 6   5     0   7   184 147 *                     331.0 212 6 95 6   5     0   7   184 147                 331
1373253 1373253 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_7 158 22 36 6   6     0   10   113 125 *                     238.0 158 22 36 6   6     0   10   113 125                 238
1374118 1374118 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2020   grade_10 95 9 100 6   2     0   8   137 83 *                     220.0 95 9 100 6   2     0   8   137 83                 220
1676051 1676051 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee - Mashpee High   Regular School No High 09 12 2021   grade_9 72 3 2 6   3     0   9   56 39 *                     95.0 72 3 2 6   3     0   9   56 39                 95
1676272 1676272 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford - Milford High   Regular School No High 09 12 2021   grade_9 180 8 103 6   5     0   7   177 132 *                     309.0 180 8 103 6   5     0   7   177 132                 309
1676275 1676275 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford - Milford High   Regular School No High 09 12 2021   grade_12 167 14 77 6   4     0   12   140 140 *                     280.0 167 14 77 6   4     0   12   140 140                 280
1680517 1680517 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth - Mattacheese Middle School   Regular School No Middle 06 07 2021   grade_6 129 16 22 6   2     0   24   99 100 *                     199.0 129 16 22 6   2     0   24   99 100                 199
1680519 1680519 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth - Dennis-Yarmouth Regional High   Regular School No High 08 12 2021   grade_8 151 21 33 6   6     0   11   115 113 *                     228.0 151 21 33 6   6     0   11   115 113                 228
2043864 2043864 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_1 85 2 4 6   3     0   14   66 48                       114.0 85 2 4 6   3     0   14   66 48                 114
2043866 2043866 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_7 89 4 2 6   3     0   7   66 45                       111.0 89 4 2 6   3     0   7   66 45                 111
2044093 2044093 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_7 214 8 89 6   6     0   10   183 150                       333.0 214 8 89 6   6     0   10   183 150                 333
2044098 2044098 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_12 171 5 65 6   11     0   4   131 131                       262.0 171 5 65 6   11     0   4   131 131                 262
2048314 2048314 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2019   grade_6 160 19 32 6   6     0   12   119 116                       235.0 160 19 32 6   6     0   12   119 116                 235
2048318 2048318 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_10 126 15 26 6   4     1   9   100 87                       187.0 126 15 26 6   4     1   9   100 87                 187
2048582 2048582 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2019   grade_10 121 9 26 6   3     1   5   85 86                       171.0 121 9 26 6   3     1   5   85 86                 171
2230514 2230514 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   grade_10 167 642 144 6   27     2   34   556 466                       1022.0 167 642 144 6   27     2   34   556 466                 1022
2233303 2233303 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_8 53 40 291 6   35     0   15   227 213                       440.0 53 40 291 6   35     0   15   227 213                 440
2233558 2233558 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   grade_8 105 4 4 6   3     1   7   71 59                       130.0 105 4 4 6   3     1   7   71 59                 130
2233832 2233832 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_9 181 11 77 6   5     0   11   149 142                       291.0 181 11 77 6   5     0   11   149 142                 291
2238828 2238828 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth: N H Wixon Innovation School   Regular School No Elementary 04 05 2018   grade_5 194 21 30 6   7     0   13   136 135                       271.0 194 21 30 6   7     0   13   136 135                 271
2238834 2238834 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_8 154 26 29 6   4     0   11   113 117                       230.0 154 26 29 6   4     0   11   113 117                 230
2238835 2238835 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_9 132 16 19 6   4     1   11   109 80                       189.0 132 16 19 6   4     1   11   109 80                 189
2239809 2239809 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical: Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2018   grade_11 97 7 16 6   2     1   9   87 51                       138.0 97 7 16 6   2     1   9   87 51                 138
735973 735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
737072 737072 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2015   grade_1 24 62 78 5   1     0   10   94 86                       180 24 62 78 5   1     0   10   94 86                 180
738135 738135 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_1 35 2 1 5   1     0   4   26 22                       48 35 2 1 5   1     0   4   26 22                 48
738155 738155 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_11 159 8 4 5   9     1   5   95 96                       191 159 8 4 5   9     1   5   95 96                 191
739722 739722 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   pre_kindergarten 68 4 6 5   3     0   6   51 41                       92 68 4 6 5   3     0   6   51 41                 92
739725 739725 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_7 101 6 4 5   5     0   6   66 61                       127 101 6 4 5   5     0   6   66 61                 127
739732 739732 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_10 90 1 4 5   2     0   7   64 45                       109 90 1 4 5   2     0   7   64 45                 109
739945 739945 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   grade_2 84 3 50 5   5     0   9   87 69                       156 84 3 50 5   5     0   9   87 69                 156
739956 739956 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_9 185 8 80 5   11     1   6   136 160                       296 185 8 80 5   11     1   6   136 160                 296
739959 739959 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_12 226 4 29 5   13     0   1   138 140                       278 226 4 29 5   13     0   1   138 140                 278
740732 740732 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_2 38 1 8 5   1     0   5   27 31                       58 38 1 8 5   1     0   5   27 31                 58
742924 742924 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2015   grade_12 380 19 27 5   11     0   4   204 242                       446 380 19 27 5   11     0   4   204 242                 446
743380 743380 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No 3 09 12 2015   grade_12 151 51 81 5   30     0   8   160 166                       326 151 51 81 5   30     0   8   160 166                 326
743416 743416 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_5 14 10 136 5   2     0   0   80 87                       167 14 10 136 5   2     0   0   80 87                 167
744193 744193 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   grade_1 89 7 6 5   2     0   9   59 59                       118 89 7 6 5   2     0   9   59 59                 118
744197 744197 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No 2 04 05 2015   grade_5 188 25 23 5   5     0   11   128 129                       257 188 25 23 5   5     0   11   128 129                 257
745129 745129 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 153 5 7 5   2     0   0   97 75                       172 153 5 7 5   2     0   0   97 75                 172
932735 932735 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   grade_2 156 2 19 5   29     0   8   116 103                       219 156 2 19 5   29     0   8   116 103                 219
932849 932849 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_11 280 34 43 5   11     0   14   185 202                       387 280 34 43 5   11     0   14   185 202                 387
933699 933699 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   grade_11 13 90 117 5   1     1   7   131 103                       234 13 90 117 5   1     1   7   131 103                 234
934024 934024 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_9 267 694 166 5   26     3   51   637 575                       1212 267 694 166 5   26     3   51   637 575                 1212
935010 935010 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_12 145 7 5 5   9     1   4   83 93                       176 145 7 5 5   9     1   4   83 93                 176
936356 936356 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_6 52 37 259 5   37     0   15   213 192                       405 52 37 259 5   37     0   15   213 192                 405
936359 936359 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_6 67 46 254 5   59     0   17   225 223                       448 67 46 254 5   59     0   17   225 223                 448
936512 936512 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No 1 KG 04 2016   kindergarten 88 9 51 5   17     0   6   98 78                       176 88 9 51 5   17     0   6   98 78                 176
936566 936566 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   pre_kindergarten 61 7 4 5   1     1   2   46 35                       81 61 7 4 5   1     1   2   46 35                 81
936802 936802 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2016   grade_9 183 6 60 5   9     0   2   138 127                       265 183 6 60 5   9     0   2   138 127                 265
937115 937115 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_11 284 93 276 5   6     3   28   351 344                       695 284 93 276 5   6     3   28   351 344                 695
939279 939279 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2016   grade_2 150 18 6 5   2     0   21   86 116                       202 150 18 6 5   2     0   21   86 116                 202
940235 940235 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_5 25 14 117 5   2     2   0   73 92                       165 25 14 117 5   2     2   0   73 92                 165
941024 941024 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2016   grade_6 163 28 27 5   3     0   11   119 118                       237 163 28 27 5   3     0   11   119 118                 237
941289 941289 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2016   grade_12 115 4 19 5   2     0   6   76 75                       151 115 4 19 5   2     0   6   76 75                 151
941866 941866 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2016   grade_11 116 9 13 5   1     0   4   89 59                       148 116 9 13 5   1     0   4   89 59                 148
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
1366244 1366244 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_12 138 598 111 5   28     0   29   473 436 *                     909.0 138 598 111 5   28     0   29   473 436                 909
1368597 1368597 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_10 56 52 413 5   40     0   10   301 275 *                     576.0 56 52 413 5   40     0   10   301 275                 576
1368997 1368997 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2020   grade_8 229 5 8 5   6     0   10   137 126 *                     263.0 229 5 8 5   6     0   10   137 126                 263
1369024 1369024 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2020   grade_9 195 8 123 5   8     0   15   184 168 *                     354.0 195 8 123 5   8     0   15   184 168                 354
1369340 1369340 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_12 153 85 214 5   7     1   19   248 236 *                     484.0 153 85 214 5   7     1   19   248 236                 484
1371539 1371539 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No High 08 12 2020   grade_9 102 12 10 5   0     0   17   76 69 *                     146.0 102 12 10 5   0     0   17   76 69                 146
1372119 1372119 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2020   grade_9 209 13 32 5   18     0   6   140 143 *                     283.0 209 13 32 5   18     0   6   140 143                 283
1373254 1373254 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_8 140 17 35 5   4     0   16   108 109 *                     217.0 140 17 35 5   4     0   16   108 109                 217
1373257 1373257 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_11 119 16 23 5   5     0   8   98 78 *                     176.0 119 16 23 5   5     0   8   98 78                 176
1373521 1373521 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2020   grade_11 118 8 31 5   3     1   5   88 83 *                     171.0 118 8 31 5   3     1   5   88 83                 171

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