ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Kane" and fips = 49025 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
28137 | 28137 | 2020-04-02 | Kane | Utah | 49025 | 1 | 0 |
30479 | 30479 | 2020-04-03 | Kane | Utah | 49025 | 1 | 0 |
32877 | 32877 | 2020-04-04 | Kane | Utah | 49025 | 1 | 0 |
35315 | 35315 | 2020-04-05 | Kane | Utah | 49025 | 2 | 0 |
37793 | 37793 | 2020-04-06 | Kane | Utah | 49025 | 2 | 0 |
40322 | 40322 | 2020-04-07 | Kane | Utah | 49025 | 2 | 0 |
42890 | 42890 | 2020-04-08 | Kane | Utah | 49025 | 2 | 0 |
45484 | 45484 | 2020-04-09 | Kane | Utah | 49025 | 3 | 0 |
48108 | 48108 | 2020-04-10 | Kane | Utah | 49025 | 3 | 0 |
50766 | 50766 | 2020-04-11 | Kane | Utah | 49025 | 3 | 0 |
53441 | 53441 | 2020-04-12 | Kane | Utah | 49025 | 3 | 0 |
56130 | 56130 | 2020-04-13 | Kane | Utah | 49025 | 3 | 0 |
58836 | 58836 | 2020-04-14 | Kane | Utah | 49025 | 3 | 0 |
61554 | 61554 | 2020-04-15 | Kane | Utah | 49025 | 3 | 0 |
64286 | 64286 | 2020-04-16 | Kane | Utah | 49025 | 3 | 0 |
67034 | 67034 | 2020-04-17 | Kane | Utah | 49025 | 3 | 0 |
69795 | 69795 | 2020-04-18 | Kane | Utah | 49025 | 3 | 0 |
72565 | 72565 | 2020-04-19 | Kane | Utah | 49025 | 3 | 0 |
75341 | 75341 | 2020-04-20 | Kane | Utah | 49025 | 3 | 0 |
78123 | 78123 | 2020-04-21 | Kane | Utah | 49025 | 3 | 0 |
80915 | 80915 | 2020-04-22 | Kane | Utah | 49025 | 3 | 0 |
83716 | 83716 | 2020-04-23 | Kane | Utah | 49025 | 3 | 0 |
86523 | 86523 | 2020-04-24 | Kane | Utah | 49025 | 3 | 0 |
89338 | 89338 | 2020-04-25 | Kane | Utah | 49025 | 3 | 0 |
92155 | 92155 | 2020-04-26 | Kane | Utah | 49025 | 3 | 0 |
94984 | 94984 | 2020-04-27 | Kane | Utah | 49025 | 3 | 0 |
97826 | 97826 | 2020-04-28 | Kane | Utah | 49025 | 3 | 0 |
100676 | 100676 | 2020-04-29 | Kane | Utah | 49025 | 3 | 0 |
103531 | 103531 | 2020-04-30 | Kane | Utah | 49025 | 3 | 0 |
106395 | 106395 | 2020-05-01 | Kane | Utah | 49025 | 3 | 0 |
109264 | 109264 | 2020-05-02 | Kane | Utah | 49025 | 3 | 0 |
112138 | 112138 | 2020-05-03 | Kane | Utah | 49025 | 3 | 0 |
115021 | 115021 | 2020-05-04 | Kane | Utah | 49025 | 3 | 0 |
117980 | 117980 | 2020-05-05 | Kane | Utah | 49025 | 3 | 0 |
120944 | 120944 | 2020-05-06 | Kane | Utah | 49025 | 3 | 0 |
123924 | 123924 | 2020-05-07 | Kane | Utah | 49025 | 3 | 0 |
126909 | 126909 | 2020-05-08 | Kane | Utah | 49025 | 3 | 0 |
129898 | 129898 | 2020-05-09 | Kane | Utah | 49025 | 3 | 0 |
132888 | 132888 | 2020-05-10 | Kane | Utah | 49025 | 3 | 0 |
135879 | 135879 | 2020-05-11 | Kane | Utah | 49025 | 3 | 0 |
138869 | 138869 | 2020-05-12 | Kane | Utah | 49025 | 3 | 0 |
141865 | 141865 | 2020-05-13 | Kane | Utah | 49025 | 3 | 0 |
144862 | 144862 | 2020-05-14 | Kane | Utah | 49025 | 3 | 0 |
147866 | 147866 | 2020-05-15 | Kane | Utah | 49025 | 3 | 0 |
150874 | 150874 | 2020-05-16 | Kane | Utah | 49025 | 3 | 0 |
153885 | 153885 | 2020-05-17 | Kane | Utah | 49025 | 3 | 0 |
156902 | 156902 | 2020-05-18 | Kane | Utah | 49025 | 3 | 0 |
159926 | 159926 | 2020-05-19 | Kane | Utah | 49025 | 3 | 0 |
162954 | 162954 | 2020-05-20 | Kane | Utah | 49025 | 3 | 0 |
165983 | 165983 | 2020-05-21 | Kane | Utah | 49025 | 3 | 0 |
169019 | 169019 | 2020-05-22 | Kane | Utah | 49025 | 3 | 0 |
172060 | 172060 | 2020-05-23 | Kane | Utah | 49025 | 3 | 0 |
175103 | 175103 | 2020-05-24 | Kane | Utah | 49025 | 3 | 0 |
178148 | 178148 | 2020-05-25 | Kane | Utah | 49025 | 3 | 0 |
181192 | 181192 | 2020-05-26 | Kane | Utah | 49025 | 3 | 0 |
184243 | 184243 | 2020-05-27 | Kane | Utah | 49025 | 3 | 0 |
187300 | 187300 | 2020-05-28 | Kane | Utah | 49025 | 3 | 0 |
190364 | 190364 | 2020-05-29 | Kane | Utah | 49025 | 3 | 0 |
193430 | 193430 | 2020-05-30 | Kane | Utah | 49025 | 3 | 0 |
196500 | 196500 | 2020-05-31 | Kane | Utah | 49025 | 3 | 0 |
199573 | 199573 | 2020-06-01 | Kane | Utah | 49025 | 3 | 0 |
202649 | 202649 | 2020-06-02 | Kane | Utah | 49025 | 3 | 0 |
205728 | 205728 | 2020-06-03 | Kane | Utah | 49025 | 3 | 0 |
208810 | 208810 | 2020-06-04 | Kane | Utah | 49025 | 3 | 0 |
211895 | 211895 | 2020-06-05 | Kane | Utah | 49025 | 3 | 0 |
214982 | 214982 | 2020-06-06 | Kane | Utah | 49025 | 3 | 0 |
218072 | 218072 | 2020-06-07 | Kane | Utah | 49025 | 3 | 0 |
221164 | 221164 | 2020-06-08 | Kane | Utah | 49025 | 4 | 0 |
224260 | 224260 | 2020-06-09 | Kane | Utah | 49025 | 4 | 0 |
227360 | 227360 | 2020-06-10 | Kane | Utah | 49025 | 4 | 0 |
230464 | 230464 | 2020-06-11 | Kane | Utah | 49025 | 4 | 0 |
233568 | 233568 | 2020-06-12 | Kane | Utah | 49025 | 4 | 0 |
236675 | 236675 | 2020-06-13 | Kane | Utah | 49025 | 4 | 0 |
239783 | 239783 | 2020-06-14 | Kane | Utah | 49025 | 4 | 0 |
242894 | 242894 | 2020-06-15 | Kane | Utah | 49025 | 4 | 0 |
246006 | 246006 | 2020-06-16 | Kane | Utah | 49025 | 4 | 0 |
249119 | 249119 | 2020-06-17 | Kane | Utah | 49025 | 4 | 0 |
252234 | 252234 | 2020-06-18 | Kane | Utah | 49025 | 4 | 0 |
255351 | 255351 | 2020-06-19 | Kane | Utah | 49025 | 5 | 0 |
258478 | 258478 | 2020-06-20 | Kane | Utah | 49025 | 5 | 0 |
261605 | 261605 | 2020-06-21 | Kane | Utah | 49025 | 5 | 0 |
264734 | 264734 | 2020-06-22 | Kane | Utah | 49025 | 5 | 0 |
267863 | 267863 | 2020-06-23 | Kane | Utah | 49025 | 6 | 0 |
270997 | 270997 | 2020-06-24 | Kane | Utah | 49025 | 6 | 0 |
274137 | 274137 | 2020-06-25 | Kane | Utah | 49025 | 6 | 0 |
277285 | 277285 | 2020-06-26 | Kane | Utah | 49025 | 6 | 0 |
280433 | 280433 | 2020-06-27 | Kane | Utah | 49025 | 6 | 0 |
283579 | 283579 | 2020-06-28 | Kane | Utah | 49025 | 6 | 0 |
286725 | 286725 | 2020-06-29 | Kane | Utah | 49025 | 6 | 0 |
289875 | 289875 | 2020-06-30 | Kane | Utah | 49025 | 6 | 0 |
293028 | 293028 | 2020-07-01 | Kane | Utah | 49025 | 6 | 0 |
296183 | 296183 | 2020-07-02 | Kane | Utah | 49025 | 7 | 0 |
299345 | 299345 | 2020-07-03 | Kane | Utah | 49025 | 7 | 0 |
302509 | 302509 | 2020-07-04 | Kane | Utah | 49025 | 7 | 0 |
305673 | 305673 | 2020-07-05 | Kane | Utah | 49025 | 7 | 0 |
308841 | 308841 | 2020-07-06 | Kane | Utah | 49025 | 12 | 0 |
312010 | 312010 | 2020-07-07 | Kane | Utah | 49025 | 12 | 0 |
315184 | 315184 | 2020-07-08 | Kane | Utah | 49025 | 12 | 0 |
318357 | 318357 | 2020-07-09 | Kane | Utah | 49025 | 13 | 0 |
321536 | 321536 | 2020-07-10 | Kane | Utah | 49025 | 14 | 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);