ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51085 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388889 | 388889 | 2020-07-31 | Hanover | Virginia | 51085 | 584 | 31 |
385672 | 385672 | 2020-07-30 | Hanover | Virginia | 51085 | 583 | 30 |
382454 | 382454 | 2020-07-29 | Hanover | Virginia | 51085 | 579 | 30 |
379237 | 379237 | 2020-07-28 | Hanover | Virginia | 51085 | 576 | 30 |
376021 | 376021 | 2020-07-27 | Hanover | Virginia | 51085 | 575 | 30 |
372807 | 372807 | 2020-07-26 | Hanover | Virginia | 51085 | 563 | 30 |
369595 | 369595 | 2020-07-25 | Hanover | Virginia | 51085 | 557 | 30 |
366386 | 366386 | 2020-07-24 | Hanover | Virginia | 51085 | 546 | 30 |
363180 | 363180 | 2020-07-23 | Hanover | Virginia | 51085 | 539 | 30 |
359974 | 359974 | 2020-07-22 | Hanover | Virginia | 51085 | 531 | 30 |
356769 | 356769 | 2020-07-21 | Hanover | Virginia | 51085 | 532 | 30 |
353566 | 353566 | 2020-07-20 | Hanover | Virginia | 51085 | 518 | 30 |
350364 | 350364 | 2020-07-19 | Hanover | Virginia | 51085 | 514 | 30 |
347163 | 347163 | 2020-07-18 | Hanover | Virginia | 51085 | 511 | 30 |
343963 | 343963 | 2020-07-17 | Hanover | Virginia | 51085 | 508 | 30 |
340764 | 340764 | 2020-07-16 | Hanover | Virginia | 51085 | 504 | 30 |
337568 | 337568 | 2020-07-15 | Hanover | Virginia | 51085 | 491 | 30 |
334373 | 334373 | 2020-07-14 | Hanover | Virginia | 51085 | 486 | 31 |
331180 | 331180 | 2020-07-13 | Hanover | Virginia | 51085 | 483 | 31 |
327994 | 327994 | 2020-07-12 | Hanover | Virginia | 51085 | 476 | 31 |
324809 | 324809 | 2020-07-11 | Hanover | Virginia | 51085 | 469 | 31 |
321628 | 321628 | 2020-07-10 | Hanover | Virginia | 51085 | 467 | 31 |
318449 | 318449 | 2020-07-09 | Hanover | Virginia | 51085 | 459 | 31 |
315276 | 315276 | 2020-07-08 | Hanover | Virginia | 51085 | 456 | 31 |
312101 | 312101 | 2020-07-07 | Hanover | Virginia | 51085 | 452 | 31 |
308932 | 308932 | 2020-07-06 | Hanover | Virginia | 51085 | 449 | 29 |
305764 | 305764 | 2020-07-05 | Hanover | Virginia | 51085 | 447 | 29 |
302600 | 302600 | 2020-07-04 | Hanover | Virginia | 51085 | 443 | 29 |
299436 | 299436 | 2020-07-03 | Hanover | Virginia | 51085 | 442 | 29 |
296274 | 296274 | 2020-07-02 | Hanover | Virginia | 51085 | 435 | 27 |
293119 | 293119 | 2020-07-01 | Hanover | Virginia | 51085 | 429 | 27 |
289966 | 289966 | 2020-06-30 | Hanover | Virginia | 51085 | 429 | 26 |
286816 | 286816 | 2020-06-29 | Hanover | Virginia | 51085 | 423 | 26 |
283670 | 283670 | 2020-06-28 | Hanover | Virginia | 51085 | 420 | 26 |
280524 | 280524 | 2020-06-27 | Hanover | Virginia | 51085 | 416 | 26 |
277376 | 277376 | 2020-06-26 | Hanover | Virginia | 51085 | 415 | 25 |
274228 | 274228 | 2020-06-25 | Hanover | Virginia | 51085 | 412 | 25 |
271088 | 271088 | 2020-06-24 | Hanover | Virginia | 51085 | 410 | 25 |
267954 | 267954 | 2020-06-23 | Hanover | Virginia | 51085 | 410 | 25 |
264825 | 264825 | 2020-06-22 | Hanover | Virginia | 51085 | 405 | 25 |
261696 | 261696 | 2020-06-21 | Hanover | Virginia | 51085 | 403 | 25 |
258569 | 258569 | 2020-06-20 | Hanover | Virginia | 51085 | 397 | 25 |
255442 | 255442 | 2020-06-19 | Hanover | Virginia | 51085 | 387 | 25 |
252323 | 252323 | 2020-06-18 | Hanover | Virginia | 51085 | 380 | 25 |
249208 | 249208 | 2020-06-17 | Hanover | Virginia | 51085 | 378 | 25 |
246096 | 246096 | 2020-06-16 | Hanover | Virginia | 51085 | 375 | 25 |
242983 | 242983 | 2020-06-15 | Hanover | Virginia | 51085 | 374 | 25 |
239872 | 239872 | 2020-06-14 | Hanover | Virginia | 51085 | 371 | 25 |
236764 | 236764 | 2020-06-13 | Hanover | Virginia | 51085 | 368 | 25 |
233657 | 233657 | 2020-06-12 | Hanover | Virginia | 51085 | 362 | 25 |
230552 | 230552 | 2020-06-11 | Hanover | Virginia | 51085 | 357 | 25 |
227448 | 227448 | 2020-06-10 | Hanover | Virginia | 51085 | 354 | 25 |
224348 | 224348 | 2020-06-09 | Hanover | Virginia | 51085 | 351 | 24 |
221252 | 221252 | 2020-06-08 | Hanover | Virginia | 51085 | 347 | 24 |
218160 | 218160 | 2020-06-07 | Hanover | Virginia | 51085 | 348 | 24 |
215070 | 215070 | 2020-06-06 | Hanover | Virginia | 51085 | 340 | 24 |
211983 | 211983 | 2020-06-05 | Hanover | Virginia | 51085 | 338 | 24 |
208898 | 208898 | 2020-06-04 | Hanover | Virginia | 51085 | 336 | 24 |
205816 | 205816 | 2020-06-03 | Hanover | Virginia | 51085 | 331 | 24 |
202737 | 202737 | 2020-06-02 | Hanover | Virginia | 51085 | 335 | 24 |
199661 | 199661 | 2020-06-01 | Hanover | Virginia | 51085 | 327 | 24 |
196588 | 196588 | 2020-05-31 | Hanover | Virginia | 51085 | 326 | 24 |
193518 | 193518 | 2020-05-30 | Hanover | Virginia | 51085 | 322 | 24 |
190452 | 190452 | 2020-05-29 | Hanover | Virginia | 51085 | 320 | 24 |
187388 | 187388 | 2020-05-28 | Hanover | Virginia | 51085 | 316 | 24 |
184331 | 184331 | 2020-05-27 | Hanover | Virginia | 51085 | 309 | 22 |
181280 | 181280 | 2020-05-26 | Hanover | Virginia | 51085 | 301 | 19 |
178236 | 178236 | 2020-05-25 | Hanover | Virginia | 51085 | 275 | 19 |
175191 | 175191 | 2020-05-24 | Hanover | Virginia | 51085 | 252 | 19 |
172148 | 172148 | 2020-05-23 | Hanover | Virginia | 51085 | 252 | 19 |
169107 | 169107 | 2020-05-22 | Hanover | Virginia | 51085 | 246 | 19 |
166071 | 166071 | 2020-05-21 | Hanover | Virginia | 51085 | 244 | 19 |
163042 | 163042 | 2020-05-20 | Hanover | Virginia | 51085 | 238 | 19 |
160014 | 160014 | 2020-05-19 | Hanover | Virginia | 51085 | 232 | 19 |
156990 | 156990 | 2020-05-18 | Hanover | Virginia | 51085 | 225 | 19 |
153973 | 153973 | 2020-05-17 | Hanover | Virginia | 51085 | 220 | 19 |
150962 | 150962 | 2020-05-16 | Hanover | Virginia | 51085 | 215 | 19 |
147953 | 147953 | 2020-05-15 | Hanover | Virginia | 51085 | 208 | 19 |
144950 | 144950 | 2020-05-14 | Hanover | Virginia | 51085 | 198 | 18 |
141953 | 141953 | 2020-05-13 | Hanover | Virginia | 51085 | 183 | 17 |
138957 | 138957 | 2020-05-12 | Hanover | Virginia | 51085 | 174 | 17 |
135966 | 135966 | 2020-05-11 | Hanover | Virginia | 51085 | 171 | 16 |
132976 | 132976 | 2020-05-10 | Hanover | Virginia | 51085 | 170 | 16 |
129986 | 129986 | 2020-05-09 | Hanover | Virginia | 51085 | 163 | 16 |
126996 | 126996 | 2020-05-08 | Hanover | Virginia | 51085 | 155 | 15 |
124011 | 124011 | 2020-05-07 | Hanover | Virginia | 51085 | 154 | 15 |
121030 | 121030 | 2020-05-06 | Hanover | Virginia | 51085 | 145 | 13 |
118066 | 118066 | 2020-05-05 | Hanover | Virginia | 51085 | 145 | 13 |
115107 | 115107 | 2020-05-04 | Hanover | Virginia | 51085 | 141 | 12 |
112224 | 112224 | 2020-05-03 | Hanover | Virginia | 51085 | 137 | 12 |
109350 | 109350 | 2020-05-02 | Hanover | Virginia | 51085 | 133 | 11 |
106481 | 106481 | 2020-05-01 | Hanover | Virginia | 51085 | 132 | 12 |
103617 | 103617 | 2020-04-30 | Hanover | Virginia | 51085 | 118 | 9 |
100762 | 100762 | 2020-04-29 | Hanover | Virginia | 51085 | 113 | 9 |
97912 | 97912 | 2020-04-28 | Hanover | Virginia | 51085 | 109 | 9 |
95069 | 95069 | 2020-04-27 | Hanover | Virginia | 51085 | 108 | 7 |
92240 | 92240 | 2020-04-26 | Hanover | Virginia | 51085 | 105 | 7 |
89423 | 89423 | 2020-04-25 | Hanover | Virginia | 51085 | 103 | 7 |
86608 | 86608 | 2020-04-24 | Hanover | Virginia | 51085 | 100 | 7 |
83801 | 83801 | 2020-04-23 | Hanover | Virginia | 51085 | 99 | 7 |
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);