I'd like to know which bible verses were popular on twitter on Valentine's Day - 2013. I've added elasticsearch support to my project habakkuk to store religious tweets for analysis. It turns out to be a collection of love scriptures. Very Nice!

Results

1. John 3:16  "For God so loved the world that he gave his one and only Son, that whoever believes in him shall not perish but have eternal life."
2. 1  John 4:19 "We love because he first loved us."
3. 1 Corinthians 13:4 "Love is patient, love is kind. It does not envy, it does not boast, it is not proud."
4. 1 Corinthians 13:13 "And now these three remain: faith, hope and love. But the greatest of these is love."
5. John 14:23  "Jesus replied, “Anyone who loves me will obey my teaching. My Father will love them, and we will come to them and make our home with them."
6. Psalm 37:23 "The steps of a good man are ordered by the Lord: and he delighteth in his way."
7. John 15:13 "Greater love has no one than this: to lay down one’s life for one’s friends."
8. 1 Corinthians 13:7  "[Love]  always protects, always trusts, always hopes, always perseveres."
9. Philippians 4:13 "I can do all this through him who gives me strength."
10. Romans 5:8 "But God demonstrates his own love for us in this: While we were still sinners, Christ died for us."

Technical Details

To get the data for Valentines day 2013, I execute the following

$ python bible_facet.py -s 2013-02-14 -e 2013-02-15

It shows the raw query json for the Elasticsearch Query DSL. Below that it shows the top 10 bible references. Its basically just a faceted search on the bibleverse field.

    {
      "query": {
        "filtered": {
          "filter": {
            "range": {
              "created_at_date": {
                "to": "2013-02-15T00:00:00",
                "include_upper": false,
                "from": "2013-02-14T00:00:00"
              }
            }
          },
          "query": {
            "match_all": {}
          }
        }
      },
      "facets": {
        "bibleverse": {
          "terms": {
            "field": "bibleverse",
            "order": "count",
            "size": 10
          }
        }
      },
      "size": 0
    }

Total bibleverse 1568
  john 3:16 85
  i_john 4:19 42
  i_corinthians 13:4 31
  i_corinthians 13:13 24
  john 14:23 19
  psalm 37:23 18
  john 15:13 18
  i_corinthians 13:7 18
  philippians 4:13 17
  romans 5:8 15

 

Project Details

Please reference the elasticsearch readme in habakkuk for details regarding the query that obtained this data. Special thanks to http://www.biblegateway.com for the NIV Bible text. I should also shout out to openbible.info, his twitter Lent blog is awesome.