ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 22087 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535584 | 535584 | 2020-09-15 | St. Bernard | Louisiana | 22087 | 1339 | 28 |
532349 | 532349 | 2020-09-14 | St. Bernard | Louisiana | 22087 | 1335 | 28 |
529112 | 529112 | 2020-09-13 | St. Bernard | Louisiana | 22087 | 1328 | 28 |
525876 | 525876 | 2020-09-12 | St. Bernard | Louisiana | 22087 | 1317 | 28 |
522640 | 522640 | 2020-09-11 | St. Bernard | Louisiana | 22087 | 1317 | 28 |
519403 | 519403 | 2020-09-10 | St. Bernard | Louisiana | 22087 | 1316 | 28 |
516168 | 516168 | 2020-09-09 | St. Bernard | Louisiana | 22087 | 1310 | 28 |
512935 | 512935 | 2020-09-08 | St. Bernard | Louisiana | 22087 | 1296 | 28 |
509703 | 509703 | 2020-09-07 | St. Bernard | Louisiana | 22087 | 1289 | 28 |
506470 | 506470 | 2020-09-06 | St. Bernard | Louisiana | 22087 | 1284 | 28 |
503236 | 503236 | 2020-09-05 | St. Bernard | Louisiana | 22087 | 1268 | 27 |
500003 | 500003 | 2020-09-04 | St. Bernard | Louisiana | 22087 | 1268 | 27 |
496769 | 496769 | 2020-09-03 | St. Bernard | Louisiana | 22087 | 1257 | 27 |
493536 | 493536 | 2020-09-02 | St. Bernard | Louisiana | 22087 | 1244 | 27 |
490302 | 490302 | 2020-09-01 | St. Bernard | Louisiana | 22087 | 1242 | 27 |
487069 | 487069 | 2020-08-31 | St. Bernard | Louisiana | 22087 | 1238 | 27 |
483834 | 483834 | 2020-08-30 | St. Bernard | Louisiana | 22087 | 1233 | 27 |
480600 | 480600 | 2020-08-29 | St. Bernard | Louisiana | 22087 | 1221 | 26 |
477367 | 477367 | 2020-08-28 | St. Bernard | Louisiana | 22087 | 1221 | 26 |
474134 | 474134 | 2020-08-27 | St. Bernard | Louisiana | 22087 | 1213 | 26 |
470902 | 470902 | 2020-08-26 | St. Bernard | Louisiana | 22087 | 1213 | 25 |
467673 | 467673 | 2020-08-25 | St. Bernard | Louisiana | 22087 | 1203 | 25 |
464444 | 464444 | 2020-08-24 | St. Bernard | Louisiana | 22087 | 1196 | 25 |
461213 | 461213 | 2020-08-23 | St. Bernard | Louisiana | 22087 | 1191 | 25 |
457986 | 457986 | 2020-08-22 | St. Bernard | Louisiana | 22087 | 1169 | 24 |
454758 | 454758 | 2020-08-21 | St. Bernard | Louisiana | 22087 | 1169 | 24 |
451530 | 451530 | 2020-08-20 | St. Bernard | Louisiana | 22087 | 1160 | 24 |
448302 | 448302 | 2020-08-19 | St. Bernard | Louisiana | 22087 | 1152 | 24 |
445075 | 445075 | 2020-08-18 | St. Bernard | Louisiana | 22087 | 1147 | 24 |
441849 | 441849 | 2020-08-17 | St. Bernard | Louisiana | 22087 | 1141 | 24 |
438622 | 438622 | 2020-08-16 | St. Bernard | Louisiana | 22087 | 1136 | 24 |
435397 | 435397 | 2020-08-15 | St. Bernard | Louisiana | 22087 | 1126 | 24 |
432172 | 432172 | 2020-08-14 | St. Bernard | Louisiana | 22087 | 1126 | 24 |
428944 | 428944 | 2020-08-13 | St. Bernard | Louisiana | 22087 | 1125 | 24 |
425720 | 425720 | 2020-08-12 | St. Bernard | Louisiana | 22087 | 1120 | 24 |
422499 | 422499 | 2020-08-11 | St. Bernard | Louisiana | 22087 | 1113 | 24 |
419277 | 419277 | 2020-08-10 | St. Bernard | Louisiana | 22087 | 1109 | 24 |
416056 | 416056 | 2020-08-09 | St. Bernard | Louisiana | 22087 | 1103 | 24 |
412836 | 412836 | 2020-08-08 | St. Bernard | Louisiana | 22087 | 1091 | 24 |
409616 | 409616 | 2020-08-07 | St. Bernard | Louisiana | 22087 | 1091 | 24 |
406396 | 406396 | 2020-08-06 | St. Bernard | Louisiana | 22087 | 1081 | 24 |
403178 | 403178 | 2020-08-05 | St. Bernard | Louisiana | 22087 | 1067 | 24 |
399961 | 399961 | 2020-08-04 | St. Bernard | Louisiana | 22087 | 1058 | 23 |
396746 | 396746 | 2020-08-03 | St. Bernard | Louisiana | 22087 | 1037 | 23 |
393530 | 393530 | 2020-08-02 | St. Bernard | Louisiana | 22087 | 1028 | 23 |
390313 | 390313 | 2020-08-01 | St. Bernard | Louisiana | 22087 | 1001 | 23 |
387096 | 387096 | 2020-07-31 | St. Bernard | Louisiana | 22087 | 1001 | 23 |
383878 | 383878 | 2020-07-30 | St. Bernard | Louisiana | 22087 | 998 | 23 |
380661 | 380661 | 2020-07-29 | St. Bernard | Louisiana | 22087 | 990 | 23 |
377444 | 377444 | 2020-07-28 | St. Bernard | Louisiana | 22087 | 981 | 23 |
374229 | 374229 | 2020-07-27 | St. Bernard | Louisiana | 22087 | 976 | 23 |
371017 | 371017 | 2020-07-26 | St. Bernard | Louisiana | 22087 | 957 | 23 |
367807 | 367807 | 2020-07-25 | St. Bernard | Louisiana | 22087 | 909 | 23 |
364600 | 364600 | 2020-07-24 | St. Bernard | Louisiana | 22087 | 909 | 23 |
361393 | 361393 | 2020-07-23 | St. Bernard | Louisiana | 22087 | 891 | 24 |
358188 | 358188 | 2020-07-22 | St. Bernard | Louisiana | 22087 | 874 | 24 |
354985 | 354985 | 2020-07-21 | St. Bernard | Louisiana | 22087 | 839 | 24 |
351783 | 351783 | 2020-07-20 | St. Bernard | Louisiana | 22087 | 830 | 24 |
348583 | 348583 | 2020-07-19 | St. Bernard | Louisiana | 22087 | 816 | 24 |
345382 | 345382 | 2020-07-18 | St. Bernard | Louisiana | 22087 | 792 | 24 |
342182 | 342182 | 2020-07-17 | St. Bernard | Louisiana | 22087 | 792 | 24 |
338986 | 338986 | 2020-07-16 | St. Bernard | Louisiana | 22087 | 774 | 24 |
335790 | 335790 | 2020-07-15 | St. Bernard | Louisiana | 22087 | 754 | 24 |
332597 | 332597 | 2020-07-14 | St. Bernard | Louisiana | 22087 | 738 | 24 |
329410 | 329410 | 2020-07-13 | St. Bernard | Louisiana | 22087 | 721 | 24 |
326224 | 326224 | 2020-07-12 | St. Bernard | Louisiana | 22087 | 706 | 24 |
323041 | 323041 | 2020-07-11 | St. Bernard | Louisiana | 22087 | 702 | 24 |
319862 | 319862 | 2020-07-10 | St. Bernard | Louisiana | 22087 | 689 | 23 |
316687 | 316687 | 2020-07-09 | St. Bernard | Louisiana | 22087 | 678 | 23 |
313513 | 313513 | 2020-07-08 | St. Bernard | Louisiana | 22087 | 668 | 23 |
310343 | 310343 | 2020-07-07 | St. Bernard | Louisiana | 22087 | 659 | 23 |
307175 | 307175 | 2020-07-06 | St. Bernard | Louisiana | 22087 | 650 | 23 |
304008 | 304008 | 2020-07-05 | St. Bernard | Louisiana | 22087 | 646 | 23 |
300844 | 300844 | 2020-07-04 | St. Bernard | Louisiana | 22087 | 641 | 23 |
297682 | 297682 | 2020-07-03 | St. Bernard | Louisiana | 22087 | 641 | 23 |
294524 | 294524 | 2020-07-02 | St. Bernard | Louisiana | 22087 | 629 | 23 |
291370 | 291370 | 2020-07-01 | St. Bernard | Louisiana | 22087 | 621 | 23 |
288219 | 288219 | 2020-06-30 | St. Bernard | Louisiana | 22087 | 617 | 23 |
285070 | 285070 | 2020-06-29 | St. Bernard | Louisiana | 22087 | 611 | 23 |
281924 | 281924 | 2020-06-28 | St. Bernard | Louisiana | 22087 | 607 | 23 |
278776 | 278776 | 2020-06-27 | St. Bernard | Louisiana | 22087 | 605 | 23 |
275628 | 275628 | 2020-06-26 | St. Bernard | Louisiana | 22087 | 605 | 23 |
272485 | 272485 | 2020-06-25 | St. Bernard | Louisiana | 22087 | 602 | 23 |
269349 | 269349 | 2020-06-24 | St. Bernard | Louisiana | 22087 | 601 | 23 |
266216 | 266216 | 2020-06-23 | St. Bernard | Louisiana | 22087 | 599 | 23 |
263089 | 263089 | 2020-06-22 | St. Bernard | Louisiana | 22087 | 601 | 23 |
259960 | 259960 | 2020-06-21 | St. Bernard | Louisiana | 22087 | 601 | 23 |
256834 | 256834 | 2020-06-20 | St. Bernard | Louisiana | 22087 | 598 | 23 |
253714 | 253714 | 2020-06-19 | St. Bernard | Louisiana | 22087 | 598 | 23 |
250599 | 250599 | 2020-06-18 | St. Bernard | Louisiana | 22087 | 580 | 23 |
247487 | 247487 | 2020-06-17 | St. Bernard | Louisiana | 22087 | 580 | 23 |
244374 | 244374 | 2020-06-16 | St. Bernard | Louisiana | 22087 | 575 | 23 |
241263 | 241263 | 2020-06-15 | St. Bernard | Louisiana | 22087 | 571 | 23 |
238154 | 238154 | 2020-06-14 | St. Bernard | Louisiana | 22087 | 569 | 23 |
235047 | 235047 | 2020-06-13 | St. Bernard | Louisiana | 22087 | 568 | 23 |
231942 | 231942 | 2020-06-12 | St. Bernard | Louisiana | 22087 | 562 | 23 |
228838 | 228838 | 2020-06-11 | St. Bernard | Louisiana | 22087 | 559 | 23 |
225736 | 225736 | 2020-06-10 | St. Bernard | Louisiana | 22087 | 558 | 23 |
222640 | 222640 | 2020-06-09 | St. Bernard | Louisiana | 22087 | 555 | 23 |
219545 | 219545 | 2020-06-08 | St. Bernard | Louisiana | 22087 | 555 | 23 |
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);