ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 12 and fips = 28129 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 |
---|---|---|---|---|---|---|---|
387411 | 387411 | 2020-07-31 | Smith | Mississippi | 28129 | 367 | 12 |
384193 | 384193 | 2020-07-30 | Smith | Mississippi | 28129 | 366 | 12 |
380976 | 380976 | 2020-07-29 | Smith | Mississippi | 28129 | 361 | 12 |
377759 | 377759 | 2020-07-28 | Smith | Mississippi | 28129 | 355 | 12 |
374544 | 374544 | 2020-07-27 | Smith | Mississippi | 28129 | 350 | 12 |
371332 | 371332 | 2020-07-26 | Smith | Mississippi | 28129 | 349 | 12 |
368122 | 368122 | 2020-07-25 | Smith | Mississippi | 28129 | 347 | 12 |
364914 | 364914 | 2020-07-24 | Smith | Mississippi | 28129 | 341 | 12 |
361707 | 361707 | 2020-07-23 | Smith | Mississippi | 28129 | 331 | 12 |
358502 | 358502 | 2020-07-22 | Smith | Mississippi | 28129 | 325 | 12 |
355299 | 355299 | 2020-07-21 | Smith | Mississippi | 28129 | 318 | 12 |
352097 | 352097 | 2020-07-20 | Smith | Mississippi | 28129 | 307 | 12 |
348897 | 348897 | 2020-07-19 | Smith | Mississippi | 28129 | 301 | 12 |
345696 | 345696 | 2020-07-18 | Smith | Mississippi | 28129 | 301 | 12 |
342496 | 342496 | 2020-07-17 | Smith | Mississippi | 28129 | 273 | 12 |
339300 | 339300 | 2020-07-16 | Smith | Mississippi | 28129 | 268 | 12 |
336104 | 336104 | 2020-07-15 | Smith | Mississippi | 28129 | 263 | 12 |
332911 | 332911 | 2020-07-14 | Smith | Mississippi | 28129 | 261 | 12 |
329724 | 329724 | 2020-07-13 | Smith | Mississippi | 28129 | 256 | 12 |
326538 | 326538 | 2020-07-12 | Smith | Mississippi | 28129 | 252 | 12 |
323355 | 323355 | 2020-07-11 | Smith | Mississippi | 28129 | 246 | 12 |
320176 | 320176 | 2020-07-10 | Smith | Mississippi | 28129 | 237 | 12 |
317001 | 317001 | 2020-07-09 | Smith | Mississippi | 28129 | 234 | 12 |
313827 | 313827 | 2020-07-08 | Smith | Mississippi | 28129 | 234 | 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);