ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Elko" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
279343 | 279343 | 2020-06-27 | Elko | Nevada | 32007 | 105 | 1 |
282490 | 282490 | 2020-06-28 | Elko | Nevada | 32007 | 115 | 1 |
285635 | 285635 | 2020-06-29 | Elko | Nevada | 32007 | 124 | 1 |
288785 | 288785 | 2020-06-30 | Elko | Nevada | 32007 | 127 | 1 |
291937 | 291937 | 2020-07-01 | Elko | Nevada | 32007 | 131 | 1 |
295092 | 295092 | 2020-07-02 | Elko | Nevada | 32007 | 134 | 1 |
298252 | 298252 | 2020-07-03 | Elko | Nevada | 32007 | 135 | 1 |
301415 | 301415 | 2020-07-04 | Elko | Nevada | 32007 | 140 | 1 |
304578 | 304578 | 2020-07-05 | Elko | Nevada | 32007 | 144 | 1 |
307745 | 307745 | 2020-07-06 | Elko | Nevada | 32007 | 162 | 1 |
310913 | 310913 | 2020-07-07 | Elko | Nevada | 32007 | 162 | 1 |
314084 | 314084 | 2020-07-08 | Elko | Nevada | 32007 | 185 | 1 |
317258 | 317258 | 2020-07-09 | Elko | Nevada | 32007 | 199 | 1 |
320434 | 320434 | 2020-07-10 | Elko | Nevada | 32007 | 213 | 1 |
323614 | 323614 | 2020-07-11 | Elko | Nevada | 32007 | 243 | 1 |
326798 | 326798 | 2020-07-12 | Elko | Nevada | 32007 | 244 | 1 |
329985 | 329985 | 2020-07-13 | Elko | Nevada | 32007 | 267 | 1 |
333176 | 333176 | 2020-07-14 | Elko | Nevada | 32007 | 267 | 1 |
336370 | 336370 | 2020-07-15 | Elko | Nevada | 32007 | 288 | 1 |
339566 | 339566 | 2020-07-16 | Elko | Nevada | 32007 | 298 | 1 |
342764 | 342764 | 2020-07-17 | Elko | Nevada | 32007 | 308 | 1 |
345963 | 345963 | 2020-07-18 | Elko | Nevada | 32007 | 308 | 1 |
349164 | 349164 | 2020-07-19 | Elko | Nevada | 32007 | 325 | 1 |
352367 | 352367 | 2020-07-20 | Elko | Nevada | 32007 | 342 | 1 |
355570 | 355570 | 2020-07-21 | Elko | Nevada | 32007 | 344 | 2 |
358774 | 358774 | 2020-07-22 | Elko | Nevada | 32007 | 350 | 2 |
361980 | 361980 | 2020-07-23 | Elko | Nevada | 32007 | 373 | 2 |
365186 | 365186 | 2020-07-24 | Elko | Nevada | 32007 | 384 | 2 |
368395 | 368395 | 2020-07-25 | Elko | Nevada | 32007 | 386 | 2 |
371607 | 371607 | 2020-07-26 | Elko | Nevada | 32007 | 411 | 2 |
374819 | 374819 | 2020-07-27 | Elko | Nevada | 32007 | 424 | 2 |
378034 | 378034 | 2020-07-28 | Elko | Nevada | 32007 | 435 | 2 |
381252 | 381252 | 2020-07-29 | Elko | Nevada | 32007 | 444 | 2 |
384469 | 384469 | 2020-07-30 | Elko | Nevada | 32007 | 462 | 2 |
387686 | 387686 | 2020-07-31 | Elko | Nevada | 32007 | 462 | 2 |
390903 | 390903 | 2020-08-01 | Elko | Nevada | 32007 | 467 | 2 |
394120 | 394120 | 2020-08-02 | Elko | Nevada | 32007 | 482 | 2 |
397336 | 397336 | 2020-08-03 | Elko | Nevada | 32007 | 488 | 2 |
400551 | 400551 | 2020-08-04 | Elko | Nevada | 32007 | 503 | 2 |
403769 | 403769 | 2020-08-05 | Elko | Nevada | 32007 | 505 | 2 |
406988 | 406988 | 2020-08-06 | Elko | Nevada | 32007 | 524 | 2 |
410208 | 410208 | 2020-08-07 | Elko | Nevada | 32007 | 525 | 2 |
413428 | 413428 | 2020-08-08 | Elko | Nevada | 32007 | 535 | 2 |
416649 | 416649 | 2020-08-09 | Elko | Nevada | 32007 | 544 | 2 |
419870 | 419870 | 2020-08-10 | Elko | Nevada | 32007 | 553 | 2 |
423093 | 423093 | 2020-08-11 | Elko | Nevada | 32007 | 555 | 2 |
426315 | 426315 | 2020-08-12 | Elko | Nevada | 32007 | 567 | 2 |
429540 | 429540 | 2020-08-13 | Elko | Nevada | 32007 | 579 | 3 |
432767 | 432767 | 2020-08-14 | Elko | Nevada | 32007 | 613 | 3 |
435993 | 435993 | 2020-08-15 | Elko | Nevada | 32007 | 623 | 3 |
439218 | 439218 | 2020-08-16 | Elko | Nevada | 32007 | 640 | 3 |
442445 | 442445 | 2020-08-17 | Elko | Nevada | 32007 | 640 | 3 |
445671 | 445671 | 2020-08-18 | Elko | Nevada | 32007 | 644 | 3 |
448898 | 448898 | 2020-08-19 | Elko | Nevada | 32007 | 659 | 3 |
452126 | 452126 | 2020-08-20 | Elko | Nevada | 32007 | 700 | 3 |
455354 | 455354 | 2020-08-21 | Elko | Nevada | 32007 | 718 | 3 |
458582 | 458582 | 2020-08-22 | Elko | Nevada | 32007 | 719 | 3 |
461809 | 461809 | 2020-08-23 | Elko | Nevada | 32007 | 728 | 3 |
465040 | 465040 | 2020-08-24 | Elko | Nevada | 32007 | 731 | 3 |
468268 | 468268 | 2020-08-25 | Elko | Nevada | 32007 | 735 | 3 |
471500 | 471500 | 2020-08-26 | Elko | Nevada | 32007 | 735 | 3 |
474733 | 474733 | 2020-08-27 | Elko | Nevada | 32007 | 761 | 3 |
477966 | 477966 | 2020-08-28 | Elko | Nevada | 32007 | 778 | 4 |
481198 | 481198 | 2020-08-29 | Elko | Nevada | 32007 | 792 | 4 |
484433 | 484433 | 2020-08-30 | Elko | Nevada | 32007 | 792 | 4 |
487667 | 487667 | 2020-08-31 | Elko | Nevada | 32007 | 803 | 4 |
490900 | 490900 | 2020-09-01 | Elko | Nevada | 32007 | 813 | 4 |
494134 | 494134 | 2020-09-02 | Elko | Nevada | 32007 | 824 | 4 |
497367 | 497367 | 2020-09-03 | Elko | Nevada | 32007 | 824 | 6 |
500601 | 500601 | 2020-09-04 | Elko | Nevada | 32007 | 853 | 6 |
503835 | 503835 | 2020-09-05 | Elko | Nevada | 32007 | 860 | 6 |
507067 | 507067 | 2020-09-06 | Elko | Nevada | 32007 | 860 | 5 |
510300 | 510300 | 2020-09-07 | Elko | Nevada | 32007 | 863 | 5 |
513533 | 513533 | 2020-09-08 | Elko | Nevada | 32007 | 862 | 5 |
516767 | 516767 | 2020-09-09 | Elko | Nevada | 32007 | 865 | 6 |
520002 | 520002 | 2020-09-10 | Elko | Nevada | 32007 | 868 | 7 |
523239 | 523239 | 2020-09-11 | Elko | Nevada | 32007 | 875 | 7 |
526475 | 526475 | 2020-09-12 | Elko | Nevada | 32007 | 876 | 7 |
529711 | 529711 | 2020-09-13 | Elko | Nevada | 32007 | 883 | 7 |
532947 | 532947 | 2020-09-14 | Elko | Nevada | 32007 | 879 | 7 |
536182 | 536182 | 2020-09-15 | Elko | Nevada | 32007 | 895 | 8 |
539420 | 539420 | 2020-09-16 | Elko | Nevada | 32007 | 895 | 8 |
542656 | 542656 | 2020-09-17 | Elko | Nevada | 32007 | 896 | 8 |
545893 | 545893 | 2020-09-18 | Elko | Nevada | 32007 | 908 | 8 |
549131 | 549131 | 2020-09-19 | Elko | Nevada | 32007 | 908 | 8 |
552370 | 552370 | 2020-09-20 | Elko | Nevada | 32007 | 908 | 9 |
555608 | 555608 | 2020-09-21 | Elko | Nevada | 32007 | 912 | 9 |
558845 | 558845 | 2020-09-22 | Elko | Nevada | 32007 | 912 | 9 |
562082 | 562082 | 2020-09-23 | Elko | Nevada | 32007 | 925 | 9 |
565323 | 565323 | 2020-09-24 | Elko | Nevada | 32007 | 939 | 10 |
568564 | 568564 | 2020-09-25 | Elko | Nevada | 32007 | 945 | 10 |
571806 | 571806 | 2020-09-26 | Elko | Nevada | 32007 | 949 | 10 |
575049 | 575049 | 2020-09-27 | Elko | Nevada | 32007 | 952 | 10 |
578290 | 578290 | 2020-09-28 | Elko | Nevada | 32007 | 961 | 10 |
581531 | 581531 | 2020-09-29 | Elko | Nevada | 32007 | 968 | 10 |
584772 | 584772 | 2020-09-30 | Elko | Nevada | 32007 | 972 | 10 |
588012 | 588012 | 2020-10-01 | Elko | Nevada | 32007 | 978 | 10 |
591253 | 591253 | 2020-10-02 | Elko | Nevada | 32007 | 989 | 10 |
594494 | 594494 | 2020-10-03 | Elko | Nevada | 32007 | 999 | 10 |
597736 | 597736 | 2020-10-04 | Elko | Nevada | 32007 | 1005 | 10 |
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);