ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 40053 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195284 | 1195284 | 2021-04-06 | Grant | Oklahoma | 40053 | 548 | 7 |
1192036 | 1192036 | 2021-04-05 | Grant | Oklahoma | 40053 | 548 | 7 |
1188787 | 1188787 | 2021-04-04 | Grant | Oklahoma | 40053 | 548 | 7 |
1185540 | 1185540 | 2021-04-03 | Grant | Oklahoma | 40053 | 548 | 7 |
1182293 | 1182293 | 2021-04-02 | Grant | Oklahoma | 40053 | 548 | 7 |
1179046 | 1179046 | 2021-04-01 | Grant | Oklahoma | 40053 | 548 | 7 |
1175799 | 1175799 | 2021-03-31 | Grant | Oklahoma | 40053 | 548 | 7 |
1172552 | 1172552 | 2021-03-30 | Grant | Oklahoma | 40053 | 547 | 7 |
1169305 | 1169305 | 2021-03-29 | Grant | Oklahoma | 40053 | 547 | 7 |
1166057 | 1166057 | 2021-03-28 | Grant | Oklahoma | 40053 | 547 | 7 |
1162809 | 1162809 | 2021-03-27 | Grant | Oklahoma | 40053 | 547 | 7 |
1159560 | 1159560 | 2021-03-26 | Grant | Oklahoma | 40053 | 547 | 7 |
1156313 | 1156313 | 2021-03-25 | Grant | Oklahoma | 40053 | 547 | 7 |
1153066 | 1153066 | 2021-03-24 | Grant | Oklahoma | 40053 | 547 | 7 |
1149819 | 1149819 | 2021-03-23 | Grant | Oklahoma | 40053 | 543 | 7 |
1146572 | 1146572 | 2021-03-22 | Grant | Oklahoma | 40053 | 543 | 7 |
1143325 | 1143325 | 2021-03-21 | Grant | Oklahoma | 40053 | 543 | 7 |
1140078 | 1140078 | 2021-03-20 | Grant | Oklahoma | 40053 | 543 | 7 |
1136832 | 1136832 | 2021-03-19 | Grant | Oklahoma | 40053 | 543 | 7 |
1133586 | 1133586 | 2021-03-18 | Grant | Oklahoma | 40053 | 543 | 7 |
1130338 | 1130338 | 2021-03-17 | Grant | Oklahoma | 40053 | 543 | 7 |
1127091 | 1127091 | 2021-03-16 | Grant | Oklahoma | 40053 | 543 | 7 |
1123845 | 1123845 | 2021-03-15 | Grant | Oklahoma | 40053 | 543 | 7 |
1120599 | 1120599 | 2021-03-14 | Grant | Oklahoma | 40053 | 543 | 7 |
1117352 | 1117352 | 2021-03-13 | Grant | Oklahoma | 40053 | 542 | 7 |
1114105 | 1114105 | 2021-03-12 | Grant | Oklahoma | 40053 | 542 | 7 |
1110859 | 1110859 | 2021-03-11 | Grant | Oklahoma | 40053 | 542 | 7 |
1107613 | 1107613 | 2021-03-10 | Grant | Oklahoma | 40053 | 541 | 7 |
1104367 | 1104367 | 2021-03-09 | Grant | Oklahoma | 40053 | 540 | 7 |
1101121 | 1101121 | 2021-03-08 | Grant | Oklahoma | 40053 | 540 | 7 |
1097875 | 1097875 | 2021-03-07 | Grant | Oklahoma | 40053 | 540 | 7 |
1094627 | 1094627 | 2021-03-06 | Grant | Oklahoma | 40053 | 538 | 7 |
1091381 | 1091381 | 2021-03-05 | Grant | Oklahoma | 40053 | 538 | 7 |
1088135 | 1088135 | 2021-03-04 | Grant | Oklahoma | 40053 | 538 | 7 |
1084890 | 1084890 | 2021-03-03 | Grant | Oklahoma | 40053 | 536 | 7 |
1081644 | 1081644 | 2021-03-02 | Grant | Oklahoma | 40053 | 535 | 7 |
1078398 | 1078398 | 2021-03-01 | Grant | Oklahoma | 40053 | 535 | 7 |
1075153 | 1075153 | 2021-02-28 | Grant | Oklahoma | 40053 | 535 | 7 |
1071907 | 1071907 | 2021-02-27 | Grant | Oklahoma | 40053 | 534 | 7 |
1068661 | 1068661 | 2021-02-26 | Grant | Oklahoma | 40053 | 534 | 7 |
1065416 | 1065416 | 2021-02-25 | Grant | Oklahoma | 40053 | 534 | 7 |
1062172 | 1062172 | 2021-02-24 | Grant | Oklahoma | 40053 | 533 | 7 |
1058926 | 1058926 | 2021-02-23 | Grant | Oklahoma | 40053 | 533 | 7 |
1055680 | 1055680 | 2021-02-22 | Grant | Oklahoma | 40053 | 531 | 7 |
1052434 | 1052434 | 2021-02-21 | Grant | Oklahoma | 40053 | 531 | 7 |
1049187 | 1049187 | 2021-02-20 | Grant | Oklahoma | 40053 | 531 | 7 |
1045940 | 1045940 | 2021-02-19 | Grant | Oklahoma | 40053 | 528 | 7 |
1042695 | 1042695 | 2021-02-18 | Grant | Oklahoma | 40053 | 525 | 7 |
1039450 | 1039450 | 2021-02-17 | Grant | Oklahoma | 40053 | 524 | 7 |
1036205 | 1036205 | 2021-02-16 | Grant | Oklahoma | 40053 | 524 | 7 |
1032960 | 1032960 | 2021-02-15 | Grant | Oklahoma | 40053 | 523 | 7 |
1029714 | 1029714 | 2021-02-14 | Grant | Oklahoma | 40053 | 522 | 7 |
1026467 | 1026467 | 2021-02-13 | Grant | Oklahoma | 40053 | 520 | 7 |
1023222 | 1023222 | 2021-02-12 | Grant | Oklahoma | 40053 | 519 | 7 |
1019977 | 1019977 | 2021-02-11 | Grant | Oklahoma | 40053 | 519 | 7 |
1016732 | 1016732 | 2021-02-10 | Grant | Oklahoma | 40053 | 517 | 7 |
1013487 | 1013487 | 2021-02-09 | Grant | Oklahoma | 40053 | 515 | 7 |
1010242 | 1010242 | 2021-02-08 | Grant | Oklahoma | 40053 | 513 | 6 |
1006996 | 1006996 | 2021-02-07 | Grant | Oklahoma | 40053 | 511 | 6 |
1003750 | 1003750 | 2021-02-06 | Grant | Oklahoma | 40053 | 507 | 6 |
1000504 | 1000504 | 2021-02-05 | Grant | Oklahoma | 40053 | 504 | 6 |
997258 | 997258 | 2021-02-04 | Grant | Oklahoma | 40053 | 504 | 6 |
994012 | 994012 | 2021-02-03 | Grant | Oklahoma | 40053 | 504 | 6 |
990766 | 990766 | 2021-02-02 | Grant | Oklahoma | 40053 | 503 | 5 |
987520 | 987520 | 2021-02-01 | Grant | Oklahoma | 40053 | 497 | 5 |
984273 | 984273 | 2021-01-31 | Grant | Oklahoma | 40053 | 497 | 5 |
981026 | 981026 | 2021-01-30 | Grant | Oklahoma | 40053 | 486 | 5 |
977780 | 977780 | 2021-01-29 | Grant | Oklahoma | 40053 | 484 | 5 |
974535 | 974535 | 2021-01-28 | Grant | Oklahoma | 40053 | 483 | 5 |
971290 | 971290 | 2021-01-27 | Grant | Oklahoma | 40053 | 482 | 5 |
968045 | 968045 | 2021-01-26 | Grant | Oklahoma | 40053 | 481 | 5 |
964801 | 964801 | 2021-01-25 | Grant | Oklahoma | 40053 | 479 | 5 |
961556 | 961556 | 2021-01-24 | Grant | Oklahoma | 40053 | 478 | 5 |
958311 | 958311 | 2021-01-23 | Grant | Oklahoma | 40053 | 473 | 5 |
955065 | 955065 | 2021-01-22 | Grant | Oklahoma | 40053 | 468 | 5 |
951820 | 951820 | 2021-01-21 | Grant | Oklahoma | 40053 | 463 | 5 |
948575 | 948575 | 2021-01-20 | Grant | Oklahoma | 40053 | 459 | 5 |
945329 | 945329 | 2021-01-19 | Grant | Oklahoma | 40053 | 457 | 5 |
942082 | 942082 | 2021-01-18 | Grant | Oklahoma | 40053 | 453 | 5 |
938837 | 938837 | 2021-01-17 | Grant | Oklahoma | 40053 | 452 | 5 |
935592 | 935592 | 2021-01-16 | Grant | Oklahoma | 40053 | 446 | 5 |
932347 | 932347 | 2021-01-15 | Grant | Oklahoma | 40053 | 446 | 5 |
929102 | 929102 | 2021-01-14 | Grant | Oklahoma | 40053 | 443 | 5 |
925857 | 925857 | 2021-01-13 | Grant | Oklahoma | 40053 | 443 | 5 |
922611 | 922611 | 2021-01-12 | Grant | Oklahoma | 40053 | 439 | 5 |
919366 | 919366 | 2021-01-11 | Grant | Oklahoma | 40053 | 436 | 5 |
916121 | 916121 | 2021-01-10 | Grant | Oklahoma | 40053 | 432 | 5 |
912876 | 912876 | 2021-01-09 | Grant | Oklahoma | 40053 | 423 | 5 |
909631 | 909631 | 2021-01-08 | Grant | Oklahoma | 40053 | 416 | 5 |
906386 | 906386 | 2021-01-07 | Grant | Oklahoma | 40053 | 412 | 5 |
903140 | 903140 | 2021-01-06 | Grant | Oklahoma | 40053 | 409 | 5 |
899895 | 899895 | 2021-01-05 | Grant | Oklahoma | 40053 | 408 | 5 |
896650 | 896650 | 2021-01-04 | Grant | Oklahoma | 40053 | 405 | 5 |
893404 | 893404 | 2021-01-03 | Grant | Oklahoma | 40053 | 402 | 5 |
890158 | 890158 | 2021-01-02 | Grant | Oklahoma | 40053 | 386 | 5 |
886911 | 886911 | 2021-01-01 | Grant | Oklahoma | 40053 | 380 | 5 |
883666 | 883666 | 2020-12-31 | Grant | Oklahoma | 40053 | 380 | 5 |
880421 | 880421 | 2020-12-30 | Grant | Oklahoma | 40053 | 380 | 5 |
877176 | 877176 | 2020-12-29 | Grant | Oklahoma | 40053 | 375 | 5 |
873931 | 873931 | 2020-12-28 | Grant | Oklahoma | 40053 | 375 | 5 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);