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_1 table in this repository, by referencing it like:
"usaid-gov/guatemala-food-consumption-data-section-1-pcma-mau9:latest"."guatemala_food_consumption_data_section_1"or in a full query, like:
SELECT
":id", -- Socrata column ID
"h104a_39a", -- AMOUNT FROM PURCHASES Other meats like sausages sausages sausages small unit median
"h106b_006", -- OWN PRODUCTION UNIT Cakes unit small medium large
"h103a_039", -- AMOUNT CONSUMED IN PAST 7 DAYS Ham Pounds Grams
"h104b_035", -- UNIT FROM PURCHASES Fish fresh or dry Pounds
"h106b_039", -- OWN PRODUCTION UNIT Ham Pounds Grams
"h103b_034", -- UNIT CONSUMED IN PAST 7 DAYS Viscera giblets Pounds
"h104a_006", -- AMOUNT FROM PURCHASES Cakes unit small medium large
"h106a_39a", -- OWN PRODUCTION AMOUNT Other meats like sausages sausages sausages small unit median
"h107a_009", -- AMOUNT OF GIFTS AND OTHER SOURCES Incaparina Pounds
"h107a_39a", -- AMOUNT OF GIFTS AND OTHER SOURCES Other meats like sausages sausages sausages small unit median
"h107b_041", -- UNIT CAME AND OTHER SOURCES OF GIFTS Powdered milk Pounds
"h105_027", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Beef Pounds
"h107a_023", -- AMOUNT OF GIFTS AND OTHER SOURCES Soup in envelopes Mahler Maggi etc Grams
"h104a_038", -- AMOUNT FROM PURCHASES Seafood shrimp crabs Pounds
"h107b_037", -- UNIT GIFTS AND OTHER SOURCES Sardines tuna etc canned Grams
"h106b_035", -- OWN PRODUCTION UNIT Fish fresh or dry Pounds
"h106b_003", -- OWN PRODUCTION UNIT Maize white yellow etc Pounds
"h103b_026", -- UNIT CONSUMED IN PAST 7 DAYS Instant Soups in glass Grams
"h107a_014", -- AMOUNT OF GIFTS AND OTHER SOURCES Panela rapadura Pounds
"h107b_002", -- UNIT GIFTS AND OTHER SOURCES Rice 1st or 2nd Pounds
"h106b_034", -- OWN PRODUCTION UNIT Viscera giblets Pounds
"h103b_009", -- UNIT CONSUMED IN PAST 7 DAYS Incaparina Pounds
"h107b_013", -- UNIT GIFTS AND OTHER SOURCES Sugar Pounds
"h103a_030", -- AMOUNT CONSUMED IN PAST 7 DAYS Pork Pounds
"h106b_017", -- OWN PRODUCTION UNIT Corn flour Maseca Pounds
"h106a_038", -- OWN PRODUCTION AMOUNT Seafood shrimp crabs Pounds
"h102_014", -- CONSUMPTION IN PAST 7 DAYS Panela rapadura Pounds
"h107b_017", -- UNIT GIFTS AND OTHER SOURCES corn flour Maseca Pounds
"h107b_005", -- UNIT GIFTS AND OTHER SOURCES Cookies unit small medium large
"h104b_007", -- UNIT FROM PURCHASES corn or flour tortillas Units Pounds
"h107a_040", -- AMOUNT OF GIFTS AND OTHER SOURCES baby milk powder Pounds
"h106b_001", -- OWN PRODUCTION UNIT Bean black white red etc Pounds
"h106b_007", -- OWN PRODUCTION UNIT corn or flour tortillas Units Pounds
"h103b_035", -- UNIT CONSUMED IN PAST 7 DAYS Fish fresh or dry Pounds
"h103b_017", -- UNIT CONSUMED IN PAST 7 DAYS corn flour Maseca Pounds
"h106b_004", -- OWN PRODUCTION UNIT Pan small unit medium large
"h102_041", -- CONSUMPTION IN PAST 7 DAYS Milk Powder Pounds
"h104b_011", -- UNIT FROM PURCHASES Atoles corn glass
"h107b_008", -- UNIT GIFTS AND OTHER SOURCES Cereal preparations Corn Flakes etc Grams
"h107b_046", -- UNIT GIFTS AND OTHER SOURCES Fresh Cream Liters Glass
"h104b_013", -- UNIT FROM PURCHASES Sugar Pounds
"h103b_024", -- UNIT CONSUMED IN PAST 7 DAYS Sauces and canned tomato paste Grams
"h107a_008", -- AMOUNT OF GIFTS AND OTHER SOURCES Cereal preparations Corn Flakes etc Grams
"h106a_046", -- OWN PRODUCTION AMOUNT Fresh Cream Liters Glass
"h107a_039", -- AMOUNT OF GIFTS AND OTHER SOURCES Ham Pounds Grams
"h104b_034", -- UNIT FROM PURCHASES Viscera giblets Pounds
"h102_018", -- CONSUMPTION IN PAST 7 DAYS Wheat Pounds
"h103b_038", -- UNIT CONSUMED IN PAST 7 DAYS Seafood shrimp crabs Pounds
"h102_022", -- CONSUMPTION IN PAST 7 DAYS Noodles noodles macaroni pasta of all kinds Pounds
"h102_39a", -- CONSUMPTION IN PAST 7 DAYS Other meats like sausages sausages sausages small unit median
"h102_001", -- CONSUMPTION IN PAST 7 DAYS Bean black white red etc Pounds
"h103b_022", -- UNIT CONSUMED IN PAST 7 DAYS Noodles noodles macaroni pasta of all kinds Pounds
"h102_011", -- CONSUMPTION IN PAST 7 DAYS Atoles corn glass
"h103a_034", -- AMOUNT CONSUMED IN PAST 7 DAYS Viscera giblets Pounds
"h106a_010", -- OWN PRODUCTION AMOUNT Corn of all kinds mosh etc Pounds
"h107b_042", -- UNIT GIFTS AND OTHER SOURCES Fluid Milk Liters
"h107a_046", -- AMOUNT OF GIFTS AND OTHER SOURCES Fresh Cream Liters Glass
"h104b_024", -- UNIT FROM PURCHASES Sauces and canned tomato paste Grams
"h104b_037", -- UNIT FROM PURCHASES Sardines tuna etc canned Grams
"h104b_044", -- UNIT FROM PURCHASES Eggs Units
"h107b_034", -- UNIT GIFTS AND OTHER SOURCES Viscera giblets Pounds
"h102_017", -- CONSUMPTION IN PAST 7 DAYS corn flour Maseca Pounds
"h102_046", -- CONSUMPTION IN PAST 7 DAYS Fresh Cream Liters Glass
"h107b_035", -- UNIT GIFTS AND OTHER SOURCES Fish fresh or dry Pounds
"h107b_001", -- UNIT GIFTS AND OTHER SOURCES Bean black white red etc Pounds
"h107b_039", -- UNIT GIFTS AND OTHER SOURCES Ham Pounds Grams
"h104a_002", -- AMOUNT FROM PURCHASES Rice 1st or 2nd Pounds
"h106a_009", -- OWN PRODUCTION AMOUNT Incaparina Pounds
"h107b_023", -- UNIT GIFTS AND OTHER SOURCES Soup in envelopes Mahler Maggi etc Grams
"h104b_004", -- UNIT FROM PURCHASES Pan small unit medium large
"h106a_024", -- OWN PRODUCTION AMOUNT Sauces and canned tomato paste Grams
"h106b_040", -- OWN PRODUCTION UNIT baby milk powder Pounds
"h102_034", -- CONSUMPTION IN PAST 7 DAYS Viscera giblets Pounds
"h104b_39a", -- UNIT FROM PURCHASES Other meats like sausages sausages sausages small unit median
"h107b_018", -- UNIT GIFTS AND OTHER SOURCES Wheat Pounds
"h107a_037", -- AMOUNT OF GIFTS AND OTHER SOURCES Sardines tuna etc canned Grams
"h104b_009", -- UNIT FROM PURCHASES Incaparina Pounds
"h103a_003", -- AMOUNT CONSUMED IN PAST 7 DAYS Maize white yellow etc Pounds
"h106b_041", -- OWN PRODUCTION UNIT Milk Powder Pounds
"h106b_037", -- OWN PRODUCTION UNIT Sardines tuna etc canned Grams
"h107a_035", -- AMOUNT OF GIFTS AND OTHER SOURCES Fish fresh or dry Pounds
"h106a_035", -- OWN PRODUCTION AMOUNT Fish fresh or dry Pounds
"h107a_041", -- AMOUNT OF GIFTS AND OTHER SOURCES Milk Powder Pounds
"h102_030", -- CONSUMPTION IN PAST 7 DAYS Pork Pounds
"h107b_014", -- UNIT GIFTS AND OTHER SOURCES Panela rapadura Pounds
"h103b_008", -- UNIT CONSUMED IN PAST 7 DAYS Cereal preparations Corn Flakes etc Grams
"h106b_011", -- OWN PRODUCTION UNIT Atoles corn glass
"h103b_010", -- UNIT CONSUMED IN PAST 7 DAYS Corn of all kinds mosh etc Pounds
"h104b_006", -- UNIT FROM PURCHASES Cakes unit small medium large
"h104b_008", -- UNIT FROM PURCHASES Cereal preparations Corn Flakes etc Grams
"h103b_030", -- UNIT CONSUMED IN PAST 7 DAYS Pork Pounds
"h104b_027", -- UNIT FROM PURCHASES Beef Pounds
"h106b_027", -- OWN PRODUCTION UNIT Beef Pounds
"h103a_001", -- AMOUNT CONSUMED IN PAST 7 DAYS Bean black white red etc Pounds
"h102_035", -- CONSUMPTION IN PAST 7 DAYS Fish fresh or dry Pounds
"h102_003", -- CONSUMPTION IN PAST 7 DAYS Maize white yellow etc Pounds
"h106a_012", -- OWN PRODUCTION AMOUNT Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h102_007", -- CONSUMPTION IN PAST 7 DAYS corn or flour tortillas Units Pounds
"h104b_030", -- UNIT FROM PURCHASES Pork Pounds
"h107a_018", -- AMOUNT OF GIFTS AND OTHER SOURCES Wheat Pounds
"h103b_003", -- UNIT CONSUMED IN PAST 7 DAYS Maize white yellow etc Pounds
"id",
"h104b_039", -- UNIT FROM PURCHASES Ham Pounds Grams
"h107b_007", -- UNIT GIFTS AND OTHER SOURCES corn or flour tortillas Units Pounds
"h106a_011", -- OWN PRODUCTION AMOUNT Atoles corn glass
"h102_008", -- CONSUMPTION IN PAST 7 DAYS Cereal preparations Corn Flakes etc Grams
"h107a_002", -- AMOUNT OF GIFTS AND OTHER SOURCES Rice 1st or 2nd Pounds
"h107a_042", -- AMOUNT OF GIFTS AND OTHER SOURCES Fluid Milk Liters
"h106a_014", -- OWN PRODUCTION AMOUNT Panela rapadura Pounds
"h102_012", -- CONSUMPTION IN PAST 7 DAYS Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h103b_39a", -- UNIT CONSUMED IN PAST 7 DAYS Other meats like sausages sausages sausages small unit median
"h106a_040", -- OWN PRODUCTION AMOUNT baby milk powder Pounds
"h103b_013", -- UNIT CONSUMED IN PAST 7 DAYS Sugar Pounds
"h106a_005", -- OWN PRODUCTION AMOUNT Cookies unit small medium large
"h106b_005", -- OWN PRODUCTION UNIT Cookies unit small medium large
"h107a_026", -- AMOUNT OF GIFTS AND OTHER SOURCES Instant Soups in glass Grams
"h106b_038", -- OWN PRODUCTION UNIT Seafood shrimp crabs Pounds
"h107a_027", -- AMOUNT OF GIFTS AND OTHER SOURCES Beef Pounds
"h106b_008", -- OWN PRODUCTION UNIT Cereal preparations Corn Flakes etc Grams
"h103b_044", -- UNIT CONSUMED IN PAST 7 DAYS Eggs Units
"h107a_022", -- AMOUNT OF GIFTS AND OTHER SOURCES Noodles noodles macaroni pasta of all kinds Pounds
"h106a_004", -- OWN PRODUCTION AMOUNT Pan small unit medium large
"h104b_023", -- UNIT FROM PURCHASES Soup in envelopes Mahler Maggi etc Grams
"h104b_003", -- UNIT FROM PURCHASES Maize white yellow etc Pounds
"h103b_042", -- UNIT CONSUMED IN PAST 7 DAYS Fluid Milk Liters
"h102_039", -- CONSUMPTION IN PAST 7 DAYS Ham Pounds Grams
"h107b_038", -- UNIT GIFTS AND OTHER SOURCES seafood shrimp crabs Pounds
"h102_044", -- CONSUMPTION IN PAST 7 DAYS Eggs Units
"h107a_030", -- AMOUNT OF GIFTS AND OTHER SOURCES Pork Pounds
"h102_006", -- CONSUMPTION IN PAST 7 DAYS Cakes unit small medium large
"h104b_017", -- UNIT FROM PURCHASES corn flour Maseca Pounds
"h107a_012", -- AMOUNT OF GIFTS AND OTHER SOURCES Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h102_037", -- CONSUMPTION IN PAST 7 DAYS Sardines tuna etc canned Grams
"h102_026", -- CONSUMPTION IN PAST 7 DAYS Instant Soups in glass Grams
"h106a_023", -- OWN PRODUCTION AMOUNT Soup in envelopes Mahler Maggi etc Grams
"h102_042", -- CONSUMPTION IN PAST 7 DAYS Fluid Milk Liters
"h104a_040", -- AMOUNT FROM PURCHASES Milk powder for baby Pounds
"h107b_003", -- UNIT GIFTS AND OTHER SOURCES Maize white yellow etc Pounds
"h107a_038", -- AMOUNT OF GIFTS AND OTHER SOURCES seafood shrimp crabs Pounds
"h106b_012", -- OWN PRODUCTION UNIT Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h106b_033", -- OWN PRODUCTION UNIT Chicken meat or chicken Pounds
"h106b_030", -- OWN PRODUCTION UNIT Pork Pounds
"h106b_009", -- OWN PRODUCTION UNIT Incaparina Pounds
"h107b_030", -- UNIT GIFTS AND OTHER SOURCES Pork Pounds
"h107b_011", -- UNIT GIFTS AND OTHER SOURCES Atoles corn glass
"h103b_023", -- UNIT CONSUMED IN PAST 7 DAYS Soup in envelopes Mahler Maggi etc Grams
"h104b_041", -- UNIT FROM PURCHASES Milk Powder Pounds
"h103b_014", -- UNIT CONSUMED IN PAST 7 DAYS Panela rapadura Pounds
"h102_004", -- CONSUMPTION IN PAST 7 DAYS Pan small unit medium large
"h107b_033", -- UNIT GIFTS AND OTHER SOURCES Chicken meat or chicken Pounds
"h103b_039", -- UNIT CONSUMED IN PAST 7 DAYS Ham Pounds Grams
"h105_040", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES baby milk powder Pounds
"h106a_006", -- OWN PRODUCTION AMOUNT Cakes unit small medium large
"h103b_033", -- UNIT CONSUMED IN PAST 7 DAYS Chicken meat or chicken Pounds
"h106b_026", -- OWN PRODUCTION UNIT Instant Soups in glass Grams
"h107b_026", -- UNIT GIFTS AND OTHER SOURCES Instant Soups in glass Grams
"h107b_004", -- UNIT GIFTS AND OTHER SOURCES Pan small unit medium large
"h106b_044", -- OWN PRODUCTION UNIT Eggs Units
"h106a_026", -- OWN PRODUCTION AMOUNT Instant Soups in glass Grams
"h104b_022", -- UNIT FROM PURCHASES Noodles noodles macaroni pasta of all kinds Pounds
"h106b_010", -- OWN PRODUCTION UNIT Corn of all kinds mosh etc Pounds
"h102_027", -- CONSUMPTION IN PAST 7 DAYS Beef Pounds
"h106a_008", -- OWN PRODUCTION AMOUNT Cereal preparations Corn Flakes etc Grams
"h107b_024", -- UNIT GIFTS AND OTHER SOURCES Sauces and canned tomato paste Grams
"h107b_022", -- UNIT GIFTS AND OTHER SOURCES Noodles noodles macaroni pasta of all kinds Pounds
"a05", -- A05 Department
"h103b_046", -- UNIT CONSUMED IN PAST 7 DAYS Fresh Cream Liters Glass
"h104b_042", -- UNIT FROM PURCHASES Fluid Milk Liters
"h103b_037", -- UNIT CONSUMED IN PAST 7 DAYS Sardines tuna etc canned Grams
"h107a_001", -- AMOUNT OF GIFTS AND OTHER SOURCES Bean black white red etc Pounds
"h106b_013", -- OWN PRODUCTION UNIT Sugar Pounds
"h104b_026", -- UNIT FROM PURCHASES Instant Soups in glass Grams
"h105_001", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Bean black white red etc Pounds
"h103b_040", -- UNIT CONSUMED IN PAST 7 DAYS baby milk powder Pounds
"h107b_010", -- UNIT GIFTS AND OTHER SOURCES Corn of all kinds mosh etc Pounds
"h104b_033", -- UNIT FROM PURCHASES Chicken meat or chicken Pounds
"h104b_002", -- UNIT FROM PURCHASES Rice 1st or 2nd Pounds
"h107a_006", -- AMOUNT OF GIFTS AND OTHER SOURCES Cakes unit small medium large
"h106a_007", -- OWN PRODUCTION AMOUNT corn or flour tortillas Units Pounds
"h104b_010", -- UNIT FROM PURCHASES Corn of all kinds mosh etc Pounds
"a01", -- A01 Number of Household
"a02", -- A02 Enumeration area number
"h00c", -- H00C Order Number Person preparing food
"h104a_001", -- AMOUNT FROM PURCHASES Bean black white red etc Pounds
"h105_002", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Rice 1st or 2nd Pounds
"h106a_002", -- OWN PRODUCTION AMOUNT Rice 1st or 2nd Pounds
"h106b_002", -- OWN PRODUCTION UNIT Rice 1st or 2nd Pounds
"h107a_003", -- AMOUNT OF GIFTS AND OTHER SOURCES Maize white yellow etc Pounds
"h103a_004", -- AMOUNT CONSUMED IN PAST 7 DAYS Pan unit small medium large
"h107a_004", -- AMOUNT OF GIFTS AND OTHER SOURCES Pan small unit medium large
"h102_005", -- CONSUMPTION IN PAST 7 DAYS Cookies unit small medium large
"h103a_005", -- AMOUNT CONSUMED IN PAST 7 DAYS Cookies unit small medium large
"h105_005", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Cookies unit small medium large
"h107b_006", -- UNIT GIFTS AND OTHER SOURCES Cakes unit small medium large
"h107a_007", -- AMOUNT OF GIFTS AND OTHER SOURCES corn or flour tortillas Units Pounds
"h104a_008", -- AMOUNT FROM PURCHASES Cereal preparations Corn Flakes etc Grams
"h105_008", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Cereal preparations Corn Flakes etc Grams
"h102_009", -- CONSUMPTION IN PAST 7 DAYS Incaparina Pounds
"h103a_009", -- AMOUNT CONSUMED IN PAST 7 DAYS Incaparina Pounds
"h107b_009", -- UNIT GIFTS AND OTHER SOURCES Incaparina Pounds
"h103a_010", -- AMOUNT CONSUMED IN PAST 7 DAYS Corn of all kinds mosh etc Pounds
"h104a_010", -- AMOUNT FROM PURCHASES Corn of all kinds mosh etc Pounds
"h103b_011", -- UNIT CONSUMED IN PAST 7 DAYS Atoles corn glass
"h104a_012", -- AMOUNT FROM PURCHASES Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h105_012", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h107b_012", -- UNIT GIFTS AND OTHER SOURCES Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h106a_013", -- OWN PRODUCTION AMOUNT Sugar Pounds
"h107a_013", -- AMOUNT OF GIFTS AND OTHER SOURCES Sugar Pounds
"h103a_014", -- AMOUNT CONSUMED IN PAST 7 DAYS Panela rapadura Pounds
"h106b_014", -- OWN PRODUCTION UNIT Panela rapadura Pounds
"h104a_017", -- AMOUNT FROM PURCHASES corn flour Maseca Pounds
"h106a_017", -- OWN PRODUCTION AMOUNT corn flour Maseca Pounds
"h107a_017", -- AMOUNT OF GIFTS AND OTHER SOURCES corn flour Maseca Pounds
"h103a_018", -- AMOUNT CONSUMED IN PAST 7 DAYS Wheat Pounds
"h103b_018", -- UNIT CONSUMED IN PAST 7 DAYS Wheat Pounds
"h104b_018", -- UNIT FROM PURCHASES Wheat Pounds
"h106b_018", -- OWN PRODUCTION UNIT Wheat Pounds
"h103a_022", -- AMOUNT CONSUMED IN PAST 7 DAYS Noodles noodles macaroni pasta of all kinds Pounds
"h105_022", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Noodles noodles macaroni pasta of all kinds Pounds
"h103a_023", -- AMOUNT CONSUMED IN PAST 7 DAYS Soup in envelopes Mahler Maggi etc Grams
"h104a_023", -- AMOUNT FROM PURCHASES Soup in envelopes Mahler Maggi etc Grams
"h105_023", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Soup in envelopes Mahler Maggi etc Grams
"h106b_023", -- OWN PRODUCTION UNIT Soup in envelopes Mahler Maggi etc Grams
"h105_024", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Sauces and canned tomato paste Grams
"h106b_024", -- OWN PRODUCTION UNIT Sauces and tomato paste packed Grams
"h107a_024", -- AMOUNT OF GIFTS AND OTHER SOURCES Sauces and canned tomato paste Grams
"h103a_026", -- AMOUNT CONSUMED IN PAST 7 DAYS Instant Soups in glass Grams
"h104a_026", -- AMOUNT FROM PURCHASES Instant Soups in glass Grams
"h107b_027", -- UNIT GIFTS AND OTHER SOURCES Beef Pounds
"h104a_030", -- AMOUNT FROM PURCHASES Pork Pounds
"h106a_033", -- OWN PRODUCTION AMOUNT Chicken meat or chicken Pounds
"h107a_033", -- AMOUNT OF GIFTS AND OTHER SOURCES Chicken meat or chicken Pounds
"h104a_034", -- AMOUNT FROM PURCHASES Viscera giblets Pounds
"h105_034", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Viscera giblets Pounds
"h107a_034", -- AMOUNT OF GIFTS AND OTHER SOURCES Viscera giblets Pounds
"h103a_035", -- AMOUNT CONSUMED IN PAST 7 DAYS Fish fresh or dry Pounds
"h104a_035", -- AMOUNT FROM PURCHASES Fish fresh or dry Pounds
"h103a_037", -- AMOUNT CONSUMED IN PAST 7 DAYS Sardines tuna etc canned Grams
"h104a_037", -- AMOUNT FROM PURCHASES Sardines tuna etc canned Grams
"h105_037", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Sardines tuna etc canned Grams
"h104b_038", -- UNIT FROM PURCHASES Seafood shrimp crabs Pounds
"h105_039", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Ham Pounds Grams
"h103a_39a", -- AMOUNT CONSUMED IN PAST 7 DAYS Other meats like sausages sausages sausages small unit median
"h105_39a", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Other meats like sausages sausages sausages small unit median
"h102_040", -- CONSUMPTION IN PAST 7 DAYS baby milk powder Pounds
"h103b_041", -- UNIT CONSUMED IN PAST 7 DAYS Milk Powder Pounds
"h104a_041", -- AMOUNT FROM PURCHASES Milk Powder Pounds
"h106a_041", -- OWN PRODUCTION AMOUNT Milk Powder Pounds
"h103a_042", -- AMOUNT CONSUMED IN PAST 7 DAYS Fluid Milk Liters
"h104a_042", -- AMOUNT FROM PURCHASES Fluid Milk Liters
"h105_042", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Fluid Milk Liters
"h104a_044", -- AMOUNT FROM PURCHASES Eggs Units
"h105_044", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Eggs Units
"h106a_044", -- OWN PRODUCTION AMOUNT Eggs Units
"h107b_044", -- UNIT GIFTS AND OTHER SOURCES Eggs Units
"h104a_046", -- AMOUNT FROM PURCHASES Fresh Cream Liters Glass
"h104b_046", -- UNIT FROM PURCHASES Fresh Cream Liters Glass
"h105_046", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Fresh Cream Liters Glass
"h106b_046", -- OWN PRODUCTION UNIT Fresh Cream Liters Glass
"h00h", -- H00H Start Time Module H
"h00m", -- Sign H00M Minutes Module H
"h00a", -- Number H00A home
"h00b", -- H00B Enumeration area number
"h103b_001", -- UNIT CONSUMED IN PAST 7 DAYS Bean black white red etc Pounds
"h104b_001", -- UNIT FROM PURCHASES Bean black white red etc Pounds
"h106a_001", -- OWN PRODUCTION AMOUNT Bean black white red etc Pounds
"h102_002", -- CONSUMPTION IN PAST 7 DAYS Rice 1st or 2nd Pounds
"h103a_002", -- AMOUNT CONSUMED IN PAST 7 DAYS Rice 1st or 2nd Pounds
"h103b_002", -- UNIT CONSUMED IN PAST 7 DAYS Rice 1st or 2nd Pounds
"h104a_003", -- AMOUNT FROM PURCHASES Maize white yellow etc Pounds
"h105_003", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Maize white yellow etc Pounds
"h106a_003", -- OWN PRODUCTION AMOUNT Maize white yellow etc Pounds
"h103b_004", -- UNIT CONSUMED IN PAST 7 DAYS Pan unit small medium large
"h104a_004", -- AMOUNT FROM PURCHASES Pan small unit medium large
"h105_004", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Pan small unit medium large
"h103b_005", -- UNIT CONSUMED IN PAST 7 DAYS Cookies unit small medium large
"h104a_005", -- AMOUNT FROM PURCHASES Cookies unit small medium large
"h104b_005", -- UNIT FROM PURCHASES Cookies unit small medium large
"h107a_005", -- AMOUNT OF GIFTS AND OTHER SOURCES Cookies unit small medium large
"h103a_006", -- AMOUNT CONSUMED IN PAST 7 DAYS Cakes unit small medium large
"h103b_006", -- UNIT CONSUMED IN PAST 7 DAYS Cakes unit small medium large
"h105_006", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Cakes unit small medium large
"h103a_007", -- AMOUNT CONSUMED IN PAST 7 DAYS corn or flour tortillas Units Pounds
"h103b_007", -- UNIT CONSUMED IN PAST 7 DAYS corn or flour tortillas Units Pounds
"h104a_007", -- AMOUNT FROM PURCHASES corn or flour tortillas Units Pounds
"h105_007", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES corn or flour tortillas Units Pounds
"h103a_008", -- AMOUNT CONSUMED IN PAST 7 DAYS Cereal preparations Corn Flakes etc Grams
"h104a_009", -- AMOUNT FROM PURCHASES Incaparina Pounds
"h105_009", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Incaparina Pounds
"h102_010", -- CONSUMPTION IN PAST 7 DAYS Corn of all kinds mosh etc Pounds
"h105_010", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Corn of all kinds mosh etc Pounds
"h107a_010", -- AMOUNT OF GIFTS AND OTHER SOURCES Corn of all kinds mosh etc Pounds
"h103a_011", -- AMOUNT CONSUMED IN PAST 7 DAYS Atoles corn glass
"h104a_011", -- AMOUNT FROM PURCHASES Atoles corn glass
"h105_011", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Atoles corn glass
"h107a_011", -- AMOUNT OF GIFTS AND OTHER SOURCES Atoles corn glass
"h103a_012", -- AMOUNT CONSUMED IN PAST 7 DAYS Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h103b_012", -- UNIT CONSUMED IN PAST 7 DAYS Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h104b_012", -- UNIT FROM PURCHASES Other gruel rice milk gruel platana Atolillo shuco etc vessel
"h102_013", -- CONSUMPTION IN PAST 7 DAYS Sugar Pounds
"h103a_013", -- AMOUNT CONSUMED IN PAST 7 DAYS Sugar Pounds
"h104a_013", -- AMOUNT FROM PURCHASES Sugar Pounds
"h105_013", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Sugar Pounds
"h104a_014", -- AMOUNT FROM PURCHASES Panela rapadura Pounds
"h104b_014", -- UNIT FROM PURCHASES Panela rapadura Pounds
"h105_014", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Panela rapadura Pounds
"h103a_017", -- AMOUNT CONSUMED IN PAST 7 DAYS corn flour Maseca Pounds
"h105_017", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES corn flour Maseca Pounds
"h104a_018", -- AMOUNT FROM PURCHASES Wheat Pounds
"h105_018", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Wheat Pounds
"h106a_018", -- OWN PRODUCTION AMOUNT Wheat Pounds
"h104a_022", -- AMOUNT FROM PURCHASES Noodles noodles macaroni pasta of all kinds Pounds
"h106a_022", -- OWN PRODUCTION AMOUNT Noodles noodles macaroni pasta of all kinds Pounds
"h106b_022", -- OWN PRODUCTION UNIT Noodles noodles macaroni pasta of all kinds Pounds
"h102_023", -- CONSUMPTION IN PAST 7 DAYS Soup in envelopes Mahler Maggi etc Grams
"h102_024", -- CONSUMPTION IN PAST 7 DAYS Sauces and canned tomato paste Grams
"h103a_024", -- AMOUNT CONSUMED IN PAST 7 DAYS Sauces and canned tomato paste Grams
"h104a_024", -- AMOUNT FROM PURCHASES Sauces and tomato paste packed Grams
"h105_026", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Instant Soups in glass Grams
"h103a_027", -- AMOUNT CONSUMED IN PAST 7 DAYS Beef Pounds
"h103b_027", -- UNIT CONSUMED IN PAST 7 DAYS Beef Pounds
"h104a_027", -- AMOUNT FROM PURCHASES Beef Pounds
"h106a_027", -- OWN PRODUCTION AMOUNT Beef Pounds
"h105_030", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Pork Pounds
"h106a_030", -- OWN PRODUCTION AMOUNT Pork Pounds
"h102_033", -- CONSUMPTION IN PAST 7 DAYS Chicken meat or chicken Pounds
"h103a_033", -- AMOUNT CONSUMED IN PAST 7 DAYS Chicken meat or chicken Pounds
"h104a_033", -- AMOUNT FROM PURCHASES Chicken meat or chicken Pounds
"h105_033", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Chicken meat or chicken Pounds
"h106a_034", -- OWN PRODUCTION AMOUNT Viscera giblets Pounds
"h105_035", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Fish fresh or dry Pounds
"h106a_037", -- OWN PRODUCTION AMOUNT Sardines tuna etc canned Grams
"h102_038", -- CONSUMPTION IN PAST 7 DAYS Seafood shrimp crabs Pounds
"h103a_038", -- AMOUNT CONSUMED IN PAST 7 DAYS Seafood shrimp crabs Pounds
"h105_038", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Seafood shrimp crabs Pounds
"h104a_039", -- AMOUNT FROM PURCHASES Ham Pounds Grams
"h106a_039", -- OWN PRODUCTION AMOUNT Ham Pounds Grams
"h106b_39a", -- OWN PRODUCTION UNIT Other meats like sausages sausages sausages small unit median
"h107b_39a", -- UNIT GIFTS AND OTHER SOURCES Other meats like sausages sausages sausages small unit median
"h103a_040", -- AMOUNT CONSUMED IN PAST 7 DAYS baby milk powder Pounds
"h104b_040", -- UNIT FROM PURCHASES Milk powder for baby Pounds
"h107b_040", -- UNIT GIFTS AND OTHER SOURCES baby milk powder Pounds
"h103a_041", -- AMOUNT CONSUMED IN PAST 7 DAYS Milk Powder Pounds
"h105_041", -- MONEY SPENT ON AMOUNT CONSUMED IN PAST 7 DAYS FROM PURCHASES Milk Powder Pounds
"h106a_042", -- OWN PRODUCTION AMOUNT Fluid Milk Liters
"h106b_042", -- OWN PRODUCTION UNIT Fluid Milk Liters
"h103a_044", -- AMOUNT CONSUMED IN PAST 7 DAYS Eggs Units
"h107a_044", -- AMOUNT OF GIFTS AND OTHER SOURCES Eggs Units
"h103a_046", -- AMOUNT CONSUMED IN PAST 7 DAYS Fresh Cream Liters Glass
"h102_047" -- CONSUMPTION IN PAST 7 DAYS Fresh drive Pounds
FROM
"usaid-gov/guatemala-food-consumption-data-section-1-pcma-mau9:latest"."guatemala_food_consumption_data_section_1"
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-1-pcma-mau9 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-1-pcma-mau9: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-1-pcma-mau9Checkout 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-1-pcma-mau9:latestThis will download all the objects for the latest tag of usaid-gov/guatemala-food-consumption-data-section-1-pcma-mau9 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-1-pcma-mau9: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-1-pcma-mau9: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-1-pcma-mau9 is just another Postgres schema.