ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 49005 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637760 | 637760 | 2020-10-16 | Cache | Utah | 49005 | 3560 | 8 |
634515 | 634515 | 2020-10-15 | Cache | Utah | 49005 | 3509 | 8 |
631270 | 631270 | 2020-10-14 | Cache | Utah | 49005 | 3459 | 8 |
628026 | 628026 | 2020-10-13 | Cache | Utah | 49005 | 3376 | 7 |
624783 | 624783 | 2020-10-12 | Cache | Utah | 49005 | 3343 | 7 |
621540 | 621540 | 2020-10-11 | Cache | Utah | 49005 | 3288 | 7 |
618297 | 618297 | 2020-10-10 | Cache | Utah | 49005 | 3255 | 6 |
615055 | 615055 | 2020-10-09 | Cache | Utah | 49005 | 3202 | 6 |
611814 | 611814 | 2020-10-08 | Cache | Utah | 49005 | 3170 | 6 |
608572 | 608572 | 2020-10-07 | Cache | Utah | 49005 | 3122 | 6 |
605329 | 605329 | 2020-10-06 | Cache | Utah | 49005 | 3053 | 6 |
602087 | 602087 | 2020-10-05 | Cache | Utah | 49005 | 3025 | 6 |
598844 | 598844 | 2020-10-04 | Cache | Utah | 49005 | 2992 | 6 |
595601 | 595601 | 2020-10-03 | Cache | Utah | 49005 | 2929 | 6 |
592359 | 592359 | 2020-10-02 | Cache | Utah | 49005 | 2895 | 6 |
589119 | 589119 | 2020-10-01 | Cache | Utah | 49005 | 2854 | 6 |
585878 | 585878 | 2020-09-30 | Cache | Utah | 49005 | 2803 | 6 |
582638 | 582638 | 2020-09-29 | Cache | Utah | 49005 | 2785 | 6 |
579399 | 579399 | 2020-09-28 | Cache | Utah | 49005 | 2762 | 6 |
576158 | 576158 | 2020-09-27 | Cache | Utah | 49005 | 2736 | 6 |
572914 | 572914 | 2020-09-26 | Cache | Utah | 49005 | 2728 | 6 |
569672 | 569672 | 2020-09-25 | Cache | Utah | 49005 | 2695 | 6 |
566431 | 566431 | 2020-09-24 | Cache | Utah | 49005 | 2659 | 6 |
563190 | 563190 | 2020-09-23 | Cache | Utah | 49005 | 2635 | 6 |
559951 | 559951 | 2020-09-22 | Cache | Utah | 49005 | 2598 | 6 |
556715 | 556715 | 2020-09-21 | Cache | Utah | 49005 | 2573 | 6 |
553478 | 553478 | 2020-09-20 | Cache | Utah | 49005 | 2557 | 6 |
550239 | 550239 | 2020-09-19 | Cache | Utah | 49005 | 2536 | 6 |
547000 | 547000 | 2020-09-18 | Cache | Utah | 49005 | 2501 | 6 |
543763 | 543763 | 2020-09-17 | Cache | Utah | 49005 | 2442 | 6 |
540527 | 540527 | 2020-09-16 | Cache | Utah | 49005 | 2422 | 6 |
537290 | 537290 | 2020-09-15 | Cache | Utah | 49005 | 2389 | 6 |
534054 | 534054 | 2020-09-14 | Cache | Utah | 49005 | 2365 | 6 |
530819 | 530819 | 2020-09-13 | Cache | Utah | 49005 | 2346 | 6 |
527582 | 527582 | 2020-09-12 | Cache | Utah | 49005 | 2321 | 6 |
524346 | 524346 | 2020-09-11 | Cache | Utah | 49005 | 2301 | 6 |
521110 | 521110 | 2020-09-10 | Cache | Utah | 49005 | 2260 | 6 |
517874 | 517874 | 2020-09-09 | Cache | Utah | 49005 | 2232 | 6 |
514639 | 514639 | 2020-09-08 | Cache | Utah | 49005 | 2225 | 6 |
511406 | 511406 | 2020-09-07 | Cache | Utah | 49005 | 2217 | 6 |
508173 | 508173 | 2020-09-06 | Cache | Utah | 49005 | 2202 | 6 |
504941 | 504941 | 2020-09-05 | Cache | Utah | 49005 | 2194 | 6 |
501707 | 501707 | 2020-09-04 | Cache | Utah | 49005 | 2184 | 6 |
498473 | 498473 | 2020-09-03 | Cache | Utah | 49005 | 2182 | 6 |
495240 | 495240 | 2020-09-02 | Cache | Utah | 49005 | 2143 | 6 |
492006 | 492006 | 2020-09-01 | Cache | Utah | 49005 | 2119 | 6 |
488773 | 488773 | 2020-08-31 | Cache | Utah | 49005 | 2114 | 6 |
485540 | 485540 | 2020-08-30 | Cache | Utah | 49005 | 2109 | 6 |
482305 | 482305 | 2020-08-29 | Cache | Utah | 49005 | 2097 | 6 |
479071 | 479071 | 2020-08-28 | Cache | Utah | 49005 | 2088 | 6 |
475838 | 475838 | 2020-08-27 | Cache | Utah | 49005 | 2078 | 6 |
472605 | 472605 | 2020-08-26 | Cache | Utah | 49005 | 2068 | 6 |
469373 | 469373 | 2020-08-25 | Cache | Utah | 49005 | 2054 | 6 |
466144 | 466144 | 2020-08-24 | Cache | Utah | 49005 | 2046 | 6 |
462915 | 462915 | 2020-08-23 | Cache | Utah | 49005 | 2044 | 6 |
459686 | 459686 | 2020-08-22 | Cache | Utah | 49005 | 2044 | 6 |
456459 | 456459 | 2020-08-21 | Cache | Utah | 49005 | 2017 | 6 |
453231 | 453231 | 2020-08-20 | Cache | Utah | 49005 | 2005 | 6 |
450003 | 450003 | 2020-08-19 | Cache | Utah | 49005 | 1993 | 6 |
446775 | 446775 | 2020-08-18 | Cache | Utah | 49005 | 1982 | 5 |
443548 | 443548 | 2020-08-17 | Cache | Utah | 49005 | 1974 | 5 |
440322 | 440322 | 2020-08-16 | Cache | Utah | 49005 | 1973 | 5 |
437096 | 437096 | 2020-08-15 | Cache | Utah | 49005 | 1971 | 5 |
433870 | 433870 | 2020-08-14 | Cache | Utah | 49005 | 1965 | 5 |
430645 | 430645 | 2020-08-13 | Cache | Utah | 49005 | 1960 | 5 |
427417 | 427417 | 2020-08-12 | Cache | Utah | 49005 | 1950 | 5 |
424193 | 424193 | 2020-08-11 | Cache | Utah | 49005 | 1943 | 5 |
420972 | 420972 | 2020-08-10 | Cache | Utah | 49005 | 1937 | 5 |
417751 | 417751 | 2020-08-09 | Cache | Utah | 49005 | 1926 | 5 |
414530 | 414530 | 2020-08-08 | Cache | Utah | 49005 | 1911 | 4 |
411310 | 411310 | 2020-08-07 | Cache | Utah | 49005 | 1908 | 4 |
408091 | 408091 | 2020-08-06 | Cache | Utah | 49005 | 1886 | 4 |
404871 | 404871 | 2020-08-05 | Cache | Utah | 49005 | 1872 | 4 |
401653 | 401653 | 2020-08-04 | Cache | Utah | 49005 | 1857 | 4 |
398437 | 398437 | 2020-08-03 | Cache | Utah | 49005 | 1833 | 4 |
395221 | 395221 | 2020-08-02 | Cache | Utah | 49005 | 1828 | 4 |
392005 | 392005 | 2020-08-01 | Cache | Utah | 49005 | 1809 | 4 |
388788 | 388788 | 2020-07-31 | Cache | Utah | 49005 | 1805 | 4 |
385571 | 385571 | 2020-07-30 | Cache | Utah | 49005 | 1798 | 3 |
382353 | 382353 | 2020-07-29 | Cache | Utah | 49005 | 1790 | 3 |
379136 | 379136 | 2020-07-28 | Cache | Utah | 49005 | 1770 | 3 |
375920 | 375920 | 2020-07-27 | Cache | Utah | 49005 | 1764 | 3 |
372707 | 372707 | 2020-07-26 | Cache | Utah | 49005 | 1758 | 3 |
369495 | 369495 | 2020-07-25 | Cache | Utah | 49005 | 1751 | 3 |
366286 | 366286 | 2020-07-24 | Cache | Utah | 49005 | 1736 | 3 |
363080 | 363080 | 2020-07-23 | Cache | Utah | 49005 | 1706 | 3 |
359873 | 359873 | 2020-07-22 | Cache | Utah | 49005 | 1685 | 3 |
356668 | 356668 | 2020-07-21 | Cache | Utah | 49005 | 1663 | 3 |
353465 | 353465 | 2020-07-20 | Cache | Utah | 49005 | 1657 | 3 |
350263 | 350263 | 2020-07-19 | Cache | Utah | 49005 | 1654 | 3 |
347063 | 347063 | 2020-07-18 | Cache | Utah | 49005 | 1632 | 3 |
343862 | 343862 | 2020-07-17 | Cache | Utah | 49005 | 1620 | 3 |
340663 | 340663 | 2020-07-16 | Cache | Utah | 49005 | 1681 | 3 |
337467 | 337467 | 2020-07-15 | Cache | Utah | 49005 | 1658 | 3 |
334272 | 334272 | 2020-07-14 | Cache | Utah | 49005 | 1656 | 3 |
331079 | 331079 | 2020-07-13 | Cache | Utah | 49005 | 1650 | 2 |
327893 | 327893 | 2020-07-12 | Cache | Utah | 49005 | 1640 | 2 |
324708 | 324708 | 2020-07-11 | Cache | Utah | 49005 | 1620 | 2 |
321527 | 321527 | 2020-07-10 | Cache | Utah | 49005 | 1605 | 2 |
318348 | 318348 | 2020-07-09 | Cache | Utah | 49005 | 1582 | 2 |
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);