ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Las Piedras" 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 |
---|---|---|---|---|---|---|---|
2498699 | 2498699 | 2022-05-12 | Las Piedras | Puerto Rico | 72085 | 6314 | |
2495441 | 2495441 | 2022-05-11 | Las Piedras | Puerto Rico | 72085 | 6253 | |
2492183 | 2492183 | 2022-05-10 | Las Piedras | Puerto Rico | 72085 | 6223 | |
2488925 | 2488925 | 2022-05-09 | Las Piedras | Puerto Rico | 72085 | 6218 | |
2485668 | 2485668 | 2022-05-08 | Las Piedras | Puerto Rico | 72085 | 6142 | |
2482410 | 2482410 | 2022-05-07 | Las Piedras | Puerto Rico | 72085 | 6140 | |
2479152 | 2479152 | 2022-05-06 | Las Piedras | Puerto Rico | 72085 | 6061 | |
2475894 | 2475894 | 2022-05-05 | Las Piedras | Puerto Rico | 72085 | 6008 | |
2472637 | 2472637 | 2022-05-04 | Las Piedras | Puerto Rico | 72085 | 5956 | |
2469381 | 2469381 | 2022-05-03 | Las Piedras | Puerto Rico | 72085 | 5923 | |
2466125 | 2466125 | 2022-05-02 | Las Piedras | Puerto Rico | 72085 | 5913 | |
2462870 | 2462870 | 2022-05-01 | Las Piedras | Puerto Rico | 72085 | 5881 | |
2459614 | 2459614 | 2022-04-30 | Las Piedras | Puerto Rico | 72085 | 5829 | |
2456358 | 2456358 | 2022-04-29 | Las Piedras | Puerto Rico | 72085 | 5784 | |
2453102 | 2453102 | 2022-04-28 | Las Piedras | Puerto Rico | 72085 | 5743 | |
2449846 | 2449846 | 2022-04-27 | Las Piedras | Puerto Rico | 72085 | 5688 | |
2446589 | 2446589 | 2022-04-26 | Las Piedras | Puerto Rico | 72085 | 5665 | |
2443334 | 2443334 | 2022-04-25 | Las Piedras | Puerto Rico | 72085 | 5659 | |
2440078 | 2440078 | 2022-04-24 | Las Piedras | Puerto Rico | 72085 | 5622 | |
2436822 | 2436822 | 2022-04-23 | Las Piedras | Puerto Rico | 72085 | 5575 | |
2433566 | 2433566 | 2022-04-22 | Las Piedras | Puerto Rico | 72085 | 5518 | |
2430310 | 2430310 | 2022-04-21 | Las Piedras | Puerto Rico | 72085 | 5471 | |
2427054 | 2427054 | 2022-04-20 | Las Piedras | Puerto Rico | 72085 | 5423 | |
2423798 | 2423798 | 2022-04-19 | Las Piedras | Puerto Rico | 72085 | 5408 | |
2420542 | 2420542 | 2022-04-18 | Las Piedras | Puerto Rico | 72085 | 5397 | |
2417286 | 2417286 | 2022-04-17 | Las Piedras | Puerto Rico | 72085 | 5373 | |
2414030 | 2414030 | 2022-04-16 | Las Piedras | Puerto Rico | 72085 | 5304 | |
2410774 | 2410774 | 2022-04-15 | Las Piedras | Puerto Rico | 72085 | 5304 | |
2407518 | 2407518 | 2022-04-14 | Las Piedras | Puerto Rico | 72085 | 5304 | |
2404262 | 2404262 | 2022-04-13 | Las Piedras | Puerto Rico | 72085 | 5289 | |
2401007 | 2401007 | 2022-04-12 | Las Piedras | Puerto Rico | 72085 | 5277 | |
2397752 | 2397752 | 2022-04-11 | Las Piedras | Puerto Rico | 72085 | 5277 | |
2394497 | 2394497 | 2022-04-10 | Las Piedras | Puerto Rico | 72085 | 5273 | |
2391241 | 2391241 | 2022-04-09 | Las Piedras | Puerto Rico | 72085 | 5256 | |
2387985 | 2387985 | 2022-04-08 | Las Piedras | Puerto Rico | 72085 | 5245 | |
2384730 | 2384730 | 2022-04-07 | Las Piedras | Puerto Rico | 72085 | 5236 | |
2381475 | 2381475 | 2022-04-06 | Las Piedras | Puerto Rico | 72085 | 5225 | |
2378220 | 2378220 | 2022-04-05 | Las Piedras | Puerto Rico | 72085 | 5219 | |
2374966 | 2374966 | 2022-04-04 | Las Piedras | Puerto Rico | 72085 | 5218 | |
2371714 | 2371714 | 2022-04-03 | Las Piedras | Puerto Rico | 72085 | 5216 | |
2368461 | 2368461 | 2022-04-02 | Las Piedras | Puerto Rico | 72085 | 5209 | |
2365208 | 2365208 | 2022-04-01 | Las Piedras | Puerto Rico | 72085 | 5202 | |
2361955 | 2361955 | 2022-03-31 | Las Piedras | Puerto Rico | 72085 | 5186 | |
2358701 | 2358701 | 2022-03-30 | Las Piedras | Puerto Rico | 72085 | 5180 | |
2355447 | 2355447 | 2022-03-29 | Las Piedras | Puerto Rico | 72085 | 5167 | |
2352194 | 2352194 | 2022-03-28 | Las Piedras | Puerto Rico | 72085 | 5167 | |
2348942 | 2348942 | 2022-03-27 | Las Piedras | Puerto Rico | 72085 | 5159 | |
2345689 | 2345689 | 2022-03-26 | Las Piedras | Puerto Rico | 72085 | 5158 | |
2342436 | 2342436 | 2022-03-25 | Las Piedras | Puerto Rico | 72085 | 5152 | |
2339183 | 2339183 | 2022-03-24 | Las Piedras | Puerto Rico | 72085 | 5151 | |
2335929 | 2335929 | 2022-03-23 | Las Piedras | Puerto Rico | 72085 | 5147 | |
2332675 | 2332675 | 2022-03-22 | Las Piedras | Puerto Rico | 72085 | 5145 | |
2329422 | 2329422 | 2022-03-21 | Las Piedras | Puerto Rico | 72085 | 5145 | |
2326170 | 2326170 | 2022-03-20 | Las Piedras | Puerto Rico | 72085 | 5144 | |
2322917 | 2322917 | 2022-03-19 | Las Piedras | Puerto Rico | 72085 | 5139 | |
2319663 | 2319663 | 2022-03-18 | Las Piedras | Puerto Rico | 72085 | 5139 | |
2316409 | 2316409 | 2022-03-17 | Las Piedras | Puerto Rico | 72085 | 5138 | |
2313156 | 2313156 | 2022-03-16 | Las Piedras | Puerto Rico | 72085 | 5136 | |
2309903 | 2309903 | 2022-03-15 | Las Piedras | Puerto Rico | 72085 | 5134 | |
2306650 | 2306650 | 2022-03-14 | Las Piedras | Puerto Rico | 72085 | 5134 | |
2303399 | 2303399 | 2022-03-13 | Las Piedras | Puerto Rico | 72085 | 5134 | |
2300147 | 2300147 | 2022-03-12 | Las Piedras | Puerto Rico | 72085 | 5133 | |
2296895 | 2296895 | 2022-03-11 | Las Piedras | Puerto Rico | 72085 | 5132 | |
2293643 | 2293643 | 2022-03-10 | Las Piedras | Puerto Rico | 72085 | 5130 | |
2290391 | 2290391 | 2022-03-09 | Las Piedras | Puerto Rico | 72085 | 5128 | |
2287139 | 2287139 | 2022-03-08 | Las Piedras | Puerto Rico | 72085 | 5124 | |
2283887 | 2283887 | 2022-03-07 | Las Piedras | Puerto Rico | 72085 | 5124 | |
2280635 | 2280635 | 2022-03-06 | Las Piedras | Puerto Rico | 72085 | 5123 | |
2277382 | 2277382 | 2022-03-05 | Las Piedras | Puerto Rico | 72085 | 5122 | |
2274129 | 2274129 | 2022-03-04 | Las Piedras | Puerto Rico | 72085 | 5121 | |
2270876 | 2270876 | 2022-03-03 | Las Piedras | Puerto Rico | 72085 | 5120 | |
2267624 | 2267624 | 2022-03-02 | Las Piedras | Puerto Rico | 72085 | 5117 | |
2264371 | 2264371 | 2022-03-01 | Las Piedras | Puerto Rico | 72085 | 5114 | |
2261121 | 2261121 | 2022-02-28 | Las Piedras | Puerto Rico | 72085 | 5114 | |
2257870 | 2257870 | 2022-02-27 | Las Piedras | Puerto Rico | 72085 | 5113 | |
2254619 | 2254619 | 2022-02-26 | Las Piedras | Puerto Rico | 72085 | 5112 | |
2251368 | 2251368 | 2022-02-25 | Las Piedras | Puerto Rico | 72085 | 5111 | |
2248117 | 2248117 | 2022-02-24 | Las Piedras | Puerto Rico | 72085 | 5111 | |
2244866 | 2244866 | 2022-02-23 | Las Piedras | Puerto Rico | 72085 | 5108 | |
2241615 | 2241615 | 2022-02-22 | Las Piedras | Puerto Rico | 72085 | 5108 | |
2238364 | 2238364 | 2022-02-21 | Las Piedras | Puerto Rico | 72085 | 5108 | |
2235113 | 2235113 | 2022-02-20 | Las Piedras | Puerto Rico | 72085 | 5108 | |
2231862 | 2231862 | 2022-02-19 | Las Piedras | Puerto Rico | 72085 | 5105 | |
2228611 | 2228611 | 2022-02-18 | Las Piedras | Puerto Rico | 72085 | 5097 | |
2225360 | 2225360 | 2022-02-17 | Las Piedras | Puerto Rico | 72085 | 5094 | |
2222109 | 2222109 | 2022-02-16 | Las Piedras | Puerto Rico | 72085 | 5093 | |
2218858 | 2218858 | 2022-02-15 | Las Piedras | Puerto Rico | 72085 | 5089 | |
2215607 | 2215607 | 2022-02-14 | Las Piedras | Puerto Rico | 72085 | 5090 | |
2212356 | 2212356 | 2022-02-13 | Las Piedras | Puerto Rico | 72085 | 5090 | |
2209103 | 2209103 | 2022-02-12 | Las Piedras | Puerto Rico | 72085 | 5087 | |
2205850 | 2205850 | 2022-02-11 | Las Piedras | Puerto Rico | 72085 | 5081 | |
2202597 | 2202597 | 2022-02-10 | Las Piedras | Puerto Rico | 72085 | 5078 | |
2199343 | 2199343 | 2022-02-09 | Las Piedras | Puerto Rico | 72085 | 5068 | |
2196089 | 2196089 | 2022-02-08 | Las Piedras | Puerto Rico | 72085 | 5064 | |
2192835 | 2192835 | 2022-02-07 | Las Piedras | Puerto Rico | 72085 | 5064 | |
2189581 | 2189581 | 2022-02-06 | Las Piedras | Puerto Rico | 72085 | 5059 | |
2186328 | 2186328 | 2022-02-05 | Las Piedras | Puerto Rico | 72085 | 5042 | |
2183076 | 2183076 | 2022-02-04 | Las Piedras | Puerto Rico | 72085 | 5029 | |
2179824 | 2179824 | 2022-02-03 | Las Piedras | Puerto Rico | 72085 | 5019 | |
2176573 | 2176573 | 2022-02-02 | Las Piedras | Puerto Rico | 72085 | 4992 |
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);