ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where county = "St. Francois", deaths = 2, fips = 29187 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
439056 | 439056 | 2020-08-16 | St. Francois | Missouri | 29187 | 571 | 2 |
435831 | 435831 | 2020-08-15 | St. Francois | Missouri | 29187 | 502 | 2 |
432605 | 432605 | 2020-08-14 | St. Francois | Missouri | 29187 | 502 | 2 |
429378 | 429378 | 2020-08-13 | St. Francois | Missouri | 29187 | 462 | 2 |
426154 | 426154 | 2020-08-12 | St. Francois | Missouri | 29187 | 441 | 2 |
422932 | 422932 | 2020-08-11 | St. Francois | Missouri | 29187 | 421 | 2 |
419710 | 419710 | 2020-08-10 | St. Francois | Missouri | 29187 | 402 | 2 |
416489 | 416489 | 2020-08-09 | St. Francois | Missouri | 29187 | 368 | 2 |
413269 | 413269 | 2020-08-08 | St. Francois | Missouri | 29187 | 355 | 2 |
410049 | 410049 | 2020-08-07 | St. Francois | Missouri | 29187 | 355 | 2 |
406829 | 406829 | 2020-08-06 | St. Francois | Missouri | 29187 | 349 | 2 |
403611 | 403611 | 2020-08-05 | St. Francois | Missouri | 29187 | 337 | 2 |
400394 | 400394 | 2020-08-04 | St. Francois | Missouri | 29187 | 322 | 2 |
397180 | 397180 | 2020-08-03 | St. Francois | Missouri | 29187 | 312 | 2 |
393964 | 393964 | 2020-08-02 | St. Francois | Missouri | 29187 | 299 | 2 |
390747 | 390747 | 2020-08-01 | St. Francois | Missouri | 29187 | 297 | 2 |
387530 | 387530 | 2020-07-31 | St. Francois | Missouri | 29187 | 295 | 2 |
384312 | 384312 | 2020-07-30 | St. Francois | Missouri | 29187 | 281 | 2 |
381096 | 381096 | 2020-07-29 | St. Francois | Missouri | 29187 | 273 | 2 |
377879 | 377879 | 2020-07-28 | St. Francois | Missouri | 29187 | 268 | 2 |
374664 | 374664 | 2020-07-27 | St. Francois | Missouri | 29187 | 259 | 2 |
371452 | 371452 | 2020-07-26 | St. Francois | Missouri | 29187 | 252 | 2 |
368241 | 368241 | 2020-07-25 | St. Francois | Missouri | 29187 | 252 | 2 |
365033 | 365033 | 2020-07-24 | St. Francois | Missouri | 29187 | 252 | 2 |
361826 | 361826 | 2020-07-23 | St. Francois | Missouri | 29187 | 240 | 2 |
358621 | 358621 | 2020-07-22 | St. Francois | Missouri | 29187 | 234 | 2 |
355418 | 355418 | 2020-07-21 | St. Francois | Missouri | 29187 | 226 | 2 |
352216 | 352216 | 2020-07-20 | St. Francois | Missouri | 29187 | 218 | 2 |
349016 | 349016 | 2020-07-19 | St. Francois | Missouri | 29187 | 202 | 2 |
345815 | 345815 | 2020-07-18 | St. Francois | Missouri | 29187 | 202 | 2 |
342615 | 342615 | 2020-07-17 | St. Francois | Missouri | 29187 | 202 | 2 |
339419 | 339419 | 2020-07-16 | St. Francois | Missouri | 29187 | 195 | 2 |
336223 | 336223 | 2020-07-15 | St. Francois | Missouri | 29187 | 194 | 2 |
333030 | 333030 | 2020-07-14 | St. Francois | Missouri | 29187 | 191 | 2 |
329843 | 329843 | 2020-07-13 | St. Francois | Missouri | 29187 | 187 | 2 |
326657 | 326657 | 2020-07-12 | St. Francois | Missouri | 29187 | 174 | 2 |
323474 | 323474 | 2020-07-11 | St. Francois | Missouri | 29187 | 174 | 2 |
320295 | 320295 | 2020-07-10 | St. Francois | Missouri | 29187 | 174 | 2 |
317120 | 317120 | 2020-07-09 | St. Francois | Missouri | 29187 | 168 | 2 |
313946 | 313946 | 2020-07-08 | St. Francois | Missouri | 29187 | 168 | 2 |
310775 | 310775 | 2020-07-07 | St. Francois | Missouri | 29187 | 165 | 2 |
307607 | 307607 | 2020-07-06 | St. Francois | Missouri | 29187 | 156 | 2 |
304440 | 304440 | 2020-07-05 | St. Francois | Missouri | 29187 | 155 | 2 |
301276 | 301276 | 2020-07-04 | St. Francois | Missouri | 29187 | 155 | 2 |
298113 | 298113 | 2020-07-03 | St. Francois | Missouri | 29187 | 155 | 2 |
294955 | 294955 | 2020-07-02 | St. Francois | Missouri | 29187 | 155 | 2 |
291801 | 291801 | 2020-07-01 | St. Francois | Missouri | 29187 | 147 | 2 |
288650 | 288650 | 2020-06-30 | St. Francois | Missouri | 29187 | 145 | 2 |
285500 | 285500 | 2020-06-29 | St. Francois | Missouri | 29187 | 140 | 2 |
282355 | 282355 | 2020-06-28 | St. Francois | Missouri | 29187 | 139 | 2 |
279207 | 279207 | 2020-06-27 | St. Francois | Missouri | 29187 | 138 | 2 |
276059 | 276059 | 2020-06-26 | St. Francois | Missouri | 29187 | 129 | 2 |
272916 | 272916 | 2020-06-25 | St. Francois | Missouri | 29187 | 100 | 2 |
269777 | 269777 | 2020-06-24 | St. Francois | Missouri | 29187 | 97 | 2 |
266644 | 266644 | 2020-06-23 | St. Francois | Missouri | 29187 | 84 | 2 |
263518 | 263518 | 2020-06-22 | St. Francois | Missouri | 29187 | 68 | 2 |
260390 | 260390 | 2020-06-21 | St. Francois | Missouri | 29187 | 66 | 2 |
257264 | 257264 | 2020-06-20 | St. Francois | Missouri | 29187 | 50 | 2 |
254143 | 254143 | 2020-06-19 | St. Francois | Missouri | 29187 | 50 | 2 |
251028 | 251028 | 2020-06-18 | St. Francois | Missouri | 29187 | 49 | 2 |
247915 | 247915 | 2020-06-17 | St. Francois | Missouri | 29187 | 43 | 2 |
244802 | 244802 | 2020-06-16 | St. Francois | Missouri | 29187 | 43 | 2 |
241691 | 241691 | 2020-06-15 | St. Francois | Missouri | 29187 | 42 | 2 |
238581 | 238581 | 2020-06-14 | St. Francois | Missouri | 29187 | 40 | 2 |
235474 | 235474 | 2020-06-13 | St. Francois | Missouri | 29187 | 40 | 2 |
232368 | 232368 | 2020-06-12 | St. Francois | Missouri | 29187 | 40 | 2 |
229264 | 229264 | 2020-06-11 | St. Francois | Missouri | 29187 | 40 | 2 |
226161 | 226161 | 2020-06-10 | St. Francois | Missouri | 29187 | 40 | 2 |
223062 | 223062 | 2020-06-09 | St. Francois | Missouri | 29187 | 41 | 2 |
219967 | 219967 | 2020-06-08 | St. Francois | Missouri | 29187 | 41 | 2 |
216875 | 216875 | 2020-06-07 | St. Francois | Missouri | 29187 | 39 | 2 |
213786 | 213786 | 2020-06-06 | St. Francois | Missouri | 29187 | 39 | 2 |
210702 | 210702 | 2020-06-05 | St. Francois | Missouri | 29187 | 38 | 2 |
207621 | 207621 | 2020-06-04 | St. Francois | Missouri | 29187 | 38 | 2 |
204540 | 204540 | 2020-06-03 | St. Francois | Missouri | 29187 | 36 | 2 |
201463 | 201463 | 2020-06-02 | St. Francois | Missouri | 29187 | 36 | 2 |
198390 | 198390 | 2020-06-01 | St. Francois | Missouri | 29187 | 35 | 2 |
195319 | 195319 | 2020-05-31 | St. Francois | Missouri | 29187 | 35 | 2 |
192249 | 192249 | 2020-05-30 | St. Francois | Missouri | 29187 | 35 | 2 |
189185 | 189185 | 2020-05-29 | St. Francois | Missouri | 29187 | 34 | 2 |
186127 | 186127 | 2020-05-28 | St. Francois | Missouri | 29187 | 33 | 2 |
183071 | 183071 | 2020-05-27 | St. Francois | Missouri | 29187 | 32 | 2 |
180023 | 180023 | 2020-05-26 | St. Francois | Missouri | 29187 | 32 | 2 |
176979 | 176979 | 2020-05-25 | St. Francois | Missouri | 29187 | 31 | 2 |
173936 | 173936 | 2020-05-24 | St. Francois | Missouri | 29187 | 31 | 2 |
170894 | 170894 | 2020-05-23 | St. Francois | Missouri | 29187 | 31 | 2 |
167855 | 167855 | 2020-05-22 | St. Francois | Missouri | 29187 | 31 | 2 |
164819 | 164819 | 2020-05-21 | St. Francois | Missouri | 29187 | 30 | 2 |
161790 | 161790 | 2020-05-20 | St. Francois | Missouri | 29187 | 30 | 2 |
158764 | 158764 | 2020-05-19 | St. Francois | Missouri | 29187 | 30 | 2 |
155746 | 155746 | 2020-05-18 | St. Francois | Missouri | 29187 | 30 | 2 |
152732 | 152732 | 2020-05-17 | St. Francois | Missouri | 29187 | 30 | 2 |
149721 | 149721 | 2020-05-16 | St. Francois | Missouri | 29187 | 30 | 2 |
146715 | 146715 | 2020-05-15 | St. Francois | Missouri | 29187 | 30 | 2 |
143714 | 143714 | 2020-05-14 | St. Francois | Missouri | 29187 | 30 | 2 |
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);