Agriculture
21 columns
98 rows
8 formats

Microfarm Water Efficiency Metrics

This dataset provides granular, event-level metrics on water usage, irrigation methods, crop types, and yield outcomes for microfarms and small farm operators. It enables benchmarking of water efficiency, supports compliance with sustainability standards, and empowers precision agriculture initiatives for improved resource management and crop productivity.

last updated 1 Dec 2025
by GoMask

The brief that made it

Benchmarking water usage and irrigation efficiency across microfarms

Sample rows

preview · 8 of 98 rows · all 21 columns

microfarm_idstring	irrigation_methodstring	yield_kgfloat	sustainability_certifiedboolean	compliance_standardstring	farm_namestring	location_street_addressstring	location_citystring	location_statestring	location_postal_codestring	location_countrystring	irrigation_event_idstring	irrigation_datetimedatetime	water_volume_litersfloat	field_idstring	crop_typestring	crop_varietystring	crop_stagestring	area_irrigated_sqmfloat	yield_datedate	notesstring
MF001	drip	85.2	true	USDA Organic	Green Valley	123 Orchard Lane	Eugene	OR	97401	USA	EVT10001	2023-03-15T08:30:00	850.5	F01	lettuce	Butterhead	vegetative	120.5	2023-04-18	Optimal soil moisture maintained.
MF002	sprinkler	92	false	blank	Sunrise Acres	46 Creekside Rd	Fresno	CA	93722	USA	EVT10002	2023-03-16T09:05:00	1210	F02	tomatoes	Roma	flowering	200	2023-05-20	Mild runoff observed.
MF003	manual	blank	false	blank	Urban Roots	89 Main Street	Seattle	WA	98101	USA	EVT10003	2023-04-07T15:20:00	95.2	F03	spinach	Bloomsdale	seedling	25	blank	Hand-watering due to system maintenance.
MF004	flood	120.5	true	GlobalG.A.P.	Hilltop Farms	331 Hilltop Dr	Boulder	CO	80302	USA	EVT10004	2023-05-01T10:45:00	1700	F04	carrots	Nantes	vegetative	240	2023-06-12	Heavy rainfall prior to event.
MF005	sprinkler	78	false	blank	Prairie Patch	555 Prairie Ave	Wichita	KS	67212	USA	EVT10005	2023-04-13T07:50:00	980	F05	lettuce	Romaine	vegetative	131	2023-05-15	Short irrigation due to water-saving protocol.
MF001	drip	88.3	true	USDA Organic	Green Valley	123 Orchard Lane	Eugene	OR	97401	USA	EVT10006	2023-05-10T08:00:00	900	F01	lettuce	Butterhead	flowering	120.5	2023-06-08	Drip lines inspected prior to use.
MF006	drip	34.8	false	blank	Sunnybrook Microfarm	77 Sunnybrook Rd	Austin	TX	78704	USA	EVT10007	2023-04-19T11:10:00	505	F06	spinach	Savoy	vegetative	52	2023-05-25	blank
MF007	sprinkler	89	true	USDA Organic	Blue Sky Farm	14 Blue Sky Lane	Portland	OR	97217	USA	EVT10008	2023-05-12T09:40:00	1125	F07	tomatoes	Beefsteak	flowering	188	2023-06-20	High humidity during event.
MF008	drip	blank	false	blank	Maple Leaf Farm	202 Maple Ave	Montpelier	VT	05602	USA	EVT10009	2023-03-22T10:15:00	630.2	F08	spinach	Tyee	seedling	40	blank	Cool weather, slow growth.
MF009	manual	blank	false	blank	Red Barn Microfarm	9 Red Barn Ln	Corvallis	OR	97330	USA	EVT10010	2023-04-01T13:00:00	75	F09	lettuce	Iceberg	seedling	18	blank	Hand-watering for new transplants.
MF010	drip	28.7	false	blank	Harvest Lane	176 Harvest Ln	Madison	WI	53703	USA	EVT10011	2023-04-05T07:30:00	410	F10	spinach	Bloomsdale	vegetative	38	2023-05-12	High efficiency achieved.
MF011	flood	98	false	blank	Crescent Acres	67 Crescent Rd	Salem	OR	97301	USA	EVT10012	2023-04-18T08:40:00	1400	F11	carrots	Danvers	vegetative	200	2023-06-01	Some pooling in low spots.
MF012	sprinkler	blank	false	blank	Little Leaf Farm	21 Willow Way	Burlington	VT	05401	USA	EVT10013	2023-03-29T09:20:00	810.5	F12	lettuce	Green Leaf	vegetative	101.2	blank	Overcast, low evapotranspiration.
MF013	sprinkler	82.5	true	USDA Organic	Prairie Patch	555 Prairie Ave	Wichita	KS	67212	USA	EVT10014	2023-05-02T06:45:00	995	F13	lettuce	Romaine	flowering	136.7	2023-06-07	Harvest expected in two weeks.
MF014	drip	29.3	false	blank	Harvest Lane	176 Harvest Ln	Madison	WI	53703	USA	EVT10015	2023-05-06T08:15:00	415.6	F10	spinach	Bloomsdale	flowering	39	2023-06-07	blank
MF015	drip	25	false	blank	Maple Leaf Farm	202 Maple Ave	Montpelier	VT	05602	USA	EVT10016	2023-03-30T10:00:00	640	F14	spinach	Tyee	vegetative	41.5	2023-05-10	Irrigation lines flushed before event.
MF016	flood	105	false	blank	Sunrise Acres	46 Creekside Rd	Fresno	CA	93722	USA	EVT10017	2023-04-17T07:30:00	1610.5	F15	carrots	Imperator	vegetative	190	2023-05-27	Some soil erosion in corners.
MF017	sprinkler	blank	false	blank	Blue Sky Farm	14 Blue Sky Lane	Portland	OR	97217	USA	EVT10018	2023-04-21T09:50:00	1150	F16	tomatoes	Beefsteak	vegetative	192	blank	Windy conditions, some drift.
MF018	manual	blank	false	blank	Urban Roots	89 Main Street	Seattle	WA	98101	USA	EVT10019	2023-04-08T10:00:00	83.5	F17	spinach	Savoy	seedling	22	blank	Hand-watering new rows.
MF019	flood	blank	false	blank	Crescent Acres	67 Crescent Rd	Salem	OR	97301	USA	EVT10020	2023-04-19T08:10:00	1350	F18	carrots	Danvers	vegetative	184	blank	No pooling observed.

What the 98 rows show

from the 98-row sample

Flood (irrigation method) stands out: mean yield_kg is 129.4, against 53.0 for the rest.

35%sustainability_certified = true
62.8median yield_kg
5crop stages
6location countries
12crop types
665.1median water_volume_liters

Mean yield_kg by irrigation_method75 rows

yield_kg75 rows, in bands of 20

Median 62.8, from 7.0 to 181.3.

compliance_standard34 rows with a value · 64 left blank

USDA Organic15
GlobalG.A.P.8
Soil Association3
Freshcare3
Red Tractor2
CanadaGAP1
EU Organic1
LEAF Marque1

21 columns by typefrom the column list below

string 15
float 3
date 1
datetime 1
boolean 1

Columns

21 columns in four groups

blueprint · 21 columns
column	type	description	example
Text 15 columns
`microfarm_id`	string	Unique identifier for each microfarm or small farm operation.	MF001
`farm_name`	string	Name of the microfarm or small farm.	Green Valley
`location_street_address`	string	Street address of the microfarm.optional	123 Orchard Lane
`location_city`	string	City where the microfarm is located.optional	Eugene
`location_state`	string	State or region where the microfarm is located.optional	OR
`location_postal_code`	string	Postal code of the microfarm location.optional	97401
`location_country`	string	Country where the microfarm is located.6 countries	USA
`irrigation_event_id`	string	Unique identifier for each irrigation event.unique	EVT10001
`irrigation_method`	string	Type of irrigation method used (e.g., drip, sprinkler, flood).drip · sprinkler · flood · manual · other	drip
`field_id`	string	Unique identifier for the field or plot within the microfarm.	F01
`crop_type`	string	Type of crop being irrigated (e.g., lettuce, tomatoes, spinach).12 types	lettuce
`crop_variety`	string	Specific variety of the crop (if applicable).optional	Butterhead
`crop_stage`	string	Growth stage of the crop during irrigation (e.g., seedling, vegetative, flowering, harvest).6 values · optional	vegetative
`compliance_standard`	string	Name of the sustainability or compliance standard (e.g., GlobalG.A.P., USDA Organic).8 standards · optional	USDA Organic
`notes`	string	Additional notes or observations related to the irrigation event or crop yield.optional	Mild runoff observed.
Numbers 3 columns
`water_volume_liters`	float	Total volume of water used in the irrigation event, measured in liters.0 or more	850.5
`area_irrigated_sqm`	float	Area irrigated during the event, in square meters.0 or more	120.5
`yield_kg`	float	Yield harvested from the irrigated area, measured in kilograms.0 or more · optional	85.2
Dates and times 2 columns
`irrigation_datetime`	datetime	Date and time when the irrigation event occurred.	2023-03-15T08:30:00
`yield_date`	date	Date when the yield was measured or harvested.optional	2023-04-18
True or false 1 column
`sustainability_certified`	boolean	Indicates if the irrigation event or farm is certified under a sustainability standard.optional	true

Use it for

An agriculture dashboard
The sustainability_certified rate, yield_kg by irrigation_method and a breakdown of compliance_standard. Excel, Power BI or Tableau.
Why do the 14 flood rows have a mean yield_kg of 129.4?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Microfarms98
MF00185.2drip
MF00292sprinkler
MF004120.5flood
A software demo
Believable microfarms with farm_name, location_street_address and location_city to fill a screen in front of a buyer.

This dataset98 rows21 columns

Yours1,000 rows21 columnslocation_street_address: UK only

blueprint · microfarm-water-efficiency-metrics

Behind this dataset

Same schema. As many rows as you need.

These 98 rows came out of a blueprint — 21 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Each row represents a single microfarm for a specific month.
Includes irrigation volume, rainfall received, crop type, and crop yield.
Calculates water use efficiency ratio (yield per liter).
Flags farms exceeding regional water usage thresholds.
Records use of water-saving technology (Yes/No).

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: microfarm-water-efficiency-metrics

What should your data show?

No signup. No card.

Sample rows

What the 98 rows show

Columns

Use it for

An agriculture dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Agriculture

What should your data show?