ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 12 and fips = 21049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
807872 | 807872 | 2020-12-08 | Clark | Kentucky | 21049 | 1125 | 12 |
804627 | 804627 | 2020-12-07 | Clark | Kentucky | 21049 | 1088 | 12 |
801382 | 801382 | 2020-12-06 | Clark | Kentucky | 21049 | 1079 | 12 |
798137 | 798137 | 2020-12-05 | Clark | Kentucky | 21049 | 1071 | 12 |
794892 | 794892 | 2020-12-04 | Clark | Kentucky | 21049 | 1049 | 12 |
791647 | 791647 | 2020-12-03 | Clark | Kentucky | 21049 | 1012 | 12 |
788402 | 788402 | 2020-12-02 | Clark | Kentucky | 21049 | 973 | 12 |
785158 | 785158 | 2020-12-01 | Clark | Kentucky | 21049 | 949 | 12 |
781913 | 781913 | 2020-11-30 | Clark | Kentucky | 21049 | 922 | 12 |
778667 | 778667 | 2020-11-29 | Clark | Kentucky | 21049 | 914 | 12 |
775422 | 775422 | 2020-11-28 | Clark | Kentucky | 21049 | 905 | 12 |
772177 | 772177 | 2020-11-27 | Clark | Kentucky | 21049 | 901 | 12 |
768932 | 768932 | 2020-11-26 | Clark | Kentucky | 21049 | 866 | 12 |
765686 | 765686 | 2020-11-25 | Clark | Kentucky | 21049 | 866 | 12 |
762441 | 762441 | 2020-11-24 | Clark | Kentucky | 21049 | 833 | 12 |
759196 | 759196 | 2020-11-23 | Clark | Kentucky | 21049 | 811 | 12 |
755949 | 755949 | 2020-11-22 | Clark | Kentucky | 21049 | 805 | 12 |
752703 | 752703 | 2020-11-21 | Clark | Kentucky | 21049 | 801 | 12 |
749457 | 749457 | 2020-11-20 | Clark | Kentucky | 21049 | 763 | 12 |
746211 | 746211 | 2020-11-19 | Clark | Kentucky | 21049 | 728 | 12 |
742964 | 742964 | 2020-11-18 | Clark | Kentucky | 21049 | 711 | 12 |
739717 | 739717 | 2020-11-17 | Clark | Kentucky | 21049 | 705 | 12 |
736473 | 736473 | 2020-11-16 | Clark | Kentucky | 21049 | 695 | 12 |
733227 | 733227 | 2020-11-15 | Clark | Kentucky | 21049 | 694 | 12 |
729982 | 729982 | 2020-11-14 | Clark | Kentucky | 21049 | 690 | 12 |
726739 | 726739 | 2020-11-13 | Clark | Kentucky | 21049 | 668 | 12 |
723496 | 723496 | 2020-11-12 | Clark | Kentucky | 21049 | 663 | 12 |
720253 | 720253 | 2020-11-11 | Clark | Kentucky | 21049 | 655 | 12 |
717010 | 717010 | 2020-11-10 | Clark | Kentucky | 21049 | 647 | 12 |
713766 | 713766 | 2020-11-09 | Clark | Kentucky | 21049 | 642 | 12 |
710522 | 710522 | 2020-11-08 | Clark | Kentucky | 21049 | 624 | 12 |
707278 | 707278 | 2020-11-07 | Clark | Kentucky | 21049 | 625 | 12 |
704035 | 704035 | 2020-11-06 | Clark | Kentucky | 21049 | 607 | 12 |
700793 | 700793 | 2020-11-05 | Clark | Kentucky | 21049 | 589 | 12 |
697549 | 697549 | 2020-11-04 | Clark | Kentucky | 21049 | 583 | 12 |
694306 | 694306 | 2020-11-03 | Clark | Kentucky | 21049 | 580 | 12 |
691064 | 691064 | 2020-11-02 | Clark | Kentucky | 21049 | 571 | 12 |
687819 | 687819 | 2020-11-01 | Clark | Kentucky | 21049 | 565 | 12 |
684575 | 684575 | 2020-10-31 | Clark | Kentucky | 21049 | 562 | 12 |
681332 | 681332 | 2020-10-30 | Clark | Kentucky | 21049 | 550 | 12 |
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);