ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 140 and fips = 29101 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 |
---|---|---|---|---|---|---|---|
2471806 | 2471806 | 2022-05-04 | Johnson | Missouri | 29101 | 12165 | 140 |
2468550 | 2468550 | 2022-05-03 | Johnson | Missouri | 29101 | 12165 | 140 |
2465294 | 2465294 | 2022-05-02 | Johnson | Missouri | 29101 | 12165 | 140 |
2462039 | 2462039 | 2022-05-01 | Johnson | Missouri | 29101 | 12165 | 140 |
2458783 | 2458783 | 2022-04-30 | Johnson | Missouri | 29101 | 12165 | 140 |
2455527 | 2455527 | 2022-04-29 | Johnson | Missouri | 29101 | 12165 | 140 |
2452271 | 2452271 | 2022-04-28 | Johnson | Missouri | 29101 | 12165 | 140 |
2449015 | 2449015 | 2022-04-27 | Johnson | Missouri | 29101 | 12165 | 140 |
2445758 | 2445758 | 2022-04-26 | Johnson | Missouri | 29101 | 12165 | 140 |
2442503 | 2442503 | 2022-04-25 | Johnson | Missouri | 29101 | 12165 | 140 |
2439247 | 2439247 | 2022-04-24 | Johnson | Missouri | 29101 | 12165 | 140 |
2435991 | 2435991 | 2022-04-23 | Johnson | Missouri | 29101 | 12165 | 140 |
2432735 | 2432735 | 2022-04-22 | Johnson | Missouri | 29101 | 12165 | 140 |
2429479 | 2429479 | 2022-04-21 | Johnson | Missouri | 29101 | 12165 | 140 |
2426223 | 2426223 | 2022-04-20 | Johnson | Missouri | 29101 | 12165 | 140 |
2422967 | 2422967 | 2022-04-19 | Johnson | Missouri | 29101 | 12165 | 140 |
2419710 | 2419710 | 2022-04-18 | Johnson | Missouri | 29101 | 12165 | 140 |
2416455 | 2416455 | 2022-04-17 | Johnson | Missouri | 29101 | 12165 | 140 |
2413199 | 2413199 | 2022-04-16 | Johnson | Missouri | 29101 | 12165 | 140 |
2409943 | 2409943 | 2022-04-15 | Johnson | Missouri | 29101 | 12165 | 140 |
2406687 | 2406687 | 2022-04-14 | Johnson | Missouri | 29101 | 12165 | 140 |
2403431 | 2403431 | 2022-04-13 | Johnson | Missouri | 29101 | 12165 | 140 |
2400176 | 2400176 | 2022-04-12 | Johnson | Missouri | 29101 | 12165 | 140 |
2396921 | 2396921 | 2022-04-11 | Johnson | Missouri | 29101 | 12165 | 140 |
2393666 | 2393666 | 2022-04-10 | Johnson | Missouri | 29101 | 12165 | 140 |
2390410 | 2390410 | 2022-04-09 | Johnson | Missouri | 29101 | 12165 | 140 |
2387154 | 2387154 | 2022-04-08 | Johnson | Missouri | 29101 | 12165 | 140 |
2383899 | 2383899 | 2022-04-07 | Johnson | Missouri | 29101 | 12165 | 140 |
2380644 | 2380644 | 2022-04-06 | Johnson | Missouri | 29101 | 12165 | 140 |
2377389 | 2377389 | 2022-04-05 | Johnson | Missouri | 29101 | 12165 | 140 |
2374136 | 2374136 | 2022-04-04 | Johnson | Missouri | 29101 | 12165 | 140 |
2370884 | 2370884 | 2022-04-03 | Johnson | Missouri | 29101 | 12165 | 140 |
2367631 | 2367631 | 2022-04-02 | Johnson | Missouri | 29101 | 12165 | 140 |
2364378 | 2364378 | 2022-04-01 | Johnson | Missouri | 29101 | 12165 | 140 |
2361124 | 2361124 | 2022-03-31 | Johnson | Missouri | 29101 | 12165 | 140 |
2357870 | 2357870 | 2022-03-30 | Johnson | Missouri | 29101 | 12156 | 140 |
2354617 | 2354617 | 2022-03-29 | Johnson | Missouri | 29101 | 12154 | 140 |
2351364 | 2351364 | 2022-03-28 | Johnson | Missouri | 29101 | 12150 | 140 |
2348112 | 2348112 | 2022-03-27 | Johnson | Missouri | 29101 | 12141 | 140 |
2344859 | 2344859 | 2022-03-26 | Johnson | Missouri | 29101 | 12141 | 140 |
2341606 | 2341606 | 2022-03-25 | Johnson | Missouri | 29101 | 12141 | 140 |
2338353 | 2338353 | 2022-03-24 | Johnson | Missouri | 29101 | 12141 | 140 |
2335099 | 2335099 | 2022-03-23 | Johnson | Missouri | 29101 | 12139 | 140 |
2331845 | 2331845 | 2022-03-22 | Johnson | Missouri | 29101 | 12138 | 140 |
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);