ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 5, fips = 51099 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 |
---|---|---|---|---|---|---|---|
783876 | 783876 | 2020-11-30 | King George | Virginia | 51099 | 420 | 5 |
780631 | 780631 | 2020-11-29 | King George | Virginia | 51099 | 415 | 5 |
777385 | 777385 | 2020-11-28 | King George | Virginia | 51099 | 409 | 5 |
774140 | 774140 | 2020-11-27 | King George | Virginia | 51099 | 396 | 5 |
770895 | 770895 | 2020-11-26 | King George | Virginia | 51099 | 384 | 5 |
767649 | 767649 | 2020-11-25 | King George | Virginia | 51099 | 377 | 5 |
764404 | 764404 | 2020-11-24 | King George | Virginia | 51099 | 375 | 5 |
761159 | 761159 | 2020-11-23 | King George | Virginia | 51099 | 371 | 5 |
757914 | 757914 | 2020-11-22 | King George | Virginia | 51099 | 363 | 5 |
754667 | 754667 | 2020-11-21 | King George | Virginia | 51099 | 361 | 5 |
751421 | 751421 | 2020-11-20 | King George | Virginia | 51099 | 354 | 5 |
748175 | 748175 | 2020-11-19 | King George | Virginia | 51099 | 350 | 5 |
744929 | 744929 | 2020-11-18 | King George | Virginia | 51099 | 348 | 5 |
741682 | 741682 | 2020-11-17 | King George | Virginia | 51099 | 342 | 5 |
738435 | 738435 | 2020-11-16 | King George | Virginia | 51099 | 337 | 5 |
735191 | 735191 | 2020-11-15 | King George | Virginia | 51099 | 329 | 5 |
731945 | 731945 | 2020-11-14 | King George | Virginia | 51099 | 327 | 5 |
728700 | 728700 | 2020-11-13 | King George | Virginia | 51099 | 323 | 5 |
725457 | 725457 | 2020-11-12 | King George | Virginia | 51099 | 318 | 5 |
722214 | 722214 | 2020-11-11 | King George | Virginia | 51099 | 311 | 5 |
718971 | 718971 | 2020-11-10 | King George | Virginia | 51099 | 303 | 5 |
715728 | 715728 | 2020-11-09 | King George | Virginia | 51099 | 304 | 5 |
712484 | 712484 | 2020-11-08 | King George | Virginia | 51099 | 303 | 5 |
709240 | 709240 | 2020-11-07 | King George | Virginia | 51099 | 300 | 5 |
705996 | 705996 | 2020-11-06 | King George | Virginia | 51099 | 298 | 5 |
702753 | 702753 | 2020-11-05 | King George | Virginia | 51099 | 297 | 5 |
699510 | 699510 | 2020-11-04 | King George | Virginia | 51099 | 294 | 5 |
696266 | 696266 | 2020-11-03 | King George | Virginia | 51099 | 296 | 5 |
693024 | 693024 | 2020-11-02 | King George | Virginia | 51099 | 292 | 5 |
689780 | 689780 | 2020-11-01 | King George | Virginia | 51099 | 290 | 5 |
686535 | 686535 | 2020-10-31 | King George | Virginia | 51099 | 289 | 5 |
683292 | 683292 | 2020-10-30 | King George | Virginia | 51099 | 284 | 5 |
680049 | 680049 | 2020-10-29 | King George | Virginia | 51099 | 278 | 5 |
676806 | 676806 | 2020-10-28 | King George | Virginia | 51099 | 275 | 5 |
673563 | 673563 | 2020-10-27 | King George | Virginia | 51099 | 272 | 5 |
670321 | 670321 | 2020-10-26 | King George | Virginia | 51099 | 270 | 5 |
667078 | 667078 | 2020-10-25 | King George | Virginia | 51099 | 267 | 5 |
663833 | 663833 | 2020-10-24 | King George | Virginia | 51099 | 267 | 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);