ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Albany" and state = "New York" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- …
state 1
- New York · 793 ✖
fips 1
- 36001 793
county 1
- Albany · 793 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1516 | 1516 | 2020-03-12 | Albany | New York | 36001 | 2 | 0 |
1809 | 1809 | 2020-03-13 | Albany | New York | 36001 | 2 | 0 |
2157 | 2157 | 2020-03-14 | Albany | New York | 36001 | 5 | 0 |
2565 | 2565 | 2020-03-15 | Albany | New York | 36001 | 11 | 0 |
3023 | 3023 | 2020-03-16 | Albany | New York | 36001 | 12 | 0 |
3538 | 3538 | 2020-03-17 | Albany | New York | 36001 | 23 | 0 |
4134 | 4134 | 2020-03-18 | Albany | New York | 36001 | 36 | 0 |
4863 | 4863 | 2020-03-19 | Albany | New York | 36001 | 43 | 0 |
5709 | 5709 | 2020-03-20 | Albany | New York | 36001 | 61 | 0 |
6703 | 6703 | 2020-03-21 | Albany | New York | 36001 | 88 | 0 |
7796 | 7796 | 2020-03-22 | Albany | New York | 36001 | 123 | 0 |
8993 | 8993 | 2020-03-23 | Albany | New York | 36001 | 127 | 0 |
10299 | 10299 | 2020-03-24 | Albany | New York | 36001 | 146 | 0 |
11733 | 11733 | 2020-03-25 | Albany | New York | 36001 | 152 | 0 |
13336 | 13336 | 2020-03-26 | Albany | New York | 36001 | 171 | 0 |
15070 | 15070 | 2020-03-27 | Albany | New York | 36001 | 187 | 0 |
16899 | 16899 | 2020-03-28 | Albany | New York | 36001 | 195 | 1 |
18823 | 18823 | 2020-03-29 | Albany | New York | 36001 | 205 | 1 |
20862 | 20862 | 2020-03-30 | Albany | New York | 36001 | 217 | 1 |
22985 | 22985 | 2020-03-31 | Albany | New York | 36001 | 226 | 1 |
25179 | 25179 | 2020-04-01 | Albany | New York | 36001 | 240 | 2 |
27439 | 27439 | 2020-04-02 | Albany | New York | 36001 | 253 | 2 |
29763 | 29763 | 2020-04-03 | Albany | New York | 36001 | 267 | 4 |
32149 | 32149 | 2020-04-04 | Albany | New York | 36001 | 293 | 6 |
34580 | 34580 | 2020-04-05 | Albany | New York | 36001 | 305 | 8 |
37050 | 37050 | 2020-04-06 | Albany | New York | 36001 | 319 | 9 |
39565 | 39565 | 2020-04-07 | Albany | New York | 36001 | 333 | 9 |
42122 | 42122 | 2020-04-08 | Albany | New York | 36001 | 342 | 10 |
44705 | 44705 | 2020-04-09 | Albany | New York | 36001 | 379 | 12 |
47318 | 47318 | 2020-04-10 | Albany | New York | 36001 | 426 | 14 |
49973 | 49973 | 2020-04-11 | Albany | New York | 36001 | 446 | 16 |
52646 | 52646 | 2020-04-12 | Albany | New York | 36001 | 478 | 16 |
55329 | 55329 | 2020-04-13 | Albany | New York | 36001 | 499 | 17 |
58029 | 58029 | 2020-04-14 | Albany | New York | 36001 | 535 | 21 |
60743 | 60743 | 2020-04-15 | Albany | New York | 36001 | 548 | 26 |
63469 | 63469 | 2020-04-16 | Albany | New York | 36001 | 581 | 26 |
66211 | 66211 | 2020-04-17 | Albany | New York | 36001 | 619 | 26 |
68968 | 68968 | 2020-04-18 | Albany | New York | 36001 | 648 | 26 |
71735 | 71735 | 2020-04-19 | Albany | New York | 36001 | 682 | 33 |
74510 | 74510 | 2020-04-20 | Albany | New York | 36001 | 687 | 35 |
77291 | 77291 | 2020-04-21 | Albany | New York | 36001 | 704 | 36 |
80080 | 80080 | 2020-04-22 | Albany | New York | 36001 | 737 | 36 |
82879 | 82879 | 2020-04-23 | Albany | New York | 36001 | 758 | 41 |
85683 | 85683 | 2020-04-24 | Albany | New York | 36001 | 805 | 42 |
88495 | 88495 | 2020-04-25 | Albany | New York | 36001 | 899 | 43 |
91310 | 91310 | 2020-04-26 | Albany | New York | 36001 | 948 | 45 |
94135 | 94135 | 2020-04-27 | Albany | New York | 36001 | 979 | 45 |
96971 | 96971 | 2020-04-28 | Albany | New York | 36001 | 1009 | 45 |
99818 | 99818 | 2020-04-29 | Albany | New York | 36001 | 1067 | 47 |
102671 | 102671 | 2020-04-30 | Albany | New York | 36001 | 1165 | 53 |
105533 | 105533 | 2020-05-01 | Albany | New York | 36001 | 1204 | 55 |
108400 | 108400 | 2020-05-02 | Albany | New York | 36001 | 1238 | 60 |
111273 | 111273 | 2020-05-03 | Albany | New York | 36001 | 1258 | 61 |
114154 | 114154 | 2020-05-04 | Albany | New York | 36001 | 1287 | 65 |
117034 | 117034 | 2020-05-05 | Albany | New York | 36001 | 1294 | 70 |
119995 | 119995 | 2020-05-06 | Albany | New York | 36001 | 1321 | 93 |
122970 | 122970 | 2020-05-07 | Albany | New York | 36001 | 1348 | 100 |
125953 | 125953 | 2020-05-08 | Albany | New York | 36001 | 1384 | 103 |
128942 | 128942 | 2020-05-09 | Albany | New York | 36001 | 1416 | 107 |
131931 | 131931 | 2020-05-10 | Albany | New York | 36001 | 1432 | 109 |
134922 | 134922 | 2020-05-11 | Albany | New York | 36001 | 1456 | 112 |
137912 | 137912 | 2020-05-12 | Albany | New York | 36001 | 1479 | 116 |
140908 | 140908 | 2020-05-13 | Albany | New York | 36001 | 1494 | 118 |
143903 | 143903 | 2020-05-14 | Albany | New York | 36001 | 1509 | 120 |
146904 | 146904 | 2020-05-15 | Albany | New York | 36001 | 1538 | 124 |
149911 | 149911 | 2020-05-16 | Albany | New York | 36001 | 1572 | 127 |
152921 | 152921 | 2020-05-17 | Albany | New York | 36001 | 1579 | 128 |
155938 | 155938 | 2020-05-18 | Albany | New York | 36001 | 1610 | 129 |
158956 | 158956 | 2020-05-19 | Albany | New York | 36001 | 1655 | 130 |
161983 | 161983 | 2020-05-20 | Albany | New York | 36001 | 1682 | 132 |
165012 | 165012 | 2020-05-21 | Albany | New York | 36001 | 1700 | 134 |
168047 | 168047 | 2020-05-22 | Albany | New York | 36001 | 1756 | 136 |
171086 | 171086 | 2020-05-23 | Albany | New York | 36001 | 1770 | 138 |
174128 | 174128 | 2020-05-24 | Albany | New York | 36001 | 1782 | 140 |
177172 | 177172 | 2020-05-25 | Albany | New York | 36001 | 1791 | 141 |
180215 | 180215 | 2020-05-26 | Albany | New York | 36001 | 1793 | 141 |
183263 | 183263 | 2020-05-27 | Albany | New York | 36001 | 1796 | 141 |
186320 | 186320 | 2020-05-28 | Albany | New York | 36001 | 1814 | 142 |
189380 | 189380 | 2020-05-29 | Albany | New York | 36001 | 1834 | 142 |
192444 | 192444 | 2020-05-30 | Albany | New York | 36001 | 1843 | 142 |
195514 | 195514 | 2020-05-31 | Albany | New York | 36001 | 1860 | 142 |
198587 | 198587 | 2020-06-01 | Albany | New York | 36001 | 1882 | 143 |
201661 | 201661 | 2020-06-02 | Albany | New York | 36001 | 1900 | 143 |
204738 | 204738 | 2020-06-03 | Albany | New York | 36001 | 1920 | 145 |
207819 | 207819 | 2020-06-04 | Albany | New York | 36001 | 1930 | 145 |
210901 | 210901 | 2020-06-05 | Albany | New York | 36001 | 1941 | 145 |
213985 | 213985 | 2020-06-06 | Albany | New York | 36001 | 1953 | 146 |
217075 | 217075 | 2020-06-07 | Albany | New York | 36001 | 1961 | 148 |
220167 | 220167 | 2020-06-08 | Albany | New York | 36001 | 1978 | 148 |
223261 | 223261 | 2020-06-09 | Albany | New York | 36001 | 1983 | 149 |
226361 | 226361 | 2020-06-10 | Albany | New York | 36001 | 1986 | 150 |
229465 | 229465 | 2020-06-11 | Albany | New York | 36001 | 1996 | 152 |
232570 | 232570 | 2020-06-12 | Albany | New York | 36001 | 2007 | 152 |
235675 | 235675 | 2020-06-13 | Albany | New York | 36001 | 2016 | 152 |
238783 | 238783 | 2020-06-14 | Albany | New York | 36001 | 2020 | 153 |
241892 | 241892 | 2020-06-15 | Albany | New York | 36001 | 2022 | 154 |
245004 | 245004 | 2020-06-16 | Albany | New York | 36001 | 2026 | 156 |
248117 | 248117 | 2020-06-17 | Albany | New York | 36001 | 2029 | 157 |
251232 | 251232 | 2020-06-18 | Albany | New York | 36001 | 2034 | 157 |
254347 | 254347 | 2020-06-19 | Albany | New York | 36001 | 2049 | 157 |
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);