enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by native_american descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1368797 1368797 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_3 64 7 6 9   1     0   13   45 55 *                     100.0 64 7 6 9   1     0   13   45 55                 100
1370317 1370317 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_11 162 16 322 9   30     0   10   285 264 *                     549.0 162 16 322 9   30     0   10   285 264                 549
1368795 1368795 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_7 107 6 5 8   5     0   16   71 76 *                     147.0 107 6 5 8   5     0   16   71 76                 147
1368798 1368798 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_4 84 6 10 8   2     0   10   60 60 *                     120.0 84 6 10 8   2     0   10   60 60                 120
1368799 1368799 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_5 86 2 8 8   2     0   11   56 61 *                     117.0 86 2 8 8   2     0   11   56 61                 117
1368800 1368800 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_6 97 6 4 8   2     0   6   63 60 *                     123.0 97 6 4 8   2     0   6   63 60                 123
1369020 1369020 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2020   grade_5 199 11 93 8   4     1   17   180 153 *                     333.0 199 11 93 8   4     1   17   180 153                 333
1369021 1369021 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2020   grade_6 197 12 100 8   8     0   12   181 156 *                     337.0 197 12 100 8   8     0   12   181 156                 337
1373251 1373251 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2020   grade_5 164 17 21 8   2     0   28   123 117 *                     240.0 164 17 21 8   2     0   28   123 117                 240
1368803 1368803 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_11 89 5 6 7   4     0   2   51 62 *                     113.0 89 5 6 7   4     0   2   51 62                 113
1369026 1369026 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2020   grade_11 179 14 88 7   4     0   12   152 152 *                     304.0 179 14 88 7   4     0   12   152 152                 304
1369027 1369027 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2020   grade_12 192 3 60 7   9     0   8   128 151 *                     279.0 192 3 60 7   9     0   8   128 151                 279
1373252 1373252 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_6 133 29 44 7   4     1   12   119 111 *                     230.0 133 29 44 7   4     1   12   119 111                 230
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
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
1373949 1373949 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_1 25 0 4 5   0     0   3   23 14 *                     37.0 25 0 4 5   0     0   3   23 14                 37
1364986 1364986 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2020   grade_5 156 7 26 4   30     0   4   113 114 *                     227.0 156 7 26 4   30     0   4   113 114                 227
1364987 1364987 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_6 150 4 32 4   30     0   9   118 111 *                     229.0 150 4 32 4   30     0   9   118 111                 229
1365094 1365094 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_6 242 24 78 4   8     1   18   202 173 *                     375.0 242 24 78 4   8     1   18   202 173                 375
1366064 1366064 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_6 149 5 8 4   4     0   4   80 94 *                     174.0 149 5 8 4   4     0   4   80 94                 174
1366242 1366242 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_10 144 547 130 4   22     2   41   449 441 *                     890.0 144 547 130 4   22     2   41   449 441                 890
1366243 1366243 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_11 174 559 117 4   19     4   31   475 433 *                     908.0 174 559 117 4   19     4   31   475 433                 908
1366998 1366998 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson Olmsted School   Regular School No Elementary 03 05 2020   grade_3 189 19 25 4   6     1   5   126 123 *                     249.0 189 19 25 4   6     1   5   126 123                 249
1367088 1367088 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_9 90 86 281 4   24     0   8   251 242 *                     493.0 90 86 281 4   24     0   8   251 242                 493
1367239 1367239 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_9 207 13 14 4   2     0   12   130 121 *                     252.0 207 13 14 4   2     0   12   130 121                 252
1368593 1368593 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2020   grade_10 102 35 318 4   47     0   19   272 253 *                     525.0 102 35 318 4   47     0   19   272 253                 525
1368682 1368682 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   grade_10 103 103 133 4   98     0   13   225 229 *                     454.0 103 103 133 4   98     0   13   225 229                 454
1369338 1369338 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_10 214 107 288 4   7     1   31   350 302 *                     652.0 214 107 288 4   7     1   31   350 302                 652
1369339 1369339 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_11 153 106 233 4   6     2   28   263 269 *                     532.0 153 106 233 4   6     2   28   263 269                 532
1370464 1370464 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Oaklandvale   Regular School No Elementary KG 05 2020   grade_5 25 2 14 4   3     0   3   28 23 *                     51.0 25 2 14 4   3     0   3   28 23                 51
1370587 1370587 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2020   grade_2 57 11 18 4   77     0   13   102 78 *                     180.0 57 11 18 4   77     0   13   102 78                 180
1371298 1371298 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   grade_8 427 122 83 4   8     1   45   356 334 *                     690.0 427 122 83 4   8     1   45   356 334                 690
1371375 1371375 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2020   grade_7 118 1 8 4   2     0   1   66 68 *                     134.0 118 1 8 4   2     0   1   66 68                 134
1371530 1371530 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2020   grade_4 115 12 23 4   1     0   18   94 79 *                     173.0 115 12 23 4   1     0   18   94 79                 173
1372456 1372456 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_9 26 14 130 4   2     2   0   83 95 *                     178.0 26 14 130 4   2     2   0   83 95                 178
1373249 1373249 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2020   grade_3 66 10 6 4   4     1   5   54 42 *                     96.0 66 10 6 4   4     1   5   54 42                 96
1373250 1373250 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2020   grade_4 166 23 28 4   9     0   25   140 115 *                     255.0 166 23 28 4   9     0   25   140 115                 255
1373520 1373520 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2020   grade_10 93 10 42 4   2     1   5   97 60 *                     157.0 93 10 42 4   2     1   5   97 60                 157
1374085 1374085 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 298 10 23 4   2     0   15   212 140 *                     352.0 298 10 23 4   2     0   15   212 140                 352
1374088 1374088 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 2020   grade_9 113 16 21 4   1     0   7   98 63 *                     162.0 113 16 21 4   1     0   7   98 63                 162
1374117 1374117 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_9 86 15 98 4   4     0   7   125 89 *                     214.0 86 15 98 4   4     0   7   125 89                 214
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
1364925 1364925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_9 321 8 27 3   84     0   12   208 247 *                     455.0 321 8 27 3   84     0   12   208 247                 455
1365080 1365080 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   kindergarten 23 10 22 3   4     0   4   40 26 *                     66.0 23 10 22 3   4     0   4   40 26                 66
1365318 1365318 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten 0 29 12 3   1     0   1   25 21 *                     46.0 0 29 12 3   1     0   1   25 21                 46
1366065 1366065 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_7 140 3 12 3   2     0   6   94 72 *                     166.0 140 3 12 3   2     0   6   94 72                 166
1366066 1366066 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_8 150 2 9 3   2     0   5   86 85 *                     171.0 150 2 9 3   2     0   5   86 85                 171
1366235 1366235 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_6 55 100 30 3   10     0   5   117 86 *                     203.0 55 100 30 3   10     0   5   117 86                 203
1366241 1366241 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_9 169 865 231 3   29     3   52   766 586 *                     1352.0 169 865 231 3   29     3   52   766 586                 1352
1366482 1366482 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_12 189 140 69 3   61     1   31   249 245 *                     494.0 189 140 69 3   61     1   31   249 245                 494
1366905 1366905 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2020   grade_9 166 15 16 3   19     0   6   118 107 *                     225.0 166 15 16 3   19     0   6   118 107                 225
1366907 1366907 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2020   grade_11 163 19 19 3   20     0   6   119 111 *                     230.0 163 19 19 3   20     0   6   119 111                 230
1367015 1367015 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_5 34 3 16 3   0     0   3   24 35 *                     59.0 34 3 16 3   0     0   3   24 35                 59
1367089 1367089 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_10 103 99 298 3   24     0   7   274 260 *                     534.0 103 99 298 3   24     0   7   274 260                 534
1367206 1367206 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2020   grade_12 275 34 120 3   27     1   18   227 251 *                     478.0 275 34 120 3   27     1   18   227 251                 478
1367217 1367217 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   grade_3 34 1 3 3   0     0   3   24 20 *                     44.0 34 1 3 3   0     0   3   24 20                 44
1367507 1367507 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_7 173 2 21 3   1     0   2   86 116 *                     202.0 173 2 21 3   1     0   2   86 116                 202
1367785 1367785 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2020   grade_9 161 3 15 3   16     0   5   110 93 *                     203.0 161 3 15 3   16     0   5   110 93                 203
1368571 1368571 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Edward A Sisson   Regular School No Elementary PK 05 2020   kindergarten 16 3 28 3   6     0   7   29 34 *                     63.0 16 3 28 3   6     0   7   29 34                 63
1368589 1368589 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_6 76 12 106 3   19     0   9   113 112 *                     225.0 76 12 106 3   19     0   9   113 112                 225
1368612 1368612 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_10 37 18 193 3   18     0   7   152 123 *                     276.0 37 18 193 3   18     0   7   152 123                 276
1368793 1368793 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_1 60 3 13 3   1     0   15   48 47 *                     95.0 60 3 13 3   1     0   15   48 47                 95
1368804 1368804 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_12 81 7 6 3   3     0   6   57 49 *                     106.0 81 7 6 3   3     0   6   57 49                 106
1368831 1368831 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2020   grade_5 165 2 12 3   7     0   5   115 79 *                     194.0 165 2 12 3   7     0   5   115 79                 194
1368864 1368864 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2020   grade_1 55 10 10 3   8     0   4   43 47 *                     90.0 55 10 10 3   8     0   4   43 47                 90
1368984 1368984 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_2 94 3 3 3   1     0   5   62 47 *                     109.0 94 3 3 3   1     0   5   62 47                 109
1368996 1368996 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2020   grade_7 233 11 7 3   0     0   7   131 130 *                     261.0 233 11 7 3   0     0   7   131 130                 261
1368998 1368998 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2020   grade_9 186 7 10 3   5     0   10   109 112 *                     221.0 186 7 10 3   5     0   10   109 112                 221
1369006 1369006 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2020   pre_kindergarten 66 1 3 3   2     0   0   42 33 *                     75.0 66 1 3 3   2     0   0   42 33                 75
1369332 1369332 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2020   grade_7 174 44 162 3   2     0   27   212 200 *                     412.0 174 44 162 3   2     0   27   212 200                 412
1369337 1369337 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_9 269 89 331 3   4     0   37   377 355 *                     733.0 269 89 331 3   4     0   37   377 355                 733
1370186 1370186 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No High 09 12 2020   grade_11 221 39 32 3   89     1   16   194 206 *                     401.0 221 39 32 3   89     1   16   194 206                 401
1370451 1370451 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2020   grade_11 148 0 2 3   4     1   0   73 85 *                     158.0 148 0 2 3   4     1   0   73 85                 158
1370979 1370979 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2020   pre_kindergarten 7 22 72 3   0     0   3   53 54 *                     107.0 7 22 72 3   0     0   3   53 54                 107
1371295 1371295 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2020   grade_5 166 37 42 3   3     0   10   124 137 *                     261.0 166 37 42 3   3     0   10   124 137                 261
1371453 1371453 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No High 09 12 2020   grade_9 215 2 11 3   9     0   6   125 121 *                     246.0 215 2 11 3   9     0   6   125 121                 246
1371525 1371525 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2020   kindergarten 138 11 16 3   2     0   28   96 102 *                     198.0 138 11 16 3   2     0   28   96 102                 198
1371532 1371532 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2020   grade_6 128 15 11 3   2     0   31   87 103 *                     190.0 128 15 11 3   2     0   31   87 103                 190
1371571 1371571 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2020   grade_12 110 6 22 3   5     0   8   81 73 *                     154.0 110 6 22 3   5     0   8   81 73                 154
1372123 1372123 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 253 86 23 3   13     0   15   191 202 *                     393.0 253 86 23 3   13     0   15   191 202                 393
1372660 1372660 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_1 18 61 31 3   2     0   5   54 66 *                     120.0 18 61 31 3   2     0   5   54 66                 120
1372931 1372931 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes High 09 12 2020   grade_9 5 13 144 3   0     0   0   85 80 *                     165.0 5 13 144 3   0     0   0   85 80                 165
1372943 1372943 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2020   grade_8 26 13 14 3   2     0   2   33 27 *                     60.0 26 13 14 3   2     0   2   33 27                 60
1373111 1373111 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2020   grade_10 55 5 10 3   2     1   6   43 39 *                     82.0 55 5 10 3   2     1   6   43 39                 82
1373240 1373240 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   grade_3 45 7 11 3   0     0   7   40 33 *                     73.0 45 7 11 3   0     0   7   40 33                 73

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