ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 22031 and state = "Louisiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5503 | 5503 | 2020-03-20 | De Soto | Louisiana | 22031 | 2 | 0 |
6455 | 6455 | 2020-03-21 | De Soto | Louisiana | 22031 | 2 | 0 |
7530 | 7530 | 2020-03-22 | De Soto | Louisiana | 22031 | 2 | 0 |
8694 | 8694 | 2020-03-23 | De Soto | Louisiana | 22031 | 5 | 0 |
9982 | 9982 | 2020-03-24 | De Soto | Louisiana | 22031 | 6 | 0 |
11386 | 11386 | 2020-03-25 | De Soto | Louisiana | 22031 | 8 | 0 |
12961 | 12961 | 2020-03-26 | De Soto | Louisiana | 22031 | 11 | 1 |
14668 | 14668 | 2020-03-27 | De Soto | Louisiana | 22031 | 13 | 1 |
16486 | 16486 | 2020-03-28 | De Soto | Louisiana | 22031 | 21 | 1 |
18398 | 18398 | 2020-03-29 | De Soto | Louisiana | 22031 | 25 | 1 |
20414 | 20414 | 2020-03-30 | De Soto | Louisiana | 22031 | 28 | 1 |
22522 | 22522 | 2020-03-31 | De Soto | Louisiana | 22031 | 30 | 1 |
24698 | 24698 | 2020-04-01 | De Soto | Louisiana | 22031 | 39 | 1 |
26949 | 26949 | 2020-04-02 | De Soto | Louisiana | 22031 | 42 | 1 |
29266 | 29266 | 2020-04-03 | De Soto | Louisiana | 22031 | 46 | 2 |
31644 | 31644 | 2020-04-04 | De Soto | Louisiana | 22031 | 71 | 3 |
34069 | 34069 | 2020-04-05 | De Soto | Louisiana | 22031 | 80 | 3 |
36527 | 36527 | 2020-04-06 | De Soto | Louisiana | 22031 | 82 | 4 |
39035 | 39035 | 2020-04-07 | De Soto | Louisiana | 22031 | 89 | 6 |
41587 | 41587 | 2020-04-08 | De Soto | Louisiana | 22031 | 91 | 7 |
44163 | 44163 | 2020-04-09 | De Soto | Louisiana | 22031 | 101 | 7 |
46771 | 46771 | 2020-04-10 | De Soto | Louisiana | 22031 | 107 | 7 |
49412 | 49412 | 2020-04-11 | De Soto | Louisiana | 22031 | 114 | 7 |
52082 | 52082 | 2020-04-12 | De Soto | Louisiana | 22031 | 124 | 7 |
54763 | 54763 | 2020-04-13 | De Soto | Louisiana | 22031 | 125 | 7 |
57461 | 57461 | 2020-04-14 | De Soto | Louisiana | 22031 | 130 | 7 |
60169 | 60169 | 2020-04-15 | De Soto | Louisiana | 22031 | 134 | 8 |
62890 | 62890 | 2020-04-16 | De Soto | Louisiana | 22031 | 140 | 8 |
65629 | 65629 | 2020-04-17 | De Soto | Louisiana | 22031 | 145 | 8 |
68378 | 68378 | 2020-04-18 | De Soto | Louisiana | 22031 | 152 | 8 |
71141 | 71141 | 2020-04-19 | De Soto | Louisiana | 22031 | 156 | 8 |
73913 | 73913 | 2020-04-20 | De Soto | Louisiana | 22031 | 158 | 9 |
76693 | 76693 | 2020-04-21 | De Soto | Louisiana | 22031 | 168 | 10 |
79479 | 79479 | 2020-04-22 | De Soto | Louisiana | 22031 | 171 | 10 |
82275 | 82275 | 2020-04-23 | De Soto | Louisiana | 22031 | 176 | 10 |
85079 | 85079 | 2020-04-24 | De Soto | Louisiana | 22031 | 180 | 10 |
87888 | 87888 | 2020-04-25 | De Soto | Louisiana | 22031 | 184 | 10 |
90704 | 90704 | 2020-04-26 | De Soto | Louisiana | 22031 | 185 | 10 |
93525 | 93525 | 2020-04-27 | De Soto | Louisiana | 22031 | 187 | 11 |
96360 | 96360 | 2020-04-28 | De Soto | Louisiana | 22031 | 189 | 11 |
102058 | 102058 | 2020-04-30 | De Soto | Louisiana | 22031 | 190 | 11 |
99206 | 99206 | 2020-04-29 | De Soto | Louisiana | 22031 | 191 | 11 |
104919 | 104919 | 2020-05-01 | De Soto | Louisiana | 22031 | 194 | 11 |
107783 | 107783 | 2020-05-02 | De Soto | Louisiana | 22031 | 198 | 12 |
110655 | 110655 | 2020-05-03 | De Soto | Louisiana | 22031 | 198 | 12 |
113532 | 113532 | 2020-05-04 | De Soto | Louisiana | 22031 | 202 | 13 |
116414 | 116414 | 2020-05-05 | De Soto | Louisiana | 22031 | 202 | 13 |
119375 | 119375 | 2020-05-06 | De Soto | Louisiana | 22031 | 205 | 13 |
122346 | 122346 | 2020-05-07 | De Soto | Louisiana | 22031 | 207 | 13 |
125328 | 125328 | 2020-05-08 | De Soto | Louisiana | 22031 | 208 | 13 |
128315 | 128315 | 2020-05-09 | De Soto | Louisiana | 22031 | 213 | 13 |
131305 | 131305 | 2020-05-10 | De Soto | Louisiana | 22031 | 214 | 13 |
134296 | 134296 | 2020-05-11 | De Soto | Louisiana | 22031 | 215 | 14 |
137286 | 137286 | 2020-05-12 | De Soto | Louisiana | 22031 | 215 | 14 |
149280 | 149280 | 2020-05-16 | De Soto | Louisiana | 22031 | 218 | 15 |
140280 | 140280 | 2020-05-13 | De Soto | Louisiana | 22031 | 221 | 14 |
152291 | 152291 | 2020-05-17 | De Soto | Louisiana | 22031 | 222 | 15 |
143275 | 143275 | 2020-05-14 | De Soto | Louisiana | 22031 | 223 | 14 |
155305 | 155305 | 2020-05-18 | De Soto | Louisiana | 22031 | 224 | 16 |
146275 | 146275 | 2020-05-15 | De Soto | Louisiana | 22031 | 225 | 14 |
158323 | 158323 | 2020-05-19 | De Soto | Louisiana | 22031 | 226 | 16 |
161349 | 161349 | 2020-05-20 | De Soto | Louisiana | 22031 | 228 | 16 |
164378 | 164378 | 2020-05-21 | De Soto | Louisiana | 22031 | 235 | 16 |
167414 | 167414 | 2020-05-22 | De Soto | Louisiana | 22031 | 236 | 16 |
170452 | 170452 | 2020-05-23 | De Soto | Louisiana | 22031 | 236 | 16 |
173493 | 173493 | 2020-05-24 | De Soto | Louisiana | 22031 | 237 | 16 |
176537 | 176537 | 2020-05-25 | De Soto | Louisiana | 22031 | 239 | 16 |
179581 | 179581 | 2020-05-26 | De Soto | Louisiana | 22031 | 239 | 17 |
182626 | 182626 | 2020-05-27 | De Soto | Louisiana | 22031 | 241 | 17 |
185681 | 185681 | 2020-05-28 | De Soto | Louisiana | 22031 | 242 | 17 |
188739 | 188739 | 2020-05-29 | De Soto | Louisiana | 22031 | 242 | 17 |
191803 | 191803 | 2020-05-30 | De Soto | Louisiana | 22031 | 246 | 17 |
194871 | 194871 | 2020-05-31 | De Soto | Louisiana | 22031 | 247 | 17 |
197942 | 197942 | 2020-06-01 | De Soto | Louisiana | 22031 | 247 | 17 |
201014 | 201014 | 2020-06-02 | De Soto | Louisiana | 22031 | 249 | 17 |
204091 | 204091 | 2020-06-03 | De Soto | Louisiana | 22031 | 250 | 17 |
207172 | 207172 | 2020-06-04 | De Soto | Louisiana | 22031 | 260 | 17 |
210253 | 210253 | 2020-06-05 | De Soto | Louisiana | 22031 | 262 | 17 |
213338 | 213338 | 2020-06-06 | De Soto | Louisiana | 22031 | 262 | 17 |
216425 | 216425 | 2020-06-07 | De Soto | Louisiana | 22031 | 262 | 17 |
219517 | 219517 | 2020-06-08 | De Soto | Louisiana | 22031 | 263 | 17 |
222612 | 222612 | 2020-06-09 | De Soto | Louisiana | 22031 | 263 | 17 |
225708 | 225708 | 2020-06-10 | De Soto | Louisiana | 22031 | 263 | 17 |
228810 | 228810 | 2020-06-11 | De Soto | Louisiana | 22031 | 266 | 17 |
231914 | 231914 | 2020-06-12 | De Soto | Louisiana | 22031 | 269 | 17 |
235019 | 235019 | 2020-06-13 | De Soto | Louisiana | 22031 | 270 | 17 |
238126 | 238126 | 2020-06-14 | De Soto | Louisiana | 22031 | 271 | 17 |
241235 | 241235 | 2020-06-15 | De Soto | Louisiana | 22031 | 271 | 17 |
244346 | 244346 | 2020-06-16 | De Soto | Louisiana | 22031 | 273 | 17 |
247459 | 247459 | 2020-06-17 | De Soto | Louisiana | 22031 | 275 | 17 |
250571 | 250571 | 2020-06-18 | De Soto | Louisiana | 22031 | 275 | 17 |
253686 | 253686 | 2020-06-19 | De Soto | Louisiana | 22031 | 311 | 17 |
256806 | 256806 | 2020-06-20 | De Soto | Louisiana | 22031 | 313 | 17 |
259932 | 259932 | 2020-06-21 | De Soto | Louisiana | 22031 | 316 | 18 |
263061 | 263061 | 2020-06-22 | De Soto | Louisiana | 22031 | 318 | 18 |
266188 | 266188 | 2020-06-23 | De Soto | Louisiana | 22031 | 320 | 18 |
269321 | 269321 | 2020-06-24 | De Soto | Louisiana | 22031 | 324 | 18 |
272457 | 272457 | 2020-06-25 | De Soto | Louisiana | 22031 | 327 | 18 |
275600 | 275600 | 2020-06-26 | De Soto | Louisiana | 22031 | 329 | 18 |
278748 | 278748 | 2020-06-27 | De Soto | Louisiana | 22031 | 329 | 18 |
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);