ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 2, fips = 49021 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
566439 | 566439 | 2020-09-24 | Iron | Utah | 49021 | 731 | 2 |
563198 | 563198 | 2020-09-23 | Iron | Utah | 49021 | 726 | 2 |
559959 | 559959 | 2020-09-22 | Iron | Utah | 49021 | 723 | 2 |
556723 | 556723 | 2020-09-21 | Iron | Utah | 49021 | 723 | 2 |
553486 | 553486 | 2020-09-20 | Iron | Utah | 49021 | 713 | 2 |
550247 | 550247 | 2020-09-19 | Iron | Utah | 49021 | 713 | 2 |
547008 | 547008 | 2020-09-18 | Iron | Utah | 49021 | 709 | 2 |
543771 | 543771 | 2020-09-17 | Iron | Utah | 49021 | 706 | 2 |
540535 | 540535 | 2020-09-16 | Iron | Utah | 49021 | 703 | 2 |
537298 | 537298 | 2020-09-15 | Iron | Utah | 49021 | 698 | 2 |
534062 | 534062 | 2020-09-14 | Iron | Utah | 49021 | 696 | 2 |
530827 | 530827 | 2020-09-13 | Iron | Utah | 49021 | 693 | 2 |
527590 | 527590 | 2020-09-12 | Iron | Utah | 49021 | 693 | 2 |
524354 | 524354 | 2020-09-11 | Iron | Utah | 49021 | 691 | 2 |
521118 | 521118 | 2020-09-10 | Iron | Utah | 49021 | 685 | 2 |
517881 | 517881 | 2020-09-09 | Iron | Utah | 49021 | 684 | 2 |
514646 | 514646 | 2020-09-08 | Iron | Utah | 49021 | 684 | 2 |
511413 | 511413 | 2020-09-07 | Iron | Utah | 49021 | 681 | 2 |
508180 | 508180 | 2020-09-06 | Iron | Utah | 49021 | 678 | 2 |
504948 | 504948 | 2020-09-05 | Iron | Utah | 49021 | 678 | 2 |
501714 | 501714 | 2020-09-04 | Iron | Utah | 49021 | 667 | 2 |
498480 | 498480 | 2020-09-03 | Iron | Utah | 49021 | 660 | 2 |
495247 | 495247 | 2020-09-02 | Iron | Utah | 49021 | 651 | 2 |
492013 | 492013 | 2020-09-01 | Iron | Utah | 49021 | 646 | 2 |
488780 | 488780 | 2020-08-31 | Iron | Utah | 49021 | 644 | 2 |
485547 | 485547 | 2020-08-30 | Iron | Utah | 49021 | 637 | 2 |
482312 | 482312 | 2020-08-29 | Iron | Utah | 49021 | 637 | 2 |
479078 | 479078 | 2020-08-28 | Iron | Utah | 49021 | 635 | 2 |
475845 | 475845 | 2020-08-27 | Iron | Utah | 49021 | 626 | 2 |
472612 | 472612 | 2020-08-26 | Iron | Utah | 49021 | 614 | 2 |
469380 | 469380 | 2020-08-25 | Iron | Utah | 49021 | 608 | 2 |
466151 | 466151 | 2020-08-24 | Iron | Utah | 49021 | 606 | 2 |
462922 | 462922 | 2020-08-23 | Iron | Utah | 49021 | 599 | 2 |
459693 | 459693 | 2020-08-22 | Iron | Utah | 49021 | 599 | 2 |
456466 | 456466 | 2020-08-21 | Iron | Utah | 49021 | 595 | 2 |
453238 | 453238 | 2020-08-20 | Iron | Utah | 49021 | 594 | 2 |
450010 | 450010 | 2020-08-19 | Iron | Utah | 49021 | 590 | 2 |
446782 | 446782 | 2020-08-18 | Iron | Utah | 49021 | 586 | 2 |
443555 | 443555 | 2020-08-17 | Iron | Utah | 49021 | 584 | 2 |
440329 | 440329 | 2020-08-16 | Iron | Utah | 49021 | 580 | 2 |
437103 | 437103 | 2020-08-15 | Iron | Utah | 49021 | 580 | 2 |
433877 | 433877 | 2020-08-14 | Iron | Utah | 49021 | 577 | 2 |
430652 | 430652 | 2020-08-13 | Iron | Utah | 49021 | 572 | 2 |
427424 | 427424 | 2020-08-12 | Iron | Utah | 49021 | 567 | 2 |
424200 | 424200 | 2020-08-11 | Iron | Utah | 49021 | 563 | 2 |
420979 | 420979 | 2020-08-10 | Iron | Utah | 49021 | 561 | 2 |
417758 | 417758 | 2020-08-09 | Iron | Utah | 49021 | 556 | 2 |
414537 | 414537 | 2020-08-08 | Iron | Utah | 49021 | 556 | 2 |
411317 | 411317 | 2020-08-07 | Iron | Utah | 49021 | 555 | 2 |
408098 | 408098 | 2020-08-06 | Iron | Utah | 49021 | 550 | 2 |
404878 | 404878 | 2020-08-05 | Iron | Utah | 49021 | 544 | 2 |
401660 | 401660 | 2020-08-04 | Iron | Utah | 49021 | 534 | 2 |
398444 | 398444 | 2020-08-03 | Iron | Utah | 49021 | 528 | 2 |
395228 | 395228 | 2020-08-02 | Iron | Utah | 49021 | 513 | 2 |
392012 | 392012 | 2020-08-01 | Iron | Utah | 49021 | 513 | 2 |
388795 | 388795 | 2020-07-31 | Iron | Utah | 49021 | 504 | 2 |
385578 | 385578 | 2020-07-30 | Iron | Utah | 49021 | 500 | 2 |
382360 | 382360 | 2020-07-29 | Iron | Utah | 49021 | 491 | 2 |
379143 | 379143 | 2020-07-28 | Iron | Utah | 49021 | 485 | 2 |
375927 | 375927 | 2020-07-27 | Iron | Utah | 49021 | 476 | 2 |
372714 | 372714 | 2020-07-26 | Iron | Utah | 49021 | 464 | 2 |
369502 | 369502 | 2020-07-25 | Iron | Utah | 49021 | 464 | 2 |
366293 | 366293 | 2020-07-24 | Iron | Utah | 49021 | 460 | 2 |
363087 | 363087 | 2020-07-23 | Iron | Utah | 49021 | 452 | 2 |
359880 | 359880 | 2020-07-22 | Iron | Utah | 49021 | 439 | 2 |
356675 | 356675 | 2020-07-21 | Iron | Utah | 49021 | 431 | 2 |
353472 | 353472 | 2020-07-20 | Iron | Utah | 49021 | 423 | 2 |
350270 | 350270 | 2020-07-19 | Iron | Utah | 49021 | 415 | 2 |
347070 | 347070 | 2020-07-18 | Iron | Utah | 49021 | 415 | 2 |
343869 | 343869 | 2020-07-17 | Iron | Utah | 49021 | 408 | 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);