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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337725 | 2337725 | 2022-03-24 | Elk | Kansas | 20049 | 570 | 9 |
2339096 | 2339096 | 2022-03-24 | Elk | Pennsylvania | 42047 | 7118 | 97 |
2334471 | 2334471 | 2022-03-23 | Elk | Kansas | 20049 | 570 | 9 |
2335842 | 2335842 | 2022-03-23 | Elk | Pennsylvania | 42047 | 7115 | 97 |
2331217 | 2331217 | 2022-03-22 | Elk | Kansas | 20049 | 570 | 8 |
2332588 | 2332588 | 2022-03-22 | Elk | Pennsylvania | 42047 | 7114 | 97 |
2327965 | 2327965 | 2022-03-21 | Elk | Kansas | 20049 | 570 | 8 |
2329335 | 2329335 | 2022-03-21 | Elk | Pennsylvania | 42047 | 7113 | 97 |
2324712 | 2324712 | 2022-03-20 | Elk | Kansas | 20049 | 570 | 8 |
2326083 | 2326083 | 2022-03-20 | Elk | Pennsylvania | 42047 | 7113 | 97 |
2321458 | 2321458 | 2022-03-19 | Elk | Kansas | 20049 | 570 | 8 |
2322830 | 2322830 | 2022-03-19 | Elk | Pennsylvania | 42047 | 7112 | 97 |
2318204 | 2318204 | 2022-03-18 | Elk | Kansas | 20049 | 570 | 8 |
2319576 | 2319576 | 2022-03-18 | Elk | Pennsylvania | 42047 | 7110 | 97 |
2314951 | 2314951 | 2022-03-17 | Elk | Kansas | 20049 | 569 | 8 |
2316322 | 2316322 | 2022-03-17 | Elk | Pennsylvania | 42047 | 7108 | 97 |
2311698 | 2311698 | 2022-03-16 | Elk | Kansas | 20049 | 569 | 8 |
2313069 | 2313069 | 2022-03-16 | Elk | Pennsylvania | 42047 | 7101 | 97 |
2308445 | 2308445 | 2022-03-15 | Elk | Kansas | 20049 | 569 | 8 |
2309816 | 2309816 | 2022-03-15 | Elk | Pennsylvania | 42047 | 7102 | 97 |
2305194 | 2305194 | 2022-03-14 | Elk | Kansas | 20049 | 569 | 8 |
2306563 | 2306563 | 2022-03-14 | Elk | Pennsylvania | 42047 | 7098 | 97 |
2301942 | 2301942 | 2022-03-13 | Elk | Kansas | 20049 | 569 | 8 |
2303312 | 2303312 | 2022-03-13 | Elk | Pennsylvania | 42047 | 7097 | 97 |
2298690 | 2298690 | 2022-03-12 | Elk | Kansas | 20049 | 569 | 8 |
2300060 | 2300060 | 2022-03-12 | Elk | Pennsylvania | 42047 | 7095 | 97 |
2295438 | 2295438 | 2022-03-11 | Elk | Kansas | 20049 | 569 | 8 |
2296808 | 2296808 | 2022-03-11 | Elk | Pennsylvania | 42047 | 7094 | 97 |
2292186 | 2292186 | 2022-03-10 | Elk | Kansas | 20049 | 569 | 8 |
2293556 | 2293556 | 2022-03-10 | Elk | Pennsylvania | 42047 | 7091 | 97 |
2288934 | 2288934 | 2022-03-09 | Elk | Kansas | 20049 | 569 | 8 |
2290304 | 2290304 | 2022-03-09 | Elk | Pennsylvania | 42047 | 7088 | 97 |
2285683 | 2285683 | 2022-03-08 | Elk | Kansas | 20049 | 569 | 8 |
2287052 | 2287052 | 2022-03-08 | Elk | Pennsylvania | 42047 | 7086 | 97 |
2282431 | 2282431 | 2022-03-07 | Elk | Kansas | 20049 | 569 | 8 |
2283800 | 2283800 | 2022-03-07 | Elk | Pennsylvania | 42047 | 7084 | 96 |
2279178 | 2279178 | 2022-03-06 | Elk | Kansas | 20049 | 569 | 8 |
2280548 | 2280548 | 2022-03-06 | Elk | Pennsylvania | 42047 | 7084 | 96 |
2275925 | 2275925 | 2022-03-05 | Elk | Kansas | 20049 | 569 | 8 |
2277295 | 2277295 | 2022-03-05 | Elk | Pennsylvania | 42047 | 7082 | 96 |
2272672 | 2272672 | 2022-03-04 | Elk | Kansas | 20049 | 569 | 8 |
2274042 | 2274042 | 2022-03-04 | Elk | Pennsylvania | 42047 | 7078 | 96 |
2269420 | 2269420 | 2022-03-03 | Elk | Kansas | 20049 | 570 | 8 |
2270789 | 2270789 | 2022-03-03 | Elk | Pennsylvania | 42047 | 7076 | 96 |
2266167 | 2266167 | 2022-03-02 | Elk | Kansas | 20049 | 570 | 8 |
2267537 | 2267537 | 2022-03-02 | Elk | Pennsylvania | 42047 | 7070 | 96 |
2262916 | 2262916 | 2022-03-01 | Elk | Kansas | 20049 | 568 | 8 |
2264284 | 2264284 | 2022-03-01 | Elk | Pennsylvania | 42047 | 7067 | 95 |
2259665 | 2259665 | 2022-02-28 | Elk | Kansas | 20049 | 568 | 8 |
2261034 | 2261034 | 2022-02-28 | Elk | Pennsylvania | 42047 | 7064 | 95 |
2256414 | 2256414 | 2022-02-27 | Elk | Kansas | 20049 | 569 | 8 |
2257783 | 2257783 | 2022-02-27 | Elk | Pennsylvania | 42047 | 7062 | 95 |
2253163 | 2253163 | 2022-02-26 | Elk | Kansas | 20049 | 569 | 8 |
2254532 | 2254532 | 2022-02-26 | Elk | Pennsylvania | 42047 | 7061 | 95 |
2249912 | 2249912 | 2022-02-25 | Elk | Kansas | 20049 | 569 | 8 |
2251281 | 2251281 | 2022-02-25 | Elk | Pennsylvania | 42047 | 7054 | 95 |
2246661 | 2246661 | 2022-02-24 | Elk | Kansas | 20049 | 566 | 8 |
2248030 | 2248030 | 2022-02-24 | Elk | Pennsylvania | 42047 | 7049 | 95 |
2243410 | 2243410 | 2022-02-23 | Elk | Kansas | 20049 | 566 | 8 |
2244779 | 2244779 | 2022-02-23 | Elk | Pennsylvania | 42047 | 7038 | 95 |
2240159 | 2240159 | 2022-02-22 | Elk | Kansas | 20049 | 565 | 8 |
2241528 | 2241528 | 2022-02-22 | Elk | Pennsylvania | 42047 | 7036 | 95 |
2236908 | 2236908 | 2022-02-21 | Elk | Kansas | 20049 | 565 | 8 |
2238277 | 2238277 | 2022-02-21 | Elk | Pennsylvania | 42047 | 7022 | 95 |
2233657 | 2233657 | 2022-02-20 | Elk | Kansas | 20049 | 563 | 8 |
2235026 | 2235026 | 2022-02-20 | Elk | Pennsylvania | 42047 | 7022 | 95 |
2230406 | 2230406 | 2022-02-19 | Elk | Kansas | 20049 | 563 | 8 |
2231775 | 2231775 | 2022-02-19 | Elk | Pennsylvania | 42047 | 7019 | 95 |
2227155 | 2227155 | 2022-02-18 | Elk | Kansas | 20049 | 563 | 8 |
2228524 | 2228524 | 2022-02-18 | Elk | Pennsylvania | 42047 | 7012 | 95 |
2223904 | 2223904 | 2022-02-17 | Elk | Kansas | 20049 | 563 | 8 |
2225273 | 2225273 | 2022-02-17 | Elk | Pennsylvania | 42047 | 7001 | 95 |
2220653 | 2220653 | 2022-02-16 | Elk | Kansas | 20049 | 563 | 8 |
2222022 | 2222022 | 2022-02-16 | Elk | Pennsylvania | 42047 | 6990 | 94 |
2217402 | 2217402 | 2022-02-15 | Elk | Kansas | 20049 | 560 | 8 |
2218771 | 2218771 | 2022-02-15 | Elk | Pennsylvania | 42047 | 6979 | 94 |
2214151 | 2214151 | 2022-02-14 | Elk | Kansas | 20049 | 560 | 8 |
2215520 | 2215520 | 2022-02-14 | Elk | Pennsylvania | 42047 | 6971 | 93 |
2210899 | 2210899 | 2022-02-13 | Elk | Kansas | 20049 | 558 | 8 |
2212269 | 2212269 | 2022-02-13 | Elk | Pennsylvania | 42047 | 6964 | 93 |
2207646 | 2207646 | 2022-02-12 | Elk | Kansas | 20049 | 558 | 8 |
2209016 | 2209016 | 2022-02-12 | Elk | Pennsylvania | 42047 | 6957 | 93 |
2204393 | 2204393 | 2022-02-11 | Elk | Kansas | 20049 | 558 | 8 |
2205763 | 2205763 | 2022-02-11 | Elk | Pennsylvania | 42047 | 6939 | 93 |
2201140 | 2201140 | 2022-02-10 | Elk | Kansas | 20049 | 558 | 8 |
2202510 | 2202510 | 2022-02-10 | Elk | Pennsylvania | 42047 | 6924 | 93 |
2197886 | 2197886 | 2022-02-09 | Elk | Kansas | 20049 | 558 | 8 |
2199256 | 2199256 | 2022-02-09 | Elk | Pennsylvania | 42047 | 6914 | 90 |
2194632 | 2194632 | 2022-02-08 | Elk | Kansas | 20049 | 556 | 8 |
2196002 | 2196002 | 2022-02-08 | Elk | Pennsylvania | 42047 | 6896 | 90 |
2191378 | 2191378 | 2022-02-07 | Elk | Kansas | 20049 | 556 | 8 |
2192748 | 2192748 | 2022-02-07 | Elk | Pennsylvania | 42047 | 6915 | 86 |
2188125 | 2188125 | 2022-02-06 | Elk | Kansas | 20049 | 553 | 8 |
2189494 | 2189494 | 2022-02-06 | Elk | Pennsylvania | 42047 | 6873 | 86 |
2184872 | 2184872 | 2022-02-05 | Elk | Kansas | 20049 | 553 | 8 |
2186241 | 2186241 | 2022-02-05 | Elk | Pennsylvania | 42047 | 6867 | 86 |
2181620 | 2181620 | 2022-02-04 | Elk | Kansas | 20049 | 553 | 8 |
2182989 | 2182989 | 2022-02-04 | Elk | Pennsylvania | 42047 | 6832 | 86 |
2178369 | 2178369 | 2022-02-03 | Elk | Kansas | 20049 | 550 | 8 |
2179737 | 2179737 | 2022-02-03 | Elk | Pennsylvania | 42047 | 6804 | 86 |
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);