ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Unknown" 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 |
---|---|---|---|---|---|---|---|
2176601 | 2176601 | 2022-02-02 | Unknown | Puerto Rico | 16227 | 3887 | |
2173347 | 2173347 | 2022-02-01 | Unknown | Puerto Rico | 16182 | 3867 | |
2170095 | 2170095 | 2022-01-31 | Unknown | Puerto Rico | 16182 | 3855 | |
2166841 | 2166841 | 2022-01-30 | Unknown | Puerto Rico | 16153 | 3854 | |
2163586 | 2163586 | 2022-01-29 | Unknown | Puerto Rico | 16104 | 3837 | |
2160331 | 2160331 | 2022-01-28 | Unknown | Puerto Rico | 16039 | 3809 | |
2157075 | 2157075 | 2022-01-27 | Unknown | Puerto Rico | 15918 | 3773 | |
2153822 | 2153822 | 2022-01-26 | Unknown | Puerto Rico | 15846 | 3754 | |
2150570 | 2150570 | 2022-01-25 | Unknown | Puerto Rico | 15711 | 3731 | |
2147318 | 2147318 | 2022-01-24 | Unknown | Puerto Rico | 15684 | 3704 | |
2144064 | 2144064 | 2022-01-23 | Unknown | Puerto Rico | 15575 | 3696 | |
2140809 | 2140809 | 2022-01-22 | Unknown | Puerto Rico | 15366 | 3673 | |
2137553 | 2137553 | 2022-01-21 | Unknown | Puerto Rico | 15161 | 3631 | |
2134299 | 2134299 | 2022-01-20 | Unknown | Puerto Rico | 15026 | 3593 | |
2131047 | 2131047 | 2022-01-19 | Unknown | Puerto Rico | 14849 | 3563 | |
2127793 | 2127793 | 2022-01-18 | Unknown | Puerto Rico | 14613 | 3542 | |
2124541 | 2124541 | 2022-01-17 | Unknown | Puerto Rico | 14598 | 3520 | |
2121289 | 2121289 | 2022-01-16 | Unknown | Puerto Rico | 14380 | 3511 | |
2118037 | 2118037 | 2022-01-15 | Unknown | Puerto Rico | 14155 | 3493 | |
2114786 | 2114786 | 2022-01-14 | Unknown | Puerto Rico | 13795 | 3473 | |
2111534 | 2111534 | 2022-01-13 | Unknown | Puerto Rico | 13352 | 3446 | |
2108282 | 2108282 | 2022-01-12 | Unknown | Puerto Rico | 12954 | 3421 | |
2105031 | 2105031 | 2022-01-11 | Unknown | Puerto Rico | 12551 | 3393 | |
2101780 | 2101780 | 2022-01-10 | Unknown | Puerto Rico | 12498 | 3373 | |
2098529 | 2098529 | 2022-01-09 | Unknown | Puerto Rico | 12201 | 3373 | |
2095277 | 2095277 | 2022-01-08 | Unknown | Puerto Rico | 11825 | 3361 | |
2092025 | 2092025 | 2022-01-07 | Unknown | Puerto Rico | 11493 | 3357 | |
2088773 | 2088773 | 2022-01-06 | Unknown | Puerto Rico | 11050 | 3338 | |
2085522 | 2085522 | 2022-01-05 | Unknown | Puerto Rico | 10528 | 3324 | |
2082270 | 2082270 | 2022-01-04 | Unknown | Puerto Rico | 10221 | 3318 | |
2079018 | 2079018 | 2022-01-03 | Unknown | Puerto Rico | 10085 | 3314 | |
2075767 | 2075767 | 2022-01-02 | Unknown | Puerto Rico | 9912 | 3310 | |
2072516 | 2072516 | 2022-01-01 | Unknown | Puerto Rico | 8679 | 3308 | |
2069265 | 2069265 | 2021-12-31 | Unknown | Puerto Rico | 8679 | 3305 | |
2066014 | 2066014 | 2021-12-30 | Unknown | Puerto Rico | 8108 | 3298 | |
2062764 | 2062764 | 2021-12-29 | Unknown | Puerto Rico | 7590 | 3295 | |
2059514 | 2059514 | 2021-12-28 | Unknown | Puerto Rico | 7284 | 3292 | |
2056265 | 2056265 | 2021-12-27 | Unknown | Puerto Rico | 7183 | 3291 | |
2053016 | 2053016 | 2021-12-26 | Unknown | Puerto Rico | 7102 | 3291 | |
2049766 | 2049766 | 2021-12-25 | Unknown | Puerto Rico | 6883 | 3291 | |
2046516 | 2046516 | 2021-12-24 | Unknown | Puerto Rico | 6382 | 3288 | |
2043266 | 2043266 | 2021-12-23 | Unknown | Puerto Rico | 6383 | 3288 | |
2040017 | 2040017 | 2021-12-22 | Unknown | Puerto Rico | 6223 | 3287 | |
2036767 | 2036767 | 2021-12-21 | Unknown | Puerto Rico | 6120 | 3287 | |
2033517 | 2033517 | 2021-12-20 | Unknown | Puerto Rico | 6100 | 3286 | |
2030267 | 2030267 | 2021-12-19 | Unknown | Puerto Rico | 6030 | 3285 | |
2027016 | 2027016 | 2021-12-18 | Unknown | Puerto Rico | 5959 | 3284 | |
2023765 | 2023765 | 2021-12-17 | Unknown | Puerto Rico | 5869 | 3279 | |
2020514 | 2020514 | 2021-12-16 | Unknown | Puerto Rico | 5831 | 3278 | |
2017263 | 2017263 | 2021-12-15 | Unknown | Puerto Rico | 5809 | 3277 | |
2014013 | 2014013 | 2021-12-14 | Unknown | Puerto Rico | 5797 | 3276 | |
2010762 | 2010762 | 2021-12-13 | Unknown | Puerto Rico | 5792 | 3276 | |
2007511 | 2007511 | 2021-12-12 | Unknown | Puerto Rico | 5792 | 3276 | |
2004260 | 2004260 | 2021-12-11 | Unknown | Puerto Rico | 5785 | 3274 | |
2001009 | 2001009 | 2021-12-10 | Unknown | Puerto Rico | 5785 | 3274 | |
1997759 | 1997759 | 2021-12-09 | Unknown | Puerto Rico | 5781 | 3274 | |
1994508 | 1994508 | 2021-12-08 | Unknown | Puerto Rico | 5782 | 3274 | |
1991257 | 1991257 | 2021-12-07 | Unknown | Puerto Rico | 5773 | 3274 | |
1988006 | 1988006 | 2021-12-06 | Unknown | Puerto Rico | 5773 | 3273 | |
1984756 | 1984756 | 2021-12-05 | Unknown | Puerto Rico | 5772 | 3273 | |
1981506 | 1981506 | 2021-12-04 | Unknown | Puerto Rico | 5768 | 3272 | |
1978256 | 1978256 | 2021-12-03 | Unknown | Puerto Rico | 5763 | 3272 | |
1975006 | 1975006 | 2021-12-02 | Unknown | Puerto Rico | 5749 | 3271 | |
1971757 | 1971757 | 2021-12-01 | Unknown | Puerto Rico | 5713 | 3270 | |
1968507 | 1968507 | 2021-11-30 | Unknown | Puerto Rico | 5712 | 3270 | |
1965256 | 1965256 | 2021-11-29 | Unknown | Puerto Rico | 5712 | 3269 | |
1962004 | 1962004 | 2021-11-28 | Unknown | Puerto Rico | 5710 | 3269 | |
1958753 | 1958753 | 2021-11-27 | Unknown | Puerto Rico | 5710 | 3268 | |
1955502 | 1955502 | 2021-11-26 | Unknown | Puerto Rico | 5682 | 3266 | |
1952251 | 1952251 | 2021-11-25 | Unknown | Puerto Rico | 5687 | 3266 | |
1949000 | 1949000 | 2021-11-24 | Unknown | Puerto Rico | 5678 | 3266 | |
1945749 | 1945749 | 2021-11-23 | Unknown | Puerto Rico | 5680 | 3264 | |
1942498 | 1942498 | 2021-11-22 | Unknown | Puerto Rico | 5680 | 3263 | |
1939248 | 1939248 | 2021-11-21 | Unknown | Puerto Rico | 5679 | 3262 | |
1935998 | 1935998 | 2021-11-20 | Unknown | Puerto Rico | 5676 | 3261 | |
1932748 | 1932748 | 2021-11-19 | Unknown | Puerto Rico | 5611 | 3260 | |
1929497 | 1929497 | 2021-11-18 | Unknown | Puerto Rico | 5557 | 3259 | |
1926247 | 1926247 | 2021-11-17 | Unknown | Puerto Rico | 5571 | 3259 | |
1922997 | 1922997 | 2021-11-16 | Unknown | Puerto Rico | 5570 | 3258 | |
1919748 | 1919748 | 2021-11-15 | Unknown | Puerto Rico | 5574 | 3257 | |
1916498 | 1916498 | 2021-11-14 | Unknown | Puerto Rico | 5571 | 3257 | |
1913248 | 1913248 | 2021-11-13 | Unknown | Puerto Rico | 5566 | 3257 | |
1909998 | 1909998 | 2021-11-12 | Unknown | Puerto Rico | 5474 | 3256 | |
1906749 | 1906749 | 2021-11-11 | Unknown | Puerto Rico | 5474 | 3252 | |
1903500 | 1903500 | 2021-11-10 | Unknown | Puerto Rico | 5477 | 3247 | |
1900250 | 1900250 | 2021-11-09 | Unknown | Puerto Rico | 5476 | 3247 | |
1897000 | 1897000 | 2021-11-08 | Unknown | Puerto Rico | 5476 | 3246 | |
1893750 | 1893750 | 2021-11-07 | Unknown | Puerto Rico | 5472 | 3245 | |
1890500 | 1890500 | 2021-11-06 | Unknown | Puerto Rico | 5470 | 3244 | |
1887250 | 1887250 | 2021-11-05 | Unknown | Puerto Rico | 5422 | 3239 | |
1884000 | 1884000 | 2021-11-04 | Unknown | Puerto Rico | 5422 | 3239 | |
1880751 | 1880751 | 2021-11-03 | Unknown | Puerto Rico | 5389 | 3236 | |
1877502 | 1877502 | 2021-11-02 | Unknown | Puerto Rico | 5389 | 3234 | |
1874253 | 1874253 | 2021-11-01 | Unknown | Puerto Rico | 5390 | 3234 | |
1871004 | 1871004 | 2021-10-31 | Unknown | Puerto Rico | 5389 | 3234 | |
1867755 | 1867755 | 2021-10-30 | Unknown | Puerto Rico | 5388 | 3232 | |
1864506 | 1864506 | 2021-10-29 | Unknown | Puerto Rico | 5387 | 3229 | |
1861257 | 1861257 | 2021-10-28 | Unknown | Puerto Rico | 5386 | 3228 | |
1858008 | 1858008 | 2021-10-27 | Unknown | Puerto Rico | 5386 | 3227 | |
1854759 | 1854759 | 2021-10-26 | Unknown | Puerto Rico | 5385 | 3223 |
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);