ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 51149 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388932 | 388932 | 2020-07-31 | Prince George | Virginia | 51149 | 329 | 2 |
385715 | 385715 | 2020-07-30 | Prince George | Virginia | 51149 | 328 | 2 |
382497 | 382497 | 2020-07-29 | Prince George | Virginia | 51149 | 327 | 2 |
379280 | 379280 | 2020-07-28 | Prince George | Virginia | 51149 | 326 | 2 |
376064 | 376064 | 2020-07-27 | Prince George | Virginia | 51149 | 319 | 2 |
372850 | 372850 | 2020-07-26 | Prince George | Virginia | 51149 | 318 | 2 |
369638 | 369638 | 2020-07-25 | Prince George | Virginia | 51149 | 304 | 2 |
366429 | 366429 | 2020-07-24 | Prince George | Virginia | 51149 | 302 | 2 |
363223 | 363223 | 2020-07-23 | Prince George | Virginia | 51149 | 298 | 2 |
360017 | 360017 | 2020-07-22 | Prince George | Virginia | 51149 | 293 | 2 |
356812 | 356812 | 2020-07-21 | Prince George | Virginia | 51149 | 293 | 2 |
353609 | 353609 | 2020-07-20 | Prince George | Virginia | 51149 | 291 | 2 |
350407 | 350407 | 2020-07-19 | Prince George | Virginia | 51149 | 288 | 2 |
347206 | 347206 | 2020-07-18 | Prince George | Virginia | 51149 | 283 | 2 |
344006 | 344006 | 2020-07-17 | Prince George | Virginia | 51149 | 280 | 2 |
340807 | 340807 | 2020-07-16 | Prince George | Virginia | 51149 | 277 | 2 |
337611 | 337611 | 2020-07-15 | Prince George | Virginia | 51149 | 276 | 2 |
334416 | 334416 | 2020-07-14 | Prince George | Virginia | 51149 | 265 | 2 |
331223 | 331223 | 2020-07-13 | Prince George | Virginia | 51149 | 265 | 2 |
328037 | 328037 | 2020-07-12 | Prince George | Virginia | 51149 | 262 | 2 |
324852 | 324852 | 2020-07-11 | Prince George | Virginia | 51149 | 258 | 2 |
321671 | 321671 | 2020-07-10 | Prince George | Virginia | 51149 | 255 | 2 |
318492 | 318492 | 2020-07-09 | Prince George | Virginia | 51149 | 254 | 2 |
315319 | 315319 | 2020-07-08 | Prince George | Virginia | 51149 | 254 | 2 |
312144 | 312144 | 2020-07-07 | Prince George | Virginia | 51149 | 246 | 1 |
308975 | 308975 | 2020-07-06 | Prince George | Virginia | 51149 | 245 | 1 |
305807 | 305807 | 2020-07-05 | Prince George | Virginia | 51149 | 244 | 1 |
302643 | 302643 | 2020-07-04 | Prince George | Virginia | 51149 | 244 | 1 |
299479 | 299479 | 2020-07-03 | Prince George | Virginia | 51149 | 243 | 1 |
296317 | 296317 | 2020-07-02 | Prince George | Virginia | 51149 | 238 | 1 |
293162 | 293162 | 2020-07-01 | Prince George | Virginia | 51149 | 239 | 1 |
290009 | 290009 | 2020-06-30 | Prince George | Virginia | 51149 | 238 | 1 |
286859 | 286859 | 2020-06-29 | Prince George | Virginia | 51149 | 235 | 1 |
283713 | 283713 | 2020-06-28 | Prince George | Virginia | 51149 | 229 | 1 |
280567 | 280567 | 2020-06-27 | Prince George | Virginia | 51149 | 228 | 1 |
277419 | 277419 | 2020-06-26 | Prince George | Virginia | 51149 | 227 | 0 |
274271 | 274271 | 2020-06-25 | Prince George | Virginia | 51149 | 222 | 0 |
271131 | 271131 | 2020-06-24 | Prince George | Virginia | 51149 | 215 | 0 |
267997 | 267997 | 2020-06-23 | Prince George | Virginia | 51149 | 207 | 0 |
264868 | 264868 | 2020-06-22 | Prince George | Virginia | 51149 | 215 | 0 |
261739 | 261739 | 2020-06-21 | Prince George | Virginia | 51149 | 213 | 0 |
258612 | 258612 | 2020-06-20 | Prince George | Virginia | 51149 | 191 | 0 |
255485 | 255485 | 2020-06-19 | Prince George | Virginia | 51149 | 179 | 0 |
252366 | 252366 | 2020-06-18 | Prince George | Virginia | 51149 | 170 | 0 |
249251 | 249251 | 2020-06-17 | Prince George | Virginia | 51149 | 169 | 0 |
246139 | 246139 | 2020-06-16 | Prince George | Virginia | 51149 | 168 | 0 |
243026 | 243026 | 2020-06-15 | Prince George | Virginia | 51149 | 167 | 0 |
239915 | 239915 | 2020-06-14 | Prince George | Virginia | 51149 | 163 | 0 |
236807 | 236807 | 2020-06-13 | Prince George | Virginia | 51149 | 162 | 0 |
233700 | 233700 | 2020-06-12 | Prince George | Virginia | 51149 | 158 | 0 |
230595 | 230595 | 2020-06-11 | Prince George | Virginia | 51149 | 158 | 0 |
227491 | 227491 | 2020-06-10 | Prince George | Virginia | 51149 | 153 | 0 |
224391 | 224391 | 2020-06-09 | Prince George | Virginia | 51149 | 153 | 0 |
221295 | 221295 | 2020-06-08 | Prince George | Virginia | 51149 | 150 | 0 |
218203 | 218203 | 2020-06-07 | Prince George | Virginia | 51149 | 148 | 0 |
215113 | 215113 | 2020-06-06 | Prince George | Virginia | 51149 | 146 | 0 |
212026 | 212026 | 2020-06-05 | Prince George | Virginia | 51149 | 142 | 0 |
208941 | 208941 | 2020-06-04 | Prince George | Virginia | 51149 | 142 | 0 |
205859 | 205859 | 2020-06-03 | Prince George | Virginia | 51149 | 135 | 0 |
202780 | 202780 | 2020-06-02 | Prince George | Virginia | 51149 | 135 | 0 |
199704 | 199704 | 2020-06-01 | Prince George | Virginia | 51149 | 129 | 0 |
196631 | 196631 | 2020-05-31 | Prince George | Virginia | 51149 | 126 | 0 |
193561 | 193561 | 2020-05-30 | Prince George | Virginia | 51149 | 126 | 0 |
190495 | 190495 | 2020-05-29 | Prince George | Virginia | 51149 | 121 | 0 |
187431 | 187431 | 2020-05-28 | Prince George | Virginia | 51149 | 81 | 0 |
184374 | 184374 | 2020-05-27 | Prince George | Virginia | 51149 | 79 | 0 |
181323 | 181323 | 2020-05-26 | Prince George | Virginia | 51149 | 71 | 0 |
178279 | 178279 | 2020-05-25 | Prince George | Virginia | 51149 | 60 | 0 |
175234 | 175234 | 2020-05-24 | Prince George | Virginia | 51149 | 60 | 0 |
172191 | 172191 | 2020-05-23 | Prince George | Virginia | 51149 | 60 | 0 |
169150 | 169150 | 2020-05-22 | Prince George | Virginia | 51149 | 56 | 0 |
166114 | 166114 | 2020-05-21 | Prince George | Virginia | 51149 | 56 | 0 |
163085 | 163085 | 2020-05-20 | Prince George | Virginia | 51149 | 56 | 0 |
160057 | 160057 | 2020-05-19 | Prince George | Virginia | 51149 | 56 | 0 |
157033 | 157033 | 2020-05-18 | Prince George | Virginia | 51149 | 52 | 0 |
154016 | 154016 | 2020-05-17 | Prince George | Virginia | 51149 | 49 | 0 |
151005 | 151005 | 2020-05-16 | Prince George | Virginia | 51149 | 49 | 0 |
147996 | 147996 | 2020-05-15 | Prince George | Virginia | 51149 | 49 | 0 |
144993 | 144993 | 2020-05-14 | Prince George | Virginia | 51149 | 48 | 0 |
141996 | 141996 | 2020-05-13 | Prince George | Virginia | 51149 | 46 | 0 |
139000 | 139000 | 2020-05-12 | Prince George | Virginia | 51149 | 45 | 0 |
136009 | 136009 | 2020-05-11 | Prince George | Virginia | 51149 | 45 | 0 |
133019 | 133019 | 2020-05-10 | Prince George | Virginia | 51149 | 44 | 0 |
130029 | 130029 | 2020-05-09 | Prince George | Virginia | 51149 | 42 | 0 |
127039 | 127039 | 2020-05-08 | Prince George | Virginia | 51149 | 42 | 0 |
124054 | 124054 | 2020-05-07 | Prince George | Virginia | 51149 | 42 | 0 |
121073 | 121073 | 2020-05-06 | Prince George | Virginia | 51149 | 40 | 0 |
118109 | 118109 | 2020-05-05 | Prince George | Virginia | 51149 | 40 | 0 |
115150 | 115150 | 2020-05-04 | Prince George | Virginia | 51149 | 40 | 0 |
112267 | 112267 | 2020-05-03 | Prince George | Virginia | 51149 | 35 | 0 |
109393 | 109393 | 2020-05-02 | Prince George | Virginia | 51149 | 35 | 0 |
106524 | 106524 | 2020-05-01 | Prince George | Virginia | 51149 | 34 | 0 |
103660 | 103660 | 2020-04-30 | Prince George | Virginia | 51149 | 33 | 0 |
100805 | 100805 | 2020-04-29 | Prince George | Virginia | 51149 | 33 | 0 |
97955 | 97955 | 2020-04-28 | Prince George | Virginia | 51149 | 31 | 0 |
95111 | 95111 | 2020-04-27 | Prince George | Virginia | 51149 | 31 | 0 |
92282 | 92282 | 2020-04-26 | Prince George | Virginia | 51149 | 30 | 0 |
89465 | 89465 | 2020-04-25 | Prince George | Virginia | 51149 | 30 | 0 |
86650 | 86650 | 2020-04-24 | Prince George | Virginia | 51149 | 29 | 0 |
83843 | 83843 | 2020-04-23 | Prince George | Virginia | 51149 | 29 | 0 |
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);