ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 47131 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 |
---|---|---|---|---|---|---|---|
2502176 | 2502176 | 2022-05-13 | Obion | Tennessee | 47131 | 10786 | 195 |
2498918 | 2498918 | 2022-05-12 | Obion | Tennessee | 47131 | 10786 | 195 |
2495660 | 2495660 | 2022-05-11 | Obion | Tennessee | 47131 | 10786 | 195 |
2492402 | 2492402 | 2022-05-10 | Obion | Tennessee | 47131 | 10780 | 195 |
2489144 | 2489144 | 2022-05-09 | Obion | Tennessee | 47131 | 10780 | 195 |
2485887 | 2485887 | 2022-05-08 | Obion | Tennessee | 47131 | 10780 | 195 |
2482629 | 2482629 | 2022-05-07 | Obion | Tennessee | 47131 | 10780 | 195 |
2479371 | 2479371 | 2022-05-06 | Obion | Tennessee | 47131 | 10780 | 195 |
2476113 | 2476113 | 2022-05-05 | Obion | Tennessee | 47131 | 10780 | 195 |
2472856 | 2472856 | 2022-05-04 | Obion | Tennessee | 47131 | 10780 | 195 |
2469600 | 2469600 | 2022-05-03 | Obion | Tennessee | 47131 | 10770 | 195 |
2466344 | 2466344 | 2022-05-02 | Obion | Tennessee | 47131 | 10770 | 195 |
2463089 | 2463089 | 2022-05-01 | Obion | Tennessee | 47131 | 10770 | 195 |
2459833 | 2459833 | 2022-04-30 | Obion | Tennessee | 47131 | 10770 | 195 |
2456577 | 2456577 | 2022-04-29 | Obion | Tennessee | 47131 | 10770 | 195 |
2453321 | 2453321 | 2022-04-28 | Obion | Tennessee | 47131 | 10770 | 195 |
2450065 | 2450065 | 2022-04-27 | Obion | Tennessee | 47131 | 10770 | 195 |
2446808 | 2446808 | 2022-04-26 | Obion | Tennessee | 47131 | 10765 | 194 |
2443553 | 2443553 | 2022-04-25 | Obion | Tennessee | 47131 | 10765 | 194 |
2440297 | 2440297 | 2022-04-24 | Obion | Tennessee | 47131 | 10765 | 194 |
2437041 | 2437041 | 2022-04-23 | Obion | Tennessee | 47131 | 10765 | 194 |
2433785 | 2433785 | 2022-04-22 | Obion | Tennessee | 47131 | 10765 | 194 |
2430529 | 2430529 | 2022-04-21 | Obion | Tennessee | 47131 | 10765 | 194 |
2427273 | 2427273 | 2022-04-20 | Obion | Tennessee | 47131 | 10765 | 194 |
2424017 | 2424017 | 2022-04-19 | Obion | Tennessee | 47131 | 10763 | 193 |
2420761 | 2420761 | 2022-04-18 | Obion | Tennessee | 47131 | 10763 | 193 |
2417505 | 2417505 | 2022-04-17 | Obion | Tennessee | 47131 | 10763 | 193 |
2414249 | 2414249 | 2022-04-16 | Obion | Tennessee | 47131 | 10763 | 193 |
2410993 | 2410993 | 2022-04-15 | Obion | Tennessee | 47131 | 10763 | 193 |
2407737 | 2407737 | 2022-04-14 | Obion | Tennessee | 47131 | 10763 | 193 |
2404481 | 2404481 | 2022-04-13 | Obion | Tennessee | 47131 | 10763 | 193 |
2401226 | 2401226 | 2022-04-12 | Obion | Tennessee | 47131 | 10764 | 189 |
2397971 | 2397971 | 2022-04-11 | Obion | Tennessee | 47131 | 10764 | 189 |
2394716 | 2394716 | 2022-04-10 | Obion | Tennessee | 47131 | 10764 | 189 |
2391460 | 2391460 | 2022-04-09 | Obion | Tennessee | 47131 | 10764 | 189 |
2388204 | 2388204 | 2022-04-08 | Obion | Tennessee | 47131 | 10764 | 189 |
2384949 | 2384949 | 2022-04-07 | Obion | Tennessee | 47131 | 10764 | 189 |
2381694 | 2381694 | 2022-04-06 | Obion | Tennessee | 47131 | 10764 | 189 |
2378439 | 2378439 | 2022-04-05 | Obion | Tennessee | 47131 | 10757 | 189 |
2375185 | 2375185 | 2022-04-04 | Obion | Tennessee | 47131 | 10757 | 189 |
2371933 | 2371933 | 2022-04-03 | Obion | Tennessee | 47131 | 10757 | 189 |
2368680 | 2368680 | 2022-04-02 | Obion | Tennessee | 47131 | 10757 | 189 |
2365427 | 2365427 | 2022-04-01 | Obion | Tennessee | 47131 | 10757 | 189 |
2362174 | 2362174 | 2022-03-31 | Obion | Tennessee | 47131 | 10757 | 189 |
2358920 | 2358920 | 2022-03-30 | Obion | Tennessee | 47131 | 10757 | 189 |
2355666 | 2355666 | 2022-03-29 | Obion | Tennessee | 47131 | 10753 | 187 |
2352413 | 2352413 | 2022-03-28 | Obion | Tennessee | 47131 | 10753 | 187 |
2349161 | 2349161 | 2022-03-27 | Obion | Tennessee | 47131 | 10753 | 187 |
2345908 | 2345908 | 2022-03-26 | Obion | Tennessee | 47131 | 10753 | 187 |
2342655 | 2342655 | 2022-03-25 | Obion | Tennessee | 47131 | 10753 | 187 |
2339402 | 2339402 | 2022-03-24 | Obion | Tennessee | 47131 | 10753 | 187 |
2336148 | 2336148 | 2022-03-23 | Obion | Tennessee | 47131 | 10753 | 187 |
2332894 | 2332894 | 2022-03-22 | Obion | Tennessee | 47131 | 10750 | 185 |
2329641 | 2329641 | 2022-03-21 | Obion | Tennessee | 47131 | 10750 | 185 |
2326389 | 2326389 | 2022-03-20 | Obion | Tennessee | 47131 | 10750 | 185 |
2323136 | 2323136 | 2022-03-19 | Obion | Tennessee | 47131 | 10750 | 185 |
2319882 | 2319882 | 2022-03-18 | Obion | Tennessee | 47131 | 10750 | 185 |
2316628 | 2316628 | 2022-03-17 | Obion | Tennessee | 47131 | 10750 | 185 |
2313375 | 2313375 | 2022-03-16 | Obion | Tennessee | 47131 | 10750 | 185 |
2310122 | 2310122 | 2022-03-15 | Obion | Tennessee | 47131 | 10742 | 179 |
2306869 | 2306869 | 2022-03-14 | Obion | Tennessee | 47131 | 10742 | 179 |
2303618 | 2303618 | 2022-03-13 | Obion | Tennessee | 47131 | 10742 | 179 |
2300366 | 2300366 | 2022-03-12 | Obion | Tennessee | 47131 | 10742 | 179 |
2297114 | 2297114 | 2022-03-11 | Obion | Tennessee | 47131 | 10742 | 179 |
2293862 | 2293862 | 2022-03-10 | Obion | Tennessee | 47131 | 10742 | 179 |
2290610 | 2290610 | 2022-03-09 | Obion | Tennessee | 47131 | 10742 | 179 |
2287358 | 2287358 | 2022-03-08 | Obion | Tennessee | 47131 | 10724 | 179 |
2284106 | 2284106 | 2022-03-07 | Obion | Tennessee | 47131 | 10724 | 179 |
2280854 | 2280854 | 2022-03-06 | Obion | Tennessee | 47131 | 10724 | 179 |
2277601 | 2277601 | 2022-03-05 | Obion | Tennessee | 47131 | 10724 | 179 |
2274348 | 2274348 | 2022-03-04 | Obion | Tennessee | 47131 | 10724 | 179 |
2271095 | 2271095 | 2022-03-03 | Obion | Tennessee | 47131 | 10724 | 179 |
2267843 | 2267843 | 2022-03-02 | Obion | Tennessee | 47131 | 10724 | 179 |
2264590 | 2264590 | 2022-03-01 | Obion | Tennessee | 47131 | 10659 | 168 |
2261340 | 2261340 | 2022-02-28 | Obion | Tennessee | 47131 | 10659 | 168 |
2258089 | 2258089 | 2022-02-27 | Obion | Tennessee | 47131 | 10659 | 168 |
2254838 | 2254838 | 2022-02-26 | Obion | Tennessee | 47131 | 10659 | 168 |
2251587 | 2251587 | 2022-02-25 | Obion | Tennessee | 47131 | 10659 | 168 |
2248336 | 2248336 | 2022-02-24 | Obion | Tennessee | 47131 | 10659 | 168 |
2245085 | 2245085 | 2022-02-23 | Obion | Tennessee | 47131 | 10659 | 168 |
2241834 | 2241834 | 2022-02-22 | Obion | Tennessee | 47131 | 10558 | 163 |
2238583 | 2238583 | 2022-02-21 | Obion | Tennessee | 47131 | 10558 | 163 |
2235332 | 2235332 | 2022-02-20 | Obion | Tennessee | 47131 | 10558 | 163 |
2232081 | 2232081 | 2022-02-19 | Obion | Tennessee | 47131 | 10558 | 163 |
2228830 | 2228830 | 2022-02-18 | Obion | Tennessee | 47131 | 10558 | 163 |
2225579 | 2225579 | 2022-02-17 | Obion | Tennessee | 47131 | 10558 | 163 |
2222328 | 2222328 | 2022-02-16 | Obion | Tennessee | 47131 | 10558 | 163 |
2219077 | 2219077 | 2022-02-15 | Obion | Tennessee | 47131 | 10418 | 161 |
2215826 | 2215826 | 2022-02-14 | Obion | Tennessee | 47131 | 10418 | 161 |
2212575 | 2212575 | 2022-02-13 | Obion | Tennessee | 47131 | 10418 | 161 |
2209322 | 2209322 | 2022-02-12 | Obion | Tennessee | 47131 | 10418 | 161 |
2206069 | 2206069 | 2022-02-11 | Obion | Tennessee | 47131 | 10418 | 161 |
2202816 | 2202816 | 2022-02-10 | Obion | Tennessee | 47131 | 10418 | 161 |
2199562 | 2199562 | 2022-02-09 | Obion | Tennessee | 47131 | 10418 | 161 |
2196308 | 2196308 | 2022-02-08 | Obion | Tennessee | 47131 | 10086 | 157 |
2193054 | 2193054 | 2022-02-07 | Obion | Tennessee | 47131 | 10086 | 157 |
2189800 | 2189800 | 2022-02-06 | Obion | Tennessee | 47131 | 10086 | 157 |
2186547 | 2186547 | 2022-02-05 | Obion | Tennessee | 47131 | 10086 | 157 |
2183295 | 2183295 | 2022-02-04 | Obion | Tennessee | 47131 | 10086 | 157 |
2180043 | 2180043 | 2022-02-03 | Obion | Tennessee | 47131 | 10086 | 157 |
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);