ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 29199 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536011 | 536011 | 2020-09-15 | Scotland | Missouri | 29199 | 24 | 1 |
532776 | 532776 | 2020-09-14 | Scotland | Missouri | 29199 | 23 | 1 |
529540 | 529540 | 2020-09-13 | Scotland | Missouri | 29199 | 23 | 1 |
526304 | 526304 | 2020-09-12 | Scotland | Missouri | 29199 | 23 | 1 |
523068 | 523068 | 2020-09-11 | Scotland | Missouri | 29199 | 22 | 1 |
519831 | 519831 | 2020-09-10 | Scotland | Missouri | 29199 | 22 | 1 |
516596 | 516596 | 2020-09-09 | Scotland | Missouri | 29199 | 22 | 1 |
513362 | 513362 | 2020-09-08 | Scotland | Missouri | 29199 | 22 | 1 |
510130 | 510130 | 2020-09-07 | Scotland | Missouri | 29199 | 22 | 1 |
506897 | 506897 | 2020-09-06 | Scotland | Missouri | 29199 | 21 | 1 |
503664 | 503664 | 2020-09-05 | Scotland | Missouri | 29199 | 21 | 1 |
500430 | 500430 | 2020-09-04 | Scotland | Missouri | 29199 | 21 | 1 |
497196 | 497196 | 2020-09-03 | Scotland | Missouri | 29199 | 20 | 1 |
493963 | 493963 | 2020-09-02 | Scotland | Missouri | 29199 | 20 | 1 |
490729 | 490729 | 2020-09-01 | Scotland | Missouri | 29199 | 18 | 1 |
487496 | 487496 | 2020-08-31 | Scotland | Missouri | 29199 | 18 | 1 |
484262 | 484262 | 2020-08-30 | Scotland | Missouri | 29199 | 18 | 1 |
481027 | 481027 | 2020-08-29 | Scotland | Missouri | 29199 | 18 | 1 |
477795 | 477795 | 2020-08-28 | Scotland | Missouri | 29199 | 18 | 1 |
474562 | 474562 | 2020-08-27 | Scotland | Missouri | 29199 | 18 | 1 |
471330 | 471330 | 2020-08-26 | Scotland | Missouri | 29199 | 18 | 1 |
468100 | 468100 | 2020-08-25 | Scotland | Missouri | 29199 | 18 | 1 |
464871 | 464871 | 2020-08-24 | Scotland | Missouri | 29199 | 18 | 1 |
461640 | 461640 | 2020-08-23 | Scotland | Missouri | 29199 | 18 | 1 |
458413 | 458413 | 2020-08-22 | Scotland | Missouri | 29199 | 18 | 1 |
455185 | 455185 | 2020-08-21 | Scotland | Missouri | 29199 | 20 | 1 |
451957 | 451957 | 2020-08-20 | Scotland | Missouri | 29199 | 20 | 1 |
448729 | 448729 | 2020-08-19 | Scotland | Missouri | 29199 | 20 | 1 |
445503 | 445503 | 2020-08-18 | Scotland | Missouri | 29199 | 19 | 1 |
442277 | 442277 | 2020-08-17 | Scotland | Missouri | 29199 | 19 | 1 |
439050 | 439050 | 2020-08-16 | Scotland | Missouri | 29199 | 19 | 1 |
435825 | 435825 | 2020-08-15 | Scotland | Missouri | 29199 | 18 | 1 |
432599 | 432599 | 2020-08-14 | Scotland | Missouri | 29199 | 16 | 1 |
429372 | 429372 | 2020-08-13 | Scotland | Missouri | 29199 | 16 | 1 |
426148 | 426148 | 2020-08-12 | Scotland | Missouri | 29199 | 15 | 1 |
422926 | 422926 | 2020-08-11 | Scotland | Missouri | 29199 | 15 | 1 |
419704 | 419704 | 2020-08-10 | Scotland | Missouri | 29199 | 16 | 1 |
416483 | 416483 | 2020-08-09 | Scotland | Missouri | 29199 | 15 | 1 |
413263 | 413263 | 2020-08-08 | Scotland | Missouri | 29199 | 14 | 1 |
410043 | 410043 | 2020-08-07 | Scotland | Missouri | 29199 | 14 | 1 |
406823 | 406823 | 2020-08-06 | Scotland | Missouri | 29199 | 14 | 1 |
403605 | 403605 | 2020-08-05 | Scotland | Missouri | 29199 | 14 | 1 |
400388 | 400388 | 2020-08-04 | Scotland | Missouri | 29199 | 12 | 1 |
397174 | 397174 | 2020-08-03 | Scotland | Missouri | 29199 | 12 | 1 |
393958 | 393958 | 2020-08-02 | Scotland | Missouri | 29199 | 12 | 1 |
390741 | 390741 | 2020-08-01 | Scotland | Missouri | 29199 | 12 | 1 |
387524 | 387524 | 2020-07-31 | Scotland | Missouri | 29199 | 12 | 1 |
384306 | 384306 | 2020-07-30 | Scotland | Missouri | 29199 | 12 | 1 |
381090 | 381090 | 2020-07-29 | Scotland | Missouri | 29199 | 12 | 1 |
377873 | 377873 | 2020-07-28 | Scotland | Missouri | 29199 | 11 | 1 |
374658 | 374658 | 2020-07-27 | Scotland | Missouri | 29199 | 11 | 1 |
371446 | 371446 | 2020-07-26 | Scotland | Missouri | 29199 | 11 | 1 |
368235 | 368235 | 2020-07-25 | Scotland | Missouri | 29199 | 11 | 1 |
365027 | 365027 | 2020-07-24 | Scotland | Missouri | 29199 | 11 | 1 |
361820 | 361820 | 2020-07-23 | Scotland | Missouri | 29199 | 11 | 1 |
358615 | 358615 | 2020-07-22 | Scotland | Missouri | 29199 | 11 | 1 |
355412 | 355412 | 2020-07-21 | Scotland | Missouri | 29199 | 11 | 1 |
352210 | 352210 | 2020-07-20 | Scotland | Missouri | 29199 | 11 | 1 |
349010 | 349010 | 2020-07-19 | Scotland | Missouri | 29199 | 11 | 1 |
345809 | 345809 | 2020-07-18 | Scotland | Missouri | 29199 | 11 | 1 |
342609 | 342609 | 2020-07-17 | Scotland | Missouri | 29199 | 11 | 1 |
339413 | 339413 | 2020-07-16 | Scotland | Missouri | 29199 | 11 | 1 |
336217 | 336217 | 2020-07-15 | Scotland | Missouri | 29199 | 11 | 1 |
333024 | 333024 | 2020-07-14 | Scotland | Missouri | 29199 | 11 | 1 |
329837 | 329837 | 2020-07-13 | Scotland | Missouri | 29199 | 11 | 1 |
326651 | 326651 | 2020-07-12 | Scotland | Missouri | 29199 | 11 | 1 |
323468 | 323468 | 2020-07-11 | Scotland | Missouri | 29199 | 11 | 1 |
320289 | 320289 | 2020-07-10 | Scotland | Missouri | 29199 | 11 | 1 |
317114 | 317114 | 2020-07-09 | Scotland | Missouri | 29199 | 11 | 1 |
313940 | 313940 | 2020-07-08 | Scotland | Missouri | 29199 | 11 | 1 |
310769 | 310769 | 2020-07-07 | Scotland | Missouri | 29199 | 11 | 1 |
307601 | 307601 | 2020-07-06 | Scotland | Missouri | 29199 | 11 | 1 |
304434 | 304434 | 2020-07-05 | Scotland | Missouri | 29199 | 11 | 1 |
301270 | 301270 | 2020-07-04 | Scotland | Missouri | 29199 | 11 | 1 |
298107 | 298107 | 2020-07-03 | Scotland | Missouri | 29199 | 11 | 1 |
294949 | 294949 | 2020-07-02 | Scotland | Missouri | 29199 | 11 | 1 |
291795 | 291795 | 2020-07-01 | Scotland | Missouri | 29199 | 11 | 1 |
288644 | 288644 | 2020-06-30 | Scotland | Missouri | 29199 | 11 | 1 |
285494 | 285494 | 2020-06-29 | Scotland | Missouri | 29199 | 11 | 1 |
282349 | 282349 | 2020-06-28 | Scotland | Missouri | 29199 | 11 | 1 |
279201 | 279201 | 2020-06-27 | Scotland | Missouri | 29199 | 11 | 1 |
276053 | 276053 | 2020-06-26 | Scotland | Missouri | 29199 | 10 | 1 |
272910 | 272910 | 2020-06-25 | Scotland | Missouri | 29199 | 8 | 1 |
269771 | 269771 | 2020-06-24 | Scotland | Missouri | 29199 | 8 | 1 |
266638 | 266638 | 2020-06-23 | Scotland | Missouri | 29199 | 8 | 1 |
263512 | 263512 | 2020-06-22 | Scotland | Missouri | 29199 | 8 | 1 |
260384 | 260384 | 2020-06-21 | Scotland | Missouri | 29199 | 8 | 1 |
257258 | 257258 | 2020-06-20 | Scotland | Missouri | 29199 | 8 | 1 |
254137 | 254137 | 2020-06-19 | Scotland | Missouri | 29199 | 8 | 1 |
251022 | 251022 | 2020-06-18 | Scotland | Missouri | 29199 | 8 | 1 |
247909 | 247909 | 2020-06-17 | Scotland | Missouri | 29199 | 8 | 1 |
244796 | 244796 | 2020-06-16 | Scotland | Missouri | 29199 | 8 | 1 |
241685 | 241685 | 2020-06-15 | Scotland | Missouri | 29199 | 8 | 1 |
238575 | 238575 | 2020-06-14 | Scotland | Missouri | 29199 | 8 | 1 |
235468 | 235468 | 2020-06-13 | Scotland | Missouri | 29199 | 8 | 1 |
232362 | 232362 | 2020-06-12 | Scotland | Missouri | 29199 | 8 | 1 |
229258 | 229258 | 2020-06-11 | Scotland | Missouri | 29199 | 8 | 1 |
226155 | 226155 | 2020-06-10 | Scotland | Missouri | 29199 | 8 | 1 |
223056 | 223056 | 2020-06-09 | Scotland | Missouri | 29199 | 9 | 0 |
219961 | 219961 | 2020-06-08 | Scotland | Missouri | 29199 | 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);