ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lincoln" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501134 | 2501134 | 2022-05-13 | Lincoln | Missouri | 29113 | 15187 | 138 |
2497876 | 2497876 | 2022-05-12 | Lincoln | Missouri | 29113 | 15152 | 138 |
2494618 | 2494618 | 2022-05-11 | Lincoln | Missouri | 29113 | 15152 | 138 |
2491360 | 2491360 | 2022-05-10 | Lincoln | Missouri | 29113 | 15152 | 138 |
2488102 | 2488102 | 2022-05-09 | Lincoln | Missouri | 29113 | 15152 | 138 |
2484845 | 2484845 | 2022-05-08 | Lincoln | Missouri | 29113 | 15152 | 138 |
2481587 | 2481587 | 2022-05-07 | Lincoln | Missouri | 29113 | 15152 | 138 |
2478329 | 2478329 | 2022-05-06 | Lincoln | Missouri | 29113 | 15152 | 138 |
2475071 | 2475071 | 2022-05-05 | Lincoln | Missouri | 29113 | 15127 | 138 |
2471814 | 2471814 | 2022-05-04 | Lincoln | Missouri | 29113 | 15127 | 137 |
2468558 | 2468558 | 2022-05-03 | Lincoln | Missouri | 29113 | 15127 | 137 |
2465302 | 2465302 | 2022-05-02 | Lincoln | Missouri | 29113 | 15127 | 137 |
2462047 | 2462047 | 2022-05-01 | Lincoln | Missouri | 29113 | 15127 | 137 |
2458791 | 2458791 | 2022-04-30 | Lincoln | Missouri | 29113 | 15127 | 137 |
2455535 | 2455535 | 2022-04-29 | Lincoln | Missouri | 29113 | 15127 | 137 |
2452279 | 2452279 | 2022-04-28 | Lincoln | Missouri | 29113 | 15127 | 137 |
2449023 | 2449023 | 2022-04-27 | Lincoln | Missouri | 29113 | 15127 | 137 |
2445766 | 2445766 | 2022-04-26 | Lincoln | Missouri | 29113 | 15127 | 137 |
2442511 | 2442511 | 2022-04-25 | Lincoln | Missouri | 29113 | 15127 | 137 |
2439255 | 2439255 | 2022-04-24 | Lincoln | Missouri | 29113 | 15127 | 137 |
2435999 | 2435999 | 2022-04-23 | Lincoln | Missouri | 29113 | 15127 | 137 |
2432743 | 2432743 | 2022-04-22 | Lincoln | Missouri | 29113 | 15127 | 137 |
2429487 | 2429487 | 2022-04-21 | Lincoln | Missouri | 29113 | 15127 | 137 |
2426231 | 2426231 | 2022-04-20 | Lincoln | Missouri | 29113 | 15127 | 137 |
2422975 | 2422975 | 2022-04-19 | Lincoln | Missouri | 29113 | 15127 | 137 |
2419718 | 2419718 | 2022-04-18 | Lincoln | Missouri | 29113 | 15127 | 137 |
2416463 | 2416463 | 2022-04-17 | Lincoln | Missouri | 29113 | 15127 | 137 |
2413207 | 2413207 | 2022-04-16 | Lincoln | Missouri | 29113 | 15127 | 137 |
2409951 | 2409951 | 2022-04-15 | Lincoln | Missouri | 29113 | 15127 | 137 |
2406695 | 2406695 | 2022-04-14 | Lincoln | Missouri | 29113 | 15127 | 137 |
2403439 | 2403439 | 2022-04-13 | Lincoln | Missouri | 29113 | 15127 | 137 |
2400184 | 2400184 | 2022-04-12 | Lincoln | Missouri | 29113 | 15127 | 137 |
2396929 | 2396929 | 2022-04-11 | Lincoln | Missouri | 29113 | 15127 | 137 |
2393674 | 2393674 | 2022-04-10 | Lincoln | Missouri | 29113 | 15127 | 137 |
2390418 | 2390418 | 2022-04-09 | Lincoln | Missouri | 29113 | 15127 | 137 |
2387162 | 2387162 | 2022-04-08 | Lincoln | Missouri | 29113 | 15127 | 137 |
2383907 | 2383907 | 2022-04-07 | Lincoln | Missouri | 29113 | 15127 | 137 |
2380652 | 2380652 | 2022-04-06 | Lincoln | Missouri | 29113 | 15127 | 137 |
2377397 | 2377397 | 2022-04-05 | Lincoln | Missouri | 29113 | 15127 | 137 |
2374144 | 2374144 | 2022-04-04 | Lincoln | Missouri | 29113 | 15127 | 137 |
2370892 | 2370892 | 2022-04-03 | Lincoln | Missouri | 29113 | 15127 | 137 |
2367639 | 2367639 | 2022-04-02 | Lincoln | Missouri | 29113 | 15127 | 137 |
2364386 | 2364386 | 2022-04-01 | Lincoln | Missouri | 29113 | 15127 | 137 |
2361132 | 2361132 | 2022-03-31 | Lincoln | Missouri | 29113 | 15127 | 137 |
2357878 | 2357878 | 2022-03-30 | Lincoln | Missouri | 29113 | 15127 | 137 |
2354625 | 2354625 | 2022-03-29 | Lincoln | Missouri | 29113 | 15126 | 137 |
2351372 | 2351372 | 2022-03-28 | Lincoln | Missouri | 29113 | 15125 | 136 |
2348120 | 2348120 | 2022-03-27 | Lincoln | Missouri | 29113 | 15125 | 136 |
2344867 | 2344867 | 2022-03-26 | Lincoln | Missouri | 29113 | 15125 | 136 |
2341614 | 2341614 | 2022-03-25 | Lincoln | Missouri | 29113 | 15125 | 136 |
2338361 | 2338361 | 2022-03-24 | Lincoln | Missouri | 29113 | 15123 | 136 |
2335107 | 2335107 | 2022-03-23 | Lincoln | Missouri | 29113 | 15117 | 136 |
2331853 | 2331853 | 2022-03-22 | Lincoln | Missouri | 29113 | 15116 | 136 |
2328600 | 2328600 | 2022-03-21 | Lincoln | Missouri | 29113 | 15110 | 136 |
2325348 | 2325348 | 2022-03-20 | Lincoln | Missouri | 29113 | 15109 | 136 |
2322094 | 2322094 | 2022-03-19 | Lincoln | Missouri | 29113 | 15109 | 136 |
2318840 | 2318840 | 2022-03-18 | Lincoln | Missouri | 29113 | 15109 | 136 |
2315587 | 2315587 | 2022-03-17 | Lincoln | Missouri | 29113 | 15108 | 136 |
2312334 | 2312334 | 2022-03-16 | Lincoln | Missouri | 29113 | 15104 | 136 |
2309081 | 2309081 | 2022-03-15 | Lincoln | Missouri | 29113 | 15102 | 136 |
2305829 | 2305829 | 2022-03-14 | Lincoln | Missouri | 29113 | 15097 | 133 |
2302578 | 2302578 | 2022-03-13 | Lincoln | Missouri | 29113 | 15092 | 133 |
2299326 | 2299326 | 2022-03-12 | Lincoln | Missouri | 29113 | 15092 | 133 |
2296074 | 2296074 | 2022-03-11 | Lincoln | Missouri | 29113 | 15092 | 133 |
2292822 | 2292822 | 2022-03-10 | Lincoln | Missouri | 29113 | 15090 | 133 |
2289570 | 2289570 | 2022-03-09 | Lincoln | Missouri | 29113 | 15085 | 133 |
2286318 | 2286318 | 2022-03-08 | Lincoln | Missouri | 29113 | 15082 | 133 |
2283066 | 2283066 | 2022-03-07 | Lincoln | Missouri | 29113 | 15079 | 130 |
2279813 | 2279813 | 2022-03-06 | Lincoln | Missouri | 29113 | 15076 | 130 |
2276560 | 2276560 | 2022-03-05 | Lincoln | Missouri | 29113 | 15076 | 130 |
2273307 | 2273307 | 2022-03-04 | Lincoln | Missouri | 29113 | 15076 | 130 |
2270055 | 2270055 | 2022-03-03 | Lincoln | Missouri | 29113 | 15071 | 129 |
2266802 | 2266802 | 2022-03-02 | Lincoln | Missouri | 29113 | 15065 | 128 |
2263551 | 2263551 | 2022-03-01 | Lincoln | Missouri | 29113 | 15062 | 128 |
2260300 | 2260300 | 2022-02-28 | Lincoln | Missouri | 29113 | 15057 | 126 |
2257049 | 2257049 | 2022-02-27 | Lincoln | Missouri | 29113 | 15047 | 126 |
2253798 | 2253798 | 2022-02-26 | Lincoln | Missouri | 29113 | 15047 | 126 |
2250547 | 2250547 | 2022-02-25 | Lincoln | Missouri | 29113 | 15047 | 126 |
2247296 | 2247296 | 2022-02-24 | Lincoln | Missouri | 29113 | 15046 | 126 |
2244045 | 2244045 | 2022-02-23 | Lincoln | Missouri | 29113 | 15038 | 124 |
2240794 | 2240794 | 2022-02-22 | Lincoln | Missouri | 29113 | 15033 | 124 |
2237543 | 2237543 | 2022-02-21 | Lincoln | Missouri | 29113 | 15004 | 124 |
2234292 | 2234292 | 2022-02-20 | Lincoln | Missouri | 29113 | 15004 | 124 |
2231041 | 2231041 | 2022-02-19 | Lincoln | Missouri | 29113 | 15004 | 124 |
2227790 | 2227790 | 2022-02-18 | Lincoln | Missouri | 29113 | 15004 | 124 |
2224539 | 2224539 | 2022-02-17 | Lincoln | Missouri | 29113 | 14992 | 124 |
2221288 | 2221288 | 2022-02-16 | Lincoln | Missouri | 29113 | 14975 | 123 |
2218037 | 2218037 | 2022-02-15 | Lincoln | Missouri | 29113 | 14960 | 123 |
2214786 | 2214786 | 2022-02-14 | Lincoln | Missouri | 29113 | 14948 | 121 |
2211534 | 2211534 | 2022-02-13 | Lincoln | Missouri | 29113 | 14899 | 121 |
2208281 | 2208281 | 2022-02-12 | Lincoln | Missouri | 29113 | 14899 | 121 |
2205028 | 2205028 | 2022-02-11 | Lincoln | Missouri | 29113 | 14899 | 121 |
2201775 | 2201775 | 2022-02-10 | Lincoln | Missouri | 29113 | 14899 | 121 |
2198521 | 2198521 | 2022-02-09 | Lincoln | Missouri | 29113 | 14868 | 118 |
2195267 | 2195267 | 2022-02-08 | Lincoln | Missouri | 29113 | 14838 | 118 |
2192013 | 2192013 | 2022-02-07 | Lincoln | Missouri | 29113 | 14820 | 111 |
2188760 | 2188760 | 2022-02-06 | Lincoln | Missouri | 29113 | 14808 | 111 |
2185507 | 2185507 | 2022-02-05 | Lincoln | Missouri | 29113 | 14790 | 111 |
2182255 | 2182255 | 2022-02-04 | Lincoln | Missouri | 29113 | 14759 | 111 |
2179003 | 2179003 | 2022-02-03 | Lincoln | Missouri | 29113 | 14751 | 111 |
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);