ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where county = "Pierce" and fips = 31139 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
49892 | 49892 | 2020-04-11 | Pierce | Nebraska | 31139 | 1 | 0 |
52566 | 52566 | 2020-04-12 | Pierce | Nebraska | 31139 | 1 | 0 |
55247 | 55247 | 2020-04-13 | Pierce | Nebraska | 31139 | 1 | 0 |
57946 | 57946 | 2020-04-14 | Pierce | Nebraska | 31139 | 1 | 0 |
60661 | 60661 | 2020-04-15 | Pierce | Nebraska | 31139 | 1 | 0 |
63386 | 63386 | 2020-04-16 | Pierce | Nebraska | 31139 | 1 | 0 |
66127 | 66127 | 2020-04-17 | Pierce | Nebraska | 31139 | 1 | 0 |
68882 | 68882 | 2020-04-18 | Pierce | Nebraska | 31139 | 1 | 0 |
71649 | 71649 | 2020-04-19 | Pierce | Nebraska | 31139 | 1 | 0 |
74423 | 74423 | 2020-04-20 | Pierce | Nebraska | 31139 | 1 | 0 |
77203 | 77203 | 2020-04-21 | Pierce | Nebraska | 31139 | 1 | 0 |
79992 | 79992 | 2020-04-22 | Pierce | Nebraska | 31139 | 1 | 0 |
82789 | 82789 | 2020-04-23 | Pierce | Nebraska | 31139 | 1 | 0 |
85594 | 85594 | 2020-04-24 | Pierce | Nebraska | 31139 | 1 | 0 |
88404 | 88404 | 2020-04-25 | Pierce | Nebraska | 31139 | 1 | 0 |
91220 | 91220 | 2020-04-26 | Pierce | Nebraska | 31139 | 1 | 0 |
94042 | 94042 | 2020-04-27 | Pierce | Nebraska | 31139 | 1 | 0 |
96878 | 96878 | 2020-04-28 | Pierce | Nebraska | 31139 | 1 | 0 |
99725 | 99725 | 2020-04-29 | Pierce | Nebraska | 31139 | 1 | 0 |
102578 | 102578 | 2020-04-30 | Pierce | Nebraska | 31139 | 1 | 0 |
105439 | 105439 | 2020-05-01 | Pierce | Nebraska | 31139 | 1 | 0 |
108306 | 108306 | 2020-05-02 | Pierce | Nebraska | 31139 | 1 | 0 |
111179 | 111179 | 2020-05-03 | Pierce | Nebraska | 31139 | 1 | 0 |
119901 | 119901 | 2020-05-06 | Pierce | Nebraska | 31139 | 1 | 0 |
122875 | 122875 | 2020-05-07 | Pierce | Nebraska | 31139 | 1 | 0 |
125857 | 125857 | 2020-05-08 | Pierce | Nebraska | 31139 | 1 | 0 |
128846 | 128846 | 2020-05-09 | Pierce | Nebraska | 31139 | 1 | 0 |
131836 | 131836 | 2020-05-10 | Pierce | Nebraska | 31139 | 1 | 0 |
134827 | 134827 | 2020-05-11 | Pierce | Nebraska | 31139 | 1 | 0 |
137817 | 137817 | 2020-05-12 | Pierce | Nebraska | 31139 | 1 | 0 |
140811 | 140811 | 2020-05-13 | Pierce | Nebraska | 31139 | 1 | 0 |
143806 | 143806 | 2020-05-14 | Pierce | Nebraska | 31139 | 1 | 0 |
146807 | 146807 | 2020-05-15 | Pierce | Nebraska | 31139 | 1 | 0 |
149814 | 149814 | 2020-05-16 | Pierce | Nebraska | 31139 | 1 | 0 |
152825 | 152825 | 2020-05-17 | Pierce | Nebraska | 31139 | 1 | 0 |
155839 | 155839 | 2020-05-18 | Pierce | Nebraska | 31139 | 1 | 0 |
158857 | 158857 | 2020-05-19 | Pierce | Nebraska | 31139 | 1 | 0 |
161883 | 161883 | 2020-05-20 | Pierce | Nebraska | 31139 | 1 | 0 |
114059 | 114059 | 2020-05-04 | Pierce | Nebraska | 31139 | 2 | 0 |
116941 | 116941 | 2020-05-05 | Pierce | Nebraska | 31139 | 2 | 0 |
164912 | 164912 | 2020-05-21 | Pierce | Nebraska | 31139 | 2 | 0 |
167948 | 167948 | 2020-05-22 | Pierce | Nebraska | 31139 | 2 | 0 |
170987 | 170987 | 2020-05-23 | Pierce | Nebraska | 31139 | 2 | 0 |
174030 | 174030 | 2020-05-24 | Pierce | Nebraska | 31139 | 2 | 0 |
177073 | 177073 | 2020-05-25 | Pierce | Nebraska | 31139 | 2 | 0 |
180117 | 180117 | 2020-05-26 | Pierce | Nebraska | 31139 | 3 | 0 |
183165 | 183165 | 2020-05-27 | Pierce | Nebraska | 31139 | 3 | 0 |
186221 | 186221 | 2020-05-28 | Pierce | Nebraska | 31139 | 5 | 0 |
189280 | 189280 | 2020-05-29 | Pierce | Nebraska | 31139 | 5 | 0 |
192344 | 192344 | 2020-05-30 | Pierce | Nebraska | 31139 | 6 | 0 |
195414 | 195414 | 2020-05-31 | Pierce | Nebraska | 31139 | 6 | 0 |
198487 | 198487 | 2020-06-01 | Pierce | Nebraska | 31139 | 6 | 0 |
201561 | 201561 | 2020-06-02 | Pierce | Nebraska | 31139 | 6 | 0 |
204638 | 204638 | 2020-06-03 | Pierce | Nebraska | 31139 | 6 | 0 |
207719 | 207719 | 2020-06-04 | Pierce | Nebraska | 31139 | 6 | 0 |
210801 | 210801 | 2020-06-05 | Pierce | Nebraska | 31139 | 6 | 0 |
213885 | 213885 | 2020-06-06 | Pierce | Nebraska | 31139 | 6 | 0 |
216974 | 216974 | 2020-06-07 | Pierce | Nebraska | 31139 | 6 | 0 |
220066 | 220066 | 2020-06-08 | Pierce | Nebraska | 31139 | 6 | 0 |
223162 | 223162 | 2020-06-09 | Pierce | Nebraska | 31139 | 6 | 0 |
226261 | 226261 | 2020-06-10 | Pierce | Nebraska | 31139 | 6 | 0 |
229364 | 229364 | 2020-06-11 | Pierce | Nebraska | 31139 | 6 | 0 |
232469 | 232469 | 2020-06-12 | Pierce | Nebraska | 31139 | 6 | 0 |
235575 | 235575 | 2020-06-13 | Pierce | Nebraska | 31139 | 6 | 0 |
238682 | 238682 | 2020-06-14 | Pierce | Nebraska | 31139 | 6 | 0 |
241792 | 241792 | 2020-06-15 | Pierce | Nebraska | 31139 | 6 | 0 |
244903 | 244903 | 2020-06-16 | Pierce | Nebraska | 31139 | 6 | 0 |
248016 | 248016 | 2020-06-17 | Pierce | Nebraska | 31139 | 6 | 0 |
251131 | 251131 | 2020-06-18 | Pierce | Nebraska | 31139 | 6 | 0 |
254246 | 254246 | 2020-06-19 | Pierce | Nebraska | 31139 | 6 | 0 |
257369 | 257369 | 2020-06-20 | Pierce | Nebraska | 31139 | 6 | 0 |
260495 | 260495 | 2020-06-21 | Pierce | Nebraska | 31139 | 6 | 0 |
263624 | 263624 | 2020-06-22 | Pierce | Nebraska | 31139 | 6 | 0 |
266751 | 266751 | 2020-06-23 | Pierce | Nebraska | 31139 | 6 | 0 |
269885 | 269885 | 2020-06-24 | Pierce | Nebraska | 31139 | 7 | 0 |
273024 | 273024 | 2020-06-25 | Pierce | Nebraska | 31139 | 7 | 0 |
276167 | 276167 | 2020-06-26 | Pierce | Nebraska | 31139 | 7 | 0 |
279315 | 279315 | 2020-06-27 | Pierce | Nebraska | 31139 | 8 | 0 |
282463 | 282463 | 2020-06-28 | Pierce | Nebraska | 31139 | 8 | 0 |
285608 | 285608 | 2020-06-29 | Pierce | Nebraska | 31139 | 8 | 0 |
288758 | 288758 | 2020-06-30 | Pierce | Nebraska | 31139 | 8 | 0 |
291910 | 291910 | 2020-07-01 | Pierce | Nebraska | 31139 | 8 | 0 |
295065 | 295065 | 2020-07-02 | Pierce | Nebraska | 31139 | 8 | 0 |
298224 | 298224 | 2020-07-03 | Pierce | Nebraska | 31139 | 9 | 0 |
301387 | 301387 | 2020-07-04 | Pierce | Nebraska | 31139 | 9 | 0 |
304551 | 304551 | 2020-07-05 | Pierce | Nebraska | 31139 | 9 | 0 |
307718 | 307718 | 2020-07-06 | Pierce | Nebraska | 31139 | 9 | 0 |
310886 | 310886 | 2020-07-07 | Pierce | Nebraska | 31139 | 9 | 0 |
314057 | 314057 | 2020-07-08 | Pierce | Nebraska | 31139 | 10 | 0 |
317231 | 317231 | 2020-07-09 | Pierce | Nebraska | 31139 | 10 | 0 |
326771 | 326771 | 2020-07-12 | Pierce | Nebraska | 31139 | 10 | 0 |
320407 | 320407 | 2020-07-10 | Pierce | Nebraska | 31139 | 11 | 0 |
323587 | 323587 | 2020-07-11 | Pierce | Nebraska | 31139 | 11 | 0 |
329958 | 329958 | 2020-07-13 | Pierce | Nebraska | 31139 | 11 | 0 |
333148 | 333148 | 2020-07-14 | Pierce | Nebraska | 31139 | 11 | 0 |
339539 | 339539 | 2020-07-16 | Pierce | Nebraska | 31139 | 12 | 0 |
336342 | 336342 | 2020-07-15 | Pierce | Nebraska | 31139 | 13 | 0 |
342736 | 342736 | 2020-07-17 | Pierce | Nebraska | 31139 | 13 | 0 |
345936 | 345936 | 2020-07-18 | Pierce | Nebraska | 31139 | 14 | 0 |
349137 | 349137 | 2020-07-19 | Pierce | Nebraska | 31139 | 15 | 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);