ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Clay" and state = "Alabama" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10844 | 10844 | 2020-03-25 | Clay | Alabama | 1027 | 1 | 0 |
12378 | 12378 | 2020-03-26 | Clay | Alabama | 1027 | 1 | 0 |
14036 | 14036 | 2020-03-27 | Clay | Alabama | 1027 | 1 | 0 |
15814 | 15814 | 2020-03-28 | Clay | Alabama | 1027 | 2 | 0 |
17697 | 17697 | 2020-03-29 | Clay | Alabama | 1027 | 2 | 0 |
19667 | 19667 | 2020-03-30 | Clay | Alabama | 1027 | 2 | 0 |
21739 | 21739 | 2020-03-31 | Clay | Alabama | 1027 | 2 | 0 |
23893 | 23893 | 2020-04-01 | Clay | Alabama | 1027 | 3 | 0 |
26114 | 26114 | 2020-04-02 | Clay | Alabama | 1027 | 7 | 0 |
28410 | 28410 | 2020-04-03 | Clay | Alabama | 1027 | 8 | 0 |
30767 | 30767 | 2020-04-04 | Clay | Alabama | 1027 | 9 | 0 |
33171 | 33171 | 2020-04-05 | Clay | Alabama | 1027 | 9 | 0 |
35610 | 35610 | 2020-04-06 | Clay | Alabama | 1027 | 9 | 0 |
38098 | 38098 | 2020-04-07 | Clay | Alabama | 1027 | 9 | 0 |
40640 | 40640 | 2020-04-08 | Clay | Alabama | 1027 | 11 | 0 |
43213 | 43213 | 2020-04-09 | Clay | Alabama | 1027 | 11 | 0 |
45811 | 45811 | 2020-04-10 | Clay | Alabama | 1027 | 11 | 0 |
48440 | 48440 | 2020-04-11 | Clay | Alabama | 1027 | 12 | 0 |
51101 | 51101 | 2020-04-12 | Clay | Alabama | 1027 | 14 | 0 |
53779 | 53779 | 2020-04-13 | Clay | Alabama | 1027 | 14 | 0 |
56471 | 56471 | 2020-04-14 | Clay | Alabama | 1027 | 14 | 0 |
59179 | 59179 | 2020-04-15 | Clay | Alabama | 1027 | 14 | 0 |
61897 | 61897 | 2020-04-16 | Clay | Alabama | 1027 | 14 | 0 |
64630 | 64630 | 2020-04-17 | Clay | Alabama | 1027 | 14 | 0 |
67378 | 67378 | 2020-04-18 | Clay | Alabama | 1027 | 17 | 0 |
70140 | 70140 | 2020-04-19 | Clay | Alabama | 1027 | 18 | 0 |
72909 | 72909 | 2020-04-20 | Clay | Alabama | 1027 | 19 | 0 |
75685 | 75685 | 2020-04-21 | Clay | Alabama | 1027 | 19 | 0 |
78468 | 78468 | 2020-04-22 | Clay | Alabama | 1027 | 19 | 0 |
81261 | 81261 | 2020-04-23 | Clay | Alabama | 1027 | 19 | 1 |
84062 | 84062 | 2020-04-24 | Clay | Alabama | 1027 | 19 | 1 |
86870 | 86870 | 2020-04-25 | Clay | Alabama | 1027 | 19 | 1 |
89686 | 89686 | 2020-04-26 | Clay | Alabama | 1027 | 19 | 1 |
92504 | 92504 | 2020-04-27 | Clay | Alabama | 1027 | 19 | 1 |
95334 | 95334 | 2020-04-28 | Clay | Alabama | 1027 | 19 | 1 |
98179 | 98179 | 2020-04-29 | Clay | Alabama | 1027 | 21 | 1 |
101029 | 101029 | 2020-04-30 | Clay | Alabama | 1027 | 21 | 1 |
103884 | 103884 | 2020-05-01 | Clay | Alabama | 1027 | 21 | 1 |
106749 | 106749 | 2020-05-02 | Clay | Alabama | 1027 | 21 | 1 |
109618 | 109618 | 2020-05-03 | Clay | Alabama | 1027 | 22 | 1 |
112493 | 112493 | 2020-05-04 | Clay | Alabama | 1027 | 22 | 1 |
115376 | 115376 | 2020-05-05 | Clay | Alabama | 1027 | 24 | 1 |
118335 | 118335 | 2020-05-06 | Clay | Alabama | 1027 | 25 | 1 |
121301 | 121301 | 2020-05-07 | Clay | Alabama | 1027 | 25 | 1 |
124281 | 124281 | 2020-05-08 | Clay | Alabama | 1027 | 26 | 1 |
127266 | 127266 | 2020-05-09 | Clay | Alabama | 1027 | 26 | 1 |
130256 | 130256 | 2020-05-10 | Clay | Alabama | 1027 | 26 | 1 |
133246 | 133246 | 2020-05-11 | Clay | Alabama | 1027 | 27 | 1 |
136236 | 136236 | 2020-05-12 | Clay | Alabama | 1027 | 27 | 1 |
139227 | 139227 | 2020-05-13 | Clay | Alabama | 1027 | 27 | 1 |
142223 | 142223 | 2020-05-14 | Clay | Alabama | 1027 | 27 | 2 |
145222 | 145222 | 2020-05-15 | Clay | Alabama | 1027 | 27 | 2 |
148225 | 148225 | 2020-05-16 | Clay | Alabama | 1027 | 27 | 2 |
151234 | 151234 | 2020-05-17 | Clay | Alabama | 1027 | 27 | 2 |
154246 | 154246 | 2020-05-18 | Clay | Alabama | 1027 | 27 | 2 |
157262 | 157262 | 2020-05-19 | Clay | Alabama | 1027 | 27 | 2 |
160286 | 160286 | 2020-05-20 | Clay | Alabama | 1027 | 27 | 2 |
163314 | 163314 | 2020-05-21 | Clay | Alabama | 1027 | 27 | 2 |
166346 | 166346 | 2020-05-22 | Clay | Alabama | 1027 | 27 | 2 |
169382 | 169382 | 2020-05-23 | Clay | Alabama | 1027 | 27 | 2 |
172423 | 172423 | 2020-05-24 | Clay | Alabama | 1027 | 27 | 2 |
175466 | 175466 | 2020-05-25 | Clay | Alabama | 1027 | 27 | 2 |
178511 | 178511 | 2020-05-26 | Clay | Alabama | 1027 | 27 | 2 |
181555 | 181555 | 2020-05-27 | Clay | Alabama | 1027 | 27 | 2 |
184607 | 184607 | 2020-05-28 | Clay | Alabama | 1027 | 27 | 2 |
187664 | 187664 | 2020-05-29 | Clay | Alabama | 1027 | 27 | 2 |
190728 | 190728 | 2020-05-30 | Clay | Alabama | 1027 | 27 | 2 |
193794 | 193794 | 2020-05-31 | Clay | Alabama | 1027 | 27 | 2 |
196864 | 196864 | 2020-06-01 | Clay | Alabama | 1027 | 28 | 2 |
199937 | 199937 | 2020-06-02 | Clay | Alabama | 1027 | 28 | 2 |
203013 | 203013 | 2020-06-03 | Clay | Alabama | 1027 | 28 | 2 |
206092 | 206092 | 2020-06-04 | Clay | Alabama | 1027 | 28 | 2 |
209174 | 209174 | 2020-06-05 | Clay | Alabama | 1027 | 28 | 2 |
212259 | 212259 | 2020-06-06 | Clay | Alabama | 1027 | 29 | 2 |
215346 | 215346 | 2020-06-07 | Clay | Alabama | 1027 | 29 | 2 |
218436 | 218436 | 2020-06-08 | Clay | Alabama | 1027 | 29 | 2 |
221528 | 221528 | 2020-06-09 | Clay | Alabama | 1027 | 30 | 2 |
224624 | 224624 | 2020-06-10 | Clay | Alabama | 1027 | 30 | 2 |
227725 | 227725 | 2020-06-11 | Clay | Alabama | 1027 | 30 | 2 |
230829 | 230829 | 2020-06-12 | Clay | Alabama | 1027 | 30 | 2 |
233934 | 233934 | 2020-06-13 | Clay | Alabama | 1027 | 30 | 2 |
237041 | 237041 | 2020-06-14 | Clay | Alabama | 1027 | 30 | 2 |
240149 | 240149 | 2020-06-15 | Clay | Alabama | 1027 | 30 | 2 |
243260 | 243260 | 2020-06-16 | Clay | Alabama | 1027 | 30 | 2 |
246373 | 246373 | 2020-06-17 | Clay | Alabama | 1027 | 30 | 2 |
249485 | 249485 | 2020-06-18 | Clay | Alabama | 1027 | 30 | 2 |
252600 | 252600 | 2020-06-19 | Clay | Alabama | 1027 | 30 | 2 |
255719 | 255719 | 2020-06-20 | Clay | Alabama | 1027 | 31 | 2 |
258846 | 258846 | 2020-06-21 | Clay | Alabama | 1027 | 32 | 2 |
261973 | 261973 | 2020-06-22 | Clay | Alabama | 1027 | 33 | 2 |
265102 | 265102 | 2020-06-23 | Clay | Alabama | 1027 | 34 | 2 |
268231 | 268231 | 2020-06-24 | Clay | Alabama | 1027 | 34 | 2 |
271365 | 271365 | 2020-06-25 | Clay | Alabama | 1027 | 35 | 2 |
274505 | 274505 | 2020-06-26 | Clay | Alabama | 1027 | 35 | 2 |
277653 | 277653 | 2020-06-27 | Clay | Alabama | 1027 | 35 | 2 |
280801 | 280801 | 2020-06-28 | Clay | Alabama | 1027 | 35 | 2 |
283947 | 283947 | 2020-06-29 | Clay | Alabama | 1027 | 48 | 2 |
287093 | 287093 | 2020-06-30 | Clay | Alabama | 1027 | 53 | 2 |
290243 | 290243 | 2020-07-01 | Clay | Alabama | 1027 | 58 | 2 |
293396 | 293396 | 2020-07-02 | Clay | Alabama | 1027 | 61 | 2 |
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);