ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 49043 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056403 | 1056403 | 2021-02-22 | Summit | Utah | 49043 | 4912 | 8 |
1053157 | 1053157 | 2021-02-21 | Summit | Utah | 49043 | 4909 | 8 |
1049910 | 1049910 | 2021-02-20 | Summit | Utah | 49043 | 4904 | 8 |
1046663 | 1046663 | 2021-02-19 | Summit | Utah | 49043 | 4899 | 8 |
1043418 | 1043418 | 2021-02-18 | Summit | Utah | 49043 | 4888 | 8 |
1040173 | 1040173 | 2021-02-17 | Summit | Utah | 49043 | 4870 | 8 |
1036928 | 1036928 | 2021-02-16 | Summit | Utah | 49043 | 4861 | 8 |
1033683 | 1033683 | 2021-02-15 | Summit | Utah | 49043 | 4855 | 8 |
1030437 | 1030437 | 2021-02-14 | Summit | Utah | 49043 | 4842 | 8 |
1027190 | 1027190 | 2021-02-13 | Summit | Utah | 49043 | 4828 | 8 |
1023945 | 1023945 | 2021-02-12 | Summit | Utah | 49043 | 4806 | 8 |
1020700 | 1020700 | 2021-02-11 | Summit | Utah | 49043 | 4780 | 8 |
1017455 | 1017455 | 2021-02-10 | Summit | Utah | 49043 | 4755 | 8 |
1014210 | 1014210 | 2021-02-09 | Summit | Utah | 49043 | 4743 | 7 |
1010965 | 1010965 | 2021-02-08 | Summit | Utah | 49043 | 4726 | 7 |
1007719 | 1007719 | 2021-02-07 | Summit | Utah | 49043 | 4717 | 7 |
1004473 | 1004473 | 2021-02-06 | Summit | Utah | 49043 | 4707 | 7 |
1001227 | 1001227 | 2021-02-05 | Summit | Utah | 49043 | 4682 | 7 |
997981 | 997981 | 2021-02-04 | Summit | Utah | 49043 | 4671 | 7 |
994735 | 994735 | 2021-02-03 | Summit | Utah | 49043 | 4647 | 7 |
991489 | 991489 | 2021-02-02 | Summit | Utah | 49043 | 4622 | 7 |
988243 | 988243 | 2021-02-01 | Summit | Utah | 49043 | 4604 | 7 |
984996 | 984996 | 2021-01-31 | Summit | Utah | 49043 | 4600 | 7 |
981749 | 981749 | 2021-01-30 | Summit | Utah | 49043 | 4573 | 7 |
978503 | 978503 | 2021-01-29 | Summit | Utah | 49043 | 4546 | 7 |
975258 | 975258 | 2021-01-28 | Summit | Utah | 49043 | 4521 | 6 |
972013 | 972013 | 2021-01-27 | Summit | Utah | 49043 | 4499 | 6 |
968768 | 968768 | 2021-01-26 | Summit | Utah | 49043 | 4460 | 6 |
965524 | 965524 | 2021-01-25 | Summit | Utah | 49043 | 4438 | 6 |
962279 | 962279 | 2021-01-24 | Summit | Utah | 49043 | 4411 | 6 |
959034 | 959034 | 2021-01-23 | Summit | Utah | 49043 | 4375 | 6 |
955788 | 955788 | 2021-01-22 | Summit | Utah | 49043 | 4326 | 6 |
952543 | 952543 | 2021-01-21 | Summit | Utah | 49043 | 4280 | 6 |
949298 | 949298 | 2021-01-20 | Summit | Utah | 49043 | 4249 | 6 |
946052 | 946052 | 2021-01-19 | Summit | Utah | 49043 | 4196 | 6 |
942805 | 942805 | 2021-01-18 | Summit | Utah | 49043 | 4163 | 6 |
939560 | 939560 | 2021-01-17 | Summit | Utah | 49043 | 4146 | 6 |
936315 | 936315 | 2021-01-16 | Summit | Utah | 49043 | 4110 | 6 |
933070 | 933070 | 2021-01-15 | Summit | Utah | 49043 | 4060 | 6 |
929825 | 929825 | 2021-01-14 | Summit | Utah | 49043 | 4006 | 6 |
926580 | 926580 | 2021-01-13 | Summit | Utah | 49043 | 3951 | 6 |
923334 | 923334 | 2021-01-12 | Summit | Utah | 49043 | 3855 | 6 |
920089 | 920089 | 2021-01-11 | Summit | Utah | 49043 | 3817 | 6 |
916844 | 916844 | 2021-01-10 | Summit | Utah | 49043 | 3749 | 6 |
913599 | 913599 | 2021-01-09 | Summit | Utah | 49043 | 3692 | 6 |
910354 | 910354 | 2021-01-08 | Summit | Utah | 49043 | 3633 | 6 |
907109 | 907109 | 2021-01-07 | Summit | Utah | 49043 | 3569 | 6 |
903863 | 903863 | 2021-01-06 | Summit | Utah | 49043 | 3489 | 6 |
900618 | 900618 | 2021-01-05 | Summit | Utah | 49043 | 3423 | 5 |
897373 | 897373 | 2021-01-04 | Summit | Utah | 49043 | 3364 | 5 |
894127 | 894127 | 2021-01-03 | Summit | Utah | 49043 | 3320 | 5 |
890881 | 890881 | 2021-01-02 | Summit | Utah | 49043 | 3309 | 5 |
887634 | 887634 | 2021-01-01 | Summit | Utah | 49043 | 3214 | 5 |
884389 | 884389 | 2020-12-31 | Summit | Utah | 49043 | 3214 | 5 |
881144 | 881144 | 2020-12-30 | Summit | Utah | 49043 | 3149 | 5 |
877899 | 877899 | 2020-12-29 | Summit | Utah | 49043 | 3105 | 5 |
874654 | 874654 | 2020-12-28 | Summit | Utah | 49043 | 3074 | 5 |
871409 | 871409 | 2020-12-27 | Summit | Utah | 49043 | 3044 | 5 |
868164 | 868164 | 2020-12-26 | Summit | Utah | 49043 | 3029 | 5 |
864919 | 864919 | 2020-12-25 | Summit | Utah | 49043 | 2959 | 5 |
861674 | 861674 | 2020-12-24 | Summit | Utah | 49043 | 2959 | 5 |
858429 | 858429 | 2020-12-23 | Summit | Utah | 49043 | 2924 | 5 |
855184 | 855184 | 2020-12-22 | Summit | Utah | 49043 | 2890 | 5 |
851939 | 851939 | 2020-12-21 | Summit | Utah | 49043 | 2859 | 5 |
848694 | 848694 | 2020-12-20 | Summit | Utah | 49043 | 2835 | 5 |
845449 | 845449 | 2020-12-19 | Summit | Utah | 49043 | 2804 | 5 |
842203 | 842203 | 2020-12-18 | Summit | Utah | 49043 | 2760 | 5 |
838958 | 838958 | 2020-12-17 | Summit | Utah | 49043 | 2732 | 5 |
835712 | 835712 | 2020-12-16 | Summit | Utah | 49043 | 2695 | 5 |
832466 | 832466 | 2020-12-15 | Summit | Utah | 49043 | 2643 | 5 |
829219 | 829219 | 2020-12-14 | Summit | Utah | 49043 | 2626 | 5 |
825973 | 825973 | 2020-12-13 | Summit | Utah | 49043 | 2606 | 5 |
822726 | 822726 | 2020-12-12 | Summit | Utah | 49043 | 2585 | 5 |
819480 | 819480 | 2020-12-11 | Summit | Utah | 49043 | 2563 | 5 |
816234 | 816234 | 2020-12-10 | Summit | Utah | 49043 | 2540 | 5 |
812988 | 812988 | 2020-12-09 | Summit | Utah | 49043 | 2514 | 5 |
809744 | 809744 | 2020-12-08 | Summit | Utah | 49043 | 2485 | 5 |
806499 | 806499 | 2020-12-07 | Summit | Utah | 49043 | 2466 | 5 |
803254 | 803254 | 2020-12-06 | Summit | Utah | 49043 | 2444 | 5 |
800009 | 800009 | 2020-12-05 | Summit | Utah | 49043 | 2406 | 5 |
796764 | 796764 | 2020-12-04 | Summit | Utah | 49043 | 2381 | 5 |
793519 | 793519 | 2020-12-03 | Summit | Utah | 49043 | 2331 | 5 |
790274 | 790274 | 2020-12-02 | Summit | Utah | 49043 | 2290 | 5 |
787029 | 787029 | 2020-12-01 | Summit | Utah | 49043 | 2271 | 5 |
783785 | 783785 | 2020-11-30 | Summit | Utah | 49043 | 2245 | 5 |
780540 | 780540 | 2020-11-29 | Summit | Utah | 49043 | 2217 | 5 |
777294 | 777294 | 2020-11-28 | Summit | Utah | 49043 | 2207 | 5 |
774049 | 774049 | 2020-11-27 | Summit | Utah | 49043 | 2183 | 5 |
770804 | 770804 | 2020-11-26 | Summit | Utah | 49043 | 2145 | 4 |
767558 | 767558 | 2020-11-25 | Summit | Utah | 49043 | 2145 | 4 |
764313 | 764313 | 2020-11-24 | Summit | Utah | 49043 | 2123 | 3 |
761068 | 761068 | 2020-11-23 | Summit | Utah | 49043 | 2107 | 3 |
757823 | 757823 | 2020-11-22 | Summit | Utah | 49043 | 2076 | 3 |
754576 | 754576 | 2020-11-21 | Summit | Utah | 49043 | 2056 | 3 |
751330 | 751330 | 2020-11-20 | Summit | Utah | 49043 | 2018 | 3 |
748084 | 748084 | 2020-11-19 | Summit | Utah | 49043 | 1981 | 3 |
744838 | 744838 | 2020-11-18 | Summit | Utah | 49043 | 1950 | 3 |
741591 | 741591 | 2020-11-17 | Summit | Utah | 49043 | 1919 | 2 |
738344 | 738344 | 2020-11-16 | Summit | Utah | 49043 | 1883 | 2 |
735100 | 735100 | 2020-11-15 | Summit | Utah | 49043 | 1864 | 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);