enrollments

Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 6,679 ✖
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
1124816 1124816 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_4 * * * *   *     *   *   2 *                       *                         2                    
1125190 1125190 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_4 * * * *   *     *   *   * *                       *                                              
1125319 1125319 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_4 * * * *   *     *   *   3 2                       *                         3 2                  
1125423 1125423 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_4 * * * *   *     *   *   4 1                       *                         4 1                  
1126249 1126249 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_4 * * * *   *     *   *   4 *                       *                         4                    
1126350 1126350 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   grade_4 * * * *   *     *   *   1 1                       *                         1 1                  
1126449 1126449 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_4 * * * *   *     *   *   3 *                       *                         3                    
1128752 1128752 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_4 * * * *   *     *   *   3 1                       *                         3 1                  
1131075 1131075 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_4 * * * *   *     *   *   1 2                       *                         1 2                  
1132405 1132405 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No Elementary PK 06 2017   grade_4 * * * *   *     *   *   1 1                       *                         1 1                  
1368461 1368461 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1374311 1374311 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
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
2230207 2230207 MA Suffolk   school   35   Boston   350652               2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2231641 2231641 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2232019 2232019 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
2237225 2237225 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_4 * * * *   *     *   *   * *                       0.0                                             0
738425 738425 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No 2 04 05 2015   grade_4 * * * *   *     *   *   * *                       1                                             1
738473 738473 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No 2 04 07 2015   grade_4 * * * *   *     *   *   1 *                       1                         1                   1
936164 936164 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_4 * * * *   *     *   *   1 *                       1                         1                   1
936329 936329 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 KG 06 2016   grade_4 3 1 5 0   0     0   1   9 1                       10 3 1 5 0   0     0   1   9 1                 10
941721 941721 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2016   grade_4 9 0 0 0   1     0   0   7 3                       10 9 0 0 0   1     0   0   7 3                 10
1132728 1132728 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_4 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
1370776 1370776 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield Public Day Elementary School   Regular School No Elementary 01 05 2020   grade_4 1 2 7 0   0     0   0   9 1 *                     10.0 1 2 7 0   0     0   0   9 1                 10
1672599 1672599 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_4 5 0 5 0   0     0   0   4 6 *                     10.0 5 0 5 0   0     0   0   4 6                 10
2043625 2043625 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 05 2019   grade_4 2 0 8 0   0     0   0   9 1                       10.0 2 0 8 0   0     0   0   9 1                 10
2045459 2045459 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_4 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2045565 2045565 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2019   grade_4 10 0 0 0   0     0   0   5 5                       10.0 10 0 0 0   0     0   0   5 5                 10
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
2231752 2231752 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida: Abbott Memorial   Regular School No Elementary PK 08 2018   grade_4 10 0 0 0   0     0   0   6 4                       10.0 10 0 0 0   0     0   0   6 4                 10
2239105 2239105 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont: Hawlemont Regional   Regular School No Elementary PK 06 2018   grade_4 9 0 0 0   0     0   1   5 5                       10.0 9 0 0 0   0     0   1   5 5                 10
2239636 2239636 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional: Chilmark Elementary   Regular School No Elementary KG 05 2018   grade_4 10 0 0 0   0     0   0   7 3                       10.0 10 0 0 0   0     0   0   7 3                 10
736016 736016 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_4 93 1 4 0   2     0   0   47 53                       100 93 1 4 0   2     0   0   47 53                 100
736124 736124 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No 1 KG 05 2015   grade_4 83 2 7 0   5     1   2   41 59                       100 83 2 7 0   5     1   2   41 59                 100
738163 738163 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2015   grade_4 31 6 51 0   4     0   8   50 50                       100 31 6 51 0   4     0   8   50 50                 100
739573 739573 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2015   grade_4 27 22 32 0   14     0   5   48 52                       100 27 22 32 0   14     0   5   48 52                 100
740999 740999 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No 1 KG 05 2015   grade_4 95 1 1 0   2     0   1   49 51                       100 95 1 1 0   2     0   1   49 51                 100
741251 741251 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No 1 PK 05 2015   grade_4 26 7 55 0   9     1   2   45 55                       100 26 7 55 0   9     1   2   45 55                 100
932761 932761 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No 1 KG 04 2016   grade_4 61 5 17 0   8     0   9   51 49                       100 61 5 17 0   8     0   9   51 49                 100
934753 934753 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No 1 03 05 2016   grade_4 90 1 4 0   2     0   3   54 46                       100 90 1 4 0   2     0   3   54 46                 100
936081 936081 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No 1 PK 04 2016   grade_4 36 1 17 0   42     0   4   55 45                       100 36 1 17 0   42     0   4   55 45                 100
938554 938554 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2016   grade_4 7 10 81 0   1     0   1   50 50                       100 7 10 81 0   1     0   1   50 50                 100
1123740 1123740 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_4 59 4 21 0   8     0   8   52 48                       100 59 4 21 0   8     0   8   52 48                 100
1123995 1123995 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2017   grade_4 65 11 6 0   11     0   7   44 56                       100 65 11 6 0   11     0   7   44 56                 100
1124441 1124441 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2017   grade_4 89 3 7 0   1     0   0   52 48                       100 89 3 7 0   1     0   0   52 48                 100
1127066 1127066 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Cunningham School   Regular School No Elementary KG 05 2017   grade_4 78 11 6 0   3     0   2   60 40                       100 78 11 6 0   3     0   2   60 40                 100
1128824 1128824 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No Elementary KG 05 2017   grade_4 61 5 4 0   26     0   4   51 49                       100 61 5 4 0   26     0   4   51 49                 100
1128919 1128919 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2017   grade_4 88 3 7 0   2     0   0   54 46                       100 88 3 7 0   2     0   0   54 46                 100
1131617 1131617 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_4 80 3 11 0   0     0   6   48 52                       100 80 3 11 0   0     0   6   48 52                 100
1365009 1365009 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   grade_4 66 4 18 0   6     0   6   54 46 *                     100.0 66 4 18 0   6     0   6   54 46                 100
1365659 1365659 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_4 0 62 33 1   1     0   3   55 45 *                     100.0 0 62 33 1   1     0   3   55 45                 100
1368130 1368130 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2020   grade_4 37 11 40 0   7     0   5   47 53 *                     100.0 37 11 40 0   7     0   5   47 53                 100
1368176 1368176 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2020   grade_4 50 5 3 0   33     0   9   55 45 *                     100.0 50 5 3 0   33     0   9   55 45                 100
1368818 1368818 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_4 79 1 13 0   1     0   6   50 50 *                     100.0 79 1 13 0   1     0   6   50 50                 100
1372790 1372790 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_4 2 50 48 0   0     0   0   48 52 *                     100.0 2 50 48 0   0     0   0   48 52                 100
1674842 1674842 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_4 91 2 5 1   0     0   1   50 50 *                     100.0 91 2 5 1   0     0   1   50 50                 100
1676623 1676623 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 Newton - A E Angier   Regular School No Elementary KG 05 2021   grade_4 72 3 3 0   15     0   7   55 45 *                     100.0 72 3 3 0   15     0   7   55 45                 100
1681118 1681118 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District - Powder Mill School   Regular School No Elementary 03 06 2021   grade_4 87 2 6 0   1     0   4   51 49 *                     100.0 87 2 6 0   1     0   4   51 49                 100
1681307 1681307 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Whitman-Hanson - Indian Head   Regular School No Elementary KG 04 2021   grade_4 90 0 5 1   2     0   2   55 45 *                     100.0 90 0 5 1   2     0   2   55 45                 100
2042319 2042319 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2019   grade_4 38 4 48 0   2     1   7   53 47                       100.0 38 4 48 0   2     1   7   53 47                 100
2043365 2043365 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2019   grade_4 40 5 20 0   29     0   6   56 44                       100.0 40 5 20 0   29     0   6   56 44                 100
2043401 2043401 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2019   grade_4 11 5 36 0   45     0   3   51 49                       100.0 11 5 36 0   45     0   3   51 49                 100
2043413 2043413 MA Middlesex   school 2507020 160   Lowell 250702001029 1600030 Charles W Morey   Regular School No Elementary PK 04 2019   grade_4 20 5 13 0   59     0   3   49 51                       100.0 20 5 13 0   59     0   3   49 51                 100
2044224 2044224 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No Elementary KG 04 2019   grade_4 88 0 5 0   2     0   5   56 44                       100.0 88 0 5 0   2     0   5   56 44                 100
2044648 2044648 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2019   grade_4 83 2 5 1   6     0   3   56 44                       100.0 83 2 5 1   6     0   3   56 44                 100
2046338 2046338 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2019   grade_4 74 13 6 1   2     0   4   44 56                       100.0 74 13 6 1   2     0   4   44 56                 100
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
2231279 2231279 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 Dracut: George H. Englesby Elementary School   Regular School No Elementary KG 05 2018   grade_4 70 7 13 0   6     0   4   47 53                       100.0 70 7 13 0   6     0   4   47 53                 100
2231364 2231364 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 East Longmeadow: Mapleshade   Regular School No Elementary 03 05 2018   grade_4 79 4 2 0   13     0   2   43 57                       100.0 79 4 2 0   13     0   2   43 57                 100
2234121 2234121 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 New Bedford: Hayden/McFadden   Regular School No Elementary PK 05 2018   grade_4 37 8 53 1   0     0   1   60 40                       100.0 37 8 53 1   0     0   1   60 40                 100
2235740 2235740 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 Somerset: North Elementary   Regular School No Elementary KG 05 2018   grade_4 91 2 4 0   1     0   2   50 50                       100.0 91 2 4 0   1     0   2   50 50                 100
2239572 2239572 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Spencer-E Brookfield: Wire Village School   Regular School No Elementary KG 04 2018   grade_4 85 0 10 0   2     0   3   52 48                       100.0 85 0 10 0   2     0   3   52 48                 100
738279 738279 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2015   grade_4 60 16 17 0   3     0   5   64 37                       101 60 16 17 0   3     0   5   64 37                 101
738311 738311 MA Norfolk   school 2505010 101   Franklin 250501001694 1010012 Helen Keller Elementary   Regular School No 1 KG 05 2015   grade_4 93 0 1 0   6     0   1   60 41                       101 93 0 1 0   6     0   1   60 41                 101
738659 738659 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2015   grade_4 97 1 0 0   2     0   1   62 39                       101 97 1 0 0   2     0   1   62 39                 101
739125 739125 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2015   grade_4 44 10 2 1   43     0   1   53 48                       101 44 10 2 1   43     0   1   53 48                 101
739137 739137 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No 1 KG 05 2015   grade_4 48 3 3 0   39     0   8   36 65                       101 48 3 3 0   39     0   8   36 65                 101
739783 739783 MA Middlesex   school 2507560 176   Medford 250756002049 1760130 Brooks School   Regular School No 1 PK 05 2015   grade_4 73 10 9 0   6     0   3   53 48                       101 73 10 9 0   6     0   3   53 48                 101
740234 740234 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No 1 PK 05 2015   grade_4 75 4 10 0   1     0   11   48 53                       101 75 4 10 0   1     0   11   48 53                 101
740685 740685 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   grade_4 98 0 0 0   2     0   1   46 55                       101 98 0 0 0   2     0   1   46 55                 101
932750 932750 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No 1 KG 04 2016   grade_4 59 1 29 1   4     0   7   51 50                       101 59 1 29 1   4     0   7   51 50                 101
935461 935461 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No 1 01 04 2016   grade_4 47 3 50 0   1     0   0   52 49                       101 47 3 50 0   1     0   0   52 49                 101
937336 937336 MA Essex   school 2508700 211   North Andover 250870001395 2110010 Franklin   Regular School No 1 KG 05 2016   grade_4 84 0 8 0   8     0   1   50 51                       101 84 0 8 0   8     0   1   50 51                 101
938334 938334 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No 1 KG 05 2016   grade_4 67 1 3 1   24     0   5   60 41                       101 67 1 3 1   24     0   5   60 41                 101
1122935 1122935 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2017   grade_4 4 41 27 0   23     0   6   57 44                       101 4 41 27 0   23     0   6   57 44                 101
1125961 1125961 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2017   grade_4 45 3 44 0   6     0   3   50 51                       101 45 3 44 0   6     0   3   50 51                 101
1130030 1130030 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2017   grade_4 76 7 1 0   10     1   6   40 61                       101 76 7 1 0   10     1   6   40 61                 101
1369138 1369138 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Brown   Regular School No Elementary KG 04 2020   grade_4 54 1 10 0   33     0   3   51 50 *                     101.0 54 1 10 0   33     0   3   51 50                 101
1373077 1373077 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2020   grade_4 79 1 15 0   1     0   5   51 50 *                     101.0 79 1 15 0   1     0   5   51 50                 101
1672410 1672410 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley - Berkley Community School   Regular School No Elementary PK 04 2021   grade_4 95 0 2 0   1     0   3   57 44 *                     101.0 95 0 2 0   1     0   3   57 44                 101
1676234 1676234 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_4 86 1 3 0   2     0   9   47 54 *                     101.0 86 1 3 0   2     0   9   47 54                 101
1677376 1677376 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy - Clifford H Marshall Elementary   Regular School No Elementary KG 04 2021   grade_4 32 19 15 0   34     0   1   44 57 *                     101.0 32 19 15 0   34     0   1   44 57                 101
1678641 1678641 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Wakefield - Dolbeare   Regular School No Elementary KG 04 2021   grade_4 86 2 8 0   2     0   3   56 45 *                     101.0 86 2 8 0   2     0   3   56 45                 101
1680341 1680341 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol-Royalston - Athol Community Elementary School   Regular School No Elementary PK 04 2021   grade_4 84 3 10 0   0     0   4   50 51 *                     101.0 84 3 10 0   0     0   4   50 51                 101
2040031 2040031 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No Elementary KG 04 2019   grade_4 64 8 16 0   3     0   10   53 48                       101.0 64 8 16 0   3     0   10   53 48                 101
2042041 2042041 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2019   grade_4 70 7 15 0   6     0   3   59 42                       101.0 70 7 15 0   6     0   3   59 42                 101
2043449 2043449 MA Middlesex   school 2507020 160   Lowell 250702000092 1600080 Charlotte M Murkland Elementary   Regular School No Elementary PK 04 2019   grade_4 15 2 33 0   45     0   6   60 41                       101.0 15 2 33 0   45     0   6   60 41                 101
2043714 2043714 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_4 27 18 38 0   14     0   4   48 53                       101.0 27 18 38 0   14     0   4   48 53                 101
2232637 2232637 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_4 2 0 99 0   0     0   0   51 50                       101.0 2 0 99 0   0     0   0   51 50                 101

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