ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where state = "Guam" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534972 | 534972 | 2020-09-15 | Unknown | Guam | 2935 | 29 | |
531737 | 531737 | 2020-09-14 | Unknown | Guam | 2896 | 27 | |
528500 | 528500 | 2020-09-13 | Unknown | Guam | 2832 | 24 | |
525264 | 525264 | 2020-09-12 | Unknown | Guam | 2832 | 24 | |
522028 | 522028 | 2020-09-11 | Unknown | Guam | 2832 | 24 | |
518791 | 518791 | 2020-09-10 | Unknown | Guam | 2815 | 22 | |
515556 | 515556 | 2020-09-09 | Unknown | Guam | 2727 | 21 | |
512323 | 512323 | 2020-09-08 | Unknown | Guam | 2682 | 20 | |
509090 | 509090 | 2020-09-07 | Unknown | Guam | 2588 | 19 | |
505858 | 505858 | 2020-09-06 | Unknown | Guam | 2588 | 17 | |
502624 | 502624 | 2020-09-05 | Unknown | Guam | 2640 | 16 | |
499390 | 499390 | 2020-09-04 | Unknown | Guam | 2588 | 15 | |
496157 | 496157 | 2020-09-03 | Unknown | Guam | 2529 | 14 | |
492923 | 492923 | 2020-09-02 | Unknown | Guam | 2463 | 14 | |
489690 | 489690 | 2020-09-01 | Unknown | Guam | 2416 | 14 | |
486457 | 486457 | 2020-08-31 | Unknown | Guam | 2364 | 11 | |
483222 | 483222 | 2020-08-30 | Unknown | Guam | 2256 | 11 | |
479988 | 479988 | 2020-08-29 | Unknown | Guam | 2256 | 11 | |
476755 | 476755 | 2020-08-28 | Unknown | Guam | 2256 | 11 | |
473522 | 473522 | 2020-08-27 | Unknown | Guam | 2201 | 10 | |
470290 | 470290 | 2020-08-26 | Unknown | Guam | 2089 | 10 | |
467061 | 467061 | 2020-08-25 | Unknown | Guam | 1953 | 8 | |
463832 | 463832 | 2020-08-24 | Unknown | Guam | 1876 | 8 | |
460603 | 460603 | 2020-08-23 | Unknown | Guam | 1736 | 7 | |
457376 | 457376 | 2020-08-22 | Unknown | Guam | 1736 | 7 | |
454148 | 454148 | 2020-08-21 | Unknown | Guam | 1736 | 7 | |
450920 | 450920 | 2020-08-20 | Unknown | Guam | 1673 | 7 | |
447692 | 447692 | 2020-08-19 | Unknown | Guam | 1568 | 6 | |
444465 | 444465 | 2020-08-18 | Unknown | Guam | 1546 | 6 | |
441239 | 441239 | 2020-08-17 | Unknown | Guam | 1527 | 6 | |
438013 | 438013 | 2020-08-16 | Unknown | Guam | 1471 | 6 | |
434787 | 434787 | 2020-08-15 | Unknown | Guam | 1471 | 6 | |
431562 | 431562 | 2020-08-14 | Unknown | Guam | 1471 | 6 | |
428334 | 428334 | 2020-08-13 | Unknown | Guam | 1446 | 6 | |
425110 | 425110 | 2020-08-12 | Unknown | Guam | 1418 | 6 | |
421889 | 421889 | 2020-08-11 | Unknown | Guam | 1403 | 6 | |
418668 | 418668 | 2020-08-10 | Unknown | Guam | 1387 | 6 | |
415447 | 415447 | 2020-08-09 | Unknown | Guam | 1381 | 6 | |
412227 | 412227 | 2020-08-08 | Unknown | Guam | 1381 | 6 | |
409008 | 409008 | 2020-08-07 | Unknown | Guam | 1380 | 6 | |
405788 | 405788 | 2020-08-06 | Unknown | Guam | 1366 | 6 | |
402570 | 402570 | 2020-08-05 | Unknown | Guam | 1358 | 6 | |
399354 | 399354 | 2020-08-04 | Unknown | Guam | 1344 | 6 | |
396138 | 396138 | 2020-08-03 | Unknown | Guam | 1337 | 6 | |
392922 | 392922 | 2020-08-02 | Unknown | Guam | 1328 | 6 | |
389705 | 389705 | 2020-08-01 | Unknown | Guam | 1328 | 6 | |
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 |
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);