enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 391 ✖

grade ✖

  • grade_7 · 391 ✖
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 ▼
934092 934092 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2016   grade_7 27 3 3 0   21     0   7   30 31                       61 27 3 3 0   21     0   7   30 31                 61
934120 934120 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2016   grade_7 33 2 7 0   14     0   6   29 33                       62 33 2 7 0   14     0   6   29 33                 62
935309 935309 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_7 52 1 6 0   3     0   0   38 24                       62 52 1 6 0   3     0   0   38 24                 62
941231 941231 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No 2 05 08 2016   grade_7 56 2 3 0   0     0   1   37 25                       62 56 2 3 0   0     0   1   37 25                 62
935577 935577 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2016   grade_7 3 0 60 0   0     0   0   32 31                       63 3 0 60 0   0     0   0   32 31                 63
940605 940605 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes 3 07 12 2016   grade_7 60 1 0 0   1     0   1   26 37                       63 60 1 0 0   1     0   1   26 37                 63
941767 941767 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2016   grade_7 57 1 4 0   0     0   1   36 27                       63 57 1 4 0   0     0   1   36 27                 63
942016 942016 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_7 43 11 4 1   2     0   2   26 37                       63 43 11 4 1   2     0   2   26 37                 63
933249 933249 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 07 2016   grade_7 0 19 43 0   1     1   0   35 29                       64 0 19 43 0   1     1   0   35 29                 64
935911 935911 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_7 52 0 4 0   6     0   2   35 29                       64 52 0 4 0   6     0   2   35 29                 64
940588 940588 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2016   grade_7 53 1 9 0   1     0   1   29 36                       65 53 1 9 0   1     0   1   29 36                 65
932818 932818 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_7 34 21 4 1   4     0   2   36 30                       66 34 21 4 1   4     0   2   36 30                 66
933084 933084 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_7 9 29 24 0   4     0   1   42 25                       67 9 29 24 0   4     0   1   42 25                 67
940269 940269 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_7 2 47 17 0   0     0   1   33 34                       67 2 47 17 0   0     0   1   33 34                 67
940611 940611 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes 3 07 12 2016   grade_7 45 6 10 0   1     0   5   21 46                       67 45 6 10 0   1     0   5   21 46                 67
933320 933320 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2016   grade_7 4 38 22 0   3     0   1   42 26                       68 4 38 22 0   3     0   1   42 26                 68
934300 934300 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2016   grade_7 55 0 0 0   8     0   5   37 31                       68 55 0 0 0   8     0   5   37 31                 68
934918 934918 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No 1 PK 07 2016   grade_7 41 6 12 0   4     0   5   31 37                       68 41 6 12 0   4     0   5   31 37                 68
940241 940241 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2016   grade_7 4 39 20 0   3     0   2   32 36                       68 4 39 20 0   3     0   2   32 36                 68
940262 940262 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2016   grade_7 51 15 2 0   0     0   1   35 34                       69 51 15 2 0   0     0   1   35 34                 69
940536 940536 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 1 KG 08 2016   grade_7 0 46 22 0   0     0   1   38 31                       69 0 46 22 0   0     0   1   38 31                 69
940488 940488 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes 1 KG 08 2016   grade_7 4 4 62 0   0     0   1   32 39                       71 4 4 62 0   0     0   1   32 39                 71
933101 933101 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2016   grade_7 0 17 55 0   0     0   0   34 38                       72 0 17 55 0   0     0   0   34 38                 72
936026 936026 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2016   grade_7 45 7 7 0   8     0   5   28 44                       72 45 7 7 0   8     0   5   28 44                 72
940651 940651 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_7 34 6 27 0   5     0   0   31 41                       72 34 6 27 0   5     0   0   31 41                 72
940745 940745 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes 2 05 08 2016   grade_7 5 16 48 0   2     0   1   40 32                       72 5 16 48 0   2     0   1   40 32                 72
941988 941988 MA Middlesex   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 4 07 11 2016   grade_7 26 22 19 1   2     0   2   28 44                       72 26 22 19 1   2     0   2   28 44                 72
942029 942029 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_7 52 3 9 0   5     0   3   35 37                       72 52 3 9 0   5     0   3   35 37                 72
940717 940717 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes 3 07 12 2016   grade_7 14 19 32 2   4     1   1   38 35                       73 14 19 32 2   4     1   1   38 35                 73
933425 933425 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   grade_7 1 27 43 0   2     0   1   39 35                       74 1 27 43 0   2     0   1   39 35                 74
940166 940166 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2016   grade_7 3 4 60 0   6     0   1   44 30                       74 3 4 60 0   6     0   1   44 30                 74
941183 941183 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No 2 06 08 2016   grade_7 68 0 4 0   0     0   2   24 50                       74 68 0 4 0   0     0   2   24 50                 74
941967 941967 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 09 2016   grade_7 3 19 50 0   1     0   1   36 38                       74 3 19 50 0   1     0   1   36 38                 74
934824 934824 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2016   grade_7 31 12 25 0   4     0   3   35 40                       75 31 12 25 0   4     0   3   35 40                 75
940249 940249 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 4 05 12 2016   grade_7 3 48 22 0   1     0   1   36 39                       75 3 48 22 0   1     0   1   36 39                 75
937951 937951 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Reay E Sterling Middle   Regular School No 2 05 08 2016   grade_7 28 12 12 1   22     0   2   45 32                       77 28 12 12 1   22     0   2   45 32                 77
938795 938795 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2016   grade_7 10 9 53 0   2     0   3   33 44                       77 10 9 53 0   2     0   3   33 44                 77
939456 939456 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2016   grade_7 70 2 2 0   0     0   3   37 40                       77 70 2 2 0   0     0   3   37 40                 77
933170 933170 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2016   grade_7 7 4 66 0   0     0   1   44 34                       78 7 4 66 0   0     0   1   44 34                 78
935045 935045 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2016   grade_7 26 5 36 0   3     0   8   32 46                       78 26 5 36 0   3     0   8   32 46                 78
933745 933745 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2016   grade_7 2 16 15 0   41     1   4   48 31                       79 2 16 15 0   41     1   4   48 31                 79
934259 934259 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2016   grade_7 31 22 6 2   10     0   8   47 32                       79 31 22 6 2   10     0   8   47 32                 79
938143 938143 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No 2 06 08 2016   grade_7 70 1 0 0   1     0   7   41 38                       79 70 1 0 0   1     0   7   41 38                 79
934253 934253 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No 2 06 08 2016   grade_7 23 29 11 1   11     1   4   30 50                       80 23 29 11 1   11     1   4   30 50                 80
935693 935693 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No 2 06 08 2016   grade_7 75 2 1 0   0     0   2   38 42                       80 75 2 1 0   0     0   2   38 42                 80
940340 940340 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_7 71 0 5 0   1     0   3   31 49                       80 71 0 5 0   1     0   3   31 49                 80
940517 940517 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 08 2016   grade_7 4 22 33 0   19     0   2   37 43                       80 4 22 33 0   19     0   2   37 43                 80
933583 933583 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   grade_7 9 17 40 1   12     0   2   47 34                       81 9 17 40 1   12     0   2   47 34                 81
934110 934110 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2016   grade_7 37 10 12 0   13     0   9   41 40                       81 37 10 12 0   13     0   9   41 40                 81
940725 940725 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_7 31 10 33 0   2     0   5   40 41                       81 31 10 33 0   2     0   5   40 41                 81
940285 940285 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 2 06 08 2016   grade_7 0 64 15 0   0     2   1   44 38                       82 0 64 15 0   0     2   1   44 38                 82
941139 941139 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Junior High School   Regular School No 2 07 08 2016   grade_7 76 0 5 0   0     0   1   43 39                       82 76 0 5 0   0     0   1   43 39                 82
937955 937955 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No 2 05 08 2016   grade_7 44 8 2 0   26     0   3   44 39                       83 44 8 2 0   26     0   3   44 39                 83
940748 940748 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2016   grade_7 30 20 26 0   3     0   4   46 37                       83 30 20 26 0   3     0   4   46 37                 83
936412 936412 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2016   grade_7 29 12 13 0   26     1   3   44 40                       84 29 12 13 0   26     1   3   44 40                 84
934054 934054 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_7 40 3 10 0   25     1   6   48 37                       85 40 3 10 0   25     1   6   48 37                 85
934063 934063 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_7 53 5 10 0   9     0   8   45 40                       85 53 5 10 0   9     0   8   45 40                 85
934250 934250 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2016   grade_7 34 27 11 1   9     1   2   44 41                       85 34 27 11 1   9     1   2   44 41                 85
935638 935638 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_7 78 0 1 1   4     0   1   42 43                       85 78 0 1 1   4     0   1   42 43                 85
940569 940569 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   grade_7 2 42 38 2   0     0   1   47 38                       85 2 42 38 2   0     0   1   47 38                 85
935815 935815 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_7 4 0 77 0   4     0   1   49 37                       86 4 0 77 0   4     0   1   49 37                 86
940917 940917 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_7 76 1 1 0   5     0   3   44 42                       86 76 1 1 0   5     0   3   44 42                 86
934256 934256 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2016   grade_7 30 28 14 0   10     0   5   47 40                       87 30 28 14 0   10     0   5   47 40                 87
933398 933398 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2016   grade_7 12 26 18 0   25     1   6   56 32                       88 12 26 18 0   25     1   6   56 32                 88
941429 941429 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2016   grade_7 82 0 1 0   5     0   0   58 30                       88 82 0 1 0   5     0   0   58 30                 88
934848 934848 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2016   grade_7 30 18 30 0   8     0   3   40 49                       89 30 18 30 0   8     0   3   40 49                 89
935757 935757 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_7 1 1 84 0   3     0   0   48 41                       89 1 1 84 0   3     0   0   48 41                 89
940639 940639 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2016   grade_7 86 0 1 0   1     0   1   37 52                       89 86 0 1 0   1     0   1   37 52                 89
933610 933610 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_7 1 65 21 1   2     0   0   48 42                       90 1 65 21 1   2     0   0   48 42                 90
941545 941545 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2016   grade_7 81 2 5 0   1     0   1   53 37                       90 81 2 5 0   1     0   1   53 37                 90
933431 933431 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_7 9 26 46 0   3     0   7   60 31                       91 9 26 46 0   3     0   7   60 31                 91
934857 934857 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_7 21 24 43 0   1     0   2   48 43                       91 21 24 43 0   1     0   2   48 43                 91
938783 938783 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2016   grade_7 2 16 71 0   2     0   0   50 41                       91 2 16 71 0   2     0   0   50 41                 91
941376 941376 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No 3 07 12 2016   grade_7 86 0 2 1   0     0   3   45 47                       92 86 0 2 1   0     0   3   45 47                 92
932941 932941 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2016   grade_7 88 1 1 0   1     0   2   42 51                       93 88 1 1 0   1     0   2   42 51                 93
935796 935796 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2016   grade_7 1 1 90 0   1     0   0   45 48                       93 1 1 90 0   1     0   0   45 48                 93
941789 941789 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_7 87 1 4 0   1     0   0   57 36                       93 87 1 4 0   1     0   0   57 36                 93
935335 935335 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2016   grade_7 63 0 17 0   3     0   11   55 39                       94 63 0 17 0   3     0   11   55 39                 94
940462 940462 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_7 40 31 18 1   2     0   2   49 45                       94 40 31 18 1   2     0   2   49 45                 94
935523 935523 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_7 62 11 15 0   5     0   2   52 43                       95 62 11 15 0   5     0   2   52 43                 95
936439 936439 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2016   grade_7 37 17 17 0   21     0   3   46 49                       95 37 17 17 0   21     0   3   46 49                 95
936879 936879 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2016   grade_7 95 1 0 0   0     0   0   45 51                       96 95 1 0 0   0     0   0   45 51                 96
941426 941426 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2016   grade_7 86 3 2 0   2     0   3   51 45                       96 86 3 2 0   2     0   3   51 45                 96
933656 933656 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 05 08 2016   grade_7 6 38 49 1   1     0   2   57 40                       97 6 38 49 1   1     0   2   57 40                 97
938780 938780 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2016   grade_7 10 31 56 0   0     0   0   61 36                       97 10 31 56 0   0     0   0   61 36                 97
938792 938792 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2016   grade_7 0 8 89 0   0     0   0   50 47                       97 0 8 89 0   0     0   0   50 47                 97
940818 940818 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_7 88 7 0 0   2     0   0   55 42                       97 88 7 0 0   2     0   0   55 42                 97
935398 935398 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_7 79 3 3 0   11     0   3   52 47                       99 79 3 3 0   11     0   3   52 47                 99
940344 940344 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_7 80 3 6 0   8     0   3   51 49                       100 80 3 6 0   8     0   3   51 49                 100
940703 940703 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_7 87 3 5 0   4     0   1   51 49                       100 87 3 5 0   4     0   1   51 49                 100
940909 940909 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_7 83 2 7 0   3     2   3   50 50                       100 83 2 7 0   3     2   3   50 50                 100
941395 941395 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_7 89 1 5 0   1     0   4   51 49                       100 89 1 5 0   1     0   4   51 49                 100
942000 942000 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 07 2016   grade_7 64 12 19 1   1     0   3   58 42                       100 64 12 19 1   1     0   3   58 42                 100
936060 936060 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2016   grade_7 77 5 5 0   9     0   5   55 46                       101 77 5 5 0   9     0   5   55 46                 101
936421 936421 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_7 29 24 20 1   22     0   5   68 33                       101 29 24 20 1   22     0   5   68 33                 101
936901 936901 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No 2 06 08 2016   grade_7 62 15 18 0   2     1   3   56 45                       101 62 15 18 0   2     1   3   56 45                 101
939470 939470 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_7 87 2 4 0   4     0   4   48 53                       101 87 2 4 0   4     0   4   48 53                 101
939784 939784 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_7 85 1 8 1   2     0   4   48 53                       101 85 1 8 1   2     0   4   48 53                 101
941423 941423 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_7 97 1 1 0   2     0   0   48 53                       101 97 1 1 0   2     0   0   48 53                 101
940582 940582 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_7 60 13 3 0   23     0   3   52 50                       102 60 13 3 0   23     0   3   52 50                 102

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