Data source: Big Local News · About: Big Local

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

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
476675 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002727 225 HERITAGE ES Elementary Regular School No Elementary KG 05 2017   grade_2 19 0 11 25   1     0   20   41 35                       76 19 0 11 25   1     0   20   41 35                 76
476676 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002727 225 HERITAGE ES Elementary Regular School No Elementary KG 05 2017   grade_3 21 0 18 37   1     0   13   45 45                       90 21 0 18 37   1     0   13   45 45                 90
476677 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002727 225 HERITAGE ES Elementary Regular School No Elementary KG 05 2017   grade_4 20 0 22 34   0     0   13   53 36                       89 20 0 22 34   0     0   13   53 36                 89
476678 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002727 225 HERITAGE ES Elementary Regular School No Elementary KG 05 2017   grade_5 22 0 14 29   0     0   13   37 41                       78 22 0 14 29   0     0   13   37 41                 78
476679 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002727 225 HERITAGE ES Elementary Regular School No Elementary KG 05 2017   kindergarten_full_day 24 2 18 32   0     0   23   47 52                       99 24 2 18 32   0     0   23   47 52                 99
476680 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2017   grade_6 52 3 43 109   2     0   18   117 110                       227 52 3 43 109   2     0   18   117 110                 227
476681 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2017   grade_7 53 5 35 100   3     0   25   107 114                       221 53 5 35 100   3     0   25   107 114                 221
476682 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2017   grade_8 56 2 40 93   4     0   23   119 99                       218 56 2 40 93   4     0   23   119 99                 218
476683 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2017   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
476684 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001544 705 TAHLEQUAH HS High School Regular School No High 09 12 2017   grade_10 72 7 51 142   0     1   25   150 148                       298 72 7 51 142   0     1   25   150 148                 298
476685 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001544 705 TAHLEQUAH HS High School Regular School No High 09 12 2017   grade_11 83 3 47 133   1     0   28   154 141                       295 83 3 47 133   1     0   28   154 141                 295
476686 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001544 705 TAHLEQUAH HS High School Regular School No High 09 12 2017   grade_12 75 3 31 106   3     0   30   138 110                       248 75 3 31 106   3     0   30   138 110                 248
476687 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001544 705 TAHLEQUAH HS High School Regular School No High 09 12 2017   grade_9 89 6 52 164   2     0   58   194 177                       371 89 6 52 164   2     0   58   194 177                 371
476688 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001544 705 TAHLEQUAH HS High School Regular School No High 09 12 2017   out_of_home_placement 1 0 1 3   0     0   1   2 4                       6 1 0 1 3   0     0   1   2 4                 6
476689 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_1 0 0 0 10   0     0   0   5 5                       10 0 0 0 10   0     0   0   5 5                 10
476690 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_2 0 0 0 6   0     0   0   4 2                       6 0 0 0 6   0     0   0   4 2                 6
476691 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_3 0 0 0 7   0     0   0   5 2                       7 0 0 0 7   0     0   0   5 2                 7
476692 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_4 0 0 0 8   0     0   0   3 5                       8 0 0 0 8   0     0   0   3 5                 8
476693 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_5 0 0 0 8   0     0   0   3 5                       8 0 0 0 8   0     0   0   3 5                 8
476694 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_6 0 0 0 7   0     0   0   6 1                       7 0 0 0 7   0     0   0   6 1                 7
476695 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_7 0 0 0 20   0     0   1   9 12                       21 0 0 0 20   0     0   1   9 12                 21
476696 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_8 0 0 0 19   0     0   1   14 6                       20 0 0 0 19   0     0   1   14 6                 20
476697 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   kindergarten_full_day 0 0 0 8   0     0   0   4 4                       8 0 0 0 8   0     0   0   4 4                 8
476698 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   pre_kindergarten_full_day 0 0 0 11   0     0   0   4 7                       11 0 0 0 11   0     0   0   4 7                 11
476699 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_1 9 0 0 6   0     0   0   9 6                       15 9 0 0 6   0     0   0   9 6                 15
476700 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_2 11 0 0 6   0     0   0   8 9                       17 11 0 0 6   0     0   0   8 9                 17
476701 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_3 11 0 0 4   0     0   0   7 8                       15 11 0 0 4   0     0   0   7 8                 15
476702 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_4 7 1 0 4   0     0   0   4 8                       12 7 1 0 4   0     0   0   4 8                 12
476703 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 4 1 0 7   0     0   0   6 6                       12 4 1 0 7   0     0   0   6 6                 12
476704 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 5 0 0 4   0     0   0   3 6                       9 5 0 0 4   0     0   0   3 6                 9
476705 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 2   0     0   0   5 5                       10 8 0 0 2   0     0   0   5 5                 10
476706 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_8 10 1 1 4   0     0   0   6 10                       16 10 1 1 4   0     0   0   6 10                 16
476707 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 7 1 0 5   0     0   2   9 6                       15 7 1 0 5   0     0   2   9 6                 15
476708 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 10 0 1 9   0     0   1   11 10                       21 10 0 1 9   0     0   1   11 10                 21
476709 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504000177 105 BOSWELL ES Elementary Regular School No Elementary PK 06 2017   grade_1 12 6 4 13   0     0   2   20 17                       37 12 6 4 13   0     0   2   20 17                 37
476710 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504000177 105 BOSWELL ES Elementary Regular School No Elementary PK 06 2017   grade_2 14 5 4 9   0     0   3   11 24                       35 14 5 4 9   0     0   3   11 24                 35
476711 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504000177 105 BOSWELL ES Elementary Regular School No Elementary PK 06 2017   grade_3 10 3 4 8   0     0   0   14 11                       25 10 3 4 8   0     0   0   14 11                 25
476712 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504000177 105 BOSWELL ES Elementary Regular School No Elementary PK 06 2017   grade_4 15 1 3 9   0     0   2   18 12                       30 15 1 3 9   0     0   2   18 12                 30
476713 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504000177 105 BOSWELL ES Elementary Regular School No Elementary PK 06 2017   grade_5 11 1 1 9   0     0   3   14 11                       25 11 1 1 9   0     0   3   14 11                 25
476714 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504000177 105 BOSWELL ES Elementary Regular School No Elementary PK 06 2017   grade_6 12 1 2 10   0     0   5   19 11                       30 12 1 2 10   0     0   5   19 11                 30
476715 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504000177 105 BOSWELL ES Elementary Regular School No Elementary PK 06 2017   kindergarten_full_day 14 0 0 11   0     0   4   11 18                       29 14 0 0 11   0     0   4   11 18                 29
476716 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504000177 105 BOSWELL ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 10 4 2 8   0     0   0   14 10                       24 10 4 2 8   0     0   0   14 10                 24
476717 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2017   grade_7 9 1 4 8   0     0   0   8 14                       22 9 1 4 8   0     0   0   8 14                 22
476718 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2017   grade_8 8 0 5 13   0     0   0   12 14                       26 8 0 5 13   0     0   0   12 14                 26
476719 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504029640 715 BOSWELL HS High School Regular School No High 09 12 2017   grade_10 12 2 0 6   0     0   0   11 9                       20 12 2 0 6   0     0   0   11 9                 20
476720 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504029640 715 BOSWELL HS High School Regular School No High 09 12 2017   grade_11 5 0 1 5   0     0   0   7 4                       11 5 0 1 5   0     0   0   7 4                 11
476721 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504029640 715 BOSWELL HS High School Regular School No High 09 12 2017   grade_12 12 1 0 9   0     0   0   9 13                       22 12 1 0 9   0     0   0   9 13                 22
476722 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504029640 715 BOSWELL HS High School Regular School No High 09 12 2017   grade_9 10 3 1 12   0     0   0   15 11                       26 10 3 1 12   0     0   0   15 11                 26
476723 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000577 105 FORT TOWSON ES Elementary Regular School No Elementary PK 06 2017   grade_1 10 0 1 4   0     0   2   7 10                       17 10 0 1 4   0     0   2   7 10                 17
476724 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000577 105 FORT TOWSON ES Elementary Regular School No Elementary PK 06 2017   grade_2 11 0 0 5   0     0   3   7 12                       19 11 0 0 5   0     0   3   7 12                 19
476725 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000577 105 FORT TOWSON ES Elementary Regular School No Elementary PK 06 2017   grade_3 14 0 0 5   0     0   1   12 8                       20 14 0 0 5   0     0   1   12 8                 20
476726 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000577 105 FORT TOWSON ES Elementary Regular School No Elementary PK 06 2017   grade_4 18 0 0 6   0     0   1   15 10                       25 18 0 0 6   0     0   1   15 10                 25
476727 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000577 105 FORT TOWSON ES Elementary Regular School No Elementary PK 06 2017   grade_5 20 1 1 5   0     0   2   17 12                       29 20 1 1 5   0     0   2   17 12                 29
476728 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000577 105 FORT TOWSON ES Elementary Regular School No Elementary PK 06 2017   grade_6 14 1 0 6   0     0   2   7 16                       23 14 1 0 6   0     0   2   7 16                 23
476729 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000577 105 FORT TOWSON ES Elementary Regular School No Elementary PK 06 2017   kindergarten_full_day 11 0 0 7   0     0   1   11 8                       19 11 0 0 7   0     0   1   11 8                 19
476730 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000577 105 FORT TOWSON ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 10 0 2 5   0     0   1   12 6                       18 10 0 2 5   0     0   1   12 6                 18
476731 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230002790 605 FORT TOWSON JHS Junior High Regular School No Middle 07 08 2017   grade_7 22 1 0 10   0     0   6   13 26                       39 22 1 0 10   0     0   6   13 26                 39
476732 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230002790 605 FORT TOWSON JHS Junior High Regular School No Middle 07 08 2017   grade_8 19 1 0 2   0     0   5   12 15                       27 19 1 0 2   0     0   5   12 15                 27
476733 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000578 705 FORT TOWSON HS High School Regular School No High 09 12 2017   grade_10 30 0 1 12   0     0   3   15 31                       46 30 0 1 12   0     0   3   15 31                 46
476734 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000578 705 FORT TOWSON HS High School Regular School No High 09 12 2017   grade_11 20 1 2 7   0     0   2   13 19                       32 20 1 2 7   0     0   2   13 19                 32
476735 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000578 705 FORT TOWSON HS High School Regular School No High 09 12 2017   grade_12 29 1 1 15   0     0   0   23 23                       46 29 1 1 15   0     0   0   23 23                 46
476736 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230000578 705 FORT TOWSON HS High School Regular School No High 09 12 2017   grade_9 24 1 1 8   0     0   3   20 17                       37 24 1 1 8   0     0   3   20 17                 37
476737 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_1 16 0 0 14   0     0   0   15 15                       30 16 0 0 14   0     0   0   15 15                 30
476738 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_2 11 0 0 13   0     0   0   11 13                       24 11 0 0 13   0     0   0   11 13                 24
476739 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_3 11 1 1 13   0     0   0   14 12                       26 11 1 1 13   0     0   0   14 12                 26
476740 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_4 9 0 2 8   0     0   0   8 11                       19 9 0 2 8   0     0   0   8 11                 19
476741 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_5 9 0 0 10   1     0   0   9 11                       20 9 0 0 10   1     0   0   9 11                 20
476742 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_6 10 0 1 15   0     0   0   15 11                       26 10 0 1 15   0     0   0   15 11                 26
476743 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 0 9   0     0   1   11 13                       24 14 0 0 9   0     0   1   11 13                 24
476744 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_8 12 0 2 16   1     0   0   16 15                       31 12 0 2 16   1     0   0   16 15                 31
476745 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 15 1 0 12   0     0   0   14 14                       28 15 1 0 12   0     0   0   14 14                 28
476746 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 13 0 1 9   0     0   0   10 13                       23 13 0 1 9   0     0   0   10 13                 23
476747 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001485 705 SOPER HS High School Regular School No High 09 12 2017   grade_10 18 1 0 19   0     0   0   18 20                       38 18 1 0 19   0     0   0   18 20                 38
476748 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001485 705 SOPER HS High School Regular School No High 09 12 2017   grade_11 19 0 3 17   0     0   0   16 23                       39 19 0 3 17   0     0   0   16 23                 39
476749 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001485 705 SOPER HS High School Regular School No High 09 12 2017   grade_12 13 0 0 16   0     0   0   12 17                       29 13 0 0 16   0     0   0   12 17                 29
476750 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001485 705 SOPER HS High School Regular School No High 09 12 2017   grade_9 13 1 1 12   0     0   0   10 17                       27 13 1 1 12   0     0   0   10 17                 27
476751 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002768 135 HUGO ES Elementary Regular School No Elementary PK 03 2017   grade_1 28 21 7 44   0     0   4   60 44                       104 28 21 7 44   0     0   4   60 44                 104
476752 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002768 135 HUGO ES Elementary Regular School No Elementary PK 03 2017   grade_2 37 22 3 33   0     0   6   52 49                       101 37 22 3 33   0     0   6   52 49                 101
476753 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002768 135 HUGO ES Elementary Regular School No Elementary PK 03 2017   grade_3 21 30 5 30   0     0   10   56 40                       96 21 30 5 30   0     0   10   56 40                 96
476754 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002768 135 HUGO ES Elementary Regular School No Elementary PK 03 2017   kindergarten_full_day 41 32 7 31   0     0   3   74 40                       114 41 32 7 31   0     0   3   74 40                 114
476755 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002768 135 HUGO ES Elementary Regular School No Elementary PK 03 2017   pre_kindergarten_full_day 21 16 3 27   1     0   7   46 29                       75 21 16 3 27   1     0   7   46 29                 75
476756 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002774 140 HUGO INTERMEDIATE Elementary Regular School No Elementary 04 05 2017   grade_4 31 24 7 21   1     0   10   35 59                       94 31 24 7 21   1     0   10   35 59                 94
476757 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002774 140 HUGO INTERMEDIATE Elementary Regular School No Elementary 04 05 2017   grade_5 40 28 4 17   1     0   6   48 48                       96 40 28 4 17   1     0   6   48 48                 96
476758 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2017   grade_6 29 32 4 23   0     0   1   54 35                       89 29 32 4 23   0     0   1   54 35                 89
476759 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2017   grade_7 24 23 4 20   0     0   6   36 41                       77 24 23 4 20   0     0   6   36 41                 77
476760 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2017   grade_8 33 26 2 25   0     1   3   48 42                       90 33 26 2 25   0     1   3   48 42                 90
476761 OK CHOCTAW   school 4015210 12-I039   HUGO 401521000713 705 HUGO HS High School Regular School No High 09 12 2017   grade_10 26 25 7 27   1     0   4   53 37                       90 26 25 7 27   1     0   4   53 37                 90
476762 OK CHOCTAW   school 4015210 12-I039   HUGO 401521000713 705 HUGO HS High School Regular School No High 09 12 2017   grade_11 24 15 2 17   0     0   7   34 31                       65 24 15 2 17   0     0   7   34 31                 65
476763 OK CHOCTAW   school 4015210 12-I039   HUGO 401521000713 705 HUGO HS High School Regular School No High 09 12 2017   grade_12 24 21 3 16   1     0   3   34 34                       68 24 21 3 16   1     0   3   34 34                 68
476764 OK CHOCTAW   school 4015210 12-I039   HUGO 401521000713 705 HUGO HS High School Regular School No High 09 12 2017   grade_9 21 30 4 22   1     0   1   45 34                       79 21 30 4 22   1     0   1   45 34                 79
476765 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   grade_1 14 0 7 0   0     0   0   10 11                       21 14 0 7 0   0     0   0   10 11                 21
476766 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   grade_2 15 0 12 1   0     0   0   15 13                       28 15 0 12 1   0     0   0   15 13                 28
476767 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   grade_3 9 0 11 0   0     0   1   15 6                       21 9 0 11 0   0     0   1   15 6                 21
476768 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   grade_4 11 0 12 0   0     0   2   9 16                       25 11 0 12 0   0     0   2   9 16                 25
476769 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   grade_5 6 0 7 0   0     0   0   8 5                       13 6 0 7 0   0     0   0   8 5                 13
476770 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   grade_6 9 0 8 0   0     0   0   10 7                       17 9 0 8 0   0     0   0   10 7                 17
476771 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   kindergarten_full_day 6 0 12 1   0     0   0   12 7                       19 6 0 12 1   0     0   0   12 7                 19
476772 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   out_of_home_placement 0 0 1 0   0     0   0   0 1                       1 0 0 1 0   0     0   0   0 1                 1
476773 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486000166 105 BOISE CITY ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_full_day 6 0 13 0   0     0   0   9 10                       19 6 0 13 0   0     0   0   9 10                 19
476774 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2017   grade_7 6 0 7 0   0     0   0   5 8                       13 6 0 7 0   0     0   0   5 8                 13

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