ftmq
This library provides methods to query and filter entities formatted as Follow The Money data, either from a json file/stream or using a statement-based store backend from nomenklatura.
It also provides a Query class that can be used in other libraries to work with SQL store queries or api queries.
ftmq is the base layer for investigativedata.io's libraries and applications dealing with Follow The Money data.
To get familiar with the Follow The Money ecosystem, you can have a look at this pad here.
Installation
Minimum Python version: 3.11
pip install ftmq
Usage
Command line
cat entities.ftm.json | ftmq -s Company --country=de --incorporationDate__gte=2023 -o s3://data/entities-filtered.ftm.json
Python Library
from ftmq import Query, smart_read_proxies
q = Query() \
.where(dataset="ec_meetings", date__lte=2020) \
.where(schema="Event") \
.order_by("date", ascending=False)
for proxy in smart_read_proxies("s3://data/entities.ftm.json"):
if q.apply(proxy):
yield proxy
Documentation
https://docs.investigraph.dev/lib/ftmq
Support
This project is part of investigraph
In 2023, development of ftmq was supported by Media Tech Lab Bayern batch #3
License and Copyright
ftmq, (C) 2023 Simon Wörpel
ftmq, (C) 2024-2025 investigativedata.io
ftmq, (C) 2025 Data and Research Center – DARC
ftmq is licensed under the AGPLv3 or later license.
Prior to version 0.8.0, ftmq was released under the MIT license.
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file ftmq-4.10.0.tar.gz.
File metadata
- Download URL: ftmq-4.10.0.tar.gz
- Upload date:
- Size: 51.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
poetry/2.4.1 CPython/3.14.6 Linux/7.0.10+deb14-amd64
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
346e66035608a1b341b32402ef442f3e75641c2a14afc750cfeecb33d2ec141c
|
|
| MD5 |
7155f4f03d86ad8c815535e25f7cc4e7
|
|
| BLAKE2b-256 |
2671ac12b81c10ed442864f972af70c8155bba16bec8407219100f54511bfe25
|
File details
Details for the file ftmq-4.10.0-py3-none-any.whl.
File metadata
- Download URL: ftmq-4.10.0-py3-none-any.whl
- Upload date:
- Size: 62.8 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
poetry/2.4.1 CPython/3.14.6 Linux/7.0.10+deb14-amd64
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
abbd1ff0f816bf0fc65815161e7d87b58fa03711d4adfe30c6ebaf3c5279dea4
|
|
| MD5 |
ea04a4967332e190c02d40e691025371
|
|
| BLAKE2b-256 |
40435f2757c2456ac8118a9c1855c1ac51dbabbd4ee259dea939df8e9b0aa46d
|
