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)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500223 | 2500223 | 2022-05-13 | Kendall | Illinois | 17093 | 32538 | 171 |
2502336 | 2502336 | 2022-05-13 | Kendall | Texas | 48259 | 8263 | 119 |
2496965 | 2496965 | 2022-05-12 | Kendall | Illinois | 17093 | 32402 | 171 |
2499078 | 2499078 | 2022-05-12 | Kendall | Texas | 48259 | 8257 | 119 |
2493707 | 2493707 | 2022-05-11 | Kendall | Illinois | 17093 | 32345 | 171 |
2495820 | 2495820 | 2022-05-11 | Kendall | Texas | 48259 | 8252 | 119 |
2490449 | 2490449 | 2022-05-10 | Kendall | Illinois | 17093 | 32269 | 170 |
2492562 | 2492562 | 2022-05-10 | Kendall | Texas | 48259 | 8250 | 119 |
2487192 | 2487192 | 2022-05-09 | Kendall | Illinois | 17093 | 32197 | 170 |
2489304 | 2489304 | 2022-05-09 | Kendall | Texas | 48259 | 8244 | 119 |
2483934 | 2483934 | 2022-05-08 | Kendall | Illinois | 17093 | 31968 | 170 |
2486047 | 2486047 | 2022-05-08 | Kendall | Texas | 48259 | 8242 | 119 |
2480676 | 2480676 | 2022-05-07 | Kendall | Illinois | 17093 | 31968 | 170 |
2482789 | 2482789 | 2022-05-07 | Kendall | Texas | 48259 | 8240 | 118 |
2477418 | 2477418 | 2022-05-06 | Kendall | Illinois | 17093 | 31968 | 170 |
2479531 | 2479531 | 2022-05-06 | Kendall | Texas | 48259 | 8237 | 118 |
2474160 | 2474160 | 2022-05-05 | Kendall | Illinois | 17093 | 31874 | 170 |
2476273 | 2476273 | 2022-05-05 | Kendall | Texas | 48259 | 8236 | 118 |
2470903 | 2470903 | 2022-05-04 | Kendall | Illinois | 17093 | 31827 | 170 |
2473016 | 2473016 | 2022-05-04 | Kendall | Texas | 48259 | 8234 | 118 |
2467647 | 2467647 | 2022-05-03 | Kendall | Illinois | 17093 | 31774 | 170 |
2469760 | 2469760 | 2022-05-03 | Kendall | Texas | 48259 | 8232 | 118 |
2464392 | 2464392 | 2022-05-02 | Kendall | Illinois | 17093 | 31719 | 170 |
2466504 | 2466504 | 2022-05-02 | Kendall | Texas | 48259 | 8232 | 118 |
2461136 | 2461136 | 2022-05-01 | Kendall | Illinois | 17093 | 31600 | 170 |
2463249 | 2463249 | 2022-05-01 | Kendall | Texas | 48259 | 8230 | 118 |
2457880 | 2457880 | 2022-04-30 | Kendall | Illinois | 17093 | 31600 | 170 |
2459993 | 2459993 | 2022-04-30 | Kendall | Texas | 48259 | 8228 | 118 |
2454624 | 2454624 | 2022-04-29 | Kendall | Illinois | 17093 | 31600 | 170 |
2456737 | 2456737 | 2022-04-29 | Kendall | Texas | 48259 | 8223 | 118 |
2451368 | 2451368 | 2022-04-28 | Kendall | Illinois | 17093 | 31560 | 170 |
2453481 | 2453481 | 2022-04-28 | Kendall | Texas | 48259 | 8221 | 118 |
2448112 | 2448112 | 2022-04-27 | Kendall | Illinois | 17093 | 31502 | 170 |
2450225 | 2450225 | 2022-04-27 | Kendall | Texas | 48259 | 8215 | 118 |
2444856 | 2444856 | 2022-04-26 | Kendall | Illinois | 17093 | 31468 | 170 |
2446968 | 2446968 | 2022-04-26 | Kendall | Texas | 48259 | 8213 | 118 |
2441600 | 2441600 | 2022-04-25 | Kendall | Illinois | 17093 | 31442 | 170 |
2443713 | 2443713 | 2022-04-25 | Kendall | Texas | 48259 | 8202 | 118 |
2438344 | 2438344 | 2022-04-24 | Kendall | Illinois | 17093 | 31346 | 170 |
2440457 | 2440457 | 2022-04-24 | Kendall | Texas | 48259 | 8201 | 118 |
2435088 | 2435088 | 2022-04-23 | Kendall | Illinois | 17093 | 31346 | 170 |
2437201 | 2437201 | 2022-04-23 | Kendall | Texas | 48259 | 8199 | 118 |
2431832 | 2431832 | 2022-04-22 | Kendall | Illinois | 17093 | 31346 | 170 |
2433945 | 2433945 | 2022-04-22 | Kendall | Texas | 48259 | 8199 | 118 |
2428576 | 2428576 | 2022-04-21 | Kendall | Illinois | 17093 | 31307 | 170 |
2430689 | 2430689 | 2022-04-21 | Kendall | Texas | 48259 | 8198 | 118 |
2425320 | 2425320 | 2022-04-20 | Kendall | Illinois | 17093 | 31261 | 170 |
2427433 | 2427433 | 2022-04-20 | Kendall | Texas | 48259 | 8196 | 117 |
2422064 | 2422064 | 2022-04-19 | Kendall | Illinois | 17093 | 31220 | 170 |
2424177 | 2424177 | 2022-04-19 | Kendall | Texas | 48259 | 8194 | 117 |
2418808 | 2418808 | 2022-04-18 | Kendall | Illinois | 17093 | 31187 | 170 |
2420921 | 2420921 | 2022-04-18 | Kendall | Texas | 48259 | 8193 | 117 |
2415552 | 2415552 | 2022-04-17 | Kendall | Illinois | 17093 | 31139 | 170 |
2417665 | 2417665 | 2022-04-17 | Kendall | Texas | 48259 | 8186 | 117 |
2412296 | 2412296 | 2022-04-16 | Kendall | Illinois | 17093 | 31139 | 170 |
2414409 | 2414409 | 2022-04-16 | Kendall | Texas | 48259 | 8186 | 117 |
2409040 | 2409040 | 2022-04-15 | Kendall | Illinois | 17093 | 31139 | 170 |
2411153 | 2411153 | 2022-04-15 | Kendall | Texas | 48259 | 8186 | 117 |
2405784 | 2405784 | 2022-04-14 | Kendall | Illinois | 17093 | 31115 | 170 |
2407897 | 2407897 | 2022-04-14 | Kendall | Texas | 48259 | 8186 | 117 |
2402529 | 2402529 | 2022-04-13 | Kendall | Illinois | 17093 | 31087 | 170 |
2404641 | 2404641 | 2022-04-13 | Kendall | Texas | 48259 | 8179 | 118 |
2399274 | 2399274 | 2022-04-12 | Kendall | Illinois | 17093 | 31069 | 170 |
2401386 | 2401386 | 2022-04-12 | Kendall | Texas | 48259 | 8177 | 118 |
2396019 | 2396019 | 2022-04-11 | Kendall | Illinois | 17093 | 31053 | 170 |
2398131 | 2398131 | 2022-04-11 | Kendall | Texas | 48259 | 8175 | 118 |
2392763 | 2392763 | 2022-04-10 | Kendall | Illinois | 17093 | 31010 | 170 |
2394876 | 2394876 | 2022-04-10 | Kendall | Texas | 48259 | 8172 | 118 |
2389507 | 2389507 | 2022-04-09 | Kendall | Illinois | 17093 | 31010 | 170 |
2391620 | 2391620 | 2022-04-09 | Kendall | Texas | 48259 | 8172 | 119 |
2386252 | 2386252 | 2022-04-08 | Kendall | Illinois | 17093 | 31010 | 170 |
2388364 | 2388364 | 2022-04-08 | Kendall | Texas | 48259 | 8170 | 119 |
2382997 | 2382997 | 2022-04-07 | Kendall | Illinois | 17093 | 30991 | 170 |
2385109 | 2385109 | 2022-04-07 | Kendall | Texas | 48259 | 8168 | 119 |
2379742 | 2379742 | 2022-04-06 | Kendall | Illinois | 17093 | 30980 | 170 |
2381854 | 2381854 | 2022-04-06 | Kendall | Texas | 48259 | 8166 | 118 |
2376488 | 2376488 | 2022-04-05 | Kendall | Illinois | 17093 | 30947 | 170 |
2378599 | 2378599 | 2022-04-05 | Kendall | Texas | 48259 | 8165 | 118 |
2373236 | 2373236 | 2022-04-04 | Kendall | Illinois | 17093 | 30930 | 170 |
2375345 | 2375345 | 2022-04-04 | Kendall | Texas | 48259 | 8165 | 118 |
2369983 | 2369983 | 2022-04-03 | Kendall | Illinois | 17093 | 30893 | 170 |
2372093 | 2372093 | 2022-04-03 | Kendall | Texas | 48259 | 8164 | 118 |
2366730 | 2366730 | 2022-04-02 | Kendall | Illinois | 17093 | 30893 | 170 |
2368840 | 2368840 | 2022-04-02 | Kendall | Texas | 48259 | 8164 | 118 |
2363477 | 2363477 | 2022-04-01 | Kendall | Illinois | 17093 | 30893 | 170 |
2365587 | 2365587 | 2022-04-01 | Kendall | Texas | 48259 | 8161 | 118 |
2360223 | 2360223 | 2022-03-31 | Kendall | Illinois | 17093 | 30877 | 170 |
2362334 | 2362334 | 2022-03-31 | Kendall | Texas | 48259 | 8161 | 118 |
2356969 | 2356969 | 2022-03-30 | Kendall | Illinois | 17093 | 30862 | 169 |
2359080 | 2359080 | 2022-03-30 | Kendall | Texas | 48259 | 8161 | 118 |
2353716 | 2353716 | 2022-03-29 | Kendall | Illinois | 17093 | 30857 | 169 |
2355826 | 2355826 | 2022-03-29 | Kendall | Texas | 48259 | 8158 | 118 |
2350464 | 2350464 | 2022-03-28 | Kendall | Illinois | 17093 | 30850 | 169 |
2352573 | 2352573 | 2022-03-28 | Kendall | Texas | 48259 | 8151 | 118 |
2347211 | 2347211 | 2022-03-27 | Kendall | Illinois | 17093 | 30824 | 169 |
2349321 | 2349321 | 2022-03-27 | Kendall | Texas | 48259 | 8151 | 118 |
2343958 | 2343958 | 2022-03-26 | Kendall | Illinois | 17093 | 30824 | 169 |
2346068 | 2346068 | 2022-03-26 | Kendall | Texas | 48259 | 8151 | 118 |
2340705 | 2340705 | 2022-03-25 | Kendall | Illinois | 17093 | 30824 | 169 |
2342815 | 2342815 | 2022-03-25 | Kendall | Texas | 48259 | 8139 | 118 |
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);