ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Unknown" and state = "Utah" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12203 | 12203 | 2020-03-25 | Unknown | Utah | 10 | 0 | |
13839 | 13839 | 2020-03-26 | Unknown | Utah | 5 | 0 | |
15605 | 15605 | 2020-03-27 | Unknown | Utah | 17 | 1 | |
17479 | 17479 | 2020-03-28 | Unknown | Utah | 17 | 1 | |
19438 | 19438 | 2020-03-29 | Unknown | Utah | 1 | 1 | |
21501 | 21501 | 2020-03-30 | Unknown | Utah | 8 | 3 | |
23640 | 23640 | 2020-03-31 | Unknown | Utah | 19 | 3 | |
25855 | 25855 | 2020-04-01 | Unknown | Utah | 37 | 4 | |
28144 | 28144 | 2020-04-02 | Unknown | Utah | 16 | 4 | |
30487 | 30487 | 2020-04-03 | Unknown | Utah | 0 | 3 | |
32885 | 32885 | 2020-04-04 | Unknown | Utah | 0 | 4 | |
35323 | 35323 | 2020-04-05 | Unknown | Utah | 14 | 4 | |
37801 | 37801 | 2020-04-06 | Unknown | Utah | 23 | 9 | |
40330 | 40330 | 2020-04-07 | Unknown | Utah | 0 | 9 | |
42898 | 42898 | 2020-04-08 | Unknown | Utah | 0 | 3 | |
45492 | 45492 | 2020-04-09 | Unknown | Utah | 0 | 3 | |
48116 | 48116 | 2020-04-10 | Unknown | Utah | 0 | 7 | |
50774 | 50774 | 2020-04-11 | Unknown | Utah | 7 | 7 | |
53449 | 53449 | 2020-04-12 | Unknown | Utah | 6 | 7 | |
56138 | 56138 | 2020-04-13 | Unknown | Utah | 8 | 7 | |
58844 | 58844 | 2020-04-14 | Unknown | Utah | 0 | 8 | |
61563 | 61563 | 2020-04-15 | Unknown | Utah | 0 | 9 | |
64295 | 64295 | 2020-04-16 | Unknown | Utah | 3 | 1 | |
67043 | 67043 | 2020-04-17 | Unknown | Utah | 2 | 1 | |
69805 | 69805 | 2020-04-18 | Unknown | Utah | 0 | 1 | |
72575 | 72575 | 2020-04-19 | Unknown | Utah | 0 | 1 | |
75351 | 75351 | 2020-04-20 | Unknown | Utah | 0 | 1 | |
78133 | 78133 | 2020-04-21 | Unknown | Utah | 0 | 2 | |
80925 | 80925 | 2020-04-22 | Unknown | Utah | 0 | 2 | |
83726 | 83726 | 2020-04-23 | Unknown | Utah | 0 | 1 | |
86533 | 86533 | 2020-04-24 | Unknown | Utah | 1 | 1 | |
89348 | 89348 | 2020-04-25 | Unknown | Utah | 0 | 1 | |
92165 | 92165 | 2020-04-26 | Unknown | Utah | 0 | 1 | |
94994 | 94994 | 2020-04-27 | Unknown | Utah | 0 | 2 | |
97836 | 97836 | 2020-04-28 | Unknown | Utah | 0 | 2 | |
100686 | 100686 | 2020-04-29 | Unknown | Utah | 0 | 2 | |
103541 | 103541 | 2020-04-30 | Unknown | Utah | 11 | 2 | |
106405 | 106405 | 2020-05-01 | Unknown | Utah | 0 | 1 | |
109274 | 109274 | 2020-05-02 | Unknown | Utah | 0 | 2 | |
112148 | 112148 | 2020-05-03 | Unknown | Utah | 8 | 2 | |
115031 | 115031 | 2020-05-04 | Unknown | Utah | 0 | 2 | |
117990 | 117990 | 2020-05-05 | Unknown | Utah | 0 | 3 | |
120954 | 120954 | 2020-05-06 | Unknown | Utah | 0 | 3 | |
123935 | 123935 | 2020-05-07 | Unknown | Utah | 1 | 3 | |
126920 | 126920 | 2020-05-08 | Unknown | Utah | 2 | 3 | |
129909 | 129909 | 2020-05-09 | Unknown | Utah | 17 | 2 | |
132899 | 132899 | 2020-05-10 | Unknown | Utah | 11 | 3 | |
138880 | 138880 | 2020-05-12 | Unknown | Utah | 0 | 2 | |
141876 | 141876 | 2020-05-13 | Unknown | Utah | 0 | 3 | |
144873 | 144873 | 2020-05-14 | Unknown | Utah | 0 | 3 | |
150885 | 150885 | 2020-05-16 | Unknown | Utah | 1 | 1 | |
153896 | 153896 | 2020-05-17 | Unknown | Utah | 8 | 2 | |
156913 | 156913 | 2020-05-18 | Unknown | Utah | 3 | 2 | |
159937 | 159937 | 2020-05-19 | Unknown | Utah | 0 | 3 | |
162965 | 162965 | 2020-05-20 | Unknown | Utah | 0 | 4 | |
165994 | 165994 | 2020-05-21 | Unknown | Utah | 0 | 3 | |
169030 | 169030 | 2020-05-22 | Unknown | Utah | 0 | 4 | |
172071 | 172071 | 2020-05-23 | Unknown | Utah | 5 | 4 | |
175114 | 175114 | 2020-05-24 | Unknown | Utah | 22 | 4 | |
178159 | 178159 | 2020-05-25 | Unknown | Utah | 14 | 3 | |
181203 | 181203 | 2020-05-26 | Unknown | Utah | 0 | 3 | |
184254 | 184254 | 2020-05-27 | Unknown | Utah | 0 | 4 | |
187311 | 187311 | 2020-05-28 | Unknown | Utah | 0 | 3 | |
190375 | 190375 | 2020-05-29 | Unknown | Utah | 0 | 3 | |
193441 | 193441 | 2020-05-30 | Unknown | Utah | 0 | 5 | |
196511 | 196511 | 2020-05-31 | Unknown | Utah | 0 | 4 | |
199584 | 199584 | 2020-06-01 | Unknown | Utah | 0 | 4 | |
202660 | 202660 | 2020-06-02 | Unknown | Utah | 0 | 4 | |
205739 | 205739 | 2020-06-03 | Unknown | Utah | 0 | 4 | |
208821 | 208821 | 2020-06-04 | Unknown | Utah | 0 | 4 | |
211906 | 211906 | 2020-06-05 | Unknown | Utah | 0 | 3 | |
214993 | 214993 | 2020-06-06 | Unknown | Utah | 0 | 4 | |
218083 | 218083 | 2020-06-07 | Unknown | Utah | 0 | 4 | |
221175 | 221175 | 2020-06-08 | Unknown | Utah | 0 | 4 | |
224271 | 224271 | 2020-06-09 | Unknown | Utah | 0 | 4 | |
227371 | 227371 | 2020-06-10 | Unknown | Utah | 0 | 4 | |
230475 | 230475 | 2020-06-11 | Unknown | Utah | 0 | 4 | |
233580 | 233580 | 2020-06-12 | Unknown | Utah | 0 | 5 | |
236687 | 236687 | 2020-06-13 | Unknown | Utah | 0 | 5 | |
239795 | 239795 | 2020-06-14 | Unknown | Utah | 24 | 5 | |
242906 | 242906 | 2020-06-15 | Unknown | Utah | 0 | 6 | |
246018 | 246018 | 2020-06-16 | Unknown | Utah | 0 | 7 | |
255363 | 255363 | 2020-06-19 | Unknown | Utah | 0 | 9 | |
258490 | 258490 | 2020-06-20 | Unknown | Utah | 0 | 9 | |
261617 | 261617 | 2020-06-21 | Unknown | Utah | 0 | 10 | |
264746 | 264746 | 2020-06-22 | Unknown | Utah | 0 | 9 | |
267875 | 267875 | 2020-06-23 | Unknown | Utah | 0 | 10 | |
271009 | 271009 | 2020-06-24 | Unknown | Utah | 0 | 10 | |
274149 | 274149 | 2020-06-25 | Unknown | Utah | 0 | 10 | |
277297 | 277297 | 2020-06-26 | Unknown | Utah | 0 | 11 | |
280445 | 280445 | 2020-06-27 | Unknown | Utah | 0 | 11 | |
283591 | 283591 | 2020-06-28 | Unknown | Utah | 0 | 11 | |
286737 | 286737 | 2020-06-29 | Unknown | Utah | 0 | 9 | |
289887 | 289887 | 2020-06-30 | Unknown | Utah | 0 | 11 | |
293040 | 293040 | 2020-07-01 | Unknown | Utah | 0 | 10 | |
296195 | 296195 | 2020-07-02 | Unknown | Utah | 0 | 10 | |
299357 | 299357 | 2020-07-03 | Unknown | Utah | 0 | 12 | |
302521 | 302521 | 2020-07-04 | Unknown | Utah | 0 | 12 | |
305685 | 305685 | 2020-07-05 | Unknown | Utah | 0 | 13 | |
308853 | 308853 | 2020-07-06 | Unknown | Utah | 0 | 13 |
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);