ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where county = "Greene", deaths = 5 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
607640 | 607640 | 2020-10-07 | Greene | North Carolina | 37079 | 708 | 5 |
604397 | 604397 | 2020-10-06 | Greene | North Carolina | 37079 | 705 | 5 |
601155 | 601155 | 2020-10-05 | Greene | North Carolina | 37079 | 702 | 5 |
597912 | 597912 | 2020-10-04 | Greene | North Carolina | 37079 | 669 | 5 |
594669 | 594669 | 2020-10-03 | Greene | North Carolina | 37079 | 669 | 5 |
591428 | 591428 | 2020-10-02 | Greene | North Carolina | 37079 | 637 | 5 |
588187 | 588187 | 2020-10-01 | Greene | North Carolina | 37079 | 633 | 5 |
584947 | 584947 | 2020-09-30 | Greene | North Carolina | 37079 | 623 | 5 |
581706 | 581706 | 2020-09-29 | Greene | North Carolina | 37079 | 618 | 5 |
578466 | 578466 | 2020-09-28 | Greene | North Carolina | 37079 | 607 | 5 |
575225 | 575225 | 2020-09-27 | Greene | North Carolina | 37079 | 604 | 5 |
571981 | 571981 | 2020-09-26 | Greene | North Carolina | 37079 | 601 | 5 |
568739 | 568739 | 2020-09-25 | Greene | North Carolina | 37079 | 593 | 5 |
565498 | 565498 | 2020-09-24 | Greene | North Carolina | 37079 | 581 | 5 |
562257 | 562257 | 2020-09-23 | Greene | North Carolina | 37079 | 507 | 5 |
559020 | 559020 | 2020-09-22 | Greene | North Carolina | 37079 | 507 | 5 |
555783 | 555783 | 2020-09-21 | Greene | North Carolina | 37079 | 505 | 5 |
552546 | 552546 | 2020-09-20 | Greene | North Carolina | 37079 | 502 | 5 |
549307 | 549307 | 2020-09-19 | Greene | North Carolina | 37079 | 498 | 5 |
546068 | 546068 | 2020-09-18 | Greene | North Carolina | 37079 | 498 | 5 |
542831 | 542831 | 2020-09-17 | Greene | North Carolina | 37079 | 495 | 5 |
539595 | 539595 | 2020-09-16 | Greene | North Carolina | 37079 | 494 | 5 |
536358 | 536358 | 2020-09-15 | Greene | North Carolina | 37079 | 485 | 5 |
533122 | 533122 | 2020-09-14 | Greene | North Carolina | 37079 | 486 | 5 |
529887 | 529887 | 2020-09-13 | Greene | North Carolina | 37079 | 478 | 5 |
526650 | 526650 | 2020-09-12 | Greene | North Carolina | 37079 | 471 | 5 |
523414 | 523414 | 2020-09-11 | Greene | North Carolina | 37079 | 467 | 5 |
520178 | 520178 | 2020-09-10 | Greene | North Carolina | 37079 | 464 | 5 |
516942 | 516942 | 2020-09-09 | Greene | North Carolina | 37079 | 458 | 5 |
513707 | 513707 | 2020-09-08 | Greene | North Carolina | 37079 | 458 | 5 |
510474 | 510474 | 2020-09-07 | Greene | North Carolina | 37079 | 458 | 5 |
507241 | 507241 | 2020-09-06 | Greene | North Carolina | 37079 | 457 | 5 |
504009 | 504009 | 2020-09-05 | Greene | North Carolina | 37079 | 449 | 5 |
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);