ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "St. Louis" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536018 | 536018 | 2020-09-15 | St. Louis | Missouri | 29189 | 22090 | 774 |
532783 | 532783 | 2020-09-14 | St. Louis | Missouri | 29189 | 21914 | 768 |
529547 | 529547 | 2020-09-13 | St. Louis | Missouri | 29189 | 21831 | 768 |
526311 | 526311 | 2020-09-12 | St. Louis | Missouri | 29189 | 21588 | 768 |
523075 | 523075 | 2020-09-11 | St. Louis | Missouri | 29189 | 21343 | 763 |
519838 | 519838 | 2020-09-10 | St. Louis | Missouri | 29189 | 21187 | 763 |
516603 | 516603 | 2020-09-09 | St. Louis | Missouri | 29189 | 21001 | 762 |
513369 | 513369 | 2020-09-08 | St. Louis | Missouri | 29189 | 20839 | 760 |
510137 | 510137 | 2020-09-07 | St. Louis | Missouri | 29189 | 20735 | 760 |
506904 | 506904 | 2020-09-06 | St. Louis | Missouri | 29189 | 20574 | 760 |
503671 | 503671 | 2020-09-05 | St. Louis | Missouri | 29189 | 20351 | 760 |
500437 | 500437 | 2020-09-04 | St. Louis | Missouri | 29189 | 20174 | 757 |
497203 | 497203 | 2020-09-03 | St. Louis | Missouri | 29189 | 20039 | 755 |
493970 | 493970 | 2020-09-02 | St. Louis | Missouri | 29189 | 19852 | 752 |
490736 | 490736 | 2020-09-01 | St. Louis | Missouri | 29189 | 19665 | 738 |
487503 | 487503 | 2020-08-31 | St. Louis | Missouri | 29189 | 19432 | 732 |
484269 | 484269 | 2020-08-30 | St. Louis | Missouri | 29189 | 19278 | 729 |
481034 | 481034 | 2020-08-29 | St. Louis | Missouri | 29189 | 19071 | 729 |
477802 | 477802 | 2020-08-28 | St. Louis | Missouri | 29189 | 18774 | 727 |
474569 | 474569 | 2020-08-27 | St. Louis | Missouri | 29189 | 18507 | 726 |
471337 | 471337 | 2020-08-26 | St. Louis | Missouri | 29189 | 18334 | 721 |
468107 | 468107 | 2020-08-25 | St. Louis | Missouri | 29189 | 18210 | 720 |
464878 | 464878 | 2020-08-24 | St. Louis | Missouri | 29189 | 17975 | 713 |
461647 | 461647 | 2020-08-23 | St. Louis | Missouri | 29189 | 17872 | 713 |
458420 | 458420 | 2020-08-22 | St. Louis | Missouri | 29189 | 17721 | 713 |
455192 | 455192 | 2020-08-21 | St. Louis | Missouri | 29189 | 17517 | 710 |
451964 | 451964 | 2020-08-20 | St. Louis | Missouri | 29189 | 17294 | 710 |
448736 | 448736 | 2020-08-19 | St. Louis | Missouri | 29189 | 17094 | 705 |
445510 | 445510 | 2020-08-18 | St. Louis | Missouri | 29189 | 16968 | 705 |
442284 | 442284 | 2020-08-17 | St. Louis | Missouri | 29189 | 16764 | 701 |
439057 | 439057 | 2020-08-16 | St. Louis | Missouri | 29189 | 16614 | 683 |
435832 | 435832 | 2020-08-15 | St. Louis | Missouri | 29189 | 16409 | 678 |
432606 | 432606 | 2020-08-14 | St. Louis | Missouri | 29189 | 16133 | 676 |
429379 | 429379 | 2020-08-13 | St. Louis | Missouri | 29189 | 15872 | 673 |
426155 | 426155 | 2020-08-12 | St. Louis | Missouri | 29189 | 15485 | 672 |
422933 | 422933 | 2020-08-11 | St. Louis | Missouri | 29189 | 15284 | 672 |
419711 | 419711 | 2020-08-10 | St. Louis | Missouri | 29189 | 14941 | 671 |
416490 | 416490 | 2020-08-09 | St. Louis | Missouri | 29189 | 14785 | 667 |
413270 | 413270 | 2020-08-08 | St. Louis | Missouri | 29189 | 14666 | 663 |
410050 | 410050 | 2020-08-07 | St. Louis | Missouri | 29189 | 14563 | 662 |
406830 | 406830 | 2020-08-06 | St. Louis | Missouri | 29189 | 14362 | 653 |
403612 | 403612 | 2020-08-05 | St. Louis | Missouri | 29189 | 14074 | 652 |
400395 | 400395 | 2020-08-04 | St. Louis | Missouri | 29189 | 13788 | 651 |
397181 | 397181 | 2020-08-03 | St. Louis | Missouri | 29189 | 13474 | 650 |
393965 | 393965 | 2020-08-02 | St. Louis | Missouri | 29189 | 13271 | 650 |
390748 | 390748 | 2020-08-01 | St. Louis | Missouri | 29189 | 13162 | 650 |
387531 | 387531 | 2020-07-31 | St. Louis | Missouri | 29189 | 12880 | 650 |
384313 | 384313 | 2020-07-30 | St. Louis | Missouri | 29189 | 12548 | 648 |
381097 | 381097 | 2020-07-29 | St. Louis | Missouri | 29189 | 12018 | 646 |
377880 | 377880 | 2020-07-28 | St. Louis | Missouri | 29189 | 11595 | 643 |
374665 | 374665 | 2020-07-27 | St. Louis | Missouri | 29189 | 11507 | 636 |
371453 | 371453 | 2020-07-26 | St. Louis | Missouri | 29189 | 11210 | 632 |
368242 | 368242 | 2020-07-25 | St. Louis | Missouri | 29189 | 10687 | 628 |
365034 | 365034 | 2020-07-24 | St. Louis | Missouri | 29189 | 10319 | 627 |
361827 | 361827 | 2020-07-23 | St. Louis | Missouri | 29189 | 9944 | 626 |
358622 | 358622 | 2020-07-22 | St. Louis | Missouri | 29189 | 9624 | 619 |
355419 | 355419 | 2020-07-21 | St. Louis | Missouri | 29189 | 9361 | 610 |
352217 | 352217 | 2020-07-20 | St. Louis | Missouri | 29189 | 9114 | 610 |
349017 | 349017 | 2020-07-19 | St. Louis | Missouri | 29189 | 8990 | 610 |
345816 | 345816 | 2020-07-18 | St. Louis | Missouri | 29189 | 8862 | 610 |
342616 | 342616 | 2020-07-17 | St. Louis | Missouri | 29189 | 8739 | 607 |
339420 | 339420 | 2020-07-16 | St. Louis | Missouri | 29189 | 8561 | 605 |
336224 | 336224 | 2020-07-15 | St. Louis | Missouri | 29189 | 8300 | 605 |
333031 | 333031 | 2020-07-14 | St. Louis | Missouri | 29189 | 8140 | 604 |
329844 | 329844 | 2020-07-13 | St. Louis | Missouri | 29189 | 7897 | 603 |
326658 | 326658 | 2020-07-12 | St. Louis | Missouri | 29189 | 7809 | 597 |
323475 | 323475 | 2020-07-11 | St. Louis | Missouri | 29189 | 7761 | 597 |
320296 | 320296 | 2020-07-10 | St. Louis | Missouri | 29189 | 7586 | 595 |
317121 | 317121 | 2020-07-09 | St. Louis | Missouri | 29189 | 7469 | 593 |
313947 | 313947 | 2020-07-08 | St. Louis | Missouri | 29189 | 7284 | 593 |
310776 | 310776 | 2020-07-07 | St. Louis | Missouri | 29189 | 7066 | 593 |
307608 | 307608 | 2020-07-06 | St. Louis | Missouri | 29189 | 6931 | 584 |
304441 | 304441 | 2020-07-05 | St. Louis | Missouri | 29189 | 6887 | 584 |
301277 | 301277 | 2020-07-04 | St. Louis | Missouri | 29189 | 6837 | 584 |
298114 | 298114 | 2020-07-03 | St. Louis | Missouri | 29189 | 6755 | 583 |
294956 | 294956 | 2020-07-02 | St. Louis | Missouri | 29189 | 6682 | 582 |
291802 | 291802 | 2020-07-01 | St. Louis | Missouri | 29189 | 6616 | 581 |
288651 | 288651 | 2020-06-30 | St. Louis | Missouri | 29189 | 6582 | 575 |
285501 | 285501 | 2020-06-29 | St. Louis | Missouri | 29189 | 6446 | 568 |
282356 | 282356 | 2020-06-28 | St. Louis | Missouri | 29189 | 6357 | 568 |
279208 | 279208 | 2020-06-27 | St. Louis | Missouri | 29189 | 6293 | 568 |
276060 | 276060 | 2020-06-26 | St. Louis | Missouri | 29189 | 6201 | 567 |
272917 | 272917 | 2020-06-25 | St. Louis | Missouri | 29189 | 6092 | 558 |
269778 | 269778 | 2020-06-24 | St. Louis | Missouri | 29189 | 6004 | 558 |
266645 | 266645 | 2020-06-23 | St. Louis | Missouri | 29189 | 5941 | 555 |
263519 | 263519 | 2020-06-22 | St. Louis | Missouri | 29189 | 5878 | 551 |
260391 | 260391 | 2020-06-21 | St. Louis | Missouri | 29189 | 5850 | 550 |
257265 | 257265 | 2020-06-20 | St. Louis | Missouri | 29189 | 5825 | 550 |
254144 | 254144 | 2020-06-19 | St. Louis | Missouri | 29189 | 5769 | 547 |
251029 | 251029 | 2020-06-18 | St. Louis | Missouri | 29189 | 5731 | 544 |
247916 | 247916 | 2020-06-17 | St. Louis | Missouri | 29189 | 5669 | 518 |
244803 | 244803 | 2020-06-16 | St. Louis | Missouri | 29189 | 5653 | 503 |
241692 | 241692 | 2020-06-15 | St. Louis | Missouri | 29189 | 5604 | 500 |
238582 | 238582 | 2020-06-14 | St. Louis | Missouri | 29189 | 5536 | 500 |
235475 | 235475 | 2020-06-13 | St. Louis | Missouri | 29189 | 5506 | 500 |
232369 | 232369 | 2020-06-12 | St. Louis | Missouri | 29189 | 5460 | 499 |
229265 | 229265 | 2020-06-11 | St. Louis | Missouri | 29189 | 5440 | 496 |
226162 | 226162 | 2020-06-10 | St. Louis | Missouri | 29189 | 5388 | 485 |
223063 | 223063 | 2020-06-09 | St. Louis | Missouri | 29189 | 5345 | 480 |
219968 | 219968 | 2020-06-08 | St. Louis | Missouri | 29189 | 5301 | 466 |
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);