enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
1364983 1364983 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_2 118 7 27 0   43     0   9   103 101 *                     204.0 118 7 27 0   43     0   9   103 101                 204
1365041 1365041 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   grade_2 78 2 12 0   3     0   1   52 44 *                     96.0 78 2 12 0   3     0   1   52 44                 96
1365045 1365045 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_2 62 0 5 0   4     0   4   36 39 *                     75.0 62 0 5 0   4     0   4   36 39                 75
1365105 1365105 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_2 125 11 10 0   51     0   20   94 123 *                     217.0 125 11 10 0   51     0   20   94 123                 217
1365325 1365325 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2020   grade_2 1 14 24 0   0     0   1   22 18 *                     40.0 1 14 24 0   0     0   1   22 18                 40
1365344 1365344 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2020   grade_2 28 33 26 0   2     0   3   43 49 *                     92.0 28 33 26 0   2     0   3   43 49                 92
1366060 1366060 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   grade_2 125 3 8 0   1     0   6   68 75 *                     143.0 125 3 8 0   1     0   6   68 75                 143
1366075 1366075 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2020   grade_2 78 0 1 0   2     0   6   41 46 *                     87.0 78 0 1 0   2     0   6   41 46                 87
1366130 1366130 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   grade_2 54 0 1 0   0     0   2   36 21 *                     57.0 54 0 1 0   0     0   2   36 21                 57
1366619 1366619 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2020   grade_2 41 10 43 0   1     0   3   52 46 *                     98.0 41 10 43 0   1     0   3   52 46                 98
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
1366915 1366915 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   grade_2 183 1 6 0   0     0   9   100 99 *                     199.0 183 1 6 0   0     0   9   100 99                 199
1366926 1366926 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2020   grade_2 142 4 11 0   1     0   3   70 91 *                     161.0 142 4 11 0   1     0   3   70 91                 161
1366975 1366975 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   grade_2 151 1 24 0   8     0   9   97 96 *                     193.0 151 1 24 0   8     0   9   97 96                 193
1366989 1366989 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2020   grade_2 68 5 8 0   1     0   4   50 36 *                     86.0 68 5 8 0   1     0   4   50 36                 86
1366993 1366993 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2020   grade_2 75 3 8 1   1     0   6   41 53 *                     94.0 75 3 8 1   1     0   6   41 53                 94
1366997 1366997 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2020   grade_2 48 6 5 0   4     0   0   39 24 *                     63.0 48 6 5 0   4     0   0   39 24                 63
1367699 1367699 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2020   grade_2 23 2 15 0   1     0   1   18 24 *                     42.0 23 2 15 0   1     0   1   18 24                 42
1367781 1367781 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   grade_2 164 0 13 2   18     0   13   109 101 *                     210.0 164 0 13 2   18     0   13   109 101                 210
1367955 1367955 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2020   grade_2 146 0 4 1   2     0   1   82 72 *                     154.0 146 0 4 1   2     0   1   82 72                 154
1367995 1367995 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2020   grade_2 1 2 71 0   1     0   0   39 36 *                     75.0 1 2 71 0   1     0   0   39 36                 75
1368235 1368235 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2020   grade_2 112 0 4 0   20     0   1   61 76 *                     137.0 112 0 4 0   20     0   1   61 76                 137
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
1368689 1368689 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2020   grade_2 187 7 7 1   20     0   13   127 108 *                     235.0 187 7 7 1   20     0   13   127 108                 235
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
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
1369005 1369005 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2020   grade_2 73 2 4 0   6     0   1   39 47 *                     86.0 73 2 4 0   6     0   1   39 47                 86
1369013 1369013 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2020   grade_2 102 4 50 0   0     0   5   82 79 *                     161.0 102 4 50 0   0     0   5   82 79                 161
1369016 1369016 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2020   grade_2 93 6 54 1   0     0   7   86 75 *                     161.0 93 6 54 1   0     0   7   86 75                 161
1369118 1369118 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2020   grade_2 50 9 54 0   1     0   7   61 60 *                     121.0 50 9 54 0   1     0   7   61 60                 121
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
1369802 1369802 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2020   grade_2 51 1 9 0   0     0   4   38 27 *                     65.0 51 1 9 0   0     0   4   38 27                 65
1370442 1370442 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   grade_2 165 0 14 0   3     1   5   92 96 *                     188.0 165 0 14 0   3     1   5   92 96                 188
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
1371236 1371236 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No Elementary KG 02 2020   grade_2 91 1 0 0   1     0   2   53 42 *                     95.0 91 1 0 0   1     0   2   53 42                 95
1371240 1371240 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No Elementary PK 02 2020   grade_2 67 0 1 0   2     0   3   35 38 *                     73.0 67 0 1 0   2     0   3   35 38                 73
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
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
1371528 1371528 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2020   grade_2 131 16 20 2   1     0   21   103 88 *                     191.0 131 16 20 2   1     0   21   103 88                 191
1371773 1371773 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2020   grade_2 91 1 1 0   25     0   5   78 45 *                     123.0 91 1 1 0   25     0   5   78 45                 123
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
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
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
1372057 1372057 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2020   grade_2 107 1 20 0   2     0   2   62 70 *                     132.0 107 1 20 0   2     0   2   62 70                 132
1373152 1373152 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No Elementary KG 02 2020   grade_2 69 0 10 0   0     0   7   45 41 *                     86.0 69 0 10 0   0     0   7   45 41                 86
1373754 1373754 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Dr Frederick N Sweetsir   Regular School No Elementary PK 02 2020   grade_2 52 0 7 0   0     0   0   28 31 *                     59.0 52 0 7 0   0     0   0   28 31                 59
1373868 1373868 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2020   grade_2 76 2 6 1   2     0   1   52 36 *                     88.0 76 2 6 1   2     0   1   52 36                 88
1373960 1373960 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2020   grade_2 84 1 10 0   1     0   3   47 52 *                     99.0 84 1 10 0   1     0   3   47 52                 99
1365074 1365074 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_2 47 2 6 0   0     0   7   36 26 *                     62.0 47 2 6 0   0     0   7   36 26                 62
1365078 1365078 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_2 42 4 6 0   1     0   7   34 26 *                     60.0 42 4 6 0   1     0   7   34 26                 60
1365082 1365082 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_2 44 11 25 1   1     0   2   42 42 *                     84.0 44 11 25 1   1     0   2   42 42                 84
1365086 1365086 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   grade_2 29 11 28 0   3     0   13   35 49 *                     84.0 29 11 28 0   3     0   13   35 49                 84
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
1365122 1365122 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2020   grade_2 148 0 12 0   3     0   5   81 87 *                     168.0 148 0 12 0   3     0   5   81 87                 168
1365134 1365134 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2020   grade_2 62 2 13 0   3     2   2   43 41 *                     84.0 62 2 13 0   3     2   2   43 41                 84
1365138 1365138 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2020   grade_2 58 1 3 0   1     2   4   38 31 *                     69.0 58 1 3 0   1     2   4   38 31                 69
1365269 1365269 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2020   grade_2 2 14 18 0   1     0   1   19 17 *                     36.0 2 14 18 0   1     0   1   19 17                 36
1365289 1365289 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2020   grade_2 2 23 11 1   0     0   0   20 17 *                     37.0 2 23 11 1   0     0   0   20 17                 37
1365320 1365320 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2020   grade_2 1 20 12 0   0     0   0   13 20 *                     33.0 1 20 12 0   0     0   0   13 20                 33
1365329 1365329 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 03 2020   grade_2 3 55 21 0   0     0   5   52 32 *                     84.0 3 55 21 0   0     0   5   52 32                 84
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
1367854 1367854 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2020   grade_2 9 5 40 0   0     0   3   24 33 *                     57.0 9 5 40 0   0     0   3   24 33                 57
1367882 1367882 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Elmwood   Regular School No Elementary 02 03 2020   grade_2 149 2 12 0   76     0   15   127 127 *                     254.0 149 2 12 0   76     0   15   127 127                 254
1368215 1368215 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2020   grade_2 37 5 14 0   0     0   11   30 37 *                     67.0 37 5 14 0   0     0   11   30 37                 67
1368430 1368430 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Chapin Street Elementary School   Regular School No Elementary 02 03 2020   grade_2 129 1 25 0   1     0   7   81 82 *                     163.0 129 1 25 0   1     0   7   81 82                 163
1368710 1368710 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No Elementary PK 03 2020   grade_2 87 3 3 0   0     0   3   42 54 *                     96.0 87 3 3 0   0     0   3   42 54                 96
1368808 1368808 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2020   grade_2 50 0 3 0   2     0   5   29 31 *                     60.0 50 0 3 0   2     0   5   29 31                 60
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
1368832 1368832 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Ralph Wheelock School   Regular School No Elementary 02 03 2020   grade_2 165 4 5 0   4     0   9   81 106 *                     187.0 165 4 5 0   4     0   9   81 106                 187
1369032 1369032 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2020   grade_2 110 4 11 0   2     0   5   60 72 *                     132.0 110 4 11 0   2     0   5   60 72                 132
1369358 1369358 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2020   grade_2 114 2 7 0   3     0   2   55 73 *                     128.0 114 2 7 0   3     0   2   55 73                 128
1369711 1369711 MA Bristol   school 2509000 218   Norton 250900001450 2180010 L G Nourse Elementary   Regular School No Elementary KG 03 2020   grade_2 64 0 4 0   4     0   2   41 33 *                     74.0 64 0 4 0   4     0   2   41 33                 74
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
1370018 1370018 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Anna Ware Jackson   Regular School No Elementary PK 03 2020   grade_2 76 4 7 0   4     0   0   44 47 *                     91.0 76 4 7 0   4     0   0   44 47                 91
1370730 1370730 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2020   grade_2 90 0 7 0   33     0   8   67 71 *                     138.0 90 0 7 0   33     0   8   67 71                 138
1371343 1371343 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No Elementary PK 03 2020   grade_2 76 1 3 1   1     0   3   42 43 *                     85.0 76 1 3 1   1     0   3   42 43                 85
1371370 1371370 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No Elementary PK 03 2020   grade_2 114 2 7 2   0     0   1   64 62 *                     126.0 114 2 7 2   0     0   1   64 62                 126
1371460 1371460 MA Middlesex   school 2512000 308   Waltham 251200002863 3080001 Waltham Public Schools Dual Language Program   Regular School No Elementary KG 03 2020   grade_2 7 0 28 0   0     0   0   24 11 *                     35.0 7 0 28 0   0     0   0   24 11                 35
1371513 1371513 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2020   grade_2 67 1 2 0   0     0   2   35 37 *                     72.0 67 1 2 0   0     0   2   35 37                 72
1371672 1371672 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2020   grade_2 53 1 11 0   54     0   3   67 55 *                     122.0 53 1 11 0   54     0   3   67 55                 122
1371676 1371676 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No Elementary KG 03 2020   grade_2 42 2 2 0   25     0   4   30 45 *                     75.0 42 2 2 0   25     0   4   30 45                 75
1371681 1371681 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2020   grade_2 42 1 16 0   36     0   2   43 54 *                     97.0 42 1 16 0   36     0   2   43 54                 97
1371707 1371707 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2020   grade_2 78 2 4 0   1     0   5   49 41 *                     90.0 78 2 4 0   1     0   5   49 41                 90
1371805 1371805 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No Elementary PK 03 2020   grade_2 33 5 6 0   16     0   1   28 33 *                     61.0 33 5 6 0   16     0   1   28 33                 61
1371812 1371812 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2020   grade_2 35 5 9 0   12     0   3   35 29 *                     64.0 35 5 9 0   12     0   3   35 29                 64
1371981 1371981 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2020   grade_2 126 4 5 0   6     0   7   68 80 *                     148.0 126 4 5 0   6     0   7   68 80                 148
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
1372427 1372427 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_2 107 3 6 0   4     0   10   62 68 *                     130.0 107 3 6 0   4     0   10   62 68                 130
1373033 1373033 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Elementary School   Regular School No Elementary PK 03 2020   grade_2 71 3 1 0   0     0   3   43 35 *                     78.0 71 3 1 0   0     0   3   43 35                 78
1373173 1373173 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2020   grade_2 224 8 9 0   5     2   8   143 113 *                     256.0 224 8 9 0   5     2   8   143 113                 256
1373239 1373239 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   grade_2 32 7 12 0   0     1   6   30 28 *                     58.0 32 7 12 0   0     1   6   30 28                 58
1373244 1373244 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2020   grade_2 31 8 8 1   2     0   2   25 27 *                     52.0 31 8 8 1   2     0   2   25 27                 52
1373248 1373248 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2020   grade_2 71 7 9 1   5     1   3   42 55 *                     97.0 71 7 9 1   5     1   3   42 55                 97
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
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
1373462 1373462 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Stony Hill School   Regular School No Elementary 02 03 2020   grade_2 133 4 10 0   3     0   3   70 83 *                     153.0 133 4 10 0   3     0   3   70 83                 153
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
1364812 1364812 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Clifford M Granger   Regular School No Elementary KG 04 2020   grade_2 28 1 6 0   3     0   0   20 18 *                     38.0 28 1 6 0   3     0   0   20 18                 38

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