ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 21143 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090279 | 1090279 | 2021-03-05 | Lyon | Kentucky | 21143 | 879 | 13 |
1087034 | 1087034 | 2021-03-04 | Lyon | Kentucky | 21143 | 839 | 13 |
1083788 | 1083788 | 2021-03-03 | Lyon | Kentucky | 21143 | 702 | 13 |
1080542 | 1080542 | 2021-03-02 | Lyon | Kentucky | 21143 | 514 | 13 |
1077297 | 1077297 | 2021-03-01 | Lyon | Kentucky | 21143 | 506 | 13 |
1074051 | 1074051 | 2021-02-28 | Lyon | Kentucky | 21143 | 507 | 13 |
1070805 | 1070805 | 2021-02-27 | Lyon | Kentucky | 21143 | 506 | 13 |
1067560 | 1067560 | 2021-02-26 | Lyon | Kentucky | 21143 | 489 | 13 |
1064315 | 1064315 | 2021-02-25 | Lyon | Kentucky | 21143 | 486 | 13 |
1061070 | 1061070 | 2021-02-24 | Lyon | Kentucky | 21143 | 484 | 13 |
1057824 | 1057824 | 2021-02-23 | Lyon | Kentucky | 21143 | 476 | 13 |
1054578 | 1054578 | 2021-02-22 | Lyon | Kentucky | 21143 | 474 | 13 |
1051331 | 1051331 | 2021-02-21 | Lyon | Kentucky | 21143 | 473 | 13 |
1048084 | 1048084 | 2021-02-20 | Lyon | Kentucky | 21143 | 465 | 13 |
1044839 | 1044839 | 2021-02-19 | Lyon | Kentucky | 21143 | 460 | 13 |
1041594 | 1041594 | 2021-02-18 | Lyon | Kentucky | 21143 | 457 | 13 |
1038349 | 1038349 | 2021-02-17 | Lyon | Kentucky | 21143 | 458 | 13 |
1035104 | 1035104 | 2021-02-16 | Lyon | Kentucky | 21143 | 457 | 13 |
1031858 | 1031858 | 2021-02-15 | Lyon | Kentucky | 21143 | 455 | 13 |
1028611 | 1028611 | 2021-02-14 | Lyon | Kentucky | 21143 | 455 | 13 |
1025366 | 1025366 | 2021-02-13 | Lyon | Kentucky | 21143 | 451 | 13 |
1022121 | 1022121 | 2021-02-12 | Lyon | Kentucky | 21143 | 449 | 13 |
1018876 | 1018876 | 2021-02-11 | Lyon | Kentucky | 21143 | 448 | 12 |
1015631 | 1015631 | 2021-02-10 | Lyon | Kentucky | 21143 | 442 | 12 |
1012386 | 1012386 | 2021-02-09 | Lyon | Kentucky | 21143 | 435 | 12 |
1009140 | 1009140 | 2021-02-08 | Lyon | Kentucky | 21143 | 431 | 12 |
1005894 | 1005894 | 2021-02-07 | Lyon | Kentucky | 21143 | 429 | 12 |
1002648 | 1002648 | 2021-02-06 | Lyon | Kentucky | 21143 | 426 | 12 |
999402 | 999402 | 2021-02-05 | Lyon | Kentucky | 21143 | 425 | 12 |
996156 | 996156 | 2021-02-04 | Lyon | Kentucky | 21143 | 425 | 12 |
992910 | 992910 | 2021-02-03 | Lyon | Kentucky | 21143 | 423 | 12 |
989664 | 989664 | 2021-02-02 | Lyon | Kentucky | 21143 | 423 | 12 |
986417 | 986417 | 2021-02-01 | Lyon | Kentucky | 21143 | 423 | 12 |
983170 | 983170 | 2021-01-31 | Lyon | Kentucky | 21143 | 422 | 12 |
979924 | 979924 | 2021-01-30 | Lyon | Kentucky | 21143 | 414 | 12 |
976678 | 976678 | 2021-01-29 | Lyon | Kentucky | 21143 | 406 | 12 |
973433 | 973433 | 2021-01-28 | Lyon | Kentucky | 21143 | 404 | 12 |
970188 | 970188 | 2021-01-27 | Lyon | Kentucky | 21143 | 402 | 12 |
966944 | 966944 | 2021-01-26 | Lyon | Kentucky | 21143 | 400 | 12 |
963699 | 963699 | 2021-01-25 | Lyon | Kentucky | 21143 | 400 | 12 |
960454 | 960454 | 2021-01-24 | Lyon | Kentucky | 21143 | 400 | 11 |
957208 | 957208 | 2021-01-23 | Lyon | Kentucky | 21143 | 397 | 11 |
953963 | 953963 | 2021-01-22 | Lyon | Kentucky | 21143 | 394 | 11 |
950718 | 950718 | 2021-01-21 | Lyon | Kentucky | 21143 | 390 | 11 |
947472 | 947472 | 2021-01-20 | Lyon | Kentucky | 21143 | 388 | 11 |
944225 | 944225 | 2021-01-19 | Lyon | Kentucky | 21143 | 385 | 11 |
940980 | 940980 | 2021-01-18 | Lyon | Kentucky | 21143 | 379 | 11 |
937735 | 937735 | 2021-01-17 | Lyon | Kentucky | 21143 | 378 | 10 |
934490 | 934490 | 2021-01-16 | Lyon | Kentucky | 21143 | 376 | 8 |
931245 | 931245 | 2021-01-15 | Lyon | Kentucky | 21143 | 375 | 8 |
928000 | 928000 | 2021-01-14 | Lyon | Kentucky | 21143 | 373 | 8 |
924754 | 924754 | 2021-01-13 | Lyon | Kentucky | 21143 | 368 | 7 |
921509 | 921509 | 2021-01-12 | Lyon | Kentucky | 21143 | 367 | 7 |
918264 | 918264 | 2021-01-11 | Lyon | Kentucky | 21143 | 364 | 7 |
915019 | 915019 | 2021-01-10 | Lyon | Kentucky | 21143 | 362 | 7 |
911774 | 911774 | 2021-01-09 | Lyon | Kentucky | 21143 | 351 | 7 |
908529 | 908529 | 2021-01-08 | Lyon | Kentucky | 21143 | 349 | 7 |
905283 | 905283 | 2021-01-07 | Lyon | Kentucky | 21143 | 346 | 7 |
902038 | 902038 | 2021-01-06 | Lyon | Kentucky | 21143 | 344 | 7 |
898793 | 898793 | 2021-01-05 | Lyon | Kentucky | 21143 | 341 | 7 |
895548 | 895548 | 2021-01-04 | Lyon | Kentucky | 21143 | 340 | 7 |
892301 | 892301 | 2021-01-03 | Lyon | Kentucky | 21143 | 338 | 6 |
889055 | 889055 | 2021-01-02 | Lyon | Kentucky | 21143 | 330 | 5 |
885809 | 885809 | 2021-01-01 | Lyon | Kentucky | 21143 | 320 | 5 |
882564 | 882564 | 2020-12-31 | Lyon | Kentucky | 21143 | 320 | 5 |
879319 | 879319 | 2020-12-30 | Lyon | Kentucky | 21143 | 320 | 5 |
876074 | 876074 | 2020-12-29 | Lyon | Kentucky | 21143 | 319 | 5 |
872829 | 872829 | 2020-12-28 | Lyon | Kentucky | 21143 | 319 | 5 |
869584 | 869584 | 2020-12-27 | Lyon | Kentucky | 21143 | 317 | 5 |
866339 | 866339 | 2020-12-26 | Lyon | Kentucky | 21143 | 315 | 5 |
863094 | 863094 | 2020-12-25 | Lyon | Kentucky | 21143 | 300 | 5 |
859849 | 859849 | 2020-12-24 | Lyon | Kentucky | 21143 | 300 | 5 |
856604 | 856604 | 2020-12-23 | Lyon | Kentucky | 21143 | 300 | 5 |
853359 | 853359 | 2020-12-22 | Lyon | Kentucky | 21143 | 299 | 5 |
850114 | 850114 | 2020-12-21 | Lyon | Kentucky | 21143 | 292 | 5 |
846869 | 846869 | 2020-12-20 | Lyon | Kentucky | 21143 | 284 | 5 |
843623 | 843623 | 2020-12-19 | Lyon | Kentucky | 21143 | 280 | 5 |
840378 | 840378 | 2020-12-18 | Lyon | Kentucky | 21143 | 269 | 5 |
837133 | 837133 | 2020-12-17 | Lyon | Kentucky | 21143 | 268 | 5 |
833887 | 833887 | 2020-12-16 | Lyon | Kentucky | 21143 | 260 | 5 |
830640 | 830640 | 2020-12-15 | Lyon | Kentucky | 21143 | 257 | 5 |
827394 | 827394 | 2020-12-14 | Lyon | Kentucky | 21143 | 257 | 5 |
824147 | 824147 | 2020-12-13 | Lyon | Kentucky | 21143 | 256 | 5 |
820901 | 820901 | 2020-12-12 | Lyon | Kentucky | 21143 | 252 | 5 |
817655 | 817655 | 2020-12-11 | Lyon | Kentucky | 21143 | 243 | 5 |
814409 | 814409 | 2020-12-10 | Lyon | Kentucky | 21143 | 241 | 5 |
811164 | 811164 | 2020-12-09 | Lyon | Kentucky | 21143 | 233 | 5 |
807919 | 807919 | 2020-12-08 | Lyon | Kentucky | 21143 | 232 | 5 |
804674 | 804674 | 2020-12-07 | Lyon | Kentucky | 21143 | 229 | 5 |
801429 | 801429 | 2020-12-06 | Lyon | Kentucky | 21143 | 224 | 5 |
798184 | 798184 | 2020-12-05 | Lyon | Kentucky | 21143 | 219 | 5 |
794939 | 794939 | 2020-12-04 | Lyon | Kentucky | 21143 | 216 | 5 |
791694 | 791694 | 2020-12-03 | Lyon | Kentucky | 21143 | 211 | 5 |
788449 | 788449 | 2020-12-02 | Lyon | Kentucky | 21143 | 211 | 5 |
785205 | 785205 | 2020-12-01 | Lyon | Kentucky | 21143 | 209 | 5 |
781960 | 781960 | 2020-11-30 | Lyon | Kentucky | 21143 | 204 | 5 |
778714 | 778714 | 2020-11-29 | Lyon | Kentucky | 21143 | 200 | 5 |
775469 | 775469 | 2020-11-28 | Lyon | Kentucky | 21143 | 195 | 5 |
772224 | 772224 | 2020-11-27 | Lyon | Kentucky | 21143 | 195 | 5 |
768979 | 768979 | 2020-11-26 | Lyon | Kentucky | 21143 | 192 | 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);