Skip to content

Instantly share code, notes, and snippets.

View henryjameslau's full-sized avatar

Henry Lau henryjameslau

17 followers · 12 following
View GitHub Profile
@henryjameslau
henryjameslau / HenryOverrides.css
Created February 22, 2024 11:17
Test overrides css
@font-face {
font-family: BBCReithSans;
src: url("https://static.files.bbci.co.uk/fonts/reith/2.512/BBCReithSans_W_Rg.woff2");
}
@font-face {
font-family: BBCReithSans;
src: url("https://static.files.bbci.co.uk/fonts/reith/2.512/BBCReithSans_W_Bd.woff2");
font-weight: bold;
}
@henryjameslau
henryjameslau / metadata-suggested-categories.csv
Created April 5, 2023 20:07
metadata-suggested-categories
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 11 columns, instead of 6. in line 7.
ITEM_ID,ITEM_START,BASE_DATE,CATEGORY,SUB CATEGORY 1,SUB CATEGORY 2,ITEM_DESC,WEIGHT\SIZE,AVERAGE_PRICE,Category1,Category2
210102,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Large white unsliced bread,750-800g,1.255,Food,Bread
210106,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Bread rolls (white or brown),pack of 6,0.948,Food,Bread
210111,200402,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,White sliced bread,750-800g,1.105,Food,Bread
210113,200402,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Wholemeal sliced bread,750-800g,1.021,Food,Bread
210114,201002,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Chilled garlic bread,,0.891,Food,Bread
210201,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Flours and other cereals,Self-raising flour,1.5kg,0.625,Food,Store cupboard
210204,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Pasta
@henryjameslau
henryjameslau / metadata-lowest-category.csv
Created March 29, 2023 13:41
metadata-lowest-category
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 10 columns, instead of 7. in line 7.
ITEM_ID,ITEM_START,BASE_DATE,CATEGORY,SUB CATEGORY 1,SUB CATEGORY 2,lowestCategory,ITEM_DESC,WEIGHT\SIZE,AVERAGE_PRICE
210102,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Bread,Large white unsliced bread,750-800g,1.255
210106,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Bread,Bread rolls (white or brown),pack of 6,0.948
210111,200402,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Bread,White sliced bread,750-800g,1.105
210113,200402,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Bread,Wholemeal sliced bread,750-800g,1.021
210114,201002,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread,Bread,Chilled garlic bread,,0.891
210201,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Flours and other cereals,Flours and other cereals,Self-raising flour,1.5kg,0.625
210204,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Pasta products and couscous,Pas
@henryjameslau
henryjameslau / annualgrowth.csv
Created March 8, 2023 15:19
We can't make this file beautiful and searchable because it's too large.
ITEM_ID,2017-01-01,2017-02-01,2017-03-01,2017-04-01,2017-05-01,2017-06-01,2017-07-01,2017-08-01,2017-09-01,2017-10-01,2017-11-01,2017-12-01,2018-01-01,2018-02-01,2018-03-01,2018-04-01,2018-05-01,2018-06-01,2018-07-01,2018-08-01,2018-09-01,2018-10-01,2018-11-01,2018-12-01,2019-01-01,2019-02-01,2019-03-01,2019-04-01,2019-05-01,2019-06-01,2019-07-01,2019-08-01,2019-09-01,2019-10-01,2019-11-01,2019-12-01,2020-01-01,2020-02-01,2020-03-01,2020-04-01,2020-05-01,2020-06-01,2020-07-01,2020-08-01,2020-09-01,2020-10-01,2020-11-01,2020-12-01,2021-01-01,2021-02-01,2021-03-01,2021-04-01,2021-05-01,2021-06-01,2021-07-01,2021-08-01,2021-09-01,2021-10-01,2021-11-01,2021-12-01,2022-01-01,2022-02-01,2022-03-01,2022-04-01,2022-05-01,2022-06-01,2022-07-01,2022-08-01,2022-09-01,2022-10-01,2022-11-01,2022-12-01,2023-01-01
210102,,,,,,,,,,,,,0.39000000000000057,2.9982458682501405,3.495194355316667,0.15716856731958445,1.167236593444556,-0.8762593506286843,6.483205657041835,7.266906463511757,4.782373574615769,2.9796410318322595,2.3956
@henryjameslau
henryjameslau / monthlygrowth.csv
Created March 8, 2023 15:18
We can't make this file beautiful and searchable because it's too large.
ITEM_ID,2017-01-01,2017-02-01,2017-03-01,2017-04-01,2017-05-01,2017-06-01,2017-07-01,2017-08-01,2017-09-01,2017-10-01,2017-11-01,2017-12-01,2018-01-01,2018-02-01,2018-03-01,2018-04-01,2018-05-01,2018-06-01,2018-07-01,2018-08-01,2018-09-01,2018-10-01,2018-11-01,2018-12-01,2019-01-01,2019-02-01,2019-03-01,2019-04-01,2019-05-01,2019-06-01,2019-07-01,2019-08-01,2019-09-01,2019-10-01,2019-11-01,2019-12-01,2020-01-01,2020-02-01,2020-03-01,2020-04-01,2020-05-01,2020-06-01,2020-07-01,2020-08-01,2020-09-01,2020-10-01,2020-11-01,2020-12-01,2021-01-01,2021-02-01,2021-03-01,2021-04-01,2021-05-01,2021-06-01,2021-07-01,2021-08-01,2021-09-01,2021-10-01,2021-11-01,2021-12-01,2022-01-01,2022-02-01,2022-03-01,2022-04-01,2022-05-01,2022-06-01,2022-07-01,2022-08-01,2022-09-01,2022-10-01,2022-11-01,2022-12-01,2023-01-01
210102,,-1.3130000000000024,-0.8359763697346184,0.8951380515419722,-0.32003889080192277,2.1397654995834356,-5.46713353493555,0.41670174257092435,1.4544997275432843,2.664848785324738,1.0181496237273133,0.4332324117
@henryjameslau
henryjameslau / avgprice.csv
Created March 8, 2023 15:16
average price
We can't make this file beautiful and searchable because it's too large.
ITEM_ID,2017-01-01,2017-02-01,2017-03-01,2017-04-01,2017-05-01,2017-06-01,2017-07-01,2017-08-01,2017-09-01,2017-10-01,2017-11-01,2017-12-01,2018-01-01,2018-02-01,2018-03-01,2018-04-01,2018-05-01,2018-06-01,2018-07-01,2018-08-01,2018-09-01,2018-10-01,2018-11-01,2018-12-01,2019-01-01,2019-02-01,2019-03-01,2019-04-01,2019-05-01,2019-06-01,2019-07-01,2019-08-01,2019-09-01,2019-10-01,2019-11-01,2019-12-01,2020-01-01,2020-02-01,2020-03-01,2020-04-01,2020-05-01,2020-06-01,2020-07-01,2020-08-01,2020-09-01,2020-10-01,2020-11-01,2020-12-01,2021-01-01,2021-02-01,2021-03-01,2021-04-01,2021-05-01,2021-06-01,2021-07-01,2021-08-01,2021-09-01,2021-10-01,2021-11-01,2021-12-01,2022-01-01,2022-02-01,2022-03-01,2022-04-01,2022-05-01,2022-06-01,2022-07-01,2022-08-01,2022-09-01,2022-10-01,2022-11-01,2022-12-01,2023-01-01
210102,1.1403923671614933,1.125419015380663,1.1160107783515805,1.1260006154879152,1.122396975607685,1.146413638860106,1.0837376743609104,1.0882536281348698,1.1040822741910714,1.133504397263838,1.1450451680195124,1
@henryjameslau
henryjameslau / metadata.csv
Created March 7, 2023 20:11
cpi items metadata
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 9 columns, instead of 6. in line 5.
ITEM_ID,ITEM_START,BASE_DATE,CATEGORY,SUB CATEGORY 1,SUB CATEGORY 2,ITEM_DESC,WEIGHT\SIZE,AVERAGE_PRICE
210102,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread ,Large white unsliced bread,750-800g,1.26
210106,198702,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread ,Bread rolls (white or brown),pack of 6,0.95
210111,200402,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread ,White sliced bread,750-800g,1.11
210113,200402,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread ,Wholemeal sliced bread,750-800g,1.02
210114,201002,201701 = 100,Food and non alcoholic beverages,Bread and cereals,Bread
@henryjameslau
henryjameslau / chained.csv
Created March 7, 2023 20:10
chained prices
We can't make this file beautiful and searchable because it's too large.
ITEM_ID,2017-01-01,2017-02-01,2017-03-01,2017-04-01,2017-05-01,2017-06-01,2017-07-01,2017-08-01,2017-09-01,2017-10-01,2017-11-01,2017-12-01,2018-01-01,2018-02-01,2018-03-01,2018-04-01,2018-05-01,2018-06-01,2018-07-01,2018-08-01,2018-09-01,2018-10-01,2018-11-01,2018-12-01,2019-01-01,2019-02-01,2019-03-01,2019-04-01,2019-05-01,2019-06-01,2019-07-01,2019-08-01,2019-09-01,2019-10-01,2019-11-01,2019-12-01,2020-01-01,2020-02-01,2020-03-01,2020-04-01,2020-05-01,2020-06-01,2020-07-01,2020-08-01,2020-09-01,2020-10-01,2020-11-01,2020-12-01,2021-01-01,2021-02-01,2021-03-01,2021-04-01,2021-05-01,2021-06-01,2021-07-01,2021-08-01,2021-09-01,2021-10-01,2021-11-01,2021-12-01,2022-01-01,2022-02-01,2022-03-01,2022-04-01,2022-05-01,2022-06-01,2022-07-01,2022-08-01,2022-09-01,2022-10-01,2022-11-01,2022-12-01,2023-01-01
210102,100,98.687,97.862,98.738,98.422,100.528,95.032,95.428,96.816,99.396,100.408,100.843,100.39,101.64587890000001,101.28246709999999,98.89318510000001,99.5708176,99.647114,101.19312,102.3626635,101.4461028,102.
@henryjameslau
henryjameslau / census2021-ts009-ltla.csv
Created December 15, 2022 11:59
date geography geography code Sex: Female; Age: Aged under 1 year; measures: Value Sex: Female; Age: Aged 1 year; measures: Value Sex: Female; Age: Aged 2 years; measures: Value Sex: Female; Age: Aged 3 years; measures: Value Sex: Female; Age: Aged 4 years; measures: Value Sex: Female; Age: Aged 5 years; measures: Value Sex: Female; Age: Aged 6 years; measures: Value Sex: Female; Age: Aged 7 years; measures: Value Sex: Female; Age: Aged 8 years; measures: Value Sex: Female; Age: Aged 9 years; measures: Value Sex: Female; Age: Aged 10 years; measures: Value Sex: Female; Age: Aged 11 years; measures: Value Sex: Female; Age: Aged 12 years; measures: Value Sex: Female; Age: Aged 13 years; measures: Value Sex: Female; Age: Aged 14 years; measures: Value Sex: Female; Age: Aged 15 years; measures: Value Sex: Female; Age: Aged 16 years; measures: Value Sex: Female; Age: Aged 17 years; measures: Value Sex: Female; Age: Aged 18 years; measures: Value Sex: Female; Age: Aged 19 years; measures: Value Sex: Female; Age: Ag
@henryjameslau
henryjameslau / .block
Last active May 14, 2022 18:29
UK map d3v4
license: mit