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 new_york_city_work_and_family_leave_survey_wfls table in this repository, by referencing it like:
"cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe:latest"."new_york_city_work_and_family_leave_survey_wfls"or in a full query, like:
SELECT
":id", -- Socrata column ID
"sc4a_1", -- SC4A. What's not correct? (MENTION #1)1=name is different 2=date of birth is different 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"pop_weight", -- Final Weight Numberd to population size
"samp_weight", -- Final Weight Numberd to number of completed interviews
"lang", -- LANG. (INTERVIEWER: DO NOT READ THIS TO RESPONDENT) In what language was this interview completed?1=English 2=Spanish
"es3", -- ES.3. During the past 12 months, what was your yearly total household income before taxes? Include your income, your husband's or partner's income, and any other income you may have received.1=$0 to $16,000 2=$16,001 to $20,000 3=$20,001 to $24,000 4=$24,001 to $28,000 5=$28,001 to $32,000 6=$32,001 to $40,000 7=$40,001 to $48,000 8=$48,001 to $57,000 9=$57,001 to $60,000 10=$60,001 to $73,000 11=$73,001 to $85,000 12=$85,001 or more 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"es2", -- ES.2. In the last 30 days, have you been concerned about having enough food for you or your family?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"es1b", -- (Did/do you receive any of the following services? ES.1b. Welfare/Public Assistance? Was this...1=During pregnancy 2=After Birth 3=Both 4=Neither 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"st5", -- (The next questions are about things that may have happened during your pregnancy or in the 12 months after your child was born:) ST.5. I had problems paying the rent, mortgage, or other bills. (Did this happen...)1=During pregnancy 2=After Birth 3=Both 4=Neither 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"de3", -- DE.3. Where was [CP/your partner or spouse] born? Please tell me the country.1=United States of America 2=OTHER (SPECIFY) 5 =AFRICA 6 =ALBANIA 7=ANTIGUA 8 =ARGENTINA 9 =AUSTRALIA 10 =AUSTRIA 11 =BANGLADESH 12 =BARBADOS 13 =BELARUS 14 =BELIZE 15 =BOLIVIA 16 =BRAZIL 17 =CANADA 18 =CARIBBEAN 19 =CENTRAL AFRICA 20 =CHILE 21 =CHINA 22 =COLUMBIA 23 =COSTA RICA 24 =CUBA 25 =CZECHOSLOVAKIA 26 =DOMINICAN REPUBLIC 27 =EASTERN AFRICA 28 =ECUADOR 29 =EGYPT 30 =EL SALVADOR 31 =ENGLAND 32 =EUROPE 33 =FRANCE 34 =GERMANY 35 =GHANA 36 =GREECE 37 =GRENADA 38 =GUATEMALA 39 =GUINEA 40 =GUYANA 41 =HAITI 42 =HONDURAS 43 =HONG KONG 44 =HUNGARY 45 =INDIA 46 =IRAN 47 =IRELAND 48 =ISRAEL 49 =ITALY 50= JAMAICA 51 =JAPAN 52 =KOREA 53 =LIBERIA 54= MALAYSIA 55 =MALI 56 =MEXICO 57 =NICARAGUA 58 =NIGERIA 59 =NORTHERN AFRICA 60 =PAKISTAN 61 =PANAMA 62 =PERU 63 =PHILIPPINES 64 =POLAND 65 =PUERTO RICO 66 =ROMANIA 67 =RUSSIA 68 =SENEGAL 69 =SIERRA LEONE 70 =SOUTH AMERICAN 71 =SOUTHERN AFRICA 72 =SPAIN 73 =ST. LUCIA 74 =ST. VINCENT 75 =TAIWAN 76 =TRINIDAD AND TOBAGO 77 =(VOL) DON'T KNOW 78 =TURKEY 79 =UKRAINE 80 =UNITED KINGDOM (INCLUDES ENGLAND, N. IRELAND, SCOTLAND, WALES) 81= UZBEKISTAN 82 =VENEZUELA 83 =VIETNAM 84 =VIRGIN ISLANDS 85 =WEST INDIAN 86 =WESTERN AFRICA 87 =YUGOSLAVIA
"de2_2", -- DE.2. Which one or more of the following would you say is [CP/your partner or spouse]'s race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #2)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"de2_1", -- DE.2. Which one or more of the following would you say is [CP/your partner or spouse]'s race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #1)
"d7", -- D.7. What is the highest grade or year of school you completed?1=Never attended school or only attended kindergarten 2=Grades 1 through 8 (ELEMENTARY) 3=Grades 9 through 11 (SOME HIGH SCHOOL) 4=Grade 12 or GED (HIGH SCHOOL GRADUATE) 5=College 1 year to 3 years (SOME COLLEGE OR TECHNICAL SCHOOL) 6=College 4 years or more (COLLEGE GRADUATE) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d4_6", -- D.4. Which one or more of the following would you say is your race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #6)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d4_1", -- D.4. Which one or more of the following would you say is your race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #1)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d3", -- D.3. Are you Hispanic or Latino?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sd2", -- SD.2. While you are away from your child for work, how often do you feel that HE/SHE is well cared for?1=Always 2=Often 3=Sometimes 4=Rarely 5=Never 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cc1", -- CC.1. Which one of the following people spends the most time taking care of your child when you are at work? Is it:1=My husband or partner 2=Child's Grandparent 3=Other close family member or relative 4=Friend or neighbor 5=Babysitter, nanny, or other child care provider in your home 6=Staff at day care, nursery, or preschool 7=Child is with me while I am at work 8=Someone else (specify) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"mh4", -- MH.4. During the first year of [CHILDNAME]/your child's life, would you say that, in general, your health was--1=Excellent 2=Very good 3=Good 4=Fair 5=Poor 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"mh3a", -- MH.3a. What treatment did you receive? Was it counseling, medication or both?1=Counseling 2=Medication 3=Both 4=Other (Specify) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"mh1", -- MH.1. During the first year of [CHILDNAME]/your child's life, how often did you experience significant depression that interfered with your life activities for a period of more than 2 weeks?1=Always 2=Often 3=Sometimes 4=Rarely 5=Never 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1awks", -- [ENTER NUMBER OF WEEKS] BF.1.a. How old was your baby the first time HE/SHE ate or drank something other than breastmilk:
"bf1a_2", -- BF.1.a. How old was your baby the first time HE/SHE ate or drank something other than breastmilk: (MENTION #2)1=Less than one week 2=Answered in weeks 3=Answered in months 4=(VOL) Never 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1a_1", -- BF.1.a. How old was your baby the first time HE/SHE ate or drank something other than breastmilk: (MENTION #1)1=Less than one week 2=Answered in weeks 3=Answered in months 4=(VOL) Never 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1mns", -- [ENTER NUMBER OF MONTHS] BF.1. How many weeks or months did you breastfeed or pump milk to feed your child?
"bf1_2", -- BF.1. How many weeks or months did you breastfeed or pump milk to feed your child? (MENTION #2)1=Never 2=Less than 1 week 3=Weeks 4=Months 5=Still breastfeeding 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih5a_3", -- IH.5.a. Why didn't your child receive the needed care? (Select ALL that apply) (MENTION #3)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih5a_1", -- IH.5.a. Why didn't your child receive the needed care? (Select ALL that apply) (MENTION #1)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih5", -- IH.5. During the first year of [CHILDNAME]/your child's life, was there any time when [CHILDNAME]/your child needed medical care but DID NOT get it?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih4_5", -- IH.4. Did any of these things keep your child from having a well-baby checkup during the first year of their life? (Select ALL that apply) (MENTION #5)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih4_3", -- IH.4. Did any of these things keep your child from having a well-baby checkup during the first year of their life? (Select ALL that apply) (MENTION #3)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih4_1", -- IH.4. Did any of these things keep your child from having a well-baby checkup during the first year of their life? (Select ALL that apply) (MENTION #1)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp10mns", -- [ENTER NUMBER OF MONTHS] CP.10. How many weeks or months of leave, in total, did [CP]/HE/SHE take?
"cp8", -- CP.8. During the twelve months before you gave birth to [CHILDNAME]/your child, how many hours per week did [CP]/HE/SHE work on average?666=(VOL) WAS NOT WORKING 777=(VOL) DON'T KNOW 999= (VOL) REFUSED
"cp7", -- CP.7. During the twelve months before you gave birth to [CHILDNAME]/your child, did [CP]/HE/SHE work continuously for the same employer?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp6c", -- CP.6c. During the first 12 months after [CHILDNAME]/your child was born, how often did [CP]/HE/SHE do the following things with your child? Wash or bathe or dress him/her? Did [CP]/HE/SHE do this...1=More than once a day 2=About once a day 3=A few times a week 4=A few times a month 5=Rarely 6=Not at all 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp6a", -- CP.6a. During the first 12 months after [CHILDNAME]/your child was born, how often did [CP]/HE/SHE do the following things with your child? Change diapers? Did [CP]/HE/SHE do this...1=More than once a day 2=About once a day 3=A few times a week 4=A few times a month 5=Rarely 6=Not at all 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp2", -- CP.2. Please give me a first name or initial so that I can refer to this person for the next set of questions.1=Gave Response 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el17f", -- El17f. Did any of these situations affect your decision about taking leave from work after [CHILDNAME]/your child was born? I needed health insurance that is provided by my employer.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el17a", -- El17a. Did any of these situations affect your decision about taking leave from work after [CHILDNAME]/your child was born? I could not financially afford to take leave or as much leave as I would have liked (OR MORE LEAVE).1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el16", -- EL.16. Which of the following best describes why you are not currently employed?1=I was fired for a reason relating to the pregnancy, birth or maternity leave. 2=I wanted to stay home full-time with my baby. 3=I could not arrange a schedule flexible enough to meet our needs. 4=I could not find acceptable childcare that I could afford. 5=I had a health problem that kept me from returning to work. 6=My baby had health problems that kept me from returning to work. 7=I am a student/Getting ready to go back to school. 8=I cannot find work. 9=I'm currently seeking employment. 10=OTHER (specify) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el13c", -- EL.13c. How many WEEKS of pay did you receive from each of these sources: Employer provided maternity leave?77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el12mns", -- [ENTER NUMBER OF WEEKS] EL.12. How many weeks or months of leave, in total, did you take?
"el12_3", -- EL.12. How many weeks or months of leave, in total, did you take? (MENTION #2)1=Less than one week 2=Answered in weeks 3=Answered in months 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el12_2", -- EL.12. How many weeks or months of leave, in total, did you take? (MENTION #1)1=Less than one week 2=Answered in weeks 3=Answered in months 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el12_1", -- EL.12. How many weeks or months of leave, in total, did you take? (MENTION #1)1=Less than one week 2=Answered in weeks 3=Answered in months 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el11", -- EL.11. Which of the following describes the leave or time you took off from work after [CHILDNAME]/your child was born?1=I took paid leave from my job 2=I took unpaid leave from my job 3=I took both paid and unpaid leave 4=I did not take any leave or time off 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el10", -- EL.10. During the twelve months before you gave birth to [CHILDNAME]/your child, how many hours per week did you work on average? 777=(VOL) DON'T KNOW 999= (VOL) REFUSED
"el7", -- EL.7. At the place where you worked (on your main job) during your pregnancy-- for example the site, store, or building -- would you say there were 50 or more employees?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el4", -- EL.4. In what state was that job located?1=New York 2=New Jersey 3=Another State 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"pph2c", -- PPH.2c. Did any of these things keep you from having a postpartum checkup? I couldn't get time off work.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bc1a", -- BC.1a. In what month did you give birth to [CHILDNAME]/the child that you gave birth to in 2014?1=January 2=February 3=March 4=April 5=May 6=June 7=July 8=August 9=September 10=October 11=November 12=December 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc6", -- SC6. Are you at least 18 years old?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc4d", -- SC4D. For purposes of this survey our system has randomly selected your [SELECTEDCHILD] child. For questions about this child, I can refer to them as THE [SELECTEDCHILD] child born in 2014 or by their name or nickname [Enter name/nickname if given].1=Yes, gave name 2=NO, REFER TO MY CHILD AS 'YOUR CHILD BORN IN 2014' 66=(VOL) NO LONGER HAVE THE CHILD LIVING WITH ME 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc4b1", -- SC4B.1. How many children did you give birth to in 2014?77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc4b", -- SC4B. Did you give birth to a child in New York City in 2014?1=Yes 2=Yes, I gave birth to more than one child in 2014 3=No 66=(VOL) YES, GAVE BIRTH BUT NO LONGER HAVE THE CHILD LIVING WITH ME 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc4", -- SC4. Just to make sure I'm speaking to the correct person, can you confirm your name and year of birth? I have on file: NAME: [RESPNAME] YEAR OF BIRTH: [YOB]1=information matches 2=no 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc3", -- SC3. Are you driving?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc2", -- SC2. Are you in a safe place to talk right now? [IF DRIVING VOLUNTEERED, CODE AS 2]1=Yes, safe place to talk 2=No, call me later 3=No, CB on land-line 4=On landline 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"qkey", -- Sample key number
"qrep", -- Sample replicate
"fdate", -- End date of interview
"es1a", -- (Did/do you receive any of the following services? ES.1a. Food stamps or money to buy food? Was this...1=During pregnancy 2=After Birth 3=Both 4=Neither 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d5", -- D.5. Where were you born? Please tell me the country.1=United States of America 2=OTHER (SPECIFY) 5 =AFRICA 6 =ALBANIA 7=ANTIGUA 8 =ARGENTINA 9 =AUSTRALIA 10 =AUSTRIA 11 =BANGLADESH 12 =BARBADOS 13 =BELARUS 14 =BELIZE 15 =BOLIVIA 16 =BRAZIL 17 =CANADA 18 =CARIBBEAN 19 =CENTRAL AFRICA 20 =CHILE 21 =CHINA 22 =COLUMBIA 23 =COSTA RICA 24 =CUBA 25 =CZECHOSLOVAKIA 26 =DOMINICAN REPUBLIC 27 =EASTERN AFRICA 28 =ECUADOR 29 =EGYPT 30 =EL SALVADOR 31 =ENGLAND 32 =EUROPE 33 =FRANCE 34 =GERMANY 35 =GHANA 36 =GREECE 37 =GRENADA 38 =GUATEMALA 39 =GUINEA 40 =GUYANA 41 =HAITI 42 =HONDURAS 43 =HONG KONG 44 =HUNGARY 45 =INDIA 46 =IRAN 47 =IRELAND 48 =ISRAEL 49 =ITALY 50= JAMAICA 51 =JAPAN 52 =KOREA 53 =LIBERIA 54= MALAYSIA 55 =MALI 56 =MEXICO 57 =NICARAGUA 58 =NIGERIA 59 =NORTHERN AFRICA 60 =PAKISTAN 61 =PANAMA 62 =PERU 63 =PHILIPPINES 64 =POLAND 65 =PUERTO RICO 66 =ROMANIA 67 =RUSSIA 68 =SENEGAL 69 =SIERRA LEONE 70 =SOUTH AMERICAN 71 =SOUTHERN AFRICA 72 =SPAIN 73 =ST. LUCIA 74 =ST. VINCENT 75 =TAIWAN 76 =TRINIDAD AND TOBAGO 77 =(VOL) DON'T KNOW 78 =TURKEY 79 =UKRAINE 80 =UNITED KINGDOM (INCLUDES ENGLAND, N. IRELAND, SCOTLAND, WALES) 81= UZBEKISTAN 82 =VENEZUELA 83 =VIETNAM 84 =VIRGIN ISLANDS 85 =WEST INDIAN 86 =WESTERN AFRICA 87 =YUGOSLAVIA 99=(VOL) REFUSED
"d4_4", -- D.4. Which one or more of the following would you say is your race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #4)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d1yob", -- ENTER YEAR OF BIRTH
"mh3", -- MH.3. During the first year of [CHILDNAME]/your child's life, did you receive treatment for your depression?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"mh2", -- MH.2. During the first year of [CHILDNAME]/your child's life, did a doctor, nurse, or other health care worker tell you that you had depression?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih5a_4", -- IH.5.a. Why didn't your child receive the needed care? (Select ALL that apply) (MENTION #4)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih2", -- IH.2. During the first year of [CHILDNAME]/your child's life, did HE/SHE have all recommended well-baby visits? A well-baby visit is a regular visit with a doctor for your baby usually at 2 weeks and then 1, 2, 4, 6 and 12 months of age.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih1", -- IH.1. In general, how is [CHILDNAME]/your child's physical health? Would you say it is excellent, very good, good, fair, or poor?1=Excellent 2=Very good 3=Good 4=Fair 5=Poor 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp6b", -- CP.6b. During the first 12 months after [CHILDNAME]/your child was born, how often did [CP]/HE/SHE do the following things with your child? Prepare or feed meals or bottles? Did [CP]/HE/SHE do this...1=More than once a day 2=About once a day 3=A few times a week 4=A few times a month 5=Rarely 6=Not at all 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp5", -- CP.5. Thinking back to the first 12 months after [CHILDNAME]/your child was born, how available was [CP]/HE/SHE to help you care for yourself and your new baby?1=Always 2=Often 3=Sometimes 4=Rarely 5=Never 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp1", -- CP.1. Was there another person such as a spouse or partner helping with [CHILDNAME]/your child when he/she was born in 2014? This could be someone living in your household or somewhere else?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el17c", -- El17c. Did any of these situations affect your decision about taking leave from work after [CHILDNAME]/your child was born? My job does not have paid leave.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el13d", -- EL.13d. How many WEEKS of pay did you receive from each of these sources: Unpaid?77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el8", -- EL.8. Please think now of all of your organization's work sites within 75 miles at the time of your pregnancy. How many people were employed at your organization across all of the work sites within that 75 mile range, including your worksite?1=1-9 2=10-19 3=20-29 4=30-39 5=40-49 6=50-99 7=100-249 8=250-499 9=500 or more 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el3", -- EL.3. During your pregnancy, were you employed by government, by a private company, a nonprofit organization, or were you self-employed?1=Government 2=Private-for-profit company 3=Non-profit organization including tax exempt and charitable organizations 4=Self-employed 5=(VOL) OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el1", -- EL.1. At any time during your pregnancy, did you work at a job for pay?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"pph2b", -- PPH.2b. Did any of these things keep you from having a postpartum checkup? I didn't have anyone to take care of my other children.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"pph2a", -- PPH.2a. Did any of these things keep you from having a postpartum checkup? I didn't have enough money or insurance to pay for it.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bc3", -- BC.3. After [CHILDNAME]/the child that you gave birth to in 2014 was delivered, how long did [he/she] stay in the hospital? (READ IF NECESSARY)1=Less than 24 hours (less than 1 day) 2=24 to 48 hours (1 to 2 days) 3=3 to 5 days 4=6 to 14 days 5=More than 14 days 6=My baby was not born in a hospital 7=My baby is still in the hospital 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bc1", -- BC.1. Just to confirm, did you give birth to a single baby or more than one?1=Single 2=More than me 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc5", -- SC5. It is important that I speak directly to [RESPNAME]. Do you know when she will be home?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc4d1", -- SC4D.1. Is [CHILDNAME]/your child born in 2014 male or female?1=Male 2=Female 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"selchild", -- IF SC4B.2=1 RANDOMLY SELECT NUMBER BETWEEN 1 AND SC4B.1, CREATE VARIABLE SELCHILD TO STORE SELECTED CHILD] 1 'FIRST' 2 'SECOND' 3 'THIRD' 4 'FOURTH'1=first 2=second 3=third 4=fourth
"sc4b2", -- SC4B.2. Were these children born together or in separate births?1=yes multiple births 2=no, separate births 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"resp", -- Respondent ID
"odate", -- Original start date
"qc1", -- QC.1. Would you like any of these phone numbers?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"fulladra", -- Did we get all the address asked for?1=Yes 2=No
"es4", -- ES.4. How many people, including yourself, depend on this income? NUMBER OF PEOPLE 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"st4", -- (The next questions are about things that may have happened during your pregnancy or in the 12 months after your child was born:) ST.4. My husband, partner, or I had a cut in work hours or pay. (Did this happen...)1=During pregnancy 2=After Birth 3=Both 4=Neither 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"st3", -- (The next questions are about things that may have happened during your pregnancy or in the 12 months after your child was born:) ST.3. I lost my job even though I wanted to go on working. (Did this happen...)1=During pregnancy 2=After Birth 3=Both 4=Neither 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"st2", -- (The next questions are about things that may have happened during your pregnancy or in the 12 months after your child was born:) ST.2. My husband or partner lost his/her job. (Did this happen...)1=During pregnancy 2=After Birth 3=Both 4=Neither 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"st1", -- (The next questions are about things that may have happened during your pregnancy or in the 12 months after your child was born:) ST.1. I was homeless or had to sleep outside, in a car, or in a shelter. Did this happen...
"de2_6", -- DE.2. Which one or more of the following would you say is [CP/your partner or spouse]'s race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #6)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"de2_5", -- DE.2. Which one or more of the following would you say is [CP/your partner or spouse]'s race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #5)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"de2_4", -- DE.2. Which one or more of the following would you say is [CP/your partner or spouse]'s race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #4)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"de2_3", -- DE.2. Which one or more of the following would you say is [CP/your partner or spouse]'s race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #3)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"de1", -- DE.1. Is [CP/your partner or spouse] Hispanic or Latino?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d6", -- D.6. How long have you lived in the United States? (READ IF NEEDED:)1=Less than 5 years 2=5 to 9 years 3=10 or more years 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d4_5", -- D.4. Which one or more of the following would you say is your race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #5)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d4_3", -- D.4. Which one or more of the following would you say is your race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #3)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d4_2", -- D.4. Which one or more of the following would you say is your race? (READ ANSWER CHOICES, MULTIPLE RESPONSE:) (MENTION #2)1=White 2=Black or African American 3=Asian 4=Native Hawaiian or Other Pacific Islander 5=American Indian, Alaska Native, or 8=Something else (SPECIFY) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"fixd2", -- Zip code
"d2", -- D.2. What is your zip code?1=Gave Response 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"d1", -- D.1. Now I have just a few questions about you and your household. First, what is your date of birth?1=Gave Response 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sd1mns", -- [ENTER NUMBER OF MONTHS] SD.1. How old was [CHILDNAME]/your child born in 2014 when HE/SHE first went to childcare?
"sd1wks", -- [ENTER NUMBER OF WEEKS] SD.1. How old was [CHILDNAME]/your child born in 2014 when HE/SHE first went to childcare?1=Answered in weeks 2=Answered in months 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sd1_1", -- SD.1. How old was [CHILDNAME]/your child born in 2014 when HE/SHE first went to childcare? (MENTION #1)
"bf2", -- BF.2. What was the MAIN reason you stopped breastfeeding or pumping?1=I thought I was not producing enough milk for my baby 2=It was too time consuming 3=I felt it was the right time to stop breastfeeding 4=I got sick or I had to stop for medical reasons 5=I went back to work 6=I went back to school 7=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1amns", -- [ENTER NUMBER OF MONTHS] BF.1.a. How old was your baby the first time HE/SHE ate or drank something other than breastmilk.
"bf1a_4", -- BF.1.a. How old was your baby the first time HE/SHE ate or drank something other than breastmilk: (MENTION #4)1=Less than one week 2=Answered in weeks 3=Answered in months 4=(VOL) Never 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1a_3", -- BF.1.a. How old was your baby the first time HE/SHE ate or drank something other than breastmilk: (MENTION #3)1=Less than one week 2=Answered in weeks 3=Answered in months 4=(VOL) Never 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1wks", -- [ENTER NUMBER OF WEEKS] BF.1. How many weeks or months did you breastfeed or pump milk to feed your child?
"bf1_5", -- BF.1. How many weeks or months did you breastfeed or pump milk to feed your child? (MENTION #5)1=Never 2=Less than 1 week 3=Weeks 4=Months 5=Still breastfeeding 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1_4", -- BF.1. How many weeks or months did you breastfeed or pump milk to feed your child? (MENTION #4)1=Never 2=Less than 1 week 3=Weeks 4=Months 5=Still breastfeeding 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1_3", -- BF.1. How many weeks or months did you breastfeed or pump milk to feed your child? (MENTION #3)1=Never 2=Less than 1 week 3=Weeks 4=Months 5=Still breastfeeding 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bf1_1", -- BF.1. How many weeks or months did you breastfeed or pump milk to feed your child? (MENTION #1)1=Never 2=Less than 1 week 3=Weeks 4=Months 5=Still breastfeeding 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih5a_2", -- IH.5.a. Why didn't your child receive the needed care? (Select ALL that apply) (MENTION #2)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih4_4", -- IH.4. Did any of these things keep your child from having a well-baby checkup during the first year of their life? (Select ALL that apply) (MENTION #4)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ih3", -- IH.3. During the first year of [CHILDNAME]/your child's life, was your child up-to-date on vaccinations?1=Yes, on schedule 2=Partial/missing a few 3=Not vaccinated 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp10wks", -- [ENTER NUMBER OF WEEKS] CP.10. How many weeks or months of leave, in total, did [CP]/HE/SHE take?
"cp10_3", -- CP.10. How many weeks or months of leave, in total, did [CP]/HE/SHE take? (MENTION #3)1=Less than one week 2=Answered in weeks 3=Answered in months 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp10_2", -- CP.10. How many weeks or months of leave, in total, did [CP]/HE/SHE take? (MENTION #2)1=Less than one week 2=Answered in weeks 3=Answered in months 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp10_1", -- CP.10. How many weeks or months of leave, in total, did [CP]/HE/SHE take? (MENTION #1)1=Less than one week 2=Answered in weeks 3=Answered in months 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp9", -- CP.9. Which of the following describes the leave or time [CP]/HE/SHE took off from work after [CHILDNAME]/your child born in 2014 was born?1=He/she took paid leave from his/her job 2=He/she took unpaid leave from his/her job 3=He/she took both paid and unpaid leave 4=He/she did not take any leave or time off 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp4", -- CP.4. Did [CP]/HE/SHE live with you or somewhere else when [CHILDNAME]/your child was born?1=Yes, lived with me 2=No, lived somewhere else 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el17e", -- El17e. Did any of these situations affect your decision about taking leave from work after [CHILDNAME]/your child was born? I was ready to go back to work.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el17d", -- El17d. Did any of these situations affect your decision about taking leave from work after [CHILDNAME]/your child was born? I had not built up enough leave time to take any or more time off.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el17b", -- El17b. Did any of these situations affect your decision about taking leave from work after [CHILDNAME]/your child was born? I was afraid I'd lose my job if I took leave or stayed out longer.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el15", -- EL.15. Did you return to the job you had during your pregnancy?1=Yes 2=No 3=No, but I will be returning 4=No, but returned to a different job 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el14", -- EL.14. How did you feel about the amount of time you were able to take off after the birth of [CHILDNAME]/your child? Did you feel it was too little time, just the right amount of time, or too much time?1=Too little time 2=Just the right amount of time 3=Too much time 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el13e", -- EL.13e. How many WEEKS of pay did you receive from each of these sources: Other (specify)?77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el13b", -- EL.13b. How many WEEKS of pay did you receive from each of these sources: Temporary disability insurance?77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el13a", -- EL.13a. How many WEEKS of pay did you receive from each of these sources: Earned weeks (sick and/or vacation)?77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"el12wks", -- [ENTER NUMBER OF WEEKS] EL.12. How many weeks or months of leave, in total, did you take?
"el9", -- EL.9. During the twelve months before you gave birth to [CHILDNAME]/your child did you work continuously for the same employer (on your main job)?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"pph1", -- PPH.1. After [CHILDNAME]/the child that you gave birth to in 2014 was born, did you have a postpartum checkup for yourself? A postpartum checkup is the regular checkup a woman has about 4-6 weeks after she gives birth.1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"bc2", -- BC.2. How was/were your baby/babies delivered?1=Vaginally 2=Cesarean delivery (C-section) 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc4c", -- SC4C. What is your name?1=gave name 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"cp3", -- CP.3. Is [CP]/this person male or female?1=Male 2=Female 3=Other 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"qcell", -- Sample cell phone flag0=No 1=Yes
"clientid", -- Client ID number
"sc4a_2", -- SC4A. What's not correct? (MENTION #2)1=name is different 2=date of birth is different 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc6a", -- SC6A. Do you have any questions about this survey, the study or your rights as a study participant?1=Yes 2=No
"sc7", -- SC7. Shall we begin?1=Yes 2=No 66=(VOL) NO LONGER HAVE THE CHILD LIVING WITH ME 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"mp1", -- MP.1. Before the birth of [CHILDNAME]/your child born in 2014, how many children had you given birth to?77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"ph1", -- PH.1. Before you got pregnant, would you say that, in general, your health was...1=Excellent 2=Very good 3=Good 4=Fair 5=Poor 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sc1", -- SC1. Hello, my name is [INTERVIEWERNAME]...This survey is about parental leave from work around the birth of a child. If you qualify for the study, we will send you $15 as a thank you for answering our questions. May I please speak to [RESPNAME]?1=SPEAKING TO RESPONDENT 2=RESPONDENT COMES TO PHONE 3=NOT A GOOD TIME 4=RESPONDENT NOT AVAILABLE 5=NO SUCH PERSON 66=(VOL) GAVE BIRTH BUT NO LONGER HAVE THE CHILD LIVING WITH ME 77=(VOL) DON'T KNOW 99=(VOL) REFUSED
"ih4_2", -- IH.4. Did any of these things keep your child from having a well-baby checkup during the first year of their life? (Select ALL that apply) (MENTION #2)1=I didn't have enough money or insurance to pay for it 2=I didn't have anyone to take care of my other children 3=I couldn't get time off work 4=I didn't have enough sick/vacation time to take time off work 5=My child seemed fine and I did not think he/she needed to have a visit 6=(VOL) NONE OF THE ABOVE/OTHER 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"sd1_2", -- SD.1. How old was [CHILDNAME]/your child born in 2014 when HE/SHE first went to childcare? (MENTION #2)1=Answered in weeks 2=Answered in months 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"stratum" -- Stratum Variable (should be used when calculating variance)1 or 2
FROM
"cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe:latest"."new_york_city_work_and_family_leave_survey_wfls"
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 cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe with SQL in under 60 seconds.
This repository is an "external" repository. That means it's hosted elsewhere, in this case at data.cityofnewyork.us. When you querycityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe: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.cityofnewyork.us, 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 \
"cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe" \
--handler-options '{
"domain": "data.cityofnewyork.us",
"tables": {
"new_york_city_work_and_family_leave_survey_wfls": "grnn-mvqe"
}
}'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, cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe is just another Postgres schema.