ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where date = "2020-06-30" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
289525 | 289525 | 2020-06-30 | Anderson | Tennessee | 47001 | 102 | 2 |
289526 | 289526 | 2020-06-30 | Bedford | Tennessee | 47003 | 513 | 5 |
289527 | 289527 | 2020-06-30 | Benton | Tennessee | 47005 | 12 | 1 |
289528 | 289528 | 2020-06-30 | Bledsoe | Tennessee | 47007 | 617 | 1 |
289529 | 289529 | 2020-06-30 | Blount | Tennessee | 47009 | 173 | 3 |
289530 | 289530 | 2020-06-30 | Bradley | Tennessee | 47011 | 550 | 3 |
289531 | 289531 | 2020-06-30 | Campbell | Tennessee | 47013 | 36 | 1 |
289532 | 289532 | 2020-06-30 | Cannon | Tennessee | 47015 | 27 | 0 |
289533 | 289533 | 2020-06-30 | Carroll | Tennessee | 47017 | 39 | 1 |
289534 | 289534 | 2020-06-30 | Carter | Tennessee | 47019 | 54 | 1 |
289535 | 289535 | 2020-06-30 | Cheatham | Tennessee | 47021 | 202 | 1 |
289536 | 289536 | 2020-06-30 | Chester | Tennessee | 47023 | 23 | 0 |
289537 | 289537 | 2020-06-30 | Claiborne | Tennessee | 47025 | 25 | 0 |
289538 | 289538 | 2020-06-30 | Clay | Tennessee | 47027 | 16 | 0 |
289539 | 289539 | 2020-06-30 | Cocke | Tennessee | 47029 | 58 | 0 |
289540 | 289540 | 2020-06-30 | Coffee | Tennessee | 47031 | 108 | 0 |
289541 | 289541 | 2020-06-30 | Crockett | Tennessee | 47033 | 31 | 3 |
289542 | 289542 | 2020-06-30 | Cumberland | Tennessee | 47035 | 168 | 3 |
289543 | 289543 | 2020-06-30 | Davidson | Tennessee | 47037 | 9805 | 113 |
289544 | 289544 | 2020-06-30 | DeKalb | Tennessee | 47041 | 52 | 0 |
289545 | 289545 | 2020-06-30 | Decatur | Tennessee | 47039 | 21 | 0 |
289546 | 289546 | 2020-06-30 | Dickson | Tennessee | 47043 | 175 | 0 |
289547 | 289547 | 2020-06-30 | Dyer | Tennessee | 47045 | 214 | 1 |
289548 | 289548 | 2020-06-30 | Fayette | Tennessee | 47047 | 273 | 2 |
289549 | 289549 | 2020-06-30 | Fentress | Tennessee | 47049 | 17 | 0 |
289550 | 289550 | 2020-06-30 | Franklin | Tennessee | 47051 | 75 | 3 |
289551 | 289551 | 2020-06-30 | Gibson | Tennessee | 47053 | 100 | 1 |
289552 | 289552 | 2020-06-30 | Giles | Tennessee | 47055 | 50 | 1 |
289553 | 289553 | 2020-06-30 | Grainger | Tennessee | 47057 | 35 | 0 |
289554 | 289554 | 2020-06-30 | Greene | Tennessee | 47059 | 85 | 2 |
289555 | 289555 | 2020-06-30 | Grundy | Tennessee | 47061 | 58 | 1 |
289556 | 289556 | 2020-06-30 | Hamblen | Tennessee | 47063 | 220 | 4 |
289557 | 289557 | 2020-06-30 | Hamilton | Tennessee | 47065 | 2525 | 30 |
289558 | 289558 | 2020-06-30 | Hancock | Tennessee | 47067 | 3 | 0 |
289559 | 289559 | 2020-06-30 | Hardeman | Tennessee | 47069 | 299 | 1 |
289560 | 289560 | 2020-06-30 | Hardin | Tennessee | 47071 | 93 | 5 |
289561 | 289561 | 2020-06-30 | Hawkins | Tennessee | 47073 | 51 | 2 |
289562 | 289562 | 2020-06-30 | Haywood | Tennessee | 47075 | 71 | 2 |
289563 | 289563 | 2020-06-30 | Henderson | Tennessee | 47077 | 32 | 0 |
289564 | 289564 | 2020-06-30 | Henry | Tennessee | 47079 | 42 | 0 |
289565 | 289565 | 2020-06-30 | Hickman | Tennessee | 47081 | 70 | 0 |
289566 | 289566 | 2020-06-30 | Houston | Tennessee | 47083 | 12 | 0 |
289567 | 289567 | 2020-06-30 | Humphreys | Tennessee | 47085 | 22 | 1 |
289568 | 289568 | 2020-06-30 | Jackson | Tennessee | 47087 | 26 | 0 |
289569 | 289569 | 2020-06-30 | Jefferson | Tennessee | 47089 | 102 | 0 |
289570 | 289570 | 2020-06-30 | Johnson | Tennessee | 47091 | 36 | 0 |
289571 | 289571 | 2020-06-30 | Knox | Tennessee | 47093 | 967 | 5 |
289572 | 289572 | 2020-06-30 | Lake | Tennessee | 47095 | 690 | 0 |
289573 | 289573 | 2020-06-30 | Lauderdale | Tennessee | 47097 | 119 | 2 |
289574 | 289574 | 2020-06-30 | Lawrence | Tennessee | 47099 | 124 | 5 |
289575 | 289575 | 2020-06-30 | Lewis | Tennessee | 47101 | 6 | 0 |
289576 | 289576 | 2020-06-30 | Lincoln | Tennessee | 47103 | 56 | 0 |
289577 | 289577 | 2020-06-30 | Loudon | Tennessee | 47105 | 261 | 1 |
289578 | 289578 | 2020-06-30 | Macon | Tennessee | 47111 | 394 | 3 |
289579 | 289579 | 2020-06-30 | Madison | Tennessee | 47113 | 247 | 2 |
289580 | 289580 | 2020-06-30 | Marion | Tennessee | 47115 | 64 | 4 |
289581 | 289581 | 2020-06-30 | Marshall | Tennessee | 47117 | 71 | 1 |
289582 | 289582 | 2020-06-30 | Maury | Tennessee | 47119 | 287 | 3 |
289583 | 289583 | 2020-06-30 | McMinn | Tennessee | 47107 | 210 | 17 |
289584 | 289584 | 2020-06-30 | McNairy | Tennessee | 47109 | 58 | 0 |
289585 | 289585 | 2020-06-30 | Meigs | Tennessee | 47121 | 32 | 0 |
289586 | 289586 | 2020-06-30 | Monroe | Tennessee | 47123 | 132 | 4 |
289587 | 289587 | 2020-06-30 | Montgomery | Tennessee | 47125 | 479 | 7 |
289588 | 289588 | 2020-06-30 | Moore | Tennessee | 47127 | 7 | 0 |
289589 | 289589 | 2020-06-30 | Morgan | Tennessee | 47129 | 24 | 1 |
289590 | 289590 | 2020-06-30 | Obion | Tennessee | 47131 | 94 | 2 |
289591 | 289591 | 2020-06-30 | Overton | Tennessee | 47133 | 56 | 0 |
289592 | 289592 | 2020-06-30 | Perry | Tennessee | 47135 | 31 | 0 |
289593 | 289593 | 2020-06-30 | Pickett | Tennessee | 47137 | 6 | 0 |
289594 | 289594 | 2020-06-30 | Polk | Tennessee | 47139 | 41 | 0 |
289595 | 289595 | 2020-06-30 | Putnam | Tennessee | 47141 | 783 | 7 |
289596 | 289596 | 2020-06-30 | Rhea | Tennessee | 47143 | 269 | 0 |
289597 | 289597 | 2020-06-30 | Roane | Tennessee | 47145 | 44 | 0 |
289598 | 289598 | 2020-06-30 | Robertson | Tennessee | 47147 | 776 | 11 |
289599 | 289599 | 2020-06-30 | Rutherford | Tennessee | 47149 | 2528 | 34 |
289600 | 289600 | 2020-06-30 | Scott | Tennessee | 47151 | 14 | 0 |
289601 | 289601 | 2020-06-30 | Sequatchie | Tennessee | 47153 | 24 | 0 |
289602 | 289602 | 2020-06-30 | Sevier | Tennessee | 47155 | 608 | 3 |
289603 | 289603 | 2020-06-30 | Shelby | Tennessee | 47157 | 10028 | 192 |
289604 | 289604 | 2020-06-30 | Smith | Tennessee | 47159 | 90 | 1 |
289605 | 289605 | 2020-06-30 | Stewart | Tennessee | 47161 | 21 | 0 |
289606 | 289606 | 2020-06-30 | Sullivan | Tennessee | 47163 | 89 | 2 |
289607 | 289607 | 2020-06-30 | Sumner | Tennessee | 47165 | 1417 | 52 |
289608 | 289608 | 2020-06-30 | Tipton | Tennessee | 47167 | 607 | 4 |
289609 | 289609 | 2020-06-30 | Trousdale | Tennessee | 47169 | 1485 | 5 |
289610 | 289610 | 2020-06-30 | Unicoi | Tennessee | 47171 | 54 | 0 |
289611 | 289611 | 2020-06-30 | Union | Tennessee | 47173 | 12 | 0 |
289612 | 289612 | 2020-06-30 | Van Buren | Tennessee | 47175 | 7 | 0 |
289613 | 289613 | 2020-06-30 | Warren | Tennessee | 47177 | 62 | 0 |
289614 | 289614 | 2020-06-30 | Washington | Tennessee | 47179 | 131 | 0 |
289615 | 289615 | 2020-06-30 | Wayne | Tennessee | 47181 | 77 | 0 |
289616 | 289616 | 2020-06-30 | Weakley | Tennessee | 47183 | 60 | 1 |
289617 | 289617 | 2020-06-30 | White | Tennessee | 47185 | 63 | 3 |
289618 | 289618 | 2020-06-30 | Williamson | Tennessee | 47187 | 1013 | 14 |
289619 | 289619 | 2020-06-30 | Wilson | Tennessee | 47189 | 779 | 17 |
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);