ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where cases = 8 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
628052 | 628052 | 2020-10-13 | Wayne | Utah | 49055 | 8 | 0 |
582651 | 582651 | 2020-09-29 | Piute | Utah | 49031 | 8 | 0 |
433883 | 433883 | 2020-08-14 | Rich | Utah | 49033 | 8 | 0 |
430658 | 430658 | 2020-08-13 | Rich | Utah | 49033 | 8 | 0 |
427430 | 427430 | 2020-08-12 | Rich | Utah | 49033 | 8 | 0 |
424206 | 424206 | 2020-08-11 | Rich | Utah | 49033 | 8 | 0 |
286714 | 286714 | 2020-06-29 | Beaver | Utah | 49001 | 8 | 0 |
283568 | 283568 | 2020-06-28 | Beaver | Utah | 49001 | 8 | 0 |
280422 | 280422 | 2020-06-27 | Beaver | Utah | 49001 | 8 | 0 |
277274 | 277274 | 2020-06-26 | Beaver | Utah | 49001 | 8 | 0 |
258479 | 258479 | 2020-06-20 | Millard | Utah | 49027 | 8 | 0 |
255352 | 255352 | 2020-06-19 | Millard | Utah | 49027 | 8 | 0 |
252235 | 252235 | 2020-06-18 | Millard | Utah | 49027 | 8 | 0 |
249114 | 249114 | 2020-06-17 | Emery | Utah | 49015 | 8 | 0 |
249120 | 249120 | 2020-06-17 | Millard | Utah | 49027 | 8 | 0 |
246001 | 246001 | 2020-06-16 | Emery | Utah | 49015 | 8 | 0 |
246007 | 246007 | 2020-06-16 | Millard | Utah | 49027 | 8 | 0 |
242889 | 242889 | 2020-06-15 | Emery | Utah | 49015 | 8 | 0 |
242895 | 242895 | 2020-06-15 | Millard | Utah | 49027 | 8 | 0 |
199580 | 199580 | 2020-06-01 | Sevier | Utah | 49041 | 8 | 0 |
196507 | 196507 | 2020-05-31 | Sevier | Utah | 49041 | 8 | 0 |
193437 | 193437 | 2020-05-30 | Sevier | Utah | 49041 | 8 | 0 |
190358 | 190358 | 2020-05-29 | Duchesne | Utah | 49013 | 8 | 0 |
190371 | 190371 | 2020-05-29 | Sevier | Utah | 49041 | 8 | 0 |
187294 | 187294 | 2020-05-28 | Duchesne | Utah | 49013 | 8 | 0 |
187307 | 187307 | 2020-05-28 | Sevier | Utah | 49041 | 8 | 0 |
184237 | 184237 | 2020-05-27 | Duchesne | Utah | 49013 | 8 | 0 |
184250 | 184250 | 2020-05-27 | Sevier | Utah | 49041 | 8 | 0 |
181186 | 181186 | 2020-05-26 | Duchesne | Utah | 49013 | 8 | 0 |
181199 | 181199 | 2020-05-26 | Sevier | Utah | 49041 | 8 | 0 |
178140 | 178140 | 2020-05-25 | Carbon | Utah | 49007 | 8 | 0 |
178142 | 178142 | 2020-05-25 | Duchesne | Utah | 49013 | 8 | 0 |
178155 | 178155 | 2020-05-25 | Sevier | Utah | 49041 | 8 | 0 |
175095 | 175095 | 2020-05-24 | Carbon | Utah | 49007 | 8 | 0 |
175097 | 175097 | 2020-05-24 | Duchesne | Utah | 49013 | 8 | 0 |
175110 | 175110 | 2020-05-24 | Sevier | Utah | 49041 | 8 | 0 |
172052 | 172052 | 2020-05-23 | Carbon | Utah | 49007 | 8 | 0 |
172054 | 172054 | 2020-05-23 | Duchesne | Utah | 49013 | 8 | 0 |
172067 | 172067 | 2020-05-23 | Sevier | Utah | 49041 | 8 | 0 |
169011 | 169011 | 2020-05-22 | Carbon | Utah | 49007 | 8 | 0 |
169026 | 169026 | 2020-05-22 | Sevier | Utah | 49041 | 8 | 0 |
165975 | 165975 | 2020-05-21 | Carbon | Utah | 49007 | 8 | 0 |
165990 | 165990 | 2020-05-21 | Sevier | Utah | 49041 | 8 | 0 |
162946 | 162946 | 2020-05-20 | Carbon | Utah | 49007 | 8 | 0 |
162961 | 162961 | 2020-05-20 | Sevier | Utah | 49041 | 8 | 0 |
159918 | 159918 | 2020-05-19 | Carbon | Utah | 49007 | 8 | 0 |
159925 | 159925 | 2020-05-19 | Juab | Utah | 49023 | 8 | 0 |
159933 | 159933 | 2020-05-19 | Sevier | Utah | 49041 | 8 | 0 |
156894 | 156894 | 2020-05-18 | Carbon | Utah | 49007 | 8 | 0 |
156901 | 156901 | 2020-05-18 | Juab | Utah | 49023 | 8 | 0 |
156909 | 156909 | 2020-05-18 | Sevier | Utah | 49041 | 8 | 0 |
153884 | 153884 | 2020-05-17 | Juab | Utah | 49023 | 8 | 0 |
153892 | 153892 | 2020-05-17 | Sevier | Utah | 49041 | 8 | 0 |
153895 | 153895 | 2020-05-17 | Uintah | Utah | 49047 | 8 | 0 |
153896 | 153896 | 2020-05-17 | Unknown | Utah | 8 | 2 | |
150873 | 150873 | 2020-05-16 | Juab | Utah | 49023 | 8 | 0 |
150881 | 150881 | 2020-05-16 | Sevier | Utah | 49041 | 8 | 0 |
150884 | 150884 | 2020-05-16 | Uintah | Utah | 49047 | 8 | 0 |
147858 | 147858 | 2020-05-15 | Carbon | Utah | 49007 | 8 | 0 |
147865 | 147865 | 2020-05-15 | Juab | Utah | 49023 | 8 | 0 |
147873 | 147873 | 2020-05-15 | Sevier | Utah | 49041 | 8 | 0 |
147876 | 147876 | 2020-05-15 | Uintah | Utah | 49047 | 8 | 0 |
144861 | 144861 | 2020-05-14 | Juab | Utah | 49023 | 8 | 0 |
144869 | 144869 | 2020-05-14 | Sevier | Utah | 49041 | 8 | 0 |
144872 | 144872 | 2020-05-14 | Uintah | Utah | 49047 | 8 | 0 |
141864 | 141864 | 2020-05-13 | Juab | Utah | 49023 | 8 | 0 |
141872 | 141872 | 2020-05-13 | Sevier | Utah | 49041 | 8 | 0 |
138868 | 138868 | 2020-05-12 | Juab | Utah | 49023 | 8 | 0 |
138876 | 138876 | 2020-05-12 | Sevier | Utah | 49041 | 8 | 0 |
135878 | 135878 | 2020-05-11 | Juab | Utah | 49023 | 8 | 0 |
135886 | 135886 | 2020-05-11 | Sevier | Utah | 49041 | 8 | 0 |
132887 | 132887 | 2020-05-10 | Juab | Utah | 49023 | 8 | 0 |
132895 | 132895 | 2020-05-10 | Sevier | Utah | 49041 | 8 | 0 |
129897 | 129897 | 2020-05-09 | Juab | Utah | 49023 | 8 | 0 |
129905 | 129905 | 2020-05-09 | Sevier | Utah | 49041 | 8 | 0 |
126903 | 126903 | 2020-05-08 | Duchesne | Utah | 49013 | 8 | 0 |
126916 | 126916 | 2020-05-08 | Sevier | Utah | 49041 | 8 | 0 |
123918 | 123918 | 2020-05-07 | Duchesne | Utah | 49013 | 8 | 0 |
120938 | 120938 | 2020-05-06 | Duchesne | Utah | 49013 | 8 | 0 |
117974 | 117974 | 2020-05-05 | Duchesne | Utah | 49013 | 8 | 0 |
115015 | 115015 | 2020-05-04 | Duchesne | Utah | 49013 | 8 | 0 |
112132 | 112132 | 2020-05-03 | Duchesne | Utah | 49013 | 8 | 0 |
112148 | 112148 | 2020-05-03 | Unknown | Utah | 8 | 2 | |
56138 | 56138 | 2020-04-13 | Unknown | Utah | 8 | 7 | |
53445 | 53445 | 2020-04-12 | San Juan | Utah | 49037 | 8 | 0 |
50770 | 50770 | 2020-04-11 | San Juan | Utah | 49037 | 8 | 0 |
21501 | 21501 | 2020-03-30 | Unknown | Utah | 8 | 3 | |
21504 | 21504 | 2020-03-30 | Washington | Utah | 49053 | 8 | 0 |
19441 | 19441 | 2020-03-29 | Washington | Utah | 49053 | 8 | 0 |
17477 | 17477 | 2020-03-28 | Tooele | Utah | 49045 | 8 | 0 |
17482 | 17482 | 2020-03-28 | Washington | Utah | 49053 | 8 | 0 |
13843 | 13843 | 2020-03-26 | Weber | Utah | 49057 | 8 | 0 |
9352 | 9352 | 2020-03-23 | Weber | Utah | 49057 | 8 | 0 |
8130 | 8130 | 2020-03-22 | Wasatch | Utah | 49051 | 8 | 0 |
5078 | 5078 | 2020-03-19 | Davis | Utah | 49011 | 8 | 0 |
2687 | 2687 | 2020-03-15 | Summit | Utah | 49043 | 8 | 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);