ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where county = "Fulton", deaths = 180, fips = 39051 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501669 | 2501669 | 2022-05-13 | Fulton | Ohio | 39051 | 10436 | 180 |
2498411 | 2498411 | 2022-05-12 | Fulton | Ohio | 39051 | 10436 | 180 |
2495153 | 2495153 | 2022-05-11 | Fulton | Ohio | 39051 | 10396 | 180 |
2491895 | 2491895 | 2022-05-10 | Fulton | Ohio | 39051 | 10396 | 180 |
2488637 | 2488637 | 2022-05-09 | Fulton | Ohio | 39051 | 10396 | 180 |
2485380 | 2485380 | 2022-05-08 | Fulton | Ohio | 39051 | 10396 | 180 |
2482122 | 2482122 | 2022-05-07 | Fulton | Ohio | 39051 | 10396 | 180 |
2478864 | 2478864 | 2022-05-06 | Fulton | Ohio | 39051 | 10396 | 180 |
2475606 | 2475606 | 2022-05-05 | Fulton | Ohio | 39051 | 10396 | 180 |
2472349 | 2472349 | 2022-05-04 | Fulton | Ohio | 39051 | 10360 | 180 |
2469093 | 2469093 | 2022-05-03 | Fulton | Ohio | 39051 | 10360 | 180 |
2465837 | 2465837 | 2022-05-02 | Fulton | Ohio | 39051 | 10360 | 180 |
2462582 | 2462582 | 2022-05-01 | Fulton | Ohio | 39051 | 10360 | 180 |
2459326 | 2459326 | 2022-04-30 | Fulton | Ohio | 39051 | 10360 | 180 |
2456070 | 2456070 | 2022-04-29 | Fulton | Ohio | 39051 | 10360 | 180 |
2452814 | 2452814 | 2022-04-28 | Fulton | Ohio | 39051 | 10360 | 180 |
2449558 | 2449558 | 2022-04-27 | Fulton | Ohio | 39051 | 10334 | 180 |
2446301 | 2446301 | 2022-04-26 | Fulton | Ohio | 39051 | 10334 | 180 |
2443046 | 2443046 | 2022-04-25 | Fulton | Ohio | 39051 | 10334 | 180 |
2439790 | 2439790 | 2022-04-24 | Fulton | Ohio | 39051 | 10334 | 180 |
2436534 | 2436534 | 2022-04-23 | Fulton | Ohio | 39051 | 10334 | 180 |
2433278 | 2433278 | 2022-04-22 | Fulton | Ohio | 39051 | 10334 | 180 |
2430022 | 2430022 | 2022-04-21 | Fulton | Ohio | 39051 | 10334 | 180 |
2426766 | 2426766 | 2022-04-20 | Fulton | Ohio | 39051 | 10321 | 180 |
2423510 | 2423510 | 2022-04-19 | Fulton | Ohio | 39051 | 10321 | 180 |
2420253 | 2420253 | 2022-04-18 | Fulton | Ohio | 39051 | 10321 | 180 |
2416998 | 2416998 | 2022-04-17 | Fulton | Ohio | 39051 | 10321 | 180 |
2413742 | 2413742 | 2022-04-16 | Fulton | Ohio | 39051 | 10321 | 180 |
2410486 | 2410486 | 2022-04-15 | Fulton | Ohio | 39051 | 10321 | 180 |
2407230 | 2407230 | 2022-04-14 | Fulton | Ohio | 39051 | 10321 | 180 |
2403974 | 2403974 | 2022-04-13 | Fulton | Ohio | 39051 | 10320 | 180 |
2400719 | 2400719 | 2022-04-12 | Fulton | Ohio | 39051 | 10320 | 180 |
2397464 | 2397464 | 2022-04-11 | Fulton | Ohio | 39051 | 10320 | 180 |
2394209 | 2394209 | 2022-04-10 | Fulton | Ohio | 39051 | 10320 | 180 |
2390953 | 2390953 | 2022-04-09 | Fulton | Ohio | 39051 | 10320 | 180 |
2387697 | 2387697 | 2022-04-08 | Fulton | Ohio | 39051 | 10320 | 180 |
2384442 | 2384442 | 2022-04-07 | Fulton | Ohio | 39051 | 10320 | 180 |
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);