ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where fips = 29103 and state = "Missouri" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
226114 | 226114 | 2020-06-10 | Knox | Missouri | 29103 | 2 | 0 |
229217 | 229217 | 2020-06-11 | Knox | Missouri | 29103 | 2 | 0 |
232321 | 232321 | 2020-06-12 | Knox | Missouri | 29103 | 2 | 0 |
235427 | 235427 | 2020-06-13 | Knox | Missouri | 29103 | 2 | 0 |
238534 | 238534 | 2020-06-14 | Knox | Missouri | 29103 | 2 | 0 |
241644 | 241644 | 2020-06-15 | Knox | Missouri | 29103 | 2 | 0 |
244755 | 244755 | 2020-06-16 | Knox | Missouri | 29103 | 2 | 0 |
247868 | 247868 | 2020-06-17 | Knox | Missouri | 29103 | 2 | 0 |
250981 | 250981 | 2020-06-18 | Knox | Missouri | 29103 | 2 | 0 |
254096 | 254096 | 2020-06-19 | Knox | Missouri | 29103 | 2 | 0 |
257216 | 257216 | 2020-06-20 | Knox | Missouri | 29103 | 2 | 0 |
260342 | 260342 | 2020-06-21 | Knox | Missouri | 29103 | 2 | 0 |
263470 | 263470 | 2020-06-22 | Knox | Missouri | 29103 | 2 | 0 |
266596 | 266596 | 2020-06-23 | Knox | Missouri | 29103 | 2 | 0 |
269729 | 269729 | 2020-06-24 | Knox | Missouri | 29103 | 2 | 0 |
272868 | 272868 | 2020-06-25 | Knox | Missouri | 29103 | 2 | 0 |
276011 | 276011 | 2020-06-26 | Knox | Missouri | 29103 | 2 | 0 |
279159 | 279159 | 2020-06-27 | Knox | Missouri | 29103 | 2 | 0 |
282307 | 282307 | 2020-06-28 | Knox | Missouri | 29103 | 2 | 0 |
285452 | 285452 | 2020-06-29 | Knox | Missouri | 29103 | 2 | 0 |
288602 | 288602 | 2020-06-30 | Knox | Missouri | 29103 | 2 | 0 |
291753 | 291753 | 2020-07-01 | Knox | Missouri | 29103 | 2 | 0 |
294907 | 294907 | 2020-07-02 | Knox | Missouri | 29103 | 2 | 0 |
298065 | 298065 | 2020-07-03 | Knox | Missouri | 29103 | 2 | 0 |
301228 | 301228 | 2020-07-04 | Knox | Missouri | 29103 | 2 | 0 |
304392 | 304392 | 2020-07-05 | Knox | Missouri | 29103 | 2 | 0 |
307559 | 307559 | 2020-07-06 | Knox | Missouri | 29103 | 2 | 0 |
310727 | 310727 | 2020-07-07 | Knox | Missouri | 29103 | 2 | 0 |
313898 | 313898 | 2020-07-08 | Knox | Missouri | 29103 | 2 | 0 |
317072 | 317072 | 2020-07-09 | Knox | Missouri | 29103 | 2 | 0 |
320247 | 320247 | 2020-07-10 | Knox | Missouri | 29103 | 2 | 0 |
323426 | 323426 | 2020-07-11 | Knox | Missouri | 29103 | 2 | 0 |
326609 | 326609 | 2020-07-12 | Knox | Missouri | 29103 | 2 | 0 |
329795 | 329795 | 2020-07-13 | Knox | Missouri | 29103 | 2 | 0 |
332982 | 332982 | 2020-07-14 | Knox | Missouri | 29103 | 2 | 0 |
336175 | 336175 | 2020-07-15 | Knox | Missouri | 29103 | 2 | 0 |
339371 | 339371 | 2020-07-16 | Knox | Missouri | 29103 | 2 | 0 |
342567 | 342567 | 2020-07-17 | Knox | Missouri | 29103 | 2 | 0 |
345767 | 345767 | 2020-07-18 | Knox | Missouri | 29103 | 2 | 0 |
348968 | 348968 | 2020-07-19 | Knox | Missouri | 29103 | 2 | 0 |
352168 | 352168 | 2020-07-20 | Knox | Missouri | 29103 | 3 | 0 |
355370 | 355370 | 2020-07-21 | Knox | Missouri | 29103 | 3 | 0 |
358573 | 358573 | 2020-07-22 | Knox | Missouri | 29103 | 4 | 0 |
361778 | 361778 | 2020-07-23 | Knox | Missouri | 29103 | 4 | 0 |
364985 | 364985 | 2020-07-24 | Knox | Missouri | 29103 | 4 | 0 |
368193 | 368193 | 2020-07-25 | Knox | Missouri | 29103 | 4 | 0 |
371404 | 371404 | 2020-07-26 | Knox | Missouri | 29103 | 4 | 0 |
374616 | 374616 | 2020-07-27 | Knox | Missouri | 29103 | 5 | 0 |
377831 | 377831 | 2020-07-28 | Knox | Missouri | 29103 | 5 | 0 |
381048 | 381048 | 2020-07-29 | Knox | Missouri | 29103 | 6 | 0 |
384264 | 384264 | 2020-07-30 | Knox | Missouri | 29103 | 9 | 0 |
387482 | 387482 | 2020-07-31 | Knox | Missouri | 29103 | 9 | 0 |
390699 | 390699 | 2020-08-01 | Knox | Missouri | 29103 | 11 | 0 |
393916 | 393916 | 2020-08-02 | Knox | Missouri | 29103 | 15 | 0 |
397132 | 397132 | 2020-08-03 | Knox | Missouri | 29103 | 19 | 0 |
400346 | 400346 | 2020-08-04 | Knox | Missouri | 29103 | 19 | 0 |
403563 | 403563 | 2020-08-05 | Knox | Missouri | 29103 | 24 | 0 |
406781 | 406781 | 2020-08-06 | Knox | Missouri | 29103 | 26 | 0 |
410001 | 410001 | 2020-08-07 | Knox | Missouri | 29103 | 27 | 0 |
413221 | 413221 | 2020-08-08 | Knox | Missouri | 29103 | 27 | 0 |
416441 | 416441 | 2020-08-09 | Knox | Missouri | 29103 | 27 | 0 |
419662 | 419662 | 2020-08-10 | Knox | Missouri | 29103 | 27 | 0 |
422884 | 422884 | 2020-08-11 | Knox | Missouri | 29103 | 27 | 0 |
426106 | 426106 | 2020-08-12 | Knox | Missouri | 29103 | 32 | 0 |
429330 | 429330 | 2020-08-13 | Knox | Missouri | 29103 | 33 | 0 |
432557 | 432557 | 2020-08-14 | Knox | Missouri | 29103 | 35 | 0 |
435783 | 435783 | 2020-08-15 | Knox | Missouri | 29103 | 35 | 0 |
439008 | 439008 | 2020-08-16 | Knox | Missouri | 29103 | 36 | 0 |
442235 | 442235 | 2020-08-17 | Knox | Missouri | 29103 | 36 | 0 |
445461 | 445461 | 2020-08-18 | Knox | Missouri | 29103 | 36 | 0 |
448687 | 448687 | 2020-08-19 | Knox | Missouri | 29103 | 36 | 0 |
451915 | 451915 | 2020-08-20 | Knox | Missouri | 29103 | 36 | 0 |
455143 | 455143 | 2020-08-21 | Knox | Missouri | 29103 | 36 | 0 |
458371 | 458371 | 2020-08-22 | Knox | Missouri | 29103 | 38 | 0 |
461598 | 461598 | 2020-08-23 | Knox | Missouri | 29103 | 38 | 0 |
464829 | 464829 | 2020-08-24 | Knox | Missouri | 29103 | 38 | 0 |
468058 | 468058 | 2020-08-25 | Knox | Missouri | 29103 | 38 | 0 |
471288 | 471288 | 2020-08-26 | Knox | Missouri | 29103 | 38 | 0 |
474520 | 474520 | 2020-08-27 | Knox | Missouri | 29103 | 38 | 0 |
477753 | 477753 | 2020-08-28 | Knox | Missouri | 29103 | 38 | 0 |
480985 | 480985 | 2020-08-29 | Knox | Missouri | 29103 | 38 | 0 |
484220 | 484220 | 2020-08-30 | Knox | Missouri | 29103 | 38 | 0 |
487454 | 487454 | 2020-08-31 | Knox | Missouri | 29103 | 38 | 0 |
490687 | 490687 | 2020-09-01 | Knox | Missouri | 29103 | 38 | 0 |
493921 | 493921 | 2020-09-02 | Knox | Missouri | 29103 | 39 | 0 |
497154 | 497154 | 2020-09-03 | Knox | Missouri | 29103 | 39 | 0 |
500388 | 500388 | 2020-09-04 | Knox | Missouri | 29103 | 40 | 0 |
503622 | 503622 | 2020-09-05 | Knox | Missouri | 29103 | 42 | 0 |
506855 | 506855 | 2020-09-06 | Knox | Missouri | 29103 | 42 | 0 |
510088 | 510088 | 2020-09-07 | Knox | Missouri | 29103 | 43 | 0 |
513320 | 513320 | 2020-09-08 | Knox | Missouri | 29103 | 44 | 0 |
516554 | 516554 | 2020-09-09 | Knox | Missouri | 29103 | 45 | 0 |
519789 | 519789 | 2020-09-10 | Knox | Missouri | 29103 | 45 | 0 |
523026 | 523026 | 2020-09-11 | Knox | Missouri | 29103 | 45 | 0 |
526262 | 526262 | 2020-09-12 | Knox | Missouri | 29103 | 45 | 0 |
529498 | 529498 | 2020-09-13 | Knox | Missouri | 29103 | 45 | 0 |
532734 | 532734 | 2020-09-14 | Knox | Missouri | 29103 | 46 | 0 |
535969 | 535969 | 2020-09-15 | Knox | Missouri | 29103 | 46 | 0 |
539206 | 539206 | 2020-09-16 | Knox | Missouri | 29103 | 46 | 1 |
542442 | 542442 | 2020-09-17 | Knox | Missouri | 29103 | 46 | 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);