ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47043 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637431 | 637431 | 2020-10-16 | Dickson | Tennessee | 47043 | 1499 | 18 |
634185 | 634185 | 2020-10-15 | Dickson | Tennessee | 47043 | 1487 | 18 |
630940 | 630940 | 2020-10-14 | Dickson | Tennessee | 47043 | 1472 | 17 |
627696 | 627696 | 2020-10-13 | Dickson | Tennessee | 47043 | 1462 | 17 |
624454 | 624454 | 2020-10-12 | Dickson | Tennessee | 47043 | 1441 | 17 |
621211 | 621211 | 2020-10-11 | Dickson | Tennessee | 47043 | 1419 | 17 |
617968 | 617968 | 2020-10-10 | Dickson | Tennessee | 47043 | 1415 | 17 |
614726 | 614726 | 2020-10-09 | Dickson | Tennessee | 47043 | 1407 | 17 |
611485 | 611485 | 2020-10-08 | Dickson | Tennessee | 47043 | 1403 | 17 |
608243 | 608243 | 2020-10-07 | Dickson | Tennessee | 47043 | 1385 | 17 |
605000 | 605000 | 2020-10-06 | Dickson | Tennessee | 47043 | 1372 | 17 |
601758 | 601758 | 2020-10-05 | Dickson | Tennessee | 47043 | 1360 | 17 |
598515 | 598515 | 2020-10-04 | Dickson | Tennessee | 47043 | 1329 | 17 |
595272 | 595272 | 2020-10-03 | Dickson | Tennessee | 47043 | 1321 | 17 |
592031 | 592031 | 2020-10-02 | Dickson | Tennessee | 47043 | 1314 | 17 |
588790 | 588790 | 2020-10-01 | Dickson | Tennessee | 47043 | 1309 | 17 |
585550 | 585550 | 2020-09-30 | Dickson | Tennessee | 47043 | 1297 | 16 |
582310 | 582310 | 2020-09-29 | Dickson | Tennessee | 47043 | 1280 | 15 |
579070 | 579070 | 2020-09-28 | Dickson | Tennessee | 47043 | 1277 | 15 |
575829 | 575829 | 2020-09-27 | Dickson | Tennessee | 47043 | 1274 | 15 |
572585 | 572585 | 2020-09-26 | Dickson | Tennessee | 47043 | 1257 | 15 |
569343 | 569343 | 2020-09-25 | Dickson | Tennessee | 47043 | 1250 | 15 |
566102 | 566102 | 2020-09-24 | Dickson | Tennessee | 47043 | 1235 | 15 |
562861 | 562861 | 2020-09-23 | Dickson | Tennessee | 47043 | 1230 | 14 |
559624 | 559624 | 2020-09-22 | Dickson | Tennessee | 47043 | 1207 | 14 |
556387 | 556387 | 2020-09-21 | Dickson | Tennessee | 47043 | 1199 | 13 |
553150 | 553150 | 2020-09-20 | Dickson | Tennessee | 47043 | 1193 | 12 |
549911 | 549911 | 2020-09-19 | Dickson | Tennessee | 47043 | 1176 | 12 |
546672 | 546672 | 2020-09-18 | Dickson | Tennessee | 47043 | 1166 | 12 |
543435 | 543435 | 2020-09-17 | Dickson | Tennessee | 47043 | 1156 | 12 |
540199 | 540199 | 2020-09-16 | Dickson | Tennessee | 47043 | 1148 | 12 |
536962 | 536962 | 2020-09-15 | Dickson | Tennessee | 47043 | 1138 | 12 |
533726 | 533726 | 2020-09-14 | Dickson | Tennessee | 47043 | 1131 | 12 |
530491 | 530491 | 2020-09-13 | Dickson | Tennessee | 47043 | 1111 | 12 |
527254 | 527254 | 2020-09-12 | Dickson | Tennessee | 47043 | 1110 | 12 |
524018 | 524018 | 2020-09-11 | Dickson | Tennessee | 47043 | 1103 | 11 |
520782 | 520782 | 2020-09-10 | Dickson | Tennessee | 47043 | 1094 | 11 |
517546 | 517546 | 2020-09-09 | Dickson | Tennessee | 47043 | 1090 | 10 |
514311 | 514311 | 2020-09-08 | Dickson | Tennessee | 47043 | 1077 | 9 |
511078 | 511078 | 2020-09-07 | Dickson | Tennessee | 47043 | 1015 | 9 |
507845 | 507845 | 2020-09-06 | Dickson | Tennessee | 47043 | 1008 | 9 |
504613 | 504613 | 2020-09-05 | Dickson | Tennessee | 47043 | 988 | 9 |
501379 | 501379 | 2020-09-04 | Dickson | Tennessee | 47043 | 970 | 9 |
498145 | 498145 | 2020-09-03 | Dickson | Tennessee | 47043 | 955 | 9 |
494912 | 494912 | 2020-09-02 | Dickson | Tennessee | 47043 | 932 | 9 |
491678 | 491678 | 2020-09-01 | Dickson | Tennessee | 47043 | 920 | 9 |
488445 | 488445 | 2020-08-31 | Dickson | Tennessee | 47043 | 913 | 9 |
485212 | 485212 | 2020-08-30 | Dickson | Tennessee | 47043 | 907 | 9 |
481977 | 481977 | 2020-08-29 | Dickson | Tennessee | 47043 | 904 | 9 |
478743 | 478743 | 2020-08-28 | Dickson | Tennessee | 47043 | 906 | 9 |
475510 | 475510 | 2020-08-27 | Dickson | Tennessee | 47043 | 890 | 9 |
472277 | 472277 | 2020-08-26 | Dickson | Tennessee | 47043 | 877 | 9 |
469045 | 469045 | 2020-08-25 | Dickson | Tennessee | 47043 | 861 | 8 |
465816 | 465816 | 2020-08-24 | Dickson | Tennessee | 47043 | 851 | 8 |
462587 | 462587 | 2020-08-23 | Dickson | Tennessee | 47043 | 844 | 7 |
459359 | 459359 | 2020-08-22 | Dickson | Tennessee | 47043 | 832 | 7 |
456131 | 456131 | 2020-08-21 | Dickson | Tennessee | 47043 | 832 | 7 |
452903 | 452903 | 2020-08-20 | Dickson | Tennessee | 47043 | 813 | 5 |
449675 | 449675 | 2020-08-19 | Dickson | Tennessee | 47043 | 807 | 5 |
446447 | 446447 | 2020-08-18 | Dickson | Tennessee | 47043 | 794 | 4 |
443221 | 443221 | 2020-08-17 | Dickson | Tennessee | 47043 | 784 | 4 |
439994 | 439994 | 2020-08-16 | Dickson | Tennessee | 47043 | 777 | 4 |
436769 | 436769 | 2020-08-15 | Dickson | Tennessee | 47043 | 766 | 4 |
433542 | 433542 | 2020-08-14 | Dickson | Tennessee | 47043 | 757 | 4 |
430317 | 430317 | 2020-08-13 | Dickson | Tennessee | 47043 | 743 | 3 |
427090 | 427090 | 2020-08-12 | Dickson | Tennessee | 47043 | 718 | 3 |
423867 | 423867 | 2020-08-11 | Dickson | Tennessee | 47043 | 705 | 2 |
420645 | 420645 | 2020-08-10 | Dickson | Tennessee | 47043 | 698 | 2 |
417424 | 417424 | 2020-08-09 | Dickson | Tennessee | 47043 | 691 | 2 |
414203 | 414203 | 2020-08-08 | Dickson | Tennessee | 47043 | 679 | 2 |
410983 | 410983 | 2020-08-07 | Dickson | Tennessee | 47043 | 666 | 2 |
407764 | 407764 | 2020-08-06 | Dickson | Tennessee | 47043 | 652 | 1 |
404544 | 404544 | 2020-08-05 | Dickson | Tennessee | 47043 | 630 | 1 |
401326 | 401326 | 2020-08-04 | Dickson | Tennessee | 47043 | 609 | 1 |
398111 | 398111 | 2020-08-03 | Dickson | Tennessee | 47043 | 595 | 1 |
394894 | 394894 | 2020-08-02 | Dickson | Tennessee | 47043 | 587 | 1 |
391678 | 391678 | 2020-08-01 | Dickson | Tennessee | 47043 | 580 | 1 |
388461 | 388461 | 2020-07-31 | Dickson | Tennessee | 47043 | 575 | 1 |
385244 | 385244 | 2020-07-30 | Dickson | Tennessee | 47043 | 550 | 1 |
382026 | 382026 | 2020-07-29 | Dickson | Tennessee | 47043 | 534 | 1 |
378809 | 378809 | 2020-07-28 | Dickson | Tennessee | 47043 | 510 | 1 |
375593 | 375593 | 2020-07-27 | Dickson | Tennessee | 47043 | 499 | 1 |
372380 | 372380 | 2020-07-26 | Dickson | Tennessee | 47043 | 491 | 0 |
369168 | 369168 | 2020-07-25 | Dickson | Tennessee | 47043 | 471 | 0 |
365959 | 365959 | 2020-07-24 | Dickson | Tennessee | 47043 | 447 | 0 |
362753 | 362753 | 2020-07-23 | Dickson | Tennessee | 47043 | 421 | 0 |
359546 | 359546 | 2020-07-22 | Dickson | Tennessee | 47043 | 402 | 0 |
356342 | 356342 | 2020-07-21 | Dickson | Tennessee | 47043 | 398 | 0 |
353139 | 353139 | 2020-07-20 | Dickson | Tennessee | 47043 | 390 | 0 |
349936 | 349936 | 2020-07-19 | Dickson | Tennessee | 47043 | 376 | 0 |
346736 | 346736 | 2020-07-18 | Dickson | Tennessee | 47043 | 370 | 0 |
343536 | 343536 | 2020-07-17 | Dickson | Tennessee | 47043 | 343 | 0 |
340338 | 340338 | 2020-07-16 | Dickson | Tennessee | 47043 | 323 | 0 |
337141 | 337141 | 2020-07-15 | Dickson | Tennessee | 47043 | 308 | 0 |
333947 | 333947 | 2020-07-14 | Dickson | Tennessee | 47043 | 295 | 0 |
330755 | 330755 | 2020-07-13 | Dickson | Tennessee | 47043 | 282 | 0 |
327569 | 327569 | 2020-07-12 | Dickson | Tennessee | 47043 | 275 | 0 |
324384 | 324384 | 2020-07-11 | Dickson | Tennessee | 47043 | 258 | 0 |
321203 | 321203 | 2020-07-10 | Dickson | Tennessee | 47043 | 251 | 0 |
318025 | 318025 | 2020-07-09 | Dickson | Tennessee | 47043 | 243 | 0 |
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);