ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where deaths = 4 and fips = 29101 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
581312 | 581312 | 2020-09-29 | Johnson | Missouri | 29101 | 1111 | 4 |
578071 | 578071 | 2020-09-28 | Johnson | Missouri | 29101 | 1111 | 4 |
574830 | 574830 | 2020-09-27 | Johnson | Missouri | 29101 | 1117 | 4 |
571587 | 571587 | 2020-09-26 | Johnson | Missouri | 29101 | 1101 | 4 |
568345 | 568345 | 2020-09-25 | Johnson | Missouri | 29101 | 1081 | 4 |
565105 | 565105 | 2020-09-24 | Johnson | Missouri | 29101 | 1065 | 4 |
561865 | 561865 | 2020-09-23 | Johnson | Missouri | 29101 | 1046 | 4 |
558628 | 558628 | 2020-09-22 | Johnson | Missouri | 29101 | 1020 | 4 |
555391 | 555391 | 2020-09-21 | Johnson | Missouri | 29101 | 995 | 4 |
552153 | 552153 | 2020-09-20 | Johnson | Missouri | 29101 | 984 | 4 |
548914 | 548914 | 2020-09-19 | Johnson | Missouri | 29101 | 975 | 4 |
545676 | 545676 | 2020-09-18 | Johnson | Missouri | 29101 | 969 | 4 |
542439 | 542439 | 2020-09-17 | Johnson | Missouri | 29101 | 966 | 4 |
539203 | 539203 | 2020-09-16 | Johnson | Missouri | 29101 | 911 | 4 |
535966 | 535966 | 2020-09-15 | Johnson | Missouri | 29101 | 905 | 4 |
532731 | 532731 | 2020-09-14 | Johnson | Missouri | 29101 | 888 | 4 |
529495 | 529495 | 2020-09-13 | Johnson | Missouri | 29101 | 853 | 4 |
526259 | 526259 | 2020-09-12 | Johnson | Missouri | 29101 | 800 | 4 |
523023 | 523023 | 2020-09-11 | Johnson | Missouri | 29101 | 777 | 4 |
519786 | 519786 | 2020-09-10 | Johnson | Missouri | 29101 | 768 | 4 |
516551 | 516551 | 2020-09-09 | Johnson | Missouri | 29101 | 767 | 4 |
513317 | 513317 | 2020-09-08 | Johnson | Missouri | 29101 | 733 | 4 |
510085 | 510085 | 2020-09-07 | Johnson | Missouri | 29101 | 717 | 4 |
506852 | 506852 | 2020-09-06 | Johnson | Missouri | 29101 | 699 | 4 |
503619 | 503619 | 2020-09-05 | Johnson | Missouri | 29101 | 643 | 4 |
500385 | 500385 | 2020-09-04 | Johnson | Missouri | 29101 | 622 | 4 |
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);