ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Morgan" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388799 | 388799 | 2020-07-31 | Morgan | Utah | 49029 | 43 | 0 |
385582 | 385582 | 2020-07-30 | Morgan | Utah | 49029 | 42 | 0 |
382364 | 382364 | 2020-07-29 | Morgan | Utah | 49029 | 42 | 0 |
379147 | 379147 | 2020-07-28 | Morgan | Utah | 49029 | 42 | 0 |
375931 | 375931 | 2020-07-27 | Morgan | Utah | 49029 | 42 | 0 |
372718 | 372718 | 2020-07-26 | Morgan | Utah | 49029 | 41 | 0 |
369506 | 369506 | 2020-07-25 | Morgan | Utah | 49029 | 41 | 0 |
366297 | 366297 | 2020-07-24 | Morgan | Utah | 49029 | 41 | 0 |
363091 | 363091 | 2020-07-23 | Morgan | Utah | 49029 | 41 | 0 |
359884 | 359884 | 2020-07-22 | Morgan | Utah | 49029 | 41 | 0 |
356679 | 356679 | 2020-07-21 | Morgan | Utah | 49029 | 41 | 0 |
353476 | 353476 | 2020-07-20 | Morgan | Utah | 49029 | 40 | 0 |
350274 | 350274 | 2020-07-19 | Morgan | Utah | 49029 | 39 | 0 |
347074 | 347074 | 2020-07-18 | Morgan | Utah | 49029 | 36 | 0 |
343873 | 343873 | 2020-07-17 | Morgan | Utah | 49029 | 36 | 0 |
340674 | 340674 | 2020-07-16 | Morgan | Utah | 49029 | 34 | 0 |
337478 | 337478 | 2020-07-15 | Morgan | Utah | 49029 | 34 | 0 |
334283 | 334283 | 2020-07-14 | Morgan | Utah | 49029 | 33 | 0 |
331090 | 331090 | 2020-07-13 | Morgan | Utah | 49029 | 32 | 0 |
327904 | 327904 | 2020-07-12 | Morgan | Utah | 49029 | 30 | 0 |
324719 | 324719 | 2020-07-11 | Morgan | Utah | 49029 | 30 | 0 |
321538 | 321538 | 2020-07-10 | Morgan | Utah | 49029 | 28 | 0 |
318359 | 318359 | 2020-07-09 | Morgan | Utah | 49029 | 26 | 0 |
315186 | 315186 | 2020-07-08 | Morgan | Utah | 49029 | 26 | 0 |
312012 | 312012 | 2020-07-07 | Morgan | Utah | 49029 | 25 | 0 |
308843 | 308843 | 2020-07-06 | Morgan | Utah | 49029 | 25 | 0 |
305675 | 305675 | 2020-07-05 | Morgan | Utah | 49029 | 24 | 0 |
302511 | 302511 | 2020-07-04 | Morgan | Utah | 49029 | 24 | 0 |
299347 | 299347 | 2020-07-03 | Morgan | Utah | 49029 | 24 | 0 |
296185 | 296185 | 2020-07-02 | Morgan | Utah | 49029 | 23 | 0 |
293030 | 293030 | 2020-07-01 | Morgan | Utah | 49029 | 22 | 0 |
289877 | 289877 | 2020-06-30 | Morgan | Utah | 49029 | 22 | 0 |
286727 | 286727 | 2020-06-29 | Morgan | Utah | 49029 | 19 | 0 |
283581 | 283581 | 2020-06-28 | Morgan | Utah | 49029 | 18 | 0 |
280435 | 280435 | 2020-06-27 | Morgan | Utah | 49029 | 18 | 0 |
277287 | 277287 | 2020-06-26 | Morgan | Utah | 49029 | 18 | 0 |
274139 | 274139 | 2020-06-25 | Morgan | Utah | 49029 | 17 | 0 |
270999 | 270999 | 2020-06-24 | Morgan | Utah | 49029 | 17 | 0 |
267865 | 267865 | 2020-06-23 | Morgan | Utah | 49029 | 17 | 0 |
264736 | 264736 | 2020-06-22 | Morgan | Utah | 49029 | 17 | 0 |
261607 | 261607 | 2020-06-21 | Morgan | Utah | 49029 | 18 | 0 |
258480 | 258480 | 2020-06-20 | Morgan | Utah | 49029 | 17 | 0 |
255353 | 255353 | 2020-06-19 | Morgan | Utah | 49029 | 17 | 0 |
252236 | 252236 | 2020-06-18 | Morgan | Utah | 49029 | 17 | 0 |
249121 | 249121 | 2020-06-17 | Morgan | Utah | 49029 | 16 | 0 |
246008 | 246008 | 2020-06-16 | Morgan | Utah | 49029 | 17 | 0 |
242896 | 242896 | 2020-06-15 | Morgan | Utah | 49029 | 16 | 0 |
239785 | 239785 | 2020-06-14 | Morgan | Utah | 49029 | 16 | 0 |
236677 | 236677 | 2020-06-13 | Morgan | Utah | 49029 | 16 | 0 |
233570 | 233570 | 2020-06-12 | Morgan | Utah | 49029 | 16 | 0 |
230466 | 230466 | 2020-06-11 | Morgan | Utah | 49029 | 15 | 0 |
227362 | 227362 | 2020-06-10 | Morgan | Utah | 49029 | 15 | 0 |
224262 | 224262 | 2020-06-09 | Morgan | Utah | 49029 | 14 | 0 |
221166 | 221166 | 2020-06-08 | Morgan | Utah | 49029 | 13 | 0 |
218074 | 218074 | 2020-06-07 | Morgan | Utah | 49029 | 13 | 0 |
214984 | 214984 | 2020-06-06 | Morgan | Utah | 49029 | 13 | 0 |
211897 | 211897 | 2020-06-05 | Morgan | Utah | 49029 | 13 | 0 |
208812 | 208812 | 2020-06-04 | Morgan | Utah | 49029 | 13 | 0 |
205730 | 205730 | 2020-06-03 | Morgan | Utah | 49029 | 12 | 0 |
202651 | 202651 | 2020-06-02 | Morgan | Utah | 49029 | 12 | 0 |
199575 | 199575 | 2020-06-01 | Morgan | Utah | 49029 | 12 | 0 |
196502 | 196502 | 2020-05-31 | Morgan | Utah | 49029 | 11 | 0 |
193432 | 193432 | 2020-05-30 | Morgan | Utah | 49029 | 11 | 0 |
190366 | 190366 | 2020-05-29 | Morgan | Utah | 49029 | 11 | 0 |
187302 | 187302 | 2020-05-28 | Morgan | Utah | 49029 | 11 | 0 |
184245 | 184245 | 2020-05-27 | Morgan | Utah | 49029 | 11 | 0 |
181194 | 181194 | 2020-05-26 | Morgan | Utah | 49029 | 11 | 0 |
178150 | 178150 | 2020-05-25 | Morgan | Utah | 49029 | 10 | 0 |
175105 | 175105 | 2020-05-24 | Morgan | Utah | 49029 | 10 | 0 |
172062 | 172062 | 2020-05-23 | Morgan | Utah | 49029 | 10 | 0 |
169021 | 169021 | 2020-05-22 | Morgan | Utah | 49029 | 10 | 0 |
165985 | 165985 | 2020-05-21 | Morgan | Utah | 49029 | 10 | 0 |
162956 | 162956 | 2020-05-20 | Morgan | Utah | 49029 | 10 | 0 |
159928 | 159928 | 2020-05-19 | Morgan | Utah | 49029 | 10 | 0 |
156904 | 156904 | 2020-05-18 | Morgan | Utah | 49029 | 10 | 0 |
153887 | 153887 | 2020-05-17 | Morgan | Utah | 49029 | 10 | 0 |
150876 | 150876 | 2020-05-16 | Morgan | Utah | 49029 | 10 | 0 |
147868 | 147868 | 2020-05-15 | Morgan | Utah | 49029 | 10 | 0 |
144864 | 144864 | 2020-05-14 | Morgan | Utah | 49029 | 10 | 0 |
141867 | 141867 | 2020-05-13 | Morgan | Utah | 49029 | 10 | 0 |
138871 | 138871 | 2020-05-12 | Morgan | Utah | 49029 | 10 | 0 |
135881 | 135881 | 2020-05-11 | Morgan | Utah | 49029 | 10 | 0 |
132890 | 132890 | 2020-05-10 | Morgan | Utah | 49029 | 10 | 0 |
129900 | 129900 | 2020-05-09 | Morgan | Utah | 49029 | 9 | 0 |
126911 | 126911 | 2020-05-08 | Morgan | Utah | 49029 | 9 | 0 |
123926 | 123926 | 2020-05-07 | Morgan | Utah | 49029 | 9 | 0 |
120946 | 120946 | 2020-05-06 | Morgan | Utah | 49029 | 9 | 0 |
117982 | 117982 | 2020-05-05 | Morgan | Utah | 49029 | 9 | 0 |
115023 | 115023 | 2020-05-04 | Morgan | Utah | 49029 | 9 | 0 |
112140 | 112140 | 2020-05-03 | Morgan | Utah | 49029 | 9 | 0 |
109266 | 109266 | 2020-05-02 | Morgan | Utah | 49029 | 9 | 0 |
106397 | 106397 | 2020-05-01 | Morgan | Utah | 49029 | 9 | 0 |
103533 | 103533 | 2020-04-30 | Morgan | Utah | 49029 | 9 | 0 |
100678 | 100678 | 2020-04-29 | Morgan | Utah | 49029 | 9 | 0 |
97828 | 97828 | 2020-04-28 | Morgan | Utah | 49029 | 9 | 0 |
94986 | 94986 | 2020-04-27 | Morgan | Utah | 49029 | 9 | 0 |
92157 | 92157 | 2020-04-26 | Morgan | Utah | 49029 | 9 | 0 |
89340 | 89340 | 2020-04-25 | Morgan | Utah | 49029 | 9 | 0 |
86525 | 86525 | 2020-04-24 | Morgan | Utah | 49029 | 9 | 0 |
83718 | 83718 | 2020-04-23 | Morgan | Utah | 49029 | 9 | 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);