enrollments

Data source: Big Local News · About: Big Local

970 rows where grade = "grade_2", state = "MA" and year = 2021 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 970 ✖

grade ✖

  • grade_2 · 970 ✖
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
1673014 1673014 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_2 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673279 1673279 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1674291 1674291 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_2 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674752 1674752 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_2 * * * *   *     *   *   * * *                     1.0                                             1
1675700 1675700 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1675796 1675796 MA Essex   school 2507110 163   Lynn 250711002527 1630080 Lynn - William R Fallon   Regular School No Elementary 01 05 2021   grade_2 * * * *   *     *   *   3 * *                     5.0                         3                   5
1677739 1677739 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Savoy - Emma L Miller Elementary School   Regular School No Elementary PK 06 2021   grade_2 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1678030 1678030 MA Hampden   school 2511130 281   Springfield 251113002723 2810005 Springfield - Springfield Public Day Elementary School   Regular School No Elementary 01 05 2021   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1672051 1672051 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_2 49 0 5 0   4     0   2   30 30 *                     60.0 49 0 5 0   4     0   2   30 30                 60
1672110 1672110 MA Essex   school 2501950 9   Andover 250195000047 90003 Andover - Bancroft Elementary   Regular School No Elementary KG 05 2021   grade_2 63 0 12 0   6     0   11   43 49 *                     92.0 63 0 12 0   6     0   11   43 49                 92
1672161 1672161 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Arlington - Brackett   Regular School No Elementary KG 05 2021   grade_2 78 0 4 0   6     0   13   55 46 *                     101.0 78 0 4 0   6     0   13   55 46                 101
1672265 1672265 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Auburn - Bryn Mawr   Regular School No Elementary KG 02 2021   grade_2 65 0 9 0   6     0   3   49 34 *                     83.0 65 0 9 0   6     0   3   49 34                 83
1672378 1672378 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Belmont - Winn Brook   Regular School No Elementary KG 04 2021   grade_2 42 0 2 0   39     0   6   46 43 *                     89.0 42 0 2 0   39     0   6   46 43                 89
1672589 1672589 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston - Curtis Guild   Regular School No Elementary PK 06 2021   grade_2 8 0 28 0   1     0   0   22 15 *                     37.0 8 0 28 0   1     0   0   22 15                 37
1672597 1672597 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_2 4 0 10 0   0     0   1   6 9 *                     15.0 4 0 10 0   0     0   1   6 9                 15
1672696 1672696 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston - Hugh Roe O'Donnell   Regular School No Elementary PK 06 2021   grade_2 6 0 34 0   0     0   0   18 22 *                     40.0 6 0 34 0   0     0   0   18 22                 40
1673311 1673311 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford - Harry Lee Cole   Regular School No Elementary PK 02 2021   grade_2 67 0 5 0   0     0   8   42 38 *                     80.0 67 0 5 0   0     0   8   42 38                 80
1673370 1673370 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_2 25 0 1 0   0     0   0   16 10 *                     26.0 25 0 1 0   0     0   0   16 10                 26
1673491 1673491 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_2 33 0 2 0   0     0   0   20 15 *                     35.0 33 0 2 0   0     0   0   20 15                 35
1673594 1673594 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Burlington - Pine Glen Elementary   Regular School No Elementary KG 05 2021   grade_2 46 0 1 0   7     0   5   30 29 *                     59.0 46 0 1 0   7     0   5   30 29                 59
1673868 1673868 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee - Litwin   Regular School No Elementary KG 05 2021   grade_2 16 0 3 0   0     0   0   5 14 *                     19.0 16 0 3 0   0     0   0   5 14                 19
1673912 1673912 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_2 18 0 2 0   0     0   0   10 10 *                     20.0 18 0 2 0   0     0   0   10 10                 20
1673965 1673965 MA Middlesex   school 2503840 67   Concord 250384000526 670030 Concord - Willard   Regular School No Elementary PK 05 2021   grade_2 59 0 1 0   5     0   4   36 33 *                     69.0 59 0 1 0   5     0   4   36 33                 69
1673995 1673995 MA Essex   school 2503990 71   Danvers 250399000536 710030 Danvers - Riverside   Regular School No Elementary PK 05 2021   grade_2 44 0 5 0   1     0   1   27 24 *                     51.0 44 0 5 0   1     0   1   27 24                 51
1674008 1674008 MA Essex   school 2503990 71   Danvers 250399000538 710045 Danvers - Willis E Thorpe   Regular School No Elementary PK 05 2021   grade_2 38 0 2 0   1     0   0   20 21 *                     41.0 38 0 2 0   1     0   0   20 21                 41
1674030 1674030 MA Bristol   school 2504020 72   Dartmouth 250402000542 720030 Dartmouth - George H Potter   Regular School No Elementary PK 05 2021   grade_2 53 0 4 0   0     0   4   30 31 *                     61.0 53 0 4 0   0     0   4   30 31                 61
1674055 1674055 MA Norfolk   school 2504050 73   Dedham 250405000550 730025 Dedham - Greenlodge   Regular School No Elementary 01 05 2021   grade_2 40 0 8 0   0     0   4   26 26 *                     52.0 40 0 8 0   0     0   4   26 26                 52
1674080 1674080 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield - Deerfield Elementary   Regular School No Elementary PK 06 2021   grade_2 33 0 2 0   0     0   4   18 21 *                     39.0 33 0 2 0   0     0   4   18 21                 39
1674088 1674088 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas - Douglas Elementary School   Regular School No Elementary 02 05 2021   grade_2 75 0 5 0   1     0   2   49 34 *                     83.0 75 0 5 0   1     0   2   49 34                 83
1674176 1674176 MA Hampshire   school 2504590 86   Easthampton 250459000611 860005 Easthampton - Center School   Regular School No Elementary KG 04 2021   grade_2 34 0 3 0   0     0   2   22 17 *                     39.0 34 0 3 0   0     0   2   22 17                 39
1674182 1674182 MA Hampshire   school 2504590 86   Easthampton 250459000613 860010 Easthampton - Maple   Regular School No Elementary PK 04 2021   grade_2 37 0 3 0   1     0   0   22 19 *                     41.0 37 0 3 0   1     0   0   22 19                 41
1674187 1674187 MA Hampshire   school 2504590 86   Easthampton 250459002466 860020 Easthampton - Neil A Pepin   Regular School No Elementary KG 04 2021   grade_2 24 0 11 0   1     0   0   15 21 *                     36.0 24 0 11 0   1     0   0   15 21                 36
1674251 1674251 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving - Erving Elementary   Regular School No Elementary PK 06 2021   grade_2 13 0 1 0   0     0   1   11 4 *                     15.0 13 0 1 0   0     0   1   11 4                 15
1674526 1674526 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_2 8 0 0 0   0     0   0   4 4 *                     8.0 8 0 0 0   0     0   0   4 4                 8
1674546 1674546 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Foxborough - Charles Taylor Elementary   Regular School No Elementary KG 04 2021   grade_2 32 0 7 0   2     0   3   24 20 *                     44.0 32 0 7 0   2     0   3   24 20                 44
1674641 1674641 MA Norfolk   school 2505010 101   Franklin 250501000740 1010013 Franklin - J F Kennedy Memorial   Regular School No Elementary KG 05 2021   grade_2 48 0 2 0   2     2   0   28 26 *                     54.0 48 0 2 0   2     2   0   28 26                 54
1674647 1674647 MA Norfolk   school 2505010 101   Franklin 250501000741 1010030 Franklin - Oak Street Elementary   Regular School No Elementary KG 05 2021   grade_2 50 0 5 0   5     0   6   31 35 *                     66.0 50 0 5 0   5     0   6   31 35                 66
1674659 1674659 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Franklin - Davis Thayer   Regular School No Elementary KG 05 2021   grade_2 38 0 2 0   2     2   0   21 23 *                     44.0 38 0 2 0   2     2   0   21 23                 44
1674699 1674699 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_2 98 0 1 0   0     0   5   50 54 *                     104.0 98 0 1 0   0     0   5   50 54                 104
1674718 1674718 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 Gloucester - East Gloucester Elementary   Regular School No Elementary KG 05 2021   grade_2 30 0 5 0   1     0   0   19 17 *                     36.0 30 0 5 0   1     0   0   19 17                 36
1674737 1674737 MA Essex   school 2505280 107   Gloucester 250528000781 1070050 Gloucester - West Parish   Regular School No Elementary KG 05 2021   grade_2 43 0 4 0   0     0   4   22 29 *                     51.0 43 0 4 0   0     0   4   22 29                 51
1674789 1674789 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby - East Meadow   Regular School No Elementary PK 06 2021   grade_2 55 0 9 0   0     0   1   25 40 *                     65.0 55 0 9 0   0     0   1   25 40                 65
1674808 1674808 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Greenfield - Discovery School at Four Corners   Regular School No Elementary KG 04 2021   grade_2 29 0 2 1   2     0   0   14 20 *                     34.0 29 0 2 1   2     0   0   14 20                 34
1674871 1674871 MA Worcester   school 2505880 125   Harvard 250588000839 1250005 Harvard - Hildreth Elementary School   Regular School No Elementary PK 05 2021   grade_2 48 0 2 0   5     0   3   25 33 *                     58.0 48 0 2 0   5     0   3   25 33                 58
1675015 1675015 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland - Holland Elementary   Regular School No Elementary PK 06 2021   grade_2 25 0 1 0   0     0   0   12 14 *                     26.0 25 0 1 0   0     0   0   12 14                 26
1675037 1675037 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke - Joseph Metcalf School   Regular School No Elementary PK 06 2021   grade_2 10 0 29 0   0     0   2   18 23 *                     41.0 10 0 29 0   0     0   2   18 23                 41
1675045 1675045 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_2 9 0 18 0   0     0   0   14 13 *                     27.0 9 0 18 0   0     0   0   14 13                 27
1675066 1675066 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke - Kelly Elementary   Regular School No Elementary PK 08 2021   grade_2 1 0 51 0   0     0   1   30 23 *                     53.0 1 0 51 0   0     0   1   30 23                 53
1675113 1675113 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale - Memorial   Regular School No Elementary KG 06 2021   grade_2 54 0 6 0   2     0   4   36 30 *                     66.0 54 0 6 0   2     0   4   36 30                 66
1675127 1675127 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton - Elmwood   Regular School No Elementary 02 03 2021   grade_2 183 0 17 1   87     0   20   155 153 *                     308.0 183 0 17 1   87     0   20   155 153                 308
1675147 1675147 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Hudson - Forest Avenue Elementary   Regular School No Elementary KG 04 2021   grade_2 49 0 10 0   0     0   3   30 32 *                     62.0 49 0 10 0   0     0   3   30 32                 62
1675180 1675180 MA Essex   school 2506480 144   Ipswich 250648000936 1440007 Ipswich - Paul F Doyon Memorial   Regular School No Elementary KG 05 2021   grade_2 50 0 4 0   0     0   3   25 32 *                     57.0 50 0 4 0   0     0   3   25 32                 57
1675187 1675187 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Ipswich - Winthrop   Regular School No Elementary PK 05 2021   grade_2 39 0 6 0   0     0   5   25 25 *                     50.0 39 0 6 0   0     0   5   25 25                 50
1675200 1675200 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston - Kingston Elementary   Regular School No Elementary KG 02 2021   grade_2 144 0 2 0   0     0   4   75 75 *                     150.0 144 0 2 0   0     0   4   75 75                 150
1675259 1675259 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_2 1 0 87 0   1     0   0   49 40 *                     89.0 1 0 87 0   1     0   0   49 40                 89
1675272 1675272 MA Essex   school 2506660 149   Lawrence 250666002477 1490075 Lawrence - John K Tarbox   Regular School No Elementary 01 05 2021   grade_2 2 0 57 0   0     0   0   34 25 *                     59.0 2 0 57 0   0     0   0   34 25                 59
1675303 1675303 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_2 1 0 5 0   0     0   0   5 1 *                     6.0 1 0 5 0   0     0   0   5 1                 6
1675318 1675318 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee - Lee Elementary   Regular School No Elementary PK 06 2021   grade_2 39 0 7 0   1     0   2   20 29 *                     49.0 39 0 7 0   1     0   2   20 29                 49
1675347 1675347 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Lenox - Morris   Regular School No Elementary PK 05 2021   grade_2 37 0 7 0   2     0   3   28 21 *                     49.0 37 0 7 0   2     0   3   28 21                 49
1675405 1675405 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_2 12 0 1 0   0     0   1   6 8 *                     14.0 12 0 1 0   0     0   1   6 8                 14
1675443 1675443 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Lexington - Maria Hastings   Regular School No Elementary KG 05 2021   grade_2 41 0 7 0   53     0   10   56 55 *                     111.0 41 0 7 0   53     0   10   56 55                 111
1675728 1675728 MA Essex   school 2507110 163   Lynn 250711001062 1630016 Lynn - A Drewicz Elementary   Regular School No Elementary PK 05 2021   grade_2 7 0 52 0   11     0   0   34 36 *                     70.0 7 0 52 0   11     0   0   34 36                 70
1675791 1675791 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn - Lynn Woods   Regular School No Elementary KG 05 2021   grade_2 16 0 9 0   0     0   2   12 15 *                     27.0 16 0 9 0   0     0   2   12 15                 27
1675865 1675865 MA Essex   school 2507140 164   Lynnfield 250714001093 1640020 Lynnfield - Summer Street   Regular School No Elementary KG 04 2021   grade_2 70 0 5 0   4     0   5   37 47 *                     84.0 70 0 5 0   4     0   5   37 47                 84
1676004 1676004 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Marshfield - Eames Way School   Regular School No Elementary KG 05 2021   grade_2 32 0 1 0   0     0   0   15 18 *                     33.0 32 0 1 0   0     0   0   15 18                 33
1676010 1676010 MA Plymouth   school 2507350 171   Marshfield 250735001144 1710010 Marshfield - South River   Regular School No Elementary KG 05 2021   grade_2 29 0 0 0   0     0   1   12 18 *                     30.0 29 0 0 0   0     0   1   12 18                 30
1676017 1676017 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Marshfield - Daniel Webster   Regular School No Elementary PK 05 2021   grade_2 34 0 3 0   1     0   3   28 13 *                     41.0 34 0 3 0   1     0   3   28 13                 41
1676023 1676023 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Marshfield - Gov Edward Winslow   Regular School No Elementary KG 05 2021   grade_2 57 0 3 0   0     0   1   32 29 *                     61.0 57 0 3 0   0     0   1   32 29                 61
1676058 1676058 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Mattapoisett - Center   Regular School No Elementary PK 03 2021   grade_2 54 0 5 0   0     0   4   37 26 *                     63.0 54 0 5 0   0     0   4   37 26                 63
1676163 1676163 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Melrose - Horace Mann   Regular School No Elementary KG 05 2021   grade_2 41 0 1 0   0     0   4   22 24 *                     46.0 41 0 1 0   0     0   4   22 24                 46
1676169 1676169 MA Middlesex   school 2507620 178   Melrose 250762001196 1780035 Melrose - Roosevelt   Regular School No Elementary KG 05 2021   grade_2 56 0 3 0   1     0   5   35 30 *                     65.0 56 0 3 0   1     0   5   35 30                 65
1676342 1676342 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_2 64 0 3 0   1     0   0   26 42 *                     68.0 64 0 3 0   1     0   0   26 42                 68
1676357 1676357 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Nahant - Johnson   Regular School No Elementary PK 06 2021   grade_2 14 0 0 0   0     0   0   11 3 *                     14.0 14 0 0 0   0     0   0   11 3                 14
1676607 1676607 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Newburyport - Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2021   grade_2 126 0 6 0   2     0   3   59 78 *                     137.0 126 0 6 0   2     0   3   59 78                 137
1676627 1676627 MA Middlesex   school 2508610 207   Newton 250861001358 2070015 Newton - Bowen   Regular School No Elementary KG 05 2021   grade_2 27 0 7 0   13     0   10   32 25 *                     57.0 27 0 7 0   13     0   10   32 25                 57
1676669 1676669 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Newton - Mason-Rice   Regular School No Elementary KG 05 2021   grade_2 34 0 1 0   13     0   5   27 26 *                     53.0 34 0 1 0   13     0   5   27 26                 53
1676681 1676681 MA Middlesex   school 2508610 207   Newton 250861001373 2070105 Newton - Memorial Spaulding   Regular School No Elementary KG 05 2021   grade_2 43 0 3 0   11     0   2   26 33 *                     59.0 43 0 3 0   11     0   2   26 33                 59
1676700 1676700 MA Middlesex   school 2508610 207   Newton 250861001382 2070125 Newton - Williams   Regular School No Elementary KG 05 2021   grade_2 15 0 5 0   15     0   3   21 17 *                     38.0 15 0 5 0   15     0   3   21 17                 38
1676742 1676742 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 North Adams - Colegrove Park Elementary   Regular School No Elementary PK 06 2021   grade_2 25 0 2 0   0     0   2   13 16 *                     29.0 25 0 2 0   0     0   2   13 16                 29
1676750 1676750 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 North Adams - Greylock   Regular School No Elementary PK 06 2021   grade_2 22 0 2 0   0     0   4   11 17 *                     28.0 22 0 2 0   0     0   4   11 17                 28
1676844 1676844 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 North Attleborough - Falls   Regular School No Elementary KG 05 2021   grade_2 25 0 1 0   2     0   3   17 14 *                     31.0 25 0 1 0   2     0   3   17 14                 31
1676876 1676876 MA Worcester   school 2508880 213   Northborough 250888001437 2130003 Northborough - Lincoln Street   Regular School No Elementary KG 05 2021   grade_2 35 0 0 0   4     1   0   21 19 *                     40.0 35 0 0 0   4     1   0   21 19                 40
1676938 1676938 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 North Reading - L D Batchelder   Regular School No Elementary KG 05 2021   grade_2 63 0 2 0   2     0   1   37 31 *                     68.0 63 0 2 0   2     0   1   37 31                 68
1676985 1676985 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 Norwell - William G Vinal   Regular School No Elementary PK 05 2021   grade_2 76 0 0 0   2     0   2   48 31 *                     80.0 76 0 0 0   2     0   2   48 31                 80
1677094 1677094 MA Essex   school 2509360 229   Peabody 250936001496 2290007 Peabody - John E Burke   Regular School No Elementary KG 05 2021   grade_2 40 0 4 0   1     0   0   17 28 *                     45.0 40 0 4 0   1     0   0   17 28                 45
1677113 1677113 MA Essex   school 2509360 229   Peabody 250936001821 2290016 Peabody - John E. McCarthy   Regular School No Elementary PK 05 2021   grade_2 33 0 6 0   0     0   3   22 20 *                     42.0 33 0 6 0   0     0   3   22 20                 42
1677134 1677134 MA Essex   school 2509360 229   Peabody 250936001505 2290045 Peabody - West Memorial   Regular School No Elementary PK 05 2021   grade_2 39 0 1 1   1     0   0   22 20 *                     42.0 39 0 1 1   1     0   0   22 20                 42
1677154 1677154 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Pembroke - Bryantville Elementary   Regular School No Elementary KG 06 2021   grade_2 66 0 2 0   0     0   5   39 34 *                     73.0 66 0 2 0   0     0   5   39 34                 73
1677169 1677169 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 Pembroke - North Pembroke Elementary   Regular School No Elementary PK 06 2021   grade_2 62 0 0 0   0     0   0   27 35 *                     62.0 62 0 0 0   0     0   0   27 35                 62
1677183 1677183 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham - Petersham Center   Regular School No Elementary KG 06 2021   grade_2 22 0 2 0   0     0   0   10 14 *                     24.0 22 0 2 0   0     0   0   10 14                 24
1677313 1677313 MA Plymouth   school 2509720 239   Plymouth 250972001548 2390047 Plymouth - West Elementary   Regular School No Elementary KG 05 2021   grade_2 37 0 1 0   1     0   5   21 23 *                     44.0 37 0 1 0   1     0   5   21 23                 44
1677333 1677333 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Plympton - Dennett Elementary   Regular School No Elementary KG 06 2021   grade_2 27 0 0 0   0     0   1   19 9 *                     28.0 27 0 0 0   0     0   1   19 9                 28
1677477 1677477 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Reading - Alice M Barrows   Regular School No Elementary KG 05 2021   grade_2 55 0 3 0   2     0   0   33 27 *                     60.0 55 0 3 0   2     0   0   33 27                 60
1677575 1677575 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_2 10 0 1 0   0     0   1   3 9 *                     12.0 10 0 1 0   0     0   1   3 9                 12
1677585 1677585 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester - Rochester Memorial   Regular School No Elementary PK 06 2021   grade_2 61 0 2 0   0     0   1   32 32 *                     64.0 61 0 2 0   0     0   1   32 32                 64
1677592 1677592 MA Plymouth   school 2510170 251   Rockland 251017001640 2510020 Rockland - Memorial Park   Regular School No Elementary KG 04 2021   grade_2 38 0 16 0   1     0   4   28 31 *                     59.0 38 0 16 0   1     0   4   28 31                 59
1677618 1677618 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport - Rockport Elementary   Regular School No Elementary PK 05 2021   grade_2 47 0 0 0   1     0   1   19 30 *                     49.0 47 0 0 0   1     0   1   19 30                 49
1677630 1677630 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe - Rowe Elementary   Regular School No Elementary PK 06 2021   grade_2 3 0 0 0   0     0   3   1 5 *                     6.0 3 0 0 0   0     0   3   1 5                 6
1677726 1677726 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Saugus - Douglas Waybright   Regular School No Elementary KG 05 2021   grade_2 19 0 5 0   1     0   3   17 11 *                     28.0 19 0 5 0   1     0   3   17 11                 28
1677746 1677746 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Scituate - Cushing Elementary   Regular School No Elementary KG 05 2021   grade_2 57 0 0 1   0     0   2   29 31 *                     60.0 57 0 0 1   0     0   2   29 31                 60

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