enrollments
Data source: Big Local News · About: Big Local
11,264 rows where state = "MA" and year = 2017 sorted by county
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1122297 | 1122297 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002851 | 200001 | Enoch Cobb Early Learning Center | Regular School | No | Elementary | PK | PK | 2017 | pre_kindergarten | 92 | 7 | 14 | 0 | 3 | 0 | 10 | 69 | 57 | 126 | 92 | 7 | 14 | 0 | 3 | 0 | 10 | 69 | 57 | 126 | |||||||||||||||||||||||||||||||||
1122298 | 1122298 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002851 | 200001 | Enoch Cobb Early Learning Center | Regular School | No | Elementary | PK | PK | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1122299 | 1122299 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000125 | 200005 | West Barnstable Elementary | Regular School | No | Elementary | KG | 03 | 2017 | kindergarten | 48 | 5 | 5 | 0 | 2 | 0 | 1 | 33 | 28 | 61 | 48 | 5 | 5 | 0 | 2 | 0 | 1 | 33 | 28 | 61 | |||||||||||||||||||||||||||||||||
1122300 | 1122300 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000125 | 200005 | West Barnstable Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_1 | 57 | 2 | 3 | 0 | 1 | 0 | 2 | 40 | 25 | 65 | 57 | 2 | 3 | 0 | 1 | 0 | 2 | 40 | 25 | 65 | |||||||||||||||||||||||||||||||||
1122301 | 1122301 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000125 | 200005 | West Barnstable Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_2 | 55 | 5 | 2 | 0 | 0 | 0 | 5 | 37 | 30 | 67 | 55 | 5 | 2 | 0 | 0 | 0 | 5 | 37 | 30 | 67 | |||||||||||||||||||||||||||||||||
1122302 | 1122302 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000125 | 200005 | West Barnstable Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_3 | 57 | 0 | 7 | 0 | 2 | 0 | 1 | 37 | 30 | 67 | 57 | 0 | 7 | 0 | 2 | 0 | 1 | 37 | 30 | 67 | |||||||||||||||||||||||||||||||||
1122303 | 1122303 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000125 | 200005 | West Barnstable Elementary | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1122304 | 1122304 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000118 | 200010 | Centerville Elementary | Regular School | No | Elementary | KG | 03 | 2017 | kindergarten | 44 | 3 | 4 | 0 | 1 | 0 | 4 | 32 | 24 | 56 | 44 | 3 | 4 | 0 | 1 | 0 | 4 | 32 | 24 | 56 | |||||||||||||||||||||||||||||||||
1122305 | 1122305 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000118 | 200010 | Centerville Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_1 | 55 | 5 | 6 | 0 | 0 | 0 | 3 | 37 | 32 | 69 | 55 | 5 | 6 | 0 | 0 | 0 | 3 | 37 | 32 | 69 | |||||||||||||||||||||||||||||||||
1122306 | 1122306 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000118 | 200010 | Centerville Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_2 | 64 | 5 | 8 | 0 | 1 | 0 | 1 | 39 | 40 | 79 | 64 | 5 | 8 | 0 | 1 | 0 | 1 | 39 | 40 | 79 | |||||||||||||||||||||||||||||||||
1122307 | 1122307 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000118 | 200010 | Centerville Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_3 | 78 | 1 | 7 | 1 | 2 | 0 | 0 | 50 | 39 | 89 | 78 | 1 | 7 | 1 | 2 | 0 | 0 | 50 | 39 | 89 | |||||||||||||||||||||||||||||||||
1122308 | 1122308 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000118 | 200010 | Centerville Elementary | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1122309 | 1122309 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000121 | 200025 | Hyannis West Elementary | Regular School | No | Elementary | KG | 03 | 2017 | kindergarten | 38 | 17 | 20 | 0 | 2 | 0 | 9 | 40 | 46 | 86 | 38 | 17 | 20 | 0 | 2 | 0 | 9 | 40 | 46 | 86 | |||||||||||||||||||||||||||||||||
1122310 | 1122310 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000121 | 200025 | Hyannis West Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_1 | 32 | 18 | 32 | 1 | 2 | 0 | 4 | 50 | 39 | 89 | 32 | 18 | 32 | 1 | 2 | 0 | 4 | 50 | 39 | 89 | |||||||||||||||||||||||||||||||||
1122311 | 1122311 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000121 | 200025 | Hyannis West Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_2 | 37 | 16 | 23 | 0 | 3 | 0 | 11 | 50 | 40 | 90 | 37 | 16 | 23 | 0 | 3 | 0 | 11 | 50 | 40 | 90 | |||||||||||||||||||||||||||||||||
1122312 | 1122312 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000121 | 200025 | Hyannis West Elementary | Regular School | No | Elementary | KG | 03 | 2017 | grade_3 | 45 | 10 | 23 | 0 | 2 | 1 | 10 | 55 | 36 | 91 | 45 | 10 | 23 | 0 | 2 | 1 | 10 | 55 | 36 | 91 | |||||||||||||||||||||||||||||||||
1122313 | 1122313 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000121 | 200025 | Hyannis West Elementary | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1122314 | 1122314 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002679 | 200045 | West Villages Elementary School | Regular School | No | Elementary | KG | 03 | 2017 | kindergarten | 94 | 2 | 5 | 0 | 1 | 0 | 2 | 56 | 48 | 104 | 94 | 2 | 5 | 0 | 1 | 0 | 2 | 56 | 48 | 104 | |||||||||||||||||||||||||||||||||
1122315 | 1122315 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002679 | 200045 | West Villages Elementary School | Regular School | No | Elementary | KG | 03 | 2017 | grade_1 | 91 | 2 | 5 | 0 | 0 | 0 | 4 | 57 | 45 | 102 | 91 | 2 | 5 | 0 | 0 | 0 | 4 | 57 | 45 | 102 | |||||||||||||||||||||||||||||||||
1122316 | 1122316 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002679 | 200045 | West Villages Elementary School | Regular School | No | Elementary | KG | 03 | 2017 | grade_2 | 110 | 3 | 4 | 1 | 0 | 0 | 4 | 58 | 64 | 122 | 110 | 3 | 4 | 1 | 0 | 0 | 4 | 58 | 64 | 122 | |||||||||||||||||||||||||||||||||
1122317 | 1122317 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002679 | 200045 | West Villages Elementary School | Regular School | No | Elementary | KG | 03 | 2017 | grade_3 | 93 | 2 | 9 | 1 | 2 | 0 | 6 | 51 | 62 | 113 | 93 | 2 | 9 | 1 | 2 | 0 | 6 | 51 | 62 | 113 | |||||||||||||||||||||||||||||||||
1122318 | 1122318 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002679 | 200045 | West Villages Elementary School | Regular School | No | Elementary | KG | 03 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1122319 | 1122319 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2017 | grade_4 | 343 | 27 | 49 | 0 | 9 | 3 | 15 | 217 | 229 | 446 | 343 | 27 | 49 | 0 | 9 | 3 | 15 | 217 | 229 | 446 | |||||||||||||||||||||||||||||||||
1122320 | 1122320 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2017 | grade_5 | 301 | 30 | 51 | 0 | 9 | 0 | 15 | 226 | 180 | 406 | 301 | 30 | 51 | 0 | 9 | 0 | 15 | 226 | 180 | 406 | |||||||||||||||||||||||||||||||||
1122321 | 1122321 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002748 | 200050 | Barnstable United Elementary School | Regular School | No | Elementary | 04 | 05 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1122322 | 1122322 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable Intermediate School | Regular School | No | Middle | 06 | 07 | 2017 | grade_6 | 261 | 26 | 39 | 2 | 5 | 0 | 24 | 167 | 190 | 357 | 261 | 26 | 39 | 2 | 5 | 0 | 24 | 167 | 190 | 357 | |||||||||||||||||||||||||||||||||
1122323 | 1122323 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable Intermediate School | Regular School | No | Middle | 06 | 07 | 2017 | grade_7 | 302 | 34 | 36 | 2 | 8 | 0 | 15 | 200 | 197 | 397 | 302 | 34 | 36 | 2 | 8 | 0 | 15 | 200 | 197 | 397 | |||||||||||||||||||||||||||||||||
1122324 | 1122324 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable Intermediate School | Regular School | No | Middle | 06 | 07 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1122325 | 1122325 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2017 | grade_8 | 279 | 26 | 54 | 1 | 2 | 2 | 13 | 204 | 173 | 377 | 279 | 26 | 54 | 1 | 2 | 2 | 13 | 204 | 173 | 377 | |||||||||||||||||||||||||||||||||
1122326 | 1122326 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2017 | grade_9 | 269 | 38 | 44 | 2 | 13 | 1 | 13 | 169 | 211 | 380 | 269 | 38 | 44 | 2 | 13 | 1 | 13 | 169 | 211 | 380 | |||||||||||||||||||||||||||||||||
1122327 | 1122327 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2017 | grade_10 | 273 | 28 | 34 | 5 | 12 | 3 | 17 | 175 | 197 | 372 | 273 | 28 | 34 | 5 | 12 | 3 | 17 | 175 | 197 | 372 | |||||||||||||||||||||||||||||||||
1122328 | 1122328 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2017 | grade_11 | 273 | 35 | 47 | 5 | 16 | 2 | 15 | 197 | 196 | 393 | 273 | 35 | 47 | 5 | 16 | 2 | 15 | 197 | 196 | 393 | |||||||||||||||||||||||||||||||||
1122329 | 1122329 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2017 | grade_12 | 245 | 30 | 35 | 4 | 10 | 0 | 10 | 157 | 177 | 334 | 245 | 30 | 35 | 4 | 10 | 0 | 10 | 157 | 177 | 334 | |||||||||||||||||||||||||||||||||
1122330 | 1122330 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231000116 | 200505 | Barnstable High | Regular School | No | High | 08 | 12 | 2017 | sped_beyond_grade_12 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | |||||||||||||||||||||||||||||||||||||
1123461 | 1123461 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002664 | 360005 | Bournedale Elementary School | Regular School | No | Elementary | PK | 04 | 2017 | kindergarten | 64 | 1 | 1 | 0 | 0 | 0 | 1 | 34 | 33 | 67 | 64 | 1 | 1 | 0 | 0 | 0 | 1 | 34 | 33 | 67 | |||||||||||||||||||||||||||||||||
1123462 | 1123462 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002664 | 360005 | Bournedale Elementary School | Regular School | No | Elementary | PK | 04 | 2017 | pre_kindergarten | 58 | 3 | 0 | 0 | 1 | 0 | 4 | 35 | 31 | 66 | 58 | 3 | 0 | 0 | 1 | 0 | 4 | 35 | 31 | 66 | |||||||||||||||||||||||||||||||||
1123463 | 1123463 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002664 | 360005 | Bournedale Elementary School | Regular School | No | Elementary | PK | 04 | 2017 | grade_1 | 53 | 1 | 4 | 1 | 0 | 1 | 4 | 34 | 30 | 64 | 53 | 1 | 4 | 1 | 0 | 1 | 4 | 34 | 30 | 64 | |||||||||||||||||||||||||||||||||
1123464 | 1123464 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002664 | 360005 | Bournedale Elementary School | Regular School | No | Elementary | PK | 04 | 2017 | grade_2 | 79 | 1 | 7 | 1 | 0 | 0 | 3 | 54 | 37 | 91 | 79 | 1 | 7 | 1 | 0 | 0 | 3 | 54 | 37 | 91 | |||||||||||||||||||||||||||||||||
1123465 | 1123465 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002664 | 360005 | Bournedale Elementary School | Regular School | No | Elementary | PK | 04 | 2017 | grade_3 | 67 | 0 | 1 | 2 | 1 | 0 | 0 | 33 | 38 | 71 | 67 | 0 | 1 | 2 | 1 | 0 | 0 | 33 | 38 | 71 | |||||||||||||||||||||||||||||||||
1123466 | 1123466 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002664 | 360005 | Bournedale Elementary School | Regular School | No | Elementary | PK | 04 | 2017 | grade_4 | 67 | 1 | 3 | 0 | 1 | 0 | 2 | 41 | 33 | 74 | 67 | 1 | 3 | 0 | 1 | 0 | 2 | 41 | 33 | 74 | |||||||||||||||||||||||||||||||||
1123467 | 1123467 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282002664 | 360005 | Bournedale Elementary School | Regular School | No | Elementary | PK | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1123468 | 1123468 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000353 | 360010 | Peebles Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | kindergarten | 32 | 1 | 0 | 0 | 1 | 0 | 0 | 18 | 16 | 34 | 32 | 1 | 0 | 0 | 1 | 0 | 0 | 18 | 16 | 34 | |||||||||||||||||||||||||||||||||
1123469 | 1123469 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000353 | 360010 | Peebles Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | grade_1 | 67 | 3 | 7 | 1 | 1 | 1 | 2 | 42 | 40 | 82 | 67 | 3 | 7 | 1 | 1 | 1 | 2 | 42 | 40 | 82 | |||||||||||||||||||||||||||||||||
1123470 | 1123470 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000353 | 360010 | Peebles Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | grade_2 | 64 | 2 | 1 | 0 | 1 | 0 | 2 | 28 | 42 | 70 | 64 | 2 | 1 | 0 | 1 | 0 | 2 | 28 | 42 | 70 | |||||||||||||||||||||||||||||||||
1123471 | 1123471 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000353 | 360010 | Peebles Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | grade_3 | 69 | 1 | 2 | 4 | 2 | 0 | 6 | 38 | 46 | 84 | 69 | 1 | 2 | 4 | 2 | 0 | 6 | 38 | 46 | 84 | |||||||||||||||||||||||||||||||||
1123472 | 1123472 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000353 | 360010 | Peebles Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | grade_4 | 75 | 1 | 3 | 2 | 0 | 0 | 4 | 52 | 33 | 85 | 75 | 1 | 3 | 2 | 0 | 0 | 4 | 52 | 33 | 85 | |||||||||||||||||||||||||||||||||
1123473 | 1123473 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000353 | 360010 | Peebles Elementary School | Regular School | No | Elementary | KG | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1123474 | 1123474 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 147 | 2 | 10 | 1 | 1 | 0 | 2 | 83 | 80 | 163 | 147 | 2 | 10 | 1 | 1 | 0 | 2 | 83 | 80 | 163 | |||||||||||||||||||||||||||||||||
1123475 | 1123475 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 157 | 1 | 2 | 2 | 5 | 0 | 7 | 76 | 98 | 174 | 157 | 1 | 2 | 2 | 5 | 0 | 7 | 76 | 98 | 174 | |||||||||||||||||||||||||||||||||
1123476 | 1123476 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 170 | 3 | 2 | 2 | 6 | 0 | 0 | 86 | 97 | 183 | 170 | 3 | 2 | 2 | 6 | 0 | 0 | 86 | 97 | 183 | |||||||||||||||||||||||||||||||||
1123477 | 1123477 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_8 | 162 | 4 | 7 | 1 | 5 | 0 | 12 | 104 | 87 | 191 | 162 | 4 | 7 | 1 | 5 | 0 | 12 | 104 | 87 | 191 | |||||||||||||||||||||||||||||||||
1123478 | 1123478 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282001517 | 360325 | Bourne Middle School | Regular School | No | Middle | 05 | 08 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1123479 | 1123479 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000348 | 360505 | Bourne High School | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 108 | 1 | 5 | 0 | 5 | 1 | 5 | 60 | 65 | 125 | 108 | 1 | 5 | 0 | 5 | 1 | 5 | 60 | 65 | 125 | |||||||||||||||||||||||||||||||||
1123480 | 1123480 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000348 | 360505 | Bourne High School | Regular School | No | High | 09 | 12 | 2017 | grade_10 | 92 | 4 | 6 | 0 | 0 | 0 | 3 | 59 | 46 | 105 | 92 | 4 | 6 | 0 | 0 | 0 | 3 | 59 | 46 | 105 | |||||||||||||||||||||||||||||||||
1123481 | 1123481 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000348 | 360505 | Bourne High School | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 99 | 1 | 4 | 0 | 2 | 0 | 2 | 50 | 58 | 108 | 99 | 1 | 4 | 0 | 2 | 0 | 2 | 50 | 58 | 108 | |||||||||||||||||||||||||||||||||
1123482 | 1123482 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000348 | 360505 | Bourne High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 80 | 0 | 4 | 0 | 2 | 0 | 8 | 50 | 44 | 94 | 80 | 0 | 4 | 0 | 2 | 0 | 8 | 50 | 44 | 94 | |||||||||||||||||||||||||||||||||
1123483 | 1123483 | MA | Barnstable | school | 2502820 | 36 | Bourne | 250282000348 | 360505 | Bourne High School | Regular School | No | High | 09 | 12 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1123559 | 1123559 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000374 | 410005 | Stony Brook Elementary | Regular School | No | Elementary | PK | 02 | 2017 | kindergarten | 62 | 3 | 5 | 0 | 0 | 0 | 5 | 32 | 43 | 75 | 62 | 3 | 5 | 0 | 0 | 0 | 5 | 32 | 43 | 75 | |||||||||||||||||||||||||||||||||
1123560 | 1123560 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000374 | 410005 | Stony Brook Elementary | Regular School | No | Elementary | PK | 02 | 2017 | pre_kindergarten | 27 | 0 | 4 | 0 | 0 | 0 | 1 | 18 | 14 | 32 | 27 | 0 | 4 | 0 | 0 | 0 | 1 | 18 | 14 | 32 | |||||||||||||||||||||||||||||||||
1123561 | 1123561 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000374 | 410005 | Stony Brook Elementary | Regular School | No | Elementary | PK | 02 | 2017 | grade_1 | 61 | 2 | 5 | 0 | 0 | 0 | 5 | 39 | 34 | 73 | 61 | 2 | 5 | 0 | 0 | 0 | 5 | 39 | 34 | 73 | |||||||||||||||||||||||||||||||||
1123562 | 1123562 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000374 | 410005 | Stony Brook Elementary | Regular School | No | Elementary | PK | 02 | 2017 | grade_2 | 64 | 2 | 7 | 0 | 2 | 0 | 4 | 36 | 43 | 79 | 64 | 2 | 7 | 0 | 2 | 0 | 4 | 36 | 43 | 79 | |||||||||||||||||||||||||||||||||
1123563 | 1123563 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000374 | 410005 | Stony Brook Elementary | Regular School | No | Elementary | PK | 02 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1123564 | 1123564 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2017 | grade_3 | 73 | 1 | 4 | 0 | 1 | 0 | 4 | 43 | 40 | 83 | 73 | 1 | 4 | 0 | 1 | 0 | 4 | 43 | 40 | 83 | |||||||||||||||||||||||||||||||||
1123565 | 1123565 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2017 | grade_4 | 68 | 1 | 1 | 0 | 2 | 0 | 1 | 37 | 36 | 73 | 68 | 1 | 1 | 0 | 2 | 0 | 1 | 37 | 36 | 73 | |||||||||||||||||||||||||||||||||
1123566 | 1123566 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2017 | grade_5 | 65 | 4 | 6 | 0 | 0 | 0 | 2 | 38 | 39 | 77 | 65 | 4 | 6 | 0 | 0 | 0 | 2 | 38 | 39 | 77 | |||||||||||||||||||||||||||||||||
1123567 | 1123567 | MA | Barnstable | school | 2502970 | 41 | Brewster | 250297000841 | 410010 | Eddy Elementary | Regular School | No | Elementary | 03 | 05 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1124509 | 1124509 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | kindergarten | 26 | 1 | 0 | 0 | 0 | 0 | 0 | 13 | 14 | 27 | 26 | 1 | 0 | 0 | 0 | 0 | 0 | 13 | 14 | 27 | |||||||||||||||||||||||||||||||||
1124510 | 1124510 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | pre_kindergarten | 5 | 1 | 4 | 0 | 0 | 0 | 1 | 9 | 2 | 11 | 5 | 1 | 4 | 0 | 0 | 0 | 1 | 9 | 2 | 11 | |||||||||||||||||||||||||||||||||
1124511 | 1124511 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_1 | 24 | 1 | 3 | 0 | 0 | 0 | 1 | 13 | 16 | 29 | 24 | 1 | 3 | 0 | 0 | 0 | 1 | 13 | 16 | 29 | |||||||||||||||||||||||||||||||||
1124512 | 1124512 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_2 | 23 | 0 | 0 | 1 | 0 | 0 | 1 | 9 | 16 | 25 | 23 | 0 | 0 | 1 | 0 | 0 | 1 | 9 | 16 | 25 | |||||||||||||||||||||||||||||||||
1124513 | 1124513 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_3 | 20 | 1 | 0 | 0 | 2 | 0 | 1 | 13 | 11 | 24 | 20 | 1 | 0 | 0 | 2 | 0 | 1 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
1124514 | 1124514 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_4 | 34 | 3 | 0 | 1 | 0 | 0 | 0 | 17 | 21 | 38 | 34 | 3 | 0 | 1 | 0 | 0 | 0 | 17 | 21 | 38 | |||||||||||||||||||||||||||||||||
1124515 | 1124515 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | grade_5 | 24 | 3 | 0 | 0 | 1 | 0 | 0 | 14 | 14 | 28 | 24 | 3 | 0 | 0 | 1 | 0 | 0 | 14 | 14 | 28 | |||||||||||||||||||||||||||||||||
1124516 | 1124516 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1124830 | 1124830 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000685 | 960005 | East Falmouth Elementary | Regular School | No | Elementary | PK | 04 | 2017 | kindergarten | 39 | 3 | 4 | 3 | 0 | 0 | 3 | 30 | 22 | 52 | 39 | 3 | 4 | 3 | 0 | 0 | 3 | 30 | 22 | 52 | |||||||||||||||||||||||||||||||||
1124831 | 1124831 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000685 | 960005 | East Falmouth Elementary | Regular School | No | Elementary | PK | 04 | 2017 | pre_kindergarten | 62 | 0 | 7 | 0 | 0 | 0 | 6 | 41 | 34 | 75 | 62 | 0 | 7 | 0 | 0 | 0 | 6 | 41 | 34 | 75 | |||||||||||||||||||||||||||||||||
1124832 | 1124832 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000685 | 960005 | East Falmouth Elementary | Regular School | No | Elementary | PK | 04 | 2017 | grade_1 | 34 | 2 | 5 | 0 | 1 | 0 | 5 | 29 | 18 | 47 | 34 | 2 | 5 | 0 | 1 | 0 | 5 | 29 | 18 | 47 | |||||||||||||||||||||||||||||||||
1124833 | 1124833 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000685 | 960005 | East Falmouth Elementary | Regular School | No | Elementary | PK | 04 | 2017 | grade_2 | 48 | 5 | 3 | 1 | 1 | 0 | 1 | 24 | 35 | 59 | 48 | 5 | 3 | 1 | 1 | 0 | 1 | 24 | 35 | 59 | |||||||||||||||||||||||||||||||||
1124834 | 1124834 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000685 | 960005 | East Falmouth Elementary | Regular School | No | Elementary | PK | 04 | 2017 | grade_3 | 54 | 1 | 1 | 3 | 0 | 0 | 5 | 37 | 27 | 64 | 54 | 1 | 1 | 3 | 0 | 0 | 5 | 37 | 27 | 64 | |||||||||||||||||||||||||||||||||
1124835 | 1124835 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000685 | 960005 | East Falmouth Elementary | Regular School | No | Elementary | PK | 04 | 2017 | grade_4 | 40 | 7 | 1 | 1 | 1 | 0 | 4 | 29 | 25 | 54 | 40 | 7 | 1 | 1 | 1 | 0 | 4 | 29 | 25 | 54 | |||||||||||||||||||||||||||||||||
1124836 | 1124836 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000685 | 960005 | East Falmouth Elementary | Regular School | No | Elementary | PK | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1124837 | 1124837 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000691 | 960015 | Teaticket | Regular School | No | Elementary | PK | 04 | 2017 | kindergarten | 35 | 8 | 3 | 1 | 0 | 0 | 6 | 27 | 26 | 53 | 35 | 8 | 3 | 1 | 0 | 0 | 6 | 27 | 26 | 53 | |||||||||||||||||||||||||||||||||
1124838 | 1124838 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000691 | 960015 | Teaticket | Regular School | No | Elementary | PK | 04 | 2017 | pre_kindergarten | 12 | 3 | 2 | 0 | 0 | 0 | 2 | 11 | 8 | 19 | 12 | 3 | 2 | 0 | 0 | 0 | 2 | 11 | 8 | 19 | |||||||||||||||||||||||||||||||||
1124839 | 1124839 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000691 | 960015 | Teaticket | Regular School | No | Elementary | PK | 04 | 2017 | grade_1 | 47 | 6 | 5 | 0 | 0 | 0 | 1 | 22 | 37 | 59 | 47 | 6 | 5 | 0 | 0 | 0 | 1 | 22 | 37 | 59 | |||||||||||||||||||||||||||||||||
1124840 | 1124840 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000691 | 960015 | Teaticket | Regular School | No | Elementary | PK | 04 | 2017 | grade_2 | 50 | 3 | 2 | 0 | 1 | 0 | 2 | 34 | 24 | 58 | 50 | 3 | 2 | 0 | 1 | 0 | 2 | 34 | 24 | 58 | |||||||||||||||||||||||||||||||||
1124841 | 1124841 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000691 | 960015 | Teaticket | Regular School | No | Elementary | PK | 04 | 2017 | grade_3 | 33 | 4 | 1 | 7 | 1 | 0 | 5 | 33 | 18 | 51 | 33 | 4 | 1 | 7 | 1 | 0 | 5 | 33 | 18 | 51 | |||||||||||||||||||||||||||||||||
1124842 | 1124842 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000691 | 960015 | Teaticket | Regular School | No | Elementary | PK | 04 | 2017 | grade_4 | 48 | 1 | 3 | 0 | 4 | 0 | 4 | 30 | 30 | 60 | 48 | 1 | 3 | 0 | 4 | 0 | 4 | 30 | 30 | 60 | |||||||||||||||||||||||||||||||||
1124843 | 1124843 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000691 | 960015 | Teaticket | Regular School | No | Elementary | PK | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1124844 | 1124844 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000689 | 960020 | Mullen-Hall | Regular School | No | Elementary | KG | 04 | 2017 | kindergarten | 57 | 2 | 4 | 2 | 4 | 0 | 10 | 46 | 33 | 79 | 57 | 2 | 4 | 2 | 4 | 0 | 10 | 46 | 33 | 79 | |||||||||||||||||||||||||||||||||
1124845 | 1124845 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000689 | 960020 | Mullen-Hall | Regular School | No | Elementary | KG | 04 | 2017 | grade_1 | 72 | 0 | 3 | 0 | 2 | 0 | 7 | 44 | 40 | 84 | 72 | 0 | 3 | 0 | 2 | 0 | 7 | 44 | 40 | 84 | |||||||||||||||||||||||||||||||||
1124846 | 1124846 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000689 | 960020 | Mullen-Hall | Regular School | No | Elementary | KG | 04 | 2017 | grade_2 | 81 | 6 | 5 | 1 | 2 | 0 | 3 | 52 | 46 | 98 | 81 | 6 | 5 | 1 | 2 | 0 | 3 | 52 | 46 | 98 | |||||||||||||||||||||||||||||||||
1124847 | 1124847 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000689 | 960020 | Mullen-Hall | Regular School | No | Elementary | KG | 04 | 2017 | grade_3 | 73 | 2 | 6 | 4 | 5 | 0 | 6 | 52 | 44 | 96 | 73 | 2 | 6 | 4 | 5 | 0 | 6 | 52 | 44 | 96 | |||||||||||||||||||||||||||||||||
1124848 | 1124848 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000689 | 960020 | Mullen-Hall | Regular School | No | Elementary | KG | 04 | 2017 | grade_4 | 82 | 4 | 10 | 0 | 3 | 0 | 8 | 56 | 51 | 107 | 82 | 4 | 10 | 0 | 3 | 0 | 8 | 56 | 51 | 107 | |||||||||||||||||||||||||||||||||
1124849 | 1124849 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000689 | 960020 | Mullen-Hall | Regular School | No | Elementary | KG | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * | |||||||||||||||||||||||||||||||||||||||||||||
1124850 | 1124850 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000690 | 960030 | North Falmouth Elementary | Regular School | No | Elementary | KG | 04 | 2017 | kindergarten | 38 | 3 | 4 | 0 | 1 | 0 | 2 | 27 | 21 | 48 | 38 | 3 | 4 | 0 | 1 | 0 | 2 | 27 | 21 | 48 | |||||||||||||||||||||||||||||||||
1124851 | 1124851 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000690 | 960030 | North Falmouth Elementary | Regular School | No | Elementary | KG | 04 | 2017 | grade_1 | 53 | 2 | 3 | 0 | 1 | 0 | 4 | 25 | 38 | 63 | 53 | 2 | 3 | 0 | 1 | 0 | 4 | 25 | 38 | 63 | |||||||||||||||||||||||||||||||||
1124852 | 1124852 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000690 | 960030 | North Falmouth Elementary | Regular School | No | Elementary | KG | 04 | 2017 | grade_2 | 65 | 0 | 3 | 0 | 2 | 0 | 4 | 35 | 39 | 74 | 65 | 0 | 3 | 0 | 2 | 0 | 4 | 35 | 39 | 74 | |||||||||||||||||||||||||||||||||
1124853 | 1124853 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000690 | 960030 | North Falmouth Elementary | Regular School | No | Elementary | KG | 04 | 2017 | grade_3 | 56 | 1 | 6 | 0 | 0 | 0 | 2 | 32 | 33 | 65 | 56 | 1 | 6 | 0 | 0 | 0 | 2 | 32 | 33 | 65 | |||||||||||||||||||||||||||||||||
1124854 | 1124854 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000690 | 960030 | North Falmouth Elementary | Regular School | No | Elementary | KG | 04 | 2017 | grade_4 | 57 | 1 | 1 | 0 | 2 | 0 | 1 | 34 | 28 | 62 | 57 | 1 | 1 | 0 | 2 | 0 | 1 | 34 | 28 | 62 | |||||||||||||||||||||||||||||||||
1124855 | 1124855 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000690 | 960030 | North Falmouth Elementary | Regular School | No | Elementary | KG | 04 | 2017 | sped_beyond_grade_12 | * | * | * | * | * | * | * | * |
Advanced export
JSON shape: default, array, newline-delimited
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]);