ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 45001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 521 ✖
- 2599 32
- 2598 12
- 34 10
- 6644 9
- 6620 8
- 6652 8
- 35 7
- 6621 7
- 6629 7
- 6637 7
- 6642 7
- 1 6
- 4 6
- 6 6
- 4157 6
- 5703 5
- 6648 5
- 9 4
- 33 4
- 36 4
- 73 4
- 2597 4
- 4282 4
- 5004 4
- 6461 4
- 6553 4
- 6619 4
- 10 3
- 29 3
- 31 3
- 2570 3
- 2596 3
- 2614 3
- 2645 3
- 2682 3
- 2731 3
- 2809 3
- 2918 3
- 3068 3
- 3208 3
- 3426 3
- 3519 3
- 3623 3
- 3699 3
- 3764 3
- 3817 3
- 3831 3
- 3854 3
- 3883 3
- 3906 3
- 3939 3
- 3977 3
- 4032 3
- 4104 3
- 4533 3
- 6104 3
- 6367 3
- 6605 3
- 6614 3
- 6655 3
- 3 2
- 7 2
- 17 2
- 24 2
- 39 2
- 46 2
- 47 2
- 60 2
- 63 2
- 86 2
- 103 2
- 113 2
- 119 2
- 335 2
- 467 2
- 469 2
- 530 2
- 579 2
- 687 2
- 694 2
- 934 2
- 1216 2
- 1275 2
- 2426 2
- 2447 2
- 2530 2
- 2534 2
- 2563 2
- 2580 2
- 2583 2
- 2587 2
- 2624 2
- 3365 2
- 3829 2
- 3879 2
- 3893 2
- 3928 2
- 6615 2
- 5 1
- 15 1
- 18 1
- 22 1
- 23 1
- 27 1
- 37 1
- 42 1
- 44 1
- 49 1
- 51 1
- 58 1
- 62 1
- 67 1
- 70 1
- 87 1
- 88 1
- 91 1
- 99 1
- 100 1
- 106 1
- 118 1
- 124 1
- 134 1
- 135 1
- 137 1
- 138 1
- 141 1
- 150 1
- 153 1
- 157 1
- 162 1
- 165 1
- 170 1
- 176 1
- 185 1
- 190 1
- 242 1
- 246 1
- 249 1
- 255 1
- 260 1
- 264 1
- 269 1
- 270 1
- 272 1
- 279 1
- 282 1
- 285 1
- 288 1
- 290 1
- 298 1
- 301 1
- 304 1
- 313 1
- 321 1
- 325 1
- 346 1
- 353 1
- 354 1
- 355 1
- 360 1
- 362 1
- 363 1
- 366 1
- 371 1
- 376 1
- 381 1
- 385 1
- 388 1
- 390 1
- 392 1
- 393 1
- 394 1
- 404 1
- 406 1
- 415 1
- 418 1
- 434 1
- 439 1
- 450 1
- 462 1
- 463 1
- 464 1
- 478 1
- 488 1
- 491 1
- 492 1
- 498 1
- 500 1
- 515 1
- 531 1
- 532 1
- 538 1
- 548 1
- 553 1
- 569 1
- 578 1
- 582 1
- 591 1
- 595 1
- 606 1
- 633 1
- 638 1
- 640 1
- 651 1
- 662 1
- 672 1
- 692 1
- 693 1
- 701 1
- 703 1
- 707 1
- 711 1
- 713 1
- 716 1
- 718 1
- 723 1
- 733 1
- 739 1
- 747 1
- 754 1
- 760 1
- 768 1
- 779 1
- 789 1
- 801 1
- 805 1
- 806 1
- 808 1
- 812 1
- 820 1
- 826 1
- 836 1
- 839 1
- 840 1
- 844 1
- 849 1
- 855 1
- 864 1
- 865 1
- 866 1
- 869 1
- 872 1
- 882 1
- 887 1
- 901 1
- 906 1
- 912 1
- 914 1
- 923 1
- 948 1
- 960 1
- 961 1
- 967 1
- 972 1
- 978 1
- 989 1
- 1002 1
- 1032 1
- 1036 1
- 1052 1
- 1055 1
- 1058 1
- 1066 1
- 1079 1
- 1102 1
- 1108 1
- 1117 1
- 1125 1
- 1131 1
- 1134 1
- 1146 1
- 1163 1
- 1183 1
- 1189 1
- 1195 1
- 1204 1
- 1228 1
- 1250 1
- 1254 1
- 1264 1
- 1265 1
- 1282 1
- 1294 1
- 1301 1
- 1305 1
- 1316 1
- 1328 1
- 1347 1
- 1360 1
- 1383 1
- 1389 1
- 1391 1
- 1414 1
- 1443 1
- 1456 1
- 1472 1
- 1495 1
- 1498 1
- 1510 1
- 1581 1
- 1620 1
- 1635 1
- 1682 1
- 1707 1
- 1718 1
- 1733 1
- 1742 1
- 1759 1
- 1782 1
- 1830 1
- 1843 1
- 1848 1
- 1856 1
- 1873 1
- 1887 1
- 1948 1
- 1972 1
- 1989 1
- 2002 1
- 2008 1
- 2024 1
- 2045 1
- 2067 1
- 2097 1
- 2117 1
- 2119 1
- 2124 1
- 2130 1
- 2146 1
- 2159 1
- 2174 1
- 2184 1
- 2191 1
- 2192 1
- 2200 1
- 2207 1
- 2216 1
- 2224 1
- 2235 1
- 2236 1
- 2237 1
- 2243 1
- 2252 1
- 2267 1
- 2280 1
- 2284 1
- 2285 1
- 2286 1
- 2292 1
- 2301 1
- 2308 1
- 2327 1
- 2330 1
- 2333 1
- 2338 1
- 2347 1
- 2349 1
- 2352 1
- 2359 1
- 2368 1
- 2374 1
- 2376 1
- 2380 1
- 2403 1
- 2406 1
- 2417 1
- 2418 1
- 2427 1
- 2429 1
- 2435 1
- 2459 1
- 2467 1
- 2481 1
- 2485 1
- 2494 1
- 2501 1
- 2502 1
- 2504 1
- 2506 1
- 2510 1
- 2511 1
- 2519 1
- 2523 1
- 2527 1
- 2536 1
- 2538 1
- 2541 1
- 2542 1
- 2545 1
- 2548 1
- 2549 1
- 2557 1
- 2559 1
- 2560 1
- 2564 1
- 2567 1
- 2569 1
- 2572 1
- 2574 1
- 2576 1
- 2578 1
- 2579 1
- 2581 1
- 2582 1
- 2586 1
- 2588 1
- 2590 1
- 2593 1
- 2595 1
- 2605 1
- 2606 1
- 2609 1
- 2612 1
- 2622 1
- 2632 1
- 2656 1
- 2666 1
- 2673 1
- 2681 1
- 2700 1
- 2704 1
- 2711 1
- 2718 1
- 2770 1
- 2777 1
- 2783 1
- 2793 1
- 2857 1
- 2866 1
- 2874 1
- 2896 1
- 2977 1
- 3010 1
- 3019 1
- 3041 1
- 3145 1
- 3172 1
- 3183 1
- 3193 1
- 3345 1
- 3383 1
- 3463 1
- 3472 1
- 3479 1
- 3499 1
- 3569 1
- 3580 1
- 3592 1
- 3604 1
- 3662 1
- 3665 1
- 3672 1
- 3686 1
- 3727 1
- 3738 1
- 3741 1
- 3748 1
- 3791 1
- 3793 1
- 3802 1
- 3805 1
- 3825 1
- 3827 1
- 3843 1
- 3844 1
- 3845 1
- 3852 1
- 3873 1
- 3875 1
- 3895 1
- 3900 1
- 3922 1
- 3926 1
- 3958 1
- 3959 1
- 3964 1
- 3972 1
- 3998 1
- 4000 1
- 4013 1
- 4024 1
- 4070 1
- 4074 1
- 4083 1
- 4090 1
- 4128 1
- 4137 1
- 4147 1
- 4207 1
- 4234 1
- 4394 1
- 4407 1
- 4448 1
- 4808 1
- 4846 1
- 4878 1
- 4931 1
- 5513 1
- 5548 1
- 5599 1
- 6012 1
- 6040 1
- 6271 1
- 6285 1
- 6307 1
- 6327 1
- 6421 1
- 6434 1
- 6444 1
- 6512 1
- 6517 1
- 6525 1
- 6537 1
- 6581 1
- 6586 1
- 6594 1
- 6607 1
- 6609 1
- 6611 1
- 6612 1
- 6617 1
state 1
- South Carolina 786
fips 1
- 45001 · 786 ✖
county 1
- Abbeville 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501999 | 2501999 | 2022-05-13 | Abbeville | South Carolina | 45001 | 6655 | 69 |
2498741 | 2498741 | 2022-05-12 | Abbeville | South Carolina | 45001 | 6655 | 69 |
2495483 | 2495483 | 2022-05-11 | Abbeville | South Carolina | 45001 | 6655 | 69 |
2492225 | 2492225 | 2022-05-10 | Abbeville | South Carolina | 45001 | 6652 | 69 |
2488967 | 2488967 | 2022-05-09 | Abbeville | South Carolina | 45001 | 6652 | 69 |
2485710 | 2485710 | 2022-05-08 | Abbeville | South Carolina | 45001 | 6652 | 69 |
2482452 | 2482452 | 2022-05-07 | Abbeville | South Carolina | 45001 | 6652 | 69 |
2479194 | 2479194 | 2022-05-06 | Abbeville | South Carolina | 45001 | 6652 | 69 |
2475936 | 2475936 | 2022-05-05 | Abbeville | South Carolina | 45001 | 6652 | 69 |
2472679 | 2472679 | 2022-05-04 | Abbeville | South Carolina | 45001 | 6652 | 69 |
2469423 | 2469423 | 2022-05-03 | Abbeville | South Carolina | 45001 | 6652 | 69 |
2466167 | 2466167 | 2022-05-02 | Abbeville | South Carolina | 45001 | 6648 | 69 |
2462912 | 2462912 | 2022-05-01 | Abbeville | South Carolina | 45001 | 6648 | 69 |
2459656 | 2459656 | 2022-04-30 | Abbeville | South Carolina | 45001 | 6648 | 69 |
2456400 | 2456400 | 2022-04-29 | Abbeville | South Carolina | 45001 | 6648 | 69 |
2453144 | 2453144 | 2022-04-28 | Abbeville | South Carolina | 45001 | 6648 | 69 |
2449888 | 2449888 | 2022-04-27 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2446631 | 2446631 | 2022-04-26 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2443376 | 2443376 | 2022-04-25 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2440120 | 2440120 | 2022-04-24 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2436864 | 2436864 | 2022-04-23 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2433608 | 2433608 | 2022-04-22 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2430352 | 2430352 | 2022-04-21 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2427096 | 2427096 | 2022-04-20 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2423840 | 2423840 | 2022-04-19 | Abbeville | South Carolina | 45001 | 6644 | 69 |
2420584 | 2420584 | 2022-04-18 | Abbeville | South Carolina | 45001 | 6642 | 69 |
2417328 | 2417328 | 2022-04-17 | Abbeville | South Carolina | 45001 | 6642 | 69 |
2414072 | 2414072 | 2022-04-16 | Abbeville | South Carolina | 45001 | 6642 | 69 |
2410816 | 2410816 | 2022-04-15 | Abbeville | South Carolina | 45001 | 6642 | 69 |
2407560 | 2407560 | 2022-04-14 | Abbeville | South Carolina | 45001 | 6642 | 69 |
2404304 | 2404304 | 2022-04-13 | Abbeville | South Carolina | 45001 | 6642 | 69 |
2401049 | 2401049 | 2022-04-12 | Abbeville | South Carolina | 45001 | 6642 | 69 |
2397794 | 2397794 | 2022-04-11 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2394539 | 2394539 | 2022-04-10 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2391283 | 2391283 | 2022-04-09 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2388027 | 2388027 | 2022-04-08 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2384772 | 2384772 | 2022-04-07 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2381517 | 2381517 | 2022-04-06 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2378262 | 2378262 | 2022-04-05 | Abbeville | South Carolina | 45001 | 6637 | 69 |
2375008 | 2375008 | 2022-04-04 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2371756 | 2371756 | 2022-04-03 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2368503 | 2368503 | 2022-04-02 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2365250 | 2365250 | 2022-04-01 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2361997 | 2361997 | 2022-03-31 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2358743 | 2358743 | 2022-03-30 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2355489 | 2355489 | 2022-03-29 | Abbeville | South Carolina | 45001 | 6629 | 70 |
2352236 | 2352236 | 2022-03-28 | Abbeville | South Carolina | 45001 | 6621 | 69 |
2348984 | 2348984 | 2022-03-27 | Abbeville | South Carolina | 45001 | 6621 | 69 |
2345731 | 2345731 | 2022-03-26 | Abbeville | South Carolina | 45001 | 6621 | 69 |
2342478 | 2342478 | 2022-03-25 | Abbeville | South Carolina | 45001 | 6621 | 69 |
2339225 | 2339225 | 2022-03-24 | Abbeville | South Carolina | 45001 | 6621 | 69 |
2335971 | 2335971 | 2022-03-23 | Abbeville | South Carolina | 45001 | 6621 | 69 |
2332717 | 2332717 | 2022-03-22 | Abbeville | South Carolina | 45001 | 6621 | 69 |
2329464 | 2329464 | 2022-03-21 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2326212 | 2326212 | 2022-03-20 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2322959 | 2322959 | 2022-03-19 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2319705 | 2319705 | 2022-03-18 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2316451 | 2316451 | 2022-03-17 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2313198 | 2313198 | 2022-03-16 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2309945 | 2309945 | 2022-03-15 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2306692 | 2306692 | 2022-03-14 | Abbeville | South Carolina | 45001 | 6619 | 69 |
2303441 | 2303441 | 2022-03-13 | Abbeville | South Carolina | 45001 | 6619 | 69 |
2300189 | 2300189 | 2022-03-12 | Abbeville | South Carolina | 45001 | 6619 | 69 |
2296937 | 2296937 | 2022-03-11 | Abbeville | South Carolina | 45001 | 6619 | 69 |
2293685 | 2293685 | 2022-03-10 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2290433 | 2290433 | 2022-03-09 | Abbeville | South Carolina | 45001 | 6617 | 67 |
2287181 | 2287181 | 2022-03-08 | Abbeville | South Carolina | 45001 | 6615 | 67 |
2283929 | 2283929 | 2022-03-07 | Abbeville | South Carolina | 45001 | 6615 | 67 |
2280677 | 2280677 | 2022-03-06 | Abbeville | South Carolina | 45001 | 6614 | 67 |
2277424 | 2277424 | 2022-03-05 | Abbeville | South Carolina | 45001 | 6614 | 67 |
2274171 | 2274171 | 2022-03-04 | Abbeville | South Carolina | 45001 | 6614 | 67 |
2270918 | 2270918 | 2022-03-03 | Abbeville | South Carolina | 45001 | 6609 | 67 |
2267666 | 2267666 | 2022-03-02 | Abbeville | South Carolina | 45001 | 6607 | 67 |
2264413 | 2264413 | 2022-03-01 | Abbeville | South Carolina | 45001 | 6611 | 67 |
2261163 | 2261163 | 2022-02-28 | Abbeville | South Carolina | 45001 | 6612 | 68 |
2257912 | 2257912 | 2022-02-27 | Abbeville | South Carolina | 45001 | 6605 | 67 |
2254661 | 2254661 | 2022-02-26 | Abbeville | South Carolina | 45001 | 6605 | 67 |
2251410 | 2251410 | 2022-02-25 | Abbeville | South Carolina | 45001 | 6605 | 67 |
2248159 | 2248159 | 2022-02-24 | Abbeville | South Carolina | 45001 | 6594 | 65 |
2244908 | 2244908 | 2022-02-23 | Abbeville | South Carolina | 45001 | 6586 | 65 |
2241657 | 2241657 | 2022-02-22 | Abbeville | South Carolina | 45001 | 6581 | 65 |
2238406 | 2238406 | 2022-02-21 | Abbeville | South Carolina | 45001 | 6553 | 64 |
2235155 | 2235155 | 2022-02-20 | Abbeville | South Carolina | 45001 | 6553 | 64 |
2231904 | 2231904 | 2022-02-19 | Abbeville | South Carolina | 45001 | 6553 | 64 |
2228653 | 2228653 | 2022-02-18 | Abbeville | South Carolina | 45001 | 6553 | 64 |
2225402 | 2225402 | 2022-02-17 | Abbeville | South Carolina | 45001 | 6537 | 64 |
2222151 | 2222151 | 2022-02-16 | Abbeville | South Carolina | 45001 | 6525 | 63 |
2218900 | 2218900 | 2022-02-15 | Abbeville | South Carolina | 45001 | 6517 | 63 |
2215649 | 2215649 | 2022-02-14 | Abbeville | South Carolina | 45001 | 6512 | 63 |
2212398 | 2212398 | 2022-02-13 | Abbeville | South Carolina | 45001 | 6461 | 63 |
2209145 | 2209145 | 2022-02-12 | Abbeville | South Carolina | 45001 | 6461 | 63 |
2205892 | 2205892 | 2022-02-11 | Abbeville | South Carolina | 45001 | 6461 | 63 |
2202639 | 2202639 | 2022-02-10 | Abbeville | South Carolina | 45001 | 6461 | 63 |
2199385 | 2199385 | 2022-02-09 | Abbeville | South Carolina | 45001 | 6444 | 63 |
2196131 | 2196131 | 2022-02-08 | Abbeville | South Carolina | 45001 | 6434 | 62 |
2192877 | 2192877 | 2022-02-07 | Abbeville | South Carolina | 45001 | 6421 | 62 |
2189623 | 2189623 | 2022-02-06 | Abbeville | South Carolina | 45001 | 6367 | 61 |
2186370 | 2186370 | 2022-02-05 | Abbeville | South Carolina | 45001 | 6367 | 61 |
2183118 | 2183118 | 2022-02-04 | Abbeville | South Carolina | 45001 | 6367 | 61 |
2179866 | 2179866 | 2022-02-03 | Abbeville | South Carolina | 45001 | 6327 | 61 |
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);