Bord4 data

Collection of datasets and map files used by data journalists at Bergens Tidende.

Data files are stored in the data folder. Scripts for generating the datasets are found in the script folder.

Data files

Datasets

Name	Download	Preview	Script
Norwegian regions	csv pickle	norwegian_regions.csv	script
Norwegian regions - changes 2019/2020	csv pickle	norwegian_regions_changes.csv	script
Population 2020 for Norwegian regions	csv pickle	norwegian_regions.csv	script
Population for Norwegian regions	csv pickle	norwegian_regions.csv	script
Brann matches since 1995	csv	brann_matches.csv

Map files

Name	Download	Preview

Example

To get a dataframe of all Norwegian regions do the following

df = pd.read_pickle("https://raw.githubusercontent.com/BergensTidende/bord4-data/master/data/pkl/norwegian_population.pkl")

or

df = pd.read_csv("https://raw.githubusercontent.com/BergensTidende/bord4-data/master/data/csv/norwegian_population.csv")

Sources

Population

• Source: [https://www.ssb.no/statbank/table/10826/] [https://www.ssb.no/statbank/table/07459/]
• Last updated: 2020-07-29
• Note: For cities there's only population for 2020 for the moment.

Regions

• Source: [https://www.ssb.no/statbank/table/10826/] [https://www.ssb.no/statbank/table/07459/]
• Last updated: 2020-07-29
• Note: Generated from the population files

Regional changes

• Source: [https://www.kartverket.no/kommunereform/tekniske-endringer/kommune--og-regionsendringer-2020/]
• Last updated: 2020-07-29

Updating the data

To update the data you must first run

pipenv install

To run just one of the script run

pipenv run python script/<name>.py

To generate all the data files run

make data

The team

Bord4 are the data journalists and editorial developers at Bergens Tidende. Bord is Norwegian for table, so it translates to table 4. Many aeons ago bord4 sat around the fourth table in a corridor.

• Tove B. Knutsen
• Lasse Lambrechts
• Anders Grimsrud Eriksen
• Philipp Bock
• Halvard Alvheim Vegum

Contact

If you want to contact us you can reach us at [email protected].

License

This project uses the following license: MIT.