enrollments

Data source: Big Local News · About: Big Local

979 rows where grade = "grade_1", state = "MA" and year = 2019 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 979 ✖

grade ✖

  • grade_1 · 979 ✖
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
2042765 2042765 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2045562 2045562 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2019   grade_1 9 1 0 0   0     0   0   4 6                       10.0 9 1 0 0   0     0   0   4 6                 10
2041623 2041623 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2019   grade_1 72 1 3 1   18     0   5   49 51                       100.0 72 1 3 1   18     0   5   49 51                 100
2042143 2042143 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_1 21 15 49 1   11     0   3   52 48                       100.0 21 15 49 1   11     0   3   52 48                 100
2042242 2042242 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary KG 05 2019   grade_1 49 11 20 0   7     0   13   48 52                       100.0 49 11 20 0   7     0   13   48 52                 100
2044021 2044021 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   grade_1 59 4 30 0   4     0   3   55 45                       100.0 59 4 30 0   4     0   3   55 45                 100
2044887 2044887 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   grade_1 85 2 9 0   1     0   3   51 49                       100.0 85 2 9 0   1     0   3   51 49                 100
2046647 2046647 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2019   grade_1 81 4 3 0   10     0   2   47 53                       100.0 81 4 3 0   10     0   2   47 53                 100
2041251 2041251 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2019   grade_1 23 65 5 0   3     1   4   35 66                       101.0 23 65 5 0   3     1   4   35 66                 101
2041280 2041280 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2019   grade_1 21 60 13 2   1     0   4   65 36                       101.0 21 60 13 2   1     0   4   65 36                 101
2043211 2043211 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2019   grade_1 49 9 36 0   2     0   5   52 49                       101.0 49 9 36 0   2     0   5   52 49                 101
2043594 2043594 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2019   grade_1 4 10 73 0   11     0   3   50 51                       101.0 4 10 73 0   11     0   3   50 51                 101
2043702 2043702 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_1 33 8 14 0   41     0   5   49 52                       101.0 33 8 14 0   41     0   5   49 52                 101
2043711 2043711 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_1 25 19 28 0   25     0   4   52 49                       101.0 25 19 28 0   25     0   4   52 49                 101
2044903 2044903 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2019   grade_1 82 4 10 0   1     0   4   42 59                       101.0 82 4 10 0   1     0   4   42 59                 101
2049033 2049033 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2019   grade_1 89 1 7 0   2     0   2   46 55                       101.0 89 1 7 0   2     0   2   46 55                 101
2040371 2040371 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 02 2019   grade_1 5 69 25 0   0     0   3   62 40                       102.0 5 69 25 0   0     0   3   62 40                 102
2041608 2041608 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2019   grade_1 71 3 5 0   20     0   3   54 48                       102.0 71 3 5 0   20     0   3   54 48                 102
2044216 2044216 MA Middlesex   school 2508340 198   Natick 250834001299 1980035 Lilja Elementary   Regular School No Elementary KG 04 2019   grade_1 76 2 8 0   13     0   3   48 54                       102.0 76 2 8 0   13     0   3   48 54                 102
2045132 2045132 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2019   grade_1 86 1 5 0   0     0   10   60 42                       102.0 86 1 5 0   0     0   10   60 42                 102
2045491 2045491 MA Essex   school 2510380 258   Salem 251038001668 2580070 Witchcraft Heights   Regular School No Elementary KG 05 2019   grade_1 45 8 41 0   4     0   4   53 49                       102.0 45 8 41 0   4     0   4   53 49                 102
2047073 2047073 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2019   grade_1 90 0 5 0   2     0   5   55 47                       102.0 90 0 5 0   2     0   5   55 47                 102
2048771 2048771 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2019   grade_1 92 2 2 0   0     0   6   49 53                       102.0 92 2 2 0   0     0   6   49 53                 102
2041393 2041393 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   grade_1 49 4 9 0   29     0   12   56 47                       103.0 49 4 9 0   29     0   12   56 47                 103
2041641 2041641 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2019   grade_1 11 5 85 0   1     0   1   45 58                       103.0 11 5 85 0   1     0   1   45 58                 103
2045199 2045199 MA Norfolk   school 2509870 243   Quincy 250987001220 2430055 Clifford H Marshall Elementary   Regular School No Elementary KG 04 2019   grade_1 23 14 10 0   56     0   0   49 54                       103.0 23 14 10 0   56     0   0   49 54                 103
2042316 2042316 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2019   grade_1 28 5 55 0   5     0   11   54 50                       104.0 28 5 55 0   5     0   11   54 50                 104
2042591 2042591 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2019   grade_1 86 1 3 0   9     0   5   53 51                       104.0 86 1 3 0   9     0   5   53 51                 104
2044054 2044054 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2019   grade_1 89 2 4 2   2     0   5   61 43                       104.0 89 2 4 2   2     0   5   61 43                 104
2039827 2039827 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2019   grade_1 95 3 4 0   1     0   2   55 50                       105.0 95 3 4 0   1     0   2   55 50                 105
2041263 2041263 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2019   grade_1 14 65 15 0   9     0   2   58 47                       105.0 14 65 15 0   9     0   2   58 47                 105
2041646 2041646 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2019   grade_1 17 9 76 0   1     0   2   58 47                       105.0 17 9 76 0   1     0   2   58 47                 105
2042152 2042152 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_1 15 14 74 0   2     0   0   59 46                       105.0 15 14 74 0   2     0   0   59 46                 105
2042189 2042189 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2019   grade_1 57 9 22 0   4     0   13   54 51                       105.0 57 9 22 0   4     0   13   54 51                 105
2042535 2042535 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2019   grade_1 99 0 2 0   2     0   2   56 49                       105.0 99 0 2 0   2     0   2   56 49                 105
2042682 2042682 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2019   grade_1 95 0 7 0   0     0   3   61 44                       105.0 95 0 7 0   0     0   3   61 44                 105
2045188 2045188 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2019   grade_1 31 12 10 1   44     2   5   46 59                       105.0 31 12 10 1   44     2   5   46 59                 105
2046626 2046626 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2019   grade_1 65 4 17 1   7     0   11   49 56                       105.0 65 4 17 1   7     0   11   49 56                 105
2041642 2041642 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_1 3 9 90 0   3     0   1   53 53                       106.0 3 9 90 0   3     0   1   53 53                 106
2041781 2041781 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2019   grade_1 100 3 2 0   1     0   0   46 60                       106.0 100 3 2 0   1     0   0   46 60                 106
2043072 2043072 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2019   grade_1 8 0 91 0   6     0   1   55 51                       106.0 8 0 91 0   6     0   1   55 51                 106
2044305 2044305 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2019   grade_1 33 17 43 0   1     0   12   52 54                       106.0 33 17 43 0   1     0   12   52 54                 106
2048401 2048401 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2019   grade_1 98 3 2 0   0     0   3   62 44                       106.0 98 3 2 0   0     0   3   62 44                 106
2043582 2043582 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2019   grade_1 5 6 82 0   12     0   2   50 57                       107.0 5 6 82 0   12     0   2   50 57                 107
2044143 2044143 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2019   grade_1 83 6 5 0   5     0   8   50 57                       107.0 83 6 5 0   5     0   8   50 57                 107
2044789 2044789 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2019   grade_1 96 1 4 0   0     0   6   48 59                       107.0 96 1 4 0   0     0   6   48 59                 107
2046055 2046055 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   grade_1 5 18 84 0   0     0   0   51 56                       107.0 5 18 84 0   0     0   0   51 56                 107
2046897 2046897 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   grade_1 100 1 2 0   0     0   4   54 53                       107.0 100 1 2 0   0     0   4   54 53                 107
2048397 2048397 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2019   grade_1 102 0 2 0   1     0   2   48 59                       107.0 102 0 2 0   1     0   2   48 59                 107
2041650 2041650 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 05 2019   grade_1 3 4 101 0   0     0   0   48 60                       108.0 3 4 101 0   0     0   0   48 60                 108
2041876 2041876 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2019   grade_1 98 2 3 0   0     0   5   57 51                       108.0 98 2 3 0   0     0   5   57 51                 108
2042236 2042236 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2019   grade_1 57 9 29 0   6     0   7   45 63                       108.0 57 9 29 0   6     0   7   45 63                 108
2043217 2043217 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2019   grade_1 47 5 46 0   3     0   7   61 47                       108.0 47 5 46 0   3     0   7   61 47                 108
2044338 2044338 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2019   grade_1 21 13 71 1   0     0   3   59 50                       109.0 21 13 71 1   0     0   3   59 50                 109
2048450 2048450 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2019   grade_1 97 0 2 0   4     0   6   58 51                       109.0 97 0 2 0   4     0   6   58 51                 109
2048620 2048620 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2019   grade_1 79 6 9 1   2     0   12   66 43                       109.0 79 6 9 1   2     0   12   66 43                 109
2045166 2045166 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_1 8 2 1 0   0     0   0   3 8                       11.0 8 2 1 0   0     0   0   3 8                 11
2049016 2049016 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2019   grade_1 9 0 0 1   0     0   1   5 6                       11.0 9 0 0 1   0     0   1   5 6                 11
2040559 2040559 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2019   grade_1 0 57 43 1   3     0   6   59 51                       110.0 0 57 43 1   3     0   6   59 51                 110
2041211 2041211 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   grade_1 11 66 27 0   0     0   6   63 47                       110.0 11 66 27 0   0     0   6   63 47                 110
2042202 2042202 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2019   grade_1 32 9 50 1   2     1   15   59 51                       110.0 32 9 50 1   2     1   15   59 51                 110
2043606 2043606 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2019   grade_1 10 12 71 1   13     0   3   62 48                       110.0 10 12 71 1   13     0   3   62 48                 110
2044201 2044201 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2019   grade_1 90 2 2 1   14     0   1   60 50                       110.0 90 2 2 1   14     0   1   60 50                 110
2047985 2047985 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_1 86 6 7 0   1     0   10   55 55                       110.0 86 6 7 0   1     0   10   55 55                 110
2049273 2049273 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_1 10 22 36 0   38     0   4   63 47                       110.0 10 22 36 0   38     0   4   63 47                 110
2040197 2040197 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2019   grade_1 76 4 4 0   18     0   9   61 50                       111.0 76 4 4 0   18     0   9   61 50                 111
2044130 2044130 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2019   grade_1 93 2 4 0   11     0   1   59 52                       111.0 93 2 4 0   11     0   1   59 52                 111
2045377 2045377 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2019   grade_1 27 5 74 0   3     0   2   56 55                       111.0 27 5 74 0   3     0   2   56 55                 111
2045661 2045661 MA Worcester   school 2510770 271   Shrewsbury 251077001047 2710020 Floral Street School   Regular School No Elementary 01 04 2019   grade_1 29 5 10 4   59     0   4   54 57                       111.0 29 5 10 4   59     0   4   54 57                 111
2045941 2045941 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No Elementary PK 05 2019   grade_1 21 23 55 1   5     0   6   60 51                       111.0 21 23 55 1   5     0   6   60 51                 111
2046430 2046430 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2019   grade_1 87 7 8 0   4     0   5   60 51                       111.0 87 7 8 0   4     0   5   60 51                 111
2047378 2047378 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2019   grade_1 19 15 59 0   10     0   8   59 52                       111.0 19 15 59 0   10     0   8   59 52                 111
2048329 2048329 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary PK 04 2019   grade_1 100 1 2 0   1     0   7   58 53                       111.0 100 1 2 0   1     0   7   58 53                 111
2040115 2040115 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_1 88 2 12 0   0     0   10   57 55                       112.0 88 2 12 0   0     0   10   57 55                 112
2043173 2043173 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No Elementary PK 02 2019   grade_1 92 6 11 0   2     0   1   58 54                       112.0 92 6 11 0   2     0   1   58 54                 112
2043199 2043199 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2019   grade_1 63 8 33 0   2     0   6   68 44                       112.0 63 8 33 0   2     0   6   68 44                 112
2044929 2044929 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Thomas Carroll   Regular School No Elementary KG 05 2019   grade_1 84 5 22 0   1     0   0   51 61                       112.0 84 5 22 0   1     0   0   51 61                 112
2046745 2046745 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2019   grade_1 53 2 5 0   51     0   1   64 48                       112.0 53 2 5 0   51     0   1   64 48                 112
2043527 2043527 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2019   grade_1 93 3 12 0   4     0   2   58 56                       114.0 93 3 12 0   4     0   2   58 56                 114
2043799 2043799 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2019   grade_1 50 7 51 0   6     0   0   59 55                       114.0 50 7 51 0   6     0   0   59 55                 114
2043864 2043864 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_1 85 2 4 6   3     0   14   66 48                       114.0 85 2 4 6   3     0   14   66 48                 114
2046226 2046226 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_1 98 1 7 0   2     0   6   54 60                       114.0 98 1 7 0   2     0   6   54 60                 114
2047731 2047731 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_1 16 55 30 1   5     0   7   40 74                       114.0 16 55 30 1   5     0   7   40 74                 114
2043886 2043886 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2019   grade_1 90 1 15 0   2     0   7   60 55                       115.0 90 1 15 0   2     0   7   60 55                 115
2046351 2046351 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No Elementary KG 04 2019   grade_1 51 30 16 0   1     0   17   67 48                       115.0 51 30 16 0   1     0   17   67 48                 115
2046388 2046388 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2019   grade_1 110 1 1 0   1     0   2   54 61                       115.0 110 1 1 0   1     0   2   54 61                 115
2048147 2048147 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2019   grade_1 96 1 10 0   3     0   5   57 58                       115.0 96 1 10 0   3     0   5   57 58                 115
2040749 2040749 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   grade_1 11 12 8 0   82     0   3   58 58                       116.0 11 12 8 0   82     0   3   58 58                 116
2041593 2041593 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2019   grade_1 111 2 1 0   0     0   2   54 62                       116.0 111 2 1 0   0     0   2   54 62                 116
2042332 2042332 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2019   grade_1 34 9 62 0   6     0   6   61 56                       117.0 34 9 62 0   6     0   6   61 56                 117
2043055 2043055 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   grade_1 2 0 115 0   0     0   0   59 58                       117.0 2 0 115 0   0     0   0   59 58                 117
2042322 2042322 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2019   grade_1 36 9 61 0   2     0   10   62 56                       118.0 36 9 61 0   2     0   10   62 56                 118
2044011 2044011 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_1 55 6 48 0   5     0   4   66 52                       118.0 55 6 48 0   5     0   4   66 52                 118
2046385 2046385 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2019   grade_1 99 5 7 0   7     0   0   60 58                       118.0 99 5 7 0   7     0   0   60 58                 118
2046849 2046849 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No Elementary KG 02 2019   grade_1 73 0 3 0   38     0   4   59 59                       118.0 73 0 3 0   38     0   4   59 59                 118
2047706 2047706 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_1 20 32 56 0   3     0   7   58 60                       118.0 20 32 56 0   3     0   7   58 60                 118
2044561 2044561 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2019   grade_1 114 1 1 0   3     0   0   68 51                       119.0 114 1 1 0   3     0   0   68 51                 119
2045364 2045364 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2019   grade_1 30 6 76 0   4     0   3   60 59                       119.0 30 6 76 0   4     0   3   60 59                 119
2046855 2046855 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary KG 02 2019   grade_1 69 1 3 0   42     0   4   59 60                       119.0 69 1 3 0   42     0   4   59 60                 119
2040318 2040318 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2019   grade_1 4 3 3 0   1     0   1   8 4                       12.0 4 3 3 0   1     0   1   8 4                 12

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