ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72025 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 |
---|---|---|---|---|---|---|---|
2501926 | 2501926 | 2022-05-13 | Caguas | Puerto Rico | 72025 | 25226 | |
2498668 | 2498668 | 2022-05-12 | Caguas | Puerto Rico | 72025 | 25063 | |
2495410 | 2495410 | 2022-05-11 | Caguas | Puerto Rico | 72025 | 24788 | |
2492152 | 2492152 | 2022-05-10 | Caguas | Puerto Rico | 72025 | 24615 | |
2488894 | 2488894 | 2022-05-09 | Caguas | Puerto Rico | 72025 | 24588 | |
2485637 | 2485637 | 2022-05-08 | Caguas | Puerto Rico | 72025 | 24227 | |
2482379 | 2482379 | 2022-05-07 | Caguas | Puerto Rico | 72025 | 24226 | |
2479121 | 2479121 | 2022-05-06 | Caguas | Puerto Rico | 72025 | 24000 | |
2475863 | 2475863 | 2022-05-05 | Caguas | Puerto Rico | 72025 | 23789 | |
2472606 | 2472606 | 2022-05-04 | Caguas | Puerto Rico | 72025 | 23565 | |
2469350 | 2469350 | 2022-05-03 | Caguas | Puerto Rico | 72025 | 23447 | |
2466094 | 2466094 | 2022-05-02 | Caguas | Puerto Rico | 72025 | 23393 | |
2462839 | 2462839 | 2022-05-01 | Caguas | Puerto Rico | 72025 | 23251 | |
2459583 | 2459583 | 2022-04-30 | Caguas | Puerto Rico | 72025 | 23084 | |
2456327 | 2456327 | 2022-04-29 | Caguas | Puerto Rico | 72025 | 22925 | |
2453071 | 2453071 | 2022-04-28 | Caguas | Puerto Rico | 72025 | 22797 | |
2449815 | 2449815 | 2022-04-27 | Caguas | Puerto Rico | 72025 | 22652 | |
2446558 | 2446558 | 2022-04-26 | Caguas | Puerto Rico | 72025 | 22555 | |
2443303 | 2443303 | 2022-04-25 | Caguas | Puerto Rico | 72025 | 22528 | |
2440047 | 2440047 | 2022-04-24 | Caguas | Puerto Rico | 72025 | 22445 | |
2436791 | 2436791 | 2022-04-23 | Caguas | Puerto Rico | 72025 | 22303 | |
2433535 | 2433535 | 2022-04-22 | Caguas | Puerto Rico | 72025 | 22132 | |
2430279 | 2430279 | 2022-04-21 | Caguas | Puerto Rico | 72025 | 21981 | |
2427023 | 2427023 | 2022-04-20 | Caguas | Puerto Rico | 72025 | 21826 | |
2423767 | 2423767 | 2022-04-19 | Caguas | Puerto Rico | 72025 | 21742 | |
2420511 | 2420511 | 2022-04-18 | Caguas | Puerto Rico | 72025 | 21715 | |
2417255 | 2417255 | 2022-04-17 | Caguas | Puerto Rico | 72025 | 21665 | |
2413999 | 2413999 | 2022-04-16 | Caguas | Puerto Rico | 72025 | 21473 | |
2410743 | 2410743 | 2022-04-15 | Caguas | Puerto Rico | 72025 | 21473 | |
2407487 | 2407487 | 2022-04-14 | Caguas | Puerto Rico | 72025 | 21473 | |
2404231 | 2404231 | 2022-04-13 | Caguas | Puerto Rico | 72025 | 21415 | |
2400976 | 2400976 | 2022-04-12 | Caguas | Puerto Rico | 72025 | 21357 | |
2397721 | 2397721 | 2022-04-11 | Caguas | Puerto Rico | 72025 | 21351 | |
2394466 | 2394466 | 2022-04-10 | Caguas | Puerto Rico | 72025 | 21314 | |
2391210 | 2391210 | 2022-04-09 | Caguas | Puerto Rico | 72025 | 21273 | |
2387954 | 2387954 | 2022-04-08 | Caguas | Puerto Rico | 72025 | 21244 | |
2384699 | 2384699 | 2022-04-07 | Caguas | Puerto Rico | 72025 | 21209 | |
2381444 | 2381444 | 2022-04-06 | Caguas | Puerto Rico | 72025 | 21176 | |
2378189 | 2378189 | 2022-04-05 | Caguas | Puerto Rico | 72025 | 21143 | |
2374935 | 2374935 | 2022-04-04 | Caguas | Puerto Rico | 72025 | 21142 | |
2371683 | 2371683 | 2022-04-03 | Caguas | Puerto Rico | 72025 | 21123 | |
2368430 | 2368430 | 2022-04-02 | Caguas | Puerto Rico | 72025 | 21104 | |
2365177 | 2365177 | 2022-04-01 | Caguas | Puerto Rico | 72025 | 21077 | |
2361924 | 2361924 | 2022-03-31 | Caguas | Puerto Rico | 72025 | 21058 | |
2358670 | 2358670 | 2022-03-30 | Caguas | Puerto Rico | 72025 | 21046 | |
2355416 | 2355416 | 2022-03-29 | Caguas | Puerto Rico | 72025 | 21026 | |
2352163 | 2352163 | 2022-03-28 | Caguas | Puerto Rico | 72025 | 21022 | |
2348911 | 2348911 | 2022-03-27 | Caguas | Puerto Rico | 72025 | 21004 | |
2345658 | 2345658 | 2022-03-26 | Caguas | Puerto Rico | 72025 | 20982 | |
2342405 | 2342405 | 2022-03-25 | Caguas | Puerto Rico | 72025 | 20958 | |
2339152 | 2339152 | 2022-03-24 | Caguas | Puerto Rico | 72025 | 20950 | |
2335898 | 2335898 | 2022-03-23 | Caguas | Puerto Rico | 72025 | 20948 | |
2332644 | 2332644 | 2022-03-22 | Caguas | Puerto Rico | 72025 | 20937 | |
2329391 | 2329391 | 2022-03-21 | Caguas | Puerto Rico | 72025 | 20936 | |
2326139 | 2326139 | 2022-03-20 | Caguas | Puerto Rico | 72025 | 20930 | |
2322886 | 2322886 | 2022-03-19 | Caguas | Puerto Rico | 72025 | 20920 | |
2319632 | 2319632 | 2022-03-18 | Caguas | Puerto Rico | 72025 | 20914 | |
2316378 | 2316378 | 2022-03-17 | Caguas | Puerto Rico | 72025 | 20907 | |
2313125 | 2313125 | 2022-03-16 | Caguas | Puerto Rico | 72025 | 20898 | |
2309872 | 2309872 | 2022-03-15 | Caguas | Puerto Rico | 72025 | 20892 | |
2306619 | 2306619 | 2022-03-14 | Caguas | Puerto Rico | 72025 | 20885 | |
2303368 | 2303368 | 2022-03-13 | Caguas | Puerto Rico | 72025 | 20882 | |
2300116 | 2300116 | 2022-03-12 | Caguas | Puerto Rico | 72025 | 20874 | |
2296864 | 2296864 | 2022-03-11 | Caguas | Puerto Rico | 72025 | 20870 | |
2293612 | 2293612 | 2022-03-10 | Caguas | Puerto Rico | 72025 | 20868 | |
2290360 | 2290360 | 2022-03-09 | Caguas | Puerto Rico | 72025 | 20858 | |
2287108 | 2287108 | 2022-03-08 | Caguas | Puerto Rico | 72025 | 20851 | |
2283856 | 2283856 | 2022-03-07 | Caguas | Puerto Rico | 72025 | 20851 | |
2280604 | 2280604 | 2022-03-06 | Caguas | Puerto Rico | 72025 | 20850 | |
2277351 | 2277351 | 2022-03-05 | Caguas | Puerto Rico | 72025 | 20846 | |
2274098 | 2274098 | 2022-03-04 | Caguas | Puerto Rico | 72025 | 20839 | |
2270845 | 2270845 | 2022-03-03 | Caguas | Puerto Rico | 72025 | 20832 | |
2267593 | 2267593 | 2022-03-02 | Caguas | Puerto Rico | 72025 | 20826 | |
2264340 | 2264340 | 2022-03-01 | Caguas | Puerto Rico | 72025 | 20816 | |
2261090 | 2261090 | 2022-02-28 | Caguas | Puerto Rico | 72025 | 20813 | |
2257839 | 2257839 | 2022-02-27 | Caguas | Puerto Rico | 72025 | 20807 | |
2254588 | 2254588 | 2022-02-26 | Caguas | Puerto Rico | 72025 | 20803 | |
2251337 | 2251337 | 2022-02-25 | Caguas | Puerto Rico | 72025 | 20790 | |
2248086 | 2248086 | 2022-02-24 | Caguas | Puerto Rico | 72025 | 20785 | |
2244835 | 2244835 | 2022-02-23 | Caguas | Puerto Rico | 72025 | 20777 | |
2241584 | 2241584 | 2022-02-22 | Caguas | Puerto Rico | 72025 | 20776 | |
2238333 | 2238333 | 2022-02-21 | Caguas | Puerto Rico | 72025 | 20775 | |
2235082 | 2235082 | 2022-02-20 | Caguas | Puerto Rico | 72025 | 20772 | |
2231831 | 2231831 | 2022-02-19 | Caguas | Puerto Rico | 72025 | 20763 | |
2228580 | 2228580 | 2022-02-18 | Caguas | Puerto Rico | 72025 | 20745 | |
2225329 | 2225329 | 2022-02-17 | Caguas | Puerto Rico | 72025 | 20738 | |
2222078 | 2222078 | 2022-02-16 | Caguas | Puerto Rico | 72025 | 20719 | |
2218827 | 2218827 | 2022-02-15 | Caguas | Puerto Rico | 72025 | 20701 | |
2215576 | 2215576 | 2022-02-14 | Caguas | Puerto Rico | 72025 | 20704 | |
2212325 | 2212325 | 2022-02-13 | Caguas | Puerto Rico | 72025 | 20701 | |
2209072 | 2209072 | 2022-02-12 | Caguas | Puerto Rico | 72025 | 20687 | |
2205819 | 2205819 | 2022-02-11 | Caguas | Puerto Rico | 72025 | 20668 | |
2202566 | 2202566 | 2022-02-10 | Caguas | Puerto Rico | 72025 | 20657 | |
2199312 | 2199312 | 2022-02-09 | Caguas | Puerto Rico | 72025 | 20634 | |
2196058 | 2196058 | 2022-02-08 | Caguas | Puerto Rico | 72025 | 20621 | |
2192804 | 2192804 | 2022-02-07 | Caguas | Puerto Rico | 72025 | 20619 | |
2189550 | 2189550 | 2022-02-06 | Caguas | Puerto Rico | 72025 | 20607 | |
2186297 | 2186297 | 2022-02-05 | Caguas | Puerto Rico | 72025 | 20564 | |
2183045 | 2183045 | 2022-02-04 | Caguas | Puerto Rico | 72025 | 20540 | |
2179793 | 2179793 | 2022-02-03 | Caguas | Puerto Rico | 72025 | 20514 |
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);