ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 217 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 13
county 13
- Hampton city 6
- Shenandoah 6
- Arlington 2
- Frederick 2
- Henry 2
- Prince William 2
- Bedford 1
- Chesterfield 1
- Henrico 1
- Newport News city 1
- Norfolk city 1
- Portsmouth city 1
- Suffolk city 1
state 1
- Virginia · 27 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2268186 | 2268186 | 2022-03-02 | Bedford | Virginia | 51019 | 16457 | 217 |
2245531 | 2245531 | 2022-02-23 | Shenandoah | Virginia | 51171 | 10650 | 217 |
2242280 | 2242280 | 2022-02-22 | Shenandoah | Virginia | 51171 | 10641 | 217 |
2239029 | 2239029 | 2022-02-21 | Shenandoah | Virginia | 51171 | 10622 | 217 |
2235778 | 2235778 | 2022-02-20 | Shenandoah | Virginia | 51171 | 10577 | 217 |
2232527 | 2232527 | 2022-02-19 | Shenandoah | Virginia | 51171 | 10577 | 217 |
2229276 | 2229276 | 2022-02-18 | Shenandoah | Virginia | 51171 | 10577 | 217 |
2219455 | 2219455 | 2022-02-15 | Frederick | Virginia | 51069 | 19974 | 217 |
2216205 | 2216205 | 2022-02-14 | Frederick | Virginia | 51069 | 19929 | 217 |
2173931 | 2173931 | 2022-02-01 | Henry | Virginia | 51089 | 10299 | 217 |
2170679 | 2170679 | 2022-01-31 | Henry | Virginia | 51089 | 10281 | 217 |
1787106 | 1787106 | 2021-10-05 | Hampton city | Virginia | 51650 | 14419 | 217 |
1783857 | 1783857 | 2021-10-04 | Hampton city | Virginia | 51650 | 14397 | 217 |
1780608 | 1780608 | 2021-10-03 | Hampton city | Virginia | 51650 | 14279 | 217 |
1777358 | 1777358 | 2021-10-02 | Hampton city | Virginia | 51650 | 14279 | 217 |
1774108 | 1774108 | 2021-10-01 | Hampton city | Virginia | 51650 | 14279 | 217 |
1770858 | 1770858 | 2021-09-30 | Hampton city | Virginia | 51650 | 14238 | 217 |
1770922 | 1770922 | 2021-09-30 | Suffolk city | Virginia | 51800 | 10259 | 217 |
1741660 | 1741660 | 2021-09-21 | Portsmouth city | Virginia | 51740 | 11569 | 217 |
1218856 | 1218856 | 2021-04-13 | Newport News city | Virginia | 51700 | 13226 | 217 |
1098710 | 1098710 | 2021-03-07 | Norfolk city | Virginia | 51710 | 15155 | 217 |
1062928 | 1062928 | 2021-02-24 | Arlington | Virginia | 51013 | 12974 | 217 |
1059683 | 1059683 | 2021-02-23 | Arlington | Virginia | 51013 | 12922 | 217 |
1040225 | 1040225 | 2021-02-17 | Chesterfield | Virginia | 51041 | 22643 | 217 |
644401 | 644401 | 2020-10-18 | Prince William | Virginia | 51153 | 13556 | 217 |
641153 | 641153 | 2020-10-17 | Prince William | Virginia | 51153 | 13493 | 217 |
589223 | 589223 | 2020-10-01 | Henrico | Virginia | 51087 | 5501 | 217 |
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);