ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Randolph" and state = "Alabama" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14068 | 14068 | 2020-03-27 | Randolph | Alabama | 1111 | 1 | 0 |
15847 | 15847 | 2020-03-28 | Randolph | Alabama | 1111 | 2 | 0 |
17731 | 17731 | 2020-03-29 | Randolph | Alabama | 1111 | 2 | 0 |
19703 | 19703 | 2020-03-30 | Randolph | Alabama | 1111 | 2 | 0 |
21775 | 21775 | 2020-03-31 | Randolph | Alabama | 1111 | 2 | 0 |
23931 | 23931 | 2020-04-01 | Randolph | Alabama | 1111 | 5 | 0 |
26153 | 26153 | 2020-04-02 | Randolph | Alabama | 1111 | 6 | 0 |
28450 | 28450 | 2020-04-03 | Randolph | Alabama | 1111 | 10 | 1 |
30807 | 30807 | 2020-04-04 | Randolph | Alabama | 1111 | 11 | 1 |
33211 | 33211 | 2020-04-05 | Randolph | Alabama | 1111 | 11 | 1 |
35650 | 35650 | 2020-04-06 | Randolph | Alabama | 1111 | 12 | 1 |
38138 | 38138 | 2020-04-07 | Randolph | Alabama | 1111 | 13 | 2 |
40680 | 40680 | 2020-04-08 | Randolph | Alabama | 1111 | 15 | 2 |
43254 | 43254 | 2020-04-09 | Randolph | Alabama | 1111 | 20 | 3 |
45852 | 45852 | 2020-04-10 | Randolph | Alabama | 1111 | 22 | 3 |
48481 | 48481 | 2020-04-11 | Randolph | Alabama | 1111 | 27 | 4 |
51143 | 51143 | 2020-04-12 | Randolph | Alabama | 1111 | 36 | 4 |
53821 | 53821 | 2020-04-13 | Randolph | Alabama | 1111 | 40 | 4 |
56513 | 56513 | 2020-04-14 | Randolph | Alabama | 1111 | 45 | 4 |
59221 | 59221 | 2020-04-15 | Randolph | Alabama | 1111 | 45 | 4 |
61939 | 61939 | 2020-04-16 | Randolph | Alabama | 1111 | 47 | 4 |
64672 | 64672 | 2020-04-17 | Randolph | Alabama | 1111 | 51 | 4 |
67420 | 67420 | 2020-04-18 | Randolph | Alabama | 1111 | 51 | 3 |
70182 | 70182 | 2020-04-19 | Randolph | Alabama | 1111 | 53 | 3 |
72951 | 72951 | 2020-04-20 | Randolph | Alabama | 1111 | 56 | 3 |
75727 | 75727 | 2020-04-21 | Randolph | Alabama | 1111 | 59 | 3 |
78510 | 78510 | 2020-04-22 | Randolph | Alabama | 1111 | 60 | 4 |
81303 | 81303 | 2020-04-23 | Randolph | Alabama | 1111 | 58 | 4 |
84104 | 84104 | 2020-04-24 | Randolph | Alabama | 1111 | 60 | 4 |
86912 | 86912 | 2020-04-25 | Randolph | Alabama | 1111 | 60 | 4 |
89728 | 89728 | 2020-04-26 | Randolph | Alabama | 1111 | 60 | 4 |
92546 | 92546 | 2020-04-27 | Randolph | Alabama | 1111 | 61 | 4 |
95376 | 95376 | 2020-04-28 | Randolph | Alabama | 1111 | 62 | 4 |
98221 | 98221 | 2020-04-29 | Randolph | Alabama | 1111 | 62 | 4 |
101071 | 101071 | 2020-04-30 | Randolph | Alabama | 1111 | 62 | 4 |
103926 | 103926 | 2020-05-01 | Randolph | Alabama | 1111 | 62 | 4 |
106791 | 106791 | 2020-05-02 | Randolph | Alabama | 1111 | 74 | 4 |
109660 | 109660 | 2020-05-03 | Randolph | Alabama | 1111 | 77 | 4 |
112535 | 112535 | 2020-05-04 | Randolph | Alabama | 1111 | 79 | 4 |
115418 | 115418 | 2020-05-05 | Randolph | Alabama | 1111 | 82 | 4 |
118377 | 118377 | 2020-05-06 | Randolph | Alabama | 1111 | 91 | 5 |
121343 | 121343 | 2020-05-07 | Randolph | Alabama | 1111 | 96 | 6 |
124323 | 124323 | 2020-05-08 | Randolph | Alabama | 1111 | 100 | 6 |
127308 | 127308 | 2020-05-09 | Randolph | Alabama | 1111 | 102 | 6 |
130298 | 130298 | 2020-05-10 | Randolph | Alabama | 1111 | 104 | 7 |
133288 | 133288 | 2020-05-11 | Randolph | Alabama | 1111 | 111 | 7 |
136278 | 136278 | 2020-05-12 | Randolph | Alabama | 1111 | 117 | 7 |
139269 | 139269 | 2020-05-13 | Randolph | Alabama | 1111 | 117 | 7 |
142265 | 142265 | 2020-05-14 | Randolph | Alabama | 1111 | 118 | 7 |
145264 | 145264 | 2020-05-15 | Randolph | Alabama | 1111 | 119 | 7 |
148267 | 148267 | 2020-05-16 | Randolph | Alabama | 1111 | 119 | 7 |
151276 | 151276 | 2020-05-17 | Randolph | Alabama | 1111 | 120 | 7 |
154288 | 154288 | 2020-05-18 | Randolph | Alabama | 1111 | 120 | 7 |
157304 | 157304 | 2020-05-19 | Randolph | Alabama | 1111 | 120 | 7 |
160328 | 160328 | 2020-05-20 | Randolph | Alabama | 1111 | 120 | 7 |
163356 | 163356 | 2020-05-21 | Randolph | Alabama | 1111 | 122 | 7 |
166388 | 166388 | 2020-05-22 | Randolph | Alabama | 1111 | 123 | 7 |
169424 | 169424 | 2020-05-23 | Randolph | Alabama | 1111 | 124 | 7 |
172465 | 172465 | 2020-05-24 | Randolph | Alabama | 1111 | 125 | 7 |
175508 | 175508 | 2020-05-25 | Randolph | Alabama | 1111 | 124 | 7 |
178553 | 178553 | 2020-05-26 | Randolph | Alabama | 1111 | 124 | 7 |
181597 | 181597 | 2020-05-27 | Randolph | Alabama | 1111 | 124 | 7 |
184649 | 184649 | 2020-05-28 | Randolph | Alabama | 1111 | 125 | 7 |
187706 | 187706 | 2020-05-29 | Randolph | Alabama | 1111 | 125 | 7 |
190770 | 190770 | 2020-05-30 | Randolph | Alabama | 1111 | 125 | 7 |
193836 | 193836 | 2020-05-31 | Randolph | Alabama | 1111 | 127 | 7 |
196906 | 196906 | 2020-06-01 | Randolph | Alabama | 1111 | 130 | 7 |
199979 | 199979 | 2020-06-02 | Randolph | Alabama | 1111 | 131 | 7 |
203055 | 203055 | 2020-06-03 | Randolph | Alabama | 1111 | 131 | 7 |
206134 | 206134 | 2020-06-04 | Randolph | Alabama | 1111 | 131 | 7 |
209216 | 209216 | 2020-06-05 | Randolph | Alabama | 1111 | 131 | 8 |
212301 | 212301 | 2020-06-06 | Randolph | Alabama | 1111 | 132 | 8 |
215388 | 215388 | 2020-06-07 | Randolph | Alabama | 1111 | 135 | 8 |
218478 | 218478 | 2020-06-08 | Randolph | Alabama | 1111 | 135 | 8 |
221570 | 221570 | 2020-06-09 | Randolph | Alabama | 1111 | 135 | 8 |
224666 | 224666 | 2020-06-10 | Randolph | Alabama | 1111 | 138 | 8 |
227767 | 227767 | 2020-06-11 | Randolph | Alabama | 1111 | 139 | 8 |
230871 | 230871 | 2020-06-12 | Randolph | Alabama | 1111 | 140 | 8 |
233976 | 233976 | 2020-06-13 | Randolph | Alabama | 1111 | 140 | 8 |
237083 | 237083 | 2020-06-14 | Randolph | Alabama | 1111 | 142 | 8 |
240191 | 240191 | 2020-06-15 | Randolph | Alabama | 1111 | 143 | 8 |
243302 | 243302 | 2020-06-16 | Randolph | Alabama | 1111 | 143 | 8 |
246415 | 246415 | 2020-06-17 | Randolph | Alabama | 1111 | 143 | 8 |
249527 | 249527 | 2020-06-18 | Randolph | Alabama | 1111 | 144 | 8 |
252642 | 252642 | 2020-06-19 | Randolph | Alabama | 1111 | 144 | 8 |
255761 | 255761 | 2020-06-20 | Randolph | Alabama | 1111 | 144 | 8 |
258888 | 258888 | 2020-06-21 | Randolph | Alabama | 1111 | 144 | 8 |
262015 | 262015 | 2020-06-22 | Randolph | Alabama | 1111 | 144 | 8 |
265144 | 265144 | 2020-06-23 | Randolph | Alabama | 1111 | 146 | 9 |
268273 | 268273 | 2020-06-24 | Randolph | Alabama | 1111 | 149 | 9 |
271407 | 271407 | 2020-06-25 | Randolph | Alabama | 1111 | 152 | 9 |
274547 | 274547 | 2020-06-26 | Randolph | Alabama | 1111 | 152 | 9 |
277695 | 277695 | 2020-06-27 | Randolph | Alabama | 1111 | 156 | 9 |
280843 | 280843 | 2020-06-28 | Randolph | Alabama | 1111 | 156 | 9 |
283989 | 283989 | 2020-06-29 | Randolph | Alabama | 1111 | 165 | 9 |
287135 | 287135 | 2020-06-30 | Randolph | Alabama | 1111 | 171 | 9 |
290285 | 290285 | 2020-07-01 | Randolph | Alabama | 1111 | 172 | 9 |
293438 | 293438 | 2020-07-02 | Randolph | Alabama | 1111 | 190 | 9 |
296593 | 296593 | 2020-07-03 | Randolph | Alabama | 1111 | 203 | 9 |
299755 | 299755 | 2020-07-04 | Randolph | Alabama | 1111 | 202 | 9 |
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);