ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where county = "Los Angeles" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 777 ✖
- 1 38
- 1428526 3
- 2835021 3
- 2844303 3
- 2851184 3
- 2860503 3
- 2872907 3
- 2889112 3
- 14 2
- 677538 2
- 1233036 2
- 1523244 2
- 1595943 2
- 1697286 2
- 2794480 2
- 2804180 2
- 2812568 2
- 2824058 2
- 2830752 2
- 7 1
- 11 1
- 13 1
- 19 1
- 20 1
- 28 1
- 32 1
- 40 1
- 53 1
- 69 1
- 94 1
- 144 1
- 190 1
- 231 1
- 292 1
- 351 1
- 421 1
- 536 1
- 662 1
- 799 1
- 1216 1
- 1465 1
- 1804 1
- 2136 1
- 2474 1
- 3011 1
- 3518 1
- 4045 1
- 4566 1
- 5277 1
- 5940 1
- 6360 1
- 6910 1
- 7530 1
- 7955 1
- 8430 1
- 8873 1
- 9192 1
- 9420 1
- 10047 1
- 10496 1
- 10854 1
- 11391 1
- 12021 1
- 12341 1
- 13816 1
- 15140 1
- 16435 1
- 17508 1
- 18545 1
- 19107 1
- 19528 1
- 20417 1
- 20976 1
- 22485 1
- 23182 1
- 24215 1
- 24894 1
- 25662 1
- 26217 1
- 27815 1
- 28644 1
- 29427 1
- 30296 1
- 31197 1
- 31677 1
- 32258 1
- 33180 1
- 34428 1
- 35329 1
- 36259 1
- 37303 1
- 37974 1
- 38451 1
- 39573 1
- 40857 1
- 42037 1
- 43052 1
- 44055 1
- 44988 1
- 46018 1
- 47822 1
- 48700 1
- 49774 1
- 51562 1
- 53651 1
- 54996 1
- 55968 1
- 57118 1
- 58234 1
- 59650 1
- 61045 1
- 62338 1
- 63844 1
- 64644 1
- 65822 1
- 67064 1
- 68875 1
- 70476 1
- 72023 1
- 73018 1
- 73791 1
- 75084 1
- 77189 1
- 78227 1
- 79609 1
- 81636 1
- 83397 1
- 85942 1
- 88262 1
- 89490 1
- 91467 1
- 93232 1
- 95371 1
- 97894 1
- 100772 1
- 103529 1
- 105507 1
- 107667 1
- 110310 1
- 113497 1
- 114993 1
- 116570 1
- 120539 1
- 123004 1
- 124738 1
- 127358 1
- 130242 1
- 133549 1
- 136129 1
- 140307 1
- 143009 1
- 147468 1
- 150319 1
- 153041 1
- 155887 1
- 159045 1
- 161673 1
- 164870 1
- 166848 1
- 168757 1
- 172325 1
- 173995 1
- 176028 1
- 178642 1
- 183383 1
- 185872 1
- 188481 1
- 190693 1
- 192167 1
- 193788 1
- 195614 1
- 197912 1
- 201106 1
- 204167 1
- 206761 1
- 208528 1
- 210424 1
- 211808 1
- 214197 1
- 216139 1
- 218693 1
- 220762 1
- 221950 1
- 223131 1
- 224031 1
- 225827 1
- 227346 1
- 229054 1
- 230662 1
- 231695 1
- 232893 1
- 233777 1
- 235386 1
- 236986 1
- 238458 1
- 239756 1
- 240749 1
- 241768 1
- 242521 1
- 243935 1
- 244999 1
- 246407 1
- 247542 1
- 248334 1
- 248821 1
- 249241 1
- 249859 1
- 251024 1
- 252066 1
- 253176 1
- 253985 1
- 254656 1
- 255049 1
- 256148 1
- 257271 1
- 258516 1
- 259817 1
- 260797 1
- 261446 1
- 262133 1
- 263333 1
- 264414 1
- 265775 1
- 266988 1
- 267801 1
- 268455 1
- 269284 1
- 270299 1
- 271371 1
- 272653 1
- 273638 1
- 274565 1
- 274942 1
- 275856 1
- 277445 1
- 278665 1
- 279909 1
- 281165 1
- 282135 1
- 282982 1
- 283750 1
- 285016 1
- 286183 1
- 287222 1
- 288136 1
- 288451 1
- 289366 1
- 290009 1
- 290486 1
- 294065 1
- 296821 1
- 298937 1
- 299760 1
- 300614 1
- 302077 1
- 303369 1
- 305070 1
- 306327 1
- 307618 1
- 309190 1
- 310595 1
- 311745 1
- 313526 1
- 315634 1
- 317727 1
- 320048 1
- 322281 1
- 323699 1
- 325951 1
- 328042 1
- 330528 1
- 332945 1
- 336630 1
- 339640 1
- 342425 1
- 344607 1
- 348420 1
- 353316 1
- 357541 1
- 361962 1
- 364613 1
- 370729 1
- 374231 1
- 378421 1
- 383373 1
- 387793 1
- 391004 1
- 395957 1
- 401034 1
- 408515 1
- 414304 1
- 422000 1
- 430713 1
- 439538 1
- 449982 1
- 458011 1
- 466459 1
- 475409 1
- 488055 1
- 501792 1
- 513029 1
- 525651 1
- 532895 1
- 543949 1
- 566185 1
- 580505 1
- 596910 1
- 610562 1
- 623875 1
- 635058 1
- 647766 1
- 664193 1
- 706712 1
- 720099 1
- 733612 1
- 746381 1
- 756412 1
- 770915 1
- 790895 1
- 806523 1
- 818959 1
- 827843 1
- 840956 1
- 852510 1
- 871749 1
- 889787 1
- 906554 1
- 920560 1
- 933083 1
- 944713 1
- 958891 1
- 975693 1
- 990326 1
- 1004322 1
- 1015063 1
- 1024592 1
- 1032277 1
- 1038495 1
- 1046424 1
- 1055214 1
- 1065309 1
- 1073533 1
- 1079818 1
- 1085466 1
- 1092134 1
- 1098363 1
- 1104843 1
- 1111543 1
- 1117346 1
- 1121349 1
- 1125034 1
- 1129957 1
- 1134820 1
- 1139256 1
- 1143917 1
- 1146951 1
- 1149565 1
- 1152740 1
- 1155821 1
- 1159135 1
- 1162294 1
- 1165294 1
- 1167074 1
- 1168904 1
- 1170100 1
- 1172221 1
- 1174897 1
- 1177340 1
- 1179633 1
- 1181060 1
- 1181994 1
- 1183969 1
- 1186074 1
- 1188101 1
- 1189859 1
- 1191521 1
- 1192559 1
- 1193531 1
- 1194878 1
- 1196552 1
- 1198737 1
- 1200764 1
- 1202513 1
- 1203799 1
- 1204665 1
- 1205924 1
- 1207361 1
- 1208672 1
- 1208678 1
- 1210286 1
- 1210920 1
- 1211319 1
- 1211561 1
- 1212389 1
- 1213242 1
- 1213934 1
- 1214431 1
- 1214825 1
- 1215330 1
- 1215776 1
- 1216386 1
- 1216904 1
- 1217686 1
- 1218359 1
- 1218879 1
- 1219237 1
- 1219612 1
- 1220217 1
- 1220900 1
- 1221506 1
- 1222262 1
- 1222771 1
- 1223104 1
- 1223435 1
- 1223832 1
- 1224450 1
- 1225163 1
- 1225916 1
- 1226456 1
- 1226851 1
- 1227256 1
- 1227626 1
- 1228176 1
- 1228776 1
- 1229226 1
- 1229659 1
- 1229973 1
- 1230303 1
- 1230660 1
- 1231024 1
- 1231448 1
- 1231826 1
- 1232195 1
- 1232469 1
- 1232742 1
- 1233723 1
- 1234151 1
- 1234435 1
- 1234648 1
- 1234865 1
- 1235037 1
- 1235411 1
- 1235783 1
- 1236087 1
- 1236316 1
- 1236461 1
- 1236634 1
- 1236907 1
- 1237120 1
- 1237652 1
- 1237899 1
- 1238075 1
- 1238225 1
- 1238345 1
- 1238563 1
- 1238785 1
- 1239031 1
- 1239272 1
- 1239446 1
- 1239584 1
- 1239758 1
- 1239945 1
- 1243985 1
- 1244188 1
- 1244380 1
- 1244550 1
- 1244722 1
- 1244831 1
- 1244924 1
- 1245127 1
- 1245330 1
- 1245585 1
- 1245788 1
- 1245921 1
- 1246081 1
- 1246255 1
- 1246438 1
- 1246616 1
- 1246790 1
- 1246974 1
- 1247103 1
- 1247286 1
- 1247488 1
- 1247699 1
- 1247883 1
- 1248028 1
- 1248285 1
- 1248410 1
- 1248567 1
- 1248796 1
- 1249083 1
- 1249404 1
- 1249732 1
- 1249971 1
- 1250227 1
- 1250503 1
- 1250908 1
- 1251383 1
- 1251889 1
- 1252513 1
- 1252968 1
- 1253404 1
- 1253732 1
- 1254202 1
- 1256034 1
- 1256761 1
- 1257185 1
- 1258298 1
- 1259900 1
- 1260948 1
- 1261902 1
- 1263254 1
- 1265131 1
- 1266908 1
- 1268541 1
- 1269771 1
- 1271567 1
- 1274071 1
- 1276818 1
- 1279856 1
- 1282445 1
- 1284529 1
- 1286456 1
- 1288516 1
- 1290911 1
- 1294135 1
- 1297728 1
- 1301009 1
- 1304039 1
- 1306400 1
- 1308666 1
- 1312352 1
- 1316009 1
- 1319913 1
- 1324042 1
- 1327058 1
- 1329959 1
- 1332556 1
- 1336029 1
- 1339835 1
- 1343533 1
- 1347717 1
- 1351064 1
- 1353485 1
- 1356392 1
- 1360366 1
- 1363550 1
- 1377253 1
- 1381117 1
- 1383888 1
- 1386207 1
- 1388847 1
- 1392067 1
- 1395192 1
- 1397943 1
- 1401541 1
- 1403757 1
- 1406094 1
- 1408026 1
- 1410254 1
- 1412949 1
- 1415563 1
- 1417628 1
- 1419739 1
- 1421269 1
- 1422320 1
- 1424329 1
- 1426515 1
- 1434174 1
- 1435872 1
- 1437782 1
- 1439720 1
- 1441425 1
- 1443517 1
- 1444836 1
- 1445830 1
- 1447057 1
- 1448769 1
- 1450632 1
- 1452147 1
- 1453702 1
- 1454881 1
- 1455864 1
- 1456984 1
- 1458381 1
- 1459891 1
- 1461354 1
- 1462717 1
- 1463743 1
- 1464593 1
- 1465497 1
- 1466952 1
- 1468154 1
- 1469338 1
- 1470494 1
- 1471533 1
- 1472349 1
- 1473123 1
- 1474114 1
- 1475222 1
- 1476398 1
- 1477495 1
- 1478390 1
- 1479326 1
- 1480125 1
- 1481360 1
- 1482518 1
- 1483735 1
- 1484896 1
- 1485809 1
- 1486473 1
- 1487318 1
- 1488206 1
- 1490084 1
- 1491402 1
- 1492810 1
- 1493874 1
- 1494823 1
- 1495718 1
- 1497297 1
- 1499097 1
- 1500615 1
- 1502231 1
- 1503380 1
- 1504368 1
- 1505547 1
- 1507009 1
- 1508440 1
- 1509777 1
- 1511138 1
- 1512028 1
- 1512851 1
- 1513720 1
- 1514986 1
- 1516028 1
- 1517605 1
- 1519436 1
- 1520485 1
- 1521208 1
- 1521901 1
- 1524998 1
- 1525616 1
- 1526190 1
- 1526976 1
- 1527836 1
- 1529290 1
- 1531230 1
- 1533134 1
- 1535424 1
- 1537055 1
- 1538154 1
- 1539155 1
- 1540904 1
- 1542590 1
- 1544488 1
- 1546287 1
- 1547746 1
- 1548861 1
- 1550000 1
- 1551821 1
- 1554070 1
- 1557389 1
- 1561081 1
- 1564583 1
- 1567837 1
- 1570934 1
- 1577406 1
- 1586017 1
- 1616737 1
- 1624146 1
- 1633597 1
- 1650080 1
- 1670249 1
- 1741996 1
- 1758226 1
- 1780858 1
- 1807532 1
- 1844626 1
- 1888230 1
- 1922594 1
- 1968147 1
- 2011668 1
- 2046912 1
- 2087285 1
- 2132227 1
- 2172712 1
- 2214368 1
- 2258206 1
- 2289749 1
- 2312272 1
- 2344525 1
- 2386425 1
- 2429448 1
- 2468501 1
- 2494801 1
- 2520482 1
- 2540779 1
- 2561472 1
- 2587443 1
- 2611089 1
- 2632698 1
- 2649455 1
- 2660118 1
- 2668798 1
- 2684348 1
- 2695780 1
- 2711066 1
- 2720920 1
- 2727863 1
- 2732113 1
- 2736392 1
- 2741404 1
- 2747570 1
- 2753102 1
- 2757762 1
- 2762574 1
- 2764777 1
- 2766865 1
- 2770076 1
- 2773273 1
- 2777869 1
- 2781027 1
- 2783657 1
- 2784980 1
- 2786153 1
- 2788063 1
- 2789996 1
- 2792334 1
- 2797264 1
- 2798332 1
- 2799873 1
- 2801445 1
- 2802827 1
- 2805823 1
- 2806653 1
- 2807761 1
- 2809113 1
- 2811012 1
- 2814393 1
- 2815113 1
- 2816083 1
- 2817894 1
- 2820863 1
- 2826127 1
- 2826781 1
- 2827632 1
- 2828506 1
- 2829795 1
- 2831807 1
- 2832359 1
- 2833410 1
- 2833910 1
- 2837309 1
- 2838134 1
- 2839146 1
- 2840184 1
- 2847007 1
- 2847801 1
- 2848734 1
- 2849889 1
- 2854410 1
- 2855271 1
- 2856391 1
- 2858476 1
- 2864988 1
- 2866529 1
- 2868119 1
- 2870489 1
- 2878664 1
- 2880521 1
- 2882983 1
- 2885879 1
- 2896104 1
- 2898217 1
- 2901153 1
- 2904483 1
- 2908425 1
state 1
- California 839
fips 1
- 6037 839
county 1
- Los Angeles · 839 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
10 | 10 | 2020-01-26 | Los Angeles | California | 6037 | 1 | 0 |
15 | 15 | 2020-01-27 | Los Angeles | California | 6037 | 1 | 0 |
20 | 20 | 2020-01-28 | Los Angeles | California | 6037 | 1 | 0 |
25 | 25 | 2020-01-29 | Los Angeles | California | 6037 | 1 | 0 |
30 | 30 | 2020-01-30 | Los Angeles | California | 6037 | 1 | 0 |
35 | 35 | 2020-01-31 | Los Angeles | California | 6037 | 1 | 0 |
41 | 41 | 2020-02-01 | Los Angeles | California | 6037 | 1 | 0 |
48 | 48 | 2020-02-02 | Los Angeles | California | 6037 | 1 | 0 |
56 | 56 | 2020-02-03 | Los Angeles | California | 6037 | 1 | 0 |
64 | 64 | 2020-02-04 | Los Angeles | California | 6037 | 1 | 0 |
72 | 72 | 2020-02-05 | Los Angeles | California | 6037 | 1 | 0 |
81 | 81 | 2020-02-06 | Los Angeles | California | 6037 | 1 | 0 |
90 | 90 | 2020-02-07 | Los Angeles | California | 6037 | 1 | 0 |
99 | 99 | 2020-02-08 | Los Angeles | California | 6037 | 1 | 0 |
108 | 108 | 2020-02-09 | Los Angeles | California | 6037 | 1 | 0 |
117 | 117 | 2020-02-10 | Los Angeles | California | 6037 | 1 | 0 |
127 | 127 | 2020-02-11 | Los Angeles | California | 6037 | 1 | 0 |
137 | 137 | 2020-02-12 | Los Angeles | California | 6037 | 1 | 0 |
148 | 148 | 2020-02-13 | Los Angeles | California | 6037 | 1 | 0 |
159 | 159 | 2020-02-14 | Los Angeles | California | 6037 | 1 | 0 |
170 | 170 | 2020-02-15 | Los Angeles | California | 6037 | 1 | 0 |
181 | 181 | 2020-02-16 | Los Angeles | California | 6037 | 1 | 0 |
192 | 192 | 2020-02-17 | Los Angeles | California | 6037 | 1 | 0 |
204 | 204 | 2020-02-18 | Los Angeles | California | 6037 | 1 | 0 |
216 | 216 | 2020-02-19 | Los Angeles | California | 6037 | 1 | 0 |
229 | 229 | 2020-02-20 | Los Angeles | California | 6037 | 1 | 0 |
242 | 242 | 2020-02-21 | Los Angeles | California | 6037 | 1 | 0 |
256 | 256 | 2020-02-22 | Los Angeles | California | 6037 | 1 | 0 |
270 | 270 | 2020-02-23 | Los Angeles | California | 6037 | 1 | 0 |
284 | 284 | 2020-02-24 | Los Angeles | California | 6037 | 1 | 0 |
300 | 300 | 2020-02-25 | Los Angeles | California | 6037 | 1 | 0 |
317 | 317 | 2020-02-26 | Los Angeles | California | 6037 | 1 | 0 |
337 | 337 | 2020-02-27 | Los Angeles | California | 6037 | 1 | 0 |
357 | 357 | 2020-02-28 | Los Angeles | California | 6037 | 1 | 0 |
379 | 379 | 2020-02-29 | Los Angeles | California | 6037 | 1 | 0 |
402 | 402 | 2020-03-01 | Los Angeles | California | 6037 | 1 | 0 |
429 | 429 | 2020-03-02 | Los Angeles | California | 6037 | 1 | 0 |
463 | 463 | 2020-03-03 | Los Angeles | California | 6037 | 1 | 0 |
498 | 498 | 2020-03-04 | Los Angeles | California | 6037 | 7 | 0 |
537 | 537 | 2020-03-05 | Los Angeles | California | 6037 | 11 | 0 |
587 | 587 | 2020-03-06 | Los Angeles | California | 6037 | 13 | 0 |
662 | 662 | 2020-03-07 | Los Angeles | California | 6037 | 14 | 0 |
757 | 757 | 2020-03-08 | Los Angeles | California | 6037 | 14 | 0 |
871 | 871 | 2020-03-09 | Los Angeles | California | 6037 | 19 | 0 |
1003 | 1003 | 2020-03-10 | Los Angeles | California | 6037 | 20 | 0 |
1169 | 1169 | 2020-03-11 | Los Angeles | California | 6037 | 28 | 1 |
1375 | 1375 | 2020-03-12 | Los Angeles | California | 6037 | 32 | 1 |
1635 | 1635 | 2020-03-13 | Los Angeles | California | 6037 | 40 | 1 |
1952 | 1952 | 2020-03-14 | Los Angeles | California | 6037 | 53 | 1 |
2331 | 2331 | 2020-03-15 | Los Angeles | California | 6037 | 69 | 1 |
2765 | 2765 | 2020-03-16 | Los Angeles | California | 6037 | 94 | 1 |
3246 | 3246 | 2020-03-17 | Los Angeles | California | 6037 | 144 | 1 |
3799 | 3799 | 2020-03-18 | Los Angeles | California | 6037 | 190 | 1 |
4459 | 4459 | 2020-03-19 | Los Angeles | California | 6037 | 231 | 2 |
5234 | 5234 | 2020-03-20 | Los Angeles | California | 6037 | 292 | 2 |
6155 | 6155 | 2020-03-21 | Los Angeles | California | 6037 | 351 | 4 |
7189 | 7189 | 2020-03-22 | Los Angeles | California | 6037 | 421 | 5 |
8332 | 8332 | 2020-03-23 | Los Angeles | California | 6037 | 536 | 7 |
9573 | 9573 | 2020-03-24 | Los Angeles | California | 6037 | 662 | 11 |
10945 | 10945 | 2020-03-25 | Los Angeles | California | 6037 | 799 | 13 |
12490 | 12490 | 2020-03-26 | Los Angeles | California | 6037 | 1216 | 21 |
14156 | 14156 | 2020-03-27 | Los Angeles | California | 6037 | 1465 | 27 |
15938 | 15938 | 2020-03-28 | Los Angeles | California | 6037 | 1804 | 33 |
17827 | 17827 | 2020-03-29 | Los Angeles | California | 6037 | 2136 | 37 |
19804 | 19804 | 2020-03-30 | Los Angeles | California | 6037 | 2474 | 44 |
21878 | 21878 | 2020-03-31 | Los Angeles | California | 6037 | 3011 | 54 |
24036 | 24036 | 2020-04-01 | Los Angeles | California | 6037 | 3518 | 65 |
26265 | 26265 | 2020-04-02 | Los Angeles | California | 6037 | 4045 | 78 |
28564 | 28564 | 2020-04-03 | Los Angeles | California | 6037 | 4566 | 89 |
30922 | 30922 | 2020-04-04 | Los Angeles | California | 6037 | 5277 | 117 |
33328 | 33328 | 2020-04-05 | Los Angeles | California | 6037 | 5940 | 132 |
35773 | 35773 | 2020-04-06 | Los Angeles | California | 6037 | 6360 | 147 |
38262 | 38262 | 2020-04-07 | Los Angeles | California | 6037 | 6910 | 169 |
40806 | 40806 | 2020-04-08 | Los Angeles | California | 6037 | 7530 | 198 |
43378 | 43378 | 2020-04-09 | Los Angeles | California | 6037 | 7955 | 223 |
45978 | 45978 | 2020-04-10 | Los Angeles | California | 6037 | 8430 | 241 |
48608 | 48608 | 2020-04-11 | Los Angeles | California | 6037 | 8873 | 265 |
51270 | 51270 | 2020-04-12 | Los Angeles | California | 6037 | 9192 | 296 |
53949 | 53949 | 2020-04-13 | Los Angeles | California | 6037 | 9420 | 320 |
56641 | 56641 | 2020-04-14 | Los Angeles | California | 6037 | 10047 | 360 |
59349 | 59349 | 2020-04-15 | Los Angeles | California | 6037 | 10496 | 402 |
62068 | 62068 | 2020-04-16 | Los Angeles | California | 6037 | 10854 | 455 |
64801 | 64801 | 2020-04-17 | Los Angeles | California | 6037 | 11391 | 495 |
67549 | 67549 | 2020-04-18 | Los Angeles | California | 6037 | 12021 | 576 |
70311 | 70311 | 2020-04-19 | Los Angeles | California | 6037 | 12341 | 600 |
73080 | 73080 | 2020-04-20 | Los Angeles | California | 6037 | 13816 | 617 |
75856 | 75856 | 2020-04-21 | Los Angeles | California | 6037 | 15140 | 663 |
78640 | 78640 | 2020-04-22 | Los Angeles | California | 6037 | 16435 | 729 |
81434 | 81434 | 2020-04-23 | Los Angeles | California | 6037 | 17508 | 797 |
84234 | 84234 | 2020-04-24 | Los Angeles | California | 6037 | 18545 | 850 |
87042 | 87042 | 2020-04-25 | Los Angeles | California | 6037 | 19107 | 895 |
89859 | 89859 | 2020-04-26 | Los Angeles | California | 6037 | 19528 | 913 |
92677 | 92677 | 2020-04-27 | Los Angeles | California | 6037 | 20417 | 942 |
95508 | 95508 | 2020-04-28 | Los Angeles | California | 6037 | 20976 | 1000 |
98353 | 98353 | 2020-04-29 | Los Angeles | California | 6037 | 22485 | 1056 |
101203 | 101203 | 2020-04-30 | Los Angeles | California | 6037 | 23182 | 1111 |
104058 | 104058 | 2020-05-01 | Los Angeles | California | 6037 | 24215 | 1172 |
106923 | 106923 | 2020-05-02 | Los Angeles | California | 6037 | 24894 | 1209 |
109792 | 109792 | 2020-05-03 | Los Angeles | California | 6037 | 25662 | 1229 |
112667 | 112667 | 2020-05-04 | Los Angeles | California | 6037 | 26217 | 1256 |
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);