ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,135 rows where county = "Linn" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 294 ✖
- 12 274
- 0 238
- 1 237
- 11 93
- 13 83
- 14 62
- 64 58
- 9 56
- 4 54
- 21 54
- 7 52
- 24 51
- 10 50
- 28 45
- 82 45
- 23 43
- 27 42
- 81 39
- 2 35
- 58 33
- 22 32
- 59 32
- 15 31
- 62 31
- 17 30
- 342 29
- 57 28
- 26 27
- 268 26
- 80 24
- 87 24
- 20 23
- 25 22
- 61 20
- 18 19
- 56 17
- 63 15
- 32 14
- 83 14
- 339 14
- 346 14
- 579 14
- 581 14
- 8 13
- 338 13
- 79 12
- 50 11
- 85 11
- 60 10
- 132 10
- 305 10
- 76 9
- 77 9
- 94 9
- 221 9
- 222 9
- 3 8
- 6 8
- 88 8
- 335 8
- 51 7
- 54 7
- 55 7
- 89 7
- 206 7
- 217 7
- 225 7
- 228 7
- 243 7
- 320 7
- 328 7
- 329 7
- 330 7
- 334 7
- 343 7
- 344 7
- 349 7
- 350 7
- 353 7
- 363 7
- 367 7
- 375 7
- 379 7
- 394 7
- 403 7
- 409 7
- 414 7
- 423 7
- 424 7
- 430 7
- 433 7
- 436 7
- 439 7
- 447 7
- 456 7
- 487 7
- 501 7
- 513 7
- 524 7
- 538 7
- 548 7
- 555 7
- 560 7
- 567 7
- 573 7
- 577 7
- 578 7
- 580 7
- 19 6
- 31 6
- 36 6
- 67 6
- 239 6
- 249 6
- 324 6
- 332 6
- 333 6
- 340 6
- 341 6
- 49 5
- 65 5
- 66 5
- 70 5
- 120 5
- 122 5
- 141 5
- 178 5
- 203 5
- 223 5
- 230 5
- 240 5
- 258 5
- 267 5
- 312 5
- 321 5
- 46 4
- 68 4
- 69 4
- 73 4
- 75 4
- 90 4
- 91 4
- 97 4
- 100 4
- 107 4
- 116 4
- 129 4
- 131 4
- 150 4
- 154 4
- 160 4
- 164 4
- 200 4
- 210 4
- 231 4
- 234 4
- 255 4
- 260 4
- 264 4
- 279 4
- 317 4
- 336 4
- 16 3
- 29 3
- 47 3
- 74 3
- 84 3
- 86 3
- 99 3
- 101 3
- 106 3
- 115 3
- 119 3
- 134 3
- 137 3
- 145 3
- 179 3
- 183 3
- 189 3
- 201 3
- 229 3
- 274 3
- 300 3
- 325 3
- 337 3
- 583 3
- 33 2
- 34 2
- 35 2
- 38 2
- 42 2
- 53 2
- 72 2
- 96 2
- 98 2
- 108 2
- 111 2
- 114 2
- 117 2
- 121 2
- 126 2
- 127 2
- 133 2
- 140 2
- 153 2
- 158 2
- 159 2
- 166 2
- 168 2
- 173 2
- 184 2
- 209 2
- 215 2
- 236 2
- 245 2
- 266 2
- 269 2
- 278 2
- 280 2
- 293 2
- 299 2
- 303 2
- 311 2
- 313 2
- 319 2
- 322 2
- 40 1
- 43 1
- 45 1
- 78 1
- 92 1
- 93 1
- 95 1
- 103 1
- 105 1
- 109 1
- 110 1
- 112 1
- 113 1
- 123 1
- 128 1
- 130 1
- 135 1
- 136 1
- 139 1
- 142 1
- 144 1
- 146 1
- 148 1
- 149 1
- 152 1
- 161 1
- 162 1
- 165 1
- 169 1
- 170 1
- 171 1
- 174 1
- 181 1
- 187 1
- 188 1
- 193 1
- 198 1
- 204 1
- 205 1
- 207 1
- 208 1
- 211 1
- 212 1
- 213 1
- 214 1
- 227 1
- 232 1
- 233 1
- 237 1
- 241 1
- 244 1
- 247 1
- 248 1
- 250 1
- 251 1
- 253 1
- 254 1
- 262 1
- 270 1
- 275 1
- 281 1
- 282 1
- 284 1
- 294 1
- 295 1
- 301 1
- 309 1
- 315 1
county 1
- Linn · 3,135 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1302 | 1302 | 2020-03-11 | Linn | Oregon | 41043 | 2 | 0 |
1546 | 1546 | 2020-03-12 | Linn | Oregon | 41043 | 8 | 0 |
1842 | 1842 | 2020-03-13 | Linn | Oregon | 41043 | 8 | 0 |
2203 | 2203 | 2020-03-14 | Linn | Oregon | 41043 | 9 | 0 |
2622 | 2622 | 2020-03-15 | Linn | Oregon | 41043 | 10 | 0 |
3087 | 3087 | 2020-03-16 | Linn | Oregon | 41043 | 10 | 0 |
3616 | 3616 | 2020-03-17 | Linn | Oregon | 41043 | 15 | 0 |
4231 | 4231 | 2020-03-18 | Linn | Oregon | 41043 | 15 | 0 |
4662 | 4662 | 2020-03-19 | Linn | Kansas | 20107 | 1 | 0 |
4970 | 4970 | 2020-03-19 | Linn | Oregon | 41043 | 17 | 0 |
5473 | 5473 | 2020-03-20 | Linn | Kansas | 20107 | 1 | 0 |
5838 | 5838 | 2020-03-20 | Linn | Oregon | 41043 | 19 | 0 |
6404 | 6404 | 2020-03-21 | Linn | Iowa | 19113 | 3 | 0 |
6418 | 6418 | 2020-03-21 | Linn | Kansas | 20107 | 1 | 0 |
6840 | 6840 | 2020-03-21 | Linn | Oregon | 41043 | 19 | 0 |
7466 | 7466 | 2020-03-22 | Linn | Iowa | 19113 | 4 | 0 |
7486 | 7486 | 2020-03-22 | Linn | Kansas | 20107 | 1 | 0 |
7955 | 7955 | 2020-03-22 | Linn | Oregon | 41043 | 19 | 1 |
8625 | 8625 | 2020-03-23 | Linn | Iowa | 19113 | 6 | 0 |
8647 | 8647 | 2020-03-23 | Linn | Kansas | 20107 | 2 | 0 |
9165 | 9165 | 2020-03-23 | Linn | Oregon | 41043 | 20 | 1 |
9904 | 9904 | 2020-03-24 | Linn | Iowa | 19113 | 6 | 0 |
9928 | 9928 | 2020-03-24 | Linn | Kansas | 20107 | 2 | 0 |
10484 | 10484 | 2020-03-24 | Linn | Oregon | 41043 | 20 | 1 |
11301 | 11301 | 2020-03-25 | Linn | Iowa | 19113 | 7 | 0 |
11326 | 11326 | 2020-03-25 | Linn | Kansas | 20107 | 2 | 0 |
11946 | 11946 | 2020-03-25 | Linn | Oregon | 41043 | 25 | 1 |
12865 | 12865 | 2020-03-26 | Linn | Iowa | 19113 | 12 | 0 |
12894 | 12894 | 2020-03-26 | Linn | Kansas | 20107 | 4 | 0 |
13562 | 13562 | 2020-03-26 | Linn | Oregon | 41043 | 26 | 1 |
14557 | 14557 | 2020-03-27 | Linn | Iowa | 19113 | 22 | 0 |
14594 | 14594 | 2020-03-27 | Linn | Kansas | 20107 | 4 | 0 |
15307 | 15307 | 2020-03-27 | Linn | Oregon | 41043 | 28 | 1 |
16362 | 16362 | 2020-03-28 | Linn | Iowa | 19113 | 36 | 0 |
16401 | 16401 | 2020-03-28 | Linn | Kansas | 20107 | 4 | 0 |
17154 | 17154 | 2020-03-28 | Linn | Oregon | 41043 | 32 | 1 |
18267 | 18267 | 2020-03-29 | Linn | Iowa | 19113 | 42 | 1 |
18307 | 18307 | 2020-03-29 | Linn | Kansas | 20107 | 5 | 0 |
19092 | 19092 | 2020-03-29 | Linn | Oregon | 41043 | 36 | 1 |
20278 | 20278 | 2020-03-30 | Linn | Iowa | 19113 | 71 | 2 |
20320 | 20320 | 2020-03-30 | Linn | Kansas | 20107 | 5 | 0 |
21142 | 21142 | 2020-03-30 | Linn | Oregon | 41043 | 36 | 2 |
22374 | 22374 | 2020-03-31 | Linn | Iowa | 19113 | 90 | 2 |
22419 | 22419 | 2020-03-31 | Linn | Kansas | 20107 | 5 | 0 |
23275 | 23275 | 2020-03-31 | Linn | Oregon | 41043 | 37 | 2 |
24546 | 24546 | 2020-04-01 | Linn | Iowa | 19113 | 94 | 2 |
24594 | 24594 | 2020-04-01 | Linn | Kansas | 20107 | 5 | 0 |
25473 | 25473 | 2020-04-01 | Linn | Oregon | 41043 | 37 | 2 |
26788 | 26788 | 2020-04-02 | Linn | Iowa | 19113 | 105 | 4 |
26838 | 26838 | 2020-04-02 | Linn | Kansas | 20107 | 5 | 0 |
27745 | 27745 | 2020-04-02 | Linn | Oregon | 41043 | 37 | 2 |
29099 | 29099 | 2020-04-03 | Linn | Iowa | 19113 | 118 | 4 |
29152 | 29152 | 2020-04-03 | Linn | Kansas | 20107 | 5 | 0 |
29613 | 29613 | 2020-04-03 | Linn | Missouri | 29115 | 1 | 0 |
30078 | 30078 | 2020-04-03 | Linn | Oregon | 41043 | 37 | 2 |
31470 | 31470 | 2020-04-04 | Linn | Iowa | 19113 | 139 | 4 |
31526 | 31526 | 2020-04-04 | Linn | Kansas | 20107 | 6 | 0 |
31993 | 31993 | 2020-04-04 | Linn | Missouri | 29115 | 1 | 0 |
32468 | 32468 | 2020-04-04 | Linn | Oregon | 41043 | 41 | 2 |
33883 | 33883 | 2020-04-05 | Linn | Iowa | 19113 | 161 | 6 |
33940 | 33940 | 2020-04-05 | Linn | Kansas | 20107 | 6 | 0 |
34421 | 34421 | 2020-04-05 | Linn | Missouri | 29115 | 1 | 0 |
34902 | 34902 | 2020-04-05 | Linn | Oregon | 41043 | 43 | 2 |
36338 | 36338 | 2020-04-06 | Linn | Iowa | 19113 | 176 | 8 |
36397 | 36397 | 2020-04-06 | Linn | Kansas | 20107 | 6 | 0 |
36885 | 36885 | 2020-04-06 | Linn | Missouri | 29115 | 2 | 0 |
37377 | 37377 | 2020-04-06 | Linn | Oregon | 41043 | 44 | 2 |
38839 | 38839 | 2020-04-07 | Linn | Iowa | 19113 | 186 | 8 |
38899 | 38899 | 2020-04-07 | Linn | Kansas | 20107 | 6 | 0 |
39398 | 39398 | 2020-04-07 | Linn | Missouri | 29115 | 3 | 0 |
39898 | 39898 | 2020-04-07 | Linn | Oregon | 41043 | 45 | 2 |
41385 | 41385 | 2020-04-08 | Linn | Iowa | 19113 | 197 | 9 |
41446 | 41446 | 2020-04-08 | Linn | Kansas | 20107 | 6 | 0 |
41952 | 41952 | 2020-04-08 | Linn | Missouri | 29115 | 3 | 0 |
42458 | 42458 | 2020-04-08 | Linn | Oregon | 41043 | 46 | 2 |
43961 | 43961 | 2020-04-09 | Linn | Iowa | 19113 | 215 | 9 |
44022 | 44022 | 2020-04-09 | Linn | Kansas | 20107 | 6 | 0 |
44529 | 44529 | 2020-04-09 | Linn | Missouri | 29115 | 3 | 0 |
45044 | 45044 | 2020-04-09 | Linn | Oregon | 41043 | 49 | 4 |
46566 | 46566 | 2020-04-10 | Linn | Iowa | 19113 | 225 | 12 |
46629 | 46629 | 2020-04-10 | Linn | Kansas | 20107 | 6 | 0 |
47138 | 47138 | 2020-04-10 | Linn | Missouri | 29115 | 3 | 0 |
47661 | 47661 | 2020-04-10 | Linn | Oregon | 41043 | 49 | 4 |
49200 | 49200 | 2020-04-11 | Linn | Iowa | 19113 | 235 | 12 |
49265 | 49265 | 2020-04-11 | Linn | Kansas | 20107 | 6 | 0 |
49786 | 49786 | 2020-04-11 | Linn | Missouri | 29115 | 3 | 0 |
50318 | 50318 | 2020-04-11 | Linn | Oregon | 41043 | 51 | 4 |
51864 | 51864 | 2020-04-12 | Linn | Iowa | 19113 | 243 | 18 |
51930 | 51930 | 2020-04-12 | Linn | Kansas | 20107 | 6 | 0 |
52459 | 52459 | 2020-04-12 | Linn | Missouri | 29115 | 3 | 0 |
52991 | 52991 | 2020-04-12 | Linn | Oregon | 41043 | 52 | 4 |
54546 | 54546 | 2020-04-13 | Linn | Iowa | 19113 | 258 | 19 |
54612 | 54612 | 2020-04-13 | Linn | Kansas | 20107 | 6 | 0 |
55141 | 55141 | 2020-04-13 | Linn | Missouri | 29115 | 4 | 1 |
55676 | 55676 | 2020-04-13 | Linn | Oregon | 41043 | 52 | 4 |
57239 | 57239 | 2020-04-14 | Linn | Iowa | 19113 | 265 | 19 |
57306 | 57306 | 2020-04-14 | Linn | Kansas | 20107 | 6 | 0 |
57839 | 57839 | 2020-04-14 | Linn | Missouri | 29115 | 5 | 1 |
58379 | 58379 | 2020-04-14 | Linn | Oregon | 41043 | 52 | 4 |
59947 | 59947 | 2020-04-15 | Linn | Iowa | 19113 | 276 | 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);