ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 8040 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471841 | 2471841 | 2022-05-04 | Polk | Missouri | 29167 | 8040 | 108 |
2468585 | 2468585 | 2022-05-03 | Polk | Missouri | 29167 | 8040 | 108 |
2465329 | 2465329 | 2022-05-02 | Polk | Missouri | 29167 | 8040 | 108 |
2462074 | 2462074 | 2022-05-01 | Polk | Missouri | 29167 | 8040 | 108 |
2458818 | 2458818 | 2022-04-30 | Polk | Missouri | 29167 | 8040 | 108 |
2455562 | 2455562 | 2022-04-29 | Polk | Missouri | 29167 | 8040 | 108 |
2452306 | 2452306 | 2022-04-28 | Polk | Missouri | 29167 | 8040 | 108 |
2449050 | 2449050 | 2022-04-27 | Polk | Missouri | 29167 | 8040 | 108 |
2445793 | 2445793 | 2022-04-26 | Polk | Missouri | 29167 | 8040 | 108 |
2442538 | 2442538 | 2022-04-25 | Polk | Missouri | 29167 | 8040 | 108 |
2439282 | 2439282 | 2022-04-24 | Polk | Missouri | 29167 | 8040 | 108 |
2436026 | 2436026 | 2022-04-23 | Polk | Missouri | 29167 | 8040 | 108 |
2432770 | 2432770 | 2022-04-22 | Polk | Missouri | 29167 | 8040 | 108 |
2429514 | 2429514 | 2022-04-21 | Polk | Missouri | 29167 | 8040 | 108 |
2426258 | 2426258 | 2022-04-20 | Polk | Missouri | 29167 | 8040 | 108 |
2423002 | 2423002 | 2022-04-19 | Polk | Missouri | 29167 | 8040 | 108 |
2419745 | 2419745 | 2022-04-18 | Polk | Missouri | 29167 | 8040 | 108 |
2416490 | 2416490 | 2022-04-17 | Polk | Missouri | 29167 | 8040 | 108 |
2413234 | 2413234 | 2022-04-16 | Polk | Missouri | 29167 | 8040 | 108 |
2409978 | 2409978 | 2022-04-15 | Polk | Missouri | 29167 | 8040 | 108 |
2406722 | 2406722 | 2022-04-14 | Polk | Missouri | 29167 | 8040 | 108 |
2403466 | 2403466 | 2022-04-13 | Polk | Missouri | 29167 | 8040 | 108 |
2400211 | 2400211 | 2022-04-12 | Polk | Missouri | 29167 | 8040 | 108 |
2396956 | 2396956 | 2022-04-11 | Polk | Missouri | 29167 | 8040 | 108 |
2393701 | 2393701 | 2022-04-10 | Polk | Missouri | 29167 | 8040 | 108 |
2390445 | 2390445 | 2022-04-09 | Polk | Missouri | 29167 | 8040 | 108 |
2387189 | 2387189 | 2022-04-08 | Polk | Missouri | 29167 | 8040 | 108 |
2383934 | 2383934 | 2022-04-07 | Polk | Missouri | 29167 | 8040 | 108 |
2380679 | 2380679 | 2022-04-06 | Polk | Missouri | 29167 | 8040 | 108 |
2377424 | 2377424 | 2022-04-05 | Polk | Missouri | 29167 | 8040 | 108 |
2374171 | 2374171 | 2022-04-04 | Polk | Missouri | 29167 | 8040 | 108 |
2370919 | 2370919 | 2022-04-03 | Polk | Missouri | 29167 | 8040 | 108 |
2367666 | 2367666 | 2022-04-02 | Polk | Missouri | 29167 | 8040 | 108 |
2364413 | 2364413 | 2022-04-01 | Polk | Missouri | 29167 | 8040 | 108 |
2361159 | 2361159 | 2022-03-31 | Polk | Missouri | 29167 | 8040 | 108 |
723977 | 723977 | 2020-11-12 | Boone | Missouri | 29019 | 8040 | 18 |
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);