ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,274 rows where county = "Comanche" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Comanche · 2,174 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394288 | 2394288 | 2022-04-10 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2394793 | 2394793 | 2022-04-10 | Comanche | Texas | 48093 | 3570 | 78 |
2389773 | 2389773 | 2022-04-09 | Comanche | Kansas | 20033 | 439 | 16 |
2391032 | 2391032 | 2022-04-09 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2391537 | 2391537 | 2022-04-09 | Comanche | Texas | 48093 | 3570 | 78 |
2386517 | 2386517 | 2022-04-08 | Comanche | Kansas | 20033 | 439 | 16 |
2387776 | 2387776 | 2022-04-08 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2388281 | 2388281 | 2022-04-08 | Comanche | Texas | 48093 | 3553 | 78 |
2383263 | 2383263 | 2022-04-07 | Comanche | Kansas | 20033 | 439 | 16 |
2384521 | 2384521 | 2022-04-07 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2385026 | 2385026 | 2022-04-07 | Comanche | Texas | 48093 | 3542 | 78 |
2380008 | 2380008 | 2022-04-06 | Comanche | Kansas | 20033 | 439 | 16 |
2381266 | 2381266 | 2022-04-06 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2381771 | 2381771 | 2022-04-06 | Comanche | Texas | 48093 | 3540 | 78 |
2376753 | 2376753 | 2022-04-05 | Comanche | Kansas | 20033 | 439 | 16 |
2378011 | 2378011 | 2022-04-05 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2378516 | 2378516 | 2022-04-05 | Comanche | Texas | 48093 | 3540 | 78 |
2373501 | 2373501 | 2022-04-04 | Comanche | Kansas | 20033 | 439 | 16 |
2374757 | 2374757 | 2022-04-04 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2375262 | 2375262 | 2022-04-04 | Comanche | Texas | 48093 | 3514 | 78 |
2370248 | 2370248 | 2022-04-03 | Comanche | Kansas | 20033 | 439 | 16 |
2371505 | 2371505 | 2022-04-03 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2372010 | 2372010 | 2022-04-03 | Comanche | Texas | 48093 | 3514 | 78 |
2366995 | 2366995 | 2022-04-02 | Comanche | Kansas | 20033 | 439 | 16 |
2368252 | 2368252 | 2022-04-02 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2368757 | 2368757 | 2022-04-02 | Comanche | Texas | 48093 | 3514 | 78 |
2363742 | 2363742 | 2022-04-01 | Comanche | Kansas | 20033 | 439 | 16 |
2364999 | 2364999 | 2022-04-01 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2365504 | 2365504 | 2022-04-01 | Comanche | Texas | 48093 | 3496 | 78 |
2360488 | 2360488 | 2022-03-31 | Comanche | Kansas | 20033 | 439 | 15 |
2361746 | 2361746 | 2022-03-31 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2362251 | 2362251 | 2022-03-31 | Comanche | Texas | 48093 | 3475 | 78 |
2357234 | 2357234 | 2022-03-30 | Comanche | Kansas | 20033 | 439 | 15 |
2358492 | 2358492 | 2022-03-30 | Comanche | Oklahoma | 40031 | 32842 | 381 |
2358997 | 2358997 | 2022-03-30 | Comanche | Texas | 48093 | 3456 | 78 |
2353981 | 2353981 | 2022-03-29 | Comanche | Kansas | 20033 | 439 | 15 |
2355238 | 2355238 | 2022-03-29 | Comanche | Oklahoma | 40031 | 32842 | 381 |
2355743 | 2355743 | 2022-03-29 | Comanche | Texas | 48093 | 3440 | 78 |
2350729 | 2350729 | 2022-03-28 | Comanche | Kansas | 20033 | 439 | 15 |
2351985 | 2351985 | 2022-03-28 | Comanche | Oklahoma | 40031 | 32842 | 381 |
2352490 | 2352490 | 2022-03-28 | Comanche | Texas | 48093 | 3412 | 78 |
2347476 | 2347476 | 2022-03-27 | Comanche | Kansas | 20033 | 438 | 15 |
2348733 | 2348733 | 2022-03-27 | Comanche | Oklahoma | 40031 | 32842 | 381 |
2349238 | 2349238 | 2022-03-27 | Comanche | Texas | 48093 | 3412 | 78 |
2344223 | 2344223 | 2022-03-26 | Comanche | Kansas | 20033 | 438 | 15 |
2345480 | 2345480 | 2022-03-26 | Comanche | Oklahoma | 40031 | 32842 | 381 |
2345985 | 2345985 | 2022-03-26 | Comanche | Texas | 48093 | 3412 | 78 |
2340970 | 2340970 | 2022-03-25 | Comanche | Kansas | 20033 | 438 | 15 |
2342227 | 2342227 | 2022-03-25 | Comanche | Oklahoma | 40031 | 32842 | 381 |
2342732 | 2342732 | 2022-03-25 | Comanche | Texas | 48093 | 3393 | 78 |
2337717 | 2337717 | 2022-03-24 | Comanche | Kansas | 20033 | 440 | 15 |
2338974 | 2338974 | 2022-03-24 | Comanche | Oklahoma | 40031 | 32842 | 381 |
2339479 | 2339479 | 2022-03-24 | Comanche | Texas | 48093 | 3338 | 78 |
2334463 | 2334463 | 2022-03-23 | Comanche | Kansas | 20033 | 440 | 15 |
2335720 | 2335720 | 2022-03-23 | Comanche | Oklahoma | 40031 | 32736 | 376 |
2336225 | 2336225 | 2022-03-23 | Comanche | Texas | 48093 | 3293 | 78 |
2331209 | 2331209 | 2022-03-22 | Comanche | Kansas | 20033 | 440 | 15 |
2332466 | 2332466 | 2022-03-22 | Comanche | Oklahoma | 40031 | 32736 | 376 |
2332971 | 2332971 | 2022-03-22 | Comanche | Texas | 48093 | 3253 | 78 |
2327957 | 2327957 | 2022-03-21 | Comanche | Kansas | 20033 | 440 | 15 |
2329213 | 2329213 | 2022-03-21 | Comanche | Oklahoma | 40031 | 32736 | 376 |
2329718 | 2329718 | 2022-03-21 | Comanche | Texas | 48093 | 3213 | 78 |
2324704 | 2324704 | 2022-03-20 | Comanche | Kansas | 20033 | 440 | 15 |
2325961 | 2325961 | 2022-03-20 | Comanche | Oklahoma | 40031 | 32736 | 376 |
2326466 | 2326466 | 2022-03-20 | Comanche | Texas | 48093 | 3213 | 78 |
2321450 | 2321450 | 2022-03-19 | Comanche | Kansas | 20033 | 440 | 15 |
2322708 | 2322708 | 2022-03-19 | Comanche | Oklahoma | 40031 | 32736 | 376 |
2323213 | 2323213 | 2022-03-19 | Comanche | Texas | 48093 | 3213 | 78 |
2318196 | 2318196 | 2022-03-18 | Comanche | Kansas | 20033 | 440 | 15 |
2319454 | 2319454 | 2022-03-18 | Comanche | Oklahoma | 40031 | 32736 | 376 |
2319959 | 2319959 | 2022-03-18 | Comanche | Texas | 48093 | 3196 | 78 |
2314943 | 2314943 | 2022-03-17 | Comanche | Kansas | 20033 | 440 | 15 |
2316200 | 2316200 | 2022-03-17 | Comanche | Oklahoma | 40031 | 32736 | 376 |
2316705 | 2316705 | 2022-03-17 | Comanche | Texas | 48093 | 3172 | 78 |
2311690 | 2311690 | 2022-03-16 | Comanche | Kansas | 20033 | 440 | 15 |
2312947 | 2312947 | 2022-03-16 | Comanche | Oklahoma | 40031 | 31649 | 372 |
2313452 | 2313452 | 2022-03-16 | Comanche | Texas | 48093 | 3160 | 78 |
2308437 | 2308437 | 2022-03-15 | Comanche | Kansas | 20033 | 441 | 15 |
2309694 | 2309694 | 2022-03-15 | Comanche | Oklahoma | 40031 | 31649 | 372 |
2310199 | 2310199 | 2022-03-15 | Comanche | Texas | 48093 | 3160 | 78 |
2305186 | 2305186 | 2022-03-14 | Comanche | Kansas | 20033 | 441 | 15 |
2306441 | 2306441 | 2022-03-14 | Comanche | Oklahoma | 40031 | 31649 | 372 |
2306946 | 2306946 | 2022-03-14 | Comanche | Texas | 48093 | 3153 | 78 |
2301934 | 2301934 | 2022-03-13 | Comanche | Kansas | 20033 | 441 | 15 |
2303190 | 2303190 | 2022-03-13 | Comanche | Oklahoma | 40031 | 31649 | 372 |
2303695 | 2303695 | 2022-03-13 | Comanche | Texas | 48093 | 3153 | 78 |
2298682 | 2298682 | 2022-03-12 | Comanche | Kansas | 20033 | 441 | 15 |
2299938 | 2299938 | 2022-03-12 | Comanche | Oklahoma | 40031 | 31649 | 372 |
2300443 | 2300443 | 2022-03-12 | Comanche | Texas | 48093 | 3153 | 78 |
2295430 | 2295430 | 2022-03-11 | Comanche | Kansas | 20033 | 441 | 15 |
2296686 | 2296686 | 2022-03-11 | Comanche | Oklahoma | 40031 | 31649 | 372 |
2297191 | 2297191 | 2022-03-11 | Comanche | Texas | 48093 | 3137 | 78 |
2292178 | 2292178 | 2022-03-10 | Comanche | Kansas | 20033 | 441 | 15 |
2293434 | 2293434 | 2022-03-10 | Comanche | Oklahoma | 40031 | 31649 | 372 |
2293939 | 2293939 | 2022-03-10 | Comanche | Texas | 48093 | 3137 | 78 |
2288926 | 2288926 | 2022-03-09 | Comanche | Kansas | 20033 | 441 | 15 |
2290182 | 2290182 | 2022-03-09 | Comanche | Oklahoma | 40031 | 31417 | 364 |
2290687 | 2290687 | 2022-03-09 | Comanche | Texas | 48093 | 3135 | 78 |
2285675 | 2285675 | 2022-03-08 | Comanche | Kansas | 20033 | 439 | 15 |
2286930 | 2286930 | 2022-03-08 | Comanche | Oklahoma | 40031 | 31417 | 364 |
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);