ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where county = "Loudon", deaths = 3 and state = "Tennessee" 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 |
---|---|---|---|---|---|---|---|
494943 | 494943 | 2020-09-02 | Loudon | Tennessee | 47105 | 973 | 3 |
491709 | 491709 | 2020-09-01 | Loudon | Tennessee | 47105 | 963 | 3 |
488476 | 488476 | 2020-08-31 | Loudon | Tennessee | 47105 | 952 | 3 |
485243 | 485243 | 2020-08-30 | Loudon | Tennessee | 47105 | 944 | 3 |
482008 | 482008 | 2020-08-29 | Loudon | Tennessee | 47105 | 939 | 3 |
478774 | 478774 | 2020-08-28 | Loudon | Tennessee | 47105 | 934 | 3 |
475541 | 475541 | 2020-08-27 | Loudon | Tennessee | 47105 | 914 | 3 |
472308 | 472308 | 2020-08-26 | Loudon | Tennessee | 47105 | 903 | 3 |
469076 | 469076 | 2020-08-25 | Loudon | Tennessee | 47105 | 888 | 3 |
465847 | 465847 | 2020-08-24 | Loudon | Tennessee | 47105 | 879 | 3 |
462618 | 462618 | 2020-08-23 | Loudon | Tennessee | 47105 | 874 | 3 |
459390 | 459390 | 2020-08-22 | Loudon | Tennessee | 47105 | 862 | 3 |
456162 | 456162 | 2020-08-21 | Loudon | Tennessee | 47105 | 834 | 3 |
452934 | 452934 | 2020-08-20 | Loudon | Tennessee | 47105 | 828 | 3 |
449706 | 449706 | 2020-08-19 | Loudon | Tennessee | 47105 | 823 | 3 |
446478 | 446478 | 2020-08-18 | Loudon | Tennessee | 47105 | 819 | 3 |
443252 | 443252 | 2020-08-17 | Loudon | Tennessee | 47105 | 815 | 3 |
440025 | 440025 | 2020-08-16 | Loudon | Tennessee | 47105 | 809 | 3 |
436800 | 436800 | 2020-08-15 | Loudon | Tennessee | 47105 | 799 | 3 |
433573 | 433573 | 2020-08-14 | Loudon | Tennessee | 47105 | 788 | 3 |
430348 | 430348 | 2020-08-13 | Loudon | Tennessee | 47105 | 779 | 3 |
427121 | 427121 | 2020-08-12 | Loudon | Tennessee | 47105 | 774 | 3 |
423898 | 423898 | 2020-08-11 | Loudon | Tennessee | 47105 | 754 | 3 |
420676 | 420676 | 2020-08-10 | Loudon | Tennessee | 47105 | 749 | 3 |
417455 | 417455 | 2020-08-09 | Loudon | Tennessee | 47105 | 742 | 3 |
414234 | 414234 | 2020-08-08 | Loudon | Tennessee | 47105 | 725 | 3 |
411014 | 411014 | 2020-08-07 | Loudon | Tennessee | 47105 | 718 | 3 |
407795 | 407795 | 2020-08-06 | Loudon | Tennessee | 47105 | 705 | 3 |
404575 | 404575 | 2020-08-05 | Loudon | Tennessee | 47105 | 686 | 3 |
401357 | 401357 | 2020-08-04 | Loudon | Tennessee | 47105 | 682 | 3 |
398142 | 398142 | 2020-08-03 | Loudon | Tennessee | 47105 | 653 | 3 |
394925 | 394925 | 2020-08-02 | Loudon | Tennessee | 47105 | 649 | 3 |
391709 | 391709 | 2020-08-01 | Loudon | Tennessee | 47105 | 643 | 3 |
388492 | 388492 | 2020-07-31 | Loudon | Tennessee | 47105 | 606 | 3 |
385275 | 385275 | 2020-07-30 | Loudon | Tennessee | 47105 | 590 | 3 |
382057 | 382057 | 2020-07-29 | Loudon | Tennessee | 47105 | 575 | 3 |
378840 | 378840 | 2020-07-28 | Loudon | Tennessee | 47105 | 560 | 3 |
375624 | 375624 | 2020-07-27 | Loudon | Tennessee | 47105 | 544 | 3 |
372411 | 372411 | 2020-07-26 | Loudon | Tennessee | 47105 | 515 | 3 |
369199 | 369199 | 2020-07-25 | Loudon | Tennessee | 47105 | 503 | 3 |
365990 | 365990 | 2020-07-24 | Loudon | Tennessee | 47105 | 493 | 3 |
362784 | 362784 | 2020-07-23 | Loudon | Tennessee | 47105 | 484 | 3 |
359577 | 359577 | 2020-07-22 | Loudon | Tennessee | 47105 | 443 | 3 |
356373 | 356373 | 2020-07-21 | Loudon | Tennessee | 47105 | 437 | 3 |
353170 | 353170 | 2020-07-20 | Loudon | Tennessee | 47105 | 408 | 3 |
349967 | 349967 | 2020-07-19 | Loudon | Tennessee | 47105 | 398 | 3 |
346767 | 346767 | 2020-07-18 | Loudon | Tennessee | 47105 | 394 | 3 |
343567 | 343567 | 2020-07-17 | Loudon | Tennessee | 47105 | 382 | 3 |
340369 | 340369 | 2020-07-16 | Loudon | Tennessee | 47105 | 368 | 3 |
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);