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
"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
"de1", -- DE.1. Is [CP/your partner or spouse] Hispanic or Latino?1=Yes 2=No 77=(VOL) DON'T KNOW 99= (VOL) REFUSED
"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
"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
"fdate", -- End date of interview
"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
"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
"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
"bf1mns", -- [ENTER NUMBER OF MONTHS] BF.1. How many weeks or months did you breastfeed or pump milk to feed your child?
"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
"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
"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
"pop_weight", -- Final Weight Numberd to population size
"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
"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
"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
"qrep", -- Sample replicate
"qkey", -- Sample key number
"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
"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
"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
"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
"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
"sc4c", -- SC4C. What is your name?1=gave name 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
"sc3", -- SC3. Are you driving?1=Yes 2=No 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?
"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
"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
"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)
"sc4b1", -- SC4B.1. How many children did you give birth to in 2014?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
"el12mns", -- [ENTER NUMBER OF WEEKS] EL.12. How many weeks or months of leave, in total, did you take?
"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
"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
"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
"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
"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
"cp3", -- CP.3. Is [CP]/this person male or female?1=Male 2=Female 3=Other 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
"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
"sc6", -- SC6. Are you at least 18 years old?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
"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
"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
"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_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
"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
"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
"resp", -- Respondent 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
"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
"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
"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
"fulladra", -- Did we get all the address asked for?1=Yes 2=No
"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.
"es4", -- ES.4. How many people, including yourself, depend on this income? NUMBER OF PEOPLE 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?
"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
"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
"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
"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
"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
"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
"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
"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
"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
"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
"bf1wks", -- [ENTER NUMBER OF WEEKS] BF.1. How many weeks or months did you breastfeed or pump milk to feed your child?
"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
"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
"sd1_1", -- SD.1. How old was [CHILDNAME]/your child born in 2014 when HE/SHE first went to childcare? (MENTION #1)
"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
"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
"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
"sc6a", -- SC6A. Do you have any questions about this survey, the study or your rights as a study participant?1=Yes 2=No
"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
"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
"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
"clientid", -- Client ID number
"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
"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
"fixd2", -- Zip code
"d2", -- D.2. What is your zip code?1=Gave Response 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
"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
"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
"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
"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
"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
"qcell", -- Sample cell phone flag0=No 1=Yes
"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
"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
"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
"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
"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
"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
"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
"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
"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
"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
"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
"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
"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
"stratum", -- Stratum Variable (should be used when calculating variance)1 or 2
"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
"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
"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
"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
"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
"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
"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
"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
"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
"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
"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:
"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
"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
"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
"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
"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
"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
"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
"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
"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
"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
"d1yob", -- ENTER YEAR OF BIRTH
"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
"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
"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
"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
"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
"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
"sd1mns", -- [ENTER NUMBER OF MONTHS] SD.1. How old was [CHILDNAME]/your child born in 2014 when HE/SHE first went to childcare?
"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
"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
"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
"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
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.
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 cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe: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 cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqeCheckout 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 cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe:latestThis will download all the objects for the latest tag of cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe 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 cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe: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 cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe: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, cityofnewyork-us/new-york-city-work-and-family-leave-survey-wfls-grnn-mvqe is just another Postgres schema.