ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
737 rows where fips = 49031 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637773 | 637773 | 2020-10-16 | Piute | Utah | 49031 | 25 | 0 |
634528 | 634528 | 2020-10-15 | Piute | Utah | 49031 | 24 | 0 |
631283 | 631283 | 2020-10-14 | Piute | Utah | 49031 | 24 | 0 |
628039 | 628039 | 2020-10-13 | Piute | Utah | 49031 | 23 | 0 |
624796 | 624796 | 2020-10-12 | Piute | Utah | 49031 | 22 | 0 |
621553 | 621553 | 2020-10-11 | Piute | Utah | 49031 | 21 | 0 |
618310 | 618310 | 2020-10-10 | Piute | Utah | 49031 | 21 | 0 |
615068 | 615068 | 2020-10-09 | Piute | Utah | 49031 | 18 | 0 |
611827 | 611827 | 2020-10-08 | Piute | Utah | 49031 | 16 | 0 |
608585 | 608585 | 2020-10-07 | Piute | Utah | 49031 | 16 | 0 |
605342 | 605342 | 2020-10-06 | Piute | Utah | 49031 | 16 | 0 |
602100 | 602100 | 2020-10-05 | Piute | Utah | 49031 | 16 | 0 |
598857 | 598857 | 2020-10-04 | Piute | Utah | 49031 | 13 | 0 |
595614 | 595614 | 2020-10-03 | Piute | Utah | 49031 | 9 | 0 |
592372 | 592372 | 2020-10-02 | Piute | Utah | 49031 | 9 | 0 |
589132 | 589132 | 2020-10-01 | Piute | Utah | 49031 | 9 | 0 |
585891 | 585891 | 2020-09-30 | Piute | Utah | 49031 | 9 | 0 |
582651 | 582651 | 2020-09-29 | Piute | Utah | 49031 | 8 | 0 |
579412 | 579412 | 2020-09-28 | Piute | Utah | 49031 | 7 | 0 |
576171 | 576171 | 2020-09-27 | Piute | Utah | 49031 | 7 | 0 |
572927 | 572927 | 2020-09-26 | Piute | Utah | 49031 | 7 | 0 |
569685 | 569685 | 2020-09-25 | Piute | Utah | 49031 | 7 | 0 |
566444 | 566444 | 2020-09-24 | Piute | Utah | 49031 | 7 | 0 |
563203 | 563203 | 2020-09-23 | Piute | Utah | 49031 | 7 | 0 |
559964 | 559964 | 2020-09-22 | Piute | Utah | 49031 | 7 | 0 |
556728 | 556728 | 2020-09-21 | Piute | Utah | 49031 | 7 | 0 |
553491 | 553491 | 2020-09-20 | Piute | Utah | 49031 | 7 | 0 |
550252 | 550252 | 2020-09-19 | Piute | Utah | 49031 | 7 | 0 |
547013 | 547013 | 2020-09-18 | Piute | Utah | 49031 | 6 | 0 |
543776 | 543776 | 2020-09-17 | Piute | Utah | 49031 | 6 | 0 |
540540 | 540540 | 2020-09-16 | Piute | Utah | 49031 | 6 | 0 |
537303 | 537303 | 2020-09-15 | Piute | Utah | 49031 | 6 | 0 |
534067 | 534067 | 2020-09-14 | Piute | Utah | 49031 | 6 | 0 |
530832 | 530832 | 2020-09-13 | Piute | Utah | 49031 | 6 | 0 |
527595 | 527595 | 2020-09-12 | Piute | Utah | 49031 | 6 | 0 |
524359 | 524359 | 2020-09-11 | Piute | Utah | 49031 | 6 | 0 |
521123 | 521123 | 2020-09-10 | Piute | Utah | 49031 | 6 | 0 |
517886 | 517886 | 2020-09-09 | Piute | Utah | 49031 | 6 | 0 |
514651 | 514651 | 2020-09-08 | Piute | Utah | 49031 | 6 | 0 |
511418 | 511418 | 2020-09-07 | Piute | Utah | 49031 | 6 | 0 |
508185 | 508185 | 2020-09-06 | Piute | Utah | 49031 | 6 | 0 |
504953 | 504953 | 2020-09-05 | Piute | Utah | 49031 | 6 | 0 |
501719 | 501719 | 2020-09-04 | Piute | Utah | 49031 | 6 | 0 |
498485 | 498485 | 2020-09-03 | Piute | Utah | 49031 | 6 | 0 |
495252 | 495252 | 2020-09-02 | Piute | Utah | 49031 | 6 | 0 |
492018 | 492018 | 2020-09-01 | Piute | Utah | 49031 | 6 | 0 |
488785 | 488785 | 2020-08-31 | Piute | Utah | 49031 | 6 | 0 |
485552 | 485552 | 2020-08-30 | Piute | Utah | 49031 | 6 | 0 |
482317 | 482317 | 2020-08-29 | Piute | Utah | 49031 | 6 | 0 |
479083 | 479083 | 2020-08-28 | Piute | Utah | 49031 | 6 | 0 |
475850 | 475850 | 2020-08-27 | Piute | Utah | 49031 | 6 | 0 |
472617 | 472617 | 2020-08-26 | Piute | Utah | 49031 | 6 | 0 |
469385 | 469385 | 2020-08-25 | Piute | Utah | 49031 | 6 | 0 |
466156 | 466156 | 2020-08-24 | Piute | Utah | 49031 | 6 | 0 |
462927 | 462927 | 2020-08-23 | Piute | Utah | 49031 | 6 | 0 |
459698 | 459698 | 2020-08-22 | Piute | Utah | 49031 | 9 | 0 |
456471 | 456471 | 2020-08-21 | Piute | Utah | 49031 | 9 | 0 |
453243 | 453243 | 2020-08-20 | Piute | Utah | 49031 | 6 | 0 |
450015 | 450015 | 2020-08-19 | Piute | Utah | 49031 | 6 | 0 |
446787 | 446787 | 2020-08-18 | Piute | Utah | 49031 | 6 | 0 |
443560 | 443560 | 2020-08-17 | Piute | Utah | 49031 | 6 | 0 |
440334 | 440334 | 2020-08-16 | Piute | Utah | 49031 | 6 | 0 |
437108 | 437108 | 2020-08-15 | Piute | Utah | 49031 | 6 | 0 |
433882 | 433882 | 2020-08-14 | Piute | Utah | 49031 | 6 | 0 |
430657 | 430657 | 2020-08-13 | Piute | Utah | 49031 | 6 | 0 |
427429 | 427429 | 2020-08-12 | Piute | Utah | 49031 | 6 | 0 |
424205 | 424205 | 2020-08-11 | Piute | Utah | 49031 | 6 | 0 |
420984 | 420984 | 2020-08-10 | Piute | Utah | 49031 | 6 | 0 |
417763 | 417763 | 2020-08-09 | Piute | Utah | 49031 | 6 | 0 |
414542 | 414542 | 2020-08-08 | Piute | Utah | 49031 | 6 | 0 |
411322 | 411322 | 2020-08-07 | Piute | Utah | 49031 | 6 | 0 |
408103 | 408103 | 2020-08-06 | Piute | Utah | 49031 | 5 | 0 |
404883 | 404883 | 2020-08-05 | Piute | Utah | 49031 | 5 | 0 |
401665 | 401665 | 2020-08-04 | Piute | Utah | 49031 | 5 | 0 |
398449 | 398449 | 2020-08-03 | Piute | Utah | 49031 | 4 | 0 |
395233 | 395233 | 2020-08-02 | Piute | Utah | 49031 | 4 | 0 |
392017 | 392017 | 2020-08-01 | Piute | Utah | 49031 | 4 | 0 |
388800 | 388800 | 2020-07-31 | Piute | Utah | 49031 | 4 | 0 |
385583 | 385583 | 2020-07-30 | Piute | Utah | 49031 | 4 | 0 |
382365 | 382365 | 2020-07-29 | Piute | Utah | 49031 | 4 | 0 |
379148 | 379148 | 2020-07-28 | Piute | Utah | 49031 | 4 | 0 |
375932 | 375932 | 2020-07-27 | Piute | Utah | 49031 | 4 | 0 |
372719 | 372719 | 2020-07-26 | Piute | Utah | 49031 | 4 | 0 |
369507 | 369507 | 2020-07-25 | Piute | Utah | 49031 | 4 | 0 |
366298 | 366298 | 2020-07-24 | Piute | Utah | 49031 | 4 | 0 |
363092 | 363092 | 2020-07-23 | Piute | Utah | 49031 | 4 | 0 |
359885 | 359885 | 2020-07-22 | Piute | Utah | 49031 | 4 | 0 |
356680 | 356680 | 2020-07-21 | Piute | Utah | 49031 | 4 | 0 |
353477 | 353477 | 2020-07-20 | Piute | Utah | 49031 | 4 | 0 |
350275 | 350275 | 2020-07-19 | Piute | Utah | 49031 | 4 | 0 |
347075 | 347075 | 2020-07-18 | Piute | Utah | 49031 | 4 | 0 |
343874 | 343874 | 2020-07-17 | Piute | Utah | 49031 | 4 | 0 |
340675 | 340675 | 2020-07-16 | Piute | Utah | 49031 | 4 | 0 |
337479 | 337479 | 2020-07-15 | Piute | Utah | 49031 | 4 | 0 |
334284 | 334284 | 2020-07-14 | Piute | Utah | 49031 | 4 | 0 |
331091 | 331091 | 2020-07-13 | Piute | Utah | 49031 | 4 | 0 |
327905 | 327905 | 2020-07-12 | Piute | Utah | 49031 | 4 | 0 |
324720 | 324720 | 2020-07-11 | Piute | Utah | 49031 | 4 | 0 |
321539 | 321539 | 2020-07-10 | Piute | Utah | 49031 | 4 | 0 |
318360 | 318360 | 2020-07-09 | Piute | Utah | 49031 | 4 | 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);