ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Unknown" and state = "Guam" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386488 | 386488 | 2020-07-31 | Unknown | Guam | 1325 | 6 | |
383270 | 383270 | 2020-07-30 | Unknown | Guam | 1323 | 6 | |
380053 | 380053 | 2020-07-29 | Unknown | Guam | 1320 | 6 | |
376836 | 376836 | 2020-07-28 | Unknown | Guam | 1318 | 6 | |
373622 | 373622 | 2020-07-27 | Unknown | Guam | 1315 | 6 | |
370410 | 370410 | 2020-07-26 | Unknown | Guam | 1306 | 6 | |
367200 | 367200 | 2020-07-25 | Unknown | Guam | 1306 | 6 | |
363993 | 363993 | 2020-07-24 | Unknown | Guam | 1306 | 6 | |
360786 | 360786 | 2020-07-23 | Unknown | Guam | 1301 | 6 | |
357581 | 357581 | 2020-07-22 | Unknown | Guam | 1299 | 6 | |
354378 | 354378 | 2020-07-21 | Unknown | Guam | 1296 | 6 | |
351176 | 351176 | 2020-07-20 | Unknown | Guam | 1288 | 6 | |
347975 | 347975 | 2020-07-19 | Unknown | Guam | 1284 | 6 | |
344775 | 344775 | 2020-07-18 | Unknown | Guam | 1284 | 6 | |
341576 | 341576 | 2020-07-17 | Unknown | Guam | 1283 | 6 | |
338379 | 338379 | 2020-07-16 | Unknown | Guam | 1283 | 6 | |
335184 | 335184 | 2020-07-15 | Unknown | Guam | 1282 | 6 | |
331991 | 331991 | 2020-07-14 | Unknown | Guam | 1281 | 6 | |
328804 | 328804 | 2020-07-13 | Unknown | Guam | 1281 | 6 | |
325618 | 325618 | 2020-07-12 | Unknown | Guam | 1281 | 6 | |
322437 | 322437 | 2020-07-11 | Unknown | Guam | 1281 | 6 | |
319258 | 319258 | 2020-07-10 | Unknown | Guam | 1279 | 6 | |
316085 | 316085 | 2020-07-09 | Unknown | Guam | 1278 | 6 | |
312910 | 312910 | 2020-07-08 | Unknown | Guam | 1276 | 6 | |
309740 | 309740 | 2020-07-07 | Unknown | Guam | 1272 | 6 | |
306572 | 306572 | 2020-07-06 | Unknown | Guam | 1270 | 6 | |
303408 | 303408 | 2020-07-05 | Unknown | Guam | 1257 | 6 | |
300244 | 300244 | 2020-07-04 | Unknown | Guam | 1257 | 6 | |
297082 | 297082 | 2020-07-03 | Unknown | Guam | 1255 | 6 | |
293926 | 293926 | 2020-07-02 | Unknown | Guam | 1249 | 6 | |
290772 | 290772 | 2020-07-01 | Unknown | Guam | 1240 | 6 | |
287621 | 287621 | 2020-06-30 | Unknown | Guam | 1228 | 6 | |
284475 | 284475 | 2020-06-29 | Unknown | Guam | 1224 | 6 | |
281329 | 281329 | 2020-06-28 | Unknown | Guam | 1217 | 6 | |
278182 | 278182 | 2020-06-27 | Unknown | Guam | 1217 | 6 | |
275034 | 275034 | 2020-06-26 | Unknown | Guam | 1217 | 6 | |
271894 | 271894 | 2020-06-25 | Unknown | Guam | 1214 | 6 | |
268758 | 268758 | 2020-06-24 | Unknown | Guam | 1200 | 6 | |
265628 | 265628 | 2020-06-23 | Unknown | Guam | 1194 | 6 | |
262500 | 262500 | 2020-06-22 | Unknown | Guam | 1191 | 6 | |
259373 | 259373 | 2020-06-21 | Unknown | Guam | 1191 | 6 | |
256246 | 256246 | 2020-06-20 | Unknown | Guam | 1191 | 6 | |
253127 | 253127 | 2020-06-19 | Unknown | Guam | 1169 | 6 | |
250012 | 250012 | 2020-06-18 | Unknown | Guam | 1162 | 6 | |
246900 | 246900 | 2020-06-17 | Unknown | Guam | 1157 | 6 | |
243787 | 243787 | 2020-06-16 | Unknown | Guam | 1155 | 6 | |
240676 | 240676 | 2020-06-15 | Unknown | Guam | 1155 | 6 | |
237568 | 237568 | 2020-06-14 | Unknown | Guam | 1154 | 6 | |
234461 | 234461 | 2020-06-13 | Unknown | Guam | 1154 | 6 | |
231355 | 231355 | 2020-06-12 | Unknown | Guam | 1153 | 6 | |
228252 | 228252 | 2020-06-11 | Unknown | Guam | 1152 | 6 | |
225150 | 225150 | 2020-06-10 | Unknown | Guam | 1149 | 6 | |
222055 | 222055 | 2020-06-09 | Unknown | Guam | 1149 | 6 | |
218960 | 218960 | 2020-06-08 | Unknown | Guam | 1149 | 6 | |
215869 | 215869 | 2020-06-07 | Unknown | Guam | 1148 | 6 | |
212782 | 212782 | 2020-06-06 | Unknown | Guam | 1148 | 6 | |
209697 | 209697 | 2020-06-05 | Unknown | Guam | 1148 | 6 | |
206616 | 206616 | 2020-06-04 | Unknown | Guam | 1148 | 6 | |
203536 | 203536 | 2020-06-03 | Unknown | Guam | 1146 | 6 | |
200460 | 200460 | 2020-06-02 | Unknown | Guam | 1146 | 6 | |
197387 | 197387 | 2020-06-01 | Unknown | Guam | 1144 | 6 | |
194317 | 194317 | 2020-05-31 | Unknown | Guam | 1144 | 6 | |
191250 | 191250 | 2020-05-30 | Unknown | Guam | 1141 | 6 | |
188185 | 188185 | 2020-05-29 | Unknown | Guam | 1141 | 6 | |
185129 | 185129 | 2020-05-28 | Unknown | Guam | 1141 | 6 | |
182075 | 182075 | 2020-05-27 | Unknown | Guam | 1140 | 6 | |
179031 | 179031 | 2020-05-26 | Unknown | Guam | 1139 | 6 | |
175987 | 175987 | 2020-05-25 | Unknown | Guam | 1135 | 6 | |
172944 | 172944 | 2020-05-24 | Unknown | Guam | 1135 | 6 | |
169903 | 169903 | 2020-05-23 | Unknown | Guam | 1134 | 6 | |
166866 | 166866 | 2020-05-22 | Unknown | Guam | 1134 | 6 | |
163833 | 163833 | 2020-05-21 | Unknown | Guam | 1134 | 6 | |
160805 | 160805 | 2020-05-20 | Unknown | Guam | 1134 | 6 | |
157779 | 157779 | 2020-05-19 | Unknown | Guam | 1123 | 6 | |
154763 | 154763 | 2020-05-18 | Unknown | Guam | 1123 | 6 | |
151751 | 151751 | 2020-05-17 | Unknown | Guam | 1123 | 6 | |
148742 | 148742 | 2020-05-16 | Unknown | Guam | 1123 | 6 | |
145739 | 145739 | 2020-05-15 | Unknown | Guam | 1123 | 6 | |
142739 | 142739 | 2020-05-14 | Unknown | Guam | 1121 | 6 | |
139743 | 139743 | 2020-05-13 | Unknown | Guam | 1121 | 6 | |
136752 | 136752 | 2020-05-12 | Unknown | Guam | 1121 | 6 | |
133763 | 133763 | 2020-05-11 | Unknown | Guam | 1120 | 6 | |
130772 | 130772 | 2020-05-10 | Unknown | Guam | 1120 | 6 | |
127781 | 127781 | 2020-05-09 | Unknown | Guam | 1120 | 6 | |
124794 | 124794 | 2020-05-08 | Unknown | Guam | 1120 | 6 | |
121815 | 121815 | 2020-05-07 | Unknown | Guam | 1118 | 6 | |
118845 | 118845 | 2020-05-06 | Unknown | Guam | 1118 | 6 | |
115885 | 115885 | 2020-05-05 | Unknown | Guam | 1118 | 6 | |
113002 | 113002 | 2020-05-04 | Unknown | Guam | 1118 | 6 | |
110127 | 110127 | 2020-05-03 | Unknown | Guam | 1118 | 6 | |
107257 | 107257 | 2020-05-02 | Unknown | Guam | 1117 | 6 | |
104392 | 104392 | 2020-05-01 | Unknown | Guam | 1115 | 6 | |
101537 | 101537 | 2020-04-30 | Unknown | Guam | 1115 | 6 | |
98686 | 98686 | 2020-04-29 | Unknown | Guam | 1114 | 6 | |
95842 | 95842 | 2020-04-28 | Unknown | Guam | 1114 | 6 | |
93010 | 93010 | 2020-04-27 | Unknown | Guam | 1113 | 6 | |
90191 | 90191 | 2020-04-26 | Unknown | Guam | 997 | 6 | |
87375 | 87375 | 2020-04-25 | Unknown | Guam | 997 | 6 | |
84566 | 84566 | 2020-04-24 | Unknown | Guam | 997 | 6 | |
81766 | 81766 | 2020-04-23 | Unknown | Guam | 979 | 6 |
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);