Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/simple_sql_exercises/ja/changes/?format=api
{ "count": 109, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": null, "author": null, "timestamp": "2023-12-06T09:23:51.134083Z", "action": 17, "target": "", "id": 1899976, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1899976/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99412/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:54:42.369616Z", "action": 26, "target": "`sum(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコード集合のレコードの合計を返すPostgreSQL 集約関数です。", "id": 1899975, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1899975/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99412/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:54:28.230238Z", "action": 7, "target": "`count(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコードの集合のレコード数を返す PostgreSQL 集約関数。", "id": 1899974, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899974/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99411/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:53:59.849742Z", "action": 26, "target": "`sum(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコード集合のレコードの合計を返すPostgreSQL 集約関数です。", "id": 1899973, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/1899973/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99409/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:53:05.996920Z", "action": 7, "target": "**それぞれの行政区で、白人の人口比率は何パーセントでしょうか?**", "id": 1899972, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899972/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99408/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:53:02.581875Z", "action": 7, "target": "**各行政区にはそれぞれどれだけの地区があるでしょうか?**", "id": 1899971, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899971/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99407/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:59.701273Z", "action": 7, "target": "**ブロンクスの人口はいくらでしょうか?**", "id": 1899970, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899970/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99405/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:56.550363Z", "action": 7, "target": "この\"AS\"とは何でしょう? テーブルまたはカラムに、エイリアスを使って他の名前を与えることができます。エイリアスは読み書きともにクエリを簡単にしてくれます。``sum`` という出力カラム名の代わりに、カラム名が読みやすい ``population`` にするために **AS** を書きます。", "id": 1899969, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899969/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99404/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:50.119085Z", "action": 7, "target": "**ニューヨーク市の人口はいくらでしょうか?**", "id": 1899968, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899968/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99403/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:46.223579Z", "action": 7, "target": "**ニューヨーク市のストリート数はいくつでしょうか?**", "id": 1899967, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899967/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99402/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:35.871734Z", "action": 7, "target": "**nyc_streets テーブルのレコード数はいくつでしょうか?**", "id": 1899966, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899966/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99401/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:31.880544Z", "action": 7, "target": "では問題です:", "id": 1899965, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899965/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99399/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:29.413606Z", "action": 7, "target": "count() - レコードの集合のレコード数", "id": 1899964, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899964/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99398/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:27.360162Z", "action": 7, "target": "sum() - レコードの集合の合計値", "id": 1899963, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899963/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99397/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:24.851879Z", "action": 7, "target": "avg() - レコードの集合の平均値", "id": 1899962, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899962/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99396/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:22.030101Z", "action": 7, "target": "また、便利と思う可能性がありそうな、一般的な SQL 集約関数をここで示します:", "id": 1899961, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899961/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99395/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:13.920671Z", "action": 7, "target": "ブロックのポリゴン", "id": 1899960, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899960/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99390/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:08.550566Z", "action": 7, "target": "ブロック内の賃貸住宅の戸数", "id": 1899958, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899958/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99389/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:06.318644Z", "action": 7, "target": "**hous_rent**", "id": 1899957, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899957/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99388/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:03.268628Z", "action": 7, "target": "ブロック内の持ち家の戸数", "id": 1899956, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899956/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99387/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:52:00.830492Z", "action": 7, "target": "**hous_own**", "id": 1899955, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899955/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99386/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:58.685460Z", "action": 7, "target": "ブロック内の住宅戸数", "id": 1899954, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899954/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99384/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:52.570640Z", "action": 7, "target": "**hous_total**", "id": 1899953, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899953/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99383/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:49.140754Z", "action": 7, "target": "ブロック内で他のカテゴリを自認する人の数", "id": 1899952, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899952/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99381/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:44.081133Z", "action": 7, "target": "ブロック内で「アジア人」と自認する人の数", "id": 1899950, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899950/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99379/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:38.252728Z", "action": 7, "target": "ブロック内で「ネイティブアメリカン」と自認する人の数", "id": 1899949, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899949/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99377/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:36.035340Z", "action": 7, "target": "ブロック内で「黒人」を自認する人の数", "id": 1899948, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899948/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99374/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:33.756165Z", "action": 7, "target": "ブロック内で「白人」を自認する人の数", "id": 1899947, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899947/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99372/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:30.309943Z", "action": 7, "target": "ブロック内の人の合計", "id": 1899946, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899946/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99367/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:51:02.525371Z", "action": 7, "target": "始めるのに助けになる情報を示します。:ref:`About Our Data <about_data>` セクションの ``nyc_census_blocks`` テーブル定義を思い出して下さい。", "id": 1899944, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899944/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99366/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:50:53.578468Z", "action": 7, "target": "``nyc_census_blocks`` テーブルを使って、次の問に答えます (回答を覗かないで下さい!)。", "id": 1899943, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899943/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99365/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:50:44.897603Z", "action": 7, "target": "単純なSQLの練習", "id": 1899942, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1899942/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99412/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.742792Z", "action": 4, "target": "`count(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコードの集合のレコード数を返す PostgreSQL 集約関数。", "id": 1899941, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899941/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99409/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.728603Z", "action": 4, "target": "**それぞれの行政区で、白人の人口比率は何パーセントでしょうか?**", "id": 1899940, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899940/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99408/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.723443Z", "action": 4, "target": "**各行政区にはそれぞれどれだけの地区があるでしょうか?**", "id": 1899939, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899939/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99407/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.718373Z", "action": 4, "target": "**ブロンクスの人口はいくらでしょうか?**", "id": 1899938, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899938/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99405/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.713134Z", "action": 4, "target": "この\"AS\"とは何でしょう? テーブルまたはカラムに、エイリアスを使って他の名前を与えることができます。エイリアスは読み書きともにクエリを簡単にしてくれます。``sum`` という出力カラム名の代わりに、カラム名が読みやすい ``population`` にするために **AS** を書きます。", "id": 1899937, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899937/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99404/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.707783Z", "action": 4, "target": "**ニューヨーク市の人口はいくらでしょうか?**", "id": 1899936, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899936/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99403/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.702871Z", "action": 4, "target": "**ニューヨーク市のストリート数はいくつでしょうか?**", "id": 1899935, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899935/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99402/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.696208Z", "action": 4, "target": "**nyc_streets テーブルのレコード数はいくつでしょうか?**", "id": 1899934, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899934/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99401/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.670884Z", "action": 4, "target": "では問題です:", "id": 1899933, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899933/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99399/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.666488Z", "action": 4, "target": "count() - レコードの集合のレコード数", "id": 1899932, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899932/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99398/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.662125Z", "action": 4, "target": "sum() - レコードの集合の合計値", "id": 1899931, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899931/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99397/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.647569Z", "action": 4, "target": "avg() - レコードの集合の平均値", "id": 1899930, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899930/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99396/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.636403Z", "action": 4, "target": "また、便利と思う可能性がありそうな、一般的な SQL 集約関数をここで示します:", "id": 1899929, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899929/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99395/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.631055Z", "action": 4, "target": "ブロックのポリゴン", "id": 1899928, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899928/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99390/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.619889Z", "action": 4, "target": "ブロック内の賃貸住宅の戸数", "id": 1899927, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899927/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99389/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.612602Z", "action": 4, "target": "**hous_rent**", "id": 1899926, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899926/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99388/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.605011Z", "action": 4, "target": "ブロック内の持ち家の戸数", "id": 1899925, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899925/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/99387/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/simple_sql_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-06T07:49:55.597996Z", "action": 4, "target": "**hous_own**", "id": 1899924, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1899924/?format=api" } ] }