Metadata

Description

Dataset name: Public school data by state, 2017 - 2020

This dataset provides key information that we used to generate the inputs for our analysis of financial education impact on outcomes in the U.S. Federal Reserve’s Survey of Household Economics and Decisionmaking (SHED). This dataset enables users to add control variables to financial education models or harmonize spending estimates and financial education course duration across states.

Metadata for search engines

name value
1 Knology; National Endowment for Financial Education
x
State
SalaryInstructorAve
MedianLaborIncome
PopulationK4
Population58
Population912
TotalHSCreditsRequired
Standalone_Required
Standalone_Offered
Embedded_Required
Embedded_Offered
No_Offerings
Total_Offerings_Number

#Variables

State

U.S. State

Distribution

## 52  unique, categorical values, so not shown.

1 missing values.

Summary statistics

name label data_type ordered value_labels n_missing complete_rate n_unique top_counts
State U.S. State factor FALSE 1. Not asked,
2. REFUSED,
3. Alabama,
4. Alaska,
5. Arizona,
6. Arkansas,
7. California,
8. Colorado,
9. Connecticut,
10. Delaware,
11. Florida,
12. Georgia,
13. Hawaii,
14. Idaho,
15. Illinois,
16. Indiana,
17. Iowa,
18. Kansas,
19. Kentucky,
20. Louisiana,
21. Maine,
22. Maryland,
23. Massachusetts,
24. Michigan,
25. Minnesota,
26. Mississippi,
27. Missouri,
28. Montana,
29. Nebraska,
30. Nevada,
31. New Hampshire,
32. New Jersey,
33. New Mexico,
34. New York,
35. North Carolina,
36. North Dakota,
37. Ohio,
38. Oklahoma,
39. Oregon,
40. Pennsylvania,
41. Rhode Island,
42. South Carolina,
43. South Dakota,
44. Tennessee,
45. Texas,
46. Utah,
47. Vermont,
48. Virginia,
49. Washington,
50. West Virginia,
51. Wisconsin,
52. Wyoming,
53. American Samoa,
54. District of Columbia,
55. Guam,
56. Puerto Rico,
57. Virgin Islands
1 0.9811321 52 Ala: 1, Ala: 1, Ari: 1, Ark: 1

SalaryInstructorAve

Average salaries of instructional staff in public schools

Distribution

Distribution of values for SalaryInstructorAve

Distribution of values for SalaryInstructorAve

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
SalaryInstructorAve Average salaries of instructional staff in public schools numeric 1 0.9811321 44908 56616 82064 59048.96 9492.444 <U+2586><U+2587><U+2583><U+2582><U+2582>

MedianLaborIncome

Median earnings (dollars) for full-time, year-round workers with earnings

Distribution

Distribution of values for MedianLaborIncome

Distribution of values for MedianLaborIncome

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
MedianLaborIncome Median earnings (dollars) for full-time, year-round workers with earnings numeric 0 1 23527 44783 69503 45452.72 7000.439 <U+2581><U+2586><U+2587><U+2583><U+2581>

PopulationK4

school enrollment, Kindergarten-4th grade

Distribution

Distribution of values for PopulationK4

Distribution of values for PopulationK4

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
PopulationK4 school enrollment, Kindergarten-4th grade numeric 1 0.9811321 32730 278535 2491526 397478.6 464041.3 <U+2587><U+2582><U+2581><U+2581><U+2581>

Population58

school enrollment, 5th-8th grade

Distribution

Distribution of values for Population58

Distribution of values for Population58

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
Population58 school enrollment, 5th-8th grade numeric 1 0.9811321 20279 218832 2e+06 320662.4 374427.8 <U+2587><U+2582><U+2581><U+2581><U+2581>

Population912

school enrollment, 9th-12th grade

Distribution

Distribution of values for Population912

Distribution of values for Population912

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
Population912 school enrollment, 9th-12th grade numeric 1 0.9811321 23577 214679 2174435 330480.1 390494.1 <U+2587><U+2582><U+2581><U+2581><U+2581>

TotalHSCreditsRequired

Number of credits required to graduate high school

Distribution

Distribution of values for TotalHSCreditsRequired

Distribution of values for TotalHSCreditsRequired

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
TotalHSCreditsRequired Number of credits required to graduate high school numeric 1 0.9811321 11 22 200 27.375 27.87487 <U+2587><U+2581><U+2581><U+2581><U+2581>

Standalone_Required

Number of students, standalone financial education course required to graduate

Distribution

Distribution of values for Standalone_Required

Distribution of values for Standalone_Required

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
Standalone_Required Number of students, standalone financial education course required to graduate numeric 1 0.9811321 0 5702 1602678 61641.46 226418.7 <U+2587><U+2581><U+2581><U+2581><U+2581>

Standalone_Offered

Number of students, standalone financial education course offered

Distribution

Distribution of values for Standalone_Offered

Distribution of values for Standalone_Offered

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
Standalone_Offered Number of students, standalone financial education course offered numeric 1 0.9811321 0 38457 3622490 139326.5 501293.5 <U+2587><U+2581><U+2581><U+2581><U+2581>

Embedded_Required

Number of students, embedded financial education course required to graduate

Distribution

Distribution of values for Embedded_Required

Distribution of values for Embedded_Required

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
Embedded_Required Number of students, embedded financial education course required to graduate numeric 1 0.9811321 0 4908 1512512 58173.54 215293.7 <U+2587><U+2581><U+2581><U+2581><U+2581>

Embedded_Offered

Number of students, embedded financial education course offered

Distribution

Distribution of values for Embedded_Offered

Distribution of values for Embedded_Offered

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
Embedded_Offered Number of students, embedded financial education course offered numeric 1 0.9811321 0 10031 1401295 53895.96 197760.6 <U+2587><U+2581><U+2581><U+2581><U+2581>

No_Offerings

Number of students, no financial education course offered

Distribution

Distribution of values for No_Offerings

Distribution of values for No_Offerings

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
No_Offerings Number of students, no financial education course offered numeric 1 0.9811321 0 2608 632487 24326.42 96476.32 <U+2587><U+2581><U+2581><U+2581><U+2581>

Total_Offerings_Number

Number of students, data available on financial education course offerings

Distribution

Distribution of values for Total_Offerings_Number

Distribution of values for Total_Offerings_Number

1 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
Total_Offerings_Number Number of students, data available on financial education course offerings numeric 1 0.9811321 3838 118251 8771462 337363.9 1209211 <U+2587><U+2581><U+2581><U+2581><U+2581>

Missingness report

Codebook table

JSON-LD metadata The following JSON-LD can be found by search engines, if you share this codebook publicly on the web.

{
  "name": "Public school data by state, 2017 - 2020",
  "description": "This dataset provides key information that we used to generate the inputs for our analysis of financial education impact on outcomes in the U.S. Federal Reserve’s Survey of Household Economics and Decisionmaking (SHED). This dataset enables users to add control variables to financial education models or harmonize spending estimates and financial education course duration across states.\n\n\n## Table of variables\nThis table contains variable names, labels, and number of missing values.\nSee the complete codebook for more.\n\n|name                   |label                                                                          | n_missing|\n|:----------------------|:------------------------------------------------------------------------------|---------:|\n|State                  |U.S. State                                                                     |         1|\n|SalaryInstructorAve    |Average salaries of instructional staff in public schools                      |         1|\n|MedianLaborIncome      |Median earnings (dollars) for full-time, year-round workers with earnings      |         0|\n|PopulationK4           |school enrollment, Kindergarten-4th grade                                      |         1|\n|Population58           |school enrollment, 5th-8th grade                                               |         1|\n|Population912          |school enrollment, 9th-12th grade                                              |         1|\n|TotalHSCreditsRequired |Number of credits required to graduate high school                             |         1|\n|Standalone_Required    |Number of students, standalone financial education course required to graduate |         1|\n|Standalone_Offered     |Number of students, standalone financial education course offered              |         1|\n|Embedded_Required      |Number of students, embedded financial education course required to graduate   |         1|\n|Embedded_Offered       |Number of students, embedded financial education course offered                |         1|\n|No_Offerings           |Number of students, no financial education course offered                      |         1|\n|Total_Offerings_Number |Number of students, data available on financial education course offerings     |         1|\n\n### Note\nThis dataset was automatically described using the [codebook R package](https://rubenarslan.github.io/codebook/) (version 0.9.2).",
  "identifier": "https://dx.doi.org/....",
  "creator": "Knology; National Endowment for Financial Education",
  "citation": "Dwyer, Joseph de la Torre, Field, Shaun, Flinner, Kate, Attaway, Elizabeth, Norlander, Rebecca, and LaMarca, Nicole. (2020). KnologyFinEdStateSpending.",
  "url": "https://gitlab.com/knologyresearch/KnologyFinEdStateSpending",
  "datePublished": "NA",
  "temporalCoverage": "2017 - 2020",
  "spatialCoverage": "U.S. States",
  "keywords": ["State", "SalaryInstructorAve", "MedianLaborIncome", "PopulationK4", "Population58", "Population912", "TotalHSCreditsRequired", "Standalone_Required", "Standalone_Offered", "Embedded_Required", "Embedded_Offered", "No_Offerings", "Total_Offerings_Number"],
  "@context": "http://schema.org/",
  "@type": "Dataset",
  "variableMeasured": [
    {
      "name": "State",
      "description": "U.S. State",
      "value": "1. Not asked,\n2. REFUSED,\n3. Alabama,\n4. Alaska,\n5. Arizona,\n6. Arkansas,\n7. California,\n8. Colorado,\n9. Connecticut,\n10. Delaware,\n11. Florida,\n12. Georgia,\n13. Hawaii,\n14. Idaho,\n15. Illinois,\n16. Indiana,\n17. Iowa,\n18. Kansas,\n19. Kentucky,\n20. Louisiana,\n21. Maine,\n22. Maryland,\n23. Massachusetts,\n24. Michigan,\n25. Minnesota,\n26. Mississippi,\n27. Missouri,\n28. Montana,\n29. Nebraska,\n30. Nevada,\n31. New Hampshire,\n32. New Jersey,\n33. New Mexico,\n34. New York,\n35. North Carolina,\n36. North Dakota,\n37. Ohio,\n38. Oklahoma,\n39. Oregon,\n40. Pennsylvania,\n41. Rhode Island,\n42. South Carolina,\n43. South Dakota,\n44. Tennessee,\n45. Texas,\n46. Utah,\n47. Vermont,\n48. Virginia,\n49. Washington,\n50. West Virginia,\n51. Wisconsin,\n52. Wyoming,\n53. American Samoa,\n54. District of Columbia,\n55. Guam,\n56. Puerto Rico,\n57. Virgin Islands",
      "@type": "propertyValue"
    },
    {
      "name": "SalaryInstructorAve",
      "description": "Average salaries of instructional staff in public schools",
      "@type": "propertyValue"
    },
    {
      "name": "MedianLaborIncome",
      "description": "Median earnings (dollars) for full-time, year-round workers with earnings",
      "@type": "propertyValue"
    },
    {
      "name": "PopulationK4",
      "description": "school enrollment, Kindergarten-4th grade",
      "@type": "propertyValue"
    },
    {
      "name": "Population58",
      "description": "school enrollment, 5th-8th grade",
      "@type": "propertyValue"
    },
    {
      "name": "Population912",
      "description": "school enrollment, 9th-12th grade",
      "@type": "propertyValue"
    },
    {
      "name": "TotalHSCreditsRequired",
      "description": "Number of credits required to graduate high school",
      "@type": "propertyValue"
    },
    {
      "name": "Standalone_Required",
      "description": "Number of students, standalone financial education course required to graduate",
      "@type": "propertyValue"
    },
    {
      "name": "Standalone_Offered",
      "description": "Number of students, standalone financial education course offered",
      "@type": "propertyValue"
    },
    {
      "name": "Embedded_Required",
      "description": "Number of students, embedded financial education course required to graduate",
      "@type": "propertyValue"
    },
    {
      "name": "Embedded_Offered",
      "description": "Number of students, embedded financial education course offered",
      "@type": "propertyValue"
    },
    {
      "name": "No_Offerings",
      "description": "Number of students, no financial education course offered",
      "@type": "propertyValue"
    },
    {
      "name": "Total_Offerings_Number",
      "description": "Number of students, data available on financial education course offerings",
      "@type": "propertyValue"
    }
  ]
}`