Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 11,552
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
3025487 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
3025489 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2020   grade_11 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
3025490 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2020   grade_12 14 1 0 0   0     0   0   6 9                       15 14 1 0 0   0     0   0   6 9                 15
3025491 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2020   grade_9 15 1 0 0   0     0   1   9 8                       17 15 1 0 0   0     0   1   9 8                 17
3025542 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074002836 125 ELK CITY ES Elementary Regular School No Elementary PK 03 2020   pre_kindergarten_half_day 1 0 0 0   0     0   1   2 0                       2 1 0 0 0   0     0   1   2 0                 2
3025549 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000495 705 ELK CITY HS High School Regular School No High 09 12 2020   out_of_home_placement 1 0 0 1   0     0   1   2 1                       3 1 0 0 1   0     0   1   2 1                 3
3025564 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2020   grade_1 15 0 0 0   0     0   1   7 9                       16 15 0 0 0   0     0   1   7 9                 16
3025565 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2020   grade_2 16 1 0 1   0     0   0   9 9                       18 16 1 0 1   0     0   0   9 9                 18
3025566 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2020   grade_3 18 1 0 0   0     0   1   10 10                       20 18 1 0 0   0     0   1   10 10                 20
3025567 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2020   grade_4 13 0 0 0   0     0   1   5 9                       14 13 0 0 0   0     0   1   5 9                 14
3025569 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2020   grade_6 15 0 0 0   0     0   2   9 8                       17 15 0 0 0   0     0   2   9 8                 17
3025571 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2020   grade_8 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
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
3025630 OK BLAINE   school 4006480 06-I105   CANTON 400648000253 105 CANTON ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 13 0 0 1   0     0   0   5 9                       14 13 0 0 1   0     0   0   5 9                 14
3025636 OK BRYAN   school 4027640 07-I001   SILO 402764001472 110 SILO ES Elementary Regular School No Elementary PK 05 2020   grade_4 51 0 0 10   0     0   8   41 28                       69 51 0 0 10   0     0   8   41 28                 69
3025655 OK BRYAN   school 4033601 07-I002   ROCK CREEK 403360129840 105 ROCK CREEK ES Elementary Regular School No Elementary PK 08 2020   grade_7 21 0 0 8   1     0   3   18 15                       33 21 0 0 8   1     0   3   18 15                 33
3025663 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_1 22 0 0 4   0     0   5   23 8                       31 22 0 0 4   0     0   5   23 8                 31
3025665 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_3 15 0 0 8   0     0   3   11 15                       26 15 0 0 8   0     0   3   11 15                 26
3025666 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_4 10 0 0 6   0     0   0   8 8                       16 10 0 0 6   0     0   0   8 8                 16
3025671 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 27 0 0 3   0     0   7   17 20                       37 27 0 0 3   0     0   7   17 20                 37
3025674 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2020   grade_11 16 0 0 2   0     0   1   11 8                       19 16 0 0 2   0     0   1   11 8                 19
3025676 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2020   grade_9 16 0 0 4   0     0   0   11 9                       20 16 0 0 4   0     0   0   11 9                 20
3025701 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_half_day 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
3025702 OK BRYAN   school 4006150 07-I005   CADDO 400615029619 715 CADDO HS High School Regular School No High 09 12 2020   grade_10 23 0 0 13   0     0   3   23 16                       39 23 0 0 13   0     0   3   23 16                 39
3025703 OK BRYAN   school 4006150 07-I005   CADDO 400615029619 715 CADDO HS High School Regular School No High 09 12 2020   grade_11 20 0 0 9   0     0   2   11 20                       31 20 0 0 9   0     0   2   11 20                 31
3025705 OK BRYAN   school 4006150 07-I005   CADDO 400615029619 715 CADDO HS High School Regular School No High 09 12 2020   grade_9 22 0 0 10   0     0   3   16 19                       35 22 0 0 10   0     0   3   16 19                 35
3025707 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2020   grade_2 10 0 0 7   0     0   0   9 8                       17 10 0 0 7   0     0   0   9 8                 17
3025710 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2020   grade_5 11 1 0 10   0     0   1   13 10                       23 11 1 0 10   0     0   1   13 10                 23
3025711 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2020   grade_6 12 1 0 13   0     0   2   15 13                       28 12 1 0 13   0     0   2   15 13                 28
3025713 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2020   grade_8 9 1 0 6   0     0   0   9 7                       16 9 1 0 6   0     0   0   9 7                 16
3025714 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 6 0 0 5   0     0   1   7 5                       12 6 0 0 5   0     0   1   7 5                 12
3025715 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 8 0 0 5   0     0   0   10 3                       13 8 0 0 5   0     0   0   10 3                 13
3025716 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000124 705 BENNINGTON HS High School Regular School No High 09 12 2020   grade_10 17 0 0 10   0     0   0   10 17                       27 17 0 0 10   0     0   0   10 17                 27
3025718 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000124 705 BENNINGTON HS High School Regular School No High 09 12 2020   grade_12 7 0 0 12   0     0   0   5 14                       19 7 0 0 12   0     0   0   5 14                 19
3025719 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000124 705 BENNINGTON HS High School Regular School No High 09 12 2020   grade_9 17 0 0 13   0     0   0   12 18                       30 17 0 0 13   0     0   0   12 18                 30
3025728 OK BRYAN   school 4006180 07-I048   CALERA 400618000239 105 CALERA ES Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 32 2 0 20   0     0   12   40 26                       66 32 2 0 20   0     0   12   40 26                 66
3025729 OK BRYAN   school 4006180 07-I048   CALERA 400618000239 105 CALERA ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 36 0 0 11   0     0   15   35 27                       62 36 0 0 11   0     0   15   35 27                 62
3025769 OK CADDO   school 4018390 08-I012   LOOKEBA SICKLES 401839000876 105 LOOKEBA-SICKLES ES Elementary Regular School No Elementary PK 08 2020   grade_4 10 0 0 0   0     0   2   5 7                       12 10 0 0 0   0     0   2   5 7                 12
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
3025824 OK CADDO   school 4009300 08-I064   CYRIL 400930000397 105 CYRIL ES Elementary Regular School No Elementary PK 06 2020   grade_1 8 0 0 9   0     0   3   11 9                       20 8 0 0 9   0     0   3   11 9                 20
3025835 OK CADDO   school 4009300 08-I064   CYRIL 400930029624 715 CYRIL HS High School Regular School No High 09 12 2020   grade_11 11 0 0 2   0     0   0   4 9                       13 11 0 0 2   0     0   0   4 9                 13
3025838 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2020   grade_1 4 0 0 4   0     0   1   6 3                       9 4 0 0 4   0     0   1   6 3                 9
3025839 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2020   grade_2 4 0 0 3   0     0   2   5 4                       9 4 0 0 3   0     0   2   5 4                 9
3025848 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000607 705 GRACEMONT HS High School Regular School No High 09 12 2020   grade_10 3 0 0 4   0     0   0   3 4                       7 3 0 0 4   0     0   0   3 4                 7
3025849 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000607 705 GRACEMONT HS High School Regular School No High 09 12 2020   grade_11 6 0 0 5   0     0   0   6 5                       11 6 0 0 5   0     0   0   6 5                 11
3025850 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000607 705 GRACEMONT HS High School Regular School No High 09 12 2020   grade_12 5 0 0 3   0     0   1   4 5                       9 5 0 0 3   0     0   1   4 5                 9
3025851 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000607 705 GRACEMONT HS High School Regular School No High 09 12 2020   grade_9 7 0 0 0   0     0   1   4 4                       8 7 0 0 0   0     0   1   4 4                 8
3025853 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2020   grade_2 10 0 0 2   0     0   0   6 6                       12 10 0 0 2   0     0   0   6 6                 12
3025854 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2020   grade_3 16 1 0 4   0     0   0   11 10                       21 16 1 0 4   0     0   0   11 10                 21
3025856 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2020   grade_5 7 0 0 2   0     0   0   5 4                       9 7 0 0 2   0     0   0   5 4                 9
3025859 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2020   grade_8 10 0 0 4   0     0   1   7 8                       15 10 0 0 4   0     0   1   7 8                 15
3025860 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 11 0 0 2   0     0   0   10 3                       13 11 0 0 2   0     0   0   10 3                 13
3025862 OK CADDO   school 4006960 08-I160   CEMENT 400696029625 715 CEMENT HS High School Regular School No High 09 12 2020   grade_10 11 0 0 3   0     0   1   9 6                       15 11 0 0 3   0     0   1   9 6                 15
3025865 OK CADDO   school 4006960 08-I160   CEMENT 400696029625 715 CEMENT HS High School Regular School No High 09 12 2020   grade_9 11 1 0 3   0     0   0   9 6                       15 11 1 0 3   0     0   0   9 6                 15
3025880 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229842 105 FORT COBB-BROXTON LOWER ES Elementary Regular School No Elementary PK 05 2020   grade_1 11 1 0 4   0     0   4   10 10                       20 11 1 0 4   0     0   4   10 10                 20
3025881 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229842 105 FORT COBB-BROXTON LOWER ES Elementary Regular School No Elementary PK 05 2020   grade_2 10 2 0 6   0     0   5   8 15                       23 10 2 0 6   0     0   5   8 15                 23
3025886 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229842 105 FORT COBB-BROXTON LOWER ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_half_day 7 0 0 4   0     0   6   10 7                       17 7 0 0 4   0     0   6   10 7                 17
3025887 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2020   grade_6 10 2 0 10   0     0   3   14 11                       25 10 2 0 10   0     0   3   14 11                 25
3025890 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229844 705 FORT COBB-BROXTON HS High School Regular School No High 09 12 2020   grade_10 16 0 0 7   0     0   1   15 9                       24 16 0 0 7   0     0   1   15 9                 24
3025893 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229844 705 FORT COBB-BROXTON HS High School Regular School No High 09 12 2020   grade_9 11 0 0 3   0     0   5   11 8                       19 11 0 0 3   0     0   5   11 8                 19
3025896 OK CADDO   school 4033603 08-I168   BINGER-ONEY 403360329845 105 BINGER-ONEY ES Elementary Regular School No Elementary PK 08 2020   grade_3 13 0 0 5   0     0   0   14 4                       18 13 0 0 5   0     0   0   14 4                 18
3025911 OK CANADIAN   school 4026010 09-C029   RIVERSIDE 402601001379 105 RIVERSIDE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_4 9 0 0 1   0     0   2   4 8                       12 9 0 0 1   0     0   2   4 8                 12
3025936 OK CANADIAN   school 4009420 09-C070   DARLINGTON 400942000404 105 DARLINGTON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 3 0 0 15   0     0   6   12 12                       24 3 0 0 15   0     0   6   12 12                 24
3025937 OK CANADIAN   school 4009420 09-C070   DARLINGTON 400942000404 105 DARLINGTON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 4 0 0 15   0     0   6   12 13                       25 4 0 0 15   0     0   6   12 13                 25
3025956 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002391 115 STONE RIDGE ES Elementary Regular School No Elementary 01 04 2020   out_of_home_placement 2 0 0 0   0     0   0   0 2                       2 2 0 0 0   0     0   0   0 2                 2
3025966 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002909 130 PIEDMONT EARLY CHILDHOOD CTR Elementary Regular School No Elementary PK KG 2020   out_of_home_placement 3 0 0 0   0     0   0   1 2                       3 3 0 0 0   0     0   0   1 2                 3
3025998 OK CANADIAN   school 4033480 09-I027   YUKON 403348001846 120 RANCHWOOD ES Elementary Regular School No Elementary PK 03 2020   pre_kindergarten_half_day 2 0 0 0   0     0   0   1 1                       2 2 0 0 0   0     0   0   1 1                 2
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
3026041 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000484 705 EL RENO HS High School Regular School No High 09 12 2020   out_of_home_placement 13 4 0 1   0     0   3   19 2                       21 13 4 0 1   0     0   3   19 2                 21
3026045 OK CANADIAN   school 4030630 09-I057   UNION CITY 403063001706 105 UNION CITY ES Elementary Regular School No Elementary PK 08 2020   grade_4 20 0 0 2   0     0   1   14 9                       23 20 0 0 2   0     0   1   14 9                 23
3026053 OK CANADIAN   school 4030630 09-I057   UNION CITY 403063001707 705 UNION CITY HS High School Regular School No High 09 12 2020   grade_11 19 0 0 0   0     0   2   12 9                       21 19 0 0 0   0     0   2   12 9                 21
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
3026080 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100029628 120 MUSTANG TRAILS ES Elementary Regular School No Elementary PK 04 2020   out_of_home_placement 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
3026082 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100029628 120 MUSTANG TRAILS ES Elementary Regular School No Elementary PK 04 2020   pre_kindergarten_half_day 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
3026088 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001605 125 MUSTANG CREEK ES Elementary Regular School No Elementary PK 04 2020   out_of_home_placement 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
3026100 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002767 140 MUSTANG HORIZON IES Elementary Regular School No Middle 05 06 2020   out_of_home_placement 2 0 0 1   0     0   1   1 3                       4 2 0 0 1   0     0   1   1 3                 4
3026119 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2020   out_of_home_placement 1 0 0 1   0     0   0   0 2                       2 1 0 0 1   0     0   0   0 2                 2
3026133 OK CANADIAN   school 4006240 09-I076   CALUMET 400624000241 105 CALUMET ES Elementary Regular School No Elementary PK 08 2020   grade_5 15 0 0 5   0     0   4   9 15                       24 15 0 0 5   0     0   4   9 15                 24
3026147 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_5 18 0 0 13   0     0   9   20 20                       40 18 0 0 13   0     0   9   20 20                 40
3026148 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 15 0 0 3   0     0   16   15 19                       34 15 0 0 3   0     0   16   15 19                 34
3026150 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 11 0 0 3   0     0   4   7 11                       18 11 0 0 3   0     0   4   7 11                 18
3026151 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 16 0 0 7   0     0   4   13 14                       27 16 0 0 7   0     0   4   13 14                 27
3026152 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 28 0 0 5   0     0   9   23 19                       42 28 0 0 5   0     0   9   23 19                 42
3026179 OK CARTER   school 4028350 10-I021   SPRINGER 402835001495 105 SPRINGER ES Elementary Regular School No Elementary PK 08 2020   grade_3 9 1 0 2   0     0   4   8 8                       16 9 1 0 2   0     0   4   8 8                 16
3026182 OK CARTER   school 4028350 10-I021   SPRINGER 402835001495 105 SPRINGER ES Elementary Regular School No Elementary PK 08 2020   grade_6 9 2 0 3   0     0   6   9 11                       20 9 2 0 3   0     0   6   9 11                 20
3026188 OK CARTER   school 4028350 10-I021   SPRINGER 402835001496 705 SPRINGER HS High School Regular School No High 09 12 2020   grade_11 5 0 0 0   0     0   1   4 2                       6 5 0 0 0   0     0   1   4 2                 6
3026212 OK CARTER   school 4018090 10-I032   LONE GROVE 401809001120 110 LONE GROVE PRIMARY ES Elementary Regular School No Elementary PK 02 2020   pre_kindergarten_half_day 2 0 0 2   0     0   0   4 0                       4 2 0 0 2   0     0   0   4 0                 4
3026221 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2020   grade_2 15 0 0 3   0     0   1   5 14                       19 15 0 0 3   0     0   1   5 14                 19
3026222 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2020   grade_3 14 1 0 3   0     0   0   10 8                       18 14 1 0 3   0     0   0   10 8                 18
3026224 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2020   grade_5 15 2 0 5   0     0   0   11 11                       22 15 2 0 5   0     0   0   11 11                 22
3026225 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2020   grade_6 20 0 0 12   0     0   0   12 20                       32 20 0 0 12   0     0   0   12 20                 32
3026230 OK CARTER   school 4032940 10-I043   WILSON 403294001816 705 WILSON HS High School Regular School No High 09 12 2020   grade_10 29 1 0 14   0     0   0   22 22                       44 29 1 0 14   0     0   0   22 22                 44
3026231 OK CARTER   school 4032940 10-I043   WILSON 403294001816 705 WILSON HS High School Regular School No High 09 12 2020   grade_11 25 1 0 11   0     1   0   20 18                       38 25 1 0 11   0     1   0   20 18                 38
3026232 OK CARTER   school 4032940 10-I043   WILSON 403294001816 705 WILSON HS High School Regular School No High 09 12 2020   grade_12 22 0 0 11   0     0   1   16 18                       34 22 0 0 11   0     0   1   16 18                 34
3026233 OK CARTER   school 4032940 10-I043   WILSON 403294001816 705 WILSON HS High School Regular School No High 09 12 2020   grade_9 28 0 0 4   0     0   2   19 15                       34 28 0 0 4   0     0   2   19 15                 34
3026240 OK CARTER   school 4014130 10-I055   HEALDTON 401413000667 105 HEALDTON ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 20 1 0 2   0     0   2   12 13                       25 20 1 0 2   0     0   2   12 13                 25
3026248 OK CARTER   school 4012060 10-I074   FOX 401206000562 105 FOX ES Elementary Regular School No Elementary PK 08 2020   grade_1 9 0 0 3   0     0   2   7 7                       14 9 0 0 3   0     0   2   7 7                 14
3026249 OK CARTER   school 4012060 10-I074   FOX 401206000562 105 FOX ES Elementary Regular School No Elementary PK 08 2020   grade_2 13 6 0 3   0     0   0   8 14                       22 13 6 0 3   0     0   0   8 14                 22
3026250 OK CARTER   school 4012060 10-I074   FOX 401206000562 105 FOX ES Elementary Regular School No Elementary PK 08 2020   grade_3 9 1 0 1   0     0   1   5 7                       12 9 1 0 1   0     0   1   5 7                 12
3026251 OK CARTER   school 4012060 10-I074   FOX 401206000562 105 FOX ES Elementary Regular School No Elementary PK 08 2020   grade_4 13 3 0 2   0     0   0   9 9                       18 13 3 0 2   0     0   0   9 9                 18

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