ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Johnson" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535966 | 535966 | 2020-09-15 | Johnson | Missouri | 29101 | 905 | 4 |
532731 | 532731 | 2020-09-14 | Johnson | Missouri | 29101 | 888 | 4 |
529495 | 529495 | 2020-09-13 | Johnson | Missouri | 29101 | 853 | 4 |
526259 | 526259 | 2020-09-12 | Johnson | Missouri | 29101 | 800 | 4 |
523023 | 523023 | 2020-09-11 | Johnson | Missouri | 29101 | 777 | 4 |
519786 | 519786 | 2020-09-10 | Johnson | Missouri | 29101 | 768 | 4 |
516551 | 516551 | 2020-09-09 | Johnson | Missouri | 29101 | 767 | 4 |
513317 | 513317 | 2020-09-08 | Johnson | Missouri | 29101 | 733 | 4 |
510085 | 510085 | 2020-09-07 | Johnson | Missouri | 29101 | 717 | 4 |
506852 | 506852 | 2020-09-06 | Johnson | Missouri | 29101 | 699 | 4 |
503619 | 503619 | 2020-09-05 | Johnson | Missouri | 29101 | 643 | 4 |
500385 | 500385 | 2020-09-04 | Johnson | Missouri | 29101 | 622 | 4 |
497151 | 497151 | 2020-09-03 | Johnson | Missouri | 29101 | 609 | 3 |
493918 | 493918 | 2020-09-02 | Johnson | Missouri | 29101 | 599 | 3 |
490684 | 490684 | 2020-09-01 | Johnson | Missouri | 29101 | 597 | 3 |
487451 | 487451 | 2020-08-31 | Johnson | Missouri | 29101 | 595 | 3 |
484217 | 484217 | 2020-08-30 | Johnson | Missouri | 29101 | 592 | 3 |
480982 | 480982 | 2020-08-29 | Johnson | Missouri | 29101 | 587 | 3 |
477750 | 477750 | 2020-08-28 | Johnson | Missouri | 29101 | 582 | 3 |
474517 | 474517 | 2020-08-27 | Johnson | Missouri | 29101 | 568 | 3 |
471285 | 471285 | 2020-08-26 | Johnson | Missouri | 29101 | 560 | 3 |
468055 | 468055 | 2020-08-25 | Johnson | Missouri | 29101 | 551 | 3 |
464826 | 464826 | 2020-08-24 | Johnson | Missouri | 29101 | 551 | 3 |
461595 | 461595 | 2020-08-23 | Johnson | Missouri | 29101 | 543 | 3 |
458368 | 458368 | 2020-08-22 | Johnson | Missouri | 29101 | 542 | 3 |
455140 | 455140 | 2020-08-21 | Johnson | Missouri | 29101 | 537 | 3 |
451912 | 451912 | 2020-08-20 | Johnson | Missouri | 29101 | 527 | 3 |
448684 | 448684 | 2020-08-19 | Johnson | Missouri | 29101 | 523 | 3 |
445458 | 445458 | 2020-08-18 | Johnson | Missouri | 29101 | 520 | 3 |
442232 | 442232 | 2020-08-17 | Johnson | Missouri | 29101 | 517 | 3 |
439005 | 439005 | 2020-08-16 | Johnson | Missouri | 29101 | 513 | 3 |
435780 | 435780 | 2020-08-15 | Johnson | Missouri | 29101 | 507 | 3 |
432554 | 432554 | 2020-08-14 | Johnson | Missouri | 29101 | 504 | 3 |
429327 | 429327 | 2020-08-13 | Johnson | Missouri | 29101 | 501 | 3 |
426103 | 426103 | 2020-08-12 | Johnson | Missouri | 29101 | 499 | 3 |
422881 | 422881 | 2020-08-11 | Johnson | Missouri | 29101 | 494 | 2 |
419659 | 419659 | 2020-08-10 | Johnson | Missouri | 29101 | 489 | 2 |
416438 | 416438 | 2020-08-09 | Johnson | Missouri | 29101 | 487 | 2 |
413218 | 413218 | 2020-08-08 | Johnson | Missouri | 29101 | 486 | 2 |
409998 | 409998 | 2020-08-07 | Johnson | Missouri | 29101 | 486 | 2 |
406778 | 406778 | 2020-08-06 | Johnson | Missouri | 29101 | 476 | 2 |
403560 | 403560 | 2020-08-05 | Johnson | Missouri | 29101 | 474 | 2 |
400343 | 400343 | 2020-08-04 | Johnson | Missouri | 29101 | 473 | 2 |
397129 | 397129 | 2020-08-03 | Johnson | Missouri | 29101 | 473 | 2 |
393913 | 393913 | 2020-08-02 | Johnson | Missouri | 29101 | 464 | 2 |
390696 | 390696 | 2020-08-01 | Johnson | Missouri | 29101 | 463 | 2 |
387479 | 387479 | 2020-07-31 | Johnson | Missouri | 29101 | 454 | 2 |
384261 | 384261 | 2020-07-30 | Johnson | Missouri | 29101 | 445 | 2 |
381045 | 381045 | 2020-07-29 | Johnson | Missouri | 29101 | 437 | 2 |
377828 | 377828 | 2020-07-28 | Johnson | Missouri | 29101 | 427 | 2 |
374613 | 374613 | 2020-07-27 | Johnson | Missouri | 29101 | 417 | 2 |
371401 | 371401 | 2020-07-26 | Johnson | Missouri | 29101 | 417 | 2 |
368190 | 368190 | 2020-07-25 | Johnson | Missouri | 29101 | 416 | 2 |
364982 | 364982 | 2020-07-24 | Johnson | Missouri | 29101 | 411 | 2 |
361775 | 361775 | 2020-07-23 | Johnson | Missouri | 29101 | 397 | 2 |
358570 | 358570 | 2020-07-22 | Johnson | Missouri | 29101 | 389 | 2 |
355367 | 355367 | 2020-07-21 | Johnson | Missouri | 29101 | 381 | 2 |
352165 | 352165 | 2020-07-20 | Johnson | Missouri | 29101 | 372 | 2 |
348965 | 348965 | 2020-07-19 | Johnson | Missouri | 29101 | 354 | 2 |
345764 | 345764 | 2020-07-18 | Johnson | Missouri | 29101 | 350 | 2 |
342564 | 342564 | 2020-07-17 | Johnson | Missouri | 29101 | 322 | 2 |
339368 | 339368 | 2020-07-16 | Johnson | Missouri | 29101 | 309 | 2 |
336172 | 336172 | 2020-07-15 | Johnson | Missouri | 29101 | 309 | 2 |
332979 | 332979 | 2020-07-14 | Johnson | Missouri | 29101 | 309 | 2 |
329792 | 329792 | 2020-07-13 | Johnson | Missouri | 29101 | 309 | 2 |
326606 | 326606 | 2020-07-12 | Johnson | Missouri | 29101 | 246 | 2 |
323423 | 323423 | 2020-07-11 | Johnson | Missouri | 29101 | 238 | 2 |
320244 | 320244 | 2020-07-10 | Johnson | Missouri | 29101 | 238 | 1 |
317069 | 317069 | 2020-07-09 | Johnson | Missouri | 29101 | 215 | 1 |
313895 | 313895 | 2020-07-08 | Johnson | Missouri | 29101 | 215 | 1 |
310724 | 310724 | 2020-07-07 | Johnson | Missouri | 29101 | 197 | 0 |
307556 | 307556 | 2020-07-06 | Johnson | Missouri | 29101 | 185 | 0 |
304389 | 304389 | 2020-07-05 | Johnson | Missouri | 29101 | 162 | 0 |
301225 | 301225 | 2020-07-04 | Johnson | Missouri | 29101 | 161 | 0 |
298062 | 298062 | 2020-07-03 | Johnson | Missouri | 29101 | 151 | 0 |
294904 | 294904 | 2020-07-02 | Johnson | Missouri | 29101 | 141 | 0 |
291750 | 291750 | 2020-07-01 | Johnson | Missouri | 29101 | 124 | 0 |
288599 | 288599 | 2020-06-30 | Johnson | Missouri | 29101 | 124 | 0 |
285449 | 285449 | 2020-06-29 | Johnson | Missouri | 29101 | 120 | 0 |
282304 | 282304 | 2020-06-28 | Johnson | Missouri | 29101 | 113 | 0 |
279156 | 279156 | 2020-06-27 | Johnson | Missouri | 29101 | 112 | 0 |
276008 | 276008 | 2020-06-26 | Johnson | Missouri | 29101 | 101 | 0 |
272865 | 272865 | 2020-06-25 | Johnson | Missouri | 29101 | 100 | 0 |
269727 | 269727 | 2020-06-24 | Johnson | Missouri | 29101 | 91 | 0 |
266594 | 266594 | 2020-06-23 | Johnson | Missouri | 29101 | 91 | 0 |
263468 | 263468 | 2020-06-22 | Johnson | Missouri | 29101 | 89 | 0 |
260340 | 260340 | 2020-06-21 | Johnson | Missouri | 29101 | 89 | 0 |
257214 | 257214 | 2020-06-20 | Johnson | Missouri | 29101 | 89 | 0 |
254094 | 254094 | 2020-06-19 | Johnson | Missouri | 29101 | 90 | 0 |
250979 | 250979 | 2020-06-18 | Johnson | Missouri | 29101 | 87 | 0 |
247866 | 247866 | 2020-06-17 | Johnson | Missouri | 29101 | 84 | 0 |
244753 | 244753 | 2020-06-16 | Johnson | Missouri | 29101 | 81 | 0 |
241642 | 241642 | 2020-06-15 | Johnson | Missouri | 29101 | 80 | 0 |
238532 | 238532 | 2020-06-14 | Johnson | Missouri | 29101 | 80 | 0 |
235425 | 235425 | 2020-06-13 | Johnson | Missouri | 29101 | 80 | 0 |
232319 | 232319 | 2020-06-12 | Johnson | Missouri | 29101 | 79 | 0 |
229215 | 229215 | 2020-06-11 | Johnson | Missouri | 29101 | 79 | 0 |
226112 | 226112 | 2020-06-10 | Johnson | Missouri | 29101 | 78 | 0 |
223014 | 223014 | 2020-06-09 | Johnson | Missouri | 29101 | 78 | 0 |
219919 | 219919 | 2020-06-08 | Johnson | Missouri | 29101 | 78 | 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);