ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Colleton" 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 |
---|---|---|---|---|---|---|---|
2502013 | 2502013 | 2022-05-13 | Colleton | South Carolina | 45029 | 8913 | 221 |
2498755 | 2498755 | 2022-05-12 | Colleton | South Carolina | 45029 | 8913 | 221 |
2495497 | 2495497 | 2022-05-11 | Colleton | South Carolina | 45029 | 8913 | 221 |
2492239 | 2492239 | 2022-05-10 | Colleton | South Carolina | 45029 | 8877 | 220 |
2488981 | 2488981 | 2022-05-09 | Colleton | South Carolina | 45029 | 8877 | 220 |
2485724 | 2485724 | 2022-05-08 | Colleton | South Carolina | 45029 | 8877 | 220 |
2482466 | 2482466 | 2022-05-07 | Colleton | South Carolina | 45029 | 8877 | 220 |
2479208 | 2479208 | 2022-05-06 | Colleton | South Carolina | 45029 | 8877 | 220 |
2475950 | 2475950 | 2022-05-05 | Colleton | South Carolina | 45029 | 8877 | 220 |
2472693 | 2472693 | 2022-05-04 | Colleton | South Carolina | 45029 | 8877 | 220 |
2469437 | 2469437 | 2022-05-03 | Colleton | South Carolina | 45029 | 8877 | 220 |
2466181 | 2466181 | 2022-05-02 | Colleton | South Carolina | 45029 | 8864 | 220 |
2462926 | 2462926 | 2022-05-01 | Colleton | South Carolina | 45029 | 8864 | 220 |
2459670 | 2459670 | 2022-04-30 | Colleton | South Carolina | 45029 | 8864 | 220 |
2456414 | 2456414 | 2022-04-29 | Colleton | South Carolina | 45029 | 8864 | 220 |
2453158 | 2453158 | 2022-04-28 | Colleton | South Carolina | 45029 | 8864 | 220 |
2449902 | 2449902 | 2022-04-27 | Colleton | South Carolina | 45029 | 8861 | 220 |
2446645 | 2446645 | 2022-04-26 | Colleton | South Carolina | 45029 | 8861 | 220 |
2443390 | 2443390 | 2022-04-25 | Colleton | South Carolina | 45029 | 8861 | 220 |
2440134 | 2440134 | 2022-04-24 | Colleton | South Carolina | 45029 | 8861 | 220 |
2436878 | 2436878 | 2022-04-23 | Colleton | South Carolina | 45029 | 8861 | 220 |
2433622 | 2433622 | 2022-04-22 | Colleton | South Carolina | 45029 | 8861 | 220 |
2430366 | 2430366 | 2022-04-21 | Colleton | South Carolina | 45029 | 8861 | 220 |
2427110 | 2427110 | 2022-04-20 | Colleton | South Carolina | 45029 | 8861 | 220 |
2423854 | 2423854 | 2022-04-19 | Colleton | South Carolina | 45029 | 8861 | 220 |
2420598 | 2420598 | 2022-04-18 | Colleton | South Carolina | 45029 | 8849 | 220 |
2417342 | 2417342 | 2022-04-17 | Colleton | South Carolina | 45029 | 8849 | 220 |
2414086 | 2414086 | 2022-04-16 | Colleton | South Carolina | 45029 | 8849 | 220 |
2410830 | 2410830 | 2022-04-15 | Colleton | South Carolina | 45029 | 8849 | 220 |
2407574 | 2407574 | 2022-04-14 | Colleton | South Carolina | 45029 | 8849 | 220 |
2404318 | 2404318 | 2022-04-13 | Colleton | South Carolina | 45029 | 8849 | 220 |
2401063 | 2401063 | 2022-04-12 | Colleton | South Carolina | 45029 | 8849 | 220 |
2397808 | 2397808 | 2022-04-11 | Colleton | South Carolina | 45029 | 8842 | 219 |
2394553 | 2394553 | 2022-04-10 | Colleton | South Carolina | 45029 | 8842 | 219 |
2391297 | 2391297 | 2022-04-09 | Colleton | South Carolina | 45029 | 8842 | 219 |
2388041 | 2388041 | 2022-04-08 | Colleton | South Carolina | 45029 | 8842 | 219 |
2384786 | 2384786 | 2022-04-07 | Colleton | South Carolina | 45029 | 8842 | 219 |
2381531 | 2381531 | 2022-04-06 | Colleton | South Carolina | 45029 | 8842 | 219 |
2378276 | 2378276 | 2022-04-05 | Colleton | South Carolina | 45029 | 8842 | 219 |
2375022 | 2375022 | 2022-04-04 | Colleton | South Carolina | 45029 | 8841 | 219 |
2371770 | 2371770 | 2022-04-03 | Colleton | South Carolina | 45029 | 8841 | 219 |
2368517 | 2368517 | 2022-04-02 | Colleton | South Carolina | 45029 | 8841 | 219 |
2365264 | 2365264 | 2022-04-01 | Colleton | South Carolina | 45029 | 8841 | 219 |
2362011 | 2362011 | 2022-03-31 | Colleton | South Carolina | 45029 | 8841 | 219 |
2358757 | 2358757 | 2022-03-30 | Colleton | South Carolina | 45029 | 8841 | 219 |
2355503 | 2355503 | 2022-03-29 | Colleton | South Carolina | 45029 | 8841 | 219 |
2352250 | 2352250 | 2022-03-28 | Colleton | South Carolina | 45029 | 8823 | 219 |
2348998 | 2348998 | 2022-03-27 | Colleton | South Carolina | 45029 | 8823 | 219 |
2345745 | 2345745 | 2022-03-26 | Colleton | South Carolina | 45029 | 8823 | 219 |
2342492 | 2342492 | 2022-03-25 | Colleton | South Carolina | 45029 | 8823 | 219 |
2339239 | 2339239 | 2022-03-24 | Colleton | South Carolina | 45029 | 8823 | 219 |
2335985 | 2335985 | 2022-03-23 | Colleton | South Carolina | 45029 | 8823 | 219 |
2332731 | 2332731 | 2022-03-22 | Colleton | South Carolina | 45029 | 8823 | 219 |
2329478 | 2329478 | 2022-03-21 | Colleton | South Carolina | 45029 | 8813 | 217 |
2326226 | 2326226 | 2022-03-20 | Colleton | South Carolina | 45029 | 8813 | 217 |
2322973 | 2322973 | 2022-03-19 | Colleton | South Carolina | 45029 | 8813 | 217 |
2319719 | 2319719 | 2022-03-18 | Colleton | South Carolina | 45029 | 8813 | 217 |
2316465 | 2316465 | 2022-03-17 | Colleton | South Carolina | 45029 | 8813 | 217 |
2313212 | 2313212 | 2022-03-16 | Colleton | South Carolina | 45029 | 8813 | 217 |
2309959 | 2309959 | 2022-03-15 | Colleton | South Carolina | 45029 | 8813 | 217 |
2306706 | 2306706 | 2022-03-14 | Colleton | South Carolina | 45029 | 8818 | 217 |
2303455 | 2303455 | 2022-03-13 | Colleton | South Carolina | 45029 | 8818 | 217 |
2300203 | 2300203 | 2022-03-12 | Colleton | South Carolina | 45029 | 8818 | 217 |
2296951 | 2296951 | 2022-03-11 | Colleton | South Carolina | 45029 | 8818 | 217 |
2293699 | 2293699 | 2022-03-10 | Colleton | South Carolina | 45029 | 8816 | 217 |
2290447 | 2290447 | 2022-03-09 | Colleton | South Carolina | 45029 | 8820 | 216 |
2287195 | 2287195 | 2022-03-08 | Colleton | South Carolina | 45029 | 8819 | 215 |
2283943 | 2283943 | 2022-03-07 | Colleton | South Carolina | 45029 | 8820 | 215 |
2280691 | 2280691 | 2022-03-06 | Colleton | South Carolina | 45029 | 8821 | 215 |
2277438 | 2277438 | 2022-03-05 | Colleton | South Carolina | 45029 | 8821 | 215 |
2274185 | 2274185 | 2022-03-04 | Colleton | South Carolina | 45029 | 8821 | 215 |
2270932 | 2270932 | 2022-03-03 | Colleton | South Carolina | 45029 | 8822 | 215 |
2267680 | 2267680 | 2022-03-02 | Colleton | South Carolina | 45029 | 8822 | 215 |
2264427 | 2264427 | 2022-03-01 | Colleton | South Carolina | 45029 | 8821 | 215 |
2261177 | 2261177 | 2022-02-28 | Colleton | South Carolina | 45029 | 8819 | 215 |
2257926 | 2257926 | 2022-02-27 | Colleton | South Carolina | 45029 | 8804 | 215 |
2254675 | 2254675 | 2022-02-26 | Colleton | South Carolina | 45029 | 8804 | 215 |
2251424 | 2251424 | 2022-02-25 | Colleton | South Carolina | 45029 | 8804 | 215 |
2248173 | 2248173 | 2022-02-24 | Colleton | South Carolina | 45029 | 8794 | 214 |
2244922 | 2244922 | 2022-02-23 | Colleton | South Carolina | 45029 | 8785 | 214 |
2241671 | 2241671 | 2022-02-22 | Colleton | South Carolina | 45029 | 8769 | 214 |
2238420 | 2238420 | 2022-02-21 | Colleton | South Carolina | 45029 | 8701 | 214 |
2235169 | 2235169 | 2022-02-20 | Colleton | South Carolina | 45029 | 8701 | 214 |
2231918 | 2231918 | 2022-02-19 | Colleton | South Carolina | 45029 | 8701 | 214 |
2228667 | 2228667 | 2022-02-18 | Colleton | South Carolina | 45029 | 8701 | 214 |
2225416 | 2225416 | 2022-02-17 | Colleton | South Carolina | 45029 | 8696 | 210 |
2222165 | 2222165 | 2022-02-16 | Colleton | South Carolina | 45029 | 8688 | 210 |
2218914 | 2218914 | 2022-02-15 | Colleton | South Carolina | 45029 | 8683 | 209 |
2215663 | 2215663 | 2022-02-14 | Colleton | South Carolina | 45029 | 8668 | 209 |
2212412 | 2212412 | 2022-02-13 | Colleton | South Carolina | 45029 | 8586 | 207 |
2209159 | 2209159 | 2022-02-12 | Colleton | South Carolina | 45029 | 8586 | 207 |
2205906 | 2205906 | 2022-02-11 | Colleton | South Carolina | 45029 | 8586 | 207 |
2202653 | 2202653 | 2022-02-10 | Colleton | South Carolina | 45029 | 8586 | 207 |
2199399 | 2199399 | 2022-02-09 | Colleton | South Carolina | 45029 | 8571 | 207 |
2196145 | 2196145 | 2022-02-08 | Colleton | South Carolina | 45029 | 8519 | 207 |
2192891 | 2192891 | 2022-02-07 | Colleton | South Carolina | 45029 | 8508 | 207 |
2189637 | 2189637 | 2022-02-06 | Colleton | South Carolina | 45029 | 8449 | 206 |
2186384 | 2186384 | 2022-02-05 | Colleton | South Carolina | 45029 | 8449 | 206 |
2183132 | 2183132 | 2022-02-04 | Colleton | South Carolina | 45029 | 8449 | 206 |
2179880 | 2179880 | 2022-02-03 | Colleton | South Carolina | 45029 | 8336 | 204 |
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);