enrollments

Data source: Big Local News · About: Big Local

972 rows where grade = "grade_2", state = "MA" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 972 ✖

grade ✖

  • grade_2 · 972 ✖
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
1368459 1368459 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1374309 1374309 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1367682 1367682 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_2 * * * *   *     *   *   1 * *                     1.0                         1                   1
1367022 1367022 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2020   grade_2 10 0 0 0   0     0   0   5 5 *                     10.0 10 0 0 0   0     0   0   5 5                 10
1370488 1370488 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2020   grade_2 9 1 0 0   0     0   0   4 6 *                     10.0 9 1 0 0   0     0   0   4 6                 10
1371797 1371797 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2020   grade_2 9 0 1 0   0     0   0   3 7 *                     10.0 9 0 1 0   0     0   0   3 7                 10
1373943 1373943 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2020   grade_2 8 0 0 1   0     0   1   5 5 *                     10.0 8 0 0 1   0     0   1   5 5                 10
1367137 1367137 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2020   grade_2 51 8 30 0   1     0   10   53 47 *                     100.0 51 8 30 0   1     0   10   53 47                 100
1371195 1371195 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2020   grade_2 93 0 4 1   1     0   1   50 50 *                     100.0 93 0 4 1   1     0   1   50 50                 100
1371554 1371554 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2020   grade_2 64 4 15 1   7     0   9   44 56 *                     100.0 64 4 15 1   7     0   9   44 56                 100
1368646 1368646 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_2 25 16 30 0   25     0   5   56 45 *                     101.0 25 16 30 0   25     0   5   56 45                 101
1366212 1366212 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_2 18 62 16 1   1     0   4   65 37 *                     102.0 18 62 16 1   1     0   4   65 37                 102
1367171 1367171 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary PK 05 2020   grade_2 53 7 22 0   6     0   14   48 54 *                     102.0 53 7 22 0   6     0   14   48 54                 102
1368180 1368180 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2020   grade_2 36 3 3 0   44     0   16   59 43 *                     102.0 36 3 3 0   44     0   16   59 43                 102
1368519 1368519 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2020   grade_2 6 12 70 0   9     0   5   49 53 *                     102.0 6 12 70 0   9     0   5   49 53                 102
1370059 1370059 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2020   grade_2 84 1 6 0   0     0   11   59 43 *                     102.0 84 1 6 0   0     0   11   59 43                 102
1374057 1374057 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2020   grade_2 93 3 4 0   1     0   1   56 46 *                     102.0 93 3 4 0   1     0   1   56 46                 102
1366712 1366712 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2020   grade_2 98 2 2 0   1     0   0   44 59 *                     103.0 98 2 2 0   1     0   0   44 59                 103
1367072 1367072 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_2 25 17 46 0   13     0   2   51 52 *                     103.0 25 17 46 0   13     0   2   51 52                 103
1367247 1367247 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2020   grade_2 25 5 57 0   5     0   11   51 52 *                     103.0 25 5 57 0   5     0   11   51 52                 103
1369809 1369809 MA Worcester   school 2509270 226   Oxford 250927001481 2260005 Clara Barton   Regular School No Elementary 02 04 2020   grade_2 86 2 12 0   0     0   3   52 51 *                     103.0 86 2 12 0   0     0   3   52 51                 103
1370305 1370305 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2020   grade_2 23 4 70 0   3     0   3   49 54 *                     103.0 23 4 70 0   3     0   3   49 54                 103
1371776 1371776 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No Elementary KG 02 2020   grade_2 60 0 3 0   35     0   5   50 53 *                     103.0 60 0 3 0   35     0   5   50 53                 103
1367673 1367673 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2020   grade_2 44 5 51 0   1     0   3   55 49 *                     104.0 44 5 51 0   1     0   3   55 49                 104
1367755 1367755 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 05 2020   grade_2 51 24 14 0   7     0   8   56 48 *                     104.0 51 24 14 0   7     0   8   56 48                 104
1369831 1369831 MA Hampden   school 2509300 227   Palmer 250930002594 2270008 Old Mill Pond   Regular School No Elementary PK 05 2020   grade_2 82 5 12 0   1     0   4   43 61 *                     104.0 82 5 12 0   1     0   4   43 61                 104
1371575 1371575 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2020   grade_2 81 5 5 0   10     0   3   49 55 *                     104.0 81 5 5 0   10     0   3   49 55                 104
1366539 1366539 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2020   grade_2 69 3 6 0   24     0   3   54 51 *                     105.0 69 3 6 0   24     0   3   54 51                 105
1366581 1366581 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_2 4 5 96 0   0     0   0   47 58 *                     105.0 4 5 96 0   0     0   0   47 58                 105
1368524 1368524 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Robert L Ford   Regular School No Elementary 01 05 2020   grade_2 3 9 80 0   9     0   4   51 54 *                     105.0 3 9 80 0   9     0   4   51 54                 105
1369716 1369716 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2020   grade_2 94 1 4 0   0     0   6   49 56 *                     105.0 94 1 4 0   0     0   6   49 56                 105
1372445 1372445 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_2 21 13 63 2   1     0   5   57 48 *                     105.0 21 13 63 2   1     0   5   57 48                 105
1367130 1367130 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   grade_2 28 9 49 1   2     1   16   58 48 *                     106.0 28 9 49 1   2     1   16   58 48                 106
1367464 1367464 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_2 100 0 2 0   2     0   2   54 52 *                     106.0 100 0 2 0   2     0   2   54 52                 106
1367989 1367989 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2020   grade_2 10 0 89 0   6     0   1   53 53 *                     106.0 10 0 89 0   6     0   1   53 53                 106
1370419 1370419 MA Essex   school 2510380 258   Salem 251038001668 2580070 Witchcraft Heights   Regular School No Elementary KG 05 2020   grade_2 45 6 45 0   4     0   6   54 52 *                     106.0 45 6 45 0   4     0   6   54 52                 106
1370981 1370981 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2020   grade_2 6 17 83 0   0     0   0   47 59 *                     106.0 6 17 83 0   0     0   0   47 59                 106
1367081 1367081 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_2 13 14 78 0   2     0   0   54 53 *                     107.0 13 14 78 0   2     0   0   54 53                 107
1367117 1367117 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2020   grade_2 58 13 25 0   4     0   7   56 51 *                     107.0 58 13 25 0   4     0   7   56 51                 107
1367253 1367253 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary PK 04 2020   grade_2 28 8 58 0   2     0   11   61 46 *                     107.0 28 8 58 0   2     0   11   61 46                 107
1367263 1367263 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   grade_2 32 9 58 0   5     0   3   55 52 *                     107.0 32 9 58 0   5     0   3   55 52                 107
1368512 1368512 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2020   grade_2 8 8 74 0   14     0   3   51 56 *                     107.0 8 8 74 0   14     0   3   51 56                 107
1373335 1373335 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2020   grade_2 102 1 1 0   1     0   2   48 59 *                     107.0 102 1 1 0   1     0   2   48 59                 107
1373712 1373712 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2020   grade_2 94 2 2 0   1     0   8   48 59 *                     107.0 94 2 2 0   1     0   8   48 59                 107
1367695 1367695 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary KG 03 2020   grade_2 36 5 60 0   3     0   4   48 60 *                     108.0 36 5 60 0   3     0   4   48 60                 108
1368941 1368941 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_2 48 6 48 0   3     0   3   67 41 *                     108.0 48 6 48 0   3     0   3   67 41                 108
1371824 1371824 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2020   grade_2 100 2 2 0   0     0   4   52 56 *                     108.0 100 2 2 0   0     0   4   52 56                 108
1372000 1372000 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2020   grade_2 92 0 9 0   2     0   5   54 54 *                     108.0 92 0 9 0   2     0   5   54 54                 108
1372306 1372306 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2020   grade_2 19 16 58 0   9     0   6   58 50 *                     108.0 19 16 58 0   9     0   6   58 50                 108
1364802 1364802 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2020   grade_2 96 4 5 0   1     0   3   56 53 *                     109.0 96 4 5 0   1     0   3   56 53                 109
1365230 1365230 MA Middlesex   school 2502670 31   Billerica 250267000186 310005 Thomas Ditson   Regular School No Elementary KG 04 2020   grade_2 83 4 6 0   10     0   6   66 43 *                     109.0 83 4 6 0   10     0   6   66 43                 109
1367164 1367164 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2020   grade_2 55 11 27 0   9     0   7   53 56 *                     109.0 55 11 27 0   9     0   7   53 56                 109
1367646 1367646 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No Elementary KG 04 2020   grade_2 63 3 40 0   1     0   2   50 59 *                     109.0 63 3 40 0   1     0   2   50 59                 109
1368128 1368128 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2020   grade_2 48 10 45 0   2     0   4   57 52 *                     109.0 48 10 45 0   2     0   4   57 52                 109
1368984 1368984 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2020   grade_2 94 3 3 3   1     0   5   62 47 *                     109.0 94 3 3 3   1     0   5   62 47                 109
1373387 1373387 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2020   grade_2 95 0 3 0   4     0   7   57 52 *                     109.0 95 0 3 0   4     0   7   57 52                 109
1373327 1373327 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_2 10 0 1 0   0     0   0   6 5 *                     11.0 10 0 1 0   0     0   0   6 5                 11
1366554 1366554 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   grade_2 77 1 6 1   20     0   5   55 55 *                     110.0 77 1 6 1   20     0   5   55 55                 110
1367520 1367520 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_2 87 4 4 0   10     0   5   55 55 *                     110.0 87 4 4 0   10     0   5   55 55                 110
1369266 1369266 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No Elementary PK 05 2020   grade_2 22 17 68 1   0     0   2   63 47 *                     110.0 22 17 68 1   0     0   2   63 47                 110
1370115 1370115 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2020   grade_2 35 14 7 0   48     1   5   44 66 *                     110.0 35 14 7 0   48     1   5   44 66                 110
1372914 1372914 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_2 86 6 7 0   1     0   10   55 55 *                     110.0 86 6 7 0   1     0   10   55 55                 110
1373268 1373268 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary PK 04 2020   grade_2 99 1 3 0   1     0   6   54 56 *                     110.0 99 1 3 0   1     0   6   54 56                 110
1366807 1366807 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2020   grade_2 99 2 4 0   0     0   6   57 54 *                     111.0 99 2 4 0   0     0   6   57 54                 111
1367651 1367651 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2020   grade_2 40 5 59 1   1     0   5   60 51 *                     111.0 40 5 59 1   1     0   5   60 51                 111
1368445 1368445 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2020   grade_2 90 2 14 0   4     0   1   53 58 *                     111.0 90 2 14 0   4     0   1   53 58                 111
1368794 1368794 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_2 83 2 4 6   1     0   15   68 43 *                     111.0 83 2 4 6   1     0   15   68 43                 111
1368951 1368951 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_2 60 6 36 0   5     0   4   61 50 *                     111.0 60 6 36 0   5     0   4   61 50                 111
1369072 1369072 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2020   grade_2 84 7 6 0   7     0   7   54 57 *                     111.0 84 7 6 0   7     0   7   54 57                 111
1369857 1369857 MA Essex   school 2509360 229   Peabody 250936001503 2290010 Thomas Carroll   Regular School No Elementary KG 05 2020   grade_2 81 5 24 0   1     0   0   53 58 *                     111.0 81 5 24 0   1     0   0   53 58                 111
1371783 1371783 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary PK 02 2020   grade_2 60 2 2 0   43     0   4   55 56 *                     111.0 60 2 2 0   43     0   4   55 56                 111
1365172 1365172 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_2 83 3 3 0   17     0   6   58 54 *                     112.0 83 3 3 0   17     0   6   58 54                 112
1365517 1365517 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2020   grade_2 0 59 45 1   2     0   5   57 55 *                     112.0 0 59 45 1   2     0   5   57 55                 112
1366197 1366197 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_2 18 70 15 0   6     0   3   60 52 *                     112.0 18 70 15 0   6     0   3   60 52                 112
1368537 1368537 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2020   grade_2 11 8 76 1   11     0   5   62 50 *                     112.0 11 8 76 1   11     0   5   62 50                 112
1368702 1368702 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 02 2020   grade_2 97 2 9 0   0     0   4   63 49 *                     112.0 97 2 9 0   0     0   4   63 49                 112
1368816 1368816 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2020   grade_2 85 1 17 0   1     0   8   56 56 *                     112.0 85 1 17 0   1     0   8   56 56                 112
1369059 1369059 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary KG 05 2020   grade_2 94 1 4 0   10     0   3   63 49 *                     112.0 94 1 4 0   10     0   3   63 49                 112
1370867 1370867 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Frederick Harris   Regular School No Elementary PK 05 2020   grade_2 21 23 57 1   5     0   5   53 59 *                     112.0 21 23 57 1   5     0   5   53 59                 112
1366145 1366145 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2020   grade_2 9 69 29 0   0     0   6   66 47 *                     113.0 9 69 29 0   0     0   6   66 47                 113
1366524 1366524 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2020   grade_2 107 3 1 0   0     0   2   55 58 *                     113.0 107 3 1 0   0     0   2   55 58                 113
1369131 1369131 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2020   grade_2 92 2 3 1   13     0   2   63 50 *                     113.0 92 2 3 1   13     0   2   63 50                 113
1371151 1371151 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_2 95 2 9 0   1     0   6   51 62 *                     113.0 95 2 9 0   1     0   6   51 62                 113
1368730 1368730 MA Middlesex   school 2507320 170   Marlborough 250732001130 1700008 Francis J Kane   Regular School No Elementary KG 04 2020   grade_2 51 7 52 0   4     0   0   59 55 *                     114.0 51 7 52 0   4     0   0   59 55                 114
1371356 1371356 MA Middlesex   school 2511760 301   Tyngsborough 251176001714 3010020 Tyngsborough Elementary   Regular School No Elementary PK 05 2020   grade_2 85 8 10 0   6     0   5   63 51 *                     114.0 85 8 10 0   6     0   5   63 51                 114
1374198 1374198 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_2 11 23 34 0   43     0   3   59 55 *                     114.0 11 23 34 0   43     0   3   59 55                 114
1365090 1365090 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   grade_2 89 2 14 0   0     0   10   59 56 *                     115.0 89 2 14 0   0     0   10   59 56                 115
1370292 1370292 MA Suffolk   school 2510050 248   Revere 251005001633 2480035 Staff Sargent James J. Hill Elementary School   Regular School No Elementary KG 05 2020   grade_2 26 5 78 0   5     0   1   62 53 *                     115.0 26 5 78 0   5     0   1   62 53                 115
1371276 1371276 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No Elementary KG 04 2020   grade_2 54 30 15 0   1     0   15   64 51 *                     115.0 54 30 15 0   1     0   15   64 51                 115
1373560 1373560 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   grade_2 88 6 9 1   2     0   10   68 48 *                     116.0 88 6 9 1   2     0   10   68 48                 116
1365707 1365707 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2020   grade_2 10 14 10 0   80     0   3   63 54 *                     117.0 10 14 10 0   80     0   3   63 54                 117
1369489 1369489 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2020   grade_2 114 0 1 0   2     0   0   64 53 *                     117.0 114 0 1 0   2     0   0   64 53                 117
1373339 1373339 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2020   grade_2 106 3 6 0   0     0   2   64 53 *                     117.0 106 3 6 0   0     0   2   64 53                 117
1368116 1368116 MA Worcester   school 2506780 153   Leominster 250678000981 1530007 Fall Brook   Regular School No Elementary KG 05 2020   grade_2 67 7 35 0   2     0   7   69 49 *                     118.0 67 7 35 0   2     0   7   69 49                 118
1368134 1368134 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2020   grade_2 50 3 54 0   4     0   7   54 64 *                     118.0 50 3 54 0   4     0   7   54 64                 118
1371313 1371313 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2020   grade_2 111 2 3 0   1     0   1   55 63 *                     118.0 111 2 3 0   1     0   1   55 63                 118
1371984 1371984 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2020   grade_2 99 1 7 0   6     0   5   55 63 *                     118.0 99 1 7 0   6     0   5   55 63                 118
1368087 1368087 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Elementary   Regular School No Elementary KG 04 2020   grade_2 91 7 15 0   3     0   3   61 58 *                     119.0 91 7 15 0   3     0   3   61 58                 119
1371310 1371310 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2020   grade_2 98 9 4 0   7     0   1   59 60 *                     119.0 98 9 4 0   7     0   1   59 60                 119
1372661 1372661 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 2020   grade_2 19 56 29 1   6     0   8   42 77 *                     119.0 19 56 29 1   6     0   8   42 77                 119

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