ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 29181 and state = "Missouri" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
16794 | 16794 | 2020-03-28 | Ripley | Missouri | 29181 | 1 | 0 |
18716 | 18716 | 2020-03-29 | Ripley | Missouri | 29181 | 2 | 0 |
20749 | 20749 | 2020-03-30 | Ripley | Missouri | 29181 | 2 | 0 |
22868 | 22868 | 2020-03-31 | Ripley | Missouri | 29181 | 2 | 0 |
25056 | 25056 | 2020-04-01 | Ripley | Missouri | 29181 | 2 | 0 |
27313 | 27313 | 2020-04-02 | Ripley | Missouri | 29181 | 2 | 0 |
29634 | 29634 | 2020-04-03 | Ripley | Missouri | 29181 | 2 | 0 |
32015 | 32015 | 2020-04-04 | Ripley | Missouri | 29181 | 2 | 0 |
34443 | 34443 | 2020-04-05 | Ripley | Missouri | 29181 | 2 | 0 |
36909 | 36909 | 2020-04-06 | Ripley | Missouri | 29181 | 2 | 0 |
39424 | 39424 | 2020-04-07 | Ripley | Missouri | 29181 | 2 | 0 |
41978 | 41978 | 2020-04-08 | Ripley | Missouri | 29181 | 2 | 0 |
44555 | 44555 | 2020-04-09 | Ripley | Missouri | 29181 | 2 | 0 |
47164 | 47164 | 2020-04-10 | Ripley | Missouri | 29181 | 3 | 0 |
49812 | 49812 | 2020-04-11 | Ripley | Missouri | 29181 | 3 | 0 |
52485 | 52485 | 2020-04-12 | Ripley | Missouri | 29181 | 3 | 0 |
55167 | 55167 | 2020-04-13 | Ripley | Missouri | 29181 | 3 | 0 |
57865 | 57865 | 2020-04-14 | Ripley | Missouri | 29181 | 3 | 0 |
60579 | 60579 | 2020-04-15 | Ripley | Missouri | 29181 | 3 | 0 |
63301 | 63301 | 2020-04-16 | Ripley | Missouri | 29181 | 3 | 0 |
66041 | 66041 | 2020-04-17 | Ripley | Missouri | 29181 | 3 | 0 |
68795 | 68795 | 2020-04-18 | Ripley | Missouri | 29181 | 4 | 0 |
71562 | 71562 | 2020-04-19 | Ripley | Missouri | 29181 | 3 | 0 |
74335 | 74335 | 2020-04-20 | Ripley | Missouri | 29181 | 3 | 0 |
77116 | 77116 | 2020-04-21 | Ripley | Missouri | 29181 | 3 | 0 |
79903 | 79903 | 2020-04-22 | Ripley | Missouri | 29181 | 4 | 0 |
82699 | 82699 | 2020-04-23 | Ripley | Missouri | 29181 | 4 | 0 |
85503 | 85503 | 2020-04-24 | Ripley | Missouri | 29181 | 4 | 0 |
88313 | 88313 | 2020-04-25 | Ripley | Missouri | 29181 | 5 | 0 |
91129 | 91129 | 2020-04-26 | Ripley | Missouri | 29181 | 5 | 0 |
93950 | 93950 | 2020-04-27 | Ripley | Missouri | 29181 | 5 | 0 |
96786 | 96786 | 2020-04-28 | Ripley | Missouri | 29181 | 5 | 0 |
99632 | 99632 | 2020-04-29 | Ripley | Missouri | 29181 | 5 | 0 |
102484 | 102484 | 2020-04-30 | Ripley | Missouri | 29181 | 5 | 0 |
105345 | 105345 | 2020-05-01 | Ripley | Missouri | 29181 | 5 | 0 |
108210 | 108210 | 2020-05-02 | Ripley | Missouri | 29181 | 5 | 0 |
111082 | 111082 | 2020-05-03 | Ripley | Missouri | 29181 | 5 | 0 |
113961 | 113961 | 2020-05-04 | Ripley | Missouri | 29181 | 5 | 0 |
116843 | 116843 | 2020-05-05 | Ripley | Missouri | 29181 | 5 | 0 |
119803 | 119803 | 2020-05-06 | Ripley | Missouri | 29181 | 5 | 0 |
122777 | 122777 | 2020-05-07 | Ripley | Missouri | 29181 | 5 | 0 |
125759 | 125759 | 2020-05-08 | Ripley | Missouri | 29181 | 5 | 0 |
128747 | 128747 | 2020-05-09 | Ripley | Missouri | 29181 | 5 | 0 |
131737 | 131737 | 2020-05-10 | Ripley | Missouri | 29181 | 5 | 0 |
134728 | 134728 | 2020-05-11 | Ripley | Missouri | 29181 | 5 | 0 |
137718 | 137718 | 2020-05-12 | Ripley | Missouri | 29181 | 5 | 0 |
140712 | 140712 | 2020-05-13 | Ripley | Missouri | 29181 | 5 | 0 |
143707 | 143707 | 2020-05-14 | Ripley | Missouri | 29181 | 6 | 0 |
146708 | 146708 | 2020-05-15 | Ripley | Missouri | 29181 | 6 | 0 |
149713 | 149713 | 2020-05-16 | Ripley | Missouri | 29181 | 6 | 0 |
152724 | 152724 | 2020-05-17 | Ripley | Missouri | 29181 | 6 | 0 |
155738 | 155738 | 2020-05-18 | Ripley | Missouri | 29181 | 7 | 0 |
158756 | 158756 | 2020-05-19 | Ripley | Missouri | 29181 | 7 | 0 |
161782 | 161782 | 2020-05-20 | Ripley | Missouri | 29181 | 7 | 0 |
164811 | 164811 | 2020-05-21 | Ripley | Missouri | 29181 | 7 | 0 |
167847 | 167847 | 2020-05-22 | Ripley | Missouri | 29181 | 7 | 0 |
170886 | 170886 | 2020-05-23 | Ripley | Missouri | 29181 | 7 | 0 |
173928 | 173928 | 2020-05-24 | Ripley | Missouri | 29181 | 7 | 0 |
176971 | 176971 | 2020-05-25 | Ripley | Missouri | 29181 | 7 | 0 |
180015 | 180015 | 2020-05-26 | Ripley | Missouri | 29181 | 7 | 0 |
183062 | 183062 | 2020-05-27 | Ripley | Missouri | 29181 | 7 | 0 |
186118 | 186118 | 2020-05-28 | Ripley | Missouri | 29181 | 7 | 0 |
189176 | 189176 | 2020-05-29 | Ripley | Missouri | 29181 | 7 | 0 |
192240 | 192240 | 2020-05-30 | Ripley | Missouri | 29181 | 7 | 0 |
195310 | 195310 | 2020-05-31 | Ripley | Missouri | 29181 | 7 | 0 |
198381 | 198381 | 2020-06-01 | Ripley | Missouri | 29181 | 7 | 0 |
201454 | 201454 | 2020-06-02 | Ripley | Missouri | 29181 | 8 | 0 |
204531 | 204531 | 2020-06-03 | Ripley | Missouri | 29181 | 10 | 0 |
207612 | 207612 | 2020-06-04 | Ripley | Missouri | 29181 | 10 | 0 |
210693 | 210693 | 2020-06-05 | Ripley | Missouri | 29181 | 11 | 0 |
213777 | 213777 | 2020-06-06 | Ripley | Missouri | 29181 | 11 | 0 |
216866 | 216866 | 2020-06-07 | Ripley | Missouri | 29181 | 11 | 0 |
219958 | 219958 | 2020-06-08 | Ripley | Missouri | 29181 | 11 | 0 |
223053 | 223053 | 2020-06-09 | Ripley | Missouri | 29181 | 11 | 0 |
226152 | 226152 | 2020-06-10 | Ripley | Missouri | 29181 | 11 | 0 |
229255 | 229255 | 2020-06-11 | Ripley | Missouri | 29181 | 11 | 0 |
232359 | 232359 | 2020-06-12 | Ripley | Missouri | 29181 | 12 | 0 |
235465 | 235465 | 2020-06-13 | Ripley | Missouri | 29181 | 11 | 0 |
238572 | 238572 | 2020-06-14 | Ripley | Missouri | 29181 | 11 | 0 |
241682 | 241682 | 2020-06-15 | Ripley | Missouri | 29181 | 11 | 0 |
244793 | 244793 | 2020-06-16 | Ripley | Missouri | 29181 | 11 | 0 |
247906 | 247906 | 2020-06-17 | Ripley | Missouri | 29181 | 12 | 0 |
251019 | 251019 | 2020-06-18 | Ripley | Missouri | 29181 | 12 | 0 |
254134 | 254134 | 2020-06-19 | Ripley | Missouri | 29181 | 12 | 0 |
257255 | 257255 | 2020-06-20 | Ripley | Missouri | 29181 | 14 | 0 |
260381 | 260381 | 2020-06-21 | Ripley | Missouri | 29181 | 14 | 0 |
263509 | 263509 | 2020-06-22 | Ripley | Missouri | 29181 | 14 | 0 |
266635 | 266635 | 2020-06-23 | Ripley | Missouri | 29181 | 14 | 0 |
269768 | 269768 | 2020-06-24 | Ripley | Missouri | 29181 | 16 | 0 |
272907 | 272907 | 2020-06-25 | Ripley | Missouri | 29181 | 17 | 0 |
276050 | 276050 | 2020-06-26 | Ripley | Missouri | 29181 | 17 | 0 |
279198 | 279198 | 2020-06-27 | Ripley | Missouri | 29181 | 17 | 0 |
282346 | 282346 | 2020-06-28 | Ripley | Missouri | 29181 | 18 | 0 |
285491 | 285491 | 2020-06-29 | Ripley | Missouri | 29181 | 19 | 0 |
288641 | 288641 | 2020-06-30 | Ripley | Missouri | 29181 | 19 | 0 |
291792 | 291792 | 2020-07-01 | Ripley | Missouri | 29181 | 19 | 0 |
294946 | 294946 | 2020-07-02 | Ripley | Missouri | 29181 | 19 | 0 |
298104 | 298104 | 2020-07-03 | Ripley | Missouri | 29181 | 19 | 0 |
301267 | 301267 | 2020-07-04 | Ripley | Missouri | 29181 | 19 | 0 |
304431 | 304431 | 2020-07-05 | Ripley | Missouri | 29181 | 19 | 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);