ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45041 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 632 ✖
- 41736 9
- 41805 8
- 41641 7
- 41676 7
- 41688 7
- 41707 7
- 41718 7
- 27836 6
- 36007 5
- 41761 5
- 28548 4
- 32992 4
- 40726 4
- 41332 4
- 41630 4
- 1 3
- 5 3
- 17964 3
- 17986 3
- 18016 3
- 18068 3
- 18129 3
- 18222 3
- 18439 3
- 18800 3
- 19344 3
- 20160 3
- 21367 3
- 22724 3
- 23644 3
- 24592 3
- 25277 3
- 25789 3
- 26116 3
- 26367 3
- 26513 3
- 26654 3
- 26748 3
- 26842 3
- 26980 3
- 27096 3
- 27251 3
- 27417 3
- 27580 3
- 30352 3
- 38638 3
- 40126 3
- 41512 3
- 41594 3
- 41861 3
- 6525 2
- 9505 2
- 10494 2
- 17199 2
- 17882 2
- 17922 2
- 17972 2
- 26800 2
- 27069 2
- 41609 2
- 3 1
- 11 1
- 12 1
- 13 1
- 15 1
- 19 1
- 21 1
- 26 1
- 29 1
- 35 1
- 36 1
- 39 1
- 45 1
- 47 1
- 53 1
- 64 1
- 66 1
- 72 1
- 79 1
- 82 1
- 87 1
- 103 1
- 121 1
- 128 1
- 150 1
- 153 1
- 168 1
- 176 1
- 195 1
- 225 1
- 242 1
- 265 1
- 268 1
- 273 1
- 288 1
- 304 1
- 325 1
- 329 1
- 336 1
- 348 1
- 353 1
- 358 1
- 370 1
- 399 1
- 412 1
- 424 1
- 444 1
- 455 1
- 469 1
- 487 1
- 505 1
- 519 1
- 524 1
- 540 1
- 547 1
- 550 1
- 563 1
- 574 1
- 588 1
- 602 1
- 603 1
- 605 1
- 612 1
- 622 1
- 637 1
- 643 1
- 655 1
- 675 1
- 678 1
- 684 1
- 691 1
- 707 1
- 711 1
- 717 1
- 724 1
- 727 1
- 730 1
- 751 1
- 770 1
- 793 1
- 814 1
- 826 1
- 833 1
- 855 1
- 871 1
- 878 1
- 901 1
- 921 1
- 977 1
- 995 1
- 1014 1
- 1037 1
- 1064 1
- 1104 1
- 1134 1
- 1159 1
- 1199 1
- 1230 1
- 1266 1
- 1296 1
- 1355 1
- 1384 1
- 1415 1
- 1427 1
- 1458 1
- 1492 1
- 1525 1
- 1570 1
- 1621 1
- 1659 1
- 1728 1
- 1756 1
- 1818 1
- 1880 1
- 1901 1
- 2004 1
- 2080 1
- 2148 1
- 2194 1
- 2258 1
- 2367 1
- 2430 1
- 2477 1
- 2544 1
- 2623 1
- 2676 1
- 2789 1
- 2853 1
- 2938 1
- 3033 1
- 3091 1
- 3133 1
- 3186 1
- 3258 1
- 3329 1
- 3371 1
- 3436 1
- 3480 1
- 3511 1
- 3551 1
- 3614 1
- 3659 1
- 3721 1
- 3753 1
- 3791 1
- 3816 1
- 3845 1
- 3896 1
- 3941 1
- 3968 1
- 4014 1
- 4052 1
- 4079 1
- 4103 1
- 4120 1
- 4173 1
- 4201 1
- 4226 1
- 4258 1
- 4318 1
- 4360 1
- 4386 1
- 4434 1
- 4464 1
- 4483 1
- 4503 1
- 4519 1
- 4542 1
- 4554 1
- 4589 1
- 4625 1
- 4645 1
- 4655 1
- 4672 1
- 4689 1
- 4727 1
- 4749 1
- 4779 1
- 4795 1
- 4816 1
- 4836 1
- 4851 1
- 4873 1
- 4890 1
- 4912 1
- 4931 1
- 4941 1
- 4953 1
- 4958 1
- 4968 1
- 4986 1
- 5018 1
- 5032 1
- 5043 1
- 5074 1
- 5118 1
- 5136 1
- 5148 1
- 5167 1
- 5184 1
- 5200 1
- 5230 1
- 5259 1
- 5290 1
- 5316 1
- 5343 1
- 5357 1
- 5385 1
- 5410 1
- 5427 1
- 5461 1
- 5474 1
- 5487 1
- 5529 1
- 5552 1
- 5582 1
- 5631 1
- 5639 1
- 5658 1
- 5683 1
- 5720 1
- 5747 1
- 5771 1
- 5780 1
- 5797 1
- 5817 1
- 5873 1
- 5901 1
- 5911 1
- 5942 1
- 5974 1
- 6010 1
- 6045 1
- 6110 1
- 6153 1
- 6178 1
- 6222 1
- 6271 1
- 6311 1
- 6349 1
- 6373 1
- 6389 1
- 6423 1
- 6467 1
- 6610 1
- 6680 1
- 6713 1
- 6750 1
- 6783 1
- 6820 1
- 6902 1
- 6976 1
- 7082 1
- 7182 1
- 7294 1
- 7419 1
- 7511 1
- 7598 1
- 7736 1
- 7870 1
- 8002 1
- 8138 1
- 8264 1
- 8366 1
- 8459 1
- 8646 1
- 8775 1
- 8863 1
- 9019 1
- 9149 1
- 9373 1
- 9624 1
- 10038 1
- 10119 1
- 10219 1
- 10361 1
- 10725 1
- 11116 1
- 11340 1
- 11454 1
- 11631 1
- 11794 1
- 11973 1
- 12216 1
- 12354 1
- 12469 1
- 12521 1
- 12771 1
- 13003 1
- 13204 1
- 13417 1
- 13639 1
- 13786 1
- 13886 1
- 13955 1
- 14058 1
- 14211 1
- 14327 1
- 14430 1
- 14544 1
- 14630 1
- 14694 1
- 14777 1
- 14872 1
- 14950 1
- 15049 1
- 15102 1
- 15141 1
- 15191 1
- 15246 1
- 15323 1
- 15393 1
- 15502 1
- 15552 1
- 15627 1
- 15674 1
- 15792 1
- 15908 1
- 15967 1
- 16076 1
- 16127 1
- 16151 1
- 16181 1
- 16220 1
- 16274 1
- 16338 1
- 16376 1
- 16391 1
- 16417 1
- 16449 1
- 16511 1
- 16537 1
- 16572 1
- 16592 1
- 16606 1
- 16627 1
- 16651 1
- 16665 1
- 16712 1
- 16744 1
- 16778 1
- 16807 1
- 16813 1
- 16838 1
- 16849 1
- 16886 1
- 16936 1
- 16943 1
- 16951 1
- 16962 1
- 16988 1
- 17026 1
- 17041 1
- 17052 1
- 17072 1
- 17079 1
- 17093 1
- 17095 1
- 17123 1
- 17138 1
- 17151 1
- 17155 1
- 17162 1
- 17167 1
- 17174 1
- 17185 1
- 17191 1
- 17209 1
- 17228 1
- 17234 1
- 17250 1
- 17268 1
- 17287 1
- 17300 1
- 17314 1
- 17323 1
- 17327 1
- 17346 1
- 17385 1
- 17406 1
- 17422 1
- 17440 1
- 17461 1
- 17465 1
- 17480 1
- 17504 1
- 17516 1
- 17529 1
- 17536 1
- 17546 1
- 17553 1
- 17580 1
- 17594 1
- 17607 1
- 17614 1
- 17628 1
- 17636 1
- 17652 1
- 17661 1
- 17677 1
- 17690 1
- 17702 1
- 17722 1
- 17728 1
- 17740 1
- 17742 1
- 17752 1
- 17778 1
- 17784 1
- 17793 1
- 17794 1
- 17801 1
- 17805 1
- 17825 1
- 17832 1
- 17839 1
- 17841 1
- 17843 1
- 17847 1
- 17849 1
- 17862 1
- 17868 1
- 17877 1
- 17888 1
- 17890 1
- 17895 1
- 17899 1
- 17903 1
- 17907 1
- 17912 1
- 17917 1
- 17921 1
- 17924 1
- 17934 1
- 17937 1
- 17943 1
- 17944 1
- 17977 1
- 17981 1
- 18006 1
- 18008 1
- 18009 1
- 18013 1
- 18043 1
- 18045 1
- 18049 1
- 18052 1
- 18101 1
- 18105 1
- 18112 1
- 18114 1
- 18156 1
- 18160 1
- 18168 1
- 18190 1
- 18275 1
- 18302 1
- 18345 1
- 18385 1
- 18594 1
- 18633 1
- 18685 1
- 18736 1
- 19023 1
- 19078 1
- 19119 1
- 19213 1
- 19645 1
- 19709 1
- 19817 1
- 19930 1
- 20792 1
- 20944 1
- 21059 1
- 21169 1
- 22041 1
- 22188 1
- 22334 1
- 22527 1
- 23275 1
- 23387 1
- 23467 1
- 23570 1
- 24111 1
- 24231 1
- 24334 1
- 24425 1
- 24994 1
- 25068 1
- 25119 1
- 25200 1
- 25531 1
- 25582 1
- 25626 1
- 25711 1
- 25971 1
- 26006 1
- 26031 1
- 26086 1
- 26237 1
- 26248 1
- 26281 1
- 26330 1
- 26447 1
- 26462 1
- 26479 1
- 26497 1
- 26573 1
- 26582 1
- 26606 1
- 26616 1
- 26697 1
- 26705 1
- 26715 1
- 26729 1
- 26789 1
- 26795 1
- 26892 1
- 26906 1
- 26924 1
- 26943 1
- 27051 1
- 27057 1
- 27151 1
- 27162 1
- 27183 1
- 27205 1
- 27351 1
- 27359 1
- 27376 1
- 27395 1
- 27501 1
- 27524 1
- 27539 1
- 27555 1
- 27716 1
- 27733 1
- 27780 1
- 28186 1
- 28320 1
- 29356 1
- 29554 1
- 30025 1
- 31614 1
- 31794 1
- 32074 1
- 32409 1
- 34943 1
- 35279 1
- 35630 1
- 37909 1
- 38243 1
- 39482 1
- 39592 1
- 39728 1
- 39945 1
- 40488 1
- 40528 1
- 40615 1
- 41109 1
- 41145 1
- 41188 1
- 41276 1
- 41461 1
- 41493 1
- 41499 1
- 41540 1
- 41570 1
- 41576 1
- 41584 1
- 41618 1
- 41626 1
state 1
- South Carolina 785
fips 1
- 45041 · 785 ✖
county 1
- Florence 785
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5885 | 5885 | 2020-03-20 | Florence | South Carolina | 45041 | 1 | 1 |
6891 | 6891 | 2020-03-21 | Florence | South Carolina | 45041 | 1 | 1 |
8012 | 8012 | 2020-03-22 | Florence | South Carolina | 45041 | 1 | 1 |
9224 | 9224 | 2020-03-23 | Florence | South Carolina | 45041 | 3 | 1 |
10550 | 10550 | 2020-03-24 | Florence | South Carolina | 45041 | 5 | 2 |
12021 | 12021 | 2020-03-25 | Florence | South Carolina | 45041 | 5 | 2 |
13643 | 13643 | 2020-03-26 | Florence | South Carolina | 45041 | 5 | 2 |
15390 | 15390 | 2020-03-27 | Florence | South Carolina | 45041 | 11 | 3 |
17244 | 17244 | 2020-03-28 | Florence | South Carolina | 45041 | 12 | 3 |
19184 | 19184 | 2020-03-29 | Florence | South Carolina | 45041 | 13 | 3 |
21236 | 21236 | 2020-03-30 | Florence | South Carolina | 45041 | 15 | 3 |
23374 | 23374 | 2020-03-31 | Florence | South Carolina | 45041 | 19 | 3 |
25572 | 25572 | 2020-04-01 | Florence | South Carolina | 45041 | 21 | 3 |
27846 | 27846 | 2020-04-02 | Florence | South Carolina | 45041 | 26 | 5 |
30181 | 30181 | 2020-04-03 | Florence | South Carolina | 45041 | 29 | 5 |
32572 | 32572 | 2020-04-04 | Florence | South Carolina | 45041 | 35 | 5 |
35008 | 35008 | 2020-04-05 | Florence | South Carolina | 45041 | 36 | 5 |
37483 | 37483 | 2020-04-06 | Florence | South Carolina | 45041 | 39 | 5 |
40006 | 40006 | 2020-04-07 | Florence | South Carolina | 45041 | 45 | 5 |
42566 | 42566 | 2020-04-08 | Florence | South Carolina | 45041 | 47 | 5 |
45152 | 45152 | 2020-04-09 | Florence | South Carolina | 45041 | 53 | 5 |
47769 | 47769 | 2020-04-10 | Florence | South Carolina | 45041 | 64 | 6 |
50426 | 50426 | 2020-04-11 | Florence | South Carolina | 45041 | 66 | 7 |
53099 | 53099 | 2020-04-12 | Florence | South Carolina | 45041 | 72 | 7 |
55784 | 55784 | 2020-04-13 | Florence | South Carolina | 45041 | 79 | 7 |
58487 | 58487 | 2020-04-14 | Florence | South Carolina | 45041 | 82 | 7 |
61202 | 61202 | 2020-04-15 | Florence | South Carolina | 45041 | 87 | 7 |
63928 | 63928 | 2020-04-16 | Florence | South Carolina | 45041 | 103 | 7 |
66674 | 66674 | 2020-04-17 | Florence | South Carolina | 45041 | 121 | 8 |
69432 | 69432 | 2020-04-18 | Florence | South Carolina | 45041 | 128 | 8 |
72199 | 72199 | 2020-04-19 | Florence | South Carolina | 45041 | 150 | 8 |
74974 | 74974 | 2020-04-20 | Florence | South Carolina | 45041 | 153 | 8 |
77756 | 77756 | 2020-04-21 | Florence | South Carolina | 45041 | 168 | 8 |
80546 | 80546 | 2020-04-22 | Florence | South Carolina | 45041 | 176 | 8 |
83345 | 83345 | 2020-04-23 | Florence | South Carolina | 45041 | 195 | 8 |
86149 | 86149 | 2020-04-24 | Florence | South Carolina | 45041 | 225 | 7 |
88963 | 88963 | 2020-04-25 | Florence | South Carolina | 45041 | 242 | 9 |
91779 | 91779 | 2020-04-26 | Florence | South Carolina | 45041 | 265 | 9 |
94606 | 94606 | 2020-04-27 | Florence | South Carolina | 45041 | 268 | 10 |
97445 | 97445 | 2020-04-28 | Florence | South Carolina | 45041 | 273 | 10 |
100294 | 100294 | 2020-04-29 | Florence | South Carolina | 45041 | 288 | 13 |
103147 | 103147 | 2020-04-30 | Florence | South Carolina | 45041 | 304 | 14 |
106010 | 106010 | 2020-05-01 | Florence | South Carolina | 45041 | 325 | 15 |
108877 | 108877 | 2020-05-02 | Florence | South Carolina | 45041 | 329 | 16 |
111751 | 111751 | 2020-05-03 | Florence | South Carolina | 45041 | 336 | 16 |
114633 | 114633 | 2020-05-04 | Florence | South Carolina | 45041 | 348 | 16 |
117589 | 117589 | 2020-05-05 | Florence | South Carolina | 45041 | 353 | 17 |
120551 | 120551 | 2020-05-06 | Florence | South Carolina | 45041 | 358 | 19 |
123529 | 123529 | 2020-05-07 | Florence | South Carolina | 45041 | 370 | 19 |
126512 | 126512 | 2020-05-08 | Florence | South Carolina | 45041 | 399 | 20 |
129501 | 129501 | 2020-05-09 | Florence | South Carolina | 45041 | 412 | 20 |
132490 | 132490 | 2020-05-10 | Florence | South Carolina | 45041 | 424 | 20 |
135481 | 135481 | 2020-05-11 | Florence | South Carolina | 45041 | 444 | 23 |
138471 | 138471 | 2020-05-12 | Florence | South Carolina | 45041 | 455 | 24 |
141467 | 141467 | 2020-05-13 | Florence | South Carolina | 45041 | 469 | 26 |
144463 | 144463 | 2020-05-14 | Florence | South Carolina | 45041 | 487 | 26 |
147464 | 147464 | 2020-05-15 | Florence | South Carolina | 45041 | 505 | 27 |
150472 | 150472 | 2020-05-16 | Florence | South Carolina | 45041 | 519 | 27 |
153483 | 153483 | 2020-05-17 | Florence | South Carolina | 45041 | 524 | 28 |
156500 | 156500 | 2020-05-18 | Florence | South Carolina | 45041 | 540 | 29 |
159521 | 159521 | 2020-05-19 | Florence | South Carolina | 45041 | 547 | 29 |
162548 | 162548 | 2020-05-20 | Florence | South Carolina | 45041 | 550 | 29 |
165577 | 165577 | 2020-05-21 | Florence | South Carolina | 45041 | 563 | 30 |
168613 | 168613 | 2020-05-22 | Florence | South Carolina | 45041 | 574 | 30 |
171652 | 171652 | 2020-05-23 | Florence | South Carolina | 45041 | 588 | 31 |
174694 | 174694 | 2020-05-24 | Florence | South Carolina | 45041 | 603 | 31 |
177738 | 177738 | 2020-05-25 | Florence | South Carolina | 45041 | 602 | 32 |
180781 | 180781 | 2020-05-26 | Florence | South Carolina | 45041 | 605 | 33 |
183831 | 183831 | 2020-05-27 | Florence | South Carolina | 45041 | 612 | 34 |
186888 | 186888 | 2020-05-28 | Florence | South Carolina | 45041 | 622 | 34 |
189950 | 189950 | 2020-05-29 | Florence | South Carolina | 45041 | 637 | 37 |
193015 | 193015 | 2020-05-30 | Florence | South Carolina | 45041 | 643 | 38 |
196084 | 196084 | 2020-05-31 | Florence | South Carolina | 45041 | 655 | 38 |
199157 | 199157 | 2020-06-01 | Florence | South Carolina | 45041 | 675 | 38 |
202232 | 202232 | 2020-06-02 | Florence | South Carolina | 45041 | 678 | 38 |
205309 | 205309 | 2020-06-03 | Florence | South Carolina | 45041 | 684 | 38 |
208390 | 208390 | 2020-06-04 | Florence | South Carolina | 45041 | 691 | 39 |
211472 | 211472 | 2020-06-05 | Florence | South Carolina | 45041 | 707 | 39 |
214558 | 214558 | 2020-06-06 | Florence | South Carolina | 45041 | 711 | 40 |
217648 | 217648 | 2020-06-07 | Florence | South Carolina | 45041 | 717 | 40 |
220740 | 220740 | 2020-06-08 | Florence | South Carolina | 45041 | 724 | 40 |
223835 | 223835 | 2020-06-09 | Florence | South Carolina | 45041 | 727 | 41 |
226935 | 226935 | 2020-06-10 | Florence | South Carolina | 45041 | 730 | 42 |
230039 | 230039 | 2020-06-11 | Florence | South Carolina | 45041 | 751 | 43 |
233144 | 233144 | 2020-06-12 | Florence | South Carolina | 45041 | 770 | 43 |
236249 | 236249 | 2020-06-13 | Florence | South Carolina | 45041 | 793 | 43 |
239357 | 239357 | 2020-06-14 | Florence | South Carolina | 45041 | 814 | 43 |
242466 | 242466 | 2020-06-15 | Florence | South Carolina | 45041 | 826 | 43 |
245578 | 245578 | 2020-06-16 | Florence | South Carolina | 45041 | 833 | 43 |
248691 | 248691 | 2020-06-17 | Florence | South Carolina | 45041 | 855 | 43 |
251806 | 251806 | 2020-06-18 | Florence | South Carolina | 45041 | 871 | 44 |
254921 | 254921 | 2020-06-19 | Florence | South Carolina | 45041 | 878 | 44 |
258047 | 258047 | 2020-06-20 | Florence | South Carolina | 45041 | 901 | 45 |
261174 | 261174 | 2020-06-21 | Florence | South Carolina | 45041 | 921 | 47 |
264302 | 264302 | 2020-06-22 | Florence | South Carolina | 45041 | 977 | 47 |
267430 | 267430 | 2020-06-23 | Florence | South Carolina | 45041 | 995 | 47 |
270564 | 270564 | 2020-06-24 | Florence | South Carolina | 45041 | 1014 | 47 |
273703 | 273703 | 2020-06-25 | Florence | South Carolina | 45041 | 1037 | 47 |
276850 | 276850 | 2020-06-26 | Florence | South Carolina | 45041 | 1064 | 47 |
279998 | 279998 | 2020-06-27 | Florence | South Carolina | 45041 | 1104 | 48 |
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);