enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_7", state = "MA" and year = 2018 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_7 · 495 ✖
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
2232599 2232599 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_7 6 0 90 0   3     0   0   46 53                       99.0 6 0 90 0   3     0   0   46 53                 99
2232320 2232320 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_7 50 20 15 0   4     0   9   47 51                       98.0 50 20 15 0   4     0   9   47 51                 98
2232953 2232953 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow: Williams Middle   Regular School No Middle 06 08 2018   grade_7 84 1 4 0   6     0   3   61 37                       98.0 84 1 4 0   6     0   3   61 37                 98
2238198 2238198 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   grade_7 49 24 22 0   1     0   2   53 45                       98.0 49 24 22 0   1     0   2   53 45                 98
2229247 2229247 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_7 92 0 0 0   0     0   5   47 50                       97.0 92 0 0 0   0     0   5   47 50                 97
2239717 2239717 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   grade_7 83 1 7 0   2     0   3   48 48                       96.0 83 1 7 0   2     0   3   48 48                 96
2236778 2236778 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware: Ware Junior/Senior High School   Regular School No High 07 12 2018   grade_7 78 2 8 0   2     0   5   45 50                       95.0 78 2 8 0   2     0   5   45 50                 95
2235200 2235200 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy: Point Webster Middle   Regular School No Middle 05 08 2018   grade_7 37 12 8 1   33     0   3   51 43                       94.0 37 12 8 1   33     0   3   51 43                 94
2239023 2239023 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague: Great Falls Middle   Regular School No Middle 06 08 2018   grade_7 74 4 9 0   0     0   7   56 38                       94.0 74 4 9 0   0     0   7   56 38                 94
2239207 2239207 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock: Mt Greylock Regional High   Regular School No High 07 12 2018   grade_7 86 1 2 0   4     0   1   47 47                       94.0 86 1 2 0   4     0   1   47 47                 94
2238421 2238421 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2018   grade_7 7 64 14 0   4     0   4   52 41                       93.0 7 64 14 0   4     0   4   52 41                 93
2230072 2230072 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston: James P Timilty Middle   Regular School No Middle 06 08 2018   grade_7 0 31 60 0   0     1   0   42 50                       92.0 0 31 60 0   0     1   0   42 50                 92
2231470 2231470 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett: George Keverian School   Regular School No Elementary KG 08 2018   grade_7 25 20 43 0   3     0   1   45 47                       92.0 25 20 43 0   3     0   1   45 47                 92
2238307 2238307 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   grade_7 0 41 48 0   1     0   2   49 43                       92.0 0 41 48 0   1     0   2   49 43                 92
2238487 2238487 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District): Global Learning Charter Public School   Regular School Yes High 05 12 2018   grade_7 45 10 29 0   1     0   7   50 42                       92.0 45 10 29 0   1     0   7   50 42                 92
2238588 2238588 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_7 86 4 1 0   0     0   1   46 46                       92.0 86 4 1 0   0     0   1   46 46                 92
2233399 2233399 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden: Linden   Regular School No Elementary KG 08 2018   grade_7 34 16 18 1   19     0   3   44 47                       91.0 34 16 18 1   19     0   3   44 47                 91
2238381 2238381 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District): Rising Tide Charter Public School   Regular School Yes High 05 12 2018   grade_7 80 1 3 1   1     0   5   42 49                       91.0 80 1 3 1   1     0   5   42 49                 91
2238697 2238697 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston: Tahanto Regional High   Regular School No High 06 12 2018   grade_7 81 1 6 0   3     0   0   52 39                       91.0 81 1 6 0   3     0   0   52 39                 91
2230774 2230774 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge: Putnam Avenue Upper School   Regular School No Middle 06 08 2018   grade_7 23 30 17 0   7     0   13   43 47                       90.0 23 30 17 0   7     0   13   43 47                 90
2233589 2233589 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard: Fowler School   Regular School No Middle 04 08 2018   grade_7 70 2 11 0   2     0   5   48 42                       90.0 70 2 11 0   2     0   5   48 42                 90
2237411 2237411 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon: Murdock Middle School   Regular School No Middle 06 08 2018   grade_7 72 0 6 0   4     0   8   51 39                       90.0 72 0 6 0   4     0   8   51 39                 90
2229807 2229807 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_7 3 42 38 0   2     1   3   50 39                       89.0 3 42 38 0   2     1   3   50 39                 89
2230778 2230778 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Cambridge: Rindge Avenue Upper School   Regular School No Middle 06 08 2018   grade_7 40 28 7 0   7     1   6   42 47                       89.0 40 28 7 0   7     1   6   42 47                 89
2236193 2236193 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield: Chestnut Academy   Regular School No Middle 06 08 2018   grade_7 0 10 79 0   0     0   0   41 48                       89.0 0 10 79 0   0     0   0   41 48                 89
2233369 2233369 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_7 23 11 10 0   41     0   2   40 47                       87.0 23 11 10 0   41     0   2   40 47                 87
2237849 2237849 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_7 4 5 70 0   7     0   0   46 40                       86.0 4 5 70 0   7     0   0   46 40                 86
2231460 2231460 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_7 20 15 41 0   6     0   3   39 46                       85.0 20 15 41 0   6     0   3   39 46                 85
2232455 2232455 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale: Hopedale Jr Sr High   Regular School No High 07 12 2018   grade_7 70 0 4 0   6     1   4   49 36                       85.0 70 0 4 0   6     1   4   49 36                 85
2235195 2235195 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy: Reay E Sterling Middle   Regular School No Middle 05 08 2018   grade_7 40 12 12 0   18     0   3   42 43                       85.0 40 12 12 0   18     0   3   42 43                 85
2229778 2229778 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston: Richard J Murphy   Regular School No Elementary PK 08 2018   grade_7 9 22 15 0   36     0   2   46 38                       84.0 9 22 15 0   36     0   2   46 38                 84
2230609 2230609 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_7 49 5 11 0   13     0   6   34 50                       84.0 49 5 11 0   13     0   6   34 50                 84
2233379 2233379 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden: Ferryway   Regular School No Elementary KG 08 2018   grade_7 18 18 26 0   17     0   5   41 43                       84.0 18 18 26 0   17     0   5   41 43                 84
2239304 2239304 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba: Hale   Regular School No Middle 06 08 2018   grade_7 71 2 5 0   4     0   2   42 42                       84.0 71 2 5 0   4     0   2   42 42                 84
2232669 2232669 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_7 4 1 75 0   3     0   0   39 44                       83.0 4 1 75 0   3     0   0   39 44                 83
2238259 2238259 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public (District): Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2018   grade_7 2 25 36 0   17     0   2   39 43                       82.0 2 25 36 0   17     0   2   39 43                 82
2238510 2238510 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School (District): Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2018   grade_7 5 19 57 0   1     0   0   32 50                       82.0 5 19 57 0   1     0   0   32 50                 82
2239296 2239296 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba: Florence Sawyer School   Regular School No Elementary PK 08 2018   grade_7 76 0 3 0   3     0   0   42 40                       82.0 76 0 3 0   3     0   0   42 40                 82
2230014 2230014 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_7 2 45 28 1   3     0   2   47 34                       81.0 2 45 28 1   3     0   2   47 34                 81
2238070 2238070 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District): Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2018   grade_7 71 2 3 0   1     0   4   37 44                       81.0 71 2 3 0   1     0   4   37 44                 81
2230770 2230770 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge: Cambridge Street Upper School   Regular School No Middle 06 08 2018   grade_7 32 20 16 0   6     1   5   37 43                       80.0 32 20 16 0   6     1   5   37 43                 80
2232385 2232385 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke: William R. Peck School   Regular School No Middle 04 08 2018   grade_7 6 3 71 0   0     0   0   45 35                       80.0 6 3 71 0   0     0   0   45 35                 80
2236185 2236185 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 Springfield: South End Middle School   Regular School No Middle 06 08 2018   grade_7 1 13 64 0   0     0   2   35 45                       80.0 1 13 64 0   0     0   2   35 45                 80
2239933 2239933 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_7 6 18 55 0   0     0   1   48 32                       80.0 6 18 55 0   0     0   1   48 32                 80
2231628 2231628 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River: Stone PK-12 School   Regular School No Other 02 12 2018   grade_7 5 0 3 0   0     0   0   7 1                       8.0 5 0 3 0   0     0   0   7 1                 8
2233323 2233323 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_7 2 2 3 1   0     0   0   4 4                       8.0 2 2 3 1   0     0   0   4 4                 8
2229443 2229443 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   grade_7 3 18 54 0   2     0   2   32 47                       79.0 3 18 54 0   2     0   2   32 47                 79
2230557 2230557 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_7 43 7 10 0   7     0   11   41 37                       78.0 43 7 10 0   7     0   11   41 37                 78
2229814 2229814 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston: William H Ohrenberger   Regular School No Middle 03 08 2018   grade_7 12 22 40 0   2     0   1   47 30                       77.0 12 22 40 0   2     0   1   47 30                 77
2238435 2238435 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District): South Shore Charter Public School   Regular School Yes Other KG 12 2018   grade_7 50 18 2 0   3     0   4   39 38                       77.0 50 18 2 0   3     0   4   39 38                 77
2239964 2239964 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II) (District): Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2018   grade_7 24 20 16 0   13     0   4   37 40                       77.0 24 20 16 0   13     0   4   37 40                 77
2229606 2229606 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_7 9 27 34 0   4     0   2   44 32                       76.0 9 27 34 0   4     0   2   44 32                 76
2235426 2235426 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport: Rockport Middle   Regular School No Middle 06 08 2018   grade_7 74 0 2 0   0     0   0   34 42                       76.0 74 0 2 0   0     0   0   34 42                 76
2236992 2236992 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston: West Boylston Junior/Senior High   Regular School No High 06 12 2018   grade_7 64 2 6 0   1     0   3   31 45                       76.0 64 2 6 0   1     0   3   31 45                 76
2237954 2237954 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   grade_7 4 42 27 0   0     0   3   38 38                       76.0 4 42 27 0   0     0   3   38 38                 76
2230547 2230547 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_7 38 10 4 0   15     0   8   37 38                       75.0 38 10 4 0   15     0   8   37 38                 75
2232168 2232168 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_7 59 3 3 0   10     0   0   43 32                       75.0 59 3 3 0   10     0   0   43 32                 75
2238328 2238328 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2018   grade_7 45 3 22 0   0     0   5   45 30                       75.0 45 3 22 0   0     0   5   45 30                 75
2238273 2238273 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School (District): KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2018   grade_7 0 46 26 0   1     0   1   43 31                       74.0 0 46 26 0   1     0   1   43 31                 74
2239300 2239300 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba: Luther Burbank Middle School   Regular School No Middle 06 08 2018   grade_7 60 2 7 0   4     0   1   45 29                       74.0 60 2 7 0   4     0   1   45 29                 74
2239439 2239439 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley: Pioneer Valley Regional   Regular School No High 07 12 2018   grade_7 68 0 1 0   1     0   4   39 35                       74.0 68 0 1 0   1     0   4   39 35                 74
2230830 2230830 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_7 52 1 1 0   15     0   4   35 38                       73.0 52 1 1 0   15     0   4   35 38                 73
2237969 2237969 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District): Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2018   grade_7 47 8 8 1   4     0   5   33 40                       73.0 47 8 8 1   4     0   5   33 40                 73
2237998 2237998 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public (District): Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2018   grade_7 0 49 21 1   1     1   0   42 31                       73.0 0 49 21 1   1     1   0   42 31                 73
2238397 2238397 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District): Salem Academy Charter School   Regular School Yes High 06 12 2018   grade_7 36 5 25 0   6     0   1   31 42                       73.0 36 5 25 0   6     0   1   31 42                 73
2230130 2230130 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston: New Mission High School   Alternative School No High 07 12 2018   grade_7 3 37 29 0   2     0   1   38 34                       72.0 3 37 29 0   2     0   1   38 34                 72
2238227 2238227 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter (District): Holyoke Community Charter School   Regular School Yes Elementary KG 08 2018   grade_7 3 1 66 0   0     0   2   32 40                       72.0 3 1 66 0   0     0   2   32 40                 72
2239961 2239961 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District): UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2018   grade_7 0 39 28 1   1     0   2   33 38                       71.0 0 39 28 1   1     0   2   33 38                 71
2232755 2232755 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_7 62 0 4 0   4     0   0   35 35                       70.0 62 0 4 0   4     0   0   35 35                 70
2234208 2234208 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford: Trinity Day Academy   Regular School No High 06 12 2018   grade_7 4 0 2 1   0     0   0   5 2                       7.0 4 0 2 1   0     0   0   5 2                 7
2234215 2234215 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford: Whaling City Junior/Senior High School   Regular School No High 06 12 2018   grade_7 1 1 5 0   0     0   0   6 1                       7.0 1 1 5 0   0     0   0   6 1                 7
2238342 2238342 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential (District): Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2018   grade_7 62 1 2 0   0     0   4   33 36                       69.0 62 1 2 0   0     0   4   33 36                 69
2238478 2238478 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District): Pioneer Charter School of Science   Regular School Yes Other KG 12 2018   grade_7 15 20 27 2   3     0   2   38 31                       69.0 15 20 27 2   3     0   2   38 31                 69
2229698 2229698 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_7 2 35 22 0   2     2   5   38 30                       68.0 2 35 22 0   2     2   5   38 30                 68
2230568 2230568 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   grade_7 38 6 3 0   14     0   7   37 31                       68.0 38 6 3 0   14     0   7   37 31                 68
2230620 2230620 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline: John D Runkle   Regular School No Elementary PK 08 2018   grade_7 43 1 6 0   12     0   6   29 39                       68.0 43 1 6 0   12     0   6   29 39                 68
2238349 2238349 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District): Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2018   grade_7 48 5 12 0   1     0   2   18 50                       68.0 48 5 12 0   1     0   2   18 50                 68
2231733 2231733 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg: McKay Arts Academy   Regular School No Elementary PK 08 2018   grade_7 25 1 33 0   3     0   5   25 42                       67.0 25 1 33 0   3     0   5   25 42                 67
2238973 2238973 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway: Gateway Regional Middle School   Regular School No Middle 06 08 2018   grade_7 62 0 4 1   0     0   0   36 31                       67.0 62 0 4 1   0     0   0   36 31                 67
2229096 2229096 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_7 34 18 7 0   1     0   5   29 36                       65.0 34 18 7 0   1     0   5   29 36                 65
2232521 2232521 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull: Memorial Middle   Regular School No Middle 06 08 2018   grade_7 65 0 0 0   0     0   0   40 25                       65.0 65 0 0 0   0     0   0   40 25                 65
2235803 2235803 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 Somerville: E Somerville Community   Regular School No Elementary KG 08 2018   grade_7 7 5 51 0   1     0   1   27 38                       65.0 7 5 51 0   1     0   1   27 38                 65
2238083 2238083 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District): Community Charter School of Cambridge   Regular School Yes High 06 12 2018   grade_7 3 38 16 1   5     0   2   32 33                       65.0 3 38 16 1   5     0   2   32 33                 65
2231570 2231570 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River: Henry Lord Community School   Regular School No Elementary PK 08 2018   grade_7 30 8 22 0   2     0   2   36 28                       64.0 30 8 22 0   2     0   2   36 28                 64
2239946 2239946 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District): Collegiate Charter School of Lowell   Regular School Yes Elementary KG 07 2018   grade_7 15 11 20 0   16     0   2   32 32                       64.0 15 11 20 0   16     0   2   32 32                 64
2230173 2230173 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston: Quincy Upper School   Regular School No High 06 12 2018   grade_7 4 13 18 0   26     0   2   36 27                       63.0 4 13 18 0   26     0   2   36 27                 63
2230579 2230579 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline: Heath   Regular School No Elementary PK 08 2018   grade_7 41 4 4 0   13     0   1   33 30                       63.0 41 4 4 0   13     0   1   33 30                 63
2232899 2232899 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln: Lincoln School   Regular School No Elementary PK 08 2018   grade_7 47 9 4 0   0     0   3   33 30                       63.0 47 9 4 0   0     0   3   33 30                 63
2232417 2232417 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke: Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2018   grade_7 8 4 49 0   0     0   1   26 36                       62.0 8 4 49 0   0     0   1   26 36                 62
2233389 2233389 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden: Forestdale   Regular School No Elementary KG 08 2018   grade_7 22 11 22 0   7     0   0   32 30                       62.0 22 11 22 0   7     0   0   32 30                 62
2239535 2239535 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire: Mt Everett Regional   Regular School No High 07 12 2018   grade_7 53 2 3 1   0     0   3   27 35                       62.0 53 2 3 1   0     0   3   27 35                 62
2239690 2239690 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett: Paxton Center   Regular School No Elementary KG 08 2018   grade_7 57 1 2 0   1     0   1   37 25                       62.0 57 1 2 0   1     0   1   37 25                 62
2230589 2230589 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline: Lawrence   Regular School No Elementary KG 08 2018   grade_7 26 4 2 0   22     0   6   29 31                       60.0 26 4 2 0   22     0   6   29 31                 60
2237945 2237945 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District): Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2018   grade_7 3 32 24 0   0     0   1   32 28                       60.0 3 32 24 0   0     0   1   32 28                 60
2238411 2238411 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter Public (District): Seven Hills Charter School   Regular School Yes Elementary KG 08 2018   grade_7 5 25 27 0   0     0   3   29 31                       60.0 5 25 27 0   0     0   3   29 31                 60
2230267 2230267 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_7 0 3 3 0   0     0   0   2 4                       6.0 0 3 3 0   0     0   0   2 4                 6
2235829 2235829 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville: Next Wave Junior High   Alternative School No Middle 06 08 2018   grade_7 3 0 3 0   0     0   0   5 *                       6.0 3 0 3 0   0     0   0   5                   6
2229616 2229616 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston: James W Hennigan   Regular School No Elementary KG 08 2018   grade_7 1 17 41 0   0     0   0   22 37                       59.0 1 17 41 0   0     0   0   22 37                 59
2230056 2230056 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_7 10 24 17 0   6     0   2   34 25                       59.0 10 24 17 0   6     0   2   34 25                 59
2232721 2232721 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee: Lee Middle/High School   Regular School No High 07 12 2018   grade_7 49 1 4 0   0     0   5   25 34                       59.0 49 1 4 0   0     0   5   25 34                 59

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