ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 49013 and state = "Utah" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
30473 | 30473 | 2020-04-03 | Duchesne | Utah | 49013 | 1 | 0 |
32871 | 32871 | 2020-04-04 | Duchesne | Utah | 49013 | 1 | 0 |
35309 | 35309 | 2020-04-05 | Duchesne | Utah | 49013 | 1 | 0 |
37787 | 37787 | 2020-04-06 | Duchesne | Utah | 49013 | 1 | 0 |
40316 | 40316 | 2020-04-07 | Duchesne | Utah | 49013 | 1 | 0 |
42884 | 42884 | 2020-04-08 | Duchesne | Utah | 49013 | 2 | 0 |
45478 | 45478 | 2020-04-09 | Duchesne | Utah | 49013 | 3 | 0 |
48102 | 48102 | 2020-04-10 | Duchesne | Utah | 49013 | 3 | 0 |
50760 | 50760 | 2020-04-11 | Duchesne | Utah | 49013 | 3 | 0 |
53435 | 53435 | 2020-04-12 | Duchesne | Utah | 49013 | 3 | 0 |
56124 | 56124 | 2020-04-13 | Duchesne | Utah | 49013 | 3 | 0 |
58830 | 58830 | 2020-04-14 | Duchesne | Utah | 49013 | 3 | 0 |
61548 | 61548 | 2020-04-15 | Duchesne | Utah | 49013 | 3 | 0 |
64280 | 64280 | 2020-04-16 | Duchesne | Utah | 49013 | 3 | 0 |
67028 | 67028 | 2020-04-17 | Duchesne | Utah | 49013 | 4 | 0 |
69789 | 69789 | 2020-04-18 | Duchesne | Utah | 49013 | 4 | 0 |
72559 | 72559 | 2020-04-19 | Duchesne | Utah | 49013 | 5 | 0 |
75335 | 75335 | 2020-04-20 | Duchesne | Utah | 49013 | 4 | 0 |
78117 | 78117 | 2020-04-21 | Duchesne | Utah | 49013 | 4 | 0 |
80909 | 80909 | 2020-04-22 | Duchesne | Utah | 49013 | 4 | 0 |
83710 | 83710 | 2020-04-23 | Duchesne | Utah | 49013 | 4 | 0 |
86517 | 86517 | 2020-04-24 | Duchesne | Utah | 49013 | 4 | 0 |
89332 | 89332 | 2020-04-25 | Duchesne | Utah | 49013 | 4 | 0 |
92149 | 92149 | 2020-04-26 | Duchesne | Utah | 49013 | 5 | 0 |
94978 | 94978 | 2020-04-27 | Duchesne | Utah | 49013 | 5 | 0 |
97820 | 97820 | 2020-04-28 | Duchesne | Utah | 49013 | 5 | 0 |
100670 | 100670 | 2020-04-29 | Duchesne | Utah | 49013 | 5 | 0 |
103525 | 103525 | 2020-04-30 | Duchesne | Utah | 49013 | 5 | 0 |
106389 | 106389 | 2020-05-01 | Duchesne | Utah | 49013 | 7 | 0 |
109258 | 109258 | 2020-05-02 | Duchesne | Utah | 49013 | 7 | 0 |
112132 | 112132 | 2020-05-03 | Duchesne | Utah | 49013 | 8 | 0 |
115015 | 115015 | 2020-05-04 | Duchesne | Utah | 49013 | 8 | 0 |
117974 | 117974 | 2020-05-05 | Duchesne | Utah | 49013 | 8 | 0 |
120938 | 120938 | 2020-05-06 | Duchesne | Utah | 49013 | 8 | 0 |
123918 | 123918 | 2020-05-07 | Duchesne | Utah | 49013 | 8 | 0 |
126903 | 126903 | 2020-05-08 | Duchesne | Utah | 49013 | 8 | 0 |
129892 | 129892 | 2020-05-09 | Duchesne | Utah | 49013 | 9 | 0 |
132882 | 132882 | 2020-05-10 | Duchesne | Utah | 49013 | 9 | 0 |
135873 | 135873 | 2020-05-11 | Duchesne | Utah | 49013 | 9 | 0 |
138863 | 138863 | 2020-05-12 | Duchesne | Utah | 49013 | 9 | 0 |
141859 | 141859 | 2020-05-13 | Duchesne | Utah | 49013 | 9 | 0 |
144856 | 144856 | 2020-05-14 | Duchesne | Utah | 49013 | 9 | 0 |
147860 | 147860 | 2020-05-15 | Duchesne | Utah | 49013 | 11 | 0 |
150868 | 150868 | 2020-05-16 | Duchesne | Utah | 49013 | 11 | 0 |
153879 | 153879 | 2020-05-17 | Duchesne | Utah | 49013 | 11 | 0 |
156896 | 156896 | 2020-05-18 | Duchesne | Utah | 49013 | 9 | 0 |
159920 | 159920 | 2020-05-19 | Duchesne | Utah | 49013 | 9 | 0 |
162948 | 162948 | 2020-05-20 | Duchesne | Utah | 49013 | 9 | 0 |
165977 | 165977 | 2020-05-21 | Duchesne | Utah | 49013 | 9 | 0 |
169013 | 169013 | 2020-05-22 | Duchesne | Utah | 49013 | 9 | 0 |
172054 | 172054 | 2020-05-23 | Duchesne | Utah | 49013 | 8 | 0 |
175097 | 175097 | 2020-05-24 | Duchesne | Utah | 49013 | 8 | 0 |
178142 | 178142 | 2020-05-25 | Duchesne | Utah | 49013 | 8 | 0 |
181186 | 181186 | 2020-05-26 | Duchesne | Utah | 49013 | 8 | 0 |
184237 | 184237 | 2020-05-27 | Duchesne | Utah | 49013 | 8 | 0 |
187294 | 187294 | 2020-05-28 | Duchesne | Utah | 49013 | 8 | 0 |
190358 | 190358 | 2020-05-29 | Duchesne | Utah | 49013 | 8 | 0 |
193424 | 193424 | 2020-05-30 | Duchesne | Utah | 49013 | 9 | 0 |
196494 | 196494 | 2020-05-31 | Duchesne | Utah | 49013 | 9 | 0 |
199567 | 199567 | 2020-06-01 | Duchesne | Utah | 49013 | 9 | 0 |
202643 | 202643 | 2020-06-02 | Duchesne | Utah | 49013 | 9 | 0 |
205722 | 205722 | 2020-06-03 | Duchesne | Utah | 49013 | 9 | 0 |
208804 | 208804 | 2020-06-04 | Duchesne | Utah | 49013 | 9 | 0 |
211889 | 211889 | 2020-06-05 | Duchesne | Utah | 49013 | 9 | 0 |
214976 | 214976 | 2020-06-06 | Duchesne | Utah | 49013 | 9 | 0 |
218066 | 218066 | 2020-06-07 | Duchesne | Utah | 49013 | 10 | 0 |
221158 | 221158 | 2020-06-08 | Duchesne | Utah | 49013 | 9 | 0 |
224254 | 224254 | 2020-06-09 | Duchesne | Utah | 49013 | 9 | 0 |
227354 | 227354 | 2020-06-10 | Duchesne | Utah | 49013 | 9 | 0 |
230458 | 230458 | 2020-06-11 | Duchesne | Utah | 49013 | 9 | 0 |
233562 | 233562 | 2020-06-12 | Duchesne | Utah | 49013 | 9 | 0 |
236669 | 236669 | 2020-06-13 | Duchesne | Utah | 49013 | 10 | 0 |
239777 | 239777 | 2020-06-14 | Duchesne | Utah | 49013 | 10 | 0 |
242888 | 242888 | 2020-06-15 | Duchesne | Utah | 49013 | 10 | 0 |
246000 | 246000 | 2020-06-16 | Duchesne | Utah | 49013 | 10 | 0 |
249113 | 249113 | 2020-06-17 | Duchesne | Utah | 49013 | 10 | 0 |
252228 | 252228 | 2020-06-18 | Duchesne | Utah | 49013 | 10 | 0 |
255345 | 255345 | 2020-06-19 | Duchesne | Utah | 49013 | 10 | 0 |
258472 | 258472 | 2020-06-20 | Duchesne | Utah | 49013 | 10 | 0 |
261599 | 261599 | 2020-06-21 | Duchesne | Utah | 49013 | 10 | 0 |
264728 | 264728 | 2020-06-22 | Duchesne | Utah | 49013 | 10 | 0 |
267857 | 267857 | 2020-06-23 | Duchesne | Utah | 49013 | 10 | 0 |
270991 | 270991 | 2020-06-24 | Duchesne | Utah | 49013 | 11 | 0 |
274131 | 274131 | 2020-06-25 | Duchesne | Utah | 49013 | 11 | 0 |
277279 | 277279 | 2020-06-26 | Duchesne | Utah | 49013 | 13 | 0 |
280427 | 280427 | 2020-06-27 | Duchesne | Utah | 49013 | 13 | 0 |
283573 | 283573 | 2020-06-28 | Duchesne | Utah | 49013 | 13 | 0 |
286719 | 286719 | 2020-06-29 | Duchesne | Utah | 49013 | 13 | 0 |
289869 | 289869 | 2020-06-30 | Duchesne | Utah | 49013 | 14 | 0 |
293022 | 293022 | 2020-07-01 | Duchesne | Utah | 49013 | 14 | 0 |
296177 | 296177 | 2020-07-02 | Duchesne | Utah | 49013 | 14 | 0 |
299339 | 299339 | 2020-07-03 | Duchesne | Utah | 49013 | 14 | 0 |
302503 | 302503 | 2020-07-04 | Duchesne | Utah | 49013 | 14 | 0 |
305667 | 305667 | 2020-07-05 | Duchesne | Utah | 49013 | 14 | 0 |
308835 | 308835 | 2020-07-06 | Duchesne | Utah | 49013 | 15 | 0 |
312004 | 312004 | 2020-07-07 | Duchesne | Utah | 49013 | 15 | 0 |
315178 | 315178 | 2020-07-08 | Duchesne | Utah | 49013 | 15 | 0 |
318351 | 318351 | 2020-07-09 | Duchesne | Utah | 49013 | 20 | 0 |
321530 | 321530 | 2020-07-10 | Duchesne | Utah | 49013 | 20 | 0 |
324711 | 324711 | 2020-07-11 | Duchesne | Utah | 49013 | 20 | 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);