ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
305 rows where deaths = 93 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475103 | 2475103 | 2022-05-05 | Ray | Missouri | 29177 | 5181 | 93 |
2471846 | 2471846 | 2022-05-04 | Ray | Missouri | 29177 | 5147 | 93 |
2468590 | 2468590 | 2022-05-03 | Ray | Missouri | 29177 | 5147 | 93 |
2465334 | 2465334 | 2022-05-02 | Ray | Missouri | 29177 | 5147 | 93 |
2462079 | 2462079 | 2022-05-01 | Ray | Missouri | 29177 | 5147 | 93 |
2458823 | 2458823 | 2022-04-30 | Ray | Missouri | 29177 | 5147 | 93 |
2455567 | 2455567 | 2022-04-29 | Ray | Missouri | 29177 | 5147 | 93 |
2452311 | 2452311 | 2022-04-28 | Ray | Missouri | 29177 | 5147 | 93 |
2449055 | 2449055 | 2022-04-27 | Ray | Missouri | 29177 | 5147 | 93 |
2445798 | 2445798 | 2022-04-26 | Ray | Missouri | 29177 | 5147 | 93 |
2442543 | 2442543 | 2022-04-25 | Ray | Missouri | 29177 | 5147 | 93 |
2439287 | 2439287 | 2022-04-24 | Ray | Missouri | 29177 | 5147 | 93 |
2436031 | 2436031 | 2022-04-23 | Ray | Missouri | 29177 | 5147 | 93 |
2432775 | 2432775 | 2022-04-22 | Ray | Missouri | 29177 | 5147 | 93 |
2429519 | 2429519 | 2022-04-21 | Ray | Missouri | 29177 | 5147 | 93 |
2426263 | 2426263 | 2022-04-20 | Ray | Missouri | 29177 | 5147 | 93 |
2423007 | 2423007 | 2022-04-19 | Ray | Missouri | 29177 | 5147 | 93 |
2419750 | 2419750 | 2022-04-18 | Ray | Missouri | 29177 | 5147 | 93 |
2416495 | 2416495 | 2022-04-17 | Ray | Missouri | 29177 | 5147 | 93 |
2413239 | 2413239 | 2022-04-16 | Ray | Missouri | 29177 | 5147 | 93 |
2409983 | 2409983 | 2022-04-15 | Ray | Missouri | 29177 | 5147 | 93 |
2406727 | 2406727 | 2022-04-14 | Ray | Missouri | 29177 | 5147 | 93 |
2403471 | 2403471 | 2022-04-13 | Ray | Missouri | 29177 | 5147 | 93 |
2400216 | 2400216 | 2022-04-12 | Ray | Missouri | 29177 | 5147 | 93 |
2396961 | 2396961 | 2022-04-11 | Ray | Missouri | 29177 | 5147 | 93 |
2393706 | 2393706 | 2022-04-10 | Ray | Missouri | 29177 | 5147 | 93 |
2390450 | 2390450 | 2022-04-09 | Ray | Missouri | 29177 | 5147 | 93 |
2387194 | 2387194 | 2022-04-08 | Ray | Missouri | 29177 | 5147 | 93 |
2383939 | 2383939 | 2022-04-07 | Ray | Missouri | 29177 | 5147 | 93 |
2380684 | 2380684 | 2022-04-06 | Ray | Missouri | 29177 | 5147 | 93 |
2377429 | 2377429 | 2022-04-05 | Ray | Missouri | 29177 | 5147 | 93 |
2374176 | 2374176 | 2022-04-04 | Ray | Missouri | 29177 | 5147 | 93 |
2370924 | 2370924 | 2022-04-03 | Ray | Missouri | 29177 | 5147 | 93 |
2367671 | 2367671 | 2022-04-02 | Ray | Missouri | 29177 | 5147 | 93 |
2364418 | 2364418 | 2022-04-01 | Ray | Missouri | 29177 | 5147 | 93 |
2361164 | 2361164 | 2022-03-31 | Ray | Missouri | 29177 | 5147 | 93 |
2357910 | 2357910 | 2022-03-30 | Ray | Missouri | 29177 | 5147 | 93 |
2354657 | 2354657 | 2022-03-29 | Ray | Missouri | 29177 | 5144 | 93 |
2351404 | 2351404 | 2022-03-28 | Ray | Missouri | 29177 | 5144 | 93 |
2348152 | 2348152 | 2022-03-27 | Ray | Missouri | 29177 | 5143 | 93 |
2344899 | 2344899 | 2022-03-26 | Ray | Missouri | 29177 | 5143 | 93 |
2341646 | 2341646 | 2022-03-25 | Ray | Missouri | 29177 | 5143 | 93 |
2338393 | 2338393 | 2022-03-24 | Ray | Missouri | 29177 | 5141 | 93 |
2335139 | 2335139 | 2022-03-23 | Ray | Missouri | 29177 | 5139 | 93 |
2331885 | 2331885 | 2022-03-22 | Ray | Missouri | 29177 | 5139 | 93 |
2283117 | 2283117 | 2022-03-07 | Texas | Missouri | 29215 | 4637 | 93 |
2279864 | 2279864 | 2022-03-06 | Texas | Missouri | 29215 | 4636 | 93 |
2276611 | 2276611 | 2022-03-05 | Texas | Missouri | 29215 | 4636 | 93 |
2273358 | 2273358 | 2022-03-04 | Texas | Missouri | 29215 | 4636 | 93 |
2260278 | 2260278 | 2022-02-28 | Gasconade | Missouri | 29073 | 3299 | 93 |
2257027 | 2257027 | 2022-02-27 | Gasconade | Missouri | 29073 | 3296 | 93 |
2253776 | 2253776 | 2022-02-26 | Gasconade | Missouri | 29073 | 3296 | 93 |
2250525 | 2250525 | 2022-02-25 | Gasconade | Missouri | 29073 | 3296 | 93 |
2247274 | 2247274 | 2022-02-24 | Gasconade | Missouri | 29073 | 3293 | 93 |
2244023 | 2244023 | 2022-02-23 | Gasconade | Missouri | 29073 | 3286 | 93 |
2240772 | 2240772 | 2022-02-22 | Gasconade | Missouri | 29073 | 3279 | 93 |
2237521 | 2237521 | 2022-02-21 | Gasconade | Missouri | 29073 | 3271 | 93 |
2234270 | 2234270 | 2022-02-20 | Gasconade | Missouri | 29073 | 3271 | 93 |
2231019 | 2231019 | 2022-02-19 | Gasconade | Missouri | 29073 | 3271 | 93 |
2227768 | 2227768 | 2022-02-18 | Gasconade | Missouri | 29073 | 3271 | 93 |
2224517 | 2224517 | 2022-02-17 | Gasconade | Missouri | 29073 | 3268 | 93 |
2221266 | 2221266 | 2022-02-16 | Gasconade | Missouri | 29073 | 3264 | 93 |
2218015 | 2218015 | 2022-02-15 | Gasconade | Missouri | 29073 | 3258 | 93 |
2214764 | 2214764 | 2022-02-14 | Gasconade | Missouri | 29073 | 3252 | 93 |
2211512 | 2211512 | 2022-02-13 | Gasconade | Missouri | 29073 | 3237 | 93 |
2208259 | 2208259 | 2022-02-12 | Gasconade | Missouri | 29073 | 3237 | 93 |
2205006 | 2205006 | 2022-02-11 | Gasconade | Missouri | 29073 | 3237 | 93 |
2201753 | 2201753 | 2022-02-10 | Gasconade | Missouri | 29073 | 3237 | 93 |
2198499 | 2198499 | 2022-02-09 | Gasconade | Missouri | 29073 | 3229 | 93 |
2195245 | 2195245 | 2022-02-08 | Gasconade | Missouri | 29073 | 3220 | 93 |
2195298 | 2195298 | 2022-02-08 | Randolph | Missouri | 29175 | 5770 | 93 |
2191989 | 2191989 | 2022-02-07 | Dunklin | Missouri | 29069 | 6737 | 93 |
2191991 | 2191991 | 2022-02-07 | Gasconade | Missouri | 29073 | 3209 | 93 |
2192027 | 2192027 | 2022-02-07 | Morgan | Missouri | 29141 | 3888 | 93 |
2192066 | 2192066 | 2022-02-07 | Warren | Missouri | 29219 | 7946 | 93 |
2188736 | 2188736 | 2022-02-06 | Dunklin | Missouri | 29069 | 6727 | 93 |
2188738 | 2188738 | 2022-02-06 | Gasconade | Missouri | 29073 | 3207 | 93 |
2188774 | 2188774 | 2022-02-06 | Morgan | Missouri | 29141 | 3881 | 93 |
2188813 | 2188813 | 2022-02-06 | Warren | Missouri | 29219 | 7943 | 93 |
2185483 | 2185483 | 2022-02-05 | Dunklin | Missouri | 29069 | 6720 | 93 |
2185485 | 2185485 | 2022-02-05 | Gasconade | Missouri | 29073 | 3206 | 93 |
2185521 | 2185521 | 2022-02-05 | Morgan | Missouri | 29141 | 3878 | 93 |
2185560 | 2185560 | 2022-02-05 | Warren | Missouri | 29219 | 7939 | 93 |
2182231 | 2182231 | 2022-02-04 | Dunklin | Missouri | 29069 | 6648 | 93 |
2182233 | 2182233 | 2022-02-04 | Gasconade | Missouri | 29073 | 3195 | 93 |
2182269 | 2182269 | 2022-02-04 | Morgan | Missouri | 29141 | 3861 | 93 |
2182308 | 2182308 | 2022-02-04 | Warren | Missouri | 29219 | 7924 | 93 |
2178979 | 2178979 | 2022-02-03 | Dunklin | Missouri | 29069 | 6604 | 93 |
2178981 | 2178981 | 2022-02-03 | Gasconade | Missouri | 29073 | 3190 | 93 |
2179017 | 2179017 | 2022-02-03 | Morgan | Missouri | 29141 | 3854 | 93 |
2179056 | 2179056 | 2022-02-03 | Warren | Missouri | 29219 | 7921 | 93 |
2175727 | 2175727 | 2022-02-02 | Dunklin | Missouri | 29069 | 6567 | 93 |
2175729 | 2175729 | 2022-02-02 | Gasconade | Missouri | 29073 | 3179 | 93 |
2175765 | 2175765 | 2022-02-02 | Morgan | Missouri | 29141 | 3847 | 93 |
2175804 | 2175804 | 2022-02-02 | Warren | Missouri | 29219 | 7904 | 93 |
2172474 | 2172474 | 2022-02-01 | Dunklin | Missouri | 29069 | 6552 | 93 |
2172476 | 2172476 | 2022-02-01 | Gasconade | Missouri | 29073 | 3149 | 93 |
2172512 | 2172512 | 2022-02-01 | Morgan | Missouri | 29141 | 3829 | 93 |
2172551 | 2172551 | 2022-02-01 | Warren | Missouri | 29219 | 7864 | 93 |
2169190 | 2169190 | 2022-01-31 | Audrain | Missouri | 29007 | 5373 | 93 |
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);