ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,537 rows where county = "Tyler" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502436 | 2502436 | 2022-05-13 | Tyler | Texas | 48457 | 3405 | 88 |
2502730 | 2502730 | 2022-05-13 | Tyler | West Virginia | 54095 | 2214 | 32 |
2499178 | 2499178 | 2022-05-12 | Tyler | Texas | 48457 | 3404 | 88 |
2499472 | 2499472 | 2022-05-12 | Tyler | West Virginia | 54095 | 2214 | 32 |
2495920 | 2495920 | 2022-05-11 | Tyler | Texas | 48457 | 3403 | 88 |
2496214 | 2496214 | 2022-05-11 | Tyler | West Virginia | 54095 | 2208 | 32 |
2492662 | 2492662 | 2022-05-10 | Tyler | Texas | 48457 | 3403 | 88 |
2492956 | 2492956 | 2022-05-10 | Tyler | West Virginia | 54095 | 2208 | 32 |
2489404 | 2489404 | 2022-05-09 | Tyler | Texas | 48457 | 3402 | 88 |
2489698 | 2489698 | 2022-05-09 | Tyler | West Virginia | 54095 | 2208 | 32 |
2486146 | 2486146 | 2022-05-08 | Tyler | Texas | 48457 | 3402 | 88 |
2486441 | 2486441 | 2022-05-08 | Tyler | West Virginia | 54095 | 2208 | 32 |
2482888 | 2482888 | 2022-05-07 | Tyler | Texas | 48457 | 3402 | 88 |
2483183 | 2483183 | 2022-05-07 | Tyler | West Virginia | 54095 | 2208 | 32 |
2479630 | 2479630 | 2022-05-06 | Tyler | Texas | 48457 | 3402 | 88 |
2479925 | 2479925 | 2022-05-06 | Tyler | West Virginia | 54095 | 2208 | 32 |
2476372 | 2476372 | 2022-05-05 | Tyler | Texas | 48457 | 3401 | 88 |
2476667 | 2476667 | 2022-05-05 | Tyler | West Virginia | 54095 | 2208 | 32 |
2473115 | 2473115 | 2022-05-04 | Tyler | Texas | 48457 | 3400 | 88 |
2473409 | 2473409 | 2022-05-04 | Tyler | West Virginia | 54095 | 2205 | 32 |
2469859 | 2469859 | 2022-05-03 | Tyler | Texas | 48457 | 3398 | 88 |
2470152 | 2470152 | 2022-05-03 | Tyler | West Virginia | 54095 | 2205 | 32 |
2466603 | 2466603 | 2022-05-02 | Tyler | Texas | 48457 | 3398 | 88 |
2466896 | 2466896 | 2022-05-02 | Tyler | West Virginia | 54095 | 2205 | 32 |
2463348 | 2463348 | 2022-05-01 | Tyler | Texas | 48457 | 3398 | 88 |
2463641 | 2463641 | 2022-05-01 | Tyler | West Virginia | 54095 | 2204 | 32 |
2460092 | 2460092 | 2022-04-30 | Tyler | Texas | 48457 | 3397 | 88 |
2460385 | 2460385 | 2022-04-30 | Tyler | West Virginia | 54095 | 2204 | 32 |
2456836 | 2456836 | 2022-04-29 | Tyler | Texas | 48457 | 3396 | 88 |
2457129 | 2457129 | 2022-04-29 | Tyler | West Virginia | 54095 | 2204 | 32 |
2453580 | 2453580 | 2022-04-28 | Tyler | Texas | 48457 | 3395 | 88 |
2453873 | 2453873 | 2022-04-28 | Tyler | West Virginia | 54095 | 2205 | 32 |
2450324 | 2450324 | 2022-04-27 | Tyler | Texas | 48457 | 3393 | 88 |
2450617 | 2450617 | 2022-04-27 | Tyler | West Virginia | 54095 | 2205 | 32 |
2447067 | 2447067 | 2022-04-26 | Tyler | Texas | 48457 | 3392 | 88 |
2447361 | 2447361 | 2022-04-26 | Tyler | West Virginia | 54095 | 2203 | 32 |
2443812 | 2443812 | 2022-04-25 | Tyler | Texas | 48457 | 3391 | 88 |
2444105 | 2444105 | 2022-04-25 | Tyler | West Virginia | 54095 | 2203 | 31 |
2440556 | 2440556 | 2022-04-24 | Tyler | Texas | 48457 | 3391 | 88 |
2440849 | 2440849 | 2022-04-24 | Tyler | West Virginia | 54095 | 2203 | 31 |
2437300 | 2437300 | 2022-04-23 | Tyler | Texas | 48457 | 3390 | 88 |
2437593 | 2437593 | 2022-04-23 | Tyler | West Virginia | 54095 | 2203 | 31 |
2434044 | 2434044 | 2022-04-22 | Tyler | Texas | 48457 | 3389 | 88 |
2434337 | 2434337 | 2022-04-22 | Tyler | West Virginia | 54095 | 2203 | 31 |
2430788 | 2430788 | 2022-04-21 | Tyler | Texas | 48457 | 3389 | 88 |
2431081 | 2431081 | 2022-04-21 | Tyler | West Virginia | 54095 | 2203 | 31 |
2427532 | 2427532 | 2022-04-20 | Tyler | Texas | 48457 | 3389 | 88 |
2427825 | 2427825 | 2022-04-20 | Tyler | West Virginia | 54095 | 2201 | 31 |
2424276 | 2424276 | 2022-04-19 | Tyler | Texas | 48457 | 3389 | 88 |
2424569 | 2424569 | 2022-04-19 | Tyler | West Virginia | 54095 | 2201 | 31 |
2421020 | 2421020 | 2022-04-18 | Tyler | Texas | 48457 | 3387 | 87 |
2421313 | 2421313 | 2022-04-18 | Tyler | West Virginia | 54095 | 2201 | 30 |
2417764 | 2417764 | 2022-04-17 | Tyler | Texas | 48457 | 3387 | 87 |
2418057 | 2418057 | 2022-04-17 | Tyler | West Virginia | 54095 | 2200 | 30 |
2414508 | 2414508 | 2022-04-16 | Tyler | Texas | 48457 | 3387 | 87 |
2414801 | 2414801 | 2022-04-16 | Tyler | West Virginia | 54095 | 2200 | 30 |
2411252 | 2411252 | 2022-04-15 | Tyler | Texas | 48457 | 3387 | 87 |
2411545 | 2411545 | 2022-04-15 | Tyler | West Virginia | 54095 | 2200 | 30 |
2407996 | 2407996 | 2022-04-14 | Tyler | Texas | 48457 | 3387 | 87 |
2408289 | 2408289 | 2022-04-14 | Tyler | West Virginia | 54095 | 2200 | 30 |
2404740 | 2404740 | 2022-04-13 | Tyler | Texas | 48457 | 3387 | 86 |
2405033 | 2405033 | 2022-04-13 | Tyler | West Virginia | 54095 | 2200 | 30 |
2401485 | 2401485 | 2022-04-12 | Tyler | Texas | 48457 | 3387 | 86 |
2401778 | 2401778 | 2022-04-12 | Tyler | West Virginia | 54095 | 2200 | 30 |
2398230 | 2398230 | 2022-04-11 | Tyler | Texas | 48457 | 3387 | 86 |
2398523 | 2398523 | 2022-04-11 | Tyler | West Virginia | 54095 | 2200 | 30 |
2394975 | 2394975 | 2022-04-10 | Tyler | Texas | 48457 | 3387 | 86 |
2395268 | 2395268 | 2022-04-10 | Tyler | West Virginia | 54095 | 2200 | 30 |
2391719 | 2391719 | 2022-04-09 | Tyler | Texas | 48457 | 3387 | 86 |
2392012 | 2392012 | 2022-04-09 | Tyler | West Virginia | 54095 | 2200 | 30 |
2388463 | 2388463 | 2022-04-08 | Tyler | Texas | 48457 | 3387 | 86 |
2388756 | 2388756 | 2022-04-08 | Tyler | West Virginia | 54095 | 2200 | 30 |
2385208 | 2385208 | 2022-04-07 | Tyler | Texas | 48457 | 3387 | 86 |
2385501 | 2385501 | 2022-04-07 | Tyler | West Virginia | 54095 | 2200 | 30 |
2381953 | 2381953 | 2022-04-06 | Tyler | Texas | 48457 | 3387 | 86 |
2382246 | 2382246 | 2022-04-06 | Tyler | West Virginia | 54095 | 2200 | 30 |
2378698 | 2378698 | 2022-04-05 | Tyler | Texas | 48457 | 3386 | 86 |
2378991 | 2378991 | 2022-04-05 | Tyler | West Virginia | 54095 | 2200 | 30 |
2375444 | 2375444 | 2022-04-04 | Tyler | Texas | 48457 | 3386 | 86 |
2375737 | 2375737 | 2022-04-04 | Tyler | West Virginia | 54095 | 2199 | 31 |
2372192 | 2372192 | 2022-04-03 | Tyler | Texas | 48457 | 3386 | 86 |
2372485 | 2372485 | 2022-04-03 | Tyler | West Virginia | 54095 | 2199 | 31 |
2368939 | 2368939 | 2022-04-02 | Tyler | Texas | 48457 | 3386 | 86 |
2369232 | 2369232 | 2022-04-02 | Tyler | West Virginia | 54095 | 2199 | 31 |
2365686 | 2365686 | 2022-04-01 | Tyler | Texas | 48457 | 3386 | 86 |
2365979 | 2365979 | 2022-04-01 | Tyler | West Virginia | 54095 | 2199 | 31 |
2362433 | 2362433 | 2022-03-31 | Tyler | Texas | 48457 | 3383 | 86 |
2362726 | 2362726 | 2022-03-31 | Tyler | West Virginia | 54095 | 2198 | 31 |
2359179 | 2359179 | 2022-03-30 | Tyler | Texas | 48457 | 3380 | 86 |
2359472 | 2359472 | 2022-03-30 | Tyler | West Virginia | 54095 | 2198 | 31 |
2355925 | 2355925 | 2022-03-29 | Tyler | Texas | 48457 | 3379 | 86 |
2356218 | 2356218 | 2022-03-29 | Tyler | West Virginia | 54095 | 2196 | 31 |
2352672 | 2352672 | 2022-03-28 | Tyler | Texas | 48457 | 3379 | 85 |
2352965 | 2352965 | 2022-03-28 | Tyler | West Virginia | 54095 | 2196 | 31 |
2349420 | 2349420 | 2022-03-27 | Tyler | Texas | 48457 | 3379 | 85 |
2349713 | 2349713 | 2022-03-27 | Tyler | West Virginia | 54095 | 2196 | 31 |
2346167 | 2346167 | 2022-03-26 | Tyler | Texas | 48457 | 3379 | 85 |
2346460 | 2346460 | 2022-03-26 | Tyler | West Virginia | 54095 | 2196 | 31 |
2342914 | 2342914 | 2022-03-25 | Tyler | Texas | 48457 | 3379 | 85 |
2343207 | 2343207 | 2022-03-25 | Tyler | West Virginia | 54095 | 2196 | 31 |
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);