ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 51075 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388883 | 388883 | 2020-07-31 | Goochland | Virginia | 51075 | 150 | 7 |
385666 | 385666 | 2020-07-30 | Goochland | Virginia | 51075 | 149 | 7 |
382448 | 382448 | 2020-07-29 | Goochland | Virginia | 51075 | 149 | 7 |
379231 | 379231 | 2020-07-28 | Goochland | Virginia | 51075 | 148 | 7 |
376015 | 376015 | 2020-07-27 | Goochland | Virginia | 51075 | 147 | 6 |
372801 | 372801 | 2020-07-26 | Goochland | Virginia | 51075 | 145 | 6 |
369589 | 369589 | 2020-07-25 | Goochland | Virginia | 51075 | 144 | 6 |
366380 | 366380 | 2020-07-24 | Goochland | Virginia | 51075 | 144 | 6 |
363174 | 363174 | 2020-07-23 | Goochland | Virginia | 51075 | 143 | 6 |
359968 | 359968 | 2020-07-22 | Goochland | Virginia | 51075 | 142 | 6 |
356763 | 356763 | 2020-07-21 | Goochland | Virginia | 51075 | 141 | 6 |
353560 | 353560 | 2020-07-20 | Goochland | Virginia | 51075 | 139 | 6 |
350358 | 350358 | 2020-07-19 | Goochland | Virginia | 51075 | 139 | 6 |
347157 | 347157 | 2020-07-18 | Goochland | Virginia | 51075 | 138 | 6 |
343957 | 343957 | 2020-07-17 | Goochland | Virginia | 51075 | 138 | 6 |
340758 | 340758 | 2020-07-16 | Goochland | Virginia | 51075 | 135 | 6 |
337562 | 337562 | 2020-07-15 | Goochland | Virginia | 51075 | 135 | 6 |
334367 | 334367 | 2020-07-14 | Goochland | Virginia | 51075 | 131 | 6 |
331174 | 331174 | 2020-07-13 | Goochland | Virginia | 51075 | 131 | 6 |
327988 | 327988 | 2020-07-12 | Goochland | Virginia | 51075 | 130 | 6 |
324803 | 324803 | 2020-07-11 | Goochland | Virginia | 51075 | 129 | 6 |
321622 | 321622 | 2020-07-10 | Goochland | Virginia | 51075 | 129 | 6 |
318443 | 318443 | 2020-07-09 | Goochland | Virginia | 51075 | 129 | 6 |
315270 | 315270 | 2020-07-08 | Goochland | Virginia | 51075 | 128 | 6 |
312095 | 312095 | 2020-07-07 | Goochland | Virginia | 51075 | 128 | 6 |
308926 | 308926 | 2020-07-06 | Goochland | Virginia | 51075 | 127 | 6 |
305758 | 305758 | 2020-07-05 | Goochland | Virginia | 51075 | 127 | 6 |
302594 | 302594 | 2020-07-04 | Goochland | Virginia | 51075 | 126 | 6 |
299430 | 299430 | 2020-07-03 | Goochland | Virginia | 51075 | 126 | 6 |
296268 | 296268 | 2020-07-02 | Goochland | Virginia | 51075 | 121 | 6 |
293113 | 293113 | 2020-07-01 | Goochland | Virginia | 51075 | 120 | 6 |
289960 | 289960 | 2020-06-30 | Goochland | Virginia | 51075 | 119 | 6 |
286810 | 286810 | 2020-06-29 | Goochland | Virginia | 51075 | 119 | 6 |
283664 | 283664 | 2020-06-28 | Goochland | Virginia | 51075 | 119 | 6 |
280518 | 280518 | 2020-06-27 | Goochland | Virginia | 51075 | 118 | 6 |
277370 | 277370 | 2020-06-26 | Goochland | Virginia | 51075 | 118 | 6 |
274222 | 274222 | 2020-06-25 | Goochland | Virginia | 51075 | 118 | 6 |
271082 | 271082 | 2020-06-24 | Goochland | Virginia | 51075 | 118 | 6 |
267948 | 267948 | 2020-06-23 | Goochland | Virginia | 51075 | 118 | 6 |
264819 | 264819 | 2020-06-22 | Goochland | Virginia | 51075 | 116 | 6 |
261690 | 261690 | 2020-06-21 | Goochland | Virginia | 51075 | 115 | 6 |
258563 | 258563 | 2020-06-20 | Goochland | Virginia | 51075 | 115 | 6 |
255436 | 255436 | 2020-06-19 | Goochland | Virginia | 51075 | 115 | 6 |
252317 | 252317 | 2020-06-18 | Goochland | Virginia | 51075 | 116 | 6 |
249202 | 249202 | 2020-06-17 | Goochland | Virginia | 51075 | 116 | 6 |
246090 | 246090 | 2020-06-16 | Goochland | Virginia | 51075 | 116 | 6 |
242977 | 242977 | 2020-06-15 | Goochland | Virginia | 51075 | 116 | 6 |
239866 | 239866 | 2020-06-14 | Goochland | Virginia | 51075 | 114 | 6 |
236758 | 236758 | 2020-06-13 | Goochland | Virginia | 51075 | 114 | 6 |
233651 | 233651 | 2020-06-12 | Goochland | Virginia | 51075 | 112 | 6 |
230546 | 230546 | 2020-06-11 | Goochland | Virginia | 51075 | 109 | 6 |
227442 | 227442 | 2020-06-10 | Goochland | Virginia | 51075 | 106 | 6 |
224342 | 224342 | 2020-06-09 | Goochland | Virginia | 51075 | 108 | 6 |
221246 | 221246 | 2020-06-08 | Goochland | Virginia | 51075 | 107 | 6 |
218154 | 218154 | 2020-06-07 | Goochland | Virginia | 51075 | 107 | 6 |
215064 | 215064 | 2020-06-06 | Goochland | Virginia | 51075 | 105 | 6 |
211977 | 211977 | 2020-06-05 | Goochland | Virginia | 51075 | 105 | 6 |
208892 | 208892 | 2020-06-04 | Goochland | Virginia | 51075 | 103 | 6 |
205810 | 205810 | 2020-06-03 | Goochland | Virginia | 51075 | 103 | 6 |
202731 | 202731 | 2020-06-02 | Goochland | Virginia | 51075 | 101 | 6 |
199655 | 199655 | 2020-06-01 | Goochland | Virginia | 51075 | 99 | 6 |
196582 | 196582 | 2020-05-31 | Goochland | Virginia | 51075 | 99 | 6 |
193512 | 193512 | 2020-05-30 | Goochland | Virginia | 51075 | 96 | 6 |
190446 | 190446 | 2020-05-29 | Goochland | Virginia | 51075 | 95 | 6 |
187382 | 187382 | 2020-05-28 | Goochland | Virginia | 51075 | 93 | 6 |
184325 | 184325 | 2020-05-27 | Goochland | Virginia | 51075 | 94 | 6 |
181274 | 181274 | 2020-05-26 | Goochland | Virginia | 51075 | 93 | 6 |
178230 | 178230 | 2020-05-25 | Goochland | Virginia | 51075 | 93 | 6 |
175185 | 175185 | 2020-05-24 | Goochland | Virginia | 51075 | 90 | 5 |
172142 | 172142 | 2020-05-23 | Goochland | Virginia | 51075 | 90 | 5 |
169101 | 169101 | 2020-05-22 | Goochland | Virginia | 51075 | 89 | 5 |
166065 | 166065 | 2020-05-21 | Goochland | Virginia | 51075 | 89 | 5 |
163036 | 163036 | 2020-05-20 | Goochland | Virginia | 51075 | 88 | 5 |
160008 | 160008 | 2020-05-19 | Goochland | Virginia | 51075 | 88 | 5 |
156984 | 156984 | 2020-05-18 | Goochland | Virginia | 51075 | 88 | 5 |
153967 | 153967 | 2020-05-17 | Goochland | Virginia | 51075 | 87 | 5 |
150956 | 150956 | 2020-05-16 | Goochland | Virginia | 51075 | 87 | 5 |
147947 | 147947 | 2020-05-15 | Goochland | Virginia | 51075 | 86 | 5 |
144944 | 144944 | 2020-05-14 | Goochland | Virginia | 51075 | 86 | 5 |
141947 | 141947 | 2020-05-13 | Goochland | Virginia | 51075 | 82 | 5 |
138951 | 138951 | 2020-05-12 | Goochland | Virginia | 51075 | 82 | 5 |
135960 | 135960 | 2020-05-11 | Goochland | Virginia | 51075 | 81 | 5 |
132970 | 132970 | 2020-05-10 | Goochland | Virginia | 51075 | 81 | 5 |
129980 | 129980 | 2020-05-09 | Goochland | Virginia | 51075 | 81 | 5 |
126990 | 126990 | 2020-05-08 | Goochland | Virginia | 51075 | 81 | 5 |
124005 | 124005 | 2020-05-07 | Goochland | Virginia | 51075 | 81 | 5 |
121024 | 121024 | 2020-05-06 | Goochland | Virginia | 51075 | 80 | 5 |
118060 | 118060 | 2020-05-05 | Goochland | Virginia | 51075 | 80 | 5 |
115101 | 115101 | 2020-05-04 | Goochland | Virginia | 51075 | 80 | 5 |
112218 | 112218 | 2020-05-03 | Goochland | Virginia | 51075 | 79 | 5 |
109344 | 109344 | 2020-05-02 | Goochland | Virginia | 51075 | 78 | 4 |
106475 | 106475 | 2020-05-01 | Goochland | Virginia | 51075 | 78 | 4 |
103611 | 103611 | 2020-04-30 | Goochland | Virginia | 51075 | 76 | 4 |
100756 | 100756 | 2020-04-29 | Goochland | Virginia | 51075 | 74 | 4 |
97906 | 97906 | 2020-04-28 | Goochland | Virginia | 51075 | 74 | 3 |
95064 | 95064 | 2020-04-27 | Goochland | Virginia | 51075 | 72 | 3 |
92235 | 92235 | 2020-04-26 | Goochland | Virginia | 51075 | 70 | 3 |
89418 | 89418 | 2020-04-25 | Goochland | Virginia | 51075 | 69 | 3 |
86603 | 86603 | 2020-04-24 | Goochland | Virginia | 51075 | 69 | 3 |
83796 | 83796 | 2020-04-23 | Goochland | Virginia | 51075 | 63 | 3 |
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);