ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1071 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 138 ✖
- 2 54
- 3 43
- 112 33
- 110 26
- 241 25
- 117 22
- 113 21
- 23 20
- 34 20
- 194 18
- 1 15
- 12 15
- 9 14
- 105 14
- 236 14
- 200 13
- 207 13
- 5 11
- 6 11
- 7 11
- 11 11
- 24 11
- 122 11
- 4 9
- 106 9
- 114 9
- 10 8
- 201 8
- 214 8
- 233 8
- 15 7
- 41 7
- 102 6
- 104 6
- 108 6
- 132 6
- 196 6
- 219 6
- 0 5
- 19 5
- 115 5
- 119 5
- 123 5
- 125 5
- 192 5
- 195 5
- 199 5
- 225 5
- 231 5
- 234 5
- 14 4
- 78 4
- 92 4
- 99 4
- 136 4
- 164 4
- 170 4
- 188 4
- 203 4
- 204 4
- 229 4
- 240 4
- 17 3
- 22 3
- 26 3
- 31 3
- 45 3
- 77 3
- 124 3
- 158 3
- 180 3
- 182 3
- 184 3
- 185 3
- 210 3
- 211 3
- 215 3
- 13 2
- 21 2
- 28 2
- 69 2
- 70 2
- 103 2
- 111 2
- 120 2
- 121 2
- 131 2
- 161 2
- 162 2
- 177 2
- 202 2
- 221 2
- 230 2
- 8 1
- 18 1
- 25 1
- 27 1
- 29 1
- 33 1
- 35 1
- 36 1
- 37 1
- 44 1
- 49 1
- 57 1
- 62 1
- 73 1
- 84 1
- 86 1
- 88 1
- 93 1
- 95 1
- 101 1
- 107 1
- 116 1
- 130 1
- 145 1
- 146 1
- 152 1
- 156 1
- 165 1
- 168 1
- 169 1
- 172 1
- 183 1
- 186 1
- 189 1
- 191 1
- 193 1
- 197 1
- 216 1
- 218 1
- 226 1
- 228 1
- 235 1
- 237 1
- 238 1
- 239 1
state 1
- Alabama 785
fips 1
- 1071 · 785 ✖
county 1
- Jackson 785
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5172 | 5172 | 2020-03-20 | Jackson | Alabama | 1071 | 1 | 0 |
6088 | 6088 | 2020-03-21 | Jackson | Alabama | 1071 | 1 | 0 |
7122 | 7122 | 2020-03-22 | Jackson | Alabama | 1071 | 1 | 0 |
8262 | 8262 | 2020-03-23 | Jackson | Alabama | 1071 | 1 | 0 |
9489 | 9489 | 2020-03-24 | Jackson | Alabama | 1071 | 2 | 0 |
10853 | 10853 | 2020-03-25 | Jackson | Alabama | 1071 | 2 | 1 |
12390 | 12390 | 2020-03-26 | Jackson | Alabama | 1071 | 4 | 1 |
14051 | 14051 | 2020-03-27 | Jackson | Alabama | 1071 | 5 | 1 |
15829 | 15829 | 2020-03-28 | Jackson | Alabama | 1071 | 5 | 1 |
17712 | 17712 | 2020-03-29 | Jackson | Alabama | 1071 | 5 | 1 |
19684 | 19684 | 2020-03-30 | Jackson | Alabama | 1071 | 7 | 1 |
21756 | 21756 | 2020-03-31 | Jackson | Alabama | 1071 | 8 | 1 |
23912 | 23912 | 2020-04-01 | Jackson | Alabama | 1071 | 8 | 1 |
26134 | 26134 | 2020-04-02 | Jackson | Alabama | 1071 | 9 | 1 |
28431 | 28431 | 2020-04-03 | Jackson | Alabama | 1071 | 12 | 1 |
30788 | 30788 | 2020-04-04 | Jackson | Alabama | 1071 | 13 | 1 |
33192 | 33192 | 2020-04-05 | Jackson | Alabama | 1071 | 14 | 1 |
35631 | 35631 | 2020-04-06 | Jackson | Alabama | 1071 | 17 | 1 |
38119 | 38119 | 2020-04-07 | Jackson | Alabama | 1071 | 18 | 1 |
40661 | 40661 | 2020-04-08 | Jackson | Alabama | 1071 | 20 | 1 |
43234 | 43234 | 2020-04-09 | Jackson | Alabama | 1071 | 22 | 2 |
45832 | 45832 | 2020-04-10 | Jackson | Alabama | 1071 | 22 | 2 |
48461 | 48461 | 2020-04-11 | Jackson | Alabama | 1071 | 22 | 2 |
51123 | 51123 | 2020-04-12 | Jackson | Alabama | 1071 | 25 | 2 |
53801 | 53801 | 2020-04-13 | Jackson | Alabama | 1071 | 26 | 2 |
56493 | 56493 | 2020-04-14 | Jackson | Alabama | 1071 | 29 | 2 |
59201 | 59201 | 2020-04-15 | Jackson | Alabama | 1071 | 31 | 2 |
61919 | 61919 | 2020-04-16 | Jackson | Alabama | 1071 | 32 | 2 |
64652 | 64652 | 2020-04-17 | Jackson | Alabama | 1071 | 32 | 2 |
67400 | 67400 | 2020-04-18 | Jackson | Alabama | 1071 | 38 | 2 |
70162 | 70162 | 2020-04-19 | Jackson | Alabama | 1071 | 38 | 2 |
72931 | 72931 | 2020-04-20 | Jackson | Alabama | 1071 | 39 | 2 |
75707 | 75707 | 2020-04-21 | Jackson | Alabama | 1071 | 41 | 2 |
78490 | 78490 | 2020-04-22 | Jackson | Alabama | 1071 | 42 | 2 |
81283 | 81283 | 2020-04-23 | Jackson | Alabama | 1071 | 43 | 2 |
84084 | 84084 | 2020-04-24 | Jackson | Alabama | 1071 | 45 | 2 |
86892 | 86892 | 2020-04-25 | Jackson | Alabama | 1071 | 45 | 2 |
89708 | 89708 | 2020-04-26 | Jackson | Alabama | 1071 | 45 | 2 |
92526 | 92526 | 2020-04-27 | Jackson | Alabama | 1071 | 45 | 2 |
95356 | 95356 | 2020-04-28 | Jackson | Alabama | 1071 | 46 | 2 |
98201 | 98201 | 2020-04-29 | Jackson | Alabama | 1071 | 47 | 2 |
101051 | 101051 | 2020-04-30 | Jackson | Alabama | 1071 | 48 | 2 |
103906 | 103906 | 2020-05-01 | Jackson | Alabama | 1071 | 49 | 2 |
106771 | 106771 | 2020-05-02 | Jackson | Alabama | 1071 | 50 | 2 |
109640 | 109640 | 2020-05-03 | Jackson | Alabama | 1071 | 50 | 2 |
112515 | 112515 | 2020-05-04 | Jackson | Alabama | 1071 | 50 | 2 |
115398 | 115398 | 2020-05-05 | Jackson | Alabama | 1071 | 53 | 2 |
118357 | 118357 | 2020-05-06 | Jackson | Alabama | 1071 | 53 | 2 |
121323 | 121323 | 2020-05-07 | Jackson | Alabama | 1071 | 56 | 2 |
124303 | 124303 | 2020-05-08 | Jackson | Alabama | 1071 | 59 | 2 |
127288 | 127288 | 2020-05-09 | Jackson | Alabama | 1071 | 59 | 2 |
130278 | 130278 | 2020-05-10 | Jackson | Alabama | 1071 | 60 | 2 |
133268 | 133268 | 2020-05-11 | Jackson | Alabama | 1071 | 60 | 2 |
136258 | 136258 | 2020-05-12 | Jackson | Alabama | 1071 | 60 | 2 |
139249 | 139249 | 2020-05-13 | Jackson | Alabama | 1071 | 60 | 2 |
142245 | 142245 | 2020-05-14 | Jackson | Alabama | 1071 | 60 | 2 |
145244 | 145244 | 2020-05-15 | Jackson | Alabama | 1071 | 61 | 2 |
148247 | 148247 | 2020-05-16 | Jackson | Alabama | 1071 | 63 | 2 |
151256 | 151256 | 2020-05-17 | Jackson | Alabama | 1071 | 63 | 2 |
154268 | 154268 | 2020-05-18 | Jackson | Alabama | 1071 | 64 | 2 |
157284 | 157284 | 2020-05-19 | Jackson | Alabama | 1071 | 63 | 2 |
160308 | 160308 | 2020-05-20 | Jackson | Alabama | 1071 | 66 | 2 |
163336 | 163336 | 2020-05-21 | Jackson | Alabama | 1071 | 69 | 2 |
166368 | 166368 | 2020-05-22 | Jackson | Alabama | 1071 | 69 | 2 |
169404 | 169404 | 2020-05-23 | Jackson | Alabama | 1071 | 69 | 2 |
172445 | 172445 | 2020-05-24 | Jackson | Alabama | 1071 | 69 | 2 |
175488 | 175488 | 2020-05-25 | Jackson | Alabama | 1071 | 71 | 2 |
178533 | 178533 | 2020-05-26 | Jackson | Alabama | 1071 | 72 | 2 |
181577 | 181577 | 2020-05-27 | Jackson | Alabama | 1071 | 74 | 2 |
184629 | 184629 | 2020-05-28 | Jackson | Alabama | 1071 | 75 | 2 |
187686 | 187686 | 2020-05-29 | Jackson | Alabama | 1071 | 76 | 2 |
190750 | 190750 | 2020-05-30 | Jackson | Alabama | 1071 | 77 | 2 |
193816 | 193816 | 2020-05-31 | Jackson | Alabama | 1071 | 78 | 2 |
196886 | 196886 | 2020-06-01 | Jackson | Alabama | 1071 | 84 | 2 |
199959 | 199959 | 2020-06-02 | Jackson | Alabama | 1071 | 86 | 3 |
203035 | 203035 | 2020-06-03 | Jackson | Alabama | 1071 | 86 | 3 |
206114 | 206114 | 2020-06-04 | Jackson | Alabama | 1071 | 86 | 3 |
209196 | 209196 | 2020-06-05 | Jackson | Alabama | 1071 | 89 | 3 |
212281 | 212281 | 2020-06-06 | Jackson | Alabama | 1071 | 91 | 3 |
215368 | 215368 | 2020-06-07 | Jackson | Alabama | 1071 | 93 | 3 |
218458 | 218458 | 2020-06-08 | Jackson | Alabama | 1071 | 97 | 3 |
221550 | 221550 | 2020-06-09 | Jackson | Alabama | 1071 | 100 | 3 |
224646 | 224646 | 2020-06-10 | Jackson | Alabama | 1071 | 104 | 3 |
227747 | 227747 | 2020-06-11 | Jackson | Alabama | 1071 | 110 | 3 |
230851 | 230851 | 2020-06-12 | Jackson | Alabama | 1071 | 116 | 3 |
233956 | 233956 | 2020-06-13 | Jackson | Alabama | 1071 | 126 | 3 |
237063 | 237063 | 2020-06-14 | Jackson | Alabama | 1071 | 125 | 3 |
240171 | 240171 | 2020-06-15 | Jackson | Alabama | 1071 | 125 | 3 |
243282 | 243282 | 2020-06-16 | Jackson | Alabama | 1071 | 128 | 3 |
246395 | 246395 | 2020-06-17 | Jackson | Alabama | 1071 | 137 | 3 |
249507 | 249507 | 2020-06-18 | Jackson | Alabama | 1071 | 142 | 3 |
252622 | 252622 | 2020-06-19 | Jackson | Alabama | 1071 | 150 | 3 |
255741 | 255741 | 2020-06-20 | Jackson | Alabama | 1071 | 150 | 3 |
258868 | 258868 | 2020-06-21 | Jackson | Alabama | 1071 | 152 | 3 |
261995 | 261995 | 2020-06-22 | Jackson | Alabama | 1071 | 155 | 3 |
265124 | 265124 | 2020-06-23 | Jackson | Alabama | 1071 | 162 | 3 |
268253 | 268253 | 2020-06-24 | Jackson | Alabama | 1071 | 166 | 3 |
271387 | 271387 | 2020-06-25 | Jackson | Alabama | 1071 | 182 | 3 |
274527 | 274527 | 2020-06-26 | Jackson | Alabama | 1071 | 200 | 3 |
277675 | 277675 | 2020-06-27 | Jackson | Alabama | 1071 | 198 | 3 |
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);