ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
840 rows where fips = 6059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 574 ✖
- 0 60
- 5136 6
- 1577 5
- 5675 5
- 1633 4
- 5126 4
- 5146 4
- 5864 4
- 5890 4
- 6308 4
- 6450 4
- 6927 4
- 6958 4
- 6990 4
- 7007 4
- 7011 4
- 14 3
- 17 3
- 19 3
- 88 3
- 131 3
- 1093 3
- 1341 3
- 1484 3
- 1526 3
- 3848 3
- 5031 3
- 5065 3
- 5103 3
- 5123 3
- 5135 3
- 5141 3
- 5144 3
- 5153 3
- 5161 3
- 5274 3
- 5384 3
- 5436 3
- 5475 3
- 5518 3
- 5562 3
- 5595 3
- 5615 3
- 5643 3
- 5661 3
- 5756 3
- 5814 3
- 5851 3
- 5906 3
- 5921 3
- 5953 3
- 6066 3
- 6152 3
- 6570 3
- 6658 3
- 6740 3
- 6828 3
- 6860 3
- 6886 3
- 6937 3
- 6966 3
- 6997 3
- 7009 3
- 7019 3
- 1 2
- 3 2
- 4 2
- 13 2
- 32 2
- 33 2
- 36 2
- 52 2
- 76 2
- 80 2
- 147 2
- 177 2
- 221 2
- 269 2
- 323 2
- 360 2
- 366 2
- 494 2
- 651 2
- 726 2
- 810 2
- 833 2
- 897 2
- 1053 2
- 1128 2
- 1216 2
- 1286 2
- 1409 2
- 1447 2
- 1509 2
- 1554 2
- 1559 2
- 1694 2
- 1782 2
- 1846 2
- 1875 2
- 1901 2
- 1926 2
- 2367 2
- 3493 2
- 3577 2
- 4486 2
- 4768 2
- 4839 2
- 4896 2
- 4933 2
- 4969 2
- 5008 2
- 5083 2
- 5109 2
- 5113 2
- 5129 2
- 5138 2
- 5139 2
- 5142 2
- 5143 2
- 5149 2
- 5155 2
- 5181 2
- 5354 2
- 5447 2
- 5634 2
- 7 1
- 10 1
- 15 1
- 18 1
- 22 1
- 25 1
- 28 1
- 34 1
- 38 1
- 39 1
- 40 1
- 42 1
- 44 1
- 45 1
- 50 1
- 57 1
- 61 1
- 65 1
- 66 1
- 71 1
- 74 1
- 78 1
- 84 1
- 86 1
- 98 1
- 112 1
- 118 1
- 130 1
- 136 1
- 142 1
- 145 1
- 146 1
- 150 1
- 158 1
- 165 1
- 174 1
- 176 1
- 185 1
- 198 1
- 202 1
- 210 1
- 217 1
- 233 1
- 243 1
- 250 1
- 257 1
- 267 1
- 275 1
- 299 1
- 306 1
- 326 1
- 330 1
- 340 1
- 345 1
- 354 1
- 363 1
- 369 1
- 376 1
- 402 1
- 412 1
- 421 1
- 423 1
- 433 1
- 455 1
- 466 1
- 469 1
- 493 1
- 513 1
- 521 1
- 543 1
- 556 1
- 562 1
- 564 1
- 566 1
- 581 1
- 587 1
- 604 1
- 618 1
- 649 1
- 653 1
- 665 1
- 697 1
- 704 1
- 720 1
- 734 1
- 745 1
- 769 1
- 789 1
- 809 1
- 815 1
- 882 1
- 896 1
- 912 1
- 918 1
- 947 1
- 956 1
- 975 1
- 979 1
- 980 1
- 988 1
- 1007 1
- 1018 1
- 1042 1
- 1051 1
- 1056 1
- 1065 1
- 1069 1
- 1081 1
- 1105 1
- 1111 1
- 1115 1
- 1123 1
- 1127 1
- 1150 1
- 1176 1
- 1182 1
- 1204 1
- 1214 1
- 1249 1
- 1268 1
- 1275 1
- 1281 1
- 1287 1
- 1289 1
- 1292 1
- 1306 1
- 1316 1
- 1340 1
- 1360 1
- 1391 1
- 1401 1
- 1410 1
- 1412 1
- 1423 1
- 1434 1
- 1440 1
- 1444 1
- 1454 1
- 1467 1
- 1468 1
- 1475 1
- 1483 1
- 1491 1
- 1494 1
- 1503 1
- 1506 1
- 1512 1
- 1514 1
- 1520 1
- 1522 1
- 1524 1
- 1528 1
- 1537 1
- 1540 1
- 1551 1
- 1556 1
- 1578 1
- 1586 1
- 1603 1
- 1618 1
- 1640 1
- 1662 1
- 1680 1
- 1695 1
- 1718 1
- 1731 1
- 1734 1
- 1760 1
- 1775 1
- 1777 1
- 1779 1
- 1781 1
- 1845 1
- 1847 1
- 1874 1
- 1943 1
- 1972 1
- 1998 1
- 2041 1
- 2091 1
- 2120 1
- 2148 1
- 2179 1
- 2195 1
- 2277 1
- 2320 1
- 2477 1
- 2508 1
- 2546 1
- 2547 1
- 2625 1
- 2638 1
- 2704 1
- 2768 1
- 2839 1
- 2868 1
- 2975 1
- 3018 1
- 3062 1
- 3109 1
- 3162 1
- 3199 1
- 3249 1
- 3279 1
- 3312 1
- 3358 1
- 3383 1
- 3416 1
- 3451 1
- 3544 1
- 3617 1
- 3644 1
- 3685 1
- 3726 1
- 3770 1
- 3810 1
- 3889 1
- 3892 1
- 3904 1
- 3917 1
- 3921 1
- 3952 1
- 3966 1
- 4013 1
- 4075 1
- 4173 1
- 4226 1
- 4252 1
- 4313 1
- 4346 1
- 4379 1
- 4408 1
- 4434 1
- 4465 1
- 4511 1
- 4522 1
- 4536 1
- 4562 1
- 4607 1
- 4608 1
- 4635 1
- 4646 1
- 4665 1
- 4684 1
- 4711 1
- 4725 1
- 4726 1
- 4740 1
- 4744 1
- 4755 1
- 4761 1
- 4772 1
- 4784 1
- 4791 1
- 4810 1
- 4826 1
- 4831 1
- 4849 1
- 4862 1
- 4869 1
- 4886 1
- 4891 1
- 4900 1
- 4902 1
- 4910 1
- 4918 1
- 4924 1
- 4939 1
- 4944 1
- 4948 1
- 4957 1
- 4965 1
- 4978 1
- 4979 1
- 4992 1
- 5000 1
- 5005 1
- 5017 1
- 5023 1
- 5026 1
- 5028 1
- 5030 1
- 5034 1
- 5038 1
- 5042 1
- 5047 1
- 5049 1
- 5052 1
- 5056 1
- 5057 1
- 5058 1
- 5059 1
- 5063 1
- 5068 1
- 5070 1
- 5073 1
- 5078 1
- 5088 1
- 5090 1
- 5092 1
- 5097 1
- 5101 1
- 5105 1
- 5108 1
- 5112 1
- 5114 1
- 5116 1
- 5117 1
- 5119 1
- 5124 1
- 5125 1
- 5132 1
- 5137 1
- 5158 1
- 5159 1
- 5165 1
- 5169 1
- 5176 1
- 5179 1
- 5184 1
- 5190 1
- 5197 1
- 5202 1
- 5206 1
- 5222 1
- 5223 1
- 5225 1
- 5229 1
- 5236 1
- 5250 1
- 5253 1
- 5286 1
- 5295 1
- 5299 1
- 5302 1
- 5306 1
- 5312 1
- 5316 1
- 5326 1
- 5337 1
- 5344 1
- 5346 1
- 5355 1
- 5363 1
- 5371 1
- 5409 1
- 5418 1
- 5426 1
- 5432 1
- 5454 1
- 5463 1
- 5499 1
- 5504 1
- 5508 1
- 5513 1
- 5528 1
- 5531 1
- 5538 1
- 5550 1
- 5578 1
- 5584 1
- 5588 1
- 5592 1
- 5596 1
- 5602 1
- 5609 1
- 5612 1
- 5618 1
- 5623 1
- 5648 1
- 5652 1
- 5653 1
- 5659 1
- 5664 1
- 5666 1
- 5710 1
- 5725 1
- 5736 1
- 5749 1
- 5771 1
- 5783 1
- 5796 1
- 5806 1
- 5825 1
- 5829 1
- 5839 1
- 5846 1
- 5853 1
- 5857 1
- 5859 1
- 5877 1
- 5883 1
- 5888 1
- 5895 1
- 5897 1
- 5901 1
- 5903 1
- 5908 1
- 5911 1
- 5914 1
- 5916 1
- 5932 1
- 5938 1
- 5941 1
- 5946 1
- 5970 1
- 5978 1
- 6006 1
- 6037 1
- 6100 1
- 6110 1
- 6126 1
- 6140 1
- 6180 1
- 6205 1
- 6265 1
- 6358 1
- 6376 1
- 6395 1
- 6419 1
- 6505 1
- 6524 1
- 6544 1
- 6609 1
- 6617 1
- 6628 1
- 6643 1
- 6689 1
- 6696 1
- 6704 1
- 6721 1
- 6778 1
- 6783 1
- 6794 1
- 6820 1
- 6843 1
- 6846 1
- 6856 1
- 6857 1
- 6864 1
- 6875 1
- 6880 1
- 6884 1
- 6891 1
- 6901 1
- 6910 1
- 6919 1
- 7023 1
state 1
- California 840
fips 1
- 6059 · 840 ✖
county 1
- Orange 840
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499791 | 2499791 | 2022-05-13 | Orange | California | 6059 | 600384 | 7023 |
2496533 | 2496533 | 2022-05-12 | Orange | California | 6059 | 598954 | 7019 |
2493275 | 2493275 | 2022-05-11 | Orange | California | 6059 | 598954 | 7019 |
2490017 | 2490017 | 2022-05-10 | Orange | California | 6059 | 598954 | 7019 |
2486760 | 2486760 | 2022-05-09 | Orange | California | 6059 | 597100 | 7011 |
2483502 | 2483502 | 2022-05-08 | Orange | California | 6059 | 597100 | 7011 |
2480244 | 2480244 | 2022-05-07 | Orange | California | 6059 | 597100 | 7011 |
2476986 | 2476986 | 2022-05-06 | Orange | California | 6059 | 597100 | 7011 |
2473728 | 2473728 | 2022-05-05 | Orange | California | 6059 | 595487 | 7009 |
2470471 | 2470471 | 2022-05-04 | Orange | California | 6059 | 595487 | 7009 |
2467215 | 2467215 | 2022-05-03 | Orange | California | 6059 | 595487 | 7009 |
2463960 | 2463960 | 2022-05-02 | Orange | California | 6059 | 594132 | 7007 |
2460704 | 2460704 | 2022-05-01 | Orange | California | 6059 | 594132 | 7007 |
2457448 | 2457448 | 2022-04-30 | Orange | California | 6059 | 594132 | 7007 |
2454192 | 2454192 | 2022-04-29 | Orange | California | 6059 | 594132 | 7007 |
2450936 | 2450936 | 2022-04-28 | Orange | California | 6059 | 592872 | 6997 |
2447680 | 2447680 | 2022-04-27 | Orange | California | 6059 | 592872 | 6997 |
2444424 | 2444424 | 2022-04-26 | Orange | California | 6059 | 592872 | 6997 |
2441168 | 2441168 | 2022-04-25 | Orange | California | 6059 | 591778 | 6990 |
2437912 | 2437912 | 2022-04-24 | Orange | California | 6059 | 591778 | 6990 |
2434656 | 2434656 | 2022-04-23 | Orange | California | 6059 | 591778 | 6990 |
2431400 | 2431400 | 2022-04-22 | Orange | California | 6059 | 591778 | 6990 |
2428144 | 2428144 | 2022-04-21 | Orange | California | 6059 | 590828 | 6966 |
2424888 | 2424888 | 2022-04-20 | Orange | California | 6059 | 590828 | 6966 |
2421632 | 2421632 | 2022-04-19 | Orange | California | 6059 | 590828 | 6966 |
2418376 | 2418376 | 2022-04-18 | Orange | California | 6059 | 590003 | 6958 |
2415120 | 2415120 | 2022-04-17 | Orange | California | 6059 | 590003 | 6958 |
2411864 | 2411864 | 2022-04-16 | Orange | California | 6059 | 590003 | 6958 |
2408608 | 2408608 | 2022-04-15 | Orange | California | 6059 | 590003 | 6958 |
2405352 | 2405352 | 2022-04-14 | Orange | California | 6059 | 589475 | 6937 |
2402097 | 2402097 | 2022-04-13 | Orange | California | 6059 | 588344 | 6937 |
2398842 | 2398842 | 2022-04-12 | Orange | California | 6059 | 588344 | 6937 |
2395587 | 2395587 | 2022-04-11 | Orange | California | 6059 | 588344 | 6927 |
2392331 | 2392331 | 2022-04-10 | Orange | California | 6059 | 588344 | 6927 |
2389075 | 2389075 | 2022-04-09 | Orange | California | 6059 | 588344 | 6927 |
2385820 | 2385820 | 2022-04-08 | Orange | California | 6059 | 588344 | 6927 |
2382565 | 2382565 | 2022-04-07 | Orange | California | 6059 | 587852 | 6919 |
2379310 | 2379310 | 2022-04-06 | Orange | California | 6059 | 587852 | 6910 |
2376056 | 2376056 | 2022-04-05 | Orange | California | 6059 | 587852 | 6901 |
2372804 | 2372804 | 2022-04-04 | Orange | California | 6059 | 587408 | 6891 |
2369551 | 2369551 | 2022-04-03 | Orange | California | 6059 | 587408 | 6886 |
2366298 | 2366298 | 2022-04-02 | Orange | California | 6059 | 587408 | 6886 |
2363045 | 2363045 | 2022-04-01 | Orange | California | 6059 | 587408 | 6886 |
2359791 | 2359791 | 2022-03-31 | Orange | California | 6059 | 587256 | 6884 |
2356537 | 2356537 | 2022-03-30 | Orange | California | 6059 | 587066 | 6880 |
2353284 | 2353284 | 2022-03-29 | Orange | California | 6059 | 586934 | 6875 |
2350032 | 2350032 | 2022-03-28 | Orange | California | 6059 | 586878 | 6864 |
2346779 | 2346779 | 2022-03-27 | Orange | California | 6059 | 586528 | 6860 |
2343526 | 2343526 | 2022-03-26 | Orange | California | 6059 | 586528 | 6860 |
2340273 | 2340273 | 2022-03-25 | Orange | California | 6059 | 586528 | 6860 |
2337020 | 2337020 | 2022-03-24 | Orange | California | 6059 | 586392 | 6857 |
2333766 | 2333766 | 2022-03-23 | Orange | California | 6059 | 586266 | 6856 |
2330512 | 2330512 | 2022-03-22 | Orange | California | 6059 | 586134 | 6846 |
2327260 | 2327260 | 2022-03-21 | Orange | California | 6059 | 586053 | 6843 |
2324007 | 2324007 | 2022-03-20 | Orange | California | 6059 | 585098 | 6828 |
2320753 | 2320753 | 2022-03-19 | Orange | California | 6059 | 585098 | 6828 |
2317499 | 2317499 | 2022-03-18 | Orange | California | 6059 | 585098 | 6828 |
2314246 | 2314246 | 2022-03-17 | Orange | California | 6059 | 584517 | 6820 |
2310993 | 2310993 | 2022-03-16 | Orange | California | 6059 | 584262 | 6794 |
2307740 | 2307740 | 2022-03-15 | Orange | California | 6059 | 584164 | 6783 |
2304489 | 2304489 | 2022-03-14 | Orange | California | 6059 | 584101 | 6778 |
2301237 | 2301237 | 2022-03-13 | Orange | California | 6059 | 583419 | 6740 |
2297985 | 2297985 | 2022-03-12 | Orange | California | 6059 | 583419 | 6740 |
2294733 | 2294733 | 2022-03-11 | Orange | California | 6059 | 583419 | 6740 |
2291481 | 2291481 | 2022-03-10 | Orange | California | 6059 | 583343 | 6721 |
2288229 | 2288229 | 2022-03-09 | Orange | California | 6059 | 582968 | 6704 |
2284978 | 2284978 | 2022-03-08 | Orange | California | 6059 | 582832 | 6696 |
2281726 | 2281726 | 2022-03-07 | Orange | California | 6059 | 582707 | 6689 |
2278473 | 2278473 | 2022-03-06 | Orange | California | 6059 | 582267 | 6658 |
2275220 | 2275220 | 2022-03-05 | Orange | California | 6059 | 582267 | 6658 |
2271967 | 2271967 | 2022-03-04 | Orange | California | 6059 | 582267 | 6658 |
2268715 | 2268715 | 2022-03-03 | Orange | California | 6059 | 582034 | 6643 |
2265462 | 2265462 | 2022-03-02 | Orange | California | 6059 | 581567 | 6628 |
2262211 | 2262211 | 2022-03-01 | Orange | California | 6059 | 581352 | 6617 |
2258960 | 2258960 | 2022-02-28 | Orange | California | 6059 | 581172 | 6609 |
2255709 | 2255709 | 2022-02-27 | Orange | California | 6059 | 580505 | 6570 |
2252458 | 2252458 | 2022-02-26 | Orange | California | 6059 | 580505 | 6570 |
2249207 | 2249207 | 2022-02-25 | Orange | California | 6059 | 580505 | 6570 |
2245956 | 2245956 | 2022-02-24 | Orange | California | 6059 | 580144 | 6544 |
2242705 | 2242705 | 2022-02-23 | Orange | California | 6059 | 579815 | 6524 |
2239454 | 2239454 | 2022-02-22 | Orange | California | 6059 | 579493 | 6505 |
2236203 | 2236203 | 2022-02-21 | Orange | California | 6059 | 578444 | 6450 |
2232952 | 2232952 | 2022-02-20 | Orange | California | 6059 | 578444 | 6450 |
2229701 | 2229701 | 2022-02-19 | Orange | California | 6059 | 578444 | 6450 |
2226450 | 2226450 | 2022-02-18 | Orange | California | 6059 | 578444 | 6450 |
2223199 | 2223199 | 2022-02-17 | Orange | California | 6059 | 578359 | 6419 |
2219948 | 2219948 | 2022-02-16 | Orange | California | 6059 | 577597 | 6395 |
2216697 | 2216697 | 2022-02-15 | Orange | California | 6059 | 577043 | 6376 |
2213446 | 2213446 | 2022-02-14 | Orange | California | 6059 | 576253 | 6358 |
2210194 | 2210194 | 2022-02-13 | Orange | California | 6059 | 574622 | 6308 |
2206941 | 2206941 | 2022-02-12 | Orange | California | 6059 | 574622 | 6308 |
2203688 | 2203688 | 2022-02-11 | Orange | California | 6059 | 574622 | 6308 |
2200435 | 2200435 | 2022-02-10 | Orange | California | 6059 | 574435 | 6308 |
2197181 | 2197181 | 2022-02-09 | Orange | California | 6059 | 573049 | 6265 |
2193926 | 2193926 | 2022-02-08 | Orange | California | 6059 | 570984 | 6205 |
2190673 | 2190673 | 2022-02-07 | Orange | California | 6059 | 567448 | 6180 |
2187420 | 2187420 | 2022-02-06 | Orange | California | 6059 | 567058 | 6152 |
2184167 | 2184167 | 2022-02-05 | Orange | California | 6059 | 567058 | 6152 |
2180915 | 2180915 | 2022-02-04 | Orange | California | 6059 | 567058 | 6152 |
2177664 | 2177664 | 2022-02-03 | Orange | California | 6059 | 563960 | 6140 |
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);