ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
701 rows where county = "Rich" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056398 | 1056398 | 2021-02-22 | Rich | Utah | 49033 | 123 | 0 |
1053152 | 1053152 | 2021-02-21 | Rich | Utah | 49033 | 123 | 0 |
1049905 | 1049905 | 2021-02-20 | Rich | Utah | 49033 | 123 | 0 |
1046658 | 1046658 | 2021-02-19 | Rich | Utah | 49033 | 123 | 0 |
1043413 | 1043413 | 2021-02-18 | Rich | Utah | 49033 | 123 | 0 |
1040168 | 1040168 | 2021-02-17 | Rich | Utah | 49033 | 123 | 0 |
1036923 | 1036923 | 2021-02-16 | Rich | Utah | 49033 | 123 | 0 |
1033678 | 1033678 | 2021-02-15 | Rich | Utah | 49033 | 122 | 0 |
1030432 | 1030432 | 2021-02-14 | Rich | Utah | 49033 | 122 | 0 |
1027185 | 1027185 | 2021-02-13 | Rich | Utah | 49033 | 122 | 0 |
1023940 | 1023940 | 2021-02-12 | Rich | Utah | 49033 | 122 | 0 |
1020695 | 1020695 | 2021-02-11 | Rich | Utah | 49033 | 120 | 0 |
1017450 | 1017450 | 2021-02-10 | Rich | Utah | 49033 | 120 | 0 |
1014205 | 1014205 | 2021-02-09 | Rich | Utah | 49033 | 119 | 0 |
1010960 | 1010960 | 2021-02-08 | Rich | Utah | 49033 | 117 | 0 |
1007714 | 1007714 | 2021-02-07 | Rich | Utah | 49033 | 117 | 0 |
1004468 | 1004468 | 2021-02-06 | Rich | Utah | 49033 | 117 | 0 |
1001222 | 1001222 | 2021-02-05 | Rich | Utah | 49033 | 117 | 0 |
997976 | 997976 | 2021-02-04 | Rich | Utah | 49033 | 117 | 0 |
994730 | 994730 | 2021-02-03 | Rich | Utah | 49033 | 117 | 0 |
991484 | 991484 | 2021-02-02 | Rich | Utah | 49033 | 114 | 0 |
988238 | 988238 | 2021-02-01 | Rich | Utah | 49033 | 114 | 0 |
984991 | 984991 | 2021-01-31 | Rich | Utah | 49033 | 114 | 0 |
981744 | 981744 | 2021-01-30 | Rich | Utah | 49033 | 114 | 0 |
978498 | 978498 | 2021-01-29 | Rich | Utah | 49033 | 111 | 0 |
975253 | 975253 | 2021-01-28 | Rich | Utah | 49033 | 111 | 0 |
972008 | 972008 | 2021-01-27 | Rich | Utah | 49033 | 111 | 0 |
968763 | 968763 | 2021-01-26 | Rich | Utah | 49033 | 110 | 0 |
965519 | 965519 | 2021-01-25 | Rich | Utah | 49033 | 98 | 0 |
962274 | 962274 | 2021-01-24 | Rich | Utah | 49033 | 95 | 0 |
959029 | 959029 | 2021-01-23 | Rich | Utah | 49033 | 95 | 0 |
955783 | 955783 | 2021-01-22 | Rich | Utah | 49033 | 90 | 0 |
952538 | 952538 | 2021-01-21 | Rich | Utah | 49033 | 90 | 0 |
949293 | 949293 | 2021-01-20 | Rich | Utah | 49033 | 90 | 0 |
946047 | 946047 | 2021-01-19 | Rich | Utah | 49033 | 90 | 0 |
942800 | 942800 | 2021-01-18 | Rich | Utah | 49033 | 90 | 0 |
939555 | 939555 | 2021-01-17 | Rich | Utah | 49033 | 90 | 0 |
936310 | 936310 | 2021-01-16 | Rich | Utah | 49033 | 87 | 0 |
933065 | 933065 | 2021-01-15 | Rich | Utah | 49033 | 86 | 0 |
929820 | 929820 | 2021-01-14 | Rich | Utah | 49033 | 85 | 0 |
926575 | 926575 | 2021-01-13 | Rich | Utah | 49033 | 82 | 0 |
923329 | 923329 | 2021-01-12 | Rich | Utah | 49033 | 82 | 0 |
920084 | 920084 | 2021-01-11 | Rich | Utah | 49033 | 82 | 0 |
916839 | 916839 | 2021-01-10 | Rich | Utah | 49033 | 82 | 0 |
913594 | 913594 | 2021-01-09 | Rich | Utah | 49033 | 82 | 0 |
910349 | 910349 | 2021-01-08 | Rich | Utah | 49033 | 80 | 0 |
907104 | 907104 | 2021-01-07 | Rich | Utah | 49033 | 75 | 0 |
903858 | 903858 | 2021-01-06 | Rich | Utah | 49033 | 70 | 0 |
900613 | 900613 | 2021-01-05 | Rich | Utah | 49033 | 69 | 0 |
897368 | 897368 | 2021-01-04 | Rich | Utah | 49033 | 69 | 0 |
894122 | 894122 | 2021-01-03 | Rich | Utah | 49033 | 69 | 0 |
890876 | 890876 | 2021-01-02 | Rich | Utah | 49033 | 69 | 0 |
887629 | 887629 | 2021-01-01 | Rich | Utah | 49033 | 67 | 0 |
884384 | 884384 | 2020-12-31 | Rich | Utah | 49033 | 67 | 0 |
881139 | 881139 | 2020-12-30 | Rich | Utah | 49033 | 66 | 0 |
877894 | 877894 | 2020-12-29 | Rich | Utah | 49033 | 66 | 0 |
874649 | 874649 | 2020-12-28 | Rich | Utah | 49033 | 63 | 0 |
871404 | 871404 | 2020-12-27 | Rich | Utah | 49033 | 63 | 0 |
868159 | 868159 | 2020-12-26 | Rich | Utah | 49033 | 63 | 0 |
864914 | 864914 | 2020-12-25 | Rich | Utah | 49033 | 63 | 0 |
861669 | 861669 | 2020-12-24 | Rich | Utah | 49033 | 63 | 0 |
858424 | 858424 | 2020-12-23 | Rich | Utah | 49033 | 63 | 0 |
855179 | 855179 | 2020-12-22 | Rich | Utah | 49033 | 59 | 0 |
851934 | 851934 | 2020-12-21 | Rich | Utah | 49033 | 59 | 0 |
848689 | 848689 | 2020-12-20 | Rich | Utah | 49033 | 59 | 0 |
845444 | 845444 | 2020-12-19 | Rich | Utah | 49033 | 58 | 0 |
842198 | 842198 | 2020-12-18 | Rich | Utah | 49033 | 58 | 0 |
838953 | 838953 | 2020-12-17 | Rich | Utah | 49033 | 57 | 0 |
835707 | 835707 | 2020-12-16 | Rich | Utah | 49033 | 57 | 0 |
832461 | 832461 | 2020-12-15 | Rich | Utah | 49033 | 57 | 0 |
829214 | 829214 | 2020-12-14 | Rich | Utah | 49033 | 55 | 0 |
825968 | 825968 | 2020-12-13 | Rich | Utah | 49033 | 55 | 0 |
822721 | 822721 | 2020-12-12 | Rich | Utah | 49033 | 53 | 0 |
819475 | 819475 | 2020-12-11 | Rich | Utah | 49033 | 53 | 0 |
816229 | 816229 | 2020-12-10 | Rich | Utah | 49033 | 53 | 0 |
812983 | 812983 | 2020-12-09 | Rich | Utah | 49033 | 49 | 0 |
809739 | 809739 | 2020-12-08 | Rich | Utah | 49033 | 49 | 0 |
806494 | 806494 | 2020-12-07 | Rich | Utah | 49033 | 49 | 0 |
803249 | 803249 | 2020-12-06 | Rich | Utah | 49033 | 49 | 0 |
800004 | 800004 | 2020-12-05 | Rich | Utah | 49033 | 46 | 0 |
796759 | 796759 | 2020-12-04 | Rich | Utah | 49033 | 45 | 0 |
793514 | 793514 | 2020-12-03 | Rich | Utah | 49033 | 45 | 0 |
790269 | 790269 | 2020-12-02 | Rich | Utah | 49033 | 45 | 0 |
787024 | 787024 | 2020-12-01 | Rich | Utah | 49033 | 46 | 0 |
783780 | 783780 | 2020-11-30 | Rich | Utah | 49033 | 44 | 0 |
780535 | 780535 | 2020-11-29 | Rich | Utah | 49033 | 44 | 0 |
777289 | 777289 | 2020-11-28 | Rich | Utah | 49033 | 44 | 0 |
774044 | 774044 | 2020-11-27 | Rich | Utah | 49033 | 44 | 0 |
770799 | 770799 | 2020-11-26 | Rich | Utah | 49033 | 44 | 0 |
767553 | 767553 | 2020-11-25 | Rich | Utah | 49033 | 44 | 0 |
764308 | 764308 | 2020-11-24 | Rich | Utah | 49033 | 44 | 0 |
761063 | 761063 | 2020-11-23 | Rich | Utah | 49033 | 40 | 0 |
757818 | 757818 | 2020-11-22 | Rich | Utah | 49033 | 39 | 0 |
754571 | 754571 | 2020-11-21 | Rich | Utah | 49033 | 39 | 0 |
751325 | 751325 | 2020-11-20 | Rich | Utah | 49033 | 39 | 0 |
748079 | 748079 | 2020-11-19 | Rich | Utah | 49033 | 37 | 0 |
744833 | 744833 | 2020-11-18 | Rich | Utah | 49033 | 36 | 0 |
741586 | 741586 | 2020-11-17 | Rich | Utah | 49033 | 32 | 0 |
738339 | 738339 | 2020-11-16 | Rich | Utah | 49033 | 32 | 0 |
735095 | 735095 | 2020-11-15 | Rich | Utah | 49033 | 31 | 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);