Skip to content

Instantly share code, notes, and snippets.

@uffanahmed
uffanahmed / List of all states JSON.json
Last active February 22, 2020 09:30
List of all states JSON
[
{
"id": 3901,
"name": "Badakhshan",
"country_id": 1,
"country_code": "AF",
"state_code": "BDS"
},
{
"id": 3871,
@uffanahmed
uffanahmed / List of all countries JSON.json
Created February 22, 2020 09:28
List of all countries database JSON
[
{
"id": 1,
"name": "Afghanistan",
"iso3": "AFG",
"iso2": "AF",
"phone_code": "93",
"capital": "Kabul",
"currency": "AFN"
},
@uffanahmed
uffanahmed / List of all currencies along with their symbols SQL.sql
Created February 20, 2020 11:39
List of all currencies along with their symbols SQL
CREATE TABLE currencies(
symbol VARCHAR(10) NOT NULL PRIMARY KEY,
name VARCHAR(50) NOT NULL,
symbol_native VARCHAR(10) NOT NULL,
decimal_digits INTEGER NOT NULL,
rounding NUMERIC(4,2) NOT NULL,
code VARCHAR(10) NOT NULL,
name_plural VARCHAR(50) NOT NULL
);
@uffanahmed
uffanahmed / List of all currencies along with their symbols JSON.json
Last active February 20, 2020 11:34
List of all currencies along with their symbols JSON
[
{
"symbol": "$",
"name": "US Dollar",
"symbol_native": "$",
"decimal_digits": 2,
"rounding": 0,
"code": "USD",
"name_plural": "US dollars"
},