ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Alfalfa", fips = 40003 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501734 | 2501734 | 2022-05-13 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2498476 | 2498476 | 2022-05-12 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2495218 | 2495218 | 2022-05-11 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2491960 | 2491960 | 2022-05-10 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2488702 | 2488702 | 2022-05-09 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2485445 | 2485445 | 2022-05-08 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2482187 | 2482187 | 2022-05-07 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2478929 | 2478929 | 2022-05-06 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2475671 | 2475671 | 2022-05-05 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
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 |
2309680 | 2309680 | 2022-03-15 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2306427 | 2306427 | 2022-03-14 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2303176 | 2303176 | 2022-03-13 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2299924 | 2299924 | 2022-03-12 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2296672 | 2296672 | 2022-03-11 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2293420 | 2293420 | 2022-03-10 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2290168 | 2290168 | 2022-03-09 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2286916 | 2286916 | 2022-03-08 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2283664 | 2283664 | 2022-03-07 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2280412 | 2280412 | 2022-03-06 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2277159 | 2277159 | 2022-03-05 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2273906 | 2273906 | 2022-03-04 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2270653 | 2270653 | 2022-03-03 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2267401 | 2267401 | 2022-03-02 | Alfalfa | Oklahoma | 40003 | 1704 | 14 |
2264148 | 2264148 | 2022-03-01 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2260898 | 2260898 | 2022-02-28 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2257647 | 2257647 | 2022-02-27 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2254396 | 2254396 | 2022-02-26 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2251145 | 2251145 | 2022-02-25 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2247894 | 2247894 | 2022-02-24 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2244643 | 2244643 | 2022-02-23 | Alfalfa | Oklahoma | 40003 | 1700 | 12 |
2241392 | 2241392 | 2022-02-22 | Alfalfa | Oklahoma | 40003 | 1698 | 11 |
2238141 | 2238141 | 2022-02-21 | Alfalfa | Oklahoma | 40003 | 1698 | 11 |
2234890 | 2234890 | 2022-02-20 | Alfalfa | Oklahoma | 40003 | 1698 | 11 |
2231639 | 2231639 | 2022-02-19 | Alfalfa | Oklahoma | 40003 | 1698 | 11 |
2228388 | 2228388 | 2022-02-18 | Alfalfa | Oklahoma | 40003 | 1698 | 11 |
2225137 | 2225137 | 2022-02-17 | Alfalfa | Oklahoma | 40003 | 1698 | 11 |
2221886 | 2221886 | 2022-02-16 | Alfalfa | Oklahoma | 40003 | 1698 | 11 |
2218635 | 2218635 | 2022-02-15 | Alfalfa | Oklahoma | 40003 | 1689 | 11 |
2215384 | 2215384 | 2022-02-14 | Alfalfa | Oklahoma | 40003 | 1689 | 11 |
2212133 | 2212133 | 2022-02-13 | Alfalfa | Oklahoma | 40003 | 1689 | 11 |
2208880 | 2208880 | 2022-02-12 | Alfalfa | Oklahoma | 40003 | 1689 | 11 |
2205627 | 2205627 | 2022-02-11 | Alfalfa | Oklahoma | 40003 | 1689 | 11 |
2202374 | 2202374 | 2022-02-10 | Alfalfa | Oklahoma | 40003 | 1689 | 11 |
2199120 | 2199120 | 2022-02-09 | Alfalfa | Oklahoma | 40003 | 1689 | 11 |
2195866 | 2195866 | 2022-02-08 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2192612 | 2192612 | 2022-02-07 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2189358 | 2189358 | 2022-02-06 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2186105 | 2186105 | 2022-02-05 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2182853 | 2182853 | 2022-02-04 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2179601 | 2179601 | 2022-02-03 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
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);