ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Utah" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
2688 | 2688 | 2020-03-15 | Utah | Utah | 49049 | 1 | 0 |
3158 | 3158 | 2020-03-16 | Utah | Utah | 49049 | 1 | 0 |
3694 | 3694 | 2020-03-17 | Utah | Utah | 49049 | 1 | 0 |
4326 | 4326 | 2020-03-18 | Utah | Utah | 49049 | 2 | 0 |
5082 | 5082 | 2020-03-19 | Utah | Utah | 49049 | 3 | 0 |
5976 | 5976 | 2020-03-20 | Utah | Utah | 49049 | 3 | 0 |
6999 | 6999 | 2020-03-21 | Utah | Utah | 49049 | 7 | 0 |
8129 | 8129 | 2020-03-22 | Utah | Utah | 49049 | 7 | 0 |
9349 | 9349 | 2020-03-23 | Utah | Utah | 49049 | 12 | 0 |
10693 | 10693 | 2020-03-24 | Utah | Utah | 49049 | 14 | 0 |
12204 | 12204 | 2020-03-25 | Utah | Utah | 49049 | 18 | 0 |
13840 | 13840 | 2020-03-26 | Utah | Utah | 49049 | 25 | 0 |
15606 | 15606 | 2020-03-27 | Utah | Utah | 49049 | 27 | 0 |
17480 | 17480 | 2020-03-28 | Utah | Utah | 49049 | 30 | 0 |
19439 | 19439 | 2020-03-29 | Utah | Utah | 49049 | 51 | 0 |
21502 | 21502 | 2020-03-30 | Utah | Utah | 49049 | 58 | 0 |
23641 | 23641 | 2020-03-31 | Utah | Utah | 49049 | 70 | 0 |
25856 | 25856 | 2020-04-01 | Utah | Utah | 49049 | 90 | 0 |
28145 | 28145 | 2020-04-02 | Utah | Utah | 49049 | 105 | 0 |
30488 | 30488 | 2020-04-03 | Utah | Utah | 49049 | 150 | 0 |
32886 | 32886 | 2020-04-04 | Utah | Utah | 49049 | 186 | 0 |
35324 | 35324 | 2020-04-05 | Utah | Utah | 49049 | 216 | 0 |
37802 | 37802 | 2020-04-06 | Utah | Utah | 49049 | 223 | 0 |
40331 | 40331 | 2020-04-07 | Utah | Utah | 49049 | 236 | 0 |
42899 | 42899 | 2020-04-08 | Utah | Utah | 49049 | 267 | 0 |
45493 | 45493 | 2020-04-09 | Utah | Utah | 49049 | 272 | 0 |
48117 | 48117 | 2020-04-10 | Utah | Utah | 49049 | 283 | 0 |
50775 | 50775 | 2020-04-11 | Utah | Utah | 49049 | 295 | 0 |
53450 | 53450 | 2020-04-12 | Utah | Utah | 49049 | 313 | 0 |
56139 | 56139 | 2020-04-13 | Utah | Utah | 49049 | 322 | 0 |
58845 | 58845 | 2020-04-14 | Utah | Utah | 49049 | 335 | 0 |
61564 | 61564 | 2020-04-15 | Utah | Utah | 49049 | 352 | 0 |
64296 | 64296 | 2020-04-16 | Utah | Utah | 49049 | 387 | 4 |
67044 | 67044 | 2020-04-17 | Utah | Utah | 49049 | 403 | 4 |
69806 | 69806 | 2020-04-18 | Utah | Utah | 49049 | 417 | 5 |
72576 | 72576 | 2020-04-19 | Utah | Utah | 49049 | 455 | 5 |
75352 | 75352 | 2020-04-20 | Utah | Utah | 49049 | 498 | 5 |
78134 | 78134 | 2020-04-21 | Utah | Utah | 49049 | 523 | 5 |
80926 | 80926 | 2020-04-22 | Utah | Utah | 49049 | 570 | 6 |
83727 | 83727 | 2020-04-23 | Utah | Utah | 49049 | 611 | 6 |
86534 | 86534 | 2020-04-24 | Utah | Utah | 49049 | 669 | 7 |
89349 | 89349 | 2020-04-25 | Utah | Utah | 49049 | 725 | 7 |
92166 | 92166 | 2020-04-26 | Utah | Utah | 49049 | 777 | 7 |
94995 | 94995 | 2020-04-27 | Utah | Utah | 49049 | 828 | 7 |
97837 | 97837 | 2020-04-28 | Utah | Utah | 49049 | 862 | 7 |
100687 | 100687 | 2020-04-29 | Utah | Utah | 49049 | 899 | 7 |
103542 | 103542 | 2020-04-30 | Utah | Utah | 49049 | 957 | 7 |
106406 | 106406 | 2020-05-01 | Utah | Utah | 49049 | 993 | 7 |
109275 | 109275 | 2020-05-02 | Utah | Utah | 49049 | 1021 | 9 |
112149 | 112149 | 2020-05-03 | Utah | Utah | 49049 | 1073 | 9 |
115032 | 115032 | 2020-05-04 | Utah | Utah | 49049 | 1122 | 9 |
117991 | 117991 | 2020-05-05 | Utah | Utah | 49049 | 1171 | 10 |
120955 | 120955 | 2020-05-06 | Utah | Utah | 49049 | 1210 | 10 |
123936 | 123936 | 2020-05-07 | Utah | Utah | 49049 | 1219 | 11 |
126921 | 126921 | 2020-05-08 | Utah | Utah | 49049 | 1288 | 11 |
129910 | 129910 | 2020-05-09 | Utah | Utah | 49049 | 1318 | 11 |
132900 | 132900 | 2020-05-10 | Utah | Utah | 49049 | 1346 | 11 |
135890 | 135890 | 2020-05-11 | Utah | Utah | 49049 | 1358 | 11 |
138881 | 138881 | 2020-05-12 | Utah | Utah | 49049 | 1365 | 11 |
141877 | 141877 | 2020-05-13 | Utah | Utah | 49049 | 1400 | 11 |
144874 | 144874 | 2020-05-14 | Utah | Utah | 49049 | 1435 | 11 |
147877 | 147877 | 2020-05-15 | Utah | Utah | 49049 | 1455 | 11 |
150886 | 150886 | 2020-05-16 | Utah | Utah | 49049 | 1471 | 11 |
153897 | 153897 | 2020-05-17 | Utah | Utah | 49049 | 1497 | 11 |
156914 | 156914 | 2020-05-18 | Utah | Utah | 49049 | 1520 | 11 |
159938 | 159938 | 2020-05-19 | Utah | Utah | 49049 | 1537 | 12 |
162966 | 162966 | 2020-05-20 | Utah | Utah | 49049 | 1569 | 13 |
165995 | 165995 | 2020-05-21 | Utah | Utah | 49049 | 1592 | 13 |
169031 | 169031 | 2020-05-22 | Utah | Utah | 49049 | 1651 | 13 |
172072 | 172072 | 2020-05-23 | Utah | Utah | 49049 | 1678 | 14 |
175115 | 175115 | 2020-05-24 | Utah | Utah | 49049 | 1704 | 14 |
178160 | 178160 | 2020-05-25 | Utah | Utah | 49049 | 1722 | 14 |
181204 | 181204 | 2020-05-26 | Utah | Utah | 49049 | 1744 | 14 |
184255 | 184255 | 2020-05-27 | Utah | Utah | 49049 | 1753 | 15 |
187312 | 187312 | 2020-05-28 | Utah | Utah | 49049 | 1777 | 17 |
190376 | 190376 | 2020-05-29 | Utah | Utah | 49049 | 1826 | 17 |
193442 | 193442 | 2020-05-30 | Utah | Utah | 49049 | 1870 | 17 |
196512 | 196512 | 2020-05-31 | Utah | Utah | 49049 | 1929 | 17 |
199585 | 199585 | 2020-06-01 | Utah | Utah | 49049 | 1965 | 17 |
202661 | 202661 | 2020-06-02 | Utah | Utah | 49049 | 1991 | 17 |
205740 | 205740 | 2020-06-03 | Utah | Utah | 49049 | 2028 | 17 |
208822 | 208822 | 2020-06-04 | Utah | Utah | 49049 | 2088 | 17 |
211907 | 211907 | 2020-06-05 | Utah | Utah | 49049 | 2143 | 17 |
214994 | 214994 | 2020-06-06 | Utah | Utah | 49049 | 2183 | 17 |
218084 | 218084 | 2020-06-07 | Utah | Utah | 49049 | 2261 | 17 |
221176 | 221176 | 2020-06-08 | Utah | Utah | 49049 | 2310 | 17 |
224272 | 224272 | 2020-06-09 | Utah | Utah | 49049 | 2337 | 18 |
227372 | 227372 | 2020-06-10 | Utah | Utah | 49049 | 2376 | 18 |
230476 | 230476 | 2020-06-11 | Utah | Utah | 49049 | 2444 | 19 |
233581 | 233581 | 2020-06-12 | Utah | Utah | 49049 | 2491 | 19 |
236688 | 236688 | 2020-06-13 | Utah | Utah | 49049 | 2551 | 19 |
239796 | 239796 | 2020-06-14 | Utah | Utah | 49049 | 2607 | 19 |
242907 | 242907 | 2020-06-15 | Utah | Utah | 49049 | 2654 | 19 |
246019 | 246019 | 2020-06-16 | Utah | Utah | 49049 | 2711 | 19 |
249131 | 249131 | 2020-06-17 | Utah | Utah | 49049 | 2776 | 19 |
252246 | 252246 | 2020-06-18 | Utah | Utah | 49049 | 2861 | 19 |
255364 | 255364 | 2020-06-19 | Utah | Utah | 49049 | 2957 | 19 |
258491 | 258491 | 2020-06-20 | Utah | Utah | 49049 | 3056 | 19 |
261618 | 261618 | 2020-06-21 | Utah | Utah | 49049 | 3136 | 21 |
264747 | 264747 | 2020-06-22 | Utah | Utah | 49049 | 3263 | 21 |
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);