ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Garfield" 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 |
---|---|---|---|---|---|---|---|
17471 | 17471 | 2020-03-28 | Garfield | Utah | 49017 | 1 | 0 |
19430 | 19430 | 2020-03-29 | Garfield | Utah | 49017 | 1 | 0 |
21493 | 21493 | 2020-03-30 | Garfield | Utah | 49017 | 1 | 0 |
23632 | 23632 | 2020-03-31 | Garfield | Utah | 49017 | 1 | 0 |
25847 | 25847 | 2020-04-01 | Garfield | Utah | 49017 | 1 | 0 |
28135 | 28135 | 2020-04-02 | Garfield | Utah | 49017 | 1 | 0 |
30475 | 30475 | 2020-04-03 | Garfield | Utah | 49017 | 1 | 0 |
32873 | 32873 | 2020-04-04 | Garfield | Utah | 49017 | 1 | 0 |
35311 | 35311 | 2020-04-05 | Garfield | Utah | 49017 | 1 | 0 |
37789 | 37789 | 2020-04-06 | Garfield | Utah | 49017 | 1 | 0 |
40318 | 40318 | 2020-04-07 | Garfield | Utah | 49017 | 1 | 0 |
42886 | 42886 | 2020-04-08 | Garfield | Utah | 49017 | 1 | 0 |
45480 | 45480 | 2020-04-09 | Garfield | Utah | 49017 | 1 | 0 |
48104 | 48104 | 2020-04-10 | Garfield | Utah | 49017 | 1 | 0 |
50762 | 50762 | 2020-04-11 | Garfield | Utah | 49017 | 1 | 0 |
53437 | 53437 | 2020-04-12 | Garfield | Utah | 49017 | 1 | 0 |
56126 | 56126 | 2020-04-13 | Garfield | Utah | 49017 | 1 | 0 |
58832 | 58832 | 2020-04-14 | Garfield | Utah | 49017 | 1 | 0 |
61550 | 61550 | 2020-04-15 | Garfield | Utah | 49017 | 1 | 0 |
64282 | 64282 | 2020-04-16 | Garfield | Utah | 49017 | 1 | 0 |
67030 | 67030 | 2020-04-17 | Garfield | Utah | 49017 | 1 | 0 |
69791 | 69791 | 2020-04-18 | Garfield | Utah | 49017 | 1 | 0 |
72561 | 72561 | 2020-04-19 | Garfield | Utah | 49017 | 1 | 0 |
75337 | 75337 | 2020-04-20 | Garfield | Utah | 49017 | 1 | 0 |
78119 | 78119 | 2020-04-21 | Garfield | Utah | 49017 | 1 | 0 |
80911 | 80911 | 2020-04-22 | Garfield | Utah | 49017 | 1 | 0 |
83712 | 83712 | 2020-04-23 | Garfield | Utah | 49017 | 1 | 0 |
86519 | 86519 | 2020-04-24 | Garfield | Utah | 49017 | 1 | 0 |
89334 | 89334 | 2020-04-25 | Garfield | Utah | 49017 | 1 | 0 |
92151 | 92151 | 2020-04-26 | Garfield | Utah | 49017 | 1 | 0 |
94980 | 94980 | 2020-04-27 | Garfield | Utah | 49017 | 3 | 0 |
97822 | 97822 | 2020-04-28 | Garfield | Utah | 49017 | 3 | 0 |
100672 | 100672 | 2020-04-29 | Garfield | Utah | 49017 | 3 | 0 |
103527 | 103527 | 2020-04-30 | Garfield | Utah | 49017 | 3 | 0 |
106391 | 106391 | 2020-05-01 | Garfield | Utah | 49017 | 3 | 0 |
109260 | 109260 | 2020-05-02 | Garfield | Utah | 49017 | 3 | 0 |
112134 | 112134 | 2020-05-03 | Garfield | Utah | 49017 | 3 | 0 |
115017 | 115017 | 2020-05-04 | Garfield | Utah | 49017 | 3 | 0 |
117976 | 117976 | 2020-05-05 | Garfield | Utah | 49017 | 3 | 0 |
120940 | 120940 | 2020-05-06 | Garfield | Utah | 49017 | 3 | 0 |
123920 | 123920 | 2020-05-07 | Garfield | Utah | 49017 | 3 | 0 |
126905 | 126905 | 2020-05-08 | Garfield | Utah | 49017 | 3 | 0 |
129894 | 129894 | 2020-05-09 | Garfield | Utah | 49017 | 3 | 0 |
132884 | 132884 | 2020-05-10 | Garfield | Utah | 49017 | 3 | 0 |
135875 | 135875 | 2020-05-11 | Garfield | Utah | 49017 | 3 | 0 |
138865 | 138865 | 2020-05-12 | Garfield | Utah | 49017 | 3 | 0 |
141861 | 141861 | 2020-05-13 | Garfield | Utah | 49017 | 3 | 0 |
144858 | 144858 | 2020-05-14 | Garfield | Utah | 49017 | 3 | 0 |
147862 | 147862 | 2020-05-15 | Garfield | Utah | 49017 | 3 | 0 |
150870 | 150870 | 2020-05-16 | Garfield | Utah | 49017 | 3 | 0 |
153881 | 153881 | 2020-05-17 | Garfield | Utah | 49017 | 3 | 0 |
156898 | 156898 | 2020-05-18 | Garfield | Utah | 49017 | 3 | 0 |
159922 | 159922 | 2020-05-19 | Garfield | Utah | 49017 | 3 | 0 |
162950 | 162950 | 2020-05-20 | Garfield | Utah | 49017 | 3 | 0 |
165979 | 165979 | 2020-05-21 | Garfield | Utah | 49017 | 3 | 0 |
169015 | 169015 | 2020-05-22 | Garfield | Utah | 49017 | 3 | 0 |
172056 | 172056 | 2020-05-23 | Garfield | Utah | 49017 | 3 | 0 |
175099 | 175099 | 2020-05-24 | Garfield | Utah | 49017 | 3 | 0 |
178144 | 178144 | 2020-05-25 | Garfield | Utah | 49017 | 3 | 0 |
181188 | 181188 | 2020-05-26 | Garfield | Utah | 49017 | 3 | 0 |
184239 | 184239 | 2020-05-27 | Garfield | Utah | 49017 | 3 | 0 |
187296 | 187296 | 2020-05-28 | Garfield | Utah | 49017 | 3 | 0 |
190360 | 190360 | 2020-05-29 | Garfield | Utah | 49017 | 3 | 0 |
193426 | 193426 | 2020-05-30 | Garfield | Utah | 49017 | 3 | 0 |
196496 | 196496 | 2020-05-31 | Garfield | Utah | 49017 | 3 | 0 |
199569 | 199569 | 2020-06-01 | Garfield | Utah | 49017 | 3 | 0 |
202645 | 202645 | 2020-06-02 | Garfield | Utah | 49017 | 3 | 0 |
205724 | 205724 | 2020-06-03 | Garfield | Utah | 49017 | 3 | 0 |
208806 | 208806 | 2020-06-04 | Garfield | Utah | 49017 | 4 | 0 |
211891 | 211891 | 2020-06-05 | Garfield | Utah | 49017 | 4 | 0 |
214978 | 214978 | 2020-06-06 | Garfield | Utah | 49017 | 4 | 0 |
218068 | 218068 | 2020-06-07 | Garfield | Utah | 49017 | 4 | 0 |
221160 | 221160 | 2020-06-08 | Garfield | Utah | 49017 | 4 | 0 |
224256 | 224256 | 2020-06-09 | Garfield | Utah | 49017 | 4 | 0 |
227356 | 227356 | 2020-06-10 | Garfield | Utah | 49017 | 4 | 0 |
230460 | 230460 | 2020-06-11 | Garfield | Utah | 49017 | 4 | 0 |
233564 | 233564 | 2020-06-12 | Garfield | Utah | 49017 | 4 | 0 |
236671 | 236671 | 2020-06-13 | Garfield | Utah | 49017 | 4 | 0 |
239779 | 239779 | 2020-06-14 | Garfield | Utah | 49017 | 4 | 0 |
242890 | 242890 | 2020-06-15 | Garfield | Utah | 49017 | 4 | 0 |
246002 | 246002 | 2020-06-16 | Garfield | Utah | 49017 | 4 | 0 |
249115 | 249115 | 2020-06-17 | Garfield | Utah | 49017 | 4 | 0 |
252230 | 252230 | 2020-06-18 | Garfield | Utah | 49017 | 4 | 0 |
255347 | 255347 | 2020-06-19 | Garfield | Utah | 49017 | 4 | 0 |
258474 | 258474 | 2020-06-20 | Garfield | Utah | 49017 | 5 | 0 |
261601 | 261601 | 2020-06-21 | Garfield | Utah | 49017 | 5 | 0 |
264730 | 264730 | 2020-06-22 | Garfield | Utah | 49017 | 9 | 0 |
267859 | 267859 | 2020-06-23 | Garfield | Utah | 49017 | 11 | 0 |
270993 | 270993 | 2020-06-24 | Garfield | Utah | 49017 | 11 | 0 |
274133 | 274133 | 2020-06-25 | Garfield | Utah | 49017 | 12 | 0 |
277281 | 277281 | 2020-06-26 | Garfield | Utah | 49017 | 12 | 0 |
280429 | 280429 | 2020-06-27 | Garfield | Utah | 49017 | 13 | 0 |
283575 | 283575 | 2020-06-28 | Garfield | Utah | 49017 | 13 | 0 |
286721 | 286721 | 2020-06-29 | Garfield | Utah | 49017 | 14 | 0 |
289871 | 289871 | 2020-06-30 | Garfield | Utah | 49017 | 14 | 0 |
293024 | 293024 | 2020-07-01 | Garfield | Utah | 49017 | 15 | 0 |
296179 | 296179 | 2020-07-02 | Garfield | Utah | 49017 | 15 | 0 |
299341 | 299341 | 2020-07-03 | Garfield | Utah | 49017 | 15 | 0 |
302505 | 302505 | 2020-07-04 | Garfield | Utah | 49017 | 15 | 0 |
305669 | 305669 | 2020-07-05 | Garfield | Utah | 49017 | 15 | 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);