Documentation: meters

Represents installations of on-grid or mini-grid meters at a specific customer.

To import data in this format you can use our API. -> API Documentation
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.

You can also supply us with files in xlsx, csv or json format. -> Example CSV

	Required	Type	p14n	Blurred	Autogenerated
customer_external_id ID for the specific customer associated with the meter	✓	string	⤫	⤫	⤫
device_external_id ID for the specific meter tracked by the data provider (source)	✓	string	⤫	⤫	⤫
serial_number serial number of system	✓	string	⤫	⤫	⤫
manufacturer manufacturer of system, needed to make ID when combined with serial number	✓	string	⤫	⤫	⤫
uid customer_uid + device_uid	⤫	string	⤫	⤫	✓
customer_name customer first and last name (p14)	⤫	string	✓	⤫	⤫
customer_id_number customer identification number	⤫	string	✓	⤫	⤫
customer_id_type type of customer identification	⤫	string	⤫	⤫	⤫
customer_gender Male, Female, Other, or Unknown (null)	⤫	enum: M, F, O	⤫	⤫	⤫
customer_birth_year year of purchaser birth, for demographic analysis	⤫	integer	⤫	⤫	⤫
customer_former_electricity_source e.g. none, solar, genset	⤫	string	⤫	⤫	⤫
customer_household_size number of residents of household (if residential use)	⤫	integer	⤫	⤫	⤫
customer_profession Profession of the customer - e.g. farmer or shop owner	⤫	string	⤫	⤫	⤫
customer_address customer address	⤫	string	✓	⤫	⤫
customer_country two-letter country code according to ISO 3166-1 alpha-2	⤫	string	⤫	⤫	⤫
customer_latitude customer latitude (blurred to 3 decimal points)	⤫	float	✓	✓	⤫
customer_longitude customer longitude (blurred to 3 decimal points)	⤫	float	✓	✓	⤫
customer_email customer email (p14)	⤫	string	✓	⤫	⤫
customer_phone customer telephone (p14)	⤫	string	✓	⤫	⤫
customer_phone_2 customer telephone 2 (p14)	⤫	string	✓	⤫	⤫
customer_location_area_1 customer first-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country	⤫	string	⤫	⤫	⤫
customer_location_area_2 customer second-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country	⤫	string	⤫	⤫	⤫
customer_location_area_3 customer third-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country	⤫	string	⤫	⤫	⤫
customer_location_area_4 customer fourth-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country	⤫	string	⤫	⤫	⤫
customer_location_area_5 customer fifth-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country	⤫	string	⤫	⤫	⤫
installation_date date system was installed	⤫	date	⤫	⤫	⤫
purchase_date if meter is part of an installation - date system was purchased	⤫	date	⤫	⤫	⤫
firmware_version firmware version installed on the smart meter / modem	⤫	string	⤫	⤫	⤫
model specific model of system	⤫	string	⤫	⤫	⤫
customer_category how the system is to be used: \"household\", \"institutional\", \"commercial\"	⤫	string	⤫	⤫	⤫
customer_sub_category which type of business, which institution	⤫	string	⤫	⤫	⤫
account_external_id ID for the specific account (e.g. paygo loan) associated with the meter	⤫	string	⤫	⤫	⤫
payment_plan monthly or annual payment plan - e.g. Medium Consumption or High Consumption, paygo or cash	⤫	string	⤫	⤫	⤫
payment_plan_days if meter is part of an installation with loan - repayment plan of loan	⤫	float	⤫	⤫	⤫
payment_plan_down_payment if meter is part of an installation with loan - amount paid at time of purchase	⤫	float	⤫	⤫	⤫
payment_plan_amount_financed if meter is part of an installation with loan - amount to be repaid after down payment	⤫	float	⤫	⤫	⤫
total_price Total sales price of the device	⤫	float	⤫	⤫	⤫
payment_plan_currency if meter is part of an installation with loan - currency code of payment plan, in ISO 4217 three character format	⤫	string	⤫	⤫	⤫
primary_use what type of appliance (if any) is attached? - e.g. cooking, milling, tv	⤫	string	⤫	⤫	⤫
repossession_date date system was repossessed, null if not repossessed	⤫	date	⤫	⤫	⤫
is_locked no energy coming through	⤫	boolean	⤫	⤫	⤫
max_power_w max connection max load in watts	⤫	float	⤫	⤫	⤫
is_test Is the system installed in the fiel (FALSE) or for testing purposes (TRUE)	⤫	boolean	⤫	⤫	⤫
device_uid organization_id + manufacturer + serial_number	⤫	string	⤫	⤫	✓
customer_uid organization_id + data_origin + customer_external_id	⤫	string	⤫	⤫	✓
account_uid organization_id + data_origin + account_external_id	⤫	string	⤫	⤫	✓
grid_uid organization_id + grid_name; FK from grids table	⤫	string	⤫	⤫	✓
grid_name name of the (mini-)grid the meter is connected to, typically given by operator company. Used to identifies the grid.	⤫	string	⤫	⤫	⤫
created_at Timestamp when row was inserted	⤫	datetime	⤫	⤫	✓
updated_at Timestamp when row was updated	⤫	datetime	⤫	⤫	✓
source_id References Source of data	⤫	integer	⤫	⤫	✓
import_id References Import of data	⤫	integer	⤫	⤫	✓
organization_id References Organization of data	⤫	integer	⤫	⤫	✓
custom Saves additional imported data out of standard structure	⤫	jsonb	⤫	⤫	✓
data_origin Origin of the data, generic or name of the api	⤫	string	⤫	⤫	✓
last_import_id Id of the last import which updated the record	⤫	integer	⤫	⤫	✓
last_source_id Id of the last Source which updated the record	⤫	integer	⤫	⤫	✓