city
60 rows where country_id = 44
This data as json, xlsx, CSV (advanced)
Suggested facets: last_update, last_update (date)
| city_id ▼ | city | country_id | last_update |
|---|---|---|---|
| 8 | Adoni | 44 44 | 2020-12-23 07:12:14 |
| 9 | Ahmadnagar | 44 44 | 2020-12-23 07:12:14 |
| 18 | Allappuzha (Alleppey) | 44 44 | 2020-12-23 07:12:14 |
| 22 | Ambattur | 44 44 | 2020-12-23 07:12:14 |
| 24 | Amroha | 44 44 | 2020-12-23 07:12:14 |
| 51 | Balurghat | 44 44 | 2020-12-23 07:12:14 |
| 71 | Berhampore (Baharampur) | 44 44 | 2020-12-23 07:12:14 |
| 73 | Bhavnagar | 44 44 | 2020-12-23 07:12:14 |
| 74 | Bhilwara | 44 44 | 2020-12-23 07:12:14 |
| 75 | Bhimavaram | 44 44 | 2020-12-23 07:12:15 |
| 76 | Bhopal | 44 44 | 2020-12-23 07:12:15 |
| 77 | Bhusawal | 44 44 | 2020-12-23 07:12:15 |
| 78 | Bijapur | 44 44 | 2020-12-23 07:12:15 |
| 107 | Chandrapur | 44 44 | 2020-12-23 07:12:15 |
| 110 | Chapra | 44 44 | 2020-12-23 07:12:15 |
| 144 | Dhule (Dhulia) | 44 44 | 2020-12-23 07:12:15 |
| 164 | Etawah | 44 44 | 2020-12-23 07:12:16 |
| 169 | Firozabad | 44 44 | 2020-12-23 07:12:16 |
| 176 | Gandhinagar | 44 44 | 2020-12-23 07:12:16 |
| 191 | Gulbarga | 44 44 | 2020-12-23 07:12:16 |
| 195 | Haldia | 44 44 | 2020-12-23 07:12:16 |
| 197 | Halisahar | 44 44 | 2020-12-23 07:12:16 |
| 208 | Hoshiarpur | 44 44 | 2020-12-23 07:12:16 |
| 211 | Hubli-Dharwad | 44 44 | 2020-12-23 07:12:16 |
| 231 | Jaipur | 44 44 | 2020-12-23 07:12:16 |
| 239 | Jhansi | 44 44 | 2020-12-23 07:12:16 |
| 243 | Jodhpur | 44 44 | 2020-12-23 07:12:17 |
| 257 | Kamarhati | 44 44 | 2020-12-23 07:12:17 |
| 261 | Kanchrapara | 44 44 | 2020-12-23 07:12:17 |
| 263 | Karnal | 44 44 | 2020-12-23 07:12:17 |
| 264 | Katihar | 44 44 | 2020-12-23 07:12:17 |
| 283 | Kumbakonam | 44 44 | 2020-12-23 07:12:17 |
| 336 | Miraj | 44 44 | 2020-12-23 07:12:18 |
| 346 | Munger (Monghyr) | 44 44 | 2020-12-23 07:12:18 |
| 350 | Mysore | 44 44 | 2020-12-23 07:12:18 |
| 354 | Nagaon | 44 44 | 2020-12-23 07:12:18 |
| 395 | Palghat (Palakkad) | 44 44 | 2020-12-23 07:12:18 |
| 398 | Parbhani | 44 44 | 2020-12-23 07:12:19 |
| 399 | Pathankot | 44 44 | 2020-12-23 07:12:19 |
| 400 | Patiala | 44 44 | 2020-12-23 07:12:19 |
| 416 | Pudukkottai | 44 44 | 2020-12-23 07:12:19 |
| 417 | Pune | 44 44 | 2020-12-23 07:12:19 |
| 418 | Purnea (Purnia) | 44 44 | 2020-12-23 07:12:19 |
| 425 | Rae Bareli | 44 44 | 2020-12-23 07:12:19 |
| 426 | Rajkot | 44 44 | 2020-12-23 07:12:19 |
| 427 | Rampur | 44 44 | 2020-12-23 07:12:19 |
| 429 | Ranchi | 44 44 | 2020-12-23 07:12:19 |
| 448 | Sambhal | 44 44 | 2020-12-23 07:12:19 |
| 464 | Satna | 44 44 | 2020-12-23 07:12:19 |
| 473 | Shimoga | 44 44 | 2020-12-23 07:12:19 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) ;