Data source: Big Local News · About: Big Local

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

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
476435 OK CARTER   school 4003180 10-I019   ARDMORE 400318029631 120 JEFFERSON ES Elementary Regular School No Elementary 01 05 2017   grade_4 21 11 10 13   0     0   0   32 23                       55 21 11 10 13   0     0   0   32 23                 55
476436 OK CARTER   school 4003180 10-I019   ARDMORE 400318029631 120 JEFFERSON ES Elementary Regular School No Elementary 01 05 2017   grade_5 26 10 11 7   0     0   0   21 33                       54 26 10 11 7   0     0   0   21 33                 54
476437 OK CARTER   school 4003180 10-I019   ARDMORE 400318029631 120 JEFFERSON ES Elementary Regular School No Elementary 01 05 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
476448 OK CARTER   school 4003180 10-I019   ARDMORE 400318029637 705 ARDMORE HS High School Regular School No High 09 12 2017   grade_10 97 39 30 24   5     2   0   95 102                       197 97 39 30 24   5     2   0   95 102                 197
476492 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000871 705 LONE GROVE HS High School Regular School No High 09 12 2017   grade_11 80 2 1 19   0     0   0   47 55                       102 80 2 1 19   0     0   0   47 55                 102
476501 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 0 14   0     0   0   13 14                       27 13 0 0 14   0     0   0   13 14                 27
476508 OK CARTER   school 4032940 10-I043   WILSON 403294001816 705 WILSON HS High School Regular School No High 09 12 2017   grade_9 31 0 1 10   0     0   0   22 20                       42 31 0 1 10   0     0   0   22 20                 42
476530 OK CARTER   school 4012060 10-I074   FOX 401206000562 105 FOX ES Elementary Regular School No Elementary PK 08 2017   grade_8 14 2 1 4   0     0   0   13 8                       21 14 2 1 4   0     0   0   13 8                 21
476533 OK CARTER   school 4012060 10-I074   FOX 401206000563 705 FOX HS High School Regular School No High 09 12 2017   grade_10 9 1 0 2   0     0   0   6 6                       12 9 1 0 2   0     0   0   6 6                 12
476534 OK CARTER   school 4012060 10-I074   FOX 401206000563 705 FOX HS High School Regular School No High 09 12 2017   grade_11 19 1 1 4   0     0   0   13 12                       25 19 1 1 4   0     0   0   13 12                 25
476535 OK CARTER   school 4012060 10-I074   FOX 401206000563 705 FOX HS High School Regular School No High 09 12 2017   grade_12 12 1 1 1   0     0   0   8 7                       15 12 1 1 1   0     0   0   8 7                 15
476536 OK CARTER   school 4012060 10-I074   FOX 401206000563 705 FOX HS High School Regular School No High 09 12 2017   grade_9 26 2 0 4   0     0   0   22 10                       32 26 2 0 4   0     0   0   22 10                 32
476554 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_4 3 0 2 16   0     0   0   7 14                       21 3 0 2 16   0     0   0   7 14                 21
476555 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 1 0 0 13   0     0   0   11 3                       14 1 0 0 13   0     0   0   11 3                 14
476556 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 5 0 1 10   0     0   0   9 7                       16 5 0 1 10   0     0   0   9 7                 16
476558 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_8 0 0 0 6   0     0   0   3 3                       6 0 0 0 6   0     0   0   3 3                 6
476559 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 4 0 1 13   0     0   0   8 10                       18 4 0 1 13   0     0   0   8 10                 18
476560 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 3 1 2 7   0     0   0   8 5                       13 3 1 2 7   0     0   0   8 5                 13
476581 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_1 4 0 2 12   0     0   0   8 10                       18 4 0 2 12   0     0   0   8 10                 18
476582 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_2 6 0 1 12   0     0   0   11 8                       19 6 0 1 12   0     0   0   11 8                 19
476583 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_3 4 0 3 16   0     0   0   15 8                       23 4 0 3 16   0     0   0   15 8                 23
476584 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_4 4 0 2 12   0     0   0   5 13                       18 4 0 2 12   0     0   0   5 13                 18
476585 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 3 0 2 13   1     0   0   6 13                       19 3 0 2 13   1     0   0   6 13                 19
476586 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 3 1 0 6   0     0   0   4 6                       10 3 1 0 6   0     0   0   4 6                 10
476587 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 2 0 1 5   0     0   0   6 2                       8 2 0 1 5   0     0   0   6 2                 8
476588 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_8 1 0 1 12   0     0   0   9 5                       14 1 0 1 12   0     0   0   9 5                 14
476589 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 2 0 0 11   0     0   0   6 7                       13 2 0 0 11   0     0   0   6 7                 13
476590 OK CHEROKEE   school 4027420 11-C026   SHADY GROVE 402742001448 105 SHADY GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 1 0 0 15   0     0   0   9 7                       16 1 0 0 15   0     0   0   9 7                 16
476591 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_1 3 0 1 17   0     0   0   11 10                       21 3 0 1 17   0     0   0   11 10                 21
476592 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_2 8 0 0 20   0     0   0   13 15                       28 8 0 0 20   0     0   0   13 15                 28
476593 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_3 5 0 0 19   0     0   0   14 10                       24 5 0 0 19   0     0   0   14 10                 24
476594 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_4 7 0 1 24   0     0   0   12 20                       32 7 0 1 24   0     0   0   12 20                 32
476595 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 4 0 1 17   0     0   0   7 15                       22 4 0 1 17   0     0   0   7 15                 22
476596 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 3 0 1 20   0     0   0   15 9                       24 3 0 1 20   0     0   0   15 9                 24
476597 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 19   0     0   0   12 10                       22 3 0 0 19   0     0   0   12 10                 22
476599 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 4 0 0 18   0     0   0   11 11                       22 4 0 0 18   0     0   0   11 11                 22
476600 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   out_of_home_placement 0 0 0 2   0     0   0   1 1                       2 0 0 0 2   0     0   0   1 1                 2
476601 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 1 0 0 9   0     0   0   8 2                       10 1 0 0 9   0     0   0   8 2                 10
476610 OK CHEROKEE   school 4013230 11-C034   GRAND VIEW 401323000614 105 GRAND VIEW PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 10 1 4 47   0     0   0   28 34                       62 10 1 4 47   0     0   0   28 34                 62
476622 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_1 4 1 0 18   0     0   0   11 12                       23 4 1 0 18   0     0   0   11 12                 23
476623 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_2 4 1 1 33   0     0   0   17 22                       39 4 1 1 33   0     0   0   17 22                 39
476624 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_3 3 0 0 15   0     0   0   14 4                       18 3 0 0 15   0     0   0   14 4                 18
476625 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_4 13 1 0 21   0     0   0   19 16                       35 13 1 0 21   0     0   0   19 16                 35
476626 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 4 0 1 21   0     0   0   17 9                       26 4 0 1 21   0     0   0   17 9                 26
476627 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 4 0 0 21   0     0   0   11 14                       25 4 0 0 21   0     0   0   11 14                 25
476628 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 20   0     0   0   15 13                       28 8 0 0 20   0     0   0   15 13                 28
476629 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_8 2 0 0 21   0     0   0   11 12                       23 2 0 0 21   0     0   0   11 12                 23
476631 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 8 0 1 15   0     0   0   12 12                       24 8 0 1 15   0     0   0   12 12                 24
476633 OK CHEROKEE   school 4000033 11-I006   KEYS 400003302299 105 KEYS ES Elementary Regular School No Elementary PK 08 2017   grade_2 11 1 0 23   0     0   0   14 21                       35 11 1 0 23   0     0   0   14 21                 35
476653 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 615 HULBERT JR-SR HS (JR) Junior High Regular School No Middle 06 08 2017   grade_6 10 0 1 25   0     0   0   13 23                       36 10 0 1 25   0     0   0   13 23                 36
476654 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 615 HULBERT JR-SR HS (JR) Junior High Regular School No Middle 06 08 2017   grade_7 7 0 8 20   0     0   0   21 14                       35 7 0 8 20   0     0   0   21 14                 35
476657 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524029639 715 HULBERT JR-SR HS (SR) High School Regular School No High 09 12 2017   grade_11 12 0 1 27   0     0   0   20 20                       40 12 0 1 27   0     0   0   20 20                 40
476667 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001541 210 CHEROKEE ES Elementary Regular School No Elementary KG 05 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
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
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
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
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
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
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
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
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
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
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]);