ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 47189 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637504 | 637504 | 2020-10-16 | Wilson | Tennessee | 47189 | 4184 | 52 |
634259 | 634259 | 2020-10-15 | Wilson | Tennessee | 47189 | 4176 | 52 |
631014 | 631014 | 2020-10-14 | Wilson | Tennessee | 47189 | 4155 | 52 |
627770 | 627770 | 2020-10-13 | Wilson | Tennessee | 47189 | 4118 | 52 |
624528 | 624528 | 2020-10-12 | Wilson | Tennessee | 47189 | 4074 | 52 |
621285 | 621285 | 2020-10-11 | Wilson | Tennessee | 47189 | 4011 | 52 |
618042 | 618042 | 2020-10-10 | Wilson | Tennessee | 47189 | 3971 | 52 |
614800 | 614800 | 2020-10-09 | Wilson | Tennessee | 47189 | 3931 | 52 |
611559 | 611559 | 2020-10-08 | Wilson | Tennessee | 47189 | 3908 | 52 |
608317 | 608317 | 2020-10-07 | Wilson | Tennessee | 47189 | 3863 | 50 |
605074 | 605074 | 2020-10-06 | Wilson | Tennessee | 47189 | 3827 | 50 |
601832 | 601832 | 2020-10-05 | Wilson | Tennessee | 47189 | 3788 | 49 |
598589 | 598589 | 2020-10-04 | Wilson | Tennessee | 47189 | 3717 | 49 |
595346 | 595346 | 2020-10-03 | Wilson | Tennessee | 47189 | 3675 | 49 |
592104 | 592104 | 2020-10-02 | Wilson | Tennessee | 47189 | 3653 | 49 |
588864 | 588864 | 2020-10-01 | Wilson | Tennessee | 47189 | 3636 | 48 |
585623 | 585623 | 2020-09-30 | Wilson | Tennessee | 47189 | 3605 | 47 |
582383 | 582383 | 2020-09-29 | Wilson | Tennessee | 47189 | 3562 | 47 |
579144 | 579144 | 2020-09-28 | Wilson | Tennessee | 47189 | 3538 | 45 |
575903 | 575903 | 2020-09-27 | Wilson | Tennessee | 47189 | 3519 | 45 |
572659 | 572659 | 2020-09-26 | Wilson | Tennessee | 47189 | 3476 | 45 |
569417 | 569417 | 2020-09-25 | Wilson | Tennessee | 47189 | 3453 | 44 |
566176 | 566176 | 2020-09-24 | Wilson | Tennessee | 47189 | 3418 | 44 |
562935 | 562935 | 2020-09-23 | Wilson | Tennessee | 47189 | 3412 | 43 |
559697 | 559697 | 2020-09-22 | Wilson | Tennessee | 47189 | 3384 | 43 |
556461 | 556461 | 2020-09-21 | Wilson | Tennessee | 47189 | 3373 | 43 |
553224 | 553224 | 2020-09-20 | Wilson | Tennessee | 47189 | 3358 | 41 |
549985 | 549985 | 2020-09-19 | Wilson | Tennessee | 47189 | 3318 | 41 |
546746 | 546746 | 2020-09-18 | Wilson | Tennessee | 47189 | 3308 | 39 |
543509 | 543509 | 2020-09-17 | Wilson | Tennessee | 47189 | 3259 | 38 |
540273 | 540273 | 2020-09-16 | Wilson | Tennessee | 47189 | 3246 | 37 |
537036 | 537036 | 2020-09-15 | Wilson | Tennessee | 47189 | 3223 | 37 |
533800 | 533800 | 2020-09-14 | Wilson | Tennessee | 47189 | 3210 | 37 |
530565 | 530565 | 2020-09-13 | Wilson | Tennessee | 47189 | 3173 | 36 |
527328 | 527328 | 2020-09-12 | Wilson | Tennessee | 47189 | 3162 | 36 |
524092 | 524092 | 2020-09-11 | Wilson | Tennessee | 47189 | 3143 | 35 |
520856 | 520856 | 2020-09-10 | Wilson | Tennessee | 47189 | 3107 | 35 |
517620 | 517620 | 2020-09-09 | Wilson | Tennessee | 47189 | 3074 | 31 |
514385 | 514385 | 2020-09-08 | Wilson | Tennessee | 47189 | 3059 | 31 |
511152 | 511152 | 2020-09-07 | Wilson | Tennessee | 47189 | 3043 | 31 |
507919 | 507919 | 2020-09-06 | Wilson | Tennessee | 47189 | 3022 | 31 |
504687 | 504687 | 2020-09-05 | Wilson | Tennessee | 47189 | 2993 | 31 |
501453 | 501453 | 2020-09-04 | Wilson | Tennessee | 47189 | 2954 | 31 |
498219 | 498219 | 2020-09-03 | Wilson | Tennessee | 47189 | 2943 | 31 |
494986 | 494986 | 2020-09-02 | Wilson | Tennessee | 47189 | 2900 | 31 |
491752 | 491752 | 2020-09-01 | Wilson | Tennessee | 47189 | 2870 | 31 |
488519 | 488519 | 2020-08-31 | Wilson | Tennessee | 47189 | 2828 | 31 |
485286 | 485286 | 2020-08-30 | Wilson | Tennessee | 47189 | 2811 | 31 |
482051 | 482051 | 2020-08-29 | Wilson | Tennessee | 47189 | 2791 | 31 |
478817 | 478817 | 2020-08-28 | Wilson | Tennessee | 47189 | 2764 | 31 |
475584 | 475584 | 2020-08-27 | Wilson | Tennessee | 47189 | 2739 | 31 |
472351 | 472351 | 2020-08-26 | Wilson | Tennessee | 47189 | 2712 | 31 |
469119 | 469119 | 2020-08-25 | Wilson | Tennessee | 47189 | 2672 | 30 |
465890 | 465890 | 2020-08-24 | Wilson | Tennessee | 47189 | 2664 | 30 |
462661 | 462661 | 2020-08-23 | Wilson | Tennessee | 47189 | 2659 | 29 |
459432 | 459432 | 2020-08-22 | Wilson | Tennessee | 47189 | 2627 | 29 |
456205 | 456205 | 2020-08-21 | Wilson | Tennessee | 47189 | 2604 | 28 |
452977 | 452977 | 2020-08-20 | Wilson | Tennessee | 47189 | 2581 | 27 |
449749 | 449749 | 2020-08-19 | Wilson | Tennessee | 47189 | 2563 | 26 |
446521 | 446521 | 2020-08-18 | Wilson | Tennessee | 47189 | 2526 | 26 |
443294 | 443294 | 2020-08-17 | Wilson | Tennessee | 47189 | 2501 | 25 |
440068 | 440068 | 2020-08-16 | Wilson | Tennessee | 47189 | 2484 | 24 |
436842 | 436842 | 2020-08-15 | Wilson | Tennessee | 47189 | 2457 | 23 |
433616 | 433616 | 2020-08-14 | Wilson | Tennessee | 47189 | 2434 | 23 |
430391 | 430391 | 2020-08-13 | Wilson | Tennessee | 47189 | 2411 | 23 |
427164 | 427164 | 2020-08-12 | Wilson | Tennessee | 47189 | 2374 | 23 |
423940 | 423940 | 2020-08-11 | Wilson | Tennessee | 47189 | 2339 | 23 |
420719 | 420719 | 2020-08-10 | Wilson | Tennessee | 47189 | 2321 | 23 |
417498 | 417498 | 2020-08-09 | Wilson | Tennessee | 47189 | 2290 | 23 |
414277 | 414277 | 2020-08-08 | Wilson | Tennessee | 47189 | 2262 | 23 |
411057 | 411057 | 2020-08-07 | Wilson | Tennessee | 47189 | 2229 | 23 |
407838 | 407838 | 2020-08-06 | Wilson | Tennessee | 47189 | 2190 | 23 |
404618 | 404618 | 2020-08-05 | Wilson | Tennessee | 47189 | 2152 | 23 |
401400 | 401400 | 2020-08-04 | Wilson | Tennessee | 47189 | 2102 | 22 |
398184 | 398184 | 2020-08-03 | Wilson | Tennessee | 47189 | 2072 | 21 |
394968 | 394968 | 2020-08-02 | Wilson | Tennessee | 47189 | 2064 | 20 |
391752 | 391752 | 2020-08-01 | Wilson | Tennessee | 47189 | 2041 | 20 |
388535 | 388535 | 2020-07-31 | Wilson | Tennessee | 47189 | 2001 | 20 |
385318 | 385318 | 2020-07-30 | Wilson | Tennessee | 47189 | 1973 | 20 |
382100 | 382100 | 2020-07-29 | Wilson | Tennessee | 47189 | 1941 | 20 |
378883 | 378883 | 2020-07-28 | Wilson | Tennessee | 47189 | 1902 | 20 |
375667 | 375667 | 2020-07-27 | Wilson | Tennessee | 47189 | 1876 | 20 |
372454 | 372454 | 2020-07-26 | Wilson | Tennessee | 47189 | 1840 | 20 |
369242 | 369242 | 2020-07-25 | Wilson | Tennessee | 47189 | 1790 | 20 |
366033 | 366033 | 2020-07-24 | Wilson | Tennessee | 47189 | 1777 | 20 |
362827 | 362827 | 2020-07-23 | Wilson | Tennessee | 47189 | 1746 | 20 |
359620 | 359620 | 2020-07-22 | Wilson | Tennessee | 47189 | 1688 | 19 |
356415 | 356415 | 2020-07-21 | Wilson | Tennessee | 47189 | 1664 | 19 |
353212 | 353212 | 2020-07-20 | Wilson | Tennessee | 47189 | 1628 | 19 |
350010 | 350010 | 2020-07-19 | Wilson | Tennessee | 47189 | 1601 | 19 |
346810 | 346810 | 2020-07-18 | Wilson | Tennessee | 47189 | 1553 | 18 |
343610 | 343610 | 2020-07-17 | Wilson | Tennessee | 47189 | 1457 | 18 |
340411 | 340411 | 2020-07-16 | Wilson | Tennessee | 47189 | 1412 | 18 |
337215 | 337215 | 2020-07-15 | Wilson | Tennessee | 47189 | 1338 | 18 |
334020 | 334020 | 2020-07-14 | Wilson | Tennessee | 47189 | 1275 | 17 |
330829 | 330829 | 2020-07-13 | Wilson | Tennessee | 47189 | 1261 | 17 |
327643 | 327643 | 2020-07-12 | Wilson | Tennessee | 47189 | 1187 | 17 |
324458 | 324458 | 2020-07-11 | Wilson | Tennessee | 47189 | 1148 | 17 |
321277 | 321277 | 2020-07-10 | Wilson | Tennessee | 47189 | 1130 | 17 |
318099 | 318099 | 2020-07-09 | Wilson | Tennessee | 47189 | 1099 | 17 |
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);