ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Pontotoc" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338277 | 2338277 | 2022-03-24 | Pontotoc | Mississippi | 28115 | 10318 | 144 |
2339020 | 2339020 | 2022-03-24 | Pontotoc | Oklahoma | 40123 | 11981 | 138 |
2335023 | 2335023 | 2022-03-23 | Pontotoc | Mississippi | 28115 | 10318 | 144 |
2335766 | 2335766 | 2022-03-23 | Pontotoc | Oklahoma | 40123 | 11978 | 135 |
2331769 | 2331769 | 2022-03-22 | Pontotoc | Mississippi | 28115 | 10318 | 144 |
2332512 | 2332512 | 2022-03-22 | Pontotoc | Oklahoma | 40123 | 11978 | 135 |
2328517 | 2328517 | 2022-03-21 | Pontotoc | Mississippi | 28115 | 10318 | 144 |
2329259 | 2329259 | 2022-03-21 | Pontotoc | Oklahoma | 40123 | 11978 | 135 |
2325264 | 2325264 | 2022-03-20 | Pontotoc | Mississippi | 28115 | 10316 | 143 |
2326007 | 2326007 | 2022-03-20 | Pontotoc | Oklahoma | 40123 | 11978 | 135 |
2322010 | 2322010 | 2022-03-19 | Pontotoc | Mississippi | 28115 | 10316 | 143 |
2322754 | 2322754 | 2022-03-19 | Pontotoc | Oklahoma | 40123 | 11978 | 135 |
2318756 | 2318756 | 2022-03-18 | Pontotoc | Mississippi | 28115 | 10316 | 143 |
2319500 | 2319500 | 2022-03-18 | Pontotoc | Oklahoma | 40123 | 11978 | 135 |
2315503 | 2315503 | 2022-03-17 | Pontotoc | Mississippi | 28115 | 10316 | 143 |
2316246 | 2316246 | 2022-03-17 | Pontotoc | Oklahoma | 40123 | 11978 | 135 |
2312250 | 2312250 | 2022-03-16 | Pontotoc | Mississippi | 28115 | 10316 | 143 |
2312993 | 2312993 | 2022-03-16 | Pontotoc | Oklahoma | 40123 | 11934 | 131 |
2308997 | 2308997 | 2022-03-15 | Pontotoc | Mississippi | 28115 | 10316 | 143 |
2309740 | 2309740 | 2022-03-15 | Pontotoc | Oklahoma | 40123 | 11934 | 131 |
2305746 | 2305746 | 2022-03-14 | Pontotoc | Mississippi | 28115 | 10316 | 143 |
2306487 | 2306487 | 2022-03-14 | Pontotoc | Oklahoma | 40123 | 11934 | 131 |
2302494 | 2302494 | 2022-03-13 | Pontotoc | Mississippi | 28115 | 10314 | 141 |
2303236 | 2303236 | 2022-03-13 | Pontotoc | Oklahoma | 40123 | 11934 | 131 |
2299242 | 2299242 | 2022-03-12 | Pontotoc | Mississippi | 28115 | 10314 | 141 |
2299984 | 2299984 | 2022-03-12 | Pontotoc | Oklahoma | 40123 | 11934 | 131 |
2295990 | 2295990 | 2022-03-11 | Pontotoc | Mississippi | 28115 | 10314 | 141 |
2296732 | 2296732 | 2022-03-11 | Pontotoc | Oklahoma | 40123 | 11934 | 131 |
2292738 | 2292738 | 2022-03-10 | Pontotoc | Mississippi | 28115 | 10314 | 141 |
2293480 | 2293480 | 2022-03-10 | Pontotoc | Oklahoma | 40123 | 11934 | 131 |
2289486 | 2289486 | 2022-03-09 | Pontotoc | Mississippi | 28115 | 10314 | 141 |
2290228 | 2290228 | 2022-03-09 | Pontotoc | Oklahoma | 40123 | 11857 | 125 |
2286235 | 2286235 | 2022-03-08 | Pontotoc | Mississippi | 28115 | 10314 | 141 |
2286976 | 2286976 | 2022-03-08 | Pontotoc | Oklahoma | 40123 | 11857 | 125 |
2282983 | 2282983 | 2022-03-07 | Pontotoc | Mississippi | 28115 | 10314 | 139 |
2283724 | 2283724 | 2022-03-07 | Pontotoc | Oklahoma | 40123 | 11857 | 125 |
2279730 | 2279730 | 2022-03-06 | Pontotoc | Mississippi | 28115 | 10276 | 139 |
2280472 | 2280472 | 2022-03-06 | Pontotoc | Oklahoma | 40123 | 11857 | 125 |
2276477 | 2276477 | 2022-03-05 | Pontotoc | Mississippi | 28115 | 10276 | 139 |
2277219 | 2277219 | 2022-03-05 | Pontotoc | Oklahoma | 40123 | 11857 | 125 |
2273224 | 2273224 | 2022-03-04 | Pontotoc | Mississippi | 28115 | 10276 | 139 |
2273966 | 2273966 | 2022-03-04 | Pontotoc | Oklahoma | 40123 | 11857 | 125 |
2269972 | 2269972 | 2022-03-03 | Pontotoc | Mississippi | 28115 | 10274 | 137 |
2270713 | 2270713 | 2022-03-03 | Pontotoc | Oklahoma | 40123 | 11857 | 125 |
2266719 | 2266719 | 2022-03-02 | Pontotoc | Mississippi | 28115 | 10241 | 137 |
2267461 | 2267461 | 2022-03-02 | Pontotoc | Oklahoma | 40123 | 11857 | 125 |
2263468 | 2263468 | 2022-03-01 | Pontotoc | Mississippi | 28115 | 10240 | 137 |
2264208 | 2264208 | 2022-03-01 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2260217 | 2260217 | 2022-02-28 | Pontotoc | Mississippi | 28115 | 10238 | 136 |
2260958 | 2260958 | 2022-02-28 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2256966 | 2256966 | 2022-02-27 | Pontotoc | Mississippi | 28115 | 10210 | 134 |
2257707 | 2257707 | 2022-02-27 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2253715 | 2253715 | 2022-02-26 | Pontotoc | Mississippi | 28115 | 10210 | 134 |
2254456 | 2254456 | 2022-02-26 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2250464 | 2250464 | 2022-02-25 | Pontotoc | Mississippi | 28115 | 10210 | 134 |
2251205 | 2251205 | 2022-02-25 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2247213 | 2247213 | 2022-02-24 | Pontotoc | Mississippi | 28115 | 10206 | 132 |
2247954 | 2247954 | 2022-02-24 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2243962 | 2243962 | 2022-02-23 | Pontotoc | Mississippi | 28115 | 10205 | 132 |
2244703 | 2244703 | 2022-02-23 | Pontotoc | Oklahoma | 40123 | 11787 | 120 |
2240711 | 2240711 | 2022-02-22 | Pontotoc | Mississippi | 28115 | 10194 | 131 |
2241452 | 2241452 | 2022-02-22 | Pontotoc | Oklahoma | 40123 | 11659 | 119 |
2237460 | 2237460 | 2022-02-21 | Pontotoc | Mississippi | 28115 | 10147 | 131 |
2238201 | 2238201 | 2022-02-21 | Pontotoc | Oklahoma | 40123 | 11659 | 119 |
2234209 | 2234209 | 2022-02-20 | Pontotoc | Mississippi | 28115 | 10147 | 131 |
2234950 | 2234950 | 2022-02-20 | Pontotoc | Oklahoma | 40123 | 11659 | 119 |
2230958 | 2230958 | 2022-02-19 | Pontotoc | Mississippi | 28115 | 10147 | 131 |
2231699 | 2231699 | 2022-02-19 | Pontotoc | Oklahoma | 40123 | 11659 | 119 |
2227707 | 2227707 | 2022-02-18 | Pontotoc | Mississippi | 28115 | 10147 | 131 |
2228448 | 2228448 | 2022-02-18 | Pontotoc | Oklahoma | 40123 | 11659 | 119 |
2224456 | 2224456 | 2022-02-17 | Pontotoc | Mississippi | 28115 | 10132 | 131 |
2225197 | 2225197 | 2022-02-17 | Pontotoc | Oklahoma | 40123 | 11659 | 119 |
2221205 | 2221205 | 2022-02-16 | Pontotoc | Mississippi | 28115 | 10131 | 131 |
2221946 | 2221946 | 2022-02-16 | Pontotoc | Oklahoma | 40123 | 11659 | 119 |
2217954 | 2217954 | 2022-02-15 | Pontotoc | Mississippi | 28115 | 10116 | 130 |
2218695 | 2218695 | 2022-02-15 | Pontotoc | Oklahoma | 40123 | 11464 | 116 |
2214703 | 2214703 | 2022-02-14 | Pontotoc | Mississippi | 28115 | 10081 | 129 |
2215444 | 2215444 | 2022-02-14 | Pontotoc | Oklahoma | 40123 | 11464 | 116 |
2211451 | 2211451 | 2022-02-13 | Pontotoc | Mississippi | 28115 | 10061 | 127 |
2212193 | 2212193 | 2022-02-13 | Pontotoc | Oklahoma | 40123 | 11464 | 116 |
2208198 | 2208198 | 2022-02-12 | Pontotoc | Mississippi | 28115 | 10061 | 127 |
2208940 | 2208940 | 2022-02-12 | Pontotoc | Oklahoma | 40123 | 11464 | 116 |
2204945 | 2204945 | 2022-02-11 | Pontotoc | Mississippi | 28115 | 10061 | 127 |
2205687 | 2205687 | 2022-02-11 | Pontotoc | Oklahoma | 40123 | 11464 | 116 |
2201692 | 2201692 | 2022-02-10 | Pontotoc | Mississippi | 28115 | 10048 | 127 |
2202434 | 2202434 | 2022-02-10 | Pontotoc | Oklahoma | 40123 | 11464 | 116 |
2198438 | 2198438 | 2022-02-09 | Pontotoc | Mississippi | 28115 | 10033 | 126 |
2199180 | 2199180 | 2022-02-09 | Pontotoc | Oklahoma | 40123 | 11464 | 116 |
2195184 | 2195184 | 2022-02-08 | Pontotoc | Mississippi | 28115 | 10019 | 126 |
2195926 | 2195926 | 2022-02-08 | Pontotoc | Oklahoma | 40123 | 11137 | 112 |
2191930 | 2191930 | 2022-02-07 | Pontotoc | Mississippi | 28115 | 9937 | 125 |
2192672 | 2192672 | 2022-02-07 | Pontotoc | Oklahoma | 40123 | 11137 | 112 |
2188677 | 2188677 | 2022-02-06 | Pontotoc | Mississippi | 28115 | 9703 | 125 |
2189418 | 2189418 | 2022-02-06 | Pontotoc | Oklahoma | 40123 | 11137 | 112 |
2185424 | 2185424 | 2022-02-05 | Pontotoc | Mississippi | 28115 | 9703 | 125 |
2186165 | 2186165 | 2022-02-05 | Pontotoc | Oklahoma | 40123 | 11137 | 112 |
2182172 | 2182172 | 2022-02-04 | Pontotoc | Mississippi | 28115 | 9703 | 125 |
2182913 | 2182913 | 2022-02-04 | Pontotoc | Oklahoma | 40123 | 11137 | 112 |
2178920 | 2178920 | 2022-02-03 | Pontotoc | Mississippi | 28115 | 9594 | 123 |
2179661 | 2179661 | 2022-02-03 | Pontotoc | Oklahoma | 40123 | 11137 | 112 |
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);