enrollments

Data source: Big Local News · About: Big Local

889 rows where grade = "grade_5", state = "MA" and year = 2021 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 889 ✖

grade ✖

  • grade_5 · 889 ✖
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
1673282 1673282 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673451 1673451 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_5 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674755 1674755 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_5 * * * *   *     *   *   * * *                     1.0                                             1
1675612 1675612 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_5 * * * *   *     *   *   1 * *                     2.0                         1                   2
1675703 1675703 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1677633 1677633 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe - Rowe Elementary   Regular School No Elementary PK 06 2021   grade_5 * * * *   *     *   *   1 4 *                     5.0                         1 4                 5
1677742 1677742 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy - Emma L Miller Elementary School   Regular School No Elementary PK 06 2021   grade_5 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1678251 1678251 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield - Springfield International Academy at Johnson   Regular School No Elementary 03 05 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1672029 1672029 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_5 96 0 3 0   1     0   8   57 51 *                     108.0 96 0 3 0   1     0   8   57 51                 108
1672158 1672158 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_5 42 0 1 0   14     2   6   31 34 *                     65.0 42 0 1 0   14     2   6   31 34                 65
1672164 1672164 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_5 53 0 3 0   4     0   4   30 34 *                     64.0 53 0 3 0   4     0   4   30 34                 64
1672411 1672411 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_5 86 0 3 0   0     0   4   35 58 *                     93.0 86 0 3 0   0     0   4   35 58                 93
1672600 1672600 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_5 2 0 2 0   0     0   2   2 4 *                     6.0 2 0 2 0   0     0   2   2 4                 6
1672699 1672699 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston - Hugh Roe O'Donnell   Regular School No Elementary PK 06 2021   grade_5 1 0 27 0   1     0   0   16 13 *                     29.0 1 0 27 0   1     0   0   16 13                 29
1673373 1673373 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_5 29 0 1 0   1     0   0   21 10 *                     31.0 29 0 1 0   1     0   0   21 10                 31
1673494 1673494 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_5 40 0 1 0   0     0   0   19 22 *                     41.0 40 0 1 0   0     0   0   19 22                 41
1673570 1673570 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_5 39 0 8 0   8     0   8   30 33 *                     63.0 39 0 8 0   8     0   8   30 33                 63
1673749 1673749 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_5 47 0 2 0   7     0   2   30 28 *                     58.0 47 0 2 0   7     0   2   30 28                 58
1673915 1673915 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_5 20 0 1 0   0     0   1   8 14 *                     22.0 20 0 1 0   0     0   1   8 14                 22
1673978 1673978 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway - Conway Grammar   Regular School No Elementary PK 06 2021   grade_5 19 0 0 0   0     0   1   8 12 *                     20.0 19 0 0 0   0     0   1   8 12                 20
1673985 1673985 MA Essex   school 2503990 71   Danvers 250399000532 710010 Danvers - Highlands   Regular School No Elementary KG 05 2021   grade_5 50 0 6 0   2     0   3   35 26 *                     61.0 50 0 6 0   2     0   3   35 26                 61
1673991 1673991 MA Essex   school 2503990 71   Danvers 250399000531 710015 Danvers - Great Oak   Regular School No Elementary KG 05 2021   grade_5 54 0 9 0   1     0   3   40 27 *                     67.0 54 0 9 0   1     0   3   40 27                 67
1674026 1674026 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Dartmouth - Joseph Demello   Regular School No Elementary 01 05 2021   grade_5 62 0 5 0   1     0   4   35 37 *                     72.0 62 0 5 0   1     0   4   35 37                 72
1674033 1674033 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 Dartmouth - George H Potter   Regular School No Elementary PK 05 2021   grade_5 57 0 2 0   0     0   3   40 22 *                     62.0 57 0 2 0   0     0   3   40 22                 62
1674083 1674083 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield - Deerfield Elementary   Regular School No Elementary PK 06 2021   grade_5 34 0 2 0   0     0   2   15 23 *                     38.0 34 0 2 0   0     0   2   15 23                 38
1674091 1674091 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas - Douglas Elementary School   Regular School No Elementary 02 05 2021   grade_5 84 0 8 0   1     0   2   47 48 *                     95.0 84 0 8 0   1     0   2   47 48                 95
1674130 1674130 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 Dracut - George H. Englesby Elementary School   Regular School No Elementary KG 05 2021   grade_5 65 0 13 0   8     0   2   37 51 *                     88.0 65 0 13 0   8     0   2   37 51                 88
1674254 1674254 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving - Erving Elementary   Regular School No Elementary PK 06 2021   grade_5 19 0 1 0   0     0   1   12 9 *                     21.0 19 0 1 0   0     0   1   12 9                 21
1674429 1674429 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_5 6 0 0 0   0     0   1   6 1 *                     7.0 6 0 0 0   0     0   1   6 1                 7
1674529 1674529 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_5 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1674662 1674662 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_5 33 0 1 0   0     0   0   16 18 *                     34.0 33 0 1 0   0     0   0   16 18                 34
1674702 1674702 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_5 89 0 5 0   2     0   0   52 44 *                     96.0 89 0 5 0   2     0   0   52 44                 96
1674721 1674721 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester - East Gloucester Elementary   Regular School No Elementary KG 05 2021   grade_5 38 0 3 0   0     0   3   24 20 *                     44.0 38 0 3 0   0     0   3   24 20                 44
1674728 1674728 MA Essex   school 2505280 107   Gloucester 250528000877 1070042 Gloucester - Plum Cove School   Regular School No Elementary KG 05 2021   grade_5 30 0 2 0   0     0   1   17 16 *                     33.0 30 0 2 0   0     0   1   17 16                 33
1674773 1674773 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_5 88 0 4 0   12     1   7   58 54 *                     112.0 88 0 4 0   12     1   7   58 54                 112
1674792 1674792 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby - East Meadow   Regular School No Elementary PK 06 2021   grade_5 45 0 8 1   1     0   3   34 24 *                     58.0 45 0 8 1   1     0   3   34 24                 58
1674830 1674830 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley - Hadley Elementary   Regular School No Elementary PK 06 2021   grade_5 29 0 6 0   2     1   1   22 17 *                     39.0 29 0 6 0   2     1   1   22 17                 39
1674851 1674851 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_5 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
1674888 1674888 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield - Hatfield Elementary   Regular School No Elementary PK 06 2021   grade_5 23 0 2 0   1     0   1   17 10 *                     27.0 23 0 2 0   1     0   1   17 10                 27
1674949 1674949 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_5 9 0 27 0   0     0   2   21 17 *                     38.0 9 0 27 0   0     0   2   21 17                 38
1675076 1675076 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke - E N White Elementary   Regular School No Elementary PK 05 2021   grade_5 5 0 43 0   0     0   2   33 17 *                     50.0 5 0 43 0   0     0   2   33 17                 50
1675083 1675083 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke - Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2021   grade_5 1 0 48 0   1     0   1   22 29 *                     51.0 1 0 48 0   1     0   1   22 29                 51
1675170 1675170 MA Plymouth   school 2506420 142   Hull 250642000932 1420015 Hull - Lillian M Jacobs   Regular School No Elementary PK 05 2021   grade_5 49 0 3 1   3     0   1   30 27 *                     57.0 49 0 3 1   3     0   1   30 27                 57
1675183 1675183 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Ipswich - Paul F Doyon Memorial   Regular School No Elementary KG 05 2021   grade_5 53 0 5 0   0     0   1   30 29 *                     59.0 53 0 5 0   0     0   1   30 29                 59
1675203 1675203 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston - Kingston Intermediate   Regular School No Elementary 03 06 2021   grade_5 156 0 5 1   0     0   0   89 73 *                     162.0 156 0 5 1   0     0   0   89 73                 162
1675224 1675224 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_5 1 0 72 0   2     0   0   38 36 *                     75.0 1 0 72 0   2     0   0   38 36                 75
1675249 1675249 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence - Parthum Middle School   Regular School No Middle 05 08 2021   grade_5 7 0 132 0   2     0   1   76 66 *                     142.0 7 0 132 0   2     0   1   76 66                 142
1675262 1675262 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_5 2 0 86 0   0     0   0   46 42 *                     88.0 2 0 86 0   0     0   0   46 42                 88
1675275 1675275 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_5 0 0 63 0   0     0   0   40 23 *                     63.0 0 0 63 0   0     0   0   40 23                 63
1675281 1675281 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence - Emily G Wetherbee   Regular School No Elementary KG 08 2021   grade_5 1 0 70 0   0     0   2   32 41 *                     73.0 1 0 70 0   0     0   2   32 41                 73
1675321 1675321 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee - Lee Elementary   Regular School No Elementary PK 06 2021   grade_5 45 0 2 0   0     0   1   31 17 *                     48.0 45 0 2 0   0     0   1   31 17                 48
1675350 1675350 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Lenox - Morris   Regular School No Elementary PK 05 2021   grade_5 38 0 3 0   3     0   6   24 26 *                     50.0 38 0 3 0   3     0   6   24 26                 50
1675408 1675408 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_5 14 0 0 0   0     0   1   9 6 *                     15.0 14 0 0 0   0     0   1   9 6                 15
1676007 1676007 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield - Eames Way School   Regular School No Elementary KG 05 2021   grade_5 36 0 0 0   0     0   1   21 16 *                     37.0 36 0 0 0   0     0   1   21 16                 37
1676013 1676013 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 Marshfield - South River   Regular School No Elementary KG 05 2021   grade_5 46 0 3 0   0     0   1   26 24 *                     50.0 46 0 3 0   0     0   1   26 24                 50
1676020 1676020 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield - Daniel Webster   Regular School No Elementary PK 05 2021   grade_5 50 0 0 1   1     1   0   23 30 *                     53.0 50 0 0 1   1     1   0   23 30                 53
1676026 1676026 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Marshfield - Gov Edward Winslow   Regular School No Elementary KG 05 2021   grade_5 70 0 1 0   0     0   2   26 47 *                     73.0 70 0 1 0   0     0   2   26 47                 73
1676033 1676033 MA Plymouth   school 2507350 171   Marshfield 250735001139 1710025 Marshfield - Martinson Elementary   Regular School No Elementary PK 05 2021   grade_5 48 0 3 0   2     0   1   22 32 *                     54.0 48 0 3 0   2     0   1   22 32                 54
1676069 1676069 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard - Fowler School   Regular School No Middle 04 08 2021   grade_5 76 0 15 0   1     0   4   46 50 *                     96.0 76 0 15 0   1     0   4   46 50                 96
1676178 1676178 MA Middlesex   school 2507620 178   Melrose 250762001198 1780050 Melrose - Winthrop   Regular School No Elementary KG 05 2021   grade_5 56 0 2 0   0     0   4   33 29 *                     62.0 56 0 2 0   0     0   4   33 29                 62
1676360 1676360 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant - Johnson   Regular School No Elementary PK 06 2021   grade_5 18 0 1 0   0     0   1   8 12 *                     20.0 18 0 1 0   0     0   1   8 12                 20
1676431 1676431 MA Norfolk   school 2508370 199   Needham 250837001313 1990035 Needham - Sunita L. Williams Elementary   Regular School No Elementary KG 05 2021   grade_5 64 0 6 0   10     0   8   52 36 *                     88.0 64 0 6 0   10     0   8   52 36                 88
1676437 1676437 MA Norfolk   school 2508370 199   Needham 250837001317 1990040 Needham - William Mitchell   Regular School No Elementary KG 05 2021   grade_5 69 0 4 0   9     0   7   36 53 *                     89.0 69 0 4 0   9     0   7   36 53                 89
1676556 1676556 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 New Bedford - Thomas R Rodman   Regular School No Elementary KG 05 2021   grade_5 10 0 4 0   0     0   2   6 10 *                     16.0 10 0 4 0   0     0   2   6 10                 16
1676576 1676576 MA Bristol   school 2508430 201   New Bedford 250843001319 2010140 New Bedford - Betsey B Winslow   Regular School No Elementary KG 05 2021   grade_5 16 0 5 1   1     0   2   15 10 *                     25.0 16 0 5 1   1     0   2   15 10                 25
1676654 1676654 MA Middlesex   school 2508610 207   Newton 250861001366 2070055 Newton - Franklin   Regular School No Elementary KG 05 2021   grade_5 39 0 5 0   8     0   3   28 27 *                     55.0 39 0 5 0   8     0   3   28 27                 55
1676672 1676672 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Newton - Mason-Rice   Regular School No Elementary KG 05 2021   grade_5 62 0 3 0   11     0   7   45 38 *                     83.0 62 0 3 0   11     0   7   45 38                 83
1676691 1676691 MA Middlesex   school 2508610 207   Newton 250861001379 2070115 Newton - Underwood   Regular School No Elementary KG 05 2021   grade_5 27 0 3 0   8     0   3   17 24 *                     41.0 27 0 3 0   8     0   3   17 24                 41
1676697 1676697 MA Middlesex   school 2508610 207   Newton 250861001369 2070120 Newton - John Ward   Regular School No Elementary KG 05 2021   grade_5 31 0 1 0   6     0   4   20 22 *                     42.0 31 0 1 0   6     0   4   20 22                 42
1676733 1676733 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk - Freeman-Kennedy School   Regular School No Elementary 03 06 2021   grade_5 131 0 7 0   2     0   4   80 64 *                     144.0 131 0 7 0   2     0   4   80 64                 144
1676753 1676753 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams - Greylock   Regular School No Elementary PK 06 2021   grade_5 23 0 2 0   0     0   1   9 17 *                     26.0 23 0 2 0   0     0   1   9 17                 26
1676775 1676775 MA Hampshire   school 2508850 210   Northampton 250885001425 2100005 Northampton - Bridge Street   Regular School No Elementary PK 05 2021   grade_5 16 0 9 0   1     0   2   12 16 *                     28.0 16 0 9 0   1     0   2   12 16                 28
1676818 1676818 MA Essex   school 2508700 211   North Andover 250870001396 2110015 North Andover - Kittredge   Regular School No Elementary 01 05 2021   grade_5 37 0 6 0   2     0   1   28 18 *                     46.0 37 0 6 0   2     0   1   28 18                 46
1676823 1676823 MA Essex   school 2508700 211   North Andover 250870000767 2110018 North Andover - Annie L Sargent School   Regular School No Elementary 01 05 2021   grade_5 74 0 3 0   5     0   5   32 55 *                     87.0 74 0 3 0   5     0   5   32 55                 87
1676828 1676828 MA Essex   school 2508700 211   North Andover 250870001399 2110020 North Andover - Thomson   Regular School No Elementary 01 05 2021   grade_5 53 0 10 0   2     0   3   37 31 *                     68.0 53 0 10 0   2     0   3   37 31                 68
1676879 1676879 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Northborough - Lincoln Street   Regular School No Elementary KG 05 2021   grade_5 38 0 0 1   4     1   2   19 27 *                     46.0 38 0 0 1   4     1   2   19 27                 46
1676885 1676885 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Northborough - Marguerite E Peaslee   Regular School No Elementary KG 05 2021   grade_5 41 0 6 0   4     8   3   36 26 *                     62.0 41 0 6 0   4     8   3   36 26                 62
1676907 1676907 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge - Northbridge Middle   Regular School No Middle 05 08 2021   grade_5 123 0 16 0   2     0   9   57 93 *                     150.0 123 0 16 0   2     0   9   57 93                 150
1676921 1676921 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield - North Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_5 29 0 3 0   1     0   0   19 14 *                     33.0 29 0 3 0   1     0   0   19 14                 33
1676935 1676935 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 North Reading - E Ethel Little School   Regular School No Elementary PK 05 2021   grade_5 48 0 2 0   2     0   4   30 26 *                     56.0 48 0 2 0   2     0   4   30 26                 56
1676941 1676941 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 North Reading - L D Batchelder   Regular School No Elementary KG 05 2021   grade_5 64 0 8 0   4     0   7   52 31 *                     83.0 64 0 8 0   4     0   7   52 31                 83
1676988 1676988 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 Norwell - William G Vinal   Regular School No Elementary PK 05 2021   grade_5 87 0 3 0   4     0   2   49 47 *                     96.0 87 0 3 0   4     0   2   49 47                 96
1677044 1677044 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Orange - Dexter Park   Regular School No Elementary 03 06 2021   grade_5 60 0 7 0   1     0   2   32 38 *                     70.0 60 0 7 0   1     0   2   32 38                 70
1677137 1677137 MA Essex   school 2509360 229   Peabody 250936001505 2290045 Peabody - West Memorial   Regular School No Elementary PK 05 2021   grade_5 35 0 1 0   0     0   1   24 13 *                     37.0 35 0 1 0   0     0   1   24 13                 37
1677150 1677150 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham - Pelham Elementary   Regular School No Elementary KG 06 2021   grade_5 10 0 5 0   0     0   1   8 8 *                     16.0 10 0 5 0   0     0   1   8 8                 16
1677157 1677157 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Pembroke - Bryantville Elementary   Regular School No Elementary KG 06 2021   grade_5 63 0 0 0   1     0   3   35 32 *                     67.0 63 0 0 0   1     0   3   35 32                 67
1677164 1677164 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Pembroke - Hobomock Elementary   Regular School No Elementary KG 06 2021   grade_5 69 0 0 0   1     0   2   39 33 *                     72.0 69 0 0 0   1     0   2   39 33                 72
1677186 1677186 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham - Petersham Center   Regular School No Elementary KG 06 2021   grade_5 14 0 0 0   0     0   2   11 5 *                     16.0 14 0 0 0   0     0   2   11 5                 16
1677228 1677228 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Pittsfield - Stearns   Regular School No Elementary KG 05 2021   grade_5 30 0 4 0   0     0   3   22 15 *                     37.0 30 0 4 0   0     0   3   22 15                 37
1677274 1677274 MA Plymouth   school 2509720 239   Plymouth 250972001539 2390005 Plymouth - Cold Spring   Regular School No Elementary KG 05 2021   grade_5 18 0 2 0   1     0   1   13 9 *                     22.0 18 0 2 0   1     0   1   13 9                 22
1677280 1677280 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Plymouth - Hedge   Regular School No Elementary KG 05 2021   grade_5 19 0 6 0   2     0   3   15 15 *                     30.0 19 0 6 0   2     0   3   15 15                 30
1677292 1677292 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Plymouth - Indian Brook   Regular School No Elementary KG 05 2021   grade_5 85 0 2 0   0     0   5   52 40 *                     92.0 85 0 2 0   0     0   5   52 40                 92
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
1677336 1677336 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton - Dennett Elementary   Regular School No Elementary KG 06 2021   grade_5 37 0 1 0   0     0   0   19 19 *                     38.0 37 0 1 0   0     0   0   19 19                 38
1677360 1677360 MA Norfolk   school 2509870 243   Quincy 250987001568 2430025 Quincy - Charles A Bernazzani Elementary   Regular School No Elementary KG 05 2021   grade_5 33 0 4 0   15     0   4   28 28 *                     56.0 33 0 4 0   15     0   4   28 28                 56
1677527 1677527 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Revere - Beachmont Veterans Memorial School   Regular School No Elementary PK 05 2021   grade_5 19 0 29 0   1     0   1   25 25 *                     50.0 19 0 29 0   1     0   1   25 25                 50
1677549 1677549 MA Suffolk   school 2510050 248   Revere 251005001629 2480050 Revere - Paul Revere   Regular School No Elementary KG 05 2021   grade_5 33 0 34 0   5     0   2   37 37 *                     74.0 33 0 34 0   5     0   2   37 37                 74
1677588 1677588 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester - Rochester Memorial   Regular School No Elementary PK 06 2021   grade_5 75 0 2 0   0     0   5   42 40 *                     82.0 75 0 2 0   0     0   5   42 40                 82
1677621 1677621 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport - Rockport Elementary   Regular School No Elementary PK 05 2021   grade_5 64 0 0 0   0     0   0   32 32 *                     64.0 64 0 0 0   0     0   0   32 32                 64
1677768 1677768 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Scituate - Wampatuck Elementary   Regular School No Elementary PK 05 2021   grade_5 49 0 4 0   0     0   2   28 27 *                     55.0 49 0 4 0   0     0   2   28 27                 55

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