ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,467 rows where county = "Sierra" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
99812 | 99812 | 2020-04-29 | Sierra | New Mexico | 35051 | 1 | 0 |
102665 | 102665 | 2020-04-30 | Sierra | New Mexico | 35051 | 1 | 0 |
105527 | 105527 | 2020-05-01 | Sierra | New Mexico | 35051 | 1 | 0 |
108393 | 108393 | 2020-05-02 | Sierra | New Mexico | 35051 | 1 | 0 |
111266 | 111266 | 2020-05-03 | Sierra | New Mexico | 35051 | 1 | 0 |
114147 | 114147 | 2020-05-04 | Sierra | New Mexico | 35051 | 1 | 0 |
117028 | 117028 | 2020-05-05 | Sierra | New Mexico | 35051 | 1 | 0 |
119989 | 119989 | 2020-05-06 | Sierra | New Mexico | 35051 | 1 | 0 |
122964 | 122964 | 2020-05-07 | Sierra | New Mexico | 35051 | 1 | 0 |
125947 | 125947 | 2020-05-08 | Sierra | New Mexico | 35051 | 1 | 0 |
128936 | 128936 | 2020-05-09 | Sierra | New Mexico | 35051 | 1 | 0 |
131925 | 131925 | 2020-05-10 | Sierra | New Mexico | 35051 | 1 | 0 |
134916 | 134916 | 2020-05-11 | Sierra | New Mexico | 35051 | 1 | 0 |
137906 | 137906 | 2020-05-12 | Sierra | New Mexico | 35051 | 1 | 0 |
140902 | 140902 | 2020-05-13 | Sierra | New Mexico | 35051 | 1 | 0 |
143897 | 143897 | 2020-05-14 | Sierra | New Mexico | 35051 | 1 | 0 |
146898 | 146898 | 2020-05-15 | Sierra | New Mexico | 35051 | 1 | 0 |
149905 | 149905 | 2020-05-16 | Sierra | New Mexico | 35051 | 1 | 0 |
152915 | 152915 | 2020-05-17 | Sierra | New Mexico | 35051 | 1 | 0 |
155932 | 155932 | 2020-05-18 | Sierra | New Mexico | 35051 | 1 | 0 |
158950 | 158950 | 2020-05-19 | Sierra | New Mexico | 35051 | 1 | 0 |
161976 | 161976 | 2020-05-20 | Sierra | New Mexico | 35051 | 1 | 0 |
165005 | 165005 | 2020-05-21 | Sierra | New Mexico | 35051 | 1 | 0 |
166550 | 166550 | 2020-05-22 | Sierra | California | 6091 | 1 | 0 |
168041 | 168041 | 2020-05-22 | Sierra | New Mexico | 35051 | 1 | 0 |
169587 | 169587 | 2020-05-23 | Sierra | California | 6091 | 1 | 0 |
171080 | 171080 | 2020-05-23 | Sierra | New Mexico | 35051 | 1 | 0 |
172628 | 172628 | 2020-05-24 | Sierra | California | 6091 | 1 | 0 |
174122 | 174122 | 2020-05-24 | Sierra | New Mexico | 35051 | 1 | 0 |
175672 | 175672 | 2020-05-25 | Sierra | California | 6091 | 1 | 0 |
177165 | 177165 | 2020-05-25 | Sierra | New Mexico | 35051 | 1 | 0 |
178716 | 178716 | 2020-05-26 | Sierra | California | 6091 | 1 | 0 |
180209 | 180209 | 2020-05-26 | Sierra | New Mexico | 35051 | 1 | 0 |
181760 | 181760 | 2020-05-27 | Sierra | California | 6091 | 1 | 0 |
183257 | 183257 | 2020-05-27 | Sierra | New Mexico | 35051 | 1 | 0 |
184814 | 184814 | 2020-05-28 | Sierra | California | 6091 | 1 | 0 |
186314 | 186314 | 2020-05-28 | Sierra | New Mexico | 35051 | 1 | 0 |
187870 | 187870 | 2020-05-29 | Sierra | California | 6091 | 1 | 0 |
189374 | 189374 | 2020-05-29 | Sierra | New Mexico | 35051 | 1 | 0 |
190935 | 190935 | 2020-05-30 | Sierra | California | 6091 | 1 | 0 |
192438 | 192438 | 2020-05-30 | Sierra | New Mexico | 35051 | 1 | 0 |
194002 | 194002 | 2020-05-31 | Sierra | California | 6091 | 1 | 0 |
195508 | 195508 | 2020-05-31 | Sierra | New Mexico | 35051 | 1 | 0 |
197072 | 197072 | 2020-06-01 | Sierra | California | 6091 | 1 | 0 |
198581 | 198581 | 2020-06-01 | Sierra | New Mexico | 35051 | 1 | 0 |
200145 | 200145 | 2020-06-02 | Sierra | California | 6091 | 1 | 0 |
201655 | 201655 | 2020-06-02 | Sierra | New Mexico | 35051 | 1 | 0 |
203221 | 203221 | 2020-06-03 | Sierra | California | 6091 | 1 | 0 |
204732 | 204732 | 2020-06-03 | Sierra | New Mexico | 35051 | 1 | 0 |
206301 | 206301 | 2020-06-04 | Sierra | California | 6091 | 1 | 0 |
207813 | 207813 | 2020-06-04 | Sierra | New Mexico | 35051 | 1 | 0 |
209382 | 209382 | 2020-06-05 | Sierra | California | 6091 | 1 | 0 |
210895 | 210895 | 2020-06-05 | Sierra | New Mexico | 35051 | 1 | 0 |
212467 | 212467 | 2020-06-06 | Sierra | California | 6091 | 1 | 0 |
213979 | 213979 | 2020-06-06 | Sierra | New Mexico | 35051 | 1 | 0 |
215554 | 215554 | 2020-06-07 | Sierra | California | 6091 | 1 | 0 |
217068 | 217068 | 2020-06-07 | Sierra | New Mexico | 35051 | 1 | 0 |
218645 | 218645 | 2020-06-08 | Sierra | California | 6091 | 1 | 0 |
220160 | 220160 | 2020-06-08 | Sierra | New Mexico | 35051 | 1 | 0 |
221740 | 221740 | 2020-06-09 | Sierra | California | 6091 | 1 | 0 |
223255 | 223255 | 2020-06-09 | Sierra | New Mexico | 35051 | 1 | 0 |
224835 | 224835 | 2020-06-10 | Sierra | California | 6091 | 1 | 0 |
227937 | 227937 | 2020-06-11 | Sierra | California | 6091 | 1 | 0 |
231040 | 231040 | 2020-06-12 | Sierra | California | 6091 | 1 | 0 |
234146 | 234146 | 2020-06-13 | Sierra | California | 6091 | 1 | 0 |
237253 | 237253 | 2020-06-14 | Sierra | California | 6091 | 1 | 0 |
240361 | 240361 | 2020-06-15 | Sierra | California | 6091 | 1 | 0 |
243472 | 243472 | 2020-06-16 | Sierra | California | 6091 | 1 | 0 |
246585 | 246585 | 2020-06-17 | Sierra | California | 6091 | 1 | 0 |
249697 | 249697 | 2020-06-18 | Sierra | California | 6091 | 1 | 0 |
252812 | 252812 | 2020-06-19 | Sierra | California | 6091 | 1 | 0 |
255931 | 255931 | 2020-06-20 | Sierra | California | 6091 | 1 | 0 |
259058 | 259058 | 2020-06-21 | Sierra | California | 6091 | 1 | 0 |
262185 | 262185 | 2020-06-22 | Sierra | California | 6091 | 1 | 0 |
265313 | 265313 | 2020-06-23 | Sierra | California | 6091 | 1 | 0 |
268443 | 268443 | 2020-06-24 | Sierra | California | 6091 | 1 | 0 |
271578 | 271578 | 2020-06-25 | Sierra | California | 6091 | 1 | 0 |
274718 | 274718 | 2020-06-26 | Sierra | California | 6091 | 1 | 0 |
277866 | 277866 | 2020-06-27 | Sierra | California | 6091 | 1 | 0 |
281013 | 281013 | 2020-06-28 | Sierra | California | 6091 | 1 | 0 |
284159 | 284159 | 2020-06-29 | Sierra | California | 6091 | 1 | 0 |
287305 | 287305 | 2020-06-30 | Sierra | California | 6091 | 1 | 0 |
290456 | 290456 | 2020-07-01 | Sierra | California | 6091 | 1 | 0 |
293610 | 293610 | 2020-07-02 | Sierra | California | 6091 | 1 | 0 |
296766 | 296766 | 2020-07-03 | Sierra | California | 6091 | 1 | 0 |
299928 | 299928 | 2020-07-04 | Sierra | California | 6091 | 1 | 0 |
303092 | 303092 | 2020-07-05 | Sierra | California | 6091 | 1 | 0 |
306256 | 306256 | 2020-07-06 | Sierra | California | 6091 | 1 | 0 |
309424 | 309424 | 2020-07-07 | Sierra | California | 6091 | 1 | 0 |
312594 | 312594 | 2020-07-08 | Sierra | California | 6091 | 1 | 0 |
315769 | 315769 | 2020-07-09 | Sierra | California | 6091 | 1 | 0 |
318942 | 318942 | 2020-07-10 | Sierra | California | 6091 | 1 | 0 |
322121 | 322121 | 2020-07-11 | Sierra | California | 6091 | 1 | 0 |
325302 | 325302 | 2020-07-12 | Sierra | California | 6091 | 1 | 0 |
328488 | 328488 | 2020-07-13 | Sierra | California | 6091 | 1 | 0 |
331674 | 331674 | 2020-07-14 | Sierra | California | 6091 | 1 | 0 |
334867 | 334867 | 2020-07-15 | Sierra | California | 6091 | 1 | 0 |
338062 | 338062 | 2020-07-16 | Sierra | California | 6091 | 1 | 0 |
341258 | 341258 | 2020-07-17 | Sierra | California | 6091 | 1 | 0 |
344457 | 344457 | 2020-07-18 | Sierra | California | 6091 | 1 | 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);