ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,582 rows where county = "St. Louis" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500976 | 2500976 | 2022-05-13 | St. Louis | Minnesota | 27137 | 48555 | 533 |
2501178 | 2501178 | 2022-05-13 | St. Louis | Missouri | 29189 | 227453 | 3341 |
2497718 | 2497718 | 2022-05-12 | St. Louis | Minnesota | 27137 | 48400 | 532 |
2497920 | 2497920 | 2022-05-12 | St. Louis | Missouri | 29189 | 227187 | 3341 |
2494460 | 2494460 | 2022-05-11 | St. Louis | Minnesota | 27137 | 48295 | 531 |
2494662 | 2494662 | 2022-05-11 | St. Louis | Missouri | 29189 | 226840 | 3342 |
2491202 | 2491202 | 2022-05-10 | St. Louis | Minnesota | 27137 | 48210 | 531 |
2491404 | 2491404 | 2022-05-10 | St. Louis | Missouri | 29189 | 226454 | 3342 |
2487945 | 2487945 | 2022-05-09 | St. Louis | Minnesota | 27137 | 48014 | 531 |
2488146 | 2488146 | 2022-05-09 | St. Louis | Missouri | 29189 | 226131 | 3342 |
2484687 | 2484687 | 2022-05-08 | St. Louis | Minnesota | 27137 | 47912 | 531 |
2484889 | 2484889 | 2022-05-08 | St. Louis | Missouri | 29189 | 225360 | 3342 |
2481429 | 2481429 | 2022-05-07 | St. Louis | Minnesota | 27137 | 47912 | 531 |
2481631 | 2481631 | 2022-05-07 | St. Louis | Missouri | 29189 | 225360 | 3342 |
2478171 | 2478171 | 2022-05-06 | St. Louis | Minnesota | 27137 | 47912 | 531 |
2478373 | 2478373 | 2022-05-06 | St. Louis | Missouri | 29189 | 225360 | 3342 |
2474913 | 2474913 | 2022-05-05 | St. Louis | Minnesota | 27137 | 47838 | 531 |
2475115 | 2475115 | 2022-05-05 | St. Louis | Missouri | 29189 | 225179 | 3342 |
2471656 | 2471656 | 2022-05-04 | St. Louis | Minnesota | 27137 | 47778 | 531 |
2471858 | 2471858 | 2022-05-04 | St. Louis | Missouri | 29189 | 224698 | 3342 |
2468400 | 2468400 | 2022-05-03 | St. Louis | Minnesota | 27137 | 47702 | 531 |
2468602 | 2468602 | 2022-05-03 | St. Louis | Missouri | 29189 | 224644 | 3341 |
2465145 | 2465145 | 2022-05-02 | St. Louis | Minnesota | 27137 | 47632 | 531 |
2465346 | 2465346 | 2022-05-02 | St. Louis | Missouri | 29189 | 224295 | 3326 |
2461889 | 2461889 | 2022-05-01 | St. Louis | Minnesota | 27137 | 47585 | 531 |
2462091 | 2462091 | 2022-05-01 | St. Louis | Missouri | 29189 | 223952 | 3325 |
2458633 | 2458633 | 2022-04-30 | St. Louis | Minnesota | 27137 | 47585 | 531 |
2458835 | 2458835 | 2022-04-30 | St. Louis | Missouri | 29189 | 223952 | 3325 |
2455377 | 2455377 | 2022-04-29 | St. Louis | Minnesota | 27137 | 47585 | 531 |
2455579 | 2455579 | 2022-04-29 | St. Louis | Missouri | 29189 | 223952 | 3325 |
2452121 | 2452121 | 2022-04-28 | St. Louis | Minnesota | 27137 | 47529 | 531 |
2452323 | 2452323 | 2022-04-28 | St. Louis | Missouri | 29189 | 223764 | 3325 |
2448865 | 2448865 | 2022-04-27 | St. Louis | Minnesota | 27137 | 47485 | 531 |
2449067 | 2449067 | 2022-04-27 | St. Louis | Missouri | 29189 | 223498 | 3325 |
2445609 | 2445609 | 2022-04-26 | St. Louis | Minnesota | 27137 | 47441 | 531 |
2445810 | 2445810 | 2022-04-26 | St. Louis | Missouri | 29189 | 223271 | 3320 |
2442353 | 2442353 | 2022-04-25 | St. Louis | Minnesota | 27137 | 47373 | 531 |
2442555 | 2442555 | 2022-04-25 | St. Louis | Missouri | 29189 | 223069 | 3318 |
2439097 | 2439097 | 2022-04-24 | St. Louis | Minnesota | 27137 | 47334 | 531 |
2439299 | 2439299 | 2022-04-24 | St. Louis | Missouri | 29189 | 222608 | 3318 |
2435841 | 2435841 | 2022-04-23 | St. Louis | Minnesota | 27137 | 47334 | 531 |
2436043 | 2436043 | 2022-04-23 | St. Louis | Missouri | 29189 | 222608 | 3318 |
2432585 | 2432585 | 2022-04-22 | St. Louis | Minnesota | 27137 | 47334 | 531 |
2432787 | 2432787 | 2022-04-22 | St. Louis | Missouri | 29189 | 222608 | 3318 |
2429329 | 2429329 | 2022-04-21 | St. Louis | Minnesota | 27137 | 47286 | 530 |
2429531 | 2429531 | 2022-04-21 | St. Louis | Missouri | 29189 | 222432 | 3318 |
2426073 | 2426073 | 2022-04-20 | St. Louis | Minnesota | 27137 | 47252 | 530 |
2426275 | 2426275 | 2022-04-20 | St. Louis | Missouri | 29189 | 222244 | 3318 |
2422817 | 2422817 | 2022-04-19 | St. Louis | Minnesota | 27137 | 47217 | 530 |
2423019 | 2423019 | 2022-04-19 | St. Louis | Missouri | 29189 | 222097 | 3313 |
2419561 | 2419561 | 2022-04-18 | St. Louis | Minnesota | 27137 | 47148 | 529 |
2419762 | 2419762 | 2022-04-18 | St. Louis | Missouri | 29189 | 221963 | 3313 |
2416305 | 2416305 | 2022-04-17 | St. Louis | Minnesota | 27137 | 47121 | 529 |
2416507 | 2416507 | 2022-04-17 | St. Louis | Missouri | 29189 | 221665 | 3312 |
2413049 | 2413049 | 2022-04-16 | St. Louis | Minnesota | 27137 | 47121 | 529 |
2413251 | 2413251 | 2022-04-16 | St. Louis | Missouri | 29189 | 221665 | 3312 |
2409793 | 2409793 | 2022-04-15 | St. Louis | Minnesota | 27137 | 47121 | 529 |
2409995 | 2409995 | 2022-04-15 | St. Louis | Missouri | 29189 | 221665 | 3312 |
2406537 | 2406537 | 2022-04-14 | St. Louis | Minnesota | 27137 | 47091 | 528 |
2406739 | 2406739 | 2022-04-14 | St. Louis | Missouri | 29189 | 221528 | 3312 |
2403281 | 2403281 | 2022-04-13 | St. Louis | Minnesota | 27137 | 47072 | 528 |
2403483 | 2403483 | 2022-04-13 | St. Louis | Missouri | 29189 | 221391 | 3310 |
2400027 | 2400027 | 2022-04-12 | St. Louis | Minnesota | 27137 | 47039 | 528 |
2400228 | 2400228 | 2022-04-12 | St. Louis | Missouri | 29189 | 221323 | 3307 |
2396771 | 2396771 | 2022-04-11 | St. Louis | Minnesota | 27137 | 47001 | 527 |
2396973 | 2396973 | 2022-04-11 | St. Louis | Missouri | 29189 | 221212 | 3304 |
2393516 | 2393516 | 2022-04-10 | St. Louis | Minnesota | 27137 | 46969 | 527 |
2393718 | 2393718 | 2022-04-10 | St. Louis | Missouri | 29189 | 221012 | 3304 |
2390260 | 2390260 | 2022-04-09 | St. Louis | Minnesota | 27137 | 46969 | 527 |
2390462 | 2390462 | 2022-04-09 | St. Louis | Missouri | 29189 | 221012 | 3304 |
2387004 | 2387004 | 2022-04-08 | St. Louis | Minnesota | 27137 | 46969 | 527 |
2387206 | 2387206 | 2022-04-08 | St. Louis | Missouri | 29189 | 221012 | 3304 |
2383749 | 2383749 | 2022-04-07 | St. Louis | Minnesota | 27137 | 46934 | 527 |
2383951 | 2383951 | 2022-04-07 | St. Louis | Missouri | 29189 | 220939 | 3303 |
2380494 | 2380494 | 2022-04-06 | St. Louis | Minnesota | 27137 | 46910 | 527 |
2380696 | 2380696 | 2022-04-06 | St. Louis | Missouri | 29189 | 220337 | 3302 |
2377239 | 2377239 | 2022-04-05 | St. Louis | Minnesota | 27137 | 46890 | 527 |
2377441 | 2377441 | 2022-04-05 | St. Louis | Missouri | 29189 | 220287 | 3301 |
2373987 | 2373987 | 2022-04-04 | St. Louis | Minnesota | 27137 | 46824 | 526 |
2374188 | 2374188 | 2022-04-04 | St. Louis | Missouri | 29189 | 220223 | 3299 |
2370734 | 2370734 | 2022-04-03 | St. Louis | Minnesota | 27137 | 46803 | 526 |
2370936 | 2370936 | 2022-04-03 | St. Louis | Missouri | 29189 | 220061 | 3299 |
2367481 | 2367481 | 2022-04-02 | St. Louis | Minnesota | 27137 | 46803 | 526 |
2367683 | 2367683 | 2022-04-02 | St. Louis | Missouri | 29189 | 220061 | 3299 |
2364228 | 2364228 | 2022-04-01 | St. Louis | Minnesota | 27137 | 46803 | 526 |
2364430 | 2364430 | 2022-04-01 | St. Louis | Missouri | 29189 | 220061 | 3299 |
2360974 | 2360974 | 2022-03-31 | St. Louis | Minnesota | 27137 | 46768 | 526 |
2361176 | 2361176 | 2022-03-31 | St. Louis | Missouri | 29189 | 219984 | 3299 |
2357720 | 2357720 | 2022-03-30 | St. Louis | Minnesota | 27137 | 46752 | 526 |
2357922 | 2357922 | 2022-03-30 | St. Louis | Missouri | 29189 | 219892 | 3289 |
2354467 | 2354467 | 2022-03-29 | St. Louis | Minnesota | 27137 | 46736 | 526 |
2354669 | 2354669 | 2022-03-29 | St. Louis | Missouri | 29189 | 219800 | 3283 |
2351215 | 2351215 | 2022-03-28 | St. Louis | Minnesota | 27137 | 46678 | 526 |
2351416 | 2351416 | 2022-03-28 | St. Louis | Missouri | 29189 | 219745 | 3283 |
2347962 | 2347962 | 2022-03-27 | St. Louis | Minnesota | 27137 | 46656 | 526 |
2348164 | 2348164 | 2022-03-27 | St. Louis | Missouri | 29189 | 219629 | 3279 |
2344709 | 2344709 | 2022-03-26 | St. Louis | Minnesota | 27137 | 46656 | 526 |
2344911 | 2344911 | 2022-03-26 | St. Louis | Missouri | 29189 | 219629 | 3279 |
2341456 | 2341456 | 2022-03-25 | St. Louis | Minnesota | 27137 | 46656 | 526 |
2341658 | 2341658 | 2022-03-25 | St. Louis | Missouri | 29189 | 219629 | 3279 |
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);