⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

396 rows where county = "San Francisco" and state = "California" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

Link rowid date ▲ county state fips cases deaths
1082939 2021-03-03 San Francisco California 6075 34390 422
1079693 2021-03-02 San Francisco California 6075 34321 422
1076448 2021-03-01 San Francisco California 6075 34294 422
1073202 2021-02-28 San Francisco California 6075 34263 422
1069956 2021-02-27 San Francisco California 6075 34216 412
1066711 2021-02-26 San Francisco California 6075 34141 410
1063466 2021-02-25 San Francisco California 6075 34064 398
1060221 2021-02-24 San Francisco California 6075 33997 394
1056975 2021-02-23 San Francisco California 6075 33950 394
1053729 2021-02-22 San Francisco California 6075 33894 394
1050482 2021-02-21 San Francisco California 6075 33823 394
1047235 2021-02-20 San Francisco California 6075 33749 394
1043990 2021-02-19 San Francisco California 6075 33653 387
1040745 2021-02-18 San Francisco California 6075 33561 376
1037500 2021-02-17 San Francisco California 6075 33494 376
1034255 2021-02-16 San Francisco California 6075 33457 372
1031009 2021-02-15 San Francisco California 6075 33377 366
1027762 2021-02-14 San Francisco California 6075 33294 366
1024517 2021-02-13 San Francisco California 6075 33182 366
1021272 2021-02-12 San Francisco California 6075 33079 359
1018027 2021-02-11 San Francisco California 6075 32958 351
1014782 2021-02-10 San Francisco California 6075 32785 351
1011537 2021-02-09 San Francisco California 6075 32682 346
1008291 2021-02-08 San Francisco California 6075 32612 346
1005045 2021-02-07 San Francisco California 6075 32440 346
1001799 2021-02-06 San Francisco California 6075 32232 345
998553 2021-02-05 San Francisco California 6075 32119 345
995307 2021-02-04 San Francisco California 6075 31986 328
992061 2021-02-03 San Francisco California 6075 31791 328
988815 2021-02-02 San Francisco California 6075 31706 324
985568 2021-02-01 San Francisco California 6075 31566 324
982321 2021-01-31 San Francisco California 6075 31430 324
979075 2021-01-30 San Francisco California 6075 31297 323
975830 2021-01-29 San Francisco California 6075 31196 317
972585 2021-01-28 San Francisco California 6075 31085 308
969340 2021-01-27 San Francisco California 6075 30877 297
966096 2021-01-26 San Francisco California 6075 30737 293
962851 2021-01-25 San Francisco California 6075 30562 293
959606 2021-01-24 San Francisco California 6075 30311 293
956360 2021-01-23 San Francisco California 6075 30030 278
953115 2021-01-22 San Francisco California 6075 29804 275
949870 2021-01-21 San Francisco California 6075 29668 274
946624 2021-01-20 San Francisco California 6075 29505 266
943377 2021-01-19 San Francisco California 6075 29324 262
940132 2021-01-18 San Francisco California 6075 29142 262
936887 2021-01-17 San Francisco California 6075 28856 254
933642 2021-01-16 San Francisco California 6075 28577 254
930397 2021-01-15 San Francisco California 6075 28203 241
927152 2021-01-14 San Francisco California 6075 27866 237
923906 2021-01-13 San Francisco California 6075 27534 235
920661 2021-01-12 San Francisco California 6075 27267 235
917416 2021-01-11 San Francisco California 6075 27057 234
914171 2021-01-10 San Francisco California 6075 26711 233
910926 2021-01-09 San Francisco California 6075 26381 233
907681 2021-01-08 San Francisco California 6075 25888 218
904435 2021-01-07 San Francisco California 6075 25427 205
901190 2021-01-06 San Francisco California 6075 24992 203
897945 2021-01-05 San Francisco California 6075 24756 198
894700 2021-01-04 San Francisco California 6075 24591 194
891453 2021-01-03 San Francisco California 6075 24417 194
888206 2021-01-02 San Francisco California 6075 24148 194
884961 2021-01-01 San Francisco California 6075 23743 189
881716 2020-12-31 San Francisco California 6075 23227 186
878471 2020-12-30 San Francisco California 6075 22999 184
875226 2020-12-29 San Francisco California 6075 22729 182
871981 2020-12-28 San Francisco California 6075 22517 182
868736 2020-12-27 San Francisco California 6075 22322 182
865491 2020-12-26 San Francisco California 6075 22133 181
862246 2020-12-25 San Francisco California 6075 21833 181
859001 2020-12-24 San Francisco California 6075 21501 178
855756 2020-12-23 San Francisco California 6075 21235 178
852511 2020-12-22 San Francisco California 6075 21089 176
849266 2020-12-21 San Francisco California 6075 20940 176
846021 2020-12-20 San Francisco California 6075 20646 176
842775 2020-12-19 San Francisco California 6075 20318 176
839530 2020-12-18 San Francisco California 6075 19942 173
836285 2020-12-17 San Francisco California 6075 19627 172
833039 2020-12-16 San Francisco California 6075 19286 172
829792 2020-12-15 San Francisco California 6075 18907 167
826546 2020-12-14 San Francisco California 6075 18689 167
823299 2020-12-13 San Francisco California 6075 18416 167
820053 2020-12-12 San Francisco California 6075 18249 167
816807 2020-12-11 San Francisco California 6075 17948 167
813561 2020-12-10 San Francisco California 6075 17631 165
810317 2020-12-09 San Francisco California 6075 17387 164
807072 2020-12-08 San Francisco California 6075 17223 164
803827 2020-12-07 San Francisco California 6075 17110 164
800582 2020-12-06 San Francisco California 6075 16789 164
797337 2020-12-05 San Francisco California 6075 16502 164
794092 2020-12-04 San Francisco California 6075 16239 162
790847 2020-12-03 San Francisco California 6075 16061 161
787602 2020-12-02 San Francisco California 6075 15800 160
784358 2020-12-01 San Francisco California 6075 15642 160
781113 2020-11-30 San Francisco California 6075 15574 160
777867 2020-11-29 San Francisco California 6075 15453 160
774622 2020-11-28 San Francisco California 6075 15380 160
771377 2020-11-27 San Francisco California 6075 15159 160
768132 2020-11-26 San Francisco California 6075 15056 160
764886 2020-11-25 San Francisco California 6075 14877 160
761641 2020-11-24 San Francisco California 6075 14665 158
758396 2020-11-23 San Francisco California 6075 14545 158
755149 2020-11-22 San Francisco California 6075 14448 158
751903 2020-11-21 San Francisco California 6075 14330 158
748657 2020-11-20 San Francisco California 6075 14254 156
745411 2020-11-19 San Francisco California 6075 14060 156
742164 2020-11-18 San Francisco California 6075 13955 156
738917 2020-11-17 San Francisco California 6075 13850 156
735673 2020-11-16 San Francisco California 6075 13760 156
732427 2020-11-15 San Francisco California 6075 13668 156
729182 2020-11-14 San Francisco California 6075 13519 155
725939 2020-11-13 San Francisco California 6075 13407 153
722696 2020-11-12 San Francisco California 6075 13311 153
719453 2020-11-11 San Francisco California 6075 13213 153
716210 2020-11-10 San Francisco California 6075 13142 151
712966 2020-11-09 San Francisco California 6075 13084 151
709722 2020-11-08 San Francisco California 6075 12983 151
706478 2020-11-07 San Francisco California 6075 12863 151
703235 2020-11-06 San Francisco California 6075 12756 151
699992 2020-11-05 San Francisco California 6075 12669 149
696748 2020-11-04 San Francisco California 6075 12602 149
693506 2020-11-03 San Francisco California 6075 12557 149
690263 2020-11-02 San Francisco California 6075 12511 148
687018 2020-11-01 San Francisco California 6075 12457 148
683774 2020-10-31 San Francisco California 6075 12402 148
680531 2020-10-30 San Francisco California 6075 12323 147
677288 2020-10-29 San Francisco California 6075 12280 145
674045 2020-10-28 San Francisco California 6075 12244 145
670803 2020-10-27 San Francisco California 6075 12192 140
667560 2020-10-26 San Francisco California 6075 12155 140
664315 2020-10-25 San Francisco California 6075 12106 140
661071 2020-10-24 San Francisco California 6075 12072 140
657827 2020-10-23 San Francisco California 6075 12035 140
654582 2020-10-22 San Francisco California 6075 12003 138
651337 2020-10-21 San Francisco California 6075 12016 137
648093 2020-10-20 San Francisco California 6075 11940 133
644848 2020-10-19 San Francisco California 6075 11904 133
641600 2020-10-18 San Francisco California 6075 11880 133
638353 2020-10-17 San Francisco California 6075 11843 133
635108 2020-10-16 San Francisco California 6075 11811 131
631862 2020-10-15 San Francisco California 6075 11786 126
628618 2020-10-14 San Francisco California 6075 11715 123
625375 2020-10-13 San Francisco California 6075 11694 123
622132 2020-10-12 San Francisco California 6075 11669 123
618889 2020-10-11 San Francisco California 6075 11666 123
615647 2020-10-10 San Francisco California 6075 11623 123
612406 2020-10-09 San Francisco California 6075 11611 121
609164 2020-10-08 San Francisco California 6075 11554 115
605921 2020-10-07 San Francisco California 6075 11536 114
602679 2020-10-06 San Francisco California 6075 11508 111
599436 2020-10-05 San Francisco California 6075 11483 108
596193 2020-10-04 San Francisco California 6075 11478 108
592951 2020-10-03 San Francisco California 6075 11417 107
589711 2020-10-02 San Francisco California 6075 11363 107
586470 2020-10-01 San Francisco California 6075 11335 106
583230 2020-09-30 San Francisco California 6075 11278 104
579991 2020-09-29 San Francisco California 6075 11241 101
576750 2020-09-28 San Francisco California 6075 11198 101
573507 2020-09-27 San Francisco California 6075 11146 101
570265 2020-09-26 San Francisco California 6075 11079 101
567023 2020-09-25 San Francisco California 6075 11041 99
563783 2020-09-24 San Francisco California 6075 10949 99
560544 2020-09-23 San Francisco California 6075 10904 99
557308 2020-09-22 San Francisco California 6075 10868 99
554071 2020-09-21 San Francisco California 6075 10810 99
550832 2020-09-20 San Francisco California 6075 10748 99
547593 2020-09-19 San Francisco California 6075 10699 97
544355 2020-09-18 San Francisco California 6075 10643 96
541119 2020-09-17 San Francisco California 6075 10572 91
537882 2020-09-16 San Francisco California 6075 10493 91
534646 2020-09-15 San Francisco California 6075 10433 91
531411 2020-09-14 San Francisco California 6075 10381 91
528174 2020-09-13 San Francisco California 6075 10305 91
524938 2020-09-12 San Francisco California 6075 10266 90
521702 2020-09-11 San Francisco California 6075 10191 89
518465 2020-09-10 San Francisco California 6075 10123 88
515230 2020-09-09 San Francisco California 6075 10077 87
511997 2020-09-08 San Francisco California 6075 9982 86
508764 2020-09-07 San Francisco California 6075 9982 86
505532 2020-09-06 San Francisco California 6075 9918 86
502298 2020-09-05 San Francisco California 6075 9842 86
499064 2020-09-04 San Francisco California 6075 9758 84
495831 2020-09-03 San Francisco California 6075 9699 84
492597 2020-09-02 San Francisco California 6075 9620 84
489364 2020-09-01 San Francisco California 6075 9547 83
486131 2020-08-31 San Francisco California 6075 9497 83
482896 2020-08-30 San Francisco California 6075 9431 83
479662 2020-08-29 San Francisco California 6075 9352 83
476429 2020-08-28 San Francisco California 6075 9218 83
473196 2020-08-27 San Francisco California 6075 9152 82
469964 2020-08-26 San Francisco California 6075 9063 80
466735 2020-08-25 San Francisco California 6075 8984 77
463506 2020-08-24 San Francisco California 6075 8939 77
460277 2020-08-23 San Francisco California 6075 8874 77
457050 2020-08-22 San Francisco California 6075 8794 74
453822 2020-08-21 San Francisco California 6075 8705 72
450594 2020-08-20 San Francisco California 6075 8614 72
447366 2020-08-19 San Francisco California 6075 8531 72
444139 2020-08-18 San Francisco California 6075 8430 70
440913 2020-08-17 San Francisco California 6075 8349 70
437687 2020-08-16 San Francisco California 6075 8295 69
434461 2020-08-15 San Francisco California 6075 8160 69
431236 2020-08-14 San Francisco California 6075 8056 69
428008 2020-08-13 San Francisco California 6075 7947 67
424784 2020-08-12 San Francisco California 6075 7837 67
421563 2020-08-11 San Francisco California 6075 7626 67
418342 2020-08-10 San Francisco California 6075 7626 67
415121 2020-08-09 San Francisco California 6075 7551 67
411901 2020-08-08 San Francisco California 6075 7435 67
408682 2020-08-07 San Francisco California 6075 7329 64
405462 2020-08-06 San Francisco California 6075 7231 63
402244 2020-08-05 San Francisco California 6075 7084 62
399028 2020-08-04 San Francisco California 6075 6992 61
395812 2020-08-03 San Francisco California 6075 6919 61
392596 2020-08-02 San Francisco California 6075 6814 61
389379 2020-08-01 San Francisco California 6075 6726 61
386162 2020-07-31 San Francisco California 6075 6578 59
382944 2020-07-30 San Francisco California 6075 6426 58
379727 2020-07-29 San Francisco California 6075 6200 57
376510 2020-07-28 San Francisco California 6075 6068 56
373296 2020-07-27 San Francisco California 6075 6025 56
370084 2020-07-26 San Francisco California 6075 5935 56
366874 2020-07-25 San Francisco California 6075 5790 56
363667 2020-07-24 San Francisco California 6075 5682 56
360460 2020-07-23 San Francisco California 6075 5567 55
357255 2020-07-22 San Francisco California 6075 5462 53
354052 2020-07-21 San Francisco California 6075 5366 53
350850 2020-07-20 San Francisco California 6075 5308 52
347649 2020-07-19 San Francisco California 6075 5205 52
344449 2020-07-18 San Francisco California 6075 5119 52
341250 2020-07-17 San Francisco California 6075 4978 52
338054 2020-07-16 San Francisco California 6075 4863 51
334859 2020-07-15 San Francisco California 6075 4699 50
331666 2020-07-14 San Francisco California 6075 4643 50
328480 2020-07-13 San Francisco California 6075 4593 50
325294 2020-07-12 San Francisco California 6075 4525 50
322113 2020-07-11 San Francisco California 6075 4429 50
318934 2020-07-10 San Francisco California 6075 4319 50
315761 2020-07-09 San Francisco California 6075 4148 50
312586 2020-07-08 San Francisco California 6075 4074 50
309416 2020-07-07 San Francisco California 6075 4023 50
306248 2020-07-06 San Francisco California 6075 3995 50
303084 2020-07-05 San Francisco California 6075 3864 50
299920 2020-07-04 San Francisco California 6075 3784 50
296758 2020-07-03 San Francisco California 6075 3722 50
293602 2020-07-02 San Francisco California 6075 3722 50
290448 2020-07-01 San Francisco California 6075 3651 50
287297 2020-06-30 San Francisco California 6075 3606 50
284151 2020-06-29 San Francisco California 6075 3564 50
281005 2020-06-28 San Francisco California 6075 3515 50
277858 2020-06-27 San Francisco California 6075 3471 49
274710 2020-06-26 San Francisco California 6075 3403 48
271570 2020-06-25 San Francisco California 6075 3300 48
268435 2020-06-24 San Francisco California 6075 3252 48
265305 2020-06-23 San Francisco California 6075 3222 48
262177 2020-06-22 San Francisco California 6075 3188 48
259050 2020-06-21 San Francisco California 6075 3061 47
255923 2020-06-20 San Francisco California 6075 3061 47
252804 2020-06-19 San Francisco California 6075 3060 47
249689 2020-06-18 San Francisco California 6075 3023 47
246577 2020-06-17 San Francisco California 6075 2985 47
243464 2020-06-16 San Francisco California 6075 2974 46
240353 2020-06-15 San Francisco California 6075 2955 45
237245 2020-06-14 San Francisco California 6075 2931 45
234138 2020-06-13 San Francisco California 6075 2909 44
231032 2020-06-12 San Francisco California 6075 2880 44
227929 2020-06-11 San Francisco California 6075 2843 44
224827 2020-06-10 San Francisco California 6075 2812 44
221732 2020-06-09 San Francisco California 6075 2796 44
218637 2020-06-08 San Francisco California 6075 2782 43
215546 2020-06-07 San Francisco California 6075 2750 43
212459 2020-06-06 San Francisco California 6075 2715 43
209374 2020-06-05 San Francisco California 6075 2701 43
206293 2020-06-04 San Francisco California 6075 2647 43
203213 2020-06-03 San Francisco California 6075 2616 43
200137 2020-06-02 San Francisco California 6075 2590 43
197064 2020-06-01 San Francisco California 6075 2573 43
193994 2020-05-31 San Francisco California 6075 2561 42
190927 2020-05-30 San Francisco California 6075 2535 41
187862 2020-05-29 San Francisco California 6075 2476 41
184806 2020-05-28 San Francisco California 6075 2440 40
181752 2020-05-27 San Francisco California 6075 2411 40
178708 2020-05-26 San Francisco California 6075 2402 40
175664 2020-05-25 San Francisco California 6075 2389 40
172620 2020-05-24 San Francisco California 6075 2370 40
169579 2020-05-23 San Francisco California 6075 2353 40
166542 2020-05-22 San Francisco California 6075 2323 40
163510 2020-05-21 San Francisco California 6075 2202 37
160482 2020-05-20 San Francisco California 6075 2189 37
157456 2020-05-19 San Francisco California 6075 2186 36
154440 2020-05-18 San Francisco California 6075 2135 36
151428 2020-05-17 San Francisco California 6075 2097 36
148419 2020-05-16 San Francisco California 6075 2065 36
145415 2020-05-15 San Francisco California 6075 2032 36
142416 2020-05-14 San Francisco California 6075 2007 35
139420 2020-05-13 San Francisco California 6075 1997 35
136429 2020-05-12 San Francisco California 6075 1980 35
133439 2020-05-11 San Francisco California 6075 1957 35
130449 2020-05-10 San Francisco California 6075 1946 34
127459 2020-05-09 San Francisco California 6075 1894 33
124474 2020-05-08 San Francisco California 6075 1856 33
121494 2020-05-07 San Francisco California 6075 1806 32
118527 2020-05-06 San Francisco California 6075 1779 31
115568 2020-05-05 San Francisco California 6075 1760 31
112685 2020-05-04 San Francisco California 6075 1692 30
109810 2020-05-03 San Francisco California 6075 1632 29
106941 2020-05-02 San Francisco California 6075 1552 29
104076 2020-05-01 San Francisco California 6075 1526 28
101221 2020-04-30 San Francisco California 6075 1502 25
98371 2020-04-29 San Francisco California 6075 1490 23
95526 2020-04-28 San Francisco California 6075 1471 23
92694 2020-04-27 San Francisco California 6075 1427 23
89876 2020-04-26 San Francisco California 6075 1411 22
87059 2020-04-25 San Francisco California 6075 1357 22
84251 2020-04-24 San Francisco California 6075 1343 22
81451 2020-04-23 San Francisco California 6075 1305 21
78657 2020-04-22 San Francisco California 6075 1236 21
75873 2020-04-21 San Francisco California 6075 1234 20
73097 2020-04-20 San Francisco California 6075 1219 20
70328 2020-04-19 San Francisco California 6075 1160 20
67566 2020-04-18 San Francisco California 6075 1140 20
64818 2020-04-17 San Francisco California 6075 1061 20
62085 2020-04-16 San Francisco California 6075 1022 17
59366 2020-04-15 San Francisco California 6075 1016 17
56658 2020-04-14 San Francisco California 6075 990 15
53966 2020-04-13 San Francisco California 6075 960 15
51287 2020-04-12 San Francisco California 6075 875 14
48625 2020-04-11 San Francisco California 6075 860 13
45995 2020-04-10 San Francisco California 6075 800 13
43395 2020-04-09 San Francisco California 6075 727 10
40823 2020-04-08 San Francisco California 6075 679 10
38279 2020-04-07 San Francisco California 6075 622 9
35790 2020-04-06 San Francisco California 6075 586 9
33345 2020-04-05 San Francisco California 6075 571 8
30939 2020-04-04 San Francisco California 6075 529 8
28581 2020-04-03 San Francisco California 6075 500 7
26282 2020-04-02 San Francisco California 6075 450 7
24053 2020-04-01 San Francisco California 6075 437 7
21895 2020-03-31 San Francisco California 6075 400 6
19820 2020-03-30 San Francisco California 6075 374 6
17843 2020-03-29 San Francisco California 6075 343 5
15954 2020-03-28 San Francisco California 6075 308 4
14172 2020-03-27 San Francisco California 6075 282 3
12506 2020-03-26 San Francisco California 6075 226 2
10961 2020-03-25 San Francisco California 6075 181 1
9589 2020-03-24 San Francisco California 6075 152 0
8346 2020-03-23 San Francisco California 6075 134 0
7203 2020-03-22 San Francisco California 6075 111 0
6169 2020-03-21 San Francisco California 6075 84 0
5248 2020-03-20 San Francisco California 6075 79 0
4473 2020-03-19 San Francisco California 6075 73 0
3813 2020-03-18 San Francisco California 6075 51 0
3259 2020-03-17 San Francisco California 6075 46 0
2777 2020-03-16 San Francisco California 6075 43 0
2342 2020-03-15 San Francisco California 6075 37 0
1962 2020-03-14 San Francisco California 6075 31 0
1645 2020-03-13 San Francisco California 6075 26 0
1384 2020-03-12 San Francisco California 6075 21 0
1178 2020-03-11 San Francisco California 6075 17 0
1012 2020-03-10 San Francisco California 6075 17 0
880 2020-03-09 San Francisco California 6075 16 0
766 2020-03-08 San Francisco California 6075 11 0
671 2020-03-07 San Francisco California 6075 11 0
594 2020-03-06 San Francisco California 6075 5 0
544 2020-03-05 San Francisco California 6075 5 0
505 2020-03-04 San Francisco California 6075 3 0
470 2020-03-03 San Francisco California 6075 3 0
436 2020-03-02 San Francisco California 6075 3 0
408 2020-03-01 San Francisco California 6075 3 0
385 2020-02-29 San Francisco California 6075 3 0
363 2020-02-28 San Francisco California 6075 3 0
343 2020-02-27 San Francisco California 6075 3 0
323 2020-02-26 San Francisco California 6075 3 0
304 2020-02-25 San Francisco California 6075 3 0
288 2020-02-24 San Francisco California 6075 3 0
274 2020-02-23 San Francisco California 6075 2 0
260 2020-02-22 San Francisco California 6075 2 0
246 2020-02-21 San Francisco California 6075 2 0
232 2020-02-20 San Francisco California 6075 2 0
219 2020-02-19 San Francisco California 6075 2 0
207 2020-02-18 San Francisco California 6075 2 0
195 2020-02-17 San Francisco California 6075 2 0
184 2020-02-16 San Francisco California 6075 2 0
173 2020-02-15 San Francisco California 6075 2 0
162 2020-02-14 San Francisco California 6075 2 0
151 2020-02-13 San Francisco California 6075 2 0
140 2020-02-12 San Francisco California 6075 2 0
130 2020-02-11 San Francisco California 6075 2 0
120 2020-02-10 San Francisco California 6075 2 0
110 2020-02-09 San Francisco California 6075 2 0
101 2020-02-08 San Francisco California 6075 2 0
92 2020-02-07 San Francisco California 6075 2 0
83 2020-02-06 San Francisco California 6075 2 0
74 2020-02-05 San Francisco California 6075 2 0
66 2020-02-04 San Francisco California 6075 2 0
58 2020-02-03 San Francisco California 6075 2 0
50 2020-02-02 San Francisco California 6075 2 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);