42,9 % af de ejerlejligheder, der er til salg i København, er sat ned i pris

Alle aktive annoncer på hentedagen, og hvor mange af dem der ligger i postnummer 1000-2500.

SELECT count(*)                                            AS annoncer,
       count(DISTINCT postnummer)                          AS postnumre,
       min(fetched_at)::date                               AS aeldste_observation,
       max(fetched_at)::date                               AS nyeste_observation,
       count(*) FILTER (WHERE postnummer::int BETWEEN 1000 AND 2500) AS heraf_koebenhavn
FROM boligsiden_annonce
WHERE fetched_at::date = (SELECT max(fetched_at)::date FROM boligsiden_annonce)
  AND postnummer ~ '^[0-9]{4}$'

Andel med mindst én prisnedsættelse over annoncens levetid, efter Boligsidens eget felt.

SELECT CASE WHEN postnummer::int BETWEEN 1000 AND 2500
            THEN 'København og Frederiksberg' ELSE 'Resten af landet' END AS omraade,
       ejendomstype,
       count(*)                                                   AS aktive,
       count(*) FILTER (WHERE pris_aendring < 0)                  AS nedsat,
       round(100.0 * count(*) FILTER (WHERE pris_aendring < 0) / count(*), 1) AS pct_nedsat,
       round(percentile_cont(0.5) WITHIN GROUP (ORDER BY pris_aendring)
             FILTER (WHERE pris_aendring BETWEEN -95 AND -0.01)::numeric, 1) AS median_nedsaettelse_pct,
       round(percentile_cont(0.25) WITHIN GROUP (ORDER BY pris_aendring)
             FILTER (WHERE pris_aendring BETWEEN -95 AND -0.01)::numeric, 1) AS q1_nedsaettelse_pct,
       count(*) FILTER (WHERE pris_aendring < -95 OR pris_aendring > 95)     AS uden_for_graensen
FROM boligsiden_annonce
WHERE fetched_at::date = (SELECT max(fetched_at)::date FROM boligsiden_annonce)
  AND postnummer ~ '^[0-9]{4}$'
  AND ejendomstype IN ('condo', 'villa', 'terraced house')
GROUP BY 1, 2
HAVING count(*) >= 40
ORDER BY 1 DESC, 2

Vores egen sammenligning af første og seneste observerede pris, 8. juli til 16. september 2026.

SELECT CASE WHEN postnummer::int BETWEEN 1000 AND 2500
            THEN 'København og Frederiksberg' ELSE 'Resten af landet' END AS omraade,
       ejendomstype,
       count(*)                                                     AS fulgt_hele_vinduet,
       count(*) FILTER (WHERE seneste_pris < foerste_pris)          AS nedsat_i_vinduet,
       round(100.0 * count(*) FILTER (WHERE seneste_pris < foerste_pris) / count(*), 1) AS pct,
       round(percentile_cont(0.5) WITHIN GROUP (
             ORDER BY 100.0 * (seneste_pris - foerste_pris) / foerste_pris)
             FILTER (WHERE seneste_pris < foerste_pris)::numeric, 1) AS median_nedsaettelse_pct
FROM annonce_forloeb
WHERE forsvundet_dato IS NULL AND foerste_pris > 0
  AND udbudsdato <= DATE '2026-07-15'
  AND postnummer ~ '^[0-9]{4}$'
  AND ejendomstype IN ('condo', 'villa', 'terraced house')
GROUP BY 1, 2
HAVING count(*) >= 40
ORDER BY 1 DESC, 2

Hvor længe de annoncer, der er aktive nu, har ligget. Beholdning, ikke strøm.

SELECT CASE WHEN postnummer::int BETWEEN 1000 AND 2500
            THEN 'København og Frederiksberg' ELSE 'Resten af landet' END AS omraade,
       count(*)                                                        AS aktive,
       percentile_cont(0.25) WITHIN GROUP (ORDER BY dage_paa_marked)::int AS p25_dage,
       percentile_cont(0.50) WITHIN GROUP (ORDER BY dage_paa_marked)::int AS median_dage,
       percentile_cont(0.75) WITHIN GROUP (ORDER BY dage_paa_marked)::int AS p75_dage,
       percentile_cont(0.90) WITHIN GROUP (ORDER BY dage_paa_marked)::int AS p90_dage,
       count(*) FILTER (WHERE dage_paa_marked <=  30)                  AS d_0_30,
       count(*) FILTER (WHERE dage_paa_marked >   30 AND dage_paa_marked <=  90) AS d_31_90,
       count(*) FILTER (WHERE dage_paa_marked >   90 AND dage_paa_marked <= 180) AS d_91_180,
       count(*) FILTER (WHERE dage_paa_marked >  180)                  AS d_over_180
FROM boligsiden_annonce
WHERE fetched_at::date = (SELECT max(fetched_at)::date FROM boligsiden_annonce)
  AND postnummer ~ '^[0-9]{4}$' AND ejendomstype = 'condo'
GROUP BY 1
ORDER BY 1 DESC

Ejerlejligheder pr. postnummer i København, kun postnumre med mindst 40 annoncer.

SELECT a.postnummer::int                                              AS postnr,
       (SELECT h.postdistrikt FROM husnummer h
         WHERE h.postnummer = a.postnummer LIMIT 1)                   AS bynavn,
       count(*)                                                       AS aktive,
       round(100.0 * count(*) FILTER (WHERE a.pris_aendring < 0) / count(*), 1) AS pct_nedsat,
       percentile_cont(0.5) WITHIN GROUP (ORDER BY a.dage_paa_marked)::int      AS median_dage,
       percentile_cont(0.5) WITHIN GROUP (
             ORDER BY a.pris / nullif(a.areal_m2, 0))::int            AS median_udbudt_kr_m2
FROM boligsiden_annonce a
WHERE a.fetched_at::date = (SELECT max(fetched_at)::date FROM boligsiden_annonce)
  AND a.postnummer ~ '^[0-9]{4}$' AND a.postnummer::int BETWEEN 1000 AND 2500
  AND a.ejendomstype = 'condo'
GROUP BY 1, a.postnummer
HAVING count(*) >= 40
ORDER BY 4 DESC

Danmarks Statistiks sæsonkorrigerede antal salg, EJ121, Region Hovedstaden.

SELECT periode,
       max(vaerdi) FILTER (WHERE noegletal = 'Antal salg, sæsonkorrigeret') AS antal_salg
FROM dst_ejendomspris
WHERE tabel_kode = 'EJ121' AND omraade = 'Region Hovedstaden'
  AND ejendomstype = 'Ejerlejligheder, i alt'
  AND periode >= '2019K1'
GROUP BY periode
ORDER BY periode