enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2019 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 493 ✖

grade ✖

  • grade_8 · 493 ✖
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
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
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
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
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
2043291 2043291 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_8 149 9 10 0   137     0   23   160 168                       328.0 149 9 10 0   137     0   23   160 168                 328
2043469 2043469 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_8 39 9 41 0   31     0   6   63 63                       126.0 39 9 41 0   31     0   6   63 63                 126
2043473 2043473 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2019   grade_8 42 9 34 0   76     0   7   91 77                       168.0 42 9 34 0   76     0   7   91 77                 168
2044094 2044094 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_8 218 9 106 3   13     0   12   185 176                       361.0 218 9 106 3   13     0   12   185 176                 361
2044545 2044545 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2019   grade_8 133 9 13 0   59     0   17   104 127                       231.0 133 9 13 0   59     0   17   104 127                 231
2046397 2046397 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2019   grade_8 244 9 9 1   7     0   4   146 128                       274.0 244 9 9 1   7     0   4   146 128                 274
2046640 2046640 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2019   grade_8 128 9 24 2   12     1   9   87 98                       185.0 128 9 24 2   12     1   9   87 98                 185
2047191 2047191 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2019   grade_8 125 9 10 1   7     0   5   79 78                       157.0 125 9 10 1   7     0   5   79 78                 157
2047524 2047524 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_8 10 9 20 0   0     0   1   18 22                       40.0 10 9 20 0   0     0   1   18 22                 40
2047557 2047557 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_8 53 9 7 0   4     0   5   39 39                       78.0 53 9 7 0   4     0   5   39 39                 78
2047992 2047992 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_8 84 9 10 0   4     0   2   60 49                       109.0 84 9 10 0   4     0   2   60 49                 109
2049081 2049081 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2019   grade_8 224 9 10 0   13     0   5   139 122                       261.0 224 9 10 0   13     0   5   139 122                 261
2049135 2049135 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2019   grade_8 164 9 11 3   3     1   7   116 82                       198.0 164 9 11 3   3     1   7   116 82                 198
2041070 2041070 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_8 3 86 38 0   3     1   5   85 51                       136.0 3 86 38 0   3     1   5   85 51                 136
2045294 2045294 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2019   grade_8 27 86 30 1   29     0   10   91 92                       183.0 27 86 30 1   29     0   10   91 92                 183
2040058 2040058 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_8 97 8 24 0   8     0   2   83 56                       139.0 97 8 24 0   8     0   2   83 56                 139
2042390 2042390 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2019   grade_8 171 8 11 2   3     0   5   92 108                       200.0 171 8 11 2   3     0   5   92 108                 200
2042745 2042745 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_8 125 8 32 0   3     0   3   88 83                       171.0 125 8 32 0   3     0   3   88 83                 171
2043225 2043225 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2019   grade_8 105 8 40 0   5     0   6   87 76                       164.0 105 8 40 0   5     0   6   87 76                 164
2043310 2043310 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2019   grade_8 46 8 4 0   1     0   3   32 30                       62.0 46 8 4 0   1     0   3   32 30                 62
2045248 2045248 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_8 106 8 7 0   92     0   5   113 105                       218.0 106 8 7 0   92     0   5   113 105                 218
2045433 2045433 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2019   grade_8 136 8 15 0   2     0   4   93 72                       165.0 136 8 15 0   2     0   4   93 72                 165
2046259 2046259 MA Middlesex   school 2511340 288   Sudbury 251134001872 2880305 Ephraim Curtis Middle   Regular School No Middle 06 08 2019   grade_8 232 8 10 0   27     0   21   137 161                       298.0 232 8 10 0   27     0   21   137 161                 298
2049311 2049311 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_8 70 8 17 1   2     0   5   54 49                       103.0 70 8 17 1   2     0   5   54 49                 103
2047460 2047460 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2019   grade_8 201 75 177 1   24     0   24   242 260                       502.0 201 75 177 1   24     0   24   242 260                 502
2040914 2040914 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2019   grade_8 0 74 72 0   16     1   4   99 68                       167.0 0 74 72 0   16     1   4   99 68                 167
2047462 2047462 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2019   grade_8 77 71 197 0   18     0   19   183 199                       382.0 77 71 197 0   18     0   19   183 199                 382
2047904 2047904 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 2019   grade_8 5 71 78 0   10     0   2   91 75                       166.0 5 71 78 0   10     0   2   91 75                 166
2039819 2039819 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_8 147 7 12 0   3     0   3   83 89                       172.0 147 7 12 0   3     0   3   83 89                 172
2040624 2040624 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_8 12 7 9 0   0     0   0   11 17                       28.0 12 7 9 0   0     0   0   11 17                 28
2040722 2040722 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   grade_8 9 7 18 0   0     0   0   16 18                       34.0 9 7 18 0   0     0   0   16 18                 34
2041666 2041666 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_8 3 7 124 1   1     0   1   77 60                       137.0 3 7 124 1   1     0   1   77 60                 137
2041883 2041883 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2019   grade_8 275 7 10 0   0     0   20   183 129                       312.0 275 7 10 0   0     0   20   183 129                 312
2042109 2042109 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_8 5 7 25 3   3     0   2   22 23                       45.0 5 7 25 3   3     0   2   22 23                 45
2042603 2042603 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_8 214 7 8 0   30     0   6   125 140                       265.0 214 7 8 0   30     0   6   125 140                 265
2042753 2042753 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_8 69 7 58 0   5     0   1   75 65                       140.0 69 7 58 0   5     0   1   75 65                 140
2045732 2045732 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_8 12 7 11 0   6     1   2   19 20                       39.0 12 7 11 0   6     1   2   19 20                 39
2045741 2045741 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary KG 08 2019   grade_8 28 7 4 0   1     1   1   23 19                       42.0 28 7 4 0   1     1   1   23 19                 42
2045961 2045961 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_8 7 7 12 0   0     0   3   13 16                       29.0 7 7 12 0   0     0   3   13 16                 29
2046094 2046094 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2019   grade_8 1 7 64 0   0     0   1   32 41                       73.0 1 7 64 0   0     0   1   32 41                 73
2046099 2046099 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_8 0 7 78 0   0     0   0   43 42                       85.0 0 7 78 0   0     0   0   43 42                 85
2046731 2046731 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2019   grade_8 283 7 17 0   51     0   28   208 178                       386.0 283 7 17 0   51     0   28   208 178                 386
2046789 2046789 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_8 99 7 5 0   0     0   1   63 49                       112.0 99 7 5 0   0     0   1   63 49                 112
2048183 2048183 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_8 109 7 18 3   0     1   3   67 74                       141.0 109 7 18 3   0     1   3   67 74                 141
2048349 2048349 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2019   grade_8 135 7 7 1   17     0   10   82 95                       177.0 135 7 7 1   17     0   10   82 95                 177
2049339 2049339 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 09 2019   grade_8 25 7 19 0   1     0   1   27 26                       53.0 25 7 19 0   1     0   1   27 26                 53
2047751 2047751 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_8 54 68 5 1   7     0   11   70 76                       146.0 54 68 5 1   7     0   11   70 76                 146
2047465 2047465 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2019   grade_8 91 66 218 1   35     0   19   227 203                       430.0 91 66 218 1   35     0   19   227 203                 430
2041249 2041249 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_8 12 64 15 0   0     1   10   44 58                       102.0 12 64 15 0   0     1   10   44 58                 102
2041004 2041004 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_8 97 63 67 0   57     1   13   121 176                       298.0 97 63 67 0   57     1   13   121 176                 298
2047738 2047738 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 2019   grade_8 25 61 25 0   3     0   6   64 56                       120.0 25 61 25 0   3     0   6   64 56                 120
2046218 2046218 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No Middle 06 08 2019   grade_8 136 60 28 1   21     0   13   127 132                       259.0 136 60 28 1   21     0   13   127 132                 259
2040655 2040655 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_8 0 6 20 0   0     0   0   11 15                       26.0 0 6 20 0   0     0   0   11 15                 26
2040784 2040784 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_8 0 6 18 0   0     0   1   13 12                       25.0 0 6 18 0   0     0   1   13 12                 25
2040794 2040794 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_8 6 6 23 0   1     0   0   24 12                       36.0 6 6 23 0   1     0   0   24 12                 36
2041363 2041363 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   grade_8 38 6 3 0   14     0   7   41 27                       68.0 38 6 3 0   14     0   7   41 27                 68
2041391 2041391 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2019   grade_8 26 6 9 0   9     0   8   24 34                       58.0 26 6 9 0   9     0   8   24 34                 58
2041634 2041634 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2019   grade_8 152 6 6 0   29     0   7   98 102                       200.0 152 6 6 0   29     0   7   98 102                 200
2041662 2041662 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_8 11 6 103 0   2     0   2   65 59                       124.0 11 6 103 0   2     0   2   65 59                 124
2041770 2041770 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2019   grade_8 93 6 30 0   2     0   0   78 53                       131.0 93 6 30 0   2     0   0   78 53                 131
2041855 2041855 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2019   grade_8 238 6 20 0   7     0   9   139 141                       280.0 238 6 20 0   7     0   9   139 141                 280
2042181 2042181 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2019   grade_8 142 6 9 2   4     0   6   82 87                       169.0 142 6 9 2   4     0   6   82 87                 169
2044068 2044068 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2019   grade_8 218 6 10 5   6     0   12   118 139                       257.0 218 6 10 5   6     0   12   118 139                 257
2044536 2044536 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2019   grade_8 107 6 23 0   26     0   12   82 92                       174.0 107 6 23 0   26     0   12   82 92                 174
2045355 2045355 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_8 94 6 88 1   6     1   2   102 96                       198.0 94 6 88 1   6     1   2   102 96                 198
2045384 2045384 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2019   grade_8 58 6 100 0   13     0   1   88 90                       178.0 58 6 100 0   13     0   1   88 90                 178
2046088 2046088 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_8 0 6 11 0   0     0   0   15 2                       17.0 0 6 11 0   0     0   0   15 2                 17
2046301 2046301 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No Middle 05 08 2019   grade_8 143 6 16 1   4     0   4   86 88                       174.0 143 6 16 1   4     0   4   86 88                 174
2047188 2047188 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_8 110 6 13 3   12     0   2   70 76                       146.0 110 6 13 3   12     0   2   70 76                 146
2047446 2047446 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No High 07 12 2019   grade_8 4 6 21 0   10     0   3   23 21                       44.0 4 6 21 0   10     0   3   23 21                 44
2047940 2047940 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes High 06 12 2019   grade_8 32 6 27 0   6     0   1   30 42                       72.0 32 6 27 0   6     0   1   30 42                 72
2048247 2048247 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2019   grade_8 153 6 0 0   3     1   16   94 85                       179.0 153 6 0 0   3     1   16   94 85                 179
2048556 2048556 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2019   grade_8 308 6 13 0   4     0   10   170 171                       341.0 308 6 13 0   4     0   10   170 171                 341
2047458 2047458 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2019   grade_8 105 59 136 0   11     0   12   145 178                       323.0 105 59 136 0   11     0   12   145 178                 323
2047962 2047962 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_8 7 59 12 0   4     0   5   44 43                       87.0 7 59 12 0   4     0   5   44 43                 87
2046072 2046072 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2019   grade_8 22 56 94 2   6     0   1   103 78                       181.0 22 56 94 2   6     0   1   103 78                 181
2044157 2044157 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No Middle 06 08 2019   grade_8 201 55 14 0   19     0   5   123 171                       294.0 201 55 14 0   19     0   5   123 171                 294
2041039 2041039 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2019   grade_8 22 52 64 0   32     0   4   71 103                       174.0 22 52 64 0   32     0   4   71 103                 174
2046085 2046085 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2019   grade_8 23 50 162 0   5     0   1   128 113                       241.0 23 50 162 0   5     0   1   128 113                 241
2040170 2040170 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_8 149 5 5 0   5     0   1   79 86                       165.0 149 5 5 0   5     0   1   79 86                 165
2040811 2040811 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   grade_8 6 5 13 0   2     0   1   16 11                       27.0 6 5 13 0   2     0   1   16 11                 27
2041067 2041067 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2019   grade_8 10 5 122 0   1     1   0   77 62                       139.0 10 5 122 0   1     1   0   77 62                 139
2041187 2041187 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2019   grade_8 174 5 9 1   37     0   3   109 120                       229.0 174 5 9 1   37     0   3   109 120                 229
2041373 2041373 MA Middlesex   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2019   grade_8 36 5 4 0   12     0   1   29 29                       58.0 36 5 4 0   12     0   1   29 29                 58
2041400 2041400 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   grade_8 47 5 12 0   11     0   6   32 49                       81.0 47 5 12 0   11     0   6   32 49                 81
2042003 2042003 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2019   grade_8 181 5 2 1   3     0   3   91 104                       195.0 181 5 2 1   3     0   3   91 104                 195
2042223 2042223 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_8 28 5 18 1   2     0   1   30 25                       55.0 28 5 18 1   2     0   1   30 25                 55
2042580 2042580 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_8 164 5 16 1   3     1   17   117 90                       207.0 164 5 16 1   3     1   17   117 90                 207
2042789 2042789 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_8 80 5 34 0   2     1   1   58 65                       123.0 80 5 34 0   2     1   1   58 65                 123
2042968 2042968 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2019   grade_8 250 5 8 0   42     0   8   153 160                       313.0 250 5 8 0   42     0   8   153 160                 313
2043177 2043177 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2019   grade_8 94 5 10 0   2     0   7   57 61                       118.0 94 5 10 0   2     0   7   57 61                 118
2043315 2043315 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_8 33 5 9 1   1     0   4   24 29                       53.0 33 5 9 1   1     0   4   24 29                 53
2043492 2043492 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2019   grade_8 17 5 59 0   81     0   6   92 76                       168.0 17 5 59 0   81     0   6   92 76                 168
2043761 2043761 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2019   grade_8 284 5 17 0   14     0   14   177 157                       334.0 284 5 17 0   14     0   14   177 157                 334

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