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,537 ✖
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
1365071 1365071 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 94 9 29 0   3     0   26   99 62 *                     161.0 94 9 29 0   3     0   26   99 62                 161
1365072 1365072 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   kindergarten 41 2 11 0   0     0   4   34 24 *                     58.0 41 2 11 0   0     0   4   34 24                 58
1365073 1365073 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_1 45 1 4 0   3     0   9   31 31 *                     62.0 45 1 4 0   3     0   9   31 31                 62
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
1365075 1365075 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_3 49 2 6 0   2     0   4   36 27 *                     63.0 49 2 6 0   2     0   4   36 27                 63
1365076 1365076 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   kindergarten 32 4 11 0   0     0   8   25 30 *                     55.0 32 4 11 0   0     0   8   25 30                 55
1365077 1365077 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_1 47 5 15 0   0     0   4   42 29 *                     71.0 47 5 15 0   0     0   4   42 29                 71
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
1365079 1365079 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_3 36 4 12 0   2     0   3   30 27 *                     57.0 36 4 12 0   2     0   3   30 27                 57
1365080 1365080 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   kindergarten 23 10 22 3   4     0   4   40 26 *                     66.0 23 10 22 3   4     0   4   40 26                 66
1365081 1365081 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_1 36 6 25 0   5     0   5   40 37 *                     77.0 36 6 25 0   5     0   5   40 37                 77
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
1365083 1365083 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_3 39 6 17 0   2     0   1   33 32 *                     65.0 39 6 17 0   2     0   1   33 32                 65
1365084 1365084 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   kindergarten 24 13 25 0   1     0   9   30 42 *                     72.0 24 13 25 0   1     0   9   30 42                 72
1365085 1365085 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   grade_1 19 9 35 1   1     1   6   35 37 *                     72.0 19 9 35 1   1     1   6   35 37                 72
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
1365087 1365087 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   grade_3 26 15 31 0   1     0   8   34 47 *                     81.0 26 15 31 0   1     0   8   34 47                 81
1365088 1365088 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   kindergarten 70 1 9 0   0     0   12   48 44 *                     92.0 70 1 9 0   0     0   12   48 44                 92
1365089 1365089 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   grade_1 84 1 9 0   5     0   6   54 50 *                     105.0 84 1 9 0   5     0   6   54 50                 105
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
1365091 1365091 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   grade_3 99 0 6 0   2     0   5   57 55 *                     112.0 99 0 6 0   2     0   5   57 55                 112
1365092 1365092 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2020   grade_4 265 29 74 1   5     0   20   208 186 *                     394.0 265 29 74 1   5     0   20   208 186                 394
1365093 1365093 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2020   grade_5 269 35 72 2   6     0   26   220 190 *                     410.0 269 35 72 2   6     0   26   220 190                 410
1365094 1365094 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_6 242 24 78 4   8     1   18   202 173 *                     375.0 242 24 78 4   8     1   18   202 173                 375
1365095 1365095 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2020   grade_7 274 28 53 0   9     2   15   190 191 *                     381.0 274 28 53 0   9     2   15   190 191                 381
1365096 1365096 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_8 273 31 71 1   8     0   22   217 188 *                     406.0 273 31 71 1   8     0   22   217 188                 406
1365097 1365097 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_9 218 30 53 2   5     1   23   134 198 *                     332.0 218 30 53 2   5     1   23   134 198                 332
1365098 1365098 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_10 227 32 61 1   5     1   11   178 160 *                     338.0 227 32 61 1   5     1   11   178 160                 338
1365099 1365099 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_11 254 32 64 1   4     2   10   186 181 *                     367.0 254 32 64 1   4     2   10   186 181                 367
1365100 1365100 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_12 246 29 52 1   10     0   13   159 192 *                     351.0 246 29 52 1   10     0   13   159 192                 351
1365101 1365101 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   sped_beyond_grade_12 10 0 1 1   1     0   0   7 6 *                     13.0 10 0 1 1   1     0   0   7 6                 13
1366057 1366057 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   kindergarten 106 2 12 1   3     0   8   71 61 *                     132.0 106 2 12 1   3     0   8   71 61                 132
1366058 1366058 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten 59 1 0 0   1     0   1   35 27 *                     62.0 59 1 0 0   1     0   1   35 27                 62
1366059 1366059 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   grade_1 106 2 7 1   3     0   5   57 67 *                     124.0 106 2 7 1   3     0   5   57 67                 124
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
1366061 1366061 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne Intermediate School   Regular School No Elementary 03 05 2020   grade_3 122 3 7 1   2     0   3   61 77 *                     138.0 122 3 7 1   2     0   3   61 77                 138
1366062 1366062 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne Intermediate School   Regular School No Elementary 03 05 2020   grade_4 138 5 17 1   1     2   7   80 91 *                     171.0 138 5 17 1   1     2   7   80 91                 171
1366063 1366063 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne Intermediate School   Regular School No Elementary 03 05 2020   grade_5 147 2 10 0   1     0   5   85 80 *                     165.0 147 2 10 0   1     0   5   85 80                 165
1366064 1366064 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_6 149 5 8 4   4     0   4   80 94 *                     174.0 149 5 8 4   4     0   4   80 94                 174
1366065 1366065 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_7 140 3 12 3   2     0   6   94 72 *                     166.0 140 3 12 3   2     0   6   94 72                 166
1366066 1366066 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_8 150 2 9 3   2     0   5   86 85 *                     171.0 150 2 9 3   2     0   5   86 85                 171
1366067 1366067 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_9 96 0 1 1   2     0   3   43 60 *                     103.0 96 0 1 1   2     0   3   43 60                 103
1366068 1366068 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_10 101 2 7 2   2     0   1   49 66 *                     115.0 101 2 7 2   2     0   1   49 66                 115
1366069 1366069 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_11 97 1 7 0   2     0   5   50 62 *                     112.0 97 1 7 0   2     0   5   50 62                 112
1366070 1366070 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   grade_12 103 2 7 0   7     1   4   52 72 *                     124.0 103 2 7 0   7     1   4   52 72                 124
1366071 1366071 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2020   sped_beyond_grade_12 7 0 0 0   0     0   0   5 2 *                     7.0 7 0 0 0   0     0   0   5 2                 7
1366127 1366127 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   kindergarten 45 1 8 0   0     0   8   32 30 *                     62.0 45 1 8 0   0     0   8   32 30                 62
1366128 1366128 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 27 0 6 0   0     0   1   21 13 *                     34.0 27 0 6 0   0     0   1   21 13                 34
1366129 1366129 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   grade_1 58 1 8 0   0     0   4   30 41 *                     71.0 58 1 8 0   0     0   4   30 41                 71
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
1366131 1366131 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2020   grade_3 72 4 5 0   0     0   4   43 42 *                     85.0 72 4 5 0   0     0   4   43 42                 85
1366132 1366132 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2020   grade_4 65 2 5 0   0     0   5   43 34 *                     77.0 65 2 5 0   0     0   5   43 34                 77
1366133 1366133 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2020   grade_5 69 1 8 0   2     0   4   43 41 *                     84.0 69 1 8 0   2     0   4   43 41                 84
1366937 1366937 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   kindergarten 26 2 1 0   0     0   3   16 16 *                     32.0 26 2 1 0   0     0   3   16 16                 32
1366938 1366938 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 21 4 1 0   0     0   3   13 16 *                     29.0 21 4 1 0   0     0   3   13 16                 29
1366939 1366939 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   grade_1 20 1 1 0   2     0   1   17 8 *                     25.0 20 1 1 0   2     0   1   17 8                 25
1366940 1366940 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   grade_2 22 4 1 0   0     0   0   17 10 *                     27.0 22 4 1 0   0     0   0   17 10                 27
1366941 1366941 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   grade_3 25 2 0 0   1     0   1   16 13 *                     29.0 25 2 0 0   1     0   1   16 13                 29
1366942 1366942 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   grade_4 22 2 1 0   1     0   0   10 16 *                     26.0 22 2 1 0   1     0   0   10 16                 26
1366943 1366943 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   grade_5 23 2 0 0   0     0   1   11 15 *                     26.0 23 2 0 0   0     0   1   11 15                 26
1367213 1367213 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   kindergarten 24 1 4 1   1     0   1   19 13 *                     32.0 24 1 4 1   1     0   1   19 13                 32
1367214 1367214 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 74 5 7 1   2     0   1   52 38 *                     90.0 74 5 7 1   2     0   1   52 38                 90
1367215 1367215 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   grade_1 33 2 10 0   3     0   2   26 24 *                     50.0 33 2 10 0   3     0   2   26 24                 50
1367216 1367216 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   grade_2 30 2 5 1   1     0   5   20 24 *                     44.0 30 2 5 1   1     0   5   20 24                 44
1367217 1367217 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   grade_3 34 1 3 3   0     0   3   24 20 *                     44.0 34 1 3 3   0     0   3   24 20                 44
1367218 1367218 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   grade_4 32 2 4 0   1     0   6   21 24 *                     45.0 32 2 4 0   1     0   6   21 24                 45
1367219 1367219 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   kindergarten 38 4 6 0   2     0   3   33 20 *                     53.0 38 4 6 0   2     0   3   33 20                 53
1367220 1367220 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   pre_kindergarten 14 1 7 0   0     0   3   17 8 *                     25.0 14 1 7 0   0     0   3   17 8                 25
1367221 1367221 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   grade_1 24 8 2 1   0     0   2   18 19 *                     37.0 24 8 2 1   0     0   2   18 19                 37
1367222 1367222 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   grade_2 33 4 7 0   1     0   5   31 19 *                     50.0 33 4 7 0   1     0   5   31 19                 50
1367223 1367223 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   grade_3 33 8 3 1   0     0   6   23 28 *                     51.0 33 8 3 1   0     0   6   23 28                 51
1367224 1367224 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   grade_4 44 4 3 0   0     0   2   23 30 *                     53.0 44 4 3 0   0     0   2   23 30                 53
1367225 1367225 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   kindergarten 62 1 9 0   4     0   11   55 32 *                     87.0 62 1 9 0   4     0   11   55 32                 87
1367226 1367226 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   grade_1 70 5 9 1   2     0   5   35 57 *                     92.0 70 5 9 1   2     0   5   35 57                 92
1367227 1367227 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   grade_2 69 3 8 0   1     0   8   59 30 *                     89.0 69 3 8 0   1     0   8   59 30                 89
1367228 1367228 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   grade_3 62 2 7 2   1     0   10   49 35 *                     84.0 62 2 7 2   1     0   10   49 35                 84
1367229 1367229 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   grade_4 75 2 8 0   3     0   6   54 40 *                     94.0 75 2 8 0   3     0   6   54 40                 94
1367230 1367230 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   kindergarten 47 1 3 0   1     0   2   26 28 *                     54.0 47 1 3 0   1     0   2   26 28                 54
1367231 1367231 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   grade_1 50 2 5 0   0     1   4   27 35 *                     62.0 50 2 5 0   0     1   4   27 35                 62
1367232 1367232 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   grade_2 65 3 7 0   1     0   3   39 40 *                     79.0 65 3 7 0   1     0   3   39 40                 79
1367233 1367233 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   grade_3 48 1 2 0   2     0   2   34 21 *                     55.0 48 1 2 0   2     0   2   34 21                 55
1367234 1367234 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   grade_4 58 2 4 0   0     0   4   26 42 *                     68.0 58 2 4 0   0     0   4   26 42                 68
1367235 1367235 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_5 225 13 13 1   4     0   13   131 138 *                     269.0 225 13 13 1   4     0   13   131 138                 269
1367236 1367236 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_6 217 9 15 11   4     0   24   148 132 *                     280.0 217 9 15 11   4     0   24   148 132                 280
1367237 1367237 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_7 205 15 14 1   13     0   18   142 124 *                     266.0 205 15 14 1   13     0   18   142 124                 266
1367238 1367238 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_8 204 19 16 1   2     0   14   130 126 *                     256.0 204 19 16 1   2     0   14   130 126                 256
1367239 1367239 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_9 207 13 14 4   2     0   12   130 121 *                     252.0 207 13 14 4   2     0   12   130 121                 252
1367240 1367240 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_10 165 9 13 2   6     0   16   106 104 *                     211.0 165 9 13 2   6     0   16   106 104                 211
1367241 1367241 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_11 157 8 7 1   4     0   10   91 95 *                     187.0 157 8 7 1   4     0   10   91 95                 187
1367242 1367242 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_12 160 10 6 1   4     0   8   87 101 *                     189.0 160 10 6 1   4     0   8   87 101                 189
1367243 1367243 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1368791 1368791 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   kindergarten 67 5 9 2   2     0   11   55 41 *                     96.0 67 5 9 2   2     0   11   55 41                 96
1368792 1368792 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   pre_kindergarten 71 1 7 1   2     1   8   54 37 *                     91.0 71 1 7 1   2     1   8   54 37                 91
1368793 1368793 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_1 60 3 13 3   1     0   15   48 47 *                     95.0 60 3 13 3   1     0   15   48 47                 95
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
1368795 1368795 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_7 107 6 5 8   5     0   16   71 76 *                     147.0 107 6 5 8   5     0   16   71 76                 147
1368796 1368796 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_8 85 4 4 6   3     0   7   59 50 *                     109.0 85 4 4 6   3     0   7   59 50                 109
1368797 1368797 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_3 64 7 6 9   1     0   13   45 55 *                     100.0 64 7 6 9   1     0   13   45 55                 100
1368798 1368798 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_4 84 6 10 8   2     0   10   60 60 *                     120.0 84 6 10 8   2     0   10   60 60                 120
1368799 1368799 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_5 86 2 8 8   2     0   11   56 61 *                     117.0 86 2 8 8   2     0   11   56 61                 117

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