ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,454 rows where county = "Elk" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500497 | 2500497 | 2022-05-13 | Elk | Kansas | 20049 | 571 | 10 |
2501870 | 2501870 | 2022-05-13 | Elk | Pennsylvania | 42047 | 7193 | 101 |
2497239 | 2497239 | 2022-05-12 | Elk | Kansas | 20049 | 571 | 10 |
2498612 | 2498612 | 2022-05-12 | Elk | Pennsylvania | 42047 | 7193 | 101 |
2493981 | 2493981 | 2022-05-11 | Elk | Kansas | 20049 | 571 | 10 |
2495354 | 2495354 | 2022-05-11 | Elk | Pennsylvania | 42047 | 7193 | 101 |
2490723 | 2490723 | 2022-05-10 | Elk | Kansas | 20049 | 571 | 10 |
2492096 | 2492096 | 2022-05-10 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2487466 | 2487466 | 2022-05-09 | Elk | Kansas | 20049 | 571 | 10 |
2488838 | 2488838 | 2022-05-09 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2484208 | 2484208 | 2022-05-08 | Elk | Kansas | 20049 | 571 | 10 |
2485581 | 2485581 | 2022-05-08 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2480950 | 2480950 | 2022-05-07 | Elk | Kansas | 20049 | 571 | 10 |
2482323 | 2482323 | 2022-05-07 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2477692 | 2477692 | 2022-05-06 | Elk | Kansas | 20049 | 571 | 10 |
2479065 | 2479065 | 2022-05-06 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2474434 | 2474434 | 2022-05-05 | Elk | Kansas | 20049 | 570 | 10 |
2475807 | 2475807 | 2022-05-05 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2471177 | 2471177 | 2022-05-04 | Elk | Kansas | 20049 | 570 | 10 |
2472550 | 2472550 | 2022-05-04 | Elk | Pennsylvania | 42047 | 7156 | 101 |
2467921 | 2467921 | 2022-05-03 | Elk | Kansas | 20049 | 570 | 10 |
2469294 | 2469294 | 2022-05-03 | Elk | Pennsylvania | 42047 | 7153 | 101 |
2464666 | 2464666 | 2022-05-02 | Elk | Kansas | 20049 | 570 | 10 |
2466038 | 2466038 | 2022-05-02 | Elk | Pennsylvania | 42047 | 7150 | 101 |
2461410 | 2461410 | 2022-05-01 | Elk | Kansas | 20049 | 570 | 10 |
2462783 | 2462783 | 2022-05-01 | Elk | Pennsylvania | 42047 | 7150 | 101 |
2458154 | 2458154 | 2022-04-30 | Elk | Kansas | 20049 | 570 | 10 |
2459527 | 2459527 | 2022-04-30 | Elk | Pennsylvania | 42047 | 7148 | 101 |
2454898 | 2454898 | 2022-04-29 | Elk | Kansas | 20049 | 570 | 10 |
2456271 | 2456271 | 2022-04-29 | Elk | Pennsylvania | 42047 | 7148 | 101 |
2451642 | 2451642 | 2022-04-28 | Elk | Kansas | 20049 | 569 | 10 |
2453015 | 2453015 | 2022-04-28 | Elk | Pennsylvania | 42047 | 7144 | 101 |
2448386 | 2448386 | 2022-04-27 | Elk | Kansas | 20049 | 569 | 10 |
2449759 | 2449759 | 2022-04-27 | Elk | Pennsylvania | 42047 | 7141 | 101 |
2445130 | 2445130 | 2022-04-26 | Elk | Kansas | 20049 | 569 | 10 |
2446502 | 2446502 | 2022-04-26 | Elk | Pennsylvania | 42047 | 7140 | 101 |
2441874 | 2441874 | 2022-04-25 | Elk | Kansas | 20049 | 569 | 10 |
2443247 | 2443247 | 2022-04-25 | Elk | Pennsylvania | 42047 | 7139 | 101 |
2438618 | 2438618 | 2022-04-24 | Elk | Kansas | 20049 | 569 | 10 |
2439991 | 2439991 | 2022-04-24 | Elk | Pennsylvania | 42047 | 7139 | 101 |
2435362 | 2435362 | 2022-04-23 | Elk | Kansas | 20049 | 569 | 10 |
2436735 | 2436735 | 2022-04-23 | Elk | Pennsylvania | 42047 | 7138 | 101 |
2432106 | 2432106 | 2022-04-22 | Elk | Kansas | 20049 | 569 | 10 |
2433479 | 2433479 | 2022-04-22 | Elk | Pennsylvania | 42047 | 7136 | 101 |
2428850 | 2428850 | 2022-04-21 | Elk | Kansas | 20049 | 568 | 10 |
2430223 | 2430223 | 2022-04-21 | Elk | Pennsylvania | 42047 | 7135 | 101 |
2425594 | 2425594 | 2022-04-20 | Elk | Kansas | 20049 | 568 | 10 |
2426967 | 2426967 | 2022-04-20 | Elk | Pennsylvania | 42047 | 7135 | 101 |
2422338 | 2422338 | 2022-04-19 | Elk | Kansas | 20049 | 568 | 10 |
2423711 | 2423711 | 2022-04-19 | Elk | Pennsylvania | 42047 | 7135 | 101 |
2419082 | 2419082 | 2022-04-18 | Elk | Kansas | 20049 | 568 | 10 |
2420455 | 2420455 | 2022-04-18 | Elk | Pennsylvania | 42047 | 7132 | 101 |
2415826 | 2415826 | 2022-04-17 | Elk | Kansas | 20049 | 568 | 10 |
2417199 | 2417199 | 2022-04-17 | Elk | Pennsylvania | 42047 | 7131 | 101 |
2412570 | 2412570 | 2022-04-16 | Elk | Kansas | 20049 | 568 | 10 |
2413943 | 2413943 | 2022-04-16 | Elk | Pennsylvania | 42047 | 7131 | 101 |
2409314 | 2409314 | 2022-04-15 | Elk | Kansas | 20049 | 568 | 10 |
2410687 | 2410687 | 2022-04-15 | Elk | Pennsylvania | 42047 | 7131 | 101 |
2406058 | 2406058 | 2022-04-14 | Elk | Kansas | 20049 | 570 | 10 |
2407431 | 2407431 | 2022-04-14 | Elk | Pennsylvania | 42047 | 7131 | 101 |
2402802 | 2402802 | 2022-04-13 | Elk | Kansas | 20049 | 570 | 10 |
2404175 | 2404175 | 2022-04-13 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2399548 | 2399548 | 2022-04-12 | Elk | Kansas | 20049 | 570 | 10 |
2400920 | 2400920 | 2022-04-12 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2396292 | 2396292 | 2022-04-11 | Elk | Kansas | 20049 | 570 | 10 |
2397665 | 2397665 | 2022-04-11 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2393037 | 2393037 | 2022-04-10 | Elk | Kansas | 20049 | 570 | 10 |
2394410 | 2394410 | 2022-04-10 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2389781 | 2389781 | 2022-04-09 | Elk | Kansas | 20049 | 570 | 10 |
2391154 | 2391154 | 2022-04-09 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2386525 | 2386525 | 2022-04-08 | Elk | Kansas | 20049 | 570 | 10 |
2387898 | 2387898 | 2022-04-08 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2383271 | 2383271 | 2022-04-07 | Elk | Kansas | 20049 | 570 | 10 |
2384643 | 2384643 | 2022-04-07 | Elk | Pennsylvania | 42047 | 7131 | 100 |
2380016 | 2380016 | 2022-04-06 | Elk | Kansas | 20049 | 570 | 10 |
2381388 | 2381388 | 2022-04-06 | Elk | Pennsylvania | 42047 | 7130 | 100 |
2376761 | 2376761 | 2022-04-05 | Elk | Kansas | 20049 | 570 | 10 |
2378133 | 2378133 | 2022-04-05 | Elk | Pennsylvania | 42047 | 7130 | 100 |
2373509 | 2373509 | 2022-04-04 | Elk | Kansas | 20049 | 570 | 10 |
2374879 | 2374879 | 2022-04-04 | Elk | Pennsylvania | 42047 | 7129 | 100 |
2370256 | 2370256 | 2022-04-03 | Elk | Kansas | 20049 | 570 | 10 |
2371627 | 2371627 | 2022-04-03 | Elk | Pennsylvania | 42047 | 7128 | 100 |
2367003 | 2367003 | 2022-04-02 | Elk | Kansas | 20049 | 570 | 10 |
2368374 | 2368374 | 2022-04-02 | Elk | Pennsylvania | 42047 | 7128 | 100 |
2363750 | 2363750 | 2022-04-01 | Elk | Kansas | 20049 | 570 | 10 |
2365121 | 2365121 | 2022-04-01 | Elk | Pennsylvania | 42047 | 7127 | 100 |
2360496 | 2360496 | 2022-03-31 | Elk | Kansas | 20049 | 570 | 9 |
2361868 | 2361868 | 2022-03-31 | Elk | Pennsylvania | 42047 | 7125 | 99 |
2357242 | 2357242 | 2022-03-30 | Elk | Kansas | 20049 | 570 | 9 |
2358614 | 2358614 | 2022-03-30 | Elk | Pennsylvania | 42047 | 7125 | 99 |
2353989 | 2353989 | 2022-03-29 | Elk | Kansas | 20049 | 570 | 9 |
2355360 | 2355360 | 2022-03-29 | Elk | Pennsylvania | 42047 | 7125 | 98 |
2350737 | 2350737 | 2022-03-28 | Elk | Kansas | 20049 | 570 | 9 |
2352107 | 2352107 | 2022-03-28 | Elk | Pennsylvania | 42047 | 7122 | 98 |
2347484 | 2347484 | 2022-03-27 | Elk | Kansas | 20049 | 570 | 9 |
2348855 | 2348855 | 2022-03-27 | Elk | Pennsylvania | 42047 | 7122 | 98 |
2344231 | 2344231 | 2022-03-26 | Elk | Kansas | 20049 | 570 | 9 |
2345602 | 2345602 | 2022-03-26 | Elk | Pennsylvania | 42047 | 7122 | 98 |
2340978 | 2340978 | 2022-03-25 | Elk | Kansas | 20049 | 570 | 9 |
2342349 | 2342349 | 2022-03-25 | Elk | Pennsylvania | 42047 | 7118 | 97 |
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);