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

PMLP table (PDF, 8 pages) of foreigners holding valid temporary residence permits (TUA) on 2018-01-01, 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 ('39valstis,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. Pages 7-8 hold only a few overflow figures of the all-reasons total column and page footers. The real-estate kopā cell of the Russia, 'Kopā visas valstis' and 'Kopā III valstis' rows is printed as '###' (column too narrow), so those three kopā values are not in the document and not stored; their galv. and ģim. values are. 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: 238. Zero rows added by pass extract-zeros-b: 949. With the zeros the columns still add up. The '###' cells are not zeros and are still not stored. 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).