ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 51023 and state = "Virginia" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
286772 | 286772 | 2020-06-29 | Botetourt | Virginia | 51023 | 86 | 4 |
289922 | 289922 | 2020-06-30 | Botetourt | Virginia | 51023 | 121 | 4 |
293075 | 293075 | 2020-07-01 | Botetourt | Virginia | 51023 | 123 | 4 |
296230 | 296230 | 2020-07-02 | Botetourt | Virginia | 51023 | 125 | 4 |
299392 | 299392 | 2020-07-03 | Botetourt | Virginia | 51023 | 133 | 4 |
302556 | 302556 | 2020-07-04 | Botetourt | Virginia | 51023 | 133 | 4 |
305720 | 305720 | 2020-07-05 | Botetourt | Virginia | 51023 | 134 | 4 |
308888 | 308888 | 2020-07-06 | Botetourt | Virginia | 51023 | 139 | 4 |
312057 | 312057 | 2020-07-07 | Botetourt | Virginia | 51023 | 145 | 4 |
315232 | 315232 | 2020-07-08 | Botetourt | Virginia | 51023 | 148 | 4 |
318405 | 318405 | 2020-07-09 | Botetourt | Virginia | 51023 | 150 | 4 |
321584 | 321584 | 2020-07-10 | Botetourt | Virginia | 51023 | 151 | 4 |
324765 | 324765 | 2020-07-11 | Botetourt | Virginia | 51023 | 152 | 4 |
327950 | 327950 | 2020-07-12 | Botetourt | Virginia | 51023 | 155 | 4 |
331136 | 331136 | 2020-07-13 | Botetourt | Virginia | 51023 | 156 | 4 |
334329 | 334329 | 2020-07-14 | Botetourt | Virginia | 51023 | 160 | 4 |
337524 | 337524 | 2020-07-15 | Botetourt | Virginia | 51023 | 161 | 4 |
340720 | 340720 | 2020-07-16 | Botetourt | Virginia | 51023 | 164 | 4 |
343919 | 343919 | 2020-07-17 | Botetourt | Virginia | 51023 | 165 | 4 |
347119 | 347119 | 2020-07-18 | Botetourt | Virginia | 51023 | 165 | 4 |
350320 | 350320 | 2020-07-19 | Botetourt | Virginia | 51023 | 165 | 4 |
353522 | 353522 | 2020-07-20 | Botetourt | Virginia | 51023 | 166 | 4 |
356725 | 356725 | 2020-07-21 | Botetourt | Virginia | 51023 | 166 | 4 |
359930 | 359930 | 2020-07-22 | Botetourt | Virginia | 51023 | 166 | 4 |
363136 | 363136 | 2020-07-23 | Botetourt | Virginia | 51023 | 168 | 4 |
366342 | 366342 | 2020-07-24 | Botetourt | Virginia | 51023 | 171 | 4 |
369551 | 369551 | 2020-07-25 | Botetourt | Virginia | 51023 | 172 | 4 |
372763 | 372763 | 2020-07-26 | Botetourt | Virginia | 51023 | 177 | 4 |
375977 | 375977 | 2020-07-27 | Botetourt | Virginia | 51023 | 179 | 4 |
379193 | 379193 | 2020-07-28 | Botetourt | Virginia | 51023 | 178 | 4 |
382410 | 382410 | 2020-07-29 | Botetourt | Virginia | 51023 | 182 | 4 |
385628 | 385628 | 2020-07-30 | Botetourt | Virginia | 51023 | 183 | 5 |
388845 | 388845 | 2020-07-31 | Botetourt | Virginia | 51023 | 185 | 5 |
392062 | 392062 | 2020-08-01 | Botetourt | Virginia | 51023 | 185 | 7 |
395278 | 395278 | 2020-08-02 | Botetourt | Virginia | 51023 | 188 | 7 |
398494 | 398494 | 2020-08-03 | Botetourt | Virginia | 51023 | 192 | 7 |
401710 | 401710 | 2020-08-04 | Botetourt | Virginia | 51023 | 192 | 7 |
404928 | 404928 | 2020-08-05 | Botetourt | Virginia | 51023 | 193 | 7 |
408148 | 408148 | 2020-08-06 | Botetourt | Virginia | 51023 | 200 | 7 |
411367 | 411367 | 2020-08-07 | Botetourt | Virginia | 51023 | 210 | 7 |
414587 | 414587 | 2020-08-08 | Botetourt | Virginia | 51023 | 212 | 7 |
417808 | 417808 | 2020-08-09 | Botetourt | Virginia | 51023 | 214 | 7 |
421029 | 421029 | 2020-08-10 | Botetourt | Virginia | 51023 | 215 | 7 |
424250 | 424250 | 2020-08-11 | Botetourt | Virginia | 51023 | 215 | 7 |
427474 | 427474 | 2020-08-12 | Botetourt | Virginia | 51023 | 216 | 7 |
430702 | 430702 | 2020-08-13 | Botetourt | Virginia | 51023 | 217 | 7 |
433927 | 433927 | 2020-08-14 | Botetourt | Virginia | 51023 | 219 | 7 |
437153 | 437153 | 2020-08-15 | Botetourt | Virginia | 51023 | 220 | 7 |
440379 | 440379 | 2020-08-16 | Botetourt | Virginia | 51023 | 220 | 7 |
443605 | 443605 | 2020-08-17 | Botetourt | Virginia | 51023 | 223 | 7 |
446832 | 446832 | 2020-08-18 | Botetourt | Virginia | 51023 | 222 | 7 |
450060 | 450060 | 2020-08-19 | Botetourt | Virginia | 51023 | 220 | 7 |
453288 | 453288 | 2020-08-20 | Botetourt | Virginia | 51023 | 221 | 7 |
456516 | 456516 | 2020-08-21 | Botetourt | Virginia | 51023 | 224 | 7 |
459743 | 459743 | 2020-08-22 | Botetourt | Virginia | 51023 | 226 | 7 |
462972 | 462972 | 2020-08-23 | Botetourt | Virginia | 51023 | 226 | 8 |
466201 | 466201 | 2020-08-24 | Botetourt | Virginia | 51023 | 230 | 8 |
469430 | 469430 | 2020-08-25 | Botetourt | Virginia | 51023 | 231 | 8 |
472662 | 472662 | 2020-08-26 | Botetourt | Virginia | 51023 | 237 | 8 |
475895 | 475895 | 2020-08-27 | Botetourt | Virginia | 51023 | 238 | 8 |
479128 | 479128 | 2020-08-28 | Botetourt | Virginia | 51023 | 247 | 8 |
482362 | 482362 | 2020-08-29 | Botetourt | Virginia | 51023 | 246 | 8 |
485597 | 485597 | 2020-08-30 | Botetourt | Virginia | 51023 | 248 | 8 |
488830 | 488830 | 2020-08-31 | Botetourt | Virginia | 51023 | 249 | 8 |
492063 | 492063 | 2020-09-01 | Botetourt | Virginia | 51023 | 250 | 10 |
495297 | 495297 | 2020-09-02 | Botetourt | Virginia | 51023 | 251 | 10 |
498530 | 498530 | 2020-09-03 | Botetourt | Virginia | 51023 | 255 | 10 |
501764 | 501764 | 2020-09-04 | Botetourt | Virginia | 51023 | 255 | 10 |
504998 | 504998 | 2020-09-05 | Botetourt | Virginia | 51023 | 256 | 10 |
508230 | 508230 | 2020-09-06 | Botetourt | Virginia | 51023 | 260 | 10 |
511463 | 511463 | 2020-09-07 | Botetourt | Virginia | 51023 | 266 | 10 |
514696 | 514696 | 2020-09-08 | Botetourt | Virginia | 51023 | 266 | 10 |
517931 | 517931 | 2020-09-09 | Botetourt | Virginia | 51023 | 265 | 10 |
521168 | 521168 | 2020-09-10 | Botetourt | Virginia | 51023 | 269 | 10 |
524404 | 524404 | 2020-09-11 | Botetourt | Virginia | 51023 | 272 | 10 |
527640 | 527640 | 2020-09-12 | Botetourt | Virginia | 51023 | 274 | 10 |
530877 | 530877 | 2020-09-13 | Botetourt | Virginia | 51023 | 277 | 10 |
534112 | 534112 | 2020-09-14 | Botetourt | Virginia | 51023 | 277 | 10 |
537348 | 537348 | 2020-09-15 | Botetourt | Virginia | 51023 | 278 | 10 |
540585 | 540585 | 2020-09-16 | Botetourt | Virginia | 51023 | 280 | 10 |
543821 | 543821 | 2020-09-17 | Botetourt | Virginia | 51023 | 281 | 10 |
547058 | 547058 | 2020-09-18 | Botetourt | Virginia | 51023 | 283 | 10 |
550297 | 550297 | 2020-09-19 | Botetourt | Virginia | 51023 | 284 | 10 |
553536 | 553536 | 2020-09-20 | Botetourt | Virginia | 51023 | 290 | 10 |
556773 | 556773 | 2020-09-21 | Botetourt | Virginia | 51023 | 290 | 10 |
560009 | 560009 | 2020-09-22 | Botetourt | Virginia | 51023 | 291 | 10 |
563248 | 563248 | 2020-09-23 | Botetourt | Virginia | 51023 | 292 | 10 |
566489 | 566489 | 2020-09-24 | Botetourt | Virginia | 51023 | 293 | 10 |
569730 | 569730 | 2020-09-25 | Botetourt | Virginia | 51023 | 297 | 10 |
572972 | 572972 | 2020-09-26 | Botetourt | Virginia | 51023 | 302 | 10 |
576216 | 576216 | 2020-09-27 | Botetourt | Virginia | 51023 | 302 | 10 |
579457 | 579457 | 2020-09-28 | Botetourt | Virginia | 51023 | 302 | 10 |
582696 | 582696 | 2020-09-29 | Botetourt | Virginia | 51023 | 305 | 10 |
585936 | 585936 | 2020-09-30 | Botetourt | Virginia | 51023 | 306 | 10 |
589177 | 589177 | 2020-10-01 | Botetourt | Virginia | 51023 | 307 | 10 |
592417 | 592417 | 2020-10-02 | Botetourt | Virginia | 51023 | 310 | 10 |
595659 | 595659 | 2020-10-03 | Botetourt | Virginia | 51023 | 312 | 10 |
598902 | 598902 | 2020-10-04 | Botetourt | Virginia | 51023 | 315 | 10 |
602145 | 602145 | 2020-10-05 | Botetourt | Virginia | 51023 | 315 | 10 |
605387 | 605387 | 2020-10-06 | Botetourt | Virginia | 51023 | 315 | 10 |
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);