enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
2239998 2239998 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_6 2 94 10 1   0     0   0   52 55                       107.0 2 94 10 1   0     0   0   52 55                 107
736806 736806 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_12 9 93 74 1   42     0   1   118 102                       220 9 93 74 1   42     0   1   118 102                 220
740276 740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
741996 741996 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_11 73 93 212 0   26     0   16   210 210                       420 73 93 212 0   26     0   16   210 210                 420
743479 743479 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_12 16 93 48 1   3     1   4   73 93                       166 16 93 48 1   3     1   4   73 93                 166
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
1123643 1123643 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2017   grade_2 16 93 14 1   8     1   5   71 67                       138 16 93 14 1   8     1   5   71 67                 138
1128426 1128426 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2017   grade_10 9 93 19 0   24     0   9   87 67                       154 9 93 19 0   24     0   9   87 67                 154
1673176 1673176 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston - Madison Park High   Career and Technical School No High 09 12 2021   grade_11 5 93 124 2   1     1   3   130 99 *                     229.0 5 93 124 2   1     1   3   130 99                 229
1673261 1673261 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_10 3 93 39 0   5     0   9   93 56 *                     149.0 3 93 39 0   5     0   9   93 56                 149
1679806 1679806 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_9 3 93 50 0   1     0   1   72 76 *                     148.0 3 93 50 0   1     0   1   72 76                 148
2041307 2041307 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2019   grade_8 48 93 20 1   5     0   6   97 76                       173.0 48 93 20 1   5     0   6   97 76                 173
2041310 2041310 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2019   grade_8 51 93 72 1   7     0   9   113 120                       233.0 51 93 72 1   7     0   9   113 120                 233
2047613 2047613 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_4 14 93 67 1   4     0   4   85 98                       183.0 14 93 67 1   4     0   4   85 98                 183
2230467 2230467 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton: Oscar F Raymond   Regular School No Elementary KG 05 2018   grade_4 17 93 11 0   2     0   10   66 67                       133.0 17 93 11 0   2     0   10   66 67                 133
2233119 2233119 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_10 227 93 199 0   240     1   20   393 387                       780.0 227 93 199 0   240     1   20   393 387                 780
2236520 2236520 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_10 308 93 62 0   8     2   19   232 260                       492.0 308 93 62 0   8     2   19   232 260                 492
2238028 2238028 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   kindergarten 4 93 74 0   5     0   2   86 92                       178.0 4 93 74 0   5     0   2   86 92                 178
741165 741165 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No 3 09 12 2015   grade_9 25 92 14 1   36     1   10   97 82                       179 25 92 14 1   36     1   10   97 82                 179
745112 745112 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 175 92 39 0   1     0   6   168 145                       313 175 92 39 0   1     0   6   168 145                 313
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
1123311 1123311 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2017   grade_10 3 92 129 0   2     0   8   127 107                       234 3 92 129 0   2     0   8   127 107                 234
1123688 1123688 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2017   grade_7 49 92 27 1   8     1   13   102 89                       191 49 92 27 1   8     1   13   102 89                 191
1124685 1124685 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2017   grade_10 148 92 244 1   21     1   7   265 249                       514 148 92 244 1   21     1   7   265 249                 514
1126301 1126301 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_10 226 92 178 0   248     0   19   371 392                       763 226 92 178 0   248     0   19   371 392                 763
1133178 1133178 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_6 1 92 10 0   0     0   2   55 50                       105 1 92 10 0   0     0   2   55 50                 105
1133179 1133179 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_7 4 92 8 0   0     0   0   59 45                       104 4 92 8 0   0     0   0   59 45                 104
1366025 1366025 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_11 4 92 32 1   5     0   0   66 68 *                     134.0 4 92 32 1   5     0   0   66 68                 134
1370219 1370219 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2020   grade_7 25 92 45 1   44     0   14   118 103 *                     221.0 25 92 45 1   44     0   14   118 103                 221
1370224 1370224 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2020   grade_12 15 92 15 0   30     1   4   87 70 *                     157.0 15 92 15 0   30     1   4   87 70                 157
1673414 1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1681493 1681493 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_11 1 92 8 0   0     0   0   49 52 *                     101.0 1 92 8 0   0     0   0   49 52                 101
2047610 2047610 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_1 4 92 76 0   5     0   2   86 93                       179.0 4 92 76 0   5     0   2   86 93                 179
2230088 2230088 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston: Charlestown High   Regular School No High 09 12 2018   grade_12 13 92 93 0   42     0   2   132 110                       242.0 13 92 93 0   42     0   2   132 110                 242
736893 736893 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2015   grade_12 31 91 57 0   57     1   1   111 127                       238 31 91 57 0   57     1   1   111 127                 238
737123 737123 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_4 9 91 17 1   4     0   6   69 59                       128 9 91 17 1   4     0   6   69 59                 128
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
1123380 1123380 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_12 26 91 80 1   62     0   5   110 155                       265 26 91 80 1   62     0   5   110 155                 265
1370222 1370222 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2020   grade_10 18 91 28 0   29     1   3   100 70 *                     170.0 18 91 28 0   29     1   3   100 70                 170
1372543 1372543 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_9 5 91 32 0   1     0   2   71 60 *                     131.0 5 91 32 0   1     0   2   71 60                 131
1673471 1673471 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton - Joseph F. Plouffe Academy   Regular School No Middle 06 08 2021   grade_6 35 91 83 1   6     1   8   109 116 *                     225.0 35 91 83 1   6     1   8   109 116                 225
1679800 1679800 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_3 4 91 94 1   4     0   2   104 92 *                     196.0 4 91 94 1   4     0   2   104 92                 196
2040405 2040405 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_4 1 91 11 1   2     0   3   60 49                       109.0 1 91 11 1   2     0   3   60 49                 109
2041243 2041243 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_2 16 91 20 0   1     0   7   68 67                       135.0 16 91 20 0   1     0   7   68 67                 135
2230041 2230041 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston: Lilla G. Frederick Middle School   Regular School No Middle 06 08 2018   grade_8 3 91 87 0   18     0   3   107 95                       202.0 3 91 87 0   18     0   3   107 95                 202
2230118 2230118 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston: Madison Park High   Career and Technical School No High 09 12 2018   grade_12 8 91 84 1   3     1   3   107 84                       191.0 8 91 84 1   3     1   3   107 84                 191
2231502 2231502 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_10 132 91 266 2   27     2   5   271 254                       525.0 132 91 266 2   27     2   5   271 254                 525
2235243 2235243 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph: Randolph Community Middle   Regular School No Middle 06 08 2018   grade_7 28 91 29 1   32     0   10   95 96                       191.0 28 91 29 1   32     0   10   95 96                 191
736817 736817 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No 3 09 12 2015   grade_9 4 90 38 0   2     0   1   85 50                       135 4 90 38 0   2     0   1   85 50                 135
743790 743790 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2015   grade_8 13 90 53 0   5     0   3   80 84                       164 13 90 53 0   5     0   3   80 84                 164
743819 743819 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_8 2 90 60 0   0     0   4   75 81                       156 2 90 60 0   0     0   4   75 81                 156
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
1123339 1123339 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_11 82 90 56 1   68     1   5   127 176                       303 82 90 56 1   68     1   5   127 176                 303
1126594 1126594 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_10 135 90 97 3   109     0   13   216 231                       447 135 90 97 3   109     0   13   216 231                 447
1129701 1129701 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_8 435 90 90 1   5     0   23   319 325                       644 435 90 90 1   5     0   23   319 325                 644
1367090 1367090 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_11 96 90 221 0   24     0   11   233 209 *                     442.0 96 90 221 0   24     0   11   233 209                 442
1370221 1370221 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2020   grade_9 13 90 22 0   22     0   12   91 68 *                     159.0 13 90 22 0   22     0   12   91 68                 159
1673436 1673436 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_1 8 90 11 0   0     2   2   67 46 *                     113.0 8 90 11 0   0     2   2   67 46                 113
1677470 1677470 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   grade_10 16 90 25 0   25     0   9   95 70 *                     165.0 16 90 25 0   25     0   9   95 70                 165
1677471 1677471 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   grade_11 15 90 28 0   31     0   2   105 61 *                     166.0 15 90 28 0   31     0   2   105 61                 166
1679941 1679941 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_5 31 90 5 0   11     0   12   71 78 *                     149.0 31 90 5 0   11     0   12   71 78                 149
1679944 1679944 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_8 34 90 4 0   15     0   8   72 79 *                     151.0 34 90 4 0   15     0   8   72 79                 151
2046377 2046377 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_11 311 90 63 0   8     2   15   224 264                       489.0 311 90 63 0   8     2   15   224 264                 489
2229470 2229470 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston: Charles H Taylor   Regular School No Elementary PK 05 2018   grade_3 0 90 11 1   1     0   4   56 51                       107.0 0 90 11 1   1     0   4   56 51                 107
2234204 2234204 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_10 179 90 285 4   5     1   22   325 261                       586.0 179 90 285 4   5     1   22   325 261                 586
2238356 2238356 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_6 4 90 69 0   16     1   3   89 94                       183.0 4 90 69 0   16     1   3   89 94                 183
735869 735869 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_12 142 9 8 0   4     0   5   80 88                       168 142 9 8 0   4     0   5   80 88                 168
735898 735898 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_7 134 9 11 0   8     0   4   94 72                       166 134 9 11 0   8     0   4   94 72                 166
736056 736056 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_5 240 9 14 0   54     0   22   165 174                       339 240 9 14 0   54     0   22   165 174                 339
736112 736112 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No 2 06 08 2015   grade_6 268 9 30 0   7     0   8   170 152                       322 268 9 30 0   7     0   8   170 152                 322
736118 736118 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2015   grade_12 281 9 26 0   7     0   2   135 190                       325 281 9 26 0   7     0   2   135 190                 325
736183 736183 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No 1 PK 01 2015   kindergarten 0 9 24 0   4     0   1   17 21                       38 0 9 24 0   4     0   1   17 21                 38
736317 736317 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   grade_3 23 9 5 0   1     0   1   17 22                       39 23 9 5 0   1     0   1   17 22                 39
736325 736325 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2015   grade_1 9 9 20 0   0     0   3   17 24                       41 9 9 20 0   0     0   3   17 24                 41
736326 736326 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No 1 PK 05 2015   grade_2 17 9 14 0   0     0   3   23 20                       43 17 9 14 0   0     0   3   23 20                 43
736345 736345 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2015   grade_4 2 9 7 0   2     0   2   12 10                       22 2 9 7 0   2     0   2   12 10                 22
736414 736414 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_4 5 9 7 1   0     0   1   15 8                       23 5 9 7 1   0     0   1   15 8                 23
736415 736415 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No 1 PK 05 2015   grade_5 6 9 5 0   1     0   2   13 10                       23 6 9 5 0   1     0   2   13 10                 23
736513 736513 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No 1 KG 05 2015   grade_5 5 9 6 0   2     0   1   16 7                       23 5 9 6 0   2     0   1   16 7                 23
736523 736523 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_1 22 9 15 0   20     0   1   38 29                       67 22 9 15 0   20     0   1   38 29                 67
736531 736531 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   kindergarten 2 9 6 0   1     0   2   5 15                       20 2 9 6 0   1     0   2   5 15                 20
736534 736534 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2015   grade_2 0 9 11 0   0     0   2   10 12                       22 0 9 11 0   0     0   2   10 12                 22
736584 736584 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_2 24 9 14 0   2     0   0   29 20                       49 24 9 14 0   2     0   0   29 20                 49
736586 736586 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No 1 PK 04 2015   grade_4 7 9 5 0   2     0   0   14 9                       23 7 9 5 0   2     0   0   14 9                 23
736629 736629 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   kindergarten 1 9 29 0   1     1   0   19 22                       41 1 9 29 0   1     1   0   19 22                 41
736644 736644 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2015   grade_4 8 9 24 0   3     1   1   25 21                       46 8 9 24 0   3     1   1   25 21                 46
736649 736649 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No 1 PK 05 2015   kindergarten 9 9 7 0   15     0   3   16 27                       43 9 9 7 0   15     0   3   16 27                 43
736689 736689 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_3 1 9 26 0   5     0   4   22 23                       45 1 9 26 0   5     0   4   22 23                 45
736690 736690 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2015   grade_4 2 9 25 0   3     0   1   19 21                       40 2 9 25 0   3     0   1   19 21                 40
736911 736911 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_11 13 9 11 0   1     0   2   20 16                       36 13 9 11 0   1     0   2   20 16                 36
736912 736912 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Lyon Upper 9-12   Regular School No 3 09 12 2015   grade_12 9 9 9 0   3     0   2   20 12                       32 9 9 9 0   3     0   2   20 12                 32

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