ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Juncos" 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 |
---|---|---|---|---|---|---|---|
1065610 | 1065610 | 2021-02-25 | Juncos | Puerto Rico | 72077 | 1726 | |
1062365 | 1062365 | 2021-02-24 | Juncos | Puerto Rico | 72077 | 1721 | |
1059120 | 1059120 | 2021-02-23 | Juncos | Puerto Rico | 72077 | 1721 | |
1055874 | 1055874 | 2021-02-22 | Juncos | Puerto Rico | 72077 | 1718 | |
1052628 | 1052628 | 2021-02-21 | Juncos | Puerto Rico | 72077 | 1713 | |
1049381 | 1049381 | 2021-02-20 | Juncos | Puerto Rico | 72077 | 1712 | |
1046134 | 1046134 | 2021-02-19 | Juncos | Puerto Rico | 72077 | 1707 | |
1042889 | 1042889 | 2021-02-18 | Juncos | Puerto Rico | 72077 | 1701 | |
1039644 | 1039644 | 2021-02-17 | Juncos | Puerto Rico | 72077 | 1699 | |
1036399 | 1036399 | 2021-02-16 | Juncos | Puerto Rico | 72077 | 1697 | |
1033154 | 1033154 | 2021-02-15 | Juncos | Puerto Rico | 72077 | 1691 | |
1029908 | 1029908 | 2021-02-14 | Juncos | Puerto Rico | 72077 | 1689 | |
1026661 | 1026661 | 2021-02-13 | Juncos | Puerto Rico | 72077 | 1682 | |
1023416 | 1023416 | 2021-02-12 | Juncos | Puerto Rico | 72077 | 1674 | |
1020171 | 1020171 | 2021-02-11 | Juncos | Puerto Rico | 72077 | 1666 | |
1016926 | 1016926 | 2021-02-10 | Juncos | Puerto Rico | 72077 | 1664 | |
1013681 | 1013681 | 2021-02-09 | Juncos | Puerto Rico | 72077 | 1662 | |
1010436 | 1010436 | 2021-02-08 | Juncos | Puerto Rico | 72077 | 1646 | |
1007190 | 1007190 | 2021-02-07 | Juncos | Puerto Rico | 72077 | 1632 | |
1003944 | 1003944 | 2021-02-06 | Juncos | Puerto Rico | 72077 | 1623 | |
1000698 | 1000698 | 2021-02-05 | Juncos | Puerto Rico | 72077 | 1621 | |
997452 | 997452 | 2021-02-04 | Juncos | Puerto Rico | 72077 | 1620 | |
994206 | 994206 | 2021-02-03 | Juncos | Puerto Rico | 72077 | 1616 | |
990960 | 990960 | 2021-02-02 | Juncos | Puerto Rico | 72077 | 1613 | |
987714 | 987714 | 2021-02-01 | Juncos | Puerto Rico | 72077 | 1597 | |
984467 | 984467 | 2021-01-31 | Juncos | Puerto Rico | 72077 | 1579 | |
981220 | 981220 | 2021-01-30 | Juncos | Puerto Rico | 72077 | 1573 | |
977974 | 977974 | 2021-01-29 | Juncos | Puerto Rico | 72077 | 1566 | |
974729 | 974729 | 2021-01-28 | Juncos | Puerto Rico | 72077 | 1560 | |
971484 | 971484 | 2021-01-27 | Juncos | Puerto Rico | 72077 | 1559 | |
968239 | 968239 | 2021-01-26 | Juncos | Puerto Rico | 72077 | 1558 | |
964995 | 964995 | 2021-01-25 | Juncos | Puerto Rico | 72077 | 1555 | |
961750 | 961750 | 2021-01-24 | Juncos | Puerto Rico | 72077 | 1539 | |
958505 | 958505 | 2021-01-23 | Juncos | Puerto Rico | 72077 | 1526 | |
955259 | 955259 | 2021-01-22 | Juncos | Puerto Rico | 72077 | 1518 | |
952014 | 952014 | 2021-01-21 | Juncos | Puerto Rico | 72077 | 1514 | |
948769 | 948769 | 2021-01-20 | Juncos | Puerto Rico | 72077 | 1513 | |
945523 | 945523 | 2021-01-19 | Juncos | Puerto Rico | 72077 | 1512 | |
942276 | 942276 | 2021-01-18 | Juncos | Puerto Rico | 72077 | 1509 | |
939031 | 939031 | 2021-01-17 | Juncos | Puerto Rico | 72077 | 1504 | |
935786 | 935786 | 2021-01-16 | Juncos | Puerto Rico | 72077 | 1492 | |
932541 | 932541 | 2021-01-15 | Juncos | Puerto Rico | 72077 | 1491 | |
929296 | 929296 | 2021-01-14 | Juncos | Puerto Rico | 72077 | 1473 | |
926051 | 926051 | 2021-01-13 | Juncos | Puerto Rico | 72077 | 1473 | |
922805 | 922805 | 2021-01-12 | Juncos | Puerto Rico | 72077 | 1471 | |
919560 | 919560 | 2021-01-11 | Juncos | Puerto Rico | 72077 | 1465 | |
916315 | 916315 | 2021-01-10 | Juncos | Puerto Rico | 72077 | 1466 | |
913070 | 913070 | 2021-01-09 | Juncos | Puerto Rico | 72077 | 1464 | |
909825 | 909825 | 2021-01-08 | Juncos | Puerto Rico | 72077 | 1441 | |
906580 | 906580 | 2021-01-07 | Juncos | Puerto Rico | 72077 | 1420 | |
903334 | 903334 | 2021-01-06 | Juncos | Puerto Rico | 72077 | 1416 | |
900089 | 900089 | 2021-01-05 | Juncos | Puerto Rico | 72077 | 1414 | |
896844 | 896844 | 2021-01-04 | Juncos | Puerto Rico | 72077 | 1412 | |
893598 | 893598 | 2021-01-03 | Juncos | Puerto Rico | 72077 | 1408 | |
890352 | 890352 | 2021-01-02 | Juncos | Puerto Rico | 72077 | 1404 | |
887105 | 887105 | 2021-01-01 | Juncos | Puerto Rico | 72077 | 1394 | |
883860 | 883860 | 2020-12-31 | Juncos | Puerto Rico | 72077 | 1380 | |
880615 | 880615 | 2020-12-30 | Juncos | Puerto Rico | 72077 | 1377 | |
877370 | 877370 | 2020-12-29 | Juncos | Puerto Rico | 72077 | 1376 | |
874125 | 874125 | 2020-12-28 | Juncos | Puerto Rico | 72077 | 1211 | |
870880 | 870880 | 2020-12-27 | Juncos | Puerto Rico | 72077 | 1110 | |
867635 | 867635 | 2020-12-26 | Juncos | Puerto Rico | 72077 | 1088 | |
864390 | 864390 | 2020-12-25 | Juncos | Puerto Rico | 72077 | 1080 | |
861145 | 861145 | 2020-12-24 | Juncos | Puerto Rico | 72077 | 1077 | |
857900 | 857900 | 2020-12-23 | Juncos | Puerto Rico | 72077 | 1075 | |
854655 | 854655 | 2020-12-22 | Juncos | Puerto Rico | 72077 | 1057 | |
851410 | 851410 | 2020-12-21 | Juncos | Puerto Rico | 72077 | 1002 | |
848165 | 848165 | 2020-12-20 | Juncos | Puerto Rico | 72077 | 991 | |
844920 | 844920 | 2020-12-19 | Juncos | Puerto Rico | 72077 | 986 | |
841674 | 841674 | 2020-12-18 | Juncos | Puerto Rico | 72077 | 980 | |
838429 | 838429 | 2020-12-17 | Juncos | Puerto Rico | 72077 | 971 | |
835183 | 835183 | 2020-12-16 | Juncos | Puerto Rico | 72077 | 967 | |
831937 | 831937 | 2020-12-15 | Juncos | Puerto Rico | 72077 | 961 | |
828690 | 828690 | 2020-12-14 | Juncos | Puerto Rico | 72077 | 959 | |
825444 | 825444 | 2020-12-13 | Juncos | Puerto Rico | 72077 | 958 | |
822197 | 822197 | 2020-12-12 | Juncos | Puerto Rico | 72077 | 957 | |
818951 | 818951 | 2020-12-11 | Juncos | Puerto Rico | 72077 | 946 | |
815705 | 815705 | 2020-12-10 | Juncos | Puerto Rico | 72077 | 936 | |
812459 | 812459 | 2020-12-09 | Juncos | Puerto Rico | 72077 | 932 | |
809215 | 809215 | 2020-12-08 | Juncos | Puerto Rico | 72077 | 925 | |
805970 | 805970 | 2020-12-07 | Juncos | Puerto Rico | 72077 | 911 | |
802725 | 802725 | 2020-12-06 | Juncos | Puerto Rico | 72077 | 899 | |
799480 | 799480 | 2020-12-05 | Juncos | Puerto Rico | 72077 | 889 | |
796235 | 796235 | 2020-12-04 | Juncos | Puerto Rico | 72077 | 876 | |
792990 | 792990 | 2020-12-03 | Juncos | Puerto Rico | 72077 | 859 | |
789745 | 789745 | 2020-12-02 | Juncos | Puerto Rico | 72077 | 847 | |
786500 | 786500 | 2020-12-01 | Juncos | Puerto Rico | 72077 | 831 | |
783256 | 783256 | 2020-11-30 | Juncos | Puerto Rico | 72077 | 827 | |
780011 | 780011 | 2020-11-29 | Juncos | Puerto Rico | 72077 | 819 | |
776765 | 776765 | 2020-11-28 | Juncos | Puerto Rico | 72077 | 817 | |
773520 | 773520 | 2020-11-27 | Juncos | Puerto Rico | 72077 | 808 | |
770275 | 770275 | 2020-11-26 | Juncos | Puerto Rico | 72077 | 793 | |
767029 | 767029 | 2020-11-25 | Juncos | Puerto Rico | 72077 | 788 | |
763784 | 763784 | 2020-11-24 | Juncos | Puerto Rico | 72077 | 785 | |
760539 | 760539 | 2020-11-23 | Juncos | Puerto Rico | 72077 | 782 | |
757294 | 757294 | 2020-11-22 | Juncos | Puerto Rico | 72077 | 781 | |
754047 | 754047 | 2020-11-21 | Juncos | Puerto Rico | 72077 | 772 | |
750801 | 750801 | 2020-11-20 | Juncos | Puerto Rico | 72077 | 760 | |
747555 | 747555 | 2020-11-19 | Juncos | Puerto Rico | 72077 | 750 | |
744309 | 744309 | 2020-11-18 | Juncos | Puerto Rico | 72077 | 734 |
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);