enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 956 ✖

grade ✖

  • grade_4 · 956 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total ▼ white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1674754 1674754 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1675702 1675702 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
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
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
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
1674772 1674772 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_4 82 1 7 1   7     0   4   47 55 *                     102.0 82 1 7 1   7     0   4   47 55                 102
1675364 1675364 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Leominster - Fall Brook   Regular School No Elementary KG 05 2021   grade_4 46 11 36 0   2     0   7   55 47 *                     102.0 46 11 36 0   2     0   7   55 47                 102
1677365 1677365 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_4 29 15 23 1   28     1   5   53 49 *                     102.0 29 15 23 1   28     1   5   53 49                 102
1679095 1679095 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 West Springfield - Philip G Coburn   Regular School No Elementary KG 05 2021   grade_4 57 4 27 0   12     0   2   48 54 *                     102.0 57 4 27 0   12     0   2   48 54                 102
1680825 1680825 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Monomoy Regional School District - Harwich Elementary School   Regular School No Elementary PK 04 2021   grade_4 81 7 5 0   0     0   9   45 57 *                     102.0 81 7 5 0   0     0   9   45 57                 102
1673448 1673448 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   grade_4 17 58 17 1   1     1   8   60 43 *                     103.0 17 58 17 1   1     1   8   60 43                 103
1675781 1675781 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn - Ingalls   Regular School No Elementary KG 05 2021   grade_4 4 7 82 1   6     0   3   52 51 *                     103.0 4 7 82 1   6     0   3   52 51                 103
1676222 1676222 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen - Donald P Timony Grammar   Regular School No Elementary PK 08 2021   grade_4 36 4 53 0   3     0   7   57 46 *                     103.0 36 4 53 0   3     0   7   57 46                 103
1676385 1676385 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Natick - Brown   Regular School No Elementary KG 04 2021   grade_4 64 0 12 0   22     0   5   53 50 *                     103.0 64 0 12 0   22     0   5   53 50                 103
1675749 1675749 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Lynn - Cobbet Elementary   Regular School No Elementary KG 05 2021   grade_4 5 6 88 0   3     0   2   56 48 *                     104.0 5 6 88 0   3     0   2   56 48                 104
1677555 1677555 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Revere - Garfield Elementary School   Regular School No Elementary PK 05 2021   grade_4 24 0 73 0   7     0   0   55 49 *                     104.0 24 0 73 0   7     0   0   55 49                 104
1678827 1678827 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Wayland - Claypit Hill School   Regular School No Elementary KG 05 2021   grade_4 78 4 2 0   14     0   6   49 55 *                     104.0 78 4 2 0   14     0   6   49 55                 104
1678962 1678962 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 West Bridgewater - Howard School   Regular School No Middle 04 06 2021   grade_4 83 8 6 1   1     0   5   50 54 *                     104.0 83 8 6 1   1     0   5   50 54                 104
1681139 1681139 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Spencer-E Brookfield - Wire Village School   Regular School No Elementary KG 04 2021   grade_4 79 4 20 0   0     0   1   59 45 *                     104.0 79 4 20 0   0     0   1   59 45                 104
1675261 1675261 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_4 1 1 102 0   1     0   0   54 51 *                     105.0 1 1 102 0   1     0   0   54 51                 105
1679248 1679248 MA Middlesex   school 2513050 342   Wilmington 251305001576 3420080 Wilmington - West Intermediate   Regular School No Elementary 04 05 2021   grade_4 83 1 5 1   12     0   3   50 55 *                     105.0 83 1 5 1   12     0   3   50 55                 105
1674356 1674356 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River - Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2021   grade_4 52 4 43 1   2     0   5   60 47 *                     107.0 52 4 43 1   2     0   5   60 47                 107
1674397 1674397 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   grade_4 50 3 41 0   6     0   7   49 58 *                     107.0 50 3 41 0   6     0   7   49 58                 107
1674587 1674587 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_4 18 6 79 0   0     0   4   53 54 *                     107.0 18 6 79 0   0     0   4   53 54                 107
1673782 1673782 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_4 67 7 12 0   18     0   4   56 52 *                     108.0 67 7 12 0   18     0   4   56 52                 108
1676521 1676521 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 New Bedford - Abraham Lincoln   Regular School No Elementary KG 05 2021   grade_4 52 14 34 1   2     0   5   49 59 *                     108.0 52 14 34 1   2     0   5   49 59                 108
1679079 1679079 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport - Westport Elementary   Regular School No Elementary 03 06 2021   grade_4 97 0 6 0   0     0   5   61 47 *                     108.0 97 0 6 0   0     0   5   61 47                 108
1680535 1680535 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Dighton-Rehoboth - Palmer River   Regular School No Elementary PK 04 2021   grade_4 96 2 2 1   3     0   4   53 55 *                     108.0 96 2 2 1   3     0   4   53 55                 108
1680559 1680559 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley-Charlton Reg - Dudley Elementary   Regular School No Elementary 02 04 2021   grade_4 94 3 9 0   1     0   1   54 54 *                     108.0 94 3 9 0   1     0   1   54 54                 108
1674363 1674363 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   grade_4 38 11 43 0   4     0   13   66 43 *                     109.0 38 11 43 0   4     0   13   66 43                 109
1679262 1679262 MA Worcester   school 2513080 343   Winchendon 251308000804 3430050 Winchendon - Toy Town Elementary   Regular School No Elementary 03 05 2021   grade_4 96 0 8 0   0     1   4   68 41 *                     109.0 96 0 8 0   0     1   4   68 41                 109
1674528 1674528 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_4 11 0 0 0   0     0   0   5 6 *                     11.0 11 0 0 0   0     0   0   5 6                 11
1675665 1675665 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_4 5 0 2 0   3     0   1   10 1 *                     11.0 5 0 2 0   3     0   1   10 1                 11
1677343 1677343 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_4 6 1 3 0   0     0   1   5 6 *                     11.0 6 1 3 0   0     0   1   5 6                 11
1678250 1678250 MA Hampden   school 2511130 281   Springfield 251113002898 2810215 Springfield - Springfield International Academy at Johnson   Regular School No Elementary 03 05 2021   grade_4 0 4 7 0   0     0   0   5 6 *                     11.0 0 4 7 0   0     0   0   5 6                 11
1680039 1680039 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_4 7 0 1 0   0     0   3   7 4 *                     11.0 7 0 1 0   0     0   3   7 4                 11
1677542 1677542 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Revere - Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2021   grade_4 27 2 73 0   5     0   3   54 56 *                     110.0 27 2 73 0   5     0   3   54 56                 110
1678623 1678623 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Uxbridge - Whitin Intermediate   Regular School No Middle 04 07 2021   grade_4 99 0 7 0   0     0   4   60 50 *                     110.0 99 0 7 0   0     0   4   60 50                 110
1680181 1680181 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_4 81 10 12 0   0     0   7   57 53 *                     110.0 81 10 12 0   0     0   7   57 53                 110
1675688 1675688 MA Worcester   school 2507080 162   Lunenburg 250708002871 1620025 Lunenburg - Turkey Hill Elementary School   Regular School No Elementary 03 05 2021   grade_4 93 5 7 0   3     0   3   55 56 *                     111.0 93 5 7 0   3     0   3   55 56                 111
1675980 1675980 MA Middlesex   school 2507320 170   Marlborough 250732002913 1700020 Marlborough - Goodnow Brothers Elementary School   Regular School No Elementary KG 05 2021   grade_4 50 3 54 0   2     0   2   61 50 *                     111.0 50 3 54 0   2     0   2   61 50                 111
1677076 1677076 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Palmer - Old Mill Pond   Regular School No Elementary PK 05 2021   grade_4 82 5 17 0   2     0   5   48 63 *                     111.0 82 5 17 0   2     0   5   48 63                 111
1679246 1679246 MA Middlesex   school 2513050 342   Wilmington 251305001575 3420060 Wilmington - North Intermediate   Regular School No Elementary 04 05 2021   grade_4 96 2 4 0   4     0   5   58 53 *                     111.0 96 2 4 0   4     0   5   58 53                 111
1675482 1675482 MA Middlesex   school 2506960 158   Littleton 250696001013 1580015 Littleton - Russell St Elementary   Regular School No Elementary 03 05 2021   grade_4 98 1 2 0   9     0   2   56 56 *                     112.0 98 1 2 0   9     0   2   56 56                 112
1681251 1681251 MA Worcester   school 2511880 775   Wachusett 251188002131 7750060 Wachusett - Glenwood Elementary School   Regular School No Elementary 03 05 2021   grade_4 98 2 10 0   1     0   1   56 56 *                     112.0 98 2 10 0   1     0   1   56 56                 112
1674286 1674286 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_4 17 17 69 1   4     1   4   64 49 *                     113.0 17 17 69 1   4     1   4   64 49                 113
1675992 1675992 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Marlborough - Charles Jaworek School   Regular School No Elementary KG 05 2021   grade_4 37 3 67 0   4     0   2   53 60 *                     113.0 37 3 67 0   4     0   2   53 60                 113
1677309 1677309 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 Plymouth - South Elementary   Regular School No Elementary KG 05 2021   grade_4 99 0 3 2   0     0   9   68 45 *                     113.0 99 0 3 2   0     0   9   68 45                 113
1680892 1680892 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Narragansett - Templeton Elementary School   Regular School No Elementary PK 05 2021   grade_4 103 1 4 0   1     0   4   57 56 *                     113.0 103 1 4 0   1     0   4   57 56                 113
1673935 1673935 MA Norfolk   school 2503780 65   Cohasset 250378000519 650005 Cohasset - Deer Hill   Regular School No Elementary 03 05 2021   grade_4 105 2 1 0   2     0   4   60 54 *                     114.0 105 2 1 0   2     0   4   60 54                 114
1672865 1672865 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_4 18 15 21 2   53     0   6   64 51 *                     115.0 18 15 21 2   53     0   6   64 51                 115
1676852 1676852 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 North Attleborough - Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2021   grade_4 101 3 5 1   3     0   2   62 53 *                     115.0 101 3 5 1   3     0   2   62 53                 115
1675002 1675002 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 Holbrook - John F Kennedy   Regular School No Elementary PK 05 2021   grade_4 56 23 26 0   5     0   6   68 48 *                     116.0 56 23 26 0   5     0   6   68 48                 116
1675917 1675917 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden - Salemwood   Regular School No Elementary KG 08 2021   grade_4 23 26 46 0   18     0   3   64 52 *                     116.0 23 26 46 0   18     0   3   64 52                 116
1681448 1681448 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_4 14 29 42 0   24     0   7   61 55 *                     116.0 14 29 42 0   24     0   7   61 55                 116
1672396 1672396 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_4 78 1 0 0   23     0   15   62 55 *                     117.0 78 1 0 0   23     0   15   62 55                 117
1672747 1672747 MA Suffolk   school 2502790 35   Boston 250279000268 350167 Boston - UP Academy Holland   Regular School No Elementary PK 05 2021   grade_4 1 49 60 1   2     1   3   51 66 *                     117.0 1 49 60 1   2     1   3   51 66                 117
1674350 1674350 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   grade_4 60 12 32 1   0     0   12   61 56 *                     117.0 60 12 32 1   0     0   12   61 56                 117
1676239 1676239 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_4 108 1 0 0   3     0   5   61 56 *                     117.0 108 1 0 0   3     0   5   61 56                 117
1676380 1676380 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Natick - Bennett-Hemenway   Regular School No Elementary KG 04 2021   grade_4 97 1 3 0   10     0   6   54 63 *                     117.0 97 1 3 0   10     0   6   54 63                 117
1679927 1679927 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_4 21 57 34 0   3     0   2   48 69 *                     117.0 21 57 34 0   3     0   2   48 69                 117
1675376 1675376 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Leominster - Johnny Appleseed   Regular School No Elementary KG 05 2021   grade_4 52 16 42 1   3     0   4   53 65 *                     118.0 52 16 42 1   3     0   4   53 65                 118
1680654 1680654 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Groton-Dunstable - Florence Roche School   Regular School No Elementary KG 04 2021   grade_4 98 3 1 0   10     0   6   62 56 *                     118.0 98 3 1 0   10     0   6   62 56                 118
1673412 1673412 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_4 10 86 17 0   0     0   6   60 59 *                     119.0 10 86 17 0   0     0   6   60 59                 119
1676482 1676482 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 New Bedford - Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2021   grade_4 52 23 39 0   1     0   5   62 58 *                     120.0 52 23 39 0   1     0   5   62 58                 120
1677836 1677836 MA Worcester   school 2510770 271   Shrewsbury 251077001713 2710015 Shrewsbury - Calvin Coolidge   Regular School No Elementary KG 04 2021   grade_4 45 5 19 1   39     0   11   68 52 *                     120.0 45 5 19 1   39     0   11   68 52                 120
1678536 1678536 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Taunton - Elizabeth Pole   Regular School No Elementary KG 04 2021   grade_4 56 44 11 0   2     0   7   56 64 *                     120.0 56 44 11 0   2     0   7   56 64                 120
1679030 1679030 MA Middlesex   school 2512660 326   Westford 251266001737 3260045 Westford - John A. Crisafulli Elementary School   Regular School No Elementary 03 05 2021   grade_4 80 1 2 0   32     0   5   55 65 *                     120.0 80 1 2 0   32     0   5   55 65                 120
1680103 1680103 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_4 1 71 44 0   0     0   4   52 68 *                     120.0 1 71 44 0   0     0   4   52 68                 120
1673870 1673870 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee - Litwin   Regular School No Elementary KG 05 2021   grade_4 58 12 48 0   1     0   2   57 64 *                     121.0 58 12 48 0   1     0   2   57 64                 121
1674499 1674499 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg - South Street Elementary   Regular School No Elementary PK 04 2021   grade_4 23 7 75 0   5     0   11   62 59 *                     121.0 23 7 75 0   5     0   11   62 59                 121
1674905 1674905 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Haverhill - Golden Hill   Regular School No Elementary KG 04 2021   grade_4 47 5 61 0   4     0   4   64 57 *                     121.0 47 5 61 0   4     0   4   64 57                 121
1675244 1675244 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence - Gerard A. Guilmette   Regular School No Elementary 01 04 2021   grade_4 1 1 117 0   1     0   1   60 61 *                     121.0 1 1 117 0   1     0   1   60 61                 121
1675382 1675382 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Leominster - Northwest   Regular School No Elementary KG 05 2021   grade_4 44 8 59 0   2     0   8   65 56 *                     121.0 44 8 59 0   2     0   8   65 56                 121
1672454 1672454 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Billerica - Thomas Ditson   Regular School No Elementary KG 04 2021   grade_4 90 7 10 0   10     0   5   63 59 *                     122.0 90 7 10 0   10     0   5   63 59                 122
1675236 1675236 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence - Robert Frost   Regular School No Elementary KG 04 2021   grade_4 9 6 106 0   1     0   0   52 70 *                     122.0 9 6 106 0   1     0   0   52 70                 122
1679693 1679693 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham - Charles E Roderick   Regular School No Middle 04 06 2021   grade_4 105 4 9 0   3     0   1   65 57 *                     122.0 105 4 9 0   3     0   1   65 57                 122
1674483 1674483 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   grade_4 36 1 69 0   3     0   14   71 52 *                     123.0 36 1 69 0   3     0   14   71 52                 123
1675445 1675445 MA Middlesex   school 2506840 155   Lexington 250684000473 1550035 Lexington - Maria Hastings   Regular School No Elementary KG 05 2021   grade_4 39 2 7 0   69     0   6   64 59 *                     123.0 39 2 7 0   69     0   6   64 59                 123
1676202 1676202 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen - Comprehensive Grammar School   Regular School No Elementary PK 08 2021   grade_4 59 12 47 0   5     0   0   65 58 *                     123.0 59 12 47 0   5     0   0   65 58                 123
1677980 1677980 MA Worcester   school 2510980 276   Southborough 251098001760 2760020 Southborough - Margaret A Neary   Regular School No Elementary 04 05 2021   grade_4 84 1 3 1   23     0   11   62 61 *                     123.0 84 1 3 1   23     0   11   62 61                 123
1678412 1678412 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge - Burgess Elementary   Regular School No Elementary PK 06 2021   grade_4 101 1 12 0   2     0   7   65 58 *                     123.0 101 1 12 0   2     0   7   65 58                 123
1680068 1680068 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   grade_4 52 22 16 0   20     0   13   68 55 *                     123.0 52 22 16 0   20     0   13   68 55                 123
1672943 1672943 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston - Josiah Quincy   Regular School No Elementary PK 05 2021   grade_4 8 16 13 0   84     0   3   66 58 *                     124.0 8 16 13 0   84     0   3   66 58                 124
1674934 1674934 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Haverhill - Silver Hill Elementary School   Regular School No Elementary KG 05 2021   grade_4 54 12 45 0   4     0   9   63 61 *                     124.0 54 12 45 0   4     0   9   63 61                 124
1676309 1676309 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Milton - Collicot   Regular School No Elementary KG 05 2021   grade_4 89 5 7 0   17     0   6   66 58 *                     124.0 89 5 7 0   17     0   6   66 58                 124
1679814 1679814 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_4 7 24 85 2   3     0   4   56 69 *                     125.0 7 24 85 2   3     0   4   56 69                 125
1673806 1673806 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_4 6 8 112 0   0     0   0   69 57 *                     126.0 6 8 112 0   0     0   0   69 57                 126
1678099 1678099 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Springfield - Rebecca M Johnson   Regular School No Elementary PK 05 2021   grade_4 3 30 91 0   1     0   1   66 60 *                     126.0 3 30 91 0   1     0   1   66 60                 126
1673380 1673380 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton - Dr W Arnone Community School   Regular School No Elementary PK 05 2021   grade_4 14 82 20 1   0     0   10   75 52 *                     127.0 14 82 20 1   0     0   10   75 52                 127
1676212 1676212 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   grade_4 40 1 76 0   3     0   7   64 63 *                     127.0 40 1 76 0   3     0   7   64 63                 127
1673298 1673298 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne - Bourne Intermediate School   Regular School No Elementary 03 05 2021   grade_4 115 3 4 1   2     0   3   59 69 *                     128.0 115 3 4 1   2     0   3   59 69                 128
1675270 1675270 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Lawrence - Edward F. Parthum   Regular School No Elementary KG 04 2021   grade_4 9 5 114 0   0     0   0   67 61 *                     128.0 9 5 114 0   0     0   0   67 61                 128

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