enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 854 ✖

grade ✖

  • grade_4 · 854 ✖
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
2045698 2045698 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Chace Street   Regular School No Elementary PK 05 2019   grade_4 48 0 2 0   1     0   1   30 22                       52.0 48 0 2 0   1     0   1   30 22                 52
2045704 2045704 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2019   grade_4 68 0 0 0   0     0   4   36 36                       72.0 68 0 0 0   0     0   4   36 36                 72
2045798 2045798 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No Elementary PK 06 2019   grade_4 53 0 3 0   0     0   2   33 25                       58.0 53 0 3 0   0     0   2   33 25                 58
2045820 2045820 MA Worcester   school 2511010 277   Southbridge 251101001770 2770020 West Street   Regular School No Elementary 02 05 2019   grade_4 31 0 43 0   1     0   1   41 35                       76.0 31 0 43 0   1     0   1   41 35                 76
2046255 2046255 MA Middlesex   school 2511340 288   Sudbury 251134001877 2880030 Peter Noyes   Regular School No Elementary PK 05 2019   grade_4 65 0 1 0   9     0   9   42 42                       84.0 65 0 1 0   9     0   9   42 42                 84
2046286 2046286 MA Essex   school 2511430 291   Swampscott 251143001883 2910005 Clarke   Regular School No Elementary KG 04 2019   grade_4 28 0 7 0   4     0   1   15 25                       40.0 28 0 7 0   4     0   1   15 25                 40
2046318 2046318 MA Bristol   school 2511460 292   Swansea 251146001895 2920020 Joseph G Luther   Regular School No Elementary 03 05 2019   grade_4 70 0 2 1   2     0   6   39 42                       81.0 70 0 2 1   2     0   6   39 42                 81
2046408 2046408 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_4 20 0 6 0   0     0   0   14 12                       26.0 20 0 6 0   0     0   0   14 12                 26
2046413 2046413 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Middle 04 06 2019   grade_4 88 0 1 1   2     0   0   44 48                       92.0 88 0 1 1   2     0   0   44 48                 92
2046426 2046426 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2019   grade_4 9 0 1 0   0     0   2   9 3                       12.0 9 0 1 0   0     0   2   9 3                 12
2046464 2046464 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Dolbeare   Regular School No Elementary KG 04 2019   grade_4 78 0 5 0   2     0   2   49 38                       87.0 78 0 5 0   2     0   2   49 38                 87
2046479 2046479 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No Elementary KG 04 2019   grade_4 41 0 4 0   2     0   2   26 23                       49.0 41 0 4 0   2     0   2   26 23                 49
2046493 2046493 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   grade_4 13 0 0 0   0     0   2   5 10                       15.0 13 0 0 0   0     0   2   5 10                 15
2046589 2046589 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2019   grade_4 79 0 9 1   1     0   9   49 50                       99.0 79 0 9 1   1     0   9   49 50                 99
2046709 2046709 MA Norfolk   school 2512270 317   Wellesley 251227002022 3170025 Hunnewell   Regular School No Elementary KG 05 2019   grade_4 37 0 1 0   3     0   8   26 23                       49.0 37 0 1 0   3     0   8   26 23                 49
2046742 2046742 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   grade_4 14 0 1 0   0     0   0   9 6                       15.0 14 0 1 0   0     0   0   9 6                 15
2046842 2046842 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No Elementary 03 05 2019   grade_4 57 0 1 0   63     0   7   66 62                       128.0 57 0 1 0   63     0   7   66 62                 128
2046873 2046873 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2019   grade_4 19 0 0 0   1     0   0   10 10                       20.0 19 0 0 0   1     0   0   10 10                 20
2046900 2046900 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2019   grade_4 110 0 4 1   1     0   9   60 65                       125.0 110 0 4 1   1     0   9   60 65                 125
2046936 2046936 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No Elementary KG 05 2019   grade_4 45 0 8 0   2     0   1   28 28                       56.0 45 0 8 0   2     0   1   28 28                 56
2046950 2046950 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No Elementary KG 05 2019   grade_4 30 0 1 0   5     0   4   21 19                       40.0 30 0 1 0   5     0   4   21 19                 40
2046956 2046956 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Downey   Regular School No Elementary PK 05 2019   grade_4 29 0 3 0   5     0   2   19 20                       39.0 29 0 3 0   5     0   2   19 20                 39
2046962 2046962 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No Elementary KG 05 2019   grade_4 30 0 1 0   4     0   3   22 16                       38.0 30 0 1 0   4     0   3   22 16                 38
2046968 2046968 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Martha Jones   Regular School No Elementary KG 05 2019   grade_4 41 0 3 0   4     0   1   24 25                       49.0 41 0 3 0   4     0   1   24 25                 49
2046974 2046974 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 William E Sheehan   Regular School No Elementary KG 05 2019   grade_4 57 0 3 0   5     0   2   31 36                       67.0 57 0 3 0   5     0   2   31 36                 67
2047006 2047006 MA Norfolk   school 2512840 336   Weymouth 251284002114 3360065 Lawrence W Pingree   Regular School No Elementary KG 04 2019   grade_4 30 0 5 0   2     0   1   18 20                       38.0 30 0 5 0   2     0   1   18 20                 38
2047039 2047039 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   grade_4 16 0 0 0   0     0   1   9 8                       17.0 16 0 0 0   0     0   1   9 8                 17
2047047 2047047 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_4 17 0 3 0   0     0   0   9 11                       20.0 17 0 3 0   0     0   0   9 11                 20
2047060 2047060 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 North Intermediate   Regular School No Elementary 04 05 2019   grade_4 84 0 6 0   5     0   4   54 45                       99.0 84 0 6 0   5     0   4   54 45                 99
2047093 2047093 MA Middlesex   school 2513110 344   Winchester 251311002165 3440005 Lincoln Elementary   Regular School No Elementary KG 05 2019   grade_4 67 0 1 0   10     0   3   41 40                       81.0 67 0 1 0   10     0   3   41 40                 81
2047107 2047107 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Vinson-Owen Elementary   Regular School No Elementary PK 05 2019   grade_4 51 0 4 0   17     0   4   37 39                       76.0 51 0 4 0   17     0   4   37 39                 76
2047113 2047113 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Muraco Elementary   Regular School No Elementary KG 05 2019   grade_4 42 0 3 0   15     0   4   38 26                       64.0 42 0 3 0   15     0   4   38 26                 64
2047119 2047119 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2019   grade_4 69 0 2 0   2     0   3   43 33                       76.0 69 0 2 0   2     0   3   43 33                 76
2047209 2047209 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2019   grade_4 12 0 7 0   3     0   1   10 13                       23.0 12 0 7 0   3     0   1   10 13                 23
2047494 2047494 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   grade_4 8 0 0 0   0     0   0   6 2                       8.0 8 0 0 0   0     0   0   6 2                 8
2047502 2047502 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2019   grade_4 114 0 6 1   4     0   6   64 67                       131.0 114 0 6 1   4     0   6   64 67                 131
2047645 2047645 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 07 2019   grade_4 2 0 39 0   0     0   0   16 25                       41.0 2 0 39 0   0     0   0   16 25                 41
2047700 2047700 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   grade_4 0 0 47 0   0     0   0   28 19                       47.0 0 0 47 0   0     0   0   28 19                 47
2047777 2047777 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2019   grade_4 17 0 1 0   0     0   4   13 9                       22.0 17 0 1 0   0     0   4   13 9                 22
2047800 2047800 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_4 0 0 83 0   0     0   0   46 37                       83.0 0 0 83 0   0     0   0   46 37                 83
2047846 2047846 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_4 9 0 0 1   0     0   4   7 7                       14.0 9 0 0 1   0     0   4   7 7                 14
2047917 2047917 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_4 30 0 0 0   3     0   1   19 15                       34.0 30 0 0 0   3     0   1   19 15                 34
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2039870 2039870 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2019   grade_4 71 1 7 0   2     0   7   48 40                       88.0 71 1 7 0   2     0   7   48 40                 88
2039876 2039876 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2019   grade_4 78 1 6 1   2     0   1   49 40                       89.0 78 1 6 1   2     0   1   49 40                 89
2039902 2039902 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_4 20 1 10 0   8     0   3   21 21                       42.0 20 1 10 0   8     0   3   21 21                 42
2039922 2039922 MA Essex   school 2501950 9   Andover 250195001676 90004 High Plain Elementary   Regular School No Elementary KG 05 2019   grade_4 47 1 11 0   29     0   5   52 41                       93.0 47 1 11 0   29     0   5   52 41                 93
2039935 2039935 MA Essex   school 2501950 9   Andover 250195000050 90020 South Elementary   Regular School No Elementary KG 05 2019   grade_4 49 1 3 0   15     0   0   38 30                       68.0 49 1 3 0   15     0   0   38 30                 68
2039941 2039941 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_4 88 1 5 0   16     0   5   53 62                       115.0 88 1 5 0   16     0   5   53 62                 115
2039973 2039973 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2019   grade_4 61 1 4 0   9     0   5   40 40                       80.0 61 1 4 0   9     0   5   40 40                 80
2040295 2040295 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2019   grade_4 27 1 3 0   1     0   3   16 19                       35.0 27 1 3 0   1     0   3   16 19                 35
2040450 2040450 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_4 6 1 84 0   0     0   0   46 45                       91.0 6 1 84 0   0     0   0   46 45                 91
2040637 2040637 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2019   grade_4 18 1 22 0   4     0   1   21 25                       46.0 18 1 22 0   4     0   1   21 25                 46
2041116 2041116 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   grade_4 75 1 7 1   0     0   3   49 38                       87.0 75 1 7 1   0     0   3   49 38                 87
2041121 2041121 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2019   grade_4 70 1 5 0   1     0   2   34 45                       79.0 70 1 5 0   1     0   2   34 45                 79
2041136 2041136 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_4 81 1 1 0   6     0   3   51 41                       92.0 81 1 1 0   6     0   3   51 41                 92

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);