ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
809 rows where fips = 49035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1196003 | 1196003 | 2021-04-06 | Salt Lake | Utah | 49035 | 144546 | 828 |
1192755 | 1192755 | 2021-04-05 | Salt Lake | Utah | 49035 | 144443 | 827 |
1189506 | 1189506 | 2021-04-04 | Salt Lake | Utah | 49035 | 144361 | 827 |
1186259 | 1186259 | 2021-04-03 | Salt Lake | Utah | 49035 | 144244 | 827 |
1183012 | 1183012 | 2021-04-02 | Salt Lake | Utah | 49035 | 144097 | 827 |
1179765 | 1179765 | 2021-04-01 | Salt Lake | Utah | 49035 | 143938 | 825 |
1176518 | 1176518 | 2021-03-31 | Salt Lake | Utah | 49035 | 143774 | 824 |
1173271 | 1173271 | 2021-03-30 | Salt Lake | Utah | 49035 | 143610 | 821 |
1170024 | 1170024 | 2021-03-29 | Salt Lake | Utah | 49035 | 143480 | 820 |
1166776 | 1166776 | 2021-03-28 | Salt Lake | Utah | 49035 | 143399 | 820 |
1163528 | 1163528 | 2021-03-27 | Salt Lake | Utah | 49035 | 143233 | 819 |
1160279 | 1160279 | 2021-03-26 | Salt Lake | Utah | 49035 | 143049 | 816 |
1157032 | 1157032 | 2021-03-25 | Salt Lake | Utah | 49035 | 142874 | 816 |
1153785 | 1153785 | 2021-03-24 | Salt Lake | Utah | 49035 | 142677 | 813 |
1150538 | 1150538 | 2021-03-23 | Salt Lake | Utah | 49035 | 142504 | 812 |
1147291 | 1147291 | 2021-03-22 | Salt Lake | Utah | 49035 | 142374 | 807 |
1144044 | 1144044 | 2021-03-21 | Salt Lake | Utah | 49035 | 142318 | 807 |
1140797 | 1140797 | 2021-03-20 | Salt Lake | Utah | 49035 | 142183 | 807 |
1137551 | 1137551 | 2021-03-19 | Salt Lake | Utah | 49035 | 142008 | 807 |
1134305 | 1134305 | 2021-03-18 | Salt Lake | Utah | 49035 | 141849 | 801 |
1131057 | 1131057 | 2021-03-17 | Salt Lake | Utah | 49035 | 141680 | 799 |
1127810 | 1127810 | 2021-03-16 | Salt Lake | Utah | 49035 | 141444 | 798 |
1124564 | 1124564 | 2021-03-15 | Salt Lake | Utah | 49035 | 141289 | 797 |
1121318 | 1121318 | 2021-03-14 | Salt Lake | Utah | 49035 | 141197 | 797 |
1118071 | 1118071 | 2021-03-13 | Salt Lake | Utah | 49035 | 141033 | 796 |
1114824 | 1114824 | 2021-03-12 | Salt Lake | Utah | 49035 | 140867 | 796 |
1111578 | 1111578 | 2021-03-11 | Salt Lake | Utah | 49035 | 140680 | 794 |
1108332 | 1108332 | 2021-03-10 | Salt Lake | Utah | 49035 | 140455 | 786 |
1105086 | 1105086 | 2021-03-09 | Salt Lake | Utah | 49035 | 140250 | 786 |
1101840 | 1101840 | 2021-03-08 | Salt Lake | Utah | 49035 | 140070 | 780 |
1098594 | 1098594 | 2021-03-07 | Salt Lake | Utah | 49035 | 139976 | 780 |
1095346 | 1095346 | 2021-03-06 | Salt Lake | Utah | 49035 | 139779 | 780 |
1092100 | 1092100 | 2021-03-05 | Salt Lake | Utah | 49035 | 139590 | 777 |
1088854 | 1088854 | 2021-03-04 | Salt Lake | Utah | 49035 | 139390 | 775 |
1085609 | 1085609 | 2021-03-03 | Salt Lake | Utah | 49035 | 139170 | 774 |
1082363 | 1082363 | 2021-03-02 | Salt Lake | Utah | 49035 | 138909 | 769 |
1079117 | 1079117 | 2021-03-01 | Salt Lake | Utah | 49035 | 138773 | 767 |
1075872 | 1075872 | 2021-02-28 | Salt Lake | Utah | 49035 | 138696 | 764 |
1072626 | 1072626 | 2021-02-27 | Salt Lake | Utah | 49035 | 138506 | 762 |
1069380 | 1069380 | 2021-02-26 | Salt Lake | Utah | 49035 | 138249 | 755 |
1066135 | 1066135 | 2021-02-25 | Salt Lake | Utah | 49035 | 138058 | 746 |
1062890 | 1062890 | 2021-02-24 | Salt Lake | Utah | 49035 | 137794 | 744 |
1059645 | 1059645 | 2021-02-23 | Salt Lake | Utah | 49035 | 137502 | 738 |
1056399 | 1056399 | 2021-02-22 | Salt Lake | Utah | 49035 | 137262 | 734 |
1053153 | 1053153 | 2021-02-21 | Salt Lake | Utah | 49035 | 137117 | 734 |
1049906 | 1049906 | 2021-02-20 | Salt Lake | Utah | 49035 | 136873 | 731 |
1046659 | 1046659 | 2021-02-19 | Salt Lake | Utah | 49035 | 136602 | 726 |
1043414 | 1043414 | 2021-02-18 | Salt Lake | Utah | 49035 | 136338 | 723 |
1040169 | 1040169 | 2021-02-17 | Salt Lake | Utah | 49035 | 135998 | 720 |
1036924 | 1036924 | 2021-02-16 | Salt Lake | Utah | 49035 | 135691 | 718 |
1033679 | 1033679 | 2021-02-15 | Salt Lake | Utah | 49035 | 135477 | 717 |
1030433 | 1030433 | 2021-02-14 | Salt Lake | Utah | 49035 | 135294 | 717 |
1027186 | 1027186 | 2021-02-13 | Salt Lake | Utah | 49035 | 135052 | 717 |
1023941 | 1023941 | 2021-02-12 | Salt Lake | Utah | 49035 | 134729 | 716 |
1020696 | 1020696 | 2021-02-11 | Salt Lake | Utah | 49035 | 134381 | 715 |
1017451 | 1017451 | 2021-02-10 | Salt Lake | Utah | 49035 | 133913 | 714 |
1014206 | 1014206 | 2021-02-09 | Salt Lake | Utah | 49035 | 133449 | 711 |
1010961 | 1010961 | 2021-02-08 | Salt Lake | Utah | 49035 | 133103 | 708 |
1007715 | 1007715 | 2021-02-07 | Salt Lake | Utah | 49035 | 132902 | 708 |
1004469 | 1004469 | 2021-02-06 | Salt Lake | Utah | 49035 | 132547 | 708 |
1001223 | 1001223 | 2021-02-05 | Salt Lake | Utah | 49035 | 132130 | 707 |
997977 | 997977 | 2021-02-04 | Salt Lake | Utah | 49035 | 131697 | 701 |
994731 | 994731 | 2021-02-03 | Salt Lake | Utah | 49035 | 131260 | 695 |
991485 | 991485 | 2021-02-02 | Salt Lake | Utah | 49035 | 130734 | 690 |
988239 | 988239 | 2021-02-01 | Salt Lake | Utah | 49035 | 130275 | 681 |
984992 | 984992 | 2021-01-31 | Salt Lake | Utah | 49035 | 130042 | 680 |
981745 | 981745 | 2021-01-30 | Salt Lake | Utah | 49035 | 129608 | 680 |
978499 | 978499 | 2021-01-29 | Salt Lake | Utah | 49035 | 129114 | 675 |
975254 | 975254 | 2021-01-28 | Salt Lake | Utah | 49035 | 128589 | 660 |
972009 | 972009 | 2021-01-27 | Salt Lake | Utah | 49035 | 128020 | 660 |
968764 | 968764 | 2021-01-26 | Salt Lake | Utah | 49035 | 127384 | 660 |
965520 | 965520 | 2021-01-25 | Salt Lake | Utah | 49035 | 126940 | 657 |
962275 | 962275 | 2021-01-24 | Salt Lake | Utah | 49035 | 126604 | 657 |
959030 | 959030 | 2021-01-23 | Salt Lake | Utah | 49035 | 126093 | 653 |
955784 | 955784 | 2021-01-22 | Salt Lake | Utah | 49035 | 125468 | 649 |
952539 | 952539 | 2021-01-21 | Salt Lake | Utah | 49035 | 124688 | 639 |
949294 | 949294 | 2021-01-20 | Salt Lake | Utah | 49035 | 123926 | 631 |
946048 | 946048 | 2021-01-19 | Salt Lake | Utah | 49035 | 123304 | 627 |
942801 | 942801 | 2021-01-18 | Salt Lake | Utah | 49035 | 122887 | 624 |
939556 | 939556 | 2021-01-17 | Salt Lake | Utah | 49035 | 122400 | 624 |
936311 | 936311 | 2021-01-16 | Salt Lake | Utah | 49035 | 121741 | 624 |
933066 | 933066 | 2021-01-15 | Salt Lake | Utah | 49035 | 121050 | 622 |
929821 | 929821 | 2021-01-14 | Salt Lake | Utah | 49035 | 120091 | 615 |
926576 | 926576 | 2021-01-13 | Salt Lake | Utah | 49035 | 119222 | 612 |
923330 | 923330 | 2021-01-12 | Salt Lake | Utah | 49035 | 118431 | 610 |
920085 | 920085 | 2021-01-11 | Salt Lake | Utah | 49035 | 117670 | 600 |
916840 | 916840 | 2021-01-10 | Salt Lake | Utah | 49035 | 117126 | 599 |
913595 | 913595 | 2021-01-09 | Salt Lake | Utah | 49035 | 116220 | 599 |
910350 | 910350 | 2021-01-08 | Salt Lake | Utah | 49035 | 115315 | 594 |
907105 | 907105 | 2021-01-07 | Salt Lake | Utah | 49035 | 114097 | 583 |
903859 | 903859 | 2021-01-06 | Salt Lake | Utah | 49035 | 112552 | 571 |
900614 | 900614 | 2021-01-05 | Salt Lake | Utah | 49035 | 111389 | 564 |
897369 | 897369 | 2021-01-04 | Salt Lake | Utah | 49035 | 110242 | 563 |
894123 | 894123 | 2021-01-03 | Salt Lake | Utah | 49035 | 109533 | 561 |
890877 | 890877 | 2021-01-02 | Salt Lake | Utah | 49035 | 108971 | 560 |
887630 | 887630 | 2021-01-01 | Salt Lake | Utah | 49035 | 107386 | 554 |
884385 | 884385 | 2020-12-31 | Salt Lake | Utah | 49035 | 107386 | 554 |
881140 | 881140 | 2020-12-30 | Salt Lake | Utah | 49035 | 105933 | 551 |
877895 | 877895 | 2020-12-29 | Salt Lake | Utah | 49035 | 105026 | 542 |
874650 | 874650 | 2020-12-28 | Salt Lake | Utah | 49035 | 104167 | 536 |
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);