home / unwash_db

advertiser

3 rows where details = "{"name": "ExxonMobil"}", updated_at = "2024-10-20 21:47:31.421696" and "updated_at" is on date 2024-10-20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at, created_at (date), updated_at (date)

Link rowid ▼ id source_advertiser_id platform_id details advertiser_federation_id created_at updated_at
40 40 019082e4-d857-76f8-933f-427dc9e613c0 925007000949719 01908067-e73b-7475-a740-16092c11f9cd
{
    "name": "ExxonMobil"
}
  2024-07-05 12:35:54.067621 2024-10-20 21:47:31.421696
41 41 019082e4-d857-7fbf-9378-64c4580b8653 925007000949719 019081d1-6bad-787f-a36d-7c9b7fb0f508
{
    "name": "ExxonMobil"
}
  2024-07-05 12:35:54.067621 2024-10-20 21:47:31.421696
42 42 0190d746-cfa2-721c-b4f1-6e7e5737dd31 925007000949719 019081d1-6bad-7d3d-a977-e91f33c8c4cf
{
    "name": "ExxonMobil"
}
  2024-07-21 21:51:00.511866 2024-10-20 21:47:31.421696

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE advertiser(id VARCHAR, source_advertiser_id VARCHAR, platform_id VARCHAR, details VARCHAR, advertiser_federation_id VARCHAR, created_at VARCHAR, updated_at VARCHAR);
Powered by Datasette · Queries took 14.024ms