ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where county = "Pierce" and deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
state 5
- Georgia 38
- North Dakota 13
- Wisconsin 10
- Nebraska 8
- Washington 1
county 1
- Pierce · 70 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
740731 | 740731 | 2020-11-17 | Pierce | North Dakota | 38069 | 327 | 4 |
737486 | 737486 | 2020-11-16 | Pierce | North Dakota | 38069 | 324 | 4 |
734242 | 734242 | 2020-11-15 | Pierce | North Dakota | 38069 | 296 | 4 |
730996 | 730996 | 2020-11-14 | Pierce | North Dakota | 38069 | 288 | 4 |
727752 | 727752 | 2020-11-13 | Pierce | North Dakota | 38069 | 268 | 4 |
724508 | 724508 | 2020-11-12 | Pierce | North Dakota | 38069 | 251 | 4 |
721265 | 721265 | 2020-11-11 | Pierce | North Dakota | 38069 | 239 | 4 |
718022 | 718022 | 2020-11-10 | Pierce | North Dakota | 38069 | 234 | 4 |
714779 | 714779 | 2020-11-09 | Pierce | North Dakota | 38069 | 229 | 4 |
711535 | 711535 | 2020-11-08 | Pierce | North Dakota | 38069 | 219 | 4 |
708291 | 708291 | 2020-11-07 | Pierce | North Dakota | 38069 | 210 | 4 |
705048 | 705048 | 2020-11-06 | Pierce | North Dakota | 38069 | 190 | 4 |
701805 | 701805 | 2020-11-05 | Pierce | North Dakota | 38069 | 180 | 4 |
519973 | 519973 | 2020-09-10 | Pierce | Nebraska | 31139 | 82 | 4 |
516738 | 516738 | 2020-09-09 | Pierce | Nebraska | 31139 | 77 | 4 |
513504 | 513504 | 2020-09-08 | Pierce | Nebraska | 31139 | 72 | 4 |
510272 | 510272 | 2020-09-07 | Pierce | Nebraska | 31139 | 70 | 4 |
507039 | 507039 | 2020-09-06 | Pierce | Nebraska | 31139 | 71 | 4 |
503806 | 503806 | 2020-09-05 | Pierce | Nebraska | 31139 | 68 | 4 |
500572 | 500572 | 2020-09-04 | Pierce | Nebraska | 31139 | 66 | 4 |
497338 | 497338 | 2020-09-03 | Pierce | Nebraska | 31139 | 65 | 4 |
466464 | 466464 | 2020-08-24 | Pierce | Wisconsin | 55093 | 271 | 4 |
463235 | 463235 | 2020-08-23 | Pierce | Wisconsin | 55093 | 270 | 4 |
460006 | 460006 | 2020-08-22 | Pierce | Wisconsin | 55093 | 266 | 4 |
456779 | 456779 | 2020-08-21 | Pierce | Wisconsin | 55093 | 261 | 4 |
453551 | 453551 | 2020-08-20 | Pierce | Wisconsin | 55093 | 256 | 4 |
450323 | 450323 | 2020-08-19 | Pierce | Wisconsin | 55093 | 253 | 4 |
447095 | 447095 | 2020-08-18 | Pierce | Wisconsin | 55093 | 250 | 4 |
443868 | 443868 | 2020-08-17 | Pierce | Wisconsin | 55093 | 247 | 4 |
440642 | 440642 | 2020-08-16 | Pierce | Wisconsin | 55093 | 244 | 4 |
437416 | 437416 | 2020-08-15 | Pierce | Wisconsin | 55093 | 239 | 4 |
287573 | 287573 | 2020-06-30 | Pierce | Georgia | 13229 | 170 | 4 |
284427 | 284427 | 2020-06-29 | Pierce | Georgia | 13229 | 162 | 4 |
281281 | 281281 | 2020-06-28 | Pierce | Georgia | 13229 | 161 | 4 |
278134 | 278134 | 2020-06-27 | Pierce | Georgia | 13229 | 158 | 4 |
274986 | 274986 | 2020-06-26 | Pierce | Georgia | 13229 | 156 | 4 |
271846 | 271846 | 2020-06-25 | Pierce | Georgia | 13229 | 155 | 4 |
268710 | 268710 | 2020-06-24 | Pierce | Georgia | 13229 | 148 | 4 |
265580 | 265580 | 2020-06-23 | Pierce | Georgia | 13229 | 143 | 4 |
262452 | 262452 | 2020-06-22 | Pierce | Georgia | 13229 | 140 | 4 |
259325 | 259325 | 2020-06-21 | Pierce | Georgia | 13229 | 137 | 4 |
256198 | 256198 | 2020-06-20 | Pierce | Georgia | 13229 | 135 | 4 |
253079 | 253079 | 2020-06-19 | Pierce | Georgia | 13229 | 134 | 4 |
249964 | 249964 | 2020-06-18 | Pierce | Georgia | 13229 | 132 | 4 |
246852 | 246852 | 2020-06-17 | Pierce | Georgia | 13229 | 132 | 4 |
243739 | 243739 | 2020-06-16 | Pierce | Georgia | 13229 | 132 | 4 |
240628 | 240628 | 2020-06-15 | Pierce | Georgia | 13229 | 131 | 4 |
237520 | 237520 | 2020-06-14 | Pierce | Georgia | 13229 | 128 | 4 |
234413 | 234413 | 2020-06-13 | Pierce | Georgia | 13229 | 128 | 4 |
231307 | 231307 | 2020-06-12 | Pierce | Georgia | 13229 | 126 | 4 |
228204 | 228204 | 2020-06-11 | Pierce | Georgia | 13229 | 125 | 4 |
225102 | 225102 | 2020-06-10 | Pierce | Georgia | 13229 | 122 | 4 |
222007 | 222007 | 2020-06-09 | Pierce | Georgia | 13229 | 121 | 4 |
218912 | 218912 | 2020-06-08 | Pierce | Georgia | 13229 | 119 | 4 |
215821 | 215821 | 2020-06-07 | Pierce | Georgia | 13229 | 117 | 4 |
212734 | 212734 | 2020-06-06 | Pierce | Georgia | 13229 | 116 | 4 |
209649 | 209649 | 2020-06-05 | Pierce | Georgia | 13229 | 114 | 4 |
206568 | 206568 | 2020-06-04 | Pierce | Georgia | 13229 | 109 | 4 |
163785 | 163785 | 2020-05-21 | Pierce | Georgia | 13229 | 85 | 4 |
160757 | 160757 | 2020-05-20 | Pierce | Georgia | 13229 | 84 | 4 |
157731 | 157731 | 2020-05-19 | Pierce | Georgia | 13229 | 81 | 4 |
154715 | 154715 | 2020-05-18 | Pierce | Georgia | 13229 | 75 | 4 |
151703 | 151703 | 2020-05-17 | Pierce | Georgia | 13229 | 71 | 4 |
148694 | 148694 | 2020-05-16 | Pierce | Georgia | 13229 | 70 | 4 |
145691 | 145691 | 2020-05-15 | Pierce | Georgia | 13229 | 69 | 4 |
142691 | 142691 | 2020-05-14 | Pierce | Georgia | 13229 | 69 | 4 |
139695 | 139695 | 2020-05-13 | Pierce | Georgia | 13229 | 69 | 4 |
136704 | 136704 | 2020-05-12 | Pierce | Georgia | 13229 | 68 | 4 |
133715 | 133715 | 2020-05-11 | Pierce | Georgia | 13229 | 67 | 4 |
13947 | 13947 | 2020-03-26 | Pierce | Washington | 53053 | 186 | 4 |
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);