city

30 rows where country_id = 60

✎ 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
4 Acua 60 60 2020-12-23 07:12:14
19 Allende 60 60 2020-12-23 07:12:14
40 Atlixco 60 60 2020-12-23 07:12:14
103 Carmen 60 60 2020-12-23 07:12:15
106 Celaya 60 60 2020-12-23 07:12:15
124 Coacalco de Berriozbal 60 60 2020-12-23 07:12:15
125 Coatzacoalcos 60 60 2020-12-23 07:12:15
129 Cuauhtmoc 60 60 2020-12-23 07:12:15
130 Cuautla 60 60 2020-12-23 07:12:15
131 Cuernavaca 60 60 2020-12-23 07:12:15
154 El Fuerte 60 60 2020-12-23 07:12:16
188 Guadalajara 60 60 2020-12-23 07:12:16
202 Hidalgo 60 60 2020-12-23 07:12:16
212 Huejutla de Reyes 60 60 2020-12-23 07:12:16
213 Huixquilucan 60 60 2020-12-23 07:12:16
246 Jos Azueta 60 60 2020-12-23 07:12:17
250 Jurez 60 60 2020-12-23 07:12:17
288 La Paz 60 60 2020-12-23 07:12:17
330 Matamoros 60 60 2020-12-23 07:12:18
335 Mexicali 60 60 2020-12-23 07:12:18
341 Monclova 60 60 2020-12-23 07:12:18
365 Nezahualcyotl 60 60 2020-12-23 07:12:18
393 Pachuca de Soto 60 60 2020-12-23 07:12:18
445 Salamanca 60 60 2020-12-23 07:12:19
451 San Felipe del Progreso 60 60 2020-12-23 07:12:19
452 San Juan Bautista Tuxtepec 60 60 2020-12-23 07:12:19
541 Torren 60 60 2020-12-23 07:12:20
556 Uruapan 60 60 2020-12-23 07:12:20
563 Valle de Santiago 60 60 2020-12-23 07:12:21
595 Zapopan 60 60 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)
;