city

600 rows

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update, last_update (date)

city_id ▼ city country_id last_update
1 A Corua (La Corua) 87 87 2020-12-23 07:12:14
2 Abha 82 82 2020-12-23 07:12:14
3 Abu Dhabi 101 101 2020-12-23 07:12:14
4 Acua 60 60 2020-12-23 07:12:14
5 Adana 97 97 2020-12-23 07:12:14
6 Addis Abeba 31 31 2020-12-23 07:12:14
7 Aden 107 107 2020-12-23 07:12:14
8 Adoni 44 44 2020-12-23 07:12:14
9 Ahmadnagar 44 44 2020-12-23 07:12:14
10 Akishima 50 50 2020-12-23 07:12:14
11 Akron 103 103 2020-12-23 07:12:14
12 al-Ayn 101 101 2020-12-23 07:12:14
13 al-Hawiya 82 82 2020-12-23 07:12:14
14 al-Manama 11 11 2020-12-23 07:12:14
15 al-Qadarif 89 89 2020-12-23 07:12:14
16 al-Qatif 82 82 2020-12-23 07:12:14
17 Alessandria 49 49 2020-12-23 07:12:14
18 Allappuzha (Alleppey) 44 44 2020-12-23 07:12:14
19 Allende 60 60 2020-12-23 07:12:14
20 Almirante Brown 6 6 2020-12-23 07:12:14
21 Alvorada 15 15 2020-12-23 07:12:14
22 Ambattur 44 44 2020-12-23 07:12:14
23 Amersfoort 67 67 2020-12-23 07:12:14
24 Amroha 44 44 2020-12-23 07:12:14
25 Angra dos Reis 15 15 2020-12-23 07:12:14
26 Anpolis 15 15 2020-12-23 07:12:14
27 Antofagasta 22 22 2020-12-23 07:12:14
28 Aparecida de Goinia 15 15 2020-12-23 07:12:14
29 Apeldoorn 67 67 2020-12-23 07:12:14
30 Araatuba 15 15 2020-12-23 07:12:14
31 Arak 46 46 2020-12-23 07:12:14
32 Arecibo 77 77 2020-12-23 07:12:14
33 Arlington 103 103 2020-12-23 07:12:14
34 Ashdod 48 48 2020-12-23 07:12:14
35 Ashgabat 98 98 2020-12-23 07:12:14
36 Ashqelon 48 48 2020-12-23 07:12:14
37 Asuncin 73 73 2020-12-23 07:12:14
38 Athenai 39 39 2020-12-23 07:12:14
39 Atinsk 80 80 2020-12-23 07:12:14
40 Atlixco 60 60 2020-12-23 07:12:14
41 Augusta-Richmond County 103 103 2020-12-23 07:12:14
42 Aurora 103 103 2020-12-23 07:12:14
43 Avellaneda 6 6 2020-12-23 07:12:14
44 Bag 15 15 2020-12-23 07:12:14
45 Baha Blanca 6 6 2020-12-23 07:12:14
46 Baicheng 23 23 2020-12-23 07:12:14
47 Baiyin 23 23 2020-12-23 07:12:14
48 Baku 10 10 2020-12-23 07:12:14
49 Balaiha 80 80 2020-12-23 07:12:14
50 Balikesir 97 97 2020-12-23 07:12:14

Next page

Advanced export

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

CSV options: 

CREATE TABLE city (
  city_id int NOT NULL,
  city VARCHAR(50) NOT NULL,
  country_id SMALLINT NOT NULL,
  last_update TIMESTAMP NOT NULL,
  PRIMARY KEY  (city_id),
  CONSTRAINT fk_city_country FOREIGN KEY (country_id) REFERENCES country (country_id) ON DELETE NO ACTION ON UPDATE CASCADE
);
CREATE INDEX idx_fk_country_id ON city(country_id)
;