Data source: Big Local News · About: Big Local

58,650 rows where state = "OK" sorted by native_american

View and edit SQL

year

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
475623 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_1 12 0 1 0   1     0   3   8 9                       17 12 0 1 0   1     0   3   8 9                 17
475624 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_2 10 0 1 0   0     0   3   8 6                       14 10 0 1 0   0     0   3   8 6                 14
475625 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_3 16 0 1 0   0     0   2   10 9                       19 16 0 1 0   0     0   2   10 9                 19
475626 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_4 8 0 1 0   0     0   1   4 6                       10 8 0 1 0   0     0   1   4 6                 10
475627 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_5 10 0 2 0   0     0   0   6 6                       12 10 0 2 0   0     0   0   6 6                 12
475628 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_6 9 0 0 0   0     0   1   5 5                       10 9 0 0 0   0     0   1   5 5                 10
475629 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 2 0   0     0   1   5 6                       11 8 0 2 0   0     0   1   5 6                 11
475631 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 15 0 0 0   0     0   2   11 6                       17 15 0 0 0   0     0   2   11 6                 17
475632 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 11 0 0 0   0     0   2   3 10                       13 11 0 0 0   0     0   2   3 10                 13
475633 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000221 705 BURLINGTON HS High School Regular School No High 09 12 2017   grade_10 6 0 3 0   0     0   0   5 4                       9 6 0 3 0   0     0   0   5 4                 9
475634 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000221 705 BURLINGTON HS High School Regular School No High 09 12 2017   grade_11 8 0 0 0   0     0   4   4 8                       12 8 0 0 0   0     0   4   4 8                 12
475635 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000221 705 BURLINGTON HS High School Regular School No High 09 12 2017   grade_12 10 0 1 0   0     0   0   8 3                       11 10 0 1 0   0     0   0   8 3                 11
475636 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000221 705 BURLINGTON HS High School Regular School No High 09 12 2017   grade_9 7 0 2 0   0     0   1   5 5                       10 7 0 2 0   0     0   1   5 5                 10
475639 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000296 105 CHEROKEE ES Elementary Regular School No Elementary PK 05 2017   grade_3 17 0 6 0   0     0   1   12 12                       24 17 0 6 0   0     0   1   12 12                 24
475640 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000296 105 CHEROKEE ES Elementary Regular School No Elementary PK 05 2017   grade_4 25 0 4 0   0     0   3   12 20                       32 25 0 4 0   0     0   3   12 20                 32
475641 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000296 105 CHEROKEE ES Elementary Regular School No Elementary PK 05 2017   grade_5 12 2 3 0   0     0   2   7 12                       19 12 2 3 0   0     0   2   7 12                 19
475644 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000296 105 CHEROKEE ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 5 0 0 0   0     0   0   2 3                       5 5 0 0 0   0     0   0   2 3                 5
475648 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000297 705 CHEROKEE HS High School Regular School No High 09 12 2017   grade_10 20 0 2 0   0     0   2   16 8                       24 20 0 2 0   0     0   2   16 8                 24
475650 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741000297 705 CHEROKEE HS High School Regular School No High 09 12 2017   grade_12 24 1 2 0   0     0   0   19 8                       27 24 1 2 0   0     0   0   19 8                 27
475657 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301028 105 TIMBERLAKE ES Elementary Regular School No Elementary PK 08 2017   grade_6 17 0 0 0   0     0   2   7 12                       19 17 0 0 0   0     0   2   7 12                 19
475658 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301028 105 TIMBERLAKE ES Elementary Regular School No Elementary PK 08 2017   grade_7 16 0 0 0   0     0   1   14 3                       17 16 0 0 0   0     0   1   14 3                 17
475663 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301101 705 TIMBERLAKE HS High School Regular School No High 09 12 2017   grade_11 12 0 0 0   0     0   1   9 4                       13 12 0 0 0   0     0   1   9 4                 13
475664 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301101 705 TIMBERLAKE HS High School Regular School No High 09 12 2017   grade_12 11 0 0 0   1     0   1   4 9                       13 11 0 0 0   1     0   1   4 9                 13
475743 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   grade_1 11 0 15 0   0     0   0   18 8                       26 11 0 15 0   0     0   0   18 8                 26
475745 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   grade_3 11 0 9 0   0     0   0   10 10                       20 11 0 9 0   0     0   0   10 10                 20
475746 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   grade_4 16 0 12 0   0     0   0   12 16                       28 16 0 12 0   0     0   0   12 16                 28
475747 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   grade_5 15 0 12 0   0     0   0   13 14                       27 15 0 12 0   0     0   0   13 14                 27
475748 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   grade_6 10 0 19 0   0     0   0   14 15                       29 10 0 19 0   0     0   0   14 15                 29
475750 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   grade_8 19 1 11 0   0     0   1   15 17                       32 19 1 11 0   0     0   1   15 17                 32
475751 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 30 1 7 0   0     0   0   22 16                       38 30 1 7 0   0     0   0   22 16                 38
475752 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_half_day 15 0 4 0   1     0   1   7 14                       21 15 0 4 0   1     0   1   7 14                 21
475753 OK BEAVER   school 4003750 04-I022   BEAVER 400375000116 705 BEAVER HS High School Regular School No High 09 12 2017   grade_10 8 0 10 0   0     0   0   9 9                       18 8 0 10 0   0     0   0   9 9                 18
475754 OK BEAVER   school 4003750 04-I022   BEAVER 400375000116 705 BEAVER HS High School Regular School No High 09 12 2017   grade_11 24 0 5 0   0     0   0   16 13                       29 24 0 5 0   0     0   0   16 13                 29
475756 OK BEAVER   school 4003750 04-I022   BEAVER 400375000116 705 BEAVER HS High School Regular School No High 09 12 2017   grade_9 18 0 8 0   0     0   0   13 13                       26 18 0 8 0   0     0   0   13 13                 26
475758 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   grade_2 9 0 0 0   0     0   0   4 5                       9 9 0 0 0   0     0   0   4 5                 9
475760 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   grade_4 6 0 1 0   0     0   0   6 1                       7 6 0 1 0   0     0   0   6 1                 7
475761 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   grade_5 13 0 1 0   0     0   0   9 5                       14 13 0 1 0   0     0   0   9 5                 14
475762 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   grade_6 15 0 1 0   0     0   0   8 8                       16 15 0 1 0   0     0   0   8 8                 16
475763 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 1 0   0     0   0   5 6                       11 10 0 1 0   0     0   0   5 6                 11
475764 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   grade_8 14 0 0 0   0     0   0   6 8                       14 14 0 0 0   0     0   0   6 8                 14
475765 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 12 1 1 0   0     0   0   8 6                       14 12 1 1 0   0     0   0   8 6                 14
475766 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 9 0 2 0   0     0   0   5 6                       11 9 0 2 0   0     0   0   5 6                 11
475767 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2017   grade_10 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
475768 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2017   grade_11 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
475769 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2017   grade_12 11 0 0 0   0     0   0   4 7                       11 11 0 0 0   0     0   0   4 7                 11
475770 OK BEAVER   school 4003510 04-I075   BALKO 400351000090 705 BALKO HS High School Regular School No High 09 12 2017   grade_9 14 1 1 0   0     0   0   5 11                       16 14 1 1 0   0     0   0   5 11                 16
475771 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_1 4 0 5 0   0     0   0   6 3                       9 4 0 5 0   0     0   0   6 3                 9
475772 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_2 6 0 3 0   0     0   0   5 4                       9 6 0 3 0   0     0   0   5 4                 9
475773 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_3 7 0 6 0   0     0   0   8 5                       13 7 0 6 0   0     0   0   8 5                 13
475774 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_4 9 0 4 0   0     0   0   8 5                       13 9 0 4 0   0     0   0   8 5                 13
475775 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_5 8 0 4 0   0     0   0   9 3                       12 8 0 4 0   0     0   0   9 3                 12
475776 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_6 10 0 1 0   0     0   0   4 7                       11 10 0 1 0   0     0   0   4 7                 11
475777 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 7 0   0     0   0   9 6                       15 8 0 7 0   0     0   0   9 6                 15
475778 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_8 8 0 5 0   0     0   0   4 9                       13 8 0 5 0   0     0   0   4 9                 13
475779 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 7 0 3 0   0     0   0   5 5                       10 7 0 3 0   0     0   0   5 5                 10
475780 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 4 0 5 0   0     0   0   4 5                       9 4 0 5 0   0     0   0   4 5                 9
475781 OK BEAVER   school 4011880 04-I123   FORGAN 401188000554 705 FORGAN HS High School Regular School No High 09 12 2017   grade_10 2 0 7 0   0     0   0   4 5                       9 2 0 7 0   0     0   0   4 5                 9
475782 OK BEAVER   school 4011880 04-I123   FORGAN 401188000554 705 FORGAN HS High School Regular School No High 09 12 2017   grade_11 10 0 5 0   0     0   1   10 6                       16 10 0 5 0   0     0   1   10 6                 16
475783 OK BEAVER   school 4011880 04-I123   FORGAN 401188000554 705 FORGAN HS High School Regular School No High 09 12 2017   grade_12 5 0 3 0   0     0   0   5 3                       8 5 0 3 0   0     0   0   5 3                 8
475784 OK BEAVER   school 4011880 04-I123   FORGAN 401188000554 705 FORGAN HS High School Regular School No High 09 12 2017   grade_9 6 0 2 0   0     0   0   7 1                       8 6 0 2 0   0     0   0   7 1                 8
475785 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_1 11 0 13 0   0     0   1   14 11                       25 11 0 13 0   0     0   1   14 11                 25
475786 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_2 18 0 17 0   0     0   1   14 22                       36 18 0 17 0   0     0   1   14 22                 36
475787 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_3 14 0 21 0   0     0   2   13 24                       37 14 0 21 0   0     0   2   13 24                 37
475788 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_4 20 0 20 0   0     0   0   20 20                       40 20 0 20 0   0     0   0   20 20                 40
475789 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_5 18 0 13 0   0     0   0   15 16                       31 18 0 13 0   0     0   0   15 16                 31
475790 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_6 15 1 15 0   0     0   0   19 12                       31 15 1 15 0   0     0   0   19 12                 31
475791 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 0 19 0   0     0   1   22 16                       38 18 0 19 0   0     0   1   22 16                 38
475792 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_8 11 0 14 0   0     0   0   13 12                       25 11 0 14 0   0     0   0   13 12                 25
475793 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 12 0 18 0   1     0   1   10 22                       32 12 0 18 0   1     0   1   10 22                 32
475794 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 8 0 20 0   0     0   1   19 10                       29 8 0 20 0   0     0   1   19 10                 29
475795 OK BEAVER   school 4030330 04-I128   TURPIN 403033001689 705 TURPIN HS High School Regular School No High 09 12 2017   grade_10 9 0 13 0   0     0   0   13 9                       22 9 0 13 0   0     0   0   13 9                 22
475796 OK BEAVER   school 4030330 04-I128   TURPIN 403033001689 705 TURPIN HS High School Regular School No High 09 12 2017   grade_11 17 0 11 0   0     0   1   17 12                       29 17 0 11 0   0     0   1   17 12                 29
475797 OK BEAVER   school 4030330 04-I128   TURPIN 403033001689 705 TURPIN HS High School Regular School No High 09 12 2017   grade_12 14 1 14 0   0     0   0   16 13                       29 14 1 14 0   0     0   0   16 13                 29
475798 OK BEAVER   school 4030330 04-I128   TURPIN 403033001689 705 TURPIN HS High School Regular School No High 09 12 2017   grade_9 12 0 16 0   0     0   0   11 17                       28 12 0 16 0   0     0   0   11 17                 28
475800 OK BECKHAM   school 4019800 05-I002   MERRITT 401980000940 105 MERRITT ES Elementary Regular School No Elementary PK 08 2017   grade_2 47 0 11 0   0     0   2   32 28                       60 47 0 11 0   0     0   2   32 28                 60
475816 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074001894 110 PIONEER ES Elementary Regular School No Elementary PK KG 2017   kindergarten_half_day 9 1 2 0   0     0   0   9 3                       12 9 1 2 0   0     0   0   9 3                 12
475817 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074001894 110 PIONEER ES Elementary Regular School No Elementary PK KG 2017   out_of_home_placement 2 0 0 0   0     0   0   2 0                       2 2 0 0 0   0     0   0   2 0                 2
475830 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000495 705 ELK CITY HS High School Regular School No Other 05 12 2017   grade_5 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
475831 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000495 705 ELK CITY HS High School Regular School No Other 05 12 2017   grade_9 5 0 0 0   0     0   0   4 1                       5 5 0 0 0   0     0   0   4 1                 5
475832 OK BECKHAM   school 4027060 05-I031   SAYRE 402706001431 105 SAYRE ES Elementary Regular School No Elementary PK 05 2017   grade_1 64 0 10 0   0     0   7   35 46                       81 64 0 10 0   0     0   7   35 46                 81
475833 OK BECKHAM   school 4027060 05-I031   SAYRE 402706001431 105 SAYRE ES Elementary Regular School No Elementary PK 05 2017   grade_2 37 0 6 0   0     0   2   25 20                       45 37 0 6 0   0     0   2   25 20                 45
475834 OK BECKHAM   school 4027060 05-I031   SAYRE 402706001431 105 SAYRE ES Elementary Regular School No Elementary PK 05 2017   grade_3 42 0 6 0   0     0   8   32 24                       56 42 0 6 0   0     0   8   32 24                 56
475839 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2017   grade_6 42 0 10 0   0     0   2   32 22                       54 42 0 10 0   0     0   2   32 22                 54
475842 OK BECKHAM   school 4027060 05-I031   SAYRE 402706001432 705 SAYRE HS High School Regular School No High 09 12 2017   grade_10 39 1 6 0   0     0   5   24 27                       51 39 1 6 0   0     0   5   24 27                 51
475843 OK BECKHAM   school 4027060 05-I031   SAYRE 402706001432 705 SAYRE HS High School Regular School No High 09 12 2017   grade_11 36 0 4 0   0     0   4   19 25                       44 36 0 4 0   0     0   4   19 25                 44
475846 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   grade_1 12 0 0 0   0     0   2   9 5                       14 12 0 0 0   0     0   2   9 5                 14
475847 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   grade_2 17 0 1 0   0     0   2   13 7                       20 17 0 1 0   0     0   2   13 7                 20
475848 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   grade_3 18 0 0 0   0     0   2   11 9                       20 18 0 0 0   0     0   2   11 9                 20
475849 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   grade_4 22 0 2 0   0     0   3   20 7                       27 22 0 2 0   0     0   3   20 7                 27
475850 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   grade_5 14 0 0 0   0     0   1   8 7                       15 14 0 0 0   0     0   1   8 7                 15
475852 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 4 0   1     0   2   8 10                       18 11 0 4 0   1     0   2   8 10                 18
475854 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 20 1 0 0   0     0   1   11 11                       22 20 1 0 0   0     0   1   11 11                 22
475855 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 20 1 0 0   0     0   0   12 9                       21 20 1 0 0   0     0   0   12 9                 21
475856 OK BECKHAM   school 4011040 05-I051   ERICK 401104029615 715 ERICK HS High School Regular School No High 09 12 2017   grade_10 14 0 0 0   0     0   2   10 6                       16 14 0 0 0   0     0   2   10 6                 16
475857 OK BECKHAM   school 4011040 05-I051   ERICK 401104029615 715 ERICK HS High School Regular School No High 09 12 2017   grade_11 13 0 2 0   1     0   1   6 11                       17 13 0 2 0   1     0   1   6 11                 17
475858 OK BECKHAM   school 4011040 05-I051   ERICK 401104029615 715 ERICK HS High School Regular School No High 09 12 2017   grade_12 14 0 1 0   0     0   1   7 9                       16 14 0 1 0   0     0   1   7 9                 16
475859 OK BECKHAM   school 4011040 05-I051   ERICK 401104029615 715 ERICK HS High School Regular School No High 09 12 2017   grade_9 11 0 1 0   0     0   2   10 4                       14 11 0 1 0   0     0   2   10 4                 14
475861 OK BLAINE   school 4022650 06-I009   OKEENE 402265001108 105 OKEENE ES Elementary Regular School No Elementary PK 06 2017   grade_2 20 0 5 0   0     0   0   14 11                       25 20 0 5 0   0     0   0   14 11                 25
475862 OK BLAINE   school 4022650 06-I009   OKEENE 402265001108 105 OKEENE ES Elementary Regular School No Elementary PK 06 2017   grade_3 22 1 7 0   0     0   0   19 11                       30 22 1 7 0   0     0   0   19 11                 30
475863 OK BLAINE   school 4022650 06-I009   OKEENE 402265001108 105 OKEENE ES Elementary Regular School No Elementary PK 06 2017   grade_4 17 0 6 0   0     0   0   13 10                       23 17 0 6 0   0     0   0   13 10                 23

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