enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by native_american_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2044092 2044092 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_6 193 9 107 14   5     0   13   185 156                       341.0 193 9 107 14   5     0   13   185 156                 341
2043867 2043867 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_8 105 10 2 13   4     0   6   59 81                       140.0 105 10 2 13   4     0   6   59 81                 140
2042305 2042305 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2019   grade_5 225 8 14 12   5     0   22   153 133                       286.0 225 8 14 12   5     0   22   153 133                 286
2043870 2043870 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_5 100 6 4 9   2     0   7   64 64                       128.0 100 6 4 9   2     0   7   64 64                 128
2043871 2043871 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_6 106 4 5 9   4     0   12   68 72                       140.0 106 4 5 9   4     0   12   68 72                 140
2043873 2043873 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_10 92 5 7 9   5     0   2   56 64                       120.0 92 5 7 9   5     0   2   56 64                 120
2044090 2044090 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_4 199 13 93 9   3     1   18   179 157                       336.0 199 13 93 9   3     1   18   179 157                 336
2043868 2043868 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_3 86 5 8 8   1     0   11   58 61                       119.0 86 5 8 8   1     0   11   58 61                 119
2043869 2043869 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_4 86 2 8 8   1     0   11   53 63                       116.0 86 2 8 8   1     0   11   53 63                 116
2043875 2043875 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_12 82 6 4 8   2     0   9   62 49                       111.0 82 6 4 8   2     0   9   62 49                 111
2044091 2044091 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_5 190 11 95 8   11     0   14   178 151                       329.0 190 11 95 8   11     0   14   178 151                 329
2045389 2045389 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2019   grade_10 170 18 321 8   29     0   8   279 275                       554.0 170 18 321 8   29     0   8   279 275                 554
2048312 2048312 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2019   grade_4 170 19 20 8   2     0   28   123 124                       247.0 170 19 20 8   2     0   28   123 124                 247
2043865 2043865 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_2 69 7 3 7   3     1   13   48 55                       103.0 69 7 3 7   3     1   13   48 55                 103
2044096 2044096 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_10 185 13 93 7   5     0   11   163 151                       314.0 185 13 93 7   5     0   11   163 151                 314
2044097 2044097 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_11 205 4 64 7   5     0   11   138 158                       296.0 205 4 64 7   5     0   11   138 158                 296
2048313 2048313 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2019   grade_5 162 28 47 7   4     0   17   136 129                       265.0 162 28 47 7   4     0   17   136 129                 265
2043864 2043864 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_1 85 2 4 6   3     0   14   66 48                       114.0 85 2 4 6   3     0   14   66 48                 114
2043866 2043866 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_7 89 4 2 6   3     0   7   66 45                       111.0 89 4 2 6   3     0   7   66 45                 111
2044093 2044093 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_7 214 8 89 6   6     0   10   183 150                       333.0 214 8 89 6   6     0   10   183 150                 333
2044098 2044098 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_12 171 5 65 6   11     0   4   131 131                       262.0 171 5 65 6   11     0   4   131 131                 262
2048314 2048314 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2019   grade_6 160 19 32 6   6     0   12   119 116                       235.0 160 19 32 6   6     0   12   119 116                 235
2048318 2048318 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_10 126 15 26 6   4     1   9   100 87                       187.0 126 15 26 6   4     1   9   100 87                 187
2048582 2048582 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2019   grade_10 121 9 26 6   3     1   5   85 86                       171.0 121 9 26 6   3     1   5   85 86                 171
2040012 2040012 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2019   grade_4 152 6 20 5   32     0   4   106 113                       219.0 152 6 20 5   32     0   4   106 113                 219
2040013 2040013 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 David Mindess   Regular School No Elementary 03 05 2019   grade_5 149 2 28 5   25     0   9   110 108                       218.0 149 2 28 5   25     0   9   110 108                 218
2041313 2041313 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_11 151 620 120 5   28     1   35   504 456                       960.0 151 620 120 5   28     1   35   504 456                 960
2042309 2042309 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2019   grade_9 185 15 10 5   5     0   20   123 117                       240.0 185 15 10 5   5     0   20   123 117                 240
2043664 2043664 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2019   grade_9 58 57 352 5   43     0   13   288 240                       528.0 58 57 352 5   43     0   13   288 240                 528
2043872 2043872 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_9 86 7 5 5   3     1   8   65 50                       115.0 86 7 5 5   3     1   8   65 50                 115
2043874 2043874 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_11 83 6 6 5   2     0   6   58 50                       108.0 83 6 6 5   2     0   6   58 50                 108
2044067 2044067 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_7 227 6 8 5   6     0   11   137 126                       263.0 227 6 8 5   6     0   11   137 126                 263
2044068 2044068 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_8 218 6 10 5   6     0   12   118 139                       257.0 218 6 10 5   6     0   12   118 139                 257
2044077 2044077 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2019   pre_kindergarten 72 0 0 5   2     0   0   38 41                       79.0 72 0 0 5   2     0   0   38 41                 79
2044410 2044410 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_9 232 111 247 5   9     1   34   339 300                       639.0 232 111 247 5   9     1   34   339 300                 639
2046603 2046603 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2019   grade_3 110 13 17 5   1     0   20   95 71                       166.0 110 13 17 5   1     0   20   95 71                 166
2048310 2048310 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2019   grade_2 77 10 8 5   3     1   5   63 46                       109.0 77 10 8 5   3     1   5   63 46                 109
2048315 2048315 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2019   grade_7 138 17 35 5   5     0   15   101 114                       215.0 138 17 35 5   5     0   15   101 114                 215
2048581 2048581 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2019   grade_9 99 10 30 5   2     2   5   97 56                       153.0 99 10 30 5   2     2   5   97 56                 153
2049022 2049022 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   kindergarten 24 1 3 5   0     0   4   23 14                       37.0 24 1 3 5   0     0   4   23 14                 37
2049165 2049165 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 2019   grade_12 83 7 13 5   1     1   6   73 43                       116.0 83 7 13 5   1     1   6   73 43                 116
2049193 2049193 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 2019   grade_9 92 8 95 5   2     0   7   128 81                       209.0 92 8 95 5   2     0   7   128 81                 209
2040119 2040119 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2019   grade_5 279 24 65 4   8     1   15   209 187                       396.0 279 24 65 4   8     1   15   209 187                 396
2041122 2041122 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_5 150 2 7 4   4     0   5   81 91                       172.0 150 2 7 4   4     0   5   81 91                 172
2041227 2041227 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2019   grade_5 13 60 76 4   1     0   9   91 72                       163.0 13 60 76 4   1     0   9   91 72                 163
2042160 2042160 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_9 102 94 273 4   23     0   7   258 245                       503.0 102 94 273 4   23     0   7   258 245                 503
2042958 2042958 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_12 69 1 2 4   0     0   2   39 39                       78.0 69 1 2 4   0     0   2   39 39                 78
2043660 2043660 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2019   grade_9 108 32 261 4   48     0   19   234 238                       472.0 108 32 261 4   48     0   19   234 238                 472
2043677 2043677 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_9 39 19 186 4   18     0   9   152 122                       275.0 39 19 186 4   18     0   9   152 122                 275
2044070 2044070 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2019   grade_10 169 6 3 4   2     0   6   100 90                       190.0 169 6 3 4   2     0   6   100 90                 190
2044412 2044412 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_11 159 89 261 4   7     1   21   297 245                       542.0 159 89 261 4   7     1   21   297 245                 542
2045654 2045654 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   kindergarten 87 8 18 4   96     0   8   122 99                       221.0 87 8 18 4   96     0   8   122 99                 221
2045661 2045661 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_1 29 5 10 4   59     0   4   54 57                       111.0 29 5 10 4   59     0   4   54 57                 111
2046612 2046612 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No High 08 12 2019   grade_9 95 16 7 4   1     0   15   68 69                       138.0 95 16 7 4   1     0   15   68 69                 138
2047196 2047196 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 311 107 99 4   9     0   21   261 290                       551.0 311 107 99 4   9     0   21   261 290                 551
2047528 2047528 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_8 29 14 123 4   3     2   0   81 94                       175.0 29 14 123 4   3     2   0   81 94                 175
2048316 2048316 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_8 171 23 20 4   5     0   11   122 112                       234.0 171 23 20 4   5     0   11   122 112                 234
2048320 2048320 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_12 136 23 27 4   8     0   10   100 108                       208.0 136 23 27 4   8     0   10   100 108                 208
2049158 2049158 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 304 10 22 4   2     0   17   221 138                       359.0 304 10 22 4   2     0   17   221 138                 359
2049185 2049185 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2019   grade_10 326 39 144 4   3     0   25   264 277                       541.0 326 39 144 4   3     0   25   264 277                 541
2049194 2049194 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 2019   grade_10 99 10 81 4   0     0   5   121 78                       199.0 99 10 81 4   0     0   5   121 78                 199
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2041008 2041008 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_12 63 56 71 3   67     0   6   110 156                       266.0 63 56 71 3   67     0   6   110 156                 266
2041213 2041213 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   grade_3 19 80 15 3   0     0   9   74 52                       126.0 19 80 15 3   0     0   9   74 52                 126
2041266 2041266 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2019   grade_4 44 122 23 3   12     1   7   106 106                       212.0 44 122 23 3   12     1   7   106 106                 212
2041302 2041302 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2019   grade_6 59 162 25 3   9     1   6   151 114                       265.0 59 162 25 3   9     1   6   151 114                 265
2041311 2041311 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_9 174 708 154 3   20     4   45   585 523                       1108.0 174 708 154 3   20     4   45   585 523                 1108
2041312 2041312 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_10 197 601 130 3   22     4   38   541 454                       995.0 197 601 130 3   22     4   38   541 454                 995
2041549 2041549 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_9 198 143 77 3   44     2   45   262 250                       512.0 198 143 77 3   44     2   45   262 250                 512
2041551 2041551 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_11 184 141 62 3   60     1   32   248 235                       483.0 184 141 62 3   60     1   32   248 235                 483
2042069 2042069 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2019   grade_2 61 7 7 3   1     0   2   38 43                       81.0 61 7 7 3   1     0   2   38 43                 81
2042086 2042086 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_4 34 2 16 3   0     0   3   21 37                       58.0 34 2 16 3   0     0   3   21 37                 58
2042109 2042109 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_8 5 7 25 3   3     0   2   22 23                       45.0 5 7 25 3   3     0   2   22 23                 45
2042286 2042286 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_2 33 2 2 3   0     0   4   26 18                       44.0 33 2 2 3   0     0   4   26 18                 44
2042312 2042312 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2019   grade_12 148 4 7 3   10     0   7   79 99                       179.0 148 4 7 3   10     0   7   79 99                 179
2042578 2042578 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_6 175 3 19 3   3     0   1   87 117                       204.0 175 3 19 3   3     0   1   87 117                 204
2042749 2042749 MA Essex   school 2505970 128   Haverhill 250597000056 1280045 Moody   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 106 21 64 3   4     2   0   126 74                       200.0 106 21 64 3   4     2   0   126 74                 200
2043862 2043862 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   pre_kindergarten 65 3 8 3   2     1   12   55 39                       94.0 65 3 8 3   2     1   12   55 39                 94
2043863 2043863 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   kindergarten 60 3 15 3   1     0   15   52 45                       97.0 60 3 15 3   1     0   15   52 45                 97
2043901 2043901 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Dale Street   Regular School No Elementary 04 05 2019   grade_4 160 2 13 3   7     0   4   111 78                       189.0 160 2 13 3   7     0   4   111 78                 189
2043934 2043934 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2019   kindergarten 56 9 10 3   5     0   4   42 45                       87.0 56 9 10 3   5     0   4   42 45                 87
2044066 2044066 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_6 233 11 9 3   1     0   8   137 128                       265.0 233 11 9 3   1     0   8   137 128                 265
2044071 2044071 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No High 09 12 2019   grade_11 154 2 6 3   0     0   5   87 83                       170.0 154 2 6 3   0     0   5   87 83                 170
2044094 2044094 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_8 218 9 106 3   13     0   12   185 176                       361.0 218 9 106 3   13     0   12   185 176                 361
2044404 2044404 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2019   grade_6 179 38 150 3   2     0   30   218 184                       402.0 179 38 150 3   2     0   30   218 184                 402
2044411 2044411 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_10 159 101 241 3   5     2   26   268 269                       537.0 159 101 241 3   5     2   26   268 269                 537
2044547 2044547 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_10 307 42 44 3   68     0   34   254 242                       498.0 307 42 44 3   68     0   34   254 242                 498
2044549 2044549 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2019   grade_12 361 18 56 3   83     0   23   269 274                       544.0 361 18 56 3   83     0   23   269 274                 544
2044792 2044792 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2019   grade_4 157 4 10 3   2     0   6   90 92                       182.0 157 4 10 3   2     0   6   90 92                 182
2045148 2045148 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2019   grade_8 287 10 17 3   8     0   11   193 142                       336.0 287 10 17 3   8     0   11   193 142                 336
2045174 2045174 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 51 15 11 3   88     1   8   107 70                       177.0 51 15 11 3   88     1   8   107 70                 177
2045187 2045187 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2019   kindergarten 40 10 7 3   47     0   6   62 51                       113.0 40 10 7 3   47     0   6   62 51                 113
2045390 2045390 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2019   grade_11 147 15 258 3   28     0   12   234 229                       463.0 147 15 258 3   28     0   12   234 229                 463
2045522 2045522 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2019   grade_8 211 2 2 3   6     0   1   112 113                       225.0 211 2 2 3   6     0   1   112 113                 225
2045524 2045524 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2019   grade_10 141 0 1 3   4     1   0   70 80                       150.0 141 0 1 3   4     1   0   70 80                 150
2045537 2045537 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Oaklandvale   Regular School No Elementary KG 05 2019   grade_4 26 2 10 3   2     0   3   25 21                       46.0 26 2 10 3   2     0   3   25 21                 46
2045918 2045918 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   pre_kindergarten 24 35 85 3   4     0   4   86 69                       155.0 24 35 85 3   4     0   4   86 69                 155
2046374 2046374 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_8 400 110 79 3   8     0   31   331 300                       631.0 400 110 79 3   8     0   31   331 300                 631
2046601 2046601 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   grade_1 136 17 21 3   1     0   21   107 92                       199.0 136 17 21 3   1     0   21   107 92                 199
2046643 2046643 MA Middlesex   school 2512180 314   Watertown 251218002005 3140505 Watertown High   Regular School No High 09 12 2019   grade_11 108 6 21 3   4     0   8   74 76                       150.0 108 6 21 3   4     0   8   74 76                 150

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