ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

165 rows where fips = 6075 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 6075 · 165

county

Link rowid date ▲ county state fips cases deaths
334597 2020-07-15 San Francisco California 6075 4699 50
331406 2020-07-14 San Francisco California 6075 4643 50
328222 2020-07-13 San Francisco California 6075 4593 50
325038 2020-07-12 San Francisco California 6075 4525 50
321859 2020-07-11 San Francisco California 6075 4429 50
318682 2020-07-10 San Francisco California 6075 4319 50
315511 2020-07-09 San Francisco California 6075 4148 50
312338 2020-07-08 San Francisco California 6075 4074 50
309170 2020-07-07 San Francisco California 6075 4023 50
306004 2020-07-06 San Francisco California 6075 3995 50
302842 2020-07-05 San Francisco California 6075 3864 50
299680 2020-07-04 San Francisco California 6075 3784 50
296520 2020-07-03 San Francisco California 6075 3722 50
293366 2020-07-02 San Francisco California 6075 3722 50
290214 2020-07-01 San Francisco California 6075 3651 50
287065 2020-06-30 San Francisco California 6075 3606 50
283920 2020-06-29 San Francisco California 6075 3564 50
280775 2020-06-28 San Francisco California 6075 3515 50
277629 2020-06-27 San Francisco California 6075 3471 49
274483 2020-06-26 San Francisco California 6075 3403 48
271345 2020-06-25 San Francisco California 6075 3300 48
268212 2020-06-24 San Francisco California 6075 3252 48
265084 2020-06-23 San Francisco California 6075 3222 48
261957 2020-06-22 San Francisco California 6075 3188 48
258832 2020-06-21 San Francisco California 6075 3061 47
255707 2020-06-20 San Francisco California 6075 3061 47
252590 2020-06-19 San Francisco California 6075 3060 47
249477 2020-06-18 San Francisco California 6075 3023 47
246367 2020-06-17 San Francisco California 6075 2985 47
243256 2020-06-16 San Francisco California 6075 2974 46
240147 2020-06-15 San Francisco California 6075 2955 45
237041 2020-06-14 San Francisco California 6075 2931 45
233936 2020-06-13 San Francisco California 6075 2909 44
230832 2020-06-12 San Francisco California 6075 2880 44
227730 2020-06-11 San Francisco California 6075 2843 44
224630 2020-06-10 San Francisco California 6075 2812 44
221536 2020-06-09 San Francisco California 6075 2796 44
218443 2020-06-08 San Francisco California 6075 2782 43
215354 2020-06-07 San Francisco California 6075 2750 43
212269 2020-06-06 San Francisco California 6075 2715 43
209186 2020-06-05 San Francisco California 6075 2701 43
206107 2020-06-04 San Francisco California 6075 2647 43
203030 2020-06-03 San Francisco California 6075 2616 43
199957 2020-06-02 San Francisco California 6075 2590 43
196887 2020-06-01 San Francisco California 6075 2573 43
193820 2020-05-31 San Francisco California 6075 2561 42
190756 2020-05-30 San Francisco California 6075 2535 41
187694 2020-05-29 San Francisco California 6075 2476 41
184641 2020-05-28 San Francisco California 6075 2440 40
181590 2020-05-27 San Francisco California 6075 2411 40
178549 2020-05-26 San Francisco California 6075 2402 40
175508 2020-05-25 San Francisco California 6075 2389 40
172467 2020-05-24 San Francisco California 6075 2370 40
169429 2020-05-23 San Francisco California 6075 2353 40
166395 2020-05-22 San Francisco California 6075 2323 40
163366 2020-05-21 San Francisco California 6075 2202 37
160341 2020-05-20 San Francisco California 6075 2189 37
157318 2020-05-19 San Francisco California 6075 2186 36
154305 2020-05-18 San Francisco California 6075 2135 36
151296 2020-05-17 San Francisco California 6075 2097 36
148290 2020-05-16 San Francisco California 6075 2065 36
145289 2020-05-15 San Francisco California 6075 2032 36
142293 2020-05-14 San Francisco California 6075 2007 35
139300 2020-05-13 San Francisco California 6075 1997 35
136312 2020-05-12 San Francisco California 6075 1980 35
133325 2020-05-11 San Francisco California 6075 1957 35
130338 2020-05-10 San Francisco California 6075 1946 34
127351 2020-05-09 San Francisco California 6075 1894 33
124369 2020-05-08 San Francisco California 6075 1856 33
121392 2020-05-07 San Francisco California 6075 1806 32
118429 2020-05-06 San Francisco California 6075 1779 31
115474 2020-05-05 San Francisco California 6075 1760 31
112595 2020-05-04 San Francisco California 6075 1692 30
109724 2020-05-03 San Francisco California 6075 1632 29
106859 2020-05-02 San Francisco California 6075 1552 29
103998 2020-05-01 San Francisco California 6075 1526 28
101147 2020-04-30 San Francisco California 6075 1502 25
98301 2020-04-29 San Francisco California 6075 1490 23
95460 2020-04-28 San Francisco California 6075 1471 23
92631 2020-04-27 San Francisco California 6075 1427 23
89816 2020-04-26 San Francisco California 6075 1411 22
87002 2020-04-25 San Francisco California 6075 1357 22
84197 2020-04-24 San Francisco California 6075 1343 22
81400 2020-04-23 San Francisco California 6075 1305 21
78609 2020-04-22 San Francisco California 6075 1236 21
75828 2020-04-21 San Francisco California 6075 1234 20
73055 2020-04-20 San Francisco California 6075 1219 20
70289 2020-04-19 San Francisco California 6075 1160 20
67530 2020-04-18 San Francisco California 6075 1140 20
64785 2020-04-17 San Francisco California 6075 1061 20
62055 2020-04-16 San Francisco California 6075 1022 17
59339 2020-04-15 San Francisco California 6075 1016 17
56634 2020-04-14 San Francisco California 6075 990 15
53945 2020-04-13 San Francisco California 6075 960 15
51269 2020-04-12 San Francisco California 6075 875 14
48610 2020-04-11 San Francisco California 6075 860 13
45983 2020-04-10 San Francisco California 6075 800 13
43386 2020-04-09 San Francisco California 6075 727 10
40817 2020-04-08 San Francisco California 6075 679 10
38276 2020-04-07 San Francisco California 6075 622 9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1115.499ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette