ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 51640 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283661 | 283661 | 2020-06-28 | Galax city | Virginia | 51640 | 252 | 13 |
280515 | 280515 | 2020-06-27 | Galax city | Virginia | 51640 | 244 | 13 |
277367 | 277367 | 2020-06-26 | Galax city | Virginia | 51640 | 243 | 13 |
274219 | 274219 | 2020-06-25 | Galax city | Virginia | 51640 | 238 | 13 |
271079 | 271079 | 2020-06-24 | Galax city | Virginia | 51640 | 233 | 13 |
267945 | 267945 | 2020-06-23 | Galax city | Virginia | 51640 | 227 | 11 |
264816 | 264816 | 2020-06-22 | Galax city | Virginia | 51640 | 224 | 11 |
261687 | 261687 | 2020-06-21 | Galax city | Virginia | 51640 | 223 | 11 |
258560 | 258560 | 2020-06-20 | Galax city | Virginia | 51640 | 222 | 11 |
255433 | 255433 | 2020-06-19 | Galax city | Virginia | 51640 | 217 | 11 |
252314 | 252314 | 2020-06-18 | Galax city | Virginia | 51640 | 211 | 11 |
249199 | 249199 | 2020-06-17 | Galax city | Virginia | 51640 | 208 | 11 |
246087 | 246087 | 2020-06-16 | Galax city | Virginia | 51640 | 206 | 10 |
242974 | 242974 | 2020-06-15 | Galax city | Virginia | 51640 | 205 | 10 |
239863 | 239863 | 2020-06-14 | Galax city | Virginia | 51640 | 204 | 10 |
236755 | 236755 | 2020-06-13 | Galax city | Virginia | 51640 | 193 | 8 |
233648 | 233648 | 2020-06-12 | Galax city | Virginia | 51640 | 171 | 8 |
230543 | 230543 | 2020-06-11 | Galax city | Virginia | 51640 | 165 | 7 |
227439 | 227439 | 2020-06-10 | Galax city | Virginia | 51640 | 154 | 6 |
224339 | 224339 | 2020-06-09 | Galax city | Virginia | 51640 | 148 | 1 |
221243 | 221243 | 2020-06-08 | Galax city | Virginia | 51640 | 147 | 1 |
218151 | 218151 | 2020-06-07 | Galax city | Virginia | 51640 | 147 | 1 |
215061 | 215061 | 2020-06-06 | Galax city | Virginia | 51640 | 143 | 1 |
211974 | 211974 | 2020-06-05 | Galax city | Virginia | 51640 | 140 | 1 |
208889 | 208889 | 2020-06-04 | Galax city | Virginia | 51640 | 140 | 1 |
205807 | 205807 | 2020-06-03 | Galax city | Virginia | 51640 | 131 | 1 |
202728 | 202728 | 2020-06-02 | Galax city | Virginia | 51640 | 127 | 0 |
199652 | 199652 | 2020-06-01 | Galax city | Virginia | 51640 | 124 | 0 |
196579 | 196579 | 2020-05-31 | Galax city | Virginia | 51640 | 123 | 0 |
193509 | 193509 | 2020-05-30 | Galax city | Virginia | 51640 | 112 | 0 |
190443 | 190443 | 2020-05-29 | Galax city | Virginia | 51640 | 107 | 0 |
187379 | 187379 | 2020-05-28 | Galax city | Virginia | 51640 | 107 | 0 |
184322 | 184322 | 2020-05-27 | Galax city | Virginia | 51640 | 106 | 0 |
181271 | 181271 | 2020-05-26 | Galax city | Virginia | 51640 | 104 | 0 |
178227 | 178227 | 2020-05-25 | Galax city | Virginia | 51640 | 95 | 0 |
175182 | 175182 | 2020-05-24 | Galax city | Virginia | 51640 | 88 | 0 |
172139 | 172139 | 2020-05-23 | Galax city | Virginia | 51640 | 87 | 0 |
169098 | 169098 | 2020-05-22 | Galax city | Virginia | 51640 | 85 | 0 |
166062 | 166062 | 2020-05-21 | Galax city | Virginia | 51640 | 82 | 0 |
163033 | 163033 | 2020-05-20 | Galax city | Virginia | 51640 | 82 | 0 |
160005 | 160005 | 2020-05-19 | Galax city | Virginia | 51640 | 82 | 0 |
156981 | 156981 | 2020-05-18 | Galax city | Virginia | 51640 | 82 | 0 |
153964 | 153964 | 2020-05-17 | Galax city | Virginia | 51640 | 80 | 0 |
150953 | 150953 | 2020-05-16 | Galax city | Virginia | 51640 | 77 | 0 |
147944 | 147944 | 2020-05-15 | Galax city | Virginia | 51640 | 66 | 0 |
144941 | 144941 | 2020-05-14 | Galax city | Virginia | 51640 | 65 | 0 |
141944 | 141944 | 2020-05-13 | Galax city | Virginia | 51640 | 64 | 0 |
138948 | 138948 | 2020-05-12 | Galax city | Virginia | 51640 | 56 | 0 |
135957 | 135957 | 2020-05-11 | Galax city | Virginia | 51640 | 55 | 0 |
132967 | 132967 | 2020-05-10 | Galax city | Virginia | 51640 | 45 | 0 |
129977 | 129977 | 2020-05-09 | Galax city | Virginia | 51640 | 34 | 0 |
126987 | 126987 | 2020-05-08 | Galax city | Virginia | 51640 | 33 | 0 |
124002 | 124002 | 2020-05-07 | Galax city | Virginia | 51640 | 32 | 0 |
121021 | 121021 | 2020-05-06 | Galax city | Virginia | 51640 | 25 | 0 |
118057 | 118057 | 2020-05-05 | Galax city | Virginia | 51640 | 25 | 0 |
115098 | 115098 | 2020-05-04 | Galax city | Virginia | 51640 | 25 | 0 |
112215 | 112215 | 2020-05-03 | Galax city | Virginia | 51640 | 12 | 0 |
109341 | 109341 | 2020-05-02 | Galax city | Virginia | 51640 | 10 | 0 |
106472 | 106472 | 2020-05-01 | Galax city | Virginia | 51640 | 9 | 0 |
103608 | 103608 | 2020-04-30 | Galax city | Virginia | 51640 | 4 | 0 |
100753 | 100753 | 2020-04-29 | Galax city | Virginia | 51640 | 4 | 0 |
97903 | 97903 | 2020-04-28 | Galax city | Virginia | 51640 | 4 | 0 |
95061 | 95061 | 2020-04-27 | Galax city | Virginia | 51640 | 3 | 0 |
92232 | 92232 | 2020-04-26 | Galax city | Virginia | 51640 | 4 | 0 |
89415 | 89415 | 2020-04-25 | Galax city | Virginia | 51640 | 1 | 0 |
86600 | 86600 | 2020-04-24 | Galax city | Virginia | 51640 | 1 | 0 |
83793 | 83793 | 2020-04-23 | Galax city | Virginia | 51640 | 1 | 0 |
80992 | 80992 | 2020-04-22 | Galax city | Virginia | 51640 | 1 | 0 |
78200 | 78200 | 2020-04-21 | Galax city | Virginia | 51640 | 1 | 0 |
75418 | 75418 | 2020-04-20 | Galax city | Virginia | 51640 | 1 | 0 |
72642 | 72642 | 2020-04-19 | Galax city | Virginia | 51640 | 1 | 0 |
69872 | 69872 | 2020-04-18 | Galax city | Virginia | 51640 | 1 | 0 |
67110 | 67110 | 2020-04-17 | Galax city | Virginia | 51640 | 1 | 0 |
64362 | 64362 | 2020-04-16 | Galax city | Virginia | 51640 | 1 | 0 |
61629 | 61629 | 2020-04-15 | Galax city | Virginia | 51640 | 1 | 0 |
58910 | 58910 | 2020-04-14 | Galax city | Virginia | 51640 | 1 | 0 |
56204 | 56204 | 2020-04-13 | Galax city | Virginia | 51640 | 1 | 0 |
53514 | 53514 | 2020-04-12 | Galax city | Virginia | 51640 | 1 | 0 |
50839 | 50839 | 2020-04-11 | Galax city | Virginia | 51640 | 1 | 0 |
48181 | 48181 | 2020-04-10 | Galax city | Virginia | 51640 | 1 | 0 |
45555 | 45555 | 2020-04-09 | Galax city | Virginia | 51640 | 1 | 0 |
42960 | 42960 | 2020-04-08 | Galax city | Virginia | 51640 | 1 | 0 |
40391 | 40391 | 2020-04-07 | Galax city | Virginia | 51640 | 1 | 0 |
37858 | 37858 | 2020-04-06 | Galax city | Virginia | 51640 | 1 | 0 |
35376 | 35376 | 2020-04-05 | Galax city | Virginia | 51640 | 1 | 0 |
32938 | 32938 | 2020-04-04 | Galax city | Virginia | 51640 | 1 | 0 |
30539 | 30539 | 2020-04-03 | Galax city | Virginia | 51640 | 1 | 0 |
28193 | 28193 | 2020-04-02 | Galax city | Virginia | 51640 | 1 | 0 |
25903 | 25903 | 2020-04-01 | Galax city | Virginia | 51640 | 1 | 0 |
23687 | 23687 | 2020-03-31 | Galax city | Virginia | 51640 | 1 | 0 |
21542 | 21542 | 2020-03-30 | Galax city | Virginia | 51640 | 1 | 0 |
19479 | 19479 | 2020-03-29 | Galax city | Virginia | 51640 | 1 | 0 |
17519 | 17519 | 2020-03-28 | Galax city | Virginia | 51640 | 1 | 0 |
15645 | 15645 | 2020-03-27 | Galax city | Virginia | 51640 | 1 | 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);