Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1367392 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 87 2 1 0   10     6   5   67 44 *                     111.0 87 2 1 0   10     6   5   67 44                 111
1370180 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2020   grade_5 26 15 20 0   44     5   3   56 57 *                     113.0 26 15 20 0   44     5   3   56 57                 113
1371142 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2020   grade_7 155 63 39 0   8     5   22   135 157 *                     292.0 155 63 39 0   8     5   22   135 157                 292
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
1367509 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2020   grade_9 172 3 32 1   1     4   17   147 83 *                     230.0 172 3 32 1   1     4   17   147 83                 230
1367584 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_9 28 2 4 0   0     4   0   17 21 *                     38.0 28 2 4 0   0     4   0   17 21                 38
1365139 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2020   grade_3 68 2 6 0   0     3   2   45 36 *                     81.0 68 2 6 0   0     3   2   45 36                 81
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
1366479 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_9 190 130 78 0   48     3   45   231 263 *                     494.0 190 130 78 0   48     3   45   231 263                 494
1367408 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_3 53 0 4 1   2     3   2   35 30 *                     65.0 53 0 4 1   2     3   2   35 30                 65
1367441 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_12 379 5 9 0   19     3   14   216 213 *                     429.0 379 5 9 0   19     3   14   216 213                 429
1367583 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_8 36 1 5 0   3     3   3   27 24 *                     51.0 36 1 5 0   3     3   3   27 24                 51
1368156 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2020   grade_12 78 9 48 0   1     3   5   98 46 *                     144.0 78 9 48 0   1     3   5   98 46                 144
1369652 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_7 133 2 17 0   23     3   6   85 99 *                     184.0 133 2 17 0   23     3   6   85 99                 184
1369749 MA Norfolk   school 2509060 220   Norwood 250906001460 2200005 Balch   Regular School No Elementary 01 05 2020   grade_1 28 6 20 0   7     3   0   34 30 *                     64.0 28 6 20 0   7     3   0   34 30                 64
1369771 MA Norfolk   school 2509060 220   Norwood 250906001461 2200025 Charles J Prescott   Regular School No Elementary KG 05 2020   grade_2 21 5 8 0   23     3   0   28 32 *                     60.0 21 5 8 0   23     3   0   28 32                 60
1369775 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2020   kindergarten 166 18 40 0   35     3   6   137 131 *                     268.0 166 18 40 0   35     3   6   137 131                 268
1369776 MA Norfolk   school 2509060 220   Norwood 250906001557 2200075 George F. Willett   Regular School No Elementary PK KG 2020   pre_kindergarten 85 9 8 0   17     3   0   74 48 *                     122.0 85 9 8 0   17     3   0   74 48                 122
1370479 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_7 139 7 39 1   10     3   5   107 97 *                     204.0 139 7 39 1   10     3   5   107 97                 204
1372859 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_6 2 140 105 1   0     3   0   136 115 *                     251.0 2 140 105 1   0     3   0   136 115                 251
1373432 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2020   grade_5 39 0 0 0   0     3   1   22 21 *                     43.0 39 0 0 0   0     3   1   22 21                 43
1374299 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_6 76 10 20 0   6     3   9   66 58 *                     124.0 76 10 20 0   6     3   9   66 58                 124
1364934 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   grade_4 46 0 2 0   14     2   6   33 37 *                     70.0 46 0 2 0   14     2   6   33 37                 70
1365034 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_11 290 31 64 0   27     2   25   225 214 *                     439.0 290 31 64 0   27     2   25   225 214                 439
1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
1365099 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_11 254 32 64 1   4     2   10   186 181 *                     367.0 254 32 64 1   4     2   10   186 181                 367
1365134 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2020   grade_2 62 2 13 0   3     2   2   43 41 *                     84.0 62 2 13 0   3     2   2   43 41                 84
1365138 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2020   grade_2 58 1 3 0   1     2   4   38 31 *                     69.0 58 1 3 0   1     2   4   38 31                 69
1365386 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_7 2 49 26 0   3     2   2   41 43 *                     84.0 2 49 26 0   3     2   2   41 43                 84
1365387 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_8 1 43 18 0   0     2   1   30 35 *                     65.0 1 43 18 0   0     2   1   30 35                 65
1365658 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_3 0 58 37 1   2     2   2   55 47 *                     102.0 0 58 37 1   2     2   2   55 47                 102
1365797 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_1 0 32 19 0   1     2   2   25 31 *                     56.0 0 32 19 0   1     2   2   25 31                 56
1365803 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_7 1 15 9 0   1     2   0   20 8 *                     28.0 1 15 9 0   1     2   0   20 8                 28
1365900 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2020   grade_10 8 38 68 1   9     2   2   72 56 *                     128.0 8 38 68 1   9     2   2   72 56                 128
1365923 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2020   grade_11 2 67 28 0   0     2   3   57 45 *                     102.0 2 67 28 0   0     2   3   57 45                 102
1365935 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2020   grade_9 14 130 194 0   4     2   7   209 142 *                     351.0 14 130 194 0   4     2   7   209 142                 351
1365982 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_9 191 41 65 0   130     2   23   211 239 *                     452.0 191 41 65 0   130     2   23   211 239                 452
1365984 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_11 196 27 47 1   135     2   13   192 229 *                     421.0 196 27 47 1   135     2   13   192 229                 421
1366062 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne Intermediate School   Regular School No Elementary 03 05 2020   grade_4 138 5 17 1   1     2   7   80 91 *                     171.0 138 5 17 1   1     2   7   80 91                 171
1366124 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2020   grade_10 307 14 22 0   87     2   7   221 218 *                     439.0 307 14 22 0   87     2   7   221 218                 439
1366168 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   kindergarten 17 55 5 0   2     2   4   45 40 *                     85.0 17 55 5 0   2     2   4   45 40                 85
1366179 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_5 11 79 16 0   1     2   4   51 62 *                     113.0 11 79 16 0   1     2   4   51 62                 113
1366236 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_7 64 117 25 2   7     2   4   96 125 *                     221.0 64 117 25 2   7     2   4   96 125                 221
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
1366480 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_10 192 140 81 2   51     2   44   270 242 *                     512.0 192 140 81 2   51     2   44   270 242                 512
1366481 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   grade_11 183 139 63 2   49     2   33   230 241 *                     471.0 183 139 63 2   49     2   33   230 241                 471
1366496 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_5 62 5 2 0   7     2   5   40 43 *                     83.0 62 5 2 0   7     2   5   40 43                 83
1366503 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_6 205 29 10 1   24     2   20   145 146 *                     291.0 205 29 10 1   24     2   20   145 146                 291
1367091 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_12 124 117 253 2   24     2   5   273 254 *                     527.0 124 117 253 2   24     2   5   273 254                 527
1367406 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 J F Kennedy Memorial   Regular School No Elementary KG 05 2020   grade_1 49 1 1 0   1     2   0   31 23 *                     54.0 49 1 1 0   1     2   0   31 23                 54
1367417 MA Norfolk   school 2505010 101   Franklin 250501002519 1010032 Parmenter   Regular School No Elementary KG 05 2020   kindergarten 52 4 3 0   2     2   0   32 31 *                     63.0 52 4 3 0   2     2   0   32 31                 63
1367424 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_1 43 2 3 0   3     2   0   23 30 *                     53.0 43 2 3 0   3     2   0   23 30                 53
1367428 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2020   grade_5 34 0 0 0   0     2   0   20 16 *                     36.0 34 0 0 0   0     2   0   20 16                 36
1367435 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2020   grade_6 110 3 5 0   9     2   4   71 62 *                     133.0 110 3 5 0   9     2   4   71 62                 133
1367439 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_10 370 5 16 0   33     2   6   214 218 *                     432.0 370 5 16 0   33     2   6   214 218                 432
1367496 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No Elementary KG 05 2020   grade_2 19 3 4 0   1     2   1   12 18 *                     30.0 19 3 4 0   1     2   1   12 18                 30
1367531 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2020   grade_8 201 5 16 2   28     2   6   130 130 *                     260.0 201 5 16 2   28     2   6   130 130                 260
1367711 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No High 09 12 2020   grade_9 259 22 204 0   11     2   8   268 238 *                     506.0 259 22 204 0   11     2   8   268 238                 506
1368212 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2020   kindergarten 36 2 11 0   0     2   8   28 31 *                     59.0 36 2 11 0   0     2   8   28 31                 59
1368228 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_5 31 4 17 0   0     2   9   31 32 *                     63.0 31 4 17 0   0     2   9   31 32                 63
1368268 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_6 95 0 6 0   17     2   9   57 72 *                     129.0 95 0 6 0   17     2   9   57 72                 129
1368453 MA Worcester   school 2507080 162   Lunenburg 250708001058 1620505 Lunenburg High   Regular School No High 09 12 2020   grade_10 103 4 12 2   2     2   1   59 67 *                     126.0 103 4 12 2   2     2   1   59 67                 126
1369101 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson High School   Regular School No High 07 12 2020   grade_8 55 0 8 0   2     2   3   36 34 *                     70.0 55 0 8 0   2     2   3   36 34                 70
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
1369405 MA Middlesex   school 2508610 207   Newton 250861001366 2070055 Franklin   Regular School No Elementary KG 05 2020   grade_5 59 3 4 0   7     2   6   38 43 *                     81.0 59 3 4 0   7     2   6   38 43                 81
1369456 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Zervas   Regular School No Elementary KG 05 2020   grade_1 36 7 6 1   20     2   4   36 40 *                     76.0 36 7 6 1   20     2   4   36 40                 76
1369621 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2020   grade_7 329 11 22 0   16     2   16   175 221 *                     396.0 329 11 22 0   16     2   16   175 221                 396
1369653 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_8 148 8 14 0   21     2   11   96 108 *                     204.0 148 8 14 0   21     2   11   96 108                 204
1369824 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2020   grade_10 78 4 9 0   1     2   6   47 53 *                     100.0 78 4 9 0   1     2   6   47 53                 100
1370132 MA Norfolk   school 2509870 243   Quincy 250987001573 2430060 Merrymount   Regular School No Elementary KG 05 2020   grade_3 26 4 1 1   14     2   0   29 19 *                     48.0 26 4 1 1   14     2   0   29 19                 48
1370168 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_8 74 9 4 0   96     2   8   105 88 *                     193.0 74 9 4 0   96     2   8   105 88                 193
1370172 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_6 94 8 6 0   105     2   4   111 108 *                     219.0 94 8 6 0   105     2   4   111 108                 219
1370173 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2020   grade_7 90 6 9 0   85     2   9   94 107 *                     201.0 90 6 9 0   85     2   9   94 107                 201
1370444 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_4 182 2 7 0   6     2   0   105 94 *                     199.0 182 2 7 0   6     2   0   105 94                 199
1370725 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2020   kindergarten 95 4 9 1   24     2   5   84 56 *                     140.0 95 4 9 1   24     2   5   84 56                 140
1370836 MA Hampden   school 2511130 281   Springfield 251113001807 2810050 Hiram L Dorman   Regular School No Elementary KG 05 2020   grade_4 3 10 24 0   1     2   2   21 21 *                     42.0 3 10 24 0   1     2   2   21 21                 42
1371143 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2020   grade_8 164 71 28 1   25     2   13   183 121 *                     304.0 164 71 28 1   25     2   13   183 121                 304
1371302 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   grade_12 293 83 52 0   8     2   13   211 239 *                     451.0 293 83 52 0   8     2   13   211 239                 451
1372051 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2020   grade_10 243 1 13 1   67     2   17   169 175 *                     344.0 243 1 13 1   67     2   17   169 175                 344
1372113 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_6 101 18 13 0   15     2   7   77 79 *                     156.0 101 18 13 0   15     2   7   77 79                 156
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
1372464 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2020   grade_10 5 35 37 0   1     2   2   48 34 *                     82.0 5 35 37 0   1     2   2   48 34                 82
1372548 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_1 8 14 98 0   1     2   1   53 71 *                     124.0 8 14 98 0   1     2   1   53 71                 124
1372678 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_6 47 64 5 2   15     2   10   65 80 *                     145.0 47 64 5 2   15     2   10   65 80                 145
1372785 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   kindergarten 1 50 35 1   0     2   3   48 44 *                     92.0 1 50 35 1   0     2   3   48 44                 92
1372861 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_8 1 126 94 2   4     2   2   125 106 *                     231.0 1 126 94 2   4     2   2   125 106                 231
1372888 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_6 6 56 22 0   6     2   3   46 49 *                     95.0 6 56 22 0   6     2   3   46 49                 95
1373023 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2020   grade_7 203 13 27 2   151     2   14   208 204 *                     412.0 203 13 27 2   151     2   14   208 204                 412
1373109 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_8 92 3 15 2   7     2   5   70 56 *                     126.0 92 3 15 2   7     2   5   70 56                 126
1373126 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2020   grade_11 103 3 11 0   3     2   6   65 63 *                     128.0 103 3 11 0   3     2   6   65 63                 128
1373173 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2020   grade_2 224 8 9 0   5     2   8   143 113 *                     256.0 224 8 9 0   5     2   8   143 113                 256
1373459 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2020   grade_1 119 3 16 0   4     2   8   79 73 *                     152.0 119 3 16 0   4     2   8   79 73                 152
1373677 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No High 09 12 2020   grade_10 239 6 12 0   4     2   5   126 142 *                     268.0 239 6 12 0   4     2   5   126 142                 268
1373689 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2020   grade_9 234 4 20 3   42     2   16   159 162 *                     321.0 234 4 20 3   42     2   16   159 162                 321
1373692 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2020   grade_12 266 4 23 0   33     2   12   170 170 *                     340.0 266 4 23 0   33     2   12   170 170                 340
1374070 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2020   grade_12 255 9 12 1   7     2   4   143 147 *                     290.0 255 9 12 1   7     2   4   143 147                 290
1374304 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_11 228 17 41 0   8     2   13   105 204 *                     309.0 228 17 41 0   8     2   13   105 204                 309
1364785 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_3 135 6 21 0   2     1   0   81 84 *                     165.0 135 6 21 0   2     1   0   81 84                 165
1364813 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_3 62 2 4 0   0     1   1   32 38 *                     70.0 62 2 4 0   0     1   1   32 38                 70
1364846 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_1 52 0 7 0   1     1   3   36 28 *                     64.0 52 0 7 0   1     1   3   36 28                 64

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