ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where county = "Brunswick", deaths = 6 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
770845 | 770845 | 2020-11-26 | Brunswick | Virginia | 51025 | 460 | 6 |
767599 | 767599 | 2020-11-25 | Brunswick | Virginia | 51025 | 460 | 6 |
764354 | 764354 | 2020-11-24 | Brunswick | Virginia | 51025 | 458 | 6 |
761109 | 761109 | 2020-11-23 | Brunswick | Virginia | 51025 | 458 | 6 |
757864 | 757864 | 2020-11-22 | Brunswick | Virginia | 51025 | 454 | 6 |
754617 | 754617 | 2020-11-21 | Brunswick | Virginia | 51025 | 454 | 6 |
751371 | 751371 | 2020-11-20 | Brunswick | Virginia | 51025 | 454 | 6 |
748125 | 748125 | 2020-11-19 | Brunswick | Virginia | 51025 | 453 | 6 |
744879 | 744879 | 2020-11-18 | Brunswick | Virginia | 51025 | 452 | 6 |
741632 | 741632 | 2020-11-17 | Brunswick | Virginia | 51025 | 449 | 6 |
738385 | 738385 | 2020-11-16 | Brunswick | Virginia | 51025 | 448 | 6 |
735141 | 735141 | 2020-11-15 | Brunswick | Virginia | 51025 | 447 | 6 |
731895 | 731895 | 2020-11-14 | Brunswick | Virginia | 51025 | 447 | 6 |
728650 | 728650 | 2020-11-13 | Brunswick | Virginia | 51025 | 446 | 6 |
725407 | 725407 | 2020-11-12 | Brunswick | Virginia | 51025 | 443 | 6 |
722164 | 722164 | 2020-11-11 | Brunswick | Virginia | 51025 | 442 | 6 |
718921 | 718921 | 2020-11-10 | Brunswick | Virginia | 51025 | 441 | 6 |
715678 | 715678 | 2020-11-09 | Brunswick | Virginia | 51025 | 440 | 6 |
712434 | 712434 | 2020-11-08 | Brunswick | Virginia | 51025 | 435 | 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);