ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Orangeburg" and state = "South Carolina" 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 |
---|---|---|---|---|---|---|---|
2502036 | 2502036 | 2022-05-13 | Orangeburg | South Carolina | 45075 | 23425 | 420 |
2498778 | 2498778 | 2022-05-12 | Orangeburg | South Carolina | 45075 | 23425 | 420 |
2495520 | 2495520 | 2022-05-11 | Orangeburg | South Carolina | 45075 | 23425 | 420 |
2492262 | 2492262 | 2022-05-10 | Orangeburg | South Carolina | 45075 | 23358 | 420 |
2489004 | 2489004 | 2022-05-09 | Orangeburg | South Carolina | 45075 | 23358 | 420 |
2485747 | 2485747 | 2022-05-08 | Orangeburg | South Carolina | 45075 | 23358 | 420 |
2482489 | 2482489 | 2022-05-07 | Orangeburg | South Carolina | 45075 | 23358 | 420 |
2479231 | 2479231 | 2022-05-06 | Orangeburg | South Carolina | 45075 | 23358 | 420 |
2475973 | 2475973 | 2022-05-05 | Orangeburg | South Carolina | 45075 | 23358 | 420 |
2472716 | 2472716 | 2022-05-04 | Orangeburg | South Carolina | 45075 | 23358 | 420 |
2469460 | 2469460 | 2022-05-03 | Orangeburg | South Carolina | 45075 | 23358 | 420 |
2466204 | 2466204 | 2022-05-02 | Orangeburg | South Carolina | 45075 | 23327 | 417 |
2462949 | 2462949 | 2022-05-01 | Orangeburg | South Carolina | 45075 | 23327 | 417 |
2459693 | 2459693 | 2022-04-30 | Orangeburg | South Carolina | 45075 | 23327 | 417 |
2456437 | 2456437 | 2022-04-29 | Orangeburg | South Carolina | 45075 | 23327 | 417 |
2453181 | 2453181 | 2022-04-28 | Orangeburg | South Carolina | 45075 | 23327 | 417 |
2449925 | 2449925 | 2022-04-27 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2446668 | 2446668 | 2022-04-26 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2443413 | 2443413 | 2022-04-25 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2440157 | 2440157 | 2022-04-24 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2436901 | 2436901 | 2022-04-23 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2433645 | 2433645 | 2022-04-22 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2430389 | 2430389 | 2022-04-21 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2427133 | 2427133 | 2022-04-20 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2423877 | 2423877 | 2022-04-19 | Orangeburg | South Carolina | 45075 | 23306 | 417 |
2420621 | 2420621 | 2022-04-18 | Orangeburg | South Carolina | 45075 | 23293 | 415 |
2417365 | 2417365 | 2022-04-17 | Orangeburg | South Carolina | 45075 | 23293 | 415 |
2414109 | 2414109 | 2022-04-16 | Orangeburg | South Carolina | 45075 | 23293 | 415 |
2410853 | 2410853 | 2022-04-15 | Orangeburg | South Carolina | 45075 | 23293 | 415 |
2407597 | 2407597 | 2022-04-14 | Orangeburg | South Carolina | 45075 | 23293 | 415 |
2404341 | 2404341 | 2022-04-13 | Orangeburg | South Carolina | 45075 | 23293 | 415 |
2401086 | 2401086 | 2022-04-12 | Orangeburg | South Carolina | 45075 | 23293 | 415 |
2397831 | 2397831 | 2022-04-11 | Orangeburg | South Carolina | 45075 | 23280 | 415 |
2394576 | 2394576 | 2022-04-10 | Orangeburg | South Carolina | 45075 | 23280 | 415 |
2391320 | 2391320 | 2022-04-09 | Orangeburg | South Carolina | 45075 | 23280 | 415 |
2388064 | 2388064 | 2022-04-08 | Orangeburg | South Carolina | 45075 | 23280 | 415 |
2384809 | 2384809 | 2022-04-07 | Orangeburg | South Carolina | 45075 | 23280 | 415 |
2381554 | 2381554 | 2022-04-06 | Orangeburg | South Carolina | 45075 | 23280 | 415 |
2378299 | 2378299 | 2022-04-05 | Orangeburg | South Carolina | 45075 | 23280 | 415 |
2375045 | 2375045 | 2022-04-04 | Orangeburg | South Carolina | 45075 | 23275 | 415 |
2371793 | 2371793 | 2022-04-03 | Orangeburg | South Carolina | 45075 | 23275 | 415 |
2368540 | 2368540 | 2022-04-02 | Orangeburg | South Carolina | 45075 | 23275 | 415 |
2365287 | 2365287 | 2022-04-01 | Orangeburg | South Carolina | 45075 | 23275 | 415 |
2362034 | 2362034 | 2022-03-31 | Orangeburg | South Carolina | 45075 | 23275 | 415 |
2358780 | 2358780 | 2022-03-30 | Orangeburg | South Carolina | 45075 | 23275 | 415 |
2355526 | 2355526 | 2022-03-29 | Orangeburg | South Carolina | 45075 | 23275 | 415 |
2352273 | 2352273 | 2022-03-28 | Orangeburg | South Carolina | 45075 | 23267 | 415 |
2349021 | 2349021 | 2022-03-27 | Orangeburg | South Carolina | 45075 | 23267 | 415 |
2345768 | 2345768 | 2022-03-26 | Orangeburg | South Carolina | 45075 | 23267 | 415 |
2342515 | 2342515 | 2022-03-25 | Orangeburg | South Carolina | 45075 | 23267 | 415 |
2339262 | 2339262 | 2022-03-24 | Orangeburg | South Carolina | 45075 | 23267 | 415 |
2336008 | 2336008 | 2022-03-23 | Orangeburg | South Carolina | 45075 | 23267 | 415 |
2332754 | 2332754 | 2022-03-22 | Orangeburg | South Carolina | 45075 | 23267 | 415 |
2329501 | 2329501 | 2022-03-21 | Orangeburg | South Carolina | 45075 | 23248 | 413 |
2326249 | 2326249 | 2022-03-20 | Orangeburg | South Carolina | 45075 | 23248 | 413 |
2322996 | 2322996 | 2022-03-19 | Orangeburg | South Carolina | 45075 | 23248 | 413 |
2319742 | 2319742 | 2022-03-18 | Orangeburg | South Carolina | 45075 | 23248 | 413 |
2316488 | 2316488 | 2022-03-17 | Orangeburg | South Carolina | 45075 | 23248 | 413 |
2313235 | 2313235 | 2022-03-16 | Orangeburg | South Carolina | 45075 | 23248 | 413 |
2309982 | 2309982 | 2022-03-15 | Orangeburg | South Carolina | 45075 | 23248 | 413 |
2306729 | 2306729 | 2022-03-14 | Orangeburg | South Carolina | 45075 | 23244 | 412 |
2303478 | 2303478 | 2022-03-13 | Orangeburg | South Carolina | 45075 | 23244 | 412 |
2300226 | 2300226 | 2022-03-12 | Orangeburg | South Carolina | 45075 | 23244 | 412 |
2296974 | 2296974 | 2022-03-11 | Orangeburg | South Carolina | 45075 | 23244 | 412 |
2293722 | 2293722 | 2022-03-10 | Orangeburg | South Carolina | 45075 | 23242 | 410 |
2290470 | 2290470 | 2022-03-09 | Orangeburg | South Carolina | 45075 | 23238 | 406 |
2287218 | 2287218 | 2022-03-08 | Orangeburg | South Carolina | 45075 | 23235 | 405 |
2283966 | 2283966 | 2022-03-07 | Orangeburg | South Carolina | 45075 | 23234 | 404 |
2280714 | 2280714 | 2022-03-06 | Orangeburg | South Carolina | 45075 | 23223 | 398 |
2277461 | 2277461 | 2022-03-05 | Orangeburg | South Carolina | 45075 | 23223 | 398 |
2274208 | 2274208 | 2022-03-04 | Orangeburg | South Carolina | 45075 | 23223 | 398 |
2270955 | 2270955 | 2022-03-03 | Orangeburg | South Carolina | 45075 | 23215 | 398 |
2267703 | 2267703 | 2022-03-02 | Orangeburg | South Carolina | 45075 | 23212 | 398 |
2264450 | 2264450 | 2022-03-01 | Orangeburg | South Carolina | 45075 | 23212 | 397 |
2261200 | 2261200 | 2022-02-28 | Orangeburg | South Carolina | 45075 | 23209 | 396 |
2257949 | 2257949 | 2022-02-27 | Orangeburg | South Carolina | 45075 | 23176 | 394 |
2254698 | 2254698 | 2022-02-26 | Orangeburg | South Carolina | 45075 | 23176 | 394 |
2251447 | 2251447 | 2022-02-25 | Orangeburg | South Carolina | 45075 | 23176 | 394 |
2248196 | 2248196 | 2022-02-24 | Orangeburg | South Carolina | 45075 | 23168 | 392 |
2244945 | 2244945 | 2022-02-23 | Orangeburg | South Carolina | 45075 | 23154 | 391 |
2241694 | 2241694 | 2022-02-22 | Orangeburg | South Carolina | 45075 | 23133 | 391 |
2238443 | 2238443 | 2022-02-21 | Orangeburg | South Carolina | 45075 | 23064 | 386 |
2235192 | 2235192 | 2022-02-20 | Orangeburg | South Carolina | 45075 | 23064 | 386 |
2231941 | 2231941 | 2022-02-19 | Orangeburg | South Carolina | 45075 | 23064 | 386 |
2228690 | 2228690 | 2022-02-18 | Orangeburg | South Carolina | 45075 | 23064 | 386 |
2225439 | 2225439 | 2022-02-17 | Orangeburg | South Carolina | 45075 | 23042 | 385 |
2222188 | 2222188 | 2022-02-16 | Orangeburg | South Carolina | 45075 | 23006 | 383 |
2218937 | 2218937 | 2022-02-15 | Orangeburg | South Carolina | 45075 | 22989 | 379 |
2215686 | 2215686 | 2022-02-14 | Orangeburg | South Carolina | 45075 | 22973 | 379 |
2212435 | 2212435 | 2022-02-13 | Orangeburg | South Carolina | 45075 | 22777 | 378 |
2209182 | 2209182 | 2022-02-12 | Orangeburg | South Carolina | 45075 | 22777 | 378 |
2205929 | 2205929 | 2022-02-11 | Orangeburg | South Carolina | 45075 | 22777 | 378 |
2202676 | 2202676 | 2022-02-10 | Orangeburg | South Carolina | 45075 | 22777 | 378 |
2199422 | 2199422 | 2022-02-09 | Orangeburg | South Carolina | 45075 | 22738 | 378 |
2196168 | 2196168 | 2022-02-08 | Orangeburg | South Carolina | 45075 | 22693 | 376 |
2192914 | 2192914 | 2022-02-07 | Orangeburg | South Carolina | 45075 | 22664 | 376 |
2189660 | 2189660 | 2022-02-06 | Orangeburg | South Carolina | 45075 | 22429 | 373 |
2186407 | 2186407 | 2022-02-05 | Orangeburg | South Carolina | 45075 | 22429 | 373 |
2183155 | 2183155 | 2022-02-04 | Orangeburg | South Carolina | 45075 | 22429 | 373 |
2179903 | 2179903 | 2022-02-03 | Orangeburg | South Carolina | 45075 | 22345 | 369 |
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);