ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,243 rows where county = "Ellis" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Ellis · 2,143 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394295 | 2394295 | 2022-04-10 | Ellis | Oklahoma | 40045 | 772 | 8 |
2394817 | 2394817 | 2022-04-10 | Ellis | Texas | 48139 | 48774 | 580 |
2389782 | 2389782 | 2022-04-09 | Ellis | Kansas | 20051 | 7135 | 81 |
2391039 | 2391039 | 2022-04-09 | Ellis | Oklahoma | 40045 | 772 | 8 |
2391561 | 2391561 | 2022-04-09 | Ellis | Texas | 48139 | 48772 | 580 |
2386526 | 2386526 | 2022-04-08 | Ellis | Kansas | 20051 | 7135 | 81 |
2387783 | 2387783 | 2022-04-08 | Ellis | Oklahoma | 40045 | 772 | 8 |
2388305 | 2388305 | 2022-04-08 | Ellis | Texas | 48139 | 48765 | 578 |
2383272 | 2383272 | 2022-04-07 | Ellis | Kansas | 20051 | 7133 | 81 |
2384528 | 2384528 | 2022-04-07 | Ellis | Oklahoma | 40045 | 772 | 8 |
2385050 | 2385050 | 2022-04-07 | Ellis | Texas | 48139 | 48755 | 578 |
2380017 | 2380017 | 2022-04-06 | Ellis | Kansas | 20051 | 7133 | 81 |
2381273 | 2381273 | 2022-04-06 | Ellis | Oklahoma | 40045 | 770 | 8 |
2381795 | 2381795 | 2022-04-06 | Ellis | Texas | 48139 | 48738 | 578 |
2376762 | 2376762 | 2022-04-05 | Ellis | Kansas | 20051 | 7133 | 81 |
2378018 | 2378018 | 2022-04-05 | Ellis | Oklahoma | 40045 | 770 | 8 |
2378540 | 2378540 | 2022-04-05 | Ellis | Texas | 48139 | 48727 | 577 |
2373510 | 2373510 | 2022-04-04 | Ellis | Kansas | 20051 | 7133 | 81 |
2374764 | 2374764 | 2022-04-04 | Ellis | Oklahoma | 40045 | 770 | 8 |
2375286 | 2375286 | 2022-04-04 | Ellis | Texas | 48139 | 48720 | 577 |
2370257 | 2370257 | 2022-04-03 | Ellis | Kansas | 20051 | 7133 | 81 |
2371512 | 2371512 | 2022-04-03 | Ellis | Oklahoma | 40045 | 770 | 8 |
2372034 | 2372034 | 2022-04-03 | Ellis | Texas | 48139 | 48717 | 577 |
2367004 | 2367004 | 2022-04-02 | Ellis | Kansas | 20051 | 7133 | 81 |
2368259 | 2368259 | 2022-04-02 | Ellis | Oklahoma | 40045 | 770 | 8 |
2368781 | 2368781 | 2022-04-02 | Ellis | Texas | 48139 | 48714 | 577 |
2363751 | 2363751 | 2022-04-01 | Ellis | Kansas | 20051 | 7133 | 81 |
2365006 | 2365006 | 2022-04-01 | Ellis | Oklahoma | 40045 | 770 | 8 |
2365528 | 2365528 | 2022-04-01 | Ellis | Texas | 48139 | 48697 | 577 |
2360497 | 2360497 | 2022-03-31 | Ellis | Kansas | 20051 | 7131 | 79 |
2361753 | 2361753 | 2022-03-31 | Ellis | Oklahoma | 40045 | 770 | 8 |
2362275 | 2362275 | 2022-03-31 | Ellis | Texas | 48139 | 48685 | 577 |
2357243 | 2357243 | 2022-03-30 | Ellis | Kansas | 20051 | 7131 | 79 |
2358499 | 2358499 | 2022-03-30 | Ellis | Oklahoma | 40045 | 769 | 7 |
2359021 | 2359021 | 2022-03-30 | Ellis | Texas | 48139 | 48668 | 577 |
2353990 | 2353990 | 2022-03-29 | Ellis | Kansas | 20051 | 7131 | 79 |
2355245 | 2355245 | 2022-03-29 | Ellis | Oklahoma | 40045 | 769 | 7 |
2355767 | 2355767 | 2022-03-29 | Ellis | Texas | 48139 | 48658 | 576 |
2350738 | 2350738 | 2022-03-28 | Ellis | Kansas | 20051 | 7133 | 79 |
2351992 | 2351992 | 2022-03-28 | Ellis | Oklahoma | 40045 | 769 | 7 |
2352514 | 2352514 | 2022-03-28 | Ellis | Texas | 48139 | 48649 | 576 |
2347485 | 2347485 | 2022-03-27 | Ellis | Kansas | 20051 | 7133 | 79 |
2348740 | 2348740 | 2022-03-27 | Ellis | Oklahoma | 40045 | 769 | 7 |
2349262 | 2349262 | 2022-03-27 | Ellis | Texas | 48139 | 48647 | 576 |
2344232 | 2344232 | 2022-03-26 | Ellis | Kansas | 20051 | 7133 | 79 |
2345487 | 2345487 | 2022-03-26 | Ellis | Oklahoma | 40045 | 769 | 7 |
2346009 | 2346009 | 2022-03-26 | Ellis | Texas | 48139 | 48647 | 576 |
2340979 | 2340979 | 2022-03-25 | Ellis | Kansas | 20051 | 7133 | 79 |
2342234 | 2342234 | 2022-03-25 | Ellis | Oklahoma | 40045 | 769 | 7 |
2342756 | 2342756 | 2022-03-25 | Ellis | Texas | 48139 | 48636 | 575 |
2337726 | 2337726 | 2022-03-24 | Ellis | Kansas | 20051 | 7133 | 79 |
2338981 | 2338981 | 2022-03-24 | Ellis | Oklahoma | 40045 | 769 | 7 |
2339503 | 2339503 | 2022-03-24 | Ellis | Texas | 48139 | 48631 | 575 |
2334472 | 2334472 | 2022-03-23 | Ellis | Kansas | 20051 | 7133 | 79 |
2335727 | 2335727 | 2022-03-23 | Ellis | Oklahoma | 40045 | 768 | 7 |
2336249 | 2336249 | 2022-03-23 | Ellis | Texas | 48139 | 48617 | 575 |
2331218 | 2331218 | 2022-03-22 | Ellis | Kansas | 20051 | 7133 | 79 |
2332473 | 2332473 | 2022-03-22 | Ellis | Oklahoma | 40045 | 768 | 7 |
2332995 | 2332995 | 2022-03-22 | Ellis | Texas | 48139 | 48604 | 574 |
2327966 | 2327966 | 2022-03-21 | Ellis | Kansas | 20051 | 7133 | 79 |
2329220 | 2329220 | 2022-03-21 | Ellis | Oklahoma | 40045 | 768 | 7 |
2329742 | 2329742 | 2022-03-21 | Ellis | Texas | 48139 | 48603 | 574 |
2324713 | 2324713 | 2022-03-20 | Ellis | Kansas | 20051 | 7132 | 79 |
2325968 | 2325968 | 2022-03-20 | Ellis | Oklahoma | 40045 | 768 | 7 |
2326490 | 2326490 | 2022-03-20 | Ellis | Texas | 48139 | 48591 | 574 |
2321459 | 2321459 | 2022-03-19 | Ellis | Kansas | 20051 | 7132 | 79 |
2322715 | 2322715 | 2022-03-19 | Ellis | Oklahoma | 40045 | 768 | 7 |
2323237 | 2323237 | 2022-03-19 | Ellis | Texas | 48139 | 48580 | 574 |
2318205 | 2318205 | 2022-03-18 | Ellis | Kansas | 20051 | 7132 | 79 |
2319461 | 2319461 | 2022-03-18 | Ellis | Oklahoma | 40045 | 768 | 7 |
2319983 | 2319983 | 2022-03-18 | Ellis | Texas | 48139 | 48571 | 573 |
2314952 | 2314952 | 2022-03-17 | Ellis | Kansas | 20051 | 7131 | 79 |
2316207 | 2316207 | 2022-03-17 | Ellis | Oklahoma | 40045 | 768 | 7 |
2316729 | 2316729 | 2022-03-17 | Ellis | Texas | 48139 | 48565 | 573 |
2311699 | 2311699 | 2022-03-16 | Ellis | Kansas | 20051 | 7131 | 79 |
2312954 | 2312954 | 2022-03-16 | Ellis | Oklahoma | 40045 | 767 | 7 |
2313476 | 2313476 | 2022-03-16 | Ellis | Texas | 48139 | 48559 | 573 |
2308446 | 2308446 | 2022-03-15 | Ellis | Kansas | 20051 | 7130 | 79 |
2309701 | 2309701 | 2022-03-15 | Ellis | Oklahoma | 40045 | 767 | 7 |
2310223 | 2310223 | 2022-03-15 | Ellis | Texas | 48139 | 48544 | 573 |
2305195 | 2305195 | 2022-03-14 | Ellis | Kansas | 20051 | 7130 | 80 |
2306448 | 2306448 | 2022-03-14 | Ellis | Oklahoma | 40045 | 767 | 7 |
2306970 | 2306970 | 2022-03-14 | Ellis | Texas | 48139 | 48537 | 573 |
2301943 | 2301943 | 2022-03-13 | Ellis | Kansas | 20051 | 7129 | 80 |
2303197 | 2303197 | 2022-03-13 | Ellis | Oklahoma | 40045 | 767 | 7 |
2303719 | 2303719 | 2022-03-13 | Ellis | Texas | 48139 | 48535 | 573 |
2298691 | 2298691 | 2022-03-12 | Ellis | Kansas | 20051 | 7129 | 80 |
2299945 | 2299945 | 2022-03-12 | Ellis | Oklahoma | 40045 | 767 | 7 |
2300467 | 2300467 | 2022-03-12 | Ellis | Texas | 48139 | 48505 | 573 |
2295439 | 2295439 | 2022-03-11 | Ellis | Kansas | 20051 | 7129 | 80 |
2296693 | 2296693 | 2022-03-11 | Ellis | Oklahoma | 40045 | 767 | 7 |
2297215 | 2297215 | 2022-03-11 | Ellis | Texas | 48139 | 48481 | 573 |
2292187 | 2292187 | 2022-03-10 | Ellis | Kansas | 20051 | 7126 | 80 |
2293441 | 2293441 | 2022-03-10 | Ellis | Oklahoma | 40045 | 767 | 7 |
2293963 | 2293963 | 2022-03-10 | Ellis | Texas | 48139 | 48466 | 573 |
2288935 | 2288935 | 2022-03-09 | Ellis | Kansas | 20051 | 7126 | 80 |
2290189 | 2290189 | 2022-03-09 | Ellis | Oklahoma | 40045 | 766 | 7 |
2290711 | 2290711 | 2022-03-09 | Ellis | Texas | 48139 | 48442 | 573 |
2285684 | 2285684 | 2022-03-08 | Ellis | Kansas | 20051 | 7120 | 80 |
2286937 | 2286937 | 2022-03-08 | Ellis | Oklahoma | 40045 | 766 | 7 |
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);