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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
651 | 651 | 2020-03-06 | Pierce | Washington | 53053 | 1 | 0 |
746 | 746 | 2020-03-07 | Pierce | Washington | 53053 | 3 | 0 |
859 | 859 | 2020-03-08 | Pierce | Washington | 53053 | 4 | 0 |
990 | 990 | 2020-03-09 | Pierce | Washington | 53053 | 7 | 0 |
995 | 995 | 2020-03-09 | Pierce | Wisconsin | 55093 | 1 | 0 |
1153 | 1153 | 2020-03-10 | Pierce | Washington | 53053 | 14 | 0 |
1160 | 1160 | 2020-03-10 | Pierce | Wisconsin | 55093 | 1 | 0 |
1353 | 1353 | 2020-03-11 | Pierce | Washington | 53053 | 17 | 0 |
1362 | 1362 | 2020-03-11 | Pierce | Wisconsin | 55093 | 1 | 0 |
1607 | 1607 | 2020-03-12 | Pierce | Washington | 53053 | 17 | 0 |
1617 | 1617 | 2020-03-12 | Pierce | Wisconsin | 55093 | 1 | 0 |
1918 | 1918 | 2020-03-13 | Pierce | Washington | 53053 | 19 | 0 |
1929 | 1929 | 2020-03-13 | Pierce | Wisconsin | 55093 | 1 | 0 |
2292 | 2292 | 2020-03-14 | Pierce | Washington | 53053 | 26 | 0 |
2303 | 2303 | 2020-03-14 | Pierce | Wisconsin | 55093 | 1 | 0 |
2721 | 2721 | 2020-03-15 | Pierce | Washington | 53053 | 29 | 0 |
2732 | 2732 | 2020-03-15 | Pierce | Wisconsin | 55093 | 1 | 0 |
3195 | 3195 | 2020-03-16 | Pierce | Washington | 53053 | 44 | 0 |
3207 | 3207 | 2020-03-16 | Pierce | Wisconsin | 55093 | 1 | 0 |
3737 | 3737 | 2020-03-17 | Pierce | Washington | 53053 | 44 | 0 |
3751 | 3751 | 2020-03-17 | Pierce | Wisconsin | 55093 | 1 | 0 |
4372 | 4372 | 2020-03-18 | Pierce | Washington | 53053 | 56 | 1 |
4389 | 4389 | 2020-03-18 | Pierce | Wisconsin | 55093 | 1 | 0 |
5129 | 5129 | 2020-03-19 | Pierce | Washington | 53053 | 75 | 1 |
5153 | 5153 | 2020-03-19 | Pierce | Wisconsin | 55093 | 1 | 0 |
5784 | 5784 | 2020-03-20 | Pierce | North Dakota | 38069 | 1 | 0 |
6031 | 6031 | 2020-03-20 | Pierce | Washington | 53053 | 83 | 1 |
6065 | 6065 | 2020-03-20 | Pierce | Wisconsin | 55093 | 1 | 0 |
6781 | 6781 | 2020-03-21 | Pierce | North Dakota | 38069 | 1 | 0 |
7062 | 7062 | 2020-03-21 | Pierce | Washington | 53053 | 95 | 1 |
7098 | 7098 | 2020-03-21 | Pierce | Wisconsin | 55093 | 1 | 0 |
7887 | 7887 | 2020-03-22 | Pierce | North Dakota | 38069 | 2 | 0 |
8199 | 8199 | 2020-03-22 | Pierce | Washington | 53053 | 107 | 1 |
8236 | 8236 | 2020-03-22 | Pierce | Wisconsin | 55093 | 1 | 0 |
8508 | 8508 | 2020-03-23 | Pierce | Georgia | 13229 | 1 | 0 |
9089 | 9089 | 2020-03-23 | Pierce | North Dakota | 38069 | 2 | 0 |
9424 | 9424 | 2020-03-23 | Pierce | Washington | 53053 | 126 | 1 |
9462 | 9462 | 2020-03-23 | Pierce | Wisconsin | 55093 | 3 | 0 |
9766 | 9766 | 2020-03-24 | Pierce | Georgia | 13229 | 1 | 0 |
10401 | 10401 | 2020-03-24 | Pierce | North Dakota | 38069 | 2 | 0 |
10773 | 10773 | 2020-03-24 | Pierce | Washington | 53053 | 138 | 1 |
10816 | 10816 | 2020-03-24 | Pierce | Wisconsin | 55093 | 3 | 0 |
11146 | 11146 | 2020-03-25 | Pierce | Georgia | 13229 | 1 | 0 |
11847 | 11847 | 2020-03-25 | Pierce | North Dakota | 38069 | 2 | 0 |
12297 | 12297 | 2020-03-25 | Pierce | Washington | 53053 | 155 | 2 |
12347 | 12347 | 2020-03-25 | Pierce | Wisconsin | 55093 | 3 | 0 |
12698 | 12698 | 2020-03-26 | Pierce | Georgia | 13229 | 1 | 0 |
13453 | 13453 | 2020-03-26 | Pierce | North Dakota | 38069 | 2 | 0 |
13947 | 13947 | 2020-03-26 | Pierce | Washington | 53053 | 186 | 4 |
14001 | 14001 | 2020-03-26 | Pierce | Wisconsin | 55093 | 3 | 0 |
14372 | 14372 | 2020-03-27 | Pierce | Georgia | 13229 | 1 | 0 |
15190 | 15190 | 2020-03-27 | Pierce | North Dakota | 38069 | 2 | 0 |
15715 | 15715 | 2020-03-27 | Pierce | Washington | 53053 | 231 | 5 |
15775 | 15775 | 2020-03-27 | Pierce | Wisconsin | 55093 | 4 | 0 |
16160 | 16160 | 2020-03-28 | Pierce | Georgia | 13229 | 2 | 0 |
17028 | 17028 | 2020-03-28 | Pierce | North Dakota | 38069 | 2 | 0 |
17595 | 17595 | 2020-03-28 | Pierce | Washington | 53053 | 282 | 5 |
17656 | 17656 | 2020-03-28 | Pierce | Wisconsin | 55093 | 4 | 0 |
18057 | 18057 | 2020-03-29 | Pierce | Georgia | 13229 | 2 | 0 |
18962 | 18962 | 2020-03-29 | Pierce | North Dakota | 38069 | 2 | 0 |
19560 | 19560 | 2020-03-29 | Pierce | Washington | 53053 | 318 | 6 |
19625 | 19625 | 2020-03-29 | Pierce | Wisconsin | 55093 | 4 | 0 |
20050 | 20050 | 2020-03-30 | Pierce | Georgia | 13229 | 2 | 0 |
21005 | 21005 | 2020-03-30 | Pierce | North Dakota | 38069 | 2 | 0 |
21627 | 21627 | 2020-03-30 | Pierce | Washington | 53053 | 353 | 6 |
21697 | 21697 | 2020-03-30 | Pierce | Wisconsin | 55093 | 6 | 0 |
22132 | 22132 | 2020-03-31 | Pierce | Georgia | 13229 | 3 | 0 |
23136 | 23136 | 2020-03-31 | Pierce | North Dakota | 38069 | 2 | 0 |
23776 | 23776 | 2020-03-31 | Pierce | Washington | 53053 | 353 | 6 |
23850 | 23850 | 2020-03-31 | Pierce | Wisconsin | 55093 | 7 | 0 |
24296 | 24296 | 2020-04-01 | Pierce | Georgia | 13229 | 7 | 0 |
25331 | 25331 | 2020-04-01 | Pierce | North Dakota | 38069 | 2 | 0 |
25994 | 25994 | 2020-04-01 | Pierce | Washington | 53053 | 424 | 7 |
26071 | 26071 | 2020-04-01 | Pierce | Wisconsin | 55093 | 7 | 0 |
26527 | 26527 | 2020-04-02 | Pierce | Georgia | 13229 | 10 | 0 |
27597 | 27597 | 2020-04-02 | Pierce | North Dakota | 38069 | 2 | 0 |
28285 | 28285 | 2020-04-02 | Pierce | Washington | 53053 | 499 | 7 |
28364 | 28364 | 2020-04-02 | Pierce | Wisconsin | 55093 | 7 | 0 |
28832 | 28832 | 2020-04-03 | Pierce | Georgia | 13229 | 16 | 0 |
29925 | 29925 | 2020-04-03 | Pierce | North Dakota | 38069 | 2 | 0 |
30638 | 30638 | 2020-04-03 | Pierce | Washington | 53053 | 578 | 7 |
30719 | 30719 | 2020-04-03 | Pierce | Wisconsin | 55093 | 7 | 0 |
31192 | 31192 | 2020-04-04 | Pierce | Georgia | 13229 | 16 | 0 |
32313 | 32313 | 2020-04-04 | Pierce | North Dakota | 38069 | 2 | 0 |
33038 | 33038 | 2020-04-04 | Pierce | Washington | 53053 | 627 | 8 |
33121 | 33121 | 2020-04-04 | Pierce | Wisconsin | 55093 | 7 | 0 |
33599 | 33599 | 2020-04-05 | Pierce | Georgia | 13229 | 16 | 0 |
34746 | 34746 | 2020-04-05 | Pierce | North Dakota | 38069 | 2 | 0 |
35476 | 35476 | 2020-04-05 | Pierce | Washington | 53053 | 695 | 10 |
35560 | 35560 | 2020-04-05 | Pierce | Wisconsin | 55093 | 7 | 0 |
36049 | 36049 | 2020-04-06 | Pierce | Georgia | 13229 | 23 | 0 |
37215 | 37215 | 2020-04-06 | Pierce | North Dakota | 38069 | 2 | 0 |
37960 | 37960 | 2020-04-06 | Pierce | Washington | 53053 | 724 | 12 |
38047 | 38047 | 2020-04-06 | Pierce | Wisconsin | 55093 | 7 | 0 |
38542 | 38542 | 2020-04-07 | Pierce | Georgia | 13229 | 32 | 1 |
39732 | 39732 | 2020-04-07 | Pierce | North Dakota | 38069 | 2 | 0 |
40495 | 40495 | 2020-04-07 | Pierce | Washington | 53053 | 767 | 14 |
40589 | 40589 | 2020-04-07 | Pierce | Wisconsin | 55093 | 7 | 0 |
41086 | 41086 | 2020-04-08 | Pierce | Georgia | 13229 | 39 | 1 |
42289 | 42289 | 2020-04-08 | Pierce | North Dakota | 38069 | 2 | 0 |
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);