ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,171 rows where county = "Edwards" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Edwards · 2,071 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393036 | 2393036 | 2022-04-10 | Edwards | Kansas | 20047 | 558 | 13 |
2394815 | 2394815 | 2022-04-10 | Edwards | Texas | 48137 | 465 | 11 |
2389484 | 2389484 | 2022-04-09 | Edwards | Illinois | 17047 | 1744 | 29 |
2389780 | 2389780 | 2022-04-09 | Edwards | Kansas | 20047 | 558 | 13 |
2391559 | 2391559 | 2022-04-09 | Edwards | Texas | 48137 | 465 | 11 |
2386229 | 2386229 | 2022-04-08 | Edwards | Illinois | 17047 | 1744 | 29 |
2386524 | 2386524 | 2022-04-08 | Edwards | Kansas | 20047 | 558 | 13 |
2388303 | 2388303 | 2022-04-08 | Edwards | Texas | 48137 | 465 | 11 |
2382974 | 2382974 | 2022-04-07 | Edwards | Illinois | 17047 | 1743 | 29 |
2383270 | 2383270 | 2022-04-07 | Edwards | Kansas | 20047 | 558 | 13 |
2385048 | 2385048 | 2022-04-07 | Edwards | Texas | 48137 | 465 | 11 |
2379719 | 2379719 | 2022-04-06 | Edwards | Illinois | 17047 | 1744 | 29 |
2380015 | 2380015 | 2022-04-06 | Edwards | Kansas | 20047 | 558 | 13 |
2381793 | 2381793 | 2022-04-06 | Edwards | Texas | 48137 | 465 | 11 |
2376465 | 2376465 | 2022-04-05 | Edwards | Illinois | 17047 | 1746 | 29 |
2376760 | 2376760 | 2022-04-05 | Edwards | Kansas | 20047 | 558 | 13 |
2378538 | 2378538 | 2022-04-05 | Edwards | Texas | 48137 | 465 | 11 |
2373213 | 2373213 | 2022-04-04 | Edwards | Illinois | 17047 | 1746 | 29 |
2373508 | 2373508 | 2022-04-04 | Edwards | Kansas | 20047 | 558 | 13 |
2375284 | 2375284 | 2022-04-04 | Edwards | Texas | 48137 | 465 | 11 |
2369960 | 2369960 | 2022-04-03 | Edwards | Illinois | 17047 | 1750 | 29 |
2370255 | 2370255 | 2022-04-03 | Edwards | Kansas | 20047 | 558 | 13 |
2372032 | 2372032 | 2022-04-03 | Edwards | Texas | 48137 | 465 | 11 |
2366707 | 2366707 | 2022-04-02 | Edwards | Illinois | 17047 | 1750 | 29 |
2367002 | 2367002 | 2022-04-02 | Edwards | Kansas | 20047 | 558 | 13 |
2368779 | 2368779 | 2022-04-02 | Edwards | Texas | 48137 | 465 | 11 |
2363454 | 2363454 | 2022-04-01 | Edwards | Illinois | 17047 | 1750 | 29 |
2363749 | 2363749 | 2022-04-01 | Edwards | Kansas | 20047 | 558 | 13 |
2365526 | 2365526 | 2022-04-01 | Edwards | Texas | 48137 | 465 | 11 |
2360200 | 2360200 | 2022-03-31 | Edwards | Illinois | 17047 | 1750 | 29 |
2360495 | 2360495 | 2022-03-31 | Edwards | Kansas | 20047 | 558 | 13 |
2362273 | 2362273 | 2022-03-31 | Edwards | Texas | 48137 | 465 | 11 |
2356946 | 2356946 | 2022-03-30 | Edwards | Illinois | 17047 | 1748 | 29 |
2357241 | 2357241 | 2022-03-30 | Edwards | Kansas | 20047 | 558 | 13 |
2359019 | 2359019 | 2022-03-30 | Edwards | Texas | 48137 | 465 | 11 |
2353693 | 2353693 | 2022-03-29 | Edwards | Illinois | 17047 | 1748 | 29 |
2353988 | 2353988 | 2022-03-29 | Edwards | Kansas | 20047 | 558 | 13 |
2355765 | 2355765 | 2022-03-29 | Edwards | Texas | 48137 | 465 | 11 |
2350441 | 2350441 | 2022-03-28 | Edwards | Illinois | 17047 | 1748 | 29 |
2350736 | 2350736 | 2022-03-28 | Edwards | Kansas | 20047 | 558 | 13 |
2352512 | 2352512 | 2022-03-28 | Edwards | Texas | 48137 | 465 | 11 |
2347188 | 2347188 | 2022-03-27 | Edwards | Illinois | 17047 | 1754 | 29 |
2347483 | 2347483 | 2022-03-27 | Edwards | Kansas | 20047 | 558 | 13 |
2349260 | 2349260 | 2022-03-27 | Edwards | Texas | 48137 | 465 | 11 |
2343935 | 2343935 | 2022-03-26 | Edwards | Illinois | 17047 | 1754 | 29 |
2344230 | 2344230 | 2022-03-26 | Edwards | Kansas | 20047 | 558 | 13 |
2346007 | 2346007 | 2022-03-26 | Edwards | Texas | 48137 | 465 | 11 |
2340682 | 2340682 | 2022-03-25 | Edwards | Illinois | 17047 | 1754 | 29 |
2340977 | 2340977 | 2022-03-25 | Edwards | Kansas | 20047 | 558 | 13 |
2342754 | 2342754 | 2022-03-25 | Edwards | Texas | 48137 | 465 | 11 |
2337429 | 2337429 | 2022-03-24 | Edwards | Illinois | 17047 | 1753 | 29 |
2337724 | 2337724 | 2022-03-24 | Edwards | Kansas | 20047 | 561 | 13 |
2339501 | 2339501 | 2022-03-24 | Edwards | Texas | 48137 | 465 | 11 |
2334175 | 2334175 | 2022-03-23 | Edwards | Illinois | 17047 | 1753 | 29 |
2334470 | 2334470 | 2022-03-23 | Edwards | Kansas | 20047 | 561 | 13 |
2336247 | 2336247 | 2022-03-23 | Edwards | Texas | 48137 | 465 | 11 |
2330921 | 2330921 | 2022-03-22 | Edwards | Illinois | 17047 | 1753 | 29 |
2331216 | 2331216 | 2022-03-22 | Edwards | Kansas | 20047 | 562 | 13 |
2332993 | 2332993 | 2022-03-22 | Edwards | Texas | 48137 | 465 | 11 |
2327669 | 2327669 | 2022-03-21 | Edwards | Illinois | 17047 | 1753 | 29 |
2327964 | 2327964 | 2022-03-21 | Edwards | Kansas | 20047 | 562 | 13 |
2329740 | 2329740 | 2022-03-21 | Edwards | Texas | 48137 | 465 | 11 |
2324416 | 2324416 | 2022-03-20 | Edwards | Illinois | 17047 | 1753 | 29 |
2324711 | 2324711 | 2022-03-20 | Edwards | Kansas | 20047 | 562 | 13 |
2326488 | 2326488 | 2022-03-20 | Edwards | Texas | 48137 | 465 | 11 |
2321162 | 2321162 | 2022-03-19 | Edwards | Illinois | 17047 | 1753 | 29 |
2321457 | 2321457 | 2022-03-19 | Edwards | Kansas | 20047 | 562 | 13 |
2323235 | 2323235 | 2022-03-19 | Edwards | Texas | 48137 | 465 | 11 |
2317908 | 2317908 | 2022-03-18 | Edwards | Illinois | 17047 | 1753 | 29 |
2318203 | 2318203 | 2022-03-18 | Edwards | Kansas | 20047 | 562 | 13 |
2319981 | 2319981 | 2022-03-18 | Edwards | Texas | 48137 | 465 | 11 |
2314655 | 2314655 | 2022-03-17 | Edwards | Illinois | 17047 | 1753 | 29 |
2314950 | 2314950 | 2022-03-17 | Edwards | Kansas | 20047 | 562 | 13 |
2316727 | 2316727 | 2022-03-17 | Edwards | Texas | 48137 | 465 | 11 |
2311402 | 2311402 | 2022-03-16 | Edwards | Illinois | 17047 | 1753 | 29 |
2311697 | 2311697 | 2022-03-16 | Edwards | Kansas | 20047 | 562 | 13 |
2313474 | 2313474 | 2022-03-16 | Edwards | Texas | 48137 | 465 | 11 |
2308149 | 2308149 | 2022-03-15 | Edwards | Illinois | 17047 | 1752 | 29 |
2308444 | 2308444 | 2022-03-15 | Edwards | Kansas | 20047 | 562 | 13 |
2310221 | 2310221 | 2022-03-15 | Edwards | Texas | 48137 | 465 | 11 |
2304898 | 2304898 | 2022-03-14 | Edwards | Illinois | 17047 | 1751 | 29 |
2305193 | 2305193 | 2022-03-14 | Edwards | Kansas | 20047 | 562 | 13 |
2306968 | 2306968 | 2022-03-14 | Edwards | Texas | 48137 | 465 | 11 |
2301646 | 2301646 | 2022-03-13 | Edwards | Illinois | 17047 | 1750 | 28 |
2301941 | 2301941 | 2022-03-13 | Edwards | Kansas | 20047 | 560 | 13 |
2303717 | 2303717 | 2022-03-13 | Edwards | Texas | 48137 | 465 | 11 |
2298394 | 2298394 | 2022-03-12 | Edwards | Illinois | 17047 | 1750 | 28 |
2298689 | 2298689 | 2022-03-12 | Edwards | Kansas | 20047 | 560 | 13 |
2300465 | 2300465 | 2022-03-12 | Edwards | Texas | 48137 | 465 | 11 |
2295142 | 2295142 | 2022-03-11 | Edwards | Illinois | 17047 | 1750 | 28 |
2295437 | 2295437 | 2022-03-11 | Edwards | Kansas | 20047 | 560 | 13 |
2297213 | 2297213 | 2022-03-11 | Edwards | Texas | 48137 | 465 | 11 |
2291890 | 2291890 | 2022-03-10 | Edwards | Illinois | 17047 | 1749 | 28 |
2292185 | 2292185 | 2022-03-10 | Edwards | Kansas | 20047 | 560 | 13 |
2293961 | 2293961 | 2022-03-10 | Edwards | Texas | 48137 | 465 | 11 |
2288638 | 2288638 | 2022-03-09 | Edwards | Illinois | 17047 | 1748 | 28 |
2288933 | 2288933 | 2022-03-09 | Edwards | Kansas | 20047 | 560 | 13 |
2290709 | 2290709 | 2022-03-09 | Edwards | Texas | 48137 | 465 | 11 |
2285387 | 2285387 | 2022-03-08 | Edwards | Illinois | 17047 | 1748 | 28 |
2285682 | 2285682 | 2022-03-08 | Edwards | Kansas | 20047 | 560 | 13 |
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);