ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51740 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 200 ✖
- 205 31
- 256 27
- 11 24
- 70 18
- 25 15
- 71 15
- 0 14
- 69 14
- 337 13
- 250 12
- 1 11
- 4 11
- 8 10
- 204 10
- 210 10
- 254 10
- 318 10
- 16 9
- 18 9
- 21 9
- 63 9
- 73 8
- 96 8
- 187 8
- 199 8
- 202 8
- 203 8
- 246 8
- 59 7
- 78 7
- 97 7
- 206 7
- 207 7
- 317 7
- 5 6
- 13 6
- 19 6
- 34 6
- 99 6
- 197 6
- 200 6
- 201 6
- 222 6
- 248 6
- 10 5
- 43 5
- 45 5
- 87 5
- 188 5
- 212 5
- 228 5
- 238 5
- 241 5
- 243 5
- 255 5
- 262 5
- 306 5
- 12 4
- 20 4
- 24 4
- 58 4
- 75 4
- 90 4
- 94 4
- 171 4
- 185 4
- 209 4
- 215 4
- 311 4
- 326 4
- 332 4
- 9 3
- 30 3
- 61 3
- 64 3
- 76 3
- 77 3
- 107 3
- 108 3
- 149 3
- 162 3
- 183 3
- 191 3
- 192 3
- 211 3
- 219 3
- 233 3
- 240 3
- 252 3
- 260 3
- 267 3
- 281 3
- 296 3
- 307 3
- 308 3
- 312 3
- 315 3
- 316 3
- 321 3
- 338 3
- 22 2
- 31 2
- 42 2
- 53 2
- 65 2
- 67 2
- 86 2
- 125 2
- 130 2
- 131 2
- 148 2
- 151 2
- 164 2
- 165 2
- 169 2
- 170 2
- 174 2
- 180 2
- 181 2
- 195 2
- 214 2
- 218 2
- 231 2
- 236 2
- 249 2
- 251 2
- 305 2
- 324 2
- 7 1
- 28 1
- 36 1
- 41 1
- 46 1
- 47 1
- 48 1
- 49 1
- 51 1
- 62 1
- 72 1
- 74 1
- 95 1
- 123 1
- 126 1
- 128 1
- 136 1
- 139 1
- 140 1
- 141 1
- 142 1
- 150 1
- 153 1
- 154 1
- 157 1
- 158 1
- 159 1
- 160 1
- 161 1
- 163 1
- 168 1
- 172 1
- 173 1
- 177 1
- 184 1
- 186 1
- 189 1
- 190 1
- 193 1
- 194 1
- 196 1
- 216 1
- 217 1
- 220 1
- 221 1
- 223 1
- 226 1
- 232 1
- 237 1
- 245 1
- 247 1
- 257 1
- 263 1
- 265 1
- 273 1
- 275 1
- 276 1
- 280 1
- 286 1
- 288 1
- 292 1
- 294 1
- 300 1
- 313 1
- 319 1
- 322 1
- 325 1
- 327 1
- 329 1
- 331 1
- 335 1
- 336 1
state 1
- Virginia 785
fips 1
- 51740 · 785 ✖
county 1
- Portsmouth city 785
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);