subdivisions

Data source: ISO

19 rows where country_code = "UY"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
UY,UY-AR* UY UY-AR* Artigas   es    
UY,UY-CA* UY UY-CA* Canelones   es    
UY,UY-CL* UY UY-CL* Cerro Largo   es    
UY,UY-CO* UY UY-CO* Colonia   es    
UY,UY-DU* UY UY-DU* Durazno   es    
UY,UY-FD* UY UY-FD* Florida   es    
UY,UY-FS* UY UY-FS* Flores   es    
UY,UY-LA* UY UY-LA* Lavalleja   es    
UY,UY-MA* UY UY-MA* Maldonado   es    
UY,UY-MO* UY UY-MO* Montevideo   es    
UY,UY-PA* UY UY-PA* Paysandú   es    
UY,UY-RN* UY UY-RN* Río Negro   es    
UY,UY-RO* UY UY-RO* Rocha   es    
UY,UY-RV* UY UY-RV* Rivera   es    
UY,UY-SA* UY UY-SA* Salto   es    
UY,UY-SJ* UY UY-SJ* San José   es    
UY,UY-SO* UY UY-SO* Soriano   es    
UY,UY-TA* UY UY-TA* Tacuarembó   es    
UY,UY-TT* UY UY-TT* Treinta y Tres   es    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE subdivisions (
    country_code text NOT NULL
    , code_31662 text NOT NULL
    , name text
    , local_variant text
    , language_code text
    , romanization_system text
    , parent_subdivision text
    , PRIMARY KEY (country_code , code_31662)
    , FOREIGN KEY (country_code) REFERENCES countries (alpha_2_code) ON DELETE CASCADE
    , FOREIGN KEY (language_code) REFERENCES languages (alpha_2_code) ON DELETE CASCADE
);