ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Hanover" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637862 | 637862 | 2020-10-16 | Hanover | Virginia | 51085 | 1507 | 40 |
634617 | 634617 | 2020-10-15 | Hanover | Virginia | 51085 | 1495 | 40 |
631372 | 631372 | 2020-10-14 | Hanover | Virginia | 51085 | 1475 | 40 |
628128 | 628128 | 2020-10-13 | Hanover | Virginia | 51085 | 1468 | 40 |
624885 | 624885 | 2020-10-12 | Hanover | Virginia | 51085 | 1453 | 40 |
621642 | 621642 | 2020-10-11 | Hanover | Virginia | 51085 | 1444 | 40 |
618399 | 618399 | 2020-10-10 | Hanover | Virginia | 51085 | 1433 | 40 |
615157 | 615157 | 2020-10-09 | Hanover | Virginia | 51085 | 1421 | 40 |
611916 | 611916 | 2020-10-08 | Hanover | Virginia | 51085 | 1416 | 40 |
608674 | 608674 | 2020-10-07 | Hanover | Virginia | 51085 | 1401 | 39 |
605431 | 605431 | 2020-10-06 | Hanover | Virginia | 51085 | 1395 | 39 |
602189 | 602189 | 2020-10-05 | Hanover | Virginia | 51085 | 1372 | 39 |
598946 | 598946 | 2020-10-04 | Hanover | Virginia | 51085 | 1358 | 39 |
595703 | 595703 | 2020-10-03 | Hanover | Virginia | 51085 | 1347 | 39 |
592461 | 592461 | 2020-10-02 | Hanover | Virginia | 51085 | 1337 | 39 |
589221 | 589221 | 2020-10-01 | Hanover | Virginia | 51085 | 1326 | 38 |
585980 | 585980 | 2020-09-30 | Hanover | Virginia | 51085 | 1320 | 38 |
582740 | 582740 | 2020-09-29 | Hanover | Virginia | 51085 | 1311 | 38 |
579501 | 579501 | 2020-09-28 | Hanover | Virginia | 51085 | 1297 | 37 |
576260 | 576260 | 2020-09-27 | Hanover | Virginia | 51085 | 1293 | 37 |
573016 | 573016 | 2020-09-26 | Hanover | Virginia | 51085 | 1288 | 37 |
569774 | 569774 | 2020-09-25 | Hanover | Virginia | 51085 | 1286 | 37 |
566533 | 566533 | 2020-09-24 | Hanover | Virginia | 51085 | 1265 | 36 |
563292 | 563292 | 2020-09-23 | Hanover | Virginia | 51085 | 1248 | 36 |
560053 | 560053 | 2020-09-22 | Hanover | Virginia | 51085 | 1241 | 36 |
556817 | 556817 | 2020-09-21 | Hanover | Virginia | 51085 | 1230 | 36 |
553580 | 553580 | 2020-09-20 | Hanover | Virginia | 51085 | 1222 | 36 |
550341 | 550341 | 2020-09-19 | Hanover | Virginia | 51085 | 1212 | 36 |
547102 | 547102 | 2020-09-18 | Hanover | Virginia | 51085 | 1198 | 35 |
543865 | 543865 | 2020-09-17 | Hanover | Virginia | 51085 | 1195 | 35 |
540629 | 540629 | 2020-09-16 | Hanover | Virginia | 51085 | 1190 | 35 |
537392 | 537392 | 2020-09-15 | Hanover | Virginia | 51085 | 1187 | 35 |
534156 | 534156 | 2020-09-14 | Hanover | Virginia | 51085 | 1124 | 35 |
530921 | 530921 | 2020-09-13 | Hanover | Virginia | 51085 | 1090 | 35 |
527684 | 527684 | 2020-09-12 | Hanover | Virginia | 51085 | 1068 | 35 |
524448 | 524448 | 2020-09-11 | Hanover | Virginia | 51085 | 1049 | 35 |
521212 | 521212 | 2020-09-10 | Hanover | Virginia | 51085 | 1023 | 35 |
517975 | 517975 | 2020-09-09 | Hanover | Virginia | 51085 | 901 | 35 |
514740 | 514740 | 2020-09-08 | Hanover | Virginia | 51085 | 890 | 35 |
511507 | 511507 | 2020-09-07 | Hanover | Virginia | 51085 | 876 | 35 |
508274 | 508274 | 2020-09-06 | Hanover | Virginia | 51085 | 863 | 35 |
505042 | 505042 | 2020-09-05 | Hanover | Virginia | 51085 | 855 | 35 |
501808 | 501808 | 2020-09-04 | Hanover | Virginia | 51085 | 846 | 35 |
498574 | 498574 | 2020-09-03 | Hanover | Virginia | 51085 | 832 | 35 |
495341 | 495341 | 2020-09-02 | Hanover | Virginia | 51085 | 816 | 35 |
492107 | 492107 | 2020-09-01 | Hanover | Virginia | 51085 | 810 | 35 |
488874 | 488874 | 2020-08-31 | Hanover | Virginia | 51085 | 794 | 35 |
485641 | 485641 | 2020-08-30 | Hanover | Virginia | 51085 | 787 | 35 |
482406 | 482406 | 2020-08-29 | Hanover | Virginia | 51085 | 779 | 35 |
479172 | 479172 | 2020-08-28 | Hanover | Virginia | 51085 | 768 | 34 |
475939 | 475939 | 2020-08-27 | Hanover | Virginia | 51085 | 762 | 34 |
472706 | 472706 | 2020-08-26 | Hanover | Virginia | 51085 | 757 | 34 |
469474 | 469474 | 2020-08-25 | Hanover | Virginia | 51085 | 745 | 34 |
466245 | 466245 | 2020-08-24 | Hanover | Virginia | 51085 | 743 | 34 |
463016 | 463016 | 2020-08-23 | Hanover | Virginia | 51085 | 741 | 34 |
459787 | 459787 | 2020-08-22 | Hanover | Virginia | 51085 | 736 | 33 |
456560 | 456560 | 2020-08-21 | Hanover | Virginia | 51085 | 732 | 33 |
453332 | 453332 | 2020-08-20 | Hanover | Virginia | 51085 | 729 | 33 |
450104 | 450104 | 2020-08-19 | Hanover | Virginia | 51085 | 722 | 33 |
446876 | 446876 | 2020-08-18 | Hanover | Virginia | 51085 | 716 | 33 |
443649 | 443649 | 2020-08-17 | Hanover | Virginia | 51085 | 703 | 33 |
440423 | 440423 | 2020-08-16 | Hanover | Virginia | 51085 | 700 | 33 |
437197 | 437197 | 2020-08-15 | Hanover | Virginia | 51085 | 695 | 33 |
433971 | 433971 | 2020-08-14 | Hanover | Virginia | 51085 | 690 | 33 |
430746 | 430746 | 2020-08-13 | Hanover | Virginia | 51085 | 676 | 33 |
427518 | 427518 | 2020-08-12 | Hanover | Virginia | 51085 | 660 | 33 |
424294 | 424294 | 2020-08-11 | Hanover | Virginia | 51085 | 656 | 32 |
421073 | 421073 | 2020-08-10 | Hanover | Virginia | 51085 | 653 | 32 |
417852 | 417852 | 2020-08-09 | Hanover | Virginia | 51085 | 644 | 32 |
414631 | 414631 | 2020-08-08 | Hanover | Virginia | 51085 | 641 | 32 |
411411 | 411411 | 2020-08-07 | Hanover | Virginia | 51085 | 637 | 32 |
408192 | 408192 | 2020-08-06 | Hanover | Virginia | 51085 | 615 | 32 |
404972 | 404972 | 2020-08-05 | Hanover | Virginia | 51085 | 611 | 32 |
401754 | 401754 | 2020-08-04 | Hanover | Virginia | 51085 | 605 | 31 |
398538 | 398538 | 2020-08-03 | Hanover | Virginia | 51085 | 597 | 31 |
395322 | 395322 | 2020-08-02 | Hanover | Virginia | 51085 | 590 | 31 |
392106 | 392106 | 2020-08-01 | Hanover | Virginia | 51085 | 588 | 31 |
388889 | 388889 | 2020-07-31 | Hanover | Virginia | 51085 | 584 | 31 |
385672 | 385672 | 2020-07-30 | Hanover | Virginia | 51085 | 583 | 30 |
382454 | 382454 | 2020-07-29 | Hanover | Virginia | 51085 | 579 | 30 |
379237 | 379237 | 2020-07-28 | Hanover | Virginia | 51085 | 576 | 30 |
376021 | 376021 | 2020-07-27 | Hanover | Virginia | 51085 | 575 | 30 |
372807 | 372807 | 2020-07-26 | Hanover | Virginia | 51085 | 563 | 30 |
369595 | 369595 | 2020-07-25 | Hanover | Virginia | 51085 | 557 | 30 |
366386 | 366386 | 2020-07-24 | Hanover | Virginia | 51085 | 546 | 30 |
363180 | 363180 | 2020-07-23 | Hanover | Virginia | 51085 | 539 | 30 |
359974 | 359974 | 2020-07-22 | Hanover | Virginia | 51085 | 531 | 30 |
356769 | 356769 | 2020-07-21 | Hanover | Virginia | 51085 | 532 | 30 |
353566 | 353566 | 2020-07-20 | Hanover | Virginia | 51085 | 518 | 30 |
350364 | 350364 | 2020-07-19 | Hanover | Virginia | 51085 | 514 | 30 |
347163 | 347163 | 2020-07-18 | Hanover | Virginia | 51085 | 511 | 30 |
343963 | 343963 | 2020-07-17 | Hanover | Virginia | 51085 | 508 | 30 |
340764 | 340764 | 2020-07-16 | Hanover | Virginia | 51085 | 504 | 30 |
337568 | 337568 | 2020-07-15 | Hanover | Virginia | 51085 | 491 | 30 |
334373 | 334373 | 2020-07-14 | Hanover | Virginia | 51085 | 486 | 31 |
331180 | 331180 | 2020-07-13 | Hanover | Virginia | 51085 | 483 | 31 |
327994 | 327994 | 2020-07-12 | Hanover | Virginia | 51085 | 476 | 31 |
324809 | 324809 | 2020-07-11 | Hanover | Virginia | 51085 | 469 | 31 |
321628 | 321628 | 2020-07-10 | Hanover | Virginia | 51085 | 467 | 31 |
318449 | 318449 | 2020-07-09 | Hanover | Virginia | 51085 | 459 | 31 |
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);