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 guatemala_food_consumption_data_section_3 table in this repository, by referencing it like:
"usaid-gov/guatemala-food-consumption-data-section-3-yi56-9r93:latest"."guatemala_food_consumption_data_section_3"or in a full query, like:
SELECT
":id", -- Socrata column ID
"h107b_091", -- UNIT GIFTS AND OTHER SOURCES Pears Units
"h102_108", -- CONSUMPTION IN PAST 7 DAYS Cigarettes Units
"h104b_090", -- UNIT FROM PURCHASES Mandarins Units
"h106b_105", -- OWN PRODUCTION UNIT Jams jellies Grams
"h203_108", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES matches
"h103b_093", -- UNIT CONSUMED IN PAST 7 DAYS Consomm s seasonings garlic salt onion and other salts Grams
"h103b_113", -- UNIT CONSUMED IN PAST 7 DAYS Paches Units
"h103b_087", -- UNIT CONSUMED IN PAST 7 DAYS Melons Units Portion
"h104b_087", -- UNIT FROM PURCHASES Melons Units Portion
"h102_090", -- CONSUMPTION IN PAST 7 DAYS Mandarins Units
"h103b_086", -- UNIT CONSUMED IN PAST 7 DAYS Potatoya Units Portion
"h107a_092", -- AMOUNT OF GIFTS AND OTHER SOURCES Grapes Pounds
"h104b_086", -- UNIT FROM PURCHASES Potatoya Units Portion
"h203_110", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Lustre shoe
"h201_107", -- ITEM Milling corn
"h203_103", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES fuel for private vehicles home Vehicles used for the home
"h203_101", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Newspapers
"h203_100", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES urban buses minibuses taxis or autorickshaws not including school transportation expenses
"h200", -- H200 Order Number head of household or person responsible
"h105_117", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Spending at restaurants food soda beer juice or other drinks or foods
"h106a_116", -- OWN PRODUCTION AMOUNT Toast with guacamole beans salsa etc Units
"h103a_116", -- AMOUNT CONSUMED IN PAST 7 DAYS Toast with guacamole beans salsa etc Units
"h107a_115", -- AMOUNT OF GIFTS AND OTHER SOURCES Tacos of all kinds Units
"h106b_114", -- OWN PRODUCTION UNIT pork rillettes Libra
"h105_114", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES pork rillettes Libra
"h106a_113", -- OWN PRODUCTION AMOUNT Paches Units
"h105_113", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Paches Units
"h103b_094", -- UNIT CONSUMED IN PAST 7 DAYS thyme bay leaf oregano and other spices Bunch Ounces
"h104b_094", -- UNIT FROM PURCHASES thyme bay leaf oregano and other spices Bunch Ounces
"h106b_094", -- OWN PRODUCTION UNIT thyme bay leaf oregano and other spices Bunch Ounces
"h107b_094", -- UNIT GIFTS AND OTHER SOURCES thyme bay leaf oregano and other spices Bunch Ounces
"h105_112", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Tamales colored black corn chuchitos etc Units
"h104a_112", -- AMOUNT FROM PURCHASES Tamales colored black corn chuchitos etc Units
"h105_111", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Tea on box Grams
"h104a_111", -- AMOUNT FROM PURCHASES Tea on box Grams
"h107a_110", -- AMOUNT OF GIFTS AND OTHER SOURCES Jams Grams
"h104a_110", -- AMOUNT FROM PURCHASES Jams Grams
"h105_107", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES liqueurs rums whiskeys wines cusha etc Liters
"h104a_107", -- AMOUNT FROM PURCHASES Liquor rums whiskeys wines cusha etc Liters
"h107a_095", -- AMOUNT OF GIFTS AND OTHER SOURCES Sal Pounds
"h105_096", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Aerated water Liters milliliters
"h103a_097", -- AMOUNT CONSUMED IN PAST 7 DAYS packaged or canned juices Milliliters
"h104a_097", -- AMOUNT FROM PURCHASES packaged or canned juices Milliliters
"h106a_097", -- OWN PRODUCTION AMOUNT packaged or canned juices Milliliters
"h106b_097", -- OWN PRODUCTION UNIT packaged or canned juices Milliliters
"h103b_106", -- UNIT CONSUMED IN PAST 7 DAYS Seeds toast as a hobby cashew etc Grams
"h107b_105", -- UNIT GIFTS AND OTHER SOURCES Jams jellies Grams
"h104a_104", -- AMOUNT FROM PURCHASES Candy tortrix curls etc Grams
"h103b_104", -- UNIT CONSUMED IN PAST 7 DAYS Candy tortrix curls etc Grams
"h104a_101", -- AMOUNT FROM PURCHASES Coffee beans ground coffee instant Pounds Grams
"h107a_113", -- AMOUNT OF GIFTS AND OTHER SOURCES Paches Units
"h103a_093", -- AMOUNT CONSUMED IN PAST 7 DAYS Consomm s seasonings garlic salt onion and other salts Grams
"h106b_115", -- OWN PRODUCTION UNIT Tacos of all kinds Units
"h105_106", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Seeds toast as a hobby cashew etc Grams
"h202_111", -- CONSUMPTION IN PAST 7 DAYS airtime cards for cell phones refills pins
"h103a_117", -- AMOUNT CONSUMED IN PAST 7 DAYS Spending at restaurants food soda beer juice or other drinks or foods
"h105_101", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Coffee beans ground coffee instant Pounds Grams
"h106b_108", -- OWN PRODUCTION UNIT Cigarettes Units
"h106a_110", -- OWN PRODUCTION AMOUNT Jams Grams
"h107b_110", -- UNIT GIFTS AND OTHER SOURCES Jams Grams
"h103a_111", -- AMOUNT CONSUMED IN PAST 7 DAYS Tea on box Grams
"h103b_111", -- UNIT CONSUMED IN PAST 7 DAYS Tea on box Grams
"h104a_103", -- AMOUNT FROM PURCHASES Beer Ounces liters milliliters
"h106b_111", -- OWN PRODUCTION UNIT Tea on box Grams
"h107b_111", -- UNIT GIFTS AND OTHER SOURCES Tea on box Grams
"h102_112", -- CONSUMPTION IN PAST 7 DAYS Tamales colored black corn chuchitos etc Units
"h103a_112", -- AMOUNT CONSUMED IN PAST 7 DAYS Tamales colored black corn chuchitos etc Units
"h103b_101", -- UNIT CONSUMED IN PAST 7 DAYS Coffee beans ground coffee instant Pounds Grams
"h103b_090", -- UNIT CONSUMED IN PAST 7 DAYS Mandarins Units
"h106a_105", -- OWN PRODUCTION AMOUNT Jams jellies Grams
"h106b_106", -- OWN PRODUCTION UNIT Seeds toast as a hobby cashew etc Grams
"h103a_098", -- AMOUNT CONSUMED IN PAST 7 DAYS Canned beans Grams
"h104b_098", -- UNIT FROM PURCHASES Canned beans Grams
"h105_098", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Canned beans Grams
"h107a_098", -- AMOUNT OF GIFTS AND OTHER SOURCES Canned beans Grams
"h107b_098", -- UNIT GIFTS AND OTHER SOURCES Canned beans Grams
"h102_099", -- CONSUMPTION IN PAST 7 DAYS Purified water Liters milliliters
"h103b_099", -- UNIT CONSUMED IN PAST 7 DAYS Purified water Liters milliliters
"h104a_099", -- AMOUNT FROM PURCHASES Purified water Liters milliliters
"h104b_104", -- UNIT FROM PURCHASES Candy tortrix curls etc Grams
"h105_104", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Candy tortrix curls etc Grams
"h106a_104", -- OWN PRODUCTION AMOUNT Candy tortrix curls etc Grams
"h107a_104", -- AMOUNT OF GIFTS AND OTHER SOURCES Candy tortrix curls etc Grams
"h107b_113", -- UNIT GIFTS AND OTHER SOURCES Paches Units
"h103b_085", -- UNIT CONSUMED IN PAST 7 DAYS Avocado Units
"h107b_117", -- UNIT GIFTS AND OTHER SOURCES Spending at restaurants food soda beer juice or other drinks or foods
"h106a_096", -- OWN PRODUCTION AMOUNT Aerated water Liters milliliters
"h103a_105", -- AMOUNT CONSUMED IN PAST 7 DAYS Jams jellies Grams
"h103b_105", -- UNIT CONSUMED IN PAST 7 DAYS Jams jellies Grams
"h104a_102", -- AMOUNT FROM PURCHASES Chocolate Pounds
"h107b_103", -- UNIT GIFTS AND OTHER SOURCES Beer Ounces liters milliliters
"h106a_112", -- OWN PRODUCTION AMOUNT Tamales colored black corn chuchitos etc Units
"h106b_112", -- OWN PRODUCTION UNIT Tamales colored black corn chuchitos etc Units
"h104a_105", -- AMOUNT FROM PURCHASES Jams jellies Grams
"h107a_112", -- AMOUNT OF GIFTS AND OTHER SOURCES Tamales colored black corn chuchitos etc Units
"h103a_113", -- AMOUNT CONSUMED IN PAST 7 DAYS Paches Units
"h103a_114", -- AMOUNT CONSUMED IN PAST 7 DAYS pork rillettes Libra
"h201_109", -- ITEM Lighters
"h105_105", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Jams jellies Grams
"h104a_114", -- AMOUNT FROM PURCHASES pork rillettes Libra
"h104a_113", -- AMOUNT FROM PURCHASES Paches Units
"h107a_114", -- AMOUNT OF GIFTS AND OTHER SOURCES pork rillettes Libra
"h107b_114", -- UNIT GIFTS AND OTHER SOURCES pork rillettes Libra
"h103b_097", -- UNIT CONSUMED IN PAST 7 DAYS packaged or canned juices Milliliters
"h107a_105", -- AMOUNT OF GIFTS AND OTHER SOURCES Jams jellies Grams
"h104a_115", -- AMOUNT FROM PURCHASES Tacos of all kinds Units
"h105_115", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Tacos of all kinds Units
"h107b_115", -- UNIT GIFTS AND OTHER SOURCES Tacos of all kinds Units
"h103b_110", -- UNIT CONSUMED IN PAST 7 DAYS Jams Grams
"h103b_116", -- UNIT CONSUMED IN PAST 7 DAYS Toast with guacamole beans salsa etc Units
"h104a_116", -- AMOUNT FROM PURCHASES Toast with guacamole beans salsa etc Units
"h202_100", -- CONSUMPTION IN PAST 7 DAYS urban buses minibuses taxis or autorickshaws not including school transportation expenses
"h105_116", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Toast with guacamole beans salsa etc Units
"h107a_116", -- AMOUNT OF GIFTS AND OTHER SOURCES Toast with guacamole beans salsa etc Units
"h106a_101", -- OWN PRODUCTION AMOUNT Coffee beans ground coffee instant Pounds Grams
"h107b_099", -- UNIT GIFTS AND OTHER SOURCES Purified water Liters milliliters
"h106b_113", -- OWN PRODUCTION UNIT Paches Units
"h104a_100", -- AMOUNT FROM PURCHASES Ice hail etc Units
"h103b_092", -- UNIT CONSUMED IN PAST 7 DAYS Grapes Pounds
"h107a_091", -- AMOUNT OF GIFTS AND OTHER SOURCES Pears Units
"h102_089", -- CONSUMPTION IN PAST 7 DAYS Strawberries Pounds
"h104b_099", -- UNIT FROM PURCHASES Purified water Liters milliliters
"h103a_106", -- AMOUNT CONSUMED IN PAST 7 DAYS Seeds toast as a hobby cashew etc Grams
"h102_117", -- CONSUMPTION IN PAST 7 DAYS Spending at restaurants food soda beer juice or other drinks or foods
"h106a_117", -- OWN PRODUCTION AMOUNT Spending at restaurants food soda beer juice or other drinks or foods
"h106b_117", -- OWN PRODUCTION UNIT Spending at restaurants food soda beer juice or other drinks or foods
"h201_100", -- ITEM urban buses minibuses taxis or autorickshaws not including school transportation expenses
"h203_102", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES public telephone telegrams letters fax internet outside the home
"h107b_085", -- UNIT GIFTS AND OTHER SOURCES Avocado Units
"h102_115", -- CONSUMPTION IN PAST 7 DAYS Tacos of all kinds Units
"h106a_106", -- OWN PRODUCTION AMOUNT Seeds toast as a hobby cashew etc Grams
"h107b_087", -- UNIT GIFTS AND OTHER SOURCES Melons Units Portion
"h102_088", -- CONSUMPTION IN PAST 7 DAYS Peaches peaches Units
"h107a_106", -- AMOUNT OF GIFTS AND OTHER SOURCES Seeds toast as a hobby cashew etc Grams
"h102_106", -- CONSUMPTION IN PAST 7 DAYS Seeds toast as a hobby cashew etc Grams
"h102_098", -- CONSUMPTION IN PAST 7 DAYS Canned beans Grams
"h103b_091", -- UNIT CONSUMED IN PAST 7 DAYS Pears Units
"h202_106", -- CONSUMPTION IN PAST 7 DAYS Money given to children for personal expenses at school
"h106a_114", -- OWN PRODUCTION AMOUNT pork rillettes Libra
"h102_111", -- CONSUMPTION IN PAST 7 DAYS Tea on box Grams
"h103a_108", -- AMOUNT CONSUMED IN PAST 7 DAYS Cigarettes Units
"h106a_100", -- OWN PRODUCTION AMOUNT Ice hail etc Units
"h106a_088", -- OWN PRODUCTION AMOUNT Peaches peaches Units
"h106b_088", -- OWN PRODUCTION UNIT Peaches peaches Units
"h102_104", -- CONSUMPTION IN PAST 7 DAYS Candy tortrix curls etc Grams
"h107b_106", -- UNIT GIFTS AND OTHER SOURCES Seeds toast as a hobby cashew etc Grams
"h105_099", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Purified water Liters milliliters
"h102_101", -- CONSUMPTION IN PAST 7 DAYS Coffee beans ground coffee instant Pounds Grams
"h103a_107", -- AMOUNT CONSUMED IN PAST 7 DAYS liqueurs rums whiskeys wines cusha etc Liters
"h106b_101", -- OWN PRODUCTION UNIT Coffee beans ground coffee instant Pounds Grams
"h107b_101", -- UNIT GIFTS AND OTHER SOURCES Coffee beans ground coffee instant Pounds Grams
"h103a_102", -- AMOUNT CONSUMED IN PAST 7 DAYS Chocolate Pounds
"h103b_102", -- UNIT CONSUMED IN PAST 7 DAYS Chocolate Pounds
"h104b_102", -- UNIT FROM PURCHASES Chocolate Pounds
"h106b_102", -- OWN PRODUCTION UNIT Chocolate Pounds
"h104a_087", -- AMOUNT FROM PURCHASES Melons Units Portion
"h107b_086", -- UNIT GIFTS AND OTHER SOURCES Potatoya Units Portion
"h106b_107", -- OWN PRODUCTION UNIT Liquor rums whiskeys wines cusha etc Liters
"h107a_107", -- AMOUNT OF GIFTS AND OTHER SOURCES Liquor rums whiskeys wines cusha etc Liters
"h107b_107", -- UNIT GIFTS AND OTHER SOURCES Liquor rums whiskeys wines cusha etc Liters
"h102_086", -- CONSUMPTION IN PAST 7 DAYS Potatoya Units Portion
"h107b_112", -- UNIT GIFTS AND OTHER SOURCES Tamales colored black corn chuchitos etc Units
"h106b_098", -- OWN PRODUCTION UNIT Canned beans Grams
"h105_085", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Avocado Units
"h106a_086", -- OWN PRODUCTION AMOUNT Potatoya Units Portion
"h103a_088", -- AMOUNT CONSUMED IN PAST 7 DAYS Peaches peaches Units
"h103b_112", -- UNIT CONSUMED IN PAST 7 DAYS Tamales colored black corn chuchitos etc Units
"h106a_107", -- OWN PRODUCTION AMOUNT Liquor rums whiskeys wines cusha etc Liters
"h201_110", -- ITEM Lustre shoe
"h104b_088", -- UNIT FROM PURCHASES Peaches peaches Units
"h105_088", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Peaches peaches Units
"h104a_089", -- AMOUNT FROM PURCHASES Strawberries Pounds
"h107a_094", -- AMOUNT OF GIFTS AND OTHER SOURCES thyme bay leaf oregano and other spices Bunch Ounces
"h105_089", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Strawberries Pounds
"h106b_099", -- OWN PRODUCTION UNIT Purified water Liters milliliters
"h104b_100", -- UNIT FROM PURCHASES Ice hail etc Units
"h104a_090", -- AMOUNT FROM PURCHASES Mandarins Units
"h105_090", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Mandarins Units
"h106a_091", -- OWN PRODUCTION AMOUNT Pears Units
"h103a_092", -- AMOUNT CONSUMED IN PAST 7 DAYS Grapes Pounds
"h105_092", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Grapes Pounds
"h103a_103", -- AMOUNT CONSUMED IN PAST 7 DAYS Beer Ounces liters milliliters
"h103a_101", -- AMOUNT CONSUMED IN PAST 7 DAYS Coffee beans ground coffee instant Pounds Grams
"h107b_102", -- UNIT GIFTS AND OTHER SOURCES Chocolate Pounds
"h104b_117", -- UNIT FROM PURCHASES Spending at restaurants food soda beer juice or other drinks or foods
"h104b_110", -- UNIT FROM PURCHASES Jams Grams
"h104b_107", -- UNIT FROM PURCHASES Liquor rums whiskeys wines cusha etc Liters
"h107a_097", -- AMOUNT OF GIFTS AND OTHER SOURCES packaged or canned juices Milliliters
"h202_108", -- CONSUMPTION IN PAST 7 DAYS matches
"h104b_105", -- UNIT FROM PURCHASES Jams jellies Grams
"h107b_097", -- UNIT GIFTS AND OTHER SOURCES packaged or canned juices Milliliters
"h102_110", -- CONSUMPTION IN PAST 7 DAYS Jams Grams
"h102_102", -- CONSUMPTION IN PAST 7 DAYS Chocolate Pounds
"h105_108", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Cigarettes Units
"h106a_111", -- OWN PRODUCTION AMOUNT Tea on box Grams
"h203_107", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Milling corn
"h104a_106", -- AMOUNT FROM PURCHASES Seeds toast as a hobby cashew etc Grams
"h103a_100", -- AMOUNT CONSUMED IN PAST 7 DAYS Ice hail etc Units
"h107a_117", -- AMOUNT OF GIFTS AND OTHER SOURCES Spending at restaurants food soda beer juice or other drinks or foods
"h104a_093", -- AMOUNT FROM PURCHASES Consomm s seasonings garlic salt onion and other salts Grams
"h105_093", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Consomm s seasonings garlic salt onion and other salts Grams
"h104a_094", -- AMOUNT FROM PURCHASES thyme bay leaf oregano and other spices Bunch Ounces
"h105_094", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES thyme bay leaf oregano and other spices Bunch Ounces
"h106a_094", -- OWN PRODUCTION AMOUNT thyme bay leaf oregano and other spices Bunch Ounces
"h102_095", -- CONSUMPTION IN PAST 7 DAYS Sal Pounds
"h103a_095", -- AMOUNT CONSUMED IN PAST 7 DAYS Sal Pounds
"h103b_095", -- UNIT CONSUMED IN PAST 7 DAYS Sal Pounds
"h104a_095", -- AMOUNT FROM PURCHASES Sal Pounds
"h106b_095", -- OWN PRODUCTION UNIT Sal Pounds
"h107b_095", -- UNIT GIFTS AND OTHER SOURCES Sal Pounds
"h102_096", -- CONSUMPTION IN PAST 7 DAYS Aerated water Liters milliliters
"h104a_096", -- AMOUNT FROM PURCHASES Aerated water Liters milliliters
"h102_097", -- CONSUMPTION IN PAST 7 DAYS packaged or canned juices Milliliters
"h106b_100", -- OWN PRODUCTION UNIT Ice hail etc Units
"h105_100", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Ice hail etc Units
"h106a_103", -- OWN PRODUCTION AMOUNT Beer Ounces liters milliliters
"h106b_104", -- OWN PRODUCTION UNIT Candy tortrix curls etc Grams
"h103a_089", -- AMOUNT CONSUMED IN PAST 7 DAYS Strawberries Pounds
"h105_097", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES packaged or canned juices Milliliters
"h103a_099", -- AMOUNT CONSUMED IN PAST 7 DAYS Purified water Liters milliliters
"h106a_099", -- OWN PRODUCTION AMOUNT Purified water Liters milliliters
"h107a_099", -- AMOUNT OF GIFTS AND OTHER SOURCES Purified water Liters milliliters
"h104b_096", -- UNIT FROM PURCHASES Aerated water Liters milliliters
"h201_102", -- ITEM public telephone telegrams letters fax internet outside the home
"h106b_096", -- OWN PRODUCTION UNIT Aerated water Liters milliliters
"h106b_086", -- OWN PRODUCTION UNIT Potatoya Units Portion
"h106b_116", -- OWN PRODUCTION UNIT Toast with guacamole beans salsa etc Units
"h102_103", -- CONSUMPTION IN PAST 7 DAYS Beer Ounces liters milliliters
"h103b_103", -- UNIT CONSUMED IN PAST 7 DAYS Beer Ounces liters milliliters
"h104b_111", -- UNIT FROM PURCHASES Tea on box Grams
"h103b_117", -- UNIT CONSUMED IN PAST 7 DAYS Spending at restaurants food soda beer juice or other drinks or foods
"h105_103", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Beer Ounces liters milliliters
"h107a_103", -- AMOUNT OF GIFTS AND OTHER SOURCES Beer Ounces liters milliliters
"h104b_089", -- UNIT FROM PURCHASES Strawberries Pounds
"h106a_089", -- OWN PRODUCTION AMOUNT Strawberries Pounds
"h103b_089", -- UNIT CONSUMED IN PAST 7 DAYS Strawberries Pounds
"h104b_093", -- UNIT FROM PURCHASES Consomm s seasonings garlic salt onion and other salts Grams
"h102_093", -- CONSUMPTION IN PAST 7 DAYS Consomm s seasonings garlic salt onion and other salts Grams
"h106b_092", -- OWN PRODUCTION UNIT Grapes Pounds
"h105_110", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Jams Grams
"h106a_092", -- OWN PRODUCTION AMOUNT Grapes Pounds
"h104b_092", -- UNIT FROM PURCHASES Grapes Pounds
"h102_092", -- CONSUMPTION IN PAST 7 DAYS Grapes Pounds
"h106b_091", -- OWN PRODUCTION UNIT Pears Units
"h107a_108", -- AMOUNT OF GIFTS AND OTHER SOURCES Cigarettes Units
"h104a_098", -- AMOUNT FROM PURCHASES Canned beans Grams
"h202_102", -- CONSUMPTION IN PAST 7 DAYS public telephone telegrams letters fax internet outside the home
"h105_095", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Sal Pounds
"h104b_106", -- UNIT FROM PURCHASES Seeds toast as a hobby cashew etc Grams
"h105_091", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Pears Units
"h104a_091", -- AMOUNT FROM PURCHASES Pears Units
"h103a_091", -- AMOUNT CONSUMED IN PAST 7 DAYS Pears Units
"h102_091", -- CONSUMPTION IN PAST 7 DAYS Pears Units
"h107b_090", -- UNIT GIFTS AND OTHER SOURCES Mandarins Units
"h105_086", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Potatoya Units Portion
"h107a_090", -- AMOUNT OF GIFTS AND OTHER SOURCES Mandarins Units
"h106a_090", -- OWN PRODUCTION AMOUNT Mandarins Units
"h103a_086", -- AMOUNT CONSUMED IN PAST 7 DAYS Potatoya Units Portion
"h107a_085", -- AMOUNT OF GIFTS AND OTHER SOURCES Avocado Units
"h106a_085", -- OWN PRODUCTION AMOUNT Avocado Units
"h104a_085", -- AMOUNT FROM PURCHASES Avocado Units
"h104b_095", -- UNIT FROM PURCHASES Sal Pounds
"h107a_100", -- AMOUNT OF GIFTS AND OTHER SOURCES Ice hail etc Units
"h106a_098", -- OWN PRODUCTION AMOUNT Canned beans Grams
"h105_087", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Melons Units Portion
"h107a_088", -- AMOUNT OF GIFTS AND OTHER SOURCES Peaches peaches Units
"h103b_107", -- UNIT CONSUMED IN PAST 7 DAYS liqueurs rums whiskeys wines cusha etc Liters
"h103a_090", -- AMOUNT CONSUMED IN PAST 7 DAYS Mandarins Units
"h103a_085", -- AMOUNT CONSUMED IN PAST 7 DAYS Avocado Units
"h103b_108", -- UNIT CONSUMED IN PAST 7 DAYS Cigarettes Units
"h107a_102", -- AMOUNT OF GIFTS AND OTHER SOURCES Chocolate Pounds
"h104b_114", -- UNIT FROM PURCHASES pork rillettes Libra
"h201_106", -- ITEM Money given to children for personal expenses at school
"h102_113", -- CONSUMPTION IN PAST 7 DAYS Paches Units
"h104a_117", -- AMOUNT FROM PURCHASES Spending at restaurants food soda beer juice or other drinks or foods
"h201_101", -- ITEM Newspapers
"h106b_110", -- OWN PRODUCTION UNIT Jams Grams
"h103b_098", -- UNIT CONSUMED IN PAST 7 DAYS Canned beans Grams
"id",
"h104b_115", -- UNIT FROM PURCHASES Tacos of all kinds Units
"h104b_103", -- UNIT FROM PURCHASES Beer Ounces liters milliliters
"h102_114", -- CONSUMPTION IN PAST 7 DAYS pork rillettes Libra
"h107a_093", -- AMOUNT OF GIFTS AND OTHER SOURCES Consomm s seasonings garlic salt onion and other salts Grams
"h102_100", -- CONSUMPTION IN PAST 7 DAYS Ice hail etc Units
"h103b_096", -- UNIT CONSUMED IN PAST 7 DAYS Aerated water Liters milliliters
"h104a_108", -- AMOUNT FROM PURCHASES Cigarettes Units
"h201_103", -- ITEM fuel for private vehicles home Vehicles used for the home
"h103a_087", -- AMOUNT CONSUMED IN PAST 7 DAYS Melons Units Portion
"h104b_116", -- UNIT FROM PURCHASES Toast with guacamole beans salsa etc Units
"h202_109", -- CONSUMPTION IN PAST 7 DAYS Lighters
"h107b_100", -- UNIT GIFTS AND OTHER SOURCES Ice hail etc Units
"h106a_095", -- OWN PRODUCTION AMOUNT Sal Pounds
"h106a_108", -- OWN PRODUCTION AMOUNT Cigarettes Units
"h104b_085", -- UNIT FROM PURCHASES Avocado Units
"h202_107", -- CONSUMPTION IN PAST 7 DAYS Milling corn
"h103a_110", -- AMOUNT CONSUMED IN PAST 7 DAYS Jams Grams
"h106a_087", -- OWN PRODUCTION AMOUNT Melons Units Portion
"h201_108", -- ITEM matches
"h106a_102", -- OWN PRODUCTION AMOUNT Chocolate Pounds
"h104a_092", -- AMOUNT FROM PURCHASES Grapes Pounds
"h106b_090", -- OWN PRODUCTION UNIT Mandarins Units
"h106b_093", -- OWN PRODUCTION UNIT Consomm s seasonings garlic salt onion and other salts Grams
"h102_087", -- CONSUMPTION IN PAST 7 DAYS Melons Units Portion
"h106b_087", -- OWN PRODUCTION UNIT Melons Units Portion
"h107b_088", -- UNIT GIFTS AND OTHER SOURCES Peaches peaches Units
"h107a_101", -- AMOUNT OF GIFTS AND OTHER SOURCES Coffee beans ground coffee instant Pounds Grams
"h107a_111", -- AMOUNT OF GIFTS AND OTHER SOURCES Tea on box Grams
"h103b_088", -- UNIT CONSUMED IN PAST 7 DAYS Peaches peaches Units
"h107b_096", -- UNIT GIFTS AND OTHER SOURCES Aerated water Liters milliliters
"h107a_096", -- AMOUNT OF GIFTS AND OTHER SOURCES Aerated water Liters milliliters
"h107b_116", -- UNIT GIFTS AND OTHER SOURCES Toast with guacamole beans salsa etc Units
"h107a_086", -- AMOUNT OF GIFTS AND OTHER SOURCES Potatoya Units Portion
"h106b_103", -- OWN PRODUCTION UNIT Beer Ounces liters milliliters
"h104b_112", -- UNIT FROM PURCHASES Tamales colored black corn chuchitos etc Units
"h107b_092", -- UNIT GIFTS AND OTHER SOURCES Grapes Pounds
"h102_094", -- CONSUMPTION IN PAST 7 DAYS thyme bay leaf oregano and other spices Bunch Ounces
"h202_103", -- CONSUMPTION IN PAST 7 DAYS fuel for private vehicles home Vehicles used for the home
"h103a_104", -- AMOUNT CONSUMED IN PAST 7 DAYS Candy tortrix curls etc Grams
"h104a_086", -- AMOUNT FROM PURCHASES Potatoya Units Portion
"h105_102", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Chocolate Pounds
"h106b_085", -- OWN PRODUCTION UNIT Avocado Units
"h104b_101", -- UNIT FROM PURCHASES Coffee beans ground coffee instant Pounds Grams
"h104b_091", -- UNIT FROM PURCHASES Pears Units
"h202_110", -- CONSUMPTION IN PAST 7 DAYS Lustre shoe
"h106b_089", -- OWN PRODUCTION UNIT Strawberries Pounds
"h102_116", -- CONSUMPTION IN PAST 7 DAYS Toast with guacamole beans salsa etc Units
"h107a_089", -- AMOUNT OF GIFTS AND OTHER SOURCES Strawberries Pounds
"h103b_115", -- UNIT CONSUMED IN PAST 7 DAYS Tacos of all kinds Units
"h107a_087", -- AMOUNT OF GIFTS AND OTHER SOURCES Melons Units Portion
"h107b_093", -- UNIT GIFTS AND OTHER SOURCES Consomm s seasonings garlic salt onion and other salts Grams
"h104b_097", -- UNIT FROM PURCHASES packaged or canned juices Milliliters
"h103a_096", -- AMOUNT CONSUMED IN PAST 7 DAYS Aerated water Liters milliliters
"h103a_115", -- AMOUNT CONSUMED IN PAST 7 DAYS Tacos of all kinds Units
"h202_101", -- CONSUMPTION IN PAST 7 DAYS Newspapers
"h107b_104", -- UNIT GIFTS AND OTHER SOURCES Candy tortrix curls etc Grams
"h203_106", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Money given to children for personal expenses at school
"h203_109", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Lighters
"h201_111", -- ITEM airtime cards for cell phones refills pins
"h203_111", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES airtime cards for cell phones refills pins
"h106a_115", -- OWN PRODUCTION AMOUNT Tacos of all kinds Units
"h104b_108", -- UNIT FROM PURCHASES Cigarettes Units
"h103b_114", -- UNIT CONSUMED IN PAST 7 DAYS pork rillettes Libra
"h102_107", -- CONSUMPTION IN PAST 7 DAYS Liquor rums whiskeys wines cusha etc Liters
"h103b_100", -- UNIT CONSUMED IN PAST 7 DAYS Ice hail etc Units
"h104b_113", -- UNIT FROM PURCHASES Paches Units
"h102_105", -- CONSUMPTION IN PAST 7 DAYS Jams jellies Grams
"h107b_108", -- UNIT GIFTS AND OTHER SOURCES Cigarettes Units
"h106a_093", -- OWN PRODUCTION AMOUNT Consomm s seasonings garlic salt onion and other salts Grams
"h107b_089", -- UNIT GIFTS AND OTHER SOURCES Strawberries Pounds
"h104a_088", -- AMOUNT FROM PURCHASES Peaches peaches Units
"h103a_094" -- AMOUNT CONSUMED IN PAST 7 DAYS thyme bay leaf oregano and other spices Bunch Ounces
FROM
"usaid-gov/guatemala-food-consumption-data-section-3-yi56-9r93:latest"."guatemala_food_consumption_data_section_3"
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/guatemala-food-consumption-data-section-3-yi56-9r93 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/guatemala-food-consumption-data-section-3-yi56-9r93: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/guatemala-food-consumption-data-section-3-yi56-9r93Checkout 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/guatemala-food-consumption-data-section-3-yi56-9r93:latestThis will download all the objects for the latest tag of usaid-gov/guatemala-food-consumption-data-section-3-yi56-9r93 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/guatemala-food-consumption-data-section-3-yi56-9r93: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/guatemala-food-consumption-data-section-3-yi56-9r93: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/guatemala-food-consumption-data-section-3-yi56-9r93 is just another Postgres schema.