ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,723 rows where deaths = 0 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 51091 315
- 51720 245
- 51071 239
- 51115 237
- 51045 231
- 51103 206
- 51017 201
- 51037 199
- 51580 199
- 51790 197
- 51043 183
- 51750 177
- 51125 174
- 51049 166
- 51735 165
- 51678 154
- 51185 150
- 51520 143
- 51009 138
- 51011 138
- 51163 136
- 51105 131
- 51027 126
- 51530 123
- 51630 116
- 51111 114
- 51167 109
- 51820 109
- 51119 102
- 51057 100
- …
county >30
- Highland 315
- Norton city 245
- Giles 239
- Mathews 237
- Craig 231
- Lancaster 206
- Bath 201
- Charlotte 199
- Covington city 199
- Staunton city 197
- Clarke 183
- Radford city 177
- Nelson 174
- Cumberland 166
- Poquoson city 165
- Lexington city 154
- Tazewell 150
- Bristol city 143
- Amherst 138
- Appomattox 138
- Rockbridge 136
- Lee 131
- Buchanan 126
- Buena Vista city 123
- Fredericksburg city 116
- Lunenburg 114
- Russell 109
- Waynesboro city 109
- Middlesex 102
- Essex 100
- …
state 1
- Virginia · 8,723 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447264 | 2447264 | 2022-04-26 | Unknown | Virginia | 151 | 0 | |
2336604 | 2336604 | 2022-03-23 | Unknown | Virginia | 97 | 0 | |
1082454 | 1082454 | 2021-03-02 | Highland | Virginia | 51091 | 91 | 0 |
1079208 | 1079208 | 2021-03-01 | Highland | Virginia | 51091 | 91 | 0 |
1075963 | 1075963 | 2021-02-28 | Highland | Virginia | 51091 | 91 | 0 |
1072717 | 1072717 | 2021-02-27 | Highland | Virginia | 51091 | 91 | 0 |
1069471 | 1069471 | 2021-02-26 | Highland | Virginia | 51091 | 91 | 0 |
1066226 | 1066226 | 2021-02-25 | Highland | Virginia | 51091 | 89 | 0 |
1062981 | 1062981 | 2021-02-24 | Highland | Virginia | 51091 | 89 | 0 |
1059736 | 1059736 | 2021-02-23 | Highland | Virginia | 51091 | 90 | 0 |
1056490 | 1056490 | 2021-02-22 | Highland | Virginia | 51091 | 90 | 0 |
1053244 | 1053244 | 2021-02-21 | Highland | Virginia | 51091 | 90 | 0 |
1049997 | 1049997 | 2021-02-20 | Highland | Virginia | 51091 | 89 | 0 |
1046750 | 1046750 | 2021-02-19 | Highland | Virginia | 51091 | 89 | 0 |
1043505 | 1043505 | 2021-02-18 | Highland | Virginia | 51091 | 87 | 0 |
1040260 | 1040260 | 2021-02-17 | Highland | Virginia | 51091 | 87 | 0 |
1037015 | 1037015 | 2021-02-16 | Highland | Virginia | 51091 | 87 | 0 |
1033770 | 1033770 | 2021-02-15 | Highland | Virginia | 51091 | 87 | 0 |
1030524 | 1030524 | 2021-02-14 | Highland | Virginia | 51091 | 87 | 0 |
1027277 | 1027277 | 2021-02-13 | Highland | Virginia | 51091 | 87 | 0 |
1024032 | 1024032 | 2021-02-12 | Highland | Virginia | 51091 | 86 | 0 |
1020787 | 1020787 | 2021-02-11 | Highland | Virginia | 51091 | 86 | 0 |
1017542 | 1017542 | 2021-02-10 | Highland | Virginia | 51091 | 87 | 0 |
1014297 | 1014297 | 2021-02-09 | Highland | Virginia | 51091 | 88 | 0 |
1011052 | 1011052 | 2021-02-08 | Highland | Virginia | 51091 | 86 | 0 |
1007806 | 1007806 | 2021-02-07 | Highland | Virginia | 51091 | 86 | 0 |
1004560 | 1004560 | 2021-02-06 | Highland | Virginia | 51091 | 86 | 0 |
1001314 | 1001314 | 2021-02-05 | Highland | Virginia | 51091 | 85 | 0 |
998068 | 998068 | 2021-02-04 | Highland | Virginia | 51091 | 84 | 0 |
994822 | 994822 | 2021-02-03 | Highland | Virginia | 51091 | 84 | 0 |
991576 | 991576 | 2021-02-02 | Highland | Virginia | 51091 | 84 | 0 |
988330 | 988330 | 2021-02-01 | Highland | Virginia | 51091 | 83 | 0 |
985083 | 985083 | 2021-01-31 | Highland | Virginia | 51091 | 81 | 0 |
981785 | 981785 | 2021-01-30 | Bath | Virginia | 51017 | 241 | 0 |
981836 | 981836 | 2021-01-30 | Highland | Virginia | 51091 | 81 | 0 |
978539 | 978539 | 2021-01-29 | Bath | Virginia | 51017 | 241 | 0 |
978590 | 978590 | 2021-01-29 | Highland | Virginia | 51091 | 78 | 0 |
975294 | 975294 | 2021-01-28 | Bath | Virginia | 51017 | 239 | 0 |
975345 | 975345 | 2021-01-28 | Highland | Virginia | 51091 | 78 | 0 |
972049 | 972049 | 2021-01-27 | Bath | Virginia | 51017 | 237 | 0 |
972100 | 972100 | 2021-01-27 | Highland | Virginia | 51091 | 78 | 0 |
968804 | 968804 | 2021-01-26 | Bath | Virginia | 51017 | 238 | 0 |
968855 | 968855 | 2021-01-26 | Highland | Virginia | 51091 | 77 | 0 |
965560 | 965560 | 2021-01-25 | Bath | Virginia | 51017 | 240 | 0 |
965611 | 965611 | 2021-01-25 | Highland | Virginia | 51091 | 76 | 0 |
962315 | 962315 | 2021-01-24 | Bath | Virginia | 51017 | 239 | 0 |
962366 | 962366 | 2021-01-24 | Highland | Virginia | 51091 | 73 | 0 |
959070 | 959070 | 2021-01-23 | Bath | Virginia | 51017 | 236 | 0 |
959121 | 959121 | 2021-01-23 | Highland | Virginia | 51091 | 72 | 0 |
955824 | 955824 | 2021-01-22 | Bath | Virginia | 51017 | 236 | 0 |
955875 | 955875 | 2021-01-22 | Highland | Virginia | 51091 | 72 | 0 |
952579 | 952579 | 2021-01-21 | Bath | Virginia | 51017 | 236 | 0 |
952630 | 952630 | 2021-01-21 | Highland | Virginia | 51091 | 71 | 0 |
949334 | 949334 | 2021-01-20 | Bath | Virginia | 51017 | 236 | 0 |
949385 | 949385 | 2021-01-20 | Highland | Virginia | 51091 | 71 | 0 |
946088 | 946088 | 2021-01-19 | Bath | Virginia | 51017 | 232 | 0 |
946139 | 946139 | 2021-01-19 | Highland | Virginia | 51091 | 69 | 0 |
942841 | 942841 | 2021-01-18 | Bath | Virginia | 51017 | 231 | 0 |
942892 | 942892 | 2021-01-18 | Highland | Virginia | 51091 | 67 | 0 |
939596 | 939596 | 2021-01-17 | Bath | Virginia | 51017 | 229 | 0 |
939647 | 939647 | 2021-01-17 | Highland | Virginia | 51091 | 67 | 0 |
936351 | 936351 | 2021-01-16 | Bath | Virginia | 51017 | 226 | 0 |
936402 | 936402 | 2021-01-16 | Highland | Virginia | 51091 | 63 | 0 |
933106 | 933106 | 2021-01-15 | Bath | Virginia | 51017 | 217 | 0 |
933157 | 933157 | 2021-01-15 | Highland | Virginia | 51091 | 62 | 0 |
929861 | 929861 | 2021-01-14 | Bath | Virginia | 51017 | 219 | 0 |
929912 | 929912 | 2021-01-14 | Highland | Virginia | 51091 | 62 | 0 |
926616 | 926616 | 2021-01-13 | Bath | Virginia | 51017 | 215 | 0 |
926667 | 926667 | 2021-01-13 | Highland | Virginia | 51091 | 62 | 0 |
923370 | 923370 | 2021-01-12 | Bath | Virginia | 51017 | 212 | 0 |
923421 | 923421 | 2021-01-12 | Highland | Virginia | 51091 | 62 | 0 |
920125 | 920125 | 2021-01-11 | Bath | Virginia | 51017 | 209 | 0 |
920176 | 920176 | 2021-01-11 | Highland | Virginia | 51091 | 62 | 0 |
916880 | 916880 | 2021-01-10 | Bath | Virginia | 51017 | 208 | 0 |
916931 | 916931 | 2021-01-10 | Highland | Virginia | 51091 | 62 | 0 |
913635 | 913635 | 2021-01-09 | Bath | Virginia | 51017 | 204 | 0 |
913686 | 913686 | 2021-01-09 | Highland | Virginia | 51091 | 59 | 0 |
910390 | 910390 | 2021-01-08 | Bath | Virginia | 51017 | 201 | 0 |
910441 | 910441 | 2021-01-08 | Highland | Virginia | 51091 | 59 | 0 |
907145 | 907145 | 2021-01-07 | Bath | Virginia | 51017 | 202 | 0 |
907196 | 907196 | 2021-01-07 | Highland | Virginia | 51091 | 58 | 0 |
903899 | 903899 | 2021-01-06 | Bath | Virginia | 51017 | 199 | 0 |
903950 | 903950 | 2021-01-06 | Highland | Virginia | 51091 | 57 | 0 |
900654 | 900654 | 2021-01-05 | Bath | Virginia | 51017 | 192 | 0 |
900705 | 900705 | 2021-01-05 | Highland | Virginia | 51091 | 57 | 0 |
897409 | 897409 | 2021-01-04 | Bath | Virginia | 51017 | 189 | 0 |
897460 | 897460 | 2021-01-04 | Highland | Virginia | 51091 | 57 | 0 |
894163 | 894163 | 2021-01-03 | Bath | Virginia | 51017 | 187 | 0 |
894214 | 894214 | 2021-01-03 | Highland | Virginia | 51091 | 57 | 0 |
890917 | 890917 | 2021-01-02 | Bath | Virginia | 51017 | 175 | 0 |
890968 | 890968 | 2021-01-02 | Highland | Virginia | 51091 | 57 | 0 |
887670 | 887670 | 2021-01-01 | Bath | Virginia | 51017 | 168 | 0 |
887721 | 887721 | 2021-01-01 | Highland | Virginia | 51091 | 57 | 0 |
884425 | 884425 | 2020-12-31 | Bath | Virginia | 51017 | 153 | 0 |
884476 | 884476 | 2020-12-31 | Highland | Virginia | 51091 | 57 | 0 |
881180 | 881180 | 2020-12-30 | Bath | Virginia | 51017 | 146 | 0 |
881231 | 881231 | 2020-12-30 | Highland | Virginia | 51091 | 57 | 0 |
877935 | 877935 | 2020-12-29 | Bath | Virginia | 51017 | 139 | 0 |
877986 | 877986 | 2020-12-29 | Highland | Virginia | 51091 | 57 | 0 |
874690 | 874690 | 2020-12-28 | Bath | Virginia | 51017 | 138 | 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);