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 |
---|---|---|---|---|---|---|---|
437110 | 437110 | 2020-08-15 | Salt Lake | Utah | 49035 | 21707 | 212 |
433884 | 433884 | 2020-08-14 | Salt Lake | Utah | 49035 | 21539 | 211 |
430659 | 430659 | 2020-08-13 | Salt Lake | Utah | 49035 | 21290 | 209 |
427431 | 427431 | 2020-08-12 | Salt Lake | Utah | 49035 | 21118 | 206 |
424207 | 424207 | 2020-08-11 | Salt Lake | Utah | 49035 | 20985 | 201 |
420986 | 420986 | 2020-08-10 | Salt Lake | Utah | 49035 | 20810 | 197 |
417765 | 417765 | 2020-08-09 | Salt Lake | Utah | 49035 | 20628 | 190 |
414544 | 414544 | 2020-08-08 | Salt Lake | Utah | 49035 | 20530 | 190 |
411324 | 411324 | 2020-08-07 | Salt Lake | Utah | 49035 | 20417 | 191 |
408105 | 408105 | 2020-08-06 | Salt Lake | Utah | 49035 | 20197 | 188 |
404885 | 404885 | 2020-08-05 | Salt Lake | Utah | 49035 | 20004 | 187 |
401667 | 401667 | 2020-08-04 | Salt Lake | Utah | 49035 | 19796 | 186 |
398451 | 398451 | 2020-08-03 | Salt Lake | Utah | 49035 | 19623 | 180 |
395235 | 395235 | 2020-08-02 | Salt Lake | Utah | 49035 | 19408 | 177 |
392019 | 392019 | 2020-08-01 | Salt Lake | Utah | 49035 | 19323 | 177 |
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 |
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);