ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Warren" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637930 | 637930 | 2020-10-16 | Warren | Virginia | 51187 | 514 | 14 |
634685 | 634685 | 2020-10-15 | Warren | Virginia | 51187 | 514 | 14 |
631440 | 631440 | 2020-10-14 | Warren | Virginia | 51187 | 495 | 13 |
628196 | 628196 | 2020-10-13 | Warren | Virginia | 51187 | 493 | 13 |
624953 | 624953 | 2020-10-12 | Warren | Virginia | 51187 | 490 | 13 |
621710 | 621710 | 2020-10-11 | Warren | Virginia | 51187 | 484 | 13 |
618467 | 618467 | 2020-10-10 | Warren | Virginia | 51187 | 478 | 13 |
615225 | 615225 | 2020-10-09 | Warren | Virginia | 51187 | 473 | 13 |
611984 | 611984 | 2020-10-08 | Warren | Virginia | 51187 | 467 | 12 |
608742 | 608742 | 2020-10-07 | Warren | Virginia | 51187 | 460 | 12 |
605499 | 605499 | 2020-10-06 | Warren | Virginia | 51187 | 460 | 11 |
602257 | 602257 | 2020-10-05 | Warren | Virginia | 51187 | 453 | 10 |
599014 | 599014 | 2020-10-04 | Warren | Virginia | 51187 | 449 | 10 |
595771 | 595771 | 2020-10-03 | Warren | Virginia | 51187 | 448 | 10 |
592529 | 592529 | 2020-10-02 | Warren | Virginia | 51187 | 442 | 10 |
589289 | 589289 | 2020-10-01 | Warren | Virginia | 51187 | 442 | 10 |
586048 | 586048 | 2020-09-30 | Warren | Virginia | 51187 | 440 | 7 |
582808 | 582808 | 2020-09-29 | Warren | Virginia | 51187 | 435 | 7 |
579569 | 579569 | 2020-09-28 | Warren | Virginia | 51187 | 431 | 7 |
576328 | 576328 | 2020-09-27 | Warren | Virginia | 51187 | 418 | 7 |
573084 | 573084 | 2020-09-26 | Warren | Virginia | 51187 | 418 | 7 |
569842 | 569842 | 2020-09-25 | Warren | Virginia | 51187 | 415 | 7 |
566601 | 566601 | 2020-09-24 | Warren | Virginia | 51187 | 415 | 6 |
563360 | 563360 | 2020-09-23 | Warren | Virginia | 51187 | 415 | 6 |
560121 | 560121 | 2020-09-22 | Warren | Virginia | 51187 | 413 | 6 |
556885 | 556885 | 2020-09-21 | Warren | Virginia | 51187 | 413 | 6 |
553648 | 553648 | 2020-09-20 | Warren | Virginia | 51187 | 412 | 6 |
550409 | 550409 | 2020-09-19 | Warren | Virginia | 51187 | 412 | 6 |
547170 | 547170 | 2020-09-18 | Warren | Virginia | 51187 | 409 | 6 |
543933 | 543933 | 2020-09-17 | Warren | Virginia | 51187 | 409 | 6 |
540697 | 540697 | 2020-09-16 | Warren | Virginia | 51187 | 409 | 6 |
537460 | 537460 | 2020-09-15 | Warren | Virginia | 51187 | 407 | 6 |
534224 | 534224 | 2020-09-14 | Warren | Virginia | 51187 | 405 | 6 |
530989 | 530989 | 2020-09-13 | Warren | Virginia | 51187 | 404 | 6 |
527752 | 527752 | 2020-09-12 | Warren | Virginia | 51187 | 402 | 6 |
524516 | 524516 | 2020-09-11 | Warren | Virginia | 51187 | 400 | 6 |
521280 | 521280 | 2020-09-10 | Warren | Virginia | 51187 | 398 | 6 |
518043 | 518043 | 2020-09-09 | Warren | Virginia | 51187 | 396 | 6 |
514808 | 514808 | 2020-09-08 | Warren | Virginia | 51187 | 395 | 6 |
511575 | 511575 | 2020-09-07 | Warren | Virginia | 51187 | 395 | 6 |
508342 | 508342 | 2020-09-06 | Warren | Virginia | 51187 | 394 | 6 |
505110 | 505110 | 2020-09-05 | Warren | Virginia | 51187 | 393 | 6 |
501876 | 501876 | 2020-09-04 | Warren | Virginia | 51187 | 393 | 6 |
498642 | 498642 | 2020-09-03 | Warren | Virginia | 51187 | 395 | 6 |
495409 | 495409 | 2020-09-02 | Warren | Virginia | 51187 | 394 | 6 |
492175 | 492175 | 2020-09-01 | Warren | Virginia | 51187 | 391 | 6 |
488942 | 488942 | 2020-08-31 | Warren | Virginia | 51187 | 391 | 6 |
485709 | 485709 | 2020-08-30 | Warren | Virginia | 51187 | 391 | 6 |
482474 | 482474 | 2020-08-29 | Warren | Virginia | 51187 | 389 | 6 |
479240 | 479240 | 2020-08-28 | Warren | Virginia | 51187 | 389 | 6 |
476007 | 476007 | 2020-08-27 | Warren | Virginia | 51187 | 390 | 6 |
472774 | 472774 | 2020-08-26 | Warren | Virginia | 51187 | 388 | 6 |
469542 | 469542 | 2020-08-25 | Warren | Virginia | 51187 | 386 | 6 |
466313 | 466313 | 2020-08-24 | Warren | Virginia | 51187 | 386 | 6 |
463084 | 463084 | 2020-08-23 | Warren | Virginia | 51187 | 386 | 6 |
459855 | 459855 | 2020-08-22 | Warren | Virginia | 51187 | 381 | 6 |
456628 | 456628 | 2020-08-21 | Warren | Virginia | 51187 | 378 | 6 |
453400 | 453400 | 2020-08-20 | Warren | Virginia | 51187 | 380 | 6 |
450172 | 450172 | 2020-08-19 | Warren | Virginia | 51187 | 375 | 6 |
446944 | 446944 | 2020-08-18 | Warren | Virginia | 51187 | 374 | 6 |
443717 | 443717 | 2020-08-17 | Warren | Virginia | 51187 | 367 | 6 |
440491 | 440491 | 2020-08-16 | Warren | Virginia | 51187 | 367 | 6 |
437265 | 437265 | 2020-08-15 | Warren | Virginia | 51187 | 367 | 6 |
434039 | 434039 | 2020-08-14 | Warren | Virginia | 51187 | 366 | 6 |
430814 | 430814 | 2020-08-13 | Warren | Virginia | 51187 | 360 | 6 |
427586 | 427586 | 2020-08-12 | Warren | Virginia | 51187 | 356 | 6 |
424362 | 424362 | 2020-08-11 | Warren | Virginia | 51187 | 356 | 6 |
421141 | 421141 | 2020-08-10 | Warren | Virginia | 51187 | 355 | 6 |
417920 | 417920 | 2020-08-09 | Warren | Virginia | 51187 | 355 | 6 |
414699 | 414699 | 2020-08-08 | Warren | Virginia | 51187 | 355 | 6 |
411479 | 411479 | 2020-08-07 | Warren | Virginia | 51187 | 354 | 6 |
408260 | 408260 | 2020-08-06 | Warren | Virginia | 51187 | 353 | 6 |
405040 | 405040 | 2020-08-05 | Warren | Virginia | 51187 | 352 | 6 |
401822 | 401822 | 2020-08-04 | Warren | Virginia | 51187 | 351 | 6 |
398606 | 398606 | 2020-08-03 | Warren | Virginia | 51187 | 348 | 6 |
395390 | 395390 | 2020-08-02 | Warren | Virginia | 51187 | 348 | 7 |
392174 | 392174 | 2020-08-01 | Warren | Virginia | 51187 | 348 | 7 |
388957 | 388957 | 2020-07-31 | Warren | Virginia | 51187 | 348 | 7 |
385740 | 385740 | 2020-07-30 | Warren | Virginia | 51187 | 345 | 7 |
382522 | 382522 | 2020-07-29 | Warren | Virginia | 51187 | 344 | 7 |
379305 | 379305 | 2020-07-28 | Warren | Virginia | 51187 | 344 | 7 |
376089 | 376089 | 2020-07-27 | Warren | Virginia | 51187 | 345 | 7 |
372875 | 372875 | 2020-07-26 | Warren | Virginia | 51187 | 342 | 7 |
369663 | 369663 | 2020-07-25 | Warren | Virginia | 51187 | 341 | 7 |
366454 | 366454 | 2020-07-24 | Warren | Virginia | 51187 | 339 | 7 |
363248 | 363248 | 2020-07-23 | Warren | Virginia | 51187 | 339 | 7 |
360042 | 360042 | 2020-07-22 | Warren | Virginia | 51187 | 340 | 8 |
356837 | 356837 | 2020-07-21 | Warren | Virginia | 51187 | 334 | 8 |
353634 | 353634 | 2020-07-20 | Warren | Virginia | 51187 | 334 | 8 |
350432 | 350432 | 2020-07-19 | Warren | Virginia | 51187 | 326 | 8 |
347231 | 347231 | 2020-07-18 | Warren | Virginia | 51187 | 326 | 8 |
344031 | 344031 | 2020-07-17 | Warren | Virginia | 51187 | 322 | 8 |
340832 | 340832 | 2020-07-16 | Warren | Virginia | 51187 | 318 | 8 |
337636 | 337636 | 2020-07-15 | Warren | Virginia | 51187 | 317 | 8 |
334441 | 334441 | 2020-07-14 | Warren | Virginia | 51187 | 314 | 8 |
331248 | 331248 | 2020-07-13 | Warren | Virginia | 51187 | 313 | 8 |
328062 | 328062 | 2020-07-12 | Warren | Virginia | 51187 | 312 | 8 |
324877 | 324877 | 2020-07-11 | Warren | Virginia | 51187 | 308 | 8 |
321696 | 321696 | 2020-07-10 | Warren | Virginia | 51187 | 304 | 8 |
318517 | 318517 | 2020-07-09 | Warren | Virginia | 51187 | 303 | 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);