Data source: Big Local News · About: Big Local

11,843 rows where state = "OK" and year = 2019 sorted by hispanic_int

View and edit SQL

year

  • 2019 · 11,743
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
2306527 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2019   grade_1 6 0 0 0   0     0   0   5 1                       6 6 0 0 0   0     0   0   5 1                 6
2306530 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2019   grade_4 11 0 0 0   0     0   1   4 8                       12 11 0 0 0   0     0   1   4 8                 12
2306532 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2019   grade_6 6 0 0 0   0     0   0   3 3                       6 6 0 0 0   0     0   0   3 3                 6
2306533 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2019   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
2306534 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2019   grade_8 16 1 0 0   0     0   1   9 9                       18 16 1 0 0   0     0   1   9 9                 18
2306537 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2019   grade_10 13 0 0 0   0     0   0   7 6                       13 13 0 0 0   0     0   0   7 6                 13
2306538 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2019   grade_11 14 1 0 0   0     0   0   6 9                       15 14 1 0 0   0     0   0   6 9                 15
2306539 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2019   grade_12 8 0 0 0   0     0   0   3 5                       8 8 0 0 0   0     0   0   3 5                 8
2306598 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000495 705 ELK CITY HS High School Regular School No High 08 12 2019   out_of_home_placement 2 0 0 1   0     0   0   3 0                       3 2 0 0 1   0     0   0   3 0                 3
2306613 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2019   grade_1 23 1 0 0   0     0   1   14 11                       25 23 1 0 0   0     0   1   14 11                 25
2306614 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2019   grade_2 22 1 0 0   0     0   2   11 14                       25 22 1 0 0   0     0   2   11 14                 25
2306615 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2019   grade_3 12 0 0 0   0     0   1   5 8                       13 12 0 0 0   0     0   1   5 8                 13
2306617 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2019   grade_5 17 0 0 0   0     0   2   10 9                       19 17 0 0 0   0     0   2   10 9                 19
2306619 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2019   grade_7 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
2306621 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2019   kindergarten_full_day 19 0 0 0   0     0   3   12 10                       22 19 0 0 0   0     0   3   12 10                 22
2306622 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 12 1 0 2   0     0   2   9 8                       17 12 1 0 2   0     0   2   9 8                 17
2306625 OK BECKHAM   school 4011040 05-I051   ERICK 401104029615 715 ERICK HS High School Regular School No High 09 12 2019   grade_12 17 0 0 0   0     0   2   10 9                       19 17 0 0 0   0     0   2   10 9                 19
2306681 OK BLAINE   school 4006480 06-I105   CANTON 400648000254 705 CANTON HS High School Regular School No High 09 12 2019   grade_11 13 0 0 8   0     0   1   10 12                       22 13 0 0 8   0     0   1   10 12                 22
2306693 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2019   grade_8 59 1 0 16   0     0   6   45 37                       82 59 1 0 16   0     0   6   45 37                 82
2306703 OK BRYAN   school 4033601 07-I002   ROCK CREEK 403360129840 105 ROCK CREEK ES Elementary Regular School No Elementary PK 08 2019   grade_6 24 0 0 12   1     0   1   26 12                       38 24 0 0 12   1     0   1   26 12                 38
2306714 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2019   grade_3 10 0 0 6   0     0   1   7 10                       17 10 0 0 6   0     0   1   7 10                 17
2306719 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2019   grade_8 16 0 0 4   0     0   1   10 11                       21 16 0 0 4   0     0   1   10 11                 21
2306722 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2019   grade_10 16 1 0 2   0     0   2   13 8                       21 16 1 0 2   0     0   2   13 8                 21
2306724 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000002 705 ACHILLE HS High School Regular School No High 09 12 2019   grade_12 12 0 0 5   0     0   0   8 9                       17 12 0 0 5   0     0   0   8 9                 17
2306743 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2019   grade_4 20 1 0 17   0     0   3   20 21                       41 20 1 0 17   0     0   3   20 21                 41
2306745 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2019   grade_6 20 0 0 11   0     0   5   20 16                       36 20 0 0 11   0     0   5   20 16                 36
2306747 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2019   grade_8 22 0 0 9   0     0   1   12 20                       32 22 0 0 9   0     0   1   12 20                 32
2306748 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2019   kindergarten_full_day 16 0 0 13   0     0   2   16 15                       31 16 0 0 13   0     0   2   16 15                 31
2306750 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2019   pre_kindergarten_half_day 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
2306751 OK BRYAN   school 4006150 07-I005   CADDO 400615029619 715 CADDO HS High School Regular School No High 09 12 2019   grade_10 22 0 0 10   0     0   2   12 22                       34 22 0 0 10   0     0   2   12 22                 34
2306754 OK BRYAN   school 4006150 07-I005   CADDO 400615029619 715 CADDO HS High School Regular School No High 09 12 2019   grade_9 25 0 0 17   0     0   3   25 20                       45 25 0 0 17   0     0   3   25 20                 45
2306758 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2019   grade_4 13 1 0 10   0     0   1   13 12                       25 13 1 0 10   0     0   1   13 12                 25
2306759 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2019   grade_5 13 1 0 11   0     0   2   13 14                       27 13 1 0 11   0     0   2   13 14                 27
2306761 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2019   grade_7 13 1 0 8   0     0   0   13 9                       22 13 1 0 8   0     0   0   13 9                 22
2306765 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000124 705 BENNINGTON HS High School Regular School No High 09 12 2019   grade_10 13 0 0 10   0     0   0   13 10                       23 13 0 0 10   0     0   0   13 10                 23
2306766 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000124 705 BENNINGTON HS High School Regular School No High 09 12 2019   grade_11 8 1 0 11   0     0   0   7 13                       20 8 1 0 11   0     0   0   7 13                 20
2306768 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000124 705 BENNINGTON HS High School Regular School No High 09 12 2019   grade_9 18 0 0 10   0     0   0   9 19                       28 18 0 0 10   0     0   0   9 19                 28
2306776 OK BRYAN   school 4006180 07-I048   CALERA 400618000239 105 CALERA ES Elementary Regular School No Elementary PK 08 2019   grade_8 30 1 0 11   0     0   6   29 19                       48 30 1 0 11   0     0   6   29 19                 48
2306801 OK BRYAN   school 4010350 07-I072   DURANT 401035000456 705 DURANT HS High School Regular School No High 09 12 2019   out_of_home_placement 5 0 0 0   0     0   0   5 0                       5 5 0 0 0   0     0   0   5 0                 5
2306860 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005010 105 APACHE ES Elementary Regular School No Elementary PK 05 2019   grade_1 12 2 0 14   0     0   7   19 16                       35 12 2 0 14   0     0   7   19 16                 35
2306866 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005010 105 APACHE ES Elementary Regular School No Elementary PK 05 2019   out_of_home_placement 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
2306871 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2019   out_of_home_placement 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
2306876 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005013 705 APACHE HS High School Regular School No High 09 12 2019   out_of_home_placement 2 0 0 0   0     0   0   1 1                       2 2 0 0 0   0     0   0   1 1                 2
2306887 OK CADDO   school 4009300 08-I064   CYRIL 400930029624 715 CYRIL HS High School Regular School No High 09 12 2019   grade_10 13 0 0 4   0     0   1   7 11                       18 13 0 0 4   0     0   1   7 11                 18
2306889 OK CADDO   school 4009300 08-I064   CYRIL 400930029624 715 CYRIL HS High School Regular School No High 09 12 2019   grade_12 20 0 0 1   0     0   1   9 13                       22 20 0 0 1   0     0   1   9 13                 22
2306891 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2019   grade_1 1 0 0 11   0     0   3   8 7                       15 1 0 0 11   0     0   3   8 7                 15
2306898 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2019   grade_8 5 0 0 7   0     0   0   5 7                       12 5 0 0 7   0     0   0   5 7                 12
2306899 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2019   kindergarten_full_day 5 0 0 2   0     0   2   6 3                       9 5 0 0 2   0     0   2   6 3                 9
2306900 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 2 0 0 5   0     0   1   6 2                       8 2 0 0 5   0     0   1   6 2                 8
2306901 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000607 705 GRACEMONT HS High School Regular School No High 09 12 2019   grade_10 1 0 0 9   0     0   1   5 6                       11 1 0 0 9   0     0   1   5 6                 11
2306902 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000607 705 GRACEMONT HS High School Regular School No High 09 12 2019   grade_11 2 0 0 6   0     0   2   4 6                       10 2 0 0 6   0     0   2   4 6                 10
2306904 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000607 705 GRACEMONT HS High School Regular School No High 09 12 2019   grade_9 2 0 0 6   0     0   1   3 6                       9 2 0 0 6   0     0   1   3 6                 9
2306905 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2019   grade_1 10 0 0 1   0     0   0   6 5                       11 10 0 0 1   0     0   0   6 5                 11
2306906 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2019   grade_2 17 0 0 3   0     0   0   11 9                       20 17 0 0 3   0     0   0   11 9                 20
2306908 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2019   grade_4 11 0 0 2   0     0   0   7 6                       13 11 0 0 2   0     0   0   7 6                 13
2306909 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2019   grade_5 21 0 0 5   0     0   0   8 18                       26 21 0 0 5   0     0   0   8 18                 26
2306912 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2019   grade_8 11 1 0 3   0     0   0   10 5                       15 11 1 0 3   0     0   0   10 5                 15
2306914 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 10 1 0 1   0     0   0   10 2                       12 10 1 0 1   0     0   0   10 2                 12
2306917 OK CADDO   school 4006960 08-I160   CEMENT 400696029625 715 CEMENT HS High School Regular School No High 09 12 2019   grade_12 12 1 0 5   1     0   0   10 9                       19 12 1 0 5   1     0   0   10 9                 19
2306918 OK CADDO   school 4006960 08-I160   CEMENT 400696029625 715 CEMENT HS High School Regular School No High 09 12 2019   grade_9 14 1 0 3   0     0   0   10 8                       18 14 1 0 3   0     0   0   10 8                 18
2306933 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229842 105 FORT COBB-BROXTON LOWER ES Elementary Regular School No Elementary PK 05 2019   grade_1 13 2 0 2   0     0   3   9 11                       20 13 2 0 2   0     0   3   9 11                 20
2306934 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229842 105 FORT COBB-BROXTON LOWER ES Elementary Regular School No Elementary PK 05 2019   grade_2 17 0 0 7   0     0   5   17 12                       29 17 0 0 7   0     0   5   17 12                 29
2306937 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229842 105 FORT COBB-BROXTON LOWER ES Elementary Regular School No Elementary PK 05 2019   grade_5 10 2 0 10   0     0   3   14 11                       25 10 2 0 10   0     0   3   14 11                 25
2306938 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229842 105 FORT COBB-BROXTON LOWER ES Elementary Regular School No Elementary PK 05 2019   kindergarten_full_day 9 1 0 5   0     0   6   10 11                       21 9 1 0 5   0     0   6   10 11                 21
2306942 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2019   grade_8 12 0 0 4   0     0   4   11 9                       20 12 0 0 4   0     0   4   11 9                 20
2306946 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360229844 705 FORT COBB-BROXTON HS High School Regular School No High 09 12 2019   grade_9 15 0 0 6   0     0   2   13 10                       23 15 0 0 6   0     0   2   13 10                 23
2306948 OK CADDO   school 4033603 08-I168   BINGER-ONEY 403360329845 105 BINGER-ONEY ES Elementary Regular School No Elementary PK 08 2019   grade_2 14 0 0 4   0     0   1   13 6                       19 14 0 0 4   0     0   1   13 6                 19
2306953 OK CADDO   school 4033603 08-I168   BINGER-ONEY 403360329845 105 BINGER-ONEY ES Elementary Regular School No Elementary PK 08 2019   grade_7 13 0 0 7   0     0   5   13 12                       25 13 0 0 7   0     0   5   13 12                 25
2306955 OK CADDO   school 4033603 08-I168   BINGER-ONEY 403360329845 105 BINGER-ONEY ES Elementary Regular School No Elementary PK 08 2019   kindergarten_full_day 15 1 0 1   0     0   0   9 8                       17 15 1 0 1   0     0   0   9 8                 17
2306956 OK CADDO   school 4033603 08-I168   BINGER-ONEY 403360329845 105 BINGER-ONEY ES Elementary Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 22 0 0 0   0     0   4   15 11                       26 22 0 0 0   0     0   4   15 11                 26
2306960 OK CADDO   school 4033603 08-I168   BINGER-ONEY 403360329846 705 BINGER-ONEY HS High School Regular School No High 09 12 2019   grade_9 17 1 0 6   0     0   3   12 15                       27 17 1 0 6   0     0   3   12 15                 27
2306990 OK CANADIAN   school 4009420 09-C070   DARLINGTON 400942000404 105 DARLINGTON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 6 0 0 16   0     0   4   14 12                       26 6 0 0 16   0     0   4   14 12                 26
2306992 OK CANADIAN   school 4018900 09-C162   MAPLE 401890000897 105 MAPLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_2 15 0 0 3   0     0   0   10 8                       18 15 0 0 3   0     0   0   10 8                 18
2307000 OK CANADIAN   school 4018900 09-C162   MAPLE 401890000897 105 MAPLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 15 0 0 1   0     0   4   7 13                       20 15 0 0 1   0     0   4   7 13                 20
2307006 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001271 105 PIEDMONT ES Elementary Regular School No Elementary KG 04 2019   out_of_home_placement 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
2307007 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002114 110 PIEDMONT PRIMARY ES Elementary Regular School No Prekindergarten PK PK 2019   out_of_home_placement 1 0 0 1   0     0   0   2 0                       2 1 0 0 1   0     0   0   2 0                 2
2307052 OK CANADIAN   school 4033480 09-I027   YUKON 403348001846 120 RANCHWOOD ES Elementary Regular School No Elementary PK 03 2019   pre_kindergarten_half_day 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
2307064 OK CANADIAN   school 4033480 09-I027   YUKON 403348001886 130 PARKLAND ES Elementary Regular School No Elementary PK 03 2019   pre_kindergarten_half_day 1 0 0 1   0     0   0   0 2                       2 1 0 0 1   0     0   0   0 2                 2
2307106 OK CANADIAN   school 4030630 09-I057   UNION CITY 403063001707 705 UNION CITY HS High School Regular School No High 09 12 2019   grade_10 21 0 0 0   0     0   2   12 11                       23 21 0 0 0   0     0   2   12 11                 23
2307149 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002767 140 MUSTANG HORIZON IES Elementary Regular School No Middle 05 06 2019   out_of_home_placement 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
2307177 OK CANADIAN   school 4006240 09-I076   CALUMET 400624000241 105 CALUMET ES Elementary Regular School No Elementary PK 08 2019   grade_3 12 0 0 9   0     0   2   12 11                       23 12 0 0 9   0     0   2   12 11                 23
2307178 OK CANADIAN   school 4006240 09-I076   CALUMET 400624000241 105 CALUMET ES Elementary Regular School No Elementary PK 08 2019   grade_4 12 0 0 6   0     0   4   10 12                       22 12 0 0 6   0     0   4   10 12                 22
2307192 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_4 14 1 0 7   0     0   9   17 14                       31 14 1 0 7   0     0   9   17 14                 31
2307195 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 0 5   0     0   5   8 11                       19 9 0 0 5   0     0   5   8 11                 19
2307197 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   kindergarten_full_day 16 0 0 3   0     0   8   15 12                       27 16 0 0 3   0     0   8   15 12                 27
2307198 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 14 0 0 6   0     0   3   10 13                       23 14 0 0 6   0     0   3   10 13                 23
2307216 OK CARTER   school 4003180 10-I019   ARDMORE 400318029635 135 WILL ROGERS ES Elementary Regular School No Elementary PK KG 2019   pre_kindergarten_half_day 2 0 0 0   0     0   1   2 1                       3 2 0 0 0   0     0   1   2 1                 3
2307225 OK CARTER   school 4028350 10-I021   SPRINGER 402835001495 105 SPRINGER ES Elementary Regular School No Elementary PK 08 2019   grade_2 10 1 0 2   0     0   3   10 6                       16 10 1 0 2   0     0   3   10 6                 16
2307227 OK CARTER   school 4028350 10-I021   SPRINGER 402835001495 105 SPRINGER ES Elementary Regular School No Elementary PK 08 2019   grade_4 6 1 0 2   0     0   7   7 9                       16 6 1 0 2   0     0   7   7 9                 16
2307228 OK CARTER   school 4028350 10-I021   SPRINGER 402835001495 105 SPRINGER ES Elementary Regular School No Elementary PK 08 2019   grade_5 10 1 0 3   0     0   8   10 12                       22 10 1 0 3   0     0   8   10 12                 22
2307229 OK CARTER   school 4028350 10-I021   SPRINGER 402835001495 105 SPRINGER ES Elementary Regular School No Elementary PK 08 2019   grade_6 8 2 0 1   0     0   7   7 11                       18 8 2 0 1   0     0   7   7 11                 18
2307234 OK CARTER   school 4028350 10-I021   SPRINGER 402835001496 705 SPRINGER HS High School Regular School No High 09 12 2019   grade_10 7 0 0 1   0     0   2   6 4                       10 7 0 0 1   0     0   2   6 4                 10
2307259 OK CARTER   school 4018090 10-I032   LONE GROVE 401809001120 110 LONE GROVE PRIMARY ES Elementary Regular School No Elementary PK 02 2019   pre_kindergarten_half_day 2 0 0 1   0     0   0   1 2                       3 2 0 0 1   0     0   0   1 2                 3
2307267 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2019   grade_1 19 0 0 4   0     0   0   10 13                       23 19 0 0 4   0     0   0   10 13                 23
2307268 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2019   grade_2 16 0 0 2   0     1   0   11 8                       19 16 0 0 2   0     1   0   11 8                 19
2307269 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2019   grade_3 21 0 0 10   0     0   0   17 14                       31 21 0 0 10   0     0   0   17 14                 31
2307270 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2019   grade_4 16 2 0 6   0     0   0   12 12                       24 16 2 0 6   0     0   0   12 12                 24
2307271 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2019   grade_5 16 0 0 15   0     0   0   9 22                       31 16 0 0 15   0     0   0   9 22                 31
2307272 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2019   grade_6 13 0 0 6   0     0   0   8 11                       19 13 0 0 6   0     0   0   8 11                 19
2307273 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2019   grade_7 17 0 0 9   0     0   0   13 13                       26 17 0 0 9   0     0   0   13 13                 26

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