enrollments

Data source: Big Local News · About: Big Local

4,267 rows where grade = "sped_beyond_grade_12" and state = "MA" sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • sped_beyond_grade_12 · 4,267 ✖
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
932851 932851 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   sped_beyond_grade_12 11 0 0 1   0     1   2   10 5                       15 11 0 0 1   0     1   2   10 5                 15
935011 935011 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   3 2                       5                         3 2                 5
941093 941093 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 3                       5                         2 3                 5
941338 941338 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2016   sped_beyond_grade_12 11 1 0 0   1     0   1   7 7                       14 11 1 0 0   1     0   1   7 7                 14
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 * * * *   *     *   *                             *                                              
1122303 1122303 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122308 1122308 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122313 1122313 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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 * * * *   *     *   *                             *                                              
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 * * * *   *     *   *                             *                                              
1122324 1122324 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
1123467 1123467 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123473 1123473 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123478 1123478 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123483 1123483 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123563 1123563 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123567 1123567 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Eddy Elementary   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124516 1124516 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124836 1124836 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124843 1124843 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124849 1124849 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124855 1124855 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124858 1124858 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124861 1124861 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124866 1124866 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126735 1126735 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126738 1126738 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126743 1126743 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126748 1126748 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127940 1127940 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128281 1128281 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128694 1128694 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128699 1128699 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128702 1128702 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128707 1128707 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129767 1129767 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130139 1130139 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131199 1131199 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131241 1131241 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131612 1131612 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131984 1131984 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131990 1131990 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131995 1131995 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131998 1131998 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132001 1132001 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No Middle 06 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132008 1132008 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132080 1132080 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132085 1132085 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132358 1132358 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132365 1132365 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132369 1132369 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1132375 1132375 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   sped_beyond_grade_12 7 1 0 0   0     0   1                             9 7 1 0 0   0     0   1                       9
1132996 1132996 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133096 1133096 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
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
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
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
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
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
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
1677704 1677704 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich - Sandwich High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
2040127 2040127 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   sped_beyond_grade_12 9 2 2 1   0     0   0                             14.0 9 2 2 1   0     0   0                       14
2041130 2041130 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 0 0   0     0   0                             6.0 6 0 0 0   0     0   0                       6
2042313 2042313 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2048386 2048386 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2048632 2048632 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2049166 2049166 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2229104 2229104 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229109 2229109 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229114 2229114 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229119 2229119 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable: Hyannis West Elementary   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229124 2229124 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229127 2229127 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable: Barnstable United Elementary School   Regular School No Elementary 04 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229130 2229130 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable: Barnstable Intermediate School   Regular School No Middle 06 07 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229136 2229136 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   sped_beyond_grade_12 10 1 1 0   0     0   1                             13.0 10 1 1 0   0     0   1                       13
2230285 2230285 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne: Bournedale Elementary School   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230291 2230291 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Bourne: Peebles Elementary School   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230296 2230296 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230301 2230301 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne: Bourne High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             4.0                                             4
2230381 2230381 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster: Stony Brook Elementary   Regular School No Elementary PK 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2230385 2230385 MA Barnstable   school 2502970 41   Brewster 250297000841 410010 Brewster: Eddy Elementary   Regular School No Elementary 03 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231333 2231333 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham: Eastham Elementary   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231663 2231663 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth: East Falmouth Elementary   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231670 2231670 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth: Teaticket   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231676 2231676 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth: Mullen-Hall   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231682 2231682 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth: North Falmouth Elementary   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231685 2231685 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth: Morse Pond School   Regular School No Middle 05 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231688 2231688 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth: Lawrence   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2231693 2231693 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth: Falmouth High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2233556 2233556 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233559 2233559 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233564 2233564 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2233569 2233569 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee: Mashpee High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2234762 2234762 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans: Orleans Elementary   Regular School No Elementary KG 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235102 2235102 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235516 2235516 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich: Forestdale School   Regular School No Elementary PK 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235521 2235521 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235524 2235524 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich: Sandwich STEM Academy   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2235529 2235529 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich: Sandwich High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0

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