ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Iron" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056392 | 1056392 | 2021-02-22 | Iron | Utah | 49021 | 4924 | 30 |
1053146 | 1053146 | 2021-02-21 | Iron | Utah | 49021 | 4882 | 29 |
1049899 | 1049899 | 2021-02-20 | Iron | Utah | 49021 | 4882 | 29 |
1046652 | 1046652 | 2021-02-19 | Iron | Utah | 49021 | 4882 | 29 |
1043407 | 1043407 | 2021-02-18 | Iron | Utah | 49021 | 4856 | 28 |
1040162 | 1040162 | 2021-02-17 | Iron | Utah | 49021 | 4838 | 28 |
1036917 | 1036917 | 2021-02-16 | Iron | Utah | 49021 | 4816 | 28 |
1033672 | 1033672 | 2021-02-15 | Iron | Utah | 49021 | 4787 | 27 |
1030426 | 1030426 | 2021-02-14 | Iron | Utah | 49021 | 4787 | 27 |
1027179 | 1027179 | 2021-02-13 | Iron | Utah | 49021 | 4787 | 27 |
1023934 | 1023934 | 2021-02-12 | Iron | Utah | 49021 | 4787 | 27 |
1020689 | 1020689 | 2021-02-11 | Iron | Utah | 49021 | 4750 | 26 |
1017444 | 1017444 | 2021-02-10 | Iron | Utah | 49021 | 4750 | 26 |
1014199 | 1014199 | 2021-02-09 | Iron | Utah | 49021 | 4721 | 26 |
1010954 | 1010954 | 2021-02-08 | Iron | Utah | 49021 | 4713 | 25 |
1007708 | 1007708 | 2021-02-07 | Iron | Utah | 49021 | 4654 | 25 |
1004462 | 1004462 | 2021-02-06 | Iron | Utah | 49021 | 4654 | 25 |
1001216 | 1001216 | 2021-02-05 | Iron | Utah | 49021 | 4654 | 25 |
997970 | 997970 | 2021-02-04 | Iron | Utah | 49021 | 4611 | 25 |
994724 | 994724 | 2021-02-03 | Iron | Utah | 49021 | 4611 | 25 |
991478 | 991478 | 2021-02-02 | Iron | Utah | 49021 | 4581 | 25 |
988232 | 988232 | 2021-02-01 | Iron | Utah | 49021 | 4570 | 25 |
984985 | 984985 | 2021-01-31 | Iron | Utah | 49021 | 4551 | 24 |
981738 | 981738 | 2021-01-30 | Iron | Utah | 49021 | 4551 | 24 |
978492 | 978492 | 2021-01-29 | Iron | Utah | 49021 | 4512 | 24 |
975247 | 975247 | 2021-01-28 | Iron | Utah | 49021 | 4473 | 23 |
972002 | 972002 | 2021-01-27 | Iron | Utah | 49021 | 4426 | 23 |
968757 | 968757 | 2021-01-26 | Iron | Utah | 49021 | 4379 | 23 |
965513 | 965513 | 2021-01-25 | Iron | Utah | 49021 | 4344 | 22 |
962268 | 962268 | 2021-01-24 | Iron | Utah | 49021 | 4300 | 22 |
959023 | 959023 | 2021-01-23 | Iron | Utah | 49021 | 4300 | 22 |
955777 | 955777 | 2021-01-22 | Iron | Utah | 49021 | 4230 | 20 |
952532 | 952532 | 2021-01-21 | Iron | Utah | 49021 | 4230 | 20 |
949287 | 949287 | 2021-01-20 | Iron | Utah | 49021 | 4195 | 20 |
946041 | 946041 | 2021-01-19 | Iron | Utah | 49021 | 4037 | 19 |
942794 | 942794 | 2021-01-18 | Iron | Utah | 49021 | 4037 | 19 |
939549 | 939549 | 2021-01-17 | Iron | Utah | 49021 | 4037 | 19 |
936304 | 936304 | 2021-01-16 | Iron | Utah | 49021 | 4037 | 19 |
933059 | 933059 | 2021-01-15 | Iron | Utah | 49021 | 3988 | 19 |
929814 | 929814 | 2021-01-14 | Iron | Utah | 49021 | 3946 | 19 |
926569 | 926569 | 2021-01-13 | Iron | Utah | 49021 | 3750 | 16 |
923323 | 923323 | 2021-01-12 | Iron | Utah | 49021 | 3750 | 16 |
920078 | 920078 | 2021-01-11 | Iron | Utah | 49021 | 3750 | 16 |
916833 | 916833 | 2021-01-10 | Iron | Utah | 49021 | 3613 | 16 |
913588 | 913588 | 2021-01-09 | Iron | Utah | 49021 | 3613 | 16 |
910343 | 910343 | 2021-01-08 | Iron | Utah | 49021 | 3554 | 16 |
907098 | 907098 | 2021-01-07 | Iron | Utah | 49021 | 3486 | 16 |
903852 | 903852 | 2021-01-06 | Iron | Utah | 49021 | 3385 | 15 |
900607 | 900607 | 2021-01-05 | Iron | Utah | 49021 | 3341 | 15 |
897362 | 897362 | 2021-01-04 | Iron | Utah | 49021 | 3272 | 15 |
894116 | 894116 | 2021-01-03 | Iron | Utah | 49021 | 3242 | 15 |
890870 | 890870 | 2021-01-02 | Iron | Utah | 49021 | 3242 | 15 |
887623 | 887623 | 2021-01-01 | Iron | Utah | 49021 | 3208 | 15 |
884378 | 884378 | 2020-12-31 | Iron | Utah | 49021 | 3208 | 15 |
881133 | 881133 | 2020-12-30 | Iron | Utah | 49021 | 3167 | 15 |
877888 | 877888 | 2020-12-29 | Iron | Utah | 49021 | 3113 | 15 |
874643 | 874643 | 2020-12-28 | Iron | Utah | 49021 | 3062 | 15 |
871398 | 871398 | 2020-12-27 | Iron | Utah | 49021 | 3001 | 15 |
868153 | 868153 | 2020-12-26 | Iron | Utah | 49021 | 3001 | 15 |
864908 | 864908 | 2020-12-25 | Iron | Utah | 49021 | 2964 | 15 |
861663 | 861663 | 2020-12-24 | Iron | Utah | 49021 | 2964 | 15 |
858418 | 858418 | 2020-12-23 | Iron | Utah | 49021 | 2948 | 15 |
855173 | 855173 | 2020-12-22 | Iron | Utah | 49021 | 2912 | 15 |
851928 | 851928 | 2020-12-21 | Iron | Utah | 49021 | 2875 | 15 |
848683 | 848683 | 2020-12-20 | Iron | Utah | 49021 | 2833 | 14 |
845438 | 845438 | 2020-12-19 | Iron | Utah | 49021 | 2833 | 14 |
842192 | 842192 | 2020-12-18 | Iron | Utah | 49021 | 2774 | 14 |
838947 | 838947 | 2020-12-17 | Iron | Utah | 49021 | 2737 | 14 |
835701 | 835701 | 2020-12-16 | Iron | Utah | 49021 | 2684 | 13 |
832455 | 832455 | 2020-12-15 | Iron | Utah | 49021 | 2626 | 12 |
829208 | 829208 | 2020-12-14 | Iron | Utah | 49021 | 2566 | 12 |
825962 | 825962 | 2020-12-13 | Iron | Utah | 49021 | 2514 | 10 |
822715 | 822715 | 2020-12-12 | Iron | Utah | 49021 | 2514 | 10 |
819469 | 819469 | 2020-12-11 | Iron | Utah | 49021 | 2441 | 10 |
816223 | 816223 | 2020-12-10 | Iron | Utah | 49021 | 2416 | 10 |
812977 | 812977 | 2020-12-09 | Iron | Utah | 49021 | 2367 | 8 |
809733 | 809733 | 2020-12-08 | Iron | Utah | 49021 | 2308 | 6 |
806488 | 806488 | 2020-12-07 | Iron | Utah | 49021 | 2260 | 6 |
803243 | 803243 | 2020-12-06 | Iron | Utah | 49021 | 2152 | 6 |
799998 | 799998 | 2020-12-05 | Iron | Utah | 49021 | 2152 | 6 |
796753 | 796753 | 2020-12-04 | Iron | Utah | 49021 | 2082 | 6 |
793508 | 793508 | 2020-12-03 | Iron | Utah | 49021 | 2029 | 6 |
790263 | 790263 | 2020-12-02 | Iron | Utah | 49021 | 1975 | 6 |
787018 | 787018 | 2020-12-01 | Iron | Utah | 49021 | 1895 | 6 |
783774 | 783774 | 2020-11-30 | Iron | Utah | 49021 | 1836 | 6 |
780529 | 780529 | 2020-11-29 | Iron | Utah | 49021 | 1763 | 6 |
777283 | 777283 | 2020-11-28 | Iron | Utah | 49021 | 1763 | 6 |
774038 | 774038 | 2020-11-27 | Iron | Utah | 49021 | 1681 | 6 |
770793 | 770793 | 2020-11-26 | Iron | Utah | 49021 | 1681 | 6 |
767547 | 767547 | 2020-11-25 | Iron | Utah | 49021 | 1681 | 6 |
764302 | 764302 | 2020-11-24 | Iron | Utah | 49021 | 1654 | 6 |
761057 | 761057 | 2020-11-23 | Iron | Utah | 49021 | 1592 | 4 |
757812 | 757812 | 2020-11-22 | Iron | Utah | 49021 | 1533 | 4 |
754565 | 754565 | 2020-11-21 | Iron | Utah | 49021 | 1533 | 4 |
751319 | 751319 | 2020-11-20 | Iron | Utah | 49021 | 1475 | 4 |
748073 | 748073 | 2020-11-19 | Iron | Utah | 49021 | 1430 | 4 |
744827 | 744827 | 2020-11-18 | Iron | Utah | 49021 | 1387 | 4 |
741580 | 741580 | 2020-11-17 | Iron | Utah | 49021 | 1313 | 4 |
738333 | 738333 | 2020-11-16 | Iron | Utah | 49021 | 1286 | 4 |
735089 | 735089 | 2020-11-15 | Iron | Utah | 49021 | 1245 | 4 |
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);