ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

779 rows where county = "Jackson" and fips = 48239 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 48239 · 779 ✖

county 1

  • Jackson · 779 ✖
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
2323286 2323286 2022-03-19 Jackson Texas 48239 3234 59
2320032 2320032 2022-03-18 Jackson Texas 48239 3234 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
2287508 2287508 2022-03-08 Jackson Texas 48239 3225 59
2284256 2284256 2022-03-07 Jackson Texas 48239 3223 59
2281004 2281004 2022-03-06 Jackson Texas 48239 3223 59
2277751 2277751 2022-03-05 Jackson Texas 48239 3223 59
2274498 2274498 2022-03-04 Jackson Texas 48239 3223 59
2271245 2271245 2022-03-03 Jackson Texas 48239 3223 59
2267993 2267993 2022-03-02 Jackson Texas 48239 3220 59
2264740 2264740 2022-03-01 Jackson Texas 48239 3218 58
2261490 2261490 2022-02-28 Jackson Texas 48239 3216 58
2258239 2258239 2022-02-27 Jackson Texas 48239 3215 58
2254988 2254988 2022-02-26 Jackson Texas 48239 3212 58
2251737 2251737 2022-02-25 Jackson Texas 48239 3212 58
2248486 2248486 2022-02-24 Jackson Texas 48239 3210 58
2245235 2245235 2022-02-23 Jackson Texas 48239 3207 58
2241984 2241984 2022-02-22 Jackson Texas 48239 3207 57
2238733 2238733 2022-02-21 Jackson Texas 48239 3205 56
2235482 2235482 2022-02-20 Jackson Texas 48239 3176 56
2232231 2232231 2022-02-19 Jackson Texas 48239 3173 56
2228980 2228980 2022-02-18 Jackson Texas 48239 3170 56
2225729 2225729 2022-02-17 Jackson Texas 48239 3169 56
2222478 2222478 2022-02-16 Jackson Texas 48239 3167 55
2219227 2219227 2022-02-15 Jackson Texas 48239 3164 55
2215976 2215976 2022-02-14 Jackson Texas 48239 3160 55
2212725 2212725 2022-02-13 Jackson Texas 48239 3157 55
2209472 2209472 2022-02-12 Jackson Texas 48239 3151 55
2206219 2206219 2022-02-11 Jackson Texas 48239 3147 55
2202966 2202966 2022-02-10 Jackson Texas 48239 3143 55
2199712 2199712 2022-02-09 Jackson Texas 48239 3142 55
2196458 2196458 2022-02-08 Jackson Texas 48239 3140 55
2193204 2193204 2022-02-07 Jackson Texas 48239 3136 55
2189950 2189950 2022-02-06 Jackson Texas 48239 3133 55
2186697 2186697 2022-02-05 Jackson Texas 48239 3133 55
2183445 2183445 2022-02-04 Jackson Texas 48239 3123 55
2180193 2180193 2022-02-03 Jackson Texas 48239 3116 55

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);