messages

2,189 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: messengerId, messengerName, messageType, dateTime (date)

Next page

CREATE TABLE messages (
    id INTEGER NOT NULL,
    "messengerId" TEXT NOT NULL,
    latitude FLOAT NOT NULL,
    longitude FLOAT NOT NULL,
    "dateTime" TEXT NOT NULL,
    "unixTime" INTEGER NOT NULL,
    altitude TEXT,
    "messengerName" TEXT NOT NULL,
    "messageType" TEXT NOT NULL,
    "showCustomMsg" TEXT NOT NULL,
    hidden TEXT NOT NULL,
    "messageContent" TEXT,
    PRIMARY KEY (id)
);