ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Kansas City" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175745 | 2175745 | 2022-02-02 | Kansas City | Missouri | 108215 | 1091 | |
2172492 | 2172492 | 2022-02-01 | Kansas City | Missouri | 107704 | 1086 | |
2169239 | 2169239 | 2022-01-31 | Kansas City | Missouri | 107342 | 1065 | |
2165984 | 2165984 | 2022-01-30 | Kansas City | Missouri | 107143 | 1065 | |
2162729 | 2162729 | 2022-01-29 | Kansas City | Missouri | 106845 | 1065 | |
2159474 | 2159474 | 2022-01-28 | Kansas City | Missouri | 106082 | 1064 | |
2156220 | 2156220 | 2022-01-27 | Kansas City | Missouri | 105459 | 1064 | |
2152967 | 2152967 | 2022-01-26 | Kansas City | Missouri | 104690 | 1064 | |
2149715 | 2149715 | 2022-01-25 | Kansas City | Missouri | 104045 | 1064 | |
2146463 | 2146463 | 2022-01-24 | Kansas City | Missouri | 103416 | 1061 | |
2143208 | 2143208 | 2022-01-23 | Kansas City | Missouri | 102853 | 1060 | |
2139953 | 2139953 | 2022-01-22 | Kansas City | Missouri | 102136 | 1060 | |
2136697 | 2136697 | 2022-01-21 | Kansas City | Missouri | 101034 | 1060 | |
2133445 | 2133445 | 2022-01-20 | Kansas City | Missouri | 99679 | 1043 | |
2130192 | 2130192 | 2022-01-19 | Kansas City | Missouri | 98437 | 1047 | |
2126938 | 2126938 | 2022-01-18 | Kansas City | Missouri | 97339 | 1028 | |
2123686 | 2123686 | 2022-01-17 | Kansas City | Missouri | 95256 | 1028 | |
2120434 | 2120434 | 2022-01-16 | Kansas City | Missouri | 95256 | 1028 | |
2117182 | 2117182 | 2022-01-15 | Kansas City | Missouri | 95256 | 1028 | |
2113931 | 2113931 | 2022-01-14 | Kansas City | Missouri | 93231 | 1028 | |
2110679 | 2110679 | 2022-01-13 | Kansas City | Missouri | 92304 | 1023 | |
2107428 | 2107428 | 2022-01-12 | Kansas City | Missouri | 90942 | 1023 | |
2104177 | 2104177 | 2022-01-11 | Kansas City | Missouri | 89572 | 1022 | |
2100926 | 2100926 | 2022-01-10 | Kansas City | Missouri | 88160 | 1010 | |
2097675 | 2097675 | 2022-01-09 | Kansas City | Missouri | 87241 | 1010 | |
2094423 | 2094423 | 2022-01-08 | Kansas City | Missouri | 86770 | 1009 | |
2091171 | 2091171 | 2022-01-07 | Kansas City | Missouri | 84898 | 1008 | |
2087920 | 2087920 | 2022-01-06 | Kansas City | Missouri | 83614 | 1008 | |
2084668 | 2084668 | 2022-01-05 | Kansas City | Missouri | 82240 | 1006 | |
2081416 | 2081416 | 2022-01-04 | Kansas City | Missouri | 81006 | 1005 | |
2078164 | 2078164 | 2022-01-03 | Kansas City | Missouri | 80274 | 1000 | |
2074913 | 2074913 | 2022-01-02 | Kansas City | Missouri | 76832 | 1000 | |
2071662 | 2071662 | 2022-01-01 | Kansas City | Missouri | 76832 | 1000 | |
2068411 | 2068411 | 2021-12-31 | Kansas City | Missouri | 76832 | 1000 | |
2065160 | 2065160 | 2021-12-30 | Kansas City | Missouri | 76832 | 1000 | |
2061910 | 2061910 | 2021-12-29 | Kansas City | Missouri | 76014 | 1004 | |
2058661 | 2058661 | 2021-12-28 | Kansas City | Missouri | 75393 | 1003 | |
2055412 | 2055412 | 2021-12-27 | Kansas City | Missouri | 74964 | 997 | |
2052162 | 2052162 | 2021-12-26 | Kansas City | Missouri | 73948 | 996 | |
2048912 | 2048912 | 2021-12-25 | Kansas City | Missouri | 73948 | 996 | |
2045662 | 2045662 | 2021-12-24 | Kansas City | Missouri | 73948 | 996 | |
2042412 | 2042412 | 2021-12-23 | Kansas City | Missouri | 73948 | 996 | |
2039163 | 2039163 | 2021-12-22 | Kansas City | Missouri | 73301 | 993 | |
2035913 | 2035913 | 2021-12-21 | Kansas City | Missouri | 73015 | 989 | |
2032663 | 2032663 | 2021-12-20 | Kansas City | Missouri | 72855 | 982 | |
2029412 | 2029412 | 2021-12-19 | Kansas City | Missouri | 72616 | 982 | |
2026161 | 2026161 | 2021-12-18 | Kansas City | Missouri | 72393 | 982 | |
2022910 | 2022910 | 2021-12-17 | Kansas City | Missouri | 72098 | 982 | |
2019659 | 2019659 | 2021-12-16 | Kansas City | Missouri | 71802 | 982 | |
2016409 | 2016409 | 2021-12-15 | Kansas City | Missouri | 71381 | 982 | |
2013158 | 2013158 | 2021-12-14 | Kansas City | Missouri | 71117 | 977 | |
2009907 | 2009907 | 2021-12-13 | Kansas City | Missouri | 70957 | 967 | |
2006656 | 2006656 | 2021-12-12 | Kansas City | Missouri | 70838 | 967 | |
2003405 | 2003405 | 2021-12-11 | Kansas City | Missouri | 70605 | 967 | |
2000155 | 2000155 | 2021-12-10 | Kansas City | Missouri | 70346 | 966 | |
1996904 | 1996904 | 2021-12-09 | Kansas City | Missouri | 70033 | 964 | |
1993653 | 1993653 | 2021-12-08 | Kansas City | Missouri | 69727 | 954 | |
1990402 | 1990402 | 2021-12-07 | Kansas City | Missouri | 69353 | 954 | |
1987152 | 1987152 | 2021-12-06 | Kansas City | Missouri | 69178 | 952 | |
1983902 | 1983902 | 2021-12-05 | Kansas City | Missouri | 68811 | 952 | |
1980652 | 1980652 | 2021-12-04 | Kansas City | Missouri | 68721 | 952 | |
1977402 | 1977402 | 2021-12-03 | Kansas City | Missouri | 68146 | 952 | |
1974152 | 1974152 | 2021-12-02 | Kansas City | Missouri | 68146 | 952 | |
1970903 | 1970903 | 2021-12-01 | Kansas City | Missouri | 67899 | 952 | |
1967653 | 1967653 | 2021-11-30 | Kansas City | Missouri | 67668 | 951 | |
1964401 | 1964401 | 2021-11-29 | Kansas City | Missouri | 67493 | 948 | |
1961150 | 1961150 | 2021-11-28 | Kansas City | Missouri | 66830 | 948 | |
1957899 | 1957899 | 2021-11-27 | Kansas City | Missouri | 66830 | 948 | |
1954648 | 1954648 | 2021-11-26 | Kansas City | Missouri | 66830 | 948 | |
1951397 | 1951397 | 2021-11-25 | Kansas City | Missouri | 66830 | 948 | |
1948146 | 1948146 | 2021-11-24 | Kansas City | Missouri | 66830 | 948 | |
1944895 | 1944895 | 2021-11-23 | Kansas City | Missouri | 66683 | 948 | |
1941644 | 1941644 | 2021-11-22 | Kansas City | Missouri | 66584 | 942 | |
1938394 | 1938394 | 2021-11-21 | Kansas City | Missouri | 66517 | 952 | |
1935144 | 1935144 | 2021-11-20 | Kansas City | Missouri | 66390 | 950 | |
1931894 | 1931894 | 2021-11-19 | Kansas City | Missouri | 66213 | 949 | |
1928643 | 1928643 | 2021-11-18 | Kansas City | Missouri | 66091 | 940 | |
1925393 | 1925393 | 2021-11-17 | Kansas City | Missouri | 65182 | 857 | |
1922144 | 1922144 | 2021-11-16 | Kansas City | Missouri | 65070 | 857 | |
1918894 | 1918894 | 2021-11-15 | Kansas City | Missouri | 65025 | 853 | |
1915644 | 1915644 | 2021-11-14 | Kansas City | Missouri | 64971 | 853 | |
1912394 | 1912394 | 2021-11-13 | Kansas City | Missouri | 64874 | 853 | |
1909144 | 1909144 | 2021-11-12 | Kansas City | Missouri | 64767 | 850 | |
1905895 | 1905895 | 2021-11-11 | Kansas City | Missouri | 64530 | 850 | |
1902646 | 1902646 | 2021-11-10 | Kansas City | Missouri | 64530 | 850 | |
1899396 | 1899396 | 2021-11-09 | Kansas City | Missouri | 64417 | 849 | |
1896146 | 1896146 | 2021-11-08 | Kansas City | Missouri | 64345 | 840 | |
1892896 | 1892896 | 2021-11-07 | Kansas City | Missouri | 64244 | 840 | |
1889646 | 1889646 | 2021-11-06 | Kansas City | Missouri | 64164 | 840 | |
1886396 | 1886396 | 2021-11-05 | Kansas City | Missouri | 64061 | 839 | |
1883147 | 1883147 | 2021-11-04 | Kansas City | Missouri | 63969 | 839 | |
1879898 | 1879898 | 2021-11-03 | Kansas City | Missouri | 63883 | 839 | |
1876649 | 1876649 | 2021-11-02 | Kansas City | Missouri | 63803 | 837 | |
1873400 | 1873400 | 2021-11-01 | Kansas City | Missouri | 63761 | 827 | |
1870151 | 1870151 | 2021-10-31 | Kansas City | Missouri | 63718 | 827 | |
1866902 | 1866902 | 2021-10-30 | Kansas City | Missouri | 63647 | 827 | |
1863653 | 1863653 | 2021-10-29 | Kansas City | Missouri | 63554 | 826 | |
1860404 | 1860404 | 2021-10-28 | Kansas City | Missouri | 63455 | 823 | |
1857155 | 1857155 | 2021-10-27 | Kansas City | Missouri | 63365 | 823 | |
1853906 | 1853906 | 2021-10-26 | Kansas City | Missouri | 63259 | 822 |
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);