Contains HM Land Registry data Β© Crown copyright and database right 2021. This data is licensed under the Open Government Licence v3.0.
See https://clickhouse.com/docs/en/getting-started/example-datasets/uk-price-paid/
# Download ClickHouse:
$ curl https://clickhouse.com/ | sh
$ ./clickhouse local
ClickHouse local version 25.3.1.1.
:) CREATE TABLE uk_price_paid
(
price UInt32,
date Date,
postcode1 LowCardinality(String),
postcode2 LowCardinality(String),
type Enum8('other' = 0, 'terraced' = 1, 'semi-detached' = 2, 'detached' = 3, 'flat' = 4),
is_new UInt8,
duration Enum8('unknown' = 0, 'freehold' = 1, 'leasehold' = 2),
addr1 String,
addr2 String,
street LowCardinality(String),
locality LowCardinality(String),
town LowCardinality(String),
district LowCardinality(String),
county LowCardinality(String)
)
ENGINE = MergeTree
ORDER BY (postcode1, postcode2, addr1, addr2)
SETTINGS table_disk = 1, disk = disk(type = web, endpoint = 'https://raw.githubusercontent.com/ClickHouse/web-tables-demo/table_disk/uk_price_paid/')
Query id: 21982815-9290-44e6-bc99-595ab0080411
Ok.
0 rows in set. Elapsed: 1.691 sec.
:) SELECT
toYear(date) AS year,
round(avg(price)) AS price,
bar(price, 0, 1000000, 80)
FROM uk_price_paid
GROUP BY year
ORDER BY year ASC
Query id: 7aa7cba7-eac5-40a8-9e0c-326eeb3b7de6
ββyearββ¬ββpriceββ¬βbar(round(avg(price)), 0, 1000000, 80)ββ
β 1995 β 67935 β ββββββ β
β 1996 β 71510 β ββββββ β
β 1997 β 78538 β βββββββ β
β 1998 β 85442 β βββββββ β
β 1999 β 96038 β ββββββββ β
β 2000 β 107489 β βββββββββ β
β 2001 β 118891 β ββββββββββ β
β 2002 β 137955 β βββββββββββ β
β 2003 β 155895 β βββββββββββββ β
β 2004 β 178890 β βββββββββββββββ β
β 2005 β 189361 β ββββββββββββββββ β
β 2006 β 203532 β βββββββββββββββββ β
β 2007 β 219376 β ββββββββββββββββββ β
β 2008 β 217043 β ββββββββββββββββββ β
β 2009 β 213421 β βββββββββββββββββ β
β 2010 β 236113 β βββββββββββββββββββ β
β 2011 β 232807 β βββββββββββββββββββ β
β 2012 β 238384 β βββββββββββββββββββ β
β 2013 β 256928 β βββββββββββββββββββββ β
β 2014 β 280029 β βββββββββββββββββββββββ β
β 2015 β 297282 β ββββββββββββββββββββββββ β
β 2016 β 313543 β βββββββββββββββββββββββββ β
β 2017 β 346486 β ββββββββββββββββββββββββββββ β
β 2018 β 350913 β ββββββββββββββββββββββββββββ β
β 2019 β 352562 β βββββββββββββββββββββββββββββ β
β 2020 β 376855 β βββββββββββββββββββββββββββββββ β
β 2021 β 382166 β βββββββββββββββββββββββββββββββ β
β 2022 β 387415 β βββββββββββββββββββββββββββββββ β
ββββββββ΄βββββββββ΄βββββββββββββββββββββββββββββββββββββββββ
28 rows in set. Elapsed: 0.431 sec. Processed 27.21 million rows, 163.28 MB (63.17 million rows/s., 379.00 MB/s.)
:) Bye.