Data source: Big Local News · About: Big Local

3,371,677 rows sorted by district

View and edit SQL

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
1930490 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_10                         58.0 35.0                       93.0                         58 35                 93
1930491 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_11                         40.0 62.0                       102.0                         40 62                 102
1930492 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_12                         28.0 34.0                       62.0                         28 34                 62
1930493 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_2                         37.0 50.0                       87.0                         37 50                 87
1930494 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_3                         49.0 40.0                       89.0                         49 40                 89
1930495 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_4                         50.0 47.0                       97.0                         50 47                 97
1930496 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_5                         49.0 38.0                       87.0                         49 38                 87
1930497 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_6                         47.0 52.0                       99.0                         47 52                 99
1930498 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_7                         51.0 51.0                       102.0                         51 51                 102
1930499 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_8                         49.0 55.0                       104.0                         49 55                 104
1930500 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   grade_9                         68.0 72.0                       140.0                         68 72                 140
1930501 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   kindergarten                         48.0 54.0                       102.0                         48 54                 102
1930502 IN     school 1800046 9545   21st Century Charter Sch of Gary 180004602162 4164 21st Century Charter Sch of Gary   Regular School Yes Other KG 12 2021   pk_12_total 2.0 1185.0 48.0               29.0   625.0 639.0     2.0         1077.0   167.0   1264.0 2 1185 48               29   625 639     2     1077 167   1264
14434 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
17750 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_2                         0.0 0.0                       0.0                         0 0                 0
21066 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_3                         0.0 0.0                       0.0                         0 0                 0
24382 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_4                         0.0 0.0                       0.0                         0 0                 0
27698 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_5                         0.0 0.0                       0.0                         0 0                 0
31014 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_6                         113.0 134.0                       247.0                         113 134                 247
34330 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_7                         134.0 171.0                       305.0                         134 171                 305
37646 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_8                         187.0 220.0                       407.0                         187 220                 407
40962 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_9                         216.0 231.0                       447.0                         216 231                 447
44278 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_10                         165.0 239.0                       404.0                         165 239                 404
47594 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_11                         147.0 225.0                       372.0                         147 225                 372
50910 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct grade_12                         113.0 208.0                       321.0                         113 208                 321
54226 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct pk_12_total                         1075.0 1428.0             301.0         2503.0                         1075 1428         301       2503
57542 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct combined_PK                         0.0 0.0                       0.0                         0 0                 0
60858 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2021 1-Oct combined_K                         0.0 0.0                       0.0                         0 0                 0
164483 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_1                         0.0 0.0                       0.0                         0 0                 0
167830 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_2                         0.0 0.0                       0.0                         0 0                 0
171177 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_3                         0.0 0.0                       0.0                         0 0                 0
174524 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_4                         0.0 0.0                       0.0                         0 0                 0
177871 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_5                         0.0 0.0                       0.0                         0 0                 0
181218 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_6                         29.0 32.0                       61.0                         29 32                 61
184565 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_7                         60.0 63.0                       123.0                         60 63                 123
187912 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_8                         78.0 99.0                       177.0                         78 99                 177
191259 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_9                         88.0 148.0                       236.0                         88 148                 236
194606 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_10                         93.0 126.0                       219.0                         93 126                 219
197953 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_11                         89.0 148.0                       237.0                         89 148                 237
201300 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct grade_12                         73.0 144.0                       217.0                         73 144                 217
204647 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct pk_12_total                         510.0 760.0             258.0         1270.0                         510 760         258       1270
207994 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct combined_PK                         0.0 0.0                       0.0                         0 0                 0
211341 PA Chester 42029 school 4200091 124150002 CS 21st Century Cyber CS 420009100597 7691 21st Century Cyber CS   Regular School Yes High 06 12 2020 1-Oct combined_K                         0.0 0.0                       0.0                         0 0                 0
111730 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   pk_12_total 87.0 224.0 107.0     1.0         27.0   222.0 224.0             272     56   446 87 224 107     1         27   222 224         272   56   446
111731 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_1                                                   56                                             56
111732 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_2                                                   54                                             54
111733 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_3                                                   46                                             46
111734 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_4                                                   42                                             42
111735 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_5                                                   52                                             52
111736 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_6                                                   35                                             35
111737 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_7                                                   32                                             32
111738 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   40                                             40
111739 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   kindergarten_4_year_old                                                   33                                             33
111740 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   kindergarten                                                   56                                             56
281703 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   pk_12_total 71.0 202.0 139.0     2.0         31.0   219.0 226.0             311     54   445 71 202 139     2         31   219 226         311   54   445
281704 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_1                                                   50                                             50
281705 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_2                                                   59                                             59
281706 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_3                                                   46                                             46
281707 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_4                                                   45                                             45
281708 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_5                                                   40                                             40
281709 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_6                                                   58                                             58
281710 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_7                                                   30                                             30
281711 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   25                                             25
281712 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   kindergarten_4_year_old                                                   41                                             41
281713 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   kindergarten                                                   51                                             51
325597 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   pk_12_total 75.0 229.0 152.0     2.0         41.0   234.0 265.0             362     46   499 75 229 152     2         41   234 265         362   46   499
325598 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_1                                                   60                                             60
325599 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_2                                                   48                                             48
325600 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_3                                                   59                                             59
325601 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_4                                                   51                                             51
325602 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_5                                                   51                                             51
325603 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_6                                                   38                                             38
325604 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_7                                                   57                                             57
325605 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_8                                                   37                                             37
325606 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   kindergarten_4_year_old                                                   41                                             41
325607 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   kindergarten                                                   57                                             57
2318120 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   pk_12_total 47.0 288.0 176.0               40.0   262.0 289.0             467     59   551 47 288 176               40   262 289         467   59   551
2318121 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_1                                                   47                                             47
2318122 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_2                                                   55                                             55
2318123 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_3                                                   57                                             57
2318124 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_4                                                   57                                             57
2318125 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_5                                                   59                                             59
2318126 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_6                                                   58                                             58
2318127 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_7                                                   59                                             59
2318128 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_8                                                   60                                             60
2318129 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   kindergarten_4_year_old                                                   39                                             39
2318130 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   kindergarten                                                   60                                             60
2332926 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   pk_12_total 47.0 264.0 168.0               34.0   254.0 259.0     55.0       405     54   513 47 264 168               34   254 259     55   405   54   513
2332927 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_1                                                   58                                             58
2332928 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_2                                                   43                                             43
2332929 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_3                                                   56                                             56
2332930 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_4                                                   49                                             49
2332931 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_5                                                   53                                             53
2332932 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_6                                                   60                                             60
2332933 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_7                                                   60                                             60
2332934 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_8                                                   53                                             53
2332935 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   kindergarten_4_year_old                                                   37                                             37
2332936 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   kindergarten                                                   44                                             44
3073888 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2019   pk_12_total 58.0 272.0 169.0               44.0   250.0 293.0             443     61   543 58 272 169               44   250 293         443   61   543
3073889 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2019   grade_1                                                   59                                             59

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