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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
171915 | 171915 | 2020-05-23 | Hardeman | Texas | 48197 | 1 | 0 |
174958 | 174958 | 2020-05-24 | Hardeman | Texas | 48197 | 1 | 0 |
178002 | 178002 | 2020-05-25 | Hardeman | Texas | 48197 | 1 | 0 |
181045 | 181045 | 2020-05-26 | Hardeman | Texas | 48197 | 1 | 0 |
184095 | 184095 | 2020-05-27 | Hardeman | Texas | 48197 | 1 | 0 |
187152 | 187152 | 2020-05-28 | Hardeman | Texas | 48197 | 1 | 0 |
190216 | 190216 | 2020-05-29 | Hardeman | Texas | 48197 | 1 | 0 |
193281 | 193281 | 2020-05-30 | Hardeman | Texas | 48197 | 1 | 0 |
196351 | 196351 | 2020-05-31 | Hardeman | Texas | 48197 | 1 | 0 |
199424 | 199424 | 2020-06-01 | Hardeman | Texas | 48197 | 1 | 0 |
202499 | 202499 | 2020-06-02 | Hardeman | Texas | 48197 | 1 | 0 |
205578 | 205578 | 2020-06-03 | Hardeman | Texas | 48197 | 2 | 0 |
208660 | 208660 | 2020-06-04 | Hardeman | Texas | 48197 | 2 | 0 |
211744 | 211744 | 2020-06-05 | Hardeman | Texas | 48197 | 3 | 0 |
214831 | 214831 | 2020-06-06 | Hardeman | Texas | 48197 | 3 | 0 |
217921 | 217921 | 2020-06-07 | Hardeman | Texas | 48197 | 3 | 0 |
221013 | 221013 | 2020-06-08 | Hardeman | Texas | 48197 | 3 | 0 |
224108 | 224108 | 2020-06-09 | Hardeman | Texas | 48197 | 4 | 0 |
227208 | 227208 | 2020-06-10 | Hardeman | Texas | 48197 | 4 | 0 |
230312 | 230312 | 2020-06-11 | Hardeman | Texas | 48197 | 4 | 0 |
233416 | 233416 | 2020-06-12 | Hardeman | Texas | 48197 | 4 | 0 |
236522 | 236522 | 2020-06-13 | Hardeman | Texas | 48197 | 4 | 0 |
239630 | 239630 | 2020-06-14 | Hardeman | Texas | 48197 | 4 | 0 |
242740 | 242740 | 2020-06-15 | Hardeman | Texas | 48197 | 4 | 0 |
245852 | 245852 | 2020-06-16 | Hardeman | Texas | 48197 | 4 | 0 |
248965 | 248965 | 2020-06-17 | Hardeman | Texas | 48197 | 4 | 0 |
252080 | 252080 | 2020-06-18 | Hardeman | Texas | 48197 | 4 | 0 |
255195 | 255195 | 2020-06-19 | Hardeman | Texas | 48197 | 4 | 0 |
258322 | 258322 | 2020-06-20 | Hardeman | Texas | 48197 | 4 | 0 |
261449 | 261449 | 2020-06-21 | Hardeman | Texas | 48197 | 4 | 0 |
264577 | 264577 | 2020-06-22 | Hardeman | Texas | 48197 | 4 | 0 |
267705 | 267705 | 2020-06-23 | Hardeman | Texas | 48197 | 4 | 0 |
270839 | 270839 | 2020-06-24 | Hardeman | Texas | 48197 | 4 | 0 |
273979 | 273979 | 2020-06-25 | Hardeman | Texas | 48197 | 4 | 0 |
277126 | 277126 | 2020-06-26 | Hardeman | Texas | 48197 | 4 | 0 |
280274 | 280274 | 2020-06-27 | Hardeman | Texas | 48197 | 4 | 0 |
283420 | 283420 | 2020-06-28 | Hardeman | Texas | 48197 | 4 | 0 |
286566 | 286566 | 2020-06-29 | Hardeman | Texas | 48197 | 4 | 0 |
289716 | 289716 | 2020-06-30 | Hardeman | Texas | 48197 | 5 | 0 |
292869 | 292869 | 2020-07-01 | Hardeman | Texas | 48197 | 5 | 0 |
296024 | 296024 | 2020-07-02 | Hardeman | Texas | 48197 | 5 | 0 |
299184 | 299184 | 2020-07-03 | Hardeman | Texas | 48197 | 5 | 0 |
302348 | 302348 | 2020-07-04 | Hardeman | Texas | 48197 | 5 | 0 |
305512 | 305512 | 2020-07-05 | Hardeman | Texas | 48197 | 5 | 0 |
308680 | 308680 | 2020-07-06 | Hardeman | Texas | 48197 | 5 | 0 |
311849 | 311849 | 2020-07-07 | Hardeman | Texas | 48197 | 5 | 0 |
315023 | 315023 | 2020-07-08 | Hardeman | Texas | 48197 | 5 | 0 |
318196 | 318196 | 2020-07-09 | Hardeman | Texas | 48197 | 5 | 0 |
321375 | 321375 | 2020-07-10 | Hardeman | Texas | 48197 | 5 | 0 |
324556 | 324556 | 2020-07-11 | Hardeman | Texas | 48197 | 5 | 0 |
327741 | 327741 | 2020-07-12 | Hardeman | Texas | 48197 | 5 | 0 |
330927 | 330927 | 2020-07-13 | Hardeman | Texas | 48197 | 5 | 0 |
334118 | 334118 | 2020-07-14 | Hardeman | Texas | 48197 | 6 | 0 |
337313 | 337313 | 2020-07-15 | Hardeman | Texas | 48197 | 6 | 0 |
340509 | 340509 | 2020-07-16 | Hardeman | Texas | 48197 | 6 | 0 |
343708 | 343708 | 2020-07-17 | Hardeman | Texas | 48197 | 6 | 0 |
346908 | 346908 | 2020-07-18 | Hardeman | Texas | 48197 | 6 | 0 |
350108 | 350108 | 2020-07-19 | Hardeman | Texas | 48197 | 6 | 0 |
353310 | 353310 | 2020-07-20 | Hardeman | Texas | 48197 | 6 | 0 |
356513 | 356513 | 2020-07-21 | Hardeman | Texas | 48197 | 8 | 0 |
359718 | 359718 | 2020-07-22 | Hardeman | Texas | 48197 | 10 | 0 |
362925 | 362925 | 2020-07-23 | Hardeman | Texas | 48197 | 10 | 0 |
366131 | 366131 | 2020-07-24 | Hardeman | Texas | 48197 | 10 | 0 |
369340 | 369340 | 2020-07-25 | Hardeman | Texas | 48197 | 11 | 0 |
372552 | 372552 | 2020-07-26 | Hardeman | Texas | 48197 | 11 | 0 |
375765 | 375765 | 2020-07-27 | Hardeman | Texas | 48197 | 11 | 0 |
378981 | 378981 | 2020-07-28 | Hardeman | Texas | 48197 | 13 | 0 |
382198 | 382198 | 2020-07-29 | Hardeman | Texas | 48197 | 14 | 0 |
385416 | 385416 | 2020-07-30 | Hardeman | Texas | 48197 | 14 | 0 |
388633 | 388633 | 2020-07-31 | Hardeman | Texas | 48197 | 15 | 0 |
391850 | 391850 | 2020-08-01 | Hardeman | Texas | 48197 | 15 | 0 |
395066 | 395066 | 2020-08-02 | Hardeman | Texas | 48197 | 15 | 0 |
398282 | 398282 | 2020-08-03 | Hardeman | Texas | 48197 | 15 | 0 |
401498 | 401498 | 2020-08-04 | Hardeman | Texas | 48197 | 16 | 0 |
404716 | 404716 | 2020-08-05 | Hardeman | Texas | 48197 | 17 | 0 |
407936 | 407936 | 2020-08-06 | Hardeman | Texas | 48197 | 17 | 0 |
411155 | 411155 | 2020-08-07 | Hardeman | Texas | 48197 | 17 | 0 |
414375 | 414375 | 2020-08-08 | Hardeman | Texas | 48197 | 18 | 0 |
417596 | 417596 | 2020-08-09 | Hardeman | Texas | 48197 | 18 | 0 |
420817 | 420817 | 2020-08-10 | Hardeman | Texas | 48197 | 18 | 0 |
424038 | 424038 | 2020-08-11 | Hardeman | Texas | 48197 | 21 | 0 |
427262 | 427262 | 2020-08-12 | Hardeman | Texas | 48197 | 22 | 0 |
430489 | 430489 | 2020-08-13 | Hardeman | Texas | 48197 | 22 | 0 |
433714 | 433714 | 2020-08-14 | Hardeman | Texas | 48197 | 22 | 0 |
436940 | 436940 | 2020-08-15 | Hardeman | Texas | 48197 | 22 | 0 |
440166 | 440166 | 2020-08-16 | Hardeman | Texas | 48197 | 22 | 0 |
443392 | 443392 | 2020-08-17 | Hardeman | Texas | 48197 | 22 | 0 |
446619 | 446619 | 2020-08-18 | Hardeman | Texas | 48197 | 22 | 0 |
449847 | 449847 | 2020-08-19 | Hardeman | Texas | 48197 | 22 | 0 |
453075 | 453075 | 2020-08-20 | Hardeman | Texas | 48197 | 22 | 0 |
456303 | 456303 | 2020-08-21 | Hardeman | Texas | 48197 | 22 | 0 |
459530 | 459530 | 2020-08-22 | Hardeman | Texas | 48197 | 22 | 0 |
462759 | 462759 | 2020-08-23 | Hardeman | Texas | 48197 | 22 | 0 |
465988 | 465988 | 2020-08-24 | Hardeman | Texas | 48197 | 22 | 0 |
469217 | 469217 | 2020-08-25 | Hardeman | Texas | 48197 | 22 | 0 |
472449 | 472449 | 2020-08-26 | Hardeman | Texas | 48197 | 22 | 0 |
475682 | 475682 | 2020-08-27 | Hardeman | Texas | 48197 | 22 | 0 |
478915 | 478915 | 2020-08-28 | Hardeman | Texas | 48197 | 22 | 0 |
482149 | 482149 | 2020-08-29 | Hardeman | Texas | 48197 | 22 | 0 |
485384 | 485384 | 2020-08-30 | Hardeman | Texas | 48197 | 22 | 0 |
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);