Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by rowid descending

View and edit SQL

year

grade

  • grade_6 · 4,038
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
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
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
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
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
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
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
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
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
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
2239774 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson: Whitman Middle   Regular School No Middle 06 08 2018   grade_6 151 9 12 2   1     0   6   100 81                       181.0 151 9 12 2   1     0   6   100 81                 181
2239741 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional: West Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_6 39 0 1 0   0     0   1   23 18                       41.0 39 0 1 0   0     0   1   23 18                 41
2239732 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional: Warren Elementary   Regular School No Elementary PK 06 2018   grade_6 53 1 7 0   0     0   2   34 29                       63.0 53 1 7 0   0     0   2   34 29                 63
2239716 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   grade_6 88 0 4 0   1     0   2   43 52                       95.0 88 0 4 0   1     0   2   43 52                 95
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
2239707 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Wachusett: Mountview Middle   Regular School No Middle 06 08 2018   grade_6 247 3 14 1   11     0   5   131 150                       281.0 247 3 14 1   11     0   5   131 150                 281
2239699 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett: Thomas Prince   Regular School No Elementary KG 08 2018   grade_6 45 0 4 0   1     0   0   20 30                       50.0 45 0 4 0   1     0   0   20 30                 50
2239689 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett: Paxton Center   Regular School No Elementary KG 08 2018   grade_6 59 1 4 0   0     0   2   36 30                       66.0 59 1 4 0   0     0   2   36 30                 66
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
2239622 MA Essex   school 2511740 773   Triton 251174001651 7730025 Triton: Pine Grove   Regular School No Elementary PK 06 2018   grade_6 55 0 0 0   0     0   2   31 26                       57.0 55 0 0 0   0     0   2   31 26                 57
2239613 MA Essex   school 2511740 773   Triton 251174001348 7730020 Triton: Newbury Elementary   Regular School No Elementary PK 06 2018   grade_6 70 1 0 0   1     0   1   37 36                       73.0 70 1 0 0   1     0   1   37 36                 73
2239604 MA Essex   school 2511740 773   Triton 251174001669 7730015 Triton: Salisbury Elementary   Regular School No Elementary PK 06 2018   grade_6 52 0 2 0   2     0   1   26 31                       57.0 52 0 2 0   2     0   1   26 31                 57
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
2239533 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire: Undermountain   Regular School No Elementary PK 06 2018   grade_6 42 0 1 0   0     0   2   17 28                       45.0 42 0 1 0   0     0   2   17 28                 45
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
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
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
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
2239437 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Pioneer Valley: Warwick Community School   Regular School No Elementary PK 06 2018   grade_6 7 0 0 0   0     0   0   4 3                       7.0 7 0 0 0   0     0   0   4 3                 7
2239428 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley: Northfield Elementary   Regular School No Elementary PK 06 2018   grade_6 27 0 1 0   0     0   3   15 16                       31.0 27 0 1 0   0     0   3   15 16                 31
2239419 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pioneer Valley: Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2239413 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley: Bernardston Elementary   Regular School No Elementary PK 06 2018   grade_6 23 1 0 0   0     0   2   14 12                       26.0 23 1 0 0   0     0   2   14 12                 26
2239391 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Pentucket: Dr John C Page School   Regular School No Elementary PK 06 2018   grade_6 41 0 0 0   2     0   0   17 26                       43.0 41 0 0 0   2     0   0   17 26                 43
2239382 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Pentucket: Helen R Donaghue School   Regular School No Elementary 03 06 2018   grade_6 66 0 5 0   1     0   0   33 39                       72.0 66 0 5 0   1     0   0   33 39                 72
2239377 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Pentucket: Elmer S Bagnall   Regular School No Elementary PK 06 2018   grade_6 70 0 3 0   0     0   0   40 33                       73.0 70 0 3 0   0     0   0   40 33                 73
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
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
2239319 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell: Swift River   Regular School No Elementary PK 06 2018   grade_6 16 0 2 0   0     0   0   7 11                       18.0 16 0 2 0   0     0   0   7 11                 18
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
2239299 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba: Luther Burbank Middle School   Regular School No Middle 06 08 2018   grade_6 81 1 5 0   2     0   4   50 43                       93.0 81 1 5 0   2     0   4   50 43                 93
2239295 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba: Florence Sawyer School   Regular School No Elementary PK 08 2018   grade_6 52 0 2 0   11     0   1   32 34                       66.0 52 0 2 0   11     0   1   32 34                 66
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
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
2239230 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail: Colrain Central   Regular School No Elementary PK 06 2018   grade_6 17 0 2 0   0     0   0   7 12                       19.0 17 0 2 0   0     0   0   7 12                 19
2239221 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Mohawk Trail: Buckland-Shelburne Regional   Regular School No Elementary PK 06 2018   grade_6 18 0 1 0   1     0   0   12 8                       20.0 18 0 1 0   1     0   0   12 8                 20
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
2239167 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton: Miscoe Hill School   Regular School No Middle 05 08 2018   grade_6 162 1 11 0   4     0   11   99 90                       189.0 162 1 11 0   4     0   11   99 90                 189
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
2239107 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_6 14 0 1 0   0     0   2   6 11                       17.0 14 0 1 0   0     0   2   6 11                 17
2239084 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham: Wilbraham Middle   Regular School No Middle 06 08 2018   grade_6 168 6 9 0   4     0   7   91 103                       194.0 168 6 9 0   4     0   7   91 103                 194
2239080 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Hampden-Wilbraham: Thornton Burgess   Regular School No Middle 06 08 2018   grade_6 23 1 3 0   0     0   1   16 12                       28.0 23 1 3 0   0     0   1   16 12                 28
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
2239022 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague: Great Falls Middle   Regular School No Middle 06 08 2018   grade_6 54 0 8 0   0     0   4   30 36                       66.0 54 0 8 0   0     0   4   30 36                 66
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
2238996 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable: Groton Dunstable Regional Middle   Regular School No Middle 05 08 2018   grade_6 188 2 1 1   8     1   4   103 102                       205.0 188 2 1 1   8     1   4   103 102                 205
2238972 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway: Gateway Regional Middle School   Regular School No Middle 06 08 2018   grade_6 61 2 3 0   0     0   1   28 39                       67.0 61 2 3 0   0     0   1   28 39                 67
2238940 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville: Freetown-Lakeville Middle School   Regular School No Middle 06 08 2018   grade_6 251 2 6 1   0     0   4   125 139                       264.0 251 2 6 1   0     0   4   125 139                 264
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
2238908 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset: Nauset Regional Middle   Regular School No Middle 06 08 2018   grade_6 152 8 13 0   5     0   7   88 97                       185.0 152 8 13 0   5     0   7   88 97                 185
2238899 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg: Charlton Middle School   Regular School No Middle 05 08 2018   grade_6 142 1 12 0   1     0   3   81 78                       159.0 142 1 12 0   1     0   3   81 78                 159
2238894 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg: Dudley Middle School   Regular School No Middle 05 08 2018   grade_6 121 2 14 0   3     0   5   66 79                       145.0 121 2 14 0   3     0   5   66 79                 145
2238868 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn: Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2018   grade_6 132 3 6 0   19     0   8   93 75                       168.0 132 3 6 0   19     0   8   93 75                 168
2238858 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth: Dorothy L Beckwith   Regular School No Middle 05 08 2018   grade_6 139 0 6 0   3     0   6   82 72                       154.0 139 0 6 0   3     0   6   82 72                 154
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
2238830 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_6 150 18 34 5   4     0   14   107 118                       225.0 150 18 34 5   4     0   14   107 118                 225
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
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
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
2238744 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_6 215 16 0 0   1     0   16   146 102                       248.0 215 16 0 0   1     0   16   146 102                 248
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
2238696 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston: Tahanto Regional High   Regular School No High 06 12 2018   grade_6 82 2 4 0   4     0   3   55 40                       95.0 82 2 4 0   4     0   3   55 40                 95
2238687 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_6 58 2 3 0   6     0   6   43 32                       75.0 58 2 3 0   6     0   6   43 32                 75
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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