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

137 rows where fips = 6001 sorted by date descending

View and edit SQL

state

fips

  • 6001 · 137

county

Link rowid date ▲ county state fips cases deaths
334561 2020-07-15 Alameda California 6001 8499 154
331370 2020-07-14 Alameda California 6001 8342 152
328186 2020-07-13 Alameda California 6001 8077 148
325002 2020-07-12 Alameda California 6001 7866 148
321823 2020-07-11 Alameda California 6001 7746 148
318646 2020-07-10 Alameda California 6001 7506 147
315475 2020-07-09 Alameda California 6001 7428 146
312302 2020-07-08 Alameda California 6001 7266 142
309134 2020-07-07 Alameda California 6001 6991 140
305968 2020-07-06 Alameda California 6001 6908 140
302806 2020-07-05 Alameda California 6001 6876 140
299644 2020-07-04 Alameda California 6001 6577 140
296484 2020-07-03 Alameda California 6001 6493 140
293330 2020-07-02 Alameda California 6001 6405 138
290178 2020-07-01 Alameda California 6001 6177 136
287029 2020-06-30 Alameda California 6001 5985 135
283884 2020-06-29 Alameda California 6001 5783 133
280739 2020-06-28 Alameda California 6001 5691 133
277593 2020-06-27 Alameda California 6001 5523 130
274447 2020-06-26 Alameda California 6001 5514 130
271309 2020-06-25 Alameda California 6001 5403 128
268176 2020-06-24 Alameda California 6001 5296 122
265048 2020-06-23 Alameda California 6001 5161 121
261921 2020-06-22 Alameda California 6001 5028 120
258796 2020-06-21 Alameda California 6001 4826 119
255671 2020-06-20 Alameda California 6001 4826 118
252554 2020-06-19 Alameda California 6001 4723 118
249441 2020-06-18 Alameda California 6001 4659 117
246331 2020-06-17 Alameda California 6001 4554 116
243220 2020-06-16 Alameda California 6001 4502 112
240111 2020-06-15 Alameda California 6001 4394 112
237005 2020-06-14 Alameda California 6001 4341 112
233900 2020-06-13 Alameda California 6001 4237 110
230796 2020-06-12 Alameda California 6001 4237 110
227694 2020-06-11 Alameda California 6001 4140 110
224594 2020-06-10 Alameda California 6001 4054 110
221500 2020-06-09 Alameda California 6001 4006 110
218407 2020-06-08 Alameda California 6001 3966 104
215318 2020-06-07 Alameda California 6001 3895 104
212233 2020-06-06 Alameda California 6001 3826 104
209150 2020-06-05 Alameda California 6001 3746 104
206071 2020-06-04 Alameda California 6001 3662 104
202994 2020-06-03 Alameda California 6001 3569 104
199921 2020-06-02 Alameda California 6001 3536 104
196851 2020-06-01 Alameda California 6001 3491 104
193784 2020-05-31 Alameda California 6001 3411 103
190720 2020-05-30 Alameda California 6001 3310 103
187658 2020-05-29 Alameda California 6001 3216 102
184605 2020-05-28 Alameda California 6001 3118 97
181554 2020-05-27 Alameda California 6001 3070 97
178513 2020-05-26 Alameda California 6001 3007 93
175472 2020-05-25 Alameda California 6001 2895 93
172431 2020-05-24 Alameda California 6001 2868 93
169393 2020-05-23 Alameda California 6001 2788 92
166360 2020-05-22 Alameda California 6001 2729 90
163331 2020-05-21 Alameda California 6001 2630 90
160306 2020-05-20 Alameda California 6001 2581 88
157283 2020-05-19 Alameda California 6001 2543 88
154270 2020-05-18 Alameda California 6001 2478 85
151261 2020-05-17 Alameda California 6001 2413 85
148255 2020-05-16 Alameda California 6001 2372 85
145254 2020-05-15 Alameda California 6001 2321 84
142258 2020-05-14 Alameda California 6001 2202 80
139265 2020-05-13 Alameda California 6001 2199 80
136277 2020-05-12 Alameda California 6001 2154 75
133290 2020-05-11 Alameda California 6001 2122 75
130303 2020-05-10 Alameda California 6001 2085 75
127316 2020-05-09 Alameda California 6001 2044 72
124334 2020-05-08 Alameda California 6001 1982 70
121357 2020-05-07 Alameda California 6001 1938 69
118394 2020-05-06 Alameda California 6001 1884 69
115439 2020-05-05 Alameda California 6001 1830 66
112560 2020-05-04 Alameda California 6001 1797 65
109689 2020-05-03 Alameda California 6001 1770 63
106824 2020-05-02 Alameda California 6001 1726 63
103963 2020-05-01 Alameda California 6001 1657 63
101112 2020-04-30 Alameda California 6001 1624 63
98266 2020-04-29 Alameda California 6001 1589 59
95425 2020-04-28 Alameda California 6001 1554 59
92597 2020-04-27 Alameda California 6001 1519 56
89782 2020-04-26 Alameda California 6001 1489 52
86968 2020-04-25 Alameda California 6001 1458 52
84163 2020-04-24 Alameda California 6001 1422 48
81366 2020-04-23 Alameda California 6001 1350 48
78575 2020-04-22 Alameda California 6001 1260 43
75794 2020-04-21 Alameda California 6001 1260 43
73021 2020-04-20 Alameda California 6001 1212 42
70255 2020-04-19 Alameda California 6001 1185 42
67496 2020-04-18 Alameda California 6001 1135 41
64751 2020-04-17 Alameda California 6001 1084 40
62021 2020-04-16 Alameda California 6001 1069 40
59305 2020-04-15 Alameda California 6001 983 36
56600 2020-04-14 Alameda California 6001 908 23
53911 2020-04-13 Alameda California 6001 907 23
51235 2020-04-12 Alameda California 6001 864 23
48576 2020-04-11 Alameda California 6001 827 21
45949 2020-04-10 Alameda California 6001 766 20
43352 2020-04-09 Alameda California 6001 734 17
40783 2020-04-08 Alameda California 6001 695 16
38242 2020-04-07 Alameda California 6001 655 15

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 1133.916ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette