ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Lawrence" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921990 | 921990 | 2021-01-12 | Lawrence | Missouri | 29109 | 2532 | 60 |
918745 | 918745 | 2021-01-11 | Lawrence | Missouri | 29109 | 2521 | 57 |
915500 | 915500 | 2021-01-10 | Lawrence | Missouri | 29109 | 2515 | 57 |
912255 | 912255 | 2021-01-09 | Lawrence | Missouri | 29109 | 2490 | 57 |
909010 | 909010 | 2021-01-08 | Lawrence | Missouri | 29109 | 2470 | 57 |
905764 | 905764 | 2021-01-07 | Lawrence | Missouri | 29109 | 2434 | 57 |
902519 | 902519 | 2021-01-06 | Lawrence | Missouri | 29109 | 2418 | 57 |
899274 | 899274 | 2021-01-05 | Lawrence | Missouri | 29109 | 2407 | 57 |
896029 | 896029 | 2021-01-04 | Lawrence | Missouri | 29109 | 2370 | 52 |
892782 | 892782 | 2021-01-03 | Lawrence | Missouri | 29109 | 2370 | 52 |
889536 | 889536 | 2021-01-02 | Lawrence | Missouri | 29109 | 2355 | 52 |
886290 | 886290 | 2021-01-01 | Lawrence | Missouri | 29109 | 2346 | 52 |
883045 | 883045 | 2020-12-31 | Lawrence | Missouri | 29109 | 2293 | 52 |
879800 | 879800 | 2020-12-30 | Lawrence | Missouri | 29109 | 2277 | 47 |
876555 | 876555 | 2020-12-29 | Lawrence | Missouri | 29109 | 2265 | 47 |
873310 | 873310 | 2020-12-28 | Lawrence | Missouri | 29109 | 2261 | 47 |
870065 | 870065 | 2020-12-27 | Lawrence | Missouri | 29109 | 2257 | 47 |
866820 | 866820 | 2020-12-26 | Lawrence | Missouri | 29109 | 2251 | 47 |
863575 | 863575 | 2020-12-25 | Lawrence | Missouri | 29109 | 2247 | 47 |
860330 | 860330 | 2020-12-24 | Lawrence | Missouri | 29109 | 2241 | 47 |
857085 | 857085 | 2020-12-23 | Lawrence | Missouri | 29109 | 2224 | 47 |
853840 | 853840 | 2020-12-22 | Lawrence | Missouri | 29109 | 2215 | 45 |
850595 | 850595 | 2020-12-21 | Lawrence | Missouri | 29109 | 2199 | 41 |
847350 | 847350 | 2020-12-20 | Lawrence | Missouri | 29109 | 2190 | 41 |
844104 | 844104 | 2020-12-19 | Lawrence | Missouri | 29109 | 2183 | 41 |
840859 | 840859 | 2020-12-18 | Lawrence | Missouri | 29109 | 2169 | 41 |
837614 | 837614 | 2020-12-17 | Lawrence | Missouri | 29109 | 2153 | 41 |
834368 | 834368 | 2020-12-16 | Lawrence | Missouri | 29109 | 2133 | 41 |
831121 | 831121 | 2020-12-15 | Lawrence | Missouri | 29109 | 2121 | 41 |
827875 | 827875 | 2020-12-14 | Lawrence | Missouri | 29109 | 2114 | 41 |
824628 | 824628 | 2020-12-13 | Lawrence | Missouri | 29109 | 2105 | 41 |
821382 | 821382 | 2020-12-12 | Lawrence | Missouri | 29109 | 2093 | 41 |
818136 | 818136 | 2020-12-11 | Lawrence | Missouri | 29109 | 2069 | 41 |
814890 | 814890 | 2020-12-10 | Lawrence | Missouri | 29109 | 2069 | 41 |
811645 | 811645 | 2020-12-09 | Lawrence | Missouri | 29109 | 2052 | 41 |
808400 | 808400 | 2020-12-08 | Lawrence | Missouri | 29109 | 2044 | 41 |
805155 | 805155 | 2020-12-07 | Lawrence | Missouri | 29109 | 2033 | 39 |
801910 | 801910 | 2020-12-06 | Lawrence | Missouri | 29109 | 2019 | 39 |
798665 | 798665 | 2020-12-05 | Lawrence | Missouri | 29109 | 2010 | 39 |
795420 | 795420 | 2020-12-04 | Lawrence | Missouri | 29109 | 1997 | 39 |
792175 | 792175 | 2020-12-03 | Lawrence | Missouri | 29109 | 1978 | 39 |
788930 | 788930 | 2020-12-02 | Lawrence | Missouri | 29109 | 1963 | 39 |
785685 | 785685 | 2020-12-01 | Lawrence | Missouri | 29109 | 1956 | 39 |
782441 | 782441 | 2020-11-30 | Lawrence | Missouri | 29109 | 1932 | 37 |
779195 | 779195 | 2020-11-29 | Lawrence | Missouri | 29109 | 1902 | 37 |
775950 | 775950 | 2020-11-28 | Lawrence | Missouri | 29109 | 1884 | 37 |
772705 | 772705 | 2020-11-27 | Lawrence | Missouri | 29109 | 1881 | 37 |
769460 | 769460 | 2020-11-26 | Lawrence | Missouri | 29109 | 1858 | 37 |
766214 | 766214 | 2020-11-25 | Lawrence | Missouri | 29109 | 1832 | 37 |
762969 | 762969 | 2020-11-24 | Lawrence | Missouri | 29109 | 1822 | 37 |
759724 | 759724 | 2020-11-23 | Lawrence | Missouri | 29109 | 1813 | 33 |
756477 | 756477 | 2020-11-22 | Lawrence | Missouri | 29109 | 1787 | 33 |
753231 | 753231 | 2020-11-21 | Lawrence | Missouri | 29109 | 1772 | 33 |
749985 | 749985 | 2020-11-20 | Lawrence | Missouri | 29109 | 1742 | 33 |
746739 | 746739 | 2020-11-19 | Lawrence | Missouri | 29109 | 1712 | 33 |
743492 | 743492 | 2020-11-18 | Lawrence | Missouri | 29109 | 1679 | 33 |
740245 | 740245 | 2020-11-17 | Lawrence | Missouri | 29109 | 1657 | 33 |
737001 | 737001 | 2020-11-16 | Lawrence | Missouri | 29109 | 1618 | 32 |
733755 | 733755 | 2020-11-15 | Lawrence | Missouri | 29109 | 1585 | 32 |
730510 | 730510 | 2020-11-14 | Lawrence | Missouri | 29109 | 1585 | 32 |
727267 | 727267 | 2020-11-13 | Lawrence | Missouri | 29109 | 1517 | 32 |
724024 | 724024 | 2020-11-12 | Lawrence | Missouri | 29109 | 1489 | 32 |
720781 | 720781 | 2020-11-11 | Lawrence | Missouri | 29109 | 1459 | 32 |
717538 | 717538 | 2020-11-10 | Lawrence | Missouri | 29109 | 1440 | 32 |
714294 | 714294 | 2020-11-09 | Lawrence | Missouri | 29109 | 1410 | 26 |
711050 | 711050 | 2020-11-08 | Lawrence | Missouri | 29109 | 1381 | 26 |
707806 | 707806 | 2020-11-07 | Lawrence | Missouri | 29109 | 1351 | 26 |
704563 | 704563 | 2020-11-06 | Lawrence | Missouri | 29109 | 1324 | 26 |
701321 | 701321 | 2020-11-05 | Lawrence | Missouri | 29109 | 1284 | 25 |
698077 | 698077 | 2020-11-04 | Lawrence | Missouri | 29109 | 1256 | 24 |
694834 | 694834 | 2020-11-03 | Lawrence | Missouri | 29109 | 1239 | 24 |
691592 | 691592 | 2020-11-02 | Lawrence | Missouri | 29109 | 1222 | 24 |
688347 | 688347 | 2020-11-01 | Lawrence | Missouri | 29109 | 1193 | 24 |
685103 | 685103 | 2020-10-31 | Lawrence | Missouri | 29109 | 1177 | 24 |
681860 | 681860 | 2020-10-30 | Lawrence | Missouri | 29109 | 1156 | 21 |
678616 | 678616 | 2020-10-29 | Lawrence | Missouri | 29109 | 1139 | 21 |
675374 | 675374 | 2020-10-28 | Lawrence | Missouri | 29109 | 1126 | 21 |
672131 | 672131 | 2020-10-27 | Lawrence | Missouri | 29109 | 1105 | 21 |
668889 | 668889 | 2020-10-26 | Lawrence | Missouri | 29109 | 1096 | 20 |
665645 | 665645 | 2020-10-25 | Lawrence | Missouri | 29109 | 1089 | 20 |
662400 | 662400 | 2020-10-24 | Lawrence | Missouri | 29109 | 1062 | 20 |
659156 | 659156 | 2020-10-23 | Lawrence | Missouri | 29109 | 1034 | 14 |
655911 | 655911 | 2020-10-22 | Lawrence | Missouri | 29109 | 1018 | 14 |
652666 | 652666 | 2020-10-21 | Lawrence | Missouri | 29109 | 1006 | 14 |
649421 | 649421 | 2020-10-20 | Lawrence | Missouri | 29109 | 974 | 14 |
646177 | 646177 | 2020-10-19 | Lawrence | Missouri | 29109 | 974 | 14 |
642931 | 642931 | 2020-10-18 | Lawrence | Missouri | 29109 | 957 | 14 |
639683 | 639683 | 2020-10-17 | Lawrence | Missouri | 29109 | 944 | 14 |
636437 | 636437 | 2020-10-16 | Lawrence | Missouri | 29109 | 928 | 13 |
633191 | 633191 | 2020-10-15 | Lawrence | Missouri | 29109 | 907 | 13 |
629946 | 629946 | 2020-10-14 | Lawrence | Missouri | 29109 | 880 | 14 |
626702 | 626702 | 2020-10-13 | Lawrence | Missouri | 29109 | 823 | 13 |
623460 | 623460 | 2020-10-12 | Lawrence | Missouri | 29109 | 823 | 13 |
620217 | 620217 | 2020-10-11 | Lawrence | Missouri | 29109 | 823 | 13 |
616975 | 616975 | 2020-10-10 | Lawrence | Missouri | 29109 | 823 | 13 |
613734 | 613734 | 2020-10-09 | Lawrence | Missouri | 29109 | 786 | 13 |
610492 | 610492 | 2020-10-08 | Lawrence | Missouri | 29109 | 772 | 13 |
607250 | 607250 | 2020-10-07 | Lawrence | Missouri | 29109 | 755 | 3 |
604007 | 604007 | 2020-10-06 | Lawrence | Missouri | 29109 | 747 | 4 |
600765 | 600765 | 2020-10-05 | Lawrence | Missouri | 29109 | 738 | 4 |
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);