ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Johnson" and fips = 47091 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637455 | 637455 | 2020-10-16 | Johnson | Tennessee | 47091 | 1060 | 6 |
634209 | 634209 | 2020-10-15 | Johnson | Tennessee | 47091 | 1060 | 6 |
630964 | 630964 | 2020-10-14 | Johnson | Tennessee | 47091 | 1050 | 6 |
627720 | 627720 | 2020-10-13 | Johnson | Tennessee | 47091 | 1049 | 5 |
624478 | 624478 | 2020-10-12 | Johnson | Tennessee | 47091 | 1047 | 5 |
621235 | 621235 | 2020-10-11 | Johnson | Tennessee | 47091 | 1038 | 4 |
617992 | 617992 | 2020-10-10 | Johnson | Tennessee | 47091 | 1030 | 4 |
614750 | 614750 | 2020-10-09 | Johnson | Tennessee | 47091 | 1019 | 4 |
611509 | 611509 | 2020-10-08 | Johnson | Tennessee | 47091 | 1009 | 4 |
608267 | 608267 | 2020-10-07 | Johnson | Tennessee | 47091 | 1009 | 3 |
605024 | 605024 | 2020-10-06 | Johnson | Tennessee | 47091 | 846 | 3 |
601782 | 601782 | 2020-10-05 | Johnson | Tennessee | 47091 | 783 | 3 |
598539 | 598539 | 2020-10-04 | Johnson | Tennessee | 47091 | 771 | 3 |
595296 | 595296 | 2020-10-03 | Johnson | Tennessee | 47091 | 765 | 3 |
592055 | 592055 | 2020-10-02 | Johnson | Tennessee | 47091 | 764 | 3 |
588814 | 588814 | 2020-10-01 | Johnson | Tennessee | 47091 | 757 | 3 |
585574 | 585574 | 2020-09-30 | Johnson | Tennessee | 47091 | 752 | 3 |
582334 | 582334 | 2020-09-29 | Johnson | Tennessee | 47091 | 732 | 3 |
579094 | 579094 | 2020-09-28 | Johnson | Tennessee | 47091 | 729 | 2 |
575853 | 575853 | 2020-09-27 | Johnson | Tennessee | 47091 | 726 | 2 |
572609 | 572609 | 2020-09-26 | Johnson | Tennessee | 47091 | 711 | 2 |
569367 | 569367 | 2020-09-25 | Johnson | Tennessee | 47091 | 696 | 2 |
566126 | 566126 | 2020-09-24 | Johnson | Tennessee | 47091 | 675 | 2 |
562885 | 562885 | 2020-09-23 | Johnson | Tennessee | 47091 | 662 | 2 |
559648 | 559648 | 2020-09-22 | Johnson | Tennessee | 47091 | 649 | 2 |
556411 | 556411 | 2020-09-21 | Johnson | Tennessee | 47091 | 648 | 2 |
553174 | 553174 | 2020-09-20 | Johnson | Tennessee | 47091 | 645 | 2 |
549935 | 549935 | 2020-09-19 | Johnson | Tennessee | 47091 | 635 | 2 |
546696 | 546696 | 2020-09-18 | Johnson | Tennessee | 47091 | 633 | 2 |
543459 | 543459 | 2020-09-17 | Johnson | Tennessee | 47091 | 620 | 2 |
540223 | 540223 | 2020-09-16 | Johnson | Tennessee | 47091 | 618 | 2 |
536986 | 536986 | 2020-09-15 | Johnson | Tennessee | 47091 | 610 | 2 |
533750 | 533750 | 2020-09-14 | Johnson | Tennessee | 47091 | 561 | 2 |
530515 | 530515 | 2020-09-13 | Johnson | Tennessee | 47091 | 539 | 2 |
527278 | 527278 | 2020-09-12 | Johnson | Tennessee | 47091 | 533 | 2 |
524042 | 524042 | 2020-09-11 | Johnson | Tennessee | 47091 | 534 | 2 |
520806 | 520806 | 2020-09-10 | Johnson | Tennessee | 47091 | 523 | 2 |
517570 | 517570 | 2020-09-09 | Johnson | Tennessee | 47091 | 514 | 1 |
514335 | 514335 | 2020-09-08 | Johnson | Tennessee | 47091 | 509 | 1 |
511102 | 511102 | 2020-09-07 | Johnson | Tennessee | 47091 | 511 | 1 |
507869 | 507869 | 2020-09-06 | Johnson | Tennessee | 47091 | 506 | 1 |
504637 | 504637 | 2020-09-05 | Johnson | Tennessee | 47091 | 435 | 1 |
501403 | 501403 | 2020-09-04 | Johnson | Tennessee | 47091 | 430 | 1 |
498169 | 498169 | 2020-09-03 | Johnson | Tennessee | 47091 | 428 | 1 |
494936 | 494936 | 2020-09-02 | Johnson | Tennessee | 47091 | 427 | 1 |
491702 | 491702 | 2020-09-01 | Johnson | Tennessee | 47091 | 416 | 1 |
488469 | 488469 | 2020-08-31 | Johnson | Tennessee | 47091 | 407 | 1 |
485236 | 485236 | 2020-08-30 | Johnson | Tennessee | 47091 | 407 | 1 |
482001 | 482001 | 2020-08-29 | Johnson | Tennessee | 47091 | 407 | 1 |
478767 | 478767 | 2020-08-28 | Johnson | Tennessee | 47091 | 405 | 1 |
475534 | 475534 | 2020-08-27 | Johnson | Tennessee | 47091 | 403 | 1 |
472301 | 472301 | 2020-08-26 | Johnson | Tennessee | 47091 | 396 | 1 |
469069 | 469069 | 2020-08-25 | Johnson | Tennessee | 47091 | 392 | 1 |
465840 | 465840 | 2020-08-24 | Johnson | Tennessee | 47091 | 387 | 1 |
462611 | 462611 | 2020-08-23 | Johnson | Tennessee | 47091 | 387 | 1 |
459383 | 459383 | 2020-08-22 | Johnson | Tennessee | 47091 | 384 | 1 |
456155 | 456155 | 2020-08-21 | Johnson | Tennessee | 47091 | 372 | 1 |
452927 | 452927 | 2020-08-20 | Johnson | Tennessee | 47091 | 366 | 1 |
449699 | 449699 | 2020-08-19 | Johnson | Tennessee | 47091 | 362 | 1 |
446471 | 446471 | 2020-08-18 | Johnson | Tennessee | 47091 | 353 | 1 |
443245 | 443245 | 2020-08-17 | Johnson | Tennessee | 47091 | 349 | 1 |
440018 | 440018 | 2020-08-16 | Johnson | Tennessee | 47091 | 349 | 0 |
436793 | 436793 | 2020-08-15 | Johnson | Tennessee | 47091 | 321 | 0 |
433566 | 433566 | 2020-08-14 | Johnson | Tennessee | 47091 | 319 | 0 |
430341 | 430341 | 2020-08-13 | Johnson | Tennessee | 47091 | 318 | 0 |
427114 | 427114 | 2020-08-12 | Johnson | Tennessee | 47091 | 307 | 0 |
423891 | 423891 | 2020-08-11 | Johnson | Tennessee | 47091 | 288 | 0 |
420669 | 420669 | 2020-08-10 | Johnson | Tennessee | 47091 | 285 | 0 |
417448 | 417448 | 2020-08-09 | Johnson | Tennessee | 47091 | 280 | 0 |
414227 | 414227 | 2020-08-08 | Johnson | Tennessee | 47091 | 265 | 0 |
411007 | 411007 | 2020-08-07 | Johnson | Tennessee | 47091 | 258 | 0 |
407788 | 407788 | 2020-08-06 | Johnson | Tennessee | 47091 | 225 | 0 |
404568 | 404568 | 2020-08-05 | Johnson | Tennessee | 47091 | 214 | 0 |
401350 | 401350 | 2020-08-04 | Johnson | Tennessee | 47091 | 177 | 0 |
398135 | 398135 | 2020-08-03 | Johnson | Tennessee | 47091 | 172 | 0 |
394918 | 394918 | 2020-08-02 | Johnson | Tennessee | 47091 | 160 | 0 |
391702 | 391702 | 2020-08-01 | Johnson | Tennessee | 47091 | 141 | 0 |
388485 | 388485 | 2020-07-31 | Johnson | Tennessee | 47091 | 116 | 0 |
385268 | 385268 | 2020-07-30 | Johnson | Tennessee | 47091 | 92 | 0 |
382050 | 382050 | 2020-07-29 | Johnson | Tennessee | 47091 | 81 | 0 |
378833 | 378833 | 2020-07-28 | Johnson | Tennessee | 47091 | 72 | 0 |
375617 | 375617 | 2020-07-27 | Johnson | Tennessee | 47091 | 70 | 0 |
372404 | 372404 | 2020-07-26 | Johnson | Tennessee | 47091 | 63 | 0 |
369192 | 369192 | 2020-07-25 | Johnson | Tennessee | 47091 | 59 | 0 |
365983 | 365983 | 2020-07-24 | Johnson | Tennessee | 47091 | 57 | 0 |
362777 | 362777 | 2020-07-23 | Johnson | Tennessee | 47091 | 54 | 0 |
359570 | 359570 | 2020-07-22 | Johnson | Tennessee | 47091 | 52 | 0 |
356366 | 356366 | 2020-07-21 | Johnson | Tennessee | 47091 | 52 | 0 |
353163 | 353163 | 2020-07-20 | Johnson | Tennessee | 47091 | 52 | 0 |
349960 | 349960 | 2020-07-19 | Johnson | Tennessee | 47091 | 52 | 0 |
346760 | 346760 | 2020-07-18 | Johnson | Tennessee | 47091 | 51 | 0 |
343560 | 343560 | 2020-07-17 | Johnson | Tennessee | 47091 | 51 | 0 |
340362 | 340362 | 2020-07-16 | Johnson | Tennessee | 47091 | 51 | 0 |
337165 | 337165 | 2020-07-15 | Johnson | Tennessee | 47091 | 48 | 0 |
333971 | 333971 | 2020-07-14 | Johnson | Tennessee | 47091 | 49 | 0 |
330779 | 330779 | 2020-07-13 | Johnson | Tennessee | 47091 | 49 | 0 |
327593 | 327593 | 2020-07-12 | Johnson | Tennessee | 47091 | 46 | 0 |
324408 | 324408 | 2020-07-11 | Johnson | Tennessee | 47091 | 46 | 0 |
321227 | 321227 | 2020-07-10 | Johnson | Tennessee | 47091 | 45 | 0 |
318049 | 318049 | 2020-07-09 | Johnson | Tennessee | 47091 | 44 | 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);