ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Henry" and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
21552 | 21552 | 2020-03-30 | Henry | Virginia | 51089 | 1 | 0 |
23697 | 23697 | 2020-03-31 | Henry | Virginia | 51089 | 1 | 0 |
25913 | 25913 | 2020-04-01 | Henry | Virginia | 51089 | 2 | 0 |
28203 | 28203 | 2020-04-02 | Henry | Virginia | 51089 | 2 | 0 |
30549 | 30549 | 2020-04-03 | Henry | Virginia | 51089 | 3 | 0 |
32948 | 32948 | 2020-04-04 | Henry | Virginia | 51089 | 3 | 0 |
35386 | 35386 | 2020-04-05 | Henry | Virginia | 51089 | 3 | 0 |
37869 | 37869 | 2020-04-06 | Henry | Virginia | 51089 | 3 | 0 |
40402 | 40402 | 2020-04-07 | Henry | Virginia | 51089 | 4 | 0 |
42971 | 42971 | 2020-04-08 | Henry | Virginia | 51089 | 4 | 0 |
45566 | 45566 | 2020-04-09 | Henry | Virginia | 51089 | 5 | 0 |
48192 | 48192 | 2020-04-10 | Henry | Virginia | 51089 | 5 | 0 |
50850 | 50850 | 2020-04-11 | Henry | Virginia | 51089 | 8 | 0 |
53525 | 53525 | 2020-04-12 | Henry | Virginia | 51089 | 8 | 0 |
56215 | 56215 | 2020-04-13 | Henry | Virginia | 51089 | 8 | 0 |
58921 | 58921 | 2020-04-14 | Henry | Virginia | 51089 | 8 | 0 |
61640 | 61640 | 2020-04-15 | Henry | Virginia | 51089 | 8 | 0 |
64373 | 64373 | 2020-04-16 | Henry | Virginia | 51089 | 8 | 0 |
67121 | 67121 | 2020-04-17 | Henry | Virginia | 51089 | 10 | 0 |
69883 | 69883 | 2020-04-18 | Henry | Virginia | 51089 | 10 | 0 |
72653 | 72653 | 2020-04-19 | Henry | Virginia | 51089 | 10 | 0 |
75429 | 75429 | 2020-04-20 | Henry | Virginia | 51089 | 10 | 0 |
78211 | 78211 | 2020-04-21 | Henry | Virginia | 51089 | 10 | 1 |
81003 | 81003 | 2020-04-22 | Henry | Virginia | 51089 | 10 | 1 |
83804 | 83804 | 2020-04-23 | Henry | Virginia | 51089 | 10 | 1 |
86611 | 86611 | 2020-04-24 | Henry | Virginia | 51089 | 12 | 1 |
89426 | 89426 | 2020-04-25 | Henry | Virginia | 51089 | 13 | 1 |
92243 | 92243 | 2020-04-26 | Henry | Virginia | 51089 | 14 | 1 |
95072 | 95072 | 2020-04-27 | Henry | Virginia | 51089 | 15 | 1 |
97915 | 97915 | 2020-04-28 | Henry | Virginia | 51089 | 16 | 1 |
100765 | 100765 | 2020-04-29 | Henry | Virginia | 51089 | 16 | 1 |
103620 | 103620 | 2020-04-30 | Henry | Virginia | 51089 | 16 | 1 |
106484 | 106484 | 2020-05-01 | Henry | Virginia | 51089 | 16 | 1 |
109353 | 109353 | 2020-05-02 | Henry | Virginia | 51089 | 19 | 1 |
112227 | 112227 | 2020-05-03 | Henry | Virginia | 51089 | 19 | 1 |
115110 | 115110 | 2020-05-04 | Henry | Virginia | 51089 | 19 | 1 |
118069 | 118069 | 2020-05-05 | Henry | Virginia | 51089 | 19 | 1 |
121033 | 121033 | 2020-05-06 | Henry | Virginia | 51089 | 19 | 1 |
124014 | 124014 | 2020-05-07 | Henry | Virginia | 51089 | 20 | 1 |
126999 | 126999 | 2020-05-08 | Henry | Virginia | 51089 | 21 | 1 |
129989 | 129989 | 2020-05-09 | Henry | Virginia | 51089 | 22 | 1 |
132979 | 132979 | 2020-05-10 | Henry | Virginia | 51089 | 22 | 1 |
135969 | 135969 | 2020-05-11 | Henry | Virginia | 51089 | 25 | 1 |
138960 | 138960 | 2020-05-12 | Henry | Virginia | 51089 | 27 | 1 |
141956 | 141956 | 2020-05-13 | Henry | Virginia | 51089 | 28 | 1 |
144953 | 144953 | 2020-05-14 | Henry | Virginia | 51089 | 28 | 1 |
147956 | 147956 | 2020-05-15 | Henry | Virginia | 51089 | 30 | 1 |
150965 | 150965 | 2020-05-16 | Henry | Virginia | 51089 | 34 | 2 |
153976 | 153976 | 2020-05-17 | Henry | Virginia | 51089 | 36 | 2 |
156993 | 156993 | 2020-05-18 | Henry | Virginia | 51089 | 43 | 2 |
160017 | 160017 | 2020-05-19 | Henry | Virginia | 51089 | 46 | 2 |
163045 | 163045 | 2020-05-20 | Henry | Virginia | 51089 | 50 | 2 |
166074 | 166074 | 2020-05-21 | Henry | Virginia | 51089 | 53 | 2 |
169110 | 169110 | 2020-05-22 | Henry | Virginia | 51089 | 59 | 2 |
172151 | 172151 | 2020-05-23 | Henry | Virginia | 51089 | 63 | 2 |
175194 | 175194 | 2020-05-24 | Henry | Virginia | 51089 | 67 | 2 |
178239 | 178239 | 2020-05-25 | Henry | Virginia | 51089 | 77 | 2 |
181283 | 181283 | 2020-05-26 | Henry | Virginia | 51089 | 84 | 2 |
184334 | 184334 | 2020-05-27 | Henry | Virginia | 51089 | 92 | 3 |
187391 | 187391 | 2020-05-28 | Henry | Virginia | 51089 | 95 | 3 |
190455 | 190455 | 2020-05-29 | Henry | Virginia | 51089 | 99 | 3 |
193521 | 193521 | 2020-05-30 | Henry | Virginia | 51089 | 104 | 3 |
196591 | 196591 | 2020-05-31 | Henry | Virginia | 51089 | 113 | 3 |
199664 | 199664 | 2020-06-01 | Henry | Virginia | 51089 | 114 | 3 |
202740 | 202740 | 2020-06-02 | Henry | Virginia | 51089 | 136 | 3 |
205819 | 205819 | 2020-06-03 | Henry | Virginia | 51089 | 145 | 3 |
208901 | 208901 | 2020-06-04 | Henry | Virginia | 51089 | 152 | 3 |
211986 | 211986 | 2020-06-05 | Henry | Virginia | 51089 | 155 | 3 |
215073 | 215073 | 2020-06-06 | Henry | Virginia | 51089 | 159 | 3 |
218163 | 218163 | 2020-06-07 | Henry | Virginia | 51089 | 166 | 3 |
221255 | 221255 | 2020-06-08 | Henry | Virginia | 51089 | 169 | 3 |
224351 | 224351 | 2020-06-09 | Henry | Virginia | 51089 | 174 | 3 |
227451 | 227451 | 2020-06-10 | Henry | Virginia | 51089 | 182 | 3 |
230555 | 230555 | 2020-06-11 | Henry | Virginia | 51089 | 188 | 3 |
233660 | 233660 | 2020-06-12 | Henry | Virginia | 51089 | 193 | 3 |
236767 | 236767 | 2020-06-13 | Henry | Virginia | 51089 | 198 | 3 |
239875 | 239875 | 2020-06-14 | Henry | Virginia | 51089 | 199 | 3 |
242986 | 242986 | 2020-06-15 | Henry | Virginia | 51089 | 202 | 3 |
246099 | 246099 | 2020-06-16 | Henry | Virginia | 51089 | 210 | 3 |
249211 | 249211 | 2020-06-17 | Henry | Virginia | 51089 | 212 | 3 |
252326 | 252326 | 2020-06-18 | Henry | Virginia | 51089 | 214 | 3 |
255445 | 255445 | 2020-06-19 | Henry | Virginia | 51089 | 224 | 3 |
258572 | 258572 | 2020-06-20 | Henry | Virginia | 51089 | 227 | 3 |
261699 | 261699 | 2020-06-21 | Henry | Virginia | 51089 | 226 | 3 |
264828 | 264828 | 2020-06-22 | Henry | Virginia | 51089 | 227 | 3 |
267957 | 267957 | 2020-06-23 | Henry | Virginia | 51089 | 228 | 4 |
271091 | 271091 | 2020-06-24 | Henry | Virginia | 51089 | 230 | 4 |
274231 | 274231 | 2020-06-25 | Henry | Virginia | 51089 | 232 | 4 |
277379 | 277379 | 2020-06-26 | Henry | Virginia | 51089 | 237 | 4 |
280527 | 280527 | 2020-06-27 | Henry | Virginia | 51089 | 243 | 4 |
283673 | 283673 | 2020-06-28 | Henry | Virginia | 51089 | 249 | 4 |
286819 | 286819 | 2020-06-29 | Henry | Virginia | 51089 | 250 | 4 |
289969 | 289969 | 2020-06-30 | Henry | Virginia | 51089 | 260 | 4 |
293122 | 293122 | 2020-07-01 | Henry | Virginia | 51089 | 264 | 4 |
296277 | 296277 | 2020-07-02 | Henry | Virginia | 51089 | 273 | 4 |
299439 | 299439 | 2020-07-03 | Henry | Virginia | 51089 | 280 | 4 |
302603 | 302603 | 2020-07-04 | Henry | Virginia | 51089 | 284 | 4 |
305767 | 305767 | 2020-07-05 | Henry | Virginia | 51089 | 288 | 4 |
308935 | 308935 | 2020-07-06 | Henry | Virginia | 51089 | 293 | 4 |
312104 | 312104 | 2020-07-07 | Henry | Virginia | 51089 | 301 | 5 |
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);