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 |
---|---|---|---|---|---|---|---|
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 |
315276 | 315276 | 2020-07-08 | Hanover | Virginia | 51085 | 456 | 31 |
312101 | 312101 | 2020-07-07 | Hanover | Virginia | 51085 | 452 | 31 |
308932 | 308932 | 2020-07-06 | Hanover | Virginia | 51085 | 449 | 29 |
305764 | 305764 | 2020-07-05 | Hanover | Virginia | 51085 | 447 | 29 |
302600 | 302600 | 2020-07-04 | Hanover | Virginia | 51085 | 443 | 29 |
299436 | 299436 | 2020-07-03 | Hanover | Virginia | 51085 | 442 | 29 |
296274 | 296274 | 2020-07-02 | Hanover | Virginia | 51085 | 435 | 27 |
293119 | 293119 | 2020-07-01 | Hanover | Virginia | 51085 | 429 | 27 |
289966 | 289966 | 2020-06-30 | Hanover | Virginia | 51085 | 429 | 26 |
286816 | 286816 | 2020-06-29 | Hanover | Virginia | 51085 | 423 | 26 |
283670 | 283670 | 2020-06-28 | Hanover | Virginia | 51085 | 420 | 26 |
280524 | 280524 | 2020-06-27 | Hanover | Virginia | 51085 | 416 | 26 |
277376 | 277376 | 2020-06-26 | Hanover | Virginia | 51085 | 415 | 25 |
274228 | 274228 | 2020-06-25 | Hanover | Virginia | 51085 | 412 | 25 |
271088 | 271088 | 2020-06-24 | Hanover | Virginia | 51085 | 410 | 25 |
267954 | 267954 | 2020-06-23 | Hanover | Virginia | 51085 | 410 | 25 |
264825 | 264825 | 2020-06-22 | Hanover | Virginia | 51085 | 405 | 25 |
261696 | 261696 | 2020-06-21 | Hanover | Virginia | 51085 | 403 | 25 |
258569 | 258569 | 2020-06-20 | Hanover | Virginia | 51085 | 397 | 25 |
255442 | 255442 | 2020-06-19 | Hanover | Virginia | 51085 | 387 | 25 |
252323 | 252323 | 2020-06-18 | Hanover | Virginia | 51085 | 380 | 25 |
249208 | 249208 | 2020-06-17 | Hanover | Virginia | 51085 | 378 | 25 |
246096 | 246096 | 2020-06-16 | Hanover | Virginia | 51085 | 375 | 25 |
242983 | 242983 | 2020-06-15 | Hanover | Virginia | 51085 | 374 | 25 |
239872 | 239872 | 2020-06-14 | Hanover | Virginia | 51085 | 371 | 25 |
236764 | 236764 | 2020-06-13 | Hanover | Virginia | 51085 | 368 | 25 |
233657 | 233657 | 2020-06-12 | Hanover | Virginia | 51085 | 362 | 25 |
230552 | 230552 | 2020-06-11 | Hanover | Virginia | 51085 | 357 | 25 |
227448 | 227448 | 2020-06-10 | Hanover | Virginia | 51085 | 354 | 25 |
224348 | 224348 | 2020-06-09 | Hanover | Virginia | 51085 | 351 | 24 |
221252 | 221252 | 2020-06-08 | Hanover | Virginia | 51085 | 347 | 24 |
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);