for 3 years worth . carbonmonitor.org
Here is what it looks like for ONE DAY - 84 rows not including the header
country date sector MtCO2 per day
Brazil 01/01/2023 Domestic Aviation 0.0200738
Brazil 01/01/2023 Ground Transport 0.23143
Brazil 01/01/2023 Industry 0.238468
Brazil 01/01/2023 International Aviation 0.0138432
Brazil 01/01/2023 Power 0.0853684
Brazil 01/01/2023 Residential 0.0984519
China 01/01/2023 Domestic Aviation 0.0867145
China 01/01/2023 Ground Transport 2.16809
China 01/01/2023 Industry 12.8764
China 01/01/2023 International Aviation 0.0168365
China 01/01/2023 Power 16.9097
China 01/01/2023 Residential 3.68142
blah blah blah blah for a gazillion rows
WORLD 01/01/2023 Domestic Aviation 0.697971
WORLD 01/01/2023 Ground Transport 14.0947
WORLD 01/01/2023 Industry 28.123
WORLD 01/01/2023 International Aviation 1.3214
WORLD 01/01/2023 Power 36.7724
WORLD 01/01/2023 Residential 15.2654
They don't even bother adding the sectors up.
Anyway, I'll have to brush up on Excel database operations, which I haven't used in at least a decade, and then not very much.
Presumably, for a year of data, I could extract all records with WORLD in column A. And then simply sum up all 6*365=2190 rows of that to get a year total of WORLD, all sectors combined. (Yes, I know about =SUM(range) in Excel). Probably not difficult to do the database extraction part either, maybe later.
There's also a DSUM function in Excel that will sum up all records with a field or fields matching criteria. So I probably won't have to bother with extracting WORLD first.