all_follows = (await splitgraph`
SELECT * FROM (
SELECT
display_name,
date,
followers,
'liberal' as affiliation
FROM "neumark/theverge-post-elon-twitter-follows:latest"."file_4"
WHERE date > '2022-03-28'::date AND display_name <> 'Barack Obama'
UNION
SELECT
display_name,
date,
followers,
'conservative' as affiliation
FROM "neumark/theverge-post-elon-twitter-follows:latest"."file_3"
WHERE date > '2022-03-28'::date
) a ORDER by display_name, date
`).reduce((acc, {display_name, date, followers, affiliation}) => {
acc[affiliation].push({display_name, date, followers});
return acc;
}, {conservative: [], liberal: []})