ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Jackson" and fips = 1071 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 |
---|---|---|---|---|---|---|---|
2499610 | 2499610 | 2022-05-13 | Jackson | Alabama | 1071 | 15049 | 241 |
2496352 | 2496352 | 2022-05-12 | Jackson | Alabama | 1071 | 15049 | 241 |
2493094 | 2493094 | 2022-05-11 | Jackson | Alabama | 1071 | 15048 | 241 |
2489836 | 2489836 | 2022-05-10 | Jackson | Alabama | 1071 | 15043 | 241 |
2486579 | 2486579 | 2022-05-09 | Jackson | Alabama | 1071 | 15042 | 241 |
2483321 | 2483321 | 2022-05-08 | Jackson | Alabama | 1071 | 15042 | 241 |
2480063 | 2480063 | 2022-05-07 | Jackson | Alabama | 1071 | 15042 | 241 |
2476805 | 2476805 | 2022-05-06 | Jackson | Alabama | 1071 | 15042 | 241 |
2473547 | 2473547 | 2022-05-05 | Jackson | Alabama | 1071 | 15040 | 241 |
2470290 | 2470290 | 2022-05-04 | Jackson | Alabama | 1071 | 15040 | 241 |
2467034 | 2467034 | 2022-05-03 | Jackson | Alabama | 1071 | 15040 | 241 |
2463779 | 2463779 | 2022-05-02 | Jackson | Alabama | 1071 | 15041 | 241 |
2460523 | 2460523 | 2022-05-01 | Jackson | Alabama | 1071 | 15039 | 241 |
2457267 | 2457267 | 2022-04-30 | Jackson | Alabama | 1071 | 15039 | 241 |
2454011 | 2454011 | 2022-04-29 | Jackson | Alabama | 1071 | 15039 | 241 |
2450755 | 2450755 | 2022-04-28 | Jackson | Alabama | 1071 | 15038 | 241 |
2447499 | 2447499 | 2022-04-27 | Jackson | Alabama | 1071 | 15037 | 241 |
2444243 | 2444243 | 2022-04-26 | Jackson | Alabama | 1071 | 15035 | 241 |
2440987 | 2440987 | 2022-04-25 | Jackson | Alabama | 1071 | 15034 | 241 |
2437731 | 2437731 | 2022-04-24 | Jackson | Alabama | 1071 | 15031 | 241 |
2434475 | 2434475 | 2022-04-23 | Jackson | Alabama | 1071 | 15031 | 241 |
2431219 | 2431219 | 2022-04-22 | Jackson | Alabama | 1071 | 15031 | 241 |
2427963 | 2427963 | 2022-04-21 | Jackson | Alabama | 1071 | 15030 | 241 |
2424707 | 2424707 | 2022-04-20 | Jackson | Alabama | 1071 | 15026 | 241 |
2421451 | 2421451 | 2022-04-19 | Jackson | Alabama | 1071 | 15025 | 241 |
2418195 | 2418195 | 2022-04-18 | Jackson | Alabama | 1071 | 15022 | 240 |
2414939 | 2414939 | 2022-04-17 | Jackson | Alabama | 1071 | 15022 | 240 |
2411683 | 2411683 | 2022-04-16 | Jackson | Alabama | 1071 | 15022 | 240 |
2408427 | 2408427 | 2022-04-15 | Jackson | Alabama | 1071 | 15022 | 240 |
2405171 | 2405171 | 2022-04-14 | Jackson | Alabama | 1071 | 15022 | 239 |
2401916 | 2401916 | 2022-04-13 | Jackson | Alabama | 1071 | 15021 | 238 |
2398661 | 2398661 | 2022-04-12 | Jackson | Alabama | 1071 | 15020 | 237 |
2395406 | 2395406 | 2022-04-11 | Jackson | Alabama | 1071 | 15020 | 236 |
2392150 | 2392150 | 2022-04-10 | Jackson | Alabama | 1071 | 15019 | 236 |
2388894 | 2388894 | 2022-04-09 | Jackson | Alabama | 1071 | 15019 | 236 |
2385639 | 2385639 | 2022-04-08 | Jackson | Alabama | 1071 | 15019 | 236 |
2382384 | 2382384 | 2022-04-07 | Jackson | Alabama | 1071 | 15019 | 236 |
2379129 | 2379129 | 2022-04-06 | Jackson | Alabama | 1071 | 15022 | 236 |
2375875 | 2375875 | 2022-04-05 | Jackson | Alabama | 1071 | 15022 | 236 |
2372623 | 2372623 | 2022-04-04 | Jackson | Alabama | 1071 | 15022 | 236 |
2369370 | 2369370 | 2022-04-03 | Jackson | Alabama | 1071 | 15022 | 236 |
2366117 | 2366117 | 2022-04-02 | Jackson | Alabama | 1071 | 15022 | 236 |
2362864 | 2362864 | 2022-04-01 | Jackson | Alabama | 1071 | 15022 | 236 |
2359610 | 2359610 | 2022-03-31 | Jackson | Alabama | 1071 | 15021 | 236 |
2356356 | 2356356 | 2022-03-30 | Jackson | Alabama | 1071 | 15020 | 236 |
2353103 | 2353103 | 2022-03-29 | Jackson | Alabama | 1071 | 15020 | 236 |
2349851 | 2349851 | 2022-03-28 | Jackson | Alabama | 1071 | 15019 | 235 |
2346598 | 2346598 | 2022-03-27 | Jackson | Alabama | 1071 | 15015 | 234 |
2343345 | 2343345 | 2022-03-26 | Jackson | Alabama | 1071 | 15015 | 234 |
2340092 | 2340092 | 2022-03-25 | Jackson | Alabama | 1071 | 15015 | 234 |
2336839 | 2336839 | 2022-03-24 | Jackson | Alabama | 1071 | 15013 | 234 |
2333585 | 2333585 | 2022-03-23 | Jackson | Alabama | 1071 | 15012 | 234 |
2330331 | 2330331 | 2022-03-22 | Jackson | Alabama | 1071 | 15009 | 233 |
2327079 | 2327079 | 2022-03-21 | Jackson | Alabama | 1071 | 15006 | 233 |
2323826 | 2323826 | 2022-03-20 | Jackson | Alabama | 1071 | 15003 | 233 |
2320572 | 2320572 | 2022-03-19 | Jackson | Alabama | 1071 | 15003 | 233 |
2317318 | 2317318 | 2022-03-18 | Jackson | Alabama | 1071 | 15003 | 233 |
2314065 | 2314065 | 2022-03-17 | Jackson | Alabama | 1071 | 15001 | 233 |
2310812 | 2310812 | 2022-03-16 | Jackson | Alabama | 1071 | 15002 | 233 |
2307559 | 2307559 | 2022-03-15 | Jackson | Alabama | 1071 | 15001 | 233 |
2304308 | 2304308 | 2022-03-14 | Jackson | Alabama | 1071 | 14998 | 231 |
2301056 | 2301056 | 2022-03-13 | Jackson | Alabama | 1071 | 14995 | 231 |
2297804 | 2297804 | 2022-03-12 | Jackson | Alabama | 1071 | 14995 | 231 |
2294552 | 2294552 | 2022-03-11 | Jackson | Alabama | 1071 | 14995 | 231 |
2291300 | 2291300 | 2022-03-10 | Jackson | Alabama | 1071 | 14988 | 231 |
2288048 | 2288048 | 2022-03-09 | Jackson | Alabama | 1071 | 14978 | 230 |
2284796 | 2284796 | 2022-03-08 | Jackson | Alabama | 1071 | 14974 | 230 |
2281544 | 2281544 | 2022-03-07 | Jackson | Alabama | 1071 | 14967 | 229 |
2278291 | 2278291 | 2022-03-06 | Jackson | Alabama | 1071 | 14938 | 229 |
2275038 | 2275038 | 2022-03-05 | Jackson | Alabama | 1071 | 14938 | 229 |
2271785 | 2271785 | 2022-03-04 | Jackson | Alabama | 1071 | 14938 | 229 |
2268533 | 2268533 | 2022-03-03 | Jackson | Alabama | 1071 | 14931 | 228 |
2265280 | 2265280 | 2022-03-02 | Jackson | Alabama | 1071 | 14925 | 226 |
2262030 | 2262030 | 2022-03-01 | Jackson | Alabama | 1071 | 14906 | 225 |
2258779 | 2258779 | 2022-02-28 | Jackson | Alabama | 1071 | 14897 | 225 |
2255528 | 2255528 | 2022-02-27 | Jackson | Alabama | 1071 | 14896 | 225 |
2252277 | 2252277 | 2022-02-26 | Jackson | Alabama | 1071 | 14895 | 225 |
2249026 | 2249026 | 2022-02-25 | Jackson | Alabama | 1071 | 14882 | 225 |
2245775 | 2245775 | 2022-02-24 | Jackson | Alabama | 1071 | 14876 | 221 |
2242524 | 2242524 | 2022-02-23 | Jackson | Alabama | 1071 | 14872 | 221 |
2239273 | 2239273 | 2022-02-22 | Jackson | Alabama | 1071 | 14861 | 219 |
2236022 | 2236022 | 2022-02-21 | Jackson | Alabama | 1071 | 14849 | 219 |
2232771 | 2232771 | 2022-02-20 | Jackson | Alabama | 1071 | 14847 | 219 |
2229520 | 2229520 | 2022-02-19 | Jackson | Alabama | 1071 | 14827 | 219 |
2226269 | 2226269 | 2022-02-18 | Jackson | Alabama | 1071 | 14814 | 219 |
2223018 | 2223018 | 2022-02-17 | Jackson | Alabama | 1071 | 14800 | 219 |
2219767 | 2219767 | 2022-02-16 | Jackson | Alabama | 1071 | 14783 | 218 |
2216517 | 2216517 | 2022-02-15 | Jackson | Alabama | 1071 | 14770 | 216 |
2213266 | 2213266 | 2022-02-14 | Jackson | Alabama | 1071 | 14755 | 215 |
2210013 | 2210013 | 2022-02-13 | Jackson | Alabama | 1071 | 14751 | 215 |
2206760 | 2206760 | 2022-02-12 | Jackson | Alabama | 1071 | 14737 | 215 |
2203507 | 2203507 | 2022-02-11 | Jackson | Alabama | 1071 | 14716 | 214 |
2200253 | 2200253 | 2022-02-10 | Jackson | Alabama | 1071 | 14686 | 214 |
2196999 | 2196999 | 2022-02-09 | Jackson | Alabama | 1071 | 14640 | 214 |
2193744 | 2193744 | 2022-02-08 | Jackson | Alabama | 1071 | 14579 | 214 |
2190491 | 2190491 | 2022-02-07 | Jackson | Alabama | 1071 | 14505 | 214 |
2187238 | 2187238 | 2022-02-06 | Jackson | Alabama | 1071 | 14433 | 214 |
2183985 | 2183985 | 2022-02-05 | Jackson | Alabama | 1071 | 14433 | 214 |
2180733 | 2180733 | 2022-02-04 | Jackson | Alabama | 1071 | 14383 | 214 |
2177482 | 2177482 | 2022-02-03 | Jackson | Alabama | 1071 | 14184 | 211 |
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);