ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51700 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 205 ✖
- 10 72
- 1 30
- 320 26
- 51 20
- 239 16
- 240 16
- 49 14
- 28 13
- 242 13
- 306 13
- 20 12
- 228 12
- 53 11
- 224 10
- 244 10
- 402 10
- 55 8
- 76 8
- 305 8
- 18 7
- 233 7
- 250 7
- 291 7
- 303 7
- 304 7
- 322 7
- 6 6
- 9 6
- 56 6
- 64 6
- 190 6
- 208 6
- 288 6
- 391 6
- 393 6
- 396 6
- 14 5
- 15 5
- 16 5
- 113 5
- 219 5
- 235 5
- 297 5
- 378 5
- 381 5
- 384 5
- 7 4
- 21 4
- 32 4
- 33 4
- 50 4
- 58 4
- 63 4
- 70 4
- 73 4
- 117 4
- 202 4
- 203 4
- 204 4
- 238 4
- 243 4
- 252 4
- 269 4
- 283 4
- 309 4
- 313 4
- 333 4
- 388 4
- 400 4
- 38 3
- 48 3
- 66 3
- 72 3
- 83 3
- 87 3
- 97 3
- 103 3
- 214 3
- 215 3
- 220 3
- 222 3
- 223 3
- 229 3
- 246 3
- 247 3
- 253 3
- 260 3
- 279 3
- 302 3
- 347 3
- 357 3
- 368 3
- 401 3
- 403 3
- 0 2
- 13 2
- 19 2
- 24 2
- 37 2
- 54 2
- 69 2
- 79 2
- 199 2
- 211 2
- 221 2
- 226 2
- 227 2
- 230 2
- 234 2
- 237 2
- 254 2
- 282 2
- 296 2
- 307 2
- 308 2
- 344 2
- 380 2
- 385 2
- 387 2
- 404 2
- 25 1
- 27 1
- 39 1
- 40 1
- 41 1
- 43 1
- 46 1
- 52 1
- 65 1
- 68 1
- 74 1
- 89 1
- 93 1
- 100 1
- 101 1
- 109 1
- 115 1
- 116 1
- 118 1
- 132 1
- 135 1
- 138 1
- 140 1
- 141 1
- 148 1
- 158 1
- 161 1
- 176 1
- 182 1
- 191 1
- 198 1
- 200 1
- 205 1
- 207 1
- 212 1
- 216 1
- 217 1
- 218 1
- 231 1
- 232 1
- 236 1
- 241 1
- 245 1
- 258 1
- 259 1
- 263 1
- 264 1
- 265 1
- 267 1
- 274 1
- 275 1
- 277 1
- 280 1
- 281 1
- 284 1
- 299 1
- 300 1
- 301 1
- 310 1
- 312 1
- 314 1
- 319 1
- 324 1
- 326 1
- 328 1
- 341 1
- 342 1
- 350 1
- 351 1
- 353 1
- 354 1
- 358 1
- 359 1
- 362 1
- 365 1
- 374 1
- 375 1
- 382 1
- 383 1
- 389 1
- 390 1
- 392 1
- 395 1
- 398 1
- 399 1
state 1
- Virginia 785
fips 1
- 51700 · 785 ✖
county 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502594 | 2502594 | 2022-05-13 | Newport News city | Virginia | 51700 | 37189 | 404 |
2499336 | 2499336 | 2022-05-12 | Newport News city | Virginia | 51700 | 37129 | 404 |
2496078 | 2496078 | 2022-05-11 | Newport News city | Virginia | 51700 | 37046 | 403 |
2492820 | 2492820 | 2022-05-10 | Newport News city | Virginia | 51700 | 37000 | 403 |
2489562 | 2489562 | 2022-05-09 | Newport News city | Virginia | 51700 | 36939 | 403 |
2486305 | 2486305 | 2022-05-08 | Newport News city | Virginia | 51700 | 36867 | 402 |
2483047 | 2483047 | 2022-05-07 | Newport News city | Virginia | 51700 | 36867 | 402 |
2479789 | 2479789 | 2022-05-06 | Newport News city | Virginia | 51700 | 36867 | 402 |
2476531 | 2476531 | 2022-05-05 | Newport News city | Virginia | 51700 | 36837 | 402 |
2473273 | 2473273 | 2022-05-04 | Newport News city | Virginia | 51700 | 36805 | 402 |
2470017 | 2470017 | 2022-05-03 | Newport News city | Virginia | 51700 | 36724 | 402 |
2466761 | 2466761 | 2022-05-02 | Newport News city | Virginia | 51700 | 36682 | 402 |
2463506 | 2463506 | 2022-05-01 | Newport News city | Virginia | 51700 | 36619 | 402 |
2460250 | 2460250 | 2022-04-30 | Newport News city | Virginia | 51700 | 36619 | 402 |
2456994 | 2456994 | 2022-04-29 | Newport News city | Virginia | 51700 | 36619 | 402 |
2453738 | 2453738 | 2022-04-28 | Newport News city | Virginia | 51700 | 36590 | 401 |
2450482 | 2450482 | 2022-04-27 | Newport News city | Virginia | 51700 | 36530 | 401 |
2447225 | 2447225 | 2022-04-26 | Newport News city | Virginia | 51700 | 36516 | 401 |
2443970 | 2443970 | 2022-04-25 | Newport News city | Virginia | 51700 | 36503 | 400 |
2440714 | 2440714 | 2022-04-24 | Newport News city | Virginia | 51700 | 36468 | 400 |
2437458 | 2437458 | 2022-04-23 | Newport News city | Virginia | 51700 | 36468 | 400 |
2434202 | 2434202 | 2022-04-22 | Newport News city | Virginia | 51700 | 36468 | 400 |
2430946 | 2430946 | 2022-04-21 | Newport News city | Virginia | 51700 | 36453 | 399 |
2427690 | 2427690 | 2022-04-20 | Newport News city | Virginia | 51700 | 36362 | 398 |
2424434 | 2424434 | 2022-04-19 | Newport News city | Virginia | 51700 | 36347 | 396 |
2421178 | 2421178 | 2022-04-18 | Newport News city | Virginia | 51700 | 36331 | 396 |
2417922 | 2417922 | 2022-04-17 | Newport News city | Virginia | 51700 | 36289 | 396 |
2414666 | 2414666 | 2022-04-16 | Newport News city | Virginia | 51700 | 36289 | 396 |
2411410 | 2411410 | 2022-04-15 | Newport News city | Virginia | 51700 | 36289 | 396 |
2408154 | 2408154 | 2022-04-14 | Newport News city | Virginia | 51700 | 36270 | 396 |
2404898 | 2404898 | 2022-04-13 | Newport News city | Virginia | 51700 | 36254 | 395 |
2401643 | 2401643 | 2022-04-12 | Newport News city | Virginia | 51700 | 36240 | 393 |
2398388 | 2398388 | 2022-04-11 | Newport News city | Virginia | 51700 | 36232 | 393 |
2395133 | 2395133 | 2022-04-10 | Newport News city | Virginia | 51700 | 36202 | 393 |
2391877 | 2391877 | 2022-04-09 | Newport News city | Virginia | 51700 | 36202 | 393 |
2388621 | 2388621 | 2022-04-08 | Newport News city | Virginia | 51700 | 36202 | 393 |
2385366 | 2385366 | 2022-04-07 | Newport News city | Virginia | 51700 | 36191 | 393 |
2382111 | 2382111 | 2022-04-06 | Newport News city | Virginia | 51700 | 36177 | 392 |
2378856 | 2378856 | 2022-04-05 | Newport News city | Virginia | 51700 | 36158 | 391 |
2375602 | 2375602 | 2022-04-04 | Newport News city | Virginia | 51700 | 36152 | 391 |
2372350 | 2372350 | 2022-04-03 | Newport News city | Virginia | 51700 | 36118 | 391 |
2369097 | 2369097 | 2022-04-02 | Newport News city | Virginia | 51700 | 36118 | 391 |
2365844 | 2365844 | 2022-04-01 | Newport News city | Virginia | 51700 | 36118 | 391 |
2362591 | 2362591 | 2022-03-31 | Newport News city | Virginia | 51700 | 36109 | 391 |
2359337 | 2359337 | 2022-03-30 | Newport News city | Virginia | 51700 | 36104 | 390 |
2356083 | 2356083 | 2022-03-29 | Newport News city | Virginia | 51700 | 36094 | 389 |
2352830 | 2352830 | 2022-03-28 | Newport News city | Virginia | 51700 | 36090 | 388 |
2349578 | 2349578 | 2022-03-27 | Newport News city | Virginia | 51700 | 36073 | 388 |
2346325 | 2346325 | 2022-03-26 | Newport News city | Virginia | 51700 | 36073 | 388 |
2343072 | 2343072 | 2022-03-25 | Newport News city | Virginia | 51700 | 36073 | 388 |
2339819 | 2339819 | 2022-03-24 | Newport News city | Virginia | 51700 | 36070 | 387 |
2336565 | 2336565 | 2022-03-23 | Newport News city | Virginia | 51700 | 36061 | 387 |
2333311 | 2333311 | 2022-03-22 | Newport News city | Virginia | 51700 | 36051 | 385 |
2330058 | 2330058 | 2022-03-21 | Newport News city | Virginia | 51700 | 36051 | 385 |
2326806 | 2326806 | 2022-03-20 | Newport News city | Virginia | 51700 | 36032 | 384 |
2323553 | 2323553 | 2022-03-19 | Newport News city | Virginia | 51700 | 36032 | 384 |
2320299 | 2320299 | 2022-03-18 | Newport News city | Virginia | 51700 | 36032 | 384 |
2317045 | 2317045 | 2022-03-17 | Newport News city | Virginia | 51700 | 36023 | 384 |
2313792 | 2313792 | 2022-03-16 | Newport News city | Virginia | 51700 | 36017 | 384 |
2310539 | 2310539 | 2022-03-15 | Newport News city | Virginia | 51700 | 36008 | 383 |
2307286 | 2307286 | 2022-03-14 | Newport News city | Virginia | 51700 | 35972 | 382 |
2304035 | 2304035 | 2022-03-13 | Newport News city | Virginia | 51700 | 35948 | 381 |
2300783 | 2300783 | 2022-03-12 | Newport News city | Virginia | 51700 | 35948 | 381 |
2297531 | 2297531 | 2022-03-11 | Newport News city | Virginia | 51700 | 35948 | 381 |
2294279 | 2294279 | 2022-03-10 | Newport News city | Virginia | 51700 | 35931 | 381 |
2291027 | 2291027 | 2022-03-09 | Newport News city | Virginia | 51700 | 35923 | 381 |
2287775 | 2287775 | 2022-03-08 | Newport News city | Virginia | 51700 | 35920 | 380 |
2284523 | 2284523 | 2022-03-07 | Newport News city | Virginia | 51700 | 35917 | 380 |
2281271 | 2281271 | 2022-03-06 | Newport News city | Virginia | 51700 | 35889 | 378 |
2278018 | 2278018 | 2022-03-05 | Newport News city | Virginia | 51700 | 35889 | 378 |
2274765 | 2274765 | 2022-03-04 | Newport News city | Virginia | 51700 | 35889 | 378 |
2271512 | 2271512 | 2022-03-03 | Newport News city | Virginia | 51700 | 35880 | 378 |
2268260 | 2268260 | 2022-03-02 | Newport News city | Virginia | 51700 | 35861 | 378 |
2265007 | 2265007 | 2022-03-01 | Newport News city | Virginia | 51700 | 35850 | 375 |
2261757 | 2261757 | 2022-02-28 | Newport News city | Virginia | 51700 | 35842 | 374 |
2258506 | 2258506 | 2022-02-27 | Newport News city | Virginia | 51700 | 35803 | 368 |
2255255 | 2255255 | 2022-02-26 | Newport News city | Virginia | 51700 | 35803 | 368 |
2252004 | 2252004 | 2022-02-25 | Newport News city | Virginia | 51700 | 35803 | 368 |
2248753 | 2248753 | 2022-02-24 | Newport News city | Virginia | 51700 | 35771 | 365 |
2245502 | 2245502 | 2022-02-23 | Newport News city | Virginia | 51700 | 35742 | 362 |
2242251 | 2242251 | 2022-02-22 | Newport News city | Virginia | 51700 | 35720 | 359 |
2239000 | 2239000 | 2022-02-21 | Newport News city | Virginia | 51700 | 35708 | 358 |
2235749 | 2235749 | 2022-02-20 | Newport News city | Virginia | 51700 | 35644 | 357 |
2232498 | 2232498 | 2022-02-19 | Newport News city | Virginia | 51700 | 35644 | 357 |
2229247 | 2229247 | 2022-02-18 | Newport News city | Virginia | 51700 | 35644 | 357 |
2225996 | 2225996 | 2022-02-17 | Newport News city | Virginia | 51700 | 35614 | 354 |
2222745 | 2222745 | 2022-02-16 | Newport News city | Virginia | 51700 | 35575 | 353 |
2219494 | 2219494 | 2022-02-15 | Newport News city | Virginia | 51700 | 35550 | 351 |
2216244 | 2216244 | 2022-02-14 | Newport News city | Virginia | 51700 | 35515 | 350 |
2212993 | 2212993 | 2022-02-13 | Newport News city | Virginia | 51700 | 35414 | 347 |
2209740 | 2209740 | 2022-02-12 | Newport News city | Virginia | 51700 | 35414 | 347 |
2206487 | 2206487 | 2022-02-11 | Newport News city | Virginia | 51700 | 35414 | 347 |
2203234 | 2203234 | 2022-02-10 | Newport News city | Virginia | 51700 | 35367 | 344 |
2199980 | 2199980 | 2022-02-09 | Newport News city | Virginia | 51700 | 35294 | 344 |
2196726 | 2196726 | 2022-02-08 | Newport News city | Virginia | 51700 | 35216 | 342 |
2193471 | 2193471 | 2022-02-07 | Newport News city | Virginia | 51700 | 35160 | 341 |
2190218 | 2190218 | 2022-02-06 | Newport News city | Virginia | 51700 | 34931 | 333 |
2186965 | 2186965 | 2022-02-05 | Newport News city | Virginia | 51700 | 34931 | 333 |
2183712 | 2183712 | 2022-02-04 | Newport News city | Virginia | 51700 | 34931 | 333 |
2180460 | 2180460 | 2022-02-03 | Newport News city | Virginia | 51700 | 34820 | 333 |
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);