ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "New Castle" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 779 ✖
- 4 3
- 147142 3
- 148584 3
- 149662 3
- 1205 2
- 8694 2
- 65138 2
- 79813 2
- 82472 2
- 147959 2
- 150458 2
- 1 1
- 7 1
- 8 1
- 15 1
- 20 1
- 23 1
- 28 1
- 32 1
- 39 1
- 58 1
- 71 1
- 79 1
- 91 1
- 106 1
- 130 1
- 141 1
- 156 1
- 197 1
- 226 1
- 245 1
- 279 1
- 400 1
- 436 1
- 496 1
- 571 1
- 636 1
- 701 1
- 751 1
- 807 1
- 880 1
- 919 1
- 947 1
- 974 1
- 1003 1
- 1100 1
- 1229 1
- 1303 1
- 1352 1
- 1389 1
- 1486 1
- 1504 1
- 1599 1
- 1629 1
- 1701 1
- 1717 1
- 1734 1
- 1829 1
- 1864 1
- 1903 1
- 1934 1
- 1979 1
- 2087 1
- 2130 1
- 2184 1
- 2275 1
- 2331 1
- 2390 1
- 2440 1
- 2496 1
- 2560 1
- 2619 1
- 2667 1
- 2682 1
- 2738 1
- 2845 1
- 2933 1
- 3053 1
- 3132 1
- 3238 1
- 3309 1
- 3436 1
- 3508 1
- 3528 1
- 3575 1
- 3629 1
- 3723 1
- 3758 1
- 3838 1
- 3883 1
- 3903 1
- 3925 1
- 3937 1
- 3995 1
- 4070 1
- 4095 1
- 4125 1
- 4139 1
- 4171 1
- 4224 1
- 4259 1
- 4287 1
- 4345 1
- 4386 1
- 4422 1
- 4470 1
- 4522 1
- 4569 1
- 4647 1
- 4682 1
- 4697 1
- 4720 1
- 4791 1
- 4840 1
- 4871 1
- 4925 1
- 5031 1
- 5065 1
- 5079 1
- 5183 1
- 5277 1
- 5334 1
- 5398 1
- 5489 1
- 5555 1
- 5583 1
- 5626 1
- 5688 1
- 5732 1
- 5759 1
- 5797 1
- 5860 1
- 5904 1
- 5935 1
- 5981 1
- 6028 1
- 6070 1
- 6125 1
- 6206 1
- 6231 1
- 6296 1
- 6408 1
- 6414 1
- 6480 1
- 6560 1
- 6588 1
- 6682 1
- 6743 1
- 6794 1
- 6843 1
- 6868 1
- 6938 1
- 6994 1
- 7042 1
- 7092 1
- 7130 1
- 7161 1
- 7206 1
- 7243 1
- 7276 1
- 7309 1
- 7379 1
- 7450 1
- 7490 1
- 7524 1
- 7580 1
- 7617 1
- 7661 1
- 7705 1
- 7737 1
- 7771 1
- 7826 1
- 7865 1
- 7890 1
- 7925 1
- 7927 1
- 7989 1
- 8109 1
- 8139 1
- 8190 1
- 8250 1
- 8285 1
- 8360 1
- 8415 1
- 8516 1
- 8601 1
- 8656 1
- 8805 1
- 8880 1
- 8989 1
- 9092 1
- 9146 1
- 9262 1
- 9351 1
- 9418 1
- 9480 1
- 9521 1
- 9590 1
- 9663 1
- 9731 1
- 9777 1
- 9865 1
- 9975 1
- 10029 1
- 10106 1
- 10198 1
- 10309 1
- 10368 1
- 10520 1
- 10813 1
- 10936 1
- 11005 1
- 11087 1
- 11159 1
- 11216 1
- 11297 1
- 11399 1
- 11507 1
- 11593 1
- 11688 1
- 11747 1
- 11787 1
- 11851 1
- 11958 1
- 12059 1
- 12153 1
- 12200 1
- 12277 1
- 12311 1
- 12401 1
- 12491 1
- 12579 1
- 12646 1
- 12776 1
- 12814 1
- 12895 1
- 12989 1
- 13079 1
- 13192 1
- 13259 1
- 13394 1
- 13451 1
- 13507 1
- 13639 1
- 13818 1
- 13964 1
- 14204 1
- 14414 1
- 14545 1
- 14675 1
- 14800 1
- 15113 1
- 15341 1
- 15629 1
- 15866 1
- 16123 1
- 16240 1
- 16490 1
- 16900 1
- 17262 1
- 17587 1
- 17820 1
- 18121 1
- 18359 1
- 18709 1
- 19088 1
- 19409 1
- 19788 1
- 20004 1
- 20501 1
- 20700 1
- 21211 1
- 21753 1
- 22204 1
- 22705 1
- 23109 1
- 23576 1
- 24250 1
- 24705 1
- 25107 1
- 25771 1
- 26089 1
- 26653 1
- 27095 1
- 27602 1
- 28075 1
- 28235 1
- 28869 1
- 29126 1
- 29300 1
- 29647 1
- 30058 1
- 30526 1
- 30964 1
- 31370 1
- 31697 1
- 31963 1
- 32426 1
- 32686 1
- 33211 1
- 33433 1
- 33852 1
- 34182 1
- 34641 1
- 35085 1
- 35434 1
- 36188 1
- 36424 1
- 36913 1
- 37396 1
- 37674 1
- 38033 1
- 38451 1
- 38955 1
- 39339 1
- 39678 1
- 40199 1
- 40497 1
- 40753 1
- 41012 1
- 41472 1
- 41819 1
- 42180 1
- 42499 1
- 42872 1
- 43025 1
- 43190 1
- 43541 1
- 43763 1
- 44073 1
- 44340 1
- 44570 1
- 44683 1
- 44833 1
- 44932 1
- 45112 1
- 45277 1
- 45742 1
- 45935 1
- 46076 1
- 46237 1
- 46455 1
- 46681 1
- 46949 1
- 47134 1
- 47278 1
- 47349 1
- 47465 1
- 47608 1
- 47842 1
- 48047 1
- 48142 1
- 48396 1
- 48493 1
- 48647 1
- 48833 1
- 49019 1
- 49304 1
- 49523 1
- 49741 1
- 49817 1
- 49967 1
- 50129 1
- 50278 1
- 50449 1
- 50614 1
- 50757 1
- 50844 1
- 50991 1
- 51712 1
- 51890 1
- 52084 1
- 52228 1
- 52413 1
- 52512 1
- 52763 1
- 52986 1
- 53148 1
- 53323 1
- 53561 1
- 53672 1
- 53818 1
- 53966 1
- 54110 1
- 54318 1
- 54554 1
- 54815 1
- 55064 1
- 55191 1
- 55327 1
- 55599 1
- 55871 1
- 56201 1
- 56411 1
- 56541 1
- 56715 1
- 56868 1
- 57112 1
- 57358 1
- 57630 1
- 57861 1
- 58126 1
- 58265 1
- 58498 1
- 58789 1
- 59049 1
- 59355 1
- 59610 1
- 59884 1
- 59996 1
- 60187 1
- 60366 1
- 60591 1
- 60777 1
- 60970 1
- 61111 1
- 61218 1
- 61359 1
- 61447 1
- 61647 1
- 61787 1
- 61935 1
- 62047 1
- 62151 1
- 62273 1
- 62381 1
- 62514 1
- 62615 1
- 62734 1
- 62805 1
- 62862 1
- 62915 1
- 62991 1
- 63077 1
- 63166 1
- 63262 1
- 63317 1
- 63374 1
- 63953 1
- 64017 1
- 64107 1
- 64183 1
- 64248 1
- 64279 1
- 64329 1
- 64351 1
- 64396 1
- 64448 1
- 64504 1
- 64524 1
- 64555 1
- 64566 1
- 64578 1
- 64608 1
- 64631 1
- 64656 1
- 64690 1
- 64716 1
- 64726 1
- 64742 1
- 64761 1
- 64784 1
- 64802 1
- 64823 1
- 64842 1
- 64865 1
- 64866 1
- 64897 1
- 64907 1
- 64923 1
- 64937 1
- 64945 1
- 64954 1
- 64964 1
- 64976 1
- 64987 1
- 64999 1
- 65016 1
- 65030 1
- 65034 1
- 65053 1
- 65059 1
- 65087 1
- 65099 1
- 65119 1
- 65131 1
- 65151 1
- 65182 1
- 65205 1
- 65240 1
- 65251 1
- 65263 1
- 65301 1
- 65320 1
- 65339 1
- 65382 1
- 65399 1
- 65421 1
- 65444 1
- 65467 1
- 65506 1
- 65530 1
- 65570 1
- 65613 1
- 65660 1
- 65710 1
- 65747 1
- 65806 1
- 65889 1
- 65963 1
- 66033 1
- 66094 1
- 66144 1
- 66198 1
- 66275 1
- 66383 1
- 66504 1
- 66602 1
- 66702 1
- 66767 1
- 66836 1
- 66990 1
- 67120 1
- 67274 1
- 67394 1
- 67549 1
- 67618 1
- 67764 1
- 67965 1
- 68162 1
- 68353 1
- 68493 1
- 68630 1
- 68740 1
- 68878 1
- 69101 1
- 69360 1
- 69507 1
- 69660 1
- 69877 1
- 69966 1
- 70118 1
- 70381 1
- 70664 1
- 70857 1
- 71033 1
- 71154 1
- 71325 1
- 71452 1
- 71594 1
- 71938 1
- 72267 1
- 72576 1
- 72781 1
- 72930 1
- 73024 1
- 73296 1
- 73601 1
- 73907 1
- 74119 1
- 74331 1
- 74466 1
- 74576 1
- 74873 1
- 75137 1
- 75442 1
- 75622 1
- 75822 1
- 75979 1
- 76146 1
- 76411 1
- 76690 1
- 77001 1
- 77190 1
- 77369 1
- 77518 1
- 77755 1
- 77993 1
- 78233 1
- 78539 1
- 78643 1
- 78856 1
- 78941 1
- 79107 1
- 79349 1
- 79540 1
- 80125 1
- 80214 1
- 80364 1
- 80529 1
- 80725 1
- 80933 1
- 81061 1
- 81222 1
- 81267 1
- 81406 1
- 81556 1
- 81667 1
- 81889 1
- 82013 1
- 82126 1
- 82163 1
- 82309 1
- 82779 1
- 82929 1
- 83071 1
- 83110 1
- 83253 1
- 83446 1
- 83692 1
- 83851 1
- 84042 1
- 84140 1
- 84157 1
- 84235 1
- 84309 1
- 84462 1
- 85352 1
- 85521 1
- 85662 1
- 85810 1
- 85974 1
- 86194 1
- 86497 1
- 86641 1
- 86770 1
- 86901 1
- 87086 1
- 87424 1
- 87743 1
- 88159 1
- 88612 1
- 88888 1
- 89112 1
- 89279 1
- 89589 1
- 89970 1
- 90416 1
- 90795 1
- 91096 1
- 91454 1
- 91588 1
- 91873 1
- 92205 1
- 92734 1
- 93189 1
- 93554 1
- 93921 1
- 94218 1
- 94520 1
- 95144 1
- 95970 1
- 96862 1
- 97631 1
- 97915 1
- 98237 1
- 98819 1
- 100020 1
- 101913 1
- 104426 1
- 106161 1
- 107755 1
- 109060 1
- 109986 1
- 111837 1
- 113698 1
- 115882 1
- 117976 1
- 119730 1
- 121001 1
- 123038 1
- 125537 1
- 127278 1
- 128976 1
- 130278 1
- 131345 1
- 132118 1
- 132866 1
- 133641 1
- 134821 1
- 135915 1
- 136824 1
- 137494 1
- 138002 1
- 138376 1
- 139117 1
- 139775 1
- 140248 1
- 140567 1
- 140842 1
- 141029 1
- 141217 1
- 141653 1
- 141965 1
- 142195 1
- 142416 1
- 142562 1
- 142688 1
- 142887 1
- 143136 1
- 143381 1
- 143526 1
- 143648 1
- 143779 1
- 143852 1
- 143931 1
- 144131 1
- 144281 1
- 144399 1
- 144489 1
- 144554 1
- 144600 1
- 144648 1
- 145096 1
- 145173 1
- 145234 1
- 145301 1
- 145343 1
- 145354 1
- 145409 1
- 145490 1
- 145585 1
- 145662 1
- 145717 1
- 145740 1
- 145762 1
- 145797 1
- 146011 1
- 146106 1
- 146146 1
- 146189 1
- 146208 1
- 146237 1
- 146269 1
- 146306 1
- 146366 1
- 146418 1
- 146469 1
- 146494 1
- 146512 1
- 146551 1
- 146569 1
- 146629 1
- 146667 1
- 146707 1
- 146758 1
- 146761 1
- 146801 1
- 146816 1
- 146867 1
- 146884 1
- 146894 1
- 146910 1
- 146944 1
- 147004 1
- 147005 1
- 147067 1
- 147127 1
- 147168 1
- 147192 1
- 147219 1
- 147265 1
- 147367 1
- 147434 1
- 147472 1
- 147570 1
- 147677 1
- 147791 1
- 148107 1
- 148164 1
- 148290 1
- 148439 1
- 149023 1
- 149087 1
- 149200 1
- 149457 1
- 150312 1
- 151033 1
- 151392 1
state 1
- Delaware 794
fips 1
- 10003 794
county 1
- New Castle · 794 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499894 | 2499894 | 2022-05-13 | New Castle | Delaware | 10003 | 151392 | 1424 |
2496636 | 2496636 | 2022-05-12 | New Castle | Delaware | 10003 | 151033 | 1423 |
2493378 | 2493378 | 2022-05-11 | New Castle | Delaware | 10003 | 150458 | 1423 |
2490120 | 2490120 | 2022-05-10 | New Castle | Delaware | 10003 | 150458 | 1423 |
2486863 | 2486863 | 2022-05-09 | New Castle | Delaware | 10003 | 150312 | 1423 |
2483605 | 2483605 | 2022-05-08 | New Castle | Delaware | 10003 | 149662 | 1423 |
2480347 | 2480347 | 2022-05-07 | New Castle | Delaware | 10003 | 149662 | 1423 |
2477089 | 2477089 | 2022-05-06 | New Castle | Delaware | 10003 | 149662 | 1423 |
2473831 | 2473831 | 2022-05-05 | New Castle | Delaware | 10003 | 149457 | 1420 |
2470574 | 2470574 | 2022-05-04 | New Castle | Delaware | 10003 | 149200 | 1420 |
2467318 | 2467318 | 2022-05-03 | New Castle | Delaware | 10003 | 149087 | 1420 |
2464063 | 2464063 | 2022-05-02 | New Castle | Delaware | 10003 | 149023 | 1420 |
2460807 | 2460807 | 2022-05-01 | New Castle | Delaware | 10003 | 148584 | 1414 |
2457551 | 2457551 | 2022-04-30 | New Castle | Delaware | 10003 | 148584 | 1414 |
2454295 | 2454295 | 2022-04-29 | New Castle | Delaware | 10003 | 148584 | 1414 |
2451039 | 2451039 | 2022-04-28 | New Castle | Delaware | 10003 | 148439 | 1413 |
2447783 | 2447783 | 2022-04-27 | New Castle | Delaware | 10003 | 148290 | 1413 |
2444527 | 2444527 | 2022-04-26 | New Castle | Delaware | 10003 | 148164 | 1413 |
2441271 | 2441271 | 2022-04-25 | New Castle | Delaware | 10003 | 148107 | 1412 |
2438015 | 2438015 | 2022-04-24 | New Castle | Delaware | 10003 | 147959 | 1412 |
2434759 | 2434759 | 2022-04-23 | New Castle | Delaware | 10003 | 147959 | 1412 |
2431503 | 2431503 | 2022-04-22 | New Castle | Delaware | 10003 | 147791 | 1408 |
2428247 | 2428247 | 2022-04-21 | New Castle | Delaware | 10003 | 147677 | 1408 |
2424991 | 2424991 | 2022-04-20 | New Castle | Delaware | 10003 | 147570 | 1408 |
2421735 | 2421735 | 2022-04-19 | New Castle | Delaware | 10003 | 147472 | 1408 |
2418479 | 2418479 | 2022-04-18 | New Castle | Delaware | 10003 | 147434 | 1407 |
2415223 | 2415223 | 2022-04-17 | New Castle | Delaware | 10003 | 147142 | 1407 |
2411967 | 2411967 | 2022-04-16 | New Castle | Delaware | 10003 | 147142 | 1407 |
2408711 | 2408711 | 2022-04-15 | New Castle | Delaware | 10003 | 147142 | 1407 |
2405455 | 2405455 | 2022-04-14 | New Castle | Delaware | 10003 | 147005 | 1400 |
2402200 | 2402200 | 2022-04-13 | New Castle | Delaware | 10003 | 146894 | 1400 |
2398945 | 2398945 | 2022-04-12 | New Castle | Delaware | 10003 | 146801 | 1400 |
2395690 | 2395690 | 2022-04-11 | New Castle | Delaware | 10003 | 146761 | 1400 |
2392434 | 2392434 | 2022-04-10 | New Castle | Delaware | 10003 | 146707 | 1400 |
2389178 | 2389178 | 2022-04-09 | New Castle | Delaware | 10003 | 146629 | 1400 |
2385923 | 2385923 | 2022-04-08 | New Castle | Delaware | 10003 | 146569 | 1396 |
2382668 | 2382668 | 2022-04-07 | New Castle | Delaware | 10003 | 147367 | 1396 |
2379413 | 2379413 | 2022-04-06 | New Castle | Delaware | 10003 | 147265 | 1396 |
2376159 | 2376159 | 2022-04-05 | New Castle | Delaware | 10003 | 147219 | 1396 |
2372907 | 2372907 | 2022-04-04 | New Castle | Delaware | 10003 | 147192 | 1395 |
2369654 | 2369654 | 2022-04-03 | New Castle | Delaware | 10003 | 147168 | 1395 |
2366401 | 2366401 | 2022-04-02 | New Castle | Delaware | 10003 | 147127 | 1395 |
2363148 | 2363148 | 2022-04-01 | New Castle | Delaware | 10003 | 147067 | 1383 |
2359894 | 2359894 | 2022-03-31 | New Castle | Delaware | 10003 | 147004 | 1383 |
2356640 | 2356640 | 2022-03-30 | New Castle | Delaware | 10003 | 146944 | 1383 |
2353387 | 2353387 | 2022-03-29 | New Castle | Delaware | 10003 | 146910 | 1383 |
2350135 | 2350135 | 2022-03-28 | New Castle | Delaware | 10003 | 146884 | 1383 |
2346882 | 2346882 | 2022-03-27 | New Castle | Delaware | 10003 | 146867 | 1383 |
2343629 | 2343629 | 2022-03-26 | New Castle | Delaware | 10003 | 146816 | 1383 |
2340376 | 2340376 | 2022-03-25 | New Castle | Delaware | 10003 | 146758 | 1379 |
2337123 | 2337123 | 2022-03-24 | New Castle | Delaware | 10003 | 146667 | 1379 |
2333869 | 2333869 | 2022-03-23 | New Castle | Delaware | 10003 | 146551 | 1379 |
2330615 | 2330615 | 2022-03-22 | New Castle | Delaware | 10003 | 146512 | 1379 |
2327363 | 2327363 | 2022-03-21 | New Castle | Delaware | 10003 | 146494 | 1379 |
2324110 | 2324110 | 2022-03-20 | New Castle | Delaware | 10003 | 146469 | 1379 |
2320856 | 2320856 | 2022-03-19 | New Castle | Delaware | 10003 | 146418 | 1379 |
2317602 | 2317602 | 2022-03-18 | New Castle | Delaware | 10003 | 146366 | 1368 |
2314349 | 2314349 | 2022-03-17 | New Castle | Delaware | 10003 | 146306 | 1368 |
2311096 | 2311096 | 2022-03-16 | New Castle | Delaware | 10003 | 146269 | 1368 |
2307843 | 2307843 | 2022-03-15 | New Castle | Delaware | 10003 | 146237 | 1368 |
2304592 | 2304592 | 2022-03-14 | New Castle | Delaware | 10003 | 146208 | 1367 |
2301340 | 2301340 | 2022-03-13 | New Castle | Delaware | 10003 | 146189 | 1367 |
2298088 | 2298088 | 2022-03-12 | New Castle | Delaware | 10003 | 146146 | 1367 |
2294836 | 2294836 | 2022-03-11 | New Castle | Delaware | 10003 | 146106 | 1338 |
2291584 | 2291584 | 2022-03-10 | New Castle | Delaware | 10003 | 146011 | 1338 |
2288332 | 2288332 | 2022-03-09 | New Castle | Delaware | 10003 | 145797 | 1338 |
2285081 | 2285081 | 2022-03-08 | New Castle | Delaware | 10003 | 145762 | 1338 |
2281829 | 2281829 | 2022-03-07 | New Castle | Delaware | 10003 | 145740 | 1338 |
2278576 | 2278576 | 2022-03-06 | New Castle | Delaware | 10003 | 145717 | 1338 |
2275323 | 2275323 | 2022-03-05 | New Castle | Delaware | 10003 | 145662 | 1338 |
2272070 | 2272070 | 2022-03-04 | New Castle | Delaware | 10003 | 145585 | 1312 |
2268818 | 2268818 | 2022-03-03 | New Castle | Delaware | 10003 | 145490 | 1311 |
2265565 | 2265565 | 2022-03-02 | New Castle | Delaware | 10003 | 145409 | 1311 |
2262314 | 2262314 | 2022-03-01 | New Castle | Delaware | 10003 | 145354 | 1311 |
2259063 | 2259063 | 2022-02-28 | New Castle | Delaware | 10003 | 145343 | 1310 |
2255812 | 2255812 | 2022-02-27 | New Castle | Delaware | 10003 | 145301 | 1310 |
2252561 | 2252561 | 2022-02-26 | New Castle | Delaware | 10003 | 145234 | 1310 |
2249310 | 2249310 | 2022-02-25 | New Castle | Delaware | 10003 | 145173 | 1310 |
2246059 | 2246059 | 2022-02-24 | New Castle | Delaware | 10003 | 145096 | 1309 |
2242808 | 2242808 | 2022-02-23 | New Castle | Delaware | 10003 | 144648 | 1309 |
2239557 | 2239557 | 2022-02-22 | New Castle | Delaware | 10003 | 144600 | 1308 |
2236306 | 2236306 | 2022-02-21 | New Castle | Delaware | 10003 | 144554 | 1307 |
2233055 | 2233055 | 2022-02-20 | New Castle | Delaware | 10003 | 144489 | 1307 |
2229804 | 2229804 | 2022-02-19 | New Castle | Delaware | 10003 | 144399 | 1307 |
2226553 | 2226553 | 2022-02-18 | New Castle | Delaware | 10003 | 144281 | 1285 |
2223302 | 2223302 | 2022-02-17 | New Castle | Delaware | 10003 | 144131 | 1282 |
2220051 | 2220051 | 2022-02-16 | New Castle | Delaware | 10003 | 143931 | 1281 |
2216800 | 2216800 | 2022-02-15 | New Castle | Delaware | 10003 | 143852 | 1280 |
2213549 | 2213549 | 2022-02-14 | New Castle | Delaware | 10003 | 143779 | 1278 |
2210297 | 2210297 | 2022-02-13 | New Castle | Delaware | 10003 | 143648 | 1278 |
2207044 | 2207044 | 2022-02-12 | New Castle | Delaware | 10003 | 143526 | 1278 |
2203791 | 2203791 | 2022-02-11 | New Castle | Delaware | 10003 | 143381 | 1253 |
2200538 | 2200538 | 2022-02-10 | New Castle | Delaware | 10003 | 143136 | 1253 |
2197284 | 2197284 | 2022-02-09 | New Castle | Delaware | 10003 | 142887 | 1253 |
2194030 | 2194030 | 2022-02-08 | New Castle | Delaware | 10003 | 142688 | 1250 |
2190776 | 2190776 | 2022-02-07 | New Castle | Delaware | 10003 | 142562 | 1246 |
2187523 | 2187523 | 2022-02-06 | New Castle | Delaware | 10003 | 142416 | 1246 |
2184270 | 2184270 | 2022-02-05 | New Castle | Delaware | 10003 | 142195 | 1246 |
2181018 | 2181018 | 2022-02-04 | New Castle | Delaware | 10003 | 141965 | 1236 |
2177767 | 2177767 | 2022-02-03 | New Castle | Delaware | 10003 | 141653 | 1234 |
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);