enrollments

Data source: Big Local News · About: Big Local

133 rows where grade = "out_of_home_placement", state = "OK" and year = 2021 sorted by multiracial_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 33 ✖

grade ✖

  • out_of_home_placement · 33 ✖
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
3330078 3330078 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000475 505 CIMARRON MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 1 0 1 0   0     0   1   3 0                       3 1 0 1 0   0     0   1   3 0                 3
3330089 3330089 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059029716 520 SUMMIT MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 3 3 0 0   0     0   1   6 1                       7 3 3 0 0   0     0   1   6 1                 7
3330261 3330261 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995002791 195 MIDWEST CITY ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 4 0 0 4   0     0   1   5 4                       9 4 0 0 4   0     0   1   5 4                 9
3330272 3330272 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995002655 550 MIDWEST CITY MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 12 1 4 3   0     0   1   9 12                       21 12 1 4 3   0     0   1   9 12                 21
3331773 3331773 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757000728 505 SHAWNEE MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 3 0 0 0   0     0   1   3 1                       4 3 0 0 0   0     0   1   3 1                 4
3332028 3332028 OK ROGERS   school 4006870 66-I002   CATOOSA 400687029754 110 CHEROKEE ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 2 0 0 0   0     0   1   3 0                       3 2 0 0 0   0     0   1   3 0                 3
3332033 3332033 OK ROGERS   school 4006870 66-I002   CATOOSA 400687002309 115 HELEN PAUL LEARNING CTR Elementary Regular School No Elementary KG 02 2021   out_of_home_placement 0 0 0 1   0     0   1   0 2                       2 0 0 0 1   0     0   1   0 2                 2
3332338 3332338 OK SEQUOYAH   school 4026790 68-I001   SALLISAW 402679001401 705 SALLISAW HS High School Regular School No High 09 12 2021   out_of_home_placement 9 6 3 6   0     0   1   25 0                       25 9 6 3 6   0     0   1   25 0                 25
3332706 3332706 OK TILLMAN   school 4012150 71-I158   FREDERICK 401215000567 105 FREDERICK ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 3 1 1 0   0     0   1   4 2                       6 3 1 1 0   0     0   1   4 2                 6
3332715 3332715 OK TILLMAN   school 4012150 71-I158   FREDERICK 401215000569 710 FREDERICK HS High School Regular School No High 09 12 2021   out_of_home_placement 0 0 0 0   0     0   1   0 1                       1 0 0 0 0   0     0   1   0 1                 1
3333272 3333272 OK TULSA   school 4026880 72-I002   SAND SPRINGS 402688001405 705 CHARLES PAGE HS High School Regular School No High 09 12 2021   out_of_home_placement 12 5 2 8   0     0   1   25 3                       28 12 5 2 8   0     0   1   25 3                 28
3333431 3333431 OK TULSA   school 4004500 72-I004   BIXBY 400450000148 705 BIXBY HS High School Regular School No High 09 12 2021   out_of_home_placement 0 0 1 0   0     0   1   0 2                       2 0 0 1 0   0     0   1   0 2                 2
3333545 3333545 OK TULSA   school 4030600 72-I009   UNION 403060001883 125 PETERS ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 1 0 0 0   0     0   1   2 0                       2 1 0 0 0   0     0   1   2 0                 2
3333941 3333941 OK WASHITA   school 4006510 75-I011   CANUTE 400651000256 705 CANUTE HS High School Regular School No High 09 12 2021   out_of_home_placement 4 5 3 2   0     0   1   15 0                       15 4 5 3 2   0     0   1   15 0                 15
3325484 3325484 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938001544 705 TAHLEQUAH HS High School Regular School No High 09 12 2021   out_of_home_placement 7 1 0 5   0     0   2   10 5                       15 7 1 0 5   0     0   2   10 5                 15
3326106 3326106 OK COMANCHE   school 4006120 16-I001   CACHE 400612000235 105 CACHE ES Elementary Regular School No Elementary PK 04 2021   out_of_home_placement 2 1 2 0   0     0   2   6 1                       7 2 1 2 0   0     0   2   6 1                 7
3326117 3326117 OK COMANCHE   school 4006120 16-I001   CACHE 400612029647 705 CACHE HS High School Regular School No High 09 12 2021   out_of_home_placement 5 0 1 1   0     0   2   4 5                       9 5 0 1 1   0     0   2   4 5                 9
3326426 3326426 OK CRAIG   school 4032190 18-I017   WELCH 403219029652 715 WELCH HS High School Regular School No High 09 12 2021   out_of_home_placement 6 4 0 2   0     0   2   14 0                       14 6 4 0 2   0     0   2   14 0                 14
3327164 3327164 OK GARVIN   school 4017850 25-I009   LINDSAY 401785000862 105 LINDSAY ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 6 0 0 5   0     0   2   11 2                       13 6 0 0 5   0     0   2   11 2                 13
3328999 3328999 OK MCCURTAIN   school 4015370 48-I005   IDABEL 401537000723 710 IDABEL HS High School Regular School No High 09 12 2021   out_of_home_placement 13 3 0 5   0     1   2   9 15                       24 13 3 0 5   0     1   2   9 15                 24
3330017 3330017 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059001965 150 CHARLES HASKELL ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 6 5 0 0   0     0   2   10 3                       13 6 5 0 0   0     0   2   10 3                 13
3333267 3333267 OK TULSA   school 4026880 72-I002   SAND SPRINGS 402688002382 520 CLYDE BOYD MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 6 2 0 4   0     0   2   12 2                       14 6 2 0 4   0     0   2   12 2                 14
3326513 3326513 OK CREEK   school 4005460 19-I002   BRISTOW 400546000193 705 BRISTOW HS High School Regular School No High 09 12 2021   out_of_home_placement 1 1 0 0   0     0   3   4 1                       5 1 1 0 0   0     0   3   4 1                 5
3330000 3330000 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000471 140 CHISHOLM ES Elementary Regular School No Elementary PK 05 2021   out_of_home_placement 3 1 1 1   0     0   3   9 0                       9 3 1 1 1   0     0   3   9 0                 9
3330285 3330285 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995000963 715 MIDWEST CITY HS High School Regular School No High 09 12 2021   out_of_home_placement 14 0 3 1   0     0   3   8 13                       21 14 0 3 1   0     0   3   8 13                 21
3326005 3326005 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002710 740 DIMENSIONS ACADEMY High School Regular School No High 09 12 2021   out_of_home_placement 45 8 7 12   1     0   4   63 14                       77 45 8 7 12   1     0   4   63 14                 77
3333136 3333136 OK TULSA   school 4030240 72-I001   TULSA 403024002736 574 TRAICE MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 19 1 5 5   1     0   4   18 17                       35 19 1 5 5   1     0   4   18 17                 35
3330593 3330593 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001928 710 EMERSON ALTERNATIVE ED. (HS) High School Regular School No High 09 12 2021   out_of_home_placement 44 19 7 10   0     0   5   62 23                       85 44 19 7 10   0     0   5   62 23                 85
3333089 3333089 OK TULSA   school 4030240 72-I001   TULSA 403024002738 423 PROJECT ACCEPT TRAICE ES Elementary Regular School No Elementary KG 06 2021   out_of_home_placement 8 1 2 5   0     0   7   19 4                       23 8 1 2 5   0     0   7   19 4                 23
3333190 3333190 OK TULSA   school 4030240 72-I001   TULSA 403024002663 750 TRAICE High School Regular School No High 09 12 2021   out_of_home_placement 16 6 4 5   0     0   7   20 18                       38 16 6 4 5   0     0   7   20 18                 38
3325979 3325979 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002714 170 DIMENSIONS ACADEMY Elementary Regular School No Elementary KG 08 2021   out_of_home_placement 46 8 2 4   0     0   9   53 16                       69 46 8 2 4   0     0   9   53 16                 69
3330376 3330376 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002325 210 EMERSON ALTERNATIVE ED. (ES) Elementary Regular School No Elementary KG 05 2021   out_of_home_placement 30 6 4 4   0     0   9   37 16                       53 30 6 4 4   0     0   9   37 16                 53
3330533 3330533 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002326 511 EMERSON ALTERNATIVE ED. (MS) Middle Regular School No Middle 06 08 2021   out_of_home_placement 57 6 5 10   0     0   17   70 25                       95 57 6 5 10   0     0   17   70 25                 95

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