ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22121 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387114 | 387114 | 2020-07-31 | West Baton Rouge | Louisiana | 22121 | 613 | 36 |
383896 | 383896 | 2020-07-30 | West Baton Rouge | Louisiana | 22121 | 609 | 35 |
380679 | 380679 | 2020-07-29 | West Baton Rouge | Louisiana | 22121 | 593 | 34 |
377462 | 377462 | 2020-07-28 | West Baton Rouge | Louisiana | 22121 | 582 | 33 |
374247 | 374247 | 2020-07-27 | West Baton Rouge | Louisiana | 22121 | 573 | 33 |
371035 | 371035 | 2020-07-26 | West Baton Rouge | Louisiana | 22121 | 545 | 33 |
367825 | 367825 | 2020-07-25 | West Baton Rouge | Louisiana | 22121 | 524 | 33 |
364618 | 364618 | 2020-07-24 | West Baton Rouge | Louisiana | 22121 | 524 | 33 |
361411 | 361411 | 2020-07-23 | West Baton Rouge | Louisiana | 22121 | 502 | 33 |
358206 | 358206 | 2020-07-22 | West Baton Rouge | Louisiana | 22121 | 490 | 33 |
355003 | 355003 | 2020-07-21 | West Baton Rouge | Louisiana | 22121 | 484 | 33 |
351801 | 351801 | 2020-07-20 | West Baton Rouge | Louisiana | 22121 | 479 | 32 |
348601 | 348601 | 2020-07-19 | West Baton Rouge | Louisiana | 22121 | 467 | 32 |
345400 | 345400 | 2020-07-18 | West Baton Rouge | Louisiana | 22121 | 455 | 32 |
342200 | 342200 | 2020-07-17 | West Baton Rouge | Louisiana | 22121 | 455 | 32 |
339004 | 339004 | 2020-07-16 | West Baton Rouge | Louisiana | 22121 | 439 | 32 |
335808 | 335808 | 2020-07-15 | West Baton Rouge | Louisiana | 22121 | 427 | 32 |
332615 | 332615 | 2020-07-14 | West Baton Rouge | Louisiana | 22121 | 415 | 32 |
329428 | 329428 | 2020-07-13 | West Baton Rouge | Louisiana | 22121 | 392 | 31 |
326242 | 326242 | 2020-07-12 | West Baton Rouge | Louisiana | 22121 | 378 | 31 |
323059 | 323059 | 2020-07-11 | West Baton Rouge | Louisiana | 22121 | 371 | 31 |
319880 | 319880 | 2020-07-10 | West Baton Rouge | Louisiana | 22121 | 356 | 31 |
316705 | 316705 | 2020-07-09 | West Baton Rouge | Louisiana | 22121 | 342 | 31 |
313531 | 313531 | 2020-07-08 | West Baton Rouge | Louisiana | 22121 | 336 | 31 |
310361 | 310361 | 2020-07-07 | West Baton Rouge | Louisiana | 22121 | 326 | 30 |
307193 | 307193 | 2020-07-06 | West Baton Rouge | Louisiana | 22121 | 310 | 30 |
304026 | 304026 | 2020-07-05 | West Baton Rouge | Louisiana | 22121 | 309 | 30 |
300862 | 300862 | 2020-07-04 | West Baton Rouge | Louisiana | 22121 | 290 | 30 |
297700 | 297700 | 2020-07-03 | West Baton Rouge | Louisiana | 22121 | 290 | 30 |
294542 | 294542 | 2020-07-02 | West Baton Rouge | Louisiana | 22121 | 278 | 30 |
291388 | 291388 | 2020-07-01 | West Baton Rouge | Louisiana | 22121 | 264 | 30 |
288237 | 288237 | 2020-06-30 | West Baton Rouge | Louisiana | 22121 | 258 | 30 |
285088 | 285088 | 2020-06-29 | West Baton Rouge | Louisiana | 22121 | 252 | 30 |
281942 | 281942 | 2020-06-28 | West Baton Rouge | Louisiana | 22121 | 248 | 30 |
278794 | 278794 | 2020-06-27 | West Baton Rouge | Louisiana | 22121 | 243 | 30 |
275646 | 275646 | 2020-06-26 | West Baton Rouge | Louisiana | 22121 | 243 | 30 |
272503 | 272503 | 2020-06-25 | West Baton Rouge | Louisiana | 22121 | 243 | 30 |
269367 | 269367 | 2020-06-24 | West Baton Rouge | Louisiana | 22121 | 239 | 30 |
266234 | 266234 | 2020-06-23 | West Baton Rouge | Louisiana | 22121 | 232 | 30 |
263107 | 263107 | 2020-06-22 | West Baton Rouge | Louisiana | 22121 | 234 | 30 |
259978 | 259978 | 2020-06-21 | West Baton Rouge | Louisiana | 22121 | 234 | 30 |
256852 | 256852 | 2020-06-20 | West Baton Rouge | Louisiana | 22121 | 232 | 30 |
253732 | 253732 | 2020-06-19 | West Baton Rouge | Louisiana | 22121 | 231 | 30 |
250617 | 250617 | 2020-06-18 | West Baton Rouge | Louisiana | 22121 | 205 | 30 |
247505 | 247505 | 2020-06-17 | West Baton Rouge | Louisiana | 22121 | 205 | 30 |
244392 | 244392 | 2020-06-16 | West Baton Rouge | Louisiana | 22121 | 204 | 31 |
241281 | 241281 | 2020-06-15 | West Baton Rouge | Louisiana | 22121 | 204 | 31 |
238172 | 238172 | 2020-06-14 | West Baton Rouge | Louisiana | 22121 | 204 | 31 |
235065 | 235065 | 2020-06-13 | West Baton Rouge | Louisiana | 22121 | 202 | 31 |
231960 | 231960 | 2020-06-12 | West Baton Rouge | Louisiana | 22121 | 200 | 31 |
228856 | 228856 | 2020-06-11 | West Baton Rouge | Louisiana | 22121 | 197 | 31 |
225754 | 225754 | 2020-06-10 | West Baton Rouge | Louisiana | 22121 | 195 | 31 |
222658 | 222658 | 2020-06-09 | West Baton Rouge | Louisiana | 22121 | 192 | 31 |
219563 | 219563 | 2020-06-08 | West Baton Rouge | Louisiana | 22121 | 186 | 31 |
216471 | 216471 | 2020-06-07 | West Baton Rouge | Louisiana | 22121 | 185 | 31 |
213384 | 213384 | 2020-06-06 | West Baton Rouge | Louisiana | 22121 | 183 | 31 |
210299 | 210299 | 2020-06-05 | West Baton Rouge | Louisiana | 22121 | 180 | 31 |
207218 | 207218 | 2020-06-04 | West Baton Rouge | Louisiana | 22121 | 180 | 31 |
204137 | 204137 | 2020-06-03 | West Baton Rouge | Louisiana | 22121 | 176 | 31 |
201060 | 201060 | 2020-06-02 | West Baton Rouge | Louisiana | 22121 | 176 | 31 |
197988 | 197988 | 2020-06-01 | West Baton Rouge | Louisiana | 22121 | 175 | 30 |
194917 | 194917 | 2020-05-31 | West Baton Rouge | Louisiana | 22121 | 166 | 30 |
191849 | 191849 | 2020-05-30 | West Baton Rouge | Louisiana | 22121 | 161 | 30 |
188785 | 188785 | 2020-05-29 | West Baton Rouge | Louisiana | 22121 | 159 | 31 |
185727 | 185727 | 2020-05-28 | West Baton Rouge | Louisiana | 22121 | 159 | 31 |
182672 | 182672 | 2020-05-27 | West Baton Rouge | Louisiana | 22121 | 158 | 30 |
179627 | 179627 | 2020-05-26 | West Baton Rouge | Louisiana | 22121 | 157 | 30 |
176583 | 176583 | 2020-05-25 | West Baton Rouge | Louisiana | 22121 | 156 | 30 |
173539 | 173539 | 2020-05-24 | West Baton Rouge | Louisiana | 22121 | 154 | 30 |
170498 | 170498 | 2020-05-23 | West Baton Rouge | Louisiana | 22121 | 154 | 30 |
167460 | 167460 | 2020-05-22 | West Baton Rouge | Louisiana | 22121 | 154 | 30 |
164424 | 164424 | 2020-05-21 | West Baton Rouge | Louisiana | 22121 | 152 | 30 |
161395 | 161395 | 2020-05-20 | West Baton Rouge | Louisiana | 22121 | 149 | 30 |
158369 | 158369 | 2020-05-19 | West Baton Rouge | Louisiana | 22121 | 148 | 30 |
155351 | 155351 | 2020-05-18 | West Baton Rouge | Louisiana | 22121 | 148 | 30 |
152337 | 152337 | 2020-05-17 | West Baton Rouge | Louisiana | 22121 | 148 | 30 |
149326 | 149326 | 2020-05-16 | West Baton Rouge | Louisiana | 22121 | 148 | 30 |
146321 | 146321 | 2020-05-15 | West Baton Rouge | Louisiana | 22121 | 150 | 30 |
143321 | 143321 | 2020-05-14 | West Baton Rouge | Louisiana | 22121 | 150 | 30 |
140326 | 140326 | 2020-05-13 | West Baton Rouge | Louisiana | 22121 | 124 | 30 |
137332 | 137332 | 2020-05-12 | West Baton Rouge | Louisiana | 22121 | 124 | 28 |
134342 | 134342 | 2020-05-11 | West Baton Rouge | Louisiana | 22121 | 123 | 29 |
131351 | 131351 | 2020-05-10 | West Baton Rouge | Louisiana | 22121 | 123 | 26 |
128361 | 128361 | 2020-05-09 | West Baton Rouge | Louisiana | 22121 | 122 | 25 |
125374 | 125374 | 2020-05-08 | West Baton Rouge | Louisiana | 22121 | 119 | 24 |
122392 | 122392 | 2020-05-07 | West Baton Rouge | Louisiana | 22121 | 118 | 24 |
119421 | 119421 | 2020-05-06 | West Baton Rouge | Louisiana | 22121 | 118 | 24 |
116460 | 116460 | 2020-05-05 | West Baton Rouge | Louisiana | 22121 | 115 | 23 |
113578 | 113578 | 2020-05-04 | West Baton Rouge | Louisiana | 22121 | 111 | 22 |
110701 | 110701 | 2020-05-03 | West Baton Rouge | Louisiana | 22121 | 110 | 22 |
107829 | 107829 | 2020-05-02 | West Baton Rouge | Louisiana | 22121 | 110 | 19 |
104965 | 104965 | 2020-05-01 | West Baton Rouge | Louisiana | 22121 | 108 | 19 |
102104 | 102104 | 2020-04-30 | West Baton Rouge | Louisiana | 22121 | 98 | 18 |
99252 | 99252 | 2020-04-29 | West Baton Rouge | Louisiana | 22121 | 96 | 16 |
96406 | 96406 | 2020-04-28 | West Baton Rouge | Louisiana | 22121 | 94 | 16 |
93571 | 93571 | 2020-04-27 | West Baton Rouge | Louisiana | 22121 | 94 | 16 |
90750 | 90750 | 2020-04-26 | West Baton Rouge | Louisiana | 22121 | 91 | 15 |
87934 | 87934 | 2020-04-25 | West Baton Rouge | Louisiana | 22121 | 92 | 15 |
85125 | 85125 | 2020-04-24 | West Baton Rouge | Louisiana | 22121 | 93 | 13 |
82321 | 82321 | 2020-04-23 | West Baton Rouge | Louisiana | 22121 | 90 | 12 |
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);