Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by rowid descending

View and edit SQL

year

grade

  • grade_5 · 6,218
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
2240029 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_5 24 9 10 0   0     0   3   25 21                       46.0 24 9 10 0   0     0   3   25 21                 46
2240015 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_5 18 5 5 1   2     0   8   20 19                       39.0 18 5 5 1   2     0   8   20 19                 39
2239996 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School (District): Bentley Academy Charter School   Regular School Yes Elementary KG 05 2018   grade_5 9 6 18 0   2     0   1   20 16                       36.0 9 6 18 0   2     0   1   20 16                 36
2239959 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_5 2 49 37 0   0     0   2   46 44                       90.0 2 49 37 0   0     0   2   46 44                 90
2239944 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_5 12 18 31 0   26     0   6   48 45                       93.0 12 18 31 0   26     0   6   48 45                 93
2239772 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson: Indian Head   Regular School No Elementary 03 05 2018   grade_5 101 1 6 1   2     0   1   55 57                       112.0 101 1 6 1   2     0   1   55 57                 112
2239768 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 Whitman-Hanson: John H Duval   Regular School No Elementary KG 05 2018   grade_5 78 0 9 0   1     0   2   41 49                       90.0 78 0 9 0   1     0   2   41 49                 90
2239756 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Whitman-Hanson: Louise A Conley   Regular School No Elementary KG 05 2018   grade_5 96 5 6 0   1     0   4   43 69                       112.0 96 5 6 0   1     0   4   43 69                 112
2239740 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional: West Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_5 34 1 1 0   0     0   3   16 23                       39.0 34 1 1 0   0     0   3   16 23                 39
2239731 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional: Warren Elementary   Regular School No Elementary PK 06 2018   grade_5 60 0 5 0   0     0   1   31 35                       66.0 60 0 5 0   0     0   1   31 35                 66
2239715 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   grade_5 64 1 7 0   5     0   2   42 37                       79.0 64 1 7 0   5     0   2   42 37                 79
2239705 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett: Glenwood Elementary School   Regular School No Elementary 03 05 2018   grade_5 113 2 7 0   4     0   3   64 65                       129.0 113 2 7 0   4     0   3   64 65                 129
2239698 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett: Thomas Prince   Regular School No Elementary KG 08 2018   grade_5 44 0 1 0   2     0   1   22 26                       48.0 44 0 1 0   2     0   1   22 26                 48
2239688 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett: Paxton Center   Regular School No Elementary KG 08 2018   grade_5 52 2 4 0   4     0   1   33 30                       63.0 52 2 4 0   4     0   1   33 30                 63
2239681 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Wachusett: Leroy E.Mayo   Regular School No Elementary KG 05 2018   grade_5 68 1 9 0   6     0   3   43 44                       87.0 68 1 9 0   6     0   3   43 44                 87
2239668 MA Worcester   school 2511880 775   Wachusett 251188000884 7750020 Wachusett: Dawson   Regular School No Elementary KG 05 2018   grade_5 77 3 4 0   5     0   1   46 44                       90.0 77 3 4 0   5     0   1   46 44                 90
2239661 MA Worcester   school 2511880 775   Wachusett 251188001607 7750018 Wachusett: Davis Hill Elementary   Regular School No Elementary KG 05 2018   grade_5 81 4 5 0   1     0   3   48 46                       94.0 81 4 5 0   1     0   3   48 46                 94
2239645 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_5 27 0 3 0   0     0   2   21 11                       32.0 27 0 3 0   0     0   2   21 11                 32
2239637 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional: Chilmark Elementary   Regular School No Elementary KG 05 2018   grade_5 6 0 0 0   0     0   0   2 4                       6.0 6 0 0 0   0     0   0   2 4                 6
2239621 MA Essex   school 2511740 773   Triton 251174001651 7730025 Triton: Pine Grove   Regular School No Elementary PK 06 2018   grade_5 62 0 1 0   1     0   2   39 27                       66.0 62 0 1 0   1     0   2   39 27                 66
2239612 MA Essex   school 2511740 773   Triton 251174001348 7730020 Triton: Newbury Elementary   Regular School No Elementary PK 06 2018   grade_5 54 0 1 0   0     1   0   34 22                       56.0 54 0 1 0   0     1   0   34 22                 56
2239603 MA Essex   school 2511740 773   Triton 251174001669 7730015 Triton: Salisbury Elementary   Regular School No Elementary PK 06 2018   grade_5 67 0 4 0   5     0   2   43 35                       78.0 67 0 4 0   5     0   2   43 35                 78
2239574 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_5 79 2 7 0   2     0   5   45 50                       95.0 79 2 7 0   2     0   5   45 50                 95
2239565 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield: East Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_5 19 0 1 0   0     0   1   9 12                       21.0 19 0 1 0   0     0   1   9 12                 21
2239549 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_5 106 1 3 0   1     0   3   57 57                       114.0 106 1 3 0   1     0   3   57 57                 114
2239532 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire: Undermountain   Regular School No Elementary PK 06 2018   grade_5 49 0 2 1   0     0   4   31 25                       56.0 49 0 2 1   0     0   4   31 25                 56
2239477 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Quabbin: Ruggles Lane   Regular School No Elementary PK 06 2018   grade_5 45 0 4 0   0     0   1   24 26                       50.0 45 0 4 0   0     0   1   24 26                 50
2239468 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_5 25 2 0 0   0     0   0   11 16                       27.0 25 2 0 0   0     0   0   11 16                 27
2239459 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Quabbin: Hubbardston Center   Regular School No Elementary KG 06 2018   grade_5 39 1 0 0   1     0   1   19 23                       42.0 39 1 0 0   1     0   1   19 23                 42
2239451 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin: Hardwick Elementary   Regular School No Elementary KG 06 2018   grade_5 24 1 3 0   0     0   0   15 13                       28.0 24 1 3 0   0     0   0   15 13                 28
2239436 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Pioneer Valley: Warwick Community School   Regular School No Elementary PK 06 2018   grade_5 7 0 1 0   0     0   0   6 2                       8.0 7 0 1 0   0     0   0   6 2                 8
2239427 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley: Northfield Elementary   Regular School No Elementary PK 06 2018   grade_5 24 0 0 0   0     0   1   13 12                       25.0 24 0 0 0   0     0   1   13 12                 25
2239412 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley: Bernardston Elementary   Regular School No Elementary PK 06 2018   grade_5 20 0 0 0   0     0   2   11 11                       22.0 20 0 0 0   0     0   2   11 11                 22
2239390 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Pentucket: Dr John C Page School   Regular School No Elementary PK 06 2018   grade_5 52 0 0 0   0     0   3   23 32                       55.0 52 0 0 0   0     0   3   23 32                 55
2239381 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Pentucket: Helen R Donaghue School   Regular School No Elementary 03 06 2018   grade_5 64 1 2 0   0     0   2   37 32                       69.0 64 1 2 0   0     0   2   37 32                 69
2239376 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Pentucket: Elmer S Bagnall   Regular School No Elementary PK 06 2018   grade_5 77 1 5 0   1     0   2   45 41                       86.0 77 1 5 0   1     0   2   45 41                 86
2239351 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex: Nissitissit Middle School   Regular School No Middle 05 08 2018   grade_5 133 3 6 0   2     0   4   69 79                       148.0 133 3 6 0   2     0   4   69 79                 148
2239340 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex: Hawthorne Brook   Regular School No Middle 05 08 2018   grade_5 121 0 3 0   2     0   3   67 62                       129.0 121 0 3 0   2     0   3   67 62                 129
2239318 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell: Swift River   Regular School No Elementary PK 06 2018   grade_5 18 0 1 0   1     0   1   10 11                       21.0 18 0 1 0   1     0   1   10 11                 21
2239294 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba: Florence Sawyer School   Regular School No Elementary PK 08 2018   grade_5 81 0 4 0   7     0   3   44 51                       95.0 81 0 4 0   7     0   3   44 51                 95
2239286 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Nashoba: Center School   Regular School No Elementary PK 05 2018   grade_5 79 0 7 1   11     0   1   54 45                       99.0 79 0 7 1   11     0   1   54 45                 99
2239278 MA Worcester   school 2508310 725   Nashoba 250831000948 7250010 Nashoba: Mary Rowlandson Elementary   Regular School No Elementary PK 05 2018   grade_5 65 1 10 0   1     0   1   39 39                       78.0 65 1 10 0   1     0   1   39 39                 78
2239262 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett: Narragansett Middle   Regular School No Middle 05 08 2018   grade_5 96 3 11 0   0     1   5   56 60                       116.0 96 3 11 0   0     1   5   56 60                 116
2239238 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail: Sanderson Academy   Regular School No Elementary PK 06 2018   grade_5 18 0 0 0   0     0   0   14 4                       18.0 18 0 0 0   0     0   0   14 4                 18
2239229 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail: Colrain Central   Regular School No Elementary PK 06 2018   grade_5 10 1 0 0   0     0   0   4 7                       11.0 10 1 0 0   0     0   0   4 7                 11
2239220 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Mohawk Trail: Buckland-Shelburne Regional   Regular School No Elementary PK 06 2018   grade_5 29 0 0 0   0     0   0   12 17                       29.0 29 0 0 0   0     0   0   12 17                 29
2239197 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_5 162 14 10 0   1     1   2   100 90                       190.0 162 14 10 0   1     1   2   100 90                 190
2239166 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton: Miscoe Hill School   Regular School No Middle 05 08 2018   grade_5 170 0 9 0   7     0   7   102 91                       193.0 170 0 9 0   7     0   7   102 91                 193
2239135 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Manchester Essex Regional: Essex Elementary   Regular School No Elementary KG 05 2018   grade_5 44 0 0 0   0     0   1   19 26                       45.0 44 0 0 0   0     0   1   19 26                 45
2239128 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Essex Regional: Manchester Memorial Elementary   Regular School No Elementary PK 05 2018   grade_5 77 0 0 0   1     0   0   40 38                       78.0 77 0 0 0   1     0   0   40 38                 78
2239106 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_5 19 1 1 0   0     0   1   10 12                       22.0 19 1 1 0   0     0   1   10 12                 22
2239075 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002139 6800030 Hampden-Wilbraham: Soule Road   Regular School No Elementary 04 05 2018   grade_5 151 6 12 0   4     0   4   90 87                       177.0 151 6 12 0   4     0   4   90 87                 177
2239068 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham: Green Meadows Elementary   Regular School No Elementary PK 05 2018   grade_5 34 2 2 0   1     0   1   16 24                       40.0 34 2 2 0   1     0   1   16 24                 40
2239051 MA Essex   school 2505670 675   Hamilton-Wenham 250567000821 6750015 Hamilton-Wenham: Winthrop School   Regular School No Elementary PK 05 2018   grade_5 41 2 3 0   0     0   0   23 23                       46.0 41 2 3 0   0     0   0   23 23                 46
2239043 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Hamilton-Wenham: Cutler School   Regular School No Elementary KG 05 2018   grade_5 41 0 1 0   2     0   2   24 22                       46.0 41 0 1 0   2     0   2   24 22                 46
2239036 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Hamilton-Wenham: Bessie Buker Elementary   Regular School No Elementary KG 05 2018   grade_5 40 0 0 0   1     0   2   24 19                       43.0 40 0 0 0   1     0   2   24 19                 43
2239020 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Gill-Montague: Sheffield Elementary School   Regular School No Elementary 02 05 2018   grade_5 35 0 8 1   0     0   6   20 30                       50.0 35 0 8 1   0     0   6   20 30                 50
2239010 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague: Gill Elementary   Regular School No Elementary KG 06 2018   grade_5 19 0 0 0   0     0   2   11 10                       21.0 19 0 0 0   0     0   2   11 10                 21
2238995 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable: Groton Dunstable Regional Middle   Regular School No Middle 05 08 2018   grade_5 156 4 5 0   8     0   4   89 88                       177.0 156 4 5 0   8     0   4   89 88                 177
2238970 MA Hampshire   school 2505160 672   Gateway 250516000761 6720143 Gateway: Littleville Elementary School   Regular School No Elementary PK 05 2018   grade_5 48 1 1 0   0     0   0   27 23                       50.0 48 1 1 0   0     0   0   27 23                 50
2238962 MA Hampshire   school 2505160 672   Gateway 250516000757 6720059 Gateway: Chester Elementary   Regular School No Elementary PK 05 2018   grade_5 18 0 1 1   0     0   1   12 9                       21.0 18 0 1 1   0     0   1   12 9                 21
2238938 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 Freetown-Lakeville: George R Austin Intermediate School   Regular School No Elementary 04 05 2018   grade_5 209 6 2 1   4     0   6   107 121                       228.0 209 6 2 1   4     0   6   107 121                 228
2238923 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_5 17 0 0 0   0     0   0   9 8                       17.0 17 0 0 0   0     0   0   9 8                 17
2238898 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg: Charlton Middle School   Regular School No Middle 05 08 2018   grade_5 143 1 19 1   2     1   3   97 73                       170.0 143 1 19 1   2     1   3   97 73                 170
2238893 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg: Dudley Middle School   Regular School No Middle 05 08 2018   grade_5 107 2 7 0   0     0   1   58 59                       117.0 107 2 7 0   0     0   1   58 59                 117
2238857 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth: Dorothy L Beckwith   Regular School No Middle 05 08 2018   grade_5 129 0 3 0   1     0   5   68 70                       138.0 129 0 3 0   1     0   5   68 70                 138
2238852 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth: Dighton Middle School   Regular School No Middle 05 08 2018   grade_5 77 1 7 0   1     0   5   42 49                       91.0 77 1 7 0   1     0   5   42 49                 91
2238828 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth: N H Wixon Innovation School   Regular School No Elementary 04 05 2018   grade_5 194 21 30 6   7     0   13   136 135                       271.0 194 21 30 6   7     0   13   136 135                 271
2238793 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Central Berkshire: Kittredge   Regular School No Elementary PK 05 2018   grade_5 22 1 0 0   0     0   2   16 9                       25.0 22 1 0 0   0     0   2   16 9                 25
2238785 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Central Berkshire: Craneville   Regular School No Elementary KG 05 2018   grade_5 73 1 4 0   1     0   2   44 37                       81.0 73 1 4 0   1     0   2   44 37                 81
2238778 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire: Becket Washington School   Regular School No Elementary PK 05 2018   grade_5 17 0 0 0   0     0   0   10 7                       17.0 17 0 0 0   0     0   0   10 7                 17
2238769 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen: New Hingham Regional Elementary   Regular School No Elementary PK 06 2018   grade_5 20 0 0 0   0     0   0   13 7                       20.0 20 0 0 0   0     0   0   13 7                 20
2238746 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham: Raynham Middle School   Regular School No Middle 05 08 2018   grade_5 157 7 0 0   2     0   4   104 66                       170.0 157 7 0 0   2     0   4   104 66                 170
2238743 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_5 258 15 0 1   3     2   21   148 152                       300.0 258 15 0 1   3     2   21   148 152                 300
2238718 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 Blackstone-Millville: A F Maloney   Regular School No Elementary 03 05 2018   grade_5 88 1 7 0   1     0   3   44 56                       100.0 88 1 7 0   1     0   3   44 56                 100
2238714 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Blackstone-Millville: Millville Elementary   Regular School No Elementary PK 05 2018   grade_5 44 0 3 0   1     0   1   23 26                       49.0 44 0 3 0   1     0   1   23 26                 49
2238686 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_5 63 2 6 0   2     0   5   44 34                       78.0 63 2 6 0   2     0   5   44 34                 78
2238668 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202736 6160002 Ayer Shirley School District: Page Hilltop Elementary School   Regular School No Elementary PK 05 2018   grade_5 71 3 10 0   0     0   4   47 41                       88.0 71 3 10 0   0     0   4   47 41                 88
2238660 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202731 6160001 Ayer Shirley School District: Lura A. White Elementary School   Regular School No Elementary PK 05 2018   grade_5 55 2 7 0   1     0   1   32 34                       66.0 55 2 7 0   1     0   1   32 34                 66
2238644 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston: Athol-Royalston Middle School   Regular School No Middle 05 08 2018   grade_5 81 1 11 0   2     0   4   55 44                       99.0 81 1 11 0   2     0   4   55 44                 99
2238641 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston: Royalston Community School   Regular School No Elementary KG 06 2018   grade_5 22 0 0 0   1     0   0   15 8                       23.0 22 0 0 0   1     0   0   15 8                 23
2238618 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Ashburnham-Westminster: Briggs Elementary   Regular School No Elementary PK 05 2018   grade_5 81 0 1 0   1     0   3   42 44                       86.0 81 0 1 0   1     0   3   42 44                 86
2238607 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster: Westminster Elementary   Regular School No Elementary 02 05 2018   grade_5 91 1 4 0   0     0   2   53 45                       98.0 91 1 4 0   0     0   2   53 45                 98
2238586 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_5 95 6 5 0   0     0   0   56 50                       106.0 95 6 5 0   0     0   0   56 50                 106
2238568 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   grade_5 18 2 7 0   63     1   2   40 53                       93.0 18 2 7 0   63     1   2   40 53                 93
2238560 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   grade_5 20 2 0 1   22     0   2   22 25                       47.0 20 2 0 1   22     0   2   22 25                 47
2238552 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   grade_5 46 0 2 0   15     1   5   39 30                       69.0 46 0 2 0   15     1   5   39 30                 69
2238544 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   grade_5 50 1 9 0   7     0   3   34 36                       70.0 50 1 9 0   7     0   3   34 36                 70
2238536 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   grade_5 52 3 6 0   10     0   1   35 37                       72.0 52 3 6 0   10     0   1   35 37                 72
2238528 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   grade_5 35 3 2 2   25     0   2   36 33                       69.0 35 3 2 2   25     0   2   36 33                 69
2238508 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_5 3 16 70 0   0     0   1   38 52                       90.0 3 16 70 0   0     0   1   38 52                 90
2238499 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_5 25 1 5 0   7     0   5   24 19                       43.0 25 1 5 0   7     0   5   24 19                 43
2238485 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_5 37 9 38 1   1     0   3   41 48                       89.0 37 9 38 1   1     0   3   41 48                 89
2238466 MA Hampden   school 2500089 492   Martin Luther King Jr. Charter School of Excellence (District) 250008902127 4920005 Martin Luther King Jr. Charter School of Excellence (District): Martin Luther King Jr. Charter School of Excellence   Regular School Yes Elementary KG 05 2018   grade_5 0 25 32 0   1     0   2   32 28                       60.0 0 25 32 0   1     0   2   32 28                 60
2238452 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_5 89 3 12 0   0     0   6   52 58                       110.0 89 3 12 0   0     0   6   52 58                 110
2238433 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_5 35 31 3 0   5     0   5   36 43                       79.0 35 31 3 0   5     0   5   36 43                 79
2238419 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_5 17 48 18 2   9     1   2   52 45                       97.0 17 48 18 2   9     1   2   52 45                 97
2238409 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_5 1 42 34 0   0     0   2   41 38                       79.0 1 42 34 0   0     0   2   41 38                 79
2238388 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_5 3 135 92 1   4     0   1   124 112                       236.0 3 135 92 1   4     0   1   124 112                 236
2238379 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_5 79 2 3 0   1     0   7   53 39                       92.0 79 2 3 0   1     0   7   53 39                 92

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