ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 29149 and state = "Missouri" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
39410 | 39410 | 2020-04-07 | Oregon | Missouri | 29149 | 1 | 0 |
41964 | 41964 | 2020-04-08 | Oregon | Missouri | 29149 | 1 | 0 |
44541 | 44541 | 2020-04-09 | Oregon | Missouri | 29149 | 1 | 0 |
47150 | 47150 | 2020-04-10 | Oregon | Missouri | 29149 | 1 | 0 |
49798 | 49798 | 2020-04-11 | Oregon | Missouri | 29149 | 1 | 0 |
52471 | 52471 | 2020-04-12 | Oregon | Missouri | 29149 | 1 | 0 |
55153 | 55153 | 2020-04-13 | Oregon | Missouri | 29149 | 1 | 0 |
57851 | 57851 | 2020-04-14 | Oregon | Missouri | 29149 | 1 | 0 |
60565 | 60565 | 2020-04-15 | Oregon | Missouri | 29149 | 1 | 0 |
63287 | 63287 | 2020-04-16 | Oregon | Missouri | 29149 | 1 | 0 |
66027 | 66027 | 2020-04-17 | Oregon | Missouri | 29149 | 1 | 0 |
68781 | 68781 | 2020-04-18 | Oregon | Missouri | 29149 | 1 | 0 |
71548 | 71548 | 2020-04-19 | Oregon | Missouri | 29149 | 1 | 0 |
74321 | 74321 | 2020-04-20 | Oregon | Missouri | 29149 | 1 | 0 |
77102 | 77102 | 2020-04-21 | Oregon | Missouri | 29149 | 1 | 0 |
79889 | 79889 | 2020-04-22 | Oregon | Missouri | 29149 | 1 | 0 |
82685 | 82685 | 2020-04-23 | Oregon | Missouri | 29149 | 1 | 0 |
85489 | 85489 | 2020-04-24 | Oregon | Missouri | 29149 | 1 | 0 |
88299 | 88299 | 2020-04-25 | Oregon | Missouri | 29149 | 1 | 0 |
91115 | 91115 | 2020-04-26 | Oregon | Missouri | 29149 | 1 | 0 |
93936 | 93936 | 2020-04-27 | Oregon | Missouri | 29149 | 1 | 0 |
96772 | 96772 | 2020-04-28 | Oregon | Missouri | 29149 | 1 | 0 |
99618 | 99618 | 2020-04-29 | Oregon | Missouri | 29149 | 1 | 0 |
102470 | 102470 | 2020-04-30 | Oregon | Missouri | 29149 | 1 | 0 |
105331 | 105331 | 2020-05-01 | Oregon | Missouri | 29149 | 1 | 0 |
108196 | 108196 | 2020-05-02 | Oregon | Missouri | 29149 | 2 | 0 |
111068 | 111068 | 2020-05-03 | Oregon | Missouri | 29149 | 2 | 0 |
113947 | 113947 | 2020-05-04 | Oregon | Missouri | 29149 | 2 | 0 |
116829 | 116829 | 2020-05-05 | Oregon | Missouri | 29149 | 2 | 0 |
119789 | 119789 | 2020-05-06 | Oregon | Missouri | 29149 | 2 | 0 |
122763 | 122763 | 2020-05-07 | Oregon | Missouri | 29149 | 2 | 0 |
125745 | 125745 | 2020-05-08 | Oregon | Missouri | 29149 | 2 | 0 |
128733 | 128733 | 2020-05-09 | Oregon | Missouri | 29149 | 2 | 0 |
131723 | 131723 | 2020-05-10 | Oregon | Missouri | 29149 | 2 | 0 |
134714 | 134714 | 2020-05-11 | Oregon | Missouri | 29149 | 2 | 0 |
137704 | 137704 | 2020-05-12 | Oregon | Missouri | 29149 | 2 | 0 |
140698 | 140698 | 2020-05-13 | Oregon | Missouri | 29149 | 2 | 0 |
143693 | 143693 | 2020-05-14 | Oregon | Missouri | 29149 | 2 | 0 |
146694 | 146694 | 2020-05-15 | Oregon | Missouri | 29149 | 2 | 0 |
149699 | 149699 | 2020-05-16 | Oregon | Missouri | 29149 | 2 | 0 |
152710 | 152710 | 2020-05-17 | Oregon | Missouri | 29149 | 2 | 0 |
155724 | 155724 | 2020-05-18 | Oregon | Missouri | 29149 | 2 | 0 |
158742 | 158742 | 2020-05-19 | Oregon | Missouri | 29149 | 2 | 0 |
161768 | 161768 | 2020-05-20 | Oregon | Missouri | 29149 | 2 | 0 |
164797 | 164797 | 2020-05-21 | Oregon | Missouri | 29149 | 2 | 0 |
167833 | 167833 | 2020-05-22 | Oregon | Missouri | 29149 | 2 | 0 |
170872 | 170872 | 2020-05-23 | Oregon | Missouri | 29149 | 2 | 0 |
173914 | 173914 | 2020-05-24 | Oregon | Missouri | 29149 | 2 | 0 |
176957 | 176957 | 2020-05-25 | Oregon | Missouri | 29149 | 2 | 0 |
180001 | 180001 | 2020-05-26 | Oregon | Missouri | 29149 | 2 | 0 |
183048 | 183048 | 2020-05-27 | Oregon | Missouri | 29149 | 2 | 0 |
186104 | 186104 | 2020-05-28 | Oregon | Missouri | 29149 | 2 | 0 |
189162 | 189162 | 2020-05-29 | Oregon | Missouri | 29149 | 2 | 0 |
192226 | 192226 | 2020-05-30 | Oregon | Missouri | 29149 | 2 | 0 |
195296 | 195296 | 2020-05-31 | Oregon | Missouri | 29149 | 2 | 0 |
198367 | 198367 | 2020-06-01 | Oregon | Missouri | 29149 | 2 | 0 |
201440 | 201440 | 2020-06-02 | Oregon | Missouri | 29149 | 2 | 0 |
204517 | 204517 | 2020-06-03 | Oregon | Missouri | 29149 | 2 | 0 |
207598 | 207598 | 2020-06-04 | Oregon | Missouri | 29149 | 2 | 0 |
210679 | 210679 | 2020-06-05 | Oregon | Missouri | 29149 | 2 | 0 |
213763 | 213763 | 2020-06-06 | Oregon | Missouri | 29149 | 2 | 0 |
216851 | 216851 | 2020-06-07 | Oregon | Missouri | 29149 | 2 | 0 |
219943 | 219943 | 2020-06-08 | Oregon | Missouri | 29149 | 2 | 0 |
223038 | 223038 | 2020-06-09 | Oregon | Missouri | 29149 | 2 | 0 |
226137 | 226137 | 2020-06-10 | Oregon | Missouri | 29149 | 2 | 0 |
229240 | 229240 | 2020-06-11 | Oregon | Missouri | 29149 | 3 | 0 |
232344 | 232344 | 2020-06-12 | Oregon | Missouri | 29149 | 3 | 0 |
235450 | 235450 | 2020-06-13 | Oregon | Missouri | 29149 | 4 | 0 |
238557 | 238557 | 2020-06-14 | Oregon | Missouri | 29149 | 4 | 0 |
241667 | 241667 | 2020-06-15 | Oregon | Missouri | 29149 | 4 | 0 |
244778 | 244778 | 2020-06-16 | Oregon | Missouri | 29149 | 4 | 0 |
247891 | 247891 | 2020-06-17 | Oregon | Missouri | 29149 | 6 | 0 |
251004 | 251004 | 2020-06-18 | Oregon | Missouri | 29149 | 6 | 0 |
254119 | 254119 | 2020-06-19 | Oregon | Missouri | 29149 | 6 | 0 |
257239 | 257239 | 2020-06-20 | Oregon | Missouri | 29149 | 6 | 0 |
260365 | 260365 | 2020-06-21 | Oregon | Missouri | 29149 | 6 | 0 |
263493 | 263493 | 2020-06-22 | Oregon | Missouri | 29149 | 6 | 0 |
266619 | 266619 | 2020-06-23 | Oregon | Missouri | 29149 | 6 | 0 |
269752 | 269752 | 2020-06-24 | Oregon | Missouri | 29149 | 6 | 0 |
272891 | 272891 | 2020-06-25 | Oregon | Missouri | 29149 | 6 | 0 |
276034 | 276034 | 2020-06-26 | Oregon | Missouri | 29149 | 6 | 0 |
279182 | 279182 | 2020-06-27 | Oregon | Missouri | 29149 | 7 | 0 |
282330 | 282330 | 2020-06-28 | Oregon | Missouri | 29149 | 7 | 0 |
285475 | 285475 | 2020-06-29 | Oregon | Missouri | 29149 | 8 | 0 |
288625 | 288625 | 2020-06-30 | Oregon | Missouri | 29149 | 7 | 0 |
291776 | 291776 | 2020-07-01 | Oregon | Missouri | 29149 | 7 | 0 |
294930 | 294930 | 2020-07-02 | Oregon | Missouri | 29149 | 7 | 0 |
298088 | 298088 | 2020-07-03 | Oregon | Missouri | 29149 | 7 | 0 |
301251 | 301251 | 2020-07-04 | Oregon | Missouri | 29149 | 8 | 0 |
304415 | 304415 | 2020-07-05 | Oregon | Missouri | 29149 | 8 | 0 |
307582 | 307582 | 2020-07-06 | Oregon | Missouri | 29149 | 8 | 0 |
310750 | 310750 | 2020-07-07 | Oregon | Missouri | 29149 | 8 | 0 |
313921 | 313921 | 2020-07-08 | Oregon | Missouri | 29149 | 9 | 0 |
317095 | 317095 | 2020-07-09 | Oregon | Missouri | 29149 | 9 | 0 |
320270 | 320270 | 2020-07-10 | Oregon | Missouri | 29149 | 9 | 0 |
323449 | 323449 | 2020-07-11 | Oregon | Missouri | 29149 | 9 | 0 |
326632 | 326632 | 2020-07-12 | Oregon | Missouri | 29149 | 9 | 0 |
329818 | 329818 | 2020-07-13 | Oregon | Missouri | 29149 | 9 | 0 |
333005 | 333005 | 2020-07-14 | Oregon | Missouri | 29149 | 9 | 0 |
336198 | 336198 | 2020-07-15 | Oregon | Missouri | 29149 | 9 | 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);