ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where deaths = 0, fips = 29161 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 |
---|---|---|---|---|---|---|---|
500417 | 500417 | 2020-09-04 | Phelps | Missouri | 29161 | 244 | 0 |
497183 | 497183 | 2020-09-03 | Phelps | Missouri | 29161 | 240 | 0 |
493950 | 493950 | 2020-09-02 | Phelps | Missouri | 29161 | 224 | 0 |
490716 | 490716 | 2020-09-01 | Phelps | Missouri | 29161 | 212 | 0 |
487483 | 487483 | 2020-08-31 | Phelps | Missouri | 29161 | 210 | 0 |
484249 | 484249 | 2020-08-30 | Phelps | Missouri | 29161 | 208 | 0 |
481014 | 481014 | 2020-08-29 | Phelps | Missouri | 29161 | 199 | 0 |
477782 | 477782 | 2020-08-28 | Phelps | Missouri | 29161 | 190 | 0 |
474549 | 474549 | 2020-08-27 | Phelps | Missouri | 29161 | 180 | 0 |
471317 | 471317 | 2020-08-26 | Phelps | Missouri | 29161 | 175 | 0 |
468087 | 468087 | 2020-08-25 | Phelps | Missouri | 29161 | 164 | 0 |
464858 | 464858 | 2020-08-24 | Phelps | Missouri | 29161 | 152 | 0 |
461627 | 461627 | 2020-08-23 | Phelps | Missouri | 29161 | 151 | 0 |
458400 | 458400 | 2020-08-22 | Phelps | Missouri | 29161 | 145 | 0 |
455172 | 455172 | 2020-08-21 | Phelps | Missouri | 29161 | 137 | 0 |
451944 | 451944 | 2020-08-20 | Phelps | Missouri | 29161 | 132 | 0 |
448716 | 448716 | 2020-08-19 | Phelps | Missouri | 29161 | 129 | 0 |
445490 | 445490 | 2020-08-18 | Phelps | Missouri | 29161 | 129 | 0 |
442264 | 442264 | 2020-08-17 | Phelps | Missouri | 29161 | 128 | 0 |
439037 | 439037 | 2020-08-16 | Phelps | Missouri | 29161 | 123 | 0 |
435812 | 435812 | 2020-08-15 | Phelps | Missouri | 29161 | 115 | 0 |
432586 | 432586 | 2020-08-14 | Phelps | Missouri | 29161 | 114 | 0 |
429359 | 429359 | 2020-08-13 | Phelps | Missouri | 29161 | 104 | 0 |
426135 | 426135 | 2020-08-12 | Phelps | Missouri | 29161 | 100 | 0 |
422913 | 422913 | 2020-08-11 | Phelps | Missouri | 29161 | 90 | 0 |
419691 | 419691 | 2020-08-10 | Phelps | Missouri | 29161 | 89 | 0 |
416470 | 416470 | 2020-08-09 | Phelps | Missouri | 29161 | 88 | 0 |
413250 | 413250 | 2020-08-08 | Phelps | Missouri | 29161 | 81 | 0 |
410030 | 410030 | 2020-08-07 | Phelps | Missouri | 29161 | 81 | 0 |
406810 | 406810 | 2020-08-06 | Phelps | Missouri | 29161 | 84 | 0 |
403592 | 403592 | 2020-08-05 | Phelps | Missouri | 29161 | 79 | 0 |
400375 | 400375 | 2020-08-04 | Phelps | Missouri | 29161 | 76 | 0 |
397161 | 397161 | 2020-08-03 | Phelps | Missouri | 29161 | 74 | 0 |
393945 | 393945 | 2020-08-02 | Phelps | Missouri | 29161 | 75 | 0 |
390728 | 390728 | 2020-08-01 | Phelps | Missouri | 29161 | 75 | 0 |
387511 | 387511 | 2020-07-31 | Phelps | Missouri | 29161 | 72 | 0 |
384293 | 384293 | 2020-07-30 | Phelps | Missouri | 29161 | 69 | 0 |
381077 | 381077 | 2020-07-29 | Phelps | Missouri | 29161 | 66 | 0 |
377860 | 377860 | 2020-07-28 | Phelps | Missouri | 29161 | 65 | 0 |
374645 | 374645 | 2020-07-27 | Phelps | Missouri | 29161 | 59 | 0 |
371433 | 371433 | 2020-07-26 | Phelps | Missouri | 29161 | 59 | 0 |
368222 | 368222 | 2020-07-25 | Phelps | Missouri | 29161 | 59 | 0 |
365014 | 365014 | 2020-07-24 | Phelps | Missouri | 29161 | 59 | 0 |
361807 | 361807 | 2020-07-23 | Phelps | Missouri | 29161 | 61 | 0 |
358602 | 358602 | 2020-07-22 | Phelps | Missouri | 29161 | 60 | 0 |
355399 | 355399 | 2020-07-21 | Phelps | Missouri | 29161 | 59 | 0 |
352197 | 352197 | 2020-07-20 | Phelps | Missouri | 29161 | 57 | 0 |
348997 | 348997 | 2020-07-19 | Phelps | Missouri | 29161 | 57 | 0 |
345796 | 345796 | 2020-07-18 | Phelps | Missouri | 29161 | 53 | 0 |
342596 | 342596 | 2020-07-17 | Phelps | Missouri | 29161 | 53 | 0 |
339400 | 339400 | 2020-07-16 | Phelps | Missouri | 29161 | 53 | 0 |
336204 | 336204 | 2020-07-15 | Phelps | Missouri | 29161 | 52 | 0 |
333011 | 333011 | 2020-07-14 | Phelps | Missouri | 29161 | 52 | 0 |
329824 | 329824 | 2020-07-13 | Phelps | Missouri | 29161 | 53 | 0 |
326638 | 326638 | 2020-07-12 | Phelps | Missouri | 29161 | 53 | 0 |
323455 | 323455 | 2020-07-11 | Phelps | Missouri | 29161 | 53 | 0 |
320276 | 320276 | 2020-07-10 | Phelps | Missouri | 29161 | 53 | 0 |
317101 | 317101 | 2020-07-09 | Phelps | Missouri | 29161 | 53 | 0 |
313927 | 313927 | 2020-07-08 | Phelps | Missouri | 29161 | 51 | 0 |
310756 | 310756 | 2020-07-07 | Phelps | Missouri | 29161 | 48 | 0 |
307588 | 307588 | 2020-07-06 | Phelps | Missouri | 29161 | 49 | 0 |
304421 | 304421 | 2020-07-05 | Phelps | Missouri | 29161 | 46 | 0 |
301257 | 301257 | 2020-07-04 | Phelps | Missouri | 29161 | 45 | 0 |
298094 | 298094 | 2020-07-03 | Phelps | Missouri | 29161 | 45 | 0 |
294936 | 294936 | 2020-07-02 | Phelps | Missouri | 29161 | 44 | 0 |
291782 | 291782 | 2020-07-01 | Phelps | Missouri | 29161 | 40 | 0 |
288631 | 288631 | 2020-06-30 | Phelps | Missouri | 29161 | 35 | 0 |
285481 | 285481 | 2020-06-29 | Phelps | Missouri | 29161 | 25 | 0 |
282336 | 282336 | 2020-06-28 | Phelps | Missouri | 29161 | 23 | 0 |
279188 | 279188 | 2020-06-27 | Phelps | Missouri | 29161 | 21 | 0 |
276040 | 276040 | 2020-06-26 | Phelps | Missouri | 29161 | 22 | 0 |
272897 | 272897 | 2020-06-25 | Phelps | Missouri | 29161 | 15 | 0 |
269758 | 269758 | 2020-06-24 | Phelps | Missouri | 29161 | 12 | 0 |
266625 | 266625 | 2020-06-23 | Phelps | Missouri | 29161 | 8 | 0 |
263499 | 263499 | 2020-06-22 | Phelps | Missouri | 29161 | 7 | 0 |
260371 | 260371 | 2020-06-21 | Phelps | Missouri | 29161 | 7 | 0 |
257245 | 257245 | 2020-06-20 | Phelps | Missouri | 29161 | 7 | 0 |
254124 | 254124 | 2020-06-19 | Phelps | Missouri | 29161 | 6 | 0 |
251009 | 251009 | 2020-06-18 | Phelps | Missouri | 29161 | 7 | 0 |
247896 | 247896 | 2020-06-17 | Phelps | Missouri | 29161 | 7 | 0 |
244783 | 244783 | 2020-06-16 | Phelps | Missouri | 29161 | 6 | 0 |
241672 | 241672 | 2020-06-15 | Phelps | Missouri | 29161 | 6 | 0 |
238562 | 238562 | 2020-06-14 | Phelps | Missouri | 29161 | 6 | 0 |
235455 | 235455 | 2020-06-13 | Phelps | Missouri | 29161 | 6 | 0 |
232349 | 232349 | 2020-06-12 | Phelps | Missouri | 29161 | 6 | 0 |
229245 | 229245 | 2020-06-11 | Phelps | Missouri | 29161 | 6 | 0 |
226142 | 226142 | 2020-06-10 | Phelps | Missouri | 29161 | 6 | 0 |
223043 | 223043 | 2020-06-09 | Phelps | Missouri | 29161 | 5 | 0 |
219948 | 219948 | 2020-06-08 | Phelps | Missouri | 29161 | 5 | 0 |
216856 | 216856 | 2020-06-07 | Phelps | Missouri | 29161 | 5 | 0 |
213768 | 213768 | 2020-06-06 | Phelps | Missouri | 29161 | 5 | 0 |
210684 | 210684 | 2020-06-05 | Phelps | Missouri | 29161 | 5 | 0 |
207603 | 207603 | 2020-06-04 | Phelps | Missouri | 29161 | 5 | 0 |
204522 | 204522 | 2020-06-03 | Phelps | Missouri | 29161 | 5 | 0 |
201445 | 201445 | 2020-06-02 | Phelps | Missouri | 29161 | 4 | 0 |
198372 | 198372 | 2020-06-01 | Phelps | Missouri | 29161 | 4 | 0 |
195301 | 195301 | 2020-05-31 | Phelps | Missouri | 29161 | 4 | 0 |
192231 | 192231 | 2020-05-30 | Phelps | Missouri | 29161 | 4 | 0 |
189167 | 189167 | 2020-05-29 | Phelps | Missouri | 29161 | 4 | 0 |
186109 | 186109 | 2020-05-28 | Phelps | Missouri | 29161 | 4 | 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);