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/es/units/?format=api
{ "count": 43, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Simple SQL Exercises" ], "previous_source": "", "target": [ "Ejercicios Básicos de 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": 99272, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=e694734ae6b06686", "url": "https://weblate.osgeo.org/api/units/99272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.671949Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Using the ``nyc_census_blocks`` table, answer the following questions (don't peek at the answers!)." ], "previous_source": "", "target": [ "Utilizando la tabla ``nyc_census_blocks``, responde a las siguientes preguntas (¡no mires las respuestas!)." ], "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": 99273, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=6192b4b105567287", "url": "https://weblate.osgeo.org/api/units/99273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.673927Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": [ "Aquí tiene información útil para empezar. Recuerda la definición de la tabla ``nyc_census_blocks`` de la sección :ref:`Acerca de nuestros datos<about_data>`." ], "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": 99274, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=749fbf4ceea00005", "url": "https://weblate.osgeo.org/api/units/99274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.675560Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99275, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=bdd583ca965ba9fa", "url": "https://weblate.osgeo.org/api/units/99275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.677248Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "A 15-digit code that uniquely identifies every census **block**. (\"360050001009000\")" ], "previous_source": "", "target": [ "Un código de 15 dígitos que identifica de forma única cada **bloque** del censo. Ej: 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": 99276, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=8affd4433e57ccb4", "url": "https://weblate.osgeo.org/api/units/99276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.679161Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99277, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=ac8274474ace6bbf", "url": "https://weblate.osgeo.org/api/units/99277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.680874Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Total number of people in the census block" ], "previous_source": "", "target": [ "Número total de personas en el bloque del censo" ], "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": 99278, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=082206c5e2c9ec26", "url": "https://weblate.osgeo.org/api/units/99278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.682573Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99279, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=a97de1ed68615a06", "url": "https://weblate.osgeo.org/api/units/99279/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.684234Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Number of people self-identifying as \"white\" in the block" ], "previous_source": "", "target": [ "Número de personas que se auto-identifican como \"Blanco/a\"" ], "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": 99280, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=9d132e2a15c615f0", "url": "https://weblate.osgeo.org/api/units/99280/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.685859Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99281, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=bdc2e75453130d0a", "url": "https://weblate.osgeo.org/api/units/99281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.687567Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Number of people self-identifying as \"black\" in the block" ], "previous_source": "", "target": [ "Número de personas que se auto-identifican con \"Negro/a\"" ], "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": 99283, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=d20b16c8a621ceb1", "url": "https://weblate.osgeo.org/api/units/99283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.689394Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99284, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=e90fbe276e1c26a6", "url": "https://weblate.osgeo.org/api/units/99284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.691071Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Number of people self-identifying as \"native american\" in the block" ], "previous_source": "", "target": [ "Número de personas que se auto-identifican como \"Nativo/a Americano/a\"" ], "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": 99285, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=08e81c2ed8406bbd", "url": "https://weblate.osgeo.org/api/units/99285/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.692784Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99287, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=57dd1209a0141977", "url": "https://weblate.osgeo.org/api/units/99287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.694489Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Number of people self-identifying as \"asias\" in the block" ], "previous_source": "", "target": [ "Número de personas que se auto-identifican como \"Asiático/a\"" ], "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": 99288, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=00aa7c32f8b0fcd1", "url": "https://weblate.osgeo.org/api/units/99288/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.696142Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99289, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=108a699ec0094660", "url": "https://weblate.osgeo.org/api/units/99289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.697772Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Number of people self-identifying with other categories in the block" ], "previous_source": "", "target": [ "Número de personas que se auto-identifican como otras categorías" ], "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": 99290, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=b165071ec6ecf78a", "url": "https://weblate.osgeo.org/api/units/99290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.699387Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99291, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=dab333b8d0a3456f", "url": "https://weblate.osgeo.org/api/units/99291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.701102Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Number of housing units in the block" ], "previous_source": "", "target": [ "Número de viviendas en el bloque" ], "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": 99292, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=d236f2ab2a4a77d4", "url": "https://weblate.osgeo.org/api/units/99292/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.702797Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99293, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=d32b7829735b0105", "url": "https://weblate.osgeo.org/api/units/99293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.704517Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Number of owner-occupied housing units in the block" ], "previous_source": "", "target": [ "Número de viviendas ocupadas por sus propietarios en el bloque" ], "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": 99294, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=682bddec00932d04", "url": "https://weblate.osgeo.org/api/units/99294/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.706159Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99295, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=e90d049ea97619e0", "url": "https://weblate.osgeo.org/api/units/99295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.707812Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Number of renter-occupied housing units in the block" ], "previous_source": "", "target": [ "Número de viviendas ocupadas por inquilinos en el bloque" ], "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": 99296, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=400617a127a66c25", "url": "https://weblate.osgeo.org/api/units/99296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.709442Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99297, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=5e532e55917579da", "url": "https://weblate.osgeo.org/api/units/99297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.711085Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens" ], "previous_source": "", "target": [ "Nombre del distrito de Nueva York, Manhattan, el Bronx, Brooklyn, Staten Island, Queens" ], "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": 99298, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=e43b87288b5cfc11", "url": "https://weblate.osgeo.org/api/units/99298/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.712707Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": 99300, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=20fee8b9a8706952", "url": "https://weblate.osgeo.org/api/units/99300/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.714346Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Polygon boundary of the block" ], "previous_source": "", "target": [ "Límite del bloque" ], "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": 99301, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=3ed83ad84510c748", "url": "https://weblate.osgeo.org/api/units/99301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.715940Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "And, here are some common SQL aggregation functions you might find useful:" ], "previous_source": "", "target": [ "Además, aquí tienes algunas funciones de agregación SQL comunes que pueden resultarte útiles:" ], "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": 99302, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=a5e3692058615978", "url": "https://weblate.osgeo.org/api/units/99302/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.717513Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "avg() - the average (mean) of the values in a set of records" ], "previous_source": "", "target": [ "avg() - la media de los valores de un conjunto de registros" ], "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": 99303, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=8c74b28758ca7b7e", "url": "https://weblate.osgeo.org/api/units/99303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.719102Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "sum() - the sum of the values in a set of records" ], "previous_source": "", "target": [ "sum() - suma de los valores de un conjunto de registros" ], "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": 99304, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=c90c9f8d4fa3f0ed", "url": "https://weblate.osgeo.org/api/units/99304/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.720747Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "count() - the number of records in a set of records" ], "previous_source": "", "target": [ "count() - el número de registros de un conjunto de registros" ], "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": 99306, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=f3541cf5700f1a2c", "url": "https://weblate.osgeo.org/api/units/99306/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.722419Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Now the questions:" ], "previous_source": "", "target": [ "Ahora las preguntas:" ], "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": 99307, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=a3409e2a11386a0b", "url": "https://weblate.osgeo.org/api/units/99307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.724166Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "**How many records are in the nyc_streets table?**" ], "previous_source": "", "target": [ "**¿Cuántos registros hay en la tabla 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": 99308, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=9198471ae778ebbb", "url": "https://weblate.osgeo.org/api/units/99308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.725900Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "**How many streets in NYC start with ‘B’?**" ], "previous_source": "", "target": [ "**¿Cuántas calles de Nueva York empiezan por \"B\"?**" ], "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": 99309, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=3c62cff56c84e0af", "url": "https://weblate.osgeo.org/api/units/99309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.727676Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "**What is the population of the City of New York?**" ], "previous_source": "", "target": [ "**¿Cuál es la población de la ciudad de Nueva York?**" ], "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": 99310, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=60477f2c422480e3", "url": "https://weblate.osgeo.org/api/units/99310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.729393Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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": [ "¿Qué es eso de ``AS``? Puedes dar otro nombre a una tabla o columna utilizando un alias. Los alias facilitan la escritura y la lectura de las consultas. Así, en lugar de escribir el nombre de nuestra columna como ``suma``, escribiremos ``AS``, más legible ``población``." ], "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": 99311, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=637692e15bd65cec", "url": "https://weblate.osgeo.org/api/units/99311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.731065Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "**What is the population of the Bronx?**" ], "previous_source": "", "target": [ "**¿Cuál es la población del Bronx?**" ], "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": 99312, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=84059c59db774814", "url": "https://weblate.osgeo.org/api/units/99312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.732803Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "**How many \"neighborhoods\" are in each borough?**" ], "previous_source": "", "target": [ "**¿Cuántos barrios hay en cada distrito?**" ], "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": 99313, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=52bc3eeb3310a7fa", "url": "https://weblate.osgeo.org/api/units/99313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.734516Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "**For each borough, what percentage of the population is white?**" ], "previous_source": "", "target": [ "**¿Qué porcentaje de población negra hay en cada distrito?**" ], "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": 99315, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=d843a8d674ed98f5", "url": "https://weblate.osgeo.org/api/units/99315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.736166Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "Lista de funciones" ], "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": 99316, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/99316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.737796Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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(expresión) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Función de agregación de PostgreSQL que devuelve la media de una columna numérica." ], "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": 99317, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=3a2413662380a57c", "url": "https://weblate.osgeo.org/api/units/99317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.739460Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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(expresión) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Función de PostgreSQL que devuelve el número de registros en un conjunto de registros." ], "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": 99318, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=49eeb4dc908b828a", "url": "https://weblate.osgeo.org/api/units/99318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.741184Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/es/?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(expresión) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Función de PostgreSQL que devuelve la suma de los valores de un conjunto de registros." ], "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": 99319, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/es/?checksum=afbfdf9fa8f3cf02", "url": "https://weblate.osgeo.org/api/units/99319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.742905Z" } ] }