interesting queries for ooni-api

ooni-api-queries.sql

# Interesting DNS Consistency tests 
SELECT input, report_id FROM reports WHERE test_name='dns_consistency' AND (test_keys->>'tampering_detected')::bool=true;


# Interesting HTTP requests tests
SELECT input, report_id FROM reports WHERE test_name='http_requests' AND (test_keys->>'body_length_match')::bool=false;

# Interesting tests that indicate a generic failure
SELECT input, report_id FROM reports WHERE test_keys->>'failure' != 'null';

Is 'failure' a boolean or does it represent a contextualized error message in the context of this query?

SELECT input, report_id FROM reports WHERE test_keys->>'failure' != 'null';

failure is one of the strings amongst the following: https://github.com/TheTorProject/ooni-spec/blob/master/data-formats/df-000-base.md#error-strings