Data source: Big Local News · About: Big Local

884 rows where grade = "grade_5", state = "MA" and year = 2020 sorted by rowid descending

View and edit SQL

year

  • 2020 · 884

grade

  • grade_5 · 884
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
1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1374298 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_5 33 9 14 0   3     0   9   37 31 *                     68.0 33 9 14 0   3     0   9   37 31                 68
1374285 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_5 15 6 7 0   2     0   4   23 11 *                     34.0 15 6 7 0   2     0   4   23 11                 34
1374266 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 05 2020   grade_5 37 2 1 0   0     0   0   19 21 *                     40.0 37 2 1 0   0     0   0   19 21                 40
1374251 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_5 11 9 31 0   3     0   1   24 31 *                     55.0 11 9 31 0   3     0   1   24 31                 55
1374245 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_5 6 10 35 0   0     0   3   32 22 *                     54.0 6 10 35 0   0     0   3   32 22                 54
1374216 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_5 0 45 26 0   1     1   0   38 35 *                     73.0 0 45 26 0   1     1   0   38 35                 73
1374201 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_5 13 18 38 1   23     0   0   49 44 *                     93.0 13 18 38 1   23     0   0   49 44                 93
1374063 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_5 102 0 7 0   2     0   2   55 58 *                     113.0 102 0 7 0   2     0   2   55 58                 113
1374054 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2020   grade_5 64 6 2 1   1     1   6   44 37 *                     81.0 64 6 2 1   1     1   6   44 37                 81
1374048 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2020   grade_5 72 0 7 1   1     0   1   48 34 *                     82.0 72 0 7 1   1     0   1   48 34                 82
1374034 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_5 40 0 2 0   0     0   3   23 22 *                     45.0 40 0 2 0   0     0   3   23 22                 45
1374026 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2020   grade_5 59 0 5 0   0     0   8   34 38 *                     72.0 59 0 5 0   0     0   8   34 38                 72
1374011 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2020   grade_5 63 1 1 0   1     0   2   43 25 *                     68.0 63 1 1 0   1     0   2   43 25                 68
1374004 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2020   grade_5 95 2 4 2   2     0   3   56 52 *                     108.0 95 2 4 2   2     0   3   56 52                 108
1373998 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2020   grade_5 49 0 2 0   0     0   1   22 30 *                     52.0 49 0 2 0   0     0   1   22 30                 52
1373989 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2020   grade_5 49 2 5 0   2     0   2   34 26 *                     60.0 49 2 5 0   2     0   2   34 26                 60
1373983 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No Elementary KG 05 2020   grade_5 77 3 5 0   4     0   0   48 41 *                     89.0 77 3 5 0   4     0   0   48 41                 89
1373972 MA Worcester   school 2511880 775   Wachusett 251188000884 7750020 Dawson   Regular School No Elementary KG 05 2020   grade_5 73 5 4 0   5     0   3   48 42 *                     90.0 73 5 4 0   5     0   3   48 42                 90
1373966 MA Worcester   school 2511880 775   Wachusett 251188001607 7750018 Davis Hill Elementary   Regular School No Elementary KG 05 2020   grade_5 70 3 5 0   3     0   3   49 35 *                     84.0 70 3 5 0   3     0   3   49 35                 84
1373953 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_5 35 0 4 2   0     0   1   17 25 *                     42.0 35 0 4 2   0     0   1   17 25                 42
1373946 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2020   grade_5 9 0 1 0   0     0   2   7 5 *                     12.0 9 0 1 0   0     0   2   7 5                 12
1373933 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2020   grade_5 67 2 2 0   0     0   5   42 34 *                     76.0 67 2 2 0   0     0   5   42 34                 76
1373925 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2020   grade_5 50 1 1 0   1     0   0   27 26 *                     53.0 50 1 1 0   1     0   0   27 26                 53
1373917 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2020   grade_5 55 1 4 0   1     0   0   37 24 *                     61.0 55 1 4 0   1     0   0   37 24                 61
1373892 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_5 75 1 10 0   2     0   1   46 43 *                     89.0 75 1 10 0   2     0   1   46 43                 89
1373885 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_5 14 0 1 0   0     0   2   8 9 *                     17.0 14 0 1 0   0     0   2   8 9                 17
1373871 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_5 111 1 7 1   1     0   6   70 57 *                     127.0 111 1 7 1   1     0   6   70 57                 127
1373857 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 05 2020   grade_5 35 2 4 1   0     0   2   26 18 *                     44.0 35 2 4 1   0     0   2   26 18                 44
1373817 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_5 67 1 2 0   1     0   2   39 34 *                     73.0 67 1 2 0   1     0   2   39 34                 73
1373809 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_5 31 0 1 0   0     0   0   9 23 *                     32.0 31 0 1 0   0     0   0   9 23                 32
1373802 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_5 40 0 2 0   1     0   0   18 25 *                     43.0 40 0 2 0   1     0   0   18 25                 43
1373795 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_5 19 0 3 1   0     0   0   10 13 *                     23.0 19 0 3 1   0     0   0   10 13                 23
1373781 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_5 10 0 1 0   0     0   0   6 5 *                     11.0 10 0 1 0   0     0   0   6 5                 11
1373775 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2020   grade_5 21 0 1 0   0     0   1   10 13 *                     23.0 21 0 1 0   0     0   1   10 13                 23
1373767 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2020   grade_5 28 0 0 0   0     0   2   13 17 *                     30.0 28 0 0 0   0     0   2   13 17                 30
1373749 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2020   grade_5 50 1 2 0   2     0   2   37 20 *                     57.0 50 1 2 0   2     0   2   37 20                 57
1373741 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No Elementary 03 06 2020   grade_5 43 0 5 0   0     0   3   27 24 *                     51.0 43 0 5 0   0     0   3   27 24                 51
1373737 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Elmer S Bagnall   Regular School No Elementary PK 06 2020   grade_5 68 0 4 0   0     0   1   42 30 *                     73.0 68 0 4 0   0     0   1   42 30                 73
1373715 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2020   grade_5 107 1 8 0   1     0   2   59 60 *                     119.0 107 1 8 0   1     0   2   59 60                 119
1373706 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_5 100 1 7 0   2     0   4   54 60 *                     114.0 100 1 7 0   2     0   4   54 60                 114
1373687 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2020   grade_5 14 0 0 0   0     0   1   5 10 *                     15.0 14 0 0 0   0     0   1   5 10                 15
1373666 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2020   grade_5 59 0 1 0   5     0   4   32 37 *                     69.0 59 0 1 0   5     0   4   32 37                 69
1373659 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2020   grade_5 90 4 4 0   7     0   4   53 56 *                     109.0 90 4 4 0   7     0   4   53 56                 109
1373652 MA Worcester   school 2508310 725   Nashoba 250831000948 7250010 Mary Rowlandson Elementary   Regular School No Elementary PK 05 2020   grade_5 78 6 8 1   1     0   0   47 47 *                     94.0 78 6 8 1   1     0   0   47 47                 94
1373637 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Elementary School   Regular School No Elementary PK 05 2020   grade_5 87 1 6 0   0     0   7   52 49 *                     101.0 87 1 6 0   0     0   7   52 49                 101
1373630 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary KG 05 2020   grade_5 17 0 1 0   0     0   1   13 6 *                     19.0 17 0 1 0   0     0   1   13 6                 19
1373616 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2020   grade_5 18 0 1 0   0     0   1   8 12 *                     20.0 18 0 1 0   0     0   1   8 12                 20
1373608 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2020   grade_5 17 0 1 0   0     0   0   9 9 *                     18.0 17 0 1 0   0     0   0   9 9                 18
1373600 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2020   grade_5 28 0 2 0   0     0   1   19 12 *                     31.0 28 0 2 0   0     0   1   19 12                 31
1373585 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Williamstown Elementary   Regular School No Elementary PK 06 2020   grade_5 57 0 1 0   0     0   2   30 30 *                     60.0 57 0 1 0   0     0   2   30 30                 60
1373577 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2020   grade_5 22 1 2 0   0     0   1   8 18 *                     26.0 22 1 2 0   0     0   1   8 18                 26
1373563 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_5 137 6 10 1   0     0   8   69 93 *                     162.0 137 6 10 1   0     0   8   69 93                 162
1373536 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2020   grade_5 147 1 7 0   3     0   2   91 69 *                     160.0 147 1 7 0   3     0   2   91 69                 160
1373511 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Essex Elementary   Regular School No Elementary KG 05 2020   grade_5 40 0 1 0   0     0   0   21 20 *                     41.0 40 0 1 0   0     0   0   21 20                 41
1373505 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Memorial Elementary   Regular School No Elementary PK 05 2020   grade_5 60 1 1 0   0     0   0   40 22 *                     62.0 60 1 1 0   0     0   0   40 22                 62
1373485 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2020   grade_5 16 0 1 0   0     0   1   10 8 *                     18.0 16 0 1 0   0     0   1   10 8                 18
1373461 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002139 6800030 Soule Road   Regular School No Elementary 04 05 2020   grade_5 130 3 14 0   5     0   8   85 75 *                     160.0 130 3 14 0   5     0   8   85 75                 160
1373453 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_5 38 0 2 0   0     0   2   16 26 *                     42.0 38 0 2 0   0     0   2   16 26                 42
1373439 MA Essex   school 2505670 675   Hamilton-Wenham 250567000821 6750015 Winthrop School   Regular School No Elementary PK 05 2020   grade_5 49 0 5 0   2     0   1   30 27 *                     57.0 49 0 5 0   2     0   1   30 27                 57
1373432 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2020   grade_5 39 0 0 0   0     3   1   22 21 *                     43.0 39 0 0 0   0     3   1   22 21                 43
1373426 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No Elementary KG 05 2020   grade_5 36 0 3 0   1     0   1   24 17 *                     41.0 36 0 3 0   1     0   1   24 17                 41
1373412 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2020   grade_5 46 0 5 0   0     0   4   30 25 *                     55.0 46 0 5 0   0     0   4   30 25                 55
1373404 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2020   grade_5 16 1 1 0   0     0   1   8 11 *                     19.0 16 1 1 0   0     0   1   8 11                 19
1373390 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_5 169 2 3 0   18     1   4   97 100 *                     197.0 169 2 3 0   18     1   4   97 100                 197
1373370 MA Hampshire   school 2505160 672   Gateway 250516000761 6720143 Littleville Elementary School   Regular School No Elementary PK 05 2020   grade_5 56 1 1 0   0     0   2   31 29 *                     60.0 56 1 1 0   0     0   2   31 29                 60
1373363 MA Hampshire   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2020   grade_5 18 0 0 0   0     0   0   9 9 *                     18.0 18 0 0 0   0     0   0   9 9                 18
1373342 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No Middle 04 06 2020   grade_5 193 3 2 0   0     0   5   115 88 *                     203.0 193 3 2 0   0     0   5   115 88                 203
1373330 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_5 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1373308 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2020   grade_5 127 4 13 1   0     0   7   82 70 *                     152.0 127 4 13 1   0     0   7   82 70                 152
1373304 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2020   grade_5 127 1 14 0   0     0   5   85 62 *                     147.0 127 1 14 0   0     0   5   85 62                 147
1373275 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2020   grade_5 94 4 4 0   3     0   4   48 61 *                     109.0 94 4 4 0   3     0   4   48 61                 109
1373271 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_5 80 3 3 0   2     0   4   50 42 *                     92.0 80 3 3 0   2     0   4   50 42                 92
1373251 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2020   grade_5 164 17 21 8   2     0   28   123 117 *                     240.0 164 17 21 8   2     0   28   123 117                 240
1373224 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2020   grade_5 15 0 0 0   0     0   1   8 8 *                     16.0 15 0 0 0   0     0   1   8 8                 16
1373217 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary KG 05 2020   grade_5 61 0 4 0   1     0   9   51 24 *                     75.0 61 0 4 0   1     0   9   51 24                 75
1373211 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2020   grade_5 17 0 1 0   0     0   2   11 9 *                     20.0 17 0 1 0   0     0   2   11 9                 20
1373204 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2020   grade_5 14 0 1 1   0     0   0   8 8 *                     16.0 14 0 1 1   0     0   0   8 8                 16
1373183 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_5 144 9 0 1   5     0   7   77 89 *                     166.0 144 9 0 1   5     0   7   77 89                 166
1373181 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2020   grade_5 198 19 5 0   3     0   13   122 116 *                     238.0 198 19 5 0   3     0   13   122 116                 238
1373162 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2020   grade_5 66 1 8 0   0     0   8   45 38 *                     83.0 66 1 8 0   0     0   8   45 38                 83
1373159 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Millville Elementary   Regular School No Elementary PK 05 2020   grade_5 34 0 4 0   0     0   0   20 18 *                     38.0 34 0 4 0   0     0   0   20 18                 38
1373142 MA Worcester   school 2502580 620   Berlin-Boylston 250258002912 6200010 Boylston Elementary School   Regular School No Elementary PK 05 2020   grade_5 36 1 2 0   2     0   2   15 28 *                     43.0 36 1 2 0   2     0   2   15 28                 43
1373135 MA Worcester   school 2502580 620   Berlin-Boylston 250258002901 6200005 Berlin Memorial School   Regular School No Elementary PK 05 2020   grade_5 23 0 0 0   0     0   0   16 7 *                     23.0 23 0 0 0   0     0   0   16 7                 23
1373120 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_5 54 1 7 0   2     0   4   39 29 *                     68.0 54 1 7 0   2     0   4   39 29                 68
1373106 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202736 6160002 Page Hilltop Elementary School   Regular School No Elementary PK 05 2020   grade_5 59 6 11 1   2     1   2   48 34 *                     82.0 59 6 11 1   2     1   2   48 34                 82
1373099 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202731 6160001 Lura A. White Elementary School   Regular School No Elementary KG 05 2020   grade_5 54 2 5 0   1     0   0   36 26 *                     62.0 54 2 5 0   1     0   0   36 26                 62
1373085 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_5 85 1 5 0   3     0   2   55 41 *                     96.0 85 1 5 0   3     0   2   55 41                 96
1373083 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2020   grade_5 17 0 0 0   0     0   3   6 14 *                     20.0 17 0 0 0   0     0   3   6 14                 20
1373063 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No Elementary PK 05 2020   grade_5 79 2 10 0   2     0   2   41 54 *                     95.0 79 2 10 0   2     0   2   41 54                 95
1373054 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2020   grade_5 86 0 6 0   1     0   6   53 46 *                     99.0 86 0 6 0   1     0   6   53 46                 99
1373036 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_5 90 6 6 0   2     0   2   55 51 *                     106.0 90 6 6 0   2     0   2   55 51                 106
1373021 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2020   grade_5 12 2 2 0   29     0   1   24 22 *                     46.0 12 2 2 0   29     0   1   24 22                 46
1373014 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2020   grade_5 22 2 3 0   43     0   1   33 38 *                     71.0 22 2 3 0   43     0   1   33 38                 71
1373007 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2020   grade_5 48 0 1 0   15     1   4   40 29 *                     69.0 48 0 1 0   15     1   4   40 29                 69
1373000 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2020   grade_5 49 5 13 2   16     0   5   44 46 *                     90.0 49 5 13 2   16     0   5   44 46                 90
1372993 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2020   grade_5 46 1 5 0   17     0   2   37 34 *                     71.0 46 1 5 0   17     0   2   37 34                 71
1372986 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2020   grade_5 38 1 2 0   23     0   1   38 27 *                     65.0 38 1 2 0   23     0   1   38 27                 65
1372969 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2020   grade_5 9 22 76 1   2     0   0   51 59 *                     110.0 9 22 76 1   2     0   0   51 59                 110
1372961 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_5 22 0 4 0   12     0   8   20 26 *                     46.0 22 0 4 0   12     0   8   20 26                 46

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