enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by black_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 500 ✖

grade ✖

  • grade_7 · 500 ✖
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
1366226 1366226 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No Middle 06 08 2020   grade_7 24 199 33 2   3     0   11   139 133 *                     272.0 24 199 33 2   3     0   11   139 133                 272
1366233 1366233 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2020   grade_7 53 154 23 2   8     0   7   137 110 *                     247.0 53 154 23 2   8     0   7   137 110                 247
1366230 1366230 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2020   grade_7 25 136 30 0   0     0   7   108 90 *                     198.0 25 136 30 0   0     0   7   108 90                 198
1372860 1372860 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_7 0 134 98 0   1     0   1   119 115 *                     234.0 0 134 98 0   1     0   1   119 115                 234
1366239 1366239 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2020   grade_7 50 122 77 1   8     0   14   142 130 *                     272.0 50 122 77 1   8     0   14   142 130                 272
1366236 1366236 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2020   grade_7 64 117 25 2   7     2   4   96 125 *                     221.0 64 117 25 2   7     2   4   96 125                 221
1374253 1374253 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
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
1372679 1372679 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_7 33 86 4 0   15     0   10   69 79 *                     148.0 33 86 4 0   15     0   10   69 79                 148
1366181 1366181 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_7 16 84 19 1   2     0   7   65 64 *                     129.0 16 84 19 1   2     0   7   65 64                 129
1372541 1372541 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_7 8 82 81 1   2     0   8   93 89 *                     182.0 8 82 81 1   2     0   8   93 89                 182
1372386 1372386 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2020   grade_7 168 71 167 2   29     0   24   236 225 *                     461.0 168 71 167 2   29     0   24   236 225                 461
1366021 1366021 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_7 7 67 35 0   2     0   5   58 58 *                     116.0 7 67 35 0   2     0   5   58 58                 116
1372391 1372391 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2020   grade_7 134 67 168 2   42     0   17   226 204 *                     430.0 134 67 168 2   42     0   17   226 204                 430
1372490 1372490 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_7 2 65 24 0   1     0   5   52 45 *                     97.0 2 65 24 0   1     0   5   52 45                 97
1372510 1372510 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2020   grade_7 0 64 16 0   0     0   0   42 38 *                     80.0 0 64 16 0   0     0   0   42 38                 80
1371142 1371142 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2020   grade_7 155 63 39 0   8     5   22   135 157 *                     292.0 155 63 39 0   8     5   22   135 157                 292
1372388 1372388 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_7 70 62 187 0   19     1   14   175 178 *                     353.0 70 62 187 0   19     1   14   175 178                 353
1372666 1372666 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_7 21 61 32 0   1     0   0   56 59 *                     115.0 21 61 32 0   1     0   0   56 59                 115
1372831 1372831 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2020   grade_7 3 61 77 0   0     1   3   79 66 *                     145.0 3 61 77 0   0     1   3   79 66                 145
1365869 1365869 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2020   grade_7 2 57 70 0   13     1   6   87 62 *                     149.0 2 57 70 0   13     1   6   87 62                 149
1372384 1372384 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2020   grade_7 106 57 161 0   15     0   22   188 173 *                     361.0 106 57 161 0   15     0   22   188 173                 361
1371009 1371009 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2020   grade_7 22 56 160 0   3     0   4   145 100 *                     245.0 22 56 160 0   3     0   4   145 100                 245
1365958 1365958 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2020   grade_7 93 53 81 1   44     0   14   120 166 *                     286.0 93 53 81 1   44     0   14   120 166                 286
1365846 1365846 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_7 2 52 38 0   0     0   2   55 39 *                     94.0 2 52 38 0   0     0   2   55 39                 94
1368587 1368587 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2020   grade_7 62 51 348 1   43     0   13   255 263 *                     518.0 62 51 348 1   43     0   13   255 263                 518
1369084 1369084 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2020   grade_7 231 50 11 0   20     1   11   159 165 *                     324.0 231 50 11 0   20     1   11   159 165                 324
1370996 1370996 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2020   grade_7 28 50 88 0   2     0   5   93 80 *                     173.0 28 50 88 0   2     0   5   93 80                 173
1372589 1372589 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2020   grade_7 3 50 6 0   3     1   3   36 30 *                     66.0 3 50 6 0   3     1   3   36 30                 66
1365386 1365386 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_7 2 49 26 0   3     2   2   41 43 *                     84.0 2 49 26 0   3     2   2   41 43                 84
1365994 1365994 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2020   grade_7 29 49 59 0   34     1   3   93 82 *                     175.0 29 49 59 0   34     1   3   93 82                 175
1372889 1372889 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_7 17 49 18 2   7     0   3   55 41 *                     96.0 17 49 18 2   7     0   3   55 41                 96
1369335 1369335 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_7 117 48 139 0   0     1   20   170 155 *                     325.0 117 48 139 0   0     1   20   170 155                 325
1369329 1369329 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2020   grade_7 120 46 139 1   6     0   26   187 151 *                     338.0 120 46 139 1   6     0   26   187 151                 338
1369332 1369332 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2020   grade_7 174 44 162 3   2     0   27   212 200 *                     412.0 174 44 162 3   2     0   27   212 200                 412
1371003 1371003 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2020   grade_7 31 44 153 0   13     0   5   127 119 *                     246.0 31 44 153 0   13     0   5   127 119                 246
1371286 1371286 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No Middle 05 07 2020   grade_7 153 44 27 1   2     1   7   123 112 *                     235.0 153 44 27 1   2     1   7   123 112                 235
1372793 1372793 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_7 1 44 41 0   1     0   3   34 56 *                     90.0 1 44 41 0   1     0   3   34 56                 90
1365662 1365662 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_7 1 43 42 0   0     1   0   39 48 *                     87.0 1 43 42 0   0     1   0   39 48                 87
1365897 1365897 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_7 1 43 58 0   2     0   0   55 49 *                     104.0 1 43 58 0   2     0   0   55 49                 104
1372470 1372470 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_7 8 43 22 0   0     0   1   37 37 *                     74.0 8 43 22 0   0     0   1   37 37                 74
1374218 1374218 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2020   grade_7 2 40 34 0   0     0   1   39 38 *                     77.0 2 40 34 0   0     0   1   39 38                 77
1372654 1372654 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_7 7 39 21 1   1     0   1   42 28 *                     70.0 7 39 21 1   1     0   1   42 28                 70
1368584 1368584 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2020   grade_7 39 38 341 0   36     0   6   240 220 *                     460.0 39 38 341 0   36     0   6   240 220                 460
1372902 1372902 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2020   grade_7 27 38 3 0   4     0   6   44 34 *                     78.0 27 38 3 0   4     0   6   44 34                 78
1365894 1365894 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2020   grade_7 4 37 43 0   0     0   2   41 45 *                     86.0 4 37 43 0   0     0   2   41 45                 86
1371915 1371915 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 06 08 2020   grade_7 310 37 53 1   22     0   18   219 222 *                     441.0 310 37 53 1   22     0   18   219 222                 441
1365529 1365529 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2020   grade_7 8 36 61 1   3     0   2   48 63 *                     111.0 8 36 61 1   3     0   2   48 63                 111
1366474 1366474 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2020   grade_7 37 34 6 0   8     0   10   48 47 *                     95.0 37 34 6 0   8     0   10   48 47                 95
1372696 1372696 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_7 49 34 10 1   0     0   3   51 46 *                     97.0 49 34 10 1   0     0   3   51 46                 97
1372764 1372764 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2020   grade_7 0 34 22 0   0     0   0   34 22 *                     56.0 0 34 22 0   0     0   0   34 22                 56
1372880 1372880 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2020   grade_7 1 34 33 0   0     0   2   34 36 *                     70.0 1 34 33 0   0     0   2   34 36                 70
1366471 1366471 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2020   grade_7 29 33 14 0   14     1   7   39 59 *                     98.0 29 33 14 0   14     1   7   39 59                 98
1365563 1365563 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_7 1 32 21 0   4     0   6   31 33 *                     64.0 1 32 21 0   4     0   6   31 33                 64
1366504 1366504 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No Middle 06 08 2020   grade_7 171 32 8 0   28     0   12   113 138 *                     251.0 171 32 8 0   28     0   12   113 138                 251
1371006 1371006 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_7 15 32 110 0   2     0   4   87 76 *                     163.0 15 32 110 0   2     0   4   87 76                 163
1371297 1371297 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No Middle 05 07 2020   grade_7 191 32 31 1   2     0   13   136 134 *                     270.0 191 32 31 1   2     0   13   136 134                 270
1372640 1372640 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_7 23 32 60 0   7     0   9   66 65 *                     131.0 23 32 60 0   7     0   9   66 65                 131
1368873 1368873 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No Middle 06 08 2020   grade_7 71 31 25 1   16     0   8   75 77 *                     152.0 71 31 25 1   16     0   8   75 77                 152
1371294 1371294 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2020   grade_7 93 31 29 0   2     1   7   81 82 *                     163.0 93 31 29 0   2     1   7   81 82                 163
1372974 1372974 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science East   Regular School Yes High 06 12 2020   grade_7 16 31 39 0   2     0   4   43 49 *                     92.0 16 31 39 0   2     0   4   43 49                 92
1368679 1368679 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2020   grade_7 24 30 43 0   25     0   5   54 73 *                     127.0 24 30 43 0   25     0   5   54 73                 127
1370001 1370001 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2020   grade_7 136 30 28 0   2     0   15   103 108 *                     211.0 136 30 28 0   2     0   15   103 108                 211
1365980 1365980 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2020   grade_7 187 29 50 0   128     0   23   191 226 *                     417.0 187 29 50 0   128     0   23   191 226                 417
1365095 1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
1365482 1365482 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_7 20 28 32 0   2     0   1   42 41 *                     83.0 20 28 32 0   2     0   1   42 41                 83
1365830 1365830 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_7 3 28 17 0   0     0   5   26 27 *                     53.0 3 28 17 0   0     0   5   26 27                 53
1366117 1366117 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2020   grade_7 147 28 18 0   64     0   1   133 125 *                     258.0 147 28 18 0   64     0   1   133 125                 258
1367002 1367002 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_7 246 28 17 0   7     0   9   150 157 *                     307.0 246 28 17 0   7     0   9   150 157                 307
1369778 1369778 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2020   grade_7 169 28 34 0   17     1   6   121 134 *                     255.0 169 28 34 0   17     1   6   121 134                 255
1366477 1366477 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No Middle 06 08 2020   grade_7 44 27 3 0   18     0   8   51 48 *                     100.0 44 27 3 0   18     0   8   51 48                 100
1369998 1369998 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_7 118 27 17 1   0     0   13   80 96 *                     176.0 118 27 17 1   0     0   13   80 96                 176
1372461 1372461 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2020   grade_7 6 26 27 0   0     0   3   33 29 *                     62.0 6 26 27 0   0     0   3   33 29                 62
1365668 1365668 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_7 6 25 41 0   0     0   3   41 34 *                     75.0 6 25 41 0   0     0   3   41 34                 75
1368143 1368143 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2020   grade_7 128 25 111 0   9     0   12   141 144 *                     285.0 128 25 111 0   9     0   12   141 144                 285
1374220 1374220 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2020   grade_7 17 25 17 1   5     0   1   32 34 *                     66.0 17 25 17 1   5     0   1   32 34                 66
1365883 1365883 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_7 11 24 23 2   3     0   0   30 33 *                     63.0 11 24 23 2   3     0   0   30 33                 63
1368590 1368590 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2020   grade_7 65 24 107 1   22     0   14   122 111 *                     233.0 65 24 107 1   22     0   14   122 111                 233
1368651 1368651 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_7 29 24 43 0   17     0   9   61 61 *                     122.0 29 24 43 0   17     0   9   61 61                 122
1365836 1365836 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_7 2 22 20 0   0     0   1   31 14 *                     45.0 2 22 20 0   0     0   1   31 14                 45
1366903 1366903 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2020   grade_7 241 22 49 0   20     0   3   175 160 *                     335.0 241 22 49 0   20     0   3   175 160                 335
1370986 1370986 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2020   grade_7 18 22 58 0   0     0   0   40 58 *                     98.0 18 22 58 0   0     0   0   40 58                 98
1371029 1371029 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_7 12 22 65 0   5     0   2   50 56 *                     106.0 12 22 65 0   5     0   2   50 56                 106
1371504 1371504 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2020   grade_7 75 22 139 0   13     0   3   122 130 *                     252.0 75 22 139 0   13     0   3   122 130                 252
1372806 1372806 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_7 65 22 20 0   26     0   5   71 67 *                     138.0 65 22 20 0   26     0   5   71 67                 138
1373253 1373253 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_7 158 22 36 6   6     0   10   113 125 *                     238.0 158 22 36 6   6     0   10   113 125                 238
1365891 1365891 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2020   grade_7 15 21 91 0   2     0   0   66 63 *                     129.0 15 21 91 0   2     0   0   66 63                 129
1366841 1366841 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2020   grade_7 173 21 45 1   5     0   13   137 121 *                     258.0 173 21 45 1   5     0   13   137 121                 258
1367061 1367061 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_7 32 21 66 0   7     0   4   65 65 *                     130.0 32 21 66 0   7     0   4   65 65                 130
1367383 1367383 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2020   grade_7 67 21 101 0   2     0   5   115 81 *                     196.0 67 21 101 0   2     0   5   115 81                 196
1365339 1365339 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_7 3 20 64 0   1     0   3   42 49 *                     91.0 3 20 64 0   1     0   3   42 49                 91
1367760 1367760 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_7 45 20 13 0   7     0   9   40 53 *                     94.0 45 20 13 0   7     0   9   40 53                 94
1369896 1369896 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2020   grade_7 363 20 79 0   3     0   12   247 230 *                     477.0 363 20 79 0   3     0   12   247 230                 477
1371657 1371657 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2020   grade_7 258 20 12 0   65     0   27   168 213 *                     382.0 258 20 12 0   65     0   27   168 213                 382
1365444 1365444 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_7 1 19 21 0   1     0   2   24 20 *                     44.0 1 19 21 0   1     0   2   24 20                 44
1365635 1365635 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_7 3 19 32 0   24     0   3   47 34 *                     81.0 3 19 32 0   24     0   3   47 34                 81
1365856 1365856 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_7 0 19 23 0   0     0   0   22 20 *                     42.0 0 19 23 0   0     0   0   22 20                 42
1365948 1365948 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2020   grade_7 2 19 16 0   0     0   0   18 19 *                     37.0 2 19 16 0   0     0   0   18 19                 37
1366468 1366468 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2020   grade_7 45 19 15 1   10     0   9   57 42 *                     99.0 45 19 15 1   10     0   9   57 42                 99
1367086 1367086 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_7 15 19 78 0   4     0   3   53 66 *                     119.0 15 19 78 0   4     0   3   53 66                 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]);