ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45003 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 224 ✖
- 437 46
- 225 29
- 224 27
- 7 22
- 6 18
- 9 18
- 356 17
- 226 15
- 1 13
- 215 12
- 0 11
- 85 11
- 87 10
- 210 10
- 218 10
- 229 10
- 8 9
- 98 9
- 227 8
- 433 8
- 10 7
- 86 7
- 217 7
- 222 7
- 347 7
- 364 7
- 436 7
- 13 6
- 77 6
- 82 6
- 91 6
- 336 6
- 368 6
- 4 5
- 133 5
- 216 5
- 354 5
- 369 5
- 378 5
- 416 5
- 434 5
- 3 4
- 11 4
- 23 4
- 68 4
- 84 4
- 90 4
- 111 4
- 193 4
- 211 4
- 219 4
- 232 4
- 256 4
- 289 4
- 321 4
- 355 4
- 360 4
- 373 4
- 407 4
- 428 4
- 15 3
- 24 3
- 46 3
- 56 3
- 57 3
- 63 3
- 76 3
- 95 3
- 105 3
- 115 3
- 146 3
- 165 3
- 167 3
- 207 3
- 214 3
- 220 3
- 221 3
- 223 3
- 236 3
- 242 3
- 271 3
- 286 3
- 294 3
- 313 3
- 317 3
- 319 3
- 324 3
- 343 3
- 349 3
- 383 3
- 396 3
- 422 3
- 20 2
- 26 2
- 33 2
- 38 2
- 42 2
- 67 2
- 78 2
- 81 2
- 89 2
- 96 2
- 101 2
- 121 2
- 124 2
- 150 2
- 153 2
- 159 2
- 169 2
- 175 2
- 176 2
- 182 2
- 183 2
- 197 2
- 199 2
- 201 2
- 202 2
- 213 2
- 233 2
- 239 2
- 269 2
- 285 2
- 327 2
- 345 2
- 348 2
- 352 2
- 361 2
- 371 2
- 372 2
- 375 2
- 388 2
- 404 2
- 408 2
- 418 2
- 426 2
- 2 1
- 5 1
- 14 1
- 18 1
- 22 1
- 29 1
- 31 1
- 34 1
- 37 1
- 39 1
- 44 1
- 49 1
- 50 1
- 51 1
- 53 1
- 62 1
- 64 1
- 65 1
- 69 1
- 71 1
- 74 1
- 79 1
- 80 1
- 92 1
- 93 1
- 99 1
- 100 1
- 108 1
- 109 1
- 110 1
- 116 1
- 119 1
- 123 1
- 131 1
- 132 1
- 136 1
- 138 1
- 139 1
- 140 1
- 141 1
- 143 1
- 144 1
- 145 1
- 148 1
- 149 1
- 154 1
- 162 1
- 163 1
- 178 1
- 188 1
- 189 1
- 191 1
- 192 1
- 196 1
- 204 1
- 228 1
- 235 1
- 240 1
- 241 1
- 247 1
- 250 1
- 253 1
- 267 1
- 268 1
- 277 1
- 281 1
- 297 1
- 298 1
- 306 1
- 308 1
- 318 1
- 331 1
- 332 1
- 339 1
- 357 1
- 358 1
- 359 1
- 367 1
- 374 1
- 379 1
- 380 1
- 391 1
- 394 1
- 405 1
- 412 1
- 419 1
- 423 1
- 430 1
- 432 1
state 1
- South Carolina 785
fips 1
- 45003 · 785 ✖
county 1
- Aiken 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502000 | 2502000 | 2022-05-13 | Aiken | South Carolina | 45003 | 41767 | 437 |
2498742 | 2498742 | 2022-05-12 | Aiken | South Carolina | 45003 | 41767 | 437 |
2495484 | 2495484 | 2022-05-11 | Aiken | South Carolina | 45003 | 41767 | 437 |
2492226 | 2492226 | 2022-05-10 | Aiken | South Carolina | 45003 | 41661 | 437 |
2488968 | 2488968 | 2022-05-09 | Aiken | South Carolina | 45003 | 41661 | 437 |
2485711 | 2485711 | 2022-05-08 | Aiken | South Carolina | 45003 | 41661 | 437 |
2482453 | 2482453 | 2022-05-07 | Aiken | South Carolina | 45003 | 41661 | 437 |
2479195 | 2479195 | 2022-05-06 | Aiken | South Carolina | 45003 | 41661 | 437 |
2475937 | 2475937 | 2022-05-05 | Aiken | South Carolina | 45003 | 41661 | 437 |
2472680 | 2472680 | 2022-05-04 | Aiken | South Carolina | 45003 | 41661 | 437 |
2469424 | 2469424 | 2022-05-03 | Aiken | South Carolina | 45003 | 41661 | 437 |
2466168 | 2466168 | 2022-05-02 | Aiken | South Carolina | 45003 | 41569 | 437 |
2462913 | 2462913 | 2022-05-01 | Aiken | South Carolina | 45003 | 41569 | 437 |
2459657 | 2459657 | 2022-04-30 | Aiken | South Carolina | 45003 | 41569 | 437 |
2456401 | 2456401 | 2022-04-29 | Aiken | South Carolina | 45003 | 41569 | 437 |
2453145 | 2453145 | 2022-04-28 | Aiken | South Carolina | 45003 | 41569 | 437 |
2449889 | 2449889 | 2022-04-27 | Aiken | South Carolina | 45003 | 41482 | 437 |
2446632 | 2446632 | 2022-04-26 | Aiken | South Carolina | 45003 | 41482 | 437 |
2443377 | 2443377 | 2022-04-25 | Aiken | South Carolina | 45003 | 41482 | 437 |
2440121 | 2440121 | 2022-04-24 | Aiken | South Carolina | 45003 | 41482 | 437 |
2436865 | 2436865 | 2022-04-23 | Aiken | South Carolina | 45003 | 41482 | 437 |
2433609 | 2433609 | 2022-04-22 | Aiken | South Carolina | 45003 | 41482 | 437 |
2430353 | 2430353 | 2022-04-21 | Aiken | South Carolina | 45003 | 41482 | 437 |
2427097 | 2427097 | 2022-04-20 | Aiken | South Carolina | 45003 | 41482 | 437 |
2423841 | 2423841 | 2022-04-19 | Aiken | South Carolina | 45003 | 41482 | 437 |
2420585 | 2420585 | 2022-04-18 | Aiken | South Carolina | 45003 | 41465 | 437 |
2417329 | 2417329 | 2022-04-17 | Aiken | South Carolina | 45003 | 41465 | 437 |
2414073 | 2414073 | 2022-04-16 | Aiken | South Carolina | 45003 | 41465 | 437 |
2410817 | 2410817 | 2022-04-15 | Aiken | South Carolina | 45003 | 41465 | 437 |
2407561 | 2407561 | 2022-04-14 | Aiken | South Carolina | 45003 | 41465 | 437 |
2404305 | 2404305 | 2022-04-13 | Aiken | South Carolina | 45003 | 41465 | 437 |
2401050 | 2401050 | 2022-04-12 | Aiken | South Carolina | 45003 | 41465 | 437 |
2397795 | 2397795 | 2022-04-11 | Aiken | South Carolina | 45003 | 41457 | 437 |
2394540 | 2394540 | 2022-04-10 | Aiken | South Carolina | 45003 | 41457 | 437 |
2391284 | 2391284 | 2022-04-09 | Aiken | South Carolina | 45003 | 41457 | 437 |
2388028 | 2388028 | 2022-04-08 | Aiken | South Carolina | 45003 | 41457 | 437 |
2384773 | 2384773 | 2022-04-07 | Aiken | South Carolina | 45003 | 41457 | 437 |
2381518 | 2381518 | 2022-04-06 | Aiken | South Carolina | 45003 | 41457 | 437 |
2378263 | 2378263 | 2022-04-05 | Aiken | South Carolina | 45003 | 41457 | 437 |
2375009 | 2375009 | 2022-04-04 | Aiken | South Carolina | 45003 | 41421 | 437 |
2371757 | 2371757 | 2022-04-03 | Aiken | South Carolina | 45003 | 41421 | 437 |
2368504 | 2368504 | 2022-04-02 | Aiken | South Carolina | 45003 | 41421 | 437 |
2365251 | 2365251 | 2022-04-01 | Aiken | South Carolina | 45003 | 41421 | 437 |
2361998 | 2361998 | 2022-03-31 | Aiken | South Carolina | 45003 | 41421 | 437 |
2358744 | 2358744 | 2022-03-30 | Aiken | South Carolina | 45003 | 41421 | 437 |
2355490 | 2355490 | 2022-03-29 | Aiken | South Carolina | 45003 | 41421 | 437 |
2352237 | 2352237 | 2022-03-28 | Aiken | South Carolina | 45003 | 41385 | 436 |
2348985 | 2348985 | 2022-03-27 | Aiken | South Carolina | 45003 | 41385 | 436 |
2345732 | 2345732 | 2022-03-26 | Aiken | South Carolina | 45003 | 41385 | 436 |
2342479 | 2342479 | 2022-03-25 | Aiken | South Carolina | 45003 | 41385 | 436 |
2339226 | 2339226 | 2022-03-24 | Aiken | South Carolina | 45003 | 41385 | 436 |
2335972 | 2335972 | 2022-03-23 | Aiken | South Carolina | 45003 | 41385 | 436 |
2332718 | 2332718 | 2022-03-22 | Aiken | South Carolina | 45003 | 41385 | 436 |
2329465 | 2329465 | 2022-03-21 | Aiken | South Carolina | 45003 | 41323 | 433 |
2326213 | 2326213 | 2022-03-20 | Aiken | South Carolina | 45003 | 41323 | 433 |
2322960 | 2322960 | 2022-03-19 | Aiken | South Carolina | 45003 | 41323 | 433 |
2319706 | 2319706 | 2022-03-18 | Aiken | South Carolina | 45003 | 41323 | 433 |
2316452 | 2316452 | 2022-03-17 | Aiken | South Carolina | 45003 | 41323 | 433 |
2313199 | 2313199 | 2022-03-16 | Aiken | South Carolina | 45003 | 41323 | 433 |
2309946 | 2309946 | 2022-03-15 | Aiken | South Carolina | 45003 | 41323 | 433 |
2306693 | 2306693 | 2022-03-14 | Aiken | South Carolina | 45003 | 41264 | 434 |
2303442 | 2303442 | 2022-03-13 | Aiken | South Carolina | 45003 | 41264 | 434 |
2300190 | 2300190 | 2022-03-12 | Aiken | South Carolina | 45003 | 41264 | 434 |
2296938 | 2296938 | 2022-03-11 | Aiken | South Carolina | 45003 | 41264 | 434 |
2293686 | 2293686 | 2022-03-10 | Aiken | South Carolina | 45003 | 41220 | 434 |
2290434 | 2290434 | 2022-03-09 | Aiken | South Carolina | 45003 | 41180 | 433 |
2287182 | 2287182 | 2022-03-08 | Aiken | South Carolina | 45003 | 41153 | 432 |
2283930 | 2283930 | 2022-03-07 | Aiken | South Carolina | 45003 | 41151 | 430 |
2280678 | 2280678 | 2022-03-06 | Aiken | South Carolina | 45003 | 41079 | 428 |
2277425 | 2277425 | 2022-03-05 | Aiken | South Carolina | 45003 | 41079 | 428 |
2274172 | 2274172 | 2022-03-04 | Aiken | South Carolina | 45003 | 41079 | 428 |
2270919 | 2270919 | 2022-03-03 | Aiken | South Carolina | 45003 | 41054 | 428 |
2267667 | 2267667 | 2022-03-02 | Aiken | South Carolina | 45003 | 41024 | 426 |
2264414 | 2264414 | 2022-03-01 | Aiken | South Carolina | 45003 | 41004 | 426 |
2261164 | 2261164 | 2022-02-28 | Aiken | South Carolina | 45003 | 40998 | 423 |
2257913 | 2257913 | 2022-02-27 | Aiken | South Carolina | 45003 | 40835 | 422 |
2254662 | 2254662 | 2022-02-26 | Aiken | South Carolina | 45003 | 40835 | 422 |
2251411 | 2251411 | 2022-02-25 | Aiken | South Carolina | 45003 | 40835 | 422 |
2248160 | 2248160 | 2022-02-24 | Aiken | South Carolina | 45003 | 40777 | 419 |
2244909 | 2244909 | 2022-02-23 | Aiken | South Carolina | 45003 | 40676 | 418 |
2241658 | 2241658 | 2022-02-22 | Aiken | South Carolina | 45003 | 40603 | 418 |
2238407 | 2238407 | 2022-02-21 | Aiken | South Carolina | 45003 | 40450 | 416 |
2235156 | 2235156 | 2022-02-20 | Aiken | South Carolina | 45003 | 40450 | 416 |
2231905 | 2231905 | 2022-02-19 | Aiken | South Carolina | 45003 | 40450 | 416 |
2228654 | 2228654 | 2022-02-18 | Aiken | South Carolina | 45003 | 40450 | 416 |
2225403 | 2225403 | 2022-02-17 | Aiken | South Carolina | 45003 | 40399 | 416 |
2222152 | 2222152 | 2022-02-16 | Aiken | South Carolina | 45003 | 40324 | 412 |
2218901 | 2218901 | 2022-02-15 | Aiken | South Carolina | 45003 | 40286 | 408 |
2215650 | 2215650 | 2022-02-14 | Aiken | South Carolina | 45003 | 40220 | 408 |
2212399 | 2212399 | 2022-02-13 | Aiken | South Carolina | 45003 | 39925 | 407 |
2209146 | 2209146 | 2022-02-12 | Aiken | South Carolina | 45003 | 39925 | 407 |
2205893 | 2205893 | 2022-02-11 | Aiken | South Carolina | 45003 | 39925 | 407 |
2202640 | 2202640 | 2022-02-10 | Aiken | South Carolina | 45003 | 39925 | 407 |
2199386 | 2199386 | 2022-02-09 | Aiken | South Carolina | 45003 | 39852 | 405 |
2196132 | 2196132 | 2022-02-08 | Aiken | South Carolina | 45003 | 39740 | 404 |
2192878 | 2192878 | 2022-02-07 | Aiken | South Carolina | 45003 | 39667 | 404 |
2189624 | 2189624 | 2022-02-06 | Aiken | South Carolina | 45003 | 39243 | 396 |
2186371 | 2186371 | 2022-02-05 | Aiken | South Carolina | 45003 | 39243 | 396 |
2183119 | 2183119 | 2022-02-04 | Aiken | South Carolina | 45003 | 39243 | 396 |
2179867 | 2179867 | 2022-02-03 | Aiken | South Carolina | 45003 | 39057 | 394 |
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);