ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Henry" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388892 | 388892 | 2020-07-31 | Henry | Virginia | 51089 | 477 | 5 |
385675 | 385675 | 2020-07-30 | Henry | Virginia | 51089 | 467 | 5 |
382457 | 382457 | 2020-07-29 | Henry | Virginia | 51089 | 461 | 5 |
379240 | 379240 | 2020-07-28 | Henry | Virginia | 51089 | 458 | 5 |
376024 | 376024 | 2020-07-27 | Henry | Virginia | 51089 | 434 | 5 |
372810 | 372810 | 2020-07-26 | Henry | Virginia | 51089 | 434 | 5 |
369598 | 369598 | 2020-07-25 | Henry | Virginia | 51089 | 429 | 5 |
366389 | 366389 | 2020-07-24 | Henry | Virginia | 51089 | 424 | 5 |
363183 | 363183 | 2020-07-23 | Henry | Virginia | 51089 | 422 | 5 |
359977 | 359977 | 2020-07-22 | Henry | Virginia | 51089 | 413 | 5 |
356772 | 356772 | 2020-07-21 | Henry | Virginia | 51089 | 410 | 5 |
353569 | 353569 | 2020-07-20 | Henry | Virginia | 51089 | 393 | 5 |
350367 | 350367 | 2020-07-19 | Henry | Virginia | 51089 | 393 | 5 |
347166 | 347166 | 2020-07-18 | Henry | Virginia | 51089 | 393 | 5 |
343966 | 343966 | 2020-07-17 | Henry | Virginia | 51089 | 391 | 5 |
340767 | 340767 | 2020-07-16 | Henry | Virginia | 51089 | 387 | 5 |
337571 | 337571 | 2020-07-15 | Henry | Virginia | 51089 | 381 | 5 |
334376 | 334376 | 2020-07-14 | Henry | Virginia | 51089 | 363 | 5 |
331183 | 331183 | 2020-07-13 | Henry | Virginia | 51089 | 350 | 5 |
327997 | 327997 | 2020-07-12 | Henry | Virginia | 51089 | 350 | 5 |
324812 | 324812 | 2020-07-11 | Henry | Virginia | 51089 | 350 | 5 |
321631 | 321631 | 2020-07-10 | Henry | Virginia | 51089 | 339 | 5 |
318452 | 318452 | 2020-07-09 | Henry | Virginia | 51089 | 330 | 5 |
315279 | 315279 | 2020-07-08 | Henry | Virginia | 51089 | 315 | 5 |
312104 | 312104 | 2020-07-07 | Henry | Virginia | 51089 | 301 | 5 |
308935 | 308935 | 2020-07-06 | Henry | Virginia | 51089 | 293 | 4 |
305767 | 305767 | 2020-07-05 | Henry | Virginia | 51089 | 288 | 4 |
302603 | 302603 | 2020-07-04 | Henry | Virginia | 51089 | 284 | 4 |
299439 | 299439 | 2020-07-03 | Henry | Virginia | 51089 | 280 | 4 |
296277 | 296277 | 2020-07-02 | Henry | Virginia | 51089 | 273 | 4 |
293122 | 293122 | 2020-07-01 | Henry | Virginia | 51089 | 264 | 4 |
289969 | 289969 | 2020-06-30 | Henry | Virginia | 51089 | 260 | 4 |
286819 | 286819 | 2020-06-29 | Henry | Virginia | 51089 | 250 | 4 |
283673 | 283673 | 2020-06-28 | Henry | Virginia | 51089 | 249 | 4 |
280527 | 280527 | 2020-06-27 | Henry | Virginia | 51089 | 243 | 4 |
277379 | 277379 | 2020-06-26 | Henry | Virginia | 51089 | 237 | 4 |
274231 | 274231 | 2020-06-25 | Henry | Virginia | 51089 | 232 | 4 |
271091 | 271091 | 2020-06-24 | Henry | Virginia | 51089 | 230 | 4 |
267957 | 267957 | 2020-06-23 | Henry | Virginia | 51089 | 228 | 4 |
264828 | 264828 | 2020-06-22 | Henry | Virginia | 51089 | 227 | 3 |
261699 | 261699 | 2020-06-21 | Henry | Virginia | 51089 | 226 | 3 |
258572 | 258572 | 2020-06-20 | Henry | Virginia | 51089 | 227 | 3 |
255445 | 255445 | 2020-06-19 | Henry | Virginia | 51089 | 224 | 3 |
252326 | 252326 | 2020-06-18 | Henry | Virginia | 51089 | 214 | 3 |
249211 | 249211 | 2020-06-17 | Henry | Virginia | 51089 | 212 | 3 |
246099 | 246099 | 2020-06-16 | Henry | Virginia | 51089 | 210 | 3 |
242986 | 242986 | 2020-06-15 | Henry | Virginia | 51089 | 202 | 3 |
239875 | 239875 | 2020-06-14 | Henry | Virginia | 51089 | 199 | 3 |
236767 | 236767 | 2020-06-13 | Henry | Virginia | 51089 | 198 | 3 |
233660 | 233660 | 2020-06-12 | Henry | Virginia | 51089 | 193 | 3 |
230555 | 230555 | 2020-06-11 | Henry | Virginia | 51089 | 188 | 3 |
227451 | 227451 | 2020-06-10 | Henry | Virginia | 51089 | 182 | 3 |
224351 | 224351 | 2020-06-09 | Henry | Virginia | 51089 | 174 | 3 |
221255 | 221255 | 2020-06-08 | Henry | Virginia | 51089 | 169 | 3 |
218163 | 218163 | 2020-06-07 | Henry | Virginia | 51089 | 166 | 3 |
215073 | 215073 | 2020-06-06 | Henry | Virginia | 51089 | 159 | 3 |
211986 | 211986 | 2020-06-05 | Henry | Virginia | 51089 | 155 | 3 |
208901 | 208901 | 2020-06-04 | Henry | Virginia | 51089 | 152 | 3 |
205819 | 205819 | 2020-06-03 | Henry | Virginia | 51089 | 145 | 3 |
202740 | 202740 | 2020-06-02 | Henry | Virginia | 51089 | 136 | 3 |
199664 | 199664 | 2020-06-01 | Henry | Virginia | 51089 | 114 | 3 |
196591 | 196591 | 2020-05-31 | Henry | Virginia | 51089 | 113 | 3 |
193521 | 193521 | 2020-05-30 | Henry | Virginia | 51089 | 104 | 3 |
190455 | 190455 | 2020-05-29 | Henry | Virginia | 51089 | 99 | 3 |
187391 | 187391 | 2020-05-28 | Henry | Virginia | 51089 | 95 | 3 |
184334 | 184334 | 2020-05-27 | Henry | Virginia | 51089 | 92 | 3 |
181283 | 181283 | 2020-05-26 | Henry | Virginia | 51089 | 84 | 2 |
178239 | 178239 | 2020-05-25 | Henry | Virginia | 51089 | 77 | 2 |
175194 | 175194 | 2020-05-24 | Henry | Virginia | 51089 | 67 | 2 |
172151 | 172151 | 2020-05-23 | Henry | Virginia | 51089 | 63 | 2 |
169110 | 169110 | 2020-05-22 | Henry | Virginia | 51089 | 59 | 2 |
166074 | 166074 | 2020-05-21 | Henry | Virginia | 51089 | 53 | 2 |
163045 | 163045 | 2020-05-20 | Henry | Virginia | 51089 | 50 | 2 |
160017 | 160017 | 2020-05-19 | Henry | Virginia | 51089 | 46 | 2 |
156993 | 156993 | 2020-05-18 | Henry | Virginia | 51089 | 43 | 2 |
153976 | 153976 | 2020-05-17 | Henry | Virginia | 51089 | 36 | 2 |
150965 | 150965 | 2020-05-16 | Henry | Virginia | 51089 | 34 | 2 |
147956 | 147956 | 2020-05-15 | Henry | Virginia | 51089 | 30 | 1 |
144953 | 144953 | 2020-05-14 | Henry | Virginia | 51089 | 28 | 1 |
141956 | 141956 | 2020-05-13 | Henry | Virginia | 51089 | 28 | 1 |
138960 | 138960 | 2020-05-12 | Henry | Virginia | 51089 | 27 | 1 |
135969 | 135969 | 2020-05-11 | Henry | Virginia | 51089 | 25 | 1 |
132979 | 132979 | 2020-05-10 | Henry | Virginia | 51089 | 22 | 1 |
129989 | 129989 | 2020-05-09 | Henry | Virginia | 51089 | 22 | 1 |
126999 | 126999 | 2020-05-08 | Henry | Virginia | 51089 | 21 | 1 |
124014 | 124014 | 2020-05-07 | Henry | Virginia | 51089 | 20 | 1 |
121033 | 121033 | 2020-05-06 | Henry | Virginia | 51089 | 19 | 1 |
118069 | 118069 | 2020-05-05 | Henry | Virginia | 51089 | 19 | 1 |
115110 | 115110 | 2020-05-04 | Henry | Virginia | 51089 | 19 | 1 |
112227 | 112227 | 2020-05-03 | Henry | Virginia | 51089 | 19 | 1 |
109353 | 109353 | 2020-05-02 | Henry | Virginia | 51089 | 19 | 1 |
106484 | 106484 | 2020-05-01 | Henry | Virginia | 51089 | 16 | 1 |
103620 | 103620 | 2020-04-30 | Henry | Virginia | 51089 | 16 | 1 |
100765 | 100765 | 2020-04-29 | Henry | Virginia | 51089 | 16 | 1 |
97915 | 97915 | 2020-04-28 | Henry | Virginia | 51089 | 16 | 1 |
95072 | 95072 | 2020-04-27 | Henry | Virginia | 51089 | 15 | 1 |
92243 | 92243 | 2020-04-26 | Henry | Virginia | 51089 | 14 | 1 |
89426 | 89426 | 2020-04-25 | Henry | Virginia | 51089 | 13 | 1 |
86611 | 86611 | 2020-04-24 | Henry | Virginia | 51089 | 12 | 1 |
83804 | 83804 | 2020-04-23 | Henry | Virginia | 51089 | 10 | 1 |
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);