ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where deaths = 13 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 |
---|---|---|---|---|---|---|---|
532663 | 532663 | 2020-09-14 | Smith | Mississippi | 28129 | 511 | 13 |
529427 | 529427 | 2020-09-13 | Smith | Mississippi | 28129 | 509 | 13 |
526191 | 526191 | 2020-09-12 | Smith | Mississippi | 28129 | 508 | 13 |
522955 | 522955 | 2020-09-11 | Smith | Mississippi | 28129 | 502 | 13 |
519718 | 519718 | 2020-09-10 | Smith | Mississippi | 28129 | 496 | 13 |
516483 | 516483 | 2020-09-09 | Smith | Mississippi | 28129 | 492 | 13 |
513249 | 513249 | 2020-09-08 | Smith | Mississippi | 28129 | 492 | 13 |
510017 | 510017 | 2020-09-07 | Smith | Mississippi | 28129 | 492 | 13 |
506784 | 506784 | 2020-09-06 | Smith | Mississippi | 28129 | 492 | 13 |
503551 | 503551 | 2020-09-05 | Smith | Mississippi | 28129 | 492 | 13 |
500317 | 500317 | 2020-09-04 | Smith | Mississippi | 28129 | 490 | 13 |
497083 | 497083 | 2020-09-03 | Smith | Mississippi | 28129 | 484 | 13 |
493850 | 493850 | 2020-09-02 | Smith | Mississippi | 28129 | 479 | 13 |
490616 | 490616 | 2020-09-01 | Smith | Mississippi | 28129 | 474 | 13 |
487383 | 487383 | 2020-08-31 | Smith | Mississippi | 28129 | 467 | 13 |
484149 | 484149 | 2020-08-30 | Smith | Mississippi | 28129 | 467 | 13 |
480914 | 480914 | 2020-08-29 | Smith | Mississippi | 28129 | 463 | 13 |
477682 | 477682 | 2020-08-28 | Smith | Mississippi | 28129 | 462 | 13 |
474449 | 474449 | 2020-08-27 | Smith | Mississippi | 28129 | 463 | 13 |
471217 | 471217 | 2020-08-26 | Smith | Mississippi | 28129 | 456 | 13 |
467987 | 467987 | 2020-08-25 | Smith | Mississippi | 28129 | 454 | 13 |
464758 | 464758 | 2020-08-24 | Smith | Mississippi | 28129 | 454 | 13 |
461527 | 461527 | 2020-08-23 | Smith | Mississippi | 28129 | 454 | 13 |
458300 | 458300 | 2020-08-22 | Smith | Mississippi | 28129 | 451 | 13 |
455072 | 455072 | 2020-08-21 | Smith | Mississippi | 28129 | 441 | 13 |
451844 | 451844 | 2020-08-20 | Smith | Mississippi | 28129 | 439 | 13 |
448616 | 448616 | 2020-08-19 | Smith | Mississippi | 28129 | 435 | 13 |
445390 | 445390 | 2020-08-18 | Smith | Mississippi | 28129 | 429 | 13 |
442164 | 442164 | 2020-08-17 | Smith | Mississippi | 28129 | 422 | 13 |
438937 | 438937 | 2020-08-16 | Smith | Mississippi | 28129 | 421 | 13 |
435712 | 435712 | 2020-08-15 | Smith | Mississippi | 28129 | 421 | 13 |
432486 | 432486 | 2020-08-14 | Smith | Mississippi | 28129 | 419 | 13 |
429259 | 429259 | 2020-08-13 | Smith | Mississippi | 28129 | 415 | 13 |
426035 | 426035 | 2020-08-12 | Smith | Mississippi | 28129 | 412 | 13 |
422813 | 422813 | 2020-08-11 | Smith | Mississippi | 28129 | 406 | 13 |
419591 | 419591 | 2020-08-10 | Smith | Mississippi | 28129 | 406 | 13 |
416370 | 416370 | 2020-08-09 | Smith | Mississippi | 28129 | 405 | 13 |
413150 | 413150 | 2020-08-08 | Smith | Mississippi | 28129 | 404 | 13 |
409930 | 409930 | 2020-08-07 | Smith | Mississippi | 28129 | 397 | 13 |
406710 | 406710 | 2020-08-06 | Smith | Mississippi | 28129 | 394 | 13 |
403492 | 403492 | 2020-08-05 | Smith | Mississippi | 28129 | 389 | 13 |
400275 | 400275 | 2020-08-04 | Smith | Mississippi | 28129 | 385 | 13 |
397061 | 397061 | 2020-08-03 | Smith | Mississippi | 28129 | 380 | 13 |
393845 | 393845 | 2020-08-02 | Smith | Mississippi | 28129 | 377 | 13 |
390628 | 390628 | 2020-08-01 | Smith | Mississippi | 28129 | 374 | 13 |
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);