ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Charleston" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 335 ✖
- 1 23
- 511 23
- 517 21
- 0 14
- 939 14
- 489 13
- 11 11
- 269 10
- 944 8
- 7 7
- 10 7
- 12 7
- 14 7
- 293 7
- 753 7
- 914 7
- 923 7
- 926 7
- 931 7
- 938 7
- 484 6
- 508 6
- 509 6
- 510 6
- 720 6
- 3 5
- 320 5
- 475 5
- 501 5
- 504 5
- 516 5
- 518 5
- 735 5
- 780 5
- 871 5
- 2 4
- 6 4
- 19 4
- 260 4
- 271 4
- 288 4
- 301 4
- 335 4
- 466 4
- 477 4
- 519 4
- 550 4
- 745 4
- 749 4
- 755 4
- 761 4
- 772 4
- 849 4
- 893 4
- 913 4
- 5 3
- 9 3
- 15 3
- 22 3
- 217 3
- 226 3
- 249 3
- 255 3
- 275 3
- 279 3
- 283 3
- 285 3
- 302 3
- 319 3
- 321 3
- 361 3
- 416 3
- 432 3
- 452 3
- 460 3
- 494 3
- 507 3
- 520 3
- 528 3
- 536 3
- 576 3
- 594 3
- 619 3
- 635 3
- 651 3
- 674 3
- 684 3
- 697 3
- 713 3
- 726 3
- 730 3
- 741 3
- 747 3
- 748 3
- 796 3
- 831 3
- 879 3
- 881 3
- 945 3
- 13 2
- 16 2
- 17 2
- 23 2
- 34 2
- 36 2
- 120 2
- 135 2
- 194 2
- 214 2
- 242 2
- 246 2
- 252 2
- 253 2
- 256 2
- 261 2
- 263 2
- 267 2
- 277 2
- 278 2
- 284 2
- 286 2
- 292 2
- 294 2
- 305 2
- 311 2
- 323 2
- 352 2
- 358 2
- 420 2
- 438 2
- 465 2
- 478 2
- 480 2
- 493 2
- 500 2
- 505 2
- 533 2
- 540 2
- 640 2
- 676 2
- 688 2
- 703 2
- 724 2
- 727 2
- 728 2
- 732 2
- 736 2
- 752 2
- 754 2
- 756 2
- 766 2
- 774 2
- 810 2
- 835 2
- 860 2
- 905 2
- 8 1
- 20 1
- 21 1
- 26 1
- 33 1
- 35 1
- 41 1
- 47 1
- 51 1
- 52 1
- 59 1
- 60 1
- 61 1
- 67 1
- 69 1
- 80 1
- 81 1
- 86 1
- 87 1
- 88 1
- 103 1
- 117 1
- 132 1
- 144 1
- 154 1
- 158 1
- 162 1
- 165 1
- 168 1
- 171 1
- 178 1
- 182 1
- 189 1
- 190 1
- 196 1
- 203 1
- 206 1
- 209 1
- 210 1
- 213 1
- 221 1
- 228 1
- 230 1
- 231 1
- 232 1
- 235 1
- 236 1
- 238 1
- 239 1
- 244 1
- 247 1
- 254 1
- 257 1
- 258 1
- 259 1
- 264 1
- 266 1
- 268 1
- 270 1
- 273 1
- 274 1
- 287 1
- 289 1
- 290 1
- 291 1
- 297 1
- 298 1
- 299 1
- 300 1
- 304 1
- 308 1
- 309 1
- 313 1
- 314 1
- 316 1
- 325 1
- 327 1
- 329 1
- 330 1
- 338 1
- 339 1
- 344 1
- 347 1
- 353 1
- 356 1
- 360 1
- 364 1
- 378 1
- 379 1
- 383 1
- 384 1
- 396 1
- 397 1
- 398 1
- 405 1
- 410 1
- 414 1
- 418 1
- 421 1
- 426 1
- 427 1
- 428 1
- 433 1
- 437 1
- 441 1
- 447 1
- 449 1
- 450 1
- 454 1
- 455 1
- 456 1
- 457 1
- 461 1
- 469 1
- 470 1
- 487 1
- 490 1
- 491 1
- 496 1
- 498 1
- 502 1
- 503 1
- 513 1
- 514 1
- 515 1
- 524 1
- 525 1
- 526 1
- 527 1
- 532 1
- 535 1
- 542 1
- 559 1
- 560 1
- 566 1
- 572 1
- 580 1
- 581 1
- 585 1
- 591 1
- 602 1
- 603 1
- 610 1
- 615 1
- 621 1
- 625 1
- 628 1
- 629 1
- 645 1
- 648 1
- 662 1
- 664 1
- 667 1
- 672 1
- 679 1
- 682 1
- 692 1
- 694 1
- 708 1
- 712 1
- 716 1
- 717 1
- 721 1
- 739 1
- 740 1
- 767 1
- 771 1
- 779 1
- 785 1
- 786 1
- 826 1
- 828 1
- 837 1
- 868 1
- 885 1
- 886 1
- 890 1
- 904 1
- 911 1
state 1
- South Carolina 799
fips 1
- 45019 799
county 1
- Charleston · 799 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502008 | 2502008 | 2022-05-13 | Charleston | South Carolina | 45019 | 112905 | 945 |
2498750 | 2498750 | 2022-05-12 | Charleston | South Carolina | 45019 | 112905 | 945 |
2495492 | 2495492 | 2022-05-11 | Charleston | South Carolina | 45019 | 112905 | 945 |
2492234 | 2492234 | 2022-05-10 | Charleston | South Carolina | 45019 | 112523 | 944 |
2488976 | 2488976 | 2022-05-09 | Charleston | South Carolina | 45019 | 112523 | 944 |
2485719 | 2485719 | 2022-05-08 | Charleston | South Carolina | 45019 | 112523 | 944 |
2482461 | 2482461 | 2022-05-07 | Charleston | South Carolina | 45019 | 112523 | 944 |
2479203 | 2479203 | 2022-05-06 | Charleston | South Carolina | 45019 | 112523 | 944 |
2475945 | 2475945 | 2022-05-05 | Charleston | South Carolina | 45019 | 112523 | 944 |
2472688 | 2472688 | 2022-05-04 | Charleston | South Carolina | 45019 | 112523 | 944 |
2469432 | 2469432 | 2022-05-03 | Charleston | South Carolina | 45019 | 112523 | 944 |
2466176 | 2466176 | 2022-05-02 | Charleston | South Carolina | 45019 | 112277 | 939 |
2462921 | 2462921 | 2022-05-01 | Charleston | South Carolina | 45019 | 112277 | 939 |
2459665 | 2459665 | 2022-04-30 | Charleston | South Carolina | 45019 | 112277 | 939 |
2456409 | 2456409 | 2022-04-29 | Charleston | South Carolina | 45019 | 112277 | 939 |
2453153 | 2453153 | 2022-04-28 | Charleston | South Carolina | 45019 | 112277 | 939 |
2449897 | 2449897 | 2022-04-27 | Charleston | South Carolina | 45019 | 112033 | 939 |
2446640 | 2446640 | 2022-04-26 | Charleston | South Carolina | 45019 | 112033 | 939 |
2443385 | 2443385 | 2022-04-25 | Charleston | South Carolina | 45019 | 112033 | 939 |
2440129 | 2440129 | 2022-04-24 | Charleston | South Carolina | 45019 | 112033 | 939 |
2436873 | 2436873 | 2022-04-23 | Charleston | South Carolina | 45019 | 112033 | 939 |
2433617 | 2433617 | 2022-04-22 | Charleston | South Carolina | 45019 | 112033 | 939 |
2430361 | 2430361 | 2022-04-21 | Charleston | South Carolina | 45019 | 112033 | 939 |
2427105 | 2427105 | 2022-04-20 | Charleston | South Carolina | 45019 | 112033 | 939 |
2423849 | 2423849 | 2022-04-19 | Charleston | South Carolina | 45019 | 112033 | 939 |
2420593 | 2420593 | 2022-04-18 | Charleston | South Carolina | 45019 | 111853 | 938 |
2417337 | 2417337 | 2022-04-17 | Charleston | South Carolina | 45019 | 111853 | 938 |
2414081 | 2414081 | 2022-04-16 | Charleston | South Carolina | 45019 | 111853 | 938 |
2410825 | 2410825 | 2022-04-15 | Charleston | South Carolina | 45019 | 111853 | 938 |
2407569 | 2407569 | 2022-04-14 | Charleston | South Carolina | 45019 | 111853 | 938 |
2404313 | 2404313 | 2022-04-13 | Charleston | South Carolina | 45019 | 111853 | 938 |
2401058 | 2401058 | 2022-04-12 | Charleston | South Carolina | 45019 | 111853 | 938 |
2397803 | 2397803 | 2022-04-11 | Charleston | South Carolina | 45019 | 111709 | 931 |
2394548 | 2394548 | 2022-04-10 | Charleston | South Carolina | 45019 | 111709 | 931 |
2391292 | 2391292 | 2022-04-09 | Charleston | South Carolina | 45019 | 111709 | 931 |
2388036 | 2388036 | 2022-04-08 | Charleston | South Carolina | 45019 | 111709 | 931 |
2384781 | 2384781 | 2022-04-07 | Charleston | South Carolina | 45019 | 111709 | 931 |
2381526 | 2381526 | 2022-04-06 | Charleston | South Carolina | 45019 | 111709 | 931 |
2378271 | 2378271 | 2022-04-05 | Charleston | South Carolina | 45019 | 111709 | 931 |
2375017 | 2375017 | 2022-04-04 | Charleston | South Carolina | 45019 | 111562 | 926 |
2371765 | 2371765 | 2022-04-03 | Charleston | South Carolina | 45019 | 111562 | 926 |
2368512 | 2368512 | 2022-04-02 | Charleston | South Carolina | 45019 | 111562 | 926 |
2365259 | 2365259 | 2022-04-01 | Charleston | South Carolina | 45019 | 111562 | 926 |
2362006 | 2362006 | 2022-03-31 | Charleston | South Carolina | 45019 | 111562 | 926 |
2358752 | 2358752 | 2022-03-30 | Charleston | South Carolina | 45019 | 111562 | 926 |
2355498 | 2355498 | 2022-03-29 | Charleston | South Carolina | 45019 | 111562 | 926 |
2352245 | 2352245 | 2022-03-28 | Charleston | South Carolina | 45019 | 111409 | 923 |
2348993 | 2348993 | 2022-03-27 | Charleston | South Carolina | 45019 | 111409 | 923 |
2345740 | 2345740 | 2022-03-26 | Charleston | South Carolina | 45019 | 111409 | 923 |
2342487 | 2342487 | 2022-03-25 | Charleston | South Carolina | 45019 | 111409 | 923 |
2339234 | 2339234 | 2022-03-24 | Charleston | South Carolina | 45019 | 111409 | 923 |
2335980 | 2335980 | 2022-03-23 | Charleston | South Carolina | 45019 | 111409 | 923 |
2332726 | 2332726 | 2022-03-22 | Charleston | South Carolina | 45019 | 111409 | 923 |
2329473 | 2329473 | 2022-03-21 | Charleston | South Carolina | 45019 | 111250 | 914 |
2326221 | 2326221 | 2022-03-20 | Charleston | South Carolina | 45019 | 111250 | 914 |
2322968 | 2322968 | 2022-03-19 | Charleston | South Carolina | 45019 | 111250 | 914 |
2319714 | 2319714 | 2022-03-18 | Charleston | South Carolina | 45019 | 111250 | 914 |
2316460 | 2316460 | 2022-03-17 | Charleston | South Carolina | 45019 | 111250 | 914 |
2313207 | 2313207 | 2022-03-16 | Charleston | South Carolina | 45019 | 111250 | 914 |
2309954 | 2309954 | 2022-03-15 | Charleston | South Carolina | 45019 | 111250 | 914 |
2306701 | 2306701 | 2022-03-14 | Charleston | South Carolina | 45019 | 111200 | 913 |
2303450 | 2303450 | 2022-03-13 | Charleston | South Carolina | 45019 | 111200 | 913 |
2300198 | 2300198 | 2022-03-12 | Charleston | South Carolina | 45019 | 111200 | 913 |
2296946 | 2296946 | 2022-03-11 | Charleston | South Carolina | 45019 | 111200 | 913 |
2293694 | 2293694 | 2022-03-10 | Charleston | South Carolina | 45019 | 111163 | 911 |
2290442 | 2290442 | 2022-03-09 | Charleston | South Carolina | 45019 | 111132 | 905 |
2287190 | 2287190 | 2022-03-08 | Charleston | South Carolina | 45019 | 111116 | 905 |
2283938 | 2283938 | 2022-03-07 | Charleston | South Carolina | 45019 | 111104 | 904 |
2280686 | 2280686 | 2022-03-06 | Charleston | South Carolina | 45019 | 111053 | 893 |
2277433 | 2277433 | 2022-03-05 | Charleston | South Carolina | 45019 | 111053 | 893 |
2274180 | 2274180 | 2022-03-04 | Charleston | South Carolina | 45019 | 111053 | 893 |
2270927 | 2270927 | 2022-03-03 | Charleston | South Carolina | 45019 | 111030 | 893 |
2267675 | 2267675 | 2022-03-02 | Charleston | South Carolina | 45019 | 110996 | 890 |
2264422 | 2264422 | 2022-03-01 | Charleston | South Carolina | 45019 | 110970 | 886 |
2261172 | 2261172 | 2022-02-28 | Charleston | South Carolina | 45019 | 110950 | 885 |
2257921 | 2257921 | 2022-02-27 | Charleston | South Carolina | 45019 | 110814 | 881 |
2254670 | 2254670 | 2022-02-26 | Charleston | South Carolina | 45019 | 110814 | 881 |
2251419 | 2251419 | 2022-02-25 | Charleston | South Carolina | 45019 | 110814 | 881 |
2248168 | 2248168 | 2022-02-24 | Charleston | South Carolina | 45019 | 110754 | 879 |
2244917 | 2244917 | 2022-02-23 | Charleston | South Carolina | 45019 | 110685 | 879 |
2241666 | 2241666 | 2022-02-22 | Charleston | South Carolina | 45019 | 110596 | 879 |
2238415 | 2238415 | 2022-02-21 | Charleston | South Carolina | 45019 | 110261 | 871 |
2235164 | 2235164 | 2022-02-20 | Charleston | South Carolina | 45019 | 110261 | 871 |
2231913 | 2231913 | 2022-02-19 | Charleston | South Carolina | 45019 | 110261 | 871 |
2228662 | 2228662 | 2022-02-18 | Charleston | South Carolina | 45019 | 110261 | 871 |
2225411 | 2225411 | 2022-02-17 | Charleston | South Carolina | 45019 | 110148 | 871 |
2222160 | 2222160 | 2022-02-16 | Charleston | South Carolina | 45019 | 110047 | 868 |
2218909 | 2218909 | 2022-02-15 | Charleston | South Carolina | 45019 | 109971 | 860 |
2215658 | 2215658 | 2022-02-14 | Charleston | South Carolina | 45019 | 109912 | 860 |
2212407 | 2212407 | 2022-02-13 | Charleston | South Carolina | 45019 | 109173 | 849 |
2209154 | 2209154 | 2022-02-12 | Charleston | South Carolina | 45019 | 109173 | 849 |
2205901 | 2205901 | 2022-02-11 | Charleston | South Carolina | 45019 | 109173 | 849 |
2202648 | 2202648 | 2022-02-10 | Charleston | South Carolina | 45019 | 109173 | 849 |
2199394 | 2199394 | 2022-02-09 | Charleston | South Carolina | 45019 | 108928 | 837 |
2196140 | 2196140 | 2022-02-08 | Charleston | South Carolina | 45019 | 108671 | 835 |
2192886 | 2192886 | 2022-02-07 | Charleston | South Carolina | 45019 | 108526 | 835 |
2189632 | 2189632 | 2022-02-06 | Charleston | South Carolina | 45019 | 107482 | 831 |
2186379 | 2186379 | 2022-02-05 | Charleston | South Carolina | 45019 | 107482 | 831 |
2183127 | 2183127 | 2022-02-04 | Charleston | South Carolina | 45019 | 107482 | 831 |
2179875 | 2179875 | 2022-02-03 | Charleston | South Carolina | 45019 | 107068 | 828 |
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);