enrollments

Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,536 ✖
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
1672295 1672295 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable - Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 75 7 18 0   6     0   18   85 39 *                     124.0 75 7 18 0   6     0   18   85 39                 124
1672296 1672296 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   kindergarten 32 2 12 0   1     0   5   31 21 *                     52.0 32 2 12 0   1     0   5   31 21                 52
1672297 1672297 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_1 45 2 11 0   0     0   5   34 29 *                     63.0 45 2 11 0   0     0   5   34 29                 63
1672298 1672298 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_2 35 1 4 0   2     0   8   22 28 *                     50.0 35 1 4 0   2     0   8   22 28                 50
1672299 1672299 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_3 42 2 6 0   0     0   6   32 24 *                     56.0 42 2 6 0   0     0   6   32 24                 56
1672300 1672300 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   kindergarten 32 4 8 0   0     0   11   31 24 *                     55.0 32 4 8 0   0     0   11   31 24                 55
1672301 1672301 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_1 34 4 11 0   0     0   8   31 26 *                     57.0 34 4 11 0   0     0   8   31 26                 57
1672302 1672302 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_2 43 5 12 0   0     0   4   38 26 *                     64.0 43 5 12 0   0     0   4   38 26                 64
1672303 1672303 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_3 43 6 5 0   1     0   6   34 27 *                     61.0 43 6 5 0   1     0   6   34 27                 61
1672304 1672304 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   kindergarten 22 9 27 0   1     0   6   38 27 *                     65.0 22 9 27 0   1     0   6   38 27                 65
1672305 1672305 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_1 25 9 24 3   4     0   3   38 30 *                     68.0 25 9 24 3   4     0   3   38 30                 68
1672306 1672306 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_2 36 7 24 0   5     0   6   38 39 *                     78.0 36 7 24 0   5     0   6   38 39                 78
1672307 1672307 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_3 37 15 24 1   1     0   3   39 42 *                     81.0 37 15 24 1   1     0   3   39 42                 81
1672308 1672308 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   kindergarten 24 8 26 0   0     0   9   39 28 *                     67.0 24 8 26 0   0     0   9   39 28                 67
1672309 1672309 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   grade_1 21 13 17 0   0     0   10   26 35 *                     61.0 21 13 17 0   0     0   10   26 35                 61
1672310 1672310 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   grade_2 16 10 38 1   1     0   5   35 36 *                     71.0 16 10 38 1   1     0   5   35 36                 71
1672311 1672311 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   grade_3 26 10 26 0   2     0   13   34 43 *                     77.0 26 10 26 0   2     0   13   34 43                 77
1672312 1672312 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   kindergarten 58 4 13 0   0     0   13   46 42 *                     88.0 58 4 13 0   0     0   13   46 42                 88
1672313 1672313 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_1 67 1 13 0   0     0   12   45 48 *                     93.0 67 1 13 0   0     0   12   45 48                 93
1672314 1672314 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_2 77 1 8 0   3     0   7   51 45 *                     96.0 77 1 8 0   3     0   7   51 45                 96
1672315 1672315 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_3 82 1 12 0   0     0   8   51 52 *                     103.0 82 1 12 0   0     0   8   51 52                 103
1672316 1672316 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable - Barnstable United Elementary School   Regular School No Elementary 04 05 2021   grade_4 212 24 71 0   11     0   22   175 164 *                     340.0 212 24 71 0   11     0   22   175 164                 340
1672317 1672317 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable - Barnstable United Elementary School   Regular School No Elementary 04 05 2021   grade_5 226 30 80 1   9     0   18   192 171 *                     364.0 226 30 80 1   9     0   18   192 171                 364
1672318 1672318 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_6 221 33 70 2   7     0   25   190 168 *                     358.0 221 33 70 2   7     0   25   190 168                 358
1672319 1672319 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_7 225 24 73 4   8     1   16   189 162 *                     351.0 225 24 73 4   8     1   16   189 162                 351
1672320 1672320 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_8 265 31 62 0   11     2   18   192 197 *                     389.0 265 31 62 0   11     2   18   192 197                 389
1672321 1672321 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_9 221 34 74 1   9     0   16   194 160 *                     355.0 221 34 74 1   9     0   16   194 160                 355
1672322 1672322 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_10 210 30 65 2   5     1   22   136 199 *                     335.0 210 30 65 2   5     1   22   136 199                 335
1672323 1672323 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_11 229 32 54 1   5     1   12   166 167 *                     334.0 229 32 54 1   5     1   12   166 167                 334
1672324 1672324 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_12 241 30 56 2   4     2   10   180 165 *                     345.0 241 30 56 2   4     2   10   180 165                 345
1672325 1672325 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   sped_beyond_grade_12 8 0 1 1   1     0   0   6 5 *                     11.0 8 0 1 1   1     0   0   6 5                 11
1673293 1673293 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   kindergarten 66 0 5 1   3     0   6   44 37 *                     81.0 66 0 5 1   3     0   6   44 37                 81
1673294 1673294 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   pre_kindergarten 32 2 2 0   1     0   2   20 19 *                     39.0 32 2 2 0   1     0   2   20 19                 39
1673295 1673295 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_1 88 2 12 1   3     0   9   62 53 *                     115.0 88 2 12 1   3     0   9   62 53                 115
1673296 1673296 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_2 91 1 4 1   3     0   3   45 58 *                     103.0 91 1 4 1   3     0   3   45 58                 103
1673297 1673297 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne - Bourne Intermediate School   Regular School No Elementary 03 05 2021   grade_3 122 3 7 0   2     0   7   71 70 *                     141.0 122 3 7 0   2     0   7   71 70                 141
1673298 1673298 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne - Bourne Intermediate School   Regular School No Elementary 03 05 2021   grade_4 115 3 4 1   2     0   3   59 69 *                     128.0 115 3 4 1   2     0   3   59 69                 128
1673299 1673299 MA Barnstable   school 2502820 36   Bourne 250282002909 360030 Bourne - Bourne Intermediate School   Regular School No Elementary 03 05 2021   grade_5 126 5 15 1   2     0   6   69 86 *                     155.0 126 5 15 1   2     0   6   69 86                 155
1673300 1673300 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_6 124 2 6 0   1     0   5   68 70 *                     138.0 124 2 6 0   1     0   5   68 70                 138
1673301 1673301 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_7 140 3 9 5   3     0   5   73 92 *                     165.0 140 3 9 5   3     0   5   73 92                 165
1673302 1673302 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_8 132 3 10 3   2     0   7   88 69 *                     157.0 132 3 10 3   2     0   7   88 69                 157
1673303 1673303 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_9 84 1 4 3   2     0   4   49 49 *                     98.0 84 1 4 3   2     0   4   49 49                 98
1673304 1673304 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_10 87 0 0 1   3     0   3   39 55 *                     94.0 87 0 0 1   3     0   3   39 55                 94
1673305 1673305 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_11 96 4 5 2   2     0   2   49 62 *                     111.0 96 4 5 2   2     0   2   49 62                 111
1673306 1673306 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   grade_12 101 1 6 0   2     0   4   50 64 *                     114.0 101 1 6 0   2     0   4   50 64                 114
1673307 1673307 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne - Bourne High School   Regular School No High 09 12 2021   sped_beyond_grade_12 11 0 0 0   0     0   0   7 4 *                     11.0 11 0 0 0   0     0   0   7 4                 11
1673360 1673360 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   kindergarten 48 4 7 0   1     0   7   37 30 *                     67.0 48 4 7 0   1     0   7   37 30                 67
1673361 1673361 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   pre_kindergarten 13 1 3 0   0     0   1   9 9 *                     18.0 13 1 3 0   0     0   1   9 9                 18
1673362 1673362 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   grade_1 49 0 8 0   0     0   7   35 29 *                     64.0 49 0 8 0   0     0   7   35 29                 64
1673363 1673363 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   grade_2 51 1 8 0   0     0   2   23 39 *                     62.0 51 1 8 0   0     0   2   23 39                 62
1673364 1673364 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster - Eddy Elementary   Regular School No Elementary 03 05 2021   grade_3 49 0 2 0   0     0   2   33 20 *                     53.0 49 0 2 0   0     0   2   33 20                 53
1673365 1673365 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster - Eddy Elementary   Regular School No Elementary 03 05 2021   grade_4 68 4 4 0   0     0   4   38 42 *                     80.0 68 4 4 0   0     0   4   38 42                 80
1673366 1673366 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster - Eddy Elementary   Regular School No Elementary 03 05 2021   grade_5 64 3 5 0   0     0   4   40 36 *                     76.0 64 3 5 0   0     0   4   40 36                 76
1674167 1674167 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   kindergarten 14 3 1 0   0     0   3   11 10 *                     21.0 14 3 1 0   0     0   3   11 10                 21
1674168 1674168 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 12 2 3 0   0     0   5   11 11 *                     22.0 12 2 3 0   0     0   5   11 11                 22
1674169 1674169 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_1 24 2 1 0   0     0   3   17 13 *                     30.0 24 2 1 0   0     0   3   17 13                 30
1674170 1674170 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_2 21 1 2 0   2     0   2   16 12 *                     28.0 21 1 2 0   2     0   2   16 12                 28
1674171 1674171 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_3 23 4 2 0   0     0   0   16 13 *                     29.0 23 4 2 0   0     0   0   16 13                 29
1674172 1674172 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_4 28 3 0 0   1     0   2   20 14 *                     34.0 28 3 0 0   1     0   2   20 14                 34
1674173 1674173 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_5 25 3 1 0   1     0   0   14 16 *                     30.0 25 3 1 0   1     0   0   14 16                 30
1674447 1674447 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   kindergarten 26 4 1 0   0     0   2   19 14 *                     33.0 26 4 1 0   0     0   2   19 14                 33
1674448 1674448 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 52 3 9 1   0     0   0   44 21 *                     65.0 52 3 9 1   0     0   0   44 21                 65
1674449 1674449 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_1 22 1 4 1   1     0   0   18 11 *                     29.0 22 1 4 1   1     0   0   18 11                 29
1674450 1674450 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_2 32 1 8 0   3     0   1   21 24 *                     45.0 32 1 8 0   3     0   1   21 24                 45
1674451 1674451 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_3 31 3 5 1   1     0   4   23 22 *                     45.0 31 3 5 1   1     0   4   23 22                 45
1674452 1674452 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_4 32 1 3 2   0     0   2   22 18 *                     40.0 32 1 3 2   0     0   2   22 18                 40
1674453 1674453 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   kindergarten 32 0 3 1   1     0   6   24 19 *                     43.0 32 0 3 1   1     0   6   24 19                 43
1674454 1674454 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   pre_kindergarten 12 2 0 0   0     0   3   9 8 *                     17.0 12 2 0 0   0     0   3   9 8                 17
1674455 1674455 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_1 32 4 7 0   1     0   3   27 20 *                     47.0 32 4 7 0   1     0   3   27 20                 47
1674456 1674456 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_2 27 7 1 1   0     0   2   17 21 *                     38.0 27 7 1 1   0     0   2   17 21                 38
1674457 1674457 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_3 33 4 6 0   1     0   5   30 19 *                     49.0 33 4 6 0   1     0   5   30 19                 49
1674458 1674458 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_4 33 8 4 1   0     0   5   25 26 *                     51.0 33 8 4 1   0     0   5   25 26                 51
1674459 1674459 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   kindergarten 54 1 9 1   0     0   7   41 31 *                     72.0 54 1 9 1   0     0   7   41 31                 72
1674460 1674460 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_1 61 1 11 0   4     0   11   54 34 *                     88.0 61 1 11 0   4     0   11   54 34                 88
1674461 1674461 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_2 63 4 10 0   2     0   4   34 49 *                     83.0 63 4 10 0   2     0   4   34 49                 83
1674462 1674462 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_3 62 4 7 0   1     0   9   56 27 *                     83.0 62 4 7 0   1     0   9   56 27                 83
1674463 1674463 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_4 55 2 8 2   0     0   12   45 34 *                     79.0 55 2 8 2   0     0   12   45 34                 79
1674464 1674464 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   kindergarten 35 2 6 0   1     0   1   23 22 *                     45.0 35 2 6 0   1     0   1   23 22                 45
1674465 1674465 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_1 52 1 3 0   0     0   3   30 29 *                     59.0 52 1 3 0   0     0   3   30 29                 59
1674466 1674466 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_2 49 3 6 0   0     0   4   26 36 *                     62.0 49 3 6 0   0     0   4   26 36                 62
1674467 1674467 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_3 67 2 6 0   1     0   6   40 42 *                     82.0 67 2 6 0   1     0   6   40 42                 82
1674468 1674468 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_4 51 1 2 0   2     0   2   34 24 *                     58.0 51 1 2 0   2     0   2   34 24                 58
1674469 1674469 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth - Morse Pond School   Regular School No Middle 05 06 2021   grade_5 195 8 19 1   3     1   20   119 128 *                     247.0 195 8 19 1   3     1   20   119 128                 247
1674470 1674470 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth - Morse Pond School   Regular School No Middle 05 06 2021   grade_6 207 14 12 1   4     0   10   120 128 *                     248.0 207 14 12 1   4     0   10   120 128                 248
1674471 1674471 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_7 197 9 15 9   3     0   20   131 122 *                     253.0 197 9 15 9   3     0   20   131 122                 253
1674472 1674472 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_8 197 15 15 1   12     0   17   134 123 *                     257.0 197 15 15 1   12     0   17   134 123                 257
1674473 1674473 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_9 158 15 13 0   2     0   11   102 97 *                     199.0 158 15 13 0   2     0   11   102 97                 199
1674474 1674474 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_10 193 13 18 2   3     0   11   121 116 *                     240.0 193 13 18 2   3     0   11   121 116                 240
1674475 1674475 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_11 148 9 9 1   6     0   12   92 92 *                     185.0 148 9 9 1   6     0   12   92 92                 185
1674476 1674476 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_12 155 8 7 1   3     0   9   88 94 *                     183.0 155 8 7 1   3     0   9   88 94                 183
1674477 1674477 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1676041 1676041 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   kindergarten 65 5 6 4   3     1   9   48 45 *                     93.0 65 5 6 4   3     1   9   48 45                 93
1676042 1676042 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   pre_kindergarten 44 2 3 2   0     0   3   21 33 *                     54.0 44 2 3 2   0     0   3   21 33                 54
1676043 1676043 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   grade_1 62 6 8 2   1     0   13   52 40 *                     92.0 62 6 8 2   1     0   13   52 40                 92
1676044 1676044 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   grade_2 56 4 12 4   1     0   14   49 42 *                     91.0 56 4 12 4   1     0   14   49 42                 91
1676045 1676045 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_7 89 5 5 8   2     0   6   58 57 *                     115.0 89 5 5 8   2     0   6   58 57                 115
1676046 1676046 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_8 101 6 5 8   5     0   16   69 72 *                     141.0 101 6 5 8   5     0   16   69 72                 141
1676047 1676047 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_3 78 2 4 5   1     0   15   67 38 *                     105.0 78 2 4 5   1     0   15   67 38                 105
1676048 1676048 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_4 62 7 7 9   1     0   11   44 53 *                     97.0 62 7 7 9   1     0   11   44 53                 97
1676049 1676049 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_5 82 7 10 8   1     0   11   57 62 *                     119.0 82 7 10 8   1     0   11   57 62                 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]);