ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where county = "Crawford", deaths = 3 and fips = 42039 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
575563 | 575563 | 2020-09-27 | Crawford | Pennsylvania | 42039 | 305 | 3 |
572319 | 572319 | 2020-09-26 | Crawford | Pennsylvania | 42039 | 304 | 3 |
569077 | 569077 | 2020-09-25 | Crawford | Pennsylvania | 42039 | 303 | 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 |
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);