AAP Chapters

The American Academy of Pediatrics has quite a few chapters. They are all listed here: [login to view URL] Please note that some links (e.g., Alaska) appear to be broken. In that case, a 30-seconds Google Search (e.g., Alaska American Academy of Pediatrics) should suffice. I need a spreadsheet with two sheets: SHEET 1 - The below information for each chapter: State / Name of chapter / URL of chapter / Contact phone number(s) when available / Contact email(s) / Number of members (if readily available on the website). SHEET 2 - For each chapter, a list of events they are organizing/advertising. The columns would be: State / Name of chapter (matching SHEET 1) / Name of event / Date of Event / URL of event page For example: Alaska / Alaska Chapter of the American Academy of Pediatrics / June 2021 (ongoing) ... / June 2021 / [login to view URL] Alaska / Alaska Chapter of the American Academy of Pediatrics / June 2021 (ongoing) ... / Sept 30, 2021 / [login to view URL] (Note that there are 2 rows here, as there are 2 events listed on the page. Please also note that both events have already taken pace - that's ok, as long as you are comprehensive)