Build primary data model

We are making progress on training our AI/ML model from #42

## List of data sources that we are indexing into the database

**Our current primary dataset**: [Org data - Master List](https://docs.google.com/spreadsheets/d/1qqQvD1svf0cCRexC5LysRVmIInmZ0Ew7ctJYy9SFrjc/edit#gid=0)

## First 3 to merge

~[Nicole Kelner's Google Sheet](https://docs.google.com/spreadsheets/d/1QzarGBkRUvTSx8qu92O0d3zJ6XkblfyyMONSPUsoLgs/edit#gid=0)~

~[handpicked data in Baserow](https://baserow.io/public/grid/F9iNqpzpbOSx1mAixwYzOaozLex-fjXn2JdUtTIc8TQ)~

Climatescape - [website](https://climatescape.org/) / ~[airtable](https://airtable.com/shraY1nLoEKJ8UsNH/tblPH0ZgLZYGVEhEo)~

~Work on Climate - [Old Spreadsheet](https://docs.google.com/spreadsheets/d/12xd_rY-WJo_QDxTkD1BfxzX9P4CwWCV5tAic7ELp4fo/edit#gid=0)~

Crunchbase - _in progress_

---

**Additional sources** (not yet ranked in order of priority)

[MCJ Substack recommendations](https://myclimatejourney.substack.com/recommendations)

Net Zero Insights - [Climate Events Airtable](https://airtable.com/appk5E7qrPetNDZDZ/shrAMh9RcdtdPei4v/tblifmhfl1ljKTh0R/viwAomwDH9VdaQPN6)

Climate Events [public Notion page](https://climatekic.notion.site/876e4156d2f840c798bbd9640282c9e9?v=2e5b836b2ea54c6c8934679a140838e4)

Climate events from [PNW Climate Week's site](https://www.pnwclimateweek.org/) - bottom of the page

[Climate Tech Net](https://climatetechnet.com)

[Climate Blog list from Ben James](https://climate.benjames.io/bloggers/)

[Climate Tech Net](https://climatetechnet.com/)

ClimateU - [Resources](https://www.climateu.earth/resources), [Events](https://www.climateu.earth/events), [Directory](https://www.climateu.earth/community), etc.

Work on Climate [Notion Site](https://www.notion.so/Work-on-Climate-WoCl-Guide-c7794978a88a4931ba6bb4f0d7e4a8ad)

Climate Tech VC - [Profiles](https://www.ctvc.co/tag/profiles/) / [VCs](https://www.ctvc.co/climate-tech-vc/) / [Accelerators](https://www.ctvc.co/a-running-list-of-climate-accelerators/)

[Global Climate Landscape](https://www.globalclimatelandscape.org/) (HolonIQ)

4ward.vc - [investor Airtable](https://4ward.vc/climate-investor-overview/), [CapEx Airtable](https://airtable.com/appYjptdOqat2R1Ko/shrlPSNHi4AklAOxI/tblMbeDRb1HiAGwsh)

Sightline Climate Capital Stack - [dataset](https://platform.sightlineclimate.com/public/capital-stack)

Carbon Collective - [2023 Climate Solution Stocks](https://www.carboncollective.co/climate-change-solutions-stocks)
- Note: they have different categories and types that aren't exactly a 1:1 match of Project Drawdown, i.e. "insulation", "critical minerals", perhaps others.
- Note: these seem to update every year. They have a something else called the "[Climate Index](https://www.carboncollective.co/climate-index)", but it appears to be from 2022 and no longer up to date.

[Environment.wiki](https://environment.wiki) - list of lists

[climatehub.io](https://climatehub.io)

[climatehub.tech](https://www.climatehub.tech/)

[Climate Techies](https://climatetechies.com/) - by 4WARD.VC

[Woman and Climate Speakers database](https://www.womenandclimate.co/speaker-database)

New Energy Nexus - [portfolio](https://www.newenergynexus.com/portfolio/)

Net Zero Insights - [Resources](https://netzeroinsights.com/resources/)

[Climate Career Portal](https://www.climatecareerportal.com/) ([Iron & Earth](https://www.ironandearth.org/))

[ClimateChangeResources.org](ClimateChangeResources.org)

[Seattle Airtable](https://airtable.com/appguaSYYSPRdHFE9/tblUAjYUX0NmamqLA/viwj34tjfxOZXXKv6?blocks=hide)

Drawdown Solutions Table ([web](https://www.climatetechhandbook.com/solutions/#table-of-solutions) /[ .csv](https://github.com/climate-tech-handbook/climate-tech-handbook/blob/main/data/drawdown-solutions-table.csv))

UN Climate Technology Centre & Network - ([web](https://www.climatetechhandbook.com/technologies/) /[ .csv](https://github.com/climate-tech-handbook/climate-tech-handbook/blob/main/data/UN-ctcn_taxonomy.csv) /[ additional content](https://www.ctc-n.org/technology-sectors))

[Climate Change Angela's list](http://climatechangeela.pbworks.com/w/page/104429365/Organizations%20Focused%20on%20Climate%20Change%20Education)

[Climate Tech List](https://climatetechlist.com/)

[AI/ML & Climate Startup Directory](https://touchgrass.notion.site/AI-ML-Climate-Startup-Directory-d5237283e6da47358fa3648c73d87b1d)

MCJ's [Airtable](https://airtable.com/shrMRrJvP4Zt4EZfq) & [Climate Tech Map](https://whimsical.com/climate-tech-map-Wtu9LamabbBCcvkSZ26mMF)

[Climate Tech Distillery](https://www.climatetechdistillery.com/)

[Phyconomy](https://airtable.com/shrGYaj6CikiaXEhH/tblZFNBiWgVocM5BA/viwpawOq6LL8eHnqL?blocks=hide)

[ClimateChange.ai Directory](https://directory.climatechange.ai/)

[Speed and Scale Tracker](https://speedandscale.com/tracker/)

[Open Climate](https://openclimate.network/) / part of [Open Earth](openearth.org).

Open Door Climate - [Directory](https://www.opendoorclimate.com/directory)

[Nature Tech Database - Startups](https://airtable.com/appNHwNlUdu0kyoGa/shrBOXN6pwy2iUpQQ)
[Nature Tech Database - Investors](https://airtable.com/appNHwNlUdu0kyoGa/shrbO66cxdTyRFmYs?)

[Climate Ingenuity](https://www.climateingenuity.com)

[Daybreak Game cards](https://daybreakgame.org/explore-cards)

[Silicon Valley Bank - “The Future of Climate Tech 2024 report”](https://www.svb.com/trends-insights/reports/future-of-climate-tech)

[Climate Papa's list](https://www.climatepapa.com/software#appendix)

[Designer Fund's list](https://www.designerfund.com/blog/climate-tech-guide-for-designers/#climate-tech-companies-by-category)

Work on Climate Starter Packs - [Website](https://workonclimate.org/starter-packs/) / [Notion list](https://workonclimate.notion.site/Starter-Packs-Community-curated-resources-52547bba557e4544bacc299d3a077795) (not sure if these two match)

MCJ Podcast [Archive](https://www.mcjcollective.com/media/podcast)

Canary Media's [work on climatetech guide](https://www.canarymedia.com/articles/clean-energy-jobs/want-to-work-in-climatetech-heres-how-to-get-started)

[Climesumer](https://www.climesumer.com)

Watershed's [reading list](https://watershed.com/reading-list)

Katie Kross's [LinkedIn Post](https://www.linkedin.com/feed/update/urn:li:activity:7062050126877392896/)

Goodreads.com [list of best Climate Change books](https://www.goodreads.com/list/show/39667.Best_Climate_Change_Books)

Climate Finance Podcast - [Investor List](https://www.climatefinance.xyz/investor-lists), [Slack Communities](https://www.climatefinance.xyz/climate-slack-communities), [Book list](https://www.climatefinance.xyz/books).

Local media outlets e.g. [Geekwire's coverage in Seattle](https://www.geekwire.com/sustainability/)

---

**Other interesting sources**

- [Climate Dossier](https://docs.google.com/document/d/1aeUx5CG40p9LO1LBOl4bq37ksw7vcJQCibNuS4y_pIo/edit)
- [Open Sustainable Technology](https://opensustain.tech/) (more useful for deeper tech projects)
- [Nature Tech Taxonomy Framework](https://www.naturetechcollective.org/stories/nature-tech-taxonomy-framework?utm_source=substack&utm_medium=email) via Nature Tech Collective
- [Our World in Data](ourworldindata.org)
- [Gapminder](gapminder.org)

---

Google News URL & RSS example:
For the organization “One Tree Planted”
https://news.google.com/search?q=%22One%20Tree%20Planted%22&hl=en-US&gl=US&ceid=US%3Aen

https://news.google.com/rss/search?q=%22One+Tree+Planted%22&hl=en-US&gl=US&ceid=US:en

---

## Questions

- [ ] How to handle notable individuals that correlate with organizations. Separate data table?