ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Kendall" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337452 | 2337452 | 2022-03-24 | Kendall | Illinois | 17093 | 30809 | 169 |
2339562 | 2339562 | 2022-03-24 | Kendall | Texas | 48259 | 8135 | 118 |
2334198 | 2334198 | 2022-03-23 | Kendall | Illinois | 17093 | 30794 | 169 |
2336308 | 2336308 | 2022-03-23 | Kendall | Texas | 48259 | 8134 | 118 |
2330944 | 2330944 | 2022-03-22 | Kendall | Illinois | 17093 | 30784 | 169 |
2333054 | 2333054 | 2022-03-22 | Kendall | Texas | 48259 | 8132 | 118 |
2327692 | 2327692 | 2022-03-21 | Kendall | Illinois | 17093 | 30772 | 169 |
2329801 | 2329801 | 2022-03-21 | Kendall | Texas | 48259 | 8130 | 118 |
2324439 | 2324439 | 2022-03-20 | Kendall | Illinois | 17093 | 30735 | 168 |
2326549 | 2326549 | 2022-03-20 | Kendall | Texas | 48259 | 8130 | 118 |
2321185 | 2321185 | 2022-03-19 | Kendall | Illinois | 17093 | 30735 | 168 |
2323296 | 2323296 | 2022-03-19 | Kendall | Texas | 48259 | 8127 | 118 |
2317931 | 2317931 | 2022-03-18 | Kendall | Illinois | 17093 | 30735 | 168 |
2320042 | 2320042 | 2022-03-18 | Kendall | Texas | 48259 | 8119 | 117 |
2314678 | 2314678 | 2022-03-17 | Kendall | Illinois | 17093 | 30713 | 167 |
2316788 | 2316788 | 2022-03-17 | Kendall | Texas | 48259 | 8114 | 117 |
2311425 | 2311425 | 2022-03-16 | Kendall | Illinois | 17093 | 30693 | 167 |
2313535 | 2313535 | 2022-03-16 | Kendall | Texas | 48259 | 8106 | 117 |
2308172 | 2308172 | 2022-03-15 | Kendall | Illinois | 17093 | 30682 | 167 |
2310282 | 2310282 | 2022-03-15 | Kendall | Texas | 48259 | 8095 | 117 |
2304921 | 2304921 | 2022-03-14 | Kendall | Illinois | 17093 | 30671 | 166 |
2307029 | 2307029 | 2022-03-14 | Kendall | Texas | 48259 | 8083 | 117 |
2301669 | 2301669 | 2022-03-13 | Kendall | Illinois | 17093 | 30637 | 166 |
2303778 | 2303778 | 2022-03-13 | Kendall | Texas | 48259 | 8080 | 117 |
2298417 | 2298417 | 2022-03-12 | Kendall | Illinois | 17093 | 30637 | 166 |
2300526 | 2300526 | 2022-03-12 | Kendall | Texas | 48259 | 8080 | 117 |
2295165 | 2295165 | 2022-03-11 | Kendall | Illinois | 17093 | 30637 | 166 |
2297274 | 2297274 | 2022-03-11 | Kendall | Texas | 48259 | 8072 | 117 |
2291913 | 2291913 | 2022-03-10 | Kendall | Illinois | 17093 | 30614 | 166 |
2294022 | 2294022 | 2022-03-10 | Kendall | Texas | 48259 | 8060 | 116 |
2288661 | 2288661 | 2022-03-09 | Kendall | Illinois | 17093 | 30600 | 165 |
2290770 | 2290770 | 2022-03-09 | Kendall | Texas | 48259 | 8045 | 116 |
2285410 | 2285410 | 2022-03-08 | Kendall | Illinois | 17093 | 30582 | 165 |
2287518 | 2287518 | 2022-03-08 | Kendall | Texas | 48259 | 8037 | 116 |
2282158 | 2282158 | 2022-03-07 | Kendall | Illinois | 17093 | 30574 | 165 |
2284266 | 2284266 | 2022-03-07 | Kendall | Texas | 48259 | 8024 | 116 |
2278905 | 2278905 | 2022-03-06 | Kendall | Illinois | 17093 | 30547 | 165 |
2281014 | 2281014 | 2022-03-06 | Kendall | Texas | 48259 | 8023 | 116 |
2275652 | 2275652 | 2022-03-05 | Kendall | Illinois | 17093 | 30547 | 165 |
2277761 | 2277761 | 2022-03-05 | Kendall | Texas | 48259 | 8021 | 115 |
2272399 | 2272399 | 2022-03-04 | Kendall | Illinois | 17093 | 30547 | 165 |
2274508 | 2274508 | 2022-03-04 | Kendall | Texas | 48259 | 8010 | 115 |
2269147 | 2269147 | 2022-03-03 | Kendall | Illinois | 17093 | 30532 | 164 |
2271255 | 2271255 | 2022-03-03 | Kendall | Texas | 48259 | 8003 | 115 |
2265894 | 2265894 | 2022-03-02 | Kendall | Illinois | 17093 | 30519 | 164 |
2268003 | 2268003 | 2022-03-02 | Kendall | Texas | 48259 | 7985 | 115 |
2262643 | 2262643 | 2022-03-01 | Kendall | Illinois | 17093 | 30513 | 164 |
2264750 | 2264750 | 2022-03-01 | Kendall | Texas | 48259 | 7977 | 115 |
2259392 | 2259392 | 2022-02-28 | Kendall | Illinois | 17093 | 30495 | 164 |
2261500 | 2261500 | 2022-02-28 | Kendall | Texas | 48259 | 7969 | 115 |
2256141 | 2256141 | 2022-02-27 | Kendall | Illinois | 17093 | 30458 | 163 |
2258249 | 2258249 | 2022-02-27 | Kendall | Texas | 48259 | 7964 | 115 |
2252890 | 2252890 | 2022-02-26 | Kendall | Illinois | 17093 | 30458 | 163 |
2254998 | 2254998 | 2022-02-26 | Kendall | Texas | 48259 | 7963 | 115 |
2249639 | 2249639 | 2022-02-25 | Kendall | Illinois | 17093 | 30458 | 163 |
2251747 | 2251747 | 2022-02-25 | Kendall | Texas | 48259 | 7954 | 115 |
2246388 | 2246388 | 2022-02-24 | Kendall | Illinois | 17093 | 30434 | 163 |
2248496 | 2248496 | 2022-02-24 | Kendall | Texas | 48259 | 7934 | 115 |
2243137 | 2243137 | 2022-02-23 | Kendall | Illinois | 17093 | 30418 | 162 |
2245245 | 2245245 | 2022-02-23 | Kendall | Texas | 48259 | 7912 | 115 |
2239886 | 2239886 | 2022-02-22 | Kendall | Illinois | 17093 | 30387 | 162 |
2241994 | 2241994 | 2022-02-22 | Kendall | Texas | 48259 | 7904 | 114 |
2236635 | 2236635 | 2022-02-21 | Kendall | Illinois | 17093 | 30316 | 161 |
2238743 | 2238743 | 2022-02-21 | Kendall | Texas | 48259 | 7894 | 114 |
2233384 | 2233384 | 2022-02-20 | Kendall | Illinois | 17093 | 30316 | 161 |
2235492 | 2235492 | 2022-02-20 | Kendall | Texas | 48259 | 7890 | 114 |
2230133 | 2230133 | 2022-02-19 | Kendall | Illinois | 17093 | 30316 | 161 |
2232241 | 2232241 | 2022-02-19 | Kendall | Texas | 48259 | 7888 | 114 |
2226882 | 2226882 | 2022-02-18 | Kendall | Illinois | 17093 | 30316 | 161 |
2228990 | 2228990 | 2022-02-18 | Kendall | Texas | 48259 | 7882 | 113 |
2223631 | 2223631 | 2022-02-17 | Kendall | Illinois | 17093 | 30289 | 161 |
2225739 | 2225739 | 2022-02-17 | Kendall | Texas | 48259 | 7875 | 113 |
2220380 | 2220380 | 2022-02-16 | Kendall | Illinois | 17093 | 30265 | 160 |
2222488 | 2222488 | 2022-02-16 | Kendall | Texas | 48259 | 7859 | 113 |
2217129 | 2217129 | 2022-02-15 | Kendall | Illinois | 17093 | 30227 | 158 |
2219237 | 2219237 | 2022-02-15 | Kendall | Texas | 48259 | 7841 | 113 |
2213878 | 2213878 | 2022-02-14 | Kendall | Illinois | 17093 | 30131 | 158 |
2215986 | 2215986 | 2022-02-14 | Kendall | Texas | 48259 | 7821 | 113 |
2210626 | 2210626 | 2022-02-13 | Kendall | Illinois | 17093 | 29872 | 158 |
2212735 | 2212735 | 2022-02-13 | Kendall | Texas | 48259 | 7816 | 113 |
2207373 | 2207373 | 2022-02-12 | Kendall | Illinois | 17093 | 29872 | 158 |
2209482 | 2209482 | 2022-02-12 | Kendall | Texas | 48259 | 7799 | 111 |
2204120 | 2204120 | 2022-02-11 | Kendall | Illinois | 17093 | 29872 | 158 |
2206229 | 2206229 | 2022-02-11 | Kendall | Texas | 48259 | 7779 | 110 |
2200867 | 2200867 | 2022-02-10 | Kendall | Illinois | 17093 | 29872 | 158 |
2202976 | 2202976 | 2022-02-10 | Kendall | Texas | 48259 | 7762 | 110 |
2197613 | 2197613 | 2022-02-09 | Kendall | Illinois | 17093 | 29791 | 157 |
2199722 | 2199722 | 2022-02-09 | Kendall | Texas | 48259 | 7738 | 110 |
2194359 | 2194359 | 2022-02-08 | Kendall | Illinois | 17093 | 29735 | 156 |
2196468 | 2196468 | 2022-02-08 | Kendall | Texas | 48259 | 7714 | 109 |
2191105 | 2191105 | 2022-02-07 | Kendall | Illinois | 17093 | 29649 | 155 |
2193214 | 2193214 | 2022-02-07 | Kendall | Texas | 48259 | 7688 | 108 |
2187852 | 2187852 | 2022-02-06 | Kendall | Illinois | 17093 | 29474 | 153 |
2189960 | 2189960 | 2022-02-06 | Kendall | Texas | 48259 | 7673 | 108 |
2184599 | 2184599 | 2022-02-05 | Kendall | Illinois | 17093 | 29474 | 153 |
2186707 | 2186707 | 2022-02-05 | Kendall | Texas | 48259 | 7648 | 108 |
2181347 | 2181347 | 2022-02-04 | Kendall | Illinois | 17093 | 29474 | 153 |
2183455 | 2183455 | 2022-02-04 | Kendall | Texas | 48259 | 7615 | 107 |
2178096 | 2178096 | 2022-02-03 | Kendall | Illinois | 17093 | 29304 | 152 |
2180203 | 2180203 | 2022-02-03 | Kendall | Texas | 48259 | 7591 | 107 |
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);