Hackathon reference: Big Timber, MT & Tuscaloosa, AL jurisdiction IDs
Open Navigator jurisdiction_id values follow the prefixed bronze convention (see migration 013_add_jurisdiction_id_prefix.sql):
| Type | Pattern | Example |
|---|---|---|
| State | {USPS} | MT, AL |
| County | c-{USPS}-{county_geoid} | c-MT-30097 |
| Municipality (place) | m-{USPS}-{place_geoid} | m-MT-3006475 |
| School district | s-{USPS}-{lea_geoid} | s-AL-0103360 |
Scrape artifacts live under data/cache/scraped_meetings/{USPS}/{type}/... in a local clone (cache is typically gitignored). Links below point at the open-navigator repo tree so you can copy paths or open them after generating data locally.
Big Timber, Montana
| Jurisdiction type | jurisdiction_id | Census / NCES GEOID | Website (discovery / override) | Scraped meetings folder (repo path) |
|---|---|---|---|---|
| State | MT | State FIPS 30 | — | data/cache/scraped_meetings/MT |
| County (Sweet Grass) | c-MT-30097 | County 30097 | sweetgrasscountygov.com (NACO) | .../MT/county/county_30097 |
| City (Big Timber) | m-MT-3006475 | Place 3006475 | cityofbigtimber.com (override) | .../MT/municipality/municipality_3006475 |
| Schools (Sweet Grass County / LEA 3003800) | s-MT-3003800 | District 3003800 | — | .../MT/school/school_district_3003800 |
Sweet Grass area, other NCES LEAs (not this 3003800 folder): NCES directory seed rows include www.co.sweetgrass.mt.us (LEA 3000079, “Sweet Grass” district) and www.sgchs.com (LEA 3025560, Sweet Grass County HS). The hackathon meetings cache path above uses LEA 3003800; see the offline inventory for crawl context.
Tuscaloosa, Alabama
| Jurisdiction type | jurisdiction_id | Census / NCES GEOID | Website (discovery / override) | Scraped meetings folder (repo path) |
|---|---|---|---|---|
| State | AL | State FIPS 01 | — | data/cache/scraped_meetings/AL |
| County (Tuscaloosa) | c-AL-01125 | County 01125 | www.tuscco.com (override; NACO lists http://www.tuscco.com) | .../AL/county/county_01125 |
| City (Tuscaloosa) | m-AL-0177256 | Place 0177256 | www.tuscaloosa.com (League of Cities override; USCM seed http://www.tuscaloosa.com) | .../AL/municipality/municipality_0177256 |
| Schools — Tuscaloosa City | s-AL-0103360 | LEA 0103360 | District tuscaloosacityschools.com; board …/board-of-education; meetings Simbli S=2088 (overrides) | .../AL/school/school_district_0103360 |
| Schools — Tuscaloosa County (TCSS) | s-AL-0103390 | LEA 0103390 | District tcss.net; board …/board-of-education; meetings Simbli S=2092 (overrides) | .../AL/school/school_district_0103390 |
The county commission crawl is county_01125, not the city folder—“Tuscaloosa County” and “City of Tuscaloosa” are separate jurisdictions. Warehouse source id for the city website row: uscm + AL + tuscaloosa (joined with | in the database).
Cache folder names use the legacy suffix form (county_01125, municipality_0177256, …) under data/cache/scraped_meetings/…; jurisdiction_id in bronze uses the prefixed form (c-AL-01125, m-AL-0177256, …).
Related repo notes
- Offline inventory / QA snapshot:
docs/meetings_scrape_big_timber_tuscaloosa_inventory.md