2022年最新数据：中国国家省市区行政区域数据库下载（Excel/SQLLite）

select e.id,e.text,d.id,d.text,c.id,c.text,b.id,b.text,a.id,a.text from (select * from data_xingzhengquyu where data_type='villagetable') as a 
join (select * from data_xingzhengquyu where data_type='towntable') as b on a.parent_id = b.id
join (select * from data_xingzhengquyu where data_type='countytable') as c on b.parent_id = c.id
join (select * from data_xingzhengquyu where data_type='citytable') as d on c.parent_id = d.id
join (select * from data_xingzhengquyu where data_type='provincetable') as e on d.parent_id = e.id

select data_type,count(1) as total from data_xingzhengquyu group by data_type;

#|data_type    |count(1)
-+-------------+--------
1|provincetable|31      
2|citytable    |342     
3|countytable  |3344    
4|towntable    |41278   

select data_type,count(1) as total from data_xingzhengquyu group by data_type;

#|data_type    |count(1)
-+-------------+--------
1|provincetable|31      
2|citytable    |342     
3|countytable  |3344    
4|towntable    |41278   
5|villagetable |618133