search

sebsto / meetup-crawler

A serverless crawler of meetup.com data for analytics purposes
3 stars 1 forks source link

Include region name in the group table #1

Open sebsto opened 4 years ago

sebsto commented 4 years ago

One thing that I believe we are missing is the region attached to the user group (EMEA, APJC…) – can I do anything to help with adding that info?

sebsto commented 4 years ago

Meetup does not provide that information. So we would need to build a mapping table (country => region) That’s something I can create a database level and then include that in the main table. So you would have an additional column available for you in the Group tables.

Would that be a good solution ?

What are the region list you want me to map ?

sebsto commented 4 years ago

Proposed region list to use :

  1. NAMER
  2. LATAM
  3. Europe
  4. Middle East & Africa
  5. APAC
  6. GCR
  7. Japan
sebsto commented 4 years ago

Countries :

eetupcrawler=> select distinct country from meetup_group_latest; country

AE AL AR AT AU BA BD BE BG BH BR BY CA CH CL CN CO CR CZ DE DK DO DZ EE EG ES FI FR GB GE GH GI GR GT HK HR HU IE IL IN IT KE KR LB LK LU MA ME MT MW MX NG NL NO NP NZ PA PE PH PL PT RO RS RU SA SE SG SI SK SV TR UA US UY VE XK ZA (77 rows)