Bigquery JS Frameworks

gistfile1.sql

SELECT COUNT(*)
FROM [githubarchive:github.timeline]
WHERE repository_language == "JavaScript"
  AND type == "CreateEvent"
  AND (
    LOWER(repository_description) CONTAINS "framework" AND (
      LOWER(repository_description) CONTAINS "mvc" OR
      LOWER(repository_description) CONTAINS "mvvm" OR
      LOWER(repository_description) CONTAINS "mvp" OR
      LOWER(repository_description) CONTAINS "mv*"
    )
  )
  AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2013-01-01 00:00:00');