ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

96 rows where date = "2021-08-17" and state = "Tennessee" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Tennessee · 96 ✖
Link rowid date ▲ county state fips cases deaths
1627467 1627467 2021-08-17 Anderson Tennessee 47001 9535 181
1627468 1627468 2021-08-17 Bedford Tennessee 47003 7184 135
1627469 1627469 2021-08-17 Benton Tennessee 47005 1884 41
1627470 1627470 2021-08-17 Bledsoe Tennessee 47007 2460 13
1627471 1627471 2021-08-17 Blount Tennessee 47009 17490 210
1627472 1627472 2021-08-17 Bradley Tennessee 47011 16648 158
1627473 1627473 2021-08-17 Campbell Tennessee 47013 4576 64
1627474 1627474 2021-08-17 Cannon Tennessee 47015 2086 32
1627475 1627475 2021-08-17 Carroll Tennessee 47017 4037 84
1627476 1627476 2021-08-17 Carter Tennessee 47019 7402 169
1627477 1627477 2021-08-17 Cheatham Tennessee 47021 5026 56
1627478 1627478 2021-08-17 Chester Tennessee 47023 2532 51
1627479 1627479 2021-08-17 Claiborne Tennessee 47025 3507 78
1627480 1627480 2021-08-17 Clay Tennessee 47027 1155 30
1627481 1627481 2021-08-17 Cocke Tennessee 47029 5119 102
1627482 1627482 2021-08-17 Coffee Tennessee 47031 7469 123
1627483 1627483 2021-08-17 Crockett Tennessee 47033 2504 52
1627484 1627484 2021-08-17 Cumberland Tennessee 47035 7720 147
1627485 1627485 2021-08-17 Davidson Tennessee 47037 107425 984
1627486 1627486 2021-08-17 DeKalb Tennessee 47041 3055 57
1627487 1627487 2021-08-17 Decatur Tennessee 47039 1780 39
1627488 1627488 2021-08-17 Dickson Tennessee 47043 7658 121
1627489 1627489 2021-08-17 Dyer Tennessee 47045 6009 110
1627490 1627490 2021-08-17 Fayette Tennessee 47047 5821 85
1627491 1627491 2021-08-17 Fentress Tennessee 47049 2667 50
1627492 1627492 2021-08-17 Franklin Tennessee 47051 5785 92
1627493 1627493 2021-08-17 Gibson Tennessee 47053 7776 152
1627494 1627494 2021-08-17 Giles Tennessee 47055 4397 100
1627495 1627495 2021-08-17 Grainger Tennessee 47057 2920 51
1627496 1627496 2021-08-17 Greene Tennessee 47059 8873 165
1627497 1627497 2021-08-17 Grundy Tennessee 47061 1976 35
1627498 1627498 2021-08-17 Hamblen Tennessee 47063 9737 178
1627499 1627499 2021-08-17 Hamilton Tennessee 47065 50731 533
1627500 1627500 2021-08-17 Hancock Tennessee 47067 713 13
1627501 1627501 2021-08-17 Hardeman Tennessee 47069 3954 65
1627502 1627502 2021-08-17 Hardin Tennessee 47071 4009 70
1627503 1627503 2021-08-17 Hawkins Tennessee 47073 7017 124
1627504 1627504 2021-08-17 Haywood Tennessee 47075 3015 62
1627505 1627505 2021-08-17 Henderson Tennessee 47077 4156 79
1627506 1627506 2021-08-17 Henry Tennessee 47079 3939 76
1627507 1627507 2021-08-17 Hickman Tennessee 47081 3219 48
1627508 1627508 2021-08-17 Houston Tennessee 47083 1322 34
1627509 1627509 2021-08-17 Humphreys Tennessee 47085 2200 32
1627510 1627510 2021-08-17 Jackson Tennessee 47087 1460 37
1627511 1627511 2021-08-17 Jefferson Tennessee 47089 6983 130
1627512 1627512 2021-08-17 Johnson Tennessee 47091 2599 39
1627513 1627513 2021-08-17 Knox Tennessee 47093 56503 675
1627514 1627514 2021-08-17 Lake Tennessee 47095 1758 31
1627515 1627515 2021-08-17 Lauderdale Tennessee 47097 3680 50
1627516 1627516 2021-08-17 Lawrence Tennessee 47099 6692 101
1627517 1627517 2021-08-17 Lewis Tennessee 47101 1832 28
1627518 1627518 2021-08-17 Lincoln Tennessee 47103 4932 69
1627519 1627519 2021-08-17 Loudon Tennessee 47105 6736 73
1627520 1627520 2021-08-17 Macon Tennessee 47111 3986 78
1627521 1627521 2021-08-17 Madison Tennessee 47113 13322 251
1627522 1627522 2021-08-17 Marion Tennessee 47115 3661 51
1627523 1627523 2021-08-17 Marshall Tennessee 47117 4794 65
1627524 1627524 2021-08-17 Maury Tennessee 47119 14938 183
1627525 1627525 2021-08-17 McMinn Tennessee 47107 7384 108
1627526 1627526 2021-08-17 McNairy Tennessee 47109 3300 57
1627527 1627527 2021-08-17 Meigs Tennessee 47121 1563 24
1627528 1627528 2021-08-17 Monroe Tennessee 47123 6576 98
1627529 1627529 2021-08-17 Montgomery Tennessee 47125 23465 237
1627530 1627530 2021-08-17 Moore Tennessee 47127 1139 19
1627531 1627531 2021-08-17 Morgan Tennessee 47129 2797 40
1627532 1627532 2021-08-17 Obion Tennessee 47131 4964 98
1627533 1627533 2021-08-17 Overton Tennessee 47133 3258 63
1627534 1627534 2021-08-17 Perry Tennessee 47135 1176 29
1627535 1627535 2021-08-17 Pickett Tennessee 47137 815 24
1627536 1627536 2021-08-17 Polk Tennessee 47139 2330 25
1627537 1627537 2021-08-17 Putnam Tennessee 47141 12570 184
1627538 1627538 2021-08-17 Rhea Tennessee 47143 4842 83
1627539 1627539 2021-08-17 Roane Tennessee 47145 7132 115
1627540 1627540 2021-08-17 Robertson Tennessee 47147 10795 145
1627541 1627541 2021-08-17 Rutherford Tennessee 47149 47538 458
1627542 1627542 2021-08-17 Scott Tennessee 47151 3404 49
1627543 1627543 2021-08-17 Sequatchie Tennessee 47153 1964 30
1627544 1627544 2021-08-17 Sevier Tennessee 47155 15083 183
1627545 1627545 2021-08-17 Shelby Tennessee 47157 115471 1790
1627546 1627546 2021-08-17 Smith Tennessee 47159 3052 40
1627547 1627547 2021-08-17 Stewart Tennessee 47161 1471 28
1627548 1627548 2021-08-17 Sullivan Tennessee 47163 19072 328
1627549 1627549 2021-08-17 Sumner Tennessee 47165 27137 367
1627550 1627550 2021-08-17 Tipton Tennessee 47167 8608 107
1627551 1627551 2021-08-17 Trousdale Tennessee 47169 2663 22
1627552 1627552 2021-08-17 Unicoi Tennessee 47171 2221 51
1627553 1627553 2021-08-17 Union Tennessee 47173 2067 35
1627554 1627554 2021-08-17 Unknown Tennessee   8693 96
1627555 1627555 2021-08-17 Van Buren Tennessee 47175 927 23
1627556 1627556 2021-08-17 Warren Tennessee 47177 5916 87
1627557 1627557 2021-08-17 Washington Tennessee 47179 16147 260
1627558 1627558 2021-08-17 Wayne Tennessee 47181 3177 36
1627559 1627559 2021-08-17 Weakley Tennessee 47183 4559 70
1627560 1627560 2021-08-17 White Tennessee 47185 3980 75
1627561 1627561 2021-08-17 Williamson Tennessee 47187 31673 228
1627562 1627562 2021-08-17 Wilson Tennessee 47189 21195 262

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);