Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2018 sorted by school_nces_id

View and edit SQL

year

  • 2018 · 575

grade

  • grade_6 · 575
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
2239452 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin: Hardwick Elementary   Regular School No Elementary KG 06 2018   grade_6 33 0 2 0   0     0   1   12 24                       36.0 33 0 2 0   0     0   1   12 24                 36
2239460 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Quabbin: Hubbardston Center   Regular School No Elementary KG 06 2018   grade_6 41 0 3 0   0     0   0   24 20                       44.0 41 0 3 0   0     0   0   24 20                 44
2239469 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_6 26 0 0 0   0     0   0   13 13                       26.0 26 0 0 0   0     0   0   13 13                 26
2239478 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Quabbin: Ruggles Lane   Regular School No Elementary PK 06 2018   grade_6 70 0 1 0   1     0   1   36 37                       73.0 70 0 1 0   1     0   1   36 37                 73
2239575 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_6 84 2 16 0   1     0   7   68 42                       110.0 84 2 16 0   1     0   7   68 42                 110
2239566 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 17 0 1 0   0     0   0   12 6                       18.0 17 0 1 0   0     0   0   12 6                 18
2239550 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District: Powder Mill School   Regular School No Elementary 03 06 2018   grade_6 93 2 6 0   0     0   4   54 51                       105.0 93 2 6 0   0     0   4   54 51                 105
2238770 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen: New Hingham Regional Elementary   Regular School No Elementary PK 06 2018   grade_6 16 0 0 0   0     0   0   6 10                       16.0 16 0 0 0   0     0   0   6 10                 16
2237953 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_6 6 42 27 0   1     0   0   34 42                       76.0 6 42 27 0   1     0   0   34 42                 76
2238008 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public (District): Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2018   grade_6 2 32 4 0   0     0   0   14 24                       38.0 2 32 4 0   0     0   0   14 24                 38
2238069 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_6 70 1 3 0   1     0   5   40 40                       80.0 70 1 3 0   1     0   5   40 40                 80
2238074 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_6 70 1 12 0   7     0   10   46 54                       100.0 70 1 12 0   7     0   10   46 54                 100
2238128 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_6 2 0 31 0   0     0   0   9 24                       33.0 2 0 31 0   0     0   0   9 24                 33
2238138 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District): Sabis International Charter School   Regular School Yes Other KG 12 2018   grade_6 28 43 51 0   5     0   3   67 63                       130.0 28 43 51 0   5     0   3   67 63                 130
2238153 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   grade_6 16 31 9 1   1     0   5   36 27                       63.0 16 31 9 1   1     0   5   36 27                 63
2238192 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District): Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2018   grade_6 34 0 4 0   10     0   2   18 32                       50.0 34 0 4 0   10     0   2   18 32                 50
2238211 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2018   grade_6 23 1 4 0   0     0   4   17 15                       32.0 23 1 4 0   0     0   4   17 15                 32
2238237 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_6 1 2 49 0   0     0   0   24 28                       52.0 1 2 49 0   0     0   0   24 28                 52
2238278 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District): Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2018   grade_6 42 4 0 0   2     0   3   30 21                       51.0 42 4 0 0   2     0   3   30 21                 51
2238288 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_6 18 1 1 0   0     0   0   9 11                       20.0 18 1 1 0   0     0   0   9 11                 20
2238367 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   grade_6 0 47 30 0   0     0   1   34 44                       78.0 0 47 30 0   0     0   1   34 44                 78
2238434 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_6 35 26 3 0   7     0   6   37 40                       77.0 35 26 3 0   7     0   6   37 40                 77
2238453 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_6 87 5 14 0   2     0   2   53 57                       110.0 87 5 14 0   2     0   2   53 57                 110
2239646 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_6 37 0 0 0   0     0   5   26 16                       42.0 37 0 0 0   0     0   5   26 16                 42
2238410 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_6 6 37 34 0   0     0   0   43 34                       77.0 6 37 34 0   0     0   0   43 34                 77
2238420 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_6 23 54 9 1   8     0   3   56 42                       98.0 23 54 9 1   8     0   3   56 42                 98
2238164 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_6 29 61 18 0   4     1   2   55 60                       115.0 29 61 18 0   4     1   2   55 60                 115
2238178 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District): Foxborough Regional Charter School   Regular School Yes Other KG 12 2018   grade_6 47 61 10 0   13     0   5   67 69                       136.0 47 61 10 0   13     0   5   67 69                 136
2238197 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_6 30 38 24 0   4     0   3   51 48                       99.0 30 38 24 0   4     0   3   51 48                 99
2238320 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District): Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2018   grade_6 61 36 14 0   33     0   5   68 81                       149.0 61 36 14 0   33     0   5   68 81                 149
2238380 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_6 78 2 2 1   2     0   7   49 43                       92.0 78 2 2 1   2     0   7   49 43                 92
2238117 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District): Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2018   grade_6 5 22 14 0   0     0   0   12 29                       41.0 5 22 14 0   0     0   0   12 29                 41
2238375 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_6 26 1 1 0   2     0   2   9 23                       32.0 26 1 1 0   2     0   2   9 23                 32
2238389 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_6 4 135 100 0   5     1   3   136 112                       248.0 4 135 100 0   5     1   3   136 112                 248
2238258 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_6 3 22 32 0   20     0   2   41 38                       79.0 3 22 32 0   20     0   2   41 38                 79
2238306 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_6 1 28 65 0   0     1   1   47 49                       96.0 1 28 65 0   0     1   1   47 49                 96
2239137 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional: Manchester Essex Regional Middle School   Regular School No Middle 06 08 2018   grade_6 111 0 3 0   1     0   2   62 55                       117.0 111 0 3 0   1     0   2   62 55                 117
2237993 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public (District): Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2018   grade_6 78 9 26 0   7     0   19   72 67                       139.0 78 9 26 0   7     0   19   72 67                 139
2238102 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_6 0 18 2 0   0     0   0   9 11                       20.0 0 18 2 0   0     0   0   9 11                 20
2238034 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_6 10 102 72 0   3     0   1   89 99                       188.0 10 102 72 0   3     0   1   89 99                 188
2237937 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_6 20 6 140 0   3     1   2   92 80                       172.0 20 6 140 0   3     1   2   92 80                 172
2237997 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_6 2 44 14 0   0     0   0   30 30                       60.0 2 44 14 0   0     0   0   30 30                 60
2237968 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_6 39 8 7 0   3     0   3   36 24                       60.0 39 8 7 0   3     0   3   36 24                 60
2237976 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District): Boston Preparatory Charter Public School   Regular School Yes High 06 12 2018   grade_6 1 48 33 0   0     0   5   44 43                       87.0 1 48 33 0   0     0   5   44 43                 87
2238044 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_6 4 19 96 0   2     0   1   63 59                       122.0 4 19 96 0   2     0   1   63 59                 122
2238247 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2018   grade_6 21 3 9 0   0     0   2   13 22                       35.0 21 3 9 0   0     0   2   13 22                 35
2238396 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_6 30 5 33 0   3     0   3   35 39                       74.0 30 5 33 0   3     0   3   35 39                 74
2238052 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   grade_6 102 0 8 0   21     0   13   77 67                       144.0 102 0 8 0   21     0   13   77 67                 144
2238082 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_6 6 19 7 0   3     0   2   19 18                       37.0 6 19 7 0   3     0   2   19 18                 37
2238226 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_6 7 1 67 0   0     0   0   35 40                       75.0 7 1 67 0   0     0   0   35 40                 75
2238500 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District): Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2018   grade_6 30 6 2 0   9     0   7   23 31                       54.0 30 6 2 0   9     0   7   23 31                 54
2238486 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_6 35 11 39 1   0     0   2   44 44                       88.0 35 11 39 1   0     0   2   44 44                 88
2238513 MA Hampden   school 2500522 499   Hampden Charter School of Science East (District) 250052202680 4990305 Hampden Charter School of Science East (District): Hampden Charter School of Science East   Regular School Yes High 06 12 2018   grade_6 26 25 33 0   2     0   0   40 46                       86.0 26 25 33 0   2     0   0   40 46                 86
2237932 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   grade_6 19 6 18 0   0     0   3   21 25                       46.0 19 6 18 0   0     0   3   21 25                 46
2237944 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District): Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2018   grade_6 4 16 23 0   1     0   1   27 18                       45.0 4 16 23 0   1     0   1   27 18                 45
2237991 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District): Bridge Boston Charter School   Regular School Yes Elementary PK 06 2018   grade_6 0 23 10 0   1     0   1   18 17                       35.0 0 23 10 0   1     0   1   18 17                 35
2238356 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_6 4 90 69 0   16     1   3   89 94                       183.0 4 90 69 0   16     1   3   89 94                 183
2238067 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster (District): Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 06 2018   grade_6 1 0 31 0   0     0   0   18 14                       32.0 1 0 31 0   0     0   0   18 14                 32
2238509 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School (District): Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2018   grade_6 3 9 70 0   1     0   3   45 41                       86.0 3 9 70 0   1     0   3   45 41                 86
2238272 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_6 0 55 13 0   1     0   1   33 37                       70.0 0 55 13 0   1     0   1   33 37                 70
2238021 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District): Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 06 2018   grade_6 1 0 34 0   1     0   0   16 20                       36.0 1 0 34 0   1     0   0   16 20                 36
2238670 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District: Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2018   grade_6 98 2 12 1   8     2   4   71 56                       127.0 98 2 12 1   8     2   4   71 56                 127
2239198 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   grade_6 100 12 13 1   1     1   4   68 64                       132.0 100 12 13 1   1     1   4   68 64                 132
2239945 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_6 12 9 30 0   9     0   4   39 25                       64.0 12 9 30 0   9     0   4   39 25                 64
2239960 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_6 0 36 39 0   5     0   2   41 41                       82.0 0 36 39 0   5     0   2   41 41                 82
2239932 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_6 4 18 54 0   1     1   2   37 43                       80.0 4 18 54 0   1     1   2   37 43                 80
2240016 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_6 18 3 7 0   0     0   3   20 11                       31.0 18 3 7 0   0     0   3   20 11                 31
2239981 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_6 64 11 21 0   2     0   5   55 48                       103.0 64 11 21 0   2     0   5   55 48                 103
2240030 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_6 61 6 14 0   2     0   7   48 42                       90.0 61 6 14 0   2     0   7   48 42                 90
2239998 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_6 2 94 10 1   0     0   0   52 55                       107.0 2 94 10 1   0     0   0   52 55                 107
2240003 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School (District): Libertas Academy Charter School   Regular School Yes Middle 06 06 2018   grade_6 2 11 76 0   0     0   1   49 41                       90.0 2 11 76 0   0     0   1   49 41                 90
2228764 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_6 173 2 10 0   3     0   0   106 82                       188.0 173 2 10 0   3     0   0   106 82                 188
2238553 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   grade_6 46 0 4 0   15     0   3   35 33                       68.0 46 0 4 0   15     0   3   35 33                 68
2238561 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   grade_6 27 1 3 0   35     0   3   32 37                       69.0 27 1 3 0   35     0   3   32 37                 69
2238569 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_6 18 1 1 0   47     0   1   36 32                       68.0 18 1 1 0   47     0   1   36 32                 68
2238545 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   grade_6 47 4 7 1   6     0   5   39 31                       70.0 47 4 7 1   6     0   5   39 31                 70
2238537 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   grade_6 50 0 5 0   13     0   3   43 28                       71.0 50 0 5 0   13     0   3   43 28                 71
2238529 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   grade_6 39 3 2 0   27     0   3   41 33                       74.0 39 3 2 0   27     0   3   41 33                 74
2228781 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_6 109 2 2 0   0     0   1   62 52                       114.0 109 2 2 0   0     0   1   62 52                 114
2238587 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_6 87 2 2 1   0     0   0   43 49                       92.0 87 2 2 1   0     0   0   43 49                 92
2228812 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_6 249 9 18 0   14     0   10   169 131                       300.0 249 9 18 0   14     0   10   169 131                 300
2228837 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_6 145 4 14 0   0     1   3   77 90                       167.0 145 4 14 0   0     1   3   77 90                 167
2228858 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_6 29 5 17 0   5     0   9   29 36                       65.0 29 5 17 0   5     0   9   29 36                 65
2228866 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_6 25 9 13 0   0     0   3   24 26                       50.0 25 9 13 0   0     0   3   24 26                 50
2228874 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_6 27 11 12 1   4     0   4   29 30                       59.0 27 11 12 1   4     0   4   29 30                 59
2228921 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_6 77 4 13 1   44     0   4   79 64                       143.0 77 4 13 1   44     0   4   79 64                 143
2228913 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_6 142 4 15 0   18     0   6   82 103                       185.0 142 4 15 0   18     0   6   82 103                 185
2228917 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_6 126 7 10 1   28     0   4   96 80                       176.0 126 7 10 1   28     0   4   96 80                 176
2228981 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_6 328 11 28 0   52     1   22   204 238                       442.0 328 11 28 0   52     1   22   204 238                 442
2238620 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster: Overlook Middle School   Regular School No Middle 06 08 2018   grade_6 172 2 12 1   1     0   2   93 97                       190.0 172 2 12 1   1     0   2   93 97                 190
2229000 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_6 139 4 27 1   30     0   6   101 106                       207.0 139 4 27 1   30     0   6   101 106                 207
2238645 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston: Athol-Royalston Middle School   Regular School No Middle 05 08 2018   grade_6 57 5 16 0   1     0   4   43 40                       83.0 57 5 16 0   1     0   4   43 40                 83
2238642 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston: Royalston Community School   Regular School No Elementary KG 06 2018   grade_6 20 0 3 0   0     0   1   13 11                       24.0 20 0 3 0   0     0   1   13 11                 24
2229047 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_6 93 5 29 1   9     0   7   69 75                       144.0 93 5 29 1   9     0   7   69 75                 144
2229042 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_6 121 5 22 0   8     0   11   82 85                       167.0 121 5 22 0   8     0   11   82 85                 167
2229052 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_6 104 6 27 0   7     0   11   80 75                       155.0 104 6 27 0   7     0   11   80 75                 155
2229077 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn: Auburn Middle   Regular School No Middle 06 08 2018   grade_6 166 3 15 0   8     0   6   109 89                       198.0 166 3 15 0   8     0   6   109 89                 198
2229094 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_6 32 17 4 1   2     0   3   33 26                       59.0 32 17 4 1   2     0   3   33 26                 59
2229128 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable: Barnstable Intermediate School   Regular School No Middle 06 07 2018   grade_6 263 30 58 0   9     0   18   206 172                       378.0 263 30 58 0   9     0   18   206 172                 378
2229145 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford: John Glenn Middle   Regular School No Middle 06 08 2018   grade_6 121 10 10 0   28     0   12   100 81                       181.0 121 10 10 0   28     0   12   100 81                 181

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