ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "San Lorenzo" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501979 | 2501979 | 2022-05-13 | San Lorenzo | Puerto Rico | 72129 | 6464 | |
2498721 | 2498721 | 2022-05-12 | San Lorenzo | Puerto Rico | 72129 | 6402 | |
2495463 | 2495463 | 2022-05-11 | San Lorenzo | Puerto Rico | 72129 | 6330 | |
2492205 | 2492205 | 2022-05-10 | San Lorenzo | Puerto Rico | 72129 | 6289 | |
2488947 | 2488947 | 2022-05-09 | San Lorenzo | Puerto Rico | 72129 | 6280 | |
2485690 | 2485690 | 2022-05-08 | San Lorenzo | Puerto Rico | 72129 | 6205 | |
2482432 | 2482432 | 2022-05-07 | San Lorenzo | Puerto Rico | 72129 | 6205 | |
2479174 | 2479174 | 2022-05-06 | San Lorenzo | Puerto Rico | 72129 | 6115 | |
2475916 | 2475916 | 2022-05-05 | San Lorenzo | Puerto Rico | 72129 | 6042 | |
2472659 | 2472659 | 2022-05-04 | San Lorenzo | Puerto Rico | 72129 | 5948 | |
2469403 | 2469403 | 2022-05-03 | San Lorenzo | Puerto Rico | 72129 | 5876 | |
2466147 | 2466147 | 2022-05-02 | San Lorenzo | Puerto Rico | 72129 | 5865 | |
2462892 | 2462892 | 2022-05-01 | San Lorenzo | Puerto Rico | 72129 | 5848 | |
2459636 | 2459636 | 2022-04-30 | San Lorenzo | Puerto Rico | 72129 | 5788 | |
2456380 | 2456380 | 2022-04-29 | San Lorenzo | Puerto Rico | 72129 | 5733 | |
2453124 | 2453124 | 2022-04-28 | San Lorenzo | Puerto Rico | 72129 | 5693 | |
2449868 | 2449868 | 2022-04-27 | San Lorenzo | Puerto Rico | 72129 | 5665 | |
2446611 | 2446611 | 2022-04-26 | San Lorenzo | Puerto Rico | 72129 | 5635 | |
2443356 | 2443356 | 2022-04-25 | San Lorenzo | Puerto Rico | 72129 | 5630 | |
2440100 | 2440100 | 2022-04-24 | San Lorenzo | Puerto Rico | 72129 | 5613 | |
2436844 | 2436844 | 2022-04-23 | San Lorenzo | Puerto Rico | 72129 | 5565 | |
2433588 | 2433588 | 2022-04-22 | San Lorenzo | Puerto Rico | 72129 | 5528 | |
2430332 | 2430332 | 2022-04-21 | San Lorenzo | Puerto Rico | 72129 | 5497 | |
2427076 | 2427076 | 2022-04-20 | San Lorenzo | Puerto Rico | 72129 | 5468 | |
2423820 | 2423820 | 2022-04-19 | San Lorenzo | Puerto Rico | 72129 | 5438 | |
2420564 | 2420564 | 2022-04-18 | San Lorenzo | Puerto Rico | 72129 | 5434 | |
2417308 | 2417308 | 2022-04-17 | San Lorenzo | Puerto Rico | 72129 | 5423 | |
2414052 | 2414052 | 2022-04-16 | San Lorenzo | Puerto Rico | 72129 | 5371 | |
2410796 | 2410796 | 2022-04-15 | San Lorenzo | Puerto Rico | 72129 | 5371 | |
2407540 | 2407540 | 2022-04-14 | San Lorenzo | Puerto Rico | 72129 | 5371 | |
2404284 | 2404284 | 2022-04-13 | San Lorenzo | Puerto Rico | 72129 | 5355 | |
2401029 | 2401029 | 2022-04-12 | San Lorenzo | Puerto Rico | 72129 | 5343 | |
2397774 | 2397774 | 2022-04-11 | San Lorenzo | Puerto Rico | 72129 | 5342 | |
2394519 | 2394519 | 2022-04-10 | San Lorenzo | Puerto Rico | 72129 | 5339 | |
2391263 | 2391263 | 2022-04-09 | San Lorenzo | Puerto Rico | 72129 | 5327 | |
2388007 | 2388007 | 2022-04-08 | San Lorenzo | Puerto Rico | 72129 | 5317 | |
2384752 | 2384752 | 2022-04-07 | San Lorenzo | Puerto Rico | 72129 | 5310 | |
2381497 | 2381497 | 2022-04-06 | San Lorenzo | Puerto Rico | 72129 | 5297 | |
2378242 | 2378242 | 2022-04-05 | San Lorenzo | Puerto Rico | 72129 | 5286 | |
2374988 | 2374988 | 2022-04-04 | San Lorenzo | Puerto Rico | 72129 | 5286 | |
2371736 | 2371736 | 2022-04-03 | San Lorenzo | Puerto Rico | 72129 | 5284 | |
2368483 | 2368483 | 2022-04-02 | San Lorenzo | Puerto Rico | 72129 | 5276 | |
2365230 | 2365230 | 2022-04-01 | San Lorenzo | Puerto Rico | 72129 | 5271 | |
2361977 | 2361977 | 2022-03-31 | San Lorenzo | Puerto Rico | 72129 | 5263 | |
2358723 | 2358723 | 2022-03-30 | San Lorenzo | Puerto Rico | 72129 | 5258 | |
2355469 | 2355469 | 2022-03-29 | San Lorenzo | Puerto Rico | 72129 | 5255 | |
2352216 | 2352216 | 2022-03-28 | San Lorenzo | Puerto Rico | 72129 | 5255 | |
2348964 | 2348964 | 2022-03-27 | San Lorenzo | Puerto Rico | 72129 | 5253 | |
2345711 | 2345711 | 2022-03-26 | San Lorenzo | Puerto Rico | 72129 | 5252 | |
2342458 | 2342458 | 2022-03-25 | San Lorenzo | Puerto Rico | 72129 | 5247 | |
2339205 | 2339205 | 2022-03-24 | San Lorenzo | Puerto Rico | 72129 | 5245 | |
2335951 | 2335951 | 2022-03-23 | San Lorenzo | Puerto Rico | 72129 | 5244 | |
2332697 | 2332697 | 2022-03-22 | San Lorenzo | Puerto Rico | 72129 | 5243 | |
2329444 | 2329444 | 2022-03-21 | San Lorenzo | Puerto Rico | 72129 | 5243 | |
2326192 | 2326192 | 2022-03-20 | San Lorenzo | Puerto Rico | 72129 | 5242 | |
2322939 | 2322939 | 2022-03-19 | San Lorenzo | Puerto Rico | 72129 | 5240 | |
2319685 | 2319685 | 2022-03-18 | San Lorenzo | Puerto Rico | 72129 | 5240 | |
2316431 | 2316431 | 2022-03-17 | San Lorenzo | Puerto Rico | 72129 | 5240 | |
2313178 | 2313178 | 2022-03-16 | San Lorenzo | Puerto Rico | 72129 | 5235 | |
2309925 | 2309925 | 2022-03-15 | San Lorenzo | Puerto Rico | 72129 | 5235 | |
2306672 | 2306672 | 2022-03-14 | San Lorenzo | Puerto Rico | 72129 | 5235 | |
2303421 | 2303421 | 2022-03-13 | San Lorenzo | Puerto Rico | 72129 | 5235 | |
2300169 | 2300169 | 2022-03-12 | San Lorenzo | Puerto Rico | 72129 | 5235 | |
2296917 | 2296917 | 2022-03-11 | San Lorenzo | Puerto Rico | 72129 | 5236 | |
2293665 | 2293665 | 2022-03-10 | San Lorenzo | Puerto Rico | 72129 | 5236 | |
2290413 | 2290413 | 2022-03-09 | San Lorenzo | Puerto Rico | 72129 | 5236 | |
2287161 | 2287161 | 2022-03-08 | San Lorenzo | Puerto Rico | 72129 | 5236 | |
2283909 | 2283909 | 2022-03-07 | San Lorenzo | Puerto Rico | 72129 | 5236 | |
2280657 | 2280657 | 2022-03-06 | San Lorenzo | Puerto Rico | 72129 | 5233 | |
2277404 | 2277404 | 2022-03-05 | San Lorenzo | Puerto Rico | 72129 | 5232 | |
2274151 | 2274151 | 2022-03-04 | San Lorenzo | Puerto Rico | 72129 | 5230 | |
2270898 | 2270898 | 2022-03-03 | San Lorenzo | Puerto Rico | 72129 | 5228 | |
2267646 | 2267646 | 2022-03-02 | San Lorenzo | Puerto Rico | 72129 | 5225 | |
2264393 | 2264393 | 2022-03-01 | San Lorenzo | Puerto Rico | 72129 | 5225 | |
2261143 | 2261143 | 2022-02-28 | San Lorenzo | Puerto Rico | 72129 | 5225 | |
2257892 | 2257892 | 2022-02-27 | San Lorenzo | Puerto Rico | 72129 | 5223 | |
2254641 | 2254641 | 2022-02-26 | San Lorenzo | Puerto Rico | 72129 | 5221 | |
2251390 | 2251390 | 2022-02-25 | San Lorenzo | Puerto Rico | 72129 | 5220 | |
2248139 | 2248139 | 2022-02-24 | San Lorenzo | Puerto Rico | 72129 | 5217 | |
2244888 | 2244888 | 2022-02-23 | San Lorenzo | Puerto Rico | 72129 | 5212 | |
2241637 | 2241637 | 2022-02-22 | San Lorenzo | Puerto Rico | 72129 | 5213 | |
2238386 | 2238386 | 2022-02-21 | San Lorenzo | Puerto Rico | 72129 | 5213 | |
2235135 | 2235135 | 2022-02-20 | San Lorenzo | Puerto Rico | 72129 | 5213 | |
2231884 | 2231884 | 2022-02-19 | San Lorenzo | Puerto Rico | 72129 | 5209 | |
2228633 | 2228633 | 2022-02-18 | San Lorenzo | Puerto Rico | 72129 | 5199 | |
2225382 | 2225382 | 2022-02-17 | San Lorenzo | Puerto Rico | 72129 | 5196 | |
2222131 | 2222131 | 2022-02-16 | San Lorenzo | Puerto Rico | 72129 | 5190 | |
2218880 | 2218880 | 2022-02-15 | San Lorenzo | Puerto Rico | 72129 | 5183 | |
2215629 | 2215629 | 2022-02-14 | San Lorenzo | Puerto Rico | 72129 | 5183 | |
2212378 | 2212378 | 2022-02-13 | San Lorenzo | Puerto Rico | 72129 | 5183 | |
2209125 | 2209125 | 2022-02-12 | San Lorenzo | Puerto Rico | 72129 | 5178 | |
2205872 | 2205872 | 2022-02-11 | San Lorenzo | Puerto Rico | 72129 | 5164 | |
2202619 | 2202619 | 2022-02-10 | San Lorenzo | Puerto Rico | 72129 | 5161 | |
2199365 | 2199365 | 2022-02-09 | San Lorenzo | Puerto Rico | 72129 | 5147 | |
2196111 | 2196111 | 2022-02-08 | San Lorenzo | Puerto Rico | 72129 | 5136 | |
2192857 | 2192857 | 2022-02-07 | San Lorenzo | Puerto Rico | 72129 | 5135 | |
2189603 | 2189603 | 2022-02-06 | San Lorenzo | Puerto Rico | 72129 | 5127 | |
2186350 | 2186350 | 2022-02-05 | San Lorenzo | Puerto Rico | 72129 | 5114 | |
2183098 | 2183098 | 2022-02-04 | San Lorenzo | Puerto Rico | 72129 | 5100 | |
2179846 | 2179846 | 2022-02-03 | San Lorenzo | Puerto Rico | 72129 | 5072 |
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);