Units
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/units/?format=api
{ "count": 43, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Simple SQL Exercises" ], "previous_source": "", "target": [ "単純なSQLの練習" ], "id_hash": 7391659653956920966, "content_hash": 7391659653956920966, "location": "../../en/simple_sql_exercises.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/98775/?format=api", "priority": 100, "id": 99365, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=e694734ae6b06686", "url": "https://weblate.osgeo.org/api/units/99365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.869460Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Using the ``nyc_census_blocks`` table, answer the following questions (don't peek at the answers!)." ], "previous_source": "", "target": [ "``nyc_census_blocks`` テーブルを使って、次の問に答えます (回答を覗かないで下さい!)。" ], "id_hash": -2192491396184247673, "content_hash": -2192491396184247673, "location": "../../en/simple_sql_exercises.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/98790/?format=api", "priority": 100, "id": 99366, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=6192b4b105567287", "url": "https://weblate.osgeo.org/api/units/99366/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.871254Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Here is some helpful information to get started. Recall from the :ref:`About Our Data <about_data>` section our ``nyc_census_blocks`` table definition." ], "previous_source": "", "target": [ "始めるのに助けになる情報を示します。:ref:`About Our Data <about_data>` セクションの ``nyc_census_blocks`` テーブル定義を思い出して下さい。" ], "id_hash": -819726270016258043, "content_hash": -819726270016258043, "location": "../../en/simple_sql_exercises.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/98817/?format=api", "priority": 100, "id": 99367, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=749fbf4ceea00005", "url": "https://weblate.osgeo.org/api/units/99367/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.872916Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**blkid**" ], "previous_source": "", "target": [ "**blkid**" ], "id_hash": 4455612312482195962, "content_hash": 4455612312482195962, "location": "../../en/simple_sql_exercises.rst:13", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98843/?format=api", "priority": 100, "id": 99369, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=bdd583ca965ba9fa", "url": "https://weblate.osgeo.org/api/units/99369/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.874614Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "A 15-digit code that uniquely identifies every census **block**. (\"360050001009000\")" ], "previous_source": "", "target": [ "**block**を一意に識別する15桁のコードです。例: 360050001009000" ], "id_hash": 792585444714335412, "content_hash": 792585444714335412, "location": "../../en/simple_sql_exercises.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/98852/?format=api", "priority": 100, "id": 99370, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=8affd4433e57ccb4", "url": "https://weblate.osgeo.org/api/units/99370/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.876268Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**popn_total**" ], "previous_source": "", "target": [ "**popn_total**" ], "id_hash": 3207253734187756479, "content_hash": 3207253734187756479, "location": "../../en/simple_sql_exercises.rst:15", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98853/?format=api", "priority": 100, "id": 99371, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=ac8274474ace6bbf", "url": "https://weblate.osgeo.org/api/units/99371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.877884Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Total number of people in the census block" ], "previous_source": "", "target": [ "ブロック内の人の合計" ], "id_hash": -8637333688359982042, "content_hash": -8637333688359982042, "location": "../../en/simple_sql_exercises.rst:16", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/98855/?format=api", "priority": 100, "id": 99372, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=082206c5e2c9ec26", "url": "https://weblate.osgeo.org/api/units/99372/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.879701Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**popn_white**" ], "previous_source": "", "target": [ "**popn_white**" ], "id_hash": 2989794137418586630, "content_hash": 2989794137418586630, "location": "../../en/simple_sql_exercises.rst:17", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98871/?format=api", "priority": 100, "id": 99373, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=a97de1ed68615a06", "url": "https://weblate.osgeo.org/api/units/99373/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.881614Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Number of people self-identifying as \"white\" in the block" ], "previous_source": "", "target": [ "ブロック内で「白人」を自認する人の数" ], "id_hash": 2095069009946220016, "content_hash": 2095069009946220016, "location": "../../en/simple_sql_exercises.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98885/?format=api", "priority": 100, "id": 99374, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=9d132e2a15c615f0", "url": "https://weblate.osgeo.org/api/units/99374/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.883334Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**popn_black**" ], "previous_source": "", "target": [ "**popn_black**" ], "id_hash": 4450373731152497930, "content_hash": 4450373731152497930, "location": "../../en/simple_sql_exercises.rst:19", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98891/?format=api", "priority": 100, "id": 99376, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=bdc2e75453130d0a", "url": "https://weblate.osgeo.org/api/units/99376/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.884901Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Number of people self-identifying as \"black\" in the block" ], "previous_source": "", "target": [ "ブロック内で「黒人」を自認する人の数" ], "id_hash": 5911843986890411697, "content_hash": 5911843986890411697, "location": "../../en/simple_sql_exercises.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98895/?format=api", "priority": 100, "id": 99377, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=d20b16c8a621ceb1", "url": "https://weblate.osgeo.org/api/units/99377/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.886541Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**popn_nativ**" ], "previous_source": "", "target": [ "**popn_nativ**" ], "id_hash": 7570478575193433766, "content_hash": 7570478575193433766, "location": "../../en/simple_sql_exercises.rst:21", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98909/?format=api", "priority": 100, "id": 99378, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=e90fbe276e1c26a6", "url": "https://weblate.osgeo.org/api/units/99378/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.888184Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Number of people self-identifying as \"native american\" in the block" ], "previous_source": "", "target": [ "ブロック内で「ネイティブアメリカン」と自認する人の数" ], "id_hash": -8581578102432306243, "content_hash": -8581578102432306243, "location": "../../en/simple_sql_exercises.rst:22", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/98923/?format=api", "priority": 100, "id": 99379, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=08e81c2ed8406bbd", "url": "https://weblate.osgeo.org/api/units/99379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.890160Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**popn_asian**" ], "previous_source": "", "target": [ "**popn_asian**" ], "id_hash": -2892135553152312969, "content_hash": -2892135553152312969, "location": "../../en/simple_sql_exercises.rst:23", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98939/?format=api", "priority": 100, "id": 99380, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=57dd1209a0141977", "url": "https://weblate.osgeo.org/api/units/99380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.891801Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Number of people self-identifying as \"asias\" in the block" ], "previous_source": "", "target": [ "ブロック内で「アジア人」と自認する人の数" ], "id_hash": -9175384732451406639, "content_hash": -9175384732451406639, "location": "../../en/simple_sql_exercises.rst:24", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98944/?format=api", "priority": 100, "id": 99381, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=00aa7c32f8b0fcd1", "url": "https://weblate.osgeo.org/api/units/99381/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.893488Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**popn_other**" ], "previous_source": "", "target": [ "**popn_other**" ], "id_hash": -8031490854914275744, "content_hash": -8031490854914275744, "location": "../../en/simple_sql_exercises.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98958/?format=api", "priority": 100, "id": 99382, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=108a699ec0094660", "url": "https://weblate.osgeo.org/api/units/99382/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.895085Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Number of people self-identifying with other categories in the block" ], "previous_source": "", "target": [ "ブロック内で他のカテゴリを自認する人の数" ], "id_hash": 3559258909274077066, "content_hash": 3559258909274077066, "location": "../../en/simple_sql_exercises.rst:26", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/98972/?format=api", "priority": 100, "id": 99383, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=b165071ec6ecf78a", "url": "https://weblate.osgeo.org/api/units/99383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.896696Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**hous_total**" ], "previous_source": "", "target": [ "**hous_total**" ], "id_hash": 6535624353112081775, "content_hash": 6535624353112081775, "location": "../../en/simple_sql_exercises.rst:27", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98978/?format=api", "priority": 100, "id": 99384, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=dab333b8d0a3456f", "url": "https://weblate.osgeo.org/api/units/99384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.898486Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Number of housing units in the block" ], "previous_source": "", "target": [ "ブロック内の住宅戸数" ], "id_hash": 5924189176815318996, "content_hash": 5924189176815318996, "location": "../../en/simple_sql_exercises.rst:28", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/98979/?format=api", "priority": 100, "id": 99386, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=d236f2ab2a4a77d4", "url": "https://weblate.osgeo.org/api/units/99386/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.900053Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**hous_own**" ], "previous_source": "", "target": [ "**hous_own**" ], "id_hash": 5993015848570913029, "content_hash": 5993015848570913029, "location": "../../en/simple_sql_exercises.rst:29", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98986/?format=api", "priority": 100, "id": 99387, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=d32b7829735b0105", "url": "https://weblate.osgeo.org/api/units/99387/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.901995Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Number of owner-occupied housing units in the block" ], "previous_source": "", "target": [ "ブロック内の持ち家の戸数" ], "id_hash": -1717034827220046588, "content_hash": -1717034827220046588, "location": "../../en/simple_sql_exercises.rst:30", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99001/?format=api", "priority": 100, "id": 99388, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=682bddec00932d04", "url": "https://weblate.osgeo.org/api/units/99388/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.903616Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**hous_rent**" ], "previous_source": "", "target": [ "**hous_rent**" ], "id_hash": 7569711628174105056, "content_hash": 7569711628174105056, "location": "../../en/simple_sql_exercises.rst:31", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/99015/?format=api", "priority": 100, "id": 99389, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=e90d049ea97619e0", "url": "https://weblate.osgeo.org/api/units/99389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.905233Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Number of renter-occupied housing units in the block" ], "previous_source": "", "target": [ "ブロック内の賃貸住宅の戸数" ], "id_hash": -4609971187644732379, "content_hash": -4609971187644732379, "location": "../../en/simple_sql_exercises.rst:32", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99029/?format=api", "priority": 100, "id": 99390, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=400617a127a66c25", "url": "https://weblate.osgeo.org/api/units/99390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.907039Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**boroname**" ], "previous_source": "", "target": [ "**boroname**" ], "id_hash": -2426544829175072294, "content_hash": -2426544829175072294, "location": "../../en/simple_sql_exercises.rst:33", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/99031/?format=api", "priority": 100, "id": 99392, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=5e532e55917579da", "url": "https://weblate.osgeo.org/api/units/99392/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.908873Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens" ], "previous_source": "", "target": [ "ニューヨーク市の行政区名。マンハッタン区、ブロンクス区、ブルックリン区、スタテンアイランド区、クイーンズ区" ], "id_hash": 7222515035625290769, "content_hash": 7222515035625290769, "location": "../../en/simple_sql_exercises.rst:34", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/99033/?format=api", "priority": 100, "id": 99393, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=e43b87288b5cfc11", "url": "https://weblate.osgeo.org/api/units/99393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.910652Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**geom**" ], "previous_source": "", "target": [ "**geom**" ], "id_hash": -6845778499464042158, "content_hash": -6845778499464042158, "location": "../../en/simple_sql_exercises.rst:35", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/99035/?format=api", "priority": 100, "id": 99394, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=20fee8b9a8706952", "url": "https://weblate.osgeo.org/api/units/99394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.912418Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Polygon boundary of the block" ], "previous_source": "", "target": [ "ブロックのポリゴン" ], "id_hash": -4694937910987667640, "content_hash": -4694937910987667640, "location": "../../en/simple_sql_exercises.rst:36", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://weblate.osgeo.org/api/units/99037/?format=api", "priority": 100, "id": 99395, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=3ed83ad84510c748", "url": "https://weblate.osgeo.org/api/units/99395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.914207Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "And, here are some common SQL aggregation functions you might find useful:" ], "previous_source": "", "target": [ "また、便利と思う可能性がありそうな、一般的な SQL 集約関数をここで示します:" ], "id_hash": 2730141386759297400, "content_hash": 2730141386759297400, "location": "../../en/simple_sql_exercises.rst:38", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/99039/?format=api", "priority": 100, "id": 99396, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=a5e3692058615978", "url": "https://weblate.osgeo.org/api/units/99396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.915879Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "avg() - the average (mean) of the values in a set of records" ], "previous_source": "", "target": [ "avg() - レコードの集合の平均値" ], "id_hash": 897538520133565310, "content_hash": 897538520133565310, "location": "../../en/simple_sql_exercises.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/99041/?format=api", "priority": 100, "id": 99397, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=8c74b28758ca7b7e", "url": "https://weblate.osgeo.org/api/units/99397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.917553Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "sum() - the sum of the values in a set of records" ], "previous_source": "", "target": [ "sum() - レコードの集合の合計値" ], "id_hash": 5263757493764616429, "content_hash": 5263757493764616429, "location": "../../en/simple_sql_exercises.rst:41", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/99043/?format=api", "priority": 100, "id": 99398, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=c90c9f8d4fa3f0ed", "url": "https://weblate.osgeo.org/api/units/99398/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.919265Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "count() - the number of records in a set of records" ], "previous_source": "", "target": [ "count() - レコードの集合のレコード数" ], "id_hash": 8310299052878010924, "content_hash": 8310299052878010924, "location": "../../en/simple_sql_exercises.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/99045/?format=api", "priority": 100, "id": 99399, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=f3541cf5700f1a2c", "url": "https://weblate.osgeo.org/api/units/99399/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.920888Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Now the questions:" ], "previous_source": "", "target": [ "では問題です:" ], "id_hash": 2540204093351684619, "content_hash": 2540204093351684619, "location": "../../en/simple_sql_exercises.rst:44", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/99047/?format=api", "priority": 100, "id": 99401, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=a3409e2a11386a0b", "url": "https://weblate.osgeo.org/api/units/99401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.922534Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**How many records are in the nyc_streets table?**" ], "previous_source": "", "target": [ "**nyc_streets テーブルのレコード数はいくつでしょうか?**" ], "id_hash": 1267841475982977979, "content_hash": 1267841475982977979, "location": "../../en/simple_sql_exercises.rst:46", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99049/?format=api", "priority": 100, "id": 99402, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=9198471ae778ebbb", "url": "https://weblate.osgeo.org/api/units/99402/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.924151Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**How many streets in NYC start with ‘B’?**" ], "previous_source": "", "target": [ "**ニューヨーク市のストリート数はいくつでしょうか?**" ], "id_hash": -4872103193866870609, "content_hash": -4872103193866870609, "location": "../../en/simple_sql_exercises.rst:57", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99051/?format=api", "priority": 100, "id": 99403, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=3c62cff56c84e0af", "url": "https://weblate.osgeo.org/api/units/99403/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.925805Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**What is the population of the City of New York?**" ], "previous_source": "", "target": [ "**ニューヨーク市の人口はいくらでしょうか?**" ], "id_hash": -2285718457802260253, "content_hash": -2285718457802260253, "location": "../../en/simple_sql_exercises.rst:70", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/99053/?format=api", "priority": 100, "id": 99404, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=60477f2c422480e3", "url": "https://weblate.osgeo.org/api/units/99404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.927483Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "What is this ``AS``? You can give a table or a column another name by using an alias. Aliases can make queries easier to both write and to read. So instead of our outputted column name as ``sum`` we write it **AS** the more readable ``population``." ], "previous_source": "", "target": [ "この\"AS\"とは何でしょう? テーブルまたはカラムに、エイリアスを使って他の名前を与えることができます。エイリアスは読み書きともにクエリを簡単にしてくれます。``sum`` という出力カラム名の代わりに、カラム名が読みやすい ``population`` にするために **AS** を書きます。" ], "id_hash": -2056294683241980692, "content_hash": -2056294683241980692, "location": "../../en/simple_sql_exercises.rst:83", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://weblate.osgeo.org/api/units/99056/?format=api", "priority": 100, "id": 99405, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=637692e15bd65cec", "url": "https://weblate.osgeo.org/api/units/99405/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.929440Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**What is the population of the Bronx?**" ], "previous_source": "", "target": [ "**ブロンクスの人口はいくらでしょうか?**" ], "id_hash": 289809660783314964, "content_hash": 289809660783314964, "location": "../../en/simple_sql_exercises.rst:85", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 37, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/99059/?format=api", "priority": 100, "id": 99407, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=84059c59db774814", "url": "https://weblate.osgeo.org/api/units/99407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.931519Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**How many \"neighborhoods\" are in each borough?**" ], "previous_source": "", "target": [ "**各行政区にはそれぞれどれだけの地区があるでしょうか?**" ], "id_hash": -3261662850228115462, "content_hash": -3261662850228115462, "location": "../../en/simple_sql_exercises.rst:98", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 38, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/99062/?format=api", "priority": 100, "id": 99408, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=52bc3eeb3310a7fa", "url": "https://weblate.osgeo.org/api/units/99408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.933471Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "**For each borough, what percentage of the population is white?**" ], "previous_source": "", "target": [ "**それぞれの行政区で、白人の人口比率は何パーセントでしょうか?**" ], "id_hash": 6360112737815468277, "content_hash": 6360112737815468277, "location": "../../en/simple_sql_exercises.rst:118", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/99065/?format=api", "priority": 100, "id": 99409, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=d843a8d674ed98f5", "url": "https://weblate.osgeo.org/api/units/99409/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.935052Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "関数リスト" ], "id_hash": 2815949782297668712, "content_hash": 2815949782297668712, "location": "../../en/simple_sql_exercises.rst:141", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 40, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99068/?format=api", "priority": 100, "id": 99410, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/99410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.936646Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "`avg(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the average value of a numeric column." ], "previous_source": "", "target": [ "`avg(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: 数値カラムの値の平均を返す PostgreSQL 集約関数。" ], "id_hash": -5033877154090146436, "content_hash": -5033877154090146436, "location": "../../en/simple_sql_exercises.rst:143", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 41, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/99071/?format=api", "priority": 100, "id": 99411, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=3a2413662380a57c", "url": "https://weblate.osgeo.org/api/units/99411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.938307Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "`count(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the number of records in a set of records." ], "previous_source": "", "target": [ "`count(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコードの集合のレコード数を返す PostgreSQL 集約関数。" ], "id_hash": -3895977768218033526, "content_hash": -3895977768218033526, "location": "../../en/simple_sql_exercises.rst:145", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 42, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/99101/?format=api", "priority": 100, "id": 99412, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=49eeb4dc908b828a", "url": "https://weblate.osgeo.org/api/units/99412/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.940068Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/ja/?format=api", "source": [ "`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the sum of records in a set of records." ], "previous_source": "", "target": [ "`sum(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコード集合のレコードの合計を返すPostgreSQL 集約関数です。" ], "id_hash": 3440714517161692930, "content_hash": 3440714517161692930, "location": "../../en/simple_sql_exercises.rst:147", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 43, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/99105/?format=api", "priority": 100, "id": 99413, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/ja/?checksum=afbfdf9fa8f3cf02", "url": "https://weblate.osgeo.org/api/units/99413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.941814Z" } ] }