ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
176 rows where county = "Crawford" and deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
county 1
- Crawford · 176 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
804317 | 804317 | 2020-12-07 | Crawford | Indiana | 18025 | 407 | 3 |
801072 | 801072 | 2020-12-06 | Crawford | Indiana | 18025 | 395 | 3 |
797827 | 797827 | 2020-12-05 | Crawford | Indiana | 18025 | 380 | 3 |
794582 | 794582 | 2020-12-04 | Crawford | Indiana | 18025 | 373 | 3 |
722389 | 722389 | 2020-11-11 | Crawford | Wisconsin | 55023 | 573 | 3 |
719146 | 719146 | 2020-11-10 | Crawford | Wisconsin | 55023 | 548 | 3 |
695561 | 695561 | 2020-11-03 | Crawford | Pennsylvania | 42039 | 624 | 3 |
692319 | 692319 | 2020-11-02 | Crawford | Pennsylvania | 42039 | 598 | 3 |
689075 | 689075 | 2020-11-01 | Crawford | Pennsylvania | 42039 | 585 | 3 |
685830 | 685830 | 2020-10-31 | Crawford | Pennsylvania | 42039 | 571 | 3 |
682587 | 682587 | 2020-10-30 | Crawford | Pennsylvania | 42039 | 561 | 3 |
679344 | 679344 | 2020-10-29 | Crawford | Pennsylvania | 42039 | 532 | 3 |
676101 | 676101 | 2020-10-28 | Crawford | Pennsylvania | 42039 | 523 | 3 |
672858 | 672858 | 2020-10-27 | Crawford | Pennsylvania | 42039 | 490 | 3 |
669616 | 669616 | 2020-10-26 | Crawford | Pennsylvania | 42039 | 478 | 3 |
666372 | 666372 | 2020-10-25 | Crawford | Pennsylvania | 42039 | 461 | 3 |
663127 | 663127 | 2020-10-24 | Crawford | Pennsylvania | 42039 | 449 | 3 |
659883 | 659883 | 2020-10-23 | Crawford | Pennsylvania | 42039 | 438 | 3 |
656639 | 656639 | 2020-10-22 | Crawford | Pennsylvania | 42039 | 431 | 3 |
653394 | 653394 | 2020-10-21 | Crawford | Pennsylvania | 42039 | 417 | 3 |
650149 | 650149 | 2020-10-20 | Crawford | Pennsylvania | 42039 | 399 | 3 |
646905 | 646905 | 2020-10-19 | Crawford | Pennsylvania | 42039 | 392 | 3 |
643659 | 643659 | 2020-10-18 | Crawford | Pennsylvania | 42039 | 386 | 3 |
640411 | 640411 | 2020-10-17 | Crawford | Pennsylvania | 42039 | 379 | 3 |
637165 | 637165 | 2020-10-16 | Crawford | Pennsylvania | 42039 | 374 | 3 |
633919 | 633919 | 2020-10-15 | Crawford | Pennsylvania | 42039 | 366 | 3 |
630674 | 630674 | 2020-10-14 | Crawford | Pennsylvania | 42039 | 359 | 3 |
627430 | 627430 | 2020-10-13 | Crawford | Pennsylvania | 42039 | 356 | 3 |
624188 | 624188 | 2020-10-12 | Crawford | Pennsylvania | 42039 | 355 | 3 |
620945 | 620945 | 2020-10-11 | Crawford | Pennsylvania | 42039 | 345 | 3 |
617702 | 617702 | 2020-10-10 | Crawford | Pennsylvania | 42039 | 342 | 3 |
614460 | 614460 | 2020-10-09 | Crawford | Pennsylvania | 42039 | 336 | 3 |
611219 | 611219 | 2020-10-08 | Crawford | Pennsylvania | 42039 | 334 | 3 |
607977 | 607977 | 2020-10-07 | Crawford | Pennsylvania | 42039 | 332 | 3 |
604734 | 604734 | 2020-10-06 | Crawford | Pennsylvania | 42039 | 331 | 3 |
601492 | 601492 | 2020-10-05 | Crawford | Pennsylvania | 42039 | 330 | 3 |
598249 | 598249 | 2020-10-04 | Crawford | Pennsylvania | 42039 | 324 | 3 |
595006 | 595006 | 2020-10-03 | Crawford | Pennsylvania | 42039 | 321 | 3 |
591765 | 591765 | 2020-10-02 | Crawford | Pennsylvania | 42039 | 321 | 3 |
588524 | 588524 | 2020-10-01 | Crawford | Pennsylvania | 42039 | 317 | 3 |
585284 | 585284 | 2020-09-30 | Crawford | Pennsylvania | 42039 | 316 | 3 |
582044 | 582044 | 2020-09-29 | Crawford | Pennsylvania | 42039 | 311 | 3 |
578804 | 578804 | 2020-09-28 | Crawford | Pennsylvania | 42039 | 308 | 3 |
573900 | 573900 | 2020-09-27 | Crawford | Illinois | 17033 | 450 | 3 |
575563 | 575563 | 2020-09-27 | Crawford | Pennsylvania | 42039 | 305 | 3 |
570657 | 570657 | 2020-09-26 | Crawford | Illinois | 17033 | 440 | 3 |
572319 | 572319 | 2020-09-26 | Crawford | Pennsylvania | 42039 | 304 | 3 |
567415 | 567415 | 2020-09-25 | Crawford | Illinois | 17033 | 429 | 3 |
569077 | 569077 | 2020-09-25 | Crawford | Pennsylvania | 42039 | 303 | 3 |
564175 | 564175 | 2020-09-24 | Crawford | Illinois | 17033 | 420 | 3 |
565836 | 565836 | 2020-09-24 | Crawford | Pennsylvania | 42039 | 297 | 3 |
562595 | 562595 | 2020-09-23 | Crawford | Pennsylvania | 42039 | 298 | 3 |
559358 | 559358 | 2020-09-22 | Crawford | Pennsylvania | 42039 | 293 | 3 |
556121 | 556121 | 2020-09-21 | Crawford | Pennsylvania | 42039 | 290 | 3 |
552884 | 552884 | 2020-09-20 | Crawford | Pennsylvania | 42039 | 291 | 3 |
549645 | 549645 | 2020-09-19 | Crawford | Pennsylvania | 42039 | 288 | 3 |
546406 | 546406 | 2020-09-18 | Crawford | Pennsylvania | 42039 | 287 | 3 |
543169 | 543169 | 2020-09-17 | Crawford | Pennsylvania | 42039 | 283 | 3 |
539933 | 539933 | 2020-09-16 | Crawford | Pennsylvania | 42039 | 263 | 3 |
536696 | 536696 | 2020-09-15 | Crawford | Pennsylvania | 42039 | 257 | 3 |
533460 | 533460 | 2020-09-14 | Crawford | Pennsylvania | 42039 | 254 | 3 |
519058 | 519058 | 2020-09-10 | Crawford | Iowa | 19047 | 881 | 3 |
515823 | 515823 | 2020-09-09 | Crawford | Iowa | 19047 | 877 | 3 |
512590 | 512590 | 2020-09-08 | Crawford | Iowa | 19047 | 871 | 3 |
509357 | 509357 | 2020-09-07 | Crawford | Iowa | 19047 | 868 | 3 |
506125 | 506125 | 2020-09-06 | Crawford | Iowa | 19047 | 866 | 3 |
502502 | 502502 | 2020-09-05 | Crawford | Georgia | 13079 | 156 | 3 |
502891 | 502891 | 2020-09-05 | Crawford | Iowa | 19047 | 865 | 3 |
499268 | 499268 | 2020-09-04 | Crawford | Georgia | 13079 | 154 | 3 |
499657 | 499657 | 2020-09-04 | Crawford | Iowa | 19047 | 863 | 3 |
496035 | 496035 | 2020-09-03 | Crawford | Georgia | 13079 | 153 | 3 |
496424 | 496424 | 2020-09-03 | Crawford | Iowa | 19047 | 855 | 3 |
492801 | 492801 | 2020-09-02 | Crawford | Georgia | 13079 | 152 | 3 |
493190 | 493190 | 2020-09-02 | Crawford | Iowa | 19047 | 841 | 3 |
489568 | 489568 | 2020-09-01 | Crawford | Georgia | 13079 | 153 | 3 |
489957 | 489957 | 2020-09-01 | Crawford | Iowa | 19047 | 836 | 3 |
486335 | 486335 | 2020-08-31 | Crawford | Georgia | 13079 | 151 | 3 |
486724 | 486724 | 2020-08-31 | Crawford | Iowa | 19047 | 836 | 3 |
483100 | 483100 | 2020-08-30 | Crawford | Georgia | 13079 | 151 | 3 |
483489 | 483489 | 2020-08-30 | Crawford | Iowa | 19047 | 832 | 3 |
479866 | 479866 | 2020-08-29 | Crawford | Georgia | 13079 | 148 | 3 |
480255 | 480255 | 2020-08-29 | Crawford | Iowa | 19047 | 828 | 3 |
476633 | 476633 | 2020-08-28 | Crawford | Georgia | 13079 | 148 | 3 |
477022 | 477022 | 2020-08-28 | Crawford | Iowa | 19047 | 822 | 3 |
473789 | 473789 | 2020-08-27 | Crawford | Iowa | 19047 | 812 | 3 |
470557 | 470557 | 2020-08-26 | Crawford | Iowa | 19047 | 804 | 3 |
467328 | 467328 | 2020-08-25 | Crawford | Iowa | 19047 | 797 | 3 |
464099 | 464099 | 2020-08-24 | Crawford | Iowa | 19047 | 794 | 3 |
460870 | 460870 | 2020-08-23 | Crawford | Iowa | 19047 | 788 | 3 |
457643 | 457643 | 2020-08-22 | Crawford | Iowa | 19047 | 782 | 3 |
454415 | 454415 | 2020-08-21 | Crawford | Iowa | 19047 | 776 | 3 |
451187 | 451187 | 2020-08-20 | Crawford | Iowa | 19047 | 769 | 3 |
447959 | 447959 | 2020-08-19 | Crawford | Iowa | 19047 | 765 | 3 |
444732 | 444732 | 2020-08-18 | Crawford | Iowa | 19047 | 756 | 3 |
441506 | 441506 | 2020-08-17 | Crawford | Iowa | 19047 | 757 | 3 |
438280 | 438280 | 2020-08-16 | Crawford | Iowa | 19047 | 754 | 3 |
435054 | 435054 | 2020-08-15 | Crawford | Iowa | 19047 | 753 | 3 |
431829 | 431829 | 2020-08-14 | Crawford | Iowa | 19047 | 743 | 3 |
428601 | 428601 | 2020-08-13 | Crawford | Iowa | 19047 | 743 | 3 |
425377 | 425377 | 2020-08-12 | Crawford | Iowa | 19047 | 736 | 3 |
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);