enrollments

Data source: Big Local News · About: Big Local

956 rows where grade = "grade_4", state = "MA" and year = 2021 sorted by male

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 956 ✖

grade ✖

  • grade_4 · 956 ✖
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
1674754 1674754 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1675702 1675702 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1673450 1673450 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_4 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674428 1674428 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_4 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1675850 1675850 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   grade_4 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1679685 1679685 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington - R. H. Conwell   Regular School No Elementary PK 06 2021   grade_4 9 0 0 0   0     0   0   1 8 *                     9.0 9 0 0 0   0     0   0   1 8                 9
1680952 1680952 MA Middlesex   school 2508790 735   North Middlesex 250879002686 7350002 North Middlesex - Squannacook Early Childhood Center   Regular School No Elementary 02 04 2021   grade_4 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1675665 1675665 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_4 5 0 2 0   3     0   1   10 1 *                     11.0 5 0 2 0   3     0   1   10 1                 11
1678918 1678918 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet - Wellfleet Elementary   Regular School No Elementary KG 05 2021   grade_4 15 0 2 0   1     0   2   10 10 *                     20.0 15 0 2 0   1     0   2   10 10                 20
1680473 1680473 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Central Berkshire - Becket Washington School   Regular School No Elementary PK 05 2021   grade_4 18 0 0 0   0     0   1   10 9 *                     19.0 18 0 0 0   0     0   1   10 9                 19
1680774 1680774 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Manchester Essex Regional - Essex Elementary   Regular School No Elementary KG 05 2021   grade_4 26 0 0 0   0     0   0   10 16 *                     26.0 26 0 0 0   0     0   0   10 16                 26
1680877 1680877 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   grade_4 18 0 2 0   0     0   0   10 10 *                     20.0 18 0 2 0   0     0   0   10 10                 20
1672270 1672270 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Auburn - Swanson Road Intermediate School   Regular School No Elementary 03 05 2021   grade_4 166 6 14 0   11     0   9   105 101 *                     206.0 166 6 14 0   11     0   9   105 101                 206
1680606 1680606 MA Bristol   school 2505070 665   Freetown-Lakeville 250507001852 6650015 Freetown-Lakeville - George R Austin Intermediate School   Regular School No Middle 04 06 2021   grade_4 183 2 7 0   0     0   8   107 93 *                     200.0 183 2 7 0   0     0   8   107 93                 200
1672208 1672208 MA Middlesex   school 2502100 14   Ashland 250210000071 140015 Ashland - David Mindess   Regular School No Elementary 03 05 2021   grade_4 141 4 35 0   32     0   10   108 114 *                     222.0 141 4 35 0   32     0   10   108 114                 222
1675945 1675945 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead - Village School   Regular School No Elementary 03 06 2021   grade_4 173 4 15 0   4     0   4   108 92 *                     200.0 173 4 15 0   4     0   4   108 92                 200
1675407 1675407 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_4 14 0 0 0   0     0   3   11 6 *                     17.0 14 0 0 0   0     0   3   11 6                 17
1677728 1677728 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Saugus - Douglas Waybright   Regular School No Elementary KG 05 2021   grade_4 19 0 1 0   1     0   0   11 10 *                     21.0 19 0 1 0   1     0   0   11 10                 21
1678155 1678155 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Springfield - Kensington International School   Regular School No Elementary PK 05 2021   grade_4 6 4 21 0   1     0   0   11 21 *                     32.0 6 4 21 0   1     0   0   11 21                 32
1679181 1679181 MA Norfolk   school 2512840 336   Weymouth 251284000509 3360060 Weymouth - Thomas V Nash   Regular School No Elementary KG 05 2021   grade_4 29 1 2 0   0     0   0   11 21 *                     32.0 29 1 2 0   0     0   0   11 21                 32
1679526 1679526 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester - Lincoln Street   Regular School No Elementary KG 06 2021   grade_4 4 8 8 0   3     0   0   11 12 *                     23.0 4 8 8 0   3     0   0   11 12                 23
1680748 1680748 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont - Hawlemont Regional   Regular School No Elementary PK 06 2021   grade_4 20 0 3 0   0     0   0   11 12 *                     23.0 20 0 3 0   0     0   0   11 12                 23
1681132 1681132 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 Spencer-E Brookfield - East Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_4 21 0 3 0   0     0   0   11 13 *                     24.0 21 0 3 0   0     0   0   11 13                 24
1674858 1674858 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Hanover - Center Elementary   Regular School No Elementary 02 04 2021   grade_4 198 1 5 0   3     0   2   111 98 *                     209.0 198 1 5 0   3     0   2   111 98                 209
1676081 1676081 MA Norfolk   school 2507530 175   Medfield 250753001155 1750005 Medfield - Dale Street   Regular School No Elementary 04 05 2021   grade_4 168 1 13 0   6     0   8   111 85 *                     196.0 168 1 13 0   6     0   8   111 85                 196
1675021 1675021 MA Middlesex   school 2506240 136   Holliston 250624001302 1360007 Holliston - Miller School   Regular School No Elementary 03 05 2021   grade_4 181 2 9 2   21     1   8   116 108 *                     224.0 181 2 9 2   21     1   8   116 108                 224
1675932 1675932 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Mansfield - Jordan/Jackson Elementary   Regular School No Elementary 03 05 2021   grade_4 183 15 11 0   22     0   12   118 125 *                     243.0 183 15 11 0   22     0   12   118 125                 243
1677840 1677840 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_4 66 5 19 1   115     0   7   119 94 *                     213.0 66 5 19 1   115     0   7   119 94                 213
1680443 1680443 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham - Williams Intermediate School   Regular School No Middle 04 06 2021   grade_4 195 22 6 1   6     0   9   119 120 *                     239.0 195 22 6 1   6     0   9   119 120                 239
1672764 1672764 MA Suffolk   school 2502790 35   Boston 250279000270 350180 Boston - John Winthrop   Regular School No Elementary PK 05 2021   grade_4 1 19 14 0   0     0   0   12 22 *                     34.0 1 19 14 0   0     0   0   12 22                 34
1672883 1672883 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_4 14 7 3 0   1     0   0   12 13 *                     25.0 14 7 3 0   1     0   0   12 13                 25
1673016 1673016 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_4 3 4 5 0   1     0   0   12 1 *                     13.0 3 4 5 0   1     0   0   12 1                 13
1673697 1673697 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Cambridge - Fletcher/Maynard Academy   Regular School No Elementary PK 05 2021   grade_4 7 19 4 0   2     0   3   12 23 *                     35.0 7 19 4 0   2     0   3   12 23                 35
1674720 1674720 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester - East Gloucester Elementary   Regular School No Elementary KG 05 2021   grade_4 25 0 1 0   0     0   1   12 15 *                     27.0 25 0 1 0   0     0   1   12 15                 27
1677149 1677149 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham - Pelham Elementary   Regular School No Elementary KG 06 2021   grade_4 13 2 2 0   2     0   1   12 8 *                     20.0 13 2 2 0   2     0   1   12 8                 20
1678904 1678904 MA Norfolk   school 2512270 317   Wellesley 251227002021 3170050 Wellesley - Ernest F Upham   Regular School No Elementary KG 05 2021   grade_4 21 3 2 0   6     0   1   12 21 *                     33.0 21 3 2 0   6     0   1   12 21                 33
1679970 1679970 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_4 14 0 1 0   2     0   5   12 10 *                     22.0 14 0 1 0   2     0   5   12 10                 22
1680346 1680346 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Athol-Royalston - Royalston Community School   Regular School No Elementary KG 06 2021   grade_4 21 0 0 0   0     0   0   12 9 *                     21.0 21 0 0 0   0     0   0   12 9                 21
1674228 1674228 MA Bristol   school 2504620 88   Easton 250462000983 880025 Easton - Richardson Olmsted School   Regular School No Elementary 03 05 2021   grade_4 190 17 27 4   6     1   3   120 128 *                     248.0 190 17 27 4   6     1   3   120 128                 248
1673011 1673011 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_4 1 15 7 0   0     0   1   13 11 *                     24.0 1 15 7 0   0     0   1   13 11                 24
1673977 1673977 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   grade_4 17 0 2 0   0     0   0   13 6 *                     19.0 17 0 2 0   0     0   0   13 6                 19
1674727 1674727 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester - Plum Cove School   Regular School No Elementary KG 05 2021   grade_4 29 2 2 0   1     0   0   13 21 *                     34.0 29 2 2 0   1     0   0   13 21                 34
1675793 1675793 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn - Lynn Woods   Regular School No Elementary KG 05 2021   grade_4 10 0 10 0   3     0   4   13 14 *                     27.0 10 0 10 0   3     0   4   13 14                 27
1677273 1677273 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Plymouth - Cold Spring   Regular School No Elementary KG 05 2021   grade_4 24 0 5 0   2     0   1   13 19 *                     32.0 24 0 5 0   2     0   1   13 19                 32
1679052 1679052 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton - Westhampton Elementary School   Regular School No Elementary PK 06 2021   grade_4 18 0 1 0   0     0   0   13 6 *                     19.0 18 0 1 0   0     0   0   13 6                 19
1681057 1681057 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin - Oakham Center   Regular School No Elementary 02 06 2021   grade_4 27 0 1 0   0     0   0   13 15 *                     28.0 27 0 1 0   0     0   0   13 15                 28
1680514 1680514 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_4 148 25 20 8   5     2   20   130 98 *                     228.0 148 25 20 8   5     2   20   130 98                 228
1672524 1672524 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_4 10 6 7 0   1     0   1   14 11 *                     25.0 10 6 7 0   1     0   1   14 11                 25
1672799 1672799 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston - Joseph P Manning   Regular School No Elementary PK 06 2021   grade_4 7 1 9 0   5     0   3   14 11 *                     25.0 7 1 9 0   5     0   3   14 11                 25
1672858 1672858 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Boston - Mozart   Regular School No Elementary PK 05 2021   grade_4 6 8 6 0   1     0   2   14 9 *                     23.0 6 8 6 0   1     0   2   14 9                 23
1677279 1677279 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Plymouth - Hedge   Regular School No Elementary KG 05 2021   grade_4 16 2 5 0   0     0   3   14 12 *                     26.0 16 2 5 0   0     0   3   14 12                 26
1677335 1677335 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton - Dennett Elementary   Regular School No Elementary KG 06 2021   grade_4 27 0 0 0   0     0   0   14 13 *                     27.0 27 0 0 0   0     0   0   14 13                 27
1677896 1677896 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Somerville - Benjamin G Brown   Regular School No Elementary KG 05 2021   grade_4 28 0 1 0   5     0   3   14 23 *                     37.0 28 0 1 0   5     0   3   14 23                 37
1677942 1677942 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville - West Somerville Neighborhood   Regular School No Elementary PK 08 2021   grade_4 21 4 1 0   2     0   3   14 17 *                     31.0 21 4 1 0   2     0   3   14 17                 31
1678032 1678032 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_4 1 6 9 0   0     0   0   14 2 *                     16.0 1 6 9 0   0     0   0   14 2                 16
1678479 1678479 MA Essex   school 2511430 291   Swampscott 251143001886 2910020 Swampscott - Stanley   Regular School No Elementary KG 04 2021   grade_4 40 0 2 0   2     0   0   14 30 *                     44.0 40 0 2 0   2     0   0   14 30                 44
1679540 1679540 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester - Francis J McGrath Elementary   Regular School No Elementary KG 06 2021   grade_4 7 7 11 0   1     0   3   14 15 *                     29.0 7 7 11 0   1     0   3   14 15                 29
1679764 1679764 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District) - Bridge Boston Charter School   Regular School Yes Elementary PK 08 2021   grade_4 2 34 4 0   0     0   0   14 26 *                     40.0 2 34 4 0   0     0   0   14 26                 40
1681045 1681045 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Quabbin - Hardwick Elementary   Regular School No Elementary PK 06 2021   grade_4 18 0 4 0   0     0   1   14 9 *                     23.0 18 0 4 0   0     0   1   14 9                 23
1678933 1678933 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough - Mill Pond School   Regular School No Middle 04 06 2021   grade_4 129 5 30 1   118     0   14   145 152 *                     297.0 129 5 30 1   118     0   14   145 152                 297
1672676 1672676 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston - George H Conley   Regular School No Elementary PK 06 2021   grade_4 4 9 11 0   0     0   0   15 9 *                     24.0 4 9 11 0   0     0   0   15 9                 24
1672779 1672779 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_4 5 4 31 0   1     0   0   15 26 *                     41.0 5 4 31 0   1     0   0   15 26                 41
1672918 1672918 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston - Patrick J Kennedy   Regular School No Elementary PK 06 2021   grade_4 1 4 23 0   0     0   0   15 13 *                     28.0 1 4 23 0   0     0   0   15 13                 28
1673273 1673273 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_4 5 0 42 0   0     0   0   15 32 *                     47.0 5 0 42 0   0     0   0   15 32                 47
1674416 1674416 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Fall River - Samuel Watson   Regular School No Elementary KG 05 2021   grade_4 19 3 9 1   0     0   6   15 23 *                     38.0 19 3 9 1   0     0   6   15 23                 38
1674733 1674733 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Gloucester - Veterans Memorial   Regular School No Elementary KG 05 2021   grade_4 26 1 10 0   1     0   1   15 24 *                     39.0 26 1 10 0   1     0   1   15 24                 39
1675057 1675057 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke - Morgan Full Service Community School   Regular School No Elementary PK 04 2021   grade_4 2 0 40 0   0     0   0   15 27 *                     42.0 2 0 40 0   0     0   0   15 27                 42
1676456 1676456 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 New Bedford - Charles S Ashley   Regular School No Elementary KG 05 2021   grade_4 24 1 6 0   0     0   0   15 16 *                     31.0 24 1 6 0   0     0   0   15 16                 31
1677054 1677054 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans - Orleans Elementary   Regular School No Elementary KG 05 2021   grade_4 33 1 2 0   0     0   0   15 21 *                     36.0 33 1 2 0   0     0   0   15 21                 36
1677952 1677952 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Somerville - Winter Hill Community   Regular School No Elementary PK 08 2021   grade_4 8 3 16 0   1     0   0   15 13 *                     28.0 8 3 16 0   1     0   0   15 13                 28
1678385 1678385 MA Norfolk   school 2511250 285   Stoughton 251125001863 2850015 Stoughton - South Elementary   Regular School No Elementary KG 05 2021   grade_4 18 10 2 0   2     0   2   15 19 *                     34.0 18 10 2 0   2     0   2   15 19                 34
1678880 1678880 MA Norfolk   school 2512270 317   Wellesley 251227002023 3170020 Wellesley - John D Hardy   Regular School No Elementary KG 05 2021   grade_4 13 0 9 0   10     0   4   15 21 *                     36.0 13 0 9 0   10     0   4   15 21                 36
1678886 1678886 MA Norfolk   school 2512270 317   Wellesley 251227002022 3170025 Wellesley - Hunnewell   Regular School No Elementary KG 05 2021   grade_4 26 2 3 0   2     0   2   15 20 *                     35.0 26 2 3 0   2     0   2   15 20                 35
1679451 1679451 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Worcester - Clark St Community   Regular School No Elementary PK 06 2021   grade_4 6 3 23 0   1     0   1   15 19 *                     34.0 6 3 23 0   1     0   1   15 19                 34
1679547 1679547 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester - Midland Street   Regular School No Elementary KG 06 2021   grade_4 14 1 4 0   2     0   1   15 7 *                     22.0 14 1 4 0   2     0   1   15 7                 22
1679792 1679792 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway (District) - Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 08 2021   grade_4 0 0 42 0   0     0   0   15 27 *                     42.0 0 0 42 0   0     0   0   15 27                 42
1679914 1679914 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District) - Neighborhood House Charter School   Regular School Yes Other PK 12 2021   grade_4 9 20 7 0   3     0   4   15 27 *                     43.0 9 20 7 0   3     0   4   15 27                 43
1680110 1680110 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_4 27 0 2 0   1     0   2   15 17 *                     32.0 27 0 2 0   1     0   2   15 17                 32
1680421 1680421 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Blackstone-Millville - Millville Elementary   Regular School No Elementary PK 05 2021   grade_4 27 0 4 0   0     0   1   15 17 *                     32.0 27 0 4 0   0     0   1   15 17                 32
1672698 1672698 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston - Hugh Roe O'Donnell   Regular School No Elementary PK 06 2021   grade_4 1 0 32 0   2     0   0   16 19 *                     35.0 1 0 32 0   2     0   0   16 19                 35
1672958 1672958 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_4 6 1 21 1   0     0   0   16 13 *                     29.0 6 1 21 1   0     0   0   16 13                 29
1672983 1672983 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_4 4 3 31 0   1     0   1   16 23 *                     40.0 4 3 31 0   1     0   1   16 23                 40
1673100 1673100 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_4 14 9 11 0   0     1   0   16 19 *                     35.0 14 9 11 0   0     1   0   16 19                 35
1674829 1674829 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley - Hadley Elementary   Regular School No Elementary PK 06 2021   grade_4 23 1 3 1   1     1   1   16 15 *                     31.0 23 1 3 1   1     1   1   16 15                 31
1675017 1675017 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland - Holland Elementary   Regular School No Elementary PK 06 2021   grade_4 27 0 0 0   1     0   1   16 13 *                     29.0 27 0 0 0   1     0   1   16 13                 29
1676508 1676508 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 New Bedford - Ellen R Hathaway   Regular School No Elementary PK 05 2021   grade_4 7 10 19 0   1     0   0   16 21 *                     37.0 7 10 19 0   1     0   0   16 21                 37
1676696 1676696 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 Newton - John Ward   Regular School No Elementary KG 05 2021   grade_4 30 1 2 0   4     0   4   16 25 *                     41.0 30 1 2 0   4     0   4   16 25                 41
1676752 1676752 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams - Greylock   Regular School No Elementary PK 06 2021   grade_4 20 0 2 0   1     0   3   16 10 *                     26.0 20 0 2 0   1     0   3   16 10                 26
1676846 1676846 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 North Attleborough - Falls   Regular School No Elementary KG 05 2021   grade_4 24 2 2 0   4     0   0   16 16 *                     32.0 24 2 2 0   4     0   0   16 16                 32
1681031 1681031 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Pioneer Valley - Northfield Elementary   Regular School No Elementary PK 06 2021   grade_4 27 0 0 0   0     1   1   16 13 *                     29.0 27 0 0 0   0     1   1   16 13                 29
1675129 1675129 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkinton - Hopkins Elementary School   Regular School No Elementary 04 05 2021   grade_4 208 1 10 1   85     0   7   163 149 *                     312.0 208 1 10 1   85     0   7   163 149                 312
1676267 1676267 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford - Woodland   Regular School No Elementary 03 05 2021   grade_4 198 14 96 3   3     1   9   164 160 *                     324.0 198 14 96 3   3     1   9   164 160                 324
1672459 1672459 MA Middlesex   school 2502670 31   Billerica 250267000179 310007 Billerica - Frederick J Dutile   Regular School No Elementary KG 04 2021   grade_4 31 1 4 0   2     0   1   17 22 *                     39.0 31 1 4 0   2     0   1   17 22                 39
1672973 1672973 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_4 0 6 31 0   0     0   1   17 21 *                     38.0 0 6 31 0   0     0   1   17 21                 38
1673037 1673037 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_4 0 26 14 0   0     1   1   17 25 *                     42.0 0 26 14 0   0     1   1   17 25                 42
1674189 1674189 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton - Neil A Pepin   Regular School No Elementary KG 04 2021   grade_4 29 0 8 0   0     0   2   17 22 *                     39.0 29 0 8 0   0     0   2   17 22                 39
1677096 1677096 MA Essex   school 2509360 229   Peabody 250936001496 2290007 Peabody - John E Burke   Regular School No Elementary KG 05 2021   grade_4 32 0 2 0   2     0   2   17 21 *                     38.0 32 0 2 0   2     0   2   17 21                 38
1679110 1679110 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield - Mittineague   Regular School No Elementary 01 05 2021   grade_4 24 0 10 0   0     0   1   17 18 *                     35.0 24 0 10 0   0     0   1   17 18                 35
1679142 1679142 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Westwood - Paul Hanlon   Regular School No Elementary KG 05 2021   grade_4 21 0 1 0   8     0   1   17 14 *                     31.0 21 0 1 0   8     0   1   17 14                 31
1679624 1679624 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester - West Tatnuck   Regular School No Elementary PK 06 2021   grade_4 22 5 5 0   2     0   2   17 19 *                     36.0 22 5 5 0   2     0   2   17 19                 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]);