This page will help you get started accessing probate data with the Column API.

Probate Notices

A notice of probate is a legal document that announces the death of an individual and the commencement of the probate process. The probate process is the legal process by which a person's assets are distributed after their death, according to the terms of their will or, if they did not leave a will, according to the laws of the state in which they lived. A notice of probate is usually issued by the court handling the probate case, and it may be published in a local newspaper or mailed to interested parties, such as the decedent's heirs or beneficiaries. The notice is meant to inform interested parties of the probate proceedings and allows them to participate in the process if they wish to do so.

🚧

Limited Access

By default Column's API only exposes a limited set of probate notices. To get more access, reach out to [email protected]

Extracting Data from Text or PDFs

If you have access to a notice of probate in text or PDF format, you can use Column's entity extraction algorithms to convert that information into structured data. Entity extraction is a process that involves extracting specific pieces of information, such as names, dates, and addresses, from unstructured text data and organizing them into a structured format, such as a table or spreadsheet.

curl --request POST \
  --url http://utility.column.us/v1/probate/extract \
  --header 'Content-Type: application/json' \
  --data '{
	"text": "NOTICE OF PROBATE ..."
}'

Accessing Foreclosure Notices

Access is currently segmented by state. For example, to access notices in California, you would use the endpoint https://utility.column.us/v1/california/probate

Access follows standard REST guidelines as outlined below.

Listing records

curl --request GET \
  --url 'https://utility.column.us/v1/colorado/probate' \
  --header 'Authorization: Bearer YOUR_TOKEN'

Paginating Responses

Column’s API supports pagination by offset as well as by cursor.

Paginating by offset

# use the page parameter to get the next batch of results
curl --request GET \
  --url 'https://utility.column.us/v1/colorado/probate?page=1' \
  --header 'Authorization: Bearer YOUR_TOKEN'

Paginating by cursor

# use the starting_after parameter to get results after the document with ID 12345
curl --request GET \
  --url 'https://utility.column.us/v1/colorado/probate?starting_after=12345' \
  --header 'Authorization: Bearer YOUR_TOKEN'

# use the ending_before parameter to get results before the document with ID 12345
curl --request GET \
  --url 'https://utility.column.us/v1/colorado/probate?ending_before=12345' \
  --header 'Authorization: Bearer YOUR_TOKEN'

Getting the details of a record

curl --request GET \
  --url 'https://utility.column.us/v1/colorado/probate/1' \
  --header 'Authorization: Bearer YOUR_TOKEN'

Filtering records with query parameters

curl --request GET \
  --url 'https://utility.column.us/v1/colorado/probate?county=Douglas%20County' \
  --header 'Authorization: Bearer YOUR_TOKEN'

Running text search against record contents

Fields available for text search are detailed in the schema below with column “searchable.”

curl --request GET \
  --url 'https://utility.column.us/v1/colorado/probate?search=Text' \
  --header 'Authorization: Bearer YOUR_TOKEN'

Bulk Data Delivery

For questions surrounding bulk data delivery or notice data in multiple states please contact [email protected] with the headline “Accessing Bulk Data.”