ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 51065 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388875 | 388875 | 2020-07-31 | Fluvanna | Virginia | 51065 | 173 | 8 |
385658 | 385658 | 2020-07-30 | Fluvanna | Virginia | 51065 | 170 | 8 |
382440 | 382440 | 2020-07-29 | Fluvanna | Virginia | 51065 | 170 | 8 |
379223 | 379223 | 2020-07-28 | Fluvanna | Virginia | 51065 | 167 | 8 |
376007 | 376007 | 2020-07-27 | Fluvanna | Virginia | 51065 | 165 | 8 |
372793 | 372793 | 2020-07-26 | Fluvanna | Virginia | 51065 | 160 | 8 |
369581 | 369581 | 2020-07-25 | Fluvanna | Virginia | 51065 | 157 | 8 |
366372 | 366372 | 2020-07-24 | Fluvanna | Virginia | 51065 | 157 | 8 |
363166 | 363166 | 2020-07-23 | Fluvanna | Virginia | 51065 | 154 | 8 |
359960 | 359960 | 2020-07-22 | Fluvanna | Virginia | 51065 | 151 | 8 |
356755 | 356755 | 2020-07-21 | Fluvanna | Virginia | 51065 | 151 | 8 |
353552 | 353552 | 2020-07-20 | Fluvanna | Virginia | 51065 | 146 | 8 |
350350 | 350350 | 2020-07-19 | Fluvanna | Virginia | 51065 | 145 | 8 |
347149 | 347149 | 2020-07-18 | Fluvanna | Virginia | 51065 | 145 | 8 |
343949 | 343949 | 2020-07-17 | Fluvanna | Virginia | 51065 | 142 | 8 |
340750 | 340750 | 2020-07-16 | Fluvanna | Virginia | 51065 | 139 | 8 |
337554 | 337554 | 2020-07-15 | Fluvanna | Virginia | 51065 | 139 | 8 |
334359 | 334359 | 2020-07-14 | Fluvanna | Virginia | 51065 | 139 | 8 |
331166 | 331166 | 2020-07-13 | Fluvanna | Virginia | 51065 | 138 | 8 |
327980 | 327980 | 2020-07-12 | Fluvanna | Virginia | 51065 | 134 | 8 |
324795 | 324795 | 2020-07-11 | Fluvanna | Virginia | 51065 | 130 | 8 |
321614 | 321614 | 2020-07-10 | Fluvanna | Virginia | 51065 | 128 | 8 |
318435 | 318435 | 2020-07-09 | Fluvanna | Virginia | 51065 | 126 | 8 |
315262 | 315262 | 2020-07-08 | Fluvanna | Virginia | 51065 | 125 | 8 |
312087 | 312087 | 2020-07-07 | Fluvanna | Virginia | 51065 | 123 | 8 |
308918 | 308918 | 2020-07-06 | Fluvanna | Virginia | 51065 | 121 | 8 |
305750 | 305750 | 2020-07-05 | Fluvanna | Virginia | 51065 | 120 | 8 |
302586 | 302586 | 2020-07-04 | Fluvanna | Virginia | 51065 | 120 | 8 |
299422 | 299422 | 2020-07-03 | Fluvanna | Virginia | 51065 | 116 | 8 |
296260 | 296260 | 2020-07-02 | Fluvanna | Virginia | 51065 | 114 | 7 |
293105 | 293105 | 2020-07-01 | Fluvanna | Virginia | 51065 | 112 | 7 |
289952 | 289952 | 2020-06-30 | Fluvanna | Virginia | 51065 | 110 | 7 |
286802 | 286802 | 2020-06-29 | Fluvanna | Virginia | 51065 | 110 | 6 |
283656 | 283656 | 2020-06-28 | Fluvanna | Virginia | 51065 | 109 | 6 |
280510 | 280510 | 2020-06-27 | Fluvanna | Virginia | 51065 | 109 | 6 |
277362 | 277362 | 2020-06-26 | Fluvanna | Virginia | 51065 | 109 | 6 |
274214 | 274214 | 2020-06-25 | Fluvanna | Virginia | 51065 | 107 | 6 |
271074 | 271074 | 2020-06-24 | Fluvanna | Virginia | 51065 | 107 | 6 |
267940 | 267940 | 2020-06-23 | Fluvanna | Virginia | 51065 | 108 | 6 |
264811 | 264811 | 2020-06-22 | Fluvanna | Virginia | 51065 | 105 | 6 |
261682 | 261682 | 2020-06-21 | Fluvanna | Virginia | 51065 | 105 | 6 |
258555 | 258555 | 2020-06-20 | Fluvanna | Virginia | 51065 | 104 | 6 |
255428 | 255428 | 2020-06-19 | Fluvanna | Virginia | 51065 | 103 | 6 |
252309 | 252309 | 2020-06-18 | Fluvanna | Virginia | 51065 | 103 | 6 |
249194 | 249194 | 2020-06-17 | Fluvanna | Virginia | 51065 | 103 | 6 |
246082 | 246082 | 2020-06-16 | Fluvanna | Virginia | 51065 | 102 | 6 |
242969 | 242969 | 2020-06-15 | Fluvanna | Virginia | 51065 | 102 | 6 |
239858 | 239858 | 2020-06-14 | Fluvanna | Virginia | 51065 | 102 | 6 |
236750 | 236750 | 2020-06-13 | Fluvanna | Virginia | 51065 | 101 | 6 |
233643 | 233643 | 2020-06-12 | Fluvanna | Virginia | 51065 | 101 | 6 |
230538 | 230538 | 2020-06-11 | Fluvanna | Virginia | 51065 | 98 | 6 |
227434 | 227434 | 2020-06-10 | Fluvanna | Virginia | 51065 | 98 | 6 |
224334 | 224334 | 2020-06-09 | Fluvanna | Virginia | 51065 | 95 | 6 |
221238 | 221238 | 2020-06-08 | Fluvanna | Virginia | 51065 | 95 | 6 |
218146 | 218146 | 2020-06-07 | Fluvanna | Virginia | 51065 | 94 | 6 |
215056 | 215056 | 2020-06-06 | Fluvanna | Virginia | 51065 | 94 | 6 |
211969 | 211969 | 2020-06-05 | Fluvanna | Virginia | 51065 | 94 | 6 |
208884 | 208884 | 2020-06-04 | Fluvanna | Virginia | 51065 | 94 | 6 |
205802 | 205802 | 2020-06-03 | Fluvanna | Virginia | 51065 | 92 | 6 |
202723 | 202723 | 2020-06-02 | Fluvanna | Virginia | 51065 | 92 | 6 |
199647 | 199647 | 2020-06-01 | Fluvanna | Virginia | 51065 | 92 | 6 |
196574 | 196574 | 2020-05-31 | Fluvanna | Virginia | 51065 | 92 | 6 |
193504 | 193504 | 2020-05-30 | Fluvanna | Virginia | 51065 | 91 | 6 |
190438 | 190438 | 2020-05-29 | Fluvanna | Virginia | 51065 | 90 | 6 |
187374 | 187374 | 2020-05-28 | Fluvanna | Virginia | 51065 | 88 | 6 |
184317 | 184317 | 2020-05-27 | Fluvanna | Virginia | 51065 | 87 | 6 |
181266 | 181266 | 2020-05-26 | Fluvanna | Virginia | 51065 | 87 | 6 |
178222 | 178222 | 2020-05-25 | Fluvanna | Virginia | 51065 | 85 | 6 |
175177 | 175177 | 2020-05-24 | Fluvanna | Virginia | 51065 | 84 | 6 |
172134 | 172134 | 2020-05-23 | Fluvanna | Virginia | 51065 | 84 | 6 |
169093 | 169093 | 2020-05-22 | Fluvanna | Virginia | 51065 | 84 | 6 |
166057 | 166057 | 2020-05-21 | Fluvanna | Virginia | 51065 | 83 | 6 |
163028 | 163028 | 2020-05-20 | Fluvanna | Virginia | 51065 | 82 | 6 |
160000 | 160000 | 2020-05-19 | Fluvanna | Virginia | 51065 | 82 | 6 |
156976 | 156976 | 2020-05-18 | Fluvanna | Virginia | 51065 | 82 | 6 |
153959 | 153959 | 2020-05-17 | Fluvanna | Virginia | 51065 | 81 | 6 |
150948 | 150948 | 2020-05-16 | Fluvanna | Virginia | 51065 | 81 | 6 |
147939 | 147939 | 2020-05-15 | Fluvanna | Virginia | 51065 | 79 | 6 |
144936 | 144936 | 2020-05-14 | Fluvanna | Virginia | 51065 | 79 | 6 |
141939 | 141939 | 2020-05-13 | Fluvanna | Virginia | 51065 | 79 | 6 |
138943 | 138943 | 2020-05-12 | Fluvanna | Virginia | 51065 | 78 | 6 |
135952 | 135952 | 2020-05-11 | Fluvanna | Virginia | 51065 | 79 | 6 |
132962 | 132962 | 2020-05-10 | Fluvanna | Virginia | 51065 | 79 | 6 |
129972 | 129972 | 2020-05-09 | Fluvanna | Virginia | 51065 | 79 | 6 |
126982 | 126982 | 2020-05-08 | Fluvanna | Virginia | 51065 | 78 | 6 |
123997 | 123997 | 2020-05-07 | Fluvanna | Virginia | 51065 | 78 | 6 |
121016 | 121016 | 2020-05-06 | Fluvanna | Virginia | 51065 | 76 | 6 |
118052 | 118052 | 2020-05-05 | Fluvanna | Virginia | 51065 | 76 | 6 |
115093 | 115093 | 2020-05-04 | Fluvanna | Virginia | 51065 | 76 | 6 |
112210 | 112210 | 2020-05-03 | Fluvanna | Virginia | 51065 | 76 | 6 |
109336 | 109336 | 2020-05-02 | Fluvanna | Virginia | 51065 | 76 | 6 |
106467 | 106467 | 2020-05-01 | Fluvanna | Virginia | 51065 | 74 | 6 |
103603 | 103603 | 2020-04-30 | Fluvanna | Virginia | 51065 | 73 | 6 |
100748 | 100748 | 2020-04-29 | Fluvanna | Virginia | 51065 | 73 | 5 |
97898 | 97898 | 2020-04-28 | Fluvanna | Virginia | 51065 | 73 | 5 |
95056 | 95056 | 2020-04-27 | Fluvanna | Virginia | 51065 | 73 | 5 |
92227 | 92227 | 2020-04-26 | Fluvanna | Virginia | 51065 | 72 | 5 |
89410 | 89410 | 2020-04-25 | Fluvanna | Virginia | 51065 | 72 | 5 |
86595 | 86595 | 2020-04-24 | Fluvanna | Virginia | 51065 | 72 | 5 |
83788 | 83788 | 2020-04-23 | Fluvanna | Virginia | 51065 | 72 | 4 |
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);