Destination datasets

Here’s a detailed reference of datasets available for destinations:

Source Data

Contact Custom Attributes

Field name Field type Description
CONTACT_ID String The ID of the contact this custom attribute is associated with.
CUSTOM_ATTRIBUTE_NAME String The name of the custom attribute. Accepts alphanumeric characters and underscores. Contact custom attribute names have the contact. prefix, for example, contact.preferred_communication.
CUSTOM_ATTRIBUTE_TYPE String The data type of the custom attribute. One of String, Integer, Decimal, Timestamp or Boolean.
VALUE String The value of the custom attribute. Should be of the specified data type.
SOURCE String Information about the source of the current value: who updated it or where it was imported from.
CREATED_AT Timestamp The time when this custom attribute was created.
UPDATED_AT Timestamp The time when this custom attribute was updated.

Contacts

Field name Field type Description
ID String The internal ChartMogul ID of the contact object.
DATA_SOURCE_UUID String The ChartMogul UUID of the source for the customer to whom this contact belongs.
DATA_SOURCE_CUSTOMER_EXTERNAL_ID String The external ID of the customer to whom this contact belongs.
FIRST_NAME String The first name of the contact.
LAST_NAME String The last name of the contact.
TITLE String The job title of the contact.
EMAIL String The email address of the contact.
PHONE String The phone number of the contact.
LINKED_IN String The URL of the contact’s LinkedIn profile.
NOTE String Additional notes or comments about the contact.
CREATED_AT Timestamp The time when this contact was created in ChartMogul.
UPDATED_AT Timestamp The time when this contact was updated in ChartMogul.

Currency Rates

Field name Field type Description
RATE_DAY String The date of the currency exchange.
RATE Double The currency exchange rate.
CURRENCY_FROM String The currency you’re converting from.
CURRENCY_TO String The currency you’re converting to.

Custom Attributes

Field name Field type Description
CUSTOMER_UUID String The ChartMogul UUID of the customer this custom attribute is associated with.
CUSTOM_ATTRIBUTE_NAME String The name of the custom attribute. Accepts alphanumeric characters and underscores. Customer custom attribute names have the custom. prefix, for example, custom.marketing_campaign.
CUSTOM_ATTRIBUTE_TYPE String The data type of the custom attribute. One of String, Integer, Decimal, Timestamp or Boolean.
VALUE String The value of the custom attribute. Should be of the specified data type.

Customers

📘

Source customers

Source customers are tied to a particular source. Each source customer belongs to one calculated customer (a customer you see on customer lists). When customers are merged, multiple source customers become part of one calculated customer.

Field name Field type Description
ID Integer The internal ChartMogul ID of the customer object.
BILLING_CONNECTOR_ID Integer The ChartMogul UUID of the source for this customer.
CUSTOMER_ID Integer The internal ChartMogul ID of the calculated customer object this source customer belongs to.
EXTERNAL_ID String The unique external identifier for this source customer.
FULL_NAME String The name of this customer.
DESCRIPTION String Usually a company name.
EMAIL String This customer’s email address.
COUNTRY_ID Integer The country ID based on ChartMogul’s enum, provided in the table below.
STATE_ID Integer The state ID (for United States customers) based on ChartMogul’s enum, provided in the table below.
CITY String The city from the customer’s address.
ADDRESS_ZIP String The zip code from the customer’s address.
CREATED_AT Timestamp The time when this source customer was created in ChartMogul.
UPDATED_AT Timestamp The time when this source customer was updated in ChartMogul.
UUID String This field is deprecated. Identify source customers using their ID or EXTERNAL_ID.

Notes and Call Logs

Field name Field type Description
ID String The ID of the note or call log.
CUSTOMER_UUID String The ChartMogul UUID of the customer this note or call log is associated with.
AUTHOR_EMAIL String The email address of the user who created this note or call log.
TYPE String Either note or call.
TEXT String The content of the note or call log.
CALL_DURATION Integer For call logs, call duration in seconds.
CREATED_AT Timestamp The time this note or call log was created.
UPDATED_AT Timestamp The time this note or call log was updated.

Invoice Line Items

Field name Field type Description
ID Integer The internal ChartMogul ID of the invoice line item object.
EXTERNAL_ID String The unique identifier specified by you for the line item. Typically an identifier from your internal system.
TYPE String Either subscription or one_time.
TYPE_DATA JSON String Additional information about the invoice line item:
  • prorated — Specifies whether an invoice is prorated
  • proration_type — The type of proration
  • balance_transfer — Specifies whether there is balance transfer. Learn more.
AMOUNT_IN_CENTS Integer The final amount charged towards this line item, for the specified quantity and service period, after discounts, taxes and fees have been applied. Expressed in cents (or pence for GBP, etc.)
QUANTITY Integer The number of seats or licenses of the subscription being billed by this line item. Can be any non-zero integer. Defaults to 1.
DISCOUNT_CODE String If a discount has been applied to this line item, then this is an optional reference code to identify the discount.
DISCOUNT_AMOUNT_IN_CENTS Integer If any discount has been applied to this line item, then this is the discount amount in cents. Defaults to 0.
TAX_AMOUNT_IN_CENTS Integer The tax that has been applied to this line item, in cents. Defaults to 0.
SERVICE_PERIOD_START Timestamp The start date of the service period for which this subscription is being charged.
SERVICE_PERIOD_END Timestamp The end date of the service period for which this subscription is being charged.
TRANSACTION_FEES_IN_CENTS Integer The final total transaction fees paid to a billing provider and/or payment processor for this line item. Expressed in cents (or pence for GBP, etc.).
UNMAPPED_ATTRIBUTES JSON String Not used at the moment. The idea is to allow headers of any kind in the CSV file when uploading the data.
CREATED_AT Timestamp The time when this invoice line item was created in ChartMogul.
UPDATED_AT Timestamp The time when this invoice line item was updated in ChartMogul.
SUBSCRIPTION_EXTERNAL_ID String A reference identifier for the subscription in your system.
INVOICE_EXTERNAL_ID String The unique external identifier for the invoice that this invoice line item is part of.
PLAN_EXTERNAL_ID String The unique external identifier for the plan that this invoice line item is linked to.
DATA_SOURCE_UUID String The ChartMogul UUID of the source to which these invoices should be attributed.
SUBSCRIPTION_SET_EXTERNAL_ID String A reference identifier for a set of subscriptions used to group several subscriptions into one set.
TRANSACTION_FEES_CURRENCY String The three-letter currency code for transaction_fees_in_cents, e.g. USD, EUR, GBP. Refer to the full list of supported currencies.
DISCOUNT_DESCRIPTION String A short description of discount_amount_in_cents.
EVENT_ORDER Integer Used for ordering events that happen at the same time. Learn more.

Invoices

Field name Field type Description
ID String The internal ChartMogul ID of the Invoice object.
EXTERNAL_ID String The unique identifier specified by you for the invoice. Typically the invoice number in your system.
INVOICED_AT Timestamp The date when this invoice was created.
DUE_AT Timestamp The date within which this invoice must be paid.
CURRENCY String The three-letter currency code of the currency in which this invoice is being billed, e.g. USD, EUR, GBP. Refer to the full list of supported currencies.
UNMAPPED_ATTRIBUTES JSON String Not used at the moment. The idea is to allow headers of any kind in the CSV file when uploading the data.
CREATED_AT Timestamp The time when this invoice was created in ChartMogul.
UPDATED_AT Timestamp The time when this invoice was updated in ChartMogul.
DATA_SOURCE_CUSTOMER_EXTERNAL_ID String The unique identifier specified by you for the customer. Typically an identifier from your internal system.
DATA_SOURCE_UUID String The ChartMogul UUID of the source to which these invoices should be attributed.
MRR_PROCESSED_AT Timestamp This field is used internally for incremental dump processing.
STATUS Integer Enum of the statuses:
  • 0: open
  • 1: paid
  • 2: refunded
  • 3: written_off
  • 4: voided

Plans

Field name Field type Description
ID Integer The internal ChartMogul ID of the Plan object.
NAME String The name of this plan.
EXTERNAL_ID String The unique external identifier for this plan.
INTERVAL String The frequency with which a subscription for this plan is billed. For example, if you bill your customer every three months for a subscription with this plan, then interval_count would be 3 and interval would be month.
INTERVAL_COUNT Integer The number of intervals (specified by the interval_unit attribute) between subsequent billing dates.
BILLING_CONNECTOR_ID Integer The ChartMogul UUID of the source of this customer.
TITLE Integer The name you set to use in filters in ChartMogul.
UUID Integer The UUID of the plan object generated by ChartMogul.
DELETED Boolean Indicates whether this plan has been deleted. If it has, it still exists in ChartMogul but it is hidden from the UI.
CREATED_AT Timestamp The time when this plan was created in ChartMogul.
UPDATED_AT Timestamp The time when this plan was updated in ChartMogul.

Opportunities

Field name Field type Description
ID String The ID of this opportunity.
CUSTOMER_UUID String The ChartMogul UUID of the customer this opportunity is associated with.
OWNER String The email address of the user who owns this opportunity.
PIPELINE String The name of the sales pipeline this opportunity belongs to.
PIPELINE_STAGE String The pipeline stage of this opportunity.
ESTIMATED_CLOSE_DATE String The date this opportunity is expected to close.
CURRENCY String A three-letter currency code.
AMOUNT_IN_CENTS Integer The value of this opportunity in cents (or pence for GBP, etc.).
TYPE String Either recurring (for subscriptions) or one-time (for one-time deals).
WIN_LIKELIHOOD Integer An estimate (as a percentage from 0 to 100) of how likely you’ll successfully close the opportunity.
FORECAST_CATEGORY String The opportunity’s grouping based on its likelihood of closing. One of pipeline, best_case, committed, lost or won.
CREATED_AT Timestamp The time when this opportunity was created.
UPDATED_AT Timestamp The time when this opportunity was updated.

Opportunity Custom Attributes

Field name Field type Description
OPPORTUNITY_ID String The ID of the opportunity this custom attribute is associated with.
CUSTOM_ATTRIBUTE_NAME String The name of the custom attribute. Accepts alphanumeric characters and underscores. Opportunity custom attribute names have the opportunity. prefix, for example, opportunity.number_of_seats.
CUSTOM_ATTRIBUTE_TYPE String The data type of the custom attribute. One of String, Integer, Decimal, Timestamp or Boolean.
VALUE String The value of the custom attribute. Should be of the specified data type.
SOURCE String Information about the source of the current value: who updated it or where it was imported from.
CREATED_AT Timestamp The time when this custom attribute was created.
UPDATED_AT Timestamp The time when this custom attribute was updated.

Subscription Events

Field name Field type Description
ID Integer The internal ChartMogul ID of the subscription event object.
DATA_SOURCE_UUID String The ChartMogul UUID of the source.
DATA_SOURCE_CUSTOMER_EXTERNAL_ID String The unique identifier specified by you for the customer. Typically the identifier from your internal system.
SUBSCRIPTION_EXTERNAL_ID String The unique identifier for a subscription.
PLAN_EXTERNAL_ID String The unique identifier specified for the plan.
EXTERNAL_ID String The external ID of a subscription event.
EVENT_DATE Timestamp The date and time when this event was raised.
EFFECTIVE_DATE Timestamp The date and time when this event takes effect.
PAYLOAD JSON String This field stores the currency, quantity and amount for some event types.
CREATED_AT Timestamp The time when this subscription event was created in ChartMogul.
UPDATED_AT Timestamp The time when this subscription event was updated in ChartMogul.
EVENT_TYPE Integer The subscription event type. Internal ChartMogul mapping based on events from the event lists.
  • 0: subscription_start_scheduled
  • 1: subscription_start
  • 2: scheduled_subscription_start_retracted
  • 3: subscription_cancellation_scheduled
  • 4: subscription_cancelled
  • 5: scheduled_subscription_cancellation_retracted
  • 6: subscription_update_scheduled
  • 7: subscription_updated
  • 8: scheduled_subscription_update_retracted
  • 9: subscription_event_retracted

Tags

Field name Field type Description
CUSTOMER_UUID String The ChartMogul UUID of the customer this tag is associated with.
TAG String An array of tags added to the customer.

Tasks

Field name Field type Description
ID String The ID of this task.
CUSTOMER_UUID String The ChartMogul UUID of the customer this task is associated with.
ASSIGNEE String The email address of the user assigned to this task. Or, null for unassigned tasks.
DUE_DATE Timestamp The time when this task is due.
COMPLETED_AT Timestamp The time when this task was completed. Or, null for ongoing tasks.
TASK_DETAILS String The description of the task.
CREATED_AT Timestamp The time this task was created.
UPDATED_AT Timestamp The time this task was updated.

Transactions

Field name Field type Description
ID String The internal ChartMogul ID of the transaction object.
EXTERNAL_ID String The unique identifier specified by you for the transaction. Typically an identifier from your internal system.
TRANSACTED_AT Timestamp The timestamp of when the transaction was attempted.
TYPE String Either payment or refund.
RESULT String Either successful or failed depending on the result of this attempted transaction.
UNMAPPED_ATTRIBUTES JSON String Not used at the moment. The idea is to allow headers of any kind in the CSV file when uploading the data.
CREATED_AT Timestamp The time when this transaction was created in ChartMogul.
UPDATED_AT Timestamp The time when this transaction was updated in ChartMogul.
INVOICE_EXTERNAL_ID String The unique external identifier for the invoice that is connected to this transaction.
DATA_SOURCE_UUID String The ChartMogul UUID of the source of this transaction.
AMOUNT_IN_CENTS Integer The amount partially paid/refunded for this transaction.
REFUND_OPTIONS Variant The field is used internally for use cases specific to Stripe sources.
TRANSACTION_FEES_IN_CENTS Integer The transaction fees in cents for this line item if any.
TRANSACTION_FEES_CURRENCY String The transaction fee currency for this line item if any.

Data Sources

Field name Field type Description
ID Integer The internal ChartMogul ID of the source object.
CREATED_AT Timestamp The time when this source was created in ChartMogul.
UPDATED_AT Timestamp The time when this source was updated in ChartMogul.
TYPE String The type of system from which customer billing data is imported using this source. Available values:
  • BillingConnectors::ManualConnector
  • BillingConnectors::ServiceApiConnector
  • BillingConnectors::PayPalConnector
  • BillingConnectors::BraintreeConnector
  • BillingConnectors::DataPlatformConnector
  • BillingConnectors::StripeConnector
  • BillingConnectors::ImportApiConnector
  • BillingConnectors::GooglePlayConnector
  • BillingConnectors::ChargebeeConnector
  • BillingConnectors::RecurlyConnector
  • BillingConnectors::ChargifyConnector
TITLE String The name of the source as specified by you.
DELETED Boolean When this flag is set to true, it means that the source is in the process of being deleted and no new data should be processed.
UUID String The UUID of the data_source object generated by ChartMogul.

Calculated Data

Customers

📘

Calculated customers

Calculated customers are what you see on customer lists. Each calculated customer contains one or more source customers. When customers are merged, multiple source customers become part of one calculated customer.

Field name Field type Description
MRR Float The current monthly recurring revenue for this customer, expressed in cents in the currency selected for your account, as an integer. Divide by 100 to obtain the actual amount.
ARR Float The current annual run rate for this customer, also expressed in cents in the currency selected for your account, as an integer. Divide by 100 to obtain the actual amount.
PLAN_NAME String The name of the plan the customer is subscribed to. When the customer is subscribed to multiple plans, this is a pipe-separated list of plan names.
BILLING_CYCLE String The frequency with which a subscription for this plan is billed. For example, if you bill your customer every three months for a subscription with this plan, then interval_count would be 3 and interval would be month. When the customer has multiple subscriptions, this is a pipe-separated list of billing cycles.
NET_PAYMENTS Float The sum of all payments this customer has made.
COUNTRY String The country code from this customer’s address as per the ISO-3166 alpha-2 standard.
STATE String The state from this customer’s address.
CITY String The city from this customer’s address.
ADDRESS_ZIP String The zip code from this customer’s address.
SUBSCRIBER_SINCE Timestamp An RFC 3339-formatted datetime attribute indicating when the customer first started paying for a subscription.
STATUS String The status of this customer. One of New Lead, Working Lead, Qualified Lead, Unqualified Lead, Active, Past Due or Cancelled.
UUID String The UUID of the calculated customer object generated by ChartMogul.
EXTERNAL_ID String A pipe-separated list of the external IDs of all source customers associated with this calculated customer.
COMPANY_NAME String This customer’s company name.
CUSTOMERS_NAME String The name of this customer. This is a legacy field.
EMAIL String The customer’s email address. This is a legacy field.
CURRENCY String The currency of the MRR readings for this customer.
SUBSCRIPTION_QUANTITY Integer The number of subscription seats or licenses this customer has. When the customer has multiple subscriptions, this is the sum of all subscription seats or licenses.
SUBSCRIPTION_EXTERNAL_ID String The unique external identifier for the activity’s subscription on the activity date. This is usually the subscription identifier from your billing system. When the customer has multiple subscriptions, this is a pipe-separated list of IDs.
LEAD_CREATED_AT Timestamp The time when this customer was established as a lead.
DATA_SOURCE_NAME String A pipe-separated list of source names. These are the sources of all source customers associated with this calculated customer.
FREE_TRIAL_STARTED_AT Timestamp The time when this customer started a free trial of your product or service.
CUSTOMER_CREATED_AT Timestamp The time when the calculated customer was created in ChartMogul.

MRR Movements

Field name Field type Description
DATE Timestamp The time when the activity occurred.
CUSTOMER_NAME String The name of the customer associated with the activity.
MRR_MOVEMENT Integer The change in MRR as a result of the activity. May be a positive or negative number. All amounts are expressed in cents in the currency selected for your account, as an integer. Divide by 100 to obtain the actual amount.
MRR Integer The new MRR after the activity has occurred.
DESCRIPTION String A description of the activity.
MOVEMENT_TYPE String The type of the activity. One of new_biz, churn, expansion, contraction or reactivation.
CURRENCY_CODE String The code representing your account currency, e.g. USD or EUR.
BILLING_CONNECTOR_UUID String ChartMogul-generated UUID for the billing system in use.
CUSTOMER_EXTERNAL_ID String The unique external identifier for the customer who was responsible for the activity, if any.
CUSTOMER_UUID String ChartMogul-generated UUID for the customer who was responsible for the activity.
SUBSCRIPTION_EXTERNAL_ID String The unique external identifier for the activity’s subscription on the activity date. This is usually the subscription identifier from your billing system.
PLAN_EXTERNAL_ID String External identifier of the plan related to the activity.
ACTIVE_SUBSCRIPTION_QUANTITY Integer The number of seats or licenses of the subscription being billed by this line item. Can be any non-zero integer.
UUID String The UUID of the activity object generated by ChartMogul.
RANK Integer This field can help order activities with the same date value.
PREVIOUS_PLAN_EXTERNAL_ID String The external ID of the plan before a movement happened, which can help you track the plans before and after a change.

Webhooks

JSON Payload

Field name Field type Description
date String The time when the activity occurred.
type String The activity type. The value is always mrr_movement.
customer.name String The name of the customer associated with the activity.
customer.uuid String The UUID of the activity object generated by ChartMogul.
customer.email String The email address associated with this customer.
customer.status String The status of this customer. One of New Lead, Working Lead, Qualified Lead, Unqualified Lead, Active, Past Due or Cancelled.
customer.company String The customer’s company name.
customer.currency String The three-letter currency code of the currency of the customer’s MRR readings, e.g. USD, EUR, GBP. Refer to the full list of supported currencies.
customer.current_arr Integer The customer’s current ARR, expressed in cents. Divide by 100 to obtain the actual amount.
customer.current_mrr Integer The customer’s current MRR, expressed in cents. Divide by 100 to obtain the actual amount.

customer.external_id String The unique external identifier for this customer.
customer.external_ids Array of strings

An array containing the unique external identifiers of all customer records that have been merged into this customer.
customer.currency_symbol String Text representation to display the currency of the customer’s MRR readings, e.g. $ or .
customer.data_source_uuid String The ChartMogul UUID of the source of this customer.
description String The activity’s description, for example, purchased the Silver Monthly plan.
subscription.external_id String The unique identifier for the subscription associated with the activity.
movement_type String The type of the MRR movement. One of new_biz, churn, expansion, contraction or reactivation.

account_currency String The three-letter currency code of the currency associated with this ChartMogul account, e.g. USD, EUR, GBP. Refer to the full list of supported currencies.
invoice_currency String The three-letter currency code of the currency in which the invoice is billed, e.g. USD, EUR, GBP. Refer to the full list of supported currencies.
account_currency_symbol String Text representation to display the currency associated with this ChartMogul account, e.g. $ or .
invoice_currency_symbol String Text representation to display the currency in which the invoice is billed, e.g. $ or .
movement_amount_in_cent Integer The change in MRR as a result of the activity. May be a positive or negative number. All amounts are expressed in cents in the currency selected for your account, as an integer. Divide by 100 to obtain the actual amount.
mrr_movement_in_account_currency Integer The change in MRR as a result of the activity, expressed in cents in the currency associated with this ChartMogul account.
mrr_movement_in_invoice_currency Integer The change in MRR as a result of the activity, expressed in cents in the currency in which the invoice is billed.

Additional Enumerations

Country codes

ID ISO Country Name
1 AF Afghanistan
2 AL Albania
3 DZ Algeria
4 AS American Samoa
5 AD Andorra
6 AO Angola
7 AI Anguilla
8 AQ Antarctica
9 AG Antigua And Barbuda
10 AR Argentina
11 AM Armenia
12 AW Aruba
13 AU Australia
14 AT Austria
15 AZ Azerbaijan
16 BS Bahamas
17 BH Bahrain
18 BD Bangladesh
19 BB Barbados
20 BY Belarus
21 BE Belgium
22 BZ Belize
23 BJ Benin
24 BM Bermuda
25 BT Bhutan
26 BO Bolivia
27 BA Bosnia And Herzegovina
28 BW Botswana
29 BV Bouvet Island
30 BR Brazil
31 IO British Indian Ocean Territory
32 BN Brunei
33 BG Bulgaria
34 BF Burkina Faso
35 BI Burundi
36 KH Cambodia
37 CM Cameroon
38 CA Canada
39 CV Cape Verde
40 KY Cayman Islands
41 CF Central African Republic
42 TD Chad
43 CL Chile
44 CN China
45 CX Christmas Island
46 CC Cocos (keeling) Islands
47 CO Colombia
48 KM Comoros
49 CG Congo
50 CD DR Congo
51 CK Cook Islands
52 CR Costa Rica
53 CI Ivory Coast
54 HR Croatia
55 CU Cuba
56 CY Cyprus
57 CZ Czech Republic
58 DK Denmark
59 DJ Djibouti
60 DM Dominica
61 DO Dominican Republic
62 TP East Timor
63 EC Ecuador
64 EG Egypt
65 SV El Salvador
66 GQ Equatorial Guinea
67 ER Eritrea
68 EE Estonia
69 ET Ethiopia
70 FK Falkland Islands
71 FO Faroe Islands
72 FJ Fiji
73 FI Finland
74 FR France
75 GF French Guiana
76 PF French Polynesia
77 TF French Southern Territories
78 GA Gabon
79 GM Gambia
80 GE Georgia
81 DE Germany
82 GH Ghana
83 GI Gibraltar
84 GR Greece
85 GL Greenland
86 GD Grenada
87 GP Guadeloupe
88 GU Guam
89 GT Guatemala
90 GN Guinea
91 GW Guinea-bissau
92 GY Guyana
93 HT Haiti
94 HM Heard & Mcdonald Islands
95 VA Holy See (vatican City State)
96 HN Honduras
97 HK Hong Kong
98 HU Hungary
99 IS Iceland
100 IN India
101 ID Indonesia
102 IR Iran
103 IQ Iraq
104 IE Ireland
105 IL Israel
106 IT Italy
107 JM Jamaica
108 JP Japan
109 JO Jordan
110 KZ Kazakhstan
111 KE Kenya
112 KI Kiribati
113 KP North Korea
114 KR South Korea
115 KV Kosovo
116 KW Kuwait
117 KG Kyrgyzstan
118 LA Laos
119 LV Latvia
120 LB Lebanon
121 LS Lesotho
122 LR Liberia
123 LY Libya
124 LI Liechtenstein
125 LT Lithuania
126 LU Luxembourg
127 MO Macau
128 MK Macedonia
129 MG Madagascar
130 MW Malawi
131 MY Malaysia
132 MV Maldives
133 ML Mali
134 MT Malta
135 MH Marshall Islands
136 MQ Martinique
137 MR Mauritania
138 MU Mauritius
139 YT Mayotte
140 MX Mexico
141 FM Micronesia
142 MD Moldova
143 MC Monaco
144 MN Mongolia
145 MS Montserrat
146 ME Montenegro
147 MA Morocco
148 MZ Mozambique
149 MM Burma
150 NA Namibia
151 NR Nauru
152 NP Nepal
153 NL Netherlands
154 AN Netherlands Antilles
155 NC New Caledonia
156 NZ New Zealand
157 NI Nicaragua
158 NE Niger
159 NG Nigeria
160 NU Niue
161 NF Norfolk Island
162 MP Northern Mariana Islands
163 NO Norway
164 OM Oman
165 PK Pakistan
166 PW Palau
167 PS Palestine
168 PA Panama
169 PG Papua New Guinea
170 PY Paraguay
171 PE Peru
172 PH Philippines
173 PN Pitcairn
174 PL Poland
175 PT Portugal
176 PR Puerto Rico
177 QA Qatar
178 RE Reunion
179 RO Romania
180 RU Russia
181 RW Rwanda
182 SH Saint Helena
183 KN Saint Kitts And Nevis
184 LC Saint Lucia
185 PM Saint Pierre And Miquelon
186 VC Saint Vincent And The Grenadines
187 WS Samoa
188 SM San Marino
189 ST Sao Tome And Principe
190 SA Saudi Arabia
191 SN Senegal
192 RS Serbia
193 SC Seychelles
194 SL Sierra Leone
195 SG Singapore
196 SK Slovakia
197 SI Slovenia
198 SB Solomon Islands
199 SO Somalia
200 ZA South Africa
201 GS South Georgia
202 ES Spain
203 LK Sri Lanka
204 SD Sudan
205 SR Suriname
206 SJ Svalbard And Jan Mayen
207 SZ Swaziland
208 SE Sweden
209 CH Switzerland
210 SY Syria
211 TW Taiwan
212 TJ Tajikistan
213 TZ Tanzania
214 TH Thailand
215 TG Togo
216 TK Tokelau
217 TO Tonga
218 TT Trinidad And Tobago
219 TN Tunisia
220 TR Turkey
221 TM Turkmenistan
222 TC Turks And Caicos Islands
223 TV Tuvalu
224 UG Uganda
225 UA Ukraine
226 AE United Arab Emirates
227 GB United Kingdom
228 US United States
229 UM United States Minor Outlying Islands
230 UY Uruguay
231 UZ Uzbekistan
232 VU Vanuatu
233 VE Venezuela
234 VN Viet Nam
235 VG British Virgin Islands
236 VI Virgin Islands, US
238 EH Western Sahara
239 YE Yemen
240 ZM Zambia
241 ZW Zimbabwe
242 SS South Sudan
243 JE Jersey
244 GG Guernsey
245 TL Timor-Leste

State codes

ID Country ID ISO Name Abbreviation
10001 228 US-AK Alaska AK
10002 228 US-AL Alabama AL
10004 228 US-AZ Arizona AZ
10005 228 US-AR Arkansas AR
10006 228 US-CA California CA
10007 228 US-CO Colorado CO
10008 228 US-CT Connecticut CT
10009 228 US-DE Delaware DE
100010 228 US-DC "Washington, D.C." DC
100012 228 US-FL Florida FL
100013 228 US-GA Georgia GA
100015 228 US-HI Hawaii HI
100016 228 US-ID Idaho ID
100017 228 US-IL Illinois IL
100018 228 US-IN Indiana IN
100019 228 US-IA Iowa IA
100020 228 US-KS Kansas KS
100021 228 US-KY Kentucky KY
100022 228 US-LA Louisiana LA
100023 228 US-ME Maine ME
100025 228 US-MD Maryland MD
100026 228 US-MA Massachusetts MA
100027 228 US-MI Michigan MI
100028 228 US-MN Minnesota MN
100029 228 US-MS Mississippi MS
100030 228 US-MO Missouri MO
100031 228 US-MT Montana MT
100032 228 US-NE Nebraska NE
100033 228 US-NV Nevada NV
100034 228 US-NH New Hampshire NH
100035 228 US-NJ New Jersey NJ
100036 228 US-NM New Mexico NM
100037 228 US-NY New York NY
100038 228 US-NC North Carolina NC
100039 228 US-ND North Dakota ND
100041 228 US-OH Ohio OH
100042 228 US-OK Oklahoma OK
100043 228 US-OR Oregon OR
100045 228 US-PA Pennsylvania PA
100047 228 US-RI Rhode Island RI
100048 228 US-SC South Carolina SC
100049 228 US-SD South Dakota SD
100050 228 US-TN Tennessee TN
100051 228 US-TX Texas TX
100052 228 US-UT Utah UT
100053 228 US-VT Vermont VT
100055 228 US-VA Virginia VA
100056 228 US-WA Washington WA
100057 228 US-WV West Virginia WV
100058 228 US-WI Wisconsin WI
100059 228 US-WY Wyoming WY