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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
39935 | 39935 | 2020-04-07 | Elk | Pennsylvania | 42047 | 2 | 0 |
42495 | 42495 | 2020-04-08 | Elk | Pennsylvania | 42047 | 2 | 0 |
45081 | 45081 | 2020-04-09 | Elk | Pennsylvania | 42047 | 2 | 0 |
47698 | 47698 | 2020-04-10 | Elk | Pennsylvania | 42047 | 2 | 0 |
50355 | 50355 | 2020-04-11 | Elk | Pennsylvania | 42047 | 2 | 0 |
53028 | 53028 | 2020-04-12 | Elk | Pennsylvania | 42047 | 2 | 0 |
55713 | 55713 | 2020-04-13 | Elk | Pennsylvania | 42047 | 2 | 0 |
58416 | 58416 | 2020-04-14 | Elk | Pennsylvania | 42047 | 2 | 0 |
61131 | 61131 | 2020-04-15 | Elk | Pennsylvania | 42047 | 2 | 0 |
63857 | 63857 | 2020-04-16 | Elk | Pennsylvania | 42047 | 2 | 0 |
66603 | 66603 | 2020-04-17 | Elk | Pennsylvania | 42047 | 2 | 0 |
69361 | 69361 | 2020-04-18 | Elk | Pennsylvania | 42047 | 2 | 0 |
72128 | 72128 | 2020-04-19 | Elk | Pennsylvania | 42047 | 2 | 0 |
74903 | 74903 | 2020-04-20 | Elk | Pennsylvania | 42047 | 2 | 0 |
77685 | 77685 | 2020-04-21 | Elk | Pennsylvania | 42047 | 2 | 0 |
80475 | 80475 | 2020-04-22 | Elk | Pennsylvania | 42047 | 2 | 0 |
83274 | 83274 | 2020-04-23 | Elk | Pennsylvania | 42047 | 2 | 0 |
86078 | 86078 | 2020-04-24 | Elk | Pennsylvania | 42047 | 2 | 0 |
88892 | 88892 | 2020-04-25 | Elk | Pennsylvania | 42047 | 2 | 0 |
91708 | 91708 | 2020-04-26 | Elk | Pennsylvania | 42047 | 3 | 0 |
94535 | 94535 | 2020-04-27 | Elk | Pennsylvania | 42047 | 3 | 0 |
97374 | 97374 | 2020-04-28 | Elk | Pennsylvania | 42047 | 3 | 0 |
100223 | 100223 | 2020-04-29 | Elk | Pennsylvania | 42047 | 3 | 0 |
103076 | 103076 | 2020-04-30 | Elk | Pennsylvania | 42047 | 3 | 0 |
105939 | 105939 | 2020-05-01 | Elk | Pennsylvania | 42047 | 3 | 0 |
108806 | 108806 | 2020-05-02 | Elk | Pennsylvania | 42047 | 4 | 0 |
111680 | 111680 | 2020-05-03 | Elk | Pennsylvania | 42047 | 4 | 0 |
114562 | 114562 | 2020-05-04 | Elk | Pennsylvania | 42047 | 4 | 0 |
117443 | 117443 | 2020-05-05 | Elk | Pennsylvania | 42047 | 4 | 0 |
120405 | 120405 | 2020-05-06 | Elk | Pennsylvania | 42047 | 4 | 0 |
123382 | 123382 | 2020-05-07 | Elk | Pennsylvania | 42047 | 5 | 1 |
126365 | 126365 | 2020-05-08 | Elk | Pennsylvania | 42047 | 5 | 1 |
129354 | 129354 | 2020-05-09 | Elk | Pennsylvania | 42047 | 5 | 1 |
132343 | 132343 | 2020-05-10 | Elk | Pennsylvania | 42047 | 5 | 1 |
135334 | 135334 | 2020-05-11 | Elk | Pennsylvania | 42047 | 5 | 1 |
138324 | 138324 | 2020-05-12 | Elk | Pennsylvania | 42047 | 5 | 1 |
141320 | 141320 | 2020-05-13 | Elk | Pennsylvania | 42047 | 6 | 1 |
144316 | 144316 | 2020-05-14 | Elk | Pennsylvania | 42047 | 6 | 1 |
147317 | 147317 | 2020-05-15 | Elk | Pennsylvania | 42047 | 6 | 1 |
150324 | 150324 | 2020-05-16 | Elk | Pennsylvania | 42047 | 6 | 1 |
153335 | 153335 | 2020-05-17 | Elk | Pennsylvania | 42047 | 6 | 1 |
156352 | 156352 | 2020-05-18 | Elk | Pennsylvania | 42047 | 6 | 0 |
159373 | 159373 | 2020-05-19 | Elk | Pennsylvania | 42047 | 6 | 0 |
162400 | 162400 | 2020-05-20 | Elk | Pennsylvania | 42047 | 6 | 0 |
165429 | 165429 | 2020-05-21 | Elk | Pennsylvania | 42047 | 6 | 0 |
168465 | 168465 | 2020-05-22 | Elk | Pennsylvania | 42047 | 6 | 0 |
171504 | 171504 | 2020-05-23 | Elk | Pennsylvania | 42047 | 6 | 0 |
174546 | 174546 | 2020-05-24 | Elk | Pennsylvania | 42047 | 6 | 0 |
177590 | 177590 | 2020-05-25 | Elk | Pennsylvania | 42047 | 6 | 0 |
180633 | 180633 | 2020-05-26 | Elk | Pennsylvania | 42047 | 6 | 0 |
183683 | 183683 | 2020-05-27 | Elk | Pennsylvania | 42047 | 6 | 0 |
186740 | 186740 | 2020-05-28 | Elk | Pennsylvania | 42047 | 6 | 0 |
189801 | 189801 | 2020-05-29 | Elk | Pennsylvania | 42047 | 6 | 0 |
192866 | 192866 | 2020-05-30 | Elk | Pennsylvania | 42047 | 6 | 0 |
195935 | 195935 | 2020-05-31 | Elk | Pennsylvania | 42047 | 6 | 0 |
199008 | 199008 | 2020-06-01 | Elk | Pennsylvania | 42047 | 6 | 0 |
202083 | 202083 | 2020-06-02 | Elk | Pennsylvania | 42047 | 6 | 0 |
205160 | 205160 | 2020-06-03 | Elk | Pennsylvania | 42047 | 6 | 0 |
208241 | 208241 | 2020-06-04 | Elk | Pennsylvania | 42047 | 6 | 0 |
211323 | 211323 | 2020-06-05 | Elk | Pennsylvania | 42047 | 6 | 0 |
214409 | 214409 | 2020-06-06 | Elk | Pennsylvania | 42047 | 6 | 0 |
217499 | 217499 | 2020-06-07 | Elk | Pennsylvania | 42047 | 6 | 0 |
220591 | 220591 | 2020-06-08 | Elk | Pennsylvania | 42047 | 6 | 0 |
223686 | 223686 | 2020-06-09 | Elk | Pennsylvania | 42047 | 6 | 0 |
226786 | 226786 | 2020-06-10 | Elk | Pennsylvania | 42047 | 6 | 0 |
229890 | 229890 | 2020-06-11 | Elk | Pennsylvania | 42047 | 6 | 0 |
232995 | 232995 | 2020-06-12 | Elk | Pennsylvania | 42047 | 6 | 0 |
236100 | 236100 | 2020-06-13 | Elk | Pennsylvania | 42047 | 6 | 0 |
239208 | 239208 | 2020-06-14 | Elk | Pennsylvania | 42047 | 6 | 0 |
242317 | 242317 | 2020-06-15 | Elk | Pennsylvania | 42047 | 6 | 0 |
245429 | 245429 | 2020-06-16 | Elk | Pennsylvania | 42047 | 6 | 0 |
248542 | 248542 | 2020-06-17 | Elk | Pennsylvania | 42047 | 6 | 0 |
251657 | 251657 | 2020-06-18 | Elk | Pennsylvania | 42047 | 6 | 0 |
254772 | 254772 | 2020-06-19 | Elk | Pennsylvania | 42047 | 8 | 0 |
257898 | 257898 | 2020-06-20 | Elk | Pennsylvania | 42047 | 8 | 0 |
261025 | 261025 | 2020-06-21 | Elk | Pennsylvania | 42047 | 8 | 0 |
264153 | 264153 | 2020-06-22 | Elk | Pennsylvania | 42047 | 9 | 0 |
267281 | 267281 | 2020-06-23 | Elk | Pennsylvania | 42047 | 9 | 0 |
270415 | 270415 | 2020-06-24 | Elk | Pennsylvania | 42047 | 10 | 0 |
273554 | 273554 | 2020-06-25 | Elk | Pennsylvania | 42047 | 10 | 0 |
275394 | 275394 | 2020-06-26 | Elk | Kansas | 20049 | 1 | 0 |
276701 | 276701 | 2020-06-26 | Elk | Pennsylvania | 42047 | 12 | 0 |
278542 | 278542 | 2020-06-27 | Elk | Kansas | 20049 | 1 | 0 |
279849 | 279849 | 2020-06-27 | Elk | Pennsylvania | 42047 | 12 | 0 |
281690 | 281690 | 2020-06-28 | Elk | Kansas | 20049 | 1 | 0 |
282995 | 282995 | 2020-06-28 | Elk | Pennsylvania | 42047 | 13 | 0 |
284835 | 284835 | 2020-06-29 | Elk | Kansas | 20049 | 1 | 0 |
286140 | 286140 | 2020-06-29 | Elk | Pennsylvania | 42047 | 13 | 0 |
287984 | 287984 | 2020-06-30 | Elk | Kansas | 20049 | 1 | 0 |
289291 | 289291 | 2020-06-30 | Elk | Pennsylvania | 42047 | 15 | 0 |
291134 | 291134 | 2020-07-01 | Elk | Kansas | 20049 | 1 | 0 |
292443 | 292443 | 2020-07-01 | Elk | Pennsylvania | 42047 | 15 | 0 |
294288 | 294288 | 2020-07-02 | Elk | Kansas | 20049 | 1 | 0 |
295599 | 295599 | 2020-07-02 | Elk | Pennsylvania | 42047 | 15 | 0 |
297446 | 297446 | 2020-07-03 | Elk | Kansas | 20049 | 1 | 0 |
298758 | 298758 | 2020-07-03 | Elk | Pennsylvania | 42047 | 16 | 0 |
300608 | 300608 | 2020-07-04 | Elk | Kansas | 20049 | 1 | 0 |
301922 | 301922 | 2020-07-04 | Elk | Pennsylvania | 42047 | 19 | 0 |
303772 | 303772 | 2020-07-05 | Elk | Kansas | 20049 | 1 | 0 |
305085 | 305085 | 2020-07-05 | Elk | Pennsylvania | 42047 | 20 | 0 |
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);