ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46023 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
251840 | 251840 | 2020-06-18 | Charles Mix | South Dakota | 46023 | 41 | 0 |
254955 | 254955 | 2020-06-19 | Charles Mix | South Dakota | 46023 | 45 | 0 |
258081 | 258081 | 2020-06-20 | Charles Mix | South Dakota | 46023 | 47 | 0 |
261208 | 261208 | 2020-06-21 | Charles Mix | South Dakota | 46023 | 48 | 0 |
264336 | 264336 | 2020-06-22 | Charles Mix | South Dakota | 46023 | 49 | 0 |
267464 | 267464 | 2020-06-23 | Charles Mix | South Dakota | 46023 | 49 | 0 |
270598 | 270598 | 2020-06-24 | Charles Mix | South Dakota | 46023 | 56 | 0 |
273737 | 273737 | 2020-06-25 | Charles Mix | South Dakota | 46023 | 57 | 0 |
276884 | 276884 | 2020-06-26 | Charles Mix | South Dakota | 46023 | 58 | 0 |
280032 | 280032 | 2020-06-27 | Charles Mix | South Dakota | 46023 | 68 | 0 |
283178 | 283178 | 2020-06-28 | Charles Mix | South Dakota | 46023 | 70 | 0 |
286323 | 286323 | 2020-06-29 | Charles Mix | South Dakota | 46023 | 75 | 0 |
289474 | 289474 | 2020-06-30 | Charles Mix | South Dakota | 46023 | 82 | 0 |
292626 | 292626 | 2020-07-01 | Charles Mix | South Dakota | 46023 | 85 | 0 |
295782 | 295782 | 2020-07-02 | Charles Mix | South Dakota | 46023 | 86 | 0 |
298942 | 298942 | 2020-07-03 | Charles Mix | South Dakota | 46023 | 90 | 0 |
302106 | 302106 | 2020-07-04 | Charles Mix | South Dakota | 46023 | 91 | 0 |
305269 | 305269 | 2020-07-05 | Charles Mix | South Dakota | 46023 | 91 | 0 |
308436 | 308436 | 2020-07-06 | Charles Mix | South Dakota | 46023 | 91 | 0 |
311605 | 311605 | 2020-07-07 | Charles Mix | South Dakota | 46023 | 90 | 0 |
314778 | 314778 | 2020-07-08 | Charles Mix | South Dakota | 46023 | 95 | 0 |
317951 | 317951 | 2020-07-09 | Charles Mix | South Dakota | 46023 | 96 | 0 |
321129 | 321129 | 2020-07-10 | Charles Mix | South Dakota | 46023 | 96 | 0 |
324309 | 324309 | 2020-07-11 | Charles Mix | South Dakota | 46023 | 96 | 0 |
327494 | 327494 | 2020-07-12 | Charles Mix | South Dakota | 46023 | 96 | 0 |
330680 | 330680 | 2020-07-13 | Charles Mix | South Dakota | 46023 | 96 | 0 |
333872 | 333872 | 2020-07-14 | Charles Mix | South Dakota | 46023 | 97 | 0 |
337066 | 337066 | 2020-07-15 | Charles Mix | South Dakota | 46023 | 98 | 0 |
340263 | 340263 | 2020-07-16 | Charles Mix | South Dakota | 46023 | 98 | 0 |
343461 | 343461 | 2020-07-17 | Charles Mix | South Dakota | 46023 | 98 | 0 |
346661 | 346661 | 2020-07-18 | Charles Mix | South Dakota | 46023 | 98 | 0 |
349861 | 349861 | 2020-07-19 | Charles Mix | South Dakota | 46023 | 98 | 0 |
353064 | 353064 | 2020-07-20 | Charles Mix | South Dakota | 46023 | 98 | 0 |
356267 | 356267 | 2020-07-21 | Charles Mix | South Dakota | 46023 | 98 | 0 |
359471 | 359471 | 2020-07-22 | Charles Mix | South Dakota | 46023 | 98 | 0 |
362677 | 362677 | 2020-07-23 | Charles Mix | South Dakota | 46023 | 98 | 0 |
365883 | 365883 | 2020-07-24 | Charles Mix | South Dakota | 46023 | 99 | 0 |
369092 | 369092 | 2020-07-25 | Charles Mix | South Dakota | 46023 | 99 | 0 |
372304 | 372304 | 2020-07-26 | Charles Mix | South Dakota | 46023 | 99 | 0 |
375517 | 375517 | 2020-07-27 | Charles Mix | South Dakota | 46023 | 99 | 0 |
378733 | 378733 | 2020-07-28 | Charles Mix | South Dakota | 46023 | 99 | 0 |
381950 | 381950 | 2020-07-29 | Charles Mix | South Dakota | 46023 | 99 | 0 |
385168 | 385168 | 2020-07-30 | Charles Mix | South Dakota | 46023 | 99 | 0 |
388385 | 388385 | 2020-07-31 | Charles Mix | South Dakota | 46023 | 99 | 0 |
391602 | 391602 | 2020-08-01 | Charles Mix | South Dakota | 46023 | 99 | 0 |
394818 | 394818 | 2020-08-02 | Charles Mix | South Dakota | 46023 | 99 | 0 |
398035 | 398035 | 2020-08-03 | Charles Mix | South Dakota | 46023 | 100 | 0 |
401250 | 401250 | 2020-08-04 | Charles Mix | South Dakota | 46023 | 100 | 0 |
404468 | 404468 | 2020-08-05 | Charles Mix | South Dakota | 46023 | 100 | 0 |
407688 | 407688 | 2020-08-06 | Charles Mix | South Dakota | 46023 | 100 | 0 |
410907 | 410907 | 2020-08-07 | Charles Mix | South Dakota | 46023 | 101 | 0 |
414127 | 414127 | 2020-08-08 | Charles Mix | South Dakota | 46023 | 101 | 0 |
417348 | 417348 | 2020-08-09 | Charles Mix | South Dakota | 46023 | 105 | 0 |
420569 | 420569 | 2020-08-10 | Charles Mix | South Dakota | 46023 | 104 | 0 |
423791 | 423791 | 2020-08-11 | Charles Mix | South Dakota | 46023 | 103 | 0 |
427014 | 427014 | 2020-08-12 | Charles Mix | South Dakota | 46023 | 103 | 0 |
430240 | 430240 | 2020-08-13 | Charles Mix | South Dakota | 46023 | 103 | 0 |
433465 | 433465 | 2020-08-14 | Charles Mix | South Dakota | 46023 | 109 | 0 |
436692 | 436692 | 2020-08-15 | Charles Mix | South Dakota | 46023 | 112 | 0 |
439917 | 439917 | 2020-08-16 | Charles Mix | South Dakota | 46023 | 113 | 0 |
443144 | 443144 | 2020-08-17 | Charles Mix | South Dakota | 46023 | 113 | 0 |
446370 | 446370 | 2020-08-18 | Charles Mix | South Dakota | 46023 | 113 | 0 |
449598 | 449598 | 2020-08-19 | Charles Mix | South Dakota | 46023 | 114 | 0 |
452826 | 452826 | 2020-08-20 | Charles Mix | South Dakota | 46023 | 114 | 0 |
456054 | 456054 | 2020-08-21 | Charles Mix | South Dakota | 46023 | 116 | 0 |
459282 | 459282 | 2020-08-22 | Charles Mix | South Dakota | 46023 | 115 | 0 |
462510 | 462510 | 2020-08-23 | Charles Mix | South Dakota | 46023 | 116 | 0 |
465739 | 465739 | 2020-08-24 | Charles Mix | South Dakota | 46023 | 116 | 0 |
468967 | 468967 | 2020-08-25 | Charles Mix | South Dakota | 46023 | 116 | 0 |
472199 | 472199 | 2020-08-26 | Charles Mix | South Dakota | 46023 | 116 | 0 |
475433 | 475433 | 2020-08-27 | Charles Mix | South Dakota | 46023 | 117 | 0 |
478666 | 478666 | 2020-08-28 | Charles Mix | South Dakota | 46023 | 119 | 0 |
481900 | 481900 | 2020-08-29 | Charles Mix | South Dakota | 46023 | 122 | 0 |
485135 | 485135 | 2020-08-30 | Charles Mix | South Dakota | 46023 | 122 | 0 |
488368 | 488368 | 2020-08-31 | Charles Mix | South Dakota | 46023 | 122 | 0 |
491601 | 491601 | 2020-09-01 | Charles Mix | South Dakota | 46023 | 122 | 0 |
494835 | 494835 | 2020-09-02 | Charles Mix | South Dakota | 46023 | 122 | 0 |
498068 | 498068 | 2020-09-03 | Charles Mix | South Dakota | 46023 | 122 | 0 |
501302 | 501302 | 2020-09-04 | Charles Mix | South Dakota | 46023 | 122 | 0 |
504536 | 504536 | 2020-09-05 | Charles Mix | South Dakota | 46023 | 124 | 0 |
507768 | 507768 | 2020-09-06 | Charles Mix | South Dakota | 46023 | 124 | 0 |
511001 | 511001 | 2020-09-07 | Charles Mix | South Dakota | 46023 | 125 | 0 |
514234 | 514234 | 2020-09-08 | Charles Mix | South Dakota | 46023 | 125 | 0 |
517469 | 517469 | 2020-09-09 | Charles Mix | South Dakota | 46023 | 127 | 0 |
520705 | 520705 | 2020-09-10 | Charles Mix | South Dakota | 46023 | 128 | 0 |
523941 | 523941 | 2020-09-11 | Charles Mix | South Dakota | 46023 | 128 | 0 |
527177 | 527177 | 2020-09-12 | Charles Mix | South Dakota | 46023 | 128 | 0 |
530414 | 530414 | 2020-09-13 | Charles Mix | South Dakota | 46023 | 129 | 0 |
533649 | 533649 | 2020-09-14 | Charles Mix | South Dakota | 46023 | 129 | 0 |
536885 | 536885 | 2020-09-15 | Charles Mix | South Dakota | 46023 | 129 | 0 |
540122 | 540122 | 2020-09-16 | Charles Mix | South Dakota | 46023 | 134 | 0 |
543358 | 543358 | 2020-09-17 | Charles Mix | South Dakota | 46023 | 135 | 0 |
546595 | 546595 | 2020-09-18 | Charles Mix | South Dakota | 46023 | 136 | 0 |
549834 | 549834 | 2020-09-19 | Charles Mix | South Dakota | 46023 | 139 | 0 |
553073 | 553073 | 2020-09-20 | Charles Mix | South Dakota | 46023 | 140 | 0 |
556310 | 556310 | 2020-09-21 | Charles Mix | South Dakota | 46023 | 143 | 0 |
559547 | 559547 | 2020-09-22 | Charles Mix | South Dakota | 46023 | 150 | 0 |
562784 | 562784 | 2020-09-23 | Charles Mix | South Dakota | 46023 | 156 | 0 |
566025 | 566025 | 2020-09-24 | Charles Mix | South Dakota | 46023 | 159 | 0 |
569266 | 569266 | 2020-09-25 | Charles Mix | South Dakota | 46023 | 160 | 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);