ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where county = "Sacramento" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 653 ✖
- 3 12
- 1 5
- 167399 5
- 106264 4
- 108827 4
- 174652 4
- 296151 4
- 303101 4
- 304008 4
- 305497 4
- 307868 4
- 310696 4
- 312308 4
- 9 3
- 52 3
- 164 3
- 1132 3
- 104957 3
- 105603 3
- 106713 3
- 107637 3
- 111080 3
- 112421 3
- 114630 3
- 117648 3
- 151658 3
- 153979 3
- 155773 3
- 157620 3
- 159635 3
- 161821 3
- 163644 3
- 166604 3
- 169094 3
- 170836 3
- 172460 3
- 179588 3
- 192347 3
- 219460 3
- 247777 3
- 270928 3
- 285282 3
- 292828 3
- 298886 3
- 300180 3
- 301316 3
- 301675 3
- 302366 3
- 16 2
- 32 2
- 39 2
- 87 2
- 112 2
- 224 2
- 17149 2
- 18812 2
- 20062 2
- 21170 2
- 22182 2
- 22854 2
- 23648 2
- 24191 2
- 25263 2
- 26184 2
- 27529 2
- 29836 2
- 32864 2
- 35738 2
- 36629 2
- 41095 2
- 47472 2
- 54002 2
- 95087 2
- 95963 2
- 101057 2
- 102070 2
- 102958 2
- 104175 2
- 107185 2
- 108084 2
- 121019 2
- 164960 2
- 165395 2
- 303450 2
- 304009 2
- 306300 2
- 309119 2
- 311587 2
- 313543 2
- 28 1
- 44 1
- 314 1
- 340 1
- 389 1
- 411 1
- 441 1
- 461 1
- 524 1
- 579 1
- 612 1
- 652 1
- 699 1
- 707 1
- 739 1
- 816 1
- 853 1
- 879 1
- 896 1
- 914 1
- 925 1
- 940 1
- 954 1
- 971 1
- 987 1
- 1019 1
- 1025 1
- 1037 1
- 1045 1
- 1053 1
- 1068 1
- 1077 1
- 1090 1
- 1106 1
- 1116 1
- 1126 1
- 1159 1
- 1164 1
- 1166 1
- 1172 1
- 1180 1
- 1182 1
- 1193 1
- 1210 1
- 1221 1
- 1236 1
- 1244 1
- 1249 1
- 1254 1
- 1265 1
- 1271 1
- 1288 1
- 1292 1
- 1301 1
- 1309 1
- 1318 1
- 1348 1
- 1372 1
- 1399 1
- 1414 1
- 1428 1
- 1438 1
- 1462 1
- 1489 1
- 1518 1
- 1536 1
- 1568 1
- 1587 1
- 1623 1
- 1641 1
- 1669 1
- 1703 1
- 1715 1
- 1752 1
- 1793 1
- 1824 1
- 1891 1
- 1939 1
- 1975 1
- 2068 1
- 2159 1
- 2242 1
- 2373 1
- 2439 1
- 2511 1
- 2665 1
- 2686 1
- 2775 1
- 3003 1
- 3222 1
- 3396 1
- 3558 1
- 3670 1
- 4003 1
- 4235 1
- 4394 1
- 4565 1
- 4775 1
- 4931 1
- 5151 1
- 5338 1
- 5488 1
- 5713 1
- 5937 1
- 6173 1
- 6394 1
- 6510 1
- 6692 1
- 6934 1
- 7325 1
- 7685 1
- 7970 1
- 8246 1
- 8553 1
- 8635 1
- 8902 1
- 9017 1
- 9417 1
- 9513 1
- 9663 1
- 9819 1
- 10015 1
- 10066 1
- 10121 1
- 10173 1
- 10243 1
- 10543 1
- 10794 1
- 10797 1
- 11143 1
- 12039 1
- 12273 1
- 12477 1
- 13215 1
- 13614 1
- 13644 1
- 14017 1
- 14325 1
- 14601 1
- 14759 1
- 14983 1
- 15245 1
- 15246 1
- 15515 1
- 16330 1
- 16622 1
- 16741 1
- 16908 1
- 17587 1
- 18051 1
- 18285 1
- 18412 1
- 18606 1
- 18954 1
- 19345 1
- 19459 1
- 19523 1
- 19668 1
- 20183 1
- 20434 1
- 20544 1
- 20659 1
- 20960 1
- 21296 1
- 21627 1
- 21799 1
- 21871 1
- 22025 1
- 22268 1
- 22437 1
- 22589 1
- 22653 1
- 22754 1
- 23075 1
- 23244 1
- 23362 1
- 23419 1
- 23522 1
- 23688 1
- 23849 1
- 23968 1
- 24059 1
- 24101 1
- 24303 1
- 24581 1
- 24810 1
- 24956 1
- 25093 1
- 25371 1
- 25600 1
- 25749 1
- 25881 1
- 26017 1
- 26315 1
- 26715 1
- 26883 1
- 27042 1
- 27277 1
- 27772 1
- 28236 1
- 28720 1
- 29013 1
- 29509 1
- 30297 1
- 30998 1
- 31386 1
- 31851 1
- 32410 1
- 33132 1
- 34185 1
- 35142 1
- 36904 1
- 37883 1
- 38998 1
- 39366 1
- 40304 1
- 41877 1
- 43425 1
- 44687 1
- 45335 1
- 46478 1
- 48318 1
- 50222 1
- 51051 1
- 52181 1
- 53184 1
- 55168 1
- 57081 1
- 58000 1
- 58868 1
- 59769 1
- 60595 1
- 61629 1
- 62434 1
- 63415 1
- 64321 1
- 65077 1
- 65540 1
- 65816 1
- 66955 1
- 67809 1
- 69110 1
- 70163 1
- 70676 1
- 71571 1
- 72341 1
- 73244 1
- 74481 1
- 75393 1
- 76008 1
- 77200 1
- 78267 1
- 79121 1
- 79136 1
- 80153 1
- 80278 1
- 80677 1
- 81182 1
- 81686 1
- 82302 1
- 82860 1
- 83407 1
- 84109 1
- 84652 1
- 85061 1
- 85427 1
- 85697 1
- 86319 1
- 86387 1
- 86559 1
- 86855 1
- 87106 1
- 87414 1
- 87703 1
- 87991 1
- 88531 1
- 88918 1
- 89266 1
- 89377 1
- 89652 1
- 89987 1
- 90251 1
- 90400 1
- 90855 1
- 91090 1
- 91245 1
- 91392 1
- 91796 1
- 91814 1
- 92056 1
- 92427 1
- 92620 1
- 92771 1
- 92943 1
- 93159 1
- 93179 1
- 93280 1
- 93527 1
- 93677 1
- 93789 1
- 93946 1
- 94128 1
- 94181 1
- 94331 1
- 94560 1
- 94698 1
- 94769 1
- 94906 1
- 95191 1
- 95440 1
- 95555 1
- 95666 1
- 95836 1
- 96125 1
- 96376 1
- 96504 1
- 96615 1
- 96781 1
- 96989 1
- 97039 1
- 97246 1
- 97480 1
- 97616 1
- 97717 1
- 97882 1
- 98487 1
- 98647 1
- 98659 1
- 98847 1
- 99041 1
- 99156 1
- 99267 1
- 99667 1
- 99721 1
- 100047 1
- 100364 1
- 100586 1
- 100725 1
- 100856 1
- 101171 1
- 101510 1
- 101664 1
- 101786 1
- 101905 1
- 102178 1
- 102485 1
- 102613 1
- 102682 1
- 102792 1
- 103042 1
- 103385 1
- 103497 1
- 103594 1
- 104057 1
- 104207 1
- 104490 1
- 104609 1
- 104719 1
- 104839 1
- 105163 1
- 105233 1
- 105373 1
- 105539 1
- 105844 1
- 105962 1
- 106042 1
- 106152 1
- 106472 1
- 106569 1
- 106634 1
- 106960 1
- 107029 1
- 107102 1
- 107116 1
- 107198 1
- 107394 1
- 107440 1
- 107493 1
- 107559 1
- 107820 1
- 107871 1
- 107912 1
- 108012 1
- 108178 1
- 108410 1
- 108504 1
- 108570 1
- 108687 1
- 109267 1
- 109392 1
- 110943 1
- 111685 1
- 111838 1
- 111979 1
- 112182 1
- 113244 1
- 113459 1
- 113785 1
- 114235 1
- 115803 1
- 116178 1
- 116605 1
- 117054 1
- 119312 1
- 119572 1
- 119980 1
- 120311 1
- 122065 1
- 122538 1
- 123241 1
- 123588 1
- 124032 1
- 124651 1
- 125297 1
- 125867 1
- 126353 1
- 126983 1
- 127580 1
- 128405 1
- 129526 1
- 130032 1
- 130557 1
- 131037 1
- 131775 1
- 132348 1
- 133044 1
- 133975 1
- 134919 1
- 135983 1
- 136979 1
- 137569 1
- 140877 1
- 141679 1
- 142454 1
- 143162 1
- 143915 1
- 144456 1
- 144910 1
- 145544 1
- 145849 1
- 146129 1
- 146645 1
- 146958 1
- 147431 1
- 147938 1
- 148452 1
- 148905 1
- 149457 1
- 149688 1
- 149865 1
- 150306 1
- 150719 1
- 151081 1
- 151463 1
- 152675 1
- 153026 1
- 153240 1
- 153768 1
- 154746 1
- 154969 1
- 155193 1
- 155371 1
- 156612 1
- 156888 1
- 157142 1
- 157497 1
- 158436 1
- 158784 1
- 158926 1
- 159332 1
- 159636 1
- 161026 1
- 161153 1
- 161526 1
- 162363 1
- 162589 1
- 162808 1
- 163189 1
- 164427 1
- 164613 1
- 164734 1
- 165759 1
- 165935 1
- 166100 1
- 166340 1
- 167158 1
- 167293 1
- 168241 1
- 168353 1
- 168491 1
- 168810 1
- 169915 1
- 170120 1
- 170342 1
- 170584 1
- 171597 1
- 171745 1
- 171911 1
- 172207 1
- 173347 1
- 173567 1
- 173836 1
- 174203 1
- 176366 1
- 176798 1
- 178171 1
- 179927 1
- 186018 1
- 187297 1
- 188717 1
- 202673 1
- 205252 1
- 208287 1
- 216000 1
- 230123 1
- 232447 1
- 235049 1
- 243606 1
- 257160 1
- 259093 1
- 262039 1
- 268214 1
- 277513 1
- 278392 1
- 279302 1
- 283923 1
- 287198 1
- 288679 1
- 290324 1
- 292105 1
- 294428 1
- 295028 1
- 295431 1
- 295487 1
- 297659 1
- 297860 1
- 298604 1
- 299474 1
- 299585 1
- 299636 1
- 299984 1
- 300628 1
- 300772 1
- 300969 1
- 301170 1
- 301479 1
- 301512 1
- 301513 1
- 301529 1
- 302137 1
- 302154 1
- 302194 1
- 302235 1
- 302691 1
- 302726 1
- 302877 1
- 302964 1
- 303451 1
- 304840 1
- 306301 1
- 309120 1
- 311588 1
- 313544 1
- 314407 1
state 1
- California 813
fips 1
- 6067 813
county 1
- Sacramento · 813 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
244 | 244 | 2020-02-21 | Sacramento | California | 6067 | 1 | 0 |
258 | 258 | 2020-02-22 | Sacramento | California | 6067 | 1 | 0 |
272 | 272 | 2020-02-23 | Sacramento | California | 6067 | 1 | 0 |
286 | 286 | 2020-02-24 | Sacramento | California | 6067 | 1 | 0 |
302 | 302 | 2020-02-25 | Sacramento | California | 6067 | 1 | 0 |
321 | 321 | 2020-02-26 | Sacramento | California | 6067 | 3 | 0 |
341 | 341 | 2020-02-27 | Sacramento | California | 6067 | 3 | 0 |
361 | 361 | 2020-02-28 | Sacramento | California | 6067 | 3 | 0 |
383 | 383 | 2020-02-29 | Sacramento | California | 6067 | 3 | 0 |
406 | 406 | 2020-03-01 | Sacramento | California | 6067 | 3 | 0 |
434 | 434 | 2020-03-02 | Sacramento | California | 6067 | 3 | 0 |
468 | 468 | 2020-03-03 | Sacramento | California | 6067 | 3 | 0 |
503 | 503 | 2020-03-04 | Sacramento | California | 6067 | 3 | 0 |
542 | 542 | 2020-03-05 | Sacramento | California | 6067 | 3 | 0 |
592 | 592 | 2020-03-06 | Sacramento | California | 6067 | 3 | 0 |
669 | 669 | 2020-03-07 | Sacramento | California | 6067 | 3 | 0 |
764 | 764 | 2020-03-08 | Sacramento | California | 6067 | 3 | 0 |
878 | 878 | 2020-03-09 | Sacramento | California | 6067 | 9 | 0 |
1010 | 1010 | 2020-03-10 | Sacramento | California | 6067 | 9 | 1 |
1176 | 1176 | 2020-03-11 | Sacramento | California | 6067 | 9 | 1 |
1382 | 1382 | 2020-03-12 | Sacramento | California | 6067 | 16 | 1 |
1642 | 1642 | 2020-03-13 | Sacramento | California | 6067 | 16 | 1 |
1959 | 1959 | 2020-03-14 | Sacramento | California | 6067 | 28 | 1 |
2338 | 2338 | 2020-03-15 | Sacramento | California | 6067 | 32 | 1 |
2773 | 2773 | 2020-03-16 | Sacramento | California | 6067 | 32 | 2 |
3255 | 3255 | 2020-03-17 | Sacramento | California | 6067 | 39 | 2 |
3809 | 3809 | 2020-03-18 | Sacramento | California | 6067 | 39 | 2 |
4469 | 4469 | 2020-03-19 | Sacramento | California | 6067 | 44 | 3 |
5244 | 5244 | 2020-03-20 | Sacramento | California | 6067 | 52 | 3 |
6165 | 6165 | 2020-03-21 | Sacramento | California | 6067 | 52 | 3 |
7199 | 7199 | 2020-03-22 | Sacramento | California | 6067 | 52 | 3 |
8342 | 8342 | 2020-03-23 | Sacramento | California | 6067 | 87 | 4 |
9585 | 9585 | 2020-03-24 | Sacramento | California | 6067 | 87 | 4 |
10957 | 10957 | 2020-03-25 | Sacramento | California | 6067 | 112 | 5 |
12502 | 12502 | 2020-03-26 | Sacramento | California | 6067 | 112 | 5 |
14168 | 14168 | 2020-03-27 | Sacramento | California | 6067 | 164 | 6 |
15950 | 15950 | 2020-03-28 | Sacramento | California | 6067 | 164 | 6 |
17839 | 17839 | 2020-03-29 | Sacramento | California | 6067 | 164 | 6 |
19816 | 19816 | 2020-03-30 | Sacramento | California | 6067 | 224 | 7 |
21891 | 21891 | 2020-03-31 | Sacramento | California | 6067 | 224 | 7 |
24049 | 24049 | 2020-04-01 | Sacramento | California | 6067 | 314 | 9 |
26278 | 26278 | 2020-04-02 | Sacramento | California | 6067 | 340 | 9 |
28577 | 28577 | 2020-04-03 | Sacramento | California | 6067 | 389 | 10 |
30935 | 30935 | 2020-04-04 | Sacramento | California | 6067 | 411 | 12 |
33341 | 33341 | 2020-04-05 | Sacramento | California | 6067 | 441 | 16 |
35786 | 35786 | 2020-04-06 | Sacramento | California | 6067 | 461 | 18 |
38275 | 38275 | 2020-04-07 | Sacramento | California | 6067 | 524 | 21 |
40819 | 40819 | 2020-04-08 | Sacramento | California | 6067 | 579 | 22 |
43391 | 43391 | 2020-04-09 | Sacramento | California | 6067 | 612 | 22 |
45991 | 45991 | 2020-04-10 | Sacramento | California | 6067 | 652 | 24 |
48621 | 48621 | 2020-04-11 | Sacramento | California | 6067 | 699 | 26 |
51283 | 51283 | 2020-04-12 | Sacramento | California | 6067 | 707 | 26 |
53962 | 53962 | 2020-04-13 | Sacramento | California | 6067 | 739 | 27 |
56654 | 56654 | 2020-04-14 | Sacramento | California | 6067 | 816 | 28 |
59362 | 59362 | 2020-04-15 | Sacramento | California | 6067 | 853 | 32 |
62081 | 62081 | 2020-04-16 | Sacramento | California | 6067 | 879 | 32 |
64814 | 64814 | 2020-04-17 | Sacramento | California | 6067 | 896 | 32 |
67562 | 67562 | 2020-04-18 | Sacramento | California | 6067 | 914 | 33 |
70324 | 70324 | 2020-04-19 | Sacramento | California | 6067 | 925 | 34 |
73093 | 73093 | 2020-04-20 | Sacramento | California | 6067 | 940 | 34 |
75869 | 75869 | 2020-04-21 | Sacramento | California | 6067 | 954 | 35 |
78653 | 78653 | 2020-04-22 | Sacramento | California | 6067 | 971 | 36 |
81447 | 81447 | 2020-04-23 | Sacramento | California | 6067 | 987 | 41 |
84247 | 84247 | 2020-04-24 | Sacramento | California | 6067 | 1019 | 41 |
87055 | 87055 | 2020-04-25 | Sacramento | California | 6067 | 1025 | 41 |
89872 | 89872 | 2020-04-26 | Sacramento | California | 6067 | 1037 | 41 |
92690 | 92690 | 2020-04-27 | Sacramento | California | 6067 | 1045 | 41 |
95522 | 95522 | 2020-04-28 | Sacramento | California | 6067 | 1053 | 41 |
98367 | 98367 | 2020-04-29 | Sacramento | California | 6067 | 1068 | 42 |
101217 | 101217 | 2020-04-30 | Sacramento | California | 6067 | 1077 | 43 |
104072 | 104072 | 2020-05-01 | Sacramento | California | 6067 | 1090 | 43 |
106937 | 106937 | 2020-05-02 | Sacramento | California | 6067 | 1106 | 43 |
109806 | 109806 | 2020-05-03 | Sacramento | California | 6067 | 1116 | 43 |
112681 | 112681 | 2020-05-04 | Sacramento | California | 6067 | 1126 | 47 |
115564 | 115564 | 2020-05-05 | Sacramento | California | 6067 | 1132 | 47 |
118523 | 118523 | 2020-05-06 | Sacramento | California | 6067 | 1132 | 47 |
121490 | 121490 | 2020-05-07 | Sacramento | California | 6067 | 1132 | 49 |
124470 | 124470 | 2020-05-08 | Sacramento | California | 6067 | 1159 | 50 |
127455 | 127455 | 2020-05-09 | Sacramento | California | 6067 | 1164 | 51 |
130445 | 130445 | 2020-05-10 | Sacramento | California | 6067 | 1166 | 52 |
133435 | 133435 | 2020-05-11 | Sacramento | California | 6067 | 1172 | 52 |
136425 | 136425 | 2020-05-12 | Sacramento | California | 6067 | 1180 | 52 |
139416 | 139416 | 2020-05-13 | Sacramento | California | 6067 | 1182 | 52 |
142412 | 142412 | 2020-05-14 | Sacramento | California | 6067 | 1193 | 54 |
145411 | 145411 | 2020-05-15 | Sacramento | California | 6067 | 1210 | 54 |
148415 | 148415 | 2020-05-16 | Sacramento | California | 6067 | 1221 | 55 |
151424 | 151424 | 2020-05-17 | Sacramento | California | 6067 | 1236 | 55 |
154436 | 154436 | 2020-05-18 | Sacramento | California | 6067 | 1244 | 56 |
157452 | 157452 | 2020-05-19 | Sacramento | California | 6067 | 1249 | 56 |
160478 | 160478 | 2020-05-20 | Sacramento | California | 6067 | 1254 | 57 |
163506 | 163506 | 2020-05-21 | Sacramento | California | 6067 | 1265 | 57 |
166538 | 166538 | 2020-05-22 | Sacramento | California | 6067 | 1271 | 57 |
169575 | 169575 | 2020-05-23 | Sacramento | California | 6067 | 1288 | 57 |
172616 | 172616 | 2020-05-24 | Sacramento | California | 6067 | 1292 | 57 |
175660 | 175660 | 2020-05-25 | Sacramento | California | 6067 | 1301 | 57 |
178704 | 178704 | 2020-05-26 | Sacramento | California | 6067 | 1309 | 57 |
181748 | 181748 | 2020-05-27 | Sacramento | California | 6067 | 1318 | 57 |
184802 | 184802 | 2020-05-28 | Sacramento | California | 6067 | 1348 | 57 |
187858 | 187858 | 2020-05-29 | Sacramento | California | 6067 | 1372 | 57 |
190923 | 190923 | 2020-05-30 | Sacramento | California | 6067 | 1399 | 57 |
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);