ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 34005 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 786 ✖
- 2 3
- 3 2
- 5 2
- 5461 2
- 44118 2
- 44159 2
- 101227 2
- 102870 2
- 4 1
- 10 1
- 14 1
- 17 1
- 20 1
- 26 1
- 36 1
- 42 1
- 48 1
- 64 1
- 88 1
- 115 1
- 142 1
- 178 1
- 202 1
- 255 1
- 294 1
- 367 1
- 469 1
- 547 1
- 646 1
- 733 1
- 801 1
- 883 1
- 954 1
- 1031 1
- 1095 1
- 1155 1
- 1207 1
- 1261 1
- 1326 1
- 1366 1
- 1456 1
- 1587 1
- 1663 1
- 1765 1
- 1878 1
- 1969 1
- 2054 1
- 2153 1
- 2333 1
- 2407 1
- 2543 1
- 2606 1
- 2690 1
- 2769 1
- 2879 1
- 3043 1
- 3100 1
- 3207 1
- 3235 1
- 3367 1
- 3431 1
- 3531 1
- 3574 1
- 3665 1
- 3697 1
- 3726 1
- 3782 1
- 3849 1
- 3875 1
- 3937 1
- 3986 1
- 4000 1
- 4058 1
- 4097 1
- 4217 1
- 4252 1
- 4308 1
- 4355 1
- 4381 1
- 4432 1
- 4476 1
- 4519 1
- 4567 1
- 4627 1
- 4657 1
- 4680 1
- 4700 1
- 4725 1
- 4746 1
- 4769 1
- 4785 1
- 4798 1
- 4808 1
- 4826 1
- 4832 1
- 4848 1
- 4866 1
- 4876 1
- 4894 1
- 4929 1
- 4935 1
- 4954 1
- 4981 1
- 4994 1
- 5023 1
- 5046 1
- 5056 1
- 5068 1
- 5122 1
- 5130 1
- 5163 1
- 5174 1
- 5180 1
- 5206 1
- 5227 1
- 5259 1
- 5276 1
- 5281 1
- 5300 1
- 5315 1
- 5333 1
- 5344 1
- 5357 1
- 5373 1
- 5401 1
- 5416 1
- 5423 1
- 5453 1
- 5472 1
- 5482 1
- 5484 1
- 5492 1
- 5520 1
- 5531 1
- 5543 1
- 5574 1
- 5608 1
- 5635 1
- 5683 1
- 5725 1
- 5761 1
- 5772 1
- 5821 1
- 5852 1
- 5871 1
- 5886 1
- 5920 1
- 5947 1
- 5967 1
- 5992 1
- 6017 1
- 6047 1
- 6065 1
- 6082 1
- 6108 1
- 6133 1
- 6147 1
- 6167 1
- 6184 1
- 6198 1
- 6214 1
- 6241 1
- 6268 1
- 6287 1
- 6300 1
- 6314 1
- 6327 1
- 6344 1
- 6353 1
- 6366 1
- 6393 1
- 6409 1
- 6421 1
- 6434 1
- 6460 1
- 6496 1
- 6538 1
- 6560 1
- 6580 1
- 6598 1
- 6620 1
- 6645 1
- 6662 1
- 6680 1
- 6700 1
- 6733 1
- 6755 1
- 6786 1
- 6821 1
- 6840 1
- 6869 1
- 6901 1
- 6940 1
- 6969 1
- 6985 1
- 7013 1
- 7045 1
- 7075 1
- 7103 1
- 7137 1
- 7166 1
- 7184 1
- 7208 1
- 7225 1
- 7249 1
- 7289 1
- 7322 1
- 7347 1
- 7368 1
- 7384 1
- 7408 1
- 7483 1
- 7525 1
- 7549 1
- 7586 1
- 7600 1
- 7639 1
- 7703 1
- 7744 1
- 7771 1
- 7817 1
- 7866 1
- 7926 1
- 7969 1
- 8019 1
- 8069 1
- 8116 1
- 8201 1
- 8242 1
- 8321 1
- 8375 1
- 8457 1
- 8527 1
- 8628 1
- 8664 1
- 8762 1
- 8835 1
- 8892 1
- 9002 1
- 9061 1
- 9167 1
- 9306 1
- 9396 1
- 9545 1
- 9671 1
- 9769 1
- 9899 1
- 10106 1
- 10263 1
- 10568 1
- 10673 1
- 10890 1
- 11061 1
- 11266 1
- 11452 1
- 11740 1
- 12037 1
- 12215 1
- 12585 1
- 12861 1
- 13064 1
- 13261 1
- 13328 1
- 13680 1
- 13847 1
- 14061 1
- 14247 1
- 14418 1
- 14691 1
- 15034 1
- 15349 1
- 15591 1
- 15829 1
- 16042 1
- 16309 1
- 16467 1
- 16781 1
- 16919 1
- 17224 1
- 17437 1
- 17675 1
- 17857 1
- 17986 1
- 18229 1
- 18511 1
- 18699 1
- 18990 1
- 19258 1
- 19562 1
- 19808 1
- 20106 1
- 20192 1
- 20371 1
- 20591 1
- 21014 1
- 21221 1
- 21512 1
- 21828 1
- 22047 1
- 24127 1
- 24576 1
- 24925 1
- 25271 1
- 25567 1
- 25938 1
- 26167 1
- 26361 1
- 26782 1
- 27200 1
- 27464 1
- 27790 1
- 28049 1
- 28288 1
- 28487 1
- 28717 1
- 28997 1
- 29277 1
- 29458 1
- 29765 1
- 30050 1
- 30248 1
- 30433 1
- 30661 1
- 30835 1
- 31111 1
- 31359 1
- 31577 1
- 31695 1
- 31886 1
- 32034 1
- 32202 1
- 32422 1
- 32610 1
- 32811 1
- 32919 1
- 33056 1
- 33215 1
- 33332 1
- 33456 1
- 33619 1
- 33723 1
- 33762 1
- 33890 1
- 34025 1
- 34132 1
- 34230 1
- 34473 1
- 34585 1
- 34677 1
- 34771 1
- 34879 1
- 35002 1
- 35130 1
- 35273 1
- 35369 1
- 35483 1
- 35600 1
- 35715 1
- 35842 1
- 35975 1
- 36125 1
- 36206 1
- 36326 1
- 36443 1
- 36584 1
- 36738 1
- 36879 1
- 37000 1
- 37136 1
- 37226 1
- 37336 1
- 37508 1
- 37675 1
- 37844 1
- 38004 1
- 38116 1
- 38258 1
- 38441 1
- 38595 1
- 38780 1
- 38946 1
- 39143 1
- 39319 1
- 39490 1
- 39691 1
- 39852 1
- 40095 1
- 40316 1
- 40494 1
- 40699 1
- 40821 1
- 40959 1
- 41085 1
- 41277 1
- 41460 1
- 41621 1
- 41771 1
- 41879 1
- 42083 1
- 42229 1
- 42374 1
- 42539 1
- 42701 1
- 42825 1
- 42935 1
- 43041 1
- 43165 1
- 43271 1
- 43389 1
- 43469 1
- 43519 1
- 43558 1
- 43615 1
- 43622 1
- 43694 1
- 43756 1
- 43840 1
- 43902 1
- 43966 1
- 43990 1
- 43996 1
- 44001 1
- 44005 1
- 44012 1
- 44020 1
- 44032 1
- 44041 1
- 44042 1
- 44043 1
- 44053 1
- 44060 1
- 44061 1
- 44063 1
- 44068 1
- 44081 1
- 44086 1
- 44088 1
- 44099 1
- 44105 1
- 44111 1
- 44119 1
- 44129 1
- 44147 1
- 44161 1
- 44169 1
- 44173 1
- 44176 1
- 44190 1
- 44196 1
- 44204 1
- 44210 1
- 44227 1
- 44243 1
- 44253 1
- 44260 1
- 44271 1
- 44278 1
- 44283 1
- 44296 1
- 44300 1
- 44304 1
- 44312 1
- 44319 1
- 44321 1
- 44335 1
- 44348 1
- 44354 1
- 44360 1
- 44370 1
- 44375 1
- 44389 1
- 44392 1
- 44399 1
- 44413 1
- 44430 1
- 44441 1
- 44450 1
- 44455 1
- 44462 1
- 44473 1
- 44486 1
- 44519 1
- 44523 1
- 44537 1
- 44547 1
- 44569 1
- 44584 1
- 44598 1
- 44627 1
- 44652 1
- 44671 1
- 44681 1
- 44704 1
- 44741 1
- 44777 1
- 44813 1
- 44860 1
- 44894 1
- 44920 1
- 44970 1
- 45024 1
- 45079 1
- 45132 1
- 45196 1
- 45250 1
- 45311 1
- 45378 1
- 45473 1
- 45567 1
- 45633 1
- 45731 1
- 45806 1
- 45867 1
- 45978 1
- 46092 1
- 46202 1
- 46322 1
- 46429 1
- 46505 1
- 46601 1
- 46687 1
- 46778 1
- 46895 1
- 47077 1
- 47201 1
- 47300 1
- 47392 1
- 47514 1
- 47649 1
- 47787 1
- 47977 1
- 48091 1
- 48211 1
- 48326 1
- 48430 1
- 48534 1
- 48737 1
- 48852 1
- 48963 1
- 49034 1
- 49164 1
- 49175 1
- 49412 1
- 49529 1
- 49678 1
- 49802 1
- 49907 1
- 50030 1
- 50120 1
- 50237 1
- 50383 1
- 50535 1
- 50693 1
- 50796 1
- 50897 1
- 51015 1
- 51137 1
- 51265 1
- 51395 1
- 51550 1
- 51617 1
- 51689 1
- 51810 1
- 51932 1
- 52064 1
- 52192 1
- 52289 1
- 52391 1
- 52464 1
- 52532 1
- 52663 1
- 52797 1
- 52917 1
- 53047 1
- 53147 1
- 53231 1
- 53317 1
- 53387 1
- 53485 1
- 53597 1
- 53689 1
- 53754 1
- 53820 1
- 53906 1
- 54004 1
- 54104 1
- 54194 1
- 54279 1
- 54339 1
- 54402 1
- 54498 1
- 54570 1
- 54710 1
- 54811 1
- 54903 1
- 54959 1
- 55007 1
- 55080 1
- 55140 1
- 55267 1
- 55354 1
- 55447 1
- 55508 1
- 55552 1
- 55651 1
- 55770 1
- 55911 1
- 56055 1
- 56173 1
- 56290 1
- 56388 1
- 56531 1
- 56665 1
- 56877 1
- 57029 1
- 57181 1
- 57299 1
- 57401 1
- 57590 1
- 57728 1
- 57916 1
- 58084 1
- 58182 1
- 58253 1
- 58417 1
- 58592 1
- 58836 1
- 59119 1
- 59416 1
- 59682 1
- 59967 1
- 60136 1
- 60328 1
- 60563 1
- 60822 1
- 61127 1
- 61365 1
- 61532 1
- 61679 1
- 61875 1
- 62115 1
- 62452 1
- 62774 1
- 63030 1
- 63333 1
- 63688 1
- 64002 1
- 64426 1
- 65001 1
- 65590 1
- 66261 1
- 66822 1
- 67221 1
- 67769 1
- 68592 1
- 69842 1
- 71326 1
- 72492 1
- 73576 1
- 74424 1
- 75768 1
- 77167 1
- 78653 1
- 80490 1
- 82084 1
- 83530 1
- 84509 1
- 85573 1
- 86601 1
- 87775 1
- 88911 1
- 89854 1
- 90658 1
- 91123 1
- 91598 1
- 92252 1
- 92975 1
- 93673 1
- 94240 1
- 94719 1
- 95042 1
- 95355 1
- 95770 1
- 96250 1
- 96617 1
- 96970 1
- 97192 1
- 97344 1
- 97534 1
- 97807 1
- 98068 1
- 98285 1
- 98513 1
- 98640 1
- 98763 1
- 98878 1
- 99041 1
- 99292 1
- 99579 1
- 99715 1
- 99797 1
- 99877 1
- 99977 1
- 100072 1
- 100219 1
- 100293 1
- 100348 1
- 100415 1
- 100426 1
- 100497 1
- 100548 1
- 100593 1
- 100683 1
- 100725 1
- 100776 1
- 100791 1
- 100821 1
- 100835 1
- 100870 1
- 100910 1
- 100972 1
- 101000 1
- 101035 1
- 101083 1
- 101130 1
- 101179 1
- 101264 1
- 101277 1
- 101307 1
- 101346 1
- 101383 1
- 101411 1
- 101448 1
- 101466 1
- 101489 1
- 101520 1
- 101563 1
- 101621 1
- 101659 1
- 101700 1
- 101732 1
- 101756 1
- 101808 1
- 101853 1
- 101903 1
- 101947 1
- 101993 1
- 102028 1
- 102073 1
- 102119 1
- 102181 1
- 102286 1
- 102359 1
- 102457 1
- 102536 1
- 102595 1
- 102680 1
- 102762 1
- 103083 1
- 103146 1
- 103186 1
- 103260 1
- 103377 1
- 103473 1
- 103602 1
- 103703 1
- 103759 1
- 103805 1
- 103905 1
- 104002 1
- 104145 1
- 104276 1
- 104428 1
- 104527 1
- 104677 1
- 104779 1
- 104925 1
- 105139 1
- 105285 1
- 105469 1
- 105592 1
- 105717 1
- 105926 1
- 106147 1
- 106613 1
- 106935 1
state 1
- New Jersey 795
fips 1
- 34005 · 795 ✖
county 1
- Burlington 795
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092 | 1092 | 2020-03-10 | Burlington | New Jersey | 34005 | 2 | 0 |
1274 | 1274 | 2020-03-11 | Burlington | New Jersey | 34005 | 2 | 0 |
1503 | 1503 | 2020-03-12 | Burlington | New Jersey | 34005 | 2 | 0 |
1795 | 1795 | 2020-03-13 | Burlington | New Jersey | 34005 | 3 | 0 |
2141 | 2141 | 2020-03-14 | Burlington | New Jersey | 34005 | 3 | 0 |
2549 | 2549 | 2020-03-15 | Burlington | New Jersey | 34005 | 4 | 0 |
3005 | 3005 | 2020-03-16 | Burlington | New Jersey | 34005 | 5 | 0 |
3517 | 3517 | 2020-03-17 | Burlington | New Jersey | 34005 | 5 | 0 |
4113 | 4113 | 2020-03-18 | Burlington | New Jersey | 34005 | 10 | 0 |
4839 | 4839 | 2020-03-19 | Burlington | New Jersey | 34005 | 14 | 0 |
5682 | 5682 | 2020-03-20 | Burlington | New Jersey | 34005 | 17 | 0 |
6675 | 6675 | 2020-03-21 | Burlington | New Jersey | 34005 | 20 | 0 |
7766 | 7766 | 2020-03-22 | Burlington | New Jersey | 34005 | 26 | 0 |
8962 | 8962 | 2020-03-23 | Burlington | New Jersey | 34005 | 36 | 0 |
10266 | 10266 | 2020-03-24 | Burlington | New Jersey | 34005 | 42 | 0 |
11698 | 11698 | 2020-03-25 | Burlington | New Jersey | 34005 | 48 | 1 |
13301 | 13301 | 2020-03-26 | Burlington | New Jersey | 34005 | 64 | 3 |
15033 | 15033 | 2020-03-27 | Burlington | New Jersey | 34005 | 88 | 3 |
16862 | 16862 | 2020-03-28 | Burlington | New Jersey | 34005 | 115 | 3 |
18786 | 18786 | 2020-03-29 | Burlington | New Jersey | 34005 | 142 | 3 |
20824 | 20824 | 2020-03-30 | Burlington | New Jersey | 34005 | 178 | 5 |
22947 | 22947 | 2020-03-31 | Burlington | New Jersey | 34005 | 202 | 5 |
25138 | 25138 | 2020-04-01 | Burlington | New Jersey | 34005 | 255 | 5 |
27398 | 27398 | 2020-04-02 | Burlington | New Jersey | 34005 | 294 | 8 |
29721 | 29721 | 2020-04-03 | Burlington | New Jersey | 34005 | 367 | 9 |
32106 | 32106 | 2020-04-04 | Burlington | New Jersey | 34005 | 469 | 10 |
34537 | 34537 | 2020-04-05 | Burlington | New Jersey | 34005 | 547 | 11 |
37007 | 37007 | 2020-04-06 | Burlington | New Jersey | 34005 | 646 | 11 |
39522 | 39522 | 2020-04-07 | Burlington | New Jersey | 34005 | 733 | 13 |
42079 | 42079 | 2020-04-08 | Burlington | New Jersey | 34005 | 801 | 17 |
44661 | 44661 | 2020-04-09 | Burlington | New Jersey | 34005 | 883 | 21 |
47273 | 47273 | 2020-04-10 | Burlington | New Jersey | 34005 | 954 | 22 |
49927 | 49927 | 2020-04-11 | Burlington | New Jersey | 34005 | 1031 | 22 |
52600 | 52600 | 2020-04-12 | Burlington | New Jersey | 34005 | 1095 | 23 |
55283 | 55283 | 2020-04-13 | Burlington | New Jersey | 34005 | 1155 | 24 |
57983 | 57983 | 2020-04-14 | Burlington | New Jersey | 34005 | 1207 | 28 |
60697 | 60697 | 2020-04-15 | Burlington | New Jersey | 34005 | 1261 | 45 |
63423 | 63423 | 2020-04-16 | Burlington | New Jersey | 34005 | 1326 | 52 |
66165 | 66165 | 2020-04-17 | Burlington | New Jersey | 34005 | 1366 | 54 |
68921 | 68921 | 2020-04-18 | Burlington | New Jersey | 34005 | 1456 | 57 |
71688 | 71688 | 2020-04-19 | Burlington | New Jersey | 34005 | 1587 | 58 |
74463 | 74463 | 2020-04-20 | Burlington | New Jersey | 34005 | 1663 | 61 |
77244 | 77244 | 2020-04-21 | Burlington | New Jersey | 34005 | 1765 | 66 |
80033 | 80033 | 2020-04-22 | Burlington | New Jersey | 34005 | 1878 | 68 |
82831 | 82831 | 2020-04-23 | Burlington | New Jersey | 34005 | 1969 | 76 |
85635 | 85635 | 2020-04-24 | Burlington | New Jersey | 34005 | 2054 | 81 |
88446 | 88446 | 2020-04-25 | Burlington | New Jersey | 34005 | 2153 | 88 |
91261 | 91261 | 2020-04-26 | Burlington | New Jersey | 34005 | 2333 | 94 |
94085 | 94085 | 2020-04-27 | Burlington | New Jersey | 34005 | 2407 | 98 |
96921 | 96921 | 2020-04-28 | Burlington | New Jersey | 34005 | 2543 | 106 |
99768 | 99768 | 2020-04-29 | Burlington | New Jersey | 34005 | 2606 | 117 |
102621 | 102621 | 2020-04-30 | Burlington | New Jersey | 34005 | 2690 | 130 |
105483 | 105483 | 2020-05-01 | Burlington | New Jersey | 34005 | 2769 | 144 |
108349 | 108349 | 2020-05-02 | Burlington | New Jersey | 34005 | 2879 | 146 |
111222 | 111222 | 2020-05-03 | Burlington | New Jersey | 34005 | 3043 | 149 |
114103 | 114103 | 2020-05-04 | Burlington | New Jersey | 34005 | 3100 | 149 |
116984 | 116984 | 2020-05-05 | Burlington | New Jersey | 34005 | 3207 | 164 |
119945 | 119945 | 2020-05-06 | Burlington | New Jersey | 34005 | 3235 | 177 |
122920 | 122920 | 2020-05-07 | Burlington | New Jersey | 34005 | 3367 | 185 |
125903 | 125903 | 2020-05-08 | Burlington | New Jersey | 34005 | 3431 | 190 |
128892 | 128892 | 2020-05-09 | Burlington | New Jersey | 34005 | 3531 | 194 |
131881 | 131881 | 2020-05-10 | Burlington | New Jersey | 34005 | 3574 | 198 |
134872 | 134872 | 2020-05-11 | Burlington | New Jersey | 34005 | 3665 | 200 |
137862 | 137862 | 2020-05-12 | Burlington | New Jersey | 34005 | 3697 | 208 |
140858 | 140858 | 2020-05-13 | Burlington | New Jersey | 34005 | 3726 | 214 |
143853 | 143853 | 2020-05-14 | Burlington | New Jersey | 34005 | 3782 | 228 |
146854 | 146854 | 2020-05-15 | Burlington | New Jersey | 34005 | 3849 | 238 |
149861 | 149861 | 2020-05-16 | Burlington | New Jersey | 34005 | 3875 | 239 |
152871 | 152871 | 2020-05-17 | Burlington | New Jersey | 34005 | 3937 | 239 |
155887 | 155887 | 2020-05-18 | Burlington | New Jersey | 34005 | 3986 | 245 |
158905 | 158905 | 2020-05-19 | Burlington | New Jersey | 34005 | 4000 | 247 |
161931 | 161931 | 2020-05-20 | Burlington | New Jersey | 34005 | 4058 | 249 |
164960 | 164960 | 2020-05-21 | Burlington | New Jersey | 34005 | 4097 | 249 |
167996 | 167996 | 2020-05-22 | Burlington | New Jersey | 34005 | 4217 | 261 |
171035 | 171035 | 2020-05-23 | Burlington | New Jersey | 34005 | 4252 | 266 |
174077 | 174077 | 2020-05-24 | Burlington | New Jersey | 34005 | 4308 | 270 |
177120 | 177120 | 2020-05-25 | Burlington | New Jersey | 34005 | 4355 | 271 |
180164 | 180164 | 2020-05-26 | Burlington | New Jersey | 34005 | 4381 | 273 |
183212 | 183212 | 2020-05-27 | Burlington | New Jersey | 34005 | 4432 | 275 |
186269 | 186269 | 2020-05-28 | Burlington | New Jersey | 34005 | 4476 | 277 |
189329 | 189329 | 2020-05-29 | Burlington | New Jersey | 34005 | 4519 | 286 |
192393 | 192393 | 2020-05-30 | Burlington | New Jersey | 34005 | 4567 | 290 |
195463 | 195463 | 2020-05-31 | Burlington | New Jersey | 34005 | 4627 | 291 |
198536 | 198536 | 2020-06-01 | Burlington | New Jersey | 34005 | 4657 | 294 |
201610 | 201610 | 2020-06-02 | Burlington | New Jersey | 34005 | 4680 | 297 |
204687 | 204687 | 2020-06-03 | Burlington | New Jersey | 34005 | 4700 | 302 |
207768 | 207768 | 2020-06-04 | Burlington | New Jersey | 34005 | 4725 | 307 |
210850 | 210850 | 2020-06-05 | Burlington | New Jersey | 34005 | 4746 | 311 |
213934 | 213934 | 2020-06-06 | Burlington | New Jersey | 34005 | 4769 | 314 |
217023 | 217023 | 2020-06-07 | Burlington | New Jersey | 34005 | 4785 | 327 |
220115 | 220115 | 2020-06-08 | Burlington | New Jersey | 34005 | 4798 | 327 |
223210 | 223210 | 2020-06-09 | Burlington | New Jersey | 34005 | 4808 | 334 |
226310 | 226310 | 2020-06-10 | Burlington | New Jersey | 34005 | 4826 | 344 |
229414 | 229414 | 2020-06-11 | Burlington | New Jersey | 34005 | 4832 | 349 |
232519 | 232519 | 2020-06-12 | Burlington | New Jersey | 34005 | 4848 | 350 |
235624 | 235624 | 2020-06-13 | Burlington | New Jersey | 34005 | 4866 | 356 |
238731 | 238731 | 2020-06-14 | Burlington | New Jersey | 34005 | 4876 | 363 |
241841 | 241841 | 2020-06-15 | Burlington | New Jersey | 34005 | 4894 | 364 |
244953 | 244953 | 2020-06-16 | Burlington | New Jersey | 34005 | 4929 | 364 |
248066 | 248066 | 2020-06-17 | Burlington | New Jersey | 34005 | 4935 | 364 |
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);