ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Surry" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
cases 882 ✖
- 423 26
- 421 22
- 424 22
- 3 20
- 10 20
- 4 19
- 13 15
- 422 15
- 6 14
- 17 11
- 12 8
- 35 8
- 52 7
- 1085 7
- 1086 7
- 21009 7
- 21028 7
- 21049 7
- 21089 7
- 21149 7
- 2 6
- 14 6
- 16 6
- 407 6
- 1075 6
- 1092 6
- 14067 6
- 1 5
- 141 5
- 142 5
- 148 5
- 400 5
- 405 5
- 1087 5
- 1091 5
- 12996 5
- 11 4
- 21 4
- 51 4
- 62 4
- 101 4
- 134 4
- 140 4
- 324 4
- 336 4
- 342 4
- 398 4
- 413 4
- 417 4
- 552 4
- 564 4
- 575 4
- 601 4
- 624 4
- 630 4
- 637 4
- 1066 4
- 1094 4
- 7680 4
- 8339 4
- 8393 4
- 8411 4
- 10034 4
- 16474 4
- 5 3
- 89 3
- 95 3
- 109 3
- 119 3
- 129 3
- 137 3
- 150 3
- 171 3
- 187 3
- 233 3
- 294 3
- 341 3
- 362 3
- 411 3
- 412 3
- 414 3
- 415 3
- 420 3
- 426 3
- 427 3
- 428 3
- 435 3
- 453 3
- 466 3
- 487 3
- 517 3
- 524 3
- 527 3
- 542 3
- 595 3
- 603 3
- 612 3
- 618 3
- 621 3
- 622 3
- 623 3
- 643 3
- 648 3
- 651 3
- 669 3
- 728 3
- 793 3
- 865 3
- 934 3
- 989 3
- 1040 3
- 1060 3
- 1071 3
- 1073 3
- 1076 3
- 1077 3
- 1082 3
- 1083 3
- 1093 3
- 1097 3
- 1099 3
- 1100 3
- 1110 3
- 4036 3
- 7621 3
- 7842 3
- 7923 3
- 8015 3
- 8090 3
- 8165 3
- 8223 3
- 8295 3
- 8375 3
- 8383 3
- 8399 3
- 8441 3
- 8485 3
- 8572 3
- 8698 3
- 8834 3
- 9119 3
- 9371 3
- 9673 3
- 10399 3
- 10859 3
- 11193 3
- 11558 3
- 11815 3
- 12044 3
- 12245 3
- 12425 3
- 12546 3
- 12691 3
- 12850 3
- 13234 3
- 13590 3
- 13825 3
- 14659 3
- 15351 3
- 17826 3
- 18979 3
- 19721 3
- 20232 3
- 20577 3
- 20758 3
- 20869 3
- 20914 3
- 20969 3
- 20990 3
- 21005 3
- 21231 3
- 18 2
- 20 2
- 26 2
- 30 2
- 37 2
- 47 2
- 105 2
- 114 2
- 118 2
- 121 2
- 125 2
- 133 2
- 149 2
- 151 2
- 154 2
- 158 2
- 167 2
- 177 2
- 195 2
- 218 2
- 224 2
- 231 2
- 247 2
- 249 2
- 256 2
- 261 2
- 269 2
- 274 2
- 337 2
- 339 2
- 346 2
- 349 2
- 370 2
- 384 2
- 409 2
- 451 2
- 463 2
- 547 2
- 590 2
- 604 2
- 616 2
- 629 2
- 639 2
- 897 2
- 916 2
- 1063 2
- 1072 2
- 1084 2
- 1095 2
- 1275 2
- 2677 2
- 4430 2
- 5643 2
- 6228 2
- 7368 2
- 7443 2
- 7487 2
- 7556 2
- 8378 2
- 8397 2
- 8405 2
- 8421 2
- 12618 2
- 20977 2
- 21006 2
- 7 1
- 8 1
- 9 1
- 15 1
- 19 1
- 22 1
- 25 1
- 29 1
- 31 1
- 33 1
- 38 1
- 39 1
- 41 1
- 42 1
- 43 1
- 44 1
- 45 1
- 49 1
- 53 1
- 56 1
- 57 1
- 58 1
- 60 1
- 63 1
- 65 1
- 66 1
- 67 1
- 68 1
- 71 1
- 75 1
- 78 1
- 82 1
- 85 1
- 86 1
- 87 1
- 92 1
- 102 1
- 104 1
- 106 1
- 110 1
- 122 1
- 124 1
- 127 1
- 128 1
- 132 1
- 135 1
- 136 1
- 138 1
- 144 1
- 146 1
- 153 1
- 156 1
- 164 1
- 166 1
- 168 1
- 170 1
- 173 1
- 176 1
- 178 1
- 181 1
- 183 1
- 188 1
- 189 1
- 190 1
- 191 1
- 197 1
- 199 1
- 201 1
- 202 1
- 213 1
- 214 1
- 217 1
- 219 1
- 221 1
- 226 1
- 239 1
- 242 1
- 245 1
- 246 1
- 251 1
- 252 1
- 253 1
- 257 1
- 259 1
- 266 1
- 273 1
- 275 1
- 279 1
- 282 1
- 286 1
- 290 1
- 292 1
- 295 1
- 299 1
- 300 1
- 303 1
- 307 1
- 311 1
- 313 1
- 315 1
- 317 1
- 320 1
- 327 1
- 331 1
- 332 1
- 333 1
- 335 1
- 343 1
- 348 1
- 352 1
- 353 1
- 355 1
- 358 1
- 360 1
- 364 1
- 367 1
- 372 1
- 373 1
- 377 1
- 378 1
- 381 1
- 382 1
- 383 1
- 385 1
- 386 1
- 389 1
- 392 1
- 394 1
- 395 1
- 397 1
- 402 1
- 403 1
- 406 1
- 418 1
- 433 1
- 437 1
- 442 1
- 444 1
- 446 1
- 449 1
- 456 1
- 459 1
- 464 1
- 470 1
- 472 1
- 473 1
- 480 1
- 482 1
- 486 1
- 488 1
- 493 1
- 496 1
- 497 1
- 503 1
- 504 1
- 510 1
- 515 1
- 516 1
- 525 1
- 528 1
- 533 1
- 535 1
- 536 1
- 538 1
- 541 1
- 551 1
- 553 1
- 557 1
- 559 1
- 562 1
- 563 1
- 565 1
- 566 1
- 571 1
- 572 1
- 574 1
- 580 1
- 582 1
- 587 1
- 592 1
- 605 1
- 607 1
- 608 1
- 615 1
- 617 1
- 620 1
- 628 1
- 631 1
- 632 1
- 633 1
- 634 1
- 638 1
- 640 1
- 642 1
- 647 1
- 652 1
- 658 1
- 663 1
- 664 1
- 665 1
- 671 1
- 675 1
- 683 1
- 686 1
- 688 1
- 696 1
- 699 1
- 709 1
- 712 1
- 737 1
- 748 1
- 750 1
- 757 1
- 766 1
- 773 1
- 774 1
- 785 1
- 787 1
- 802 1
- 823 1
- 832 1
- 835 1
- 845 1
- 848 1
- 857 1
- 860 1
- 869 1
- 872 1
- 877 1
- 878 1
- 898 1
- 909 1
- 928 1
- 954 1
- 956 1
- 957 1
- 960 1
- 965 1
- 967 1
- 972 1
- 974 1
- 980 1
- 984 1
- 998 1
- 999 1
- 1005 1
- 1007 1
- 1009 1
- 1013 1
- 1017 1
- 1019 1
- 1028 1
- 1041 1
- 1049 1
- 1051 1
- 1052 1
- 1056 1
- 1062 1
- 1064 1
- 1068 1
- 1069 1
- 1079 1
- 1080 1
- 1098 1
- 1104 1
- 1105 1
- 1107 1
- 1118 1
- 1131 1
- 1148 1
- 1155 1
- 1157 1
- 1167 1
- 1173 1
- 1187 1
- 1195 1
- 1204 1
- 1209 1
- 1214 1
- 1215 1
- 1217 1
- 1230 1
- 1232 1
- 1238 1
- 1240 1
- 1242 1
- 1243 1
- 1249 1
- 1257 1
- 1265 1
- 1271 1
- 1277 1
- 1279 1
- 1282 1
- 1313 1
- 1316 1
- 1323 1
- 1332 1
- 1334 1
- 1345 1
- 1363 1
- 1386 1
- 1399 1
- 1401 1
- 1411 1
- 1424 1
- 1431 1
- 1451 1
- 1459 1
- 1480 1
- 1497 1
- 1503 1
- 1512 1
- 1530 1
- 1542 1
- 1577 1
- 1599 1
- 1610 1
- 1636 1
- 1646 1
- 1661 1
- 1677 1
- 1694 1
- 1738 1
- 1771 1
- 1795 1
- 1810 1
- 1853 1
- 1885 1
- 1930 1
- 1961 1
- 1998 1
- 2009 1
- 2021 1
- 2050 1
- 2093 1
- 2142 1
- 2157 1
- 2187 1
- 2200 1
- 2221 1
- 2253 1
- 2289 1
- 2308 1
- 2334 1
- 2351 1
- 2362 1
- 2385 1
- 2426 1
- 2480 1
- 2526 1
- 2548 1
- 2589 1
- 2603 1
- 2620 1
- 2747 1
- 2755 1
- 2779 1
- 2809 1
- 2839 1
- 2894 1
- 2931 1
- 2969 1
- 3002 1
- 3045 1
- 3084 1
- 3123 1
- 3187 1
- 3250 1
- 3322 1
- 3378 1
- 3439 1
- 3488 1
- 3537 1
- 3606 1
- 3645 1
- 3723 1
- 3804 1
- 3881 1
- 3908 1
- 3970 1
- 4202 1
- 4216 1
- 4251 1
- 4266 1
- 4388 1
- 4588 1
- 4620 1
- 4670 1
- 4747 1
- 4853 1
- 4955 1
- 5009 1
- 5117 1
- 5200 1
- 5231 1
- 5260 1
- 5295 1
- 5413 1
- 5497 1
- 5561 1
- 5711 1
- 5782 1
- 5846 1
- 5918 1
- 5966 1
- 6024 1
- 6082 1
- 6097 1
- 6135 1
- 6189 1
- 6321 1
- 6359 1
- 6382 1
- 6437 1
- 6512 1
- 6566 1
- 6632 1
- 6706 1
- 6745 1
- 6776 1
- 6841 1
- 6900 1
- 6950 1
- 7000 1
- 7027 1
- 7050 1
- 7067 1
- 7100 1
- 7154 1
- 7180 1
- 7215 1
- 7241 1
- 7261 1
- 7269 1
- 7296 1
- 7324 1
- 7348 1
- 7379 1
- 7383 1
- 7401 1
- 7413 1
- 7426 1
- 7455 1
- 7457 1
- 7461 1
- 7477 1
- 7485 1
- 7501 1
- 7510 1
- 7527 1
- 7538 1
- 7542 1
- 7566 1
- 7570 1
- 7595 1
- 7604 1
- 7642 1
- 7652 1
- 7665 1
- 7786 1
- 7795 1
- 7814 1
- 7828 1
- 7874 1
- 7880 1
- 7895 1
- 7905 1
- 7959 1
- 7967 1
- 7996 1
- 8007 1
- 8044 1
- 8054 1
- 8067 1
- 8081 1
- 8119 1
- 8127 1
- 8136 1
- 8151 1
- 8186 1
- 8189 1
- 8205 1
- 8212 1
- 8255 1
- 8262 1
- 8271 1
- 8285 1
- 8317 1
- 8321 1
- 8330 1
- 8335 1
- 8358 1
- 8364 1
- 8371 1
- 8381 1
- 8384 1
- 8386 1
- 8387 1
- 8391 1
- 8392 1
- 8395 1
- 8404 1
- 8407 1
- 8433 1
- 8455 1
- 8460 1
- 8468 1
- 8478 1
- 8512 1
- 8519 1
- 8527 1
- 8553 1
- 8611 1
- 8626 1
- 8649 1
- 8674 1
- 8743 1
- 8753 1
- 8776 1
- 8806 1
- 8955 1
- 8978 1
- 9020 1
- 9086 1
- 9217 1
- 9232 1
- 9282 1
- 9329 1
- 9499 1
- 9521 1
- 9529 1
- 9614 1
- 9748 1
- 9795 1
- 9860 1
- 9936 1
- 10277 1
- 10294 1
- 10363 1
- 10577 1
- 10631 1
- 10706 1
- 10769 1
- 10977 1
- 11027 1
- 11085 1
- 11141 1
- 11333 1
- 11377 1
- 11424 1
- 11494 1
- 11671 1
- 11703 1
- 11735 1
- 11776 1
- 11912 1
- 11939 1
- 11982 1
- 12024 1
- 12115 1
- 12131 1
- 12167 1
- 12210 1
- 12356 1
- 12369 1
- 12379 1
- 12407 1
- 12462 1
- 12472 1
- 12494 1
- 12518 1
- 12582 1
- 12590 1
- 12732 1
- 12746 1
- 12778 1
- 12815 1
- 12928 1
- 12950 1
- 13126 1
- 13136 1
- 13154 1
- 13189 1
- 13364 1
- 13390 1
- 13443 1
- 13524 1
- 13695 1
- 13712 1
- 13746 1
- 13786 1
- 13942 1
- 13984 1
- 14320 1
- 14384 1
- 14566 1
- 14861 1
- 14920 1
- 15083 1
- 15213 1
- 15710 1
- 15769 1
- 15963 1
- 16266 1
- 17305 1
- 17486 1
- 17670 1
- 18310 1
- 18428 1
- 18637 1
- 18845 1
- 19315 1
- 19381 1
- 19457 1
- 19610 1
- 19931 1
- 19960 1
- 20089 1
- 20165 1
- 20359 1
- 20390 1
- 20433 1
- 20532 1
- 20661 1
- 20669 1
- 20700 1
- 20733 1
- 20815 1
- 20822 1
- 20836 1
- 20849 1
- 20886 1
- 20887 1
- 20895 1
- 20908 1
- 20933 1
- 20935 1
- 20956 1
- 20959 1
- 20981 1
- 20988 1
- 20993 1
- 20996 1
- 21002 1
- 21003 1
state 2
- North Carolina 778
- Virginia 774
county 1
- Surry · 1,552 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15175 | 15175 | 2020-03-27 | Surry | North Carolina | 37171 | 1 | 0 |
17009 | 17009 | 2020-03-28 | Surry | North Carolina | 37171 | 1 | 0 |
18941 | 18941 | 2020-03-29 | Surry | North Carolina | 37171 | 2 | 0 |
20982 | 20982 | 2020-03-30 | Surry | North Carolina | 37171 | 2 | 0 |
23110 | 23110 | 2020-03-31 | Surry | North Carolina | 37171 | 2 | 0 |
23744 | 23744 | 2020-03-31 | Surry | Virginia | 51181 | 1 | 0 |
25304 | 25304 | 2020-04-01 | Surry | North Carolina | 37171 | 2 | 0 |
25960 | 25960 | 2020-04-01 | Surry | Virginia | 51181 | 1 | 0 |
27570 | 27570 | 2020-04-02 | Surry | North Carolina | 37171 | 2 | 0 |
28251 | 28251 | 2020-04-02 | Surry | Virginia | 51181 | 1 | 0 |
29897 | 29897 | 2020-04-03 | Surry | North Carolina | 37171 | 2 | 0 |
30600 | 30600 | 2020-04-03 | Surry | Virginia | 51181 | 3 | 0 |
32284 | 32284 | 2020-04-04 | Surry | North Carolina | 37171 | 3 | 0 |
33000 | 33000 | 2020-04-04 | Surry | Virginia | 51181 | 3 | 0 |
34716 | 34716 | 2020-04-05 | Surry | North Carolina | 37171 | 3 | 0 |
35438 | 35438 | 2020-04-05 | Surry | Virginia | 51181 | 3 | 0 |
37185 | 37185 | 2020-04-06 | Surry | North Carolina | 37171 | 3 | 0 |
37922 | 37922 | 2020-04-06 | Surry | Virginia | 51181 | 3 | 0 |
39701 | 39701 | 2020-04-07 | Surry | North Carolina | 37171 | 10 | 0 |
40457 | 40457 | 2020-04-07 | Surry | Virginia | 51181 | 3 | 0 |
42258 | 42258 | 2020-04-08 | Surry | North Carolina | 37171 | 10 | 0 |
43026 | 43026 | 2020-04-08 | Surry | Virginia | 51181 | 3 | 0 |
44842 | 44842 | 2020-04-09 | Surry | North Carolina | 37171 | 10 | 0 |
45622 | 45622 | 2020-04-09 | Surry | Virginia | 51181 | 3 | 0 |
47455 | 47455 | 2020-04-10 | Surry | North Carolina | 37171 | 10 | 0 |
48249 | 48249 | 2020-04-10 | Surry | Virginia | 51181 | 3 | 0 |
50110 | 50110 | 2020-04-11 | Surry | North Carolina | 37171 | 10 | 0 |
50907 | 50907 | 2020-04-11 | Surry | Virginia | 51181 | 3 | 0 |
52783 | 52783 | 2020-04-12 | Surry | North Carolina | 37171 | 10 | 0 |
53582 | 53582 | 2020-04-12 | Surry | Virginia | 51181 | 3 | 0 |
55467 | 55467 | 2020-04-13 | Surry | North Carolina | 37171 | 10 | 0 |
56272 | 56272 | 2020-04-13 | Surry | Virginia | 51181 | 3 | 0 |
58167 | 58167 | 2020-04-14 | Surry | North Carolina | 37171 | 10 | 0 |
58978 | 58978 | 2020-04-14 | Surry | Virginia | 51181 | 3 | 0 |
60881 | 60881 | 2020-04-15 | Surry | North Carolina | 37171 | 10 | 0 |
61697 | 61697 | 2020-04-15 | Surry | Virginia | 51181 | 3 | 0 |
63607 | 63607 | 2020-04-16 | Surry | North Carolina | 37171 | 11 | 0 |
64430 | 64430 | 2020-04-16 | Surry | Virginia | 51181 | 3 | 0 |
66350 | 66350 | 2020-04-17 | Surry | North Carolina | 37171 | 16 | 0 |
67178 | 67178 | 2020-04-17 | Surry | Virginia | 51181 | 3 | 0 |
69107 | 69107 | 2020-04-18 | Surry | North Carolina | 37171 | 17 | 0 |
69940 | 69940 | 2020-04-18 | Surry | Virginia | 51181 | 3 | 0 |
71873 | 71873 | 2020-04-19 | Surry | North Carolina | 37171 | 17 | 0 |
72710 | 72710 | 2020-04-19 | Surry | Virginia | 51181 | 3 | 0 |
74648 | 74648 | 2020-04-20 | Surry | North Carolina | 37171 | 17 | 0 |
75486 | 75486 | 2020-04-20 | Surry | Virginia | 51181 | 4 | 0 |
77429 | 77429 | 2020-04-21 | Surry | North Carolina | 37171 | 12 | 0 |
78270 | 78270 | 2020-04-21 | Surry | Virginia | 51181 | 4 | 1 |
80218 | 80218 | 2020-04-22 | Surry | North Carolina | 37171 | 12 | 0 |
81063 | 81063 | 2020-04-22 | Surry | Virginia | 51181 | 4 | 1 |
83017 | 83017 | 2020-04-23 | Surry | North Carolina | 37171 | 12 | 0 |
83864 | 83864 | 2020-04-23 | Surry | Virginia | 51181 | 4 | 1 |
85821 | 85821 | 2020-04-24 | Surry | North Carolina | 37171 | 12 | 0 |
86671 | 86671 | 2020-04-24 | Surry | Virginia | 51181 | 4 | 1 |
88634 | 88634 | 2020-04-25 | Surry | North Carolina | 37171 | 12 | 0 |
89486 | 89486 | 2020-04-25 | Surry | Virginia | 51181 | 4 | 1 |
91449 | 91449 | 2020-04-26 | Surry | North Carolina | 37171 | 12 | 0 |
92303 | 92303 | 2020-04-26 | Surry | Virginia | 51181 | 4 | 1 |
94275 | 94275 | 2020-04-27 | Surry | North Carolina | 37171 | 12 | 0 |
95132 | 95132 | 2020-04-27 | Surry | Virginia | 51181 | 4 | 1 |
97112 | 97112 | 2020-04-28 | Surry | North Carolina | 37171 | 12 | 0 |
97976 | 97976 | 2020-04-28 | Surry | Virginia | 51181 | 4 | 1 |
99960 | 99960 | 2020-04-29 | Surry | North Carolina | 37171 | 13 | 0 |
100826 | 100826 | 2020-04-29 | Surry | Virginia | 51181 | 4 | 1 |
102813 | 102813 | 2020-04-30 | Surry | North Carolina | 37171 | 13 | 0 |
103681 | 103681 | 2020-04-30 | Surry | Virginia | 51181 | 4 | 1 |
105675 | 105675 | 2020-05-01 | Surry | North Carolina | 37171 | 13 | 0 |
106545 | 106545 | 2020-05-01 | Surry | Virginia | 51181 | 4 | 1 |
108542 | 108542 | 2020-05-02 | Surry | North Carolina | 37171 | 17 | 1 |
109414 | 109414 | 2020-05-02 | Surry | Virginia | 51181 | 4 | 1 |
111415 | 111415 | 2020-05-03 | Surry | North Carolina | 37171 | 16 | 1 |
112288 | 112288 | 2020-05-03 | Surry | Virginia | 51181 | 4 | 1 |
114296 | 114296 | 2020-05-04 | Surry | North Carolina | 37171 | 16 | 1 |
115171 | 115171 | 2020-05-04 | Surry | Virginia | 51181 | 4 | 1 |
117176 | 117176 | 2020-05-05 | Surry | North Carolina | 37171 | 20 | 1 |
118130 | 118130 | 2020-05-05 | Surry | Virginia | 51181 | 4 | 1 |
120137 | 120137 | 2020-05-06 | Surry | North Carolina | 37171 | 20 | 1 |
121094 | 121094 | 2020-05-06 | Surry | Virginia | 51181 | 4 | 1 |
123112 | 123112 | 2020-05-07 | Surry | North Carolina | 37171 | 26 | 1 |
124075 | 124075 | 2020-05-07 | Surry | Virginia | 51181 | 4 | 1 |
126095 | 126095 | 2020-05-08 | Surry | North Carolina | 37171 | 30 | 1 |
127060 | 127060 | 2020-05-08 | Surry | Virginia | 51181 | 4 | 1 |
129084 | 129084 | 2020-05-09 | Surry | North Carolina | 37171 | 33 | 1 |
130050 | 130050 | 2020-05-09 | Surry | Virginia | 51181 | 5 | 1 |
132073 | 132073 | 2020-05-10 | Surry | North Carolina | 37171 | 41 | 1 |
133040 | 133040 | 2020-05-10 | Surry | Virginia | 51181 | 5 | 1 |
135064 | 135064 | 2020-05-11 | Surry | North Carolina | 37171 | 43 | 1 |
136030 | 136030 | 2020-05-11 | Surry | Virginia | 51181 | 5 | 1 |
138054 | 138054 | 2020-05-12 | Surry | North Carolina | 37171 | 45 | 1 |
139021 | 139021 | 2020-05-12 | Surry | Virginia | 51181 | 6 | 1 |
141050 | 141050 | 2020-05-13 | Surry | North Carolina | 37171 | 47 | 1 |
142017 | 142017 | 2020-05-13 | Surry | Virginia | 51181 | 6 | 1 |
144045 | 144045 | 2020-05-14 | Surry | North Carolina | 37171 | 62 | 1 |
145014 | 145014 | 2020-05-14 | Surry | Virginia | 51181 | 6 | 1 |
147046 | 147046 | 2020-05-15 | Surry | North Carolina | 37171 | 67 | 1 |
148017 | 148017 | 2020-05-15 | Surry | Virginia | 51181 | 6 | 1 |
150053 | 150053 | 2020-05-16 | Surry | North Carolina | 37171 | 75 | 1 |
151026 | 151026 | 2020-05-16 | Surry | Virginia | 51181 | 6 | 1 |
153063 | 153063 | 2020-05-17 | Surry | North Carolina | 37171 | 89 | 1 |
154037 | 154037 | 2020-05-17 | Surry | Virginia | 51181 | 6 | 1 |
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);