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/sv/units/?format=api
{ "count": 43, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Simple SQL Exercises" ], "previous_source": "", "target": [ "Enkla SQL-övningar" ], "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": 2340571, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=e694734ae6b06686", "url": "https://weblate.osgeo.org/api/units/2340571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.057668Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Using the ``nyc_census_blocks`` table, answer the following questions (don't peek at the answers!)." ], "previous_source": "", "target": [ "Använd tabellen ``nyc_census_blocks`` för att besvara följande frågor (titta inte på svaren!)." ], "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": 2340572, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=6192b4b105567287", "url": "https://weblate.osgeo.org/api/units/2340572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.060600Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": [ "Här är lite användbar information för att komma igång. Minns från avsnittet :ref:`Om våra data <about_data>` vår tabelldefinition ``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": 2340573, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=749fbf4ceea00005", "url": "https://weblate.osgeo.org/api/units/2340573/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.063370Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98843/?format=api", "priority": 100, "id": 2340574, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=bdd583ca965ba9fa", "url": "https://weblate.osgeo.org/api/units/2340574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.066111Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "A 15-digit code that uniquely identifies every census **block**. (\"360050001009000\")" ], "previous_source": "", "target": [ "En 15-siffrig kod som unikt identifierar varje **block** i en folkräkning. (\"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": 2340575, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=8affd4433e57ccb4", "url": "https://weblate.osgeo.org/api/units/2340575/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.068720Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98853/?format=api", "priority": 100, "id": 2340576, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=ac8274474ace6bbf", "url": "https://weblate.osgeo.org/api/units/2340576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.071572Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Total number of people in the census block" ], "previous_source": "", "target": [ "Totalt antal personer i folkbokföringsblocket" ], "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": 2340577, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=082206c5e2c9ec26", "url": "https://weblate.osgeo.org/api/units/2340577/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.074103Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98871/?format=api", "priority": 100, "id": 2340578, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=a97de1ed68615a06", "url": "https://weblate.osgeo.org/api/units/2340578/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.076729Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Number of people self-identifying as \"white\" in the block" ], "previous_source": "", "target": [ "Antal personer som identifierar sig som \"vita\" i kvarteret" ], "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": true, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98885/?format=api", "priority": 100, "id": 2340579, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=9d132e2a15c615f0", "url": "https://weblate.osgeo.org/api/units/2340579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.079443Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98891/?format=api", "priority": 100, "id": 2340580, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=bdc2e75453130d0a", "url": "https://weblate.osgeo.org/api/units/2340580/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.082181Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Number of people self-identifying as \"black\" in the block" ], "previous_source": "", "target": [ "Antal personer som identifierar sig som \"svarta\" i kvarteret" ], "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": 2340581, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=d20b16c8a621ceb1", "url": "https://weblate.osgeo.org/api/units/2340581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.084823Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98909/?format=api", "priority": 100, "id": 2340582, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=e90fbe276e1c26a6", "url": "https://weblate.osgeo.org/api/units/2340582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.087446Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Number of people self-identifying as \"native american\" in the block" ], "previous_source": "", "target": [ "Antal personer som identifierar sig som \"native american\" i kvarteret" ], "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": 2340583, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=08e81c2ed8406bbd", "url": "https://weblate.osgeo.org/api/units/2340583/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.090113Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98939/?format=api", "priority": 100, "id": 2340584, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=57dd1209a0141977", "url": "https://weblate.osgeo.org/api/units/2340584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.092519Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Number of people self-identifying as \"asias\" in the block" ], "previous_source": "", "target": [ "Antal personer som identifierar sig som \"asiater\" i blocket" ], "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": 2340585, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=00aa7c32f8b0fcd1", "url": "https://weblate.osgeo.org/api/units/2340585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.095164Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98958/?format=api", "priority": 100, "id": 2340586, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=108a699ec0094660", "url": "https://weblate.osgeo.org/api/units/2340586/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.097681Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Number of people self-identifying with other categories in the block" ], "previous_source": "", "target": [ "Antal personer som identifierar sig med andra kategorier i blocket" ], "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": 2340587, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=b165071ec6ecf78a", "url": "https://weblate.osgeo.org/api/units/2340587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.100078Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98978/?format=api", "priority": 100, "id": 2340588, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=dab333b8d0a3456f", "url": "https://weblate.osgeo.org/api/units/2340588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.102654Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Number of housing units in the block" ], "previous_source": "", "target": [ "Antal bostadsenheter i kvarteret" ], "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": 2340589, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=d236f2ab2a4a77d4", "url": "https://weblate.osgeo.org/api/units/2340589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.105091Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98986/?format=api", "priority": 100, "id": 2340590, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=d32b7829735b0105", "url": "https://weblate.osgeo.org/api/units/2340590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.107617Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Number of owner-occupied housing units in the block" ], "previous_source": "", "target": [ "Antal ägarbebodda bostadsenheter i kvarteret" ], "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": 2340591, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=682bddec00932d04", "url": "https://weblate.osgeo.org/api/units/2340591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.111095Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/99015/?format=api", "priority": 100, "id": 2340592, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=e90d049ea97619e0", "url": "https://weblate.osgeo.org/api/units/2340592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.114922Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Number of renter-occupied housing units in the block" ], "previous_source": "", "target": [ "Antal hyresgäster som bor i bostadshus i kvarteret" ], "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": 2340593, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=400617a127a66c25", "url": "https://weblate.osgeo.org/api/units/2340593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.118433Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/99031/?format=api", "priority": 100, "id": 2340594, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=5e532e55917579da", "url": "https://weblate.osgeo.org/api/units/2340594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.121195Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens" ], "previous_source": "", "target": [ "Namn på stadsdel i New York. Manhattan, 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": 2340595, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=e43b87288b5cfc11", "url": "https://weblate.osgeo.org/api/units/2340595/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.124144Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": 2340596, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=20fee8b9a8706952", "url": "https://weblate.osgeo.org/api/units/2340596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.127990Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Polygon boundary of the block" ], "previous_source": "", "target": [ "Polygongräns för blocket" ], "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": 2340597, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=3ed83ad84510c748", "url": "https://weblate.osgeo.org/api/units/2340597/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.130572Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "And, here are some common SQL aggregation functions you might find useful:" ], "previous_source": "", "target": [ "Och här är några vanliga SQL-aggregeringsfunktioner som du kan ha nytta av:" ], "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": 2340598, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=a5e3692058615978", "url": "https://weblate.osgeo.org/api/units/2340598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.133318Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "avg() - the average (mean) of the values in a set of records" ], "previous_source": "", "target": [ "avg() - genomsnittet (medelvärdet) av värdena i en uppsättning poster" ], "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": 2340599, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=8c74b28758ca7b7e", "url": "https://weblate.osgeo.org/api/units/2340599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.136008Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "sum() - the sum of the values in a set of records" ], "previous_source": "", "target": [ "sum() - summan av värdena i en uppsättning poster" ], "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": 2340600, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=c90c9f8d4fa3f0ed", "url": "https://weblate.osgeo.org/api/units/2340600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.138465Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "count() - the number of records in a set of records" ], "previous_source": "", "target": [ "count() - antalet poster i en uppsättning poster" ], "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": 2340601, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=f3541cf5700f1a2c", "url": "https://weblate.osgeo.org/api/units/2340601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.141119Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Now the questions:" ], "previous_source": "", "target": [ "Nu kommer frågorna:" ], "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": 2340602, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=a3409e2a11386a0b", "url": "https://weblate.osgeo.org/api/units/2340602/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.144386Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "**How many records are in the nyc_streets table?**" ], "previous_source": "", "target": [ "**Hur många poster finns i tabellen 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": 2340603, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=9198471ae778ebbb", "url": "https://weblate.osgeo.org/api/units/2340603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.147860Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "**How many streets in NYC start with ‘B’?**" ], "previous_source": "", "target": [ "**Hur många gator i NYC börjar med \"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": 2340604, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=3c62cff56c84e0af", "url": "https://weblate.osgeo.org/api/units/2340604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.151239Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "**What is the population of the City of New York?**" ], "previous_source": "", "target": [ "**Vad är befolkningen i staden New 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": 2340605, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=60477f2c422480e3", "url": "https://weblate.osgeo.org/api/units/2340605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.154231Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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": [ "Vad är detta \"alias\"? Du kan ge en tabell eller en kolumn ett annat namn genom att använda ett alias. Alias kan göra frågor enklare att både skriva och läsa. Så istället för att skriva ut kolumnnamnet ``sum`` skriver vi det **AS** som det mer läsbara ``population``." ], "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": 2340606, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=637692e15bd65cec", "url": "https://weblate.osgeo.org/api/units/2340606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.157386Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "**What is the population of the Bronx?**" ], "previous_source": "", "target": [ "**Vad är befolkningen i 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": 2340607, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=84059c59db774814", "url": "https://weblate.osgeo.org/api/units/2340607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.160325Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "**How many \"neighborhoods\" are in each borough?**" ], "previous_source": "", "target": [ "**Hur många \"neighborhoods\" finns det i varje stadsdel?**" ], "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": 2340608, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=52bc3eeb3310a7fa", "url": "https://weblate.osgeo.org/api/units/2340608/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.163222Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "**For each borough, what percentage of the population is white?**" ], "previous_source": "", "target": [ "**För varje stadsdel, hur stor andel av befolkningen är vit?**" ], "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": 2340609, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=d843a8d674ed98f5", "url": "https://weblate.osgeo.org/api/units/2340609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.165998Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "Funktionslista" ], "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": 2340610, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/2340610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.168928Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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 (uttryck) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL-aggregatfunktion som returnerar medelvärdet för en numerisk kolumn." ], "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": 2340611, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=3a2413662380a57c", "url": "https://weblate.osgeo.org/api/units/2340611/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.171577Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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(uttryck) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL-aggregeringsfunktion som returnerar antalet poster i en uppsättning poster." ], "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": 2340612, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=49eeb4dc908b828a", "url": "https://weblate.osgeo.org/api/units/2340612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.174224Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql_exercises/sv/?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(uttryck) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL-aggregeringsfunktion som returnerar summan av poster i en uppsättning poster." ], "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": 2340613, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql_exercises/sv/?checksum=afbfdf9fa8f3cf02", "url": "https://weblate.osgeo.org/api/units/2340613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2025-06-04T16:09:56.177302Z" } ] }