Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

json_pluck_number

Function: json_pluck_number
  Pluck a number value out of a JSON string. The returned value must be a number, otherwise
  an error is returned.

  The path used consists of '.' to access identifiers and '[n]' to
  access the n'th element of arrays.
  For things that

Examples:

  -- Get the true value out of a piece of JSON
  json_pluck_number('{"foo": {"bar": [1, {"baz": 47}, 3]}}', '.foo.bar.[1].baz')
  -- Result: "47"

  -- Quote the identifier using brackets
  json_pluck_number('{"foo-bar": {"baz": 42}}', '.["foo-bar"].baz')
  -- Result: "42"

  -- Quote the identifier using brackets
  json_pluck_number('{"foo-bar": {"baz": 98.6}}', '.["foo-bar"].baz')
  -- Result: "98.6"




Signatures
text, text -> number