ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Sumter" and fips = 45085 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 |
---|---|---|---|---|---|---|---|
2502041 | 2502041 | 2022-05-13 | Sumter | South Carolina | 45085 | 28100 | 394 |
2498783 | 2498783 | 2022-05-12 | Sumter | South Carolina | 45085 | 28100 | 394 |
2495525 | 2495525 | 2022-05-11 | Sumter | South Carolina | 45085 | 28100 | 394 |
2492267 | 2492267 | 2022-05-10 | Sumter | South Carolina | 45085 | 27967 | 393 |
2489009 | 2489009 | 2022-05-09 | Sumter | South Carolina | 45085 | 27967 | 393 |
2485752 | 2485752 | 2022-05-08 | Sumter | South Carolina | 45085 | 27967 | 393 |
2482494 | 2482494 | 2022-05-07 | Sumter | South Carolina | 45085 | 27967 | 393 |
2479236 | 2479236 | 2022-05-06 | Sumter | South Carolina | 45085 | 27967 | 393 |
2475978 | 2475978 | 2022-05-05 | Sumter | South Carolina | 45085 | 27967 | 393 |
2472721 | 2472721 | 2022-05-04 | Sumter | South Carolina | 45085 | 27967 | 393 |
2469465 | 2469465 | 2022-05-03 | Sumter | South Carolina | 45085 | 27967 | 393 |
2466209 | 2466209 | 2022-05-02 | Sumter | South Carolina | 45085 | 27882 | 391 |
2462954 | 2462954 | 2022-05-01 | Sumter | South Carolina | 45085 | 27882 | 391 |
2459698 | 2459698 | 2022-04-30 | Sumter | South Carolina | 45085 | 27882 | 391 |
2456442 | 2456442 | 2022-04-29 | Sumter | South Carolina | 45085 | 27882 | 391 |
2453186 | 2453186 | 2022-04-28 | Sumter | South Carolina | 45085 | 27882 | 391 |
2449930 | 2449930 | 2022-04-27 | Sumter | South Carolina | 45085 | 27844 | 390 |
2446673 | 2446673 | 2022-04-26 | Sumter | South Carolina | 45085 | 27844 | 390 |
2443418 | 2443418 | 2022-04-25 | Sumter | South Carolina | 45085 | 27844 | 390 |
2440162 | 2440162 | 2022-04-24 | Sumter | South Carolina | 45085 | 27844 | 390 |
2436906 | 2436906 | 2022-04-23 | Sumter | South Carolina | 45085 | 27844 | 390 |
2433650 | 2433650 | 2022-04-22 | Sumter | South Carolina | 45085 | 27844 | 390 |
2430394 | 2430394 | 2022-04-21 | Sumter | South Carolina | 45085 | 27844 | 390 |
2427138 | 2427138 | 2022-04-20 | Sumter | South Carolina | 45085 | 27844 | 390 |
2423882 | 2423882 | 2022-04-19 | Sumter | South Carolina | 45085 | 27844 | 390 |
2420626 | 2420626 | 2022-04-18 | Sumter | South Carolina | 45085 | 27811 | 390 |
2417370 | 2417370 | 2022-04-17 | Sumter | South Carolina | 45085 | 27811 | 390 |
2414114 | 2414114 | 2022-04-16 | Sumter | South Carolina | 45085 | 27811 | 390 |
2410858 | 2410858 | 2022-04-15 | Sumter | South Carolina | 45085 | 27811 | 390 |
2407602 | 2407602 | 2022-04-14 | Sumter | South Carolina | 45085 | 27811 | 390 |
2404346 | 2404346 | 2022-04-13 | Sumter | South Carolina | 45085 | 27811 | 390 |
2401091 | 2401091 | 2022-04-12 | Sumter | South Carolina | 45085 | 27811 | 390 |
2397836 | 2397836 | 2022-04-11 | Sumter | South Carolina | 45085 | 27801 | 390 |
2394581 | 2394581 | 2022-04-10 | Sumter | South Carolina | 45085 | 27801 | 390 |
2391325 | 2391325 | 2022-04-09 | Sumter | South Carolina | 45085 | 27801 | 390 |
2388069 | 2388069 | 2022-04-08 | Sumter | South Carolina | 45085 | 27801 | 390 |
2384814 | 2384814 | 2022-04-07 | Sumter | South Carolina | 45085 | 27801 | 390 |
2381559 | 2381559 | 2022-04-06 | Sumter | South Carolina | 45085 | 27801 | 390 |
2378304 | 2378304 | 2022-04-05 | Sumter | South Carolina | 45085 | 27801 | 390 |
2375050 | 2375050 | 2022-04-04 | Sumter | South Carolina | 45085 | 27779 | 389 |
2371798 | 2371798 | 2022-04-03 | Sumter | South Carolina | 45085 | 27779 | 389 |
2368545 | 2368545 | 2022-04-02 | Sumter | South Carolina | 45085 | 27779 | 389 |
2365292 | 2365292 | 2022-04-01 | Sumter | South Carolina | 45085 | 27779 | 389 |
2362039 | 2362039 | 2022-03-31 | Sumter | South Carolina | 45085 | 27779 | 389 |
2358785 | 2358785 | 2022-03-30 | Sumter | South Carolina | 45085 | 27779 | 389 |
2355531 | 2355531 | 2022-03-29 | Sumter | South Carolina | 45085 | 27779 | 389 |
2352278 | 2352278 | 2022-03-28 | Sumter | South Carolina | 45085 | 27761 | 386 |
2349026 | 2349026 | 2022-03-27 | Sumter | South Carolina | 45085 | 27761 | 386 |
2345773 | 2345773 | 2022-03-26 | Sumter | South Carolina | 45085 | 27761 | 386 |
2342520 | 2342520 | 2022-03-25 | Sumter | South Carolina | 45085 | 27761 | 386 |
2339267 | 2339267 | 2022-03-24 | Sumter | South Carolina | 45085 | 27761 | 386 |
2336013 | 2336013 | 2022-03-23 | Sumter | South Carolina | 45085 | 27761 | 386 |
2332759 | 2332759 | 2022-03-22 | Sumter | South Carolina | 45085 | 27761 | 386 |
2329506 | 2329506 | 2022-03-21 | Sumter | South Carolina | 45085 | 27740 | 383 |
2326254 | 2326254 | 2022-03-20 | Sumter | South Carolina | 45085 | 27740 | 383 |
2323001 | 2323001 | 2022-03-19 | Sumter | South Carolina | 45085 | 27740 | 383 |
2319747 | 2319747 | 2022-03-18 | Sumter | South Carolina | 45085 | 27740 | 383 |
2316493 | 2316493 | 2022-03-17 | Sumter | South Carolina | 45085 | 27740 | 383 |
2313240 | 2313240 | 2022-03-16 | Sumter | South Carolina | 45085 | 27740 | 383 |
2309987 | 2309987 | 2022-03-15 | Sumter | South Carolina | 45085 | 27740 | 383 |
2306734 | 2306734 | 2022-03-14 | Sumter | South Carolina | 45085 | 27729 | 383 |
2303483 | 2303483 | 2022-03-13 | Sumter | South Carolina | 45085 | 27729 | 383 |
2300231 | 2300231 | 2022-03-12 | Sumter | South Carolina | 45085 | 27729 | 383 |
2296979 | 2296979 | 2022-03-11 | Sumter | South Carolina | 45085 | 27729 | 383 |
2293727 | 2293727 | 2022-03-10 | Sumter | South Carolina | 45085 | 27718 | 382 |
2290475 | 2290475 | 2022-03-09 | Sumter | South Carolina | 45085 | 27709 | 382 |
2287223 | 2287223 | 2022-03-08 | Sumter | South Carolina | 45085 | 27705 | 379 |
2283971 | 2283971 | 2022-03-07 | Sumter | South Carolina | 45085 | 27704 | 376 |
2280719 | 2280719 | 2022-03-06 | Sumter | South Carolina | 45085 | 27683 | 370 |
2277466 | 2277466 | 2022-03-05 | Sumter | South Carolina | 45085 | 27683 | 370 |
2274213 | 2274213 | 2022-03-04 | Sumter | South Carolina | 45085 | 27683 | 370 |
2270960 | 2270960 | 2022-03-03 | Sumter | South Carolina | 45085 | 27677 | 370 |
2267708 | 2267708 | 2022-03-02 | Sumter | South Carolina | 45085 | 27650 | 369 |
2264455 | 2264455 | 2022-03-01 | Sumter | South Carolina | 45085 | 27585 | 368 |
2261205 | 2261205 | 2022-02-28 | Sumter | South Carolina | 45085 | 27581 | 366 |
2257954 | 2257954 | 2022-02-27 | Sumter | South Carolina | 45085 | 27488 | 365 |
2254703 | 2254703 | 2022-02-26 | Sumter | South Carolina | 45085 | 27488 | 365 |
2251452 | 2251452 | 2022-02-25 | Sumter | South Carolina | 45085 | 27488 | 365 |
2248201 | 2248201 | 2022-02-24 | Sumter | South Carolina | 45085 | 27461 | 359 |
2244950 | 2244950 | 2022-02-23 | Sumter | South Carolina | 45085 | 27417 | 359 |
2241699 | 2241699 | 2022-02-22 | Sumter | South Carolina | 45085 | 27408 | 359 |
2238448 | 2238448 | 2022-02-21 | Sumter | South Carolina | 45085 | 27323 | 358 |
2235197 | 2235197 | 2022-02-20 | Sumter | South Carolina | 45085 | 27323 | 358 |
2231946 | 2231946 | 2022-02-19 | Sumter | South Carolina | 45085 | 27323 | 358 |
2228695 | 2228695 | 2022-02-18 | Sumter | South Carolina | 45085 | 27323 | 358 |
2225444 | 2225444 | 2022-02-17 | Sumter | South Carolina | 45085 | 27265 | 358 |
2222193 | 2222193 | 2022-02-16 | Sumter | South Carolina | 45085 | 27222 | 357 |
2218942 | 2218942 | 2022-02-15 | Sumter | South Carolina | 45085 | 27182 | 356 |
2215691 | 2215691 | 2022-02-14 | Sumter | South Carolina | 45085 | 27135 | 356 |
2212440 | 2212440 | 2022-02-13 | Sumter | South Carolina | 45085 | 26903 | 356 |
2209187 | 2209187 | 2022-02-12 | Sumter | South Carolina | 45085 | 26903 | 356 |
2205934 | 2205934 | 2022-02-11 | Sumter | South Carolina | 45085 | 26903 | 356 |
2202681 | 2202681 | 2022-02-10 | Sumter | South Carolina | 45085 | 26903 | 356 |
2199427 | 2199427 | 2022-02-09 | Sumter | South Carolina | 45085 | 26837 | 353 |
2196173 | 2196173 | 2022-02-08 | Sumter | South Carolina | 45085 | 26773 | 353 |
2192919 | 2192919 | 2022-02-07 | Sumter | South Carolina | 45085 | 26707 | 353 |
2189665 | 2189665 | 2022-02-06 | Sumter | South Carolina | 45085 | 26287 | 344 |
2186412 | 2186412 | 2022-02-05 | Sumter | South Carolina | 45085 | 26287 | 344 |
2183160 | 2183160 | 2022-02-04 | Sumter | South Carolina | 45085 | 26287 | 344 |
2179908 | 2179908 | 2022-02-03 | Sumter | South Carolina | 45085 | 26192 | 344 |
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);