ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

692 rows where county = "Ellis" and fips = 40045 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, date (date)

state 1

fips 1

  • 40045 · 692 ✖

county 1

  • Ellis · 692 ✖
Link rowid date ▲ county state fips cases deaths
2501755 2501755 2022-05-13 Ellis Oklahoma 40045 774 8
2498497 2498497 2022-05-12 Ellis Oklahoma 40045 774 8
2495239 2495239 2022-05-11 Ellis Oklahoma 40045 772 8
2491981 2491981 2022-05-10 Ellis Oklahoma 40045 772 8
2488723 2488723 2022-05-09 Ellis Oklahoma 40045 772 8
2485466 2485466 2022-05-08 Ellis Oklahoma 40045 772 8
2482208 2482208 2022-05-07 Ellis Oklahoma 40045 772 8
2478950 2478950 2022-05-06 Ellis Oklahoma 40045 772 8
2475692 2475692 2022-05-05 Ellis Oklahoma 40045 772 8
2472435 2472435 2022-05-04 Ellis Oklahoma 40045 771 8
2469179 2469179 2022-05-03 Ellis Oklahoma 40045 771 8
2465923 2465923 2022-05-02 Ellis Oklahoma 40045 771 8
2462668 2462668 2022-05-01 Ellis Oklahoma 40045 771 8
2459412 2459412 2022-04-30 Ellis Oklahoma 40045 771 8
2456156 2456156 2022-04-29 Ellis Oklahoma 40045 771 8
2452900 2452900 2022-04-28 Ellis Oklahoma 40045 771 8
2449644 2449644 2022-04-27 Ellis Oklahoma 40045 770 8
2446387 2446387 2022-04-26 Ellis Oklahoma 40045 770 8
2443132 2443132 2022-04-25 Ellis Oklahoma 40045 770 8
2439876 2439876 2022-04-24 Ellis Oklahoma 40045 770 8
2436620 2436620 2022-04-23 Ellis Oklahoma 40045 770 8
2433364 2433364 2022-04-22 Ellis Oklahoma 40045 770 8
2430108 2430108 2022-04-21 Ellis Oklahoma 40045 770 8
2426852 2426852 2022-04-20 Ellis Oklahoma 40045 773 8
2423596 2423596 2022-04-19 Ellis Oklahoma 40045 773 8
2420339 2420339 2022-04-18 Ellis Oklahoma 40045 773 8
2417084 2417084 2022-04-17 Ellis Oklahoma 40045 773 8
2413828 2413828 2022-04-16 Ellis Oklahoma 40045 773 8
2410572 2410572 2022-04-15 Ellis Oklahoma 40045 773 8
2407316 2407316 2022-04-14 Ellis Oklahoma 40045 773 8
2404060 2404060 2022-04-13 Ellis Oklahoma 40045 772 8
2400805 2400805 2022-04-12 Ellis Oklahoma 40045 772 8
2397550 2397550 2022-04-11 Ellis Oklahoma 40045 772 8
2394295 2394295 2022-04-10 Ellis Oklahoma 40045 772 8
2391039 2391039 2022-04-09 Ellis Oklahoma 40045 772 8
2387783 2387783 2022-04-08 Ellis Oklahoma 40045 772 8
2384528 2384528 2022-04-07 Ellis Oklahoma 40045 772 8
2381273 2381273 2022-04-06 Ellis Oklahoma 40045 770 8
2378018 2378018 2022-04-05 Ellis Oklahoma 40045 770 8
2374764 2374764 2022-04-04 Ellis Oklahoma 40045 770 8
2371512 2371512 2022-04-03 Ellis Oklahoma 40045 770 8
2368259 2368259 2022-04-02 Ellis Oklahoma 40045 770 8
2365006 2365006 2022-04-01 Ellis Oklahoma 40045 770 8
2361753 2361753 2022-03-31 Ellis Oklahoma 40045 770 8
2358499 2358499 2022-03-30 Ellis Oklahoma 40045 769 7
2355245 2355245 2022-03-29 Ellis Oklahoma 40045 769 7
2351992 2351992 2022-03-28 Ellis Oklahoma 40045 769 7
2348740 2348740 2022-03-27 Ellis Oklahoma 40045 769 7
2345487 2345487 2022-03-26 Ellis Oklahoma 40045 769 7
2342234 2342234 2022-03-25 Ellis Oklahoma 40045 769 7
2338981 2338981 2022-03-24 Ellis Oklahoma 40045 769 7
2335727 2335727 2022-03-23 Ellis Oklahoma 40045 768 7
2332473 2332473 2022-03-22 Ellis Oklahoma 40045 768 7
2329220 2329220 2022-03-21 Ellis Oklahoma 40045 768 7
2325968 2325968 2022-03-20 Ellis Oklahoma 40045 768 7
2322715 2322715 2022-03-19 Ellis Oklahoma 40045 768 7
2319461 2319461 2022-03-18 Ellis Oklahoma 40045 768 7
2316207 2316207 2022-03-17 Ellis Oklahoma 40045 768 7
2312954 2312954 2022-03-16 Ellis Oklahoma 40045 767 7
2309701 2309701 2022-03-15 Ellis Oklahoma 40045 767 7
2306448 2306448 2022-03-14 Ellis Oklahoma 40045 767 7
2303197 2303197 2022-03-13 Ellis Oklahoma 40045 767 7
2299945 2299945 2022-03-12 Ellis Oklahoma 40045 767 7
2296693 2296693 2022-03-11 Ellis Oklahoma 40045 767 7
2293441 2293441 2022-03-10 Ellis Oklahoma 40045 767 7
2290189 2290189 2022-03-09 Ellis Oklahoma 40045 766 7
2286937 2286937 2022-03-08 Ellis Oklahoma 40045 766 7
2283685 2283685 2022-03-07 Ellis Oklahoma 40045 766 7
2280433 2280433 2022-03-06 Ellis Oklahoma 40045 766 7
2277180 2277180 2022-03-05 Ellis Oklahoma 40045 766 7
2273927 2273927 2022-03-04 Ellis Oklahoma 40045 766 7
2270674 2270674 2022-03-03 Ellis Oklahoma 40045 766 7
2267422 2267422 2022-03-02 Ellis Oklahoma 40045 766 7
2264169 2264169 2022-03-01 Ellis Oklahoma 40045 761 7
2260919 2260919 2022-02-28 Ellis Oklahoma 40045 761 7
2257668 2257668 2022-02-27 Ellis Oklahoma 40045 761 7
2254417 2254417 2022-02-26 Ellis Oklahoma 40045 761 7
2251166 2251166 2022-02-25 Ellis Oklahoma 40045 761 7
2247915 2247915 2022-02-24 Ellis Oklahoma 40045 761 7
2244664 2244664 2022-02-23 Ellis Oklahoma 40045 761 7
2241413 2241413 2022-02-22 Ellis Oklahoma 40045 758 7
2238162 2238162 2022-02-21 Ellis Oklahoma 40045 758 7
2234911 2234911 2022-02-20 Ellis Oklahoma 40045 758 7
2231660 2231660 2022-02-19 Ellis Oklahoma 40045 758 7
2228409 2228409 2022-02-18 Ellis Oklahoma 40045 758 7
2225158 2225158 2022-02-17 Ellis Oklahoma 40045 758 7
2221907 2221907 2022-02-16 Ellis Oklahoma 40045 758 7
2218656 2218656 2022-02-15 Ellis Oklahoma 40045 752 7
2215405 2215405 2022-02-14 Ellis Oklahoma 40045 752 7
2212154 2212154 2022-02-13 Ellis Oklahoma 40045 752 7
2208901 2208901 2022-02-12 Ellis Oklahoma 40045 752 7
2205648 2205648 2022-02-11 Ellis Oklahoma 40045 752 7
2202395 2202395 2022-02-10 Ellis Oklahoma 40045 752 7
2199141 2199141 2022-02-09 Ellis Oklahoma 40045 752 7
2195887 2195887 2022-02-08 Ellis Oklahoma 40045 697 7
2192633 2192633 2022-02-07 Ellis Oklahoma 40045 697 7
2189379 2189379 2022-02-06 Ellis Oklahoma 40045 697 7
2186126 2186126 2022-02-05 Ellis Oklahoma 40045 697 7
2182874 2182874 2022-02-04 Ellis Oklahoma 40045 697 7
2179622 2179622 2022-02-03 Ellis Oklahoma 40045 697 7

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);