ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Houston" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293417 | 293417 | 2020-07-02 | Houston | Alabama | 1069 | 461 | 6 |
290264 | 290264 | 2020-07-01 | Houston | Alabama | 1069 | 449 | 6 |
287114 | 287114 | 2020-06-30 | Houston | Alabama | 1069 | 439 | 6 |
283968 | 283968 | 2020-06-29 | Houston | Alabama | 1069 | 435 | 6 |
280822 | 280822 | 2020-06-28 | Houston | Alabama | 1069 | 438 | 6 |
277674 | 277674 | 2020-06-27 | Houston | Alabama | 1069 | 433 | 6 |
274526 | 274526 | 2020-06-26 | Houston | Alabama | 1069 | 409 | 5 |
271386 | 271386 | 2020-06-25 | Houston | Alabama | 1069 | 385 | 5 |
268252 | 268252 | 2020-06-24 | Houston | Alabama | 1069 | 384 | 5 |
265123 | 265123 | 2020-06-23 | Houston | Alabama | 1069 | 366 | 5 |
261994 | 261994 | 2020-06-22 | Houston | Alabama | 1069 | 360 | 5 |
258867 | 258867 | 2020-06-21 | Houston | Alabama | 1069 | 357 | 5 |
255740 | 255740 | 2020-06-20 | Houston | Alabama | 1069 | 356 | 5 |
252621 | 252621 | 2020-06-19 | Houston | Alabama | 1069 | 352 | 5 |
249506 | 249506 | 2020-06-18 | Houston | Alabama | 1069 | 343 | 5 |
246394 | 246394 | 2020-06-17 | Houston | Alabama | 1069 | 338 | 5 |
243281 | 243281 | 2020-06-16 | Houston | Alabama | 1069 | 329 | 5 |
240170 | 240170 | 2020-06-15 | Houston | Alabama | 1069 | 325 | 5 |
237062 | 237062 | 2020-06-14 | Houston | Alabama | 1069 | 317 | 5 |
233955 | 233955 | 2020-06-13 | Houston | Alabama | 1069 | 303 | 5 |
230850 | 230850 | 2020-06-12 | Houston | Alabama | 1069 | 289 | 5 |
227746 | 227746 | 2020-06-11 | Houston | Alabama | 1069 | 280 | 5 |
224645 | 224645 | 2020-06-10 | Houston | Alabama | 1069 | 269 | 5 |
221549 | 221549 | 2020-06-09 | Houston | Alabama | 1069 | 263 | 5 |
218457 | 218457 | 2020-06-08 | Houston | Alabama | 1069 | 256 | 5 |
215367 | 215367 | 2020-06-07 | Houston | Alabama | 1069 | 255 | 5 |
212280 | 212280 | 2020-06-06 | Houston | Alabama | 1069 | 247 | 5 |
209195 | 209195 | 2020-06-05 | Houston | Alabama | 1069 | 237 | 5 |
206113 | 206113 | 2020-06-04 | Houston | Alabama | 1069 | 236 | 5 |
203034 | 203034 | 2020-06-03 | Houston | Alabama | 1069 | 236 | 5 |
199958 | 199958 | 2020-06-02 | Houston | Alabama | 1069 | 233 | 5 |
196885 | 196885 | 2020-06-01 | Houston | Alabama | 1069 | 231 | 4 |
193815 | 193815 | 2020-05-31 | Houston | Alabama | 1069 | 220 | 4 |
190749 | 190749 | 2020-05-30 | Houston | Alabama | 1069 | 209 | 4 |
187685 | 187685 | 2020-05-29 | Houston | Alabama | 1069 | 204 | 4 |
184628 | 184628 | 2020-05-28 | Houston | Alabama | 1069 | 188 | 4 |
181576 | 181576 | 2020-05-27 | Houston | Alabama | 1069 | 185 | 4 |
178532 | 178532 | 2020-05-26 | Houston | Alabama | 1069 | 183 | 4 |
175487 | 175487 | 2020-05-25 | Houston | Alabama | 1069 | 172 | 4 |
172444 | 172444 | 2020-05-24 | Houston | Alabama | 1069 | 164 | 4 |
169403 | 169403 | 2020-05-23 | Houston | Alabama | 1069 | 161 | 4 |
166367 | 166367 | 2020-05-22 | Houston | Alabama | 1069 | 156 | 3 |
163335 | 163335 | 2020-05-21 | Houston | Alabama | 1069 | 154 | 3 |
160307 | 160307 | 2020-05-20 | Houston | Alabama | 1069 | 149 | 3 |
157283 | 157283 | 2020-05-19 | Houston | Alabama | 1069 | 141 | 4 |
154267 | 154267 | 2020-05-18 | Houston | Alabama | 1069 | 137 | 4 |
151255 | 151255 | 2020-05-17 | Houston | Alabama | 1069 | 132 | 4 |
148246 | 148246 | 2020-05-16 | Houston | Alabama | 1069 | 132 | 4 |
145243 | 145243 | 2020-05-15 | Houston | Alabama | 1069 | 129 | 4 |
142244 | 142244 | 2020-05-14 | Houston | Alabama | 1069 | 125 | 4 |
139248 | 139248 | 2020-05-13 | Houston | Alabama | 1069 | 115 | 4 |
136257 | 136257 | 2020-05-12 | Houston | Alabama | 1069 | 114 | 4 |
133267 | 133267 | 2020-05-11 | Houston | Alabama | 1069 | 107 | 4 |
130277 | 130277 | 2020-05-10 | Houston | Alabama | 1069 | 107 | 4 |
127287 | 127287 | 2020-05-09 | Houston | Alabama | 1069 | 104 | 4 |
124302 | 124302 | 2020-05-08 | Houston | Alabama | 1069 | 102 | 4 |
121322 | 121322 | 2020-05-07 | Houston | Alabama | 1069 | 100 | 4 |
118356 | 118356 | 2020-05-06 | Houston | Alabama | 1069 | 99 | 4 |
115397 | 115397 | 2020-05-05 | Houston | Alabama | 1069 | 98 | 4 |
112514 | 112514 | 2020-05-04 | Houston | Alabama | 1069 | 97 | 4 |
109639 | 109639 | 2020-05-03 | Houston | Alabama | 1069 | 95 | 4 |
106770 | 106770 | 2020-05-02 | Houston | Alabama | 1069 | 93 | 4 |
103905 | 103905 | 2020-05-01 | Houston | Alabama | 1069 | 90 | 4 |
101050 | 101050 | 2020-04-30 | Houston | Alabama | 1069 | 90 | 4 |
98200 | 98200 | 2020-04-29 | Houston | Alabama | 1069 | 87 | 3 |
95355 | 95355 | 2020-04-28 | Houston | Alabama | 1069 | 84 | 3 |
92525 | 92525 | 2020-04-27 | Houston | Alabama | 1069 | 79 | 3 |
89707 | 89707 | 2020-04-26 | Houston | Alabama | 1069 | 77 | 3 |
86891 | 86891 | 2020-04-25 | Houston | Alabama | 1069 | 76 | 3 |
84083 | 84083 | 2020-04-24 | Houston | Alabama | 1069 | 76 | 3 |
81282 | 81282 | 2020-04-23 | Houston | Alabama | 1069 | 78 | 3 |
78489 | 78489 | 2020-04-22 | Houston | Alabama | 1069 | 75 | 3 |
75706 | 75706 | 2020-04-21 | Houston | Alabama | 1069 | 73 | 3 |
72930 | 72930 | 2020-04-20 | Houston | Alabama | 1069 | 70 | 2 |
70161 | 70161 | 2020-04-19 | Houston | Alabama | 1069 | 66 | 2 |
67399 | 67399 | 2020-04-18 | Houston | Alabama | 1069 | 63 | 2 |
64651 | 64651 | 2020-04-17 | Houston | Alabama | 1069 | 64 | 3 |
61918 | 61918 | 2020-04-16 | Houston | Alabama | 1069 | 58 | 3 |
59200 | 59200 | 2020-04-15 | Houston | Alabama | 1069 | 55 | 3 |
56492 | 56492 | 2020-04-14 | Houston | Alabama | 1069 | 52 | 2 |
53800 | 53800 | 2020-04-13 | Houston | Alabama | 1069 | 47 | 1 |
51122 | 51122 | 2020-04-12 | Houston | Alabama | 1069 | 44 | 1 |
48460 | 48460 | 2020-04-11 | Houston | Alabama | 1069 | 37 | 1 |
45831 | 45831 | 2020-04-10 | Houston | Alabama | 1069 | 33 | 1 |
43233 | 43233 | 2020-04-09 | Houston | Alabama | 1069 | 33 | 1 |
40660 | 40660 | 2020-04-08 | Houston | Alabama | 1069 | 27 | 1 |
38118 | 38118 | 2020-04-07 | Houston | Alabama | 1069 | 25 | 1 |
35630 | 35630 | 2020-04-06 | Houston | Alabama | 1069 | 24 | 1 |
33191 | 33191 | 2020-04-05 | Houston | Alabama | 1069 | 20 | 1 |
30787 | 30787 | 2020-04-04 | Houston | Alabama | 1069 | 14 | 1 |
28430 | 28430 | 2020-04-03 | Houston | Alabama | 1069 | 12 | 1 |
26133 | 26133 | 2020-04-02 | Houston | Alabama | 1069 | 9 | 1 |
23911 | 23911 | 2020-04-01 | Houston | Alabama | 1069 | 9 | 1 |
21755 | 21755 | 2020-03-31 | Houston | Alabama | 1069 | 8 | 0 |
19683 | 19683 | 2020-03-30 | Houston | Alabama | 1069 | 9 | 0 |
17711 | 17711 | 2020-03-29 | Houston | Alabama | 1069 | 8 | 0 |
15828 | 15828 | 2020-03-28 | Houston | Alabama | 1069 | 4 | 0 |
14050 | 14050 | 2020-03-27 | Houston | Alabama | 1069 | 4 | 0 |
12389 | 12389 | 2020-03-26 | Houston | Alabama | 1069 | 3 | 0 |
10852 | 10852 | 2020-03-25 | Houston | Alabama | 1069 | 2 | 0 |
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);