ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Carroll" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637418 | 637418 | 2020-10-16 | Carroll | Tennessee | 47017 | 1071 | 24 |
634172 | 634172 | 2020-10-15 | Carroll | Tennessee | 47017 | 1072 | 24 |
630927 | 630927 | 2020-10-14 | Carroll | Tennessee | 47017 | 1063 | 24 |
627683 | 627683 | 2020-10-13 | Carroll | Tennessee | 47017 | 1058 | 24 |
624441 | 624441 | 2020-10-12 | Carroll | Tennessee | 47017 | 1055 | 24 |
621198 | 621198 | 2020-10-11 | Carroll | Tennessee | 47017 | 1043 | 24 |
617955 | 617955 | 2020-10-10 | Carroll | Tennessee | 47017 | 1030 | 24 |
614713 | 614713 | 2020-10-09 | Carroll | Tennessee | 47017 | 1024 | 24 |
611472 | 611472 | 2020-10-08 | Carroll | Tennessee | 47017 | 1019 | 23 |
608230 | 608230 | 2020-10-07 | Carroll | Tennessee | 47017 | 1004 | 23 |
604987 | 604987 | 2020-10-06 | Carroll | Tennessee | 47017 | 997 | 21 |
601745 | 601745 | 2020-10-05 | Carroll | Tennessee | 47017 | 992 | 21 |
598502 | 598502 | 2020-10-04 | Carroll | Tennessee | 47017 | 974 | 20 |
595259 | 595259 | 2020-10-03 | Carroll | Tennessee | 47017 | 962 | 20 |
592018 | 592018 | 2020-10-02 | Carroll | Tennessee | 47017 | 941 | 20 |
588777 | 588777 | 2020-10-01 | Carroll | Tennessee | 47017 | 934 | 20 |
585537 | 585537 | 2020-09-30 | Carroll | Tennessee | 47017 | 917 | 20 |
582297 | 582297 | 2020-09-29 | Carroll | Tennessee | 47017 | 913 | 20 |
579057 | 579057 | 2020-09-28 | Carroll | Tennessee | 47017 | 905 | 20 |
575816 | 575816 | 2020-09-27 | Carroll | Tennessee | 47017 | 899 | 20 |
572572 | 572572 | 2020-09-26 | Carroll | Tennessee | 47017 | 889 | 20 |
569330 | 569330 | 2020-09-25 | Carroll | Tennessee | 47017 | 874 | 20 |
566089 | 566089 | 2020-09-24 | Carroll | Tennessee | 47017 | 858 | 19 |
562848 | 562848 | 2020-09-23 | Carroll | Tennessee | 47017 | 849 | 18 |
559611 | 559611 | 2020-09-22 | Carroll | Tennessee | 47017 | 839 | 18 |
556374 | 556374 | 2020-09-21 | Carroll | Tennessee | 47017 | 832 | 17 |
553137 | 553137 | 2020-09-20 | Carroll | Tennessee | 47017 | 829 | 17 |
549898 | 549898 | 2020-09-19 | Carroll | Tennessee | 47017 | 816 | 17 |
546659 | 546659 | 2020-09-18 | Carroll | Tennessee | 47017 | 806 | 16 |
543422 | 543422 | 2020-09-17 | Carroll | Tennessee | 47017 | 787 | 16 |
540186 | 540186 | 2020-09-16 | Carroll | Tennessee | 47017 | 781 | 16 |
536949 | 536949 | 2020-09-15 | Carroll | Tennessee | 47017 | 766 | 16 |
533713 | 533713 | 2020-09-14 | Carroll | Tennessee | 47017 | 762 | 15 |
530478 | 530478 | 2020-09-13 | Carroll | Tennessee | 47017 | 739 | 15 |
527241 | 527241 | 2020-09-12 | Carroll | Tennessee | 47017 | 736 | 15 |
524005 | 524005 | 2020-09-11 | Carroll | Tennessee | 47017 | 727 | 13 |
520769 | 520769 | 2020-09-10 | Carroll | Tennessee | 47017 | 713 | 13 |
517533 | 517533 | 2020-09-09 | Carroll | Tennessee | 47017 | 703 | 10 |
514298 | 514298 | 2020-09-08 | Carroll | Tennessee | 47017 | 698 | 10 |
511065 | 511065 | 2020-09-07 | Carroll | Tennessee | 47017 | 694 | 10 |
507832 | 507832 | 2020-09-06 | Carroll | Tennessee | 47017 | 685 | 10 |
504600 | 504600 | 2020-09-05 | Carroll | Tennessee | 47017 | 677 | 10 |
501366 | 501366 | 2020-09-04 | Carroll | Tennessee | 47017 | 667 | 9 |
498132 | 498132 | 2020-09-03 | Carroll | Tennessee | 47017 | 654 | 9 |
494899 | 494899 | 2020-09-02 | Carroll | Tennessee | 47017 | 666 | 9 |
491665 | 491665 | 2020-09-01 | Carroll | Tennessee | 47017 | 643 | 8 |
488432 | 488432 | 2020-08-31 | Carroll | Tennessee | 47017 | 637 | 8 |
485199 | 485199 | 2020-08-30 | Carroll | Tennessee | 47017 | 624 | 8 |
481964 | 481964 | 2020-08-29 | Carroll | Tennessee | 47017 | 611 | 8 |
478730 | 478730 | 2020-08-28 | Carroll | Tennessee | 47017 | 596 | 8 |
475497 | 475497 | 2020-08-27 | Carroll | Tennessee | 47017 | 566 | 7 |
472264 | 472264 | 2020-08-26 | Carroll | Tennessee | 47017 | 530 | 7 |
469032 | 469032 | 2020-08-25 | Carroll | Tennessee | 47017 | 525 | 7 |
465803 | 465803 | 2020-08-24 | Carroll | Tennessee | 47017 | 516 | 6 |
462574 | 462574 | 2020-08-23 | Carroll | Tennessee | 47017 | 508 | 6 |
459346 | 459346 | 2020-08-22 | Carroll | Tennessee | 47017 | 482 | 6 |
456118 | 456118 | 2020-08-21 | Carroll | Tennessee | 47017 | 463 | 6 |
452890 | 452890 | 2020-08-20 | Carroll | Tennessee | 47017 | 449 | 6 |
449662 | 449662 | 2020-08-19 | Carroll | Tennessee | 47017 | 426 | 6 |
446434 | 446434 | 2020-08-18 | Carroll | Tennessee | 47017 | 411 | 6 |
443208 | 443208 | 2020-08-17 | Carroll | Tennessee | 47017 | 401 | 6 |
439981 | 439981 | 2020-08-16 | Carroll | Tennessee | 47017 | 394 | 6 |
436756 | 436756 | 2020-08-15 | Carroll | Tennessee | 47017 | 384 | 6 |
433529 | 433529 | 2020-08-14 | Carroll | Tennessee | 47017 | 379 | 6 |
430304 | 430304 | 2020-08-13 | Carroll | Tennessee | 47017 | 352 | 6 |
427077 | 427077 | 2020-08-12 | Carroll | Tennessee | 47017 | 341 | 5 |
423854 | 423854 | 2020-08-11 | Carroll | Tennessee | 47017 | 330 | 3 |
420632 | 420632 | 2020-08-10 | Carroll | Tennessee | 47017 | 325 | 3 |
417411 | 417411 | 2020-08-09 | Carroll | Tennessee | 47017 | 314 | 3 |
414190 | 414190 | 2020-08-08 | Carroll | Tennessee | 47017 | 296 | 3 |
410970 | 410970 | 2020-08-07 | Carroll | Tennessee | 47017 | 290 | 3 |
407751 | 407751 | 2020-08-06 | Carroll | Tennessee | 47017 | 272 | 3 |
404531 | 404531 | 2020-08-05 | Carroll | Tennessee | 47017 | 251 | 3 |
401313 | 401313 | 2020-08-04 | Carroll | Tennessee | 47017 | 244 | 3 |
398098 | 398098 | 2020-08-03 | Carroll | Tennessee | 47017 | 228 | 3 |
394881 | 394881 | 2020-08-02 | Carroll | Tennessee | 47017 | 226 | 3 |
391665 | 391665 | 2020-08-01 | Carroll | Tennessee | 47017 | 216 | 3 |
388448 | 388448 | 2020-07-31 | Carroll | Tennessee | 47017 | 191 | 3 |
385231 | 385231 | 2020-07-30 | Carroll | Tennessee | 47017 | 181 | 3 |
382013 | 382013 | 2020-07-29 | Carroll | Tennessee | 47017 | 154 | 2 |
378796 | 378796 | 2020-07-28 | Carroll | Tennessee | 47017 | 151 | 2 |
375580 | 375580 | 2020-07-27 | Carroll | Tennessee | 47017 | 139 | 2 |
372367 | 372367 | 2020-07-26 | Carroll | Tennessee | 47017 | 128 | 2 |
369155 | 369155 | 2020-07-25 | Carroll | Tennessee | 47017 | 121 | 2 |
365946 | 365946 | 2020-07-24 | Carroll | Tennessee | 47017 | 109 | 2 |
362740 | 362740 | 2020-07-23 | Carroll | Tennessee | 47017 | 107 | 2 |
359533 | 359533 | 2020-07-22 | Carroll | Tennessee | 47017 | 90 | 2 |
356329 | 356329 | 2020-07-21 | Carroll | Tennessee | 47017 | 85 | 2 |
353126 | 353126 | 2020-07-20 | Carroll | Tennessee | 47017 | 80 | 2 |
349923 | 349923 | 2020-07-19 | Carroll | Tennessee | 47017 | 77 | 2 |
346723 | 346723 | 2020-07-18 | Carroll | Tennessee | 47017 | 73 | 2 |
343523 | 343523 | 2020-07-17 | Carroll | Tennessee | 47017 | 71 | 1 |
340325 | 340325 | 2020-07-16 | Carroll | Tennessee | 47017 | 69 | 1 |
337128 | 337128 | 2020-07-15 | Carroll | Tennessee | 47017 | 63 | 1 |
333934 | 333934 | 2020-07-14 | Carroll | Tennessee | 47017 | 58 | 1 |
330742 | 330742 | 2020-07-13 | Carroll | Tennessee | 47017 | 57 | 1 |
327556 | 327556 | 2020-07-12 | Carroll | Tennessee | 47017 | 52 | 1 |
324371 | 324371 | 2020-07-11 | Carroll | Tennessee | 47017 | 52 | 1 |
321190 | 321190 | 2020-07-10 | Carroll | Tennessee | 47017 | 52 | 1 |
318012 | 318012 | 2020-07-09 | Carroll | Tennessee | 47017 | 51 | 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);