ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Guilford" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 332 ✖
- 726 19
- 1159 16
- 0 13
- 738 13
- 721 11
- 778 10
- 1208 10
- 176 8
- 191 8
- 722 8
- 936 8
- 170 7
- 700 7
- 986 7
- 1157 7
- 1163 7
- 1169 7
- 174 6
- 711 6
- 925 6
- 929 6
- 932 6
- 947 6
- 156 5
- 158 5
- 163 5
- 171 5
- 215 5
- 239 5
- 617 5
- 673 5
- 707 5
- 720 5
- 845 5
- 916 5
- 10 4
- 38 4
- 65 4
- 106 4
- 112 4
- 133 4
- 139 4
- 180 4
- 187 4
- 205 4
- 216 4
- 230 4
- 259 4
- 276 4
- 308 4
- 318 4
- 537 4
- 714 4
- 731 4
- 749 4
- 827 4
- 833 4
- 901 4
- 950 4
- 964 4
- 1012 4
- 1108 4
- 1 3
- 4 3
- 9 3
- 13 3
- 23 3
- 31 3
- 47 3
- 52 3
- 94 3
- 117 3
- 147 3
- 160 3
- 210 3
- 218 3
- 293 3
- 303 3
- 350 3
- 377 3
- 454 3
- 552 3
- 564 3
- 603 3
- 622 3
- 627 3
- 647 3
- 693 3
- 701 3
- 719 3
- 734 3
- 760 3
- 806 3
- 857 3
- 868 3
- 871 3
- 892 3
- 913 3
- 983 3
- 1032 3
- 1068 3
- 1093 3
- 1096 3
- 1129 3
- 1144 3
- 1156 3
- 8 2
- 14 2
- 19 2
- 35 2
- 49 2
- 50 2
- 75 2
- 78 2
- 101 2
- 118 2
- 119 2
- 123 2
- 125 2
- 135 2
- 142 2
- 153 2
- 179 2
- 185 2
- 192 2
- 193 2
- 209 2
- 233 2
- 272 2
- 312 2
- 359 2
- 360 2
- 401 2
- 414 2
- 504 2
- 551 2
- 553 2
- 558 2
- 559 2
- 567 2
- 584 2
- 611 2
- 698 2
- 703 2
- 708 2
- 715 2
- 717 2
- 757 2
- 772 2
- 822 2
- 838 2
- 860 2
- 862 2
- 869 2
- 870 2
- 889 2
- 894 2
- 896 2
- 910 2
- 937 2
- 955 2
- 975 2
- 994 2
- 1132 2
- 1149 2
- 3 1
- 5 1
- 12 1
- 15 1
- 16 1
- 26 1
- 30 1
- 33 1
- 42 1
- 44 1
- 45 1
- 46 1
- 53 1
- 54 1
- 56 1
- 70 1
- 71 1
- 81 1
- 87 1
- 91 1
- 93 1
- 95 1
- 99 1
- 105 1
- 110 1
- 111 1
- 114 1
- 115 1
- 121 1
- 128 1
- 129 1
- 131 1
- 134 1
- 136 1
- 140 1
- 150 1
- 154 1
- 166 1
- 168 1
- 181 1
- 188 1
- 190 1
- 195 1
- 196 1
- 200 1
- 202 1
- 208 1
- 211 1
- 213 1
- 214 1
- 222 1
- 225 1
- 227 1
- 246 1
- 256 1
- 267 1
- 277 1
- 282 1
- 290 1
- 291 1
- 294 1
- 311 1
- 320 1
- 326 1
- 332 1
- 337 1
- 341 1
- 342 1
- 344 1
- 357 1
- 365 1
- 366 1
- 373 1
- 384 1
- 390 1
- 415 1
- 425 1
- 438 1
- 440 1
- 453 1
- 464 1
- 474 1
- 489 1
- 501 1
- 517 1
- 526 1
- 534 1
- 539 1
- 554 1
- 555 1
- 557 1
- 561 1
- 563 1
- 571 1
- 572 1
- 582 1
- 589 1
- 592 1
- 600 1
- 601 1
- 621 1
- 630 1
- 632 1
- 634 1
- 640 1
- 655 1
- 656 1
- 666 1
- 668 1
- 677 1
- 680 1
- 695 1
- 696 1
- 709 1
- 713 1
- 724 1
- 729 1
- 745 1
- 751 1
- 752 1
- 771 1
- 775 1
- 784 1
- 789 1
- 790 1
- 800 1
- 814 1
- 815 1
- 828 1
- 834 1
- 840 1
- 842 1
- 854 1
- 855 1
- 880 1
- 885 1
- 904 1
- 914 1
- 915 1
- 920 1
- 923 1
- 924 1
- 943 1
- 957 1
- 962 1
- 980 1
- 998 1
- 1004 1
- 1013 1
- 1025 1
- 1026 1
- 1046 1
- 1048 1
- 1054 1
- 1060 1
- 1071 1
- 1073 1
- 1081 1
- 1092 1
- 1102 1
- 1109 1
- 1115 1
- 1120 1
- 1133 1
- 1134 1
- 1153 1
- 1154 1
state 1
- North Carolina 787
fips 1
- 37081 787
county 1
- Guilford · 787 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4176 | 4176 | 2020-03-18 | Guilford | North Carolina | 37081 | 1 | 0 |
4907 | 4907 | 2020-03-19 | Guilford | North Carolina | 37081 | 2 | 0 |
5761 | 5761 | 2020-03-20 | Guilford | North Carolina | 37081 | 4 | 0 |
6758 | 6758 | 2020-03-21 | Guilford | North Carolina | 37081 | 4 | 0 |
7858 | 7858 | 2020-03-22 | Guilford | North Carolina | 37081 | 11 | 0 |
9059 | 9059 | 2020-03-23 | Guilford | North Carolina | 37081 | 11 | 0 |
10367 | 10367 | 2020-03-24 | Guilford | North Carolina | 37081 | 16 | 0 |
11808 | 11808 | 2020-03-25 | Guilford | North Carolina | 37081 | 22 | 0 |
13412 | 13412 | 2020-03-26 | Guilford | North Carolina | 37081 | 24 | 0 |
15147 | 15147 | 2020-03-27 | Guilford | North Carolina | 37081 | 31 | 0 |
16979 | 16979 | 2020-03-28 | Guilford | North Carolina | 37081 | 34 | 0 |
18909 | 18909 | 2020-03-29 | Guilford | North Carolina | 37081 | 39 | 0 |
20949 | 20949 | 2020-03-30 | Guilford | North Carolina | 37081 | 44 | 0 |
23075 | 23075 | 2020-03-31 | Guilford | North Carolina | 37081 | 52 | 1 |
25269 | 25269 | 2020-04-01 | Guilford | North Carolina | 37081 | 55 | 1 |
27532 | 27532 | 2020-04-02 | Guilford | North Carolina | 37081 | 71 | 1 |
29858 | 29858 | 2020-04-03 | Guilford | North Carolina | 37081 | 79 | 3 |
32245 | 32245 | 2020-04-04 | Guilford | North Carolina | 37081 | 94 | 4 |
34676 | 34676 | 2020-04-05 | Guilford | North Carolina | 37081 | 96 | 4 |
37145 | 37145 | 2020-04-06 | Guilford | North Carolina | 37081 | 104 | 4 |
39660 | 39660 | 2020-04-07 | Guilford | North Carolina | 37081 | 119 | 5 |
42217 | 42217 | 2020-04-08 | Guilford | North Carolina | 37081 | 122 | 8 |
44800 | 44800 | 2020-04-09 | Guilford | North Carolina | 37081 | 125 | 8 |
47413 | 47413 | 2020-04-10 | Guilford | North Carolina | 37081 | 127 | 9 |
50068 | 50068 | 2020-04-11 | Guilford | North Carolina | 37081 | 134 | 9 |
52741 | 52741 | 2020-04-12 | Guilford | North Carolina | 37081 | 135 | 9 |
55424 | 55424 | 2020-04-13 | Guilford | North Carolina | 37081 | 138 | 10 |
58124 | 58124 | 2020-04-14 | Guilford | North Carolina | 37081 | 137 | 10 |
60838 | 60838 | 2020-04-15 | Guilford | North Carolina | 37081 | 149 | 10 |
63564 | 63564 | 2020-04-16 | Guilford | North Carolina | 37081 | 154 | 10 |
66307 | 66307 | 2020-04-17 | Guilford | North Carolina | 37081 | 162 | 12 |
69064 | 69064 | 2020-04-18 | Guilford | North Carolina | 37081 | 168 | 13 |
71830 | 71830 | 2020-04-19 | Guilford | North Carolina | 37081 | 172 | 13 |
74605 | 74605 | 2020-04-20 | Guilford | North Carolina | 37081 | 175 | 13 |
77386 | 77386 | 2020-04-21 | Guilford | North Carolina | 37081 | 190 | 14 |
80175 | 80175 | 2020-04-22 | Guilford | North Carolina | 37081 | 226 | 14 |
82974 | 82974 | 2020-04-23 | Guilford | North Carolina | 37081 | 240 | 15 |
85778 | 85778 | 2020-04-24 | Guilford | North Carolina | 37081 | 272 | 16 |
88590 | 88590 | 2020-04-25 | Guilford | North Carolina | 37081 | 293 | 19 |
91405 | 91405 | 2020-04-26 | Guilford | North Carolina | 37081 | 299 | 19 |
94231 | 94231 | 2020-04-27 | Guilford | North Carolina | 37081 | 301 | 23 |
97068 | 97068 | 2020-04-28 | Guilford | North Carolina | 37081 | 318 | 23 |
99915 | 99915 | 2020-04-29 | Guilford | North Carolina | 37081 | 357 | 23 |
102768 | 102768 | 2020-04-30 | Guilford | North Carolina | 37081 | 381 | 26 |
105630 | 105630 | 2020-05-01 | Guilford | North Carolina | 37081 | 415 | 30 |
108497 | 108497 | 2020-05-02 | Guilford | North Carolina | 37081 | 437 | 31 |
111370 | 111370 | 2020-05-03 | Guilford | North Carolina | 37081 | 439 | 31 |
114251 | 114251 | 2020-05-04 | Guilford | North Carolina | 37081 | 443 | 31 |
117131 | 117131 | 2020-05-05 | Guilford | North Carolina | 37081 | 464 | 33 |
120092 | 120092 | 2020-05-06 | Guilford | North Carolina | 37081 | 507 | 35 |
123067 | 123067 | 2020-05-07 | Guilford | North Carolina | 37081 | 536 | 35 |
126050 | 126050 | 2020-05-08 | Guilford | North Carolina | 37081 | 553 | 38 |
129039 | 129039 | 2020-05-09 | Guilford | North Carolina | 37081 | 574 | 38 |
132028 | 132028 | 2020-05-10 | Guilford | North Carolina | 37081 | 592 | 38 |
135019 | 135019 | 2020-05-11 | Guilford | North Carolina | 37081 | 609 | 38 |
138009 | 138009 | 2020-05-12 | Guilford | North Carolina | 37081 | 626 | 42 |
141005 | 141005 | 2020-05-13 | Guilford | North Carolina | 37081 | 670 | 44 |
144000 | 144000 | 2020-05-14 | Guilford | North Carolina | 37081 | 705 | 45 |
147001 | 147001 | 2020-05-15 | Guilford | North Carolina | 37081 | 725 | 46 |
150008 | 150008 | 2020-05-16 | Guilford | North Carolina | 37081 | 776 | 47 |
153018 | 153018 | 2020-05-17 | Guilford | North Carolina | 37081 | 846 | 47 |
156035 | 156035 | 2020-05-18 | Guilford | North Carolina | 37081 | 872 | 47 |
159054 | 159054 | 2020-05-19 | Guilford | North Carolina | 37081 | 904 | 49 |
162081 | 162081 | 2020-05-20 | Guilford | North Carolina | 37081 | 931 | 49 |
165110 | 165110 | 2020-05-21 | Guilford | North Carolina | 37081 | 962 | 50 |
168145 | 168145 | 2020-05-22 | Guilford | North Carolina | 37081 | 977 | 50 |
171184 | 171184 | 2020-05-23 | Guilford | North Carolina | 37081 | 1033 | 52 |
174226 | 174226 | 2020-05-24 | Guilford | North Carolina | 37081 | 1049 | 52 |
177270 | 177270 | 2020-05-25 | Guilford | North Carolina | 37081 | 1073 | 52 |
180313 | 180313 | 2020-05-26 | Guilford | North Carolina | 37081 | 1092 | 53 |
183361 | 183361 | 2020-05-27 | Guilford | North Carolina | 37081 | 1143 | 54 |
186418 | 186418 | 2020-05-28 | Guilford | North Carolina | 37081 | 1173 | 56 |
189478 | 189478 | 2020-05-29 | Guilford | North Carolina | 37081 | 1195 | 65 |
192542 | 192542 | 2020-05-30 | Guilford | North Carolina | 37081 | 1227 | 65 |
195612 | 195612 | 2020-05-31 | Guilford | North Carolina | 37081 | 1264 | 65 |
198685 | 198685 | 2020-06-01 | Guilford | North Carolina | 37081 | 1288 | 65 |
201759 | 201759 | 2020-06-02 | Guilford | North Carolina | 37081 | 1352 | 70 |
204836 | 204836 | 2020-06-03 | Guilford | North Carolina | 37081 | 1415 | 71 |
207917 | 207917 | 2020-06-04 | Guilford | North Carolina | 37081 | 1498 | 75 |
210999 | 210999 | 2020-06-05 | Guilford | North Carolina | 37081 | 1574 | 75 |
214083 | 214083 | 2020-06-06 | Guilford | North Carolina | 37081 | 1574 | 78 |
217173 | 217173 | 2020-06-07 | Guilford | North Carolina | 37081 | 1614 | 78 |
220265 | 220265 | 2020-06-08 | Guilford | North Carolina | 37081 | 1671 | 81 |
223359 | 223359 | 2020-06-09 | Guilford | North Carolina | 37081 | 1779 | 87 |
226459 | 226459 | 2020-06-10 | Guilford | North Carolina | 37081 | 1853 | 91 |
229563 | 229563 | 2020-06-11 | Guilford | North Carolina | 37081 | 1891 | 93 |
232668 | 232668 | 2020-06-12 | Guilford | North Carolina | 37081 | 1941 | 94 |
235773 | 235773 | 2020-06-13 | Guilford | North Carolina | 37081 | 1983 | 94 |
238881 | 238881 | 2020-06-14 | Guilford | North Carolina | 37081 | 2032 | 94 |
241990 | 241990 | 2020-06-15 | Guilford | North Carolina | 37081 | 2061 | 95 |
245102 | 245102 | 2020-06-16 | Guilford | North Carolina | 37081 | 2148 | 99 |
248215 | 248215 | 2020-06-17 | Guilford | North Carolina | 37081 | 2194 | 101 |
251330 | 251330 | 2020-06-18 | Guilford | North Carolina | 37081 | 2244 | 101 |
254445 | 254445 | 2020-06-19 | Guilford | North Carolina | 37081 | 2320 | 105 |
257568 | 257568 | 2020-06-20 | Guilford | North Carolina | 37081 | 2352 | 106 |
260695 | 260695 | 2020-06-21 | Guilford | North Carolina | 37081 | 2402 | 106 |
263823 | 263823 | 2020-06-22 | Guilford | North Carolina | 37081 | 2434 | 106 |
266951 | 266951 | 2020-06-23 | Guilford | North Carolina | 37081 | 2482 | 106 |
270085 | 270085 | 2020-06-24 | Guilford | North Carolina | 37081 | 2527 | 110 |
273224 | 273224 | 2020-06-25 | Guilford | North Carolina | 37081 | 2586 | 111 |
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);