ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Madison" and fips = 22065 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12976 | 12976 | 2020-03-26 | Madison | Louisiana | 22065 | 1 | 0 |
14683 | 14683 | 2020-03-27 | Madison | Louisiana | 22065 | 1 | 0 |
16503 | 16503 | 2020-03-28 | Madison | Louisiana | 22065 | 1 | 0 |
18415 | 18415 | 2020-03-29 | Madison | Louisiana | 22065 | 1 | 0 |
20431 | 20431 | 2020-03-30 | Madison | Louisiana | 22065 | 1 | 0 |
22539 | 22539 | 2020-03-31 | Madison | Louisiana | 22065 | 1 | 0 |
24715 | 24715 | 2020-04-01 | Madison | Louisiana | 22065 | 1 | 0 |
26966 | 26966 | 2020-04-02 | Madison | Louisiana | 22065 | 1 | 0 |
29283 | 29283 | 2020-04-03 | Madison | Louisiana | 22065 | 1 | 0 |
31661 | 31661 | 2020-04-04 | Madison | Louisiana | 22065 | 1 | 0 |
34086 | 34086 | 2020-04-05 | Madison | Louisiana | 22065 | 1 | 0 |
36544 | 36544 | 2020-04-06 | Madison | Louisiana | 22065 | 1 | 0 |
39052 | 39052 | 2020-04-07 | Madison | Louisiana | 22065 | 2 | 0 |
41604 | 41604 | 2020-04-08 | Madison | Louisiana | 22065 | 2 | 0 |
44180 | 44180 | 2020-04-09 | Madison | Louisiana | 22065 | 2 | 0 |
46788 | 46788 | 2020-04-10 | Madison | Louisiana | 22065 | 2 | 0 |
49429 | 49429 | 2020-04-11 | Madison | Louisiana | 22065 | 2 | 0 |
52099 | 52099 | 2020-04-12 | Madison | Louisiana | 22065 | 2 | 0 |
54780 | 54780 | 2020-04-13 | Madison | Louisiana | 22065 | 2 | 0 |
57478 | 57478 | 2020-04-14 | Madison | Louisiana | 22065 | 2 | 0 |
60186 | 60186 | 2020-04-15 | Madison | Louisiana | 22065 | 2 | 0 |
62907 | 62907 | 2020-04-16 | Madison | Louisiana | 22065 | 2 | 0 |
65646 | 65646 | 2020-04-17 | Madison | Louisiana | 22065 | 4 | 0 |
68395 | 68395 | 2020-04-18 | Madison | Louisiana | 22065 | 4 | 0 |
71158 | 71158 | 2020-04-19 | Madison | Louisiana | 22065 | 4 | 0 |
73930 | 73930 | 2020-04-20 | Madison | Louisiana | 22065 | 4 | 0 |
76710 | 76710 | 2020-04-21 | Madison | Louisiana | 22065 | 4 | 0 |
79496 | 79496 | 2020-04-22 | Madison | Louisiana | 22065 | 5 | 0 |
82292 | 82292 | 2020-04-23 | Madison | Louisiana | 22065 | 5 | 0 |
85096 | 85096 | 2020-04-24 | Madison | Louisiana | 22065 | 5 | 0 |
87905 | 87905 | 2020-04-25 | Madison | Louisiana | 22065 | 7 | 0 |
90721 | 90721 | 2020-04-26 | Madison | Louisiana | 22065 | 7 | 0 |
93542 | 93542 | 2020-04-27 | Madison | Louisiana | 22065 | 7 | 0 |
96377 | 96377 | 2020-04-28 | Madison | Louisiana | 22065 | 7 | 0 |
99223 | 99223 | 2020-04-29 | Madison | Louisiana | 22065 | 7 | 0 |
102075 | 102075 | 2020-04-30 | Madison | Louisiana | 22065 | 7 | 0 |
104936 | 104936 | 2020-05-01 | Madison | Louisiana | 22065 | 7 | 0 |
107800 | 107800 | 2020-05-02 | Madison | Louisiana | 22065 | 8 | 0 |
110672 | 110672 | 2020-05-03 | Madison | Louisiana | 22065 | 8 | 0 |
113549 | 113549 | 2020-05-04 | Madison | Louisiana | 22065 | 8 | 0 |
116431 | 116431 | 2020-05-05 | Madison | Louisiana | 22065 | 8 | 0 |
119392 | 119392 | 2020-05-06 | Madison | Louisiana | 22065 | 8 | 0 |
122363 | 122363 | 2020-05-07 | Madison | Louisiana | 22065 | 8 | 0 |
125345 | 125345 | 2020-05-08 | Madison | Louisiana | 22065 | 8 | 0 |
128332 | 128332 | 2020-05-09 | Madison | Louisiana | 22065 | 12 | 0 |
131322 | 131322 | 2020-05-10 | Madison | Louisiana | 22065 | 12 | 0 |
134313 | 134313 | 2020-05-11 | Madison | Louisiana | 22065 | 13 | 0 |
137303 | 137303 | 2020-05-12 | Madison | Louisiana | 22065 | 14 | 0 |
140297 | 140297 | 2020-05-13 | Madison | Louisiana | 22065 | 14 | 0 |
143292 | 143292 | 2020-05-14 | Madison | Louisiana | 22065 | 18 | 0 |
146292 | 146292 | 2020-05-15 | Madison | Louisiana | 22065 | 24 | 0 |
149297 | 149297 | 2020-05-16 | Madison | Louisiana | 22065 | 24 | 0 |
152308 | 152308 | 2020-05-17 | Madison | Louisiana | 22065 | 24 | 0 |
155322 | 155322 | 2020-05-18 | Madison | Louisiana | 22065 | 24 | 0 |
158340 | 158340 | 2020-05-19 | Madison | Louisiana | 22065 | 27 | 0 |
161366 | 161366 | 2020-05-20 | Madison | Louisiana | 22065 | 33 | 0 |
164395 | 164395 | 2020-05-21 | Madison | Louisiana | 22065 | 43 | 0 |
167431 | 167431 | 2020-05-22 | Madison | Louisiana | 22065 | 54 | 0 |
170469 | 170469 | 2020-05-23 | Madison | Louisiana | 22065 | 54 | 0 |
173510 | 173510 | 2020-05-24 | Madison | Louisiana | 22065 | 55 | 0 |
176554 | 176554 | 2020-05-25 | Madison | Louisiana | 22065 | 69 | 0 |
179598 | 179598 | 2020-05-26 | Madison | Louisiana | 22065 | 70 | 0 |
182643 | 182643 | 2020-05-27 | Madison | Louisiana | 22065 | 77 | 0 |
185698 | 185698 | 2020-05-28 | Madison | Louisiana | 22065 | 79 | 0 |
188756 | 188756 | 2020-05-29 | Madison | Louisiana | 22065 | 79 | 0 |
191820 | 191820 | 2020-05-30 | Madison | Louisiana | 22065 | 90 | 0 |
194888 | 194888 | 2020-05-31 | Madison | Louisiana | 22065 | 97 | 0 |
197959 | 197959 | 2020-06-01 | Madison | Louisiana | 22065 | 101 | 0 |
201031 | 201031 | 2020-06-02 | Madison | Louisiana | 22065 | 105 | 2 |
204108 | 204108 | 2020-06-03 | Madison | Louisiana | 22065 | 106 | 2 |
207189 | 207189 | 2020-06-04 | Madison | Louisiana | 22065 | 116 | 2 |
210270 | 210270 | 2020-06-05 | Madison | Louisiana | 22065 | 121 | 2 |
213355 | 213355 | 2020-06-06 | Madison | Louisiana | 22065 | 199 | 2 |
216442 | 216442 | 2020-06-07 | Madison | Louisiana | 22065 | 209 | 2 |
219534 | 219534 | 2020-06-08 | Madison | Louisiana | 22065 | 214 | 2 |
222629 | 222629 | 2020-06-09 | Madison | Louisiana | 22065 | 219 | 2 |
225725 | 225725 | 2020-06-10 | Madison | Louisiana | 22065 | 221 | 2 |
228827 | 228827 | 2020-06-11 | Madison | Louisiana | 22065 | 249 | 2 |
231931 | 231931 | 2020-06-12 | Madison | Louisiana | 22065 | 251 | 2 |
235036 | 235036 | 2020-06-13 | Madison | Louisiana | 22065 | 261 | 2 |
238143 | 238143 | 2020-06-14 | Madison | Louisiana | 22065 | 270 | 2 |
241252 | 241252 | 2020-06-15 | Madison | Louisiana | 22065 | 286 | 2 |
244363 | 244363 | 2020-06-16 | Madison | Louisiana | 22065 | 287 | 2 |
247476 | 247476 | 2020-06-17 | Madison | Louisiana | 22065 | 287 | 2 |
250588 | 250588 | 2020-06-18 | Madison | Louisiana | 22065 | 287 | 2 |
253703 | 253703 | 2020-06-19 | Madison | Louisiana | 22065 | 289 | 2 |
256823 | 256823 | 2020-06-20 | Madison | Louisiana | 22065 | 308 | 2 |
259949 | 259949 | 2020-06-21 | Madison | Louisiana | 22065 | 317 | 2 |
263078 | 263078 | 2020-06-22 | Madison | Louisiana | 22065 | 320 | 2 |
266205 | 266205 | 2020-06-23 | Madison | Louisiana | 22065 | 320 | 2 |
269338 | 269338 | 2020-06-24 | Madison | Louisiana | 22065 | 322 | 2 |
272474 | 272474 | 2020-06-25 | Madison | Louisiana | 22065 | 324 | 2 |
275617 | 275617 | 2020-06-26 | Madison | Louisiana | 22065 | 331 | 2 |
278765 | 278765 | 2020-06-27 | Madison | Louisiana | 22065 | 331 | 2 |
281913 | 281913 | 2020-06-28 | Madison | Louisiana | 22065 | 347 | 2 |
285059 | 285059 | 2020-06-29 | Madison | Louisiana | 22065 | 352 | 2 |
288208 | 288208 | 2020-06-30 | Madison | Louisiana | 22065 | 356 | 2 |
291359 | 291359 | 2020-07-01 | Madison | Louisiana | 22065 | 362 | 2 |
294513 | 294513 | 2020-07-02 | Madison | Louisiana | 22065 | 371 | 2 |
297671 | 297671 | 2020-07-03 | Madison | Louisiana | 22065 | 383 | 2 |
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);