ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Cotton" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501749 | 2501749 | 2022-05-13 | Cotton | Oklahoma | 40033 | 1464 | 29 |
2498491 | 2498491 | 2022-05-12 | Cotton | Oklahoma | 40033 | 1464 | 29 |
2495233 | 2495233 | 2022-05-11 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2491975 | 2491975 | 2022-05-10 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2488717 | 2488717 | 2022-05-09 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2485460 | 2485460 | 2022-05-08 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2482202 | 2482202 | 2022-05-07 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2478944 | 2478944 | 2022-05-06 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2475686 | 2475686 | 2022-05-05 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2472429 | 2472429 | 2022-05-04 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2469173 | 2469173 | 2022-05-03 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2465917 | 2465917 | 2022-05-02 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2462662 | 2462662 | 2022-05-01 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2459406 | 2459406 | 2022-04-30 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2456150 | 2456150 | 2022-04-29 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2452894 | 2452894 | 2022-04-28 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2449638 | 2449638 | 2022-04-27 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2446381 | 2446381 | 2022-04-26 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2443126 | 2443126 | 2022-04-25 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2439870 | 2439870 | 2022-04-24 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2436614 | 2436614 | 2022-04-23 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2433358 | 2433358 | 2022-04-22 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2430102 | 2430102 | 2022-04-21 | Cotton | Oklahoma | 40033 | 1461 | 29 |
2426846 | 2426846 | 2022-04-20 | Cotton | Oklahoma | 40033 | 1454 | 29 |
2423590 | 2423590 | 2022-04-19 | Cotton | Oklahoma | 40033 | 1454 | 29 |
2420333 | 2420333 | 2022-04-18 | Cotton | Oklahoma | 40033 | 1454 | 29 |
2417078 | 2417078 | 2022-04-17 | Cotton | Oklahoma | 40033 | 1454 | 29 |
2413822 | 2413822 | 2022-04-16 | Cotton | Oklahoma | 40033 | 1454 | 29 |
2410566 | 2410566 | 2022-04-15 | Cotton | Oklahoma | 40033 | 1454 | 29 |
2407310 | 2407310 | 2022-04-14 | Cotton | Oklahoma | 40033 | 1454 | 29 |
2404054 | 2404054 | 2022-04-13 | Cotton | Oklahoma | 40033 | 1437 | 28 |
2400799 | 2400799 | 2022-04-12 | Cotton | Oklahoma | 40033 | 1437 | 28 |
2397544 | 2397544 | 2022-04-11 | Cotton | Oklahoma | 40033 | 1437 | 28 |
2394289 | 2394289 | 2022-04-10 | Cotton | Oklahoma | 40033 | 1437 | 28 |
2391033 | 2391033 | 2022-04-09 | Cotton | Oklahoma | 40033 | 1437 | 28 |
2387777 | 2387777 | 2022-04-08 | Cotton | Oklahoma | 40033 | 1437 | 28 |
2384522 | 2384522 | 2022-04-07 | Cotton | Oklahoma | 40033 | 1437 | 28 |
2381267 | 2381267 | 2022-04-06 | Cotton | Oklahoma | 40033 | 1438 | 27 |
2378012 | 2378012 | 2022-04-05 | Cotton | Oklahoma | 40033 | 1438 | 27 |
2374758 | 2374758 | 2022-04-04 | Cotton | Oklahoma | 40033 | 1438 | 27 |
2371506 | 2371506 | 2022-04-03 | Cotton | Oklahoma | 40033 | 1438 | 27 |
2368253 | 2368253 | 2022-04-02 | Cotton | Oklahoma | 40033 | 1438 | 27 |
2365000 | 2365000 | 2022-04-01 | Cotton | Oklahoma | 40033 | 1438 | 27 |
2361747 | 2361747 | 2022-03-31 | Cotton | Oklahoma | 40033 | 1438 | 27 |
2358493 | 2358493 | 2022-03-30 | Cotton | Oklahoma | 40033 | 1441 | 27 |
2355239 | 2355239 | 2022-03-29 | Cotton | Oklahoma | 40033 | 1441 | 27 |
2351986 | 2351986 | 2022-03-28 | Cotton | Oklahoma | 40033 | 1441 | 27 |
2348734 | 2348734 | 2022-03-27 | Cotton | Oklahoma | 40033 | 1441 | 27 |
2345481 | 2345481 | 2022-03-26 | Cotton | Oklahoma | 40033 | 1441 | 27 |
2342228 | 2342228 | 2022-03-25 | Cotton | Oklahoma | 40033 | 1441 | 27 |
2338975 | 2338975 | 2022-03-24 | Cotton | Oklahoma | 40033 | 1441 | 27 |
2335721 | 2335721 | 2022-03-23 | Cotton | Oklahoma | 40033 | 1435 | 26 |
2332467 | 2332467 | 2022-03-22 | Cotton | Oklahoma | 40033 | 1435 | 26 |
2329214 | 2329214 | 2022-03-21 | Cotton | Oklahoma | 40033 | 1435 | 26 |
2325962 | 2325962 | 2022-03-20 | Cotton | Oklahoma | 40033 | 1435 | 26 |
2322709 | 2322709 | 2022-03-19 | Cotton | Oklahoma | 40033 | 1435 | 26 |
2319455 | 2319455 | 2022-03-18 | Cotton | Oklahoma | 40033 | 1435 | 26 |
2316201 | 2316201 | 2022-03-17 | Cotton | Oklahoma | 40033 | 1435 | 26 |
2312948 | 2312948 | 2022-03-16 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2309695 | 2309695 | 2022-03-15 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2306442 | 2306442 | 2022-03-14 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2303191 | 2303191 | 2022-03-13 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2299939 | 2299939 | 2022-03-12 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2296687 | 2296687 | 2022-03-11 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2293435 | 2293435 | 2022-03-10 | Cotton | Oklahoma | 40033 | 1425 | 26 |
2290183 | 2290183 | 2022-03-09 | Cotton | Oklahoma | 40033 | 1410 | 24 |
2286931 | 2286931 | 2022-03-08 | Cotton | Oklahoma | 40033 | 1410 | 24 |
2283679 | 2283679 | 2022-03-07 | Cotton | Oklahoma | 40033 | 1410 | 24 |
2280427 | 2280427 | 2022-03-06 | Cotton | Oklahoma | 40033 | 1410 | 24 |
2277174 | 2277174 | 2022-03-05 | Cotton | Oklahoma | 40033 | 1410 | 24 |
2273921 | 2273921 | 2022-03-04 | Cotton | Oklahoma | 40033 | 1410 | 24 |
2270668 | 2270668 | 2022-03-03 | Cotton | Oklahoma | 40033 | 1410 | 24 |
2267416 | 2267416 | 2022-03-02 | Cotton | Oklahoma | 40033 | 1410 | 24 |
2264163 | 2264163 | 2022-03-01 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2260913 | 2260913 | 2022-02-28 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2257662 | 2257662 | 2022-02-27 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2254411 | 2254411 | 2022-02-26 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2251160 | 2251160 | 2022-02-25 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2247909 | 2247909 | 2022-02-24 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2244658 | 2244658 | 2022-02-23 | Cotton | Oklahoma | 40033 | 1394 | 24 |
2241407 | 2241407 | 2022-02-22 | Cotton | Oklahoma | 40033 | 1386 | 24 |
2238156 | 2238156 | 2022-02-21 | Cotton | Oklahoma | 40033 | 1386 | 24 |
2234905 | 2234905 | 2022-02-20 | Cotton | Oklahoma | 40033 | 1386 | 24 |
2231654 | 2231654 | 2022-02-19 | Cotton | Oklahoma | 40033 | 1386 | 24 |
2228403 | 2228403 | 2022-02-18 | Cotton | Oklahoma | 40033 | 1386 | 24 |
2225152 | 2225152 | 2022-02-17 | Cotton | Oklahoma | 40033 | 1386 | 24 |
2221901 | 2221901 | 2022-02-16 | Cotton | Oklahoma | 40033 | 1386 | 24 |
2218650 | 2218650 | 2022-02-15 | Cotton | Oklahoma | 40033 | 1371 | 24 |
2215399 | 2215399 | 2022-02-14 | Cotton | Oklahoma | 40033 | 1371 | 24 |
2212148 | 2212148 | 2022-02-13 | Cotton | Oklahoma | 40033 | 1371 | 24 |
2208895 | 2208895 | 2022-02-12 | Cotton | Oklahoma | 40033 | 1371 | 24 |
2205642 | 2205642 | 2022-02-11 | Cotton | Oklahoma | 40033 | 1371 | 24 |
2202389 | 2202389 | 2022-02-10 | Cotton | Oklahoma | 40033 | 1371 | 24 |
2199135 | 2199135 | 2022-02-09 | Cotton | Oklahoma | 40033 | 1371 | 24 |
2195881 | 2195881 | 2022-02-08 | Cotton | Oklahoma | 40033 | 1342 | 24 |
2192627 | 2192627 | 2022-02-07 | Cotton | Oklahoma | 40033 | 1342 | 24 |
2189373 | 2189373 | 2022-02-06 | Cotton | Oklahoma | 40033 | 1342 | 24 |
2186120 | 2186120 | 2022-02-05 | Cotton | Oklahoma | 40033 | 1342 | 24 |
2182868 | 2182868 | 2022-02-04 | Cotton | Oklahoma | 40033 | 1342 | 24 |
2179616 | 2179616 | 2022-02-03 | Cotton | Oklahoma | 40033 | 1342 | 24 |
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);