Skip to main content

Public-good ideas

Evidence-first public records explorer​

Opportunity: Use DataStitcher public audit source ingestion to create a source-attributed explorer of official public records.

Existing support:

  • DataStitcher public audit source registry.
  • GCS/BigQuery ingestion pattern.
  • Publication policy and evidence wording.

First useful version:

  • Show source coverage, official resources, download provenance, and source caveats.
  • Avoid entity judgement; show evidence and source links.

Risk:

  • Wording must not imply misconduct from raw public records.

Search Before You Share​

Opportunity: A simple public claim-search tool from Bollocks Radar.

Existing support:

  • Google Fact Check ingestion docs.
  • Verdict normalisation.
  • Claim cluster and publisher model.

First useful version:

  • Search claim text and show matching fact-check reviews with source links and clear "unknown if no match" wording.

Risk:

  • No-match and source-coverage caveats must be unavoidable.

Public dataset freshness board​

Opportunity: Use BigQuery Atlas and DataStitcher to show when public datasets were last observed, changed, or failed validation.

Existing support:

  • BigQuery Atlas metadata cataloguing.
  • DataStitcher source monitor/run model.

First useful version:

  • A small board for known Australian public datasets and public BigQuery datasets.

Risk:

  • "Stale" needs source-specific rules and should not imply official failure without evidence.

Website safety basics for community organisations​

Opportunity: A free SiteIntel-derived checker for small non-profits, clubs, and community groups.

Existing support:

  • DNS, TLS, HTTP, robots, homepage, auxiliary file, and PageSpeed checks.
  • Plain-English report strategy.

First useful version:

  • Homepage availability, TLS expiry, HTTPS, DMARC/SPF hints, noindex, contact page, and basic performance.

Risk:

  • Must avoid security-scanner positioning and keep remediation advice simple.

Public BigQuery catalogue​

Opportunity: Keep BigQuery Atlas public catalogue useful as a free research/developer tool.

Existing support:

  • Evidence-backed candidate discovery.
  • Cautious cataloguer.
  • Cloudflare D1/R2 read cache.

First useful version:

  • Search known public projects/datasets, show schema summaries, show last successful check.

Risk:

  • Large projects and permission errors need clear status explanations.

Sources consulted​

  • projects/data-stitcher/docs/public-audit-sources.md
  • projects/bollocks-radar/docs/reference/technical/google-fact-check-ingestion.mdx
  • projects/bq-atlas/services/public-cataloguer/README.md
  • projects/site-intel/docs/overview/product/product-overview.mdx