enrollments

Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by native_hawaiian_pacific_islander descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 9,499 ✖
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
937899 937899 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2016   grade_1 37 11 11 0   51     8   3   60 61                       121 37 11 11 0   51     8   3   60 61                 121
935273 935273 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2016   grade_10 186 2 18 0   3     5   3   110 107                       217 186 2 18 0   3     5   3   110 107                 217
935348 935348 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_5 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
934457 934457 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No 3 09 12 2016   grade_11 248 8 86 1   9     4   7   210 153                       363 248 8 86 1   9     4   7   210 153                 363
935154 935154 MA Norfolk   school 2505010 101   Franklin 250501000986 1010003 Franklin Early Childhood Development Center   Regular School No 1 PK PK 2016   pre_kindergarten 106 1 6 0   8     4   6   79 52                       131 106 1 6 0   8     4   6   79 52                 131
935271 935271 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2016   grade_8 164 3 15 0   4     4   7   94 103                       197 164 3 15 0   4     4   7   94 103                 197
935949 935949 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2016   grade_8 159 23 88 1   9     4   10   146 148                       294 159 23 88 1   9     4   10   146 148                 294
937114 937114 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_10 123 50 189 4   4     4   19   216 177                       393 123 50 189 4   4     4   19   216 177                 393
933996 933996 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2016   grade_1 21 65 14 1   1     3   13   65 53                       118 21 65 14 1   1     3   13   65 53                 118
934024 934024 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_9 267 694 166 5   26     3   51   637 575                       1212 267 694 166 5   26     3   51   637 575                 1212
934025 934025 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2016   grade_10 183 648 120 4   34     3   30   535 487                       1022 183 648 120 4   34     3   30   535 487                 1022
935342 935342 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   kindergarten 26 0 6 0   0     3   3   24 14                       38 26 0 6 0   0     3   3   24 14                 38
935347 935347 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_4 43 2 3 0   1     3   2   27 27                       54 43 2 3 0   1     3   2   27 27                 54
936234 936234 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_6 118 3 12 1   2     3   1   74 66                       140 118 3 12 1   2     3   1   74 66                 140
936867 936867 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2016   grade_10 160 62 8 0   18     3   10   131 130                       261 160 62 8 0   18     3   10   131 130                 261
937115 937115 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_11 284 93 276 5   6     3   28   351 344                       695 284 93 276 5   6     3   28   351 344                 695
937116 937116 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_12 188 54 125 1   4     3   26   215 186                       401 188 54 125 1   4     3   26   215 186                 401
937358 937358 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2016   grade_8 275 10 30 0   28     3   4   164 186                       350 275 10 30 0   28     3   4   164 186                 350
937361 937361 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2016   grade_11 249 11 24 0   21     3   10   144 174                       318 249 11 24 0   21     3   10   144 174                 318
938887 938887 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 South Elementary   Regular School No 1 KG 05 2016   grade_3 28 8 1 1   2     3   4   19 28                       47 28 8 1 1   2     3   4   19 28                 47
939058 939058 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_9 339 69 58 0   14     3   22   272 233                       505 339 69 58 0   14     3   22   272 233                 505
941197 941197 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No 1 KG 05 2016   grade_1 37 0 0 0   0     3   1   18 23                       41 37 0 0 0   0     3   1   18 23                 41
941447 941447 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2016   grade_12 316 4 12 0   31     3   7   178 195                       373 316 4 12 0   31     3   7   178 195                 373
932682 932682 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No 1 KG 05 2016   kindergarten 48 0 1 0   15     2   2   30 38                       68 48 0 1 0   15     2   2   30 38                 68
932729 932729 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2016   grade_10 257 14 12 0   22     2   6   157 156                       313 257 14 12 0   22     2   6   157 156                 313
932778 932778 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_7 95 9 17 0   6     2   12   79 62                       141 95 9 17 0   6     2   12   79 62                 141
932785 932785 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2016   grade_10 312 24 54 2   21     2   23   230 208                       438 312 24 54 2   21     2   23   230 208                 438
932845 932845 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_7 264 27 42 1   3     2   13   203 149                       352 264 27 42 1   3     2   13   203 149                 352
932847 932847 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_9 284 30 28 3   16     2   21   186 198                       384 284 30 28 3   16     2   21   186 198                 384
932848 932848 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_10 275 28 40 6   16     2   14   187 194                       381 275 28 40 6   16     2   14   187 194                 381
932862 932862 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2016   grade_9 152 18 14 1   19     2   16   115 107                       222 152 18 14 1   19     2   16   115 107                 222
932984 932984 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2016   grade_9 234 14 30 0   8     2   7   132 163                       295 234 14 30 0   8     2   7   132 163                 295
932986 932986 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2016   grade_11 281 11 26 0   6     2   4   177 153                       330 281 11 26 0   6     2   4   177 153                 330
933033 933033 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No 3 09 12 2016   grade_10 283 6 11 0   16     2   5   160 163                       323 283 6 11 0   16     2   5   160 163                 323
933292 933292 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2016   grade_3 0 35 20 0   5     2   3   30 35                       65 0 35 20 0   5     2   3   30 35                 65
933429 933429 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_5 39 17 43 0   5     2   1   60 47                       107 39 17 43 0   5     2   1   60 47                 107
933563 933563 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_3 3 43 28 0   0     2   1   36 41                       77 3 43 28 0   0     2   1   36 41                 77
933666 933666 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2016   grade_9 3 49 102 0   3     2   1   91 69                       160 3 49 102 0   3     2   1   91 69                 160
933722 933722 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2016   grade_11 72 79 63 1   56     2   7   117 163                       280 72 79 63 1   56     2   7   117 163                 280
933729 933729 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative Education School No 3 11 12 2016   grade_12 4 63 28 0   2     2   3   59 43                       102 4 63 28 0   2     2   3   59 43                 102
933797 933797 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No 3 09 12 2016   grade_9 8 47 79 0   9     2   1   77 69                       146 8 47 79 0   9     2   1   77 69                 146
933829 933829 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   kindergarten 67 2 7 1   1     2   6   48 38                       86 67 2 7 1   1     2   6   48 38                 86
933958 933958 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_1 18 73 14 0   2     2   6   55 60                       115 18 73 14 0   2     2   6   55 60                 115
934007 934007 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2016   grade_7 21 123 24 0   1     2   9   98 82                       180 21 123 24 0   1     2   9   98 82                 180
934015 934015 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2016   grade_6 53 115 34 1   9     2   15   126 103                       229 53 115 34 1   9     2   15   126 103                 229
934016 934016 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2016   grade_7 55 124 28 0   5     2   10   113 111                       224 55 124 28 0   5     2   10   113 111                 224
934017 934017 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2016   grade_8 65 119 31 1   8     2   8   120 114                       234 65 119 31 1   8     2   8   120 114                 234
934251 934251 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2016   grade_8 29 34 13 2   3     2   4   49 38                       87 29 34 13 2   3     2   4   49 38                 87
934263 934263 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2016   grade_11 192 135 61 2   58     2   14   242 222                       464 192 135 61 2   58     2   14   242 222                 464
934280 934280 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2016   grade_1 41 3 5 0   11     2   1   33 30                       63 41 3 5 0   11     2   1   33 30                 63
934281 934281 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2016   grade_2 65 6 2 0   12     2   4   45 46                       91 65 6 2 0   12     2   4   45 46                 91
934682 934682 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No 3 09 12 2016   grade_11 156 11 12 0   11     2   5   99 98                       197 156 11 12 0   11     2   5   99 98                 197
934710 934710 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2016   grade_10 153 8 3 0   0     2   2   84 84                       168 153 8 3 0   0     2   2   84 84                 168
934974 934974 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2016   grade_9 330 48 149 2   29     2   29   312 277                       589 330 48 149 2   29     2   29   312 277                 589
935196 935196 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2016   grade_8 140 0 3 0   8     2   7   81 79                       160 140 0 3 0   8     2   7   81 79                 160
935200 935200 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   grade_9 380 7 5 2   26     2   8   209 221                       430 380 7 5 2   26     2   8   209 221                 430
935218 935218 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   grade_12 97 3 5 2   2     2   3   67 47                       114 97 3 5 2   2     2   3   67 47                 114
935227 935227 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No 1 KG 06 2016   grade_2 197 2 3 0   3     2   2   105 104                       209 197 2 3 0   3     2   2   105 104                 209
935287 935287 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2016   grade_4 88 0 6 3   8     2   3   62 48                       110 88 0 6 3   8     2   3   62 48                 110
935343 935343 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   pre_kindergarten 32 3 2 0   0     2   0   22 17                       39 32 3 2 0   0     2   0   22 17                 39
935346 935346 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_3 36 0 5 0   0     2   1   26 18                       44 36 0 5 0   0     2   1   26 18                 44
935473 935473 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_5 54 0 77 0   5     2   2   64 76                       140 54 0 77 0   5     2   2   64 76                 140
936049 936049 MA Hampden   school 2506990 159   Longmeadow 250699001016 1590005 Blueberry Hill   Regular School No 1 KG 05 2016   grade_2 64 0 4 0   19     2   3   43 49                       92 64 0 4 0   19     2   3   43 49                 92
936212 936212 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2016   kindergarten 112 1 21 1   1     2   5   72 71                       143 112 1 21 1   1     2   5   72 71                 143
936220 936220 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2016   grade_7 204 5 15 1   3     2   5   110 125                       235 204 5 15 1   3     2   5   110 125                 235
936223 936223 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No 3 09 12 2016   grade_10 209 3 24 1   1     2   5   119 126                       245 209 3 24 1   1     2   5   119 126                 245
936468 936468 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2016   grade_12 280 9 7 2   16     2   2   158 160                       318 280 9 7 2   16     2   2   158 160                 318
936876 936876 MA Hampden   school 2508040 191   Monson 250804002589 1910025 Quarry Hill Community School   Regular School No 1 PK 04 2016   grade_4 60 0 2 0   2     2   2   34 34                       68 60 0 2 0   2     2   2   34 34                 68
936878 936878 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2016   grade_6 93 1 1 0   0     2   3   51 49                       100 93 1 1 0   0     2   3   51 49                 100
937105 937105 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2016   grade_7 122 49 101 2   4     2   21   153 148                       301 122 49 101 2   4     2   21   153 148                 301
937106 937106 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2016   grade_8 103 55 88 3   5     2   19   142 133                       275 103 55 88 3   5     2   19   142 133                 275
937108 937108 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2016   grade_7 193 26 101 4   3     2   11   193 147                       340 193 26 101 4   3     2   11   193 147                 340
937109 937109 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2016   grade_8 218 28 101 1   1     2   18   192 177                       369 218 28 101 1   1     2   18   192 177                 369
937112 937112 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2016   grade_8 125 27 94 1   2     2   7   131 127                       258 125 27 94 1   2     2   7   131 127                 258
937246 937246 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2016   grade_10 370 24 43 0   81     2   20   280 260                       540 370 24 43 0   81     2   20   280 260                 540
937291 937291 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2016   grade_12 65 6 7 2   0     2   9   38 53                       91 65 6 7 2   0     2   9   38 53                 91
937359 937359 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2016   grade_9 311 10 34 0   22     2   5   186 198                       384 311 10 34 0   22     2   5   186 198                 384
937362 937362 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2016   grade_12 286 5 21 0   24     2   1   174 165                       339 286 5 21 0   24     2   1   174 165                 339
937429 937429 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No 2 06 08 2016   grade_8 169 3 8 1   20     2   4   120 87                       207 169 3 8 1   20     2   4   120 87                 207
937481 937481 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2016   grade_10 204 1 6 0   9     2   1   104 119                       223 204 1 6 0   9     2   1   104 119                 223
937500 937500 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2016   grade_11 195 3 0 0   1     2   2   98 105                       203 195 3 0 0   1     2   2   98 105                 203
937556 937556 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2016   grade_12 193 38 14 0   15     2   1   147 116                       263 193 38 14 0   15     2   1   147 116                 263
937564 937564 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2016   grade_6 18 4 4 0   0     2   0   21 7                       28 18 4 4 0   0     2   0   21 7                 28
937593 937593 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2016   grade_6 117 2 11 2   1     2   5   58 82                       140 117 2 11 2   1     2   5   58 82                 140
937707 937707 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No 3 09 12 2016   grade_10 268 1 1 0   3     2   2   146 131                       277 268 1 1 0   3     2   2   146 131                 277
937855 937855 MA Plymouth   school 2509720 239   Plymouth 250972000325 2390515 Plymouth South High   Regular School No 3 09 12 2016   grade_11 222 3 2 4   2     2   9   139 105                       244 222 3 2 4   2     2   9   139 105                 244
937890 937890 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No 1 KG 04 2016   grade_3 40 10 10 0   23     2   2   51 36                       87 40 10 10 0   23     2   2   51 36                 87
937900 937900 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2016   grade_2 42 11 7 0   64     2   6   82 50                       132 42 11 7 0   64     2   6   82 50                 132
937902 937902 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No 1 KG 04 2016   grade_4 35 11 7 0   32     2   2   50 39                       89 35 11 7 0   32     2   2   50 39                 89
937946 937946 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2016   grade_6 108 5 5 0   90     2   5   120 95                       215 108 5 5 0   90     2   5   120 95                 215
937957 937957 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2016   grade_9 252 21 27 1   61     2   14   225 153                       378 252 21 27 1   61     2   14   225 153                 378
937958 937958 MA Norfolk   school 2509870 243   Quincy 250987001579 2430505 Quincy High   Regular School No 3 09 12 2016   grade_10 213 35 25 3   77     2   12   196 171                       367 213 35 25 3   77     2   12   196 171                 367
937993 937993 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2016   grade_8 24 133 27 1   30     2   4   107 114                       221 24 133 27 1   30     2   4   107 114                 221
938210 938210 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No 1 PK 02 2016   kindergarten 187 2 7 0   5     2   0   96 107                       203 187 2 7 0   5     2   0   96 107                 203
938926 938926 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2016   grade_2 68 1 2 1   16     2   1   54 37                       91 68 1 2 1   16     2   1   54 37                 91
938927 938927 MA Middlesex   school 2511340 288   Sudbury 251134001407 2880015 Israel Loring School   Regular School No 1 KG 05 2016   grade_3 58 2 5 1   8     2   3   43 36                       79 58 2 5 1   8     2   3   43 36                 79
938989 938989 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2016   grade_10 132 7 17 0   4     2   1   81 82                       163 132 7 17 0   4     2   1   81 82                 163
938990 938990 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2016   grade_11 164 12 12 0   1     2   3   104 90                       194 164 12 12 0   1     2   3   104 90                 194
939012 939012 MA Bristol   school 2511520 293   Taunton 251152000133 2930005 Edward F. Leddy Preschool   Regular School No 1 PK PK 2016   pre_kindergarten 200 31 28 0   4     2   13   150 128                       278 200 31 28 0   4     2   13   150 128                 278
939057 939057 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_8 458 74 79 0   6     2   20   331 308                       639 458 74 79 0   6     2   20   331 308                 639

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