ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "East Baton Rouge" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535557 | 535557 | 2020-09-15 | East Baton Rouge | Louisiana | 22033 | 14681 | 433 |
532322 | 532322 | 2020-09-14 | East Baton Rouge | Louisiana | 22033 | 14674 | 432 |
529085 | 529085 | 2020-09-13 | East Baton Rouge | Louisiana | 22033 | 14588 | 432 |
525849 | 525849 | 2020-09-12 | East Baton Rouge | Louisiana | 22033 | 14507 | 430 |
522613 | 522613 | 2020-09-11 | East Baton Rouge | Louisiana | 22033 | 14507 | 430 |
519376 | 519376 | 2020-09-10 | East Baton Rouge | Louisiana | 22033 | 14421 | 427 |
516141 | 516141 | 2020-09-09 | East Baton Rouge | Louisiana | 22033 | 14380 | 427 |
512908 | 512908 | 2020-09-08 | East Baton Rouge | Louisiana | 22033 | 14284 | 426 |
509676 | 509676 | 2020-09-07 | East Baton Rouge | Louisiana | 22033 | 14253 | 424 |
506443 | 506443 | 2020-09-06 | East Baton Rouge | Louisiana | 22033 | 14248 | 423 |
503209 | 503209 | 2020-09-05 | East Baton Rouge | Louisiana | 22033 | 14089 | 420 |
499976 | 499976 | 2020-09-04 | East Baton Rouge | Louisiana | 22033 | 14089 | 420 |
496742 | 496742 | 2020-09-03 | East Baton Rouge | Louisiana | 22033 | 13990 | 418 |
493509 | 493509 | 2020-09-02 | East Baton Rouge | Louisiana | 22033 | 13911 | 417 |
490275 | 490275 | 2020-09-01 | East Baton Rouge | Louisiana | 22033 | 13826 | 414 |
487042 | 487042 | 2020-08-31 | East Baton Rouge | Louisiana | 22033 | 13778 | 410 |
483807 | 483807 | 2020-08-30 | East Baton Rouge | Louisiana | 22033 | 13727 | 411 |
480573 | 480573 | 2020-08-29 | East Baton Rouge | Louisiana | 22033 | 13573 | 407 |
477340 | 477340 | 2020-08-28 | East Baton Rouge | Louisiana | 22033 | 13573 | 407 |
474107 | 474107 | 2020-08-27 | East Baton Rouge | Louisiana | 22033 | 13520 | 405 |
470875 | 470875 | 2020-08-26 | East Baton Rouge | Louisiana | 22033 | 13450 | 404 |
467646 | 467646 | 2020-08-25 | East Baton Rouge | Louisiana | 22033 | 13391 | 404 |
464417 | 464417 | 2020-08-24 | East Baton Rouge | Louisiana | 22033 | 13412 | 403 |
461186 | 461186 | 2020-08-23 | East Baton Rouge | Louisiana | 22033 | 13350 | 401 |
457959 | 457959 | 2020-08-22 | East Baton Rouge | Louisiana | 22033 | 13226 | 395 |
454731 | 454731 | 2020-08-21 | East Baton Rouge | Louisiana | 22033 | 13226 | 395 |
451503 | 451503 | 2020-08-20 | East Baton Rouge | Louisiana | 22033 | 13133 | 392 |
448275 | 448275 | 2020-08-19 | East Baton Rouge | Louisiana | 22033 | 13018 | 390 |
445048 | 445048 | 2020-08-18 | East Baton Rouge | Louisiana | 22033 | 12942 | 388 |
441822 | 441822 | 2020-08-17 | East Baton Rouge | Louisiana | 22033 | 12875 | 384 |
438595 | 438595 | 2020-08-16 | East Baton Rouge | Louisiana | 22033 | 12824 | 383 |
435370 | 435370 | 2020-08-15 | East Baton Rouge | Louisiana | 22033 | 12716 | 372 |
432145 | 432145 | 2020-08-14 | East Baton Rouge | Louisiana | 22033 | 12716 | 372 |
428917 | 428917 | 2020-08-13 | East Baton Rouge | Louisiana | 22033 | 12587 | 369 |
425693 | 425693 | 2020-08-12 | East Baton Rouge | Louisiana | 22033 | 12477 | 360 |
422472 | 422472 | 2020-08-11 | East Baton Rouge | Louisiana | 22033 | 12377 | 354 |
419250 | 419250 | 2020-08-10 | East Baton Rouge | Louisiana | 22033 | 12244 | 350 |
416029 | 416029 | 2020-08-09 | East Baton Rouge | Louisiana | 22033 | 12187 | 347 |
412809 | 412809 | 2020-08-08 | East Baton Rouge | Louisiana | 22033 | 11946 | 344 |
409589 | 409589 | 2020-08-07 | East Baton Rouge | Louisiana | 22033 | 11946 | 344 |
406369 | 406369 | 2020-08-06 | East Baton Rouge | Louisiana | 22033 | 11736 | 338 |
403151 | 403151 | 2020-08-05 | East Baton Rouge | Louisiana | 22033 | 11590 | 332 |
399934 | 399934 | 2020-08-04 | East Baton Rouge | Louisiana | 22033 | 11444 | 329 |
396719 | 396719 | 2020-08-03 | East Baton Rouge | Louisiana | 22033 | 11263 | 328 |
393503 | 393503 | 2020-08-02 | East Baton Rouge | Louisiana | 22033 | 11169 | 327 |
390286 | 390286 | 2020-08-01 | East Baton Rouge | Louisiana | 22033 | 10690 | 326 |
387069 | 387069 | 2020-07-31 | East Baton Rouge | Louisiana | 22033 | 10690 | 326 |
383851 | 383851 | 2020-07-30 | East Baton Rouge | Louisiana | 22033 | 10576 | 325 |
380634 | 380634 | 2020-07-29 | East Baton Rouge | Louisiana | 22033 | 10345 | 320 |
377417 | 377417 | 2020-07-28 | East Baton Rouge | Louisiana | 22033 | 10155 | 315 |
374202 | 374202 | 2020-07-27 | East Baton Rouge | Louisiana | 22033 | 9985 | 310 |
370990 | 370990 | 2020-07-26 | East Baton Rouge | Louisiana | 22033 | 9636 | 306 |
367780 | 367780 | 2020-07-25 | East Baton Rouge | Louisiana | 22033 | 9393 | 306 |
364573 | 364573 | 2020-07-24 | East Baton Rouge | Louisiana | 22033 | 9393 | 306 |
361366 | 361366 | 2020-07-23 | East Baton Rouge | Louisiana | 22033 | 9169 | 301 |
358161 | 358161 | 2020-07-22 | East Baton Rouge | Louisiana | 22033 | 8919 | 300 |
354958 | 354958 | 2020-07-21 | East Baton Rouge | Louisiana | 22033 | 8700 | 290 |
351756 | 351756 | 2020-07-20 | East Baton Rouge | Louisiana | 22033 | 8578 | 289 |
348556 | 348556 | 2020-07-19 | East Baton Rouge | Louisiana | 22033 | 8366 | 288 |
345355 | 345355 | 2020-07-18 | East Baton Rouge | Louisiana | 22033 | 8044 | 284 |
342155 | 342155 | 2020-07-17 | East Baton Rouge | Louisiana | 22033 | 8044 | 284 |
338959 | 338959 | 2020-07-16 | East Baton Rouge | Louisiana | 22033 | 7830 | 280 |
335763 | 335763 | 2020-07-15 | East Baton Rouge | Louisiana | 22033 | 7606 | 279 |
332570 | 332570 | 2020-07-14 | East Baton Rouge | Louisiana | 22033 | 7421 | 279 |
329383 | 329383 | 2020-07-13 | East Baton Rouge | Louisiana | 22033 | 7300 | 279 |
326197 | 326197 | 2020-07-12 | East Baton Rouge | Louisiana | 22033 | 7100 | 279 |
323014 | 323014 | 2020-07-11 | East Baton Rouge | Louisiana | 22033 | 6989 | 278 |
319835 | 319835 | 2020-07-10 | East Baton Rouge | Louisiana | 22033 | 6747 | 277 |
316660 | 316660 | 2020-07-09 | East Baton Rouge | Louisiana | 22033 | 6468 | 276 |
313486 | 313486 | 2020-07-08 | East Baton Rouge | Louisiana | 22033 | 6336 | 276 |
310316 | 310316 | 2020-07-07 | East Baton Rouge | Louisiana | 22033 | 6231 | 275 |
307148 | 307148 | 2020-07-06 | East Baton Rouge | Louisiana | 22033 | 5978 | 274 |
303981 | 303981 | 2020-07-05 | East Baton Rouge | Louisiana | 22033 | 5874 | 274 |
300817 | 300817 | 2020-07-04 | East Baton Rouge | Louisiana | 22033 | 5684 | 274 |
297655 | 297655 | 2020-07-03 | East Baton Rouge | Louisiana | 22033 | 5684 | 274 |
294497 | 294497 | 2020-07-02 | East Baton Rouge | Louisiana | 22033 | 5531 | 273 |
291343 | 291343 | 2020-07-01 | East Baton Rouge | Louisiana | 22033 | 5350 | 271 |
288192 | 288192 | 2020-06-30 | East Baton Rouge | Louisiana | 22033 | 5123 | 270 |
285043 | 285043 | 2020-06-29 | East Baton Rouge | Louisiana | 22033 | 5034 | 270 |
281897 | 281897 | 2020-06-28 | East Baton Rouge | Louisiana | 22033 | 4963 | 268 |
278749 | 278749 | 2020-06-27 | East Baton Rouge | Louisiana | 22033 | 4833 | 268 |
275601 | 275601 | 2020-06-26 | East Baton Rouge | Louisiana | 22033 | 4833 | 268 |
272458 | 272458 | 2020-06-25 | East Baton Rouge | Louisiana | 22033 | 4724 | 266 |
269322 | 269322 | 2020-06-24 | East Baton Rouge | Louisiana | 22033 | 4637 | 266 |
266189 | 266189 | 2020-06-23 | East Baton Rouge | Louisiana | 22033 | 4514 | 265 |
263062 | 263062 | 2020-06-22 | East Baton Rouge | Louisiana | 22033 | 4398 | 265 |
259933 | 259933 | 2020-06-21 | East Baton Rouge | Louisiana | 22033 | 4374 | 263 |
256807 | 256807 | 2020-06-20 | East Baton Rouge | Louisiana | 22033 | 4332 | 263 |
253687 | 253687 | 2020-06-19 | East Baton Rouge | Louisiana | 22033 | 4218 | 262 |
250572 | 250572 | 2020-06-18 | East Baton Rouge | Louisiana | 22033 | 4357 | 260 |
247460 | 247460 | 2020-06-17 | East Baton Rouge | Louisiana | 22033 | 4357 | 260 |
244347 | 244347 | 2020-06-16 | East Baton Rouge | Louisiana | 22033 | 4301 | 260 |
241236 | 241236 | 2020-06-15 | East Baton Rouge | Louisiana | 22033 | 4284 | 259 |
238127 | 238127 | 2020-06-14 | East Baton Rouge | Louisiana | 22033 | 4226 | 258 |
235020 | 235020 | 2020-06-13 | East Baton Rouge | Louisiana | 22033 | 4197 | 256 |
231915 | 231915 | 2020-06-12 | East Baton Rouge | Louisiana | 22033 | 4150 | 256 |
228811 | 228811 | 2020-06-11 | East Baton Rouge | Louisiana | 22033 | 4088 | 254 |
225709 | 225709 | 2020-06-10 | East Baton Rouge | Louisiana | 22033 | 4054 | 254 |
222613 | 222613 | 2020-06-09 | East Baton Rouge | Louisiana | 22033 | 4023 | 252 |
219518 | 219518 | 2020-06-08 | East Baton Rouge | Louisiana | 22033 | 3963 | 252 |
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);