ChatISA Job Scout Postings: Data Dictionary
Dataset: scout_postings table in scout.db (SQLite), 1,891 rows and 19 columns
Source: ChatISA Job Scout (https://chatisa.fsb.miamioh.edu), postings harvested from public job boards between July 29 and August 23, 2026
Course: ISA 401, Miami University
One row is one job posting. Empty cells are stored as SQL
NULL.
Field Definitions
| Field | Type | Description |
|---|---|---|
id |
text | Primary key. A 36-character UUID that identifies the posting; unique across the table. |
title |
text | Job title exactly as it appeared on the job board (for example "Data Analyst - Remote"). Never empty. |
company |
text | Employer name as posted. Never empty. 1,042 distinct companies. |
location_city |
text | City of the posting (for example "Atlanta"). NULL for 61 rows. |
location_state |
text | Two-letter U.S. state code in upper case (for example "GA"). 46 distinct codes; NULL for 30 rows. |
remote |
integer | 1 if the posting is remote, 0 otherwise (127 remote rows). Stored as an integer, not a boolean. |
Continue the table for the remaining columns (Assignment 05): source, external_id, fingerprint, category, apply_url, description, posted_at, harvested_at, last_seen_at, skills_json, taxonomy_version, active, visa_sponsorship.