ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 29059 and state = "Missouri" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
39380 | 39380 | 2020-04-07 | Dallas | Missouri | 29059 | 1 | 0 |
41934 | 41934 | 2020-04-08 | Dallas | Missouri | 29059 | 1 | 0 |
44511 | 44511 | 2020-04-09 | Dallas | Missouri | 29059 | 2 | 0 |
47120 | 47120 | 2020-04-10 | Dallas | Missouri | 29059 | 2 | 0 |
49767 | 49767 | 2020-04-11 | Dallas | Missouri | 29059 | 2 | 0 |
52440 | 52440 | 2020-04-12 | Dallas | Missouri | 29059 | 2 | 0 |
55122 | 55122 | 2020-04-13 | Dallas | Missouri | 29059 | 2 | 0 |
57820 | 57820 | 2020-04-14 | Dallas | Missouri | 29059 | 2 | 0 |
60531 | 60531 | 2020-04-15 | Dallas | Missouri | 29059 | 2 | 0 |
63253 | 63253 | 2020-04-16 | Dallas | Missouri | 29059 | 2 | 0 |
65993 | 65993 | 2020-04-17 | Dallas | Missouri | 29059 | 2 | 0 |
68745 | 68745 | 2020-04-18 | Dallas | Missouri | 29059 | 2 | 0 |
71512 | 71512 | 2020-04-19 | Dallas | Missouri | 29059 | 2 | 0 |
74285 | 74285 | 2020-04-20 | Dallas | Missouri | 29059 | 2 | 0 |
77066 | 77066 | 2020-04-21 | Dallas | Missouri | 29059 | 2 | 0 |
79852 | 79852 | 2020-04-22 | Dallas | Missouri | 29059 | 2 | 0 |
82648 | 82648 | 2020-04-23 | Dallas | Missouri | 29059 | 2 | 0 |
85452 | 85452 | 2020-04-24 | Dallas | Missouri | 29059 | 2 | 0 |
88262 | 88262 | 2020-04-25 | Dallas | Missouri | 29059 | 2 | 0 |
91078 | 91078 | 2020-04-26 | Dallas | Missouri | 29059 | 2 | 0 |
93899 | 93899 | 2020-04-27 | Dallas | Missouri | 29059 | 2 | 0 |
96735 | 96735 | 2020-04-28 | Dallas | Missouri | 29059 | 2 | 0 |
99581 | 99581 | 2020-04-29 | Dallas | Missouri | 29059 | 2 | 0 |
102433 | 102433 | 2020-04-30 | Dallas | Missouri | 29059 | 2 | 0 |
105294 | 105294 | 2020-05-01 | Dallas | Missouri | 29059 | 2 | 0 |
108159 | 108159 | 2020-05-02 | Dallas | Missouri | 29059 | 2 | 0 |
111030 | 111030 | 2020-05-03 | Dallas | Missouri | 29059 | 2 | 0 |
113909 | 113909 | 2020-05-04 | Dallas | Missouri | 29059 | 2 | 0 |
116791 | 116791 | 2020-05-05 | Dallas | Missouri | 29059 | 2 | 0 |
119751 | 119751 | 2020-05-06 | Dallas | Missouri | 29059 | 2 | 0 |
122725 | 122725 | 2020-05-07 | Dallas | Missouri | 29059 | 2 | 0 |
125707 | 125707 | 2020-05-08 | Dallas | Missouri | 29059 | 2 | 0 |
128694 | 128694 | 2020-05-09 | Dallas | Missouri | 29059 | 2 | 0 |
131684 | 131684 | 2020-05-10 | Dallas | Missouri | 29059 | 2 | 0 |
134675 | 134675 | 2020-05-11 | Dallas | Missouri | 29059 | 2 | 0 |
137665 | 137665 | 2020-05-12 | Dallas | Missouri | 29059 | 2 | 0 |
140659 | 140659 | 2020-05-13 | Dallas | Missouri | 29059 | 2 | 0 |
143654 | 143654 | 2020-05-14 | Dallas | Missouri | 29059 | 2 | 0 |
146654 | 146654 | 2020-05-15 | Dallas | Missouri | 29059 | 2 | 0 |
149659 | 149659 | 2020-05-16 | Dallas | Missouri | 29059 | 2 | 0 |
152670 | 152670 | 2020-05-17 | Dallas | Missouri | 29059 | 2 | 0 |
155684 | 155684 | 2020-05-18 | Dallas | Missouri | 29059 | 2 | 0 |
158702 | 158702 | 2020-05-19 | Dallas | Missouri | 29059 | 3 | 0 |
161728 | 161728 | 2020-05-20 | Dallas | Missouri | 29059 | 2 | 0 |
164757 | 164757 | 2020-05-21 | Dallas | Missouri | 29059 | 2 | 0 |
167793 | 167793 | 2020-05-22 | Dallas | Missouri | 29059 | 2 | 0 |
170831 | 170831 | 2020-05-23 | Dallas | Missouri | 29059 | 2 | 0 |
173873 | 173873 | 2020-05-24 | Dallas | Missouri | 29059 | 2 | 0 |
176916 | 176916 | 2020-05-25 | Dallas | Missouri | 29059 | 2 | 0 |
179960 | 179960 | 2020-05-26 | Dallas | Missouri | 29059 | 2 | 0 |
183006 | 183006 | 2020-05-27 | Dallas | Missouri | 29059 | 2 | 0 |
186062 | 186062 | 2020-05-28 | Dallas | Missouri | 29059 | 3 | 0 |
189120 | 189120 | 2020-05-29 | Dallas | Missouri | 29059 | 3 | 0 |
192184 | 192184 | 2020-05-30 | Dallas | Missouri | 29059 | 3 | 0 |
195252 | 195252 | 2020-05-31 | Dallas | Missouri | 29059 | 3 | 0 |
198323 | 198323 | 2020-06-01 | Dallas | Missouri | 29059 | 3 | 0 |
201396 | 201396 | 2020-06-02 | Dallas | Missouri | 29059 | 3 | 0 |
204473 | 204473 | 2020-06-03 | Dallas | Missouri | 29059 | 3 | 0 |
207554 | 207554 | 2020-06-04 | Dallas | Missouri | 29059 | 4 | 0 |
210635 | 210635 | 2020-06-05 | Dallas | Missouri | 29059 | 4 | 0 |
213719 | 213719 | 2020-06-06 | Dallas | Missouri | 29059 | 4 | 0 |
216807 | 216807 | 2020-06-07 | Dallas | Missouri | 29059 | 5 | 0 |
219899 | 219899 | 2020-06-08 | Dallas | Missouri | 29059 | 5 | 0 |
222994 | 222994 | 2020-06-09 | Dallas | Missouri | 29059 | 6 | 0 |
226092 | 226092 | 2020-06-10 | Dallas | Missouri | 29059 | 6 | 0 |
229195 | 229195 | 2020-06-11 | Dallas | Missouri | 29059 | 6 | 0 |
232299 | 232299 | 2020-06-12 | Dallas | Missouri | 29059 | 6 | 0 |
235405 | 235405 | 2020-06-13 | Dallas | Missouri | 29059 | 6 | 0 |
238512 | 238512 | 2020-06-14 | Dallas | Missouri | 29059 | 6 | 0 |
241622 | 241622 | 2020-06-15 | Dallas | Missouri | 29059 | 6 | 0 |
244733 | 244733 | 2020-06-16 | Dallas | Missouri | 29059 | 6 | 0 |
247846 | 247846 | 2020-06-17 | Dallas | Missouri | 29059 | 6 | 0 |
250959 | 250959 | 2020-06-18 | Dallas | Missouri | 29059 | 7 | 0 |
254074 | 254074 | 2020-06-19 | Dallas | Missouri | 29059 | 9 | 0 |
257194 | 257194 | 2020-06-20 | Dallas | Missouri | 29059 | 9 | 0 |
260320 | 260320 | 2020-06-21 | Dallas | Missouri | 29059 | 9 | 0 |
263448 | 263448 | 2020-06-22 | Dallas | Missouri | 29059 | 10 | 0 |
266574 | 266574 | 2020-06-23 | Dallas | Missouri | 29059 | 12 | 0 |
269707 | 269707 | 2020-06-24 | Dallas | Missouri | 29059 | 12 | 1 |
272845 | 272845 | 2020-06-25 | Dallas | Missouri | 29059 | 12 | 1 |
275988 | 275988 | 2020-06-26 | Dallas | Missouri | 29059 | 12 | 1 |
279136 | 279136 | 2020-06-27 | Dallas | Missouri | 29059 | 12 | 1 |
282284 | 282284 | 2020-06-28 | Dallas | Missouri | 29059 | 13 | 1 |
285429 | 285429 | 2020-06-29 | Dallas | Missouri | 29059 | 13 | 1 |
288579 | 288579 | 2020-06-30 | Dallas | Missouri | 29059 | 13 | 1 |
291730 | 291730 | 2020-07-01 | Dallas | Missouri | 29059 | 13 | 1 |
294884 | 294884 | 2020-07-02 | Dallas | Missouri | 29059 | 14 | 1 |
298042 | 298042 | 2020-07-03 | Dallas | Missouri | 29059 | 14 | 1 |
301205 | 301205 | 2020-07-04 | Dallas | Missouri | 29059 | 14 | 1 |
304369 | 304369 | 2020-07-05 | Dallas | Missouri | 29059 | 14 | 1 |
307536 | 307536 | 2020-07-06 | Dallas | Missouri | 29059 | 15 | 1 |
310704 | 310704 | 2020-07-07 | Dallas | Missouri | 29059 | 15 | 1 |
313874 | 313874 | 2020-07-08 | Dallas | Missouri | 29059 | 16 | 1 |
317048 | 317048 | 2020-07-09 | Dallas | Missouri | 29059 | 17 | 1 |
320223 | 320223 | 2020-07-10 | Dallas | Missouri | 29059 | 17 | 1 |
323402 | 323402 | 2020-07-11 | Dallas | Missouri | 29059 | 18 | 1 |
326585 | 326585 | 2020-07-12 | Dallas | Missouri | 29059 | 18 | 1 |
329771 | 329771 | 2020-07-13 | Dallas | Missouri | 29059 | 18 | 1 |
332958 | 332958 | 2020-07-14 | Dallas | Missouri | 29059 | 20 | 1 |
336151 | 336151 | 2020-07-15 | Dallas | Missouri | 29059 | 22 | 1 |
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);