ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 24510 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 747 ✖
- 64998 24
- 63817 3
- 79808 3
- 111656 3
- 112097 3
- 112574 3
- 113125 3
- 113863 3
- 114991 3
- 1 2
- 7 2
- 187 2
- 110156 2
- 3 1
- 11 1
- 15 1
- 24 1
- 31 1
- 41 1
- 53 1
- 72 1
- 103 1
- 112 1
- 129 1
- 152 1
- 265 1
- 313 1
- 343 1
- 394 1
- 435 1
- 459 1
- 571 1
- 638 1
- 689 1
- 756 1
- 812 1
- 873 1
- 962 1
- 1062 1
- 1164 1
- 1277 1
- 1381 1
- 1397 1
- 1516 1
- 1547 1
- 1608 1
- 1678 1
- 1734 1
- 1797 1
- 1872 1
- 1939 1
- 1984 1
- 2021 1
- 2076 1
- 2171 1
- 2246 1
- 2328 1
- 2420 1
- 2618 1
- 2761 1
- 2865 1
- 2950 1
- 3217 1
- 3326 1
- 3362 1
- 3413 1
- 3485 1
- 3514 1
- 3615 1
- 3727 1
- 3806 1
- 3838 1
- 4010 1
- 4159 1
- 4347 1
- 4499 1
- 4682 1
- 4791 1
- 4897 1
- 5006 1
- 5062 1
- 5211 1
- 5434 1
- 5572 1
- 5612 1
- 5672 1
- 5696 1
- 5809 1
- 5914 1
- 6046 1
- 6149 1
- 6237 1
- 6304 1
- 6363 1
- 6436 1
- 6517 1
- 6567 1
- 6641 1
- 6698 1
- 6755 1
- 6790 1
- 6874 1
- 6914 1
- 6947 1
- 7002 1
- 7062 1
- 7104 1
- 7157 1
- 7219 1
- 7267 1
- 7308 1
- 7372 1
- 7425 1
- 7507 1
- 7556 1
- 7615 1
- 7711 1
- 7799 1
- 7867 1
- 7907 1
- 7970 1
- 8011 1
- 8082 1
- 8167 1
- 8262 1
- 8380 1
- 8502 1
- 8579 1
- 8702 1
- 8849 1
- 9012 1
- 9155 1
- 9298 1
- 9442 1
- 9519 1
- 9658 1
- 9752 1
- 9856 1
- 10015 1
- 10224 1
- 10367 1
- 10593 1
- 10716 1
- 10840 1
- 11018 1
- 11206 1
- 11420 1
- 11591 1
- 11762 1
- 11859 1
- 11968 1
- 12090 1
- 12255 1
- 12390 1
- 12562 1
- 12720 1
- 12909 1
- 13007 1
- 13078 1
- 13225 1
- 13356 1
- 13440 1
- 13522 1
- 13581 1
- 13658 1
- 13723 1
- 13820 1
- 13913 1
- 13997 1
- 14088 1
- 14126 1
- 14191 1
- 14262 1
- 14332 1
- 14403 1
- 14444 1
- 14498 1
- 14555 1
- 14589 1
- 14646 1
- 14712 1
- 14787 1
- 14854 1
- 14982 1
- 15014 1
- 15057 1
- 15103 1
- 15112 1
- 15147 1
- 15180 1
- 15195 1
- 15201 1
- 15222 1
- 15244 1
- 15254 1
- 15272 1
- 15277 1
- 15310 1
- 15317 1
- 15347 1
- 15392 1
- 15449 1
- 15502 1
- 15543 1
- 15600 1
- 15623 1
- 15646 1
- 15810 1
- 15881 1
- 15915 1
- 15971 1
- 16040 1
- 16073 1
- 16117 1
- 16280 1
- 16371 1
- 16407 1
- 16465 1
- 16525 1
- 16560 1
- 16601 1
- 16664 1
- 16698 1
- 16790 1
- 16859 1
- 16923 1
- 16954 1
- 17017 1
- 17096 1
- 17198 1
- 17329 1
- 17457 1
- 17523 1
- 17598 1
- 17681 1
- 17791 1
- 17868 1
- 17994 1
- 18118 1
- 18229 1
- 18310 1
- 18475 1
- 18628 1
- 18842 1
- 19083 1
- 19214 1
- 19376 1
- 19567 1
- 19787 1
- 20025 1
- 20216 1
- 20489 1
- 20756 1
- 21029 1
- 21205 1
- 21428 1
- 21802 1
- 22030 1
- 22486 1
- 22719 1
- 22952 1
- 23107 1
- 23381 1
- 23702 1
- 23975 1
- 24140 1
- 24329 1
- 24541 1
- 24782 1
- 25026 1
- 25290 1
- 25707 1
- 25973 1
- 26215 1
- 26439 1
- 26613 1
- 26918 1
- 27218 1
- 27485 1
- 27817 1
- 28067 1
- 28291 1
- 28428 1
- 28608 1
- 28874 1
- 29041 1
- 29177 1
- 29352 1
- 29599 1
- 29886 1
- 30101 1
- 30311 1
- 30461 1
- 30633 1
- 30798 1
- 31010 1
- 31144 1
- 31333 1
- 31558 1
- 31932 1
- 32153 1
- 32338 1
- 32524 1
- 32710 1
- 33003 1
- 33236 1
- 33549 1
- 33869 1
- 34142 1
- 34421 1
- 34464 1
- 34699 1
- 34928 1
- 35220 1
- 35426 1
- 35631 1
- 35794 1
- 35963 1
- 36076 1
- 36304 1
- 36474 1
- 36709 1
- 36907 1
- 37044 1
- 37108 1
- 37302 1
- 37485 1
- 37646 1
- 37792 1
- 37972 1
- 38045 1
- 38141 1
- 38215 1
- 38332 1
- 38453 1
- 38605 1
- 38754 1
- 38849 1
- 38930 1
- 39046 1
- 39152 1
- 39274 1
- 39366 1
- 39445 1
- 39518 1
- 39573 1
- 39581 1
- 39654 1
- 39722 1
- 39806 1
- 39860 1
- 39920 1
- 40001 1
- 40058 1
- 40162 1
- 40207 1
- 40324 1
- 40422 1
- 40495 1
- 40502 1
- 40561 1
- 40629 1
- 40749 1
- 40838 1
- 40913 1
- 41021 1
- 41068 1
- 41214 1
- 41303 1
- 41436 1
- 41609 1
- 41743 1
- 41835 1
- 41927 1
- 42057 1
- 42251 1
- 42439 1
- 42571 1
- 42757 1
- 42860 1
- 42991 1
- 43177 1
- 43373 1
- 43600 1
- 43804 1
- 44038 1
- 44259 1
- 44412 1
- 44651 1
- 44891 1
- 45119 1
- 45340 1
- 45682 1
- 45847 1
- 45989 1
- 46276 1
- 46525 1
- 46800 1
- 47093 1
- 47390 1
- 47601 1
- 47771 1
- 48067 1
- 48333 1
- 48602 1
- 48908 1
- 49127 1
- 49278 1
- 49432 1
- 49615 1
- 49790 1
- 49973 1
- 50170 1
- 50334 1
- 50446 1
- 50522 1
- 50656 1
- 50795 1
- 50953 1
- 51108 1
- 51229 1
- 51329 1
- 51403 1
- 51511 1
- 51602 1
- 51766 1
- 51850 1
- 51942 1
- 51992 1
- 52038 1
- 52122 1
- 52176 1
- 52226 1
- 52279 1
- 52336 1
- 52376 1
- 52401 1
- 52431 1
- 52464 1
- 52535 1
- 52650 1
- 52695 1
- 52766 1
- 52772 1
- 52782 1
- 52809 1
- 52821 1
- 52844 1
- 52863 1
- 52876 1
- 52884 1
- 52889 1
- 52896 1
- 52926 1
- 52949 1
- 52964 1
- 52976 1
- 52979 1
- 52991 1
- 53006 1
- 53021 1
- 53037 1
- 53050 1
- 53054 1
- 53057 1
- 53068 1
- 53073 1
- 53090 1
- 53099 1
- 53110 1
- 53116 1
- 53122 1
- 53123 1
- 53129 1
- 53134 1
- 53149 1
- 53153 1
- 53157 1
- 53158 1
- 53166 1
- 53171 1
- 53173 1
- 53175 1
- 53181 1
- 53187 1
- 53194 1
- 53201 1
- 53210 1
- 53235 1
- 53242 1
- 53253 1
- 53257 1
- 53262 1
- 53267 1
- 53272 1
- 53292 1
- 53302 1
- 53317 1
- 53325 1
- 53350 1
- 53380 1
- 53398 1
- 53412 1
- 53438 1
- 53480 1
- 53500 1
- 53535 1
- 53562 1
- 53605 1
- 53668 1
- 53717 1
- 53768 1
- 53802 1
- 53834 1
- 53901 1
- 53963 1
- 54035 1
- 54128 1
- 54197 1
- 54260 1
- 54307 1
- 54396 1
- 54494 1
- 54562 1
- 54666 1
- 54751 1
- 54812 1
- 54874 1
- 54951 1
- 55056 1
- 55100 1
- 55181 1
- 55269 1
- 55337 1
- 55393 1
- 55496 1
- 55574 1
- 55702 1
- 55802 1
- 55899 1
- 55983 1
- 56058 1
- 56182 1
- 56248 1
- 56346 1
- 56445 1
- 56514 1
- 56601 1
- 56678 1
- 56695 1
- 56758 1
- 56890 1
- 57016 1
- 57139 1
- 57237 1
- 57321 1
- 57355 1
- 57470 1
- 57596 1
- 57699 1
- 57799 1
- 57921 1
- 57988 1
- 58090 1
- 58235 1
- 58337 1
- 58472 1
- 58603 1
- 58704 1
- 58819 1
- 58903 1
- 59030 1
- 59195 1
- 59273 1
- 59459 1
- 59588 1
- 59662 1
- 59744 1
- 59893 1
- 60027 1
- 60090 1
- 60211 1
- 60314 1
- 60367 1
- 60484 1
- 60523 1
- 60634 1
- 60738 1
- 60840 1
- 60931 1
- 60951 1
- 60979 1
- 61031 1
- 61129 1
- 61209 1
- 61303 1
- 61381 1
- 61417 1
- 61442 1
- 61506 1
- 61593 1
- 61671 1
- 61762 1
- 61808 1
- 61832 1
- 61906 1
- 61965 1
- 62032 1
- 62120 1
- 62204 1
- 62270 1
- 62312 1
- 62392 1
- 62484 1
- 62595 1
- 62725 1
- 62842 1
- 62950 1
- 63023 1
- 63051 1
- 63137 1
- 63263 1
- 63399 1
- 63534 1
- 63634 1
- 63703 1
- 64029 1
- 64111 1
- 64201 1
- 64356 1
- 64419 1
- 64576 1
- 64788 1
- 76567 1
- 78144 1
- 84171 1
- 85595 1
- 87056 1
- 88200 1
- 89511 1
- 90743 1
- 91837 1
- 93703 1
- 94744 1
- 95419 1
- 96377 1
- 97462 1
- 98638 1
- 99683 1
- 100601 1
- 101440 1
- 101792 1
- 102103 1
- 102700 1
- 103104 1
- 103511 1
- 103820 1
- 104017 1
- 104153 1
- 104324 1
- 104561 1
- 104795 1
- 105016 1
- 105172 1
- 105251 1
- 105341 1
- 105423 1
- 105584 1
- 105714 1
- 105799 1
- 105887 1
- 105938 1
- 105977 1
- 106034 1
- 106099 1
- 106371 1
- 106452 1
- 106502 1
- 106546 1
- 106552 1
- 109491 1
- 109522 1
- 109600 1
- 109654 1
- 110219 1
- 110254 1
- 110314 1
- 110378 1
- 110474 1
- 110504 1
- 110523 1
- 110538 1
- 110560 1
- 110597 1
- 110625 1
- 110657 1
- 110682 1
- 110696 1
- 110709 1
- 110740 1
- 110789 1
- 110830 1
- 110876 1
- 110901 1
- 110911 1
- 110938 1
- 110982 1
- 111044 1
- 111084 1
- 111130 1
- 111152 1
- 111173 1
- 111189 1
- 111226 1
- 111265 1
- 111342 1
- 111408 1
- 111429 1
- 111457 1
- 111500 1
- 111526 1
- 111592 1
- 111784 1
- 111800 1
- 111858 1
- 111928 1
- 112290 1
- 112364 1
- 112413 1
- 112497 1
- 112645 1
- 112802 1
- 112873 1
- 112989 1
- 113237 1
- 113441 1
- 113532 1
- 113704 1
- 114024 1
- 114248 1
- 114424 1
- 114683 1
- 115286 1
- 115782 1
- 116053 1
- 116321 1
- 116724 1
state 1
- Maryland 790
fips 1
- 24510 · 790 ✖
county 1
- Baltimore city 790
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500784 | 2500784 | 2022-05-13 | Baltimore city | Maryland | 24510 | 116724 | 1777 |
2497526 | 2497526 | 2022-05-12 | Baltimore city | Maryland | 24510 | 116321 | 1776 |
2494268 | 2494268 | 2022-05-11 | Baltimore city | Maryland | 24510 | 116053 | 1776 |
2491010 | 2491010 | 2022-05-10 | Baltimore city | Maryland | 24510 | 115782 | 1776 |
2487753 | 2487753 | 2022-05-09 | Baltimore city | Maryland | 24510 | 115286 | 1776 |
2484495 | 2484495 | 2022-05-08 | Baltimore city | Maryland | 24510 | 114991 | 1776 |
2481237 | 2481237 | 2022-05-07 | Baltimore city | Maryland | 24510 | 114991 | 1776 |
2477979 | 2477979 | 2022-05-06 | Baltimore city | Maryland | 24510 | 114991 | 1776 |
2474721 | 2474721 | 2022-05-05 | Baltimore city | Maryland | 24510 | 114683 | 1775 |
2471464 | 2471464 | 2022-05-04 | Baltimore city | Maryland | 24510 | 114424 | 1775 |
2468208 | 2468208 | 2022-05-03 | Baltimore city | Maryland | 24510 | 114248 | 1775 |
2464953 | 2464953 | 2022-05-02 | Baltimore city | Maryland | 24510 | 114024 | 1774 |
2461697 | 2461697 | 2022-05-01 | Baltimore city | Maryland | 24510 | 113863 | 1773 |
2458441 | 2458441 | 2022-04-30 | Baltimore city | Maryland | 24510 | 113863 | 1773 |
2455185 | 2455185 | 2022-04-29 | Baltimore city | Maryland | 24510 | 113863 | 1773 |
2451929 | 2451929 | 2022-04-28 | Baltimore city | Maryland | 24510 | 113704 | 1773 |
2448673 | 2448673 | 2022-04-27 | Baltimore city | Maryland | 24510 | 113532 | 1773 |
2445417 | 2445417 | 2022-04-26 | Baltimore city | Maryland | 24510 | 113441 | 1771 |
2442161 | 2442161 | 2022-04-25 | Baltimore city | Maryland | 24510 | 113237 | 1771 |
2438905 | 2438905 | 2022-04-24 | Baltimore city | Maryland | 24510 | 113125 | 1771 |
2435649 | 2435649 | 2022-04-23 | Baltimore city | Maryland | 24510 | 113125 | 1771 |
2432393 | 2432393 | 2022-04-22 | Baltimore city | Maryland | 24510 | 113125 | 1771 |
2429137 | 2429137 | 2022-04-21 | Baltimore city | Maryland | 24510 | 112989 | 1771 |
2425881 | 2425881 | 2022-04-20 | Baltimore city | Maryland | 24510 | 112873 | 1771 |
2422625 | 2422625 | 2022-04-19 | Baltimore city | Maryland | 24510 | 112802 | 1771 |
2419369 | 2419369 | 2022-04-18 | Baltimore city | Maryland | 24510 | 112645 | 1771 |
2416113 | 2416113 | 2022-04-17 | Baltimore city | Maryland | 24510 | 112574 | 1771 |
2412857 | 2412857 | 2022-04-16 | Baltimore city | Maryland | 24510 | 112574 | 1771 |
2409601 | 2409601 | 2022-04-15 | Baltimore city | Maryland | 24510 | 112574 | 1771 |
2406345 | 2406345 | 2022-04-14 | Baltimore city | Maryland | 24510 | 112497 | 1770 |
2403089 | 2403089 | 2022-04-13 | Baltimore city | Maryland | 24510 | 112413 | 1767 |
2399835 | 2399835 | 2022-04-12 | Baltimore city | Maryland | 24510 | 112364 | 1766 |
2396579 | 2396579 | 2022-04-11 | Baltimore city | Maryland | 24510 | 112290 | 1766 |
2393324 | 2393324 | 2022-04-10 | Baltimore city | Maryland | 24510 | 112097 | 1765 |
2390068 | 2390068 | 2022-04-09 | Baltimore city | Maryland | 24510 | 112097 | 1765 |
2386812 | 2386812 | 2022-04-08 | Baltimore city | Maryland | 24510 | 112097 | 1765 |
2383557 | 2383557 | 2022-04-07 | Baltimore city | Maryland | 24510 | 111928 | 1765 |
2380302 | 2380302 | 2022-04-06 | Baltimore city | Maryland | 24510 | 111858 | 1765 |
2377047 | 2377047 | 2022-04-05 | Baltimore city | Maryland | 24510 | 111800 | 1765 |
2373795 | 2373795 | 2022-04-04 | Baltimore city | Maryland | 24510 | 111784 | 1765 |
2370542 | 2370542 | 2022-04-03 | Baltimore city | Maryland | 24510 | 111656 | 1763 |
2367289 | 2367289 | 2022-04-02 | Baltimore city | Maryland | 24510 | 111656 | 1763 |
2364036 | 2364036 | 2022-04-01 | Baltimore city | Maryland | 24510 | 111656 | 1763 |
2360782 | 2360782 | 2022-03-31 | Baltimore city | Maryland | 24510 | 111592 | 1762 |
2357528 | 2357528 | 2022-03-30 | Baltimore city | Maryland | 24510 | 111526 | 1761 |
2354275 | 2354275 | 2022-03-29 | Baltimore city | Maryland | 24510 | 111500 | 1761 |
2351023 | 2351023 | 2022-03-28 | Baltimore city | Maryland | 24510 | 111457 | 1762 |
2347770 | 2347770 | 2022-03-27 | Baltimore city | Maryland | 24510 | 111429 | 1762 |
2344517 | 2344517 | 2022-03-26 | Baltimore city | Maryland | 24510 | 111408 | 1762 |
2341264 | 2341264 | 2022-03-25 | Baltimore city | Maryland | 24510 | 111342 | 1761 |
2338011 | 2338011 | 2022-03-24 | Baltimore city | Maryland | 24510 | 111265 | 1761 |
2334757 | 2334757 | 2022-03-23 | Baltimore city | Maryland | 24510 | 111226 | 1760 |
2331503 | 2331503 | 2022-03-22 | Baltimore city | Maryland | 24510 | 111189 | 1759 |
2328251 | 2328251 | 2022-03-21 | Baltimore city | Maryland | 24510 | 111173 | 1757 |
2324998 | 2324998 | 2022-03-20 | Baltimore city | Maryland | 24510 | 111152 | 1756 |
2321744 | 2321744 | 2022-03-19 | Baltimore city | Maryland | 24510 | 111130 | 1755 |
2318490 | 2318490 | 2022-03-18 | Baltimore city | Maryland | 24510 | 111084 | 1754 |
2315237 | 2315237 | 2022-03-17 | Baltimore city | Maryland | 24510 | 111044 | 1753 |
2311984 | 2311984 | 2022-03-16 | Baltimore city | Maryland | 24510 | 110982 | 1754 |
2308731 | 2308731 | 2022-03-15 | Baltimore city | Maryland | 24510 | 110938 | 1754 |
2305480 | 2305480 | 2022-03-14 | Baltimore city | Maryland | 24510 | 110911 | 1753 |
2302228 | 2302228 | 2022-03-13 | Baltimore city | Maryland | 24510 | 110901 | 1753 |
2298976 | 2298976 | 2022-03-12 | Baltimore city | Maryland | 24510 | 110876 | 1752 |
2295724 | 2295724 | 2022-03-11 | Baltimore city | Maryland | 24510 | 110830 | 1751 |
2292472 | 2292472 | 2022-03-10 | Baltimore city | Maryland | 24510 | 110789 | 1749 |
2289220 | 2289220 | 2022-03-09 | Baltimore city | Maryland | 24510 | 110740 | 1746 |
2285969 | 2285969 | 2022-03-08 | Baltimore city | Maryland | 24510 | 110709 | 1742 |
2282717 | 2282717 | 2022-03-07 | Baltimore city | Maryland | 24510 | 110696 | 1738 |
2279464 | 2279464 | 2022-03-06 | Baltimore city | Maryland | 24510 | 110682 | 1738 |
2276211 | 2276211 | 2022-03-05 | Baltimore city | Maryland | 24510 | 110657 | 1738 |
2272958 | 2272958 | 2022-03-04 | Baltimore city | Maryland | 24510 | 110625 | 1736 |
2269706 | 2269706 | 2022-03-03 | Baltimore city | Maryland | 24510 | 110597 | 1735 |
2266453 | 2266453 | 2022-03-02 | Baltimore city | Maryland | 24510 | 110560 | 1733 |
2263202 | 2263202 | 2022-03-01 | Baltimore city | Maryland | 24510 | 110538 | 1732 |
2259951 | 2259951 | 2022-02-28 | Baltimore city | Maryland | 24510 | 110523 | 1728 |
2256700 | 2256700 | 2022-02-27 | Baltimore city | Maryland | 24510 | 110504 | 1727 |
2253449 | 2253449 | 2022-02-26 | Baltimore city | Maryland | 24510 | 110474 | 1726 |
2250198 | 2250198 | 2022-02-25 | Baltimore city | Maryland | 24510 | 110378 | 1724 |
2246947 | 2246947 | 2022-02-24 | Baltimore city | Maryland | 24510 | 110314 | 1722 |
2243696 | 2243696 | 2022-02-23 | Baltimore city | Maryland | 24510 | 110254 | 1716 |
2240445 | 2240445 | 2022-02-22 | Baltimore city | Maryland | 24510 | 110219 | 1714 |
2237194 | 2237194 | 2022-02-21 | Baltimore city | Maryland | 24510 | 110156 | 1714 |
2233943 | 2233943 | 2022-02-20 | Baltimore city | Maryland | 24510 | 110156 | 1714 |
2230692 | 2230692 | 2022-02-19 | Baltimore city | Maryland | 24510 | 109654 | 1714 |
2227441 | 2227441 | 2022-02-18 | Baltimore city | Maryland | 24510 | 109600 | 1712 |
2224190 | 2224190 | 2022-02-17 | Baltimore city | Maryland | 24510 | 109522 | 1703 |
2220939 | 2220939 | 2022-02-16 | Baltimore city | Maryland | 24510 | 109491 | 1702 |
2217688 | 2217688 | 2022-02-15 | Baltimore city | Maryland | 24510 | 106552 | 1699 |
2214437 | 2214437 | 2022-02-14 | Baltimore city | Maryland | 24510 | 106546 | 1696 |
2211185 | 2211185 | 2022-02-13 | Baltimore city | Maryland | 24510 | 106502 | 1696 |
2207932 | 2207932 | 2022-02-12 | Baltimore city | Maryland | 24510 | 106452 | 1693 |
2204679 | 2204679 | 2022-02-11 | Baltimore city | Maryland | 24510 | 106371 | 1690 |
2201426 | 2201426 | 2022-02-10 | Baltimore city | Maryland | 24510 | 106099 | 1686 |
2198172 | 2198172 | 2022-02-09 | Baltimore city | Maryland | 24510 | 106034 | 1682 |
2194918 | 2194918 | 2022-02-08 | Baltimore city | Maryland | 24510 | 105977 | 1675 |
2191664 | 2191664 | 2022-02-07 | Baltimore city | Maryland | 24510 | 105938 | 1670 |
2188411 | 2188411 | 2022-02-06 | Baltimore city | Maryland | 24510 | 105887 | 1670 |
2185158 | 2185158 | 2022-02-05 | Baltimore city | Maryland | 24510 | 105799 | 1668 |
2181906 | 2181906 | 2022-02-04 | Baltimore city | Maryland | 24510 | 105714 | 1662 |
2178654 | 2178654 | 2022-02-03 | Baltimore city | Maryland | 24510 | 105584 | 1656 |
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);