ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Mercer" 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 |
---|---|---|---|---|---|---|---|
638006 | 638006 | 2020-10-16 | Mercer | West Virginia | 54055 | 535 | 30 |
634761 | 634761 | 2020-10-15 | Mercer | West Virginia | 54055 | 494 | 29 |
631516 | 631516 | 2020-10-14 | Mercer | West Virginia | 54055 | 488 | 29 |
628272 | 628272 | 2020-10-13 | Mercer | West Virginia | 54055 | 478 | 29 |
625029 | 625029 | 2020-10-12 | Mercer | West Virginia | 54055 | 470 | 29 |
621786 | 621786 | 2020-10-11 | Mercer | West Virginia | 54055 | 467 | 29 |
618543 | 618543 | 2020-10-10 | Mercer | West Virginia | 54055 | 456 | 29 |
615301 | 615301 | 2020-10-09 | Mercer | West Virginia | 54055 | 450 | 28 |
612060 | 612060 | 2020-10-08 | Mercer | West Virginia | 54055 | 445 | 28 |
608818 | 608818 | 2020-10-07 | Mercer | West Virginia | 54055 | 441 | 28 |
605575 | 605575 | 2020-10-06 | Mercer | West Virginia | 54055 | 449 | 28 |
602333 | 602333 | 2020-10-05 | Mercer | West Virginia | 54055 | 439 | 28 |
599090 | 599090 | 2020-10-04 | Mercer | West Virginia | 54055 | 438 | 28 |
595847 | 595847 | 2020-10-03 | Mercer | West Virginia | 54055 | 436 | 28 |
592605 | 592605 | 2020-10-02 | Mercer | West Virginia | 54055 | 432 | 28 |
589365 | 589365 | 2020-10-01 | Mercer | West Virginia | 54055 | 430 | 28 |
586124 | 586124 | 2020-09-30 | Mercer | West Virginia | 54055 | 427 | 28 |
582884 | 582884 | 2020-09-29 | Mercer | West Virginia | 54055 | 425 | 28 |
579645 | 579645 | 2020-09-28 | Mercer | West Virginia | 54055 | 418 | 28 |
576404 | 576404 | 2020-09-27 | Mercer | West Virginia | 54055 | 415 | 28 |
573160 | 573160 | 2020-09-26 | Mercer | West Virginia | 54055 | 412 | 28 |
569918 | 569918 | 2020-09-25 | Mercer | West Virginia | 54055 | 409 | 28 |
566677 | 566677 | 2020-09-24 | Mercer | West Virginia | 54055 | 407 | 27 |
563436 | 563436 | 2020-09-23 | Mercer | West Virginia | 54055 | 404 | 27 |
560197 | 560197 | 2020-09-22 | Mercer | West Virginia | 54055 | 404 | 27 |
556961 | 556961 | 2020-09-21 | Mercer | West Virginia | 54055 | 401 | 26 |
553724 | 553724 | 2020-09-20 | Mercer | West Virginia | 54055 | 399 | 26 |
550485 | 550485 | 2020-09-19 | Mercer | West Virginia | 54055 | 398 | 26 |
547246 | 547246 | 2020-09-18 | Mercer | West Virginia | 54055 | 394 | 24 |
544009 | 544009 | 2020-09-17 | Mercer | West Virginia | 54055 | 392 | 24 |
540773 | 540773 | 2020-09-16 | Mercer | West Virginia | 54055 | 384 | 24 |
537536 | 537536 | 2020-09-15 | Mercer | West Virginia | 54055 | 384 | 24 |
534300 | 534300 | 2020-09-14 | Mercer | West Virginia | 54055 | 380 | 24 |
531065 | 531065 | 2020-09-13 | Mercer | West Virginia | 54055 | 379 | 24 |
527828 | 527828 | 2020-09-12 | Mercer | West Virginia | 54055 | 373 | 24 |
524592 | 524592 | 2020-09-11 | Mercer | West Virginia | 54055 | 357 | 24 |
521356 | 521356 | 2020-09-10 | Mercer | West Virginia | 54055 | 355 | 24 |
518119 | 518119 | 2020-09-09 | Mercer | West Virginia | 54055 | 350 | 24 |
514884 | 514884 | 2020-09-08 | Mercer | West Virginia | 54055 | 350 | 24 |
511651 | 511651 | 2020-09-07 | Mercer | West Virginia | 54055 | 350 | 24 |
508418 | 508418 | 2020-09-06 | Mercer | West Virginia | 54055 | 349 | 24 |
505186 | 505186 | 2020-09-05 | Mercer | West Virginia | 54055 | 344 | 24 |
501952 | 501952 | 2020-09-04 | Mercer | West Virginia | 54055 | 331 | 24 |
498718 | 498718 | 2020-09-03 | Mercer | West Virginia | 54055 | 323 | 24 |
495485 | 495485 | 2020-09-02 | Mercer | West Virginia | 54055 | 318 | 23 |
492251 | 492251 | 2020-09-01 | Mercer | West Virginia | 54055 | 311 | 23 |
489018 | 489018 | 2020-08-31 | Mercer | West Virginia | 54055 | 310 | 23 |
485785 | 485785 | 2020-08-30 | Mercer | West Virginia | 54055 | 297 | 23 |
482550 | 482550 | 2020-08-29 | Mercer | West Virginia | 54055 | 290 | 23 |
479316 | 479316 | 2020-08-28 | Mercer | West Virginia | 54055 | 290 | 22 |
476083 | 476083 | 2020-08-27 | Mercer | West Virginia | 54055 | 287 | 22 |
472850 | 472850 | 2020-08-26 | Mercer | West Virginia | 54055 | 284 | 22 |
469618 | 469618 | 2020-08-25 | Mercer | West Virginia | 54055 | 276 | 21 |
466389 | 466389 | 2020-08-24 | Mercer | West Virginia | 54055 | 276 | 21 |
463160 | 463160 | 2020-08-23 | Mercer | West Virginia | 54055 | 274 | 21 |
459931 | 459931 | 2020-08-22 | Mercer | West Virginia | 54055 | 272 | 20 |
456704 | 456704 | 2020-08-21 | Mercer | West Virginia | 54055 | 264 | 20 |
453476 | 453476 | 2020-08-20 | Mercer | West Virginia | 54055 | 256 | 17 |
450248 | 450248 | 2020-08-19 | Mercer | West Virginia | 54055 | 245 | 18 |
447020 | 447020 | 2020-08-18 | Mercer | West Virginia | 54055 | 244 | 18 |
443793 | 443793 | 2020-08-17 | Mercer | West Virginia | 54055 | 243 | 18 |
440567 | 440567 | 2020-08-16 | Mercer | West Virginia | 54055 | 240 | 18 |
437341 | 437341 | 2020-08-15 | Mercer | West Virginia | 54055 | 227 | 18 |
434115 | 434115 | 2020-08-14 | Mercer | West Virginia | 54055 | 219 | 17 |
430890 | 430890 | 2020-08-13 | Mercer | West Virginia | 54055 | 216 | 16 |
427662 | 427662 | 2020-08-12 | Mercer | West Virginia | 54055 | 209 | 16 |
424438 | 424438 | 2020-08-11 | Mercer | West Virginia | 54055 | 203 | 13 |
421217 | 421217 | 2020-08-10 | Mercer | West Virginia | 54055 | 200 | 11 |
417996 | 417996 | 2020-08-09 | Mercer | West Virginia | 54055 | 196 | 11 |
414775 | 414775 | 2020-08-08 | Mercer | West Virginia | 54055 | 182 | 3 |
411555 | 411555 | 2020-08-07 | Mercer | West Virginia | 54055 | 177 | 3 |
408336 | 408336 | 2020-08-06 | Mercer | West Virginia | 54055 | 174 | 3 |
405116 | 405116 | 2020-08-05 | Mercer | West Virginia | 54055 | 173 | 3 |
401898 | 401898 | 2020-08-04 | Mercer | West Virginia | 54055 | 167 | 3 |
398682 | 398682 | 2020-08-03 | Mercer | West Virginia | 54055 | 165 | 3 |
395466 | 395466 | 2020-08-02 | Mercer | West Virginia | 54055 | 164 | 3 |
392250 | 392250 | 2020-08-01 | Mercer | West Virginia | 54055 | 139 | 3 |
389033 | 389033 | 2020-07-31 | Mercer | West Virginia | 54055 | 138 | 3 |
385816 | 385816 | 2020-07-30 | Mercer | West Virginia | 54055 | 128 | 3 |
382598 | 382598 | 2020-07-29 | Mercer | West Virginia | 54055 | 126 | 3 |
379381 | 379381 | 2020-07-28 | Mercer | West Virginia | 54055 | 111 | 2 |
376165 | 376165 | 2020-07-27 | Mercer | West Virginia | 54055 | 91 | 0 |
372951 | 372951 | 2020-07-26 | Mercer | West Virginia | 54055 | 85 | 0 |
369739 | 369739 | 2020-07-25 | Mercer | West Virginia | 54055 | 84 | 0 |
366529 | 366529 | 2020-07-24 | Mercer | West Virginia | 54055 | 79 | 0 |
363322 | 363322 | 2020-07-23 | Mercer | West Virginia | 54055 | 78 | 0 |
360116 | 360116 | 2020-07-22 | Mercer | West Virginia | 54055 | 76 | 0 |
356911 | 356911 | 2020-07-21 | Mercer | West Virginia | 54055 | 74 | 0 |
353708 | 353708 | 2020-07-20 | Mercer | West Virginia | 54055 | 74 | 0 |
350506 | 350506 | 2020-07-19 | Mercer | West Virginia | 54055 | 72 | 0 |
347305 | 347305 | 2020-07-18 | Mercer | West Virginia | 54055 | 69 | 0 |
344105 | 344105 | 2020-07-17 | Mercer | West Virginia | 54055 | 68 | 0 |
340906 | 340906 | 2020-07-16 | Mercer | West Virginia | 54055 | 67 | 0 |
337710 | 337710 | 2020-07-15 | Mercer | West Virginia | 54055 | 67 | 0 |
334515 | 334515 | 2020-07-14 | Mercer | West Virginia | 54055 | 63 | 0 |
331322 | 331322 | 2020-07-13 | Mercer | West Virginia | 54055 | 63 | 0 |
328136 | 328136 | 2020-07-12 | Mercer | West Virginia | 54055 | 62 | 0 |
324950 | 324950 | 2020-07-11 | Mercer | West Virginia | 54055 | 62 | 0 |
321769 | 321769 | 2020-07-10 | Mercer | West Virginia | 54055 | 62 | 0 |
318590 | 318590 | 2020-07-09 | Mercer | West Virginia | 54055 | 61 | 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);