ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 137, fips = 29221 and state = "Missouri" 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 |
---|---|---|---|---|---|---|---|
2471868 | 2471868 | 2022-05-04 | Washington | Missouri | 29221 | 5983 | 137 |
2468612 | 2468612 | 2022-05-03 | Washington | Missouri | 29221 | 5983 | 137 |
2465356 | 2465356 | 2022-05-02 | Washington | Missouri | 29221 | 5983 | 137 |
2462101 | 2462101 | 2022-05-01 | Washington | Missouri | 29221 | 5983 | 137 |
2458845 | 2458845 | 2022-04-30 | Washington | Missouri | 29221 | 5983 | 137 |
2455589 | 2455589 | 2022-04-29 | Washington | Missouri | 29221 | 5983 | 137 |
2452333 | 2452333 | 2022-04-28 | Washington | Missouri | 29221 | 5983 | 137 |
2449077 | 2449077 | 2022-04-27 | Washington | Missouri | 29221 | 5983 | 137 |
2445820 | 2445820 | 2022-04-26 | Washington | Missouri | 29221 | 5983 | 137 |
2442565 | 2442565 | 2022-04-25 | Washington | Missouri | 29221 | 5983 | 137 |
2439309 | 2439309 | 2022-04-24 | Washington | Missouri | 29221 | 5983 | 137 |
2436053 | 2436053 | 2022-04-23 | Washington | Missouri | 29221 | 5983 | 137 |
2432797 | 2432797 | 2022-04-22 | Washington | Missouri | 29221 | 5983 | 137 |
2429541 | 2429541 | 2022-04-21 | Washington | Missouri | 29221 | 5983 | 137 |
2426285 | 2426285 | 2022-04-20 | Washington | Missouri | 29221 | 5983 | 137 |
2423029 | 2423029 | 2022-04-19 | Washington | Missouri | 29221 | 5983 | 137 |
2419772 | 2419772 | 2022-04-18 | Washington | Missouri | 29221 | 5983 | 137 |
2416517 | 2416517 | 2022-04-17 | Washington | Missouri | 29221 | 5983 | 137 |
2413261 | 2413261 | 2022-04-16 | Washington | Missouri | 29221 | 5983 | 137 |
2410005 | 2410005 | 2022-04-15 | Washington | Missouri | 29221 | 5983 | 137 |
2406749 | 2406749 | 2022-04-14 | Washington | Missouri | 29221 | 5983 | 137 |
2403493 | 2403493 | 2022-04-13 | Washington | Missouri | 29221 | 5983 | 137 |
2400238 | 2400238 | 2022-04-12 | Washington | Missouri | 29221 | 5983 | 137 |
2396983 | 2396983 | 2022-04-11 | Washington | Missouri | 29221 | 5983 | 137 |
2393728 | 2393728 | 2022-04-10 | Washington | Missouri | 29221 | 5983 | 137 |
2390472 | 2390472 | 2022-04-09 | Washington | Missouri | 29221 | 5983 | 137 |
2387216 | 2387216 | 2022-04-08 | Washington | Missouri | 29221 | 5983 | 137 |
2383961 | 2383961 | 2022-04-07 | Washington | Missouri | 29221 | 5983 | 137 |
2380706 | 2380706 | 2022-04-06 | Washington | Missouri | 29221 | 5983 | 137 |
2377451 | 2377451 | 2022-04-05 | Washington | Missouri | 29221 | 5983 | 137 |
2374198 | 2374198 | 2022-04-04 | Washington | Missouri | 29221 | 5983 | 137 |
2370946 | 2370946 | 2022-04-03 | Washington | Missouri | 29221 | 5983 | 137 |
2367693 | 2367693 | 2022-04-02 | Washington | Missouri | 29221 | 5983 | 137 |
2364440 | 2364440 | 2022-04-01 | Washington | Missouri | 29221 | 5983 | 137 |
2361186 | 2361186 | 2022-03-31 | Washington | Missouri | 29221 | 5983 | 137 |
2357932 | 2357932 | 2022-03-30 | Washington | Missouri | 29221 | 5971 | 137 |
2354679 | 2354679 | 2022-03-29 | Washington | Missouri | 29221 | 5964 | 137 |
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);