ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Charles" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 740 ✖
- 15070 24
- 1 5
- 2 3
- 5 3
- 14874 3
- 18451 3
- 27866 3
- 27954 3
- 28096 3
- 28249 3
- 28422 3
- 28623 3
- 1296 2
- 10955 2
- 10961 2
- 10964 2
- 27479 2
- 4 1
- 8 1
- 10 1
- 17 1
- 21 1
- 28 1
- 33 1
- 40 1
- 56 1
- 69 1
- 90 1
- 95 1
- 111 1
- 129 1
- 136 1
- 164 1
- 180 1
- 220 1
- 235 1
- 253 1
- 274 1
- 292 1
- 310 1
- 327 1
- 337 1
- 347 1
- 370 1
- 393 1
- 402 1
- 428 1
- 443 1
- 460 1
- 484 1
- 505 1
- 530 1
- 540 1
- 552 1
- 565 1
- 613 1
- 624 1
- 640 1
- 654 1
- 663 1
- 673 1
- 701 1
- 719 1
- 730 1
- 749 1
- 757 1
- 762 1
- 779 1
- 798 1
- 831 1
- 846 1
- 861 1
- 869 1
- 896 1
- 922 1
- 944 1
- 958 1
- 971 1
- 991 1
- 999 1
- 1003 1
- 1009 1
- 1028 1
- 1057 1
- 1086 1
- 1109 1
- 1121 1
- 1134 1
- 1153 1
- 1176 1
- 1187 1
- 1198 1
- 1204 1
- 1213 1
- 1218 1
- 1233 1
- 1237 1
- 1250 1
- 1266 1
- 1271 1
- 1274 1
- 1279 1
- 1293 1
- 1306 1
- 1315 1
- 1330 1
- 1335 1
- 1343 1
- 1352 1
- 1359 1
- 1364 1
- 1373 1
- 1385 1
- 1395 1
- 1401 1
- 1418 1
- 1428 1
- 1432 1
- 1439 1
- 1443 1
- 1453 1
- 1475 1
- 1485 1
- 1498 1
- 1504 1
- 1519 1
- 1530 1
- 1536 1
- 1554 1
- 1569 1
- 1585 1
- 1595 1
- 1611 1
- 1621 1
- 1644 1
- 1661 1
- 1681 1
- 1697 1
- 1721 1
- 1732 1
- 1755 1
- 1774 1
- 1798 1
- 1821 1
- 1834 1
- 1857 1
- 1880 1
- 1911 1
- 1934 1
- 1949 1
- 1963 1
- 1985 1
- 2002 1
- 2026 1
- 2042 1
- 2069 1
- 2086 1
- 2104 1
- 2121 1
- 2154 1
- 2167 1
- 2177 1
- 2200 1
- 2215 1
- 2226 1
- 2236 1
- 2252 1
- 2262 1
- 2280 1
- 2308 1
- 2321 1
- 2333 1
- 2348 1
- 2368 1
- 2384 1
- 2396 1
- 2405 1
- 2413 1
- 2426 1
- 2441 1
- 2452 1
- 2466 1
- 2487 1
- 2496 1
- 2505 1
- 2519 1
- 2538 1
- 2556 1
- 2572 1
- 2593 1
- 2609 1
- 2630 1
- 2648 1
- 2666 1
- 2688 1
- 2696 1
- 2705 1
- 2718 1
- 2727 1
- 2739 1
- 2747 1
- 2755 1
- 2761 1
- 2772 1
- 2781 1
- 2800 1
- 2821 1
- 2831 1
- 2843 1
- 2853 1
- 2862 1
- 2871 1
- 2880 1
- 2890 1
- 2906 1
- 2924 1
- 2937 1
- 2944 1
- 2949 1
- 2964 1
- 2985 1
- 2993 1
- 3009 1
- 3020 1
- 3031 1
- 3043 1
- 3052 1
- 3069 1
- 3080 1
- 3092 1
- 3115 1
- 3138 1
- 3156 1
- 3170 1
- 3189 1
- 3210 1
- 3228 1
- 3249 1
- 3265 1
- 3275 1
- 3301 1
- 3326 1
- 3379 1
- 3421 1
- 3445 1
- 3486 1
- 3518 1
- 3555 1
- 3594 1
- 3618 1
- 3672 1
- 3719 1
- 3740 1
- 3792 1
- 3833 1
- 3882 1
- 3940 1
- 3992 1
- 4027 1
- 4067 1
- 4106 1
- 4160 1
- 4186 1
- 4256 1
- 4278 1
- 4319 1
- 4393 1
- 4436 1
- 4504 1
- 4524 1
- 4595 1
- 4668 1
- 4719 1
- 4754 1
- 4805 1
- 4887 1
- 4946 1
- 4995 1
- 5071 1
- 5143 1
- 5184 1
- 5235 1
- 5290 1
- 5323 1
- 5384 1
- 5446 1
- 5493 1
- 5536 1
- 5593 1
- 5665 1
- 5718 1
- 5769 1
- 5810 1
- 5854 1
- 5893 1
- 5923 1
- 5988 1
- 6037 1
- 6117 1
- 6181 1
- 6230 1
- 6289 1
- 6329 1
- 6397 1
- 6472 1
- 6535 1
- 6625 1
- 6696 1
- 6772 1
- 6819 1
- 6891 1
- 6958 1
- 7023 1
- 7122 1
- 7207 1
- 7265 1
- 7304 1
- 7350 1
- 7413 1
- 7471 1
- 7552 1
- 7610 1
- 7668 1
- 7720 1
- 7787 1
- 7834 1
- 7910 1
- 7966 1
- 8023 1
- 8061 1
- 8088 1
- 8128 1
- 8186 1
- 8234 1
- 8284 1
- 8330 1
- 8359 1
- 8390 1
- 8429 1
- 8466 1
- 8498 1
- 8528 1
- 8555 1
- 8580 1
- 8599 1
- 8628 1
- 8658 1
- 8688 1
- 8716 1
- 8735 1
- 8753 1
- 8773 1
- 8803 1
- 8832 1
- 8866 1
- 8887 1
- 8901 1
- 8923 1
- 8931 1
- 8965 1
- 8996 1
- 9035 1
- 9059 1
- 9076 1
- 9106 1
- 9118 1
- 9134 1
- 9160 1
- 9201 1
- 9227 1
- 9255 1
- 9277 1
- 9298 1
- 9336 1
- 9359 1
- 9393 1
- 9430 1
- 9453 1
- 9467 1
- 9486 1
- 9533 1
- 9558 1
- 9598 1
- 9622 1
- 9650 1
- 9678 1
- 9697 1
- 9726 1
- 9766 1
- 9805 1
- 9828 1
- 9874 1
- 9897 1
- 9908 1
- 9939 1
- 9967 1
- 10012 1
- 10044 1
- 10081 1
- 10096 1
- 10127 1
- 10152 1
- 10186 1
- 10216 1
- 10243 1
- 10271 1
- 10286 1
- 10298 1
- 10330 1
- 10361 1
- 10379 1
- 10409 1
- 10425 1
- 10437 1
- 10457 1
- 10475 1
- 10500 1
- 10526 1
- 10548 1
- 10569 1
- 10580 1
- 10595 1
- 10611 1
- 10628 1
- 10644 1
- 10658 1
- 10663 1
- 10671 1
- 10679 1
- 10687 1
- 10700 1
- 10715 1
- 10722 1
- 10731 1
- 10735 1
- 10741 1
- 10748 1
- 10750 1
- 10759 1
- 10769 1
- 10782 1
- 10804 1
- 10812 1
- 10822 1
- 10833 1
- 10847 1
- 10856 1
- 10858 1
- 10863 1
- 10867 1
- 10872 1
- 10883 1
- 10889 1
- 10891 1
- 10893 1
- 10894 1
- 10900 1
- 10901 1
- 10908 1
- 10918 1
- 10927 1
- 10931 1
- 10935 1
- 10938 1
- 10940 1
- 10942 1
- 10948 1
- 10953 1
- 10957 1
- 10959 1
- 10960 1
- 10965 1
- 10968 1
- 10970 1
- 10972 1
- 10975 1
- 10977 1
- 10978 1
- 10980 1
- 10982 1
- 10983 1
- 10986 1
- 10990 1
- 10991 1
- 10994 1
- 11000 1
- 11006 1
- 11007 1
- 11017 1
- 11022 1
- 11026 1
- 11036 1
- 11042 1
- 11047 1
- 11061 1
- 11068 1
- 11079 1
- 11090 1
- 11102 1
- 11112 1
- 11122 1
- 11148 1
- 11163 1
- 11192 1
- 11213 1
- 11233 1
- 11246 1
- 11275 1
- 11293 1
- 11341 1
- 11388 1
- 11434 1
- 11451 1
- 11481 1
- 11512 1
- 11565 1
- 11623 1
- 11649 1
- 11682 1
- 11722 1
- 11769 1
- 11808 1
- 11847 1
- 11903 1
- 11948 1
- 11977 1
- 12025 1
- 12055 1
- 12102 1
- 12159 1
- 12225 1
- 12283 1
- 12334 1
- 12383 1
- 12447 1
- 12516 1
- 12544 1
- 12611 1
- 12666 1
- 12697 1
- 12731 1
- 12774 1
- 12806 1
- 12826 1
- 12897 1
- 12953 1
- 12999 1
- 13044 1
- 13084 1
- 13125 1
- 13194 1
- 13243 1
- 13284 1
- 13327 1
- 13368 1
- 13402 1
- 13437 1
- 13473 1
- 13524 1
- 13561 1
- 13583 1
- 13614 1
- 13637 1
- 13672 1
- 13724 1
- 13788 1
- 13828 1
- 13864 1
- 13886 1
- 13910 1
- 13945 1
- 13985 1
- 14009 1
- 14039 1
- 14087 1
- 14101 1
- 14112 1
- 14140 1
- 14159 1
- 14188 1
- 14223 1
- 14246 1
- 14275 1
- 14289 1
- 14310 1
- 14338 1
- 14365 1
- 14400 1
- 14420 1
- 14436 1
- 14449 1
- 14460 1
- 14483 1
- 14506 1
- 14522 1
- 14533 1
- 14545 1
- 14552 1
- 14571 1
- 14584 1
- 14599 1
- 14617 1
- 14635 1
- 14648 1
- 14657 1
- 14675 1
- 14696 1
- 14703 1
- 14717 1
- 14723 1
- 14733 1
- 14737 1
- 14747 1
- 14762 1
- 14783 1
- 14802 1
- 14820 1
- 14842 1
- 14854 1
- 14919 1
- 14929 1
- 14940 1
- 14964 1
- 14979 1
- 15007 1
- 15030 1
- 17890 1
- 18072 1
- 19911 1
- 20439 1
- 20801 1
- 21032 1
- 21328 1
- 21507 1
- 21969 1
- 22404 1
- 22627 1
- 22860 1
- 23240 1
- 23561 1
- 23817 1
- 24058 1
- 24380 1
- 24537 1
- 24676 1
- 24859 1
- 25161 1
- 25345 1
- 25546 1
- 25626 1
- 25697 1
- 25799 1
- 25886 1
- 25983 1
- 26079 1
- 26147 1
- 26203 1
- 26250 1
- 26316 1
- 26354 1
- 26408 1
- 26465 1
- 26520 1
- 26537 1
- 26556 1
- 26581 1
- 26594 1
- 26652 1
- 26728 1
- 26763 1
- 26777 1
- 26803 1
- 26818 1
- 27396 1
- 27416 1
- 27444 1
- 27472 1
- 27506 1
- 27514 1
- 27525 1
- 27534 1
- 27560 1
- 27571 1
- 27579 1
- 27590 1
- 27601 1
- 27612 1
- 27619 1
- 27633 1
- 27645 1
- 27653 1
- 27658 1
- 27669 1
- 27684 1
- 27696 1
- 27704 1
- 27706 1
- 27720 1
- 27724 1
- 27727 1
- 27732 1
- 27752 1
- 27765 1
- 27775 1
- 27780 1
- 27781 1
- 27786 1
- 27795 1
- 27804 1
- 27813 1
- 27822 1
- 27836 1
- 27839 1
- 27846 1
- 27855 1
- 27900 1
- 27904 1
- 27927 1
- 27943 1
- 28002 1
- 28026 1
- 28036 1
- 28070 1
- 28115 1
- 28194 1
- 28207 1
- 28233 1
- 28270 1
- 28331 1
- 28341 1
- 28368 1
- 28460 1
- 28522 1
- 28545 1
- 28579 1
- 28658 1
- 28769 1
- 28808 1
- 28860 1
- 28950 1
state 1
- Maryland 792
fips 1
- 24017 792
county 1
- Charles · 792 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1747 | 1747 | 2020-03-13 | Charles | Maryland | 24017 | 1 | 0 |
2088 | 2088 | 2020-03-14 | Charles | Maryland | 24017 | 1 | 0 |
2488 | 2488 | 2020-03-15 | Charles | Maryland | 24017 | 1 | 0 |
2935 | 2935 | 2020-03-16 | Charles | Maryland | 24017 | 1 | 0 |
3436 | 3436 | 2020-03-17 | Charles | Maryland | 24017 | 1 | 0 |
4018 | 4018 | 2020-03-18 | Charles | Maryland | 24017 | 2 | 0 |
4721 | 4721 | 2020-03-19 | Charles | Maryland | 24017 | 2 | 0 |
5539 | 5539 | 2020-03-20 | Charles | Maryland | 24017 | 2 | 0 |
6496 | 6496 | 2020-03-21 | Charles | Maryland | 24017 | 4 | 0 |
7572 | 7572 | 2020-03-22 | Charles | Maryland | 24017 | 5 | 0 |
8742 | 8742 | 2020-03-23 | Charles | Maryland | 24017 | 5 | 0 |
10031 | 10031 | 2020-03-24 | Charles | Maryland | 24017 | 5 | 0 |
11441 | 11441 | 2020-03-25 | Charles | Maryland | 24017 | 8 | 0 |
13022 | 13022 | 2020-03-26 | Charles | Maryland | 24017 | 10 | 0 |
14730 | 14730 | 2020-03-27 | Charles | Maryland | 24017 | 17 | 0 |
16550 | 16550 | 2020-03-28 | Charles | Maryland | 24017 | 21 | 1 |
18465 | 18465 | 2020-03-29 | Charles | Maryland | 24017 | 28 | 1 |
20481 | 20481 | 2020-03-30 | Charles | Maryland | 24017 | 33 | 1 |
22590 | 22590 | 2020-03-31 | Charles | Maryland | 24017 | 40 | 1 |
24767 | 24767 | 2020-04-01 | Charles | Maryland | 24017 | 56 | 1 |
27019 | 27019 | 2020-04-02 | Charles | Maryland | 24017 | 69 | 1 |
29338 | 29338 | 2020-04-03 | Charles | Maryland | 24017 | 90 | 1 |
31716 | 31716 | 2020-04-04 | Charles | Maryland | 24017 | 95 | 1 |
34141 | 34141 | 2020-04-05 | Charles | Maryland | 24017 | 111 | 2 |
36600 | 36600 | 2020-04-06 | Charles | Maryland | 24017 | 129 | 2 |
39108 | 39108 | 2020-04-07 | Charles | Maryland | 24017 | 136 | 2 |
41660 | 41660 | 2020-04-08 | Charles | Maryland | 24017 | 164 | 2 |
44236 | 44236 | 2020-04-09 | Charles | Maryland | 24017 | 180 | 3 |
46844 | 46844 | 2020-04-10 | Charles | Maryland | 24017 | 220 | 4 |
49486 | 49486 | 2020-04-11 | Charles | Maryland | 24017 | 235 | 5 |
52156 | 52156 | 2020-04-12 | Charles | Maryland | 24017 | 253 | 9 |
54837 | 54837 | 2020-04-13 | Charles | Maryland | 24017 | 274 | 10 |
57535 | 57535 | 2020-04-14 | Charles | Maryland | 24017 | 292 | 12 |
60243 | 60243 | 2020-04-15 | Charles | Maryland | 24017 | 310 | 11 |
62964 | 62964 | 2020-04-16 | Charles | Maryland | 24017 | 327 | 13 |
65702 | 65702 | 2020-04-17 | Charles | Maryland | 24017 | 337 | 15 |
68452 | 68452 | 2020-04-18 | Charles | Maryland | 24017 | 347 | 16 |
71216 | 71216 | 2020-04-19 | Charles | Maryland | 24017 | 370 | 17 |
73988 | 73988 | 2020-04-20 | Charles | Maryland | 24017 | 393 | 20 |
76768 | 76768 | 2020-04-21 | Charles | Maryland | 24017 | 402 | 23 |
79554 | 79554 | 2020-04-22 | Charles | Maryland | 24017 | 428 | 30 |
82349 | 82349 | 2020-04-23 | Charles | Maryland | 24017 | 443 | 32 |
85153 | 85153 | 2020-04-24 | Charles | Maryland | 24017 | 460 | 34 |
87963 | 87963 | 2020-04-25 | Charles | Maryland | 24017 | 484 | 35 |
90779 | 90779 | 2020-04-26 | Charles | Maryland | 24017 | 505 | 35 |
93600 | 93600 | 2020-04-27 | Charles | Maryland | 24017 | 530 | 37 |
96435 | 96435 | 2020-04-28 | Charles | Maryland | 24017 | 540 | 39 |
99281 | 99281 | 2020-04-29 | Charles | Maryland | 24017 | 552 | 42 |
102133 | 102133 | 2020-04-30 | Charles | Maryland | 24017 | 565 | 44 |
104993 | 104993 | 2020-05-01 | Charles | Maryland | 24017 | 613 | 46 |
107857 | 107857 | 2020-05-02 | Charles | Maryland | 24017 | 624 | 47 |
110729 | 110729 | 2020-05-03 | Charles | Maryland | 24017 | 640 | 50 |
113607 | 113607 | 2020-05-04 | Charles | Maryland | 24017 | 654 | 50 |
116488 | 116488 | 2020-05-05 | Charles | Maryland | 24017 | 663 | 50 |
119449 | 119449 | 2020-05-06 | Charles | Maryland | 24017 | 673 | 52 |
122421 | 122421 | 2020-05-07 | Charles | Maryland | 24017 | 701 | 51 |
125403 | 125403 | 2020-05-08 | Charles | Maryland | 24017 | 719 | 54 |
128390 | 128390 | 2020-05-09 | Charles | Maryland | 24017 | 730 | 53 |
131380 | 131380 | 2020-05-10 | Charles | Maryland | 24017 | 749 | 54 |
134371 | 134371 | 2020-05-11 | Charles | Maryland | 24017 | 757 | 54 |
137361 | 137361 | 2020-05-12 | Charles | Maryland | 24017 | 762 | 55 |
140355 | 140355 | 2020-05-13 | Charles | Maryland | 24017 | 779 | 57 |
143350 | 143350 | 2020-05-14 | Charles | Maryland | 24017 | 798 | 59 |
146350 | 146350 | 2020-05-15 | Charles | Maryland | 24017 | 831 | 61 |
149355 | 149355 | 2020-05-16 | Charles | Maryland | 24017 | 846 | 62 |
152366 | 152366 | 2020-05-17 | Charles | Maryland | 24017 | 861 | 62 |
155380 | 155380 | 2020-05-18 | Charles | Maryland | 24017 | 869 | 62 |
158398 | 158398 | 2020-05-19 | Charles | Maryland | 24017 | 896 | 63 |
161424 | 161424 | 2020-05-20 | Charles | Maryland | 24017 | 922 | 64 |
164453 | 164453 | 2020-05-21 | Charles | Maryland | 24017 | 944 | 65 |
167489 | 167489 | 2020-05-22 | Charles | Maryland | 24017 | 958 | 67 |
170526 | 170526 | 2020-05-23 | Charles | Maryland | 24017 | 971 | 69 |
173568 | 173568 | 2020-05-24 | Charles | Maryland | 24017 | 991 | 69 |
176611 | 176611 | 2020-05-25 | Charles | Maryland | 24017 | 999 | 69 |
179655 | 179655 | 2020-05-26 | Charles | Maryland | 24017 | 1003 | 70 |
182701 | 182701 | 2020-05-27 | Charles | Maryland | 24017 | 1009 | 71 |
185756 | 185756 | 2020-05-28 | Charles | Maryland | 24017 | 1028 | 72 |
188814 | 188814 | 2020-05-29 | Charles | Maryland | 24017 | 1057 | 72 |
191878 | 191878 | 2020-05-30 | Charles | Maryland | 24017 | 1086 | 72 |
194946 | 194946 | 2020-05-31 | Charles | Maryland | 24017 | 1109 | 72 |
198017 | 198017 | 2020-06-01 | Charles | Maryland | 24017 | 1121 | 73 |
201089 | 201089 | 2020-06-02 | Charles | Maryland | 24017 | 1134 | 73 |
204166 | 204166 | 2020-06-03 | Charles | Maryland | 24017 | 1153 | 75 |
207247 | 207247 | 2020-06-04 | Charles | Maryland | 24017 | 1176 | 79 |
210328 | 210328 | 2020-06-05 | Charles | Maryland | 24017 | 1187 | 79 |
213412 | 213412 | 2020-06-06 | Charles | Maryland | 24017 | 1198 | 81 |
216500 | 216500 | 2020-06-07 | Charles | Maryland | 24017 | 1204 | 80 |
219592 | 219592 | 2020-06-08 | Charles | Maryland | 24017 | 1213 | 80 |
222687 | 222687 | 2020-06-09 | Charles | Maryland | 24017 | 1218 | 82 |
225783 | 225783 | 2020-06-10 | Charles | Maryland | 24017 | 1233 | 83 |
228885 | 228885 | 2020-06-11 | Charles | Maryland | 24017 | 1237 | 83 |
231989 | 231989 | 2020-06-12 | Charles | Maryland | 24017 | 1250 | 82 |
235094 | 235094 | 2020-06-13 | Charles | Maryland | 24017 | 1266 | 83 |
238201 | 238201 | 2020-06-14 | Charles | Maryland | 24017 | 1271 | 83 |
241310 | 241310 | 2020-06-15 | Charles | Maryland | 24017 | 1274 | 83 |
244421 | 244421 | 2020-06-16 | Charles | Maryland | 24017 | 1279 | 83 |
247534 | 247534 | 2020-06-17 | Charles | Maryland | 24017 | 1293 | 85 |
250646 | 250646 | 2020-06-18 | Charles | Maryland | 24017 | 1296 | 86 |
253761 | 253761 | 2020-06-19 | Charles | Maryland | 24017 | 1296 | 86 |
256881 | 256881 | 2020-06-20 | Charles | Maryland | 24017 | 1306 | 86 |
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);