ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Oldham" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090300 | 1090300 | 2021-03-05 | Oldham | Kentucky | 21185 | 7021 | 69 |
1087055 | 1087055 | 2021-03-04 | Oldham | Kentucky | 21185 | 6998 | 69 |
1083809 | 1083809 | 2021-03-03 | Oldham | Kentucky | 21185 | 6964 | 69 |
1080563 | 1080563 | 2021-03-02 | Oldham | Kentucky | 21185 | 6939 | 69 |
1077318 | 1077318 | 2021-03-01 | Oldham | Kentucky | 21185 | 6905 | 69 |
1074072 | 1074072 | 2021-02-28 | Oldham | Kentucky | 21185 | 6908 | 69 |
1070826 | 1070826 | 2021-02-27 | Oldham | Kentucky | 21185 | 6904 | 69 |
1067581 | 1067581 | 2021-02-26 | Oldham | Kentucky | 21185 | 6896 | 69 |
1064336 | 1064336 | 2021-02-25 | Oldham | Kentucky | 21185 | 6881 | 69 |
1061091 | 1061091 | 2021-02-24 | Oldham | Kentucky | 21185 | 6872 | 69 |
1057845 | 1057845 | 2021-02-23 | Oldham | Kentucky | 21185 | 6863 | 69 |
1054599 | 1054599 | 2021-02-22 | Oldham | Kentucky | 21185 | 6844 | 69 |
1051352 | 1051352 | 2021-02-21 | Oldham | Kentucky | 21185 | 6817 | 69 |
1048105 | 1048105 | 2021-02-20 | Oldham | Kentucky | 21185 | 6771 | 69 |
1044860 | 1044860 | 2021-02-19 | Oldham | Kentucky | 21185 | 6766 | 69 |
1041615 | 1041615 | 2021-02-18 | Oldham | Kentucky | 21185 | 6730 | 69 |
1038370 | 1038370 | 2021-02-17 | Oldham | Kentucky | 21185 | 6727 | 69 |
1035125 | 1035125 | 2021-02-16 | Oldham | Kentucky | 21185 | 6726 | 69 |
1031879 | 1031879 | 2021-02-15 | Oldham | Kentucky | 21185 | 6726 | 69 |
1028632 | 1028632 | 2021-02-14 | Oldham | Kentucky | 21185 | 6720 | 69 |
1025387 | 1025387 | 2021-02-13 | Oldham | Kentucky | 21185 | 6702 | 69 |
1022142 | 1022142 | 2021-02-12 | Oldham | Kentucky | 21185 | 6704 | 69 |
1018897 | 1018897 | 2021-02-11 | Oldham | Kentucky | 21185 | 6688 | 68 |
1015652 | 1015652 | 2021-02-10 | Oldham | Kentucky | 21185 | 6686 | 68 |
1012407 | 1012407 | 2021-02-09 | Oldham | Kentucky | 21185 | 6671 | 68 |
1009161 | 1009161 | 2021-02-08 | Oldham | Kentucky | 21185 | 6628 | 68 |
1005915 | 1005915 | 2021-02-07 | Oldham | Kentucky | 21185 | 6608 | 68 |
1002669 | 1002669 | 2021-02-06 | Oldham | Kentucky | 21185 | 6597 | 68 |
999423 | 999423 | 2021-02-05 | Oldham | Kentucky | 21185 | 6574 | 68 |
996177 | 996177 | 2021-02-04 | Oldham | Kentucky | 21185 | 6560 | 68 |
992931 | 992931 | 2021-02-03 | Oldham | Kentucky | 21185 | 6524 | 66 |
989685 | 989685 | 2021-02-02 | Oldham | Kentucky | 21185 | 6469 | 66 |
986438 | 986438 | 2021-02-01 | Oldham | Kentucky | 21185 | 6456 | 66 |
983191 | 983191 | 2021-01-31 | Oldham | Kentucky | 21185 | 6430 | 66 |
979945 | 979945 | 2021-01-30 | Oldham | Kentucky | 21185 | 6394 | 66 |
976699 | 976699 | 2021-01-29 | Oldham | Kentucky | 21185 | 6365 | 66 |
973454 | 973454 | 2021-01-28 | Oldham | Kentucky | 21185 | 6330 | 66 |
970209 | 970209 | 2021-01-27 | Oldham | Kentucky | 21185 | 6327 | 63 |
966965 | 966965 | 2021-01-26 | Oldham | Kentucky | 21185 | 6298 | 63 |
963720 | 963720 | 2021-01-25 | Oldham | Kentucky | 21185 | 6251 | 63 |
960475 | 960475 | 2021-01-24 | Oldham | Kentucky | 21185 | 6201 | 63 |
957229 | 957229 | 2021-01-23 | Oldham | Kentucky | 21185 | 6174 | 63 |
953984 | 953984 | 2021-01-22 | Oldham | Kentucky | 21185 | 6075 | 63 |
950739 | 950739 | 2021-01-21 | Oldham | Kentucky | 21185 | 6028 | 55 |
947493 | 947493 | 2021-01-20 | Oldham | Kentucky | 21185 | 5965 | 54 |
944246 | 944246 | 2021-01-19 | Oldham | Kentucky | 21185 | 5909 | 54 |
941001 | 941001 | 2021-01-18 | Oldham | Kentucky | 21185 | 5892 | 54 |
937756 | 937756 | 2021-01-17 | Oldham | Kentucky | 21185 | 5676 | 47 |
934511 | 934511 | 2021-01-16 | Oldham | Kentucky | 21185 | 5492 | 47 |
931266 | 931266 | 2021-01-15 | Oldham | Kentucky | 21185 | 5441 | 47 |
928021 | 928021 | 2021-01-14 | Oldham | Kentucky | 21185 | 5152 | 47 |
924775 | 924775 | 2021-01-13 | Oldham | Kentucky | 21185 | 4996 | 47 |
921530 | 921530 | 2021-01-12 | Oldham | Kentucky | 21185 | 4742 | 47 |
918285 | 918285 | 2021-01-11 | Oldham | Kentucky | 21185 | 4710 | 47 |
915040 | 915040 | 2021-01-10 | Oldham | Kentucky | 21185 | 4697 | 47 |
911795 | 911795 | 2021-01-09 | Oldham | Kentucky | 21185 | 4654 | 47 |
908550 | 908550 | 2021-01-08 | Oldham | Kentucky | 21185 | 4541 | 47 |
905304 | 905304 | 2021-01-07 | Oldham | Kentucky | 21185 | 4355 | 47 |
902059 | 902059 | 2021-01-06 | Oldham | Kentucky | 21185 | 4238 | 47 |
898814 | 898814 | 2021-01-05 | Oldham | Kentucky | 21185 | 4139 | 48 |
895569 | 895569 | 2021-01-04 | Oldham | Kentucky | 21185 | 4131 | 48 |
892322 | 892322 | 2021-01-03 | Oldham | Kentucky | 21185 | 4098 | 48 |
889076 | 889076 | 2021-01-02 | Oldham | Kentucky | 21185 | 4051 | 48 |
885830 | 885830 | 2021-01-01 | Oldham | Kentucky | 21185 | 3737 | 48 |
882585 | 882585 | 2020-12-31 | Oldham | Kentucky | 21185 | 3737 | 48 |
879340 | 879340 | 2020-12-30 | Oldham | Kentucky | 21185 | 3737 | 48 |
876095 | 876095 | 2020-12-29 | Oldham | Kentucky | 21185 | 3666 | 48 |
872850 | 872850 | 2020-12-28 | Oldham | Kentucky | 21185 | 3585 | 48 |
869605 | 869605 | 2020-12-27 | Oldham | Kentucky | 21185 | 3558 | 48 |
866360 | 866360 | 2020-12-26 | Oldham | Kentucky | 21185 | 3552 | 48 |
863115 | 863115 | 2020-12-25 | Oldham | Kentucky | 21185 | 3483 | 48 |
859870 | 859870 | 2020-12-24 | Oldham | Kentucky | 21185 | 3483 | 48 |
856625 | 856625 | 2020-12-23 | Oldham | Kentucky | 21185 | 3483 | 48 |
853380 | 853380 | 2020-12-22 | Oldham | Kentucky | 21185 | 3440 | 48 |
850135 | 850135 | 2020-12-21 | Oldham | Kentucky | 21185 | 3396 | 48 |
846890 | 846890 | 2020-12-20 | Oldham | Kentucky | 21185 | 3377 | 48 |
843644 | 843644 | 2020-12-19 | Oldham | Kentucky | 21185 | 3373 | 48 |
840399 | 840399 | 2020-12-18 | Oldham | Kentucky | 21185 | 3328 | 47 |
837154 | 837154 | 2020-12-17 | Oldham | Kentucky | 21185 | 3250 | 47 |
833908 | 833908 | 2020-12-16 | Oldham | Kentucky | 21185 | 3204 | 44 |
830661 | 830661 | 2020-12-15 | Oldham | Kentucky | 21185 | 3145 | 41 |
827415 | 827415 | 2020-12-14 | Oldham | Kentucky | 21185 | 3093 | 41 |
824168 | 824168 | 2020-12-13 | Oldham | Kentucky | 21185 | 3065 | 39 |
820922 | 820922 | 2020-12-12 | Oldham | Kentucky | 21185 | 3050 | 38 |
817676 | 817676 | 2020-12-11 | Oldham | Kentucky | 21185 | 3025 | 38 |
814430 | 814430 | 2020-12-10 | Oldham | Kentucky | 21185 | 3002 | 38 |
811185 | 811185 | 2020-12-09 | Oldham | Kentucky | 21185 | 2963 | 36 |
807940 | 807940 | 2020-12-08 | Oldham | Kentucky | 21185 | 2924 | 36 |
804695 | 804695 | 2020-12-07 | Oldham | Kentucky | 21185 | 2879 | 36 |
801450 | 801450 | 2020-12-06 | Oldham | Kentucky | 21185 | 2852 | 36 |
798205 | 798205 | 2020-12-05 | Oldham | Kentucky | 21185 | 2811 | 36 |
794960 | 794960 | 2020-12-04 | Oldham | Kentucky | 21185 | 2705 | 35 |
791715 | 791715 | 2020-12-03 | Oldham | Kentucky | 21185 | 2652 | 35 |
788470 | 788470 | 2020-12-02 | Oldham | Kentucky | 21185 | 2608 | 33 |
785226 | 785226 | 2020-12-01 | Oldham | Kentucky | 21185 | 2558 | 33 |
781981 | 781981 | 2020-11-30 | Oldham | Kentucky | 21185 | 2474 | 33 |
778735 | 778735 | 2020-11-29 | Oldham | Kentucky | 21185 | 2422 | 33 |
775490 | 775490 | 2020-11-28 | Oldham | Kentucky | 21185 | 2401 | 33 |
772245 | 772245 | 2020-11-27 | Oldham | Kentucky | 21185 | 2367 | 33 |
769000 | 769000 | 2020-11-26 | Oldham | Kentucky | 21185 | 2285 | 33 |
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);