Skip to content

Instantly share code, notes, and snippets.

View henryjameslau's full-sized avatar

Henry Lau henryjameslau

16 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 / points.csv
Created January 22, 2021 13:45
Occupation title Proximity to others Exposure to disease Total in employment
Chief executives and senior officials 48.7 11.7 101000
Production managers and directors in manufacturing 48.0 7.5 313000
Production managers and directors in construction 50.0 4.0 210000
Production managers and directors in mining and energy 49.3 9.0 19000
Financial managers and directors 44.0 5.5 352000
Marketing and sales directors 47.5 2.5 270000
Purchasing managers and directors 47.3 5.3 64000
Advertising and public relations directors 42.0 7.0 45000
Human resource managers and directors 39.7 4.3 217000