enrollments

Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by asian 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
938351 938351 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No 1 KG 01 2016   kindergarten 103 5 21 2   99     0   6   126 110                       236 103 5 21 2   99     0   6   126 110                 236
941889 941889 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_10 247 12 169 2   99     0   13   307 235                       542 247 12 169 2   99     0   13   307 235                 542
936453 936453 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2016   grade_11 113 95 90 2   98     1   20   201 218                       419 113 95 90 2   98     1   20   201 218                 419
936008 936008 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_8 123 13 5 1   97     0   14   130 123                       253 123 13 5 1   97     0   14   130 123                 253
939559 939559 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No 3 09 12 2016   grade_9 341 4 6 0   96     0   10   246 211                       457 341 4 6 0   96     0   10   246 211                 457
941888 941888 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 227 21 190 3   96     0   25   327 235                       562 227 21 190 3   96     0   25   327 235                 562
936004 936004 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2016   grade_7 130 14 10 1   95     0   14   130 134                       264 130 14 10 1   95     0   14   130 134                 264
938361 938361 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No 1 01 04 2016   grade_4 91 10 15 1   95     0   7   113 106                       219 91 10 15 1   95     0   7   113 106                 219
937252 937252 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2016   grade_11 280 26 37 0   93     0   21   229 228                       457 280 26 37 0   93     0   21   229 228                 457
937942 937942 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No 2 06 08 2016   grade_8 50 2 3 0   93     0   1   79 70                       149 50 2 3 0   93     0   1   79 70                 149
938377 938377 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury Sr High   Regular School No 3 09 12 2016   grade_9 276 5 29 0   92     1   10   177 236                       413 276 5 29 0   92     1   10   177 236                 413
933744 933744 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2016   grade_6 6 18 24 1   91     0   4   73 71                       144 6 18 24 1   91     0   4   73 71                 144
936006 936006 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_6 143 13 4 0   91     0   20   128 143                       271 143 13 4 0   91     0   20   128 143                 271
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
932621 932621 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2016   grade_5 27 6 11 0   9     0   2   30 25                       55 27 6 11 0   9     0   2   30 25                 55
932635 932635 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_5 28 6 9 0   9     0   6   28 30                       58 28 6 9 0   9     0   6   28 30                 58
932692 932692 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No 1 KG 05 2016   grade_4 62 1 4 0   9     0   7   43 40                       83 62 1 4 0   9     0   7   43 40                 83
932695 932695 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2016   grade_1 66 1 2 0   9     0   4   38 44                       82 66 1 2 0   9     0   4   38 44                 82
932698 932698 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No 1 KG 05 2016   grade_4 62 1 2 0   9     0   2   42 34                       76 62 1 2 0   9     0   2   42 34                 76
932705 932705 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No 1 KG 05 2016   grade_5 35 0 2 0   9     0   2   22 26                       48 35 0 2 0   9     0   2   22 26                 48
932724 932724 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No 1 KG 05 2016   grade_5 39 3 3 0   9     0   4   32 26                       58 39 3 3 0   9     0   4   32 26                 58
932744 932744 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2016   grade_11 163 5 17 0   9     0   5   91 108                       199 163 5 17 0   9     0   5   91 108                 199
932745 932745 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2016   grade_12 159 1 13 0   9     0   4   99 87                       186 159 1 13 0   9     0   4   99 87                 186
932759 932759 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2016   grade_2 61 7 12 0   9     0   4   47 46                       93 61 7 12 0   9     0   4   47 46                 93
932842 932842 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2016   grade_4 307 27 52 0   9     0   18   227 186                       413 307 27 52 0   9     0   18   227 186                 413
932890 932890 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_4 164 1 7 0   9     0   4   96 89                       185 164 1 7 0   9     0   4   96 89                 185
932893 932893 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No 2 04 07 2016   grade_7 168 3 4 0   9     0   3   111 76                       187 168 3 4 0   9     0   3   111 76                 187
932913 932913 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2016   grade_4 42 3 8 0   9     0   8   32 38                       70 42 3 8 0   9     0   8   32 38                 70
932919 932919 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2016   kindergarten 74 1 1 0   9     0   21   61 45                       106 74 1 1 0   9     0   21   61 45                 106
932981 932981 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2016   grade_6 281 13 30 0   9     0   12   201 144                       345 281 13 30 0   9     0   12   201 144                 345
932982 932982 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2016   grade_7 266 11 33 0   9     0   9   173 155                       328 266 11 33 0   9     0   9   173 155                 328
932990 932990 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No 1 KG 05 2016   grade_1 65 2 4 0   9     0   8   41 47                       88 65 2 4 0   9     0   8   41 47                 88
933009 933009 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No 1 KG 05 2016   grade_2 72 3 4 0   9     0   0   44 44                       88 72 3 4 0   9     0   0   44 44                 88
933011 933011 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No 1 KG 05 2016   grade_4 51 2 3 0   9     0   0   33 32                       65 51 2 3 0   9     0   0   33 32                 65
933015 933015 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No 1 KG 05 2016   grade_2 82 5 5 0   9     0   0   53 48                       101 82 5 5 0   9     0   0   53 48                 101
933027 933027 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No 2 06 08 2016   grade_8 236 7 14 0   9     0   5   143 128                       271 236 7 14 0   9     0   5   143 128                 271
933078 933078 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_1 10 30 34 0   9     0   1   57 27                       84 10 30 34 0   9     0   1   57 27                 84
933081 933081 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_4 7 30 39 0   9     0   5   41 49                       90 7 30 39 0   9     0   5   41 49                 90
933082 933082 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_5 6 29 31 0   9     0   6   41 40                       81 6 29 31 0   9     0   6   41 40                 81
933083 933083 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_6 10 27 27 0   9     0   2   43 32                       75 10 27 27 0   9     0   2   43 32                 75
933177 933177 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Edward Everett   Regular School No 1 PK 05 2016   grade_4 1 22 12 0   9     0   3   26 21                       47 1 22 12 0   9     0   3   26 21                 47
933552 933552 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2016   kindergarten 1 22 26 0   9     1   1   31 29                       60 1 22 26 0   9     1   1   31 29                 60
933553 933553 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2016   pre_kindergarten 3 24 26 1   9     0   3   34 32                       66 3 24 26 1   9     0   3   34 32                 66
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
933895 933895 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 KG 05 2016   grade_2 40 1 4 1   9     0   0   25 30                       55 40 1 4 1   9     0   0   25 30                 55
933953 933953 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No 1 KG 05 2016   grade_2 33 51 10 0   9     0   5   47 61                       108 33 51 10 0   9     0   5   47 61                 108
933982 933982 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_2 24 72 16 2   9     0   10   62 71                       133 24 72 16 2   9     0   10   62 71                 133
933983 933983 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_3 19 73 18 1   9     0   4   68 56                       124 19 73 18 1   9     0   4   68 56                 124
933985 933985 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_5 53 101 16 0   9     0   9   93 95                       188 53 101 16 0   9     0   9   93 95                 188
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
934063 934063 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_7 53 5 10 0   9     0   8   45 40                       85 53 5 10 0   9     0   8   45 40                 85
934065 934065 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   kindergarten 31 1 9 0   9     0   11   33 28                       61 31 1 9 0   9     0   11   33 28                 61
934083 934083 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2016   grade_7 38 2 4 0   9     0   1   22 32                       54 38 2 4 0   9     0   1   22 32                 54
934100 934100 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_6 35 5 12 0   9     0   5   35 31                       66 35 5 12 0   9     0   5   35 31                 66
934114 934114 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_1 40 5 9 0   9     0   3   37 29                       66 40 5 9 0   9     0   3   37 29                 66
934117 934117 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_4 41 3 9 0   9     0   7   38 31                       69 41 3 9 0   9     0   7   38 31                 69
934138 934138 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No 1 KG 05 2016   grade_3 50 3 1 0   9     0   6   34 35                       69 50 3 1 0   9     0   6   34 35                 69
934198 934198 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No 1 PK 05 2016   grade_4 11 10 5 0   9     0   1   17 19                       36 11 10 5 0   9     0   1   17 19                 36
934221 934221 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No 1 PK 05 2016   kindergarten 28 9 1 0   9     0   3   16 34                       50 28 9 1 0   9     0   3   16 34                 50
934243 934243 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No 1 PK 05 2016   pre_kindergarten 11 22 6 0   9     0   2   21 29                       50 11 22 6 0   9     0   2   21 29                 50
934250 934250 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2016   grade_7 34 27 11 1   9     1   2   44 41                       85 34 27 11 1   9     1   2   44 41                 85
934257 934257 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2016   grade_8 37 26 13 0   9     0   6   45 46                       91 37 26 13 0   9     0   6   45 46                 91
934283 934283 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2016   grade_4 44 13 2 0   9     0   7   39 36                       75 44 13 2 0   9     0   7   39 36                 75
934301 934301 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_8 59 2 4 0   9     0   6   34 46                       80 59 2 4 0   9     0   6   34 46                 80
934321 934321 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No 1 KG 04 2016   grade_3 69 0 5 0   9     0   3   51 35                       86 69 0 5 0   9     0   3   51 35                 86
934385 934385 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Szetela Early Childhood Center   Regular School No 1 PK PK 2016   pre_kindergarten 200 5 50 0   9     0   3   164 103                       267 200 5 50 0   9     0   3   164 103                 267
934445 934445 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_7 160 8 97 1   9     0   8   144 139                       283 160 8 97 1   9     0   8   144 139                 283
934451 934451 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2016   grade_10 146 6 95 0   9     1   3   119 141                       260 146 6 95 0   9     1   3   119 141                 260
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
934498 934498 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No 1 PK 05 2016   kindergarten 56 7 11 0   9     0   4   48 39                       87 56 7 11 0   9     0   4   48 39                 87
934562 934562 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2016   grade_8 262 3 14 0   9     0   4   148 144                       292 262 3 14 0   9     0   4   148 144                 292
934565 934565 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2016   grade_11 233 2 12 2   9     0   5   122 141                       263 233 2 12 2   9     0   5   122 141                 263
934619 934619 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No 3 09 12 2016   grade_9 124 18 30 0   9     0   4   94 91                       185 124 18 30 0   9     0   4   94 91                 185
934620 934620 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No 3 09 12 2016   grade_10 112 16 21 0   9     0   4   79 83                       162 112 16 21 0   9     0   4   79 83                 162
934650 934650 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No 1 PK 05 2016   grade_4 68 1 5 0   9     0   3   51 35                       86 68 1 5 0   9     0   3   51 35                 86
934750 934750 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2016   grade_1 138 5 17 0   9     0   5   103 71                       174 138 5 17 0   9     0   5   103 71                 174
934777 934777 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_6 239 13 12 1   9     0   13   141 146                       287 239 13 12 1   9     0   13   141 146                 287
934778 934778 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_7 247 18 11 0   9     0   6   134 157                       291 247 18 11 0   9     0   6   134 157                 291
934832 934832 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_6 29 20 40 1   9     0   1   56 44                       100 29 20 40 1   9     0   1   56 44                 100
934899 934899 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2016   grade_2 60 16 40 0   9     0   16   66 75                       141 60 16 40 0   9     0   16   66 75                 141
934934 934934 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No 1 PK 05 2016   grade_4 90 11 23 0   9     0   9   80 62                       142 90 11 23 0   9     0   9   80 62                 142
934961 934961 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2016   grade_6 157 15 51 2   9     0   16   112 138                       250 157 15 51 2   9     0   16   112 138                 250
935007 935007 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_9 183 10 5 6   9     0   10   101 122                       223 183 10 5 6   9     0   10   101 122                 223
935010 935010 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_12 145 7 5 5   9     1   4   83 93                       176 145 7 5 5   9     1   4   83 93                 176
935031 935031 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2016   grade_3 38 6 60 0   9     1   9   62 61                       123 38 6 60 0   9     1   9   62 61                 123
935041 935041 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_3 20 2 28 0   9     0   13   36 36                       72 20 2 28 0   9     0   13   36 36                 72
935095 935095 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2016   grade_2 34 6 54 0   9     0   1   51 53                       104 34 6 54 0   9     0   1   51 53                 104
935103 935103 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No 1 KG 05 2016   grade_4 64 4 7 0   9     0   4   53 35                       88 64 4 7 0   9     0   4   53 35                 88
935105 935105 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No 1 KG 05 2016   kindergarten 57 3 12 0   9     0   7   49 39                       88 57 3 12 0   9     0   7   49 39                 88
935284 935284 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No 1 PK 01 2016   grade_1 107 1 6 0   9     0   6   65 64                       129 107 1 6 0   9     0   6   65 64                 129
935399 935399 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_8 79 1 3 0   9     0   1   42 51                       93 79 1 3 0   9     0   1   42 51                 93
935480 935480 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2016   grade_12 283 11 104 1   9     0   4   218 194                       412 283 11 104 1   9     0   4   218 194                 412
935507 935507 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_6 341 4 9 0   9     1   10   191 183                       374 341 4 9 0   9     1   10   191 183                 374
935509 935509 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_8 296 1 14 0   9     0   9   173 156                       329 296 1 14 0   9     0   9   173 156                 329
935927 935927 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No 1 KG 05 2016   grade_2 30 7 34 0   9     0   5   49 36                       85 30 7 34 0   9     0   5   49 36                 85
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
936033 936033 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No 1 PK 02 2016   kindergarten 111 2 3 0   9     0   3   61 67                       128 111 2 3 0   9     0   3   61 67                 128
936041 936041 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2016   grade_7 100 0 3 1   9     0   2   47 68                       115 100 0 3 1   9     0   2   47 68                 115
936060 936060 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2016   grade_7 77 5 5 0   9     0   5   55 46                       101 77 5 5 0   9     0   5   55 46                 101
936070 936070 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_7 99 1 5 1   9     0   4   58 61                       119 99 1 5 1   9     0   4   58 61                 119

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