3 ms·
That's a fun JSON file. It's served with open CORS headers which means I can query it in Datasette Lite like this: https://lite.datasette.io/?json=https://www.
by simonw 3y ago
That's a fun JSON file. It's served with open CORS headers which means I can query it in Datasette Lite like this:
https://lite.datasette.io/?json=https://www.gstatic.com/ct/log_list/v3/all_logs_list.json#/data?sql=with+unbundled+as+%28%0A++select+name+as+owner%2C+email+as+owner_emails%2C+value+from+all_logs_list%2C+json_each%28logs%29%0A%29%0Aselect%0A++json_extract%28value%2C+%27%24.description%27%29+as+description%2C%0A++owner%2C%0A++json_extract%28value%2C+%27%24.url%27%29+as+url%2C%0A++json_extract%28value%2C+%27%24.state%27%29+as+state%2C%0A++json_extract%28value%2C+%27%24.temporal_interval%27%29+as+temporal_interval%2C%0A++json_extract%28value%2C+%27%24.mmd%27%29+as+mmd%2C%0A++json_extract%28value%2C+%27%24.log_id%27%29+as+log_id%2C%0A++json_extract%28value%2C+%27%24.key%27%29+as+key%2C%0A++owner_emails%0Afrom+unbundled https://lite.datasette.io/?json=https://www.gstatic.com/ct/l...