ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Saline" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2436034 | 2436034 | 2022-04-23 | Saline | Missouri | 29195 | 6269 | 102 |
2432778 | 2432778 | 2022-04-22 | Saline | Missouri | 29195 | 6269 | 102 |
2429522 | 2429522 | 2022-04-21 | Saline | Missouri | 29195 | 6269 | 102 |
2426266 | 2426266 | 2022-04-20 | Saline | Missouri | 29195 | 6269 | 102 |
2423010 | 2423010 | 2022-04-19 | Saline | Missouri | 29195 | 6269 | 102 |
2419753 | 2419753 | 2022-04-18 | Saline | Missouri | 29195 | 6269 | 102 |
2416498 | 2416498 | 2022-04-17 | Saline | Missouri | 29195 | 6269 | 102 |
2413242 | 2413242 | 2022-04-16 | Saline | Missouri | 29195 | 6269 | 102 |
2409986 | 2409986 | 2022-04-15 | Saline | Missouri | 29195 | 6269 | 102 |
2406730 | 2406730 | 2022-04-14 | Saline | Missouri | 29195 | 6269 | 102 |
2403474 | 2403474 | 2022-04-13 | Saline | Missouri | 29195 | 6269 | 102 |
2400219 | 2400219 | 2022-04-12 | Saline | Missouri | 29195 | 6269 | 102 |
2396964 | 2396964 | 2022-04-11 | Saline | Missouri | 29195 | 6269 | 102 |
2393709 | 2393709 | 2022-04-10 | Saline | Missouri | 29195 | 6269 | 102 |
2390453 | 2390453 | 2022-04-09 | Saline | Missouri | 29195 | 6269 | 102 |
2387197 | 2387197 | 2022-04-08 | Saline | Missouri | 29195 | 6269 | 102 |
2383942 | 2383942 | 2022-04-07 | Saline | Missouri | 29195 | 6269 | 102 |
2380687 | 2380687 | 2022-04-06 | Saline | Missouri | 29195 | 6269 | 102 |
2377432 | 2377432 | 2022-04-05 | Saline | Missouri | 29195 | 6269 | 102 |
2374179 | 2374179 | 2022-04-04 | Saline | Missouri | 29195 | 6269 | 102 |
2370927 | 2370927 | 2022-04-03 | Saline | Missouri | 29195 | 6269 | 102 |
2367674 | 2367674 | 2022-04-02 | Saline | Missouri | 29195 | 6269 | 102 |
2364421 | 2364421 | 2022-04-01 | Saline | Missouri | 29195 | 6269 | 102 |
2361167 | 2361167 | 2022-03-31 | Saline | Missouri | 29195 | 6269 | 102 |
2357913 | 2357913 | 2022-03-30 | Saline | Missouri | 29195 | 6269 | 102 |
2354660 | 2354660 | 2022-03-29 | Saline | Missouri | 29195 | 6269 | 102 |
2351407 | 2351407 | 2022-03-28 | Saline | Missouri | 29195 | 6269 | 102 |
2348155 | 2348155 | 2022-03-27 | Saline | Missouri | 29195 | 6264 | 102 |
2344902 | 2344902 | 2022-03-26 | Saline | Missouri | 29195 | 6264 | 102 |
2341649 | 2341649 | 2022-03-25 | Saline | Missouri | 29195 | 6264 | 102 |
2338396 | 2338396 | 2022-03-24 | Saline | Missouri | 29195 | 6263 | 102 |
2335142 | 2335142 | 2022-03-23 | Saline | Missouri | 29195 | 6263 | 102 |
2331888 | 2331888 | 2022-03-22 | Saline | Missouri | 29195 | 6264 | 102 |
2328635 | 2328635 | 2022-03-21 | Saline | Missouri | 29195 | 6263 | 101 |
2325383 | 2325383 | 2022-03-20 | Saline | Missouri | 29195 | 6261 | 101 |
2322129 | 2322129 | 2022-03-19 | Saline | Missouri | 29195 | 6261 | 101 |
2318875 | 2318875 | 2022-03-18 | Saline | Missouri | 29195 | 6261 | 101 |
2315622 | 2315622 | 2022-03-17 | Saline | Missouri | 29195 | 6260 | 101 |
2312369 | 2312369 | 2022-03-16 | Saline | Missouri | 29195 | 6260 | 101 |
2309116 | 2309116 | 2022-03-15 | Saline | Missouri | 29195 | 6260 | 101 |
2305864 | 2305864 | 2022-03-14 | Saline | Missouri | 29195 | 6256 | 100 |
2302613 | 2302613 | 2022-03-13 | Saline | Missouri | 29195 | 6254 | 100 |
2299361 | 2299361 | 2022-03-12 | Saline | Missouri | 29195 | 6254 | 100 |
2296109 | 2296109 | 2022-03-11 | Saline | Missouri | 29195 | 6254 | 100 |
2292857 | 2292857 | 2022-03-10 | Saline | Missouri | 29195 | 6252 | 100 |
2289605 | 2289605 | 2022-03-09 | Saline | Missouri | 29195 | 6252 | 100 |
2286353 | 2286353 | 2022-03-08 | Saline | Missouri | 29195 | 6252 | 100 |
2283101 | 2283101 | 2022-03-07 | Saline | Missouri | 29195 | 6250 | 99 |
2279848 | 2279848 | 2022-03-06 | Saline | Missouri | 29195 | 6246 | 99 |
2276595 | 2276595 | 2022-03-05 | Saline | Missouri | 29195 | 6246 | 99 |
2273342 | 2273342 | 2022-03-04 | Saline | Missouri | 29195 | 6246 | 99 |
2270090 | 2270090 | 2022-03-03 | Saline | Missouri | 29195 | 6245 | 99 |
2266837 | 2266837 | 2022-03-02 | Saline | Missouri | 29195 | 6242 | 99 |
2263586 | 2263586 | 2022-03-01 | Saline | Missouri | 29195 | 6242 | 99 |
2260335 | 2260335 | 2022-02-28 | Saline | Missouri | 29195 | 6237 | 98 |
2257084 | 2257084 | 2022-02-27 | Saline | Missouri | 29195 | 6234 | 98 |
2253833 | 2253833 | 2022-02-26 | Saline | Missouri | 29195 | 6234 | 98 |
2250582 | 2250582 | 2022-02-25 | Saline | Missouri | 29195 | 6234 | 98 |
2247331 | 2247331 | 2022-02-24 | Saline | Missouri | 29195 | 6232 | 98 |
2244080 | 2244080 | 2022-02-23 | Saline | Missouri | 29195 | 6233 | 97 |
2240829 | 2240829 | 2022-02-22 | Saline | Missouri | 29195 | 6221 | 97 |
2237578 | 2237578 | 2022-02-21 | Saline | Missouri | 29195 | 6212 | 97 |
2234327 | 2234327 | 2022-02-20 | Saline | Missouri | 29195 | 6212 | 97 |
2231076 | 2231076 | 2022-02-19 | Saline | Missouri | 29195 | 6212 | 97 |
2227825 | 2227825 | 2022-02-18 | Saline | Missouri | 29195 | 6212 | 97 |
2224574 | 2224574 | 2022-02-17 | Saline | Missouri | 29195 | 6209 | 97 |
2221323 | 2221323 | 2022-02-16 | Saline | Missouri | 29195 | 6195 | 97 |
2218072 | 2218072 | 2022-02-15 | Saline | Missouri | 29195 | 6188 | 97 |
2214821 | 2214821 | 2022-02-14 | Saline | Missouri | 29195 | 6181 | 95 |
2211569 | 2211569 | 2022-02-13 | Saline | Missouri | 29195 | 6138 | 95 |
2208316 | 2208316 | 2022-02-12 | Saline | Missouri | 29195 | 6138 | 95 |
2205063 | 2205063 | 2022-02-11 | Saline | Missouri | 29195 | 6138 | 95 |
2201810 | 2201810 | 2022-02-10 | Saline | Missouri | 29195 | 6138 | 95 |
2198556 | 2198556 | 2022-02-09 | Saline | Missouri | 29195 | 6132 | 95 |
2195302 | 2195302 | 2022-02-08 | Saline | Missouri | 29195 | 6117 | 95 |
2192048 | 2192048 | 2022-02-07 | Saline | Missouri | 29195 | 6110 | 95 |
2188795 | 2188795 | 2022-02-06 | Saline | Missouri | 29195 | 6104 | 95 |
2185542 | 2185542 | 2022-02-05 | Saline | Missouri | 29195 | 6081 | 95 |
2182290 | 2182290 | 2022-02-04 | Saline | Missouri | 29195 | 6075 | 95 |
2179038 | 2179038 | 2022-02-03 | Saline | Missouri | 29195 | 6068 | 95 |
2175786 | 2175786 | 2022-02-02 | Saline | Missouri | 29195 | 6041 | 95 |
2172533 | 2172533 | 2022-02-01 | Saline | Missouri | 29195 | 5994 | 95 |
2169280 | 2169280 | 2022-01-31 | Saline | Missouri | 29195 | 5974 | 90 |
2166025 | 2166025 | 2022-01-30 | Saline | Missouri | 29195 | 5960 | 90 |
2162770 | 2162770 | 2022-01-29 | Saline | Missouri | 29195 | 5941 | 90 |
2159515 | 2159515 | 2022-01-28 | Saline | Missouri | 29195 | 5871 | 90 |
2156261 | 2156261 | 2022-01-27 | Saline | Missouri | 29195 | 5817 | 90 |
2153008 | 2153008 | 2022-01-26 | Saline | Missouri | 29195 | 5767 | 90 |
2149756 | 2149756 | 2022-01-25 | Saline | Missouri | 29195 | 5727 | 90 |
2146504 | 2146504 | 2022-01-24 | Saline | Missouri | 29195 | 5662 | 90 |
2143249 | 2143249 | 2022-01-23 | Saline | Missouri | 29195 | 5631 | 90 |
2139994 | 2139994 | 2022-01-22 | Saline | Missouri | 29195 | 5583 | 90 |
2136738 | 2136738 | 2022-01-21 | Saline | Missouri | 29195 | 5517 | 90 |
2133486 | 2133486 | 2022-01-20 | Saline | Missouri | 29195 | 5491 | 91 |
2130233 | 2130233 | 2022-01-19 | Saline | Missouri | 29195 | 5391 | 91 |
2126979 | 2126979 | 2022-01-18 | Saline | Missouri | 29195 | 5272 | 90 |
2123727 | 2123727 | 2022-01-17 | Saline | Missouri | 29195 | 5170 | 90 |
2120475 | 2120475 | 2022-01-16 | Saline | Missouri | 29195 | 5170 | 90 |
2117223 | 2117223 | 2022-01-15 | Saline | Missouri | 29195 | 5170 | 90 |
2113972 | 2113972 | 2022-01-14 | Saline | Missouri | 29195 | 5105 | 90 |
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);