ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Clarke" and fips = 1025 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23892 | 23892 | 2020-04-01 | Clarke | Alabama | 1025 | 2 | 0 |
26113 | 26113 | 2020-04-02 | Clarke | Alabama | 1025 | 2 | 0 |
28409 | 28409 | 2020-04-03 | Clarke | Alabama | 1025 | 3 | 0 |
30766 | 30766 | 2020-04-04 | Clarke | Alabama | 1025 | 7 | 0 |
33170 | 33170 | 2020-04-05 | Clarke | Alabama | 1025 | 9 | 0 |
35609 | 35609 | 2020-04-06 | Clarke | Alabama | 1025 | 9 | 0 |
38097 | 38097 | 2020-04-07 | Clarke | Alabama | 1025 | 10 | 0 |
40639 | 40639 | 2020-04-08 | Clarke | Alabama | 1025 | 10 | 0 |
43212 | 43212 | 2020-04-09 | Clarke | Alabama | 1025 | 13 | 0 |
45810 | 45810 | 2020-04-10 | Clarke | Alabama | 1025 | 13 | 0 |
48439 | 48439 | 2020-04-11 | Clarke | Alabama | 1025 | 15 | 0 |
51100 | 51100 | 2020-04-12 | Clarke | Alabama | 1025 | 19 | 0 |
53778 | 53778 | 2020-04-13 | Clarke | Alabama | 1025 | 19 | 0 |
56470 | 56470 | 2020-04-14 | Clarke | Alabama | 1025 | 21 | 0 |
59178 | 59178 | 2020-04-15 | Clarke | Alabama | 1025 | 22 | 0 |
61896 | 61896 | 2020-04-16 | Clarke | Alabama | 1025 | 24 | 0 |
64629 | 64629 | 2020-04-17 | Clarke | Alabama | 1025 | 24 | 0 |
67377 | 67377 | 2020-04-18 | Clarke | Alabama | 1025 | 24 | 0 |
70139 | 70139 | 2020-04-19 | Clarke | Alabama | 1025 | 24 | 0 |
72908 | 72908 | 2020-04-20 | Clarke | Alabama | 1025 | 24 | 1 |
75684 | 75684 | 2020-04-21 | Clarke | Alabama | 1025 | 24 | 1 |
78467 | 78467 | 2020-04-22 | Clarke | Alabama | 1025 | 25 | 1 |
81260 | 81260 | 2020-04-23 | Clarke | Alabama | 1025 | 25 | 1 |
84061 | 84061 | 2020-04-24 | Clarke | Alabama | 1025 | 24 | 1 |
86869 | 86869 | 2020-04-25 | Clarke | Alabama | 1025 | 25 | 1 |
89685 | 89685 | 2020-04-26 | Clarke | Alabama | 1025 | 25 | 1 |
92503 | 92503 | 2020-04-27 | Clarke | Alabama | 1025 | 27 | 1 |
95333 | 95333 | 2020-04-28 | Clarke | Alabama | 1025 | 28 | 1 |
98178 | 98178 | 2020-04-29 | Clarke | Alabama | 1025 | 31 | 1 |
101028 | 101028 | 2020-04-30 | Clarke | Alabama | 1025 | 32 | 1 |
103883 | 103883 | 2020-05-01 | Clarke | Alabama | 1025 | 34 | 1 |
106748 | 106748 | 2020-05-02 | Clarke | Alabama | 1025 | 38 | 1 |
109617 | 109617 | 2020-05-03 | Clarke | Alabama | 1025 | 42 | 1 |
112492 | 112492 | 2020-05-04 | Clarke | Alabama | 1025 | 43 | 1 |
115375 | 115375 | 2020-05-05 | Clarke | Alabama | 1025 | 43 | 1 |
118334 | 118334 | 2020-05-06 | Clarke | Alabama | 1025 | 45 | 1 |
121300 | 121300 | 2020-05-07 | Clarke | Alabama | 1025 | 50 | 1 |
124280 | 124280 | 2020-05-08 | Clarke | Alabama | 1025 | 53 | 1 |
127265 | 127265 | 2020-05-09 | Clarke | Alabama | 1025 | 52 | 1 |
130255 | 130255 | 2020-05-10 | Clarke | Alabama | 1025 | 56 | 1 |
133245 | 133245 | 2020-05-11 | Clarke | Alabama | 1025 | 63 | 1 |
136235 | 136235 | 2020-05-12 | Clarke | Alabama | 1025 | 64 | 1 |
139226 | 139226 | 2020-05-13 | Clarke | Alabama | 1025 | 65 | 1 |
142222 | 142222 | 2020-05-14 | Clarke | Alabama | 1025 | 68 | 2 |
145221 | 145221 | 2020-05-15 | Clarke | Alabama | 1025 | 70 | 2 |
148224 | 148224 | 2020-05-16 | Clarke | Alabama | 1025 | 74 | 2 |
151233 | 151233 | 2020-05-17 | Clarke | Alabama | 1025 | 74 | 2 |
154245 | 154245 | 2020-05-18 | Clarke | Alabama | 1025 | 75 | 2 |
157261 | 157261 | 2020-05-19 | Clarke | Alabama | 1025 | 81 | 2 |
160285 | 160285 | 2020-05-20 | Clarke | Alabama | 1025 | 89 | 2 |
163313 | 163313 | 2020-05-21 | Clarke | Alabama | 1025 | 91 | 2 |
166345 | 166345 | 2020-05-22 | Clarke | Alabama | 1025 | 92 | 2 |
169381 | 169381 | 2020-05-23 | Clarke | Alabama | 1025 | 97 | 2 |
172422 | 172422 | 2020-05-24 | Clarke | Alabama | 1025 | 102 | 2 |
175465 | 175465 | 2020-05-25 | Clarke | Alabama | 1025 | 109 | 2 |
178510 | 178510 | 2020-05-26 | Clarke | Alabama | 1025 | 120 | 2 |
181554 | 181554 | 2020-05-27 | Clarke | Alabama | 1025 | 128 | 2 |
184606 | 184606 | 2020-05-28 | Clarke | Alabama | 1025 | 129 | 2 |
187663 | 187663 | 2020-05-29 | Clarke | Alabama | 1025 | 134 | 2 |
190727 | 190727 | 2020-05-30 | Clarke | Alabama | 1025 | 142 | 2 |
193793 | 193793 | 2020-05-31 | Clarke | Alabama | 1025 | 144 | 2 |
196863 | 196863 | 2020-06-01 | Clarke | Alabama | 1025 | 147 | 2 |
199936 | 199936 | 2020-06-02 | Clarke | Alabama | 1025 | 149 | 2 |
203012 | 203012 | 2020-06-03 | Clarke | Alabama | 1025 | 150 | 2 |
206091 | 206091 | 2020-06-04 | Clarke | Alabama | 1025 | 150 | 2 |
209173 | 209173 | 2020-06-05 | Clarke | Alabama | 1025 | 150 | 2 |
212258 | 212258 | 2020-06-06 | Clarke | Alabama | 1025 | 152 | 2 |
215345 | 215345 | 2020-06-07 | Clarke | Alabama | 1025 | 157 | 2 |
218435 | 218435 | 2020-06-08 | Clarke | Alabama | 1025 | 159 | 3 |
221527 | 221527 | 2020-06-09 | Clarke | Alabama | 1025 | 162 | 3 |
224623 | 224623 | 2020-06-10 | Clarke | Alabama | 1025 | 164 | 3 |
227724 | 227724 | 2020-06-11 | Clarke | Alabama | 1025 | 166 | 3 |
230828 | 230828 | 2020-06-12 | Clarke | Alabama | 1025 | 176 | 3 |
233933 | 233933 | 2020-06-13 | Clarke | Alabama | 1025 | 180 | 3 |
237040 | 237040 | 2020-06-14 | Clarke | Alabama | 1025 | 189 | 3 |
240148 | 240148 | 2020-06-15 | Clarke | Alabama | 1025 | 192 | 3 |
243259 | 243259 | 2020-06-16 | Clarke | Alabama | 1025 | 195 | 3 |
246372 | 246372 | 2020-06-17 | Clarke | Alabama | 1025 | 198 | 3 |
249484 | 249484 | 2020-06-18 | Clarke | Alabama | 1025 | 202 | 4 |
252599 | 252599 | 2020-06-19 | Clarke | Alabama | 1025 | 209 | 4 |
255718 | 255718 | 2020-06-20 | Clarke | Alabama | 1025 | 214 | 4 |
258845 | 258845 | 2020-06-21 | Clarke | Alabama | 1025 | 216 | 4 |
261972 | 261972 | 2020-06-22 | Clarke | Alabama | 1025 | 218 | 5 |
265101 | 265101 | 2020-06-23 | Clarke | Alabama | 1025 | 222 | 4 |
268230 | 268230 | 2020-06-24 | Clarke | Alabama | 1025 | 231 | 5 |
271364 | 271364 | 2020-06-25 | Clarke | Alabama | 1025 | 244 | 5 |
274504 | 274504 | 2020-06-26 | Clarke | Alabama | 1025 | 253 | 5 |
277652 | 277652 | 2020-06-27 | Clarke | Alabama | 1025 | 257 | 5 |
280800 | 280800 | 2020-06-28 | Clarke | Alabama | 1025 | 257 | 5 |
283946 | 283946 | 2020-06-29 | Clarke | Alabama | 1025 | 262 | 5 |
287092 | 287092 | 2020-06-30 | Clarke | Alabama | 1025 | 265 | 5 |
290242 | 290242 | 2020-07-01 | Clarke | Alabama | 1025 | 267 | 5 |
293395 | 293395 | 2020-07-02 | Clarke | Alabama | 1025 | 269 | 6 |
296550 | 296550 | 2020-07-03 | Clarke | Alabama | 1025 | 273 | 6 |
299712 | 299712 | 2020-07-04 | Clarke | Alabama | 1025 | 274 | 6 |
302876 | 302876 | 2020-07-05 | Clarke | Alabama | 1025 | 275 | 6 |
306040 | 306040 | 2020-07-06 | Clarke | Alabama | 1025 | 278 | 6 |
309209 | 309209 | 2020-07-07 | Clarke | Alabama | 1025 | 284 | 6 |
312378 | 312378 | 2020-07-08 | Clarke | Alabama | 1025 | 288 | 6 |
315553 | 315553 | 2020-07-09 | Clarke | Alabama | 1025 | 295 | 6 |
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);