ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where fips = 34003 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 797 ✖
- 3 2
- 21551 2
- 219942 2
- 226592 2
- 1 1
- 2 1
- 4 1
- 5 1
- 7 1
- 11 1
- 13 1
- 17 1
- 31 1
- 32 1
- 61 1
- 84 1
- 133 1
- 297 1
- 342 1
- 362 1
- 457 1
- 609 1
- 701 1
- 819 1
- 1206 1
- 1505 1
- 1838 1
- 2169 1
- 2482 1
- 2909 1
- 3494 1
- 4099 1
- 4866 1
- 5760 1
- 6187 1
- 6862 1
- 7533 1
- 7874 1
- 8343 1
- 8928 1
- 9362 1
- 9784 1
- 10092 1
- 10426 1
- 10848 1
- 11409 1
- 11863 1
- 12163 1
- 12639 1
- 13011 1
- 13356 1
- 13686 1
- 14049 1
- 14363 1
- 14738 1
- 14965 1
- 15104 1
- 15251 1
- 15446 1
- 15610 1
- 15830 1
- 15974 1
- 16185 1
- 16282 1
- 16460 1
- 16520 1
- 16609 1
- 16709 1
- 16804 1
- 16929 1
- 17028 1
- 17080 1
- 17091 1
- 17150 1
- 17195 1
- 17246 1
- 17361 1
- 17459 1
- 17518 1
- 17522 1
- 17583 1
- 17653 1
- 17668 1
- 17804 1
- 17901 1
- 17963 1
- 18023 1
- 18158 1
- 18211 1
- 18223 1
- 18272 1
- 18302 1
- 18333 1
- 18376 1
- 18408 1
- 18463 1
- 18492 1
- 18512 1
- 18538 1
- 18573 1
- 18667 1
- 18719 1
- 18743 1
- 18805 1
- 18818 1
- 18848 1
- 18901 1
- 18928 1
- 18949 1
- 18967 1
- 18996 1
- 19010 1
- 19037 1
- 19069 1
- 19097 1
- 19430 1
- 19527 1
- 19538 1
- 19617 1
- 19638 1
- 19686 1
- 19708 1
- 19735 1
- 19793 1
- 19823 1
- 19886 1
- 19916 1
- 19937 1
- 19993 1
- 20043 1
- 20099 1
- 20119 1
- 20143 1
- 20163 1
- 20179 1
- 20195 1
- 20218 1
- 20234 1
- 20247 1
- 20248 1
- 20302 1
- 20320 1
- 20362 1
- 20396 1
- 20425 1
- 20455 1
- 20489 1
- 20543 1
- 20604 1
- 20646 1
- 20667 1
- 20727 1
- 20749 1
- 20776 1
- 20807 1
- 20864 1
- 20890 1
- 20920 1
- 20945 1
- 21002 1
- 21045 1
- 21076 1
- 21115 1
- 21147 1
- 21188 1
- 21306 1
- 21368 1
- 21443 1
- 21505 1
- 21525 1
- 21526 1
- 21560 1
- 21570 1
- 21596 1
- 21639 1
- 21678 1
- 21696 1
- 21716 1
- 21762 1
- 21799 1
- 21842 1
- 21907 1
- 21933 1
- 21966 1
- 21994 1
- 21997 1
- 22030 1
- 22058 1
- 22086 1
- 22115 1
- 22137 1
- 22168 1
- 22178 1
- 22209 1
- 22238 1
- 22242 1
- 22273 1
- 22330 1
- 22362 1
- 22388 1
- 22411 1
- 22440 1
- 22494 1
- 22519 1
- 22547 1
- 22574 1
- 22606 1
- 22649 1
- 22682 1
- 22716 1
- 22751 1
- 22820 1
- 22874 1
- 22933 1
- 22975 1
- 23015 1
- 23068 1
- 23118 1
- 23201 1
- 23273 1
- 23349 1
- 23415 1
- 23463 1
- 23565 1
- 23633 1
- 23737 1
- 23811 1
- 23881 1
- 23980 1
- 24087 1
- 24187 1
- 24309 1
- 24415 1
- 24502 1
- 24651 1
- 24770 1
- 24891 1
- 25038 1
- 25133 1
- 25270 1
- 25478 1
- 25609 1
- 25769 1
- 25920 1
- 26095 1
- 26310 1
- 26415 1
- 26627 1
- 26959 1
- 27169 1
- 27305 1
- 27606 1
- 27923 1
- 28331 1
- 28682 1
- 29067 1
- 29469 1
- 29655 1
- 30046 1
- 30470 1
- 30912 1
- 31252 1
- 31693 1
- 32097 1
- 32491 1
- 32827 1
- 33162 1
- 33578 1
- 34125 1
- 34333 1
- 34833 1
- 35121 1
- 35577 1
- 35978 1
- 36478 1
- 37092 1
- 37602 1
- 38145 1
- 38479 1
- 38854 1
- 39133 1
- 39557 1
- 39842 1
- 40369 1
- 40737 1
- 41133 1
- 41470 1
- 41897 1
- 42264 1
- 42657 1
- 43007 1
- 43375 1
- 43626 1
- 43963 1
- 44426 1
- 44886 1
- 45324 1
- 45620 1
- 45845 1
- 46100 1
- 46412 1
- 46826 1
- 47362 1
- 47833 1
- 48265 1
- 48565 1
- 53188 1
- 53821 1
- 54435 1
- 55096 1
- 55774 1
- 56360 1
- 56890 1
- 57259 1
- 57609 1
- 58354 1
- 59102 1
- 59684 1
- 60224 1
- 60704 1
- 60985 1
- 61469 1
- 62042 1
- 62551 1
- 62908 1
- 63563 1
- 64044 1
- 64390 1
- 64848 1
- 65338 1
- 65850 1
- 66318 1
- 66836 1
- 67253 1
- 67609 1
- 67912 1
- 68134 1
- 68542 1
- 69047 1
- 69523 1
- 69951 1
- 70209 1
- 70526 1
- 70978 1
- 71373 1
- 71752 1
- 72165 1
- 72420 1
- 72567 1
- 73077 1
- 73454 1
- 73819 1
- 74126 1
- 74471 1
- 74698 1
- 75062 1
- 75478 1
- 75860 1
- 76339 1
- 76862 1
- 77290 1
- 77537 1
- 78040 1
- 78445 1
- 78951 1
- 79332 1
- 79796 1
- 80008 1
- 80339 1
- 80605 1
- 81125 1
- 81535 1
- 82037 1
- 82488 1
- 82880 1
- 83263 1
- 83594 1
- 84076 1
- 84573 1
- 85044 1
- 85586 1
- 86106 1
- 86467 1
- 86830 1
- 87348 1
- 87799 1
- 88162 1
- 88904 1
- 89471 1
- 90006 1
- 90376 1
- 90918 1
- 91488 1
- 92021 1
- 92547 1
- 93058 1
- 93426 1
- 93767 1
- 94130 1
- 94657 1
- 95067 1
- 95466 1
- 95842 1
- 96164 1
- 96411 1
- 96748 1
- 97118 1
- 97483 1
- 97885 1
- 98258 1
- 98483 1
- 98660 1
- 98913 1
- 99235 1
- 99542 1
- 99780 1
- 100060 1
- 100210 1
- 100215 1
- 100407 1
- 100594 1
- 100826 1
- 100988 1
- 101120 1
- 101198 1
- 101287 1
- 101383 1
- 102678 1
- 103082 1
- 103164 1
- 103253 1
- 103314 1
- 103352 1
- 103408 1
- 103494 1
- 103542 1
- 103613 1
- 103703 1
- 103752 1
- 103797 1
- 103831 1
- 103872 1
- 103898 1
- 103965 1
- 103993 1
- 104022 1
- 104054 1
- 104101 1
- 104142 1
- 104177 1
- 104206 1
- 104225 1
- 104237 1
- 104255 1
- 104270 1
- 104287 1
- 104301 1
- 104328 1
- 104369 1
- 104391 1
- 104409 1
- 104427 1
- 104449 1
- 104476 1
- 104508 1
- 104528 1
- 104553 1
- 104574 1
- 104610 1
- 104634 1
- 104653 1
- 104680 1
- 104694 1
- 104711 1
- 104721 1
- 104751 1
- 104791 1
- 104835 1
- 104860 1
- 104885 1
- 104908 1
- 104921 1
- 104955 1
- 104996 1
- 105028 1
- 105056 1
- 105080 1
- 105086 1
- 105095 1
- 105108 1
- 105129 1
- 105159 1
- 105181 1
- 105203 1
- 105235 1
- 105249 1
- 105290 1
- 105338 1
- 105384 1
- 105434 1
- 105485 1
- 105517 1
- 105547 1
- 105595 1
- 105647 1
- 105735 1
- 105835 1
- 105922 1
- 105987 1
- 106059 1
- 106138 1
- 106239 1
- 106361 1
- 106473 1
- 106588 1
- 106692 1
- 106777 1
- 106906 1
- 107009 1
- 107133 1
- 107269 1
- 107380 1
- 107471 1
- 107533 1
- 107723 1
- 107878 1
- 108073 1
- 108214 1
- 108434 1
- 108442 1
- 108537 1
- 108738 1
- 108919 1
- 109069 1
- 109346 1
- 109524 1
- 109664 1
- 109793 1
- 109953 1
- 110157 1
- 110336 1
- 110555 1
- 110760 1
- 110922 1
- 111046 1
- 111219 1
- 111399 1
- 111592 1
- 111723 1
- 111922 1
- 112069 1
- 112228 1
- 112265 1
- 112548 1
- 112749 1
- 112981 1
- 113188 1
- 113340 1
- 113448 1
- 113652 1
- 113835 1
- 114050 1
- 114230 1
- 114435 1
- 114602 1
- 114724 1
- 114862 1
- 115071 1
- 115270 1
- 115505 1
- 115691 1
- 115835 1
- 115960 1
- 116094 1
- 116280 1
- 116488 1
- 116662 1
- 116830 1
- 116922 1
- 117022 1
- 117153 1
- 117321 1
- 117476 1
- 117607 1
- 117750 1
- 117873 1
- 117928 1
- 118050 1
- 118198 1
- 118337 1
- 118458 1
- 118621 1
- 118678 1
- 118756 1
- 118812 1
- 118896 1
- 118984 1
- 119123 1
- 119208 1
- 119267 1
- 119375 1
- 119509 1
- 119619 1
- 119767 1
- 119911 1
- 120023 1
- 120092 1
- 120162 1
- 120240 1
- 120364 1
- 120461 1
- 120571 1
- 120671 1
- 120734 1
- 120802 1
- 120902 1
- 121000 1
- 121137 1
- 121265 1
- 121389 1
- 121543 1
- 121652 1
- 121816 1
- 122016 1
- 122200 1
- 122393 1
- 122588 1
- 122740 1
- 122850 1
- 123077 1
- 123245 1
- 123467 1
- 123649 1
- 123821 1
- 123973 1
- 124132 1
- 124405 1
- 124682 1
- 125013 1
- 125339 1
- 125650 1
- 125880 1
- 126141 1
- 126522 1
- 126851 1
- 127337 1
- 127771 1
- 128134 1
- 128476 1
- 128759 1
- 129112 1
- 129676 1
- 130341 1
- 131062 1
- 131854 1
- 132589 1
- 133193 1
- 134093 1
- 135459 1
- 137350 1
- 139544 1
- 141877 1
- 143393 1
- 144576 1
- 146477 1
- 149803 1
- 153956 1
- 157470 1
- 161029 1
- 163211 1
- 165317 1
- 168644 1
- 172553 1
- 175750 1
- 179690 1
- 183161 1
- 185731 1
- 188288 1
- 190864 1
- 193361 1
- 195515 1
- 197809 1
- 199476 1
- 200948 1
- 201991 1
- 203319 1
- 204434 1
- 205847 1
- 207078 1
- 207946 1
- 208895 1
- 209422 1
- 209989 1
- 210648 1
- 211102 1
- 211874 1
- 212402 1
- 212554 1
- 212807 1
- 213259 1
- 213651 1
- 214015 1
- 214265 1
- 214510 1
- 214717 1
- 214804 1
- 215019 1
- 215231 1
- 215633 1
- 215856 1
- 215997 1
- 216141 1
- 216281 1
- 216472 1
- 216644 1
- 216882 1
- 217124 1
- 217252 1
- 217418 1
- 217520 1
- 217630 1
- 217704 1
- 217888 1
- 218033 1
- 218186 1
- 218325 1
- 218390 1
- 218518 1
- 218696 1
- 218866 1
- 219036 1
- 219161 1
- 219245 1
- 219360 1
- 219506 1
- 219635 1
- 219824 1
- 220146 1
- 220183 1
- 220267 1
- 220589 1
- 220797 1
- 221017 1
- 221167 1
- 221267 1
- 221339 1
- 221493 1
- 221655 1
- 221825 1
- 221996 1
- 222128 1
- 222295 1
- 222380 1
- 222546 1
- 222720 1
- 222958 1
- 223164 1
- 223403 1
- 223569 1
- 223707 1
- 223979 1
- 224306 1
- 224616 1
- 224906 1
- 225103 1
- 225370 1
- 225549 1
- 225868 1
- 226211 1
- 227223 1
- 227474 1
- 227654 1
- 228011 1
- 228342 1
- 228676 1
- 229126 1
- 229529 1
- 229793 1
- 229865 1
- 230252 1
- 230656 1
- 231145 1
- 231623 1
- 232076 1
- 232411 1
- 232792 1
- 233225 1
- 233768 1
- 234326 1
- 234927 1
- 235523 1
- 236030 1
- 236300 1
- 236987 1
- 237703 1
- 238428 1
- 239353 1
state 1
- New Jersey 801
fips 1
- 34003 · 801 ✖
county 1
- Bergen 801
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
518 | 518 | 2020-03-04 | Bergen | New Jersey | 34003 | 1 | 0 |
564 | 564 | 2020-03-05 | Bergen | New Jersey | 34003 | 2 | 0 |
625 | 625 | 2020-03-06 | Bergen | New Jersey | 34003 | 3 | 0 |
713 | 713 | 2020-03-07 | Bergen | New Jersey | 34003 | 3 | 0 |
817 | 817 | 2020-03-08 | Bergen | New Jersey | 34003 | 4 | 0 |
941 | 941 | 2020-03-09 | Bergen | New Jersey | 34003 | 5 | 0 |
1091 | 1091 | 2020-03-10 | Bergen | New Jersey | 34003 | 7 | 1 |
1273 | 1273 | 2020-03-11 | Bergen | New Jersey | 34003 | 11 | 1 |
1502 | 1502 | 2020-03-12 | Bergen | New Jersey | 34003 | 13 | 1 |
1794 | 1794 | 2020-03-13 | Bergen | New Jersey | 34003 | 17 | 1 |
2140 | 2140 | 2020-03-14 | Bergen | New Jersey | 34003 | 31 | 1 |
2548 | 2548 | 2020-03-15 | Bergen | New Jersey | 34003 | 32 | 1 |
3004 | 3004 | 2020-03-16 | Bergen | New Jersey | 34003 | 61 | 2 |
3516 | 3516 | 2020-03-17 | Bergen | New Jersey | 34003 | 84 | 2 |
4112 | 4112 | 2020-03-18 | Bergen | New Jersey | 34003 | 133 | 4 |
4838 | 4838 | 2020-03-19 | Bergen | New Jersey | 34003 | 297 | 6 |
5681 | 5681 | 2020-03-20 | Bergen | New Jersey | 34003 | 342 | 7 |
6674 | 6674 | 2020-03-21 | Bergen | New Jersey | 34003 | 362 | 9 |
7765 | 7765 | 2020-03-22 | Bergen | New Jersey | 34003 | 457 | 10 |
8961 | 8961 | 2020-03-23 | Bergen | New Jersey | 34003 | 609 | 12 |
10265 | 10265 | 2020-03-24 | Bergen | New Jersey | 34003 | 701 | 14 |
11697 | 11697 | 2020-03-25 | Bergen | New Jersey | 34003 | 819 | 15 |
13300 | 13300 | 2020-03-26 | Bergen | New Jersey | 34003 | 1206 | 21 |
15032 | 15032 | 2020-03-27 | Bergen | New Jersey | 34003 | 1505 | 28 |
16861 | 16861 | 2020-03-28 | Bergen | New Jersey | 34003 | 1838 | 35 |
18785 | 18785 | 2020-03-29 | Bergen | New Jersey | 34003 | 2169 | 35 |
20823 | 20823 | 2020-03-30 | Bergen | New Jersey | 34003 | 2482 | 41 |
22946 | 22946 | 2020-03-31 | Bergen | New Jersey | 34003 | 2909 | 53 |
25137 | 25137 | 2020-04-01 | Bergen | New Jersey | 34003 | 3494 | 75 |
27397 | 27397 | 2020-04-02 | Bergen | New Jersey | 34003 | 4099 | 120 |
29720 | 29720 | 2020-04-03 | Bergen | New Jersey | 34003 | 4866 | 132 |
32105 | 32105 | 2020-04-04 | Bergen | New Jersey | 34003 | 5760 | 179 |
34536 | 34536 | 2020-04-05 | Bergen | New Jersey | 34003 | 6187 | 189 |
37006 | 37006 | 2020-04-06 | Bergen | New Jersey | 34003 | 6862 | 200 |
39521 | 39521 | 2020-04-07 | Bergen | New Jersey | 34003 | 7533 | 263 |
42078 | 42078 | 2020-04-08 | Bergen | New Jersey | 34003 | 7874 | 314 |
44660 | 44660 | 2020-04-09 | Bergen | New Jersey | 34003 | 8343 | 345 |
47272 | 47272 | 2020-04-10 | Bergen | New Jersey | 34003 | 8928 | 390 |
49926 | 49926 | 2020-04-11 | Bergen | New Jersey | 34003 | 9362 | 435 |
52599 | 52599 | 2020-04-12 | Bergen | New Jersey | 34003 | 9784 | 453 |
55282 | 55282 | 2020-04-13 | Bergen | New Jersey | 34003 | 10092 | 482 |
57982 | 57982 | 2020-04-14 | Bergen | New Jersey | 34003 | 10426 | 550 |
60696 | 60696 | 2020-04-15 | Bergen | New Jersey | 34003 | 10848 | 608 |
63422 | 63422 | 2020-04-16 | Bergen | New Jersey | 34003 | 11409 | 668 |
66164 | 66164 | 2020-04-17 | Bergen | New Jersey | 34003 | 11863 | 714 |
68920 | 68920 | 2020-04-18 | Bergen | New Jersey | 34003 | 12163 | 741 |
71687 | 71687 | 2020-04-19 | Bergen | New Jersey | 34003 | 12639 | 767 |
74462 | 74462 | 2020-04-20 | Bergen | New Jersey | 34003 | 13011 | 787 |
77243 | 77243 | 2020-04-21 | Bergen | New Jersey | 34003 | 13356 | 835 |
80032 | 80032 | 2020-04-22 | Bergen | New Jersey | 34003 | 13686 | 876 |
82830 | 82830 | 2020-04-23 | Bergen | New Jersey | 34003 | 14049 | 907 |
85634 | 85634 | 2020-04-24 | Bergen | New Jersey | 34003 | 14363 | 934 |
88445 | 88445 | 2020-04-25 | Bergen | New Jersey | 34003 | 14738 | 954 |
91260 | 91260 | 2020-04-26 | Bergen | New Jersey | 34003 | 14965 | 955 |
94084 | 94084 | 2020-04-27 | Bergen | New Jersey | 34003 | 15104 | 960 |
96920 | 96920 | 2020-04-28 | Bergen | New Jersey | 34003 | 15251 | 1002 |
99767 | 99767 | 2020-04-29 | Bergen | New Jersey | 34003 | 15446 | 1057 |
102620 | 102620 | 2020-04-30 | Bergen | New Jersey | 34003 | 15610 | 1136 |
105482 | 105482 | 2020-05-01 | Bergen | New Jersey | 34003 | 15830 | 1187 |
108348 | 108348 | 2020-05-02 | Bergen | New Jersey | 34003 | 15974 | 1202 |
111221 | 111221 | 2020-05-03 | Bergen | New Jersey | 34003 | 16185 | 1210 |
114102 | 114102 | 2020-05-04 | Bergen | New Jersey | 34003 | 16282 | 1215 |
116983 | 116983 | 2020-05-05 | Bergen | New Jersey | 34003 | 16460 | 1261 |
119944 | 119944 | 2020-05-06 | Bergen | New Jersey | 34003 | 16520 | 1289 |
122919 | 122919 | 2020-05-07 | Bergen | New Jersey | 34003 | 16609 | 1319 |
125902 | 125902 | 2020-05-08 | Bergen | New Jersey | 34003 | 16709 | 1329 |
128891 | 128891 | 2020-05-09 | Bergen | New Jersey | 34003 | 16804 | 1348 |
131880 | 131880 | 2020-05-10 | Bergen | New Jersey | 34003 | 16929 | 1355 |
134871 | 134871 | 2020-05-11 | Bergen | New Jersey | 34003 | 17028 | 1358 |
137861 | 137861 | 2020-05-12 | Bergen | New Jersey | 34003 | 17091 | 1388 |
140857 | 140857 | 2020-05-13 | Bergen | New Jersey | 34003 | 17150 | 1409 |
143852 | 143852 | 2020-05-14 | Bergen | New Jersey | 34003 | 17080 | 1423 |
146853 | 146853 | 2020-05-15 | Bergen | New Jersey | 34003 | 17195 | 1443 |
149860 | 149860 | 2020-05-16 | Bergen | New Jersey | 34003 | 17246 | 1450 |
152870 | 152870 | 2020-05-17 | Bergen | New Jersey | 34003 | 17361 | 1455 |
155886 | 155886 | 2020-05-18 | Bergen | New Jersey | 34003 | 17459 | 1460 |
158904 | 158904 | 2020-05-19 | Bergen | New Jersey | 34003 | 17522 | 1474 |
161930 | 161930 | 2020-05-20 | Bergen | New Jersey | 34003 | 17518 | 1500 |
164959 | 164959 | 2020-05-21 | Bergen | New Jersey | 34003 | 17583 | 1508 |
167995 | 167995 | 2020-05-22 | Bergen | New Jersey | 34003 | 17653 | 1515 |
171034 | 171034 | 2020-05-23 | Bergen | New Jersey | 34003 | 17668 | 1521 |
174076 | 174076 | 2020-05-24 | Bergen | New Jersey | 34003 | 17804 | 1525 |
177119 | 177119 | 2020-05-25 | Bergen | New Jersey | 34003 | 17901 | 1525 |
180163 | 180163 | 2020-05-26 | Bergen | New Jersey | 34003 | 17963 | 1528 |
183211 | 183211 | 2020-05-27 | Bergen | New Jersey | 34003 | 18023 | 1547 |
186268 | 186268 | 2020-05-28 | Bergen | New Jersey | 34003 | 18158 | 1553 |
189328 | 189328 | 2020-05-29 | Bergen | New Jersey | 34003 | 18223 | 1567 |
192392 | 192392 | 2020-05-30 | Bergen | New Jersey | 34003 | 18211 | 1573 |
195462 | 195462 | 2020-05-31 | Bergen | New Jersey | 34003 | 18272 | 1579 |
198535 | 198535 | 2020-06-01 | Bergen | New Jersey | 34003 | 18302 | 1580 |
201609 | 201609 | 2020-06-02 | Bergen | New Jersey | 34003 | 18333 | 1584 |
204686 | 204686 | 2020-06-03 | Bergen | New Jersey | 34003 | 18376 | 1595 |
207767 | 207767 | 2020-06-04 | Bergen | New Jersey | 34003 | 18408 | 1603 |
210849 | 210849 | 2020-06-05 | Bergen | New Jersey | 34003 | 18463 | 1611 |
213933 | 213933 | 2020-06-06 | Bergen | New Jersey | 34003 | 18492 | 1612 |
217022 | 217022 | 2020-06-07 | Bergen | New Jersey | 34003 | 18512 | 1618 |
220114 | 220114 | 2020-06-08 | Bergen | New Jersey | 34003 | 18538 | 1621 |
223209 | 223209 | 2020-06-09 | Bergen | New Jersey | 34003 | 18573 | 1628 |
226309 | 226309 | 2020-06-10 | Bergen | New Jersey | 34003 | 18667 | 1635 |
229413 | 229413 | 2020-06-11 | Bergen | New Jersey | 34003 | 18719 | 1646 |
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);