ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Pike" and fips = 1109 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499629 | 2499629 | 2022-05-13 | Pike | Alabama | 1109 | 7590 | 134 |
2496371 | 2496371 | 2022-05-12 | Pike | Alabama | 1109 | 7587 | 134 |
2493113 | 2493113 | 2022-05-11 | Pike | Alabama | 1109 | 7583 | 134 |
2489855 | 2489855 | 2022-05-10 | Pike | Alabama | 1109 | 7582 | 134 |
2486598 | 2486598 | 2022-05-09 | Pike | Alabama | 1109 | 7580 | 134 |
2483340 | 2483340 | 2022-05-08 | Pike | Alabama | 1109 | 7580 | 134 |
2480082 | 2480082 | 2022-05-07 | Pike | Alabama | 1109 | 7580 | 134 |
2476824 | 2476824 | 2022-05-06 | Pike | Alabama | 1109 | 7580 | 134 |
2473566 | 2473566 | 2022-05-05 | Pike | Alabama | 1109 | 7580 | 134 |
2470309 | 2470309 | 2022-05-04 | Pike | Alabama | 1109 | 7580 | 134 |
2467053 | 2467053 | 2022-05-03 | Pike | Alabama | 1109 | 7579 | 134 |
2463798 | 2463798 | 2022-05-02 | Pike | Alabama | 1109 | 7579 | 134 |
2460542 | 2460542 | 2022-05-01 | Pike | Alabama | 1109 | 7576 | 134 |
2457286 | 2457286 | 2022-04-30 | Pike | Alabama | 1109 | 7576 | 134 |
2454030 | 2454030 | 2022-04-29 | Pike | Alabama | 1109 | 7576 | 134 |
2450774 | 2450774 | 2022-04-28 | Pike | Alabama | 1109 | 7566 | 134 |
2447518 | 2447518 | 2022-04-27 | Pike | Alabama | 1109 | 7561 | 134 |
2444262 | 2444262 | 2022-04-26 | Pike | Alabama | 1109 | 7556 | 134 |
2441006 | 2441006 | 2022-04-25 | Pike | Alabama | 1109 | 7550 | 134 |
2437750 | 2437750 | 2022-04-24 | Pike | Alabama | 1109 | 7529 | 134 |
2434494 | 2434494 | 2022-04-23 | Pike | Alabama | 1109 | 7529 | 134 |
2431238 | 2431238 | 2022-04-22 | Pike | Alabama | 1109 | 7529 | 134 |
2427982 | 2427982 | 2022-04-21 | Pike | Alabama | 1109 | 7523 | 134 |
2424726 | 2424726 | 2022-04-20 | Pike | Alabama | 1109 | 7505 | 134 |
2421470 | 2421470 | 2022-04-19 | Pike | Alabama | 1109 | 7495 | 134 |
2418214 | 2418214 | 2022-04-18 | Pike | Alabama | 1109 | 7472 | 134 |
2414958 | 2414958 | 2022-04-17 | Pike | Alabama | 1109 | 7472 | 134 |
2411702 | 2411702 | 2022-04-16 | Pike | Alabama | 1109 | 7472 | 134 |
2408446 | 2408446 | 2022-04-15 | Pike | Alabama | 1109 | 7472 | 134 |
2405190 | 2405190 | 2022-04-14 | Pike | Alabama | 1109 | 7465 | 134 |
2401935 | 2401935 | 2022-04-13 | Pike | Alabama | 1109 | 7465 | 134 |
2398680 | 2398680 | 2022-04-12 | Pike | Alabama | 1109 | 7464 | 133 |
2395425 | 2395425 | 2022-04-11 | Pike | Alabama | 1109 | 7465 | 133 |
2392169 | 2392169 | 2022-04-10 | Pike | Alabama | 1109 | 7466 | 133 |
2388913 | 2388913 | 2022-04-09 | Pike | Alabama | 1109 | 7466 | 133 |
2385658 | 2385658 | 2022-04-08 | Pike | Alabama | 1109 | 7466 | 133 |
2382403 | 2382403 | 2022-04-07 | Pike | Alabama | 1109 | 7466 | 133 |
2379148 | 2379148 | 2022-04-06 | Pike | Alabama | 1109 | 7465 | 133 |
2375894 | 2375894 | 2022-04-05 | Pike | Alabama | 1109 | 7465 | 133 |
2372642 | 2372642 | 2022-04-04 | Pike | Alabama | 1109 | 7464 | 133 |
2369389 | 2369389 | 2022-04-03 | Pike | Alabama | 1109 | 7463 | 133 |
2366136 | 2366136 | 2022-04-02 | Pike | Alabama | 1109 | 7463 | 133 |
2362883 | 2362883 | 2022-04-01 | Pike | Alabama | 1109 | 7463 | 133 |
2359629 | 2359629 | 2022-03-31 | Pike | Alabama | 1109 | 7463 | 133 |
2356375 | 2356375 | 2022-03-30 | Pike | Alabama | 1109 | 7463 | 133 |
2353122 | 2353122 | 2022-03-29 | Pike | Alabama | 1109 | 7460 | 133 |
2349870 | 2349870 | 2022-03-28 | Pike | Alabama | 1109 | 7459 | 133 |
2346617 | 2346617 | 2022-03-27 | Pike | Alabama | 1109 | 7428 | 133 |
2343364 | 2343364 | 2022-03-26 | Pike | Alabama | 1109 | 7428 | 133 |
2340111 | 2340111 | 2022-03-25 | Pike | Alabama | 1109 | 7428 | 133 |
2336858 | 2336858 | 2022-03-24 | Pike | Alabama | 1109 | 7426 | 133 |
2333604 | 2333604 | 2022-03-23 | Pike | Alabama | 1109 | 7425 | 133 |
2330350 | 2330350 | 2022-03-22 | Pike | Alabama | 1109 | 7425 | 133 |
2327098 | 2327098 | 2022-03-21 | Pike | Alabama | 1109 | 7424 | 132 |
2323845 | 2323845 | 2022-03-20 | Pike | Alabama | 1109 | 7422 | 132 |
2320591 | 2320591 | 2022-03-19 | Pike | Alabama | 1109 | 7422 | 132 |
2317337 | 2317337 | 2022-03-18 | Pike | Alabama | 1109 | 7422 | 132 |
2314084 | 2314084 | 2022-03-17 | Pike | Alabama | 1109 | 7421 | 132 |
2310831 | 2310831 | 2022-03-16 | Pike | Alabama | 1109 | 7421 | 131 |
2307578 | 2307578 | 2022-03-15 | Pike | Alabama | 1109 | 7421 | 131 |
2304327 | 2304327 | 2022-03-14 | Pike | Alabama | 1109 | 7421 | 131 |
2301075 | 2301075 | 2022-03-13 | Pike | Alabama | 1109 | 7421 | 130 |
2297823 | 2297823 | 2022-03-12 | Pike | Alabama | 1109 | 7421 | 130 |
2294571 | 2294571 | 2022-03-11 | Pike | Alabama | 1109 | 7421 | 130 |
2291319 | 2291319 | 2022-03-10 | Pike | Alabama | 1109 | 7419 | 128 |
2288067 | 2288067 | 2022-03-09 | Pike | Alabama | 1109 | 7419 | 128 |
2284815 | 2284815 | 2022-03-08 | Pike | Alabama | 1109 | 7417 | 128 |
2281563 | 2281563 | 2022-03-07 | Pike | Alabama | 1109 | 7415 | 128 |
2278310 | 2278310 | 2022-03-06 | Pike | Alabama | 1109 | 7417 | 127 |
2275057 | 2275057 | 2022-03-05 | Pike | Alabama | 1109 | 7417 | 127 |
2271804 | 2271804 | 2022-03-04 | Pike | Alabama | 1109 | 7417 | 127 |
2268552 | 2268552 | 2022-03-03 | Pike | Alabama | 1109 | 7421 | 127 |
2265299 | 2265299 | 2022-03-02 | Pike | Alabama | 1109 | 7420 | 127 |
2262049 | 2262049 | 2022-03-01 | Pike | Alabama | 1109 | 7418 | 127 |
2258798 | 2258798 | 2022-02-28 | Pike | Alabama | 1109 | 7414 | 126 |
2255547 | 2255547 | 2022-02-27 | Pike | Alabama | 1109 | 7414 | 126 |
2252296 | 2252296 | 2022-02-26 | Pike | Alabama | 1109 | 7411 | 126 |
2249045 | 2249045 | 2022-02-25 | Pike | Alabama | 1109 | 7406 | 123 |
2245794 | 2245794 | 2022-02-24 | Pike | Alabama | 1109 | 7401 | 122 |
2242543 | 2242543 | 2022-02-23 | Pike | Alabama | 1109 | 7399 | 122 |
2239292 | 2239292 | 2022-02-22 | Pike | Alabama | 1109 | 7391 | 122 |
2236041 | 2236041 | 2022-02-21 | Pike | Alabama | 1109 | 7388 | 122 |
2232790 | 2232790 | 2022-02-20 | Pike | Alabama | 1109 | 7386 | 122 |
2229539 | 2229539 | 2022-02-19 | Pike | Alabama | 1109 | 7381 | 122 |
2226288 | 2226288 | 2022-02-18 | Pike | Alabama | 1109 | 7377 | 121 |
2223037 | 2223037 | 2022-02-17 | Pike | Alabama | 1109 | 7374 | 121 |
2219786 | 2219786 | 2022-02-16 | Pike | Alabama | 1109 | 7365 | 121 |
2216536 | 2216536 | 2022-02-15 | Pike | Alabama | 1109 | 7354 | 121 |
2213285 | 2213285 | 2022-02-14 | Pike | Alabama | 1109 | 7341 | 119 |
2210032 | 2210032 | 2022-02-13 | Pike | Alabama | 1109 | 7338 | 119 |
2206779 | 2206779 | 2022-02-12 | Pike | Alabama | 1109 | 7333 | 119 |
2203526 | 2203526 | 2022-02-11 | Pike | Alabama | 1109 | 7320 | 119 |
2200272 | 2200272 | 2022-02-10 | Pike | Alabama | 1109 | 7295 | 119 |
2197018 | 2197018 | 2022-02-09 | Pike | Alabama | 1109 | 7242 | 119 |
2193763 | 2193763 | 2022-02-08 | Pike | Alabama | 1109 | 7228 | 119 |
2190510 | 2190510 | 2022-02-07 | Pike | Alabama | 1109 | 7204 | 119 |
2187257 | 2187257 | 2022-02-06 | Pike | Alabama | 1109 | 7176 | 119 |
2184004 | 2184004 | 2022-02-05 | Pike | Alabama | 1109 | 7176 | 119 |
2180752 | 2180752 | 2022-02-04 | Pike | Alabama | 1109 | 7164 | 119 |
2177501 | 2177501 | 2022-02-03 | Pike | Alabama | 1109 | 7099 | 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);