Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2020 sorted by rowid descending

View and edit SQL

year

  • 2020 · 572

grade

  • grade_6 · 572
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
1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1374299 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_6 76 10 20 0   6     3   9   66 58 *                     124.0 76 10 20 0   6     3   9   66 58                 124
1374286 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_6 35 5 10 0   3     0   6   31 28 *                     59.0 35 5 10 0   3     0   6   31 28                 59
1374267 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 10 2020   grade_6 26 15 25 0   1     0   0   33 34 *                     67.0 26 15 25 0   1     0   0   33 34                 67
1374258 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 08 2020   grade_6 1 14 71 0   1     1   2   46 44 *                     90.0 1 14 71 0   1     1   2   46 44                 90
1374252 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_6 1 89 9 0   0     0   5   49 55 *                     104.0 1 89 9 0   0     0   5   49 55                 104
1374234 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_6 57 15 40 0   3     1   2   59 59 *                     118.0 57 15 40 0   3     1   2   59 59                 118
1374217 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2020   grade_6 1 44 37 0   1     1   1   50 35 *                     85.0 1 44 37 0   1     1   1   50 35                 85
1374202 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_6 17 26 47 0   25     0   5   50 70 *                     120.0 17 26 47 0   25     0   5   50 70                 120
1374189 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_6 36 32 5 0   0     1   5   40 39 *                     79.0 36 32 5 0   0     1   5   40 39                 79
1374064 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_6 97 2 4 0   1     0   4   53 55 *                     108.0 97 2 4 0   1     0   4   53 55                 108
1374060 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No Middle 06 08 2020   grade_6 167 8 12 2   1     0   7   95 102 *                     197.0 167 8 12 2   1     0   7   95 102                 197
1374035 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 40 0 1 0   0     0   0   24 17 *                     41.0 40 0 1 0   0     0   0   24 17                 41
1374027 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2020   grade_6 51 0 7 0   0     0   1   26 33 *                     59.0 51 0 7 0   0     0   1   26 33                 59
1374012 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2020   grade_6 82 1 6 0   0     0   2   51 40 *                     91.0 82 1 6 0   0     0   2   51 40                 91
1374008 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2020   grade_6 96 3 5 0   4     0   5   58 55 *                     113.0 96 3 5 0   4     0   5   58 55                 113
1374005 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No Middle 06 08 2020   grade_6 215 12 16 0   8     0   7   132 126 *                     258.0 215 12 16 0   8     0   7   132 126                 258
1373999 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_6 39 1 0 0   1     0   3   26 18 *                     44.0 39 1 0 0   1     0   3   26 18                 44
1373990 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2020   grade_6 51 1 6 0   5     0   1   35 29 *                     64.0 51 1 6 0   5     0   1   35 29                 64
1373954 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_6 47 1 3 1   0     0   5   25 32 *                     57.0 47 1 3 1   0     0   5   25 32                 57
1373934 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2020   grade_6 52 1 0 0   2     0   0   25 30 *                     55.0 52 1 0 0   2     0   0   25 30                 55
1373926 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2020   grade_6 49 0 1 0   2     1   1   34 20 *                     54.0 49 0 1 0   2     1   1   34 20                 54
1373918 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2020   grade_6 61 1 5 0   1     0   2   29 41 *                     70.0 61 1 5 0   1     0   2   29 41                 70
1373893 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_6 87 4 16 0   2     0   5   61 53 *                     114.0 87 4 16 0   2     0   5   61 53                 114
1373886 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 25 0 1 0   0     0   2   13 15 *                     28.0 25 0 1 0   0     0   2   13 15                 28
1373872 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_6 104 6 6 0   1     0   4   56 65 *                     121.0 104 6 6 0   1     0   4   56 65                 121
1373858 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_6 35 0 2 0   0     0   2   21 18 *                     39.0 35 0 2 0   0     0   2   21 18                 39
1373818 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_6 57 0 5 0   1     1   0   37 27 *                     64.0 57 0 5 0   1     1   0   37 27                 64
1373810 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_6 27 0 3 0   0     0   0   16 14 *                     30.0 27 0 3 0   0     0   0   16 14                 30
1373803 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_6 46 0 3 0   0     0   0   19 30 *                     49.0 46 0 3 0   0     0   0   19 30                 49
1373796 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_6 28 0 4 0   0     0   0   21 11 *                     32.0 28 0 4 0   0     0   0   21 11                 32
1373782 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_6 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1373776 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2020   grade_6 22 0 0 0   0     0   0   12 10 *                     22.0 22 0 0 0   0     0   0   12 10                 22
1373768 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2020   grade_6 18 0 0 0   0     0   0   8 10 *                     18.0 18 0 0 0   0     0   0   8 10                 18
1373750 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2020   grade_6 42 0 2 0   2     0   0   19 27 *                     46.0 42 0 2 0   2     0   0   19 27                 46
1373742 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No Elementary 03 06 2020   grade_6 42 0 4 1   0     0   0   24 23 *                     47.0 42 0 4 1   0     0   0   24 23                 47
1373738 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Elmer S Bagnall   Regular School No Elementary PK 06 2020   grade_6 51 0 2 0   0     0   1   32 22 *                     54.0 51 0 2 0   0     0   1   32 22                 54
1373716 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2020   grade_6 110 2 5 0   1     0   8   71 55 *                     126.0 110 2 5 0   1     0   8   71 55                 126
1373707 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_6 123 1 4 0   2     0   4   70 64 *                     134.0 123 1 4 0   2     0   4   70 64                 134
1373688 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2020   grade_6 16 0 3 0   0     0   1   11 9 *                     20.0 16 0 3 0   0     0   1   11 9                 20
1373673 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_6 88 1 3 0   3     0   4   56 43 *                     99.0 88 1 3 0   3     0   4   56 43                 99
1373670 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2020   grade_6 60 0 13 0   0     0   2   39 36 *                     75.0 60 0 13 0   0     0   2   39 36                 75
1373667 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2020   grade_6 70 1 2 0   0     0   6   38 41 *                     79.0 70 1 2 0   0     0   6   38 41                 79
1373638 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 06 08 2020   grade_6 116 2 8 1   2     0   6   77 58 *                     135.0 116 2 8 1   2     0   6   77 58                 135
1373617 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2020   grade_6 11 0 1 0   0     0   1   5 8 *                     13.0 11 0 1 0   0     0   1   5 8                 13
1373609 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2020   grade_6 7 0 3 0   0     0   0   7 3 *                     10.0 7 0 3 0   0     0   0   7 3                 10
1373601 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2020   grade_6 31 0 1 0   0     0   1   16 17 *                     33.0 31 0 1 0   0     0   1   16 17                 33
1373586 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Williamstown Elementary   Regular School No Elementary PK 06 2020   grade_6 44 0 7 0   0     0   1   23 29 *                     52.0 44 0 7 0   0     0   1   23 29                 52
1373578 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2020   grade_6 23 1 0 0   0     0   0   15 9 *                     24.0 23 1 0 0   0     0   0   15 9                 24
1373564 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_6 102 8 9 2   2     0   13   65 71 *                     136.0 102 8 9 2   2     0   13   65 71                 136
1373537 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2020   grade_6 171 0 11 0   6     0   5   110 83 *                     193.0 171 0 11 0   6     0   5   110 83                 193
1373512 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_6 117 0 1 0   0     0   0   61 57 *                     118.0 117 0 1 0   0     0   0   61 57                 118
1373486 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2020   grade_6 7 0 0 0   0     0   1   4 4 *                     8.0 7 0 0 0   0     0   1   4 4                 8
1373464 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2020   grade_6 178 7 20 0   2     0   7   104 110 *                     214.0 178 7 20 0   2     0   7   104 110                 214
1373454 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_6 8 1 3 0   0     0   2   13 1 *                     14.0 8 1 3 0   0     0   2   13 1                 14
1373440 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2020   grade_6 132 1 4 0   4     0   1   71 71 *                     142.0 132 1 4 0   4     0   1   71 71                 142
1373413 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No Middle 06 08 2020   grade_6 43 0 11 0   0     1   5   35 25 *                     60.0 43 0 11 0   0     1   5   35 25                 60
1373405 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2020   grade_6 26 0 0 0   0     0   1   15 12 *                     27.0 26 0 0 0   0     0   1   15 12                 27
1373391 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_6 147 3 5 0   12     0   4   85 86 *                     171.0 147 3 5 0   12     0   4   85 86                 171
1373371 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2020   grade_6 56 2 7 0   0     1   0   33 33 *                     66.0 56 2 7 0   0     1   0   33 33                 66
1373343 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_6 223 4 0 0   2     0   3   121 111 *                     232.0 223 4 0 0   2     0   3   121 111                 232
1373331 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 0 0   0     0   0   11 2 *                     13.0 13 0 0 0   0     0   0   11 2                 13
1373317 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_6 154 7 14 0   5     0   5   95 89 *                     185.0 154 7 14 0   5     0   5   95 89                 185
1373309 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2020   grade_6 164 1 13 1   3     0   3   94 91 *                     185.0 164 1 13 1   3     0   3   94 91                 185
1373305 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2020   grade_6 107 5 15 0   2     0   6   60 75 *                     135.0 107 5 15 0   2     0   6   60 75                 135
1373285 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2020   grade_6 119 7 14 0   28     0   16   93 91 *                     184.0 119 7 14 0   28     0   16   93 91                 184
1373276 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_6 123 2 7 1   2     0   5   69 71 *                     140.0 123 2 7 1   2     0   5   69 71                 140
1373272 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_6 95 2 5 0   1     0   4   62 45 *                     107.0 95 2 5 0   1     0   4   62 45                 107
1373252 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_6 133 29 44 7   4     1   12   119 111 *                     230.0 133 29 44 7   4     1   12   119 111                 230
1373225 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_6 105 0 3 1   0     0   1   55 55 *                     110.0 105 0 3 1   0     0   1   55 55                 110
1373184 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_6 145 15 1 0   5     0   5   92 79 *                     171.0 145 15 1 0   5     0   5   92 79                 171
1373182 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2020   grade_6 217 22 7 0   6     0   8   134 126 *                     260.0 217 22 7 0   6     0   8   134 126                 260
1373163 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2020   grade_6 113 3 11 0   2     0   7   61 75 *                     136.0 113 3 11 0   2     0   7   61 75                 136
1373143 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2020   grade_6 74 1 6 0   5     1   2   44 45 *                     89.0 74 1 6 0   5     1   2   44 45                 89
1373121 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_6 62 0 10 0   3     0   4   42 37 *                     79.0 62 0 10 0   3     0   4   42 37                 79
1373107 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_6 102 8 22 0   4     0   4   72 68 *                     140.0 102 8 22 0   4     0   4   72 68                 140
1373086 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_6 93 0 11 0   1     0   3   63 45 *                     108.0 93 0 11 0   1     0   3   63 45                 108
1373084 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2020   grade_6 13 2 2 0   0     0   1   9 9 *                     18.0 13 2 2 0   0     0   1   9 9                 18
1373064 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2020   grade_6 164 4 18 0   0     0   9   103 92 *                     195.0 164 4 18 0   0     0   9   103 92                 195
1373037 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_6 97 3 2 0   0     0   2   52 52 *                     104.0 97 3 2 0   0     0   2   52 52                 104
1373022 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2020   grade_6 21 4 3 0   41     0   3   35 37 *                     72.0 21 4 3 0   41     0   3   35 37                 72
1373015 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2020   grade_6 16 1 3 0   24     0   1   23 22 *                     45.0 16 1 3 0   24     0   1   23 22                 45
1373008 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2020   grade_6 42 1 6 1   18     0   2   36 34 *                     70.0 42 1 6 1   18     0   2   36 34                 70
1373001 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2020   grade_6 61 3 10 0   9     0   8   47 44 *                     91.0 61 3 10 0   9     0   8   47 44                 91
1372994 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2020   grade_6 54 2 2 0   31     1   1   48 43 *                     91.0 54 2 2 0   31     1   1   48 43                 91
1372987 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2020   grade_6 29 1 2 0   19     0   1   18 34 *                     52.0 29 1 2 0   19     0   1   18 34                 52
1372973 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science East   Regular School Yes High 06 12 2020   grade_6 24 28 32 0   2     0   5   43 48 *                     91.0 24 28 32 0   2     0   5   43 48                 91
1372970 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2020   grade_6 4 19 80 1   3     0   4   49 62 *                     111.0 4 19 80 1   3     0   4   49 62                 111
1372962 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_6 25 13 9 0   13     0   9   36 33 *                     69.0 25 13 9 0   13     0   9   36 33                 69
1372949 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2020   grade_6 38 10 39 0   2     0   4   48 45 *                     93.0 38 10 39 0   2     0   4   48 45                 93
1372941 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2020   grade_6 28 16 16 0   4     0   0   27 37 *                     64.0 28 16 16 0   4     0   0   27 37                 64
1372918 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_6 91 2 15 0   2     0   0   51 59 *                     110.0 91 2 15 0   2     0   0   51 59                 110
1372901 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2020   grade_6 34 29 5 0   4     0   9   44 37 *                     81.0 34 29 5 0   4     0   9   44 37                 81
1372888 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_6 6 56 22 0   6     2   3   46 49 *                     95.0 6 56 22 0   6     2   3   46 49                 95
1372879 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2020   grade_6 5 42 26 0   0     0   2   37 38 *                     75.0 5 42 26 0   0     0   2   37 38                 75
1372866 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes High 06 12 2020   grade_6 28 5 38 0   1     0   1   29 43 *                     73.0 28 5 38 0   1     0   1   29 43                 73
1372859 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_6 2 140 105 1   0     3   0   136 115 *                     251.0 2 140 105 1   0     3   0   136 115                 251
1372851 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2020   grade_6 77 0 5 0   1     0   9   40 52 *                     92.0 77 0 5 0   1     0   9   40 52                 92
1372847 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_6 29 1 3 1   0     0   0   11 23 *                     34.0 29 1 3 1   0     0   0   11 23                 34
1372840 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2020   grade_6 1 51 19 0   1     0   5   34 43 *                     77.0 1 51 19 0   1     0   5   34 43                 77

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