ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Morgan" and fips = 49029 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13835 | 13835 | 2020-03-26 | Morgan | Utah | 49029 | 2 | 0 |
15600 | 15600 | 2020-03-27 | Morgan | Utah | 49029 | 2 | 0 |
17473 | 17473 | 2020-03-28 | Morgan | Utah | 49029 | 2 | 0 |
19432 | 19432 | 2020-03-29 | Morgan | Utah | 49029 | 2 | 0 |
21495 | 21495 | 2020-03-30 | Morgan | Utah | 49029 | 3 | 0 |
23634 | 23634 | 2020-03-31 | Morgan | Utah | 49029 | 3 | 0 |
25849 | 25849 | 2020-04-01 | Morgan | Utah | 49029 | 3 | 0 |
28138 | 28138 | 2020-04-02 | Morgan | Utah | 49029 | 3 | 0 |
30481 | 30481 | 2020-04-03 | Morgan | Utah | 49029 | 3 | 0 |
32879 | 32879 | 2020-04-04 | Morgan | Utah | 49029 | 3 | 0 |
35317 | 35317 | 2020-04-05 | Morgan | Utah | 49029 | 3 | 0 |
37795 | 37795 | 2020-04-06 | Morgan | Utah | 49029 | 3 | 0 |
40324 | 40324 | 2020-04-07 | Morgan | Utah | 49029 | 3 | 0 |
42892 | 42892 | 2020-04-08 | Morgan | Utah | 49029 | 3 | 0 |
45486 | 45486 | 2020-04-09 | Morgan | Utah | 49029 | 3 | 0 |
48110 | 48110 | 2020-04-10 | Morgan | Utah | 49029 | 3 | 0 |
50768 | 50768 | 2020-04-11 | Morgan | Utah | 49029 | 3 | 0 |
53443 | 53443 | 2020-04-12 | Morgan | Utah | 49029 | 3 | 0 |
56132 | 56132 | 2020-04-13 | Morgan | Utah | 49029 | 3 | 0 |
58838 | 58838 | 2020-04-14 | Morgan | Utah | 49029 | 3 | 0 |
61556 | 61556 | 2020-04-15 | Morgan | Utah | 49029 | 3 | 0 |
64288 | 64288 | 2020-04-16 | Morgan | Utah | 49029 | 7 | 0 |
67036 | 67036 | 2020-04-17 | Morgan | Utah | 49029 | 7 | 0 |
69797 | 69797 | 2020-04-18 | Morgan | Utah | 49029 | 7 | 0 |
72567 | 72567 | 2020-04-19 | Morgan | Utah | 49029 | 7 | 0 |
75343 | 75343 | 2020-04-20 | Morgan | Utah | 49029 | 7 | 0 |
78125 | 78125 | 2020-04-21 | Morgan | Utah | 49029 | 7 | 0 |
80917 | 80917 | 2020-04-22 | Morgan | Utah | 49029 | 9 | 0 |
83718 | 83718 | 2020-04-23 | Morgan | Utah | 49029 | 9 | 0 |
86525 | 86525 | 2020-04-24 | Morgan | Utah | 49029 | 9 | 0 |
89340 | 89340 | 2020-04-25 | Morgan | Utah | 49029 | 9 | 0 |
92157 | 92157 | 2020-04-26 | Morgan | Utah | 49029 | 9 | 0 |
94986 | 94986 | 2020-04-27 | Morgan | Utah | 49029 | 9 | 0 |
97828 | 97828 | 2020-04-28 | Morgan | Utah | 49029 | 9 | 0 |
100678 | 100678 | 2020-04-29 | Morgan | Utah | 49029 | 9 | 0 |
103533 | 103533 | 2020-04-30 | Morgan | Utah | 49029 | 9 | 0 |
106397 | 106397 | 2020-05-01 | Morgan | Utah | 49029 | 9 | 0 |
109266 | 109266 | 2020-05-02 | Morgan | Utah | 49029 | 9 | 0 |
112140 | 112140 | 2020-05-03 | Morgan | Utah | 49029 | 9 | 0 |
115023 | 115023 | 2020-05-04 | Morgan | Utah | 49029 | 9 | 0 |
117982 | 117982 | 2020-05-05 | Morgan | Utah | 49029 | 9 | 0 |
120946 | 120946 | 2020-05-06 | Morgan | Utah | 49029 | 9 | 0 |
123926 | 123926 | 2020-05-07 | Morgan | Utah | 49029 | 9 | 0 |
126911 | 126911 | 2020-05-08 | Morgan | Utah | 49029 | 9 | 0 |
129900 | 129900 | 2020-05-09 | Morgan | Utah | 49029 | 9 | 0 |
132890 | 132890 | 2020-05-10 | Morgan | Utah | 49029 | 10 | 0 |
135881 | 135881 | 2020-05-11 | Morgan | Utah | 49029 | 10 | 0 |
138871 | 138871 | 2020-05-12 | Morgan | Utah | 49029 | 10 | 0 |
141867 | 141867 | 2020-05-13 | Morgan | Utah | 49029 | 10 | 0 |
144864 | 144864 | 2020-05-14 | Morgan | Utah | 49029 | 10 | 0 |
147868 | 147868 | 2020-05-15 | Morgan | Utah | 49029 | 10 | 0 |
150876 | 150876 | 2020-05-16 | Morgan | Utah | 49029 | 10 | 0 |
153887 | 153887 | 2020-05-17 | Morgan | Utah | 49029 | 10 | 0 |
156904 | 156904 | 2020-05-18 | Morgan | Utah | 49029 | 10 | 0 |
159928 | 159928 | 2020-05-19 | Morgan | Utah | 49029 | 10 | 0 |
162956 | 162956 | 2020-05-20 | Morgan | Utah | 49029 | 10 | 0 |
165985 | 165985 | 2020-05-21 | Morgan | Utah | 49029 | 10 | 0 |
169021 | 169021 | 2020-05-22 | Morgan | Utah | 49029 | 10 | 0 |
172062 | 172062 | 2020-05-23 | Morgan | Utah | 49029 | 10 | 0 |
175105 | 175105 | 2020-05-24 | Morgan | Utah | 49029 | 10 | 0 |
178150 | 178150 | 2020-05-25 | Morgan | Utah | 49029 | 10 | 0 |
181194 | 181194 | 2020-05-26 | Morgan | Utah | 49029 | 11 | 0 |
184245 | 184245 | 2020-05-27 | Morgan | Utah | 49029 | 11 | 0 |
187302 | 187302 | 2020-05-28 | Morgan | Utah | 49029 | 11 | 0 |
190366 | 190366 | 2020-05-29 | Morgan | Utah | 49029 | 11 | 0 |
193432 | 193432 | 2020-05-30 | Morgan | Utah | 49029 | 11 | 0 |
196502 | 196502 | 2020-05-31 | Morgan | Utah | 49029 | 11 | 0 |
199575 | 199575 | 2020-06-01 | Morgan | Utah | 49029 | 12 | 0 |
202651 | 202651 | 2020-06-02 | Morgan | Utah | 49029 | 12 | 0 |
205730 | 205730 | 2020-06-03 | Morgan | Utah | 49029 | 12 | 0 |
208812 | 208812 | 2020-06-04 | Morgan | Utah | 49029 | 13 | 0 |
211897 | 211897 | 2020-06-05 | Morgan | Utah | 49029 | 13 | 0 |
214984 | 214984 | 2020-06-06 | Morgan | Utah | 49029 | 13 | 0 |
218074 | 218074 | 2020-06-07 | Morgan | Utah | 49029 | 13 | 0 |
221166 | 221166 | 2020-06-08 | Morgan | Utah | 49029 | 13 | 0 |
224262 | 224262 | 2020-06-09 | Morgan | Utah | 49029 | 14 | 0 |
227362 | 227362 | 2020-06-10 | Morgan | Utah | 49029 | 15 | 0 |
230466 | 230466 | 2020-06-11 | Morgan | Utah | 49029 | 15 | 0 |
233570 | 233570 | 2020-06-12 | Morgan | Utah | 49029 | 16 | 0 |
236677 | 236677 | 2020-06-13 | Morgan | Utah | 49029 | 16 | 0 |
239785 | 239785 | 2020-06-14 | Morgan | Utah | 49029 | 16 | 0 |
242896 | 242896 | 2020-06-15 | Morgan | Utah | 49029 | 16 | 0 |
246008 | 246008 | 2020-06-16 | Morgan | Utah | 49029 | 17 | 0 |
249121 | 249121 | 2020-06-17 | Morgan | Utah | 49029 | 16 | 0 |
252236 | 252236 | 2020-06-18 | Morgan | Utah | 49029 | 17 | 0 |
255353 | 255353 | 2020-06-19 | Morgan | Utah | 49029 | 17 | 0 |
258480 | 258480 | 2020-06-20 | Morgan | Utah | 49029 | 17 | 0 |
261607 | 261607 | 2020-06-21 | Morgan | Utah | 49029 | 18 | 0 |
264736 | 264736 | 2020-06-22 | Morgan | Utah | 49029 | 17 | 0 |
267865 | 267865 | 2020-06-23 | Morgan | Utah | 49029 | 17 | 0 |
270999 | 270999 | 2020-06-24 | Morgan | Utah | 49029 | 17 | 0 |
274139 | 274139 | 2020-06-25 | Morgan | Utah | 49029 | 17 | 0 |
277287 | 277287 | 2020-06-26 | Morgan | Utah | 49029 | 18 | 0 |
280435 | 280435 | 2020-06-27 | Morgan | Utah | 49029 | 18 | 0 |
283581 | 283581 | 2020-06-28 | Morgan | Utah | 49029 | 18 | 0 |
286727 | 286727 | 2020-06-29 | Morgan | Utah | 49029 | 19 | 0 |
289877 | 289877 | 2020-06-30 | Morgan | Utah | 49029 | 22 | 0 |
293030 | 293030 | 2020-07-01 | Morgan | Utah | 49029 | 22 | 0 |
296185 | 296185 | 2020-07-02 | Morgan | Utah | 49029 | 23 | 0 |
299347 | 299347 | 2020-07-03 | Morgan | Utah | 49029 | 24 | 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);