ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 51670 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 |
---|---|---|---|---|---|---|---|
17528 | 17528 | 2020-03-28 | Hopewell city | Virginia | 51670 | 1 | 0 |
19489 | 19489 | 2020-03-29 | Hopewell city | Virginia | 51670 | 1 | 0 |
21553 | 21553 | 2020-03-30 | Hopewell city | Virginia | 51670 | 3 | 0 |
23698 | 23698 | 2020-03-31 | Hopewell city | Virginia | 51670 | 4 | 0 |
25914 | 25914 | 2020-04-01 | Hopewell city | Virginia | 51670 | 4 | 0 |
28204 | 28204 | 2020-04-02 | Hopewell city | Virginia | 51670 | 5 | 0 |
30550 | 30550 | 2020-04-03 | Hopewell city | Virginia | 51670 | 7 | 0 |
32949 | 32949 | 2020-04-04 | Hopewell city | Virginia | 51670 | 9 | 0 |
35387 | 35387 | 2020-04-05 | Hopewell city | Virginia | 51670 | 10 | 0 |
37870 | 37870 | 2020-04-06 | Hopewell city | Virginia | 51670 | 10 | 0 |
40403 | 40403 | 2020-04-07 | Hopewell city | Virginia | 51670 | 13 | 0 |
42972 | 42972 | 2020-04-08 | Hopewell city | Virginia | 51670 | 13 | 0 |
45567 | 45567 | 2020-04-09 | Hopewell city | Virginia | 51670 | 13 | 0 |
48193 | 48193 | 2020-04-10 | Hopewell city | Virginia | 51670 | 14 | 0 |
50851 | 50851 | 2020-04-11 | Hopewell city | Virginia | 51670 | 14 | 0 |
53526 | 53526 | 2020-04-12 | Hopewell city | Virginia | 51670 | 14 | 0 |
56216 | 56216 | 2020-04-13 | Hopewell city | Virginia | 51670 | 14 | 0 |
58922 | 58922 | 2020-04-14 | Hopewell city | Virginia | 51670 | 14 | 0 |
61641 | 61641 | 2020-04-15 | Hopewell city | Virginia | 51670 | 14 | 0 |
64374 | 64374 | 2020-04-16 | Hopewell city | Virginia | 51670 | 14 | 0 |
67122 | 67122 | 2020-04-17 | Hopewell city | Virginia | 51670 | 14 | 0 |
69884 | 69884 | 2020-04-18 | Hopewell city | Virginia | 51670 | 16 | 0 |
72654 | 72654 | 2020-04-19 | Hopewell city | Virginia | 51670 | 16 | 0 |
75430 | 75430 | 2020-04-20 | Hopewell city | Virginia | 51670 | 16 | 0 |
78212 | 78212 | 2020-04-21 | Hopewell city | Virginia | 51670 | 16 | 0 |
81005 | 81005 | 2020-04-22 | Hopewell city | Virginia | 51670 | 16 | 0 |
83806 | 83806 | 2020-04-23 | Hopewell city | Virginia | 51670 | 19 | 0 |
86613 | 86613 | 2020-04-24 | Hopewell city | Virginia | 51670 | 19 | 0 |
89428 | 89428 | 2020-04-25 | Hopewell city | Virginia | 51670 | 21 | 0 |
92245 | 92245 | 2020-04-26 | Hopewell city | Virginia | 51670 | 22 | 0 |
95074 | 95074 | 2020-04-27 | Hopewell city | Virginia | 51670 | 24 | 0 |
97917 | 97917 | 2020-04-28 | Hopewell city | Virginia | 51670 | 24 | 0 |
100767 | 100767 | 2020-04-29 | Hopewell city | Virginia | 51670 | 24 | 0 |
103622 | 103622 | 2020-04-30 | Hopewell city | Virginia | 51670 | 24 | 0 |
106486 | 106486 | 2020-05-01 | Hopewell city | Virginia | 51670 | 25 | 0 |
109355 | 109355 | 2020-05-02 | Hopewell city | Virginia | 51670 | 27 | 0 |
112229 | 112229 | 2020-05-03 | Hopewell city | Virginia | 51670 | 27 | 0 |
115112 | 115112 | 2020-05-04 | Hopewell city | Virginia | 51670 | 31 | 0 |
118071 | 118071 | 2020-05-05 | Hopewell city | Virginia | 51670 | 31 | 0 |
121035 | 121035 | 2020-05-06 | Hopewell city | Virginia | 51670 | 31 | 0 |
124016 | 124016 | 2020-05-07 | Hopewell city | Virginia | 51670 | 33 | 0 |
127001 | 127001 | 2020-05-08 | Hopewell city | Virginia | 51670 | 33 | 0 |
129991 | 129991 | 2020-05-09 | Hopewell city | Virginia | 51670 | 33 | 0 |
132981 | 132981 | 2020-05-10 | Hopewell city | Virginia | 51670 | 37 | 0 |
135971 | 135971 | 2020-05-11 | Hopewell city | Virginia | 51670 | 39 | 0 |
138962 | 138962 | 2020-05-12 | Hopewell city | Virginia | 51670 | 44 | 0 |
141958 | 141958 | 2020-05-13 | Hopewell city | Virginia | 51670 | 45 | 0 |
144955 | 144955 | 2020-05-14 | Hopewell city | Virginia | 51670 | 48 | 0 |
147958 | 147958 | 2020-05-15 | Hopewell city | Virginia | 51670 | 49 | 0 |
150967 | 150967 | 2020-05-16 | Hopewell city | Virginia | 51670 | 49 | 0 |
153978 | 153978 | 2020-05-17 | Hopewell city | Virginia | 51670 | 51 | 0 |
156995 | 156995 | 2020-05-18 | Hopewell city | Virginia | 51670 | 53 | 0 |
160019 | 160019 | 2020-05-19 | Hopewell city | Virginia | 51670 | 58 | 0 |
163047 | 163047 | 2020-05-20 | Hopewell city | Virginia | 51670 | 61 | 0 |
166076 | 166076 | 2020-05-21 | Hopewell city | Virginia | 51670 | 62 | 0 |
169112 | 169112 | 2020-05-22 | Hopewell city | Virginia | 51670 | 66 | 0 |
172153 | 172153 | 2020-05-23 | Hopewell city | Virginia | 51670 | 67 | 0 |
175196 | 175196 | 2020-05-24 | Hopewell city | Virginia | 51670 | 66 | 0 |
178241 | 178241 | 2020-05-25 | Hopewell city | Virginia | 51670 | 66 | 0 |
181285 | 181285 | 2020-05-26 | Hopewell city | Virginia | 51670 | 73 | 0 |
184336 | 184336 | 2020-05-27 | Hopewell city | Virginia | 51670 | 78 | 0 |
187393 | 187393 | 2020-05-28 | Hopewell city | Virginia | 51670 | 81 | 0 |
190457 | 190457 | 2020-05-29 | Hopewell city | Virginia | 51670 | 85 | 0 |
193523 | 193523 | 2020-05-30 | Hopewell city | Virginia | 51670 | 87 | 0 |
196593 | 196593 | 2020-05-31 | Hopewell city | Virginia | 51670 | 90 | 0 |
199666 | 199666 | 2020-06-01 | Hopewell city | Virginia | 51670 | 92 | 1 |
202742 | 202742 | 2020-06-02 | Hopewell city | Virginia | 51670 | 96 | 1 |
205821 | 205821 | 2020-06-03 | Hopewell city | Virginia | 51670 | 98 | 1 |
208903 | 208903 | 2020-06-04 | Hopewell city | Virginia | 51670 | 103 | 2 |
211988 | 211988 | 2020-06-05 | Hopewell city | Virginia | 51670 | 110 | 2 |
215075 | 215075 | 2020-06-06 | Hopewell city | Virginia | 51670 | 114 | 2 |
218165 | 218165 | 2020-06-07 | Hopewell city | Virginia | 51670 | 116 | 2 |
221257 | 221257 | 2020-06-08 | Hopewell city | Virginia | 51670 | 118 | 2 |
224353 | 224353 | 2020-06-09 | Hopewell city | Virginia | 51670 | 118 | 2 |
227453 | 227453 | 2020-06-10 | Hopewell city | Virginia | 51670 | 120 | 2 |
230557 | 230557 | 2020-06-11 | Hopewell city | Virginia | 51670 | 120 | 2 |
233662 | 233662 | 2020-06-12 | Hopewell city | Virginia | 51670 | 129 | 2 |
236769 | 236769 | 2020-06-13 | Hopewell city | Virginia | 51670 | 138 | 2 |
239877 | 239877 | 2020-06-14 | Hopewell city | Virginia | 51670 | 138 | 2 |
242988 | 242988 | 2020-06-15 | Hopewell city | Virginia | 51670 | 141 | 2 |
246101 | 246101 | 2020-06-16 | Hopewell city | Virginia | 51670 | 144 | 2 |
249213 | 249213 | 2020-06-17 | Hopewell city | Virginia | 51670 | 149 | 2 |
252328 | 252328 | 2020-06-18 | Hopewell city | Virginia | 51670 | 150 | 2 |
255447 | 255447 | 2020-06-19 | Hopewell city | Virginia | 51670 | 151 | 2 |
258574 | 258574 | 2020-06-20 | Hopewell city | Virginia | 51670 | 151 | 2 |
261701 | 261701 | 2020-06-21 | Hopewell city | Virginia | 51670 | 151 | 2 |
264830 | 264830 | 2020-06-22 | Hopewell city | Virginia | 51670 | 152 | 2 |
267959 | 267959 | 2020-06-23 | Hopewell city | Virginia | 51670 | 155 | 2 |
271093 | 271093 | 2020-06-24 | Hopewell city | Virginia | 51670 | 163 | 2 |
274233 | 274233 | 2020-06-25 | Hopewell city | Virginia | 51670 | 163 | 2 |
277381 | 277381 | 2020-06-26 | Hopewell city | Virginia | 51670 | 163 | 2 |
280529 | 280529 | 2020-06-27 | Hopewell city | Virginia | 51670 | 169 | 2 |
283675 | 283675 | 2020-06-28 | Hopewell city | Virginia | 51670 | 169 | 2 |
286821 | 286821 | 2020-06-29 | Hopewell city | Virginia | 51670 | 169 | 2 |
289971 | 289971 | 2020-06-30 | Hopewell city | Virginia | 51670 | 174 | 2 |
293124 | 293124 | 2020-07-01 | Hopewell city | Virginia | 51670 | 176 | 2 |
296279 | 296279 | 2020-07-02 | Hopewell city | Virginia | 51670 | 182 | 2 |
299441 | 299441 | 2020-07-03 | Hopewell city | Virginia | 51670 | 184 | 2 |
302605 | 302605 | 2020-07-04 | Hopewell city | Virginia | 51670 | 185 | 2 |
305769 | 305769 | 2020-07-05 | Hopewell city | Virginia | 51670 | 186 | 2 |
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);