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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6004 | 6004 | 2020-03-20 | Portsmouth city | Virginia | 51740 | 1 | 0 |
7034 | 7034 | 2020-03-21 | Portsmouth city | Virginia | 51740 | 1 | 0 |
8170 | 8170 | 2020-03-22 | Portsmouth city | Virginia | 51740 | 1 | 0 |
9392 | 9392 | 2020-03-23 | Portsmouth city | Virginia | 51740 | 1 | 0 |
10740 | 10740 | 2020-03-24 | Portsmouth city | Virginia | 51740 | 3 | 0 |
12260 | 12260 | 2020-03-25 | Portsmouth city | Virginia | 51740 | 3 | 0 |
13905 | 13905 | 2020-03-26 | Portsmouth city | Virginia | 51740 | 3 | 0 |
15673 | 15673 | 2020-03-27 | Portsmouth city | Virginia | 51740 | 3 | 0 |
17552 | 17552 | 2020-03-28 | Portsmouth city | Virginia | 51740 | 4 | 0 |
19514 | 19514 | 2020-03-29 | Portsmouth city | Virginia | 51740 | 4 | 0 |
21580 | 21580 | 2020-03-30 | Portsmouth city | Virginia | 51740 | 4 | 0 |
23727 | 23727 | 2020-03-31 | Portsmouth city | Virginia | 51740 | 12 | 0 |
25943 | 25943 | 2020-04-01 | Portsmouth city | Virginia | 51740 | 13 | 0 |
28233 | 28233 | 2020-04-02 | Portsmouth city | Virginia | 51740 | 16 | 0 |
30580 | 30580 | 2020-04-03 | Portsmouth city | Virginia | 51740 | 17 | 1 |
32979 | 32979 | 2020-04-04 | Portsmouth city | Virginia | 51740 | 26 | 1 |
35417 | 35417 | 2020-04-05 | Portsmouth city | Virginia | 51740 | 26 | 1 |
37900 | 37900 | 2020-04-06 | Portsmouth city | Virginia | 51740 | 27 | 1 |
40434 | 40434 | 2020-04-07 | Portsmouth city | Virginia | 51740 | 36 | 1 |
43003 | 43003 | 2020-04-08 | Portsmouth city | Virginia | 51740 | 41 | 1 |
45599 | 45599 | 2020-04-09 | Portsmouth city | Virginia | 51740 | 44 | 1 |
48225 | 48225 | 2020-04-10 | Portsmouth city | Virginia | 51740 | 48 | 1 |
50883 | 50883 | 2020-04-11 | Portsmouth city | Virginia | 51740 | 49 | 1 |
53558 | 53558 | 2020-04-12 | Portsmouth city | Virginia | 51740 | 51 | 1 |
56248 | 56248 | 2020-04-13 | Portsmouth city | Virginia | 51740 | 54 | 1 |
58954 | 58954 | 2020-04-14 | Portsmouth city | Virginia | 51740 | 59 | 4 |
61673 | 61673 | 2020-04-15 | Portsmouth city | Virginia | 51740 | 59 | 4 |
64406 | 64406 | 2020-04-16 | Portsmouth city | Virginia | 51740 | 62 | 4 |
67154 | 67154 | 2020-04-17 | Portsmouth city | Virginia | 51740 | 63 | 4 |
69916 | 69916 | 2020-04-18 | Portsmouth city | Virginia | 51740 | 65 | 4 |
72686 | 72686 | 2020-04-19 | Portsmouth city | Virginia | 51740 | 65 | 4 |
75462 | 75462 | 2020-04-20 | Portsmouth city | Virginia | 51740 | 65 | 4 |
78246 | 78246 | 2020-04-21 | Portsmouth city | Virginia | 51740 | 82 | 4 |
81039 | 81039 | 2020-04-22 | Portsmouth city | Virginia | 51740 | 93 | 4 |
83840 | 83840 | 2020-04-23 | Portsmouth city | Virginia | 51740 | 98 | 4 |
86647 | 86647 | 2020-04-24 | Portsmouth city | Virginia | 51740 | 100 | 4 |
89462 | 89462 | 2020-04-25 | Portsmouth city | Virginia | 51740 | 103 | 5 |
92279 | 92279 | 2020-04-26 | Portsmouth city | Virginia | 51740 | 108 | 5 |
95108 | 95108 | 2020-04-27 | Portsmouth city | Virginia | 51740 | 114 | 5 |
97952 | 97952 | 2020-04-28 | Portsmouth city | Virginia | 51740 | 149 | 5 |
100802 | 100802 | 2020-04-29 | Portsmouth city | Virginia | 51740 | 150 | 5 |
103657 | 103657 | 2020-04-30 | Portsmouth city | Virginia | 51740 | 158 | 5 |
106521 | 106521 | 2020-05-01 | Portsmouth city | Virginia | 51740 | 170 | 7 |
109390 | 109390 | 2020-05-02 | Portsmouth city | Virginia | 51740 | 173 | 8 |
112264 | 112264 | 2020-05-03 | Portsmouth city | Virginia | 51740 | 183 | 8 |
115147 | 115147 | 2020-05-04 | Portsmouth city | Virginia | 51740 | 183 | 8 |
118106 | 118106 | 2020-05-05 | Portsmouth city | Virginia | 51740 | 187 | 8 |
121070 | 121070 | 2020-05-06 | Portsmouth city | Virginia | 51740 | 187 | 8 |
124051 | 124051 | 2020-05-07 | Portsmouth city | Virginia | 51740 | 193 | 8 |
127036 | 127036 | 2020-05-08 | Portsmouth city | Virginia | 51740 | 194 | 8 |
130026 | 130026 | 2020-05-09 | Portsmouth city | Virginia | 51740 | 202 | 8 |
133016 | 133016 | 2020-05-10 | Portsmouth city | Virginia | 51740 | 202 | 8 |
136006 | 136006 | 2020-05-11 | Portsmouth city | Virginia | 51740 | 208 | 8 |
138997 | 138997 | 2020-05-12 | Portsmouth city | Virginia | 51740 | 210 | 9 |
141993 | 141993 | 2020-05-13 | Portsmouth city | Virginia | 51740 | 213 | 9 |
144990 | 144990 | 2020-05-14 | Portsmouth city | Virginia | 51740 | 217 | 9 |
147993 | 147993 | 2020-05-15 | Portsmouth city | Virginia | 51740 | 219 | 10 |
151002 | 151002 | 2020-05-16 | Portsmouth city | Virginia | 51740 | 222 | 10 |
154013 | 154013 | 2020-05-17 | Portsmouth city | Virginia | 51740 | 225 | 10 |
157030 | 157030 | 2020-05-18 | Portsmouth city | Virginia | 51740 | 228 | 10 |
160054 | 160054 | 2020-05-19 | Portsmouth city | Virginia | 51740 | 237 | 10 |
163082 | 163082 | 2020-05-20 | Portsmouth city | Virginia | 51740 | 241 | 11 |
166111 | 166111 | 2020-05-21 | Portsmouth city | Virginia | 51740 | 245 | 11 |
169147 | 169147 | 2020-05-22 | Portsmouth city | Virginia | 51740 | 251 | 11 |
172188 | 172188 | 2020-05-23 | Portsmouth city | Virginia | 51740 | 253 | 11 |
175231 | 175231 | 2020-05-24 | Portsmouth city | Virginia | 51740 | 262 | 11 |
178276 | 178276 | 2020-05-25 | Portsmouth city | Virginia | 51740 | 272 | 11 |
181320 | 181320 | 2020-05-26 | Portsmouth city | Virginia | 51740 | 281 | 11 |
184371 | 184371 | 2020-05-27 | Portsmouth city | Virginia | 51740 | 282 | 11 |
187428 | 187428 | 2020-05-28 | Portsmouth city | Virginia | 51740 | 284 | 11 |
190492 | 190492 | 2020-05-29 | Portsmouth city | Virginia | 51740 | 294 | 11 |
193558 | 193558 | 2020-05-30 | Portsmouth city | Virginia | 51740 | 307 | 11 |
196628 | 196628 | 2020-05-31 | Portsmouth city | Virginia | 51740 | 308 | 11 |
199701 | 199701 | 2020-06-01 | Portsmouth city | Virginia | 51740 | 313 | 11 |
202777 | 202777 | 2020-06-02 | Portsmouth city | Virginia | 51740 | 325 | 11 |
205856 | 205856 | 2020-06-03 | Portsmouth city | Virginia | 51740 | 322 | 11 |
208938 | 208938 | 2020-06-04 | Portsmouth city | Virginia | 51740 | 325 | 11 |
212023 | 212023 | 2020-06-05 | Portsmouth city | Virginia | 51740 | 325 | 11 |
215110 | 215110 | 2020-06-06 | Portsmouth city | Virginia | 51740 | 335 | 11 |
218200 | 218200 | 2020-06-07 | Portsmouth city | Virginia | 51740 | 343 | 11 |
221292 | 221292 | 2020-06-08 | Portsmouth city | Virginia | 51740 | 343 | 11 |
224388 | 224388 | 2020-06-09 | Portsmouth city | Virginia | 51740 | 351 | 11 |
227488 | 227488 | 2020-06-10 | Portsmouth city | Virginia | 51740 | 354 | 11 |
230592 | 230592 | 2020-06-11 | Portsmouth city | Virginia | 51740 | 364 | 11 |
233697 | 233697 | 2020-06-12 | Portsmouth city | Virginia | 51740 | 370 | 11 |
236804 | 236804 | 2020-06-13 | Portsmouth city | Virginia | 51740 | 375 | 12 |
239912 | 239912 | 2020-06-14 | Portsmouth city | Virginia | 51740 | 375 | 12 |
243023 | 243023 | 2020-06-15 | Portsmouth city | Virginia | 51740 | 386 | 12 |
246136 | 246136 | 2020-06-16 | Portsmouth city | Virginia | 51740 | 387 | 12 |
249248 | 249248 | 2020-06-17 | Portsmouth city | Virginia | 51740 | 395 | 13 |
252363 | 252363 | 2020-06-18 | Portsmouth city | Virginia | 51740 | 402 | 13 |
255482 | 255482 | 2020-06-19 | Portsmouth city | Virginia | 51740 | 405 | 13 |
258609 | 258609 | 2020-06-20 | Portsmouth city | Virginia | 51740 | 405 | 13 |
261736 | 261736 | 2020-06-21 | Portsmouth city | Virginia | 51740 | 406 | 13 |
264865 | 264865 | 2020-06-22 | Portsmouth city | Virginia | 51740 | 419 | 13 |
267994 | 267994 | 2020-06-23 | Portsmouth city | Virginia | 51740 | 421 | 16 |
271128 | 271128 | 2020-06-24 | Portsmouth city | Virginia | 51740 | 426 | 16 |
274268 | 274268 | 2020-06-25 | Portsmouth city | Virginia | 51740 | 442 | 16 |
277416 | 277416 | 2020-06-26 | Portsmouth city | Virginia | 51740 | 449 | 16 |
280564 | 280564 | 2020-06-27 | Portsmouth city | Virginia | 51740 | 455 | 16 |
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);