ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Warren" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637498 | 637498 | 2020-10-16 | Warren | Tennessee | 47177 | 1283 | 9 |
634253 | 634253 | 2020-10-15 | Warren | Tennessee | 47177 | 1282 | 9 |
631008 | 631008 | 2020-10-14 | Warren | Tennessee | 47177 | 1252 | 9 |
627764 | 627764 | 2020-10-13 | Warren | Tennessee | 47177 | 1230 | 9 |
624522 | 624522 | 2020-10-12 | Warren | Tennessee | 47177 | 1230 | 9 |
621279 | 621279 | 2020-10-11 | Warren | Tennessee | 47177 | 1199 | 9 |
618036 | 618036 | 2020-10-10 | Warren | Tennessee | 47177 | 1185 | 9 |
614794 | 614794 | 2020-10-09 | Warren | Tennessee | 47177 | 1184 | 9 |
611553 | 611553 | 2020-10-08 | Warren | Tennessee | 47177 | 1180 | 9 |
608311 | 608311 | 2020-10-07 | Warren | Tennessee | 47177 | 1162 | 9 |
605068 | 605068 | 2020-10-06 | Warren | Tennessee | 47177 | 1140 | 8 |
601826 | 601826 | 2020-10-05 | Warren | Tennessee | 47177 | 1135 | 8 |
598583 | 598583 | 2020-10-04 | Warren | Tennessee | 47177 | 1120 | 8 |
595340 | 595340 | 2020-10-03 | Warren | Tennessee | 47177 | 1113 | 8 |
592098 | 592098 | 2020-10-02 | Warren | Tennessee | 47177 | 1093 | 7 |
588858 | 588858 | 2020-10-01 | Warren | Tennessee | 47177 | 1091 | 7 |
585617 | 585617 | 2020-09-30 | Warren | Tennessee | 47177 | 1085 | 7 |
582377 | 582377 | 2020-09-29 | Warren | Tennessee | 47177 | 1077 | 7 |
579138 | 579138 | 2020-09-28 | Warren | Tennessee | 47177 | 1078 | 7 |
575897 | 575897 | 2020-09-27 | Warren | Tennessee | 47177 | 1075 | 7 |
572653 | 572653 | 2020-09-26 | Warren | Tennessee | 47177 | 1061 | 7 |
569411 | 569411 | 2020-09-25 | Warren | Tennessee | 47177 | 1047 | 7 |
566170 | 566170 | 2020-09-24 | Warren | Tennessee | 47177 | 1026 | 7 |
562929 | 562929 | 2020-09-23 | Warren | Tennessee | 47177 | 1019 | 7 |
559691 | 559691 | 2020-09-22 | Warren | Tennessee | 47177 | 1012 | 7 |
556455 | 556455 | 2020-09-21 | Warren | Tennessee | 47177 | 1012 | 7 |
553218 | 553218 | 2020-09-20 | Warren | Tennessee | 47177 | 1007 | 7 |
549979 | 549979 | 2020-09-19 | Warren | Tennessee | 47177 | 997 | 7 |
546740 | 546740 | 2020-09-18 | Warren | Tennessee | 47177 | 996 | 7 |
543503 | 543503 | 2020-09-17 | Warren | Tennessee | 47177 | 990 | 7 |
540267 | 540267 | 2020-09-16 | Warren | Tennessee | 47177 | 984 | 8 |
537030 | 537030 | 2020-09-15 | Warren | Tennessee | 47177 | 970 | 8 |
533794 | 533794 | 2020-09-14 | Warren | Tennessee | 47177 | 965 | 8 |
530559 | 530559 | 2020-09-13 | Warren | Tennessee | 47177 | 953 | 8 |
527322 | 527322 | 2020-09-12 | Warren | Tennessee | 47177 | 947 | 8 |
524086 | 524086 | 2020-09-11 | Warren | Tennessee | 47177 | 942 | 7 |
520850 | 520850 | 2020-09-10 | Warren | Tennessee | 47177 | 930 | 7 |
517614 | 517614 | 2020-09-09 | Warren | Tennessee | 47177 | 914 | 7 |
514379 | 514379 | 2020-09-08 | Warren | Tennessee | 47177 | 914 | 7 |
511146 | 511146 | 2020-09-07 | Warren | Tennessee | 47177 | 913 | 7 |
507913 | 507913 | 2020-09-06 | Warren | Tennessee | 47177 | 907 | 7 |
504681 | 504681 | 2020-09-05 | Warren | Tennessee | 47177 | 894 | 7 |
501447 | 501447 | 2020-09-04 | Warren | Tennessee | 47177 | 894 | 7 |
498213 | 498213 | 2020-09-03 | Warren | Tennessee | 47177 | 873 | 7 |
494980 | 494980 | 2020-09-02 | Warren | Tennessee | 47177 | 879 | 7 |
491746 | 491746 | 2020-09-01 | Warren | Tennessee | 47177 | 860 | 7 |
488513 | 488513 | 2020-08-31 | Warren | Tennessee | 47177 | 853 | 7 |
485280 | 485280 | 2020-08-30 | Warren | Tennessee | 47177 | 851 | 7 |
482045 | 482045 | 2020-08-29 | Warren | Tennessee | 47177 | 830 | 7 |
478811 | 478811 | 2020-08-28 | Warren | Tennessee | 47177 | 824 | 7 |
475578 | 475578 | 2020-08-27 | Warren | Tennessee | 47177 | 798 | 7 |
472345 | 472345 | 2020-08-26 | Warren | Tennessee | 47177 | 780 | 7 |
469113 | 469113 | 2020-08-25 | Warren | Tennessee | 47177 | 745 | 7 |
465884 | 465884 | 2020-08-24 | Warren | Tennessee | 47177 | 741 | 7 |
462655 | 462655 | 2020-08-23 | Warren | Tennessee | 47177 | 735 | 7 |
459426 | 459426 | 2020-08-22 | Warren | Tennessee | 47177 | 704 | 7 |
456199 | 456199 | 2020-08-21 | Warren | Tennessee | 47177 | 696 | 6 |
452971 | 452971 | 2020-08-20 | Warren | Tennessee | 47177 | 669 | 6 |
449743 | 449743 | 2020-08-19 | Warren | Tennessee | 47177 | 641 | 6 |
446515 | 446515 | 2020-08-18 | Warren | Tennessee | 47177 | 629 | 6 |
443288 | 443288 | 2020-08-17 | Warren | Tennessee | 47177 | 626 | 6 |
440062 | 440062 | 2020-08-16 | Warren | Tennessee | 47177 | 592 | 6 |
436836 | 436836 | 2020-08-15 | Warren | Tennessee | 47177 | 590 | 5 |
433610 | 433610 | 2020-08-14 | Warren | Tennessee | 47177 | 587 | 4 |
430385 | 430385 | 2020-08-13 | Warren | Tennessee | 47177 | 567 | 4 |
427158 | 427158 | 2020-08-12 | Warren | Tennessee | 47177 | 545 | 4 |
423934 | 423934 | 2020-08-11 | Warren | Tennessee | 47177 | 540 | 4 |
420713 | 420713 | 2020-08-10 | Warren | Tennessee | 47177 | 533 | 4 |
417492 | 417492 | 2020-08-09 | Warren | Tennessee | 47177 | 530 | 4 |
414271 | 414271 | 2020-08-08 | Warren | Tennessee | 47177 | 507 | 4 |
411051 | 411051 | 2020-08-07 | Warren | Tennessee | 47177 | 498 | 4 |
407832 | 407832 | 2020-08-06 | Warren | Tennessee | 47177 | 479 | 4 |
404612 | 404612 | 2020-08-05 | Warren | Tennessee | 47177 | 454 | 4 |
401394 | 401394 | 2020-08-04 | Warren | Tennessee | 47177 | 429 | 4 |
398178 | 398178 | 2020-08-03 | Warren | Tennessee | 47177 | 403 | 4 |
394962 | 394962 | 2020-08-02 | Warren | Tennessee | 47177 | 400 | 4 |
391746 | 391746 | 2020-08-01 | Warren | Tennessee | 47177 | 393 | 4 |
388529 | 388529 | 2020-07-31 | Warren | Tennessee | 47177 | 375 | 4 |
385312 | 385312 | 2020-07-30 | Warren | Tennessee | 47177 | 349 | 3 |
382094 | 382094 | 2020-07-29 | Warren | Tennessee | 47177 | 339 | 3 |
378877 | 378877 | 2020-07-28 | Warren | Tennessee | 47177 | 332 | 3 |
375661 | 375661 | 2020-07-27 | Warren | Tennessee | 47177 | 317 | 3 |
372448 | 372448 | 2020-07-26 | Warren | Tennessee | 47177 | 293 | 3 |
369236 | 369236 | 2020-07-25 | Warren | Tennessee | 47177 | 282 | 3 |
366027 | 366027 | 2020-07-24 | Warren | Tennessee | 47177 | 267 | 3 |
362821 | 362821 | 2020-07-23 | Warren | Tennessee | 47177 | 262 | 3 |
359614 | 359614 | 2020-07-22 | Warren | Tennessee | 47177 | 248 | 3 |
356409 | 356409 | 2020-07-21 | Warren | Tennessee | 47177 | 248 | 3 |
353206 | 353206 | 2020-07-20 | Warren | Tennessee | 47177 | 222 | 3 |
350004 | 350004 | 2020-07-19 | Warren | Tennessee | 47177 | 215 | 3 |
346804 | 346804 | 2020-07-18 | Warren | Tennessee | 47177 | 215 | 3 |
343604 | 343604 | 2020-07-17 | Warren | Tennessee | 47177 | 208 | 2 |
340405 | 340405 | 2020-07-16 | Warren | Tennessee | 47177 | 189 | 1 |
337209 | 337209 | 2020-07-15 | Warren | Tennessee | 47177 | 183 | 1 |
334014 | 334014 | 2020-07-14 | Warren | Tennessee | 47177 | 164 | 0 |
330823 | 330823 | 2020-07-13 | Warren | Tennessee | 47177 | 159 | 0 |
327637 | 327637 | 2020-07-12 | Warren | Tennessee | 47177 | 127 | 0 |
324452 | 324452 | 2020-07-11 | Warren | Tennessee | 47177 | 123 | 0 |
321271 | 321271 | 2020-07-10 | Warren | Tennessee | 47177 | 120 | 0 |
318093 | 318093 | 2020-07-09 | Warren | Tennessee | 47177 | 106 | 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);