ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 223 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
state 1
- Virginia · 34 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2291052 | 2291052 | 2022-03-09 | Rockingham | Virginia | 51165 | 14395 | 223 |
2190166 | 2190166 | 2022-02-06 | Danville city | Virginia | 51590 | 10179 | 223 |
2186913 | 2186913 | 2022-02-05 | Danville city | Virginia | 51590 | 10179 | 223 |
2183660 | 2183660 | 2022-02-04 | Danville city | Virginia | 51590 | 10179 | 223 |
2180408 | 2180408 | 2022-02-03 | Danville city | Virginia | 51590 | 10122 | 223 |
2112131 | 2112131 | 2022-01-13 | Lynchburg city | Virginia | 51680 | 15285 | 223 |
1806664 | 1806664 | 2021-10-11 | Suffolk city | Virginia | 51800 | 10518 | 223 |
1803414 | 1803414 | 2021-10-10 | Suffolk city | Virginia | 51800 | 10518 | 223 |
1800165 | 1800165 | 2021-10-09 | Suffolk city | Virginia | 51800 | 10518 | 223 |
1796916 | 1796916 | 2021-10-08 | Suffolk city | Virginia | 51800 | 10518 | 223 |
1793667 | 1793667 | 2021-10-07 | Suffolk city | Virginia | 51800 | 10488 | 223 |
1790418 | 1790418 | 2021-10-06 | Suffolk city | Virginia | 51800 | 10461 | 223 |
1787147 | 1787147 | 2021-10-05 | Portsmouth city | Virginia | 51740 | 12064 | 223 |
1787170 | 1787170 | 2021-10-05 | Suffolk city | Virginia | 51800 | 10421 | 223 |
1783921 | 1783921 | 2021-10-04 | Suffolk city | Virginia | 51800 | 10372 | 223 |
1274059 | 1274059 | 2021-04-30 | Newport News city | Virginia | 51700 | 13740 | 223 |
1270812 | 1270812 | 2021-04-29 | Newport News city | Virginia | 51700 | 13705 | 223 |
1267565 | 1267565 | 2021-04-28 | Newport News city | Virginia | 51700 | 13678 | 223 |
1072664 | 1072664 | 2021-02-27 | Arlington | Virginia | 51013 | 13112 | 223 |
702789 | 702789 | 2020-11-05 | Prince William | Virginia | 51153 | 14923 | 223 |
699546 | 699546 | 2020-11-04 | Prince William | Virginia | 51153 | 14833 | 223 |
696302 | 696302 | 2020-11-03 | Prince William | Virginia | 51153 | 14768 | 223 |
693060 | 693060 | 2020-11-02 | Prince William | Virginia | 51153 | 14660 | 223 |
689816 | 689816 | 2020-11-01 | Prince William | Virginia | 51153 | 14554 | 223 |
686571 | 686571 | 2020-10-31 | Prince William | Virginia | 51153 | 14513 | 223 |
683328 | 683328 | 2020-10-30 | Prince William | Virginia | 51153 | 14447 | 223 |
680085 | 680085 | 2020-10-29 | Prince William | Virginia | 51153 | 14350 | 223 |
676842 | 676842 | 2020-10-28 | Prince William | Virginia | 51153 | 14235 | 223 |
673599 | 673599 | 2020-10-27 | Prince William | Virginia | 51153 | 14162 | 223 |
670357 | 670357 | 2020-10-26 | Prince William | Virginia | 51153 | 14015 | 223 |
667114 | 667114 | 2020-10-25 | Prince William | Virginia | 51153 | 13984 | 223 |
663869 | 663869 | 2020-10-24 | Prince William | Virginia | 51153 | 13949 | 223 |
660625 | 660625 | 2020-10-23 | Prince William | Virginia | 51153 | 13912 | 223 |
657381 | 657381 | 2020-10-22 | Prince William | Virginia | 51153 | 13832 | 223 |
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);