ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 51770 and state = "Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15680 | 15680 | 2020-03-27 | Roanoke city | Virginia | 51770 | 1 | 0 |
17560 | 17560 | 2020-03-28 | Roanoke city | Virginia | 51770 | 1 | 0 |
19522 | 19522 | 2020-03-29 | Roanoke city | Virginia | 51770 | 1 | 0 |
21588 | 21588 | 2020-03-30 | Roanoke city | Virginia | 51770 | 6 | 0 |
23735 | 23735 | 2020-03-31 | Roanoke city | Virginia | 51770 | 6 | 0 |
25951 | 25951 | 2020-04-01 | Roanoke city | Virginia | 51770 | 6 | 0 |
28241 | 28241 | 2020-04-02 | Roanoke city | Virginia | 51770 | 9 | 0 |
30590 | 30590 | 2020-04-03 | Roanoke city | Virginia | 51770 | 9 | 0 |
32989 | 32989 | 2020-04-04 | Roanoke city | Virginia | 51770 | 10 | 0 |
35427 | 35427 | 2020-04-05 | Roanoke city | Virginia | 51770 | 10 | 0 |
37910 | 37910 | 2020-04-06 | Roanoke city | Virginia | 51770 | 11 | 0 |
40445 | 40445 | 2020-04-07 | Roanoke city | Virginia | 51770 | 12 | 0 |
43014 | 43014 | 2020-04-08 | Roanoke city | Virginia | 51770 | 14 | 0 |
45610 | 45610 | 2020-04-09 | Roanoke city | Virginia | 51770 | 15 | 0 |
48236 | 48236 | 2020-04-10 | Roanoke city | Virginia | 51770 | 16 | 0 |
50894 | 50894 | 2020-04-11 | Roanoke city | Virginia | 51770 | 17 | 0 |
53569 | 53569 | 2020-04-12 | Roanoke city | Virginia | 51770 | 20 | 0 |
56259 | 56259 | 2020-04-13 | Roanoke city | Virginia | 51770 | 21 | 0 |
58965 | 58965 | 2020-04-14 | Roanoke city | Virginia | 51770 | 21 | 0 |
61684 | 61684 | 2020-04-15 | Roanoke city | Virginia | 51770 | 22 | 0 |
64417 | 64417 | 2020-04-16 | Roanoke city | Virginia | 51770 | 24 | 0 |
67165 | 67165 | 2020-04-17 | Roanoke city | Virginia | 51770 | 24 | 0 |
69927 | 69927 | 2020-04-18 | Roanoke city | Virginia | 51770 | 24 | 0 |
72697 | 72697 | 2020-04-19 | Roanoke city | Virginia | 51770 | 24 | 0 |
75473 | 75473 | 2020-04-20 | Roanoke city | Virginia | 51770 | 24 | 0 |
78257 | 78257 | 2020-04-21 | Roanoke city | Virginia | 51770 | 25 | 0 |
81050 | 81050 | 2020-04-22 | Roanoke city | Virginia | 51770 | 27 | 0 |
83851 | 83851 | 2020-04-23 | Roanoke city | Virginia | 51770 | 28 | 0 |
86658 | 86658 | 2020-04-24 | Roanoke city | Virginia | 51770 | 33 | 0 |
89473 | 89473 | 2020-04-25 | Roanoke city | Virginia | 51770 | 33 | 0 |
92290 | 92290 | 2020-04-26 | Roanoke city | Virginia | 51770 | 33 | 0 |
95119 | 95119 | 2020-04-27 | Roanoke city | Virginia | 51770 | 33 | 0 |
97963 | 97963 | 2020-04-28 | Roanoke city | Virginia | 51770 | 35 | 0 |
100813 | 100813 | 2020-04-29 | Roanoke city | Virginia | 51770 | 57 | 0 |
103668 | 103668 | 2020-04-30 | Roanoke city | Virginia | 51770 | 73 | 0 |
106532 | 106532 | 2020-05-01 | Roanoke city | Virginia | 51770 | 80 | 0 |
109401 | 109401 | 2020-05-02 | Roanoke city | Virginia | 51770 | 80 | 0 |
112275 | 112275 | 2020-05-03 | Roanoke city | Virginia | 51770 | 81 | 0 |
115158 | 115158 | 2020-05-04 | Roanoke city | Virginia | 51770 | 81 | 0 |
118117 | 118117 | 2020-05-05 | Roanoke city | Virginia | 51770 | 82 | 0 |
121081 | 121081 | 2020-05-06 | Roanoke city | Virginia | 51770 | 82 | 0 |
124062 | 124062 | 2020-05-07 | Roanoke city | Virginia | 51770 | 88 | 1 |
127047 | 127047 | 2020-05-08 | Roanoke city | Virginia | 51770 | 91 | 1 |
130037 | 130037 | 2020-05-09 | Roanoke city | Virginia | 51770 | 93 | 1 |
133027 | 133027 | 2020-05-10 | Roanoke city | Virginia | 51770 | 93 | 1 |
136017 | 136017 | 2020-05-11 | Roanoke city | Virginia | 51770 | 106 | 1 |
139008 | 139008 | 2020-05-12 | Roanoke city | Virginia | 51770 | 108 | 1 |
142004 | 142004 | 2020-05-13 | Roanoke city | Virginia | 51770 | 116 | 1 |
145001 | 145001 | 2020-05-14 | Roanoke city | Virginia | 51770 | 120 | 1 |
148004 | 148004 | 2020-05-15 | Roanoke city | Virginia | 51770 | 120 | 1 |
151013 | 151013 | 2020-05-16 | Roanoke city | Virginia | 51770 | 120 | 8 |
154024 | 154024 | 2020-05-17 | Roanoke city | Virginia | 51770 | 120 | 8 |
157041 | 157041 | 2020-05-18 | Roanoke city | Virginia | 51770 | 128 | 8 |
160065 | 160065 | 2020-05-19 | Roanoke city | Virginia | 51770 | 135 | 8 |
163093 | 163093 | 2020-05-20 | Roanoke city | Virginia | 51770 | 135 | 8 |
166122 | 166122 | 2020-05-21 | Roanoke city | Virginia | 51770 | 135 | 8 |
169158 | 169158 | 2020-05-22 | Roanoke city | Virginia | 51770 | 140 | 9 |
172199 | 172199 | 2020-05-23 | Roanoke city | Virginia | 51770 | 141 | 9 |
175242 | 175242 | 2020-05-24 | Roanoke city | Virginia | 51770 | 140 | 9 |
178287 | 178287 | 2020-05-25 | Roanoke city | Virginia | 51770 | 140 | 9 |
181331 | 181331 | 2020-05-26 | Roanoke city | Virginia | 51770 | 146 | 9 |
184382 | 184382 | 2020-05-27 | Roanoke city | Virginia | 51770 | 146 | 9 |
187439 | 187439 | 2020-05-28 | Roanoke city | Virginia | 51770 | 147 | 9 |
190503 | 190503 | 2020-05-29 | Roanoke city | Virginia | 51770 | 152 | 9 |
193569 | 193569 | 2020-05-30 | Roanoke city | Virginia | 51770 | 155 | 9 |
196639 | 196639 | 2020-05-31 | Roanoke city | Virginia | 51770 | 160 | 9 |
199712 | 199712 | 2020-06-01 | Roanoke city | Virginia | 51770 | 167 | 9 |
202788 | 202788 | 2020-06-02 | Roanoke city | Virginia | 51770 | 171 | 9 |
205867 | 205867 | 2020-06-03 | Roanoke city | Virginia | 51770 | 176 | 10 |
208949 | 208949 | 2020-06-04 | Roanoke city | Virginia | 51770 | 176 | 10 |
212034 | 212034 | 2020-06-05 | Roanoke city | Virginia | 51770 | 190 | 10 |
215121 | 215121 | 2020-06-06 | Roanoke city | Virginia | 51770 | 197 | 10 |
218211 | 218211 | 2020-06-07 | Roanoke city | Virginia | 51770 | 199 | 10 |
221303 | 221303 | 2020-06-08 | Roanoke city | Virginia | 51770 | 199 | 10 |
224399 | 224399 | 2020-06-09 | Roanoke city | Virginia | 51770 | 204 | 10 |
227499 | 227499 | 2020-06-10 | Roanoke city | Virginia | 51770 | 207 | 10 |
230603 | 230603 | 2020-06-11 | Roanoke city | Virginia | 51770 | 222 | 10 |
233708 | 233708 | 2020-06-12 | Roanoke city | Virginia | 51770 | 232 | 10 |
236815 | 236815 | 2020-06-13 | Roanoke city | Virginia | 51770 | 247 | 10 |
239923 | 239923 | 2020-06-14 | Roanoke city | Virginia | 51770 | 250 | 10 |
243034 | 243034 | 2020-06-15 | Roanoke city | Virginia | 51770 | 250 | 10 |
246147 | 246147 | 2020-06-16 | Roanoke city | Virginia | 51770 | 270 | 10 |
249259 | 249259 | 2020-06-17 | Roanoke city | Virginia | 51770 | 277 | 10 |
252374 | 252374 | 2020-06-18 | Roanoke city | Virginia | 51770 | 277 | 10 |
255493 | 255493 | 2020-06-19 | Roanoke city | Virginia | 51770 | 291 | 10 |
258620 | 258620 | 2020-06-20 | Roanoke city | Virginia | 51770 | 308 | 10 |
261747 | 261747 | 2020-06-21 | Roanoke city | Virginia | 51770 | 313 | 10 |
264876 | 264876 | 2020-06-22 | Roanoke city | Virginia | 51770 | 324 | 10 |
268005 | 268005 | 2020-06-23 | Roanoke city | Virginia | 51770 | 343 | 10 |
271139 | 271139 | 2020-06-24 | Roanoke city | Virginia | 51770 | 359 | 10 |
274279 | 274279 | 2020-06-25 | Roanoke city | Virginia | 51770 | 359 | 10 |
277427 | 277427 | 2020-06-26 | Roanoke city | Virginia | 51770 | 360 | 10 |
280575 | 280575 | 2020-06-27 | Roanoke city | Virginia | 51770 | 363 | 10 |
283721 | 283721 | 2020-06-28 | Roanoke city | Virginia | 51770 | 368 | 10 |
286867 | 286867 | 2020-06-29 | Roanoke city | Virginia | 51770 | 403 | 10 |
290017 | 290017 | 2020-06-30 | Roanoke city | Virginia | 51770 | 439 | 9 |
293170 | 293170 | 2020-07-01 | Roanoke city | Virginia | 51770 | 438 | 10 |
296325 | 296325 | 2020-07-02 | Roanoke city | Virginia | 51770 | 436 | 10 |
299487 | 299487 | 2020-07-03 | Roanoke city | Virginia | 51770 | 465 | 10 |
302651 | 302651 | 2020-07-04 | Roanoke city | Virginia | 51770 | 476 | 10 |
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);