ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Pierce" and state = "Washington" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
1153 | 1153 | 2020-03-10 | Pierce | Washington | 53053 | 14 | 0 |
1353 | 1353 | 2020-03-11 | Pierce | Washington | 53053 | 17 | 0 |
1607 | 1607 | 2020-03-12 | Pierce | Washington | 53053 | 17 | 0 |
1918 | 1918 | 2020-03-13 | Pierce | Washington | 53053 | 19 | 0 |
2292 | 2292 | 2020-03-14 | Pierce | Washington | 53053 | 26 | 0 |
2721 | 2721 | 2020-03-15 | Pierce | Washington | 53053 | 29 | 0 |
3195 | 3195 | 2020-03-16 | Pierce | Washington | 53053 | 44 | 0 |
3737 | 3737 | 2020-03-17 | Pierce | Washington | 53053 | 44 | 0 |
4372 | 4372 | 2020-03-18 | Pierce | Washington | 53053 | 56 | 1 |
5129 | 5129 | 2020-03-19 | Pierce | Washington | 53053 | 75 | 1 |
6031 | 6031 | 2020-03-20 | Pierce | Washington | 53053 | 83 | 1 |
7062 | 7062 | 2020-03-21 | Pierce | Washington | 53053 | 95 | 1 |
8199 | 8199 | 2020-03-22 | Pierce | Washington | 53053 | 107 | 1 |
9424 | 9424 | 2020-03-23 | Pierce | Washington | 53053 | 126 | 1 |
10773 | 10773 | 2020-03-24 | Pierce | Washington | 53053 | 138 | 1 |
12297 | 12297 | 2020-03-25 | Pierce | Washington | 53053 | 155 | 2 |
13947 | 13947 | 2020-03-26 | Pierce | Washington | 53053 | 186 | 4 |
15715 | 15715 | 2020-03-27 | Pierce | Washington | 53053 | 231 | 5 |
17595 | 17595 | 2020-03-28 | Pierce | Washington | 53053 | 282 | 5 |
19560 | 19560 | 2020-03-29 | Pierce | Washington | 53053 | 318 | 6 |
21627 | 21627 | 2020-03-30 | Pierce | Washington | 53053 | 353 | 6 |
23776 | 23776 | 2020-03-31 | Pierce | Washington | 53053 | 353 | 6 |
25994 | 25994 | 2020-04-01 | Pierce | Washington | 53053 | 424 | 7 |
28285 | 28285 | 2020-04-02 | Pierce | Washington | 53053 | 499 | 7 |
30638 | 30638 | 2020-04-03 | Pierce | Washington | 53053 | 578 | 7 |
33038 | 33038 | 2020-04-04 | Pierce | Washington | 53053 | 627 | 8 |
35476 | 35476 | 2020-04-05 | Pierce | Washington | 53053 | 695 | 10 |
37960 | 37960 | 2020-04-06 | Pierce | Washington | 53053 | 724 | 12 |
40495 | 40495 | 2020-04-07 | Pierce | Washington | 53053 | 767 | 14 |
43064 | 43064 | 2020-04-08 | Pierce | Washington | 53053 | 802 | 16 |
45660 | 45660 | 2020-04-09 | Pierce | Washington | 53053 | 845 | 17 |
48288 | 48288 | 2020-04-10 | Pierce | Washington | 53053 | 882 | 19 |
50946 | 50946 | 2020-04-11 | Pierce | Washington | 53053 | 931 | 19 |
53621 | 53621 | 2020-04-12 | Pierce | Washington | 53053 | 940 | 20 |
56311 | 56311 | 2020-04-13 | Pierce | Washington | 53053 | 984 | 20 |
59017 | 59017 | 2020-04-14 | Pierce | Washington | 53053 | 1023 | 23 |
61736 | 61736 | 2020-04-15 | Pierce | Washington | 53053 | 1051 | 28 |
64469 | 64469 | 2020-04-16 | Pierce | Washington | 53053 | 1092 | 30 |
67217 | 67217 | 2020-04-17 | Pierce | Washington | 53053 | 1126 | 30 |
69979 | 69979 | 2020-04-18 | Pierce | Washington | 53053 | 1197 | 32 |
72749 | 72749 | 2020-04-19 | Pierce | Washington | 53053 | 1229 | 32 |
75525 | 75525 | 2020-04-20 | Pierce | Washington | 53053 | 1258 | 34 |
78308 | 78308 | 2020-04-21 | Pierce | Washington | 53053 | 1290 | 36 |
81101 | 81101 | 2020-04-22 | Pierce | Washington | 53053 | 1315 | 40 |
83902 | 83902 | 2020-04-23 | Pierce | Washington | 53053 | 1343 | 44 |
86709 | 86709 | 2020-04-24 | Pierce | Washington | 53053 | 1370 | 47 |
89524 | 89524 | 2020-04-25 | Pierce | Washington | 53053 | 1394 | 47 |
92341 | 92341 | 2020-04-26 | Pierce | Washington | 53053 | 1408 | 48 |
95170 | 95170 | 2020-04-27 | Pierce | Washington | 53053 | 1449 | 49 |
98015 | 98015 | 2020-04-28 | Pierce | Washington | 53053 | 1494 | 51 |
100865 | 100865 | 2020-04-29 | Pierce | Washington | 53053 | 1519 | 51 |
103720 | 103720 | 2020-04-30 | Pierce | Washington | 53053 | 1554 | 51 |
106584 | 106584 | 2020-05-01 | Pierce | Washington | 53053 | 1587 | 51 |
109453 | 109453 | 2020-05-02 | Pierce | Washington | 53053 | 1620 | 52 |
112327 | 112327 | 2020-05-03 | Pierce | Washington | 53053 | 1640 | 52 |
115210 | 115210 | 2020-05-04 | Pierce | Washington | 53053 | 1673 | 52 |
118169 | 118169 | 2020-05-05 | Pierce | Washington | 53053 | 1711 | 54 |
121133 | 121133 | 2020-05-06 | Pierce | Washington | 53053 | 1757 | 54 |
124113 | 124113 | 2020-05-07 | Pierce | Washington | 53053 | 1801 | 57 |
127098 | 127098 | 2020-05-08 | Pierce | Washington | 53053 | 1820 | 58 |
130088 | 130088 | 2020-05-09 | Pierce | Washington | 53053 | 1857 | 60 |
133078 | 133078 | 2020-05-10 | Pierce | Washington | 53053 | 1883 | 60 |
136068 | 136068 | 2020-05-11 | Pierce | Washington | 53053 | 1907 | 62 |
139059 | 139059 | 2020-05-12 | Pierce | Washington | 53053 | 1927 | 63 |
142055 | 142055 | 2020-05-13 | Pierce | Washington | 53053 | 1941 | 63 |
145052 | 145052 | 2020-05-14 | Pierce | Washington | 53053 | 1966 | 65 |
148055 | 148055 | 2020-05-15 | Pierce | Washington | 53053 | 1990 | 66 |
151064 | 151064 | 2020-05-16 | Pierce | Washington | 53053 | 2020 | 68 |
154075 | 154075 | 2020-05-17 | Pierce | Washington | 53053 | 2034 | 68 |
157092 | 157092 | 2020-05-18 | Pierce | Washington | 53053 | 2043 | 68 |
160116 | 160116 | 2020-05-19 | Pierce | Washington | 53053 | 2069 | 70 |
163144 | 163144 | 2020-05-20 | Pierce | Washington | 53053 | 2082 | 71 |
166173 | 166173 | 2020-05-21 | Pierce | Washington | 53053 | 2086 | 72 |
169209 | 169209 | 2020-05-22 | Pierce | Washington | 53053 | 2098 | 73 |
172250 | 172250 | 2020-05-23 | Pierce | Washington | 53053 | 2110 | 73 |
175293 | 175293 | 2020-05-24 | Pierce | Washington | 53053 | 2130 | 74 |
178338 | 178338 | 2020-05-25 | Pierce | Washington | 53053 | 2140 | 74 |
181382 | 181382 | 2020-05-26 | Pierce | Washington | 53053 | 2143 | 75 |
184433 | 184433 | 2020-05-27 | Pierce | Washington | 53053 | 2159 | 76 |
187490 | 187490 | 2020-05-28 | Pierce | Washington | 53053 | 2179 | 78 |
190554 | 190554 | 2020-05-29 | Pierce | Washington | 53053 | 2191 | 78 |
193620 | 193620 | 2020-05-30 | Pierce | Washington | 53053 | 2205 | 79 |
196690 | 196690 | 2020-05-31 | Pierce | Washington | 53053 | 2224 | 79 |
199763 | 199763 | 2020-06-01 | Pierce | Washington | 53053 | 2232 | 79 |
202839 | 202839 | 2020-06-02 | Pierce | Washington | 53053 | 2245 | 81 |
205918 | 205918 | 2020-06-03 | Pierce | Washington | 53053 | 2270 | 82 |
209000 | 209000 | 2020-06-04 | Pierce | Washington | 53053 | 2286 | 83 |
212085 | 212085 | 2020-06-05 | Pierce | Washington | 53053 | 2303 | 84 |
215172 | 215172 | 2020-06-06 | Pierce | Washington | 53053 | 2323 | 85 |
218262 | 218262 | 2020-06-07 | Pierce | Washington | 53053 | 2332 | 85 |
221354 | 221354 | 2020-06-08 | Pierce | Washington | 53053 | 2345 | 85 |
224450 | 224450 | 2020-06-09 | Pierce | Washington | 53053 | 2357 | 87 |
227550 | 227550 | 2020-06-10 | Pierce | Washington | 53053 | 2364 | 87 |
230654 | 230654 | 2020-06-11 | Pierce | Washington | 53053 | 2369 | 87 |
233759 | 233759 | 2020-06-12 | Pierce | Washington | 53053 | 2383 | 88 |
236866 | 236866 | 2020-06-13 | Pierce | Washington | 53053 | 2404 | 88 |
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);