enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1367089 1367089 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_10 103 99 298 3   24     0   7   274 260 *                     534.0 103 99 298 3   24     0   7   274 260                 534
1368413 1368413 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_12 215 99 177 0   232     1   17   367 374 *                     741.0 215 99 177 0   232     1   17   367 374                 741
1372534 1372534 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   kindergarten 6 99 68 1   5     0   7   81 105 *                     186.0 6 99 68 1   5     0   7   81 105                 186
1372538 1372538 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_4 10 99 66 0   2     0   4   85 96 *                     181.0 10 99 66 0   2     0   4   85 96                 181
1372540 1372540 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_6 6 99 64 0   5     0   2   80 96 *                     176.0 6 99 64 0   5     0   2   80 96                 176
1368681 1368681 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   grade_9 119 98 146 1   108     0   15   241 246 *                     487.0 119 98 146 1   108     0   15   241 246                 487
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
1365937 1365937 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2020   grade_11 6 97 125 1   7     1   1   147 91 *                     238.0 6 97 125 1   7     1   1   147 91                 238
1368411 1368411 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_10 221 97 182 0   229     0   25   366 388 *                     754.0 221 97 182 0   229     0   25   366 388                 754
1368683 1368683 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   grade_11 100 97 125 0   104     0   7   249 183 *                     433.0 100 97 125 0   104     0   7   249 183                 433
1374254 1374254 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_8 2 97 10 1   0     0   0   60 50 *                     110.0 2 97 10 1   0     0   0   60 50                 110
1366023 1366023 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_9 2 96 33 1   5     0   8   94 51 *                     145.0 2 96 33 1   5     0   8   94 51                 145
1366199 1366199 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_4 49 96 32 1   10     0   11   105 94 *                     199.0 49 96 32 1   10     0   11   105 94                 199
1366201 1366201 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   kindergarten 7 96 11 0   0     1   3   66 52 *                     118.0 7 96 11 0   0     1   3   66 52                 118
1366202 1366202 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   grade_1 7 96 18 0   0     0   1   69 53 *                     122.0 7 96 18 0   0     0   1   69 53                 122
1372537 1372537 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_3 9 96 73 0   4     0   0   82 100 *                     182.0 9 96 73 0   4     0   0   82 100                 182
1366156 1366156 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2020   grade_1 15 95 73 0   1     0   5   98 91 *                     189.0 15 95 73 0   1     0   5   98 91                 189
1372536 1372536 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_2 4 95 81 0   5     0   2   91 96 *                     187.0 4 95 81 0   5     0   2   91 96                 187
1372539 1372539 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_5 13 95 64 1   4     0   4   83 98 *                     181.0 13 95 64 1   4     0   4   83 98                 181
1372863 1372863 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_10 2 95 63 0   0     0   1   77 84 *                     161.0 2 95 63 0   0     0   1   77 84                 161
1374256 1374256 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_10 2 94 8 0   0     0   0   52 52 *                     104.0 2 94 8 0   0     0   0   52 52                 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
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
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
1364784 1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
1364787 1364787 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   kindergarten 131 9 22 1   4     0   2   82 86 *                     169.0 131 9 22 1   4     0   2   82 86                 169
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
1364880 1364880 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_2 30 9 11 0   11     0   3   30 34 *                     64.0 30 9 11 0   11     0   3   30 34                 64
1365010 1365010 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   kindergarten 63 9 11 0   6     0   6   46 49 *                     95.0 63 9 11 0   6     0   6   46 49                 95
1365018 1365018 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_3 53 9 12 0   5     0   11   39 51 *                     90.0 53 9 12 0   5     0   11   39 51                 90
1365019 1365019 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_4 41 9 11 0   8     0   14   40 43 *                     83.0 41 9 11 0   8     0   14   40 43                 83
1365020 1365020 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_5 101 9 15 0   9     0   7   82 59 *                     141.0 101 9 15 0   9     0   7   82 59                 141
1365028 1365028 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_5 85 9 19 0   1     0   15   65 64 *                     129.0 85 9 19 0   1     0   15   65 64                 129
1365058 1365058 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   pre_kindergarten 6 9 3 0   1     0   3   11 11 *                     22.0 6 9 3 0   1     0   3   11 11                 22
1365071 1365071 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 9 29 0   3     0   26   99 62 *                     161.0 94 9 29 0   3     0   26   99 62                 161
1365085 1365085 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   grade_1 19 9 35 1   1     1   6   35 37 *                     72.0 19 9 35 1   1     1   6   35 37                 72
1365163 1365163 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2020   grade_4 42 9 4 0   20     0   12   43 44 *                     87.0 42 9 4 0   20     0   12   43 44                 87
1365181 1365181 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2020   grade_11 220 9 12 0   64     0   23   168 160 *                     328.0 220 9 12 0   64     0   23   168 160                 328
1365221 1365221 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_7 280 9 55 0   12     0   7   189 174 *                     363.0 280 9 55 0   12     0   7   189 174                 363
1365222 1365222 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2020   grade_8 239 9 54 0   9     0   9   175 145 *                     320.0 239 9 54 0   9     0   9   175 145                 320
1365285 1365285 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2020   grade_1 4 9 14 1   4     0   1   17 16 *                     33.0 4 9 14 1   4     0   1   17 16                 33
1365331 1365331 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   kindergarten 46 9 22 0   3     0   8   50 38 *                     88.0 46 9 22 0   3     0   8   50 38                 88
1365434 1365434 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2020   grade_4 19 9 12 0   0     0   4   27 16 *                     44.0 19 9 12 0   0     0   4   27 16                 44
1365435 1365435 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2020   grade_5 10 9 10 0   0     0   5   12 22 *                     34.0 10 9 10 0   0     0   5   12 22                 34
1365450 1365450 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2020   grade_3 4 9 11 0   1     0   0   16 9 *                     25.0 4 9 11 0   1     0   0   16 9                 25
1365458 1365458 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2020   grade_4 3 9 18 0   0     0   0   13 17 *                     30.0 3 9 18 0   0     0   0   13 17                 30
1365542 1365542 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2020   grade_3 6 9 9 0   2     0   2   18 10 *                     28.0 6 9 9 0   2     0   2   18 10                 28
1365576 1365576 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_3 20 9 10 0   2     0   2   25 18 *                     43.0 20 9 10 0   2     0   2   25 18                 43
1365612 1365612 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_8 0 9 21 0   3     0   0   19 14 *                     33.0 0 9 21 0   3     0   0   19 14                 33
1365613 1365613 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2020   kindergarten 5 9 5 0   3     0   3   11 14 *                     25.0 5 9 5 0   3     0   3   11 14                 25
1365625 1365625 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2020   grade_4 10 9 4 1   2     0   1   17 10 *                     27.0 10 9 4 1   2     0   1   17 10                 27
1365639 1365639 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2020   grade_1 3 9 7 0   4     0   0   9 14 *                     23.0 3 9 7 0   4     0   0   9 14                 23
1365641 1365641 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2020   grade_3 2 9 11 0   1     0   1   7 17 *                     24.0 2 9 11 0   1     0   1   7 17                 24
1365643 1365643 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2020   grade_5 1 9 6 0   4     0   0   9 11 *                     20.0 1 9 6 0   4     0   0   9 11                 20
1365653 1365653 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_8 10 9 8 0   0     0   1   15 13 *                     28.0 10 9 8 0   0     0   1   15 13                 28
1365732 1365732 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   kindergarten 3 9 36 0   0     0   0   20 28 *                     48.0 3 9 36 0   0     0   0   20 28                 48
1365740 1365740 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_7 2 9 17 0   0     0   0   17 11 *                     28.0 2 9 17 0   0     0   0   17 11                 28
1365755 1365755 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2020   grade_2 13 9 7 0   5     0   6   22 18 *                     40.0 13 9 7 0   5     0   6   22 18                 40
1365761 1365761 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_1 47 9 8 0   3     0   4   42 29 *                     71.0 47 9 8 0   3     0   4   42 29                 71
1365764 1365764 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_4 31 9 13 0   4     0   3   21 39 *                     60.0 31 9 13 0   4     0   3   21 39                 60
1365775 1365775 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2020   grade_5 2 9 10 0   1     1   0   7 16 *                     23.0 2 9 10 0   1     1   0   7 16                 23
1366120 1366120 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2020   grade_7 181 9 8 0   53     0   1   122 130 *                     252.0 181 9 8 0   53     0   1   122 130                 252
1366320 1366320 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_7 48 9 8 0   8     0   5   29 49 *                     78.0 48 9 8 0   8     0   5   29 49                 78
1366341 1366341 MA Norfolk   school 2503150 46   Brookline 250315002027 460060 The Lynch Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 22 9 5 0   11     0   10   33 24 *                     57.0 22 9 5 0   11     0   10   33 24                 57
1366365 1366365 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2020   kindergarten 53 9 5 0   12     0   4   45 38 *                     83.0 53 9 5 0   12     0   4   45 38                 83
1366398 1366398 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2020   pre_kindergarten 25 9 6 0   8     0   6   29 23 *                     54.0 25 9 6 0   8     0   6   29 23                 54
1366402 1366402 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2020   grade_4 29 9 1 0   1     0   2   21 21 *                     42.0 29 9 1 0   1     0   2   21 21                 42
1366413 1366413 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2020   grade_1 17 9 2 1   14     0   10   26 27 *                     53.0 17 9 2 1   14     0   10   26 27                 53
1366420 1366420 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2020   grade_1 29 9 6 0   3     0   10   28 29 *                     57.0 29 9 6 0   3     0   10   28 29                 57
1366431 1366431 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2020   grade_5 8 9 6 0   5     0   3   13 18 *                     31.0 8 9 6 0   5     0   3   13 18                 31
1366438 1366438 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2020   grade_5 10 9 3 1   7     0   5   22 13 *                     35.0 10 9 3 1   7     0   5   22 13                 35
1366456 1366456 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2020   grade_2 31 9 3 0   11     0   3   31 26 *                     57.0 31 9 3 0   11     0   3   31 26                 57
1366457 1366457 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2020   grade_3 30 9 8 0   7     0   5   27 32 *                     59.0 30 9 8 0   7     0   5   27 32                 59
1366557 1366557 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_5 134 9 14 1   27     0   10   105 90 *                     195.0 134 9 14 1   27     0   10   105 90                 195
1366558 1366558 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2020   grade_6 129 9 12 2   27     0   7   123 63 *                     186.0 129 9 12 2   27     0   7   123 63                 186
1366599 1366599 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_6 11 9 136 0   0     0   2   91 67 *                     158.0 11 9 136 0   0     0   2   91 67                 158
1366678 1366678 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2020   grade_9 186 9 100 0   5     0   6   182 124 *                     306.0 186 9 100 0   5     0   6   182 124                 306
1366890 1366890 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2020   kindergarten 55 9 9 0   6     0   1   46 34 *                     80.0 55 9 9 0   6     0   1   46 34                 80
1366931 1366931 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2020   grade_7 151 9 1 1   0     1   6   100 69 *                     169.0 151 9 1 1   0     1   6   100 69                 169
1367032 1367032 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2020   grade_3 11 9 58 1   4     0   0   49 34 *                     83.0 11 9 58 1   4     0   0   49 34                 83
1367050 1367050 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_5 20 9 43 0   4     0   0   37 39 *                     76.0 20 9 43 0   4     0   0   37 39                 76
1367053 1367053 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_8 37 9 43 2   6     1   3   54 47 *                     101.0 37 9 43 2   6     1   3   54 47                 101
1367056 1367056 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_2 13 9 52 0   6     0   0   37 43 *                     80.0 13 9 52 0   6     0   0   37 43                 80
1367126 1367126 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2020   grade_5 50 9 45 0   8     0   10   66 56 *                     122.0 50 9 45 0   8     0   10   66 56                 122
1367127 1367127 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   kindergarten 33 9 42 0   3     0   6   56 37 *                     93.0 33 9 42 0   3     0   6   56 37                 93
1367129 1367129 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   grade_1 32 9 41 0   3     0   9   44 50 *                     94.0 32 9 41 0   3     0   9   44 50                 94
1367130 1367130 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   grade_2 28 9 49 1   2     1   16   58 48 *                     106.0 28 9 49 1   2     1   16   58 48                 106
1367143 1367143 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_1 32 9 33 0   1     0   9   40 44 *                     84.0 32 9 33 0   1     0   9   40 44                 84
1367157 1367157 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_5 26 9 9 0   1     0   12   29 28 *                     57.0 26 9 9 0   1     0   12   29 28                 57
1367172 1367172 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary PK 05 2020   grade_3 54 9 15 0   3     0   13   47 47 *                     94.0 54 9 15 0   3     0   13   47 47                 94
1367236 1367236 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_6 217 9 15 11   4     0   24   148 132 *                     280.0 217 9 15 11   4     0   24   148 132                 280
1367240 1367240 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_10 165 9 13 2   6     0   16   106 104 *                     211.0 165 9 13 2   6     0   16   106 104                 211
1367244 1367244 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2020   kindergarten 29 9 68 0   4     0   10   59 61 *                     120.0 29 9 68 0   4     0   10   59 61                 120
1367257 1367257 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_6 59 9 92 0   9     1   11   82 99 *                     181.0 59 9 92 0   9     1   11   82 99                 181
1367263 1367263 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   grade_2 32 9 58 0   5     0   3   55 52 *                     107.0 32 9 58 0   5     0   3   55 52                 107
1367264 1367264 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   grade_3 22 9 64 0   5     0   9   55 54 *                     109.0 22 9 64 0   5     0   9   55 54                 109

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