ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

28 rows where deaths = 479 and state = "Ohio" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: cases, date (date)

fips 6

state 1

  • Ohio · 28 ✖
Link rowid date ▲ county state fips cases deaths
2381176 2381176 2022-04-06 Columbiana Ohio 39029 24361 479
2377921 2377921 2022-04-05 Columbiana Ohio 39029 24361 479
2374667 2374667 2022-04-04 Columbiana Ohio 39029 24361 479
2371415 2371415 2022-04-03 Columbiana Ohio 39029 24361 479
2368162 2368162 2022-04-02 Columbiana Ohio 39029 24361 479
2364909 2364909 2022-04-01 Columbiana Ohio 39029 24361 479
2361656 2361656 2022-03-31 Columbiana Ohio 39029 24361 479
2247855 2247855 2022-02-24 Medina Ohio 39103 39718 479
2244604 2244604 2022-02-23 Medina Ohio 39103 39699 479
2241353 2241353 2022-02-22 Medina Ohio 39103 39694 479
2192534 2192534 2022-02-07 Clermont Ohio 39025 49887 479
2189280 2189280 2022-02-06 Clermont Ohio 39025 49832 479
2186027 2186027 2022-02-05 Clermont Ohio 39025 49777 479
2182775 2182775 2022-02-04 Clermont Ohio 39025 49716 479
2179522 2179522 2022-02-03 Clark Ohio 39023 34005 479
2176271 2176271 2022-02-02 Clark Ohio 39023 33871 479
2173017 2173017 2022-02-01 Clark Ohio 39023 33737 479
1419265 1419265 2021-06-14 Trumbull Ohio 39155 16527 479
1416020 1416020 2021-06-13 Trumbull Ohio 39155 16522 479
1412774 1412774 2021-06-12 Trumbull Ohio 39155 16520 479
1409529 1409529 2021-06-11 Trumbull Ohio 39155 16515 479
1406284 1406284 2021-06-10 Trumbull Ohio 39155 16512 479
1403038 1403038 2021-06-09 Trumbull Ohio 39155 16503 479
1399793 1399793 2021-06-08 Trumbull Ohio 39155 16495 479
1282897 1282897 2021-05-03 Lorain Ohio 39093 24790 479
1279650 1279650 2021-05-02 Lorain Ohio 39093 24757 479
1276403 1276403 2021-05-01 Lorain Ohio 39093 24723 479
1273156 1273156 2021-04-30 Lorain Ohio 39093 24685 479

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);