ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Clark" and fips = 53011 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1196173 | 1196173 | 2021-04-06 | Clark | Washington | 53011 | 20506 | 249 |
1192925 | 1192925 | 2021-04-05 | Clark | Washington | 53011 | 20445 | 248 |
1189675 | 1189675 | 2021-04-04 | Clark | Washington | 53011 | 20385 | 248 |
1186428 | 1186428 | 2021-04-03 | Clark | Washington | 53011 | 20385 | 248 |
1183181 | 1183181 | 2021-04-02 | Clark | Washington | 53011 | 20316 | 248 |
1179934 | 1179934 | 2021-04-01 | Clark | Washington | 53011 | 20248 | 247 |
1176687 | 1176687 | 2021-03-31 | Clark | Washington | 53011 | 20221 | 247 |
1173440 | 1173440 | 2021-03-30 | Clark | Washington | 53011 | 20143 | 247 |
1170193 | 1170193 | 2021-03-29 | Clark | Washington | 53011 | 20105 | 246 |
1166945 | 1166945 | 2021-03-28 | Clark | Washington | 53011 | 20026 | 246 |
1163697 | 1163697 | 2021-03-27 | Clark | Washington | 53011 | 20026 | 246 |
1160449 | 1160449 | 2021-03-26 | Clark | Washington | 53011 | 19949 | 246 |
1157201 | 1157201 | 2021-03-25 | Clark | Washington | 53011 | 19903 | 245 |
1153954 | 1153954 | 2021-03-24 | Clark | Washington | 53011 | 19856 | 244 |
1150707 | 1150707 | 2021-03-23 | Clark | Washington | 53011 | 19799 | 243 |
1147460 | 1147460 | 2021-03-22 | Clark | Washington | 53011 | 19768 | 243 |
1144213 | 1144213 | 2021-03-21 | Clark | Washington | 53011 | 19710 | 243 |
1140966 | 1140966 | 2021-03-20 | Clark | Washington | 53011 | 19710 | 243 |
1137720 | 1137720 | 2021-03-19 | Clark | Washington | 53011 | 19640 | 243 |
1134474 | 1134474 | 2021-03-18 | Clark | Washington | 53011 | 19587 | 243 |
1131226 | 1131226 | 2021-03-17 | Clark | Washington | 53011 | 19545 | 241 |
1127979 | 1127979 | 2021-03-16 | Clark | Washington | 53011 | 19515 | 241 |
1124733 | 1124733 | 2021-03-15 | Clark | Washington | 53011 | 19474 | 239 |
1121487 | 1121487 | 2021-03-14 | Clark | Washington | 53011 | 19395 | 237 |
1118240 | 1118240 | 2021-03-13 | Clark | Washington | 53011 | 19395 | 237 |
1114993 | 1114993 | 2021-03-12 | Clark | Washington | 53011 | 19343 | 237 |
1111747 | 1111747 | 2021-03-11 | Clark | Washington | 53011 | 19308 | 235 |
1108501 | 1108501 | 2021-03-10 | Clark | Washington | 53011 | 19285 | 235 |
1105255 | 1105255 | 2021-03-09 | Clark | Washington | 53011 | 19228 | 234 |
1102009 | 1102009 | 2021-03-08 | Clark | Washington | 53011 | 19175 | 233 |
1098763 | 1098763 | 2021-03-07 | Clark | Washington | 53011 | 19142 | 232 |
1095515 | 1095515 | 2021-03-06 | Clark | Washington | 53011 | 19142 | 232 |
1092269 | 1092269 | 2021-03-05 | Clark | Washington | 53011 | 19103 | 232 |
1089023 | 1089023 | 2021-03-04 | Clark | Washington | 53011 | 19064 | 232 |
1085778 | 1085778 | 2021-03-03 | Clark | Washington | 53011 | 19024 | 231 |
1082532 | 1082532 | 2021-03-02 | Clark | Washington | 53011 | 19001 | 230 |
1079286 | 1079286 | 2021-03-01 | Clark | Washington | 53011 | 18959 | 228 |
1076041 | 1076041 | 2021-02-28 | Clark | Washington | 53011 | 18912 | 228 |
1072795 | 1072795 | 2021-02-27 | Clark | Washington | 53011 | 18912 | 228 |
1069549 | 1069549 | 2021-02-26 | Clark | Washington | 53011 | 18859 | 228 |
1066304 | 1066304 | 2021-02-25 | Clark | Washington | 53011 | 18804 | 228 |
1063059 | 1063059 | 2021-02-24 | Clark | Washington | 53011 | 18754 | 227 |
1059814 | 1059814 | 2021-02-23 | Clark | Washington | 53011 | 18706 | 228 |
1056568 | 1056568 | 2021-02-22 | Clark | Washington | 53011 | 18674 | 225 |
1053322 | 1053322 | 2021-02-21 | Clark | Washington | 53011 | 18612 | 224 |
1050075 | 1050075 | 2021-02-20 | Clark | Washington | 53011 | 18612 | 224 |
1046828 | 1046828 | 2021-02-19 | Clark | Washington | 53011 | 18551 | 224 |
1043583 | 1043583 | 2021-02-18 | Clark | Washington | 53011 | 18516 | 223 |
1040338 | 1040338 | 2021-02-17 | Clark | Washington | 53011 | 18504 | 221 |
1037093 | 1037093 | 2021-02-16 | Clark | Washington | 53011 | 18416 | 218 |
1033848 | 1033848 | 2021-02-15 | Clark | Washington | 53011 | 18343 | 216 |
1030602 | 1030602 | 2021-02-14 | Clark | Washington | 53011 | 18343 | 216 |
1027355 | 1027355 | 2021-02-13 | Clark | Washington | 53011 | 18343 | 216 |
1024110 | 1024110 | 2021-02-12 | Clark | Washington | 53011 | 18302 | 216 |
1020865 | 1020865 | 2021-02-11 | Clark | Washington | 53011 | 18252 | 215 |
1017620 | 1017620 | 2021-02-10 | Clark | Washington | 53011 | 18194 | 214 |
1014375 | 1014375 | 2021-02-09 | Clark | Washington | 53011 | 18228 | 213 |
1011130 | 1011130 | 2021-02-08 | Clark | Washington | 53011 | 18184 | 208 |
1007884 | 1007884 | 2021-02-07 | Clark | Washington | 53011 | 18030 | 208 |
1004638 | 1004638 | 2021-02-06 | Clark | Washington | 53011 | 18030 | 208 |
1001392 | 1001392 | 2021-02-05 | Clark | Washington | 53011 | 17992 | 208 |
998146 | 998146 | 2021-02-04 | Clark | Washington | 53011 | 17884 | 202 |
994900 | 994900 | 2021-02-03 | Clark | Washington | 53011 | 17809 | 202 |
991654 | 991654 | 2021-02-02 | Clark | Washington | 53011 | 17729 | 193 |
988408 | 988408 | 2021-02-01 | Clark | Washington | 53011 | 17644 | 193 |
985161 | 985161 | 2021-01-31 | Clark | Washington | 53011 | 17508 | 189 |
981914 | 981914 | 2021-01-30 | Clark | Washington | 53011 | 17508 | 189 |
978668 | 978668 | 2021-01-29 | Clark | Washington | 53011 | 17386 | 189 |
975423 | 975423 | 2021-01-28 | Clark | Washington | 53011 | 17249 | 183 |
972178 | 972178 | 2021-01-27 | Clark | Washington | 53011 | 17106 | 181 |
968933 | 968933 | 2021-01-26 | Clark | Washington | 53011 | 17009 | 182 |
965689 | 965689 | 2021-01-25 | Clark | Washington | 53011 | 16915 | 177 |
962444 | 962444 | 2021-01-24 | Clark | Washington | 53011 | 16786 | 177 |
959199 | 959199 | 2021-01-23 | Clark | Washington | 53011 | 16786 | 177 |
955953 | 955953 | 2021-01-22 | Clark | Washington | 53011 | 16639 | 177 |
952708 | 952708 | 2021-01-21 | Clark | Washington | 53011 | 16506 | 175 |
949463 | 949463 | 2021-01-20 | Clark | Washington | 53011 | 16485 | 166 |
946217 | 946217 | 2021-01-19 | Clark | Washington | 53011 | 16300 | 166 |
942970 | 942970 | 2021-01-18 | Clark | Washington | 53011 | 16125 | 165 |
939725 | 939725 | 2021-01-17 | Clark | Washington | 53011 | 16125 | 165 |
936480 | 936480 | 2021-01-16 | Clark | Washington | 53011 | 15873 | 165 |
933235 | 933235 | 2021-01-15 | Clark | Washington | 53011 | 15873 | 165 |
929990 | 929990 | 2021-01-14 | Clark | Washington | 53011 | 15734 | 165 |
926745 | 926745 | 2021-01-13 | Clark | Washington | 53011 | 15617 | 164 |
923499 | 923499 | 2021-01-12 | Clark | Washington | 53011 | 15590 | 163 |
920254 | 920254 | 2021-01-11 | Clark | Washington | 53011 | 15301 | 159 |
917009 | 917009 | 2021-01-10 | Clark | Washington | 53011 | 15010 | 159 |
913764 | 913764 | 2021-01-09 | Clark | Washington | 53011 | 15010 | 159 |
910519 | 910519 | 2021-01-08 | Clark | Washington | 53011 | 14846 | 159 |
907274 | 907274 | 2021-01-07 | Clark | Washington | 53011 | 14657 | 156 |
904028 | 904028 | 2021-01-06 | Clark | Washington | 53011 | 14531 | 152 |
900783 | 900783 | 2021-01-05 | Clark | Washington | 53011 | 14431 | 149 |
897538 | 897538 | 2021-01-04 | Clark | Washington | 53011 | 14092 | 148 |
894292 | 894292 | 2021-01-03 | Clark | Washington | 53011 | 13932 | 146 |
891046 | 891046 | 2021-01-02 | Clark | Washington | 53011 | 13344 | 146 |
887799 | 887799 | 2021-01-01 | Clark | Washington | 53011 | 13344 | 146 |
884554 | 884554 | 2020-12-31 | Clark | Washington | 53011 | 13344 | 146 |
881309 | 881309 | 2020-12-30 | Clark | Washington | 53011 | 13172 | 146 |
878064 | 878064 | 2020-12-29 | Clark | Washington | 53011 | 13064 | 143 |
874819 | 874819 | 2020-12-28 | Clark | Washington | 53011 | 12948 | 138 |
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);