ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,925 rows where county = "Pierce" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 453 ✖
- 0 525
- 21 325
- 20 205
- 25 155
- 44 102
- 32 89
- 29 72
- 4 70
- 7 68
- 24 68
- 43 66
- 26 61
- 55 55
- 27 54
- 8 53
- 72 48
- 5 42
- 39 40
- 62 37
- 73 35
- 6 34
- 3 33
- 41 33
- 2 30
- 31 30
- 1 28
- 22 28
- 42 24
- 108 24
- 56 21
- 104 21
- 14 20
- 30 20
- 35 19
- 63 19
- 65 19
- 57 18
- 107 18
- 130 18
- 18 17
- 19 17
- 28 17
- 61 17
- 131 17
- 12 16
- 33 16
- 37 16
- 106 16
- 11 15
- 13 15
- 51 15
- 52 15
- 46 14
- 60 14
- 9 13
- 45 13
- 23 12
- 70 12
- 71 12
- 125 12
- 17 11
- 38 11
- 47 11
- 58 11
- 105 11
- 34 10
- 50 10
- 100 10
- 102 10
- 129 10
- 655 10
- 1401 10
- 48 9
- 67 9
- 68 9
- 103 9
- 53 8
- 54 8
- 133 8
- 10 7
- 86 7
- 124 7
- 132 7
- 229 7
- 1374 7
- 1385 7
- 15 6
- 89 6
- 121 6
- 308 6
- 669 6
- 671 6
- 1011 6
- 64 5
- 66 5
- 79 5
- 82 5
- 97 5
- 101 5
- 116 5
- 305 5
- 315 5
- 597 5
- 636 5
- 647 5
- 666 5
- 955 5
- 1274 5
- 1393 5
- 49 4
- 74 4
- 77 4
- 85 4
- 87 4
- 90 4
- 110 4
- 113 4
- 114 4
- 119 4
- 122 4
- 193 4
- 211 4
- 241 4
- 268 4
- 295 4
- 348 4
- 387 4
- 415 4
- 507 4
- 603 4
- 634 4
- 642 4
- 661 4
- 663 4
- 664 4
- 668 4
- 673 4
- 681 4
- 694 4
- 704 4
- 724 4
- 739 4
- 846 4
- 1006 4
- 1061 4
- 16 3
- 40 3
- 59 3
- 92 3
- 111 3
- 156 3
- 179 3
- 201 3
- 220 3
- 223 3
- 245 3
- 256 3
- 346 3
- 442 3
- 467 3
- 484 3
- 527 3
- 551 3
- 563 3
- 584 3
- 613 3
- 621 3
- 630 3
- 631 3
- 646 3
- 649 3
- 667 3
- 677 3
- 700 3
- 762 3
- 780 3
- 805 3
- 825 3
- 864 3
- 877 3
- 898 3
- 902 3
- 916 3
- 944 3
- 977 3
- 987 3
- 994 3
- 1033 3
- 1094 3
- 1144 3
- 1183 3
- 1230 3
- 1309 3
- 1328 3
- 1349 3
- 1362 3
- 1373 3
- 1391 3
- 36 2
- 78 2
- 84 2
- 88 2
- 93 2
- 96 2
- 109 2
- 112 2
- 117 2
- 118 2
- 123 2
- 134 2
- 135 2
- 137 2
- 149 2
- 176 2
- 230 2
- 233 2
- 242 2
- 243 2
- 285 2
- 292 2
- 293 2
- 299 2
- 328 2
- 331 2
- 421 2
- 469 2
- 554 2
- 606 2
- 617 2
- 639 2
- 640 2
- 645 2
- 653 2
- 658 2
- 660 2
- 662 2
- 670 2
- 674 2
- 679 2
- 686 2
- 830 2
- 865 2
- 964 2
- 992 2
- 1017 2
- 1034 2
- 1063 2
- 1103 2
- 1123 2
- 1161 2
- 1176 2
- 1200 2
- 1215 2
- 1242 2
- 1261 2
- 1289 2
- 1308 2
- 1318 2
- 1336 2
- 1344 2
- 1352 2
- 1357 2
- 1364 2
- 1369 2
- 1375 2
- 1382 2
- 1392 2
- 1394 2
- 1395 2
- 1400 2
- 1406 2
- 75 1
- 76 1
- 81 1
- 83 1
- 98 1
- 99 1
- 120 1
- 138 1
- 144 1
- 145 1
- 148 1
- 151 1
- 153 1
- 154 1
- 157 1
- 159 1
- 165 1
- 168 1
- 169 1
- 171 1
- 172 1
- 173 1
- 177 1
- 181 1
- 187 1
- 190 1
- 191 1
- 195 1
- 196 1
- 198 1
- 206 1
- 208 1
- 209 1
- 212 1
- 213 1
- 227 1
- 232 1
- 234 1
- 235 1
- 237 1
- 248 1
- 249 1
- 250 1
- 254 1
- 259 1
- 260 1
- 263 1
- 272 1
- 275 1
- 276 1
- 278 1
- 281 1
- 288 1
- 291 1
- 296 1
- 302 1
- 310 1
- 318 1
- 321 1
- 327 1
- 335 1
- 337 1
- 344 1
- 347 1
- 359 1
- 366 1
- 377 1
- 378 1
- 395 1
- 405 1
- 411 1
- 436 1
- 446 1
- 450 1
- 456 1
- 459 1
- 477 1
- 481 1
- 483 1
- 496 1
- 501 1
- 503 1
- 510 1
- 519 1
- 525 1
- 532 1
- 536 1
- 542 1
- 545 1
- 556 1
- 561 1
- 570 1
- 574 1
- 577 1
- 583 1
- 586 1
- 587 1
- 590 1
- 593 1
- 599 1
- 605 1
- 610 1
- 614 1
- 616 1
- 623 1
- 625 1
- 627 1
- 628 1
- 629 1
- 632 1
- 638 1
- 651 1
- 656 1
- 672 1
- 675 1
- 678 1
- 683 1
- 689 1
- 690 1
- 693 1
- 695 1
- 696 1
- 698 1
- 701 1
- 702 1
- 706 1
- 710 1
- 716 1
- 726 1
- 732 1
- 746 1
- 752 1
- 756 1
- 759 1
- 767 1
- 772 1
- 773 1
- 776 1
- 784 1
- 787 1
- 794 1
- 800 1
- 807 1
- 811 1
- 816 1
- 823 1
- 840 1
- 844 1
- 853 1
- 857 1
- 866 1
- 867 1
- 873 1
- 880 1
- 888 1
- 892 1
- 895 1
- 901 1
- 920 1
- 926 1
- 931 1
- 938 1
- 949 1
- 950 1
- 956 1
- 974 1
- 976 1
- 980 1
- 981 1
- 985 1
- 986 1
- 990 1
- 998 1
- 1000 1
- 1003 1
- 1007 1
- 1009 1
- 1027 1
- 1047 1
- 1051 1
- 1082 1
- 1409 1
state 5
- Washington 799
- Wisconsin 796
- North Dakota 785
- Georgia 782
- Nebraska 763
county 1
- Pierce · 3,925 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500078 | 2500078 | 2022-05-13 | Pierce | Georgia | 13229 | 5694 | 130 |
2501318 | 2501318 | 2022-05-13 | Pierce | Nebraska | 31139 | 1258 | 21 |
2501620 | 2501620 | 2022-05-13 | Pierce | North Dakota | 38069 | 1065 | 32 |
2502669 | 2502669 | 2022-05-13 | Pierce | Washington | 53053 | 198375 | 1409 |
2502785 | 2502785 | 2022-05-13 | Pierce | Wisconsin | 55093 | 11879 | 73 |
2496820 | 2496820 | 2022-05-12 | Pierce | Georgia | 13229 | 5694 | 130 |
2498060 | 2498060 | 2022-05-12 | Pierce | Nebraska | 31139 | 1259 | 21 |
2498362 | 2498362 | 2022-05-12 | Pierce | North Dakota | 38069 | 1062 | 32 |
2499411 | 2499411 | 2022-05-12 | Pierce | Washington | 53053 | 197657 | 1406 |
2499527 | 2499527 | 2022-05-12 | Pierce | Wisconsin | 55093 | 11864 | 73 |
2493562 | 2493562 | 2022-05-11 | Pierce | Georgia | 13229 | 5694 | 130 |
2494802 | 2494802 | 2022-05-11 | Pierce | Nebraska | 31139 | 1259 | 21 |
2495104 | 2495104 | 2022-05-11 | Pierce | North Dakota | 38069 | 1062 | 32 |
2496153 | 2496153 | 2022-05-11 | Pierce | Washington | 53053 | 197657 | 1406 |
2496269 | 2496269 | 2022-05-11 | Pierce | Wisconsin | 55093 | 11842 | 73 |
2490304 | 2490304 | 2022-05-10 | Pierce | Georgia | 13229 | 5686 | 130 |
2491544 | 2491544 | 2022-05-10 | Pierce | Nebraska | 31139 | 1295 | 21 |
2491846 | 2491846 | 2022-05-10 | Pierce | North Dakota | 38069 | 1062 | 32 |
2492895 | 2492895 | 2022-05-10 | Pierce | Washington | 53053 | 197193 | 1400 |
2493011 | 2493011 | 2022-05-10 | Pierce | Wisconsin | 55093 | 11824 | 73 |
2487047 | 2487047 | 2022-05-09 | Pierce | Georgia | 13229 | 5686 | 130 |
2488286 | 2488286 | 2022-05-09 | Pierce | Nebraska | 31139 | 1295 | 21 |
2488588 | 2488588 | 2022-05-09 | Pierce | North Dakota | 38069 | 1062 | 32 |
2489637 | 2489637 | 2022-05-09 | Pierce | Washington | 53053 | 197193 | 1400 |
2489753 | 2489753 | 2022-05-09 | Pierce | Wisconsin | 55093 | 11785 | 73 |
2483789 | 2483789 | 2022-05-08 | Pierce | Georgia | 13229 | 5686 | 130 |
2485029 | 2485029 | 2022-05-08 | Pierce | Nebraska | 31139 | 1292 | 21 |
2485331 | 2485331 | 2022-05-08 | Pierce | North Dakota | 38069 | 1062 | 32 |
2486380 | 2486380 | 2022-05-08 | Pierce | Washington | 53053 | 196034 | 1401 |
2486496 | 2486496 | 2022-05-08 | Pierce | Wisconsin | 55093 | 11762 | 73 |
2480531 | 2480531 | 2022-05-07 | Pierce | Georgia | 13229 | 5686 | 130 |
2481771 | 2481771 | 2022-05-07 | Pierce | Nebraska | 31139 | 1292 | 21 |
2482073 | 2482073 | 2022-05-07 | Pierce | North Dakota | 38069 | 1062 | 32 |
2483122 | 2483122 | 2022-05-07 | Pierce | Washington | 53053 | 196034 | 1401 |
2483238 | 2483238 | 2022-05-07 | Pierce | Wisconsin | 55093 | 11762 | 73 |
2477273 | 2477273 | 2022-05-06 | Pierce | Georgia | 13229 | 5686 | 130 |
2478513 | 2478513 | 2022-05-06 | Pierce | Nebraska | 31139 | 1292 | 21 |
2478815 | 2478815 | 2022-05-06 | Pierce | North Dakota | 38069 | 1062 | 32 |
2479864 | 2479864 | 2022-05-06 | Pierce | Washington | 53053 | 196034 | 1401 |
2479980 | 2479980 | 2022-05-06 | Pierce | Wisconsin | 55093 | 11762 | 73 |
2474015 | 2474015 | 2022-05-05 | Pierce | Georgia | 13229 | 5686 | 130 |
2475255 | 2475255 | 2022-05-05 | Pierce | Nebraska | 31139 | 1292 | 21 |
2475557 | 2475557 | 2022-05-05 | Pierce | North Dakota | 38069 | 1062 | 32 |
2476606 | 2476606 | 2022-05-05 | Pierce | Washington | 53053 | 196034 | 1401 |
2476722 | 2476722 | 2022-05-05 | Pierce | Wisconsin | 55093 | 11743 | 73 |
2470758 | 2470758 | 2022-05-04 | Pierce | Georgia | 13229 | 5686 | 130 |
2471998 | 2471998 | 2022-05-04 | Pierce | Nebraska | 31139 | 1293 | 21 |
2472300 | 2472300 | 2022-05-04 | Pierce | North Dakota | 38069 | 1062 | 32 |
2473348 | 2473348 | 2022-05-04 | Pierce | Washington | 53053 | 196034 | 1401 |
2473464 | 2473464 | 2022-05-04 | Pierce | Wisconsin | 55093 | 11713 | 73 |
2467502 | 2467502 | 2022-05-03 | Pierce | Georgia | 13229 | 5678 | 129 |
2468742 | 2468742 | 2022-05-03 | Pierce | Nebraska | 31139 | 1293 | 21 |
2469044 | 2469044 | 2022-05-03 | Pierce | North Dakota | 38069 | 1062 | 32 |
2470092 | 2470092 | 2022-05-03 | Pierce | Washington | 53053 | 196835 | 1401 |
2470207 | 2470207 | 2022-05-03 | Pierce | Wisconsin | 55093 | 11699 | 73 |
2464247 | 2464247 | 2022-05-02 | Pierce | Georgia | 13229 | 5678 | 129 |
2465486 | 2465486 | 2022-05-02 | Pierce | Nebraska | 31139 | 1292 | 21 |
2465788 | 2465788 | 2022-05-02 | Pierce | North Dakota | 38069 | 1062 | 32 |
2466836 | 2466836 | 2022-05-02 | Pierce | Washington | 53053 | 196835 | 1401 |
2466951 | 2466951 | 2022-05-02 | Pierce | Wisconsin | 55093 | 11691 | 73 |
2460991 | 2460991 | 2022-05-01 | Pierce | Georgia | 13229 | 5678 | 129 |
2462231 | 2462231 | 2022-05-01 | Pierce | Nebraska | 31139 | 1292 | 21 |
2462533 | 2462533 | 2022-05-01 | Pierce | North Dakota | 38069 | 1062 | 32 |
2463581 | 2463581 | 2022-05-01 | Pierce | Washington | 53053 | 195157 | 1401 |
2463696 | 2463696 | 2022-05-01 | Pierce | Wisconsin | 55093 | 11672 | 73 |
2457735 | 2457735 | 2022-04-30 | Pierce | Georgia | 13229 | 5678 | 129 |
2458975 | 2458975 | 2022-04-30 | Pierce | Nebraska | 31139 | 1292 | 21 |
2459277 | 2459277 | 2022-04-30 | Pierce | North Dakota | 38069 | 1062 | 32 |
2460325 | 2460325 | 2022-04-30 | Pierce | Washington | 53053 | 195157 | 1401 |
2460440 | 2460440 | 2022-04-30 | Pierce | Wisconsin | 55093 | 11672 | 73 |
2454479 | 2454479 | 2022-04-29 | Pierce | Georgia | 13229 | 5678 | 129 |
2455719 | 2455719 | 2022-04-29 | Pierce | Nebraska | 31139 | 1292 | 21 |
2456021 | 2456021 | 2022-04-29 | Pierce | North Dakota | 38069 | 1062 | 32 |
2457069 | 2457069 | 2022-04-29 | Pierce | Washington | 53053 | 195157 | 1401 |
2457184 | 2457184 | 2022-04-29 | Pierce | Wisconsin | 55093 | 11672 | 73 |
2451223 | 2451223 | 2022-04-28 | Pierce | Georgia | 13229 | 5678 | 129 |
2452463 | 2452463 | 2022-04-28 | Pierce | Nebraska | 31139 | 1292 | 21 |
2452765 | 2452765 | 2022-04-28 | Pierce | North Dakota | 38069 | 1060 | 32 |
2453813 | 2453813 | 2022-04-28 | Pierce | Washington | 53053 | 194758 | 1395 |
2453928 | 2453928 | 2022-04-28 | Pierce | Wisconsin | 55093 | 11662 | 73 |
2447967 | 2447967 | 2022-04-27 | Pierce | Georgia | 13229 | 5678 | 129 |
2449207 | 2449207 | 2022-04-27 | Pierce | Nebraska | 31139 | 1292 | 21 |
2449509 | 2449509 | 2022-04-27 | Pierce | North Dakota | 38069 | 1060 | 32 |
2450557 | 2450557 | 2022-04-27 | Pierce | Washington | 53053 | 194758 | 1395 |
2450672 | 2450672 | 2022-04-27 | Pierce | Wisconsin | 55093 | 11646 | 73 |
2444711 | 2444711 | 2022-04-26 | Pierce | Georgia | 13229 | 5746 | 131 |
2445950 | 2445950 | 2022-04-26 | Pierce | Nebraska | 31139 | 1292 | 21 |
2446252 | 2446252 | 2022-04-26 | Pierce | North Dakota | 38069 | 1060 | 32 |
2447301 | 2447301 | 2022-04-26 | Pierce | Washington | 53053 | 194380 | 1394 |
2447416 | 2447416 | 2022-04-26 | Pierce | Wisconsin | 55093 | 11636 | 73 |
2441455 | 2441455 | 2022-04-25 | Pierce | Georgia | 13229 | 5746 | 131 |
2442695 | 2442695 | 2022-04-25 | Pierce | Nebraska | 31139 | 1289 | 21 |
2442997 | 2442997 | 2022-04-25 | Pierce | North Dakota | 38069 | 1060 | 32 |
2444045 | 2444045 | 2022-04-25 | Pierce | Washington | 53053 | 194380 | 1394 |
2444160 | 2444160 | 2022-04-25 | Pierce | Wisconsin | 55093 | 11627 | 73 |
2438199 | 2438199 | 2022-04-24 | Pierce | Georgia | 13229 | 5746 | 131 |
2439439 | 2439439 | 2022-04-24 | Pierce | Nebraska | 31139 | 1289 | 21 |
2439741 | 2439741 | 2022-04-24 | Pierce | North Dakota | 38069 | 1060 | 32 |
2440789 | 2440789 | 2022-04-24 | Pierce | Washington | 53053 | 193910 | 1391 |
2440904 | 2440904 | 2022-04-24 | Pierce | Wisconsin | 55093 | 11612 | 73 |
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);