ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
809 rows where fips = 49035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388802 | 388802 | 2020-07-31 | Salt Lake | Utah | 49035 | 19086 | 176 |
385585 | 385585 | 2020-07-30 | Salt Lake | Utah | 49035 | 18847 | 173 |
382367 | 382367 | 2020-07-29 | Salt Lake | Utah | 49035 | 18723 | 170 |
379150 | 379150 | 2020-07-28 | Salt Lake | Utah | 49035 | 18471 | 165 |
375934 | 375934 | 2020-07-27 | Salt Lake | Utah | 49035 | 18321 | 163 |
372721 | 372721 | 2020-07-26 | Salt Lake | Utah | 49035 | 18090 | 159 |
369509 | 369509 | 2020-07-25 | Salt Lake | Utah | 49035 | 18013 | 159 |
366300 | 366300 | 2020-07-24 | Salt Lake | Utah | 49035 | 17808 | 159 |
363094 | 363094 | 2020-07-23 | Salt Lake | Utah | 49035 | 17426 | 155 |
359887 | 359887 | 2020-07-22 | Salt Lake | Utah | 49035 | 17254 | 147 |
356682 | 356682 | 2020-07-21 | Salt Lake | Utah | 49035 | 17021 | 143 |
353479 | 353479 | 2020-07-20 | Salt Lake | Utah | 49035 | 16755 | 140 |
350277 | 350277 | 2020-07-19 | Salt Lake | Utah | 49035 | 16523 | 138 |
347077 | 347077 | 2020-07-18 | Salt Lake | Utah | 49035 | 16359 | 138 |
343876 | 343876 | 2020-07-17 | Salt Lake | Utah | 49035 | 15923 | 136 |
340677 | 340677 | 2020-07-16 | Salt Lake | Utah | 49035 | 15663 | 135 |
337481 | 337481 | 2020-07-15 | Salt Lake | Utah | 49035 | 15410 | 134 |
334286 | 334286 | 2020-07-14 | Salt Lake | Utah | 49035 | 15159 | 132 |
331093 | 331093 | 2020-07-13 | Salt Lake | Utah | 49035 | 14959 | 132 |
327907 | 327907 | 2020-07-12 | Salt Lake | Utah | 49035 | 14609 | 133 |
324722 | 324722 | 2020-07-11 | Salt Lake | Utah | 49035 | 14406 | 133 |
321541 | 321541 | 2020-07-10 | Salt Lake | Utah | 49035 | 14148 | 130 |
318362 | 318362 | 2020-07-09 | Salt Lake | Utah | 49035 | 13763 | 124 |
315189 | 315189 | 2020-07-08 | Salt Lake | Utah | 49035 | 13419 | 122 |
312015 | 312015 | 2020-07-07 | Salt Lake | Utah | 49035 | 13069 | 120 |
308846 | 308846 | 2020-07-06 | Salt Lake | Utah | 49035 | 12842 | 117 |
305678 | 305678 | 2020-07-05 | Salt Lake | Utah | 49035 | 12540 | 113 |
302514 | 302514 | 2020-07-04 | Salt Lake | Utah | 49035 | 12435 | 112 |
299350 | 299350 | 2020-07-03 | Salt Lake | Utah | 49035 | 12149 | 112 |
296188 | 296188 | 2020-07-02 | Salt Lake | Utah | 49035 | 11833 | 111 |
293033 | 293033 | 2020-07-01 | Salt Lake | Utah | 49035 | 11487 | 108 |
289880 | 289880 | 2020-06-30 | Salt Lake | Utah | 49035 | 11227 | 107 |
286730 | 286730 | 2020-06-29 | Salt Lake | Utah | 49035 | 10951 | 107 |
283584 | 283584 | 2020-06-28 | Salt Lake | Utah | 49035 | 10629 | 106 |
280438 | 280438 | 2020-06-27 | Salt Lake | Utah | 49035 | 10458 | 106 |
277290 | 277290 | 2020-06-26 | Salt Lake | Utah | 49035 | 10163 | 106 |
274142 | 274142 | 2020-06-25 | Salt Lake | Utah | 49035 | 9830 | 105 |
271002 | 271002 | 2020-06-24 | Salt Lake | Utah | 49035 | 9501 | 105 |
267868 | 267868 | 2020-06-23 | Salt Lake | Utah | 49035 | 9252 | 105 |
264739 | 264739 | 2020-06-22 | Salt Lake | Utah | 49035 | 9073 | 102 |
261610 | 261610 | 2020-06-21 | Salt Lake | Utah | 49035 | 8878 | 102 |
258483 | 258483 | 2020-06-20 | Salt Lake | Utah | 49035 | 8713 | 102 |
255356 | 255356 | 2020-06-19 | Salt Lake | Utah | 49035 | 8404 | 102 |
252239 | 252239 | 2020-06-18 | Salt Lake | Utah | 49035 | 8140 | 100 |
249124 | 249124 | 2020-06-17 | Salt Lake | Utah | 49035 | 7846 | 99 |
246011 | 246011 | 2020-06-16 | Salt Lake | Utah | 49035 | 7644 | 96 |
242899 | 242899 | 2020-06-15 | Salt Lake | Utah | 49035 | 7506 | 95 |
239788 | 239788 | 2020-06-14 | Salt Lake | Utah | 49035 | 7309 | 93 |
236680 | 236680 | 2020-06-13 | Salt Lake | Utah | 49035 | 7187 | 93 |
233573 | 233573 | 2020-06-12 | Salt Lake | Utah | 49035 | 6966 | 93 |
230468 | 230468 | 2020-06-11 | Salt Lake | Utah | 49035 | 6783 | 87 |
227364 | 227364 | 2020-06-10 | Salt Lake | Utah | 49035 | 6619 | 85 |
224264 | 224264 | 2020-06-09 | Salt Lake | Utah | 49035 | 6437 | 85 |
221168 | 221168 | 2020-06-08 | Salt Lake | Utah | 49035 | 6313 | 83 |
218076 | 218076 | 2020-06-07 | Salt Lake | Utah | 49035 | 6182 | 81 |
214986 | 214986 | 2020-06-06 | Salt Lake | Utah | 49035 | 6096 | 81 |
211899 | 211899 | 2020-06-05 | Salt Lake | Utah | 49035 | 5918 | 81 |
208814 | 208814 | 2020-06-04 | Salt Lake | Utah | 49035 | 5760 | 78 |
205732 | 205732 | 2020-06-03 | Salt Lake | Utah | 49035 | 5621 | 78 |
202653 | 202653 | 2020-06-02 | Salt Lake | Utah | 49035 | 5449 | 74 |
199577 | 199577 | 2020-06-01 | Salt Lake | Utah | 49035 | 5340 | 74 |
196504 | 196504 | 2020-05-31 | Salt Lake | Utah | 49035 | 5242 | 74 |
193434 | 193434 | 2020-05-30 | Salt Lake | Utah | 49035 | 5118 | 74 |
190368 | 190368 | 2020-05-29 | Salt Lake | Utah | 49035 | 4994 | 71 |
187304 | 187304 | 2020-05-28 | Salt Lake | Utah | 49035 | 4806 | 71 |
184247 | 184247 | 2020-05-27 | Salt Lake | Utah | 49035 | 4682 | 71 |
181196 | 181196 | 2020-05-26 | Salt Lake | Utah | 49035 | 4632 | 70 |
178152 | 178152 | 2020-05-25 | Salt Lake | Utah | 49035 | 4583 | 68 |
175107 | 175107 | 2020-05-24 | Salt Lake | Utah | 49035 | 4515 | 68 |
172064 | 172064 | 2020-05-23 | Salt Lake | Utah | 49035 | 4441 | 68 |
169023 | 169023 | 2020-05-22 | Salt Lake | Utah | 49035 | 4308 | 65 |
165987 | 165987 | 2020-05-21 | Salt Lake | Utah | 49035 | 4217 | 65 |
162958 | 162958 | 2020-05-20 | Salt Lake | Utah | 49035 | 4123 | 62 |
159930 | 159930 | 2020-05-19 | Salt Lake | Utah | 49035 | 4019 | 62 |
156906 | 156906 | 2020-05-18 | Salt Lake | Utah | 49035 | 3942 | 56 |
153889 | 153889 | 2020-05-17 | Salt Lake | Utah | 49035 | 3883 | 56 |
150878 | 150878 | 2020-05-16 | Salt Lake | Utah | 49035 | 3785 | 55 |
147870 | 147870 | 2020-05-15 | Salt Lake | Utah | 49035 | 3717 | 55 |
144866 | 144866 | 2020-05-14 | Salt Lake | Utah | 49035 | 3609 | 52 |
141869 | 141869 | 2020-05-13 | Salt Lake | Utah | 49035 | 3530 | 52 |
138873 | 138873 | 2020-05-12 | Salt Lake | Utah | 49035 | 3425 | 51 |
135883 | 135883 | 2020-05-11 | Salt Lake | Utah | 49035 | 3370 | 48 |
132892 | 132892 | 2020-05-10 | Salt Lake | Utah | 49035 | 3291 | 44 |
129902 | 129902 | 2020-05-09 | Salt Lake | Utah | 49035 | 3206 | 44 |
126913 | 126913 | 2020-05-08 | Salt Lake | Utah | 49035 | 3104 | 39 |
123928 | 123928 | 2020-05-07 | Salt Lake | Utah | 49035 | 3010 | 39 |
120947 | 120947 | 2020-05-06 | Salt Lake | Utah | 49035 | 2919 | 38 |
117983 | 117983 | 2020-05-05 | Salt Lake | Utah | 49035 | 2832 | 35 |
115024 | 115024 | 2020-05-04 | Salt Lake | Utah | 49035 | 2769 | 31 |
112141 | 112141 | 2020-05-03 | Salt Lake | Utah | 49035 | 2707 | 31 |
109267 | 109267 | 2020-05-02 | Salt Lake | Utah | 49035 | 2609 | 30 |
106398 | 106398 | 2020-05-01 | Salt Lake | Utah | 49035 | 2526 | 30 |
103534 | 103534 | 2020-04-30 | Salt Lake | Utah | 49035 | 2438 | 29 |
100679 | 100679 | 2020-04-29 | Salt Lake | Utah | 49035 | 2348 | 28 |
97829 | 97829 | 2020-04-28 | Salt Lake | Utah | 49035 | 2256 | 28 |
94987 | 94987 | 2020-04-27 | Salt Lake | Utah | 49035 | 2190 | 24 |
92158 | 92158 | 2020-04-26 | Salt Lake | Utah | 49035 | 2144 | 25 |
89341 | 89341 | 2020-04-25 | Salt Lake | Utah | 49035 | 2051 | 25 |
86526 | 86526 | 2020-04-24 | Salt Lake | Utah | 49035 | 1975 | 23 |
83719 | 83719 | 2020-04-23 | Salt Lake | Utah | 49035 | 1889 | 20 |
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);