ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
920 rows where deaths = 20 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Coal 141
- Jefferson 105
- Nowata 84
- Noble 77
- Blaine 70
- Pushmataha 49
- Caddo 39
- Johnston 37
- Pittsburg 29
- Love 28
- Woodward 22
- Choctaw 21
- Delaware 18
- Cotton 14
- Craig 14
- Greer 14
- Okfuskee 14
- Woods 14
- Adair 11
- Stephens 11
- McClain 9
- Garvin 8
- Murray 8
- Okmulgee 8
- Haskell 7
- Hughes 7
- Tillman 7
- Beckham 6
- Garfield 5
- Carter 4
- …
state 1
- Oklahoma · 920 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290181 | 2290181 | 2022-03-09 | Coal | Oklahoma | 40029 | 1646 | 20 |
2286929 | 2286929 | 2022-03-08 | Coal | Oklahoma | 40029 | 1646 | 20 |
2283677 | 2283677 | 2022-03-07 | Coal | Oklahoma | 40029 | 1646 | 20 |
2280425 | 2280425 | 2022-03-06 | Coal | Oklahoma | 40029 | 1646 | 20 |
2277172 | 2277172 | 2022-03-05 | Coal | Oklahoma | 40029 | 1646 | 20 |
2273919 | 2273919 | 2022-03-04 | Coal | Oklahoma | 40029 | 1646 | 20 |
2270666 | 2270666 | 2022-03-03 | Coal | Oklahoma | 40029 | 1646 | 20 |
2267414 | 2267414 | 2022-03-02 | Coal | Oklahoma | 40029 | 1646 | 20 |
2264161 | 2264161 | 2022-03-01 | Coal | Oklahoma | 40029 | 1637 | 20 |
2260911 | 2260911 | 2022-02-28 | Coal | Oklahoma | 40029 | 1637 | 20 |
2257660 | 2257660 | 2022-02-27 | Coal | Oklahoma | 40029 | 1637 | 20 |
2254409 | 2254409 | 2022-02-26 | Coal | Oklahoma | 40029 | 1637 | 20 |
2251158 | 2251158 | 2022-02-25 | Coal | Oklahoma | 40029 | 1637 | 20 |
2247907 | 2247907 | 2022-02-24 | Coal | Oklahoma | 40029 | 1637 | 20 |
2244656 | 2244656 | 2022-02-23 | Coal | Oklahoma | 40029 | 1637 | 20 |
2241405 | 2241405 | 2022-02-22 | Coal | Oklahoma | 40029 | 1621 | 20 |
2238154 | 2238154 | 2022-02-21 | Coal | Oklahoma | 40029 | 1621 | 20 |
2234903 | 2234903 | 2022-02-20 | Coal | Oklahoma | 40029 | 1621 | 20 |
2231652 | 2231652 | 2022-02-19 | Coal | Oklahoma | 40029 | 1621 | 20 |
2228401 | 2228401 | 2022-02-18 | Coal | Oklahoma | 40029 | 1621 | 20 |
2225150 | 2225150 | 2022-02-17 | Coal | Oklahoma | 40029 | 1621 | 20 |
2221899 | 2221899 | 2022-02-16 | Coal | Oklahoma | 40029 | 1621 | 20 |
2218648 | 2218648 | 2022-02-15 | Coal | Oklahoma | 40029 | 1569 | 20 |
2215397 | 2215397 | 2022-02-14 | Coal | Oklahoma | 40029 | 1569 | 20 |
2212146 | 2212146 | 2022-02-13 | Coal | Oklahoma | 40029 | 1569 | 20 |
2208893 | 2208893 | 2022-02-12 | Coal | Oklahoma | 40029 | 1569 | 20 |
2205640 | 2205640 | 2022-02-11 | Coal | Oklahoma | 40029 | 1569 | 20 |
2202387 | 2202387 | 2022-02-10 | Coal | Oklahoma | 40029 | 1569 | 20 |
2199133 | 2199133 | 2022-02-09 | Coal | Oklahoma | 40029 | 1569 | 20 |
2195879 | 2195879 | 2022-02-08 | Coal | Oklahoma | 40029 | 1510 | 20 |
2192625 | 2192625 | 2022-02-07 | Coal | Oklahoma | 40029 | 1510 | 20 |
2189371 | 2189371 | 2022-02-06 | Coal | Oklahoma | 40029 | 1510 | 20 |
2186118 | 2186118 | 2022-02-05 | Coal | Oklahoma | 40029 | 1510 | 20 |
2182866 | 2182866 | 2022-02-04 | Coal | Oklahoma | 40029 | 1510 | 20 |
2179614 | 2179614 | 2022-02-03 | Coal | Oklahoma | 40029 | 1510 | 20 |
2176363 | 2176363 | 2022-02-02 | Coal | Oklahoma | 40029 | 1510 | 20 |
2173109 | 2173109 | 2022-02-01 | Coal | Oklahoma | 40029 | 1382 | 20 |
2173128 | 2173128 | 2022-02-01 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2169857 | 2169857 | 2022-01-31 | Coal | Oklahoma | 40029 | 1382 | 20 |
2169876 | 2169876 | 2022-01-31 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2166602 | 2166602 | 2022-01-30 | Coal | Oklahoma | 40029 | 1382 | 20 |
2166621 | 2166621 | 2022-01-30 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2163347 | 2163347 | 2022-01-29 | Coal | Oklahoma | 40029 | 1382 | 20 |
2163366 | 2163366 | 2022-01-29 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2160092 | 2160092 | 2022-01-28 | Coal | Oklahoma | 40029 | 1382 | 20 |
2160111 | 2160111 | 2022-01-28 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2156837 | 2156837 | 2022-01-27 | Coal | Oklahoma | 40029 | 1382 | 20 |
2156856 | 2156856 | 2022-01-27 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2153584 | 2153584 | 2022-01-26 | Coal | Oklahoma | 40029 | 1382 | 20 |
2153603 | 2153603 | 2022-01-26 | Jefferson | Oklahoma | 40067 | 1172 | 20 |
2150332 | 2150332 | 2022-01-25 | Coal | Oklahoma | 40029 | 1249 | 20 |
2150351 | 2150351 | 2022-01-25 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2147080 | 2147080 | 2022-01-24 | Coal | Oklahoma | 40029 | 1249 | 20 |
2147099 | 2147099 | 2022-01-24 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2143826 | 2143826 | 2022-01-23 | Coal | Oklahoma | 40029 | 1249 | 20 |
2143845 | 2143845 | 2022-01-23 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2140571 | 2140571 | 2022-01-22 | Coal | Oklahoma | 40029 | 1249 | 20 |
2140590 | 2140590 | 2022-01-22 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2137315 | 2137315 | 2022-01-21 | Coal | Oklahoma | 40029 | 1249 | 20 |
2137334 | 2137334 | 2022-01-21 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2134061 | 2134061 | 2022-01-20 | Coal | Oklahoma | 40029 | 1249 | 20 |
2134080 | 2134080 | 2022-01-20 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2130809 | 2130809 | 2022-01-19 | Coal | Oklahoma | 40029 | 1249 | 20 |
2130828 | 2130828 | 2022-01-19 | Jefferson | Oklahoma | 40067 | 1062 | 20 |
2127555 | 2127555 | 2022-01-18 | Coal | Oklahoma | 40029 | 1171 | 20 |
2127574 | 2127574 | 2022-01-18 | Jefferson | Oklahoma | 40067 | 1017 | 20 |
2124303 | 2124303 | 2022-01-17 | Coal | Oklahoma | 40029 | 1171 | 20 |
2124322 | 2124322 | 2022-01-17 | Jefferson | Oklahoma | 40067 | 1017 | 20 |
2121051 | 2121051 | 2022-01-16 | Coal | Oklahoma | 40029 | 1171 | 20 |
2121070 | 2121070 | 2022-01-16 | Jefferson | Oklahoma | 40067 | 1017 | 20 |
2117799 | 2117799 | 2022-01-15 | Coal | Oklahoma | 40029 | 1171 | 20 |
2117818 | 2117818 | 2022-01-15 | Jefferson | Oklahoma | 40067 | 1017 | 20 |
2114548 | 2114548 | 2022-01-14 | Coal | Oklahoma | 40029 | 1171 | 20 |
2114567 | 2114567 | 2022-01-14 | Jefferson | Oklahoma | 40067 | 1017 | 20 |
2111296 | 2111296 | 2022-01-13 | Coal | Oklahoma | 40029 | 1171 | 20 |
2111315 | 2111315 | 2022-01-13 | Jefferson | Oklahoma | 40067 | 1017 | 20 |
2108044 | 2108044 | 2022-01-12 | Coal | Oklahoma | 40029 | 1171 | 20 |
2108063 | 2108063 | 2022-01-12 | Jefferson | Oklahoma | 40067 | 1017 | 20 |
2104793 | 2104793 | 2022-01-11 | Coal | Oklahoma | 40029 | 1129 | 20 |
2104812 | 2104812 | 2022-01-11 | Jefferson | Oklahoma | 40067 | 991 | 20 |
2101542 | 2101542 | 2022-01-10 | Coal | Oklahoma | 40029 | 1129 | 20 |
2101561 | 2101561 | 2022-01-10 | Jefferson | Oklahoma | 40067 | 991 | 20 |
2098291 | 2098291 | 2022-01-09 | Coal | Oklahoma | 40029 | 1129 | 20 |
2098310 | 2098310 | 2022-01-09 | Jefferson | Oklahoma | 40067 | 991 | 20 |
2095039 | 2095039 | 2022-01-08 | Coal | Oklahoma | 40029 | 1129 | 20 |
2095058 | 2095058 | 2022-01-08 | Jefferson | Oklahoma | 40067 | 991 | 20 |
2091787 | 2091787 | 2022-01-07 | Coal | Oklahoma | 40029 | 1129 | 20 |
2091806 | 2091806 | 2022-01-07 | Jefferson | Oklahoma | 40067 | 991 | 20 |
2088535 | 2088535 | 2022-01-06 | Coal | Oklahoma | 40029 | 1129 | 20 |
2088554 | 2088554 | 2022-01-06 | Jefferson | Oklahoma | 40067 | 991 | 20 |
2085284 | 2085284 | 2022-01-05 | Coal | Oklahoma | 40029 | 1129 | 20 |
2085303 | 2085303 | 2022-01-05 | Jefferson | Oklahoma | 40067 | 991 | 20 |
2082032 | 2082032 | 2022-01-04 | Coal | Oklahoma | 40029 | 1105 | 20 |
2082051 | 2082051 | 2022-01-04 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2078780 | 2078780 | 2022-01-03 | Coal | Oklahoma | 40029 | 1105 | 20 |
2078799 | 2078799 | 2022-01-03 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2075529 | 2075529 | 2022-01-02 | Coal | Oklahoma | 40029 | 1105 | 20 |
2075548 | 2075548 | 2022-01-02 | Jefferson | Oklahoma | 40067 | 976 | 20 |
2072278 | 2072278 | 2022-01-01 | Coal | Oklahoma | 40029 | 1105 | 20 |
2072297 | 2072297 | 2022-01-01 | Jefferson | Oklahoma | 40067 | 976 | 20 |
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);