Search

After we opening the API to access open data we got a lot of feedback that the REST API is inconvenient if one want to analyse the entire dataset. Addressing that here.

Now in addition to the API we present a daily snapshot of the dataset available on:

https://wartears.org/static/wartears-opendata.xlsx

The snapshot contains all the data available through the API, but now in .xlsx file (Microsoft Excel). The snapshot is being updated daily. The file is created using the opensource openpyxl library.

The file contains 4 tabs (due to limited translation capabilities we're using names and keywords in Russian):

• Записи ("Records")- records about individuals and organisations. Each record contains the date of the last update, one or more names, and a short note with all public info we found. Records may be marked with tags (for the full list of tags refer to Теги sheet). Atop of that each line could contain URLs of images attached to records.
• Теги ("Tags") - the list of tags which can be used to mark records. Feel free to use any translation service. The most important though are "Погиб" (Dead) and "В плену" (Captured). Some other may refer to more specific cases, like "Еленовка" ("Olenivka", the known location where a lot of members of Azov and 36 marine brigade are held captured).
• Отношения ("Relationships") - relationships between individuals and organisations. For instance it could be who serves where, which organisation is a part of which, etc. There are a few kinds of relationships described on the next tab, Разновидности отношений ("Relationship kinds", see below). Overall relationships describe an oriented graph of social and command structure of AFU and organisations supporting AFU.
• Разновидности отношений ("Relationship kinds") - a list of relationship kinds.

Please be noted, wartears-openapi.xlsx contains more than a hundred thousand records. Hence we highly recommend to use scripts to work with it, however some table processor like Google Sheets or Microsoft Excel might work fine.