https://github.com/clariah/hdng

scripts to convert the HDNG_v2 to HDNG_v4

https://github.com/clariah/hdng

Science Score: 13.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • CITATION.cff file
  • codemeta.json file
    Found codemeta.json file
  • .zenodo.json file
  • DOI references
  • Academic publication links
  • Committers with academic emails
  • Institutional organization owner
  • JOSS paper metadata
  • Scientific vocabulary similarity
    Low similarity (8.1%) to scientific vocabulary
Last synced: 10 months ago · JSON representation

Repository

scripts to convert the HDNG_v2 to HDNG_v4

Basic Info
  • Host: GitHub
  • Owner: CLARIAH
  • Language: R
  • Default Branch: main
  • Size: 50.8 KB
Statistics
  • Stars: 0
  • Watchers: 2
  • Forks: 0
  • Open Issues: 0
  • Releases: 0
Created over 5 years ago · Last pushed over 2 years ago
Metadata Files
Readme

README.md

HDNG

The HDNG is the Historische Database Nederlandse Gemeentes (Historical Database Dutch Municipalities) and contains a wide range of historical indicators for Dutch municipalities for the 19th and 20th centuries. The HDNG dates from the floppy disk era and has been made available online by Onno Boonstra. Hitherto, there have been 4 versions of the database:

Version history

Version 1 (HED, 1970-medio 1990): - Data gathered under supervision of Hans Knippenberg. - Contains demographic indicators stored in wide format. - Using municipality name and CBS-code as unique identifyers. - Information was stored on 7 floppy disks in .POR (SPSS portable) files. - Variable names were coded as 8 digits, which were interpretable via a look-up table.

Version 2 (HDNG, 2003): - Was published online by Onno Boonstra as 11 separate csv files. - Added the Amsterdam-codes for all Dutch municipalities. - Dropped 14 variables.

Version 3 (HDNG, 2020): - Published the HDNG in one csv file. - Transformed the HDNG from a wide format into long format, so that look-up tables are no longer necessary. - Added variables from the Historisch-Ecologische Database (HED) on religion. - Added provincial and national aggregates from the Historisch-Ecologische Database (HED). - Returned the 14 dropped variables.

Version 4/5 (HDNG, 2021): - Dropped redundant columns from previous versions. - Adds descriptive fields to the HDNG to make the database more easily queryable. - Adds visualisation descriptions to the HDNG, to enable hookups with NLGIS or other shapefiles. - Redundant rows have been removed from the database.

Script overview

1. transform HDNG from separate files into long format.R transforms the HDNG v2 into long format.

2. transform HDNG_long to HDNG+HED.R adds information from the HED to the HDNG.

3. provincietotalen.R puts the provincial and national aggregates from the HED into long format.

4. add missings and provincietotalen to HDNG+.R adds provincial and national aggregates from the HED, as well as the 15 variables dropped in HDNG v2.

5. filter existing municipalities.R removes entries for non-existing municipalities.

Variable description

| Variable | Description | | -------- | ----------- | | amco | provides the Amsterdamse code, a 5-digit number to refer to municipalities | | name | the name of the municipality as provided in the HDNG v2 | | variable | the original 8-digit variable name from the HED. The variable is now redundant, but originally was used to note a variable's topic (A-H), year (809-997), variable (3 letters), and sex (1,2,3,X). | | description | queryable summary of the available variables in the HDNG. | | information | actual variables in the HDNG. | | sex | male (M), female (F), both sexes (-T), or not applicable ( ). | | year | the year for which data is available. | | visualisation_year | the year for which municipal borders have been used. | | value | score on description. | | sources | reference to source in ... | | remark | reference to remarks in ... |

Owner

  • Name: CLARIAH
  • Login: CLARIAH
  • Kind: organization

CLARIAH offers humanities scholars a Common Lab providing access to large collections of digital resources and innovative tools for research

GitHub Events

Total
Last Year

Committers

Last synced: over 1 year ago

All Time
  • Total Commits: 49
  • Total Committers: 2
  • Avg Commits per committer: 24.5
  • Development Distribution Score (DDS): 0.02
Past Year
  • Commits: 1
  • Committers: 1
  • Avg Commits per committer: 1.0
  • Development Distribution Score (DDS): 0.0
Top Committers
Name Email Commits
RJMourits 5****s 48
Richard Zijdeman r****n@i****l 1
Committer Domains (Top 20 + Academic)
iisg.nl: 1

Issues and Pull Requests

Last synced: over 1 year ago

All Time
  • Total issues: 0
  • Total pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Total issue authors: 0
  • Total pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 0
  • Pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 0
  • Pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Top Authors
Issue Authors
Pull Request Authors
Top Labels
Issue Labels
Pull Request Labels