ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Jefferson" and fips = 41031 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-05-05 1
- 2020-05-06 1
- 2020-05-07 1
- 2020-05-08 1
- 2020-05-09 1
- 2020-05-10 1
- 2020-05-11 1
- 2020-05-12 1
- 2020-05-13 1
- …
state 1
- Oregon 760
fips 1
- 41031 · 760 ✖
county 1
- Jefferson · 760 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
58374 | 58374 | 2020-04-14 | Jefferson | Oregon | 41031 | 1 | 0 |
61089 | 61089 | 2020-04-15 | Jefferson | Oregon | 41031 | 1 | 0 |
63815 | 63815 | 2020-04-16 | Jefferson | Oregon | 41031 | 1 | 0 |
66561 | 66561 | 2020-04-17 | Jefferson | Oregon | 41031 | 1 | 0 |
69319 | 69319 | 2020-04-18 | Jefferson | Oregon | 41031 | 1 | 0 |
72086 | 72086 | 2020-04-19 | Jefferson | Oregon | 41031 | 1 | 0 |
74861 | 74861 | 2020-04-20 | Jefferson | Oregon | 41031 | 1 | 0 |
77643 | 77643 | 2020-04-21 | Jefferson | Oregon | 41031 | 1 | 0 |
80433 | 80433 | 2020-04-22 | Jefferson | Oregon | 41031 | 2 | 0 |
83232 | 83232 | 2020-04-23 | Jefferson | Oregon | 41031 | 2 | 0 |
86036 | 86036 | 2020-04-24 | Jefferson | Oregon | 41031 | 2 | 0 |
88850 | 88850 | 2020-04-25 | Jefferson | Oregon | 41031 | 5 | 0 |
91666 | 91666 | 2020-04-26 | Jefferson | Oregon | 41031 | 6 | 0 |
94493 | 94493 | 2020-04-27 | Jefferson | Oregon | 41031 | 6 | 0 |
97332 | 97332 | 2020-04-28 | Jefferson | Oregon | 41031 | 6 | 0 |
100181 | 100181 | 2020-04-29 | Jefferson | Oregon | 41031 | 10 | 0 |
103034 | 103034 | 2020-04-30 | Jefferson | Oregon | 41031 | 10 | 0 |
105897 | 105897 | 2020-05-01 | Jefferson | Oregon | 41031 | 10 | 0 |
108764 | 108764 | 2020-05-02 | Jefferson | Oregon | 41031 | 13 | 0 |
111638 | 111638 | 2020-05-03 | Jefferson | Oregon | 41031 | 13 | 0 |
114520 | 114520 | 2020-05-04 | Jefferson | Oregon | 41031 | 14 | 0 |
117401 | 117401 | 2020-05-05 | Jefferson | Oregon | 41031 | 14 | 0 |
120363 | 120363 | 2020-05-06 | Jefferson | Oregon | 41031 | 18 | 0 |
123340 | 123340 | 2020-05-07 | Jefferson | Oregon | 41031 | 22 | 0 |
126323 | 126323 | 2020-05-08 | Jefferson | Oregon | 41031 | 22 | 0 |
129312 | 129312 | 2020-05-09 | Jefferson | Oregon | 41031 | 24 | 0 |
132301 | 132301 | 2020-05-10 | Jefferson | Oregon | 41031 | 24 | 0 |
135292 | 135292 | 2020-05-11 | Jefferson | Oregon | 41031 | 24 | 0 |
138282 | 138282 | 2020-05-12 | Jefferson | Oregon | 41031 | 24 | 0 |
141278 | 141278 | 2020-05-13 | Jefferson | Oregon | 41031 | 24 | 0 |
144274 | 144274 | 2020-05-14 | Jefferson | Oregon | 41031 | 24 | 0 |
147275 | 147275 | 2020-05-15 | Jefferson | Oregon | 41031 | 24 | 0 |
150282 | 150282 | 2020-05-16 | Jefferson | Oregon | 41031 | 24 | 0 |
153293 | 153293 | 2020-05-17 | Jefferson | Oregon | 41031 | 24 | 0 |
156310 | 156310 | 2020-05-18 | Jefferson | Oregon | 41031 | 24 | 0 |
159331 | 159331 | 2020-05-19 | Jefferson | Oregon | 41031 | 24 | 0 |
162358 | 162358 | 2020-05-20 | Jefferson | Oregon | 41031 | 24 | 0 |
165387 | 165387 | 2020-05-21 | Jefferson | Oregon | 41031 | 25 | 0 |
168423 | 168423 | 2020-05-22 | Jefferson | Oregon | 41031 | 25 | 0 |
171462 | 171462 | 2020-05-23 | Jefferson | Oregon | 41031 | 25 | 0 |
174504 | 174504 | 2020-05-24 | Jefferson | Oregon | 41031 | 25 | 0 |
177548 | 177548 | 2020-05-25 | Jefferson | Oregon | 41031 | 24 | 0 |
180591 | 180591 | 2020-05-26 | Jefferson | Oregon | 41031 | 24 | 0 |
183640 | 183640 | 2020-05-27 | Jefferson | Oregon | 41031 | 24 | 0 |
186697 | 186697 | 2020-05-28 | Jefferson | Oregon | 41031 | 25 | 0 |
189758 | 189758 | 2020-05-29 | Jefferson | Oregon | 41031 | 28 | 0 |
192823 | 192823 | 2020-05-30 | Jefferson | Oregon | 41031 | 30 | 0 |
195892 | 195892 | 2020-05-31 | Jefferson | Oregon | 41031 | 33 | 0 |
198965 | 198965 | 2020-06-01 | Jefferson | Oregon | 41031 | 44 | 0 |
202040 | 202040 | 2020-06-02 | Jefferson | Oregon | 41031 | 44 | 0 |
205117 | 205117 | 2020-06-03 | Jefferson | Oregon | 41031 | 45 | 0 |
208198 | 208198 | 2020-06-04 | Jefferson | Oregon | 41031 | 46 | 0 |
211280 | 211280 | 2020-06-05 | Jefferson | Oregon | 41031 | 55 | 0 |
214366 | 214366 | 2020-06-06 | Jefferson | Oregon | 41031 | 57 | 0 |
217456 | 217456 | 2020-06-07 | Jefferson | Oregon | 41031 | 57 | 0 |
220548 | 220548 | 2020-06-08 | Jefferson | Oregon | 41031 | 58 | 0 |
223643 | 223643 | 2020-06-09 | Jefferson | Oregon | 41031 | 58 | 0 |
226743 | 226743 | 2020-06-10 | Jefferson | Oregon | 41031 | 64 | 0 |
229847 | 229847 | 2020-06-11 | Jefferson | Oregon | 41031 | 67 | 0 |
232952 | 232952 | 2020-06-12 | Jefferson | Oregon | 41031 | 65 | 0 |
236057 | 236057 | 2020-06-13 | Jefferson | Oregon | 41031 | 67 | 0 |
239165 | 239165 | 2020-06-14 | Jefferson | Oregon | 41031 | 67 | 0 |
242274 | 242274 | 2020-06-15 | Jefferson | Oregon | 41031 | 68 | 0 |
245386 | 245386 | 2020-06-16 | Jefferson | Oregon | 41031 | 69 | 0 |
248499 | 248499 | 2020-06-17 | Jefferson | Oregon | 41031 | 69 | 0 |
251614 | 251614 | 2020-06-18 | Jefferson | Oregon | 41031 | 73 | 0 |
254729 | 254729 | 2020-06-19 | Jefferson | Oregon | 41031 | 77 | 0 |
257855 | 257855 | 2020-06-20 | Jefferson | Oregon | 41031 | 77 | 0 |
260982 | 260982 | 2020-06-21 | Jefferson | Oregon | 41031 | 78 | 0 |
264110 | 264110 | 2020-06-22 | Jefferson | Oregon | 41031 | 79 | 0 |
267238 | 267238 | 2020-06-23 | Jefferson | Oregon | 41031 | 81 | 0 |
270372 | 270372 | 2020-06-24 | Jefferson | Oregon | 41031 | 84 | 0 |
273511 | 273511 | 2020-06-25 | Jefferson | Oregon | 41031 | 85 | 0 |
276658 | 276658 | 2020-06-26 | Jefferson | Oregon | 41031 | 91 | 0 |
279806 | 279806 | 2020-06-27 | Jefferson | Oregon | 41031 | 94 | 0 |
282952 | 282952 | 2020-06-28 | Jefferson | Oregon | 41031 | 97 | 0 |
286097 | 286097 | 2020-06-29 | Jefferson | Oregon | 41031 | 100 | 0 |
289248 | 289248 | 2020-06-30 | Jefferson | Oregon | 41031 | 112 | 0 |
292400 | 292400 | 2020-07-01 | Jefferson | Oregon | 41031 | 118 | 0 |
295556 | 295556 | 2020-07-02 | Jefferson | Oregon | 41031 | 126 | 0 |
298715 | 298715 | 2020-07-03 | Jefferson | Oregon | 41031 | 131 | 0 |
301879 | 301879 | 2020-07-04 | Jefferson | Oregon | 41031 | 132 | 0 |
305042 | 305042 | 2020-07-05 | Jefferson | Oregon | 41031 | 133 | 0 |
308209 | 308209 | 2020-07-06 | Jefferson | Oregon | 41031 | 134 | 0 |
311378 | 311378 | 2020-07-07 | Jefferson | Oregon | 41031 | 136 | 0 |
314550 | 314550 | 2020-07-08 | Jefferson | Oregon | 41031 | 137 | 0 |
317723 | 317723 | 2020-07-09 | Jefferson | Oregon | 41031 | 145 | 0 |
320901 | 320901 | 2020-07-10 | Jefferson | Oregon | 41031 | 160 | 0 |
324081 | 324081 | 2020-07-11 | Jefferson | Oregon | 41031 | 163 | 0 |
327266 | 327266 | 2020-07-12 | Jefferson | Oregon | 41031 | 168 | 0 |
330452 | 330452 | 2020-07-13 | Jefferson | Oregon | 41031 | 168 | 0 |
333644 | 333644 | 2020-07-14 | Jefferson | Oregon | 41031 | 169 | 0 |
336838 | 336838 | 2020-07-15 | Jefferson | Oregon | 41031 | 171 | 0 |
340035 | 340035 | 2020-07-16 | Jefferson | Oregon | 41031 | 177 | 0 |
343233 | 343233 | 2020-07-17 | Jefferson | Oregon | 41031 | 184 | 0 |
346433 | 346433 | 2020-07-18 | Jefferson | Oregon | 41031 | 185 | 0 |
349633 | 349633 | 2020-07-19 | Jefferson | Oregon | 41031 | 199 | 0 |
352836 | 352836 | 2020-07-20 | Jefferson | Oregon | 41031 | 206 | 0 |
356039 | 356039 | 2020-07-21 | Jefferson | Oregon | 41031 | 214 | 0 |
359243 | 359243 | 2020-07-22 | Jefferson | Oregon | 41031 | 219 | 0 |
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);