ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,551 rows where county = "Chickasaw" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500391 | 2500391 | 2022-05-13 | Chickasaw | Iowa | 19037 | 2701 | 32 |
2501001 | 2501001 | 2022-05-13 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2497133 | 2497133 | 2022-05-12 | Chickasaw | Iowa | 19037 | 2701 | 32 |
2497743 | 2497743 | 2022-05-12 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2493875 | 2493875 | 2022-05-11 | Chickasaw | Iowa | 19037 | 2701 | 32 |
2494485 | 2494485 | 2022-05-11 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2490617 | 2490617 | 2022-05-10 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2491227 | 2491227 | 2022-05-10 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2487360 | 2487360 | 2022-05-09 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2487970 | 2487970 | 2022-05-09 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2484102 | 2484102 | 2022-05-08 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2484712 | 2484712 | 2022-05-08 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2480844 | 2480844 | 2022-05-07 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2481454 | 2481454 | 2022-05-07 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2477586 | 2477586 | 2022-05-06 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2478196 | 2478196 | 2022-05-06 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2474328 | 2474328 | 2022-05-05 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2474938 | 2474938 | 2022-05-05 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2471071 | 2471071 | 2022-05-04 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2471681 | 2471681 | 2022-05-04 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2467815 | 2467815 | 2022-05-03 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2468425 | 2468425 | 2022-05-03 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2464560 | 2464560 | 2022-05-02 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2465170 | 2465170 | 2022-05-02 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2461304 | 2461304 | 2022-05-01 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2461914 | 2461914 | 2022-05-01 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2458048 | 2458048 | 2022-04-30 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2458658 | 2458658 | 2022-04-30 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2454792 | 2454792 | 2022-04-29 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2455402 | 2455402 | 2022-04-29 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2451536 | 2451536 | 2022-04-28 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2452146 | 2452146 | 2022-04-28 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2448280 | 2448280 | 2022-04-27 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2448890 | 2448890 | 2022-04-27 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2445024 | 2445024 | 2022-04-26 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2445634 | 2445634 | 2022-04-26 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2441768 | 2441768 | 2022-04-25 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2442378 | 2442378 | 2022-04-25 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2438512 | 2438512 | 2022-04-24 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2439122 | 2439122 | 2022-04-24 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2435256 | 2435256 | 2022-04-23 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2435866 | 2435866 | 2022-04-23 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2432000 | 2432000 | 2022-04-22 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2432610 | 2432610 | 2022-04-22 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2428744 | 2428744 | 2022-04-21 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2429354 | 2429354 | 2022-04-21 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2425488 | 2425488 | 2022-04-20 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2426098 | 2426098 | 2022-04-20 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2422232 | 2422232 | 2022-04-19 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2422842 | 2422842 | 2022-04-19 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2418976 | 2418976 | 2022-04-18 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2419586 | 2419586 | 2022-04-18 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2415720 | 2415720 | 2022-04-17 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2416330 | 2416330 | 2022-04-17 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2412464 | 2412464 | 2022-04-16 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2413074 | 2413074 | 2022-04-16 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2409208 | 2409208 | 2022-04-15 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2409818 | 2409818 | 2022-04-15 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2405952 | 2405952 | 2022-04-14 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2406562 | 2406562 | 2022-04-14 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2402696 | 2402696 | 2022-04-13 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2403306 | 2403306 | 2022-04-13 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2399442 | 2399442 | 2022-04-12 | Chickasaw | Iowa | 19037 | 2676 | 32 |
2400052 | 2400052 | 2022-04-12 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2396186 | 2396186 | 2022-04-11 | Chickasaw | Iowa | 19037 | 2676 | 32 |
2396796 | 2396796 | 2022-04-11 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2392931 | 2392931 | 2022-04-10 | Chickasaw | Iowa | 19037 | 2676 | 32 |
2393541 | 2393541 | 2022-04-10 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2389675 | 2389675 | 2022-04-09 | Chickasaw | Iowa | 19037 | 2676 | 32 |
2390285 | 2390285 | 2022-04-09 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2386419 | 2386419 | 2022-04-08 | Chickasaw | Iowa | 19037 | 2676 | 32 |
2387029 | 2387029 | 2022-04-08 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2383165 | 2383165 | 2022-04-07 | Chickasaw | Iowa | 19037 | 2676 | 32 |
2383774 | 2383774 | 2022-04-07 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2379910 | 2379910 | 2022-04-06 | Chickasaw | Iowa | 19037 | 2676 | 32 |
2380519 | 2380519 | 2022-04-06 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2376655 | 2376655 | 2022-04-05 | Chickasaw | Iowa | 19037 | 2673 | 32 |
2377264 | 2377264 | 2022-04-05 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2373403 | 2373403 | 2022-04-04 | Chickasaw | Iowa | 19037 | 2673 | 32 |
2374012 | 2374012 | 2022-04-04 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2370150 | 2370150 | 2022-04-03 | Chickasaw | Iowa | 19037 | 2673 | 32 |
2370759 | 2370759 | 2022-04-03 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2366897 | 2366897 | 2022-04-02 | Chickasaw | Iowa | 19037 | 2673 | 32 |
2367506 | 2367506 | 2022-04-02 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2363644 | 2363644 | 2022-04-01 | Chickasaw | Iowa | 19037 | 2673 | 32 |
2364253 | 2364253 | 2022-04-01 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2360390 | 2360390 | 2022-03-31 | Chickasaw | Iowa | 19037 | 2673 | 32 |
2360999 | 2360999 | 2022-03-31 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2357136 | 2357136 | 2022-03-30 | Chickasaw | Iowa | 19037 | 2673 | 32 |
2357745 | 2357745 | 2022-03-30 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2353883 | 2353883 | 2022-03-29 | Chickasaw | Iowa | 19037 | 2671 | 32 |
2354492 | 2354492 | 2022-03-29 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2350631 | 2350631 | 2022-03-28 | Chickasaw | Iowa | 19037 | 2671 | 32 |
2351240 | 2351240 | 2022-03-28 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2347378 | 2347378 | 2022-03-27 | Chickasaw | Iowa | 19037 | 2671 | 32 |
2347987 | 2347987 | 2022-03-27 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2344125 | 2344125 | 2022-03-26 | Chickasaw | Iowa | 19037 | 2671 | 32 |
2344734 | 2344734 | 2022-03-26 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2340872 | 2340872 | 2022-03-25 | Chickasaw | Iowa | 19037 | 2671 | 32 |
2341481 | 2341481 | 2022-03-25 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
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);