ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Macon" and state = "Alabama" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
17720 | 17720 | 2020-03-29 | Macon | Alabama | 1087 | 1 | 0 |
19692 | 19692 | 2020-03-30 | Macon | Alabama | 1087 | 1 | 0 |
21764 | 21764 | 2020-03-31 | Macon | Alabama | 1087 | 1 | 0 |
23920 | 23920 | 2020-04-01 | Macon | Alabama | 1087 | 2 | 0 |
26142 | 26142 | 2020-04-02 | Macon | Alabama | 1087 | 4 | 0 |
28439 | 28439 | 2020-04-03 | Macon | Alabama | 1087 | 5 | 0 |
30796 | 30796 | 2020-04-04 | Macon | Alabama | 1087 | 5 | 0 |
33200 | 33200 | 2020-04-05 | Macon | Alabama | 1087 | 5 | 0 |
35639 | 35639 | 2020-04-06 | Macon | Alabama | 1087 | 5 | 1 |
38127 | 38127 | 2020-04-07 | Macon | Alabama | 1087 | 6 | 1 |
40669 | 40669 | 2020-04-08 | Macon | Alabama | 1087 | 6 | 1 |
43242 | 43242 | 2020-04-09 | Macon | Alabama | 1087 | 9 | 1 |
45840 | 45840 | 2020-04-10 | Macon | Alabama | 1087 | 9 | 1 |
48469 | 48469 | 2020-04-11 | Macon | Alabama | 1087 | 12 | 1 |
51131 | 51131 | 2020-04-12 | Macon | Alabama | 1087 | 14 | 1 |
53809 | 53809 | 2020-04-13 | Macon | Alabama | 1087 | 17 | 1 |
56501 | 56501 | 2020-04-14 | Macon | Alabama | 1087 | 19 | 2 |
59209 | 59209 | 2020-04-15 | Macon | Alabama | 1087 | 19 | 2 |
61927 | 61927 | 2020-04-16 | Macon | Alabama | 1087 | 24 | 2 |
64660 | 64660 | 2020-04-17 | Macon | Alabama | 1087 | 24 | 2 |
67408 | 67408 | 2020-04-18 | Macon | Alabama | 1087 | 24 | 2 |
70170 | 70170 | 2020-04-19 | Macon | Alabama | 1087 | 25 | 2 |
72939 | 72939 | 2020-04-20 | Macon | Alabama | 1087 | 26 | 2 |
75715 | 75715 | 2020-04-21 | Macon | Alabama | 1087 | 27 | 2 |
78498 | 78498 | 2020-04-22 | Macon | Alabama | 1087 | 27 | 2 |
81291 | 81291 | 2020-04-23 | Macon | Alabama | 1087 | 27 | 2 |
84092 | 84092 | 2020-04-24 | Macon | Alabama | 1087 | 29 | 2 |
86900 | 86900 | 2020-04-25 | Macon | Alabama | 1087 | 31 | 2 |
89716 | 89716 | 2020-04-26 | Macon | Alabama | 1087 | 34 | 2 |
92534 | 92534 | 2020-04-27 | Macon | Alabama | 1087 | 34 | 2 |
95364 | 95364 | 2020-04-28 | Macon | Alabama | 1087 | 35 | 2 |
98209 | 98209 | 2020-04-29 | Macon | Alabama | 1087 | 36 | 2 |
101059 | 101059 | 2020-04-30 | Macon | Alabama | 1087 | 37 | 2 |
103914 | 103914 | 2020-05-01 | Macon | Alabama | 1087 | 37 | 2 |
106779 | 106779 | 2020-05-02 | Macon | Alabama | 1087 | 38 | 2 |
109648 | 109648 | 2020-05-03 | Macon | Alabama | 1087 | 40 | 2 |
112523 | 112523 | 2020-05-04 | Macon | Alabama | 1087 | 40 | 2 |
115406 | 115406 | 2020-05-05 | Macon | Alabama | 1087 | 41 | 2 |
118365 | 118365 | 2020-05-06 | Macon | Alabama | 1087 | 42 | 2 |
121331 | 121331 | 2020-05-07 | Macon | Alabama | 1087 | 43 | 2 |
124311 | 124311 | 2020-05-08 | Macon | Alabama | 1087 | 44 | 2 |
127296 | 127296 | 2020-05-09 | Macon | Alabama | 1087 | 47 | 2 |
130286 | 130286 | 2020-05-10 | Macon | Alabama | 1087 | 47 | 2 |
133276 | 133276 | 2020-05-11 | Macon | Alabama | 1087 | 49 | 2 |
136266 | 136266 | 2020-05-12 | Macon | Alabama | 1087 | 51 | 2 |
139257 | 139257 | 2020-05-13 | Macon | Alabama | 1087 | 53 | 2 |
142253 | 142253 | 2020-05-14 | Macon | Alabama | 1087 | 53 | 2 |
157292 | 157292 | 2020-05-19 | Macon | Alabama | 1087 | 54 | 2 |
145252 | 145252 | 2020-05-15 | Macon | Alabama | 1087 | 55 | 2 |
148255 | 148255 | 2020-05-16 | Macon | Alabama | 1087 | 55 | 2 |
151264 | 151264 | 2020-05-17 | Macon | Alabama | 1087 | 55 | 2 |
154276 | 154276 | 2020-05-18 | Macon | Alabama | 1087 | 55 | 2 |
160316 | 160316 | 2020-05-20 | Macon | Alabama | 1087 | 58 | 2 |
163344 | 163344 | 2020-05-21 | Macon | Alabama | 1087 | 58 | 2 |
166376 | 166376 | 2020-05-22 | Macon | Alabama | 1087 | 58 | 2 |
169412 | 169412 | 2020-05-23 | Macon | Alabama | 1087 | 59 | 2 |
172453 | 172453 | 2020-05-24 | Macon | Alabama | 1087 | 60 | 2 |
175496 | 175496 | 2020-05-25 | Macon | Alabama | 1087 | 62 | 2 |
178541 | 178541 | 2020-05-26 | Macon | Alabama | 1087 | 65 | 2 |
181585 | 181585 | 2020-05-27 | Macon | Alabama | 1087 | 67 | 2 |
184637 | 184637 | 2020-05-28 | Macon | Alabama | 1087 | 71 | 2 |
187694 | 187694 | 2020-05-29 | Macon | Alabama | 1087 | 72 | 3 |
190758 | 190758 | 2020-05-30 | Macon | Alabama | 1087 | 75 | 4 |
193824 | 193824 | 2020-05-31 | Macon | Alabama | 1087 | 82 | 4 |
196894 | 196894 | 2020-06-01 | Macon | Alabama | 1087 | 86 | 4 |
199967 | 199967 | 2020-06-02 | Macon | Alabama | 1087 | 87 | 4 |
203043 | 203043 | 2020-06-03 | Macon | Alabama | 1087 | 88 | 4 |
206122 | 206122 | 2020-06-04 | Macon | Alabama | 1087 | 94 | 4 |
209204 | 209204 | 2020-06-05 | Macon | Alabama | 1087 | 95 | 4 |
212289 | 212289 | 2020-06-06 | Macon | Alabama | 1087 | 97 | 5 |
215376 | 215376 | 2020-06-07 | Macon | Alabama | 1087 | 99 | 5 |
218466 | 218466 | 2020-06-08 | Macon | Alabama | 1087 | 101 | 5 |
221558 | 221558 | 2020-06-09 | Macon | Alabama | 1087 | 105 | 5 |
224654 | 224654 | 2020-06-10 | Macon | Alabama | 1087 | 106 | 5 |
227755 | 227755 | 2020-06-11 | Macon | Alabama | 1087 | 111 | 5 |
230859 | 230859 | 2020-06-12 | Macon | Alabama | 1087 | 118 | 5 |
233964 | 233964 | 2020-06-13 | Macon | Alabama | 1087 | 123 | 6 |
237071 | 237071 | 2020-06-14 | Macon | Alabama | 1087 | 126 | 6 |
240179 | 240179 | 2020-06-15 | Macon | Alabama | 1087 | 127 | 6 |
243290 | 243290 | 2020-06-16 | Macon | Alabama | 1087 | 133 | 6 |
246403 | 246403 | 2020-06-17 | Macon | Alabama | 1087 | 134 | 6 |
249515 | 249515 | 2020-06-18 | Macon | Alabama | 1087 | 138 | 6 |
252630 | 252630 | 2020-06-19 | Macon | Alabama | 1087 | 140 | 6 |
255749 | 255749 | 2020-06-20 | Macon | Alabama | 1087 | 146 | 6 |
258876 | 258876 | 2020-06-21 | Macon | Alabama | 1087 | 149 | 6 |
265132 | 265132 | 2020-06-23 | Macon | Alabama | 1087 | 149 | 7 |
262003 | 262003 | 2020-06-22 | Macon | Alabama | 1087 | 150 | 6 |
268261 | 268261 | 2020-06-24 | Macon | Alabama | 1087 | 152 | 7 |
271395 | 271395 | 2020-06-25 | Macon | Alabama | 1087 | 155 | 7 |
274535 | 274535 | 2020-06-26 | Macon | Alabama | 1087 | 161 | 7 |
277683 | 277683 | 2020-06-27 | Macon | Alabama | 1087 | 162 | 7 |
280831 | 280831 | 2020-06-28 | Macon | Alabama | 1087 | 163 | 7 |
283977 | 283977 | 2020-06-29 | Macon | Alabama | 1087 | 167 | 8 |
287123 | 287123 | 2020-06-30 | Macon | Alabama | 1087 | 168 | 8 |
290273 | 290273 | 2020-07-01 | Macon | Alabama | 1087 | 172 | 8 |
293426 | 293426 | 2020-07-02 | Macon | Alabama | 1087 | 179 | 8 |
296581 | 296581 | 2020-07-03 | Macon | Alabama | 1087 | 185 | 9 |
299743 | 299743 | 2020-07-04 | Macon | Alabama | 1087 | 189 | 9 |
302907 | 302907 | 2020-07-05 | Macon | Alabama | 1087 | 198 | 9 |
306071 | 306071 | 2020-07-06 | Macon | Alabama | 1087 | 203 | 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);