ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 642 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 16
county 16
- King and Queen 4
- Mathews 3
- Emporia city 2
- Lunenburg 2
- Manassas Park city 2
- Amherst 1
- Charles City 1
- Dickenson 1
- Fairfax city 1
- Fauquier 1
- Floyd 1
- Lancaster 1
- Mecklenburg 1
- Northampton 1
- Petersburg city 1
- Stafford 1
state 1
- Virginia · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1894340 | 1894340 | 2021-11-07 | King and Queen | Virginia | 51097 | 642 | 8 |
1891090 | 1891090 | 2021-11-06 | King and Queen | Virginia | 51097 | 642 | 8 |
1887840 | 1887840 | 2021-11-05 | King and Queen | Virginia | 51097 | 642 | 8 |
1884590 | 1884590 | 2021-11-04 | King and Queen | Virginia | 51097 | 642 | 8 |
1816330 | 1816330 | 2021-10-14 | Fairfax city | Virginia | 51600 | 642 | 20 |
1764326 | 1764326 | 2021-09-28 | Charles City | Virginia | 51036 | 642 | 19 |
1621449 | 1621449 | 2021-08-15 | Mathews | Virginia | 51115 | 642 | 14 |
1618201 | 1618201 | 2021-08-14 | Mathews | Virginia | 51115 | 642 | 14 |
1614953 | 1614953 | 2021-08-13 | Mathews | Virginia | 51115 | 642 | 14 |
1150604 | 1150604 | 2021-03-23 | Emporia city | Virginia | 51595 | 642 | 41 |
1147357 | 1147357 | 2021-03-22 | Emporia city | Virginia | 51595 | 642 | 41 |
1075975 | 1075975 | 2021-02-28 | Lunenburg | Virginia | 51111 | 642 | 5 |
1072729 | 1072729 | 2021-02-27 | Lunenburg | Virginia | 51111 | 642 | 5 |
1053251 | 1053251 | 2021-02-21 | Lancaster | Virginia | 51103 | 642 | 6 |
991602 | 991602 | 2021-02-02 | Northampton | Virginia | 51131 | 642 | 33 |
949366 | 949366 | 2021-01-20 | Floyd | Virginia | 51063 | 642 | 18 |
887694 | 887694 | 2021-01-01 | Dickenson | Virginia | 51051 | 642 | 6 |
705937 | 705937 | 2020-11-06 | Amherst | Virginia | 51009 | 642 | 6 |
670332 | 670332 | 2020-10-26 | Manassas Park city | Virginia | 51685 | 642 | 8 |
667089 | 667089 | 2020-10-25 | Manassas Park city | Virginia | 51685 | 642 | 8 |
540652 | 540652 | 2020-09-16 | Mecklenburg | Virginia | 51117 | 642 | 33 |
498611 | 498611 | 2020-09-03 | Petersburg city | Virginia | 51730 | 642 | 23 |
443633 | 443633 | 2020-08-17 | Fauquier | Virginia | 51061 | 642 | 9 |
181341 | 181341 | 2020-05-26 | Stafford | Virginia | 51179 | 642 | 4 |
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);