ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 49023 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 |
---|---|---|---|---|---|---|---|
30478 | 30478 | 2020-04-03 | Juab | Utah | 49023 | 1 | 0 |
32876 | 32876 | 2020-04-04 | Juab | Utah | 49023 | 1 | 0 |
35314 | 35314 | 2020-04-05 | Juab | Utah | 49023 | 1 | 0 |
37792 | 37792 | 2020-04-06 | Juab | Utah | 49023 | 2 | 0 |
40321 | 40321 | 2020-04-07 | Juab | Utah | 49023 | 2 | 0 |
42889 | 42889 | 2020-04-08 | Juab | Utah | 49023 | 2 | 0 |
45483 | 45483 | 2020-04-09 | Juab | Utah | 49023 | 2 | 0 |
48107 | 48107 | 2020-04-10 | Juab | Utah | 49023 | 2 | 0 |
50765 | 50765 | 2020-04-11 | Juab | Utah | 49023 | 2 | 0 |
53440 | 53440 | 2020-04-12 | Juab | Utah | 49023 | 2 | 0 |
56129 | 56129 | 2020-04-13 | Juab | Utah | 49023 | 2 | 0 |
58835 | 58835 | 2020-04-14 | Juab | Utah | 49023 | 2 | 0 |
61553 | 61553 | 2020-04-15 | Juab | Utah | 49023 | 2 | 0 |
64285 | 64285 | 2020-04-16 | Juab | Utah | 49023 | 2 | 0 |
67033 | 67033 | 2020-04-17 | Juab | Utah | 49023 | 2 | 0 |
69794 | 69794 | 2020-04-18 | Juab | Utah | 49023 | 2 | 0 |
72564 | 72564 | 2020-04-19 | Juab | Utah | 49023 | 2 | 0 |
75340 | 75340 | 2020-04-20 | Juab | Utah | 49023 | 2 | 0 |
78122 | 78122 | 2020-04-21 | Juab | Utah | 49023 | 4 | 0 |
80914 | 80914 | 2020-04-22 | Juab | Utah | 49023 | 4 | 0 |
83715 | 83715 | 2020-04-23 | Juab | Utah | 49023 | 7 | 0 |
86522 | 86522 | 2020-04-24 | Juab | Utah | 49023 | 7 | 0 |
89337 | 89337 | 2020-04-25 | Juab | Utah | 49023 | 7 | 0 |
92154 | 92154 | 2020-04-26 | Juab | Utah | 49023 | 7 | 0 |
94983 | 94983 | 2020-04-27 | Juab | Utah | 49023 | 7 | 0 |
97825 | 97825 | 2020-04-28 | Juab | Utah | 49023 | 7 | 0 |
100675 | 100675 | 2020-04-29 | Juab | Utah | 49023 | 7 | 0 |
103530 | 103530 | 2020-04-30 | Juab | Utah | 49023 | 7 | 0 |
106394 | 106394 | 2020-05-01 | Juab | Utah | 49023 | 7 | 0 |
109263 | 109263 | 2020-05-02 | Juab | Utah | 49023 | 7 | 0 |
112137 | 112137 | 2020-05-03 | Juab | Utah | 49023 | 7 | 0 |
115020 | 115020 | 2020-05-04 | Juab | Utah | 49023 | 7 | 0 |
117979 | 117979 | 2020-05-05 | Juab | Utah | 49023 | 7 | 0 |
120943 | 120943 | 2020-05-06 | Juab | Utah | 49023 | 7 | 0 |
123923 | 123923 | 2020-05-07 | Juab | Utah | 49023 | 7 | 0 |
126908 | 126908 | 2020-05-08 | Juab | Utah | 49023 | 7 | 0 |
129897 | 129897 | 2020-05-09 | Juab | Utah | 49023 | 8 | 0 |
132887 | 132887 | 2020-05-10 | Juab | Utah | 49023 | 8 | 0 |
135878 | 135878 | 2020-05-11 | Juab | Utah | 49023 | 8 | 0 |
138868 | 138868 | 2020-05-12 | Juab | Utah | 49023 | 8 | 0 |
141864 | 141864 | 2020-05-13 | Juab | Utah | 49023 | 8 | 0 |
144861 | 144861 | 2020-05-14 | Juab | Utah | 49023 | 8 | 0 |
147865 | 147865 | 2020-05-15 | Juab | Utah | 49023 | 8 | 0 |
150873 | 150873 | 2020-05-16 | Juab | Utah | 49023 | 8 | 0 |
153884 | 153884 | 2020-05-17 | Juab | Utah | 49023 | 8 | 0 |
156901 | 156901 | 2020-05-18 | Juab | Utah | 49023 | 8 | 0 |
159925 | 159925 | 2020-05-19 | Juab | Utah | 49023 | 8 | 0 |
162953 | 162953 | 2020-05-20 | Juab | Utah | 49023 | 9 | 0 |
165982 | 165982 | 2020-05-21 | Juab | Utah | 49023 | 10 | 0 |
169018 | 169018 | 2020-05-22 | Juab | Utah | 49023 | 10 | 0 |
172059 | 172059 | 2020-05-23 | Juab | Utah | 49023 | 10 | 0 |
175102 | 175102 | 2020-05-24 | Juab | Utah | 49023 | 10 | 0 |
178147 | 178147 | 2020-05-25 | Juab | Utah | 49023 | 10 | 0 |
181191 | 181191 | 2020-05-26 | Juab | Utah | 49023 | 10 | 0 |
184242 | 184242 | 2020-05-27 | Juab | Utah | 49023 | 10 | 0 |
187299 | 187299 | 2020-05-28 | Juab | Utah | 49023 | 10 | 0 |
190363 | 190363 | 2020-05-29 | Juab | Utah | 49023 | 10 | 0 |
193429 | 193429 | 2020-05-30 | Juab | Utah | 49023 | 10 | 0 |
196499 | 196499 | 2020-05-31 | Juab | Utah | 49023 | 10 | 0 |
199572 | 199572 | 2020-06-01 | Juab | Utah | 49023 | 10 | 0 |
202648 | 202648 | 2020-06-02 | Juab | Utah | 49023 | 10 | 0 |
205727 | 205727 | 2020-06-03 | Juab | Utah | 49023 | 10 | 0 |
208809 | 208809 | 2020-06-04 | Juab | Utah | 49023 | 11 | 0 |
211894 | 211894 | 2020-06-05 | Juab | Utah | 49023 | 11 | 0 |
214981 | 214981 | 2020-06-06 | Juab | Utah | 49023 | 11 | 0 |
218071 | 218071 | 2020-06-07 | Juab | Utah | 49023 | 11 | 0 |
221163 | 221163 | 2020-06-08 | Juab | Utah | 49023 | 11 | 0 |
224259 | 224259 | 2020-06-09 | Juab | Utah | 49023 | 11 | 0 |
227359 | 227359 | 2020-06-10 | Juab | Utah | 49023 | 12 | 0 |
230463 | 230463 | 2020-06-11 | Juab | Utah | 49023 | 12 | 0 |
233567 | 233567 | 2020-06-12 | Juab | Utah | 49023 | 11 | 0 |
236674 | 236674 | 2020-06-13 | Juab | Utah | 49023 | 11 | 0 |
239782 | 239782 | 2020-06-14 | Juab | Utah | 49023 | 11 | 0 |
242893 | 242893 | 2020-06-15 | Juab | Utah | 49023 | 11 | 0 |
246005 | 246005 | 2020-06-16 | Juab | Utah | 49023 | 12 | 0 |
249118 | 249118 | 2020-06-17 | Juab | Utah | 49023 | 13 | 0 |
252233 | 252233 | 2020-06-18 | Juab | Utah | 49023 | 13 | 0 |
255350 | 255350 | 2020-06-19 | Juab | Utah | 49023 | 14 | 0 |
258477 | 258477 | 2020-06-20 | Juab | Utah | 49023 | 15 | 0 |
261604 | 261604 | 2020-06-21 | Juab | Utah | 49023 | 15 | 0 |
264733 | 264733 | 2020-06-22 | Juab | Utah | 49023 | 15 | 0 |
267862 | 267862 | 2020-06-23 | Juab | Utah | 49023 | 15 | 0 |
270996 | 270996 | 2020-06-24 | Juab | Utah | 49023 | 15 | 0 |
274136 | 274136 | 2020-06-25 | Juab | Utah | 49023 | 15 | 0 |
277284 | 277284 | 2020-06-26 | Juab | Utah | 49023 | 15 | 0 |
280432 | 280432 | 2020-06-27 | Juab | Utah | 49023 | 15 | 0 |
283578 | 283578 | 2020-06-28 | Juab | Utah | 49023 | 17 | 0 |
286724 | 286724 | 2020-06-29 | Juab | Utah | 49023 | 17 | 0 |
289874 | 289874 | 2020-06-30 | Juab | Utah | 49023 | 18 | 0 |
293027 | 293027 | 2020-07-01 | Juab | Utah | 49023 | 21 | 0 |
296182 | 296182 | 2020-07-02 | Juab | Utah | 49023 | 21 | 0 |
299344 | 299344 | 2020-07-03 | Juab | Utah | 49023 | 21 | 0 |
302508 | 302508 | 2020-07-04 | Juab | Utah | 49023 | 21 | 0 |
305672 | 305672 | 2020-07-05 | Juab | Utah | 49023 | 21 | 0 |
308840 | 308840 | 2020-07-06 | Juab | Utah | 49023 | 26 | 0 |
312009 | 312009 | 2020-07-07 | Juab | Utah | 49023 | 26 | 0 |
315183 | 315183 | 2020-07-08 | Juab | Utah | 49023 | 31 | 0 |
318356 | 318356 | 2020-07-09 | Juab | Utah | 49023 | 31 | 0 |
321535 | 321535 | 2020-07-10 | Juab | Utah | 49023 | 34 | 0 |
324716 | 324716 | 2020-07-11 | Juab | Utah | 49023 | 34 | 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);