3 ms·
I downloaded your consulates.sqlite3 file and opened it up in https://datasette.io/ https://datasette.io/ on my laptop - if you do the same (and run "datasette
by simonw 5y ago
I downloaded your consulates.sqlite3 file and opened it up in https://datasette.io/ https://datasette.io/ on my laptop - if you do the same (and run "datasette install datasette-vega" to get the charting plugin)
Having done that...
http://127.0.0.1:8001/consulates/backlogs?_facet=Post+Slug&_facet_size=max&Post+Slug=london&_facet=Visa+Class+Slug&Visa+Class+Slug=l1#g.mark=bar&g.x_column=Month&g.x_type=temporal&g.y_column=Issuances&g.y_type=quantitative http://127.0.0.1:8001/consulates/backlogs?_facet=Post+Slug&_...
Full page screenshot here: https://static.simonwillison.net/static/2021/consulate-backlogs.png https://static.simonwillison.net/static/2021/consulate-backl...
Shows an interesting graph where the number of L1 visa issuances in London drops from around 500 a month to 0 around March/April 2020, eventually climbing to between 19 and 65 per month in the past few months up to today.
This is a really neat dataset, congrats!