Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by native_american_int descending

View and edit SQL

year

  • 2021 · 9,536
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
1676271 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_8 202 6 113 13   5     0   16   185 170 *                     355.0 202 6 113 13   5     0   16   185 170                 355
1676052 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee - Mashpee High   Regular School No High 09 12 2021   grade_10 92 9 2 10   3     0   6   59 63 *                     122.0 92 9 2 10   3     0   6   59 63                 122
1674471 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_7 197 9 15 9   3     0   20   131 122 *                     253.0 197 9 15 9   3     0   20   131 122                 253
1676048 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_4 62 7 7 9   1     0   11   44 53 *                     97.0 62 7 7 9   1     0   11   44 53                 97
1677566 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere - Revere High   Regular School No High 09 12 2021   grade_12 148 17 258 9   31     0   9   239 233 *                     472.0 148 17 258 9   31     0   9   239 233                 472
1679385 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester - Head Start   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 155 106 22 9   14     0   13   157 162 *                     319.0 155 106 22 9   14     0   13   157 162                 319
1676045 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_7 89 5 5 8   2     0   6   58 57 *                     115.0 89 5 5 8   2     0   6   58 57                 115
1676046 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_8 101 6 5 8   5     0   16   69 72 *                     141.0 101 6 5 8   5     0   16   69 72                 141
1676049 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_5 82 7 10 8   1     0   11   57 62 *                     119.0 82 7 10 8   1     0   11   57 62                 119
1680514 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_4 148 25 20 8   5     2   20   130 98 *                     228.0 148 25 20 8   5     2   20   130 98                 228
1676050 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_6 84 4 9 7   2     0   13   58 61 *                     119.0 84 4 9 7   2     0   13   58 61                 119
1676054 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee - Mashpee High   Regular School No High 09 12 2021   grade_12 94 5 7 7   4     0   2   55 64 *                     119.0 94 5 7 7   4     0   2   55 64                 119
1676269 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_6 204 9 86 7   4     1   19   175 155 *                     330.0 204 9 86 7   4     1   19   175 155                 330
1676270 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_7 199 14 107 7   8     0   12   183 164 *                     347.0 199 14 107 7   8     0   12   183 164                 347
1680518 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth - Mattacheese Middle School   Regular School No Middle 06 07 2021   grade_7 131 31 45 7   4     1   13   122 110 *                     232.0 131 31 45 7   4     1   13   122 110                 232
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 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 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 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 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
1673301 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_7 140 3 9 5   3     0   5   73 92 *                     165.0 140 3 9 5   3     0   5   73 92                 165
1675835 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn - Classical High   Regular School No High 09 12 2021   grade_11 93 30 272 5   43     0   19   230 232 *                     462.0 93 30 272 5   43     0   19   230 232                 462
1676047 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_3 78 2 4 5   1     0   15   67 38 *                     105.0 78 2 4 5   1     0   15   67 38                 105
1676273 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford - Milford High   Regular School No High 09 12 2021   grade_10 196 11 117 5   8     0   11   180 166 *                     348.0 196 11 117 5   8     0   11   180 166                 348
1676587 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_10 263 97 352 5   4     0   35   397 359 *                     756.0 263 97 352 5   4     0   35   397 359                 756
1677730 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus - Saugus Middle School   Regular School No Middle 06 08 2021   grade_6 109 10 58 5   9     1   8   101 99 *                     200.0 109 10 58 5   9     1   8   101 99                 200
1677838 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_2 57 6 10 5   93     0   9   93 87 *                     180.0 57 6 10 5   93     0   9   93 87                 180
1678552 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_9 314 122 79 5   5     2   38   293 272 *                     565.0 314 122 79 5   5     2   38   293 272                 565
1680523 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth - Dennis-Yarmouth Regional High   Regular School No High 08 12 2021   grade_12 114 18 25 5   6     0   10   92 86 *                     178.0 114 18 25 5   6     0   10   92 86                 178
1680785 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard - Martha's Vineyard Regional High   Regular School No High 09 12 2021   grade_11 95 11 44 5   2     1   4   99 63 *                     162.0 95 11 44 5   2     1   4   99 63                 162
1680786 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard - Martha's Vineyard Regional High   Regular School No High 09 12 2021   grade_12 115 7 32 5   3     1   5   89 79 *                     168.0 115 7 32 5   3     1   5   89 79                 168
1681198 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_2 26 0 5 5   0     0   4   22 18 *                     40.0 26 0 5 5   0     0   4   22 18                 40
1681365 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_9 123 6 81 5   4     0   7   116 109 *                     226.0 123 6 81 5   4     0   7   116 109                 226
1681367 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_11 96 9 92 5   2     0   8   127 85 *                     212.0 96 9 92 5   2     0   8   127 85                 212
1672013 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   grade_2 128 8 13 4   5     0   3   85 76 *                     161.0 128 8 13 4   5     0   3   85 76                 161
1672319 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_7 225 24 73 4   8     1   16   189 162 *                     351.0 225 24 73 4   8     1   16   189 162                 351
1673477 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_12 166 561 110 4   19     4   31   471 424 *                     895.0 166 561 110 4   19     4   31   471 424                 895
1674228 MA Bristol   school 2504620 88   Easton 250462000983 880025 Easton - Richardson Olmsted School   Regular School No Elementary 03 05 2021   grade_4 190 17 27 4   6     1   3   120 128 *                     248.0 190 17 27 4   6     1   3   120 128                 248
1674245 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown - Edgartown Elementary   Regular School No Elementary PK 08 2021   grade_6 32 3 14 4   1     0   1   26 29 *                     55.0 32 3 14 4   1     0   1   26 29                 55
1674319 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_9 103 79 329 4   31     1   9   272 284 *                     556.0 103 79 329 4   31     1   9   272 284                 556
1674320 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_10 94 85 307 4   26     0   10   270 256 *                     526.0 94 85 307 4   26     0   10   270 256                 526
1675839 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_11 46 49 390 4   39     0   8   275 261 *                     536.0 46 49 390 4   39     0   8   275 261                 536
1676041 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   kindergarten 65 5 6 4   3     1   9   48 45 *                     93.0 65 5 6 4   3     1   9   48 45                 93
1676044 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   grade_2 56 4 12 4   1     0   14   49 42 *                     91.0 56 4 12 4   1     0   14   49 42                 91
1676053 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee - Mashpee High   Regular School No High 09 12 2021   grade_11 80 7 4 4   2     1   8   57 49 *                     106.0 80 7 4 4   2     1   8   57 49                 106
1676246 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough - Middleborough High   Regular School No High 09 12 2021   grade_9 184 5 6 4   5     0   9   113 100 *                     213.0 184 5 6 4   5     0   9   113 100                 213
1676582 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford - Normandin Middle School   Regular School No Middle 06 08 2021   grade_8 174 41 149 4   1     0   23   203 189 *                     392.0 174 41 149 4   1     0   23   203 189                 392
1676589 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_12 155 109 235 4   8     2   26   274 265 *                     539.0 155 109 235 4   8     2   26   274 265                 539
1677839 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_3 53 8 20 4   76     0   11   93 79 *                     172.0 53 8 20 4   76     0   11   93 79                 172
1678551 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_8 426 113 92 4   5     2   33   337 338 *                     675.0 426 113 92 4   5     2   33   337 338                 675
1678627 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge - Uxbridge High   Regular School No High 08 12 2021   grade_8 126 1 8 4   3     0   1   70 73 *                     143.0 126 1 8 4   3     0   1   70 73                 143
1678783 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham - Wareham Middle   Regular School No Middle 05 07 2021   grade_5 110 10 22 4   2     0   18   88 78 *                     166.0 110 10 22 4   2     0   18   88 78                 166
1678791 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham - Wareham Senior High   Regular School No High 08 12 2021   grade_9 78 11 15 4   0     0   23   67 64 *                     131.0 78 11 15 4   0     0   23   67 64                 131
1679362 MA Middlesex   school 2513200 347   Woburn 251320002188 3470055 Woburn - Malcolm White   Regular School No Elementary KG 05 2021   kindergarten 26 2 2 4   2     0   0   19 17 *                     36.0 26 2 2 4   2     0   0   19 17                 36
1679923 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   kindergarten 16 60 7 4   8     0   22   49 68 *                     117.0 16 60 7 4   8     0   22   49 68                 117
1681334 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Regional Vocational Technical - Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2021   grade_11 285 10 19 4   2     0   14   199 135 *                     334.0 285 10 19 4   2     0   14   199 135                 334
1681336 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 2021   grade_9 128 14 16 4   1     1   10   103 70 *                     174.0 128 14 16 4   1     1   10   103 70                 174
1681337 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 2021   grade_10 117 15 21 4   1     0   10   98 69 *                     168.0 117 15 21 4   1     0   10   98 69                 168
1681349 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Greater Fall River Regional Vocational Technical - Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2021   grade_10 277 11 48 4   9     0   18   213 154 *                     367.0 277 11 48 4   9     0   18   213 154                 367
1681356 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical - Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 349 43 131 4   7     1   32   306 261 *                     567.0 349 43 131 4   7     1   32   306 261                 567
1681366 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_10 81 16 92 4   4     0   7   121 82 *                     204.0 81 16 92 4   4     0   7   121 82                 204
1681422 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational Technical - Whittier Regional Vocational   Career and Technical School No High 09 12 2021   grade_10 227 7 92 4   6     0   5   179 162 *                     341.0 227 7 92 4   6     0   5   179 162                 341
1672210 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_6 158 7 27 3   29     0   5   115 114 *                     229.0 158 7 27 3   29     0   5   115 114                 229
1672211 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_7 143 6 35 3   28     0   9   118 106 *                     224.0 143 6 35 3   28     0   9   118 106                 224
1672289 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_7 28 14 5 3   4     0   5   33 26 *                     59.0 28 14 5 3   4     0   5   33 26                 59
1672305 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_1 25 9 24 3   4     0   3   38 30 *                     68.0 25 9 24 3   4     0   3   38 30                 68
1673302 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_8 132 3 10 3   2     0   7   88 69 *                     157.0 132 3 10 3   2     0   7   88 69                 157
1673303 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_9 84 1 4 3   2     0   4   49 49 *                     98.0 84 1 4 3   2     0   4   49 49                 98
1673475 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_10 132 759 198 3   27     2   50   651 520 *                     1171.0 132 759 198 3   27     2   50   651 520                 1171
1673476 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_11 131 580 128 3   22     2   39   450 455 *                     905.0 131 580 128 3   22     2   39   450 455                 905
1673608 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington - Burlington High   Regular School No High 09 12 2021   grade_9 133 14 15 3   35     0   5   105 100 *                     205.0 133 14 15 3   35     0   5   105 100                 205
1674135 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut - Dracut Senior High   Regular School No High 09 12 2021   grade_10 151 18 16 3   19     0   7   112 102 *                     214.0 151 18 16 3   19     0   7   112 102                 214
1674137 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut - Dracut Senior High   Regular School No High 09 12 2021   grade_12 159 22 19 3   20     0   6   119 110 *                     229.0 159 22 19 3   20     0   6   119 110                 229
1674321 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_11 99 103 287 3   25     0   7   273 251 *                     524.0 99 103 287 3   25     0   7   273 251                 524
1674337 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven - Hastings Middle   Regular School No Middle 06 08 2021   grade_6 133 4 9 3   2     0   9   78 82 *                     160.0 133 4 9 3   2     0   9   78 82                 160
1674549 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_5 129 8 12 3   7     0   5   81 83 *                     164.0 129 8 12 3   7     0   5   81 83                 164
1675814 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Lynn - Edward A Sisson   Regular School No Elementary PK 05 2021   grade_1 19 2 31 3   7     0   8   34 36 *                     70.0 19 2 31 3   7     0   8   34 36                 70
1675831 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn - Pickering Middle   Regular School No Middle 06 08 2021   grade_7 76 10 99 3   19     0   9   112 104 *                     216.0 76 10 99 3   19     0   9   112 104                 216
1675854 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   grade_11 35 15 191 3   17     0   6   147 120 *                     267.0 35 15 191 3   17     0   6   147 120                 267
1676085 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield - Thomas Blake Middle   Regular School No Middle 06 08 2021   grade_6 162 2 11 3   8     0   5   113 78 *                     191.0 162 2 11 3   8     0   5   113 78                 191
1676245 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough - John T. Nichols Middle   Regular School No Middle 06 08 2021   grade_8 237 11 7 3   0     0   7   134 131 *                     265.0 237 11 7 3   0     0   7   134 131                 265
1676247 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough - Middleborough High   Regular School No High 09 12 2021   grade_10 177 7 10 3   5     0   8   103 107 *                     210.0 177 7 10 3   5     0   8   103 107                 210
1676262 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Milford - Brookside   Regular School No Elementary KG 02 2021   kindergarten 93 5 42 3   1     0   7   86 65 *                     151.0 93 5 42 3   1     0   7   86 65                 151
1676267 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford - Woodland   Regular School No Elementary 03 05 2021   grade_4 198 14 96 3   3     1   9   164 160 *                     324.0 198 14 96 3   3     1   9   164 160                 324
1676268 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford - Woodland   Regular School No Elementary 03 05 2021   grade_5 194 11 103 3   7     0   14   171 161 *                     332.0 194 11 103 3   7     0   14   171 161                 332
1676580 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford - Normandin Middle School   Regular School No Middle 06 08 2021   grade_6 176 28 117 3   2     0   19   171 174 *                     345.0 176 28 117 3   2     0   19   171 174                 345
1676588 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_11 216 109 298 3   7     2   36   359 311 *                     671.0 216 109 298 3   7     2   36   359 311                 671
1677435 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy - Quincy High   Regular School No High 09 12 2021   grade_12 201 37 48 3   96     1   12   190 208 *                     398.0 201 37 48 3   96     1   12   190 208                 398
1677563 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere - Revere High   Regular School No High 09 12 2021   grade_9 147 24 337 3   23     0   8   281 261 *                     542.0 147 24 337 3   23     0   8   281 261                 542
1677703 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich - Sandwich High   Regular School No High 09 12 2021   grade_12 145 0 3 3   4     1   0   72 84 *                     156.0 145 0 3 3   4     1   0   72 84                 156
1678365 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham - Stoneham High   Regular School No High 09 12 2021   grade_10 117 3 8 3   7     0   7   76 69 *                     145.0 117 3 8 3   7     0   7   76 69                 145
1678549 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton - Benjamin Friedman Middle   Regular School No Middle 05 07 2021   grade_6 164 36 41 3   3     0   9   123 133 *                     256.0 164 36 41 3   3     0   9   123 133                 256
1678622 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge - Taft Early Learning Center   Regular School No Elementary PK 03 2021   grade_3 115 2 6 3   0     0   2   66 62 *                     128.0 115 2 6 3   0     0   2   66 62                 128
1678779 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham - John William Decas   Regular School No Elementary PK 02 2021   grade_1 124 7 18 3   1     0   31   91 93 *                     184.0 124 7 18 3   1     0   31   91 93                 184
1678785 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham - Wareham Middle   Regular School No Middle 05 07 2021   grade_7 126 14 12 3   2     0   30   84 103 *                     187.0 126 14 12 3   2     0   30   84 103                 187
1679381 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn - Woburn High   Regular School No High 09 12 2021   grade_10 208 13 36 3   20     0   8   143 145 *                     288.0 208 13 36 3   20     0   8   143 145                 288
1679716 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_5 20 10 137 3   2     0   2   88 86 *                     174.0 20 10 137 3   2     0   2   88 86                 174
1679721 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District) - Excel Academy Charter School   Regular School Yes High 05 12 2021   grade_10 25 14 128 3   2     2   0   81 93 *                     174.0 25 14 128 3   2     2   0   81 93                 174
1679925 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_2 17 62 31 3   2     0   5   56 64 *                     120.0 17 62 31 3   2     0   5   56 64                 120
1680175 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District) - Sturgis Charter Public School   Regular School Yes High 09 12 2021   grade_11 184 5 18 3   3     0   3   97 118 *                     216.0 184 5 18 3   3     0   3   97 118                 216

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