enrollments

Data source: Big Local News · About: Big Local

954 rows where grade = "grade_4", state = "MA" and year = 2019 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 954 ✖

grade ✖

  • grade_4 · 954 ✖
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
2049366 2049366 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 2019   grade_4 35 8 14 0   2     0   11   35 35                       70.0 35 8 14 0   2     0   11   35 35                 70
2049353 2049353 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_4 18 6 8 0   1     0   0   20 13                       33.0 18 6 8 0   1     0   0   20 13                 33
2049336 2049336 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 04 2019   grade_4 36 2 2 0   0     0   0   20 20                       40.0 36 2 2 0   0     0   0   20 20                 40
2049323 2049323 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_4 13 7 34 0   3     0   0   26 31                       57.0 13 7 34 0   3     0   0   26 31                 57
2049318 2049318 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   grade_4 10 12 33 0   0     0   3   30 28                       58.0 10 12 33 0   0     0   3   30 28                 58
2049290 2049290 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 2019   grade_4 0 45 26 0   1     1   0   40 33                       73.0 0 45 26 0   1     1   0   40 33                 73
2049276 2049276 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_4 13 16 44 1   19     0   1   45 49                       94.0 13 16 44 1   19     0   1   45 49                 94
2049132 2049132 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2019   grade_4 99 0 6 0   2     0   3   58 52                       110.0 99 0 6 0   2     0   3   58 52                 110
2049126 2049126 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2019   grade_4 67 4 3 1   0     1   4   45 35                       80.0 67 4 3 1   0     1   4   45 35                 80
2049120 2049120 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2019   grade_4 70 0 7 1   1     0   1   48 32                       80.0 70 0 7 1   1     0   1   48 32                 80
2049107 2049107 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_4 40 0 1 0   0     0   4   21 24                       45.0 40 0 1 0   0     0   4   21 24                 45
2049099 2049099 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2019   grade_4 61 0 5 0   0     0   6   37 35                       72.0 61 0 5 0   0     0   6   37 35                 72
2049077 2049077 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Glenwood Elementary School   Regular School No Elementary 03 05 2019   grade_4 97 2 3 2   1     0   4   56 53                       109.0 97 2 3 2   1     0   4   56 53                 109
2049071 2049071 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2019   grade_4 48 0 1 0   0     0   0   22 27                       49.0 48 0 1 0   0     0   0   22 27                 49
2049062 2049062 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2019   grade_4 47 2 5 0   2     0   0   33 23                       56.0 47 2 5 0   2     0   0   33 23                 56
2049056 2049056 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No Elementary KG 05 2019   grade_4 72 3 5 0   3     0   0   45 38                       83.0 72 3 5 0   3     0   0   45 38                 83
2049051 2049051 MA Worcester   school 2511880 775   Wachusett 251188001476 7750027 Houghton Elementary   Regular School No Elementary KG 04 2019   grade_4 64 1 2 0   1     0   3   45 26                       71.0 64 1 2 0   1     0   3   45 26                 71
2049045 2049045 MA Worcester   school 2511880 775   Wachusett 251188000884 7750020 Dawson   Regular School No Elementary KG 05 2019   grade_4 66 4 3 0   5     0   3   41 40                       81.0 66 4 3 0   5     0   3   41 40                 81
2049039 2049039 MA Worcester   school 2511880 775   Wachusett 251188001607 7750018 Davis Hill Elementary   Regular School No Elementary KG 05 2019   grade_4 66 3 4 0   3     0   2   46 32                       78.0 66 3 4 0   3     0   2   46 32                 78
2049026 2049026 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_4 31 1 3 1   0     0   2   17 21                       38.0 31 1 3 1   0     0   2   17 21                 38
2049019 2049019 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2019   grade_4 8 0 1 0   0     0   2   6 5                       11.0 8 0 1 0   0     0   2   6 5                 11
2049006 2049006 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2019   grade_4 64 1 2 0   0     0   5   40 32                       72.0 64 1 2 0   0     0   5   40 32                 72
2048998 2048998 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2019   grade_4 52 1 1 0   1     0   0   28 27                       55.0 52 1 1 0   1     0   0   28 27                 55
2048990 2048990 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2019   grade_4 60 1 2 0   1     0   0   38 26                       64.0 60 1 2 0   1     0   0   38 26                 64
2048964 2048964 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2019   grade_4 73 1 11 0   1     0   1   45 42                       87.0 73 1 11 0   1     0   1   45 42                 87
2048957 2048957 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_4 15 0 1 1   0     0   2   9 10                       19.0 15 0 1 1   0     0   2   9 10                 19
2048942 2048942 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_4 105 1 6 1   1     0   5   63 56                       119.0 105 1 6 1   1     0   5   63 56                 119
2048928 2048928 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2019   grade_4 25 1 3 0   0     0   2   20 11                       31.0 25 1 3 0   0     0   2   20 11                 31
2048921 2048921 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2019   grade_4 15 0 0 1   0     0   0   7 9                       16.0 15 0 0 1   0     0   0   7 9                 16
2048882 2048882 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   grade_4 68 1 2 0   1     0   3   38 37                       75.0 68 1 2 0   1     0   3   38 37                 75
2048874 2048874 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_4 29 0 1 0   0     0   0   9 21                       30.0 29 0 1 0   0     0   0   9 21                 30
2048867 2048867 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_4 42 1 2 0   0     0   0   21 24                       45.0 42 1 2 0   0     0   0   21 24                 45
2048860 2048860 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_4 21 0 2 1   0     0   0   11 13                       24.0 21 0 2 1   0     0   0   11 13                 24
2048847 2048847 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary PK 06 2019   grade_4 8 0 1 0   0     0   1   4 6                       10.0 8 0 1 0   0     0   1   4 6                 10
2048839 2048839 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2019   grade_4 22 0 1 0   0     0   1   10 14                       24.0 22 0 1 0   0     0   1   10 14                 24
2048833 2048833 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 04 2019   grade_4 5 0 1 0   0     0   0   3 3                       6.0 5 0 1 0   0     0   0   3 3                 6
2048826 2048826 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2019   grade_4 20 0 0 0   0     0   3   10 13                       23.0 20 0 0 0   0     0   3   10 13                 23
2048808 2048808 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2019   grade_4 50 1 3 0   2     0   1   37 20                       57.0 50 1 3 0   2     0   1   37 20                 57
2048800 2048800 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No Elementary 03 06 2019   grade_4 43 0 5 0   1     0   3   28 24                       52.0 43 0 5 0   1     0   3   28 24                 52
2048796 2048796 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Elmer S Bagnall   Regular School No Elementary PK 06 2019   grade_4 67 0 3 0   0     0   0   40 30                       70.0 67 0 3 0   0     0   0   40 30                 70
2048774 2048774 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2019   grade_4 101 1 4 0   2     0   3   55 56                       111.0 101 1 4 0   2     0   3   55 56                 111
2048765 2048765 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No Elementary KG 04 2019   grade_4 36 0 2 0   0     0   0   20 18                       38.0 36 0 2 0   0     0   0   20 18                 38
2048760 2048760 MA Middlesex   school 2508790 735   North Middlesex 250879000621 7350005 Spaulding Memorial   Regular School No Elementary KG 04 2019   grade_4 74 2 6 0   1     0   5   45 43                       88.0 74 2 6 0   1     0   5   45 43                 88
2048747 2048747 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2019   grade_4 13 0 1 0   0     0   1   5 10                       15.0 13 0 1 0   0     0   1   5 10                 15
2048726 2048726 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2019   grade_4 57 0 1 0   5     0   4   31 36                       67.0 57 0 1 0   5     0   4   31 36                 67
2048719 2048719 MA Middlesex   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2019   grade_4 87 2 4 0   7     0   4   50 54                       104.0 87 2 4 0   7     0   4   50 54                 104
2048712 2048712 MA Worcester   school 2508310 725   Nashoba 250831000948 7250010 Mary Rowlandson Elementary   Regular School No Elementary PK 05 2019   grade_4 80 4 8 1   1     0   0   46 48                       94.0 80 4 8 1   1     0   0   46 48                 94
2048695 2048695 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2019   grade_4 85 1 6 0   0     1   7   48 52                       100.0 85 1 6 0   0     1   7   48 52                 100
2048692 2048692 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary PK 04 2019   grade_4 13 0 1 0   0     0   1   10 5                       15.0 13 0 1 0   0     0   1   10 5                 15
2048677 2048677 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2019   grade_4 15 0 1 1   0     0   1   9 9                       18.0 15 0 1 1   0     0   1   9 9                 18
2048669 2048669 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2019   grade_4 17 0 1 0   0     0   0   10 8                       18.0 17 0 1 0   0     0   0   10 8                 18
2048661 2048661 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2019   grade_4 32 0 2 0   0     0   1   21 14                       35.0 32 0 2 0   0     0   1   21 14                 35
2048646 2048646 MA Berkshire   school 2508160 715   Mount Greylock 250816002899 7150010 Williamstown Elementary   Regular School No Elementary PK 06 2019   grade_4 58 0 1 0   0     0   3   32 30                       62.0 58 0 1 0   0     0   3   32 30                 62
2048638 2048638 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2019   grade_4 21 1 2 0   0     0   1   8 17                       25.0 21 1 2 0   0     0   1   8 17                 25
2048623 2048623 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2019   grade_4 90 3 7 1   0     0   7   52 56                       108.0 90 3 7 1   0     0   7   52 56                 108
2048617 2048617 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2019   grade_4 50 3 1 0   0     0   1   23 32                       55.0 50 3 1 0   0     0   1   23 32                 55
2048606 2048606 MA Worcester   school 2507680 710   Mendon-Upton 250768001200 7100179 Henry P Clough   Regular School No Elementary PK 04 2019   grade_4 62 0 3 0   0     0   1   35 31                       66.0 62 0 3 0   0     0   1   35 31                 66
2048596 2048596 MA Worcester   school 2507680 710   Mendon-Upton 250768001277 7100001 Memorial School   Regular School No Elementary PK 04 2019   grade_4 87 0 4 0   3     0   1   56 39                       95.0 87 0 4 0   3     0   1   56 39                 95
2048572 2048572 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Essex Elementary   Regular School No Elementary KG 05 2019   grade_4 37 0 1 0   0     0   1   19 20                       39.0 37 0 1 0   0     0   1   19 20                 39
2048566 2048566 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Memorial Elementary   Regular School No Elementary PK 05 2019   grade_4 57 1 1 0   0     0   0   37 22                       59.0 57 1 1 0   0     0   0   37 22                 59
2048547 2048547 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2019   grade_4 17 0 1 0   0     0   1   11 8                       19.0 17 0 1 0   0     0   1   11 8                 19
2048523 2048523 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002139 6800030 Soule Road   Regular School No Elementary 04 05 2019   grade_4 131 3 14 0   5     0   8   84 77                       161.0 131 3 14 0   5     0   8   84 77                 161
2048515 2048515 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2019   grade_4 40 0 2 0   0     0   2   17 27                       44.0 40 0 2 0   0     0   2   17 27                 44
2048501 2048501 MA Essex   school 2505670 675   Hamilton-Wenham 250567000821 6750015 Winthrop School   Regular School No Elementary PK 05 2019   grade_4 47 0 2 0   1     0   1   26 25                       51.0 47 0 2 0   1     0   1   26 25                 51
2048494 2048494 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2019   grade_4 41 0 0 0   0     3   1   23 22                       45.0 41 0 0 0   0     3   1   23 22                 45
2048488 2048488 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No Elementary KG 05 2019   grade_4 36 0 3 0   1     0   1   24 17                       41.0 36 0 3 0   1     0   1   24 17                 41
2048475 2048475 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2019   grade_4 47 0 6 0   0     0   4   32 25                       57.0 47 0 6 0   0     0   4   32 25                 57
2048467 2048467 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2019   grade_4 15 1 1 0   0     0   2   8 11                       19.0 15 1 1 0   0     0   2   8 11                 19
2048453 2048453 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2019   grade_4 96 2 2 0   12     1   3   55 61                       116.0 96 2 2 0   12     1   3   55 61                 116
2048448 2048448 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000806 6730005 Swallow/Union School   Regular School No Elementary KG 04 2019   grade_4 72 0 0 0   5     0   0   40 37                       77.0 72 0 0 0   5     0   0   40 37                 77
2048433 2048433 MA Hampshire   school 2505160 672   Gateway 250516000761 6720143 Littleville Elementary School   Regular School No Elementary PK 05 2019   grade_4 55 1 1 0   0     0   2   30 29                       59.0 55 1 1 0   0     0   2   30 29                 59
2048426 2048426 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2019   grade_4 14 1 1 0   0     0   0   8 8                       16.0 14 1 1 0   0     0   0   8 8                 16
2048404 2048404 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No Middle 04 06 2019   grade_4 198 3 0 0   1     0   4   118 88                       206.0 198 3 0 0   1     0   4   118 88                 206
2048392 2048392 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2019   grade_4 11 0 0 0   0     0   0   7 4                       11.0 11 0 0 0   0     0   0   7 4                 11
2048365 2048365 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No Elementary 02 04 2019   grade_4 130 4 13 1   0     0   6   84 70                       154.0 130 4 13 1   0     0   6   84 70                 154
2048356 2048356 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2019   grade_4 118 1 12 0   0     0   5   81 55                       136.0 118 1 12 0   0     0   5   81 55                 136
2048332 2048332 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary PK 04 2019   grade_4 95 2 5 0   2     0   3   47 60                       107.0 95 2 5 0   2     0   3   47 60                 107
2048326 2048326 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002427 6500005 Dighton Elementary   Regular School No Elementary PK 04 2019   grade_4 78 3 2 0   2     0   2   48 39                       87.0 78 3 2 0   2     0   2   48 39                 87
2048312 2048312 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2019   grade_4 170 19 20 8   2     0   28   123 124                       247.0 170 19 20 8   2     0   28   123 124                 247
2048284 2048284 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2019   grade_4 13 0 0 0   0     0   0   6 7                       13.0 13 0 0 0   0     0   0   6 7                 13
2048277 2048277 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary KG 05 2019   grade_4 59 0 2 0   1     0   7   45 24                       69.0 59 0 2 0   1     0   7   45 24                 69
2048271 2048271 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2019   grade_4 19 0 2 0   0     0   1   13 9                       22.0 19 0 2 0   0     0   1   13 9                 22
2048264 2048264 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_4 15 0 1 1   0     0   0   8 9                       17.0 15 0 1 1   0     0   0   8 9                 17
2048241 2048241 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2019   grade_4 197 15 1 0   3     0   11   113 114                       227.0 197 15 1 0   3     0   11   113 114                 227
2048240 2048240 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2019   grade_4 148 10 0 1   4     0   6   76 93                       169.0 148 10 0 1   4     0   6   76 93                 169
2048221 2048221 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2019   grade_4 76 1 6 0   0     0   7   50 40                       90.0 76 1 6 0   0     0   7   50 40                 90
2048218 2048218 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Millville Elementary   Regular School No Elementary PK 05 2019   grade_4 35 0 3 0   1     0   0   21 18                       39.0 35 0 3 0   1     0   0   21 18                 39
2048193 2048193 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No Elementary PK 04 2019   grade_4 49 0 6 0   1     0   4   32 28                       60.0 49 0 6 0   1     0   4   32 28                 60
2048179 2048179 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202736 6160002 Page Hilltop Elementary School   Regular School No Elementary PK 05 2019   grade_4 61 5 10 1   3     1   2   51 32                       83.0 61 5 10 1   3     1   2   51 32                 83
2048172 2048172 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202731 6160001 Lura A. White Elementary School   Regular School No Elementary PK 05 2019   grade_4 53 2 5 0   1     0   0   37 24                       61.0 53 2 5 0   1     0   0   37 24                 61
2048155 2048155 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2019   grade_4 18 0 0 0   0     0   1   5 14                       19.0 18 0 0 0   0     0   1   5 14                 19
2048150 2048150 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2019   grade_4 76 0 7 0   3     0   5   55 36                       91.0 76 0 7 0   3     0   5   55 36                 91
2048135 2048135 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No Elementary PK 05 2019   grade_4 76 1 11 0   2     0   2   41 51                       92.0 76 1 11 0   2     0   2   41 51                 92
2048126 2048126 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2019   grade_4 78 0 6 0   1     0   7   50 42                       92.0 78 0 6 0   1     0   7   50 42                 92
2048107 2048107 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_4 90 6 4 0   1     1   4   55 51                       106.0 90 6 4 0   1     1   4   55 51                 106
2048092 2048092 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2019   grade_4 14 2 2 0   30     0   2   27 23                       50.0 14 2 2 0   30     0   2   27 23                 50
2048085 2048085 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2019   grade_4 22 1 3 1   39     0   1   33 34                       67.0 22 1 3 1   39     0   1   33 34                 67
2048078 2048078 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2019   grade_4 48 0 0 0   15     1   5   40 29                       69.0 48 0 0 0   15     1   5   40 29                 69
2048071 2048071 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2019   grade_4 48 4 14 2   12     0   4   39 45                       84.0 48 4 14 2   12     0   4   39 45                 84
2048064 2048064 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2019   grade_4 48 1 5 0   16     0   1   38 33                       71.0 48 1 5 0   16     0   1   38 33                 71

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