ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72123 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 |
---|---|---|---|---|---|---|---|
2501976 | 2501976 | 2022-05-13 | Salinas | Puerto Rico | 72123 | 4249 | |
2498718 | 2498718 | 2022-05-12 | Salinas | Puerto Rico | 72123 | 4232 | |
2495460 | 2495460 | 2022-05-11 | Salinas | Puerto Rico | 72123 | 4213 | |
2492202 | 2492202 | 2022-05-10 | Salinas | Puerto Rico | 72123 | 4162 | |
2488944 | 2488944 | 2022-05-09 | Salinas | Puerto Rico | 72123 | 4156 | |
2485687 | 2485687 | 2022-05-08 | Salinas | Puerto Rico | 72123 | 4092 | |
2482429 | 2482429 | 2022-05-07 | Salinas | Puerto Rico | 72123 | 4091 | |
2479171 | 2479171 | 2022-05-06 | Salinas | Puerto Rico | 72123 | 4077 | |
2475913 | 2475913 | 2022-05-05 | Salinas | Puerto Rico | 72123 | 4008 | |
2472656 | 2472656 | 2022-05-04 | Salinas | Puerto Rico | 72123 | 3992 | |
2469400 | 2469400 | 2022-05-03 | Salinas | Puerto Rico | 72123 | 3920 | |
2466144 | 2466144 | 2022-05-02 | Salinas | Puerto Rico | 72123 | 3920 | |
2462889 | 2462889 | 2022-05-01 | Salinas | Puerto Rico | 72123 | 3912 | |
2459633 | 2459633 | 2022-04-30 | Salinas | Puerto Rico | 72123 | 3882 | |
2456377 | 2456377 | 2022-04-29 | Salinas | Puerto Rico | 72123 | 3861 | |
2453121 | 2453121 | 2022-04-28 | Salinas | Puerto Rico | 72123 | 3811 | |
2449865 | 2449865 | 2022-04-27 | Salinas | Puerto Rico | 72123 | 3785 | |
2446608 | 2446608 | 2022-04-26 | Salinas | Puerto Rico | 72123 | 3747 | |
2443353 | 2443353 | 2022-04-25 | Salinas | Puerto Rico | 72123 | 3746 | |
2440097 | 2440097 | 2022-04-24 | Salinas | Puerto Rico | 72123 | 3736 | |
2436841 | 2436841 | 2022-04-23 | Salinas | Puerto Rico | 72123 | 3714 | |
2433585 | 2433585 | 2022-04-22 | Salinas | Puerto Rico | 72123 | 3646 | |
2430329 | 2430329 | 2022-04-21 | Salinas | Puerto Rico | 72123 | 3620 | |
2427073 | 2427073 | 2022-04-20 | Salinas | Puerto Rico | 72123 | 3610 | |
2423817 | 2423817 | 2022-04-19 | Salinas | Puerto Rico | 72123 | 3579 | |
2420561 | 2420561 | 2022-04-18 | Salinas | Puerto Rico | 72123 | 3578 | |
2417305 | 2417305 | 2022-04-17 | Salinas | Puerto Rico | 72123 | 3570 | |
2414049 | 2414049 | 2022-04-16 | Salinas | Puerto Rico | 72123 | 3524 | |
2410793 | 2410793 | 2022-04-15 | Salinas | Puerto Rico | 72123 | 3524 | |
2407537 | 2407537 | 2022-04-14 | Salinas | Puerto Rico | 72123 | 3524 | |
2404281 | 2404281 | 2022-04-13 | Salinas | Puerto Rico | 72123 | 3515 | |
2401026 | 2401026 | 2022-04-12 | Salinas | Puerto Rico | 72123 | 3489 | |
2397771 | 2397771 | 2022-04-11 | Salinas | Puerto Rico | 72123 | 3487 | |
2394516 | 2394516 | 2022-04-10 | Salinas | Puerto Rico | 72123 | 3482 | |
2391260 | 2391260 | 2022-04-09 | Salinas | Puerto Rico | 72123 | 3459 | |
2388004 | 2388004 | 2022-04-08 | Salinas | Puerto Rico | 72123 | 3455 | |
2384749 | 2384749 | 2022-04-07 | Salinas | Puerto Rico | 72123 | 3447 | |
2381494 | 2381494 | 2022-04-06 | Salinas | Puerto Rico | 72123 | 3437 | |
2378239 | 2378239 | 2022-04-05 | Salinas | Puerto Rico | 72123 | 3435 | |
2374985 | 2374985 | 2022-04-04 | Salinas | Puerto Rico | 72123 | 3434 | |
2371733 | 2371733 | 2022-04-03 | Salinas | Puerto Rico | 72123 | 3432 | |
2368480 | 2368480 | 2022-04-02 | Salinas | Puerto Rico | 72123 | 3425 | |
2365227 | 2365227 | 2022-04-01 | Salinas | Puerto Rico | 72123 | 3424 | |
2361974 | 2361974 | 2022-03-31 | Salinas | Puerto Rico | 72123 | 3424 | |
2358720 | 2358720 | 2022-03-30 | Salinas | Puerto Rico | 72123 | 3422 | |
2355466 | 2355466 | 2022-03-29 | Salinas | Puerto Rico | 72123 | 3421 | |
2352213 | 2352213 | 2022-03-28 | Salinas | Puerto Rico | 72123 | 3421 | |
2348961 | 2348961 | 2022-03-27 | Salinas | Puerto Rico | 72123 | 3421 | |
2345708 | 2345708 | 2022-03-26 | Salinas | Puerto Rico | 72123 | 3421 | |
2342455 | 2342455 | 2022-03-25 | Salinas | Puerto Rico | 72123 | 3419 | |
2339202 | 2339202 | 2022-03-24 | Salinas | Puerto Rico | 72123 | 3416 | |
2335948 | 2335948 | 2022-03-23 | Salinas | Puerto Rico | 72123 | 3410 | |
2332694 | 2332694 | 2022-03-22 | Salinas | Puerto Rico | 72123 | 3408 | |
2329441 | 2329441 | 2022-03-21 | Salinas | Puerto Rico | 72123 | 3408 | |
2326189 | 2326189 | 2022-03-20 | Salinas | Puerto Rico | 72123 | 3406 | |
2322936 | 2322936 | 2022-03-19 | Salinas | Puerto Rico | 72123 | 3400 | |
2319682 | 2319682 | 2022-03-18 | Salinas | Puerto Rico | 72123 | 3396 | |
2316428 | 2316428 | 2022-03-17 | Salinas | Puerto Rico | 72123 | 3392 | |
2313175 | 2313175 | 2022-03-16 | Salinas | Puerto Rico | 72123 | 3390 | |
2309922 | 2309922 | 2022-03-15 | Salinas | Puerto Rico | 72123 | 3386 | |
2306669 | 2306669 | 2022-03-14 | Salinas | Puerto Rico | 72123 | 3385 | |
2303418 | 2303418 | 2022-03-13 | Salinas | Puerto Rico | 72123 | 3385 | |
2300166 | 2300166 | 2022-03-12 | Salinas | Puerto Rico | 72123 | 3379 | |
2296914 | 2296914 | 2022-03-11 | Salinas | Puerto Rico | 72123 | 3377 | |
2293662 | 2293662 | 2022-03-10 | Salinas | Puerto Rico | 72123 | 3376 | |
2290410 | 2290410 | 2022-03-09 | Salinas | Puerto Rico | 72123 | 3375 | |
2287158 | 2287158 | 2022-03-08 | Salinas | Puerto Rico | 72123 | 3373 | |
2283906 | 2283906 | 2022-03-07 | Salinas | Puerto Rico | 72123 | 3373 | |
2280654 | 2280654 | 2022-03-06 | Salinas | Puerto Rico | 72123 | 3373 | |
2277401 | 2277401 | 2022-03-05 | Salinas | Puerto Rico | 72123 | 3371 | |
2274148 | 2274148 | 2022-03-04 | Salinas | Puerto Rico | 72123 | 3369 | |
2270895 | 2270895 | 2022-03-03 | Salinas | Puerto Rico | 72123 | 3364 | |
2267643 | 2267643 | 2022-03-02 | Salinas | Puerto Rico | 72123 | 3359 | |
2264390 | 2264390 | 2022-03-01 | Salinas | Puerto Rico | 72123 | 3357 | |
2261140 | 2261140 | 2022-02-28 | Salinas | Puerto Rico | 72123 | 3356 | |
2257889 | 2257889 | 2022-02-27 | Salinas | Puerto Rico | 72123 | 3355 | |
2254638 | 2254638 | 2022-02-26 | Salinas | Puerto Rico | 72123 | 3353 | |
2251387 | 2251387 | 2022-02-25 | Salinas | Puerto Rico | 72123 | 3349 | |
2248136 | 2248136 | 2022-02-24 | Salinas | Puerto Rico | 72123 | 3342 | |
2244885 | 2244885 | 2022-02-23 | Salinas | Puerto Rico | 72123 | 3329 | |
2241634 | 2241634 | 2022-02-22 | Salinas | Puerto Rico | 72123 | 3328 | |
2238383 | 2238383 | 2022-02-21 | Salinas | Puerto Rico | 72123 | 3327 | |
2235132 | 2235132 | 2022-02-20 | Salinas | Puerto Rico | 72123 | 3325 | |
2231881 | 2231881 | 2022-02-19 | Salinas | Puerto Rico | 72123 | 3322 | |
2228630 | 2228630 | 2022-02-18 | Salinas | Puerto Rico | 72123 | 3318 | |
2225379 | 2225379 | 2022-02-17 | Salinas | Puerto Rico | 72123 | 3317 | |
2222128 | 2222128 | 2022-02-16 | Salinas | Puerto Rico | 72123 | 3314 | |
2218877 | 2218877 | 2022-02-15 | Salinas | Puerto Rico | 72123 | 3310 | |
2215626 | 2215626 | 2022-02-14 | Salinas | Puerto Rico | 72123 | 3310 | |
2212375 | 2212375 | 2022-02-13 | Salinas | Puerto Rico | 72123 | 3308 | |
2209122 | 2209122 | 2022-02-12 | Salinas | Puerto Rico | 72123 | 3287 | |
2205869 | 2205869 | 2022-02-11 | Salinas | Puerto Rico | 72123 | 3284 | |
2202616 | 2202616 | 2022-02-10 | Salinas | Puerto Rico | 72123 | 3277 | |
2199362 | 2199362 | 2022-02-09 | Salinas | Puerto Rico | 72123 | 3270 | |
2196108 | 2196108 | 2022-02-08 | Salinas | Puerto Rico | 72123 | 3265 | |
2192854 | 2192854 | 2022-02-07 | Salinas | Puerto Rico | 72123 | 3262 | |
2189600 | 2189600 | 2022-02-06 | Salinas | Puerto Rico | 72123 | 3261 | |
2186347 | 2186347 | 2022-02-05 | Salinas | Puerto Rico | 72123 | 3251 | |
2183095 | 2183095 | 2022-02-04 | Salinas | Puerto Rico | 72123 | 3252 | |
2179843 | 2179843 | 2022-02-03 | Salinas | Puerto Rico | 72123 | 3242 |
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);