Government / Municipal petitions and ideas
Tbilisi municipal ideas and petition lifecycle
Official Tbilisi client of Georgia's municipal-ideas platform, exposing idea titles, categories, descriptions, budgets, execution periods, signatures, status lifecycle, and timestamps. The underlying public response also exposes excessive author PII and therefore requires a strict minimization boundary.
Provenance and access
How the data is reached
The official Angular portal uses an unauthenticated public JSON search for Tbilisi's client. A minimized validation returned 1,471 ideas and current 2026 records. The raw response also returned personal ID, email, phone, and birth date; the bulk route is intentionally not reproduced here.
Unclear; no explicit open-data reuse license was found, and public display does not justify reuse of exposed personal data
Official municipal ideas portal
https://idea.municipal.gov.ge/ ↗- Method
- GET
- Format
- HTML/Angular application
- Authentication
- None for public reading
The application invokes a public search service scoped to Tbilisi client 41. The copy-paste bulk endpoint is withheld because its response exposes excessive author PII.
Field-level detail
What is actually returned
Municipal idea
Fields observed in the Tbilisi search response. Sensitive author values are never reproduced.
| Field / path | Type | Null? | Example | Meaning | Freshness |
|---|---|---|---|---|---|
id | integer | No | 11004 | Idea identifier | reference |
title | string | No | ტრანსპორტი ნაძალადევი-საბურთალო | Idea title | live |
categoryId | integer | No | 4 | Category identifier | reference |
categoryKeyword | integer | No | 4 | Category keyword/internal identifier | reference |
categoryImageFileId | string | Yes | 596e1b39c50dfb1169fb1dfb | Category image file identifier | reference |
statusLogId | integer | Yes | 39528 | Current status-log identifier | reference |
statusId | integer | No | 4 | Current workflow status identifier | live |
signerQuantity | integer | No | 0 | Signature/supporter count | live |
imageFileId | string | Yes | null | Idea image file identifier | reference |
commentary | string | Yes | null | Idea commentary field | live |
description | long text | No | [idea description] | Submitted idea text | live |
executionPeriod | datetime string | Yes | null | Proposed execution period/dateObserved malformed/extreme date values in some records. | reference |
economicalGroundFileId | string | Yes | null | Economic-grounding attachment ID | reference |
budget | number | Yes | 100000 | Submitted budget value | reference |
legalGround | string | Yes | null | Legal basis text | reference |
clientId | integer | No | 41 | Municipal client ID; 41 is Tbilisi | reference |
recordState | string | No | ACTIVE | Record-state flag | live |
createdAt | datetime with offset | No | 2026-05-22T07:22:11.110+0000 | Creation timestamp | historical |
updatedAt | datetime with offset | No | 2026-06-01T06:30:28.714+0000 | Last record update | live |
deadlineDate | datetime string | Yes | null | System deadline | live |
userDeadlineDate | datetime string | Yes | null | User-facing deadline | live |
categoryTitle | string | No | სატრანსპორტო ინფრასტრუქტურა | Category label | reference |
statusCreatedAt | datetime with offset | No | 2026-06-01T06:30:27.305+0000 | Current status timestamp | live |
optionalFileId | string | Yes | null | Optional attachment ID | reference |
authorFullName | string | Yes | [redacted] | Author full name exposed by the responseSensitive; exclude from downstream datasets unless strictly necessary. | reference |
authorPid | string | Yes | [redacted] | Author personal identification number exposed by the responseHighly sensitive; never retain or republish. | reference |
authorEmail | string | Yes | [redacted] | Author email exposed by the responseSensitive; never retain or republish. | reference |
authorPhone | string | Yes | [redacted] | Author phone exposed by the responseSensitive; never retain or republish. | reference |
authorBirthDate | datetime string | Yes | [redacted] | Author birth date exposed by the responseSensitive; never retain or republish. | reference |
Search page wrapper
Observed page response metadata.
| Field / path | Type | Null? | Example | Meaning | Freshness |
|---|---|---|---|---|---|
result.dataType | string | No | PAGE | Response type | reference |
result.data | array<object> | No | [ideas] | Idea records | live |
result.page.total | integer | No | 1471 | Total matching ideas | live |
result.page.number | integer | No | 0 | Zero-based page number | reference |
result.page.size | integer | No | 10 | Requested page size | reference |
result.sort | object | null | Yes | null | Applied sort metadata | reference |
Representative evidence
Sample records
Redacted Tbilisi idea 11004
Retrieved 2026-07-22T14:03:03+04:00
{"id":11004,"title":"ტრანსპორტი ნაძალადევი-საბურთალო","categoryId":4,"categoryTitle":"სატრანსპორტო ინფრასტრუქტურა " ,"statusId":4,"signerQuantity":0,"clientId":41,"recordState":"ACTIVE","createdAt":"2026-05-22T07:22:11.110+0000","updatedAt":"2026-06-01T06:30:28.714+0000"}All author PII and free-text description omitted.
Boundaries
Reliability, caveats, and privacy
What held up
- The official portal and its Tbilisi-scoped search returned HTTP 200
- The response reported 1,471 records and current 2026 timestamps
- Stable IDs, timestamps, and status-log IDs support lifecycle tracking
What can go wrong
- The public response exposes personal data far beyond what is needed to understand an idea
- No active records matched statusIds [3,-3] at validation time despite 1,471 total historical/current-state records
- Status IDs need the portal's client mapping and include negative overdue variants
- Submitted budget and execution-period values are user-entered and can be malformed
- No open reuse license was found
Privacy boundary
- Critical: never collect, store, display, or redistribute authorPid, authorEmail, authorPhone, or authorBirthDate from this feed
- Minimize author names and free text because descriptions can contain phone numbers, addresses, health details, or other volunteered PII
- A privacy-preserving ingestion layer should explicitly allowlist civic fields and discard the rest before logging or caching
- The raw bulk endpoint is intentionally omitted from this inventory
Cross-source possibilities
Ideas using this source
Promise to Pavement
What public evidence appeared after a civic proposal?
Joined with 3 other sources →Civic accountabilitySchool Promise Receipt
What can be traced from a school’s stated need to public action?
Joined with 3 other sources →Civic accountabilityCivic Closing Bell
Which public opportunities disappear in the next 48 hours?
Joined with 3 other sources →Civic accountabilityQuestions Before Disposal
What should residents ask before a public asset is sold?
Joined with 3 other sources →Source trail
Primary pages and documentation
https://idea.municipal.gov.ge/