ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Prince Edward" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388931 | 388931 | 2020-07-31 | Prince Edward | Virginia | 51147 | 323 | 9 |
385714 | 385714 | 2020-07-30 | Prince Edward | Virginia | 51147 | 300 | 9 |
382496 | 382496 | 2020-07-29 | Prince Edward | Virginia | 51147 | 289 | 7 |
379279 | 379279 | 2020-07-28 | Prince Edward | Virginia | 51147 | 284 | 6 |
376063 | 376063 | 2020-07-27 | Prince Edward | Virginia | 51147 | 258 | 6 |
372849 | 372849 | 2020-07-26 | Prince Edward | Virginia | 51147 | 258 | 6 |
369637 | 369637 | 2020-07-25 | Prince Edward | Virginia | 51147 | 246 | 6 |
366428 | 366428 | 2020-07-24 | Prince Edward | Virginia | 51147 | 242 | 6 |
363222 | 363222 | 2020-07-23 | Prince Edward | Virginia | 51147 | 242 | 6 |
360016 | 360016 | 2020-07-22 | Prince Edward | Virginia | 51147 | 242 | 6 |
356811 | 356811 | 2020-07-21 | Prince Edward | Virginia | 51147 | 242 | 6 |
353608 | 353608 | 2020-07-20 | Prince Edward | Virginia | 51147 | 241 | 6 |
350406 | 350406 | 2020-07-19 | Prince Edward | Virginia | 51147 | 239 | 6 |
347205 | 347205 | 2020-07-18 | Prince Edward | Virginia | 51147 | 239 | 6 |
344005 | 344005 | 2020-07-17 | Prince Edward | Virginia | 51147 | 239 | 6 |
340806 | 340806 | 2020-07-16 | Prince Edward | Virginia | 51147 | 238 | 6 |
337610 | 337610 | 2020-07-15 | Prince Edward | Virginia | 51147 | 238 | 6 |
334415 | 334415 | 2020-07-14 | Prince Edward | Virginia | 51147 | 238 | 6 |
331222 | 331222 | 2020-07-13 | Prince Edward | Virginia | 51147 | 238 | 6 |
328036 | 328036 | 2020-07-12 | Prince Edward | Virginia | 51147 | 237 | 6 |
324851 | 324851 | 2020-07-11 | Prince Edward | Virginia | 51147 | 237 | 6 |
321670 | 321670 | 2020-07-10 | Prince Edward | Virginia | 51147 | 236 | 6 |
318491 | 318491 | 2020-07-09 | Prince Edward | Virginia | 51147 | 234 | 6 |
315318 | 315318 | 2020-07-08 | Prince Edward | Virginia | 51147 | 219 | 6 |
312143 | 312143 | 2020-07-07 | Prince Edward | Virginia | 51147 | 216 | 6 |
308974 | 308974 | 2020-07-06 | Prince Edward | Virginia | 51147 | 214 | 6 |
305806 | 305806 | 2020-07-05 | Prince Edward | Virginia | 51147 | 213 | 6 |
302642 | 302642 | 2020-07-04 | Prince Edward | Virginia | 51147 | 213 | 6 |
299478 | 299478 | 2020-07-03 | Prince Edward | Virginia | 51147 | 213 | 6 |
296316 | 296316 | 2020-07-02 | Prince Edward | Virginia | 51147 | 194 | 5 |
293161 | 293161 | 2020-07-01 | Prince Edward | Virginia | 51147 | 191 | 4 |
290008 | 290008 | 2020-06-30 | Prince Edward | Virginia | 51147 | 187 | 3 |
286858 | 286858 | 2020-06-29 | Prince Edward | Virginia | 51147 | 186 | 3 |
283712 | 283712 | 2020-06-28 | Prince Edward | Virginia | 51147 | 182 | 3 |
280566 | 280566 | 2020-06-27 | Prince Edward | Virginia | 51147 | 182 | 3 |
277418 | 277418 | 2020-06-26 | Prince Edward | Virginia | 51147 | 178 | 3 |
274270 | 274270 | 2020-06-25 | Prince Edward | Virginia | 51147 | 178 | 3 |
271130 | 271130 | 2020-06-24 | Prince Edward | Virginia | 51147 | 176 | 3 |
267996 | 267996 | 2020-06-23 | Prince Edward | Virginia | 51147 | 175 | 3 |
264867 | 264867 | 2020-06-22 | Prince Edward | Virginia | 51147 | 173 | 3 |
261738 | 261738 | 2020-06-21 | Prince Edward | Virginia | 51147 | 173 | 3 |
258611 | 258611 | 2020-06-20 | Prince Edward | Virginia | 51147 | 173 | 3 |
255484 | 255484 | 2020-06-19 | Prince Edward | Virginia | 51147 | 173 | 3 |
252365 | 252365 | 2020-06-18 | Prince Edward | Virginia | 51147 | 173 | 3 |
249250 | 249250 | 2020-06-17 | Prince Edward | Virginia | 51147 | 171 | 3 |
246138 | 246138 | 2020-06-16 | Prince Edward | Virginia | 51147 | 171 | 3 |
243025 | 243025 | 2020-06-15 | Prince Edward | Virginia | 51147 | 170 | 3 |
239914 | 239914 | 2020-06-14 | Prince Edward | Virginia | 51147 | 162 | 3 |
236806 | 236806 | 2020-06-13 | Prince Edward | Virginia | 51147 | 161 | 3 |
233699 | 233699 | 2020-06-12 | Prince Edward | Virginia | 51147 | 161 | 3 |
230594 | 230594 | 2020-06-11 | Prince Edward | Virginia | 51147 | 155 | 3 |
227490 | 227490 | 2020-06-10 | Prince Edward | Virginia | 51147 | 153 | 3 |
224390 | 224390 | 2020-06-09 | Prince Edward | Virginia | 51147 | 151 | 2 |
221294 | 221294 | 2020-06-08 | Prince Edward | Virginia | 51147 | 151 | 2 |
218202 | 218202 | 2020-06-07 | Prince Edward | Virginia | 51147 | 148 | 2 |
215112 | 215112 | 2020-06-06 | Prince Edward | Virginia | 51147 | 148 | 2 |
212025 | 212025 | 2020-06-05 | Prince Edward | Virginia | 51147 | 146 | 2 |
208940 | 208940 | 2020-06-04 | Prince Edward | Virginia | 51147 | 146 | 2 |
205858 | 205858 | 2020-06-03 | Prince Edward | Virginia | 51147 | 143 | 2 |
202779 | 202779 | 2020-06-02 | Prince Edward | Virginia | 51147 | 143 | 2 |
199703 | 199703 | 2020-06-01 | Prince Edward | Virginia | 51147 | 137 | 2 |
196630 | 196630 | 2020-05-31 | Prince Edward | Virginia | 51147 | 134 | 2 |
193560 | 193560 | 2020-05-30 | Prince Edward | Virginia | 51147 | 134 | 2 |
190494 | 190494 | 2020-05-29 | Prince Edward | Virginia | 51147 | 129 | 2 |
187430 | 187430 | 2020-05-28 | Prince Edward | Virginia | 51147 | 129 | 2 |
184373 | 184373 | 2020-05-27 | Prince Edward | Virginia | 51147 | 129 | 2 |
181322 | 181322 | 2020-05-26 | Prince Edward | Virginia | 51147 | 122 | 2 |
178278 | 178278 | 2020-05-25 | Prince Edward | Virginia | 51147 | 108 | 2 |
175233 | 175233 | 2020-05-24 | Prince Edward | Virginia | 51147 | 108 | 2 |
172190 | 172190 | 2020-05-23 | Prince Edward | Virginia | 51147 | 108 | 2 |
169149 | 169149 | 2020-05-22 | Prince Edward | Virginia | 51147 | 104 | 2 |
166113 | 166113 | 2020-05-21 | Prince Edward | Virginia | 51147 | 99 | 2 |
163084 | 163084 | 2020-05-20 | Prince Edward | Virginia | 51147 | 86 | 2 |
160056 | 160056 | 2020-05-19 | Prince Edward | Virginia | 51147 | 83 | 2 |
157032 | 157032 | 2020-05-18 | Prince Edward | Virginia | 51147 | 77 | 2 |
154015 | 154015 | 2020-05-17 | Prince Edward | Virginia | 51147 | 73 | 2 |
151004 | 151004 | 2020-05-16 | Prince Edward | Virginia | 51147 | 73 | 2 |
147995 | 147995 | 2020-05-15 | Prince Edward | Virginia | 51147 | 72 | 2 |
144992 | 144992 | 2020-05-14 | Prince Edward | Virginia | 51147 | 72 | 2 |
141995 | 141995 | 2020-05-13 | Prince Edward | Virginia | 51147 | 69 | 2 |
138999 | 138999 | 2020-05-12 | Prince Edward | Virginia | 51147 | 68 | 2 |
136008 | 136008 | 2020-05-11 | Prince Edward | Virginia | 51147 | 66 | 2 |
133018 | 133018 | 2020-05-10 | Prince Edward | Virginia | 51147 | 66 | 2 |
130028 | 130028 | 2020-05-09 | Prince Edward | Virginia | 51147 | 66 | 2 |
127038 | 127038 | 2020-05-08 | Prince Edward | Virginia | 51147 | 65 | 2 |
124053 | 124053 | 2020-05-07 | Prince Edward | Virginia | 51147 | 63 | 2 |
121072 | 121072 | 2020-05-06 | Prince Edward | Virginia | 51147 | 58 | 2 |
118108 | 118108 | 2020-05-05 | Prince Edward | Virginia | 51147 | 58 | 2 |
115149 | 115149 | 2020-05-04 | Prince Edward | Virginia | 51147 | 55 | 2 |
112266 | 112266 | 2020-05-03 | Prince Edward | Virginia | 51147 | 55 | 2 |
109392 | 109392 | 2020-05-02 | Prince Edward | Virginia | 51147 | 55 | 2 |
106523 | 106523 | 2020-05-01 | Prince Edward | Virginia | 51147 | 51 | 2 |
103659 | 103659 | 2020-04-30 | Prince Edward | Virginia | 51147 | 49 | 2 |
100804 | 100804 | 2020-04-29 | Prince Edward | Virginia | 51147 | 46 | 2 |
97954 | 97954 | 2020-04-28 | Prince Edward | Virginia | 51147 | 41 | 2 |
95110 | 95110 | 2020-04-27 | Prince Edward | Virginia | 51147 | 41 | 2 |
92281 | 92281 | 2020-04-26 | Prince Edward | Virginia | 51147 | 41 | 2 |
89464 | 89464 | 2020-04-25 | Prince Edward | Virginia | 51147 | 37 | 2 |
86649 | 86649 | 2020-04-24 | Prince Edward | Virginia | 51147 | 34 | 2 |
83842 | 83842 | 2020-04-23 | Prince Edward | Virginia | 51147 | 29 | 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);