ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Monmouth" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 793 ✖
- 2 2
- 162045 2
- 165475 2
- 4 1
- 5 1
- 7 1
- 8 1
- 11 1
- 14 1
- 22 1
- 32 1
- 43 1
- 53 1
- 92 1
- 158 1
- 238 1
- 288 1
- 313 1
- 501 1
- 634 1
- 781 1
- 870 1
- 1030 1
- 1140 1
- 1301 1
- 1458 1
- 1743 1
- 2065 1
- 2354 1
- 2545 1
- 2770 1
- 3038 1
- 3248 1
- 3496 1
- 3651 1
- 3785 1
- 3875 1
- 4003 1
- 4122 1
- 4299 1
- 4414 1
- 4528 1
- 4669 1
- 4787 1
- 4947 1
- 5086 1
- 5238 1
- 5368 1
- 5521 1
- 5671 1
- 5759 1
- 5826 1
- 5907 1
- 6033 1
- 6132 1
- 6198 1
- 6290 1
- 6378 1
- 6490 1
- 6552 1
- 6649 1
- 6752 1
- 6815 1
- 6894 1
- 6988 1
- 7041 1
- 7090 1
- 7164 1
- 7224 1
- 7297 1
- 7339 1
- 7408 1
- 7470 1
- 7541 1
- 7637 1
- 7695 1
- 7720 1
- 7800 1
- 7865 1
- 7911 1
- 7961 1
- 8012 1
- 8100 1
- 8159 1
- 8219 1
- 8249 1
- 8289 1
- 8332 1
- 8379 1
- 8428 1
- 8454 1
- 8478 1
- 8498 1
- 8512 1
- 8563 1
- 8627 1
- 8660 1
- 8720 1
- 8740 1
- 8761 1
- 8786 1
- 8804 1
- 8830 1
- 8876 1
- 8925 1
- 8942 1
- 8965 1
- 8998 1
- 9008 1
- 9123 1
- 9150 1
- 9175 1
- 9201 1
- 9203 1
- 9233 1
- 9256 1
- 9307 1
- 9344 1
- 9368 1
- 9404 1
- 9416 1
- 9442 1
- 9458 1
- 9469 1
- 9502 1
- 9535 1
- 9580 1
- 9613 1
- 9640 1
- 9706 1
- 9727 1
- 9737 1
- 9750 1
- 9760 1
- 9773 1
- 9784 1
- 9820 1
- 9848 1
- 9891 1
- 9922 1
- 9957 1
- 10008 1
- 10047 1
- 10085 1
- 10104 1
- 10157 1
- 10193 1
- 10217 1
- 10237 1
- 10270 1
- 10289 1
- 10324 1
- 10364 1
- 10381 1
- 10399 1
- 10423 1
- 10445 1
- 10465 1
- 10504 1
- 10531 1
- 10556 1
- 10571 1
- 10593 1
- 10606 1
- 10620 1
- 10629 1
- 10641 1
- 10669 1
- 10685 1
- 10690 1
- 10703 1
- 10720 1
- 10739 1
- 10761 1
- 10792 1
- 10802 1
- 10826 1
- 10855 1
- 10872 1
- 10910 1
- 10954 1
- 10982 1
- 11018 1
- 11043 1
- 11058 1
- 11094 1
- 11135 1
- 11194 1
- 11250 1
- 11282 1
- 11309 1
- 11360 1
- 11379 1
- 11450 1
- 11495 1
- 11530 1
- 11592 1
- 11636 1
- 11676 1
- 11697 1
- 11774 1
- 11818 1
- 11870 1
- 11919 1
- 11948 1
- 11984 1
- 12041 1
- 12117 1
- 12173 1
- 12263 1
- 12316 1
- 12372 1
- 12478 1
- 12559 1
- 12680 1
- 12753 1
- 12851 1
- 12903 1
- 12943 1
- 13028 1
- 13112 1
- 13191 1
- 13272 1
- 13358 1
- 13403 1
- 13487 1
- 13531 1
- 13569 1
- 13647 1
- 13712 1
- 13784 1
- 13839 1
- 13899 1
- 13984 1
- 14088 1
- 14203 1
- 14334 1
- 14401 1
- 14507 1
- 14591 1
- 14675 1
- 14784 1
- 14919 1
- 15036 1
- 15220 1
- 15341 1
- 15460 1
- 15650 1
- 15821 1
- 16056 1
- 16259 1
- 16495 1
- 16781 1
- 16927 1
- 17249 1
- 17534 1
- 17817 1
- 18098 1
- 18427 1
- 18716 1
- 18926 1
- 19207 1
- 19478 1
- 19784 1
- 20010 1
- 20128 1
- 20539 1
- 20749 1
- 21053 1
- 21359 1
- 21713 1
- 22122 1
- 22468 1
- 22929 1
- 23168 1
- 23616 1
- 23961 1
- 24375 1
- 24652 1
- 25095 1
- 25382 1
- 25775 1
- 26075 1
- 26561 1
- 26920 1
- 27253 1
- 27659 1
- 28050 1
- 28333 1
- 28795 1
- 29170 1
- 29540 1
- 29987 1
- 30255 1
- 30461 1
- 30732 1
- 31099 1
- 31482 1
- 31937 1
- 32442 1
- 32915 1
- 33268 1
- 36128 1
- 36634 1
- 37132 1
- 37815 1
- 38540 1
- 39149 1
- 39698 1
- 40185 1
- 40500 1
- 41117 1
- 41736 1
- 42298 1
- 42764 1
- 43173 1
- 43562 1
- 44025 1
- 44463 1
- 44877 1
- 45267 1
- 45865 1
- 46254 1
- 46683 1
- 47083 1
- 47508 1
- 47835 1
- 48350 1
- 48804 1
- 49109 1
- 49378 1
- 49604 1
- 49757 1
- 50005 1
- 50314 1
- 50695 1
- 51104 1
- 51350 1
- 51693 1
- 52017 1
- 52311 1
- 52646 1
- 52951 1
- 53108 1
- 53221 1
- 53604 1
- 53935 1
- 54178 1
- 54467 1
- 54680 1
- 54892 1
- 55082 1
- 55359 1
- 55651 1
- 56025 1
- 56380 1
- 56659 1
- 56878 1
- 57157 1
- 57460 1
- 57808 1
- 58113 1
- 58515 1
- 58923 1
- 59141 1
- 59340 1
- 59856 1
- 60229 1
- 60556 1
- 60968 1
- 61340 1
- 61647 1
- 61940 1
- 62277 1
- 62683 1
- 63054 1
- 63415 1
- 63919 1
- 64209 1
- 64489 1
- 64966 1
- 65307 1
- 65718 1
- 66172 1
- 66584 1
- 66940 1
- 67270 1
- 67701 1
- 67982 1
- 68357 1
- 68700 1
- 69024 1
- 69268 1
- 69492 1
- 69781 1
- 70111 1
- 70418 1
- 70788 1
- 71096 1
- 71353 1
- 71517 1
- 71790 1
- 72065 1
- 72295 1
- 72594 1
- 72910 1
- 73105 1
- 73288 1
- 73468 1
- 73722 1
- 73835 1
- 73918 1
- 73934 1
- 74048 1
- 74123 1
- 74160 1
- 74286 1
- 74312 1
- 74367 1
- 74408 1
- 74445 1
- 74506 1
- 74552 1
- 74656 1
- 74731 1
- 74794 1
- 74839 1
- 74857 1
- 74890 1
- 74943 1
- 74950 1
- 74959 1
- 74962 1
- 75010 1
- 75042 1
- 75065 1
- 75121 1
- 75167 1
- 75218 1
- 75260 1
- 75297 1
- 75315 1
- 75329 1
- 75349 1
- 75370 1
- 75415 1
- 75426 1
- 75436 1
- 75451 1
- 75464 1
- 75473 1
- 75485 1
- 75510 1
- 75525 1
- 75543 1
- 75565 1
- 75579 1
- 75593 1
- 75612 1
- 75635 1
- 75660 1
- 75661 1
- 75683 1
- 75689 1
- 75701 1
- 75715 1
- 75737 1
- 75739 1
- 75769 1
- 75795 1
- 75817 1
- 75839 1
- 75863 1
- 75900 1
- 75939 1
- 75977 1
- 76019 1
- 76038 1
- 76066 1
- 76104 1
- 76135 1
- 76180 1
- 76210 1
- 76242 1
- 76258 1
- 76279 1
- 76350 1
- 76390 1
- 76447 1
- 76499 1
- 76533 1
- 76551 1
- 76595 1
- 76640 1
- 76687 1
- 76744 1
- 76808 1
- 76861 1
- 76883 1
- 76968 1
- 77080 1
- 77199 1
- 77339 1
- 77463 1
- 77554 1
- 77602 1
- 77696 1
- 77815 1
- 77923 1
- 78057 1
- 78212 1
- 78332 1
- 78434 1
- 78591 1
- 78754 1
- 78923 1
- 79095 1
- 79255 1
- 79374 1
- 79441 1
- 79638 1
- 79825 1
- 79966 1
- 80173 1
- 80350 1
- 80456 1
- 80605 1
- 80753 1
- 80914 1
- 81094 1
- 81409 1
- 81580 1
- 81703 1
- 81875 1
- 82067 1
- 82303 1
- 82500 1
- 82705 1
- 82876 1
- 83074 1
- 83196 1
- 83390 1
- 83628 1
- 83876 1
- 84071 1
- 84262 1
- 84400 1
- 84568 1
- 84599 1
- 85009 1
- 85178 1
- 85446 1
- 85649 1
- 85815 1
- 85941 1
- 86115 1
- 86312 1
- 86548 1
- 86747 1
- 86963 1
- 87145 1
- 87251 1
- 87421 1
- 87609 1
- 87806 1
- 87989 1
- 88125 1
- 88227 1
- 88308 1
- 88459 1
- 88640 1
- 88842 1
- 88963 1
- 89153 1
- 89283 1
- 89397 1
- 89551 1
- 89683 1
- 89812 1
- 89965 1
- 90100 1
- 90201 1
- 90262 1
- 90397 1
- 90533 1
- 90666 1
- 90799 1
- 90926 1
- 91039 1
- 91120 1
- 91239 1
- 91387 1
- 91510 1
- 91662 1
- 91778 1
- 91855 1
- 91939 1
- 92040 1
- 92155 1
- 92322 1
- 92442 1
- 92576 1
- 92695 1
- 92776 1
- 92855 1
- 93009 1
- 93165 1
- 93330 1
- 93496 1
- 93617 1
- 93703 1
- 93850 1
- 94056 1
- 94227 1
- 94419 1
- 94570 1
- 94744 1
- 94908 1
- 95047 1
- 95251 1
- 95443 1
- 95726 1
- 95939 1
- 96127 1
- 96266 1
- 96491 1
- 96698 1
- 96938 1
- 97152 1
- 97353 1
- 97561 1
- 97773 1
- 98046 1
- 98372 1
- 98795 1
- 99169 1
- 99609 1
- 99999 1
- 100327 1
- 100638 1
- 101071 1
- 101558 1
- 102057 1
- 102443 1
- 102815 1
- 103060 1
- 103450 1
- 103901 1
- 104535 1
- 105269 1
- 105850 1
- 106392 1
- 106958 1
- 107571 1
- 108566 1
- 109721 1
- 110867 1
- 112299 1
- 113105 1
- 113623 1
- 114570 1
- 116439 1
- 118371 1
- 120641 1
- 122843 1
- 124591 1
- 125875 1
- 127687 1
- 130654 1
- 132835 1
- 135558 1
- 137819 1
- 139771 1
- 141204 1
- 142867 1
- 144343 1
- 145918 1
- 147301 1
- 148425 1
- 149376 1
- 150003 1
- 150632 1
- 151317 1
- 152065 1
- 152795 1
- 153520 1
- 154441 1
- 154821 1
- 155249 1
- 155755 1
- 156224 1
- 156965 1
- 157361 1
- 157558 1
- 157697 1
- 157930 1
- 158191 1
- 158429 1
- 158638 1
- 158864 1
- 159018 1
- 159135 1
- 159259 1
- 159452 1
- 159626 1
- 159812 1
- 159938 1
- 160068 1
- 160177 1
- 160273 1
- 160365 1
- 160496 1
- 160615 1
- 160715 1
- 160780 1
- 160824 1
- 160886 1
- 160952 1
- 161059 1
- 161113 1
- 161185 1
- 161265 1
- 161308 1
- 161401 1
- 161484 1
- 161567 1
- 161644 1
- 161691 1
- 161716 1
- 161754 1
- 161811 1
- 161845 1
- 161980 1
- 162118 1
- 162155 1
- 162207 1
- 162273 1
- 162345 1
- 162428 1
- 162501 1
- 162547 1
- 162601 1
- 162652 1
- 162728 1
- 162804 1
- 162889 1
- 162967 1
- 163043 1
- 163105 1
- 163195 1
- 163301 1
- 163417 1
- 163538 1
- 163672 1
- 163756 1
- 163831 1
- 163963 1
- 164098 1
- 164253 1
- 164462 1
- 164612 1
- 164792 1
- 164900 1
- 165068 1
- 165245 1
- 165868 1
- 166013 1
- 166117 1
- 166252 1
- 166476 1
- 166686 1
- 166886 1
- 167085 1
- 167207 1
- 167320 1
- 167511 1
- 167698 1
- 167967 1
- 168218 1
- 168474 1
- 168677 1
- 168932 1
- 169112 1
- 169379 1
- 169692 1
- 169999 1
- 170294 1
- 170552 1
- 170700 1
- 171009 1
- 171404 1
- 171810 1
- 172251 1
state 1
- New Jersey 796
fips 1
- 34025 796
county 1
- Monmouth · 796 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
944 | 944 | 2020-03-09 | Monmouth | New Jersey | 34025 | 2 | 0 |
1095 | 1095 | 2020-03-10 | Monmouth | New Jersey | 34025 | 2 | 0 |
1278 | 1278 | 2020-03-11 | Monmouth | New Jersey | 34025 | 4 | 0 |
1508 | 1508 | 2020-03-12 | Monmouth | New Jersey | 34025 | 5 | 0 |
1800 | 1800 | 2020-03-13 | Monmouth | New Jersey | 34025 | 7 | 0 |
2147 | 2147 | 2020-03-14 | Monmouth | New Jersey | 34025 | 8 | 1 |
2555 | 2555 | 2020-03-15 | Monmouth | New Jersey | 34025 | 11 | 1 |
3012 | 3012 | 2020-03-16 | Monmouth | New Jersey | 34025 | 14 | 1 |
3525 | 3525 | 2020-03-17 | Monmouth | New Jersey | 34025 | 22 | 1 |
4121 | 4121 | 2020-03-18 | Monmouth | New Jersey | 34025 | 32 | 1 |
4848 | 4848 | 2020-03-19 | Monmouth | New Jersey | 34025 | 43 | 1 |
5692 | 5692 | 2020-03-20 | Monmouth | New Jersey | 34025 | 53 | 1 |
6685 | 6685 | 2020-03-21 | Monmouth | New Jersey | 34025 | 92 | 2 |
7776 | 7776 | 2020-03-22 | Monmouth | New Jersey | 34025 | 158 | 2 |
8972 | 8972 | 2020-03-23 | Monmouth | New Jersey | 34025 | 238 | 2 |
10276 | 10276 | 2020-03-24 | Monmouth | New Jersey | 34025 | 288 | 4 |
11708 | 11708 | 2020-03-25 | Monmouth | New Jersey | 34025 | 313 | 6 |
13311 | 13311 | 2020-03-26 | Monmouth | New Jersey | 34025 | 501 | 7 |
15043 | 15043 | 2020-03-27 | Monmouth | New Jersey | 34025 | 634 | 10 |
16872 | 16872 | 2020-03-28 | Monmouth | New Jersey | 34025 | 781 | 10 |
18796 | 18796 | 2020-03-29 | Monmouth | New Jersey | 34025 | 870 | 10 |
20834 | 20834 | 2020-03-30 | Monmouth | New Jersey | 34025 | 1030 | 15 |
22957 | 22957 | 2020-03-31 | Monmouth | New Jersey | 34025 | 1140 | 21 |
25148 | 25148 | 2020-04-01 | Monmouth | New Jersey | 34025 | 1301 | 24 |
27408 | 27408 | 2020-04-02 | Monmouth | New Jersey | 34025 | 1458 | 38 |
29731 | 29731 | 2020-04-03 | Monmouth | New Jersey | 34025 | 1743 | 48 |
32116 | 32116 | 2020-04-04 | Monmouth | New Jersey | 34025 | 2065 | 54 |
34547 | 34547 | 2020-04-05 | Monmouth | New Jersey | 34025 | 2354 | 58 |
37017 | 37017 | 2020-04-06 | Monmouth | New Jersey | 34025 | 2545 | 62 |
39532 | 39532 | 2020-04-07 | Monmouth | New Jersey | 34025 | 2770 | 71 |
42089 | 42089 | 2020-04-08 | Monmouth | New Jersey | 34025 | 3038 | 86 |
44671 | 44671 | 2020-04-09 | Monmouth | New Jersey | 34025 | 3248 | 98 |
47283 | 47283 | 2020-04-10 | Monmouth | New Jersey | 34025 | 3496 | 107 |
49937 | 49937 | 2020-04-11 | Monmouth | New Jersey | 34025 | 3651 | 115 |
52610 | 52610 | 2020-04-12 | Monmouth | New Jersey | 34025 | 3785 | 123 |
55293 | 55293 | 2020-04-13 | Monmouth | New Jersey | 34025 | 3875 | 127 |
57993 | 57993 | 2020-04-14 | Monmouth | New Jersey | 34025 | 4003 | 145 |
60707 | 60707 | 2020-04-15 | Monmouth | New Jersey | 34025 | 4122 | 167 |
63433 | 63433 | 2020-04-16 | Monmouth | New Jersey | 34025 | 4299 | 190 |
66175 | 66175 | 2020-04-17 | Monmouth | New Jersey | 34025 | 4414 | 206 |
68931 | 68931 | 2020-04-18 | Monmouth | New Jersey | 34025 | 4528 | 221 |
71698 | 71698 | 2020-04-19 | Monmouth | New Jersey | 34025 | 4669 | 226 |
74473 | 74473 | 2020-04-20 | Monmouth | New Jersey | 34025 | 4787 | 230 |
77254 | 77254 | 2020-04-21 | Monmouth | New Jersey | 34025 | 4947 | 244 |
80043 | 80043 | 2020-04-22 | Monmouth | New Jersey | 34025 | 5086 | 251 |
82841 | 82841 | 2020-04-23 | Monmouth | New Jersey | 34025 | 5238 | 260 |
85645 | 85645 | 2020-04-24 | Monmouth | New Jersey | 34025 | 5368 | 273 |
88456 | 88456 | 2020-04-25 | Monmouth | New Jersey | 34025 | 5521 | 287 |
91271 | 91271 | 2020-04-26 | Monmouth | New Jersey | 34025 | 5671 | 291 |
94095 | 94095 | 2020-04-27 | Monmouth | New Jersey | 34025 | 5759 | 302 |
96931 | 96931 | 2020-04-28 | Monmouth | New Jersey | 34025 | 5826 | 305 |
99778 | 99778 | 2020-04-29 | Monmouth | New Jersey | 34025 | 5907 | 317 |
102631 | 102631 | 2020-04-30 | Monmouth | New Jersey | 34025 | 6033 | 341 |
105493 | 105493 | 2020-05-01 | Monmouth | New Jersey | 34025 | 6132 | 355 |
108359 | 108359 | 2020-05-02 | Monmouth | New Jersey | 34025 | 6198 | 372 |
111232 | 111232 | 2020-05-03 | Monmouth | New Jersey | 34025 | 6290 | 382 |
114113 | 114113 | 2020-05-04 | Monmouth | New Jersey | 34025 | 6378 | 385 |
116994 | 116994 | 2020-05-05 | Monmouth | New Jersey | 34025 | 6490 | 398 |
119955 | 119955 | 2020-05-06 | Monmouth | New Jersey | 34025 | 6552 | 417 |
122930 | 122930 | 2020-05-07 | Monmouth | New Jersey | 34025 | 6649 | 428 |
125913 | 125913 | 2020-05-08 | Monmouth | New Jersey | 34025 | 6752 | 429 |
128902 | 128902 | 2020-05-09 | Monmouth | New Jersey | 34025 | 6815 | 439 |
131891 | 131891 | 2020-05-10 | Monmouth | New Jersey | 34025 | 6894 | 443 |
134882 | 134882 | 2020-05-11 | Monmouth | New Jersey | 34025 | 6988 | 445 |
137872 | 137872 | 2020-05-12 | Monmouth | New Jersey | 34025 | 7041 | 460 |
140868 | 140868 | 2020-05-13 | Monmouth | New Jersey | 34025 | 7090 | 466 |
143863 | 143863 | 2020-05-14 | Monmouth | New Jersey | 34025 | 7164 | 480 |
146864 | 146864 | 2020-05-15 | Monmouth | New Jersey | 34025 | 7224 | 495 |
149871 | 149871 | 2020-05-16 | Monmouth | New Jersey | 34025 | 7297 | 503 |
152881 | 152881 | 2020-05-17 | Monmouth | New Jersey | 34025 | 7339 | 508 |
155897 | 155897 | 2020-05-18 | Monmouth | New Jersey | 34025 | 7408 | 513 |
158915 | 158915 | 2020-05-19 | Monmouth | New Jersey | 34025 | 7470 | 520 |
161941 | 161941 | 2020-05-20 | Monmouth | New Jersey | 34025 | 7541 | 531 |
164970 | 164970 | 2020-05-21 | Monmouth | New Jersey | 34025 | 7637 | 537 |
168006 | 168006 | 2020-05-22 | Monmouth | New Jersey | 34025 | 7695 | 543 |
171045 | 171045 | 2020-05-23 | Monmouth | New Jersey | 34025 | 7720 | 551 |
174087 | 174087 | 2020-05-24 | Monmouth | New Jersey | 34025 | 7800 | 556 |
177130 | 177130 | 2020-05-25 | Monmouth | New Jersey | 34025 | 7865 | 556 |
180174 | 180174 | 2020-05-26 | Monmouth | New Jersey | 34025 | 7911 | 559 |
183222 | 183222 | 2020-05-27 | Monmouth | New Jersey | 34025 | 7961 | 575 |
186279 | 186279 | 2020-05-28 | Monmouth | New Jersey | 34025 | 8012 | 578 |
189339 | 189339 | 2020-05-29 | Monmouth | New Jersey | 34025 | 8100 | 587 |
192403 | 192403 | 2020-05-30 | Monmouth | New Jersey | 34025 | 8159 | 596 |
195473 | 195473 | 2020-05-31 | Monmouth | New Jersey | 34025 | 8219 | 597 |
198546 | 198546 | 2020-06-01 | Monmouth | New Jersey | 34025 | 8249 | 599 |
201620 | 201620 | 2020-06-02 | Monmouth | New Jersey | 34025 | 8289 | 608 |
204697 | 204697 | 2020-06-03 | Monmouth | New Jersey | 34025 | 8332 | 619 |
207778 | 207778 | 2020-06-04 | Monmouth | New Jersey | 34025 | 8379 | 627 |
210860 | 210860 | 2020-06-05 | Monmouth | New Jersey | 34025 | 8428 | 630 |
213944 | 213944 | 2020-06-06 | Monmouth | New Jersey | 34025 | 8454 | 636 |
220125 | 220125 | 2020-06-08 | Monmouth | New Jersey | 34025 | 8498 | 640 |
217033 | 217033 | 2020-06-07 | Monmouth | New Jersey | 34025 | 8478 | 641 |
223220 | 223220 | 2020-06-09 | Monmouth | New Jersey | 34025 | 8512 | 650 |
226320 | 226320 | 2020-06-10 | Monmouth | New Jersey | 34025 | 8563 | 652 |
229424 | 229424 | 2020-06-11 | Monmouth | New Jersey | 34025 | 8627 | 661 |
232529 | 232529 | 2020-06-12 | Monmouth | New Jersey | 34025 | 8660 | 662 |
235634 | 235634 | 2020-06-13 | Monmouth | New Jersey | 34025 | 8720 | 667 |
238741 | 238741 | 2020-06-14 | Monmouth | New Jersey | 34025 | 8740 | 672 |
241851 | 241851 | 2020-06-15 | Monmouth | New Jersey | 34025 | 8761 | 678 |
244963 | 244963 | 2020-06-16 | Monmouth | New Jersey | 34025 | 8786 | 687 |
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);