Data source: Big Local News · About: Big Local

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

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
2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2231643 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_6 * * * *   *     *   *   * *                       0.0                                             0
2232021 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2237227 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2232133 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   8 2                       10.0 10 0 0 0   0     0   0   8 2                 10
2235099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_6 5 3 1 0   0     0   1   6 4                       10.0 5 3 1 0   0     0   1   6 4                 10
2235441 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe: Rowe Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2239239 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail: Sanderson Academy   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2236149 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_6 16 23 55 0   2     0   4   53 47                       100.0 16 23 55 0   2     0   4   53 47                 100
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
2236192 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield: Chestnut Academy   Regular School No Middle 06 08 2018   grade_6 5 9 84 0   0     0   3   47 54                       101.0 5 9 84 0   0     0   3   47 54                 101
2230063 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_6 7 13 69 0   11     0   2   61 41                       102.0 7 13 69 0   11     0   2   61 41                 102
2230071 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston: James P Timilty Middle   Regular School No Middle 06 08 2018   grade_6 0 31 67 0   2     0   2   43 59                       102.0 0 31 67 0   2     0   2   43 59                 102
2233398 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden: Linden   Regular School No Elementary KG 08 2018   grade_6 44 19 14 1   21     0   3   55 47                       102.0 44 19 14 1   21     0   3   55 47                 102
2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
2233368 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_6 28 17 12 0   44     1   1   56 47                       103.0 28 17 12 0   44     1   1   56 47                 103
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
2231354 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_6 86 0 10 0   6     0   2   46 58                       104.0 86 0 10 0   6     0   2   46 58                 104
2239303 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba: Hale   Regular School No Middle 06 08 2018   grade_6 101 0 0 0   1     0   2   47 57                       104.0 101 0 0 0   1     0   2   47 57                 104
2233862 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis: Millis Middle   Regular School No Middle 05 08 2018   grade_6 81 1 12 0   5     0   6   58 47                       105.0 81 1 12 0   5     0   6   58 47                 105
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
2230310 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_6 98 0 3 0   4     0   1   42 64                       106.0 98 0 3 0   4     0   1   42 64                 106
2233812 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton: Howe-Manning   Regular School No Elementary 03 06 2018   grade_6 92 1 2 0   6     0   5   55 51                       106.0 92 1 2 0   6     0   5   55 51                 106
2232319 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_6 65 18 12 0   3     0   9   56 51                       107.0 65 18 12 0   3     0   9   56 51                 107
2234795 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer: Palmer High   Regular School No High 06 12 2018   grade_6 85 1 10 0   4     0   7   49 58                       107.0 85 1 10 0   4     0   7   49 58                 107
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
2230013 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_6 2 72 27 2   0     0   5   54 54                       108.0 2 72 27 2   0     0   5   54 54                 108
2232952 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow: Williams Middle   Regular School No Middle 06 08 2018   grade_6 87 1 7 0   10     0   3   49 59                       108.0 87 1 7 0   10     0   3   49 59                 108
2235001 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Plainville: Beatrice H Wood Elementary   Regular School No Middle 04 06 2018   grade_6 91 2 9 1   5     0   0   51 57                       108.0 91 2 9 1   5     0   0   51 57                 108
2236196 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Springfield: Impact Prep at Chestnut   Regular School No Middle 06 07 2018   grade_6 4 20 84 0   0     0   1   56 53                       109.0 4 20 84 0   0     0   1   56 53                 109
2232699 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_6 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2239011 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague: Gill Elementary   Regular School No Elementary KG 06 2018   grade_6 9 0 0 0   0     0   2   6 5                       11.0 9 0 0 0   0     0   2   6 5                 11
2232041 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 89 1 6 2   7     2   3   63 47                       110.0 89 1 6 2   7     2   3   63 47                 110
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
2238853 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth: Dighton Middle School   Regular School No Middle 05 08 2018   grade_6 98 2 4 0   2     0   4   60 50                       110.0 98 2 4 0   2     0   4   60 50                 110
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
2229442 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   grade_6 16 25 64 0   3     0   3   52 59                       111.0 16 25 64 0   3     0   3   52 59                 111
2232646 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_6 7 1 103 0   0     0   0   58 53                       111.0 7 1 103 0   0     0   0   58 53                 111
2236398 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton: Sutton Middle School   Regular School No Middle 06 08 2018   grade_6 102 2 2 0   2     0   3   55 56                       111.0 102 2 2 0   2     0   3   55 56                 111
2230233 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_6 1 58 43 0   6     0   4   57 55                       112.0 1 58 43 0   6     0   4   57 55                 112
2230438 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_6 20 69 17 0   0     1   6   56 57                       113.0 20 69 17 0   0     1   6   56 57                 113
2231488 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett: Lafayette School   Regular School No Elementary KG 08 2018   grade_6 25 22 53 1   6     0   6   48 65                       113.0 25 22 53 1   6     0   6   48 65                 113
2231497 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_6 15 23 72 0   3     0   0   54 59                       113.0 15 23 72 0   3     0   0   54 59                 113
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
2232940 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow: Glenbrook Middle   Regular School No Middle 06 08 2018   grade_6 79 5 8 0   17     0   5   55 59                       114.0 79 5 8 0   17     0   5   55 59                 114
2233942 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Nantucket: Cyrus Peirce   Regular School No Middle 06 08 2018   grade_6 69 11 30 0   2     0   2   54 60                       114.0 69 11 30 0   2     0   2   54 60                 114
2236776 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware: Ware Middle School   Regular School No Middle 04 06 2018   grade_6 99 3 6 0   0     1   6   51 64                       115.0 99 3 6 0   0     1   6   51 64                 115
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
2239053 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham: Miles River Middle   Regular School No Middle 06 08 2018   grade_6 99 2 5 0   6     1   3   42 74                       116.0 99 2 5 0   6     1   3   42 74                 116
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
2229659 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston: John W McCormack   Regular School No Middle 06 08 2018   grade_6 7 34 65 0   5     0   7   70 48                       118.0 7 34 65 0   5     0   7   70 48                 118
2232624 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_6 2 4 111 0   1     0   0   56 62                       118.0 2 4 111 0   1     0   0   56 62                 118
2233749 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen: Comprehensive Grammar School   Regular School No Elementary PK 08 2018   grade_6 68 2 36 0   7     0   5   56 62                       118.0 68 2 36 0   7     0   5   56 62                 118
2239263 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett: Narragansett Middle   Regular School No Middle 05 08 2018   grade_6 113 0 2 0   0     0   3   61 57                       118.0 113 0 2 0   0     0   3   61 57                 118
2231059 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset: Cohasset Middle/High School   Regular School No High 06 12 2018   grade_6 109 3 3 0   3     0   1   64 55                       119.0 109 3 3 0   3     0   1   64 55                 119
2238924 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_6 11 0 0 0   0     0   1   7 5                       12.0 11 0 0 0   0     0   1   7 5                 12
2236199 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield: Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2018   grade_6 16 24 77 0   2     0   1   57 63                       120.0 16 24 77 0   2     0   1   57 63                 120
2236591 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough: Tyngsborough Middle   Regular School No Middle 06 08 2018   grade_6 98 4 6 1   8     0   3   58 62                       120.0 98 4 6 1   8     0   3   58 62                 120
2229605 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_6 25 39 44 0   9     0   4   66 55                       121.0 25 39 44 0   9     0   4   66 55                 121
2231459 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_6 46 11 53 2   6     1   2   61 60                       121.0 46 11 53 2   6     1   2   61 60                 121
2234376 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk: Freeman-Kennedy School   Regular School No Elementary 03 06 2018   grade_6 110 2 3 0   0     0   6   70 51                       121.0 110 2 3 0   0     0   6   70 51                 121
2239711 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett: Central Tree Middle   Regular School No Middle 06 08 2018   grade_6 105 3 5 0   3     2   3   51 70                       121.0 105 3 5 0   3     2   3   51 70                 121
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
2232686 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_6 13 3 100 0   7     0   0   61 62                       123.0 13 3 100 0   7     0   0   61 62                 123
2232629 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_6 7 0 115 0   0     0   2   55 69                       124.0 7 0 115 0   0     0   2   55 69                 124
2230841 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver: Carver Middle/High School   Regular School No High 06 12 2018   grade_6 119 1 2 0   0     0   3   78 47                       125.0 119 1 2 0   0     0   3   78 47                 125
2239778 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson: Hanson Middle School   Regular School No Middle 06 08 2018   grade_6 117 1 3 0   3     0   1   68 57                       125.0 117 1 3 0   3     0   1   68 57                 125
2229813 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston: William H Ohrenberger   Regular School No Middle 03 08 2018   grade_6 30 31 57 0   2     0   6   65 61                       126.0 30 31 57 0   2     0   6   65 61                 126
2230067 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston: Washington Irving Middle   Regular School No Middle 06 08 2018   grade_6 14 46 57 1   3     0   5   59 67                       126.0 14 46 57 1   3     0   5   59 67                 126
2231469 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett: George Keverian School   Regular School No Elementary KG 08 2018   grade_6 34 19 59 1   12     0   1   66 60                       126.0 34 19 59 1   12     0   1   66 60                 126
2232257 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_6 83 6 32 1   3     0   1   69 57                       126.0 83 6 32 1   3     0   1   69 57                 126
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
2231236 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas: Douglas Middle School   Regular School No Middle 06 08 2018   grade_6 119 1 3 0   2     0   3   80 48                       128.0 119 1 3 0   2     0   3   80 48                 128
2236345 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge: Burgess Elementary   Regular School No Elementary PK 06 2018   grade_6 109 2 9 0   2     0   6   70 58                       128.0 109 2 9 0   2     0   6   70 58                 128
2232047 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 93 3 8 0   22     0   3   67 62                       129.0 93 3 8 0   22     0   3   67 62                 129
2232228 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_6 62 5 56 0   4     1   1   63 66                       129.0 62 5 56 0   4     1   1   63 66                 129
2239352 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex: Nissitissit Middle School   Regular School No Middle 05 08 2018   grade_6 116 3 5 0   3     0   2   75 54                       129.0 116 3 5 0   3     0   2   75 54                 129
2231910 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   grade_6 113 1 6 0   6     1   3   65 65                       130.0 113 1 6 0   6     1   3   65 65                 130
2233652 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 Medford: John J. McGlynn Middle School   Regular School No Middle 06 08 2018   grade_6 59 21 20 1   20     0   9   66 64                       130.0 59 21 20 1   20     0   9   66 64                 130
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
2238720 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville: Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2018   grade_6 115 3 5 1   0     0   6   73 57                       130.0 115 3 5 1   0     0   6   73 57                 130
2238795 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire: Nessacus Regional Middle School   Regular School No Middle 06 08 2018   grade_6 121 0 3 0   1     0   5   69 61                       130.0 121 0 3 0   1     0   5   69 61                 130
2232095 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield: Greenfield Middle   Regular School No Middle 05 07 2018   grade_6 94 2 21 0   4     0   10   69 62                       131.0 94 2 21 0   4     0   10   69 62                 131
2232737 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester: Leicester Middle   Regular School No Middle 06 08 2018   grade_6 103 5 13 0   7     0   4   75 57                       132.0 103 5 13 0   7     0   4   75 57                 132
2236879 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster: Webster Middle School   Regular School No Middle 05 08 2018   grade_6 81 8 29 0   3     0   11   69 63                       132.0 81 8 29 0   3     0   11   69 63                 132
2238747 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham: Raynham Middle School   Regular School No Middle 05 08 2018   grade_6 114 5 4 0   6     0   3   63 69                       132.0 114 5 4 0   6     0   3   63 69                 132
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
2231040 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton: Clinton Middle School   Regular School No Middle 04 08 2018   grade_6 91 2 38 0   2     0   0   69 64                       133.0 91 2 38 0   2     0   0   69 64                 133
2232917 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton: Littleton Middle School   Regular School No Middle 06 08 2018   grade_6 113 6 3 0   6     0   5   54 79                       133.0 113 6 3 0   6     0   5   54 79                 133
2232561 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston: Kingston Intermediate   Regular School No Elementary 03 06 2018   grade_6 125 2 3 1   1     0   2   66 68                       134.0 125 2 3 1   1     0   2   66 68                 134
2235185 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Quincy: Broad Meadows Middle   Regular School No Middle 06 08 2018   grade_6 85 8 12 2   22     0   5   79 55                       134.0 85 8 12 2   22     0   5   79 55                 134
2239341 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex: Hawthorne Brook   Regular School No Middle 05 08 2018   grade_6 116 4 6 0   2     0   6   74 60                       134.0 116 4 6 0   2     0   6   74 60                 134
2236605 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 Uxbridge: McCloskey Middle School   Regular School No Middle 06 08 2018   grade_6 120 1 5 1   4     0   4   74 61                       135.0 120 1 5 1   4     0   4   74 61                 135
2233738 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen: Marsh Grammar School   Regular School No Elementary PK 08 2018   grade_6 80 0 43 0   6     0   7   68 68                       136.0 80 0 43 0   6     0   7   68 68                 136
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
2233084 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell: B.F. Butler Middle School   Regular School No Middle 05 08 2018   grade_6 33 13 52 0   32     0   7   61 76                       137.0 33 13 52 0   32     0   7   61 76                 137
2233410 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden: Salemwood   Regular School No Elementary KG 08 2018   grade_6 29 32 46 0   30     0   1   63 75                       138.0 29 32 46 0   30     0   1   63 75                 138
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
2232545 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich: Ipswich Middle School   Regular School No Middle 06 08 2018   grade_6 125 2 9 0   2     0   3   68 73                       141.0 125 2 9 0   2     0   3   68 73                 141
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

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