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!