Data source: Big Local News · About: Big Local

11,652 rows where state = "OK" and year = 2020 sorted by white_int

View and edit SQL

year

  • 2020 · 11,652
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
3025250 OK ADAIR   school 4026250 01-C024   ROCKY MOUNTAIN 402625001381 105 ROCKY MOUNTAIN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_3 0 0 0 6   0     0   1   5 2                       7 0 0 0 6   0     0   1   5 2                 7
3025268 OK ADAIR   school 4009360 01-C029   DAHLONEGAH 400936000401 105 DAHLONEGAH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_1 0 0 1 13   0     0   0   9 5                       14 0 0 1 13   0     0   0   9 5                 14
3025273 OK ADAIR   school 4009360 01-C029   DAHLONEGAH 400936000401 105 DAHLONEGAH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 0 0 0 11   0     0   0   3 8                       11 0 0 0 11   0     0   0   3 8                 11
3025275 OK ADAIR   school 4009360 01-C029   DAHLONEGAH 400936000401 105 DAHLONEGAH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 0 0 1 11   0     0   0   5 7                       12 0 0 1 11   0     0   0   5 7                 12
3025276 OK ADAIR   school 4009360 01-C029   DAHLONEGAH 400936000401 105 DAHLONEGAH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 0 0 0 16   0     0   0   3 13                       16 0 0 0 16   0     0   0   3 13                 16
3025279 OK ADAIR   school 4021870 01-C032   GREASY 402187001091 105 GREASY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_2 0 0 1 4   0     0   0   2 3                       5 0 0 1 4   0     0   0   2 3                 5
3025281 OK ADAIR   school 4021870 01-C032   GREASY 402187001091 105 GREASY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_4 0 0 0 3   0     0   0   3 0                       3 0 0 0 3   0     0   0   3 0                 3
3025284 OK ADAIR   school 4021870 01-C032   GREASY 402187001091 105 GREASY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 0 0 0 3   0     0   0   0 3                       3 0 0 0 3   0     0   0   0 3                 3
3025286 OK ADAIR   school 4021870 01-C032   GREASY 402187001091 105 GREASY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 0 0 0 5   0     0   1   3 3                       6 0 0 0 5   0     0   1   3 3                 6
3025330 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000274 105 CAVE SPRINGS ES Elementary Regular School No Elementary PK 04 2020   grade_1 0 0 0 4   0     0   0   2 2                       4 0 0 0 4   0     0   0   2 2                 4
3025331 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000274 105 CAVE SPRINGS ES Elementary Regular School No Elementary PK 04 2020   grade_2 0 0 0 2   0     0   0   1 1                       2 0 0 0 2   0     0   0   1 1                 2
3025334 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000274 105 CAVE SPRINGS ES Elementary Regular School No Elementary PK 04 2020   kindergarten_full_day 0 0 0 6   0     0   0   3 3                       6 0 0 0 6   0     0   0   3 3                 6
3025337 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2020   grade_6 0 0 0 6   0     0   0   5 1                       6 0 0 0 6   0     0   0   5 1                 6
3025339 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2020   grade_8 0 0 0 3   0     0   0   2 1                       3 0 0 0 3   0     0   0   2 1                 3
3025620 OK BLAINE   school 4012570 06-I080   GEARY 401257029617 715 GEARY HS High School Regular School No High 09 12 2020   out_of_home_placement 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3025815 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005010 105 APACHE ES Elementary Regular School No Elementary PK 05 2020   out_of_home_placement 0 0 0 2   0     0   0   1 1                       2 0 0 0 2   0     0   0   1 1                 2
3025931 OK CANADIAN   school 4009420 09-C070   DARLINGTON 400942000404 105 DARLINGTON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_4 0 0 3 16   0     0   3   10 12                       22 0 0 3 16   0     0   3   10 12                 22
3025935 OK CANADIAN   school 4009420 09-C070   DARLINGTON 400942000404 105 DARLINGTON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 0 0 2 11   0     0   1   5 9                       14 0 0 2 11   0     0   1   5 9                 14
3025971 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2020   out_of_home_placement 0 1 1 1   0     0   0   1 2                       3 0 1 1 1   0     0   0   1 2                 3
3026010 OK CANADIAN   school 4033480 09-I027   YUKON 403348001886 130 PARKLAND ES Elementary Regular School No Elementary PK 03 2020   pre_kindergarten_half_day 0 0 0 0   0     0   2   0 2                       2 0 0 0 0   0     0   2   0 2                 2
3026073 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001869 115 MUSTANG LAKEHOMA ES Elementary Regular School No Elementary PK 04 2020   out_of_home_placement 0 0 0 0   0     0   1   0 1                       1 0 0 0 0   0     0   1   0 1                 1
3026283 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 0 0 0 9   0     0   1   8 2                       10 0 0 0 9   0     0   1   8 2                 10
3026325 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3026378 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000717 105 HULBERT ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_half_day 0 0 0 2   0     0   0   0 2                       2 0 0 0 2   0     0   0   0 2                 2
3026399 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001542 212 GREENWOOD ES Elementary Regular School No Elementary KG 05 2020   out_of_home_placement 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3026409 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2020   out_of_home_placement 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3026415 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   grade_1 0 0 0 16   0     0   0   7 9                       16 0 0 0 16   0     0   0   7 9                 16
3026416 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   grade_2 0 0 0 8   0     0   0   2 6                       8 0 0 0 8   0     0   0   2 6                 8
3026417 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   grade_3 0 0 0 5   0     0   0   4 1                       5 0 0 0 5   0     0   0   4 1                 5
3026418 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   grade_4 0 0 0 7   0     0   0   2 5                       7 0 0 0 7   0     0   0   2 5                 7
3026419 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   grade_5 0 0 0 11   0     0   0   6 5                       11 0 0 0 11   0     0   0   6 5                 11
3026420 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   grade_6 0 0 0 8   0     0   0   6 2                       8 0 0 0 8   0     0   0   6 2                 8
3026421 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   grade_7 0 0 0 16   0     0   1   6 11                       17 0 0 0 16   0     0   1   6 11                 17
3026422 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   grade_8 0 0 0 21   0     0   0   8 13                       21 0 0 0 21   0     0   0   8 13                 21
3026423 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   kindergarten_full_day 0 0 0 16   0     0   0   11 5                       16 0 0 0 16   0     0   0   11 5                 16
3026424 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2020   pre_kindergarten_full_day 0 0 0 10   0     0   1   6 5                       11 0 0 0 10   0     0   1   6 5                 11
3026612 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001868 125 WINDING CREEK ES Elementary Regular School No Elementary PK 06 2020   kindergarten_half_day 0 0 0 0   0     0   1   0 1                       1 0 0 0 0   0     0   1   0 1                 1
3026683 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001123 170 BROADMOORE ES Elementary Regular School No Elementary PK 06 2020   kindergarten_half_day 0 0 0 0   1     0   0   1 0                       1 0 0 0 0   1     0   0   1 0                 1
3026737 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002794 195 SOUTH LAKE ES Elementary Regular School No Elementary PK 06 2020   kindergarten_half_day 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
3026746 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002817 196 TIMBER CREEK ES Elementary Regular School No Elementary PK 06 2020   pre_kindergarten_full_day 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3026794 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001071 112 CLEVELAND ES Elementary Regular School No Elementary PK 05 2020   kindergarten_half_day 0 0 1 0   0     0   0   0 1                       1 0 0 1 0   0     0   0   0 1                 1
3026846 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001080 135 MCKINLEY ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_half_day 0 0 0 0   1     0   1   0 2                       2 0 0 0 0   1     0   1   0 2                 2
3026898 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 06 2020   grade_5 0 1 0 0   0     0   1   2 0                       2 0 1 0 0   0     0   1   2 0                 2
3026899 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 06 2020   grade_6 0 1 1 0   0     0   1   3 0                       3 0 1 1 0   0     0   1   3 0                 3
3026903 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 06 2020   kindergarten_half_day 0 0 0 0   1     0   0   1 0                       1 0 0 0 0   1     0   0   1 0                 1
3027126 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000803 110 CLEVELAND ES Elementary Regular School No Elementary PK 05 2020   out_of_home_placement 0 0 1 0   0     0   0   1 0                       1 0 0 1 0   0     0   0   1 0                 1
3027230 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2020   out_of_home_placement 0 0 1 0   0     0   1   1 1                       2 0 0 1 0   0     0   1   1 1                 2
3027234 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2020   out_of_home_placement 0 0 0 0   0     0   1   1 0                       1 0 0 0 0   0     0   1   1 0                 1
3027273 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2020   out_of_home_placement 0 0 0 1   0     0   2   1 2                       3 0 0 0 1   0     0   2   1 2                 3
3027278 OK COMANCHE   school 4010710 16-I016   ELGIN 401071000494 705 ELGIN HS High School Regular School No High 09 12 2020   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3027289 OK COMANCHE   school 4007320 16-I132   CHATTANOOGA 400732000286 105 CHATTANOOGA ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_half_day 0 0 0 0   0     0   1   1 0                       1 0 0 0 0   0     0   1   1 0                 1
3027339 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_3 0 0 1 2   0     0   0   1 2                       3 0 0 1 2   0     0   0   1 2                 3
3027342 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 0 0 0 0   0     0   1   1 0                       1 0 0 0 0   0     0   1   1 0                 1
3027343 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 0 0 1 0   0     0   0   1 0                       1 0 0 1 0   0     0   0   1 0                 1
3027417 OK CREEK   school 4013600 19-C012   GYPSY 401360000643 105 GYPSY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_2 0 0 0 2   0     0   0   2 0                       2 0 0 0 2   0     0   0   2 0                 2
3027511 OK CREEK   school 4016500 19-I018   KIEFER 401650000767 105 KIEFER ES Elementary Regular School No Elementary PK 06 2020   out_of_home_placement 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
3027680 OK DELAWARE   school 4008010 21-C006   CLEORA 400801000330 105 CLEORA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_half_day 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3027687 OK DELAWARE   school 4017310 21-C014   LEACH 401731000843 105 LEACH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 0 0 1 5   0     0   0   3 3                       6 0 0 1 5   0     0   0   3 3                 6
3027691 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_1 0 0 1 7   0     0   2   6 4                       10 0 0 1 7   0     0   2   6 4                 10
3027692 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_2 0 0 0 6   0     0   4   5 5                       10 0 0 0 6   0     0   4   5 5                 10
3027693 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_3 0 0 0 7   0     0   1   4 4                       8 0 0 0 7   0     0   1   4 4                 8
3027694 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_4 0 0 1 7   0     0   1   5 4                       9 0 0 1 7   0     0   1   5 4                 9
3027695 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_5 0 0 0 9   0     0   1   7 3                       10 0 0 0 9   0     0   1   7 3                 10
3027696 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 0 0 2 12   0     0   0   7 7                       14 0 0 2 12   0     0   0   7 7                 14
3027697 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 0 0 0 11   0     0   1   9 3                       12 0 0 0 11   0     0   1   9 3                 12
3027698 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 0 0 1 8   0     0   0   3 6                       9 0 0 1 8   0     0   0   3 6                 9
3027699 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 0 0 1 9   0     0   1   7 4                       11 0 0 1 9   0     0   1   7 4                 11
3027766 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2020   grade_1 0 0 0 6   0     0   2   3 5                       8 0 0 0 6   0     0   2   3 5                 8
3027767 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2020   grade_2 0 0 0 3   0     0   0   0 3                       3 0 0 0 3   0     0   0   0 3                 3
3027770 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2020   grade_5 0 0 0 4   0     0   1   4 1                       5 0 0 0 4   0     0   1   4 1                 5
3027775 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 0 0 0 3   0     0   0   0 3                       3 0 0 0 3   0     0   0   0 3                 3
3027806 OK DEWEY   school 4027240 22-I008   SEILING 402724001438 615 SEILING JR-SR HS (JR) Junior High Regular School No Middle 07 09 2020   out_of_home_placement 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3027810 OK DEWEY   school 4027240 22-I008   SEILING 402724029665 715 SEILING JR-SR HS (SR) High School Regular School No High 10 12 2020   out_of_home_placement 0 0 0 0   0     0   1   1 0                       1 0 0 0 0   0     0   1   1 0                 1
3028069 OK GARVIN   school 4032670 25-C016   WHITEBEAD 403267001805 105 WHITEBEAD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_half_day 0 0 2 1   0     0   0   2 1                       3 0 0 2 1   0     0   0   2 1                 3
3028094 OK GARVIN   school 4023430 25-I005   PAOLI 402343001244 105 PAOLI ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_half_day 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3028099 OK GARVIN   school 4023430 25-I005   PAOLI 402343001245 705 PAOLI HS High School Regular School No High 09 12 2020   out_of_home_placement 0 0 0 1   0     0   4   2 3                       5 0 0 0 1   0     0   4   2 3                 5
3028384 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2020   out_of_home_placement 0 0 2 0   0     0   0   1 1                       2 0 0 2 0   0     0   0   1 1                 2
3028414 OK HARMON   school 4014850 29-I066   HOLLIS 401485000701 510 HOLLIS MS Middle Regular School No Middle 06 08 2020   out_of_home_placement 0 0 2 0   0     0   0   1 1                       2 0 0 2 0   0     0   0   1 1                 2
3028419 OK HARMON   school 4014850 29-I066   HOLLIS 401485000700 705 HOLLIS HS High School Regular School No High 09 12 2020   out_of_home_placement 0 0 3 0   0     0   0   2 1                       3 0 0 3 0   0     0   0   2 1                 3
3028429 OK HARPER   school 4017220 30-I001   LAVERNE 401722000795 105 LAVERNE ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 0 0 1 0   0     0   0   1 0                       1 0 0 1 0   0     0   0   1 0                 1
3028489 OK HASKELL   school 4028650 31-I020   STIGLER 402865001503 705 STIGLER HS High School Regular School No High 09 12 2020   out_of_home_placement 0 0 1 0   0     0   0   1 0                       1 0 0 1 0   0     0   0   1 0                 1
3028673 OK JEFFERSON   school 4029760 34-C003   TERRAL 402976002008 105 TERRAL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 0 0 2 0   0     0   0   0 2                       2 0 0 2 0   0     0   0   0 2                 2
3029144 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_1 0 0 2 23   0     0   1   10 16                       26 0 0 2 23   0     0   1   10 16                 26
3029145 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_2 0 0 1 21   0     0   0   9 13                       22 0 0 1 21   0     0   0   9 13                 22
3029149 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 0 0 1 14   0     0   1   4 12                       16 0 0 1 14   0     0   1   4 12                 16
3029151 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 0 0 1 17   0     0   1   11 8                       19 0 0 1 17   0     0   1   11 8                 19
3029157 OK LE FLORE   school 4011400 40-C039   FANSHAWE 401140000541 105 FANSHAWE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_4 0 0 2 4   0     0   2   4 4                       8 0 0 2 4   0     0   2   4 4                 8
3029497 OK LOGAN   school 4013560 42-I001   GUTHRIE 401356002410 130 CENTRAL ES Elementary Regular School No Elementary PK 04 2020   pre_kindergarten_half_day 0 1 0 0   0     0   1   0 2                       2 0 1 0 0   0     0   1   0 2                 2
3029653 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000539 705 FAIRVIEW HS High School Regular School No High 09 12 2020   out_of_home_placement 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
3029697 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_2 0 0 0 8   0     0   0   3 5                       8 0 0 0 8   0     0   0   3 5                 8
3029701 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 0 0 0 5   0     0   3   4 4                       8 0 0 0 5   0     0   3   4 4                 8
3029703 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 0 0 0 1   0     0   2   0 3                       3 0 0 0 1   0     0   2   0 3                 3
3029775 OK MAYES   school 4018000 46-I017   LOCUST GROVE 401800000866 105 LOCUST GROVE EARLY LRNING CTR Elementary Regular School No Elementary PK 01 2020   out_of_home_placement 0 0 0 0   0     0   1   0 1                       1 0 0 0 0   0     0   1   0 1                 1
3029781 OK MAYES   school 4018000 46-I017   LOCUST GROVE 401800002323 110 LOCUST GROVE UPPER ES Elementary Regular School No Elementary 02 05 2020   out_of_home_placement 0 0 0 1   0     0   1   2 0                       2 0 0 0 1   0     0   1   2 0                 2
3030075 OK MCINTOSH   school 4026580 49-C003   RYAL 402658001392 105 RYAL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 0 0 1 3   0     0   0   1 3                       4 0 0 1 3   0     0   0   1 3                 4
3030081 OK MCINTOSH   school 4028620 49-C016   STIDHAM 402862001501 105 STIDHAM PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_4 0 0 1 4   0     0   1   4 2                       6 0 0 1 4   0     0   1   4 2                 6
3030083 OK MCINTOSH   school 4028620 49-C016   STIDHAM 402862001501 105 STIDHAM PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 0 0 1 4   0     0   0   3 2                       5 0 0 1 4   0     0   0   3 2                 5
3030110 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735000571 112 CHECOTAH INTERMEDIATE ES Elementary Regular School No Elementary 03 05 2020   out_of_home_placement 0 1 0 0   0     0   0   0 1                       1 0 1 0 0   0     0   0   0 1                 1
3030133 OK MCINTOSH   school 4013680 49-I064   HANNA 401368000649 105 HANNA ES Elementary Regular School No Elementary PK 08 2020   grade_2 0 0 0 2   0     0   0   1 1                       2 0 0 0 2   0     0   0   1 1                 2
3030139 OK MCINTOSH   school 4013680 49-I064   HANNA 401368000649 105 HANNA ES Elementary Regular School No Elementary PK 08 2020   grade_8 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1

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