ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Canovanas" 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 |
---|---|---|---|---|---|---|---|
1279888 | 1279888 | 2021-05-02 | Canovanas | Puerto Rico | 72029 | 2275 | |
1276641 | 1276641 | 2021-05-01 | Canovanas | Puerto Rico | 72029 | 2267 | |
1273394 | 1273394 | 2021-04-30 | Canovanas | Puerto Rico | 72029 | 2262 | |
1270147 | 1270147 | 2021-04-29 | Canovanas | Puerto Rico | 72029 | 2254 | |
1266900 | 1266900 | 2021-04-28 | Canovanas | Puerto Rico | 72029 | 2248 | |
1263653 | 1263653 | 2021-04-27 | Canovanas | Puerto Rico | 72029 | 2236 | |
1260406 | 1260406 | 2021-04-26 | Canovanas | Puerto Rico | 72029 | 2219 | |
1257159 | 1257159 | 2021-04-25 | Canovanas | Puerto Rico | 72029 | 2201 | |
1253912 | 1253912 | 2021-04-24 | Canovanas | Puerto Rico | 72029 | 2187 | |
1250665 | 1250665 | 2021-04-23 | Canovanas | Puerto Rico | 72029 | 2154 | |
1247418 | 1247418 | 2021-04-22 | Canovanas | Puerto Rico | 72029 | 2135 | |
1244171 | 1244171 | 2021-04-21 | Canovanas | Puerto Rico | 72029 | 2120 | |
1240924 | 1240924 | 2021-04-20 | Canovanas | Puerto Rico | 72029 | 2104 | |
1237677 | 1237677 | 2021-04-19 | Canovanas | Puerto Rico | 72029 | 2087 | |
1234430 | 1234430 | 2021-04-18 | Canovanas | Puerto Rico | 72029 | 2052 | |
1231182 | 1231182 | 2021-04-17 | Canovanas | Puerto Rico | 72029 | 2028 | |
1227934 | 1227934 | 2021-04-16 | Canovanas | Puerto Rico | 72029 | 2011 | |
1224686 | 1224686 | 2021-04-15 | Canovanas | Puerto Rico | 72029 | 1994 | |
1221439 | 1221439 | 2021-04-14 | Canovanas | Puerto Rico | 72029 | 1986 | |
1218191 | 1218191 | 2021-04-13 | Canovanas | Puerto Rico | 72029 | 1979 | |
1214943 | 1214943 | 2021-04-12 | Canovanas | Puerto Rico | 72029 | 1965 | |
1211696 | 1211696 | 2021-04-11 | Canovanas | Puerto Rico | 72029 | 1950 | |
1208447 | 1208447 | 2021-04-10 | Canovanas | Puerto Rico | 72029 | 1944 | |
1205199 | 1205199 | 2021-04-09 | Canovanas | Puerto Rico | 72029 | 1934 | |
1201951 | 1201951 | 2021-04-08 | Canovanas | Puerto Rico | 72029 | 1917 | |
1198702 | 1198702 | 2021-04-07 | Canovanas | Puerto Rico | 72029 | 1916 | |
1195453 | 1195453 | 2021-04-06 | Canovanas | Puerto Rico | 72029 | 1916 | |
1192205 | 1192205 | 2021-04-05 | Canovanas | Puerto Rico | 72029 | 1916 | |
1188956 | 1188956 | 2021-04-04 | Canovanas | Puerto Rico | 72029 | 1909 | |
1185709 | 1185709 | 2021-04-03 | Canovanas | Puerto Rico | 72029 | 1900 | |
1182462 | 1182462 | 2021-04-02 | Canovanas | Puerto Rico | 72029 | 1885 | |
1179215 | 1179215 | 2021-04-01 | Canovanas | Puerto Rico | 72029 | 1874 | |
1175968 | 1175968 | 2021-03-31 | Canovanas | Puerto Rico | 72029 | 1873 | |
1172721 | 1172721 | 2021-03-30 | Canovanas | Puerto Rico | 72029 | 1867 | |
1169474 | 1169474 | 2021-03-29 | Canovanas | Puerto Rico | 72029 | 1864 | |
1166226 | 1166226 | 2021-03-28 | Canovanas | Puerto Rico | 72029 | 1853 | |
1162978 | 1162978 | 2021-03-27 | Canovanas | Puerto Rico | 72029 | 1851 | |
1159729 | 1159729 | 2021-03-26 | Canovanas | Puerto Rico | 72029 | 1842 | |
1156482 | 1156482 | 2021-03-25 | Canovanas | Puerto Rico | 72029 | 1836 | |
1153235 | 1153235 | 2021-03-24 | Canovanas | Puerto Rico | 72029 | 1835 | |
1149988 | 1149988 | 2021-03-23 | Canovanas | Puerto Rico | 72029 | 1829 | |
1146741 | 1146741 | 2021-03-22 | Canovanas | Puerto Rico | 72029 | 1825 | |
1143494 | 1143494 | 2021-03-21 | Canovanas | Puerto Rico | 72029 | 1819 | |
1140247 | 1140247 | 2021-03-20 | Canovanas | Puerto Rico | 72029 | 1812 | |
1137001 | 1137001 | 2021-03-19 | Canovanas | Puerto Rico | 72029 | 1809 | |
1133755 | 1133755 | 2021-03-18 | Canovanas | Puerto Rico | 72029 | 1801 | |
1130507 | 1130507 | 2021-03-17 | Canovanas | Puerto Rico | 72029 | 1794 | |
1127260 | 1127260 | 2021-03-16 | Canovanas | Puerto Rico | 72029 | 1793 | |
1124014 | 1124014 | 2021-03-15 | Canovanas | Puerto Rico | 72029 | 1789 | |
1120768 | 1120768 | 2021-03-14 | Canovanas | Puerto Rico | 72029 | 1785 | |
1117521 | 1117521 | 2021-03-13 | Canovanas | Puerto Rico | 72029 | 1780 | |
1114274 | 1114274 | 2021-03-12 | Canovanas | Puerto Rico | 72029 | 1781 | |
1111028 | 1111028 | 2021-03-11 | Canovanas | Puerto Rico | 72029 | 1768 | |
1107782 | 1107782 | 2021-03-10 | Canovanas | Puerto Rico | 72029 | 1764 | |
1104536 | 1104536 | 2021-03-09 | Canovanas | Puerto Rico | 72029 | 1764 | |
1101290 | 1101290 | 2021-03-08 | Canovanas | Puerto Rico | 72029 | 1764 | |
1098044 | 1098044 | 2021-03-07 | Canovanas | Puerto Rico | 72029 | 1760 | |
1094796 | 1094796 | 2021-03-06 | Canovanas | Puerto Rico | 72029 | 1760 | |
1091550 | 1091550 | 2021-03-05 | Canovanas | Puerto Rico | 72029 | 1758 | |
1088304 | 1088304 | 2021-03-04 | Canovanas | Puerto Rico | 72029 | 1758 | |
1085059 | 1085059 | 2021-03-03 | Canovanas | Puerto Rico | 72029 | 1758 | |
1081813 | 1081813 | 2021-03-02 | Canovanas | Puerto Rico | 72029 | 1758 | |
1078567 | 1078567 | 2021-03-01 | Canovanas | Puerto Rico | 72029 | 1757 | |
1075322 | 1075322 | 2021-02-28 | Canovanas | Puerto Rico | 72029 | 1755 | |
1072076 | 1072076 | 2021-02-27 | Canovanas | Puerto Rico | 72029 | 1754 | |
1068830 | 1068830 | 2021-02-26 | Canovanas | Puerto Rico | 72029 | 1752 | |
1065585 | 1065585 | 2021-02-25 | Canovanas | Puerto Rico | 72029 | 1751 | |
1062340 | 1062340 | 2021-02-24 | Canovanas | Puerto Rico | 72029 | 1750 | |
1059095 | 1059095 | 2021-02-23 | Canovanas | Puerto Rico | 72029 | 1750 | |
1055849 | 1055849 | 2021-02-22 | Canovanas | Puerto Rico | 72029 | 1747 | |
1052603 | 1052603 | 2021-02-21 | Canovanas | Puerto Rico | 72029 | 1746 | |
1049356 | 1049356 | 2021-02-20 | Canovanas | Puerto Rico | 72029 | 1743 | |
1046109 | 1046109 | 2021-02-19 | Canovanas | Puerto Rico | 72029 | 1742 | |
1042864 | 1042864 | 2021-02-18 | Canovanas | Puerto Rico | 72029 | 1743 | |
1039619 | 1039619 | 2021-02-17 | Canovanas | Puerto Rico | 72029 | 1740 | |
1036374 | 1036374 | 2021-02-16 | Canovanas | Puerto Rico | 72029 | 1740 | |
1033129 | 1033129 | 2021-02-15 | Canovanas | Puerto Rico | 72029 | 1738 | |
1029883 | 1029883 | 2021-02-14 | Canovanas | Puerto Rico | 72029 | 1736 | |
1026636 | 1026636 | 2021-02-13 | Canovanas | Puerto Rico | 72029 | 1735 | |
1023391 | 1023391 | 2021-02-12 | Canovanas | Puerto Rico | 72029 | 1730 | |
1020146 | 1020146 | 2021-02-11 | Canovanas | Puerto Rico | 72029 | 1730 | |
1016901 | 1016901 | 2021-02-10 | Canovanas | Puerto Rico | 72029 | 1729 | |
1013656 | 1013656 | 2021-02-09 | Canovanas | Puerto Rico | 72029 | 1729 | |
1010411 | 1010411 | 2021-02-08 | Canovanas | Puerto Rico | 72029 | 1727 | |
1007165 | 1007165 | 2021-02-07 | Canovanas | Puerto Rico | 72029 | 1724 | |
1003919 | 1003919 | 2021-02-06 | Canovanas | Puerto Rico | 72029 | 1722 | |
1000673 | 1000673 | 2021-02-05 | Canovanas | Puerto Rico | 72029 | 1713 | |
997427 | 997427 | 2021-02-04 | Canovanas | Puerto Rico | 72029 | 1712 | |
994181 | 994181 | 2021-02-03 | Canovanas | Puerto Rico | 72029 | 1706 | |
990935 | 990935 | 2021-02-02 | Canovanas | Puerto Rico | 72029 | 1704 | |
987689 | 987689 | 2021-02-01 | Canovanas | Puerto Rico | 72029 | 1701 | |
984442 | 984442 | 2021-01-31 | Canovanas | Puerto Rico | 72029 | 1696 | |
981195 | 981195 | 2021-01-30 | Canovanas | Puerto Rico | 72029 | 1696 | |
977949 | 977949 | 2021-01-29 | Canovanas | Puerto Rico | 72029 | 1693 | |
974704 | 974704 | 2021-01-28 | Canovanas | Puerto Rico | 72029 | 1682 | |
971459 | 971459 | 2021-01-27 | Canovanas | Puerto Rico | 72029 | 1680 | |
968214 | 968214 | 2021-01-26 | Canovanas | Puerto Rico | 72029 | 1676 | |
964970 | 964970 | 2021-01-25 | Canovanas | Puerto Rico | 72029 | 1672 | |
961725 | 961725 | 2021-01-24 | Canovanas | Puerto Rico | 72029 | 1669 | |
958480 | 958480 | 2021-01-23 | Canovanas | Puerto Rico | 72029 | 1650 |
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);