ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2021-03-04 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1088487 | 1088487 | 2021-03-04 | Anderson | Tennessee | 47001 | 8044 | 158 |
1088488 | 1088488 | 2021-03-04 | Bedford | Tennessee | 47003 | 5816 | 120 |
1088489 | 1088489 | 2021-03-04 | Benton | Tennessee | 47005 | 1510 | 39 |
1088490 | 1088490 | 2021-03-04 | Bledsoe | Tennessee | 47007 | 2010 | 10 |
1088491 | 1088491 | 2021-03-04 | Blount | Tennessee | 47009 | 14141 | 183 |
1088492 | 1088492 | 2021-03-04 | Bradley | Tennessee | 47011 | 12996 | 141 |
1088493 | 1088493 | 2021-03-04 | Campbell | Tennessee | 47013 | 3818 | 59 |
1088494 | 1088494 | 2021-03-04 | Cannon | Tennessee | 47015 | 1767 | 30 |
1088495 | 1088495 | 2021-03-04 | Carroll | Tennessee | 47017 | 3491 | 81 |
1088496 | 1088496 | 2021-03-04 | Carter | Tennessee | 47019 | 5990 | 155 |
1088497 | 1088497 | 2021-03-04 | Cheatham | Tennessee | 47021 | 3945 | 44 |
1088498 | 1088498 | 2021-03-04 | Chester | Tennessee | 47023 | 2023 | 48 |
1088499 | 1088499 | 2021-03-04 | Claiborne | Tennessee | 47025 | 2830 | 69 |
1088500 | 1088500 | 2021-03-04 | Clay | Tennessee | 47027 | 1071 | 30 |
1088501 | 1088501 | 2021-03-04 | Cocke | Tennessee | 47029 | 4012 | 95 |
1088502 | 1088502 | 2021-03-04 | Coffee | Tennessee | 47031 | 6418 | 115 |
1088503 | 1088503 | 2021-03-04 | Crockett | Tennessee | 47033 | 1975 | 47 |
1088504 | 1088504 | 2021-03-04 | Cumberland | Tennessee | 47035 | 6127 | 122 |
1088505 | 1088505 | 2021-03-04 | Davidson | Tennessee | 47037 | 90336 | 871 |
1088506 | 1088506 | 2021-03-04 | DeKalb | Tennessee | 47041 | 2661 | 51 |
1088507 | 1088507 | 2021-03-04 | Decatur | Tennessee | 47039 | 1538 | 37 |
1088508 | 1088508 | 2021-03-04 | Dickson | Tennessee | 47043 | 6256 | 106 |
1088509 | 1088509 | 2021-03-04 | Dyer | Tennessee | 47045 | 5242 | 101 |
1088510 | 1088510 | 2021-03-04 | Fayette | Tennessee | 47047 | 4683 | 72 |
1088511 | 1088511 | 2021-03-04 | Fentress | Tennessee | 47049 | 2295 | 44 |
1088512 | 1088512 | 2021-03-04 | Franklin | Tennessee | 47051 | 4757 | 85 |
1088513 | 1088513 | 2021-03-04 | Gibson | Tennessee | 47053 | 6196 | 141 |
1088514 | 1088514 | 2021-03-04 | Giles | Tennessee | 47055 | 3752 | 97 |
1088515 | 1088515 | 2021-03-04 | Grainger | Tennessee | 47057 | 2442 | 46 |
1088516 | 1088516 | 2021-03-04 | Greene | Tennessee | 47059 | 7309 | 145 |
1088517 | 1088517 | 2021-03-04 | Grundy | Tennessee | 47061 | 1697 | 30 |
1088518 | 1088518 | 2021-03-04 | Hamblen | Tennessee | 47063 | 8063 | 165 |
1088519 | 1088519 | 2021-03-04 | Hamilton | Tennessee | 47065 | 40843 | 466 |
1088520 | 1088520 | 2021-03-04 | Hancock | Tennessee | 47067 | 497 | 12 |
1088521 | 1088521 | 2021-03-04 | Hardeman | Tennessee | 47069 | 3388 | 64 |
1088522 | 1088522 | 2021-03-04 | Hardin | Tennessee | 47071 | 3315 | 63 |
1088523 | 1088523 | 2021-03-04 | Hawkins | Tennessee | 47073 | 5271 | 95 |
1088524 | 1088524 | 2021-03-04 | Haywood | Tennessee | 47075 | 2649 | 60 |
1088525 | 1088525 | 2021-03-04 | Henderson | Tennessee | 47077 | 3622 | 73 |
1088526 | 1088526 | 2021-03-04 | Henry | Tennessee | 47079 | 3012 | 75 |
1088527 | 1088527 | 2021-03-04 | Hickman | Tennessee | 47081 | 2665 | 41 |
1088528 | 1088528 | 2021-03-04 | Houston | Tennessee | 47083 | 1036 | 32 |
1088529 | 1088529 | 2021-03-04 | Humphreys | Tennessee | 47085 | 1549 | 21 |
1088530 | 1088530 | 2021-03-04 | Jackson | Tennessee | 47087 | 1256 | 34 |
1088531 | 1088531 | 2021-03-04 | Jefferson | Tennessee | 47089 | 5688 | 119 |
1088532 | 1088532 | 2021-03-04 | Johnson | Tennessee | 47091 | 2171 | 38 |
1088533 | 1088533 | 2021-03-04 | Knox | Tennessee | 47093 | 47260 | 587 |
1088534 | 1088534 | 2021-03-04 | Lake | Tennessee | 47095 | 1679 | 26 |
1088535 | 1088535 | 2021-03-04 | Lauderdale | Tennessee | 47097 | 3096 | 42 |
1088536 | 1088536 | 2021-03-04 | Lawrence | Tennessee | 47099 | 5574 | 83 |
1088537 | 1088537 | 2021-03-04 | Lewis | Tennessee | 47101 | 1474 | 25 |
1088538 | 1088538 | 2021-03-04 | Lincoln | Tennessee | 47103 | 4156 | 62 |
1088539 | 1088539 | 2021-03-04 | Loudon | Tennessee | 47105 | 5719 | 66 |
1088540 | 1088540 | 2021-03-04 | Macon | Tennessee | 47111 | 3372 | 73 |
1088541 | 1088541 | 2021-03-04 | Madison | Tennessee | 47113 | 10123 | 230 |
1088542 | 1088542 | 2021-03-04 | Marion | Tennessee | 47115 | 2947 | 44 |
1088543 | 1088543 | 2021-03-04 | Marshall | Tennessee | 47117 | 3919 | 56 |
1088544 | 1088544 | 2021-03-04 | Maury | Tennessee | 47119 | 12246 | 163 |
1088545 | 1088545 | 2021-03-04 | McMinn | Tennessee | 47107 | 5945 | 92 |
1088546 | 1088546 | 2021-03-04 | McNairy | Tennessee | 47109 | 2683 | 53 |
1088547 | 1088547 | 2021-03-04 | Meigs | Tennessee | 47121 | 1267 | 22 |
1088548 | 1088548 | 2021-03-04 | Monroe | Tennessee | 47123 | 5365 | 90 |
1088549 | 1088549 | 2021-03-04 | Montgomery | Tennessee | 47125 | 17484 | 213 |
1088550 | 1088550 | 2021-03-04 | Moore | Tennessee | 47127 | 945 | 16 |
1088551 | 1088551 | 2021-03-04 | Morgan | Tennessee | 47129 | 2303 | 38 |
1088552 | 1088552 | 2021-03-04 | Obion | Tennessee | 47131 | 4369 | 95 |
1088553 | 1088553 | 2021-03-04 | Overton | Tennessee | 47133 | 2855 | 57 |
1088554 | 1088554 | 2021-03-04 | Perry | Tennessee | 47135 | 1035 | 27 |
1088555 | 1088555 | 2021-03-04 | Pickett | Tennessee | 47137 | 746 | 23 |
1088556 | 1088556 | 2021-03-04 | Polk | Tennessee | 47139 | 1777 | 22 |
1088557 | 1088557 | 2021-03-04 | Putnam | Tennessee | 47141 | 10635 | 170 |
1088558 | 1088558 | 2021-03-04 | Rhea | Tennessee | 47143 | 4152 | 73 |
1088559 | 1088559 | 2021-03-04 | Roane | Tennessee | 47145 | 5926 | 96 |
1088560 | 1088560 | 2021-03-04 | Robertson | Tennessee | 47147 | 8997 | 121 |
1088561 | 1088561 | 2021-03-04 | Rutherford | Tennessee | 47149 | 38563 | 386 |
1088562 | 1088562 | 2021-03-04 | Scott | Tennessee | 47151 | 2881 | 44 |
1088563 | 1088563 | 2021-03-04 | Sequatchie | Tennessee | 47153 | 1573 | 27 |
1088564 | 1088564 | 2021-03-04 | Sevier | Tennessee | 47155 | 12109 | 164 |
1088565 | 1088565 | 2021-03-04 | Shelby | Tennessee | 47157 | 88521 | 1517 |
1088566 | 1088566 | 2021-03-04 | Smith | Tennessee | 47159 | 2569 | 36 |
1088567 | 1088567 | 2021-03-04 | Stewart | Tennessee | 47161 | 1240 | 25 |
1088568 | 1088568 | 2021-03-04 | Sullivan | Tennessee | 47163 | 14431 | 274 |
1088569 | 1088569 | 2021-03-04 | Sumner | Tennessee | 47165 | 21448 | 318 |
1088570 | 1088570 | 2021-03-04 | Tipton | Tennessee | 47167 | 6962 | 103 |
1088571 | 1088571 | 2021-03-04 | Trousdale | Tennessee | 47169 | 2398 | 22 |
1088572 | 1088572 | 2021-03-04 | Unicoi | Tennessee | 47171 | 1814 | 47 |
1088573 | 1088573 | 2021-03-04 | Union | Tennessee | 47173 | 1730 | 33 |
1088574 | 1088574 | 2021-03-04 | Unknown | Tennessee | 8514 | 116 | |
1088575 | 1088575 | 2021-03-04 | Van Buren | Tennessee | 47175 | 797 | 20 |
1088576 | 1088576 | 2021-03-04 | Warren | Tennessee | 47177 | 5325 | 76 |
1088577 | 1088577 | 2021-03-04 | Washington | Tennessee | 47179 | 12818 | 234 |
1088578 | 1088578 | 2021-03-04 | Wayne | Tennessee | 47181 | 2876 | 30 |
1088579 | 1088579 | 2021-03-04 | Weakley | Tennessee | 47183 | 3793 | 59 |
1088580 | 1088580 | 2021-03-04 | White | Tennessee | 47185 | 3393 | 66 |
1088581 | 1088581 | 2021-03-04 | Williamson | Tennessee | 47187 | 25382 | 204 |
1088582 | 1088582 | 2021-03-04 | Wilson | Tennessee | 47189 | 16510 | 211 |
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);