Registro público
Informe de salud del softwareesquema 0.27.0 · métricas 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 estrellas⑂ 34 forksdesde ago 2020Ver en GitHub ↗
#api#fastapi#python#hacktoberfest

okfn-brasil/querido-diario-api tiene un índice de salud de 61 sobre 100, lo que lo sitúa en la banda Moderado. Su puntuación más alta es Engineering Quality (74/100) y la más baja, Security (38/100). Se actualizó por última vez hace 9 días. Una sola persona concentra la mayor parte del trabajo reciente.

61
global / 100
Moderado

Índice de salud del software

Las métricas se agrupan en categorías ponderadas sobre una escala de 1 a 100. El resultado global parte de su media; cuando la evidencia pública activa la Política de Jurisdicciones de Alto Riesgo, la calificación se ajusta y recibe el límite 49 (En riesgo). Preparación para IA queda fuera.

61
Excelente85-100Ejemplar; cumple prácticamente todos los criterios evaluados
Bueno70-84Saludable; carencias menores
Moderado50-69Aceptable con carencias notables; se recomienda revisión
En riesgo30-49Debilidades significativas; su adopción exige cautela
Crítico1-29Problemas graves (proyecto abandonado, un solo mantenedor, sin higiene)
VitalidadComunidad yAdopciónSostenibilidady GobernanzaCalidad deIngenieríaSeguridadPreparaciónpara IA

Perfil de puntuación

Cada eje es una categoría. La forma importa más que la media: un proyecto sano llena toda la figura, mientras que un perfil de picos y cráteres indica que la fortaleza en una dimensión enmascara el riesgo en otra.

Titularidad

Open Knowledge Brasil - Rede pelo Conhecimento LivreOrganización
546 seguidores119 repositorios públicosdesde abr 2012

Este repositorio está respaldado por una organización: una custodia compartida y responsable que puede sobrevivir a cualquier mantenedor individual.

Métricas por categoría

Vitalidad

¿Está vivo el proyecto: se escribe código y se publican versiones?

67Moderado · 22% del índice global

Actividad de desarrollo

55Moderado
Cómo se puntúa
28.8/36Recencia de push — último push hace 9 días
4.2/36Cadencia de commits — 6/52 semanas con commits
12.7/18Volumen de commits — 25 commits en el último año
9/10OpenSSF Scorecard: Maintained — 11 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 9
Datos de entrada utilizados
commits_last_year25
human_commit_share1
days_since_last_push9
active_weeks_last_year6

Disciplina de publicación

84Bueno
Cómo se puntúa
27/27Publica versiones — 7 versiones publicadas
36/36Recencia de las versiones — última versión hace 9 días
12.6/27Cadencia de publicación — una versión cada ~246,1 días
0/10OpenSSF Scorecard: Signed-Releases — sin datos
Datos de entrada utilizados
releases_count7
latest_release_tagv0.22.8
releases_from_tagsno
days_since_latest_release9
mean_days_between_releases246,1
Excluidos de la puntuación (sin datos o no aplicable): OpenSSF Scorecard: Signed-Releases. Los pesos restantes se han renormalizado.

Comunidad y Adopción

¿Tiene el proyecto usuarios, descargas, atención y unas condiciones acogedoras para quienes contribuyen?

65Moderado · 18% del índice global

Popularidad y adopción

48En riesgo
Cómo se puntúa
28.7/60Estrellas — 60 estrellas
12.7/25Forks — 34 forks
6.2/15Observadores — 14 observadores
Datos de entrada utilizados
forks34
stars60
watchers14
growth_stateunverified
growth_factor_pct100
growth_unverified_reasonno_history

Salud de la comunidad

85Excelente
Cómo se puntúa
22.5/22.5README
22.5/22.5Licencia — licencia reconocida (MIT)
18/18Guía CONTRIBUTING
13.5/13.5Código de conducta
0/7.2Plantilla de issues
0/6.3Plantilla de PR
Datos de entrada utilizados
has_readmesí
has_licensesí
has_contributingsí
has_issue_templateno
has_code_of_conductsí
has_pull_request_templateno

Sostenibilidad y Gobernanza

¿Sobrevivirá el proyecto a sus personas: factor bus, capacidad de respuesta, quién lo respalda y mantenimiento del paquete?

58Moderado · 24% del índice global

Resiliencia de mantenedores (factor bus)

44En riesgo
Cómo se puntúa
9/54Factor bus — la mitad de los commits recae en 1 contribuyente(s)
11.1/22.5Distribución de commits — el principal contribuyente firma el 51% de los commits
13.5/13.5Amplitud de contribuyentes — 13 contribuyentes
10/10OpenSSF Scorecard: Contributors — project has 16 contributing companies or organizations
Datos de entrada utilizados
bus_factor1
contributors_sampled13
top_contributor_share0,508

Capacidad de respuesta a issues y PR

57Moderado
Cómo se puntúa
20.7/46.8Resolución de issues — 44% de issues cerradas
36.7/38.3Aceptación de PR — 46/48 PR decididos fusionados
0/15OpenSSF Scorecard: Code-Review — Found 1/27 approved changesets -- score normalized to 0
Datos de entrada utilizados
merged_prs46
open_issues29
closed_issues23
issue_closed_ratio0,442
closed_unmerged_prs2

Propiedad y custodia

75Bueno
Cómo se puntúa
30/30Respaldo de la propiedad — propiedad de una organización
0/20Dominio verificado
19.7/25Alcance del propietario — 546 seguidores de okfn-brasil
25/25Trayectoria — 119 repos públicos, cuenta de ~14 años
Datos de entrada utilizados
followers546
owner_typeOrganization
is_verified—
owner_loginokfn-brasil
public_repos119
account_age_days5208

Calidad de Ingeniería

¿Existen unas prácticas mínimas de ingeniería y documentación?

74Bueno · 20% del índice global

Prácticas de ingeniería

64Moderado
Cómo se puntúa
24/24Flujos de trabajo de CI — 3 flujo(s) de trabajo
24/24Pruebas presentes
0/16Configuración de linter
0/9.6Hooks de pre-commit
0/6.4.editorconfig
16/20OpenSSF Scorecard: CI-Tests — 10 out of 12 merged PRs checked by a CI test -- score normalized to 8
Datos de entrada utilizados
has_cisí
has_testssí
has_editorconfigno
has_linter_configno
has_precommit_configno

Documentación

90Excelente
Cómo se puntúa
30/30README
25/25Directorio de documentación
15/15Sitio de documentación / página del proyecto — https://api.queridodiario.ok.org.br/docs
10/10Descripción del repositorio
10/10Topics — 4 topics
0/10Wiki
Datos de entrada utilizados
topicsapi, fastapi, python, hacktoberfest
has_wikino
homepagehttps://api.queridodiario.ok.org.br/docs
has_readmesí
has_docs_dirsí
has_descriptionsí

Seguridad

¿Son sólidas las prácticas visibles de seguridad y de cadena de suministro, sin exposición jurisdiccional de alto riesgo sin resolver?

38En riesgo · 16% del índice global

Postura de seguridad

38En riesgo
Cómo se puntúa
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.5Licencia — 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 — sin datos
0/7.5Token-Permissions — detected GitHub workflow tokens with excessive permissions
0/7.5Vulnerabilities — 14 existing vulnerabilities detected
Datos de entrada utilizados
sourceopenssf_scorecard
checks_evaluated17
scorecard_versionv5.5.0
checks_inconclusive1
scorecard_aggregate3,8
Excluidos de la puntuación (sin datos o no aplicable): signed_releases. Los pesos restantes se han renormalizado.

Preparación para IA

¿Hasta qué punto está el repositorio preparado para desarrollarse y mantenerse con agentes de codificación de IA? Es una insignia independiente y experimental — peso 0,0, de modo que se presenta por separado y no afecta a la puntuación de salud global.

48En riesgo · 0% del índice global

Contexto y guía para agentes

28Crítico
Cómo se puntúa
0/45Instrucciones para agentes — sin CLAUDE.md / AGENTS.md / reglas de editor
0/15Documentación legible por máquinas (llms.txt)
27.7/40Historial de commits legible — 52 de 100 commits humanos declaran su intención (asunto estructurado o cuerpo explicativo)
Datos de entrada utilizados
has_llms_txtno
legible_history_share0,52
agent_instruction_files—
agent_instruction_max_bytes—

Bucle de verificación (compilación / pruebas / verificación de tipos)

60Moderado
Cómo se puntúa
18/18Arranque con un solo comando — Makefile
22/22Pruebas automatizadas
0/11Configuración de lint / formato
0/11Verificación estática de tipos
10/10Entorno reproducible — Dockerfile
10/10Práctica demostrada con agentes — 11 de los últimos 100 commits con autoría o crédito de agente
0/8Mantenimiento automatizado — no se observan actualizaciones automáticas de dependencias
0/10OpenSSF Scorecard: Pinned-Dependencies — dependency not pinned by hash detected -- score normalized to 0
Datos de entrada utilizados
has_nixno
has_testssí
lockfiles—
has_dockerfilesí
typed_languageno
bootstrap_filesMakefile
has_devcontainerno
has_linter_configno
typecheck_configs—
agent_commit_share0,11
toolchain_manifests—
dependency_bot_commit_share0

Legibilidad del código para modelos

55Moderado
Cómo se puntúa
0/45Código verificable por tipos — Python sin configuración de verificación de tipos
55/55Tamaños de archivo manejables — 0/40 archivos fuente de más de 60 KB
Datos de entrada utilizados
primary_languagePython
largest_source_bytes30.115
source_files_sampled40
oversized_source_files0

Datos clave

60estrellas de GitHub
13contribuidores
25commits en los últimos 12 meses
9días desde el último push
7versiones publicadas
1factor bus
29issues abiertas
PyPIecosistemas de paquetes

Advertencias de recopilación de datos

  • 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

Más detalle

Historial de estrellas y forks 0 ★ / 34 ⇿
0Estrellas
34Forks
1Versiones

Cuándo se añadió cada estrella y fork, recopilado de GitHub y agrupado por día. El crecimiento acumulado se sitúa justo encima de las adiciones diarias que lo componen, de modo que ambos se leen en conjunto: la acumulación orgánica sostenida no se parece en nada a un pico abrupto y efímero. Cuando esa diferencia es medible, se informa como autenticidad del crecimiento.

01325383442020-082023-072026-06
Mayor 0Menor 0Parche 1

Cada punto abarca 6 días.

OpenSSF Scorecard 3.8 / 10
3.8agregado

Evaluación de seguridad independiente y agnóstica en cuanto a herramientas, procedente del proyecto de código abierto OpenSSF Scorecard. Cada comprobación premia una práctica de seguridad, no la herramienta de un proveedor concreto. Las comprobaciones que Scorecard no pudo determinar se marcan como n/d y se excluyen de la puntuación de seguridad (nunca se cuentan como cero).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/dSigned-Releasesno releases found
0Token-Permissionsdetected GitHub workflow tokens with excessive permissions
0Vulnerabilities14 existing vulnerabilities detected
Todas las dependencias no recopilado

No fue posible recopilar el conjunto de dependencias resuelto para este informe: GitHub dependency-graph SBOM unavailable (404); the dependency graph may be disabled for this repository

Informe JSON sin procesar legible por máquina
{
  "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"
}

Registros relacionados

Repositorios inspeccionados que comparten etiquetas de catálogo o ecosistemas con okfn-brasil/querido-diario-api. Leer en paralelo →

86fastapi/fastapiFastAPI framework, high performance, easy to learn, fast to code, ready for productionExcelente92psf/blackThe uncompromising Python code formatterExcelente91home-assistant/core:house_with_garden: Open source home automation that puts local control and privacy first.Excelente91pylint-dev/pylintIt's not just a linter that annoys you!Excelente89litestar-org/litestarLight, flexible and extensible ASGI framework | Built to scaleExcelente89pyvista/pyvista3D visualization and mesh analysis for science and engineeringExcelente

Las puntuaciones son señales, no garantías. Reflejan prácticas públicamente visibles en GitHub; no son una auditoría de código ni una garantía de seguridad.

Los datos ausentes se excluyen y los pesos se renormalizan; nunca se puntúan como cero. La metodología es versionada y abierta: métricas v1.13.0, esquema v0.27.0 — metodología completa · wiki de métricas.

Cómo se sitúa un resultado dentro del registro general: estadísticas agregadas.