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 date descending
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 |
---|---|---|---|---|---|---|---|
2501526 | 2501526 | 2022-05-13 | Guilford | North Carolina | 37081 | 121303 | 1208 |
2498268 | 2498268 | 2022-05-12 | Guilford | North Carolina | 37081 | 121303 | 1208 |
2495010 | 2495010 | 2022-05-11 | Guilford | North Carolina | 37081 | 121303 | 1208 |
2491752 | 2491752 | 2022-05-10 | Guilford | North Carolina | 37081 | 120035 | 1208 |
2488494 | 2488494 | 2022-05-09 | Guilford | North Carolina | 37081 | 120035 | 1208 |
2485237 | 2485237 | 2022-05-08 | Guilford | North Carolina | 37081 | 120035 | 1208 |
2481979 | 2481979 | 2022-05-07 | Guilford | North Carolina | 37081 | 120035 | 1208 |
2478721 | 2478721 | 2022-05-06 | Guilford | North Carolina | 37081 | 120035 | 1208 |
2475463 | 2475463 | 2022-05-05 | Guilford | North Carolina | 37081 | 120035 | 1208 |
2472206 | 2472206 | 2022-05-04 | Guilford | North Carolina | 37081 | 120035 | 1208 |
2468950 | 2468950 | 2022-05-03 | Guilford | North Carolina | 37081 | 118963 | 1169 |
2465694 | 2465694 | 2022-05-02 | Guilford | North Carolina | 37081 | 118963 | 1169 |
2462439 | 2462439 | 2022-05-01 | Guilford | North Carolina | 37081 | 118963 | 1169 |
2459183 | 2459183 | 2022-04-30 | Guilford | North Carolina | 37081 | 118963 | 1169 |
2455927 | 2455927 | 2022-04-29 | Guilford | North Carolina | 37081 | 118963 | 1169 |
2452671 | 2452671 | 2022-04-28 | Guilford | North Carolina | 37081 | 118963 | 1169 |
2449415 | 2449415 | 2022-04-27 | Guilford | North Carolina | 37081 | 118963 | 1169 |
2446158 | 2446158 | 2022-04-26 | Guilford | North Carolina | 37081 | 118055 | 1163 |
2442903 | 2442903 | 2022-04-25 | Guilford | North Carolina | 37081 | 118055 | 1163 |
2439647 | 2439647 | 2022-04-24 | Guilford | North Carolina | 37081 | 118055 | 1163 |
2436391 | 2436391 | 2022-04-23 | Guilford | North Carolina | 37081 | 118055 | 1163 |
2433135 | 2433135 | 2022-04-22 | Guilford | North Carolina | 37081 | 118055 | 1163 |
2429879 | 2429879 | 2022-04-21 | Guilford | North Carolina | 37081 | 118055 | 1163 |
2426623 | 2426623 | 2022-04-20 | Guilford | North Carolina | 37081 | 118055 | 1163 |
2423367 | 2423367 | 2022-04-19 | Guilford | North Carolina | 37081 | 117311 | 1159 |
2420110 | 2420110 | 2022-04-18 | Guilford | North Carolina | 37081 | 117311 | 1159 |
2416855 | 2416855 | 2022-04-17 | Guilford | North Carolina | 37081 | 117311 | 1159 |
2413599 | 2413599 | 2022-04-16 | Guilford | North Carolina | 37081 | 117311 | 1159 |
2410343 | 2410343 | 2022-04-15 | Guilford | North Carolina | 37081 | 117311 | 1159 |
2407087 | 2407087 | 2022-04-14 | Guilford | North Carolina | 37081 | 117311 | 1159 |
2403831 | 2403831 | 2022-04-13 | Guilford | North Carolina | 37081 | 117311 | 1159 |
2400576 | 2400576 | 2022-04-12 | Guilford | North Carolina | 37081 | 116888 | 1159 |
2397321 | 2397321 | 2022-04-11 | Guilford | North Carolina | 37081 | 116888 | 1159 |
2394066 | 2394066 | 2022-04-10 | Guilford | North Carolina | 37081 | 116888 | 1159 |
2390810 | 2390810 | 2022-04-09 | Guilford | North Carolina | 37081 | 116888 | 1159 |
2387554 | 2387554 | 2022-04-08 | Guilford | North Carolina | 37081 | 116888 | 1159 |
2384299 | 2384299 | 2022-04-07 | Guilford | North Carolina | 37081 | 116888 | 1159 |
2381044 | 2381044 | 2022-04-06 | Guilford | North Carolina | 37081 | 116888 | 1159 |
2377789 | 2377789 | 2022-04-05 | Guilford | North Carolina | 37081 | 116792 | 1159 |
2374536 | 2374536 | 2022-04-04 | Guilford | North Carolina | 37081 | 116718 | 1159 |
2371284 | 2371284 | 2022-04-03 | Guilford | North Carolina | 37081 | 116527 | 1157 |
2368031 | 2368031 | 2022-04-02 | Guilford | North Carolina | 37081 | 116527 | 1157 |
2364778 | 2364778 | 2022-04-01 | Guilford | North Carolina | 37081 | 116527 | 1157 |
2361524 | 2361524 | 2022-03-31 | Guilford | North Carolina | 37081 | 116383 | 1157 |
2358270 | 2358270 | 2022-03-30 | Guilford | North Carolina | 37081 | 116317 | 1157 |
2355016 | 2355016 | 2022-03-29 | Guilford | North Carolina | 37081 | 116275 | 1157 |
2351763 | 2351763 | 2022-03-28 | Guilford | North Carolina | 37081 | 116251 | 1157 |
2348511 | 2348511 | 2022-03-27 | Guilford | North Carolina | 37081 | 116190 | 1156 |
2345258 | 2345258 | 2022-03-26 | Guilford | North Carolina | 37081 | 116190 | 1156 |
2342005 | 2342005 | 2022-03-25 | Guilford | North Carolina | 37081 | 116190 | 1156 |
2338752 | 2338752 | 2022-03-24 | Guilford | North Carolina | 37081 | 116127 | 1154 |
2335498 | 2335498 | 2022-03-23 | Guilford | North Carolina | 37081 | 116035 | 1153 |
2332244 | 2332244 | 2022-03-22 | Guilford | North Carolina | 37081 | 115979 | 1149 |
2328991 | 2328991 | 2022-03-21 | Guilford | North Carolina | 37081 | 115952 | 1149 |
2325739 | 2325739 | 2022-03-20 | Guilford | North Carolina | 37081 | 115857 | 1144 |
2322486 | 2322486 | 2022-03-19 | Guilford | North Carolina | 37081 | 115857 | 1144 |
2319232 | 2319232 | 2022-03-18 | Guilford | North Carolina | 37081 | 115857 | 1144 |
2315978 | 2315978 | 2022-03-17 | Guilford | North Carolina | 37081 | 115770 | 1134 |
2312725 | 2312725 | 2022-03-16 | Guilford | North Carolina | 37081 | 115742 | 1132 |
2309472 | 2309472 | 2022-03-15 | Guilford | North Carolina | 37081 | 115686 | 1132 |
2306219 | 2306219 | 2022-03-14 | Guilford | North Carolina | 37081 | 115645 | 1133 |
2302968 | 2302968 | 2022-03-13 | Guilford | North Carolina | 37081 | 115467 | 1129 |
2299716 | 2299716 | 2022-03-12 | Guilford | North Carolina | 37081 | 115467 | 1129 |
2296464 | 2296464 | 2022-03-11 | Guilford | North Carolina | 37081 | 115467 | 1129 |
2293212 | 2293212 | 2022-03-10 | Guilford | North Carolina | 37081 | 115316 | 1120 |
2289960 | 2289960 | 2022-03-09 | Guilford | North Carolina | 37081 | 115213 | 1115 |
2286708 | 2286708 | 2022-03-08 | Guilford | North Carolina | 37081 | 115121 | 1109 |
2283456 | 2283456 | 2022-03-07 | Guilford | North Carolina | 37081 | 115110 | 1108 |
2280204 | 2280204 | 2022-03-06 | Guilford | North Carolina | 37081 | 114953 | 1108 |
2276951 | 2276951 | 2022-03-05 | Guilford | North Carolina | 37081 | 114953 | 1108 |
2273698 | 2273698 | 2022-03-04 | Guilford | North Carolina | 37081 | 114953 | 1108 |
2270445 | 2270445 | 2022-03-03 | Guilford | North Carolina | 37081 | 114839 | 1102 |
2267193 | 2267193 | 2022-03-02 | Guilford | North Carolina | 37081 | 114741 | 1096 |
2263941 | 2263941 | 2022-03-01 | Guilford | North Carolina | 37081 | 114656 | 1096 |
2260690 | 2260690 | 2022-02-28 | Guilford | North Carolina | 37081 | 114598 | 1096 |
2257439 | 2257439 | 2022-02-27 | Guilford | North Carolina | 37081 | 114179 | 1093 |
2254188 | 2254188 | 2022-02-26 | Guilford | North Carolina | 37081 | 114179 | 1093 |
2250937 | 2250937 | 2022-02-25 | Guilford | North Carolina | 37081 | 114179 | 1093 |
2247686 | 2247686 | 2022-02-24 | Guilford | North Carolina | 37081 | 113940 | 1092 |
2244435 | 2244435 | 2022-02-23 | Guilford | North Carolina | 37081 | 113756 | 1081 |
2241184 | 2241184 | 2022-02-22 | Guilford | North Carolina | 37081 | 113522 | 1073 |
2237933 | 2237933 | 2022-02-21 | Guilford | North Carolina | 37081 | 113421 | 1071 |
2234682 | 2234682 | 2022-02-20 | Guilford | North Carolina | 37081 | 112988 | 1068 |
2231431 | 2231431 | 2022-02-19 | Guilford | North Carolina | 37081 | 112988 | 1068 |
2228180 | 2228180 | 2022-02-18 | Guilford | North Carolina | 37081 | 112988 | 1068 |
2224929 | 2224929 | 2022-02-17 | Guilford | North Carolina | 37081 | 112690 | 1060 |
2221678 | 2221678 | 2022-02-16 | Guilford | North Carolina | 37081 | 112510 | 1054 |
2218427 | 2218427 | 2022-02-15 | Guilford | North Carolina | 37081 | 112294 | 1048 |
2215176 | 2215176 | 2022-02-14 | Guilford | North Carolina | 37081 | 112159 | 1046 |
2211925 | 2211925 | 2022-02-13 | Guilford | North Carolina | 37081 | 111548 | 1032 |
2208672 | 2208672 | 2022-02-12 | Guilford | North Carolina | 37081 | 111548 | 1032 |
2205419 | 2205419 | 2022-02-11 | Guilford | North Carolina | 37081 | 111548 | 1032 |
2202166 | 2202166 | 2022-02-10 | Guilford | North Carolina | 37081 | 111250 | 1026 |
2198912 | 2198912 | 2022-02-09 | Guilford | North Carolina | 37081 | 110987 | 1025 |
2195658 | 2195658 | 2022-02-08 | Guilford | North Carolina | 37081 | 110680 | 1013 |
2192404 | 2192404 | 2022-02-07 | Guilford | North Carolina | 37081 | 110512 | 1012 |
2189150 | 2189150 | 2022-02-06 | Guilford | North Carolina | 37081 | 109610 | 1012 |
2185897 | 2185897 | 2022-02-05 | Guilford | North Carolina | 37081 | 109610 | 1012 |
2182645 | 2182645 | 2022-02-04 | Guilford | North Carolina | 37081 | 109610 | 1012 |
2179393 | 2179393 | 2022-02-03 | Guilford | North Carolina | 37081 | 109130 | 1004 |
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);