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 |
---|---|---|---|---|---|---|---|
1280438 | 1280438 | 2021-05-02 | Salt Lake | Utah | 49035 | 148226 | 849 |
1277191 | 1277191 | 2021-05-01 | Salt Lake | Utah | 49035 | 148119 | 849 |
1273944 | 1273944 | 2021-04-30 | Salt Lake | Utah | 49035 | 147949 | 848 |
1270697 | 1270697 | 2021-04-29 | Salt Lake | Utah | 49035 | 147821 | 846 |
1267450 | 1267450 | 2021-04-28 | Salt Lake | Utah | 49035 | 147650 | 844 |
1264203 | 1264203 | 2021-04-27 | Salt Lake | Utah | 49035 | 147430 | 844 |
1260956 | 1260956 | 2021-04-26 | Salt Lake | Utah | 49035 | 147313 | 843 |
1257709 | 1257709 | 2021-04-25 | Salt Lake | Utah | 49035 | 147212 | 842 |
1254462 | 1254462 | 2021-04-24 | Salt Lake | Utah | 49035 | 147083 | 841 |
1251215 | 1251215 | 2021-04-23 | Salt Lake | Utah | 49035 | 147074 | 840 |
1247968 | 1247968 | 2021-04-22 | Salt Lake | Utah | 49035 | 146773 | 840 |
1244721 | 1244721 | 2021-04-21 | Salt Lake | Utah | 49035 | 146621 | 840 |
1241474 | 1241474 | 2021-04-20 | Salt Lake | Utah | 49035 | 146421 | 840 |
1238227 | 1238227 | 2021-04-19 | Salt Lake | Utah | 49035 | 146295 | 839 |
1234980 | 1234980 | 2021-04-18 | Salt Lake | Utah | 49035 | 146205 | 839 |
1231732 | 1231732 | 2021-04-17 | Salt Lake | Utah | 49035 | 146100 | 839 |
1228484 | 1228484 | 2021-04-16 | Salt Lake | Utah | 49035 | 145950 | 839 |
1225236 | 1225236 | 2021-04-15 | Salt Lake | Utah | 49035 | 145800 | 838 |
1221989 | 1221989 | 2021-04-14 | Salt Lake | Utah | 49035 | 145662 | 837 |
1218741 | 1218741 | 2021-04-13 | Salt Lake | Utah | 49035 | 145484 | 837 |
1215493 | 1215493 | 2021-04-12 | Salt Lake | Utah | 49035 | 145390 | 836 |
1212246 | 1212246 | 2021-04-11 | Salt Lake | Utah | 49035 | 145318 | 836 |
1208997 | 1208997 | 2021-04-10 | Salt Lake | Utah | 49035 | 145193 | 836 |
1205749 | 1205749 | 2021-04-09 | Salt Lake | Utah | 49035 | 145036 | 835 |
1202501 | 1202501 | 2021-04-08 | Salt Lake | Utah | 49035 | 144873 | 831 |
1199252 | 1199252 | 2021-04-07 | Salt Lake | Utah | 49035 | 144730 | 829 |
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 |
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);