enrollments

Data source: Big Local News · About: Big Local

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

✎ 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 ▼
2047835 2047835 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2019   grade_7 0 44 14 0   0     0   1   26 33                       59.0 0 44 14 0   0     0   1   26 33                 59
2048014 2048014 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2019   grade_7 28 12 14 3   2     0   0   29 30                       59.0 28 12 14 3   2     0   0   29 30                 59
2042921 2042921 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_7 8 4 48 0   0     0   0   28 32                       60.0 8 4 48 0   0     0   0   28 32                 60
2043394 2043394 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2019   grade_7 25 2 26 0   5     0   2   31 29                       60.0 25 2 26 0   5     0   2   31 29                 60
2043726 2043726 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2019   grade_7 25 11 15 0   6     0   3   39 21                       60.0 25 11 15 0   6     0   3   39 21                 60
2049295 2049295 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_7 19 18 16 0   6     0   2   35 26                       61.0 19 18 16 0   6     0   2   35 26                 61
2042348 2042348 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2019   grade_7 21 3 33 0   3     0   2   34 28                       62.0 21 3 33 0   3     0   2   34 28                 62
2043309 2043309 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2019   grade_7 44 3 5 1   4     0   5   33 29                       62.0 44 3 5 1   4     0   5   33 29                 62
2045779 2045779 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_7 12 13 31 0   5     0   1   34 28                       62.0 12 13 31 0   5     0   1   34 28                 62
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
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
2044750 2044750 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2019   grade_7 56 0 4 0   0     0   3   35 28                       63.0 56 0 4 0   0     0   3   35 28                 63
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
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
2049279 2049279 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_7 16 8 28 0   8     0   3   36 27                       63.0 16 8 28 0   8     0   3   36 27                 63
2041409 2041409 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2019   grade_7 38 2 8 0   7     0   9   37 27                       64.0 38 2 8 0   7     0   9   37 27                 64
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
2040863 2040863 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   grade_7 11 12 38 0   4     0   1   39 27                       66.0 11 12 38 0   4     0   1   39 27                 66
2043190 2043190 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_7 55 0 8 0   2     0   2   37 30                       67.0 55 0 8 0   2     0   2   37 30                 67
2044171 2044171 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2019   grade_7 54 1 6 0   2     2   3   33 35                       68.0 54 1 6 0   2     2   3   33 35                 68
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
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
2040678 2040678 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2019   grade_7 4 11 29 0   21     0   4   35 34                       69.0 4 11 29 0   21     0   4   35 34                 69
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
2045256 2045256 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2019   grade_7 25 7 7 0   28     0   2   36 33                       69.0 25 7 7 0   28     0   2   36 33                 69
2047896 2047896 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2019   grade_7 47 4 9 0   0     0   9   26 43                       69.0 47 4 9 0   0     0   9   26 43                 69
2045740 2045740 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary KG 08 2019   grade_7 52 4 8 0   3     0   3   39 31                       70.0 52 4 8 0   3     0   3   39 31                 70
2046774 2046774 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2019   grade_7 58 2 7 0   2     0   1   38 32                       70.0 58 2 7 0   2     0   1   38 32                 70
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
2041589 2041589 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   grade_7 50 0 5 0   5     0   11   39 32                       71.0 50 0 5 0   5     0   11   39 32                 71
2047793 2047793 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2019   grade_7 6 0 65 0   0     0   0   33 38                       71.0 6 0 65 0   0     0   0   33 38                 71
2047726 2047726 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_7 9 42 15 1   2     0   3   38 34                       72.0 9 42 15 1   2     0   3   38 34                 72
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
2046117 2046117 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2019   grade_7 2 6 65 0   0     0   0   47 26                       73.0 2 6 65 0   0     0   0   47 26                 73
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
2045448 2045448 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2019   grade_7 69 3 2 0   0     0   0   44 30                       74.0 69 3 2 0   0     0   0   44 30                 74
2047884 2047884 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_7 44 6 18 1   3     0   2   43 31                       74.0 44 6 18 1   3     0   2   43 31                 74
2047952 2047952 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2019   grade_7 6 35 32 0   0     0   1   43 31                       74.0 6 35 32 0   0     0   1   43 31                 74
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
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
2043122 2043122 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_7 1 1 72 0   2     0   0   36 40                       76.0 1 1 72 0   2     0   0   36 40                 76
2047822 2047822 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2019   grade_7 3 22 30 0   19     0   2   40 36                       76.0 3 22 30 0   19     0   2   40 36                 76
2047939 2047939 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes High 06 12 2019   grade_7 31 8 33 0   3     0   1   37 39                       76.0 31 8 33 0   3     0   1   37 39                 76
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
2049293 2049293 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_7 0 37 36 0   2     1   1   36 41                       77.0 0 37 36 0   2     1   1   36 41                 77
2040711 2040711 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_7 10 24 39 0   0     0   5   39 39                       78.0 10 24 39 0   0     0   5   39 39                 78
2047974 2047974 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2019   grade_7 31 30 4 0   8     0   5   39 39                       78.0 31 30 4 0   8     0   5   39 39                 78
2041342 2041342 MA Middlesex   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2019   grade_7 34 4 9 0   24     0   8   50 29                       79.0 34 4 9 0   24     0   8   50 29                 79
2041399 2041399 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   grade_7 40 6 17 0   14     0   3   40 40                       80.0 40 6 17 0   14     0   3   40 40                 80
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
2045759 2045759 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2019   grade_7 10 3 62 0   5     0   0   43 37                       80.0 10 3 62 0   5     0   0   43 37                 80
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
2048196 2048196 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2019   grade_7 61 2 6 1   5     0   6   43 38                       81.0 61 2 6 1   5     0   6   43 38                 81
2040525 2040525 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2019   grade_7 9 32 34 0   5     0   2   50 32                       82.0 9 32 34 0   5     0   2   50 32                 82
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
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
2042939 2042939 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2019   grade_7 7 5 72 0   0     0   1   41 44                       85.0 7 5 72 0   0     0   1   41 44                 85
2043065 2043065 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_7 4 2 76 0   3     0   0   45 40                       85.0 4 2 76 0   3     0   0   45 40                 85
2046093 2046093 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2019   grade_7 1 8 75 0   0     0   1   41 44                       85.0 1 8 75 0   0     0   1   41 44                 85
2040705 2040705 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   grade_7 2 41 38 1   2     0   2   43 43                       86.0 2 41 38 1   2     0   2   43 43                 86
2043892 2043892 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2019   grade_7 68 2 9 0   2     0   5   40 46                       86.0 68 2 9 0   2     0   5   40 46                 86
2042953 2042953 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_7 77 2 4 1   2     0   1   49 38                       87.0 77 2 4 1   2     0   1   49 38                 87
2047079 2047079 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2019   grade_7 78 1 6 0   0     0   2   42 45                       87.0 78 1 6 0   0     0   2   42 45                 87
2047563 2047563 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_7 1 51 30 0   0     0   5   43 44                       87.0 1 51 30 0   0     0   5   43 44                 87
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
2048046 2048046 MA Hampden   school 2500522 499   Hampden Charter School of Science East (District) 250052202680 4990305 Hampden Charter School of Science East   Regular School Yes High 06 12 2019   grade_7 29 22 34 0   3     0   0   39 49                       88.0 29 22 34 0   3     0   0   39 49                 88
2047961 2047961 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_7 21 51 8 0   7     0   2   52 37                       89.0 21 51 8 0   7     0   2   52 37                 89
2041352 2041352 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_7 47 4 16 0   14     0   9   39 51                       90.0 47 4 16 0   14     0   9   39 51                 90
2048022 2048022 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2019   grade_7 35 12 40 1   0     0   2   45 45                       90.0 35 12 40 1   0     0   2   45 45                 90
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
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
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
2040217 2040217 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 3 0   0     0   2   44 48                       92.0 86 1 3 0   0     0   2   44 48                 92
2045251 2045251 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No Middle 05 08 2019   grade_7 37 9 15 0   23     1   7   51 41                       92.0 37 9 15 0   23     1   7   51 41                 92
2046114 2046114 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_7 11 11 69 0   0     0   1   48 44                       92.0 11 11 69 0   0     0   1   48 44                 92
2047865 2047865 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_7 1 29 61 0   0     0   1   44 48                       92.0 1 29 61 0   0     0   1   44 48                 92
2047924 2047924 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2019   grade_7 78 2 2 1   2     0   7   48 44                       92.0 78 2 2 1   2     0   7   48 44                 92
2040890 2040890 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_7 3 62 23 2   0     0   3   47 46                       93.0 3 62 23 2   0     0   3   47 46                 93
2041031 2041031 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   grade_7 3 20 22 0   45     0   3   48 45                       93.0 3 20 22 0   45     0   3   48 45                 93
2048732 2048732 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2019   grade_7 83 1 4 0   2     0   3   48 45                       93.0 83 1 4 0   2     0   3   48 45                 93
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
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
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
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
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
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
2047767 2047767 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_7 30 38 21 0   4     0   3   55 41                       96.0 30 38 21 0   4     0   3   55 41                 96
2048204 2048204 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2019   grade_7 82 2 4 0   5     0   3   55 41                       96.0 82 2 4 0   5     0   3   55 41                 96
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
2042541 2042541 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_7 94 1 2 0   0     0   0   51 46                       97.0 94 1 2 0   0     0   0   51 46                 97
2043717 2043717 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_7 20 15 38 0   16     0   8   48 49                       97.0 20 15 38 0   16     0   8   48 49                 97
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
2040941 2040941 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_7 1 41 54 0   0     0   2   42 56                       98.0 1 41 54 0   0     0   2   42 56                 98
2046090 2046090 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_7 13 11 68 0   4     0   2   54 44                       98.0 13 11 68 0   4     0   2   54 44                 98
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
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
2040453 2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
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
2043708 2043708 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_7 25 18 15 0   41     1   1   57 44                       101.0 25 18 15 0   41     1   1   57 44                 101
2046098 2046098 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_7 3 11 85 0   0     0   2   52 49                       101.0 3 11 85 0   0     0   2   52 49                 101

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);