ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Dyer" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637432 | 637432 | 2020-10-16 | Dyer | Tennessee | 47045 | 1881 | 24 |
634186 | 634186 | 2020-10-15 | Dyer | Tennessee | 47045 | 1874 | 24 |
630941 | 630941 | 2020-10-14 | Dyer | Tennessee | 47045 | 1840 | 24 |
627697 | 627697 | 2020-10-13 | Dyer | Tennessee | 47045 | 1801 | 21 |
624455 | 624455 | 2020-10-12 | Dyer | Tennessee | 47045 | 1778 | 21 |
621212 | 621212 | 2020-10-11 | Dyer | Tennessee | 47045 | 1736 | 21 |
617969 | 617969 | 2020-10-10 | Dyer | Tennessee | 47045 | 1700 | 21 |
614727 | 614727 | 2020-10-09 | Dyer | Tennessee | 47045 | 1670 | 21 |
611486 | 611486 | 2020-10-08 | Dyer | Tennessee | 47045 | 1640 | 20 |
608244 | 608244 | 2020-10-07 | Dyer | Tennessee | 47045 | 1599 | 19 |
605001 | 605001 | 2020-10-06 | Dyer | Tennessee | 47045 | 1564 | 18 |
601759 | 601759 | 2020-10-05 | Dyer | Tennessee | 47045 | 1549 | 18 |
598516 | 598516 | 2020-10-04 | Dyer | Tennessee | 47045 | 1520 | 18 |
595273 | 595273 | 2020-10-03 | Dyer | Tennessee | 47045 | 1501 | 18 |
592032 | 592032 | 2020-10-02 | Dyer | Tennessee | 47045 | 1476 | 18 |
588791 | 588791 | 2020-10-01 | Dyer | Tennessee | 47045 | 1465 | 18 |
585551 | 585551 | 2020-09-30 | Dyer | Tennessee | 47045 | 1430 | 17 |
582311 | 582311 | 2020-09-29 | Dyer | Tennessee | 47045 | 1420 | 17 |
579071 | 579071 | 2020-09-28 | Dyer | Tennessee | 47045 | 1403 | 14 |
575830 | 575830 | 2020-09-27 | Dyer | Tennessee | 47045 | 1387 | 14 |
572586 | 572586 | 2020-09-26 | Dyer | Tennessee | 47045 | 1370 | 14 |
569344 | 569344 | 2020-09-25 | Dyer | Tennessee | 47045 | 1350 | 14 |
566103 | 566103 | 2020-09-24 | Dyer | Tennessee | 47045 | 1318 | 13 |
562862 | 562862 | 2020-09-23 | Dyer | Tennessee | 47045 | 1314 | 13 |
559625 | 559625 | 2020-09-22 | Dyer | Tennessee | 47045 | 1287 | 12 |
556388 | 556388 | 2020-09-21 | Dyer | Tennessee | 47045 | 1279 | 12 |
553151 | 553151 | 2020-09-20 | Dyer | Tennessee | 47045 | 1266 | 12 |
549912 | 549912 | 2020-09-19 | Dyer | Tennessee | 47045 | 1253 | 12 |
546673 | 546673 | 2020-09-18 | Dyer | Tennessee | 47045 | 1246 | 13 |
543436 | 543436 | 2020-09-17 | Dyer | Tennessee | 47045 | 1210 | 13 |
540200 | 540200 | 2020-09-16 | Dyer | Tennessee | 47045 | 1185 | 13 |
536963 | 536963 | 2020-09-15 | Dyer | Tennessee | 47045 | 1161 | 13 |
533727 | 533727 | 2020-09-14 | Dyer | Tennessee | 47045 | 1152 | 12 |
530492 | 530492 | 2020-09-13 | Dyer | Tennessee | 47045 | 1129 | 12 |
527255 | 527255 | 2020-09-12 | Dyer | Tennessee | 47045 | 1125 | 10 |
524019 | 524019 | 2020-09-11 | Dyer | Tennessee | 47045 | 1100 | 11 |
520783 | 520783 | 2020-09-10 | Dyer | Tennessee | 47045 | 1082 | 10 |
517547 | 517547 | 2020-09-09 | Dyer | Tennessee | 47045 | 1061 | 11 |
514312 | 514312 | 2020-09-08 | Dyer | Tennessee | 47045 | 1063 | 10 |
511079 | 511079 | 2020-09-07 | Dyer | Tennessee | 47045 | 1060 | 10 |
507846 | 507846 | 2020-09-06 | Dyer | Tennessee | 47045 | 1056 | 10 |
504614 | 504614 | 2020-09-05 | Dyer | Tennessee | 47045 | 1034 | 10 |
501380 | 501380 | 2020-09-04 | Dyer | Tennessee | 47045 | 1025 | 10 |
498146 | 498146 | 2020-09-03 | Dyer | Tennessee | 47045 | 1013 | 10 |
494913 | 494913 | 2020-09-02 | Dyer | Tennessee | 47045 | 988 | 10 |
491679 | 491679 | 2020-09-01 | Dyer | Tennessee | 47045 | 975 | 10 |
488446 | 488446 | 2020-08-31 | Dyer | Tennessee | 47045 | 964 | 10 |
485213 | 485213 | 2020-08-30 | Dyer | Tennessee | 47045 | 952 | 10 |
481978 | 481978 | 2020-08-29 | Dyer | Tennessee | 47045 | 947 | 10 |
478744 | 478744 | 2020-08-28 | Dyer | Tennessee | 47045 | 924 | 10 |
475511 | 475511 | 2020-08-27 | Dyer | Tennessee | 47045 | 917 | 9 |
472278 | 472278 | 2020-08-26 | Dyer | Tennessee | 47045 | 887 | 9 |
469046 | 469046 | 2020-08-25 | Dyer | Tennessee | 47045 | 866 | 9 |
465817 | 465817 | 2020-08-24 | Dyer | Tennessee | 47045 | 862 | 9 |
462588 | 462588 | 2020-08-23 | Dyer | Tennessee | 47045 | 852 | 9 |
459360 | 459360 | 2020-08-22 | Dyer | Tennessee | 47045 | 829 | 9 |
456132 | 456132 | 2020-08-21 | Dyer | Tennessee | 47045 | 809 | 9 |
452904 | 452904 | 2020-08-20 | Dyer | Tennessee | 47045 | 794 | 9 |
449676 | 449676 | 2020-08-19 | Dyer | Tennessee | 47045 | 772 | 9 |
446448 | 446448 | 2020-08-18 | Dyer | Tennessee | 47045 | 751 | 9 |
443222 | 443222 | 2020-08-17 | Dyer | Tennessee | 47045 | 747 | 9 |
439995 | 439995 | 2020-08-16 | Dyer | Tennessee | 47045 | 737 | 9 |
436770 | 436770 | 2020-08-15 | Dyer | Tennessee | 47045 | 728 | 9 |
433543 | 433543 | 2020-08-14 | Dyer | Tennessee | 47045 | 715 | 9 |
430318 | 430318 | 2020-08-13 | Dyer | Tennessee | 47045 | 696 | 9 |
427091 | 427091 | 2020-08-12 | Dyer | Tennessee | 47045 | 679 | 8 |
423868 | 423868 | 2020-08-11 | Dyer | Tennessee | 47045 | 668 | 8 |
420646 | 420646 | 2020-08-10 | Dyer | Tennessee | 47045 | 663 | 8 |
417425 | 417425 | 2020-08-09 | Dyer | Tennessee | 47045 | 650 | 8 |
414204 | 414204 | 2020-08-08 | Dyer | Tennessee | 47045 | 628 | 7 |
410984 | 410984 | 2020-08-07 | Dyer | Tennessee | 47045 | 619 | 7 |
407765 | 407765 | 2020-08-06 | Dyer | Tennessee | 47045 | 593 | 7 |
404545 | 404545 | 2020-08-05 | Dyer | Tennessee | 47045 | 579 | 7 |
401327 | 401327 | 2020-08-04 | Dyer | Tennessee | 47045 | 568 | 7 |
398112 | 398112 | 2020-08-03 | Dyer | Tennessee | 47045 | 555 | 7 |
394895 | 394895 | 2020-08-02 | Dyer | Tennessee | 47045 | 542 | 7 |
391679 | 391679 | 2020-08-01 | Dyer | Tennessee | 47045 | 534 | 7 |
388462 | 388462 | 2020-07-31 | Dyer | Tennessee | 47045 | 515 | 6 |
385245 | 385245 | 2020-07-30 | Dyer | Tennessee | 47045 | 487 | 5 |
382027 | 382027 | 2020-07-29 | Dyer | Tennessee | 47045 | 459 | 5 |
378810 | 378810 | 2020-07-28 | Dyer | Tennessee | 47045 | 457 | 5 |
375594 | 375594 | 2020-07-27 | Dyer | Tennessee | 47045 | 446 | 5 |
372381 | 372381 | 2020-07-26 | Dyer | Tennessee | 47045 | 436 | 5 |
369169 | 369169 | 2020-07-25 | Dyer | Tennessee | 47045 | 424 | 5 |
365960 | 365960 | 2020-07-24 | Dyer | Tennessee | 47045 | 416 | 5 |
362754 | 362754 | 2020-07-23 | Dyer | Tennessee | 47045 | 400 | 5 |
359547 | 359547 | 2020-07-22 | Dyer | Tennessee | 47045 | 383 | 5 |
356343 | 356343 | 2020-07-21 | Dyer | Tennessee | 47045 | 383 | 5 |
353140 | 353140 | 2020-07-20 | Dyer | Tennessee | 47045 | 373 | 4 |
349937 | 349937 | 2020-07-19 | Dyer | Tennessee | 47045 | 365 | 3 |
346737 | 346737 | 2020-07-18 | Dyer | Tennessee | 47045 | 358 | 3 |
343537 | 343537 | 2020-07-17 | Dyer | Tennessee | 47045 | 352 | 3 |
340339 | 340339 | 2020-07-16 | Dyer | Tennessee | 47045 | 337 | 3 |
337142 | 337142 | 2020-07-15 | Dyer | Tennessee | 47045 | 326 | 3 |
333948 | 333948 | 2020-07-14 | Dyer | Tennessee | 47045 | 310 | 3 |
330756 | 330756 | 2020-07-13 | Dyer | Tennessee | 47045 | 302 | 3 |
327570 | 327570 | 2020-07-12 | Dyer | Tennessee | 47045 | 292 | 3 |
324385 | 324385 | 2020-07-11 | Dyer | Tennessee | 47045 | 291 | 3 |
321204 | 321204 | 2020-07-10 | Dyer | Tennessee | 47045 | 280 | 3 |
318026 | 318026 | 2020-07-09 | Dyer | Tennessee | 47045 | 274 | 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);