ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 5, fips = 51145 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
725490 | 725490 | 2020-11-12 | Powhatan | Virginia | 51145 | 351 | 5 |
722247 | 722247 | 2020-11-11 | Powhatan | Virginia | 51145 | 343 | 5 |
719004 | 719004 | 2020-11-10 | Powhatan | Virginia | 51145 | 339 | 5 |
715761 | 715761 | 2020-11-09 | Powhatan | Virginia | 51145 | 338 | 5 |
712517 | 712517 | 2020-11-08 | Powhatan | Virginia | 51145 | 338 | 5 |
709273 | 709273 | 2020-11-07 | Powhatan | Virginia | 51145 | 332 | 5 |
706029 | 706029 | 2020-11-06 | Powhatan | Virginia | 51145 | 324 | 5 |
702786 | 702786 | 2020-11-05 | Powhatan | Virginia | 51145 | 325 | 5 |
699543 | 699543 | 2020-11-04 | Powhatan | Virginia | 51145 | 326 | 5 |
696299 | 696299 | 2020-11-03 | Powhatan | Virginia | 51145 | 324 | 5 |
693057 | 693057 | 2020-11-02 | Powhatan | Virginia | 51145 | 324 | 5 |
689813 | 689813 | 2020-11-01 | Powhatan | Virginia | 51145 | 324 | 5 |
686568 | 686568 | 2020-10-31 | Powhatan | Virginia | 51145 | 321 | 5 |
683325 | 683325 | 2020-10-30 | Powhatan | Virginia | 51145 | 316 | 5 |
680082 | 680082 | 2020-10-29 | Powhatan | Virginia | 51145 | 315 | 5 |
676839 | 676839 | 2020-10-28 | Powhatan | Virginia | 51145 | 313 | 5 |
673596 | 673596 | 2020-10-27 | Powhatan | Virginia | 51145 | 312 | 5 |
670354 | 670354 | 2020-10-26 | Powhatan | Virginia | 51145 | 311 | 5 |
667111 | 667111 | 2020-10-25 | Powhatan | Virginia | 51145 | 306 | 5 |
663866 | 663866 | 2020-10-24 | Powhatan | Virginia | 51145 | 304 | 5 |
660622 | 660622 | 2020-10-23 | Powhatan | Virginia | 51145 | 294 | 5 |
657378 | 657378 | 2020-10-22 | Powhatan | Virginia | 51145 | 290 | 5 |
654133 | 654133 | 2020-10-21 | Powhatan | Virginia | 51145 | 289 | 5 |
650888 | 650888 | 2020-10-20 | Powhatan | Virginia | 51145 | 283 | 5 |
647644 | 647644 | 2020-10-19 | Powhatan | Virginia | 51145 | 280 | 5 |
644398 | 644398 | 2020-10-18 | Powhatan | Virginia | 51145 | 280 | 5 |
641150 | 641150 | 2020-10-17 | Powhatan | Virginia | 51145 | 278 | 5 |
637903 | 637903 | 2020-10-16 | Powhatan | Virginia | 51145 | 268 | 5 |
634658 | 634658 | 2020-10-15 | Powhatan | Virginia | 51145 | 269 | 5 |
631413 | 631413 | 2020-10-14 | Powhatan | Virginia | 51145 | 267 | 5 |
628169 | 628169 | 2020-10-13 | Powhatan | Virginia | 51145 | 266 | 5 |
624926 | 624926 | 2020-10-12 | Powhatan | Virginia | 51145 | 256 | 5 |
621683 | 621683 | 2020-10-11 | Powhatan | Virginia | 51145 | 254 | 5 |
618440 | 618440 | 2020-10-10 | Powhatan | Virginia | 51145 | 254 | 5 |
615198 | 615198 | 2020-10-09 | Powhatan | Virginia | 51145 | 247 | 5 |
611957 | 611957 | 2020-10-08 | Powhatan | Virginia | 51145 | 240 | 5 |
608715 | 608715 | 2020-10-07 | Powhatan | Virginia | 51145 | 240 | 5 |
605472 | 605472 | 2020-10-06 | Powhatan | Virginia | 51145 | 240 | 5 |
602230 | 602230 | 2020-10-05 | Powhatan | Virginia | 51145 | 238 | 5 |
598987 | 598987 | 2020-10-04 | Powhatan | Virginia | 51145 | 236 | 5 |
595744 | 595744 | 2020-10-03 | Powhatan | Virginia | 51145 | 234 | 5 |
592502 | 592502 | 2020-10-02 | Powhatan | Virginia | 51145 | 233 | 5 |
589262 | 589262 | 2020-10-01 | Powhatan | Virginia | 51145 | 231 | 5 |
586021 | 586021 | 2020-09-30 | Powhatan | Virginia | 51145 | 230 | 5 |
582781 | 582781 | 2020-09-29 | Powhatan | Virginia | 51145 | 229 | 5 |
579542 | 579542 | 2020-09-28 | Powhatan | Virginia | 51145 | 223 | 5 |
576301 | 576301 | 2020-09-27 | Powhatan | Virginia | 51145 | 222 | 5 |
573057 | 573057 | 2020-09-26 | Powhatan | Virginia | 51145 | 221 | 5 |
569815 | 569815 | 2020-09-25 | Powhatan | Virginia | 51145 | 219 | 5 |
566574 | 566574 | 2020-09-24 | Powhatan | Virginia | 51145 | 220 | 5 |
563333 | 563333 | 2020-09-23 | Powhatan | Virginia | 51145 | 219 | 5 |
560094 | 560094 | 2020-09-22 | Powhatan | Virginia | 51145 | 218 | 5 |
556858 | 556858 | 2020-09-21 | Powhatan | Virginia | 51145 | 214 | 5 |
553621 | 553621 | 2020-09-20 | Powhatan | Virginia | 51145 | 212 | 5 |
550382 | 550382 | 2020-09-19 | Powhatan | Virginia | 51145 | 210 | 5 |
547143 | 547143 | 2020-09-18 | Powhatan | Virginia | 51145 | 207 | 5 |
543906 | 543906 | 2020-09-17 | Powhatan | Virginia | 51145 | 208 | 5 |
540670 | 540670 | 2020-09-16 | Powhatan | Virginia | 51145 | 208 | 5 |
537433 | 537433 | 2020-09-15 | Powhatan | Virginia | 51145 | 207 | 5 |
534197 | 534197 | 2020-09-14 | Powhatan | Virginia | 51145 | 203 | 5 |
530962 | 530962 | 2020-09-13 | Powhatan | Virginia | 51145 | 203 | 5 |
527725 | 527725 | 2020-09-12 | Powhatan | Virginia | 51145 | 202 | 5 |
524489 | 524489 | 2020-09-11 | Powhatan | Virginia | 51145 | 199 | 5 |
521253 | 521253 | 2020-09-10 | Powhatan | Virginia | 51145 | 198 | 5 |
518016 | 518016 | 2020-09-09 | Powhatan | Virginia | 51145 | 197 | 5 |
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);