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-778v-b68h:latest"."data_on_food_consumption_in_zinder_and_maradi_in"or in a full query, like:
SELECT
":id", -- Socrata column ID
"h103u_085", -- Oeufs How much did you eat in the past 7 days Unit
"h104u_081", -- Huille de coton How much came from purchases Unit
"h107u_100", -- Cafe en boite ou en Sachets How much came from gifts other sources Unit
"h106u_084", -- Pate d arachide How much came from your own production Unit
"h105_082", -- Huille de mais How much did you spend FCFA
"h106u_091", -- Yaourt solani How much came from your own production Unit
"h105_073", -- Autres viandes n d a How much did you spend FCFA
"h103u_104", -- Jus en poudre How much did you eat in the past 7 days Unit
"h104u_103", -- Jus de fruit How much came from purchases Unit
"h107q_095", -- Miel How much came from gifts other sources Quantity
"h107u_104", -- Jus en poudre How much came from gifts other sources Unit
"h107q_093", -- Sucre How much came from gifts other sources Quantity
"h104q_104", -- Jus en poudre How much came from purchases Quanity
"h107q_092", -- Autres produits laitiers How much came from gifts other sources Quantity
"h103q_078", -- Conserves d autres produits de peche How much did you eat in the past 7 days Quantity
"h106q_077", -- Conserves de poisson How much came from your own production Quantity
"h102_081", -- Huille de coton Did you eat any in the past 7 days
"h103u_092", -- Autres produits laitiers How much did you eat in the past 7 days Unit
"h105_095", -- Miel How much did you spend FCFA
"h107q_076", -- Poisson seche How much came from gifts other sources Quantity
"h106q_098", -- Tabac How much came from your own production Quantity
"h103u_091", -- Yaourt solani How much did you eat in the past 7 days Unit
"h107u_092", -- Autres produits laitiers How much came from gifts other sources Unit
"h107u_093", -- Sucre How much came from gifts other sources Unit
"h106u_102", -- Autres tisanes et infusions n d a How much came from your own production Unit
"h104u_105", -- Boissons gazeuses How much came from purchases Unit
"h103q_095", -- Miel How much did you eat in the past 7 days Quantity
"h107q_098", -- Tabac How much came from gifts other sources Quantity
"h103q_077", -- Conserves de poisson How much did you eat in the past 7 days Quantity
"h103u_071", -- Abats How much did you eat in the past 7 days Unit
"h102_094", -- Cacao chocolat Did you eat any in the past 7 days
"h103q_088", -- Lait en poudre How much did you eat in the past 7 days Quantity
"h104q_080", -- Huille d arachide How much came from purchases Quanity
"h103u_101", -- The en paquet ou en Sachets How much did you eat in the past 7 days Unit
"h104q_096", -- Confiserie How much came from purchases Quanity
"h104u_091", -- Yaourt solani How much came from purchases Unit
"h106u_085", -- Oeufs How much came from your own production Unit
"h103u_093", -- Sucre How much did you eat in the past 7 days Unit
"h103q_074", -- Poisson frais How much did you eat in the past 7 days Quantity
"h106q_086", -- Lait frais How much came from your own production Quantity
"h102_093", -- Sucre Did you eat any in the past 7 days
"h105_092", -- Autres produits laitiers How much did you spend FCFA
"h103q_092", -- Autres produits laitiers How much did you eat in the past 7 days Quantity
"h107u_091", -- Yaourt solani How much came from gifts other sources Unit
"h103q_084", -- Pate d arachide How much did you eat in the past 7 days Quantity
"h103u_084", -- Pate d arachide How much did you eat in the past 7 days Unit
"h107q_084", -- Pate d arachide How much came from gifts other sources Quantity
"h104u_085", -- Oeufs How much came from purchases Unit
"h103q_086", -- Lait frais How much did you eat in the past 7 days Quantity
"h104q_086", -- Lait frais How much came from purchases Quanity
"h105_075", -- Poisson fume How much did you spend FCFA
"h107u_083", -- Autres huilles n d a How much came from gifts other sources Unit
"h102_078", -- Conserves d autres produits de peche Did you eat any in the past 7 days
"h104u_094", -- Cacao chocolat How much came from purchases Unit
"h105_086", -- Lait frais How much did you spend FCFA
"h106u_086", -- Lait frais How much came from your own production Unit
"h104q_087", -- Lait caille How much came from purchases Quanity
"h106u_082", -- Huille de mais How much came from your own production Unit
"h105_087", -- Lait caille How much did you spend FCFA
"h107q_082", -- Huille de mais How much came from gifts other sources Quantity
"h106q_087", -- Lait caille How much came from your own production Quantity
"h107q_087", -- Lait caille How much came from gifts other sources Quantity
"h107u_087", -- Lait caille How much came from gifts other sources Unit
"h103u_088", -- Lait en poudre How much did you eat in the past 7 days Unit
"h104u_088", -- Lait en poudre How much came from purchases Unit
"h106u_088", -- Lait en poudre How much came from your own production Unit
"h106q_091", -- Yaourt solani How much came from your own production Quantity
"h107q_103", -- Jus de fruit How much came from gifts other sources Quantity
"h103q_096", -- Confiserie How much did you eat in the past 7 days Quantity
"h103u_105", -- Boissons gazeuses How much did you eat in the past 7 days Unit
"h102_088", -- Lait en poudre Did you eat any in the past 7 days
"h106q_092", -- Autres produits laitiers How much came from your own production Quantity
"h106q_078", -- Conserves d autres produits de peche How much came from your own production Quantity
"h106q_084", -- Pate d arachide How much came from your own production Quantity
"h104u_076", -- Poisson seche How much came from purchases Unit
"h107u_088", -- Lait en poudre How much came from gifts other sources Unit
"h106q_089", -- Fromage How much came from your own production Quantity
"h106u_105", -- Boissons gazeuses How much came from your own production Unit
"h103u_075", -- Poisson fume How much did you eat in the past 7 days Unit
"h107u_089", -- Fromage How much came from gifts other sources Unit
"h102_090", -- Beurre Did you eat any in the past 7 days
"h104q_090", -- Beurre How much came from purchases Quanity
"h104u_080", -- Huille d arachide How much came from purchases Unit
"h105_090", -- Beurre How much did you spend FCFA
"h103u_083", -- Autres huilles n d a How much did you eat in the past 7 days Unit
"h103q_083", -- Autres huilles n d a How much did you eat in the past 7 days Quantity
"h102_083", -- Autres huilles n d a Did you eat any in the past 7 days
"h107u_082", -- Huille de mais How much came from gifts other sources Unit
"h107u_081", -- Huille de coton How much came from gifts other sources Unit
"h105_081", -- Huille de coton How much did you spend FCFA
"h104q_083", -- Autres huilles n d a How much came from purchases Quanity
"h103q_081", -- Huille de coton How much did you eat in the past 7 days Quantity
"h105_104", -- Jus en poudre How much did you spend FCFA
"h106u_083", -- Autres huilles n d a How much came from your own production Unit
"h106u_094", -- Cacao chocolat How much came from your own production Unit
"h106q_083", -- Autres huilles n d a How much came from your own production Quantity
"h102_091", -- Yaourt solani Did you eat any in the past 7 days
"h107u_080", -- Huille d arachide How much came from gifts other sources Unit
"h102_077", -- Conserves de poisson Did you eat any in the past 7 days
"h105_093", -- Sucre How much did you spend FCFA
"h106u_080", -- Huille d arachide How much came from your own production Unit
"h106q_080", -- Huille d arachide How much came from your own production Quantity
"h104q_095", -- Miel How much came from purchases Quanity
"h107u_096", -- Confiserie How much came from gifts other sources Unit
"h102_079", -- Huille de palme Did you eat any in the past 7 days
"h106q_073", -- Autres viandes n d a How much came from your own production Quantity
"h103u_072", -- Gibier How much did you eat in the past 7 days Unit
"h104q_082", -- Huille de mais How much came from purchases Quanity
"h106q_102", -- Autres tisanes et infusions n d a How much came from your own production Quantity
"h105_088", -- Lait en poudre How much did you spend FCFA
"h106q_104", -- Jus en poudre How much came from your own production Quantity
"h107q_090", -- Beurre How much came from gifts other sources Quantity
"h106q_103", -- Jus de fruit How much came from your own production Quantity
"h106u_073", -- Autres viandes n d a How much came from your own production Unit
"h105_072", -- Gibier How much did you spend FCFA
"h102_085", -- Oeufs Did you eat any in the past 7 days
"h102_080", -- Huille d arachide Did you eat any in the past 7 days
"h106q_072", -- Gibier How much came from your own production Quantity
"h104q_084", -- Pate d arachide How much came from purchases Quanity
"h102_084", -- Pate d arachide Did you eat any in the past 7 days
"h103u_081", -- Huille de coton How much did you eat in the past 7 days Unit
"h103u_103", -- Jus de fruit How much did you eat in the past 7 days Unit
"h106u_074", -- Poisson frais How much came from your own production Unit
"h105_105", -- Boissons gazeuses How much did you spend FCFA
"h103u_089", -- Fromage How much did you eat in the past 7 days Unit
"h107u_084", -- Pate d arachide How much came from gifts other sources Unit
"h106q_093", -- Sucre How much came from your own production Quantity
"h106u_093", -- Sucre How much came from your own production Unit
"h105_089", -- Fromage How much did you spend FCFA
"h103q_094", -- Cacao chocolat How much did you eat in the past 7 days Quantity
"h103u_094", -- Cacao chocolat How much did you eat in the past 7 days Unit
"h104q_094", -- Cacao chocolat How much came from purchases Quanity
"h105_094", -- Cacao chocolat How much did you spend FCFA
"h103u_095", -- Miel How much did you eat in the past 7 days Unit
"h106q_105", -- Boissons gazeuses How much came from your own production Quantity
"h102_075", -- Poisson fume Did you eat any in the past 7 days
"h105_091", -- Yaourt solani How much did you spend FCFA
"h102_072", -- Gibier Did you eat any in the past 7 days
"h106u_099", -- Cigarette How much came from your own production Unit
"h104u_104", -- Jus en poudre How much came from purchases Unit
"h106u_100", -- Cafe en boite ou en Sachets How much came from your own production Unit
"h105_080", -- Huille d arachide How much did you spend FCFA
"h103u_080", -- Huille d arachide How much did you eat in the past 7 days Unit
"h103q_080", -- Huille d arachide How much did you eat in the past 7 days Quantity
"h106q_079", -- Huille de palme How much came from your own production Quantity
"h102_087", -- Lait caille Did you eat any in the past 7 days
"h107q_099", -- Cigarette How much came from gifts other sources Quantity
"h104u_090", -- Beurre How much came from purchases Unit
"h107u_098", -- Tabac How much came from gifts other sources Unit
"h104u_095", -- Miel How much came from purchases Unit
"h105_079", -- Huille de palme How much did you spend FCFA
"h106u_095", -- Miel How much came from your own production Unit
"h104u_079", -- Huille de palme How much came from purchases Unit
"h103u_073", -- Autres viandes n d a How much did you eat in the past 7 days Unit
"h103u_079", -- Huille de palme How much did you eat in the past 7 days Unit
"h106u_071", -- Abats How much came from your own production Unit
"h103q_079", -- Huille de palme How much did you eat in the past 7 days Quantity
"h103q_097", -- Autres produits alimentaires How much did you eat in the past 7 days Quantity
"h107u_078", -- Conserves d autres produits de peche How much came from gifts other sources Unit
"h106q_097", -- Autres produits alimentaires How much came from your own production Quantity
"h106u_103", -- Jus de fruit How much came from your own production Unit
"h105_078", -- Conserves d autres produits de peche How much did you spend FCFA
"h107q_096", -- Confiserie How much came from gifts other sources Quantity
"h104u_078", -- Conserves d autres produits de peche How much came from purchases Unit
"h107u_077", -- Conserves de poisson How much came from gifts other sources Unit
"h107q_077", -- Conserves de poisson How much came from gifts other sources Quantity
"h107q_097", -- Autres produits alimentaires How much came from gifts other sources Quantity
"h106u_077", -- Conserves de poisson How much came from your own production Unit
"h104u_097", -- Autres produits alimentaires How much came from purchases Unit
"h105_077", -- Conserves de poisson How much did you spend FCFA
"h103u_077", -- Conserves de poisson How much did you eat in the past 7 days Unit
"h104q_076", -- Poisson seche How much came from purchases Quanity
"h102_076", -- Poisson seche Did you eat any in the past 7 days
"h107q_100", -- Cafe en boite ou en Sachets How much came from gifts other sources Quantity
"h106u_075", -- Poisson fume How much came from your own production Unit
"h103q_075", -- Poisson fume How much did you eat in the past 7 days Quantity
"h105_074", -- Poisson frais How much did you spend FCFA
"h103u_074", -- Poisson frais How much did you eat in the past 7 days Unit
"h103q_072", -- Gibier How much did you eat in the past 7 days Quantity
"h106q_081", -- Huille de coton How much came from your own production Quantity
"h104q_103", -- Jus de fruit How much came from purchases Quanity
"h104q_105", -- Boissons gazeuses How much came from purchases Quanity
"h107u_103", -- Jus de fruit How much came from gifts other sources Unit
"h104q_092", -- Autres produits laitiers How much came from purchases Quanity
"h105_098", -- Tabac How much did you spend FCFA
"h104q_098", -- Tabac How much came from purchases Quanity
"h106u_098", -- Tabac How much came from your own production Unit
"h102_099", -- Cigarette Did you eat any in the past 7 days
"h103u_099", -- Cigarette How much did you eat in the past 7 days Unit
"h102_097", -- Autres produits alimentaires Did you eat any in the past 7 days
"h107u_073", -- Autres viandes n d a How much came from gifts other sources Unit
"h104u_073", -- Autres viandes n d a How much came from purchases Unit
"h107q_073", -- Autres viandes n d a How much came from gifts other sources Quantity
"h103u_076", -- Poisson seche How much did you eat in the past 7 days Unit
"h107q_089", -- Fromage How much came from gifts other sources Quantity
"h103q_073", -- Autres viandes n d a How much did you eat in the past 7 days Quantity
"h107u_072", -- Gibier How much came from gifts other sources Unit
"h106q_071", -- Abats How much came from your own production Quantity
"h105_071", -- Abats How much did you spend FCFA
"h104u_092", -- Autres produits laitiers How much came from purchases Unit
"h107q_085", -- Oeufs How much came from gifts other sources Quantity
"h104u_071", -- Abats How much came from purchases Unit
"h104q_071", -- Abats How much came from purchases Quanity
"h102_095", -- Miel Did you eat any in the past 7 days
"h104u_098", -- Tabac How much came from purchases Unit
"h107u_075", -- Poisson fume How much came from gifts other sources Unit
"h107q_070", -- Volailles How much came from gifts other sources Quantity
"h107u_086", -- Lait frais How much came from gifts other sources Unit
"h107q_080", -- Huille d arachide How much came from gifts other sources Quantity
"h102_105", -- Boissons gazeuses Did you eat any in the past 7 days
"h102_092", -- Autres produits laitiers Did you eat any in the past 7 days
"h106u_076", -- Poisson seche How much came from your own production Unit
"h104q_097", -- Autres produits alimentaires How much came from purchases Quanity
"h106u_087", -- Lait caille How much came from your own production Unit
"h106u_104", -- Jus en poudre How much came from your own production Unit
"h107q_102", -- Autres tisanes et infusions n d a How much came from gifts other sources Quantity
"h107q_088", -- Lait en poudre How much came from gifts other sources Quantity
"h107u_101", -- The en paquet ou en Sachets How much came from gifts other sources Unit
"h103q_071", -- Abats How much did you eat in the past 7 days Quantity
"h107u_070", -- Volailles How much came from gifts other sources Unit
"id",
"h107u_102", -- Autres tisanes et infusions n d a How much came from gifts other sources Unit
"h104q_075", -- Poisson fume How much came from purchases Quanity
"h107u_095", -- Miel How much came from gifts other sources Unit
"h107q_091", -- Yaourt solani How much came from gifts other sources Quantity
"h104u_102", -- Autres tisanes et infusions n d a How much came from purchases Unit
"h103q_102", -- Autres tisanes et infusions n d a How much did you eat in the past 7 days Quantity
"h106u_101", -- The en paquet ou en Sachets How much came from your own production Unit
"h104u_101", -- The en paquet ou en Sachets How much came from purchases Unit
"h103q_101", -- The en paquet ou en Sachets How much did you eat in the past 7 days Quantity
"h105_100", -- Cafe en boite ou en Sachets How much did you spend FCFA
"h104q_100", -- Cafe en boite ou en Sachets How much came from purchases Quanity
"h103u_100", -- Cafe en boite ou en Sachets How much did you eat in the past 7 days Unit
"h103q_099", -- Cigarette How much did you eat in the past 7 days Quantity
"h107u_097", -- Autres produits alimentaires How much came from gifts other sources Unit
"h106u_097", -- Autres produits alimentaires How much came from your own production Unit
"h105_096", -- Confiserie How much did you spend FCFA
"h104q_099", -- Cigarette How much came from purchases Quanity
"h104u_099", -- Cigarette How much came from purchases Unit
"h105_099", -- Cigarette How much did you spend FCFA
"h103q_100", -- Cafe en boite ou en Sachets How much did you eat in the past 7 days Quantity
"h104u_100", -- Cafe en boite ou en Sachets How much came from purchases Unit
"h106u_078", -- Conserves d autres produits de peche How much came from your own production Unit
"h105_097", -- Autres produits alimentaires How much did you spend FCFA
"h102_096", -- Confiserie Did you eat any in the past 7 days
"h107u_094", -- Cacao chocolat How much came from gifts other sources Unit
"h102_101", -- The en paquet ou en Sachets Did you eat any in the past 7 days
"h107q_094", -- Cacao chocolat How much came from gifts other sources Quantity
"h104q_093", -- Sucre How much came from purchases Quanity
"h107u_099", -- Cigarette How much came from gifts other sources Unit
"h103q_093", -- Sucre How much did you eat in the past 7 days Quantity
"h107q_079", -- Huille de palme How much came from gifts other sources Quantity
"h104q_091", -- Yaourt solani How much came from purchases Quanity
"h103q_091", -- Yaourt solani How much did you eat in the past 7 days Quantity
"h106q_095", -- Miel How much came from your own production Quantity
"h107u_079", -- Huille de palme How much came from gifts other sources Unit
"h106u_089", -- Fromage How much came from your own production Unit
"h106q_074", -- Poisson frais How much came from your own production Quantity
"h107q_081", -- Huille de coton How much came from gifts other sources Quantity
"h107q_101", -- The en paquet ou en Sachets How much came from gifts other sources Quantity
"h103q_098", -- Tabac How much did you eat in the past 7 days Quantity
"h106q_076", -- Poisson seche How much came from your own production Quantity
"h107q_086", -- Lait frais How much came from gifts other sources Quantity
"h106q_094", -- Cacao chocolat How much came from your own production Quantity
"h106q_101", -- The en paquet ou en Sachets How much came from your own production Quantity
"h104u_082", -- Huille de mais How much came from purchases Unit
"h106q_082", -- Huille de mais How much came from your own production Quantity
"h106u_092", -- Autres produits laitiers How much came from your own production Unit
"h104u_093", -- Sucre How much came from purchases Unit
"h107u_090", -- Beurre How much came from gifts other sources Unit
"h106u_090", -- Beurre How much came from your own production Unit
"h106q_090", -- Beurre How much came from your own production Quantity
"h107u_074", -- Poisson frais How much came from gifts other sources Unit
"h103u_082", -- Huille de mais How much did you eat in the past 7 days Unit
"h106q_096", -- Confiserie How much came from your own production Quantity
"h107q_104", -- Jus en poudre How much came from gifts other sources Quantity
"h104q_101", -- The en paquet ou en Sachets How much came from purchases Quanity
"h105_101", -- The en paquet ou en Sachets How much did you spend FCFA
"h102_102", -- Autres tisanes et infusions n d a Did you eat any in the past 7 days
"h103u_102", -- Autres tisanes et infusions n d a How much did you eat in the past 7 days Unit
"h104q_102", -- Autres tisanes et infusions n d a How much came from purchases Quanity
"h105_102", -- Autres tisanes et infusions n d a How much did you spend FCFA
"h103u_090", -- Beurre How much did you eat in the past 7 days Unit
"h102_103", -- Jus de fruit Did you eat any in the past 7 days
"h103q_090", -- Beurre How much did you eat in the past 7 days Quantity
"h103q_103", -- Jus de fruit How much did you eat in the past 7 days Quantity
"h104q_089", -- Fromage How much came from purchases Quanity
"h102_089", -- Fromage Did you eat any in the past 7 days
"h106q_088", -- Lait en poudre How much came from your own production Quantity
"h104q_088", -- Lait en poudre How much came from purchases Quanity
"h104u_087", -- Lait caille How much came from purchases Unit
"h105_103", -- Jus de fruit How much did you spend FCFA
"h103q_104", -- Jus en poudre How much did you eat in the past 7 days Quantity
"h103q_089", -- Fromage How much did you eat in the past 7 days Quantity
"h103q_087", -- Lait caille How much did you eat in the past 7 days Quantity
"h103u_096", -- Confiserie How much did you eat in the past 7 days Unit
"h104u_086", -- Lait frais How much came from purchases Unit
"h104u_074", -- Poisson frais How much came from purchases Unit
"h103u_086", -- Lait frais How much did you eat in the past 7 days Unit
"h107q_083", -- Autres huilles n d a How much came from gifts other sources Quantity
"h103q_105", -- Boissons gazeuses How much did you eat in the past 7 days Quantity
"h103u_078", -- Conserves d autres produits de peche How much did you eat in the past 7 days Unit
"h102_086", -- Lait frais Did you eat any in the past 7 days
"h104u_075", -- Poisson fume How much came from purchases Unit
"h107u_085", -- Oeufs How much came from gifts other sources Unit
"h106q_085", -- Oeufs How much came from your own production Quantity
"h105_085", -- Oeufs How much did you spend FCFA
"h104q_085", -- Oeufs How much came from purchases Quanity
"h105_084", -- Pate d arachide How much did you spend FCFA
"h104u_084", -- Pate d arachide How much came from purchases Unit
"h105_083", -- Autres huilles n d a How much did you spend FCFA
"h104u_083", -- Autres huilles n d a How much came from purchases Unit
"h103q_082", -- Huille de mais How much did you eat in the past 7 days Quantity
"h102_082", -- Huille de mais Did you eat any in the past 7 days
"h104q_081", -- Huille de coton How much came from purchases Quanity
"h106u_079", -- Huille de palme How much came from your own production Unit
"h104q_079", -- Huille de palme How much came from purchases Quanity
"h104q_078", -- Conserves d autres produits de peche How much came from purchases Quanity
"h104u_077", -- Conserves de poisson How much came from purchases Unit
"h104q_077", -- Conserves de poisson How much came from purchases Quanity
"h107u_076", -- Poisson seche How much came from gifts other sources Unit
"h105_076", -- Poisson seche How much did you spend FCFA
"h107q_075", -- Poisson fume How much came from gifts other sources Quantity
"h106q_075", -- Poisson fume How much came from your own production Quantity
"h104q_074", -- Poisson frais How much came from purchases Quanity
"h102_074", -- Poisson frais Did you eat any in the past 7 days
"h104q_073", -- Autres viandes n d a How much came from purchases Quanity
"h107q_072", -- Gibier How much came from gifts other sources Quantity
"h106u_072", -- Gibier How much came from your own production Unit
"h103u_097", -- Autres produits alimentaires How much did you eat in the past 7 days Unit
"h106u_081", -- Huille de coton How much came from your own production Unit
"h104u_096", -- Confiserie How much came from purchases Unit
"h102_100", -- Cafe en boite ou en Sachets Did you eat any in the past 7 days
"h107u_071", -- Abats How much came from gifts other sources Unit
"h107q_074", -- Poisson frais How much came from gifts other sources Quantity
"h106q_100", -- Cafe en boite ou en Sachets How much came from your own production Quantity
"h104u_089", -- Fromage How much came from purchases Unit
"h102_098", -- Tabac Did you eat any in the past 7 days
"h103q_085", -- Oeufs How much did you eat in the past 7 days Quantity
"h107q_078", -- Conserves d autres produits de peche How much came from gifts other sources Quantity
"h107q_071", -- Abats How much came from gifts other sources Quantity
"h102_073", -- Autres viandes n d a Did you eat any in the past 7 days
"h104u_072", -- Gibier How much came from purchases Unit
"h102_071", -- Abats Did you eat any in the past 7 days
"h104q_072", -- Gibier How much came from purchases Quanity
"h106u_096", -- Confiserie How much came from your own production Unit
"h102_104", -- Jus en poudre Did you eat any in the past 7 days
"h103q_076", -- Poisson seche How much did you eat in the past 7 days Quantity
"h103u_098", -- Tabac How much did you eat in the past 7 days Unit
"h103u_087", -- Lait caille How much did you eat in the past 7 days Unit
"h106q_099" -- Cigarette How much came from your own production Quantity
FROM
"usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-778v-b68h: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-778v-b68h with SQL in under 60 seconds.
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, 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 (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-778v-b68h:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-778v-b68hCheckout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-778v-b68h:latestThis will download all the objects for the latest tag of usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-778v-b68h and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-778v-b68h:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered usaid-gov/data-on-food-consumption-in-zinder-and-maradi-in-778v-b68h:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
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-778v-b68h is just another Postgres schema.