Hearing List
API endpoint for hearings.
GET /v1/hearing/?format=api&offset=50&ordering=created_at
{ "count": 73, "next": null, "previous": "https://testikerrokantasi-api.turku.fi/v1/hearing/?format=api&limit=50&ordering=created_at", "results": [ { "abstract": { "en": "This is the intro.", "fi": "Tämä on johdanto." }, "id": "fcIOSxxtOucTNSZVtoLOaZ9QZdQHd0KH", "n_comments": 5, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-02-01T22:00:00Z", "close_at": "2022-02-27T22:00:00Z", "created_at": "2022-02-02T07:14:10.842038Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "helmikuun-huhuilut-1", "main_image": { "id": 55, "url": "https://testikerrokantasi-api.turku.fi/media/images/2022/02/AXtNGkgH.jpeg", "width": 1200, "height": 568, "title": {}, "caption": { "en": "Fantastic Aurajoki", "fi": "Hieno Aurajoki" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "February feelers", "fi": "Helmikuun huhuilua" }, "borough": {} }, { "abstract": { "fi": "Kokeillaan toimiiko kysymysten merkkirajoitus" }, "id": "zzhrqxw9UKIgkzrcaeaLDbV6xCIfm4sq", "n_comments": 2, "published": true, "labels": [ { "id": 3, "label": { "fi": "Kokeilu" } } ], "open_at": "2022-02-01T22:00:00Z", "close_at": "2022-02-27T22:00:00Z", "created_at": "2022-02-02T10:17:01.326666Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "helmikuunkysymykset", "main_image": { "id": 57, "url": "https://testikerrokantasi-api.turku.fi/media/images/2022/02/i1LAgcCW.jpeg", "width": 478, "height": 313, "title": {}, "caption": { "fi": "Asiakkaan kanssa keskustelua. " }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Helmikuun kyselyä" }, "borough": {} }, { "abstract": { "en": "This is the intro.", "fi": "<p>Tämä on johdanto. Tämä on <a href=\"https://google.fi\" target=\"_blank\" class=\"\" id=\"\">linkki </a>googleen. Varaamon <a href=\"https://testivaraamo.turku.fi\" target=\"_blank\">linkki</a>.</p>" }, "id": "d3QZD8YQ35EmxT3BEvWT13fWfvciqz6B", "n_comments": 1, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-02-21T22:00:00Z", "close_at": "2022-04-29T21:00:00Z", "created_at": "2022-02-22T12:09:37.334071Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "excel-alaosiot1", "main_image": { "id": 58, "url": "https://testikerrokantasi-api.turku.fi/media/images/2022/02/vLcbPMLd.png", "width": 256, "height": 256, "title": {}, "caption": { "en": "turku", "fi": "turku" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "Excel and subsections", "fi": "Excel ja alaosiot" }, "borough": {} }, { "abstract": { "fi": "<p>Toukokuun 2022 kuuleminen on ilmestynyt!</p>" }, "id": "JgiXhcL21JRqb1VRLvvm5pqjnjbKgpYu", "n_comments": 5, "published": true, "labels": [ { "id": 5, "label": { "fi": "testikokeilu" } } ], "open_at": "2022-04-30T21:00:00Z", "close_at": "2022-05-30T21:00:00Z", "created_at": "2022-05-04T07:09:48.349012Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "toukokuutest22", "main_image": { "id": 60, "url": "https://testikerrokantasi-api.turku.fi/media/images/2022/05/VjdNjYk7.webp", "width": 382, "height": 300, "title": {}, "caption": { "fi": "kuva jossa lukee kuva" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Toukokuun testausta!" }, "borough": {} }, { "abstract": { "fi": "<p>Tämä on johdanto. 123456. Johdannon <a href=\"https://google.fi\" target=\"_blank\">linkki</a>.</p>" }, "id": "NmAQgTA6mbmYtn3EQ8gTggud2kTSR57f", "n_comments": 15, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } }, { "id": 5, "label": { "fi": "testikokeilu" } }, { "id": 9, "label": { "fi": "katutaide" } } ], "open_at": "2022-06-27T21:00:00Z", "close_at": "2022-09-29T21:00:00Z", "created_at": "2022-06-20T07:41:25.259464Z", "servicemap_url": "", "preview_url": null, "project": { "id": "E6mw7KkHa40POsk0ewhn4vfaulU35TNw", "phases": [ { "id": "dyXDkyx0Cw3yxnH7qOFmeogN0fHbQuU1", "has_hearings": true, "hearings": [ "vaihetesti", "kupittaa3d", "kasvit-jokirannassa1" ], "title": { "fi": "testaus" }, "description": {}, "schedule": { "fi": "5 pv" }, "is_active": true }, { "id": "66w1JZXEKIoh7tqRblYAFUUlJJuMDhP1", "has_hearings": true, "hearings": [], "title": { "fi": "toista testaus" }, "description": {}, "schedule": { "fi": "50 pv" }, "is_active": false } ], "title": { "fi": "testiprojektiappp" } }, "closed": true, "organization": "Turun kaupunki", "slug": "kasvit-jokirannassa1", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Minkälaisia kasveja haluaisit jokirantaan?" }, "borough": {} }, { "abstract": { "fi": "<p>test</p>" }, "id": "lVf7Bf0aa8d2xizr5dxPUhly0yIckT29", "n_comments": 1, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-09-22T21:00:00Z", "close_at": "2022-09-23T11:37:59.177000Z", "created_at": "2022-09-23T11:36:01.448667Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "test-for-deletion1", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Tämä on testi poistettavaksi" }, "borough": {} }, { "abstract": { "en": "<p>test</p>", "fi": "<p>test</p>" }, "id": "f0owWF8ifYeD5tSXQ3jk8rmfAb8pPv0H", "n_comments": 6, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-10-04T21:00:00Z", "close_at": "2022-10-30T22:00:00Z", "created_at": "2022-10-05T05:13:58.532269Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "maps-in-comments", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "Maps in comments", "fi": "Kartat kommenteissa" }, "borough": {} }, { "abstract": { "en": "<p>test link to google: <a href=\"https://google.fi\" target=\"_blank\">google</a>. More test text...</p>", "fi": "<p>test linkki googleen: <a href=\"https://google.fi\" target=\"_blank\">google</a>. Lisää testiä...</p>" }, "id": "mFE6GW6JMlJzIdFpoWXS6SlpCmL4pU4M", "n_comments": 11, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-10-06T21:00:00Z", "close_at": "2022-10-30T22:00:00Z", "created_at": "2022-10-07T06:30:53.115013Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "long-heading-word-1", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "Tell us your opinion of this very long word 12345678901234567890 test 1", "fi": "Kerro mielipiteesi tästä todella pitkästä sanasta 12345678901234567890 testi 1" }, "borough": {} }, { "abstract": { "fi": "<p>test</p>" }, "id": "NPgDxHJxwweCPJEMOGeQsyewI1jfYko3", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } }, { "id": 3, "label": { "fi": "Kokeilu" } } ], "open_at": "2022-10-06T21:00:00Z", "close_at": "2022-10-30T22:00:00Z", "created_at": "2022-10-07T06:34:26.418799Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "long-heading-word-2", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Kerro mielipiteesi tästä todella pitkästä sanasta 12345678901234567890 testi 2" }, "borough": {} }, { "abstract": { "fi": "<p>test</p>" }, "id": "LiHX4noCL4io2qU6xNRi8EH0mYknSopw", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-10-06T21:00:00Z", "close_at": "2022-10-30T22:00:00Z", "created_at": "2022-10-07T06:38:25.179107Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "long-heading-word-3", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Kerro mielipiteesi tästä todella pitkästä sanasta 123456789012345678901234567890 testi 3" }, "borough": {} }, { "abstract": { "fi": "<p>Äänestä mielestäsi parasta vaihtoehtoa.</p>", "en": "<p>Vote the options that you think are the best.</p>" }, "id": "4U1NJokZD0cC3Krc5APUUgxrRsTckQ4E", "n_comments": 1, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-11-01T22:00:00Z", "close_at": "2022-11-29T22:00:00Z", "created_at": "2022-11-02T05:50:27.278233Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "marraskuun-aanestys-1", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "November votings", "fi": "Marraskuun äänestykset" }, "borough": {} }, { "abstract": { "fi": "<p>Marraskuussa sattuu ja tapahtuu. Kerro mielipiteesi asioihin.</p>" }, "id": "XvGY5Uj4rM3a56rYx7vqcm8qQ1Sv5kBp", "n_comments": 2, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-11-09T22:00:00Z", "close_at": "2022-11-29T22:00:00Z", "created_at": "2022-11-10T10:05:49.785321Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "marraskuu-kyselyt-2", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Marraskuun kyselyt vol 2" }, "borough": {} }, { "abstract": { "fi": "<p>testi</p>" }, "id": "VWDll5TSpWqyJJYVE5M9LXoOipR7gEXr", "n_comments": 2, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-11-30T22:00:00Z", "close_at": "2022-12-30T22:00:00Z", "created_at": "2022-12-01T13:04:17.362068Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "uusi-liitteella", "main_image": { "id": 61, "url": "https://testikerrokantasi-api.turku.fi/media/images/2022/12/LotLgaeV.webp", "width": 1200, "height": 568, "title": {}, "caption": { "fi": "kuva" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Uusi kuuleminen liitteen kera" }, "borough": {} }, { "abstract": { "fi": "<p>Tämä on johdanto.</p>" }, "id": "upYAoPiQi4752ODqFZO0ziANkMsVeexX", "n_comments": 13, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2022-12-07T22:00:00Z", "close_at": "2022-12-30T22:00:00Z", "created_at": "2022-12-08T11:45:54.690020Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "joulukuun-aanestykset", "main_image": { "id": 62, "url": "https://testikerrokantasi-api.turku.fi/media/images/2022/12/N8wiGd7l.png", "width": 1600, "height": 757, "title": {}, "caption": { "fi": "jouluja" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Joulukuun äänestykset" }, "borough": {} }, { "abstract": { "fi": "<p>Testi</p>" }, "id": "PHlL0TLIMhvoLA6CdSbFQYe6SMeJcPQm", "n_comments": 1, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2023-01-02T22:00:00Z", "close_at": "2023-01-30T22:00:00Z", "created_at": "2023-01-03T12:40:46.241469Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "tammikuun-tuiverrukset", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Tammikuun tuiverrukset" }, "borough": {} }, { "abstract": { "en": "<p>abc</p>", "fi": "<p>abc</p>" }, "id": "40yYFCchpzfhUwVXCIA2EE3nnXIwgWWa", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2023-01-24T22:00:00Z", "close_at": "2023-02-04T22:00:00Z", "created_at": "2023-01-25T06:10:58.398665Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "talven-valot", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "Tell us should winters have more light", "fi": "Kerro pitäisikö talvella olla valoisampaa" }, "borough": {} }, { "abstract": { "fi": "<p>Liitteitä</p>" }, "id": "HduYPfmc0GM3PrC3RQiV0c8UHVsNrWvj", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2023-02-21T22:00:00Z", "close_at": "2023-02-27T22:00:00Z", "created_at": "2023-02-22T07:44:47.940412Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "liitteet-2", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Liitteitä ja niiden rajoitukset" }, "borough": {} }, { "abstract": { "fi": "<p>Mitä kuuluu maaliskuussa?</p>" }, "id": "C39LIjQGiVPjYw1EiI4QtnHWRW2Wa2ZX", "n_comments": 2, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2023-03-16T22:00:00Z", "close_at": "2023-04-01T07:41:00Z", "created_at": "2023-03-17T08:11:52.726684Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "maaliskuun-huhuilut", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Maaliskuun huhuilut" }, "borough": {} }, { "abstract": { "fi": "<p>Mitä ne kartat ovat?</p>", "en": "<p>What are those maps?1</p>" }, "id": "WPmYDAffylPq4xAg68eP2a2UJc5VlLvi", "n_comments": 1, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2023-03-27T21:00:00Z", "close_at": "2023-04-29T21:00:00Z", "created_at": "2023-03-28T09:38:05.791789Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "maps-test2", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "What do you think of the maps?", "fi": "Mitä mieltä olet kartoista?" }, "borough": {} }, { "abstract": { "fi": "<p>johdanto</p>" }, "id": "KxdM3Be8KNUXmSO8g7RDKUC1JbvACC9S", "n_comments": 2, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2023-11-13T22:00:00Z", "close_at": "2023-11-16T06:10:00Z", "created_at": "2023-11-14T06:09:44.692118Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "testailua", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Testailua" }, "borough": {} }, { "abstract": { "fi": "<p>test</p>" }, "id": "g2OXY8OjckdbHwGn8Wr2WtQiPXc72aIj", "n_comments": 2, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2024-09-25T21:00:00Z", "close_at": "2024-10-05T21:00:00Z", "created_at": "2024-09-26T05:34:06.040135Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "testi-syksy-2024", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Testi syksy 2024" }, "borough": {} }, { "abstract": { "fi": "<p>johdanto</p>" }, "id": "0OMfZZCs0E42Nn6gU0whWsujYKwSd2su", "n_comments": 6, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } }, { "id": 3, "label": { "fi": "Kokeilu" } } ], "open_at": "2025-03-10T22:00:00Z", "close_at": "2025-04-15T21:00:00Z", "created_at": "2025-03-11T12:01:55.757549Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "maalis-2025", "main_image": { "id": 64, "url": "https://testikerrokantasi-api.turku.fi/media/images/2025/03/Ko6M0X7O.webp", "width": 1200, "height": 568, "title": {}, "caption": { "fi": "turku-kuva" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Mitä kuuluu maalis 2025" }, "borough": {} }, { "abstract": { "en": "<p>intro</p>", "fi": "<p>johdanto</p>" }, "id": "sP4VP7h5dhha5wtJYBz7fyX1XwCxnR47", "n_comments": 2, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } }, { "id": 5, "label": { "fi": "testikokeilu" } } ], "open_at": "2025-03-10T22:00:00Z", "close_at": "2025-04-04T21:00:00Z", "created_at": "2025-03-11T13:11:09.371905Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "attachment-march-2025", "main_image": { "id": 67, "url": "https://testikerrokantasi-api.turku.fi/media/images/2025/03/GnLEbtVO.webp", "width": 1024, "height": 512, "title": {}, "caption": { "en": "art", "fi": "taidetta" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "Hearing w/ attachment march 2025", "fi": "Kuuleminen liitteella maalis 2025" }, "borough": {} } ] }
