enrollments

Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by black 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
933927 933927 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_1 17 98 30 2   0     0   15   90 72                       162 17 98 30 2   0     0   15   90 72                 162
934021 934021 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2016   grade_6 49 98 59 0   4     1   17   103 125                       228 49 98 59 0   4     1   17   103 125                 228
933791 933791 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2016   grade_12 5 97 20 2   7     0   4   82 53                       135 5 97 20 2   7     0   4   82 53                 135
933929 933929 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_3 18 97 26 1   0     0   5   73 74                       147 18 97 26 1   0     0   5   73 74                 147
933686 933686 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2016   grade_11 5 96 19 0   0     0   1   64 57                       121 5 96 19 0   0     0   1   64 57                 121
933754 933754 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2016   grade_9 33 96 91 2   69     1   6   136 162                       298 33 96 91 2   69     1   6   136 162                 298
934014 934014 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_8 29 96 32 0   7     0   10   90 84                       174 29 96 32 0   7     0   10   90 84                 174
936207 936207 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_9 253 96 223 0   259     0   24   432 423                       855 253 96 223 0   259     0   24   432 423                 855
937997 937997 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2016   grade_12 24 96 22 1   32     0   3   107 71                       178 24 96 22 1   32     0   3   107 71                 178
938810 938810 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_12 85 96 225 0   27     0   3   221 215                       436 85 96 225 0   27     0   3   221 215                 436
933991 933991 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 05 2016   grade_5 9 95 16 1   5     0   5   70 61                       131 9 95 16 1   5     0   5   70 61                 131
934012 934012 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_6 53 95 27 0   4     1   9   95 94                       189 53 95 27 0   4     1   9   95 94                 189
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
938811 938811 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_9 43 94 303 0   4     0   8   239 213                       452 43 94 303 0   4     0   8   239 213                 452
933698 933698 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   grade_10 7 93 111 0   1     0   6   122 96                       218 7 93 111 0   1     0   6   122 96                 218
933721 933721 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2016   grade_10 88 93 58 1   69     1   6   134 182                       316 88 93 58 1   69     1   6   134 182                 316
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
933634 933634 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2016   grade_8 3 92 85 0   12     1   3   96 100                       196 3 92 85 0   12     1   3   96 100                 196
933981 933981 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_1 21 92 14 2   8     0   7   79 65                       144 21 92 14 2   8     0   7   79 65                 144
938812 938812 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_10 39 92 281 0   5     0   4   226 195                       421 39 92 281 0   5     0   4   226 195                 421
941933 941933 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_12 166 92 39 0   0     0   5   164 138                       302 166 92 39 0   0     0   5   164 138                 302
933930 933930 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_4 12 91 30 1   1     0   7   69 73                       142 12 91 30 1   1     0   7   69 73                 142
934022 934022 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2016   grade_7 63 91 51 2   7     0   10   111 113                       224 63 91 51 2   7     0   10   111 113                 224
933699 933699 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Vocational Education School No 3 09 12 2016   grade_11 13 90 117 5   1     1   7   131 103                       234 13 90 117 5   1     1   7   131 103                 234
934859 934859 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2016   grade_9 164 90 235 3   24     1   8   281 244                       525 164 90 235 3   24     1   8   281 244                 525
936209 936209 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   grade_11 274 90 165 1   247     0   6   394 389                       783 274 90 165 1   247     0   6   394 389                 783
938842 938842 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_10 57 90 210 0   6     0   2   166 199                       365 57 90 210 0   6     0   2   166 199                 365
932627 932627 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_4 25 9 16 0   4     0   4   28 30                       58 25 9 16 0   4     0   4   28 30                 58
932677 932677 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_9 367 9 17 0   66     0   12   209 262                       471 367 9 17 0   66     0   12   209 262                 471
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
932782 932782 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_7 86 9 30 0   11     0   9   73 72                       145 86 9 30 0   11     0   9   73 72                 145
932810 932810 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No 1 PK 06 2016   kindergarten 34 9 1 0   2     0   3   27 22                       49 34 9 1 0   2     0   3   27 22                 49
932926 932926 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2016   grade_6 245 9 15 0   53     0   19   171 170                       341 245 9 15 0   53     0   19   171 170                 341
933153 933153 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   kindergarten 12 9 12 0   0     0   5   20 18                       38 12 9 12 0   0     0   5   20 18                 38
933183 933183 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2016   grade_3 37 9 21 0   3     0   1   37 34                       71 37 9 21 0   3     0   1   37 34                 71
933193 933193 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2016   grade_3 16 9 12 0   0     0   2   19 20                       39 16 9 12 0   0     0   2   19 20                 39
933197 933197 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2016   pre_kindergarten 16 9 13 0   3     0   1   23 19                       42 16 9 13 0   3     0   1   23 19                 42
933208 933208 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2016   grade_1 4 9 13 0   1     0   1   14 14                       28 4 9 13 0   1     0   1   14 14                 28
933283 933283 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2016   grade_4 1 9 13 0   0     0   0   7 16                       23 1 9 13 0   0     0   0   7 16                 23
933326 933326 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2016   grade_3 7 9 9 0   1     0   1   13 14                       27 7 9 9 0   1     0   1   13 14                 27
933382 933382 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2016   grade_5 1 9 8 0   1     0   0   8 11                       19 1 9 8 0   1     0   0   8 11                 19
933383 933383 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   kindergarten 13 9 4 0   1     0   1   19 9                       28 13 9 4 0   1     0   1   19 9                 28
933384 933384 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   pre_kindergarten 10 9 6 0   1     0   2   21 7                       28 10 9 6 0   1     0   2   21 7                 28
933389 933389 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   grade_5 4 9 5 0   4     0   0   12 10                       22 4 9 5 0   4     0   0   12 10                 22
933404 933404 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2016   grade_3 0 9 13 0   0     0   2   11 13                       24 0 9 13 0   0     0   2   11 13                 24
933413 933413 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2016   grade_5 15 9 6 0   1     0   0   16 15                       31 15 9 6 0   1     0   0   16 15                 31
933441 933441 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2016   grade_7 5 9 23 0   0     0   0   19 18                       37 5 9 23 0   0     0   0   19 18                 37
933451 933451 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 03 2016   pre_kindergarten 19 9 10 0   7     0   2   27 20                       47 19 9 10 0   7     0   2   27 20                 47
933464 933464 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No 1 PK 05 2016   grade_1 10 9 14 0   5     0   1   23 16                       39 10 9 14 0   5     0   1   23 16                 39
933491 933491 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No 1 PK 05 2016   pre_kindergarten 3 9 7 0   2     0   3   11 13                       24 3 9 7 0   2     0   3   11 13                 24
933497 933497 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   kindergarten 0 9 32 0   0     0   2   21 22                       43 0 9 32 0   0     0   2   21 22                 43
933503 933503 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_5 0 9 27 0   1     0   0   17 20                       37 0 9 27 0   1     0   0   17 20                 37
933506 933506 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   grade_8 1 9 15 1   0     0   0   18 8                       26 1 9 15 1   0     0   0   18 8                 26
933526 933526 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2016   grade_1 38 9 14 0   3     0   4   34 34                       68 38 9 14 0   3     0   4   34 34                 68
933576 933576 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   pre_kindergarten 4 9 9 0   8     0   1   11 20                       31 4 9 9 0   8     0   1   11 20                 31
933782 933782 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_6 20 9 132 1   6     0   2   86 84                       170 20 9 132 1   6     0   2   86 84                 170
933825 933825 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative Education School No 3 08 12 2016   grade_9 1 9 6 1   0     0   0   8 9                       17 1 9 6 1   0     0   0   8 9                 17
933892 933892 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No 1 KG 05 2016   grade_5 48 9 0 0   8     0   2   35 32                       67 48 9 0 0   8     0   2   35 32                 67
933898 933898 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No 1 KG 05 2016   grade_5 39 9 6 1   4     0   0   28 31                       59 39 9 6 1   4     0   0   28 31                 59
933993 933993 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 4 06 12 2016   grade_9 3 9 0 0   0     0   0   9 3                       12 3 9 0 0   0     0   0   9 3                 12
934030 934030 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No 3 08 12 2016   grade_10 9 9 16 0   1     0   5   31 9                       40 9 9 16 0   1     0   5   31 9                 40
934052 934052 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_5 34 9 5 0   22     0   7   40 37                       77 34 9 5 0   22     0   7   40 37                 77
934098 934098 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2016   grade_4 29 9 12 1   13     0   3   32 35                       67 29 9 12 1   13     0   3   32 35                 67
934154 934154 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No 2 06 08 2016   grade_7 216 9 8 1   29     0   9   147 125                       272 216 9 8 1   29     0   9   147 125                 272
934164 934164 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No 1 PK 05 2016   grade_1 34 9 7 0   5     0   5   34 26                       60 34 9 7 0   5     0   5   34 26                 60
934179 934179 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2016   kindergarten 32 9 4 0   2     0   2   22 27                       49 32 9 4 0   2     0   2   22 27                 49
934185 934185 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No 1 PK 05 2016   grade_5 20 9 5 0   3     0   2   16 23                       39 20 9 5 0   3     0   2   16 23                 39
934186 934186 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No 1 PK 05 2016   kindergarten 25 9 3 0   5     0   4   21 25                       46 25 9 3 0   5     0   4   21 25                 46
934203 934203 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2016   grade_2 21 9 7 1   5     0   3   24 22                       46 21 9 7 1   5     0   3   24 22                 46
934206 934206 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative Education School No 1 PK 05 2016   grade_5 15 9 5 0   3     0   1   15 18                       33 15 9 5 0   3     0   1   15 18                 33
934217 934217 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No 1 PK 05 2016   grade_2 15 9 5 0   7     0   6   20 22                       42 15 9 5 0   7     0   6   20 22                 42
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
934224 934224 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No 1 PK 05 2016   grade_2 24 9 8 0   3     0   3   21 26                       47 24 9 8 0   3     0   3   21 26                 47
934239 934239 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2016   grade_3 30 9 6 0   19     0   3   35 32                       67 30 9 6 0   19     0   3   35 32                 67
934240 934240 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative Education School No 1 PK 05 2016   grade_4 20 9 7 0   8     0   4   24 24                       48 20 9 7 0   8     0   4   24 24                 48
934355 934355 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2016   grade_4 21 9 116 0   1     0   2   76 73                       149 21 9 116 0   1     0   2   76 73                 149
934444 934444 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2016   grade_6 153 9 101 0   6     0   5   144 130                       274 153 9 101 0   6     0   5   144 130                 274
934483 934483 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No 3 09 12 2016   grade_12 60 9 25 0   3     0   0   48 49                       97 60 9 25 0   3     0   0   48 49                 97
934563 934563 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2016   grade_9 225 9 15 0   7     0   3   129 130                       259 225 9 15 0   7     0   3   129 130                 259
934667 934667 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No 1 KG 05 2016   grade_2 56 9 5 0   4     0   0   39 35                       74 56 9 5 0   4     0   0   39 35                 74
934802 934802 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   kindergarten 19 9 43 0   10     0   1   32 50                       82 19 9 43 0   10     0   1   32 50                 82
934806 934806 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_4 17 9 44 2   3     0   1   34 42                       76 17 9 44 2   3     0   1   34 42                 76
934808 934808 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2016   grade_6 14 9 38 0   4     0   1   31 35                       66 14 9 38 0   4     0   1   31 35                 66
934890 934890 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   grade_5 86 9 26 0   4     0   7   74 58                       132 86 9 26 0   4     0   7   74 58                 132
934897 934897 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2016   kindergarten 49 9 47 0   5     0   8   61 57                       118 49 9 47 0   5     0   8   61 57                 118
934909 934909 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No 1 PK 05 2016   grade_5 39 9 40 0   4     0   1   55 38                       93 39 9 40 0   4     0   1   55 38                 93
934912 934912 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_1 28 9 19 0   6     0   7   34 35                       69 28 9 19 0   6     0   7   34 35                 69
934915 934915 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_4 19 9 12 0   3     0   4   30 17                       47 19 9 12 0   3     0   4   30 17                 47
935020 935020 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2016   grade_2 52 9 48 0   4     1   9   65 58                       123 52 9 48 0   4     1   9   65 58                 123
935097 935097 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No 1 KG 05 2016   grade_4 29 9 52 0   2     0   4   53 43                       96 29 9 52 0   2     0   4   53 43                 96
935130 935130 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   grade_1 44 9 23 0   2     0   6   34 50                       84 44 9 23 0   2     0   6   34 50                 84
935132 935132 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   grade_3 48 9 24 0   2     0   9   44 48                       92 48 9 24 0   2     0   9   44 48                 92
935139 935139 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No 1 KG 05 2016   grade_4 57 9 10 0   2     0   3   44 37                       81 57 9 10 0   2     0   3   44 37                 81
935149 935149 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_8 109 9 71 0   18     1   10   115 103                       218 109 9 71 0   18     1   10   115 103                 218
935476 935476 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_8 130 9 90 0   5     0   1   113 122                       235 130 9 90 0   5     0   1   113 122                 235
935478 935478 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2016   grade_10 299 9 112 0   5     0   4   219 210                       429 299 9 112 0   5     0   4   219 210                 429
935657 935657 MA Middlesex   school 2506330 139   Hopkinton 250633000920 1390505 Hopkinton High   Regular School No 3 09 12 2016   grade_12 271 9 6 1   19     0   1   153 154                       307 271 9 6 1   19     0   1   153 154                 307
935940 935940 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No 1 KG 05 2016   grade_3 56 9 39 1   3     0   4   49 63                       112 56 9 39 1   3     0   4   49 63                 112
935975 935975 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2016   grade_2 56 9 2 0   26     0   8   61 40                       101 56 9 2 0   26     0   8   61 40                 101
935981 935981 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2016   grade_2 38 9 2 0   38     0   7   47 47                       94 38 9 2 0   38     0   7   47 47                 94

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