ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 291 ✖
- 149 19
- 136 17
- 319 17
- 696 16
- 694 15
- 139 13
- 146 13
- 145 12
- 159 12
- 359 12
- 137 9
- 138 9
- 360 9
- 151 8
- 327 8
- 345 8
- 352 8
- 702 8
- 336 7
- 344 7
- 660 7
- 686 7
- 141 6
- 208 6
- 301 6
- 326 6
- 334 6
- 346 6
- 351 6
- 354 6
- 580 6
- 1 5
- 125 5
- 135 5
- 299 5
- 310 5
- 316 5
- 321 5
- 322 5
- 333 5
- 347 5
- 355 5
- 675 5
- 690 5
- 693 5
- 0 4
- 113 4
- 142 4
- 148 4
- 155 4
- 314 4
- 329 4
- 341 4
- 348 4
- 353 4
- 356 4
- 361 4
- 386 4
- 390 4
- 587 4
- 632 4
- 683 4
- 695 4
- 2 3
- 100 3
- 123 3
- 153 3
- 158 3
- 166 3
- 193 3
- 271 3
- 287 3
- 288 3
- 298 3
- 300 3
- 306 3
- 313 3
- 323 3
- 337 3
- 343 3
- 357 3
- 358 3
- 366 3
- 372 3
- 405 3
- 406 3
- 412 3
- 430 3
- 440 3
- 455 3
- 473 3
- 488 3
- 510 3
- 525 3
- 558 3
- 567 3
- 596 3
- 608 3
- 617 3
- 624 3
- 662 3
- 703 3
- 4 2
- 16 2
- 61 2
- 69 2
- 119 2
- 124 2
- 131 2
- 132 2
- 134 2
- 143 2
- 150 2
- 152 2
- 156 2
- 160 2
- 163 2
- 164 2
- 173 2
- 183 2
- 196 2
- 241 2
- 262 2
- 272 2
- 304 2
- 307 2
- 317 2
- 318 2
- 320 2
- 330 2
- 331 2
- 340 2
- 349 2
- 350 2
- 362 2
- 369 2
- 375 2
- 379 2
- 387 2
- 398 2
- 422 2
- 483 2
- 538 2
- 540 2
- 604 2
- 613 2
- 623 2
- 631 2
- 661 2
- 671 2
- 684 2
- 6 1
- 7 1
- 9 1
- 10 1
- 12 1
- 13 1
- 22 1
- 24 1
- 26 1
- 27 1
- 30 1
- 36 1
- 40 1
- 44 1
- 48 1
- 53 1
- 55 1
- 57 1
- 60 1
- 64 1
- 68 1
- 70 1
- 78 1
- 79 1
- 82 1
- 87 1
- 88 1
- 93 1
- 95 1
- 102 1
- 107 1
- 109 1
- 114 1
- 117 1
- 122 1
- 127 1
- 128 1
- 129 1
- 130 1
- 133 1
- 147 1
- 161 1
- 169 1
- 170 1
- 172 1
- 176 1
- 178 1
- 180 1
- 182 1
- 188 1
- 191 1
- 192 1
- 204 1
- 221 1
- 227 1
- 235 1
- 237 1
- 248 1
- 249 1
- 253 1
- 255 1
- 261 1
- 264 1
- 266 1
- 281 1
- 282 1
- 285 1
- 295 1
- 296 1
- 297 1
- 309 1
- 312 1
- 315 1
- 332 1
- 339 1
- 363 1
- 364 1
- 370 1
- 371 1
- 394 1
- 396 1
- 409 1
- 416 1
- 420 1
- 433 1
- 434 1
- 435 1
- 438 1
- 448 1
- 451 1
- 453 1
- 454 1
- 460 1
- 463 1
- 464 1
- 469 1
- 484 1
- 485 1
- 493 1
- 499 1
- 504 1
- 509 1
- 512 1
- 518 1
- 522 1
- 527 1
- 528 1
- 533 1
- 537 1
- 541 1
- 547 1
- 549 1
- 554 1
- 560 1
- 561 1
- 562 1
- 565 1
- 569 1
- 576 1
- 579 1
- 585 1
- 588 1
- 589 1
- 590 1
- 594 1
- 600 1
- 603 1
- 614 1
- 615 1
- 620 1
- 628 1
- 630 1
- 650 1
- 652 1
- 655 1
- 681 1
- 682 1
- 685 1
- 692 1
- 697 1
state 1
- Colorado 792
fips 1
- 8123 · 792 ✖
county 1
- Weld 792
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499882 | 2499882 | 2022-05-13 | Weld | Colorado | 8123 | 85893 | 703 |
2496624 | 2496624 | 2022-05-12 | Weld | Colorado | 8123 | 85569 | 703 |
2493366 | 2493366 | 2022-05-11 | Weld | Colorado | 8123 | 85522 | 703 |
2490108 | 2490108 | 2022-05-10 | Weld | Colorado | 8123 | 85522 | 702 |
2486851 | 2486851 | 2022-05-09 | Weld | Colorado | 8123 | 85257 | 702 |
2483593 | 2483593 | 2022-05-08 | Weld | Colorado | 8123 | 85257 | 702 |
2480335 | 2480335 | 2022-05-07 | Weld | Colorado | 8123 | 85257 | 702 |
2477077 | 2477077 | 2022-05-06 | Weld | Colorado | 8123 | 85257 | 702 |
2473819 | 2473819 | 2022-05-05 | Weld | Colorado | 8123 | 84955 | 702 |
2470562 | 2470562 | 2022-05-04 | Weld | Colorado | 8123 | 84955 | 702 |
2467306 | 2467306 | 2022-05-03 | Weld | Colorado | 8123 | 84955 | 702 |
2464051 | 2464051 | 2022-05-02 | Weld | Colorado | 8123 | 84702 | 697 |
2460795 | 2460795 | 2022-05-01 | Weld | Colorado | 8123 | 84702 | 696 |
2457539 | 2457539 | 2022-04-30 | Weld | Colorado | 8123 | 84702 | 696 |
2454283 | 2454283 | 2022-04-29 | Weld | Colorado | 8123 | 84702 | 696 |
2451027 | 2451027 | 2022-04-28 | Weld | Colorado | 8123 | 84425 | 696 |
2447771 | 2447771 | 2022-04-27 | Weld | Colorado | 8123 | 84425 | 696 |
2444515 | 2444515 | 2022-04-26 | Weld | Colorado | 8123 | 84425 | 695 |
2441259 | 2441259 | 2022-04-25 | Weld | Colorado | 8123 | 84239 | 695 |
2438003 | 2438003 | 2022-04-24 | Weld | Colorado | 8123 | 84239 | 696 |
2434747 | 2434747 | 2022-04-23 | Weld | Colorado | 8123 | 84239 | 696 |
2431491 | 2431491 | 2022-04-22 | Weld | Colorado | 8123 | 84239 | 696 |
2428235 | 2428235 | 2022-04-21 | Weld | Colorado | 8123 | 83957 | 696 |
2424979 | 2424979 | 2022-04-20 | Weld | Colorado | 8123 | 83881 | 696 |
2421723 | 2421723 | 2022-04-19 | Weld | Colorado | 8123 | 83881 | 696 |
2418467 | 2418467 | 2022-04-18 | Weld | Colorado | 8123 | 83681 | 696 |
2415211 | 2415211 | 2022-04-17 | Weld | Colorado | 8123 | 83662 | 696 |
2411955 | 2411955 | 2022-04-16 | Weld | Colorado | 8123 | 83662 | 696 |
2408699 | 2408699 | 2022-04-15 | Weld | Colorado | 8123 | 83662 | 696 |
2405443 | 2405443 | 2022-04-14 | Weld | Colorado | 8123 | 83366 | 696 |
2402188 | 2402188 | 2022-04-13 | Weld | Colorado | 8123 | 83346 | 695 |
2398933 | 2398933 | 2022-04-12 | Weld | Colorado | 8123 | 83346 | 695 |
2395678 | 2395678 | 2022-04-11 | Weld | Colorado | 8123 | 83156 | 694 |
2392422 | 2392422 | 2022-04-10 | Weld | Colorado | 8123 | 83147 | 694 |
2389166 | 2389166 | 2022-04-09 | Weld | Colorado | 8123 | 83147 | 694 |
2385911 | 2385911 | 2022-04-08 | Weld | Colorado | 8123 | 83147 | 694 |
2382656 | 2382656 | 2022-04-07 | Weld | Colorado | 8123 | 82955 | 694 |
2379401 | 2379401 | 2022-04-06 | Weld | Colorado | 8123 | 82911 | 694 |
2376147 | 2376147 | 2022-04-05 | Weld | Colorado | 8123 | 82911 | 694 |
2372895 | 2372895 | 2022-04-04 | Weld | Colorado | 8123 | 82707 | 694 |
2369642 | 2369642 | 2022-04-03 | Weld | Colorado | 8123 | 82707 | 694 |
2366389 | 2366389 | 2022-04-02 | Weld | Colorado | 8123 | 82707 | 694 |
2363136 | 2363136 | 2022-04-01 | Weld | Colorado | 8123 | 82707 | 694 |
2359882 | 2359882 | 2022-03-31 | Weld | Colorado | 8123 | 82493 | 694 |
2356628 | 2356628 | 2022-03-30 | Weld | Colorado | 8123 | 82400 | 694 |
2353375 | 2353375 | 2022-03-29 | Weld | Colorado | 8123 | 82347 | 694 |
2350123 | 2350123 | 2022-03-28 | Weld | Colorado | 8123 | 82206 | 694 |
2346870 | 2346870 | 2022-03-27 | Weld | Colorado | 8123 | 82184 | 693 |
2343617 | 2343617 | 2022-03-26 | Weld | Colorado | 8123 | 82184 | 693 |
2340364 | 2340364 | 2022-03-25 | Weld | Colorado | 8123 | 82184 | 693 |
2337111 | 2337111 | 2022-03-24 | Weld | Colorado | 8123 | 81996 | 693 |
2333857 | 2333857 | 2022-03-23 | Weld | Colorado | 8123 | 81969 | 693 |
2330603 | 2330603 | 2022-03-22 | Weld | Colorado | 8123 | 81969 | 692 |
2327351 | 2327351 | 2022-03-21 | Weld | Colorado | 8123 | 81707 | 690 |
2324098 | 2324098 | 2022-03-20 | Weld | Colorado | 8123 | 81683 | 690 |
2320844 | 2320844 | 2022-03-19 | Weld | Colorado | 8123 | 81683 | 690 |
2317590 | 2317590 | 2022-03-18 | Weld | Colorado | 8123 | 81683 | 690 |
2314337 | 2314337 | 2022-03-17 | Weld | Colorado | 8123 | 81452 | 690 |
2311084 | 2311084 | 2022-03-16 | Weld | Colorado | 8123 | 81336 | 686 |
2307831 | 2307831 | 2022-03-15 | Weld | Colorado | 8123 | 81252 | 686 |
2304580 | 2304580 | 2022-03-14 | Weld | Colorado | 8123 | 81252 | 686 |
2301328 | 2301328 | 2022-03-13 | Weld | Colorado | 8123 | 81124 | 686 |
2298076 | 2298076 | 2022-03-12 | Weld | Colorado | 8123 | 81124 | 686 |
2294824 | 2294824 | 2022-03-11 | Weld | Colorado | 8123 | 81124 | 686 |
2291572 | 2291572 | 2022-03-10 | Weld | Colorado | 8123 | 81124 | 686 |
2288320 | 2288320 | 2022-03-09 | Weld | Colorado | 8123 | 81057 | 685 |
2285069 | 2285069 | 2022-03-08 | Weld | Colorado | 8123 | 80985 | 684 |
2281817 | 2281817 | 2022-03-07 | Weld | Colorado | 8123 | 80946 | 684 |
2278564 | 2278564 | 2022-03-06 | Weld | Colorado | 8123 | 80859 | 683 |
2275311 | 2275311 | 2022-03-05 | Weld | Colorado | 8123 | 80859 | 683 |
2272058 | 2272058 | 2022-03-04 | Weld | Colorado | 8123 | 80859 | 683 |
2268806 | 2268806 | 2022-03-03 | Weld | Colorado | 8123 | 80824 | 682 |
2265553 | 2265553 | 2022-03-02 | Weld | Colorado | 8123 | 80758 | 683 |
2262302 | 2262302 | 2022-03-01 | Weld | Colorado | 8123 | 80682 | 681 |
2259051 | 2259051 | 2022-02-28 | Weld | Colorado | 8123 | 80639 | 675 |
2255800 | 2255800 | 2022-02-27 | Weld | Colorado | 8123 | 80498 | 675 |
2252549 | 2252549 | 2022-02-26 | Weld | Colorado | 8123 | 80498 | 675 |
2249298 | 2249298 | 2022-02-25 | Weld | Colorado | 8123 | 80498 | 675 |
2246047 | 2246047 | 2022-02-24 | Weld | Colorado | 8123 | 80386 | 675 |
2242796 | 2242796 | 2022-02-23 | Weld | Colorado | 8123 | 80308 | 671 |
2239545 | 2239545 | 2022-02-22 | Weld | Colorado | 8123 | 80182 | 671 |
2236294 | 2236294 | 2022-02-21 | Weld | Colorado | 8123 | 79956 | 661 |
2233043 | 2233043 | 2022-02-20 | Weld | Colorado | 8123 | 79956 | 662 |
2229792 | 2229792 | 2022-02-19 | Weld | Colorado | 8123 | 79956 | 662 |
2226541 | 2226541 | 2022-02-18 | Weld | Colorado | 8123 | 79956 | 662 |
2223290 | 2223290 | 2022-02-17 | Weld | Colorado | 8123 | 79825 | 661 |
2220039 | 2220039 | 2022-02-16 | Weld | Colorado | 8123 | 79722 | 660 |
2216788 | 2216788 | 2022-02-15 | Weld | Colorado | 8123 | 79562 | 660 |
2213537 | 2213537 | 2022-02-14 | Weld | Colorado | 8123 | 79477 | 660 |
2210285 | 2210285 | 2022-02-13 | Weld | Colorado | 8123 | 79224 | 660 |
2207032 | 2207032 | 2022-02-12 | Weld | Colorado | 8123 | 79224 | 660 |
2203779 | 2203779 | 2022-02-11 | Weld | Colorado | 8123 | 79224 | 660 |
2200526 | 2200526 | 2022-02-10 | Weld | Colorado | 8123 | 79019 | 660 |
2197272 | 2197272 | 2022-02-09 | Weld | Colorado | 8123 | 78796 | 655 |
2194018 | 2194018 | 2022-02-08 | Weld | Colorado | 8123 | 78598 | 650 |
2190764 | 2190764 | 2022-02-07 | Weld | Colorado | 8123 | 78430 | 652 |
2187511 | 2187511 | 2022-02-06 | Weld | Colorado | 8123 | 77941 | 632 |
2184258 | 2184258 | 2022-02-05 | Weld | Colorado | 8123 | 77941 | 632 |
2181006 | 2181006 | 2022-02-04 | Weld | Colorado | 8123 | 77941 | 632 |
2177755 | 2177755 | 2022-02-03 | Weld | Colorado | 8123 | 77729 | 631 |
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);