ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 8069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 240 ✖
- 248 41
- 29 22
- 55 20
- 19 18
- 227 17
- 0 16
- 478 15
- 231 14
- 459 14
- 21 12
- 240 12
- 35 11
- 37 11
- 28 10
- 27 9
- 30 9
- 233 9
- 250 9
- 483 9
- 9 8
- 63 8
- 245 8
- 32 7
- 57 7
- 222 7
- 242 7
- 249 7
- 460 7
- 462 7
- 44 6
- 79 6
- 229 6
- 277 6
- 8 5
- 42 5
- 52 5
- 176 5
- 224 5
- 226 5
- 230 5
- 243 5
- 396 5
- 410 5
- 479 5
- 31 4
- 49 4
- 66 4
- 128 4
- 208 4
- 235 4
- 244 4
- 251 4
- 261 4
- 278 4
- 284 4
- 313 4
- 319 4
- 378 4
- 391 4
- 403 4
- 420 4
- 436 4
- 454 4
- 458 4
- 477 4
- 480 4
- 502 4
- 503 4
- 1 3
- 7 3
- 18 3
- 36 3
- 46 3
- 50 3
- 56 3
- 60 3
- 75 3
- 182 3
- 192 3
- 214 3
- 246 3
- 252 3
- 255 3
- 265 3
- 275 3
- 282 3
- 287 3
- 292 3
- 303 3
- 336 3
- 353 3
- 365 3
- 386 3
- 399 3
- 400 3
- 435 3
- 484 3
- 3 2
- 12 2
- 13 2
- 34 2
- 39 2
- 43 2
- 45 2
- 53 2
- 54 2
- 59 2
- 64 2
- 74 2
- 92 2
- 95 2
- 112 2
- 154 2
- 175 2
- 212 2
- 218 2
- 219 2
- 225 2
- 260 2
- 263 2
- 264 2
- 272 2
- 291 2
- 298 2
- 314 2
- 325 2
- 382 2
- 395 2
- 401 2
- 416 2
- 418 2
- 424 2
- 427 2
- 431 2
- 448 2
- 457 2
- 500 2
- 4 1
- 6 1
- 10 1
- 14 1
- 15 1
- 22 1
- 33 1
- 38 1
- 47 1
- 48 1
- 51 1
- 61 1
- 65 1
- 67 1
- 69 1
- 73 1
- 76 1
- 86 1
- 89 1
- 98 1
- 101 1
- 105 1
- 109 1
- 111 1
- 116 1
- 121 1
- 125 1
- 134 1
- 137 1
- 142 1
- 147 1
- 148 1
- 150 1
- 151 1
- 164 1
- 166 1
- 167 1
- 169 1
- 170 1
- 171 1
- 177 1
- 179 1
- 180 1
- 181 1
- 186 1
- 189 1
- 196 1
- 198 1
- 199 1
- 201 1
- 204 1
- 209 1
- 213 1
- 215 1
- 217 1
- 221 1
- 228 1
- 232 1
- 234 1
- 238 1
- 241 1
- 247 1
- 254 1
- 259 1
- 267 1
- 268 1
- 276 1
- 288 1
- 290 1
- 300 1
- 302 1
- 305 1
- 306 1
- 309 1
- 312 1
- 327 1
- 332 1
- 342 1
- 345 1
- 348 1
- 351 1
- 355 1
- 361 1
- 364 1
- 367 1
- 369 1
- 373 1
- 375 1
- 379 1
- 384 1
- 387 1
- 389 1
- 390 1
- 393 1
- 402 1
- 408 1
- 409 1
- 452 1
- 456 1
- 481 1
- 501 1
- 505 1
- 507 1
state 1
- Colorado 796
fips 1
- 8069 · 796 ✖
county 1
- Larimer 796
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499855 | 2499855 | 2022-05-13 | Larimer | Colorado | 8069 | 81210 | 505 |
2496597 | 2496597 | 2022-05-12 | Larimer | Colorado | 8069 | 81056 | 503 |
2493339 | 2493339 | 2022-05-11 | Larimer | Colorado | 8069 | 80284 | 503 |
2490081 | 2490081 | 2022-05-10 | Larimer | Colorado | 8069 | 80142 | 503 |
2486824 | 2486824 | 2022-05-09 | Larimer | Colorado | 8069 | 80033 | 502 |
2483566 | 2483566 | 2022-05-08 | Larimer | Colorado | 8069 | 79808 | 502 |
2480308 | 2480308 | 2022-05-07 | Larimer | Colorado | 8069 | 79808 | 502 |
2477050 | 2477050 | 2022-05-06 | Larimer | Colorado | 8069 | 79808 | 502 |
2473792 | 2473792 | 2022-05-05 | Larimer | Colorado | 8069 | 79693 | 501 |
2470535 | 2470535 | 2022-05-04 | Larimer | Colorado | 8069 | 79585 | 500 |
2467279 | 2467279 | 2022-05-03 | Larimer | Colorado | 8069 | 79486 | 500 |
2464024 | 2464024 | 2022-05-02 | Larimer | Colorado | 8069 | 79420 | 483 |
2460768 | 2460768 | 2022-05-01 | Larimer | Colorado | 8069 | 79267 | 484 |
2457512 | 2457512 | 2022-04-30 | Larimer | Colorado | 8069 | 79267 | 484 |
2454256 | 2454256 | 2022-04-29 | Larimer | Colorado | 8069 | 79267 | 484 |
2451000 | 2451000 | 2022-04-28 | Larimer | Colorado | 8069 | 79183 | 483 |
2447744 | 2447744 | 2022-04-27 | Larimer | Colorado | 8069 | 79109 | 483 |
2444488 | 2444488 | 2022-04-26 | Larimer | Colorado | 8069 | 78975 | 483 |
2441232 | 2441232 | 2022-04-25 | Larimer | Colorado | 8069 | 78883 | 481 |
2437976 | 2437976 | 2022-04-24 | Larimer | Colorado | 8069 | 78628 | 480 |
2434720 | 2434720 | 2022-04-23 | Larimer | Colorado | 8069 | 78628 | 480 |
2431464 | 2431464 | 2022-04-22 | Larimer | Colorado | 8069 | 78628 | 480 |
2428208 | 2428208 | 2022-04-21 | Larimer | Colorado | 8069 | 78500 | 479 |
2424952 | 2424952 | 2022-04-20 | Larimer | Colorado | 8069 | 78368 | 480 |
2421696 | 2421696 | 2022-04-19 | Larimer | Colorado | 8069 | 78211 | 483 |
2418440 | 2418440 | 2022-04-18 | Larimer | Colorado | 8069 | 78111 | 483 |
2415184 | 2415184 | 2022-04-17 | Larimer | Colorado | 8069 | 77879 | 483 |
2411928 | 2411928 | 2022-04-16 | Larimer | Colorado | 8069 | 77879 | 483 |
2408672 | 2408672 | 2022-04-15 | Larimer | Colorado | 8069 | 77879 | 483 |
2405416 | 2405416 | 2022-04-14 | Larimer | Colorado | 8069 | 77761 | 479 |
2402161 | 2402161 | 2022-04-13 | Larimer | Colorado | 8069 | 77637 | 507 |
2398906 | 2398906 | 2022-04-12 | Larimer | Colorado | 8069 | 77505 | 503 |
2395651 | 2395651 | 2022-04-11 | Larimer | Colorado | 8069 | 77446 | 478 |
2392395 | 2392395 | 2022-04-10 | Larimer | Colorado | 8069 | 77220 | 478 |
2389139 | 2389139 | 2022-04-09 | Larimer | Colorado | 8069 | 77220 | 478 |
2385884 | 2385884 | 2022-04-08 | Larimer | Colorado | 8069 | 77220 | 478 |
2382629 | 2382629 | 2022-04-07 | Larimer | Colorado | 8069 | 77082 | 478 |
2379374 | 2379374 | 2022-04-06 | Larimer | Colorado | 8069 | 77005 | 478 |
2376120 | 2376120 | 2022-04-05 | Larimer | Colorado | 8069 | 76831 | 478 |
2372868 | 2372868 | 2022-04-04 | Larimer | Colorado | 8069 | 76764 | 478 |
2369615 | 2369615 | 2022-04-03 | Larimer | Colorado | 8069 | 76644 | 478 |
2366362 | 2366362 | 2022-04-02 | Larimer | Colorado | 8069 | 76644 | 478 |
2363109 | 2363109 | 2022-04-01 | Larimer | Colorado | 8069 | 76644 | 478 |
2359855 | 2359855 | 2022-03-31 | Larimer | Colorado | 8069 | 76538 | 478 |
2356601 | 2356601 | 2022-03-30 | Larimer | Colorado | 8069 | 76412 | 478 |
2353348 | 2353348 | 2022-03-29 | Larimer | Colorado | 8069 | 76105 | 478 |
2350096 | 2350096 | 2022-03-28 | Larimer | Colorado | 8069 | 76011 | 478 |
2346843 | 2346843 | 2022-03-27 | Larimer | Colorado | 8069 | 75877 | 479 |
2343590 | 2343590 | 2022-03-26 | Larimer | Colorado | 8069 | 75877 | 479 |
2340337 | 2340337 | 2022-03-25 | Larimer | Colorado | 8069 | 75877 | 479 |
2337084 | 2337084 | 2022-03-24 | Larimer | Colorado | 8069 | 75722 | 477 |
2333830 | 2333830 | 2022-03-23 | Larimer | Colorado | 8069 | 75612 | 477 |
2330576 | 2330576 | 2022-03-22 | Larimer | Colorado | 8069 | 75499 | 477 |
2327324 | 2327324 | 2022-03-21 | Larimer | Colorado | 8069 | 75349 | 477 |
2324071 | 2324071 | 2022-03-20 | Larimer | Colorado | 8069 | 75107 | 462 |
2320817 | 2320817 | 2022-03-19 | Larimer | Colorado | 8069 | 75107 | 462 |
2317563 | 2317563 | 2022-03-18 | Larimer | Colorado | 8069 | 75107 | 462 |
2314310 | 2314310 | 2022-03-17 | Larimer | Colorado | 8069 | 75107 | 462 |
2311057 | 2311057 | 2022-03-16 | Larimer | Colorado | 8069 | 74943 | 462 |
2307804 | 2307804 | 2022-03-15 | Larimer | Colorado | 8069 | 74758 | 462 |
2304553 | 2304553 | 2022-03-14 | Larimer | Colorado | 8069 | 74671 | 462 |
2301301 | 2301301 | 2022-03-13 | Larimer | Colorado | 8069 | 74557 | 460 |
2298049 | 2298049 | 2022-03-12 | Larimer | Colorado | 8069 | 74557 | 460 |
2294797 | 2294797 | 2022-03-11 | Larimer | Colorado | 8069 | 74557 | 460 |
2291545 | 2291545 | 2022-03-10 | Larimer | Colorado | 8069 | 74498 | 460 |
2288293 | 2288293 | 2022-03-09 | Larimer | Colorado | 8069 | 74402 | 460 |
2285042 | 2285042 | 2022-03-08 | Larimer | Colorado | 8069 | 74332 | 460 |
2281790 | 2281790 | 2022-03-07 | Larimer | Colorado | 8069 | 74296 | 460 |
2278537 | 2278537 | 2022-03-06 | Larimer | Colorado | 8069 | 74106 | 459 |
2275284 | 2275284 | 2022-03-05 | Larimer | Colorado | 8069 | 74106 | 459 |
2272031 | 2272031 | 2022-03-04 | Larimer | Colorado | 8069 | 74106 | 459 |
2268779 | 2268779 | 2022-03-03 | Larimer | Colorado | 8069 | 74011 | 459 |
2265526 | 2265526 | 2022-03-02 | Larimer | Colorado | 8069 | 73931 | 459 |
2262275 | 2262275 | 2022-03-01 | Larimer | Colorado | 8069 | 73856 | 459 |
2259024 | 2259024 | 2022-02-28 | Larimer | Colorado | 8069 | 73769 | 459 |
2255773 | 2255773 | 2022-02-27 | Larimer | Colorado | 8069 | 73531 | 459 |
2252522 | 2252522 | 2022-02-26 | Larimer | Colorado | 8069 | 73531 | 459 |
2249271 | 2249271 | 2022-02-25 | Larimer | Colorado | 8069 | 73531 | 459 |
2246020 | 2246020 | 2022-02-24 | Larimer | Colorado | 8069 | 73422 | 459 |
2242769 | 2242769 | 2022-02-23 | Larimer | Colorado | 8069 | 73297 | 459 |
2239518 | 2239518 | 2022-02-22 | Larimer | Colorado | 8069 | 73164 | 459 |
2236267 | 2236267 | 2022-02-21 | Larimer | Colorado | 8069 | 73090 | 459 |
2233016 | 2233016 | 2022-02-20 | Larimer | Colorado | 8069 | 72813 | 458 |
2229765 | 2229765 | 2022-02-19 | Larimer | Colorado | 8069 | 72813 | 458 |
2226514 | 2226514 | 2022-02-18 | Larimer | Colorado | 8069 | 72813 | 458 |
2223263 | 2223263 | 2022-02-17 | Larimer | Colorado | 8069 | 72639 | 458 |
2220012 | 2220012 | 2022-02-16 | Larimer | Colorado | 8069 | 72462 | 457 |
2216761 | 2216761 | 2022-02-15 | Larimer | Colorado | 8069 | 72268 | 457 |
2213510 | 2213510 | 2022-02-14 | Larimer | Colorado | 8069 | 72117 | 456 |
2210258 | 2210258 | 2022-02-13 | Larimer | Colorado | 8069 | 71780 | 454 |
2207005 | 2207005 | 2022-02-12 | Larimer | Colorado | 8069 | 71780 | 454 |
2203752 | 2203752 | 2022-02-11 | Larimer | Colorado | 8069 | 71780 | 454 |
2200499 | 2200499 | 2022-02-10 | Larimer | Colorado | 8069 | 71579 | 454 |
2197245 | 2197245 | 2022-02-09 | Larimer | Colorado | 8069 | 71346 | 452 |
2193991 | 2193991 | 2022-02-08 | Larimer | Colorado | 8069 | 71109 | 448 |
2190737 | 2190737 | 2022-02-07 | Larimer | Colorado | 8069 | 70940 | 448 |
2187484 | 2187484 | 2022-02-06 | Larimer | Colorado | 8069 | 70483 | 436 |
2184231 | 2184231 | 2022-02-05 | Larimer | Colorado | 8069 | 70483 | 436 |
2180979 | 2180979 | 2022-02-04 | Larimer | Colorado | 8069 | 70483 | 436 |
2177728 | 2177728 | 2022-02-03 | Larimer | Colorado | 8069 | 70225 | 436 |
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);