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-13 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
141541 | 141541 | 2020-05-13 | Anderson | Tennessee | 47001 | 35 | 1 |
141542 | 141542 | 2020-05-13 | Bedford | Tennessee | 47003 | 246 | 3 |
141543 | 141543 | 2020-05-13 | Benton | Tennessee | 47005 | 6 | 1 |
141544 | 141544 | 2020-05-13 | Bledsoe | Tennessee | 47007 | 603 | 1 |
141545 | 141545 | 2020-05-13 | Blount | Tennessee | 47009 | 74 | 3 |
141546 | 141546 | 2020-05-13 | Bradley | Tennessee | 47011 | 75 | 1 |
141547 | 141547 | 2020-05-13 | Campbell | Tennessee | 47013 | 17 | 1 |
141548 | 141548 | 2020-05-13 | Cannon | Tennessee | 47015 | 13 | 0 |
141549 | 141549 | 2020-05-13 | Carroll | Tennessee | 47017 | 22 | 1 |
141550 | 141550 | 2020-05-13 | Carter | Tennessee | 47019 | 18 | 1 |
141551 | 141551 | 2020-05-13 | Cheatham | Tennessee | 47021 | 78 | 0 |
141552 | 141552 | 2020-05-13 | Chester | Tennessee | 47023 | 12 | 0 |
141553 | 141553 | 2020-05-13 | Claiborne | Tennessee | 47025 | 7 | 0 |
141554 | 141554 | 2020-05-13 | Clay | Tennessee | 47027 | 6 | 0 |
141555 | 141555 | 2020-05-13 | Cocke | Tennessee | 47029 | 19 | 0 |
141556 | 141556 | 2020-05-13 | Coffee | Tennessee | 47031 | 56 | 0 |
141557 | 141557 | 2020-05-13 | Crockett | Tennessee | 47033 | 12 | 1 |
141558 | 141558 | 2020-05-13 | Cumberland | Tennessee | 47035 | 87 | 1 |
141559 | 141559 | 2020-05-13 | Davidson | Tennessee | 47037 | 3879 | 38 |
141560 | 141560 | 2020-05-13 | DeKalb | Tennessee | 47041 | 28 | 0 |
141561 | 141561 | 2020-05-13 | Decatur | Tennessee | 47039 | 4 | 0 |
141562 | 141562 | 2020-05-13 | Dickson | Tennessee | 47043 | 88 | 0 |
141563 | 141563 | 2020-05-13 | Dyer | Tennessee | 47045 | 44 | 0 |
141564 | 141564 | 2020-05-13 | Fayette | Tennessee | 47047 | 85 | 1 |
141565 | 141565 | 2020-05-13 | Fentress | Tennessee | 47049 | 6 | 0 |
141566 | 141566 | 2020-05-13 | Franklin | Tennessee | 47051 | 41 | 1 |
141567 | 141567 | 2020-05-13 | Gibson | Tennessee | 47053 | 57 | 1 |
141568 | 141568 | 2020-05-13 | Giles | Tennessee | 47055 | 9 | 0 |
141569 | 141569 | 2020-05-13 | Grainger | Tennessee | 47057 | 6 | 0 |
141570 | 141570 | 2020-05-13 | Greene | Tennessee | 47059 | 47 | 2 |
141571 | 141571 | 2020-05-13 | Grundy | Tennessee | 47061 | 30 | 1 |
141572 | 141572 | 2020-05-13 | Hamblen | Tennessee | 47063 | 25 | 2 |
141573 | 141573 | 2020-05-13 | Hamilton | Tennessee | 47065 | 286 | 13 |
141574 | 141574 | 2020-05-13 | Hardeman | Tennessee | 47069 | 177 | 0 |
141575 | 141575 | 2020-05-13 | Hardin | Tennessee | 47071 | 8 | 0 |
141576 | 141576 | 2020-05-13 | Hawkins | Tennessee | 47073 | 31 | 2 |
141577 | 141577 | 2020-05-13 | Haywood | Tennessee | 47075 | 28 | 1 |
141578 | 141578 | 2020-05-13 | Henderson | Tennessee | 47077 | 10 | 0 |
141579 | 141579 | 2020-05-13 | Henry | Tennessee | 47079 | 15 | 0 |
141580 | 141580 | 2020-05-13 | Hickman | Tennessee | 47081 | 52 | 0 |
141581 | 141581 | 2020-05-13 | Houston | Tennessee | 47083 | 6 | 0 |
141582 | 141582 | 2020-05-13 | Humphreys | Tennessee | 47085 | 12 | 1 |
141583 | 141583 | 2020-05-13 | Jackson | Tennessee | 47087 | 10 | 0 |
141584 | 141584 | 2020-05-13 | Jefferson | Tennessee | 47089 | 26 | 0 |
141585 | 141585 | 2020-05-13 | Johnson | Tennessee | 47091 | 15 | 0 |
141586 | 141586 | 2020-05-13 | Knox | Tennessee | 47093 | 295 | 5 |
141587 | 141587 | 2020-05-13 | Lake | Tennessee | 47095 | 300 | 0 |
141588 | 141588 | 2020-05-13 | Lauderdale | Tennessee | 47097 | 40 | 0 |
141589 | 141589 | 2020-05-13 | Lawrence | Tennessee | 47099 | 21 | 0 |
141590 | 141590 | 2020-05-13 | Lewis | Tennessee | 47101 | 2 | 0 |
141591 | 141591 | 2020-05-13 | Lincoln | Tennessee | 47103 | 16 | 0 |
141592 | 141592 | 2020-05-13 | Loudon | Tennessee | 47105 | 46 | 0 |
141593 | 141593 | 2020-05-13 | Macon | Tennessee | 47111 | 71 | 3 |
141594 | 141594 | 2020-05-13 | Madison | Tennessee | 47113 | 156 | 1 |
141595 | 141595 | 2020-05-13 | Marion | Tennessee | 47115 | 29 | 1 |
141596 | 141596 | 2020-05-13 | Marshall | Tennessee | 47117 | 24 | 1 |
141597 | 141597 | 2020-05-13 | Maury | Tennessee | 47119 | 58 | 0 |
141598 | 141598 | 2020-05-13 | McMinn | Tennessee | 47107 | 123 | 9 |
141599 | 141599 | 2020-05-13 | McNairy | Tennessee | 47109 | 12 | 0 |
141600 | 141600 | 2020-05-13 | Meigs | Tennessee | 47121 | 22 | 0 |
141601 | 141601 | 2020-05-13 | Monroe | Tennessee | 47123 | 33 | 1 |
141602 | 141602 | 2020-05-13 | Montgomery | Tennessee | 47125 | 191 | 2 |
141603 | 141603 | 2020-05-13 | Moore | Tennessee | 47127 | 3 | 0 |
141604 | 141604 | 2020-05-13 | Morgan | Tennessee | 47129 | 12 | 0 |
141605 | 141605 | 2020-05-13 | Obion | Tennessee | 47131 | 16 | 1 |
141606 | 141606 | 2020-05-13 | Overton | Tennessee | 47133 | 14 | 0 |
141607 | 141607 | 2020-05-13 | Perry | Tennessee | 47135 | 13 | 0 |
141608 | 141608 | 2020-05-13 | Pickett | Tennessee | 47137 | 1 | 0 |
141609 | 141609 | 2020-05-13 | Polk | Tennessee | 47139 | 12 | 0 |
141610 | 141610 | 2020-05-13 | Putnam | Tennessee | 47141 | 190 | 5 |
141611 | 141611 | 2020-05-13 | Rhea | Tennessee | 47143 | 6 | 0 |
141612 | 141612 | 2020-05-13 | Roane | Tennessee | 47145 | 8 | 0 |
141613 | 141613 | 2020-05-13 | Robertson | Tennessee | 47147 | 245 | 0 |
141614 | 141614 | 2020-05-13 | Rutherford | Tennessee | 47149 | 780 | 20 |
141615 | 141615 | 2020-05-13 | Scott | Tennessee | 47151 | 11 | 0 |
141616 | 141616 | 2020-05-13 | Sequatchie | Tennessee | 47153 | 7 | 0 |
141617 | 141617 | 2020-05-13 | Sevier | Tennessee | 47155 | 65 | 2 |
141618 | 141618 | 2020-05-13 | Shelby | Tennessee | 47157 | 3475 | 76 |
141619 | 141619 | 2020-05-13 | Smith | Tennessee | 47159 | 24 | 1 |
141620 | 141620 | 2020-05-13 | Stewart | Tennessee | 47161 | 7 | 0 |
141621 | 141621 | 2020-05-13 | Sullivan | Tennessee | 47163 | 54 | 2 |
141622 | 141622 | 2020-05-13 | Sumner | Tennessee | 47165 | 714 | 40 |
141623 | 141623 | 2020-05-13 | Tipton | Tennessee | 47167 | 400 | 2 |
141624 | 141624 | 2020-05-13 | Trousdale | Tennessee | 47169 | 1381 | 3 |
141625 | 141625 | 2020-05-13 | Unicoi | Tennessee | 47171 | 3 | 0 |
141626 | 141626 | 2020-05-13 | Union | Tennessee | 47173 | 4 | 0 |
141627 | 141627 | 2020-05-13 | Unknown | Tennessee | 81 | 0 | |
141628 | 141628 | 2020-05-13 | Van Buren | Tennessee | 47175 | 2 | 0 |
141629 | 141629 | 2020-05-13 | Warren | Tennessee | 47177 | 13 | 0 |
141630 | 141630 | 2020-05-13 | Washington | Tennessee | 47179 | 64 | 0 |
141631 | 141631 | 2020-05-13 | Wayne | Tennessee | 47181 | 3 | 0 |
141632 | 141632 | 2020-05-13 | Weakley | Tennessee | 47183 | 24 | 0 |
141633 | 141633 | 2020-05-13 | White | Tennessee | 47185 | 17 | 0 |
141634 | 141634 | 2020-05-13 | Williamson | Tennessee | 47187 | 453 | 10 |
141635 | 141635 | 2020-05-13 | Wilson | Tennessee | 47189 | 309 | 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);