enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 395 ✖

grade ✖

  • grade_7 · 395 ✖
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
2238238 2238238 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   grade_7 0 0 54 0   0     0   0   24 30                       54.0 0 0 54 0   0     0   0   24 30                 54
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
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
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
2230599 2230599 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   grade_7 24 6 9 0   7     0   8   23 31                       54.0 24 6 9 0   7     0   8   23 31                 54
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
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
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
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
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
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
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
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
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
2231581 2231581 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   grade_7 25 3 22 0   1     0   2   20 33                       53.0 25 3 22 0   1     0   2   20 33                 53
2233080 2233080 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell: Bartlett Community Partnership   Regular School No Elementary PK 08 2018   grade_7 8 3 24 0   19     0   1   22 33                       55.0 8 3 24 0   19     0   1   22 33                 55
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
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
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
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
2236181 2236181 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield: STEM Middle Academy   Regular School No Middle 06 08 2018   grade_7 12 19 67 0   3     0   0   67 34                       101.0 12 19 67 0   3     0   0   67 34                 101
2239241 2239241 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail: Mohawk Trail Regional High   Regular School No High 07 12 2018   grade_7 54 0 0 0   0     0   0   20 34                       54.0 54 0 0 0   0     0   0   20 34                 54
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2230234 2230234 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_7 2 73 40 0   1     1   4   82 39                       121.0 2 73 40 0   1     1   4   82 39                 121
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
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
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
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
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
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
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
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
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
2230064 2230064 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_7 7 14 75 0   7     0   2   63 42                       105.0 7 14 75 0   7     0   2   63 42                 105
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
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
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
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
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
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
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
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
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
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
2236204 2236204 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield: Conservatory of the Arts   Regular School No High 06 12 2018   grade_7 5 14 37 0   0     0   1   14 43                       57.0 5 14 37 0   0     0   1   14 43                 57
2238075 2238075 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_7 82 2 6 0   5     0   5   57 43                       100.0 82 2 6 0   5     0   5   57 43                 100
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
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
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
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
2231355 2231355 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_7 86 2 12 0   3     0   2   60 45                       105.0 86 2 12 0   3     0   2   60 45                 105
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
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
2237010 2237010 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater: West Bridgewater Junior/Senior   Regular School No High 07 12 2018   grade_7 96 5 5 0   0     0   0   61 45                       106.0 96 5 5 0   0     0   0   61 45                 106
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
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
2232677 2232677 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_7 1 0 98 0   1     0   0   54 46                       100.0 1 0 98 0   1     0   0   54 46                 100
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
2238854 2238854 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth: Dighton Middle School   Regular School No Middle 05 08 2018   grade_7 91 1 4 0   1     0   5   56 46                       102.0 91 1 4 0   1     0   5   56 46                 102
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
2230068 2230068 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston: Washington Irving Middle   Regular School No Middle 06 08 2018   grade_7 2 47 49 0   2     0   0   53 47                       100.0 2 47 49 0   2     0   0   53 47                 100
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
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
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
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
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
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
2231498 2231498 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_7 11 10 81 0   4     0   0   58 48                       106.0 11 10 81 0   4     0   0   58 48                 106
2234410 2234410 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams: Drury High   Regular School No High 07 12 2018   grade_7 85 4 4 0   0     0   7   52 48                       100.0 85 4 4 0   0     0   7   52 48                 100
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
2238045 2238045 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District): KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2018   grade_7 8 18 91 0   2     0   3   74 48                       122.0 8 18 91 0   2     0   3   74 48                 122
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
2239779 2239779 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson: Hanson Middle School   Regular School No Middle 06 08 2018   grade_7 125 1 4 0   0     0   1   83 48                       131.0 125 1 4 0   0     0   1   83 48                 131
2234796 2234796 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer: Palmer High   Regular School No High 06 12 2018   grade_7 95 3 13 0   0     0   8   70 49                       119.0 95 3 13 0   0     0   8   70 49                 119
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
2239264 2239264 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett: Narragansett Middle   Regular School No Middle 05 08 2018   grade_7 95 0 7 0   0     0   2   55 49                       104.0 95 0 7 0   0     0   2   55 49                 104
2239576 2239576 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield: Knox Trail Middle School   Regular School No Middle 05 08 2018   grade_7 100 1 12 0   2     0   1   67 49                       116.0 100 1 12 0   2     0   1   67 49                 116
2239982 2239982 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   grade_7 65 10 15 1   3     1   8   54 49                       103.0 65 10 15 1   3     1   8   54 49                 103
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
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
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

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