ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
735 rows where county = "Laclede", fips = 29105 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501130 | 2501130 | 2022-05-13 | Laclede | Missouri | 29105 | 8096 | 176 |
2497872 | 2497872 | 2022-05-12 | Laclede | Missouri | 29105 | 8089 | 176 |
2494614 | 2494614 | 2022-05-11 | Laclede | Missouri | 29105 | 8089 | 176 |
2491356 | 2491356 | 2022-05-10 | Laclede | Missouri | 29105 | 8089 | 176 |
2488098 | 2488098 | 2022-05-09 | Laclede | Missouri | 29105 | 8089 | 176 |
2484841 | 2484841 | 2022-05-08 | Laclede | Missouri | 29105 | 8089 | 176 |
2481583 | 2481583 | 2022-05-07 | Laclede | Missouri | 29105 | 8089 | 176 |
2478325 | 2478325 | 2022-05-06 | Laclede | Missouri | 29105 | 8089 | 176 |
2475067 | 2475067 | 2022-05-05 | Laclede | Missouri | 29105 | 8102 | 176 |
2471810 | 2471810 | 2022-05-04 | Laclede | Missouri | 29105 | 8102 | 175 |
2468554 | 2468554 | 2022-05-03 | Laclede | Missouri | 29105 | 8102 | 175 |
2465298 | 2465298 | 2022-05-02 | Laclede | Missouri | 29105 | 8102 | 175 |
2462043 | 2462043 | 2022-05-01 | Laclede | Missouri | 29105 | 8102 | 175 |
2458787 | 2458787 | 2022-04-30 | Laclede | Missouri | 29105 | 8102 | 175 |
2455531 | 2455531 | 2022-04-29 | Laclede | Missouri | 29105 | 8102 | 175 |
2452275 | 2452275 | 2022-04-28 | Laclede | Missouri | 29105 | 8102 | 175 |
2449019 | 2449019 | 2022-04-27 | Laclede | Missouri | 29105 | 8102 | 175 |
2445762 | 2445762 | 2022-04-26 | Laclede | Missouri | 29105 | 8102 | 175 |
2442507 | 2442507 | 2022-04-25 | Laclede | Missouri | 29105 | 8102 | 175 |
2439251 | 2439251 | 2022-04-24 | Laclede | Missouri | 29105 | 8102 | 175 |
2435995 | 2435995 | 2022-04-23 | Laclede | Missouri | 29105 | 8102 | 175 |
2432739 | 2432739 | 2022-04-22 | Laclede | Missouri | 29105 | 8102 | 175 |
2429483 | 2429483 | 2022-04-21 | Laclede | Missouri | 29105 | 8102 | 175 |
2426227 | 2426227 | 2022-04-20 | Laclede | Missouri | 29105 | 8102 | 175 |
2422971 | 2422971 | 2022-04-19 | Laclede | Missouri | 29105 | 8102 | 175 |
2419714 | 2419714 | 2022-04-18 | Laclede | Missouri | 29105 | 8102 | 175 |
2416459 | 2416459 | 2022-04-17 | Laclede | Missouri | 29105 | 8102 | 175 |
2413203 | 2413203 | 2022-04-16 | Laclede | Missouri | 29105 | 8102 | 175 |
2409947 | 2409947 | 2022-04-15 | Laclede | Missouri | 29105 | 8102 | 175 |
2406691 | 2406691 | 2022-04-14 | Laclede | Missouri | 29105 | 8102 | 175 |
2403435 | 2403435 | 2022-04-13 | Laclede | Missouri | 29105 | 8102 | 175 |
2400180 | 2400180 | 2022-04-12 | Laclede | Missouri | 29105 | 8102 | 175 |
2396925 | 2396925 | 2022-04-11 | Laclede | Missouri | 29105 | 8102 | 175 |
2393670 | 2393670 | 2022-04-10 | Laclede | Missouri | 29105 | 8102 | 175 |
2390414 | 2390414 | 2022-04-09 | Laclede | Missouri | 29105 | 8102 | 175 |
2387158 | 2387158 | 2022-04-08 | Laclede | Missouri | 29105 | 8102 | 175 |
2383903 | 2383903 | 2022-04-07 | Laclede | Missouri | 29105 | 8102 | 175 |
2380648 | 2380648 | 2022-04-06 | Laclede | Missouri | 29105 | 8102 | 175 |
2377393 | 2377393 | 2022-04-05 | Laclede | Missouri | 29105 | 8102 | 175 |
2374140 | 2374140 | 2022-04-04 | Laclede | Missouri | 29105 | 8102 | 175 |
2370888 | 2370888 | 2022-04-03 | Laclede | Missouri | 29105 | 8102 | 175 |
2367635 | 2367635 | 2022-04-02 | Laclede | Missouri | 29105 | 8102 | 175 |
2364382 | 2364382 | 2022-04-01 | Laclede | Missouri | 29105 | 8102 | 175 |
2361128 | 2361128 | 2022-03-31 | Laclede | Missouri | 29105 | 8102 | 175 |
2357874 | 2357874 | 2022-03-30 | Laclede | Missouri | 29105 | 8097 | 175 |
2354621 | 2354621 | 2022-03-29 | Laclede | Missouri | 29105 | 8097 | 175 |
2351368 | 2351368 | 2022-03-28 | Laclede | Missouri | 29105 | 8097 | 174 |
2348116 | 2348116 | 2022-03-27 | Laclede | Missouri | 29105 | 8095 | 174 |
2344863 | 2344863 | 2022-03-26 | Laclede | Missouri | 29105 | 8095 | 174 |
2341610 | 2341610 | 2022-03-25 | Laclede | Missouri | 29105 | 8095 | 174 |
2338357 | 2338357 | 2022-03-24 | Laclede | Missouri | 29105 | 8095 | 174 |
2335103 | 2335103 | 2022-03-23 | Laclede | Missouri | 29105 | 8092 | 174 |
2331849 | 2331849 | 2022-03-22 | Laclede | Missouri | 29105 | 8092 | 174 |
2328596 | 2328596 | 2022-03-21 | Laclede | Missouri | 29105 | 8090 | 174 |
2325344 | 2325344 | 2022-03-20 | Laclede | Missouri | 29105 | 8087 | 174 |
2322090 | 2322090 | 2022-03-19 | Laclede | Missouri | 29105 | 8087 | 174 |
2318836 | 2318836 | 2022-03-18 | Laclede | Missouri | 29105 | 8087 | 174 |
2315583 | 2315583 | 2022-03-17 | Laclede | Missouri | 29105 | 8085 | 174 |
2312330 | 2312330 | 2022-03-16 | Laclede | Missouri | 29105 | 8087 | 174 |
2309077 | 2309077 | 2022-03-15 | Laclede | Missouri | 29105 | 8083 | 174 |
2305825 | 2305825 | 2022-03-14 | Laclede | Missouri | 29105 | 8083 | 170 |
2302574 | 2302574 | 2022-03-13 | Laclede | Missouri | 29105 | 8081 | 170 |
2299322 | 2299322 | 2022-03-12 | Laclede | Missouri | 29105 | 8081 | 170 |
2296070 | 2296070 | 2022-03-11 | Laclede | Missouri | 29105 | 8081 | 170 |
2292818 | 2292818 | 2022-03-10 | Laclede | Missouri | 29105 | 8079 | 170 |
2289566 | 2289566 | 2022-03-09 | Laclede | Missouri | 29105 | 8077 | 170 |
2286314 | 2286314 | 2022-03-08 | Laclede | Missouri | 29105 | 8076 | 170 |
2283062 | 2283062 | 2022-03-07 | Laclede | Missouri | 29105 | 8071 | 168 |
2279809 | 2279809 | 2022-03-06 | Laclede | Missouri | 29105 | 8070 | 168 |
2276556 | 2276556 | 2022-03-05 | Laclede | Missouri | 29105 | 8070 | 168 |
2273303 | 2273303 | 2022-03-04 | Laclede | Missouri | 29105 | 8070 | 168 |
2270051 | 2270051 | 2022-03-03 | Laclede | Missouri | 29105 | 8065 | 167 |
2266798 | 2266798 | 2022-03-02 | Laclede | Missouri | 29105 | 8063 | 167 |
2263547 | 2263547 | 2022-03-01 | Laclede | Missouri | 29105 | 8058 | 167 |
2260296 | 2260296 | 2022-02-28 | Laclede | Missouri | 29105 | 8056 | 166 |
2257045 | 2257045 | 2022-02-27 | Laclede | Missouri | 29105 | 8046 | 166 |
2253794 | 2253794 | 2022-02-26 | Laclede | Missouri | 29105 | 8046 | 166 |
2250543 | 2250543 | 2022-02-25 | Laclede | Missouri | 29105 | 8046 | 166 |
2247292 | 2247292 | 2022-02-24 | Laclede | Missouri | 29105 | 8045 | 166 |
2244041 | 2244041 | 2022-02-23 | Laclede | Missouri | 29105 | 8032 | 163 |
2240790 | 2240790 | 2022-02-22 | Laclede | Missouri | 29105 | 8026 | 163 |
2237539 | 2237539 | 2022-02-21 | Laclede | Missouri | 29105 | 8006 | 163 |
2234288 | 2234288 | 2022-02-20 | Laclede | Missouri | 29105 | 8006 | 163 |
2231037 | 2231037 | 2022-02-19 | Laclede | Missouri | 29105 | 8006 | 163 |
2227786 | 2227786 | 2022-02-18 | Laclede | Missouri | 29105 | 8006 | 163 |
2224535 | 2224535 | 2022-02-17 | Laclede | Missouri | 29105 | 8004 | 163 |
2221284 | 2221284 | 2022-02-16 | Laclede | Missouri | 29105 | 7999 | 163 |
2218033 | 2218033 | 2022-02-15 | Laclede | Missouri | 29105 | 7993 | 163 |
2214782 | 2214782 | 2022-02-14 | Laclede | Missouri | 29105 | 7985 | 162 |
2211530 | 2211530 | 2022-02-13 | Laclede | Missouri | 29105 | 7943 | 162 |
2208277 | 2208277 | 2022-02-12 | Laclede | Missouri | 29105 | 7943 | 162 |
2205024 | 2205024 | 2022-02-11 | Laclede | Missouri | 29105 | 7943 | 162 |
2201771 | 2201771 | 2022-02-10 | Laclede | Missouri | 29105 | 7943 | 162 |
2198517 | 2198517 | 2022-02-09 | Laclede | Missouri | 29105 | 7929 | 162 |
2195263 | 2195263 | 2022-02-08 | Laclede | Missouri | 29105 | 7909 | 162 |
2192009 | 2192009 | 2022-02-07 | Laclede | Missouri | 29105 | 7890 | 161 |
2188756 | 2188756 | 2022-02-06 | Laclede | Missouri | 29105 | 7876 | 161 |
2185503 | 2185503 | 2022-02-05 | Laclede | Missouri | 29105 | 7861 | 161 |
2182251 | 2182251 | 2022-02-04 | Laclede | Missouri | 29105 | 7851 | 161 |
2178999 | 2178999 | 2022-02-03 | Laclede | Missouri | 29105 | 7836 | 161 |
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);