ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where county = "Warren", deaths = 6 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
296342 | 296342 | 2020-07-02 | Warren | Virginia | 51187 | 292 | 6 |
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);