ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

39,812 rows where state = "Virginia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

state

  • Virginia · 39,812 ✖
Link rowid date ▲ county state fips cases deaths
955895 955895 2021-01-22 Accomack Virginia 51001 2206 31
955896 955896 2021-01-22 Albemarle Virginia 51003 3666 35
955897 955897 2021-01-22 Alexandria city Virginia 51510 8975 99
955898 955898 2021-01-22 Alleghany Virginia 51005 1047 29
955899 955899 2021-01-22 Amelia Virginia 51007 575 8
955900 955900 2021-01-22 Amherst Virginia 51009 2156 10
955901 955901 2021-01-22 Appomattox Virginia 51011 1129 8
955902 955902 2021-01-22 Arlington Virginia 51013 11006 196
955903 955903 2021-01-22 Augusta Virginia 51015 4527 43
955904 955904 2021-01-22 Bath Virginia 51017 236 0
955905 955905 2021-01-22 Bedford Virginia 51019 4679 36
955906 955906 2021-01-22 Bland Virginia 51021 589 7
955907 955907 2021-01-22 Botetourt Virginia 51023 1734 20
955908 955908 2021-01-22 Bristol city Virginia 51520 1142 22
955909 955909 2021-01-22 Brunswick Virginia 51025 1042 8
955910 955910 2021-01-22 Buchanan Virginia 51027 1012 26
955911 955911 2021-01-22 Buckingham Virginia 51029 1717 15
955912 955912 2021-01-22 Buena Vista city Virginia 51530 672 9
955913 955913 2021-01-22 Campbell Virginia 51031 3258 29
955914 955914 2021-01-22 Caroline Virginia 51033 1415 12
955915 955915 2021-01-22 Carroll Virginia 51035 1894 55
955916 955916 2021-01-22 Charles City Virginia 51036 316 9
955917 955917 2021-01-22 Charlotte Virginia 51037 555 10
955918 955918 2021-01-22 Charlottesville city Virginia 51540 2628 37
955919 955919 2021-01-22 Chesapeake city Virginia 51550 14015 120
955920 955920 2021-01-22 Chesterfield Virginia 51041 17408 195
955921 955921 2021-01-22 Clarke Virginia 51043 569 8
955922 955922 2021-01-22 Colonial Heights city Virginia 51570 924 30
955923 955923 2021-01-22 Covington city Virginia 51580 540 4
955924 955924 2021-01-22 Craig Virginia 51045 199 3
955925 955925 2021-01-22 Culpeper Virginia 51047 3558 32
955926 955926 2021-01-22 Cumberland Virginia 51049 293 4
955927 955927 2021-01-22 Danville city Virginia 51590 3224 64
955928 955928 2021-01-22 Dickenson Virginia 51051 797 13
955929 955929 2021-01-22 Dinwiddie Virginia 51053 1312 18
955930 955930 2021-01-22 Emporia city Virginia 51595 534 31
955931 955931 2021-01-22 Essex Virginia 51057 496 3
955932 955932 2021-01-22 Fairfax Virginia 51059 55846 749
955933 955933 2021-01-22 Fairfax city Virginia 51600 382 10
955934 955934 2021-01-22 Falls Church city Virginia 51610 256 6
955935 955935 2021-01-22 Fauquier Virginia 51061 3208 31
955936 955936 2021-01-22 Floyd Virginia 51063 651 18
955937 955937 2021-01-22 Fluvanna Virginia 51065 1040 11
955938 955938 2021-01-22 Franklin Virginia 51067 3102 31
955939 955939 2021-01-22 Franklin city Virginia 51620 795 20
955940 955940 2021-01-22 Frederick Virginia 51069 5195 40
955941 955941 2021-01-22 Fredericksburg city Virginia 51630 1364 14
955942 955942 2021-01-22 Galax city Virginia 51640 943 38
955943 955943 2021-01-22 Giles Virginia 51071 877 6
955944 955944 2021-01-22 Gloucester Virginia 51073 1318 19
955945 955945 2021-01-22 Goochland Virginia 51075 930 7
955946 955946 2021-01-22 Grayson Virginia 51077 998 26
955947 955947 2021-01-22 Greene Virginia 51079 758 4
955948 955948 2021-01-22 Greensville Virginia 51081 1164 17
955949 955949 2021-01-22 Halifax Virginia 51083 1817 48
955950 955950 2021-01-22 Hampton city Virginia 51650 6420 59
955951 955951 2021-01-22 Hanover Virginia 51085 5332 93
955952 955952 2021-01-22 Harrisonburg city Virginia 51660 5112 57
955953 955953 2021-01-22 Henrico Virginia 51087 16846 329
955954 955954 2021-01-22 Henry Virginia 51089 3484 65
955955 955955 2021-01-22 Highland Virginia 51091 72 0
955956 955956 2021-01-22 Hopewell city Virginia 51670 1436 12
955957 955957 2021-01-22 Isle of Wight Virginia 51093 1973 35
955958 955958 2021-01-22 James City Virginia 51095 3012 37
955959 955959 2021-01-22 King George Virginia 51099 1052 11
955960 955960 2021-01-22 King William Virginia 51101 645 5
955961 955961 2021-01-22 King and Queen Virginia 51097 234 3
955962 955962 2021-01-22 Lancaster Virginia 51103 496 3
955963 955963 2021-01-22 Lee Virginia 51105 2023 33
955964 955964 2021-01-22 Lexington city Virginia 51678 766 15
955965 955965 2021-01-22 Loudoun Virginia 51107 17809 171
955966 955966 2021-01-22 Louisa Virginia 51109 1341 11
955967 955967 2021-01-22 Lunenburg Virginia 51111 529 3
955968 955968 2021-01-22 Lynchburg city Virginia 51680 5669 66
955969 955969 2021-01-22 Madison Virginia 51113 416 5
955970 955970 2021-01-22 Manassas Park city Virginia 51685 1050 8
955971 955971 2021-01-22 Manassas city Virginia 51683 3500 32
955972 955972 2021-01-22 Martinsville city Virginia 51690 1277 30
955973 955973 2021-01-22 Mathews Virginia 51115 400 6
955974 955974 2021-01-22 Mecklenburg Virginia 51117 1632 43
955975 955975 2021-01-22 Middlesex Virginia 51119 370 15
955976 955976 2021-01-22 Montgomery Virginia 51121 5988 56
955977 955977 2021-01-22 Nelson Virginia 51125 560 5
955978 955978 2021-01-22 New Kent Virginia 51127 953 7
955979 955979 2021-01-22 Newport News city Virginia 51700 8517 79
955980 955980 2021-01-22 Norfolk city Virginia 51710 11715 132
955981 955981 2021-01-22 Northampton Virginia 51131 582 32
955982 955982 2021-01-22 Northumberland Virginia 51133 536 12
955983 955983 2021-01-22 Norton city Virginia 51720 223 2
955984 955984 2021-01-22 Nottoway Virginia 51135 1570 25
955985 955985 2021-01-22 Orange Virginia 51137 1390 16
955986 955986 2021-01-22 Page Virginia 51139 1445 38
955987 955987 2021-01-22 Patrick Virginia 51141 976 28
955988 955988 2021-01-22 Petersburg city Virginia 51730 2253 36
955989 955989 2021-01-22 Pittsylvania Virginia 51143 3754 43
955990 955990 2021-01-22 Poquoson city Virginia 51735 513 7
955991 955991 2021-01-22 Portsmouth city Virginia 51740 6028 96
955992 955992 2021-01-22 Powhatan Virginia 51145 1184 7
955993 955993 2021-01-22 Prince Edward Virginia 51147 1505 19
955994 955994 2021-01-22 Prince George Virginia 51149 2291 10

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);