Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 2,956
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
475513 OK ADAIR   school 4010560 01-C019   PEAVINE 401056000470 105 PEAVINE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 7 1 0 4   0     0   0   7 5                       12 7 1 0 4   0     0   0   7 5                 12
475533 OK ADAIR   school 4026250 01-C024   ROCKY MOUNTAIN 402625001381 105 ROCKY MOUNTAIN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 2 0 0 13   0     0   0   9 6                       15 2 0 0 13   0     0   0   9 6                 15
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
475563 OK ADAIR   school 4021870 01-C032   GREASY 402187001091 105 GREASY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 10   0     0   0   4 7                       11 1 0 0 10   0     0   0   4 7                 11
475617 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2017   grade_7 1 0 0 9   0     0   0   7 3                       10 1 0 0 9   0     0   0   7 3                 10
475658 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301028 105 TIMBERLAKE ES Elementary Regular School No Elementary PK 08 2017   grade_7 16 0 0 0   0     0   1   14 3                       17 16 0 0 0   0     0   1   14 3                 17
475672 OK ATOKA   school 4013830 03-C021   HARMONY 401383000653 105 HARMONY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 8   0     0   0   5 11                       16 8 0 0 8   0     0   0   5 11                 16
475693 OK ATOKA   school 4029010 03-I007   STRINGTOWN 402901001521 105 STRINGTOWN ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 7   0     0   0   3 7                       10 3 0 0 7   0     0   0   3 7                 10
475979 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2017   grade_7 30 0 0 12   0     1   3   24 22                       46 30 0 0 12   0     1   3   24 22                 46
476135 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 7   0     0   1   4 5                       9 1 0 0 7   0     0   1   4 5                 9
476179 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2017   grade_7 13 0 0 4   0     0   2   9 10                       19 13 0 0 4   0     0   2   9 10                 19
476191 OK CADDO   school 4033603 08-I168   BINGER-ONEY 403360329845 105 BINGER-ONEY ES Elementary Regular School No Elementary PK 08 2017   grade_7 21 1 0 7   0     0   3   15 17                       32 21 1 0 7   0     0   3   15 17                 32
476236 OK CANADIAN   school 4018900 09-C162   MAPLE 401890000897 105 MAPLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   3   5 9                       14 11 0 0 0   0     0   3   5 9                 14
476501 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 0 14   0     0   0   13 14                       27 13 0 0 14   0     0   0   13 14                 27
476529 OK CARTER   school 4012060 10-I074   FOX 401206000562 105 FOX ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 3 0 3   0     0   2   12 10                       22 14 3 0 3   0     0   2   12 10                 22
476567 OK CHEROKEE   school 4021900 11-C014   NORWOOD 402190001092 105 NORWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 6 1 0 10   0     0   3   7 13                       20 6 1 0 10   0     0   3   7 13                 20
476577 OK CHEROKEE   school 4033090 11-C021   WOODALL 403309001819 105 WOODALL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 0 27   0     0   6   21 23                       44 11 0 0 27   0     0   6   21 23                 44
476597 OK CHEROKEE   school 4023730 11-C031   PEGGS 402373001258 105 PEGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 19   0     0   0   12 10                       22 3 0 0 19   0     0   0   12 10                 22
476628 OK CHEROKEE   school 4029670 11-C066   TENKILLER 402967001559 105 TENKILLER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 20   0     0   0   15 13                       28 8 0 0 20   0     0   0   15 13                 28
476638 OK CHEROKEE   school 4000033 11-I006   KEYS 400003302299 105 KEYS ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 1 0 30   0     0   2   21 25                       46 13 1 0 30   0     0   2   21 25                 46
476695 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_7 0 0 0 20   0     0   1   9 12                       21 0 0 0 20   0     0   1   9 12                 21
476705 OK CHOCTAW   school 4029340 12-C021   SWINK 402934001540 105 SWINK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 2   0     0   0   5 5                       10 8 0 0 2   0     0   0   5 5                 10
476731 OK CHOCTAW   school 4012300 12-I002   FORT TOWSON 401230002790 605 FORT TOWSON JHS Junior High Regular School No Middle 07 08 2017   grade_7 22 1 0 10   0     0   6   13 26                       39 22 1 0 10   0     0   6   13 26                 39
476743 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 0 9   0     0   1   11 13                       24 14 0 0 9   0     0   1   11 13                 24
476814 OK CLEVELAND   school 4026100 14-C016   ROBIN HILL 402610001380 105 ROBIN HILL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 15 0 0 3   0     0   0   8 10                       18 15 0 0 3   0     0   0   8 10                 18
477233 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002118 710 NORMAN NORTH HS High School Regular School No High 07 12 2017   grade_7 1 0 0 1   0     0   0   2 0                       2 1 0 0 1   0     0   0   2 0                 2
477642 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 1   0     0   1   2 1                       3 1 0 0 1   0     0   1   2 1                 3
477654 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2017   grade_7 17 0 0 19   0     0   0   19 17                       36 17 0 0 19   0     0   0   19 17                 36
477683 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2017   grade_7 5 0 0 10   0     0   3   9 9                       18 5 0 0 10   0     0   3   9 9                 18
477720 OK CREEK   school 4013600 19-C012   GYPSY 401360000643 105 GYPSY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 0   0     0   1   2 0                       2 1 0 0 0   0     0   1   2 0                 2
477824 OK CREEK   school 4022560 19-I020   OILTON 402256001102 105 J. F. KENNEDY ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 0 7   0     0   1   9 8                       17 9 0 0 7   0     0   1   9 8                 17
477838 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 0 0 5   0     0   1   12 12                       24 18 0 0 5   0     0   1   12 12                 24
477974 OK DELAWARE   school 4008010 21-C006   CLEORA 400801000330 105 CLEORA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 0 6   0     0   0   3 8                       11 5 0 0 6   0     0   0   3 8                 11
477994 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 6   0     0   0   5 1                       6 0 0 0 6   0     0   0   5 1                 6
478003 OK DELAWARE   school 4020430 21-C034   MOSELEY 402043001012 105 MOSELEY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 7 3 0 10   0     0   0   12 8                       20 7 3 0 10   0     0   0   12 8                 20
478046 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2017   grade_7 24 1 0 28   0     0   2   25 30                       55 24 1 0 28   0     0   2   25 30                 55
478060 OK DELAWARE   school 4008250 21-I004   COLCORD 400825000345 105 COLCORD ES Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 2   0     0   0   2 0                       2 0 0 0 2   0     0   0   2 0                 2
478123 OK DEWEY   school 4029430 22-I010   TALOGA 402943001549 105 TALOGA ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 1   0     0   0   0 2                       2 1 0 0 1   0     0   0   0 2                 2
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
478550 OK GRADY   school 4021600 26-I051   NINNEKAH 402160001673 510 NINNEKAH MS Middle Regular School No Middle 06 08 2017   grade_7 24 2 0 3   0     0   5   20 14                       34 24 2 0 3   0     0   5   20 14                 34
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
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
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
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
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
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
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
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
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
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
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
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
479470 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 1 0 16   0     0   1   10 9                       19 1 1 0 16   0     0   1   10 9                 19
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
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
479781 OK LINCOLN   school 4006690 41-I105   CARNEY 400669000261 105 CARNEY ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 1 0 2   0     0   0   7 14                       21 18 1 0 2   0     0   0   7 14                 21
479967 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2017   grade_7 25 1 0 1   0     0   0   6 21                       27 25 1 0 1   0     0   0   6 21                 27
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
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
480222 OK MCCURTAIN   school 4011850 48-C001   FOREST GROVE 401185000552 105 FOREST GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 6 1 0 5   0     0   0   6 6                       12 6 1 0 5   0     0   0   6 6                 12
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
480288 OK MCCURTAIN   school 4014080 48-I006   HAWORTH 401408000664 510 HAWORTH MS Middle Regular School No Middle 06 08 2017   grade_7 20 6 0 18   1     0   0   22 23                       45 20 6 0 18   1     0   0   22 23                 45
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
480344 OK MCCURTAIN   school 4033210 48-I039   WRIGHT CITY 403321029701 610 WRIGHT CITY JHS Junior High Regular School No Middle 07 08 2017   grade_7 14 1 0 13   0     0   0   17 11                       28 14 1 0 13   0     0   0   17 11                 28
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
480435 OK MCINTOSH   school 4014670 49-I027   MIDWAY 401467000687 105 MIDWAY ES Elementary Regular School No Elementary PK 08 2017   grade_7 15 5 0 4   0     0   1   13 12                       25 15 5 0 4   0     0   1   13 12                 25
480492 OK MUSKOGEE   school 4031380 51-C009   WAINWRIGHT 403138001738 105 WAINWRIGHT PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 1 0 7   0     0   0   5 6                       11 3 1 0 7   0     0   0   5 6                 11
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
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
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
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
480806 OK OKFUSKEE   school 4019260 54-I002   MASON 401926000909 105 MASON ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 1 0 7   0     0   7   12 15                       27 12 1 0 7   0     0   7   12 15                 27
482217 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002811 971 ABLE CHARTER SCHOOL 6TH-8TH Charter (Virtual) Regular School Yes Middle 06 08 2017   grade_7 1 1 0 1   0     0   0   2 1                       3 1 1 0 1   0     0   0   2 1                 3
482309 OK OKMULGEE   school 4027090 56-I006   SCHULTER 402709001434 105 SCHULTER ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 0 2   0     0   0   5 3                       8 6 0 0 2   0     0   0   5 3                 8
482339 OK OKMULGEE   school 4009780 56-I008   DEWAR 400978002785 515 DEWAR MS Middle Regular School No Middle 06 08 2017   grade_7 12 2 0 20   0     0   0   17 17                       34 12 2 0 20   0     0   0   17 17                 34
482351 OK OSAGE   school 4023220 57-C003   OSAGE HILLS 402322001232 105 OSAGE HILLS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 1 0 6   0     0   0   8 4                       12 5 1 0 6   0     0   0   8 4                 12
482371 OK OSAGE   school 4003450 57-C035   AVANT 400345000088 105 AVANT PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 3   0     0   1   3 4                       7 3 0 0 3   0     0   1   3 4                 7
482399 OK OSAGE   school 4023580 57-I002   PAWHUSKA 402358001251 115 PAWHUSKA ES Elementary Regular School No Elementary 03 08 2017   grade_7 21 3 0 36   0     0   2   33 29                       62 21 3 0 36   0     0   2   33 29                 62
482415 OK OSAGE   school 4027630 57-I011   SHIDLER 402763002689 505 SHIDLER MS Middle Regular School No Middle 05 08 2017   grade_7 7 0 0 4   0     0   2   2 11                       13 7 0 0 4   0     0   2   2 11                 13
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
482645 OK PAYNE   school 4022160 60-C104   OAK GROVE 402216001097 105 OAK GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 0 1   0     0   0   6 8                       14 13 0 0 1   0     0   0   6 8                 14
482753 OK PAYNE   school 4012690 60-I101   GLENCOE 401269000591 105 GLENCOE ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 0 4   1     0   2   17 3                       20 13 0 0 4   1     0   2   17 3                 20
482812 OK PITTSBURG   school 4014100 61-C088   HAYWOOD 401410000665 105 HAYWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 2 0 0 6   0     0   1   5 4                       9 2 0 0 6   0     0   1   5 4                 9
482851 OK PITTSBURG   school 4000795 61-E020   CANADIAN 400079502830 972 CARLTON LANDING ACADEMY CHARTR Charter Regular School Yes Other PK 12 2017   grade_7 2 0 0 0   0     0   0   2 0                       2 2 0 0 0   0     0   0   2 0                 2
482862 OK PITTSBURG   school 4013620 61-I011   HAILEYVILLE 401362000644 105 HAILEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 0 11   0     0   0   7 13                       20 9 0 0 11   0     0   0   7 13                 20
482876 OK PITTSBURG   school 4016650 61-I014   KIOWA 401665000777 105 KIOWA ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 0 11   0     0   0   12 10                       22 11 0 0 11   0     0   0   12 10                 22
482947 OK PITTSBURG   school 4024180 61-I063   PITTSBURG 402418001275 105 PITTSBURG ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 2   0     0   0   7 3                       10 8 0 0 2   0     0   0   7 3                 10
483067 OK PONTOTOC   school 4028800 62-I030   STONEWALL 402880002389 515 MCLISH MS Middle Regular School No Middle 05 08 2017   grade_7 17 1 0 11   0     0   1   13 17                       30 17 1 0 11   0     0   1   13 17                 30
483079 OK PONTOTOC   school 4026280 62-I037   ROFF 402628001382 105 ROFF ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 0 9   0     0   0   12 11                       23 14 0 0 9   0     0   0   12 11                 23
483115 OK POTTAWATOMIE   school 4024330 63-C029   PLEASANT GROVE 402433001281 105 PLEASANT GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 4 1 0 10   0     0   2   7 10                       17 4 1 0 10   0     0   2   7 10                 17
483125 OK POTTAWATOMIE   school 4027990 63-C032   SOUTH ROCK CREEK 402799001486 105 SOUTH ROCK CREEK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 16 1 0 13   0     0   1   18 13                       31 16 1 0 13   0     0   1   18 13                 31

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