ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where county = "Northumberland", deaths = 13 and state = "Virginia" 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 |
---|---|---|---|---|---|---|---|
1056517 | 1056517 | 2021-02-22 | Northumberland | Virginia | 51133 | 654 | 13 |
1053271 | 1053271 | 2021-02-21 | Northumberland | Virginia | 51133 | 650 | 13 |
1050024 | 1050024 | 2021-02-20 | Northumberland | Virginia | 51133 | 647 | 13 |
1046777 | 1046777 | 2021-02-19 | Northumberland | Virginia | 51133 | 644 | 13 |
1043532 | 1043532 | 2021-02-18 | Northumberland | Virginia | 51133 | 637 | 13 |
1040287 | 1040287 | 2021-02-17 | Northumberland | Virginia | 51133 | 636 | 13 |
1037042 | 1037042 | 2021-02-16 | Northumberland | Virginia | 51133 | 635 | 13 |
1033797 | 1033797 | 2021-02-15 | Northumberland | Virginia | 51133 | 633 | 13 |
1030551 | 1030551 | 2021-02-14 | Northumberland | Virginia | 51133 | 630 | 13 |
1027304 | 1027304 | 2021-02-13 | Northumberland | Virginia | 51133 | 625 | 13 |
1024059 | 1024059 | 2021-02-12 | Northumberland | Virginia | 51133 | 622 | 13 |
1020814 | 1020814 | 2021-02-11 | Northumberland | Virginia | 51133 | 621 | 13 |
1017569 | 1017569 | 2021-02-10 | Northumberland | Virginia | 51133 | 614 | 13 |
1014324 | 1014324 | 2021-02-09 | Northumberland | Virginia | 51133 | 612 | 13 |
1011079 | 1011079 | 2021-02-08 | Northumberland | Virginia | 51133 | 609 | 13 |
1007833 | 1007833 | 2021-02-07 | Northumberland | Virginia | 51133 | 608 | 13 |
1004587 | 1004587 | 2021-02-06 | Northumberland | Virginia | 51133 | 606 | 13 |
1001341 | 1001341 | 2021-02-05 | Northumberland | Virginia | 51133 | 602 | 13 |
998095 | 998095 | 2021-02-04 | Northumberland | Virginia | 51133 | 596 | 13 |
994849 | 994849 | 2021-02-03 | Northumberland | Virginia | 51133 | 593 | 13 |
991603 | 991603 | 2021-02-02 | Northumberland | Virginia | 51133 | 592 | 13 |
988357 | 988357 | 2021-02-01 | Northumberland | Virginia | 51133 | 588 | 13 |
985110 | 985110 | 2021-01-31 | Northumberland | Virginia | 51133 | 582 | 13 |
981863 | 981863 | 2021-01-30 | Northumberland | Virginia | 51133 | 575 | 13 |
978617 | 978617 | 2021-01-29 | Northumberland | Virginia | 51133 | 574 | 13 |
975372 | 975372 | 2021-01-28 | Northumberland | Virginia | 51133 | 571 | 13 |
972127 | 972127 | 2021-01-27 | Northumberland | Virginia | 51133 | 562 | 13 |
968882 | 968882 | 2021-01-26 | Northumberland | Virginia | 51133 | 556 | 13 |
965638 | 965638 | 2021-01-25 | Northumberland | Virginia | 51133 | 553 | 13 |
962393 | 962393 | 2021-01-24 | Northumberland | Virginia | 51133 | 548 | 13 |
959148 | 959148 | 2021-01-23 | Northumberland | Virginia | 51133 | 538 | 13 |
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);