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 43% 23 49%†† 45 24%† 75 29% 63 28%
black 58 33% 16 62%†† 20 12%†† 38 21%† 19 63%††
white 60 50% 26 68%†† 29 10%†† 127 28% 68 30%
asian 22 21%†† NA NA 15 19%†† 17 14%†† 16 45%††
else 21 53%†† 3 33%†† 2 50%†† 14 41%†† 10 53%††
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 41% 21 67%†† 28 26%†† 68 27% 40 40%†
brooklyn 68 36% 18 61%†† 23 17%†† 38 31%† 45 44%†
queens 67 41% 7 19%†† 17 18%†† 47 24%† 33 42%†
manhattan 58 55% 14 79%†† 39 11%† 113 17% 41 36%†
si 19 21%†† 7 54%†† 3 37%†† 9 54%†† 16 13%††
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 43% 53 55% 61 29% 163 31% 114 39%
male 65 34% 16 63%†† 49 6%† 111 16% 57 40%
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% 111 18% 277 26% 176 39%

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 59% 24 44%†† 52 23% 75 31% 67 31%
black 62 49% 15 45%†† 28 8%†† 38 24%† 19 74%††
white 71 50% 26 70%†† 26 30%†† 124 26% 68 40%
else 19 23%†† 3 81%†† 3 29%†† 14 36%†† 10 38%††
asian 21 61%†† 1 0%†† 15 25%†† 17 25%†† 16 35%††
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 65%† 21 45%†† 32 20%† 68 31% 41 39%†
brooklyn 81 46% 19 66%†† 31 19%† 35 29%† 47 49%†
queens 63 48% 6 41%†† 21 23%†† 47 27%† 33 53%†
manhattan 61 55% 15 71%†† 38 21%† 113 21% 41 31%†
si 18 73%†† 7 25%†† 2 50%†† 9 62%†† 16 25%††
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% 70 31% 163 32% 117 45%
male 70 43% 17 45%†† 54 9% 108 21% 58 40%
other 3 50%†† NA NA NA NA 1 100%†† 2 0%††
non-binary 1 0%†† NA NA NA NA NA NA 1 0%††
transgender NA NA NA NA 1 0%†† 2 0%†† 2 0%††
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% 69 52% 125 22% 274 28% 180 43%

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% 32 21%† 66 37% 75 31% 61 32%
black 58 35% 20 34%†† 32 40%† 37 27%† 19 43%††
white 60 24% 30 11%† 46 24%† 127 11% 67 6%
asian 22 64%†† 3 67%†† 25 23%†† 17 0%†† 17 21%††
else 21 19%†† 2 59%†† 5 48%†† 14 10%†† 10 20%††
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 35% 104 17% 234 33% 165 25% 123 22%
white 512 17% 360 5% 233 11% 563 8% 502 10%
asian 134 22% 77 14% 126 10% 91 9% 88 12%
black 283 36% 53 7% 197 26% 141 25% 113 15%
else 109 32% 21 22%†† 51 23% 95 11% 85 21%
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 40% 89 25% 176 33% 276 21% 174 26%
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% 627 11% 852 21% 1109 15% 911 15%

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 20% 32 13%† 66 21% 75 17% 61 18%
black 58 16% 20 18%†† 32 29%† 37 21%† 19 24%††
white 60 20% 30 0%† 46 27%† 127 12% 67 8%
asian 22 3%†† 3 33%†† 25 18%†† 17 0%†† 17 14%††
else 21 5%†† 2 59%†† 5 20%†† 14 9%†† 10 10%††
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% 89 13% 176 23% 276 14% 174 16%
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% 627 4% 852 13% 1109 10% 911 8%

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% 18 47%†† 55 51% 75 37% 67 45%
black 58 39% 11 68%†† 28 62%†† 38 45%† 19 56%††
white 60 38% 16 34%†† 30 61%† 127 9% 68 18%
asian 22 64%†† 2 100%†† 17 39%†† 17 7%†† 16 33%††
else 21 19%†† 3 100%†† 3 29%†† 14 19%†† 10 38%††
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 47% 51 56% 134 53% 277 27% 180 39%
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 47% NA NA NA NA NA NA NA
1 NA NA 113.6 41% 231.8 50% 244 23% 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 56% 16 33%†† 52 54% 75 26% 67 18%
black 58 38% 10 74%†† 28 35%†† 38 45%† 19 34%††
white 60 27% 11 43%†† 26 58%†† 124 12% 68 19%
asian 22 17%†† 2 0%†† 15 12%†† 17 14%†† 16 18%††
else 21 45%†† 3 33%†† 3 61%†† 14 15%†† 10 16%††
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 41% 43 45%† 125 46% 274 24% 180 22%
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 40% 447 45% 1121 19% 912 22%

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% 16 62%†† 52 56% 75 42% 67 23%
black 58 32% 10 79%†† 28 58%†† 38 41%† 19 33%††
white 60 23% 11 43%†† 26 55%†† 124 16% 68 20%
asian 22 22%†† 2 100%†† 15 26%†† 17 18%†† 16 11%††
else 21 35%†† 3 33%†† 3 71%†† 14 43%†† 10 33%††
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% 43 61%† 125 53% 274 32% 180 23%
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 32% 240 46% 447 47% 1121 23% 912 26%

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

```