Database Snapshots

Download public data as SQL, GeoJSON map layers, and relational JSON.

Week 43, 2026

October 25, 2026

Total size

82.1 MB

💾 commongrid-2026-10-25.sql.gz

36.2 MB • Gzipped plain SQL

Download

GeoJSON DATA LAYERS

🗺️ balancing-authorities

14 MB

Download

🗺️ ev-stations

2.8 MB

Download

🗺️ isos

62 B

Download

🗺️ power-plants

651.6 KB

Download

🗺️ pricing-nodes

138.8 KB

Download

🗺️ rtos

62 B

Download

🗺️ substations

2.7 MB

Download

🗺️ territories

16.9 MB

Download

🗺️ transmission-lines

1.8 MB

Download

🗺️ utilities

2.8 MB

Download

JSON DATASETS

📄 programs

30.8 KB

Download

📄 rates

4.2 MB

Download

Week 42, 2026

October 14, 2026

Total size

118.2 MB

💾 commongrid-2026-10-14.sql.gz

36.2 MB • Gzipped plain SQL

Download

GeoJSON DATA LAYERS

🗺️ balancing-authorities

14 MB

Download

🗺️ ev-stations

2.8 MB

Download

🗺️ isos

62 B

Download

🗺️ power-plants

646.1 KB

Download

🗺️ pricing-nodes

138.8 KB

Download

🗺️ rtos

62 B

Download

🗺️ substations

2.7 MB

Download

🗺️ territories

16.9 MB

Download

🗺️ transmission-lines

1.8 MB

Download

🗺️ utilities

2.8 MB

Download

JSON DATASETS

📄 programs

30.1 KB

Download

📄 rates

4.2 MB

Download

Week 39, 2026

September 25, 2026

Total size

42.5 MB

💾 commongrid-2026-09-25.sql.gz

36.1 MB • Gzipped plain SQL

Download

GeoJSON DATA LAYERS

🗺️ ev-stations

2.8 MB

Download

🗺️ power-plants

633.6 KB

Download

🗺️ pricing-nodes

136.6 KB

Download

🗺️ utilities

2.8 MB

Download

About these snapshots

  • SQL backups: Allowlisted public reference tables — utilities, territories, programs, power plants, substations, transmission lines, pricing nodes, ISOs/RTOs, balancing authorities, and more (.sql.gz). Rates are supplied separately as JSON.
  • Relational JSON: Programs and rates retain their organization, utility, and region links. They do not have intrinsic geometry; a utility boundary does not imply program or tariff eligibility.
  • GeoJSON layers: Available spatial exports appear above for each release. New snapshots include utilities, territories, charging stations, power plants, pricing nodes, transmission lines, substations, and ISO/RTO/balancing-authority boundaries where stored geometry exists. Older releases may have fewer layers.
  • Frequency: Scheduled every Sunday at 4:00 AM UTC; the date above reflects the last published snapshot
  • Retention: All snapshots are permanent; none are deleted