issue_comments: 1081079506

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/421#issuecomment-1081079506 https://api.github.com/repos/simonw/sqlite-utils/issues/421 1081079506 IC_kwDOCGYnMM5Ab_bS 24938923 2022-03-28T19:58:55Z 2022-03-28T20:05:57Z NONE

Sure, it is from the documentation example: Extracting columns into a separate table

``` wget "https://github.com/wri/global-power-plant-database/blob/232a6666/output_database/global_power_plant_database.csv?raw=true"

sqlite-utils insert global.db power_plants \ 'global_power_plant_database.csv?raw=true' --csv

Extract those columns:

sqlite-utils extract global.db power_plants country country_long \ --table countries \ --fk-column country_id \ --rename country_long name ```

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1180427792