ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 51750 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 |
---|---|---|---|---|---|---|---|
13909 | 13909 | 2020-03-26 | Radford city | Virginia | 51750 | 1 | 0 |
15677 | 15677 | 2020-03-27 | Radford city | Virginia | 51750 | 1 | 0 |
17557 | 17557 | 2020-03-28 | Radford city | Virginia | 51750 | 1 | 0 |
19519 | 19519 | 2020-03-29 | Radford city | Virginia | 51750 | 1 | 0 |
21585 | 21585 | 2020-03-30 | Radford city | Virginia | 51750 | 1 | 0 |
23732 | 23732 | 2020-03-31 | Radford city | Virginia | 51750 | 1 | 0 |
25948 | 25948 | 2020-04-01 | Radford city | Virginia | 51750 | 1 | 0 |
28238 | 28238 | 2020-04-02 | Radford city | Virginia | 51750 | 1 | 0 |
30586 | 30586 | 2020-04-03 | Radford city | Virginia | 51750 | 1 | 0 |
32985 | 32985 | 2020-04-04 | Radford city | Virginia | 51750 | 1 | 0 |
35423 | 35423 | 2020-04-05 | Radford city | Virginia | 51750 | 1 | 0 |
37906 | 37906 | 2020-04-06 | Radford city | Virginia | 51750 | 1 | 0 |
40440 | 40440 | 2020-04-07 | Radford city | Virginia | 51750 | 1 | 0 |
43009 | 43009 | 2020-04-08 | Radford city | Virginia | 51750 | 1 | 0 |
45605 | 45605 | 2020-04-09 | Radford city | Virginia | 51750 | 1 | 0 |
48231 | 48231 | 2020-04-10 | Radford city | Virginia | 51750 | 1 | 0 |
50889 | 50889 | 2020-04-11 | Radford city | Virginia | 51750 | 1 | 0 |
53564 | 53564 | 2020-04-12 | Radford city | Virginia | 51750 | 1 | 0 |
56254 | 56254 | 2020-04-13 | Radford city | Virginia | 51750 | 1 | 0 |
58960 | 58960 | 2020-04-14 | Radford city | Virginia | 51750 | 1 | 0 |
61679 | 61679 | 2020-04-15 | Radford city | Virginia | 51750 | 1 | 0 |
64412 | 64412 | 2020-04-16 | Radford city | Virginia | 51750 | 1 | 0 |
67160 | 67160 | 2020-04-17 | Radford city | Virginia | 51750 | 1 | 0 |
69922 | 69922 | 2020-04-18 | Radford city | Virginia | 51750 | 1 | 0 |
72692 | 72692 | 2020-04-19 | Radford city | Virginia | 51750 | 1 | 0 |
75468 | 75468 | 2020-04-20 | Radford city | Virginia | 51750 | 1 | 0 |
78252 | 78252 | 2020-04-21 | Radford city | Virginia | 51750 | 1 | 0 |
81045 | 81045 | 2020-04-22 | Radford city | Virginia | 51750 | 2 | 0 |
83846 | 83846 | 2020-04-23 | Radford city | Virginia | 51750 | 2 | 0 |
86653 | 86653 | 2020-04-24 | Radford city | Virginia | 51750 | 2 | 0 |
89468 | 89468 | 2020-04-25 | Radford city | Virginia | 51750 | 3 | 0 |
92285 | 92285 | 2020-04-26 | Radford city | Virginia | 51750 | 3 | 0 |
95114 | 95114 | 2020-04-27 | Radford city | Virginia | 51750 | 3 | 0 |
97958 | 97958 | 2020-04-28 | Radford city | Virginia | 51750 | 3 | 0 |
100808 | 100808 | 2020-04-29 | Radford city | Virginia | 51750 | 3 | 0 |
103663 | 103663 | 2020-04-30 | Radford city | Virginia | 51750 | 3 | 0 |
106527 | 106527 | 2020-05-01 | Radford city | Virginia | 51750 | 3 | 0 |
109396 | 109396 | 2020-05-02 | Radford city | Virginia | 51750 | 3 | 0 |
112270 | 112270 | 2020-05-03 | Radford city | Virginia | 51750 | 3 | 0 |
115153 | 115153 | 2020-05-04 | Radford city | Virginia | 51750 | 3 | 0 |
118112 | 118112 | 2020-05-05 | Radford city | Virginia | 51750 | 3 | 0 |
121076 | 121076 | 2020-05-06 | Radford city | Virginia | 51750 | 3 | 0 |
124057 | 124057 | 2020-05-07 | Radford city | Virginia | 51750 | 3 | 0 |
127042 | 127042 | 2020-05-08 | Radford city | Virginia | 51750 | 3 | 0 |
130032 | 130032 | 2020-05-09 | Radford city | Virginia | 51750 | 3 | 0 |
133022 | 133022 | 2020-05-10 | Radford city | Virginia | 51750 | 3 | 0 |
136012 | 136012 | 2020-05-11 | Radford city | Virginia | 51750 | 3 | 0 |
139003 | 139003 | 2020-05-12 | Radford city | Virginia | 51750 | 3 | 0 |
141999 | 141999 | 2020-05-13 | Radford city | Virginia | 51750 | 3 | 0 |
144996 | 144996 | 2020-05-14 | Radford city | Virginia | 51750 | 3 | 0 |
147999 | 147999 | 2020-05-15 | Radford city | Virginia | 51750 | 3 | 0 |
151008 | 151008 | 2020-05-16 | Radford city | Virginia | 51750 | 3 | 0 |
154019 | 154019 | 2020-05-17 | Radford city | Virginia | 51750 | 3 | 0 |
157036 | 157036 | 2020-05-18 | Radford city | Virginia | 51750 | 3 | 0 |
160060 | 160060 | 2020-05-19 | Radford city | Virginia | 51750 | 3 | 0 |
163088 | 163088 | 2020-05-20 | Radford city | Virginia | 51750 | 4 | 0 |
166117 | 166117 | 2020-05-21 | Radford city | Virginia | 51750 | 4 | 0 |
169153 | 169153 | 2020-05-22 | Radford city | Virginia | 51750 | 4 | 0 |
172194 | 172194 | 2020-05-23 | Radford city | Virginia | 51750 | 4 | 0 |
175237 | 175237 | 2020-05-24 | Radford city | Virginia | 51750 | 6 | 0 |
178282 | 178282 | 2020-05-25 | Radford city | Virginia | 51750 | 7 | 0 |
181326 | 181326 | 2020-05-26 | Radford city | Virginia | 51750 | 7 | 0 |
184377 | 184377 | 2020-05-27 | Radford city | Virginia | 51750 | 7 | 0 |
187434 | 187434 | 2020-05-28 | Radford city | Virginia | 51750 | 6 | 0 |
190498 | 190498 | 2020-05-29 | Radford city | Virginia | 51750 | 6 | 0 |
193564 | 193564 | 2020-05-30 | Radford city | Virginia | 51750 | 6 | 0 |
196634 | 196634 | 2020-05-31 | Radford city | Virginia | 51750 | 6 | 0 |
199707 | 199707 | 2020-06-01 | Radford city | Virginia | 51750 | 6 | 0 |
202783 | 202783 | 2020-06-02 | Radford city | Virginia | 51750 | 6 | 0 |
205862 | 205862 | 2020-06-03 | Radford city | Virginia | 51750 | 6 | 0 |
208944 | 208944 | 2020-06-04 | Radford city | Virginia | 51750 | 6 | 0 |
212029 | 212029 | 2020-06-05 | Radford city | Virginia | 51750 | 6 | 0 |
215116 | 215116 | 2020-06-06 | Radford city | Virginia | 51750 | 7 | 0 |
218206 | 218206 | 2020-06-07 | Radford city | Virginia | 51750 | 7 | 0 |
221298 | 221298 | 2020-06-08 | Radford city | Virginia | 51750 | 7 | 0 |
224394 | 224394 | 2020-06-09 | Radford city | Virginia | 51750 | 7 | 0 |
227494 | 227494 | 2020-06-10 | Radford city | Virginia | 51750 | 7 | 0 |
230598 | 230598 | 2020-06-11 | Radford city | Virginia | 51750 | 7 | 0 |
233703 | 233703 | 2020-06-12 | Radford city | Virginia | 51750 | 7 | 0 |
236810 | 236810 | 2020-06-13 | Radford city | Virginia | 51750 | 8 | 0 |
239918 | 239918 | 2020-06-14 | Radford city | Virginia | 51750 | 8 | 0 |
243029 | 243029 | 2020-06-15 | Radford city | Virginia | 51750 | 8 | 0 |
246142 | 246142 | 2020-06-16 | Radford city | Virginia | 51750 | 9 | 0 |
249254 | 249254 | 2020-06-17 | Radford city | Virginia | 51750 | 9 | 0 |
252369 | 252369 | 2020-06-18 | Radford city | Virginia | 51750 | 9 | 0 |
255488 | 255488 | 2020-06-19 | Radford city | Virginia | 51750 | 9 | 0 |
258615 | 258615 | 2020-06-20 | Radford city | Virginia | 51750 | 9 | 0 |
261742 | 261742 | 2020-06-21 | Radford city | Virginia | 51750 | 10 | 0 |
264871 | 264871 | 2020-06-22 | Radford city | Virginia | 51750 | 10 | 0 |
268000 | 268000 | 2020-06-23 | Radford city | Virginia | 51750 | 10 | 0 |
271134 | 271134 | 2020-06-24 | Radford city | Virginia | 51750 | 11 | 0 |
274274 | 274274 | 2020-06-25 | Radford city | Virginia | 51750 | 11 | 0 |
277422 | 277422 | 2020-06-26 | Radford city | Virginia | 51750 | 11 | 0 |
280570 | 280570 | 2020-06-27 | Radford city | Virginia | 51750 | 11 | 0 |
283716 | 283716 | 2020-06-28 | Radford city | Virginia | 51750 | 11 | 0 |
286862 | 286862 | 2020-06-29 | Radford city | Virginia | 51750 | 11 | 0 |
290012 | 290012 | 2020-06-30 | Radford city | Virginia | 51750 | 11 | 0 |
293165 | 293165 | 2020-07-01 | Radford city | Virginia | 51750 | 12 | 0 |
296320 | 296320 | 2020-07-02 | Radford city | Virginia | 51750 | 13 | 0 |
299482 | 299482 | 2020-07-03 | Radford city | Virginia | 51750 | 14 | 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);