multiple results per year and area on some statistics

[dpprdan]

Not sure whether this is just a side-effect of being in the process of changing things (just close this if it is), but some queries currently return multiple results per year and area. Sometimes they are different from each other, so these are not always exact duplicates.

r <- purrr::partial(read.csv, colClasses = "character")
r("https://tabular.genesapi.org/?data=82411:EKM014&time=2011:&region=01001&labels=id")
#>    region_id year measure value statistic
#> 1      01001 2011  EKM014 18079     82411
#> 2      01001 2011  EKM014 18079     82411
#> 3      01001 2012  EKM014 18545     82411
#> 4      01001 2012  EKM014 18545     82411
#> 5      01001 2013  EKM014 18543     82411
#> 6      01001 2013  EKM014 18543     82411
#> 7      01001 2014  EKM014 18578     82411
#> 8      01001 2014  EKM014 18639     82411
#> 9      01001 2015  EKM014 18308     82411
#> 10     01001 2015  EKM014 18660     82411
#> 11     01001 2016  EKM014 18481     82411
#> 12     01001 2016  EKM014 18842     82411
#> 13     01001 2017  EKM014 19296     82411
r("https://tabular.genesapi.org/?data=82411:EKM006&time=2011:&region=01001&labels=id")
#>    region_id year measure   value statistic
#> 1      01001 2011  EKM006 1491587     82411
#> 2      01001 2011  EKM006 1491587     82411
#> 3      01001 2012  EKM006 1541701     82411
#> 4      01001 2012  EKM006 1541701     82411
#> 5      01001 2013  EKM006 1552324     82411
#> 6      01001 2013  EKM006 1552324     82411
#> 7      01001 2014  EKM006 1566743     82411
#> 8      01001 2014  EKM006 1571862     82411
#> 9      01001 2015  EKM006 1561972     82411
#> 10     01001 2015  EKM006 1592027     82411
#> 11     01001 2016  EKM006 1602046     82411
#> 12     01001 2016  EKM006 1633352     82411
#> 13     01001 2017  EKM006 1697570     82411

[dpprdan]

On https://www.regionalstatistik.de/genesis/online?Menu=Neu it says

14.11.2019 | 82411 | VGR: Verfügbares Einkommen - Berechnungsstand 08/2018 |   | 2014-2017

So the different values might have something to do with that?

[dpprdan]

I also get duplicates on api.datengui.de

[dpprdan]

This does not seem to be related to a specific statistic

r <- purrr::partial(read.csv, colClasses = "character")
r("https://tabular.genesapi.org/?data=61511:BAU004&region=01001&labels=id")
#>    region_id year measure  value statistic
#> 1      01001 1995  BAU004  45.55     61511
#> 2      01001 1995  BAU004  45.55     61511
#> 3      01001 1996  BAU004   74.5     61511
#> 4      01001 1996  BAU004   74.5     61511
[snip]
#> 41     01001 2015  BAU004  98.26     61511
#> 42     01001 2015  BAU004  98.26     61511
#> 43     01001 2016  BAU004  75.47     61511
#> 44     01001 2016  BAU004  75.47     61511
#> 45     01001 2017  BAU004 125.64     61511
#> 46     01001 2017  BAU004 125.64     61511
#> 47     01001 2018  BAU004    0.0     61511

Also on api.datengui.de