enrollments

Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,436 ✖
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
1674480 1674480 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   grade_1 26 9 70 0   4     0   7   57 59 *                     116.0 26 9 70 0   4     0   7   57 59                 116
1674493 1674493 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg - Memorial Middle School   Regular School No Middle 05 08 2021   grade_8 40 9 83 0   14     0   15   82 79 *                     161.0 40 9 83 0   14     0   15   82 79                 161
1674575 1674575 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Framingham - Charlotte A Dunning   Regular School No Elementary KG 05 2021   grade_4 46 9 10 0   9     0   1   46 29 *                     75.0 46 9 10 0   9     0   1   46 29                 75
1674602 1674602 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham - Miriam F McCarthy School   Regular School No Elementary KG 05 2021   grade_1 19 9 25 0   2     0   11   28 38 *                     66.0 19 9 25 0   2     0   11   28 38                 66
1674606 1674606 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Framingham - Miriam F McCarthy School   Regular School No Elementary KG 05 2021   grade_5 30 9 38 0   1     0   7   38 47 *                     85.0 30 9 38 0   1     0   7   38 47                 85
1674620 1674620 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_7 148 9 86 0   16     0   7   127 139 *                     266.0 148 9 86 0   16     0   7   127 139                 266
1674675 1674675 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   grade_12 381 9 15 2   33     0   9   232 217 *                     449.0 381 9 15 2   33     0   9   232 217                 449
1674913 1674913 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_7 112 9 46 1   3     0   1   88 84 *                     172.0 112 9 46 1   3     0   1   88 84                 172
1674929 1674929 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Haverhill - Pentucket Lake Elementary   Regular School No Elementary KG 04 2021   grade_4 57 9 67 2   1     0   4   64 76 *                     140.0 57 9 67 2   1     0   4   64 76                 140
1674989 1674989 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_6 265 9 13 0   3     0   8   144 153 *                     298.0 265 9 13 0   3     0   8   144 153                 298
1675363 1675363 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster - Fall Brook   Regular School No Elementary KG 05 2021   grade_3 57 9 36 0   2     0   6   64 46 *                     110.0 57 9 36 0   2     0   6   64 46                 110
1675380 1675380 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Leominster - Northwest   Regular School No Elementary KG 05 2021   grade_2 57 9 57 0   4     0   6   61 72 *                     133.0 57 9 57 0   4     0   6   61 72                 133
1675402 1675402 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Leominster - Center For Technical Education Innovation   Career and Technical School No High 09 12 2021   grade_12 91 9 56 0   2     1   4   103 60 *                     163.0 91 9 56 0   2     1   4   103 60                 163
1675449 1675449 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_8 137 9 15 0   126     0   14   143 157 *                     301.0 137 9 15 0   126     0   14   143 157                 301
1675580 1675580 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Lowell - Pawtucketville Memorial   Regular School No Elementary PK 04 2021   grade_4 31 9 23 0   21     0   7   49 42 *                     91.0 31 9 23 0   21     0   7   49 42                 91
1675616 1675616 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell - Bartlett Community Partnership   Regular School No Elementary PK 08 2021   kindergarten 11 9 5 0   17     0   4   25 21 *                     46.0 11 9 5 0   17     0   4   25 21                 46
1675633 1675633 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_8 42 9 34 0   77     0   7   99 70 *                     169.0 42 9 34 0   77     0   7   99 70                 169
1675645 1675645 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell - James Sullivan Middle School   Regular School No Middle 05 08 2021   grade_8 52 9 69 0   25     0   11   75 91 *                     166.0 52 9 69 0   25     0   11   75 91                 166
1675652 1675652 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell - Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2021   grade_7 26 9 49 0   80     0   4   91 77 *                     168.0 26 9 49 0   80     0   4   91 77                 168
1675753 1675753 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Lynn - Wm P Connery   Regular School No Elementary PK 05 2021   grade_1 3 9 65 0   4     0   0   38 43 *                     81.0 3 9 65 0   4     0   0   38 43                 81
1675761 1675761 MA Essex   school 2507110 163   Lynn 250711001070 1630045 Lynn - E J Harrington   Regular School No Elementary PK 05 2021   grade_2 15 9 69 0   9     0   5   51 56 *                     107.0 15 9 69 0   9     0   5   51 56                 107
1675768 1675768 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn - Robert L Ford   Regular School No Elementary 01 05 2021   grade_4 8 9 70 0   3     0   2   41 51 *                     92.0 8 9 70 0   3     0   2   41 51                 92
1675896 1675896 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden - Forestdale   Regular School No Elementary KG 08 2021   grade_2 22 9 9 0   9     0   7   29 27 *                     56.0 22 9 9 0   9     0   7   29 27                 56
1675898 1675898 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden - Forestdale   Regular School No Elementary KG 08 2021   grade_4 27 9 15 0   3     1   6   32 29 *                     61.0 27 9 15 0   3     1   6   32 29                 61
1675930 1675930 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield - Everett W Robinson   Regular School No Elementary KG 02 2021   grade_2 172 9 16 0   12     0   14   115 108 *                     223.0 172 9 16 0   12     0   14   115 108                 223
1675999 1675999 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough - Marlborough High   Regular School No High 09 12 2021   grade_11 94 9 135 0   4     0   6   131 117 *                     248.0 94 9 135 0   4     0   6   131 117                 248
1676052 1676052 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee - Mashpee High   Regular School No High 09 12 2021   grade_10 92 9 2 10   3     0   6   59 63 *                     122.0 92 9 2 10   3     0   6   59 63                 122
1676109 1676109 MA Middlesex   school 2507560 176   Medford 250756002057 1760140 Medford - Christopher Columbus   Regular School No Elementary PK 05 2021   grade_2 39 9 16 1   4     0   4   35 38 *                     73.0 39 9 16 1   4     0   4   35 38                 73
1676122 1676122 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford - Madeleine Dugger Andrews   Regular School No Middle 06 08 2021   grade_8 97 9 10 1   11     0   11   80 59 *                     139.0 97 9 10 1   11     0   11   80 59                 139
1676148 1676148 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Melrose - Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten 87 9 6 2   6     0   8   66 52 *                     118.0 87 9 6 2   6     0   8   66 52                 118
1676207 1676207 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   kindergarten 29 9 60 0   6     0   3   49 58 *                     107.0 29 9 60 0   6     0   3   49 58                 107
1676227 1676227 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_9 192 9 194 0   15     0   22   219 212 *                     432.0 192 9 194 0   15     0   22   219 212                 432
1676266 1676266 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford - Woodland   Regular School No Elementary 03 05 2021   grade_3 183 9 110 1   0     0   11   164 150 *                     314.0 183 9 110 1   0     0   11   164 150                 314
1676269 1676269 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_6 204 9 86 7   4     1   19   175 155 *                     330.0 204 9 86 7   4     1   19   175 155                 330
1676317 1676317 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Milton - Cunningham School   Regular School No Elementary PK 05 2021   grade_5 70 9 3 0   8     0   3   42 51 *                     93.0 70 9 3 0   8     0   3   42 51                 93
1676320 1676320 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Milton - Glover   Regular School No Elementary KG 05 2021   grade_2 95 9 2 1   5     0   6   52 66 *                     118.0 95 9 2 1   5     0   6   52 66                 118
1676371 1676371 MA Nantucket   school 2508250 197   Nantucket 250825002880 1970020 Nantucket - Nantucket Intermediate School   Regular School No Elementary 03 05 2021   grade_5 68 9 34 0   2     0   4   70 47 *                     117.0 68 9 34 0   2     0   4   70 47                 117
1676406 1676406 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick - Wilson Middle   Regular School No Middle 05 08 2021   grade_6 149 9 12 1   18     1   11   102 99 *                     201.0 149 9 12 1   18     1   11   102 99                 201
1676423 1676423 MA Norfolk   school 2508370 199   Needham 250837001314 1990020 Needham - John Eliot   Regular School No Elementary KG 05 2021   grade_3 44 9 6 0   13     0   2   42 32 *                     74.0 44 9 6 0   13     0   2   42 32                 74
1676476 1676476 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 New Bedford - James B Congdon   Regular School No Elementary KG 05 2021   grade_5 21 9 16 0   0     0   3   23 26 *                     49.0 21 9 16 0   0     0   3   23 26                 49
1676522 1676522 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 New Bedford - Abraham Lincoln   Regular School No Elementary KG 05 2021   grade_5 63 9 29 0   1     0   4   52 54 *                     106.0 63 9 29 0   1     0   4   52 54                 106
1676706 1676706 MA Middlesex   school 2508610 207   Newton 250861001383 2070130 Newton - Zervas   Regular School No Elementary KG 05 2021   grade_2 29 9 8 1   19     1   6   38 35 *                     73.0 29 9 8 1   19     1   6   38 35                 73
1676715 1676715 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton - Charles E Brown Middle   Regular School No Middle 06 08 2021   grade_8 173 9 17 1   52     0   18   135 135 *                     270.0 173 9 17 1   52     0   18   135 135                 270
1676718 1676718 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 Newton - F A Day Middle   Regular School No Middle 06 08 2021   grade_8 204 9 30 1   50     0   19   154 158 *                     313.0 204 9 30 1   50     0   19   154 158                 313
1676796 1676796 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton - John F Kennedy Middle School   Regular School No Middle 06 08 2021   grade_7 142 9 33 0   4     0   18   102 103 *                     206.0 142 9 33 0   4     0   18   102 103                 206
1676830 1676830 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover - North Andover Middle   Regular School No Middle 06 08 2021   grade_7 255 9 56 1   33     0   18   166 206 *                     372.0 255 9 56 1   33     0   18   166 206                 372
1676866 1676866 MA Bristol   school 2508730 212   North Attleborough 250873001199 2120030 North Attleborough - Community   Regular School No Elementary KG 05 2021   grade_5 34 9 2 0   3     0   4   27 25 *                     52.0 34 9 2 0   3     0   4   27 25                 52
1677200 1677200 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Pittsfield - Egremont   Regular School No Elementary KG 05 2021   grade_3 46 9 13 0   1     0   5   38 36 *                     74.0 46 9 13 0   1     0   5   38 36                 74
1677215 1677215 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Pittsfield - Morningside Community School   Regular School No Elementary PK 05 2021   grade_5 27 9 13 0   0     0   9   32 26 *                     58.0 27 9 13 0   0     0   9   32 26                 58
1677220 1677220 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Pittsfield - Crosby   Regular School No Elementary PK 05 2021   grade_3 21 9 19 0   0     0   10   37 22 *                     59.0 21 9 19 0   0     0   10   37 22                 59
1677235 1677235 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Pittsfield - Silvio O Conte Community   Regular School No Elementary PK 05 2021   kindergarten 25 9 12 1   0     0   9   27 29 *                     56.0 25 9 12 1   0     0   9   27 29                 56
1677320 1677320 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth - Plymouth Commun Intermediate   Regular School No Middle 06 08 2021   grade_6 267 9 24 0   6     0   18   167 157 *                     324.0 267 9 24 0   6     0   18   167 157                 324
1677361 1677361 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   kindergarten 38 9 15 0   56     0   9   56 71 *                     127.0 38 9 15 0   56     0   9   56 71                 127
1677424 1677424 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy - South West Middle School   Regular School No Middle 05 08 2021   grade_6 36 9 15 1   38     1   5   74 31 *                     105.0 36 9 15 1   38     1   5   74 31                 105
1677428 1677428 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_5 27 9 15 0   28     0   3   46 36 *                     82.0 27 9 15 0   28     0   3   46 36                 82
1677430 1677430 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy - Point Webster Middle   Regular School No Middle 05 08 2021   grade_7 26 9 7 1   39     1   6   50 39 *                     89.0 26 9 7 1   39     1   6   50 39                 89
1677473 1677473 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   sped_beyond_grade_12 0 9 0 0   1     0   0   8 2 *                     10.0 0 9 0 0   1     0   0   8 2                 10
1677514 1677514 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading - Reading Memorial High   Regular School No High 09 12 2021   grade_12 293 9 8 1   14     0   5   168 161 *                     330.0 293 9 8 1   14     0   5   168 161                 330
1677559 1677559 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere - Garfield Middle School   Regular School No Middle 06 08 2021   grade_8 68 9 118 0   8     0   3   99 107 *                     206.0 68 9 118 0   8     0   3   99 107                 206
1677733 1677733 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus - Saugus High   Regular School No High 09 12 2021   grade_9 111 9 41 1   10     0   0   91 81 *                     172.0 111 9 41 1   10     0   0   91 81                 172
1677735 1677735 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus - Saugus High   Regular School No High 09 12 2021   grade_11 134 9 25 1   6     0   1   83 93 *                     176.0 134 9 25 1   6     0   1   83 93                 176
1677736 1677736 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus - Saugus High   Regular School No High 09 12 2021   grade_12 119 9 29 2   6     0   2   93 73 *                     167.0 119 9 29 2   6     0   2   93 73                 167
1677811 1677811 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Sharon - Heights Elementary   Regular School No Elementary KG 05 2021   grade_1 55 9 7 0   19     0   7   46 51 *                     97.0 55 9 7 0   19     0   7   46 51                 97
1677956 1677956 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville - Winter Hill Community   Regular School No Elementary PK 08 2021   grade_8 5 9 34 0   1     0   0   22 27 *                     49.0 5 9 34 0   1     0   0   22 27                 49
1678035 1678035 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Springfield - Edward P. Boland School   Regular School No Elementary PK 05 2021   pre_kindergarten 12 9 122 0   0     0   4   85 62 *                     147.0 12 9 122 0   0     0   4   85 62                 147
1678052 1678052 MA Hampden   school 2511130 281   Springfield 251113001826 2810020 Springfield - Samuel Bowles   Regular School No Elementary KG 05 2021   grade_4 2 9 18 0   0     0   0   7 22 *                     29.0 2 9 18 0   0     0   0   7 22                 29
1678067 1678067 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Springfield - Brightwood   Regular School No Elementary PK 05 2021   grade_5 3 9 43 0   0     0   1   29 27 *                     56.0 3 9 43 0   0     0   1   29 27                 56
1678109 1678109 MA Hampden   school 2511130 281   Springfield 251113001562 2810068 Springfield - Glickman Elementary   Regular School No Elementary KG 05 2021   grade_1 4 9 27 0   2     0   2   22 22 *                     44.0 4 9 27 0   2     0   2   22 22                 44
1678111 1678111 MA Hampden   school 2511130 281   Springfield 251113001562 2810068 Springfield - Glickman Elementary   Regular School No Elementary KG 05 2021   grade_3 7 9 28 0   0     0   2   30 16 *                     46.0 7 9 28 0   0     0   2   30 16                 46
1678116 1678116 MA Hampden   school 2511130 281   Springfield 251113001803 2810075 Springfield - Frank H Freedman   Regular School No Elementary KG 05 2021   grade_2 4 9 26 1   3     0   3   21 25 *                     46.0 4 9 26 1   3     0   3   21 25                 46
1678137 1678137 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield - Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2021   grade_3 11 9 22 0   0     0   1   18 25 *                     43.0 11 9 22 0   0     0   1   18 25                 43
1678184 1678184 MA Hampden   school 2511130 281   Springfield 251113001819 2810145 Springfield - Mary O Pottenger   Regular School No Elementary PK 05 2021   grade_1 7 9 53 1   2     0   1   39 34 *                     73.0 7 9 53 1   2     0   1   39 34                 73
1678192 1678192 MA Hampden   school 2511130 281   Springfield 251113001829 2810155 Springfield - Mary M Walsh   Regular School No Elementary KG 05 2021   grade_2 4 9 33 0   0     0   1   26 21 *                     47.0 4 9 33 0   0     0   1   26 21                 47
1678201 1678201 MA Hampden   school 2511130 281   Springfield 251113001830 2810160 Springfield - Sumner Avenue   Regular School No Elementary PK 05 2021   grade_4 9 9 46 0   3     0   3   37 33 *                     70.0 9 9 46 0   3     0   3   37 33                 70
1678207 1678207 MA Hampden   school 2511130 281   Springfield 251113001795 2810165 Springfield - Arthur T Talmadge   Regular School No Elementary KG 05 2021   grade_4 4 9 29 0   0     0   1   21 22 *                     43.0 4 9 29 0   0     0   1   21 22                 43
1678210 1678210 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Springfield - Alice B Beal Elementary   Regular School No Elementary KG 05 2021   grade_1 5 9 27 0   8     0   2   27 24 *                     51.0 5 9 27 0   8     0   2   27 24                 51
1678226 1678226 MA Hampden   school 2511130 281   Springfield 251113001836 2810185 Springfield - Washington   Regular School No Elementary PK 05 2021   grade_3 8 9 42 0   4     0   3   32 34 *                     66.0 8 9 42 0   4     0   3   32 34                 66
1678286 1678286 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield - Chestnut Academy   Regular School No Middle 06 08 2021   grade_8 2 9 83 0   1     0   0   49 46 *                     95.0 2 9 83 0   1     0   0   49 46                 95
1678289 1678289 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Springfield - Impact Prep at Chestnut   Regular School No Middle 06 08 2021   grade_8 3 9 59 0   0     0   1   39 33 *                     72.0 3 9 59 0   0     0   1   39 33                 72
1678293 1678293 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield - Conservatory of the Arts   Regular School No High 06 12 2021   grade_6 7 9 38 0   1     1   0   19 37 *                     56.0 7 9 38 0   1     1   0   19 37                 56
1678328 1678328 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield - Springfield High School   Regular School No High 09 12 2021   grade_11 5 9 37 0   0     0   0   30 21 *                     51.0 5 9 37 0   0     0   0   30 21                 51
1678381 1678381 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 Stoughton - South Elementary   Regular School No Elementary KG 05 2021   kindergarten 21 9 6 0   5     1   4   21 25 *                     46.0 21 9 6 0   5     1   4   21 25                 46
1678384 1678384 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 Stoughton - South Elementary   Regular School No Elementary KG 05 2021   grade_3 17 9 2 0   3     0   4   19 16 *                     35.0 17 9 2 0   3     0   4   19 16                 35
1678482 1678482 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott - Swampscott Middle   Regular School No Middle 05 08 2021   grade_6 107 9 24 0   7     0   6   75 78 *                     153.0 107 9 24 0   7     0   6   75 78                 153
1678485 1678485 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott - Swampscott High   Regular School No High 09 12 2021   grade_9 124 9 19 0   4     0   5   78 82 *                     161.0 124 9 19 0   4     0   5   78 82                 161
1678487 1678487 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott - Swampscott High   Regular School No High 09 12 2021   grade_11 146 9 27 0   7     0   2   87 104 *                     191.0 146 9 27 0   7     0   2   87 104                 191
1678516 1678516 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Taunton - Joseph C Chamberlain   Regular School No Elementary KG 04 2021   kindergarten 49 9 7 0   3     0   8   40 36 *                     76.0 49 9 7 0   3     0   8   40 36                 76
1678567 1678567 MA Middlesex   school 2511580 295   Tewksbury 251158001923 2950020 Tewksbury - North Street   Regular School No Elementary 03 04 2021   grade_4 117 9 16 0   3     1   1   72 75 *                     147.0 117 9 16 0   3     1   1   72 75                 147
1678577 1678577 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury - Tewksbury Memorial High   Regular School No High 09 12 2021   grade_12 177 9 13 0   8     0   2   91 117 *                     209.0 177 9 13 0   8     0   2   91 117                 209
1678608 1678608 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough - Tyngsborough Elementary   Regular School No Elementary PK 05 2021   grade_3 80 9 14 0   6     0   4   61 52 *                     113.0 80 9 14 0   6     0   4   61 52                 113
1678700 1678700 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Walpole - Bird Middle   Regular School No Middle 06 08 2021   grade_8 100 9 11 0   5     0   3   63 65 *                     128.0 100 9 11 0   5     0   3   63 65                 128
1678707 1678707 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole - Walpole High   Regular School No High 09 12 2021   grade_12 224 9 16 2   15     0   4   139 131 *                     270.0 224 9 16 2   15     0   4   139 131                 270
1678722 1678722 MA Middlesex   school 2512000 308   Waltham 251200001967 3080032 Waltham - Douglas MacArthur Elementary School   Regular School No Elementary KG 05 2021   grade_1 33 9 9 0   7     0   3   30 31 *                     61.0 33 9 9 0   7     0   3   30 31                 61
1678723 1678723 MA Middlesex   school 2512000 308   Waltham 251200001967 3080032 Waltham - Douglas MacArthur Elementary School   Regular School No Elementary KG 05 2021   grade_2 57 9 6 0   9     0   1   41 41 *                     82.0 57 9 6 0   9     0   1   41 41                 82
1678729 1678729 MA Middlesex   school 2512000 308   Waltham 251200001974 3080040 Waltham - Northeast Elementary School   Regular School No Elementary PK 05 2021   grade_1 33 9 31 0   12     0   1   46 40 *                     86.0 33 9 31 0   12     0   1   46 40                 86
1678828 1678828 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Wayland - Claypit Hill School   Regular School No Elementary KG 05 2021   grade_5 54 9 8 0   12     1   4   50 38 *                     88.0 54 9 8 0   12     1   4   50 38                 88
1678845 1678845 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland - Wayland High School   Regular School No High 09 12 2021   grade_10 126 9 9 0   37     0   15   91 105 *                     196.0 126 9 9 0   37     0   15   91 105                 196
1678852 1678852 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Webster - Park Avenue Elementary   Regular School No Elementary PK 04 2021   grade_3 63 9 53 0   2     0   13   78 62 *                     140.0 63 9 53 0   2     0   13   78 62                 140
1678854 1678854 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster - Webster Middle School   Regular School No Middle 05 08 2021   grade_5 77 9 51 0   2     0   9   88 60 *                     148.0 77 9 51 0   2     0   9   88 60                 148
1678859 1678859 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Webster - Bartlett High School   Regular School No High 09 12 2021   grade_10 53 9 30 1   2     0   3   36 62 *                     98.0 53 9 30 1   2     0   3   36 62                 98

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