ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51700 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637890 | 637890 | 2020-10-16 | Newport News city | Virginia | 51700 | 3008 | 49 |
634645 | 634645 | 2020-10-15 | Newport News city | Virginia | 51700 | 2973 | 49 |
631400 | 631400 | 2020-10-14 | Newport News city | Virginia | 51700 | 2952 | 49 |
628156 | 628156 | 2020-10-13 | Newport News city | Virginia | 51700 | 2940 | 49 |
624913 | 624913 | 2020-10-12 | Newport News city | Virginia | 51700 | 2923 | 49 |
621670 | 621670 | 2020-10-11 | Newport News city | Virginia | 51700 | 2912 | 49 |
618427 | 618427 | 2020-10-10 | Newport News city | Virginia | 51700 | 2903 | 49 |
615185 | 615185 | 2020-10-09 | Newport News city | Virginia | 51700 | 2891 | 49 |
611944 | 611944 | 2020-10-08 | Newport News city | Virginia | 51700 | 2867 | 49 |
608702 | 608702 | 2020-10-07 | Newport News city | Virginia | 51700 | 2845 | 49 |
605459 | 605459 | 2020-10-06 | Newport News city | Virginia | 51700 | 2833 | 49 |
602217 | 602217 | 2020-10-05 | Newport News city | Virginia | 51700 | 2827 | 48 |
598974 | 598974 | 2020-10-04 | Newport News city | Virginia | 51700 | 2817 | 48 |
595731 | 595731 | 2020-10-03 | Newport News city | Virginia | 51700 | 2806 | 48 |
592489 | 592489 | 2020-10-02 | Newport News city | Virginia | 51700 | 2785 | 46 |
589249 | 589249 | 2020-10-01 | Newport News city | Virginia | 51700 | 2762 | 43 |
586008 | 586008 | 2020-09-30 | Newport News city | Virginia | 51700 | 2760 | 41 |
582768 | 582768 | 2020-09-29 | Newport News city | Virginia | 51700 | 2753 | 40 |
579529 | 579529 | 2020-09-28 | Newport News city | Virginia | 51700 | 2744 | 39 |
576288 | 576288 | 2020-09-27 | Newport News city | Virginia | 51700 | 2733 | 38 |
573044 | 573044 | 2020-09-26 | Newport News city | Virginia | 51700 | 2721 | 38 |
569802 | 569802 | 2020-09-25 | Newport News city | Virginia | 51700 | 2715 | 38 |
566561 | 566561 | 2020-09-24 | Newport News city | Virginia | 51700 | 2704 | 37 |
563320 | 563320 | 2020-09-23 | Newport News city | Virginia | 51700 | 2700 | 37 |
560081 | 560081 | 2020-09-22 | Newport News city | Virginia | 51700 | 2690 | 33 |
556845 | 556845 | 2020-09-21 | Newport News city | Virginia | 51700 | 2681 | 33 |
553608 | 553608 | 2020-09-20 | Newport News city | Virginia | 51700 | 2674 | 33 |
550369 | 550369 | 2020-09-19 | Newport News city | Virginia | 51700 | 2658 | 33 |
547130 | 547130 | 2020-09-18 | Newport News city | Virginia | 51700 | 2638 | 32 |
543893 | 543893 | 2020-09-17 | Newport News city | Virginia | 51700 | 2629 | 32 |
540657 | 540657 | 2020-09-16 | Newport News city | Virginia | 51700 | 2620 | 32 |
537420 | 537420 | 2020-09-15 | Newport News city | Virginia | 51700 | 2591 | 32 |
534184 | 534184 | 2020-09-14 | Newport News city | Virginia | 51700 | 2586 | 28 |
530949 | 530949 | 2020-09-13 | Newport News city | Virginia | 51700 | 2573 | 28 |
527712 | 527712 | 2020-09-12 | Newport News city | Virginia | 51700 | 2548 | 28 |
524476 | 524476 | 2020-09-11 | Newport News city | Virginia | 51700 | 2532 | 28 |
521240 | 521240 | 2020-09-10 | Newport News city | Virginia | 51700 | 2527 | 28 |
518003 | 518003 | 2020-09-09 | Newport News city | Virginia | 51700 | 2505 | 28 |
514768 | 514768 | 2020-09-08 | Newport News city | Virginia | 51700 | 2499 | 28 |
511535 | 511535 | 2020-09-07 | Newport News city | Virginia | 51700 | 2486 | 28 |
508302 | 508302 | 2020-09-06 | Newport News city | Virginia | 51700 | 2477 | 28 |
505070 | 505070 | 2020-09-05 | Newport News city | Virginia | 51700 | 2450 | 28 |
501836 | 501836 | 2020-09-04 | Newport News city | Virginia | 51700 | 2438 | 28 |
498602 | 498602 | 2020-09-03 | Newport News city | Virginia | 51700 | 2400 | 28 |
495369 | 495369 | 2020-09-02 | Newport News city | Virginia | 51700 | 2364 | 28 |
492135 | 492135 | 2020-09-01 | Newport News city | Virginia | 51700 | 2335 | 27 |
488902 | 488902 | 2020-08-31 | Newport News city | Virginia | 51700 | 2317 | 25 |
485669 | 485669 | 2020-08-30 | Newport News city | Virginia | 51700 | 2300 | 24 |
482434 | 482434 | 2020-08-29 | Newport News city | Virginia | 51700 | 2273 | 24 |
479200 | 479200 | 2020-08-28 | Newport News city | Virginia | 51700 | 2216 | 21 |
475967 | 475967 | 2020-08-27 | Newport News city | Virginia | 51700 | 2190 | 21 |
472734 | 472734 | 2020-08-26 | Newport News city | Virginia | 51700 | 2167 | 21 |
469502 | 469502 | 2020-08-25 | Newport News city | Virginia | 51700 | 2155 | 21 |
466273 | 466273 | 2020-08-24 | Newport News city | Virginia | 51700 | 2145 | 20 |
463044 | 463044 | 2020-08-23 | Newport News city | Virginia | 51700 | 2130 | 20 |
459815 | 459815 | 2020-08-22 | Newport News city | Virginia | 51700 | 2111 | 20 |
456588 | 456588 | 2020-08-21 | Newport News city | Virginia | 51700 | 2072 | 20 |
453360 | 453360 | 2020-08-20 | Newport News city | Virginia | 51700 | 2048 | 20 |
450132 | 450132 | 2020-08-19 | Newport News city | Virginia | 51700 | 2034 | 20 |
446904 | 446904 | 2020-08-18 | Newport News city | Virginia | 51700 | 2016 | 20 |
443677 | 443677 | 2020-08-17 | Newport News city | Virginia | 51700 | 1993 | 20 |
440451 | 440451 | 2020-08-16 | Newport News city | Virginia | 51700 | 1980 | 20 |
437225 | 437225 | 2020-08-15 | Newport News city | Virginia | 51700 | 1960 | 20 |
433999 | 433999 | 2020-08-14 | Newport News city | Virginia | 51700 | 1936 | 20 |
430774 | 430774 | 2020-08-13 | Newport News city | Virginia | 51700 | 1898 | 20 |
427546 | 427546 | 2020-08-12 | Newport News city | Virginia | 51700 | 1872 | 19 |
424322 | 424322 | 2020-08-11 | Newport News city | Virginia | 51700 | 1855 | 19 |
421101 | 421101 | 2020-08-10 | Newport News city | Virginia | 51700 | 1847 | 18 |
417880 | 417880 | 2020-08-09 | Newport News city | Virginia | 51700 | 1827 | 18 |
414659 | 414659 | 2020-08-08 | Newport News city | Virginia | 51700 | 1816 | 18 |
411439 | 411439 | 2020-08-07 | Newport News city | Virginia | 51700 | 1788 | 18 |
408220 | 408220 | 2020-08-06 | Newport News city | Virginia | 51700 | 1736 | 18 |
405000 | 405000 | 2020-08-05 | Newport News city | Virginia | 51700 | 1734 | 18 |
401782 | 401782 | 2020-08-04 | Newport News city | Virginia | 51700 | 1717 | 18 |
398566 | 398566 | 2020-08-03 | Newport News city | Virginia | 51700 | 1671 | 16 |
395350 | 395350 | 2020-08-02 | Newport News city | Virginia | 51700 | 1639 | 16 |
392134 | 392134 | 2020-08-01 | Newport News city | Virginia | 51700 | 1589 | 16 |
388917 | 388917 | 2020-07-31 | Newport News city | Virginia | 51700 | 1573 | 16 |
385700 | 385700 | 2020-07-30 | Newport News city | Virginia | 51700 | 1544 | 16 |
382482 | 382482 | 2020-07-29 | Newport News city | Virginia | 51700 | 1519 | 15 |
379265 | 379265 | 2020-07-28 | Newport News city | Virginia | 51700 | 1489 | 15 |
376049 | 376049 | 2020-07-27 | Newport News city | Virginia | 51700 | 1474 | 15 |
372835 | 372835 | 2020-07-26 | Newport News city | Virginia | 51700 | 1424 | 15 |
369623 | 369623 | 2020-07-25 | Newport News city | Virginia | 51700 | 1385 | 15 |
366414 | 366414 | 2020-07-24 | Newport News city | Virginia | 51700 | 1356 | 14 |
363208 | 363208 | 2020-07-23 | Newport News city | Virginia | 51700 | 1308 | 14 |
360002 | 360002 | 2020-07-22 | Newport News city | Virginia | 51700 | 1276 | 14 |
356797 | 356797 | 2020-07-21 | Newport News city | Virginia | 51700 | 1237 | 14 |
353594 | 353594 | 2020-07-20 | Newport News city | Virginia | 51700 | 1206 | 14 |
350392 | 350392 | 2020-07-19 | Newport News city | Virginia | 51700 | 1151 | 13 |
347191 | 347191 | 2020-07-18 | Newport News city | Virginia | 51700 | 1029 | 13 |
343991 | 343991 | 2020-07-17 | Newport News city | Virginia | 51700 | 984 | 10 |
340792 | 340792 | 2020-07-16 | Newport News city | Virginia | 51700 | 940 | 10 |
337596 | 337596 | 2020-07-15 | Newport News city | Virginia | 51700 | 900 | 10 |
334401 | 334401 | 2020-07-14 | Newport News city | Virginia | 51700 | 856 | 10 |
331208 | 331208 | 2020-07-13 | Newport News city | Virginia | 51700 | 815 | 10 |
328022 | 328022 | 2020-07-12 | Newport News city | Virginia | 51700 | 719 | 10 |
324837 | 324837 | 2020-07-11 | Newport News city | Virginia | 51700 | 693 | 10 |
321656 | 321656 | 2020-07-10 | Newport News city | Virginia | 51700 | 679 | 10 |
318477 | 318477 | 2020-07-09 | Newport News city | Virginia | 51700 | 659 | 10 |
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);