ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Kay" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955074 | 955074 | 2021-01-22 | Kay | Oklahoma | 40071 | 4437 | 52 |
951829 | 951829 | 2021-01-21 | Kay | Oklahoma | 40071 | 4363 | 51 |
948584 | 948584 | 2021-01-20 | Kay | Oklahoma | 40071 | 4338 | 51 |
945338 | 945338 | 2021-01-19 | Kay | Oklahoma | 40071 | 4297 | 48 |
942091 | 942091 | 2021-01-18 | Kay | Oklahoma | 40071 | 4260 | 48 |
938846 | 938846 | 2021-01-17 | Kay | Oklahoma | 40071 | 4235 | 48 |
935601 | 935601 | 2021-01-16 | Kay | Oklahoma | 40071 | 4184 | 47 |
932356 | 932356 | 2021-01-15 | Kay | Oklahoma | 40071 | 4137 | 47 |
929111 | 929111 | 2021-01-14 | Kay | Oklahoma | 40071 | 4045 | 45 |
925866 | 925866 | 2021-01-13 | Kay | Oklahoma | 40071 | 3996 | 44 |
922620 | 922620 | 2021-01-12 | Kay | Oklahoma | 40071 | 3937 | 44 |
919375 | 919375 | 2021-01-11 | Kay | Oklahoma | 40071 | 3913 | 44 |
916130 | 916130 | 2021-01-10 | Kay | Oklahoma | 40071 | 3852 | 44 |
912885 | 912885 | 2021-01-09 | Kay | Oklahoma | 40071 | 3745 | 44 |
909640 | 909640 | 2021-01-08 | Kay | Oklahoma | 40071 | 3700 | 44 |
906395 | 906395 | 2021-01-07 | Kay | Oklahoma | 40071 | 3661 | 43 |
903149 | 903149 | 2021-01-06 | Kay | Oklahoma | 40071 | 3619 | 40 |
899904 | 899904 | 2021-01-05 | Kay | Oklahoma | 40071 | 3540 | 34 |
896659 | 896659 | 2021-01-04 | Kay | Oklahoma | 40071 | 3524 | 34 |
893413 | 893413 | 2021-01-03 | Kay | Oklahoma | 40071 | 3509 | 34 |
890167 | 890167 | 2021-01-02 | Kay | Oklahoma | 40071 | 3374 | 33 |
886920 | 886920 | 2021-01-01 | Kay | Oklahoma | 40071 | 3312 | 33 |
883675 | 883675 | 2020-12-31 | Kay | Oklahoma | 40071 | 3312 | 33 |
880430 | 880430 | 2020-12-30 | Kay | Oklahoma | 40071 | 3232 | 31 |
877185 | 877185 | 2020-12-29 | Kay | Oklahoma | 40071 | 3159 | 31 |
873940 | 873940 | 2020-12-28 | Kay | Oklahoma | 40071 | 3154 | 30 |
870695 | 870695 | 2020-12-27 | Kay | Oklahoma | 40071 | 3125 | 30 |
867450 | 867450 | 2020-12-26 | Kay | Oklahoma | 40071 | 3080 | 30 |
864205 | 864205 | 2020-12-25 | Kay | Oklahoma | 40071 | 3015 | 30 |
860960 | 860960 | 2020-12-24 | Kay | Oklahoma | 40071 | 3015 | 30 |
857715 | 857715 | 2020-12-23 | Kay | Oklahoma | 40071 | 2942 | 30 |
854470 | 854470 | 2020-12-22 | Kay | Oklahoma | 40071 | 2858 | 30 |
851225 | 851225 | 2020-12-21 | Kay | Oklahoma | 40071 | 2836 | 28 |
847980 | 847980 | 2020-12-20 | Kay | Oklahoma | 40071 | 2788 | 28 |
844735 | 844735 | 2020-12-19 | Kay | Oklahoma | 40071 | 2703 | 28 |
841489 | 841489 | 2020-12-18 | Kay | Oklahoma | 40071 | 2635 | 27 |
838244 | 838244 | 2020-12-17 | Kay | Oklahoma | 40071 | 2605 | 27 |
834998 | 834998 | 2020-12-16 | Kay | Oklahoma | 40071 | 2547 | 27 |
831752 | 831752 | 2020-12-15 | Kay | Oklahoma | 40071 | 2448 | 27 |
828505 | 828505 | 2020-12-14 | Kay | Oklahoma | 40071 | 2429 | 27 |
825259 | 825259 | 2020-12-13 | Kay | Oklahoma | 40071 | 2413 | 27 |
822012 | 822012 | 2020-12-12 | Kay | Oklahoma | 40071 | 2342 | 27 |
818766 | 818766 | 2020-12-11 | Kay | Oklahoma | 40071 | 2288 | 27 |
815520 | 815520 | 2020-12-10 | Kay | Oklahoma | 40071 | 2235 | 26 |
812274 | 812274 | 2020-12-09 | Kay | Oklahoma | 40071 | 2189 | 26 |
809030 | 809030 | 2020-12-08 | Kay | Oklahoma | 40071 | 2153 | 26 |
805785 | 805785 | 2020-12-07 | Kay | Oklahoma | 40071 | 2121 | 26 |
802540 | 802540 | 2020-12-06 | Kay | Oklahoma | 40071 | 2107 | 26 |
799295 | 799295 | 2020-12-05 | Kay | Oklahoma | 40071 | 2070 | 26 |
796050 | 796050 | 2020-12-04 | Kay | Oklahoma | 40071 | 2032 | 26 |
792805 | 792805 | 2020-12-03 | Kay | Oklahoma | 40071 | 1970 | 26 |
789560 | 789560 | 2020-12-02 | Kay | Oklahoma | 40071 | 1944 | 25 |
786315 | 786315 | 2020-12-01 | Kay | Oklahoma | 40071 | 1899 | 25 |
783071 | 783071 | 2020-11-30 | Kay | Oklahoma | 40071 | 1891 | 25 |
779825 | 779825 | 2020-11-29 | Kay | Oklahoma | 40071 | 1836 | 25 |
776580 | 776580 | 2020-11-28 | Kay | Oklahoma | 40071 | 1819 | 25 |
773335 | 773335 | 2020-11-27 | Kay | Oklahoma | 40071 | 1727 | 25 |
770090 | 770090 | 2020-11-26 | Kay | Oklahoma | 40071 | 1696 | 25 |
766844 | 766844 | 2020-11-25 | Kay | Oklahoma | 40071 | 1696 | 25 |
763599 | 763599 | 2020-11-24 | Kay | Oklahoma | 40071 | 1619 | 23 |
760354 | 760354 | 2020-11-23 | Kay | Oklahoma | 40071 | 1605 | 22 |
757109 | 757109 | 2020-11-22 | Kay | Oklahoma | 40071 | 1566 | 22 |
753862 | 753862 | 2020-11-21 | Kay | Oklahoma | 40071 | 1513 | 22 |
750616 | 750616 | 2020-11-20 | Kay | Oklahoma | 40071 | 1465 | 22 |
747370 | 747370 | 2020-11-19 | Kay | Oklahoma | 40071 | 1434 | 21 |
744124 | 744124 | 2020-11-18 | Kay | Oklahoma | 40071 | 1344 | 21 |
740877 | 740877 | 2020-11-17 | Kay | Oklahoma | 40071 | 1307 | 20 |
737631 | 737631 | 2020-11-16 | Kay | Oklahoma | 40071 | 1289 | 20 |
734387 | 734387 | 2020-11-15 | Kay | Oklahoma | 40071 | 1252 | 20 |
731141 | 731141 | 2020-11-14 | Kay | Oklahoma | 40071 | 1214 | 20 |
727897 | 727897 | 2020-11-13 | Kay | Oklahoma | 40071 | 1184 | 19 |
724653 | 724653 | 2020-11-12 | Kay | Oklahoma | 40071 | 1173 | 18 |
721410 | 721410 | 2020-11-11 | Kay | Oklahoma | 40071 | 1153 | 18 |
718167 | 718167 | 2020-11-10 | Kay | Oklahoma | 40071 | 1132 | 18 |
714924 | 714924 | 2020-11-09 | Kay | Oklahoma | 40071 | 1112 | 18 |
711680 | 711680 | 2020-11-08 | Kay | Oklahoma | 40071 | 1077 | 17 |
708436 | 708436 | 2020-11-07 | Kay | Oklahoma | 40071 | 1077 | 17 |
705193 | 705193 | 2020-11-06 | Kay | Oklahoma | 40071 | 1015 | 17 |
701950 | 701950 | 2020-11-05 | Kay | Oklahoma | 40071 | 984 | 16 |
698706 | 698706 | 2020-11-04 | Kay | Oklahoma | 40071 | 964 | 16 |
695463 | 695463 | 2020-11-03 | Kay | Oklahoma | 40071 | 946 | 16 |
692221 | 692221 | 2020-11-02 | Kay | Oklahoma | 40071 | 924 | 16 |
688977 | 688977 | 2020-11-01 | Kay | Oklahoma | 40071 | 920 | 16 |
685732 | 685732 | 2020-10-31 | Kay | Oklahoma | 40071 | 907 | 16 |
682489 | 682489 | 2020-10-30 | Kay | Oklahoma | 40071 | 903 | 16 |
679246 | 679246 | 2020-10-29 | Kay | Oklahoma | 40071 | 899 | 16 |
676003 | 676003 | 2020-10-28 | Kay | Oklahoma | 40071 | 897 | 16 |
672760 | 672760 | 2020-10-27 | Kay | Oklahoma | 40071 | 883 | 16 |
669518 | 669518 | 2020-10-26 | Kay | Oklahoma | 40071 | 866 | 16 |
666274 | 666274 | 2020-10-25 | Kay | Oklahoma | 40071 | 868 | 16 |
663029 | 663029 | 2020-10-24 | Kay | Oklahoma | 40071 | 863 | 16 |
659785 | 659785 | 2020-10-23 | Kay | Oklahoma | 40071 | 844 | 16 |
656541 | 656541 | 2020-10-22 | Kay | Oklahoma | 40071 | 831 | 16 |
653296 | 653296 | 2020-10-21 | Kay | Oklahoma | 40071 | 822 | 16 |
650051 | 650051 | 2020-10-20 | Kay | Oklahoma | 40071 | 802 | 16 |
646807 | 646807 | 2020-10-19 | Kay | Oklahoma | 40071 | 796 | 15 |
643561 | 643561 | 2020-10-18 | Kay | Oklahoma | 40071 | 792 | 15 |
640313 | 640313 | 2020-10-17 | Kay | Oklahoma | 40071 | 789 | 15 |
637067 | 637067 | 2020-10-16 | Kay | Oklahoma | 40071 | 782 | 15 |
633821 | 633821 | 2020-10-15 | Kay | Oklahoma | 40071 | 775 | 15 |
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);