ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Suffolk city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 660 ✖
- 1 9
- 8002 4
- 10518 4
- 7994 3
- 8001 3
- 8003 3
- 8055 3
- 8120 3
- 8195 3
- 8360 3
- 8584 3
- 8789 3
- 9065 3
- 9347 3
- 9560 3
- 9808 3
- 10082 3
- 10284 3
- 10700 3
- 10815 3
- 10911 3
- 11005 3
- 11076 3
- 11139 3
- 11218 3
- 11299 3
- 11427 3
- 11627 3
- 11876 3
- 12561 3
- 13867 3
- 15419 3
- 16900 3
- 17713 3
- 18112 3
- 18297 3
- 18406 3
- 18494 3
- 18531 3
- 18542 3
- 18561 3
- 18588 3
- 18610 3
- 18688 3
- 18726 3
- 18771 3
- 18836 3
- 18962 3
- 6 2
- 31 2
- 147 2
- 190 2
- 205 2
- 215 2
- 221 2
- 269 2
- 308 2
- 323 2
- 325 2
- 1984 2
- 7963 2
- 7988 2
- 8004 2
- 8006 2
- 8022 2
- 8024 2
- 18547 2
- 18568 2
- 3 1
- 4 1
- 10 1
- 20 1
- 22 1
- 28 1
- 30 1
- 35 1
- 40 1
- 48 1
- 51 1
- 57 1
- 59 1
- 65 1
- 70 1
- 81 1
- 91 1
- 92 1
- 111 1
- 126 1
- 136 1
- 138 1
- 141 1
- 152 1
- 154 1
- 169 1
- 175 1
- 178 1
- 208 1
- 209 1
- 216 1
- 219 1
- 255 1
- 260 1
- 264 1
- 274 1
- 278 1
- 283 1
- 290 1
- 295 1
- 300 1
- 303 1
- 311 1
- 314 1
- 315 1
- 316 1
- 317 1
- 318 1
- 320 1
- 322 1
- 330 1
- 333 1
- 337 1
- 341 1
- 344 1
- 345 1
- 347 1
- 348 1
- 349 1
- 353 1
- 356 1
- 365 1
- 377 1
- 380 1
- 385 1
- 389 1
- 393 1
- 397 1
- 398 1
- 403 1
- 414 1
- 420 1
- 425 1
- 441 1
- 443 1
- 451 1
- 457 1
- 470 1
- 487 1
- 504 1
- 526 1
- 535 1
- 554 1
- 573 1
- 612 1
- 633 1
- 647 1
- 676 1
- 701 1
- 725 1
- 757 1
- 780 1
- 797 1
- 826 1
- 862 1
- 886 1
- 914 1
- 948 1
- 974 1
- 989 1
- 1001 1
- 1034 1
- 1059 1
- 1092 1
- 1112 1
- 1141 1
- 1167 1
- 1184 1
- 1231 1
- 1258 1
- 1282 1
- 1297 1
- 1316 1
- 1334 1
- 1351 1
- 1379 1
- 1401 1
- 1425 1
- 1438 1
- 1458 1
- 1476 1
- 1483 1
- 1503 1
- 1521 1
- 1536 1
- 1545 1
- 1553 1
- 1573 1
- 1590 1
- 1603 1
- 1620 1
- 1631 1
- 1635 1
- 1660 1
- 1674 1
- 1693 1
- 1705 1
- 1719 1
- 1728 1
- 1733 1
- 1748 1
- 1758 1
- 1773 1
- 1780 1
- 1810 1
- 1835 1
- 1842 1
- 1858 1
- 1859 1
- 1877 1
- 1885 1
- 1889 1
- 1893 1
- 1897 1
- 1908 1
- 1916 1
- 1928 1
- 1963 1
- 1970 1
- 1972 1
- 1974 1
- 1983 1
- 1989 1
- 1999 1
- 2114 1
- 2129 1
- 2132 1
- 2134 1
- 2164 1
- 2172 1
- 2189 1
- 2195 1
- 2199 1
- 2204 1
- 2211 1
- 2220 1
- 2229 1
- 2236 1
- 2245 1
- 2249 1
- 2256 1
- 2263 1
- 2266 1
- 2277 1
- 2280 1
- 2283 1
- 2284 1
- 2290 1
- 2300 1
- 2317 1
- 2324 1
- 2345 1
- 2346 1
- 2355 1
- 2364 1
- 2375 1
- 2384 1
- 2395 1
- 2404 1
- 2409 1
- 2422 1
- 2428 1
- 2437 1
- 2472 1
- 2480 1
- 2495 1
- 2523 1
- 2535 1
- 2548 1
- 2553 1
- 2565 1
- 2582 1
- 2602 1
- 2615 1
- 2631 1
- 2661 1
- 2678 1
- 2708 1
- 2715 1
- 2755 1
- 2762 1
- 2767 1
- 2776 1
- 2803 1
- 2812 1
- 2836 1
- 2867 1
- 2916 1
- 2965 1
- 2986 1
- 3022 1
- 3075 1
- 3120 1
- 3155 1
- 3211 1
- 3257 1
- 3287 1
- 3312 1
- 3354 1
- 3379 1
- 3423 1
- 3508 1
- 3552 1
- 3581 1
- 3635 1
- 3725 1
- 3781 1
- 3784 1
- 3841 1
- 3869 1
- 3890 1
- 3914 1
- 3987 1
- 4043 1
- 4059 1
- 4148 1
- 4214 1
- 4246 1
- 4282 1
- 4335 1
- 4395 1
- 4460 1
- 4510 1
- 4560 1
- 4588 1
- 4603 1
- 4638 1
- 4700 1
- 4800 1
- 4890 1
- 4956 1
- 5030 1
- 5116 1
- 5152 1
- 5201 1
- 5288 1
- 5328 1
- 5390 1
- 5454 1
- 5531 1
- 5620 1
- 5714 1
- 5778 1
- 5810 1
- 5865 1
- 5952 1
- 6011 1
- 6044 1
- 6096 1
- 6158 1
- 6220 1
- 6237 1
- 6312 1
- 6356 1
- 6406 1
- 6443 1
- 6489 1
- 6523 1
- 6558 1
- 6585 1
- 6606 1
- 6649 1
- 6671 1
- 6703 1
- 6741 1
- 6759 1
- 6776 1
- 6802 1
- 6841 1
- 6860 1
- 6876 1
- 6901 1
- 6909 1
- 6939 1
- 6963 1
- 6974 1
- 6995 1
- 7006 1
- 7017 1
- 7027 1
- 7037 1
- 7053 1
- 7067 1
- 7082 1
- 7099 1
- 7113 1
- 7127 1
- 7137 1
- 7143 1
- 7172 1
- 7175 1
- 7199 1
- 7215 1
- 7222 1
- 7230 1
- 7253 1
- 7282 1
- 7307 1
- 7326 1
- 7348 1
- 7357 1
- 7374 1
- 7391 1
- 7412 1
- 7432 1
- 7456 1
- 7467 1
- 7476 1
- 7492 1
- 7507 1
- 7524 1
- 7546 1
- 7568 1
- 7577 1
- 7597 1
- 7622 1
- 7629 1
- 7646 1
- 7664 1
- 7683 1
- 7688 1
- 7696 1
- 7707 1
- 7715 1
- 7728 1
- 7743 1
- 7759 1
- 7765 1
- 7770 1
- 7786 1
- 7796 1
- 7807 1
- 7821 1
- 7830 1
- 7834 1
- 7837 1
- 7848 1
- 7858 1
- 7866 1
- 7871 1
- 7879 1
- 7883 1
- 7886 1
- 7889 1
- 7891 1
- 7899 1
- 7911 1
- 7926 1
- 7928 1
- 7930 1
- 7938 1
- 7941 1
- 7944 1
- 7948 1
- 7949 1
- 7952 1
- 7955 1
- 7966 1
- 7970 1
- 7972 1
- 7974 1
- 7976 1
- 7977 1
- 7978 1
- 7980 1
- 7984 1
- 7985 1
- 7991 1
- 7995 1
- 7996 1
- 7997 1
- 8000 1
- 8005 1
- 8007 1
- 8009 1
- 8010 1
- 8013 1
- 8014 1
- 8015 1
- 8017 1
- 8023 1
- 8035 1
- 8039 1
- 8045 1
- 8072 1
- 8094 1
- 8100 1
- 8109 1
- 8136 1
- 8158 1
- 8172 1
- 8187 1
- 8240 1
- 8257 1
- 8301 1
- 8334 1
- 8441 1
- 8483 1
- 8504 1
- 8541 1
- 8659 1
- 8688 1
- 8723 1
- 8746 1
- 8897 1
- 8957 1
- 9000 1
- 9038 1
- 9173 1
- 9230 1
- 9267 1
- 9311 1
- 9438 1
- 9471 1
- 9498 1
- 9525 1
- 9660 1
- 9696 1
- 9742 1
- 9774 1
- 9901 1
- 9956 1
- 9989 1
- 10046 1
- 10149 1
- 10196 1
- 10225 1
- 10259 1
- 10372 1
- 10421 1
- 10461 1
- 10488 1
- 10618 1
- 10645 1
- 10670 1
- 10739 1
- 10772 1
- 10793 1
- 10803 1
- 10852 1
- 10872 1
- 10892 1
- 10903 1
- 10940 1
- 10959 1
- 10974 1
- 10996 1
- 11035 1
- 11049 1
- 11055 1
- 11064 1
- 11093 1
- 11098 1
- 11117 1
- 11124 1
- 11173 1
- 11189 1
- 11198 1
- 11209 1
- 11243 1
- 11253 1
- 11257 1
- 11290 1
- 11346 1
- 11364 1
- 11385 1
- 11412 1
- 11499 1
- 11535 1
- 11562 1
- 11592 1
- 11684 1
- 11718 1
- 11763 1
- 11808 1
- 12019 1
- 12070 1
- 12207 1
- 12351 1
- 12982 1
- 13187 1
- 13368 1
- 13606 1
- 14563 1
- 14744 1
- 14957 1
- 15188 1
- 16029 1
- 16187 1
- 16438 1
- 16679 1
- 17240 1
- 17318 1
- 17506 1
- 17616 1
- 17879 1
- 17952 1
- 18011 1
- 18058 1
- 18182 1
- 18205 1
- 18231 1
- 18269 1
- 18345 1
- 18359 1
- 18375 1
- 18389 1
- 18452 1
- 18461 1
- 18472 1
- 18485 1
- 18507 1
- 18512 1
- 18521 1
- 18527 1
- 18538 1
- 18545 1
- 18546 1
- 18550 1
- 18554 1
- 18560 1
- 18581 1
- 18583 1
- 18591 1
- 18596 1
- 18598 1
- 18602 1
- 18634 1
- 18636 1
- 18655 1
- 18677 1
- 18699 1
- 18705 1
- 18708 1
- 18711 1
- 18738 1
- 18744 1
- 18757 1
- 18765 1
- 18794 1
- 18801 1
- 18812 1
- 18822 1
- 18866 1
- 18873 1
- 18902 1
- 18933 1
- 19022 1
- 19049 1
- 19067 1
- 19102 1
- 19133 1
state 1
- Virginia · 784 ✖
fips 1
- 51800 784
county 1
- Suffolk city · 784 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502629 | 2502629 | 2022-05-13 | Suffolk city | Virginia | 51800 | 19133 | 302 |
2499371 | 2499371 | 2022-05-12 | Suffolk city | Virginia | 51800 | 19102 | 302 |
2496113 | 2496113 | 2022-05-11 | Suffolk city | Virginia | 51800 | 19067 | 302 |
2492855 | 2492855 | 2022-05-10 | Suffolk city | Virginia | 51800 | 19049 | 302 |
2489597 | 2489597 | 2022-05-09 | Suffolk city | Virginia | 51800 | 19022 | 302 |
2486340 | 2486340 | 2022-05-08 | Suffolk city | Virginia | 51800 | 18962 | 302 |
2483082 | 2483082 | 2022-05-07 | Suffolk city | Virginia | 51800 | 18962 | 302 |
2479824 | 2479824 | 2022-05-06 | Suffolk city | Virginia | 51800 | 18962 | 302 |
2476566 | 2476566 | 2022-05-05 | Suffolk city | Virginia | 51800 | 18933 | 302 |
2473308 | 2473308 | 2022-05-04 | Suffolk city | Virginia | 51800 | 18902 | 302 |
2470052 | 2470052 | 2022-05-03 | Suffolk city | Virginia | 51800 | 18873 | 302 |
2466796 | 2466796 | 2022-05-02 | Suffolk city | Virginia | 51800 | 18866 | 302 |
2463541 | 2463541 | 2022-05-01 | Suffolk city | Virginia | 51800 | 18836 | 302 |
2460285 | 2460285 | 2022-04-30 | Suffolk city | Virginia | 51800 | 18836 | 302 |
2457029 | 2457029 | 2022-04-29 | Suffolk city | Virginia | 51800 | 18836 | 302 |
2453773 | 2453773 | 2022-04-28 | Suffolk city | Virginia | 51800 | 18822 | 302 |
2450517 | 2450517 | 2022-04-27 | Suffolk city | Virginia | 51800 | 18812 | 301 |
2447260 | 2447260 | 2022-04-26 | Suffolk city | Virginia | 51800 | 18801 | 301 |
2444005 | 2444005 | 2022-04-25 | Suffolk city | Virginia | 51800 | 18794 | 301 |
2440749 | 2440749 | 2022-04-24 | Suffolk city | Virginia | 51800 | 18771 | 301 |
2437493 | 2437493 | 2022-04-23 | Suffolk city | Virginia | 51800 | 18771 | 301 |
2434237 | 2434237 | 2022-04-22 | Suffolk city | Virginia | 51800 | 18771 | 301 |
2430981 | 2430981 | 2022-04-21 | Suffolk city | Virginia | 51800 | 18765 | 300 |
2427725 | 2427725 | 2022-04-20 | Suffolk city | Virginia | 51800 | 18757 | 301 |
2424469 | 2424469 | 2022-04-19 | Suffolk city | Virginia | 51800 | 18744 | 299 |
2421213 | 2421213 | 2022-04-18 | Suffolk city | Virginia | 51800 | 18738 | 299 |
2417957 | 2417957 | 2022-04-17 | Suffolk city | Virginia | 51800 | 18726 | 299 |
2414701 | 2414701 | 2022-04-16 | Suffolk city | Virginia | 51800 | 18726 | 299 |
2411445 | 2411445 | 2022-04-15 | Suffolk city | Virginia | 51800 | 18726 | 299 |
2408189 | 2408189 | 2022-04-14 | Suffolk city | Virginia | 51800 | 18711 | 299 |
2404933 | 2404933 | 2022-04-13 | Suffolk city | Virginia | 51800 | 18708 | 298 |
2401678 | 2401678 | 2022-04-12 | Suffolk city | Virginia | 51800 | 18705 | 298 |
2398423 | 2398423 | 2022-04-11 | Suffolk city | Virginia | 51800 | 18699 | 297 |
2395168 | 2395168 | 2022-04-10 | Suffolk city | Virginia | 51800 | 18688 | 297 |
2391912 | 2391912 | 2022-04-09 | Suffolk city | Virginia | 51800 | 18688 | 297 |
2388656 | 2388656 | 2022-04-08 | Suffolk city | Virginia | 51800 | 18688 | 297 |
2385401 | 2385401 | 2022-04-07 | Suffolk city | Virginia | 51800 | 18677 | 295 |
2382146 | 2382146 | 2022-04-06 | Suffolk city | Virginia | 51800 | 18655 | 294 |
2378891 | 2378891 | 2022-04-05 | Suffolk city | Virginia | 51800 | 18636 | 293 |
2375637 | 2375637 | 2022-04-04 | Suffolk city | Virginia | 51800 | 18634 | 293 |
2372385 | 2372385 | 2022-04-03 | Suffolk city | Virginia | 51800 | 18610 | 293 |
2369132 | 2369132 | 2022-04-02 | Suffolk city | Virginia | 51800 | 18610 | 293 |
2365879 | 2365879 | 2022-04-01 | Suffolk city | Virginia | 51800 | 18610 | 293 |
2362626 | 2362626 | 2022-03-31 | Suffolk city | Virginia | 51800 | 18602 | 293 |
2359372 | 2359372 | 2022-03-30 | Suffolk city | Virginia | 51800 | 18598 | 293 |
2356118 | 2356118 | 2022-03-29 | Suffolk city | Virginia | 51800 | 18596 | 293 |
2352865 | 2352865 | 2022-03-28 | Suffolk city | Virginia | 51800 | 18591 | 293 |
2349613 | 2349613 | 2022-03-27 | Suffolk city | Virginia | 51800 | 18588 | 293 |
2346360 | 2346360 | 2022-03-26 | Suffolk city | Virginia | 51800 | 18588 | 293 |
2343107 | 2343107 | 2022-03-25 | Suffolk city | Virginia | 51800 | 18588 | 293 |
2339854 | 2339854 | 2022-03-24 | Suffolk city | Virginia | 51800 | 18583 | 293 |
2336600 | 2336600 | 2022-03-23 | Suffolk city | Virginia | 51800 | 18581 | 293 |
2333346 | 2333346 | 2022-03-22 | Suffolk city | Virginia | 51800 | 18568 | 292 |
2330093 | 2330093 | 2022-03-21 | Suffolk city | Virginia | 51800 | 18568 | 292 |
2326841 | 2326841 | 2022-03-20 | Suffolk city | Virginia | 51800 | 18561 | 292 |
2323588 | 2323588 | 2022-03-19 | Suffolk city | Virginia | 51800 | 18561 | 292 |
2320334 | 2320334 | 2022-03-18 | Suffolk city | Virginia | 51800 | 18561 | 292 |
2317080 | 2317080 | 2022-03-17 | Suffolk city | Virginia | 51800 | 18560 | 291 |
2313827 | 2313827 | 2022-03-16 | Suffolk city | Virginia | 51800 | 18554 | 291 |
2310574 | 2310574 | 2022-03-15 | Suffolk city | Virginia | 51800 | 18550 | 289 |
2307321 | 2307321 | 2022-03-14 | Suffolk city | Virginia | 51800 | 18546 | 289 |
2304070 | 2304070 | 2022-03-13 | Suffolk city | Virginia | 51800 | 18542 | 289 |
2300818 | 2300818 | 2022-03-12 | Suffolk city | Virginia | 51800 | 18542 | 289 |
2297566 | 2297566 | 2022-03-11 | Suffolk city | Virginia | 51800 | 18542 | 289 |
2294314 | 2294314 | 2022-03-10 | Suffolk city | Virginia | 51800 | 18545 | 288 |
2291062 | 2291062 | 2022-03-09 | Suffolk city | Virginia | 51800 | 18547 | 288 |
2287810 | 2287810 | 2022-03-08 | Suffolk city | Virginia | 51800 | 18547 | 288 |
2284558 | 2284558 | 2022-03-07 | Suffolk city | Virginia | 51800 | 18538 | 288 |
2281306 | 2281306 | 2022-03-06 | Suffolk city | Virginia | 51800 | 18531 | 286 |
2278053 | 2278053 | 2022-03-05 | Suffolk city | Virginia | 51800 | 18531 | 286 |
2274800 | 2274800 | 2022-03-04 | Suffolk city | Virginia | 51800 | 18531 | 286 |
2271547 | 2271547 | 2022-03-03 | Suffolk city | Virginia | 51800 | 18527 | 285 |
2268295 | 2268295 | 2022-03-02 | Suffolk city | Virginia | 51800 | 18521 | 285 |
2265042 | 2265042 | 2022-03-01 | Suffolk city | Virginia | 51800 | 18512 | 285 |
2261792 | 2261792 | 2022-02-28 | Suffolk city | Virginia | 51800 | 18507 | 284 |
2258541 | 2258541 | 2022-02-27 | Suffolk city | Virginia | 51800 | 18494 | 282 |
2255290 | 2255290 | 2022-02-26 | Suffolk city | Virginia | 51800 | 18494 | 282 |
2252039 | 2252039 | 2022-02-25 | Suffolk city | Virginia | 51800 | 18494 | 282 |
2248788 | 2248788 | 2022-02-24 | Suffolk city | Virginia | 51800 | 18485 | 281 |
2245537 | 2245537 | 2022-02-23 | Suffolk city | Virginia | 51800 | 18472 | 280 |
2242286 | 2242286 | 2022-02-22 | Suffolk city | Virginia | 51800 | 18461 | 278 |
2239035 | 2239035 | 2022-02-21 | Suffolk city | Virginia | 51800 | 18452 | 278 |
2235784 | 2235784 | 2022-02-20 | Suffolk city | Virginia | 51800 | 18406 | 275 |
2232533 | 2232533 | 2022-02-19 | Suffolk city | Virginia | 51800 | 18406 | 275 |
2229282 | 2229282 | 2022-02-18 | Suffolk city | Virginia | 51800 | 18406 | 275 |
2226031 | 2226031 | 2022-02-17 | Suffolk city | Virginia | 51800 | 18389 | 275 |
2222780 | 2222780 | 2022-02-16 | Suffolk city | Virginia | 51800 | 18375 | 275 |
2219529 | 2219529 | 2022-02-15 | Suffolk city | Virginia | 51800 | 18359 | 273 |
2216279 | 2216279 | 2022-02-14 | Suffolk city | Virginia | 51800 | 18345 | 272 |
2213028 | 2213028 | 2022-02-13 | Suffolk city | Virginia | 51800 | 18297 | 269 |
2209775 | 2209775 | 2022-02-12 | Suffolk city | Virginia | 51800 | 18297 | 269 |
2206522 | 2206522 | 2022-02-11 | Suffolk city | Virginia | 51800 | 18297 | 269 |
2203269 | 2203269 | 2022-02-10 | Suffolk city | Virginia | 51800 | 18269 | 268 |
2200015 | 2200015 | 2022-02-09 | Suffolk city | Virginia | 51800 | 18231 | 267 |
2196761 | 2196761 | 2022-02-08 | Suffolk city | Virginia | 51800 | 18205 | 267 |
2193506 | 2193506 | 2022-02-07 | Suffolk city | Virginia | 51800 | 18182 | 267 |
2190253 | 2190253 | 2022-02-06 | Suffolk city | Virginia | 51800 | 18112 | 264 |
2187000 | 2187000 | 2022-02-05 | Suffolk city | Virginia | 51800 | 18112 | 264 |
2183747 | 2183747 | 2022-02-04 | Suffolk city | Virginia | 51800 | 18112 | 264 |
2180495 | 2180495 | 2022-02-03 | Suffolk city | Virginia | 51800 | 18058 | 261 |
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);