Data source: Big Local News · About: Big Local

889 rows where grade = "grade_5", state = "MA" and year = 2021 sorted by hispanic

View and edit SQL

year

  • 2021 · 889

grade

  • grade_5 · 889
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
1673282 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673451 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_5 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674755 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_5 * * * *   *     *   *   * * *                     1.0                                             1
1675612 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_5 * * * *   *     *   *   1 * *                     2.0                         1                   2
1675703 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1677633 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe - Rowe Elementary   Regular School No Elementary PK 06 2021   grade_5 * * * *   *     *   *   1 4 *                     5.0                         1 4                 5
1677742 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy - Emma L Miller Elementary School   Regular School No Elementary PK 06 2021   grade_5 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1678251 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield - Springfield International Academy at Johnson   Regular School No Elementary 03 05 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1672501 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_5 8 2 0 0   0     0   4   8 6 *                     14.0 8 2 0 0   0     0   4   8 6                 14
1673635 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge - Cambridgeport   Regular School No Elementary PK 05 2021   grade_5 25 9 0 0   1     0   3   20 18 *                     38.0 25 9 0 0   1     0   3   20 18                 38
1673978 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   grade_5 19 0 0 0   0     0   1   8 12 *                     20.0 19 0 0 0   0     0   1   8 12                 20
1674429 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_5 6 0 0 0   0     0   1   6 1 *                     7.0 6 0 0 0   0     0   1   6 1                 7
1674529 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_5 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1674851 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_5 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1675408 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_5 14 0 0 0   0     0   1   9 6 *                     15.0 14 0 0 0   0     0   1   9 6                 15
1676007 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield - Eames Way School   Regular School No Elementary KG 05 2021   grade_5 36 0 0 0   0     0   1   21 16 *                     37.0 36 0 0 0   0     0   1   21 16                 37
1676020 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield - Daniel Webster   Regular School No Elementary PK 05 2021   grade_5 50 0 0 1   1     1   0   23 30 *                     53.0 50 0 0 1   1     1   0   23 30                 53
1676166 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Melrose - Horace Mann   Regular School No Elementary KG 05 2021   grade_5 37 3 0 0   0     0   2   18 24 *                     42.0 37 3 0 0   0     0   2   18 24                 42
1676859 MA Bristol   school 2508730 212   North Attleborough 250873001408 2120015 North Attleborough - Roosevelt Avenue   Regular School No Elementary KG 05 2021   grade_5 30 1 0 0   1     0   4   15 21 *                     36.0 30 1 0 0   1     0   4   15 21                 36
1676879 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Northborough - Lincoln Street   Regular School No Elementary KG 05 2021   grade_5 38 0 0 1   4     1   2   19 27 *                     46.0 38 0 0 1   4     1   2   19 27                 46
1676981 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Norwell - Grace Farrar Cole   Regular School No Elementary PK 05 2021   grade_5 76 1 0 0   0     0   2   42 37 *                     79.0 76 1 0 0   0     0   2   42 37                 79
1677157 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Pembroke - Bryantville Elementary   Regular School No Elementary KG 06 2021   grade_5 63 0 0 0   1     0   3   35 32 *                     67.0 63 0 0 0   1     0   3   35 32                 67
1677164 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Pembroke - Hobomock Elementary   Regular School No Elementary KG 06 2021   grade_5 69 0 0 0   1     0   2   39 33 *                     72.0 69 0 0 0   1     0   2   39 33                 72
1677186 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham - Petersham Center   Regular School No Elementary KG 06 2021   grade_5 14 0 0 0   0     0   2   11 5 *                     16.0 14 0 0 0   0     0   2   11 5                 16
1677486 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Reading - Birch Meadow   Regular School No Elementary KG 05 2021   grade_5 54 1 0 0   1     0   1   34 23 *                     57.0 54 1 0 0   1     0   1   34 23                 57
1677504 MA Middlesex   school 2509990 246   Reading 250999001958 2460020 Reading - Wood End Elementary School   Regular School No Elementary KG 05 2021   grade_5 43 1 0 0   1     0   1   30 16 *                     46.0 43 1 0 0   1     0   1   30 16                 46
1677621 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport - Rockport Elementary   Regular School No Elementary PK 05 2021   grade_5 64 0 0 0   0     0   0   32 32 *                     64.0 64 0 0 0   0     0   0   32 32                 64
1678671 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales - Wales Elementary   Regular School No Elementary PK 06 2021   grade_5 23 0 0 1   0     0   0   9 15 *                     24.0 23 0 0 1   0     0   0   9 15                 24
1678840 MA Middlesex   school 2512210 315   Wayland 251221000153 3150020 Wayland - Loker School   Regular School No Elementary KG 05 2021   grade_5 30 0 0 0   12     0   2   25 19 *                     44.0 30 0 0 0   12     0   2   25 19                 44
1678919 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet - Wellfleet Elementary   Regular School No Elementary KG 05 2021   grade_5 12 0 0 0   0     0   3   7 8 *                     15.0 12 0 0 0   0     0   3   7 8                 15
1679149 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Westwood - Martha Jones   Regular School No Elementary KG 05 2021   grade_5 41 0 0 0   4     0   3   23 25 *                     48.0 41 0 0 0   4     0   3   23 25                 48
1679235 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg - Anne T. Dunphy School   Regular School No Elementary PK 06 2021   grade_5 23 1 0 0   0     0   0   13 11 *                     24.0 23 1 0 0   0     0   0   13 11                 24
1679686 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington - R. H. Conwell   Regular School No Elementary PK 06 2021   grade_5 9 0 0 0   0     0   0   2 7 *                     9.0 9 0 0 0   0     0   0   2 7                 9
1679954 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   grade_5 68 5 0 0   18     0   5   49 47 *                     96.0 68 5 0 0   18     0   5   49 47                 96
1679971 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District) - Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2021   grade_5 21 0 0 0   0     0   1   10 12 *                     22.0 21 0 0 0   0     0   1   10 12                 22
1680111 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District) - River Valley Charter School   Regular School Yes Elementary KG 08 2021   grade_5 31 0 0 0   0     0   1   10 22 *                     32.0 31 0 0 0   0     0   1   10 22                 32
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1672126 MA Essex   school 2501950 9   Andover 250195000048 90010 Andover - Henry C Sanborn Elementary   Regular School No Elementary KG 05 2021   grade_5 51 1 1 0   17     0   2   36 36 *                     72.0 51 1 1 0   17     0   2   36 36                 72
1672158 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_5 42 0 1 0   14     2   6   31 34 *                     65.0 42 0 1 0   14     2   6   31 34                 65
1673373 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_5 29 0 1 0   1     0   0   21 10 *                     31.0 29 0 1 0   1     0   0   21 10                 31
1673494 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_5 40 0 1 0   0     0   0   19 22 *                     41.0 40 0 1 0   0     0   0   19 22                 41
1673915 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_5 20 0 1 0   0     0   1   8 14 *                     22.0 20 0 1 0   0     0   1   8 14                 22
1673936 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Cohasset - Deer Hill   Regular School No Elementary 03 05 2021   grade_5 88 2 1 0   3     0   0   47 47 *                     94.0 88 2 1 0   3     0   0   47 47                 94
1674011 MA Essex   school 2503990 71   Danvers 250399000538 710045 Danvers - Willis E Thorpe   Regular School No Elementary PK 05 2021   grade_5 44 1 1 0   1     0   0   24 23 *                     47.0 44 1 1 0   1     0   0   24 23                 47
1674173 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_5 25 3 1 0   1     0   0   14 16 *                     30.0 25 3 1 0   1     0   0   14 16                 30
1674254 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving - Erving Elementary   Regular School No Elementary PK 06 2021   grade_5 19 0 1 0   0     0   1   12 9 *                     21.0 19 0 1 0   0     0   1   12 9                 21
1674638 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Franklin - Helen Keller Elementary   Regular School No Elementary KG 05 2021   grade_5 63 4 1 0   3     1   0   42 30 *                     72.0 63 4 1 0   3     1   0   42 30                 72
1674662 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_5 33 0 1 0   0     0   0   16 18 *                     34.0 33 0 1 0   0     0   0   16 18                 34
1674982 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Hingham - Plymouth River   Regular School No Elementary KG 05 2021   grade_5 68 2 1 0   2     0   2   34 41 *                     75.0 68 2 1 0   2     0   2   34 41                 75
1675434 MA Middlesex   school 2506840 155   Lexington 250684000996 1550015 Lexington - Fiske   Regular School No Elementary KG 05 2021   grade_5 57 1 1 0   24     0   6   51 38 *                     89.0 57 1 1 0   24     0   6   51 38                 89
1675512 MA Hampden   school 2506990 159   Longmeadow 250699001022 1590025 Longmeadow - Wolf Swamp Road   Regular School No Elementary PK 05 2021   grade_5 43 2 1 0   3     0   3   25 27 *                     52.0 43 2 1 0   3     0   3   25 27                 52
1675967 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Marion - Sippican   Regular School No Elementary PK 06 2021   grade_5 49 4 1 0   1     0   5   30 30 *                     60.0 49 4 1 0   1     0   5   30 30                 60
1676026 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Marshfield - Gov Edward Winslow   Regular School No Elementary KG 05 2021   grade_5 70 0 1 0   0     0   2   26 47 *                     73.0 70 0 1 0   0     0   2   26 47                 73
1676360 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant - Johnson   Regular School No Elementary PK 06 2021   grade_5 18 0 1 0   0     0   1   8 12 *                     20.0 18 0 1 0   0     0   1   8 12                 20
1676697 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 Newton - John Ward   Regular School No Elementary KG 05 2021   grade_5 31 0 1 0   6     0   4   20 22 *                     42.0 31 0 1 0   6     0   4   20 22                 42
1676847 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 North Attleborough - Falls   Regular School No Elementary KG 05 2021   grade_5 40 1 1 0   1     0   2   25 20 *                     45.0 40 1 1 0   1     0   2   25 20                 45
1677137 MA Essex   school 2509360 229   Peabody 250936001505 2290045 Peabody - West Memorial   Regular School No Elementary PK 05 2021   grade_5 35 0 1 0   0     0   1   24 13 *                     37.0 35 0 1 0   0     0   1   24 13                 37
1677172 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 Pembroke - North Pembroke Elementary   Regular School No Elementary PK 06 2021   grade_5 63 2 1 0   0     0   4   35 35 *                     70.0 63 2 1 0   0     0   4   35 35                 70
1677208 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Pittsfield - Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2021   grade_5 19 1 1 0   0     0   3   11 13 *                     24.0 19 1 1 0   0     0   3   11 13                 24
1677298 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Plymouth - Manomet Elementary   Regular School No Elementary KG 05 2021   grade_5 29 1 1 0   0     0   2   11 22 *                     33.0 29 1 1 0   0     0   2   11 22                 33
1677336 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton - Dennett Elementary   Regular School No Elementary KG 06 2021   grade_5 37 0 1 0   0     0   0   19 19 *                     38.0 37 0 1 0   0     0   0   19 19                 38
1677407 MA Norfolk   school 2509870 243   Quincy 250987001583 2430095 Quincy - Squantum   Regular School No Elementary KG 05 2021   grade_5 21 4 1 0   17     0   0   23 20 *                     43.0 21 4 1 0   17     0   0   23 20                 43
1677498 MA Middlesex   school 2509990 246   Reading 250999001608 2460017 Reading - J Warren Killam   Regular School No Elementary KG 05 2021   grade_5 62 3 1 0   4     0   0   39 31 *                     70.0 62 3 1 0   4     0   0   39 31                 70
1677755 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Scituate - Hatherly Elementary   Regular School No Elementary KG 05 2021   grade_5 47 2 1 0   0     0   0   26 24 *                     50.0 47 2 1 0   0     0   0   26 24                 50
1677866 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury - Shutesbury Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 1 0   0     0   1   6 6 *                     12.0 10 0 1 0   0     0   1   6 6                 12
1678420 MA Middlesex   school 2511340 288   Sudbury 251134001876 2880010 Sudbury - Josiah Haynes   Regular School No Elementary KG 05 2021   grade_5 47 1 1 0   6     0   8   34 29 *                     63.0 47 1 1 0   6     0   8   34 29                 63
1678869 MA Norfolk   school 2512270 317   Wellesley 251227002025 3170005 Wellesley - Katharine Lee Bates   Regular School No Elementary KG 05 2021   grade_5 39 2 1 0   6     0   5   20 33 *                     53.0 39 2 1 0   6     0   5   20 33                 53
1678899 MA Norfolk   school 2512270 317   Wellesley 251227001733 3170048 Wellesley - Sprague Elementary School   Regular School No Elementary KG 05 2021   grade_5 34 2 1 0   12     0   5   34 20 *                     54.0 34 2 1 0   12     0   5   34 20                 54
1679017 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Westford - Abbot Elementary   Regular School No Elementary 03 05 2021   grade_5 94 0 1 0   38     0   5   63 75 *                     138.0 94 0 1 0   38     0   5   63 75                 138
1679053 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton - Westhampton Elementary School   Regular School No Elementary PK 06 2021   grade_5 15 0 1 0   0     0   1   9 8 *                     17.0 15 0 1 0   0     0   1   9 8                 17
1679227 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately - Whately Elementary   Regular School No Elementary PK 06 2021   grade_5 10 0 1 0   0     0   0   6 5 *                     11.0 10 0 1 0   0     0   0   6 5                 11
1679300 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Winchester - Muraco Elementary   Regular School No Elementary KG 05 2021   grade_5 40 1 1 1   17     0   6   31 35 *                     66.0 40 1 1 1   17     0   6   31 35                 66
1679306 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Winchester - Ambrose Elementary   Regular School No Elementary KG 05 2021   grade_5 59 0 1 0   9     0   4   33 40 *                     73.0 59 0 1 0   9     0   4   33 40                 73
1679354 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Woburn - Clyde Reeves   Regular School No Elementary PK 05 2021   grade_5 33 4 1 0   6     0   2   27 19 *                     46.0 33 4 1 0   6     0   2   27 19                 46
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
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
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
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
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
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
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
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
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
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
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

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