ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
699 rows where deaths = 14 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Dewey 161
- Alfalfa 64
- Coal 43
- Sequoyah 43
- Pushmataha 37
- Tillman 35
- Cotton 29
- Grant 29
- Latimer 28
- Choctaw 25
- Noble 15
- McIntosh 14
- Roger Mills 14
- Okmulgee 13
- Adair 12
- Muskogee 12
- Pottawatomie 10
- Kiowa 9
- Nowata 9
- Hughes 7
- Caddo 6
- Garfield 6
- Johnston 6
- Bryan 5
- Creek 5
- Payne 5
- Cherokee 4
- Grady 4
- Jackson 4
- Murray 4
- …
state 1
- Oklahoma · 699 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472414 | 2472414 | 2022-05-04 | Alfalfa | Oklahoma | 40003 | 1716 | 14 |
2469158 | 2469158 | 2022-05-03 | Alfalfa | Oklahoma | 40003 | 1716 | 14 |
2465902 | 2465902 | 2022-05-02 | Alfalfa | Oklahoma | 40003 | 1716 | 14 |
2462647 | 2462647 | 2022-05-01 | Alfalfa | Oklahoma | 40003 | 1716 | 14 |
2459391 | 2459391 | 2022-04-30 | Alfalfa | Oklahoma | 40003 | 1716 | 14 |
2456135 | 2456135 | 2022-04-29 | Alfalfa | Oklahoma | 40003 | 1716 | 14 |
2452879 | 2452879 | 2022-04-28 | Alfalfa | Oklahoma | 40003 | 1716 | 14 |
2449623 | 2449623 | 2022-04-27 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2446366 | 2446366 | 2022-04-26 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2443111 | 2443111 | 2022-04-25 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2439855 | 2439855 | 2022-04-24 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2436599 | 2436599 | 2022-04-23 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2433343 | 2433343 | 2022-04-22 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2430087 | 2430087 | 2022-04-21 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2426831 | 2426831 | 2022-04-20 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2423575 | 2423575 | 2022-04-19 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2420318 | 2420318 | 2022-04-18 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2417063 | 2417063 | 2022-04-17 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2413807 | 2413807 | 2022-04-16 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2410551 | 2410551 | 2022-04-15 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2407295 | 2407295 | 2022-04-14 | Alfalfa | Oklahoma | 40003 | 1715 | 14 |
2404039 | 2404039 | 2022-04-13 | Alfalfa | Oklahoma | 40003 | 1714 | 14 |
2400784 | 2400784 | 2022-04-12 | Alfalfa | Oklahoma | 40003 | 1714 | 14 |
2397529 | 2397529 | 2022-04-11 | Alfalfa | Oklahoma | 40003 | 1714 | 14 |
2394274 | 2394274 | 2022-04-10 | Alfalfa | Oklahoma | 40003 | 1714 | 14 |
2391018 | 2391018 | 2022-04-09 | Alfalfa | Oklahoma | 40003 | 1714 | 14 |
2387762 | 2387762 | 2022-04-08 | Alfalfa | Oklahoma | 40003 | 1714 | 14 |
2384507 | 2384507 | 2022-04-07 | Alfalfa | Oklahoma | 40003 | 1714 | 14 |
2381252 | 2381252 | 2022-04-06 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2377997 | 2377997 | 2022-04-05 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2374743 | 2374743 | 2022-04-04 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2371491 | 2371491 | 2022-04-03 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2368238 | 2368238 | 2022-04-02 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2364985 | 2364985 | 2022-04-01 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2361732 | 2361732 | 2022-03-31 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2358478 | 2358478 | 2022-03-30 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2355224 | 2355224 | 2022-03-29 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2351971 | 2351971 | 2022-03-28 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2348719 | 2348719 | 2022-03-27 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2345466 | 2345466 | 2022-03-26 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2342213 | 2342213 | 2022-03-25 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2338960 | 2338960 | 2022-03-24 | Alfalfa | Oklahoma | 40003 | 1711 | 14 |
2335706 | 2335706 | 2022-03-23 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2332452 | 2332452 | 2022-03-22 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2329199 | 2329199 | 2022-03-21 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2325947 | 2325947 | 2022-03-20 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2322694 | 2322694 | 2022-03-19 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2319440 | 2319440 | 2022-03-18 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2316186 | 2316186 | 2022-03-17 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2312933 | 2312933 | 2022-03-16 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2312958 | 2312958 | 2022-03-16 | Grant | Oklahoma | 40053 | 1028 | 14 |
2309680 | 2309680 | 2022-03-15 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2309705 | 2309705 | 2022-03-15 | Grant | Oklahoma | 40053 | 1028 | 14 |
2306427 | 2306427 | 2022-03-14 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2306452 | 2306452 | 2022-03-14 | Grant | Oklahoma | 40053 | 1028 | 14 |
2303176 | 2303176 | 2022-03-13 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2303201 | 2303201 | 2022-03-13 | Grant | Oklahoma | 40053 | 1028 | 14 |
2299924 | 2299924 | 2022-03-12 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2299949 | 2299949 | 2022-03-12 | Grant | Oklahoma | 40053 | 1028 | 14 |
2296672 | 2296672 | 2022-03-11 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2296697 | 2296697 | 2022-03-11 | Grant | Oklahoma | 40053 | 1028 | 14 |
2293420 | 2293420 | 2022-03-10 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2293445 | 2293445 | 2022-03-10 | Grant | Oklahoma | 40053 | 1028 | 14 |
2290168 | 2290168 | 2022-03-09 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2290193 | 2290193 | 2022-03-09 | Grant | Oklahoma | 40053 | 1027 | 14 |
2286916 | 2286916 | 2022-03-08 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2286941 | 2286941 | 2022-03-08 | Grant | Oklahoma | 40053 | 1027 | 14 |
2283664 | 2283664 | 2022-03-07 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2283689 | 2283689 | 2022-03-07 | Grant | Oklahoma | 40053 | 1027 | 14 |
2280412 | 2280412 | 2022-03-06 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2280437 | 2280437 | 2022-03-06 | Grant | Oklahoma | 40053 | 1027 | 14 |
2277159 | 2277159 | 2022-03-05 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2277184 | 2277184 | 2022-03-05 | Grant | Oklahoma | 40053 | 1027 | 14 |
2273906 | 2273906 | 2022-03-04 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2273931 | 2273931 | 2022-03-04 | Grant | Oklahoma | 40053 | 1027 | 14 |
2270653 | 2270653 | 2022-03-03 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2270678 | 2270678 | 2022-03-03 | Grant | Oklahoma | 40053 | 1027 | 14 |
2267401 | 2267401 | 2022-03-02 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2267426 | 2267426 | 2022-03-02 | Grant | Oklahoma | 40053 | 1027 | 14 |
2264173 | 2264173 | 2022-03-01 | Grant | Oklahoma | 40053 | 1021 | 14 |
2264211 | 2264211 | 2022-03-01 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2260923 | 2260923 | 2022-02-28 | Grant | Oklahoma | 40053 | 1021 | 14 |
2260961 | 2260961 | 2022-02-28 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2257672 | 2257672 | 2022-02-27 | Grant | Oklahoma | 40053 | 1021 | 14 |
2257710 | 2257710 | 2022-02-27 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2254421 | 2254421 | 2022-02-26 | Grant | Oklahoma | 40053 | 1021 | 14 |
2254459 | 2254459 | 2022-02-26 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2251170 | 2251170 | 2022-02-25 | Grant | Oklahoma | 40053 | 1021 | 14 |
2251208 | 2251208 | 2022-02-25 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2247919 | 2247919 | 2022-02-24 | Grant | Oklahoma | 40053 | 1021 | 14 |
2247957 | 2247957 | 2022-02-24 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2244668 | 2244668 | 2022-02-23 | Grant | Oklahoma | 40053 | 1021 | 14 |
2244706 | 2244706 | 2022-02-23 | Roger Mills | Oklahoma | 40129 | 860 | 14 |
2241417 | 2241417 | 2022-02-22 | Grant | Oklahoma | 40053 | 1019 | 14 |
2241455 | 2241455 | 2022-02-22 | Roger Mills | Oklahoma | 40129 | 858 | 14 |
2238166 | 2238166 | 2022-02-21 | Grant | Oklahoma | 40053 | 1019 | 14 |
2238204 | 2238204 | 2022-02-21 | Roger Mills | Oklahoma | 40129 | 858 | 14 |
2234915 | 2234915 | 2022-02-20 | Grant | Oklahoma | 40053 | 1019 | 14 |
2234953 | 2234953 | 2022-02-20 | Roger Mills | Oklahoma | 40129 | 858 | 14 |
2231664 | 2231664 | 2022-02-19 | Grant | Oklahoma | 40053 | 1019 | 14 |
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);