ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
163 rows where cases = 3 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
761051 | 761051 | 2020-11-23 | Daggett | Utah | 49009 | 3 | 0 |
296186 | 296186 | 2020-07-02 | Piute | Utah | 49031 | 3 | 0 |
293031 | 293031 | 2020-07-01 | Piute | Utah | 49031 | 3 | 0 |
289878 | 289878 | 2020-06-30 | Piute | Utah | 49031 | 3 | 0 |
286728 | 286728 | 2020-06-29 | Piute | Utah | 49031 | 3 | 0 |
283582 | 283582 | 2020-06-28 | Piute | Utah | 49031 | 3 | 0 |
277289 | 277289 | 2020-06-26 | Rich | Utah | 49033 | 3 | 0 |
274141 | 274141 | 2020-06-25 | Rich | Utah | 49033 | 3 | 0 |
271001 | 271001 | 2020-06-24 | Rich | Utah | 49033 | 3 | 0 |
267867 | 267867 | 2020-06-23 | Rich | Utah | 49033 | 3 | 0 |
264738 | 264738 | 2020-06-22 | Rich | Utah | 49033 | 3 | 0 |
261609 | 261609 | 2020-06-21 | Rich | Utah | 49033 | 3 | 0 |
258482 | 258482 | 2020-06-20 | Rich | Utah | 49033 | 3 | 0 |
255355 | 255355 | 2020-06-19 | Rich | Utah | 49033 | 3 | 0 |
252238 | 252238 | 2020-06-18 | Rich | Utah | 49033 | 3 | 0 |
218072 | 218072 | 2020-06-07 | Kane | Utah | 49025 | 3 | 0 |
214982 | 214982 | 2020-06-06 | Kane | Utah | 49025 | 3 | 0 |
211895 | 211895 | 2020-06-05 | Kane | Utah | 49025 | 3 | 0 |
208810 | 208810 | 2020-06-04 | Kane | Utah | 49025 | 3 | 0 |
205724 | 205724 | 2020-06-03 | Garfield | Utah | 49017 | 3 | 0 |
205728 | 205728 | 2020-06-03 | Kane | Utah | 49025 | 3 | 0 |
202645 | 202645 | 2020-06-02 | Garfield | Utah | 49017 | 3 | 0 |
202649 | 202649 | 2020-06-02 | Kane | Utah | 49025 | 3 | 0 |
199569 | 199569 | 2020-06-01 | Garfield | Utah | 49017 | 3 | 0 |
199573 | 199573 | 2020-06-01 | Kane | Utah | 49025 | 3 | 0 |
196496 | 196496 | 2020-05-31 | Garfield | Utah | 49017 | 3 | 0 |
196500 | 196500 | 2020-05-31 | Kane | Utah | 49025 | 3 | 0 |
193426 | 193426 | 2020-05-30 | Garfield | Utah | 49017 | 3 | 0 |
193430 | 193430 | 2020-05-30 | Kane | Utah | 49025 | 3 | 0 |
190360 | 190360 | 2020-05-29 | Garfield | Utah | 49017 | 3 | 0 |
190364 | 190364 | 2020-05-29 | Kane | Utah | 49025 | 3 | 0 |
187296 | 187296 | 2020-05-28 | Garfield | Utah | 49017 | 3 | 0 |
187300 | 187300 | 2020-05-28 | Kane | Utah | 49025 | 3 | 0 |
184239 | 184239 | 2020-05-27 | Garfield | Utah | 49017 | 3 | 0 |
184243 | 184243 | 2020-05-27 | Kane | Utah | 49025 | 3 | 0 |
181188 | 181188 | 2020-05-26 | Garfield | Utah | 49017 | 3 | 0 |
181192 | 181192 | 2020-05-26 | Kane | Utah | 49025 | 3 | 0 |
178144 | 178144 | 2020-05-25 | Garfield | Utah | 49017 | 3 | 0 |
178148 | 178148 | 2020-05-25 | Kane | Utah | 49025 | 3 | 0 |
175099 | 175099 | 2020-05-24 | Garfield | Utah | 49017 | 3 | 0 |
175103 | 175103 | 2020-05-24 | Kane | Utah | 49025 | 3 | 0 |
172056 | 172056 | 2020-05-23 | Garfield | Utah | 49017 | 3 | 0 |
172060 | 172060 | 2020-05-23 | Kane | Utah | 49025 | 3 | 0 |
169015 | 169015 | 2020-05-22 | Garfield | Utah | 49017 | 3 | 0 |
169019 | 169019 | 2020-05-22 | Kane | Utah | 49025 | 3 | 0 |
165979 | 165979 | 2020-05-21 | Garfield | Utah | 49017 | 3 | 0 |
165983 | 165983 | 2020-05-21 | Kane | Utah | 49025 | 3 | 0 |
162950 | 162950 | 2020-05-20 | Garfield | Utah | 49017 | 3 | 0 |
162954 | 162954 | 2020-05-20 | Kane | Utah | 49025 | 3 | 0 |
159922 | 159922 | 2020-05-19 | Garfield | Utah | 49017 | 3 | 0 |
159926 | 159926 | 2020-05-19 | Kane | Utah | 49025 | 3 | 0 |
156898 | 156898 | 2020-05-18 | Garfield | Utah | 49017 | 3 | 0 |
156902 | 156902 | 2020-05-18 | Kane | Utah | 49025 | 3 | 0 |
156913 | 156913 | 2020-05-18 | Unknown | Utah | 3 | 2 | |
153881 | 153881 | 2020-05-17 | Garfield | Utah | 49017 | 3 | 0 |
153885 | 153885 | 2020-05-17 | Kane | Utah | 49025 | 3 | 0 |
150870 | 150870 | 2020-05-16 | Garfield | Utah | 49017 | 3 | 0 |
150874 | 150874 | 2020-05-16 | Kane | Utah | 49025 | 3 | 0 |
147862 | 147862 | 2020-05-15 | Garfield | Utah | 49017 | 3 | 0 |
147866 | 147866 | 2020-05-15 | Kane | Utah | 49025 | 3 | 0 |
144858 | 144858 | 2020-05-14 | Garfield | Utah | 49017 | 3 | 0 |
144862 | 144862 | 2020-05-14 | Kane | Utah | 49025 | 3 | 0 |
141861 | 141861 | 2020-05-13 | Garfield | Utah | 49017 | 3 | 0 |
141865 | 141865 | 2020-05-13 | Kane | Utah | 49025 | 3 | 0 |
138865 | 138865 | 2020-05-12 | Garfield | Utah | 49017 | 3 | 0 |
138869 | 138869 | 2020-05-12 | Kane | Utah | 49025 | 3 | 0 |
135875 | 135875 | 2020-05-11 | Garfield | Utah | 49017 | 3 | 0 |
135879 | 135879 | 2020-05-11 | Kane | Utah | 49025 | 3 | 0 |
132884 | 132884 | 2020-05-10 | Garfield | Utah | 49017 | 3 | 0 |
132888 | 132888 | 2020-05-10 | Kane | Utah | 49025 | 3 | 0 |
129894 | 129894 | 2020-05-09 | Garfield | Utah | 49017 | 3 | 0 |
129898 | 129898 | 2020-05-09 | Kane | Utah | 49025 | 3 | 0 |
126905 | 126905 | 2020-05-08 | Garfield | Utah | 49017 | 3 | 0 |
126909 | 126909 | 2020-05-08 | Kane | Utah | 49025 | 3 | 0 |
123920 | 123920 | 2020-05-07 | Garfield | Utah | 49017 | 3 | 0 |
123924 | 123924 | 2020-05-07 | Kane | Utah | 49025 | 3 | 0 |
120940 | 120940 | 2020-05-06 | Garfield | Utah | 49017 | 3 | 0 |
120944 | 120944 | 2020-05-06 | Kane | Utah | 49025 | 3 | 0 |
117976 | 117976 | 2020-05-05 | Garfield | Utah | 49017 | 3 | 0 |
117980 | 117980 | 2020-05-05 | Kane | Utah | 49025 | 3 | 0 |
115017 | 115017 | 2020-05-04 | Garfield | Utah | 49017 | 3 | 0 |
115021 | 115021 | 2020-05-04 | Kane | Utah | 49025 | 3 | 0 |
112134 | 112134 | 2020-05-03 | Garfield | Utah | 49017 | 3 | 0 |
112135 | 112135 | 2020-05-03 | Grand | Utah | 49019 | 3 | 0 |
112138 | 112138 | 2020-05-03 | Kane | Utah | 49025 | 3 | 0 |
109260 | 109260 | 2020-05-02 | Garfield | Utah | 49017 | 3 | 0 |
109261 | 109261 | 2020-05-02 | Grand | Utah | 49019 | 3 | 0 |
109264 | 109264 | 2020-05-02 | Kane | Utah | 49025 | 3 | 0 |
106391 | 106391 | 2020-05-01 | Garfield | Utah | 49017 | 3 | 0 |
106392 | 106392 | 2020-05-01 | Grand | Utah | 49019 | 3 | 0 |
106395 | 106395 | 2020-05-01 | Kane | Utah | 49025 | 3 | 0 |
103527 | 103527 | 2020-04-30 | Garfield | Utah | 49017 | 3 | 0 |
103531 | 103531 | 2020-04-30 | Kane | Utah | 49025 | 3 | 0 |
100672 | 100672 | 2020-04-29 | Garfield | Utah | 49017 | 3 | 0 |
100676 | 100676 | 2020-04-29 | Kane | Utah | 49025 | 3 | 0 |
97822 | 97822 | 2020-04-28 | Garfield | Utah | 49017 | 3 | 0 |
97826 | 97826 | 2020-04-28 | Kane | Utah | 49025 | 3 | 0 |
94980 | 94980 | 2020-04-27 | Garfield | Utah | 49017 | 3 | 0 |
94984 | 94984 | 2020-04-27 | Kane | Utah | 49025 | 3 | 0 |
92155 | 92155 | 2020-04-26 | Kane | Utah | 49025 | 3 | 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);