Setting up

Demographic Subgroups

Adding variables for Race, Gender, Borough and Household adult count.

Create Weights

Weight the entire sample of each survey was weighted by race and borough together. To obtain a weight for that particular race in a particular borough, the NYC proportion from the Census Bureau “ACS Demographic and Housing Estimates” was divided by the Communities Speak portion.

The Communities Speak dataset has there are six racial categories: White alone, Black alone, Asian alone, Hispanic (containing Hispanic, White Hispanic, Black Hispanic, Asian Hispanic, Hawaiian or Pacific Islander Hispanic, Native Hispanic, and Other Hispanic). Else: Other, Two or More Races (except Hispanic), Hawaiian or Pacific Islander, Native, and Prefer Not to Answer.

In the Communities Speak dataset respondents were also asked to identify their borough and zip code in every survey (except the 2023 spring survey when only the zip code was asked and it was used to retrieve the borough).

The Census Bureau’s ” American Community Survey Demographic and Housing Estimates” used is the ACS 1-Year Estimates Data Profiles for 2022. The specific categories used are the Hispanic or Latino and Race: Hispanic or Latino (of any race); Other Hispanic or Latino; White alone; Black alone; American Indian and Alaska Native alone; Asian alone; Native Hawaiian and Other Pacific Islander alone; Some Other Race alone, Two or More Races. The same data, but divided by borough, are used to also weight by geographic location: Brooklyn, Bronx, Manhattan, and Queens (the dataset does not contain enough observations to include Staten Island).

Format Tables

Wrangling Data

Create a function that will create Excel File(wb), save data to that file, iterate over each item in result list and retrieve reshaped data frame

Difficulties Accessing Childcare

Tables Shown Below
Accessing Childcare For Houses With Young Children By Race
Race Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
hispanic 99 42.5% 23 49.5%†† 45 23.9%† 75 29.3% 63 28.4%
black 58 32.6% 16 62.3%†† 20 12%†† 38 21.2%† 19 62.9%††
white 60 49.9% 26 68.3%†† 29 10.3%†† 127 27.6% 68 30%
asian 22 21.4%†† NA NA 15 19.5%†† 17 13.6%†† 16 44.6%††
else 21 52.7%†† 3 33.3%†† 2 50%†† 14 41.2%†† 10 52.8%††
Note:
Note: Table scaled down for better fit.
Accessing Childcare For Houses With Young Children By Boro
Borough Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
bronx 50 40.5% 21 67.1%†† 28 26.1%†† 68 27% 40 39.5%†
brooklyn 68 35.6% 18 61.3%†† 23 16.8%†† 38 30.5%† 45 44.4%†
queens 67 41.4% 7 18.8%†† 17 17.8%†† 47 24.3%† 33 41.8%†
manhattan 58 54.7% 14 78.7%†† 39 10.6%† 113 17.2% 41 36.1%†
si 19 21.2%†† 7 53.8%†† 3 37%†† 9 53.6%†† 16 12.9%††
Accessing Childcare For Houses With Young Children By Gender
Gender Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
female 195 42.8% 53 54.7% 61 28.5% 163 31.2% 114 38.9%
male 65 33.7% 16 63.2%†† 49 5.6%† 111 16% 57 40.1%
Accessing Childcare For Houses With Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
266 40% 69 56.3% 111 18.4% 277 25.9% 176 38.6%

2. Difficulty affording childcare

Affording Childcare For Houses With Young Children By Race
Race Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
hispanic 89 58.8% 24 43.6%†† 52 23.4% 75 31.3% 67 31.3%
black 62 49% 15 45.5%†† 28 8.5%†† 38 24.5%† 19 73.7%††
white 71 49.7% 26 69.6%†† 26 30.1%†† 124 26.2% 68 39.8%
else 19 23%†† 3 81.5%†† 3 28.9%†† 14 35.8%†† 10 38.2%††
asian 21 61%†† 1 0%†† 15 25%†† 17 24.6%†† 16 34.9%††
Affording Childcare For Houses With Young Children By Boro
Borough Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
bronx 40 64.7%† 21 45.5%†† 32 19.9%† 68 30.6% 41 38.7%†
brooklyn 81 46.3% 19 65.6%†† 31 19.4%† 35 28.5%† 47 48.8%†
queens 63 47.6% 6 40.9%†† 21 23.3%†† 47 27.3%† 33 52.5%†
manhattan 61 55.3% 15 70.7%†† 38 20.7%† 113 20.8% 41 31.2%†
si 18 72.6%†† 7 25%†† 2 50%†† 9 61.9%†† 16 25.4%††
Affording Childcare For Houses With Young Children By Gender
Gender Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
female 192 57% 52 54.1% 70 30.7% 163 31.8% 117 45.4%
male 70 43.2% 17 45%†† 54 8.9% 108 20.8% 58 40.4%
Affording Childcare For Houses With Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
266 53.1% 69 52.4% 125 21.8% 274 28% 180 42.6%

Difficulty accessing resources (Tables 5, 6, 7, Appendix)

1. Worried about food running out

Tables Shown Below

Worried About Food Running Out For Houses With Young Children By Race
Race Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
hispanic 99 45.1% 32 21.1%† 66 36.7% 75 31.5% 61 32%
black 58 34.7% 20 34.2%†† 32 40.4%† 37 27.3%† 19 43.1%††
white 60 23.5% 30 11.3%† 46 24.3%† 127 10.7% 67 6.2%
asian 22 64.2%†† 3 66.7%†† 25 23.4%†† 17 0%†† 17 20.9%††
else 21 18.6%†† 2 58.8%†† 5 48.2%†† 14 9.9%†† 10 20.2%††
Worried About Food Running Out For Houses Without Children By Race
Race Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
hispanic 277 34.8% 104 17.4% 234 33.3% 165 25.5% 123 21.8%
white 512 17.4% 360 5.1% 233 10.5% 563 7.7% 502 9.9%
asian 134 21.8% 77 14.3% 126 10.1% 91 9.3% 88 11.9%
black 283 35.7% 53 7.2% 197 26% 141 24.7% 113 14.8%
else 109 32.1% 21 22.5%†† 51 22.8% 95 11.1% 85 21.4%
Worried About Food Running Out For Houses With Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
883 38.2% 243 22% 473 34.3% 557 24.9% 342 30.6%
Worried About Food Running Out For Houses With Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
266 39.9% 89 24.5% 176 32.7% 276 20.5% 174 26.1%
Worried About Food Running Out For Houses Without Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
1382 27.4% 627 10.9% 852 20.5% 1109 15.5% 911 14.5%

2. Food ran out

Food Ran Out For Houses With Young Children By Race
Race Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
hispanic 99 19.6% 32 13.2%† 66 21.5% 75 16.9% 61 17.9%
black 58 15.9% 20 17.8%†† 32 29.2%† 37 20.6%† 19 24.2%††
white 60 19.9% 30 0%† 46 26.6%† 127 12.4% 67 7.8%
asian 22 3%†† 3 33.3%†† 25 17.6%†† 17 0%†† 17 14.4%††
else 21 4.7%†† 2 58.8%†† 5 20%†† 14 8.6%†† 10 10.1%††
Food Ran Out For Houses With Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
883 16.7% 243 12.7% 473 21.9% 557 12.1% 342 16.9%
Food Ran Out For Houses With Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
266 16.1% 89 13% 176 23.4% 276 14.2% 174 15.9%
Food Ran Out For Houses Without Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
1382 12.4% 627 4.3% 852 13.4% 1109 10.4% 911 7.9%

3. Food insecure

Food Insecure For Houses With Young Children By Race
Race Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
hispanic 99 52.1% 18 46.5%†† 55 51.3% 75 37% 67 44.8%
black 58 39.3% 11 67.9%†† 28 61.7%†† 38 45.3%† 19 56.5%††
white 60 37.7% 16 33.7%†† 30 60.6%† 127 8.8% 68 17.6%
asian 22 64.2%†† 2 100%†† 17 38.9%†† 17 6.8%†† 16 33.2%††
else 21 18.6%†† 3 100%†† 3 28.9%†† 14 18.5%†† 10 37.5%††
Food Insecure For Houses With Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
883 42.7% 139 53.3% 335 57.2% 569 27.9% 350 39.9%
Food Insecure For Houses With Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
266 46.7% 51 56.3% 134 53.1% 277 26.6% 180 38.9%
Food Insecure For Houses Without Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Weighted yes responses Weighted % Weighted yes responses Weighted % Weighted yes responses Weighted % Weighted yes responses Weighted % Weighted yes responses
0 122 46.7% NA NA NA NA NA NA NA
1 NA NA 113.6 41% 231.8 50.4% 244 22.6% 213.7

4. Difficulty paying bills

Difficulty Paying Bills For Households With Young Children By Race
Race Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
hispanic 99 55.7% 16 32.9%†† 52 54.3% 75 26.4% 67 18.2%
black 58 37.9% 10 74.2%†† 28 35.4%†† 38 45.1%† 19 34.5%††
white 60 27% 11 43.5%†† 26 58.4%†† 124 11.7% 68 18.8%
asian 22 16.9%†† 2 0%†† 15 12.5%†† 17 13.6%†† 16 18.1%††
else 21 45%†† 3 33.3%†† 3 60.5%†† 14 14.8%†† 10 15.9%††
Difficulty Paying Bills For Households With Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
883 43.6% 120 51.9% 316 49.9% 566 25.3% 349 24.8%
Difficulty Paying Bills For Households With Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
266 40.9% 43 45.4%† 125 45.9% 274 24% 180 21.5%
Difficulty Paying Bills For Households Without Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
1382 41% 240 39.5% 447 45.1% 1121 18.8% 912 22.5%

5. Difficulty paying rent

Difficulty Paying Rent For Households With Young Children By Race
Race Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
hispanic 99 46.5% 16 62.3%†† 52 56.3% 75 41.9% 67 23.1%
black 58 32% 10 78.9%†† 28 57.9%†† 38 41.5%† 19 32.8%††
white 60 23.3% 11 43.5%†† 26 54.8%†† 124 15.9% 68 19.8%
asian 22 21.9%†† 2 100%†† 15 26.4%†† 17 17.9%†† 16 10.9%††
else 21 34.9%†† 3 33.3%†† 3 71.1%†† 14 43.2%†† 10 32.6%††
Difficulty Paying Rent For Households With Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
883 34.1% 120 63.5% 316 51.5% 566 32.9% 349 31.6%
Difficulty Paying Rent For Households With Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
266 35.3% 43 61.1%† 125 53.1% 274 32% 180 23.5%
Difficulty Paying Rent For Households Without Young Children
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Weighted % Total Weighted % Total Weighted % Total Weighted % Total Weighted %
1382 31.9% 240 46.2% 447 47.2% 1121 23.5% 912 25.9%
Rely On Government For Child Care Aid
Fall 2021/Spring 2022 Fall 2022 Spring 2023 Fall 2023 Spring 2024
Total Yes responses % Weighted yes responses Weighted % Total Yes responses % Weighted yes responses Weighted % Total Yes responses % Weighted yes responses Weighted % Total Yes responses % Weighted yes responses Weighted % Total Yes responses % Weighted yes responses Weighted %
300 111 37% 108.7 36.2% 86 29 34% 32.6 34.6% 177 47 27% 41.4 24.8% 246 43 17% 33 15.6% 246 43 17% 37.1 17.2%
Note:
Note: Table scaled down for better fit.

Frequency tables (Appendix)

Frequency By Race

Race Appendix For Households With Young Children
race_census count_BS_2 count_BS_3 count_BS_4 count_BS_5 count_BS_6 count_BS_7
asian 2 24 4 25 21 20
black 11 62 25 32 39 21
else 6 18 4 5 15 15
hispanic 18 93 37 68 87 70
white 14 64 32 49 138 73

Frequency by borough

Boro Appendix For Households With Young Children
borough count_BS_2 percent_BS_2 count_BS_3 percent_BS_3 count_BS_4 percent_BS_4 count_BS_5 percent_BS_5 count_BS_6 percent_BS_6 count_BS_7 percent_BS_7
bronx 21 42% 34 13% 32 31% 43 24% 75 25% 45 23%
brooklyn 8 16% 81 31% 26 25% 36 20% 46 15% 52 26%
manhattan 10 20% 60 23% 24 23% 58 32% 122 40% 45 23%
queens 10 20% 72 27% 13 12% 38 21% 53 17% 38 19%
si 1 2% 18 7% 9 9% 5 3% 9 3% 17 9%

Maps

Difficulty accessing and affording child care by neighborhood, for the neighborhood with 10 or more total respondents in 2023 and summer 2024
Borough Neighborhood Difficulty accessing child care (%) Difficulty affording child care (%) Number of respondents
Bronx Crotona - Tremont 18.8 12.5 16
Bronx Fordham - Bronx Park 15.8 15.8 19
Bronx High Bridge - Morrisania 18.8 25.0 32
Bronx Hunts Point - Mott Haven 32.1 25.0 28
Bronx Northeast Bronx 43.8 25.0 16
Bronx Pelham - Throgs Neck 26.9 26.9 26
Brooklyn Bedford Stuyvesant - Crown Heights 35.0 25.0 20
Brooklyn Downtown - Heights - Park Slope 30.8 23.1 13
Brooklyn Williamsburg - Bushwick 15.4 38.5 13
Manhattan Central Harlem - Morningside Heights 30.0 35.0 20
Manhattan Chelsea - Clinton 19.6 13.7 51
Manhattan East Harlem 8.7 13.0 23
Manhattan Greenwich Village - SoHo 8.0 16.0 25
Manhattan Lower Manhattan 0.0 23.8 21
Queens Lower Manhattan NA NA 1
Manhattan Union Square - Lower East Side 26.1 30.4 23
Manhattan Upper West Side 0.0 15.0 20
Queens Long Island City - Astoria 31.2 25.0 16
Queens Long Island City - Astoria NA NA 3
Queens Ridgewood - Forest Hills 11.1 16.7 18
Queens Ridgewood - Forest Hills 47.1 35.3 17
Queens Southwest Queens 0.0 16.7 12
Queens Southwest Queens NA NA 1
Queens West Queens 5.9 5.9 17
Queens West Queens NA NA 1

```