ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,560 rows where county = "Ripley" 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 |
---|---|---|---|---|---|---|---|
2500348 | 2500348 | 2022-05-13 | Ripley | Indiana | 18137 | 8360 | 138 |
2501168 | 2501168 | 2022-05-13 | Ripley | Missouri | 29181 | 2697 | 61 |
2497090 | 2497090 | 2022-05-12 | Ripley | Indiana | 18137 | 8352 | 138 |
2497910 | 2497910 | 2022-05-12 | Ripley | Missouri | 29181 | 2695 | 61 |
2493832 | 2493832 | 2022-05-11 | Ripley | Indiana | 18137 | 8352 | 138 |
2494652 | 2494652 | 2022-05-11 | Ripley | Missouri | 29181 | 2695 | 61 |
2490574 | 2490574 | 2022-05-10 | Ripley | Indiana | 18137 | 8341 | 138 |
2491394 | 2491394 | 2022-05-10 | Ripley | Missouri | 29181 | 2695 | 61 |
2487317 | 2487317 | 2022-05-09 | Ripley | Indiana | 18137 | 8341 | 138 |
2488136 | 2488136 | 2022-05-09 | Ripley | Missouri | 29181 | 2695 | 61 |
2484059 | 2484059 | 2022-05-08 | Ripley | Indiana | 18137 | 8329 | 138 |
2484879 | 2484879 | 2022-05-08 | Ripley | Missouri | 29181 | 2695 | 61 |
2480801 | 2480801 | 2022-05-07 | Ripley | Indiana | 18137 | 8329 | 138 |
2481621 | 2481621 | 2022-05-07 | Ripley | Missouri | 29181 | 2695 | 61 |
2477543 | 2477543 | 2022-05-06 | Ripley | Indiana | 18137 | 8329 | 138 |
2478363 | 2478363 | 2022-05-06 | Ripley | Missouri | 29181 | 2695 | 61 |
2474285 | 2474285 | 2022-05-05 | Ripley | Indiana | 18137 | 8329 | 138 |
2475105 | 2475105 | 2022-05-05 | Ripley | Missouri | 29181 | 2693 | 61 |
2471028 | 2471028 | 2022-05-04 | Ripley | Indiana | 18137 | 8329 | 138 |
2471848 | 2471848 | 2022-05-04 | Ripley | Missouri | 29181 | 2690 | 61 |
2467772 | 2467772 | 2022-05-03 | Ripley | Indiana | 18137 | 8323 | 138 |
2468592 | 2468592 | 2022-05-03 | Ripley | Missouri | 29181 | 2690 | 61 |
2464517 | 2464517 | 2022-05-02 | Ripley | Indiana | 18137 | 8323 | 138 |
2465336 | 2465336 | 2022-05-02 | Ripley | Missouri | 29181 | 2690 | 61 |
2461261 | 2461261 | 2022-05-01 | Ripley | Indiana | 18137 | 8317 | 138 |
2462081 | 2462081 | 2022-05-01 | Ripley | Missouri | 29181 | 2690 | 61 |
2458005 | 2458005 | 2022-04-30 | Ripley | Indiana | 18137 | 8317 | 138 |
2458825 | 2458825 | 2022-04-30 | Ripley | Missouri | 29181 | 2690 | 61 |
2454749 | 2454749 | 2022-04-29 | Ripley | Indiana | 18137 | 8317 | 138 |
2455569 | 2455569 | 2022-04-29 | Ripley | Missouri | 29181 | 2690 | 61 |
2451493 | 2451493 | 2022-04-28 | Ripley | Indiana | 18137 | 8309 | 138 |
2452313 | 2452313 | 2022-04-28 | Ripley | Missouri | 29181 | 2690 | 61 |
2448237 | 2448237 | 2022-04-27 | Ripley | Indiana | 18137 | 8309 | 138 |
2449057 | 2449057 | 2022-04-27 | Ripley | Missouri | 29181 | 2690 | 61 |
2444981 | 2444981 | 2022-04-26 | Ripley | Indiana | 18137 | 8304 | 138 |
2445800 | 2445800 | 2022-04-26 | Ripley | Missouri | 29181 | 2690 | 61 |
2441725 | 2441725 | 2022-04-25 | Ripley | Indiana | 18137 | 8304 | 138 |
2442545 | 2442545 | 2022-04-25 | Ripley | Missouri | 29181 | 2690 | 61 |
2438469 | 2438469 | 2022-04-24 | Ripley | Indiana | 18137 | 8300 | 138 |
2439289 | 2439289 | 2022-04-24 | Ripley | Missouri | 29181 | 2690 | 61 |
2435213 | 2435213 | 2022-04-23 | Ripley | Indiana | 18137 | 8300 | 138 |
2436033 | 2436033 | 2022-04-23 | Ripley | Missouri | 29181 | 2690 | 61 |
2431957 | 2431957 | 2022-04-22 | Ripley | Indiana | 18137 | 8300 | 138 |
2432777 | 2432777 | 2022-04-22 | Ripley | Missouri | 29181 | 2690 | 61 |
2428701 | 2428701 | 2022-04-21 | Ripley | Indiana | 18137 | 8297 | 138 |
2429521 | 2429521 | 2022-04-21 | Ripley | Missouri | 29181 | 2690 | 61 |
2425445 | 2425445 | 2022-04-20 | Ripley | Indiana | 18137 | 8297 | 138 |
2426265 | 2426265 | 2022-04-20 | Ripley | Missouri | 29181 | 2690 | 61 |
2422189 | 2422189 | 2022-04-19 | Ripley | Indiana | 18137 | 8295 | 138 |
2423009 | 2423009 | 2022-04-19 | Ripley | Missouri | 29181 | 2690 | 61 |
2418933 | 2418933 | 2022-04-18 | Ripley | Indiana | 18137 | 8295 | 138 |
2419752 | 2419752 | 2022-04-18 | Ripley | Missouri | 29181 | 2690 | 61 |
2415677 | 2415677 | 2022-04-17 | Ripley | Indiana | 18137 | 8289 | 138 |
2416497 | 2416497 | 2022-04-17 | Ripley | Missouri | 29181 | 2690 | 61 |
2412421 | 2412421 | 2022-04-16 | Ripley | Indiana | 18137 | 8289 | 138 |
2413241 | 2413241 | 2022-04-16 | Ripley | Missouri | 29181 | 2690 | 61 |
2409165 | 2409165 | 2022-04-15 | Ripley | Indiana | 18137 | 8289 | 138 |
2409985 | 2409985 | 2022-04-15 | Ripley | Missouri | 29181 | 2690 | 61 |
2405909 | 2405909 | 2022-04-14 | Ripley | Indiana | 18137 | 8289 | 138 |
2406729 | 2406729 | 2022-04-14 | Ripley | Missouri | 29181 | 2690 | 61 |
2402654 | 2402654 | 2022-04-13 | Ripley | Indiana | 18137 | 8289 | 138 |
2403473 | 2403473 | 2022-04-13 | Ripley | Missouri | 29181 | 2690 | 61 |
2399399 | 2399399 | 2022-04-12 | Ripley | Indiana | 18137 | 8287 | 138 |
2400218 | 2400218 | 2022-04-12 | Ripley | Missouri | 29181 | 2690 | 61 |
2396144 | 2396144 | 2022-04-11 | Ripley | Indiana | 18137 | 8287 | 138 |
2396963 | 2396963 | 2022-04-11 | Ripley | Missouri | 29181 | 2690 | 61 |
2392888 | 2392888 | 2022-04-10 | Ripley | Indiana | 18137 | 8288 | 138 |
2393708 | 2393708 | 2022-04-10 | Ripley | Missouri | 29181 | 2690 | 61 |
2389632 | 2389632 | 2022-04-09 | Ripley | Indiana | 18137 | 8288 | 138 |
2390452 | 2390452 | 2022-04-09 | Ripley | Missouri | 29181 | 2690 | 61 |
2386377 | 2386377 | 2022-04-08 | Ripley | Indiana | 18137 | 8288 | 138 |
2387196 | 2387196 | 2022-04-08 | Ripley | Missouri | 29181 | 2690 | 61 |
2383122 | 2383122 | 2022-04-07 | Ripley | Indiana | 18137 | 8285 | 138 |
2383941 | 2383941 | 2022-04-07 | Ripley | Missouri | 29181 | 2690 | 61 |
2379867 | 2379867 | 2022-04-06 | Ripley | Indiana | 18137 | 8285 | 138 |
2380686 | 2380686 | 2022-04-06 | Ripley | Missouri | 29181 | 2690 | 61 |
2376613 | 2376613 | 2022-04-05 | Ripley | Indiana | 18137 | 8280 | 138 |
2377431 | 2377431 | 2022-04-05 | Ripley | Missouri | 29181 | 2690 | 61 |
2373361 | 2373361 | 2022-04-04 | Ripley | Indiana | 18137 | 8280 | 138 |
2374178 | 2374178 | 2022-04-04 | Ripley | Missouri | 29181 | 2690 | 61 |
2370108 | 2370108 | 2022-04-03 | Ripley | Indiana | 18137 | 8279 | 138 |
2370926 | 2370926 | 2022-04-03 | Ripley | Missouri | 29181 | 2690 | 61 |
2366855 | 2366855 | 2022-04-02 | Ripley | Indiana | 18137 | 8279 | 138 |
2367673 | 2367673 | 2022-04-02 | Ripley | Missouri | 29181 | 2690 | 61 |
2363602 | 2363602 | 2022-04-01 | Ripley | Indiana | 18137 | 8279 | 138 |
2364420 | 2364420 | 2022-04-01 | Ripley | Missouri | 29181 | 2690 | 61 |
2360348 | 2360348 | 2022-03-31 | Ripley | Indiana | 18137 | 8278 | 138 |
2361166 | 2361166 | 2022-03-31 | Ripley | Missouri | 29181 | 2690 | 61 |
2357094 | 2357094 | 2022-03-30 | Ripley | Indiana | 18137 | 8278 | 138 |
2357912 | 2357912 | 2022-03-30 | Ripley | Missouri | 29181 | 2690 | 61 |
2353841 | 2353841 | 2022-03-29 | Ripley | Indiana | 18137 | 8283 | 138 |
2354659 | 2354659 | 2022-03-29 | Ripley | Missouri | 29181 | 2689 | 61 |
2350589 | 2350589 | 2022-03-28 | Ripley | Indiana | 18137 | 8283 | 138 |
2351406 | 2351406 | 2022-03-28 | Ripley | Missouri | 29181 | 2689 | 61 |
2347336 | 2347336 | 2022-03-27 | Ripley | Indiana | 18137 | 8281 | 138 |
2348154 | 2348154 | 2022-03-27 | Ripley | Missouri | 29181 | 2684 | 61 |
2344083 | 2344083 | 2022-03-26 | Ripley | Indiana | 18137 | 8281 | 138 |
2344901 | 2344901 | 2022-03-26 | Ripley | Missouri | 29181 | 2684 | 61 |
2340830 | 2340830 | 2022-03-25 | Ripley | Indiana | 18137 | 8281 | 138 |
2341648 | 2341648 | 2022-03-25 | Ripley | Missouri | 29181 | 2684 | 61 |
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);