Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2016 sorted by rowid descending

View and edit SQL

year

  • 2016 · 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
942028 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_6 27 6 4 0   4     0   11   23 29                       52 27 6 4 0   4     0   11   23 29                 52
942015 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_6 38 11 8 1   3     0   1   39 23                       62 38 11 8 1   3     0   1   39 23                 62
941999 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 07 2016   grade_6 75 5 14 1   1     1   5   52 50                       102 75 5 14 1   1     1   5   52 50                 102
941986 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 07 2016   grade_6 8 46 21 2   0     0   0   30 47                       77 8 46 21 2   0     0   0   30 47                 77
941966 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 09 2016   grade_6 6 24 51 0   1     0   0   42 40                       82 6 24 51 0   1     0   0   42 40                 82
941840 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_6 136 3 1 0   0     0   3   71 72                       143 136 3 1 0   0     0   3   71 72                 143
941837 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2016   grade_6 175 5 7 0   2     0   2   111 80                       191 175 5 7 0   2     0   2   111 80                 191
941811 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 40 0 1 0   0     0   2   21 22                       43 40 0 1 0   0     0   2   21 22                 43
941803 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No 1 PK 06 2016   grade_6 67 0 6 0   0     0   0   33 40                       73 67 0 6 0   0     0   0   33 40                 73
941788 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2016   grade_6 92 3 3 0   2     0   0   56 44                       100 92 3 3 0   2     0   0   56 44                 100
941784 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2016   grade_6 105 1 4 0   0     0   5   65 50                       115 105 1 4 0   0     0   5   65 50                 115
941781 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2016   grade_6 212 7 14 0   9     0   8   133 117                       250 212 7 14 0   9     0   8   133 117                 250
941775 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2016   grade_6 43 0 4 0   2     0   0   25 24                       49 43 0 4 0   2     0   0   25 24                 49
941766 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2016   grade_6 55 0 5 0   2     0   0   39 23                       62 55 0 5 0   2     0   0   39 23                 62
941730 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   grade_6 41 2 1 2   1     0   2   36 13                       49 41 2 1 2   1     0   2   36 13                 49
941709 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No 1 PK 06 2016   grade_6 62 1 0 0   1     0   0   27 37                       64 62 1 0 0   1     0   0   27 37                 64
941701 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No 1 PK 06 2016   grade_6 71 1 2 0   2     1   0   38 39                       77 71 1 2 0   2     1   0   38 39                 77
941693 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No 1 PK 06 2016   grade_6 58 1 2 0   2     0   4   38 29                       67 58 1 2 0   2     0   4   38 29                 67
941667 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No 2 05 08 2016   grade_6 74 0 9 0   1     0   4   43 45                       88 74 0 9 0   1     0   4   43 45                 88
941660 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No 1 PK 06 2016   grade_6 20 0 1 0   0     0   2   12 11                       23 20 0 1 0   0     0   2   12 11                 23
941646 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No 1 03 06 2016   grade_6 107 4 2 0   0     0   2   56 59                       115 107 4 2 0   0     0   2   56 59                 115
941642 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No 1 KG 06 2016   grade_6 14 0 0 0   0     0   0   7 7                       14 14 0 0 0   0     0   0   7 7                 14
941626 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2016   grade_6 49 1 1 1   0     0   2   31 23                       54 49 1 1 1   0     0   2   31 23                 54
941579 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No 1 KG 06 2016   grade_6 57 0 3 0   0     0   1   25 36                       61 57 0 3 0   0     0   1   25 36                 61
941572 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2016   grade_6 39 0 4 0   1     0   0   23 21                       44 39 0 4 0   1     0   0   23 21                 44
941564 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No 1 KG 06 2016   grade_6 39 0 1 0   0     0   0   19 21                       40 39 0 1 0   0     0   0   19 21                 40
941557 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No 1 KG 06 2016   grade_6 35 0 2 0   0     0   0   24 13                       37 35 0 2 0   0     0   0   24 13                 37
941544 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
941536 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No 1 PK 06 2016   grade_6 24 0 0 0   0     0   3   17 10                       27 24 0 0 0   0     0   3   17 10                 27
941528 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   4 1                       5                         4 1                 5
941521 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No 1 PK 06 2016   grade_6 23 0 0 0   0     0   1   13 11                       24 23 0 0 0   0     0   1   13 11                 24
941503 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No 1 PK 06 2016   grade_6 54 0 0 0   3     0   0   29 28                       57 54 0 0 0   3     0   0   29 28                 57
941495 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No 1 03 06 2016   grade_6 68 0 6 0   2     0   3   47 32                       79 68 0 6 0   2     0   3   47 32                 79
941491 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Elmer S Bagnall   Regular School No 1 PK 06 2016   grade_6 88 0 2 0   2     0   0   49 43                       92 88 0 2 0   2     0   0   49 43                 92
941470 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2016   grade_6 115 0 5 0   0     0   5   60 65                       125 115 0 5 0   0     0   5   60 65                 125
941461 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2016   grade_6 125 0 7 0   2     0   4   63 75                       138 125 0 7 0   2     0   4   63 75                 138
941443 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No 1 PK 06 2016   grade_6 15 0 0 0   0     0   0   8 7                       15 15 0 0 0   0     0   0   8 7                 15
941428 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2016   grade_6 106 1 4 0   2     0   0   47 66                       113 106 1 4 0   2     0   0   47 66                 113
941425 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2016   grade_6 70 2 2 0   0     2   1   31 46                       77 70 2 2 0   0     2   1   31 46                 77
941422 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_6 86 0 4 0   3     0   3   41 55                       96 86 0 4 0   3     0   3   41 55                 96
941394 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_6 100 2 4 0   0     1   1   56 52                       108 100 2 4 0   0     1   1   56 52                 108
941375 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No 1 PK 06 2016   grade_6 24 0 0 0   0     0   0   10 14                       24 24 0 0 0   0     0   0   10 14                 24
941367 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 1                       3                         2 1                 3
941360 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No 1 PK 06 2016   grade_6 12 0 0 0   0     0   0   7 5                       12 12 0 0 0   0     0   0   7 5                 12
941352 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No 1 PK 06 2016   grade_6 28 0 1 0   0     0   0   11 18                       29 28 0 1 0   0     0   0   11 18                 29
941331 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2016   grade_6 113 2 10 2   3     1   7   71 67                       138 113 2 10 2   3     1   7   71 67                 138
941304 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 04 08 2016   grade_6 183 2 12 0   5     0   1   105 98                       203 183 2 12 0   5     0   1   105 98                 203
941279 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2016   grade_6 126 0 3 0   3     0   1   65 68                       133 126 0 3 0   3     0   1   65 68                 133
941254 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No 1 PK 06 2016   grade_6 13 0 0 0   0     0   2   9 6                       15 13 0 0 0   0     0   2   9 6                 15
941233 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No 2 06 08 2016   grade_6 169 5 10 0   4     0   10   93 105                       198 169 5 10 0   4     0   10   93 105                 198
941230 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No 2 05 08 2016   grade_6 48 5 3 0   2     0   0   27 31                       58 48 5 3 0   2     0   0   27 31                 58
941209 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No 2 06 08 2016   grade_6 126 0 6 0   2     0   0   73 61                       134 126 0 6 0   2     0   0   73 61                 134
941182 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No 2 06 08 2016   grade_6 58 1 5 1   0     0   4   38 31                       69 58 1 5 1   0     0   4   38 31                 69
941174 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No 1 KG 06 2016   grade_6 11 0 0 0   0     0   0   1 10                       11 11 0 0 0   0     0   0   1 10                 11
941160 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2016   grade_6 169 1 4 0   20     0   4   99 99                       198 169 1 4 0   20     0   4   99 99                 198
941142 MA Hampshire   school 2505160 672   Gateway 250516002666 6720410 Gateway Regional Middle School   Regular School No 2 05 06 2016   grade_6 63 0 5 0   0     0   1   42 27                       69 63 0 5 0   0     0   1   42 27                 69
941113 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2016   grade_6 212 5 9 2   2     1   5   117 119                       236 212 5 9 2   2     1   5   117 119                 236
941101 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2016   grade_6 16 0 0 0   0     0   1   7 10                       17 16 0 0 0   0     0   1   7 10                 17
941086 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2016   grade_6 152 3 6 0   2     1   5   94 75                       169 152 3 6 0   2     1   5   94 75                 169
941079 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2016   grade_6 165 3 4 0   3     0   2   97 80                       177 165 3 4 0   3     0   2   97 80                 177
941075 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2016   grade_6 138 2 13 0   2     0   2   77 80                       157 138 2 13 0   2     0   2   77 80                 157
941055 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No 2 06 08 2016   grade_6 137 5 8 0   16     0   7   88 85                       173 137 5 8 0   16     0   7   88 85                 173
941046 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No 2 05 08 2016   grade_6 139 2 7 0   1     0   0   75 74                       149 139 2 7 0   1     0   0   75 74                 149
941042 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2016   grade_6 78 1 2 0   1     0   1   46 37                       83 78 1 2 0   1     0   1   46 37                 83
941024 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2016   grade_6 163 28 27 5   3     0   11   119 118                       237 163 28 27 5   3     0   11   119 118                 237
940997 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2016   grade_6 114 2 3 0   1     0   5   69 56                       125 114 2 3 0   1     0   5   69 56                 125
940975 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No 1 PK 06 2016   grade_6 24 0 0 0   1     0   1   9 17                       26 24 0 0 0   1     0   1   9 17                 26
940958 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2016   grade_6 168 1 5 0   1     0   10   99 86                       185 168 1 5 0   1     0   10   99 86                 185
940956 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No 2 04 06 2016   grade_6 226 7 8 0   2     0   13   151 105                       256 226 7 8 0   2     0   13   151 105                 256
940936 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2016   grade_6 127 1 7 0   2     0   5   66 76                       142 127 1 7 0   2     0   5   66 76                 142
940916 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_6 80 1 3 0   2     0   1   52 35                       87 80 1 3 0   2     0   1   52 35                 87
940908 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_6 86 1 9 1   1     0   2   35 65                       100 86 1 9 1   1     0   2   35 65                 100
940894 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2016   grade_6 97 5 10 1   2     1   7   53 70                       123 97 5 10 1   2     1   7   53 70                 123
940872 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_6 84 2 5 1   0     0   2   47 47                       94 84 2 5 1   0     0   2   47 47                 94
940870 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No 1 KG 06 2016   grade_6 16 0 2 0   0     0   0   11 7                       18 16 0 2 0   0     0   0   11 7                 18
940845 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2016   grade_6 171 0 5 0   1     0   1   99 79                       178 171 0 5 0   1     0   1   99 79                 178
940817 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_6 98 5 1 0   1     0   0   54 51                       105 98 5 1 0   1     0   0   54 51                 105
940797 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2016   grade_6 26 0 1 0   45     0   2   33 41                       74 26 0 1 0   45     0   2   33 41                 74
940790 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No 1 KG 06 2016   grade_6 40 1 1 0   30     0   2   38 36                       74 40 1 1 0   30     0   2   38 36                 74
940783 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No 1 KG 06 2016   grade_6 48 0 1 0   12     0   13   43 31                       74 48 0 1 0   12     0   13   43 31                 74
940776 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No 1 KG 06 2016   grade_6 52 1 8 0   6     0   5   35 37                       72 52 1 8 0   6     0   5   35 37                 72
940769 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No 1 PK 06 2016   grade_6 60 0 4 0   28     0   2   45 49                       94 60 0 4 0   28     0   2   45 49                 94
940761 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No 1 PK 06 2016   grade_6 36 3 2 0   22     0   2   34 31                       65 36 3 2 0   22     0   2   34 31                 65
940747 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2016   grade_6 44 23 15 0   3     0   1   38 48                       86 44 23 15 0   3     0   1   38 48                 86
940744 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes 2 05 08 2016   grade_6 5 18 56 0   0     0   0   34 45                       79 5 18 56 0   0     0   0   34 45                 79
940737 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_6 36 2 2 0   10     0   7   27 30                       57 36 2 2 0   10     0   7   27 30                 57
940724 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_6 45 12 21 0   2     0   6   46 40                       86 45 12 21 0   2     0   6   46 40                 86
940702 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_6 85 4 7 0   2     0   2   49 51                       100 85 4 7 0   2     0   2   49 51                 100
940685 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2016   grade_6 32 10 0 0   1     0   2   27 18                       45 32 10 0 0   1     0   2   27 18                 45
940672 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_6 9 64 18 0   5     0   1   41 56                       97 9 64 18 0   5     0   1   41 56                 97
940663 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2016   grade_6 5 29 36 0   0     0   4   42 32                       74 5 29 36 0   0     0   4   42 32                 74
940650 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_6 34 10 23 0   5     0   0   27 45                       72 34 10 23 0   5     0   0   27 45                 72
940646 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_6 1 129 115 0   1     0   2   127 121                       248 1 129 115 0   1     0   2   127 121                 248
940638 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2016   grade_6 81 1 0 0   3     0   4   50 39                       89 81 1 0 0   3     0   4   50 39                 89
940634 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2016   grade_6 31 0 0 0   0     0   1   11 21                       32 31 0 0 0   0     0   1   11 21                 32
940627 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_6 1 50 33 0   3     0   1   43 45                       88 1 50 33 0   3     0   1   43 45                 88
940617 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2016   grade_6 11 83 60 1   11     2   7   93 82                       175 11 83 60 1   11     2   7   93 82                 175
940596 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2016   grade_6 0 23 15 0   0     0   0   22 16                       38 0 23 15 0   0     0   0   22 16                 38
940581 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_6 72 16 5 0   14     0   6   54 59                       113 72 16 5 0   14     0   6   54 59                 113
940568 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   grade_6 3 36 52 0   1     0   1   45 48                       93 3 36 52 0   1     0   1   45 48                 93

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