ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
170 rows where county = "Jackson" and deaths = 59 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 15
- Texas 73
- West Virginia 18
- Louisiana 17
- Oklahoma 14
- Kentucky 11
- Iowa 7
- Ohio 7
- Tennessee 7
- Mississippi 4
- Missouri 4
- Arkansas 3
- Michigan 2
- Florida 1
- Illinois 1
- North Carolina 1
fips 15
county 1
- Jackson · 170 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502326 | 2502326 | 2022-05-13 | Jackson | Texas | 48239 | 3258 | 59 |
2499068 | 2499068 | 2022-05-12 | Jackson | Texas | 48239 | 3258 | 59 |
2495810 | 2495810 | 2022-05-11 | Jackson | Texas | 48239 | 3258 | 59 |
2492552 | 2492552 | 2022-05-10 | Jackson | Texas | 48239 | 3258 | 59 |
2489294 | 2489294 | 2022-05-09 | Jackson | Texas | 48239 | 3257 | 59 |
2486037 | 2486037 | 2022-05-08 | Jackson | Texas | 48239 | 3257 | 59 |
2482779 | 2482779 | 2022-05-07 | Jackson | Texas | 48239 | 3257 | 59 |
2479521 | 2479521 | 2022-05-06 | Jackson | Texas | 48239 | 3257 | 59 |
2476263 | 2476263 | 2022-05-05 | Jackson | Texas | 48239 | 3257 | 59 |
2473006 | 2473006 | 2022-05-04 | Jackson | Texas | 48239 | 3257 | 59 |
2469750 | 2469750 | 2022-05-03 | Jackson | Texas | 48239 | 3257 | 59 |
2466494 | 2466494 | 2022-05-02 | Jackson | Texas | 48239 | 3257 | 59 |
2463239 | 2463239 | 2022-05-01 | Jackson | Texas | 48239 | 3257 | 59 |
2459983 | 2459983 | 2022-04-30 | Jackson | Texas | 48239 | 3257 | 59 |
2456727 | 2456727 | 2022-04-29 | Jackson | Texas | 48239 | 3257 | 59 |
2453471 | 2453471 | 2022-04-28 | Jackson | Texas | 48239 | 3257 | 59 |
2450215 | 2450215 | 2022-04-27 | Jackson | Texas | 48239 | 3257 | 59 |
2446958 | 2446958 | 2022-04-26 | Jackson | Texas | 48239 | 3257 | 59 |
2443703 | 2443703 | 2022-04-25 | Jackson | Texas | 48239 | 3256 | 59 |
2440447 | 2440447 | 2022-04-24 | Jackson | Texas | 48239 | 3255 | 59 |
2437191 | 2437191 | 2022-04-23 | Jackson | Texas | 48239 | 3255 | 59 |
2433935 | 2433935 | 2022-04-22 | Jackson | Texas | 48239 | 3255 | 59 |
2430679 | 2430679 | 2022-04-21 | Jackson | Texas | 48239 | 3254 | 59 |
2427423 | 2427423 | 2022-04-20 | Jackson | Texas | 48239 | 3254 | 59 |
2424167 | 2424167 | 2022-04-19 | Jackson | Texas | 48239 | 3254 | 59 |
2420911 | 2420911 | 2022-04-18 | Jackson | Texas | 48239 | 3254 | 59 |
2417655 | 2417655 | 2022-04-17 | Jackson | Texas | 48239 | 3254 | 59 |
2414399 | 2414399 | 2022-04-16 | Jackson | Texas | 48239 | 3254 | 59 |
2411143 | 2411143 | 2022-04-15 | Jackson | Texas | 48239 | 3254 | 59 |
2407887 | 2407887 | 2022-04-14 | Jackson | Texas | 48239 | 3254 | 59 |
2404631 | 2404631 | 2022-04-13 | Jackson | Texas | 48239 | 3253 | 59 |
2401376 | 2401376 | 2022-04-12 | Jackson | Texas | 48239 | 3253 | 59 |
2398121 | 2398121 | 2022-04-11 | Jackson | Texas | 48239 | 3253 | 59 |
2394866 | 2394866 | 2022-04-10 | Jackson | Texas | 48239 | 3253 | 59 |
2391610 | 2391610 | 2022-04-09 | Jackson | Texas | 48239 | 3253 | 59 |
2388354 | 2388354 | 2022-04-08 | Jackson | Texas | 48239 | 3253 | 59 |
2385099 | 2385099 | 2022-04-07 | Jackson | Texas | 48239 | 3251 | 59 |
2381844 | 2381844 | 2022-04-06 | Jackson | Texas | 48239 | 3251 | 59 |
2378589 | 2378589 | 2022-04-05 | Jackson | Texas | 48239 | 3251 | 59 |
2375335 | 2375335 | 2022-04-04 | Jackson | Texas | 48239 | 3251 | 59 |
2372083 | 2372083 | 2022-04-03 | Jackson | Texas | 48239 | 3251 | 59 |
2368830 | 2368830 | 2022-04-02 | Jackson | Texas | 48239 | 3251 | 59 |
2365577 | 2365577 | 2022-04-01 | Jackson | Texas | 48239 | 3251 | 59 |
2362324 | 2362324 | 2022-03-31 | Jackson | Texas | 48239 | 3251 | 59 |
2359070 | 2359070 | 2022-03-30 | Jackson | Texas | 48239 | 3250 | 59 |
2355816 | 2355816 | 2022-03-29 | Jackson | Texas | 48239 | 3250 | 59 |
2352563 | 2352563 | 2022-03-28 | Jackson | Texas | 48239 | 3249 | 59 |
2349311 | 2349311 | 2022-03-27 | Jackson | Texas | 48239 | 3249 | 59 |
2346058 | 2346058 | 2022-03-26 | Jackson | Texas | 48239 | 3249 | 59 |
2342805 | 2342805 | 2022-03-25 | Jackson | Texas | 48239 | 3249 | 59 |
2339552 | 2339552 | 2022-03-24 | Jackson | Texas | 48239 | 3248 | 59 |
2336298 | 2336298 | 2022-03-23 | Jackson | Texas | 48239 | 3242 | 59 |
2333044 | 2333044 | 2022-03-22 | Jackson | Texas | 48239 | 3242 | 59 |
2329791 | 2329791 | 2022-03-21 | Jackson | Texas | 48239 | 3235 | 59 |
2326539 | 2326539 | 2022-03-20 | Jackson | Texas | 48239 | 3235 | 59 |
2320681 | 2320681 | 2022-03-19 | Jackson | Arkansas | 5067 | 6054 | 59 |
2323286 | 2323286 | 2022-03-19 | Jackson | Texas | 48239 | 3234 | 59 |
2317427 | 2317427 | 2022-03-18 | Jackson | Arkansas | 5067 | 6036 | 59 |
2320032 | 2320032 | 2022-03-18 | Jackson | Texas | 48239 | 3234 | 59 |
2314174 | 2314174 | 2022-03-17 | Jackson | Arkansas | 5067 | 6023 | 59 |
2316778 | 2316778 | 2022-03-17 | Jackson | Texas | 48239 | 3228 | 59 |
2313525 | 2313525 | 2022-03-16 | Jackson | Texas | 48239 | 3228 | 59 |
2310272 | 2310272 | 2022-03-15 | Jackson | Texas | 48239 | 3228 | 59 |
2307019 | 2307019 | 2022-03-14 | Jackson | Texas | 48239 | 3227 | 59 |
2303768 | 2303768 | 2022-03-13 | Jackson | Texas | 48239 | 3227 | 59 |
2300516 | 2300516 | 2022-03-12 | Jackson | Texas | 48239 | 3227 | 59 |
2297264 | 2297264 | 2022-03-11 | Jackson | Texas | 48239 | 3227 | 59 |
2294012 | 2294012 | 2022-03-10 | Jackson | Texas | 48239 | 3227 | 59 |
2290760 | 2290760 | 2022-03-09 | Jackson | Texas | 48239 | 3225 | 59 |
2287336 | 2287336 | 2022-03-08 | Jackson | Tennessee | 47087 | 3189 | 59 |
2287508 | 2287508 | 2022-03-08 | Jackson | Texas | 48239 | 3225 | 59 |
2284084 | 2284084 | 2022-03-07 | Jackson | Tennessee | 47087 | 3189 | 59 |
2284256 | 2284256 | 2022-03-07 | Jackson | Texas | 48239 | 3223 | 59 |
2280832 | 2280832 | 2022-03-06 | Jackson | Tennessee | 47087 | 3189 | 59 |
2281004 | 2281004 | 2022-03-06 | Jackson | Texas | 48239 | 3223 | 59 |
2277579 | 2277579 | 2022-03-05 | Jackson | Tennessee | 47087 | 3189 | 59 |
2277751 | 2277751 | 2022-03-05 | Jackson | Texas | 48239 | 3223 | 59 |
2274326 | 2274326 | 2022-03-04 | Jackson | Tennessee | 47087 | 3189 | 59 |
2274498 | 2274498 | 2022-03-04 | Jackson | Texas | 48239 | 3223 | 59 |
2271073 | 2271073 | 2022-03-03 | Jackson | Tennessee | 47087 | 3189 | 59 |
2271245 | 2271245 | 2022-03-03 | Jackson | Texas | 48239 | 3223 | 59 |
2267821 | 2267821 | 2022-03-02 | Jackson | Tennessee | 47087 | 3189 | 59 |
2267993 | 2267993 | 2022-03-02 | Jackson | Texas | 48239 | 3220 | 59 |
2110185 | 2110185 | 2022-01-13 | Jackson | Kentucky | 21109 | 3209 | 59 |
2106934 | 2106934 | 2022-01-12 | Jackson | Kentucky | 21109 | 3189 | 59 |
2103472 | 2103472 | 2022-01-11 | Jackson | Iowa | 19097 | 3819 | 59 |
2103683 | 2103683 | 2022-01-11 | Jackson | Kentucky | 21109 | 3168 | 59 |
2100221 | 2100221 | 2022-01-10 | Jackson | Iowa | 19097 | 3819 | 59 |
2100432 | 2100432 | 2022-01-10 | Jackson | Kentucky | 21109 | 3160 | 59 |
2096970 | 2096970 | 2022-01-09 | Jackson | Iowa | 19097 | 3819 | 59 |
2097181 | 2097181 | 2022-01-09 | Jackson | Kentucky | 21109 | 3155 | 59 |
2093718 | 2093718 | 2022-01-08 | Jackson | Iowa | 19097 | 3819 | 59 |
2093929 | 2093929 | 2022-01-08 | Jackson | Kentucky | 21109 | 3155 | 59 |
2090466 | 2090466 | 2022-01-07 | Jackson | Iowa | 19097 | 3819 | 59 |
2090677 | 2090677 | 2022-01-07 | Jackson | Kentucky | 21109 | 3155 | 59 |
2087215 | 2087215 | 2022-01-06 | Jackson | Iowa | 19097 | 3819 | 59 |
2087426 | 2087426 | 2022-01-06 | Jackson | Kentucky | 21109 | 3141 | 59 |
2083963 | 2083963 | 2022-01-05 | Jackson | Iowa | 19097 | 3819 | 59 |
2084174 | 2084174 | 2022-01-05 | Jackson | Kentucky | 21109 | 3129 | 59 |
2080922 | 2080922 | 2022-01-04 | Jackson | Kentucky | 21109 | 3118 | 59 |
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);