ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Union" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637406 | 637406 | 2020-10-16 | Union | South Dakota | 46127 | 630 | 10 |
634160 | 634160 | 2020-10-15 | Union | South Dakota | 46127 | 620 | 10 |
630915 | 630915 | 2020-10-14 | Union | South Dakota | 46127 | 599 | 10 |
627671 | 627671 | 2020-10-13 | Union | South Dakota | 46127 | 586 | 10 |
624429 | 624429 | 2020-10-12 | Union | South Dakota | 46127 | 571 | 10 |
621186 | 621186 | 2020-10-11 | Union | South Dakota | 46127 | 555 | 10 |
617943 | 617943 | 2020-10-10 | Union | South Dakota | 46127 | 539 | 10 |
614701 | 614701 | 2020-10-09 | Union | South Dakota | 46127 | 526 | 10 |
611460 | 611460 | 2020-10-08 | Union | South Dakota | 46127 | 514 | 10 |
608218 | 608218 | 2020-10-07 | Union | South Dakota | 46127 | 485 | 10 |
604975 | 604975 | 2020-10-06 | Union | South Dakota | 46127 | 462 | 9 |
601733 | 601733 | 2020-10-05 | Union | South Dakota | 46127 | 458 | 9 |
598490 | 598490 | 2020-10-04 | Union | South Dakota | 46127 | 458 | 9 |
595247 | 595247 | 2020-10-03 | Union | South Dakota | 46127 | 454 | 9 |
592006 | 592006 | 2020-10-02 | Union | South Dakota | 46127 | 444 | 8 |
588765 | 588765 | 2020-10-01 | Union | South Dakota | 46127 | 442 | 8 |
585525 | 585525 | 2020-09-30 | Union | South Dakota | 46127 | 408 | 7 |
582285 | 582285 | 2020-09-29 | Union | South Dakota | 46127 | 404 | 7 |
579045 | 579045 | 2020-09-28 | Union | South Dakota | 46127 | 402 | 7 |
575804 | 575804 | 2020-09-27 | Union | South Dakota | 46127 | 402 | 7 |
572560 | 572560 | 2020-09-26 | Union | South Dakota | 46127 | 394 | 7 |
569318 | 569318 | 2020-09-25 | Union | South Dakota | 46127 | 384 | 7 |
566077 | 566077 | 2020-09-24 | Union | South Dakota | 46127 | 375 | 7 |
562836 | 562836 | 2020-09-23 | Union | South Dakota | 46127 | 367 | 6 |
559599 | 559599 | 2020-09-22 | Union | South Dakota | 46127 | 360 | 6 |
556362 | 556362 | 2020-09-21 | Union | South Dakota | 46127 | 357 | 6 |
553125 | 553125 | 2020-09-20 | Union | South Dakota | 46127 | 351 | 6 |
549886 | 549886 | 2020-09-19 | Union | South Dakota | 46127 | 349 | 6 |
546647 | 546647 | 2020-09-18 | Union | South Dakota | 46127 | 341 | 6 |
543410 | 543410 | 2020-09-17 | Union | South Dakota | 46127 | 335 | 6 |
540174 | 540174 | 2020-09-16 | Union | South Dakota | 46127 | 329 | 5 |
536937 | 536937 | 2020-09-15 | Union | South Dakota | 46127 | 332 | 5 |
533701 | 533701 | 2020-09-14 | Union | South Dakota | 46127 | 329 | 5 |
530466 | 530466 | 2020-09-13 | Union | South Dakota | 46127 | 319 | 5 |
527229 | 527229 | 2020-09-12 | Union | South Dakota | 46127 | 318 | 5 |
523993 | 523993 | 2020-09-11 | Union | South Dakota | 46127 | 302 | 5 |
520757 | 520757 | 2020-09-10 | Union | South Dakota | 46127 | 298 | 5 |
517521 | 517521 | 2020-09-09 | Union | South Dakota | 46127 | 296 | 5 |
514286 | 514286 | 2020-09-08 | Union | South Dakota | 46127 | 295 | 5 |
511053 | 511053 | 2020-09-07 | Union | South Dakota | 46127 | 290 | 5 |
507820 | 507820 | 2020-09-06 | Union | South Dakota | 46127 | 290 | 5 |
504588 | 504588 | 2020-09-05 | Union | South Dakota | 46127 | 290 | 5 |
501354 | 501354 | 2020-09-04 | Union | South Dakota | 46127 | 288 | 5 |
498120 | 498120 | 2020-09-03 | Union | South Dakota | 46127 | 280 | 5 |
494887 | 494887 | 2020-09-02 | Union | South Dakota | 46127 | 273 | 5 |
491653 | 491653 | 2020-09-01 | Union | South Dakota | 46127 | 270 | 4 |
488420 | 488420 | 2020-08-31 | Union | South Dakota | 46127 | 265 | 4 |
485187 | 485187 | 2020-08-30 | Union | South Dakota | 46127 | 263 | 4 |
481952 | 481952 | 2020-08-29 | Union | South Dakota | 46127 | 255 | 4 |
478718 | 478718 | 2020-08-28 | Union | South Dakota | 46127 | 249 | 4 |
475485 | 475485 | 2020-08-27 | Union | South Dakota | 46127 | 244 | 4 |
472251 | 472251 | 2020-08-26 | Union | South Dakota | 46127 | 237 | 4 |
469019 | 469019 | 2020-08-25 | Union | South Dakota | 46127 | 237 | 4 |
465791 | 465791 | 2020-08-24 | Union | South Dakota | 46127 | 235 | 4 |
462562 | 462562 | 2020-08-23 | Union | South Dakota | 46127 | 232 | 4 |
459334 | 459334 | 2020-08-22 | Union | South Dakota | 46127 | 232 | 4 |
456106 | 456106 | 2020-08-21 | Union | South Dakota | 46127 | 231 | 4 |
452878 | 452878 | 2020-08-20 | Union | South Dakota | 46127 | 230 | 4 |
449650 | 449650 | 2020-08-19 | Union | South Dakota | 46127 | 224 | 4 |
446422 | 446422 | 2020-08-18 | Union | South Dakota | 46127 | 223 | 4 |
443196 | 443196 | 2020-08-17 | Union | South Dakota | 46127 | 223 | 4 |
439969 | 439969 | 2020-08-16 | Union | South Dakota | 46127 | 223 | 4 |
436744 | 436744 | 2020-08-15 | Union | South Dakota | 46127 | 223 | 4 |
433517 | 433517 | 2020-08-14 | Union | South Dakota | 46127 | 221 | 4 |
430292 | 430292 | 2020-08-13 | Union | South Dakota | 46127 | 220 | 4 |
427065 | 427065 | 2020-08-12 | Union | South Dakota | 46127 | 217 | 4 |
423842 | 423842 | 2020-08-11 | Union | South Dakota | 46127 | 216 | 4 |
420620 | 420620 | 2020-08-10 | Union | South Dakota | 46127 | 216 | 4 |
417399 | 417399 | 2020-08-09 | Union | South Dakota | 46127 | 214 | 4 |
414178 | 414178 | 2020-08-08 | Union | South Dakota | 46127 | 213 | 4 |
410958 | 410958 | 2020-08-07 | Union | South Dakota | 46127 | 209 | 4 |
407739 | 407739 | 2020-08-06 | Union | South Dakota | 46127 | 208 | 4 |
404519 | 404519 | 2020-08-05 | Union | South Dakota | 46127 | 204 | 4 |
401301 | 401301 | 2020-08-04 | Union | South Dakota | 46127 | 201 | 4 |
398086 | 398086 | 2020-08-03 | Union | South Dakota | 46127 | 199 | 4 |
394869 | 394869 | 2020-08-02 | Union | South Dakota | 46127 | 196 | 4 |
391653 | 391653 | 2020-08-01 | Union | South Dakota | 46127 | 195 | 4 |
388436 | 388436 | 2020-07-31 | Union | South Dakota | 46127 | 191 | 3 |
385219 | 385219 | 2020-07-30 | Union | South Dakota | 46127 | 187 | 3 |
382001 | 382001 | 2020-07-29 | Union | South Dakota | 46127 | 187 | 3 |
378784 | 378784 | 2020-07-28 | Union | South Dakota | 46127 | 180 | 2 |
375568 | 375568 | 2020-07-27 | Union | South Dakota | 46127 | 178 | 2 |
372355 | 372355 | 2020-07-26 | Union | South Dakota | 46127 | 175 | 2 |
369143 | 369143 | 2020-07-25 | Union | South Dakota | 46127 | 172 | 2 |
365934 | 365934 | 2020-07-24 | Union | South Dakota | 46127 | 171 | 2 |
362728 | 362728 | 2020-07-23 | Union | South Dakota | 46127 | 168 | 2 |
359521 | 359521 | 2020-07-22 | Union | South Dakota | 46127 | 166 | 2 |
356317 | 356317 | 2020-07-21 | Union | South Dakota | 46127 | 166 | 2 |
353114 | 353114 | 2020-07-20 | Union | South Dakota | 46127 | 164 | 2 |
349911 | 349911 | 2020-07-19 | Union | South Dakota | 46127 | 161 | 2 |
346711 | 346711 | 2020-07-18 | Union | South Dakota | 46127 | 159 | 2 |
343511 | 343511 | 2020-07-17 | Union | South Dakota | 46127 | 157 | 2 |
340313 | 340313 | 2020-07-16 | Union | South Dakota | 46127 | 157 | 2 |
337116 | 337116 | 2020-07-15 | Union | South Dakota | 46127 | 156 | 1 |
333922 | 333922 | 2020-07-14 | Union | South Dakota | 46127 | 156 | 1 |
330730 | 330730 | 2020-07-13 | Union | South Dakota | 46127 | 151 | 1 |
327544 | 327544 | 2020-07-12 | Union | South Dakota | 46127 | 151 | 1 |
324359 | 324359 | 2020-07-11 | Union | South Dakota | 46127 | 150 | 1 |
321178 | 321178 | 2020-07-10 | Union | South Dakota | 46127 | 148 | 1 |
318000 | 318000 | 2020-07-09 | Union | South Dakota | 46127 | 140 | 1 |
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);