ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,511 rows where fips = "" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110678 | 2110678 | 2022-01-13 | Joplin | Missouri | 10768 | 191 | |
2110679 | 2110679 | 2022-01-13 | Kansas City | Missouri | 92304 | 1023 | |
2107427 | 2107427 | 2022-01-12 | Joplin | Missouri | 10612 | 191 | |
2107428 | 2107428 | 2022-01-12 | Kansas City | Missouri | 90942 | 1023 | |
2104176 | 2104176 | 2022-01-11 | Joplin | Missouri | 10456 | 191 | |
2104177 | 2104177 | 2022-01-11 | Kansas City | Missouri | 89572 | 1022 | |
2100925 | 2100925 | 2022-01-10 | Joplin | Missouri | 10331 | 191 | |
2100926 | 2100926 | 2022-01-10 | Kansas City | Missouri | 88160 | 1010 | |
2097674 | 2097674 | 2022-01-09 | Joplin | Missouri | 10292 | 191 | |
2097675 | 2097675 | 2022-01-09 | Kansas City | Missouri | 87241 | 1010 | |
2094422 | 2094422 | 2022-01-08 | Joplin | Missouri | 10261 | 191 | |
2094423 | 2094423 | 2022-01-08 | Kansas City | Missouri | 86770 | 1009 | |
2091170 | 2091170 | 2022-01-07 | Joplin | Missouri | 10173 | 191 | |
2091171 | 2091171 | 2022-01-07 | Kansas City | Missouri | 84898 | 1008 | |
2087919 | 2087919 | 2022-01-06 | Joplin | Missouri | 10103 | 191 | |
2087920 | 2087920 | 2022-01-06 | Kansas City | Missouri | 83614 | 1008 | |
2084667 | 2084667 | 2022-01-05 | Joplin | Missouri | 10020 | 191 | |
2084668 | 2084668 | 2022-01-05 | Kansas City | Missouri | 82240 | 1006 | |
2081415 | 2081415 | 2022-01-04 | Joplin | Missouri | 9939 | 190 | |
2081416 | 2081416 | 2022-01-04 | Kansas City | Missouri | 81006 | 1005 | |
2078163 | 2078163 | 2022-01-03 | Joplin | Missouri | 9849 | 189 | |
2078164 | 2078164 | 2022-01-03 | Kansas City | Missouri | 80274 | 1000 | |
2074912 | 2074912 | 2022-01-02 | Joplin | Missouri | 9723 | 189 | |
2074913 | 2074913 | 2022-01-02 | Kansas City | Missouri | 76832 | 1000 | |
2071661 | 2071661 | 2022-01-01 | Joplin | Missouri | 9723 | 189 | |
2071662 | 2071662 | 2022-01-01 | Kansas City | Missouri | 76832 | 1000 | |
2068410 | 2068410 | 2021-12-31 | Joplin | Missouri | 9723 | 189 | |
2068411 | 2068411 | 2021-12-31 | Kansas City | Missouri | 76832 | 1000 | |
2065159 | 2065159 | 2021-12-30 | Joplin | Missouri | 9723 | 189 | |
2065160 | 2065160 | 2021-12-30 | Kansas City | Missouri | 76832 | 1000 | |
2061909 | 2061909 | 2021-12-29 | Joplin | Missouri | 9671 | 189 | |
2061910 | 2061910 | 2021-12-29 | Kansas City | Missouri | 76014 | 1004 | |
2058660 | 2058660 | 2021-12-28 | Joplin | Missouri | 9650 | 189 | |
2058661 | 2058661 | 2021-12-28 | Kansas City | Missouri | 75393 | 1003 | |
2055411 | 2055411 | 2021-12-27 | Joplin | Missouri | 9622 | 189 | |
2055412 | 2055412 | 2021-12-27 | Kansas City | Missouri | 74964 | 997 | |
2052161 | 2052161 | 2021-12-26 | Joplin | Missouri | 9570 | 189 | |
2052162 | 2052162 | 2021-12-26 | Kansas City | Missouri | 73948 | 996 | |
2048911 | 2048911 | 2021-12-25 | Joplin | Missouri | 9570 | 189 | |
2048912 | 2048912 | 2021-12-25 | Kansas City | Missouri | 73948 | 996 | |
2045661 | 2045661 | 2021-12-24 | Joplin | Missouri | 9570 | 189 | |
2045662 | 2045662 | 2021-12-24 | Kansas City | Missouri | 73948 | 996 | |
2042411 | 2042411 | 2021-12-23 | Joplin | Missouri | 9570 | 189 | |
2042412 | 2042412 | 2021-12-23 | Kansas City | Missouri | 73948 | 996 | |
2039162 | 2039162 | 2021-12-22 | Joplin | Missouri | 9543 | 188 | |
2039163 | 2039163 | 2021-12-22 | Kansas City | Missouri | 73301 | 993 | |
2035912 | 2035912 | 2021-12-21 | Joplin | Missouri | 9520 | 188 | |
2035913 | 2035913 | 2021-12-21 | Kansas City | Missouri | 73015 | 989 | |
2032662 | 2032662 | 2021-12-20 | Joplin | Missouri | 9503 | 188 | |
2032663 | 2032663 | 2021-12-20 | Kansas City | Missouri | 72855 | 982 | |
2029411 | 2029411 | 2021-12-19 | Joplin | Missouri | 9493 | 188 | |
2029412 | 2029412 | 2021-12-19 | Kansas City | Missouri | 72616 | 982 | |
2026160 | 2026160 | 2021-12-18 | Joplin | Missouri | 9482 | 188 | |
2026161 | 2026161 | 2021-12-18 | Kansas City | Missouri | 72393 | 982 | |
2022909 | 2022909 | 2021-12-17 | Joplin | Missouri | 9465 | 186 | |
2022910 | 2022910 | 2021-12-17 | Kansas City | Missouri | 72098 | 982 | |
2019658 | 2019658 | 2021-12-16 | Joplin | Missouri | 9444 | 186 | |
2019659 | 2019659 | 2021-12-16 | Kansas City | Missouri | 71802 | 982 | |
2016408 | 2016408 | 2021-12-15 | Joplin | Missouri | 9422 | 186 | |
2016409 | 2016409 | 2021-12-15 | Kansas City | Missouri | 71381 | 982 | |
2013157 | 2013157 | 2021-12-14 | Joplin | Missouri | 9396 | 186 | |
2013158 | 2013158 | 2021-12-14 | Kansas City | Missouri | 71117 | 977 | |
2009906 | 2009906 | 2021-12-13 | Joplin | Missouri | 9381 | 186 | |
2009907 | 2009907 | 2021-12-13 | Kansas City | Missouri | 70957 | 967 | |
2006655 | 2006655 | 2021-12-12 | Joplin | Missouri | 9368 | 186 | |
2006656 | 2006656 | 2021-12-12 | Kansas City | Missouri | 70838 | 967 | |
2003404 | 2003404 | 2021-12-11 | Joplin | Missouri | 9347 | 186 | |
2003405 | 2003405 | 2021-12-11 | Kansas City | Missouri | 70605 | 967 | |
2000154 | 2000154 | 2021-12-10 | Joplin | Missouri | 9333 | 186 | |
2000155 | 2000155 | 2021-12-10 | Kansas City | Missouri | 70346 | 966 | |
1996903 | 1996903 | 2021-12-09 | Joplin | Missouri | 9318 | 186 | |
1996904 | 1996904 | 2021-12-09 | Kansas City | Missouri | 70033 | 964 | |
1993652 | 1993652 | 2021-12-08 | Joplin | Missouri | 9298 | 186 | |
1993653 | 1993653 | 2021-12-08 | Kansas City | Missouri | 69727 | 954 | |
1990401 | 1990401 | 2021-12-07 | Joplin | Missouri | 9267 | 186 | |
1990402 | 1990402 | 2021-12-07 | Kansas City | Missouri | 69353 | 954 | |
1987151 | 1987151 | 2021-12-06 | Joplin | Missouri | 9252 | 186 | |
1987152 | 1987152 | 2021-12-06 | Kansas City | Missouri | 69178 | 952 | |
1983901 | 1983901 | 2021-12-05 | Joplin | Missouri | 9228 | 186 | |
1983902 | 1983902 | 2021-12-05 | Kansas City | Missouri | 68811 | 952 | |
1980651 | 1980651 | 2021-12-04 | Joplin | Missouri | 9207 | 186 | |
1980652 | 1980652 | 2021-12-04 | Kansas City | Missouri | 68721 | 952 | |
1977401 | 1977401 | 2021-12-03 | Joplin | Missouri | 9181 | 185 | |
1977402 | 1977402 | 2021-12-03 | Kansas City | Missouri | 68146 | 952 | |
1974151 | 1974151 | 2021-12-02 | Joplin | Missouri | 9181 | 185 | |
1974152 | 1974152 | 2021-12-02 | Kansas City | Missouri | 68146 | 952 | |
1970902 | 1970902 | 2021-12-01 | Joplin | Missouri | 9158 | 185 | |
1970903 | 1970903 | 2021-12-01 | Kansas City | Missouri | 67899 | 952 | |
1967652 | 1967652 | 2021-11-30 | Joplin | Missouri | 9133 | 185 | |
1967653 | 1967653 | 2021-11-30 | Kansas City | Missouri | 67668 | 951 | |
1964400 | 1964400 | 2021-11-29 | Joplin | Missouri | 9120 | 184 | |
1964401 | 1964401 | 2021-11-29 | Kansas City | Missouri | 67493 | 948 | |
1961149 | 1961149 | 2021-11-28 | Joplin | Missouri | 9074 | 184 | |
1961150 | 1961150 | 2021-11-28 | Kansas City | Missouri | 66830 | 948 | |
1957898 | 1957898 | 2021-11-27 | Joplin | Missouri | 9074 | 184 | |
1957899 | 1957899 | 2021-11-27 | Kansas City | Missouri | 66830 | 948 | |
1954647 | 1954647 | 2021-11-26 | Joplin | Missouri | 9074 | 184 | |
1954648 | 1954648 | 2021-11-26 | Kansas City | Missouri | 66830 | 948 | |
1951396 | 1951396 | 2021-11-25 | Joplin | Missouri | 9074 | 184 | |
1951397 | 1951397 | 2021-11-25 | Kansas City | Missouri | 66830 | 948 |
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);