School Recycled Materials Audit Log
This dataset provides detailed logs of recycled material usage across school facilities, enabling administrators to monitor sustainability practices, identify gaps, and report on ESG compliance. Each record includes material type, quantity, procurement details, facility information, and compliance status, supporting data-driven improvements in green initiatives.
Sample rows
preview · 8 of 110 rows · all 20 columns| audit_idinteger | procurement_methodstring | material_quantityfloat | esg_reportedboolean | auditor_namestring | school_idinteger | school_namestring | facility_typestring | facility_idinteger | audit_datedate | material_typestring | material_sourcestring | material_unitstring | compliance_statusstring | notesstring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | direct_purchase | 35.2 | true | Rachel Kim | 101 | Green Valley High School | cafeteria | 201 | 2024-03-14 | paper | purchased | kg | compliant | Bulk purchase of recycled paper. | 1201 Evergreen Ave | Springfield | IL | 62702 | USA |
| 2 | donation | 12.75 | false | David Martinez | 102 | Westside Middle School | laboratory | 302 | 2024-04-02 | glass | donated | kg | pending_review | Lab equipment glassware reused. | 45 Willow Rd | Harborview | CA | 90022 | USA |
| 3 | internal_transfer | 7.6 | true | Priya Singh | 103 | Mountain Ridge Elementary | classroom | 103 | 2024-01-29 | plastic | internal_reuse | kg | compliant | Water bottles reused for art project. | 87 Sunrise Blvd | Boulder | CO | 80301 | USA |
| 4 | internal_transfer | 22.4 | true | Amelia Chen | 104 | Riverbend Secondary School | library | 204 | 2024-02-15 | paper | internal_reuse | kg | compliant | Old textbooks recycled for crafts. | 312 Maple St | Greenville | TX | 75401 | USA |
| 5 | contract | 18.2 | false | Lucas Robinson | 105 | Sunset High School | gym | 105 | 2024-03-21 | metal | purchased | kg | non_compliant | Unused metal lockers replaced. | 500 Oak Lane | Madison | WI | 53703 | USA |
| 6 | donation | 9 | false | Sophia Green | 106 | Eastwood Elementary | office | 206 | 2024-02-05 | electronics | donated | items | pending_review | Old computers donated by PTA. | 1452 Cedar St | Riverside | OH | 45431 | USA |
| 7 | direct_purchase | 14.8 | true | Benjamin Carter | 107 | Lakeside Primary School | cafeteria | 207 | 2024-01-17 | plastic | purchased | kg | compliant | Recycled trays for lunch service. | 210 Lakeview Dr | Orlando | FL | 32803 | USA |
| 8 | internal_transfer | 24.3 | true | Rachel Kim | 101 | Green Valley High School | classroom | 101 | 2024-03-10 | paper | internal_reuse | kg | compliant | Paper reused from student projects. | 1201 Evergreen Ave | Springfield | IL | 62702 | USA |
| 9 | donation | 10 | false | David Martinez | 102 | Westside Middle School | gym | 209 | 2024-04-05 | metal | donated | kg | pending_review | Free weights and racks donated. | 45 Willow Rd | Harborview | CA | 90022 | USA |
| 10 | contract | 42 | true | Lucas Robinson | 105 | Sunset High School | library | 110 | 2024-03-23 | paper | purchased | kg | compliant | Recycled paper for library records. | 500 Oak Lane | Madison | WI | 53703 | USA |
| 11 | donation | 4 | false | Priya Singh | 103 | Mountain Ridge Elementary | office | 111 | 2024-01-31 | electronics | donated | items | non_compliant | Printers not recycled properly. | 87 Sunrise Blvd | Boulder | CO | 80301 | USA |
| 12 | internal_transfer | 6.3 | true | Amelia Chen | 104 | Riverbend Secondary School | laboratory | 112 | 2024-02-18 | glass | internal_reuse | kg | compliant | Beakers reused for science experiments. | 312 Maple St | Greenville | TX | 75401 | USA |
| 13 | direct_purchase | 16.7 | true | Sophia Green | 106 | Eastwood Elementary | classroom | 113 | 2024-02-08 | plastic | purchased | kg | compliant | Plastic folders for students. | 1452 Cedar St | Riverside | OH | 45431 | USA |
| 14 | donation | 8.5 | false | Benjamin Carter | 107 | Lakeside Primary School | office | 114 | 2024-01-21 | paper | donated | kg | pending_review | Community group donated paper. | 210 Lakeview Dr | Orlando | FL | 32803 | USA |
| 15 | internal_transfer | 5 | true | Rachel Kim | 101 | Green Valley High School | gym | 115 | 2024-03-17 | metal | internal_reuse | kg | compliant | Old exercise equipment recycled. | 1201 Evergreen Ave | Springfield | IL | 62702 | USA |
| 16 | contract | 19.9 | true | David Martinez | 102 | Westside Middle School | classroom | 116 | 2024-04-07 | plastic | purchased | kg | compliant | Recycled plastic chairs purchased. | 45 Willow Rd | Harborview | CA | 90022 | USA |
| 17 | donation | 2.7 | false | Priya Singh | 103 | Mountain Ridge Elementary | cafeteria | 117 | 2024-02-02 | glass | donated | kg | pending_review | Glass jars reused for food storage. | 87 Sunrise Blvd | Boulder | CO | 80301 | USA |
| 18 | internal_transfer | 3 | true | Amelia Chen | 104 | Riverbend Secondary School | office | 118 | 2024-02-21 | electronics | internal_reuse | items | compliant | Monitors reused for admin staff. | 312 Maple St | Greenville | TX | 75401 | USA |
| 19 | direct_purchase | 11.1 | true | Lucas Robinson | 105 | Sunset High School | classroom | 119 | 2024-03-25 | paper | purchased | kg | compliant | Recycled exam sheets. | 500 Oak Lane | Madison | WI | 53703 | USA |
| 20 | internal_transfer | 15 | true | Sophia Green | 106 | Eastwood Elementary | library | 120 | 2024-02-10 | glass | internal_reuse | kg | compliant | Glass shelving installed. | 1452 Cedar St | Riverside | OH | 45431 | USA |
What the 110 rows show
from the 110-row sampleContract (procurement method) stands out: mean material_
- 61%esg_
reported = true - 11.8median material_
quantity - 3compliance statuses
- 4material sources
- 4material units
- 6material types
Median 11.8, from 2.0 to 56.2.
- string 14
- integer 3
- float 1
- date 1
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
school_name | string | Official name of the school | Green Valley High School |
facility_type | string | Type of facility audited (e.g., classroom, cafeteria, gym)7 values | cafeteria |
auditor_name | string | Full name of the person conducting the audit | Rachel Kim |
material_type | string | Type of recycled material tracked (e.g., paper, plastic, metal, glass, electronics)6 values | paper |
material_source | string | Source of the recycled material (e.g., purchased, donated, internal reuse)purchased · donated · internal_reuse · other | purchased |
material_unit | string | Unit of measurement for the material quantity (e.g., kg, lbs, items)kg · lbs · items · liters · other | kg |
procurement_method | string | Method of procurement for recycled materials (e.g., direct purchase, contract, donation)5 values | direct_purchase |
compliance_status | string | Status indicating if recycled material usage complies with green initiativescompliant · non_compliant · pending_review | compliant |
notes | string | Additional comments or observations from the auditoptional | Recycled exam sheets. |
address_street | string | Street address of the school facility | 1201 Evergreen Ave |
address_city | string | City where the school facility is located | Springfield |
address_state | string | State or province of the school facility | IL |
address_postal_code | string | Postal code of the school facility | 62702 |
address_country | string | Country where the school facility is located | USA |
| Numbers 4 columns | |||
audit_id | integer | Unique identifier for each recycled materials audit recordunique · 1 or more | 1 |
school_id | integer | Unique identifier for the school where the audit is conducted1 or more | 101 |
facility_id | integer | Unique identifier for the specific facility within the school1 or more | 201 |
material_quantity | float | Quantity of recycled material used (in kilograms)0 or more | 35.2 |
| Dates and times 1 column | |||
audit_date | date | Date when the audit was performed | 2024-03-14 |
| True or false 1 column | |||
esg_reported | boolean | Indicates if this audit record has been included in ESG reporting | true |
Use it for
An education dashboard
The esg_
reported rate, material_ quantity by procurement_ method and a breakdown of auditor_ name. Excel, Power BI or Tableau. Why do the 15 contract rows have a mean material_
quantity of 24.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Rows110135.2direct_p…212.75donation37.6internal…
A software demo
Believable rows with school_
id, school_ name and facility_ type to fill a screen in front of a buyer.
blueprint · school-recycled-materials-audit-log
Behind this dataset
Same schema. As many rows as you need.
These 110 rows came out of a blueprint — 20 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.
- Each row represents a distinct material type per school per month.
- Material quantities logged must specify recycled vs. non-recycled sources.
- Include supplier details for each recycled material entry.
- Flag entries where recycled content falls below set sustainability targets.
- Record verification status for each audit entry.
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
- school-recycled-materials-audit-log