ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lebanon" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 753 ✖
- 36833 7
- 3 4
- 16204 4
- 16181 3
- 37011 3
- 1 2
- 1383 2
- 1663 2
- 1814 2
- 2112 2
- 15970 2
- 16171 2
- 16197 2
- 16201 2
- 16210 2
- 16211 2
- 16310 2
- 16431 2
- 20707 2
- 35839 2
- 36209 2
- 36513 2
- 2 1
- 4 1
- 12 1
- 15 1
- 19 1
- 27 1
- 28 1
- 36 1
- 45 1
- 54 1
- 87 1
- 106 1
- 124 1
- 145 1
- 169 1
- 187 1
- 218 1
- 232 1
- 270 1
- 284 1
- 328 1
- 349 1
- 380 1
- 424 1
- 458 1
- 484 1
- 502 1
- 525 1
- 535 1
- 544 1
- 575 1
- 592 1
- 612 1
- 621 1
- 635 1
- 648 1
- 676 1
- 694 1
- 710 1
- 735 1
- 756 1
- 766 1
- 774 1
- 785 1
- 797 1
- 805 1
- 811 1
- 815 1
- 825 1
- 849 1
- 856 1
- 863 1
- 873 1
- 874 1
- 877 1
- 880 1
- 885 1
- 887 1
- 892 1
- 900 1
- 909 1
- 912 1
- 922 1
- 936 1
- 944 1
- 950 1
- 958 1
- 969 1
- 972 1
- 980 1
- 994 1
- 997 1
- 1000 1
- 1021 1
- 1062 1
- 1072 1
- 1086 1
- 1091 1
- 1106 1
- 1140 1
- 1162 1
- 1182 1
- 1190 1
- 1193 1
- 1200 1
- 1210 1
- 1226 1
- 1240 1
- 1251 1
- 1261 1
- 1272 1
- 1278 1
- 1291 1
- 1300 1
- 1309 1
- 1324 1
- 1331 1
- 1342 1
- 1350 1
- 1361 1
- 1375 1
- 1380 1
- 1389 1
- 1399 1
- 1404 1
- 1419 1
- 1429 1
- 1441 1
- 1448 1
- 1474 1
- 1476 1
- 1481 1
- 1484 1
- 1489 1
- 1498 1
- 1500 1
- 1509 1
- 1518 1
- 1529 1
- 1533 1
- 1541 1
- 1544 1
- 1548 1
- 1554 1
- 1559 1
- 1562 1
- 1563 1
- 1565 1
- 1571 1
- 1577 1
- 1581 1
- 1584 1
- 1591 1
- 1594 1
- 1595 1
- 1610 1
- 1617 1
- 1621 1
- 1626 1
- 1632 1
- 1640 1
- 1644 1
- 1650 1
- 1651 1
- 1653 1
- 1655 1
- 1665 1
- 1672 1
- 1677 1
- 1681 1
- 1685 1
- 1694 1
- 1705 1
- 1717 1
- 1721 1
- 1728 1
- 1736 1
- 1739 1
- 1742 1
- 1748 1
- 1763 1
- 1768 1
- 1777 1
- 1783 1
- 1788 1
- 1794 1
- 1807 1
- 1838 1
- 1857 1
- 1890 1
- 1900 1
- 1909 1
- 1931 1
- 1935 1
- 1945 1
- 1959 1
- 1971 1
- 1983 1
- 2001 1
- 2015 1
- 2037 1
- 2049 1
- 2057 1
- 2078 1
- 2091 1
- 2150 1
- 2164 1
- 2181 1
- 2211 1
- 2245 1
- 2265 1
- 2325 1
- 2348 1
- 2362 1
- 2401 1
- 2427 1
- 2460 1
- 2495 1
- 2552 1
- 2582 1
- 2607 1
- 2645 1
- 2671 1
- 2725 1
- 2760 1
- 2808 1
- 2850 1
- 2897 1
- 2964 1
- 3038 1
- 3057 1
- 3132 1
- 3193 1
- 3215 1
- 3256 1
- 3315 1
- 3374 1
- 3448 1
- 3503 1
- 3569 1
- 3622 1
- 3664 1
- 3716 1
- 3773 1
- 3859 1
- 3957 1
- 3999 1
- 4045 1
- 4110 1
- 4189 1
- 4279 1
- 4361 1
- 4444 1
- 4519 1
- 4712 1
- 4763 1
- 4860 1
- 4935 1
- 5036 1
- 5105 1
- 5204 1
- 5282 1
- 5336 1
- 5386 1
- 5550 1
- 5754 1
- 5891 1
- 6040 1
- 6106 1
- 6159 1
- 6290 1
- 6385 1
- 6514 1
- 6613 1
- 6736 1
- 6931 1
- 7044 1
- 7147 1
- 7252 1
- 7357 1
- 7469 1
- 7585 1
- 7693 1
- 7789 1
- 7867 1
- 8002 1
- 8111 1
- 8182 1
- 8285 1
- 8397 1
- 8447 1
- 8569 1
- 8716 1
- 8851 1
- 8956 1
- 9087 1
- 9167 1
- 9206 1
- 9357 1
- 9504 1
- 9629 1
- 9762 1
- 9971 1
- 10075 1
- 10150 1
- 10248 1
- 10355 1
- 10457 1
- 10509 1
- 10623 1
- 10737 1
- 10780 1
- 10873 1
- 10979 1
- 11065 1
- 11161 1
- 11249 1
- 11281 1
- 11354 1
- 11412 1
- 11511 1
- 11573 1
- 11650 1
- 11715 1
- 11774 1
- 11805 1
- 11861 1
- 11888 1
- 11940 1
- 11997 1
- 12046 1
- 12125 1
- 12160 1
- 12229 1
- 12266 1
- 12308 1
- 12342 1
- 12391 1
- 12446 1
- 12468 1
- 12493 1
- 12533 1
- 12562 1
- 12584 1
- 12623 1
- 12643 1
- 12651 1
- 12678 1
- 12702 1
- 12732 1
- 12770 1
- 12798 1
- 12819 1
- 12841 1
- 12869 1
- 12902 1
- 12923 1
- 12952 1
- 12975 1
- 13008 1
- 13023 1
- 13056 1
- 13090 1
- 13121 1
- 13159 1
- 13193 1
- 13217 1
- 13229 1
- 13259 1
- 13310 1
- 13345 1
- 13362 1
- 13394 1
- 13411 1
- 13432 1
- 13469 1
- 13537 1
- 13581 1
- 13644 1
- 13677 1
- 13703 1
- 13725 1
- 13796 1
- 13841 1
- 13862 1
- 13914 1
- 13962 1
- 13996 1
- 14020 1
- 14055 1
- 14111 1
- 14149 1
- 14188 1
- 14264 1
- 14305 1
- 14325 1
- 14409 1
- 14441 1
- 14512 1
- 14576 1
- 14663 1
- 14706 1
- 14729 1
- 14794 1
- 14879 1
- 14938 1
- 15010 1
- 15073 1
- 15121 1
- 15146 1
- 15208 1
- 15266 1
- 15313 1
- 15371 1
- 15418 1
- 15456 1
- 15476 1
- 15528 1
- 15577 1
- 15613 1
- 15660 1
- 15696 1
- 15711 1
- 15727 1
- 15767 1
- 15802 1
- 15824 1
- 15839 1
- 15866 1
- 15877 1
- 15896 1
- 15919 1
- 15933 1
- 15943 1
- 15998 1
- 16005 1
- 16025 1
- 16049 1
- 16070 1
- 16089 1
- 16096 1
- 16106 1
- 16114 1
- 16118 1
- 16126 1
- 16127 1
- 16135 1
- 16137 1
- 16142 1
- 16146 1
- 16150 1
- 16153 1
- 16162 1
- 16164 1
- 16168 1
- 16176 1
- 16178 1
- 16182 1
- 16184 1
- 16187 1
- 16191 1
- 16193 1
- 16195 1
- 16196 1
- 16202 1
- 16206 1
- 16207 1
- 16209 1
- 16213 1
- 16216 1
- 16219 1
- 16223 1
- 16228 1
- 16233 1
- 16234 1
- 16238 1
- 16242 1
- 16246 1
- 16247 1
- 16260 1
- 16264 1
- 16271 1
- 16281 1
- 16286 1
- 16299 1
- 16335 1
- 16348 1
- 16360 1
- 16380 1
- 16393 1
- 16410 1
- 16462 1
- 16481 1
- 16501 1
- 16530 1
- 16562 1
- 16579 1
- 16599 1
- 16621 1
- 16648 1
- 16689 1
- 16733 1
- 16766 1
- 16793 1
- 16820 1
- 16846 1
- 16883 1
- 16924 1
- 16964 1
- 17009 1
- 17060 1
- 17101 1
- 17133 1
- 17181 1
- 17213 1
- 17261 1
- 17323 1
- 17402 1
- 17442 1
- 17483 1
- 17528 1
- 17599 1
- 17676 1
- 17751 1
- 17834 1
- 17889 1
- 17960 1
- 18031 1
- 18102 1
- 18199 1
- 18265 1
- 18365 1
- 18417 1
- 18449 1
- 18507 1
- 18560 1
- 18628 1
- 18684 1
- 18732 1
- 18763 1
- 18797 1
- 18887 1
- 18923 1
- 18968 1
- 19057 1
- 19095 1
- 19216 1
- 19279 1
- 19329 1
- 19383 1
- 19469 1
- 19534 1
- 19640 1
- 19697 1
- 19737 1
- 19786 1
- 19846 1
- 19894 1
- 19963 1
- 20008 1
- 20047 1
- 20105 1
- 20157 1
- 20196 1
- 20258 1
- 20308 1
- 20339 1
- 20397 1
- 20424 1
- 20469 1
- 20509 1
- 20553 1
- 20609 1
- 20656 1
- 20779 1
- 20828 1
- 20899 1
- 20963 1
- 21022 1
- 21090 1
- 21122 1
- 21169 1
- 21236 1
- 21310 1
- 21373 1
- 21709 1
- 21769 1
- 21818 1
- 21896 1
- 21960 1
- 22046 1
- 22138 1
- 22180 1
- 22259 1
- 22352 1
- 22427 1
- 22489 1
- 22577 1
- 22670 1
- 22750 1
- 22790 1
- 22862 1
- 22951 1
- 23017 1
- 23114 1
- 23238 1
- 23401 1
- 23489 1
- 23568 1
- 23719 1
- 23809 1
- 23930 1
- 24052 1
- 24233 1
- 24394 1
- 24498 1
- 24615 1
- 24696 1
- 24812 1
- 24940 1
- 25080 1
- 25195 1
- 25275 1
- 25423 1
- 25688 1
- 25858 1
- 26058 1
- 26267 1
- 26361 1
- 26520 1
- 26652 1
- 26777 1
- 27038 1
- 27333 1
- 27560 1
- 27856 1
- 28165 1
- 28444 1
- 28765 1
- 29023 1
- 29301 1
- 29768 1
- 30146 1
- 30756 1
- 31009 1
- 31298 1
- 31577 1
- 31837 1
- 32197 1
- 32768 1
- 33009 1
- 33277 1
- 33446 1
- 33638 1
- 33893 1
- 34144 1
- 34285 1
- 34417 1
- 34546 1
- 34691 1
- 34905 1
- 35108 1
- 35206 1
- 35317 1
- 35374 1
- 35457 1
- 35517 1
- 35587 1
- 35650 1
- 35743 1
- 35781 1
- 35883 1
- 35914 1
- 35957 1
- 36013 1
- 36034 1
- 36045 1
- 36089 1
- 36104 1
- 36128 1
- 36150 1
- 36191 1
- 36241 1
- 36259 1
- 36276 1
- 36290 1
- 36305 1
- 36310 1
- 36316 1
- 36323 1
- 36336 1
- 36346 1
- 36353 1
- 36360 1
- 36362 1
- 36366 1
- 36371 1
- 36375 1
- 36381 1
- 36388 1
- 36391 1
- 36395 1
- 36397 1
- 36401 1
- 36408 1
- 36413 1
- 36419 1
- 36425 1
- 36432 1
- 36435 1
- 36447 1
- 36451 1
- 36455 1
- 36473 1
- 36481 1
- 36483 1
- 36484 1
- 36486 1
- 36497 1
- 36505 1
- 36510 1
- 36516 1
- 36522 1
- 36536 1
- 36540 1
- 36544 1
- 36554 1
- 36557 1
- 36558 1
- 36566 1
- 36578 1
- 36585 1
- 36594 1
- 36611 1
- 36615 1
- 36619 1
- 36626 1
- 36634 1
- 36648 1
- 36654 1
- 36671 1
- 36675 1
- 36681 1
- 36693 1
- 36708 1
- 36726 1
- 36739 1
- 36764 1
- 36775 1
- 36783 1
- 36798 1
state 1
- Pennsylvania 786
fips 1
- 42075 786
county 1
- Lebanon · 786 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4987 | 4987 | 2020-03-19 | Lebanon | Pennsylvania | 42075 | 1 | 0 |
5859 | 5859 | 2020-03-20 | Lebanon | Pennsylvania | 42075 | 1 | 0 |
6862 | 6862 | 2020-03-21 | Lebanon | Pennsylvania | 42075 | 2 | 0 |
7980 | 7980 | 2020-03-22 | Lebanon | Pennsylvania | 42075 | 3 | 0 |
9191 | 9191 | 2020-03-23 | Lebanon | Pennsylvania | 42075 | 3 | 0 |
10515 | 10515 | 2020-03-24 | Lebanon | Pennsylvania | 42075 | 3 | 0 |
11979 | 11979 | 2020-03-25 | Lebanon | Pennsylvania | 42075 | 3 | 0 |
13600 | 13600 | 2020-03-26 | Lebanon | Pennsylvania | 42075 | 4 | 0 |
15346 | 15346 | 2020-03-27 | Lebanon | Pennsylvania | 42075 | 12 | 0 |
17196 | 17196 | 2020-03-28 | Lebanon | Pennsylvania | 42075 | 15 | 0 |
19134 | 19134 | 2020-03-29 | Lebanon | Pennsylvania | 42075 | 19 | 0 |
21184 | 21184 | 2020-03-30 | Lebanon | Pennsylvania | 42075 | 27 | 0 |
23320 | 23320 | 2020-03-31 | Lebanon | Pennsylvania | 42075 | 28 | 0 |
25518 | 25518 | 2020-04-01 | Lebanon | Pennsylvania | 42075 | 36 | 0 |
27791 | 27791 | 2020-04-02 | Lebanon | Pennsylvania | 42075 | 45 | 0 |
30125 | 30125 | 2020-04-03 | Lebanon | Pennsylvania | 42075 | 54 | 0 |
32515 | 32515 | 2020-04-04 | Lebanon | Pennsylvania | 42075 | 87 | 0 |
34951 | 34951 | 2020-04-05 | Lebanon | Pennsylvania | 42075 | 106 | 0 |
37426 | 37426 | 2020-04-06 | Lebanon | Pennsylvania | 42075 | 124 | 0 |
39949 | 39949 | 2020-04-07 | Lebanon | Pennsylvania | 42075 | 145 | 0 |
42509 | 42509 | 2020-04-08 | Lebanon | Pennsylvania | 42075 | 169 | 0 |
45095 | 45095 | 2020-04-09 | Lebanon | Pennsylvania | 42075 | 187 | 0 |
47712 | 47712 | 2020-04-10 | Lebanon | Pennsylvania | 42075 | 218 | 1 |
50369 | 50369 | 2020-04-11 | Lebanon | Pennsylvania | 42075 | 232 | 1 |
53042 | 53042 | 2020-04-12 | Lebanon | Pennsylvania | 42075 | 270 | 1 |
55727 | 55727 | 2020-04-13 | Lebanon | Pennsylvania | 42075 | 284 | 2 |
58430 | 58430 | 2020-04-14 | Lebanon | Pennsylvania | 42075 | 328 | 2 |
61145 | 61145 | 2020-04-15 | Lebanon | Pennsylvania | 42075 | 349 | 2 |
63871 | 63871 | 2020-04-16 | Lebanon | Pennsylvania | 42075 | 380 | 2 |
66617 | 66617 | 2020-04-17 | Lebanon | Pennsylvania | 42075 | 424 | 2 |
69375 | 69375 | 2020-04-18 | Lebanon | Pennsylvania | 42075 | 458 | 4 |
72142 | 72142 | 2020-04-19 | Lebanon | Pennsylvania | 42075 | 484 | 4 |
74917 | 74917 | 2020-04-20 | Lebanon | Pennsylvania | 42075 | 502 | 5 |
77699 | 77699 | 2020-04-21 | Lebanon | Pennsylvania | 42075 | 525 | 8 |
80489 | 80489 | 2020-04-22 | Lebanon | Pennsylvania | 42075 | 535 | 8 |
83288 | 83288 | 2020-04-23 | Lebanon | Pennsylvania | 42075 | 544 | 8 |
86092 | 86092 | 2020-04-24 | Lebanon | Pennsylvania | 42075 | 575 | 8 |
88906 | 88906 | 2020-04-25 | Lebanon | Pennsylvania | 42075 | 592 | 8 |
91722 | 91722 | 2020-04-26 | Lebanon | Pennsylvania | 42075 | 612 | 8 |
94549 | 94549 | 2020-04-27 | Lebanon | Pennsylvania | 42075 | 621 | 8 |
97388 | 97388 | 2020-04-28 | Lebanon | Pennsylvania | 42075 | 635 | 8 |
100237 | 100237 | 2020-04-29 | Lebanon | Pennsylvania | 42075 | 648 | 9 |
103090 | 103090 | 2020-04-30 | Lebanon | Pennsylvania | 42075 | 676 | 9 |
105953 | 105953 | 2020-05-01 | Lebanon | Pennsylvania | 42075 | 694 | 9 |
108820 | 108820 | 2020-05-02 | Lebanon | Pennsylvania | 42075 | 710 | 10 |
111694 | 111694 | 2020-05-03 | Lebanon | Pennsylvania | 42075 | 735 | 10 |
114576 | 114576 | 2020-05-04 | Lebanon | Pennsylvania | 42075 | 756 | 10 |
117457 | 117457 | 2020-05-05 | Lebanon | Pennsylvania | 42075 | 766 | 15 |
120419 | 120419 | 2020-05-06 | Lebanon | Pennsylvania | 42075 | 774 | 15 |
123396 | 123396 | 2020-05-07 | Lebanon | Pennsylvania | 42075 | 785 | 16 |
126379 | 126379 | 2020-05-08 | Lebanon | Pennsylvania | 42075 | 797 | 16 |
129368 | 129368 | 2020-05-09 | Lebanon | Pennsylvania | 42075 | 805 | 16 |
132357 | 132357 | 2020-05-10 | Lebanon | Pennsylvania | 42075 | 811 | 16 |
135348 | 135348 | 2020-05-11 | Lebanon | Pennsylvania | 42075 | 815 | 16 |
138338 | 138338 | 2020-05-12 | Lebanon | Pennsylvania | 42075 | 825 | 17 |
141334 | 141334 | 2020-05-13 | Lebanon | Pennsylvania | 42075 | 849 | 19 |
144330 | 144330 | 2020-05-14 | Lebanon | Pennsylvania | 42075 | 856 | 19 |
147331 | 147331 | 2020-05-15 | Lebanon | Pennsylvania | 42075 | 863 | 19 |
150338 | 150338 | 2020-05-16 | Lebanon | Pennsylvania | 42075 | 873 | 19 |
153349 | 153349 | 2020-05-17 | Lebanon | Pennsylvania | 42075 | 874 | 19 |
156366 | 156366 | 2020-05-18 | Lebanon | Pennsylvania | 42075 | 877 | 21 |
159387 | 159387 | 2020-05-19 | Lebanon | Pennsylvania | 42075 | 880 | 24 |
162414 | 162414 | 2020-05-20 | Lebanon | Pennsylvania | 42075 | 885 | 24 |
165443 | 165443 | 2020-05-21 | Lebanon | Pennsylvania | 42075 | 887 | 24 |
168479 | 168479 | 2020-05-22 | Lebanon | Pennsylvania | 42075 | 892 | 24 |
171518 | 171518 | 2020-05-23 | Lebanon | Pennsylvania | 42075 | 900 | 24 |
174560 | 174560 | 2020-05-24 | Lebanon | Pennsylvania | 42075 | 909 | 27 |
177604 | 177604 | 2020-05-25 | Lebanon | Pennsylvania | 42075 | 912 | 27 |
180647 | 180647 | 2020-05-26 | Lebanon | Pennsylvania | 42075 | 922 | 27 |
183697 | 183697 | 2020-05-27 | Lebanon | Pennsylvania | 42075 | 936 | 31 |
186754 | 186754 | 2020-05-28 | Lebanon | Pennsylvania | 42075 | 944 | 33 |
189815 | 189815 | 2020-05-29 | Lebanon | Pennsylvania | 42075 | 950 | 33 |
192880 | 192880 | 2020-05-30 | Lebanon | Pennsylvania | 42075 | 958 | 33 |
195949 | 195949 | 2020-05-31 | Lebanon | Pennsylvania | 42075 | 969 | 33 |
199022 | 199022 | 2020-06-01 | Lebanon | Pennsylvania | 42075 | 972 | 33 |
202097 | 202097 | 2020-06-02 | Lebanon | Pennsylvania | 42075 | 980 | 33 |
205174 | 205174 | 2020-06-03 | Lebanon | Pennsylvania | 42075 | 994 | 34 |
208255 | 208255 | 2020-06-04 | Lebanon | Pennsylvania | 42075 | 997 | 36 |
211337 | 211337 | 2020-06-05 | Lebanon | Pennsylvania | 42075 | 1000 | 36 |
214423 | 214423 | 2020-06-06 | Lebanon | Pennsylvania | 42075 | 1021 | 37 |
217513 | 217513 | 2020-06-07 | Lebanon | Pennsylvania | 42075 | 1062 | 37 |
220605 | 220605 | 2020-06-08 | Lebanon | Pennsylvania | 42075 | 1072 | 37 |
223700 | 223700 | 2020-06-09 | Lebanon | Pennsylvania | 42075 | 1086 | 38 |
226800 | 226800 | 2020-06-10 | Lebanon | Pennsylvania | 42075 | 1091 | 38 |
229904 | 229904 | 2020-06-11 | Lebanon | Pennsylvania | 42075 | 1106 | 38 |
233009 | 233009 | 2020-06-12 | Lebanon | Pennsylvania | 42075 | 1140 | 39 |
236114 | 236114 | 2020-06-13 | Lebanon | Pennsylvania | 42075 | 1162 | 39 |
239222 | 239222 | 2020-06-14 | Lebanon | Pennsylvania | 42075 | 1182 | 40 |
242331 | 242331 | 2020-06-15 | Lebanon | Pennsylvania | 42075 | 1190 | 40 |
245443 | 245443 | 2020-06-16 | Lebanon | Pennsylvania | 42075 | 1193 | 40 |
248556 | 248556 | 2020-06-17 | Lebanon | Pennsylvania | 42075 | 1200 | 40 |
251671 | 251671 | 2020-06-18 | Lebanon | Pennsylvania | 42075 | 1210 | 40 |
254786 | 254786 | 2020-06-19 | Lebanon | Pennsylvania | 42075 | 1226 | 40 |
257912 | 257912 | 2020-06-20 | Lebanon | Pennsylvania | 42075 | 1240 | 40 |
261039 | 261039 | 2020-06-21 | Lebanon | Pennsylvania | 42075 | 1251 | 40 |
264167 | 264167 | 2020-06-22 | Lebanon | Pennsylvania | 42075 | 1261 | 40 |
267295 | 267295 | 2020-06-23 | Lebanon | Pennsylvania | 42075 | 1272 | 41 |
270429 | 270429 | 2020-06-24 | Lebanon | Pennsylvania | 42075 | 1278 | 42 |
273568 | 273568 | 2020-06-25 | Lebanon | Pennsylvania | 42075 | 1291 | 43 |
276715 | 276715 | 2020-06-26 | Lebanon | Pennsylvania | 42075 | 1300 | 43 |
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);