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 |
---|---|---|---|---|---|---|---|
2175749 | 2175749 | 2022-02-02 | Lawrence | Missouri | 29109 | 7380 | 146 |
2172496 | 2172496 | 2022-02-01 | Lawrence | Missouri | 29109 | 7315 | 145 |
2169243 | 2169243 | 2022-01-31 | Lawrence | Missouri | 29109 | 7290 | 143 |
2165988 | 2165988 | 2022-01-30 | Lawrence | Missouri | 29109 | 7272 | 143 |
2162733 | 2162733 | 2022-01-29 | Lawrence | Missouri | 29109 | 7218 | 143 |
2159478 | 2159478 | 2022-01-28 | Lawrence | Missouri | 29109 | 7163 | 143 |
2156224 | 2156224 | 2022-01-27 | Lawrence | Missouri | 29109 | 7114 | 143 |
2152971 | 2152971 | 2022-01-26 | Lawrence | Missouri | 29109 | 7078 | 143 |
2149719 | 2149719 | 2022-01-25 | Lawrence | Missouri | 29109 | 6991 | 143 |
2146467 | 2146467 | 2022-01-24 | Lawrence | Missouri | 29109 | 6961 | 143 |
2143212 | 2143212 | 2022-01-23 | Lawrence | Missouri | 29109 | 6912 | 143 |
2139957 | 2139957 | 2022-01-22 | Lawrence | Missouri | 29109 | 6849 | 143 |
2136701 | 2136701 | 2022-01-21 | Lawrence | Missouri | 29109 | 6769 | 143 |
2133449 | 2133449 | 2022-01-20 | Lawrence | Missouri | 29109 | 6623 | 142 |
2130196 | 2130196 | 2022-01-19 | Lawrence | Missouri | 29109 | 6531 | 142 |
2126942 | 2126942 | 2022-01-18 | Lawrence | Missouri | 29109 | 6450 | 141 |
2123690 | 2123690 | 2022-01-17 | Lawrence | Missouri | 29109 | 6312 | 141 |
2120438 | 2120438 | 2022-01-16 | Lawrence | Missouri | 29109 | 6312 | 141 |
2117186 | 2117186 | 2022-01-15 | Lawrence | Missouri | 29109 | 6311 | 141 |
2113935 | 2113935 | 2022-01-14 | Lawrence | Missouri | 29109 | 6231 | 141 |
2110683 | 2110683 | 2022-01-13 | Lawrence | Missouri | 29109 | 6176 | 141 |
2107432 | 2107432 | 2022-01-12 | Lawrence | Missouri | 29109 | 6136 | 141 |
2104181 | 2104181 | 2022-01-11 | Lawrence | Missouri | 29109 | 6091 | 141 |
2100930 | 2100930 | 2022-01-10 | Lawrence | Missouri | 29109 | 6069 | 140 |
2097679 | 2097679 | 2022-01-09 | Lawrence | Missouri | 29109 | 6041 | 140 |
2094427 | 2094427 | 2022-01-08 | Lawrence | Missouri | 29109 | 6010 | 140 |
2091175 | 2091175 | 2022-01-07 | Lawrence | Missouri | 29109 | 5977 | 140 |
2087924 | 2087924 | 2022-01-06 | Lawrence | Missouri | 29109 | 5950 | 140 |
2084672 | 2084672 | 2022-01-05 | Lawrence | Missouri | 29109 | 5936 | 140 |
2081420 | 2081420 | 2022-01-04 | Lawrence | Missouri | 29109 | 5904 | 140 |
2078168 | 2078168 | 2022-01-03 | Lawrence | Missouri | 29109 | 5887 | 139 |
2074917 | 2074917 | 2022-01-02 | Lawrence | Missouri | 29109 | 5820 | 139 |
2071666 | 2071666 | 2022-01-01 | Lawrence | Missouri | 29109 | 5820 | 139 |
2068415 | 2068415 | 2021-12-31 | Lawrence | Missouri | 29109 | 5820 | 139 |
2065164 | 2065164 | 2021-12-30 | Lawrence | Missouri | 29109 | 5820 | 139 |
2061914 | 2061914 | 2021-12-29 | Lawrence | Missouri | 29109 | 5770 | 139 |
2058665 | 2058665 | 2021-12-28 | Lawrence | Missouri | 29109 | 5758 | 139 |
2055416 | 2055416 | 2021-12-27 | Lawrence | Missouri | 29109 | 5748 | 138 |
2052166 | 2052166 | 2021-12-26 | Lawrence | Missouri | 29109 | 5708 | 138 |
2048916 | 2048916 | 2021-12-25 | Lawrence | Missouri | 29109 | 5708 | 138 |
2045666 | 2045666 | 2021-12-24 | Lawrence | Missouri | 29109 | 5708 | 138 |
2042416 | 2042416 | 2021-12-23 | Lawrence | Missouri | 29109 | 5708 | 138 |
2039167 | 2039167 | 2021-12-22 | Lawrence | Missouri | 29109 | 5675 | 138 |
2035917 | 2035917 | 2021-12-21 | Lawrence | Missouri | 29109 | 5668 | 138 |
2032667 | 2032667 | 2021-12-20 | Lawrence | Missouri | 29109 | 5658 | 137 |
2029416 | 2029416 | 2021-12-19 | Lawrence | Missouri | 29109 | 5651 | 137 |
2026165 | 2026165 | 2021-12-18 | Lawrence | Missouri | 29109 | 5643 | 137 |
2022914 | 2022914 | 2021-12-17 | Lawrence | Missouri | 29109 | 5629 | 137 |
2019663 | 2019663 | 2021-12-16 | Lawrence | Missouri | 29109 | 5607 | 137 |
2016413 | 2016413 | 2021-12-15 | Lawrence | Missouri | 29109 | 5592 | 137 |
2013162 | 2013162 | 2021-12-14 | Lawrence | Missouri | 29109 | 5580 | 137 |
2009911 | 2009911 | 2021-12-13 | Lawrence | Missouri | 29109 | 5570 | 137 |
2006660 | 2006660 | 2021-12-12 | Lawrence | Missouri | 29109 | 5563 | 137 |
2003409 | 2003409 | 2021-12-11 | Lawrence | Missouri | 29109 | 5547 | 137 |
2000159 | 2000159 | 2021-12-10 | Lawrence | Missouri | 29109 | 5537 | 137 |
1996908 | 1996908 | 2021-12-09 | Lawrence | Missouri | 29109 | 5509 | 137 |
1993657 | 1993657 | 2021-12-08 | Lawrence | Missouri | 29109 | 5499 | 137 |
1990406 | 1990406 | 2021-12-07 | Lawrence | Missouri | 29109 | 5482 | 138 |
1987156 | 1987156 | 2021-12-06 | Lawrence | Missouri | 29109 | 5466 | 136 |
1983906 | 1983906 | 2021-12-05 | Lawrence | Missouri | 29109 | 5453 | 136 |
1980656 | 1980656 | 2021-12-04 | Lawrence | Missouri | 29109 | 5444 | 136 |
1977406 | 1977406 | 2021-12-03 | Lawrence | Missouri | 29109 | 5432 | 136 |
1974156 | 1974156 | 2021-12-02 | Lawrence | Missouri | 29109 | 5432 | 136 |
1970907 | 1970907 | 2021-12-01 | Lawrence | Missouri | 29109 | 5421 | 136 |
1967657 | 1967657 | 2021-11-30 | Lawrence | Missouri | 29109 | 5408 | 136 |
1964405 | 1964405 | 2021-11-29 | Lawrence | Missouri | 29109 | 5395 | 136 |
1961154 | 1961154 | 2021-11-28 | Lawrence | Missouri | 29109 | 5352 | 136 |
1957903 | 1957903 | 2021-11-27 | Lawrence | Missouri | 29109 | 5352 | 136 |
1954652 | 1954652 | 2021-11-26 | Lawrence | Missouri | 29109 | 5352 | 136 |
1951401 | 1951401 | 2021-11-25 | Lawrence | Missouri | 29109 | 5352 | 136 |
1948150 | 1948150 | 2021-11-24 | Lawrence | Missouri | 29109 | 5352 | 136 |
1944899 | 1944899 | 2021-11-23 | Lawrence | Missouri | 29109 | 5343 | 136 |
1941648 | 1941648 | 2021-11-22 | Lawrence | Missouri | 29109 | 5339 | 136 |
1938398 | 1938398 | 2021-11-21 | Lawrence | Missouri | 29109 | 5335 | 137 |
1935148 | 1935148 | 2021-11-20 | Lawrence | Missouri | 29109 | 5335 | 137 |
1931898 | 1931898 | 2021-11-19 | Lawrence | Missouri | 29109 | 5326 | 137 |
1928647 | 1928647 | 2021-11-18 | Lawrence | Missouri | 29109 | 5322 | 136 |
1925397 | 1925397 | 2021-11-17 | Lawrence | Missouri | 29109 | 5260 | 110 |
1922148 | 1922148 | 2021-11-16 | Lawrence | Missouri | 29109 | 5260 | 110 |
1918898 | 1918898 | 2021-11-15 | Lawrence | Missouri | 29109 | 5251 | 107 |
1915648 | 1915648 | 2021-11-14 | Lawrence | Missouri | 29109 | 5249 | 107 |
1912398 | 1912398 | 2021-11-13 | Lawrence | Missouri | 29109 | 5246 | 107 |
1909148 | 1909148 | 2021-11-12 | Lawrence | Missouri | 29109 | 5236 | 107 |
1905899 | 1905899 | 2021-11-11 | Lawrence | Missouri | 29109 | 5234 | 107 |
1902650 | 1902650 | 2021-11-10 | Lawrence | Missouri | 29109 | 5234 | 107 |
1899400 | 1899400 | 2021-11-09 | Lawrence | Missouri | 29109 | 5232 | 107 |
1896150 | 1896150 | 2021-11-08 | Lawrence | Missouri | 29109 | 5225 | 107 |
1892900 | 1892900 | 2021-11-07 | Lawrence | Missouri | 29109 | 5223 | 107 |
1889650 | 1889650 | 2021-11-06 | Lawrence | Missouri | 29109 | 5223 | 107 |
1886400 | 1886400 | 2021-11-05 | Lawrence | Missouri | 29109 | 5214 | 107 |
1883151 | 1883151 | 2021-11-04 | Lawrence | Missouri | 29109 | 5209 | 107 |
1879902 | 1879902 | 2021-11-03 | Lawrence | Missouri | 29109 | 5206 | 106 |
1876653 | 1876653 | 2021-11-02 | Lawrence | Missouri | 29109 | 5202 | 106 |
1873404 | 1873404 | 2021-11-01 | Lawrence | Missouri | 29109 | 5201 | 103 |
1870155 | 1870155 | 2021-10-31 | Lawrence | Missouri | 29109 | 5200 | 103 |
1866906 | 1866906 | 2021-10-30 | Lawrence | Missouri | 29109 | 5200 | 103 |
1863657 | 1863657 | 2021-10-29 | Lawrence | Missouri | 29109 | 5195 | 104 |
1860408 | 1860408 | 2021-10-28 | Lawrence | Missouri | 29109 | 5189 | 104 |
1857159 | 1857159 | 2021-10-27 | Lawrence | Missouri | 29109 | 5187 | 104 |
1853910 | 1853910 | 2021-10-26 | Lawrence | Missouri | 29109 | 5182 | 104 |
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);