ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Harrisonburg city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
81001 | 81001 | 2020-04-22 | Harrisonburg city | Virginia | 51660 | 318 | 8 |
78209 | 78209 | 2020-04-21 | Harrisonburg city | Virginia | 51660 | 264 | 0 |
75427 | 75427 | 2020-04-20 | Harrisonburg city | Virginia | 51660 | 252 | 0 |
72651 | 72651 | 2020-04-19 | Harrisonburg city | Virginia | 51660 | 236 | 0 |
69881 | 69881 | 2020-04-18 | Harrisonburg city | Virginia | 51660 | 233 | 0 |
67119 | 67119 | 2020-04-17 | Harrisonburg city | Virginia | 51660 | 214 | 0 |
64371 | 64371 | 2020-04-16 | Harrisonburg city | Virginia | 51660 | 119 | 0 |
61638 | 61638 | 2020-04-15 | Harrisonburg city | Virginia | 51660 | 101 | 0 |
58919 | 58919 | 2020-04-14 | Harrisonburg city | Virginia | 51660 | 95 | 0 |
56213 | 56213 | 2020-04-13 | Harrisonburg city | Virginia | 51660 | 87 | 0 |
53523 | 53523 | 2020-04-12 | Harrisonburg city | Virginia | 51660 | 81 | 0 |
50848 | 50848 | 2020-04-11 | Harrisonburg city | Virginia | 51660 | 79 | 0 |
48190 | 48190 | 2020-04-10 | Harrisonburg city | Virginia | 51660 | 57 | 0 |
45564 | 45564 | 2020-04-09 | Harrisonburg city | Virginia | 51660 | 39 | 0 |
42969 | 42969 | 2020-04-08 | Harrisonburg city | Virginia | 51660 | 36 | 0 |
40400 | 40400 | 2020-04-07 | Harrisonburg city | Virginia | 51660 | 27 | 0 |
37867 | 37867 | 2020-04-06 | Harrisonburg city | Virginia | 51660 | 27 | 0 |
35384 | 35384 | 2020-04-05 | Harrisonburg city | Virginia | 51660 | 25 | 0 |
32946 | 32946 | 2020-04-04 | Harrisonburg city | Virginia | 51660 | 22 | 0 |
30547 | 30547 | 2020-04-03 | Harrisonburg city | Virginia | 51660 | 22 | 0 |
28201 | 28201 | 2020-04-02 | Harrisonburg city | Virginia | 51660 | 15 | 0 |
25911 | 25911 | 2020-04-01 | Harrisonburg city | Virginia | 51660 | 10 | 0 |
23695 | 23695 | 2020-03-31 | Harrisonburg city | Virginia | 51660 | 6 | 0 |
21550 | 21550 | 2020-03-30 | Harrisonburg city | Virginia | 51660 | 6 | 0 |
19487 | 19487 | 2020-03-29 | Harrisonburg city | Virginia | 51660 | 5 | 0 |
17526 | 17526 | 2020-03-28 | Harrisonburg city | Virginia | 51660 | 5 | 0 |
15652 | 15652 | 2020-03-27 | Harrisonburg city | Virginia | 51660 | 5 | 0 |
13884 | 13884 | 2020-03-26 | Harrisonburg city | Virginia | 51660 | 3 | 0 |
12244 | 12244 | 2020-03-25 | Harrisonburg city | Virginia | 51660 | 2 | 0 |
10730 | 10730 | 2020-03-24 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
9382 | 9382 | 2020-03-23 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
8160 | 8160 | 2020-03-22 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
7026 | 7026 | 2020-03-21 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
5998 | 5998 | 2020-03-20 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
5100 | 5100 | 2020-03-19 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
4344 | 4344 | 2020-03-18 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
3711 | 3711 | 2020-03-17 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
3173 | 3173 | 2020-03-16 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
2701 | 2701 | 2020-03-15 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
2274 | 2274 | 2020-03-14 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
1902 | 1902 | 2020-03-13 | Harrisonburg city | Virginia | 51660 | 1 | 0 |
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);