ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Talladega" and state = "Alabama" 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 |
---|---|---|---|---|---|---|---|
2499635 | 2499635 | 2022-05-13 | Talladega | Alabama | 1121 | 22396 | 377 |
2496377 | 2496377 | 2022-05-12 | Talladega | Alabama | 1121 | 22389 | 377 |
2493119 | 2493119 | 2022-05-11 | Talladega | Alabama | 1121 | 22381 | 376 |
2489861 | 2489861 | 2022-05-10 | Talladega | Alabama | 1121 | 22376 | 376 |
2486604 | 2486604 | 2022-05-09 | Talladega | Alabama | 1121 | 22367 | 376 |
2483346 | 2483346 | 2022-05-08 | Talladega | Alabama | 1121 | 22359 | 376 |
2480088 | 2480088 | 2022-05-07 | Talladega | Alabama | 1121 | 22359 | 376 |
2476830 | 2476830 | 2022-05-06 | Talladega | Alabama | 1121 | 22359 | 376 |
2473572 | 2473572 | 2022-05-05 | Talladega | Alabama | 1121 | 22355 | 376 |
2470315 | 2470315 | 2022-05-04 | Talladega | Alabama | 1121 | 22348 | 376 |
2467059 | 2467059 | 2022-05-03 | Talladega | Alabama | 1121 | 22347 | 376 |
2463804 | 2463804 | 2022-05-02 | Talladega | Alabama | 1121 | 22345 | 376 |
2460548 | 2460548 | 2022-05-01 | Talladega | Alabama | 1121 | 22339 | 376 |
2457292 | 2457292 | 2022-04-30 | Talladega | Alabama | 1121 | 22339 | 376 |
2454036 | 2454036 | 2022-04-29 | Talladega | Alabama | 1121 | 22339 | 376 |
2450780 | 2450780 | 2022-04-28 | Talladega | Alabama | 1121 | 22337 | 376 |
2447524 | 2447524 | 2022-04-27 | Talladega | Alabama | 1121 | 22334 | 376 |
2444268 | 2444268 | 2022-04-26 | Talladega | Alabama | 1121 | 22333 | 376 |
2441012 | 2441012 | 2022-04-25 | Talladega | Alabama | 1121 | 22330 | 376 |
2437756 | 2437756 | 2022-04-24 | Talladega | Alabama | 1121 | 22327 | 376 |
2434500 | 2434500 | 2022-04-23 | Talladega | Alabama | 1121 | 22327 | 376 |
2431244 | 2431244 | 2022-04-22 | Talladega | Alabama | 1121 | 22327 | 376 |
2427988 | 2427988 | 2022-04-21 | Talladega | Alabama | 1121 | 22323 | 376 |
2424732 | 2424732 | 2022-04-20 | Talladega | Alabama | 1121 | 22323 | 376 |
2421476 | 2421476 | 2022-04-19 | Talladega | Alabama | 1121 | 22325 | 376 |
2418220 | 2418220 | 2022-04-18 | Talladega | Alabama | 1121 | 22315 | 376 |
2414964 | 2414964 | 2022-04-17 | Talladega | Alabama | 1121 | 22315 | 376 |
2411708 | 2411708 | 2022-04-16 | Talladega | Alabama | 1121 | 22315 | 376 |
2408452 | 2408452 | 2022-04-15 | Talladega | Alabama | 1121 | 22315 | 376 |
2405196 | 2405196 | 2022-04-14 | Talladega | Alabama | 1121 | 22314 | 376 |
2401941 | 2401941 | 2022-04-13 | Talladega | Alabama | 1121 | 22310 | 376 |
2398686 | 2398686 | 2022-04-12 | Talladega | Alabama | 1121 | 22310 | 375 |
2395431 | 2395431 | 2022-04-11 | Talladega | Alabama | 1121 | 22310 | 375 |
2392175 | 2392175 | 2022-04-10 | Talladega | Alabama | 1121 | 22304 | 375 |
2388919 | 2388919 | 2022-04-09 | Talladega | Alabama | 1121 | 22304 | 375 |
2385664 | 2385664 | 2022-04-08 | Talladega | Alabama | 1121 | 22304 | 375 |
2382409 | 2382409 | 2022-04-07 | Talladega | Alabama | 1121 | 22301 | 375 |
2379154 | 2379154 | 2022-04-06 | Talladega | Alabama | 1121 | 22297 | 375 |
2375900 | 2375900 | 2022-04-05 | Talladega | Alabama | 1121 | 22294 | 375 |
2372648 | 2372648 | 2022-04-04 | Talladega | Alabama | 1121 | 22292 | 373 |
2369395 | 2369395 | 2022-04-03 | Talladega | Alabama | 1121 | 22286 | 372 |
2366142 | 2366142 | 2022-04-02 | Talladega | Alabama | 1121 | 22286 | 372 |
2362889 | 2362889 | 2022-04-01 | Talladega | Alabama | 1121 | 22286 | 372 |
2359635 | 2359635 | 2022-03-31 | Talladega | Alabama | 1121 | 22285 | 372 |
2356381 | 2356381 | 2022-03-30 | Talladega | Alabama | 1121 | 22281 | 372 |
2353128 | 2353128 | 2022-03-29 | Talladega | Alabama | 1121 | 22278 | 372 |
2349876 | 2349876 | 2022-03-28 | Talladega | Alabama | 1121 | 22279 | 371 |
2346623 | 2346623 | 2022-03-27 | Talladega | Alabama | 1121 | 22271 | 371 |
2343370 | 2343370 | 2022-03-26 | Talladega | Alabama | 1121 | 22271 | 371 |
2340117 | 2340117 | 2022-03-25 | Talladega | Alabama | 1121 | 22271 | 371 |
2336864 | 2336864 | 2022-03-24 | Talladega | Alabama | 1121 | 22270 | 371 |
2333610 | 2333610 | 2022-03-23 | Talladega | Alabama | 1121 | 22266 | 371 |
2330356 | 2330356 | 2022-03-22 | Talladega | Alabama | 1121 | 22264 | 371 |
2327104 | 2327104 | 2022-03-21 | Talladega | Alabama | 1121 | 22260 | 369 |
2323851 | 2323851 | 2022-03-20 | Talladega | Alabama | 1121 | 22257 | 369 |
2320597 | 2320597 | 2022-03-19 | Talladega | Alabama | 1121 | 22257 | 369 |
2317343 | 2317343 | 2022-03-18 | Talladega | Alabama | 1121 | 22257 | 369 |
2314090 | 2314090 | 2022-03-17 | Talladega | Alabama | 1121 | 22256 | 367 |
2310837 | 2310837 | 2022-03-16 | Talladega | Alabama | 1121 | 22249 | 365 |
2307584 | 2307584 | 2022-03-15 | Talladega | Alabama | 1121 | 22239 | 365 |
2304333 | 2304333 | 2022-03-14 | Talladega | Alabama | 1121 | 22238 | 364 |
2301081 | 2301081 | 2022-03-13 | Talladega | Alabama | 1121 | 22232 | 363 |
2297829 | 2297829 | 2022-03-12 | Talladega | Alabama | 1121 | 22232 | 363 |
2294577 | 2294577 | 2022-03-11 | Talladega | Alabama | 1121 | 22232 | 363 |
2291325 | 2291325 | 2022-03-10 | Talladega | Alabama | 1121 | 22225 | 362 |
2288073 | 2288073 | 2022-03-09 | Talladega | Alabama | 1121 | 22213 | 358 |
2284821 | 2284821 | 2022-03-08 | Talladega | Alabama | 1121 | 22191 | 357 |
2281569 | 2281569 | 2022-03-07 | Talladega | Alabama | 1121 | 22184 | 355 |
2278316 | 2278316 | 2022-03-06 | Talladega | Alabama | 1121 | 22132 | 353 |
2275063 | 2275063 | 2022-03-05 | Talladega | Alabama | 1121 | 22132 | 353 |
2271810 | 2271810 | 2022-03-04 | Talladega | Alabama | 1121 | 22132 | 353 |
2268558 | 2268558 | 2022-03-03 | Talladega | Alabama | 1121 | 22119 | 351 |
2265305 | 2265305 | 2022-03-02 | Talladega | Alabama | 1121 | 22088 | 350 |
2262055 | 2262055 | 2022-03-01 | Talladega | Alabama | 1121 | 22059 | 350 |
2258804 | 2258804 | 2022-02-28 | Talladega | Alabama | 1121 | 22013 | 350 |
2255553 | 2255553 | 2022-02-27 | Talladega | Alabama | 1121 | 22011 | 350 |
2252302 | 2252302 | 2022-02-26 | Talladega | Alabama | 1121 | 22002 | 350 |
2249051 | 2249051 | 2022-02-25 | Talladega | Alabama | 1121 | 21952 | 350 |
2245800 | 2245800 | 2022-02-24 | Talladega | Alabama | 1121 | 21902 | 346 |
2242549 | 2242549 | 2022-02-23 | Talladega | Alabama | 1121 | 21865 | 343 |
2239298 | 2239298 | 2022-02-22 | Talladega | Alabama | 1121 | 21810 | 341 |
2236047 | 2236047 | 2022-02-21 | Talladega | Alabama | 1121 | 21798 | 341 |
2232796 | 2232796 | 2022-02-20 | Talladega | Alabama | 1121 | 21791 | 341 |
2229545 | 2229545 | 2022-02-19 | Talladega | Alabama | 1121 | 21786 | 341 |
2226294 | 2226294 | 2022-02-18 | Talladega | Alabama | 1121 | 21744 | 338 |
2223043 | 2223043 | 2022-02-17 | Talladega | Alabama | 1121 | 21721 | 335 |
2219792 | 2219792 | 2022-02-16 | Talladega | Alabama | 1121 | 21678 | 334 |
2216542 | 2216542 | 2022-02-15 | Talladega | Alabama | 1121 | 21651 | 331 |
2213291 | 2213291 | 2022-02-14 | Talladega | Alabama | 1121 | 21628 | 331 |
2210038 | 2210038 | 2022-02-13 | Talladega | Alabama | 1121 | 21621 | 331 |
2206785 | 2206785 | 2022-02-12 | Talladega | Alabama | 1121 | 21610 | 331 |
2203532 | 2203532 | 2022-02-11 | Talladega | Alabama | 1121 | 21590 | 330 |
2200278 | 2200278 | 2022-02-10 | Talladega | Alabama | 1121 | 21551 | 330 |
2197024 | 2197024 | 2022-02-09 | Talladega | Alabama | 1121 | 21480 | 330 |
2193769 | 2193769 | 2022-02-08 | Talladega | Alabama | 1121 | 21398 | 330 |
2190516 | 2190516 | 2022-02-07 | Talladega | Alabama | 1121 | 21322 | 330 |
2187263 | 2187263 | 2022-02-06 | Talladega | Alabama | 1121 | 21277 | 330 |
2184010 | 2184010 | 2022-02-05 | Talladega | Alabama | 1121 | 21277 | 330 |
2180758 | 2180758 | 2022-02-04 | Talladega | Alabama | 1121 | 21236 | 330 |
2177507 | 2177507 | 2022-02-03 | Talladega | Alabama | 1121 | 21051 | 325 |
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);