Data source: Big Local News · About: Big Local

2,956 rows where grade = "grade_7" and state = "OK" sorted by black_int

View and edit SQL

year

grade

  • grade_7 · 2,856
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
478429 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2017   grade_7 61 0 9 17   1     0   2   48 42                       90 61 0 9 17   1     0   2   48 42                 90
478473 OK GARVIN   school 4010860 25-I072   ELMORE CITY-PERNELL 401086002746 605 ELMORE CITY JHS Junior High Regular School No Middle 06 08 2017   grade_7 32 0 2 7   0     0   8   26 23                       49 32 0 2 7   0     0   8   26 23                 49
478496 OK GRADY   school 4019890 26-C096   MIDDLEBERG 401989000949 105 MIDDLEBERG PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 21 0 0 1   0     0   1   9 14                       23 21 0 0 1   0     0   1   9 14                 23
478506 OK GRADY   school 4024150 26-C131   PIONEER 402415001274 105 PIONEER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 22 0 1 3   0     0   0   13 13                       26 22 0 1 3   0     0   0   13 13                 26
478536 OK GRADY   school 4020100 26-I002   MINCO 402010001668 505 MINCO MS Middle Regular School No Middle 06 08 2017   grade_7 38 0 4 0   0     0   3   22 23                       45 38 0 4 0   0     0   3   22 23                 45
478562 OK GRADY   school 4002670 26-I056   ALEX 400267000019 105 ALEX ES Elementary Regular School No Elementary PK 08 2017   grade_7 22 0 0 6   0     0   1   16 13                       29 22 0 0 6   0     0   1   16 13                 29
478578 OK GRADY   school 4026550 26-I068   RUSH SPRINGS 402655001391 505 RUSH SPRINGS MS Middle Regular School No Middle 06 08 2017   grade_7 28 0 0 6   1     0   1   20 16                       36 28 0 0 6   1     0   1   20 16                 36
478592 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2017   grade_7 85 0 4 2   0     0   15   57 49                       106 85 0 4 2   0     0   15   57 49                 106
478619 OK GRADY   school 4031080 26-I099   VERDEN 403108001721 105 VERDEN ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 2   0     0   2   4 8                       12 8 0 0 2   0     0   2   4 8                 12
478647 OK GRANT   school 4019620 27-I054   MEDFORD 401962000934 105 MEDFORD ES Elementary Regular School No Elementary PK 08 2017   grade_7 15 0 2 1   0     0   1   13 6                       19 15 0 2 1   0     0   1   13 6                 19
478663 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2017   grade_7 25 0 4 2   0     0   1   10 22                       32 25 0 4 2   0     0   1   10 22                 32
478675 OK GRANT   school 4017020 27-I095   DEER CREEK-LAMONT 401702000788 105 DEER CREEK-LAMONT ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 0 3   1     0   0   8 5                       13 9 0 0 3   1     0   0   8 5                 13
478692 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2017   grade_7 37 0 11 0   0     0   2   25 25                       50 37 0 11 0   0     0   2   25 25                 50
478706 OK GREER   school 4013290 28-I003   GRANITE 401329000616 105 GRANITE ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 4 0   0     0   0   6 6                       12 8 0 4 0   0     0   0   6 6                 12
478737 OK HARPER   school 4017220 30-I001   LAVERNE 401722000795 105 LAVERNE ES Elementary Regular School No Elementary PK 08 2017   grade_7 16 0 15 0   0     0   1   21 11                       32 16 0 15 0   0     0   1   21 11                 32
478752 OK HARPER   school 4005760 30-I004   BUFFALO 400576000215 105 BUFFALO ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 4 0   0     0   0   6 12                       18 14 0 4 0   0     0   0   6 12                 18
478766 OK HASKELL   school 4032700 31-C010   WHITEFIELD 403270001806 105 WHITEFIELD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 1 1   0     0   0   4 3                       7 5 0 1 1   0     0   0   4 3                 7
478819 OK HASKELL   school 4016350 31-I043   KEOTA 401635000757 105 KEOTA ES Elementary Regular School No Elementary PK 08 2017   grade_7 17 0 0 14   0     0   0   18 13                       31 17 0 0 14   0     0   0   18 13                 31
478833 OK HUGHES   school 4020460 32-I001   MOSS 402046001013 105 MOSS ES Elementary Regular School No Elementary PK 08 2017   grade_7 15 0 3 4   0     0   1   13 10                       23 15 0 3 4   0     0   1   13 10                 23
478847 OK HUGHES   school 4032430 32-I005   WETUMKA 403243001796 105 WETUMKA ES Elementary Regular School No Elementary PK 08 2017   grade_7 7 0 1 15   0     0   3   14 12                       26 7 0 1 15   0     0   3   14 12                 26
478875 OK HUGHES   school 4006270 32-I048   CALVIN 400627000243 105 CALVIN ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 0 4   0     0   1   8 3                       11 6 0 0 4   0     0   1   8 3                 11
478889 OK HUGHES   school 4029100 32-I054   STUART 402910001530 105 STUART ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 2 8   0     0   1   5 7                       12 1 0 2 8   0     0   1   5 7                 12
478905 OK JACKSON   school 4021180 33-I001   NAVAJO 402118001889 610 NAVAJO JHS Junior High Regular School No Other 07 09 2017   grade_7 34 0 2 1   1     0   0   18 20                       38 34 0 2 1   1     0   0   18 20                 38
478952 OK JACKSON   school 4010680 33-I025   ELDORADO 401068000491 105 ELDORADO ES Elementary Regular School No Elementary PK 08 2017   grade_7 4 0 3 0   0     0   1   5 3                       8 4 0 3 0   0     0   1   5 3                 8
478980 OK JACKSON   school 4004650 33-I054   BLAIR 400465000157 105 BLAIR ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 8 1   0     0   0   12 10                       22 13 0 8 1   0     0   0   12 10                 22
478994 OK JEFFERSON   school 4029760 34-C003   TERRAL 402976002008 105 TERRAL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 2 0 0 1   0     0   2   4 1                       5 2 0 0 1   0     0   2   4 1                 5
479004 OK JEFFERSON   school 4026610 34-I001   RYAN 402661001393 105 RYAN ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 2 0   0     0   2   7 5                       12 8 0 2 0   0     0   2   7 5                 12
479020 OK JEFFERSON   school 4025860 34-I014   RINGLING 402586001374 610 RINGLING JHS Junior High Regular School No Other 07 09 2017   grade_7 23 0 1 14   0     0   0   17 21                       38 23 0 1 14   0     0   0   17 21                 38
479046 OK JOHNSTON   school 4018870 35-C007   MANNSVILLE 401887000896 105 MANNSVILLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 7 0 1 0   0     0   1   4 5                       9 7 0 1 0   0     0   1   4 5                 9
479056 OK JOHNSTON   school 4025530 35-C010   RAVIA 402553001364 105 RAVIA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 1 2   0     0   7   6 7                       13 3 0 1 2   0     0   7   6 7                 13
479066 OK JOHNSTON   school 4020040 35-I002   MILL CREEK 402004000979 105 MILL CREEK ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 5   0     0   0   4 4                       8 3 0 0 5   0     0   0   4 4                 8
479082 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2017   grade_7 33 0 4 14   0     0   12   36 27                       63 33 0 4 14   0     0   12   36 27                 63
479094 OK JOHNSTON   school 4019980 35-I029   MILBURN 401998000976 105 MILBURN ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 2 5   0     0   0   8 8                       16 9 0 2 5   0     0   0   8 8                 16
479109 OK JOHNSTON   school 4008310 35-I035   COLEMAN 400831000347 105 COLEMAN ES Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 0 0   0     0   7   4 8                       12 5 0 0 0   0     0   7   4 8                 12
479123 OK JOHNSTON   school 4031590 35-I037   WAPANUCKA 403159001748 105 WAPANUCKA ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 4 7   0     0   0   12 12                       24 13 0 4 7   0     0   0   12 12                 24
479137 OK KAY   school 4023700 36-C027   PECKHAM 402370001257 105 PECKHAM PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 0 0   0     0   2   4 3                       7 5 0 0 0   0     0   2   4 3                 7
479157 OK KAY   school 4004630 36-I045   BLACKWELL 400463000152 505 BLACKWELL MS Middle Regular School No Middle 06 08 2017   grade_7 53 0 10 19   0     1   0   48 35                       83 53 0 10 19   0     1   0   48 35                 83
479238 OK KAY   school 4021540 36-I125   NEWKIRK 402154001986 505 NEWKIRK MS Middle Regular School No Middle 05 08 2017   grade_7 41 0 3 21   0     0   0   40 25                       65 41 0 3 21   0     0   0   40 25                 65
479250 OK KINGFISHER   school 4010050 37-I002   DOVER 401005000436 105 DOVER ES Elementary Regular School No Elementary PK 08 2017   grade_7 2 0 3 0   0     0   0   1 4                       5 2 0 3 0   0     0   0   1 4                 5
479264 OK KINGFISHER   school 4022950 37-I003   LOMEGA 402295001223 105 LOMEGA ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 0 1   0     0   14   13 12                       25 10 0 0 1   0     0   14   13 12                 25
479324 OK KINGFISHER   school 4022590 37-I105   OKARCHE 402259029687 610 OKARCHE JHS Junior High Regular School No Other 07 09 2017   grade_7 16 0 1 2   0     0   2   10 11                       21 16 0 1 2   0     0   2   10 11                 21
479350 OK KIOWA   school 4018270 38-I002   LONE WOLF 401827000873 105 LONE WOLF ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 1 0   0     0   0   5 7                       12 11 0 1 0   0     0   0   5 7                 12
479364 OK KIOWA   school 4029886 38-I003   MOUNTAIN VIEW-GOTEBO 402988602106 110 MOUNTAIN VIEW-GOTEBO ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 3 2   0     0   3   7 9                       16 8 0 3 2   0     0   3   7 9                 16
479408 OK LATIMER   school 4025590 39-I002   RED OAK 402559001365 105 RED OAK ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 0 5   0     0   0   9 6                       15 10 0 0 5   0     0   0   9 6                 15
479422 OK LATIMER   school 4005820 39-I003   BUFFALO VALLEY 400582000217 105 BUFFALO VALLEY ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 1 6   0     0   0   9 1                       10 3 0 1 6   0     0   0   9 1                 10
479436 OK LATIMER   school 4023400 39-I004   PANOLA 402340001242 105 PANOLA ES Elementary Regular School No Elementary PK 08 2017   grade_7 7 0 0 6   0     0   0   5 8                       13 7 0 0 6   0     0   0   5 8                 13
479450 OK LE FLORE   school 4027450 40-C004   SHADY POINT 402745001450 105 SHADY POINT PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 0 3   0     0   2   4 6                       10 5 0 0 3   0     0   2   4 6                 10
479460 OK LE FLORE   school 4020190 40-C011   MONROE 402019000987 105 MONROE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 2 1   0     0   0   11 1                       12 9 0 2 1   0     0   0   11 1                 12
479480 OK LE FLORE   school 4011400 40-C039   FANSHAWE 401140000541 105 FANSHAWE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 2   0     0   0   0 2                       2 0 0 0 2   0     0   0   0 2                 2
479504 OK LE FLORE   school 4014160 40-I003   HEAVENER 401416000670 105 HEAVENER ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 25 27   0     0   0   33 31                       64 12 0 25 27   0     0   0   33 31                 64
479532 OK LE FLORE   school 4017280 40-I016   LE FLORE 401728000840 105 LEFLORE ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 1 13   0     0   0   14 6                       20 6 0 1 13   0     0   0   14 6                 20
479546 OK LE FLORE   school 4006330 40-I017   CAMERON 400633000246 105 CAMERON ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 5 5   0     0   1   10 12                       22 11 0 5 5   0     0   1   10 12                 22
479578 OK LE FLORE   school 4004950 40-I026   BOKOSHE 400495000422 615 BOKOSHE JHS Junior High Regular School No Other 07 09 2017   grade_7 9 0 1 3   0     0   0   8 5                       13 9 0 1 3   0     0   0   8 5                 13
479607 OK LE FLORE   school 4032970 40-I049   WISTER 403297001817 105 WISTER ES Elementary Regular School No Elementary PK 08 2017   grade_7 25 0 3 11   0     0   3   22 20                       42 25 0 3 11   0     0   3   22 20                 42
479623 OK LE FLORE   school 4029400 40-I052   TALIHINA 402940001548 610 TALIHINA JHS Junior High Regular School No Middle 07 08 2017   grade_7 17 0 1 23   0     0   0   20 21                       41 17 0 1 23   0     0   0   20 21                 41
479637 OK LE FLORE   school 4032730 40-I062   WHITESBORO 403273001807 105 WHITESBORO ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 10   0     0   0   10 8                       18 8 0 0 10   0     0   0   10 8                 18
479665 OK LE FLORE   school 4003210 40-I091   ARKOMA 400321000075 205 SINGLETON ES Elementary Regular School No Elementary PK 07 2017   grade_7 3 0 0 0   0     0   0   2 1                       3 3 0 0 0   0     0   0   2 1                 3
479681 OK LINCOLN   school 4032640 41-C005   WHITE ROCK 403264001804 105 WHITE ROCK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 1   0     0   4   4 4                       8 3 0 0 1   0     0   4   4 4                 8
479723 OK LINCOLN   school 4032280 41-I004   WELLSTON 403228029696 505 WELLSTON MS Middle Regular School No Middle 06 08 2017   grade_7 27 0 2 5   0     0   0   21 13                       34 27 0 2 5   0     0   0   21 13                 34
479795 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 08 2017   grade_7 22 0 2 9   0     0   0   15 18                       33 22 0 2 9   0     0   0   15 18                 33
479840 OK LOGAN   school 4020910 42-I003   MULHALL-ORLANDO 402091001029 105 MULHALL-ORLANDO ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 2 3   0     0   2   9 11                       20 13 0 2 3   0     0   2   9 11                 20
479868 OK LOVE   school 4013380 43-C003   GREENVILLE 401338000622 105 GREENVILLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 5 1   0     0   4   3 8                       11 1 0 5 1   0     0   4   3 8                 11
479880 OK LOVE   school 4029850 43-I004   THACKERVILLE 402985002833 505 THACKERVILLE MS Middle Regular School No Middle 06 08 2017   grade_7 12 0 2 2   1     0   8   17 8                       25 12 0 2 2   1     0   8   17 8                 25
479908 OK LOVE   school 4018990 43-I016   MARIETTA 401899000901 500 MARIETTA MS Middle Regular School No Middle 06 08 2017   grade_7 32 0 29 3   0     0   3   34 33                       67 32 0 29 3   0     0   3   34 33                 67
479920 OK MAJOR   school 4025920 44-I001   RINGWOOD 402592001375 105 RINGWOOD ES Elementary Regular School No Elementary PK 08 2017   grade_7 19 0 10 1   0     0   0   14 16                       30 19 0 10 1   0     0   0   14 16                 30
479935 OK MAJOR   school 4002720 44-I004   ALINE-CLEO 400272000022 105 ALINE-CLEO ES Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 1 0   0     0   2   6 2                       8 5 0 1 0   0     0   2   6 2                 8
479954 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000537 510 CHAMBERLAIN MS Middle Regular School No Middle 06 08 2017   grade_7 47 0 1 4   0     0   0   24 28                       52 47 0 1 4   0     0   0   24 28                 52
479998 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659001948 505 KINGSTON MS Middle Regular School No Middle 06 08 2017   grade_7 35 0 4 45   0     0   8   45 47                       92 35 0 4 45   0     0   8   45 47                 92
480010 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 4 0 0 6   0     0   0   5 5                       10 4 0 0 6   0     0   0   5 5                 10
480020 OK MAYES   school 4023190 46-C043   OSAGE 402319001231 105 OSAGE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 5   0     0   0   6 7                       13 8 0 0 5   0     0   0   6 7                 13
480063 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2017   grade_7 31 0 1 38   0     0   1   38 33                       71 31 0 1 38   0     0   1   38 33                 71
480077 OK MAYES   school 4026730 46-I016   SALINA 402673002005 505 SALINA MS Middle Regular School No Middle 06 08 2017   grade_7 18 0 1 31   0     0   2   28 24                       52 18 0 1 31   0     0   2   28 24                 52
480110 OK MAYES   school 4007670 46-I032   CHOUTEAU-MAZIE 400767000319 110 MAZIE ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 2   0     0   0   2 3                       5 3 0 0 2   0     0   0   2 3                 5
480119 OK MAYES   school 4007670 46-I032   CHOUTEAU-MAZIE 400767000318 505 CHOUTEAU-MAZIE MS Middle Regular School No Middle 06 08 2017   grade_7 25 0 0 18   0     0   9   29 23                       52 25 0 0 18   0     0   9   29 23                 52
480164 OK MCCLAIN   school 4031710 47-I005   WASHINGTON 403171002087 510 WASHINGTON MS Middle Regular School No Middle 06 08 2017   grade_7 52 0 5 11   0     0   1   35 34                       69 52 0 5 11   0     0   1   35 34                 69
480178 OK MCCLAIN   school 4032010 47-I010   WAYNE 403201029699 505 WAYNE MS Middle Regular School No Middle 06 08 2017   grade_7 21 0 8 3   0     0   4   21 15                       36 21 0 8 3   0     0   4   21 15                 36
480195 OK MCCLAIN   school 4025230 47-I015   PURCELL 402523002239 610 PURCELL JHS Junior High Regular School No Middle 06 08 2017   grade_7 44 0 25 11   1     0   6   44 43                       87 44 0 25 11   1     0   6   44 43                 87
480242 OK MCCURTAIN   school 4012750 48-C023   GLOVER 401275000595 105 GLOVER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 0 2   0     0   0   2 5                       7 5 0 0 2   0     0   0   2 5                 7
480262 OK MCCURTAIN   school 4014890 48-C072   HOLLY CREEK 401489000702 105 HOLLY CREEK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 3 6   0     0   1   11 13                       24 14 0 3 6   0     0   1   11 13                 24
480314 OK MCCURTAIN   school 4010440 48-I013   EAGLETOWN 401044000464 105 EAGLETOWN ES Elementary Regular School No Elementary PK 08 2017   grade_7 7 0 0 4   0     0   0   8 3                       11 7 0 0 4   0     0   0   8 3                 11
480330 OK MCCURTAIN   school 4027840 48-I014   SMITHVILLE 402784001855 505 SMITHVILLE MS Middle Regular School No Middle 06 08 2017   grade_7 9 0 0 6   0     0   0   6 9                       15 9 0 0 6   0     0   0   6 9                 15
480356 OK MCCURTAIN   school 4003660 48-I071   BATTIEST 400366000112 105 BATTIEST ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 0 13   0     0   0   11 8                       19 6 0 0 13   0     0   0   11 8                 19
480385 OK MCINTOSH   school 4026580 49-C003   RYAL 402658001392 105 RYAL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 2 3   0     0   0   3 2                       5 0 0 2 3   0     0   0   3 2                 5
480394 OK MCINTOSH   school 4028620 49-C016   STIDHAM 402862001501 105 STIDHAM PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 4 0 1 7   0     0   1   5 8                       13 4 0 1 7   0     0   1   5 8                 13
480449 OK MCINTOSH   school 4013680 49-I064   HANNA 401368000649 105 HANNA ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 1 3   0     0   0   4 3                       7 3 0 1 3   0     0   0   4 3                 7
480530 OK MUSKOGEE   school 4032130 51-I006   WEBBERS FALLS 403213001779 105 WEBBERS FALLS ES Elementary Regular School No Elementary PK 08 2017   grade_7 4 0 1 13   0     0   0   7 11                       18 4 0 1 13   0     0   0   7 11                 18
480544 OK MUSKOGEE   school 4022830 51-I008   OKTAHA 402283001215 110 OKTAHA ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 0 30   0     0   2   25 21                       46 14 0 0 30   0     0   2   25 21                 46
480650 OK MUSKOGEE   school 4005280 51-I046   BRAGGS 400528000185 105 BRAGGS ES Elementary Regular School No Elementary PK 08 2017   grade_7 7 0 0 4   0     0   0   0 11                       11 7 0 0 4   0     0   0   0 11                 11
480664 OK MUSKOGEE   school 4031650 51-I074   WARNER 403165001750 105 WARNER ES Elementary Regular School No Elementary PK 08 2017   grade_7 28 0 1 31   0     0   6   36 30                       66 28 0 1 31   0     0   6   36 30                 66
480678 OK MUSKOGEE   school 4024840 51-I088   PORUM 402484001306 105 PORUM ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 0 20   0     0   1   17 16                       33 12 0 0 20   0     0   1   17 16                 33
480695 OK NOBLE   school 4023850 52-I001   PERRY 402385002701 605 PERRY JHS Junior High Regular School No Middle 07 08 2017   grade_7 58 0 5 3   1     0   1   31 37                       68 58 0 5 3   1     0   1   31 37                 68
480707 OK NOBLE   school 4004360 52-I002   BILLINGS 400436000140 105 BILLINGS ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
480721 OK NOBLE   school 4000020 52-I004   FRONTIER 400002025620 105 FRONTIER ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 2 16   1     0   0   17 14                       31 12 0 2 16   1     0   0   17 14                 31
480739 OK NOBLE   school 4020340 52-I006   MORRISON 402034002657 510 MORRISON MS Middle Regular School No Middle 07 08 2017   grade_7 36 0 1 1   0     1   13   29 23                       52 36 0 1 1   0     1   13   29 23                 52
480755 OK NOWATA   school 4000021 53-I003   OKLAHOMA UNION 400002102290 505 OKLAHOMA UNION MS Middle Regular School No Middle 06 08 2017   grade_7 29 0 2 19   0     0   6   26 30                       56 29 0 2 19   0     0   6   26 30                 56
480782 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001395 105 SOUTH COFFEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 0 3   0     1   0   10 7                       17 13 0 0 3   0     1   0   10 7                 17
480796 OK OKFUSKEE   school 4003690 54-C029   BEARDEN 400369000114 105 BEARDEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 3   0     0   4   5 2                       7 0 0 0 3   0     0   4   5 2                 7
480850 OK OKFUSKEE   school 4032220 54-I031   WELEETKA 403222001180 610 WELEETKA JHS Junior High Regular School No Other 07 09 2017   grade_7 11 0 1 5   0     0   3   13 7                       20 11 0 1 5   0     0   3   13 7                 20
480858 OK OKFUSKEE   school 4000782 54-I054   GRAHAM-DUSTIN 400078200608 105 GRAHAM ES Elementary Regular School No Middle 05 08 2017   grade_7 6 0 1 5   0     1   2   7 8                       15 6 0 1 5   0     1   2   7 8                 15
482033 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001885 706 CLASSEN HS OF ADVANCED STUDIES High School Regular School No Other 06 12 2017   grade_7 0 0 1 0   0     0   0   0 1                       1 0 0 1 0   0     0   0   0 1                 1

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