Jak12-3

Extracting financial disclosure reports and police blotter narratives using OpenAI's Structured Output

tl;dr this demo shows how to call OpenAI's gpt-4o-mini model, provide it with URL of a screenshot of a document, and extract data that follows a schema you define. The results are pretty solid even with little effort in defining the data — and no effort doing data prep. OpenAI's API could be a cost-efficient tool for large scale data gathering projects involving public documents.

OpenAI announced Structured Outputs for its API, a feature that allows users to specify the fields and schema of extracted data, and guarantees that the JSON output will follow that specification.

For example, given a Congressional financial disclosure report, with assets defined in a table like this:

Extracting financial disclosure reports and police blotter narratives using OpenAI's Structured Output

tl;dr this demo shows how to call OpenAI's gpt-4o-mini model, provide it with URL of a screenshot of a document, and extract data that follows a schema you define. The results are pretty solid even with little effort in defining the data — and no effort doing data prep. OpenAI's API could be a cost-efficient tool for large scale data gathering projects involving public documents.

OpenAI announced Structured Outputs for its API, a feature that allows users to specify the fields and schema of extracted data, and guarantees that the JSON output will follow that specification.

For example, given a Congressional financial disclosure report, with assets defined in a table like this:

https://www.reddit.com/r/tasker/comments/14e445n/comment/jozkd3t/

yes | pkg upgrade -y

pkg install -y tur-repo x11-repo python-pip

pkg install -y chromium

pip install selenium >

	:: -----------------------------------------------------------------------------------------
	:: Cheat Command Wrapper Script
	:: -----------------------------------------------------------------------------------------
	:: This batch script acts as a wrapper for 'cheat.exe', enhancing its functionality
	:: by allowing more intuitive command-line interactions. Specifically, it:
	::
	:: 1. Directly accesses cheatsheets or tags with a single argument.
	:: 2. Facilitates search within a cheatsheet using multiple arguments, treating them
	:: as a single search query.
	:: 3. Dynamically resolves the paths to the community and personal cheatsheets

	# PowerShell script to disable Windows power management on all currently connected serial ports, including USB adapters
	# In simpler terms, it prevents Windows from turning off connected serial devices to save power.
	# Equivalent to right-clicking on a serial port device in Device Manager > Properties > "Power Management" Tab > Unchecking "Allow the computer to turn off this device to save power."

	$hubs = Get-CimInstance -ClassName Win32_SerialPort \| Select-Object Name, DeviceID, Description
	$powerMgmt = Get-CimInstance -ClassName MSPower_DeviceEnable -Namespace root\wmi

	foreach ($p in $powerMgmt) {
	$IN = $p.InstanceName.ToUpper()
	foreach ($h in $hubs) {

	:: ---- Lines beginning with :: are comments ----
	:: This script is meant to make it easy to transcribe a video file using WhisperCPP.
	:: You can simply drag a video file into the cmd window, then it will use ffmpeg to extract the audio, then transcribe using WhisperCPP and output to a text file.
	::
	@echo off
	set /p videopath="Enter the full path to the video file to transcribe: "

	:: Remove quotes from the input path
	set videopath=%videopath:"=%

	# Script to easily set resource allocation for GPUs to be passed through into a Hyper-V VM
	#
	# Author: ThioJoe / https://github.com/thiojoe
	#
	### Instructions for copying drivers to VM - Will likely need to do this before running this script
	# NOTE: Instead of manually copying the files, if you have an Nvidia GPU you can use my other script called "Copy-GPU-Drivers-VM.ps1" to do it automatically
	# 1. Open C:\Windows\System32 on host machine and copy any files beginning with "nv" (Except nvspinfo.exe and NvAgent.dll , which are unrelated)
	# 2. Place those files into the System32 folder on the VM
	# 3. On the VM, create the following directory: C:\Windows\System32\HostDriverStore\FileRepository
	# 4. For Nvidia GPUs, open C:\Windows\System32\DriverStore\FileRepository, copy any folders beginning with "nv_" (The number of folders should match the number of GPUs, or at least number of different models of GPU)

	blueprint:
	name: Appliance Notifications & Actions
	description: >
	# 📳 Appliance Notifications & Actions

	Version: 3.8


	🤔 Watts your appliance up to, you're always in the know from start to finish! 🛎️🔌💸

	@echo off
	:: Note: Lines beginning with "REM" or :: are comments
	:: Script by: https://github.com/thiojoe
	:: Purpose: Creates a much more user friendly output for the Microsoft Error Lookup Tool (err.exe). It parses the original output and modifies the text.
	:: Usage: Just call the batch file with command prompt along with the error code the same as you would with err.exe
	:: Example: error.bat 50
	:: Recommended to rename this script to something shorter like 'error.bat'. Must be next to the lookup tool exe file.

	case "senddoc":
	if len(args) < 3 {
	log.Errorf("Usage: senddoc <jid> <document path> <title> [mime-type]")
	return
	}
	recipient, ok := parseJID(args[0])
	if !ok {
	return
	}
	data, err := os.ReadFile(args[1])