Nonprofit Program Carbon Impact Log
This dataset logs nonprofit program activities with detailed carbon emission estimates, supporting ESG impact assessments and transparent reporting for grants and stakeholders. It enables organizations to analyze sustainability performance, track progress toward climate goals, and communicate environmental impact to funders and the public.
Sample rows
preview · 8 of 48 rows · all 23 columns| log_idinteger | data_sourcestring | carbon_emission_estimate_kgfloat | reported_to_stakeholdersboolean | location_street_addressstring | program_idinteger | program_namestring | activity_idinteger | activity_namestring | activity_typestring | activity_datedate | location_citystring | location_statestring | location_postal_codestring | location_countrystring | emission_scopestring | calculation_methodstring | grant_idinteger | stakeholder_idinteger | notesstring | esg_categorystring | created_atdatetime | updated_atdatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | manual entry | 85.4 | true | 123 Elm St | 1001 | Green Schools Initiative | 4501 | Solar Panel Installation Workshop | event | 2024-03-17 | Springfield | Illinois | 62704 | USA | Scope 2 | EPA Carbon Estimator v2.1 | 6001 | 9001 | Workshop attendance exceeded expectations. | Environmental | 2024-03-18T10:27:00 | 2024-03-18T14:45:00 |
| 2 | third-party report | 210.3 | true | 501 Main Ave | 1002 | Eco-Transport Solutions | 4502 | Community Electric Bus Launch | event | 2024-01-22 | Denver | Colorado | 80203 | USA | Scope 1 | DEFRA 2023 | 6002 | 9002 | Launch event featured local officials. | Environmental | 2024-01-22T08:00:00 | 2024-01-22T10:34:00 |
| 3 | manual entry | 16.2 | false | 89 Willow Lane | 1003 | Waste Reduction Campaign | 4503 | Office Supplies Procurement | procurement | 2024-02-14 | Boston | Massachusetts | 02110 | USA | Scope 3 | custom calculation | 6003 | blank | All products purchased were recycled. | Environmental | 2024-02-15T09:19:00 | 2024-02-15T09:20:00 |
| 4 | manual entry | 12.6 | true | 456 Oak Rd | 1001 | Green Schools Initiative | 4504 | School Outreach Presentation | outreach | 2024-04-08 | Springfield | Illinois | 62705 | USA | Scope 3 | EPA Carbon Estimator v2.1 | 6001 | 9001 | Presentation for grades 6-8. | Social | 2024-04-08T11:10:00 | 2024-04-08T12:55:00 |
| 5 | manual entry | 3.4 | false | blank | 1004 | Renewable Energy Access | 4505 | Remote Team Meeting | other | 2024-03-01 | Seattle | Washington | 98101 | USA | Scope 2 | custom calculation | blank | 9003 | Virtual meeting, minimal impact. | Governance | 2024-03-01T13:30:00 | 2024-03-01T13:31:00 |
| 6 | automated sensor | 41.2 | false | blank | 1002 | Eco-Transport Solutions | 4506 | Staff Commute Tracking | travel | 2024-01-29 | Denver | Colorado | 80205 | USA | Scope 3 | DEFRA 2023 | blank | blank | All staff used public transport. | Environmental | 2024-01-29T07:55:00 | 2024-01-29T08:20:00 |
| 7 | manual entry | 67.8 | true | 789 Pine Drive | 1005 | Healthy Forests Project | 4507 | Tree Planting Day | event | 2024-02-25 | Portland | Oregon | 97206 | USA | Scope 1 | EPA Carbon Estimator v2.1 | 6004 | 9004 | 200 trees planted by volunteers. | Environmental | 2024-02-25T09:00:00 | 2024-02-25T12:15:00 |
| 8 | manual entry | 7.9 | true | 22 Maple St | 1003 | Waste Reduction Campaign | 4508 | Plastic-Free Pledge Outreach | outreach | 2024-03-04 | Boston | Massachusetts | 02111 | USA | Scope 3 | custom calculation | blank | blank | Community awareness session. | Social | 2024-03-04T10:10:00 | 2024-03-04T11:00:00 |
| 9 | third-party report | 23.5 | false | 301 River Rd | 1006 | Clean Water Access | 4509 | Water Quality Testing Procurement | procurement | 2024-02-20 | Raleigh | North Carolina | 27610 | USA | Scope 3 | DEFRA 2023 | 6005 | blank | Purchased kits from certified supplier. | Environmental | 2024-02-20T15:12:00 | 2024-02-20T16:00:00 |
| 10 | third-party report | 150.7 | true | 4101 Broadway | 1002 | Eco-Transport Solutions | 4510 | Hybrid Vehicle Procurement | procurement | 2024-03-14 | Denver | Colorado | 80216 | USA | Scope 3 | DEFRA 2023 | 6002 | 9002 | Fleet expanded with 2 hybrid vehicles. | Environmental | 2024-03-14T09:45:00 | 2024-03-14T11:00:00 |
| 11 | manual entry | 19.3 | true | 110 Garden Way | 1007 | Sustainable Food Access | 4511 | Farmers Market Outreach | outreach | 2024-04-02 | Austin | Texas | 78702 | USA | Scope 1 | EPA Carbon Estimator v2.1 | blank | 9005 | Information booth set up for local shoppers. | Social | 2024-04-02T08:30:00 | 2024-04-02T09:45:00 |
| 12 | manual entry | 10.2 | false | 789 Pine Drive | 1005 | Healthy Forests Project | 4512 | Volunteer Training | event | 2024-02-18 | Portland | Oregon | 97206 | USA | Scope 2 | EPA Carbon Estimator v2.1 | 6004 | blank | Training session for new volunteers. | Social | 2024-02-18T14:00:00 | 2024-02-18T16:10:00 |
| 13 | manual entry | 6.7 | true | 301 River Rd | 1006 | Clean Water Access | 4513 | Stakeholder Meeting | other | 2024-01-17 | Raleigh | North Carolina | 27610 | USA | Scope 2 | custom calculation | blank | 9006 | Quarterly update meeting. | Governance | 2024-01-17T09:00:00 | 2024-01-17T09:05:00 |
| 14 | manual entry | 29.3 | false | 110 Garden Way | 1007 | Sustainable Food Access | 4514 | Food Distribution Drive | event | 2024-02-28 | Austin | Texas | 78702 | USA | Scope 1 | EPA Carbon Estimator v2.1 | 6006 | blank | Organic produce distributed. | Social | 2024-02-28T10:00:00 | 2024-02-28T12:00:00 |
| 15 | manual entry | 10.8 | false | 123 Elm St | 1001 | Green Schools Initiative | 4515 | Parent-Teacher Meeting | other | 2024-03-06 | Springfield | Illinois | 62704 | USA | Scope 1 | EPA Carbon Estimator v2.1 | blank | 9001 | Discussed sustainable school practices. | Governance | 2024-03-06T17:00:00 | 2024-03-06T17:30:00 |
| 16 | third-party report | 180.2 | true | 300 Sun Blvd | 1004 | Renewable Energy Access | 4516 | Solar Panel Procurement | procurement | 2024-04-12 | Seattle | Washington | 98102 | USA | Scope 3 | DEFRA 2023 | 6007 | blank | Panels sourced from local vendor. | Environmental | 2024-04-12T09:10:00 | 2024-04-12T12:00:00 |
| 17 | manual entry | 5.4 | true | 501 Main Ave | 1002 | Eco-Transport Solutions | 4517 | Public Transit Promotion | outreach | 2024-01-30 | Denver | Colorado | 80203 | USA | Scope 3 | custom calculation | blank | blank | Flyer distribution downtown. | Social | 2024-01-30T11:00:00 | 2024-01-30T11:10:00 |
| 18 | automated sensor | 22.8 | false | blank | 1005 | Healthy Forests Project | 4518 | Forest Site Visit | travel | 2024-02-22 | Portland | Oregon | 97206 | USA | Scope 1 | custom calculation | 6004 | blank | Travel by hybrid vehicle. | Environmental | 2024-02-22T08:30:00 | 2024-02-22T09:15:00 |
| 19 | manual entry | 4.6 | false | 89 Willow Lane | 1003 | Waste Reduction Campaign | 4519 | Office Waste Audit | other | 2024-03-18 | Boston | Massachusetts | 02110 | USA | Scope 2 | custom calculation | blank | blank | Monthly office audit. | Governance | 2024-03-18T16:00:00 | 2024-03-18T16:10:00 |
| 20 | manual entry | 14.9 | true | 301 River Rd | 1006 | Clean Water Access | 4520 | Water Conservation Training | event | 2024-04-11 | Raleigh | North Carolina | 27610 | USA | Scope 2 | EPA Carbon Estimator v2.1 | 6005 | 9006 | Training for local families. | Social | 2024-04-11T10:00:00 | 2024-04-11T11:20:00 |
What the 48 rows show
from the 48-row sampleManual entry (data source) stands out: mean carbon_
- 54%reported_
to_ stakeholders = true - 15.0median carbon_
emission_ estimate_ kg - 3emission scopes
- 3calculation methods
- 3esg categories
- 5activity types
Median 15.0, from 1.9 to 210.3.
- string 13
- integer 5
- float 1
- date 1
- datetime 2
- boolean 1
Columns
23 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
program_name | string | Name of the nonprofit programup to 255 · 7 names | Green Schools Initiative |
activity_name | string | Descriptive name of the activity being loggedup to 255 | Remote Team Meeting |
activity_type | string | Type of activity (e.g., event, travel, procurement, outreach)event · travel · procurement · outreach · other | event |
location_street_address | string | Street address where the activity took placeup to 255 · 10 addresses · optional | 123 Elm St |
location_city | string | City where the activity took placeup to 100 · 7 cities · optional | Springfield |
location_state | string | State or province where the activity took placeup to 100 · 7 states · optional | Illinois |
location_postal_code | string | Postal code of the activity locationup to 20 · 12 codes · optional | 62704 |
location_country | string | Country where the activity took placeup to 100 · optional | USA |
emission_scope | string | Scope of emission (Scope 1: direct, Scope 2: indirect from purchased energy, Scope 3: other indirect)Scope 1 · Scope 2 · Scope 3 | Scope 2 |
calculation_method | string | Method or source used to estimate carbon emissions (e.g., DEFRA, EPA, custom calculation)up to 255 · 3 methods | DEFRA 2023 |
data_source | string | Source of activity data (manual entry, automated sensor, third-party report)up to 255 · 3 sources · optional | manual entry |
notes | string | Additional notes or comments about the activity or emission estimateup to 2,000 · optional | Monthly office audit. |
esg_category | string | Relevant ESG category for the activity (Environmental, Social, Governance)Environmental · Social · Governance · optional | Environmental |
| Numbers 6 columns | |||
log_id | integer | Unique identifier for each carbon impact log entryunique · 1 or more | 1 |
program_id | integer | Unique identifier for the nonprofit program associated with the activity1 or more | 1001 |
activity_id | integer | Unique identifier for the specific activity within the program1 or more | 4501 |
carbon_emission_estimate_kg | float | Estimated carbon emissions (in kilograms of CO2 equivalent) for the activity0 or more | 85.4 |
grant_id | integer | Identifier for the grant supporting the program/activity, if applicable1 or more · optional | 6001 |
stakeholder_id | integer | Identifier for the stakeholder associated with the activity, if applicable1 or more · optional | 9001 |
| Dates and times 3 columns | |||
activity_date | date | Date on which the activity occurred | 2024-03-17 |
created_at | datetime | Timestamp when the log entry was created | 2024-03-18T10:27:00 |
updated_at | datetime | Timestamp when the log entry was last updated | 2024-03-18T14:45:00 |
| True or false 1 column | |||
reported_to_stakeholders | boolean | Indicates whether this activity's carbon impact has been reported to stakeholdersoptional | true |
Use it for
An energy dashboard
The reported_
to_ stakeholders rate, carbon_ emission_ estimate_ kg by data_ source and a breakdown of location_ street_ address. Excel, Power BI or Tableau. Why do the 36 manual entry rows have a mean carbon_
emission_ estimate_ kg of 16.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Rows48185.4manual e…2210.3third-pa…316.2manual e…
A software demo
Believable rows with program_
id, program_ name and activity_ id to fill a screen in front of a buyer.
This dataset48 rows23 columns
Yours1,000 rows23 columnslocation_street_address: UK only
blueprint · nonprofit-program-carbon-impact-log
Behind this dataset
Same schema. As many rows as you need.
These 48 rows came out of a blueprint — 23 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 nonprofit program activity with a unique ID
- Carbon estimates are calculated using defined activity-specific emission factors
- Activity types must be mapped to standardized ESG categories
- Timestamp and location data are mandatory for each entry
- Verification status is required (e.g., self-reported, third-party verified)
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- nonprofit-program-carbon-impact-log