Ārzemnieki ar derīgām termiņuzturēšanās atļaujām uz 2018-12-31 (foreigners holding valid temporary residence permits, by nationality and reason)

PMLP table (PDF, 6 pages) of foreigners holding valid temporary residence permits (TUA) on 2018-12-31, by nationality and reason of stay, main applicants (galv.), family members (ģim.) and both (kopā), with totals for all countries, EU/EEA and third countries and one row for the other countries with few permits ('47 valstis, TUA=<5', listed on a second sheet not included in the PDF). Three column blocks with country names repeated: pp. 1-2 spouses, parents, investor in securities/bonds (177); pp. 3-4 family reunification, work, study etc.; pp. 5-6 guardianship, alternative status, pensioners, stateless status, investor in a company (187), real estate (188), credit institution (189), others and all reasons. Investor cells: every non-zero cell by nationality (galv., ģim., kopā) and every cell of the three total rows (zeros included) are now extracted; country rows that print 0 are now stored too (value 0, METHODOLOGY decision 6). In every investor column the country rows add up to 'Kopā visas valstis', EU/EEA + third countries = all countries, and galv. + ģim. = kopā in every row. The header line's overall totals (all permits, all reasons) and the other reasons of stay are general immigration, out of scope. Rows added: 229. Zero rows added by pass extract-zeros-b: 936. With the zeros the columns still add up. Rows for status groups (Latvian stateless persons or alternative-status holders, refugees or stateless persons with another country's documents, Estonian non-citizens, etc.) are stored with category= keys (e.g. category=stateless_lva, category=refugee_arm).