ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Custer" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955058 | 955058 | 2021-01-22 | Custer | Oklahoma | 40039 | 3596 | 48 |
951813 | 951813 | 2021-01-21 | Custer | Oklahoma | 40039 | 3582 | 44 |
948568 | 948568 | 2021-01-20 | Custer | Oklahoma | 40039 | 3571 | 40 |
945322 | 945322 | 2021-01-19 | Custer | Oklahoma | 40039 | 3563 | 39 |
942075 | 942075 | 2021-01-18 | Custer | Oklahoma | 40039 | 3553 | 39 |
938830 | 938830 | 2021-01-17 | Custer | Oklahoma | 40039 | 3544 | 39 |
935585 | 935585 | 2021-01-16 | Custer | Oklahoma | 40039 | 3527 | 39 |
932340 | 932340 | 2021-01-15 | Custer | Oklahoma | 40039 | 3520 | 39 |
929095 | 929095 | 2021-01-14 | Custer | Oklahoma | 40039 | 3497 | 39 |
925850 | 925850 | 2021-01-13 | Custer | Oklahoma | 40039 | 3485 | 38 |
922604 | 922604 | 2021-01-12 | Custer | Oklahoma | 40039 | 3407 | 38 |
919359 | 919359 | 2021-01-11 | Custer | Oklahoma | 40039 | 3402 | 38 |
916114 | 916114 | 2021-01-10 | Custer | Oklahoma | 40039 | 3368 | 38 |
912869 | 912869 | 2021-01-09 | Custer | Oklahoma | 40039 | 3279 | 38 |
909624 | 909624 | 2021-01-08 | Custer | Oklahoma | 40039 | 3252 | 38 |
906379 | 906379 | 2021-01-07 | Custer | Oklahoma | 40039 | 3226 | 37 |
903133 | 903133 | 2021-01-06 | Custer | Oklahoma | 40039 | 3206 | 35 |
899888 | 899888 | 2021-01-05 | Custer | Oklahoma | 40039 | 3186 | 34 |
896643 | 896643 | 2021-01-04 | Custer | Oklahoma | 40039 | 3180 | 32 |
893397 | 893397 | 2021-01-03 | Custer | Oklahoma | 40039 | 3156 | 31 |
890151 | 890151 | 2021-01-02 | Custer | Oklahoma | 40039 | 3029 | 31 |
886904 | 886904 | 2021-01-01 | Custer | Oklahoma | 40039 | 2981 | 31 |
883659 | 883659 | 2020-12-31 | Custer | Oklahoma | 40039 | 2981 | 31 |
880414 | 880414 | 2020-12-30 | Custer | Oklahoma | 40039 | 2928 | 31 |
877169 | 877169 | 2020-12-29 | Custer | Oklahoma | 40039 | 2895 | 31 |
873924 | 873924 | 2020-12-28 | Custer | Oklahoma | 40039 | 2894 | 31 |
870679 | 870679 | 2020-12-27 | Custer | Oklahoma | 40039 | 2875 | 31 |
867434 | 867434 | 2020-12-26 | Custer | Oklahoma | 40039 | 2848 | 31 |
864189 | 864189 | 2020-12-25 | Custer | Oklahoma | 40039 | 2786 | 30 |
860944 | 860944 | 2020-12-24 | Custer | Oklahoma | 40039 | 2786 | 30 |
857699 | 857699 | 2020-12-23 | Custer | Oklahoma | 40039 | 2727 | 28 |
854454 | 854454 | 2020-12-22 | Custer | Oklahoma | 40039 | 2690 | 27 |
851209 | 851209 | 2020-12-21 | Custer | Oklahoma | 40039 | 2672 | 27 |
847964 | 847964 | 2020-12-20 | Custer | Oklahoma | 40039 | 2639 | 27 |
844719 | 844719 | 2020-12-19 | Custer | Oklahoma | 40039 | 2597 | 26 |
841473 | 841473 | 2020-12-18 | Custer | Oklahoma | 40039 | 2579 | 25 |
838228 | 838228 | 2020-12-17 | Custer | Oklahoma | 40039 | 2559 | 25 |
834982 | 834982 | 2020-12-16 | Custer | Oklahoma | 40039 | 2551 | 21 |
831736 | 831736 | 2020-12-15 | Custer | Oklahoma | 40039 | 2536 | 20 |
828489 | 828489 | 2020-12-14 | Custer | Oklahoma | 40039 | 2520 | 19 |
825243 | 825243 | 2020-12-13 | Custer | Oklahoma | 40039 | 2503 | 19 |
821996 | 821996 | 2020-12-12 | Custer | Oklahoma | 40039 | 2413 | 19 |
818750 | 818750 | 2020-12-11 | Custer | Oklahoma | 40039 | 2381 | 18 |
815504 | 815504 | 2020-12-10 | Custer | Oklahoma | 40039 | 2344 | 18 |
812258 | 812258 | 2020-12-09 | Custer | Oklahoma | 40039 | 2331 | 18 |
809014 | 809014 | 2020-12-08 | Custer | Oklahoma | 40039 | 2304 | 18 |
805769 | 805769 | 2020-12-07 | Custer | Oklahoma | 40039 | 2283 | 18 |
802524 | 802524 | 2020-12-06 | Custer | Oklahoma | 40039 | 2264 | 18 |
799279 | 799279 | 2020-12-05 | Custer | Oklahoma | 40039 | 2236 | 18 |
796034 | 796034 | 2020-12-04 | Custer | Oklahoma | 40039 | 2198 | 17 |
792789 | 792789 | 2020-12-03 | Custer | Oklahoma | 40039 | 2146 | 17 |
789544 | 789544 | 2020-12-02 | Custer | Oklahoma | 40039 | 2083 | 16 |
786299 | 786299 | 2020-12-01 | Custer | Oklahoma | 40039 | 2043 | 16 |
783055 | 783055 | 2020-11-30 | Custer | Oklahoma | 40039 | 2031 | 16 |
779809 | 779809 | 2020-11-29 | Custer | Oklahoma | 40039 | 1987 | 16 |
776564 | 776564 | 2020-11-28 | Custer | Oklahoma | 40039 | 1948 | 14 |
773319 | 773319 | 2020-11-27 | Custer | Oklahoma | 40039 | 1883 | 14 |
770074 | 770074 | 2020-11-26 | Custer | Oklahoma | 40039 | 1839 | 12 |
766828 | 766828 | 2020-11-25 | Custer | Oklahoma | 40039 | 1839 | 12 |
763583 | 763583 | 2020-11-24 | Custer | Oklahoma | 40039 | 1769 | 11 |
760338 | 760338 | 2020-11-23 | Custer | Oklahoma | 40039 | 1736 | 11 |
757093 | 757093 | 2020-11-22 | Custer | Oklahoma | 40039 | 1688 | 11 |
753846 | 753846 | 2020-11-21 | Custer | Oklahoma | 40039 | 1635 | 11 |
750600 | 750600 | 2020-11-20 | Custer | Oklahoma | 40039 | 1598 | 11 |
747354 | 747354 | 2020-11-19 | Custer | Oklahoma | 40039 | 1528 | 11 |
744108 | 744108 | 2020-11-18 | Custer | Oklahoma | 40039 | 1504 | 11 |
740861 | 740861 | 2020-11-17 | Custer | Oklahoma | 40039 | 1486 | 11 |
737615 | 737615 | 2020-11-16 | Custer | Oklahoma | 40039 | 1471 | 11 |
734371 | 734371 | 2020-11-15 | Custer | Oklahoma | 40039 | 1433 | 11 |
731125 | 731125 | 2020-11-14 | Custer | Oklahoma | 40039 | 1387 | 11 |
727881 | 727881 | 2020-11-13 | Custer | Oklahoma | 40039 | 1374 | 9 |
724637 | 724637 | 2020-11-12 | Custer | Oklahoma | 40039 | 1353 | 8 |
721394 | 721394 | 2020-11-11 | Custer | Oklahoma | 40039 | 1344 | 7 |
718151 | 718151 | 2020-11-10 | Custer | Oklahoma | 40039 | 1337 | 7 |
714908 | 714908 | 2020-11-09 | Custer | Oklahoma | 40039 | 1305 | 7 |
711664 | 711664 | 2020-11-08 | Custer | Oklahoma | 40039 | 1268 | 7 |
708420 | 708420 | 2020-11-07 | Custer | Oklahoma | 40039 | 1268 | 7 |
705177 | 705177 | 2020-11-06 | Custer | Oklahoma | 40039 | 1185 | 7 |
701934 | 701934 | 2020-11-05 | Custer | Oklahoma | 40039 | 1168 | 7 |
698690 | 698690 | 2020-11-04 | Custer | Oklahoma | 40039 | 1147 | 7 |
695447 | 695447 | 2020-11-03 | Custer | Oklahoma | 40039 | 1142 | 7 |
692205 | 692205 | 2020-11-02 | Custer | Oklahoma | 40039 | 1136 | 7 |
688961 | 688961 | 2020-11-01 | Custer | Oklahoma | 40039 | 1129 | 7 |
685716 | 685716 | 2020-10-31 | Custer | Oklahoma | 40039 | 1125 | 6 |
682473 | 682473 | 2020-10-30 | Custer | Oklahoma | 40039 | 1114 | 6 |
679230 | 679230 | 2020-10-29 | Custer | Oklahoma | 40039 | 1109 | 6 |
675987 | 675987 | 2020-10-28 | Custer | Oklahoma | 40039 | 1104 | 6 |
672744 | 672744 | 2020-10-27 | Custer | Oklahoma | 40039 | 1092 | 6 |
669502 | 669502 | 2020-10-26 | Custer | Oklahoma | 40039 | 1085 | 4 |
666258 | 666258 | 2020-10-25 | Custer | Oklahoma | 40039 | 1084 | 4 |
663013 | 663013 | 2020-10-24 | Custer | Oklahoma | 40039 | 1081 | 4 |
659769 | 659769 | 2020-10-23 | Custer | Oklahoma | 40039 | 1046 | 3 |
656525 | 656525 | 2020-10-22 | Custer | Oklahoma | 40039 | 1035 | 3 |
653280 | 653280 | 2020-10-21 | Custer | Oklahoma | 40039 | 1011 | 3 |
650035 | 650035 | 2020-10-20 | Custer | Oklahoma | 40039 | 999 | 3 |
646791 | 646791 | 2020-10-19 | Custer | Oklahoma | 40039 | 991 | 3 |
643545 | 643545 | 2020-10-18 | Custer | Oklahoma | 40039 | 991 | 3 |
640297 | 640297 | 2020-10-17 | Custer | Oklahoma | 40039 | 981 | 3 |
637051 | 637051 | 2020-10-16 | Custer | Oklahoma | 40039 | 974 | 3 |
633805 | 633805 | 2020-10-15 | Custer | Oklahoma | 40039 | 968 | 2 |
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);