ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where county = "Sanpete" 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 |
---|---|---|---|---|---|---|---|
69800 | 69800 | 2020-04-18 | Sanpete | Utah | 49039 | 3 | 0 |
72570 | 72570 | 2020-04-19 | Sanpete | Utah | 49039 | 3 | 0 |
75346 | 75346 | 2020-04-20 | Sanpete | Utah | 49039 | 3 | 0 |
78128 | 78128 | 2020-04-21 | Sanpete | Utah | 49039 | 3 | 0 |
80920 | 80920 | 2020-04-22 | Sanpete | Utah | 49039 | 3 | 0 |
83721 | 83721 | 2020-04-23 | Sanpete | Utah | 49039 | 4 | 0 |
86528 | 86528 | 2020-04-24 | Sanpete | Utah | 49039 | 4 | 0 |
89343 | 89343 | 2020-04-25 | Sanpete | Utah | 49039 | 4 | 0 |
92160 | 92160 | 2020-04-26 | Sanpete | Utah | 49039 | 5 | 0 |
94989 | 94989 | 2020-04-27 | Sanpete | Utah | 49039 | 5 | 0 |
97831 | 97831 | 2020-04-28 | Sanpete | Utah | 49039 | 5 | 0 |
100681 | 100681 | 2020-04-29 | Sanpete | Utah | 49039 | 5 | 0 |
103536 | 103536 | 2020-04-30 | Sanpete | Utah | 49039 | 5 | 0 |
106400 | 106400 | 2020-05-01 | Sanpete | Utah | 49039 | 5 | 0 |
109269 | 109269 | 2020-05-02 | Sanpete | Utah | 49039 | 5 | 0 |
112143 | 112143 | 2020-05-03 | Sanpete | Utah | 49039 | 5 | 0 |
115026 | 115026 | 2020-05-04 | Sanpete | Utah | 49039 | 6 | 0 |
117985 | 117985 | 2020-05-05 | Sanpete | Utah | 49039 | 6 | 0 |
120949 | 120949 | 2020-05-06 | Sanpete | Utah | 49039 | 6 | 0 |
123930 | 123930 | 2020-05-07 | Sanpete | Utah | 49039 | 6 | 0 |
126915 | 126915 | 2020-05-08 | Sanpete | Utah | 49039 | 6 | 0 |
129904 | 129904 | 2020-05-09 | Sanpete | Utah | 49039 | 6 | 0 |
132894 | 132894 | 2020-05-10 | Sanpete | Utah | 49039 | 6 | 0 |
135885 | 135885 | 2020-05-11 | Sanpete | Utah | 49039 | 6 | 0 |
138875 | 138875 | 2020-05-12 | Sanpete | Utah | 49039 | 6 | 0 |
141871 | 141871 | 2020-05-13 | Sanpete | Utah | 49039 | 6 | 0 |
144868 | 144868 | 2020-05-14 | Sanpete | Utah | 49039 | 6 | 0 |
147872 | 147872 | 2020-05-15 | Sanpete | Utah | 49039 | 6 | 0 |
150880 | 150880 | 2020-05-16 | Sanpete | Utah | 49039 | 6 | 0 |
153891 | 153891 | 2020-05-17 | Sanpete | Utah | 49039 | 6 | 0 |
156908 | 156908 | 2020-05-18 | Sanpete | Utah | 49039 | 6 | 0 |
159932 | 159932 | 2020-05-19 | Sanpete | Utah | 49039 | 6 | 0 |
162960 | 162960 | 2020-05-20 | Sanpete | Utah | 49039 | 7 | 0 |
165989 | 165989 | 2020-05-21 | Sanpete | Utah | 49039 | 7 | 0 |
169025 | 169025 | 2020-05-22 | Sanpete | Utah | 49039 | 7 | 0 |
172066 | 172066 | 2020-05-23 | Sanpete | Utah | 49039 | 7 | 0 |
175109 | 175109 | 2020-05-24 | Sanpete | Utah | 49039 | 7 | 0 |
178154 | 178154 | 2020-05-25 | Sanpete | Utah | 49039 | 7 | 0 |
181198 | 181198 | 2020-05-26 | Sanpete | Utah | 49039 | 7 | 0 |
184249 | 184249 | 2020-05-27 | Sanpete | Utah | 49039 | 7 | 0 |
187306 | 187306 | 2020-05-28 | Sanpete | Utah | 49039 | 12 | 0 |
190370 | 190370 | 2020-05-29 | Sanpete | Utah | 49039 | 12 | 0 |
193436 | 193436 | 2020-05-30 | Sanpete | Utah | 49039 | 12 | 0 |
196506 | 196506 | 2020-05-31 | Sanpete | Utah | 49039 | 12 | 0 |
199579 | 199579 | 2020-06-01 | Sanpete | Utah | 49039 | 12 | 0 |
202655 | 202655 | 2020-06-02 | Sanpete | Utah | 49039 | 12 | 0 |
205734 | 205734 | 2020-06-03 | Sanpete | Utah | 49039 | 12 | 0 |
208816 | 208816 | 2020-06-04 | Sanpete | Utah | 49039 | 13 | 0 |
211901 | 211901 | 2020-06-05 | Sanpete | Utah | 49039 | 14 | 0 |
214988 | 214988 | 2020-06-06 | Sanpete | Utah | 49039 | 14 | 0 |
218078 | 218078 | 2020-06-07 | Sanpete | Utah | 49039 | 14 | 0 |
221170 | 221170 | 2020-06-08 | Sanpete | Utah | 49039 | 14 | 0 |
224266 | 224266 | 2020-06-09 | Sanpete | Utah | 49039 | 16 | 0 |
227366 | 227366 | 2020-06-10 | Sanpete | Utah | 49039 | 17 | 0 |
230470 | 230470 | 2020-06-11 | Sanpete | Utah | 49039 | 20 | 0 |
233575 | 233575 | 2020-06-12 | Sanpete | Utah | 49039 | 21 | 0 |
236682 | 236682 | 2020-06-13 | Sanpete | Utah | 49039 | 21 | 0 |
239790 | 239790 | 2020-06-14 | Sanpete | Utah | 49039 | 21 | 0 |
242901 | 242901 | 2020-06-15 | Sanpete | Utah | 49039 | 27 | 0 |
246013 | 246013 | 2020-06-16 | Sanpete | Utah | 49039 | 28 | 0 |
249126 | 249126 | 2020-06-17 | Sanpete | Utah | 49039 | 29 | 0 |
252241 | 252241 | 2020-06-18 | Sanpete | Utah | 49039 | 29 | 0 |
255358 | 255358 | 2020-06-19 | Sanpete | Utah | 49039 | 35 | 0 |
258485 | 258485 | 2020-06-20 | Sanpete | Utah | 49039 | 39 | 0 |
261612 | 261612 | 2020-06-21 | Sanpete | Utah | 49039 | 41 | 0 |
264741 | 264741 | 2020-06-22 | Sanpete | Utah | 49039 | 42 | 0 |
267870 | 267870 | 2020-06-23 | Sanpete | Utah | 49039 | 43 | 0 |
271004 | 271004 | 2020-06-24 | Sanpete | Utah | 49039 | 44 | 0 |
274144 | 274144 | 2020-06-25 | Sanpete | Utah | 49039 | 44 | 0 |
277292 | 277292 | 2020-06-26 | Sanpete | Utah | 49039 | 45 | 0 |
280440 | 280440 | 2020-06-27 | Sanpete | Utah | 49039 | 45 | 0 |
283586 | 283586 | 2020-06-28 | Sanpete | Utah | 49039 | 47 | 0 |
286732 | 286732 | 2020-06-29 | Sanpete | Utah | 49039 | 47 | 0 |
289882 | 289882 | 2020-06-30 | Sanpete | Utah | 49039 | 50 | 0 |
293035 | 293035 | 2020-07-01 | Sanpete | Utah | 49039 | 53 | 0 |
296190 | 296190 | 2020-07-02 | Sanpete | Utah | 49039 | 53 | 0 |
299352 | 299352 | 2020-07-03 | Sanpete | Utah | 49039 | 56 | 0 |
302516 | 302516 | 2020-07-04 | Sanpete | Utah | 49039 | 56 | 0 |
305680 | 305680 | 2020-07-05 | Sanpete | Utah | 49039 | 56 | 0 |
308848 | 308848 | 2020-07-06 | Sanpete | Utah | 49039 | 66 | 0 |
312017 | 312017 | 2020-07-07 | Sanpete | Utah | 49039 | 66 | 0 |
315191 | 315191 | 2020-07-08 | Sanpete | Utah | 49039 | 69 | 0 |
318364 | 318364 | 2020-07-09 | Sanpete | Utah | 49039 | 69 | 0 |
321543 | 321543 | 2020-07-10 | Sanpete | Utah | 49039 | 71 | 0 |
324724 | 324724 | 2020-07-11 | Sanpete | Utah | 49039 | 71 | 0 |
327909 | 327909 | 2020-07-12 | Sanpete | Utah | 49039 | 71 | 0 |
331095 | 331095 | 2020-07-13 | Sanpete | Utah | 49039 | 74 | 0 |
334288 | 334288 | 2020-07-14 | Sanpete | Utah | 49039 | 75 | 0 |
337483 | 337483 | 2020-07-15 | Sanpete | Utah | 49039 | 75 | 0 |
340679 | 340679 | 2020-07-16 | Sanpete | Utah | 49039 | 76 | 0 |
343878 | 343878 | 2020-07-17 | Sanpete | Utah | 49039 | 76 | 0 |
347079 | 347079 | 2020-07-18 | Sanpete | Utah | 49039 | 76 | 0 |
350279 | 350279 | 2020-07-19 | Sanpete | Utah | 49039 | 76 | 0 |
353481 | 353481 | 2020-07-20 | Sanpete | Utah | 49039 | 84 | 0 |
356684 | 356684 | 2020-07-21 | Sanpete | Utah | 49039 | 85 | 0 |
359889 | 359889 | 2020-07-22 | Sanpete | Utah | 49039 | 86 | 0 |
363096 | 363096 | 2020-07-23 | Sanpete | Utah | 49039 | 88 | 0 |
366302 | 366302 | 2020-07-24 | Sanpete | Utah | 49039 | 88 | 0 |
369511 | 369511 | 2020-07-25 | Sanpete | Utah | 49039 | 88 | 0 |
372723 | 372723 | 2020-07-26 | Sanpete | Utah | 49039 | 93 | 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);