governance icon indicating copy to clipboard operation
governance copied to clipboard

Add Date Executed values for executed proposals

Open jmrossy opened this issue 1 year ago • 0 comments

Through a query for proposal execution events to the governance contract, we can get the list of executed proposals (see below): https://api.celoscan.io/api?module=logs&action=getLogs&fromBlock=0&toBlock=latest&address=0xD533Ca259b330c7A88f74E000a3FaEa2d63B7972&topic0=0x712ae1383f79ac853f8d882153778e0260ef8f03b504e2866e0593e04d2b291f

To add this useful info to the CGPs, someone will need to go through them, finding the CGP these on-chain IDs map too (see governance-proposal-id field), and then add these dates in the date-executed field formatted like 2024-01-12.

[
  { proposalId: 1, date: 'Fri May 01 2020' },
  { proposalId: 2, date: 'Mon May 18 2020' },
  { proposalId: 3, date: 'Mon May 18 2020' },
  { proposalId: 4, date: 'Tue Jun 09 2020' },
  { proposalId: 6, date: 'Wed Jun 17 2020' },
  { proposalId: 7, date: 'Sun Jun 28 2020' },
  { proposalId: 8, date: 'Fri Jul 17 2020' },
  { proposalId: 9, date: 'Sat Jul 18 2020' },
  { proposalId: 12, date: 'Tue Oct 27 2020' },
  { proposalId: 13, date: 'Wed Nov 18 2020' },
  { proposalId: 14, date: 'Wed Jan 13 2021' },
  { proposalId: 15, date: 'Thu Jan 14 2021' },
  { proposalId: 16, date: 'Thu Jan 14 2021' },
  { proposalId: 17, date: 'Sat Jan 16 2021' },
  { proposalId: 18, date: 'Thu Feb 11 2021' },
  { proposalId: 19, date: 'Thu Feb 11 2021' },
  { proposalId: 20, date: 'Thu Feb 11 2021' },
  { proposalId: 21, date: 'Thu Mar 25 2021' },
  { proposalId: 22, date: 'Thu Mar 25 2021' },
  { proposalId: 23, date: 'Thu Mar 25 2021' },
  { proposalId: 24, date: 'Fri Mar 26 2021' },
  { proposalId: 25, date: 'Fri Mar 26 2021' },
  { proposalId: 26, date: 'Thu Apr 22 2021' },
  { proposalId: 27, date: 'Fri May 14 2021' },
  { proposalId: 29, date: 'Fri Jul 16 2021' },
  { proposalId: 28, date: 'Fri Jul 16 2021' },
  { proposalId: 31, date: 'Sun Jul 25 2021' },
  { proposalId: 34, date: 'Thu Sep 23 2021' },
  { proposalId: 35, date: 'Thu Sep 23 2021' },
  { proposalId: 40, date: 'Fri Oct 01 2021' },
  { proposalId: 41, date: 'Fri Oct 01 2021' },
  { proposalId: 39, date: 'Fri Oct 01 2021' },
  { proposalId: 42, date: 'Thu Oct 14 2021' },
  { proposalId: 43, date: 'Thu Nov 11 2021' },
  { proposalId: 48, date: 'Tue Dec 14 2021' },
  { proposalId: 49, date: 'Tue Dec 14 2021' },
  { proposalId: 50, date: 'Wed Dec 15 2021' },
  { proposalId: 53, date: 'Fri Mar 18 2022' },
  { proposalId: 54, date: 'Fri Mar 18 2022' },
  { proposalId: 55, date: 'Fri Mar 18 2022' },
  { proposalId: 56, date: 'Sun May 22 2022' },
  { proposalId: 57, date: 'Thu Jun 16 2022' },
  { proposalId: 60, date: 'Sun Jun 19 2022' },
  { proposalId: 61, date: 'Sun Jun 19 2022' },
  { proposalId: 63, date: 'Thu Jun 30 2022' },
  { proposalId: 66, date: 'Tue Aug 09 2022' },
  { proposalId: 67, date: 'Tue Aug 09 2022' },
  { proposalId: 68, date: 'Thu Aug 25 2022' },
  { proposalId: 69, date: 'Sun Sep 11 2022' },
  { proposalId: 71, date: 'Mon Oct 17 2022' },
  { proposalId: 77, date: 'Mon Dec 19 2022' },
  { proposalId: 80, date: 'Thu Jan 12 2023' },
  { proposalId: 83, date: 'Mon Jan 30 2023' },
  { proposalId: 85, date: 'Sat Mar 04 2023' },
  { proposalId: 86, date: 'Sun Mar 05 2023' },
  { proposalId: 91, date: 'Fri Apr 07 2023' },
  { proposalId: 88, date: 'Fri Apr 07 2023' },
  { proposalId: 89, date: 'Fri Apr 07 2023' },
  { proposalId: 96, date: 'Sat Apr 22 2023' },
  { proposalId: 101, date: 'Sat Apr 29 2023' },
  { proposalId: 103, date: 'Sun Apr 30 2023' },
  { proposalId: 102, date: 'Mon May 01 2023' },
  { proposalId: 105, date: 'Sun May 14 2023' },
  { proposalId: 107, date: 'Mon May 15 2023' },
  { proposalId: 62, date: 'Tue May 23 2023' },
  { proposalId: 111, date: 'Sun Jun 04 2023' },
  { proposalId: 115, date: 'Tue Jul 11 2023' },
  { proposalId: 116, date: 'Mon Jul 31 2023' },
  { proposalId: 117, date: 'Tue Aug 01 2023' },
  { proposalId: 119, date: 'Wed Aug 02 2023' },
  { proposalId: 120, date: 'Thu Aug 03 2023' },
  { proposalId: 121, date: 'Fri Aug 11 2023' },
  { proposalId: 123, date: 'Sat Aug 19 2023' },
  { proposalId: 127, date: 'Fri Aug 25 2023' },
  { proposalId: 130, date: 'Tue Sep 05 2023' },
  { proposalId: 132, date: 'Mon Sep 11 2023' },
  { proposalId: 133, date: 'Tue Sep 12 2023' },
  { proposalId: 134, date: 'Tue Sep 19 2023' },
  { proposalId: 135, date: 'Fri Sep 22 2023' },
  { proposalId: 136, date: 'Sat Sep 23 2023' },
  { proposalId: 137, date: 'Tue Oct 10 2023' },
  { proposalId: 138, date: 'Thu Oct 12 2023' },
  { proposalId: 139, date: 'Mon Oct 16 2023' },
  { proposalId: 140, date: 'Fri Oct 20 2023' },
  { proposalId: 142, date: 'Sun Nov 12 2023' },
  { proposalId: 143, date: 'Mon Dec 18 2023' },
  { proposalId: 144, date: 'Tue Dec 19 2023' },
  { proposalId: 145, date: 'Wed Dec 20 2023' },
  { proposalId: 147, date: 'Fri Dec 22 2023' },
  { proposalId: 150, date: 'Wed Jan 17 2024' },
  { proposalId: 151, date: 'Fri Jan 26 2024' },
  { proposalId: 157, date: 'Fri Feb 16 2024' }
]

jmrossy avatar Feb 18 '24 18:02 jmrossy