enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1681536 1681536 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 2021   grade_5 67 9 29 1   7     0   7   59 61 *                     120.0 67 9 29 1   7     0   7   59 61                 120
1681523 1681523 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_5 31 5 8 0   2     0   2   27 21 0                     48.0 31 5 8 0   2     0   2   27 21 0               48
1681503 1681503 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School (District) - Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 06 2021   grade_5 31 3 6 0   0     0   0   23 17 *                     40.0 31 3 6 0   0     0   0   23 17                 40
1681486 1681486 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School (District) - Springfield Preparatory Charter School   Regular School Yes Elementary KG 06 2021   grade_5 3 10 37 0   3     0   0   28 25 *                     53.0 3 10 37 0   3     0   0   28 25                 53
1681461 1681461 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 2021   grade_5 0 40 34 0   1     0   2   41 36 *                     77.0 0 40 34 0   1     0   2   41 36                 77
1681449 1681449 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 Other KG 09 2021   grade_5 16 26 39 0   35     0   4   50 70 *                     120.0 16 26 39 0   35     0   4   50 70                 120
1681311 1681311 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_5 95 2 3 0   1     0   3   54 50 *                     104.0 95 2 3 0   1     0   3   54 50                 104
1681302 1681302 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 Whitman-Hanson - John H Duval   Regular School No Elementary KG 05 2021   grade_5 56 1 9 0   2     0   2   32 38 *                     70.0 56 1 9 0   2     0   2   32 38                 70
1681296 1681296 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Whitman-Hanson - Louise A Conley   Regular School No Elementary KG 05 2021   grade_5 83 5 3 1   1     0   3   49 47 *                     96.0 83 5 3 1   1     0   3   49 47                 96
1681282 1681282 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 Quaboag Regional - West Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_5 27 0 4 0   0     0   2   15 18 *                     33.0 27 0 4 0   0     0   2   15 18                 33
1681274 1681274 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Quaboag Regional - Warren Elementary   Regular School No Elementary PK 06 2021   grade_5 48 0 8 0   0     0   4   27 33 *                     60.0 48 0 8 0   0     0   4   27 33                 60
1681259 1681259 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett - Chocksett Middle School   Regular School No Middle 05 08 2021   grade_5 68 0 6 0   3     0   0   35 42 *                     77.0 68 0 6 0   3     0   0   35 42                 77
1681252 1681252 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett - Glenwood Elementary School   Regular School No Elementary 03 05 2021   grade_5 112 4 10 1   1     0   3   59 72 *                     131.0 112 4 10 1   1     0   3   59 72                 131
1681246 1681246 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_5 34 1 1 0   0     0   0   16 20 *                     36.0 34 1 1 0   0     0   0   16 20                 36
1681237 1681237 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett - Paxton Center   Regular School No Elementary KG 08 2021   grade_5 39 0 5 0   0     0   0   21 23 *                     44.0 39 0 5 0   0     0   0   21 23                 44
1681231 1681231 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Wachusett - Leroy E.Mayo   Regular School No Elementary KG 05 2021   grade_5 79 1 2 0   7     0   2   53 38 *                     91.0 79 1 2 0   7     0   2   53 38                 91
1681220 1681220 MA Worcester   school 2511880 775   Wachusett 251188000884 7750020 Wachusett - Dawson   Regular School No Elementary KG 05 2021   grade_5 71 3 5 0   2     0   0   46 35 *                     81.0 71 3 5 0   2     0   0   46 35                 81
1681214 1681214 MA Worcester   school 2511880 775   Wachusett 251188001607 7750018 Wachusett - Davis Hill Elementary   Regular School No Elementary KG 05 2021   grade_5 65 2 7 1   0     0   2   40 37 *                     77.0 65 2 7 1   0     0   2   40 37                 77
1681201 1681201 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_5 31 0 3 2   0     0   2   23 15 *                     38.0 31 0 3 2   0     0   2   23 15                 38
1681194 1681194 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional - Chilmark Elementary   Regular School No Elementary KG 05 2021   grade_5 5 0 0 1   0     0   0   2 4 *                     6.0 5 0 0 1   0     0   0   2 4                 6
1681181 1681181 MA Essex   school 2511740 773   Triton 251174001651 7730025 Triton - Pine Grove   Regular School No Elementary PK 06 2021   grade_5 48 0 1 0   1     0   0   23 27 *                     50.0 48 0 1 0   1     0   0   23 27                 50
1681173 1681173 MA Essex   school 2511740 773   Triton 251174001348 7730020 Triton - Newbury Elementary   Regular School No Elementary PK 06 2021   grade_5 52 1 1 0   1     1   0   30 26 *                     56.0 52 1 1 0   1     1   0   30 26                 56
1681165 1681165 MA Essex   school 2511740 773   Triton 251174001669 7730015 Triton - Salisbury Elementary   Regular School No Elementary PK 06 2021   grade_5 50 0 4 0   2     0   4   26 34 *                     60.0 50 0 4 0   2     0   4   26 34                 60
1681140 1681140 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_5 49 0 15 0   0     0   3   32 35 *                     67.0 49 0 15 0   0     0   3   32 35                 67
1681133 1681133 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield - East Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_5 19 0 1 0   0     0   1   14 7 *                     21.0 19 0 1 0   0     0   1   14 7                 21
1681119 1681119 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 2021   grade_5 107 2 3 0   0     0   0   55 57 *                     112.0 107 2 3 0   0     0   0   55 57                 112
1681105 1681105 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Southern Berkshire - Undermountain   Regular School No Elementary PK 05 2021   grade_5 36 0 6 0   0     0   2   22 22 *                     44.0 36 0 6 0   0     0   2   22 22                 44
1681065 1681065 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Quabbin - Ruggles Lane   Regular School No Elementary PK 06 2021   grade_5 48 1 3 0   1     0   2   24 31 *                     55.0 48 1 3 0   1     0   2   24 31                 55
1681058 1681058 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin - Oakham Center   Regular School No Elementary 02 06 2021   grade_5 18 1 2 0   1     0   1   5 18 *                     23.0 18 1 2 0   1     0   1   5 18                 23
1681052 1681052 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Quabbin - Hubbardston Center   Regular School No Elementary KG 06 2021   grade_5 33 0 1 0   0     0   0   18 16 *                     34.0 33 0 1 0   0     0   0   18 16                 34
1681046 1681046 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin - Hardwick Elementary   Regular School No Elementary PK 06 2021   grade_5 23 0 4 0   0     0   0   16 11 *                     27.0 23 0 4 0   0     0   0   16 11                 27
1681032 1681032 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley - Northfield Elementary   Regular School No Elementary PK 06 2021   grade_5 27 1 0 0   0     1   0   18 11 *                     29.0 27 1 0 0   0     1   0   18 11                 29
1681024 1681024 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Pioneer Valley - Bernardston Elementary   Regular School No Elementary PK 06 2021   grade_5 21 0 0 0   0     0   2   11 12 *                     23.0 21 0 0 0   0     0   2   11 12                 23
1681006 1681006 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Pentucket - Dr John C Page School   Regular School No Elementary PK 06 2021   grade_5 31 0 2 0   1     0   1   18 17 *                     35.0 31 0 2 0   1     0   1   18 17                 35
1680998 1680998 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Pentucket - Helen R Donaghue School   Regular School No Elementary 03 06 2021   grade_5 63 0 4 0   0     0   1   35 33 *                     68.0 63 0 4 0   0     0   1   35 33                 68
1680994 1680994 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Pentucket - Elmer S Bagnall   Regular School No Elementary PK 06 2021   grade_5 58 0 5 0   0     0   2   34 31 *                     65.0 58 0 5 0   0     0   2   34 31                 65
1680972 1680972 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex - Nissitissit Middle School   Regular School No Middle 05 08 2021   grade_5 95 5 10 1   0     0   3   61 53 *                     114.0 95 5 10 1   0     0   3   61 53                 114
1680963 1680963 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_5 102 2 2 0   3     0   5   57 57 *                     114.0 102 2 2 0   3     0   5   57 57                 114
1680942 1680942 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 New Salem-Wendell - Swift River   Regular School No Elementary PK 06 2021   grade_5 14 0 1 0   0     0   2   6 11 *                     17.0 14 0 1 0   0     0   2   6 11                 17
1680921 1680921 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba - Florence Sawyer School   Regular School No Elementary PK 08 2021   grade_5 75 1 6 0   3     0   3   50 38 *                     88.0 75 1 6 0   3     0   3   50 38                 88
1680914 1680914 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Nashoba - Center School   Regular School No Elementary PK 05 2021   grade_5 66 2 5 0   1     0   3   37 40 *                     77.0 66 2 5 0   1     0   3   37 40                 77
1680907 1680907 MA Worcester   school 2508310 725   Nashoba 250831000948 7250010 Nashoba - Mary Rowlandson Elementary   Regular School No Elementary PK 05 2021   grade_5 62 0 6 0   0     0   1   41 28 *                     69.0 62 0 6 0   0     0   1   41 28                 69
1680893 1680893 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_5 92 2 7 0   0     0   2   54 49 *                     103.0 92 2 7 0   0     0   2   54 49                 103
1680878 1680878 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1680870 1680870 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Mohawk Trail - Colrain Central   Regular School No Elementary PK 06 2021   grade_5 14 1 0 0   0     0   0   7 8 *                     15.0 14 1 0 0   0     0   0   7 8                 15
1680862 1680862 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Mohawk Trail - Buckland-Shelburne Regional   Regular School No Elementary PK 06 2021   grade_5 35 0 0 0   0     0   0   18 17 *                     35.0 35 0 0 0   0     0   0   18 17                 35
1680848 1680848 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Mount Greylock - Williamstown Elementary   Regular School No Elementary PK 06 2021   grade_5 61 0 3 0   0     0   2   41 25 *                     66.0 61 0 3 0   0     0   2   41 25                 66
1680840 1680840 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Mount Greylock - Lanesborough Elementary   Regular School No Elementary PK 06 2021   grade_5 21 1 0 0   0     0   1   8 15 *                     23.0 21 1 0 0   0     0   1   8 15                 23
1680826 1680826 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 2021   grade_5 116 11 13 1   5     0   7   88 65 *                     153.0 116 11 13 1   5     0   7   88 65                 153
1680800 1680800 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton - Miscoe Hill School   Regular School No Middle 05 08 2021   grade_5 149 0 4 0   2     0   1   81 75 *                     156.0 149 0 4 0   2     0   1   81 75                 156
1680775 1680775 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Manchester Essex Regional - Essex Elementary   Regular School No Elementary KG 05 2021   grade_5 31 0 1 0   0     0   0   17 15 *                     32.0 31 0 1 0   0     0   0   17 15                 32
1680769 1680769 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Essex Regional - Manchester Memorial Elementary   Regular School No Elementary PK 05 2021   grade_5 41 1 0 0   0     0   0   24 18 *                     42.0 41 1 0 0   0     0   0   24 18                 42
1680749 1680749 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont - Hawlemont Regional   Regular School No Elementary PK 06 2021   grade_5 14 0 1 0   0     0   1   5 11 *                     16.0 14 0 1 0   0     0   1   5 11                 16
1680726 1680726 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002139 6800030 Hampden-Wilbraham - Soule Road   Regular School No Elementary 04 05 2021   grade_5 129 2 20 1   2     0   9   96 67 *                     163.0 129 2 20 1   2     0   9   96 67                 163
1680718 1680718 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham - Green Meadows Elementary   Regular School No Elementary PK 08 2021   grade_5 33 1 6 0   1     0   0   14 27 *                     41.0 33 1 6 0   1     0   0   14 27                 41
1680704 1680704 MA Essex   school 2505670 675   Hamilton-Wenham 250567000821 6750015 Hamilton-Wenham - Winthrop School   Regular School No Elementary PK 05 2021   grade_5 34 0 0 0   3     0   0   20 17 *                     37.0 34 0 0 0   3     0   0   20 17                 37
1680697 1680697 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Hamilton-Wenham - Cutler School   Regular School No Elementary KG 05 2021   grade_5 40 0 0 0   2     0   3   15 30 *                     45.0 40 0 0 0   2     0   3   15 30                 45
1680691 1680691 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Hamilton-Wenham - Bessie Buker Elementary   Regular School No Elementary KG 05 2021   grade_5 35 0 2 0   0     0   1   17 21 *                     38.0 35 0 2 0   0     0   1   17 21                 38
1680677 1680677 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Gill-Montague - Sheffield Elementary School   Regular School No Elementary 02 05 2021   grade_5 46 0 7 0   0     0   3   26 29 *                     56.0 46 0 7 0   0     0   3   26 29                 56
1680669 1680669 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague - Gill Elementary   Regular School No Elementary KG 06 2021   grade_5 16 0 0 0   0     0   0   10 6 *                     16.0 16 0 0 0   0     0   0   10 6                 16
1680655 1680655 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable - Groton Dunstable Regional Middle   Regular School No Middle 05 08 2021   grade_5 131 2 6 1   9     0   6   80 75 *                     155.0 131 2 6 1   9     0   6   80 75                 155
1680635 1680635 MA Hampshire   school 2505160 672   Gateway 250516000761 6720143 Gateway - Littleville Elementary School   Regular School No Elementary PK 06 2021   grade_5 36 0 1 0   0     0   1   14 24 *                     38.0 36 0 1 0   0     0   1   14 24                 38
1680628 1680628 MA Hampshire   school 2505160 672   Gateway 250516000757 6720059 Gateway - Chester Elementary   Regular School No Elementary PK 05 2021   grade_5 21 0 0 0   0     0   0   15 6 *                     21.0 21 0 0 0   0     0   0   15 6                 21
1680607 1680607 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 Freetown-Lakeville - George R Austin Intermediate School   Regular School No Middle 04 06 2021   grade_5 200 6 3 0   3     0   5   109 108 *                     217.0 200 6 3 0   3     0   5   109 108                 217
1680595 1680595 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg - Farmington River Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 0 0   0     0   0   4 6 *                     10.0 10 0 0 0   0     0   0   4 6                 10
1680573 1680573 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg - Charlton Middle School   Regular School No Middle 05 08 2021   grade_5 118 2 10 0   3     0   2   74 61 *                     135.0 118 2 10 0   3     0   2   74 61                 135
1680569 1680569 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_5 102 5 14 0   1     0   4   67 59 *                     126.0 102 5 14 0   1     0   4   67 59                 126
1680540 1680540 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_5 102 0 5 0   2     0   1   60 50 *                     110.0 102 0 5 0   2     0   1   60 50                 110
1680536 1680536 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth - Dighton Middle School   Regular School No Middle 05 08 2021   grade_5 72 2 8 0   2     0   7   46 45 *                     91.0 72 2 8 0   2     0   7   46 45                 91
1680515 1680515 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_5 166 21 25 3   8     0   22   136 109 *                     245.0 166 21 25 3   8     0   22   136 109                 245
1680487 1680487 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Central Berkshire - Kittredge   Regular School No Elementary PK 05 2021   grade_5 13 1 0 0   0     0   1   8 7 *                     15.0 13 1 0 0   0     0   1   8 7                 15
1680480 1680480 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Central Berkshire - Craneville   Regular School No Elementary KG 05 2021   grade_5 58 0 3 0   0     0   1   31 31 *                     62.0 58 0 3 0   0     0   1   31 31                 62
1680474 1680474 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire - Becket Washington School   Regular School No Elementary PK 05 2021   grade_5 16 0 0 0   0     0   0   7 9 *                     16.0 16 0 0 0   0     0   0   7 9                 16
1680466 1680466 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 Chesterfield-Goshen - New Hingham Regional Elementary   Regular School No Elementary PK 06 2021   grade_5 12 0 1 0   0     0   0   6 7 *                     13.0 12 0 1 0   0     0   0   6 7                 13
1680446 1680446 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_5 150 16 6 0   6     0   5   91 92 *                     183.0 150 16 6 0   6     0   5   91 92                 183
1680444 1680444 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham - Williams Intermediate School   Regular School No Middle 04 06 2021   grade_5 186 14 5 0   4     0   13   115 107 *                     222.0 186 14 5 0   4     0   13   115 107                 222
1680425 1680425 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 Blackstone-Millville - A F Maloney   Regular School No Elementary 03 05 2021   grade_5 96 0 10 0   1     0   6   67 46 *                     113.0 96 0 10 0   1     0   6   67 46                 113
1680422 1680422 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Blackstone-Millville - Millville Elementary   Regular School No Elementary PK 05 2021   grade_5 33 0 1 0   0     0   0   28 6 *                     34.0 33 0 1 0   0     0   0   28 6                 34
1680405 1680405 MA Worcester   school 2502580 620   Berlin-Boylston 250258002912 6200010 Berlin-Boylston - Boylston Elementary School   Regular School No Elementary PK 05 2021   grade_5 43 0 4 0   4     0   3   25 29 *                     54.0 43 0 4 0   4     0   3   25 29                 54
1680398 1680398 MA Worcester   school 2502580 620   Berlin-Boylston 250258002901 6200005 Berlin-Boylston - Berlin Memorial School   Regular School No Elementary PK 05 2021   grade_5 24 0 4 0   0     0   2   17 13 *                     30.0 24 0 4 0   0     0   2   17 13                 30
1680384 1680384 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_5 60 2 10 0   4     0   8   49 35 *                     84.0 60 2 10 0   4     0   8   49 35                 84
1680370 1680370 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 2021   grade_5 57 5 13 0   2     0   3   33 47 *                     80.0 57 5 13 0   2     0   3   33 47                 80
1680363 1680363 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202731 6160001 Ayer Shirley School District - Lura A. White Elementary School   Regular School No Elementary KG 05 2021   grade_5 45 1 7 0   1     0   3   26 31 *                     57.0 45 1 7 0   1     0   3   26 31                 57
1680349 1680349 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_5 74 1 14 0   1     0   5   47 48 *                     95.0 74 1 14 0   1     0   5   47 48                 95
1680347 1680347 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston - Royalston Community School   Regular School No Elementary KG 06 2021   grade_5 23 0 0 0   0     0   0   11 12 *                     23.0 23 0 0 0   0     0   0   11 12                 23
1680327 1680327 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Ashburnham-Westminster - Briggs Elementary   Regular School No Elementary PK 05 2021   grade_5 67 0 5 0   0     0   2   37 37 *                     74.0 67 0 5 0   0     0   2   37 37                 74
1680318 1680318 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster - Westminster Elementary   Regular School No Elementary 02 05 2021   grade_5 97 2 4 0   0     0   1   55 49 *                     104.0 97 2 4 0   0     0   1   55 49                 104
1680300 1680300 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_5 70 3 2 0   0     0   1   29 47 *                     76.0 70 3 2 0   0     0   1   29 47                 76
1680285 1680285 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough - Luther Conant School   Regular School No Elementary KG 06 2021   grade_5 13 1 4 0   28     0   1   28 19 *                     47.0 13 1 4 0   28     0   1   28 19                 47
1680278 1680278 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough - Paul P Gates Elementary School   Regular School No Elementary KG 06 2021   grade_5 12 4 3 0   52     0   0   42 29 *                     71.0 12 4 3 0   52     0   0   42 29                 71
1680271 1680271 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough - C.T. Douglas Elementary School   Regular School No Elementary KG 06 2021   grade_5 45 3 2 0   12     0   4   31 35 *                     66.0 45 3 2 0   12     0   4   31 35                 66
1680264 1680264 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough - McCarthy-Towne School   Regular School No Elementary KG 06 2021   grade_5 49 2 3 0   14     0   3   31 40 *                     71.0 49 2 3 0   14     0   3   31 40                 71
1680257 1680257 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough - Merriam School   Regular School No Elementary KG 06 2021   grade_5 50 1 4 0   11     0   5   40 31 *                     71.0 50 1 4 0   11     0   5   40 31                 71
1680250 1680250 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough - Blanchard Memorial School   Regular School No Elementary KG 06 2021   grade_5 34 2 2 0   23     0   3   36 28 *                     64.0 34 2 2 0   23     0   3   36 28                 64
1680233 1680233 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 2021   grade_5 7 27 67 1   2     1   6   54 57 *                     111.0 7 27 67 1   2     1   6   54 57                 111
1680225 1680225 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 2021   grade_5 17 5 8 0   9     0   5   22 22 *                     44.0 17 5 8 0   9     0   5   22 22                 44
1680212 1680212 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 2021   grade_5 30 8 44 2   2     0   3   39 50 *                     89.0 30 8 44 2   2     0   3   39 50                 89
1680204 1680204 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District) - Pioneer Charter School of Science   Regular School Yes Other KG 12 2021   grade_5 21 20 19 1   4     0   0   36 29 *                     65.0 21 20 19 1   4     0   0   36 29                 65
1680195 1680195 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 2021   grade_5 2 21 36 0   0     0   0   27 32 *                     59.0 2 21 36 0   0     0   0   27 32                 59
1680182 1680182 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_5 87 6 11 0   2     0   4   47 63 *                     110.0 87 6 11 0   2     0   4   47 63                 110

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