ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2020-11-10" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
718510 | 718510 | 2020-11-10 | Anderson | Tennessee | 47001 | 2185 | 18 |
718511 | 718511 | 2020-11-10 | Bedford | Tennessee | 47003 | 2071 | 24 |
718512 | 718512 | 2020-11-10 | Benton | Tennessee | 47005 | 550 | 12 |
718513 | 718513 | 2020-11-10 | Bledsoe | Tennessee | 47007 | 1083 | 4 |
718514 | 718514 | 2020-11-10 | Blount | Tennessee | 47009 | 4005 | 45 |
718515 | 718515 | 2020-11-10 | Bradley | Tennessee | 47011 | 4073 | 27 |
718516 | 718516 | 2020-11-10 | Campbell | Tennessee | 47013 | 1258 | 17 |
718517 | 718517 | 2020-11-10 | Cannon | Tennessee | 47015 | 535 | 2 |
718518 | 718518 | 2020-11-10 | Carroll | Tennessee | 47017 | 1320 | 30 |
718519 | 718519 | 2020-11-10 | Carter | Tennessee | 47019 | 2039 | 41 |
718520 | 718520 | 2020-11-10 | Cheatham | Tennessee | 47021 | 1258 | 12 |
718521 | 718521 | 2020-11-10 | Chester | Tennessee | 47023 | 818 | 18 |
718522 | 718522 | 2020-11-10 | Claiborne | Tennessee | 47025 | 596 | 8 |
718523 | 718523 | 2020-11-10 | Clay | Tennessee | 47027 | 454 | 17 |
718524 | 718524 | 2020-11-10 | Cocke | Tennessee | 47029 | 1321 | 22 |
718525 | 718525 | 2020-11-10 | Coffee | Tennessee | 47031 | 2253 | 32 |
718526 | 718526 | 2020-11-10 | Crockett | Tennessee | 47033 | 1025 | 24 |
718527 | 718527 | 2020-11-10 | Cumberland | Tennessee | 47035 | 1957 | 29 |
718528 | 718528 | 2020-11-10 | Davidson | Tennessee | 47037 | 38010 | 369 |
718529 | 718529 | 2020-11-10 | DeKalb | Tennessee | 47041 | 869 | 19 |
718530 | 718530 | 2020-11-10 | Decatur | Tennessee | 47039 | 750 | 11 |
718531 | 718531 | 2020-11-10 | Dickson | Tennessee | 47043 | 2135 | 23 |
718532 | 718532 | 2020-11-10 | Dyer | Tennessee | 47045 | 2672 | 42 |
718533 | 718533 | 2020-11-10 | Fayette | Tennessee | 47047 | 1911 | 31 |
718534 | 718534 | 2020-11-10 | Fentress | Tennessee | 47049 | 1026 | 14 |
718535 | 718535 | 2020-11-10 | Franklin | Tennessee | 47051 | 1520 | 27 |
718536 | 718536 | 2020-11-10 | Gibson | Tennessee | 47053 | 2474 | 53 |
718537 | 718537 | 2020-11-10 | Giles | Tennessee | 47055 | 1152 | 39 |
718538 | 718538 | 2020-11-10 | Grainger | Tennessee | 47057 | 757 | 5 |
718539 | 718539 | 2020-11-10 | Greene | Tennessee | 47059 | 2291 | 63 |
718540 | 718540 | 2020-11-10 | Grundy | Tennessee | 47061 | 648 | 15 |
718541 | 718541 | 2020-11-10 | Hamblen | Tennessee | 47063 | 2788 | 54 |
718542 | 718542 | 2020-11-10 | Hamilton | Tennessee | 47065 | 14004 | 118 |
718543 | 718543 | 2020-11-10 | Hancock | Tennessee | 47067 | 127 | 3 |
718544 | 718544 | 2020-11-10 | Hardeman | Tennessee | 47069 | 2063 | 35 |
718545 | 718545 | 2020-11-10 | Hardin | Tennessee | 47071 | 1529 | 23 |
718546 | 718546 | 2020-11-10 | Hawkins | Tennessee | 47073 | 1475 | 30 |
718547 | 718547 | 2020-11-10 | Haywood | Tennessee | 47075 | 1425 | 28 |
718548 | 718548 | 2020-11-10 | Henderson | Tennessee | 47077 | 1552 | 29 |
718549 | 718549 | 2020-11-10 | Henry | Tennessee | 47079 | 1042 | 13 |
718550 | 718550 | 2020-11-10 | Hickman | Tennessee | 47081 | 934 | 16 |
718551 | 718551 | 2020-11-10 | Houston | Tennessee | 47083 | 513 | 18 |
718552 | 718552 | 2020-11-10 | Humphreys | Tennessee | 47085 | 546 | 6 |
718553 | 718553 | 2020-11-10 | Jackson | Tennessee | 47087 | 542 | 7 |
718554 | 718554 | 2020-11-10 | Jefferson | Tennessee | 47089 | 1776 | 25 |
718555 | 718555 | 2020-11-10 | Johnson | Tennessee | 47091 | 1293 | 15 |
718556 | 718556 | 2020-11-10 | Knox | Tennessee | 47093 | 15300 | 121 |
718557 | 718557 | 2020-11-10 | Lake | Tennessee | 47095 | 1055 | 4 |
718558 | 718558 | 2020-11-10 | Lauderdale | Tennessee | 47097 | 1628 | 20 |
718559 | 718559 | 2020-11-10 | Lawrence | Tennessee | 47099 | 2065 | 24 |
718560 | 718560 | 2020-11-10 | Lewis | Tennessee | 47101 | 600 | 7 |
718561 | 718561 | 2020-11-10 | Lincoln | Tennessee | 47103 | 1142 | 8 |
718562 | 718562 | 2020-11-10 | Loudon | Tennessee | 47105 | 1863 | 13 |
718563 | 718563 | 2020-11-10 | Macon | Tennessee | 47111 | 1518 | 26 |
718564 | 718564 | 2020-11-10 | Madison | Tennessee | 47113 | 4352 | 86 |
718565 | 718565 | 2020-11-10 | Marion | Tennessee | 47115 | 928 | 14 |
718566 | 718566 | 2020-11-10 | Marshall | Tennessee | 47117 | 1381 | 14 |
718567 | 718567 | 2020-11-10 | Maury | Tennessee | 47119 | 4464 | 43 |
718568 | 718568 | 2020-11-10 | McMinn | Tennessee | 47107 | 1942 | 46 |
718569 | 718569 | 2020-11-10 | McNairy | Tennessee | 47109 | 1259 | 30 |
718570 | 718570 | 2020-11-10 | Meigs | Tennessee | 47121 | 388 | 8 |
718571 | 718571 | 2020-11-10 | Monroe | Tennessee | 47123 | 1690 | 33 |
718572 | 718572 | 2020-11-10 | Montgomery | Tennessee | 47125 | 5060 | 68 |
718573 | 718573 | 2020-11-10 | Moore | Tennessee | 47127 | 313 | 3 |
718574 | 718574 | 2020-11-10 | Morgan | Tennessee | 47129 | 511 | 6 |
718575 | 718575 | 2020-11-10 | Obion | Tennessee | 47131 | 2112 | 32 |
718576 | 718576 | 2020-11-10 | Overton | Tennessee | 47133 | 1355 | 30 |
718577 | 718577 | 2020-11-10 | Perry | Tennessee | 47135 | 394 | 16 |
718578 | 718578 | 2020-11-10 | Pickett | Tennessee | 47137 | 314 | 10 |
718579 | 718579 | 2020-11-10 | Polk | Tennessee | 47139 | 569 | 13 |
718580 | 718580 | 2020-11-10 | Putnam | Tennessee | 47141 | 4956 | 64 |
718581 | 718581 | 2020-11-10 | Rhea | Tennessee | 47143 | 1296 | 25 |
718582 | 718582 | 2020-11-10 | Roane | Tennessee | 47145 | 1770 | 10 |
718583 | 718583 | 2020-11-10 | Robertson | Tennessee | 47147 | 2947 | 43 |
718584 | 718584 | 2020-11-10 | Rutherford | Tennessee | 47149 | 14090 | 127 |
718585 | 718585 | 2020-11-10 | Scott | Tennessee | 47151 | 591 | 5 |
718586 | 718586 | 2020-11-10 | Sequatchie | Tennessee | 47153 | 419 | 5 |
718587 | 718587 | 2020-11-10 | Sevier | Tennessee | 47155 | 3883 | 26 |
718588 | 718588 | 2020-11-10 | Shelby | Tennessee | 47157 | 40733 | 593 |
718589 | 718589 | 2020-11-10 | Smith | Tennessee | 47159 | 1147 | 16 |
718590 | 718590 | 2020-11-10 | Stewart | Tennessee | 47161 | 444 | 13 |
718591 | 718591 | 2020-11-10 | Sullivan | Tennessee | 47163 | 4761 | 71 |
718592 | 718592 | 2020-11-10 | Sumner | Tennessee | 47165 | 7273 | 121 |
718593 | 718593 | 2020-11-10 | Tipton | Tennessee | 47167 | 2791 | 26 |
718594 | 718594 | 2020-11-10 | Trousdale | Tennessee | 47169 | 1835 | 10 |
718595 | 718595 | 2020-11-10 | Unicoi | Tennessee | 47171 | 599 | 13 |
718596 | 718596 | 2020-11-10 | Union | Tennessee | 47173 | 601 | 5 |
718597 | 718597 | 2020-11-10 | Unknown | Tennessee | 34 | 0 | |
718598 | 718598 | 2020-11-10 | Van Buren | Tennessee | 47175 | 246 | 2 |
718599 | 718599 | 2020-11-10 | Warren | Tennessee | 47177 | 1802 | 11 |
718600 | 718600 | 2020-11-10 | Washington | Tennessee | 47179 | 4553 | 83 |
718601 | 718601 | 2020-11-10 | Wayne | Tennessee | 47181 | 1659 | 7 |
718602 | 718602 | 2020-11-10 | Weakley | Tennessee | 47183 | 1764 | 29 |
718603 | 718603 | 2020-11-10 | White | Tennessee | 47185 | 1418 | 17 |
718604 | 718604 | 2020-11-10 | Williamson | Tennessee | 47187 | 8621 | 63 |
718605 | 718605 | 2020-11-10 | Wilson | Tennessee | 47189 | 5664 | 66 |
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);