enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 499 ✖

grade ✖

  • grade_7 · 499 ✖
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
2040387 2040387 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_7 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2041274 2041274 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_7 * * * *   *     *   *   1 *                       1.0                         1                   1
2041702 2041702 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_7 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2042771 2042771 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_7 * * * *   *     *   *   5 *                       5.0                         5                   5
2043454 2043454 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_7 * * * *   *     *   *   3 *                       4.0                         3                   4
2043509 2043509 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2048250 2048250 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_7 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2041288 2041288 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_7 4 2 0 0   0     0   1   5 2                       7.0 4 2 0 0   0     0   1   5 2                 7
2041759 2041759 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_7 15 0 0 0   0     0   2   8 9                       17.0 15 0 0 0   0     0   2   8 9                 17
2042270 2042270 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_7 3 1 0 0   0     0   5   8 1                       9.0 3 1 0 0   0     0   5   8 1                 9
2042369 2042369 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_7 9 0 0 0   0     0   0   2 7                       9.0 9 0 0 0   0     0   0   2 7                 9
2043007 2043007 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_7 59 1 0 0   1     0   2   31 32                       63.0 59 1 0 0   1     0   2   31 32                 63
2045005 2045005 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2019   grade_7 215 1 0 0   1     1   1   125 94                       219.0 215 1 0 0   1     1   1   125 94                 219
2046861 2046861 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2019   grade_7 145 3 0 0   53     0   7   101 107                       208.0 145 3 0 0   53     0   7   101 107                 208
2047890 2047890 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2019   grade_7 67 1 0 0   0     0   2   37 33                       70.0 67 1 0 0   0     0   2   37 33                 70
2048110 2048110 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_7 87 2 0 1   0     0   1   44 47                       91.0 87 2 0 1   0     0   1   44 47                 91
2048248 2048248 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2019   grade_7 211 17 0 0   3     0   15   141 105                       246.0 211 17 0 0   3     0   15   141 105                 246
2039833 2039833 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_7 117 2 1 0   0     0   1   64 57                       121.0 117 2 1 0   0     0   1   64 57                 121
2042717 2042717 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_7 29 1 1 0   0     0   0   15 16                       31.0 29 1 1 0   0     0   0   15 16                 31
2043324 2043324 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_7 105 5 1 0   6     0   5   51 71                       122.0 105 5 1 0   6     0   5   51 71                 122
2047549 2047549 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2019   grade_7 32 4 1 0   0     0   0   18 19                       37.0 32 4 1 0   0     0   0   18 19                 37
2047840 2047840 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2019   grade_7 28 3 1 0   2     0   3   17 20                       37.0 28 3 1 0   2     0   3   17 20                 37
2047849 2047849 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_7 17 1 1 1   0     0   0   8 12                       20.0 17 1 1 1   0     0   0   8 12                 20
2048035 2048035 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2019   grade_7 26 6 1 0   8     0   6   19 28                       47.0 26 6 1 0   8     0   6   19 28                 47
2048436 2048436 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2019   grade_7 60 2 1 0   0     0   1   31 33                       64.0 60 2 1 0   0     0   1   31 33                 64
2048649 2048649 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2019   grade_7 116 3 1 0   1     0   1   50 72                       122.0 116 3 1 0   1     0   1   50 72                 122
2048735 2048735 MA Middlesex   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2019   grade_7 99 0 1 0   1     0   4   48 57                       105.0 99 0 1 0   1     0   4   48 57                 105
2048850 2048850 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2019   grade_7 58 1 1 0   0     0   3   35 28                       63.0 58 1 1 0   0     0   3   35 28                 63
2048931 2048931 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2019   grade_7 42 0 1 0   0     0   2   18 27                       45.0 42 0 1 0   0     0   2   18 27                 45
2049029 2049029 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_7 37 0 1 1   1     0   3   28 15                       43.0 37 0 1 1   1     0   3   28 15                 43
2039947 2039947 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_7 124 8 10 0   28     0   4   91 83                       174.0 124 8 10 0   28     0   4   91 83                 174
2040135 2040135 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_7 114 13 10 0   27     0   14   98 80                       178.0 114 13 10 0   27     0   14   98 80                 178
2040443 2040443 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_7 2 13 10 0   0     0   3   13 15                       28.0 2 13 10 0   0     0   3   13 15                 28
2040910 2040910 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_7 0 6 10 0   0     0   2   11 7                       18.0 0 6 10 0   0     0   2   11 7                 18
2041124 2041124 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2019   grade_7 158 1 10 2   1     0   5   90 87                       177.0 158 1 10 2   1     0   5   90 87                 177
2041541 2041541 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2019   grade_7 22 32 10 0   13     0   6   42 41                       83.0 22 32 10 0   13     0   6   42 41                 83
2041544 2041544 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2019   grade_7 43 24 10 0   9     0   8   37 57                       94.0 43 24 10 0   9     0   8   37 57                 94
2042967 2042967 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2019   grade_7 178 4 10 1   31     0   10   115 119                       234.0 178 4 10 1   31     0   10   115 119                 234
2043941 2043941 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2019   grade_7 124 15 10 0   9     0   8   89 77                       166.0 124 15 10 0   9     0   8   89 77                 166
2044909 2044909 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2019   grade_7 84 1 10 0   4     0   6   49 56                       105.0 84 1 10 0   4     0   6   49 56                 105
2045809 2045809 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2019   grade_7 104 0 10 0   30     0   8   84 68                       152.0 104 0 10 0   30     0   8   84 68                 152
2047065 2047065 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington Middle School   Regular School No Middle 06 08 2019   grade_7 237 4 10 2   9     0   12   146 128                       274.0 237 4 10 2   9     0   12   146 128                 274
2049134 2049134 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2019   grade_7 149 9 10 2   1     0   6   98 79                       177.0 149 9 10 2   1     0   6   98 79                 177
2046577 2046577 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No Middle 06 08 2019   grade_7 89 21 102 0   10     0   4   104 122                       226.0 89 21 102 0   10     0   4   104 122                 226
2045383 2045383 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2019   grade_7 58 5 103 1   9     0   4   86 94                       180.0 58 5 103 1   9     0   4   86 94                 180
2043137 2043137 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_7 11 4 104 0   6     0   0   62 63                       125.0 11 4 104 0   6     0   0   62 63                 125
2044408 2044408 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_7 109 49 104 1   0     1   9   139 134                       273.0 109 49 104 1   0     1   9   139 134                 273
2043103 2043103 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 106 0   0     0   0   61 52                       113.0 7 0 106 0   0     0   0   61 52                 113
2041739 2041739 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2019   grade_7 134 5 108 0   8     0   14   129 140                       269.0 134 5 108 0   8     0   14   129 140                 269
2043086 2043086 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_7 2 2 108 0   1     0   0   50 63                       113.0 2 2 108 0   1     0   0   50 63                 113
2046081 2046081 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2019   grade_7 18 33 108 0   0     0   3   95 67                       162.0 18 33 108 0   0     0   3   95 67                 162
2040150 2040150 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No Middle 07 08 2019   grade_7 164 5 11 0   3     1   4   80 108                       188.0 164 5 11 0   3     1   4   80 108                 188
2040846 2040846 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_7 0 12 11 0   0     0   4   13 14                       27.0 0 12 11 0   0     0   4   13 14                 27
2041186 2041186 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2019   grade_7 165 11 11 0   36     0   0   104 119                       223.0 165 11 11 0   36     0   0   104 119                 223
2041547 2041547 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No Middle 06 08 2019   grade_7 32 24 11 0   13     0   8   39 49                       88.0 32 24 11 0   13     0   8   39 49                 88
2042033 2042033 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_7 77 0 11 0   6     0   2   43 53                       96.0 77 0 11 0   6     0   2   43 53                 96
2043314 2043314 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_7 29 3 11 0   1     1   6   26 25                       51.0 29 3 11 0   1     1   6   26 25                 51
2044735 2044735 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2019   grade_7 145 4 11 0   1     1   7   77 91                       169.0 145 4 11 0   1     1   7   77 91                 169
2044795 2044795 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2019   grade_7 158 3 11 1   5     0   12   87 103                       190.0 158 3 11 1   5     0   12   87 103                 190
2046978 2046978 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2019   grade_7 196 6 11 0   35     0   9   137 120                       257.0 196 6 11 0   35     0   9   137 120                 257
2047556 2047556 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_7 51 6 11 0   2     0   5   41 34                       75.0 51 6 11 0   2     0   5   41 34                 75
2047582 2047582 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2019   grade_7 1 51 11 0   0     0   0   35 28                       63.0 1 51 11 0   0     0   0   35 28                 63
2047661 2047661 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2019   grade_7 3 38 11 0   3     0   1   23 33                       56.0 3 38 11 0   3     0   1   23 33                 56
2047693 2047693 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_7 0 15 11 0   0     0   0   8 18                       26.0 0 15 11 0   0     0   0   8 18                 26
2047750 2047750 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_7 42 73 11 0   12     0   6   66 78                       144.0 42 73 11 0   12     0   6   66 78                 144
2048372 2048372 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2019   grade_7 142 1 11 0   2     0   3   80 79                       159.0 142 1 11 0   2     0   3   80 79                 159
2048599 2048599 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2019   grade_7 171 1 11 0   4     0   11   104 94                       198.0 171 1 11 0   4     0   11   104 94                 198
2043227 2043227 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2019   grade_7 138 29 110 0   13     0   8   161 137                       298.0 138 29 110 0   13     0   8   161 137                 298
2044402 2044402 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2019   grade_7 131 49 110 1   5     0   16   162 150                       312.0 131 49 110 1   5     0   16   162 150                 312
2043658 2043658 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2019   grade_7 67 9 111 1   19     0   11   115 103                       218.0 67 9 111 1   19     0   11   115 103                 218
2046071 2046071 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2019   grade_7 13 49 112 0   3     0   0   88 89                       177.0 13 49 112 0   3     0   0   88 89                 177
2045354 2045354 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Rumney Marsh Academy   Regular School No Middle 06 08 2019   grade_7 56 11 115 1   10     0   5   103 95                       198.0 56 11 115 1   10     0   5   103 95                 198
2041661 2041661 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_7 9 10 116 0   0     0   0   73 62                       135.0 9 10 116 0   0     0   0   73 62                 135
2039818 2039818 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_7 170 2 12 0   3     0   0   104 83                       187.0 170 2 12 0   3     0   0   104 83                 187
2040169 2040169 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial School   Regular School No Middle 04 07 2019   grade_7 155 3 12 1   8     0   6   101 84                       185.0 155 3 12 1   8     0   6   101 84                 185
2040470 2040470 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2019   grade_7 6 3 12 0   2     0   1   12 12                       24.0 6 3 12 0   2     0   1   12 12                 24
2040824 2040824 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_7 2 6 12 0   0     0   0   14 6                       20.0 2 6 12 0   0     0   0   14 6                 20
2041633 2041633 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2019   grade_7 165 11 12 0   32     1   5   117 109                       226.0 165 11 12 0   32     1   5   117 109                 226
2042579 2042579 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_7 202 4 12 0   4     1   7   120 110                       230.0 202 4 12 0   4     1   7   120 110                 230
2043760 2043760 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2019   grade_7 236 13 12 0   29     0   9   150 149                       299.0 236 13 12 0   29     0   9   150 149                 299
2044123 2044123 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2019   grade_7 75 1 12 0   6     0   6   54 46                       100.0 75 1 12 0   6     0   6   54 46                 100
2044725 2044725 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2019   grade_7 147 8 12 0   21     2   11   93 108                       201.0 147 8 12 0   21     2   11   93 108                 201
2047654 2047654 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_7 68 3 12 0   6     0   11   46 54                       100.0 68 3 12 0   6     0   11   46 54                 100
2041665 2041665 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_7 11 3 124 1   1     0   0   73 67                       140.0 11 3 124 1   1     0   0   73 67                 140
2041669 2041669 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2019   grade_7 8 5 126 0   1     0   1   63 78                       141.0 8 5 126 0   1     0   1   63 78                 141
2045386 2045386 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Susan B. Anthony Middle School   Regular School No Middle 06 08 2019   grade_7 65 4 126 0   6     0   1   101 101                       202.0 65 4 126 0   6     0   1   101 101                 202
2043090 2043090 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_7 7 0 129 0   0     0   2   60 78                       138.0 7 0 129 0   0     0   2   60 78                 138
2040880 2040880 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_7 0 21 13 0   0     0   5   22 17                       39.0 0 21 13 0   0     0   5   22 17                 39
2043290 2043290 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_7 123 16 13 0   100     0   26   130 148                       278.0 123 16 13 0   100     0   26   130 148                 278
2043735 2043735 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_7 42 17 13 1   19     0   4   51 44                       96.0 42 17 13 1   19     0   4   51 44                 96
2044108 2044108 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2019   grade_7 106 4 13 0   6     0   7   69 67                       136.0 106 4 13 0   6     0   7   69 67                 136
2045750 2045750 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2019   grade_7 19 4 13 0   6     0   3   27 18                       45.0 19 4 13 0   6     0   3   27 18                 45
2046087 2046087 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_7 2 4 13 0   0     0   0   15 4                       19.0 2 4 13 0   0     0   0   15 4                 19
2046522 2046522 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2019   grade_7 137 8 13 1   9     0   1   91 78                       169.0 137 8 13 1   9     0   1   91 78                 169
2048138 2048138 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2019   grade_7 167 2 13 1   1     0   2   94 92                       186.0 167 2 13 1   1     0   2   94 92                 186
2048182 2048182 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_7 92 3 13 2   8     2   5   66 59                       125.0 92 3 13 2   8     2   5   66 59                 125
2048626 2048626 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2019   grade_7 98 13 13 1   1     1   7   70 64                       134.0 98 13 13 1   1     1   7   70 64                 134
2049338 2049338 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_7 35 5 13 1   1     0   1   31 25                       56.0 35 5 13 1   1     0   1   31 25                 56
2046084 2046084 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No Middle 06 08 2019   grade_7 25 45 135 0   7     0   1   123 90                       213.0 25 45 135 0   7     0   1   123 90                 213
2039944 2039944 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2019   grade_7 143 5 14 0   19     0   6   81 106                       187.0 143 5 14 0   19     0   6   81 106                 187

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