ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
832 rows where county = "San Francisco" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 693 ✖
- 2 22
- 3 10
- 134372 6
- 56617 5
- 37110 4
- 54443 4
- 61317 4
- 67926 4
- 129781 4
- 133484 4
- 135447 4
- 136855 4
- 138912 4
- 141495 4
- 38771 3
- 39411 3
- 40466 3
- 42015 3
- 52331 3
- 52922 3
- 53519 3
- 54034 3
- 54815 3
- 55266 3
- 56312 3
- 57144 3
- 57773 3
- 58498 3
- 78152 3
- 94875 3
- 109862 3
- 119537 3
- 124593 3
- 127853 3
- 131716 3
- 131905 3
- 132123 3
- 132138 3
- 132616 3
- 133945 3
- 136065 3
- 137816 3
- 140270 3
- 142863 3
- 5 2
- 11 2
- 17 2
- 3061 2
- 3722 2
- 7626 2
- 9982 2
- 44062 2
- 55827 2
- 55959 2
- 16 1
- 21 1
- 26 1
- 31 1
- 37 1
- 43 1
- 46 1
- 51 1
- 73 1
- 79 1
- 84 1
- 111 1
- 134 1
- 152 1
- 181 1
- 226 1
- 282 1
- 308 1
- 343 1
- 374 1
- 400 1
- 437 1
- 450 1
- 500 1
- 529 1
- 571 1
- 586 1
- 622 1
- 679 1
- 727 1
- 800 1
- 860 1
- 875 1
- 960 1
- 990 1
- 1016 1
- 1022 1
- 1061 1
- 1140 1
- 1160 1
- 1219 1
- 1234 1
- 1236 1
- 1305 1
- 1343 1
- 1357 1
- 1411 1
- 1427 1
- 1471 1
- 1490 1
- 1502 1
- 1526 1
- 1552 1
- 1632 1
- 1692 1
- 1760 1
- 1779 1
- 1806 1
- 1856 1
- 1894 1
- 1946 1
- 1957 1
- 1980 1
- 1997 1
- 2007 1
- 2032 1
- 2065 1
- 2097 1
- 2135 1
- 2186 1
- 2189 1
- 2202 1
- 2323 1
- 2353 1
- 2370 1
- 2389 1
- 2402 1
- 2411 1
- 2440 1
- 2476 1
- 2535 1
- 2561 1
- 2573 1
- 2590 1
- 2616 1
- 2647 1
- 2701 1
- 2715 1
- 2750 1
- 2782 1
- 2796 1
- 2812 1
- 2843 1
- 2880 1
- 2909 1
- 2931 1
- 2955 1
- 2974 1
- 2985 1
- 3023 1
- 3060 1
- 3188 1
- 3222 1
- 3252 1
- 3300 1
- 3403 1
- 3471 1
- 3515 1
- 3564 1
- 3606 1
- 3651 1
- 3784 1
- 3864 1
- 3995 1
- 4023 1
- 4074 1
- 4148 1
- 4319 1
- 4429 1
- 4525 1
- 4593 1
- 4643 1
- 4699 1
- 4863 1
- 4978 1
- 5119 1
- 5205 1
- 5308 1
- 5366 1
- 5462 1
- 5567 1
- 5682 1
- 5790 1
- 5935 1
- 6025 1
- 6068 1
- 6200 1
- 6426 1
- 6578 1
- 6726 1
- 6814 1
- 6919 1
- 6992 1
- 7084 1
- 7231 1
- 7329 1
- 7435 1
- 7551 1
- 7837 1
- 7947 1
- 8056 1
- 8160 1
- 8295 1
- 8349 1
- 8430 1
- 8531 1
- 8614 1
- 8705 1
- 8794 1
- 8874 1
- 8939 1
- 8984 1
- 9063 1
- 9152 1
- 9218 1
- 9352 1
- 9431 1
- 9497 1
- 9547 1
- 9620 1
- 9699 1
- 9758 1
- 9842 1
- 9918 1
- 10077 1
- 10123 1
- 10191 1
- 10266 1
- 10305 1
- 10381 1
- 10433 1
- 10493 1
- 10572 1
- 10643 1
- 10699 1
- 10748 1
- 10810 1
- 10868 1
- 10904 1
- 10949 1
- 11041 1
- 11079 1
- 11146 1
- 11198 1
- 11241 1
- 11278 1
- 11335 1
- 11363 1
- 11417 1
- 11478 1
- 11483 1
- 11508 1
- 11536 1
- 11554 1
- 11611 1
- 11623 1
- 11666 1
- 11669 1
- 11694 1
- 11715 1
- 11786 1
- 11811 1
- 11843 1
- 11880 1
- 11904 1
- 11940 1
- 12003 1
- 12016 1
- 12035 1
- 12072 1
- 12106 1
- 12155 1
- 12192 1
- 12244 1
- 12280 1
- 12323 1
- 12402 1
- 12457 1
- 12511 1
- 12557 1
- 12602 1
- 12669 1
- 12756 1
- 12863 1
- 12983 1
- 13084 1
- 13142 1
- 13213 1
- 13311 1
- 13407 1
- 13519 1
- 13668 1
- 13760 1
- 13850 1
- 13955 1
- 14060 1
- 14254 1
- 14330 1
- 14448 1
- 14545 1
- 14665 1
- 14877 1
- 15056 1
- 15159 1
- 15380 1
- 15453 1
- 15574 1
- 15642 1
- 15800 1
- 16061 1
- 16239 1
- 16502 1
- 16789 1
- 17110 1
- 17223 1
- 17387 1
- 17631 1
- 17948 1
- 18249 1
- 18416 1
- 18689 1
- 18907 1
- 19286 1
- 19627 1
- 19942 1
- 20318 1
- 20646 1
- 20940 1
- 21089 1
- 21235 1
- 21501 1
- 21833 1
- 22133 1
- 22322 1
- 22517 1
- 22729 1
- 22999 1
- 23227 1
- 23743 1
- 24148 1
- 24417 1
- 24591 1
- 24756 1
- 24992 1
- 25427 1
- 25888 1
- 26381 1
- 26711 1
- 27057 1
- 27267 1
- 27534 1
- 27866 1
- 28203 1
- 28577 1
- 28856 1
- 29142 1
- 29324 1
- 29505 1
- 29668 1
- 29804 1
- 30030 1
- 30311 1
- 30562 1
- 30737 1
- 30877 1
- 31085 1
- 31196 1
- 31297 1
- 31430 1
- 31566 1
- 31706 1
- 31791 1
- 31986 1
- 32119 1
- 32232 1
- 32440 1
- 32612 1
- 32682 1
- 32785 1
- 32958 1
- 33079 1
- 33182 1
- 33294 1
- 33377 1
- 33457 1
- 33494 1
- 33561 1
- 33653 1
- 33749 1
- 33823 1
- 33894 1
- 33950 1
- 33997 1
- 34064 1
- 34141 1
- 34216 1
- 34263 1
- 34294 1
- 34321 1
- 34390 1
- 34446 1
- 34483 1
- 34529 1
- 34563 1
- 34597 1
- 34637 1
- 34657 1
- 34691 1
- 34725 1
- 34761 1
- 34787 1
- 34813 1
- 34823 1
- 34836 1
- 34876 1
- 34907 1
- 34939 1
- 34971 1
- 35015 1
- 35043 1
- 35074 1
- 35106 1
- 35157 1
- 35189 1
- 35247 1
- 35289 1
- 35294 1
- 35328 1
- 35350 1
- 35389 1
- 35454 1
- 35491 1
- 35528 1
- 35541 1
- 35575 1
- 35621 1
- 35660 1
- 35719 1
- 35777 1
- 35818 1
- 35844 1
- 35872 1
- 35901 1
- 35950 1
- 35996 1
- 36035 1
- 36076 1
- 36097 1
- 36120 1
- 36197 1
- 36221 1
- 36255 1
- 36288 1
- 36313 1
- 36333 1
- 36361 1
- 36385 1
- 36415 1
- 36456 1
- 36499 1
- 36525 1
- 36541 1
- 36553 1
- 36580 1
- 36602 1
- 36619 1
- 36645 1
- 36672 1
- 36686 1
- 36710 1
- 36723 1
- 36744 1
- 36774 1
- 36798 1
- 36811 1
- 36819 1
- 36821 1
- 36838 1
- 36863 1
- 36882 1
- 36909 1
- 36930 1
- 36937 1
- 36942 1
- 36957 1
- 36983 1
- 36990 1
- 37011 1
- 37019 1
- 37025 1
- 37034 1
- 37044 1
- 37053 1
- 37068 1
- 37075 1
- 37082 1
- 37114 1
- 37121 1
- 37125 1
- 37137 1
- 37146 1
- 37162 1
- 37180 1
- 37192 1
- 37200 1
- 37209 1
- 37213 1
- 37225 1
- 37240 1
- 37246 1
- 37249 1
- 37254 1
- 37259 1
- 37272 1
- 37278 1
- 37290 1
- 37307 1
- 37323 1
- 37341 1
- 37351 1
- 37363 1
- 37375 1
- 38717 1
- 39029 1
- 39089 1
- 39158 1
- 39269 1
- 39800 1
- 39896 1
- 39969 1
- 40211 1
- 41175 1
- 41312 1
- 41451 1
- 41747 1
- 43035 1
- 43156 1
- 43361 1
- 43674 1
- 44687 1
- 44859 1
- 45022 1
- 45150 1
- 45316 1
- 45535 1
- 45957 1
- 46114 1
- 46292 1
- 46442 1
- 46581 1
- 47067 1
- 47330 1
- 47542 1
- 47747 1
- 47941 1
- 48055 1
- 48120 1
- 48303 1
- 48484 1
- 48652 1
- 48850 1
- 49081 1
- 49162 1
- 49636 1
- 49806 1
- 49942 1
- 50090 1
- 50205 1
- 50303 1
- 50388 1
- 50443 1
- 50645 1
- 50786 1
- 50900 1
- 51042 1
- 51201 1
- 51296 1
- 51380 1
- 51451 1
- 51585 1
- 51701 1
- 51811 1
- 51910 1
- 52011 1
- 52105 1
- 52225 1
- 52583 1
- 52648 1
- 52725 1
- 52815 1
- 53262 1
- 53327 1
- 53355 1
- 53453 1
- 53775 1
- 53834 1
- 53860 1
- 53977 1
- 54223 1
- 54269 1
- 54302 1
- 54378 1
- 54664 1
- 54686 1
- 54762 1
- 55024 1
- 55072 1
- 55104 1
- 55203 1
- 55578 1
- 55652 1
- 55706 1
- 56102 1
- 56138 1
- 56179 1
- 56256 1
- 56528 1
- 56565 1
- 56869 1
- 56912 1
- 56934 1
- 57057 1
- 57461 1
- 57517 1
- 57587 1
- 57696 1
- 58084 1
- 58149 1
- 58182 1
- 58350 1
- 59294 1
- 59597 1
- 59886 1
- 60608 1
- 64008 1
- 64833 1
- 66545 1
- 72743 1
- 74094 1
- 75897 1
- 84955 1
- 86701 1
- 88170 1
- 92571 1
- 101010 1
- 102163 1
- 103376 1
- 108276 1
- 114109 1
- 115042 1
- 115878 1
- 118446 1
- 122044 1
- 122391 1
- 122878 1
- 124120 1
- 125227 1
- 126057 1
- 127290 1
- 129035 1
- 129321 1
- 129499 1
- 129571 1
- 130054 1
- 130449 1
- 130538 1
- 130764 1
- 131764 1
- 131964 1
- 132028 1
- 132039 1
- 132054 1
- 132103 1
- 132118 1
- 132150 1
- 132176 1
- 132204 1
- 132230 1
- 132241 1
- 132261 1
- 132316 1
- 132328 1
- 132461 1
- 132970 1
- 133029 1
- 133140 1
- 133339 1
- 135079 1
- 143959 1
state 1
- California 832
fips 1
- 6075 832
county 1
- San Francisco · 832 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499799 | 2499799 | 2022-05-13 | San Francisco | California | 6075 | 143959 | 866 |
2496541 | 2496541 | 2022-05-12 | San Francisco | California | 6075 | 142863 | 864 |
2493283 | 2493283 | 2022-05-11 | San Francisco | California | 6075 | 142863 | 864 |
2490025 | 2490025 | 2022-05-10 | San Francisco | California | 6075 | 142863 | 864 |
2486768 | 2486768 | 2022-05-09 | San Francisco | California | 6075 | 141495 | 861 |
2483510 | 2483510 | 2022-05-08 | San Francisco | California | 6075 | 141495 | 861 |
2480252 | 2480252 | 2022-05-07 | San Francisco | California | 6075 | 141495 | 861 |
2476994 | 2476994 | 2022-05-06 | San Francisco | California | 6075 | 141495 | 861 |
2473736 | 2473736 | 2022-05-05 | San Francisco | California | 6075 | 140270 | 860 |
2470479 | 2470479 | 2022-05-04 | San Francisco | California | 6075 | 140270 | 860 |
2467223 | 2467223 | 2022-05-03 | San Francisco | California | 6075 | 140270 | 860 |
2463968 | 2463968 | 2022-05-02 | San Francisco | California | 6075 | 138912 | 860 |
2460712 | 2460712 | 2022-05-01 | San Francisco | California | 6075 | 138912 | 860 |
2457456 | 2457456 | 2022-04-30 | San Francisco | California | 6075 | 138912 | 860 |
2454200 | 2454200 | 2022-04-29 | San Francisco | California | 6075 | 138912 | 860 |
2450944 | 2450944 | 2022-04-28 | San Francisco | California | 6075 | 137816 | 857 |
2447688 | 2447688 | 2022-04-27 | San Francisco | California | 6075 | 137816 | 857 |
2444432 | 2444432 | 2022-04-26 | San Francisco | California | 6075 | 137816 | 857 |
2441176 | 2441176 | 2022-04-25 | San Francisco | California | 6075 | 136855 | 857 |
2437920 | 2437920 | 2022-04-24 | San Francisco | California | 6075 | 136855 | 857 |
2434664 | 2434664 | 2022-04-23 | San Francisco | California | 6075 | 136855 | 857 |
2431408 | 2431408 | 2022-04-22 | San Francisco | California | 6075 | 136855 | 857 |
2428152 | 2428152 | 2022-04-21 | San Francisco | California | 6075 | 136065 | 854 |
2424896 | 2424896 | 2022-04-20 | San Francisco | California | 6075 | 136065 | 854 |
2421640 | 2421640 | 2022-04-19 | San Francisco | California | 6075 | 136065 | 854 |
2418384 | 2418384 | 2022-04-18 | San Francisco | California | 6075 | 135447 | 854 |
2415128 | 2415128 | 2022-04-17 | San Francisco | California | 6075 | 135447 | 854 |
2411872 | 2411872 | 2022-04-16 | San Francisco | California | 6075 | 135447 | 854 |
2408616 | 2408616 | 2022-04-15 | San Francisco | California | 6075 | 135447 | 854 |
2405360 | 2405360 | 2022-04-14 | San Francisco | California | 6075 | 135079 | 850 |
2402105 | 2402105 | 2022-04-13 | San Francisco | California | 6075 | 134372 | 844 |
2398850 | 2398850 | 2022-04-12 | San Francisco | California | 6075 | 134372 | 844 |
2395595 | 2395595 | 2022-04-11 | San Francisco | California | 6075 | 134372 | 844 |
2392339 | 2392339 | 2022-04-10 | San Francisco | California | 6075 | 134372 | 844 |
2389083 | 2389083 | 2022-04-09 | San Francisco | California | 6075 | 134372 | 844 |
2385828 | 2385828 | 2022-04-08 | San Francisco | California | 6075 | 134372 | 844 |
2382573 | 2382573 | 2022-04-07 | San Francisco | California | 6075 | 133945 | 843 |
2379318 | 2379318 | 2022-04-06 | San Francisco | California | 6075 | 133945 | 843 |
2376064 | 2376064 | 2022-04-05 | San Francisco | California | 6075 | 133945 | 843 |
2372812 | 2372812 | 2022-04-04 | San Francisco | California | 6075 | 133484 | 843 |
2369559 | 2369559 | 2022-04-03 | San Francisco | California | 6075 | 133484 | 843 |
2366306 | 2366306 | 2022-04-02 | San Francisco | California | 6075 | 133484 | 843 |
2363053 | 2363053 | 2022-04-01 | San Francisco | California | 6075 | 133484 | 843 |
2359799 | 2359799 | 2022-03-31 | San Francisco | California | 6075 | 133339 | 841 |
2356545 | 2356545 | 2022-03-30 | San Francisco | California | 6075 | 133140 | 840 |
2353292 | 2353292 | 2022-03-29 | San Francisco | California | 6075 | 133029 | 839 |
2350040 | 2350040 | 2022-03-28 | San Francisco | California | 6075 | 132970 | 839 |
2346787 | 2346787 | 2022-03-27 | San Francisco | California | 6075 | 132616 | 839 |
2343534 | 2343534 | 2022-03-26 | San Francisco | California | 6075 | 132616 | 839 |
2340281 | 2340281 | 2022-03-25 | San Francisco | California | 6075 | 132616 | 839 |
2337028 | 2337028 | 2022-03-24 | San Francisco | California | 6075 | 132461 | 838 |
2333774 | 2333774 | 2022-03-23 | San Francisco | California | 6075 | 132316 | 838 |
2330520 | 2330520 | 2022-03-22 | San Francisco | California | 6075 | 132230 | 835 |
2327268 | 2327268 | 2022-03-21 | San Francisco | California | 6075 | 132176 | 835 |
2324015 | 2324015 | 2022-03-20 | San Francisco | California | 6075 | 131905 | 833 |
2320761 | 2320761 | 2022-03-19 | San Francisco | California | 6075 | 131905 | 833 |
2317507 | 2317507 | 2022-03-18 | San Francisco | California | 6075 | 131905 | 833 |
2314254 | 2314254 | 2022-03-17 | San Francisco | California | 6075 | 131764 | 831 |
2311001 | 2311001 | 2022-03-16 | San Francisco | California | 6075 | 132054 | 831 |
2307748 | 2307748 | 2022-03-15 | San Francisco | California | 6075 | 132103 | 824 |
2304497 | 2304497 | 2022-03-14 | San Francisco | California | 6075 | 132150 | 824 |
2301245 | 2301245 | 2022-03-13 | San Francisco | California | 6075 | 132138 | 823 |
2297993 | 2297993 | 2022-03-12 | San Francisco | California | 6075 | 132138 | 823 |
2294741 | 2294741 | 2022-03-11 | San Francisco | California | 6075 | 132138 | 823 |
2291489 | 2291489 | 2022-03-10 | San Francisco | California | 6075 | 132204 | 812 |
2288237 | 2288237 | 2022-03-09 | San Francisco | California | 6075 | 132261 | 807 |
2284986 | 2284986 | 2022-03-08 | San Francisco | California | 6075 | 132241 | 807 |
2281734 | 2281734 | 2022-03-07 | San Francisco | California | 6075 | 132328 | 806 |
2278481 | 2278481 | 2022-03-06 | San Francisco | California | 6075 | 132123 | 798 |
2275228 | 2275228 | 2022-03-05 | San Francisco | California | 6075 | 132123 | 798 |
2271975 | 2271975 | 2022-03-04 | San Francisco | California | 6075 | 132123 | 798 |
2268723 | 2268723 | 2022-03-03 | San Francisco | California | 6075 | 132028 | 792 |
2265470 | 2265470 | 2022-03-02 | San Francisco | California | 6075 | 132118 | 792 |
2262219 | 2262219 | 2022-03-01 | San Francisco | California | 6075 | 132039 | 792 |
2258968 | 2258968 | 2022-02-28 | San Francisco | California | 6075 | 131964 | 791 |
2255717 | 2255717 | 2022-02-27 | San Francisco | California | 6075 | 131716 | 769 |
2252466 | 2252466 | 2022-02-26 | San Francisco | California | 6075 | 131716 | 769 |
2249215 | 2249215 | 2022-02-25 | San Francisco | California | 6075 | 131716 | 769 |
2245964 | 2245964 | 2022-02-24 | San Francisco | California | 6075 | 130764 | 769 |
2242713 | 2242713 | 2022-02-23 | San Francisco | California | 6075 | 130538 | 769 |
2239462 | 2239462 | 2022-02-22 | San Francisco | California | 6075 | 130449 | 769 |
2236211 | 2236211 | 2022-02-21 | San Francisco | California | 6075 | 129781 | 756 |
2232960 | 2232960 | 2022-02-20 | San Francisco | California | 6075 | 129781 | 756 |
2229709 | 2229709 | 2022-02-19 | San Francisco | California | 6075 | 129781 | 756 |
2226458 | 2226458 | 2022-02-18 | San Francisco | California | 6075 | 129781 | 756 |
2223207 | 2223207 | 2022-02-17 | San Francisco | California | 6075 | 129571 | 756 |
2219956 | 2219956 | 2022-02-16 | San Francisco | California | 6075 | 129499 | 756 |
2216705 | 2216705 | 2022-02-15 | San Francisco | California | 6075 | 129321 | 756 |
2213454 | 2213454 | 2022-02-14 | San Francisco | California | 6075 | 129035 | 756 |
2210202 | 2210202 | 2022-02-13 | San Francisco | California | 6075 | 127853 | 740 |
2206949 | 2206949 | 2022-02-12 | San Francisco | California | 6075 | 127853 | 740 |
2203696 | 2203696 | 2022-02-11 | San Francisco | California | 6075 | 127853 | 740 |
2200443 | 2200443 | 2022-02-10 | San Francisco | California | 6075 | 127290 | 731 |
2197189 | 2197189 | 2022-02-09 | San Francisco | California | 6075 | 130054 | 731 |
2193934 | 2193934 | 2022-02-08 | San Francisco | California | 6075 | 126057 | 727 |
2190681 | 2190681 | 2022-02-07 | San Francisco | California | 6075 | 125227 | 728 |
2187428 | 2187428 | 2022-02-06 | San Francisco | California | 6075 | 124593 | 720 |
2184175 | 2184175 | 2022-02-05 | San Francisco | California | 6075 | 124593 | 720 |
2180923 | 2180923 | 2022-02-04 | San Francisco | California | 6075 | 124593 | 720 |
2177672 | 2177672 | 2022-02-03 | San Francisco | California | 6075 | 124120 | 714 |
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);