enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2040968 2040968 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_12 1 99 18 0   1     0   1   64 56                       120.0 1 99 18 0   1     0   1   64 56                 120
2041297 2041297 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No Middle 07 08 2019   grade_7 14 99 29 1   4     0   8   96 59                       155.0 14 99 29 1   4     0   8   96 59                 155
2047616 2047616 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_7 5 99 73 0   2     0   0   91 88                       179.0 5 99 73 0   2     0   0   91 88                 179
2049328 2049328 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_9 1 99 9 0   0     0   0   57 52                       109.0 1 99 9 0   0     0   0   57 52                 109
2040979 2040979 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2019   grade_10 3 98 164 0   4     0   3   175 97                       272.0 3 98 164 0   4     0   3   175 97                 272
2043495 2043495 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_11 232 98 195 0   237     1   19   386 396                       782.0 232 98 195 0   237     1   19   386 396                 782
2042162 2042162 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_11 128 97 265 2   23     2   5   270 252                       522.0 128 97 265 2   23     2   5   270 252                 522
2045297 2045297 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2019   grade_11 14 95 14 1   29     1   4   87 71                       158.0 14 95 14 1   29     1   4   87 71                 158
2049327 2049327 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_8 1 95 10 0   0     0   2   49 59                       108.0 1 95 10 0   0     0   2   49 59                 108
2041072 2041072 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_10 4 94 35 1   5     0   4   64 79                       143.0 4 94 35 1   5     0   4   64 79                 143
2042160 2042160 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_9 102 94 273 4   23     0   7   258 245                       503.0 102 94 273 4   23     0   7   258 245                 503
2045292 2045292 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2019   grade_6 25 94 50 1   45     0   14   126 103                       229.0 25 94 50 1   45     0   14   126 103                 229
2041307 2041307 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No Middle 06 08 2019   grade_8 48 93 20 1   5     0   6   97 76                       173.0 48 93 20 1   5     0   6   97 76                 173
2041310 2041310 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2019   grade_8 51 93 72 1   7     0   9   113 120                       233.0 51 93 72 1   7     0   9   113 120                 233
2047613 2047613 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_4 14 93 67 1   4     0   4   85 98                       183.0 14 93 67 1   4     0   4   85 98                 183
2047610 2047610 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_1 4 92 76 0   5     0   2   86 93                       179.0 4 92 76 0   5     0   2   86 93                 179
2040405 2040405 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No Elementary PK 05 2019   grade_4 1 91 11 1   2     0   3   60 49                       109.0 1 91 11 1   2     0   3   60 49                 109
2041243 2041243 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_2 16 91 20 0   1     0   7   68 67                       135.0 16 91 20 0   1     0   7   68 67                 135
2046377 2046377 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_11 311 90 63 0   8     2   15   224 264                       489.0 311 90 63 0   8     2   15   224 264                 489
2039810 2039810 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 71 9 9 0   1     0   0   45 45                       90.0 71 9 9 0   1     0   0   45 45                 90
2039953 2039953 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_10 324 9 21 0   96     0   10   209 250                       460.0 324 9 21 0   96     0   10   209 250                 460
2039954 2039954 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_11 319 9 26 0   67     0   9   218 212                       430.0 319 9 26 0   67     0   9   218 212                 430
2040007 2040007 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 William Pittaway Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 74 9 0 1   30     0   2   68 48                       116.0 74 9 0 1   30     0   2   68 48                 116
2040009 2040009 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_1 123 9 25 1   36     0   10   100 104                       204.0 123 9 25 1   36     0   10   100 104                 204
2040026 2040026 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Early Learning Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 133 9 19 0   7     0   11   107 72                       179.0 133 9 19 0   7     0   11   107 72                 179
2040030 2040030 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2019   grade_3 61 9 12 0   2     0   4   48 40                       88.0 61 9 12 0   2     0   4   48 40                 88
2040048 2040048 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_6 120 9 24 0   6     0   10   98 71                       169.0 120 9 24 0   6     0   10   98 71                 169
2040049 2040049 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_7 124 9 25 0   9     0   11   91 87                       178.0 124 9 25 0   9     0   11   91 87                 178
2040087 2040087 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2019   kindergarten 23 9 5 0   0     0   5   20 22                       42.0 23 9 5 0   0     0   5   20 22                 42
2040111 2040111 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_1 32 9 21 0   2     0   13   35 42                       77.0 32 9 21 0   2     0   13   35 42                 77
2040134 2040134 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_6 142 9 8 1   36     0   1   112 85                       197.0 142 9 8 1   36     0   1   112 85                 197
2040226 2040226 MA Essex   school 2502640 30   Beverly 250264002854 300002 McKeown School   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 96 9 10 1   5     0   2   78 45                       123.0 96 9 10 1   5     0   2   78 45                 123
2040254 2040254 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly Middle School   Regular School No Middle 05 08 2019   grade_7 243 9 50 0   9     0   9   172 148                       320.0 243 9 50 0   9     0   9   172 148                 320
2040290 2040290 MA Middlesex   school 2502670 31   Billerica 250267000180 310026 Hajjar Elementary   Regular School No Elementary KG 05 2019   grade_5 74 9 11 0   5     0   0   57 42                       99.0 74 9 11 0   5     0   0   57 42                 99
2040299 2040299 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2019   grade_8 181 9 10 0   12     1   4   107 110                       217.0 181 9 10 0   12     1   4   107 110                 217
2040349 2040349 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_8 2 9 16 0   1     0   0   12 16                       28.0 2 9 16 0   1     0   0   12 16                 28
2040436 2040436 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   kindergarten 14 9 13 0   0     0   2   26 12                       38.0 14 9 13 0   0     0   2   26 12                 38
2040469 2040469 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_6 41 9 22 0   8     0   1   40 41                       81.0 41 9 22 0   8     0   1   40 41                 81
2040492 2040492 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2019   grade_2 6 9 10 0   0     0   0   16 9                       25.0 6 9 10 0   0     0   0   16 9                 25
2040565 2040565 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2019   kindergarten 2 9 6 0   1     0   1   9 10                       19.0 2 9 6 0   1     0   1   9 10                 19
2040618 2040618 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_2 20 9 7 0   2     0   2   26 14                       40.0 20 9 7 0   2     0   2   26 14                 40
2040622 2040622 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_6 25 9 12 0   8     0   6   23 37                       60.0 25 9 12 0   8     0   6   23 37                 60
2040626 2040626 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2019   kindergarten 10 9 13 1   11     0   2   21 25                       46.0 10 9 13 1   11     0   2   21 25                 46
2040654 2040654 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_7 1 9 23 0   3     0   0   18 18                       36.0 1 9 23 0   3     0   0   18 18                 36
2040669 2040669 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2019   grade_5 4 9 10 0   0     0   0   11 12                       23.0 4 9 10 0   0     0   0   11 12                 23
2040683 2040683 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2019   grade_2 2 9 8 0   1     0   1   6 15                       21.0 2 9 8 0   1     0   1   6 15                 21
2040691 2040691 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_3 18 9 3 0   1     0   0   15 16                       31.0 18 9 3 0   1     0   0   15 16                 31
2040783 2040783 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_7 0 9 14 0   0     0   0   16 7                       23.0 0 9 14 0   0     0   0   16 7                 23
2040792 2040792 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_6 10 9 25 0   1     0   3   24 24                       48.0 10 9 25 0   1     0   3   24 24                 48
2040798 2040798 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2019   grade_2 8 9 9 0   7     0   3   19 17                       36.0 8 9 9 0   7     0   3   19 17                 36
2040809 2040809 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_6 29 9 14 0   4     0   5   27 34                       61.0 29 9 14 0   4     0   5   27 34                 61
2040849 2040849 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2019   kindergarten 8 9 10 0   12     0   4   23 20                       43.0 8 9 10 0   12     0   4   23 20                 43
2040907 2040907 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_4 6 9 6 0   0     0   1   12 10                       22.0 6 9 6 0   0     0   1   12 10                 22
2041002 2041002 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2019   grade_12 2 9 22 0   0     0   2   20 15                       35.0 2 9 22 0   0     0   2   20 15                 35
2041023 2041023 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2019   sped_beyond_grade_12 0 9 2 0   4     0   0                             15.0 0 9 2 0   4     0   0                       15
2041174 2041174 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2019   grade_4 45 9 6 0   10     0   1   35 36                       71.0 45 9 6 0   10     0   1   35 36                 71
2041183 2041183 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 East Middle School   Regular School No Middle 06 08 2019   grade_7 155 9 16 0   39     0   1   113 107                       220.0 155 9 16 0   39     0   1   113 107                 220
2041348 2041348 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_3 71 9 9 0   14     0   6   59 50                       109.0 71 9 9 0   14     0   6   59 50                 109
2041353 2041353 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_8 42 9 10 0   9     0   12   45 37                       82.0 42 9 10 0   9     0   12   45 37                 82
2041467 2041467 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2019   pre_kindergarten 24 9 5 0   6     0   7   26 25                       51.0 24 9 5 0   6     0   7   26 25                 51
2041470 2041470 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2019   grade_2 20 9 4 0   5     0   5   24 19                       43.0 20 9 4 0   5     0   5   24 19                 43
2041471 2041471 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2019   grade_3 28 9 1 0   3     0   4   20 25                       45.0 28 9 1 0   3     0   4   20 25                 45
2041483 2041483 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2019   grade_1 13 9 1 0   17     0   14   27 27                       54.0 13 9 1 0   17     0   14   27 27                 54
2041502 2041502 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2019   pre_kindergarten 15 9 6 0   12     0   3   24 21                       45.0 15 9 6 0   12     0   3   24 21                 45
2041512 2041512 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2019   grade_2 26 9 0 0   7     0   2   25 19                       44.0 26 9 0 0   7     0   2   25 19                 44
2041555 2041555 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No Elementary KG 05 2019   kindergarten 40 9 6 0   9     0   6   38 32                       70.0 40 9 6 0   9     0   6   38 32                 70
2041642 2041642 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_1 3 9 90 0   3     0   1   53 53                       106.0 3 9 90 0   3     0   1   53 53                 106
2041646 2041646 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2019   grade_1 17 9 76 0   1     0   2   58 47                       105.0 17 9 76 0   1     0   2   58 47                 105
2041659 2041659 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_5 5 9 97 0   3     0   3   68 49                       117.0 5 9 97 0   3     0   3   68 49                 117
2041688 2041688 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2019   grade_1 47 9 38 0   1     0   2   52 45                       97.0 47 9 38 0   1     0   2   52 45                 97
2041738 2041738 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2019   grade_6 143 9 120 0   5     0   11   148 140                       288.0 143 9 120 0   5     0   11   148 140                 288
2041741 2041741 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_6 122 9 111 1   8     0   9   141 119                       260.0 122 9 111 1   8     0   9   141 119                 260
2041773 2041773 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2019   grade_10 81 9 32 0   4     0   2   67 61                       128.0 81 9 32 0   4     0   2   67 61                 128
2041859 2041859 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2019   grade_12 208 9 15 0   8     0   2   122 120                       242.0 208 9 15 0   8     0   2   122 120                 242
2041891 2041891 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Avery   Regular School No Elementary 01 05 2019   grade_2 28 9 26 1   0     0   6   32 38                       70.0 28 9 26 1   0     0   6   32 38                 70
2041913 2041913 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2019   grade_9 124 9 31 0   2     0   4   95 75                       170.0 124 9 31 0   2     0   4   95 75                 170
2041946 2041946 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 41 9 3 0   4     0   0   39 18                       57.0 41 9 3 0   4     0   0   39 18                 57
2042051 2042051 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2019   grade_7 179 9 15 0   9     0   6   110 108                       218.0 179 9 15 0   9     0   6   110 108                 218
2042074 2042074 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2019   grade_7 245 9 14 0   10     0   7   151 134                       285.0 245 9 14 0   10     0   7   151 134                 285
2042104 2042104 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_3 11 9 51 2   7     0   1   35 46                       81.0 11 9 51 2   7     0   1   35 46                 81
2042189 2042189 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2019   grade_1 57 9 22 0   4     0   13   54 51                       105.0 57 9 22 0   4     0   13   54 51                 105
2042202 2042202 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2019   grade_1 32 9 50 1   2     1   15   59 51                       110.0 32 9 50 1   2     1   15   59 51                 110
2042215 2042215 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   kindergarten 33 9 35 0   0     0   11   46 42                       88.0 33 9 35 0   0     0   11   46 42                 88
2042217 2042217 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_2 43 9 26 0   0     0   8   43 43                       86.0 43 9 26 0   0     0   8   43 43                 86
2042229 2042229 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_4 32 9 10 0   1     0   7   28 31                       59.0 32 9 10 0   1     0   7   28 31                 59
2042236 2042236 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2019   grade_1 57 9 29 0   6     0   7   45 63                       108.0 57 9 29 0   6     0   7   45 63                 108
2042322 2042322 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2019   grade_1 36 9 61 0   2     0   10   62 56                       118.0 36 9 61 0   2     0   10   62 56                 118
2042328 2042328 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_7 52 9 92 0   13     0   7   79 94                       173.0 52 9 92 0   13     0   7   79 94                 173
2042331 2042331 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2019   kindergarten 26 9 79 0   3     0   11   66 62                       128.0 26 9 79 0   3     0   11   66 62                 128
2042332 2042332 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2019   grade_1 34 9 62 0   6     0   6   61 56                       117.0 34 9 62 0   6     0   6   61 56                 117
2042333 2042333 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2019   grade_2 28 9 66 0   5     0   8   65 51                       116.0 28 9 66 0   5     0   8   65 51                 116
2042334 2042334 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2019   grade_3 34 9 63 1   5     0   8   56 64                       120.0 34 9 63 1   5     0   8   56 64                 120
2042387 2042387 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2019   grade_5 172 9 12 1   12     0   7   110 103                       213.0 172 9 12 1   12     0   7   110 103                 213
2042515 2042515 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_3 110 9 44 0   6     0   14   89 94                       183.0 110 9 44 0   6     0   14   89 94                 183
2042943 2042943 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_11 63 9 322 0   5     0   6   195 210                       405.0 63 9 322 0   5     0   6   195 210                 405
2042995 2042995 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_9 128 9 18 0   0     1   5   69 92                       161.0 128 9 18 0   0     1   5   69 92                 161
2043168 2043168 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2019   grade_3 71 9 9 0   5     0   2   63 33                       96.0 71 9 9 0   5     0   2   63 33                 96
2043170 2043170 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Memorial Elementary   Regular School No Elementary 03 05 2019   grade_5 103 9 12 0   1     0   1   71 55                       126.0 103 9 12 0   1     0   1   71 55                 126
2043206 2043206 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2019   grade_2 22 9 40 0   1     0   5   40 37                       77.0 22 9 40 0   1     0   5   40 37                 77
2043211 2043211 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2019   grade_1 49 9 36 0   2     0   5   52 49                       101.0 49 9 36 0   2     0   5   52 49                 101

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