ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 38, fips = 39005 and state = "Ohio" 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 |
---|---|---|---|---|---|---|---|
1000392 | 1000392 | 2021-02-05 | Ashland | Ohio | 39005 | 3614 | 38 |
997146 | 997146 | 2021-02-04 | Ashland | Ohio | 39005 | 3607 | 38 |
993900 | 993900 | 2021-02-03 | Ashland | Ohio | 39005 | 3600 | 38 |
990654 | 990654 | 2021-02-02 | Ashland | Ohio | 39005 | 3592 | 38 |
987408 | 987408 | 2021-02-01 | Ashland | Ohio | 39005 | 3579 | 38 |
984161 | 984161 | 2021-01-31 | Ashland | Ohio | 39005 | 3565 | 38 |
980914 | 980914 | 2021-01-30 | Ashland | Ohio | 39005 | 3556 | 38 |
977668 | 977668 | 2021-01-29 | Ashland | Ohio | 39005 | 3545 | 38 |
974423 | 974423 | 2021-01-28 | Ashland | Ohio | 39005 | 3531 | 38 |
971178 | 971178 | 2021-01-27 | Ashland | Ohio | 39005 | 3515 | 38 |
967933 | 967933 | 2021-01-26 | Ashland | Ohio | 39005 | 3496 | 38 |
964689 | 964689 | 2021-01-25 | Ashland | Ohio | 39005 | 3490 | 38 |
961444 | 961444 | 2021-01-24 | Ashland | Ohio | 39005 | 3474 | 38 |
958199 | 958199 | 2021-01-23 | Ashland | Ohio | 39005 | 3449 | 38 |
954953 | 954953 | 2021-01-22 | Ashland | Ohio | 39005 | 3428 | 38 |
951708 | 951708 | 2021-01-21 | Ashland | Ohio | 39005 | 3425 | 38 |
948463 | 948463 | 2021-01-20 | Ashland | Ohio | 39005 | 3397 | 38 |
945217 | 945217 | 2021-01-19 | Ashland | Ohio | 39005 | 3368 | 38 |
941970 | 941970 | 2021-01-18 | Ashland | Ohio | 39005 | 3338 | 38 |
938725 | 938725 | 2021-01-17 | Ashland | Ohio | 39005 | 3317 | 38 |
935480 | 935480 | 2021-01-16 | Ashland | Ohio | 39005 | 3291 | 38 |
932235 | 932235 | 2021-01-15 | Ashland | Ohio | 39005 | 3253 | 38 |
928990 | 928990 | 2021-01-14 | Ashland | Ohio | 39005 | 3225 | 38 |
925745 | 925745 | 2021-01-13 | Ashland | Ohio | 39005 | 3192 | 38 |
922499 | 922499 | 2021-01-12 | Ashland | Ohio | 39005 | 3150 | 38 |
919254 | 919254 | 2021-01-11 | Ashland | Ohio | 39005 | 3141 | 38 |
916009 | 916009 | 2021-01-10 | Ashland | Ohio | 39005 | 3089 | 38 |
912764 | 912764 | 2021-01-09 | Ashland | Ohio | 39005 | 3055 | 38 |
909519 | 909519 | 2021-01-08 | Ashland | Ohio | 39005 | 3024 | 38 |
906274 | 906274 | 2021-01-07 | Ashland | Ohio | 39005 | 2976 | 38 |
903028 | 903028 | 2021-01-06 | Ashland | Ohio | 39005 | 2927 | 38 |
899783 | 899783 | 2021-01-05 | Ashland | Ohio | 39005 | 2909 | 38 |
896538 | 896538 | 2021-01-04 | Ashland | Ohio | 39005 | 2877 | 38 |
893292 | 893292 | 2021-01-03 | Ashland | Ohio | 39005 | 2844 | 38 |
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);