1INSTALL httpfs; LOAD httpfs;
2-- global total population
3SELECT SUM(population) AS people
4FROM read_parquet('https://s3-west.nrp-nautilus.io/public-population/ghs-pop-2020/hex/h0=*/data_0.parquet',
5                  hive_partitioning => true);
6-- → ~7.84e9
7
8-- roll up to a coarser resolution (parents are precomputed)
9SELECT h6, SUM(population) AS people
10FROM read_parquet('https://s3-west.nrp-nautilus.io/public-population/ghs-pop-2020/hex/h0=*/data_0.parquet',
11                  hive_partitioning => true)
12GROUP BY h6;

1INSTALL httpfs; LOAD httpfs;
2-- global total population
3SELECT SUM(population) AS people
4FROM read_parquet('https://s3-west.nrp-nautilus.io/public-population/ghs-pop-2020/hex/h0=*/data_0.parquet',
5                  hive_partitioning => true);
6-- → ~7.84e9
7
8-- roll up to a coarser resolution (parents are precomputed)
9SELECT h6, SUM(population) AS people
10FROM read_parquet('https://s3-west.nrp-nautilus.io/public-population/ghs-pop-2020/hex/h0=*/data_0.parquet',
11                  hive_partitioning => true)
12GROUP BY h6;