ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Williamson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
634258 | 634258 | 2020-10-15 | Williamson | Tennessee | 47187 | 6274 | 47 |
631013 | 631013 | 2020-10-14 | Williamson | Tennessee | 47187 | 6194 | 47 |
627769 | 627769 | 2020-10-13 | Williamson | Tennessee | 47187 | 6163 | 47 |
624527 | 624527 | 2020-10-12 | Williamson | Tennessee | 47187 | 6113 | 46 |
621284 | 621284 | 2020-10-11 | Williamson | Tennessee | 47187 | 6018 | 46 |
618041 | 618041 | 2020-10-10 | Williamson | Tennessee | 47187 | 5969 | 46 |
614799 | 614799 | 2020-10-09 | Williamson | Tennessee | 47187 | 5910 | 44 |
611558 | 611558 | 2020-10-08 | Williamson | Tennessee | 47187 | 5833 | 42 |
608316 | 608316 | 2020-10-07 | Williamson | Tennessee | 47187 | 5798 | 41 |
605073 | 605073 | 2020-10-06 | Williamson | Tennessee | 47187 | 5735 | 40 |
601831 | 601831 | 2020-10-05 | Williamson | Tennessee | 47187 | 5674 | 40 |
598588 | 598588 | 2020-10-04 | Williamson | Tennessee | 47187 | 5572 | 40 |
595345 | 595345 | 2020-10-03 | Williamson | Tennessee | 47187 | 5505 | 40 |
592103 | 592103 | 2020-10-02 | Williamson | Tennessee | 47187 | 5478 | 38 |
588863 | 588863 | 2020-10-01 | Williamson | Tennessee | 47187 | 5455 | 38 |
585622 | 585622 | 2020-09-30 | Williamson | Tennessee | 47187 | 5423 | 36 |
582382 | 582382 | 2020-09-29 | Williamson | Tennessee | 47187 | 5366 | 36 |
579143 | 579143 | 2020-09-28 | Williamson | Tennessee | 47187 | 5341 | 36 |
575902 | 575902 | 2020-09-27 | Williamson | Tennessee | 47187 | 5310 | 36 |
572658 | 572658 | 2020-09-26 | Williamson | Tennessee | 47187 | 5252 | 36 |
569416 | 569416 | 2020-09-25 | Williamson | Tennessee | 47187 | 5198 | 36 |
566175 | 566175 | 2020-09-24 | Williamson | Tennessee | 47187 | 5165 | 36 |
562934 | 562934 | 2020-09-23 | Williamson | Tennessee | 47187 | 5139 | 36 |
559696 | 559696 | 2020-09-22 | Williamson | Tennessee | 47187 | 5096 | 36 |
556460 | 556460 | 2020-09-21 | Williamson | Tennessee | 47187 | 5089 | 36 |
553223 | 553223 | 2020-09-20 | Williamson | Tennessee | 47187 | 5077 | 36 |
549984 | 549984 | 2020-09-19 | Williamson | Tennessee | 47187 | 5030 | 36 |
546745 | 546745 | 2020-09-18 | Williamson | Tennessee | 47187 | 5019 | 36 |
543508 | 543508 | 2020-09-17 | Williamson | Tennessee | 47187 | 4956 | 35 |
540272 | 540272 | 2020-09-16 | Williamson | Tennessee | 47187 | 4940 | 35 |
537035 | 537035 | 2020-09-15 | Williamson | Tennessee | 47187 | 4879 | 35 |
533799 | 533799 | 2020-09-14 | Williamson | Tennessee | 47187 | 4851 | 35 |
530564 | 530564 | 2020-09-13 | Williamson | Tennessee | 47187 | 4788 | 35 |
527327 | 527327 | 2020-09-12 | Williamson | Tennessee | 47187 | 4755 | 35 |
524091 | 524091 | 2020-09-11 | Williamson | Tennessee | 47187 | 4733 | 34 |
520855 | 520855 | 2020-09-10 | Williamson | Tennessee | 47187 | 4685 | 34 |
517619 | 517619 | 2020-09-09 | Williamson | Tennessee | 47187 | 4609 | 32 |
514384 | 514384 | 2020-09-08 | Williamson | Tennessee | 47187 | 4585 | 32 |
511151 | 511151 | 2020-09-07 | Williamson | Tennessee | 47187 | 4572 | 31 |
507918 | 507918 | 2020-09-06 | Williamson | Tennessee | 47187 | 4548 | 30 |
504686 | 504686 | 2020-09-05 | Williamson | Tennessee | 47187 | 4501 | 30 |
501452 | 501452 | 2020-09-04 | Williamson | Tennessee | 47187 | 4455 | 30 |
498218 | 498218 | 2020-09-03 | Williamson | Tennessee | 47187 | 4424 | 29 |
494985 | 494985 | 2020-09-02 | Williamson | Tennessee | 47187 | 4465 | 30 |
491751 | 491751 | 2020-09-01 | Williamson | Tennessee | 47187 | 4422 | 30 |
488518 | 488518 | 2020-08-31 | Williamson | Tennessee | 47187 | 4369 | 28 |
485285 | 485285 | 2020-08-30 | Williamson | Tennessee | 47187 | 4334 | 28 |
482050 | 482050 | 2020-08-29 | Williamson | Tennessee | 47187 | 4328 | 27 |
478816 | 478816 | 2020-08-28 | Williamson | Tennessee | 47187 | 4295 | 27 |
475583 | 475583 | 2020-08-27 | Williamson | Tennessee | 47187 | 4260 | 27 |
472350 | 472350 | 2020-08-26 | Williamson | Tennessee | 47187 | 4210 | 27 |
469118 | 469118 | 2020-08-25 | Williamson | Tennessee | 47187 | 4165 | 27 |
465889 | 465889 | 2020-08-24 | Williamson | Tennessee | 47187 | 4157 | 27 |
462660 | 462660 | 2020-08-23 | Williamson | Tennessee | 47187 | 4140 | 27 |
459431 | 459431 | 2020-08-22 | Williamson | Tennessee | 47187 | 4096 | 27 |
456204 | 456204 | 2020-08-21 | Williamson | Tennessee | 47187 | 4055 | 27 |
452976 | 452976 | 2020-08-20 | Williamson | Tennessee | 47187 | 4014 | 26 |
449748 | 449748 | 2020-08-19 | Williamson | Tennessee | 47187 | 3979 | 26 |
446520 | 446520 | 2020-08-18 | Williamson | Tennessee | 47187 | 3932 | 27 |
443293 | 443293 | 2020-08-17 | Williamson | Tennessee | 47187 | 3893 | 26 |
440067 | 440067 | 2020-08-16 | Williamson | Tennessee | 47187 | 3861 | 26 |
436841 | 436841 | 2020-08-15 | Williamson | Tennessee | 47187 | 3812 | 26 |
433615 | 433615 | 2020-08-14 | Williamson | Tennessee | 47187 | 3741 | 25 |
430390 | 430390 | 2020-08-13 | Williamson | Tennessee | 47187 | 3702 | 25 |
427163 | 427163 | 2020-08-12 | Williamson | Tennessee | 47187 | 3656 | 26 |
423939 | 423939 | 2020-08-11 | Williamson | Tennessee | 47187 | 3607 | 25 |
420718 | 420718 | 2020-08-10 | Williamson | Tennessee | 47187 | 3577 | 25 |
417497 | 417497 | 2020-08-09 | Williamson | Tennessee | 47187 | 3551 | 25 |
414276 | 414276 | 2020-08-08 | Williamson | Tennessee | 47187 | 3478 | 25 |
411056 | 411056 | 2020-08-07 | Williamson | Tennessee | 47187 | 3448 | 25 |
407837 | 407837 | 2020-08-06 | Williamson | Tennessee | 47187 | 3405 | 25 |
404617 | 404617 | 2020-08-05 | Williamson | Tennessee | 47187 | 3363 | 22 |
401399 | 401399 | 2020-08-04 | Williamson | Tennessee | 47187 | 3308 | 22 |
398183 | 398183 | 2020-08-03 | Williamson | Tennessee | 47187 | 3269 | 22 |
394967 | 394967 | 2020-08-02 | Williamson | Tennessee | 47187 | 3230 | 22 |
391751 | 391751 | 2020-08-01 | Williamson | Tennessee | 47187 | 3193 | 22 |
388534 | 388534 | 2020-07-31 | Williamson | Tennessee | 47187 | 3132 | 22 |
385317 | 385317 | 2020-07-30 | Williamson | Tennessee | 47187 | 3056 | 22 |
382099 | 382099 | 2020-07-29 | Williamson | Tennessee | 47187 | 3021 | 22 |
378882 | 378882 | 2020-07-28 | Williamson | Tennessee | 47187 | 2986 | 21 |
375666 | 375666 | 2020-07-27 | Williamson | Tennessee | 47187 | 2943 | 21 |
372453 | 372453 | 2020-07-26 | Williamson | Tennessee | 47187 | 2896 | 21 |
369241 | 369241 | 2020-07-25 | Williamson | Tennessee | 47187 | 2812 | 21 |
366032 | 366032 | 2020-07-24 | Williamson | Tennessee | 47187 | 2788 | 21 |
362826 | 362826 | 2020-07-23 | Williamson | Tennessee | 47187 | 2717 | 21 |
359619 | 359619 | 2020-07-22 | Williamson | Tennessee | 47187 | 2648 | 19 |
356414 | 356414 | 2020-07-21 | Williamson | Tennessee | 47187 | 2599 | 18 |
353211 | 353211 | 2020-07-20 | Williamson | Tennessee | 47187 | 2562 | 18 |
350009 | 350009 | 2020-07-19 | Williamson | Tennessee | 47187 | 2517 | 18 |
346809 | 346809 | 2020-07-18 | Williamson | Tennessee | 47187 | 2449 | 18 |
343609 | 343609 | 2020-07-17 | Williamson | Tennessee | 47187 | 2309 | 18 |
340410 | 340410 | 2020-07-16 | Williamson | Tennessee | 47187 | 2217 | 18 |
337214 | 337214 | 2020-07-15 | Williamson | Tennessee | 47187 | 2119 | 18 |
334019 | 334019 | 2020-07-14 | Williamson | Tennessee | 47187 | 1990 | 16 |
330828 | 330828 | 2020-07-13 | Williamson | Tennessee | 47187 | 1939 | 16 |
327642 | 327642 | 2020-07-12 | Williamson | Tennessee | 47187 | 1763 | 16 |
324457 | 324457 | 2020-07-11 | Williamson | Tennessee | 47187 | 1708 | 16 |
321276 | 321276 | 2020-07-10 | Williamson | Tennessee | 47187 | 1670 | 16 |
318098 | 318098 | 2020-07-09 | Williamson | Tennessee | 47187 | 1591 | 15 |
314925 | 314925 | 2020-07-08 | Williamson | Tennessee | 47187 | 1515 | 15 |
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);