ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Hamilton" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
314863 | 314863 | 2020-07-08 | Hamilton | Tennessee | 47065 | 3076 | 36 |
311689 | 311689 | 2020-07-07 | Hamilton | Tennessee | 47065 | 2982 | 36 |
308520 | 308520 | 2020-07-06 | Hamilton | Tennessee | 47065 | 2909 | 35 |
305352 | 305352 | 2020-07-05 | Hamilton | Tennessee | 47065 | 2871 | 35 |
302189 | 302189 | 2020-07-04 | Hamilton | Tennessee | 47065 | 2818 | 35 |
299025 | 299025 | 2020-07-03 | Hamilton | Tennessee | 47065 | 2782 | 33 |
295865 | 295865 | 2020-07-02 | Hamilton | Tennessee | 47065 | 2704 | 30 |
292709 | 292709 | 2020-07-01 | Hamilton | Tennessee | 47065 | 2643 | 30 |
289557 | 289557 | 2020-06-30 | Hamilton | Tennessee | 47065 | 2525 | 30 |
286406 | 286406 | 2020-06-29 | Hamilton | Tennessee | 47065 | 2469 | 30 |
283261 | 283261 | 2020-06-28 | Hamilton | Tennessee | 47065 | 2423 | 29 |
280115 | 280115 | 2020-06-27 | Hamilton | Tennessee | 47065 | 2423 | 29 |
276967 | 276967 | 2020-06-26 | Hamilton | Tennessee | 47065 | 2356 | 29 |
273820 | 273820 | 2020-06-25 | Hamilton | Tennessee | 47065 | 2322 | 29 |
270681 | 270681 | 2020-06-24 | Hamilton | Tennessee | 47065 | 2277 | 29 |
267547 | 267547 | 2020-06-23 | Hamilton | Tennessee | 47065 | 2209 | 29 |
264419 | 264419 | 2020-06-22 | Hamilton | Tennessee | 47065 | 2174 | 28 |
261291 | 261291 | 2020-06-21 | Hamilton | Tennessee | 47065 | 2138 | 26 |
258164 | 258164 | 2020-06-20 | Hamilton | Tennessee | 47065 | 2121 | 25 |
255038 | 255038 | 2020-06-19 | Hamilton | Tennessee | 47065 | 2102 | 25 |
251923 | 251923 | 2020-06-18 | Hamilton | Tennessee | 47065 | 2065 | 25 |
248808 | 248808 | 2020-06-17 | Hamilton | Tennessee | 47065 | 1988 | 24 |
245695 | 245695 | 2020-06-16 | Hamilton | Tennessee | 47065 | 1941 | 22 |
242583 | 242583 | 2020-06-15 | Hamilton | Tennessee | 47065 | 1889 | 22 |
239473 | 239473 | 2020-06-14 | Hamilton | Tennessee | 47065 | 1842 | 20 |
236365 | 236365 | 2020-06-13 | Hamilton | Tennessee | 47065 | 1788 | 20 |
233259 | 233259 | 2020-06-12 | Hamilton | Tennessee | 47065 | 1751 | 20 |
230154 | 230154 | 2020-06-11 | Hamilton | Tennessee | 47065 | 1692 | 19 |
227050 | 227050 | 2020-06-10 | Hamilton | Tennessee | 47065 | 1645 | 19 |
223950 | 223950 | 2020-06-09 | Hamilton | Tennessee | 47065 | 1556 | 19 |
220855 | 220855 | 2020-06-08 | Hamilton | Tennessee | 47065 | 1486 | 19 |
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);