ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 2020 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 176 ✖
- 4 62
- 174 36
- 6 21
- 171 21
- 161 20
- 0 15
- 8 14
- 419 14
- 499 14
- 507 14
- 9 12
- 169 11
- 179 11
- 139 10
- 149 10
- 176 9
- 50 8
- 2 7
- 14 7
- 16 7
- 28 7
- 152 7
- 158 7
- 175 7
- 215 7
- 394 7
- 417 7
- 462 7
- 469 7
- 481 7
- 489 7
- 498 7
- 504 7
- 510 7
- 519 7
- 520 7
- 521 7
- 21 6
- 25 6
- 27 6
- 36 6
- 38 6
- 41 6
- 42 6
- 127 6
- 159 6
- 207 6
- 393 6
- 13 5
- 116 5
- 124 5
- 150 5
- 151 5
- 160 5
- 180 5
- 191 5
- 373 5
- 412 5
- 426 5
- 444 5
- 458 5
- 35 4
- 65 4
- 121 4
- 183 4
- 189 4
- 199 4
- 274 4
- 280 4
- 294 4
- 381 4
- 391 4
- 3 3
- 5 3
- 15 3
- 59 3
- 61 3
- 67 3
- 96 3
- 104 3
- 157 3
- 162 3
- 177 3
- 190 3
- 220 3
- 230 3
- 248 3
- 293 3
- 319 3
- 331 3
- 342 3
- 379 3
- 526 3
- 1 2
- 12 2
- 23 2
- 24 2
- 31 2
- 43 2
- 49 2
- 57 2
- 60 2
- 63 2
- 68 2
- 78 2
- 80 2
- 103 2
- 117 2
- 118 2
- 138 2
- 181 2
- 198 2
- 219 2
- 229 2
- 316 2
- 329 2
- 338 2
- 387 2
- 392 2
- 395 2
- 424 2
- 452 2
- 454 2
- 7 1
- 10 1
- 11 1
- 20 1
- 26 1
- 37 1
- 40 1
- 46 1
- 48 1
- 55 1
- 58 1
- 73 1
- 77 1
- 81 1
- 85 1
- 86 1
- 99 1
- 101 1
- 112 1
- 115 1
- 123 1
- 125 1
- 126 1
- 137 1
- 156 1
- 173 1
- 185 1
- 187 1
- 195 1
- 204 1
- 212 1
- 221 1
- 227 1
- 232 1
- 236 1
- 237 1
- 238 1
- 257 1
- 264 1
- 268 1
- 273 1
- 275 1
- 278 1
- 283 1
- 312 1
- 322 1
- 328 1
- 333 1
- 341 1
- 366 1
- 368 1
- 375 1
- 383 1
state 1
- Alaska 793
fips 1
- 2020 · 793 ✖
county 1
- Anchorage 793
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1365 | 1365 | 2020-03-12 | Anchorage | Alaska | 2020 | 1 | 0 |
1625 | 1625 | 2020-03-13 | Anchorage | Alaska | 2020 | 1 | 0 |
1941 | 1941 | 2020-03-14 | Anchorage | Alaska | 2020 | 1 | 0 |
2318 | 2318 | 2020-03-15 | Anchorage | Alaska | 2020 | 1 | 0 |
2747 | 2747 | 2020-03-16 | Anchorage | Alaska | 2020 | 1 | 0 |
3225 | 3225 | 2020-03-17 | Anchorage | Alaska | 2020 | 2 | 0 |
3773 | 3773 | 2020-03-18 | Anchorage | Alaska | 2020 | 4 | 0 |
4416 | 4416 | 2020-03-19 | Anchorage | Alaska | 2020 | 4 | 0 |
5187 | 5187 | 2020-03-20 | Anchorage | Alaska | 2020 | 4 | 0 |
6104 | 6104 | 2020-03-21 | Anchorage | Alaska | 2020 | 5 | 0 |
7138 | 7138 | 2020-03-22 | Anchorage | Alaska | 2020 | 6 | 0 |
8279 | 8279 | 2020-03-23 | Anchorage | Alaska | 2020 | 17 | 0 |
9507 | 9507 | 2020-03-24 | Anchorage | Alaska | 2020 | 17 | 0 |
10877 | 10877 | 2020-03-25 | Anchorage | Alaska | 2020 | 28 | 0 |
12416 | 12416 | 2020-03-26 | Anchorage | Alaska | 2020 | 33 | 0 |
14079 | 14079 | 2020-03-27 | Anchorage | Alaska | 2020 | 43 | 1 |
15858 | 15858 | 2020-03-28 | Anchorage | Alaska | 2020 | 54 | 1 |
17742 | 17742 | 2020-03-29 | Anchorage | Alaska | 2020 | 59 | 2 |
19715 | 19715 | 2020-03-30 | Anchorage | Alaska | 2020 | 61 | 2 |
21787 | 21787 | 2020-03-31 | Anchorage | Alaska | 2020 | 65 | 2 |
26165 | 26165 | 2020-04-02 | Anchorage | Alaska | 2020 | 66 | 2 |
23943 | 23943 | 2020-04-01 | Anchorage | Alaska | 2020 | 67 | 2 |
28462 | 28462 | 2020-04-03 | Anchorage | Alaska | 2020 | 73 | 2 |
30819 | 30819 | 2020-04-04 | Anchorage | Alaska | 2020 | 81 | 2 |
33223 | 33223 | 2020-04-05 | Anchorage | Alaska | 2020 | 85 | 3 |
35662 | 35662 | 2020-04-06 | Anchorage | Alaska | 2020 | 88 | 3 |
38150 | 38150 | 2020-04-07 | Anchorage | Alaska | 2020 | 98 | 3 |
40692 | 40692 | 2020-04-08 | Anchorage | Alaska | 2020 | 103 | 4 |
43266 | 43266 | 2020-04-09 | Anchorage | Alaska | 2020 | 109 | 4 |
45864 | 45864 | 2020-04-10 | Anchorage | Alaska | 2020 | 112 | 4 |
48493 | 48493 | 2020-04-11 | Anchorage | Alaska | 2020 | 121 | 4 |
51155 | 51155 | 2020-04-12 | Anchorage | Alaska | 2020 | 127 | 4 |
53833 | 53833 | 2020-04-13 | Anchorage | Alaska | 2020 | 131 | 4 |
56525 | 56525 | 2020-04-14 | Anchorage | Alaska | 2020 | 136 | 4 |
59233 | 59233 | 2020-04-15 | Anchorage | Alaska | 2020 | 139 | 4 |
61951 | 61951 | 2020-04-16 | Anchorage | Alaska | 2020 | 143 | 4 |
64684 | 64684 | 2020-04-17 | Anchorage | Alaska | 2020 | 150 | 4 |
67432 | 67432 | 2020-04-18 | Anchorage | Alaska | 2020 | 151 | 4 |
70194 | 70194 | 2020-04-19 | Anchorage | Alaska | 2020 | 154 | 4 |
72963 | 72963 | 2020-04-20 | Anchorage | Alaska | 2020 | 155 | 4 |
75739 | 75739 | 2020-04-21 | Anchorage | Alaska | 2020 | 160 | 4 |
78522 | 78522 | 2020-04-22 | Anchorage | Alaska | 2020 | 164 | 4 |
81315 | 81315 | 2020-04-23 | Anchorage | Alaska | 2020 | 166 | 4 |
84116 | 84116 | 2020-04-24 | Anchorage | Alaska | 2020 | 168 | 4 |
86924 | 86924 | 2020-04-25 | Anchorage | Alaska | 2020 | 168 | 4 |
89740 | 89740 | 2020-04-26 | Anchorage | Alaska | 2020 | 168 | 4 |
92558 | 92558 | 2020-04-27 | Anchorage | Alaska | 2020 | 171 | 4 |
95388 | 95388 | 2020-04-28 | Anchorage | Alaska | 2020 | 175 | 4 |
98233 | 98233 | 2020-04-29 | Anchorage | Alaska | 2020 | 179 | 4 |
101083 | 101083 | 2020-04-30 | Anchorage | Alaska | 2020 | 179 | 4 |
103938 | 103938 | 2020-05-01 | Anchorage | Alaska | 2020 | 185 | 4 |
106803 | 106803 | 2020-05-02 | Anchorage | Alaska | 2020 | 185 | 4 |
109672 | 109672 | 2020-05-03 | Anchorage | Alaska | 2020 | 187 | 4 |
112547 | 112547 | 2020-05-04 | Anchorage | Alaska | 2020 | 189 | 4 |
115430 | 115430 | 2020-05-05 | Anchorage | Alaska | 2020 | 190 | 4 |
118389 | 118389 | 2020-05-06 | Anchorage | Alaska | 2020 | 190 | 4 |
121355 | 121355 | 2020-05-07 | Anchorage | Alaska | 2020 | 191 | 4 |
124335 | 124335 | 2020-05-08 | Anchorage | Alaska | 2020 | 194 | 4 |
127320 | 127320 | 2020-05-09 | Anchorage | Alaska | 2020 | 194 | 4 |
130310 | 130310 | 2020-05-10 | Anchorage | Alaska | 2020 | 194 | 4 |
133300 | 133300 | 2020-05-11 | Anchorage | Alaska | 2020 | 195 | 4 |
136290 | 136290 | 2020-05-12 | Anchorage | Alaska | 2020 | 196 | 4 |
139281 | 139281 | 2020-05-13 | Anchorage | Alaska | 2020 | 196 | 4 |
142277 | 142277 | 2020-05-14 | Anchorage | Alaska | 2020 | 199 | 4 |
145276 | 145276 | 2020-05-15 | Anchorage | Alaska | 2020 | 200 | 4 |
148279 | 148279 | 2020-05-16 | Anchorage | Alaska | 2020 | 202 | 4 |
151288 | 151288 | 2020-05-17 | Anchorage | Alaska | 2020 | 204 | 4 |
154300 | 154300 | 2020-05-18 | Anchorage | Alaska | 2020 | 206 | 4 |
157316 | 157316 | 2020-05-19 | Anchorage | Alaska | 2020 | 206 | 4 |
160340 | 160340 | 2020-05-20 | Anchorage | Alaska | 2020 | 207 | 4 |
163368 | 163368 | 2020-05-21 | Anchorage | Alaska | 2020 | 207 | 4 |
166400 | 166400 | 2020-05-22 | Anchorage | Alaska | 2020 | 207 | 4 |
169436 | 169436 | 2020-05-23 | Anchorage | Alaska | 2020 | 207 | 4 |
172477 | 172477 | 2020-05-24 | Anchorage | Alaska | 2020 | 207 | 4 |
175520 | 175520 | 2020-05-25 | Anchorage | Alaska | 2020 | 207 | 4 |
178565 | 178565 | 2020-05-26 | Anchorage | Alaska | 2020 | 210 | 4 |
181609 | 181609 | 2020-05-27 | Anchorage | Alaska | 2020 | 210 | 4 |
184661 | 184661 | 2020-05-28 | Anchorage | Alaska | 2020 | 214 | 4 |
187718 | 187718 | 2020-05-29 | Anchorage | Alaska | 2020 | 216 | 4 |
190782 | 190782 | 2020-05-30 | Anchorage | Alaska | 2020 | 217 | 4 |
193848 | 193848 | 2020-05-31 | Anchorage | Alaska | 2020 | 232 | 4 |
196918 | 196918 | 2020-06-01 | Anchorage | Alaska | 2020 | 235 | 4 |
199991 | 199991 | 2020-06-02 | Anchorage | Alaska | 2020 | 250 | 4 |
203067 | 203067 | 2020-06-03 | Anchorage | Alaska | 2020 | 258 | 4 |
206147 | 206147 | 2020-06-04 | Anchorage | Alaska | 2020 | 263 | 4 |
209229 | 209229 | 2020-06-05 | Anchorage | Alaska | 2020 | 278 | 4 |
212314 | 212314 | 2020-06-06 | Anchorage | Alaska | 2020 | 282 | 4 |
215401 | 215401 | 2020-06-07 | Anchorage | Alaska | 2020 | 289 | 4 |
218491 | 218491 | 2020-06-08 | Anchorage | Alaska | 2020 | 300 | 4 |
221584 | 221584 | 2020-06-09 | Anchorage | Alaska | 2020 | 305 | 5 |
224680 | 224680 | 2020-06-10 | Anchorage | Alaska | 2020 | 314 | 5 |
227781 | 227781 | 2020-06-11 | Anchorage | Alaska | 2020 | 322 | 5 |
230885 | 230885 | 2020-06-12 | Anchorage | Alaska | 2020 | 331 | 6 |
233990 | 233990 | 2020-06-13 | Anchorage | Alaska | 2020 | 339 | 6 |
237097 | 237097 | 2020-06-14 | Anchorage | Alaska | 2020 | 345 | 6 |
240205 | 240205 | 2020-06-15 | Anchorage | Alaska | 2020 | 346 | 6 |
243316 | 243316 | 2020-06-16 | Anchorage | Alaska | 2020 | 354 | 6 |
246429 | 246429 | 2020-06-17 | Anchorage | Alaska | 2020 | 358 | 6 |
249541 | 249541 | 2020-06-18 | Anchorage | Alaska | 2020 | 362 | 6 |
252656 | 252656 | 2020-06-19 | Anchorage | Alaska | 2020 | 370 | 6 |
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);