ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,517 rows where county = "Lucas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500431 | 2500431 | 2022-05-13 | Lucas | Iowa | 19117 | 1763 | 32 |
2501691 | 2501691 | 2022-05-13 | Lucas | Ohio | 39095 | 103434 | 1420 |
2497173 | 2497173 | 2022-05-12 | Lucas | Iowa | 19117 | 1763 | 32 |
2498433 | 2498433 | 2022-05-12 | Lucas | Ohio | 39095 | 103434 | 1420 |
2493915 | 2493915 | 2022-05-11 | Lucas | Iowa | 19117 | 1763 | 32 |
2495175 | 2495175 | 2022-05-11 | Lucas | Ohio | 39095 | 102610 | 1417 |
2490657 | 2490657 | 2022-05-10 | Lucas | Iowa | 19117 | 1759 | 32 |
2491917 | 2491917 | 2022-05-10 | Lucas | Ohio | 39095 | 102610 | 1417 |
2487400 | 2487400 | 2022-05-09 | Lucas | Iowa | 19117 | 1759 | 32 |
2488659 | 2488659 | 2022-05-09 | Lucas | Ohio | 39095 | 102610 | 1417 |
2484142 | 2484142 | 2022-05-08 | Lucas | Iowa | 19117 | 1759 | 32 |
2485402 | 2485402 | 2022-05-08 | Lucas | Ohio | 39095 | 102610 | 1417 |
2480884 | 2480884 | 2022-05-07 | Lucas | Iowa | 19117 | 1759 | 32 |
2482144 | 2482144 | 2022-05-07 | Lucas | Ohio | 39095 | 102610 | 1417 |
2477626 | 2477626 | 2022-05-06 | Lucas | Iowa | 19117 | 1759 | 32 |
2478886 | 2478886 | 2022-05-06 | Lucas | Ohio | 39095 | 102610 | 1417 |
2474368 | 2474368 | 2022-05-05 | Lucas | Iowa | 19117 | 1759 | 32 |
2475628 | 2475628 | 2022-05-05 | Lucas | Ohio | 39095 | 102610 | 1417 |
2471111 | 2471111 | 2022-05-04 | Lucas | Iowa | 19117 | 1759 | 32 |
2472371 | 2472371 | 2022-05-04 | Lucas | Ohio | 39095 | 101988 | 1416 |
2467855 | 2467855 | 2022-05-03 | Lucas | Iowa | 19117 | 1755 | 32 |
2469115 | 2469115 | 2022-05-03 | Lucas | Ohio | 39095 | 101988 | 1416 |
2464600 | 2464600 | 2022-05-02 | Lucas | Iowa | 19117 | 1755 | 32 |
2465859 | 2465859 | 2022-05-02 | Lucas | Ohio | 39095 | 101988 | 1416 |
2461344 | 2461344 | 2022-05-01 | Lucas | Iowa | 19117 | 1755 | 32 |
2462604 | 2462604 | 2022-05-01 | Lucas | Ohio | 39095 | 101988 | 1416 |
2458088 | 2458088 | 2022-04-30 | Lucas | Iowa | 19117 | 1755 | 32 |
2459348 | 2459348 | 2022-04-30 | Lucas | Ohio | 39095 | 101988 | 1416 |
2454832 | 2454832 | 2022-04-29 | Lucas | Iowa | 19117 | 1755 | 32 |
2456092 | 2456092 | 2022-04-29 | Lucas | Ohio | 39095 | 101988 | 1416 |
2451576 | 2451576 | 2022-04-28 | Lucas | Iowa | 19117 | 1755 | 32 |
2452836 | 2452836 | 2022-04-28 | Lucas | Ohio | 39095 | 101988 | 1416 |
2448320 | 2448320 | 2022-04-27 | Lucas | Iowa | 19117 | 1755 | 32 |
2449580 | 2449580 | 2022-04-27 | Lucas | Ohio | 39095 | 101550 | 1415 |
2445064 | 2445064 | 2022-04-26 | Lucas | Iowa | 19117 | 1755 | 32 |
2446323 | 2446323 | 2022-04-26 | Lucas | Ohio | 39095 | 101550 | 1415 |
2441808 | 2441808 | 2022-04-25 | Lucas | Iowa | 19117 | 1755 | 32 |
2443068 | 2443068 | 2022-04-25 | Lucas | Ohio | 39095 | 101550 | 1415 |
2438552 | 2438552 | 2022-04-24 | Lucas | Iowa | 19117 | 1755 | 32 |
2439812 | 2439812 | 2022-04-24 | Lucas | Ohio | 39095 | 101550 | 1415 |
2435296 | 2435296 | 2022-04-23 | Lucas | Iowa | 19117 | 1755 | 32 |
2436556 | 2436556 | 2022-04-23 | Lucas | Ohio | 39095 | 101550 | 1415 |
2432040 | 2432040 | 2022-04-22 | Lucas | Iowa | 19117 | 1755 | 32 |
2433300 | 2433300 | 2022-04-22 | Lucas | Ohio | 39095 | 101550 | 1415 |
2428784 | 2428784 | 2022-04-21 | Lucas | Iowa | 19117 | 1755 | 32 |
2430044 | 2430044 | 2022-04-21 | Lucas | Ohio | 39095 | 101550 | 1415 |
2425528 | 2425528 | 2022-04-20 | Lucas | Iowa | 19117 | 1755 | 32 |
2426788 | 2426788 | 2022-04-20 | Lucas | Ohio | 39095 | 100856 | 1413 |
2422272 | 2422272 | 2022-04-19 | Lucas | Iowa | 19117 | 1754 | 32 |
2423532 | 2423532 | 2022-04-19 | Lucas | Ohio | 39095 | 100856 | 1413 |
2419016 | 2419016 | 2022-04-18 | Lucas | Iowa | 19117 | 1754 | 32 |
2420275 | 2420275 | 2022-04-18 | Lucas | Ohio | 39095 | 100856 | 1413 |
2415760 | 2415760 | 2022-04-17 | Lucas | Iowa | 19117 | 1754 | 32 |
2417020 | 2417020 | 2022-04-17 | Lucas | Ohio | 39095 | 100856 | 1413 |
2412504 | 2412504 | 2022-04-16 | Lucas | Iowa | 19117 | 1754 | 32 |
2413764 | 2413764 | 2022-04-16 | Lucas | Ohio | 39095 | 100856 | 1413 |
2409248 | 2409248 | 2022-04-15 | Lucas | Iowa | 19117 | 1754 | 32 |
2410508 | 2410508 | 2022-04-15 | Lucas | Ohio | 39095 | 100856 | 1413 |
2405992 | 2405992 | 2022-04-14 | Lucas | Iowa | 19117 | 1754 | 32 |
2407252 | 2407252 | 2022-04-14 | Lucas | Ohio | 39095 | 100856 | 1413 |
2402736 | 2402736 | 2022-04-13 | Lucas | Iowa | 19117 | 1754 | 32 |
2403996 | 2403996 | 2022-04-13 | Lucas | Ohio | 39095 | 100143 | 1408 |
2399482 | 2399482 | 2022-04-12 | Lucas | Iowa | 19117 | 1752 | 32 |
2400741 | 2400741 | 2022-04-12 | Lucas | Ohio | 39095 | 100143 | 1408 |
2396226 | 2396226 | 2022-04-11 | Lucas | Iowa | 19117 | 1752 | 32 |
2397486 | 2397486 | 2022-04-11 | Lucas | Ohio | 39095 | 100143 | 1408 |
2392971 | 2392971 | 2022-04-10 | Lucas | Iowa | 19117 | 1752 | 32 |
2394231 | 2394231 | 2022-04-10 | Lucas | Ohio | 39095 | 100143 | 1408 |
2389715 | 2389715 | 2022-04-09 | Lucas | Iowa | 19117 | 1752 | 32 |
2390975 | 2390975 | 2022-04-09 | Lucas | Ohio | 39095 | 100143 | 1408 |
2386459 | 2386459 | 2022-04-08 | Lucas | Iowa | 19117 | 1752 | 32 |
2387719 | 2387719 | 2022-04-08 | Lucas | Ohio | 39095 | 100143 | 1408 |
2383205 | 2383205 | 2022-04-07 | Lucas | Iowa | 19117 | 1752 | 32 |
2384464 | 2384464 | 2022-04-07 | Lucas | Ohio | 39095 | 100143 | 1408 |
2379950 | 2379950 | 2022-04-06 | Lucas | Iowa | 19117 | 1752 | 32 |
2381209 | 2381209 | 2022-04-06 | Lucas | Ohio | 39095 | 99702 | 1401 |
2376695 | 2376695 | 2022-04-05 | Lucas | Iowa | 19117 | 1749 | 32 |
2377954 | 2377954 | 2022-04-05 | Lucas | Ohio | 39095 | 99702 | 1401 |
2373443 | 2373443 | 2022-04-04 | Lucas | Iowa | 19117 | 1749 | 32 |
2374700 | 2374700 | 2022-04-04 | Lucas | Ohio | 39095 | 99702 | 1401 |
2370190 | 2370190 | 2022-04-03 | Lucas | Iowa | 19117 | 1749 | 32 |
2371448 | 2371448 | 2022-04-03 | Lucas | Ohio | 39095 | 99702 | 1401 |
2366937 | 2366937 | 2022-04-02 | Lucas | Iowa | 19117 | 1749 | 32 |
2368195 | 2368195 | 2022-04-02 | Lucas | Ohio | 39095 | 99702 | 1401 |
2363684 | 2363684 | 2022-04-01 | Lucas | Iowa | 19117 | 1749 | 32 |
2364942 | 2364942 | 2022-04-01 | Lucas | Ohio | 39095 | 99702 | 1401 |
2360430 | 2360430 | 2022-03-31 | Lucas | Iowa | 19117 | 1749 | 32 |
2361689 | 2361689 | 2022-03-31 | Lucas | Ohio | 39095 | 99702 | 1401 |
2357176 | 2357176 | 2022-03-30 | Lucas | Iowa | 19117 | 1749 | 32 |
2358435 | 2358435 | 2022-03-30 | Lucas | Ohio | 39095 | 99617 | 1392 |
2353923 | 2353923 | 2022-03-29 | Lucas | Iowa | 19117 | 1748 | 32 |
2355181 | 2355181 | 2022-03-29 | Lucas | Ohio | 39095 | 99617 | 1392 |
2350671 | 2350671 | 2022-03-28 | Lucas | Iowa | 19117 | 1748 | 32 |
2351928 | 2351928 | 2022-03-28 | Lucas | Ohio | 39095 | 99617 | 1392 |
2347418 | 2347418 | 2022-03-27 | Lucas | Iowa | 19117 | 1748 | 32 |
2348676 | 2348676 | 2022-03-27 | Lucas | Ohio | 39095 | 99617 | 1392 |
2344165 | 2344165 | 2022-03-26 | Lucas | Iowa | 19117 | 1748 | 32 |
2345423 | 2345423 | 2022-03-26 | Lucas | Ohio | 39095 | 99617 | 1392 |
2340912 | 2340912 | 2022-03-25 | Lucas | Iowa | 19117 | 1748 | 32 |
2342170 | 2342170 | 2022-03-25 | Lucas | Ohio | 39095 | 99617 | 1392 |
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);