ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 49011 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
644 | 644 | 2020-03-06 | Davis | Utah | 49011 | 1 | 0 |
736 | 736 | 2020-03-07 | Davis | Utah | 49011 | 1 | 0 |
848 | 848 | 2020-03-08 | Davis | Utah | 49011 | 1 | 0 |
978 | 978 | 2020-03-09 | Davis | Utah | 49011 | 1 | 0 |
1139 | 1139 | 2020-03-10 | Davis | Utah | 49011 | 1 | 0 |
1336 | 1336 | 2020-03-11 | Davis | Utah | 49011 | 1 | 0 |
1583 | 1583 | 2020-03-12 | Davis | Utah | 49011 | 1 | 0 |
1892 | 1892 | 2020-03-13 | Davis | Utah | 49011 | 1 | 0 |
2259 | 2259 | 2020-03-14 | Davis | Utah | 49011 | 2 | 0 |
2685 | 2685 | 2020-03-15 | Davis | Utah | 49011 | 3 | 0 |
3154 | 3154 | 2020-03-16 | Davis | Utah | 49011 | 4 | 0 |
3690 | 3690 | 2020-03-17 | Davis | Utah | 49011 | 4 | 0 |
4322 | 4322 | 2020-03-18 | Davis | Utah | 49011 | 6 | 0 |
5078 | 5078 | 2020-03-19 | Davis | Utah | 49011 | 8 | 0 |
5972 | 5972 | 2020-03-20 | Davis | Utah | 49011 | 12 | 0 |
6995 | 6995 | 2020-03-21 | Davis | Utah | 49011 | 16 | 0 |
8125 | 8125 | 2020-03-22 | Davis | Utah | 49011 | 19 | 1 |
9344 | 9344 | 2020-03-23 | Davis | Utah | 49011 | 29 | 1 |
10688 | 10688 | 2020-03-24 | Davis | Utah | 49011 | 31 | 1 |
12198 | 12198 | 2020-03-25 | Davis | Utah | 49011 | 35 | 1 |
13833 | 13833 | 2020-03-26 | Davis | Utah | 49011 | 39 | 1 |
15598 | 15598 | 2020-03-27 | Davis | Utah | 49011 | 50 | 1 |
17470 | 17470 | 2020-03-28 | Davis | Utah | 49011 | 59 | 1 |
19429 | 19429 | 2020-03-29 | Davis | Utah | 49011 | 69 | 1 |
21492 | 21492 | 2020-03-30 | Davis | Utah | 49011 | 77 | 1 |
23631 | 23631 | 2020-03-31 | Davis | Utah | 49011 | 84 | 1 |
25846 | 25846 | 2020-04-01 | Davis | Utah | 49011 | 93 | 1 |
28134 | 28134 | 2020-04-02 | Davis | Utah | 49011 | 103 | 1 |
30472 | 30472 | 2020-04-03 | Davis | Utah | 49011 | 122 | 2 |
32870 | 32870 | 2020-04-04 | Davis | Utah | 49011 | 137 | 2 |
35308 | 35308 | 2020-04-05 | Davis | Utah | 49011 | 142 | 2 |
37786 | 37786 | 2020-04-06 | Davis | Utah | 49011 | 154 | 2 |
40315 | 40315 | 2020-04-07 | Davis | Utah | 49011 | 158 | 2 |
42883 | 42883 | 2020-04-08 | Davis | Utah | 49011 | 163 | 2 |
45477 | 45477 | 2020-04-09 | Davis | Utah | 49011 | 170 | 2 |
48101 | 48101 | 2020-04-10 | Davis | Utah | 49011 | 180 | 2 |
50759 | 50759 | 2020-04-11 | Davis | Utah | 49011 | 193 | 2 |
53434 | 53434 | 2020-04-12 | Davis | Utah | 49011 | 199 | 2 |
56123 | 56123 | 2020-04-13 | Davis | Utah | 49011 | 204 | 2 |
58829 | 58829 | 2020-04-14 | Davis | Utah | 49011 | 211 | 2 |
61547 | 61547 | 2020-04-15 | Davis | Utah | 49011 | 217 | 2 |
64279 | 64279 | 2020-04-16 | Davis | Utah | 49011 | 220 | 2 |
67027 | 67027 | 2020-04-17 | Davis | Utah | 49011 | 227 | 2 |
69788 | 69788 | 2020-04-18 | Davis | Utah | 49011 | 230 | 2 |
72558 | 72558 | 2020-04-19 | Davis | Utah | 49011 | 236 | 2 |
75334 | 75334 | 2020-04-20 | Davis | Utah | 49011 | 242 | 2 |
78116 | 78116 | 2020-04-21 | Davis | Utah | 49011 | 243 | 2 |
80908 | 80908 | 2020-04-22 | Davis | Utah | 49011 | 249 | 2 |
83709 | 83709 | 2020-04-23 | Davis | Utah | 49011 | 254 | 2 |
86516 | 86516 | 2020-04-24 | Davis | Utah | 49011 | 256 | 2 |
89331 | 89331 | 2020-04-25 | Davis | Utah | 49011 | 268 | 2 |
92148 | 92148 | 2020-04-26 | Davis | Utah | 49011 | 275 | 2 |
94977 | 94977 | 2020-04-27 | Davis | Utah | 49011 | 276 | 2 |
97819 | 97819 | 2020-04-28 | Davis | Utah | 49011 | 278 | 2 |
100669 | 100669 | 2020-04-29 | Davis | Utah | 49011 | 283 | 2 |
103524 | 103524 | 2020-04-30 | Davis | Utah | 49011 | 285 | 2 |
106388 | 106388 | 2020-05-01 | Davis | Utah | 49011 | 293 | 2 |
109257 | 109257 | 2020-05-02 | Davis | Utah | 49011 | 296 | 2 |
112131 | 112131 | 2020-05-03 | Davis | Utah | 49011 | 300 | 2 |
115014 | 115014 | 2020-05-04 | Davis | Utah | 49011 | 299 | 2 |
117973 | 117973 | 2020-05-05 | Davis | Utah | 49011 | 302 | 2 |
120937 | 120937 | 2020-05-06 | Davis | Utah | 49011 | 308 | 2 |
123917 | 123917 | 2020-05-07 | Davis | Utah | 49011 | 315 | 2 |
126902 | 126902 | 2020-05-08 | Davis | Utah | 49011 | 321 | 2 |
129891 | 129891 | 2020-05-09 | Davis | Utah | 49011 | 327 | 2 |
132881 | 132881 | 2020-05-10 | Davis | Utah | 49011 | 336 | 2 |
135872 | 135872 | 2020-05-11 | Davis | Utah | 49011 | 338 | 2 |
138862 | 138862 | 2020-05-12 | Davis | Utah | 49011 | 340 | 2 |
141858 | 141858 | 2020-05-13 | Davis | Utah | 49011 | 344 | 2 |
144855 | 144855 | 2020-05-14 | Davis | Utah | 49011 | 349 | 2 |
147859 | 147859 | 2020-05-15 | Davis | Utah | 49011 | 354 | 2 |
150867 | 150867 | 2020-05-16 | Davis | Utah | 49011 | 363 | 2 |
153878 | 153878 | 2020-05-17 | Davis | Utah | 49011 | 368 | 2 |
156895 | 156895 | 2020-05-18 | Davis | Utah | 49011 | 370 | 2 |
159919 | 159919 | 2020-05-19 | Davis | Utah | 49011 | 373 | 2 |
162947 | 162947 | 2020-05-20 | Davis | Utah | 49011 | 386 | 2 |
165976 | 165976 | 2020-05-21 | Davis | Utah | 49011 | 396 | 2 |
169012 | 169012 | 2020-05-22 | Davis | Utah | 49011 | 401 | 2 |
172053 | 172053 | 2020-05-23 | Davis | Utah | 49011 | 407 | 2 |
175096 | 175096 | 2020-05-24 | Davis | Utah | 49011 | 410 | 2 |
178141 | 178141 | 2020-05-25 | Davis | Utah | 49011 | 414 | 2 |
181185 | 181185 | 2020-05-26 | Davis | Utah | 49011 | 419 | 2 |
184236 | 184236 | 2020-05-27 | Davis | Utah | 49011 | 424 | 2 |
187293 | 187293 | 2020-05-28 | Davis | Utah | 49011 | 435 | 2 |
190357 | 190357 | 2020-05-29 | Davis | Utah | 49011 | 447 | 2 |
193423 | 193423 | 2020-05-30 | Davis | Utah | 49011 | 458 | 2 |
196493 | 196493 | 2020-05-31 | Davis | Utah | 49011 | 465 | 2 |
199566 | 199566 | 2020-06-01 | Davis | Utah | 49011 | 472 | 2 |
202642 | 202642 | 2020-06-02 | Davis | Utah | 49011 | 476 | 2 |
205721 | 205721 | 2020-06-03 | Davis | Utah | 49011 | 494 | 2 |
208803 | 208803 | 2020-06-04 | Davis | Utah | 49011 | 513 | 2 |
211888 | 211888 | 2020-06-05 | Davis | Utah | 49011 | 525 | 2 |
214975 | 214975 | 2020-06-06 | Davis | Utah | 49011 | 541 | 2 |
218065 | 218065 | 2020-06-07 | Davis | Utah | 49011 | 549 | 2 |
221157 | 221157 | 2020-06-08 | Davis | Utah | 49011 | 564 | 3 |
224253 | 224253 | 2020-06-09 | Davis | Utah | 49011 | 580 | 3 |
227353 | 227353 | 2020-06-10 | Davis | Utah | 49011 | 593 | 4 |
230457 | 230457 | 2020-06-11 | Davis | Utah | 49011 | 620 | 4 |
233561 | 233561 | 2020-06-12 | Davis | Utah | 49011 | 628 | 4 |
236668 | 236668 | 2020-06-13 | Davis | Utah | 49011 | 646 | 4 |
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);