Data source: Big Local News · About: Big Local

11,826 rows where state = "OK" and year = 2017 sorted by school descending

View and edit SQL

year

  • 2017 · 11,826
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
475537 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_1 10 0 0 41   0     0   0   32 19                       51 10 0 0 41   0     0   0   32 19                 51
475538 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_2 2 0 0 30   0     0   0   18 14                       32 2 0 0 30   0     0   0   18 14                 32
475539 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_3 2 0 0 31   0     0   0   14 19                       33 2 0 0 31   0     0   0   14 19                 33
475540 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_4 3 0 0 30   0     0   0   19 14                       33 3 0 0 30   0     0   0   19 14                 33
475541 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 3 0 0 26   0     0   0   16 13                       29 3 0 0 26   0     0   0   16 13                 29
475542 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 7 0 0 30   0     0   0   20 17                       37 7 0 0 30   0     0   0   20 17                 37
475543 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 22   0     0   0   15 10                       25 3 0 0 22   0     0   0   15 10                 25
475544 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_8 6 0 0 24   0     0   0   12 18                       30 6 0 0 24   0     0   0   12 18                 30
475545 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 4 0 0 26   0     0   0   14 16                       30 4 0 0 26   0     0   0   14 16                 30
475546 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 4 0 0 32   0     0   0   19 17                       36 4 0 0 32   0     0   0   19 17                 36
485568 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   k_12_total 40 0 0 260   0     0   0   160 140                       300 40 0 0 260   0     0   0   160 140                 300
476417 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_1 16 2 3 0   0     0   13   16 18                       34 16 2 3 0   0     0   13   16 18                 34
476418 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_2 16 0 2 4   0     0   11   16 17                       33 16 0 2 4   0     0   11   16 17                 33
476419 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_3 16 0 2 3   0     0   16   17 20                       37 16 0 2 3   0     0   16   17 20                 37
476420 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_4 9 0 3 4   0     0   10   14 12                       26 9 0 3 4   0     0   10   14 12                 26
476421 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_5 11 0 3 3   0     0   7   10 14                       24 11 0 3 3   0     0   7   10 14                 24
476422 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_6 10 0 2 3   0     0   10   17 8                       25 10 0 2 3   0     0   10   17 8                 25
476423 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 6 3   0     0   8   14 13                       27 10 0 6 3   0     0   8   14 13                 27
476424 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_8 7 0 1 2   0     0   8   4 14                       18 7 0 1 2   0     0   8   4 14                 18
476425 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 24 1 3 2   0     0   6   21 15                       36 24 1 3 2   0     0   6   21 15                 36
476426 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 24 0 1 1   0     0   6   18 14                       32 24 0 1 1   0     0   6   18 14                 32
485728 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   k_12_total 119 3 25 24   0     0   89   129 131                       260 119 3 25 24   0     0   89   129 131                 260
476312 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2017   grade_6 457 22 88 42   19     0   22   339 311                       650 457 22 88 42   19     0   22   339 311                 650
476313 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2017   grade_7 437 22 95 30   19     1   37   306 335                       641 437 22 95 30   19     1   37   306 335                 641
476314 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2017   grade_8 435 25 61 26   16     3   13   277 302                       579 435 25 61 26   16     3   13   277 302                 579
485704 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2017   k_12_total 1329 69 244 98   54     4   72   922 948                       1870 1329 69 244 98   54     4   72   922 948                 1870
476315 OK CANADIAN   school 4033480 09-I027   YUKON 403348001849 705 YUKON HS High School Regular School No High 09 12 2017   grade_10 496 25 75 32   9     1   19   316 341                       657 496 25 75 32   9     1   19   316 341                 657
476316 OK CANADIAN   school 4033480 09-I027   YUKON 403348001849 705 YUKON HS High School Regular School No High 09 12 2017   grade_11 447 23 69 24   15     4   15   301 296                       597 447 23 69 24   15     4   15   301 296                 597
476317 OK CANADIAN   school 4033480 09-I027   YUKON 403348001849 705 YUKON HS High School Regular School No High 09 12 2017   grade_12 419 24 48 34   14     2   19   263 297                       560 419 24 48 34   14     2   19   263 297                 560
476318 OK CANADIAN   school 4033480 09-I027   YUKON 403348001849 705 YUKON HS High School Regular School No High 09 12 2017   grade_9 487 32 82 41   20     0   17   338 341                       679 487 32 82 41   20     0   17   338 341                 679
485705 OK CANADIAN   school 4033480 09-I027   YUKON 403348001849 705 YUKON HS High School Regular School No High 09 12 2017   k_12_total 1849 104 274 131   58     7   70   1218 1275                       2493 1849 104 274 131   58     7   70   1218 1275                 2493
484065 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339029762 705 YARBROUGH HS High School Regular School No High 09 12 2017   grade_10 4 0 5 1   0     0   0   4 6                       10 4 0 5 1   0     0   0   4 6                 10
484066 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339029762 705 YARBROUGH HS High School Regular School No High 09 12 2017   grade_11 1 0 3 0   0     0   0   2 2                       4 1 0 3 0   0     0   0   2 2                 4
484067 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339029762 705 YARBROUGH HS High School Regular School No High 09 12 2017   grade_12 4 0 5 1   0     0   0   8 2                       10 4 0 5 1   0     0   0   8 2                 10
484068 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339029762 705 YARBROUGH HS High School Regular School No High 09 12 2017   grade_9 2 0 2 0   0     0   0   2 2                       4 2 0 2 0   0     0   0   2 2                 4
487057 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339029762 705 YARBROUGH HS High School Regular School No High 09 12 2017   k_12_total 11 0 15 2   0     0   0   16 12                       28 11 0 15 2   0     0   0   16 12                 28
484055 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   grade_1 8 0 2 0   0     0   0   6 4                       10 8 0 2 0   0     0   0   6 4                 10
484056 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   grade_2 3 0 3 0   0     0   0   3 3                       6 3 0 3 0   0     0   0   3 3                 6
484057 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   grade_3 6 0 5 1   0     0   0   7 5                       12 6 0 5 1   0     0   0   7 5                 12
484058 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   grade_4 4 0 4 0   0     0   0   6 2                       8 4 0 4 0   0     0   0   6 2                 8
484059 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   grade_5 4 1 2 0   0     0   0   3 4                       7 4 1 2 0   0     0   0   3 4                 7
484060 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   grade_6 5 0 0 0   0     0   0   1 4                       5 5 0 0 0   0     0   0   1 4                 5
484061 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 2 0   0     0   0   3 5                       8 6 0 2 0   0     0   0   3 5                 8
484062 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   grade_8 3 0 3 0   0     0   0   4 2                       6 3 0 3 0   0     0   0   4 2                 6
484063 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 3 0 2 0   0     0   0   1 4                       5 3 0 2 0   0     0   0   1 4                 5
484064 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 4 0 6 0   0     0   0   5 5                       10 4 0 6 0   0     0   0   5 5                 10
487056 OK TEXAS   school 4033390 70-I001   YARBROUGH 403339001840 105 YARBROUGH ES Elementary Regular School No Elementary PK 08 2017   k_12_total 42 1 23 1   0     0   0   34 33                       67 42 1 23 1   0     0   0   34 33                 67
482768 OK PAYNE   school 4033360 60-I103   YALE 403336001839 505 YALE MS Middle Regular School No Middle 06 08 2017   grade_6 18 1 0 10   0     0   2   20 11                       31 18 1 0 10   0     0   2   20 11                 31
482769 OK PAYNE   school 4033360 60-I103   YALE 403336001839 505 YALE MS Middle Regular School No Middle 06 08 2017   grade_7 17 1 1 8   0     0   2   13 16                       29 17 1 1 8   0     0   2   13 16                 29
482770 OK PAYNE   school 4033360 60-I103   YALE 403336001839 505 YALE MS Middle Regular School No Middle 06 08 2017   grade_8 17 1 0 8   0     0   1   17 10                       27 17 1 0 8   0     0   1   17 10                 27
486834 OK PAYNE   school 4033360 60-I103   YALE 403336001839 505 YALE MS Middle Regular School No Middle 06 08 2017   k_12_total 52 3 1 26   0     0   5   50 37                       87 52 3 1 26   0     0   5   50 37                 87
482771 OK PAYNE   school 4033360 60-I103   YALE 403336029743 715 YALE HS High School Regular School No High 09 12 2017   grade_10 24 0 1 11   0     0   6   22 20                       42 24 0 1 11   0     0   6   22 20                 42
482772 OK PAYNE   school 4033360 60-I103   YALE 403336029743 715 YALE HS High School Regular School No High 09 12 2017   grade_11 16 0 3 19   0     0   1   23 16                       39 16 0 3 19   0     0   1   23 16                 39
482773 OK PAYNE   school 4033360 60-I103   YALE 403336029743 715 YALE HS High School Regular School No High 09 12 2017   grade_12 24 0 2 20   0     0   4   33 17                       50 24 0 2 20   0     0   4   33 17                 50
482774 OK PAYNE   school 4033360 60-I103   YALE 403336029743 715 YALE HS High School Regular School No High 09 12 2017   grade_9 18 0 0 14   0     0   0   16 16                       32 18 0 0 14   0     0   0   16 16                 32
486835 OK PAYNE   school 4033360 60-I103   YALE 403336029743 715 YALE HS High School Regular School No High 09 12 2017   k_12_total 82 0 6 64   0     0   11   94 69                       163 82 0 6 64   0     0   11   94 69                 163
482761 OK PAYNE   school 4033360 60-I103   YALE 403336001838 105 YALE ES Elementary Regular School No Elementary PK 05 2017   grade_1 17 0 2 3   0     0   6   16 12                       28 17 0 2 3   0     0   6   16 12                 28
482762 OK PAYNE   school 4033360 60-I103   YALE 403336001838 105 YALE ES Elementary Regular School No Elementary PK 05 2017   grade_2 27 0 1 3   0     0   4   20 15                       35 27 0 1 3   0     0   4   20 15                 35
482763 OK PAYNE   school 4033360 60-I103   YALE 403336001838 105 YALE ES Elementary Regular School No Elementary PK 05 2017   grade_3 18 0 1 3   0     0   5   18 9                       27 18 0 1 3   0     0   5   18 9                 27
482764 OK PAYNE   school 4033360 60-I103   YALE 403336001838 105 YALE ES Elementary Regular School No Elementary PK 05 2017   grade_4 11 0 2 6   0     0   2   12 9                       21 11 0 2 6   0     0   2   12 9                 21
482765 OK PAYNE   school 4033360 60-I103   YALE 403336001838 105 YALE ES Elementary Regular School No Elementary PK 05 2017   grade_5 20 0 2 7   0     0   1   9 21                       30 20 0 2 7   0     0   1   9 21                 30
482766 OK PAYNE   school 4033360 60-I103   YALE 403336001838 105 YALE ES Elementary Regular School No Elementary PK 05 2017   kindergarten_full_day 15 0 0 2   0     0   5   12 10                       22 15 0 0 2   0     0   5   12 10                 22
482767 OK PAYNE   school 4033360 60-I103   YALE 403336001838 105 YALE ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_full_day 16 0 1 0   0     0   4   11 10                       21 16 0 1 0   0     0   4   11 10                 21
486833 OK PAYNE   school 4033360 60-I103   YALE 403336001838 105 YALE ES Elementary Regular School No Elementary PK 05 2017   k_12_total 108 0 8 24   0     0   23   87 76                       163 108 0 8 24   0     0   23   87 76                 163
482445 OK OSAGE   school 4033330 57-I030   WYNONA 403333001837 705 WYNONA HS High School Regular School No High 09 12 2017   grade_10 7 0 0 6   0     0   0   5 8                       13 7 0 0 6   0     0   0   5 8                 13
482446 OK OSAGE   school 4033330 57-I030   WYNONA 403333001837 705 WYNONA HS High School Regular School No High 09 12 2017   grade_11 2 0 0 2   0     0   0   2 2                       4 2 0 0 2   0     0   0   2 2                 4
482447 OK OSAGE   school 4033330 57-I030   WYNONA 403333001837 705 WYNONA HS High School Regular School No High 09 12 2017   grade_12 9 0 0 4   0     0   0   8 5                       13 9 0 0 4   0     0   0   8 5                 13
482448 OK OSAGE   school 4033330 57-I030   WYNONA 403333001837 705 WYNONA HS High School Regular School No High 09 12 2017   grade_9 5 0 0 3   0     0   0   6 2                       8 5 0 0 3   0     0   0   6 2                 8
486771 OK OSAGE   school 4033330 57-I030   WYNONA 403333001837 705 WYNONA HS High School Regular School No High 09 12 2017   k_12_total 23 0 0 15   0     0   0   21 17                       38 23 0 0 15   0     0   0   21 17                 38
482435 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   grade_1 7 1 0 1   0     0   0   6 3                       9 7 1 0 1   0     0   0   6 3                 9
482436 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   grade_2 5 1 0 4   0     0   0   3 7                       10 5 1 0 4   0     0   0   3 7                 10
482437 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   grade_3 3 0 0 1   0     0   0   3 1                       4 3 0 0 1   0     0   0   3 1                 4
482438 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   grade_4 8 0 0 1   0     0   0   3 6                       9 8 0 0 1   0     0   0   3 6                 9
482439 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   grade_5 3 0 0 2   0     0   0   2 3                       5 3 0 0 2   0     0   0   2 3                 5
482440 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   grade_6 7 0 0 2   0     0   0   4 5                       9 7 0 0 2   0     0   0   4 5                 9
482441 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   grade_7 7 0 0 1   0     0   0   5 3                       8 7 0 0 1   0     0   0   5 3                 8
482442 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   grade_8 2 0 0 4   0     0   0   1 5                       6 2 0 0 4   0     0   0   1 5                 6
482443 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   kindergarten_full_day 6 0 0 0   0     0   0   2 4                       6 6 0 0 0   0     0   0   2 4                 6
482444 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_full_day 8 0 0 1   0     0   0   5 4                       9 8 0 0 1   0     0   0   5 4                 9
486770 OK OSAGE   school 4033330 57-I030   WYNONA 403333001836 105 WYNONA ES Elementary Regular School No Elementary PK 08 2017   k_12_total 48 2 0 16   0     0   0   29 37                       66 48 2 0 16   0     0   0   29 37                 66
478456 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_5 39 7 3 8   0     1   0   22 36                       58 39 7 3 8   0     1   0   22 36                 58
478457 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_6 32 5 4 5   0     0   3   34 15                       49 32 5 4 5   0     0   3   34 15                 49
478458 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_7 30 1 1 11   1     0   4   24 24                       48 30 1 1 11   1     0   4   24 24                 48
478459 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_8 31 1 4 9   0     0   2   26 21                       47 31 1 4 9   0     0   2   26 21                 47
486071 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   k_12_total 132 14 12 33   1     1   9   106 96                       202 132 14 12 33   1     1   9   106 96                 202
478460 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001834 705 WYNNEWOOD HS High School Regular School No High 09 12 2017   grade_10 30 1 2 9   0     0   0   24 18                       42 30 1 2 9   0     0   0   24 18                 42
478461 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001834 705 WYNNEWOOD HS High School Regular School No High 09 12 2017   grade_11 18 8 4 7   0     0   0   17 20                       37 18 8 4 7   0     0   0   17 20                 37
478462 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001834 705 WYNNEWOOD HS High School Regular School No High 09 12 2017   grade_12 29 2 0 9   0     0   1   25 16                       41 29 2 0 9   0     0   1   25 16                 41
478463 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001834 705 WYNNEWOOD HS High School Regular School No High 09 12 2017   grade_9 38 2 6 14   0     1   7   34 34                       68 38 2 6 14   0     1   7   34 34                 68
478464 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001834 705 WYNNEWOOD HS High School Regular School No High 09 12 2017   out_of_home_placement 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
486072 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001834 705 WYNNEWOOD HS High School Regular School No High 09 12 2017   k_12_total 116 13 12 39   0     1   8   100 89                       189 116 13 12 39   0     1   8   100 89                 189
482506 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324002361 505 WYANDOTTE MS Middle Regular School No Middle 06 08 2017   grade_6 35 0 1 15   0     0   2   25 28                       53 35 0 1 15   0     0   2   25 28                 53
482507 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324002361 505 WYANDOTTE MS Middle Regular School No Middle 06 08 2017   grade_7 26 0 1 25   0     1   5   28 30                       58 26 0 1 25   0     1   5   28 30                 58
482508 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324002361 505 WYANDOTTE MS Middle Regular School No Middle 06 08 2017   grade_8 31 0 1 14   2     0   2   26 24                       50 31 0 1 14   2     0   2   26 24                 50
486783 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324002361 505 WYANDOTTE MS Middle Regular School No Middle 06 08 2017   k_12_total 92 0 3 54   2     1   9   79 82                       161 92 0 3 54   2     1   9   79 82                 161
482509 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324029731 715 WYANDOTTE HS High School Regular School No High 09 12 2017   grade_10 32 2 1 25   2     0   3   34 31                       65 32 2 1 25   2     0   3   34 31                 65
482510 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324029731 715 WYANDOTTE HS High School Regular School No High 09 12 2017   grade_11 19 0 3 30   1     0   4   27 30                       57 19 0 3 30   1     0   4   27 30                 57
482511 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324029731 715 WYANDOTTE HS High School Regular School No High 09 12 2017   grade_12 28 0 0 18   0     0   5   34 17                       51 28 0 0 18   0     0   5   34 17                 51
482512 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324029731 715 WYANDOTTE HS High School Regular School No High 09 12 2017   grade_9 28 1 2 21   1     0   3   28 28                       56 28 1 2 21   1     0   3   28 28                 56
482513 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324029731 715 WYANDOTTE HS High School Regular School No High 09 12 2017   out_of_home_placement 3 0 0 3   0     0   0   3 3                       6 3 0 0 3   0     0   0   3 3                 6

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