Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by native_american_int descending

View and edit SQL

grade

year

  • 2015 · 9,541
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
739728 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_4 107 4 3 12   6     0   4   58 78                       136 107 4 3 12   6     0   4   58 78                 136
739726 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_8 111 6 5 10   3     0   6   76 65                       141 111 6 5 10   3     0   6   76 65                 141
739948 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 05 2015   grade_2 106 3 44 10   5     0   4   92 80                       172 106 3 44 10   5     0   4   92 80                 172
739721 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   kindergarten 74 2 11 9   1     0   9   52 54                       106 74 2 11 9   1     0   9   52 54                 106
744198 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2015   grade_6 163 17 19 9   4     0   14   123 103                       226 163 17 19 9   4     0   14   123 103                 226
739723 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_1 98 3 5 8   1     0   7   62 60                       122 98 3 5 8   1     0   7   62 60                 122
739724 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_2 97 3 3 8   3     0   9   59 64                       123 97 3 3 8   3     0   9   59 64                 123
739730 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_6 125 5 5 8   4     0   2   67 82                       149 125 5 5 8   4     0   2   67 82                 149
740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
739729 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_5 109 5 4 7   3     1   2   74 57                       131 109 5 4 7   3     1   2   74 57                 131
739733 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_11 76 2 7 7   2     1   4   41 58                       99 76 2 7 7   2     1   4   41 58                 99
739950 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No 1 03 04 2015   grade_3 209 7 88 7   8     0   13   179 153                       332 209 7 88 7   8     0   13   179 153                 332
739955 MA Worcester   school 2507860 185   Milford 250786002439 1850310 Milford Middle East   Regular School No 4 08 08 2015   grade_8 228 9 57 7   13     0   4   170 148                       318 228 9 57 7   13     0   4   170 148                 318
735974 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_10 269 29 42 6   11     0   12   180 189                       369 269 29 42 6   11     0   12   180 189                 369
737164 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_9 206 707 159 6   31     2   35   624 522                       1146 206 707 159 6   31     2   35   624 522                 1146
739727 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_3 86 4 5 6   3     0   5   69 40                       109 86 4 5 6   3     0   5   69 40                 109
739928 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No 2 06 08 2015   grade_7 230 3 9 6   0     0   8   128 128                       256 230 3 9 6   0     0   8   128 128                 256
739944 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   grade_1 94 6 41 6   4     0   5   92 64                       156 94 6 41 6   4     0   5   92 64                 156
739953 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 07 2015   grade_6 208 8 72 6   5     0   11   162 148                       310 208 8 72 6   5     0   11   162 148                 310
739954 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No 2 05 07 2015   grade_7 229 9 58 6   7     0   7   157 159                       316 229 9 58 6   7     0   7   157 159                 316
740277 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_11 226 61 151 6   2     6   31   271 212                       483 226 61 151 6   2     6   31   271 212                 483
741131 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2015   grade_12 209 37 31 6   80     1   5   202 167                       369 209 37 31 6   80     1   5   202 167                 369
742471 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   grade_1 169 20 8 6   2     0   23   101 127                       228 169 20 8 6   2     0   23   101 127                 228
744195 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   grade_3 73 9 12 6   2     0   5   54 53                       107 73 9 12 6   2     0   5   54 53                 107
744463 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2015   grade_11 123 5 18 6   2     0   9   81 82                       163 123 5 18 6   2     0   9   81 82                 163
745044 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 138 9 13 6   1     0   5   105 67                       172 138 9 13 6   1     0   5   105 67                 172
735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
737072 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2015   grade_1 24 62 78 5   1     0   10   94 86                       180 24 62 78 5   1     0   10   94 86                 180
738135 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_1 35 2 1 5   1     0   4   26 22                       48 35 2 1 5   1     0   4   26 22                 48
738155 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_11 159 8 4 5   9     1   5   95 96                       191 159 8 4 5   9     1   5   95 96                 191
739722 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   pre_kindergarten 68 4 6 5   3     0   6   51 41                       92 68 4 6 5   3     0   6   51 41                 92
739725 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_7 101 6 4 5   5     0   6   66 61                       127 101 6 4 5   5     0   6   66 61                 127
739732 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_10 90 1 4 5   2     0   7   64 45                       109 90 1 4 5   2     0   7   64 45                 109
739945 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   grade_2 84 3 50 5   5     0   9   87 69                       156 84 3 50 5   5     0   9   87 69                 156
739956 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_9 185 8 80 5   11     1   6   136 160                       296 185 8 80 5   11     1   6   136 160                 296
739959 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No 3 08 12 2015   grade_12 226 4 29 5   13     0   1   138 140                       278 226 4 29 5   13     0   1   138 140                 278
740732 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_2 38 1 8 5   1     0   5   27 31                       58 38 1 8 5   1     0   5   27 31                 58
742924 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2015   grade_12 380 19 27 5   11     0   4   204 242                       446 380 19 27 5   11     0   4   204 242                 446
743380 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No 3 09 12 2015   grade_12 151 51 81 5   30     0   8   160 166                       326 151 51 81 5   30     0   8   160 166                 326
743416 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_5 14 10 136 5   2     0   0   80 87                       167 14 10 136 5   2     0   0   80 87                 167
744193 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   grade_1 89 7 6 5   2     0   9   59 59                       118 89 7 6 5   2     0   9   59 59                 118
744197 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No 2 04 05 2015   grade_5 188 25 23 5   5     0   11   128 129                       257 188 25 23 5   5     0   11   128 129                 257
745129 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 153 5 7 5   2     0   0   97 75                       172 153 5 7 5   2     0   0   97 75                 172
735857 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2015   kindergarten 153 5 3 4   23     0   5   86 107                       193 153 5 3 4   23     0   5   86 107                 193
735858 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2015   grade_1 149 3 19 4   23     0   8   108 98                       206 149 3 19 4   23     0   8   108 98                 206
735971 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_7 292 29 38 4   13     1   11   185 203                       388 292 29 38 4   13     1   11   185 203                 388
735972 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_8 316 22 13 4   21     2   20   197 201                       398 316 22 13 4   21     2   20   197 201                 398
735975 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_11 313 28 28 4   13     0   13   189 210                       399 313 28 28 4   13     0   13   189 210                 399
736833 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2015   grade_10 16 108 140 4   0     1   8   158 119                       277 16 108 140 4   0     1   8   158 119                 277
737165 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_10 220 623 140 4   27     3   25   503 539                       1042 220 623 140 4   27     3   25   503 539                 1042
737167 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_12 219 572 101 4   25     0   17   445 493                       938 219 572 101 4   25     0   17   445 493                 938
737401 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_9 185 172 64 4   56     0   18   270 229                       499 185 172 64 4   56     0   18   270 229                 499
737931 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   kindergarten 29 1 7 4   0     0   4   22 23                       45 29 1 7 4   0     0   4   22 23                 45
738150 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_6 242 10 8 4   6     0   20   141 149                       290 242 10 8 4   6     0   20   141 149                 290
738156 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_12 166 10 7 4   11     0   3   101 100                       201 166 10 7 4   11     0   3   101 100                 201
738790 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_8 87 0 2 4   0     0   2   45 50                       95 87 0 2 4   0     0   2   45 50                 95
739621 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_10 319 6 6 4   13     0   4   178 174                       352 319 6 6 4   13     0   4   178 174                 352
739731 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_9 100 4 4 4   1     0   6   54 65                       119 100 4 4 4   1     0   6   54 65                 119
739734 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_12 88 2 1 4   2     0   7   55 49                       104 88 2 1 4   2     0   7   55 49                 104
739912 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2015   grade_11 291 17 123 4   20     0   4   261 198                       459 291 17 123 4   20     0   4   261 198                 459
739913 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2015   grade_12 273 16 120 4   14     0   4   220 211                       431 273 16 120 4   14     0   4   220 211                 431
739943 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   kindergarten 94 5 40 4   6     1   11   94 67                       161 94 5 40 4   6     1   11   94 67                 161
739951 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No 1 03 04 2015   grade_4 230 13 79 4   7     0   12   172 173                       345 230 13 79 4   7     0   12   172 173                 345
740269 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_6 191 27 96 4   2     2   10   183 149                       332 191 27 96 4   2     2   10   183 149                 332
741025 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2015   grade_10 212 4 3 4   2     2   9   125 111                       236 212 4 3 4   2     2   9   125 111                 236
741224 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No 2 06 08 2015   grade_6 93 10 87 4   13     0   3   114 96                       210 93 10 87 4   13     0   3   114 96                 210
743388 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No 3 09 12 2015   grade_12 63 60 132 4   45     0   3   153 154                       307 63 60 132 4   45     0   3   153 154                 307
743391 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2015   grade_11 138 41 119 4   7     0   11   143 177                       320 138 41 119 4   7     0   11   143 177                 320
743657 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes 3 09 12 2015   grade_12 2 46 30 4   3     0   2   27 60                       87 2 46 30 4   3     0   2   27 60                 87
744199 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2015   grade_7 174 19 18 4   7     0   13   102 133                       235 174 19 18 4   7     0   13   102 133                 235
744204 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_12 130 7 16 4   3     0   10   86 84                       170 130 7 16 4   3     0   10   86 84                 170
744461 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2015   grade_9 139 5 13 4   4     0   13   92 86                       178 139 5 13 4   4     0   13   92 86                 178
745027 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Vocational Education School No 3 09 12 2015   grade_9 232 2 34 4   1     0   7   160 120                       280 232 2 34 4   1     0   7   160 120                 280
745037 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 137 42 12 4   3     1   3   108 94                       202 137 42 12 4   3     1   3   108 94                 202
745069 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 250 17 156 4   89     0   20   268 268                       536 250 17 156 4   89     0   20   268 268                 536
735908 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_9 310 30 48 3   22     2   18   224 209                       433 310 30 48 3   22     2   18   224 209                 433
735910 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_11 324 26 56 3   23     1   19   241 211                       452 324 26 56 3   23     1   19   241 211                 452
735970 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_6 275 28 35 3   5     2   15   209 154                       363 275 28 35 3   5     2   15   209 154                 363
736812 MA Suffolk   school 2502790 35   Boston 250279002016 350522 Excel High School   Regular School No 3 09 12 2015   grade_9 19 52 36 3   17     0   1   71 57                       128 19 52 36 3   17     0   1   71 57                 128
736823 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2015   grade_10 58 26 290 3   6     0   4   222 165                       387 58 26 290 3   6     0   4   222 165                 387
736855 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2015   grade_8 81 60 68 3   58     0   8   117 161                       278 81 60 68 3   58     0   8   117 161                 278
737073 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No 1 KG 05 2015   grade_2 21 68 58 3   2     0   13   82 83                       165 21 68 58 3   2     0   13   82 83                 165
737077 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No 1 KG KG 2015   kindergarten 52 123 32 3   3     0   23   129 107                       236 52 123 32 3   3     0   23   129 107                 236
737166 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_11 231 627 106 3   26     0   23   530 486                       1016 231 627 106 3   26     0   23   530 486                 1016
737294 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2015   grade_7 219 14 14 3   37     0   9   162 134                       296 219 14 14 3   37     0   9   162 134                 296
737403 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_11 169 157 53 3   41     0   16   215 224                       439 169 157 53 3   41     0   16   215 224                 439
737404 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_12 163 145 49 3   54     0   9   205 218                       423 163 145 49 3   54     0   9   205 218                 423
737954 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_4 15 14 37 3   3     0   2   37 37                       74 15 14 37 3   3     0   2   37 37                 74
738008 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2015   grade_10 179 115 233 3   21     0   7   312 246                       558 179 115 233 3   21     0   7   312 246                 558
738140 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_1 76 0 7 3   4     0   4   45 49                       94 76 0 7 3   4     0   4   45 49                 94
738149 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No 2 05 06 2015   grade_5 236 8 14 3   6     0   18   156 129                       285 236 8 14 3   6     0   18   156 129                 285
738152 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2015   grade_8 228 15 8 3   9     0   12   133 142                       275 228 15 8 3   9     0   12   133 142                 275
738154 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_10 210 13 5 3   6     0   7   138 106                       244 210 13 5 3   6     0   7   138 106                 244
739103 MA Worcester   school 2506780 153   Leominster 250678000987 1530505 Leominster High School   Regular School No 3 09 12 2015   grade_10 165 26 85 3   12     0   4   138 157                       295 165 26 85 3   12     0   4   138 157                 295
739434 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No 1 KG 05 2015   grade_5 3 12 52 3   9     0   1   50 30                       80 3 12 52 3   9     0   1   50 30                 80
739513 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2015   grade_8 75 40 210 3   38     1   13   197 183                       380 75 40 210 3   38     1   13   197 183                 380
739623 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_12 288 9 5 3   18     1   3   152 175                       327 288 9 5 3   18     1   3   152 175                 327
739710 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Martinson Elementary   Regular School No 1 PK 05 2015   grade_2 62 0 3 3   1     0   2   29 42                       71 62 0 3 3   1     0   2   29 42                 71
739946 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 05 2015   kindergarten 111 7 41 3   2     0   8   85 87                       172 111 7 41 3   2     0   8   85 87                 172
739947 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 05 2015   grade_1 110 4 41 3   5     0   11   82 92                       174 110 4 41 3   5     0   11   82 92                 174

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