ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
493 rows where cases = 4 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Bath 51
- Bristol city 43
- Norton city 28
- Covington city 26
- Giles 26
- Tazewell 20
- Surry 19
- Craig 16
- Lunenburg 14
- Mathews 14
- Buena Vista city 12
- Floyd 12
- Powhatan 10
- Alleghany 8
- Greene 7
- Mecklenburg 7
- Northampton 7
- Pittsylvania 7
- Virginia Beach city 7
- Charles City 6
- Danville city 6
- Pulaski 6
- Middlesex 5
- Northumberland 5
- Patrick 5
- Fairfax 4
- Franklin city 4
- Galax city 4
- Greensville 4
- Radford city 4
- …
state 1
- Virginia · 493 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 540582 | 540582 | 2020-09-16 | Bath | Virginia | 51017 | 4 | 0 |
| 537345 | 537345 | 2020-09-15 | Bath | Virginia | 51017 | 4 | 0 |
| 534109 | 534109 | 2020-09-14 | Bath | Virginia | 51017 | 4 | 0 |
| 530874 | 530874 | 2020-09-13 | Bath | Virginia | 51017 | 4 | 0 |
| 527637 | 527637 | 2020-09-12 | Bath | Virginia | 51017 | 4 | 0 |
| 524401 | 524401 | 2020-09-11 | Bath | Virginia | 51017 | 4 | 0 |
| 521165 | 521165 | 2020-09-10 | Bath | Virginia | 51017 | 4 | 0 |
| 517928 | 517928 | 2020-09-09 | Bath | Virginia | 51017 | 4 | 0 |
| 514693 | 514693 | 2020-09-08 | Bath | Virginia | 51017 | 4 | 0 |
| 511460 | 511460 | 2020-09-07 | Bath | Virginia | 51017 | 4 | 0 |
| 508227 | 508227 | 2020-09-06 | Bath | Virginia | 51017 | 4 | 0 |
| 504995 | 504995 | 2020-09-05 | Bath | Virginia | 51017 | 4 | 0 |
| 501761 | 501761 | 2020-09-04 | Bath | Virginia | 51017 | 4 | 0 |
| 498527 | 498527 | 2020-09-03 | Bath | Virginia | 51017 | 4 | 0 |
| 495294 | 495294 | 2020-09-02 | Bath | Virginia | 51017 | 4 | 0 |
| 492060 | 492060 | 2020-09-01 | Bath | Virginia | 51017 | 4 | 0 |
| 488827 | 488827 | 2020-08-31 | Bath | Virginia | 51017 | 4 | 0 |
| 485594 | 485594 | 2020-08-30 | Bath | Virginia | 51017 | 4 | 0 |
| 482359 | 482359 | 2020-08-29 | Bath | Virginia | 51017 | 4 | 0 |
| 479125 | 479125 | 2020-08-28 | Bath | Virginia | 51017 | 4 | 0 |
| 475892 | 475892 | 2020-08-27 | Bath | Virginia | 51017 | 4 | 0 |
| 472659 | 472659 | 2020-08-26 | Bath | Virginia | 51017 | 4 | 0 |
| 469427 | 469427 | 2020-08-25 | Bath | Virginia | 51017 | 4 | 0 |
| 466198 | 466198 | 2020-08-24 | Bath | Virginia | 51017 | 4 | 0 |
| 462969 | 462969 | 2020-08-23 | Bath | Virginia | 51017 | 4 | 0 |
| 459740 | 459740 | 2020-08-22 | Bath | Virginia | 51017 | 4 | 0 |
| 456513 | 456513 | 2020-08-21 | Bath | Virginia | 51017 | 4 | 0 |
| 453285 | 453285 | 2020-08-20 | Bath | Virginia | 51017 | 4 | 0 |
| 450057 | 450057 | 2020-08-19 | Bath | Virginia | 51017 | 4 | 0 |
| 446829 | 446829 | 2020-08-18 | Bath | Virginia | 51017 | 4 | 0 |
| 443602 | 443602 | 2020-08-17 | Bath | Virginia | 51017 | 4 | 0 |
| 440376 | 440376 | 2020-08-16 | Bath | Virginia | 51017 | 4 | 0 |
| 437150 | 437150 | 2020-08-15 | Bath | Virginia | 51017 | 4 | 0 |
| 433924 | 433924 | 2020-08-14 | Bath | Virginia | 51017 | 4 | 0 |
| 430699 | 430699 | 2020-08-13 | Bath | Virginia | 51017 | 4 | 0 |
| 427471 | 427471 | 2020-08-12 | Bath | Virginia | 51017 | 4 | 0 |
| 424247 | 424247 | 2020-08-11 | Bath | Virginia | 51017 | 4 | 0 |
| 421026 | 421026 | 2020-08-10 | Bath | Virginia | 51017 | 4 | 0 |
| 417805 | 417805 | 2020-08-09 | Bath | Virginia | 51017 | 4 | 0 |
| 414584 | 414584 | 2020-08-08 | Bath | Virginia | 51017 | 4 | 0 |
| 411364 | 411364 | 2020-08-07 | Bath | Virginia | 51017 | 4 | 0 |
| 408145 | 408145 | 2020-08-06 | Bath | Virginia | 51017 | 4 | 0 |
| 408196 | 408196 | 2020-08-06 | Highland | Virginia | 51091 | 4 | 0 |
| 404925 | 404925 | 2020-08-05 | Bath | Virginia | 51017 | 4 | 0 |
| 404976 | 404976 | 2020-08-05 | Highland | Virginia | 51091 | 4 | 0 |
| 401707 | 401707 | 2020-08-04 | Bath | Virginia | 51017 | 4 | 0 |
| 401758 | 401758 | 2020-08-04 | Highland | Virginia | 51091 | 4 | 0 |
| 398491 | 398491 | 2020-08-03 | Bath | Virginia | 51017 | 4 | 0 |
| 395275 | 395275 | 2020-08-02 | Bath | Virginia | 51017 | 4 | 0 |
| 392059 | 392059 | 2020-08-01 | Bath | Virginia | 51017 | 4 | 0 |
| 388842 | 388842 | 2020-07-31 | Bath | Virginia | 51017 | 4 | 0 |
| 385625 | 385625 | 2020-07-30 | Bath | Virginia | 51017 | 4 | 0 |
| 382407 | 382407 | 2020-07-29 | Bath | Virginia | 51017 | 4 | 0 |
| 379190 | 379190 | 2020-07-28 | Bath | Virginia | 51017 | 4 | 0 |
| 350396 | 350396 | 2020-07-19 | Norton city | Virginia | 51720 | 4 | 0 |
| 347195 | 347195 | 2020-07-18 | Norton city | Virginia | 51720 | 4 | 0 |
| 343995 | 343995 | 2020-07-17 | Norton city | Virginia | 51720 | 4 | 0 |
| 340796 | 340796 | 2020-07-16 | Norton city | Virginia | 51720 | 4 | 0 |
| 337600 | 337600 | 2020-07-15 | Norton city | Virginia | 51720 | 4 | 0 |
| 334405 | 334405 | 2020-07-14 | Norton city | Virginia | 51720 | 4 | 0 |
| 331212 | 331212 | 2020-07-13 | Norton city | Virginia | 51720 | 4 | 0 |
| 328026 | 328026 | 2020-07-12 | Norton city | Virginia | 51720 | 4 | 0 |
| 324841 | 324841 | 2020-07-11 | Norton city | Virginia | 51720 | 4 | 0 |
| 321660 | 321660 | 2020-07-10 | Norton city | Virginia | 51720 | 4 | 0 |
| 318481 | 318481 | 2020-07-09 | Norton city | Virginia | 51720 | 4 | 0 |
| 315308 | 315308 | 2020-07-08 | Norton city | Virginia | 51720 | 4 | 0 |
| 312133 | 312133 | 2020-07-07 | Norton city | Virginia | 51720 | 4 | 0 |
| 308964 | 308964 | 2020-07-06 | Norton city | Virginia | 51720 | 4 | 0 |
| 305796 | 305796 | 2020-07-05 | Norton city | Virginia | 51720 | 4 | 0 |
| 302632 | 302632 | 2020-07-04 | Norton city | Virginia | 51720 | 4 | 0 |
| 299468 | 299468 | 2020-07-03 | Norton city | Virginia | 51720 | 4 | 0 |
| 296231 | 296231 | 2020-07-02 | Bristol city | Virginia | 51520 | 4 | 0 |
| 296306 | 296306 | 2020-07-02 | Norton city | Virginia | 51720 | 4 | 0 |
| 293076 | 293076 | 2020-07-01 | Bristol city | Virginia | 51520 | 4 | 0 |
| 293096 | 293096 | 2020-07-01 | Dickenson | Virginia | 51051 | 4 | 0 |
| 293151 | 293151 | 2020-07-01 | Norton city | Virginia | 51720 | 4 | 0 |
| 289923 | 289923 | 2020-06-30 | Bristol city | Virginia | 51520 | 4 | 0 |
| 289943 | 289943 | 2020-06-30 | Dickenson | Virginia | 51051 | 4 | 0 |
| 289998 | 289998 | 2020-06-30 | Norton city | Virginia | 51720 | 4 | 0 |
| 286773 | 286773 | 2020-06-29 | Bristol city | Virginia | 51520 | 4 | 0 |
| 286793 | 286793 | 2020-06-29 | Dickenson | Virginia | 51051 | 4 | 0 |
| 286848 | 286848 | 2020-06-29 | Norton city | Virginia | 51720 | 4 | 0 |
| 283627 | 283627 | 2020-06-28 | Bristol city | Virginia | 51520 | 4 | 0 |
| 283702 | 283702 | 2020-06-28 | Norton city | Virginia | 51720 | 4 | 0 |
| 280481 | 280481 | 2020-06-27 | Bristol city | Virginia | 51520 | 4 | 0 |
| 280556 | 280556 | 2020-06-27 | Norton city | Virginia | 51720 | 4 | 0 |
| 277333 | 277333 | 2020-06-26 | Bristol city | Virginia | 51520 | 4 | 0 |
| 277408 | 277408 | 2020-06-26 | Norton city | Virginia | 51720 | 4 | 0 |
| 274185 | 274185 | 2020-06-25 | Bristol city | Virginia | 51520 | 4 | 0 |
| 274260 | 274260 | 2020-06-25 | Norton city | Virginia | 51720 | 4 | 0 |
| 271045 | 271045 | 2020-06-24 | Bristol city | Virginia | 51520 | 4 | 0 |
| 271060 | 271060 | 2020-06-24 | Covington city | Virginia | 51580 | 4 | 0 |
| 271120 | 271120 | 2020-06-24 | Norton city | Virginia | 51720 | 4 | 0 |
| 267911 | 267911 | 2020-06-23 | Bristol city | Virginia | 51520 | 4 | 0 |
| 267926 | 267926 | 2020-06-23 | Covington city | Virginia | 51580 | 4 | 0 |
| 267986 | 267986 | 2020-06-23 | Norton city | Virginia | 51720 | 4 | 0 |
| 264782 | 264782 | 2020-06-22 | Bristol city | Virginia | 51520 | 4 | 0 |
| 264797 | 264797 | 2020-06-22 | Covington city | Virginia | 51580 | 4 | 0 |
| 264857 | 264857 | 2020-06-22 | Norton city | Virginia | 51720 | 4 | 0 |
| 261653 | 261653 | 2020-06-21 | Bristol city | Virginia | 51520 | 4 | 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);