ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where county = "Crawford", deaths = 53 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422237 | 2422237 | 2022-04-19 | Crawford | Iowa | 19047 | 4525 | 53 |
2418981 | 2418981 | 2022-04-18 | Crawford | Iowa | 19047 | 4525 | 53 |
2415725 | 2415725 | 2022-04-17 | Crawford | Iowa | 19047 | 4525 | 53 |
2412469 | 2412469 | 2022-04-16 | Crawford | Iowa | 19047 | 4525 | 53 |
2409213 | 2409213 | 2022-04-15 | Crawford | Iowa | 19047 | 4525 | 53 |
2405957 | 2405957 | 2022-04-14 | Crawford | Iowa | 19047 | 4525 | 53 |
2402701 | 2402701 | 2022-04-13 | Crawford | Iowa | 19047 | 4525 | 53 |
2399447 | 2399447 | 2022-04-12 | Crawford | Iowa | 19047 | 4526 | 53 |
2396191 | 2396191 | 2022-04-11 | Crawford | Iowa | 19047 | 4526 | 53 |
2392936 | 2392936 | 2022-04-10 | Crawford | Iowa | 19047 | 4526 | 53 |
2389680 | 2389680 | 2022-04-09 | Crawford | Iowa | 19047 | 4526 | 53 |
2386424 | 2386424 | 2022-04-08 | Crawford | Iowa | 19047 | 4526 | 53 |
2383170 | 2383170 | 2022-04-07 | Crawford | Iowa | 19047 | 4526 | 53 |
2379915 | 2379915 | 2022-04-06 | Crawford | Iowa | 19047 | 4526 | 53 |
2331116 | 2331116 | 2022-03-22 | Crawford | Iowa | 19047 | 4516 | 53 |
2327864 | 2327864 | 2022-03-21 | Crawford | Iowa | 19047 | 4516 | 53 |
2324611 | 2324611 | 2022-03-20 | Crawford | Iowa | 19047 | 4516 | 53 |
2321357 | 2321357 | 2022-03-19 | Crawford | Iowa | 19047 | 4516 | 53 |
2318103 | 2318103 | 2022-03-18 | Crawford | Iowa | 19047 | 4516 | 53 |
2314850 | 2314850 | 2022-03-17 | Crawford | Iowa | 19047 | 4516 | 53 |
2311597 | 2311597 | 2022-03-16 | Crawford | Iowa | 19047 | 4516 | 53 |
2308344 | 2308344 | 2022-03-15 | Crawford | Iowa | 19047 | 4511 | 53 |
2305093 | 2305093 | 2022-03-14 | Crawford | Iowa | 19047 | 4511 | 53 |
2301841 | 2301841 | 2022-03-13 | Crawford | Iowa | 19047 | 4511 | 53 |
2298589 | 2298589 | 2022-03-12 | Crawford | Iowa | 19047 | 4511 | 53 |
2295337 | 2295337 | 2022-03-11 | Crawford | Iowa | 19047 | 4511 | 53 |
2292085 | 2292085 | 2022-03-10 | Crawford | Iowa | 19047 | 4511 | 53 |
2288833 | 2288833 | 2022-03-09 | Crawford | Iowa | 19047 | 4511 | 53 |
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);