ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,573 rows where county = "Albany" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
12358 | 12358 | 2020-03-25 | Albany | Wyoming | 56001 | 1 | 0 |
14014 | 14014 | 2020-03-26 | Albany | Wyoming | 56001 | 1 | 0 |
15790 | 15790 | 2020-03-27 | Albany | Wyoming | 56001 | 1 | 0 |
17671 | 17671 | 2020-03-28 | Albany | Wyoming | 56001 | 1 | 0 |
19640 | 19640 | 2020-03-29 | Albany | Wyoming | 56001 | 1 | 0 |
21712 | 21712 | 2020-03-30 | Albany | Wyoming | 56001 | 1 | 0 |
1516 | 1516 | 2020-03-12 | Albany | New York | 36001 | 2 | 0 |
1809 | 1809 | 2020-03-13 | Albany | New York | 36001 | 2 | 0 |
23865 | 23865 | 2020-03-31 | Albany | Wyoming | 56001 | 3 | 0 |
26086 | 26086 | 2020-04-01 | Albany | Wyoming | 56001 | 3 | 0 |
28380 | 28380 | 2020-04-02 | Albany | Wyoming | 56001 | 3 | 0 |
30736 | 30736 | 2020-04-03 | Albany | Wyoming | 56001 | 4 | 0 |
33139 | 33139 | 2020-04-04 | Albany | Wyoming | 56001 | 4 | 0 |
35578 | 35578 | 2020-04-05 | Albany | Wyoming | 56001 | 4 | 0 |
38066 | 38066 | 2020-04-06 | Albany | Wyoming | 56001 | 4 | 0 |
40608 | 40608 | 2020-04-07 | Albany | Wyoming | 56001 | 4 | 0 |
43180 | 43180 | 2020-04-08 | Albany | Wyoming | 56001 | 4 | 0 |
45778 | 45778 | 2020-04-09 | Albany | Wyoming | 56001 | 4 | 0 |
48407 | 48407 | 2020-04-10 | Albany | Wyoming | 56001 | 4 | 0 |
2157 | 2157 | 2020-03-14 | Albany | New York | 36001 | 5 | 0 |
51068 | 51068 | 2020-04-11 | Albany | Wyoming | 56001 | 5 | 0 |
53745 | 53745 | 2020-04-12 | Albany | Wyoming | 56001 | 5 | 0 |
56436 | 56436 | 2020-04-13 | Albany | Wyoming | 56001 | 5 | 0 |
59144 | 59144 | 2020-04-14 | Albany | Wyoming | 56001 | 5 | 0 |
61863 | 61863 | 2020-04-15 | Albany | Wyoming | 56001 | 5 | 0 |
64596 | 64596 | 2020-04-16 | Albany | Wyoming | 56001 | 5 | 0 |
78434 | 78434 | 2020-04-21 | Albany | Wyoming | 56001 | 6 | 0 |
81227 | 81227 | 2020-04-22 | Albany | Wyoming | 56001 | 6 | 0 |
84028 | 84028 | 2020-04-23 | Albany | Wyoming | 56001 | 6 | 0 |
86836 | 86836 | 2020-04-24 | Albany | Wyoming | 56001 | 6 | 0 |
89652 | 89652 | 2020-04-25 | Albany | Wyoming | 56001 | 6 | 0 |
92470 | 92470 | 2020-04-26 | Albany | Wyoming | 56001 | 6 | 0 |
67344 | 67344 | 2020-04-17 | Albany | Wyoming | 56001 | 7 | 0 |
70106 | 70106 | 2020-04-18 | Albany | Wyoming | 56001 | 7 | 0 |
72875 | 72875 | 2020-04-19 | Albany | Wyoming | 56001 | 7 | 0 |
75651 | 75651 | 2020-04-20 | Albany | Wyoming | 56001 | 7 | 0 |
95300 | 95300 | 2020-04-27 | Albany | Wyoming | 56001 | 7 | 0 |
98145 | 98145 | 2020-04-28 | Albany | Wyoming | 56001 | 8 | 0 |
100995 | 100995 | 2020-04-29 | Albany | Wyoming | 56001 | 8 | 0 |
103850 | 103850 | 2020-04-30 | Albany | Wyoming | 56001 | 8 | 0 |
106715 | 106715 | 2020-05-01 | Albany | Wyoming | 56001 | 8 | 0 |
109584 | 109584 | 2020-05-02 | Albany | Wyoming | 56001 | 8 | 0 |
112459 | 112459 | 2020-05-03 | Albany | Wyoming | 56001 | 8 | 0 |
115342 | 115342 | 2020-05-04 | Albany | Wyoming | 56001 | 8 | 0 |
118301 | 118301 | 2020-05-05 | Albany | Wyoming | 56001 | 8 | 0 |
121267 | 121267 | 2020-05-06 | Albany | Wyoming | 56001 | 8 | 0 |
124247 | 124247 | 2020-05-07 | Albany | Wyoming | 56001 | 8 | 0 |
127232 | 127232 | 2020-05-08 | Albany | Wyoming | 56001 | 8 | 0 |
130222 | 130222 | 2020-05-09 | Albany | Wyoming | 56001 | 8 | 0 |
133212 | 133212 | 2020-05-10 | Albany | Wyoming | 56001 | 8 | 0 |
136202 | 136202 | 2020-05-11 | Albany | Wyoming | 56001 | 8 | 0 |
139193 | 139193 | 2020-05-12 | Albany | Wyoming | 56001 | 8 | 0 |
142189 | 142189 | 2020-05-13 | Albany | Wyoming | 56001 | 8 | 0 |
145188 | 145188 | 2020-05-14 | Albany | Wyoming | 56001 | 8 | 0 |
148191 | 148191 | 2020-05-15 | Albany | Wyoming | 56001 | 8 | 0 |
151200 | 151200 | 2020-05-16 | Albany | Wyoming | 56001 | 9 | 0 |
154212 | 154212 | 2020-05-17 | Albany | Wyoming | 56001 | 9 | 0 |
157228 | 157228 | 2020-05-18 | Albany | Wyoming | 56001 | 10 | 0 |
160252 | 160252 | 2020-05-19 | Albany | Wyoming | 56001 | 10 | 0 |
163280 | 163280 | 2020-05-20 | Albany | Wyoming | 56001 | 10 | 0 |
166311 | 166311 | 2020-05-21 | Albany | Wyoming | 56001 | 10 | 0 |
169347 | 169347 | 2020-05-22 | Albany | Wyoming | 56001 | 10 | 0 |
2565 | 2565 | 2020-03-15 | Albany | New York | 36001 | 11 | 0 |
3023 | 3023 | 2020-03-16 | Albany | New York | 36001 | 12 | 0 |
172388 | 172388 | 2020-05-23 | Albany | Wyoming | 56001 | 14 | 0 |
175431 | 175431 | 2020-05-24 | Albany | Wyoming | 56001 | 14 | 0 |
178476 | 178476 | 2020-05-25 | Albany | Wyoming | 56001 | 20 | 0 |
3538 | 3538 | 2020-03-17 | Albany | New York | 36001 | 23 | 0 |
181520 | 181520 | 2020-05-26 | Albany | Wyoming | 56001 | 23 | 0 |
184571 | 184571 | 2020-05-27 | Albany | Wyoming | 56001 | 23 | 0 |
187628 | 187628 | 2020-05-28 | Albany | Wyoming | 56001 | 24 | 0 |
190692 | 190692 | 2020-05-29 | Albany | Wyoming | 56001 | 25 | 0 |
193758 | 193758 | 2020-05-30 | Albany | Wyoming | 56001 | 25 | 0 |
196828 | 196828 | 2020-05-31 | Albany | Wyoming | 56001 | 25 | 0 |
199901 | 199901 | 2020-06-01 | Albany | Wyoming | 56001 | 25 | 0 |
202977 | 202977 | 2020-06-02 | Albany | Wyoming | 56001 | 25 | 0 |
206056 | 206056 | 2020-06-03 | Albany | Wyoming | 56001 | 25 | 0 |
209138 | 209138 | 2020-06-04 | Albany | Wyoming | 56001 | 25 | 0 |
233898 | 233898 | 2020-06-12 | Albany | Wyoming | 56001 | 25 | 0 |
212223 | 212223 | 2020-06-05 | Albany | Wyoming | 56001 | 26 | 0 |
215310 | 215310 | 2020-06-06 | Albany | Wyoming | 56001 | 26 | 0 |
218400 | 218400 | 2020-06-07 | Albany | Wyoming | 56001 | 26 | 0 |
221492 | 221492 | 2020-06-08 | Albany | Wyoming | 56001 | 26 | 0 |
224588 | 224588 | 2020-06-09 | Albany | Wyoming | 56001 | 26 | 0 |
227689 | 227689 | 2020-06-10 | Albany | Wyoming | 56001 | 26 | 0 |
230793 | 230793 | 2020-06-11 | Albany | Wyoming | 56001 | 26 | 0 |
237005 | 237005 | 2020-06-13 | Albany | Wyoming | 56001 | 26 | 0 |
240113 | 240113 | 2020-06-14 | Albany | Wyoming | 56001 | 26 | 0 |
243224 | 243224 | 2020-06-15 | Albany | Wyoming | 56001 | 27 | 0 |
246337 | 246337 | 2020-06-16 | Albany | Wyoming | 56001 | 28 | 0 |
249449 | 249449 | 2020-06-17 | Albany | Wyoming | 56001 | 28 | 0 |
252564 | 252564 | 2020-06-18 | Albany | Wyoming | 56001 | 28 | 0 |
255683 | 255683 | 2020-06-19 | Albany | Wyoming | 56001 | 28 | 0 |
258810 | 258810 | 2020-06-20 | Albany | Wyoming | 56001 | 28 | 0 |
261937 | 261937 | 2020-06-21 | Albany | Wyoming | 56001 | 28 | 0 |
265066 | 265066 | 2020-06-22 | Albany | Wyoming | 56001 | 29 | 0 |
268195 | 268195 | 2020-06-23 | Albany | Wyoming | 56001 | 29 | 0 |
271329 | 271329 | 2020-06-24 | Albany | Wyoming | 56001 | 31 | 0 |
274469 | 274469 | 2020-06-25 | Albany | Wyoming | 56001 | 31 | 0 |
277617 | 277617 | 2020-06-26 | Albany | Wyoming | 56001 | 32 | 0 |
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);