ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
737 rows where county = "Piute" and state = "Utah" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
123927 | 123927 | 2020-05-07 | Piute | Utah | 49031 | 1 | 0 |
126912 | 126912 | 2020-05-08 | Piute | Utah | 49031 | 1 | 0 |
129901 | 129901 | 2020-05-09 | Piute | Utah | 49031 | 1 | 0 |
132891 | 132891 | 2020-05-10 | Piute | Utah | 49031 | 1 | 0 |
135882 | 135882 | 2020-05-11 | Piute | Utah | 49031 | 1 | 0 |
138872 | 138872 | 2020-05-12 | Piute | Utah | 49031 | 1 | 0 |
141868 | 141868 | 2020-05-13 | Piute | Utah | 49031 | 1 | 0 |
144865 | 144865 | 2020-05-14 | Piute | Utah | 49031 | 1 | 0 |
147869 | 147869 | 2020-05-15 | Piute | Utah | 49031 | 1 | 0 |
150877 | 150877 | 2020-05-16 | Piute | Utah | 49031 | 1 | 0 |
153888 | 153888 | 2020-05-17 | Piute | Utah | 49031 | 1 | 0 |
156905 | 156905 | 2020-05-18 | Piute | Utah | 49031 | 1 | 0 |
159929 | 159929 | 2020-05-19 | Piute | Utah | 49031 | 1 | 0 |
162957 | 162957 | 2020-05-20 | Piute | Utah | 49031 | 1 | 0 |
165986 | 165986 | 2020-05-21 | Piute | Utah | 49031 | 1 | 0 |
169022 | 169022 | 2020-05-22 | Piute | Utah | 49031 | 1 | 0 |
172063 | 172063 | 2020-05-23 | Piute | Utah | 49031 | 1 | 0 |
175106 | 175106 | 2020-05-24 | Piute | Utah | 49031 | 1 | 0 |
178151 | 178151 | 2020-05-25 | Piute | Utah | 49031 | 1 | 0 |
181195 | 181195 | 2020-05-26 | Piute | Utah | 49031 | 2 | 0 |
184246 | 184246 | 2020-05-27 | Piute | Utah | 49031 | 2 | 0 |
187303 | 187303 | 2020-05-28 | Piute | Utah | 49031 | 2 | 0 |
190367 | 190367 | 2020-05-29 | Piute | Utah | 49031 | 2 | 0 |
193433 | 193433 | 2020-05-30 | Piute | Utah | 49031 | 2 | 0 |
196503 | 196503 | 2020-05-31 | Piute | Utah | 49031 | 2 | 0 |
199576 | 199576 | 2020-06-01 | Piute | Utah | 49031 | 2 | 0 |
202652 | 202652 | 2020-06-02 | Piute | Utah | 49031 | 2 | 0 |
205731 | 205731 | 2020-06-03 | Piute | Utah | 49031 | 2 | 0 |
208813 | 208813 | 2020-06-04 | Piute | Utah | 49031 | 2 | 0 |
211898 | 211898 | 2020-06-05 | Piute | Utah | 49031 | 2 | 0 |
214985 | 214985 | 2020-06-06 | Piute | Utah | 49031 | 2 | 0 |
218075 | 218075 | 2020-06-07 | Piute | Utah | 49031 | 2 | 0 |
221167 | 221167 | 2020-06-08 | Piute | Utah | 49031 | 2 | 0 |
224263 | 224263 | 2020-06-09 | Piute | Utah | 49031 | 2 | 0 |
227363 | 227363 | 2020-06-10 | Piute | Utah | 49031 | 2 | 0 |
230467 | 230467 | 2020-06-11 | Piute | Utah | 49031 | 2 | 0 |
233571 | 233571 | 2020-06-12 | Piute | Utah | 49031 | 2 | 0 |
236678 | 236678 | 2020-06-13 | Piute | Utah | 49031 | 2 | 0 |
239786 | 239786 | 2020-06-14 | Piute | Utah | 49031 | 2 | 0 |
242897 | 242897 | 2020-06-15 | Piute | Utah | 49031 | 2 | 0 |
246009 | 246009 | 2020-06-16 | Piute | Utah | 49031 | 2 | 0 |
249122 | 249122 | 2020-06-17 | Piute | Utah | 49031 | 2 | 0 |
252237 | 252237 | 2020-06-18 | Piute | Utah | 49031 | 2 | 0 |
255354 | 255354 | 2020-06-19 | Piute | Utah | 49031 | 2 | 0 |
258481 | 258481 | 2020-06-20 | Piute | Utah | 49031 | 2 | 0 |
261608 | 261608 | 2020-06-21 | Piute | Utah | 49031 | 2 | 0 |
264737 | 264737 | 2020-06-22 | Piute | Utah | 49031 | 2 | 0 |
267866 | 267866 | 2020-06-23 | Piute | Utah | 49031 | 2 | 0 |
271000 | 271000 | 2020-06-24 | Piute | Utah | 49031 | 2 | 0 |
274140 | 274140 | 2020-06-25 | Piute | Utah | 49031 | 2 | 0 |
277288 | 277288 | 2020-06-26 | Piute | Utah | 49031 | 2 | 0 |
280436 | 280436 | 2020-06-27 | Piute | Utah | 49031 | 2 | 0 |
283582 | 283582 | 2020-06-28 | Piute | Utah | 49031 | 3 | 0 |
286728 | 286728 | 2020-06-29 | Piute | Utah | 49031 | 3 | 0 |
289878 | 289878 | 2020-06-30 | Piute | Utah | 49031 | 3 | 0 |
293031 | 293031 | 2020-07-01 | Piute | Utah | 49031 | 3 | 0 |
296186 | 296186 | 2020-07-02 | Piute | Utah | 49031 | 3 | 0 |
299348 | 299348 | 2020-07-03 | Piute | Utah | 49031 | 4 | 0 |
302512 | 302512 | 2020-07-04 | Piute | Utah | 49031 | 4 | 0 |
305676 | 305676 | 2020-07-05 | Piute | Utah | 49031 | 4 | 0 |
308844 | 308844 | 2020-07-06 | Piute | Utah | 49031 | 4 | 0 |
312013 | 312013 | 2020-07-07 | Piute | Utah | 49031 | 4 | 0 |
315187 | 315187 | 2020-07-08 | Piute | Utah | 49031 | 4 | 0 |
318360 | 318360 | 2020-07-09 | Piute | Utah | 49031 | 4 | 0 |
321539 | 321539 | 2020-07-10 | Piute | Utah | 49031 | 4 | 0 |
324720 | 324720 | 2020-07-11 | Piute | Utah | 49031 | 4 | 0 |
327905 | 327905 | 2020-07-12 | Piute | Utah | 49031 | 4 | 0 |
331091 | 331091 | 2020-07-13 | Piute | Utah | 49031 | 4 | 0 |
334284 | 334284 | 2020-07-14 | Piute | Utah | 49031 | 4 | 0 |
337479 | 337479 | 2020-07-15 | Piute | Utah | 49031 | 4 | 0 |
340675 | 340675 | 2020-07-16 | Piute | Utah | 49031 | 4 | 0 |
343874 | 343874 | 2020-07-17 | Piute | Utah | 49031 | 4 | 0 |
347075 | 347075 | 2020-07-18 | Piute | Utah | 49031 | 4 | 0 |
350275 | 350275 | 2020-07-19 | Piute | Utah | 49031 | 4 | 0 |
353477 | 353477 | 2020-07-20 | Piute | Utah | 49031 | 4 | 0 |
356680 | 356680 | 2020-07-21 | Piute | Utah | 49031 | 4 | 0 |
359885 | 359885 | 2020-07-22 | Piute | Utah | 49031 | 4 | 0 |
363092 | 363092 | 2020-07-23 | Piute | Utah | 49031 | 4 | 0 |
366298 | 366298 | 2020-07-24 | Piute | Utah | 49031 | 4 | 0 |
369507 | 369507 | 2020-07-25 | Piute | Utah | 49031 | 4 | 0 |
372719 | 372719 | 2020-07-26 | Piute | Utah | 49031 | 4 | 0 |
375932 | 375932 | 2020-07-27 | Piute | Utah | 49031 | 4 | 0 |
379148 | 379148 | 2020-07-28 | Piute | Utah | 49031 | 4 | 0 |
382365 | 382365 | 2020-07-29 | Piute | Utah | 49031 | 4 | 0 |
385583 | 385583 | 2020-07-30 | Piute | Utah | 49031 | 4 | 0 |
388800 | 388800 | 2020-07-31 | Piute | Utah | 49031 | 4 | 0 |
392017 | 392017 | 2020-08-01 | Piute | Utah | 49031 | 4 | 0 |
395233 | 395233 | 2020-08-02 | Piute | Utah | 49031 | 4 | 0 |
398449 | 398449 | 2020-08-03 | Piute | Utah | 49031 | 4 | 0 |
401665 | 401665 | 2020-08-04 | Piute | Utah | 49031 | 5 | 0 |
404883 | 404883 | 2020-08-05 | Piute | Utah | 49031 | 5 | 0 |
408103 | 408103 | 2020-08-06 | Piute | Utah | 49031 | 5 | 0 |
411322 | 411322 | 2020-08-07 | Piute | Utah | 49031 | 6 | 0 |
414542 | 414542 | 2020-08-08 | Piute | Utah | 49031 | 6 | 0 |
417763 | 417763 | 2020-08-09 | Piute | Utah | 49031 | 6 | 0 |
420984 | 420984 | 2020-08-10 | Piute | Utah | 49031 | 6 | 0 |
424205 | 424205 | 2020-08-11 | Piute | Utah | 49031 | 6 | 0 |
427429 | 427429 | 2020-08-12 | Piute | Utah | 49031 | 6 | 0 |
430657 | 430657 | 2020-08-13 | Piute | Utah | 49031 | 6 | 0 |
433882 | 433882 | 2020-08-14 | Piute | Utah | 49031 | 6 | 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);