ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "West 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 |
---|---|---|---|---|---|---|---|
535602 | 535602 | 2020-09-15 | West Baton Rouge | Louisiana | 22121 | 873 | 41 |
532367 | 532367 | 2020-09-14 | West Baton Rouge | Louisiana | 22121 | 872 | 41 |
529130 | 529130 | 2020-09-13 | West Baton Rouge | Louisiana | 22121 | 873 | 41 |
525894 | 525894 | 2020-09-12 | West Baton Rouge | Louisiana | 22121 | 871 | 41 |
522658 | 522658 | 2020-09-11 | West Baton Rouge | Louisiana | 22121 | 871 | 41 |
519421 | 519421 | 2020-09-10 | West Baton Rouge | Louisiana | 22121 | 864 | 40 |
516186 | 516186 | 2020-09-09 | West Baton Rouge | Louisiana | 22121 | 855 | 40 |
512953 | 512953 | 2020-09-08 | West Baton Rouge | Louisiana | 22121 | 852 | 40 |
509721 | 509721 | 2020-09-07 | West Baton Rouge | Louisiana | 22121 | 851 | 40 |
506488 | 506488 | 2020-09-06 | West Baton Rouge | Louisiana | 22121 | 852 | 39 |
503254 | 503254 | 2020-09-05 | West Baton Rouge | Louisiana | 22121 | 841 | 39 |
500021 | 500021 | 2020-09-04 | West Baton Rouge | Louisiana | 22121 | 841 | 39 |
496787 | 496787 | 2020-09-03 | West Baton Rouge | Louisiana | 22121 | 839 | 39 |
493554 | 493554 | 2020-09-02 | West Baton Rouge | Louisiana | 22121 | 838 | 39 |
490320 | 490320 | 2020-09-01 | West Baton Rouge | Louisiana | 22121 | 829 | 39 |
487087 | 487087 | 2020-08-31 | West Baton Rouge | Louisiana | 22121 | 833 | 39 |
483852 | 483852 | 2020-08-30 | West Baton Rouge | Louisiana | 22121 | 832 | 39 |
480618 | 480618 | 2020-08-29 | West Baton Rouge | Louisiana | 22121 | 826 | 39 |
477385 | 477385 | 2020-08-28 | West Baton Rouge | Louisiana | 22121 | 826 | 39 |
474152 | 474152 | 2020-08-27 | West Baton Rouge | Louisiana | 22121 | 820 | 38 |
470920 | 470920 | 2020-08-26 | West Baton Rouge | Louisiana | 22121 | 814 | 38 |
467691 | 467691 | 2020-08-25 | West Baton Rouge | Louisiana | 22121 | 809 | 38 |
464462 | 464462 | 2020-08-24 | West Baton Rouge | Louisiana | 22121 | 787 | 38 |
461231 | 461231 | 2020-08-23 | West Baton Rouge | Louisiana | 22121 | 787 | 38 |
458004 | 458004 | 2020-08-22 | West Baton Rouge | Louisiana | 22121 | 771 | 38 |
454776 | 454776 | 2020-08-21 | West Baton Rouge | Louisiana | 22121 | 771 | 38 |
451548 | 451548 | 2020-08-20 | West Baton Rouge | Louisiana | 22121 | 766 | 38 |
448320 | 448320 | 2020-08-19 | West Baton Rouge | Louisiana | 22121 | 766 | 37 |
445093 | 445093 | 2020-08-18 | West Baton Rouge | Louisiana | 22121 | 761 | 37 |
441867 | 441867 | 2020-08-17 | West Baton Rouge | Louisiana | 22121 | 757 | 37 |
438640 | 438640 | 2020-08-16 | West Baton Rouge | Louisiana | 22121 | 756 | 37 |
435415 | 435415 | 2020-08-15 | West Baton Rouge | Louisiana | 22121 | 754 | 37 |
432190 | 432190 | 2020-08-14 | West Baton Rouge | Louisiana | 22121 | 754 | 37 |
428962 | 428962 | 2020-08-13 | West Baton Rouge | Louisiana | 22121 | 745 | 37 |
425738 | 425738 | 2020-08-12 | West Baton Rouge | Louisiana | 22121 | 734 | 37 |
422517 | 422517 | 2020-08-11 | West Baton Rouge | Louisiana | 22121 | 727 | 37 |
419295 | 419295 | 2020-08-10 | West Baton Rouge | Louisiana | 22121 | 722 | 37 |
416074 | 416074 | 2020-08-09 | West Baton Rouge | Louisiana | 22121 | 720 | 37 |
412854 | 412854 | 2020-08-08 | West Baton Rouge | Louisiana | 22121 | 701 | 37 |
409634 | 409634 | 2020-08-07 | West Baton Rouge | Louisiana | 22121 | 701 | 37 |
406414 | 406414 | 2020-08-06 | West Baton Rouge | Louisiana | 22121 | 689 | 36 |
403196 | 403196 | 2020-08-05 | West Baton Rouge | Louisiana | 22121 | 678 | 36 |
399979 | 399979 | 2020-08-04 | West Baton Rouge | Louisiana | 22121 | 675 | 36 |
396764 | 396764 | 2020-08-03 | West Baton Rouge | Louisiana | 22121 | 661 | 36 |
393548 | 393548 | 2020-08-02 | West Baton Rouge | Louisiana | 22121 | 655 | 36 |
390331 | 390331 | 2020-08-01 | West Baton Rouge | Louisiana | 22121 | 613 | 36 |
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 |
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);