city

14 rows where country_id = 45

✎ 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
117 Cianjur 45 45 2020-12-23 07:12:15
118 Ciomas 45 45 2020-12-23 07:12:15
119 Ciparay 45 45 2020-12-23 07:12:15
184 Gorontalo 45 45 2020-12-23 07:12:16
232 Jakarta 45 45 2020-12-23 07:12:16
301 Lhokseumawe 45 45 2020-12-23 07:12:17
318 Madiun 45 45 2020-12-23 07:12:18
396 Pangkal Pinang 45 45 2020-12-23 07:12:19
403 Pemalang 45 45 2020-12-23 07:12:19
412 Pontianak 45 45 2020-12-23 07:12:19
415 Probolinggo 45 45 2020-12-23 07:12:19
419 Purwakarta 45 45 2020-12-23 07:12:19
509 Surakarta 45 45 2020-12-23 07:12:20
532 Tegal 45 45 2020-12-23 07:12:20

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