Open Data: polskie przetargi publiczne (BZP + TED, 1,4 mln rekordów)

import pandas as pd

df = pd.read_parquet(
  "https://github.com/atlasprzetargow/"
  "polish-tenders-dataset/raw/main/"
  "data/tenders_2025.parquet"
)

print(df.shape)
print(df.columns)

SELECT province,
       COUNT(*),
       SUM(estimated_value)
FROM 'https://github.com/atlasprzetargow/
  polish-tenders-dataset/raw/main/
  data/tenders_2025.parquet'
WHERE is_duplicate = false
GROUP BY province
ORDER BY 2 DESC;