ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where "date" is on date 2020-05-15 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
147539 | 147539 | 2020-05-15 | Anderson | Tennessee | 47001 | 36 | 1 |
147540 | 147540 | 2020-05-15 | Bedford | Tennessee | 47003 | 248 | 4 |
147541 | 147541 | 2020-05-15 | Benton | Tennessee | 47005 | 6 | 1 |
147542 | 147542 | 2020-05-15 | Bledsoe | Tennessee | 47007 | 605 | 1 |
147543 | 147543 | 2020-05-15 | Blount | Tennessee | 47009 | 75 | 3 |
147544 | 147544 | 2020-05-15 | Bradley | Tennessee | 47011 | 81 | 1 |
147545 | 147545 | 2020-05-15 | Campbell | Tennessee | 47013 | 17 | 1 |
147546 | 147546 | 2020-05-15 | Cannon | Tennessee | 47015 | 13 | 0 |
147547 | 147547 | 2020-05-15 | Carroll | Tennessee | 47017 | 24 | 1 |
147548 | 147548 | 2020-05-15 | Carter | Tennessee | 47019 | 19 | 1 |
147549 | 147549 | 2020-05-15 | Cheatham | Tennessee | 47021 | 88 | 0 |
147550 | 147550 | 2020-05-15 | Chester | Tennessee | 47023 | 12 | 0 |
147551 | 147551 | 2020-05-15 | Claiborne | Tennessee | 47025 | 7 | 0 |
147552 | 147552 | 2020-05-15 | Clay | Tennessee | 47027 | 6 | 0 |
147553 | 147553 | 2020-05-15 | Cocke | Tennessee | 47029 | 20 | 0 |
147554 | 147554 | 2020-05-15 | Coffee | Tennessee | 47031 | 60 | 0 |
147555 | 147555 | 2020-05-15 | Crockett | Tennessee | 47033 | 13 | 1 |
147556 | 147556 | 2020-05-15 | Cumberland | Tennessee | 47035 | 88 | 1 |
147557 | 147557 | 2020-05-15 | Davidson | Tennessee | 47037 | 4008 | 43 |
147558 | 147558 | 2020-05-15 | DeKalb | Tennessee | 47041 | 28 | 0 |
147559 | 147559 | 2020-05-15 | Decatur | Tennessee | 47039 | 5 | 0 |
147560 | 147560 | 2020-05-15 | Dickson | Tennessee | 47043 | 90 | 0 |
147561 | 147561 | 2020-05-15 | Dyer | Tennessee | 47045 | 44 | 0 |
147562 | 147562 | 2020-05-15 | Fayette | Tennessee | 47047 | 88 | 2 |
147563 | 147563 | 2020-05-15 | Fentress | Tennessee | 47049 | 6 | 0 |
147564 | 147564 | 2020-05-15 | Franklin | Tennessee | 47051 | 43 | 1 |
147565 | 147565 | 2020-05-15 | Gibson | Tennessee | 47053 | 57 | 1 |
147566 | 147566 | 2020-05-15 | Giles | Tennessee | 47055 | 9 | 0 |
147567 | 147567 | 2020-05-15 | Grainger | Tennessee | 47057 | 6 | 0 |
147568 | 147568 | 2020-05-15 | Greene | Tennessee | 47059 | 46 | 2 |
147569 | 147569 | 2020-05-15 | Grundy | Tennessee | 47061 | 30 | 1 |
147570 | 147570 | 2020-05-15 | Hamblen | Tennessee | 47063 | 24 | 2 |
147571 | 147571 | 2020-05-15 | Hamilton | Tennessee | 47065 | 332 | 13 |
147572 | 147572 | 2020-05-15 | Hardeman | Tennessee | 47069 | 180 | 0 |
147573 | 147573 | 2020-05-15 | Hardin | Tennessee | 47071 | 9 | 0 |
147574 | 147574 | 2020-05-15 | Hawkins | Tennessee | 47073 | 32 | 2 |
147575 | 147575 | 2020-05-15 | Haywood | Tennessee | 47075 | 29 | 1 |
147576 | 147576 | 2020-05-15 | Henderson | Tennessee | 47077 | 11 | 0 |
147577 | 147577 | 2020-05-15 | Henry | Tennessee | 47079 | 17 | 0 |
147578 | 147578 | 2020-05-15 | Hickman | Tennessee | 47081 | 52 | 0 |
147579 | 147579 | 2020-05-15 | Houston | Tennessee | 47083 | 6 | 0 |
147580 | 147580 | 2020-05-15 | Humphreys | Tennessee | 47085 | 12 | 1 |
147581 | 147581 | 2020-05-15 | Jackson | Tennessee | 47087 | 10 | 0 |
147582 | 147582 | 2020-05-15 | Jefferson | Tennessee | 47089 | 26 | 0 |
147583 | 147583 | 2020-05-15 | Johnson | Tennessee | 47091 | 15 | 0 |
147584 | 147584 | 2020-05-15 | Knox | Tennessee | 47093 | 302 | 5 |
147585 | 147585 | 2020-05-15 | Lake | Tennessee | 47095 | 401 | 0 |
147586 | 147586 | 2020-05-15 | Lauderdale | Tennessee | 47097 | 43 | 0 |
147587 | 147587 | 2020-05-15 | Lawrence | Tennessee | 47099 | 21 | 0 |
147588 | 147588 | 2020-05-15 | Lewis | Tennessee | 47101 | 2 | 0 |
147589 | 147589 | 2020-05-15 | Lincoln | Tennessee | 47103 | 16 | 0 |
147590 | 147590 | 2020-05-15 | Loudon | Tennessee | 47105 | 48 | 0 |
147591 | 147591 | 2020-05-15 | Macon | Tennessee | 47111 | 75 | 3 |
147592 | 147592 | 2020-05-15 | Madison | Tennessee | 47113 | 160 | 2 |
147593 | 147593 | 2020-05-15 | Marion | Tennessee | 47115 | 30 | 1 |
147594 | 147594 | 2020-05-15 | Marshall | Tennessee | 47117 | 25 | 1 |
147595 | 147595 | 2020-05-15 | Maury | Tennessee | 47119 | 60 | 0 |
147596 | 147596 | 2020-05-15 | McMinn | Tennessee | 47107 | 123 | 11 |
147597 | 147597 | 2020-05-15 | McNairy | Tennessee | 47109 | 12 | 0 |
147598 | 147598 | 2020-05-15 | Meigs | Tennessee | 47121 | 22 | 0 |
147599 | 147599 | 2020-05-15 | Monroe | Tennessee | 47123 | 38 | 1 |
147600 | 147600 | 2020-05-15 | Montgomery | Tennessee | 47125 | 203 | 2 |
147601 | 147601 | 2020-05-15 | Moore | Tennessee | 47127 | 3 | 0 |
147602 | 147602 | 2020-05-15 | Morgan | Tennessee | 47129 | 12 | 0 |
147603 | 147603 | 2020-05-15 | Obion | Tennessee | 47131 | 17 | 1 |
147604 | 147604 | 2020-05-15 | Overton | Tennessee | 47133 | 14 | 0 |
147605 | 147605 | 2020-05-15 | Perry | Tennessee | 47135 | 13 | 0 |
147606 | 147606 | 2020-05-15 | Pickett | Tennessee | 47137 | 1 | 0 |
147607 | 147607 | 2020-05-15 | Polk | Tennessee | 47139 | 12 | 0 |
147608 | 147608 | 2020-05-15 | Putnam | Tennessee | 47141 | 206 | 5 |
147609 | 147609 | 2020-05-15 | Rhea | Tennessee | 47143 | 7 | 0 |
147610 | 147610 | 2020-05-15 | Roane | Tennessee | 47145 | 8 | 0 |
147611 | 147611 | 2020-05-15 | Robertson | Tennessee | 47147 | 263 | 0 |
147612 | 147612 | 2020-05-15 | Rutherford | Tennessee | 47149 | 814 | 19 |
147613 | 147613 | 2020-05-15 | Scott | Tennessee | 47151 | 11 | 0 |
147614 | 147614 | 2020-05-15 | Sequatchie | Tennessee | 47153 | 10 | 0 |
147615 | 147615 | 2020-05-15 | Sevier | Tennessee | 47155 | 66 | 2 |
147616 | 147616 | 2020-05-15 | Shelby | Tennessee | 47157 | 3595 | 82 |
147617 | 147617 | 2020-05-15 | Smith | Tennessee | 47159 | 24 | 1 |
147618 | 147618 | 2020-05-15 | Stewart | Tennessee | 47161 | 7 | 0 |
147619 | 147619 | 2020-05-15 | Sullivan | Tennessee | 47163 | 57 | 2 |
147620 | 147620 | 2020-05-15 | Sumner | Tennessee | 47165 | 724 | 41 |
147621 | 147621 | 2020-05-15 | Tipton | Tennessee | 47167 | 402 | 2 |
147622 | 147622 | 2020-05-15 | Trousdale | Tennessee | 47169 | 1382 | 4 |
147623 | 147623 | 2020-05-15 | Unicoi | Tennessee | 47171 | 3 | 0 |
147624 | 147624 | 2020-05-15 | Union | Tennessee | 47173 | 4 | 0 |
147625 | 147625 | 2020-05-15 | Unknown | Tennessee | 85 | 0 | |
147626 | 147626 | 2020-05-15 | Van Buren | Tennessee | 47175 | 3 | 0 |
147627 | 147627 | 2020-05-15 | Warren | Tennessee | 47177 | 14 | 0 |
147628 | 147628 | 2020-05-15 | Washington | Tennessee | 47179 | 66 | 0 |
147629 | 147629 | 2020-05-15 | Wayne | Tennessee | 47181 | 61 | 0 |
147630 | 147630 | 2020-05-15 | Weakley | Tennessee | 47183 | 24 | 0 |
147631 | 147631 | 2020-05-15 | White | Tennessee | 47185 | 17 | 0 |
147632 | 147632 | 2020-05-15 | Williamson | Tennessee | 47187 | 462 | 10 |
147633 | 147633 | 2020-05-15 | Wilson | Tennessee | 47189 | 316 | 8 |
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);