ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Jefferson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637454 | 637454 | 2020-10-16 | Jefferson | Tennessee | 47089 | 1407 | 18 |
634208 | 634208 | 2020-10-15 | Jefferson | Tennessee | 47089 | 1393 | 18 |
630963 | 630963 | 2020-10-14 | Jefferson | Tennessee | 47089 | 1380 | 17 |
627719 | 627719 | 2020-10-13 | Jefferson | Tennessee | 47089 | 1368 | 17 |
624477 | 624477 | 2020-10-12 | Jefferson | Tennessee | 47089 | 1359 | 17 |
621234 | 621234 | 2020-10-11 | Jefferson | Tennessee | 47089 | 1338 | 17 |
617991 | 617991 | 2020-10-10 | Jefferson | Tennessee | 47089 | 1324 | 17 |
614749 | 614749 | 2020-10-09 | Jefferson | Tennessee | 47089 | 1296 | 16 |
611508 | 611508 | 2020-10-08 | Jefferson | Tennessee | 47089 | 1286 | 16 |
608266 | 608266 | 2020-10-07 | Jefferson | Tennessee | 47089 | 1267 | 16 |
605023 | 605023 | 2020-10-06 | Jefferson | Tennessee | 47089 | 1258 | 16 |
601781 | 601781 | 2020-10-05 | Jefferson | Tennessee | 47089 | 1243 | 16 |
598538 | 598538 | 2020-10-04 | Jefferson | Tennessee | 47089 | 1216 | 14 |
595295 | 595295 | 2020-10-03 | Jefferson | Tennessee | 47089 | 1211 | 14 |
592054 | 592054 | 2020-10-02 | Jefferson | Tennessee | 47089 | 1189 | 14 |
588813 | 588813 | 2020-10-01 | Jefferson | Tennessee | 47089 | 1171 | 14 |
585573 | 585573 | 2020-09-30 | Jefferson | Tennessee | 47089 | 1161 | 14 |
582333 | 582333 | 2020-09-29 | Jefferson | Tennessee | 47089 | 1144 | 14 |
579093 | 579093 | 2020-09-28 | Jefferson | Tennessee | 47089 | 1134 | 14 |
575852 | 575852 | 2020-09-27 | Jefferson | Tennessee | 47089 | 1130 | 14 |
572608 | 572608 | 2020-09-26 | Jefferson | Tennessee | 47089 | 1119 | 14 |
569366 | 569366 | 2020-09-25 | Jefferson | Tennessee | 47089 | 1110 | 14 |
566125 | 566125 | 2020-09-24 | Jefferson | Tennessee | 47089 | 1097 | 14 |
562884 | 562884 | 2020-09-23 | Jefferson | Tennessee | 47089 | 1085 | 14 |
559647 | 559647 | 2020-09-22 | Jefferson | Tennessee | 47089 | 1074 | 14 |
556410 | 556410 | 2020-09-21 | Jefferson | Tennessee | 47089 | 1066 | 14 |
553173 | 553173 | 2020-09-20 | Jefferson | Tennessee | 47089 | 1066 | 14 |
549934 | 549934 | 2020-09-19 | Jefferson | Tennessee | 47089 | 1051 | 14 |
546695 | 546695 | 2020-09-18 | Jefferson | Tennessee | 47089 | 1046 | 14 |
543458 | 543458 | 2020-09-17 | Jefferson | Tennessee | 47089 | 1022 | 13 |
540222 | 540222 | 2020-09-16 | Jefferson | Tennessee | 47089 | 1019 | 13 |
536985 | 536985 | 2020-09-15 | Jefferson | Tennessee | 47089 | 1015 | 13 |
533749 | 533749 | 2020-09-14 | Jefferson | Tennessee | 47089 | 1013 | 13 |
530514 | 530514 | 2020-09-13 | Jefferson | Tennessee | 47089 | 1004 | 13 |
527277 | 527277 | 2020-09-12 | Jefferson | Tennessee | 47089 | 1002 | 13 |
524041 | 524041 | 2020-09-11 | Jefferson | Tennessee | 47089 | 970 | 13 |
520805 | 520805 | 2020-09-10 | Jefferson | Tennessee | 47089 | 956 | 13 |
517569 | 517569 | 2020-09-09 | Jefferson | Tennessee | 47089 | 926 | 9 |
514334 | 514334 | 2020-09-08 | Jefferson | Tennessee | 47089 | 923 | 9 |
511101 | 511101 | 2020-09-07 | Jefferson | Tennessee | 47089 | 918 | 7 |
507868 | 507868 | 2020-09-06 | Jefferson | Tennessee | 47089 | 913 | 7 |
504636 | 504636 | 2020-09-05 | Jefferson | Tennessee | 47089 | 887 | 7 |
501402 | 501402 | 2020-09-04 | Jefferson | Tennessee | 47089 | 859 | 7 |
498168 | 498168 | 2020-09-03 | Jefferson | Tennessee | 47089 | 846 | 7 |
494935 | 494935 | 2020-09-02 | Jefferson | Tennessee | 47089 | 830 | 7 |
491701 | 491701 | 2020-09-01 | Jefferson | Tennessee | 47089 | 817 | 6 |
488468 | 488468 | 2020-08-31 | Jefferson | Tennessee | 47089 | 815 | 6 |
485235 | 485235 | 2020-08-30 | Jefferson | Tennessee | 47089 | 805 | 6 |
482000 | 482000 | 2020-08-29 | Jefferson | Tennessee | 47089 | 785 | 6 |
478766 | 478766 | 2020-08-28 | Jefferson | Tennessee | 47089 | 781 | 6 |
475533 | 475533 | 2020-08-27 | Jefferson | Tennessee | 47089 | 752 | 6 |
472300 | 472300 | 2020-08-26 | Jefferson | Tennessee | 47089 | 738 | 6 |
469068 | 469068 | 2020-08-25 | Jefferson | Tennessee | 47089 | 721 | 6 |
465839 | 465839 | 2020-08-24 | Jefferson | Tennessee | 47089 | 721 | 6 |
462610 | 462610 | 2020-08-23 | Jefferson | Tennessee | 47089 | 703 | 5 |
459382 | 459382 | 2020-08-22 | Jefferson | Tennessee | 47089 | 688 | 5 |
456154 | 456154 | 2020-08-21 | Jefferson | Tennessee | 47089 | 682 | 5 |
452926 | 452926 | 2020-08-20 | Jefferson | Tennessee | 47089 | 671 | 4 |
449698 | 449698 | 2020-08-19 | Jefferson | Tennessee | 47089 | 667 | 4 |
446470 | 446470 | 2020-08-18 | Jefferson | Tennessee | 47089 | 652 | 4 |
443244 | 443244 | 2020-08-17 | Jefferson | Tennessee | 47089 | 651 | 4 |
440017 | 440017 | 2020-08-16 | Jefferson | Tennessee | 47089 | 650 | 4 |
436792 | 436792 | 2020-08-15 | Jefferson | Tennessee | 47089 | 647 | 4 |
433565 | 433565 | 2020-08-14 | Jefferson | Tennessee | 47089 | 639 | 4 |
430340 | 430340 | 2020-08-13 | Jefferson | Tennessee | 47089 | 616 | 4 |
427113 | 427113 | 2020-08-12 | Jefferson | Tennessee | 47089 | 596 | 4 |
423890 | 423890 | 2020-08-11 | Jefferson | Tennessee | 47089 | 587 | 4 |
420668 | 420668 | 2020-08-10 | Jefferson | Tennessee | 47089 | 584 | 4 |
417447 | 417447 | 2020-08-09 | Jefferson | Tennessee | 47089 | 568 | 4 |
414226 | 414226 | 2020-08-08 | Jefferson | Tennessee | 47089 | 559 | 3 |
411006 | 411006 | 2020-08-07 | Jefferson | Tennessee | 47089 | 552 | 3 |
407787 | 407787 | 2020-08-06 | Jefferson | Tennessee | 47089 | 525 | 3 |
404567 | 404567 | 2020-08-05 | Jefferson | Tennessee | 47089 | 513 | 3 |
401349 | 401349 | 2020-08-04 | Jefferson | Tennessee | 47089 | 508 | 3 |
398134 | 398134 | 2020-08-03 | Jefferson | Tennessee | 47089 | 496 | 2 |
394917 | 394917 | 2020-08-02 | Jefferson | Tennessee | 47089 | 489 | 2 |
391701 | 391701 | 2020-08-01 | Jefferson | Tennessee | 47089 | 480 | 2 |
388484 | 388484 | 2020-07-31 | Jefferson | Tennessee | 47089 | 474 | 2 |
385267 | 385267 | 2020-07-30 | Jefferson | Tennessee | 47089 | 451 | 2 |
382049 | 382049 | 2020-07-29 | Jefferson | Tennessee | 47089 | 441 | 2 |
378832 | 378832 | 2020-07-28 | Jefferson | Tennessee | 47089 | 420 | 2 |
375616 | 375616 | 2020-07-27 | Jefferson | Tennessee | 47089 | 392 | 2 |
372403 | 372403 | 2020-07-26 | Jefferson | Tennessee | 47089 | 363 | 2 |
369191 | 369191 | 2020-07-25 | Jefferson | Tennessee | 47089 | 344 | 2 |
365982 | 365982 | 2020-07-24 | Jefferson | Tennessee | 47089 | 330 | 1 |
362776 | 362776 | 2020-07-23 | Jefferson | Tennessee | 47089 | 317 | 1 |
359569 | 359569 | 2020-07-22 | Jefferson | Tennessee | 47089 | 289 | 1 |
356365 | 356365 | 2020-07-21 | Jefferson | Tennessee | 47089 | 284 | 1 |
353162 | 353162 | 2020-07-20 | Jefferson | Tennessee | 47089 | 264 | 1 |
349959 | 349959 | 2020-07-19 | Jefferson | Tennessee | 47089 | 261 | 1 |
346759 | 346759 | 2020-07-18 | Jefferson | Tennessee | 47089 | 256 | 1 |
343559 | 343559 | 2020-07-17 | Jefferson | Tennessee | 47089 | 241 | 1 |
340361 | 340361 | 2020-07-16 | Jefferson | Tennessee | 47089 | 227 | 1 |
337164 | 337164 | 2020-07-15 | Jefferson | Tennessee | 47089 | 219 | 1 |
333970 | 333970 | 2020-07-14 | Jefferson | Tennessee | 47089 | 196 | 1 |
330778 | 330778 | 2020-07-13 | Jefferson | Tennessee | 47089 | 193 | 1 |
327592 | 327592 | 2020-07-12 | Jefferson | Tennessee | 47089 | 187 | 1 |
324407 | 324407 | 2020-07-11 | Jefferson | Tennessee | 47089 | 182 | 1 |
321226 | 321226 | 2020-07-10 | Jefferson | Tennessee | 47089 | 164 | 1 |
318048 | 318048 | 2020-07-09 | Jefferson | Tennessee | 47089 | 157 | 1 |
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);