ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 22123 and state = "Louisiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
36573 | 36573 | 2020-04-06 | West Carroll | Louisiana | 22123 | 1 | 0 |
39081 | 39081 | 2020-04-07 | West Carroll | Louisiana | 22123 | 1 | 0 |
41633 | 41633 | 2020-04-08 | West Carroll | Louisiana | 22123 | 1 | 0 |
44209 | 44209 | 2020-04-09 | West Carroll | Louisiana | 22123 | 1 | 0 |
46817 | 46817 | 2020-04-10 | West Carroll | Louisiana | 22123 | 3 | 0 |
49459 | 49459 | 2020-04-11 | West Carroll | Louisiana | 22123 | 4 | 0 |
52129 | 52129 | 2020-04-12 | West Carroll | Louisiana | 22123 | 4 | 0 |
54810 | 54810 | 2020-04-13 | West Carroll | Louisiana | 22123 | 4 | 0 |
57508 | 57508 | 2020-04-14 | West Carroll | Louisiana | 22123 | 4 | 0 |
60216 | 60216 | 2020-04-15 | West Carroll | Louisiana | 22123 | 4 | 0 |
62937 | 62937 | 2020-04-16 | West Carroll | Louisiana | 22123 | 4 | 0 |
65676 | 65676 | 2020-04-17 | West Carroll | Louisiana | 22123 | 4 | 0 |
68425 | 68425 | 2020-04-18 | West Carroll | Louisiana | 22123 | 4 | 0 |
71188 | 71188 | 2020-04-19 | West Carroll | Louisiana | 22123 | 4 | 0 |
73960 | 73960 | 2020-04-20 | West Carroll | Louisiana | 22123 | 4 | 0 |
76740 | 76740 | 2020-04-21 | West Carroll | Louisiana | 22123 | 4 | 0 |
79526 | 79526 | 2020-04-22 | West Carroll | Louisiana | 22123 | 4 | 0 |
82322 | 82322 | 2020-04-23 | West Carroll | Louisiana | 22123 | 4 | 0 |
85126 | 85126 | 2020-04-24 | West Carroll | Louisiana | 22123 | 4 | 0 |
87935 | 87935 | 2020-04-25 | West Carroll | Louisiana | 22123 | 4 | 0 |
90751 | 90751 | 2020-04-26 | West Carroll | Louisiana | 22123 | 4 | 0 |
93572 | 93572 | 2020-04-27 | West Carroll | Louisiana | 22123 | 4 | 0 |
96407 | 96407 | 2020-04-28 | West Carroll | Louisiana | 22123 | 4 | 0 |
99253 | 99253 | 2020-04-29 | West Carroll | Louisiana | 22123 | 4 | 0 |
102105 | 102105 | 2020-04-30 | West Carroll | Louisiana | 22123 | 4 | 0 |
104966 | 104966 | 2020-05-01 | West Carroll | Louisiana | 22123 | 4 | 0 |
107830 | 107830 | 2020-05-02 | West Carroll | Louisiana | 22123 | 4 | 0 |
110702 | 110702 | 2020-05-03 | West Carroll | Louisiana | 22123 | 4 | 0 |
113579 | 113579 | 2020-05-04 | West Carroll | Louisiana | 22123 | 4 | 0 |
116461 | 116461 | 2020-05-05 | West Carroll | Louisiana | 22123 | 4 | 0 |
119422 | 119422 | 2020-05-06 | West Carroll | Louisiana | 22123 | 4 | 0 |
122393 | 122393 | 2020-05-07 | West Carroll | Louisiana | 22123 | 4 | 0 |
125375 | 125375 | 2020-05-08 | West Carroll | Louisiana | 22123 | 4 | 0 |
128362 | 128362 | 2020-05-09 | West Carroll | Louisiana | 22123 | 4 | 0 |
131352 | 131352 | 2020-05-10 | West Carroll | Louisiana | 22123 | 4 | 0 |
134343 | 134343 | 2020-05-11 | West Carroll | Louisiana | 22123 | 5 | 0 |
137333 | 137333 | 2020-05-12 | West Carroll | Louisiana | 22123 | 5 | 0 |
140327 | 140327 | 2020-05-13 | West Carroll | Louisiana | 22123 | 5 | 0 |
143322 | 143322 | 2020-05-14 | West Carroll | Louisiana | 22123 | 6 | 0 |
146322 | 146322 | 2020-05-15 | West Carroll | Louisiana | 22123 | 11 | 0 |
149327 | 149327 | 2020-05-16 | West Carroll | Louisiana | 22123 | 12 | 0 |
152338 | 152338 | 2020-05-17 | West Carroll | Louisiana | 22123 | 13 | 0 |
155352 | 155352 | 2020-05-18 | West Carroll | Louisiana | 22123 | 18 | 0 |
158370 | 158370 | 2020-05-19 | West Carroll | Louisiana | 22123 | 19 | 0 |
161396 | 161396 | 2020-05-20 | West Carroll | Louisiana | 22123 | 19 | 0 |
164425 | 164425 | 2020-05-21 | West Carroll | Louisiana | 22123 | 21 | 0 |
167461 | 167461 | 2020-05-22 | West Carroll | Louisiana | 22123 | 33 | 0 |
170499 | 170499 | 2020-05-23 | West Carroll | Louisiana | 22123 | 33 | 0 |
173540 | 173540 | 2020-05-24 | West Carroll | Louisiana | 22123 | 33 | 0 |
176584 | 176584 | 2020-05-25 | West Carroll | Louisiana | 22123 | 39 | 0 |
179628 | 179628 | 2020-05-26 | West Carroll | Louisiana | 22123 | 41 | 0 |
182673 | 182673 | 2020-05-27 | West Carroll | Louisiana | 22123 | 44 | 0 |
185728 | 185728 | 2020-05-28 | West Carroll | Louisiana | 22123 | 56 | 0 |
188786 | 188786 | 2020-05-29 | West Carroll | Louisiana | 22123 | 56 | 0 |
191850 | 191850 | 2020-05-30 | West Carroll | Louisiana | 22123 | 61 | 0 |
194918 | 194918 | 2020-05-31 | West Carroll | Louisiana | 22123 | 62 | 0 |
197989 | 197989 | 2020-06-01 | West Carroll | Louisiana | 22123 | 64 | 0 |
201061 | 201061 | 2020-06-02 | West Carroll | Louisiana | 22123 | 66 | 0 |
204138 | 204138 | 2020-06-03 | West Carroll | Louisiana | 22123 | 68 | 0 |
207219 | 207219 | 2020-06-04 | West Carroll | Louisiana | 22123 | 68 | 0 |
210300 | 210300 | 2020-06-05 | West Carroll | Louisiana | 22123 | 68 | 0 |
213385 | 213385 | 2020-06-06 | West Carroll | Louisiana | 22123 | 74 | 0 |
216472 | 216472 | 2020-06-07 | West Carroll | Louisiana | 22123 | 84 | 1 |
219564 | 219564 | 2020-06-08 | West Carroll | Louisiana | 22123 | 86 | 1 |
222659 | 222659 | 2020-06-09 | West Carroll | Louisiana | 22123 | 90 | 1 |
225755 | 225755 | 2020-06-10 | West Carroll | Louisiana | 22123 | 99 | 1 |
228857 | 228857 | 2020-06-11 | West Carroll | Louisiana | 22123 | 99 | 1 |
231961 | 231961 | 2020-06-12 | West Carroll | Louisiana | 22123 | 99 | 1 |
235066 | 235066 | 2020-06-13 | West Carroll | Louisiana | 22123 | 104 | 2 |
238173 | 238173 | 2020-06-14 | West Carroll | Louisiana | 22123 | 112 | 3 |
241282 | 241282 | 2020-06-15 | West Carroll | Louisiana | 22123 | 115 | 3 |
244393 | 244393 | 2020-06-16 | West Carroll | Louisiana | 22123 | 114 | 3 |
247506 | 247506 | 2020-06-17 | West Carroll | Louisiana | 22123 | 115 | 3 |
250618 | 250618 | 2020-06-18 | West Carroll | Louisiana | 22123 | 115 | 3 |
253733 | 253733 | 2020-06-19 | West Carroll | Louisiana | 22123 | 103 | 3 |
256853 | 256853 | 2020-06-20 | West Carroll | Louisiana | 22123 | 105 | 3 |
259979 | 259979 | 2020-06-21 | West Carroll | Louisiana | 22123 | 107 | 3 |
263108 | 263108 | 2020-06-22 | West Carroll | Louisiana | 22123 | 108 | 3 |
266235 | 266235 | 2020-06-23 | West Carroll | Louisiana | 22123 | 107 | 3 |
269368 | 269368 | 2020-06-24 | West Carroll | Louisiana | 22123 | 111 | 3 |
272504 | 272504 | 2020-06-25 | West Carroll | Louisiana | 22123 | 111 | 3 |
275647 | 275647 | 2020-06-26 | West Carroll | Louisiana | 22123 | 114 | 5 |
278795 | 278795 | 2020-06-27 | West Carroll | Louisiana | 22123 | 114 | 5 |
281943 | 281943 | 2020-06-28 | West Carroll | Louisiana | 22123 | 115 | 5 |
285089 | 285089 | 2020-06-29 | West Carroll | Louisiana | 22123 | 118 | 5 |
288238 | 288238 | 2020-06-30 | West Carroll | Louisiana | 22123 | 124 | 5 |
291389 | 291389 | 2020-07-01 | West Carroll | Louisiana | 22123 | 134 | 5 |
294543 | 294543 | 2020-07-02 | West Carroll | Louisiana | 22123 | 138 | 5 |
297701 | 297701 | 2020-07-03 | West Carroll | Louisiana | 22123 | 141 | 5 |
300863 | 300863 | 2020-07-04 | West Carroll | Louisiana | 22123 | 141 | 5 |
304027 | 304027 | 2020-07-05 | West Carroll | Louisiana | 22123 | 149 | 5 |
307194 | 307194 | 2020-07-06 | West Carroll | Louisiana | 22123 | 152 | 5 |
310362 | 310362 | 2020-07-07 | West Carroll | Louisiana | 22123 | 155 | 5 |
313532 | 313532 | 2020-07-08 | West Carroll | Louisiana | 22123 | 158 | 5 |
316706 | 316706 | 2020-07-09 | West Carroll | Louisiana | 22123 | 161 | 5 |
319881 | 319881 | 2020-07-10 | West Carroll | Louisiana | 22123 | 166 | 5 |
323060 | 323060 | 2020-07-11 | West Carroll | Louisiana | 22123 | 169 | 5 |
326243 | 326243 | 2020-07-12 | West Carroll | Louisiana | 22123 | 176 | 5 |
329429 | 329429 | 2020-07-13 | West Carroll | Louisiana | 22123 | 176 | 5 |
332616 | 332616 | 2020-07-14 | West Carroll | Louisiana | 22123 | 173 | 5 |
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);