{
 "sources": [
  {
   "id": "ncsacw-2025",
   "name": "National Center on Substance Abuse and Child Welfare (NCSACW), Parental Alcohol or Drug Abuse as a Circumstance Reported at Removal by State, 2025",
   "url": "https://ncsacw.acf.gov/files/statistics-parent-AOD-in-US-by-state-2025.pdf",
   "retrievedAt": "2026-11-12",
   "role": "Share and number of children in foster care with parental alcohol or drug abuse recorded at removal, by state, federal fiscal year 2025",
   "licenseName": "Public domain (U.S. government work)",
   "licenseUrl": null,
   "redistribution": "Public domain; figures restated, document linked",
   "reliability": {
    "publisherKind": "government",
    "interest": "none",
    "note": "A center funded by the federal Children's Bureau and the Substance Abuse and Mental Health Services Administration. Figures are the Center for Children and Family Futures' analysis of the federal foster care data (AFCARS) that every state reports, as archived by the National Data Archive on Child Abuse and Neglect."
   }
  },
  {
   "id": "ncsacw-trend",
   "name": "NCSACW, Prevalence of Parental Alcohol or Drug Abuse as a Circumstance Reported at Removal in the United States, 2000 to 2025",
   "url": "https://ncsacw.acf.gov/files/statistics-parent-AOD-in-US-prevalence-in-US-2000-to-2025.pdf",
   "retrievedAt": "2026-11-12",
   "role": "National share by year, 2000 to 2025",
   "licenseName": "Public domain (U.S. government work)",
   "licenseUrl": null,
   "redistribution": "Public domain; figures restated, document linked",
   "reliability": {
    "publisherKind": "government",
    "interest": "none",
    "note": "Same center and method as the 2025 state table."
   }
  },
  {
   "id": "ncsacw-2021",
   "name": "NCSACW, Parental Alcohol or Drug Abuse as an Identified Condition of Removal by State, 2021 (archived copy)",
   "url": "https://web.archive.org/web/20260505063323/https://ncsacw.acf.gov/files/statistics-2-parental-aod-removal-by-state.pdf",
   "retrievedAt": "2026-11-12",
   "role": "Washington and national shares in the 2021 edition of the state table",
   "licenseName": "Public domain (U.S. government work)",
   "licenseUrl": null,
   "redistribution": "Public domain; figures restated, document linked",
   "reliability": {
    "publisherKind": "government",
    "interest": "none",
    "note": "An earlier edition of the same center's state table, no longer posted on its site; read from the Internet Archive copy. Its footnote cites 'AFCARS Data, 2020 v1' while its title says 2021."
   }
  },
  {
   "id": "ncsacw-2019",
   "name": "NCSACW, Parental Alcohol or Other Drug Abuse as an Identified Condition or Removal by State, 2019 (archived copy)",
   "url": "https://web.archive.org/web/20210816150416/https://ncsacw.samhsa.gov/images/statistics/2-aod-removal-by-state.pdf",
   "retrievedAt": "2026-11-12",
   "role": "Washington and national shares in the 2019 edition of the state table",
   "licenseName": "Public domain (U.S. government work)",
   "licenseUrl": null,
   "redistribution": "Public domain; figures restated, document linked",
   "reliability": {
    "publisherKind": "government",
    "interest": "none",
    "note": "An earlier edition of the same center's state table, read from the Internet Archive copy."
   }
  },
  {
   "id": "afcars-tar-wa",
   "name": "U.S. Children's Bureau, AFCARS state data reports for Washington, fiscal years 2021 and 2022",
   "url": "https://acf.gov/sites/default/files/documents/cb/afcars-tar-wa-2022.pdf",
   "retrievedAt": "2026-11-12",
   "role": "Circumstances recorded for children entering foster care in Washington (FY2021 report: https://acf.gov/sites/default/files/documents/cb/afcars-tar-wa-2021.pdf)",
   "licenseName": "Public domain (U.S. government work)",
   "licenseUrl": null,
   "redistribution": "Public domain; figures restated, document linked",
   "reliability": {
    "publisherKind": "government",
    "interest": "none",
    "note": "The federal agency's own summary of the foster care data Washington reports to it. Preliminary estimates as of June 28, 2022 (FY2021) and May 9, 2023 (FY2022). Reports for other years were not posted at the same address."
   }
  },
  {
   "id": "dcyf-dashboard",
   "name": "Washington Department of Children, Youth, and Families (DCYF), Prevention Dashboard V1.16, Factors tab",
   "url": "https://dcyf.wa.gov/practice/oiaa/reports/prevention-dashboard",
   "retrievedAt": "2026-11-12",
   "role": "Contributing factors for children entering out-of-home care, statewide and King County, by age group, 2017 to 2024",
   "licenseName": "Public record (Washington state government)",
   "licenseUrl": null,
   "redistribution": "Public record; figures restated, dashboard linked",
   "reliability": {
    "publisherKind": "government",
    "interest": "none",
    "note": "The state agency that removes children reports on its own cases from its case management system (FamLink), using the federal AFCARS definitions. Read from the dashboard's hover values on November 12, 2026 (dashboard updated September 2025)."
   }
  },
  {
   "id": "rda-7-121",
   "name": "Washington DSHS Research and Data Analysis Division, Report 7.121: Substance Use Disorder Treatment Penetration among Child Welfare-Involved Caregivers (December 2020)",
   "url": "https://www.dshs.wa.gov/sites/default/files/rda/reports/research-7-121.pdf",
   "retrievedAt": "2026-11-12",
   "role": "Share of caregivers with a substance use disorder and share treated, state fiscal years 2015 to 2018",
   "licenseName": "Public record (Washington state government)",
   "licenseUrl": null,
   "redistribution": "Public record; figures restated, document linked",
   "reliability": {
    "publisherKind": "government",
    "interest": "none",
    "note": "The state's own research office, writing for DCYF. It links child welfare records to Medicaid diagnoses, prescriptions and treatment and to drug-related arrests; treatment counts cover Medicaid-paid care only."
   }
  },
  {
   "id": "afcars-codebook",
   "name": "National Data Archive on Child Abuse and Neglect, AFCARS Foster Care File Codebook",
   "url": "https://www.ndacan.acf.hhs.gov/datasets/pdfs_user_guides/afcars-foster-care-file-codebook.pdf",
   "retrievedAt": "2026-11-12",
   "role": "Definitions of the removal-reason fields (elements #37 and #38)",
   "licenseName": "Public domain (U.S. government work)",
   "licenseUrl": null,
   "redistribution": "Public domain; figures restated, document linked",
   "reliability": {
    "publisherKind": "government",
    "interest": "none",
    "note": "The federal data archive's codebook for the AFCARS file; definitions come from federal regulation 45 CFR 1355, Appendix A."
   }
  }
 ],
 "tables": [
  {
   "id": "states-fy2025",
   "title": "Parental alcohol or drug abuse at removal, by state, FY2025",
   "description": "Children in out-of-home care at any point in federal fiscal year 2025 whose removal records list parental alcohol or drug abuse.",
   "artifactId": "states-fy2025",
   "unitOfObservation": "One state, DC or Puerto Rico",
   "fields": [
    {
     "name": "state",
     "type": "string",
     "description": "State name",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2025"
     ]
    },
    {
     "name": "usps",
     "type": "string",
     "description": "Postal code",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2025"
     ]
    },
    {
     "name": "fips",
     "type": "string",
     "description": "Two-digit FIPS code",
     "units": null,
     "nullable": false,
     "valueType": "derived",
     "derivation": "Standard Census FIPS code for the state",
     "sourceIds": [
      "ncsacw-2025"
     ]
    },
    {
     "name": "pct",
     "type": "number",
     "description": "Percent of children in out-of-home care during the year with parental alcohol or drug abuse recorded as a circumstance at removal",
     "units": "percent",
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2025"
     ]
    },
    {
     "name": "children",
     "type": "integer",
     "description": "Number of those children",
     "units": "children",
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2025"
     ]
    },
    {
     "name": "estimated_from_entries",
     "type": "string",
     "description": "yes where NCSACW estimated the percent from entries because of missing data (IA, IN, KS, NC)",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2025"
     ]
    },
    {
     "name": "rank",
     "type": "integer",
     "description": "Rank among the 50 states and DC, highest first; ties share consecutive ranks in table order; empty for Puerto Rico",
     "units": null,
     "nullable": true,
     "valueType": "derived",
     "derivation": "Sorted by pct, descending",
     "sourceIds": [
      "ncsacw-2025"
     ]
    }
   ]
  },
  {
   "id": "national-trend",
   "title": "U.S. share by year, FY2000-FY2025",
   "description": "National percent of children in out-of-home care with parental alcohol or drug abuse recorded at removal, as NCSACW's current series gives it.",
   "artifactId": "national-trend",
   "unitOfObservation": "One federal fiscal year",
   "fields": [
    {
     "name": "fiscal_year",
     "type": "integer",
     "description": "Federal fiscal year (October to September)",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-trend"
     ]
    },
    {
     "name": "pct",
     "type": "number",
     "description": "National percent",
     "units": "percent",
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-trend"
     ]
    }
   ]
  },
  {
   "id": "washington-editions",
   "title": "Washington and U.S. in three editions of the state table",
   "description": "The Washington and national figures printed in NCSACW's 2019, 2021 and 2025 state tables. Earlier editions were revised later, so they are kept as printed.",
   "artifactId": "washington-editions",
   "unitOfObservation": "One place in one edition",
   "fields": [
    {
     "name": "fiscal_year",
     "type": "integer",
     "description": "Year the table covers",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2019",
      "ncsacw-2021",
      "ncsacw-2025"
     ]
    },
    {
     "name": "place",
     "type": "string",
     "description": "Washington or United States",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2019",
      "ncsacw-2021",
      "ncsacw-2025"
     ]
    },
    {
     "name": "pct",
     "type": "number",
     "description": "Percent as printed",
     "units": "percent",
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2019",
      "ncsacw-2021",
      "ncsacw-2025"
     ]
    },
    {
     "name": "children_with_aod",
     "type": "integer",
     "description": "Number with parental alcohol or drug abuse, where printed",
     "units": "children",
     "nullable": true,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2021",
      "ncsacw-2025"
     ]
    },
    {
     "name": "children_in_care",
     "type": "integer",
     "description": "Total children, where printed",
     "units": "children",
     "nullable": true,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2021"
     ]
    },
    {
     "name": "edition",
     "type": "string",
     "description": "Which edition",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "ncsacw-2019",
      "ncsacw-2021",
      "ncsacw-2025"
     ]
    }
   ]
  },
  {
   "id": "washington-entries",
   "title": "Removal circumstances for children entering care in Washington, FY2021-FY2022",
   "description": "Every circumstance the federal reports list for children who entered foster care during the year. A child can have several.",
   "artifactId": "washington-entries",
   "unitOfObservation": "One circumstance in one fiscal year",
   "fields": [
    {
     "name": "fiscal_year",
     "type": "integer",
     "description": "Federal fiscal year",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "afcars-tar-wa"
     ]
    },
    {
     "name": "circumstance",
     "type": "string",
     "description": "Circumstance associated with the child's removal",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "afcars-tar-wa"
     ]
    },
    {
     "name": "children",
     "type": "integer",
     "description": "Children entering care with this circumstance",
     "units": "children",
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "afcars-tar-wa"
     ]
    },
    {
     "name": "entries",
     "type": "integer",
     "description": "All children entering care that year",
     "units": "children",
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "afcars-tar-wa"
     ]
    },
    {
     "name": "pct",
     "type": "number",
     "description": "children / entries, to one decimal (the report prints whole percents)",
     "units": "percent",
     "nullable": false,
     "valueType": "derived",
     "derivation": "children / entries * 100",
     "sourceIds": [
      "afcars-tar-wa"
     ]
    }
   ]
  },
  {
   "id": "dcyf-entries-by-age",
   "title": "DCYF contributing factors for children entering care, by age group",
   "description": "Percent of children entering out-of-home care with parental drug abuse, parental alcohol abuse or neglect as a contributing factor, as DCYF's prevention dashboard shows it for each age group.",
   "artifactId": "dcyf-entries-by-age",
   "unitOfObservation": "One age group in one year and place",
   "fields": [
    {
     "name": "year",
     "type": "integer",
     "description": "Calendar year of removal",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "dcyf-dashboard"
     ]
    },
    {
     "name": "geography",
     "type": "string",
     "description": "Washington or King County (county of removal)",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "dcyf-dashboard"
     ]
    },
    {
     "name": "age_group",
     "type": "string",
     "description": "The dashboard's age filter: Newborns, Infants, or 2-17 year-olds (the default view)",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "dcyf-dashboard"
     ]
    },
    {
     "name": "parent_drug_pct",
     "type": "number",
     "description": "Percent with Parent Drug Abuse as a contributing factor",
     "units": "percent",
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "dcyf-dashboard"
     ]
    },
    {
     "name": "parent_alcohol_pct",
     "type": "number",
     "description": "Percent with Parent Alcohol Abuse; empty where the dashboard shows no bar",
     "units": "percent",
     "nullable": true,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "dcyf-dashboard"
     ]
    },
    {
     "name": "neglect_pct",
     "type": "number",
     "description": "Percent with Neglect",
     "units": "percent",
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "dcyf-dashboard"
     ]
    }
   ]
  },
  {
   "id": "treatment",
   "title": "Addiction and treatment among Washington child welfare caregivers, SFY2015-2018",
   "description": "Key figures from DSHS report 7.121.",
   "artifactId": "treatment",
   "unitOfObservation": "One figure",
   "fields": [
    {
     "name": "measure",
     "type": "string",
     "description": "What is counted",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "rda-7-121"
     ]
    },
    {
     "name": "value",
     "type": "number",
     "description": "The figure",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "rda-7-121"
     ]
    },
    {
     "name": "unit",
     "type": "string",
     "description": "percent or caregivers",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "rda-7-121"
     ]
    },
    {
     "name": "group",
     "type": "string",
     "description": "Which caregivers",
     "units": null,
     "nullable": false,
     "valueType": "observed",
     "derivation": null,
     "sourceIds": [
      "rda-7-121"
     ]
    }
   ]
  }
 ],
 "analyses": [
  {
   "id": "states-fy2025",
   "title": "Parental alcohol or drug abuse at removal, by state, FY2025",
   "question": "How does Washington compare with other states?",
   "operation": "Rows of the NCSACW 2025 state table, with FIPS codes added and states ranked by percent",
   "scope": "Children in out-of-home care at any point in federal fiscal year 2025, 50 states, DC and Puerto Rico",
   "resultShape": "table",
   "structuredResult": [
    {
     "state": "Alaska",
     "usps": "AK",
     "fips": "02",
     "pct": 65.1,
     "children": 2233,
     "estimated_from_entries": "no",
     "rank": 1
    },
    {
     "state": "Alabama",
     "usps": "AL",
     "fips": "01",
     "pct": 42.6,
     "children": 3784,
     "estimated_from_entries": "no",
     "rank": 17
    },
    {
     "state": "Arkansas",
     "usps": "AR",
     "fips": "05",
     "pct": 37.9,
     "children": 2043,
     "estimated_from_entries": "no",
     "rank": 30
    },
    {
     "state": "Arizona",
     "usps": "AZ",
     "fips": "04",
     "pct": 37.6,
     "children": 5191,
     "estimated_from_entries": "no",
     "rank": 31
    },
    {
     "state": "California",
     "usps": "CA",
     "fips": "06",
     "pct": 14.2,
     "children": 7933,
     "estimated_from_entries": "no",
     "rank": 49
    },
    {
     "state": "Colorado",
     "usps": "CO",
     "fips": "08",
     "pct": 48.9,
     "children": 3264,
     "estimated_from_entries": "no",
     "rank": 10
    },
    {
     "state": "Connecticut",
     "usps": "CT",
     "fips": "09",
     "pct": 39.4,
     "children": 1904,
     "estimated_from_entries": "no",
     "rank": 27
    },
    {
     "state": "District of Columbia",
     "usps": "DC",
     "fips": "11",
     "pct": 15.7,
     "children": 112,
     "estimated_from_entries": "no",
     "rank": 48
    },
    {
     "state": "Delaware",
     "usps": "DE",
     "fips": "10",
     "pct": 26.5,
     "children": 198,
     "estimated_from_entries": "no",
     "rank": 42
    },
    {
     "state": "Florida",
     "usps": "FL",
     "fips": "12",
     "pct": 45.7,
     "children": 11429,
     "estimated_from_entries": "no",
     "rank": 13
    },
    {
     "state": "Georgia",
     "usps": "GA",
     "fips": "13",
     "pct": 41.6,
     "children": 6553,
     "estimated_from_entries": "no",
     "rank": 21
    },
    {
     "state": "Hawaii",
     "usps": "HI",
     "fips": "15",
     "pct": 20.5,
     "children": 310,
     "estimated_from_entries": "no",
     "rank": 45
    },
    {
     "state": "Iowa",
     "usps": "IA",
     "fips": "19",
     "pct": 51.3,
     "children": 3117,
     "estimated_from_entries": "yes",
     "rank": 7
    },
    {
     "state": "Idaho",
     "usps": "ID",
     "fips": "16",
     "pct": 31.3,
     "children": 690,
     "estimated_from_entries": "no",
     "rank": 37
    },
    {
     "state": "Illinois",
     "usps": "IL",
     "fips": "17",
     "pct": 11.9,
     "children": 2771,
     "estimated_from_entries": "no",
     "rank": 50
    },
    {
     "state": "Indiana",
     "usps": "IN",
     "fips": "18",
     "pct": 53.8,
     "children": 10353,
     "estimated_from_entries": "yes",
     "rank": 6
    },
    {
     "state": "Kansas",
     "usps": "KS",
     "fips": "20",
     "pct": 25.8,
     "children": 2199,
     "estimated_from_entries": "yes",
     "rank": 43
    },
    {
     "state": "Kentucky",
     "usps": "KY",
     "fips": "21",
     "pct": 34.5,
     "children": 4576,
     "estimated_from_entries": "no",
     "rank": 33
    },
    {
     "state": "Louisiana",
     "usps": "LA",
     "fips": "22",
     "pct": 3.0,
     "children": 230,
     "estimated_from_entries": "no",
     "rank": 51
    },
    {
     "state": "Massachusetts",
     "usps": "MA",
     "fips": "25",
     "pct": 33.7,
     "children": 3882,
     "estimated_from_entries": "no",
     "rank": 35
    },
    {
     "state": "Maryland",
     "usps": "MD",
     "fips": "24",
     "pct": 38.7,
     "children": 1958,
     "estimated_from_entries": "no",
     "rank": 29
    },
    {
     "state": "Maine",
     "usps": "ME",
     "fips": "23",
     "pct": 48.0,
     "children": 1510,
     "estimated_from_entries": "no",
     "rank": 11
    },
    {
     "state": "Michigan",
     "usps": "MI",
     "fips": "26",
     "pct": 41.8,
     "children": 5495,
     "estimated_from_entries": "no",
     "rank": 20
    },
    {
     "state": "Minnesota",
     "usps": "MN",
     "fips": "27",
     "pct": 46.2,
     "children": 4244,
     "estimated_from_entries": "no",
     "rank": 12
    },
    {
     "state": "Missouri",
     "usps": "MO",
     "fips": "29",
     "pct": 45.6,
     "children": 7566,
     "estimated_from_entries": "no",
     "rank": 14
    },
    {
     "state": "Mississippi",
     "usps": "MS",
     "fips": "28",
     "pct": 41.9,
     "children": 2626,
     "estimated_from_entries": "no",
     "rank": 19
    },
    {
     "state": "Montana",
     "usps": "MT",
     "fips": "30",
     "pct": 39.1,
     "children": 1297,
     "estimated_from_entries": "no",
     "rank": 28
    },
    {
     "state": "North Carolina",
     "usps": "NC",
     "fips": "37",
     "pct": 42.4,
     "children": 6811,
     "estimated_from_entries": "yes",
     "rank": 18
    },
    {
     "state": "North Dakota",
     "usps": "ND",
     "fips": "38",
     "pct": 40.4,
     "children": 757,
     "estimated_from_entries": "no",
     "rank": 23
    },
    {
     "state": "Nebraska",
     "usps": "NE",
     "fips": "31",
     "pct": 28.6,
     "children": 1582,
     "estimated_from_entries": "no",
     "rank": 40
    },
    {
     "state": "New Hampshire",
     "usps": "NH",
     "fips": "33",
     "pct": 17.4,
     "children": 292,
     "estimated_from_entries": "no",
     "rank": 46
    },
    {
     "state": "New Jersey",
     "usps": "NJ",
     "fips": "34",
     "pct": 39.9,
     "children": 1715,
     "estimated_from_entries": "no",
     "rank": 26
    },
    {
     "state": "New Mexico",
     "usps": "NM",
     "fips": "35",
     "pct": 44.0,
     "children": 1425,
     "estimated_from_entries": "no",
     "rank": 16
    },
    {
     "state": "Nevada",
     "usps": "NV",
     "fips": "32",
     "pct": 24.9,
     "children": 1627,
     "estimated_from_entries": "no",
     "rank": 44
    },
    {
     "state": "New York",
     "usps": "NY",
     "fips": "36",
     "pct": 29.7,
     "children": 6176,
     "estimated_from_entries": "no",
     "rank": 39
    },
    {
     "state": "Ohio",
     "usps": "OH",
     "fips": "39",
     "pct": 30.0,
     "children": 7218,
     "estimated_from_entries": "no",
     "rank": 38
    },
    {
     "state": "Oklahoma",
     "usps": "OK",
     "fips": "40",
     "pct": 55.0,
     "children": 5292,
     "estimated_from_entries": "no",
     "rank": 4
    },
    {
     "state": "Oregon",
     "usps": "OR",
     "fips": "41",
     "pct": 50.3,
     "children": 3385,
     "estimated_from_entries": "no",
     "rank": 9
    },
    {
     "state": "Pennsylvania",
     "usps": "PA",
     "fips": "42",
     "pct": 33.6,
     "children": 5863,
     "estimated_from_entries": "no",
     "rank": 36
    },
    {
     "state": "Rhode Island",
     "usps": "RI",
     "fips": "44",
     "pct": 28.6,
     "children": 656,
     "estimated_from_entries": "no",
     "rank": 41
    },
    {
     "state": "South Carolina",
     "usps": "SC",
     "fips": "45",
     "pct": 17.1,
     "children": 1017,
     "estimated_from_entries": "no",
     "rank": 47
    },
    {
     "state": "South Dakota",
     "usps": "SD",
     "fips": "46",
     "pct": 54.2,
     "children": 1433,
     "estimated_from_entries": "no",
     "rank": 5
    },
    {
     "state": "Tennessee",
     "usps": "TN",
     "fips": "47",
     "pct": 34.4,
     "children": 4731,
     "estimated_from_entries": "no",
     "rank": 34
    },
    {
     "state": "Texas",
     "usps": "TX",
     "fips": "48",
     "pct": 58.4,
     "children": 15645,
     "estimated_from_entries": "no",
     "rank": 3
    },
    {
     "state": "Utah",
     "usps": "UT",
     "fips": "49",
     "pct": 59.6,
     "children": 1661,
     "estimated_from_entries": "no",
     "rank": 2
    },
    {
     "state": "Virginia",
     "usps": "VA",
     "fips": "51",
     "pct": 37.2,
     "children": 2924,
     "estimated_from_entries": "no",
     "rank": 32
    },
    {
     "state": "Vermont",
     "usps": "VT",
     "fips": "50",
     "pct": 41.3,
     "children": 553,
     "estimated_from_entries": "no",
     "rank": 22
    },
    {
     "state": "Washington",
     "usps": "WA",
     "fips": "53",
     "pct": 51.3,
     "children": 4525,
     "estimated_from_entries": "no",
     "rank": 8
    },
    {
     "state": "Wisconsin",
     "usps": "WI",
     "fips": "55",
     "pct": 40.0,
     "children": 3527,
     "estimated_from_entries": "no",
     "rank": 25
    },
    {
     "state": "West Virginia",
     "usps": "WV",
     "fips": "54",
     "pct": 40.4,
     "children": 4292,
     "estimated_from_entries": "no",
     "rank": 24
    },
    {
     "state": "Wyoming",
     "usps": "WY",
     "fips": "56",
     "pct": 44.9,
     "children": 550,
     "estimated_from_entries": "no",
     "rank": 15
    },
    {
     "state": "Puerto Rico",
     "usps": "PR",
     "fips": "72",
     "pct": 16.2,
     "children": 495,
     "estimated_from_entries": "no",
     "rank": null
    }
   ],
   "displayResult": "In FY2025, 51.3% of Washington's children in foster care (4,525) had parental alcohol or drug abuse recorded at removal, against 38.0% nationally. Washington ties Iowa for 7th of 50 states and DC; Alaska (65.1%), Utah (59.6%) and Texas (58.4%) are highest, Louisiana (3.0%) lowest.",
   "methodologicalNotes": [
    "NCSACW counts parental alcohol OR drug abuse, once per child.",
    "Iowa, Indiana, Kansas and North Carolina are estimated from entries because of missing data (NCSACW's note).",
    "Washington's denominator is not printed; 4,525 / 0.513 is about 8,800 children."
   ],
   "limitations": [
    "NCSACW says states record this differently and some report only the primary reason, so very low states (Louisiana 3.0%, Illinois 11.9%, California 14.2%) likely under-record, and state ranks partly reflect recording practice.",
    "Children in care during the year include children removed in earlier years, so this is not the share of new removals."
   ],
   "executedAt": "2026-11-12T20:00:00Z"
  },
  {
   "id": "national-trend",
   "title": "U.S. share by year, FY2000-FY2025",
   "question": "How has the national share changed?",
   "operation": "As printed",
   "scope": "United States, FY2000-FY2025",
   "resultShape": "table",
   "structuredResult": [
    {
     "fiscal_year": 2000,
     "pct": 18.5
    },
    {
     "fiscal_year": 2001,
     "pct": 19.6
    },
    {
     "fiscal_year": 2002,
     "pct": 21.9
    },
    {
     "fiscal_year": 2003,
     "pct": 23.0
    },
    {
     "fiscal_year": 2004,
     "pct": 23.9
    },
    {
     "fiscal_year": 2005,
     "pct": 24.7
    },
    {
     "fiscal_year": 2006,
     "pct": 25.9
    },
    {
     "fiscal_year": 2007,
     "pct": 26.5
    },
    {
     "fiscal_year": 2008,
     "pct": 26.0
    },
    {
     "fiscal_year": 2009,
     "pct": 26.2
    },
    {
     "fiscal_year": 2010,
     "pct": 28.5
    },
    {
     "fiscal_year": 2011,
     "pct": 29.6
    },
    {
     "fiscal_year": 2012,
     "pct": 30.7
    },
    {
     "fiscal_year": 2013,
     "pct": 31.3
    },
    {
     "fiscal_year": 2014,
     "pct": 32.2
    },
    {
     "fiscal_year": 2015,
     "pct": 34.5
    },
    {
     "fiscal_year": 2016,
     "pct": 35.7
    },
    {
     "fiscal_year": 2017,
     "pct": 37.8
    },
    {
     "fiscal_year": 2018,
     "pct": 38.8
    },
    {
     "fiscal_year": 2019,
     "pct": 38.9
    },
    {
     "fiscal_year": 2020,
     "pct": 38.9
    },
    {
     "fiscal_year": 2021,
     "pct": 38.3
    },
    {
     "fiscal_year": 2022,
     "pct": 38.4
    },
    {
     "fiscal_year": 2023,
     "pct": 39.0
    },
    {
     "fiscal_year": 2024,
     "pct": 38.2
    },
    {
     "fiscal_year": 2025,
     "pct": 38.0
    }
   ],
   "displayResult": "Nationally the share rose from 18.5% in 2000 to 38.8% in 2018 and has stayed between 38% and 39% since.",
   "methodologicalNotes": [
    "NCSACW's current series; it revises earlier years (its 2021 edition printed 39.1% for 2021, the series now gives 38.3%)."
   ],
   "limitations": [
    "State recording practices changed over 25 years, so part of the rise may be better recording."
   ],
   "executedAt": "2026-11-12T20:00:00Z"
  },
  {
   "id": "washington-editions",
   "title": "Washington and U.S. in the 2019, 2021 and 2025 state tables",
   "question": "Has Washington's share changed?",
   "operation": "Figures as printed in each edition",
   "scope": "Washington and United States, FY2019, FY2021, FY2025",
   "resultShape": "table",
   "structuredResult": [
    {
     "fiscal_year": 2019,
     "place": "Washington",
     "pct": 43.4,
     "children_with_aod": null,
     "children_in_care": null,
     "edition": "NCSACW state table for 2019 (archived copy, August 2021)"
    },
    {
     "fiscal_year": 2019,
     "place": "United States",
     "pct": 38.9,
     "children_with_aod": null,
     "children_in_care": null,
     "edition": "NCSACW state table for 2019 (archived copy, August 2021)"
    },
    {
     "fiscal_year": 2021,
     "place": "Washington",
     "pct": 44.5,
     "children_with_aod": 5944,
     "children_in_care": 13354,
     "edition": "NCSACW state table for 2021 (archived copy, May 2026)"
    },
    {
     "fiscal_year": 2021,
     "place": "United States",
     "pct": 39.1,
     "children_with_aod": null,
     "children_in_care": null,
     "edition": "NCSACW state table for 2021 (archived copy, May 2026)"
    },
    {
     "fiscal_year": 2025,
     "place": "Washington",
     "pct": 51.3,
     "children_with_aod": 4525,
     "children_in_care": null,
     "edition": "NCSACW state table for 2025 (current)"
    },
    {
     "fiscal_year": 2025,
     "place": "United States",
     "pct": 38.0,
     "children_with_aod": 181620,
     "children_in_care": null,
     "edition": "NCSACW state table for 2025 (current)"
    }
   ],
   "displayResult": "Washington's share was 43.4% in the 2019 table, 44.5% in the 2021 table and 51.3% in 2025; the national figure stayed between 38% and 39%.",
   "methodologicalNotes": [
    "Only three editions could be found; NCSACW's site keeps the latest only, and the 2020 and 2022-2024 tables were not available in the Internet Archive when checked."
   ],
   "limitations": [
    "Editions can differ in method and data version (the 2021 table's footnote cites 2020 data), so treat the change as approximate."
   ],
   "executedAt": "2026-11-12T20:00:00Z"
  },
  {
   "id": "washington-entries",
   "title": "Removal circumstances, Washington entries, FY2021-FY2022",
   "question": "Among children newly entering care, how often is parental drug or alcohol abuse recorded?",
   "operation": "Counts as printed; percent = count / entries",
   "scope": "Children entering foster care in Washington, FY2021 and FY2022",
   "resultShape": "table",
   "structuredResult": [
    {
     "fiscal_year": 2021,
     "circumstance": "Neglect",
     "children": 2350,
     "entries": 3849,
     "pct": 61.1
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Drug abuse (parent)",
     "children": 1511,
     "entries": 3849,
     "pct": 39.3
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Physical abuse",
     "children": 618,
     "entries": 3849,
     "pct": 16.1
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Housing",
     "children": 459,
     "entries": 3849,
     "pct": 11.9
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Caretaker inability to cope",
     "children": 376,
     "entries": 3849,
     "pct": 9.8
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Sexual abuse",
     "children": 243,
     "entries": 3849,
     "pct": 6.3
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Parent incarceration",
     "children": 196,
     "entries": 3849,
     "pct": 5.1
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Abandonment",
     "children": 181,
     "entries": 3849,
     "pct": 4.7
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Alcohol abuse (parent)",
     "children": 166,
     "entries": 3849,
     "pct": 4.3
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Child behavior problem",
     "children": 104,
     "entries": 3849,
     "pct": 2.7
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Parent death",
     "children": 38,
     "entries": 3849,
     "pct": 1.0
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Child disability",
     "children": 23,
     "entries": 3849,
     "pct": 0.6
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Drug abuse (child)",
     "children": 20,
     "entries": 3849,
     "pct": 0.5
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Alcohol abuse (child)",
     "children": 13,
     "entries": 3849,
     "pct": 0.3
    },
    {
     "fiscal_year": 2021,
     "circumstance": "Relinquishment",
     "children": 3,
     "entries": 3849,
     "pct": 0.1
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Neglect",
     "children": 2138,
     "entries": 3518,
     "pct": 60.8
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Drug abuse (parent)",
     "children": 1467,
     "entries": 3518,
     "pct": 41.7
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Physical abuse",
     "children": 574,
     "entries": 3518,
     "pct": 16.3
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Housing",
     "children": 433,
     "entries": 3518,
     "pct": 12.3
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Caretaker inability to cope",
     "children": 331,
     "entries": 3518,
     "pct": 9.4
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Sexual abuse",
     "children": 254,
     "entries": 3518,
     "pct": 7.2
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Parent incarceration",
     "children": 178,
     "entries": 3518,
     "pct": 5.1
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Abandonment",
     "children": 171,
     "entries": 3518,
     "pct": 4.9
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Alcohol abuse (parent)",
     "children": 144,
     "entries": 3518,
     "pct": 4.1
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Child behavior problem",
     "children": 76,
     "entries": 3518,
     "pct": 2.2
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Parent death",
     "children": 62,
     "entries": 3518,
     "pct": 1.8
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Child disability",
     "children": 25,
     "entries": 3518,
     "pct": 0.7
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Drug abuse (child)",
     "children": 18,
     "entries": 3518,
     "pct": 0.5
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Alcohol abuse (child)",
     "children": 9,
     "entries": 3518,
     "pct": 0.3
    },
    {
     "fiscal_year": 2022,
     "circumstance": "Relinquishment",
     "children": 3,
     "entries": 3518,
     "pct": 0.1
    }
   ],
   "displayResult": "Parental drug abuse was recorded for 42% of children entering care in FY2022 (1,467 of 3,518) and 39% in FY2021 (1,511 of 3,849); parental alcohol abuse for 4%. Neglect was the most common circumstance (61% both years).",
   "methodologicalNotes": [
    "The reports note the categories are not mutually exclusive.",
    "Drug and alcohol counts can't be added: a child can have both."
   ],
   "limitations": [
    "Preliminary estimates; later federal files may differ slightly.",
    "Reports for FY2023 and FY2024 were not posted at the same address."
   ],
   "executedAt": "2026-11-12T20:00:00Z"
  },
  {
   "id": "dcyf-by-age-statewide",
   "title": "DCYF: parental drug abuse among children entering care, by age, 2017-2024",
   "question": "How does the share differ by the child's age?",
   "operation": "Dashboard hover values, statewide, Parent Drug Abuse only",
   "scope": "Children entering out-of-home care in Washington, calendar years 2017-2024",
   "resultShape": "table",
   "structuredResult": [
    {
     "year": 2017,
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 76.6
    },
    {
     "year": 2018,
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 75.1
    },
    {
     "year": 2019,
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 76.4
    },
    {
     "year": 2020,
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 78.4
    },
    {
     "year": 2021,
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 78.7
    },
    {
     "year": 2022,
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 80.8
    },
    {
     "year": 2023,
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 78.3
    },
    {
     "year": 2024,
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 81.8
    },
    {
     "year": 2017,
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 42.0
    },
    {
     "year": 2018,
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 42.4
    },
    {
     "year": 2019,
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 34.8
    },
    {
     "year": 2020,
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 39.6
    },
    {
     "year": 2021,
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 41.8
    },
    {
     "year": 2022,
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 47.1
    },
    {
     "year": 2023,
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 40.9
    },
    {
     "year": 2024,
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 43.2
    },
    {
     "year": 2017,
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 28.9
    },
    {
     "year": 2018,
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 29.4
    },
    {
     "year": 2019,
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 25.9
    },
    {
     "year": 2020,
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 28.7
    },
    {
     "year": 2021,
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 28.4
    },
    {
     "year": 2022,
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 28.4
    },
    {
     "year": 2023,
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 25.1
    },
    {
     "year": 2024,
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 27.5
    }
   ],
   "displayResult": "In 2024, parental drug abuse was a contributing factor for 81.8% of newborns, 43.2% of infants and 27.5% of children aged 2 to 17 entering care. The dashboard opens on the 2-to-17 group.",
   "methodologicalNotes": [
    "The dashboard's age filter shows one group at a time and opens on ages 2 to 17.",
    "Newborns are the first 30 days of life; the dashboard does not say whether its Infants group includes them."
   ],
   "limitations": [
    "Read from hover values; the dashboard offers no all-ages figure for this chart.",
    "Parent alcohol abuse is shown separately and overlaps."
   ],
   "executedAt": "2026-11-12T20:00:00Z"
  },
  {
   "id": "dcyf-king-county",
   "title": "DCYF: King County entries by age, 2023-2024",
   "question": "Is King County different?",
   "operation": "Dashboard hover values with the geography set to King County",
   "scope": "Children removed in King County, 2023 and 2024",
   "resultShape": "table",
   "structuredResult": [
    {
     "year": 2023,
     "geography": "King County",
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 84.7,
     "parent_alcohol_pct": null,
     "neglect_pct": 44.4
    },
    {
     "year": 2024,
     "geography": "King County",
     "age_group": "Newborns (first 30 days)",
     "parent_drug_pct": 86.4,
     "parent_alcohol_pct": 2.5,
     "neglect_pct": 42.0
    },
    {
     "year": 2023,
     "geography": "King County",
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 41.3,
     "parent_alcohol_pct": 2.5,
     "neglect_pct": 67.5
    },
    {
     "year": 2024,
     "geography": "King County",
     "age_group": "Infants (under 2)",
     "parent_drug_pct": 38.7,
     "parent_alcohol_pct": 12.3,
     "neglect_pct": 65.1
    },
    {
     "year": 2023,
     "geography": "King County",
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 19.0,
     "parent_alcohol_pct": 3.4,
     "neglect_pct": 57.8
    },
    {
     "year": 2024,
     "geography": "King County",
     "age_group": "Ages 2 to 17",
     "parent_drug_pct": 18.3,
     "parent_alcohol_pct": 4.6,
     "neglect_pct": 60.8
    }
   ],
   "displayResult": "In King County in 2024, parental drug abuse was a factor for 86.4% of newborns, 38.7% of infants and 18.3% of children aged 2 to 17 entering care, compared with 81.8%, 43.2% and 27.5% statewide.",
   "methodologicalNotes": [
    "County of removal."
   ],
   "limitations": [
    "Small numbers: about 80 newborns a year."
   ],
   "executedAt": "2026-11-12T20:00:00Z"
  },
  {
   "id": "treatment",
   "title": "Addiction and treatment among caregivers, SFY2015-2018",
   "question": "Do parents whose children are removed get addiction treatment?",
   "operation": "Figures as printed in RDA report 7.121",
   "scope": "Washington caregivers in child welfare, state fiscal years 2015-2018",
   "resultShape": "table",
   "structuredResult": [
    {
     "measure": "Caregivers with a child in out-of-home placement",
     "value": 27431,
     "unit": "caregivers",
     "group": "Removed-child caregivers"
    },
    {
     "measure": "Of those, had a substance use disorder in the year before the removal",
     "value": 58,
     "unit": "percent",
     "group": "Removed-child caregivers"
    },
    {
     "measure": "Of those, number with a substance use disorder",
     "value": 15879,
     "unit": "caregivers",
     "group": "Removed-child caregivers"
    },
    {
     "measure": "Of those with a substance use disorder, got any addiction treatment within 12 months of the removal",
     "value": 49,
     "unit": "percent",
     "group": "Removed-child caregivers"
    },
    {
     "measure": "Of those with an opioid use disorder, got medication for it within 12 months",
     "value": 43,
     "unit": "percent",
     "group": "Removed-child caregivers"
    },
    {
     "measure": "All caregivers in accepted child protection cases",
     "value": 148264,
     "unit": "caregivers",
     "group": "All child-welfare caregivers"
    },
    {
     "measure": "Of those, had a substance use disorder in the year before the case",
     "value": 27,
     "unit": "percent",
     "group": "All child-welfare caregivers"
    },
    {
     "measure": "Of those with a substance use disorder, got any addiction treatment within 12 months",
     "value": 39,
     "unit": "percent",
     "group": "All child-welfare caregivers"
    }
   ],
   "displayResult": "58% of caregivers with a child removed had a substance use disorder in the year before; of those, 49% got any addiction treatment paid by Medicaid in the 12 months after the removal.",
   "methodologicalNotes": [
    "Treatment is counted only for caregivers with at least one month of Medicaid in the 12 months after (87% of removed-child caregivers)."
   ],
   "limitations": [
    "Data end in mid-2018, before fentanyl spread widely in Washington.",
    "Privately paid treatment is not counted."
   ],
   "executedAt": "2026-11-12T20:00:00Z"
  }
 ]
}