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

780 rows where county = "Lawrence" and state = "Ohio" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Ohio · 780 ✖

fips 1

county 1

  • Lawrence · 780 ✖
Link rowid date ▲ county state fips cases deaths
2501687 2501687 2022-05-13 Lawrence Ohio 39087 18071 256
2498429 2498429 2022-05-12 Lawrence Ohio 39087 18071 256
2495171 2495171 2022-05-11 Lawrence Ohio 39087 17998 253
2491913 2491913 2022-05-10 Lawrence Ohio 39087 17998 253
2488655 2488655 2022-05-09 Lawrence Ohio 39087 17998 253
2485398 2485398 2022-05-08 Lawrence Ohio 39087 17998 253
2482140 2482140 2022-05-07 Lawrence Ohio 39087 17998 253
2478882 2478882 2022-05-06 Lawrence Ohio 39087 17998 253
2475624 2475624 2022-05-05 Lawrence Ohio 39087 17998 253
2472367 2472367 2022-05-04 Lawrence Ohio 39087 17958 250
2469111 2469111 2022-05-03 Lawrence Ohio 39087 17958 250
2465855 2465855 2022-05-02 Lawrence Ohio 39087 17958 250
2462600 2462600 2022-05-01 Lawrence Ohio 39087 17958 250
2459344 2459344 2022-04-30 Lawrence Ohio 39087 17958 250
2456088 2456088 2022-04-29 Lawrence Ohio 39087 17958 250
2452832 2452832 2022-04-28 Lawrence Ohio 39087 17958 250
2449576 2449576 2022-04-27 Lawrence Ohio 39087 17895 247
2446319 2446319 2022-04-26 Lawrence Ohio 39087 17895 247
2443064 2443064 2022-04-25 Lawrence Ohio 39087 17895 247
2439808 2439808 2022-04-24 Lawrence Ohio 39087 17895 247
2436552 2436552 2022-04-23 Lawrence Ohio 39087 17895 247
2433296 2433296 2022-04-22 Lawrence Ohio 39087 17895 247
2430040 2430040 2022-04-21 Lawrence Ohio 39087 17895 247
2426784 2426784 2022-04-20 Lawrence Ohio 39087 17867 247
2423528 2423528 2022-04-19 Lawrence Ohio 39087 17867 247
2420271 2420271 2022-04-18 Lawrence Ohio 39087 17867 247
2417016 2417016 2022-04-17 Lawrence Ohio 39087 17867 247
2413760 2413760 2022-04-16 Lawrence Ohio 39087 17867 247
2410504 2410504 2022-04-15 Lawrence Ohio 39087 17867 247
2407248 2407248 2022-04-14 Lawrence Ohio 39087 17867 247
2403992 2403992 2022-04-13 Lawrence Ohio 39087 17855 242
2400737 2400737 2022-04-12 Lawrence Ohio 39087 17855 242
2397482 2397482 2022-04-11 Lawrence Ohio 39087 17855 242
2394227 2394227 2022-04-10 Lawrence Ohio 39087 17855 242
2390971 2390971 2022-04-09 Lawrence Ohio 39087 17855 242
2387715 2387715 2022-04-08 Lawrence Ohio 39087 17855 242
2384460 2384460 2022-04-07 Lawrence Ohio 39087 17855 242
2381205 2381205 2022-04-06 Lawrence Ohio 39087 17840 240
2377950 2377950 2022-04-05 Lawrence Ohio 39087 17840 240
2374696 2374696 2022-04-04 Lawrence Ohio 39087 17840 240
2371444 2371444 2022-04-03 Lawrence Ohio 39087 17840 240
2368191 2368191 2022-04-02 Lawrence Ohio 39087 17840 240
2364938 2364938 2022-04-01 Lawrence Ohio 39087 17840 240
2361685 2361685 2022-03-31 Lawrence Ohio 39087 17840 240
2358431 2358431 2022-03-30 Lawrence Ohio 39087 17824 239
2355177 2355177 2022-03-29 Lawrence Ohio 39087 17824 239
2351924 2351924 2022-03-28 Lawrence Ohio 39087 17824 239
2348672 2348672 2022-03-27 Lawrence Ohio 39087 17824 239
2345419 2345419 2022-03-26 Lawrence Ohio 39087 17824 239
2342166 2342166 2022-03-25 Lawrence Ohio 39087 17824 239
2338913 2338913 2022-03-24 Lawrence Ohio 39087 17824 239
2335659 2335659 2022-03-23 Lawrence Ohio 39087 17789 233
2332405 2332405 2022-03-22 Lawrence Ohio 39087 17789 233
2329152 2329152 2022-03-21 Lawrence Ohio 39087 17789 233
2325900 2325900 2022-03-20 Lawrence Ohio 39087 17789 233
2322647 2322647 2022-03-19 Lawrence Ohio 39087 17789 233
2319393 2319393 2022-03-18 Lawrence Ohio 39087 17789 233
2316139 2316139 2022-03-17 Lawrence Ohio 39087 17789 233
2312886 2312886 2022-03-16 Lawrence Ohio 39087 17769 233
2309633 2309633 2022-03-15 Lawrence Ohio 39087 17769 233
2306380 2306380 2022-03-14 Lawrence Ohio 39087 17769 233
2303129 2303129 2022-03-13 Lawrence Ohio 39087 17769 233
2299877 2299877 2022-03-12 Lawrence Ohio 39087 17757 233
2296625 2296625 2022-03-11 Lawrence Ohio 39087 17756 233
2293373 2293373 2022-03-10 Lawrence Ohio 39087 17750 233
2290121 2290121 2022-03-09 Lawrence Ohio 39087 17745 233
2286869 2286869 2022-03-08 Lawrence Ohio 39087 17731 233
2283617 2283617 2022-03-07 Lawrence Ohio 39087 17729 222
2280365 2280365 2022-03-06 Lawrence Ohio 39087 17719 222
2277112 2277112 2022-03-05 Lawrence Ohio 39087 17711 222
2273859 2273859 2022-03-04 Lawrence Ohio 39087 17702 222
2270606 2270606 2022-03-03 Lawrence Ohio 39087 17694 219
2267354 2267354 2022-03-02 Lawrence Ohio 39087 17669 219
2264101 2264101 2022-03-01 Lawrence Ohio 39087 17659 219
2260851 2260851 2022-02-28 Lawrence Ohio 39087 17635 219
2257600 2257600 2022-02-27 Lawrence Ohio 39087 17617 219
2254349 2254349 2022-02-26 Lawrence Ohio 39087 17605 219
2251098 2251098 2022-02-25 Lawrence Ohio 39087 17588 219
2247847 2247847 2022-02-24 Lawrence Ohio 39087 17563 219
2244596 2244596 2022-02-23 Lawrence Ohio 39087 17529 219
2241345 2241345 2022-02-22 Lawrence Ohio 39087 17500 219
2238094 2238094 2022-02-21 Lawrence Ohio 39087 17472 218
2234843 2234843 2022-02-20 Lawrence Ohio 39087 17448 218
2231592 2231592 2022-02-19 Lawrence Ohio 39087 17425 218
2228341 2228341 2022-02-18 Lawrence Ohio 39087 17401 218
2225090 2225090 2022-02-17 Lawrence Ohio 39087 17344 210
2221839 2221839 2022-02-16 Lawrence Ohio 39087 17312 210
2218588 2218588 2022-02-15 Lawrence Ohio 39087 17271 210
2215337 2215337 2022-02-14 Lawrence Ohio 39087 17215 209
2212086 2212086 2022-02-13 Lawrence Ohio 39087 17193 209
2208833 2208833 2022-02-12 Lawrence Ohio 39087 17169 209
2205580 2205580 2022-02-11 Lawrence Ohio 39087 17128 209
2202327 2202327 2022-02-10 Lawrence Ohio 39087 17054 208
2199073 2199073 2022-02-09 Lawrence Ohio 39087 16996 208
2195819 2195819 2022-02-08 Lawrence Ohio 39087 16910 208
2192565 2192565 2022-02-07 Lawrence Ohio 39087 16828 198
2189311 2189311 2022-02-06 Lawrence Ohio 39087 16760 198
2186058 2186058 2022-02-05 Lawrence Ohio 39087 16719 198
2182806 2182806 2022-02-04 Lawrence Ohio 39087 16656 198
2179554 2179554 2022-02-03 Lawrence Ohio 39087 16561 198

Next page

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