ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Portsmouth city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388929 | 388929 | 2020-07-31 | Portsmouth city | Virginia | 51740 | 1462 | 22 |
385712 | 385712 | 2020-07-30 | Portsmouth city | Virginia | 51740 | 1417 | 22 |
382494 | 382494 | 2020-07-29 | Portsmouth city | Virginia | 51740 | 1390 | 21 |
379277 | 379277 | 2020-07-28 | Portsmouth city | Virginia | 51740 | 1367 | 21 |
376061 | 376061 | 2020-07-27 | Portsmouth city | Virginia | 51740 | 1291 | 21 |
372847 | 372847 | 2020-07-26 | Portsmouth city | Virginia | 51740 | 1267 | 21 |
369635 | 369635 | 2020-07-25 | Portsmouth city | Virginia | 51740 | 1225 | 21 |
366426 | 366426 | 2020-07-24 | Portsmouth city | Virginia | 51740 | 1165 | 21 |
363220 | 363220 | 2020-07-23 | Portsmouth city | Virginia | 51740 | 1115 | 21 |
360014 | 360014 | 2020-07-22 | Portsmouth city | Virginia | 51740 | 1085 | 21 |
356809 | 356809 | 2020-07-21 | Portsmouth city | Virginia | 51740 | 1046 | 21 |
353606 | 353606 | 2020-07-20 | Portsmouth city | Virginia | 51740 | 1009 | 20 |
350404 | 350404 | 2020-07-19 | Portsmouth city | Virginia | 51740 | 966 | 20 |
347203 | 347203 | 2020-07-18 | Portsmouth city | Virginia | 51740 | 925 | 20 |
344003 | 344003 | 2020-07-17 | Portsmouth city | Virginia | 51740 | 872 | 20 |
340804 | 340804 | 2020-07-16 | Portsmouth city | Virginia | 51740 | 827 | 19 |
337608 | 337608 | 2020-07-15 | Portsmouth city | Virginia | 51740 | 794 | 19 |
334413 | 334413 | 2020-07-14 | Portsmouth city | Virginia | 51740 | 761 | 19 |
331220 | 331220 | 2020-07-13 | Portsmouth city | Virginia | 51740 | 714 | 19 |
328034 | 328034 | 2020-07-12 | Portsmouth city | Virginia | 51740 | 686 | 19 |
324849 | 324849 | 2020-07-11 | Portsmouth city | Virginia | 51740 | 662 | 19 |
321668 | 321668 | 2020-07-10 | Portsmouth city | Virginia | 51740 | 627 | 18 |
318489 | 318489 | 2020-07-09 | Portsmouth city | Virginia | 51740 | 605 | 18 |
315316 | 315316 | 2020-07-08 | Portsmouth city | Virginia | 51740 | 593 | 18 |
312141 | 312141 | 2020-07-07 | Portsmouth city | Virginia | 51740 | 572 | 18 |
308972 | 308972 | 2020-07-06 | Portsmouth city | Virginia | 51740 | 549 | 18 |
305804 | 305804 | 2020-07-05 | Portsmouth city | Virginia | 51740 | 549 | 18 |
302640 | 302640 | 2020-07-04 | Portsmouth city | Virginia | 51740 | 539 | 18 |
299476 | 299476 | 2020-07-03 | Portsmouth city | Virginia | 51740 | 526 | 18 |
296314 | 296314 | 2020-07-02 | Portsmouth city | Virginia | 51740 | 513 | 18 |
293159 | 293159 | 2020-07-01 | Portsmouth city | Virginia | 51740 | 497 | 16 |
290006 | 290006 | 2020-06-30 | Portsmouth city | Virginia | 51740 | 482 | 16 |
286856 | 286856 | 2020-06-29 | Portsmouth city | Virginia | 51740 | 471 | 16 |
283710 | 283710 | 2020-06-28 | Portsmouth city | Virginia | 51740 | 459 | 16 |
280564 | 280564 | 2020-06-27 | Portsmouth city | Virginia | 51740 | 455 | 16 |
277416 | 277416 | 2020-06-26 | Portsmouth city | Virginia | 51740 | 449 | 16 |
274268 | 274268 | 2020-06-25 | Portsmouth city | Virginia | 51740 | 442 | 16 |
271128 | 271128 | 2020-06-24 | Portsmouth city | Virginia | 51740 | 426 | 16 |
267994 | 267994 | 2020-06-23 | Portsmouth city | Virginia | 51740 | 421 | 16 |
264865 | 264865 | 2020-06-22 | Portsmouth city | Virginia | 51740 | 419 | 13 |
261736 | 261736 | 2020-06-21 | Portsmouth city | Virginia | 51740 | 406 | 13 |
258609 | 258609 | 2020-06-20 | Portsmouth city | Virginia | 51740 | 405 | 13 |
255482 | 255482 | 2020-06-19 | Portsmouth city | Virginia | 51740 | 405 | 13 |
252363 | 252363 | 2020-06-18 | Portsmouth city | Virginia | 51740 | 402 | 13 |
249248 | 249248 | 2020-06-17 | Portsmouth city | Virginia | 51740 | 395 | 13 |
246136 | 246136 | 2020-06-16 | Portsmouth city | Virginia | 51740 | 387 | 12 |
243023 | 243023 | 2020-06-15 | Portsmouth city | Virginia | 51740 | 386 | 12 |
239912 | 239912 | 2020-06-14 | Portsmouth city | Virginia | 51740 | 375 | 12 |
236804 | 236804 | 2020-06-13 | Portsmouth city | Virginia | 51740 | 375 | 12 |
233697 | 233697 | 2020-06-12 | Portsmouth city | Virginia | 51740 | 370 | 11 |
230592 | 230592 | 2020-06-11 | Portsmouth city | Virginia | 51740 | 364 | 11 |
227488 | 227488 | 2020-06-10 | Portsmouth city | Virginia | 51740 | 354 | 11 |
224388 | 224388 | 2020-06-09 | Portsmouth city | Virginia | 51740 | 351 | 11 |
221292 | 221292 | 2020-06-08 | Portsmouth city | Virginia | 51740 | 343 | 11 |
218200 | 218200 | 2020-06-07 | Portsmouth city | Virginia | 51740 | 343 | 11 |
215110 | 215110 | 2020-06-06 | Portsmouth city | Virginia | 51740 | 335 | 11 |
212023 | 212023 | 2020-06-05 | Portsmouth city | Virginia | 51740 | 325 | 11 |
208938 | 208938 | 2020-06-04 | Portsmouth city | Virginia | 51740 | 325 | 11 |
205856 | 205856 | 2020-06-03 | Portsmouth city | Virginia | 51740 | 322 | 11 |
202777 | 202777 | 2020-06-02 | Portsmouth city | Virginia | 51740 | 325 | 11 |
199701 | 199701 | 2020-06-01 | Portsmouth city | Virginia | 51740 | 313 | 11 |
196628 | 196628 | 2020-05-31 | Portsmouth city | Virginia | 51740 | 308 | 11 |
193558 | 193558 | 2020-05-30 | Portsmouth city | Virginia | 51740 | 307 | 11 |
190492 | 190492 | 2020-05-29 | Portsmouth city | Virginia | 51740 | 294 | 11 |
187428 | 187428 | 2020-05-28 | Portsmouth city | Virginia | 51740 | 284 | 11 |
184371 | 184371 | 2020-05-27 | Portsmouth city | Virginia | 51740 | 282 | 11 |
181320 | 181320 | 2020-05-26 | Portsmouth city | Virginia | 51740 | 281 | 11 |
178276 | 178276 | 2020-05-25 | Portsmouth city | Virginia | 51740 | 272 | 11 |
175231 | 175231 | 2020-05-24 | Portsmouth city | Virginia | 51740 | 262 | 11 |
172188 | 172188 | 2020-05-23 | Portsmouth city | Virginia | 51740 | 253 | 11 |
169147 | 169147 | 2020-05-22 | Portsmouth city | Virginia | 51740 | 251 | 11 |
166111 | 166111 | 2020-05-21 | Portsmouth city | Virginia | 51740 | 245 | 11 |
163082 | 163082 | 2020-05-20 | Portsmouth city | Virginia | 51740 | 241 | 11 |
160054 | 160054 | 2020-05-19 | Portsmouth city | Virginia | 51740 | 237 | 10 |
157030 | 157030 | 2020-05-18 | Portsmouth city | Virginia | 51740 | 228 | 10 |
154013 | 154013 | 2020-05-17 | Portsmouth city | Virginia | 51740 | 225 | 10 |
151002 | 151002 | 2020-05-16 | Portsmouth city | Virginia | 51740 | 222 | 10 |
147993 | 147993 | 2020-05-15 | Portsmouth city | Virginia | 51740 | 219 | 10 |
144990 | 144990 | 2020-05-14 | Portsmouth city | Virginia | 51740 | 217 | 9 |
141993 | 141993 | 2020-05-13 | Portsmouth city | Virginia | 51740 | 213 | 9 |
138997 | 138997 | 2020-05-12 | Portsmouth city | Virginia | 51740 | 210 | 9 |
136006 | 136006 | 2020-05-11 | Portsmouth city | Virginia | 51740 | 208 | 8 |
133016 | 133016 | 2020-05-10 | Portsmouth city | Virginia | 51740 | 202 | 8 |
130026 | 130026 | 2020-05-09 | Portsmouth city | Virginia | 51740 | 202 | 8 |
127036 | 127036 | 2020-05-08 | Portsmouth city | Virginia | 51740 | 194 | 8 |
124051 | 124051 | 2020-05-07 | Portsmouth city | Virginia | 51740 | 193 | 8 |
121070 | 121070 | 2020-05-06 | Portsmouth city | Virginia | 51740 | 187 | 8 |
118106 | 118106 | 2020-05-05 | Portsmouth city | Virginia | 51740 | 187 | 8 |
115147 | 115147 | 2020-05-04 | Portsmouth city | Virginia | 51740 | 183 | 8 |
112264 | 112264 | 2020-05-03 | Portsmouth city | Virginia | 51740 | 183 | 8 |
109390 | 109390 | 2020-05-02 | Portsmouth city | Virginia | 51740 | 173 | 8 |
106521 | 106521 | 2020-05-01 | Portsmouth city | Virginia | 51740 | 170 | 7 |
103657 | 103657 | 2020-04-30 | Portsmouth city | Virginia | 51740 | 158 | 5 |
100802 | 100802 | 2020-04-29 | Portsmouth city | Virginia | 51740 | 150 | 5 |
97952 | 97952 | 2020-04-28 | Portsmouth city | Virginia | 51740 | 149 | 5 |
95108 | 95108 | 2020-04-27 | Portsmouth city | Virginia | 51740 | 114 | 5 |
92279 | 92279 | 2020-04-26 | Portsmouth city | Virginia | 51740 | 108 | 5 |
89462 | 89462 | 2020-04-25 | Portsmouth city | Virginia | 51740 | 103 | 5 |
86647 | 86647 | 2020-04-24 | Portsmouth city | Virginia | 51740 | 100 | 4 |
83840 | 83840 | 2020-04-23 | Portsmouth city | Virginia | 51740 | 98 | 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);