ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Blount" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637414 | 637414 | 2020-10-16 | Blount | Tennessee | 47009 | 3001 | 31 |
634168 | 634168 | 2020-10-15 | Blount | Tennessee | 47009 | 2974 | 31 |
630923 | 630923 | 2020-10-14 | Blount | Tennessee | 47009 | 2947 | 31 |
627679 | 627679 | 2020-10-13 | Blount | Tennessee | 47009 | 2911 | 31 |
624437 | 624437 | 2020-10-12 | Blount | Tennessee | 47009 | 2881 | 30 |
621194 | 621194 | 2020-10-11 | Blount | Tennessee | 47009 | 2852 | 30 |
617951 | 617951 | 2020-10-10 | Blount | Tennessee | 47009 | 2834 | 30 |
614709 | 614709 | 2020-10-09 | Blount | Tennessee | 47009 | 2815 | 28 |
611468 | 611468 | 2020-10-08 | Blount | Tennessee | 47009 | 2772 | 28 |
608226 | 608226 | 2020-10-07 | Blount | Tennessee | 47009 | 2741 | 28 |
604983 | 604983 | 2020-10-06 | Blount | Tennessee | 47009 | 2707 | 28 |
601741 | 601741 | 2020-10-05 | Blount | Tennessee | 47009 | 2696 | 28 |
598498 | 598498 | 2020-10-04 | Blount | Tennessee | 47009 | 2678 | 27 |
595255 | 595255 | 2020-10-03 | Blount | Tennessee | 47009 | 2658 | 27 |
592014 | 592014 | 2020-10-02 | Blount | Tennessee | 47009 | 2629 | 27 |
588773 | 588773 | 2020-10-01 | Blount | Tennessee | 47009 | 2616 | 27 |
585533 | 585533 | 2020-09-30 | Blount | Tennessee | 47009 | 2589 | 24 |
582293 | 582293 | 2020-09-29 | Blount | Tennessee | 47009 | 2563 | 24 |
579053 | 579053 | 2020-09-28 | Blount | Tennessee | 47009 | 2548 | 24 |
575812 | 575812 | 2020-09-27 | Blount | Tennessee | 47009 | 2535 | 24 |
572568 | 572568 | 2020-09-26 | Blount | Tennessee | 47009 | 2516 | 24 |
569326 | 569326 | 2020-09-25 | Blount | Tennessee | 47009 | 2504 | 24 |
566085 | 566085 | 2020-09-24 | Blount | Tennessee | 47009 | 2477 | 23 |
562844 | 562844 | 2020-09-23 | Blount | Tennessee | 47009 | 2461 | 23 |
559607 | 559607 | 2020-09-22 | Blount | Tennessee | 47009 | 2449 | 23 |
556370 | 556370 | 2020-09-21 | Blount | Tennessee | 47009 | 2440 | 23 |
553133 | 553133 | 2020-09-20 | Blount | Tennessee | 47009 | 2433 | 23 |
549894 | 549894 | 2020-09-19 | Blount | Tennessee | 47009 | 2425 | 23 |
546655 | 546655 | 2020-09-18 | Blount | Tennessee | 47009 | 2411 | 23 |
543418 | 543418 | 2020-09-17 | Blount | Tennessee | 47009 | 2387 | 21 |
540182 | 540182 | 2020-09-16 | Blount | Tennessee | 47009 | 2376 | 21 |
536945 | 536945 | 2020-09-15 | Blount | Tennessee | 47009 | 2355 | 21 |
533709 | 533709 | 2020-09-14 | Blount | Tennessee | 47009 | 2344 | 21 |
530474 | 530474 | 2020-09-13 | Blount | Tennessee | 47009 | 2314 | 21 |
527237 | 527237 | 2020-09-12 | Blount | Tennessee | 47009 | 2306 | 20 |
524001 | 524001 | 2020-09-11 | Blount | Tennessee | 47009 | 2293 | 19 |
520765 | 520765 | 2020-09-10 | Blount | Tennessee | 47009 | 2264 | 19 |
517529 | 517529 | 2020-09-09 | Blount | Tennessee | 47009 | 2168 | 18 |
514294 | 514294 | 2020-09-08 | Blount | Tennessee | 47009 | 2152 | 17 |
511061 | 511061 | 2020-09-07 | Blount | Tennessee | 47009 | 2147 | 17 |
507828 | 507828 | 2020-09-06 | Blount | Tennessee | 47009 | 2142 | 17 |
504596 | 504596 | 2020-09-05 | Blount | Tennessee | 47009 | 2128 | 17 |
501362 | 501362 | 2020-09-04 | Blount | Tennessee | 47009 | 2111 | 17 |
498128 | 498128 | 2020-09-03 | Blount | Tennessee | 47009 | 2076 | 17 |
494895 | 494895 | 2020-09-02 | Blount | Tennessee | 47009 | 2032 | 17 |
491661 | 491661 | 2020-09-01 | Blount | Tennessee | 47009 | 2021 | 17 |
488428 | 488428 | 2020-08-31 | Blount | Tennessee | 47009 | 2010 | 17 |
485195 | 485195 | 2020-08-30 | Blount | Tennessee | 47009 | 2003 | 17 |
481960 | 481960 | 2020-08-29 | Blount | Tennessee | 47009 | 1992 | 17 |
478726 | 478726 | 2020-08-28 | Blount | Tennessee | 47009 | 1962 | 17 |
475493 | 475493 | 2020-08-27 | Blount | Tennessee | 47009 | 1940 | 17 |
472260 | 472260 | 2020-08-26 | Blount | Tennessee | 47009 | 1770 | 17 |
469028 | 469028 | 2020-08-25 | Blount | Tennessee | 47009 | 1753 | 16 |
465799 | 465799 | 2020-08-24 | Blount | Tennessee | 47009 | 1744 | 15 |
462570 | 462570 | 2020-08-23 | Blount | Tennessee | 47009 | 1732 | 15 |
459342 | 459342 | 2020-08-22 | Blount | Tennessee | 47009 | 1715 | 15 |
456114 | 456114 | 2020-08-21 | Blount | Tennessee | 47009 | 1677 | 15 |
452886 | 452886 | 2020-08-20 | Blount | Tennessee | 47009 | 1648 | 15 |
449658 | 449658 | 2020-08-19 | Blount | Tennessee | 47009 | 1584 | 15 |
446430 | 446430 | 2020-08-18 | Blount | Tennessee | 47009 | 1542 | 15 |
443204 | 443204 | 2020-08-17 | Blount | Tennessee | 47009 | 1507 | 15 |
439977 | 439977 | 2020-08-16 | Blount | Tennessee | 47009 | 1477 | 15 |
436752 | 436752 | 2020-08-15 | Blount | Tennessee | 47009 | 1465 | 15 |
433525 | 433525 | 2020-08-14 | Blount | Tennessee | 47009 | 1414 | 15 |
430300 | 430300 | 2020-08-13 | Blount | Tennessee | 47009 | 1373 | 15 |
427073 | 427073 | 2020-08-12 | Blount | Tennessee | 47009 | 1333 | 15 |
423850 | 423850 | 2020-08-11 | Blount | Tennessee | 47009 | 1324 | 12 |
420628 | 420628 | 2020-08-10 | Blount | Tennessee | 47009 | 1314 | 11 |
417407 | 417407 | 2020-08-09 | Blount | Tennessee | 47009 | 1303 | 11 |
414186 | 414186 | 2020-08-08 | Blount | Tennessee | 47009 | 1277 | 11 |
410966 | 410966 | 2020-08-07 | Blount | Tennessee | 47009 | 1243 | 10 |
407747 | 407747 | 2020-08-06 | Blount | Tennessee | 47009 | 1222 | 9 |
404527 | 404527 | 2020-08-05 | Blount | Tennessee | 47009 | 1186 | 8 |
401309 | 401309 | 2020-08-04 | Blount | Tennessee | 47009 | 1181 | 7 |
398094 | 398094 | 2020-08-03 | Blount | Tennessee | 47009 | 1120 | 7 |
394877 | 394877 | 2020-08-02 | Blount | Tennessee | 47009 | 1098 | 7 |
391661 | 391661 | 2020-08-01 | Blount | Tennessee | 47009 | 1089 | 7 |
388444 | 388444 | 2020-07-31 | Blount | Tennessee | 47009 | 1043 | 7 |
385227 | 385227 | 2020-07-30 | Blount | Tennessee | 47009 | 972 | 7 |
382009 | 382009 | 2020-07-29 | Blount | Tennessee | 47009 | 957 | 7 |
378792 | 378792 | 2020-07-28 | Blount | Tennessee | 47009 | 915 | 7 |
375576 | 375576 | 2020-07-27 | Blount | Tennessee | 47009 | 850 | 7 |
372363 | 372363 | 2020-07-26 | Blount | Tennessee | 47009 | 784 | 7 |
369151 | 369151 | 2020-07-25 | Blount | Tennessee | 47009 | 756 | 7 |
365942 | 365942 | 2020-07-24 | Blount | Tennessee | 47009 | 728 | 7 |
362736 | 362736 | 2020-07-23 | Blount | Tennessee | 47009 | 709 | 7 |
359529 | 359529 | 2020-07-22 | Blount | Tennessee | 47009 | 663 | 6 |
356325 | 356325 | 2020-07-21 | Blount | Tennessee | 47009 | 592 | 6 |
353122 | 353122 | 2020-07-20 | Blount | Tennessee | 47009 | 538 | 7 |
349919 | 349919 | 2020-07-19 | Blount | Tennessee | 47009 | 518 | 6 |
346719 | 346719 | 2020-07-18 | Blount | Tennessee | 47009 | 509 | 6 |
343519 | 343519 | 2020-07-17 | Blount | Tennessee | 47009 | 488 | 4 |
340321 | 340321 | 2020-07-16 | Blount | Tennessee | 47009 | 416 | 4 |
337124 | 337124 | 2020-07-15 | Blount | Tennessee | 47009 | 381 | 3 |
333930 | 333930 | 2020-07-14 | Blount | Tennessee | 47009 | 358 | 3 |
330738 | 330738 | 2020-07-13 | Blount | Tennessee | 47009 | 348 | 3 |
327552 | 327552 | 2020-07-12 | Blount | Tennessee | 47009 | 339 | 3 |
324367 | 324367 | 2020-07-11 | Blount | Tennessee | 47009 | 340 | 3 |
321186 | 321186 | 2020-07-10 | Blount | Tennessee | 47009 | 306 | 3 |
318008 | 318008 | 2020-07-09 | Blount | Tennessee | 47009 | 280 | 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);