ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Arecibo" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922772 | 922772 | 2021-01-12 | Arecibo | Puerto Rico | 72013 | 2525 | |
919527 | 919527 | 2021-01-11 | Arecibo | Puerto Rico | 72013 | 2499 | |
916282 | 916282 | 2021-01-10 | Arecibo | Puerto Rico | 72013 | 2495 | |
913037 | 913037 | 2021-01-09 | Arecibo | Puerto Rico | 72013 | 2483 | |
909792 | 909792 | 2021-01-08 | Arecibo | Puerto Rico | 72013 | 2461 | |
906547 | 906547 | 2021-01-07 | Arecibo | Puerto Rico | 72013 | 2415 | |
903301 | 903301 | 2021-01-06 | Arecibo | Puerto Rico | 72013 | 2402 | |
900056 | 900056 | 2021-01-05 | Arecibo | Puerto Rico | 72013 | 2392 | |
896811 | 896811 | 2021-01-04 | Arecibo | Puerto Rico | 72013 | 2390 | |
893565 | 893565 | 2021-01-03 | Arecibo | Puerto Rico | 72013 | 2372 | |
890319 | 890319 | 2021-01-02 | Arecibo | Puerto Rico | 72013 | 2369 | |
887072 | 887072 | 2021-01-01 | Arecibo | Puerto Rico | 72013 | 2348 | |
883827 | 883827 | 2020-12-31 | Arecibo | Puerto Rico | 72013 | 2321 | |
880582 | 880582 | 2020-12-30 | Arecibo | Puerto Rico | 72013 | 2314 | |
877337 | 877337 | 2020-12-29 | Arecibo | Puerto Rico | 72013 | 2314 | |
874092 | 874092 | 2020-12-28 | Arecibo | Puerto Rico | 72013 | 2281 | |
870847 | 870847 | 2020-12-27 | Arecibo | Puerto Rico | 72013 | 2279 | |
867602 | 867602 | 2020-12-26 | Arecibo | Puerto Rico | 72013 | 2254 | |
864357 | 864357 | 2020-12-25 | Arecibo | Puerto Rico | 72013 | 2235 | |
861112 | 861112 | 2020-12-24 | Arecibo | Puerto Rico | 72013 | 2224 | |
857867 | 857867 | 2020-12-23 | Arecibo | Puerto Rico | 72013 | 2214 | |
854622 | 854622 | 2020-12-22 | Arecibo | Puerto Rico | 72013 | 2209 | |
851377 | 851377 | 2020-12-21 | Arecibo | Puerto Rico | 72013 | 2181 | |
848132 | 848132 | 2020-12-20 | Arecibo | Puerto Rico | 72013 | 2167 | |
844887 | 844887 | 2020-12-19 | Arecibo | Puerto Rico | 72013 | 2127 | |
841641 | 841641 | 2020-12-18 | Arecibo | Puerto Rico | 72013 | 2081 | |
838396 | 838396 | 2020-12-17 | Arecibo | Puerto Rico | 72013 | 2007 | |
835150 | 835150 | 2020-12-16 | Arecibo | Puerto Rico | 72013 | 1978 | |
831904 | 831904 | 2020-12-15 | Arecibo | Puerto Rico | 72013 | 1976 | |
828657 | 828657 | 2020-12-14 | Arecibo | Puerto Rico | 72013 | 1968 | |
825411 | 825411 | 2020-12-13 | Arecibo | Puerto Rico | 72013 | 1955 | |
822164 | 822164 | 2020-12-12 | Arecibo | Puerto Rico | 72013 | 1939 | |
818918 | 818918 | 2020-12-11 | Arecibo | Puerto Rico | 72013 | 1911 | |
815672 | 815672 | 2020-12-10 | Arecibo | Puerto Rico | 72013 | 1826 | |
812426 | 812426 | 2020-12-09 | Arecibo | Puerto Rico | 72013 | 1815 | |
809182 | 809182 | 2020-12-08 | Arecibo | Puerto Rico | 72013 | 1792 | |
805937 | 805937 | 2020-12-07 | Arecibo | Puerto Rico | 72013 | 1767 | |
802692 | 802692 | 2020-12-06 | Arecibo | Puerto Rico | 72013 | 1734 | |
799447 | 799447 | 2020-12-05 | Arecibo | Puerto Rico | 72013 | 1699 | |
796202 | 796202 | 2020-12-04 | Arecibo | Puerto Rico | 72013 | 1683 | |
792957 | 792957 | 2020-12-03 | Arecibo | Puerto Rico | 72013 | 1669 | |
789712 | 789712 | 2020-12-02 | Arecibo | Puerto Rico | 72013 | 1666 | |
786467 | 786467 | 2020-12-01 | Arecibo | Puerto Rico | 72013 | 1656 | |
783223 | 783223 | 2020-11-30 | Arecibo | Puerto Rico | 72013 | 1628 | |
779978 | 779978 | 2020-11-29 | Arecibo | Puerto Rico | 72013 | 1598 | |
776732 | 776732 | 2020-11-28 | Arecibo | Puerto Rico | 72013 | 1595 | |
773487 | 773487 | 2020-11-27 | Arecibo | Puerto Rico | 72013 | 1559 | |
770242 | 770242 | 2020-11-26 | Arecibo | Puerto Rico | 72013 | 1501 | |
766996 | 766996 | 2020-11-25 | Arecibo | Puerto Rico | 72013 | 1491 | |
763751 | 763751 | 2020-11-24 | Arecibo | Puerto Rico | 72013 | 1487 | |
760506 | 760506 | 2020-11-23 | Arecibo | Puerto Rico | 72013 | 1483 | |
757261 | 757261 | 2020-11-22 | Arecibo | Puerto Rico | 72013 | 1453 | |
754014 | 754014 | 2020-11-21 | Arecibo | Puerto Rico | 72013 | 1422 | |
750768 | 750768 | 2020-11-20 | Arecibo | Puerto Rico | 72013 | 1402 | |
747522 | 747522 | 2020-11-19 | Arecibo | Puerto Rico | 72013 | 1380 | |
744276 | 744276 | 2020-11-18 | Arecibo | Puerto Rico | 72013 | 1367 | |
741029 | 741029 | 2020-11-17 | Arecibo | Puerto Rico | 72013 | 1342 | |
737783 | 737783 | 2020-11-16 | Arecibo | Puerto Rico | 72013 | 1330 | |
734539 | 734539 | 2020-11-15 | Arecibo | Puerto Rico | 72013 | 1327 | |
731293 | 731293 | 2020-11-14 | Arecibo | Puerto Rico | 72013 | 1299 | |
728049 | 728049 | 2020-11-13 | Arecibo | Puerto Rico | 72013 | 1285 | |
724805 | 724805 | 2020-11-12 | Arecibo | Puerto Rico | 72013 | 1265 | |
721562 | 721562 | 2020-11-11 | Arecibo | Puerto Rico | 72013 | 1232 | |
718319 | 718319 | 2020-11-10 | Arecibo | Puerto Rico | 72013 | 1225 | |
715076 | 715076 | 2020-11-09 | Arecibo | Puerto Rico | 72013 | 1223 | |
711832 | 711832 | 2020-11-08 | Arecibo | Puerto Rico | 72013 | 1217 | |
708588 | 708588 | 2020-11-07 | Arecibo | Puerto Rico | 72013 | 1192 | |
705345 | 705345 | 2020-11-06 | Arecibo | Puerto Rico | 72013 | 1192 | |
702102 | 702102 | 2020-11-05 | Arecibo | Puerto Rico | 72013 | 1168 | |
698858 | 698858 | 2020-11-04 | Arecibo | Puerto Rico | 72013 | 1165 | |
695615 | 695615 | 2020-11-03 | Arecibo | Puerto Rico | 72013 | 1164 | |
692373 | 692373 | 2020-11-02 | Arecibo | Puerto Rico | 72013 | 1146 | |
689129 | 689129 | 2020-11-01 | Arecibo | Puerto Rico | 72013 | 1123 | |
685884 | 685884 | 2020-10-31 | Arecibo | Puerto Rico | 72013 | 1117 | |
682641 | 682641 | 2020-10-30 | Arecibo | Puerto Rico | 72013 | 1107 | |
679398 | 679398 | 2020-10-29 | Arecibo | Puerto Rico | 72013 | 1099 | |
676155 | 676155 | 2020-10-28 | Arecibo | Puerto Rico | 72013 | 1083 | |
672912 | 672912 | 2020-10-27 | Arecibo | Puerto Rico | 72013 | 1083 | |
669670 | 669670 | 2020-10-26 | Arecibo | Puerto Rico | 72013 | 1080 | |
666426 | 666426 | 2020-10-25 | Arecibo | Puerto Rico | 72013 | 1065 | |
663181 | 663181 | 2020-10-24 | Arecibo | Puerto Rico | 72013 | 1050 | |
659937 | 659937 | 2020-10-23 | Arecibo | Puerto Rico | 72013 | 1043 | |
656693 | 656693 | 2020-10-22 | Arecibo | Puerto Rico | 72013 | 1004 | |
653448 | 653448 | 2020-10-21 | Arecibo | Puerto Rico | 72013 | 998 | |
650203 | 650203 | 2020-10-20 | Arecibo | Puerto Rico | 72013 | 997 | |
646959 | 646959 | 2020-10-19 | Arecibo | Puerto Rico | 72013 | 993 | |
643713 | 643713 | 2020-10-18 | Arecibo | Puerto Rico | 72013 | 979 | |
640465 | 640465 | 2020-10-17 | Arecibo | Puerto Rico | 72013 | 975 | |
637219 | 637219 | 2020-10-16 | Arecibo | Puerto Rico | 72013 | 971 | |
633973 | 633973 | 2020-10-15 | Arecibo | Puerto Rico | 72013 | 969 | |
630728 | 630728 | 2020-10-14 | Arecibo | Puerto Rico | 72013 | 963 | |
627484 | 627484 | 2020-10-13 | Arecibo | Puerto Rico | 72013 | 957 | |
624242 | 624242 | 2020-10-12 | Arecibo | Puerto Rico | 72013 | 955 | |
620999 | 620999 | 2020-10-11 | Arecibo | Puerto Rico | 72013 | 952 | |
617756 | 617756 | 2020-10-10 | Arecibo | Puerto Rico | 72013 | 948 | |
614514 | 614514 | 2020-10-09 | Arecibo | Puerto Rico | 72013 | 939 | |
611273 | 611273 | 2020-10-08 | Arecibo | Puerto Rico | 72013 | 929 | |
608031 | 608031 | 2020-10-07 | Arecibo | Puerto Rico | 72013 | 917 | |
604788 | 604788 | 2020-10-06 | Arecibo | Puerto Rico | 72013 | 916 | |
601546 | 601546 | 2020-10-05 | Arecibo | Puerto Rico | 72013 | 908 |
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);