ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47065 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637442 | 637442 | 2020-10-16 | Hamilton | Tennessee | 47065 | 11082 | 104 |
634196 | 634196 | 2020-10-15 | Hamilton | Tennessee | 47065 | 10984 | 103 |
630951 | 630951 | 2020-10-14 | Hamilton | Tennessee | 47065 | 10907 | 103 |
627707 | 627707 | 2020-10-13 | Hamilton | Tennessee | 47065 | 10813 | 102 |
624465 | 624465 | 2020-10-12 | Hamilton | Tennessee | 47065 | 10753 | 101 |
621222 | 621222 | 2020-10-11 | Hamilton | Tennessee | 47065 | 10665 | 101 |
617979 | 617979 | 2020-10-10 | Hamilton | Tennessee | 47065 | 10603 | 101 |
614737 | 614737 | 2020-10-09 | Hamilton | Tennessee | 47065 | 10499 | 101 |
611496 | 611496 | 2020-10-08 | Hamilton | Tennessee | 47065 | 10414 | 101 |
608254 | 608254 | 2020-10-07 | Hamilton | Tennessee | 47065 | 10330 | 99 |
605011 | 605011 | 2020-10-06 | Hamilton | Tennessee | 47065 | 10237 | 99 |
601769 | 601769 | 2020-10-05 | Hamilton | Tennessee | 47065 | 10153 | 98 |
598526 | 598526 | 2020-10-04 | Hamilton | Tennessee | 47065 | 10078 | 98 |
595283 | 595283 | 2020-10-03 | Hamilton | Tennessee | 47065 | 10029 | 98 |
592042 | 592042 | 2020-10-02 | Hamilton | Tennessee | 47065 | 9936 | 98 |
588801 | 588801 | 2020-10-01 | Hamilton | Tennessee | 47065 | 9878 | 97 |
585561 | 585561 | 2020-09-30 | Hamilton | Tennessee | 47065 | 9825 | 97 |
582321 | 582321 | 2020-09-29 | Hamilton | Tennessee | 47065 | 9774 | 95 |
579081 | 579081 | 2020-09-28 | Hamilton | Tennessee | 47065 | 9702 | 95 |
575840 | 575840 | 2020-09-27 | Hamilton | Tennessee | 47065 | 9658 | 95 |
572596 | 572596 | 2020-09-26 | Hamilton | Tennessee | 47065 | 9609 | 95 |
569354 | 569354 | 2020-09-25 | Hamilton | Tennessee | 47065 | 9542 | 94 |
566113 | 566113 | 2020-09-24 | Hamilton | Tennessee | 47065 | 9451 | 92 |
562872 | 562872 | 2020-09-23 | Hamilton | Tennessee | 47065 | 9387 | 92 |
559635 | 559635 | 2020-09-22 | Hamilton | Tennessee | 47065 | 9342 | 92 |
556398 | 556398 | 2020-09-21 | Hamilton | Tennessee | 47065 | 9273 | 91 |
553161 | 553161 | 2020-09-20 | Hamilton | Tennessee | 47065 | 9241 | 91 |
549922 | 549922 | 2020-09-19 | Hamilton | Tennessee | 47065 | 9188 | 91 |
546683 | 546683 | 2020-09-18 | Hamilton | Tennessee | 47065 | 9119 | 91 |
543446 | 543446 | 2020-09-17 | Hamilton | Tennessee | 47065 | 9049 | 89 |
540210 | 540210 | 2020-09-16 | Hamilton | Tennessee | 47065 | 9007 | 88 |
536973 | 536973 | 2020-09-15 | Hamilton | Tennessee | 47065 | 8967 | 87 |
533737 | 533737 | 2020-09-14 | Hamilton | Tennessee | 47065 | 8901 | 87 |
530502 | 530502 | 2020-09-13 | Hamilton | Tennessee | 47065 | 8830 | 85 |
527265 | 527265 | 2020-09-12 | Hamilton | Tennessee | 47065 | 8769 | 85 |
524029 | 524029 | 2020-09-11 | Hamilton | Tennessee | 47065 | 8718 | 84 |
520793 | 520793 | 2020-09-10 | Hamilton | Tennessee | 47065 | 8672 | 83 |
517557 | 517557 | 2020-09-09 | Hamilton | Tennessee | 47065 | 8640 | 82 |
514322 | 514322 | 2020-09-08 | Hamilton | Tennessee | 47065 | 8594 | 79 |
511089 | 511089 | 2020-09-07 | Hamilton | Tennessee | 47065 | 8563 | 79 |
507856 | 507856 | 2020-09-06 | Hamilton | Tennessee | 47065 | 8505 | 78 |
504624 | 504624 | 2020-09-05 | Hamilton | Tennessee | 47065 | 8427 | 78 |
501390 | 501390 | 2020-09-04 | Hamilton | Tennessee | 47065 | 8326 | 78 |
498156 | 498156 | 2020-09-03 | Hamilton | Tennessee | 47065 | 8294 | 78 |
494923 | 494923 | 2020-09-02 | Hamilton | Tennessee | 47065 | 8217 | 78 |
491689 | 491689 | 2020-09-01 | Hamilton | Tennessee | 47065 | 8136 | 77 |
488456 | 488456 | 2020-08-31 | Hamilton | Tennessee | 47065 | 7998 | 75 |
485223 | 485223 | 2020-08-30 | Hamilton | Tennessee | 47065 | 7965 | 74 |
481988 | 481988 | 2020-08-29 | Hamilton | Tennessee | 47065 | 7939 | 74 |
478754 | 478754 | 2020-08-28 | Hamilton | Tennessee | 47065 | 7863 | 74 |
475521 | 475521 | 2020-08-27 | Hamilton | Tennessee | 47065 | 7763 | 72 |
472288 | 472288 | 2020-08-26 | Hamilton | Tennessee | 47065 | 7689 | 69 |
469056 | 469056 | 2020-08-25 | Hamilton | Tennessee | 47065 | 7586 | 69 |
465827 | 465827 | 2020-08-24 | Hamilton | Tennessee | 47065 | 7496 | 68 |
462598 | 462598 | 2020-08-23 | Hamilton | Tennessee | 47065 | 7463 | 63 |
459370 | 459370 | 2020-08-22 | Hamilton | Tennessee | 47065 | 7373 | 63 |
456142 | 456142 | 2020-08-21 | Hamilton | Tennessee | 47065 | 7312 | 63 |
452914 | 452914 | 2020-08-20 | Hamilton | Tennessee | 47065 | 7223 | 63 |
449686 | 449686 | 2020-08-19 | Hamilton | Tennessee | 47065 | 7145 | 63 |
446458 | 446458 | 2020-08-18 | Hamilton | Tennessee | 47065 | 6995 | 63 |
443232 | 443232 | 2020-08-17 | Hamilton | Tennessee | 47065 | 6862 | 62 |
440005 | 440005 | 2020-08-16 | Hamilton | Tennessee | 47065 | 6801 | 61 |
436780 | 436780 | 2020-08-15 | Hamilton | Tennessee | 47065 | 6694 | 60 |
433553 | 433553 | 2020-08-14 | Hamilton | Tennessee | 47065 | 6610 | 60 |
430328 | 430328 | 2020-08-13 | Hamilton | Tennessee | 47065 | 6547 | 59 |
427101 | 427101 | 2020-08-12 | Hamilton | Tennessee | 47065 | 6408 | 56 |
423878 | 423878 | 2020-08-11 | Hamilton | Tennessee | 47065 | 6315 | 56 |
420656 | 420656 | 2020-08-10 | Hamilton | Tennessee | 47065 | 6220 | 55 |
417435 | 417435 | 2020-08-09 | Hamilton | Tennessee | 47065 | 6132 | 54 |
414214 | 414214 | 2020-08-08 | Hamilton | Tennessee | 47065 | 6062 | 54 |
410994 | 410994 | 2020-08-07 | Hamilton | Tennessee | 47065 | 5970 | 53 |
407775 | 407775 | 2020-08-06 | Hamilton | Tennessee | 47065 | 5884 | 50 |
404555 | 404555 | 2020-08-05 | Hamilton | Tennessee | 47065 | 5803 | 49 |
401337 | 401337 | 2020-08-04 | Hamilton | Tennessee | 47065 | 5720 | 48 |
398122 | 398122 | 2020-08-03 | Hamilton | Tennessee | 47065 | 5661 | 48 |
394905 | 394905 | 2020-08-02 | Hamilton | Tennessee | 47065 | 5621 | 48 |
391689 | 391689 | 2020-08-01 | Hamilton | Tennessee | 47065 | 5549 | 48 |
388472 | 388472 | 2020-07-31 | Hamilton | Tennessee | 47065 | 5483 | 48 |
385255 | 385255 | 2020-07-30 | Hamilton | Tennessee | 47065 | 5395 | 47 |
382037 | 382037 | 2020-07-29 | Hamilton | Tennessee | 47065 | 5344 | 46 |
378820 | 378820 | 2020-07-28 | Hamilton | Tennessee | 47065 | 5253 | 46 |
375604 | 375604 | 2020-07-27 | Hamilton | Tennessee | 47065 | 5158 | 45 |
372391 | 372391 | 2020-07-26 | Hamilton | Tennessee | 47065 | 5055 | 45 |
369179 | 369179 | 2020-07-25 | Hamilton | Tennessee | 47065 | 4900 | 44 |
365970 | 365970 | 2020-07-24 | Hamilton | Tennessee | 47065 | 4721 | 42 |
362764 | 362764 | 2020-07-23 | Hamilton | Tennessee | 47065 | 4610 | 41 |
359557 | 359557 | 2020-07-22 | Hamilton | Tennessee | 47065 | 4523 | 41 |
356353 | 356353 | 2020-07-21 | Hamilton | Tennessee | 47065 | 4461 | 41 |
353150 | 353150 | 2020-07-20 | Hamilton | Tennessee | 47065 | 4360 | 40 |
349947 | 349947 | 2020-07-19 | Hamilton | Tennessee | 47065 | 4262 | 40 |
346747 | 346747 | 2020-07-18 | Hamilton | Tennessee | 47065 | 4160 | 40 |
343547 | 343547 | 2020-07-17 | Hamilton | Tennessee | 47065 | 4043 | 40 |
340349 | 340349 | 2020-07-16 | Hamilton | Tennessee | 47065 | 3939 | 39 |
337152 | 337152 | 2020-07-15 | Hamilton | Tennessee | 47065 | 3798 | 39 |
333958 | 333958 | 2020-07-14 | Hamilton | Tennessee | 47065 | 3684 | 38 |
330766 | 330766 | 2020-07-13 | Hamilton | Tennessee | 47065 | 3535 | 38 |
327580 | 327580 | 2020-07-12 | Hamilton | Tennessee | 47065 | 3457 | 38 |
324395 | 324395 | 2020-07-11 | Hamilton | Tennessee | 47065 | 3361 | 38 |
321214 | 321214 | 2020-07-10 | Hamilton | Tennessee | 47065 | 3255 | 37 |
318036 | 318036 | 2020-07-09 | Hamilton | Tennessee | 47065 | 3180 | 37 |
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);