ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 45009 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502003 | 2502003 | 2022-05-13 | Bamberg | South Carolina | 45009 | 3446 | 75 |
2498745 | 2498745 | 2022-05-12 | Bamberg | South Carolina | 45009 | 3446 | 75 |
2495487 | 2495487 | 2022-05-11 | Bamberg | South Carolina | 45009 | 3446 | 75 |
2492229 | 2492229 | 2022-05-10 | Bamberg | South Carolina | 45009 | 3435 | 75 |
2488971 | 2488971 | 2022-05-09 | Bamberg | South Carolina | 45009 | 3435 | 75 |
2485714 | 2485714 | 2022-05-08 | Bamberg | South Carolina | 45009 | 3435 | 75 |
2482456 | 2482456 | 2022-05-07 | Bamberg | South Carolina | 45009 | 3435 | 75 |
2479198 | 2479198 | 2022-05-06 | Bamberg | South Carolina | 45009 | 3435 | 75 |
2475940 | 2475940 | 2022-05-05 | Bamberg | South Carolina | 45009 | 3435 | 75 |
2472683 | 2472683 | 2022-05-04 | Bamberg | South Carolina | 45009 | 3435 | 75 |
2469427 | 2469427 | 2022-05-03 | Bamberg | South Carolina | 45009 | 3435 | 75 |
2466171 | 2466171 | 2022-05-02 | Bamberg | South Carolina | 45009 | 3427 | 75 |
2462916 | 2462916 | 2022-05-01 | Bamberg | South Carolina | 45009 | 3427 | 75 |
2459660 | 2459660 | 2022-04-30 | Bamberg | South Carolina | 45009 | 3427 | 75 |
2456404 | 2456404 | 2022-04-29 | Bamberg | South Carolina | 45009 | 3427 | 75 |
2453148 | 2453148 | 2022-04-28 | Bamberg | South Carolina | 45009 | 3427 | 75 |
2449892 | 2449892 | 2022-04-27 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2446635 | 2446635 | 2022-04-26 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2443380 | 2443380 | 2022-04-25 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2440124 | 2440124 | 2022-04-24 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2436868 | 2436868 | 2022-04-23 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2433612 | 2433612 | 2022-04-22 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2430356 | 2430356 | 2022-04-21 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2427100 | 2427100 | 2022-04-20 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2423844 | 2423844 | 2022-04-19 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2420588 | 2420588 | 2022-04-18 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2417332 | 2417332 | 2022-04-17 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2414076 | 2414076 | 2022-04-16 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2410820 | 2410820 | 2022-04-15 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2407564 | 2407564 | 2022-04-14 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2404308 | 2404308 | 2022-04-13 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2401053 | 2401053 | 2022-04-12 | Bamberg | South Carolina | 45009 | 3425 | 75 |
2397798 | 2397798 | 2022-04-11 | Bamberg | South Carolina | 45009 | 3424 | 75 |
2394543 | 2394543 | 2022-04-10 | Bamberg | South Carolina | 45009 | 3424 | 75 |
2391287 | 2391287 | 2022-04-09 | Bamberg | South Carolina | 45009 | 3424 | 75 |
2388031 | 2388031 | 2022-04-08 | Bamberg | South Carolina | 45009 | 3424 | 75 |
2384776 | 2384776 | 2022-04-07 | Bamberg | South Carolina | 45009 | 3424 | 75 |
2381521 | 2381521 | 2022-04-06 | Bamberg | South Carolina | 45009 | 3424 | 75 |
2378266 | 2378266 | 2022-04-05 | Bamberg | South Carolina | 45009 | 3424 | 75 |
2375012 | 2375012 | 2022-04-04 | Bamberg | South Carolina | 45009 | 3423 | 75 |
2371760 | 2371760 | 2022-04-03 | Bamberg | South Carolina | 45009 | 3423 | 75 |
2368507 | 2368507 | 2022-04-02 | Bamberg | South Carolina | 45009 | 3423 | 75 |
2365254 | 2365254 | 2022-04-01 | Bamberg | South Carolina | 45009 | 3423 | 75 |
2362001 | 2362001 | 2022-03-31 | Bamberg | South Carolina | 45009 | 3423 | 75 |
2358747 | 2358747 | 2022-03-30 | Bamberg | South Carolina | 45009 | 3423 | 75 |
2355493 | 2355493 | 2022-03-29 | Bamberg | South Carolina | 45009 | 3423 | 75 |
2352240 | 2352240 | 2022-03-28 | Bamberg | South Carolina | 45009 | 3421 | 75 |
2348988 | 2348988 | 2022-03-27 | Bamberg | South Carolina | 45009 | 3421 | 75 |
2345735 | 2345735 | 2022-03-26 | Bamberg | South Carolina | 45009 | 3421 | 75 |
2342482 | 2342482 | 2022-03-25 | Bamberg | South Carolina | 45009 | 3421 | 75 |
2339229 | 2339229 | 2022-03-24 | Bamberg | South Carolina | 45009 | 3421 | 75 |
2335975 | 2335975 | 2022-03-23 | Bamberg | South Carolina | 45009 | 3421 | 75 |
2332721 | 2332721 | 2022-03-22 | Bamberg | South Carolina | 45009 | 3421 | 75 |
2329468 | 2329468 | 2022-03-21 | Bamberg | South Carolina | 45009 | 3422 | 74 |
2326216 | 2326216 | 2022-03-20 | Bamberg | South Carolina | 45009 | 3422 | 74 |
2322963 | 2322963 | 2022-03-19 | Bamberg | South Carolina | 45009 | 3422 | 74 |
2319709 | 2319709 | 2022-03-18 | Bamberg | South Carolina | 45009 | 3422 | 74 |
2316455 | 2316455 | 2022-03-17 | Bamberg | South Carolina | 45009 | 3422 | 74 |
2313202 | 2313202 | 2022-03-16 | Bamberg | South Carolina | 45009 | 3422 | 74 |
2309949 | 2309949 | 2022-03-15 | Bamberg | South Carolina | 45009 | 3422 | 74 |
2306696 | 2306696 | 2022-03-14 | Bamberg | South Carolina | 45009 | 3408 | 74 |
2303445 | 2303445 | 2022-03-13 | Bamberg | South Carolina | 45009 | 3408 | 74 |
2300193 | 2300193 | 2022-03-12 | Bamberg | South Carolina | 45009 | 3408 | 74 |
2296941 | 2296941 | 2022-03-11 | Bamberg | South Carolina | 45009 | 3408 | 74 |
2293689 | 2293689 | 2022-03-10 | Bamberg | South Carolina | 45009 | 3406 | 74 |
2290437 | 2290437 | 2022-03-09 | Bamberg | South Carolina | 45009 | 3406 | 74 |
2287185 | 2287185 | 2022-03-08 | Bamberg | South Carolina | 45009 | 3406 | 74 |
2283933 | 2283933 | 2022-03-07 | Bamberg | South Carolina | 45009 | 3407 | 73 |
2280681 | 2280681 | 2022-03-06 | Bamberg | South Carolina | 45009 | 3394 | 73 |
2277428 | 2277428 | 2022-03-05 | Bamberg | South Carolina | 45009 | 3394 | 73 |
2274175 | 2274175 | 2022-03-04 | Bamberg | South Carolina | 45009 | 3394 | 73 |
2270922 | 2270922 | 2022-03-03 | Bamberg | South Carolina | 45009 | 3393 | 73 |
2267670 | 2267670 | 2022-03-02 | Bamberg | South Carolina | 45009 | 3393 | 73 |
2264417 | 2264417 | 2022-03-01 | Bamberg | South Carolina | 45009 | 3393 | 73 |
2261167 | 2261167 | 2022-02-28 | Bamberg | South Carolina | 45009 | 3393 | 72 |
2257916 | 2257916 | 2022-02-27 | Bamberg | South Carolina | 45009 | 3388 | 72 |
2254665 | 2254665 | 2022-02-26 | Bamberg | South Carolina | 45009 | 3388 | 72 |
2251414 | 2251414 | 2022-02-25 | Bamberg | South Carolina | 45009 | 3388 | 72 |
2248163 | 2248163 | 2022-02-24 | Bamberg | South Carolina | 45009 | 3387 | 71 |
2244912 | 2244912 | 2022-02-23 | Bamberg | South Carolina | 45009 | 3387 | 71 |
2241661 | 2241661 | 2022-02-22 | Bamberg | South Carolina | 45009 | 3386 | 71 |
2238410 | 2238410 | 2022-02-21 | Bamberg | South Carolina | 45009 | 3378 | 71 |
2235159 | 2235159 | 2022-02-20 | Bamberg | South Carolina | 45009 | 3378 | 71 |
2231908 | 2231908 | 2022-02-19 | Bamberg | South Carolina | 45009 | 3378 | 71 |
2228657 | 2228657 | 2022-02-18 | Bamberg | South Carolina | 45009 | 3378 | 71 |
2225406 | 2225406 | 2022-02-17 | Bamberg | South Carolina | 45009 | 3374 | 71 |
2222155 | 2222155 | 2022-02-16 | Bamberg | South Carolina | 45009 | 3371 | 71 |
2218904 | 2218904 | 2022-02-15 | Bamberg | South Carolina | 45009 | 3369 | 70 |
2215653 | 2215653 | 2022-02-14 | Bamberg | South Carolina | 45009 | 3366 | 70 |
2212402 | 2212402 | 2022-02-13 | Bamberg | South Carolina | 45009 | 3346 | 70 |
2209149 | 2209149 | 2022-02-12 | Bamberg | South Carolina | 45009 | 3346 | 70 |
2205896 | 2205896 | 2022-02-11 | Bamberg | South Carolina | 45009 | 3346 | 70 |
2202643 | 2202643 | 2022-02-10 | Bamberg | South Carolina | 45009 | 3346 | 70 |
2199389 | 2199389 | 2022-02-09 | Bamberg | South Carolina | 45009 | 3339 | 70 |
2196135 | 2196135 | 2022-02-08 | Bamberg | South Carolina | 45009 | 3337 | 70 |
2192881 | 2192881 | 2022-02-07 | Bamberg | South Carolina | 45009 | 3336 | 70 |
2189627 | 2189627 | 2022-02-06 | Bamberg | South Carolina | 45009 | 3304 | 68 |
2186374 | 2186374 | 2022-02-05 | Bamberg | South Carolina | 45009 | 3304 | 68 |
2183122 | 2183122 | 2022-02-04 | Bamberg | South Carolina | 45009 | 3304 | 68 |
2179870 | 2179870 | 2022-02-03 | Bamberg | South Carolina | 45009 | 3289 | 67 |
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);