ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 568 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 21
county 21
- Fairfax city 9
- Middlesex 8
- Covington city 6
- Craig 4
- Carroll 2
- Fredericksburg city 2
- Galax city 2
- Amherst 1
- Bristol city 1
- Charlotte 1
- Cumberland 1
- Fauquier 1
- Franklin 1
- Hampton city 1
- Lancaster 1
- Manassas Park city 1
- Newport News city 1
- Norton city 1
- Prince Edward 1
- Sussex 1
- Winchester city 1
state 1
- Virginia · 47 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1917051 | 1917051 | 2021-11-14 | Craig | Virginia | 51045 | 568 | 9 |
1913801 | 1913801 | 2021-11-13 | Craig | Virginia | 51045 | 568 | 9 |
1910551 | 1910551 | 2021-11-12 | Craig | Virginia | 51045 | 568 | 9 |
1907302 | 1907302 | 2021-11-11 | Craig | Virginia | 51045 | 568 | 9 |
1858620 | 1858620 | 2021-10-27 | Norton city | Virginia | 51720 | 568 | 13 |
1653885 | 1653885 | 2021-08-25 | Cumberland | Virginia | 51049 | 568 | 10 |
1562934 | 1562934 | 2021-07-28 | Fairfax city | Virginia | 51600 | 568 | 19 |
1559686 | 1559686 | 2021-07-27 | Fairfax city | Virginia | 51600 | 568 | 19 |
1556439 | 1556439 | 2021-07-26 | Fairfax city | Virginia | 51600 | 568 | 19 |
1536956 | 1536956 | 2021-07-20 | Fairfax city | Virginia | 51600 | 568 | 19 |
1533708 | 1533708 | 2021-07-19 | Fairfax city | Virginia | 51600 | 568 | 19 |
1436322 | 1436322 | 2021-06-19 | Fairfax city | Virginia | 51600 | 568 | 20 |
1433075 | 1433075 | 2021-06-18 | Fairfax city | Virginia | 51600 | 568 | 20 |
1429829 | 1429829 | 2021-06-17 | Fairfax city | Virginia | 51600 | 568 | 20 |
1377901 | 1377901 | 2021-06-01 | Fairfax city | Virginia | 51600 | 568 | 19 |
1270808 | 1270808 | 2021-04-29 | Middlesex | Virginia | 51119 | 568 | 20 |
1267561 | 1267561 | 2021-04-28 | Middlesex | Virginia | 51119 | 568 | 20 |
1264314 | 1264314 | 2021-04-27 | Middlesex | Virginia | 51119 | 568 | 20 |
1261067 | 1261067 | 2021-04-26 | Middlesex | Virginia | 51119 | 568 | 20 |
1257820 | 1257820 | 2021-04-25 | Middlesex | Virginia | 51119 | 568 | 20 |
1254573 | 1254573 | 2021-04-24 | Middlesex | Virginia | 51119 | 568 | 20 |
1251326 | 1251326 | 2021-04-23 | Middlesex | Virginia | 51119 | 568 | 20 |
1248079 | 1248079 | 2021-04-22 | Middlesex | Virginia | 51119 | 568 | 20 |
1173330 | 1173330 | 2021-03-30 | Covington city | Virginia | 51580 | 568 | 12 |
1170083 | 1170083 | 2021-03-29 | Covington city | Virginia | 51580 | 568 | 12 |
1166835 | 1166835 | 2021-03-28 | Covington city | Virginia | 51580 | 568 | 12 |
1163587 | 1163587 | 2021-03-27 | Covington city | Virginia | 51580 | 568 | 12 |
1160339 | 1160339 | 2021-03-26 | Covington city | Virginia | 51580 | 568 | 12 |
1150597 | 1150597 | 2021-03-23 | Covington city | Virginia | 51580 | 568 | 12 |
988337 | 988337 | 2021-02-01 | Lancaster | Virginia | 51103 | 568 | 4 |
959083 | 959083 | 2021-01-23 | Charlotte | Virginia | 51037 | 568 | 10 |
793559 | 793559 | 2020-12-03 | Bristol city | Virginia | 51520 | 568 | 7 |
780614 | 780614 | 2020-11-29 | Galax city | Virginia | 51640 | 568 | 30 |
777368 | 777368 | 2020-11-28 | Galax city | Virginia | 51640 | 568 | 30 |
663774 | 663774 | 2020-10-24 | Amherst | Virginia | 51009 | 568 | 4 |
654056 | 654056 | 2020-10-21 | Carroll | Virginia | 51035 | 568 | 27 |
650811 | 650811 | 2020-10-20 | Carroll | Virginia | 51035 | 568 | 27 |
650920 | 650920 | 2020-10-20 | Winchester city | Virginia | 51840 | 568 | 4 |
634607 | 634607 | 2020-10-15 | Fredericksburg city | Virginia | 51630 | 568 | 5 |
631359 | 631359 | 2020-10-14 | Franklin | Virginia | 51067 | 568 | 4 |
628118 | 628118 | 2020-10-13 | Fredericksburg city | Virginia | 51630 | 568 | 5 |
592526 | 592526 | 2020-10-02 | Sussex | Virginia | 51183 | 568 | 12 |
563334 | 563334 | 2020-09-23 | Prince Edward | Virginia | 51147 | 568 | 12 |
492126 | 492126 | 2020-09-01 | Manassas Park city | Virginia | 51685 | 568 | 7 |
379221 | 379221 | 2020-07-28 | Fauquier | Virginia | 51061 | 568 | 8 |
334372 | 334372 | 2020-07-14 | Hampton city | Virginia | 51650 | 568 | 4 |
302628 | 302628 | 2020-07-04 | Newport News city | Virginia | 51700 | 568 | 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);