city

28 rows where country_id = 15

✎ 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
21 Alvorada 15 15 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
28 Aparecida de Goinia 15 15 2020-12-23 07:12:14
30 Araatuba 15 15 2020-12-23 07:12:14
44 Bag 15 15 2020-12-23 07:12:14
66 Belm 15 15 2020-12-23 07:12:14
83 Blumenau 15 15 2020-12-23 07:12:15
84 Boa Vista 15 15 2020-12-23 07:12:15
89 Braslia 15 15 2020-12-23 07:12:15
183 Goinia 15 15 2020-12-23 07:12:16
189 Guaruj 15 15 2020-12-23 07:12:16
190 guas Lindas de Gois 15 15 2020-12-23 07:12:16
215 Ibirit 15 15 2020-12-23 07:12:16
247 Juazeiro do Norte 15 15 2020-12-23 07:12:17
248 Juiz de Fora 15 15 2020-12-23 07:12:17
317 Luzinia 15 15 2020-12-23 07:12:18
328 Maring 15 15 2020-12-23 07:12:18
410 Po 15 15 2020-12-23 07:12:19
413 Poos de Caldas 15 15 2020-12-23 07:12:19
431 Rio Claro 15 15 2020-12-23 07:12:19
456 Santa Brbara dOeste 15 15 2020-12-23 07:12:19
461 Santo Andr 15 15 2020-12-23 07:12:19
485 So Bernardo do Campo 15 15 2020-12-23 07:12:20
486 So Leopoldo 15 15 2020-12-23 07:12:20
490 Sorocaba 15 15 2020-12-23 07:12:20
569 Vila Velha 15 15 2020-12-23 07:12:21
572 Vitria de Santo Anto 15 15 2020-12-23 07:12:21

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)
;