ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Warren" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636492 | 636492 | 2020-10-16 | Warren | Missouri | 29219 | 643 | 1 |
633246 | 633246 | 2020-10-15 | Warren | Missouri | 29219 | 629 | 1 |
630001 | 630001 | 2020-10-14 | Warren | Missouri | 29219 | 623 | 2 |
626757 | 626757 | 2020-10-13 | Warren | Missouri | 29219 | 610 | 1 |
623515 | 623515 | 2020-10-12 | Warren | Missouri | 29219 | 607 | 1 |
620272 | 620272 | 2020-10-11 | Warren | Missouri | 29219 | 604 | 1 |
617030 | 617030 | 2020-10-10 | Warren | Missouri | 29219 | 597 | 1 |
613789 | 613789 | 2020-10-09 | Warren | Missouri | 29219 | 584 | 1 |
610547 | 610547 | 2020-10-08 | Warren | Missouri | 29219 | 566 | 1 |
607305 | 607305 | 2020-10-07 | Warren | Missouri | 29219 | 558 | 1 |
604062 | 604062 | 2020-10-06 | Warren | Missouri | 29219 | 556 | 1 |
600820 | 600820 | 2020-10-05 | Warren | Missouri | 29219 | 548 | 1 |
597577 | 597577 | 2020-10-04 | Warren | Missouri | 29219 | 543 | 1 |
594336 | 594336 | 2020-10-03 | Warren | Missouri | 29219 | 543 | 1 |
591095 | 591095 | 2020-10-02 | Warren | Missouri | 29219 | 537 | 1 |
587854 | 587854 | 2020-10-01 | Warren | Missouri | 29219 | 532 | 1 |
584614 | 584614 | 2020-09-30 | Warren | Missouri | 29219 | 529 | 1 |
581373 | 581373 | 2020-09-29 | Warren | Missouri | 29219 | 525 | 1 |
578132 | 578132 | 2020-09-28 | Warren | Missouri | 29219 | 515 | 1 |
574891 | 574891 | 2020-09-27 | Warren | Missouri | 29219 | 504 | 1 |
571648 | 571648 | 2020-09-26 | Warren | Missouri | 29219 | 504 | 1 |
568406 | 568406 | 2020-09-25 | Warren | Missouri | 29219 | 494 | 1 |
565166 | 565166 | 2020-09-24 | Warren | Missouri | 29219 | 489 | 1 |
561926 | 561926 | 2020-09-23 | Warren | Missouri | 29219 | 485 | 0 |
558689 | 558689 | 2020-09-22 | Warren | Missouri | 29219 | 474 | 0 |
555452 | 555452 | 2020-09-21 | Warren | Missouri | 29219 | 473 | 0 |
552214 | 552214 | 2020-09-20 | Warren | Missouri | 29219 | 469 | 0 |
548975 | 548975 | 2020-09-19 | Warren | Missouri | 29219 | 461 | 0 |
545737 | 545737 | 2020-09-18 | Warren | Missouri | 29219 | 456 | 0 |
542500 | 542500 | 2020-09-17 | Warren | Missouri | 29219 | 451 | 0 |
539264 | 539264 | 2020-09-16 | Warren | Missouri | 29219 | 445 | 0 |
536027 | 536027 | 2020-09-15 | Warren | Missouri | 29219 | 438 | 0 |
532792 | 532792 | 2020-09-14 | Warren | Missouri | 29219 | 430 | 0 |
529556 | 529556 | 2020-09-13 | Warren | Missouri | 29219 | 419 | 0 |
526320 | 526320 | 2020-09-12 | Warren | Missouri | 29219 | 414 | 0 |
523084 | 523084 | 2020-09-11 | Warren | Missouri | 29219 | 406 | 0 |
519847 | 519847 | 2020-09-10 | Warren | Missouri | 29219 | 395 | 0 |
516612 | 516612 | 2020-09-09 | Warren | Missouri | 29219 | 389 | 0 |
513378 | 513378 | 2020-09-08 | Warren | Missouri | 29219 | 384 | 0 |
510146 | 510146 | 2020-09-07 | Warren | Missouri | 29219 | 372 | 0 |
506913 | 506913 | 2020-09-06 | Warren | Missouri | 29219 | 372 | 0 |
503680 | 503680 | 2020-09-05 | Warren | Missouri | 29219 | 367 | 0 |
500446 | 500446 | 2020-09-04 | Warren | Missouri | 29219 | 364 | 0 |
497212 | 497212 | 2020-09-03 | Warren | Missouri | 29219 | 354 | 0 |
493979 | 493979 | 2020-09-02 | Warren | Missouri | 29219 | 348 | 0 |
490745 | 490745 | 2020-09-01 | Warren | Missouri | 29219 | 340 | 0 |
487512 | 487512 | 2020-08-31 | Warren | Missouri | 29219 | 331 | 0 |
484278 | 484278 | 2020-08-30 | Warren | Missouri | 29219 | 331 | 0 |
481043 | 481043 | 2020-08-29 | Warren | Missouri | 29219 | 329 | 0 |
477811 | 477811 | 2020-08-28 | Warren | Missouri | 29219 | 323 | 0 |
474578 | 474578 | 2020-08-27 | Warren | Missouri | 29219 | 314 | 0 |
471346 | 471346 | 2020-08-26 | Warren | Missouri | 29219 | 310 | 0 |
468116 | 468116 | 2020-08-25 | Warren | Missouri | 29219 | 305 | 0 |
464887 | 464887 | 2020-08-24 | Warren | Missouri | 29219 | 299 | 0 |
461656 | 461656 | 2020-08-23 | Warren | Missouri | 29219 | 296 | 0 |
458429 | 458429 | 2020-08-22 | Warren | Missouri | 29219 | 293 | 0 |
455201 | 455201 | 2020-08-21 | Warren | Missouri | 29219 | 290 | 0 |
451973 | 451973 | 2020-08-20 | Warren | Missouri | 29219 | 285 | 0 |
448745 | 448745 | 2020-08-19 | Warren | Missouri | 29219 | 281 | 0 |
445519 | 445519 | 2020-08-18 | Warren | Missouri | 29219 | 275 | 0 |
442293 | 442293 | 2020-08-17 | Warren | Missouri | 29219 | 264 | 0 |
439066 | 439066 | 2020-08-16 | Warren | Missouri | 29219 | 253 | 0 |
435841 | 435841 | 2020-08-15 | Warren | Missouri | 29219 | 238 | 0 |
432615 | 432615 | 2020-08-14 | Warren | Missouri | 29219 | 231 | 0 |
429388 | 429388 | 2020-08-13 | Warren | Missouri | 29219 | 221 | 0 |
426164 | 426164 | 2020-08-12 | Warren | Missouri | 29219 | 212 | 0 |
422942 | 422942 | 2020-08-11 | Warren | Missouri | 29219 | 208 | 0 |
419720 | 419720 | 2020-08-10 | Warren | Missouri | 29219 | 207 | 0 |
416499 | 416499 | 2020-08-09 | Warren | Missouri | 29219 | 197 | 0 |
413279 | 413279 | 2020-08-08 | Warren | Missouri | 29219 | 193 | 0 |
410059 | 410059 | 2020-08-07 | Warren | Missouri | 29219 | 191 | 0 |
406839 | 406839 | 2020-08-06 | Warren | Missouri | 29219 | 189 | 0 |
403621 | 403621 | 2020-08-05 | Warren | Missouri | 29219 | 185 | 0 |
400404 | 400404 | 2020-08-04 | Warren | Missouri | 29219 | 180 | 0 |
397190 | 397190 | 2020-08-03 | Warren | Missouri | 29219 | 178 | 0 |
393974 | 393974 | 2020-08-02 | Warren | Missouri | 29219 | 161 | 0 |
390757 | 390757 | 2020-08-01 | Warren | Missouri | 29219 | 157 | 0 |
387540 | 387540 | 2020-07-31 | Warren | Missouri | 29219 | 153 | 0 |
384322 | 384322 | 2020-07-30 | Warren | Missouri | 29219 | 146 | 0 |
381106 | 381106 | 2020-07-29 | Warren | Missouri | 29219 | 138 | 0 |
377889 | 377889 | 2020-07-28 | Warren | Missouri | 29219 | 137 | 0 |
374674 | 374674 | 2020-07-27 | Warren | Missouri | 29219 | 135 | 0 |
371462 | 371462 | 2020-07-26 | Warren | Missouri | 29219 | 127 | 0 |
368251 | 368251 | 2020-07-25 | Warren | Missouri | 29219 | 127 | 0 |
365043 | 365043 | 2020-07-24 | Warren | Missouri | 29219 | 121 | 0 |
361836 | 361836 | 2020-07-23 | Warren | Missouri | 29219 | 121 | 0 |
358631 | 358631 | 2020-07-22 | Warren | Missouri | 29219 | 118 | 0 |
355428 | 355428 | 2020-07-21 | Warren | Missouri | 29219 | 118 | 0 |
352226 | 352226 | 2020-07-20 | Warren | Missouri | 29219 | 118 | 0 |
349026 | 349026 | 2020-07-19 | Warren | Missouri | 29219 | 116 | 0 |
345825 | 345825 | 2020-07-18 | Warren | Missouri | 29219 | 116 | 0 |
342625 | 342625 | 2020-07-17 | Warren | Missouri | 29219 | 108 | 0 |
339429 | 339429 | 2020-07-16 | Warren | Missouri | 29219 | 103 | 0 |
336233 | 336233 | 2020-07-15 | Warren | Missouri | 29219 | 100 | 0 |
333040 | 333040 | 2020-07-14 | Warren | Missouri | 29219 | 95 | 0 |
329853 | 329853 | 2020-07-13 | Warren | Missouri | 29219 | 92 | 0 |
326667 | 326667 | 2020-07-12 | Warren | Missouri | 29219 | 86 | 0 |
323484 | 323484 | 2020-07-11 | Warren | Missouri | 29219 | 81 | 0 |
320305 | 320305 | 2020-07-10 | Warren | Missouri | 29219 | 73 | 0 |
317130 | 317130 | 2020-07-09 | Warren | Missouri | 29219 | 67 | 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);