ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Florida" 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 |
---|---|---|---|---|---|---|---|
2501941 | 2501941 | 2022-05-13 | Florida | Puerto Rico | 72054 | 2900 | |
2498683 | 2498683 | 2022-05-12 | Florida | Puerto Rico | 72054 | 2886 | |
2495425 | 2495425 | 2022-05-11 | Florida | Puerto Rico | 72054 | 2862 | |
2492167 | 2492167 | 2022-05-10 | Florida | Puerto Rico | 72054 | 2850 | |
2488909 | 2488909 | 2022-05-09 | Florida | Puerto Rico | 72054 | 2848 | |
2485652 | 2485652 | 2022-05-08 | Florida | Puerto Rico | 72054 | 2821 | |
2482394 | 2482394 | 2022-05-07 | Florida | Puerto Rico | 72054 | 2821 | |
2479136 | 2479136 | 2022-05-06 | Florida | Puerto Rico | 72054 | 2801 | |
2475878 | 2475878 | 2022-05-05 | Florida | Puerto Rico | 72054 | 2778 | |
2472621 | 2472621 | 2022-05-04 | Florida | Puerto Rico | 72054 | 2744 | |
2469365 | 2469365 | 2022-05-03 | Florida | Puerto Rico | 72054 | 2732 | |
2466109 | 2466109 | 2022-05-02 | Florida | Puerto Rico | 72054 | 2731 | |
2462854 | 2462854 | 2022-05-01 | Florida | Puerto Rico | 72054 | 2720 | |
2459598 | 2459598 | 2022-04-30 | Florida | Puerto Rico | 72054 | 2707 | |
2456342 | 2456342 | 2022-04-29 | Florida | Puerto Rico | 72054 | 2665 | |
2453086 | 2453086 | 2022-04-28 | Florida | Puerto Rico | 72054 | 2647 | |
2449830 | 2449830 | 2022-04-27 | Florida | Puerto Rico | 72054 | 2610 | |
2446573 | 2446573 | 2022-04-26 | Florida | Puerto Rico | 72054 | 2597 | |
2443318 | 2443318 | 2022-04-25 | Florida | Puerto Rico | 72054 | 2594 | |
2440062 | 2440062 | 2022-04-24 | Florida | Puerto Rico | 72054 | 2587 | |
2436806 | 2436806 | 2022-04-23 | Florida | Puerto Rico | 72054 | 2553 | |
2433550 | 2433550 | 2022-04-22 | Florida | Puerto Rico | 72054 | 2513 | |
2430294 | 2430294 | 2022-04-21 | Florida | Puerto Rico | 72054 | 2492 | |
2427038 | 2427038 | 2022-04-20 | Florida | Puerto Rico | 72054 | 2481 | |
2423782 | 2423782 | 2022-04-19 | Florida | Puerto Rico | 72054 | 2473 | |
2420526 | 2420526 | 2022-04-18 | Florida | Puerto Rico | 72054 | 2472 | |
2417270 | 2417270 | 2022-04-17 | Florida | Puerto Rico | 72054 | 2472 | |
2414014 | 2414014 | 2022-04-16 | Florida | Puerto Rico | 72054 | 2465 | |
2410758 | 2410758 | 2022-04-15 | Florida | Puerto Rico | 72054 | 2465 | |
2407502 | 2407502 | 2022-04-14 | Florida | Puerto Rico | 72054 | 2465 | |
2404246 | 2404246 | 2022-04-13 | Florida | Puerto Rico | 72054 | 2459 | |
2400991 | 2400991 | 2022-04-12 | Florida | Puerto Rico | 72054 | 2458 | |
2397736 | 2397736 | 2022-04-11 | Florida | Puerto Rico | 72054 | 2458 | |
2394481 | 2394481 | 2022-04-10 | Florida | Puerto Rico | 72054 | 2458 | |
2391225 | 2391225 | 2022-04-09 | Florida | Puerto Rico | 72054 | 2454 | |
2387969 | 2387969 | 2022-04-08 | Florida | Puerto Rico | 72054 | 2451 | |
2384714 | 2384714 | 2022-04-07 | Florida | Puerto Rico | 72054 | 2446 | |
2381459 | 2381459 | 2022-04-06 | Florida | Puerto Rico | 72054 | 2441 | |
2378204 | 2378204 | 2022-04-05 | Florida | Puerto Rico | 72054 | 2438 | |
2374950 | 2374950 | 2022-04-04 | Florida | Puerto Rico | 72054 | 2438 | |
2371698 | 2371698 | 2022-04-03 | Florida | Puerto Rico | 72054 | 2438 | |
2368445 | 2368445 | 2022-04-02 | Florida | Puerto Rico | 72054 | 2433 | |
2365192 | 2365192 | 2022-04-01 | Florida | Puerto Rico | 72054 | 2432 | |
2361939 | 2361939 | 2022-03-31 | Florida | Puerto Rico | 72054 | 2431 | |
2358685 | 2358685 | 2022-03-30 | Florida | Puerto Rico | 72054 | 2427 | |
2355431 | 2355431 | 2022-03-29 | Florida | Puerto Rico | 72054 | 2420 | |
2352178 | 2352178 | 2022-03-28 | Florida | Puerto Rico | 72054 | 2420 | |
2348926 | 2348926 | 2022-03-27 | Florida | Puerto Rico | 72054 | 2418 | |
2345673 | 2345673 | 2022-03-26 | Florida | Puerto Rico | 72054 | 2418 | |
2342420 | 2342420 | 2022-03-25 | Florida | Puerto Rico | 72054 | 2414 | |
2339167 | 2339167 | 2022-03-24 | Florida | Puerto Rico | 72054 | 2412 | |
2335913 | 2335913 | 2022-03-23 | Florida | Puerto Rico | 72054 | 2410 | |
2332659 | 2332659 | 2022-03-22 | Florida | Puerto Rico | 72054 | 2409 | |
2329406 | 2329406 | 2022-03-21 | Florida | Puerto Rico | 72054 | 2409 | |
2326154 | 2326154 | 2022-03-20 | Florida | Puerto Rico | 72054 | 2409 | |
2322901 | 2322901 | 2022-03-19 | Florida | Puerto Rico | 72054 | 2409 | |
2319647 | 2319647 | 2022-03-18 | Florida | Puerto Rico | 72054 | 2408 | |
2316393 | 2316393 | 2022-03-17 | Florida | Puerto Rico | 72054 | 2407 | |
2313140 | 2313140 | 2022-03-16 | Florida | Puerto Rico | 72054 | 2404 | |
2309887 | 2309887 | 2022-03-15 | Florida | Puerto Rico | 72054 | 2401 | |
2306634 | 2306634 | 2022-03-14 | Florida | Puerto Rico | 72054 | 2401 | |
2303383 | 2303383 | 2022-03-13 | Florida | Puerto Rico | 72054 | 2400 | |
2300131 | 2300131 | 2022-03-12 | Florida | Puerto Rico | 72054 | 2399 | |
2296879 | 2296879 | 2022-03-11 | Florida | Puerto Rico | 72054 | 2397 | |
2293627 | 2293627 | 2022-03-10 | Florida | Puerto Rico | 72054 | 2395 | |
2290375 | 2290375 | 2022-03-09 | Florida | Puerto Rico | 72054 | 2394 | |
2287123 | 2287123 | 2022-03-08 | Florida | Puerto Rico | 72054 | 2393 | |
2283871 | 2283871 | 2022-03-07 | Florida | Puerto Rico | 72054 | 2393 | |
2280619 | 2280619 | 2022-03-06 | Florida | Puerto Rico | 72054 | 2393 | |
2277366 | 2277366 | 2022-03-05 | Florida | Puerto Rico | 72054 | 2392 | |
2274113 | 2274113 | 2022-03-04 | Florida | Puerto Rico | 72054 | 2386 | |
2270860 | 2270860 | 2022-03-03 | Florida | Puerto Rico | 72054 | 2382 | |
2267608 | 2267608 | 2022-03-02 | Florida | Puerto Rico | 72054 | 2379 | |
2264355 | 2264355 | 2022-03-01 | Florida | Puerto Rico | 72054 | 2373 | |
2261105 | 2261105 | 2022-02-28 | Florida | Puerto Rico | 72054 | 2373 | |
2257854 | 2257854 | 2022-02-27 | Florida | Puerto Rico | 72054 | 2373 | |
2254603 | 2254603 | 2022-02-26 | Florida | Puerto Rico | 72054 | 2369 | |
2251352 | 2251352 | 2022-02-25 | Florida | Puerto Rico | 72054 | 2364 | |
2248101 | 2248101 | 2022-02-24 | Florida | Puerto Rico | 72054 | 2362 | |
2244850 | 2244850 | 2022-02-23 | Florida | Puerto Rico | 72054 | 2360 | |
2241599 | 2241599 | 2022-02-22 | Florida | Puerto Rico | 72054 | 2360 | |
2238348 | 2238348 | 2022-02-21 | Florida | Puerto Rico | 72054 | 2360 | |
2235097 | 2235097 | 2022-02-20 | Florida | Puerto Rico | 72054 | 2359 | |
2231846 | 2231846 | 2022-02-19 | Florida | Puerto Rico | 72054 | 2357 | |
2228595 | 2228595 | 2022-02-18 | Florida | Puerto Rico | 72054 | 2355 | |
2225344 | 2225344 | 2022-02-17 | Florida | Puerto Rico | 72054 | 2354 | |
2222093 | 2222093 | 2022-02-16 | Florida | Puerto Rico | 72054 | 2351 | |
2218842 | 2218842 | 2022-02-15 | Florida | Puerto Rico | 72054 | 2341 | |
2215591 | 2215591 | 2022-02-14 | Florida | Puerto Rico | 72054 | 2341 | |
2212340 | 2212340 | 2022-02-13 | Florida | Puerto Rico | 72054 | 2341 | |
2209087 | 2209087 | 2022-02-12 | Florida | Puerto Rico | 72054 | 2338 | |
2205834 | 2205834 | 2022-02-11 | Florida | Puerto Rico | 72054 | 2336 | |
2202581 | 2202581 | 2022-02-10 | Florida | Puerto Rico | 72054 | 2328 | |
2199327 | 2199327 | 2022-02-09 | Florida | Puerto Rico | 72054 | 2324 | |
2196073 | 2196073 | 2022-02-08 | Florida | Puerto Rico | 72054 | 2321 | |
2192819 | 2192819 | 2022-02-07 | Florida | Puerto Rico | 72054 | 2321 | |
2189565 | 2189565 | 2022-02-06 | Florida | Puerto Rico | 72054 | 2321 | |
2186312 | 2186312 | 2022-02-05 | Florida | Puerto Rico | 72054 | 2318 | |
2183060 | 2183060 | 2022-02-04 | Florida | Puerto Rico | 72054 | 2314 | |
2179808 | 2179808 | 2022-02-03 | Florida | Puerto Rico | 72054 | 2310 |
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);