city

28 rows where country_id = 80

✎ 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
39 Atinsk 80 80 2020-12-23 07:12:14
49 Balaiha 80 80 2020-12-23 07:12:14
150 Dzerzinsk 80 80 2020-12-23 07:12:15
156 Elista 80 80 2020-12-23 07:12:16
225 Ivanovo 80 80 2020-12-23 07:12:16
235 Jaroslavl 80 80 2020-12-23 07:12:16
238 Jelets 80 80 2020-12-23 07:12:16
254 Kaliningrad 80 80 2020-12-23 07:12:17
259 Kamyin 80 80 2020-12-23 07:12:17
270 Kirovo-Tepetsk 80 80 2020-12-23 07:12:17
274 Kolpino 80 80 2020-12-23 07:12:17
278 Korolev 80 80 2020-12-23 07:12:17
285 Kurgan 80 80 2020-12-23 07:12:17
286 Kursk 80 80 2020-12-23 07:12:17
308 Lipetsk 80 80 2020-12-23 07:12:17
310 Ljubertsy 80 80 2020-12-23 07:12:17
320 Maikop 80 80 2020-12-23 07:12:18
343 Moscow 80 80 2020-12-23 07:12:18
352 Nabereznyje Telny 80 80 2020-12-23 07:12:18
367 Niznekamsk 80 80 2020-12-23 07:12:18
369 Novoterkassk 80 80 2020-12-23 07:12:18
408 Pjatigorsk 80 80 2020-12-23 07:12:19
466 Serpuhov 80 80 2020-12-23 07:12:19
484 Smolensk 80 80 2020-12-23 07:12:20
510 Syktyvkar 80 80 2020-12-23 07:12:20
531 Teboksary 80 80 2020-12-23 07:12:20
558 Usolje-Sibirskoje 80 80 2020-12-23 07:12:20
597 Zeleznogorsk 80 80 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)
;