ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Wetzel" and state = "West Virginia" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312266 | 312266 | 2020-07-07 | Wetzel | West Virginia | 54103 | 18 | 0 |
315441 | 315441 | 2020-07-08 | Wetzel | West Virginia | 54103 | 25 | 0 |
318614 | 318614 | 2020-07-09 | Wetzel | West Virginia | 54103 | 26 | 0 |
321793 | 321793 | 2020-07-10 | Wetzel | West Virginia | 54103 | 30 | 0 |
324974 | 324974 | 2020-07-11 | Wetzel | West Virginia | 54103 | 34 | 0 |
328160 | 328160 | 2020-07-12 | Wetzel | West Virginia | 54103 | 36 | 0 |
331346 | 331346 | 2020-07-13 | Wetzel | West Virginia | 54103 | 37 | 0 |
334539 | 334539 | 2020-07-14 | Wetzel | West Virginia | 54103 | 37 | 0 |
337734 | 337734 | 2020-07-15 | Wetzel | West Virginia | 54103 | 38 | 0 |
340930 | 340930 | 2020-07-16 | Wetzel | West Virginia | 54103 | 38 | 0 |
344129 | 344129 | 2020-07-17 | Wetzel | West Virginia | 54103 | 40 | 0 |
347329 | 347329 | 2020-07-18 | Wetzel | West Virginia | 54103 | 40 | 0 |
350530 | 350530 | 2020-07-19 | Wetzel | West Virginia | 54103 | 42 | 0 |
353732 | 353732 | 2020-07-20 | Wetzel | West Virginia | 54103 | 41 | 0 |
356935 | 356935 | 2020-07-21 | Wetzel | West Virginia | 54103 | 41 | 0 |
360140 | 360140 | 2020-07-22 | Wetzel | West Virginia | 54103 | 41 | 0 |
363346 | 363346 | 2020-07-23 | Wetzel | West Virginia | 54103 | 41 | 0 |
366553 | 366553 | 2020-07-24 | Wetzel | West Virginia | 54103 | 41 | 0 |
369763 | 369763 | 2020-07-25 | Wetzel | West Virginia | 54103 | 40 | 0 |
372975 | 372975 | 2020-07-26 | Wetzel | West Virginia | 54103 | 40 | 0 |
376189 | 376189 | 2020-07-27 | Wetzel | West Virginia | 54103 | 40 | 0 |
379405 | 379405 | 2020-07-28 | Wetzel | West Virginia | 54103 | 40 | 0 |
382622 | 382622 | 2020-07-29 | Wetzel | West Virginia | 54103 | 40 | 0 |
385840 | 385840 | 2020-07-30 | Wetzel | West Virginia | 54103 | 40 | 0 |
389057 | 389057 | 2020-07-31 | Wetzel | West Virginia | 54103 | 40 | 0 |
392274 | 392274 | 2020-08-01 | Wetzel | West Virginia | 54103 | 40 | 0 |
395490 | 395490 | 2020-08-02 | Wetzel | West Virginia | 54103 | 40 | 0 |
398706 | 398706 | 2020-08-03 | Wetzel | West Virginia | 54103 | 40 | 0 |
401922 | 401922 | 2020-08-04 | Wetzel | West Virginia | 54103 | 40 | 0 |
405140 | 405140 | 2020-08-05 | Wetzel | West Virginia | 54103 | 40 | 0 |
408360 | 408360 | 2020-08-06 | Wetzel | West Virginia | 54103 | 40 | 0 |
411579 | 411579 | 2020-08-07 | Wetzel | West Virginia | 54103 | 42 | 0 |
414799 | 414799 | 2020-08-08 | Wetzel | West Virginia | 54103 | 42 | 0 |
418020 | 418020 | 2020-08-09 | Wetzel | West Virginia | 54103 | 42 | 0 |
421241 | 421241 | 2020-08-10 | Wetzel | West Virginia | 54103 | 43 | 0 |
424462 | 424462 | 2020-08-11 | Wetzel | West Virginia | 54103 | 44 | 0 |
427686 | 427686 | 2020-08-12 | Wetzel | West Virginia | 54103 | 44 | 0 |
430914 | 430914 | 2020-08-13 | Wetzel | West Virginia | 54103 | 44 | 0 |
434139 | 434139 | 2020-08-14 | Wetzel | West Virginia | 54103 | 44 | 0 |
437365 | 437365 | 2020-08-15 | Wetzel | West Virginia | 54103 | 45 | 0 |
440591 | 440591 | 2020-08-16 | Wetzel | West Virginia | 54103 | 44 | 0 |
443817 | 443817 | 2020-08-17 | Wetzel | West Virginia | 54103 | 44 | 0 |
447044 | 447044 | 2020-08-18 | Wetzel | West Virginia | 54103 | 44 | 0 |
450272 | 450272 | 2020-08-19 | Wetzel | West Virginia | 54103 | 45 | 0 |
453500 | 453500 | 2020-08-20 | Wetzel | West Virginia | 54103 | 45 | 0 |
456728 | 456728 | 2020-08-21 | Wetzel | West Virginia | 54103 | 45 | 0 |
459955 | 459955 | 2020-08-22 | Wetzel | West Virginia | 54103 | 45 | 0 |
463184 | 463184 | 2020-08-23 | Wetzel | West Virginia | 54103 | 45 | 0 |
466413 | 466413 | 2020-08-24 | Wetzel | West Virginia | 54103 | 45 | 0 |
469642 | 469642 | 2020-08-25 | Wetzel | West Virginia | 54103 | 45 | 0 |
472874 | 472874 | 2020-08-26 | Wetzel | West Virginia | 54103 | 45 | 0 |
476107 | 476107 | 2020-08-27 | Wetzel | West Virginia | 54103 | 45 | 0 |
479340 | 479340 | 2020-08-28 | Wetzel | West Virginia | 54103 | 45 | 0 |
482574 | 482574 | 2020-08-29 | Wetzel | West Virginia | 54103 | 45 | 0 |
485809 | 485809 | 2020-08-30 | Wetzel | West Virginia | 54103 | 46 | 0 |
489042 | 489042 | 2020-08-31 | Wetzel | West Virginia | 54103 | 46 | 0 |
492275 | 492275 | 2020-09-01 | Wetzel | West Virginia | 54103 | 46 | 0 |
495509 | 495509 | 2020-09-02 | Wetzel | West Virginia | 54103 | 46 | 0 |
498742 | 498742 | 2020-09-03 | Wetzel | West Virginia | 54103 | 45 | 0 |
501976 | 501976 | 2020-09-04 | Wetzel | West Virginia | 54103 | 45 | 0 |
505210 | 505210 | 2020-09-05 | Wetzel | West Virginia | 54103 | 45 | 0 |
508442 | 508442 | 2020-09-06 | Wetzel | West Virginia | 54103 | 45 | 0 |
511675 | 511675 | 2020-09-07 | Wetzel | West Virginia | 54103 | 45 | 0 |
514908 | 514908 | 2020-09-08 | Wetzel | West Virginia | 54103 | 45 | 0 |
518143 | 518143 | 2020-09-09 | Wetzel | West Virginia | 54103 | 45 | 0 |
521380 | 521380 | 2020-09-10 | Wetzel | West Virginia | 54103 | 45 | 0 |
524616 | 524616 | 2020-09-11 | Wetzel | West Virginia | 54103 | 46 | 0 |
527852 | 527852 | 2020-09-12 | Wetzel | West Virginia | 54103 | 46 | 0 |
531089 | 531089 | 2020-09-13 | Wetzel | West Virginia | 54103 | 46 | 0 |
534324 | 534324 | 2020-09-14 | Wetzel | West Virginia | 54103 | 46 | 0 |
537560 | 537560 | 2020-09-15 | Wetzel | West Virginia | 54103 | 47 | 0 |
540797 | 540797 | 2020-09-16 | Wetzel | West Virginia | 54103 | 47 | 0 |
544033 | 544033 | 2020-09-17 | Wetzel | West Virginia | 54103 | 49 | 0 |
547270 | 547270 | 2020-09-18 | Wetzel | West Virginia | 54103 | 49 | 0 |
550509 | 550509 | 2020-09-19 | Wetzel | West Virginia | 54103 | 49 | 0 |
553748 | 553748 | 2020-09-20 | Wetzel | West Virginia | 54103 | 49 | 0 |
556985 | 556985 | 2020-09-21 | Wetzel | West Virginia | 54103 | 49 | 0 |
560221 | 560221 | 2020-09-22 | Wetzel | West Virginia | 54103 | 50 | 0 |
563460 | 563460 | 2020-09-23 | Wetzel | West Virginia | 54103 | 50 | 0 |
566701 | 566701 | 2020-09-24 | Wetzel | West Virginia | 54103 | 51 | 0 |
569942 | 569942 | 2020-09-25 | Wetzel | West Virginia | 54103 | 53 | 0 |
573184 | 573184 | 2020-09-26 | Wetzel | West Virginia | 54103 | 54 | 0 |
576428 | 576428 | 2020-09-27 | Wetzel | West Virginia | 54103 | 55 | 0 |
579669 | 579669 | 2020-09-28 | Wetzel | West Virginia | 54103 | 55 | 0 |
582908 | 582908 | 2020-09-29 | Wetzel | West Virginia | 54103 | 56 | 0 |
586148 | 586148 | 2020-09-30 | Wetzel | West Virginia | 54103 | 58 | 0 |
589389 | 589389 | 2020-10-01 | Wetzel | West Virginia | 54103 | 61 | 0 |
592629 | 592629 | 2020-10-02 | Wetzel | West Virginia | 54103 | 62 | 0 |
595871 | 595871 | 2020-10-03 | Wetzel | West Virginia | 54103 | 65 | 0 |
599114 | 599114 | 2020-10-04 | Wetzel | West Virginia | 54103 | 66 | 0 |
602357 | 602357 | 2020-10-05 | Wetzel | West Virginia | 54103 | 66 | 0 |
605599 | 605599 | 2020-10-06 | Wetzel | West Virginia | 54103 | 64 | 0 |
608842 | 608842 | 2020-10-07 | Wetzel | West Virginia | 54103 | 65 | 0 |
612084 | 612084 | 2020-10-08 | Wetzel | West Virginia | 54103 | 67 | 0 |
615325 | 615325 | 2020-10-09 | Wetzel | West Virginia | 54103 | 67 | 0 |
618567 | 618567 | 2020-10-10 | Wetzel | West Virginia | 54103 | 68 | 0 |
621810 | 621810 | 2020-10-11 | Wetzel | West Virginia | 54103 | 69 | 0 |
625053 | 625053 | 2020-10-12 | Wetzel | West Virginia | 54103 | 69 | 0 |
628296 | 628296 | 2020-10-13 | Wetzel | West Virginia | 54103 | 71 | 0 |
631540 | 631540 | 2020-10-14 | Wetzel | West Virginia | 54103 | 71 | 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);