ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ciales" 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 |
---|---|---|---|---|---|---|---|
2501933 | 2501933 | 2022-05-13 | Ciales | Puerto Rico | 72039 | 3037 | |
2498675 | 2498675 | 2022-05-12 | Ciales | Puerto Rico | 72039 | 3030 | |
2495417 | 2495417 | 2022-05-11 | Ciales | Puerto Rico | 72039 | 3005 | |
2492159 | 2492159 | 2022-05-10 | Ciales | Puerto Rico | 72039 | 2984 | |
2488901 | 2488901 | 2022-05-09 | Ciales | Puerto Rico | 72039 | 2975 | |
2485644 | 2485644 | 2022-05-08 | Ciales | Puerto Rico | 72039 | 2947 | |
2482386 | 2482386 | 2022-05-07 | Ciales | Puerto Rico | 72039 | 2947 | |
2479128 | 2479128 | 2022-05-06 | Ciales | Puerto Rico | 72039 | 2925 | |
2475870 | 2475870 | 2022-05-05 | Ciales | Puerto Rico | 72039 | 2899 | |
2472613 | 2472613 | 2022-05-04 | Ciales | Puerto Rico | 72039 | 2881 | |
2469357 | 2469357 | 2022-05-03 | Ciales | Puerto Rico | 72039 | 2862 | |
2466101 | 2466101 | 2022-05-02 | Ciales | Puerto Rico | 72039 | 2854 | |
2462846 | 2462846 | 2022-05-01 | Ciales | Puerto Rico | 72039 | 2842 | |
2459590 | 2459590 | 2022-04-30 | Ciales | Puerto Rico | 72039 | 2820 | |
2456334 | 2456334 | 2022-04-29 | Ciales | Puerto Rico | 72039 | 2793 | |
2453078 | 2453078 | 2022-04-28 | Ciales | Puerto Rico | 72039 | 2765 | |
2449822 | 2449822 | 2022-04-27 | Ciales | Puerto Rico | 72039 | 2746 | |
2446565 | 2446565 | 2022-04-26 | Ciales | Puerto Rico | 72039 | 2732 | |
2443310 | 2443310 | 2022-04-25 | Ciales | Puerto Rico | 72039 | 2728 | |
2440054 | 2440054 | 2022-04-24 | Ciales | Puerto Rico | 72039 | 2714 | |
2436798 | 2436798 | 2022-04-23 | Ciales | Puerto Rico | 72039 | 2696 | |
2433542 | 2433542 | 2022-04-22 | Ciales | Puerto Rico | 72039 | 2670 | |
2430286 | 2430286 | 2022-04-21 | Ciales | Puerto Rico | 72039 | 2636 | |
2427030 | 2427030 | 2022-04-20 | Ciales | Puerto Rico | 72039 | 2601 | |
2423774 | 2423774 | 2022-04-19 | Ciales | Puerto Rico | 72039 | 2591 | |
2420518 | 2420518 | 2022-04-18 | Ciales | Puerto Rico | 72039 | 2588 | |
2417262 | 2417262 | 2022-04-17 | Ciales | Puerto Rico | 72039 | 2585 | |
2414006 | 2414006 | 2022-04-16 | Ciales | Puerto Rico | 72039 | 2551 | |
2410750 | 2410750 | 2022-04-15 | Ciales | Puerto Rico | 72039 | 2551 | |
2407494 | 2407494 | 2022-04-14 | Ciales | Puerto Rico | 72039 | 2551 | |
2404238 | 2404238 | 2022-04-13 | Ciales | Puerto Rico | 72039 | 2545 | |
2400983 | 2400983 | 2022-04-12 | Ciales | Puerto Rico | 72039 | 2537 | |
2397728 | 2397728 | 2022-04-11 | Ciales | Puerto Rico | 72039 | 2536 | |
2394473 | 2394473 | 2022-04-10 | Ciales | Puerto Rico | 72039 | 2533 | |
2391217 | 2391217 | 2022-04-09 | Ciales | Puerto Rico | 72039 | 2530 | |
2387961 | 2387961 | 2022-04-08 | Ciales | Puerto Rico | 72039 | 2528 | |
2384706 | 2384706 | 2022-04-07 | Ciales | Puerto Rico | 72039 | 2525 | |
2381451 | 2381451 | 2022-04-06 | Ciales | Puerto Rico | 72039 | 2517 | |
2378196 | 2378196 | 2022-04-05 | Ciales | Puerto Rico | 72039 | 2517 | |
2374942 | 2374942 | 2022-04-04 | Ciales | Puerto Rico | 72039 | 2517 | |
2371690 | 2371690 | 2022-04-03 | Ciales | Puerto Rico | 72039 | 2515 | |
2368437 | 2368437 | 2022-04-02 | Ciales | Puerto Rico | 72039 | 2511 | |
2365184 | 2365184 | 2022-04-01 | Ciales | Puerto Rico | 72039 | 2506 | |
2361931 | 2361931 | 2022-03-31 | Ciales | Puerto Rico | 72039 | 2502 | |
2358677 | 2358677 | 2022-03-30 | Ciales | Puerto Rico | 72039 | 2498 | |
2355423 | 2355423 | 2022-03-29 | Ciales | Puerto Rico | 72039 | 2497 | |
2352170 | 2352170 | 2022-03-28 | Ciales | Puerto Rico | 72039 | 2497 | |
2348918 | 2348918 | 2022-03-27 | Ciales | Puerto Rico | 72039 | 2497 | |
2345665 | 2345665 | 2022-03-26 | Ciales | Puerto Rico | 72039 | 2495 | |
2342412 | 2342412 | 2022-03-25 | Ciales | Puerto Rico | 72039 | 2493 | |
2339159 | 2339159 | 2022-03-24 | Ciales | Puerto Rico | 72039 | 2493 | |
2335905 | 2335905 | 2022-03-23 | Ciales | Puerto Rico | 72039 | 2493 | |
2332651 | 2332651 | 2022-03-22 | Ciales | Puerto Rico | 72039 | 2493 | |
2329398 | 2329398 | 2022-03-21 | Ciales | Puerto Rico | 72039 | 2493 | |
2326146 | 2326146 | 2022-03-20 | Ciales | Puerto Rico | 72039 | 2492 | |
2322893 | 2322893 | 2022-03-19 | Ciales | Puerto Rico | 72039 | 2492 | |
2319639 | 2319639 | 2022-03-18 | Ciales | Puerto Rico | 72039 | 2492 | |
2316385 | 2316385 | 2022-03-17 | Ciales | Puerto Rico | 72039 | 2492 | |
2313132 | 2313132 | 2022-03-16 | Ciales | Puerto Rico | 72039 | 2490 | |
2309879 | 2309879 | 2022-03-15 | Ciales | Puerto Rico | 72039 | 2489 | |
2306626 | 2306626 | 2022-03-14 | Ciales | Puerto Rico | 72039 | 2489 | |
2303375 | 2303375 | 2022-03-13 | Ciales | Puerto Rico | 72039 | 2489 | |
2300123 | 2300123 | 2022-03-12 | Ciales | Puerto Rico | 72039 | 2485 | |
2296871 | 2296871 | 2022-03-11 | Ciales | Puerto Rico | 72039 | 2485 | |
2293619 | 2293619 | 2022-03-10 | Ciales | Puerto Rico | 72039 | 2483 | |
2290367 | 2290367 | 2022-03-09 | Ciales | Puerto Rico | 72039 | 2482 | |
2287115 | 2287115 | 2022-03-08 | Ciales | Puerto Rico | 72039 | 2481 | |
2283863 | 2283863 | 2022-03-07 | Ciales | Puerto Rico | 72039 | 2481 | |
2280611 | 2280611 | 2022-03-06 | Ciales | Puerto Rico | 72039 | 2481 | |
2277358 | 2277358 | 2022-03-05 | Ciales | Puerto Rico | 72039 | 2477 | |
2274105 | 2274105 | 2022-03-04 | Ciales | Puerto Rico | 72039 | 2476 | |
2270852 | 2270852 | 2022-03-03 | Ciales | Puerto Rico | 72039 | 2475 | |
2267600 | 2267600 | 2022-03-02 | Ciales | Puerto Rico | 72039 | 2475 | |
2264347 | 2264347 | 2022-03-01 | Ciales | Puerto Rico | 72039 | 2474 | |
2261097 | 2261097 | 2022-02-28 | Ciales | Puerto Rico | 72039 | 2474 | |
2257846 | 2257846 | 2022-02-27 | Ciales | Puerto Rico | 72039 | 2471 | |
2254595 | 2254595 | 2022-02-26 | Ciales | Puerto Rico | 72039 | 2470 | |
2251344 | 2251344 | 2022-02-25 | Ciales | Puerto Rico | 72039 | 2468 | |
2248093 | 2248093 | 2022-02-24 | Ciales | Puerto Rico | 72039 | 2465 | |
2244842 | 2244842 | 2022-02-23 | Ciales | Puerto Rico | 72039 | 2463 | |
2241591 | 2241591 | 2022-02-22 | Ciales | Puerto Rico | 72039 | 2464 | |
2238340 | 2238340 | 2022-02-21 | Ciales | Puerto Rico | 72039 | 2464 | |
2235089 | 2235089 | 2022-02-20 | Ciales | Puerto Rico | 72039 | 2462 | |
2231838 | 2231838 | 2022-02-19 | Ciales | Puerto Rico | 72039 | 2456 | |
2228587 | 2228587 | 2022-02-18 | Ciales | Puerto Rico | 72039 | 2453 | |
2225336 | 2225336 | 2022-02-17 | Ciales | Puerto Rico | 72039 | 2452 | |
2222085 | 2222085 | 2022-02-16 | Ciales | Puerto Rico | 72039 | 2450 | |
2218834 | 2218834 | 2022-02-15 | Ciales | Puerto Rico | 72039 | 2448 | |
2215583 | 2215583 | 2022-02-14 | Ciales | Puerto Rico | 72039 | 2448 | |
2212332 | 2212332 | 2022-02-13 | Ciales | Puerto Rico | 72039 | 2447 | |
2209079 | 2209079 | 2022-02-12 | Ciales | Puerto Rico | 72039 | 2441 | |
2205826 | 2205826 | 2022-02-11 | Ciales | Puerto Rico | 72039 | 2437 | |
2202573 | 2202573 | 2022-02-10 | Ciales | Puerto Rico | 72039 | 2432 | |
2199319 | 2199319 | 2022-02-09 | Ciales | Puerto Rico | 72039 | 2428 | |
2196065 | 2196065 | 2022-02-08 | Ciales | Puerto Rico | 72039 | 2428 | |
2192811 | 2192811 | 2022-02-07 | Ciales | Puerto Rico | 72039 | 2428 | |
2189557 | 2189557 | 2022-02-06 | Ciales | Puerto Rico | 72039 | 2426 | |
2186304 | 2186304 | 2022-02-05 | Ciales | Puerto Rico | 72039 | 2420 | |
2183052 | 2183052 | 2022-02-04 | Ciales | Puerto Rico | 72039 | 2416 | |
2179800 | 2179800 | 2022-02-03 | Ciales | Puerto Rico | 72039 | 2408 |
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);