enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2230216 2230216 MA Suffolk   school   35   Boston   350652               2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1132094 1132094 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238925 2238925 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131083 1131083 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237908 2237908 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131087 1131087 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Elementary 04 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237912 2237912 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131077 1131077 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237902 2237902 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130732 1130732 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237560 2237560 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester: Head Start   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130801 1130801 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237628 2237628 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130879 1130879 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237705 2237705 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130792 1130792 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237619 2237619 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131016 1131016 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237841 2237841 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131069 1131069 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237894 2237894 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester: Worcester Technical High   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131040 1131040 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237865 2237865 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester: Worcester East Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131007 1131007 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237832 2237832 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130749 1130749 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237577 2237577 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130998 1130998 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237823 2237823 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester: Union Hill School   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130990 1130990 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237815 2237815 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Worcester: Thorndyke Road   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130982 1130982 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237807 2237807 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130973 1130973 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237798 2237798 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester: Worcester Arts Magnet School   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131064 1131064 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2017   sped_beyond_grade_12 10 4 9 0   2     0   0                             25 10 4 9 0   2     0   0                       25
1372412 1372412 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2020   sped_beyond_grade_12 7 1 9 0   2     0   0   14 5 *                     19.0 7 1 9 0   2     0   0   14 5                 19
1679675 1679675 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester - South High Community   Regular School No High 09 12 2021   sped_beyond_grade_12 7 1 5 0   2     0   0   13 2 *                     15.0 7 1 5 0   2     0   0   13 2                 15
2047485 2047485 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2019   sped_beyond_grade_12 8 2 6 0   2     0   0                             18.0 8 2 6 0   2     0   0                       18
2237889 2237889 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester: South High Community   Regular School No High 09 12 2018   sped_beyond_grade_12 8 4 8 0   2     0   0                             22.0 8 4 8 0   2     0   0                       22
1130964 1130964 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237789 2237789 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester: Roosevelt   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130955 1130955 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237780 2237780 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Worcester: Rice Square   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130947 1130947 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237772 2237772 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Worcester: Quinsigamond   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131059 1131059 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 2 8 0   1     0   1                             19 7 2 8 0   1     0   1                       19
1372407 1372407 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2020   sped_beyond_grade_12 7 6 5 0   1     0   1   11 9 *                     20.0 7 6 5 0   1     0   1   11 9                 20
1679670 1679670 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester - North High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 5 8 0   2     0   0   10 11 *                     21.0 6 5 8 0   2     0   0   10 11                 21
2047480 2047480 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2019   sped_beyond_grade_12 5 4 5 0   1     0   1                             16.0 5 4 5 0   1     0   1                       16
2237884 2237884 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester: North High   Regular School No High 09 12 2018   sped_beyond_grade_12 5 3 4 0   0     0   1                             13.0 5 3 4 0   0     0   1                       13
1130938 1130938 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237763 2237763 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Worcester: Norrback Avenue   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130929 1130929 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237754 2237754 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Worcester: Nelson Place   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130921 1130921 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237745 2237745 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester: Midland Street   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130904 1130904 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237729 2237729 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 Worcester: May Street   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130896 1130896 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237721 2237721 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester: Lincoln Street   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130887 1130887 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237713 2237713 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Worcester: Lake View   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130870 1130870 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237696 2237696 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Worcester: Heard Street   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131044 1131044 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237869 2237869 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Worcester: Sullivan Middle   Regular School No Middle 06 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130862 1130862 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237688 2237688 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Worcester: Grafton Street   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130853 1130853 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237680 2237680 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Worcester: Gates Lane   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130844 1130844 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237671 2237671 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Worcester: Goddard School/Science Technical   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130913 1130913 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237737 2237737 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester: Francis J McGrath Elementary   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131036 1131036 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237861 2237861 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester: Forest Grove Middle   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130826 1130826 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237654 2237654 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Worcester: Flagg Street   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130835 1130835 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237662 2237662 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Worcester: Elm Park Community   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131054 1131054 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2017   sped_beyond_grade_12 5 0 7 0   0     0   1                             13 5 0 7 0   0     0   1                       13
1372402 1372402 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 1 6 0   1     0   1   11 3 *                     14.0 5 1 6 0   1     0   1   11 3                 14
1679665 1679665 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Worcester - Doherty Memorial High   Regular School No High 09 12 2021   sped_beyond_grade_12 5 1 3 0   1     0   1   9 2 *                     11.0 5 1 3 0   1     0   1   9 2                 11
2047475 2047475 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 0 7 0   0     0   0                             13.0 6 0 7 0   0     0   0                       13
2237879 2237879 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Worcester: Doherty Memorial High   Regular School No High 09 12 2018   sped_beyond_grade_12 4 1 4 0   0     0   0                             9.0 4 1 4 0   0     0   0                       9
1130818 1130818 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237646 2237646 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Worcester: Columbus Park   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130809 1130809 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237637 2237637 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Worcester: Clark St Community   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130783 1130783 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237610 2237610 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Worcester: Chandler Elementary Community   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130775 1130775 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237602 2237602 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Worcester: Canterbury   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131033 1131033 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237858 2237858 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130766 1130766 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237593 2237593 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Worcester: Burncoat Street   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131049 1131049 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2017   sped_beyond_grade_12 2 2 8 0   1     0   1                             14 2 2 8 0   1     0   1                       14
1372397 1372397 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2020   sped_beyond_grade_12 3 2 3 0   2     0   1   8 3 *                     11.0 3 2 3 0   2     0   1   8 3                 11

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