ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Marshall" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638003 | 638003 | 2020-10-16 | Marshall | West Virginia | 54051 | 238 | 1 |
634758 | 634758 | 2020-10-15 | Marshall | West Virginia | 54051 | 231 | 1 |
631513 | 631513 | 2020-10-14 | Marshall | West Virginia | 54051 | 221 | 1 |
628269 | 628269 | 2020-10-13 | Marshall | West Virginia | 54051 | 218 | 1 |
625026 | 625026 | 2020-10-12 | Marshall | West Virginia | 54051 | 205 | 1 |
621783 | 621783 | 2020-10-11 | Marshall | West Virginia | 54051 | 205 | 1 |
618540 | 618540 | 2020-10-10 | Marshall | West Virginia | 54051 | 201 | 1 |
615298 | 615298 | 2020-10-09 | Marshall | West Virginia | 54051 | 196 | 1 |
612057 | 612057 | 2020-10-08 | Marshall | West Virginia | 54051 | 188 | 1 |
608815 | 608815 | 2020-10-07 | Marshall | West Virginia | 54051 | 186 | 1 |
605572 | 605572 | 2020-10-06 | Marshall | West Virginia | 54051 | 186 | 1 |
602330 | 602330 | 2020-10-05 | Marshall | West Virginia | 54051 | 186 | 1 |
599087 | 599087 | 2020-10-04 | Marshall | West Virginia | 54051 | 185 | 1 |
595844 | 595844 | 2020-10-03 | Marshall | West Virginia | 54051 | 184 | 1 |
592602 | 592602 | 2020-10-02 | Marshall | West Virginia | 54051 | 183 | 1 |
589362 | 589362 | 2020-10-01 | Marshall | West Virginia | 54051 | 182 | 1 |
586121 | 586121 | 2020-09-30 | Marshall | West Virginia | 54051 | 179 | 1 |
582881 | 582881 | 2020-09-29 | Marshall | West Virginia | 54051 | 179 | 1 |
579642 | 579642 | 2020-09-28 | Marshall | West Virginia | 54051 | 178 | 1 |
576401 | 576401 | 2020-09-27 | Marshall | West Virginia | 54051 | 173 | 1 |
573157 | 573157 | 2020-09-26 | Marshall | West Virginia | 54051 | 172 | 1 |
569915 | 569915 | 2020-09-25 | Marshall | West Virginia | 54051 | 170 | 1 |
566674 | 566674 | 2020-09-24 | Marshall | West Virginia | 54051 | 162 | 1 |
563433 | 563433 | 2020-09-23 | Marshall | West Virginia | 54051 | 163 | 1 |
560194 | 560194 | 2020-09-22 | Marshall | West Virginia | 54051 | 160 | 1 |
556958 | 556958 | 2020-09-21 | Marshall | West Virginia | 54051 | 159 | 1 |
553721 | 553721 | 2020-09-20 | Marshall | West Virginia | 54051 | 158 | 1 |
550482 | 550482 | 2020-09-19 | Marshall | West Virginia | 54051 | 154 | 1 |
547243 | 547243 | 2020-09-18 | Marshall | West Virginia | 54051 | 150 | 1 |
544006 | 544006 | 2020-09-17 | Marshall | West Virginia | 54051 | 148 | 1 |
540770 | 540770 | 2020-09-16 | Marshall | West Virginia | 54051 | 145 | 1 |
537533 | 537533 | 2020-09-15 | Marshall | West Virginia | 54051 | 143 | 1 |
534297 | 534297 | 2020-09-14 | Marshall | West Virginia | 54051 | 140 | 1 |
531062 | 531062 | 2020-09-13 | Marshall | West Virginia | 54051 | 139 | 1 |
527825 | 527825 | 2020-09-12 | Marshall | West Virginia | 54051 | 138 | 1 |
524589 | 524589 | 2020-09-11 | Marshall | West Virginia | 54051 | 139 | 1 |
521353 | 521353 | 2020-09-10 | Marshall | West Virginia | 54051 | 138 | 1 |
518116 | 518116 | 2020-09-09 | Marshall | West Virginia | 54051 | 136 | 1 |
514881 | 514881 | 2020-09-08 | Marshall | West Virginia | 54051 | 134 | 1 |
511648 | 511648 | 2020-09-07 | Marshall | West Virginia | 54051 | 134 | 1 |
508415 | 508415 | 2020-09-06 | Marshall | West Virginia | 54051 | 133 | 1 |
505183 | 505183 | 2020-09-05 | Marshall | West Virginia | 54051 | 133 | 1 |
501949 | 501949 | 2020-09-04 | Marshall | West Virginia | 54051 | 133 | 1 |
498715 | 498715 | 2020-09-03 | Marshall | West Virginia | 54051 | 133 | 1 |
495482 | 495482 | 2020-09-02 | Marshall | West Virginia | 54051 | 133 | 1 |
492248 | 492248 | 2020-09-01 | Marshall | West Virginia | 54051 | 133 | 1 |
489015 | 489015 | 2020-08-31 | Marshall | West Virginia | 54051 | 133 | 1 |
485782 | 485782 | 2020-08-30 | Marshall | West Virginia | 54051 | 133 | 1 |
482547 | 482547 | 2020-08-29 | Marshall | West Virginia | 54051 | 133 | 1 |
479313 | 479313 | 2020-08-28 | Marshall | West Virginia | 54051 | 133 | 1 |
476080 | 476080 | 2020-08-27 | Marshall | West Virginia | 54051 | 133 | 1 |
472847 | 472847 | 2020-08-26 | Marshall | West Virginia | 54051 | 134 | 1 |
469615 | 469615 | 2020-08-25 | Marshall | West Virginia | 54051 | 134 | 1 |
466386 | 466386 | 2020-08-24 | Marshall | West Virginia | 54051 | 135 | 1 |
463157 | 463157 | 2020-08-23 | Marshall | West Virginia | 54051 | 135 | 1 |
459928 | 459928 | 2020-08-22 | Marshall | West Virginia | 54051 | 135 | 1 |
456701 | 456701 | 2020-08-21 | Marshall | West Virginia | 54051 | 134 | 1 |
453473 | 453473 | 2020-08-20 | Marshall | West Virginia | 54051 | 133 | 1 |
450245 | 450245 | 2020-08-19 | Marshall | West Virginia | 54051 | 131 | 1 |
447017 | 447017 | 2020-08-18 | Marshall | West Virginia | 54051 | 130 | 1 |
443790 | 443790 | 2020-08-17 | Marshall | West Virginia | 54051 | 130 | 1 |
440564 | 440564 | 2020-08-16 | Marshall | West Virginia | 54051 | 130 | 1 |
437338 | 437338 | 2020-08-15 | Marshall | West Virginia | 54051 | 130 | 1 |
434112 | 434112 | 2020-08-14 | Marshall | West Virginia | 54051 | 130 | 1 |
430887 | 430887 | 2020-08-13 | Marshall | West Virginia | 54051 | 130 | 1 |
427659 | 427659 | 2020-08-12 | Marshall | West Virginia | 54051 | 130 | 1 |
424435 | 424435 | 2020-08-11 | Marshall | West Virginia | 54051 | 130 | 1 |
421214 | 421214 | 2020-08-10 | Marshall | West Virginia | 54051 | 130 | 1 |
417993 | 417993 | 2020-08-09 | Marshall | West Virginia | 54051 | 131 | 1 |
414772 | 414772 | 2020-08-08 | Marshall | West Virginia | 54051 | 131 | 1 |
411552 | 411552 | 2020-08-07 | Marshall | West Virginia | 54051 | 130 | 1 |
408333 | 408333 | 2020-08-06 | Marshall | West Virginia | 54051 | 128 | 1 |
405113 | 405113 | 2020-08-05 | Marshall | West Virginia | 54051 | 129 | 1 |
401895 | 401895 | 2020-08-04 | Marshall | West Virginia | 54051 | 129 | 1 |
398679 | 398679 | 2020-08-03 | Marshall | West Virginia | 54051 | 127 | 0 |
395463 | 395463 | 2020-08-02 | Marshall | West Virginia | 54051 | 125 | 0 |
392247 | 392247 | 2020-08-01 | Marshall | West Virginia | 54051 | 124 | 0 |
389030 | 389030 | 2020-07-31 | Marshall | West Virginia | 54051 | 124 | 0 |
385813 | 385813 | 2020-07-30 | Marshall | West Virginia | 54051 | 121 | 0 |
382595 | 382595 | 2020-07-29 | Marshall | West Virginia | 54051 | 118 | 0 |
379378 | 379378 | 2020-07-28 | Marshall | West Virginia | 54051 | 113 | 0 |
376162 | 376162 | 2020-07-27 | Marshall | West Virginia | 54051 | 109 | 0 |
372948 | 372948 | 2020-07-26 | Marshall | West Virginia | 54051 | 100 | 0 |
369736 | 369736 | 2020-07-25 | Marshall | West Virginia | 54051 | 97 | 0 |
366526 | 366526 | 2020-07-24 | Marshall | West Virginia | 54051 | 95 | 0 |
363319 | 363319 | 2020-07-23 | Marshall | West Virginia | 54051 | 92 | 0 |
360113 | 360113 | 2020-07-22 | Marshall | West Virginia | 54051 | 88 | 0 |
356908 | 356908 | 2020-07-21 | Marshall | West Virginia | 54051 | 84 | 0 |
353705 | 353705 | 2020-07-20 | Marshall | West Virginia | 54051 | 83 | 0 |
350503 | 350503 | 2020-07-19 | Marshall | West Virginia | 54051 | 83 | 0 |
347302 | 347302 | 2020-07-18 | Marshall | West Virginia | 54051 | 81 | 0 |
344102 | 344102 | 2020-07-17 | Marshall | West Virginia | 54051 | 78 | 0 |
340903 | 340903 | 2020-07-16 | Marshall | West Virginia | 54051 | 75 | 0 |
337707 | 337707 | 2020-07-15 | Marshall | West Virginia | 54051 | 72 | 0 |
334512 | 334512 | 2020-07-14 | Marshall | West Virginia | 54051 | 68 | 0 |
331319 | 331319 | 2020-07-13 | Marshall | West Virginia | 54051 | 66 | 0 |
328133 | 328133 | 2020-07-12 | Marshall | West Virginia | 54051 | 65 | 0 |
324947 | 324947 | 2020-07-11 | Marshall | West Virginia | 54051 | 63 | 0 |
321766 | 321766 | 2020-07-10 | Marshall | West Virginia | 54051 | 58 | 0 |
318587 | 318587 | 2020-07-09 | Marshall | West Virginia | 54051 | 55 | 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);