{"version":"1.0","type":"rich","title":"Efficient bulk update and insert","description":"This example demonstrates two efficient SQL patterns for bulk loading election results into a CartoDB table named `counties_results`. The `insert.sql` file shows how to add new rows using a single `INSERT INTO ... VALUES` statement with multiple tuples, while `update.sql` performs a bulk update by joining the table against a `FROM (VALUES ...)` clause, matching records on `st_usps` and `fips`. Both files contain identical county-level presidential vote percentage data, including Democratic, Republican, and other party shares, ready to be applied to a spatial database.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-5714809?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}