ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Geneva" and state = "Alabama" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
51118 | 51118 | 2020-04-12 | Geneva | Alabama | 1061 | 1 | 0 |
53796 | 53796 | 2020-04-13 | Geneva | Alabama | 1061 | 1 | 0 |
56488 | 56488 | 2020-04-14 | Geneva | Alabama | 1061 | 1 | 0 |
59196 | 59196 | 2020-04-15 | Geneva | Alabama | 1061 | 2 | 0 |
61914 | 61914 | 2020-04-16 | Geneva | Alabama | 1061 | 2 | 0 |
64647 | 64647 | 2020-04-17 | Geneva | Alabama | 1061 | 2 | 0 |
67395 | 67395 | 2020-04-18 | Geneva | Alabama | 1061 | 4 | 0 |
70157 | 70157 | 2020-04-19 | Geneva | Alabama | 1061 | 4 | 0 |
72926 | 72926 | 2020-04-20 | Geneva | Alabama | 1061 | 4 | 0 |
75702 | 75702 | 2020-04-21 | Geneva | Alabama | 1061 | 4 | 0 |
78485 | 78485 | 2020-04-22 | Geneva | Alabama | 1061 | 5 | 0 |
81278 | 81278 | 2020-04-23 | Geneva | Alabama | 1061 | 6 | 0 |
84079 | 84079 | 2020-04-24 | Geneva | Alabama | 1061 | 6 | 0 |
86887 | 86887 | 2020-04-25 | Geneva | Alabama | 1061 | 7 | 0 |
89703 | 89703 | 2020-04-26 | Geneva | Alabama | 1061 | 8 | 0 |
92521 | 92521 | 2020-04-27 | Geneva | Alabama | 1061 | 8 | 0 |
95351 | 95351 | 2020-04-28 | Geneva | Alabama | 1061 | 8 | 0 |
98196 | 98196 | 2020-04-29 | Geneva | Alabama | 1061 | 9 | 0 |
101046 | 101046 | 2020-04-30 | Geneva | Alabama | 1061 | 9 | 0 |
103901 | 103901 | 2020-05-01 | Geneva | Alabama | 1061 | 9 | 0 |
106766 | 106766 | 2020-05-02 | Geneva | Alabama | 1061 | 10 | 0 |
109635 | 109635 | 2020-05-03 | Geneva | Alabama | 1061 | 10 | 0 |
112510 | 112510 | 2020-05-04 | Geneva | Alabama | 1061 | 11 | 0 |
115393 | 115393 | 2020-05-05 | Geneva | Alabama | 1061 | 11 | 0 |
118352 | 118352 | 2020-05-06 | Geneva | Alabama | 1061 | 11 | 0 |
121318 | 121318 | 2020-05-07 | Geneva | Alabama | 1061 | 11 | 0 |
124298 | 124298 | 2020-05-08 | Geneva | Alabama | 1061 | 12 | 0 |
127283 | 127283 | 2020-05-09 | Geneva | Alabama | 1061 | 13 | 0 |
130273 | 130273 | 2020-05-10 | Geneva | Alabama | 1061 | 13 | 0 |
133263 | 133263 | 2020-05-11 | Geneva | Alabama | 1061 | 15 | 0 |
136253 | 136253 | 2020-05-12 | Geneva | Alabama | 1061 | 16 | 0 |
139244 | 139244 | 2020-05-13 | Geneva | Alabama | 1061 | 17 | 0 |
142240 | 142240 | 2020-05-14 | Geneva | Alabama | 1061 | 18 | 0 |
145239 | 145239 | 2020-05-15 | Geneva | Alabama | 1061 | 19 | 0 |
148242 | 148242 | 2020-05-16 | Geneva | Alabama | 1061 | 20 | 0 |
151251 | 151251 | 2020-05-17 | Geneva | Alabama | 1061 | 20 | 0 |
154263 | 154263 | 2020-05-18 | Geneva | Alabama | 1061 | 22 | 0 |
157279 | 157279 | 2020-05-19 | Geneva | Alabama | 1061 | 23 | 0 |
160303 | 160303 | 2020-05-20 | Geneva | Alabama | 1061 | 26 | 0 |
163331 | 163331 | 2020-05-21 | Geneva | Alabama | 1061 | 28 | 0 |
166363 | 166363 | 2020-05-22 | Geneva | Alabama | 1061 | 28 | 0 |
169399 | 169399 | 2020-05-23 | Geneva | Alabama | 1061 | 31 | 0 |
172440 | 172440 | 2020-05-24 | Geneva | Alabama | 1061 | 33 | 0 |
175483 | 175483 | 2020-05-25 | Geneva | Alabama | 1061 | 35 | 0 |
187681 | 187681 | 2020-05-29 | Geneva | Alabama | 1061 | 39 | 0 |
178528 | 178528 | 2020-05-26 | Geneva | Alabama | 1061 | 40 | 0 |
181572 | 181572 | 2020-05-27 | Geneva | Alabama | 1061 | 40 | 0 |
184624 | 184624 | 2020-05-28 | Geneva | Alabama | 1061 | 40 | 0 |
190745 | 190745 | 2020-05-30 | Geneva | Alabama | 1061 | 40 | 0 |
193811 | 193811 | 2020-05-31 | Geneva | Alabama | 1061 | 43 | 0 |
196881 | 196881 | 2020-06-01 | Geneva | Alabama | 1061 | 43 | 0 |
199954 | 199954 | 2020-06-02 | Geneva | Alabama | 1061 | 43 | 0 |
203030 | 203030 | 2020-06-03 | Geneva | Alabama | 1061 | 44 | 0 |
206109 | 206109 | 2020-06-04 | Geneva | Alabama | 1061 | 44 | 0 |
209191 | 209191 | 2020-06-05 | Geneva | Alabama | 1061 | 45 | 0 |
212276 | 212276 | 2020-06-06 | Geneva | Alabama | 1061 | 46 | 0 |
215363 | 215363 | 2020-06-07 | Geneva | Alabama | 1061 | 46 | 0 |
218453 | 218453 | 2020-06-08 | Geneva | Alabama | 1061 | 46 | 0 |
221545 | 221545 | 2020-06-09 | Geneva | Alabama | 1061 | 46 | 0 |
224641 | 224641 | 2020-06-10 | Geneva | Alabama | 1061 | 46 | 0 |
227742 | 227742 | 2020-06-11 | Geneva | Alabama | 1061 | 46 | 0 |
230846 | 230846 | 2020-06-12 | Geneva | Alabama | 1061 | 46 | 0 |
233951 | 233951 | 2020-06-13 | Geneva | Alabama | 1061 | 46 | 0 |
237058 | 237058 | 2020-06-14 | Geneva | Alabama | 1061 | 46 | 0 |
240166 | 240166 | 2020-06-15 | Geneva | Alabama | 1061 | 46 | 0 |
243277 | 243277 | 2020-06-16 | Geneva | Alabama | 1061 | 48 | 0 |
246390 | 246390 | 2020-06-17 | Geneva | Alabama | 1061 | 48 | 0 |
249502 | 249502 | 2020-06-18 | Geneva | Alabama | 1061 | 49 | 0 |
252617 | 252617 | 2020-06-19 | Geneva | Alabama | 1061 | 49 | 0 |
255736 | 255736 | 2020-06-20 | Geneva | Alabama | 1061 | 51 | 0 |
258863 | 258863 | 2020-06-21 | Geneva | Alabama | 1061 | 51 | 0 |
261990 | 261990 | 2020-06-22 | Geneva | Alabama | 1061 | 51 | 0 |
265119 | 265119 | 2020-06-23 | Geneva | Alabama | 1061 | 51 | 0 |
268248 | 268248 | 2020-06-24 | Geneva | Alabama | 1061 | 53 | 0 |
271382 | 271382 | 2020-06-25 | Geneva | Alabama | 1061 | 55 | 0 |
274522 | 274522 | 2020-06-26 | Geneva | Alabama | 1061 | 59 | 0 |
283964 | 283964 | 2020-06-29 | Geneva | Alabama | 1061 | 59 | 0 |
277670 | 277670 | 2020-06-27 | Geneva | Alabama | 1061 | 60 | 0 |
280818 | 280818 | 2020-06-28 | Geneva | Alabama | 1061 | 60 | 0 |
287110 | 287110 | 2020-06-30 | Geneva | Alabama | 1061 | 63 | 0 |
290260 | 290260 | 2020-07-01 | Geneva | Alabama | 1061 | 67 | 0 |
293413 | 293413 | 2020-07-02 | Geneva | Alabama | 1061 | 70 | 0 |
296568 | 296568 | 2020-07-03 | Geneva | Alabama | 1061 | 78 | 0 |
299730 | 299730 | 2020-07-04 | Geneva | Alabama | 1061 | 79 | 0 |
302894 | 302894 | 2020-07-05 | Geneva | Alabama | 1061 | 80 | 0 |
306058 | 306058 | 2020-07-06 | Geneva | Alabama | 1061 | 83 | 0 |
309227 | 309227 | 2020-07-07 | Geneva | Alabama | 1061 | 84 | 0 |
312396 | 312396 | 2020-07-08 | Geneva | Alabama | 1061 | 86 | 0 |
315571 | 315571 | 2020-07-09 | Geneva | Alabama | 1061 | 92 | 0 |
318744 | 318744 | 2020-07-10 | Geneva | Alabama | 1061 | 95 | 0 |
321923 | 321923 | 2020-07-11 | Geneva | Alabama | 1061 | 96 | 0 |
325104 | 325104 | 2020-07-12 | Geneva | Alabama | 1061 | 98 | 0 |
328290 | 328290 | 2020-07-13 | Geneva | Alabama | 1061 | 101 | 0 |
331476 | 331476 | 2020-07-14 | Geneva | Alabama | 1061 | 106 | 0 |
334669 | 334669 | 2020-07-15 | Geneva | Alabama | 1061 | 110 | 0 |
337864 | 337864 | 2020-07-16 | Geneva | Alabama | 1061 | 113 | 0 |
341060 | 341060 | 2020-07-17 | Geneva | Alabama | 1061 | 118 | 0 |
344259 | 344259 | 2020-07-18 | Geneva | Alabama | 1061 | 135 | 0 |
347459 | 347459 | 2020-07-19 | Geneva | Alabama | 1061 | 144 | 0 |
350660 | 350660 | 2020-07-20 | Geneva | Alabama | 1061 | 148 | 1 |
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);