enrollments

Data source: Big Local News · About: Big Local

159 rows where grade = "pre_kindergarten_half_day", state = "OK" and year = 2017 sorted by multiracial_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 59 ✖

grade ✖

  • pre_kindergarten_half_day · 59 ✖
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
483929 483929 OK STEPHENS   school 4010290 69-I001   DUNCAN 401029000454 130 WILL ROGERS PRE-K CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 10 0 2 0   1     0   3   10 6                       16 10 0 2 0   1     0   3   10 6                 16
485403 485403 OK WASHITA   school 4027330 75-I001   SENTINEL 402733001443 105 MCMURRAY ES Elementary Regular School No Elementary PK 08 2017   pre_kindergarten_half_day 13 0 3 0   0     0   3   9 10                       19 13 0 3 0   0     0   3   9 10                 19
475881 475881 OK BLAINE   school 4031770 06-I042   WATONGA 403177001757 105 WATONGA ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 18 2 5 5   0     0   4   16 18                       34 18 2 5 5   0     0   4   16 18                 34
476381 476381 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002666 135 MUSTANG CENTENNIAL ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 34 2 6 0   1     0   4   23 24                       47 34 2 6 0   1     0   4   23 24                 47
477089 477089 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001068 110 ADAMS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 14 1 13 3   0     0   4   19 16                       35 14 1 13 3   0     0   4   19 16                 35
481060 481060 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863000882 105 LUTHER ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 32 0 2 2   0     0   4   25 15                       40 32 0 2 2   0     0   4   25 15                 40
481240 481240 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000471 140 CHISHOLM ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 73 1 9 1   0     1   4   49 40                       89 73 1 9 1   0     1   4   49 40                 89
481247 481247 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059001946 145 JOHN ROSS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 33 3 7 0   2     0   4   29 20                       49 33 3 7 0   2     0   4   29 20                 49
481276 481276 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059001864 165 ANGIE DEBO ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 30 13 9 3   11     0   4   34 36                       70 30 13 9 3   11     0   4   34 36                 70
483490 483490 OK ROGERS   school 4007740 66-I001   CLAREMORE 400774002725 135 CATALAYAH ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 16 0 6 9   1     0   4   15 21                       36 16 0 6 9   1     0   4   15 21                 36
484081 484081 OK TEXAS   school 4013590 70-I008   GUYMON 401359000636 130 CARRIER ES Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 41 1 114 0   5     0   4   85 80                       165 41 1 114 0   5     0   4   85 80                 165
484940 484940 OK TULSA   school 4004500 72-I004   BIXBY 400450002772 150 NORTHEAST ES AND IS Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 29 1 4 1   1     0   4   19 21                       40 29 1 4 1   1     0   4   19 21                 40
485460 485460 OK WOODS   school 4002880 76-I001   ALVA 400288000045 115 WASHINGTON ES Elementary Regular School No Elementary PK 01 2017   pre_kindergarten_half_day 53 1 6 4   0     0   4   37 31                       68 53 1 6 4   0     0   4   37 31                 68
477145 477145 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001080 135 MCKINLEY ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 9 0 3 1   0     0   5   8 10                       18 9 0 3 1   0     0   5   8 10                 18
477414 477414 OK COMANCHE   school 4017250 16-I008   LAWTON 401725000799 106 ALMOR WEST ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 14 8 6 1   0     1   5   16 19                       35 14 8 6 1   0     1   5   16 19                 35
483468 483468 OK ROGERS   school 4007740 66-I001   CLAREMORE 400774000321 105 CLAREMONT ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 28 1 6 15   0     0   5   25 30                       55 28 1 6 15   0     0   5   25 30                 55
483483 483483 OK ROGERS   school 4007740 66-I001   CLAREMORE 400774000325 115 WESTSIDE ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 18 1 5 11   0     0   5   20 20                       40 18 1 5 11   0     0   5   20 20                 40
476391 476391 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002786 150 PRAIRIE VIEW ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 24 1 3 2   4     0   6   16 24                       40 24 1 3 2   4     0   6   16 24                 40
476903 476903 OK CLEVELAND   school 4020250 14-I002   MOORE 402025000995 120 HOUCHIN ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 23 3 7 0   1     0   6   25 15                       40 23 3 7 0   1     0   6   25 15                 40
477107 477107 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001074 115 JACKSON ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 17 5 11 1   1     0   6   16 25                       41 17 5 11 1   1     0   6   16 25                 41
479982 479982 OK MARSHALL   school 4018700 45-I002   MADILL 401870000886 105 MADILL ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 31 0 27 6   2     0   6   39 33                       72 31 0 27 6   2     0   6   39 33                 72
481098 481098 OK OKLAHOMA   school 4007620 55-I004   CHOCTAW-NICOMA PARK 400762001957 126 L. W. WESTFALL ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 32 0 4 2   0     0   6   19 25                       44 32 0 4 2   0     0   6   19 25                 44
481208 481208 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000478 122 NORTHERN HILLS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 41 13 6 3   2     0   6   40 31                       71 41 13 6 3   2     0   6   40 31                 71
484358 484358 OK TULSA   school 4030240 72-I001   TULSA 403024000989 170 EISENHOWER INTERNATIONAL ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 19 3 7 4   1     0   6   24 16                       40 19 3 7 4   1     0   6   24 16                 40
476368 476368 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100029628 120 MUSTANG TRAILS ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 34 0 1 2   1     0   7   23 22                       45 34 0 1 2   1     0   7   23 22                 45
476968 476968 OK CLEVELAND   school 4020250 14-I002   MOORE 402025029847 160 SOONER ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 22 4 4 1   2     0   7   20 20                       40 22 4 4 1   2     0   7   20 20                 40
479689 479689 OK LINCOLN   school 4007290 41-I001   CHANDLER 400729029695 110 EAST SIDE ES Elementary Regular School No Elementary PK 02 2017   pre_kindergarten_half_day 21 0 1 0   0     0   7   14 15                       29 21 0 1 0   0     0   7   14 15                 29
481255 481255 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059001965 150 CHARLES HASKELL ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 36 16 8 3   10     0   7   46 34                       80 36 16 8 3   10     0   7   46 34                 80
481304 481304 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059002819 185 HERITAGE ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 32 0 3 3   1     0   7   24 22                       46 32 0 3 3   1     0   7   24 22                 46
483618 483618 OK SEMINOLE   school 4027300 67-I001   SEMINOLE 402730001439 105 WILSON ES Elementary Regular School No Elementary PK 03 2017   pre_kindergarten_half_day 5 0 4 6   0     0   7   16 6                       22 5 0 4 6   0     0   7   16 6                 22
476864 476864 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001002 110 SOUTHGATE-RIPPETOE ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 29 2 7 3   1     0   8   24 26                       50 29 2 7 3   1     0   8   24 26                 50
476893 476893 OK CLEVELAND   school 4020250 14-I002   MOORE 402025000997 117 KINGSGATE ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 10 7 11 0   4     0   8   24 16                       40 10 7 11 0   4     0   8   24 16                 40
476922 476922 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001867 130 SANTA FE ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 25 1 5 1   0     0   8   24 16                       40 25 1 5 1   0     0   8   24 16                 40
477204 477204 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 23 0 3 2   5     0   8   23 18                       41 23 0 3 2   5     0   8   23 18                 41
481539 481539 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411000131 105 EARL HARRIS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 51 4 17 2   0     0   8   40 42                       82 51 4 17 2   0     0   8   40 42                 82
481073 481073 OK OKLAHOMA   school 4007620 55-I004   CHOCTAW-NICOMA PARK 400762000312 103 INDIAN MERIDIAN ES Elementary Regular School No Elementary PK 02 2017   pre_kindergarten_half_day 67 0 5 5   0     0   9   44 42                       86 67 0 5 5   0     0   9   44 42                 86
481262 481262 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059010484 155 CROSS TIMBERS ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 69 1 12 3   2     1   9   46 51                       97 69 1 12 3   2     1   9   46 51                 97
476883 476883 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001001 113 SKY RANCH ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 13 2 11 1   2     0   10   18 21                       39 13 2 11 1   2     0   10   18 21                 39
477098 477098 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001071 112 CLEVELAND ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 23 1 4 1   2     0   10   21 20                       41 23 1 4 1   2     0   10   21 20                 41
477185 477185 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001127 153 ROOSEVELT ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 35 4 7 6   1     0   10   31 32                       63 35 4 7 6   1     0   10   31 32                 63
477945 477945 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029660 120 BURCHAM ES Elementary Regular School No Elementary PK 01 2017   pre_kindergarten_half_day 84 2 10 7   3     0   10   68 48                       116 84 2 10 7   3     0   10   68 48                 116
481085 481085 OK OKLAHOMA   school 4007620 55-I004   CHOCTAW-NICOMA PARK 400762000314 115 NICOMA PARK ES Elementary Regular School No Elementary PK 02 2017   pre_kindergarten_half_day 68 4 5 4   1     0   10   43 49                       92 68 4 5 4   1     0   10   43 49                 92
481283 481283 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059002402 170 WEST FIELD ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 67 9 9 1   14     1   10   59 52                       111 67 9 9 1   14     1   10   59 52                 111
481269 481269 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059010485 160 WASHINGTON IRVING ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 45 5 1 0   0     0   11   36 26                       62 45 5 1 0   0     0   11   36 26                 62
476374 476374 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001605 125 MUSTANG CREEK ES Elementary Regular School No Elementary PK 04 2017   pre_kindergarten_half_day 45 1 7 2   9     1   12   47 30                       77 45 1 7 2   9     1   12   47 30                 77
477176 477176 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002752 151 RONALD REAGAN ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 26 2 6 2   0     0   12   30 18                       48 26 2 6 2   0     0   12   30 18                 48
481297 481297 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059002766 180 FRONTIER ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 58 8 3 2   2     0   12   38 47                       85 58 8 3 2   2     0   12   38 47                 85
477116 477116 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001075 120 JEFFERSON ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 23 4 3 1   0     0   13   25 19                       44 23 4 3 1   0     0   13   25 19                 44
477153 477153 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001072 140 EISENHOWER ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 36 3 4 2   0     0   13   24 34                       58 36 3 4 2   0     0   13   24 34                 58
483475 483475 OK ROGERS   school 4007740 66-I001   CLAREMORE 400774000324 110 ROOSA ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 9 0 2 9   1     0   13   13 21                       34 9 0 2 9   1     0   13   13 21                 34
477138 477138 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001079 130 MADISON ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 36 8 7 1   3     0   14   31 38                       69 36 8 7 1   3     0   14   31 38                 69
481186 481186 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000472 105 CLEGERN ES Elementary Regular School No Elementary PK 05 2017   pre_kindergarten_half_day 90 4 4 1   3     0   15   51 66                       117 90 4 4 1   3     0   15   51 66                 117
484925 484925 OK TULSA   school 4004500 72-I004   BIXBY 400450002334 120 BIXBY NORTH ES Elementary Regular School No Elementary PK 03 2017   pre_kindergarten_half_day 62 1 16 2   2     0   16   58 41                       99 62 1 16 2   2     0   16   58 41                 99
484993 484993 OK TULSA   school 4027750 72-I007   SKIATOOK 402775001474 110 MARRS ES Elementary Regular School No Elementary PK 01 2017   pre_kindergarten_half_day 47 0 5 16   0     0   19   45 42                       87 47 0 5 16   0     0   19   45 42                 87
479808 479808 OK LOGAN   school 4013560 42-I001   GUTHRIE 401356000630 120 COTTERAL ES Elementary Regular School No Elementary PK KG 2017   pre_kindergarten_half_day 70 7 12 2   1     0   20   54 58                       112 70 7 12 2   1     0   20   54 58                 112
484920 484920 OK TULSA   school 4004500 72-I004   BIXBY 400450000147 110 CENTRAL ES Elementary Regular School No Elementary PK 03 2017   pre_kindergarten_half_day 68 3 8 1   1     0   25   57 49                       106 68 3 8 1   1     0   25   57 49                 106
476978 476978 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001122 165 EARLYWINE ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 101 9 31 7   31     0   31   104 106                       210 101 9 31 7   31     0   31   104 106                 210
476827 476827 OK CLEVELAND   school 4020250 14-I002   MOORE 402025000988 103 CENTRAL ES Elementary Regular School No Elementary PK 06 2017   pre_kindergarten_half_day 125 6 23 10   4     0   32   110 90                       200 125 6 23 10   4     0   32   110 90                 200
476375 476375 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002358 130 MUSTANG EDUCATION CTR Elementary Regular School No Elementary PK PK 2017   pre_kindergarten_half_day 187 5 26 17   17     0   37   162 127                       289 187 5 26 17   17     0   37   162 127                 289

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