Data source: Big Local News · About: Big Local

11,537 rows where state = "OK" and year = 2021 sorted by white_int

View and edit SQL

year

  • 2021 · 11,537
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
3324301 OK ADAIR   school 4010560 01-C019   PEAVINE 401056000470 105 PEAVINE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_3 0 0 0 7   0     0   0   3 4                       7 0 0 0 7   0     0   0   3 4                 7
3324304 OK ADAIR   school 4010560 01-C019   PEAVINE 401056000470 105 PEAVINE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_6 0 0 1 11   1     0   0   7 6                       13 0 0 1 11   1     0   0   7 6                 13
3324321 OK ADAIR   school 4026250 01-C024   ROCKY MOUNTAIN 402625001381 105 ROCKY MOUNTAIN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_3 0 0 0 7   0     0   3   6 4                       10 0 0 0 7   0     0   3   6 4                 10
3324322 OK ADAIR   school 4026250 01-C024   ROCKY MOUNTAIN 402625001381 105 ROCKY MOUNTAIN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_4 0 0 0 9   0     0   1   7 3                       10 0 0 0 9   0     0   1   7 3                 10
3324323 OK ADAIR   school 4026250 01-C024   ROCKY MOUNTAIN 402625001381 105 ROCKY MOUNTAIN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_5 0 0 1 13   0     0   3   9 8                       17 0 0 1 13   0     0   3   9 8                 17
3324328 OK ADAIR   school 4026250 01-C024   ROCKY MOUNTAIN 402625001381 105 ROCKY MOUNTAIN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   pre_kindergarten_full_day 0 0 2 7   0     0   2   6 5                       11 0 0 2 7   0     0   2   6 5                 11
3324342 OK ADAIR   school 4009360 01-C029   DAHLONEGAH 400936000401 105 DAHLONEGAH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_4 0 0 0 9   0     0   0   5 4                       9 0 0 0 9   0     0   0   5 4                 9
3324391 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000274 105 CAVE SPRINGS ES Elementary Regular School No Elementary PK 04 2021   grade_1 0 0 0 8   0     0   0   2 6                       8 0 0 0 8   0     0   0   2 6                 8
3324392 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000274 105 CAVE SPRINGS ES Elementary Regular School No Elementary PK 04 2021   grade_2 0 0 0 5   0     0   0   3 2                       5 0 0 0 5   0     0   0   3 2                 5
3324393 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000274 105 CAVE SPRINGS ES Elementary Regular School No Elementary PK 04 2021   grade_3 0 0 0 4   0     0   0   2 2                       4 0 0 0 4   0     0   0   2 2                 4
3324396 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000274 105 CAVE SPRINGS ES Elementary Regular School No Elementary PK 04 2021   pre_kindergarten_full_day 0 0 0 10   0     0   0   5 5                       10 0 0 0 10   0     0   0   5 5                 10
3324399 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2021   grade_7 0 0 0 12   0     0   0   7 5                       12 0 0 0 12   0     0   0   7 5                 12
3324401 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693000275 705 CAVE SPRINGS HS High School Regular School No High 09 12 2021   grade_10 0 0 1 17   0     0   0   11 7                       18 0 0 1 17   0     0   0   11 7                 18
3324761 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2021   pre_kindergarten_half_day 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3324874 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005010 105 APACHE ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 0 0 0 2   0     0   0   1 1                       2 0 0 0 2   0     0   0   1 1                 2
3324879 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3324884 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005013 705 APACHE HS High School Regular School No High 09 12 2021   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3324908 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2021   out_of_home_placement 0 0 2 0   0     0   0   2 0                       2 0 0 2 0   0     0   0   2 0                 2
3324995 OK CANADIAN   school 4009420 09-C070   DARLINGTON 400942000404 105 DARLINGTON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_6 0 0 1 13   0     0   1   7 8                       15 0 0 1 13   0     0   1   7 8                 15
3324996 OK CANADIAN   school 4009420 09-C070   DARLINGTON 400942000404 105 DARLINGTON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 1 4 13   0     0   1   10 9                       19 0 1 4 13   0     0   1   10 9                 19
3325018 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002391 115 STONE RIDGE ES Elementary Regular School No Elementary 01 04 2021   out_of_home_placement 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3325023 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002712 120 NORTHWOOD ES Elementary Regular School No Elementary 01 04 2021   out_of_home_placement 0 0 1 0   0     0   0   0 1                       1 0 0 1 0   0     0   0   0 1                 1
3325067 OK CANADIAN   school 4033480 09-I027   YUKON 403348001848 125 SURREY HILLS ES Elementary Regular School No Elementary PK 03 2021   pre_kindergarten_half_day 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
3325073 OK CANADIAN   school 4033480 09-I027   YUKON 403348001886 130 PARKLAND ES Elementary Regular School No Elementary PK 03 2021   pre_kindergarten_half_day 0 0 0 0   0     0   1   0 1                       1 0 0 0 0   0     0   1   0 1                 1
3325345 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_1 0 0 1 7   0     0   0   2 6                       8 0 0 1 7   0     0   0   2 6                 8
3325349 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_5 0 0 1 4   0     0   0   2 3                       5 0 0 1 4   0     0   0   2 3                 5
3325381 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 1 14   0     0   0   12 3                       15 0 0 1 14   0     0   0   12 3                 15
3325453 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001543 115 SEQUOYAH ES Elementary Regular School No Prekindergarten PK PK 2021   out_of_home_placement 0 0 1 0   0     0   1   1 1                       2 0 0 1 0   0     0   1   1 1                 2
3325468 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001542 212 GREENWOOD ES Elementary Regular School No Elementary KG 05 2021   out_of_home_placement 0 0 0 2   0     0   0   1 1                       2 0 0 0 2   0     0   0   1 1                 2
3325479 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 0 0 0 3   0     0   0   2 1                       3 0 0 0 3   0     0   0   2 1                 3
3325485 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_1 0 0 0 17   0     1   0   12 6                       18 0 0 0 17   0     1   0   12 6                 18
3325486 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_2 0 0 0 11   0     0   0   5 6                       11 0 0 0 11   0     0   0   5 6                 11
3325487 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_3 0 0 0 7   0     0   0   3 4                       7 0 0 0 7   0     0   0   3 4                 7
3325488 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_4 0 0 0 3   0     0   0   3 0                       3 0 0 0 3   0     0   0   3 0                 3
3325489 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_5 0 0 0 5   0     0   0   2 3                       5 0 0 0 5   0     0   0   2 3                 5
3325490 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_6 0 0 0 12   0     1   0   7 6                       13 0 0 0 12   0     1   0   7 6                 13
3325491 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_7 0 0 0 12   0     0   0   7 5                       12 0 0 0 12   0     0   0   7 5                 12
3325492 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_8 0 0 1 16   0     0   1   7 11                       18 0 0 1 16   0     0   1   7 11                 18
3325493 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   kindergarten_full_day 0 0 0 14   0     0   1   6 9                       15 0 0 0 14   0     0   1   6 9                 15
3325494 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   pre_kindergarten_full_day 0 0 0 10   0     0   2   8 4                       12 0 0 0 10   0     0   2   8 4                 12
3325641 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001000 112 PLAZA TOWERS ES Elementary Regular School No Elementary PK 06 2021   pre_kindergarten_full_day 0 0 1 0   1     0   0   2 0                       2 0 0 1 0   1     0   0   2 0                 2
3325667 OK CLEVELAND   school 4020250 14-I002   MOORE 402025000995 120 HOUCHIN ES Elementary Regular School No Elementary PK 06 2021   pre_kindergarten_full_day 0 1 1 0   0     0   0   0 2                       2 0 1 1 0   0     0   0   0 2                 2
3325703 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001900 140 RED OAK ES Elementary Regular School No Elementary PK 06 2021   kindergarten_half_day 0 0 0 0   3     0   0   0 3                       3 0 0 0 0   3     0   0   0 3                 3
3325778 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002363 181 WAYLAND BONDS ES Elementary Regular School No Elementary PK 06 2021   pre_kindergarten_half_day 0 1 1 0   2     0   1   4 1                       5 0 1 1 0   2     0   1   4 1                 5
3325787 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002707 185 OAKRIDGE ES Elementary Regular School No Elementary PK 06 2021   pre_kindergarten_full_day 0 0 0 2   0     0   1   2 1                       3 0 0 0 2   0     0   1   2 1                 3
3325895 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001077 125 LINCOLN ES Elementary Regular School No Elementary PK 05 2021   kindergarten_half_day 0 1 0 1   0     0   1   0 3                       3 0 1 0 1   0     0   1   0 3                 3
3325964 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_6 0 1 0 0   0     0   1   2 0                       2 0 1 0 0   0     0   1   2 0                 2
3325965 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 1 0   0     0   1   2 0                       2 0 0 1 0   0     0   1   2 0                 2
3325969 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 08 2021   pre_kindergarten_half_day 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3325995 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001082 705 NORMAN HS High School Regular School No High 09 12 2021   grade_7 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
3326276 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 0 0 1 0   0     0   0   0 1                       1 0 0 1 0   0     0   0   0 1                 1
3326290 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000809 705 EISENHOWER HS High School Regular School No High 09 12 2021   out_of_home_placement 0 0 0 0   0     0   1   0 1                       1 0 0 0 0   0     0   1   0 1                 1
3326325 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2021   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3326330 OK COMANCHE   school 4010710 16-I016   ELGIN 401071000494 705 ELGIN HS High School Regular School No High 09 12 2021   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3326389 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_1 0 0 0 3   0     0   1   2 2                       4 0 0 0 3   0     0   1   2 2                 4
3326390 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_2 0 0 0 1   0     0   1   2 0                       2 0 0 0 1   0     0   1   2 0                 2
3326392 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_4 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3326395 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 0 0   0     0   1   1 0                       1 0 0 0 0   0     0   1   1 0                 1
3326397 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   pre_kindergarten_full_day 0 0 0 3   0     0   0   1 2                       3 0 0 0 3   0     0   0   1 2                 3
3326469 OK CREEK   school 4013600 19-C012   GYPSY 401360000643 105 GYPSY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_3 0 0 0 3   0     0   0   3 0                       3 0 0 0 3   0     0   0   3 0                 3
3326486 OK CREEK   school 4025080 19-C034   PRETTY WATER 402508001316 105 PRETTY WATER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   out_of_home_placement 0 0 0 0   0     0   1   1 0                       1 0 0 0 0   0     0   1   1 0                 1
3326737 OK DELAWARE   school 4017310 21-C014   LEACH 401731000843 105 LEACH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_8 0 0 1 6   0     0   1   4 4                       8 0 0 1 6   0     0   1   4 4                 8
3326740 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_1 0 0 0 6   0     0   0   4 2                       6 0 0 0 6   0     0   0   4 2                 6
3326741 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_2 0 0 1 4   0     0   2   4 3                       7 0 0 1 4   0     0   2   4 3                 7
3326742 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_3 0 0 0 6   0     0   3   5 4                       9 0 0 0 6   0     0   3   5 4                 9
3326743 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_4 0 0 0 6   0     0   1   4 3                       7 0 0 0 6   0     0   1   4 3                 7
3326744 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_5 0 0 0 5   0     0   1   3 3                       6 0 0 0 5   0     0   1   3 3                 6
3326745 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_6 0 0 0 8   0     0   0   7 1                       8 0 0 0 8   0     0   0   7 1                 8
3326746 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 2 8   0     0   0   5 5                       10 0 0 2 8   0     0   0   5 5                 10
3326747 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_8 0 0 0 10   0     0   0   7 3                       10 0 0 0 10   0     0   0   7 3                 10
3326817 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2021   grade_3 0 0 0 4   0     0   1   2 3                       5 0 0 0 4   0     0   1   2 3                 5
3326820 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2021   grade_6 0 0 0 2   0     0   2   4 0                       4 0 0 0 2   0     0   2   4 0                 4
3326823 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2021   kindergarten_full_day 0 0 0 7   0     0   0   4 3                       7 0 0 0 7   0     0   0   4 3                 7
3326824 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2021   pre_kindergarten_full_day 0 0 0 0   0     0   1   1 0                       1 0 0 0 0   0     0   1   1 0                 1
3326827 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001100 715 OAKS-MISSION HS High School Regular School No High 09 12 2021   grade_12 0 0 0 13   0     0   0   5 8                       13 0 0 0 13   0     0   0   5 8                 13
3326850 OK DEWEY   school 4027240 22-I008   SEILING 402724001437 105 SEILING ES Elementary Regular School No Elementary PK 06 2021   out_of_home_placement 0 0 0 2   0     0   0   0 2                       2 0 0 0 2   0     0   0   0 2                 2
3327143 OK GARVIN   school 4023430 25-I005   PAOLI 402343001245 705 PAOLI HS High School Regular School No High 09 12 2021   out_of_home_placement 0 0 0 1   0     0   1   1 1                       2 0 0 0 1   0     0   1   1 1                 2
3327451 OK HARMON   school 4014850 29-I066   HOLLIS 401485000699 105 HOLLIS ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 0 0 2 0   0     0   0   2 0                       2 0 0 2 0   0     0   0   2 0                 2
3327456 OK HARMON   school 4014850 29-I066   HOLLIS 401485000701 510 HOLLIS MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 0 0 5 0   0     0   0   3 2                       5 0 0 5 0   0     0   0   3 2                 5
3327711 OK JEFFERSON   school 4029760 34-C003   TERRAL 402976002008 105 TERRAL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_5 0 0 2 1   0     0   0   2 1                       3 0 0 2 1   0     0   0   2 1                 3
3327773 OK JOHNSTON   school 4025530 35-C010   RAVIA 402553001364 105 RAVIA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_5 0 0 0 4   0     0   3   3 4                       7 0 0 0 4   0     0   3   3 4                 7
3328072 OK KIOWA   school 4018270 38-I002   LONE WOLF 401827000874 705 LONE WOLF HS High School Regular School No High 09 12 2021   grade_12 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3328098 OK KIOWA   school 4027930 38-I004   SNYDER 402793002085 110 JOHN D MOELLER ES Elementary Regular School No Elementary PK 02 2021   out_of_home_placement 0 2 0 0   0     0   0   0 2                       2 0 2 0 0   0     0   0   0 2                 2
3328184 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_6 0 0 2 22   0     0   0   15 9                       24 0 0 2 22   0     0   0   15 9                 24
3328728 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_1 0 0 0 2   0     0   4   1 5                       6 0 0 0 2   0     0   4   1 5                 6
3328729 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_2 0 0 0 11   0     0   0   6 5                       11 0 0 0 11   0     0   0   6 5                 11
3328730 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_3 0 0 0 11   0     0   0   4 7                       11 0 0 0 11   0     0   0   4 7                 11
3328734 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 0 7   0     0   3   6 4                       10 0 0 0 7   0     0   3   6 4                 10
3328763 OK MAYES   school 4025200 46-I001   PRYOR 402520001320 110 JEFFERSON ES Elementary Regular School No Elementary PK 05 2021   pre_kindergarten_half_day 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3328824 OK MAYES   school 4007670 46-I032   CHOUTEAU-MAZIE 400767000316 105 CHOUTEAU ES Elementary Regular School No Elementary 02 04 2021   out_of_home_placement 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3328994 OK MCCURTAIN   school 4015370 48-I005   IDABEL 401537000724 505 IDABEL MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 0 1 0 0   0     0   0   0 1                       1 0 1 0 0   0     0   0   0 1                 1
3329079 OK MCCURTAIN   school 4003660 48-I071   BATTIEST 400366000112 105 BATTIEST ES Elementary Regular School No Elementary PK 08 2021   pre_kindergarten_full_day 0 0 1 1   0     0   0   1 1                       2 0 0 1 1   0     0   0   1 1                 2
3329103 OK MCINTOSH   school 4026580 49-C003   RYAL 402658001392 105 RYAL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_6 0 0 0 4   1     0   0   2 3                       5 0 0 0 4   1     0   0   2 3                 5
3329114 OK MCINTOSH   school 4028620 49-C016   STIDHAM 402862001501 105 STIDHAM PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 1 3   0     0   0   2 2                       4 0 0 1 3   0     0   0   2 2                 4
3329140 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735000571 112 CHECOTAH INTERMEDIATE ES Elementary Regular School No Elementary 03 05 2021   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3329144 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735001859 505 CHECOTAH MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 0 0 1 0   0     0   0   0 1                       1 0 0 1 0   0     0   0   0 1                 1
3329165 OK MCINTOSH   school 4013680 49-I064   HANNA 401368000649 105 HANNA ES Elementary Regular School No Elementary PK 08 2021   grade_3 0 0 0 2   0     0   1   1 2                       3 0 0 0 2   0     0   1   1 2                 3
3329171 OK MCINTOSH   school 4013680 49-I064   HANNA 401368000649 105 HANNA ES Elementary Regular School No Elementary PK 08 2021   kindergarten_full_day 0 0 0 4   0     0   0   2 2                       4 0 0 0 4   0     0   0   2 2                 4
3329176 OK MCINTOSH   school 4013680 49-I064   HANNA 401368000650 705 HANNA HS High School Regular School No High 09 12 2021   grade_9 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
3329179 OK MURRAY   school 4000075 50-H000   OKLAHOMA SCHOOL FOR THE DEAF 400007502347 105 OKLAHOMA SCHOOL FOR THE DEAF Elementary Special Education School No Elementary PK 08 2021   grade_3 0 0 1 2   0     0   1   2 2                       4 0 0 1 2   0     0   1   2 2                 4

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