ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

138 rows where fips = 49035 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 49035 · 138

county

Link rowid date ▲ county state fips cases deaths
319199 2020-07-11 Salt Lake Utah 49035 14406 133
316098 2020-07-10 Salt Lake Utah 49035 14148 130
313000 2020-07-09 Salt Lake Utah 49035 13763 124
309908 2020-07-08 Salt Lake Utah 49035 13419 122
306814 2020-07-07 Salt Lake Utah 49035 13069 120
303725 2020-07-06 Salt Lake Utah 49035 12842 117
300637 2020-07-05 Salt Lake Utah 49035 12540 113
297553 2020-07-04 Salt Lake Utah 49035 12435 112
294469 2020-07-03 Salt Lake Utah 49035 12149 112
291387 2020-07-02 Salt Lake Utah 49035 11833 111
288312 2020-07-01 Salt Lake Utah 49035 11487 108
285239 2020-06-30 Salt Lake Utah 49035 11227 107
282168 2020-06-29 Salt Lake Utah 49035 10951 107
279101 2020-06-28 Salt Lake Utah 49035 10629 106
276034 2020-06-27 Salt Lake Utah 49035 10458 106
272966 2020-06-26 Salt Lake Utah 49035 10163 106
269898 2020-06-25 Salt Lake Utah 49035 9830 105
266838 2020-06-24 Salt Lake Utah 49035 9501 105
263784 2020-06-23 Salt Lake Utah 49035 9252 105
260734 2020-06-22 Salt Lake Utah 49035 9073 102
257685 2020-06-21 Salt Lake Utah 49035 8878 102
254638 2020-06-20 Salt Lake Utah 49035 8713 102
251591 2020-06-19 Salt Lake Utah 49035 8404 102
248554 2020-06-18 Salt Lake Utah 49035 8140 100
245519 2020-06-17 Salt Lake Utah 49035 7846 99
242486 2020-06-16 Salt Lake Utah 49035 7644 96
239454 2020-06-15 Salt Lake Utah 49035 7506 95
236423 2020-06-14 Salt Lake Utah 49035 7309 93
233395 2020-06-13 Salt Lake Utah 49035 7187 93
230368 2020-06-12 Salt Lake Utah 49035 6966 93
227342 2020-06-11 Salt Lake Utah 49035 6783 87
224318 2020-06-10 Salt Lake Utah 49035 6619 85
221297 2020-06-09 Salt Lake Utah 49035 6437 85
218281 2020-06-08 Salt Lake Utah 49035 6313 83
215269 2020-06-07 Salt Lake Utah 49035 6182 81
212259 2020-06-06 Salt Lake Utah 49035 6096 81
209252 2020-06-05 Salt Lake Utah 49035 5918 81
206247 2020-06-04 Salt Lake Utah 49035 5760 78
203246 2020-06-03 Salt Lake Utah 49035 5621 78
200248 2020-06-02 Salt Lake Utah 49035 5449 74
197253 2020-06-01 Salt Lake Utah 49035 5340 74
194261 2020-05-31 Salt Lake Utah 49035 5242 74
191272 2020-05-30 Salt Lake Utah 49035 5118 74
188287 2020-05-29 Salt Lake Utah 49035 4994 71
185304 2020-05-28 Salt Lake Utah 49035 4806 71
182327 2020-05-27 Salt Lake Utah 49035 4682 71
179356 2020-05-26 Salt Lake Utah 49035 4632 70
176392 2020-05-25 Salt Lake Utah 49035 4583 68
173427 2020-05-24 Salt Lake Utah 49035 4515 68
170464 2020-05-23 Salt Lake Utah 49035 4441 68
167503 2020-05-22 Salt Lake Utah 49035 4308 65
164547 2020-05-21 Salt Lake Utah 49035 4217 65
161598 2020-05-20 Salt Lake Utah 49035 4123 62
158650 2020-05-19 Salt Lake Utah 49035 4019 62
155706 2020-05-18 Salt Lake Utah 49035 3942 56
152769 2020-05-17 Salt Lake Utah 49035 3883 56
149838 2020-05-16 Salt Lake Utah 49035 3785 55
146910 2020-05-15 Salt Lake Utah 49035 3717 55
143985 2020-05-14 Salt Lake Utah 49035 3609 52
141067 2020-05-13 Salt Lake Utah 49035 3530 52
138150 2020-05-12 Salt Lake Utah 49035 3425 51
135239 2020-05-11 Salt Lake Utah 49035 3370 48
132327 2020-05-10 Salt Lake Utah 49035 3291 44
129416 2020-05-09 Salt Lake Utah 49035 3206 44
126506 2020-05-08 Salt Lake Utah 49035 3104 39
123600 2020-05-07 Salt Lake Utah 49035 3010 39
120699 2020-05-06 Salt Lake Utah 49035 2919 38
117814 2020-05-05 Salt Lake Utah 49035 2832 35
114934 2020-05-04 Salt Lake Utah 49035 2769 31
112055 2020-05-03 Salt Lake Utah 49035 2707 31
109185 2020-05-02 Salt Lake Utah 49035 2609 30
106320 2020-05-01 Salt Lake Utah 49035 2526 30
103460 2020-04-30 Salt Lake Utah 49035 2438 29
100609 2020-04-29 Salt Lake Utah 49035 2348 28
97763 2020-04-28 Salt Lake Utah 49035 2256 28
94924 2020-04-27 Salt Lake Utah 49035 2190 24
92098 2020-04-26 Salt Lake Utah 49035 2144 25
89284 2020-04-25 Salt Lake Utah 49035 2051 25
86472 2020-04-24 Salt Lake Utah 49035 1975 23
83668 2020-04-23 Salt Lake Utah 49035 1889 20
80870 2020-04-22 Salt Lake Utah 49035 1795 19
78081 2020-04-21 Salt Lake Utah 49035 1714 18
75302 2020-04-20 Salt Lake Utah 49035 1671 15
72529 2020-04-19 Salt Lake Utah 49035 1615 15
69762 2020-04-18 Salt Lake Utah 49035 1547 13
67004 2020-04-17 Salt Lake Utah 49035 1456 12
64259 2020-04-16 Salt Lake Utah 49035 1377 12
61530 2020-04-15 Salt Lake Utah 49035 1285 7
58815 2020-04-14 Salt Lake Utah 49035 1187 7
56112 2020-04-13 Salt Lake Utah 49035 1157 7
53426 2020-04-12 Salt Lake Utah 49035 1126 7
50754 2020-04-11 Salt Lake Utah 49035 1071 7
48099 2020-04-10 Salt Lake Utah 49035 1011 7
45478 2020-04-09 Salt Lake Utah 49035 935 7
42887 2020-04-08 Salt Lake Utah 49035 868 7
40322 2020-04-07 Salt Lake Utah 49035 807 1
37796 2020-04-06 Salt Lake Utah 49035 741 1
35318 2020-04-05 Salt Lake Utah 49035 741 1
32880 2020-04-04 Salt Lake Utah 49035 650 1
30482 2020-04-03 Salt Lake Utah 49035 541 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1060.939ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette