Public record
Software health reportschema 0.27.0 · metrics 1.13.0 · 2026-07-25 21:27 UTC

okfn-brasil / querido-diario-api

This is Querido Diário's API. It provides everything the frontend does and even more!

PythonMIT★ 60 stars⑂ 34 forkssince Aug 2020View on GitHub ↗

okfn-brasil/querido-diario-api holds a health index of 61 out of 100, placing it in the Moderate band. It scores highest on Engineering Quality (74/100) and lowest on Security (38/100). It was last updated 9 days ago. A single contributor accounts for most of its recent work.

61
overall / 100
Moderate

Software health index

Metrics are grouped into weighted categories on one standardized 1–100 scale. Overall starts as their weighted mean; when public evidence triggers the High-Risk Jurisdiction Policy, the rating is adjusted and receives an At risk ceiling of 49. AI Readiness sits outside the overall score.

61
Excellent85-100Exemplary; meets essentially all checked criteria
Good70-84Healthy; minor gaps
Moderate50-69Acceptable with notable gaps; review recommended
At risk30-49Significant weaknesses; adoption warrants caution
Critical1-29Severe problems (abandoned, single-maintainer, no hygiene)
VitalityCommunity &AdoptionSustainability &GovernanceEngineeringQualitySecurityAI Readiness

Score profile

Each axis is a category. The shape matters more than the average — a healthy subject fills the whole shape, while a spike-and-crater profile means strength in one dimension is masking risk in another.

Ownership

546 followers119 public repossince Apr 2012

This repository is backed by an organization — shared, accountable stewardship that can outlive any single maintainer.

Metrics by category

Vitality

Is the project alive — is code being written and are releases shipping?

67Moderate · 22% of overall
How it's scored
28.8/36Push recency — last push 9 days ago
4.2/36Commit cadence — 6/52 weeks with commits
12.7/18Commit volume — 25 commits in the last year
9/10OpenSSF Scorecard: Maintained — 11 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 9
Inputs used
commits_last_year25
human_commit_share1
days_since_last_push9
active_weeks_last_year6
How it's scored
27/27Ships releases — 7 releases published
36/36Release recency — latest release 9 days ago
12.6/27Release cadence — a release every ~246.1 days
0/10OpenSSF Scorecard: Signed-Releases — no data
Inputs used
releases_count7
latest_release_tagv0.22.8
releases_from_tagsno
days_since_latest_release9
mean_days_between_releases246.1
Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.

Community & Adoption

Does the project have users, downloads, attention, and a welcoming setup for contributors?

65Moderate · 18% of overall
How it's scored
28.7/60Stars — 60 stars
12.7/25Forks — 34 forks
6.2/15Watchers — 14 watchers
Inputs used
forks34
stars60
watchers14
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Community health

85Excellent
How it's scored
22.5/22.5README
22.5/22.5License — recognized license (MIT)
18/18CONTRIBUTING guide
13.5/13.5Code of conduct
0/7.2Issue template
0/6.3PR template
Inputs used
has_readmeyes
has_licenseyes
has_contributingyes
has_issue_templateno
has_code_of_conductyes
has_pull_request_templateno

Sustainability & Governance

Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?

58Moderate · 24% of overall
How it's scored
9/54Bus factor — 1 contributor(s) cover half of all commits
11.1/22.5Commit distribution — top contributor authored 51% of commits
13.5/13.5Contributor breadth — 13 contributors
10/10OpenSSF Scorecard: Contributors — project has 16 contributing companies or organizations
Inputs used
bus_factor1
contributors_sampled13
top_contributor_share0.508
How it's scored
20.7/46.8Issue resolution — 44% of issues closed
36.7/38.3PR acceptance — 46/48 decided PRs merged
0/15OpenSSF Scorecard: Code-Review — Found 1/27 approved changesets -- score normalized to 0
Inputs used
merged_prs46
open_issues29
closed_issues23
issue_closed_ratio0.442
closed_unmerged_prs2
How it's scored
30/30Ownership backing — organization-owned
0/20Verified domain
19.7/25Owner reach — 546 followers of okfn-brasil
25/25Track record — 119 public repos, account ~14 yr old
Inputs used
followers546
owner_typeOrganization
is_verified
owner_loginokfn-brasil
public_repos119
account_age_days5,208

Engineering Quality

Are baseline engineering and documentation practices in place?

74Good · 20% of overall
How it's scored
24/24CI workflows — 3 workflow(s)
24/24Tests present
0/16Linter config
0/9.6Pre-commit hooks
0/6.4.editorconfig
16/20OpenSSF Scorecard: CI-Tests — 10 out of 12 merged PRs checked by a CI test -- score normalized to 8
Inputs used
has_ciyes
has_testsyes
has_editorconfigno
has_linter_configno
has_precommit_configno

Documentation

90Excellent
How it's scored
30/30README
25/25Documentation directory
15/15Documentation / homepage site — https://api.queridodiario.ok.org.br/docs
10/10Repository description
10/10Topics — 4 topics
0/10Wiki
Inputs used
topicsapi, fastapi, python, hacktoberfest
has_wikino
homepagehttps://api.queridodiario.ok.org.br/docs
has_readmeyes
has_docs_diryes
has_descriptionyes

Security

Are visible security and supply-chain practices strong, without unresolved high-risk jurisdiction exposure?

38At risk · 16% of overall
How it's scored
7.5/7.5Binary-Artifacts — no binaries found in the repo
0/7.5Branch-Protection — branch protection not enabled on development/release branches
2/2.5CI-Tests — 10 out of 12 merged PRs checked by a CI test -- score normalized to 8
0/2.5CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected
0/7.5Code-Review — Found 1/27 approved changesets -- score normalized to 0
2.5/2.5Contributors — project has 16 contributing companies or organizations
10/10Dangerous-Workflow — no dangerous workflow patterns detected
0/7.5Dependency-Update-Tool — no update tool detected
0/5Fuzzing — project is not fuzzed
2.5/2.5License — license file detected
6.8/7.5Maintained — 11 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 9
5/5Packaging — packaging workflow detected
0/5Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
1/5SAST — SAST tool is not run on all commits -- score normalized to 2
0/5Security-Policy — security policy file not detected
0/7.5Signed-Releases — no data
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 14 existing vulnerabilities detected
Inputs used
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate3.8
Excluded from scoring (no data or not applicable): signed_releases. Remaining weights renormalized.

AI Readiness

How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score.

48At risk · 0% of overall
How it's scored
0/45Agent instructions — no CLAUDE.md / AGENTS.md / editor rules
0/15Machine-readable docs (llms.txt)
27.7/40Legible commit history — 52 of 100 human commits state their intent (structured subject or explanatory body)
Inputs used
has_llms_txtno
legible_history_share0.52
agent_instruction_files
agent_instruction_max_bytes
How it's scored
18/18One-command bootstrap — Makefile
22/22Automated tests
0/11Lint / format config
0/11Static type checking
10/10Reproducible environment — Dockerfile
10/10Demonstrated agent practice — 11 of the last 100 commits agent-authored or agent-credited
0/8Automated maintenance — no automated dependency updates observed
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Inputs used
has_nixno
has_testsyes
lockfiles
has_dockerfileyes
typed_languageno
bootstrap_filesMakefile
has_devcontainerno
has_linter_configno
typecheck_configs
agent_commit_share0.11
toolchain_manifests
dependency_bot_commit_share0
How it's scored
0/45Type-checkable code — Python without a type-check config
55/55Manageable file sizes — 0/40 source files over 60KB
Inputs used
primary_languagePython
largest_source_bytes30,115
source_files_sampled40
oversized_source_files0

Key facts

60GitHub stars
13contributors
25commits, last 12 months
9days since last push
7releases
1bus factor
29open issues
PyPIpackage ecosystems

Data collection warnings

  • Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
  • GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

More detail

Star and fork history 0 ★ / 34 ⇿
0Stars
34Forks
1Releases

When each star and fork was added, collected from GitHub and bucketed by day. Cumulative growth sits directly above the daily additions it is made of, so the two read against each other: steady organic accretion looks nothing like an abrupt, short-lived burst. Where that difference is measurable, it is reported as growth authenticity.

01325383442020-082023-072026-06
Major 0Minor 0Patch 1

Each point covers 6 days.

OpenSSF Scorecard 3.8 / 10
3.8aggregate

Independent, tool-agnostic security assessment from the open-source OpenSSF Scorecard. Each check rewards a security practice, not a specific vendor's tool. Checks Scorecard could not determine are marked n/a and excluded from the security score (never counted as zero).Scorecard v5.5.0 · 2026-07-25 21:26 UTC

10Binary-Artifactsno binaries found in the repo
0Branch-Protectionbranch protection not enabled on development/release branches
8CI-Tests10 out of 12 merged PRs checked by a CI test -- score normalized to 8
0CII-Best-Practicesno effort to earn an OpenSSF best practices badge detected
0Code-ReviewFound 1/27 approved changesets -- score normalized to 0
10Contributorsproject has 16 contributing companies or organizations
10Dangerous-Workflowno dangerous workflow patterns detected
0Dependency-Update-Toolno update tool detected
0Fuzzingproject is not fuzzed
10Licenselicense file detected
9Maintained11 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 9
10Packagingpackaging workflow detected
0Pinned-Dependenciesdependency not pinned by hash detected -- score normalized to 0
2SASTSAST tool is not run on all commits -- score normalized to 2
0Security-Policysecurity policy file not detected
n/aSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities14 existing vulnerabilities detected
All dependencies not collected

The resolved dependency set could not be collected for this report: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

Raw JSON report machine-readable
{
  "data": {
    "repo": {
      "topics": [
        "api",
        "fastapi",
        "python",
        "hacktoberfest"
      ],
      "is_fork": false,
      "size_kb": 673,
      "has_wiki": false,
      "homepage": "https://api.queridodiario.ok.org.br/docs",
      "languages": {
        "Python": 231325,
        "Makefile": 5640,
        "Dockerfile": 597
      },
      "pushed_at": "2026-07-15T23:10:03Z",
      "created_at": "2020-08-21T21:06:28Z",
      "owner_type": "Organization",
      "updated_at": "2026-07-15T11:19:03Z",
      "description": "This is Querido Diário's API. It provides everything the frontend does and even more!",
      "is_archived": false,
      "is_disabled": false,
      "license_spdx": "MIT",
      "default_branch": "main",
      "license_spdx_raw": "MIT",
      "primary_language": "Python",
      "significant_languages": [
        "Python"
      ]
    },
    "owner": {
      "blog": "http://ok.org.br",
      "name": "Open Knowledge Brasil - Rede pelo Conhecimento Livre",
      "type": "Organization",
      "login": "okfn-brasil",
      "company": null,
      "location": "Brasil",
      "followers": 546,
      "avatar_url": "https://avatars.githubusercontent.com/u/1666382?v=4",
      "created_at": "2012-04-21T18:48:59Z",
      "is_verified": null,
      "public_repos": 119,
      "account_age_days": 5208
    },
    "license": {
      "state": "standard",
      "spdx_id": "MIT",
      "raw_spdx": "MIT",
      "file_present": true,
      "scorecard_found": true,
      "profile_has_license": true
    },
    "activity": {
      "releases": [
        {
          "tag": "v0.22.8",
          "kind": "patch",
          "published_at": "2026-07-15T23:10:03Z"
        },
        {
          "tag": "v0.22.7",
          "kind": "patch",
          "published_at": "2026-07-10T15:19:00Z"
        },
        {
          "tag": "v0.22.4",
          "kind": "patch",
          "published_at": "2026-07-10T13:00:07Z"
        },
        {
          "tag": "v0.22.3",
          "kind": "patch",
          "published_at": "2026-07-10T09:42:15Z"
        },
        {
          "tag": "v0.22.2",
          "kind": "patch",
          "published_at": "2026-07-10T09:28:59Z"
        },
        {
          "tag": "v0.22.1",
          "kind": "patch",
          "published_at": "2026-07-10T01:21:59Z"
        },
        {
          "tag": "v0.15.2",
          "kind": "patch",
          "published_at": "2022-06-30T12:28:47Z"
        }
      ],
      "recent_commits": [
        {
          "oid": "36b6c4f3818176ad5d0e151942eee83a8ef64434",
          "body": "Spiders ativos sem data de fim têm date_to = NULL. A condição\n`date_to >= start_date` excluía todos eles (NULL >= date é falso\nem SQL), fazendo o endpoint GET /scraper/spiders retornar lista vazia\nquando start_date era fornecido pelo scheduler.\n\nAdiciona `date_to IS NULL` à condição para incluir spiders ainda ativos.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: inclui spiders sem date_to na busca por intervalo de datas",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-15T11:18:51Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "9e377ca9ebef3f45e16945f563d0d42a6d46c069",
          "body": "Sem paginação, a query retornava todos os 437k registros com seus\nJSONs completos de stats, matando o processo por OOM. Default: 100,\nmáximo: 1000.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: adiciona limit ao GET /scraper/job-stats para evitar OOM",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-10T15:18:49Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "975847cd1bf607986029a518c35577a7906b3373",
          "body": "UPDATE e DROP COLUMN eram executados incondicionalmente — falhavam\nno segundo startup após spider já ter sido removida.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: torna backfill e drop da coluna spider idempotentes",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-10T13:34:33Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "ddf99457d8c2fe21633e1312c241bfaa7dcc3086",
          "body": "Além de renomear colunas e backfill, uniformiza tipos (json→jsonb,\ntimestamp→timestamptz) e adiciona NOT NULL após garantir dados íntegros.\nSchema final bate 1:1 com o CREATE TABLE canônico.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: migração completa e idempotente do schema de job_stats",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-10T13:04:01Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "2a0ac6e0e8cad4de411a006a2b38ba7bbb168733",
          "body": "- Renomeia job_stats→stats, start_time→created_at (via DO block idempotente)\n- Backfill de spider_name a partir de spider para 437k registros legados\n- Remove coluna spider redundante após backfill\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: unifica schema legado da tabela job_stats",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-10T12:59:57Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "a240794f67aa444a944fc3b4c6bc5a2afd5a15c1",
          "body": "Schema original usava nomes diferentes: job_stats→stats, start_time→created_at.\nRenomeia via DO block (idempotente) e adiciona colunas faltantes.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: migra schema legado da tabela job_stats",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-10T09:42:05Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "4c99d25e740c575258a8d8cb6694d8e0da92cdd4",
          "body": "A tabela foi criada antes da coluna existir; ADD COLUMN IF NOT EXISTS\ngarante que instâncias existentes sejam migradas automaticamente.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: migra coluna spider_name na tabela job_stats existente",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-10T09:28:51Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "025abc5ae4f6c93240979d935c7859c34875b8d2",
          "body": "Implementa o endpoint para registrar spiders novos ou atualizados,\nchamado pelo comando `scrapy qd-sync-spiders` no CI de raspadores.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: adiciona endpoint POST /scraper/spiders/sync",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-10T01:21:19Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "426e2a9abf1a71308e9e789c34e5cf6beb8fb1d8",
          "body": "Todas as outras rotas do app usam paths sem o prefixo /api\n(ex: /gazettes, /cities). O Traefik faz strip do /api antes de\nencaminhar para o FastAPI, então /api/scraper/* nunca era alcançado.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: remove prefixo /api das rotas do scraper",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-10T00:25:12Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "d809b0e1fadc7df0c518aa19995943ab7ffaea8f",
          "body": "fix: corrige setup de env nos workflows de CI\n\n- Troca --no-clobber por --update=none (recomendado pelo coreutils 9.4+)\n- Atualiza URL do censo.csv: DigitalOcean CDN → data.queridodiario.ok.org.br\n- Adiciona flag -f ao curl para falhar em erros HTTP (4xx/5xx)\n\nCo-authored-by: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "fix: corrige setup de arquivos de ambiente nos workflows de CI (#107)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-09T17:51:16Z",
          "body_truncated": false,
          "is_coding_agent": true
        },
        {
          "oid": "bb95441950863e1bb0769cbbd38659ae63d23976",
          "body": "* feat: add authenticated scraper endpoints (/api/scraper/*)\n\nAdd internal API endpoints so scrapers running on Zyte no longer need\ndirect database access:\n\n- GET  /api/scraper/spiders: list enabled spiders, with optional\n  start_date/end_date filters (replaces get_enabled_spiders())\n- POST /api/scr\n[…]\nemove o || true indevido — o download deve funcionar com a URL correta.\n\nCo-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>\n\n---------\n\nCo-authored-by: Claude Sonnet 4.6 <noreply@anthropic.com>",
          "is_bot": false,
          "headline": "feat: endpoints autenticados para raspadores (/api/scraper/*) (#106)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-07-09T16:27:41Z",
          "body_truncated": true,
          "is_coding_agent": true
        },
        {
          "oid": "2e37beea164f42947dfd600c66213cde9d5f9d54",
          "body": "refactor: reorganiza estrutura de testes seguindo boas práticas do unittest\n\nCorrige bugs e melhora a organização dos testes:\n\nCorreções:\n- Fix: protocolo https:// não estava sendo adicionado corretamente nas URLs\n- Fix: ordem de verificação de protocolos (https antes de http)\n\nRefatoração dos teste\n[…]\ns)\n- Adiciona README.md com documentação completa em português\n\nResultados:\n- 76 testes passando (1 falha esperada)\n- Tempo de execução: ~0.18s\n- Zero duplicação de código\n- Código formatado com Black",
          "is_bot": false,
          "headline": "refactor: reorganiza estrutura de testes seguindo boas práticas (#91)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-01-13T21:06:46Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "8352b149d79e7d4843bbda7d21081b6080a1c9fb",
          "body": "O campo 'url' não estava sendo processado pela função _build_file_url(),\nresultando em URLs completas mesmo com a feature flag REPLACE_FILE_URL_BASE\nativada. Apenas o campo 'txt_url' estava sendo transformado corretamente.\n\nAlterações:\n- gazettes/gazette_access.py: aplica _build_file_url() ao campo \n[…]\nhos relativos (dados novos)\n2. URLs completas com substituição de base (migração)\n3. URLs completas sem alteração (modo legado)\n4. Edge cases (trailing slashes, protocolos diferentes, etc)\n\nCloses #XX",
          "is_bot": false,
          "headline": "fix: aplica transformação de URL no campo 'url' principal (#90)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-01-13T19:40:33Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "948343e8387affb84f0d04c6cb12248efd79e92d",
          "body": null,
          "is_bot": false,
          "headline": "[minor] Ajusta pattern do compose",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-01-13T19:40:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3894fa4ef724cc527e75f6fdfddc5b868d7f3c96",
          "body": "* Corrige testes de API faltantes do PR #88\n\nAtualiza 4 testes que não foram completamente migrados no commit b0874d4:\n\n- test_gazettes_endpoint_should_accept_query_querystring_date:\n  Atualiza de /gazettes/{territory_id} para /gazettes?territory_ids=\n\n- test_get_gazettes_should_forward_querystring_\n[…]\nstAPI 0.115.6 + Pydantic 2.12.5).\n\n## Resultado\n\n✅ Todos os 46 testes passam com sucesso\n✅ Compatibilidade total com Python 3.12 e Pydantic v2\n✅ Consistência entre ambientes de desenvolvimento e teste",
          "is_bot": false,
          "headline": "Corrige testes de API faltantes do PR #88 (#89)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-01-13T03:53:05Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "d8f06360fc1996743083d5107f803fc4e916969c",
          "body": "* Atualiza Python 3.8 para 3.12 e dependências\n\n   - Atualiza imagem base do Dockerfile de python:3.8 para python:3.12\n   - Atualiza dependências principais para versões compatíveis com Python 3.12:\n     - fastapi: 0.61.0 → 0.115.6\n     - uvicorn: 0.11.8 → 0.32.1\n     - opensearch-py: 2.3.2 → 2.7.1\n\n[…]\nalização\n3. Executa testes no container api com --abort-on-container-exit\n\nIsso garante que o setup complete antes dos testes iniciarem, e que\nos testes possam rodar até o fim sem serem interrompidos.",
          "is_bot": false,
          "headline": "Atualiza Python 3.8 para 3.12 e dependências (#87)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-01-13T02:15:23Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "b0874d470284cb8729f924bd4854bdfd8d230a3b",
          "body": "* Corrige e atualiza testes defasados\n\nRemove testes obsoletos:\n- test_csv_database.py: testava módulo database/csv.py removido\n- test_gazette_access.py: testava classes antigas (GazetteAccess, GazetteDataGateway)\n- test_opensearch.py: testava OpenSearchDataMapper antiga\n\nAtualiza testes de configur\n[…]\ncks de City\n\nCorrige ValidationError do Pydantic nos testes de cities.\nO modelo City requer o campo obrigatório 'availability_date'.\n\nResultado: 4 erros eliminados, restam apenas 4 falhas em 46 testes",
          "is_bot": false,
          "headline": "Corrige e atualiza testes defasados (#88)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-01-12T22:44:28Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "33432b144068be96c5ed320d0959d030e85db0e9",
          "body": "* feat: adiciona construção dinâmica de URLs de arquivos\n\n- Adiciona método _build_file_url() em GazetteSearchEngineGateway\n- Adiciona método _build_file_url() em ThemedExcerptSearchEngineGateway\n- Suporta 3 cenários:\n  1. Caminhos relativos (dados novos)\n  2. URLs completas com substituição de base\n[…]\n- Mantém 100% de retrocompatibilidade\n\nDocumentação relacionada:\n- IMPLEMENTATION_SUMMARY.md\n- FILE_URL_MIGRATION_GUIDE.md\n- storage-migration-cloudfront.md\n\n* (fix) Corrige path para arquivo do censo",
          "is_bot": false,
          "headline": "feat: adiciona construção dinâmica de URLs de arquivos (#86)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2026-01-11T21:26:18Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "fc0395383168ec62f5df6ecde3345d56adfacfca",
          "body": null,
          "is_bot": false,
          "headline": "Permite configurar o nível de log da API via variável de ambiente",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2025-10-07T16:14:12Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4c5a7ccbd0f7412244ff5852bb576dc17e0733a9",
          "body": "Nós não precisamos desses logs e eles vão poluir os logs do projeto.",
          "is_bot": false,
          "headline": "Remove logs do healthcheck",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2025-10-07T08:38:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "40f052f81749bbb21a3b56b43b3017cf6aea6462",
          "body": "Isso é importante para rodar o healthcheck do container quando iniciamos\na aplicação em produção - e para mantê-la sendo verificada\nconstantemente.",
          "is_bot": false,
          "headline": "Adiciona endpoint de healthcheck (#85)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2025-09-20T13:23:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e1af5fdffdae8bedd0b55336f7c78aa1f8b67eb1",
          "body": "fix: CMD do dockerfile\n\nE ajusta o arquivo de compose de testes",
          "is_bot": false,
          "headline": "fix: Entrypoint do dockerfile (#84)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2025-09-20T13:23:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ae2b6db00517110ab52863fa02ce7e6aae27cc5c",
          "body": "* feat: Roda testes no CI para todas arquiteturas\n\n* feat: Limpezas no CI\n\n* feat: Migra de podman para docker\n\n* fix: CI healthcheck\n\n* fix: ci - ajuste opensearch\n\n* fix: Corrige nome do runner arm\n\n* ci improvements\n\nAdded:\nworkflow_dispatch trigger\npermissions: packages: write, contents: read\nco\n[…]\n(and tag manifests if tagging).\nInspect:\ndocker buildx imagetools inspect ghcr.io/okfn-brasil/querido-diario-api:latest\nYou should see linux/amd64 and linux/arm64.\n\n* temporary: disable coverage on CI",
          "is_bot": false,
          "headline": "feat: Roda testes no CI para todas arquiteturas (#83)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2025-09-02T03:13:04Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "6e5667114d6b5a5e2d4abe4bcca2a1921badb262",
          "body": "Pequeno update",
          "is_bot": false,
          "headline": "feat: Update github workflow (#82)",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2025-08-31T02:54:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c061521565e1fbb275891ac4eb6d55abd4c49ab6",
          "body": null,
          "is_bot": false,
          "headline": "feat: Update github workflow",
          "author_name": "Diego Rabatone Oliveira",
          "author_login": "diraol",
          "committed_at": "2025-08-31T02:48:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "294ec88edf0538cbfdf048486b482b6d38f4cc0e",
          "body": null,
          "is_bot": false,
          "headline": "Sobe versão para v0.19.0",
          "author_name": "Giulio",
          "author_login": "ogecece",
          "committed_at": "2025-04-10T19:36:33Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2d1ad521eac5dd86d7570c0125b3b5ee987ecf84",
          "body": "O arquivo do\n[censo.csv](https://github.com/user-attachments/files/18676111/censo.csv)\nfoi atualizado com a adição da coluna `availability_date` para indicar a\ndata que cada município foi integrado ao QD. Esse dado é relevante para\nque as notificações de entrada de municípios sejam automatizadas no \n[…]\n \"state_code\": \"AM\",\n      \"publication_urls\": [\n        \"https://diario.imprensaoficial.am.gov.br/\"\n      ],\n      \"level\": \"3\",\n      \"availability_date\": \"AAAA-MM-DD\",  # novidade!\n    },\n  ]\n}\n~~~",
          "is_bot": false,
          "headline": "Adiciona campo novo para cities (#80)",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2025-04-10T19:35:45Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "422cd61ddad68564330d049586acc36358e52501",
          "body": null,
          "is_bot": false,
          "headline": "Corrige exibição do campo no endpoint /cities",
          "author_name": "Giulio",
          "author_login": "ogecece",
          "committed_at": "2025-04-10T19:35:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "1f4eae02021f1cb3b43d645d10ac0dee3a03440a",
          "body": null,
          "is_bot": false,
          "headline": "Adiciona campo novo para cities",
          "author_name": "trevineju",
          "author_login": "trevineju",
          "committed_at": "2025-04-10T19:35:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6273fe9891e9a85d4ecb12ce828edfb0df9ae1ec",
          "body": "Signed-off-by: Juliana Trevine <44185775+trevineju@users.noreply.github.com>",
          "is_bot": false,
          "headline": "Delete docs/FUNDING.yml",
          "author_name": "Juliana Trevine",
          "author_login": "trevineju",
          "committed_at": "2025-04-08T19:29:56Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "292bcfb6899193993c99ad089533bcff000062e9",
          "body": "… variaveis POSTGRES  (#78)\n\nCorreção de bug na variável de ambiente no comando `start-database`.\r\n\r\nalterei os nomes das variáveis de ambientes no comando `start-database`\r\ndo Makefile de:\r\n```Makefile\r\n-e POSTGRES_COMPANIES_PASSWORD=$(POSTGRES_COMPANIES_PASSWORD) \\\r\n-e POSTGRES_COMPANIES_USER=$(PO\n[…]\n ) as variáveis de ambientes foram alteradas. E as\r\nvariáveis que cria a imagem doo banco de dados também foram alteradas\r\ncom a palavra `COMPANIES`, isso impedia que o banco de dados fosse\r\niniciado.",
          "is_bot": false,
          "headline": "fix: correção de bug no Makefile - remoção da palavra 'COMPANIES' das…",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2024-12-11T18:27:16Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "650a84da49e04b3d014a7f86abeae49a90472018",
          "body": null,
          "is_bot": false,
          "headline": "fix: remoção da palavra 'COMPANIES' das variaveis POSTGRES",
          "author_name": "thisiscleverson",
          "author_login": "thisiscleverson",
          "committed_at": "2024-12-05T14:11:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "0fe76197f374597613fa5b499b78b8d9de5d8ac9",
          "body": null,
          "is_bot": false,
          "headline": "Atualiza redes sociais (#77)",
          "author_name": "Juliana Trevine",
          "author_login": "trevineju",
          "committed_at": "2024-11-11T23:43:05Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6f62bb7ffa0847e82755a6354317dbca71ece690",
          "body": null,
          "is_bot": false,
          "headline": "Atualiza redes sociais",
          "author_name": "trevineju",
          "author_login": "trevineju",
          "committed_at": "2024-11-11T23:42:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "38bac65ccc46ce8c5e5f4ccf12b69177b223a89c",
          "body": null,
          "is_bot": false,
          "headline": "Incrementa versão para v0.18.0",
          "author_name": "Giulio",
          "author_login": "ogecece",
          "committed_at": "2024-08-19T12:19:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "090e6d54e67c28d5fb3219895e2e5e03e8475f79",
          "body": "…os  (#76)",
          "is_bot": false,
          "headline": "Implementa rotas para acesso ao dados de arquivos com diários agregad…",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2024-08-19T12:16:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f06658bb5cb2dc48a249f9bd2b969ecf56502003",
          "body": "Signed-off-by: Wildemberg Sales <junior_sales2010@hotmail.com>",
          "is_bot": false,
          "headline": "Implementa variável de ambiente local do bucket",
          "author_name": "Wildemberg Sales",
          "author_login": "wildemberg-sales",
          "committed_at": "2024-08-19T12:16:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4e3cad6da4be17657e228d9d6378870aec9aa227",
          "body": "Refatora verificação de erros na rota de agregados e Corrige nome de variáveis\n\nRemove try-except da rota de agregados\n\nRemove __init__ das classes do postgres de aggregates e companies\n\nRefatora método de retorno de dados dos agregados\n\nImplementa variavel .env do bucket e retorna com file_path do agregado",
          "is_bot": false,
          "headline": "Implementa herança de classe para reutilização de código",
          "author_name": "wildemberg-sales",
          "author_login": "wildemberg-sales",
          "committed_at": "2024-08-19T12:16:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e31f17fab85897bfb520d2b8de340afb32720e87",
          "body": null,
          "is_bot": false,
          "headline": "Especifica variaveis de Companies",
          "author_name": "wildemberg-sales",
          "author_login": "wildemberg-sales",
          "committed_at": "2024-08-19T12:16:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "bda6a04ab2c5da1618204ff137726dd9ab3101f2",
          "body": null,
          "is_bot": false,
          "headline": "Implementa filtragem de estado e territorio de agregados",
          "author_name": "wildemberg-sales",
          "author_login": "wildemberg-sales",
          "committed_at": "2024-08-19T12:16:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "72823f8259b4c879d5af5814288301375ae26c9f",
          "body": "Co-authored: ArthurFerreiraRodrigues <arthur.250402@gmail.com>",
          "is_bot": false,
          "headline": "Adiciona state_code e territory_id",
          "author_name": "pkbceira03",
          "author_login": "pkbceira03",
          "committed_at": "2024-08-19T12:16:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ee79446a3f2453ddc74e94dcfe9de1e2a1d4f2fa",
          "body": "Co-authored-by: pkbceira03 <cabeceira2003@gmail.com>",
          "is_bot": false,
          "headline": "implementando rota para busca dos arquivos agregados",
          "author_name": "wildemberg-sales",
          "author_login": "wildemberg-sales",
          "committed_at": "2024-08-19T12:16:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fc39df7cc50278232e95b4ed391866830b3e366c",
          "body": "Co-authored-by: wildemberg-sales <junior_sales2010@hotmail.com>",
          "is_bot": false,
          "headline": "Adicionando funções de busca de agregados e rotas da postgresql",
          "author_name": "pkbceira03",
          "author_login": "pkbceira03",
          "committed_at": "2024-08-19T12:16:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6bc037f738e3c8d8adbebbb13eafbbda548ec1e8",
          "body": ">\n>\n> Co-authored-by: pkbceira03 <cabeceira2003@gmail.com>\n> Co-authored-by: csafurtado <csafurtado.dev@gmail.com>",
          "is_bot": false,
          "headline": "Adicionando variaveis do banco no env e criando modulo de agregados",
          "author_name": "wildemberg-sales",
          "author_login": "wildemberg-sales",
          "committed_at": "2024-08-19T12:16:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "424a8f1a788d8178fe7fe9ceede858ad18af06b1",
          "body": "Este pull request faz as seguintes alterações:\r\n\r\n**Makefile:**\r\n\r\nAdiciona o comando `load-data` ao target .PHONY: run. Isso garante que,\r\nao executar `make run`, os dados necessários sejam carregados\r\ncorretamente, melhorando a inicialização do ambiente.\r\n\r\n**README:**\r\n\r\nRemove a referência ao co\n[…]\n\nrun: create-pod opensearch database load-data re-run\r\n```\r\n\r\n**README:**\r\n\r\n* Removido o texto que fazia referência ao comando make load-data.\r\n* Alterado make rerun para make re-run na documentação.",
          "is_bot": false,
          "headline": "adição do load-data ao comando run e atualização do README (#74)",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2024-07-18T15:38:41Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "8ea817323805fcec9e02829516dc122d784b9047",
          "body": "…a e correção do comando make rerun para make re-run\n\nRemovi a descrição desatualizada do comando `make load-data` e corrigi o comando `make rerun` para `make re-run` no README para refletir as mudanças recentes no Makefile.",
          "is_bot": false,
          "headline": "Atualização no README: remoção da referência ao comando make load-dat…",
          "author_name": "cleverson",
          "author_login": "thisiscleverson",
          "committed_at": "2024-07-17T19:49:11Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "273d6713bab9aa570eb5098b40f52c01444f9e6a",
          "body": "Inclui o comando `load-data` na regra `.PHONY: run` no Makefile para garantir que os dados sejam carregados ao executar o target `run`.",
          "is_bot": false,
          "headline": "Adicionei o comando load-data ao target run no Makefile",
          "author_name": "cleverson",
          "author_login": "thisiscleverson",
          "committed_at": "2024-07-17T19:41:02Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e2941d4fbdb956031c08fdcfb43a6dd39e19f93e",
          "body": null,
          "is_bot": false,
          "headline": "Atualiza documentação (#72)",
          "author_name": "Juliana Trevine",
          "author_login": "trevineju",
          "committed_at": "2024-06-21T22:17:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "99796d95a342727a5b1146d2436b685536a6f44d",
          "body": null,
          "is_bot": false,
          "headline": "Troca referencias do repo de comunidade para docs.queridodiario",
          "author_name": "trevineju",
          "author_login": "trevineju",
          "committed_at": "2024-06-21T22:13:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5f10af527de59f7213cf4e3c9f0bb5decaa42cc2",
          "body": null,
          "is_bot": false,
          "headline": "Corrige script load_fake_gazettes",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2024-03-22T15:24:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ba3071424c93f47420f12242987b8da940172f3b",
          "body": null,
          "is_bot": false,
          "headline": "Corrige chamada de rerun para re-run no Makefile",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2024-03-22T15:02:26Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "146f12c9d5335dec6d5713acf47a0e9b7de67162",
          "body": null,
          "is_bot": false,
          "headline": "Melhora integração de ambiente dev com outros repos do QD",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2024-03-19T19:48:45Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fc98628dc381b0ff936dfb2a6b4b583d84db594b",
          "body": null,
          "is_bot": false,
          "headline": "Atualiza URLs que referenciam o ReadTheDocs (#66)",
          "author_name": "Juliana Trevine",
          "author_login": "trevineju",
          "committed_at": "2023-12-08T13:15:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f6c5df60af60e3c25e3c7d298ebc498c8d8040d4",
          "body": null,
          "is_bot": false,
          "headline": "Atualiza link para documentação técnica oficial",
          "author_name": "trevineju",
          "author_login": "trevineju",
          "committed_at": "2023-12-08T12:47:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7bb0b2ef9fb64d3519ae0eafea90098e48d14346",
          "body": "Alterações feitas para refletir todas as alterações de ES para OS. Falta apenas o Makefile.\r\n\r\nMakefile adaptado para Opensearch\r\n\r\nCorreções diversas.",
          "is_bot": false,
          "headline": "Substituição da biblioteca python elasticsearch pelo opensearch (#65)",
          "author_name": "Giulio Carvalho",
          "author_login": null,
          "committed_at": "2023-12-06T21:57:52Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "8be7c91f295a996fe2d6362c7edbe7b1156490d8",
          "body": "Alterações feitas para refletir todas as alterações de ES para OS. Falta apenas o Makefile.\n\nMakefile adaptado para Opensearch\n\nCorreções diversas.",
          "is_bot": false,
          "headline": "Substituição do elasticsearch pelo opensearch.",
          "author_name": "Pedro Guimarães",
          "author_login": "tigreped",
          "committed_at": "2023-12-06T21:54:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ef087df662b8c8d6c545e12c48ebfdcee8a90907",
          "body": "Buscando se adequar ao padrão de documentação adotado no projeto\r\n(#okfn-brasil/querido-diario-comunidade#14), este PR:\r\n\r\n- Adiciona CODE_OF_CONDUCT.md e sua tradução em inglês.\r\n- Adiciona FUNDING.yml\r\n- Adiciona SUPPORT.md e sua tradução em inglês\r\n- Atualiza LICENSE.md\r\n- Como não havia CONTRIBU\n[…]\nING.md, o arquivo foi adicionado com layout\r\npadronizado e sua tradução em inglês também.\r\n- Padroniza layout do README.md, modificando pouco o conteúdo que já\r\nexistia. Adiciona sua versão em inglês.",
          "is_bot": false,
          "headline": "Atualiza arquivos básicos de documentação (#57)",
          "author_name": "Juliana Trevine",
          "author_login": "trevineju",
          "committed_at": "2023-08-10T19:46:35Z",
          "body_truncated": true,
          "is_coding_agent": false
        },
        {
          "oid": "223b0e7c60315c22080090ea3352e7b1d21e53af",
          "body": "Adiciona CONTRIBUTING.md e sua tradução em inglês\n\nAdiciona FUNDING.yml\n\nAdiciona SUPPORT.md e sua tradução\n\nMove e renomeia tradução do README.md\n\nAtualiza texto de LICENSE.md\n\nAtualiza e move arquivos para /docs",
          "is_bot": false,
          "headline": "Atualiza documentações do repositório",
          "author_name": "trevineju",
          "author_login": "trevineju",
          "committed_at": "2023-08-10T19:42:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "aa199f9878481cbc9b0e5cb0ed393ca069b99668",
          "body": "Aplicando as correções de código feitas pelo commando black.",
          "is_bot": false,
          "headline": "Correções de formatação de código.",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2023-01-30T20:22:23Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "62e310a9fb451459a1036528069acf2e19c267cd",
          "body": null,
          "is_bot": false,
          "headline": "Incrementa versão para v0.17.0",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-09-02T21:51:24Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "53b815ec8677babad37b6b9fb5c0fa46411c44eb",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch 'filtro-data-raspagem'",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-09-02T21:50:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4c0b30744984922f5d4636d93d935ee1f9a17936",
          "body": null,
          "is_bot": false,
          "headline": "Adiciona filtro por momento de raspagem",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-09-02T21:48:08Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f5c5843426fc7f3d90792ee5c3f41f9595a5fca0",
          "body": null,
          "is_bot": false,
          "headline": "Incrementa versão para v0.16.0",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-08-19T23:08:50Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "fc272008b73def9d5d877c424a9422aacde6dba0",
          "body": null,
          "is_bot": false,
          "headline": "Merge branch 'level_e_scraped_at'",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-08-19T23:08:38Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5e38c93471cbd641798b19893cd69b8c606c8f5f",
          "body": null,
          "is_bot": false,
          "headline": "Adiciona possibilidade de filtro por nível na busca por cidades",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-08-19T23:00:22Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f209facd1aeb8ce8e0a26719e631608dc94ecde8",
          "body": null,
          "is_bot": false,
          "headline": "Adiciona data de extração no resultado de gazettes e excerpts",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-08-19T22:59:47Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "39b434ceb0cac7fb98af84aff33a7e0598e701dd",
          "body": null,
          "is_bot": false,
          "headline": "Atualizando versão da tag",
          "author_name": "Pedro",
          "author_login": "tigreped",
          "committed_at": "2022-06-30T12:25:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "190bee01ab161bb0caf9d260933429e7b1b2bc6b",
          "body": "…odo get_partners()",
          "is_bot": false,
          "headline": "COrrigindo os índices dos campos para a tabela resposta_socios no mét…",
          "author_name": "Pedro",
          "author_login": "tigreped",
          "committed_at": "2022-06-29T13:54:29Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "7a3fe1c61342fb21768993454564ecad5118d6ca",
          "body": null,
          "is_bot": false,
          "headline": "Corrigindo índices dos campos no banco",
          "author_name": "Pedro",
          "author_login": "tigreped",
          "committed_at": "2022-06-28T13:40:35Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5b32240692a113d2828fa98aad382815f06ab730",
          "body": "Sem os campos de `quote_field_suffix` na construção da simple query\nstring e `matched_fields` na construção do highlighting, uma busca\npor frase exata podia dar highlighting em tokens individualmente,\ndar highlighting em variações dos tokens (levando em conta o\nstemming) ou até não dar highlighting.",
          "is_bot": false,
          "headline": "Torna busca por frase exata compatível com highlighting",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-06-08T03:25:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "986280d74847f5d0376dd7e92e68dbda2784ee31",
          "body": null,
          "is_bot": false,
          "headline": "Modifica select no banco de CNPJ para não remover zeros à esquerda",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-06-08T03:19:37Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "696bad518b799bae5aa7525a64654ac4a905a1b6",
          "body": null,
          "is_bot": false,
          "headline": "Incrementa versão para v0.14.0",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-05-25T21:11:21Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "87f19ac7d23ca63aee18119e74263bc2aefbcf3e",
          "body": "…r tema",
          "is_bot": false,
          "headline": "Reestrutura todos os endpoints (exceto sugestões) e adiciona busca po…",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-05-25T21:10:46Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "c621d53b3e9d8ec25a1045be6a76a6dc25a0484f",
          "body": "Adiciona consulta por CNPJ",
          "is_bot": false,
          "headline": "Merge pull request #55 from giuliocc/consulta-cnpj",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-05-19T17:24:19Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "5097352820eaf6b71edfe58ea354fc90fdf337e6",
          "body": null,
          "is_bot": false,
          "headline": "Incrementa versão para v0.13.0",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-05-19T17:17:51Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "a21b0f31024b01588e49ad0cd6c7410f46340e96",
          "body": "Consulta na base da receita adicionada. Testes específicos serão\nadicionados posteriormente.\n\nCom esta consulta, é possível obter dados relacionados a um CNPJ,\nsendo informações específicas da empresa ou de seus sócios.",
          "is_bot": false,
          "headline": "Adiciona consulta por CNPJ",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-05-19T16:21:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ce54333a70f5d4050e10df7135efb1515848ba66",
          "body": null,
          "is_bot": false,
          "headline": "Incrementa versão para v0.12.0",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-18T16:26:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "ef0eef01500c5419af52f968b8ec2ba4ba548330",
          "body": "Adiciona novas modalidades de busca | Add new query modes",
          "is_bot": false,
          "headline": "Merge pull request #52 from okfn-brasil/modalidades-busca",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-18T16:18:39Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "19c247a1196a2625210e4798ab0a906fcdd864ad",
          "body": null,
          "is_bot": false,
          "headline": "Corrige descrição de uso da querystring",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-18T16:12:44Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "2f6961d764057e18ee7321fe38639da16e5c464b",
          "body": null,
          "is_bot": false,
          "headline": "Adiciona testes do ElasticSearch com querystring",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-18T15:39:31Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "89ba3e70ab38a71da627d589fe519af9dacf48e7",
          "body": null,
          "is_bot": false,
          "headline": "Corrige testes com ordenação de resultados antiga",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-18T03:02:59Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6c054ef09437d4923503b456ed48b1ae0208cab6",
          "body": null,
          "is_bot": false,
          "headline": "Corrige ordenação padrão de resultados",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-08T23:27:58Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "d9de07746086c9c53e619a092afc77ee9a067044",
          "body": null,
          "is_bot": false,
          "headline": "Corrige testes unitários de gazette_access",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-08T23:22:18Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "4086221c29cf0c9c1d59fcd0d9f9204cf4b2bd17",
          "body": null,
          "is_bot": false,
          "headline": "Corrige testes unitários da API",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-08T23:22:13Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "e4c56ba8fd3d8da732b49b4fe1132667de4a677d",
          "body": "Novas modalidades de busca podem ser utilizadas através da sintaxe\nSimple Query String do ElasticSearch. Assim, podemos ter buscas\nbooleanas, fuzzy, proximidade, etc.",
          "is_bot": false,
          "headline": "Adiciona novas modalidades de busca",
          "author_name": "Giulio Carvalho",
          "author_login": "ogecece",
          "committed_at": "2022-04-08T23:17:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f3cd772435d7706854793abc402a999ee20bfcd7",
          "body": "Translating documentation\r\n\r\nTranslates from EN-US to PT-BR and creates language directory",
          "is_bot": false,
          "headline": "Translating README docs (#49)",
          "author_name": "Fernanda",
          "author_login": "campagnucci",
          "committed_at": "2022-03-31T01:32:55Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6d44baa4b2d60b0762dc72cbf3ce7170298c11a8",
          "body": "Updates the Github workflow used to build the container image to use the\nGITHUB_REPOSITORY environment variable to build the container image",
          "is_bot": false,
          "headline": "Use github environment variable to define container image name.",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2021-10-18T00:58:32Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "482d13c46e88f575bf999d70adfdaccc709b1cd5",
          "body": "Updates the workflow used to build the container image to use the\nright repository name.",
          "is_bot": false,
          "headline": "Use repository name in the container image name.",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2021-10-18T00:24:43Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "3cb0b3cf5eed8786c25435c7ba18ca30b518b194",
          "body": "Uses the Github packages feature to store the container images built in\nthe repository.",
          "is_bot": false,
          "headline": "Publish container image in the Github registry.",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2021-10-17T20:17:48Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "cb84a25ea5deea49e7003607b03bce7ca30fbd07",
          "body": "Adds date format in the endpoint's documentation",
          "is_bot": false,
          "headline": "Date format documentation",
          "author_name": "Gerardo Alcantara",
          "author_login": "GeraAlcantara",
          "committed_at": "2021-10-06T20:04:27Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6cce401519a562b9f7270c9eeb7a68505f2f4c18",
          "body": "Bumps the API version to v0.11.0",
          "is_bot": false,
          "headline": "Bumps v0.11.0 version",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2021-07-01T23:31:20Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "00782d9b4b6ad3069d51fb33302c574f5efd432c",
          "body": "Adds a new endpoint to allow the front end to send suggestions to the project.",
          "is_bot": false,
          "headline": "Send email endpoint (#37)",
          "author_name": "André Formento",
          "author_login": "andreformento",
          "committed_at": "2021-07-01T23:27:04Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "b9da14c592a2e33aa42f7e62690670e59d1929fa",
          "body": "Updates the config module to load the CORS configuration from environment variables. Removing the hard code configuration.",
          "is_bot": false,
          "headline": "Adds CORS configuration options (#39)",
          "author_name": "Jonathan Schweder",
          "author_login": "jaswdr",
          "committed_at": "2021-06-24T19:53:53Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "be471979fb39b0801384aa8dd692334c7717dc98",
          "body": null,
          "is_bot": false,
          "headline": "Remove typos and unnecessary print",
          "author_name": "Giulio Carvalho",
          "author_login": null,
          "committed_at": "2021-06-24T19:44:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "73d56239c525cd296c6ae8ffd408651e691e5bff",
          "body": "Adds another endpoint in the API. It allows getting info with the\nsame content from the \"/cities\" search endpoint but from a\nspecific city by providing it's IBGE 7-digit ID.",
          "is_bot": false,
          "headline": "Add specific city endpoint",
          "author_name": "Giulio Carvalho",
          "author_login": null,
          "committed_at": "2021-06-24T19:44:30Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "6f325a564f0568bd5398728df54dc1ef8758e780",
          "body": "Bumps the API version to v0.10.0",
          "is_bot": false,
          "headline": "Bumps v0.10.0 version",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2021-06-10T01:19:00Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "acab46bb10361bbcd0d1a59bf52495f71d331172",
          "body": "Adds a parameter in the API endpoints to allow the user to sort the search results by relevance and date.",
          "is_bot": false,
          "headline": "Parameter to sort search results",
          "author_name": "André Formento",
          "author_login": "andreformento",
          "committed_at": "2021-06-10T00:57:54Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "689a9bf3e57149e15ba47c08d0cb877754039cf9",
          "body": "Adds the FastAPI CORS middleware allowing any origin. This should be a\ntemporary fix to allow the front-end team develop the UI.",
          "is_bot": false,
          "headline": "Adds CORS middleware.",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2021-06-01T20:34:07Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "25727956223717173c266dfdf782e57750ab7a97",
          "body": "Adds a new endpoint in the API. It allows checking which cities are already\navailable in the API, what is the website the gazettes are published, and which\ncities there is no information.\n\nSigned-off-by: José Guilherme Vanz <jvanz@jvanz.com>",
          "is_bot": false,
          "headline": "Cities endpoint.",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2021-05-28T19:06:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        },
        {
          "oid": "f70839b33786cf6f27450252f2efe0b25222a04d",
          "body": "Commit the source code formatting fixed by black command line tool.",
          "is_bot": false,
          "headline": "Source code formatting",
          "author_name": "José Guilherme Vanz",
          "author_login": "jvanz",
          "committed_at": "2021-05-28T19:06:16Z",
          "body_truncated": false,
          "is_coding_agent": false
        }
      ],
      "releases_count": 7,
      "commits_last_year": 25,
      "latest_release_at": "2026-07-15T23:10:03Z",
      "latest_release_tag": "v0.22.8",
      "releases_from_tags": false,
      "days_since_last_push": 9,
      "active_weeks_last_year": 6,
      "days_since_latest_release": 9,
      "mean_days_between_releases": 246.1
    },
    "community": {
      "has_readme": true,
      "has_license": true,
      "has_description": true,
      "has_contributing": true,
      "health_percentage": 75,
      "has_issue_template": false,
      "has_code_of_conduct": true,
      "has_pull_request_template": false
    },
    "ecosystem": {
      "packages": []
    },
    "popularity": {
      "forks": 34,
      "stars": 60,
      "watchers": 14,
      "fork_history": {
        "days": [
          {
            "date": "2020-08-21",
            "count": 1
          },
          {
            "date": "2020-08-30",
            "count": 1
          },
          {
            "date": "2020-08-31",
            "count": 1
          },
          {
            "date": "2020-09-26",
            "count": 1
          },
          {
            "date": "2021-01-24",
            "count": 1
          },
          {
            "date": "2021-02-24",
            "count": 1
          },
          {
            "date": "2021-03-15",
            "count": 1
          },
          {
            "date": "2021-04-18",
            "count": 1
          },
          {
            "date": "2021-06-22",
            "count": 1
          },
          {
            "date": "2021-10-01",
            "count": 1
          },
          {
            "date": "2021-10-02",
            "count": 1
          },
          {
            "date": "2021-10-26",
            "count": 1
          },
          {
            "date": "2021-11-28",
            "count": 1
          },
          {
            "date": "2022-07-11",
            "count": 1
          },
          {
            "date": "2022-08-26",
            "count": 1
          },
          {
            "date": "2022-10-11",
            "count": 1
          },
          {
            "date": "2023-07-10",
            "count": 1
          },
          {
            "date": "2023-10-20",
            "count": 1
          },
          {
            "date": "2023-11-12",
            "count": 1
          },
          {
            "date": "2023-11-20",
            "count": 1
          },
          {
            "date": "2023-12-25",
            "count": 1
          },
          {
            "date": "2024-01-11",
            "count": 1
          },
          {
            "date": "2024-02-24",
            "count": 1
          },
          {
            "date": "2024-03-05",
            "count": 1
          },
          {
            "date": "2024-03-18",
            "count": 1
          },
          {
            "date": "2024-04-02",
            "count": 1
          },
          {
            "date": "2024-04-09",
            "count": 1
          },
          {
            "date": "2024-07-22",
            "count": 2
          },
          {
            "date": "2024-07-23",
            "count": 2
          },
          {
            "date": "2024-12-07",
            "count": 1
          },
          {
            "date": "2025-01-17",
            "count": 1
          },
          {
            "date": "2026-06-17",
            "count": 1
          }
        ],
        "complete": true,
        "collected": 34,
        "total_forks": 34
      },
      "star_history": null,
      "open_issues_and_prs": 36
    },
    "ai_readiness": {
      "has_nix": false,
      "example_dirs": [],
      "has_llms_txt": false,
      "has_dockerfile": true,
      "has_mcp_signal": false,
      "bootstrap_files": [
        "Makefile"
      ],
      "api_schema_files": [],
      "has_devcontainer": false,
      "typecheck_configs": [],
      "toolchain_manifests": [],
      "largest_source_bytes": 30115,
      "source_files_sampled": 40,
      "oversized_source_files": 0,
      "agent_instruction_files": [],
      "agent_instruction_max_bytes": null
    },
    "dependencies": {
      "manifests": [
        "requirements.txt"
      ],
      "advisories": {
        "error": null,
        "scope": null,
        "source": null,
        "findings": [],
        "collected": false,
        "malicious": [],
        "truncated": false,
        "by_severity": {},
        "advisory_count": 0,
        "affected_count": 0,
        "assessed_count": 0,
        "malicious_count": 0,
        "assessed_package": null,
        "unassessed_count": 0,
        "direct_affected_count": 0
      },
      "ecosystems": [
        "pypi"
      ],
      "dependencies": [],
      "all_dependencies": {
        "error": "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository",
        "source": null,
        "packages": [],
        "collected": false,
        "truncated": false,
        "total_count": null,
        "direct_count": null,
        "indirect_count": null
      }
    },
    "maintainership": {
      "issues": {
        "open_prs": 7,
        "merged_prs": 46,
        "open_issues": 29,
        "closed_ratio": 0.442,
        "closed_issues": 23,
        "closed_unmerged_prs": 2
      },
      "bus_factor": 1,
      "bot_contributors": 0,
      "top_contributors": [
        {
          "type": "User",
          "login": "jvanz",
          "commits": 94,
          "avatar_url": "https://avatars.githubusercontent.com/u/1514798?v=4"
        },
        {
          "type": "User",
          "login": "ogecece",
          "commits": 33,
          "avatar_url": "https://avatars.githubusercontent.com/u/26327506?v=4"
        },
        {
          "type": "User",
          "login": "diraol",
          "commits": 25,
          "avatar_url": "https://avatars.githubusercontent.com/u/192702?v=4"
        },
        {
          "type": "User",
          "login": "trevineju",
          "commits": 10,
          "avatar_url": "https://avatars.githubusercontent.com/u/44185775?v=4"
        },
        {
          "type": "User",
          "login": "wildemberg-sales",
          "commits": 6,
          "avatar_url": "https://avatars.githubusercontent.com/u/92035272?v=4"
        },
        {
          "type": "User",
          "login": "andreformento",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/5116933?v=4"
        },
        {
          "type": "User",
          "login": "tigreped",
          "commits": 4,
          "avatar_url": "https://avatars.githubusercontent.com/u/1479330?v=4"
        },
        {
          "type": "User",
          "login": "thisiscleverson",
          "commits": 3,
          "avatar_url": "https://avatars.githubusercontent.com/u/71295003?v=4"
        },
        {
          "type": "User",
          "login": "pkbceira03",
          "commits": 2,
          "avatar_url": "https://avatars.githubusercontent.com/u/109092210?v=4"
        },
        {
          "type": "User",
          "login": "cuducos",
          "commits": 1,
          "avatar_url": "https://avatars.githubusercontent.com/u/4732915?v=4"
        }
      ],
      "contributors_sampled": 13,
      "top_contributor_share": 0.508
    },
    "quality_signals": {
      "has_ci": true,
      "has_tests": true,
      "ci_workflows": [
        "build_container_image.yaml",
        "security_scan.yaml",
        "test_pull_request.yml"
      ],
      "has_docs_dir": true,
      "linter_configs": [],
      "has_editorconfig": false,
      "has_linter_config": false,
      "has_precommit_config": false
    },
    "security_signals": {
      "lockfiles": [],
      "scorecard": {
        "checks": [
          {
            "name": "Binary-Artifacts",
            "score": 10,
            "reason": "no binaries found in the repo",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
          },
          {
            "name": "Branch-Protection",
            "score": 0,
            "reason": "branch protection not enabled on development/release branches",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
          },
          {
            "name": "CI-Tests",
            "score": 8,
            "reason": "10 out of 12 merged PRs checked by a CI test -- score normalized to 8",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
          },
          {
            "name": "CII-Best-Practices",
            "score": 0,
            "reason": "no effort to earn an OpenSSF best practices badge detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
          },
          {
            "name": "Code-Review",
            "score": 0,
            "reason": "Found 1/27 approved changesets -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
          },
          {
            "name": "Contributors",
            "score": 10,
            "reason": "project has 16 contributing companies or organizations",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
          },
          {
            "name": "Dangerous-Workflow",
            "score": 10,
            "reason": "no dangerous workflow patterns detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
          },
          {
            "name": "Dependency-Update-Tool",
            "score": 0,
            "reason": "no update tool detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
          },
          {
            "name": "Fuzzing",
            "score": 0,
            "reason": "project is not fuzzed",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
          },
          {
            "name": "License",
            "score": 10,
            "reason": "license file detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
          },
          {
            "name": "Maintained",
            "score": 9,
            "reason": "11 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 9",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
          },
          {
            "name": "Packaging",
            "score": 10,
            "reason": "packaging workflow detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
          },
          {
            "name": "Pinned-Dependencies",
            "score": 0,
            "reason": "dependency not pinned by hash detected -- score normalized to 0",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
          },
          {
            "name": "SAST",
            "score": 2,
            "reason": "SAST tool is not run on all commits -- score normalized to 2",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
          },
          {
            "name": "Security-Policy",
            "score": 0,
            "reason": "security policy file not detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
          },
          {
            "name": "Signed-Releases",
            "score": null,
            "reason": "no releases found",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
          },
          {
            "name": "Token-Permissions",
            "score": 0,
            "reason": "detected GitHub workflow tokens with excessive permissions",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
          },
          {
            "name": "Vulnerabilities",
            "score": 0,
            "reason": "14 existing vulnerabilities detected",
            "documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
          }
        ],
        "commit": "36b6c4f3818176ad5d0e151942eee83a8ef64434",
        "ran_at": "2026-07-25T21:26:55Z",
        "aggregate_score": 3.8,
        "scorecard_version": "v5.5.0"
      },
      "has_codeql_workflow": false,
      "has_security_policy": false,
      "has_dependabot_config": false
    },
    "contribution_flow": {
      "collected": true,
      "ci_last_run_at": "2026-07-15T23:16:00Z",
      "oldest_open_prs": [
        {
          "number": 24,
          "created_at": "2021-04-21T01:50:09Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 29,
          "created_at": "2021-05-01T23:03:00Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 33,
          "created_at": "2021-05-30T23:31:55Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 43,
          "created_at": "2021-10-01T23:52:05Z",
          "last_comment_at": "2021-10-01T23:53:36Z",
          "last_comment_author": "vitorbaptista"
        },
        {
          "number": 58,
          "created_at": "2022-10-11T06:31:50Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 71,
          "created_at": "2024-05-07T22:34:58Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 81,
          "created_at": "2025-04-14T01:34:19Z",
          "last_comment_at": null,
          "last_comment_author": null
        }
      ],
      "last_merged_pr_at": "2026-07-09T17:51:16Z",
      "ci_last_conclusion": "SUCCESS",
      "oldest_open_issues": [
        {
          "number": 12,
          "created_at": "2020-12-30T03:02:49Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 17,
          "created_at": "2021-01-24T22:40:47Z",
          "last_comment_at": "2021-02-16T19:48:14Z",
          "last_comment_author": "jvanz"
        },
        {
          "number": 28,
          "created_at": "2021-04-30T22:54:36Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 41,
          "created_at": "2021-07-25T00:33:27Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 42,
          "created_at": "2021-09-02T00:30:04Z",
          "last_comment_at": "2021-10-17T19:36:26Z",
          "last_comment_author": "jvanz"
        },
        {
          "number": 47,
          "created_at": "2021-10-20T18:45:02Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 48,
          "created_at": "2021-10-22T20:30:39Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 51,
          "created_at": "2022-03-03T14:28:12Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 53,
          "created_at": "2022-04-18T19:06:50Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 54,
          "created_at": "2022-04-25T23:55:49Z",
          "last_comment_at": "2022-04-29T16:39:35Z",
          "last_comment_author": "ogecece"
        },
        {
          "number": 56,
          "created_at": "2022-06-09T21:29:16Z",
          "last_comment_at": "2022-06-09T21:42:04Z",
          "last_comment_author": "trevineju"
        },
        {
          "number": 61,
          "created_at": "2023-10-01T15:56:49Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 62,
          "created_at": "2023-10-01T16:01:13Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 63,
          "created_at": "2023-10-11T18:58:39Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 67,
          "created_at": "2023-12-14T20:12:04Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 69,
          "created_at": "2024-03-22T15:45:07Z",
          "last_comment_at": "2024-05-07T22:40:24Z",
          "last_comment_author": "ogecece"
        },
        {
          "number": 93,
          "created_at": "2026-03-14T15:25:23Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 94,
          "created_at": "2026-03-14T15:25:36Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 95,
          "created_at": "2026-03-15T16:52:30Z",
          "last_comment_at": null,
          "last_comment_author": null
        },
        {
          "number": 96,
          "created_at": "2026-03-15T16:52:33Z",
          "last_comment_at": null,
          "last_comment_author": null
        }
      ]
    }
  },
  "config": {
    "disabled_metrics": [],
    "disabled_categories": [],
    "disabled_components": {}
  },
  "source": {
    "url": "https://github.com/okfn-brasil/querido-diario-api",
    "host": "github.com",
    "name": "querido-diario-api",
    "owner": "okfn-brasil"
  },
  "metrics": {
    "overall": {
      "key": "overall",
      "band": "moderate",
      "name": "Overall health",
      "note": null,
      "notes": [],
      "value": 61,
      "inputs": {
        "security": 38,
        "vitality": 67,
        "community": 65,
        "governance": 58,
        "engineering": 74
      },
      "components": []
    },
    "categories": [
      {
        "key": "vitality",
        "band": "moderate",
        "name": "Vitality",
        "value": 67,
        "weight": 0.22,
        "metrics": [
          {
            "key": "development_activity",
            "band": "moderate",
            "name": "Development activity",
            "note": null,
            "notes": [],
            "value": 55,
            "inputs": {
              "commits_last_year": 25,
              "human_commit_share": 1,
              "days_since_last_push": 9,
              "active_weeks_last_year": 6
            },
            "components": [
              {
                "key": "push_recency",
                "name": "Push recency",
                "detail": "last push 9 days ago",
                "points": 28.8,
                "status": "partial",
                "details": [
                  {
                    "code": "push_recency",
                    "params": {
                      "days": 9
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_cadence",
                "name": "Commit cadence",
                "detail": "6/52 weeks with commits",
                "points": 4.2,
                "status": "partial",
                "details": [
                  {
                    "code": "commit_cadence_weeks",
                    "params": {
                      "weeks": 6
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "commit_volume",
                "name": "Commit volume",
                "detail": "25 commits in the last year",
                "points": 12.7,
                "status": "partial",
                "details": [
                  {
                    "code": "commits_last_year",
                    "params": {
                      "count": 25
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "openssf_scorecard_maintained",
                "name": "OpenSSF Scorecard: Maintained",
                "detail": "11 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 9",
                "points": 9,
                "status": "partial",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "release_discipline",
            "band": "good",
            "name": "Release discipline",
            "note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "openssf_scorecard_signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 84,
            "inputs": {
              "releases_count": 7,
              "latest_release_tag": "v0.22.8",
              "releases_from_tags": false,
              "days_since_latest_release": 9,
              "mean_days_between_releases": 246.1
            },
            "components": [
              {
                "key": "ships_releases",
                "name": "Ships releases",
                "detail": "7 releases published",
                "points": 27,
                "status": "met",
                "details": [
                  {
                    "code": "releases_published",
                    "params": {
                      "count": 7
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "release_recency",
                "name": "Release recency",
                "detail": "latest release 9 days ago",
                "points": 36,
                "status": "met",
                "details": [
                  {
                    "code": "release_recency",
                    "params": {
                      "days": 9
                    }
                  }
                ],
                "max_points": 36
              },
              {
                "key": "release_cadence",
                "name": "Release cadence",
                "detail": "a release every ~246.1 days",
                "points": 12.6,
                "status": "partial",
                "details": [
                  {
                    "code": "release_cadence",
                    "params": {
                      "gap": 246.1
                    }
                  }
                ],
                "max_points": 27
              },
              {
                "key": "openssf_scorecard_signed_releases",
                "name": "OpenSSF Scorecard: Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 10
              }
            ]
          },
          {
            "key": "abandonment",
            "band": "excellent",
            "name": "Abandonment",
            "note": null,
            "notes": [],
            "value": 100,
            "inputs": {
              "cap": null,
              "state": "maintained",
              "guards": [],
              "signals": [],
              "red_flag": false,
              "multiplier_pct": 100,
              "declared_reason": null,
              "unverified_reason": null,
              "unanswered_open_prs": null,
              "unanswered_open_issues": null,
              "days_since_last_merged_pr": null,
              "days_since_last_human_commit": 10,
              "days_since_last_human_commit_is_floor": false
            },
            "components": [
              {
                "key": "project_is_still_maintained",
                "name": "Project is still maintained",
                "detail": "last human commit 10 days ago",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "abandonment_maintained",
                    "params": {
                      "days": 10
                    }
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Is the project alive — is code being written and are releases shipping?"
      },
      {
        "key": "community",
        "band": "moderate",
        "name": "Community & Adoption",
        "value": 65,
        "weight": 0.18,
        "metrics": [
          {
            "key": "popularity",
            "band": "at_risk",
            "name": "Popularity & adoption",
            "note": null,
            "notes": [],
            "value": 48,
            "inputs": {
              "forks": 34,
              "stars": 60,
              "watchers": 14,
              "growth_state": "unverified",
              "growth_factor_pct": 100,
              "growth_unverified_reason": "no_history"
            },
            "components": [
              {
                "key": "stars",
                "name": "Stars",
                "detail": "60 stars",
                "points": 28.7,
                "status": "partial",
                "details": [
                  {
                    "code": "stars",
                    "params": {
                      "count": 60
                    }
                  }
                ],
                "max_points": 60
              },
              {
                "key": "forks",
                "name": "Forks",
                "detail": "34 forks",
                "points": 12.7,
                "status": "partial",
                "details": [
                  {
                    "code": "forks",
                    "params": {
                      "count": 34
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "watchers",
                "name": "Watchers",
                "detail": "14 watchers",
                "points": 6.2,
                "status": "partial",
                "details": [
                  {
                    "code": "watchers",
                    "params": {
                      "count": 14
                    }
                  }
                ],
                "max_points": 15
              }
            ]
          },
          {
            "key": "community_health",
            "band": "excellent",
            "name": "Community health",
            "note": null,
            "notes": [],
            "value": 85,
            "inputs": {
              "has_readme": true,
              "has_license": true,
              "has_contributing": true,
              "has_issue_template": false,
              "has_code_of_conduct": true,
              "has_pull_request_template": false
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 22.5,
                "status": "met",
                "details": [],
                "max_points": 22.5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "recognized license (MIT)",
                "points": 22.5,
                "status": "met",
                "details": [
                  {
                    "code": "license_standard",
                    "params": {}
                  },
                  {
                    "code": "license_spdx",
                    "params": {
                      "spdx": "MIT"
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributing_guide",
                "name": "CONTRIBUTING guide",
                "detail": null,
                "points": 18,
                "status": "met",
                "details": [],
                "max_points": 18
              },
              {
                "key": "code_of_conduct",
                "name": "Code of conduct",
                "detail": null,
                "points": 13.5,
                "status": "met",
                "details": [],
                "max_points": 13.5
              },
              {
                "key": "issue_template",
                "name": "Issue template",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.2
              },
              {
                "key": "pr_template",
                "name": "PR template",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.3
              }
            ]
          }
        ],
        "description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
      },
      {
        "key": "governance",
        "band": "moderate",
        "name": "Sustainability & Governance",
        "value": 58,
        "weight": 0.24,
        "metrics": [
          {
            "key": "maintainer_resilience",
            "band": "at_risk",
            "name": "Maintainer resilience (bus factor)",
            "note": null,
            "notes": [],
            "value": 44,
            "inputs": {
              "bus_factor": 1,
              "contributors_sampled": 13,
              "top_contributor_share": 0.508
            },
            "components": [
              {
                "key": "bus_factor",
                "name": "Bus factor",
                "detail": "1 contributor(s) cover half of all commits",
                "points": 9,
                "status": "partial",
                "details": [
                  {
                    "code": "bus_factor",
                    "params": {
                      "count": 1
                    }
                  }
                ],
                "max_points": 54
              },
              {
                "key": "commit_distribution",
                "name": "Commit distribution",
                "detail": "top contributor authored 51% of commits",
                "points": 11.1,
                "status": "partial",
                "details": [
                  {
                    "code": "top_contributor_share",
                    "params": {
                      "share": 51
                    }
                  }
                ],
                "max_points": 22.5
              },
              {
                "key": "contributor_breadth",
                "name": "Contributor breadth",
                "detail": "13 contributors",
                "points": 13.5,
                "status": "met",
                "details": [
                  {
                    "code": "contributors_sampled",
                    "params": {
                      "count": 13
                    }
                  }
                ],
                "max_points": 13.5
              },
              {
                "key": "openssf_scorecard_contributors",
                "name": "OpenSSF Scorecard: Contributors",
                "detail": "project has 16 contributing companies or organizations",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "responsiveness",
            "band": "moderate",
            "name": "Issue & PR responsiveness",
            "note": null,
            "notes": [],
            "value": 57,
            "inputs": {
              "merged_prs": 46,
              "open_issues": 29,
              "closed_issues": 23,
              "issue_closed_ratio": 0.442,
              "closed_unmerged_prs": 2
            },
            "components": [
              {
                "key": "issue_resolution",
                "name": "Issue resolution",
                "detail": "44% of issues closed",
                "points": 20.7,
                "status": "partial",
                "details": [
                  {
                    "code": "issues_closed_share",
                    "params": {
                      "share": 44
                    }
                  }
                ],
                "max_points": 46.75
              },
              {
                "key": "pr_acceptance",
                "name": "PR acceptance",
                "detail": "46/48 decided PRs merged",
                "points": 36.7,
                "status": "partial",
                "details": [
                  {
                    "code": "decided_prs_merged",
                    "params": {
                      "merged": 46,
                      "decided": 48
                    }
                  }
                ],
                "max_points": 38.25
              },
              {
                "key": "openssf_scorecard_code_review",
                "name": "OpenSSF Scorecard: Code-Review",
                "detail": "Found 1/27 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              }
            ]
          },
          {
            "key": "stewardship",
            "band": "good",
            "name": "Ownership & stewardship",
            "note": null,
            "notes": [],
            "value": 75,
            "inputs": {
              "followers": 546,
              "owner_type": "Organization",
              "is_verified": null,
              "owner_login": "okfn-brasil",
              "public_repos": 119,
              "account_age_days": 5208
            },
            "components": [
              {
                "key": "ownership_backing",
                "name": "Ownership backing",
                "detail": "organization-owned",
                "points": 30,
                "status": "met",
                "details": [
                  {
                    "code": "owner_organization",
                    "params": {}
                  }
                ],
                "max_points": 30
              },
              {
                "key": "verified_domain",
                "name": "Verified domain",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 20
              },
              {
                "key": "owner_reach",
                "name": "Owner reach",
                "detail": "546 followers of okfn-brasil",
                "points": 19.7,
                "status": "partial",
                "details": [
                  {
                    "code": "owner_followers",
                    "params": {
                      "count": 546,
                      "login": "okfn-brasil"
                    }
                  }
                ],
                "max_points": 25
              },
              {
                "key": "track_record",
                "name": "Track record",
                "detail": "119 public repos, account ~14 yr old",
                "points": 25,
                "status": "met",
                "details": [
                  {
                    "code": "public_repos",
                    "params": {
                      "count": 119
                    }
                  },
                  {
                    "code": "account_age_years",
                    "params": {
                      "years": 14
                    }
                  }
                ],
                "max_points": 25
              }
            ]
          }
        ],
        "description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
      },
      {
        "key": "engineering",
        "band": "good",
        "name": "Engineering Quality",
        "value": 74,
        "weight": 0.2,
        "metrics": [
          {
            "key": "engineering_practices",
            "band": "moderate",
            "name": "Engineering practices",
            "note": null,
            "notes": [],
            "value": 64,
            "inputs": {
              "has_ci": true,
              "has_tests": true,
              "has_editorconfig": false,
              "has_linter_config": false,
              "has_precommit_config": false
            },
            "components": [
              {
                "key": "ci_workflows",
                "name": "CI workflows",
                "detail": "3 workflow(s)",
                "points": 24,
                "status": "met",
                "details": [
                  {
                    "code": "ci_workflows",
                    "params": {
                      "count": 3
                    }
                  }
                ],
                "max_points": 24
              },
              {
                "key": "tests_present",
                "name": "Tests present",
                "detail": null,
                "points": 24,
                "status": "met",
                "details": [],
                "max_points": 24
              },
              {
                "key": "linter_config",
                "name": "Linter config",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 16
              },
              {
                "key": "pre_commit_hooks",
                "name": "Pre-commit hooks",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 9.6
              },
              {
                "key": "editorconfig",
                "name": ".editorconfig",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 6.4
              },
              {
                "key": "openssf_scorecard_ci_tests",
                "name": "OpenSSF Scorecard: CI-Tests",
                "detail": "10 out of 12 merged PRs checked by a CI test -- score normalized to 8",
                "points": 16,
                "status": "partial",
                "details": [],
                "max_points": 20
              }
            ]
          },
          {
            "key": "documentation",
            "band": "excellent",
            "name": "Documentation",
            "note": null,
            "notes": [],
            "value": 90,
            "inputs": {
              "topics": [
                "api",
                "fastapi",
                "python",
                "hacktoberfest"
              ],
              "has_wiki": false,
              "homepage": "https://api.queridodiario.ok.org.br/docs",
              "has_readme": true,
              "has_docs_dir": true,
              "has_description": true
            },
            "components": [
              {
                "key": "readme",
                "name": "README",
                "detail": null,
                "points": 30,
                "status": "met",
                "details": [],
                "max_points": 30
              },
              {
                "key": "documentation_directory",
                "name": "Documentation directory",
                "detail": null,
                "points": 25,
                "status": "met",
                "details": [],
                "max_points": 25
              },
              {
                "key": "documentation_homepage_site",
                "name": "Documentation / homepage site",
                "detail": "https://api.queridodiario.ok.org.br/docs",
                "points": 15,
                "status": "met",
                "details": [],
                "max_points": 15
              },
              {
                "key": "repository_description",
                "name": "Repository description",
                "detail": null,
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "topics",
                "name": "Topics",
                "detail": "4 topics",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "topics_count",
                    "params": {
                      "count": 4
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "wiki",
                "name": "Wiki",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          }
        ],
        "description": "Are baseline engineering and documentation practices in place?"
      },
      {
        "key": "security",
        "band": "at_risk",
        "name": "Security",
        "value": 38,
        "weight": 0.16,
        "metrics": [
          {
            "key": "security_posture",
            "band": "at_risk",
            "name": "Security posture",
            "note": "Excluded from scoring (no data or not applicable): Signed-Releases. Remaining weights renormalized.",
            "notes": [
              {
                "code": "excluded_no_data",
                "params": {
                  "components": [
                    "signed_releases"
                  ]
                }
              },
              {
                "code": "weights_renormalized",
                "params": {}
              }
            ],
            "value": 38,
            "inputs": {
              "source": "openssf_scorecard",
              "checks_evaluated": 17,
              "scorecard_version": "v5.5.0",
              "checks_inconclusive": 1,
              "scorecard_aggregate": 3.8
            },
            "components": [
              {
                "key": "binary_artifacts",
                "name": "Binary-Artifacts",
                "detail": "no binaries found in the repo",
                "points": 7.5,
                "status": "met",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "branch_protection",
                "name": "Branch-Protection",
                "detail": "branch protection not enabled on development/release branches",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "ci_tests",
                "name": "CI-Tests",
                "detail": "10 out of 12 merged PRs checked by a CI test -- score normalized to 8",
                "points": 2,
                "status": "partial",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "cii_best_practices",
                "name": "CII-Best-Practices",
                "detail": "no effort to earn an OpenSSF best practices badge detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "code_review",
                "name": "Code-Review",
                "detail": "Found 1/27 approved changesets -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "contributors",
                "name": "Contributors",
                "detail": "project has 16 contributing companies or organizations",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "dangerous_workflow",
                "name": "Dangerous-Workflow",
                "detail": "no dangerous workflow patterns detected",
                "points": 10,
                "status": "met",
                "details": [],
                "max_points": 10
              },
              {
                "key": "dependency_update_tool",
                "name": "Dependency-Update-Tool",
                "detail": "no update tool detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "fuzzing",
                "name": "Fuzzing",
                "detail": "project is not fuzzed",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "license",
                "name": "License",
                "detail": "license file detected",
                "points": 2.5,
                "status": "met",
                "details": [],
                "max_points": 2.5
              },
              {
                "key": "maintained",
                "name": "Maintained",
                "detail": "11 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 9",
                "points": 6.8,
                "status": "partial",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "packaging",
                "name": "Packaging",
                "detail": "packaging workflow detected",
                "points": 5,
                "status": "met",
                "details": [],
                "max_points": 5
              },
              {
                "key": "pinned_dependencies",
                "name": "Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "sast",
                "name": "SAST",
                "detail": "SAST tool is not run on all commits -- score normalized to 2",
                "points": 1,
                "status": "partial",
                "details": [],
                "max_points": 5
              },
              {
                "key": "security_policy",
                "name": "Security-Policy",
                "detail": "security policy file not detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 5
              },
              {
                "key": "signed_releases",
                "name": "Signed-Releases",
                "detail": "no releases found",
                "points": 0,
                "status": "excluded",
                "details": [
                  {
                    "code": "no_data",
                    "params": {}
                  }
                ],
                "max_points": 7.5
              },
              {
                "key": "token_permissions",
                "name": "Token-Permissions",
                "detail": "detected GitHub workflow tokens with excessive permissions",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              },
              {
                "key": "vulnerabilities",
                "name": "Vulnerabilities",
                "detail": "14 existing vulnerabilities detected",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 7.5
              }
            ]
          },
          {
            "key": "high_risk_jurisdiction_exposure",
            "band": "excellent",
            "name": "High-Risk Jurisdiction Exposure",
            "note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
            "notes": [
              {
                "code": "jurisdiction_evidence_limits",
                "params": {}
              }
            ],
            "value": 100,
            "inputs": {
              "meaning": "self-published location evidence; not nationality or citizenship",
              "red_flag": false,
              "exposures": [],
              "policy_countries": [
                "Russia",
                "Iran",
                "North Korea"
              ],
              "review_only_matches": 0,
              "assessed_self_published_locations": 21
            },
            "components": [
              {
                "key": "policy_exposure_multiplier",
                "name": "Policy exposure multiplier",
                "detail": "no confirmed policy-scope location match",
                "points": 100,
                "status": "met",
                "details": [
                  {
                    "code": "jurisdiction_no_match",
                    "params": {}
                  }
                ],
                "max_points": 100
              }
            ]
          }
        ],
        "description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
      },
      {
        "key": "ai_readiness",
        "band": "at_risk",
        "name": "AI Readiness",
        "value": 48,
        "weight": 0,
        "metrics": [
          {
            "key": "ai_agent_context",
            "band": "critical",
            "name": "Agent context & guidance",
            "note": null,
            "notes": [],
            "value": 28,
            "inputs": {
              "has_llms_txt": false,
              "legible_history_share": 0.52,
              "agent_instruction_files": [],
              "agent_instruction_max_bytes": null
            },
            "components": [
              {
                "key": "agent_instructions",
                "name": "Agent instructions",
                "detail": "no CLAUDE.md / AGENTS.md / editor rules",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_agent_instructions",
                    "params": {}
                  }
                ],
                "max_points": 45
              },
              {
                "key": "machine_readable_docs_llms_txt",
                "name": "Machine-readable docs (llms.txt)",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 15
              },
              {
                "key": "legible_commit_history",
                "name": "Legible commit history",
                "detail": "52 of 100 human commits state their intent (structured subject or explanatory body)",
                "points": 27.7,
                "status": "partial",
                "details": [
                  {
                    "code": "legible_history",
                    "params": {
                      "legible": 52,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 40
              }
            ]
          },
          {
            "key": "ai_verify_loop",
            "band": "moderate",
            "name": "Verify loop (build / test / typecheck)",
            "note": null,
            "notes": [],
            "value": 60,
            "inputs": {
              "has_nix": false,
              "has_tests": true,
              "lockfiles": [],
              "has_dockerfile": true,
              "typed_language": false,
              "bootstrap_files": [
                "Makefile"
              ],
              "has_devcontainer": false,
              "has_linter_config": false,
              "typecheck_configs": [],
              "agent_commit_share": 0.11,
              "toolchain_manifests": [],
              "dependency_bot_commit_share": 0
            },
            "components": [
              {
                "key": "one_command_bootstrap",
                "name": "One-command bootstrap",
                "detail": "Makefile",
                "points": 18,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Makefile"
                    }
                  }
                ],
                "max_points": 18
              },
              {
                "key": "automated_tests",
                "name": "Automated tests",
                "detail": null,
                "points": 22,
                "status": "met",
                "details": [],
                "max_points": 22
              },
              {
                "key": "lint_format_config",
                "name": "Lint / format config",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "static_type_checking",
                "name": "Static type checking",
                "detail": null,
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 11
              },
              {
                "key": "reproducible_environment",
                "name": "Reproducible environment",
                "detail": "Dockerfile",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "file_list",
                    "params": {
                      "files": "Dockerfile"
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "demonstrated_agent_practice",
                "name": "Demonstrated agent practice",
                "detail": "11 of the last 100 commits agent-authored or agent-credited",
                "points": 10,
                "status": "met",
                "details": [
                  {
                    "code": "agent_authored_commits",
                    "params": {
                      "count": 11,
                      "sampled": 100
                    }
                  }
                ],
                "max_points": 10
              },
              {
                "key": "automated_maintenance",
                "name": "Automated maintenance",
                "detail": "no automated dependency updates observed",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_dependency_automation",
                    "params": {}
                  }
                ],
                "max_points": 8
              },
              {
                "key": "openssf_scorecard_pinned_dependencies",
                "name": "OpenSSF Scorecard: Pinned-Dependencies",
                "detail": "dependency not pinned by hash detected -- score normalized to 0",
                "points": 0,
                "status": "missed",
                "details": [],
                "max_points": 10
              }
            ]
          },
          {
            "key": "ai_code_legibility",
            "band": "moderate",
            "name": "Code legibility for models",
            "note": null,
            "notes": [],
            "value": 55,
            "inputs": {
              "primary_language": "Python",
              "largest_source_bytes": 30115,
              "source_files_sampled": 40,
              "oversized_source_files": 0
            },
            "components": [
              {
                "key": "type_checkable_code",
                "name": "Type-checkable code",
                "detail": "Python without a type-check config",
                "points": 0,
                "status": "missed",
                "details": [
                  {
                    "code": "no_typecheck_config_language",
                    "params": {
                      "language": "Python"
                    }
                  }
                ],
                "max_points": 45
              },
              {
                "key": "manageable_file_sizes",
                "name": "Manageable file sizes",
                "detail": "0/40 source files over 60KB",
                "points": 55,
                "status": "met",
                "details": [
                  {
                    "code": "oversized_source_files",
                    "params": {
                      "kb": 60,
                      "sampled": 40,
                      "oversized": 0
                    }
                  }
                ],
                "max_points": 55
              }
            ]
          }
        ],
        "description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
      }
    ],
    "metrics_version": "1.13.0"
  },
  "warnings": [
    "Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
    "GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository"
  ],
  "report_type": "repository",
  "generated_at": "2026-07-25T21:27:13.203787Z",
  "schema_version": "0.27.0",
  "badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/o/okfn-brasil/querido-diario-api.svg",
  "full_name": "okfn-brasil/querido-diario-api",
  "license_state": "standard",
  "license_spdx": "MIT"
}

Scores are signals, not warranties. They reflect publicly visible practices on GitHub — not a code audit, and not a security guarantee.

Missing data is excluded and weights renormalized, never scored as zero. Methodology is versioned and open: metrics v1.13.0, schema v0.27.0 — full methodology · metrics wiki.

How one result sits in the wider record: aggregate statistics.