Repository navigation
docs architecture data sources
Updated weekly. Each week publishes two XLSX files.
Base path: https://www.gov.br/anp/pt-br/assuntos/precos-e-defesa-da-concorrencia/precos/arquivos-lpc/{YEAR}/
| PriceTableType | File name pattern | Example |
|---|---|---|
WEEKLY_SUMMARY |
resumo_semanal_lpc_{start}_{end}.xlsx |
resumo_semanal_lpc_2026-06-07_2026-06-13.xlsx |
STATION_DETAIL |
revendas_lpc_{start}_{end}.xlsx |
revendas_lpc_2026-06-07_2026-06-13.xlsx |
Dates use ISO format YYYY-MM-DD. The ANP listing page must be scraped to discover URLs (no fixed permanent URL).
- Fetch the ANP listing page HTML.
- Extract all
hreflinks matchingarquivos-lpc/{year}/(resumo_semanal|revendas)_lpc_*.xlsx. - Compare with locally stored
SurveyWeekrecords. - Download only missing or updated files.
- Parse and import in background (WorkManager, unmetered + charging optional).
Size: ~250–350 KB per week
Sheets: BRASIL, REGIOES, ESTADOS, MUNICIPIOS, CAPITAIS
Rows 0–5 are metadata. Row 6 (0-indexed) is the column header. Data starts at row 7.
| Column | Type | Example |
|---|---|---|
| DATA INICIAL | Excel serial date |
46180 → 2026-06-07 |
| DATA FINAL | Excel serial date |
46186 → 2026-06-13 |
| ESTADO | string (uppercase, no accents) | SAO PAULO |
| MUNICÍPIO | string (uppercase) | ADAMANTINA |
| PRODUTO | string (Portuguese) | ETANOL HIDRATADO |
| NÚMERO DE POSTOS PESQUISADOS | int | 8 |
| UNIDADE DE MEDIDA | string | R$/l |
| PREÇO MÉDIO REVENDA | decimal | 3.42 |
| DESVIO PADRÃO REVENDA | decimal | 0.19 |
| PREÇO MÍNIMO REVENDA | decimal | 3.28 |
| PREÇO MÁXIMO REVENDA | decimal | 3.80 |
| COEF DE VARIAÇÃO REVENDA | decimal | 0.056 |
- ~2,344 municipality rows
- ~380 unique municipalities
- 27 states
- 7 fuel products
Size: ~1.5–2.5 MB per week
Sheet: POSTOS REVENDEDORES
Rows 0–6 are metadata. Row 7 is the column header. Data starts at row 8.
| Column | Type | Example |
|---|---|---|
| CNPJ | string (13 digits, leading zeros lost in Excel) | 61602199002409 |
| RAZÃO | string | COMPANHIA ULTRAGAZ S A |
| FANTASIA | string | ULTRAGAZ |
| ENDEREÇO | string | RUA AMARO CASTRO LIMA |
| NÚMERO | string | 1852 |
| COMPLEMENTO | string | |
| BAIRRO | string | VILA NOVA CAMPO GRANDE |
| CEP | string | 79106361 |
| MUNICÍPIO | string | CAMPO GRANDE |
| ESTADO | string (full name) | MATO GROSSO DO SUL |
| BANDEIRA | string (brand) | ULTRAGAZ |
| PRODUTO | string | GLP |
| UNIDADE DE MEDIDA | string | R$ / 13 kg |
| PREÇO DE REVENDA | decimal | 125.00 |
| DATA DA COLETA | Excel serial date | 46181 |
- ~19,676 price rows
- ~7,386 unique stations (CNPJ)
- 7 product labels (slightly different naming vs summary file)
Summary and station files use different labels. Normalize at import:
| FuelProduct | Summary label | Station label |
|---|---|---|
ETHANOL |
ETANOL HIDRATADO | ETANOL |
GASOLINE_REGULAR |
GASOLINA COMUM | GASOLINA COMUM |
GASOLINE_PREMIUM |
GASOLINA ADITIVADA | GASOLINA ADITIVADA |
DIESEL_S500 |
OLEO DIESEL | DIESEL S500 |
DIESEL_S10 |
OLEO DIESEL S10 | DIESEL S10 |
CNG |
GNV | GNV |
LPG_P13 |
GLP | GLP |
| Scope | Per week | 1 year (~52 weeks) | 5 years |
|---|---|---|---|
| Summary (municipal) | ~2.3K rows | ~120K rows | ~600K rows |
| Station detail | ~20K rows | ~1M rows | ~5M rows |
For millions of rows on-device:
- Store summary data by default (lightweight, covers city search).
- Make station detail opt-in or rolling window (e.g. last 12 weeks).
- Use Room with proper indexes:
(survey_week_id, state, municipality, fuel_product). - FTS5 virtual table for municipality autocomplete.
- Batch insert in transactions (1000 rows/batch).
- Consider WAL mode and
PRAGMA synchronous=NORMALfor import speed.
For full historical backfill, ANP also publishes CSV at: https://www.gov.br/anp/pt-br/centrais-de-conteudo/dados-abertos/serie-historica-de-precos-de-combustiveis
Better for bulk import (streaming), but different schema — evaluate separately.
- Home
- Roadmap
- docs-README
- docs-android-build
- docs-android-design-system
- docs-android-forum
- docs-android-games
- docs-android-map-engine
- docs-android-navigation
- docs-android-ocr-image
- docs-android-ocr-live-framing
- docs-android-premium-area
- docs-android-premium-integration
- docs-android-release
- docs-android-ui-containers
- docs-architecture-android-stack
- docs-architecture-android
- docs-architecture-backend
- docs-architecture-data-sources
- docs-architecture-overview
- docs-architecture-sources-ev-research
- docs-architecture-sources-national-limits
- docs-architecture-sources-national-stations
- docs-architecture-sources-register
- docs-assets-app-tutorial-CAPTURE_CONTRACT
- docs-assets-app-tutorial-FABLE_LANDING_POLISH_PROMPT
- docs-assets-app-tutorial-README
- docs-assets-attribution
- docs-assets-brand-README
- docs-assets-flags-ATTRIBUTION
- docs-assets-fuel-icons-README
- docs-assets-games-fuel-v1-README
- docs-assets-home-icons-README
- docs-assets-landing-fleet-android-20261012-BRIEF
- docs-assets-landing-hero-20261011-BRIEF
- docs-assets-landing-illustrated-20261012-BRIEF
- docs-assets-landing-illustrated-20261012-README
- docs-assets-landing-minimal-20261012-BRIEF
- docs-assets-landing-open-data-20261026-BRIEF
- docs-assets-landing-redesign-20261011-PREPARATION_EVIDENCE
- docs-assets-landing-redesign-20261011-README
- docs-assets-landing-redesign-20261011-REFERENCE_BRIEF
- docs-assets-landing-sync-20261012-BRIEF
- docs-assets-map-icons-README
- docs-backend-anp-ingestion
- docs-backend-api
- docs-backend-community-pricing
- docs-backend-data-model
- docs-backend-domain-model
- docs-backend-driver-private-data
- docs-backend-forum-architecture
- docs-backend-forum-bulletins
- docs-backend-forum-sources
- docs-backend-payments-provider-admission
- docs-backend-payments-provider-register
- docs-backend-photos-capture
- docs-backend-photos-subset-submission
- docs-backend-premium-api
- docs-backend-premium-cloud-protocol
- docs-backend-testing
- docs-backend-toolchain
- docs-brand-app-icons
- docs-brand-identity
- docs-decisions-001-kotlin-compose-stack
- docs-decisions-002-price-import-immutability
- docs-decisions-003-nominatim-reverse-geocode
- docs-decisions-005-modular-monolith-and-postgresql
- docs-decisions-006-official-catalog-and-exact-contracts
- docs-decisions-007-anonymous-proof-of-possession
- docs-decisions-008-privacy-and-retention
- docs-decisions-009-community-consensus-and-projections
- docs-decisions-010-private-object-evidence
- docs-decisions-012-licensing-and-hosted-business
- docs-decisions-015-kotlin-multiplatform-shared-domain
- docs-decisions-016-android-commercial-community-ios-deferred
- docs-decisions-017-station-profile-and-verified-representation
- docs-decisions-021-community-first-contribution
- docs-decisions-022-comaps-derived-native-map-engine
- docs-decisions-023-admin-suite-granted-tiers-contributors
- docs-decisions-025-private-abastevo-empresas-organization-boundary
- docs-decisions-026-multilingual-public-site
- docs-decisions-README
- docs-enterprise-README
- docs-enterprise-architecture
- docs-enterprise-backlog-INDEX
- docs-enterprise-backlog-ep00-governance
- docs-enterprise-backlog-ep01-platform
- docs-enterprise-backlog-ep02-organizations
- docs-enterprise-backlog-ep03-identity-access
- docs-enterprise-backlog-ep04-sync
- docs-enterprise-backlog-ep05-fleet-meters
- docs-enterprise-backlog-ep06-trips
- docs-enterprise-backlog-ep07-gps-navigation
- docs-enterprise-backlog-ep08-fuelings
- docs-enterprise-backlog-ep09-documents
- docs-enterprise-backlog-ep10-expenses-finance
- docs-enterprise-backlog-ep11-maintenance
- docs-enterprise-backlog-ep12-fuel-stock
- docs-enterprise-backlog-ep13-intelligence
- docs-enterprise-backlog-ep14-station-claims
- docs-enterprise-backlog-ep15-station-commerce
- docs-enterprise-backlog-ep16-subscriptions
- docs-enterprise-backlog-ep17-data
- docs-enterprise-backlog-ep18-imports-notifications-integrations
- docs-enterprise-backlog-ep19-back-office
- docs-enterprise-backlog-ep20-release
- docs-enterprise-business-rules
- docs-enterprise-contract
- docs-enterprise-conventions
- docs-enterprise-data-offering
- docs-enterprise-decisions
- docs-enterprise-domain-model
- docs-enterprise-glossary
- docs-enterprise-journeys
- docs-enterprise-modules-back-office
- docs-enterprise-modules-data
- docs-enterprise-modules-documents
- docs-enterprise-modules-expenses-finance
- docs-enterprise-modules-fleet
- docs-enterprise-modules-fuel-stock
- docs-enterprise-modules-fuelings
- docs-enterprise-modules-gps-navigation
- docs-enterprise-modules-identity
- docs-enterprise-modules-imports-notifications-integrations
- docs-enterprise-modules-intelligence
- docs-enterprise-modules-maintenance
- docs-enterprise-modules-organizations
- docs-enterprise-modules-station-claims
- docs-enterprise-modules-station-commerce
- docs-enterprise-modules-subscriptions
- docs-enterprise-modules-trips
- docs-enterprise-offline-sync
- docs-enterprise-permissions
- docs-enterprise-portal-routes
- docs-enterprise-privacy-security
- docs-enterprise-product-vision
- docs-enterprise-source-admission
- docs-enterprise-state-model
- docs-enterprise-testing
- docs-enterprise-ux-app
- docs-enterprise-ux-web
- docs-operations-README
- docs-operations-backup
- docs-operations-deploy-agent
- docs-operations-dou-editions
- docs-operations-edge-cache
- docs-operations-enterprise-activation
- docs-operations-map-static-overlay
- docs-operations-moderation-feedback
- docs-operations-moderation-profiles
- docs-operations-monitoring
- docs-operations-operator-access
- docs-operations-payments
- docs-operations-premium-billing
- docs-operations-recovery
- docs-operations-registry-daily-sync
- docs-operations-registry-runs
- docs-product-README
- docs-product-admin-tiers
- docs-product-community-community-first
- docs-product-community-experience
- docs-product-community-metrics
- docs-product-community-moderation
- docs-product-community-safety
- docs-product-community-terms-pt-br
- docs-product-driver-suite-README
- docs-product-driver-suite-android-state
- docs-product-driver-suite-cloud-sync
- docs-product-driver-suite-cost-profiles-and-maintenance
- docs-product-driver-suite-driver-model-and-earnings
- docs-product-driver-suite-foundation-decisions
- docs-product-driver-suite-gps-lifecycle
- docs-product-driver-suite-mobile-hub
- docs-product-driver-suite-odometer-review
- docs-product-driver-suite-outbox-wire
- docs-product-driver-suite-quick-refuel
- docs-product-driver-suite-reports
- docs-product-driver-suite-shifts-and-distance
- docs-product-driver-suite-signed-commands
- docs-product-ev-README
- docs-product-ev-charging-stop-planner
- docs-product-ev-energy-model
- docs-product-ev-financial-method
- docs-product-ev-journey-ui
- docs-product-ev-preparation
- docs-product-ev-typed-data
- docs-product-exploration
- docs-product-forum-contract
- docs-product-forum-policies
- docs-product-glossary
- docs-product-landing-content
- docs-product-landing-guides
- docs-product-landing-organic-growth-i18n-plan
- docs-product-licensing
- docs-product-map-discovery
- docs-product-map-favorites-and-trips
- docs-product-map-reports-routing-guidance
- docs-product-notification-content
- docs-product-official-prices
- docs-product-open-source-business
- docs-product-overview
- docs-product-payments-README
- docs-product-payments-offer-policy
- docs-product-premium-README
- docs-product-premium-financial-method
- docs-product-premium-source-policy
- docs-product-stations-catalog
- docs-product-stations-fuel-feedback
- docs-product-stations-fuel-quality
- docs-product-stations-identity-and-ev-catalog
- docs-product-stations-profile-contract
- docs-product-stations-profile-representation
- docs-product-stations-registry-sources
- docs-product-vehicle-registration
- docs-product-vehicles-and-occurrences
- docs-security-android-terms-acceptance
- docs-security-free-account-access
- docs-security-identity-profile
- docs-security-media-location-policy
- docs-security-privacy-notice
- docs-security-privacy-policy
- docs-security-retention
- docs-security-risks
- docs-security-security-privacy
- docs-store-README
- docs-store-play-readiness
- docs-store-play-store-listing
- docs-store-ugc-safety
Source: AlexandreZanata/Abastevo @ e4a67580fc368a59bc1c0f1e0466fc011313f330