ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 188 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Highland 7
- Essex 5
- Cumberland 3
- Falls Church city 3
- Emporia city 2
- Gloucester 2
- King and Queen 2
- Rappahannock 2
- Alexandria city 1
- Botetourt 1
- Bristol city 1
- Brunswick 1
- Buchanan 1
- Carroll 1
- Clarke 1
- Colonial Heights city 1
- Craig 1
- Danville city 1
- Floyd 1
- Fluvanna 1
- Franklin city 1
- Greene 1
- Henry 1
- Hopewell city 1
- King William 1
- Lancaster 1
- Loudoun 1
- Nelson 1
- New Kent 1
- Norfolk city 1
- …
state 1
- Virginia · 62 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1926831 | 1926831 | 2021-11-17 | Highland | Virginia | 51091 | 188 | 4 |
1923581 | 1923581 | 2021-11-16 | Highland | Virginia | 51091 | 188 | 4 |
1920332 | 1920332 | 2021-11-15 | Highland | Virginia | 51091 | 188 | 4 |
1917082 | 1917082 | 2021-11-14 | Highland | Virginia | 51091 | 188 | 4 |
1913832 | 1913832 | 2021-11-13 | Highland | Virginia | 51091 | 188 | 4 |
1910582 | 1910582 | 2021-11-12 | Highland | Virginia | 51091 | 188 | 4 |
1907333 | 1907333 | 2021-11-11 | Highland | Virginia | 51091 | 188 | 4 |
942861 | 942861 | 2021-01-18 | Craig | Virginia | 51045 | 188 | 2 |
920219 | 920219 | 2021-01-11 | Rappahannock | Virginia | 51157 | 188 | 2 |
916974 | 916974 | 2021-01-10 | Rappahannock | Virginia | 51157 | 188 | 2 |
910447 | 910447 | 2021-01-08 | King and Queen | Virginia | 51097 | 188 | 2 |
907202 | 907202 | 2021-01-07 | King and Queen | Virginia | 51097 | 188 | 2 |
900684 | 900684 | 2021-01-05 | Falls Church city | Virginia | 51610 | 188 | 6 |
897439 | 897439 | 2021-01-04 | Falls Church city | Virginia | 51610 | 188 | 6 |
894193 | 894193 | 2021-01-03 | Falls Church city | Virginia | 51610 | 188 | 6 |
871467 | 871467 | 2020-12-27 | Cumberland | Virginia | 51049 | 188 | 4 |
868222 | 868222 | 2020-12-26 | Cumberland | Virginia | 51049 | 188 | 4 |
864977 | 864977 | 2020-12-25 | Cumberland | Virginia | 51049 | 188 | 4 |
809891 | 809891 | 2020-12-08 | Surry | Virginia | 51181 | 188 | 5 |
787138 | 787138 | 2020-12-01 | Nelson | Virginia | 51125 | 188 | 3 |
770857 | 770857 | 2020-11-26 | Clarke | Virginia | 51043 | 188 | 3 |
657348 | 657348 | 2020-10-22 | Lancaster | Virginia | 51103 | 188 | 1 |
650827 | 650827 | 2020-10-20 | Essex | Virginia | 51057 | 188 | 2 |
647612 | 647612 | 2020-10-19 | King William | Virginia | 51101 | 188 | 2 |
644337 | 644337 | 2020-10-18 | Essex | Virginia | 51057 | 188 | 2 |
641089 | 641089 | 2020-10-17 | Essex | Virginia | 51057 | 188 | 2 |
637842 | 637842 | 2020-10-16 | Essex | Virginia | 51057 | 188 | 2 |
634597 | 634597 | 2020-10-15 | Essex | Virginia | 51057 | 188 | 2 |
611947 | 611947 | 2020-10-08 | Northumberland | Virginia | 51133 | 188 | 6 |
608633 | 608633 | 2020-10-07 | Buchanan | Virginia | 51027 | 188 | 2 |
592533 | 592533 | 2020-10-02 | Williamsburg city | Virginia | 51830 | 188 | 7 |
589178 | 589178 | 2020-10-01 | Bristol city | Virginia | 51520 | 188 | 6 |
569801 | 569801 | 2020-09-25 | New Kent | Virginia | 51127 | 188 | 3 |
543850 | 543850 | 2020-09-17 | Floyd | Virginia | 51063 | 188 | 5 |
537437 | 537437 | 2020-09-15 | Pulaski | Virginia | 51155 | 188 | 3 |
492161 | 492161 | 2020-09-01 | Russell | Virginia | 51167 | 188 | 4 |
482472 | 482472 | 2020-08-29 | Tazewell | Virginia | 51185 | 188 | 1 |
472739 | 472739 | 2020-08-26 | Nottoway | Virginia | 51135 | 188 | 14 |
469467 | 469467 | 2020-08-25 | Gloucester | Virginia | 51073 | 188 | 2 |
469520 | 469520 | 2020-08-25 | Radford city | Virginia | 51750 | 188 | 0 |
466238 | 466238 | 2020-08-24 | Gloucester | Virginia | 51073 | 188 | 2 |
456556 | 456556 | 2020-08-21 | Greene | Virginia | 51079 | 188 | 2 |
440402 | 440402 | 2020-08-16 | Emporia city | Virginia | 51595 | 188 | 15 |
440493 | 440493 | 2020-08-16 | Waynesboro city | Virginia | 51820 | 188 | 3 |
437176 | 437176 | 2020-08-15 | Emporia city | Virginia | 51595 | 188 | 15 |
427506 | 427506 | 2020-08-12 | Franklin city | Virginia | 51620 | 188 | 6 |
414617 | 414617 | 2020-08-08 | Fluvanna | Virginia | 51065 | 188 | 9 |
404943 | 404943 | 2020-08-05 | Colonial Heights city | Virginia | 51570 | 188 | 21 |
395278 | 395278 | 2020-08-02 | Botetourt | Virginia | 51023 | 188 | 7 |
382412 | 382412 | 2020-07-29 | Brunswick | Virginia | 51025 | 188 | 1 |
369666 | 369666 | 2020-07-25 | Westmoreland | Virginia | 51193 | 188 | 2 |
363214 | 363214 | 2020-07-23 | Orange | Virginia | 51137 | 188 | 3 |
350340 | 350340 | 2020-07-19 | Danville city | Virginia | 51590 | 188 | 2 |
308937 | 308937 | 2020-07-06 | Hopewell city | Virginia | 51670 | 188 | 2 |
261660 | 261660 | 2020-06-21 | Carroll | Virginia | 51035 | 188 | 5 |
230555 | 230555 | 2020-06-11 | Henry | Virginia | 51089 | 188 | 3 |
175226 | 175226 | 2020-05-24 | Page | Virginia | 51139 | 188 | 21 |
130034 | 130034 | 2020-05-09 | Richmond | Virginia | 51159 | 188 | 3 |
97941 | 97941 | 2020-04-28 | Norfolk city | Virginia | 51710 | 188 | 3 |
64415 | 64415 | 2020-04-16 | Richmond city | Virginia | 51760 | 188 | 7 |
50800 | 50800 | 2020-04-11 | Alexandria city | Virginia | 51510 | 188 | 1 |
37879 | 37879 | 2020-04-06 | Loudoun | Virginia | 51107 | 188 | 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);