ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Marion" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637465 | 637465 | 2020-10-16 | Marion | Tennessee | 47115 | 654 | 9 |
634219 | 634219 | 2020-10-15 | Marion | Tennessee | 47115 | 652 | 9 |
630974 | 630974 | 2020-10-14 | Marion | Tennessee | 47115 | 640 | 9 |
627730 | 627730 | 2020-10-13 | Marion | Tennessee | 47115 | 633 | 9 |
624488 | 624488 | 2020-10-12 | Marion | Tennessee | 47115 | 629 | 9 |
621245 | 621245 | 2020-10-11 | Marion | Tennessee | 47115 | 623 | 9 |
618002 | 618002 | 2020-10-10 | Marion | Tennessee | 47115 | 617 | 9 |
614760 | 614760 | 2020-10-09 | Marion | Tennessee | 47115 | 611 | 9 |
611519 | 611519 | 2020-10-08 | Marion | Tennessee | 47115 | 604 | 9 |
608277 | 608277 | 2020-10-07 | Marion | Tennessee | 47115 | 599 | 9 |
605034 | 605034 | 2020-10-06 | Marion | Tennessee | 47115 | 589 | 9 |
601792 | 601792 | 2020-10-05 | Marion | Tennessee | 47115 | 582 | 9 |
598549 | 598549 | 2020-10-04 | Marion | Tennessee | 47115 | 576 | 9 |
595306 | 595306 | 2020-10-03 | Marion | Tennessee | 47115 | 568 | 9 |
592065 | 592065 | 2020-10-02 | Marion | Tennessee | 47115 | 563 | 9 |
588824 | 588824 | 2020-10-01 | Marion | Tennessee | 47115 | 560 | 8 |
585584 | 585584 | 2020-09-30 | Marion | Tennessee | 47115 | 555 | 8 |
582344 | 582344 | 2020-09-29 | Marion | Tennessee | 47115 | 551 | 8 |
579104 | 579104 | 2020-09-28 | Marion | Tennessee | 47115 | 538 | 8 |
575863 | 575863 | 2020-09-27 | Marion | Tennessee | 47115 | 533 | 8 |
572619 | 572619 | 2020-09-26 | Marion | Tennessee | 47115 | 529 | 8 |
569377 | 569377 | 2020-09-25 | Marion | Tennessee | 47115 | 525 | 8 |
566136 | 566136 | 2020-09-24 | Marion | Tennessee | 47115 | 518 | 7 |
562895 | 562895 | 2020-09-23 | Marion | Tennessee | 47115 | 516 | 7 |
559658 | 559658 | 2020-09-22 | Marion | Tennessee | 47115 | 504 | 7 |
556421 | 556421 | 2020-09-21 | Marion | Tennessee | 47115 | 500 | 7 |
553184 | 553184 | 2020-09-20 | Marion | Tennessee | 47115 | 499 | 7 |
549945 | 549945 | 2020-09-19 | Marion | Tennessee | 47115 | 493 | 7 |
546706 | 546706 | 2020-09-18 | Marion | Tennessee | 47115 | 488 | 7 |
543469 | 543469 | 2020-09-17 | Marion | Tennessee | 47115 | 476 | 7 |
540233 | 540233 | 2020-09-16 | Marion | Tennessee | 47115 | 469 | 7 |
536996 | 536996 | 2020-09-15 | Marion | Tennessee | 47115 | 460 | 7 |
533760 | 533760 | 2020-09-14 | Marion | Tennessee | 47115 | 452 | 7 |
530525 | 530525 | 2020-09-13 | Marion | Tennessee | 47115 | 434 | 7 |
527288 | 527288 | 2020-09-12 | Marion | Tennessee | 47115 | 430 | 7 |
524052 | 524052 | 2020-09-11 | Marion | Tennessee | 47115 | 425 | 7 |
520816 | 520816 | 2020-09-10 | Marion | Tennessee | 47115 | 413 | 7 |
517580 | 517580 | 2020-09-09 | Marion | Tennessee | 47115 | 400 | 7 |
514345 | 514345 | 2020-09-08 | Marion | Tennessee | 47115 | 397 | 7 |
511112 | 511112 | 2020-09-07 | Marion | Tennessee | 47115 | 392 | 7 |
507879 | 507879 | 2020-09-06 | Marion | Tennessee | 47115 | 386 | 7 |
504647 | 504647 | 2020-09-05 | Marion | Tennessee | 47115 | 377 | 7 |
501413 | 501413 | 2020-09-04 | Marion | Tennessee | 47115 | 361 | 7 |
498179 | 498179 | 2020-09-03 | Marion | Tennessee | 47115 | 356 | 7 |
494946 | 494946 | 2020-09-02 | Marion | Tennessee | 47115 | 342 | 7 |
491712 | 491712 | 2020-09-01 | Marion | Tennessee | 47115 | 328 | 7 |
488479 | 488479 | 2020-08-31 | Marion | Tennessee | 47115 | 325 | 7 |
485246 | 485246 | 2020-08-30 | Marion | Tennessee | 47115 | 325 | 7 |
482011 | 482011 | 2020-08-29 | Marion | Tennessee | 47115 | 323 | 6 |
478777 | 478777 | 2020-08-28 | Marion | Tennessee | 47115 | 318 | 6 |
475544 | 475544 | 2020-08-27 | Marion | Tennessee | 47115 | 314 | 6 |
472311 | 472311 | 2020-08-26 | Marion | Tennessee | 47115 | 308 | 6 |
469079 | 469079 | 2020-08-25 | Marion | Tennessee | 47115 | 300 | 5 |
465850 | 465850 | 2020-08-24 | Marion | Tennessee | 47115 | 300 | 5 |
462621 | 462621 | 2020-08-23 | Marion | Tennessee | 47115 | 297 | 5 |
459393 | 459393 | 2020-08-22 | Marion | Tennessee | 47115 | 289 | 5 |
456165 | 456165 | 2020-08-21 | Marion | Tennessee | 47115 | 285 | 5 |
452937 | 452937 | 2020-08-20 | Marion | Tennessee | 47115 | 278 | 5 |
449709 | 449709 | 2020-08-19 | Marion | Tennessee | 47115 | 276 | 5 |
446481 | 446481 | 2020-08-18 | Marion | Tennessee | 47115 | 262 | 5 |
443255 | 443255 | 2020-08-17 | Marion | Tennessee | 47115 | 258 | 5 |
440028 | 440028 | 2020-08-16 | Marion | Tennessee | 47115 | 256 | 5 |
436803 | 436803 | 2020-08-15 | Marion | Tennessee | 47115 | 243 | 5 |
433576 | 433576 | 2020-08-14 | Marion | Tennessee | 47115 | 240 | 5 |
430351 | 430351 | 2020-08-13 | Marion | Tennessee | 47115 | 239 | 5 |
427124 | 427124 | 2020-08-12 | Marion | Tennessee | 47115 | 230 | 5 |
423901 | 423901 | 2020-08-11 | Marion | Tennessee | 47115 | 228 | 5 |
420679 | 420679 | 2020-08-10 | Marion | Tennessee | 47115 | 227 | 4 |
417458 | 417458 | 2020-08-09 | Marion | Tennessee | 47115 | 224 | 4 |
414237 | 414237 | 2020-08-08 | Marion | Tennessee | 47115 | 222 | 4 |
411017 | 411017 | 2020-08-07 | Marion | Tennessee | 47115 | 216 | 4 |
407798 | 407798 | 2020-08-06 | Marion | Tennessee | 47115 | 213 | 4 |
404578 | 404578 | 2020-08-05 | Marion | Tennessee | 47115 | 210 | 4 |
401360 | 401360 | 2020-08-04 | Marion | Tennessee | 47115 | 209 | 4 |
398145 | 398145 | 2020-08-03 | Marion | Tennessee | 47115 | 205 | 4 |
394928 | 394928 | 2020-08-02 | Marion | Tennessee | 47115 | 206 | 4 |
391712 | 391712 | 2020-08-01 | Marion | Tennessee | 47115 | 199 | 4 |
388495 | 388495 | 2020-07-31 | Marion | Tennessee | 47115 | 195 | 4 |
385278 | 385278 | 2020-07-30 | Marion | Tennessee | 47115 | 190 | 4 |
382060 | 382060 | 2020-07-29 | Marion | Tennessee | 47115 | 183 | 4 |
378843 | 378843 | 2020-07-28 | Marion | Tennessee | 47115 | 184 | 4 |
375627 | 375627 | 2020-07-27 | Marion | Tennessee | 47115 | 175 | 4 |
372414 | 372414 | 2020-07-26 | Marion | Tennessee | 47115 | 172 | 4 |
369202 | 369202 | 2020-07-25 | Marion | Tennessee | 47115 | 153 | 4 |
365993 | 365993 | 2020-07-24 | Marion | Tennessee | 47115 | 148 | 4 |
362787 | 362787 | 2020-07-23 | Marion | Tennessee | 47115 | 143 | 4 |
359580 | 359580 | 2020-07-22 | Marion | Tennessee | 47115 | 135 | 4 |
356376 | 356376 | 2020-07-21 | Marion | Tennessee | 47115 | 134 | 4 |
353173 | 353173 | 2020-07-20 | Marion | Tennessee | 47115 | 132 | 4 |
349970 | 349970 | 2020-07-19 | Marion | Tennessee | 47115 | 126 | 4 |
346770 | 346770 | 2020-07-18 | Marion | Tennessee | 47115 | 121 | 4 |
343570 | 343570 | 2020-07-17 | Marion | Tennessee | 47115 | 117 | 4 |
340372 | 340372 | 2020-07-16 | Marion | Tennessee | 47115 | 113 | 4 |
337175 | 337175 | 2020-07-15 | Marion | Tennessee | 47115 | 104 | 4 |
333981 | 333981 | 2020-07-14 | Marion | Tennessee | 47115 | 100 | 4 |
330789 | 330789 | 2020-07-13 | Marion | Tennessee | 47115 | 101 | 4 |
327603 | 327603 | 2020-07-12 | Marion | Tennessee | 47115 | 95 | 4 |
324418 | 324418 | 2020-07-11 | Marion | Tennessee | 47115 | 94 | 4 |
321237 | 321237 | 2020-07-10 | Marion | Tennessee | 47115 | 91 | 4 |
318059 | 318059 | 2020-07-09 | Marion | Tennessee | 47115 | 90 | 4 |
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);