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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
50 | 50 | 2020-02-02 | San Francisco | California | 6075 | 2 | 0 |
58 | 58 | 2020-02-03 | San Francisco | California | 6075 | 2 | 0 |
66 | 66 | 2020-02-04 | San Francisco | California | 6075 | 2 | 0 |
74 | 74 | 2020-02-05 | San Francisco | California | 6075 | 2 | 0 |
83 | 83 | 2020-02-06 | San Francisco | California | 6075 | 2 | 0 |
92 | 92 | 2020-02-07 | San Francisco | California | 6075 | 2 | 0 |
101 | 101 | 2020-02-08 | San Francisco | California | 6075 | 2 | 0 |
110 | 110 | 2020-02-09 | San Francisco | California | 6075 | 2 | 0 |
120 | 120 | 2020-02-10 | San Francisco | California | 6075 | 2 | 0 |
130 | 130 | 2020-02-11 | San Francisco | California | 6075 | 2 | 0 |
140 | 140 | 2020-02-12 | San Francisco | California | 6075 | 2 | 0 |
151 | 151 | 2020-02-13 | San Francisco | California | 6075 | 2 | 0 |
162 | 162 | 2020-02-14 | San Francisco | California | 6075 | 2 | 0 |
173 | 173 | 2020-02-15 | San Francisco | California | 6075 | 2 | 0 |
184 | 184 | 2020-02-16 | San Francisco | California | 6075 | 2 | 0 |
195 | 195 | 2020-02-17 | San Francisco | California | 6075 | 2 | 0 |
207 | 207 | 2020-02-18 | San Francisco | California | 6075 | 2 | 0 |
219 | 219 | 2020-02-19 | San Francisco | California | 6075 | 2 | 0 |
232 | 232 | 2020-02-20 | San Francisco | California | 6075 | 2 | 0 |
246 | 246 | 2020-02-21 | San Francisco | California | 6075 | 2 | 0 |
260 | 260 | 2020-02-22 | San Francisco | California | 6075 | 2 | 0 |
274 | 274 | 2020-02-23 | San Francisco | California | 6075 | 2 | 0 |
288 | 288 | 2020-02-24 | San Francisco | California | 6075 | 3 | 0 |
304 | 304 | 2020-02-25 | San Francisco | California | 6075 | 3 | 0 |
323 | 323 | 2020-02-26 | San Francisco | California | 6075 | 3 | 0 |
343 | 343 | 2020-02-27 | San Francisco | California | 6075 | 3 | 0 |
363 | 363 | 2020-02-28 | San Francisco | California | 6075 | 3 | 0 |
385 | 385 | 2020-02-29 | San Francisco | California | 6075 | 3 | 0 |
408 | 408 | 2020-03-01 | San Francisco | California | 6075 | 3 | 0 |
436 | 436 | 2020-03-02 | San Francisco | California | 6075 | 3 | 0 |
470 | 470 | 2020-03-03 | San Francisco | California | 6075 | 3 | 0 |
505 | 505 | 2020-03-04 | San Francisco | California | 6075 | 3 | 0 |
544 | 544 | 2020-03-05 | San Francisco | California | 6075 | 5 | 0 |
594 | 594 | 2020-03-06 | San Francisco | California | 6075 | 5 | 0 |
671 | 671 | 2020-03-07 | San Francisco | California | 6075 | 11 | 0 |
766 | 766 | 2020-03-08 | San Francisco | California | 6075 | 11 | 0 |
880 | 880 | 2020-03-09 | San Francisco | California | 6075 | 16 | 0 |
1012 | 1012 | 2020-03-10 | San Francisco | California | 6075 | 17 | 0 |
1178 | 1178 | 2020-03-11 | San Francisco | California | 6075 | 17 | 0 |
1384 | 1384 | 2020-03-12 | San Francisco | California | 6075 | 21 | 0 |
1645 | 1645 | 2020-03-13 | San Francisco | California | 6075 | 26 | 0 |
1962 | 1962 | 2020-03-14 | San Francisco | California | 6075 | 31 | 0 |
2342 | 2342 | 2020-03-15 | San Francisco | California | 6075 | 37 | 0 |
2777 | 2777 | 2020-03-16 | San Francisco | California | 6075 | 43 | 0 |
3259 | 3259 | 2020-03-17 | San Francisco | California | 6075 | 46 | 0 |
3813 | 3813 | 2020-03-18 | San Francisco | California | 6075 | 51 | 0 |
4473 | 4473 | 2020-03-19 | San Francisco | California | 6075 | 73 | 0 |
5248 | 5248 | 2020-03-20 | San Francisco | California | 6075 | 79 | 0 |
6169 | 6169 | 2020-03-21 | San Francisco | California | 6075 | 84 | 0 |
7203 | 7203 | 2020-03-22 | San Francisco | California | 6075 | 111 | 0 |
8346 | 8346 | 2020-03-23 | San Francisco | California | 6075 | 134 | 0 |
9589 | 9589 | 2020-03-24 | San Francisco | California | 6075 | 152 | 0 |
10961 | 10961 | 2020-03-25 | San Francisco | California | 6075 | 181 | 1 |
12506 | 12506 | 2020-03-26 | San Francisco | California | 6075 | 226 | 2 |
14172 | 14172 | 2020-03-27 | San Francisco | California | 6075 | 282 | 3 |
15954 | 15954 | 2020-03-28 | San Francisco | California | 6075 | 308 | 4 |
17843 | 17843 | 2020-03-29 | San Francisco | California | 6075 | 343 | 5 |
19820 | 19820 | 2020-03-30 | San Francisco | California | 6075 | 374 | 6 |
21895 | 21895 | 2020-03-31 | San Francisco | California | 6075 | 400 | 6 |
24053 | 24053 | 2020-04-01 | San Francisco | California | 6075 | 437 | 7 |
26282 | 26282 | 2020-04-02 | San Francisco | California | 6075 | 450 | 7 |
28581 | 28581 | 2020-04-03 | San Francisco | California | 6075 | 500 | 7 |
30939 | 30939 | 2020-04-04 | San Francisco | California | 6075 | 529 | 8 |
33345 | 33345 | 2020-04-05 | San Francisco | California | 6075 | 571 | 8 |
35790 | 35790 | 2020-04-06 | San Francisco | California | 6075 | 586 | 9 |
38279 | 38279 | 2020-04-07 | San Francisco | California | 6075 | 622 | 9 |
40823 | 40823 | 2020-04-08 | San Francisco | California | 6075 | 679 | 10 |
43395 | 43395 | 2020-04-09 | San Francisco | California | 6075 | 727 | 10 |
45995 | 45995 | 2020-04-10 | San Francisco | California | 6075 | 800 | 13 |
48625 | 48625 | 2020-04-11 | San Francisco | California | 6075 | 860 | 13 |
51287 | 51287 | 2020-04-12 | San Francisco | California | 6075 | 875 | 14 |
53966 | 53966 | 2020-04-13 | San Francisco | California | 6075 | 960 | 15 |
56658 | 56658 | 2020-04-14 | San Francisco | California | 6075 | 990 | 15 |
59366 | 59366 | 2020-04-15 | San Francisco | California | 6075 | 1016 | 17 |
62085 | 62085 | 2020-04-16 | San Francisco | California | 6075 | 1022 | 17 |
64818 | 64818 | 2020-04-17 | San Francisco | California | 6075 | 1061 | 20 |
67566 | 67566 | 2020-04-18 | San Francisco | California | 6075 | 1140 | 20 |
70328 | 70328 | 2020-04-19 | San Francisco | California | 6075 | 1160 | 20 |
73097 | 73097 | 2020-04-20 | San Francisco | California | 6075 | 1219 | 20 |
75873 | 75873 | 2020-04-21 | San Francisco | California | 6075 | 1234 | 20 |
78657 | 78657 | 2020-04-22 | San Francisco | California | 6075 | 1236 | 21 |
81451 | 81451 | 2020-04-23 | San Francisco | California | 6075 | 1305 | 21 |
84251 | 84251 | 2020-04-24 | San Francisco | California | 6075 | 1343 | 22 |
87059 | 87059 | 2020-04-25 | San Francisco | California | 6075 | 1357 | 22 |
89876 | 89876 | 2020-04-26 | San Francisco | California | 6075 | 1411 | 22 |
92694 | 92694 | 2020-04-27 | San Francisco | California | 6075 | 1427 | 23 |
95526 | 95526 | 2020-04-28 | San Francisco | California | 6075 | 1471 | 23 |
98371 | 98371 | 2020-04-29 | San Francisco | California | 6075 | 1490 | 23 |
101221 | 101221 | 2020-04-30 | San Francisco | California | 6075 | 1502 | 25 |
104076 | 104076 | 2020-05-01 | San Francisco | California | 6075 | 1526 | 28 |
106941 | 106941 | 2020-05-02 | San Francisco | California | 6075 | 1552 | 29 |
109810 | 109810 | 2020-05-03 | San Francisco | California | 6075 | 1632 | 29 |
112685 | 112685 | 2020-05-04 | San Francisco | California | 6075 | 1692 | 30 |
115568 | 115568 | 2020-05-05 | San Francisco | California | 6075 | 1760 | 31 |
118527 | 118527 | 2020-05-06 | San Francisco | California | 6075 | 1779 | 31 |
121494 | 121494 | 2020-05-07 | San Francisco | California | 6075 | 1806 | 32 |
124474 | 124474 | 2020-05-08 | San Francisco | California | 6075 | 1856 | 33 |
127459 | 127459 | 2020-05-09 | San Francisco | California | 6075 | 1894 | 33 |
130449 | 130449 | 2020-05-10 | San Francisco | California | 6075 | 1946 | 34 |
133439 | 133439 | 2020-05-11 | San Francisco | California | 6075 | 1957 | 35 |
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);