ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where county = "Dade", deaths = 8 and state = "Georgia" 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 |
---|---|---|---|---|---|---|---|
917623 | 917623 | 2021-01-11 | Dade | Georgia | 13083 | 959 | 8 |
914378 | 914378 | 2021-01-10 | Dade | Georgia | 13083 | 941 | 8 |
911133 | 911133 | 2021-01-09 | Dade | Georgia | 13083 | 932 | 8 |
907888 | 907888 | 2021-01-08 | Dade | Georgia | 13083 | 916 | 8 |
904642 | 904642 | 2021-01-07 | Dade | Georgia | 13083 | 902 | 8 |
901397 | 901397 | 2021-01-06 | Dade | Georgia | 13083 | 888 | 8 |
898152 | 898152 | 2021-01-05 | Dade | Georgia | 13083 | 857 | 8 |
894907 | 894907 | 2021-01-04 | Dade | Georgia | 13083 | 844 | 8 |
891660 | 891660 | 2021-01-03 | Dade | Georgia | 13083 | 836 | 8 |
888413 | 888413 | 2021-01-02 | Dade | Georgia | 13083 | 833 | 8 |
885168 | 885168 | 2021-01-01 | Dade | Georgia | 13083 | 828 | 8 |
881923 | 881923 | 2020-12-31 | Dade | Georgia | 13083 | 822 | 8 |
878678 | 878678 | 2020-12-30 | Dade | Georgia | 13083 | 808 | 8 |
875433 | 875433 | 2020-12-29 | Dade | Georgia | 13083 | 788 | 8 |
872188 | 872188 | 2020-12-28 | Dade | Georgia | 13083 | 769 | 8 |
868943 | 868943 | 2020-12-27 | Dade | Georgia | 13083 | 761 | 8 |
865698 | 865698 | 2020-12-26 | Dade | Georgia | 13083 | 759 | 8 |
862453 | 862453 | 2020-12-25 | Dade | Georgia | 13083 | 757 | 8 |
859208 | 859208 | 2020-12-24 | Dade | Georgia | 13083 | 750 | 8 |
855963 | 855963 | 2020-12-23 | Dade | Georgia | 13083 | 738 | 8 |
852718 | 852718 | 2020-12-22 | Dade | Georgia | 13083 | 734 | 8 |
849473 | 849473 | 2020-12-21 | Dade | Georgia | 13083 | 716 | 8 |
846228 | 846228 | 2020-12-20 | Dade | Georgia | 13083 | 707 | 8 |
842982 | 842982 | 2020-12-19 | Dade | Georgia | 13083 | 701 | 8 |
839737 | 839737 | 2020-12-18 | Dade | Georgia | 13083 | 688 | 8 |
836492 | 836492 | 2020-12-17 | Dade | Georgia | 13083 | 677 | 8 |
833246 | 833246 | 2020-12-16 | Dade | Georgia | 13083 | 666 | 8 |
829999 | 829999 | 2020-12-15 | Dade | Georgia | 13083 | 649 | 8 |
826753 | 826753 | 2020-12-14 | Dade | Georgia | 13083 | 646 | 8 |
823506 | 823506 | 2020-12-13 | Dade | Georgia | 13083 | 637 | 8 |
820260 | 820260 | 2020-12-12 | Dade | Georgia | 13083 | 635 | 8 |
817014 | 817014 | 2020-12-11 | Dade | Georgia | 13083 | 632 | 8 |
813768 | 813768 | 2020-12-10 | Dade | Georgia | 13083 | 619 | 8 |
810524 | 810524 | 2020-12-09 | Dade | Georgia | 13083 | 612 | 8 |
807279 | 807279 | 2020-12-08 | Dade | Georgia | 13083 | 597 | 8 |
804034 | 804034 | 2020-12-07 | Dade | Georgia | 13083 | 594 | 8 |
800789 | 800789 | 2020-12-06 | Dade | Georgia | 13083 | 590 | 8 |
797544 | 797544 | 2020-12-05 | Dade | Georgia | 13083 | 587 | 8 |
794299 | 794299 | 2020-12-04 | Dade | Georgia | 13083 | 577 | 8 |
791054 | 791054 | 2020-12-03 | Dade | Georgia | 13083 | 559 | 8 |
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);