ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Cayey" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501931 | 2501931 | 2022-05-13 | Cayey | Puerto Rico | 72035 | 7260 | |
2498673 | 2498673 | 2022-05-12 | Cayey | Puerto Rico | 72035 | 7199 | |
2495415 | 2495415 | 2022-05-11 | Cayey | Puerto Rico | 72035 | 7124 | |
2492157 | 2492157 | 2022-05-10 | Cayey | Puerto Rico | 72035 | 7053 | |
2488899 | 2488899 | 2022-05-09 | Cayey | Puerto Rico | 72035 | 7041 | |
2485642 | 2485642 | 2022-05-08 | Cayey | Puerto Rico | 72035 | 6950 | |
2482384 | 2482384 | 2022-05-07 | Cayey | Puerto Rico | 72035 | 6950 | |
2479126 | 2479126 | 2022-05-06 | Cayey | Puerto Rico | 72035 | 6870 | |
2475868 | 2475868 | 2022-05-05 | Cayey | Puerto Rico | 72035 | 6774 | |
2472611 | 2472611 | 2022-05-04 | Cayey | Puerto Rico | 72035 | 6718 | |
2469355 | 2469355 | 2022-05-03 | Cayey | Puerto Rico | 72035 | 6637 | |
2466099 | 2466099 | 2022-05-02 | Cayey | Puerto Rico | 72035 | 6612 | |
2462844 | 2462844 | 2022-05-01 | Cayey | Puerto Rico | 72035 | 6585 | |
2459588 | 2459588 | 2022-04-30 | Cayey | Puerto Rico | 72035 | 6518 | |
2456332 | 2456332 | 2022-04-29 | Cayey | Puerto Rico | 72035 | 6473 | |
2453076 | 2453076 | 2022-04-28 | Cayey | Puerto Rico | 72035 | 6389 | |
2449820 | 2449820 | 2022-04-27 | Cayey | Puerto Rico | 72035 | 6335 | |
2446563 | 2446563 | 2022-04-26 | Cayey | Puerto Rico | 72035 | 6297 | |
2443308 | 2443308 | 2022-04-25 | Cayey | Puerto Rico | 72035 | 6283 | |
2440052 | 2440052 | 2022-04-24 | Cayey | Puerto Rico | 72035 | 6258 | |
2436796 | 2436796 | 2022-04-23 | Cayey | Puerto Rico | 72035 | 6189 | |
2433540 | 2433540 | 2022-04-22 | Cayey | Puerto Rico | 72035 | 6099 | |
2430284 | 2430284 | 2022-04-21 | Cayey | Puerto Rico | 72035 | 6016 | |
2427028 | 2427028 | 2022-04-20 | Cayey | Puerto Rico | 72035 | 5980 | |
2423772 | 2423772 | 2022-04-19 | Cayey | Puerto Rico | 72035 | 5943 | |
2420516 | 2420516 | 2022-04-18 | Cayey | Puerto Rico | 72035 | 5929 | |
2417260 | 2417260 | 2022-04-17 | Cayey | Puerto Rico | 72035 | 5902 | |
2414004 | 2414004 | 2022-04-16 | Cayey | Puerto Rico | 72035 | 5836 | |
2410748 | 2410748 | 2022-04-15 | Cayey | Puerto Rico | 72035 | 5836 | |
2407492 | 2407492 | 2022-04-14 | Cayey | Puerto Rico | 72035 | 5836 | |
2404236 | 2404236 | 2022-04-13 | Cayey | Puerto Rico | 72035 | 5813 | |
2400981 | 2400981 | 2022-04-12 | Cayey | Puerto Rico | 72035 | 5799 | |
2397726 | 2397726 | 2022-04-11 | Cayey | Puerto Rico | 72035 | 5799 | |
2394471 | 2394471 | 2022-04-10 | Cayey | Puerto Rico | 72035 | 5795 | |
2391215 | 2391215 | 2022-04-09 | Cayey | Puerto Rico | 72035 | 5774 | |
2387959 | 2387959 | 2022-04-08 | Cayey | Puerto Rico | 72035 | 5756 | |
2384704 | 2384704 | 2022-04-07 | Cayey | Puerto Rico | 72035 | 5742 | |
2381449 | 2381449 | 2022-04-06 | Cayey | Puerto Rico | 72035 | 5733 | |
2378194 | 2378194 | 2022-04-05 | Cayey | Puerto Rico | 72035 | 5721 | |
2374940 | 2374940 | 2022-04-04 | Cayey | Puerto Rico | 72035 | 5720 | |
2371688 | 2371688 | 2022-04-03 | Cayey | Puerto Rico | 72035 | 5718 | |
2368435 | 2368435 | 2022-04-02 | Cayey | Puerto Rico | 72035 | 5714 | |
2365182 | 2365182 | 2022-04-01 | Cayey | Puerto Rico | 72035 | 5710 | |
2361929 | 2361929 | 2022-03-31 | Cayey | Puerto Rico | 72035 | 5702 | |
2358675 | 2358675 | 2022-03-30 | Cayey | Puerto Rico | 72035 | 5701 | |
2355421 | 2355421 | 2022-03-29 | Cayey | Puerto Rico | 72035 | 5700 | |
2352168 | 2352168 | 2022-03-28 | Cayey | Puerto Rico | 72035 | 5697 | |
2348916 | 2348916 | 2022-03-27 | Cayey | Puerto Rico | 72035 | 5697 | |
2345663 | 2345663 | 2022-03-26 | Cayey | Puerto Rico | 72035 | 5698 | |
2342410 | 2342410 | 2022-03-25 | Cayey | Puerto Rico | 72035 | 5686 | |
2339157 | 2339157 | 2022-03-24 | Cayey | Puerto Rico | 72035 | 5683 | |
2335903 | 2335903 | 2022-03-23 | Cayey | Puerto Rico | 72035 | 5680 | |
2332649 | 2332649 | 2022-03-22 | Cayey | Puerto Rico | 72035 | 5678 | |
2329396 | 2329396 | 2022-03-21 | Cayey | Puerto Rico | 72035 | 5677 | |
2326144 | 2326144 | 2022-03-20 | Cayey | Puerto Rico | 72035 | 5674 | |
2322891 | 2322891 | 2022-03-19 | Cayey | Puerto Rico | 72035 | 5670 | |
2319637 | 2319637 | 2022-03-18 | Cayey | Puerto Rico | 72035 | 5668 | |
2316383 | 2316383 | 2022-03-17 | Cayey | Puerto Rico | 72035 | 5665 | |
2313130 | 2313130 | 2022-03-16 | Cayey | Puerto Rico | 72035 | 5660 | |
2309877 | 2309877 | 2022-03-15 | Cayey | Puerto Rico | 72035 | 5659 | |
2306624 | 2306624 | 2022-03-14 | Cayey | Puerto Rico | 72035 | 5656 | |
2303373 | 2303373 | 2022-03-13 | Cayey | Puerto Rico | 72035 | 5655 | |
2300121 | 2300121 | 2022-03-12 | Cayey | Puerto Rico | 72035 | 5650 | |
2296869 | 2296869 | 2022-03-11 | Cayey | Puerto Rico | 72035 | 5650 | |
2293617 | 2293617 | 2022-03-10 | Cayey | Puerto Rico | 72035 | 5651 | |
2290365 | 2290365 | 2022-03-09 | Cayey | Puerto Rico | 72035 | 5649 | |
2287113 | 2287113 | 2022-03-08 | Cayey | Puerto Rico | 72035 | 5646 | |
2283861 | 2283861 | 2022-03-07 | Cayey | Puerto Rico | 72035 | 5645 | |
2280609 | 2280609 | 2022-03-06 | Cayey | Puerto Rico | 72035 | 5645 | |
2277356 | 2277356 | 2022-03-05 | Cayey | Puerto Rico | 72035 | 5644 | |
2274103 | 2274103 | 2022-03-04 | Cayey | Puerto Rico | 72035 | 5642 | |
2270850 | 2270850 | 2022-03-03 | Cayey | Puerto Rico | 72035 | 5640 | |
2267598 | 2267598 | 2022-03-02 | Cayey | Puerto Rico | 72035 | 5638 | |
2264345 | 2264345 | 2022-03-01 | Cayey | Puerto Rico | 72035 | 5635 | |
2261095 | 2261095 | 2022-02-28 | Cayey | Puerto Rico | 72035 | 5635 | |
2257844 | 2257844 | 2022-02-27 | Cayey | Puerto Rico | 72035 | 5635 | |
2254593 | 2254593 | 2022-02-26 | Cayey | Puerto Rico | 72035 | 5635 | |
2251342 | 2251342 | 2022-02-25 | Cayey | Puerto Rico | 72035 | 5627 | |
2248091 | 2248091 | 2022-02-24 | Cayey | Puerto Rico | 72035 | 5626 | |
2244840 | 2244840 | 2022-02-23 | Cayey | Puerto Rico | 72035 | 5623 | |
2241589 | 2241589 | 2022-02-22 | Cayey | Puerto Rico | 72035 | 5622 | |
2238338 | 2238338 | 2022-02-21 | Cayey | Puerto Rico | 72035 | 5623 | |
2235087 | 2235087 | 2022-02-20 | Cayey | Puerto Rico | 72035 | 5621 | |
2231836 | 2231836 | 2022-02-19 | Cayey | Puerto Rico | 72035 | 5616 | |
2228585 | 2228585 | 2022-02-18 | Cayey | Puerto Rico | 72035 | 5608 | |
2225334 | 2225334 | 2022-02-17 | Cayey | Puerto Rico | 72035 | 5602 | |
2222083 | 2222083 | 2022-02-16 | Cayey | Puerto Rico | 72035 | 5596 | |
2218832 | 2218832 | 2022-02-15 | Cayey | Puerto Rico | 72035 | 5583 | |
2215581 | 2215581 | 2022-02-14 | Cayey | Puerto Rico | 72035 | 5584 | |
2212330 | 2212330 | 2022-02-13 | Cayey | Puerto Rico | 72035 | 5583 | |
2209077 | 2209077 | 2022-02-12 | Cayey | Puerto Rico | 72035 | 5573 | |
2205824 | 2205824 | 2022-02-11 | Cayey | Puerto Rico | 72035 | 5565 | |
2202571 | 2202571 | 2022-02-10 | Cayey | Puerto Rico | 72035 | 5559 | |
2199317 | 2199317 | 2022-02-09 | Cayey | Puerto Rico | 72035 | 5549 | |
2196063 | 2196063 | 2022-02-08 | Cayey | Puerto Rico | 72035 | 5539 | |
2192809 | 2192809 | 2022-02-07 | Cayey | Puerto Rico | 72035 | 5538 | |
2189555 | 2189555 | 2022-02-06 | Cayey | Puerto Rico | 72035 | 5537 | |
2186302 | 2186302 | 2022-02-05 | Cayey | Puerto Rico | 72035 | 5523 | |
2183050 | 2183050 | 2022-02-04 | Cayey | Puerto Rico | 72035 | 5519 | |
2179798 | 2179798 | 2022-02-03 | Cayey | Puerto Rico | 72035 | 5502 |
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);