ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72013 and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
430104 | 430104 | 2020-08-13 | Arecibo | Puerto Rico | 72013 | 352 | |
433330 | 433330 | 2020-08-14 | Arecibo | Puerto Rico | 72013 | 366 | |
436557 | 436557 | 2020-08-15 | Arecibo | Puerto Rico | 72013 | 377 | |
439782 | 439782 | 2020-08-16 | Arecibo | Puerto Rico | 72013 | 384 | |
443009 | 443009 | 2020-08-17 | Arecibo | Puerto Rico | 72013 | 389 | |
446235 | 446235 | 2020-08-18 | Arecibo | Puerto Rico | 72013 | 404 | |
449463 | 449463 | 2020-08-19 | Arecibo | Puerto Rico | 72013 | 414 | |
452691 | 452691 | 2020-08-20 | Arecibo | Puerto Rico | 72013 | 420 | |
455919 | 455919 | 2020-08-21 | Arecibo | Puerto Rico | 72013 | 426 | |
459147 | 459147 | 2020-08-22 | Arecibo | Puerto Rico | 72013 | 437 | |
462375 | 462375 | 2020-08-23 | Arecibo | Puerto Rico | 72013 | 449 | |
465604 | 465604 | 2020-08-24 | Arecibo | Puerto Rico | 72013 | 457 | |
468832 | 468832 | 2020-08-25 | Arecibo | Puerto Rico | 72013 | 458 | |
472064 | 472064 | 2020-08-26 | Arecibo | Puerto Rico | 72013 | 462 | |
475298 | 475298 | 2020-08-27 | Arecibo | Puerto Rico | 72013 | 477 | |
478531 | 478531 | 2020-08-28 | Arecibo | Puerto Rico | 72013 | 484 | |
481765 | 481765 | 2020-08-29 | Arecibo | Puerto Rico | 72013 | 493 | |
485000 | 485000 | 2020-08-30 | Arecibo | Puerto Rico | 72013 | 501 | |
488233 | 488233 | 2020-08-31 | Arecibo | Puerto Rico | 72013 | 510 | |
491466 | 491466 | 2020-09-01 | Arecibo | Puerto Rico | 72013 | 511 | |
494700 | 494700 | 2020-09-02 | Arecibo | Puerto Rico | 72013 | 519 | |
497933 | 497933 | 2020-09-03 | Arecibo | Puerto Rico | 72013 | 527 | |
501167 | 501167 | 2020-09-04 | Arecibo | Puerto Rico | 72013 | 529 | |
504401 | 504401 | 2020-09-05 | Arecibo | Puerto Rico | 72013 | 530 | |
507633 | 507633 | 2020-09-06 | Arecibo | Puerto Rico | 72013 | 530 | |
514099 | 514099 | 2020-09-08 | Arecibo | Puerto Rico | 72013 | 541 | |
517334 | 517334 | 2020-09-09 | Arecibo | Puerto Rico | 72013 | 541 | |
510866 | 510866 | 2020-09-07 | Arecibo | Puerto Rico | 72013 | 542 | |
520570 | 520570 | 2020-09-10 | Arecibo | Puerto Rico | 72013 | 554 | |
523806 | 523806 | 2020-09-11 | Arecibo | Puerto Rico | 72013 | 561 | |
527042 | 527042 | 2020-09-12 | Arecibo | Puerto Rico | 72013 | 574 | |
530279 | 530279 | 2020-09-13 | Arecibo | Puerto Rico | 72013 | 586 | |
533514 | 533514 | 2020-09-14 | Arecibo | Puerto Rico | 72013 | 594 | |
536750 | 536750 | 2020-09-15 | Arecibo | Puerto Rico | 72013 | 604 | |
539987 | 539987 | 2020-09-16 | Arecibo | Puerto Rico | 72013 | 608 | |
543223 | 543223 | 2020-09-17 | Arecibo | Puerto Rico | 72013 | 628 | |
546460 | 546460 | 2020-09-18 | Arecibo | Puerto Rico | 72013 | 662 | |
549699 | 549699 | 2020-09-19 | Arecibo | Puerto Rico | 72013 | 691 | |
552938 | 552938 | 2020-09-20 | Arecibo | Puerto Rico | 72013 | 708 | |
556175 | 556175 | 2020-09-21 | Arecibo | Puerto Rico | 72013 | 743 | |
559412 | 559412 | 2020-09-22 | Arecibo | Puerto Rico | 72013 | 744 | |
562649 | 562649 | 2020-09-23 | Arecibo | Puerto Rico | 72013 | 756 | |
565890 | 565890 | 2020-09-24 | Arecibo | Puerto Rico | 72013 | 774 | |
569131 | 569131 | 2020-09-25 | Arecibo | Puerto Rico | 72013 | 794 | |
572373 | 572373 | 2020-09-26 | Arecibo | Puerto Rico | 72013 | 813 | |
575617 | 575617 | 2020-09-27 | Arecibo | Puerto Rico | 72013 | 827 | |
578858 | 578858 | 2020-09-28 | Arecibo | Puerto Rico | 72013 | 836 | |
582098 | 582098 | 2020-09-29 | Arecibo | Puerto Rico | 72013 | 845 | |
585338 | 585338 | 2020-09-30 | Arecibo | Puerto Rico | 72013 | 849 | |
588578 | 588578 | 2020-10-01 | Arecibo | Puerto Rico | 72013 | 863 | |
591819 | 591819 | 2020-10-02 | Arecibo | Puerto Rico | 72013 | 887 | |
595060 | 595060 | 2020-10-03 | Arecibo | Puerto Rico | 72013 | 899 | |
598303 | 598303 | 2020-10-04 | Arecibo | Puerto Rico | 72013 | 901 | |
601546 | 601546 | 2020-10-05 | Arecibo | Puerto Rico | 72013 | 908 | |
604788 | 604788 | 2020-10-06 | Arecibo | Puerto Rico | 72013 | 916 | |
608031 | 608031 | 2020-10-07 | Arecibo | Puerto Rico | 72013 | 917 | |
611273 | 611273 | 2020-10-08 | Arecibo | Puerto Rico | 72013 | 929 | |
614514 | 614514 | 2020-10-09 | Arecibo | Puerto Rico | 72013 | 939 | |
617756 | 617756 | 2020-10-10 | Arecibo | Puerto Rico | 72013 | 948 | |
620999 | 620999 | 2020-10-11 | Arecibo | Puerto Rico | 72013 | 952 | |
624242 | 624242 | 2020-10-12 | Arecibo | Puerto Rico | 72013 | 955 | |
627484 | 627484 | 2020-10-13 | Arecibo | Puerto Rico | 72013 | 957 | |
630728 | 630728 | 2020-10-14 | Arecibo | Puerto Rico | 72013 | 963 | |
633973 | 633973 | 2020-10-15 | Arecibo | Puerto Rico | 72013 | 969 | |
637219 | 637219 | 2020-10-16 | Arecibo | Puerto Rico | 72013 | 971 | |
640465 | 640465 | 2020-10-17 | Arecibo | Puerto Rico | 72013 | 975 | |
643713 | 643713 | 2020-10-18 | Arecibo | Puerto Rico | 72013 | 979 | |
646959 | 646959 | 2020-10-19 | Arecibo | Puerto Rico | 72013 | 993 | |
650203 | 650203 | 2020-10-20 | Arecibo | Puerto Rico | 72013 | 997 | |
653448 | 653448 | 2020-10-21 | Arecibo | Puerto Rico | 72013 | 998 | |
656693 | 656693 | 2020-10-22 | Arecibo | Puerto Rico | 72013 | 1004 | |
659937 | 659937 | 2020-10-23 | Arecibo | Puerto Rico | 72013 | 1043 | |
663181 | 663181 | 2020-10-24 | Arecibo | Puerto Rico | 72013 | 1050 | |
666426 | 666426 | 2020-10-25 | Arecibo | Puerto Rico | 72013 | 1065 | |
669670 | 669670 | 2020-10-26 | Arecibo | Puerto Rico | 72013 | 1080 | |
672912 | 672912 | 2020-10-27 | Arecibo | Puerto Rico | 72013 | 1083 | |
676155 | 676155 | 2020-10-28 | Arecibo | Puerto Rico | 72013 | 1083 | |
679398 | 679398 | 2020-10-29 | Arecibo | Puerto Rico | 72013 | 1099 | |
682641 | 682641 | 2020-10-30 | Arecibo | Puerto Rico | 72013 | 1107 | |
685884 | 685884 | 2020-10-31 | Arecibo | Puerto Rico | 72013 | 1117 | |
689129 | 689129 | 2020-11-01 | Arecibo | Puerto Rico | 72013 | 1123 | |
692373 | 692373 | 2020-11-02 | Arecibo | Puerto Rico | 72013 | 1146 | |
695615 | 695615 | 2020-11-03 | Arecibo | Puerto Rico | 72013 | 1164 | |
698858 | 698858 | 2020-11-04 | Arecibo | Puerto Rico | 72013 | 1165 | |
702102 | 702102 | 2020-11-05 | Arecibo | Puerto Rico | 72013 | 1168 | |
705345 | 705345 | 2020-11-06 | Arecibo | Puerto Rico | 72013 | 1192 | |
708588 | 708588 | 2020-11-07 | Arecibo | Puerto Rico | 72013 | 1192 | |
711832 | 711832 | 2020-11-08 | Arecibo | Puerto Rico | 72013 | 1217 | |
715076 | 715076 | 2020-11-09 | Arecibo | Puerto Rico | 72013 | 1223 | |
718319 | 718319 | 2020-11-10 | Arecibo | Puerto Rico | 72013 | 1225 | |
721562 | 721562 | 2020-11-11 | Arecibo | Puerto Rico | 72013 | 1232 | |
724805 | 724805 | 2020-11-12 | Arecibo | Puerto Rico | 72013 | 1265 | |
728049 | 728049 | 2020-11-13 | Arecibo | Puerto Rico | 72013 | 1285 | |
731293 | 731293 | 2020-11-14 | Arecibo | Puerto Rico | 72013 | 1299 | |
734539 | 734539 | 2020-11-15 | Arecibo | Puerto Rico | 72013 | 1327 | |
737783 | 737783 | 2020-11-16 | Arecibo | Puerto Rico | 72013 | 1330 | |
741029 | 741029 | 2020-11-17 | Arecibo | Puerto Rico | 72013 | 1342 | |
744276 | 744276 | 2020-11-18 | Arecibo | Puerto Rico | 72013 | 1367 | |
747522 | 747522 | 2020-11-19 | Arecibo | Puerto Rico | 72013 | 1380 | |
750768 | 750768 | 2020-11-20 | Arecibo | Puerto Rico | 72013 | 1402 |
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);