enrollments

Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 6,118 ✖
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
2046414 2046414 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Middle 04 06 2019   grade_5 92 1 2 0   1     0   5   44 57                       101.0 92 1 2 0   1     0   5   44 57                 101
2046590 2046590 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2019   grade_5 89 2 7 0   0     0   3   52 49                       101.0 89 2 7 0   0     0   3   52 49                 101
2046786 2046786 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Middle 04 06 2019   grade_5 82 6 0 1   1     1   10   46 55                       101.0 82 6 0 1   1     1   10   46 55                 101
2048158 2048158 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_5 89 0 10 0   0     0   2   61 40                       101.0 89 0 10 0   0     0   2   61 40                 101
2229805 2229805 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_5 3 54 42 0   1     1   0   50 51                       101.0 3 54 42 0   1     1   0   50 51                 101
2230309 2230309 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_5 96 1 0 0   4     0   0   52 49                       101.0 96 1 0 0   4     0   0   52 49                 101
2230479 2230479 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton: Downey   Regular School No Elementary KG 05 2018   grade_5 26 51 16 0   1     0   7   50 51                       101.0 26 51 16 0   1     0   7   50 51                 101
2230545 2230545 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_5 57 3 9 0   27     0   5   52 49                       101.0 57 3 9 0   27     0   5   52 49                 101
2230811 2230811 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Canton: Dean S Luce   Regular School No Elementary KG 05 2018   grade_5 66 11 6 0   10     0   8   45 56                       101.0 66 11 6 0   10     0   8   45 56                 101
741530 741530 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No 1 KG 05 2015   grade_5 59 1 3 0   33     0   6   56 46                       102 59 1 3 0   33     0   6   56 46                 102
742662 742662 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2015   grade_5 98 0 3 0   1     0   0   57 45                       102 98 0 3 0   1     0   0   57 45                 102
935134 935134 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No 1 KG 05 2016   grade_5 56 14 23 0   4     0   5   66 36                       102 56 14 23 0   4     0   5   66 36                 102
937015 937015 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2016   grade_5 40 14 40 0   0     0   8   59 43                       102 40 14 40 0   0     0   8   59 43                 102
940604 940604 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes 1 KG 05 2016   grade_5 81 1 18 0   0     0   2   50 52                       102 81 1 18 0   0     0   2   50 52                 102
1126019 1126019 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2017   grade_5 43 5 5 0   42     0   7   54 48                       102 43 5 5 0   42     0   7   54 48                 102
1126741 1126741 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_5 83 3 3 6   2     0   5   60 42                       102 83 3 3 6   2     0   5   60 42                 102
1128729 1128729 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No Elementary KG 05 2017   grade_5 69 4 23 0   6     0   0   56 46                       102 69 4 23 0   6     0   0   56 46                 102
1367075 1367075 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_5 32 12 47 0   8     0   3   55 47 *                     102.0 32 12 47 0   8     0   3   55 47                 102
1367378 1367378 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_5 75 6 20 0   0     0   1   59 43 *                     102.0 75 6 20 0   0     0   1   59 43                 102
1370308 1370308 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2020   grade_5 13 3 75 1   8     0   2   49 53 *                     102.0 13 3 75 1   8     0   2   49 53                 102
1674039 1674039 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth - James M. Quinn School   Regular School No Elementary KG 05 2021   grade_5 82 2 5 0   3     0   10   58 44 *                     102.0 82 2 5 0   3     0   10   58 44                 102
1680104 1680104 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District) - Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2021   grade_5 1 61 36 0   0     0   4   49 53 *                     102.0 1 61 36 0   0     0   4   49 53                 102
2039831 2039831 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_5 97 1 3 0   1     0   0   60 42                       102.0 97 1 3 0   1     0   0   60 42                 102
2041566 2041566 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2019   grade_5 80 4 2 0   9     0   7   57 45                       102.0 80 4 2 0   9     0   7   57 45                 102
2044080 2044080 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2019   grade_5 83 1 5 0   5     0   8   50 52                       102.0 83 1 5 0   5     0   8   50 52                 102
2046059 2046059 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   grade_5 3 15 83 0   1     0   0   59 43                       102.0 3 15 83 0   1     0   0   59 43                 102
2232849 2232849 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington: Joseph Estabrook   Regular School No Elementary KG 05 2018   grade_5 34 2 5 0   52     0   9   44 58                       102.0 34 2 5 0   52     0   9   44 58                 102
2235918 2235918 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Springfield: Edward P. Boland School   Regular School No Elementary PK 05 2018   grade_5 9 16 75 0   1     0   1   60 42                       102.0 9 16 75 0   1     0   1   60 42                 102
2236374 2236374 MA Middlesex   school 2511340 288   Sudbury 251134001877 2880030 Sudbury: Peter Noyes   Regular School No Elementary PK 05 2018   grade_5 70 4 8 0   12     0   8   46 56                       102.0 70 4 8 0   12     0   8   46 56                 102
737424 737424 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No 1 KG 05 2015   grade_5 71 10 5 0   15     0   2   51 52                       103 71 10 5 0   15     0   2   51 52                 103
739076 739076 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No 1 KG 05 2015   grade_5 62 10 29 0   0     0   2   49 54                       103 62 10 29 0   0     0   2   49 54                 103
739132 739132 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2015   grade_5 61 5 7 1   24     0   5   56 47                       103 61 5 7 1   24     0   5   56 47                 103
740030 740030 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No 2 05 08 2015   grade_5 96 1 1 0   0     2   3   50 53                       103 96 1 1 0   0     2   3   50 53                 103
740214 740214 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   grade_5 60 10 30 0   1     0   2   52 51                       103 60 10 30 0   1     0   2   52 51                 103
740988 740988 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2015   grade_5 97 0 3 0   1     0   2   55 48                       103 97 0 3 0   1     0   2   55 48                 103
741435 741435 MA Essex   school 2510500 262   Saugus 251050001687 2620065 Veterans Memorial   Regular School No 1 KG 05 2015   grade_5 82 7 10 0   4     0   0   52 51                       103 82 7 10 0   4     0   0   52 51                 103
743637 743637 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_5 46 32 22 0   1     0   2   47 56                       103 46 32 22 0   1     0   2   47 56                 103
743775 743775 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes 1 KG 05 2015   grade_5 73 5 22 0   2     0   1   45 58                       103 73 5 22 0   2     0   1   45 58                 103
934637 934637 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No 1 02 05 2016   grade_5 91 0 7 0   4     0   1   52 51                       103 91 0 7 0   4     0   1   52 51                 103
935442 935442 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_5 58 3 36 0   4     0   2   55 48                       103 58 3 36 0   4     0   2   55 48                 103
935972 935972 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No 1 KG 05 2016   grade_5 47 8 2 0   45     0   1   50 53                       103 47 8 2 0   45     0   1   50 53                 103
938080 938080 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No 1 PK 05 2016   grade_5 26 7 57 0   10     1   2   51 52                       103 26 7 57 0   10     1   2   51 52                 103
1124990 1124990 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   grade_5 25 0 77 0   0     0   1   51 52                       103 25 0 77 0   0     0   1   51 52                 103
1125128 1125128 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_5 99 2 2 0   0     0   0   58 45                       103 99 2 2 0   0     0   0   58 45                 103
1125827 1125827 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_5 7 1 95 0   0     0   0   54 49                       103 7 1 95 0   0     0   0   54 49                 103
1128839 1128839 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No Elementary KG 05 2017   grade_5 66 2 4 1   24     0   6   59 44                       103 66 2 4 1   24     0   6   59 44                 103
1364890 1364890 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_5 76 3 7 0   12     0   5   53 50 *                     103.0 76 3 7 0   12     0   5   53 50                 103
1367704 1367704 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_5 33 5 58 1   4     0   2   56 47 *                     103.0 33 5 58 1   4     0   2   56 47                 103
1367856 1367856 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Veritas Prep Holyoke   Regular School No Middle 05 06 2020   grade_5 4 5 92 0   1     0   1   67 36 *                     103.0 4 5 92 0   1     0   1   67 36                 103
1368640 1368640 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_5 31 21 16 0   30     0   5   51 52 *                     103.0 31 21 16 0   30     0   5   51 52                 103
1368649 1368649 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_5 25 21 39 0   14     0   4   46 57 *                     103.0 25 21 39 0   14     0   4   46 57                 103
1675428 1675428 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington - Joseph Estabrook   Regular School No Elementary KG 05 2021   grade_5 34 3 4 0   58     0   4   59 44 *                     103.0 34 3 4 0   58     0   4   59 44                 103
1677310 1677310 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth - South Elementary   Regular School No Elementary KG 05 2021   grade_5 88 0 9 1   1     1   3   48 55 *                     103.0 88 0 9 1   1     1   3   48 55                 103
1680893 1680893 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_5 92 2 7 0   0     0   2   54 49 *                     103.0 92 2 7 0   0     0   2   54 49                 103
2042595 2042595 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_5 83 2 7 1   6     0   4   64 39                       103.0 83 2 7 1   6     0   4   64 39                 103
2043425 2043425 MA Middlesex   school 2507020 160   Lowell 250702001045 1600040 Peter W Reilly   Regular School No Elementary KG 05 2019   grade_5 36 2 48 0   10     0   7   48 55                       103.0 36 2 48 0   10     0   7   48 55                 103
2046309 2046309 MA Bristol   school 2511460 292   Swansea 251146001890 2920006 Elizabeth S Brown   Regular School No Elementary 03 05 2019   grade_5 100 0 0 0   3     0   0   45 58                       103.0 100 0 0 0   3     0   0   45 58                 103
2228780 2228780 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_5 100 1 2 0   0     0   0   59 44                       103.0 100 1 2 0   0     0   0   59 44                 103
736560 736560 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_5 26 27 44 0   3     0   4   55 49                       104 26 27 44 0   3     0   4   55 49                 104
737793 737793 MA Norfolk   school 2504260 78   Dover 250426000573 780005 Chickering   Regular School No 1 KG 05 2015   grade_5 87 1 4 0   8     0   4   52 52                       104 87 1 4 0   8     0   4   52 52                 104
741524 741524 MA Norfolk   school 2510620 266   Sharon 251062001703 2660010 East Elementary   Regular School No 1 KG 05 2015   grade_5 72 1 2 0   25     0   4   49 55                       104 72 1 2 0   25     0   4   49 55                 104
935506 935506 MA Plymouth   school 2506090 131   Hingham 250609000874 1310020 South Elementary   Regular School No 1 KG 05 2016   grade_5 100 0 0 0   3     0   1   62 42                       104 100 0 0 0   3     0   1   62 42                 104
935755 935755 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_5 8 0 93 0   3     0   0   47 57                       104 8 0 93 0   3     0   0   47 57                 104
935794 935794 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_5 3 0 101 0   0     0   0   57 47                       104 3 0 101 0   0     0   0   57 47                 104
938323 938323 MA Norfolk   school 2510620 266   Sharon 251062001702 2660005 Cottage Street   Regular School No 1 KG 05 2016   grade_5 64 5 8 0   24     0   3   49 55                       104 64 5 8 0   24     0   3   49 55                 104
1128229 1128229 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2017   grade_5 85 2 6 0   6     0   5   53 51                       104 85 2 6 0   6     0   5   53 51                 104
1131533 1131533 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_5 1 66 35 0   0     0   2   51 53                       104 1 66 35 0   0     0   2   51 53                 104
1366173 1366173 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_5 16 73 5 0   2     0   8   54 50 *                     104.0 16 73 5 0   2     0   8   54 50                 104
1366971 1366971 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2020   grade_5 73 7 14 0   6     0   4   61 42 *                     104.0 73 7 14 0   6     0   4   61 42                 104
1369576 1369576 MA Essex   school 2508700 211   North Andover 250870000767 2110018 Annie L Sargent School   Regular School No Elementary 01 05 2020   grade_5 85 3 5 1   7     0   3   57 47 *                     104.0 85 3 5 1   7     0   3   57 47                 104
1370056 1370056 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No Elementary KG 05 2020   grade_5 89 0 4 0   1     0   10   53 51 *                     104.0 89 0 4 0   1     0   10   53 51                 104
1674588 1674588 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_5 19 3 77 0   0     0   5   53 50 *                     104.0 19 3 77 0   0     0   5   53 50                 104
1680318 1680318 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Ashburnham-Westminster - Westminster Elementary   Regular School No Elementary 02 05 2021   grade_5 97 2 4 0   0     0   1   55 49 *                     104.0 97 2 4 0   0     0   1   55 49                 104
1681311 1681311 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_5 95 2 3 0   1     0   3   54 50 *                     104.0 95 2 3 0   1     0   3   54 50                 104
2039942 2039942 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2019   grade_5 66 7 11 0   19     0   1   43 61                       104.0 66 7 11 0   19     0   1   43 61                 104
2040379 2040379 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2019   grade_5 18 24 54 0   4     0   4   65 39                       104.0 18 24 54 0   4     0   4   65 39                 104
2042449 2042449 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2019   grade_5 74 8 20 0   0     0   2   41 63                       104.0 74 8 20 0   0     0   2   41 63                 104
2043101 2043101 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_5 2 0 101 0   1     0   0   50 53                       104.0 2 0 101 0   1     0   0   50 53                 104
2043593 2043593 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2019   grade_5 4 14 75 0   6     0   5   55 49                       104.0 4 14 75 0   6     0   5   55 49                 104
2045136 2045136 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2019   grade_5 91 1 6 1   0     0   5   57 47                       104.0 91 1 6 1   0     0   5   57 47                 104
2046274 2046274 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2019   grade_5 91 0 2 0   2     0   9   55 49                       104.0 91 0 2 0   2     0   9   55 49                 104
2046843 2046843 MA Middlesex   school 2512660 326   Westford 251266000166 3260007 Day Elementary   Regular School No Elementary 03 05 2019   grade_5 57 0 4 0   39     0   4   51 53                       104.0 57 0 4 0   39     0   4   51 53                 104
2048333 2048333 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_5 92 2 5 0   1     0   4   60 44                       104.0 92 2 5 0   1     0   4   60 44                 104
2049136 2049136 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_5 99 0 2 0   0     0   3   52 52                       104.0 99 0 2 0   0     0   3   52 52                 104
2231458 2231458 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_5 40 19 41 1   3     0   0   57 47                       104.0 40 19 41 1   3     0   0   57 47                 104
2234035 2234035 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Needham: Newman Elementary   Regular School No Elementary PK 05 2018   grade_5 80 3 7 0   8     0   6   61 43                       104.0 80 3 7 0   8     0   6   61 43                 104
738593 738593 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_5 69 5 30 0   1     0   0   52 53                       105 69 5 30 0   1     0   0   52 53                 105
740686 740686 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   grade_5 99 2 0 0   3     0   1   44 61                       105 99 2 0 0   3     0   1   44 61                 105
743521 743521 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_5 87 4 2 0   11     0   1   51 54                       105 87 4 2 0   11     0   1   51 54                 105
934747 934747 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No 1 03 05 2016   grade_5 86 7 6 0   6     0   0   58 47                       105 86 7 6 0   6     0   0   58 47                 105
939268 939268 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No 2 04 06 2016   grade_5 89 1 8 0   2     0   5   50 55                       105 89 1 8 0   2     0   5   50 55                 105
940342 940342 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_5 86 2 6 0   6     0   5   63 42                       105 86 2 6 0   6     0   5   63 42                 105
1121972 1121972 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_5 103 1 0 0   0     0   1   58 47                       105 103 1 0 0   0     0   1   58 47                 105
1123605 1123605 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2017   grade_5 34 53 14 0   2     0   2   55 50                       105 34 53 14 0   2     0   2   55 50                 105
1124536 1124536 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_5 89 0 9 0   6     0   1   48 57                       105 89 0 9 0   6     0   1   48 57                 105
1126576 1126576 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_5 41 21 13 1   26     0   3   61 44                       105 41 21 13 1   26     0   3   61 44                 105
1127044 1127044 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_5 82 1 11 0   5     0   6   63 42                       105 82 1 11 0   5     0   6   63 42                 105
1132437 1132437 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_5 100 0 1 0   0     0   4   52 53                       105 100 0 1 0   0     0   4   52 53                 105
2041137 2041137 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2019   grade_5 90 1 2 0   6     0   6   55 50                       105.0 90 1 2 0   6     0   6   55 50                 105
2042042 2042042 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2019   grade_5 80 4 4 0   15     0   2   46 59                       105.0 80 4 4 0   15     0   2   46 59                 105

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