enrollments

Data source: Big Local News · About: Big Local

973 rows where grade = "grade_1", state = "MA" and year = 2021 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 973 ✖

grade ✖

  • grade_1 · 973 ✖
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
1674751 1674751 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1675699 1675699 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1677146 1677146 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham - Pelham Elementary   Regular School No Elementary KG 06 2021   grade_1 8 0 0 0   2     0   0   8 2 *                     10.0 8 0 0 0   2     0   0   8 2                 10
1673807 1673807 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_1 6 8 84 1   0     0   1   63 37 *                     100.0 6 8 84 1   0     0   1   63 37                 100
1676065 1676065 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Maynard - Green Meadow   Regular School No Elementary PK 03 2021   grade_1 79 1 12 0   4     0   4   55 45 *                     100.0 79 1 12 0   4     0   4   55 45                 100
1676382 1676382 MA Middlesex   school 2508340 198   Natick 250834001292 1980010 Natick - Brown   Regular School No Elementary KG 04 2021   grade_1 55 2 10 0   27     0   6   54 46 *                     100.0 55 2 10 0   27     0   6   54 46                 100
1677061 1677061 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Oxford - Alfred M Chaffee   Regular School No Elementary PK 01 2021   grade_1 75 1 15 0   3     0   6   49 51 *                     100.0 75 1 15 0   3     0   6   49 51                 100
1679076 1679076 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport - Alice A Macomber   Regular School No Elementary PK 02 2021   grade_1 95 0 4 0   0     0   1   50 50 *                     100.0 95 0 4 0   0     0   1   50 50                 100
1673430 1673430 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_1 13 63 14 0   9     0   2   65 36 *                     101.0 13 63 14 0   9     0   2   65 36                 101
1675746 1675746 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Lynn - Cobbet Elementary   Regular School No Elementary KG 05 2021   grade_1 2 8 85 0   3     0   3   52 49 *                     101.0 2 8 85 0   3     0   3   52 49                 101
1676231 1676231 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough - Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2021   grade_1 89 5 2 0   0     0   5   48 53 *                     101.0 89 5 2 0   0     0   5   48 53                 101
1679023 1679023 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Westford - Nabnasset   Regular School No Elementary KG 02 2021   grade_1 76 1 0 0   19     0   5   49 52 *                     101.0 76 1 0 0   19     0   5   49 52                 101
1674374 1674374 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_1 48 6 39 0   3     0   6   56 46 *                     102.0 48 6 39 0   3     0   6   56 46                 102
1676984 1676984 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 Norwell - William G Vinal   Regular School No Elementary PK 05 2021   grade_1 91 0 1 0   2     0   8   51 51 *                     102.0 91 0 1 0   2     0   8   51 51                 102
1678522 1678522 MA Bristol   school 2511520 293   Taunton 251152001065 2930010 Taunton - East Taunton Elementary   Regular School No Elementary KG 04 2021   grade_1 66 15 15 0   0     0   6   53 49 *                     102.0 66 15 15 0   0     0   6   53 49                 102
1673802 1673802 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea - Shurtleff Early Childhood   Regular School No Elementary PK 01 2021   grade_1 4 1 96 0   0     0   2   53 50 *                     103.0 4 1 96 0   0     0   2   53 50                 103
1675886 1675886 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_1 28 18 34 0   16     0   7   58 45 *                     103.0 28 18 34 0   16     0   7   58 45                 103
1678921 1678921 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 Westborough - J Harding Armstrong   Regular School No Elementary KG 03 2021   grade_1 47 4 10 0   36     0   6   64 39 *                     103.0 47 4 10 0   36     0   6   64 39                 103
1679243 1679243 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington - Shawsheen Elementary   Regular School No Elementary 01 03 2021   grade_1 77 3 7 0   9     0   7   59 44 *                     103.0 77 3 7 0   9     0   7   59 44                 103
1679690 1679690 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham - Delaney   Regular School No Elementary PK 03 2021   grade_1 91 1 4 0   1     0   6   47 56 *                     103.0 91 1 4 0   1     0   6   47 56                 103
1679708 1679708 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_1 16 15 60 1   0     0   11   49 54 *                     103.0 16 15 60 1   0     0   11   49 54                 103
1677516 1677516 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 Revere - A. C. Whelan Elementary School   Regular School No Elementary KG 05 2021   grade_1 37 2 54 0   7     0   4   57 47 *                     104.0 37 2 54 0   7     0   4   57 47                 104
1680511 1680511 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth - Station Avenue Elementary   Regular School No Elementary KG 03 2021   grade_1 78 11 7 0   5     0   3   58 46 *                     104.0 78 11 7 0   5     0   3   58 46                 104
1672744 1672744 MA Suffolk   school 2502790 35   Boston 250279000268 350167 Boston - UP Academy Holland   Regular School No Elementary PK 05 2021   grade_1 5 53 42 0   1     1   3   59 46 *                     105.0 5 53 42 0   1     1   3   59 46                 105
1673310 1673310 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford - Harry Lee Cole   Regular School No Elementary PK 02 2021   grade_1 94 0 4 0   1     0   6   58 47 *                     105.0 94 0 4 0   1     0   6   58 47                 105
1673939 1673939 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   grade_1 91 7 2 0   0     0   5   51 54 *                     105.0 91 7 2 0   0     0   5   51 54                 105
1674698 1674698 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_1 98 0 4 0   1     0   2   47 58 *                     105.0 98 0 4 0   1     0   2   47 58                 105
1675685 1675685 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg - Lunenburg Primary School   Regular School No Elementary PK 02 2021   grade_1 89 1 10 0   1     0   4   58 47 *                     105.0 89 1 10 0   1     0   4   58 47                 105
1680599 1680599 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown-Lakeville - Freetown Elementary School   Regular School No Elementary PK 03 2021   grade_1 98 0 5 0   0     0   2   64 41 *                     105.0 98 0 5 0   0     0   2   64 41                 105
1675904 1675904 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   grade_1 31 22 18 0   32     0   3   59 47 *                     106.0 31 22 18 0   32     0   3   59 47                 106
1676440 1676440 MA Norfolk   school 2508370 199   Needham 250837000306 1990050 Needham - Newman Elementary   Regular School No Elementary PK 05 2021   grade_1 71 6 7 0   13     0   9   59 47 *                     106.0 71 6 7 0   13     0   9   59 47                 106
1678409 1678409 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Sturbridge - Burgess Elementary   Regular School No Elementary PK 06 2021   grade_1 94 1 6 0   2     0   3   53 53 *                     106.0 94 1 6 0   2     0   3   53 53                 106
1674302 1674302 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett - Lafayette School   Regular School No Elementary KG 08 2021   grade_1 19 16 60 0   10     0   2   56 51 *                     107.0 19 16 60 0   10     0   2   56 51                 107
1674353 1674353 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River - Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2021   grade_1 46 8 38 0   6     0   9   48 59 *                     107.0 46 8 38 0   6     0   9   48 59                 107
1674897 1674897 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Haverhill - Bradford Elementary   Regular School No Elementary KG 04 2021   grade_1 46 5 51 0   2     0   3   59 48 *                     107.0 46 5 51 0   2     0   3   59 48                 107
1676319 1676319 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Milton - Glover   Regular School No Elementary KG 05 2021   grade_1 79 4 8 1   6     0   9   48 59 *                     107.0 79 4 8 1   6     0   9   48 59                 107
1673377 1673377 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton - Dr W Arnone Community School   Regular School No Elementary PK 05 2021   grade_1 17 63 22 0   0     0   6   61 47 *                     108.0 17 63 22 0   0     0   6   61 47                 108
1672393 1672393 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_1 73 4 0 0   19     0   13   57 52 *                     109.0 73 4 0 0   19     0   13   57 52                 109
1674311 1674311 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett - Parlin School   Regular School No Elementary KG 08 2021   grade_1 19 11 72 0   6     0   1   47 62 *                     109.0 19 11 72 0   6     0   1   47 62                 109
1674769 1674769 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 Grafton - North Grafton Elementary   Regular School No Elementary PK 01 2021   grade_1 91 2 4 0   9     0   3   42 67 *                     109.0 91 2 4 0   9     0   3   42 67                 109
1680603 1680603 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Freetown-Lakeville - Assawompset Elementary School   Regular School No Elementary KG 03 2021   grade_1 95 5 3 0   0     0   6   50 59 *                     109.0 95 5 3 0   0     0   6   50 59                 109
1672497 1672497 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_1 2 3 5 0   1     0   0   6 5 *                     11.0 2 3 5 0   1     0   0   6 5                 11
1680624 1680624 MA Hampshire   school 2505160 672   Gateway 250516000757 6720059 Gateway - Chester Elementary   Regular School No Elementary PK 05 2021   grade_1 9 0 1 0   1     0   0   5 6 *                     11.0 9 0 1 0   1     0   0   5 6                 11
1680745 1680745 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont - Hawlemont Regional   Regular School No Elementary PK 06 2021   grade_1 10 0 1 0   0     0   0   3 8 *                     11.0 10 0 1 0   0     0   0   3 8                 11
1674999 1674999 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 Holbrook - John F Kennedy   Regular School No Elementary PK 05 2021   grade_1 63 19 15 1   3     0   9   57 53 *                     110.0 63 19 15 1   3     0   9   57 53                 110
1676189 1676189 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen - Marsh Grammar School   Regular School No Elementary PK 08 2021   grade_1 56 3 44 0   3     0   4   65 45 *                     110.0 56 3 44 0   3     0   4   65 45                 110
1678606 1678606 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough - Tyngsborough Elementary   Regular School No Elementary PK 05 2021   grade_1 81 5 10 0   10     0   4   47 63 *                     110.0 81 5 10 0   10     0   4   47 63                 110
1680178 1680178 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_1 72 7 20 0   4     0   7   52 58 *                     110.0 72 7 20 0   4     0   7   52 58                 110
1680889 1680889 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Narragansett - Templeton Elementary School   Regular School No Elementary PK 05 2021   grade_1 95 2 8 0   0     0   5   56 54 *                     110.0 95 2 8 0   0     0   5   56 54                 110
1675233 1675233 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence - Robert Frost   Regular School No Elementary KG 04 2021   grade_1 7 2 96 0   5     0   1   58 53 *                     111.0 7 2 96 0   5     0   1   58 53                 111
1678014 1678014 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 South Hadley - Plains Elementary   Regular School No Elementary PK 01 2021   grade_1 74 3 23 0   5     0   6   53 58 *                     111.0 74 3 23 0   5     0   6   53 58                 111
1679568 1679568 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Worcester - Quinsigamond   Regular School No Elementary PK 06 2021   grade_1 28 22 51 1   4     0   5   57 54 *                     111.0 28 22 51 1   4     0   5   57 54                 111
1679897 1679897 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_1 11 38 54 0   0     0   8   50 61 *                     111.0 11 38 54 0   0     0   8   50 61                 111
1680532 1680532 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Dighton-Rehoboth - Palmer River   Regular School No Elementary PK 04 2021   grade_1 103 0 3 0   3     0   2   52 59 *                     111.0 103 0 3 0   3     0   2   52 59                 111
1674486 1674486 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg - Reingold Elementary   Regular School No Elementary PK 04 2021   grade_1 38 4 58 0   4     0   8   57 55 *                     112.0 38 4 58 0   4     0   8   57 55                 112
1674496 1674496 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg - South Street Elementary   Regular School No Elementary PK 04 2021   grade_1 26 5 68 0   2     0   11   71 41 *                     112.0 26 5 68 0   2     0   11   71 41                 112
1676236 1676236 MA Plymouth   school 2507770 182   Middleborough 250777002741 1820010 Middleborough - Mary K. Goode Elementary School   Regular School No Elementary 01 05 2021   grade_1 100 2 3 2   0     0   5   62 50 *                     112.0 100 2 3 2   0     0   5   62 50                 112
1678564 1678564 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Tewksbury - Heath-Brook   Regular School No Elementary KG 02 2021   grade_1 100 4 5 0   0     0   3   55 57 *                     112.0 100 4 5 0   0     0   3   55 57                 112
1672940 1672940 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston - Josiah Quincy   Regular School No Elementary PK 05 2021   grade_1 11 13 11 0   68     0   10   54 59 *                     113.0 11 13 11 0   68     0   10   54 59                 113
1673436 1673436 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_1 8 90 11 0   0     2   2   67 46 *                     113.0 8 90 11 0   0     2   2   67 46                 113
1675479 1675479 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Littleton - Shaker Lane Elementary   Regular School No Elementary PK 02 2021   grade_1 90 0 3 0   19     1   1   53 61 *                     114.0 90 0 3 0   19     1   1   53 61                 114
1677539 1677539 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Revere - Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2021   grade_1 32 2 78 0   1     0   1   52 62 *                     114.0 32 2 78 0   1     0   1   52 62                 114
1677837 1677837 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Shrewsbury - Floral Street School   Regular School No Elementary 01 04 2021   grade_1 41 2 8 0   60     0   3   53 61 *                     114.0 41 2 8 0   60     0   3   53 61                 114
1673295 1673295 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_1 88 2 12 1   3     0   9   62 53 *                     115.0 88 2 12 1   3     0   9   62 53                 115
1674584 1674584 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_1 16 0 91 0   2     0   6   50 65 *                     115.0 16 0 91 0   2     0   6   50 65                 115
1677362 1677362 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Quincy - Lincoln-Hancock Community School   Regular School No Elementary KG 04 2021   grade_1 37 8 18 2   44     0   6   61 54 *                     115.0 37 8 18 2   44     0   6   61 54                 115
1674347 1674347 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   grade_1 58 16 30 0   0     0   12   53 63 *                     116.0 58 16 30 0   0     0   12   53 63                 116
1674480 1674480 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   grade_1 26 9 70 0   4     0   7   57 59 *                     116.0 26 9 70 0   4     0   7   57 59                 116
1675379 1675379 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Leominster - Northwest   Regular School No Elementary KG 05 2021   grade_1 46 13 49 0   3     0   5   55 61 *                     116.0 46 13 49 0   3     0   5   55 61                 116
1677552 1677552 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Revere - Garfield Elementary School   Regular School No Elementary PK 05 2021   grade_1 22 6 81 0   5     0   2   58 58 *                     116.0 22 6 81 0   5     0   2   58 58                 116
1679924 1679924 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_1 26 65 7 1   4     0   13   55 61 *                     116.0 26 65 7 1   4     0   13   55 61                 116
1678620 1678620 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge - Taft Early Learning Center   Regular School No Elementary PK 03 2021   grade_1 98 0 17 0   1     0   1   63 54 *                     117.0 98 0 17 0   1     0   1   63 54                 117
1679240 1679240 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington - Woburn Street   Regular School No Elementary 01 03 2021   grade_1 97 2 7 0   6     0   6   71 47 *                     118.0 97 2 7 0   6     0   6   71 47                 118
1674394 1674394 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   grade_1 46 14 38 0   8     0   13   54 65 *                     119.0 46 14 38 0   8     0   13   54 65                 119
1675216 1675216 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence - Community Day Arlington   Regular School No Elementary KG 04 2021   grade_1 3 1 115 0   0     0   0   60 55 *                     119.0 3 1 115 0   0     0   0   60 55                 119
1675977 1675977 MA Middlesex   school 2507320 170   Marlborough 250732002913 1700020 Marlborough - Goodnow Brothers Elementary School   Regular School No Elementary KG 05 2021   grade_1 56 1 57 0   4     0   1   73 46 *                     119.0 56 1 57 0   4     0   1   73 46                 119
1676364 1676364 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket - Nantucket Elementary   Regular School No Elementary PK 02 2021   grade_1 48 7 60 0   2     0   2   62 57 *                     119.0 48 7 60 0   2     0   2   62 57                 119
1677629 1677629 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe - Rowe Elementary   Regular School No Elementary PK 06 2021   grade_1 11 0 1 0   0     0   0   6 6 *                     12.0 11 0 1 0   0     0   0   6 6                 12
1679049 1679049 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton - Westhampton Elementary School   Regular School No Elementary PK 06 2021   grade_1 12 0 0 0   0     0   0   9 3 *                     12.0 12 0 0 0   0     0   0   9 3                 12
1679231 1679231 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg - Anne T. Dunphy School   Regular School No Elementary PK 06 2021   grade_1 11 1 0 0   0     0   0   9 3 *                     12.0 11 1 0 0   0     0   0   9 3                 12
1680665 1680665 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill-Montague - Gill Elementary   Regular School No Elementary KG 06 2021   grade_1 11 0 1 0   0     0   0   6 6 *                     12.0 11 0 1 0   0     0   0   6 6                 12
1681095 1681095 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 Southern Berkshire - New Marlborough Central   Regular School No Elementary PK 04 2021   grade_1 12 0 0 0   0     0   0   6 6 *                     12.0 12 0 0 0   0     0   0   6 6                 12
1675373 1675373 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Leominster - Johnny Appleseed   Regular School No Elementary KG 05 2021   grade_1 49 17 43 0   4     0   7   60 60 *                     120.0 49 17 43 0   4     0   7   60 60                 120
1676279 1676279 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury - Elmwood Street   Regular School No Elementary PK 03 2021   grade_1 97 1 8 0   8     0   7   71 50 *                     121.0 97 1 8 0   8     0   7   71 50                 121
1674035 1674035 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 Dartmouth - James M. Quinn School   Regular School No Elementary KG 05 2021   grade_1 106 1 5 0   2     0   8   67 55 *                     122.0 106 1 5 0   2     0   8   67 55                 122
1676737 1676737 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 Norfolk - H Olive Day   Regular School No Elementary PK 02 2021   grade_1 109 1 5 0   4     0   3   58 64 *                     122.0 109 1 5 0   4     0   3   58 64                 122
1677373 1677373 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Quincy - Clifford H Marshall Elementary   Regular School No Elementary KG 04 2021   grade_1 28 20 16 0   59     0   0   61 62 *                     123.0 28 20 16 0   59     0   0   61 62                 123
1673921 1673921 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton - Clinton Elementary   Regular School No Elementary PK 04 2021   grade_1 85 4 33 0   0     0   2   62 62 *                     124.0 85 4 33 0   0     0   2   62 62                 124
1679811 1679811 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_1 13 13 95 0   1     0   2   65 59 *                     124.0 13 13 95 0   1     0   2   65 59                 124
1673755 1673755 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   grade_1 116 6 3 0   0     0   2   63 64 *                     127.0 116 6 3 0   0     0   2   63 64                 127
1678599 1678599 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro - Truro Central   Regular School No Elementary PK 06 2021   grade_1 8 1 0 0   0     0   4   7 6 *                     13.0 8 1 0 0   0     0   4   7 6                 13
1680036 1680036 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_1 12 0 1 0   0     0   0   7 6 *                     13.0 12 0 1 0   0     0   0   7 6                 13
1680874 1680874 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Mohawk Trail - Sanderson Academy   Regular School No Elementary PK 06 2021   grade_1 12 0 0 0   0     0   1   7 6 *                     13.0 12 0 0 0   0     0   1   7 6                 13
1676219 1676219 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen - Donald P Timony Grammar   Regular School No Elementary PK 08 2021   grade_1 51 10 61 1   4     1   3   72 59 *                     131.0 51 10 61 1   4     1   3   72 59                 131
1678561 1678561 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 Tewksbury - L F Dewing   Regular School No Elementary PK 02 2021   grade_1 106 7 7 0   9     0   2   65 66 *                     131.0 106 7 7 0   9     0   2   65 66                 131
1675210 1675210 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_1 4 4 117 0   6     0   1   64 67 *                     132.0 4 4 117 0   6     0   1   64 67                 132
1676606 1676606 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Newburyport - Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2021   grade_1 118 0 5 0   2     0   7   71 61 *                     132.0 118 0 5 0   2     0   7   71 61                 132
1675989 1675989 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Marlborough - Charles Jaworek School   Regular School No Elementary KG 05 2021   grade_1 60 4 52 0   11     0   6   78 55 *                     133.0 60 4 52 0   11     0   6   78 55                 133
1676518 1676518 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 New Bedford - Abraham Lincoln   Regular School No Elementary KG 05 2021   grade_1 50 14 59 0   2     0   12   75 62 *                     137.0 50 14 59 0   2     0   12   75 62                 137
1680565 1680565 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Dudley-Charlton Reg - Charlton Elementary   Regular School No Elementary PK 01 2021   grade_1 120 2 13 0   0     0   2   75 62 *                     137.0 120 2 13 0   0     0   2   75 62                 137

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