mytown-research
Data license: CC BY 4.0 · Data source: MyTown
Queries
- New Orleans: what a public body paid a vendor (try: amazon, meta, entergy)
- Louisiana: who is registered to lobby for a company (try: meta platforms, entergy)
- Louisiana: what lobbyists reported spending on a named official (try: new orleans)
- Federal PAC money into one state (try: LA, then filter by committee)
- Surveillance tech: line items for one vendor (try: axon, flock, clearview)
- Reporter search: a surveillance vendor across towns and time
- Reporter search: surveillance company family (parent + acquired brands)
- Reporter notebook: surveillance expansion, switching, and intercept leads
- Reporter search: unusual surveillance technology
- Surveillance tech: the CONSERVATIVE total (deduped, stated amounts only)
- Surveillance tech: data-quality report (read this before quoting anything)
- Surveillance tech: totals by technology category
- Surveillance tech: largest dollar figures found (NOT confirmed payments)
- Surveillance tech: by state (conservative, deduped)
- Surveillance tech: everything one city bought (search by city)
- Vendor awards, contracts and payments (federal + local, DO NOT SUM)
- Vendor totals by record type (run this BEFORE quoting any vendor total)
- How a town's council voted (search by town name)
- Search the staff-report text (find buried unit counts, dollar figures)
- Largest campaign contributions to a recipient
- A Texas district's STAAR %Meets over time (search by district)
- A Texas district's spending by category, latest year (search by district)
- A school district's board decisions next to its proficiency (search by district)
- Towns with a RECORDED VOTE adopting a data center moratorium (blank = all)
Tables
_export_progress
tbl, cols, keycols, resumable, last_key, rows_done, pg_count, done, updated_at
71 rows
air_quality
muni_id, county_fips, county_name, state, year, days_with_aqi, good_days, moderate_days, days_unhealthy, max_aqi, p90_aqi, median_aqi, source_url, data_license, updated_at
231 rows
assisted_contracts
contract_number, property_id, muni_id, match_method, place_geoid, property_name, address, city, state, zip, county_fips, county_name, msa_name, congressional_district, contract_status, contract_effective_date, contract_expiration_date, current_expiration_date, expiration_fiscal_year, expiration_quarter, contract_term_months, assisted_units, property_total_units, program_type, program_group, contract_doc_type, hud_administered, performance_based_acc, rent_to_fmr_ratio, rent_to_fmr_bucket, units_0br, units_1br, units_2br, units_3br, units_4br, units_5plus_br, property_category, primary_financing_type, is_insured, is_202_811, is_236, is_bmir, is_hud_held, is_hud_owned, is_opportunity_zone, ownership_effective_date, owner_company_type, owner_organization, owner_city, owner_state, mgmt_agent_organization, expired_but_active, as_of_date, source, source_url, updated_at, property_units_overallocated
24,308 rows
audit_findings
source, report_number, finding_number, muni_id, state, entity_name, entity_type, entity_ext_id, place_geoid, match_method, auditor, report_title, audit_type, fiscal_year, period_start, period_end, published_date, finding_category, severity, questioned_cost, cost_basis, finding_title, finding_text, report_url, fetched_at
2,588 rows
bps_permits
muni_id, year, month, units_total, units_1unit, units_2unit, units_34unit, units_5plus, valuation, source_url, updated_at
4,280 rows
briefs
meeting_id, status, model, headline, summary, notable, tags, agenda_chars, created_at
1,318,271 rows
business_formations
uid, grain, muni_id, city, state, county, period, seasonally_adj, applications_total, high_propensity, entity_id, business_name, entity_type, entity_type_code, entity_status, formation_date, address, source, source_url, updated_at
3,105,341 rows
census_demographics
muni_id, population, median_income, housing_units, updated_at, median_home_value, per_capita_income, pct_hs_plus, pct_bachelors_plus
5,520 rows
cf_transactions
id, source, level, state, txn_type, filer_name, filer_id, office, counterparty_name, counterparty_type, employer, occupation, city, region, zip, amount, txn_date, election_cycle, report_id, external_id, updated_at
45,636,350 rows
civic_records
civic_source_id, muni_id, kind, record_no, address, rec_type, description, applicant, value, applied_date, issued_date, status, official_url, fetched_at
213,049 rows
college_stats
id, name, city, state, muni_id, year, enrollment, tuition_in, tuition_out, admission_rate, completion_rate, total_revenue, faculty_salary_avg, median_earnings, source, source_url, updated_at
6,119 rows
debt_issues
cdiac_number, muni_id, match_method, state, issuer, issuer_qualifier, issuer_group, issuer_type, issuer_county, place_geoid, county_fips, sold_status, issue_name, project_name, sale_date, settlement_date, calendar_year, principal_amount, new_money, refunding_amount, net_oid_premium, principal_outstanding_adtr, proceeds_unspent_adtr, adtr_last_reported_year, adtr_filing_status, debt_type, primary_purpose, primary_purpose_pct, source_of_repayment, tax_status, tax_exempt_amount, taxable_amount, labeled_debt_type, sale_type, private_placement, tic_rate, nic_rate, interest_type, senior_or_subordinate, first_optional_call_date, final_maturity_date, statutory_authority, local_debt_policy, marks_roos_authority, marks_roos_obligor, total_issuance_costs, lead_underwriter, underwriter_takedown, underwriter_mgmt_fee, underwriter_expenses, financial_advisor, financial_advisor_fee, bond_counsel, bond_counsel_fee, co_bond_counsel, co_bond_counsel_fee, disclosure_counsel, disclosure_counsel_fee, trustee_paying_agent, trustee_paying_agent_fee, placement_agent, placement_agent_fee, purchaser_or_lender, other_issuance_expenses, credit_enhancement_type, credit_enhancement_provider, credit_enhancement_fee, sp_rating, moodys_rating, fitch_rating, filing_contact, official_statement_url, official_statement_title, document_count, source, source_url, updated_at
77,086 rows
decision_geo
meeting_id, address, lat, lon, building_height_m, building_floors, building_name, building_class, building_subtype, flood_zone, flood_subtype, in_flood_zone, updated_at
11,326 rows
decisions
meeting_id, status, model, headline, summary, decisions, tags, minutes_chars, created_at
486,268 rows
dot_projects
id, source, state, external_id, muni_id, name, description, project_type, route, city, county, cost, program_year, status, is_highway, lat, lon, official_url, fetched_at
44,747 rows
election_results
id, muni_id, place_name, state, county, office, election_date, candidate_name, party, votes, total_votes_in_race, is_winner, term_years, source, source_url, created_at, election_type, match_method
75,388 rows
energy_plants
muni_id, plant_id, plant_name, state, county, latitude, longitude, primary_fuel, capacity_mw, generation_mwh, match_kind, distance_km, period, source, updated_at, county_fips
40,342 rows
evictions
muni_id, fips, geography_level, county_name, state, year, data_type, filings, judgments, threatened, filing_rate, source_url, data_license, updated_at
84,645 rows
fac_audits
report_id, audit_year, fy_start_date, fy_end_date, auditee_name, auditee_uei, auditee_ein, auditee_city, auditee_zip, auditee_state_reported, state, state_source, entity_form, core_name, muni_id, muni_slug, census_geoid, match_method, city_name_agrees, total_amount_expended, amount_context, dollar_threshold, audit_type, audit_period_covered, number_months, gaap_results, is_going_concern, is_material_weakness, is_control_deficiency, is_material_noncompliance, is_low_risk_auditee, auditor_firm_name, auditor_ein, oversight_agency, cognizant_agency, submitted_date, fac_accepted_date, resubmission_version, resubmission_status, is_primary_for_period, is_public, data_source, source_url, fetched_at, muni_year_siblings
170,436 rows
fac_findings
report_id, reference_number, audit_year, auditee_uei, auditee_name, state, entity_form, muni_id, muni_slug, match_method, award_count, award_refs, is_material_weakness, is_significant_deficiency, is_questioned_costs, is_repeat_finding, is_modified_opinion, is_other_findings, is_other_matters, prior_finding_ref_numbers, type_requirement, finding_text, finding_text_chars, contains_chart_or_table, questioned_costs_amount, questioned_costs_context, questioned_costs_basis, source_url, fetched_at
50,666 rows
fec_candidates
cycle, cand_id, cand_name, cand_pty_affiliation, cand_election_yr, cand_office_st, cand_office, cand_office_district, cand_ici, cand_status, cand_pcc, cand_st1, cand_st2, cand_city, cand_st, cand_zip, updated_at
65,455 rows
fec_committee_links
cycle, linkage_id, cand_id, cand_election_yr, fec_election_yr, cmte_id, cmte_tp, cmte_dsgn, updated_at
62,332 rows
fec_committees
cycle, cmte_id, cmte_nm, tres_nm, cmte_st1, cmte_st2, cmte_city, cmte_st, cmte_zip, cmte_dsgn, cmte_tp, cmte_pty_affiliation, cmte_filing_freq, org_tp, connected_org_nm, cand_id, updated_at
156,474 rows
fema_grants
gm_project_id, disaster_number, declaration_date, incident_type, pw_number, application_title, applicant_id, applicant_name, applicant_kind, muni_id, match_method, place_geoid, damage_category_code, damage_category, project_status, project_process_step, project_size, county, county_fips, state, project_amount_estimate, federal_share_obligated, total_obligated, mitigation_amount, first_obligation_date, last_obligation_date, source, source_url, data_license, updated_at
846,627 rows
fiscal_health
muni_id, fiscal_year, population, total_revenue, total_expenditure, debt_outstanding, debt_per_capita, debt_to_revenue, operating_margin, tax_reliance, intergov_reliance, pct_debt_to_revenue, pct_debt_per_capita, pct_deficit, pct_intergov_reliance, debt_load_index, debt_load_band, structural_deficit, source_url, updated_at
2,409 rows
fiscal_stress_official
muni_id, state, year, stress_score, stress_label, source, source_url, updated_at
49 rows
food_inspections
muni_id, establishment_name, address, inspection_date, result, score, violations_summary, source_domain, source_id, source_row_id, source_url, updated_at
10,413,182 rows
gov_contracts
muni_id, source_row_id, vendor_name, description, amount, award_date, start_date, end_date, contract_number, department, status, source_domain, dataset_id, source_url, updated_at
1,767,320 rows
gov_payments
id, source, record_type, muni_id, state, payee, amount, txn_date, end_date, category, object_type, purpose, funding_source, site, fiscal_period, source_url, external_id, updated_at, payer_level
1,483,357 rows
lihtc_projects
hud_project_id, muni_id, match_method, state, project_name, address, std_address, city, zip, place_geoid2020, county_fips, total_units, low_income_units, credit_type, construction_type, tax_exempt_bond, allocation_year, placed_in_service_year, allocated_credit_annual, allocated_credit_suspect, nonprofit_sponsor, aff_period_gt30, affordability_years, affordability_expiration, no_longer_monitored, nlm_reason, qct, dda, latitude, longitude, state_project_id, source, source_url, updated_at
55,345 rows
literacy
muni_id, county_fips, county_name, state, pct_low_literacy, pct_low_numeracy, year, source, updated_at
4,457 rows
lobbying_expenditures
id, source, state, muni_id, lobbyist_name, client_name, recipient_name, recipient_role, expense_date, year, amount, expense_type, description, source_url, external_id, updated_at
786,235 rows
lobbying_registrations
id, source, state, muni_id, lobbyist_name, client_name, year, compensation, source_url, external_id, updated_at, branch, paid, date_from, date_to, registrant_name, issue_codes, specific_issues
4,518,278 rows
local_sales_tax
muni_id, state, period_month, amount, tax_type, source, source_url, updated_at
51,997 rows
ma_election_results
id, source, state, election_id, election_date, office, district, stage, muni_id, city_town, ward, precinct, candidate, party, is_aggregate, votes, total_votes_in_race, source_url, external_id, updated_at
87,307 rows
matters
id, meeting_id, muni_id, matter_type, title, case_no, address, action, staff_rec, outcome, vote, units, affordable_units, height_ft, sqft, acreage, parking, est_value, conditions, lat, lon, source, model, created_at, att_id
31,917 rows
meeting_attachments
meeting_id, source_url, kind, matter_id, item_title, text, chars, ocr_needed, r2_key, fetched_at, extract_lane
691,746 rows
meetings
id, muni_id, source_id, body_name, meeting_date, meeting_time, location, agenda_url, minutes_url, video_url, detail_url, fetched_at, r2_key, archived_at, archive_status
2,034,849 rows
member_votes
id, meeting_id, muni_id, body_name, motion, member_name, vote, source, model, created_at, contested
4,819,245 rows
mobility_outcomes
geo_level, fips, muni_id, subgroup, metric, value, value_se, source, source_url, license, updated_at
33,747 rows
muni_debt
muni_id, state, gov_type, fiscal_year, debt_type, debt_outstanding, debt_service, debt_per_capita, source, source_url, updated_at
2,836 rows
muni_financials
muni_id, state, fiscal_year, gov_type, revenue_total, revenue_tax, revenue_intergov, expenditure_total, debt_outstanding, fund_balance, population, source, source_url, updated_at
4,824 rows
municipalities
id, slug, name, state, platform, body_count, added_at, last_fetched, country, kind
8,372 rows
nonprofits
ein, name, city, state, ntee_code, category, tax_year, total_revenue, total_expenses, total_assets, exec_comp_top, form_type, source, source_url, updated_at
50 rows
official_disclosures
id, source, state, muni_id, official_name, role, disclosure_year, income_summary, source_url, external_id, updated_at
1,065,786 rows
official_elections
muni_id, member_name, matched_candidate, office, election_date, votes, is_winner, source, match_method, total_votes_in_race, election_type, created_at
1,580 rows
officials
id, muni_id, body_name, name, role, first_seen_date, last_seen_date, meeting_count, updated_at
237 rows
openmeetings_findings
finding_id, state, muni_id, entity_name, body_name, body_kind, body_scope, body_scope_norm, attribution, county, determination_number, determination_date, action_type, statute, finding, finding_raw, remedy, document_id, source, source_url, updated_at
4,073 rows
pension_state
state, year, govtype, govtype_label, total_holdings, total_contributions, gov_contributions, employee_contributions, total_benefits_paid, num_systems, total_membership, beneficiaries, holdings_to_benefits, gov_contrib_share, source_url, updated_at
96 rows
people
person_id, canonical_name, muni_id, body_name, role, first_seen_vote, last_seen_vote, n_votes, n_meetings, aliases, sources, confidence, match_method, updated_at
20,469 rows
people_cf_bridge
person_id, cf_source, cf_filer_key, cf_filer_name, cf_filer_id, muni_id, office, n_txns, match_method, confidence, evidence, updated_at
283 rows
people_cf_candidates
cf_source, cf_filer_key, cf_filer_name, muni_id, office, n_txns, person_id, candidate_person_ids, reason, status, evidence, updated_at
17 rows
person_vote_stats
person_id, muni_id, canonical_name, n_votes, n_yea, n_nay, n_abstain, n_present, n_absent, n_other, n_meetings, n_decided, n_contested, n_dissents, dissent_rate, attendance_rate, first_seen_vote, last_seen_vote, updated_at
20,469 rows
police_stops_rollup
muni_id, agency, state, geography, year, race, n_stops, n_searches, n_arrests, n_contraband, n_citations, search_rate, hit_rate, arrest_rate, source, source_url, data_license, citation, updated_at
2,384 rows
professional_licenses
row_id, state, board, license_type, licensee_name, business_name, license_no, status, issue_date, expiry_date, disciplinary_flag, city, muni_id, source, source_url, updated_at
7,831,348 rows
property_sales
state, parcel_id, muni_id, address, owner, sale_price, sale_date, assessed_value, land_value, land_use, source, source_url, updated_at
38,935 rows
public_salaries
muni_id, dataset_id, record_id, employee_name, job_title, department, base_pay, overtime, total_pay, year, redacted, source_domain, source_url, updated_at
3,539,791 rows
school_stats
muni_id, leaid, enrollment, teachers_fte, schools_count, per_pupil_spending, revenue_total, year, updated_at, read_pct_proficient, math_pct_proficient, frpl_pct, assessment_year
965 rows
service_requests_recent
muni_id, dataset_id, request_id, category, status, created_date, source_domain, updated_at
100 rows
service_requests_rollup
muni_id, category, period_month, count, source_domain, source_url, dataset_id, updated_at
6,898 rows
settlements
id, candidate_id, meeting_id, muni_id, city, state, country, meeting_date, body_name, category, claimant, defendant, amount, amount_type, case_no, court, incident_summary, settlement_date, funding_source, quote, snippet, source, source_document, mytown_record, model, grounded, dup_rank, created_at
2,468 rows
staar_results
muni_id, year, grade, subject, approaches_pct, meets_pct, masters_pct, updated_at
53,631 rows
state_bills
state, session, bill_id, openstates_id, title, classification, subjects, status, latest_action_date, sponsors, source_url, updated_at
1,454,904 rows
state_legislators
openstates_id, state, name, party, district, chamber, current, source_url, updated_at
21,596 rows
state_votes
vote_id, state, session, bill_id, motion, classification, result, vote_date, chamber, yes_count, no_count, other_count, source_url, updated_at, member_vote_count
1,175,161 rows
surveillance_spending
vendor, city, state, spend_date, product, amount, quote, source_document, mytown_record, ledger, amount_type, dup_rank, geo_suspect, anomaly, state_norm
4,390 rows
usda_rd_properties
borrower_id, project_id, project_check_digit, mfis_key, muni_id, match_method, place_geoid, cousub_geoid, county_fips, report_date, property_name, city, state, zip, latitude, longitude, total_units, vacant_units, rental_assistance_units, rental_type, section_program, revitalization, tax_credit, tax_credit_expires, management_name, borrower_name, borrower_type, borrower_city_state, estimated_exit_date, estimated_exit_year, restrictive_clause_expires_year, loan_payoff_year, prepay_eligible, prepay_eligible_year, fy_of_loan_obligation, interest_rate_at_closing, loan_amount, balloon_payment, remaining_term_days, orig_loan_term_years, natural_maturity_date, upb_maturity_date, date_of_operation, source, source_url, data_license, updated_at
12,420 rows
warn_notices
uid, state, employer, city, county, muni_id, num_affected, notice_date, effective_date, layoff_type, reason, source, source_url, updated_at
2,827 rows
water_violations
muni_id, pwsid, system_name, state, city_served, county_served, population_served, year, violation_count, health_based_count, source_url, data_license, updated_at
32,661 rows
... and 25 hidden tables
Download SQLite DB: mytown-research.db 39.2 GB