ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Colleton" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 563 ✖
- 32 11
- 8861 9
- 8877 8
- 8813 7
- 8823 7
- 8841 7
- 8842 7
- 8849 7
- 23 6
- 5849 6
- 1 5
- 26 5
- 3686 5
- 7589 5
- 8864 5
- 5962 4
- 7002 4
- 8586 4
- 8701 4
- 8818 4
- 8821 4
- 5 3
- 15 3
- 21 3
- 3646 3
- 3675 3
- 3678 3
- 3700 3
- 3707 3
- 3717 3
- 3724 3
- 3745 3
- 3779 3
- 3844 3
- 3975 3
- 4106 3
- 4289 3
- 4642 3
- 4954 3
- 5139 3
- 5335 3
- 5426 3
- 5498 3
- 5554 3
- 5590 3
- 5611 3
- 5624 3
- 5632 3
- 5640 3
- 5653 3
- 5671 3
- 5702 3
- 5742 3
- 5782 3
- 5828 3
- 6350 3
- 8125 3
- 8449 3
- 8804 3
- 8913 3
- 4 2
- 6 2
- 10 2
- 33 2
- 58 2
- 76 2
- 850 2
- 852 2
- 863 2
- 889 2
- 925 2
- 983 2
- 1054 2
- 1465 2
- 1785 2
- 1951 2
- 3179 2
- 3287 2
- 3388 2
- 3405 2
- 3417 2
- 3612 2
- 3619 2
- 3673 2
- 3679 2
- 3680 2
- 3685 2
- 3687 2
- 3688 2
- 3705 2
- 3732 2
- 3756 2
- 5616 2
- 5651 2
- 5701 2
- 5771 2
- 8819 2
- 8820 2
- 8822 2
- 2 1
- 8 1
- 9 1
- 12 1
- 16 1
- 17 1
- 18 1
- 24 1
- 27 1
- 41 1
- 48 1
- 51 1
- 52 1
- 60 1
- 63 1
- 66 1
- 69 1
- 74 1
- 75 1
- 86 1
- 92 1
- 101 1
- 105 1
- 110 1
- 114 1
- 117 1
- 122 1
- 128 1
- 132 1
- 142 1
- 144 1
- 148 1
- 159 1
- 165 1
- 177 1
- 190 1
- 198 1
- 201 1
- 209 1
- 211 1
- 214 1
- 217 1
- 234 1
- 245 1
- 246 1
- 253 1
- 258 1
- 273 1
- 284 1
- 295 1
- 307 1
- 324 1
- 329 1
- 333 1
- 343 1
- 352 1
- 364 1
- 378 1
- 384 1
- 401 1
- 411 1
- 423 1
- 432 1
- 458 1
- 473 1
- 475 1
- 508 1
- 520 1
- 533 1
- 550 1
- 558 1
- 568 1
- 573 1
- 593 1
- 617 1
- 628 1
- 641 1
- 657 1
- 664 1
- 675 1
- 682 1
- 703 1
- 727 1
- 739 1
- 752 1
- 763 1
- 765 1
- 771 1
- 779 1
- 791 1
- 798 1
- 807 1
- 814 1
- 825 1
- 828 1
- 831 1
- 837 1
- 840 1
- 847 1
- 859 1
- 865 1
- 867 1
- 872 1
- 875 1
- 877 1
- 887 1
- 890 1
- 893 1
- 897 1
- 904 1
- 908 1
- 916 1
- 921 1
- 926 1
- 933 1
- 950 1
- 951 1
- 956 1
- 961 1
- 964 1
- 966 1
- 973 1
- 977 1
- 994 1
- 1004 1
- 1006 1
- 1008 1
- 1013 1
- 1022 1
- 1031 1
- 1042 1
- 1056 1
- 1057 1
- 1068 1
- 1074 1
- 1081 1
- 1091 1
- 1101 1
- 1112 1
- 1122 1
- 1129 1
- 1134 1
- 1142 1
- 1152 1
- 1167 1
- 1173 1
- 1178 1
- 1185 1
- 1193 1
- 1197 1
- 1208 1
- 1212 1
- 1215 1
- 1224 1
- 1231 1
- 1236 1
- 1245 1
- 1253 1
- 1259 1
- 1270 1
- 1278 1
- 1279 1
- 1292 1
- 1299 1
- 1313 1
- 1324 1
- 1327 1
- 1332 1
- 1343 1
- 1352 1
- 1357 1
- 1370 1
- 1372 1
- 1374 1
- 1391 1
- 1398 1
- 1407 1
- 1412 1
- 1413 1
- 1424 1
- 1431 1
- 1440 1
- 1448 1
- 1450 1
- 1454 1
- 1458 1
- 1475 1
- 1476 1
- 1480 1
- 1484 1
- 1485 1
- 1496 1
- 1502 1
- 1516 1
- 1534 1
- 1543 1
- 1556 1
- 1564 1
- 1574 1
- 1585 1
- 1591 1
- 1617 1
- 1634 1
- 1656 1
- 1663 1
- 1680 1
- 1699 1
- 1715 1
- 1731 1
- 1752 1
- 1760 1
- 1773 1
- 1778 1
- 1815 1
- 1849 1
- 1874 1
- 1882 1
- 1900 1
- 1990 1
- 2041 1
- 2055 1
- 2060 1
- 2088 1
- 2116 1
- 2148 1
- 2179 1
- 2210 1
- 2259 1
- 2296 1
- 2340 1
- 2374 1
- 2401 1
- 2436 1
- 2464 1
- 2502 1
- 2509 1
- 2530 1
- 2566 1
- 2604 1
- 2638 1
- 2668 1
- 2686 1
- 2695 1
- 2710 1
- 2729 1
- 2770 1
- 2797 1
- 2820 1
- 2833 1
- 2842 1
- 2852 1
- 2904 1
- 2932 1
- 2945 1
- 2960 1
- 2964 1
- 2983 1
- 3034 1
- 3047 1
- 3054 1
- 3065 1
- 3081 1
- 3089 1
- 3097 1
- 3105 1
- 3109 1
- 3118 1
- 3156 1
- 3174 1
- 3190 1
- 3196 1
- 3213 1
- 3235 1
- 3243 1
- 3251 1
- 3254 1
- 3258 1
- 3262 1
- 3268 1
- 3274 1
- 3282 1
- 3286 1
- 3291 1
- 3300 1
- 3306 1
- 3312 1
- 3323 1
- 3325 1
- 3327 1
- 3330 1
- 3337 1
- 3351 1
- 3356 1
- 3358 1
- 3363 1
- 3369 1
- 3375 1
- 3376 1
- 3380 1
- 3385 1
- 3392 1
- 3400 1
- 3403 1
- 3412 1
- 3425 1
- 3436 1
- 3446 1
- 3451 1
- 3452 1
- 3458 1
- 3462 1
- 3475 1
- 3492 1
- 3494 1
- 3497 1
- 3502 1
- 3513 1
- 3524 1
- 3534 1
- 3541 1
- 3547 1
- 3556 1
- 3559 1
- 3560 1
- 3561 1
- 3574 1
- 3582 1
- 3589 1
- 3593 1
- 3596 1
- 3598 1
- 3603 1
- 3604 1
- 3607 1
- 3609 1
- 3622 1
- 3629 1
- 3644 1
- 3649 1
- 3651 1
- 3653 1
- 3654 1
- 3661 1
- 3665 1
- 3668 1
- 3676 1
- 3677 1
- 3681 1
- 3694 1
- 3696 1
- 3697 1
- 3698 1
- 3702 1
- 3706 1
- 3716 1
- 3734 1
- 3739 1
- 3765 1
- 3772 1
- 3811 1
- 3813 1
- 3823 1
- 3837 1
- 3885 1
- 3889 1
- 3932 1
- 3953 1
- 4028 1
- 4034 1
- 4054 1
- 4078 1
- 4194 1
- 4211 1
- 4236 1
- 4257 1
- 4451 1
- 4487 1
- 4538 1
- 4576 1
- 4809 1
- 4848 1
- 4887 1
- 4929 1
- 5077 1
- 5097 1
- 5113 1
- 5124 1
- 5237 1
- 5262 1
- 5276 1
- 5298 1
- 5381 1
- 5389 1
- 5403 1
- 5417 1
- 5461 1
- 5467 1
- 5475 1
- 5492 1
- 5528 1
- 5532 1
- 5537 1
- 5546 1
- 5577 1
- 5578 1
- 5582 1
- 5586 1
- 5598 1
- 5600 1
- 5603 1
- 5606 1
- 5617 1
- 5619 1
- 5633 1
- 5644 1
- 5645 1
- 5657 1
- 5658 1
- 5659 1
- 5662 1
- 5695 1
- 5698 1
- 5708 1
- 5723 1
- 5726 1
- 5733 1
- 5762 1
- 5777 1
- 5811 1
- 5817 1
- 5820 1
- 5821 1
- 5841 1
- 5842 1
- 5843 1
- 5894 1
- 5937 1
- 6170 1
- 6200 1
- 6297 1
- 6613 1
- 6665 1
- 6743 1
- 6873 1
- 7383 1
- 7416 1
- 7479 1
- 7901 1
- 7943 1
- 8267 1
- 8291 1
- 8311 1
- 8336 1
- 8508 1
- 8519 1
- 8571 1
- 8668 1
- 8683 1
- 8688 1
- 8696 1
- 8769 1
- 8785 1
- 8794 1
- 8816 1
state 1
- South Carolina 783
fips 1
- 45029 783
county 1
- Colleton · 783 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8006 | 8006 | 2020-03-22 | Colleton | South Carolina | 45029 | 1 | 0 |
9218 | 9218 | 2020-03-23 | Colleton | South Carolina | 45029 | 1 | 0 |
10544 | 10544 | 2020-03-24 | Colleton | South Carolina | 45029 | 1 | 0 |
12015 | 12015 | 2020-03-25 | Colleton | South Carolina | 45029 | 1 | 0 |
13637 | 13637 | 2020-03-26 | Colleton | South Carolina | 45029 | 1 | 0 |
15384 | 15384 | 2020-03-27 | Colleton | South Carolina | 45029 | 2 | 0 |
17238 | 17238 | 2020-03-28 | Colleton | South Carolina | 45029 | 4 | 0 |
19178 | 19178 | 2020-03-29 | Colleton | South Carolina | 45029 | 4 | 0 |
21230 | 21230 | 2020-03-30 | Colleton | South Carolina | 45029 | 5 | 0 |
23368 | 23368 | 2020-03-31 | Colleton | South Carolina | 45029 | 5 | 0 |
25566 | 25566 | 2020-04-01 | Colleton | South Carolina | 45029 | 5 | 0 |
27840 | 27840 | 2020-04-02 | Colleton | South Carolina | 45029 | 6 | 0 |
30175 | 30175 | 2020-04-03 | Colleton | South Carolina | 45029 | 6 | 0 |
32566 | 32566 | 2020-04-04 | Colleton | South Carolina | 45029 | 9 | 0 |
35002 | 35002 | 2020-04-05 | Colleton | South Carolina | 45029 | 8 | 0 |
37477 | 37477 | 2020-04-06 | Colleton | South Carolina | 45029 | 10 | 0 |
40000 | 40000 | 2020-04-07 | Colleton | South Carolina | 45029 | 10 | 0 |
42560 | 42560 | 2020-04-08 | Colleton | South Carolina | 45029 | 12 | 0 |
45146 | 45146 | 2020-04-09 | Colleton | South Carolina | 45029 | 15 | 0 |
47763 | 47763 | 2020-04-10 | Colleton | South Carolina | 45029 | 15 | 0 |
50420 | 50420 | 2020-04-11 | Colleton | South Carolina | 45029 | 15 | 0 |
53093 | 53093 | 2020-04-12 | Colleton | South Carolina | 45029 | 16 | 0 |
55778 | 55778 | 2020-04-13 | Colleton | South Carolina | 45029 | 17 | 0 |
58481 | 58481 | 2020-04-14 | Colleton | South Carolina | 45029 | 18 | 0 |
61196 | 61196 | 2020-04-15 | Colleton | South Carolina | 45029 | 21 | 1 |
63922 | 63922 | 2020-04-16 | Colleton | South Carolina | 45029 | 21 | 1 |
66668 | 66668 | 2020-04-17 | Colleton | South Carolina | 45029 | 21 | 1 |
69426 | 69426 | 2020-04-18 | Colleton | South Carolina | 45029 | 23 | 1 |
72193 | 72193 | 2020-04-19 | Colleton | South Carolina | 45029 | 23 | 1 |
74968 | 74968 | 2020-04-20 | Colleton | South Carolina | 45029 | 23 | 1 |
77750 | 77750 | 2020-04-21 | Colleton | South Carolina | 45029 | 23 | 2 |
80540 | 80540 | 2020-04-22 | Colleton | South Carolina | 45029 | 23 | 2 |
83339 | 83339 | 2020-04-23 | Colleton | South Carolina | 45029 | 23 | 2 |
86143 | 86143 | 2020-04-24 | Colleton | South Carolina | 45029 | 24 | 2 |
88957 | 88957 | 2020-04-25 | Colleton | South Carolina | 45029 | 26 | 3 |
91773 | 91773 | 2020-04-26 | Colleton | South Carolina | 45029 | 26 | 4 |
94600 | 94600 | 2020-04-27 | Colleton | South Carolina | 45029 | 26 | 4 |
97439 | 97439 | 2020-04-28 | Colleton | South Carolina | 45029 | 26 | 4 |
100288 | 100288 | 2020-04-29 | Colleton | South Carolina | 45029 | 26 | 4 |
103141 | 103141 | 2020-04-30 | Colleton | South Carolina | 45029 | 27 | 4 |
106004 | 106004 | 2020-05-01 | Colleton | South Carolina | 45029 | 33 | 4 |
108871 | 108871 | 2020-05-02 | Colleton | South Carolina | 45029 | 32 | 4 |
111745 | 111745 | 2020-05-03 | Colleton | South Carolina | 45029 | 32 | 4 |
114627 | 114627 | 2020-05-04 | Colleton | South Carolina | 45029 | 32 | 4 |
117583 | 117583 | 2020-05-05 | Colleton | South Carolina | 45029 | 32 | 4 |
120545 | 120545 | 2020-05-06 | Colleton | South Carolina | 45029 | 32 | 4 |
123523 | 123523 | 2020-05-07 | Colleton | South Carolina | 45029 | 32 | 4 |
126506 | 126506 | 2020-05-08 | Colleton | South Carolina | 45029 | 32 | 4 |
129495 | 129495 | 2020-05-09 | Colleton | South Carolina | 45029 | 32 | 4 |
132484 | 132484 | 2020-05-10 | Colleton | South Carolina | 45029 | 32 | 4 |
135475 | 135475 | 2020-05-11 | Colleton | South Carolina | 45029 | 32 | 4 |
138465 | 138465 | 2020-05-12 | Colleton | South Carolina | 45029 | 32 | 4 |
141461 | 141461 | 2020-05-13 | Colleton | South Carolina | 45029 | 33 | 4 |
144457 | 144457 | 2020-05-14 | Colleton | South Carolina | 45029 | 41 | 4 |
147458 | 147458 | 2020-05-15 | Colleton | South Carolina | 45029 | 48 | 4 |
150466 | 150466 | 2020-05-16 | Colleton | South Carolina | 45029 | 51 | 4 |
153477 | 153477 | 2020-05-17 | Colleton | South Carolina | 45029 | 52 | 4 |
156494 | 156494 | 2020-05-18 | Colleton | South Carolina | 45029 | 58 | 4 |
159515 | 159515 | 2020-05-19 | Colleton | South Carolina | 45029 | 58 | 4 |
162542 | 162542 | 2020-05-20 | Colleton | South Carolina | 45029 | 60 | 8 |
165571 | 165571 | 2020-05-21 | Colleton | South Carolina | 45029 | 63 | 8 |
168607 | 168607 | 2020-05-22 | Colleton | South Carolina | 45029 | 66 | 8 |
171646 | 171646 | 2020-05-23 | Colleton | South Carolina | 45029 | 69 | 8 |
174688 | 174688 | 2020-05-24 | Colleton | South Carolina | 45029 | 75 | 8 |
177732 | 177732 | 2020-05-25 | Colleton | South Carolina | 45029 | 74 | 8 |
180775 | 180775 | 2020-05-26 | Colleton | South Carolina | 45029 | 76 | 8 |
183825 | 183825 | 2020-05-27 | Colleton | South Carolina | 45029 | 76 | 11 |
186882 | 186882 | 2020-05-28 | Colleton | South Carolina | 45029 | 86 | 11 |
189944 | 189944 | 2020-05-29 | Colleton | South Carolina | 45029 | 92 | 11 |
193009 | 193009 | 2020-05-30 | Colleton | South Carolina | 45029 | 101 | 11 |
196078 | 196078 | 2020-05-31 | Colleton | South Carolina | 45029 | 105 | 12 |
199151 | 199151 | 2020-06-01 | Colleton | South Carolina | 45029 | 110 | 14 |
202226 | 202226 | 2020-06-02 | Colleton | South Carolina | 45029 | 114 | 14 |
205303 | 205303 | 2020-06-03 | Colleton | South Carolina | 45029 | 117 | 14 |
208384 | 208384 | 2020-06-04 | Colleton | South Carolina | 45029 | 122 | 14 |
211466 | 211466 | 2020-06-05 | Colleton | South Carolina | 45029 | 128 | 14 |
214552 | 214552 | 2020-06-06 | Colleton | South Carolina | 45029 | 132 | 14 |
217642 | 217642 | 2020-06-07 | Colleton | South Carolina | 45029 | 142 | 14 |
220734 | 220734 | 2020-06-08 | Colleton | South Carolina | 45029 | 144 | 14 |
223829 | 223829 | 2020-06-09 | Colleton | South Carolina | 45029 | 148 | 14 |
226929 | 226929 | 2020-06-10 | Colleton | South Carolina | 45029 | 159 | 14 |
230033 | 230033 | 2020-06-11 | Colleton | South Carolina | 45029 | 165 | 16 |
233138 | 233138 | 2020-06-12 | Colleton | South Carolina | 45029 | 177 | 16 |
236243 | 236243 | 2020-06-13 | Colleton | South Carolina | 45029 | 190 | 16 |
239351 | 239351 | 2020-06-14 | Colleton | South Carolina | 45029 | 198 | 16 |
242460 | 242460 | 2020-06-15 | Colleton | South Carolina | 45029 | 201 | 16 |
245572 | 245572 | 2020-06-16 | Colleton | South Carolina | 45029 | 209 | 17 |
248685 | 248685 | 2020-06-17 | Colleton | South Carolina | 45029 | 211 | 18 |
251800 | 251800 | 2020-06-18 | Colleton | South Carolina | 45029 | 214 | 18 |
254915 | 254915 | 2020-06-19 | Colleton | South Carolina | 45029 | 217 | 19 |
258041 | 258041 | 2020-06-20 | Colleton | South Carolina | 45029 | 234 | 19 |
261168 | 261168 | 2020-06-21 | Colleton | South Carolina | 45029 | 245 | 20 |
264296 | 264296 | 2020-06-22 | Colleton | South Carolina | 45029 | 246 | 20 |
267424 | 267424 | 2020-06-23 | Colleton | South Carolina | 45029 | 253 | 20 |
270558 | 270558 | 2020-06-24 | Colleton | South Carolina | 45029 | 258 | 20 |
273697 | 273697 | 2020-06-25 | Colleton | South Carolina | 45029 | 273 | 21 |
276844 | 276844 | 2020-06-26 | Colleton | South Carolina | 45029 | 284 | 21 |
279992 | 279992 | 2020-06-27 | Colleton | South Carolina | 45029 | 295 | 21 |
283138 | 283138 | 2020-06-28 | Colleton | South Carolina | 45029 | 307 | 21 |
286283 | 286283 | 2020-06-29 | Colleton | South Carolina | 45029 | 324 | 21 |
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);