ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,498 rows where county = "Hardeman" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
17317 | 17317 | 2020-03-28 | Hardeman | Tennessee | 47069 | 1 | 0 |
19263 | 19263 | 2020-03-29 | Hardeman | Tennessee | 47069 | 1 | 0 |
21318 | 21318 | 2020-03-30 | Hardeman | Tennessee | 47069 | 1 | 0 |
23456 | 23456 | 2020-03-31 | Hardeman | Tennessee | 47069 | 1 | 0 |
25656 | 25656 | 2020-04-01 | Hardeman | Tennessee | 47069 | 4 | 0 |
27934 | 27934 | 2020-04-02 | Hardeman | Tennessee | 47069 | 4 | 0 |
30269 | 30269 | 2020-04-03 | Hardeman | Tennessee | 47069 | 5 | 0 |
32660 | 32660 | 2020-04-04 | Hardeman | Tennessee | 47069 | 6 | 0 |
35096 | 35096 | 2020-04-05 | Hardeman | Tennessee | 47069 | 6 | 0 |
37572 | 37572 | 2020-04-06 | Hardeman | Tennessee | 47069 | 6 | 0 |
40095 | 40095 | 2020-04-07 | Hardeman | Tennessee | 47069 | 6 | 0 |
42657 | 42657 | 2020-04-08 | Hardeman | Tennessee | 47069 | 6 | 0 |
45244 | 45244 | 2020-04-09 | Hardeman | Tennessee | 47069 | 6 | 0 |
47862 | 47862 | 2020-04-10 | Hardeman | Tennessee | 47069 | 7 | 0 |
50520 | 50520 | 2020-04-11 | Hardeman | Tennessee | 47069 | 7 | 0 |
53195 | 53195 | 2020-04-12 | Hardeman | Tennessee | 47069 | 7 | 0 |
55881 | 55881 | 2020-04-13 | Hardeman | Tennessee | 47069 | 7 | 0 |
58584 | 58584 | 2020-04-14 | Hardeman | Tennessee | 47069 | 7 | 0 |
61299 | 61299 | 2020-04-15 | Hardeman | Tennessee | 47069 | 7 | 0 |
64026 | 64026 | 2020-04-16 | Hardeman | Tennessee | 47069 | 7 | 0 |
66772 | 66772 | 2020-04-17 | Hardeman | Tennessee | 47069 | 7 | 0 |
69531 | 69531 | 2020-04-18 | Hardeman | Tennessee | 47069 | 7 | 0 |
72298 | 72298 | 2020-04-19 | Hardeman | Tennessee | 47069 | 7 | 0 |
75073 | 75073 | 2020-04-20 | Hardeman | Tennessee | 47069 | 7 | 0 |
77855 | 77855 | 2020-04-21 | Hardeman | Tennessee | 47069 | 8 | 0 |
80645 | 80645 | 2020-04-22 | Hardeman | Tennessee | 47069 | 8 | 0 |
83444 | 83444 | 2020-04-23 | Hardeman | Tennessee | 47069 | 8 | 0 |
86249 | 86249 | 2020-04-24 | Hardeman | Tennessee | 47069 | 9 | 0 |
89064 | 89064 | 2020-04-25 | Hardeman | Tennessee | 47069 | 11 | 0 |
91881 | 91881 | 2020-04-26 | Hardeman | Tennessee | 47069 | 11 | 0 |
94709 | 94709 | 2020-04-27 | Hardeman | Tennessee | 47069 | 11 | 0 |
97549 | 97549 | 2020-04-28 | Hardeman | Tennessee | 47069 | 11 | 0 |
100399 | 100399 | 2020-04-29 | Hardeman | Tennessee | 47069 | 11 | 0 |
103252 | 103252 | 2020-04-30 | Hardeman | Tennessee | 47069 | 14 | 0 |
106115 | 106115 | 2020-05-01 | Hardeman | Tennessee | 47069 | 16 | 0 |
108982 | 108982 | 2020-05-02 | Hardeman | Tennessee | 47069 | 17 | 0 |
111856 | 111856 | 2020-05-03 | Hardeman | Tennessee | 47069 | 19 | 0 |
114738 | 114738 | 2020-05-04 | Hardeman | Tennessee | 47069 | 20 | 0 |
117694 | 117694 | 2020-05-05 | Hardeman | Tennessee | 47069 | 20 | 0 |
120658 | 120658 | 2020-05-06 | Hardeman | Tennessee | 47069 | 22 | 0 |
123636 | 123636 | 2020-05-07 | Hardeman | Tennessee | 47069 | 23 | 0 |
126619 | 126619 | 2020-05-08 | Hardeman | Tennessee | 47069 | 64 | 0 |
129608 | 129608 | 2020-05-09 | Hardeman | Tennessee | 47069 | 116 | 0 |
132597 | 132597 | 2020-05-10 | Hardeman | Tennessee | 47069 | 151 | 0 |
135588 | 135588 | 2020-05-11 | Hardeman | Tennessee | 47069 | 171 | 0 |
138578 | 138578 | 2020-05-12 | Hardeman | Tennessee | 47069 | 170 | 0 |
141574 | 141574 | 2020-05-13 | Hardeman | Tennessee | 47069 | 177 | 0 |
144571 | 144571 | 2020-05-14 | Hardeman | Tennessee | 47069 | 179 | 0 |
147572 | 147572 | 2020-05-15 | Hardeman | Tennessee | 47069 | 180 | 0 |
150580 | 150580 | 2020-05-16 | Hardeman | Tennessee | 47069 | 183 | 0 |
153591 | 153591 | 2020-05-17 | Hardeman | Tennessee | 47069 | 182 | 0 |
156608 | 156608 | 2020-05-18 | Hardeman | Tennessee | 47069 | 183 | 0 |
159630 | 159630 | 2020-05-19 | Hardeman | Tennessee | 47069 | 183 | 0 |
162657 | 162657 | 2020-05-20 | Hardeman | Tennessee | 47069 | 183 | 0 |
165686 | 165686 | 2020-05-21 | Hardeman | Tennessee | 47069 | 184 | 0 |
168722 | 168722 | 2020-05-22 | Hardeman | Tennessee | 47069 | 187 | 0 |
171761 | 171761 | 2020-05-23 | Hardeman | Tennessee | 47069 | 188 | 0 |
174804 | 174804 | 2020-05-24 | Hardeman | Tennessee | 47069 | 189 | 0 |
177848 | 177848 | 2020-05-25 | Hardeman | Tennessee | 47069 | 188 | 0 |
180891 | 180891 | 2020-05-26 | Hardeman | Tennessee | 47069 | 189 | 0 |
183941 | 183941 | 2020-05-27 | Hardeman | Tennessee | 47069 | 192 | 0 |
186998 | 186998 | 2020-05-28 | Hardeman | Tennessee | 47069 | 194 | 0 |
190062 | 190062 | 2020-05-29 | Hardeman | Tennessee | 47069 | 195 | 0 |
193127 | 193127 | 2020-05-30 | Hardeman | Tennessee | 47069 | 196 | 0 |
196197 | 196197 | 2020-05-31 | Hardeman | Tennessee | 47069 | 196 | 0 |
199270 | 199270 | 2020-06-01 | Hardeman | Tennessee | 47069 | 196 | 0 |
202345 | 202345 | 2020-06-02 | Hardeman | Tennessee | 47069 | 202 | 0 |
205424 | 205424 | 2020-06-03 | Hardeman | Tennessee | 47069 | 201 | 0 |
208506 | 208506 | 2020-06-04 | Hardeman | Tennessee | 47069 | 202 | 0 |
211588 | 211588 | 2020-06-05 | Hardeman | Tennessee | 47069 | 204 | 0 |
214675 | 214675 | 2020-06-06 | Hardeman | Tennessee | 47069 | 208 | 0 |
217765 | 217765 | 2020-06-07 | Hardeman | Tennessee | 47069 | 211 | 0 |
220857 | 220857 | 2020-06-08 | Hardeman | Tennessee | 47069 | 211 | 0 |
223952 | 223952 | 2020-06-09 | Hardeman | Tennessee | 47069 | 212 | 0 |
227052 | 227052 | 2020-06-10 | Hardeman | Tennessee | 47069 | 213 | 0 |
230156 | 230156 | 2020-06-11 | Hardeman | Tennessee | 47069 | 214 | 0 |
233261 | 233261 | 2020-06-12 | Hardeman | Tennessee | 47069 | 215 | 0 |
236367 | 236367 | 2020-06-13 | Hardeman | Tennessee | 47069 | 215 | 0 |
239475 | 239475 | 2020-06-14 | Hardeman | Tennessee | 47069 | 217 | 0 |
242585 | 242585 | 2020-06-15 | Hardeman | Tennessee | 47069 | 220 | 0 |
245697 | 245697 | 2020-06-16 | Hardeman | Tennessee | 47069 | 225 | 0 |
248810 | 248810 | 2020-06-17 | Hardeman | Tennessee | 47069 | 226 | 0 |
251925 | 251925 | 2020-06-18 | Hardeman | Tennessee | 47069 | 226 | 0 |
255040 | 255040 | 2020-06-19 | Hardeman | Tennessee | 47069 | 252 | 1 |
258166 | 258166 | 2020-06-20 | Hardeman | Tennessee | 47069 | 253 | 1 |
261293 | 261293 | 2020-06-21 | Hardeman | Tennessee | 47069 | 255 | 1 |
264421 | 264421 | 2020-06-22 | Hardeman | Tennessee | 47069 | 257 | 1 |
267549 | 267549 | 2020-06-23 | Hardeman | Tennessee | 47069 | 257 | 1 |
270683 | 270683 | 2020-06-24 | Hardeman | Tennessee | 47069 | 260 | 1 |
273822 | 273822 | 2020-06-25 | Hardeman | Tennessee | 47069 | 269 | 1 |
276969 | 276969 | 2020-06-26 | Hardeman | Tennessee | 47069 | 273 | 1 |
280117 | 280117 | 2020-06-27 | Hardeman | Tennessee | 47069 | 276 | 1 |
283263 | 283263 | 2020-06-28 | Hardeman | Tennessee | 47069 | 276 | 1 |
286408 | 286408 | 2020-06-29 | Hardeman | Tennessee | 47069 | 287 | 1 |
289559 | 289559 | 2020-06-30 | Hardeman | Tennessee | 47069 | 299 | 1 |
292711 | 292711 | 2020-07-01 | Hardeman | Tennessee | 47069 | 304 | 1 |
295867 | 295867 | 2020-07-02 | Hardeman | Tennessee | 47069 | 314 | 3 |
299027 | 299027 | 2020-07-03 | Hardeman | Tennessee | 47069 | 325 | 5 |
302191 | 302191 | 2020-07-04 | Hardeman | Tennessee | 47069 | 329 | 5 |
305354 | 305354 | 2020-07-05 | Hardeman | Tennessee | 47069 | 343 | 4 |
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);