ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 49047 and state = "Utah" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
15604 | 15604 | 2020-03-27 | Uintah | Utah | 49047 | 1 | 0 |
17478 | 17478 | 2020-03-28 | Uintah | Utah | 49047 | 1 | 0 |
19437 | 19437 | 2020-03-29 | Uintah | Utah | 49047 | 1 | 0 |
21500 | 21500 | 2020-03-30 | Uintah | Utah | 49047 | 1 | 0 |
23639 | 23639 | 2020-03-31 | Uintah | Utah | 49047 | 1 | 0 |
25854 | 25854 | 2020-04-01 | Uintah | Utah | 49047 | 1 | 0 |
28143 | 28143 | 2020-04-02 | Uintah | Utah | 49047 | 1 | 0 |
30486 | 30486 | 2020-04-03 | Uintah | Utah | 49047 | 1 | 0 |
32884 | 32884 | 2020-04-04 | Uintah | Utah | 49047 | 1 | 0 |
35322 | 35322 | 2020-04-05 | Uintah | Utah | 49047 | 1 | 0 |
37800 | 37800 | 2020-04-06 | Uintah | Utah | 49047 | 1 | 0 |
40329 | 40329 | 2020-04-07 | Uintah | Utah | 49047 | 2 | 0 |
42897 | 42897 | 2020-04-08 | Uintah | Utah | 49047 | 4 | 0 |
45491 | 45491 | 2020-04-09 | Uintah | Utah | 49047 | 5 | 0 |
48115 | 48115 | 2020-04-10 | Uintah | Utah | 49047 | 5 | 0 |
50773 | 50773 | 2020-04-11 | Uintah | Utah | 49047 | 5 | 0 |
53448 | 53448 | 2020-04-12 | Uintah | Utah | 49047 | 5 | 0 |
56137 | 56137 | 2020-04-13 | Uintah | Utah | 49047 | 6 | 0 |
58843 | 58843 | 2020-04-14 | Uintah | Utah | 49047 | 6 | 0 |
61562 | 61562 | 2020-04-15 | Uintah | Utah | 49047 | 6 | 0 |
64294 | 64294 | 2020-04-16 | Uintah | Utah | 49047 | 6 | 0 |
67042 | 67042 | 2020-04-17 | Uintah | Utah | 49047 | 6 | 0 |
69804 | 69804 | 2020-04-18 | Uintah | Utah | 49047 | 6 | 0 |
72574 | 72574 | 2020-04-19 | Uintah | Utah | 49047 | 6 | 0 |
75350 | 75350 | 2020-04-20 | Uintah | Utah | 49047 | 6 | 0 |
78132 | 78132 | 2020-04-21 | Uintah | Utah | 49047 | 6 | 0 |
80924 | 80924 | 2020-04-22 | Uintah | Utah | 49047 | 6 | 0 |
83725 | 83725 | 2020-04-23 | Uintah | Utah | 49047 | 6 | 0 |
86532 | 86532 | 2020-04-24 | Uintah | Utah | 49047 | 6 | 0 |
89347 | 89347 | 2020-04-25 | Uintah | Utah | 49047 | 6 | 0 |
92164 | 92164 | 2020-04-26 | Uintah | Utah | 49047 | 6 | 0 |
94993 | 94993 | 2020-04-27 | Uintah | Utah | 49047 | 6 | 0 |
97835 | 97835 | 2020-04-28 | Uintah | Utah | 49047 | 6 | 0 |
100685 | 100685 | 2020-04-29 | Uintah | Utah | 49047 | 6 | 0 |
103540 | 103540 | 2020-04-30 | Uintah | Utah | 49047 | 6 | 0 |
106404 | 106404 | 2020-05-01 | Uintah | Utah | 49047 | 6 | 0 |
109273 | 109273 | 2020-05-02 | Uintah | Utah | 49047 | 6 | 0 |
112147 | 112147 | 2020-05-03 | Uintah | Utah | 49047 | 6 | 0 |
115030 | 115030 | 2020-05-04 | Uintah | Utah | 49047 | 6 | 0 |
117989 | 117989 | 2020-05-05 | Uintah | Utah | 49047 | 6 | 0 |
120953 | 120953 | 2020-05-06 | Uintah | Utah | 49047 | 6 | 0 |
123934 | 123934 | 2020-05-07 | Uintah | Utah | 49047 | 6 | 0 |
126919 | 126919 | 2020-05-08 | Uintah | Utah | 49047 | 6 | 0 |
129908 | 129908 | 2020-05-09 | Uintah | Utah | 49047 | 7 | 0 |
132898 | 132898 | 2020-05-10 | Uintah | Utah | 49047 | 7 | 0 |
135889 | 135889 | 2020-05-11 | Uintah | Utah | 49047 | 7 | 0 |
138879 | 138879 | 2020-05-12 | Uintah | Utah | 49047 | 7 | 0 |
141875 | 141875 | 2020-05-13 | Uintah | Utah | 49047 | 7 | 0 |
144872 | 144872 | 2020-05-14 | Uintah | Utah | 49047 | 8 | 0 |
147876 | 147876 | 2020-05-15 | Uintah | Utah | 49047 | 8 | 0 |
150884 | 150884 | 2020-05-16 | Uintah | Utah | 49047 | 8 | 0 |
153895 | 153895 | 2020-05-17 | Uintah | Utah | 49047 | 8 | 0 |
156912 | 156912 | 2020-05-18 | Uintah | Utah | 49047 | 10 | 0 |
159936 | 159936 | 2020-05-19 | Uintah | Utah | 49047 | 10 | 0 |
162964 | 162964 | 2020-05-20 | Uintah | Utah | 49047 | 10 | 0 |
165993 | 165993 | 2020-05-21 | Uintah | Utah | 49047 | 10 | 0 |
169029 | 169029 | 2020-05-22 | Uintah | Utah | 49047 | 10 | 0 |
172070 | 172070 | 2020-05-23 | Uintah | Utah | 49047 | 9 | 0 |
175113 | 175113 | 2020-05-24 | Uintah | Utah | 49047 | 9 | 0 |
178158 | 178158 | 2020-05-25 | Uintah | Utah | 49047 | 9 | 0 |
181202 | 181202 | 2020-05-26 | Uintah | Utah | 49047 | 9 | 0 |
184253 | 184253 | 2020-05-27 | Uintah | Utah | 49047 | 9 | 0 |
187310 | 187310 | 2020-05-28 | Uintah | Utah | 49047 | 9 | 0 |
190374 | 190374 | 2020-05-29 | Uintah | Utah | 49047 | 9 | 0 |
193440 | 193440 | 2020-05-30 | Uintah | Utah | 49047 | 10 | 0 |
196510 | 196510 | 2020-05-31 | Uintah | Utah | 49047 | 10 | 0 |
199583 | 199583 | 2020-06-01 | Uintah | Utah | 49047 | 10 | 0 |
202659 | 202659 | 2020-06-02 | Uintah | Utah | 49047 | 10 | 0 |
205738 | 205738 | 2020-06-03 | Uintah | Utah | 49047 | 10 | 0 |
208820 | 208820 | 2020-06-04 | Uintah | Utah | 49047 | 10 | 0 |
211905 | 211905 | 2020-06-05 | Uintah | Utah | 49047 | 10 | 0 |
214992 | 214992 | 2020-06-06 | Uintah | Utah | 49047 | 10 | 0 |
218082 | 218082 | 2020-06-07 | Uintah | Utah | 49047 | 11 | 0 |
221174 | 221174 | 2020-06-08 | Uintah | Utah | 49047 | 12 | 0 |
224270 | 224270 | 2020-06-09 | Uintah | Utah | 49047 | 12 | 0 |
227370 | 227370 | 2020-06-10 | Uintah | Utah | 49047 | 13 | 0 |
230474 | 230474 | 2020-06-11 | Uintah | Utah | 49047 | 17 | 0 |
233579 | 233579 | 2020-06-12 | Uintah | Utah | 49047 | 17 | 0 |
236686 | 236686 | 2020-06-13 | Uintah | Utah | 49047 | 18 | 0 |
239794 | 239794 | 2020-06-14 | Uintah | Utah | 49047 | 19 | 0 |
242905 | 242905 | 2020-06-15 | Uintah | Utah | 49047 | 19 | 0 |
246017 | 246017 | 2020-06-16 | Uintah | Utah | 49047 | 20 | 0 |
249130 | 249130 | 2020-06-17 | Uintah | Utah | 49047 | 22 | 0 |
252245 | 252245 | 2020-06-18 | Uintah | Utah | 49047 | 25 | 0 |
255362 | 255362 | 2020-06-19 | Uintah | Utah | 49047 | 26 | 0 |
258489 | 258489 | 2020-06-20 | Uintah | Utah | 49047 | 26 | 0 |
261616 | 261616 | 2020-06-21 | Uintah | Utah | 49047 | 26 | 0 |
264745 | 264745 | 2020-06-22 | Uintah | Utah | 49047 | 26 | 0 |
267874 | 267874 | 2020-06-23 | Uintah | Utah | 49047 | 27 | 0 |
271008 | 271008 | 2020-06-24 | Uintah | Utah | 49047 | 27 | 0 |
274148 | 274148 | 2020-06-25 | Uintah | Utah | 49047 | 29 | 0 |
277296 | 277296 | 2020-06-26 | Uintah | Utah | 49047 | 29 | 0 |
280444 | 280444 | 2020-06-27 | Uintah | Utah | 49047 | 29 | 0 |
283590 | 283590 | 2020-06-28 | Uintah | Utah | 49047 | 30 | 0 |
286736 | 286736 | 2020-06-29 | Uintah | Utah | 49047 | 30 | 0 |
289886 | 289886 | 2020-06-30 | Uintah | Utah | 49047 | 31 | 0 |
293039 | 293039 | 2020-07-01 | Uintah | Utah | 49047 | 31 | 0 |
296194 | 296194 | 2020-07-02 | Uintah | Utah | 49047 | 31 | 0 |
299356 | 299356 | 2020-07-03 | Uintah | Utah | 49047 | 31 | 0 |
302520 | 302520 | 2020-07-04 | Uintah | Utah | 49047 | 33 | 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);