ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
710 rows where county = "Hanson" and state = "South Dakota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
205358 | 205358 | 2020-06-03 | Hanson | South Dakota | 46061 | 1 | 0 |
208440 | 208440 | 2020-06-04 | Hanson | South Dakota | 46061 | 1 | 0 |
211522 | 211522 | 2020-06-05 | Hanson | South Dakota | 46061 | 2 | 0 |
214609 | 214609 | 2020-06-06 | Hanson | South Dakota | 46061 | 2 | 0 |
217699 | 217699 | 2020-06-07 | Hanson | South Dakota | 46061 | 2 | 0 |
220791 | 220791 | 2020-06-08 | Hanson | South Dakota | 46061 | 3 | 0 |
223886 | 223886 | 2020-06-09 | Hanson | South Dakota | 46061 | 3 | 0 |
226986 | 226986 | 2020-06-10 | Hanson | South Dakota | 46061 | 3 | 0 |
230090 | 230090 | 2020-06-11 | Hanson | South Dakota | 46061 | 3 | 0 |
233195 | 233195 | 2020-06-12 | Hanson | South Dakota | 46061 | 3 | 0 |
236300 | 236300 | 2020-06-13 | Hanson | South Dakota | 46061 | 3 | 0 |
239408 | 239408 | 2020-06-14 | Hanson | South Dakota | 46061 | 3 | 0 |
242518 | 242518 | 2020-06-15 | Hanson | South Dakota | 46061 | 3 | 0 |
245630 | 245630 | 2020-06-16 | Hanson | South Dakota | 46061 | 3 | 0 |
248743 | 248743 | 2020-06-17 | Hanson | South Dakota | 46061 | 3 | 0 |
251858 | 251858 | 2020-06-18 | Hanson | South Dakota | 46061 | 3 | 0 |
254973 | 254973 | 2020-06-19 | Hanson | South Dakota | 46061 | 3 | 0 |
258099 | 258099 | 2020-06-20 | Hanson | South Dakota | 46061 | 3 | 0 |
261226 | 261226 | 2020-06-21 | Hanson | South Dakota | 46061 | 4 | 0 |
264354 | 264354 | 2020-06-22 | Hanson | South Dakota | 46061 | 5 | 0 |
267482 | 267482 | 2020-06-23 | Hanson | South Dakota | 46061 | 5 | 0 |
270616 | 270616 | 2020-06-24 | Hanson | South Dakota | 46061 | 5 | 0 |
273755 | 273755 | 2020-06-25 | Hanson | South Dakota | 46061 | 6 | 0 |
276902 | 276902 | 2020-06-26 | Hanson | South Dakota | 46061 | 6 | 0 |
280050 | 280050 | 2020-06-27 | Hanson | South Dakota | 46061 | 6 | 0 |
283196 | 283196 | 2020-06-28 | Hanson | South Dakota | 46061 | 6 | 0 |
286341 | 286341 | 2020-06-29 | Hanson | South Dakota | 46061 | 7 | 0 |
289492 | 289492 | 2020-06-30 | Hanson | South Dakota | 46061 | 7 | 0 |
292644 | 292644 | 2020-07-01 | Hanson | South Dakota | 46061 | 7 | 0 |
295800 | 295800 | 2020-07-02 | Hanson | South Dakota | 46061 | 8 | 0 |
298960 | 298960 | 2020-07-03 | Hanson | South Dakota | 46061 | 8 | 0 |
302124 | 302124 | 2020-07-04 | Hanson | South Dakota | 46061 | 9 | 0 |
305287 | 305287 | 2020-07-05 | Hanson | South Dakota | 46061 | 10 | 0 |
308455 | 308455 | 2020-07-06 | Hanson | South Dakota | 46061 | 10 | 0 |
311624 | 311624 | 2020-07-07 | Hanson | South Dakota | 46061 | 12 | 0 |
314797 | 314797 | 2020-07-08 | Hanson | South Dakota | 46061 | 12 | 0 |
317970 | 317970 | 2020-07-09 | Hanson | South Dakota | 46061 | 13 | 0 |
321148 | 321148 | 2020-07-10 | Hanson | South Dakota | 46061 | 13 | 0 |
324328 | 324328 | 2020-07-11 | Hanson | South Dakota | 46061 | 13 | 0 |
327513 | 327513 | 2020-07-12 | Hanson | South Dakota | 46061 | 13 | 0 |
330699 | 330699 | 2020-07-13 | Hanson | South Dakota | 46061 | 14 | 0 |
333891 | 333891 | 2020-07-14 | Hanson | South Dakota | 46061 | 14 | 0 |
337085 | 337085 | 2020-07-15 | Hanson | South Dakota | 46061 | 14 | 0 |
340282 | 340282 | 2020-07-16 | Hanson | South Dakota | 46061 | 14 | 0 |
343480 | 343480 | 2020-07-17 | Hanson | South Dakota | 46061 | 14 | 0 |
346680 | 346680 | 2020-07-18 | Hanson | South Dakota | 46061 | 14 | 0 |
349880 | 349880 | 2020-07-19 | Hanson | South Dakota | 46061 | 14 | 0 |
353083 | 353083 | 2020-07-20 | Hanson | South Dakota | 46061 | 14 | 0 |
356286 | 356286 | 2020-07-21 | Hanson | South Dakota | 46061 | 15 | 0 |
359490 | 359490 | 2020-07-22 | Hanson | South Dakota | 46061 | 15 | 0 |
362696 | 362696 | 2020-07-23 | Hanson | South Dakota | 46061 | 15 | 0 |
365902 | 365902 | 2020-07-24 | Hanson | South Dakota | 46061 | 15 | 0 |
369111 | 369111 | 2020-07-25 | Hanson | South Dakota | 46061 | 16 | 0 |
372323 | 372323 | 2020-07-26 | Hanson | South Dakota | 46061 | 16 | 0 |
375536 | 375536 | 2020-07-27 | Hanson | South Dakota | 46061 | 17 | 0 |
378752 | 378752 | 2020-07-28 | Hanson | South Dakota | 46061 | 18 | 0 |
381969 | 381969 | 2020-07-29 | Hanson | South Dakota | 46061 | 20 | 0 |
385187 | 385187 | 2020-07-30 | Hanson | South Dakota | 46061 | 20 | 0 |
388404 | 388404 | 2020-07-31 | Hanson | South Dakota | 46061 | 20 | 0 |
391621 | 391621 | 2020-08-01 | Hanson | South Dakota | 46061 | 20 | 0 |
394837 | 394837 | 2020-08-02 | Hanson | South Dakota | 46061 | 21 | 0 |
398054 | 398054 | 2020-08-03 | Hanson | South Dakota | 46061 | 21 | 0 |
401269 | 401269 | 2020-08-04 | Hanson | South Dakota | 46061 | 21 | 0 |
404487 | 404487 | 2020-08-05 | Hanson | South Dakota | 46061 | 21 | 0 |
407707 | 407707 | 2020-08-06 | Hanson | South Dakota | 46061 | 21 | 0 |
410926 | 410926 | 2020-08-07 | Hanson | South Dakota | 46061 | 21 | 0 |
414146 | 414146 | 2020-08-08 | Hanson | South Dakota | 46061 | 21 | 0 |
417367 | 417367 | 2020-08-09 | Hanson | South Dakota | 46061 | 21 | 0 |
420588 | 420588 | 2020-08-10 | Hanson | South Dakota | 46061 | 21 | 0 |
423810 | 423810 | 2020-08-11 | Hanson | South Dakota | 46061 | 21 | 0 |
427033 | 427033 | 2020-08-12 | Hanson | South Dakota | 46061 | 21 | 0 |
430259 | 430259 | 2020-08-13 | Hanson | South Dakota | 46061 | 22 | 0 |
433484 | 433484 | 2020-08-14 | Hanson | South Dakota | 46061 | 22 | 0 |
436711 | 436711 | 2020-08-15 | Hanson | South Dakota | 46061 | 22 | 0 |
439936 | 439936 | 2020-08-16 | Hanson | South Dakota | 46061 | 22 | 0 |
443163 | 443163 | 2020-08-17 | Hanson | South Dakota | 46061 | 22 | 0 |
446389 | 446389 | 2020-08-18 | Hanson | South Dakota | 46061 | 22 | 0 |
449617 | 449617 | 2020-08-19 | Hanson | South Dakota | 46061 | 22 | 0 |
452845 | 452845 | 2020-08-20 | Hanson | South Dakota | 46061 | 22 | 0 |
456073 | 456073 | 2020-08-21 | Hanson | South Dakota | 46061 | 22 | 0 |
459301 | 459301 | 2020-08-22 | Hanson | South Dakota | 46061 | 21 | 0 |
462529 | 462529 | 2020-08-23 | Hanson | South Dakota | 46061 | 21 | 0 |
465758 | 465758 | 2020-08-24 | Hanson | South Dakota | 46061 | 22 | 0 |
468986 | 468986 | 2020-08-25 | Hanson | South Dakota | 46061 | 22 | 0 |
472218 | 472218 | 2020-08-26 | Hanson | South Dakota | 46061 | 22 | 0 |
475452 | 475452 | 2020-08-27 | Hanson | South Dakota | 46061 | 23 | 0 |
478685 | 478685 | 2020-08-28 | Hanson | South Dakota | 46061 | 23 | 0 |
481919 | 481919 | 2020-08-29 | Hanson | South Dakota | 46061 | 23 | 0 |
485154 | 485154 | 2020-08-30 | Hanson | South Dakota | 46061 | 23 | 0 |
488387 | 488387 | 2020-08-31 | Hanson | South Dakota | 46061 | 23 | 0 |
491620 | 491620 | 2020-09-01 | Hanson | South Dakota | 46061 | 23 | 0 |
494854 | 494854 | 2020-09-02 | Hanson | South Dakota | 46061 | 23 | 0 |
498087 | 498087 | 2020-09-03 | Hanson | South Dakota | 46061 | 24 | 0 |
501321 | 501321 | 2020-09-04 | Hanson | South Dakota | 46061 | 24 | 0 |
504555 | 504555 | 2020-09-05 | Hanson | South Dakota | 46061 | 25 | 0 |
507787 | 507787 | 2020-09-06 | Hanson | South Dakota | 46061 | 25 | 0 |
511020 | 511020 | 2020-09-07 | Hanson | South Dakota | 46061 | 25 | 0 |
514253 | 514253 | 2020-09-08 | Hanson | South Dakota | 46061 | 25 | 0 |
517488 | 517488 | 2020-09-09 | Hanson | South Dakota | 46061 | 25 | 0 |
520724 | 520724 | 2020-09-10 | Hanson | South Dakota | 46061 | 24 | 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);