enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,437 ✖
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
1368800 1368800 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_6 97 6 4 8   2     0   6   63 60 *                     123.0 97 6 4 8   2     0   6   63 60                 123
1368801 1368801 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_9 89 8 2 10   4     0   6   56 63 *                     119.0 89 8 2 10   4     0   6   56 63                 119
1368802 1368802 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_10 86 5 5 6   3     1   10   64 52 *                     116.0 86 5 5 6   3     1   10   64 52                 116
1368803 1368803 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_11 89 5 6 7   4     0   2   51 62 *                     113.0 89 5 6 7   4     0   2   51 62                 113
1368804 1368804 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_12 81 7 6 3   3     0   6   57 49 *                     106.0 81 7 6 3   3     0   6   57 49                 106
1369803 1369803 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2020   kindergarten 18 1 1 0   0     0   2   11 11 *                     22.0 18 1 1 0   0     0   2   11 11                 22
1369804 1369804 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2020   grade_1 26 2 3 1   0     0   0   15 17 *                     32.0 26 2 3 1   0     0   0   15 17                 32
1369805 1369805 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2020   grade_2 25 1 6 0   0     0   2   14 20 *                     34.0 25 1 6 0   0     0   2   14 20                 34
1369806 1369806 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2020   grade_3 33 3 2 0   0     0   0   15 23 *                     38.0 33 3 2 0   0     0   0   15 23                 38
1369807 1369807 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2020   grade_4 28 2 6 0   2     0   1   16 23 *                     39.0 28 2 6 0   2     0   1   16 23                 39
1369808 1369808 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2020   grade_5 30 1 0 0   0     0   1   22 10 *                     32.0 30 1 0 0   0     0   1   22 10                 32
1370090 1370090 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   kindergarten 5 2 1 0   0     0   1   4 5 *                     9.0 5 2 1 0   0     0   1   4 5                 9
1370091 1370091 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   pre_kindergarten 11 5 4 0   0     0   0   11 9 *                     20.0 11 5 4 0   0     0   0   11 9                 20
1370092 1370092 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_1 3 7 0 0   0     0   1   3 8 *                     11.0 3 7 0 0   0     0   1   3 8                 11
1370093 1370093 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_2 7 1 1 0   0     0   0   4 5 *                     9.0 7 1 1 0   0     0   0   4 5                 9
1370094 1370094 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_3 6 2 3 0   0     0   0   2 9 *                     11.0 6 2 3 0   0     0   0   2 9                 11
1370095 1370095 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_4 9 1 3 0   0     0   3   10 6 *                     16.0 9 1 3 0   0     0   3   10 6                 16
1370096 1370096 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_5 5 5 2 0   0     0   1   3 10 *                     13.0 5 5 2 0   0     0   1   3 10                 13
1370097 1370097 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_6 10 2 2 0   0     0   3   9 8 *                     17.0 10 2 2 0   0     0   3   9 8                 17
1370098 1370098 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_7 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1370099 1370099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_8 6 4 3 0   0     0   2   7 8 *                     15.0 6 4 3 0   0     0   2   7 8                 15
1370439 1370439 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   kindergarten 141 2 5 1   5     0   1   74 81 *                     155.0 141 2 5 1   5     0   1   74 81                 155
1370440 1370440 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   pre_kindergarten 55 1 3 1   2     0   0   30 32 *                     62.0 55 1 3 1   2     0   0   30 32                 62
1370441 1370441 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   grade_1 171 4 7 0   7     0   1   90 100 *                     190.0 171 4 7 0   7     0   1   90 100                 190
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
1370443 1370443 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_3 160 1 11 1   5     0   4   88 94 *                     182.0 160 1 11 1   5     0   4   88 94                 182
1370444 1370444 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_4 182 2 7 0   6     2   0   105 94 *                     199.0 182 2 7 0   6     2   0   105 94                 199
1370445 1370445 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_5 172 2 2 0   3     0   2   94 87 *                     181.0 172 2 2 0   3     0   2   94 87                 181
1370446 1370446 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2020   grade_6 187 4 3 2   5     0   2   101 102 *                     203.0 187 4 3 2   5     0   2   101 102                 203
1370447 1370447 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2020   grade_7 205 4 3 1   3     0   3   109 110 *                     219.0 205 4 3 1   3     0   3   109 110                 219
1370448 1370448 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2020   grade_8 221 1 3 0   2     0   2   110 118 *                     229.0 221 1 3 0   2     0   2   110 118                 229
1370449 1370449 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2020   grade_9 156 0 2 2   5     0   0   78 87 *                     165.0 156 0 2 2   5     0   0   78 87                 165
1370450 1370450 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2020   grade_10 155 0 3 2   2     0   0   80 82 *                     162.0 155 0 3 2   2     0   0   80 82                 162
1370451 1370451 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2020   grade_11 148 0 2 3   4     1   0   73 85 *                     158.0 148 0 2 3   4     1   0   73 85                 158
1370452 1370452 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2020   grade_12 161 4 4 0   3     0   1   89 84 *                     173.0 161 4 4 0   3     0   1   89 84                 173
1371345 1371345 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   kindergarten 8 1 0 0   0     0   3   6 6 *                     12.0 8 1 0 0   0     0   3   6 6                 12
1371346 1371346 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   pre_kindergarten 17 0 1 0   0     0   3   12 9 *                     21.0 17 0 1 0   0     0   3   12 9                 21
1371347 1371347 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_1 10 1 1 0   0     0   3   8 7 *                     15.0 10 1 1 0   0     0   3   8 7                 15
1371348 1371348 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_2 10 0 1 0   0     0   3   4 10 *                     14.0 10 0 1 0   0     0   3   4 10                 14
1371349 1371349 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_3 10 3 1 0   0     0   1   7 8 *                     15.0 10 3 1 0   0     0   1   7 8                 15
1371350 1371350 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_4 12 1 2 0   0     0   4   11 8 *                     19.0 12 1 2 0   0     0   4   11 8                 19
1371351 1371351 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_5 9 0 1 0   0     0   2   9 3 *                     12.0 9 0 1 0   0     0   2   9 3                 12
1371352 1371352 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1371664 1371664 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   kindergarten 16 0 0 0   0     0   3   13 6 *                     19.0 16 0 0 0   0     0   3   13 6                 19
1371665 1371665 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   grade_1 14 0 0 0   0     0   4   9 9 *                     18.0 14 0 0 0   0     0   4   9 9                 18
1371666 1371666 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   grade_2 14 0 0 0   0     0   1   9 6 *                     15.0 14 0 0 0   0     0   1   9 6                 15
1371667 1371667 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   grade_3 14 0 2 0   1     0   2   9 10 *                     19.0 14 0 2 0   1     0   2   9 10                 19
1371668 1371668 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   grade_4 12 1 0 0   0     0   3   7 9 *                     16.0 12 1 0 0   0     0   3   7 9                 16
1371669 1371669 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   grade_5 17 1 1 0   0     0   0   9 10 *                     19.0 17 1 1 0   0     0   0   9 10                 19
1372577 1372577 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_6 71 1 4 0   2     0   3   42 39 *                     81.0 71 1 4 0   2     0   3   42 39                 81
1372578 1372578 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_7 71 1 3 1   3     0   2   36 45 *                     81.0 71 1 3 1   3     0   2   36 45                 81
1372579 1372579 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_8 62 3 5 0   1     0   6   38 39 *                     77.0 62 3 5 0   1     0   6   38 39                 77
1372908 1372908 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_9 185 5 11 1   10     0   5   96 120 *                     217.0 185 5 11 1   10     0   5   96 120                 217
1372909 1372909 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_10 190 5 19 2   3     0   3   98 123 *                     222.0 190 5 19 2   3     0   3   98 123                 222
1372910 1372910 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_11 173 5 4 0   11     0   9   91 111 *                     202.0 173 5 4 0   11     0   9   91 111                 202
1372911 1372911 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_12 166 4 12 0   7     0   2   89 101 *                     191.0 166 4 12 0   7     0   2   89 101                 191
1373236 1373236 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   kindergarten 52 7 8 0   2     0   4   32 41 *                     73.0 52 7 8 0   2     0   4   32 41                 73
1373237 1373237 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   pre_kindergarten 21 5 3 1   2     0   0   18 14 *                     32.0 21 5 3 1   2     0   0   18 14                 32
1373238 1373238 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   grade_1 48 8 9 1   0     0   6   35 37 *                     72.0 48 8 9 1   0     0   6   35 37                 72
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
1373240 1373240 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   grade_3 45 7 11 3   0     0   7   40 33 *                     73.0 45 7 11 3   0     0   7   40 33                 73
1373241 1373241 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2020   kindergarten 31 3 14 1   1     0   3   29 24 *                     53.0 31 3 14 1   1     0   3   29 24                 53
1373242 1373242 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2020   pre_kindergarten 43 10 8 1   1     0   1   36 28 *                     64.0 43 10 8 1   1     0   1   36 28                 64
1373243 1373243 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2020   grade_1 44 6 10 2   3     0   2   33 34 *                     67.0 44 6 10 2   3     0   2   33 34                 67
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
1373245 1373245 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2020   grade_3 35 6 8 2   0     1   6   38 20 *                     58.0 35 6 8 2   0     1   6   38 20                 58
1373246 1373246 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2020   kindergarten 76 11 7 0   5     0   3   56 46 *                     102.0 76 11 7 0   5     0   3   56 46                 102
1373247 1373247 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2020   grade_1 85 7 10 1   4     0   8   58 57 *                     115.0 85 7 10 1   4     0   8   58 57                 115
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
1373249 1373249 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2020   grade_3 66 10 6 4   4     1   5   54 42 *                     96.0 66 10 6 4   4     1   5   54 42                 96
1373250 1373250 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2020   grade_4 166 23 28 4   9     0   25   140 115 *                     255.0 166 23 28 4   9     0   25   140 115                 255
1373251 1373251 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2020   grade_5 164 17 21 8   2     0   28   123 117 *                     240.0 164 17 21 8   2     0   28   123 117                 240
1373252 1373252 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_6 133 29 44 7   4     1   12   119 111 *                     230.0 133 29 44 7   4     1   12   119 111                 230
1373253 1373253 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2020   grade_7 158 22 36 6   6     0   10   113 125 *                     238.0 158 22 36 6   6     0   10   113 125                 238
1373254 1373254 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_8 140 17 35 5   4     0   16   108 109 *                     217.0 140 17 35 5   4     0   16   108 109                 217
1373255 1373255 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_9 127 22 23 3   5     0   7   102 85 *                     187.0 127 22 23 3   5     0   7   102 85                 187
1373256 1373256 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_10 110 18 23 3   3     0   6   73 90 *                     163.0 110 18 23 3   3     0   6   73 90                 163
1373257 1373257 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_11 119 16 23 5   5     0   8   98 78 *                     176.0 119 16 23 5   5     0   8   98 78                 176
1373258 1373258 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_12 122 24 29 1   7     0   11   80 114 *                     194.0 122 24 29 1   7     0   11   80 114                 194
1373317 1373317 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_6 154 7 14 0   5     0   5   95 89 *                     185.0 154 7 14 0   5     0   5   95 89                 185
1373318 1373318 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_7 175 9 13 1   3     0   2   98 105 *                     203.0 175 9 13 1   3     0   2   98 105                 203
1373319 1373319 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2020   grade_8 160 6 15 0   4     0   7   90 102 *                     192.0 160 6 15 0   4     0   7   90 102                 192
1373320 1373320 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2020   grade_9 172 14 6 0   5     0   7   89 115 *                     204.0 172 14 6 0   5     0   7   89 115                 204
1373321 1373321 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2020   grade_10 194 9 7 0   3     1   7   112 108 *                     221.0 194 9 7 0   3     1   7   112 108                 221
1373322 1373322 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2020   grade_11 192 18 14 0   8     0   8   100 140 *                     240.0 192 18 14 0   8     0   8   100 140                 240
1373323 1373323 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2020   grade_12 192 15 5 1   9     0   11   103 129 *                     233.0 192 15 5 1   9     0   11   103 129                 233
1373551 1373551 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   kindergarten 25 3 5 0   0     0   1   19 15 *                     34.0 25 3 5 0   0     0   1   19 15                 34
1373552 1373552 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 13 1 1 0   1     0   0   9 7 *                     16.0 13 1 1 0   1     0   0   9 7                 16
1373553 1373553 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   grade_1 24 2 4 0   2     0   2   15 19 *                     34.0 24 2 4 0   2     0   2   15 19                 34
1373554 1373554 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   grade_2 25 1 3 0   0     0   2   9 22 *                     31.0 25 1 3 0   0     0   2   9 22                 31
1373555 1373555 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   grade_3 29 5 8 0   0     1   3   28 18 *                     46.0 29 5 8 0   0     1   3   28 18                 46
1373556 1373556 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   grade_4 37 1 4 0   1     0   0   20 23 *                     43.0 37 1 4 0   1     0   0   20 23                 43
1373557 1373557 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   kindergarten 66 4 9 0   1     0   8   54 34 *                     88.0 66 4 9 0   1     0   8   54 34                 88
1373558 1373558 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten 37 4 4 0   3     0   5   27 26 *                     53.0 37 4 4 0   3     0   5   27 26                 53
1373559 1373559 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   grade_1 68 2 12 1   1     0   5   48 41 *                     89.0 68 2 12 1   1     0   5   48 41                 89
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
1373561 1373561 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   grade_3 82 6 4 0   0     0   8   44 56 *                     100.0 82 6 4 0   0     0   8   44 56                 100
1373562 1373562 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   grade_4 78 9 6 1   4     0   8   63 43 *                     106.0 78 9 6 1   4     0   8   63 43                 106
1373563 1373563 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_5 137 6 10 1   0     0   8   69 93 *                     162.0 137 6 10 1   0     0   8   69 93                 162
1373564 1373564 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_6 102 8 9 2   2     0   13   65 71 *                     136.0 102 8 9 2   2     0   13   65 71                 136

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