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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
275394 | 275394 | 2020-06-26 | Elk | Kansas | 20049 | 1 | 0 |
278542 | 278542 | 2020-06-27 | Elk | Kansas | 20049 | 1 | 0 |
281690 | 281690 | 2020-06-28 | Elk | Kansas | 20049 | 1 | 0 |
284835 | 284835 | 2020-06-29 | Elk | Kansas | 20049 | 1 | 0 |
287984 | 287984 | 2020-06-30 | Elk | Kansas | 20049 | 1 | 0 |
291134 | 291134 | 2020-07-01 | Elk | Kansas | 20049 | 1 | 0 |
294288 | 294288 | 2020-07-02 | Elk | Kansas | 20049 | 1 | 0 |
297446 | 297446 | 2020-07-03 | Elk | Kansas | 20049 | 1 | 0 |
300608 | 300608 | 2020-07-04 | Elk | Kansas | 20049 | 1 | 0 |
303772 | 303772 | 2020-07-05 | Elk | Kansas | 20049 | 1 | 0 |
306937 | 306937 | 2020-07-06 | Elk | Kansas | 20049 | 1 | 0 |
310105 | 310105 | 2020-07-07 | Elk | Kansas | 20049 | 1 | 0 |
313275 | 313275 | 2020-07-08 | Elk | Kansas | 20049 | 1 | 0 |
316449 | 316449 | 2020-07-09 | Elk | Kansas | 20049 | 1 | 0 |
319622 | 319622 | 2020-07-10 | Elk | Kansas | 20049 | 1 | 0 |
322801 | 322801 | 2020-07-11 | Elk | Kansas | 20049 | 1 | 0 |
325983 | 325983 | 2020-07-12 | Elk | Kansas | 20049 | 1 | 0 |
329169 | 329169 | 2020-07-13 | Elk | Kansas | 20049 | 1 | 0 |
332356 | 332356 | 2020-07-14 | Elk | Kansas | 20049 | 1 | 0 |
335549 | 335549 | 2020-07-15 | Elk | Kansas | 20049 | 1 | 0 |
338745 | 338745 | 2020-07-16 | Elk | Kansas | 20049 | 1 | 0 |
341941 | 341941 | 2020-07-17 | Elk | Kansas | 20049 | 1 | 0 |
345141 | 345141 | 2020-07-18 | Elk | Kansas | 20049 | 1 | 0 |
348342 | 348342 | 2020-07-19 | Elk | Kansas | 20049 | 1 | 0 |
351542 | 351542 | 2020-07-20 | Elk | Kansas | 20049 | 1 | 0 |
354744 | 354744 | 2020-07-21 | Elk | Kansas | 20049 | 1 | 0 |
357946 | 357946 | 2020-07-22 | Elk | Kansas | 20049 | 1 | 0 |
361151 | 361151 | 2020-07-23 | Elk | Kansas | 20049 | 1 | 0 |
364358 | 364358 | 2020-07-24 | Elk | Kansas | 20049 | 1 | 0 |
367565 | 367565 | 2020-07-25 | Elk | Kansas | 20049 | 1 | 0 |
370775 | 370775 | 2020-07-26 | Elk | Kansas | 20049 | 1 | 0 |
373987 | 373987 | 2020-07-27 | Elk | Kansas | 20049 | 1 | 0 |
377202 | 377202 | 2020-07-28 | Elk | Kansas | 20049 | 1 | 0 |
380419 | 380419 | 2020-07-29 | Elk | Kansas | 20049 | 1 | 0 |
383636 | 383636 | 2020-07-30 | Elk | Kansas | 20049 | 1 | 0 |
386854 | 386854 | 2020-07-31 | Elk | Kansas | 20049 | 1 | 0 |
390071 | 390071 | 2020-08-01 | Elk | Kansas | 20049 | 1 | 0 |
393288 | 393288 | 2020-08-02 | Elk | Kansas | 20049 | 1 | 0 |
396504 | 396504 | 2020-08-03 | Elk | Kansas | 20049 | 1 | 0 |
399719 | 399719 | 2020-08-04 | Elk | Kansas | 20049 | 1 | 0 |
402936 | 402936 | 2020-08-05 | Elk | Kansas | 20049 | 1 | 0 |
406154 | 406154 | 2020-08-06 | Elk | Kansas | 20049 | 1 | 0 |
409373 | 409373 | 2020-08-07 | Elk | Kansas | 20049 | 1 | 0 |
412593 | 412593 | 2020-08-08 | Elk | Kansas | 20049 | 1 | 0 |
415813 | 415813 | 2020-08-09 | Elk | Kansas | 20049 | 1 | 0 |
419034 | 419034 | 2020-08-10 | Elk | Kansas | 20049 | 1 | 0 |
422257 | 422257 | 2020-08-11 | Elk | Kansas | 20049 | 1 | 0 |
425478 | 425478 | 2020-08-12 | Elk | Kansas | 20049 | 1 | 0 |
428702 | 428702 | 2020-08-13 | Elk | Kansas | 20049 | 1 | 0 |
431930 | 431930 | 2020-08-14 | Elk | Kansas | 20049 | 1 | 0 |
435155 | 435155 | 2020-08-15 | Elk | Kansas | 20049 | 1 | 0 |
438380 | 438380 | 2020-08-16 | Elk | Kansas | 20049 | 1 | 0 |
441607 | 441607 | 2020-08-17 | Elk | Kansas | 20049 | 1 | 0 |
444833 | 444833 | 2020-08-18 | Elk | Kansas | 20049 | 1 | 0 |
448060 | 448060 | 2020-08-19 | Elk | Kansas | 20049 | 1 | 0 |
451288 | 451288 | 2020-08-20 | Elk | Kansas | 20049 | 1 | 0 |
454516 | 454516 | 2020-08-21 | Elk | Kansas | 20049 | 1 | 0 |
457744 | 457744 | 2020-08-22 | Elk | Kansas | 20049 | 1 | 0 |
460971 | 460971 | 2020-08-23 | Elk | Kansas | 20049 | 1 | 0 |
464200 | 464200 | 2020-08-24 | Elk | Kansas | 20049 | 1 | 0 |
467429 | 467429 | 2020-08-25 | Elk | Kansas | 20049 | 1 | 0 |
470658 | 470658 | 2020-08-26 | Elk | Kansas | 20049 | 1 | 0 |
473890 | 473890 | 2020-08-27 | Elk | Kansas | 20049 | 1 | 0 |
477123 | 477123 | 2020-08-28 | Elk | Kansas | 20049 | 1 | 0 |
480356 | 480356 | 2020-08-29 | Elk | Kansas | 20049 | 1 | 0 |
483590 | 483590 | 2020-08-30 | Elk | Kansas | 20049 | 1 | 0 |
486825 | 486825 | 2020-08-31 | Elk | Kansas | 20049 | 1 | 0 |
490058 | 490058 | 2020-09-01 | Elk | Kansas | 20049 | 1 | 0 |
493291 | 493291 | 2020-09-02 | Elk | Kansas | 20049 | 1 | 0 |
496525 | 496525 | 2020-09-03 | Elk | Kansas | 20049 | 1 | 0 |
499758 | 499758 | 2020-09-04 | Elk | Kansas | 20049 | 1 | 0 |
502992 | 502992 | 2020-09-05 | Elk | Kansas | 20049 | 1 | 0 |
506226 | 506226 | 2020-09-06 | Elk | Kansas | 20049 | 1 | 0 |
509458 | 509458 | 2020-09-07 | Elk | Kansas | 20049 | 1 | 0 |
512691 | 512691 | 2020-09-08 | Elk | Kansas | 20049 | 1 | 0 |
515924 | 515924 | 2020-09-09 | Elk | Kansas | 20049 | 1 | 0 |
519159 | 519159 | 2020-09-10 | Elk | Kansas | 20049 | 1 | 0 |
522396 | 522396 | 2020-09-11 | Elk | Kansas | 20049 | 1 | 0 |
525632 | 525632 | 2020-09-12 | Elk | Kansas | 20049 | 1 | 0 |
528868 | 528868 | 2020-09-13 | Elk | Kansas | 20049 | 1 | 0 |
532105 | 532105 | 2020-09-14 | Elk | Kansas | 20049 | 1 | 0 |
535340 | 535340 | 2020-09-15 | Elk | Kansas | 20049 | 1 | 0 |
538576 | 538576 | 2020-09-16 | Elk | Kansas | 20049 | 2 | 0 |
541813 | 541813 | 2020-09-17 | Elk | Kansas | 20049 | 2 | 0 |
545049 | 545049 | 2020-09-18 | Elk | Kansas | 20049 | 4 | 0 |
548287 | 548287 | 2020-09-19 | Elk | Kansas | 20049 | 4 | 0 |
551526 | 551526 | 2020-09-20 | Elk | Kansas | 20049 | 4 | 0 |
554765 | 554765 | 2020-09-21 | Elk | Kansas | 20049 | 4 | 0 |
558002 | 558002 | 2020-09-22 | Elk | Kansas | 20049 | 4 | 0 |
561238 | 561238 | 2020-09-23 | Elk | Kansas | 20049 | 4 | 0 |
564478 | 564478 | 2020-09-24 | Elk | Kansas | 20049 | 4 | 0 |
567718 | 567718 | 2020-09-25 | Elk | Kansas | 20049 | 4 | 0 |
570960 | 570960 | 2020-09-26 | Elk | Kansas | 20049 | 4 | 0 |
574203 | 574203 | 2020-09-27 | Elk | Kansas | 20049 | 4 | 0 |
577445 | 577445 | 2020-09-28 | Elk | Kansas | 20049 | 6 | 0 |
580686 | 580686 | 2020-09-29 | Elk | Kansas | 20049 | 6 | 0 |
583925 | 583925 | 2020-09-30 | Elk | Kansas | 20049 | 6 | 0 |
587165 | 587165 | 2020-10-01 | Elk | Kansas | 20049 | 6 | 0 |
590406 | 590406 | 2020-10-02 | Elk | Kansas | 20049 | 7 | 0 |
593647 | 593647 | 2020-10-03 | Elk | Kansas | 20049 | 7 | 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);