ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ponce" 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 |
---|---|---|---|---|---|---|---|
2501971 | 2501971 | 2022-05-13 | Ponce | Puerto Rico | 72113 | 21975 | |
2498713 | 2498713 | 2022-05-12 | Ponce | Puerto Rico | 72113 | 21697 | |
2495455 | 2495455 | 2022-05-11 | Ponce | Puerto Rico | 72113 | 21373 | |
2492197 | 2492197 | 2022-05-10 | Ponce | Puerto Rico | 72113 | 21225 | |
2488939 | 2488939 | 2022-05-09 | Ponce | Puerto Rico | 72113 | 21199 | |
2485682 | 2485682 | 2022-05-08 | Ponce | Puerto Rico | 72113 | 20894 | |
2482424 | 2482424 | 2022-05-07 | Ponce | Puerto Rico | 72113 | 20885 | |
2479166 | 2479166 | 2022-05-06 | Ponce | Puerto Rico | 72113 | 20651 | |
2475908 | 2475908 | 2022-05-05 | Ponce | Puerto Rico | 72113 | 20410 | |
2472651 | 2472651 | 2022-05-04 | Ponce | Puerto Rico | 72113 | 20213 | |
2469395 | 2469395 | 2022-05-03 | Ponce | Puerto Rico | 72113 | 19979 | |
2466139 | 2466139 | 2022-05-02 | Ponce | Puerto Rico | 72113 | 19944 | |
2462884 | 2462884 | 2022-05-01 | Ponce | Puerto Rico | 72113 | 19879 | |
2459628 | 2459628 | 2022-04-30 | Ponce | Puerto Rico | 72113 | 19651 | |
2456372 | 2456372 | 2022-04-29 | Ponce | Puerto Rico | 72113 | 19465 | |
2453116 | 2453116 | 2022-04-28 | Ponce | Puerto Rico | 72113 | 19278 | |
2449860 | 2449860 | 2022-04-27 | Ponce | Puerto Rico | 72113 | 19110 | |
2446603 | 2446603 | 2022-04-26 | Ponce | Puerto Rico | 72113 | 19010 | |
2443348 | 2443348 | 2022-04-25 | Ponce | Puerto Rico | 72113 | 18977 | |
2440092 | 2440092 | 2022-04-24 | Ponce | Puerto Rico | 72113 | 18879 | |
2436836 | 2436836 | 2022-04-23 | Ponce | Puerto Rico | 72113 | 18730 | |
2433580 | 2433580 | 2022-04-22 | Ponce | Puerto Rico | 72113 | 18527 | |
2430324 | 2430324 | 2022-04-21 | Ponce | Puerto Rico | 72113 | 18339 | |
2427068 | 2427068 | 2022-04-20 | Ponce | Puerto Rico | 72113 | 18188 | |
2423812 | 2423812 | 2022-04-19 | Ponce | Puerto Rico | 72113 | 18106 | |
2420556 | 2420556 | 2022-04-18 | Ponce | Puerto Rico | 72113 | 18079 | |
2417300 | 2417300 | 2022-04-17 | Ponce | Puerto Rico | 72113 | 18033 | |
2414044 | 2414044 | 2022-04-16 | Ponce | Puerto Rico | 72113 | 17859 | |
2410788 | 2410788 | 2022-04-15 | Ponce | Puerto Rico | 72113 | 17859 | |
2407532 | 2407532 | 2022-04-14 | Ponce | Puerto Rico | 72113 | 17859 | |
2404276 | 2404276 | 2022-04-13 | Ponce | Puerto Rico | 72113 | 17779 | |
2401021 | 2401021 | 2022-04-12 | Ponce | Puerto Rico | 72113 | 17722 | |
2397766 | 2397766 | 2022-04-11 | Ponce | Puerto Rico | 72113 | 17719 | |
2394511 | 2394511 | 2022-04-10 | Ponce | Puerto Rico | 72113 | 17679 | |
2391255 | 2391255 | 2022-04-09 | Ponce | Puerto Rico | 72113 | 17616 | |
2387999 | 2387999 | 2022-04-08 | Ponce | Puerto Rico | 72113 | 17581 | |
2384744 | 2384744 | 2022-04-07 | Ponce | Puerto Rico | 72113 | 17555 | |
2381489 | 2381489 | 2022-04-06 | Ponce | Puerto Rico | 72113 | 17508 | |
2378234 | 2378234 | 2022-04-05 | Ponce | Puerto Rico | 72113 | 17492 | |
2374980 | 2374980 | 2022-04-04 | Ponce | Puerto Rico | 72113 | 17490 | |
2371728 | 2371728 | 2022-04-03 | Ponce | Puerto Rico | 72113 | 17478 | |
2368475 | 2368475 | 2022-04-02 | Ponce | Puerto Rico | 72113 | 17458 | |
2365222 | 2365222 | 2022-04-01 | Ponce | Puerto Rico | 72113 | 17441 | |
2361969 | 2361969 | 2022-03-31 | Ponce | Puerto Rico | 72113 | 17419 | |
2358715 | 2358715 | 2022-03-30 | Ponce | Puerto Rico | 72113 | 17399 | |
2355461 | 2355461 | 2022-03-29 | Ponce | Puerto Rico | 72113 | 17389 | |
2352208 | 2352208 | 2022-03-28 | Ponce | Puerto Rico | 72113 | 17385 | |
2348956 | 2348956 | 2022-03-27 | Ponce | Puerto Rico | 72113 | 17383 | |
2345703 | 2345703 | 2022-03-26 | Ponce | Puerto Rico | 72113 | 17377 | |
2342450 | 2342450 | 2022-03-25 | Ponce | Puerto Rico | 72113 | 17341 | |
2339197 | 2339197 | 2022-03-24 | Ponce | Puerto Rico | 72113 | 17304 | |
2335943 | 2335943 | 2022-03-23 | Ponce | Puerto Rico | 72113 | 17288 | |
2332689 | 2332689 | 2022-03-22 | Ponce | Puerto Rico | 72113 | 17279 | |
2329436 | 2329436 | 2022-03-21 | Ponce | Puerto Rico | 72113 | 17279 | |
2326184 | 2326184 | 2022-03-20 | Ponce | Puerto Rico | 72113 | 17277 | |
2322931 | 2322931 | 2022-03-19 | Ponce | Puerto Rico | 72113 | 17259 | |
2319677 | 2319677 | 2022-03-18 | Ponce | Puerto Rico | 72113 | 17252 | |
2316423 | 2316423 | 2022-03-17 | Ponce | Puerto Rico | 72113 | 17235 | |
2313170 | 2313170 | 2022-03-16 | Ponce | Puerto Rico | 72113 | 17214 | |
2309917 | 2309917 | 2022-03-15 | Ponce | Puerto Rico | 72113 | 17204 | |
2306664 | 2306664 | 2022-03-14 | Ponce | Puerto Rico | 72113 | 17203 | |
2303413 | 2303413 | 2022-03-13 | Ponce | Puerto Rico | 72113 | 17201 | |
2300161 | 2300161 | 2022-03-12 | Ponce | Puerto Rico | 72113 | 17184 | |
2296909 | 2296909 | 2022-03-11 | Ponce | Puerto Rico | 72113 | 17157 | |
2293657 | 2293657 | 2022-03-10 | Ponce | Puerto Rico | 72113 | 17146 | |
2290405 | 2290405 | 2022-03-09 | Ponce | Puerto Rico | 72113 | 17126 | |
2287153 | 2287153 | 2022-03-08 | Ponce | Puerto Rico | 72113 | 17118 | |
2283901 | 2283901 | 2022-03-07 | Ponce | Puerto Rico | 72113 | 17116 | |
2280649 | 2280649 | 2022-03-06 | Ponce | Puerto Rico | 72113 | 17100 | |
2277396 | 2277396 | 2022-03-05 | Ponce | Puerto Rico | 72113 | 17088 | |
2274143 | 2274143 | 2022-03-04 | Ponce | Puerto Rico | 72113 | 17054 | |
2270890 | 2270890 | 2022-03-03 | Ponce | Puerto Rico | 72113 | 17049 | |
2267638 | 2267638 | 2022-03-02 | Ponce | Puerto Rico | 72113 | 17034 | |
2264385 | 2264385 | 2022-03-01 | Ponce | Puerto Rico | 72113 | 17027 | |
2261135 | 2261135 | 2022-02-28 | Ponce | Puerto Rico | 72113 | 17025 | |
2257884 | 2257884 | 2022-02-27 | Ponce | Puerto Rico | 72113 | 17016 | |
2254633 | 2254633 | 2022-02-26 | Ponce | Puerto Rico | 72113 | 17006 | |
2251382 | 2251382 | 2022-02-25 | Ponce | Puerto Rico | 72113 | 16982 | |
2248131 | 2248131 | 2022-02-24 | Ponce | Puerto Rico | 72113 | 16962 | |
2244880 | 2244880 | 2022-02-23 | Ponce | Puerto Rico | 72113 | 16948 | |
2241629 | 2241629 | 2022-02-22 | Ponce | Puerto Rico | 72113 | 16930 | |
2238378 | 2238378 | 2022-02-21 | Ponce | Puerto Rico | 72113 | 16925 | |
2235127 | 2235127 | 2022-02-20 | Ponce | Puerto Rico | 72113 | 16917 | |
2231876 | 2231876 | 2022-02-19 | Ponce | Puerto Rico | 72113 | 16887 | |
2228625 | 2228625 | 2022-02-18 | Ponce | Puerto Rico | 72113 | 16856 | |
2225374 | 2225374 | 2022-02-17 | Ponce | Puerto Rico | 72113 | 16839 | |
2222123 | 2222123 | 2022-02-16 | Ponce | Puerto Rico | 72113 | 16814 | |
2218872 | 2218872 | 2022-02-15 | Ponce | Puerto Rico | 72113 | 16785 | |
2215621 | 2215621 | 2022-02-14 | Ponce | Puerto Rico | 72113 | 16788 | |
2212370 | 2212370 | 2022-02-13 | Ponce | Puerto Rico | 72113 | 16772 | |
2209117 | 2209117 | 2022-02-12 | Ponce | Puerto Rico | 72113 | 16750 | |
2205864 | 2205864 | 2022-02-11 | Ponce | Puerto Rico | 72113 | 16708 | |
2202611 | 2202611 | 2022-02-10 | Ponce | Puerto Rico | 72113 | 16681 | |
2199357 | 2199357 | 2022-02-09 | Ponce | Puerto Rico | 72113 | 16632 | |
2196103 | 2196103 | 2022-02-08 | Ponce | Puerto Rico | 72113 | 16624 | |
2192849 | 2192849 | 2022-02-07 | Ponce | Puerto Rico | 72113 | 16621 | |
2189595 | 2189595 | 2022-02-06 | Ponce | Puerto Rico | 72113 | 16612 | |
2186342 | 2186342 | 2022-02-05 | Ponce | Puerto Rico | 72113 | 16532 | |
2183090 | 2183090 | 2022-02-04 | Ponce | Puerto Rico | 72113 | 16494 | |
2179838 | 2179838 | 2022-02-03 | Ponce | Puerto Rico | 72113 | 16399 |
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);