ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 42045 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 758 ✖
- 1 7
- 112267 7
- 7165 3
- 113339 3
- 6 2
- 7 2
- 14 2
- 6234 2
- 6661 2
- 6894 2
- 7097 2
- 7299 2
- 7543 2
- 9171 2
- 10524 2
- 10588 2
- 10857 2
- 11113 2
- 11348 2
- 11653 2
- 51869 2
- 52353 2
- 52389 2
- 52423 2
- 52958 2
- 53453 2
- 62391 2
- 108479 2
- 109795 2
- 9 1
- 23 1
- 33 1
- 43 1
- 54 1
- 84 1
- 101 1
- 156 1
- 185 1
- 226 1
- 276 1
- 303 1
- 338 1
- 390 1
- 470 1
- 542 1
- 616 1
- 708 1
- 822 1
- 898 1
- 1034 1
- 1222 1
- 1377 1
- 1510 1
- 1594 1
- 1712 1
- 1851 1
- 1935 1
- 2055 1
- 2281 1
- 2372 1
- 2460 1
- 2545 1
- 2698 1
- 2798 1
- 2963 1
- 3106 1
- 3213 1
- 3333 1
- 3405 1
- 3514 1
- 3672 1
- 3747 1
- 3895 1
- 4053 1
- 4173 1
- 4256 1
- 4326 1
- 4430 1
- 4554 1
- 4739 1
- 4894 1
- 5032 1
- 5101 1
- 5136 1
- 5208 1
- 5305 1
- 5409 1
- 5555 1
- 5619 1
- 5689 1
- 5807 1
- 5844 1
- 5969 1
- 6112 1
- 6168 1
- 6295 1
- 6341 1
- 6389 1
- 6428 1
- 6473 1
- 6510 1
- 6529 1
- 6545 1
- 6600 1
- 6639 1
- 6743 1
- 6754 1
- 6789 1
- 6811 1
- 6863 1
- 6944 1
- 6978 1
- 6991 1
- 7021 1
- 7037 1
- 7050 1
- 7069 1
- 7084 1
- 7127 1
- 7142 1
- 7215 1
- 7248 1
- 7275 1
- 7303 1
- 7334 1
- 7393 1
- 7429 1
- 7475 1
- 7496 1
- 7548 1
- 7569 1
- 7650 1
- 7698 1
- 7744 1
- 7808 1
- 7815 1
- 7863 1
- 7950 1
- 7962 1
- 8047 1
- 8097 1
- 8190 1
- 8250 1
- 8285 1
- 8371 1
- 8535 1
- 8596 1
- 8656 1
- 8669 1
- 8770 1
- 8804 1
- 8902 1
- 8997 1
- 9078 1
- 9123 1
- 9226 1
- 9322 1
- 9392 1
- 9482 1
- 9541 1
- 9593 1
- 9635 1
- 9691 1
- 9770 1
- 9832 1
- 9867 1
- 9950 1
- 9990 1
- 10011 1
- 10045 1
- 10120 1
- 10152 1
- 10188 1
- 10233 1
- 10279 1
- 10281 1
- 10317 1
- 10402 1
- 10472 1
- 10625 1
- 10659 1
- 10727 1
- 10762 1
- 10806 1
- 10852 1
- 10966 1
- 11004 1
- 11045 1
- 11082 1
- 11125 1
- 11194 1
- 11228 1
- 11270 1
- 11315 1
- 11401 1
- 11422 1
- 11521 1
- 11572 1
- 11612 1
- 11716 1
- 11771 1
- 11803 1
- 11880 1
- 11935 1
- 11986 1
- 12062 1
- 12111 1
- 12185 1
- 12257 1
- 12306 1
- 12365 1
- 12430 1
- 12510 1
- 12572 1
- 12632 1
- 12734 1
- 12770 1
- 12865 1
- 12976 1
- 13090 1
- 13144 1
- 13269 1
- 13397 1
- 13527 1
- 13618 1
- 13754 1
- 13888 1
- 14001 1
- 14081 1
- 14219 1
- 14359 1
- 14477 1
- 14648 1
- 14865 1
- 15020 1
- 15232 1
- 15402 1
- 15592 1
- 15832 1
- 16056 1
- 16340 1
- 16595 1
- 16736 1
- 16963 1
- 17294 1
- 17625 1
- 17899 1
- 18172 1
- 18404 1
- 18604 1
- 18829 1
- 19019 1
- 19401 1
- 19649 1
- 19877 1
- 20057 1
- 20166 1
- 20364 1
- 20762 1
- 21211 1
- 21560 1
- 21953 1
- 22258 1
- 22470 1
- 22761 1
- 23010 1
- 23408 1
- 23810 1
- 24126 1
- 24420 1
- 24627 1
- 24917 1
- 25218 1
- 25450 1
- 25757 1
- 26061 1
- 26299 1
- 26639 1
- 26905 1
- 27168 1
- 27515 1
- 27736 1
- 27991 1
- 28182 1
- 28406 1
- 28738 1
- 29371 1
- 29745 1
- 29944 1
- 30182 1
- 30337 1
- 30443 1
- 30786 1
- 31063 1
- 31675 1
- 32008 1
- 32337 1
- 32640 1
- 32836 1
- 33132 1
- 33407 1
- 33696 1
- 33933 1
- 34188 1
- 34398 1
- 34536 1
- 34717 1
- 34955 1
- 35169 1
- 35351 1
- 35642 1
- 35855 1
- 36048 1
- 36252 1
- 36447 1
- 36636 1
- 37027 1
- 37190 1
- 37339 1
- 37443 1
- 37617 1
- 37727 1
- 37868 1
- 37983 1
- 38137 1
- 38324 1
- 38461 1
- 38616 1
- 38751 1
- 38901 1
- 39041 1
- 39222 1
- 39312 1
- 39393 1
- 39479 1
- 39642 1
- 39778 1
- 39905 1
- 39983 1
- 40052 1
- 40132 1
- 40241 1
- 40383 1
- 40512 1
- 40700 1
- 40849 1
- 40957 1
- 41033 1
- 41132 1
- 41224 1
- 41315 1
- 41427 1
- 41601 1
- 41765 1
- 41841 1
- 41923 1
- 42015 1
- 42118 1
- 42232 1
- 42325 1
- 42429 1
- 42502 1
- 42598 1
- 42704 1
- 42772 1
- 42897 1
- 43081 1
- 43191 1
- 43248 1
- 43357 1
- 43530 1
- 43647 1
- 43859 1
- 44040 1
- 44208 1
- 44363 1
- 44618 1
- 44791 1
- 44969 1
- 45211 1
- 45443 1
- 45656 1
- 45808 1
- 45953 1
- 46140 1
- 46357 1
- 46548 1
- 46778 1
- 46933 1
- 47049 1
- 47427 1
- 47653 1
- 47885 1
- 48136 1
- 48406 1
- 48639 1
- 48757 1
- 48964 1
- 49196 1
- 49343 1
- 49544 1
- 49713 1
- 49841 1
- 49916 1
- 50028 1
- 50151 1
- 50283 1
- 50475 1
- 50582 1
- 50680 1
- 50743 1
- 50814 1
- 50908 1
- 51006 1
- 51114 1
- 51188 1
- 51240 1
- 51293 1
- 51348 1
- 51438 1
- 51491 1
- 51557 1
- 51614 1
- 51650 1
- 51677 1
- 51728 1
- 51759 1
- 51789 1
- 51959 1
- 51978 1
- 51995 1
- 52020 1
- 52053 1
- 52085 1
- 52113 1
- 52131 1
- 52146 1
- 52164 1
- 52165 1
- 52194 1
- 52210 1
- 52247 1
- 52255 1
- 52269 1
- 52283 1
- 52309 1
- 52327 1
- 52328 1
- 52335 1
- 52338 1
- 52347 1
- 52349 1
- 52350 1
- 52356 1
- 52358 1
- 52360 1
- 52362 1
- 52366 1
- 52367 1
- 52370 1
- 52375 1
- 52379 1
- 52383 1
- 52394 1
- 52401 1
- 52408 1
- 52415 1
- 52434 1
- 52451 1
- 52460 1
- 52474 1
- 52483 1
- 52488 1
- 52501 1
- 52510 1
- 52522 1
- 52530 1
- 52541 1
- 52551 1
- 52565 1
- 52579 1
- 52601 1
- 52636 1
- 52672 1
- 52708 1
- 52725 1
- 52762 1
- 52813 1
- 52854 1
- 52900 1
- 53038 1
- 53092 1
- 53162 1
- 53221 1
- 53292 1
- 53366 1
- 53567 1
- 53663 1
- 53718 1
- 53802 1
- 53878 1
- 53944 1
- 54029 1
- 54092 1
- 54156 1
- 54242 1
- 54354 1
- 54459 1
- 54562 1
- 54659 1
- 54734 1
- 54833 1
- 54969 1
- 55128 1
- 55287 1
- 55450 1
- 55554 1
- 55649 1
- 55757 1
- 55914 1
- 56048 1
- 56195 1
- 56327 1
- 56431 1
- 56505 1
- 56601 1
- 56762 1
- 56845 1
- 57012 1
- 57161 1
- 57265 1
- 57349 1
- 57430 1
- 57551 1
- 57698 1
- 57858 1
- 57938 1
- 58042 1
- 58109 1
- 58208 1
- 58338 1
- 58449 1
- 58522 1
- 58626 1
- 58750 1
- 58815 1
- 58929 1
- 59037 1
- 59157 1
- 59323 1
- 59376 1
- 59477 1
- 59569 1
- 59637 1
- 59850 1
- 59983 1
- 60077 1
- 60224 1
- 60327 1
- 60385 1
- 60476 1
- 60616 1
- 60717 1
- 60839 1
- 60914 1
- 61037 1
- 61104 1
- 61206 1
- 61284 1
- 61404 1
- 61501 1
- 61635 1
- 61759 1
- 61810 1
- 61932 1
- 62010 1
- 62107 1
- 62205 1
- 62298 1
- 62533 1
- 62601 1
- 62715 1
- 62809 1
- 62896 1
- 62967 1
- 63026 1
- 63125 1
- 63226 1
- 63351 1
- 63441 1
- 64082 1
- 64214 1
- 64267 1
- 64385 1
- 64481 1
- 64640 1
- 64791 1
- 64919 1
- 65041 1
- 65145 1
- 65302 1
- 65455 1
- 65592 1
- 65748 1
- 65854 1
- 65944 1
- 66035 1
- 66167 1
- 66368 1
- 66601 1
- 66950 1
- 67112 1
- 67219 1
- 67302 1
- 67576 1
- 67754 1
- 68028 1
- 68413 1
- 68673 1
- 68979 1
- 69145 1
- 69378 1
- 69551 1
- 69868 1
- 70201 1
- 70552 1
- 70858 1
- 71061 1
- 71444 1
- 71845 1
- 72308 1
- 73142 1
- 73722 1
- 74344 1
- 74693 1
- 75511 1
- 76786 1
- 77947 1
- 79520 1
- 80991 1
- 82044 1
- 83381 1
- 84648 1
- 86243 1
- 87730 1
- 89555 1
- 90745 1
- 92202 1
- 93468 1
- 94598 1
- 95870 1
- 96870 1
- 97865 1
- 98803 1
- 100000 1
- 100388 1
- 100923 1
- 101525 1
- 102339 1
- 102747 1
- 103272 1
- 103646 1
- 103940 1
- 104297 1
- 104675 1
- 105135 1
- 105558 1
- 105820 1
- 106039 1
- 106126 1
- 106289 1
- 106549 1
- 106731 1
- 106970 1
- 107313 1
- 107369 1
- 107380 1
- 107503 1
- 107637 1
- 107763 1
- 107835 1
- 107890 1
- 107946 1
- 107988 1
- 108048 1
- 108116 1
- 108205 1
- 108282 1
- 108416 1
- 108557 1
- 108594 1
- 108643 1
- 108698 1
- 108768 1
- 108791 1
- 108809 1
- 108839 1
- 108876 1
- 108915 1
- 108944 1
- 108978 1
- 108996 1
- 109027 1
- 109055 1
- 109076 1
- 109118 1
- 109144 1
- 109163 1
- 109176 1
- 109184 1
- 109240 1
- 109281 1
- 109307 1
- 109344 1
- 109361 1
- 109375 1
- 109393 1
- 109424 1
- 109443 1
- 109494 1
- 109528 1
- 109560 1
- 109582 1
- 109604 1
- 109629 1
- 109673 1
- 109714 1
- 109759 1
- 109857 1
- 109891 1
- 109938 1
- 109985 1
- 110040 1
- 110096 1
- 110142 1
- 110187 1
- 110242 1
- 110302 1
- 110405 1
- 110466 1
- 110539 1
- 110601 1
- 110653 1
- 110730 1
- 110811 1
- 110897 1
- 111008 1
- 111106 1
- 111171 1
- 111261 1
- 111306 1
- 111435 1
- 111561 1
- 111698 1
- 111818 1
- 111923 1
- 112020 1
- 112127 1
state 1
- Pennsylvania 799
fips 1
- 42045 · 799 ✖
county 1
- Delaware 799
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
635 | 635 | 2020-03-06 | Delaware | Pennsylvania | 42045 | 1 | 0 |
726 | 726 | 2020-03-07 | Delaware | Pennsylvania | 42045 | 1 | 0 |
835 | 835 | 2020-03-08 | Delaware | Pennsylvania | 42045 | 1 | 0 |
963 | 963 | 2020-03-09 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1115 | 1115 | 2020-03-10 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1309 | 1309 | 2020-03-11 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1553 | 1553 | 2020-03-12 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1851 | 1851 | 2020-03-13 | Delaware | Pennsylvania | 42045 | 6 | 0 |
2213 | 2213 | 2020-03-14 | Delaware | Pennsylvania | 42045 | 6 | 0 |
2633 | 2633 | 2020-03-15 | Delaware | Pennsylvania | 42045 | 7 | 0 |
3098 | 3098 | 2020-03-16 | Delaware | Pennsylvania | 42045 | 7 | 0 |
3628 | 3628 | 2020-03-17 | Delaware | Pennsylvania | 42045 | 9 | 0 |
4245 | 4245 | 2020-03-18 | Delaware | Pennsylvania | 42045 | 14 | 0 |
4984 | 4984 | 2020-03-19 | Delaware | Pennsylvania | 42045 | 14 | 0 |
5854 | 5854 | 2020-03-20 | Delaware | Pennsylvania | 42045 | 23 | 0 |
6857 | 6857 | 2020-03-21 | Delaware | Pennsylvania | 42045 | 33 | 0 |
7974 | 7974 | 2020-03-22 | Delaware | Pennsylvania | 42045 | 43 | 0 |
9185 | 9185 | 2020-03-23 | Delaware | Pennsylvania | 42045 | 54 | 0 |
10508 | 10508 | 2020-03-24 | Delaware | Pennsylvania | 42045 | 84 | 0 |
11970 | 11970 | 2020-03-25 | Delaware | Pennsylvania | 42045 | 101 | 0 |
13590 | 13590 | 2020-03-26 | Delaware | Pennsylvania | 42045 | 156 | 1 |
15336 | 15336 | 2020-03-27 | Delaware | Pennsylvania | 42045 | 185 | 3 |
17185 | 17185 | 2020-03-28 | Delaware | Pennsylvania | 42045 | 226 | 4 |
19123 | 19123 | 2020-03-29 | Delaware | Pennsylvania | 42045 | 276 | 4 |
21173 | 21173 | 2020-03-30 | Delaware | Pennsylvania | 42045 | 303 | 4 |
23309 | 23309 | 2020-03-31 | Delaware | Pennsylvania | 42045 | 338 | 6 |
25507 | 25507 | 2020-04-01 | Delaware | Pennsylvania | 42045 | 390 | 7 |
27779 | 27779 | 2020-04-02 | Delaware | Pennsylvania | 42045 | 470 | 8 |
30113 | 30113 | 2020-04-03 | Delaware | Pennsylvania | 42045 | 542 | 10 |
32503 | 32503 | 2020-04-04 | Delaware | Pennsylvania | 42045 | 616 | 13 |
34938 | 34938 | 2020-04-05 | Delaware | Pennsylvania | 42045 | 708 | 14 |
37413 | 37413 | 2020-04-06 | Delaware | Pennsylvania | 42045 | 822 | 15 |
39934 | 39934 | 2020-04-07 | Delaware | Pennsylvania | 42045 | 898 | 20 |
42494 | 42494 | 2020-04-08 | Delaware | Pennsylvania | 42045 | 1034 | 23 |
45080 | 45080 | 2020-04-09 | Delaware | Pennsylvania | 42045 | 1222 | 26 |
47697 | 47697 | 2020-04-10 | Delaware | Pennsylvania | 42045 | 1377 | 30 |
50354 | 50354 | 2020-04-11 | Delaware | Pennsylvania | 42045 | 1510 | 39 |
53027 | 53027 | 2020-04-12 | Delaware | Pennsylvania | 42045 | 1594 | 39 |
55712 | 55712 | 2020-04-13 | Delaware | Pennsylvania | 42045 | 1712 | 40 |
58415 | 58415 | 2020-04-14 | Delaware | Pennsylvania | 42045 | 1851 | 46 |
61130 | 61130 | 2020-04-15 | Delaware | Pennsylvania | 42045 | 1935 | 60 |
63856 | 63856 | 2020-04-16 | Delaware | Pennsylvania | 42045 | 2055 | 71 |
66602 | 66602 | 2020-04-17 | Delaware | Pennsylvania | 42045 | 2281 | 74 |
69360 | 69360 | 2020-04-18 | Delaware | Pennsylvania | 42045 | 2372 | 78 |
72127 | 72127 | 2020-04-19 | Delaware | Pennsylvania | 42045 | 2460 | 91 |
74902 | 74902 | 2020-04-20 | Delaware | Pennsylvania | 42045 | 2545 | 100 |
77684 | 77684 | 2020-04-21 | Delaware | Pennsylvania | 42045 | 2698 | 118 |
80474 | 80474 | 2020-04-22 | Delaware | Pennsylvania | 42045 | 2798 | 124 |
83273 | 83273 | 2020-04-23 | Delaware | Pennsylvania | 42045 | 2963 | 124 |
86077 | 86077 | 2020-04-24 | Delaware | Pennsylvania | 42045 | 3106 | 131 |
88891 | 88891 | 2020-04-25 | Delaware | Pennsylvania | 42045 | 3213 | 142 |
91707 | 91707 | 2020-04-26 | Delaware | Pennsylvania | 42045 | 3333 | 143 |
94534 | 94534 | 2020-04-27 | Delaware | Pennsylvania | 42045 | 3405 | 145 |
97373 | 97373 | 2020-04-28 | Delaware | Pennsylvania | 42045 | 3514 | 164 |
100222 | 100222 | 2020-04-29 | Delaware | Pennsylvania | 42045 | 3672 | 224 |
103075 | 103075 | 2020-04-30 | Delaware | Pennsylvania | 42045 | 3747 | 235 |
105938 | 105938 | 2020-05-01 | Delaware | Pennsylvania | 42045 | 3895 | 240 |
108805 | 108805 | 2020-05-02 | Delaware | Pennsylvania | 42045 | 4053 | 255 |
111679 | 111679 | 2020-05-03 | Delaware | Pennsylvania | 42045 | 4173 | 255 |
114561 | 114561 | 2020-05-04 | Delaware | Pennsylvania | 42045 | 4256 | 258 |
117442 | 117442 | 2020-05-05 | Delaware | Pennsylvania | 42045 | 4326 | 320 |
120404 | 120404 | 2020-05-06 | Delaware | Pennsylvania | 42045 | 4430 | 326 |
123381 | 123381 | 2020-05-07 | Delaware | Pennsylvania | 42045 | 4554 | 376 |
126364 | 126364 | 2020-05-08 | Delaware | Pennsylvania | 42045 | 4739 | 382 |
129353 | 129353 | 2020-05-09 | Delaware | Pennsylvania | 42045 | 4894 | 394 |
132342 | 132342 | 2020-05-10 | Delaware | Pennsylvania | 42045 | 5032 | 395 |
135333 | 135333 | 2020-05-11 | Delaware | Pennsylvania | 42045 | 5101 | 399 |
138323 | 138323 | 2020-05-12 | Delaware | Pennsylvania | 42045 | 5136 | 405 |
141319 | 141319 | 2020-05-13 | Delaware | Pennsylvania | 42045 | 5208 | 419 |
144315 | 144315 | 2020-05-14 | Delaware | Pennsylvania | 42045 | 5305 | 448 |
147316 | 147316 | 2020-05-15 | Delaware | Pennsylvania | 42045 | 5409 | 466 |
150323 | 150323 | 2020-05-16 | Delaware | Pennsylvania | 42045 | 5555 | 478 |
153334 | 153334 | 2020-05-17 | Delaware | Pennsylvania | 42045 | 5619 | 478 |
156351 | 156351 | 2020-05-18 | Delaware | Pennsylvania | 42045 | 5689 | 478 |
159372 | 159372 | 2020-05-19 | Delaware | Pennsylvania | 42045 | 5807 | 491 |
162399 | 162399 | 2020-05-20 | Delaware | Pennsylvania | 42045 | 5844 | 491 |
165428 | 165428 | 2020-05-21 | Delaware | Pennsylvania | 42045 | 5969 | 491 |
168464 | 168464 | 2020-05-22 | Delaware | Pennsylvania | 42045 | 6112 | 518 |
171503 | 171503 | 2020-05-23 | Delaware | Pennsylvania | 42045 | 6168 | 521 |
174545 | 174545 | 2020-05-24 | Delaware | Pennsylvania | 42045 | 6234 | 521 |
177589 | 177589 | 2020-05-25 | Delaware | Pennsylvania | 42045 | 6234 | 524 |
180632 | 180632 | 2020-05-26 | Delaware | Pennsylvania | 42045 | 6295 | 524 |
183682 | 183682 | 2020-05-27 | Delaware | Pennsylvania | 42045 | 6341 | 536 |
186739 | 186739 | 2020-05-28 | Delaware | Pennsylvania | 42045 | 6389 | 544 |
189800 | 189800 | 2020-05-29 | Delaware | Pennsylvania | 42045 | 6428 | 550 |
192865 | 192865 | 2020-05-30 | Delaware | Pennsylvania | 42045 | 6473 | 558 |
195934 | 195934 | 2020-05-31 | Delaware | Pennsylvania | 42045 | 6510 | 558 |
199007 | 199007 | 2020-06-01 | Delaware | Pennsylvania | 42045 | 6529 | 559 |
202082 | 202082 | 2020-06-02 | Delaware | Pennsylvania | 42045 | 6545 | 567 |
205159 | 205159 | 2020-06-03 | Delaware | Pennsylvania | 42045 | 6600 | 576 |
208240 | 208240 | 2020-06-04 | Delaware | Pennsylvania | 42045 | 6639 | 614 |
211322 | 211322 | 2020-06-05 | Delaware | Pennsylvania | 42045 | 6661 | 645 |
214408 | 214408 | 2020-06-06 | Delaware | Pennsylvania | 42045 | 6661 | 651 |
217498 | 217498 | 2020-06-07 | Delaware | Pennsylvania | 42045 | 6743 | 651 |
220590 | 220590 | 2020-06-08 | Delaware | Pennsylvania | 42045 | 6754 | 651 |
223685 | 223685 | 2020-06-09 | Delaware | Pennsylvania | 42045 | 6789 | 652 |
226785 | 226785 | 2020-06-10 | Delaware | Pennsylvania | 42045 | 6811 | 662 |
229889 | 229889 | 2020-06-11 | Delaware | Pennsylvania | 42045 | 6863 | 662 |
232994 | 232994 | 2020-06-12 | Delaware | Pennsylvania | 42045 | 6894 | 664 |
236099 | 236099 | 2020-06-13 | Delaware | Pennsylvania | 42045 | 6894 | 664 |
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);