Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2018 · 495

grade

  • grade_8 · 495
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▼ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2231645 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2237229 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2232023 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_8 * * * *   *     *   *   * *                       1.0                                             1
2234771 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_8 * * * *   *     *   *   1 *                       1.0                         1                   1
2232220 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill: Haverhill Alternative School   Regular School No High 06 12 2018   grade_8 6 1 3 0   0     0   0   7 3                       10.0 6 1 3 0   0     0   0   7 3                 10
2232701 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_8 1 1 8 0   0     0   0   9 1                       10.0 1 1 8 0   0     0   0   9 1                 10
2235101 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_8 5 2 3 0   0     0   0   3 7                       10.0 5 2 3 0   0     0   0   3 7                 10
2231490 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett: Lafayette School   Regular School No Elementary KG 08 2018   grade_8 32 23 37 0   6     0   2   49 51                       100.0 32 23 37 0   6     0   2   49 51                 100
2238076 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_8 84 4 1 0   9     0   2   48 52                       100.0 84 4 1 0   9     0   2   48 52                 100
2232456 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale: Hopedale Jr Sr High   Regular School No High 07 12 2018   grade_8 94 1 5 0   0     0   1   50 51                       101.0 94 1 5 0   0     0   1   50 51                 101
2231723 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_8 37 5 48 0   6     0   6   56 46                       102.0 37 5 48 0   6     0   6   56 46                 102
2239983 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_8 76 4 14 1   2     1   4   53 49                       102.0 76 4 14 1   2     1   4   53 49                 102
2236151 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_8 24 26 52 0   1     0   0   54 49                       103.0 24 26 52 0   1     0   0   54 49                 103
2233864 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis: Millis Middle   Regular School No Middle 05 08 2018   grade_8 89 5 6 0   3     0   1   57 47                       104.0 89 5 6 0   3     0   1   57 47                 104
2238672 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_8 82 5 7 2   1     1   7   54 51                       105.0 82 5 7 2   1     1   7   54 51                 105
2238950 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier: Frontier Regional   Regular School No High 07 12 2018   grade_8 93 1 6 0   1     1   3   53 52                       105.0 93 1 6 0   1     1   3   53 52                 105
2233944 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Nantucket: Cyrus Peirce   Regular School No Middle 06 08 2018   grade_8 55 13 28 0   1     0   10   50 57                       107.0 55 13 28 0   1     0   10   50 57                 107
2240000 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_8 3 97 8 0   0     0   0   55 53                       108.0 3 97 8 0   0     0   0   55 53                 108
2229248 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_8 101 1 3 0   1     0   3   56 53                       109.0 101 1 3 0   1     0   3   56 53                 109
2238455 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_8 90 3 12 0   2     0   2   56 53                       109.0 90 3 12 0   2     0   2   56 53                 109
2238647 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston: Athol-Royalston Middle School   Regular School No Middle 05 08 2018   grade_8 94 1 7 0   0     0   7   54 55                       109.0 94 1 7 0   0     0   7   54 55                 109
2231755 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_8 11 0 0 0   0     0   0   6 5                       11.0 11 0 0 0   0     0   0   6 5                 11
2232919 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton: Littleton Middle School   Regular School No Middle 06 08 2018   grade_8 96 2 2 0   7     0   3   54 56                       110.0 96 2 2 0   7     0   3   54 56                 110
2239744 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional: Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2018   grade_8 92 0 14 0   1     0   3   52 58                       110.0 92 0 14 0   1     0   3   52 58                 110
2230843 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver: Carver Middle/High School   Regular School No High 06 12 2018   grade_8 105 3 4 0   1     0   0   66 47                       113.0 105 3 4 0   1     0   0   66 47                 113
2232321 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_8 67 20 10 0   7     0   9   57 56                       113.0 67 20 10 0   7     0   9   57 56                 113
2232648 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_8 2 0 111 0   0     0   0   66 47                       113.0 2 0 111 0   0     0   0   66 47                 113
2239305 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba: Hale   Regular School No Middle 06 08 2018   grade_8 106 1 4 0   1     0   1   48 65                       113.0 106 1 4 0   1     0   1   48 65                 113
2233590 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard: Fowler School   Regular School No Middle 04 08 2018   grade_8 92 4 14 1   1     0   2   54 60                       114.0 92 4 14 1   1     0   2   54 60                 114
2230922 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea: Clark Avenue School   Regular School No Middle 05 08 2018   grade_8 1 2 108 0   3     0   1   62 53                       115.0 1 2 108 0   3     0   1   62 53                 115
2232942 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow: Glenbrook Middle   Regular School No Middle 06 08 2018   grade_8 96 3 5 1   6     0   4   59 56                       115.0 96 3 5 1   6     0   4   59 56                 115
2237995 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_8 71 7 22 2   5     1   7   62 53                       115.0 71 7 22 2   5     1   7   62 53                 115
2238590 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Adams-Cheshire: Hoosac Valley High School   Regular School No High 08 12 2018   grade_8 103 7 2 0   2     0   1   61 54                       115.0 103 7 2 0   2     0   1   61 54                 115
2232230 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_8 67 8 38 0   3     0   0   51 65                       116.0 67 8 38 0   3     0   0   51 65                 116
2237011 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater: West Bridgewater Junior/Senior   Regular School No High 07 12 2018   grade_8 107 4 4 0   1     0   0   61 55                       116.0 107 4 4 0   1     0   0   61 55                 116
2234797 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer: Palmer High   Regular School No High 06 12 2018   grade_8 102 2 11 0   1     0   1   60 57                       117.0 102 2 11 0   1     0   1   60 57                 117
2231961 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown: Georgetown Middle School   Regular School No Middle 07 08 2018   grade_8 112 1 2 0   2     0   1   65 53                       118.0 112 1 2 0   2     0   1   65 53                 118
2237169 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport: Westport Junior/Senior High School   Regular School No High 07 12 2018   grade_8 108 0 3 0   2     0   5   62 56                       118.0 108 0 3 0   2     0   5   62 56                 118
2231356 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_8 97 1 15 0   4     0   2   54 65                       119.0 97 1 15 0   4     0   2   54 65                 119
2232678 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_8 5 2 112 0   0     0   0   63 56                       119.0 5 2 112 0   0     0   0   63 56                 119
2239265 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett: Narragansett Middle   Regular School No Middle 05 08 2018   grade_8 105 1 10 0   0     0   3   63 56                       119.0 105 1 10 0   0     0   3   63 56                 119
2239492 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar: Ralph C Mahar Regional   Regular School No High 07 12 2018   grade_8 105 3 3 0   1     0   7   53 66                       119.0 105 3 3 0   1     0   7   53 66                 119
2239713 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett: Central Tree Middle   Regular School No Middle 06 08 2018   grade_8 107 1 4 0   1     1   5   65 54                       119.0 107 1 4 0   1     1   5   65 54                 119
2230963 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee: Chicopee Academy   Alternative School No High 06 12 2018   grade_8 3 0 9 0   0     0   0   6 6                       12.0 3 0 9 0   0     0   0   6 6                 12
2231238 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas: Douglas Middle School   Regular School No Middle 06 08 2018   grade_8 111 0 4 0   2     1   2   66 54                       120.0 111 0 4 0   2     1   2   66 54                 120
2235187 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Quincy: Broad Meadows Middle   Regular School No Middle 06 08 2018   grade_8 81 9 7 0   20     0   3   69 51                       120.0 81 9 7 0   20     0   3   69 51                 120
2238166 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_8 23 62 28 0   7     0   0   54 66                       120.0 23 62 28 0   7     0   0   54 66                 120
2238689 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_8 103 2 10 1   2     0   2   47 73                       120.0 103 2 10 1   2     0   2   47 73                 120
2238046 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_8 6 28 77 0   4     0   6   61 60                       121.0 6 28 77 0   4     0   6   61 60                 121
2236400 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton: Sutton Middle School   Regular School No Middle 06 08 2018   grade_8 118 0 1 0   1     0   3   58 65                       123.0 118 0 1 0   1     0   3   58 65                 123
2239354 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex: Nissitissit Middle School   Regular School No Middle 05 08 2018   grade_8 110 2 5 0   2     0   4   58 65                       123.0 110 2 5 0   2     0   4   58 65                 123
2230917 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea: Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2018   grade_8 6 5 111 1   0     0   1   69 55                       124.0 6 5 111 1   0     0   1   69 55                 124
2232954 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow: Williams Middle   Regular School No Middle 06 08 2018   grade_8 108 3 4 0   6     0   3   66 58                       124.0 108 3 4 0   6     0   3   66 58                 124
2230235 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_8 3 71 40 0   2     0   9   82 43                       125.0 3 71 40 0   2     0   9   82 43                 125
2231061 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset: Cohasset Middle/High School   Regular School No High 06 12 2018   grade_8 110 4 3 2   3     0   3   59 66                       125.0 110 4 3 2   3     0   3   59 66                 125
2232688 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_8 12 4 105 0   3     0   1   66 59                       125.0 12 4 105 0   3     0   1   66 59                 125
2238180 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_8 42 65 6 0   9     0   3   54 71                       125.0 42 65 6 0   9     0   3   54 71                 125
2239553 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District: Southwick Regional School   Regular School No High 07 12 2018   grade_8 119 3 3 0   0     0   1   59 67                       126.0 119 3 3 0   0     0   1   59 67                 126
2232626 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_8 2 2 122 0   2     0   0   59 69                       128.0 2 2 122 0   2     0   0   59 69                 128
2238140 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_8 30 34 49 0   4     0   11   57 71                       128.0 30 34 49 0   4     0   11   57 71                 128
2229661 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston: John W McCormack   Regular School No Middle 06 08 2018   grade_8 3 34 82 0   10     0   0   68 61                       129.0 3 34 82 0   10     0   0   68 61                 129
2231499 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_8 15 20 90 2   2     0   0   61 68                       129.0 15 20 90 2   2     0   0   61 68                 129
2233740 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen: Marsh Grammar School   Regular School No Elementary PK 08 2018   grade_8 95 2 26 0   2     0   4   67 62                       129.0 95 2 26 0   2     0   4   67 62                 129
2231652 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_8 8 1 3 0   0     0   1   6 7                       13.0 8 1 3 0   0     0   1   6 7                 13
2233324 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_8 3 0 9 0   0     0   1   10 3                       13.0 3 0 9 0   0     0   1   10 3                 13
2232098 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield: Greenfield High   Regular School No High 08 12 2018   grade_8 93 3 20 0   3     0   11   70 60                       130.0 93 3 20 0   3     0   11   70 60                 130
2233558 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   grade_8 105 4 4 6   3     1   7   71 59                       130.0 105 4 4 6   3     1   7   71 59                 130
2239139 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_8 124 0 2 0   3     0   1   65 65                       130.0 124 0 2 0   3     0   1   65 65                 130
2231042 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton: Clinton Middle School   Regular School No Middle 04 08 2018   grade_8 93 5 29 0   1     0   3   73 58                       131.0 93 5 29 0   1     0   3   73 58                 131
2239343 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex: Hawthorne Brook   Regular School No Middle 05 08 2018   grade_8 118 1 6 0   2     1   3   61 70                       131.0 118 1 6 0   2     1   3   61 70                 131
2232218 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   grade_8 100 7 22 0   1     0   2   63 69                       132.0 100 7 22 0   1     0   2   63 69                 132
2235899 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley: Michael E. Smith Middle School   Regular School No Middle 05 08 2018   grade_8 102 4 19 0   5     0   3   68 65                       133.0 102 4 19 0   5     0   3   68 65                 133
2239055 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham: Miles River Middle   Regular School No Middle 06 08 2018   grade_8 125 1 5 0   2     0   0   71 62                       133.0 125 1 5 0   2     0   0   71 62                 133
2238797 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire: Nessacus Regional Middle School   Regular School No Middle 06 08 2018   grade_8 127 1 1 0   1     0   6   77 59                       136.0 127 1 1 0   1     0   6   77 59                 136
2230073 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston: James P Timilty Middle   Regular School No Middle 06 08 2018   grade_8 5 40 86 0   0     1   5   72 65                       137.0 5 40 86 0   0     1   5   72 65                 137
2234781 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford: Oxford High   Regular School No High 08 12 2018   grade_8 111 4 12 1   1     2   6   61 76                       137.0 111 4 12 1   1     2   6   61 76                 137
2236171 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 Springfield: John F Kennedy Middle   Regular School No Middle 06 08 2018   grade_8 13 28 91 0   2     0   3   72 65                       137.0 13 28 91 0   2     0   3   72 65                 137
2239780 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson: Hanson Middle School   Regular School No Middle 06 08 2018   grade_8 130 2 3 0   0     0   2   69 68                       137.0 130 2 3 0   0     0   2   69 68                 137
2236607 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 Uxbridge: McCloskey Middle School   Regular School No Middle 06 08 2018   grade_8 122 0 8 0   3     0   5   71 67                       138.0 122 0 8 0   3     0   5   71 67                 138
2238036 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_8 6 75 53 0   1     0   3   78 60                       138.0 6 75 53 0   1     0   3   78 60                 138
2234216 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford: Whaling City Junior/Senior High School   Regular School No High 06 12 2018   grade_8 6 3 5 0   0     0   0   11 3                       14.0 6 3 5 0   0     0   0   11 3                 14
2238290 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_8 10 2 1 0   0     0   1   5 9                       14.0 10 2 1 0   0     0   1   5 9                 14
2230927 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea: Joseph A. Browne School   Regular School No Middle 05 08 2018   grade_8 5 7 122 0   5     0   1   70 70                       140.0 5 7 122 0   5     0   1   70 70                 140
2233086 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell: B.F. Butler Middle School   Regular School No Middle 05 08 2018   grade_8 48 10 31 0   41     0   10   71 69                       140.0 48 10 31 0   41     0   10   71 69                 140
2233848 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury: Millbury Junior/Senior High   Regular School No High 07 12 2018   grade_8 108 5 15 0   6     0   6   73 67                       140.0 108 5 15 0   6     0   6   73 67                 140
2229049 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_8 95 9 25 0   5     0   7   77 64                       141.0 95 9 25 0   5     0   7   77 64                 141
2231524 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven: Hastings Middle   Regular School No Middle 06 08 2018   grade_8 127 1 7 0   3     0   4   72 70                       142.0 127 1 7 0   3     0   4   72 70                 142
2239201 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District: Monomoy Regional High School   Regular School No High 08 12 2018   grade_8 114 4 13 2   2     1   6   73 69                       142.0 114 4 13 2   2     1   6   73 69                 142
2228923 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_8 85 3 11 0   42     0   2   77 66                       143.0 85 3 11 0   42     0   2   77 66                 143
2229054 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_8 95 10 24 1   9     1   3   81 62                       143.0 95 10 24 1   9     1   3   81 62                 143
2232259 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_8 96 6 37 0   2     1   1   69 74                       143.0 96 6 37 0   2     1   1   69 74                 143
2233751 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen: Comprehensive Grammar School   Regular School No Elementary PK 08 2018   grade_8 92 0 39 0   9     0   5   83 62                       145.0 92 0 39 0   9     0   5   83 62                 145
2238860 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth: Dorothy L Beckwith   Regular School No Middle 05 08 2018   grade_8 136 1 6 1   1     0   0   74 71                       145.0 136 1 6 1   1     0   0   74 71                 145
2233412 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden: Salemwood   Regular School No Elementary KG 08 2018   grade_8 30 38 48 1   24     0   5   77 69                       146.0 30 38 48 1   24     0   5   77 69                 146
2232631 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_8 10 5 131 0   0     0   1   81 66                       147.0 10 5 131 0   0     0   1   81 66                 147
2233163 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg: Lunenburg Middle School   Regular School No Middle 06 08 2018   grade_8 122 4 13 2   2     3   1   80 67                       147.0 122 4 13 2   2     3   1   80 67                 147
2234209 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford: Trinity Day Academy   Regular School No High 06 12 2018   grade_8 7 1 5 0   0     0   2   11 4                       15.0 7 1 5 0   0     0   2   11 4                 15
2233988 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick: J F Kennedy Middle School   Regular School No Middle 05 08 2018   grade_8 122 4 5 0   12     0   7   78 72                       150.0 122 4 5 0   12     0   7   78 72                 150
2235881 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge: Southbridge Middle School   Regular School No Middle 06 08 2018   grade_8 52 1 92 1   0     0   4   84 66                       150.0 52 1 92 1   0     0   4   84 66                 150

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