comunas | DemocracyOS Comunas

I want to extract election results from this website (currently all data is at zero because voting is ongoing). In the menu you can select the data you want (I need "En Chile" -> "División Geográfica" -> "Comunas"). This is the voting results for each municipality ("comuna"). When you select the desired "comuna", then you can click the excel file and results are downloaded.

The "problem" is that no url is shown along the process. I cannot see the url link to the particular "comuna" I need. I was hoping to get a specific link so then I can automate using wget with the name of each municipality. Instead, the data seems to be masked. I know you can extract JSON data, perhaps using the properties shown in the website's HTML code:

I'm trying to create a map visualization in plotly using mapbox (plotly::plot_mapbox()), where the points in the map belong to different geographical districts ("comunas") and the user can choose a geographical district in a drop-down widget created by crosstalk::filter_select().

The expected behavior is that, when a geographical district is selected in the widget, it should trigger a filter in the map, which should only show the points that belong to the selected district.

However, I'm unable to make it work (I'm following the instructions presented here). The code that I wrote successfully creates 1) the map and 2) the filtering widget, but the components don't interact/talk to each other, i.e. when I select a district in the drop-down, there is no filtering effect in the map, it keeps showing all the points, not only those who belong to the selected district.

Am I doing something wrong? How can I make this work as intended?

Below is a reproducible example with a subset of the original data (it requires a Mapbox token to run):

any of you knows how to make this selection faster or more efficient? The thing is that this selection takes more than hours to procesate on SQLite. I am using it with sqlite3 on Python so there is a few limitations of commands.

I am trying to convert a json to a tibble that follow Tidy Data principles.

The website http://pv.servelelecciones.cl/ has some nice regional data. Because I cannot provide a direct link to "Aysen region" as the url doesn't change, this is the data they are displaying:

I have 2 tables like this:

i need to setView of leaflet map to new polygon add in the map:

I'm using dplyr and gsub to remove special characters. I'm trying to translate a code I had with base R.

Here's a fake example to resemble my data:

i'm currently testing an app that simply searches a record by the given id. It works fine but the testing refuses to return the response in the code. Strangely it is ONLY shown in the CLI.

I'm using phpunit provided by cakephp:

"phpunit/phpunit": "^5.7|^6.0"

Here is the conflicting code: