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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
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 |
12358 | 12358 | 2020-03-25 | Albany | Wyoming | 56001 | 1 | 0 |
13336 | 13336 | 2020-03-26 | Albany | New York | 36001 | 171 | 0 |
14014 | 14014 | 2020-03-26 | Albany | Wyoming | 56001 | 1 | 0 |
15070 | 15070 | 2020-03-27 | Albany | New York | 36001 | 187 | 0 |
15790 | 15790 | 2020-03-27 | Albany | Wyoming | 56001 | 1 | 0 |
16899 | 16899 | 2020-03-28 | Albany | New York | 36001 | 195 | 1 |
17671 | 17671 | 2020-03-28 | Albany | Wyoming | 56001 | 1 | 0 |
18823 | 18823 | 2020-03-29 | Albany | New York | 36001 | 205 | 1 |
19640 | 19640 | 2020-03-29 | Albany | Wyoming | 56001 | 1 | 0 |
20862 | 20862 | 2020-03-30 | Albany | New York | 36001 | 217 | 1 |
21712 | 21712 | 2020-03-30 | Albany | Wyoming | 56001 | 1 | 0 |
22985 | 22985 | 2020-03-31 | Albany | New York | 36001 | 226 | 1 |
23865 | 23865 | 2020-03-31 | Albany | Wyoming | 56001 | 3 | 0 |
25179 | 25179 | 2020-04-01 | Albany | New York | 36001 | 240 | 2 |
26086 | 26086 | 2020-04-01 | Albany | Wyoming | 56001 | 3 | 0 |
27439 | 27439 | 2020-04-02 | Albany | New York | 36001 | 253 | 2 |
28380 | 28380 | 2020-04-02 | Albany | Wyoming | 56001 | 3 | 0 |
29763 | 29763 | 2020-04-03 | Albany | New York | 36001 | 267 | 4 |
30736 | 30736 | 2020-04-03 | Albany | Wyoming | 56001 | 4 | 0 |
32149 | 32149 | 2020-04-04 | Albany | New York | 36001 | 293 | 6 |
33139 | 33139 | 2020-04-04 | Albany | Wyoming | 56001 | 4 | 0 |
34580 | 34580 | 2020-04-05 | Albany | New York | 36001 | 305 | 8 |
35578 | 35578 | 2020-04-05 | Albany | Wyoming | 56001 | 4 | 0 |
37050 | 37050 | 2020-04-06 | Albany | New York | 36001 | 319 | 9 |
38066 | 38066 | 2020-04-06 | Albany | Wyoming | 56001 | 4 | 0 |
39565 | 39565 | 2020-04-07 | Albany | New York | 36001 | 333 | 9 |
40608 | 40608 | 2020-04-07 | Albany | Wyoming | 56001 | 4 | 0 |
42122 | 42122 | 2020-04-08 | Albany | New York | 36001 | 342 | 10 |
43180 | 43180 | 2020-04-08 | Albany | Wyoming | 56001 | 4 | 0 |
44705 | 44705 | 2020-04-09 | Albany | New York | 36001 | 379 | 12 |
45778 | 45778 | 2020-04-09 | Albany | Wyoming | 56001 | 4 | 0 |
47318 | 47318 | 2020-04-10 | Albany | New York | 36001 | 426 | 14 |
48407 | 48407 | 2020-04-10 | Albany | Wyoming | 56001 | 4 | 0 |
49973 | 49973 | 2020-04-11 | Albany | New York | 36001 | 446 | 16 |
51068 | 51068 | 2020-04-11 | Albany | Wyoming | 56001 | 5 | 0 |
52646 | 52646 | 2020-04-12 | Albany | New York | 36001 | 478 | 16 |
53745 | 53745 | 2020-04-12 | Albany | Wyoming | 56001 | 5 | 0 |
55329 | 55329 | 2020-04-13 | Albany | New York | 36001 | 499 | 17 |
56436 | 56436 | 2020-04-13 | Albany | Wyoming | 56001 | 5 | 0 |
58029 | 58029 | 2020-04-14 | Albany | New York | 36001 | 535 | 21 |
59144 | 59144 | 2020-04-14 | Albany | Wyoming | 56001 | 5 | 0 |
60743 | 60743 | 2020-04-15 | Albany | New York | 36001 | 548 | 26 |
61863 | 61863 | 2020-04-15 | Albany | Wyoming | 56001 | 5 | 0 |
63469 | 63469 | 2020-04-16 | Albany | New York | 36001 | 581 | 26 |
64596 | 64596 | 2020-04-16 | Albany | Wyoming | 56001 | 5 | 0 |
66211 | 66211 | 2020-04-17 | Albany | New York | 36001 | 619 | 26 |
67344 | 67344 | 2020-04-17 | Albany | Wyoming | 56001 | 7 | 0 |
68968 | 68968 | 2020-04-18 | Albany | New York | 36001 | 648 | 26 |
70106 | 70106 | 2020-04-18 | Albany | Wyoming | 56001 | 7 | 0 |
71735 | 71735 | 2020-04-19 | Albany | New York | 36001 | 682 | 33 |
72875 | 72875 | 2020-04-19 | Albany | Wyoming | 56001 | 7 | 0 |
74510 | 74510 | 2020-04-20 | Albany | New York | 36001 | 687 | 35 |
75651 | 75651 | 2020-04-20 | Albany | Wyoming | 56001 | 7 | 0 |
77291 | 77291 | 2020-04-21 | Albany | New York | 36001 | 704 | 36 |
78434 | 78434 | 2020-04-21 | Albany | Wyoming | 56001 | 6 | 0 |
80080 | 80080 | 2020-04-22 | Albany | New York | 36001 | 737 | 36 |
81227 | 81227 | 2020-04-22 | Albany | Wyoming | 56001 | 6 | 0 |
82879 | 82879 | 2020-04-23 | Albany | New York | 36001 | 758 | 41 |
84028 | 84028 | 2020-04-23 | Albany | Wyoming | 56001 | 6 | 0 |
85683 | 85683 | 2020-04-24 | Albany | New York | 36001 | 805 | 42 |
86836 | 86836 | 2020-04-24 | Albany | Wyoming | 56001 | 6 | 0 |
88495 | 88495 | 2020-04-25 | Albany | New York | 36001 | 899 | 43 |
89652 | 89652 | 2020-04-25 | Albany | Wyoming | 56001 | 6 | 0 |
91310 | 91310 | 2020-04-26 | Albany | New York | 36001 | 948 | 45 |
92470 | 92470 | 2020-04-26 | Albany | Wyoming | 56001 | 6 | 0 |
94135 | 94135 | 2020-04-27 | Albany | New York | 36001 | 979 | 45 |
95300 | 95300 | 2020-04-27 | Albany | Wyoming | 56001 | 7 | 0 |
96971 | 96971 | 2020-04-28 | Albany | New York | 36001 | 1009 | 45 |
98145 | 98145 | 2020-04-28 | Albany | Wyoming | 56001 | 8 | 0 |
99818 | 99818 | 2020-04-29 | Albany | New York | 36001 | 1067 | 47 |
100995 | 100995 | 2020-04-29 | Albany | Wyoming | 56001 | 8 | 0 |
102671 | 102671 | 2020-04-30 | Albany | New York | 36001 | 1165 | 53 |
103850 | 103850 | 2020-04-30 | Albany | Wyoming | 56001 | 8 | 0 |
105533 | 105533 | 2020-05-01 | Albany | New York | 36001 | 1204 | 55 |
106715 | 106715 | 2020-05-01 | Albany | Wyoming | 56001 | 8 | 0 |
108400 | 108400 | 2020-05-02 | Albany | New York | 36001 | 1238 | 60 |
109584 | 109584 | 2020-05-02 | Albany | Wyoming | 56001 | 8 | 0 |
111273 | 111273 | 2020-05-03 | Albany | New York | 36001 | 1258 | 61 |
112459 | 112459 | 2020-05-03 | Albany | Wyoming | 56001 | 8 | 0 |
114154 | 114154 | 2020-05-04 | Albany | New York | 36001 | 1287 | 65 |
115342 | 115342 | 2020-05-04 | Albany | Wyoming | 56001 | 8 | 0 |
117034 | 117034 | 2020-05-05 | Albany | New York | 36001 | 1294 | 70 |
118301 | 118301 | 2020-05-05 | Albany | Wyoming | 56001 | 8 | 0 |
119995 | 119995 | 2020-05-06 | Albany | New York | 36001 | 1321 | 93 |
121267 | 121267 | 2020-05-06 | Albany | Wyoming | 56001 | 8 | 0 |
122970 | 122970 | 2020-05-07 | Albany | New York | 36001 | 1348 | 100 |
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);