ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 29041 and state = "Missouri" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14941 | 14941 | 2020-03-27 | Chariton | Missouri | 29041 | 1 | 0 |
16765 | 16765 | 2020-03-28 | Chariton | Missouri | 29041 | 1 | 0 |
18687 | 18687 | 2020-03-29 | Chariton | Missouri | 29041 | 1 | 0 |
20712 | 20712 | 2020-03-30 | Chariton | Missouri | 29041 | 3 | 0 |
22830 | 22830 | 2020-03-31 | Chariton | Missouri | 29041 | 4 | 0 |
25016 | 25016 | 2020-04-01 | Chariton | Missouri | 29041 | 4 | 0 |
27271 | 27271 | 2020-04-02 | Chariton | Missouri | 29041 | 4 | 0 |
29590 | 29590 | 2020-04-03 | Chariton | Missouri | 29041 | 4 | 0 |
31970 | 31970 | 2020-04-04 | Chariton | Missouri | 29041 | 4 | 0 |
34398 | 34398 | 2020-04-05 | Chariton | Missouri | 29041 | 4 | 0 |
36861 | 36861 | 2020-04-06 | Chariton | Missouri | 29041 | 4 | 0 |
39372 | 39372 | 2020-04-07 | Chariton | Missouri | 29041 | 4 | 0 |
41926 | 41926 | 2020-04-08 | Chariton | Missouri | 29041 | 4 | 0 |
44503 | 44503 | 2020-04-09 | Chariton | Missouri | 29041 | 4 | 0 |
47112 | 47112 | 2020-04-10 | Chariton | Missouri | 29041 | 4 | 0 |
49759 | 49759 | 2020-04-11 | Chariton | Missouri | 29041 | 4 | 0 |
52432 | 52432 | 2020-04-12 | Chariton | Missouri | 29041 | 4 | 0 |
55114 | 55114 | 2020-04-13 | Chariton | Missouri | 29041 | 4 | 0 |
57812 | 57812 | 2020-04-14 | Chariton | Missouri | 29041 | 4 | 0 |
60523 | 60523 | 2020-04-15 | Chariton | Missouri | 29041 | 4 | 0 |
63245 | 63245 | 2020-04-16 | Chariton | Missouri | 29041 | 4 | 0 |
65985 | 65985 | 2020-04-17 | Chariton | Missouri | 29041 | 4 | 0 |
68737 | 68737 | 2020-04-18 | Chariton | Missouri | 29041 | 4 | 0 |
71504 | 71504 | 2020-04-19 | Chariton | Missouri | 29041 | 4 | 0 |
74277 | 74277 | 2020-04-20 | Chariton | Missouri | 29041 | 4 | 0 |
77058 | 77058 | 2020-04-21 | Chariton | Missouri | 29041 | 4 | 0 |
79844 | 79844 | 2020-04-22 | Chariton | Missouri | 29041 | 4 | 0 |
82640 | 82640 | 2020-04-23 | Chariton | Missouri | 29041 | 4 | 0 |
85444 | 85444 | 2020-04-24 | Chariton | Missouri | 29041 | 5 | 0 |
88254 | 88254 | 2020-04-25 | Chariton | Missouri | 29041 | 5 | 0 |
91070 | 91070 | 2020-04-26 | Chariton | Missouri | 29041 | 5 | 0 |
93891 | 93891 | 2020-04-27 | Chariton | Missouri | 29041 | 5 | 0 |
96727 | 96727 | 2020-04-28 | Chariton | Missouri | 29041 | 5 | 0 |
99573 | 99573 | 2020-04-29 | Chariton | Missouri | 29041 | 5 | 0 |
102425 | 102425 | 2020-04-30 | Chariton | Missouri | 29041 | 5 | 0 |
105286 | 105286 | 2020-05-01 | Chariton | Missouri | 29041 | 5 | 0 |
108151 | 108151 | 2020-05-02 | Chariton | Missouri | 29041 | 5 | 0 |
111022 | 111022 | 2020-05-03 | Chariton | Missouri | 29041 | 5 | 0 |
113901 | 113901 | 2020-05-04 | Chariton | Missouri | 29041 | 5 | 0 |
116783 | 116783 | 2020-05-05 | Chariton | Missouri | 29041 | 5 | 0 |
119743 | 119743 | 2020-05-06 | Chariton | Missouri | 29041 | 5 | 0 |
122717 | 122717 | 2020-05-07 | Chariton | Missouri | 29041 | 6 | 0 |
125699 | 125699 | 2020-05-08 | Chariton | Missouri | 29041 | 5 | 0 |
128686 | 128686 | 2020-05-09 | Chariton | Missouri | 29041 | 5 | 0 |
131676 | 131676 | 2020-05-10 | Chariton | Missouri | 29041 | 5 | 0 |
134667 | 134667 | 2020-05-11 | Chariton | Missouri | 29041 | 5 | 0 |
137657 | 137657 | 2020-05-12 | Chariton | Missouri | 29041 | 5 | 0 |
140651 | 140651 | 2020-05-13 | Chariton | Missouri | 29041 | 6 | 0 |
143646 | 143646 | 2020-05-14 | Chariton | Missouri | 29041 | 6 | 0 |
146646 | 146646 | 2020-05-15 | Chariton | Missouri | 29041 | 6 | 0 |
149651 | 149651 | 2020-05-16 | Chariton | Missouri | 29041 | 6 | 0 |
152662 | 152662 | 2020-05-17 | Chariton | Missouri | 29041 | 6 | 0 |
155676 | 155676 | 2020-05-18 | Chariton | Missouri | 29041 | 6 | 0 |
158694 | 158694 | 2020-05-19 | Chariton | Missouri | 29041 | 6 | 0 |
161720 | 161720 | 2020-05-20 | Chariton | Missouri | 29041 | 6 | 0 |
164749 | 164749 | 2020-05-21 | Chariton | Missouri | 29041 | 6 | 0 |
167785 | 167785 | 2020-05-22 | Chariton | Missouri | 29041 | 6 | 0 |
170823 | 170823 | 2020-05-23 | Chariton | Missouri | 29041 | 5 | 0 |
173865 | 173865 | 2020-05-24 | Chariton | Missouri | 29041 | 5 | 0 |
176908 | 176908 | 2020-05-25 | Chariton | Missouri | 29041 | 5 | 0 |
179952 | 179952 | 2020-05-26 | Chariton | Missouri | 29041 | 5 | 0 |
182998 | 182998 | 2020-05-27 | Chariton | Missouri | 29041 | 6 | 0 |
186054 | 186054 | 2020-05-28 | Chariton | Missouri | 29041 | 6 | 0 |
189112 | 189112 | 2020-05-29 | Chariton | Missouri | 29041 | 6 | 0 |
192176 | 192176 | 2020-05-30 | Chariton | Missouri | 29041 | 6 | 0 |
195244 | 195244 | 2020-05-31 | Chariton | Missouri | 29041 | 6 | 0 |
198315 | 198315 | 2020-06-01 | Chariton | Missouri | 29041 | 6 | 0 |
201388 | 201388 | 2020-06-02 | Chariton | Missouri | 29041 | 6 | 0 |
204465 | 204465 | 2020-06-03 | Chariton | Missouri | 29041 | 6 | 0 |
207546 | 207546 | 2020-06-04 | Chariton | Missouri | 29041 | 6 | 0 |
210627 | 210627 | 2020-06-05 | Chariton | Missouri | 29041 | 6 | 0 |
213711 | 213711 | 2020-06-06 | Chariton | Missouri | 29041 | 6 | 0 |
216799 | 216799 | 2020-06-07 | Chariton | Missouri | 29041 | 6 | 0 |
219891 | 219891 | 2020-06-08 | Chariton | Missouri | 29041 | 6 | 0 |
222986 | 222986 | 2020-06-09 | Chariton | Missouri | 29041 | 6 | 0 |
226084 | 226084 | 2020-06-10 | Chariton | Missouri | 29041 | 6 | 0 |
229187 | 229187 | 2020-06-11 | Chariton | Missouri | 29041 | 6 | 0 |
232291 | 232291 | 2020-06-12 | Chariton | Missouri | 29041 | 6 | 0 |
235397 | 235397 | 2020-06-13 | Chariton | Missouri | 29041 | 6 | 0 |
238504 | 238504 | 2020-06-14 | Chariton | Missouri | 29041 | 6 | 0 |
241613 | 241613 | 2020-06-15 | Chariton | Missouri | 29041 | 6 | 0 |
244724 | 244724 | 2020-06-16 | Chariton | Missouri | 29041 | 6 | 0 |
247837 | 247837 | 2020-06-17 | Chariton | Missouri | 29041 | 6 | 0 |
250950 | 250950 | 2020-06-18 | Chariton | Missouri | 29041 | 6 | 0 |
254065 | 254065 | 2020-06-19 | Chariton | Missouri | 29041 | 6 | 0 |
257185 | 257185 | 2020-06-20 | Chariton | Missouri | 29041 | 6 | 0 |
260311 | 260311 | 2020-06-21 | Chariton | Missouri | 29041 | 6 | 0 |
263439 | 263439 | 2020-06-22 | Chariton | Missouri | 29041 | 6 | 0 |
266565 | 266565 | 2020-06-23 | Chariton | Missouri | 29041 | 6 | 0 |
269698 | 269698 | 2020-06-24 | Chariton | Missouri | 29041 | 6 | 0 |
272836 | 272836 | 2020-06-25 | Chariton | Missouri | 29041 | 6 | 0 |
275979 | 275979 | 2020-06-26 | Chariton | Missouri | 29041 | 6 | 0 |
279127 | 279127 | 2020-06-27 | Chariton | Missouri | 29041 | 6 | 0 |
282275 | 282275 | 2020-06-28 | Chariton | Missouri | 29041 | 6 | 0 |
285420 | 285420 | 2020-06-29 | Chariton | Missouri | 29041 | 6 | 0 |
288570 | 288570 | 2020-06-30 | Chariton | Missouri | 29041 | 6 | 0 |
291721 | 291721 | 2020-07-01 | Chariton | Missouri | 29041 | 6 | 0 |
294875 | 294875 | 2020-07-02 | Chariton | Missouri | 29041 | 6 | 0 |
298033 | 298033 | 2020-07-03 | Chariton | Missouri | 29041 | 6 | 0 |
301196 | 301196 | 2020-07-04 | Chariton | Missouri | 29041 | 6 | 0 |
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);