subtotals but no (grand) totals returned

[dpprdan]

The tabular API returns subtotals but no (grand) totals when dimensions without specific values are specified (i.e. ?data=<id>:<attr>(<dim>)).

I think it would be preferable to always return grand totals (only per year, of course). If one does not want grand totals, one can specify the desired values, after all.

To illustrate, I am retrieving population data with a simple R function for better readability.

r <- purrr::partial(read.csv, colClasses = "character")
r("https://tabular.genesapi.org/?data=12411:BEVSTD(NAT,GES)&time=2017&region=01001")
#>   region_id year measure value X12411.BEVSTD.GES. X12411.BEVSTD.NAT. statistic
#> 1     01001 2017  BEVSTD  6674               GESM               NATA     12411
#> 2     01001 2017  BEVSTD 37412               GESM               NATD     12411
#> 3     01001 2017  BEVSTD 44086               GESM                        12411
#> 4     01001 2017  BEVSTD  5071               GESW               NATA     12411
#> 5     01001 2017  BEVSTD 39362               GESW               NATD     12411
#> 6     01001 2017  BEVSTD 44433               GESW                        12411
#> 7     01001 2017  BEVSTD 11745                                  NATA     12411
#> 8     01001 2017  BEVSTD 76774                                  NATD     12411

Here we get subtotals for nationality and gender, respectively, but no grand totals. Note that the subtotals are not tagged (e.g. “GESAMT”) which they probably should be. If we retrieve the data for gender or nationality independently from each other, we do not get totals either.

r("https://tabular.genesapi.org/?data=12411:BEVSTD(GES)&time=2017&region=01001")
#>   region_id year measure value X12411.BEVSTD.GES. statistic
#> 1     01001 2017  BEVSTD 44086               GESM     12411
#> 2     01001 2017  BEVSTD 44433               GESW     12411
r("https://tabular.genesapi.org/?data=12411:BEVSTD(NAT)&time=2017&region=01001")
#>   region_id year measure value X12411.BEVSTD.NAT. statistic
#> 1     01001 2017  BEVSTD 11745               NATA     12411
#> 2     01001 2017  BEVSTD 76774               NATD     12411