enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 399 ✖

grade ✖

  • grade_7 · 399 ✖
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
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
2048224 2048224 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2019   grade_7 111 2 6 0   0     0   6   71 53                       125.0 111 2 6 0   0     0   6   71 53                 125
2048408 2048408 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2019   grade_7 252 2 5 1   0     0   4   129 135                       264.0 252 2 5 1   0     0   4   129 135                 264
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
2048478 2048478 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No Middle 06 08 2019   grade_7 77 1 7 0   0     0   9   43 51                       94.0 77 1 7 0   0     0   9   43 51                 94
2048518 2048518 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   grade_7 14 1 2 0   0     0   1   8 10                       18.0 14 1 2 0   0     0   1   8 10                 18
2048700 2048700 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2019   grade_7 108 0 4 0   0     0   3   63 52                       115.0 108 0 4 0   0     0   3   63 52                 115
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
2049065 2049065 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2019   grade_7 54 1 5 0   0     0   2   34 28                       62.0 54 1 5 0   0     0   2   34 28                 62
2049110 2049110 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2019   grade_7 85 1 6 0   0     0   4   53 43                       96.0 85 1 6 0   0     0   4   53 43                 96
2049326 2049326 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_7 3 101 9 1   0     0   0   62 52                       114.0 3 101 9 1   0     0   0   62 52                 114
2049331 2049331 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 07 2019   grade_7 2 10 77 0   0     0   2   55 36                       91.0 2 10 77 0   0     0   2   55 36                 91
2040381 2040381 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_7 5 23 65 0   1     0   1   50 45                       95.0 5 23 65 0   1     0   1   50 45                 95
2040534 2040534 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_7 1 13 36 0   1     0   1   24 28                       52.0 1 13 36 0   1     0   1   24 28                 52
2040938 2040938 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2019   grade_7 6 36 44 1   1     0   3   46 45                       91.0 6 36 44 1   1     0   3   46 45                 91
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
2041465 2041465 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_7 13 0 21 0   1     0   2   11 26                       37.0 13 0 21 0   1     0   2   11 26                 37
2041538 2041538 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2019   grade_7 30 16 14 0   1     0   8   40 29                       69.0 30 16 14 0   1     0   8   40 29                 69
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
2041882 2041882 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2019   grade_7 279 5 15 0   1     0   20   174 146                       320.0 279 5 15 0   1     0   20   174 146                 320
2041933 2041933 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2019   grade_7 114 0 3 0   1     0   4   79 43                       122.0 114 0 3 0   1     0   4   79 43                 122
2042522 2042522 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_7 127 8 36 0   1     0   17   93 96                       189.0 127 8 36 0   1     0   17   93 96                 189
2042617 2042617 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_7 50 0 4 0   1     0   1   27 29                       56.0 50 0 4 0   1     0   1   27 29                 56
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
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
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
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
2043518 2043518 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2019   grade_7 157 5 22 0   1     0   6   98 93                       191.0 157 5 22 0   1     0   6   98 93                 191
2043533 2043533 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2019   grade_7 124 2 9 2   1     0   3   74 67                       141.0 124 2 9 2   1     0   3   74 67                 141
2043668 2043668 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_7 2 0 4 0   1     0   1   7 1                       8.0 2 0 4 0   1     0   1   7 1                 8
2044587 2044587 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   grade_7 100 4 4 0   1     0   5   61 53                       114.0 100 4 4 0   1     0   5   61 53                 114
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
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
2045144 2045144 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2019   grade_7 230 0 4 1   1     0   10   132 114                       246.0 230 0 4 1   1     0   10   132 114                 246
2045488 2045488 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2019   grade_7 21 0 14 0   1     0   4   22 18                       40.0 21 0 14 0   1     0   4   22 18                 40
2045769 2045769 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2019   grade_7 18 4 6 0   1     0   1   16 14                       30.0 18 4 6 0   1     0   1   16 14                 30
2046321 2046321 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2019   grade_7 186 3 5 0   1     0   1   105 91                       196.0 186 3 5 0   1     0   1   105 91                 196
2046788 2046788 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2019   grade_7 80 4 5 2   1     0   5   46 51                       97.0 80 4 5 2   1     0   5   46 51                 97
2047543 2047543 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_7 5 43 25 0   1     0   1   34 41                       75.0 5 43 25 0   1     0   1   34 41                 75
2047604 2047604 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 07 2019   grade_7 0 0 32 0   1     0   0   14 19                       33.0 0 0 32 0   1     0   0   14 19                 33
2047627 2047627 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_7 4 20 96 0   1     0   1   60 62                       122.0 4 20 96 0   1     0   1   60 62                 122
2047650 2047650 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_7 65 3 5 0   1     0   6   40 40                       80.0 65 3 5 0   1     0   6   40 40                 80
2048043 2048043 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2019   grade_7 2 6 65 0   1     0   3   38 39                       77.0 2 6 65 0   1     0   3   38 39                 77
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
2048160 2048160 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_7 86 5 21 0   1     0   3   52 64                       116.0 86 5 21 0   1     0   3   52 64                 116
2048335 2048335 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_7 99 2 4 0   1     0   4   62 48                       110.0 99 2 4 0   1     0   4   62 48                 110
2048368 2048368 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2019   grade_7 128 2 16 0   1     0   5   68 84                       152.0 128 2 16 0   1     0   5   68 84                 152
2048535 2048535 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2019   grade_7 128 0 3 0   1     0   4   70 65                       136.0 128 0 3 0   1     0   4   70 65                 136
2048575 2048575 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_7 107 0 3 0   1     0   2   59 54                       113.0 107 0 3 0   1     0   2   59 54                 113
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
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
2048680 2048680 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2019   grade_7 62 0 4 0   1     0   1   33 35                       68.0 62 0 4 0   1     0   1   33 35                 68
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
2048892 2048892 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2019   grade_7 93 0 6 0   1     0   2   60 42                       102.0 93 0 6 0   1     0   2   60 42                 102
2048945 2048945 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_7 101 0 7 0   1     0   4   57 56                       113.0 101 0 7 0   1     0   4   57 56                 113
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
2049074 2049074 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2019   grade_7 40 0 5 0   1     0   0   17 29                       46.0 40 0 5 0   1     0   0   17 29                 46
2049087 2049087 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 4 0   1     0   2   43 51                       94.0 86 1 4 0   1     0   2   43 51                 94
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
2049266 2049266 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_7 6 19 53 0   1     1   2   40 42                       82.0 6 19 53 0   1     1   2   40 42                 82
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
2040301 2040301 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 06 08 2019   grade_7 129 7 15 0   10     2   4   91 76                       167.0 129 7 15 0   10     2   4   91 76                 167
2041372 2041372 MA Middlesex   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2019   grade_7 36 2 4 0   10     0   3   34 21                       55.0 36 2 4 0   10     0   3   34 21                 55
2041390 2041390 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2019   grade_7 27 7 9 0   10     0   3   28 28                       56.0 27 7 9 0   10     0   3   28 28                 56
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
2042263 2042263 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_7 106 14 49 0   10     0   16   111 84                       195.0 106 14 49 0   10     0   16   111 84                 195
2042703 2042703 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_7 64 0 4 0   10     0   2   44 36                       80.0 64 0 4 0   10     0   2   44 36                 80
2043353 2043353 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_7 85 1 9 0   10     0   3   50 58                       108.0 85 1 9 0   10     0   3   50 58                 108
2044002 2044002 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2019   grade_7 198 28 17 0   10     0   7   123 137                       260.0 198 28 17 0   10     0   7   123 137                 260
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
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
2049080 2049080 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2019   grade_7 249 3 15 1   10     0   5   132 151                       283.0 249 3 15 1   10     0   5   132 151                 283
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
2043373 2043373 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 07 2019   grade_7 20 4 19 0   11     0   1   36 19                       55.0 20 4 19 0   11     0   1   36 19                 55
2044851 2044851 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2019   grade_7 159 30 31 0   11     1   5   120 117                       237.0 159 30 31 0   11     1   5   120 117                 237
2046639 2046639 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2019   grade_7 117 8 30 0   11     0   7   89 84                       173.0 117 8 30 0   11     0   7   89 84                 173
2047763 2047763 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2019   grade_7 36 0 2 0   11     0   3   21 31                       52.0 36 0 2 0   11     0   3   21 31                 52
2048729 2048729 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2019   grade_7 53 0 2 0   11     0   2   34 34                       68.0 53 0 2 0   11     0   2   34 34                 68
2041381 2041381 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2019   grade_7 34 3 15 0   12     0   9   41 32                       73.0 34 3 15 0   12     0   9   41 32                 73
2045554 2045554 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2019   grade_7 130 10 54 1   12     0   1   106 102                       208.0 130 10 54 1   12     0   1   106 102                 208
2046178 2046178 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2019   grade_7 136 5 17 0   12     0   8   85 93                       178.0 136 5 17 0   12     0   8   85 93                 178
2046396 2046396 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 John W. Wynn Middle   Regular School No Middle 07 08 2019   grade_7 243 9 9 0   12     0   2   149 126                       275.0 243 9 9 0   12     0   2   149 126                 275
2047457 2047457 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2019   grade_7 123 68 149 1   12     0   9   186 176                       362.0 123 68 149 1   12     0   9   186 176                 362
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
2047903 2047903 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_7 5 83 65 0   12     0   4   83 86                       169.0 5 83 65 0   12     0   4   83 86                 169
2043287 2043287 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_7 123 14 16 0   120     0   23   144 152                       296.0 123 14 16 0   120     0   23   144 152                 296
2039858 2039858 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2019   grade_7 241 10 18 0   13     0   9   165 126                       291.0 241 10 18 0   13     0   9   165 126                 291
2040935 2040935 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2019   grade_7 7 18 67 0   13     0   3   64 44                       108.0 7 18 67 0   13     0   3   64 44                 108
2041362 2041362 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   grade_7 35 5 9 0   13     0   12   38 36                       74.0 35 5 9 0   13     0   12   38 36                 74
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
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
2042133 2042133 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_7 31 21 57 1   13     0   1   61 63                       124.0 31 21 57 1   13     0   1   61 63                 124
2042266 2042266 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2019   grade_7 144 29 40 0   13     0   14   111 129                       240.0 144 29 40 0   13     0   14   111 129                 240
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
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
2048117 2048117 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2019   grade_7 126 22 46 1   13     0   15   114 109                       223.0 126 22 46 1   13     0   15   114 109                 223
2048555 2048555 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No Middle 07 08 2019   grade_7 347 6 17 1   13     0   4   204 184                       388.0 347 6 17 1   13     0   4   204 184                 388
2048585 2048585 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No Middle 07 08 2019   grade_7 281 0 9 0   13     0   6   142 167                       309.0 281 0 9 0   13     0   6   142 167                 309

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