Hearing List
API endpoint for hearings.
GET /v1/hearing/?format=api&offset=50&ordering=-n_comments
{ "count": 73, "next": null, "previous": "https://testikerrokantasi-api.turku.fi/v1/hearing/?format=api&limit=50&ordering=-n_comments", "results": [ { "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": { "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>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": { "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": "Testataan, miten aikakatkaisu toimii." }, "id": "klLpCTtEvEW0QKFyXUSXcpVdEKyAbWnF", "n_comments": 0, "published": true, "labels": [ { "id": 4, "label": { "fi": "testaus, kokeilu, sisällöntuotanto, aika" } } ], "open_at": "2020-02-13T22:00:00Z", "close_at": "2020-02-14T12:11:11.094000Z", "created_at": "2020-02-14T11:49:06.347701Z", "servicemap_url": "", "preview_url": null, "project": { "id": "lx57lh0ylexlQ7qfOPaK9NhOIUhmwdEm", "phases": [ { "id": "6PfjhBZsrvfQc0M0JoJp1dGYZvdRdCoX", "has_hearings": true, "hearings": [ "tunnistaudu", "yritys", "raitiotie" ], "title": { "fi": "N" }, "description": { "fi": "än" }, "schedule": { "fi": "hetki" }, "is_active": false }, { "id": "D6WXxkW6aXG8vydX9UhEsI1ZbqPmxN5C", "has_hearings": true, "hearings": [ "kokeilu", "aikakatkaisu", "sisaverkko" ], "title": { "fi": "Y" }, "description": { "fi": "yyy" }, "schedule": { "fi": "tovi" }, "is_active": true }, { "id": "KkGTRHfXjJhpJ20R6WsmzInUuqhnNHLP", "has_hearings": false, "hearings": [], "title": { "fi": "T" }, "description": { "fi": "teee" }, "schedule": { "fi": "kotvanen" }, "is_active": false } ], "title": { "fi": "Prokkis projekti" } }, "closed": true, "organization": "Turun kaupunki", "slug": "aikakatkaisu", "main_image": { "id": 8, "url": "https://testikerrokantasi-api.turku.fi/media/images/2020/02/AZavo3UG.jpeg", "width": 960, "height": 720, "title": {}, "caption": { "fi": "Kiss my Turku" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Testataan aikakatkaisua" }, "borough": {} }, { "abstract": { "fi": "Kokeillaan tehdä sisältöjä kahdella kielellä hitaasti.", "sv": "Testing med två språk." }, "id": "jKmrAOxyJhxb0BM13ndQvRz9NCrCVqMM", "n_comments": 0, "published": true, "labels": [ { "id": 1, "label": { "fi": "apua" } }, { "id": 2, "label": { "fi": "testi" } }, { "id": 4, "label": { "fi": "testaus, kokeilu, sisällöntuotanto, aika" } } ], "open_at": "2020-02-13T22:00:00Z", "close_at": "2020-02-28T22:00:00Z", "created_at": "2020-02-14T13:12:32.562958Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "kokeillaan", "main_image": { "id": 11, "url": "https://testikerrokantasi-api.turku.fi/media/images/2020/02/ETjtIfxr.jpeg", "width": 1828, "height": 1371, "title": {}, "caption": { "fi": "Rannalla", "sv": "Havet" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Testataan vielä", "sv": "Vi ska testa" }, "borough": {} }, { "abstract": { "fi": "Testataan sisäverkossa, että aikakatkaisu toimii myöskin. " }, "id": "XgsPezT5Db2prLu3HtcW5Dn6MAgD8YrI", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } }, { "id": 3, "label": { "fi": "Kokeilu" } }, { "id": 4, "label": { "fi": "testaus, kokeilu, sisällöntuotanto, aika" } } ], "open_at": "2020-02-16T22:00:00Z", "close_at": "2020-02-23T22:00:00Z", "created_at": "2020-02-17T09:11:51.719974Z", "servicemap_url": "", "preview_url": null, "project": { "id": "lx57lh0ylexlQ7qfOPaK9NhOIUhmwdEm", "phases": [ { "id": "6PfjhBZsrvfQc0M0JoJp1dGYZvdRdCoX", "has_hearings": true, "hearings": [ "tunnistaudu", "yritys", "raitiotie" ], "title": { "fi": "N" }, "description": { "fi": "än" }, "schedule": { "fi": "hetki" }, "is_active": false }, { "id": "D6WXxkW6aXG8vydX9UhEsI1ZbqPmxN5C", "has_hearings": true, "hearings": [ "kokeilu", "aikakatkaisu", "sisaverkko" ], "title": { "fi": "Y" }, "description": { "fi": "yyy" }, "schedule": { "fi": "tovi" }, "is_active": true }, { "id": "KkGTRHfXjJhpJ20R6WsmzInUuqhnNHLP", "has_hearings": false, "hearings": [], "title": { "fi": "T" }, "description": { "fi": "teee" }, "schedule": { "fi": "kotvanen" }, "is_active": false } ], "title": { "fi": "Prokkis projekti" } }, "closed": true, "organization": "Turun kaupunki", "slug": "sisaverkko", "main_image": { "id": 12, "url": "https://testikerrokantasi-api.turku.fi/media/images/2020/02/04tYh1XE.jpeg", "width": 960, "height": 1280, "title": {}, "caption": { "fi": "Maistuis varmaan sullekin?" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "sisäverkkokokeilu" }, "borough": {} }, { "abstract": { "fi": "Kokeillaan, saako yli megan liitteen vietyä palveluun." }, "id": "sWFSK9dOnC9Yw54qt3EX12cIwHKHzBZw", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } }, { "id": 3, "label": { "fi": "Kokeilu" } }, { "id": 4, "label": { "fi": "testaus, kokeilu, sisällöntuotanto, aika" } } ], "open_at": "2020-02-18T22:00:00Z", "close_at": "2020-02-28T22:00:00Z", "created_at": "2020-02-19T14:06:21.216187Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "liitteet", "main_image": { "id": 14, "url": "https://testikerrokantasi-api.turku.fi/media/images/2020/02/4oDxzUtL.jpeg", "width": 960, "height": 720, "title": {}, "caption": { "fi": "Kiss my" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Liitekoon testaus" }, "borough": {} }, { "abstract": {}, "id": "GOmkR16YjoSbKtD6ZBU0QLO3khb0fdSy", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2020-03-01T22:00:00Z", "close_at": "2020-03-02T22:00:00Z", "created_at": "2020-03-02T07:10:55.447744Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "testi321", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Testikuuleminen123" }, "borough": {} }, { "abstract": { "fi": "Johdantoa" }, "id": "XGgDeRrma3qkvDqm6lbqshBWU8RkCGMP", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2020-05-05T21:00:00Z", "close_at": "2020-05-09T21:00:00Z", "created_at": "2020-05-06T07:32:17.118696Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "testailualiitteilla", "main_image": { "id": 15, "url": "https://testikerrokantasi-api.turku.fi/media/images/2020/05/KfjiaY0M.jpeg", "width": 1200, "height": 568, "title": {}, "caption": { "fi": "Turkuhan se siinä" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Testikuuluminen liitteellä" }, "borough": {} }, { "abstract": { "fi": "Lyhyt johdanto" }, "id": "X2qr83AD6yhUiFBpeEZEEyVaqq7zbNyq", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2020-05-19T21:00:00Z", "close_at": "2020-05-20T21:00:00Z", "created_at": "2020-05-20T05:48:05.762259Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "piste", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Piste kartalla" }, "borough": {} }, { "abstract": { "fi": "Johdanto tekstiii", "sv": "Kort information om någonting" }, "id": "2MZEgJ0vG33QdrTOl9DhIhfWlpqjqETQ", "n_comments": 0, "published": true, "labels": [ { "id": 3, "label": { "fi": "Kokeilu" } } ], "open_at": "2020-06-15T21:00:00Z", "close_at": "2020-06-16T21:00:00Z", "created_at": "2020-06-05T11:52:22.700912Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "esikatselu", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "esikatselu", "sv": "esikatselu på svenska" }, "borough": {} }, { "abstract": { "en": "lyhyt johdanto en", "fi": "lyhyt johdanto fi" }, "id": "UgWvkE69bfASqY0D2dlj71hcLwjDIwmV", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2020-08-13T21:00:00Z", "close_at": "2020-08-14T06:36:43.360000Z", "created_at": "2020-08-14T06:29:28.164823Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "testailua123", "main_image": { "id": 30, "url": "https://testikerrokantasi-api.turku.fi/media/images/2020/08/DxQwo5ke.png", "width": 256, "height": 256, "title": {}, "caption": { "en": "kuvateksti en", "fi": "kuvateksti fi" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "otsikko en", "fi": "otsikko fi" }, "borough": {} }, { "abstract": { "en": "short description for animal hearing", "fi": "johdanto eläinjuttuun" }, "id": "Z5fyox36lMH8Lt64mTFQji9HLQCJDpDF", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2020-09-02T21:00:00Z", "close_at": "2020-10-03T21:00:00Z", "created_at": "2020-09-03T10:01:58.981622Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "elainvideoita1", "main_image": { "id": 32, "url": "https://testikerrokantasi-api.turku.fi/media/images/2020/09/5jKO2b5U.jpeg", "width": 1200, "height": 568, "title": {}, "caption": { "en": "turku", "fi": "turku" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "Animals, what are they exactly", "fi": "Mitä ne eläimet ovat" }, "borough": {} }, { "abstract": { "fi": "Yliopistokampusten ja Kupittaan alueelle levittäytyvällä Tiedepuistoalueella on merkittävä rooli kasvun tukemisessa paitsi monipuolisena koulutus- ja tutkimuskeskittymänä myös kansainvälisesti merkittävänä osaamisintensiivisen yritystoiminnan keskuksena ja vetovoimaisena asuinympäristönä." }, "id": "txIsaEWP7OhTOupEdeCb9vjVQvNFi2Kj", "n_comments": 0, "published": true, "labels": [ { "id": 10, "label": { "fi": "3D" } }, { "id": 2, "label": { "fi": "testi" } }, { "id": 3, "label": { "fi": "Kokeilu" } } ], "open_at": "2020-10-11T21:00:00Z", "close_at": "2020-11-14T22:00:00Z", "created_at": "2020-10-12T11:03:19.431860Z", "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": "kupittaa3d", "main_image": { "id": 37, "url": "https://testikerrokantasi-api.turku.fi/media/images/2020/10/HFaCH9qa.jpeg", "width": 960, "height": 720, "title": {}, "caption": { "fi": "Kupittaa 3D" }, "alt_text": {} }, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Kupittaan alueen 3D-mallit " }, "borough": {} }, { "abstract": { "en": "description", "fi": "johdanto" }, "id": "V8VWdvuFrzPkkSMExG8LlcWxEdHdFVKS", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2020-11-25T22:00:00Z", "close_at": "2020-11-26T12:43:46.575000Z", "created_at": "2020-11-26T12:43:26.159350Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "fin-eng", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "en": "Finnish and English", "fi": "Suomea ja englantia" }, "borough": {} }, { "abstract": { "fi": "Aurajoessa on kummallisia merkkejä!" }, "id": "AO6es1GZBBMD9XZGMzt4KLhAfxs9PAe5", "n_comments": 0, "published": true, "labels": [ { "id": 3, "label": { "fi": "Kokeilu" } } ], "open_at": "2021-02-17T22:00:00Z", "close_at": "2021-03-13T22:00:00Z", "created_at": "2021-02-18T12:22:24.698575Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "merkkiaura", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Merkkejä aurajoessa!" }, "borough": {} }, { "abstract": { "fi": "Polygonit ovat saapuneet Turkuun!" }, "id": "D5FrcM73Z6eT5hN73AjDD9b10JjOKRGN", "n_comments": 0, "published": true, "labels": [ { "id": 3, "label": { "fi": "Kokeilu" } } ], "open_at": "2021-02-17T22:00:00Z", "close_at": "2021-03-13T22:00:00Z", "created_at": "2021-02-18T12:39:11.428223Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "turunpoly", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Turun polygonit" }, "borough": {} }, { "abstract": {}, "id": "BELv9WwXAhE5H7xzeN3COxLqlL2HIcNl", "n_comments": 0, "published": true, "labels": [ { "id": 2, "label": { "fi": "testi" } } ], "open_at": "2021-12-17T22:00:00Z", "close_at": "2021-12-18T22:00:00Z", "created_at": "2021-04-20T05:25:49.257148Z", "servicemap_url": "", "preview_url": null, "project": null, "closed": true, "organization": "Turun kaupunki", "slug": "kuuleminen-jonossa", "main_image": null, "default_to_fullscreen": false, "visible_for_auth_methods": [], "title": { "fi": "Kuuleminen jonossa" }, "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": { "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": {} } ] }
