ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
12 rows where county = "Kansas City", deaths = 32 and state = "Missouri" 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 |
---|---|---|---|---|---|---|---|
304391 | 304391 | 2020-07-05 | Kansas City | Missouri | 2696 | 32 | |
301227 | 301227 | 2020-07-04 | Kansas City | Missouri | 2641 | 32 | |
298064 | 298064 | 2020-07-03 | Kansas City | Missouri | 2601 | 32 | |
294906 | 294906 | 2020-07-02 | Kansas City | Missouri | 2497 | 32 | |
291752 | 291752 | 2020-07-01 | Kansas City | Missouri | 2457 | 32 | |
288601 | 288601 | 2020-06-30 | Kansas City | Missouri | 2380 | 32 | |
285451 | 285451 | 2020-06-29 | Kansas City | Missouri | 2345 | 32 | |
282306 | 282306 | 2020-06-28 | Kansas City | Missouri | 2292 | 32 | |
279158 | 279158 | 2020-06-27 | Kansas City | Missouri | 2242 | 32 | |
276010 | 276010 | 2020-06-26 | Kansas City | Missouri | 2211 | 32 | |
272867 | 272867 | 2020-06-25 | Kansas City | Missouri | 2162 | 32 | |
269728 | 269728 | 2020-06-24 | Kansas City | Missouri | 2057 | 32 |
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);