and event_type in ('Battles', 'Violence against civilians', 'Explosions/Remote violence')
and event_date > '2022-01-01'
and event_date < '2023-01-01';
aa-kk-acled
select * from events
where longitude > -2.5
and longitude < 18
and latitude < 15
and latitude > 2
and event_type in ('Battles', 'Violence against civilians', 'Explosions/Remote violence')
and event_date > '2022-01-01'
and event_date < '2023-01-01';
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.