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
3029643 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000538 105 CORNELSEN ES Elementary Regular School No Elementary PK 05 2020   out_of_home_placement 1 0 0 4   0     0   3   7 1                       8 1 0 0 4   0     0   3   7 1                 8
3029644 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000538 105 CORNELSEN ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 16 0 2 0   0     0   0   10 8                       18 16 0 2 0   0     0   0   10 8                 18
3029645 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000538 105 CORNELSEN ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_half_day 22 0 0 0   1     0   3   9 17                       26 22 0 0 0   1     0   3   9 17                 26
3029646 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000537 510 CHAMBERLAIN MS Middle Regular School No Middle 06 08 2020   grade_6 46 0 4 3   0     0   7   31 29                       60 46 0 4 3   0     0   7   31 29                 60
3029647 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000537 510 CHAMBERLAIN MS Middle Regular School No Middle 06 08 2020   grade_7 45 1 5 3   0     0   3   28 29                       57 45 1 5 3   0     0   3   28 29                 57
3029648 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000537 510 CHAMBERLAIN MS Middle Regular School No Middle 06 08 2020   grade_8 46 0 8 2   0     0   1   33 24                       57 46 0 8 2   0     0   1   33 24                 57
3029649 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000539 705 FAIRVIEW HS High School Regular School No High 09 12 2020   grade_10 46 0 3 6   2     0   0   27 30                       57 46 0 3 6   2     0   0   27 30                 57
3029650 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000539 705 FAIRVIEW HS High School Regular School No High 09 12 2020   grade_11 39 0 5 3   0     0   1   19 29                       48 39 0 5 3   0     0   1   19 29                 48
3029651 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000539 705 FAIRVIEW HS High School Regular School No High 09 12 2020   grade_12 36 0 5 2   0     0   1   18 26                       44 36 0 5 2   0     0   1   18 26                 44
3029652 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000539 705 FAIRVIEW HS High School Regular School No High 09 12 2020   grade_9 45 0 5 0   0     0   2   35 17                       52 45 0 5 0   0     0   2   35 17                 52
3029653 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000539 705 FAIRVIEW HS High School Regular School No High 09 12 2020   out_of_home_placement 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
3029654 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   grade_1 20 2 1 0   0     0   1   11 13                       24 20 2 1 0   0     0   1   11 13                 24
3029655 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   grade_2 14 0 3 0   0     0   1   11 7                       18 14 0 3 0   0     0   1   11 7                 18
3029656 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   grade_3 16 0 2 1   0     0   1   13 7                       20 16 0 2 1   0     0   1   13 7                 20
3029657 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   grade_4 18 0 3 0   0     0   0   14 7                       21 18 0 3 0   0     0   0   14 7                 21
3029658 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   grade_5 11 1 4 0   0     0   1   7 10                       17 11 1 4 0   0     0   1   7 10                 17
3029659 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   grade_6 16 0 0 0   0     0   0   7 9                       16 16 0 0 0   0     0   0   7 9                 16
3029660 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   grade_7 18 0 1 0   0     0   0   9 10                       19 18 0 1 0   0     0   0   9 10                 19
3029661 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   grade_8 10 0 1 1   0     0   2   7 7                       14 10 0 1 1   0     0   2   7 7                 14
3029662 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 18 0 2 0   0     0   1   12 9                       21 18 0 2 0   0     0   1   12 9                 21
3029663 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 15 0 3 1   0     0   1   16 4                       20 15 0 3 1   0     0   1   16 4                 20
3029664 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000540 705 CIMARRON HS High School Regular School No High 09 12 2020   grade_10 27 0 0 0   0     0   0   5 22                       27 27 0 0 0   0     0   0   5 22                 27
3029665 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000540 705 CIMARRON HS High School Regular School No High 09 12 2020   grade_11 12 0 0 0   0     0   1   8 5                       13 12 0 0 0   0     0   1   8 5                 13
3029666 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000540 705 CIMARRON HS High School Regular School No High 09 12 2020   grade_12 12 0 1 0   0     0   0   6 7                       13 12 0 1 0   0     0   0   6 7                 13
3029667 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000540 705 CIMARRON HS High School Regular School No High 09 12 2020   grade_9 16 0 3 0   0     0   0   12 7                       19 16 0 3 0   0     0   0   12 7                 19
3029668 OK MARSHALL   school 4018700 45-I002   MADILL 401870000886 105 MADILL ES Elementary Regular School No Elementary PK 05 2020   grade_1 38 3 57 15   0     0   7   76 44                       120 38 3 57 15   0     0   7   76 44                 120
3029669 OK MARSHALL   school 4018700 45-I002   MADILL 401870000886 105 MADILL ES Elementary Regular School No Elementary PK 05 2020   grade_2 56 2 56 13   2     0   8   68 69                       137 56 2 56 13   2     0   8   68 69                 137
3029670 OK MARSHALL   school 4018700 45-I002   MADILL 401870000886 105 MADILL ES Elementary Regular School No Elementary PK 05 2020   grade_3 34 1 59 11   0     0   6   56 55                       111 34 1 59 11   0     0   6   56 55                 111
3029671 OK MARSHALL   school 4018700 45-I002   MADILL 401870000886 105 MADILL ES Elementary Regular School No Elementary PK 05 2020   grade_4 34 2 62 10   0     0   10   55 63                       118 34 2 62 10   0     0   10   55 63                 118
3029672 OK MARSHALL   school 4018700 45-I002   MADILL 401870000886 105 MADILL ES Elementary Regular School No Elementary PK 05 2020   grade_5 50 1 63 18   1     0   5   63 75                       138 50 1 63 18   1     0   5   63 75                 138
3029673 OK MARSHALL   school 4018700 45-I002   MADILL 401870000886 105 MADILL ES Elementary Regular School No Elementary PK 05 2020   kindergarten_full_day 55 0 66 19   0     0   11   80 71                       151 55 0 66 19   0     0   11   80 71                 151
3029674 OK MARSHALL   school 4018700 45-I002   MADILL 401870000886 105 MADILL ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 35 1 44 12   1     0   7   45 55                       100 35 1 44 12   1     0   7   45 55                 100
3029675 OK MARSHALL   school 4018700 45-I002   MADILL 401870000888 505 MADILL MS Middle Regular School No Middle 06 08 2020   grade_6 36 3 48 12   1     0   9   62 47                       109 36 3 48 12   1     0   9   62 47                 109
3029676 OK MARSHALL   school 4018700 45-I002   MADILL 401870000888 505 MADILL MS Middle Regular School No Middle 06 08 2020   grade_7 38 1 75 16   2     0   5   74 63                       137 38 1 75 16   2     0   5   74 63                 137
3029677 OK MARSHALL   school 4018700 45-I002   MADILL 401870000888 505 MADILL MS Middle Regular School No Middle 06 08 2020   grade_8 58 0 61 13   1     0   10   82 61                       143 58 0 61 13   1     0   10   82 61                 143
3029678 OK MARSHALL   school 4018700 45-I002   MADILL 401870000887 705 MADILL HS High School Regular School No High 09 12 2020   grade_10 54 2 53 9   2     0   9   59 70                       129 54 2 53 9   2     0   9   59 70                 129
3029679 OK MARSHALL   school 4018700 45-I002   MADILL 401870000887 705 MADILL HS High School Regular School No High 09 12 2020   grade_11 39 1 51 10   0     0   5   44 62                       106 39 1 51 10   0     0   5   44 62                 106
3029680 OK MARSHALL   school 4018700 45-I002   MADILL 401870000887 705 MADILL HS High School Regular School No High 09 12 2020   grade_12 44 1 43 11   1     0   10   69 41                       110 44 1 43 11   1     0   10   69 41                 110
3029681 OK MARSHALL   school 4018700 45-I002   MADILL 401870000887 705 MADILL HS High School Regular School No High 09 12 2020   grade_9 56 0 51 17   2     0   12   71 67                       138 56 0 51 17   2     0   12   71 67                 138
3029682 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000773 105 KINGSTON ES Elementary Regular School No Elementary PK 05 2020   grade_1 55 0 3 24   0     0   1   46 37                       83 55 0 3 24   0     0   1   46 37                 83
3029683 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000773 105 KINGSTON ES Elementary Regular School No Elementary PK 05 2020   grade_2 44 1 3 25   0     0   2   30 45                       75 44 1 3 25   0     0   2   30 45                 75
3029684 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000773 105 KINGSTON ES Elementary Regular School No Elementary PK 05 2020   grade_3 42 0 6 23   0     0   2   44 29                       73 42 0 6 23   0     0   2   44 29                 73
3029685 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000773 105 KINGSTON ES Elementary Regular School No Elementary PK 05 2020   grade_4 47 2 6 33   0     0   5   40 53                       93 47 2 6 33   0     0   5   40 53                 93
3029686 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000773 105 KINGSTON ES Elementary Regular School No Elementary PK 05 2020   grade_5 47 1 5 30   0     0   5   43 45                       88 47 1 5 30   0     0   5   43 45                 88
3029687 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000773 105 KINGSTON ES Elementary Regular School No Elementary PK 05 2020   kindergarten_full_day 51 3 3 22   0     0   3   39 43                       82 51 3 3 22   0     0   3   39 43                 82
3029688 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000773 105 KINGSTON ES Elementary Regular School No Elementary PK 05 2020   pre_kindergarten_full_day 60 1 7 14   0     0   1   40 43                       83 60 1 7 14   0     0   1   40 43                 83
3029689 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659001948 505 KINGSTON MS Middle Regular School No Middle 06 08 2020   grade_6 52 1 5 41   0     0   6   49 56                       105 52 1 5 41   0     0   6   49 56                 105
3029690 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659001948 505 KINGSTON MS Middle Regular School No Middle 06 08 2020   grade_7 48 2 6 31   0     0   5   51 41                       92 48 2 6 31   0     0   5   51 41                 92
3029691 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659001948 505 KINGSTON MS Middle Regular School No Middle 06 08 2020   grade_8 47 0 8 37   0     0   9   50 51                       101 47 0 8 37   0     0   9   50 51                 101
3029692 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000774 705 KINGSTON HS High School Regular School No High 09 12 2020   grade_10 46 1 5 43   1     0   5   54 47                       101 46 1 5 43   1     0   5   54 47                 101
3029693 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000774 705 KINGSTON HS High School Regular School No High 09 12 2020   grade_11 36 0 4 44   0     0   3   53 34                       87 36 0 4 44   0     0   3   53 34                 87
3029694 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000774 705 KINGSTON HS High School Regular School No High 09 12 2020   grade_12 51 0 3 38   0     0   5   43 54                       97 51 0 3 38   0     0   5   43 54                 97
3029695 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659000774 705 KINGSTON HS High School Regular School No High 09 12 2020   grade_9 41 1 4 33   1     0   3   37 46                       83 41 1 4 33   1     0   3   37 46                 83
3029696 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_1 1 0 0 7   0     0   1   5 4                       9 1 0 0 7   0     0   1   5 4                 9
3029697 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_2 0 0 0 8   0     0   0   3 5                       8 0 0 0 8   0     0   0   3 5                 8
3029698 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_3 1 0 0 6   0     0   2   6 3                       9 1 0 0 6   0     0   2   6 3                 9
3029699 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_4 2 0 0 3   0     0   0   4 1                       5 2 0 0 3   0     0   0   4 1                 5
3029700 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_5 1 0 0 4   0     0   1   4 2                       6 1 0 0 4   0     0   1   4 2                 6
3029701 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 0 0 0 5   0     0   3   4 4                       8 0 0 0 5   0     0   3   4 4                 8
3029702 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 1 0 0 4   0     0   0   1 4                       5 1 0 0 4   0     0   0   1 4                 5
3029703 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 0 0 0 1   0     0   2   0 3                       3 0 0 0 1   0     0   2   0 3                 3
3029704 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 1 0 0 5   0     0   2   6 2                       8 1 0 0 5   0     0   2   6 2                 8
3029705 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_1 11 0 0 7   0     0   5   13 10                       23 11 0 0 7   0     0   5   13 10                 23
3029706 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_2 4 0 0 5   0     0   5   7 7                       14 4 0 0 5   0     0   5   7 7                 14
3029707 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_3 8 0 1 2   0     0   3   11 3                       14 8 0 1 2   0     0   3   11 3                 14
3029708 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_4 6 0 0 6   0     0   1   8 5                       13 6 0 0 6   0     0   1   8 5                 13
3029709 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_5 2 0 1 5   0     0   1   6 3                       9 2 0 1 5   0     0   1   6 3                 9
3029710 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_6 4 0 1 4   0     0   3   7 5                       12 4 0 1 4   0     0   3   7 5                 12
3029711 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 4 0 0 1   0     0   3   2 6                       8 4 0 0 1   0     0   3   2 6                 8
3029712 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_8 2 0 2 1   0     0   2   5 2                       7 2 0 2 1   0     0   2   5 2                 7
3029713 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   kindergarten_full_day 12 0 3 6   0     0   5   13 13                       26 12 0 3 6   0     0   5   13 13                 26
3029714 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   pre_kindergarten_full_day 11 0 1 5   0     0   2   13 6                       19 11 0 1 5   0     0   2   13 6                 19
3029715 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   grade_1 32 0 4 21   0     0   21   39 39                       78 32 0 4 21   0     0   21   39 39                 78
3029716 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   grade_2 48 2 7 23   2     0   19   47 54                       101 48 2 7 23   2     0   19   47 54                 101
3029717 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   grade_3 45 1 8 26   0     1   10   50 41                       91 45 1 8 26   0     1   10   50 41                 91
3029718 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   grade_4 46 3 7 32   1     0   26   60 55                       115 46 3 7 32   1     0   26   60 55                 115
3029719 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   grade_5 41 0 6 24   2     1   17   46 45                       91 41 0 6 24   2     1   17   46 45                 91
3029720 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   grade_6 38 1 6 27   2     0   13   53 34                       87 38 1 6 27   2     0   13   53 34                 87
3029721 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   kindergarten_full_day 49 0 6 25   1     0   23   49 55                       104 49 0 6 25   1     0   23   49 55                 104
3029722 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   pre_kindergarten_full_day 33 0 10 35   0     0   21   43 56                       99 33 0 10 35   0     0   21   43 56                 99
3029723 OK MAYES   school 4025200 46-I001   PRYOR 402520001321 105 LINCOLN ES Elementary Regular School No Elementary PK 06 2020   pre_kindergarten_half_day 3 0 1 0   0     0   1   3 2                       5 3 0 1 0   0     0   1   3 2                 5
3029724 OK MAYES   school 4025200 46-I001   PRYOR 402520001320 110 JEFFERSON ES Elementary Regular School No Elementary KG 06 2020   grade_1 12 0 3 9   0     0   12   22 14                       36 12 0 3 9   0     0   12   22 14                 36
3029725 OK MAYES   school 4025200 46-I001   PRYOR 402520001320 110 JEFFERSON ES Elementary Regular School No Elementary KG 06 2020   grade_2 11 0 5 9   0     0   15   17 23                       40 11 0 5 9   0     0   15   17 23                 40
3029726 OK MAYES   school 4025200 46-I001   PRYOR 402520001320 110 JEFFERSON ES Elementary Regular School No Elementary KG 06 2020   grade_3 13 0 2 14   0     0   6   21 14                       35 13 0 2 14   0     0   6   21 14                 35
3029727 OK MAYES   school 4025200 46-I001   PRYOR 402520001320 110 JEFFERSON ES Elementary Regular School No Elementary KG 06 2020   grade_4 21 0 5 8   0     0   7   22 19                       41 21 0 5 8   0     0   7   22 19                 41
3029728 OK MAYES   school 4025200 46-I001   PRYOR 402520001320 110 JEFFERSON ES Elementary Regular School No Elementary KG 06 2020   grade_5 20 0 5 14   1     0   9   28 21                       49 20 0 5 14   1     0   9   28 21                 49
3029729 OK MAYES   school 4025200 46-I001   PRYOR 402520001320 110 JEFFERSON ES Elementary Regular School No Elementary KG 06 2020   grade_6 14 1 5 13   0     0   9   20 22                       42 14 1 5 13   0     0   9   20 22                 42
3029730 OK MAYES   school 4025200 46-I001   PRYOR 402520001320 110 JEFFERSON ES Elementary Regular School No Elementary KG 06 2020   kindergarten_full_day 12 1 4 9   0     0   9   21 14                       35 12 1 4 9   0     0   9   21 14                 35
3029731 OK MAYES   school 4025200 46-I001   PRYOR 402520001324 115 ROOSEVELT ES Elementary Regular School No Elementary PK 06 2020   grade_1 37 1 4 18   0     0   16   38 38                       76 37 1 4 18   0     0   16   38 38                 76
3029732 OK MAYES   school 4025200 46-I001   PRYOR 402520001324 115 ROOSEVELT ES Elementary Regular School No Elementary PK 06 2020   grade_2 38 0 4 27   0     0   16   42 43                       85 38 0 4 27   0     0   16   42 43                 85
3029733 OK MAYES   school 4025200 46-I001   PRYOR 402520001324 115 ROOSEVELT ES Elementary Regular School No Elementary PK 06 2020   grade_3 25 0 10 14   0     0   14   33 30                       63 25 0 10 14   0     0   14   33 30                 63
3029734 OK MAYES   school 4025200 46-I001   PRYOR 402520001324 115 ROOSEVELT ES Elementary Regular School No Elementary PK 06 2020   grade_4 34 1 4 19   0     0   10   26 42                       68 34 1 4 19   0     0   10   26 42                 68
3029735 OK MAYES   school 4025200 46-I001   PRYOR 402520001324 115 ROOSEVELT ES Elementary Regular School No Elementary PK 06 2020   grade_5 35 1 5 25   0     0   9   37 38                       75 35 1 5 25   0     0   9   37 38                 75
3029736 OK MAYES   school 4025200 46-I001   PRYOR 402520001324 115 ROOSEVELT ES Elementary Regular School No Elementary PK 06 2020   grade_6 30 2 4 18   0     1   13   37 31                       68 30 2 4 18   0     1   13   37 31                 68
3029737 OK MAYES   school 4025200 46-I001   PRYOR 402520001324 115 ROOSEVELT ES Elementary Regular School No Elementary PK 06 2020   kindergarten_full_day 25 1 7 15   0     0   11   27 32                       59 25 1 7 15   0     0   11   27 32                 59
3029738 OK MAYES   school 4025200 46-I001   PRYOR 402520001324 115 ROOSEVELT ES Elementary Regular School No Elementary PK 06 2020   pre_kindergarten_full_day 26 0 4 23   0     0   9   31 31                       62 26 0 4 23   0     0   9   31 31                 62
3029739 OK MAYES   school 4025200 46-I001   PRYOR 402520001323 610 PRYOR JHS Junior High Regular School No Middle 07 09 2020   grade_7 111 3 18 66   0     1   32   115 116                       231 111 3 18 66   0     1   32   115 116                 231
3029740 OK MAYES   school 4025200 46-I001   PRYOR 402520001323 610 PRYOR JHS Junior High Regular School No Middle 07 09 2020   grade_8 87 1 13 58   1     0   31   94 97                       191 87 1 13 58   1     0   31   94 97                 191
3029741 OK MAYES   school 4025200 46-I001   PRYOR 402520001323 610 PRYOR JHS Junior High Regular School No Middle 07 09 2020   grade_9 86 0 11 63   2     1   25   108 80                       188 86 0 11 63   2     1   25   108 80                 188
3029742 OK MAYES   school 4025200 46-I001   PRYOR 402520001322 705 PRYOR HS High School Regular School No High 10 12 2020   grade_10 67 0 15 60   2     1   21   100 66                       166 67 0 15 60   2     1   21   100 66                 166

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