ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 29225 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 |
---|---|---|---|---|---|---|---|
2501190 | 2501190 | 2022-05-13 | Webster | Missouri | 29225 | 9053 | 148 |
2497932 | 2497932 | 2022-05-12 | Webster | Missouri | 29225 | 9044 | 148 |
2494674 | 2494674 | 2022-05-11 | Webster | Missouri | 29225 | 9044 | 148 |
2491416 | 2491416 | 2022-05-10 | Webster | Missouri | 29225 | 9044 | 148 |
2488158 | 2488158 | 2022-05-09 | Webster | Missouri | 29225 | 9044 | 148 |
2484901 | 2484901 | 2022-05-08 | Webster | Missouri | 29225 | 9044 | 148 |
2481643 | 2481643 | 2022-05-07 | Webster | Missouri | 29225 | 9044 | 148 |
2478385 | 2478385 | 2022-05-06 | Webster | Missouri | 29225 | 9044 | 148 |
2475127 | 2475127 | 2022-05-05 | Webster | Missouri | 29225 | 9039 | 148 |
2471870 | 2471870 | 2022-05-04 | Webster | Missouri | 29225 | 9025 | 146 |
2468614 | 2468614 | 2022-05-03 | Webster | Missouri | 29225 | 9025 | 146 |
2465358 | 2465358 | 2022-05-02 | Webster | Missouri | 29225 | 9025 | 146 |
2462103 | 2462103 | 2022-05-01 | Webster | Missouri | 29225 | 9025 | 146 |
2458847 | 2458847 | 2022-04-30 | Webster | Missouri | 29225 | 9025 | 146 |
2455591 | 2455591 | 2022-04-29 | Webster | Missouri | 29225 | 9025 | 146 |
2452335 | 2452335 | 2022-04-28 | Webster | Missouri | 29225 | 9025 | 146 |
2449079 | 2449079 | 2022-04-27 | Webster | Missouri | 29225 | 9025 | 146 |
2445822 | 2445822 | 2022-04-26 | Webster | Missouri | 29225 | 9025 | 146 |
2442567 | 2442567 | 2022-04-25 | Webster | Missouri | 29225 | 9025 | 146 |
2439311 | 2439311 | 2022-04-24 | Webster | Missouri | 29225 | 9025 | 146 |
2436055 | 2436055 | 2022-04-23 | Webster | Missouri | 29225 | 9025 | 146 |
2432799 | 2432799 | 2022-04-22 | Webster | Missouri | 29225 | 9025 | 146 |
2429543 | 2429543 | 2022-04-21 | Webster | Missouri | 29225 | 9025 | 146 |
2426287 | 2426287 | 2022-04-20 | Webster | Missouri | 29225 | 9025 | 146 |
2423031 | 2423031 | 2022-04-19 | Webster | Missouri | 29225 | 9025 | 146 |
2419774 | 2419774 | 2022-04-18 | Webster | Missouri | 29225 | 9025 | 146 |
2416519 | 2416519 | 2022-04-17 | Webster | Missouri | 29225 | 9025 | 146 |
2413263 | 2413263 | 2022-04-16 | Webster | Missouri | 29225 | 9025 | 146 |
2410007 | 2410007 | 2022-04-15 | Webster | Missouri | 29225 | 9025 | 146 |
2406751 | 2406751 | 2022-04-14 | Webster | Missouri | 29225 | 9025 | 146 |
2403495 | 2403495 | 2022-04-13 | Webster | Missouri | 29225 | 9025 | 146 |
2400240 | 2400240 | 2022-04-12 | Webster | Missouri | 29225 | 9025 | 146 |
2396985 | 2396985 | 2022-04-11 | Webster | Missouri | 29225 | 9025 | 146 |
2393730 | 2393730 | 2022-04-10 | Webster | Missouri | 29225 | 9025 | 146 |
2390474 | 2390474 | 2022-04-09 | Webster | Missouri | 29225 | 9025 | 146 |
2387218 | 2387218 | 2022-04-08 | Webster | Missouri | 29225 | 9025 | 146 |
2383963 | 2383963 | 2022-04-07 | Webster | Missouri | 29225 | 9025 | 146 |
2380708 | 2380708 | 2022-04-06 | Webster | Missouri | 29225 | 9025 | 146 |
2377453 | 2377453 | 2022-04-05 | Webster | Missouri | 29225 | 9025 | 146 |
2374200 | 2374200 | 2022-04-04 | Webster | Missouri | 29225 | 9025 | 146 |
2370948 | 2370948 | 2022-04-03 | Webster | Missouri | 29225 | 9025 | 146 |
2367695 | 2367695 | 2022-04-02 | Webster | Missouri | 29225 | 9025 | 146 |
2364442 | 2364442 | 2022-04-01 | Webster | Missouri | 29225 | 9025 | 146 |
2361188 | 2361188 | 2022-03-31 | Webster | Missouri | 29225 | 9025 | 146 |
2357934 | 2357934 | 2022-03-30 | Webster | Missouri | 29225 | 9022 | 146 |
2354681 | 2354681 | 2022-03-29 | Webster | Missouri | 29225 | 9019 | 146 |
2351428 | 2351428 | 2022-03-28 | Webster | Missouri | 29225 | 9017 | 145 |
2348176 | 2348176 | 2022-03-27 | Webster | Missouri | 29225 | 9014 | 145 |
2344923 | 2344923 | 2022-03-26 | Webster | Missouri | 29225 | 9014 | 145 |
2341670 | 2341670 | 2022-03-25 | Webster | Missouri | 29225 | 9014 | 145 |
2338417 | 2338417 | 2022-03-24 | Webster | Missouri | 29225 | 9014 | 145 |
2335163 | 2335163 | 2022-03-23 | Webster | Missouri | 29225 | 9012 | 145 |
2331909 | 2331909 | 2022-03-22 | Webster | Missouri | 29225 | 9010 | 145 |
2328656 | 2328656 | 2022-03-21 | Webster | Missouri | 29225 | 9010 | 143 |
2325404 | 2325404 | 2022-03-20 | Webster | Missouri | 29225 | 9000 | 143 |
2322150 | 2322150 | 2022-03-19 | Webster | Missouri | 29225 | 9000 | 143 |
2318896 | 2318896 | 2022-03-18 | Webster | Missouri | 29225 | 9000 | 143 |
2315643 | 2315643 | 2022-03-17 | Webster | Missouri | 29225 | 8998 | 143 |
2312390 | 2312390 | 2022-03-16 | Webster | Missouri | 29225 | 8996 | 143 |
2309137 | 2309137 | 2022-03-15 | Webster | Missouri | 29225 | 8996 | 143 |
2305885 | 2305885 | 2022-03-14 | Webster | Missouri | 29225 | 8994 | 143 |
2302634 | 2302634 | 2022-03-13 | Webster | Missouri | 29225 | 8985 | 143 |
2299382 | 2299382 | 2022-03-12 | Webster | Missouri | 29225 | 8985 | 143 |
2296130 | 2296130 | 2022-03-11 | Webster | Missouri | 29225 | 8985 | 143 |
2292878 | 2292878 | 2022-03-10 | Webster | Missouri | 29225 | 8985 | 142 |
2289626 | 2289626 | 2022-03-09 | Webster | Missouri | 29225 | 8983 | 142 |
2286374 | 2286374 | 2022-03-08 | Webster | Missouri | 29225 | 8980 | 142 |
2283122 | 2283122 | 2022-03-07 | Webster | Missouri | 29225 | 8974 | 139 |
2279869 | 2279869 | 2022-03-06 | Webster | Missouri | 29225 | 8973 | 139 |
2276616 | 2276616 | 2022-03-05 | Webster | Missouri | 29225 | 8973 | 139 |
2273363 | 2273363 | 2022-03-04 | Webster | Missouri | 29225 | 8973 | 139 |
2270111 | 2270111 | 2022-03-03 | Webster | Missouri | 29225 | 8970 | 139 |
2266858 | 2266858 | 2022-03-02 | Webster | Missouri | 29225 | 8965 | 139 |
2263607 | 2263607 | 2022-03-01 | Webster | Missouri | 29225 | 8964 | 139 |
2260356 | 2260356 | 2022-02-28 | Webster | Missouri | 29225 | 8960 | 138 |
2257105 | 2257105 | 2022-02-27 | Webster | Missouri | 29225 | 8952 | 138 |
2253854 | 2253854 | 2022-02-26 | Webster | Missouri | 29225 | 8952 | 138 |
2250603 | 2250603 | 2022-02-25 | Webster | Missouri | 29225 | 8952 | 138 |
2247352 | 2247352 | 2022-02-24 | Webster | Missouri | 29225 | 8953 | 138 |
2244101 | 2244101 | 2022-02-23 | Webster | Missouri | 29225 | 8940 | 135 |
2240850 | 2240850 | 2022-02-22 | Webster | Missouri | 29225 | 8938 | 135 |
2237599 | 2237599 | 2022-02-21 | Webster | Missouri | 29225 | 8908 | 135 |
2234348 | 2234348 | 2022-02-20 | Webster | Missouri | 29225 | 8908 | 135 |
2231097 | 2231097 | 2022-02-19 | Webster | Missouri | 29225 | 8908 | 135 |
2227846 | 2227846 | 2022-02-18 | Webster | Missouri | 29225 | 8908 | 135 |
2224595 | 2224595 | 2022-02-17 | Webster | Missouri | 29225 | 8901 | 135 |
2221344 | 2221344 | 2022-02-16 | Webster | Missouri | 29225 | 8881 | 135 |
2218093 | 2218093 | 2022-02-15 | Webster | Missouri | 29225 | 8864 | 135 |
2214842 | 2214842 | 2022-02-14 | Webster | Missouri | 29225 | 8850 | 133 |
2211590 | 2211590 | 2022-02-13 | Webster | Missouri | 29225 | 8774 | 132 |
2208337 | 2208337 | 2022-02-12 | Webster | Missouri | 29225 | 8774 | 132 |
2205084 | 2205084 | 2022-02-11 | Webster | Missouri | 29225 | 8774 | 132 |
2201831 | 2201831 | 2022-02-10 | Webster | Missouri | 29225 | 8774 | 132 |
2198577 | 2198577 | 2022-02-09 | Webster | Missouri | 29225 | 8727 | 132 |
2195323 | 2195323 | 2022-02-08 | Webster | Missouri | 29225 | 8687 | 132 |
2192069 | 2192069 | 2022-02-07 | Webster | Missouri | 29225 | 8662 | 131 |
2188816 | 2188816 | 2022-02-06 | Webster | Missouri | 29225 | 8642 | 131 |
2185563 | 2185563 | 2022-02-05 | Webster | Missouri | 29225 | 8626 | 131 |
2182311 | 2182311 | 2022-02-04 | Webster | Missouri | 29225 | 8597 | 131 |
2179059 | 2179059 | 2022-02-03 | Webster | Missouri | 29225 | 8552 | 129 |
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);