ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 51161 and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12264 | 12264 | 2020-03-25 | Roanoke | Virginia | 51161 | 1 | 0 |
13911 | 13911 | 2020-03-26 | Roanoke | Virginia | 51161 | 1 | 0 |
15679 | 15679 | 2020-03-27 | Roanoke | Virginia | 51161 | 1 | 0 |
17559 | 17559 | 2020-03-28 | Roanoke | Virginia | 51161 | 1 | 0 |
19521 | 19521 | 2020-03-29 | Roanoke | Virginia | 51161 | 2 | 0 |
21587 | 21587 | 2020-03-30 | Roanoke | Virginia | 51161 | 2 | 0 |
23734 | 23734 | 2020-03-31 | Roanoke | Virginia | 51161 | 3 | 0 |
25950 | 25950 | 2020-04-01 | Roanoke | Virginia | 51161 | 4 | 0 |
28240 | 28240 | 2020-04-02 | Roanoke | Virginia | 51161 | 4 | 0 |
30589 | 30589 | 2020-04-03 | Roanoke | Virginia | 51161 | 4 | 0 |
32988 | 32988 | 2020-04-04 | Roanoke | Virginia | 51161 | 5 | 0 |
35426 | 35426 | 2020-04-05 | Roanoke | Virginia | 51161 | 5 | 0 |
37909 | 37909 | 2020-04-06 | Roanoke | Virginia | 51161 | 5 | 0 |
40444 | 40444 | 2020-04-07 | Roanoke | Virginia | 51161 | 8 | 0 |
43013 | 43013 | 2020-04-08 | Roanoke | Virginia | 51161 | 9 | 0 |
45609 | 45609 | 2020-04-09 | Roanoke | Virginia | 51161 | 9 | 0 |
48235 | 48235 | 2020-04-10 | Roanoke | Virginia | 51161 | 13 | 0 |
50893 | 50893 | 2020-04-11 | Roanoke | Virginia | 51161 | 13 | 0 |
53568 | 53568 | 2020-04-12 | Roanoke | Virginia | 51161 | 14 | 0 |
56258 | 56258 | 2020-04-13 | Roanoke | Virginia | 51161 | 18 | 0 |
58964 | 58964 | 2020-04-14 | Roanoke | Virginia | 51161 | 16 | 0 |
61683 | 61683 | 2020-04-15 | Roanoke | Virginia | 51161 | 17 | 0 |
64416 | 64416 | 2020-04-16 | Roanoke | Virginia | 51161 | 19 | 0 |
67164 | 67164 | 2020-04-17 | Roanoke | Virginia | 51161 | 20 | 0 |
69926 | 69926 | 2020-04-18 | Roanoke | Virginia | 51161 | 20 | 0 |
72696 | 72696 | 2020-04-19 | Roanoke | Virginia | 51161 | 22 | 0 |
75472 | 75472 | 2020-04-20 | Roanoke | Virginia | 51161 | 24 | 0 |
78256 | 78256 | 2020-04-21 | Roanoke | Virginia | 51161 | 25 | 0 |
81049 | 81049 | 2020-04-22 | Roanoke | Virginia | 51161 | 31 | 0 |
83850 | 83850 | 2020-04-23 | Roanoke | Virginia | 51161 | 34 | 0 |
86657 | 86657 | 2020-04-24 | Roanoke | Virginia | 51161 | 39 | 0 |
89472 | 89472 | 2020-04-25 | Roanoke | Virginia | 51161 | 39 | 0 |
92289 | 92289 | 2020-04-26 | Roanoke | Virginia | 51161 | 39 | 0 |
95118 | 95118 | 2020-04-27 | Roanoke | Virginia | 51161 | 41 | 0 |
97962 | 97962 | 2020-04-28 | Roanoke | Virginia | 51161 | 41 | 0 |
100812 | 100812 | 2020-04-29 | Roanoke | Virginia | 51161 | 47 | 0 |
103667 | 103667 | 2020-04-30 | Roanoke | Virginia | 51161 | 51 | 0 |
106531 | 106531 | 2020-05-01 | Roanoke | Virginia | 51161 | 53 | 0 |
109400 | 109400 | 2020-05-02 | Roanoke | Virginia | 51161 | 54 | 0 |
112274 | 112274 | 2020-05-03 | Roanoke | Virginia | 51161 | 57 | 0 |
115157 | 115157 | 2020-05-04 | Roanoke | Virginia | 51161 | 57 | 0 |
118116 | 118116 | 2020-05-05 | Roanoke | Virginia | 51161 | 57 | 0 |
121080 | 121080 | 2020-05-06 | Roanoke | Virginia | 51161 | 57 | 0 |
124061 | 124061 | 2020-05-07 | Roanoke | Virginia | 51161 | 60 | 0 |
127046 | 127046 | 2020-05-08 | Roanoke | Virginia | 51161 | 62 | 0 |
130036 | 130036 | 2020-05-09 | Roanoke | Virginia | 51161 | 62 | 0 |
133026 | 133026 | 2020-05-10 | Roanoke | Virginia | 51161 | 62 | 0 |
136016 | 136016 | 2020-05-11 | Roanoke | Virginia | 51161 | 79 | 0 |
139007 | 139007 | 2020-05-12 | Roanoke | Virginia | 51161 | 79 | 0 |
142003 | 142003 | 2020-05-13 | Roanoke | Virginia | 51161 | 80 | 0 |
145000 | 145000 | 2020-05-14 | Roanoke | Virginia | 51161 | 83 | 1 |
148003 | 148003 | 2020-05-15 | Roanoke | Virginia | 51161 | 83 | 1 |
151012 | 151012 | 2020-05-16 | Roanoke | Virginia | 51161 | 84 | 3 |
154023 | 154023 | 2020-05-17 | Roanoke | Virginia | 51161 | 85 | 3 |
157040 | 157040 | 2020-05-18 | Roanoke | Virginia | 51161 | 86 | 3 |
160064 | 160064 | 2020-05-19 | Roanoke | Virginia | 51161 | 88 | 3 |
163092 | 163092 | 2020-05-20 | Roanoke | Virginia | 51161 | 88 | 3 |
166121 | 166121 | 2020-05-21 | Roanoke | Virginia | 51161 | 89 | 3 |
169157 | 169157 | 2020-05-22 | Roanoke | Virginia | 51161 | 90 | 5 |
172198 | 172198 | 2020-05-23 | Roanoke | Virginia | 51161 | 90 | 5 |
175241 | 175241 | 2020-05-24 | Roanoke | Virginia | 51161 | 90 | 5 |
178286 | 178286 | 2020-05-25 | Roanoke | Virginia | 51161 | 94 | 7 |
181330 | 181330 | 2020-05-26 | Roanoke | Virginia | 51161 | 96 | 7 |
184381 | 184381 | 2020-05-27 | Roanoke | Virginia | 51161 | 96 | 7 |
187438 | 187438 | 2020-05-28 | Roanoke | Virginia | 51161 | 97 | 7 |
190502 | 190502 | 2020-05-29 | Roanoke | Virginia | 51161 | 102 | 7 |
193568 | 193568 | 2020-05-30 | Roanoke | Virginia | 51161 | 104 | 7 |
196638 | 196638 | 2020-05-31 | Roanoke | Virginia | 51161 | 105 | 7 |
199711 | 199711 | 2020-06-01 | Roanoke | Virginia | 51161 | 106 | 7 |
202787 | 202787 | 2020-06-02 | Roanoke | Virginia | 51161 | 110 | 7 |
205866 | 205866 | 2020-06-03 | Roanoke | Virginia | 51161 | 113 | 6 |
208948 | 208948 | 2020-06-04 | Roanoke | Virginia | 51161 | 113 | 6 |
212033 | 212033 | 2020-06-05 | Roanoke | Virginia | 51161 | 119 | 6 |
215120 | 215120 | 2020-06-06 | Roanoke | Virginia | 51161 | 122 | 6 |
218210 | 218210 | 2020-06-07 | Roanoke | Virginia | 51161 | 122 | 6 |
221302 | 221302 | 2020-06-08 | Roanoke | Virginia | 51161 | 122 | 6 |
224398 | 224398 | 2020-06-09 | Roanoke | Virginia | 51161 | 126 | 6 |
227498 | 227498 | 2020-06-10 | Roanoke | Virginia | 51161 | 125 | 5 |
230602 | 230602 | 2020-06-11 | Roanoke | Virginia | 51161 | 128 | 5 |
233707 | 233707 | 2020-06-12 | Roanoke | Virginia | 51161 | 132 | 5 |
236814 | 236814 | 2020-06-13 | Roanoke | Virginia | 51161 | 134 | 5 |
239922 | 239922 | 2020-06-14 | Roanoke | Virginia | 51161 | 134 | 5 |
243033 | 243033 | 2020-06-15 | Roanoke | Virginia | 51161 | 134 | 5 |
246146 | 246146 | 2020-06-16 | Roanoke | Virginia | 51161 | 141 | 5 |
249258 | 249258 | 2020-06-17 | Roanoke | Virginia | 51161 | 148 | 5 |
252373 | 252373 | 2020-06-18 | Roanoke | Virginia | 51161 | 149 | 5 |
255492 | 255492 | 2020-06-19 | Roanoke | Virginia | 51161 | 161 | 5 |
258619 | 258619 | 2020-06-20 | Roanoke | Virginia | 51161 | 171 | 5 |
261746 | 261746 | 2020-06-21 | Roanoke | Virginia | 51161 | 171 | 5 |
264875 | 264875 | 2020-06-22 | Roanoke | Virginia | 51161 | 177 | 5 |
268004 | 268004 | 2020-06-23 | Roanoke | Virginia | 51161 | 195 | 5 |
271138 | 271138 | 2020-06-24 | Roanoke | Virginia | 51161 | 200 | 5 |
274278 | 274278 | 2020-06-25 | Roanoke | Virginia | 51161 | 200 | 5 |
277426 | 277426 | 2020-06-26 | Roanoke | Virginia | 51161 | 199 | 5 |
280574 | 280574 | 2020-06-27 | Roanoke | Virginia | 51161 | 200 | 5 |
283720 | 283720 | 2020-06-28 | Roanoke | Virginia | 51161 | 206 | 5 |
286866 | 286866 | 2020-06-29 | Roanoke | Virginia | 51161 | 234 | 5 |
290016 | 290016 | 2020-06-30 | Roanoke | Virginia | 51161 | 254 | 6 |
293169 | 293169 | 2020-07-01 | Roanoke | Virginia | 51161 | 253 | 6 |
296324 | 296324 | 2020-07-02 | Roanoke | Virginia | 51161 | 260 | 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);