This is the whole chord progression:
C D Dsus4 D G C G E E7 E E7
Put it with the words and it sounds like this
C D Dsus4 D
Last night,
G C G E E7 E E7
I saw the fire burning on the palace door
C D Dsus4 D
O'er the land,
G C G E E7 E E7
Humble subjects watched with mixed emotion
C D Dsus4 D
Who is burning
G C Am7 E E7 E E7
Who is burning the effigy
(repeat that line again)
https://www.coveralia.com/acordes/effigy-creedence-clearwater-revival.php
And here are all the words for the song:
Last night, I saw the fire burning on the palace lawn
O'er the land, humble subjects watched with mixed emotion
Who is burning, who is burning, the effigy??
Who is burning, who is burning, effigy??
Last night, I saw the fire spreading to the palace door
Silent majority wasn't keeping quiet anymore
Who is burning, who is burning, the effigy??
Who is burning, who is burning, effigy??
Last night, I saw the fire spreading to the countryside
In the morning, few were left to watch the ashes die
Who is burning, who is burning, the effigy??
Who is burning, who is burning, effigy??
Why? Why? Why? Effigy!