Query the Data Delivery Network
Query the DDNThe easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire protocol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.
For example, you can query the data_on_food_consumption_in_zinder_and_maradi_in table in this repository, by referencing it like:
"usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-thju-5k9s:latest"."data_on_food_consumption_in_zinder_and_maradi_in"or in a full query, like:
SELECT
":id", -- Socrata column ID
"h107q_066", -- Viande de boeuf How much came from gifts other sources Quantity
"h102_048", -- Tubercule de manioc Did you eat any in the past 7 days
"h102_068", -- Viande de mouton Did you eat any in the past 7 days
"h104q_058", -- Banane douce How much came from purchases Quanity
"h104q_064", -- Noix de cola How much came from purchases Quanity
"h103u_064", -- Noix de cola How much did you eat in the past 7 days Unit
"h103q_064", -- Noix de cola How much did you eat in the past 7 days Quantity
"h106u_063", -- Ronier dourmie How much came from your own production Unit
"h103q_063", -- Ronier dourmie How much did you eat in the past 7 days Quantity
"h105_062", -- Melon How much did you spend FCFA
"h104q_062", -- Melon How much came from purchases Quanity
"h104q_061", -- Canne a sucre How much came from purchases Quanity
"h103u_061", -- Canne a sucre How much did you eat in the past 7 days Unit
"h102_047", -- Autres epices et condiments Did you eat any in the past 7 days
"h105_060", -- Dattes How much did you spend FCFA
"h107q_058", -- Banane douce How much came from gifts other sources Quantity
"h105_057", -- Aitres argrumes How much did you spend FCFA
"h103q_056", -- Orange How much did you eat in the past 7 days Quantity
"h104q_055", -- Ananas How much came from purchases Quanity
"h103q_055", -- Ananas How much did you eat in the past 7 days Quantity
"h104u_069", -- Viande de chevre How much came from purchases Unit
"h104q_069", -- Viande de chevre How much came from purchases Quanity
"h104q_068", -- Viande de mouton How much came from purchases Quanity
"h103q_068", -- Viande de mouton How much did you eat in the past 7 days Quantity
"h105_067", -- Viande de chameau How much did you spend FCFA
"h107q_061", -- Canne a sucre How much came from gifts other sources Quantity
"h107u_055", -- Ananas How much came from gifts other sources Unit
"h106q_052", -- Patate douce How much came from your own production Quantity
"h102_052", -- Patate douce Did you eat any in the past 7 days
"h107q_067", -- Viande de chameau How much came from gifts other sources Quantity
"h102_041", -- Feuilles de baobab Did you eat any in the past 7 days
"h103u_067", -- Viande de chameau How much did you eat in the past 7 days Unit
"h102_039", -- Tourteaux d arachides Did you eat any in the past 7 days
"h107q_037", -- Arachides encoque How much came from gifts other sources Quantity
"h102_050", -- Pomme de terre Did you eat any in the past 7 days
"h106q_066", -- Viande de boeuf How much came from your own production Quantity
"h103u_049", -- Tubercule d igname How much did you eat in the past 7 days Unit
"h105_054", -- Mangue How much did you spend FCFA
"h103q_054", -- Mangue How much did you eat in the past 7 days Quantity
"h104q_053", -- Autres tubercules n d a How much came from purchases Quanity
"h103u_053", -- Autres tubercules n d a How much did you eat in the past 7 days Unit
"h105_052", -- Patate douce How much did you spend FCFA
"h107q_049", -- Tubercule d igname How much came from gifts other sources Quantity
"h107q_035", -- Cube Maggi How much came from gifts other sources Quantity
"h107u_059", -- Pasteque How much came from gifts other sources Unit
"h102_067", -- Viande de chameau Did you eat any in the past 7 days
"h105_068", -- Viande de mouton How much did you spend FCFA
"h106q_045", -- Sel How much came from your own production Quantity
"h103q_044", -- Malahya Fakkou How much did you eat in the past 7 days Quantity
"h102_058", -- Banane douce Did you eat any in the past 7 days
"h102_053", -- Autres tubercules n d a Did you eat any in the past 7 days
"h103q_070", -- Volailles How much did you eat in the past 7 days Quantity
"h106u_070", -- Volailles How much came from your own production Unit
"h104u_039", -- Tourteaux d arachides How much came from purchases Unit
"h106u_062", -- Melon How much came from your own production Unit
"h106u_067", -- Viande de chameau How much came from your own production Unit
"h104q_057", -- Aitres argrumes How much came from purchases Quanity
"h103u_047", -- Autres epices et condiments How much did you eat in the past 7 days Unit
"h106u_051", -- Taro et macabo How much came from your own production Unit
"h107u_040", -- Soumbala How much came from gifts other sources Unit
"h107q_060", -- Dattes How much came from gifts other sources Quantity
"h107u_063", -- Ronier dourmie How much came from gifts other sources Unit
"h106u_050", -- Pomme de terre How much came from your own production Unit
"h107u_044", -- Malahya Fakkou How much came from gifts other sources Unit
"h106u_039", -- Tourteaux d arachides How much came from your own production Unit
"h107q_039", -- Tourteaux d arachides How much came from gifts other sources Quantity
"h106u_037", -- Arachides encoque How much came from your own production Unit
"h103u_062", -- Melon How much did you eat in the past 7 days Unit
"h104u_049", -- Tubercule d igname How much came from purchases Unit
"h107u_050", -- Pomme de terre How much came from gifts other sources Unit
"h102_069", -- Viande de chevre Did you eat any in the past 7 days
"h107u_052", -- Patate douce How much came from gifts other sources Unit
"h105_050", -- Pomme de terre How much did you spend FCFA
"h103u_058", -- Banane douce How much did you eat in the past 7 days Unit
"h106u_060", -- Dattes How much came from your own production Unit
"h103u_068", -- Viande de mouton How much did you eat in the past 7 days Unit
"h103u_055", -- Ananas How much did you eat in the past 7 days Unit
"h107q_057", -- Aitres argrumes How much came from gifts other sources Quantity
"h106u_054", -- Mangue How much came from your own production Unit
"h107q_065", -- Autres fruits n d a How much came from gifts other sources Quantity
"h107u_064", -- Noix de cola How much came from gifts other sources Unit
"h102_045", -- Sel Did you eat any in the past 7 days
"h103q_058", -- Banane douce How much did you eat in the past 7 days Quantity
"h103u_056", -- Orange How much did you eat in the past 7 days Unit
"h104q_059", -- Pasteque How much came from purchases Quanity
"h102_063", -- Ronier dourmie Did you eat any in the past 7 days
"h107q_069", -- Viande de chevre How much came from gifts other sources Quantity
"h107u_062", -- Melon How much came from gifts other sources Unit
"h104q_051", -- Taro et macabo How much came from purchases Quanity
"h105_044", -- Malahya Fakkou How much did you spend FCFA
"h107u_058", -- Banane douce How much came from gifts other sources Unit
"h103u_050", -- Pomme de terre How much did you eat in the past 7 days Unit
"h106q_037", -- Arachides encoque How much came from your own production Quantity
"h103q_052", -- Patate douce How much did you eat in the past 7 days Quantity
"h106u_047", -- Autres epices et condiments How much came from your own production Unit
"h103u_065", -- Autres fruits n d a How much did you eat in the past 7 days Unit
"h107q_055", -- Ananas How much came from gifts other sources Quantity
"h104u_055", -- Ananas How much came from purchases Unit
"h107u_054", -- Mangue How much came from gifts other sources Unit
"h106q_054", -- Mangue How much came from your own production Quantity
"h104u_054", -- Mangue How much came from purchases Unit
"h105_053", -- Autres tubercules n d a How much did you spend FCFA
"h107q_051", -- Taro et macabo How much came from gifts other sources Quantity
"h107q_050", -- Pomme de terre How much came from gifts other sources Quantity
"h104u_050", -- Pomme de terre How much came from purchases Unit
"h104q_050", -- Pomme de terre How much came from purchases Quanity
"h103q_050", -- Pomme de terre How much did you eat in the past 7 days Quantity
"h105_049", -- Tubercule d igname How much did you spend FCFA
"h103q_048", -- Tubercule de manioc How much did you eat in the past 7 days Quantity
"h107u_047", -- Autres epices et condiments How much came from gifts other sources Unit
"h107q_047", -- Autres epices et condiments How much came from gifts other sources Quantity
"h106q_047", -- Autres epices et condiments How much came from your own production Quantity
"h104q_047", -- Autres epices et condiments How much came from purchases Quanity
"h106u_046", -- Piment How much came from your own production Unit
"h107q_053", -- Autres tubercules n d a How much came from gifts other sources Quantity
"h102_046", -- Piment Did you eat any in the past 7 days
"h104q_045", -- Sel How much came from purchases Quanity
"h107u_053", -- Autres tubercules n d a How much came from gifts other sources Unit
"h104u_044", -- Malahya Fakkou How much came from purchases Unit
"h104q_044", -- Malahya Fakkou How much came from purchases Quanity
"h103u_043", -- Autres legumes en feuille How much did you eat in the past 7 days Unit
"h106u_042", -- Yodo Foye youto How much came from your own production Unit
"h106q_042", -- Yodo Foye youto How much came from your own production Quantity
"h105_042", -- Yodo Foye youto How much did you spend FCFA
"h104u_042", -- Yodo Foye youto How much came from purchases Unit
"h103u_042", -- Yodo Foye youto How much did you eat in the past 7 days Unit
"h103q_042", -- Yodo Foye youto How much did you eat in the past 7 days Quantity
"h102_042", -- Yodo Foye youto Did you eat any in the past 7 days
"h107u_041", -- Feuilles de baobab How much came from gifts other sources Unit
"h106u_041", -- Feuilles de baobab How much came from your own production Unit
"h103u_041", -- Feuilles de baobab How much did you eat in the past 7 days Unit
"h103q_041", -- Feuilles de baobab How much did you eat in the past 7 days Quantity
"h103q_039", -- Tourteaux d arachides How much did you eat in the past 7 days Quantity
"h105_038", -- Arachides decortiquees How much did you spend FCFA
"h104u_052", -- Patate douce How much came from purchases Unit
"h105_037", -- Arachides encoque How much did you spend FCFA
"h106u_058", -- Banane douce How much came from your own production Unit
"h104q_052", -- Patate douce How much came from purchases Quanity
"h103u_052", -- Patate douce How much did you eat in the past 7 days Unit
"h105_051", -- Taro et macabo How much did you spend FCFA
"h103q_051", -- Taro et macabo How much did you eat in the past 7 days Quantity
"h106q_050", -- Pomme de terre How much came from your own production Quantity
"h107u_048", -- Tubercule de manioc How much came from gifts other sources Unit
"h106u_048", -- Tubercule de manioc How much came from your own production Unit
"h102_055", -- Ananas Did you eat any in the past 7 days
"h105_048", -- Tubercule de manioc How much did you spend FCFA
"h104q_048", -- Tubercule de manioc How much came from purchases Quanity
"h102_056", -- Orange Did you eat any in the past 7 days
"h105_056", -- Orange How much did you spend FCFA
"h107u_056", -- Orange How much came from gifts other sources Unit
"h103q_057", -- Aitres argrumes How much did you eat in the past 7 days Quantity
"h104u_058", -- Banane douce How much came from purchases Unit
"h103u_060", -- Dattes How much did you eat in the past 7 days Unit
"h104q_060", -- Dattes How much came from purchases Quanity
"h106q_060", -- Dattes How much came from your own production Quantity
"h107u_060", -- Dattes How much came from gifts other sources Unit
"h103q_061", -- Canne a sucre How much did you eat in the past 7 days Quantity
"h105_061", -- Canne a sucre How much did you spend FCFA
"h102_062", -- Melon Did you eat any in the past 7 days
"h104u_062", -- Melon How much came from purchases Unit
"h107q_062", -- Melon How much came from gifts other sources Quantity
"h104u_063", -- Ronier dourmie How much came from purchases Unit
"h105_063", -- Ronier dourmie How much did you spend FCFA
"h103u_037", -- Arachides encoque How much did you eat in the past 7 days Unit
"h103q_037", -- Arachides encoque How much did you eat in the past 7 days Quantity
"h107u_036", -- Concentre de tomate How much came from gifts other sources Unit
"h106u_036", -- Concentre de tomate How much came from your own production Unit
"h106q_036", -- Concentre de tomate How much came from your own production Quantity
"h105_036", -- Concentre de tomate How much did you spend FCFA
"h103q_036", -- Concentre de tomate How much did you eat in the past 7 days Quantity
"h107u_035", -- Cube Maggi How much came from gifts other sources Unit
"id",
"h103u_059", -- Pasteque How much did you eat in the past 7 days Unit
"h106u_059", -- Pasteque How much came from your own production Unit
"h107u_067", -- Viande de chameau How much came from gifts other sources Unit
"h107u_038", -- Arachides decortiquees How much came from gifts other sources Unit
"h104u_040", -- Soumbala How much came from purchases Unit
"h107q_064", -- Noix de cola How much came from gifts other sources Quantity
"h107u_051", -- Taro et macabo How much came from gifts other sources Unit
"h103q_053", -- Autres tubercules n d a How much did you eat in the past 7 days Quantity
"h102_054", -- Mangue Did you eat any in the past 7 days
"h105_055", -- Ananas How much did you spend FCFA
"h104u_056", -- Orange How much came from purchases Unit
"h107u_046", -- Piment How much came from gifts other sources Unit
"h107q_043", -- Autres legumes en feuille How much came from gifts other sources Quantity
"h104q_056", -- Orange How much came from purchases Quanity
"h102_057", -- Aitres argrumes Did you eat any in the past 7 days
"h106q_062", -- Melon How much came from your own production Quantity
"h106q_063", -- Ronier dourmie How much came from your own production Quantity
"h103q_060", -- Dattes How much did you eat in the past 7 days Quantity
"h106u_057", -- Aitres argrumes How much came from your own production Unit
"h102_065", -- Autres fruits n d a Did you eat any in the past 7 days
"h103u_054", -- Mangue How much did you eat in the past 7 days Unit
"h105_058", -- Banane douce How much did you spend FCFA
"h106q_056", -- Orange How much came from your own production Quantity
"h102_066", -- Viande de boeuf Did you eat any in the past 7 days
"h106q_064", -- Noix de cola How much came from your own production Quantity
"h106q_059", -- Pasteque How much came from your own production Quantity
"h102_043", -- Autres legumes en feuille Did you eat any in the past 7 days
"h103q_065", -- Autres fruits n d a How much did you eat in the past 7 days Quantity
"h104u_059", -- Pasteque How much came from purchases Unit
"h103u_063", -- Ronier dourmie How much did you eat in the past 7 days Unit
"h107q_054", -- Mangue How much came from gifts other sources Quantity
"h104u_037", -- Arachides encoque How much came from purchases Unit
"h104q_067", -- Viande de chameau How much came from purchases Quanity
"h105_047", -- Autres epices et condiments How much did you spend FCFA
"h103q_047", -- Autres epices et condiments How much did you eat in the past 7 days Quantity
"h106q_046", -- Piment How much came from your own production Quantity
"h105_046", -- Piment How much did you spend FCFA
"h106q_057", -- Aitres argrumes How much came from your own production Quantity
"h107q_059", -- Pasteque How much came from gifts other sources Quantity
"h106q_055", -- Ananas How much came from your own production Quantity
"h103u_036", -- Concentre de tomate How much did you eat in the past 7 days Unit
"h104q_036", -- Concentre de tomate How much came from purchases Quanity
"h104u_036", -- Concentre de tomate How much came from purchases Unit
"h104q_037", -- Arachides encoque How much came from purchases Quanity
"h103q_038", -- Arachides decortiquees How much did you eat in the past 7 days Quantity
"h106u_038", -- Arachides decortiquees How much came from your own production Unit
"h103q_062", -- Melon How much did you eat in the past 7 days Quantity
"h106q_051", -- Taro et macabo How much came from your own production Quantity
"h106q_038", -- Arachides decortiquees How much came from your own production Quantity
"h107q_052", -- Patate douce How much came from gifts other sources Quantity
"h107u_061", -- Canne a sucre How much came from gifts other sources Unit
"h105_066", -- Viande de boeuf How much did you spend FCFA
"h102_059", -- Pasteque Did you eat any in the past 7 days
"h105_059", -- Pasteque How much did you spend FCFA
"h102_037", -- Arachides encoque Did you eat any in the past 7 days
"h102_061", -- Canne a sucre Did you eat any in the past 7 days
"h102_064", -- Noix de cola Did you eat any in the past 7 days
"h104u_061", -- Canne a sucre How much came from purchases Unit
"h102_070", -- Volailles Did you eat any in the past 7 days
"h106q_053", -- Autres tubercules n d a How much came from your own production Quantity
"h107q_038", -- Arachides decortiquees How much came from gifts other sources Quantity
"h103u_039", -- Tourteaux d arachides How much did you eat in the past 7 days Unit
"h104q_039", -- Tourteaux d arachides How much came from purchases Quanity
"h105_039", -- Tourteaux d arachides How much did you spend FCFA
"h106q_039", -- Tourteaux d arachides How much came from your own production Quantity
"h102_040", -- Soumbala Did you eat any in the past 7 days
"h103q_040", -- Soumbala How much did you eat in the past 7 days Quantity
"h103u_040", -- Soumbala How much did you eat in the past 7 days Unit
"h104q_040", -- Soumbala How much came from purchases Quanity
"h105_040", -- Soumbala How much did you spend FCFA
"h106q_040", -- Soumbala How much came from your own production Quantity
"h104u_038", -- Arachides decortiquees How much came from purchases Unit
"h104u_051", -- Taro et macabo How much came from purchases Unit
"h106q_061", -- Canne a sucre How much came from your own production Quantity
"h104u_057", -- Aitres argrumes How much came from purchases Unit
"h106u_065", -- Autres fruits n d a How much came from your own production Unit
"h106u_056", -- Orange How much came from your own production Unit
"h107q_068", -- Viande de mouton How much came from gifts other sources Quantity
"h106u_040", -- Soumbala How much came from your own production Unit
"h104q_041", -- Feuilles de baobab How much came from purchases Quanity
"h104u_041", -- Feuilles de baobab How much came from purchases Unit
"h105_041", -- Feuilles de baobab How much did you spend FCFA
"h106q_041", -- Feuilles de baobab How much came from your own production Quantity
"h107q_041", -- Feuilles de baobab How much came from gifts other sources Quantity
"h107q_042", -- Yodo Foye youto How much came from gifts other sources Quantity
"h107u_042", -- Yodo Foye youto How much came from gifts other sources Unit
"h107u_068", -- Viande de mouton How much came from gifts other sources Unit
"h107u_049", -- Tubercule d igname How much came from gifts other sources Unit
"h104u_046", -- Piment How much came from purchases Unit
"h104q_046", -- Piment How much came from purchases Quanity
"h103u_046", -- Piment How much did you eat in the past 7 days Unit
"h103q_043", -- Autres legumes en feuille How much did you eat in the past 7 days Quantity
"h104q_043", -- Autres legumes en feuille How much came from purchases Quanity
"h104u_043", -- Autres legumes en feuille How much came from purchases Unit
"h105_043", -- Autres legumes en feuille How much did you spend FCFA
"h103u_044", -- Malahya Fakkou How much did you eat in the past 7 days Unit
"h106q_044", -- Malahya Fakkou How much came from your own production Quantity
"h102_044", -- Malahya Fakkou Did you eat any in the past 7 days
"h107q_048", -- Tubercule de manioc How much came from gifts other sources Quantity
"h103u_048", -- Tubercule de manioc How much did you eat in the past 7 days Unit
"h106q_048", -- Tubercule de manioc How much came from your own production Quantity
"h106u_052", -- Patate douce How much came from your own production Unit
"h104u_065", -- Autres fruits n d a How much came from purchases Unit
"h103u_057", -- Aitres argrumes How much did you eat in the past 7 days Unit
"h104u_067", -- Viande de chameau How much came from purchases Unit
"h102_036", -- Concentre de tomate Did you eat any in the past 7 days
"h107u_043", -- Autres legumes en feuille How much came from gifts other sources Unit
"h106u_044", -- Malahya Fakkou How much came from your own production Unit
"h103q_045", -- Sel How much did you eat in the past 7 days Quantity
"h104u_045", -- Sel How much came from purchases Unit
"h105_045", -- Sel How much did you spend FCFA
"h106u_045", -- Sel How much came from your own production Unit
"h107q_045", -- Sel How much came from gifts other sources Quantity
"h107u_045", -- Sel How much came from gifts other sources Unit
"h103q_046", -- Piment How much did you eat in the past 7 days Quantity
"h106q_065", -- Autres fruits n d a How much came from your own production Quantity
"h106q_068", -- Viande de mouton How much came from your own production Quantity
"h103q_059", -- Pasteque How much did you eat in the past 7 days Quantity
"h104q_054", -- Mangue How much came from purchases Quanity
"h102_038", -- Arachides decortiquees Did you eat any in the past 7 days
"h104q_042", -- Yodo Foye youto How much came from purchases Quanity
"h106q_049", -- Tubercule d igname How much came from your own production Quantity
"h106u_055", -- Ananas How much came from your own production Unit
"h103u_069", -- Viande de chevre How much did you eat in the past 7 days Unit
"h105_070", -- Volailles How much did you spend FCFA
"h103u_038", -- Arachides decortiquees How much did you eat in the past 7 days Unit
"h103u_051", -- Taro et macabo How much did you eat in the past 7 days Unit
"h104u_060", -- Dattes How much came from purchases Unit
"h104u_048", -- Tubercule de manioc How much came from purchases Unit
"h104q_038", -- Arachides decortiquees How much came from purchases Quanity
"h107q_040", -- Soumbala How much came from gifts other sources Quantity
"h106u_049", -- Tubercule d igname How much came from your own production Unit
"h103q_049", -- Tubercule d igname How much did you eat in the past 7 days Quantity
"h102_051", -- Taro et macabo Did you eat any in the past 7 days
"h107u_039", -- Tourteaux d arachides How much came from gifts other sources Unit
"h102_049", -- Tubercule d igname Did you eat any in the past 7 days
"h106u_061", -- Canne a sucre How much came from your own production Unit
"h106u_064", -- Noix de cola How much came from your own production Unit
"h107q_046", -- Piment How much came from gifts other sources Quantity
"h104q_049", -- Tubercule d igname How much came from purchases Quanity
"h107q_056", -- Orange How much came from gifts other sources Quantity
"h107q_044", -- Malahya Fakkou How much came from gifts other sources Quantity
"h104q_066", -- Viande de boeuf How much came from purchases Quanity
"h103u_066", -- Viande de boeuf How much did you eat in the past 7 days Unit
"h103q_066", -- Viande de boeuf How much did you eat in the past 7 days Quantity
"h105_065", -- Autres fruits n d a How much did you spend FCFA
"h104q_070", -- Volailles How much came from purchases Quanity
"h106q_069", -- Viande de chevre How much came from your own production Quantity
"h104q_065", -- Autres fruits n d a How much came from purchases Quanity
"h104u_064", -- Noix de cola How much came from purchases Unit
"h106u_043", -- Autres legumes en feuille How much came from your own production Unit
"h102_060", -- Dattes Did you eat any in the past 7 days
"h106q_058", -- Banane douce How much came from your own production Quantity
"h107u_057", -- Aitres argrumes How much came from gifts other sources Unit
"h107q_063", -- Ronier dourmie How much came from gifts other sources Quantity
"h105_064", -- Noix de cola How much did you spend FCFA
"h107u_065", -- Autres fruits n d a How much came from gifts other sources Unit
"h104u_066", -- Viande de boeuf How much came from purchases Unit
"h106u_066", -- Viande de boeuf How much came from your own production Unit
"h103q_067", -- Viande de chameau How much did you eat in the past 7 days Quantity
"h106q_067", -- Viande de chameau How much came from your own production Quantity
"h104u_068", -- Viande de mouton How much came from purchases Unit
"h106u_068", -- Viande de mouton How much came from your own production Unit
"h103q_069", -- Viande de chevre How much did you eat in the past 7 days Quantity
"h105_069", -- Viande de chevre How much did you spend FCFA
"h106u_069", -- Viande de chevre How much came from your own production Unit
"h107u_069", -- Viande de chevre How much came from gifts other sources Unit
"h107u_037", -- Arachides encoque How much came from gifts other sources Unit
"h103u_045", -- Sel How much did you eat in the past 7 days Unit
"h104u_047", -- Autres epices et condiments How much came from purchases Unit
"h106u_053", -- Autres tubercules n d a How much came from your own production Unit
"h106q_043", -- Autres legumes en feuille How much came from your own production Quantity
"h104u_053", -- Autres tubercules n d a How much came from purchases Unit
"h104q_063", -- Ronier dourmie How much came from purchases Quanity
"h107q_036", -- Concentre de tomate How much came from gifts other sources Quantity
"h103u_070", -- Volailles How much did you eat in the past 7 days Unit
"h104u_070", -- Volailles How much came from purchases Unit
"h106q_070", -- Volailles How much came from your own production Quantity
"h107u_066" -- Viande de boeuf How much came from gifts other sources Unit
FROM
"usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-thju-5k9s:latest"."data_on_food_consumption_in_zinder_and_maradi_in"
LIMIT 100;Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-thju-5k9s with SQL in under 60 seconds.
This repository is an "external" repository. That means it's hosted elsewhere, in this case at data.usaid.gov. When you queryusaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-thju-5k9s:latest on the DDN, we "mount" the repository using the socrata mount handler. The mount handler proxies your SQL query to the upstream data source, translating it from SQL to the relevant language (in this case SoQL).
We also cache query responses on the DDN, but we run the DDN on multiple nodes so a CACHE_HIT is only guaranteed for subsequent queries that land on the same node.
Query Your Local Engine
Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"Read the installation docs.
Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.
It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.
There are a few ways to ingest data into the local engine.
For external repositories (like this repository), the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.
For hosted datasets, where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Mounting Data
This repository is an external repository. It's not hosted by Splitgraph. It is hosted by data.usaid.gov, and Splitgraph indexes it. This means it is not an actual Splitgraph image, so you cannot use sgr clone to get the data. Instead, you can use the socrata adapter with the sgr mount command. Then, if you want, you can import the data and turn it into a Splitgraph image that others can clone.
First, install Splitgraph if you haven't already.
Mount the table with sgr mount
sgr mount socrata \
"usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-thju-5k9s" \
--handler-options '{
"domain": "data.usaid.gov",
"tables": {
"data_on_food_consumption_in_zinder_and_maradi_in": "thju-5k9s"
}
}'That's it! Now you can query the data in the mounted table like any other Postgres table.
Query the data with your existing tools
Once you've loaded the data into your local Splitgraph engine, you can query it with any of your existing tools. As far as they're concerned, usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-thju-5k9s is just another Postgres schema.