city

31 rows where country_id = 50

✎ 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
10 Akishima 50 50 2020-12-23 07:12:14
172 Fukuyama 50 50 2020-12-23 07:12:16
203 Higashiosaka 50 50 2020-12-23 07:12:16
204 Hino 50 50 2020-12-23 07:12:16
205 Hiroshima 50 50 2020-12-23 07:12:16
224 Isesaki 50 50 2020-12-23 07:12:16
226 Iwaki 50 50 2020-12-23 07:12:16
227 Iwakuni 50 50 2020-12-23 07:12:16
228 Iwatsuki 50 50 2020-12-23 07:12:16
229 Izumisano 50 50 2020-12-23 07:12:16
253 Kakamigahara 50 50 2020-12-23 07:12:17
256 Kamakura 50 50 2020-12-23 07:12:17
260 Kanazawa 50 50 2020-12-23 07:12:17
276 Koriyama 50 50 2020-12-23 07:12:17
284 Kurashiki 50 50 2020-12-23 07:12:17
287 Kuwana 50 50 2020-12-23 07:12:17
331 Matsue 50 50 2020-12-23 07:12:18
338 Miyakonojo 50 50 2020-12-23 07:12:18
355 Nagareyama 50 50 2020-12-23 07:12:18
376 Okayama 50 50 2020-12-23 07:12:18
377 Okinawa 50 50 2020-12-23 07:12:18
380 Omiya 50 50 2020-12-23 07:12:18
382 Onomichi 50 50 2020-12-23 07:12:18
386 Otsu 50 50 2020-12-23 07:12:18
440 Sagamihara 50 50 2020-12-23 07:12:19
463 Sasebo 50 50 2020-12-23 07:12:19
474 Shimonoseki 50 50 2020-12-23 07:12:19
521 Tama 50 50 2020-12-23 07:12:20
547 Tsuyama 50 50 2020-12-23 07:12:20
552 Ueda 50 50 2020-12-23 07:12:20
555 Urawa 50 50 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)
;