The US presidential election is taking place at the moment, and with more and more data coming in, the next president of the US is almost known. The Associated Press is working hard to make all voter data as available as possible, and is publishing the U.S. election race calls on both Ethereum and EOS. However, the AP has not provided any tools for extracting the data, which is why we have created the following tool!
Data extraction tool
This tool collects the election data from EOS and stores it in a publicly accessible MariaDB/MySQL server.
Each transaction contains a text string in JSON format with electoral college votes. The database records the transaction ID, block number, and block timestamp for every call, in order to provide an easy to verify dataset.
Any MySQL-compatible database client can access and retrieve the data for further processing. Here is an example using the command-line client:
mysql --batch --skip-column-names \
--user=associapressro --password=associapressro --database=associapress \
--execute="SELECT block_num, block_time, trx_id, data FROM ELECTION ORDER BY seq DESC LIMIT 1"
For more information, visit the Github page of the tool.
Please note that EOS Amsterdam is providing this data for the mere purpose of information accessibility and transparency. EOS Amsterdam does not hold any responsibility for the correctness of data published by the Associated Press.
Founding block producer for the EOS mainnet. Telos, Proton, BOS, FIO, and Instar Block Producer. Active top WAX Guild. Partner in the Europechain sister chain. Investor in blockchain projects. Governance, intercultural cooperation, and security specialist. You can find us here:
EOS, Europechain, Proton, and Instar Block Producer name: eosamsterdam
BOS Block Producer name: amsterdambos
Telos Block Producer name: amsterdam
FIO Block Producer name: bp@eosamsterdam
WAX Guild name: amsterdamwax