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 |
---|---|---|---|---|---|---|---|
635435 | 635435 | 2020-10-16 | Unknown | Guam | 4507 | 64 | |
632189 | 632189 | 2020-10-15 | Unknown | Guam | 4396 | 62 | |
628945 | 628945 | 2020-10-14 | Unknown | Guam | 4310 | 62 | |
625702 | 625702 | 2020-10-13 | Unknown | Guam | 4235 | 62 | |
622459 | 622459 | 2020-10-12 | Unknown | Guam | 4139 | 61 | |
619216 | 619216 | 2020-10-11 | Unknown | Guam | 4047 | 61 | |
615974 | 615974 | 2020-10-10 | Unknown | Guam | 4025 | 60 | |
612733 | 612733 | 2020-10-09 | Unknown | Guam | 3958 | 59 | |
609491 | 609491 | 2020-10-08 | Unknown | Guam | 3903 | 59 | |
606248 | 606248 | 2020-10-07 | Unknown | Guam | 3837 | 58 | |
603006 | 603006 | 2020-10-06 | Unknown | Guam | 3787 | 56 | |
599763 | 599763 | 2020-10-05 | Unknown | Guam | 3722 | 56 | |
596520 | 596520 | 2020-10-04 | Unknown | Guam | 3586 | 53 | |
593278 | 593278 | 2020-10-03 | Unknown | Guam | 3668 | 52 | |
590038 | 590038 | 2020-10-02 | Unknown | Guam | 3586 | 51 | |
586797 | 586797 | 2020-10-01 | Unknown | Guam | 3519 | 50 | |
583557 | 583557 | 2020-09-30 | Unknown | Guam | 3457 | 50 | |
580318 | 580318 | 2020-09-29 | Unknown | Guam | 3412 | 48 | |
577077 | 577077 | 2020-09-28 | Unknown | Guam | 3255 | 40 | |
573834 | 573834 | 2020-09-27 | Unknown | Guam | 3255 | 40 | |
570592 | 570592 | 2020-09-26 | Unknown | Guam | 3255 | 40 | |
567350 | 567350 | 2020-09-25 | Unknown | Guam | 3255 | 40 | |
564110 | 564110 | 2020-09-24 | Unknown | Guam | 3232 | 39 | |
560870 | 560870 | 2020-09-23 | Unknown | Guam | 3204 | 38 | |
557634 | 557634 | 2020-09-22 | Unknown | Guam | 3159 | 38 | |
554397 | 554397 | 2020-09-21 | Unknown | Guam | 3116 | 36 | |
551158 | 551158 | 2020-09-20 | Unknown | Guam | 3043 | 35 | |
547919 | 547919 | 2020-09-19 | Unknown | Guam | 3043 | 35 | |
544681 | 544681 | 2020-09-18 | Unknown | Guam | 3043 | 34 | |
541445 | 541445 | 2020-09-17 | Unknown | Guam | 3014 | 31 | |
538208 | 538208 | 2020-09-16 | Unknown | Guam | 2982 | 29 | |
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 |
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);