ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1125 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1624 | 1624 | 2020-03-13 | Tuscaloosa | Alabama | 1125 | 1 | 0 |
1940 | 1940 | 2020-03-14 | Tuscaloosa | Alabama | 1125 | 2 | 0 |
2317 | 2317 | 2020-03-15 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
2746 | 2746 | 2020-03-16 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
3224 | 3224 | 2020-03-17 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
3772 | 3772 | 2020-03-18 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
4414 | 4414 | 2020-03-19 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
5184 | 5184 | 2020-03-20 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
6101 | 6101 | 2020-03-21 | Tuscaloosa | Alabama | 1125 | 6 | 0 |
7135 | 7135 | 2020-03-22 | Tuscaloosa | Alabama | 1125 | 7 | 0 |
8276 | 8276 | 2020-03-23 | Tuscaloosa | Alabama | 1125 | 9 | 0 |
9504 | 9504 | 2020-03-24 | Tuscaloosa | Alabama | 1125 | 10 | 0 |
10873 | 10873 | 2020-03-25 | Tuscaloosa | Alabama | 1125 | 15 | 0 |
12412 | 12412 | 2020-03-26 | Tuscaloosa | Alabama | 1125 | 20 | 0 |
14074 | 14074 | 2020-03-27 | Tuscaloosa | Alabama | 1125 | 22 | 0 |
15853 | 15853 | 2020-03-28 | Tuscaloosa | Alabama | 1125 | 23 | 0 |
17737 | 17737 | 2020-03-29 | Tuscaloosa | Alabama | 1125 | 23 | 0 |
19710 | 19710 | 2020-03-30 | Tuscaloosa | Alabama | 1125 | 28 | 0 |
21782 | 21782 | 2020-03-31 | Tuscaloosa | Alabama | 1125 | 29 | 0 |
23938 | 23938 | 2020-04-01 | Tuscaloosa | Alabama | 1125 | 30 | 0 |
26160 | 26160 | 2020-04-02 | Tuscaloosa | Alabama | 1125 | 37 | 0 |
28457 | 28457 | 2020-04-03 | Tuscaloosa | Alabama | 1125 | 41 | 0 |
30814 | 30814 | 2020-04-04 | Tuscaloosa | Alabama | 1125 | 44 | 0 |
33218 | 33218 | 2020-04-05 | Tuscaloosa | Alabama | 1125 | 60 | 0 |
35657 | 35657 | 2020-04-06 | Tuscaloosa | Alabama | 1125 | 74 | 0 |
38145 | 38145 | 2020-04-07 | Tuscaloosa | Alabama | 1125 | 79 | 0 |
40687 | 40687 | 2020-04-08 | Tuscaloosa | Alabama | 1125 | 85 | 0 |
43261 | 43261 | 2020-04-09 | Tuscaloosa | Alabama | 1125 | 86 | 0 |
45859 | 45859 | 2020-04-10 | Tuscaloosa | Alabama | 1125 | 91 | 0 |
48488 | 48488 | 2020-04-11 | Tuscaloosa | Alabama | 1125 | 100 | 0 |
51150 | 51150 | 2020-04-12 | Tuscaloosa | Alabama | 1125 | 119 | 0 |
53828 | 53828 | 2020-04-13 | Tuscaloosa | Alabama | 1125 | 120 | 0 |
56520 | 56520 | 2020-04-14 | Tuscaloosa | Alabama | 1125 | 122 | 0 |
59228 | 59228 | 2020-04-15 | Tuscaloosa | Alabama | 1125 | 131 | 0 |
61946 | 61946 | 2020-04-16 | Tuscaloosa | Alabama | 1125 | 132 | 0 |
64679 | 64679 | 2020-04-17 | Tuscaloosa | Alabama | 1125 | 153 | 0 |
67427 | 67427 | 2020-04-18 | Tuscaloosa | Alabama | 1125 | 141 | 0 |
70189 | 70189 | 2020-04-19 | Tuscaloosa | Alabama | 1125 | 145 | 1 |
72958 | 72958 | 2020-04-20 | Tuscaloosa | Alabama | 1125 | 153 | 1 |
75734 | 75734 | 2020-04-21 | Tuscaloosa | Alabama | 1125 | 157 | 1 |
78517 | 78517 | 2020-04-22 | Tuscaloosa | Alabama | 1125 | 165 | 1 |
81310 | 81310 | 2020-04-23 | Tuscaloosa | Alabama | 1125 | 173 | 0 |
84111 | 84111 | 2020-04-24 | Tuscaloosa | Alabama | 1125 | 182 | 0 |
86919 | 86919 | 2020-04-25 | Tuscaloosa | Alabama | 1125 | 185 | 0 |
89735 | 89735 | 2020-04-26 | Tuscaloosa | Alabama | 1125 | 192 | 0 |
92553 | 92553 | 2020-04-27 | Tuscaloosa | Alabama | 1125 | 195 | 0 |
95383 | 95383 | 2020-04-28 | Tuscaloosa | Alabama | 1125 | 199 | 0 |
98228 | 98228 | 2020-04-29 | Tuscaloosa | Alabama | 1125 | 203 | 1 |
101078 | 101078 | 2020-04-30 | Tuscaloosa | Alabama | 1125 | 208 | 1 |
103933 | 103933 | 2020-05-01 | Tuscaloosa | Alabama | 1125 | 210 | 2 |
106798 | 106798 | 2020-05-02 | Tuscaloosa | Alabama | 1125 | 216 | 2 |
109667 | 109667 | 2020-05-03 | Tuscaloosa | Alabama | 1125 | 218 | 2 |
112542 | 112542 | 2020-05-04 | Tuscaloosa | Alabama | 1125 | 237 | 2 |
115425 | 115425 | 2020-05-05 | Tuscaloosa | Alabama | 1125 | 243 | 3 |
118384 | 118384 | 2020-05-06 | Tuscaloosa | Alabama | 1125 | 248 | 4 |
121350 | 121350 | 2020-05-07 | Tuscaloosa | Alabama | 1125 | 259 | 4 |
124330 | 124330 | 2020-05-08 | Tuscaloosa | Alabama | 1125 | 269 | 4 |
127315 | 127315 | 2020-05-09 | Tuscaloosa | Alabama | 1125 | 274 | 4 |
130305 | 130305 | 2020-05-10 | Tuscaloosa | Alabama | 1125 | 278 | 4 |
133295 | 133295 | 2020-05-11 | Tuscaloosa | Alabama | 1125 | 284 | 4 |
136285 | 136285 | 2020-05-12 | Tuscaloosa | Alabama | 1125 | 291 | 7 |
139276 | 139276 | 2020-05-13 | Tuscaloosa | Alabama | 1125 | 302 | 8 |
142272 | 142272 | 2020-05-14 | Tuscaloosa | Alabama | 1125 | 319 | 8 |
145271 | 145271 | 2020-05-15 | Tuscaloosa | Alabama | 1125 | 332 | 8 |
148274 | 148274 | 2020-05-16 | Tuscaloosa | Alabama | 1125 | 345 | 8 |
151283 | 151283 | 2020-05-17 | Tuscaloosa | Alabama | 1125 | 345 | 8 |
154295 | 154295 | 2020-05-18 | Tuscaloosa | Alabama | 1125 | 368 | 8 |
157311 | 157311 | 2020-05-19 | Tuscaloosa | Alabama | 1125 | 387 | 8 |
160335 | 160335 | 2020-05-20 | Tuscaloosa | Alabama | 1125 | 431 | 8 |
163363 | 163363 | 2020-05-21 | Tuscaloosa | Alabama | 1125 | 454 | 9 |
166395 | 166395 | 2020-05-22 | Tuscaloosa | Alabama | 1125 | 464 | 9 |
169431 | 169431 | 2020-05-23 | Tuscaloosa | Alabama | 1125 | 480 | 11 |
172472 | 172472 | 2020-05-24 | Tuscaloosa | Alabama | 1125 | 505 | 12 |
175515 | 175515 | 2020-05-25 | Tuscaloosa | Alabama | 1125 | 558 | 12 |
178560 | 178560 | 2020-05-26 | Tuscaloosa | Alabama | 1125 | 607 | 12 |
181604 | 181604 | 2020-05-27 | Tuscaloosa | Alabama | 1125 | 632 | 12 |
184656 | 184656 | 2020-05-28 | Tuscaloosa | Alabama | 1125 | 678 | 13 |
187713 | 187713 | 2020-05-29 | Tuscaloosa | Alabama | 1125 | 720 | 14 |
190777 | 190777 | 2020-05-30 | Tuscaloosa | Alabama | 1125 | 738 | 14 |
193843 | 193843 | 2020-05-31 | Tuscaloosa | Alabama | 1125 | 783 | 15 |
196913 | 196913 | 2020-06-01 | Tuscaloosa | Alabama | 1125 | 808 | 16 |
199986 | 199986 | 2020-06-02 | Tuscaloosa | Alabama | 1125 | 825 | 16 |
203062 | 203062 | 2020-06-03 | Tuscaloosa | Alabama | 1125 | 831 | 16 |
206141 | 206141 | 2020-06-04 | Tuscaloosa | Alabama | 1125 | 846 | 16 |
209223 | 209223 | 2020-06-05 | Tuscaloosa | Alabama | 1125 | 864 | 16 |
212308 | 212308 | 2020-06-06 | Tuscaloosa | Alabama | 1125 | 908 | 17 |
215395 | 215395 | 2020-06-07 | Tuscaloosa | Alabama | 1125 | 927 | 18 |
218485 | 218485 | 2020-06-08 | Tuscaloosa | Alabama | 1125 | 948 | 23 |
221577 | 221577 | 2020-06-09 | Tuscaloosa | Alabama | 1125 | 989 | 23 |
224673 | 224673 | 2020-06-10 | Tuscaloosa | Alabama | 1125 | 1022 | 23 |
227774 | 227774 | 2020-06-11 | Tuscaloosa | Alabama | 1125 | 1083 | 23 |
230878 | 230878 | 2020-06-12 | Tuscaloosa | Alabama | 1125 | 1169 | 24 |
233983 | 233983 | 2020-06-13 | Tuscaloosa | Alabama | 1125 | 1253 | 25 |
237090 | 237090 | 2020-06-14 | Tuscaloosa | Alabama | 1125 | 1305 | 25 |
240198 | 240198 | 2020-06-15 | Tuscaloosa | Alabama | 1125 | 1356 | 25 |
243309 | 243309 | 2020-06-16 | Tuscaloosa | Alabama | 1125 | 1419 | 25 |
246422 | 246422 | 2020-06-17 | Tuscaloosa | Alabama | 1125 | 1432 | 25 |
249534 | 249534 | 2020-06-18 | Tuscaloosa | Alabama | 1125 | 1481 | 28 |
252649 | 252649 | 2020-06-19 | Tuscaloosa | Alabama | 1125 | 1541 | 29 |
255768 | 255768 | 2020-06-20 | Tuscaloosa | Alabama | 1125 | 1559 | 31 |
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);