Live analytics
Status Analytics
Per-status viewer counts and pre-aggregated reaction payloads.
Table metadata
Rows: 6Page: 1 / 1Page size: 100Mode: read-write
Columns
| name | type | primary_key | not_null | default_value |
|---|---|---|---|---|
| status_id | TEXT | 1 | 0 | — |
| user_id | TEXT | 0 | 1 | — |
| mood | TEXT | 0 | 1 | — |
| had_image | INTEGER | 0 | 1 | — |
| posted_at | INTEGER | 0 | 1 | — |
| reaction_counts | TEXT | 0 | 1 | — |
| viewer_count | INTEGER | 0 | 1 | 0 |
Rows
Manage rows
Create, edit, and delete live rows directly from the SQLite database.
| __rowid__ | status_id | user_id | mood | had_image | posted_at | reaction_counts | viewer_count | Actions |
|---|---|---|---|---|---|---|---|---|
| 6 | sts_2c06c4f8-2e6 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | focused | 1 | 1776451275023 | {"❤️":0,"🔥":0,"🫂":0,"💭":0,"👀":0} | 0 | |
| 4 | sts_d9a995df-2b7 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | energized | 0 | 1776451234281 | {"❤️":0,"🔥":0,"🫂":0,"💭":0,"👀":0} | 0 | |
| 5 | sts_47e0694a-ba5 | 965ca4fb-4144-4b05-b438-36e38d3ca019 | curious | 0 | 1776449983449 | {"❤️":0,"🔥":0,"🫂":0,"💭":0,"👀":0} | 0 | |
| 3 | sts_8bd113f7-3ae | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | energized | 1 | 1776419249351 | {"❤️":0,"🔥":0,"🫂":0,"💭":0,"👀":0} | 0 | |
| 2 | sts_d60ce6bf-580 | 965ca4fb-4144-4b05-b438-36e38d3ca019 | reflective | 1 | 1776357557012 | {"❤️":0,"🔥":0,"🫂":0,"💭":0,"👀":0} | 0 | |
| 1 | sts_8b5c84ac-430 | 965ca4fb-4144-4b05-b438-36e38d3ca019 | curious | 0 | 1776357515628 | {"❤️":0,"🔥":0,"🫂":0,"💭":0,"👀":0} | 0 |