ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 52 and fips = 19139 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 |
---|---|---|---|---|---|---|---|
551471 | 551471 | 2020-09-20 | Muscatine | Iowa | 19139 | 1064 | 52 |
548232 | 548232 | 2020-09-19 | Muscatine | Iowa | 19139 | 1060 | 52 |
544994 | 544994 | 2020-09-18 | Muscatine | Iowa | 19139 | 1054 | 52 |
541758 | 541758 | 2020-09-17 | Muscatine | Iowa | 19139 | 1053 | 52 |
538521 | 538521 | 2020-09-16 | Muscatine | Iowa | 19139 | 1050 | 52 |
535285 | 535285 | 2020-09-15 | Muscatine | Iowa | 19139 | 1045 | 52 |
532050 | 532050 | 2020-09-14 | Muscatine | Iowa | 19139 | 1045 | 52 |
528813 | 528813 | 2020-09-13 | Muscatine | Iowa | 19139 | 1036 | 52 |
525577 | 525577 | 2020-09-12 | Muscatine | Iowa | 19139 | 1031 | 52 |
522341 | 522341 | 2020-09-11 | Muscatine | Iowa | 19139 | 1028 | 52 |
519104 | 519104 | 2020-09-10 | Muscatine | Iowa | 19139 | 1022 | 52 |
515869 | 515869 | 2020-09-09 | Muscatine | Iowa | 19139 | 1015 | 52 |
512636 | 512636 | 2020-09-08 | Muscatine | Iowa | 19139 | 1008 | 52 |
509403 | 509403 | 2020-09-07 | Muscatine | Iowa | 19139 | 1001 | 52 |
506171 | 506171 | 2020-09-06 | Muscatine | Iowa | 19139 | 998 | 52 |
502937 | 502937 | 2020-09-05 | Muscatine | Iowa | 19139 | 995 | 52 |
499703 | 499703 | 2020-09-04 | Muscatine | Iowa | 19139 | 990 | 52 |
496470 | 496470 | 2020-09-03 | Muscatine | Iowa | 19139 | 983 | 52 |
493236 | 493236 | 2020-09-02 | Muscatine | Iowa | 19139 | 976 | 52 |
490003 | 490003 | 2020-09-01 | Muscatine | Iowa | 19139 | 973 | 52 |
486770 | 486770 | 2020-08-31 | Muscatine | Iowa | 19139 | 967 | 52 |
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);