ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 53031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 368 ✖
- 28 29
- 71 21
- 30 16
- 31 14
- 50 14
- 338 13
- 70 12
- 1 9
- 54 9
- 29 8
- 41 7
- 337 7
- 412 7
- 414 7
- 38 6
- 69 6
- 1149 6
- 4 5
- 33 5
- 75 5
- 81 5
- 345 5
- 411 5
- 416 5
- 1217 5
- 2788 5
- 2831 5
- 2959 5
- 3124 5
- 32 4
- 51 4
- 325 4
- 329 4
- 333 4
- 385 4
- 450 4
- 470 4
- 733 4
- 1021 4
- 1353 4
- 1447 4
- 1949 4
- 3010 4
- 14 3
- 27 3
- 76 3
- 80 3
- 86 3
- 87 3
- 88 3
- 204 3
- 220 3
- 273 3
- 281 3
- 331 3
- 364 3
- 439 3
- 459 3
- 477 3
- 504 3
- 527 3
- 563 3
- 624 3
- 660 3
- 824 3
- 873 3
- 927 3
- 971 3
- 1003 3
- 1061 3
- 1094 3
- 1133 3
- 1190 3
- 1260 3
- 1294 3
- 1323 3
- 1666 3
- 2191 3
- 2452 3
- 2621 3
- 2745 3
- 2870 3
- 2911 3
- 2921 3
- 2934 3
- 2947 3
- 2992 3
- 3022 3
- 3074 3
- 3 2
- 11 2
- 19 2
- 36 2
- 37 2
- 53 2
- 56 2
- 59 2
- 72 2
- 89 2
- 90 2
- 91 2
- 94 2
- 139 2
- 152 2
- 164 2
- 176 2
- 180 2
- 198 2
- 211 2
- 214 2
- 238 2
- 254 2
- 267 2
- 292 2
- 309 2
- 317 2
- 335 2
- 343 2
- 348 2
- 349 2
- 351 2
- 353 2
- 360 2
- 371 2
- 380 2
- 388 2
- 395 2
- 403 2
- 419 2
- 426 2
- 428 2
- 437 2
- 447 2
- 448 2
- 449 2
- 455 2
- 1012 2
- 1240 2
- 2291 2
- 2385 2
- 2542 2
- 2587 2
- 2662 2
- 2683 2
- 2781 2
- 2793 2
- 2854 2
- 2863 2
- 2877 2
- 2897 2
- 2912 2
- 2914 2
- 2917 2
- 2925 2
- 2939 2
- 2944 2
- 2949 2
- 2953 2
- 2977 2
- 3047 2
- 3060 2
- 3089 2
- 3159 2
- 3180 2
- 6 1
- 7 1
- 8 1
- 10 1
- 13 1
- 17 1
- 20 1
- 22 1
- 35 1
- 39 1
- 43 1
- 44 1
- 57 1
- 61 1
- 62 1
- 63 1
- 65 1
- 66 1
- 67 1
- 74 1
- 79 1
- 82 1
- 84 1
- 92 1
- 93 1
- 103 1
- 106 1
- 112 1
- 114 1
- 115 1
- 122 1
- 123 1
- 128 1
- 134 1
- 146 1
- 149 1
- 159 1
- 161 1
- 167 1
- 169 1
- 170 1
- 171 1
- 186 1
- 188 1
- 191 1
- 193 1
- 195 1
- 196 1
- 201 1
- 205 1
- 207 1
- 209 1
- 216 1
- 218 1
- 219 1
- 229 1
- 233 1
- 246 1
- 252 1
- 256 1
- 258 1
- 259 1
- 261 1
- 276 1
- 277 1
- 279 1
- 284 1
- 286 1
- 290 1
- 291 1
- 308 1
- 312 1
- 316 1
- 328 1
- 339 1
- 342 1
- 344 1
- 346 1
- 347 1
- 356 1
- 357 1
- 359 1
- 362 1
- 363 1
- 373 1
- 378 1
- 381 1
- 390 1
- 396 1
- 397 1
- 398 1
- 400 1
- 402 1
- 405 1
- 406 1
- 407 1
- 415 1
- 420 1
- 432 1
- 436 1
- 438 1
- 441 1
- 443 1
- 444 1
- 445 1
- 454 1
- 462 1
- 465 1
- 468 1
- 469 1
- 473 1
- 474 1
- 478 1
- 490 1
- 495 1
- 496 1
- 501 1
- 510 1
- 518 1
- 521 1
- 524 1
- 540 1
- 541 1
- 549 1
- 553 1
- 579 1
- 602 1
- 609 1
- 617 1
- 637 1
- 640 1
- 645 1
- 651 1
- 686 1
- 697 1
- 708 1
- 723 1
- 787 1
- 799 1
- 811 1
- 844 1
- 852 1
- 861 1
- 867 1
- 889 1
- 903 1
- 915 1
- 925 1
- 945 1
- 956 1
- 958 1
- 968 1
- 986 1
- 989 1
- 992 1
- 997 1
- 1015 1
- 1016 1
- 1037 1
- 1041 1
- 1046 1
- 1080 1
- 1081 1
- 1085 1
- 1091 1
- 1108 1
- 1111 1
- 1117 1
- 1120 1
- 1146 1
- 1160 1
- 1168 1
- 1172 1
- 1185 1
- 1211 1
- 1214 1
- 1236 1
- 1250 1
- 1263 1
- 1276 1
- 1281 1
- 1285 1
- 1304 1
- 1309 1
- 1314 1
- 1318 1
- 1332 1
- 1334 1
- 1344 1
- 1410 1
- 1413 1
- 1431 1
- 1522 1
- 1544 1
- 1567 1
- 1608 1
- 1764 1
- 1793 1
- 1847 1
- 1915 1
- 2046 1
- 2080 1
- 2128 1
- 3198 1
state 1
- Washington 799
fips 1
- 53031 · 799 ✖
county 1
- Jefferson 799
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502658 | 2502658 | 2022-05-13 | Jefferson | Washington | 53031 | 3198 | 29 |
2499400 | 2499400 | 2022-05-12 | Jefferson | Washington | 53031 | 3180 | 29 |
2496142 | 2496142 | 2022-05-11 | Jefferson | Washington | 53031 | 3180 | 29 |
2492884 | 2492884 | 2022-05-10 | Jefferson | Washington | 53031 | 3159 | 28 |
2489626 | 2489626 | 2022-05-09 | Jefferson | Washington | 53031 | 3159 | 28 |
2486369 | 2486369 | 2022-05-08 | Jefferson | Washington | 53031 | 3124 | 28 |
2483111 | 2483111 | 2022-05-07 | Jefferson | Washington | 53031 | 3124 | 28 |
2479853 | 2479853 | 2022-05-06 | Jefferson | Washington | 53031 | 3124 | 28 |
2476595 | 2476595 | 2022-05-05 | Jefferson | Washington | 53031 | 3124 | 28 |
2473337 | 2473337 | 2022-05-04 | Jefferson | Washington | 53031 | 3124 | 28 |
2470081 | 2470081 | 2022-05-03 | Jefferson | Washington | 53031 | 3089 | 28 |
2466825 | 2466825 | 2022-05-02 | Jefferson | Washington | 53031 | 3089 | 28 |
2463570 | 2463570 | 2022-05-01 | Jefferson | Washington | 53031 | 3074 | 28 |
2460314 | 2460314 | 2022-04-30 | Jefferson | Washington | 53031 | 3074 | 28 |
2457058 | 2457058 | 2022-04-29 | Jefferson | Washington | 53031 | 3074 | 28 |
2453802 | 2453802 | 2022-04-28 | Jefferson | Washington | 53031 | 3060 | 28 |
2450546 | 2450546 | 2022-04-27 | Jefferson | Washington | 53031 | 3060 | 28 |
2447290 | 2447290 | 2022-04-26 | Jefferson | Washington | 53031 | 3047 | 28 |
2444034 | 2444034 | 2022-04-25 | Jefferson | Washington | 53031 | 3047 | 28 |
2440778 | 2440778 | 2022-04-24 | Jefferson | Washington | 53031 | 3022 | 28 |
2437522 | 2437522 | 2022-04-23 | Jefferson | Washington | 53031 | 3022 | 28 |
2434266 | 2434266 | 2022-04-22 | Jefferson | Washington | 53031 | 3022 | 28 |
2431010 | 2431010 | 2022-04-21 | Jefferson | Washington | 53031 | 3010 | 28 |
2427754 | 2427754 | 2022-04-20 | Jefferson | Washington | 53031 | 3010 | 28 |
2424498 | 2424498 | 2022-04-19 | Jefferson | Washington | 53031 | 3010 | 28 |
2421242 | 2421242 | 2022-04-18 | Jefferson | Washington | 53031 | 3010 | 28 |
2417986 | 2417986 | 2022-04-17 | Jefferson | Washington | 53031 | 2992 | 28 |
2414730 | 2414730 | 2022-04-16 | Jefferson | Washington | 53031 | 2992 | 28 |
2411474 | 2411474 | 2022-04-15 | Jefferson | Washington | 53031 | 2992 | 28 |
2408218 | 2408218 | 2022-04-14 | Jefferson | Washington | 53031 | 2977 | 28 |
2404962 | 2404962 | 2022-04-13 | Jefferson | Washington | 53031 | 2977 | 28 |
2401707 | 2401707 | 2022-04-12 | Jefferson | Washington | 53031 | 2959 | 28 |
2398452 | 2398452 | 2022-04-11 | Jefferson | Washington | 53031 | 2959 | 28 |
2395197 | 2395197 | 2022-04-10 | Jefferson | Washington | 53031 | 2959 | 28 |
2391941 | 2391941 | 2022-04-09 | Jefferson | Washington | 53031 | 2959 | 28 |
2388685 | 2388685 | 2022-04-08 | Jefferson | Washington | 53031 | 2959 | 28 |
2385430 | 2385430 | 2022-04-07 | Jefferson | Washington | 53031 | 2953 | 28 |
2382175 | 2382175 | 2022-04-06 | Jefferson | Washington | 53031 | 2953 | 28 |
2378920 | 2378920 | 2022-04-05 | Jefferson | Washington | 53031 | 2949 | 28 |
2375666 | 2375666 | 2022-04-04 | Jefferson | Washington | 53031 | 2949 | 28 |
2372414 | 2372414 | 2022-04-03 | Jefferson | Washington | 53031 | 2947 | 28 |
2369161 | 2369161 | 2022-04-02 | Jefferson | Washington | 53031 | 2947 | 28 |
2365908 | 2365908 | 2022-04-01 | Jefferson | Washington | 53031 | 2947 | 28 |
2362655 | 2362655 | 2022-03-31 | Jefferson | Washington | 53031 | 2944 | 28 |
2359401 | 2359401 | 2022-03-30 | Jefferson | Washington | 53031 | 2944 | 28 |
2356147 | 2356147 | 2022-03-29 | Jefferson | Washington | 53031 | 2939 | 28 |
2352894 | 2352894 | 2022-03-28 | Jefferson | Washington | 53031 | 2939 | 28 |
2349642 | 2349642 | 2022-03-27 | Jefferson | Washington | 53031 | 2934 | 28 |
2346389 | 2346389 | 2022-03-26 | Jefferson | Washington | 53031 | 2934 | 28 |
2343136 | 2343136 | 2022-03-25 | Jefferson | Washington | 53031 | 2934 | 28 |
2339883 | 2339883 | 2022-03-24 | Jefferson | Washington | 53031 | 2925 | 28 |
2336630 | 2336630 | 2022-03-23 | Jefferson | Washington | 53031 | 2925 | 28 |
2333376 | 2333376 | 2022-03-22 | Jefferson | Washington | 53031 | 2917 | 28 |
2330122 | 2330122 | 2022-03-21 | Jefferson | Washington | 53031 | 2917 | 28 |
2326870 | 2326870 | 2022-03-20 | Jefferson | Washington | 53031 | 2921 | 28 |
2323617 | 2323617 | 2022-03-19 | Jefferson | Washington | 53031 | 2921 | 28 |
2320363 | 2320363 | 2022-03-18 | Jefferson | Washington | 53031 | 2921 | 28 |
2317109 | 2317109 | 2022-03-17 | Jefferson | Washington | 53031 | 2914 | 28 |
2313856 | 2313856 | 2022-03-16 | Jefferson | Washington | 53031 | 2914 | 28 |
2310603 | 2310603 | 2022-03-15 | Jefferson | Washington | 53031 | 2912 | 28 |
2307350 | 2307350 | 2022-03-14 | Jefferson | Washington | 53031 | 2912 | 28 |
2304099 | 2304099 | 2022-03-13 | Jefferson | Washington | 53031 | 2911 | 28 |
2300847 | 2300847 | 2022-03-12 | Jefferson | Washington | 53031 | 2911 | 28 |
2297595 | 2297595 | 2022-03-11 | Jefferson | Washington | 53031 | 2911 | 28 |
2294343 | 2294343 | 2022-03-10 | Jefferson | Washington | 53031 | 2897 | 28 |
2291091 | 2291091 | 2022-03-09 | Jefferson | Washington | 53031 | 2897 | 28 |
2287839 | 2287839 | 2022-03-08 | Jefferson | Washington | 53031 | 2877 | 28 |
2284587 | 2284587 | 2022-03-07 | Jefferson | Washington | 53031 | 2877 | 28 |
2281335 | 2281335 | 2022-03-06 | Jefferson | Washington | 53031 | 2870 | 28 |
2278082 | 2278082 | 2022-03-05 | Jefferson | Washington | 53031 | 2870 | 28 |
2274829 | 2274829 | 2022-03-04 | Jefferson | Washington | 53031 | 2870 | 28 |
2271576 | 2271576 | 2022-03-03 | Jefferson | Washington | 53031 | 2863 | 27 |
2268324 | 2268324 | 2022-03-02 | Jefferson | Washington | 53031 | 2863 | 27 |
2265071 | 2265071 | 2022-03-01 | Jefferson | Washington | 53031 | 2854 | 27 |
2261821 | 2261821 | 2022-02-28 | Jefferson | Washington | 53031 | 2854 | 27 |
2258570 | 2258570 | 2022-02-27 | Jefferson | Washington | 53031 | 2831 | 27 |
2255319 | 2255319 | 2022-02-26 | Jefferson | Washington | 53031 | 2831 | 27 |
2252068 | 2252068 | 2022-02-25 | Jefferson | Washington | 53031 | 2831 | 27 |
2248817 | 2248817 | 2022-02-24 | Jefferson | Washington | 53031 | 2831 | 25 |
2245566 | 2245566 | 2022-02-23 | Jefferson | Washington | 53031 | 2831 | 25 |
2242315 | 2242315 | 2022-02-22 | Jefferson | Washington | 53031 | 2788 | 25 |
2239064 | 2239064 | 2022-02-21 | Jefferson | Washington | 53031 | 2788 | 25 |
2235813 | 2235813 | 2022-02-20 | Jefferson | Washington | 53031 | 2788 | 25 |
2232562 | 2232562 | 2022-02-19 | Jefferson | Washington | 53031 | 2788 | 25 |
2229311 | 2229311 | 2022-02-18 | Jefferson | Washington | 53031 | 2788 | 25 |
2226060 | 2226060 | 2022-02-17 | Jefferson | Washington | 53031 | 2793 | 25 |
2222809 | 2222809 | 2022-02-16 | Jefferson | Washington | 53031 | 2793 | 25 |
2219558 | 2219558 | 2022-02-15 | Jefferson | Washington | 53031 | 2781 | 24 |
2216308 | 2216308 | 2022-02-14 | Jefferson | Washington | 53031 | 2781 | 24 |
2213057 | 2213057 | 2022-02-13 | Jefferson | Washington | 53031 | 2745 | 24 |
2209804 | 2209804 | 2022-02-12 | Jefferson | Washington | 53031 | 2745 | 24 |
2206551 | 2206551 | 2022-02-11 | Jefferson | Washington | 53031 | 2745 | 24 |
2203298 | 2203298 | 2022-02-10 | Jefferson | Washington | 53031 | 2683 | 24 |
2200044 | 2200044 | 2022-02-09 | Jefferson | Washington | 53031 | 2683 | 24 |
2196790 | 2196790 | 2022-02-08 | Jefferson | Washington | 53031 | 2662 | 24 |
2193535 | 2193535 | 2022-02-07 | Jefferson | Washington | 53031 | 2662 | 24 |
2190282 | 2190282 | 2022-02-06 | Jefferson | Washington | 53031 | 2621 | 23 |
2187029 | 2187029 | 2022-02-05 | Jefferson | Washington | 53031 | 2621 | 23 |
2183776 | 2183776 | 2022-02-04 | Jefferson | Washington | 53031 | 2621 | 23 |
2180524 | 2180524 | 2022-02-03 | Jefferson | Washington | 53031 | 2587 | 23 |
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);