Metadata

Description

Dataset name: Pooled National Center for Charitable Statistics (NCCS) data, 2000 – 2015 (NCCSAY)

This dataset, NCCSAY, (where ‘AY’ stands for All Years) provides a user with pooled data on Private Charities and Private Foundations reported to the IRS in Form 990 and then published by the IRS as NCCS Core files.

Metadata for search engines

name value
1 Knology; National Endowment for Financial Education
x
NAME
State
FISYR
NTEEFINAL
EXPS
fined
finlit
monmgt
keywords
fincounsel
FINED

#Variables

NAME

Name of organization

Distribution

Distribution of values for NAME

Distribution of values for NAME

0 missing values.

Summary statistics

name label data_type n_missing complete_rate n_unique empty min max whitespace
NAME Name of organization character 0 1 846955 22217 0 109 0

State

U.S. State

Distribution

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

110227 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
110227 0.9840906 50 Cal: 783368, New: 591730, Tex: 406172, Pen: 330591

FISYR

Fiscal year

Distribution

Distribution of values for FISYR

Distribution of values for FISYR

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
FISYR Fiscal year numeric 0 1 1998 2008 2016 2008.093 4.586543 <U+2583><U+2586><U+2586><U+2587><U+2587>

NTEEFINAL

Final National Taxonomy of Exempt Entities (NTEE) code

Distribution

Distribution of values for NTEEFINAL

Distribution of values for NTEEFINAL

0 missing values.

Summary statistics

name label data_type n_missing complete_rate n_unique empty min max whitespace
NTEEFINAL Final National Taxonomy of Exempt Entities (NTEE) code character 0 1 2883 14022 0 5 0

EXPS

Total expenses

Distribution

Distribution of values for EXPS

Distribution of values for EXPS

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
EXPS Total expenses numeric 0 1 -1.1e+09 99931 4.8e+10 3153948 69024229 <U+2587><U+2581><U+2581><U+2581><U+2581>

fined

NAME contains ‘financial’ and ‘education’

Distribution

Distribution of values for fined

Distribution of values for fined

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
fined NAME contains ‘financial’ and ‘education’ numeric 0 1 0 0 1 6.83e-05 0.0082623 <U+2587><U+2581><U+2581><U+2581><U+2581>

finlit

NAME contains ‘financial’ and ‘literacy’

Distribution

Distribution of values for finlit

Distribution of values for finlit

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
finlit NAME contains ‘financial’ and ‘literacy’ numeric 0 1 0 0 1 4.37e-05 0.0066129 <U+2587><U+2581><U+2581><U+2581><U+2581>

monmgt

NAME contains ‘money’ and ‘management’

Distribution

Distribution of values for monmgt

Distribution of values for monmgt

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
monmgt NAME contains ‘money’ and ‘management’ numeric 0 1 0 0 1 9.8e-06 0.0031328 <U+2587><U+2581><U+2581><U+2581><U+2581>

keywords

fined, finlit, or monmgt is TRUE

Distribution

Distribution of values for keywords

Distribution of values for keywords

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
keywords fined, finlit, or monmgt is TRUE numeric 0 1 0 0 1 0.0001186 0.0108916 <U+2587><U+2581><U+2581><U+2581><U+2581>

fincounsel

NTEEFINAL is ‘P51’

Distribution

Distribution of values for fincounsel

Distribution of values for fincounsel

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
fincounsel NTEEFINAL is ‘P51’ numeric 0 1 0 0 1 0.0008559 0.0292432 <U+2587><U+2581><U+2581><U+2581><U+2581>

FINED

keywords or NTEEFINAL is TRUE

Distribution

Distribution of values for FINED

Distribution of values for FINED

0 missing values.

Summary statistics

name label data_type n_missing complete_rate min median max mean sd hist
FINED keywords or NTEEFINAL is TRUE numeric 0 1 0 0 1 0.0009551 0.0308891 <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": "Pooled National Center for Charitable Statistics (NCCS) data, 2000 – 2015 (NCCSAY)",
  "description": "This dataset, NCCSAY, (where 'AY' stands for All Years) provides a user with pooled data on Private Charities and Private Foundations reported to the IRS in Form 990 and then published by the IRS as NCCS Core files.\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|NAME       |Name of organization                                         |         0|\n|State      |U.S. State                                                   |    110227|\n|FISYR      |Fiscal year                                                  |         0|\n|NTEEFINAL  |Final National  Taxonomy  of  Exempt  Entities  (NTEE)  code |         0|\n|EXPS       |Total expenses                                               |         0|\n|fined      |NAME contains 'financial' and 'education'                    |         0|\n|finlit     |NAME contains 'financial' and 'literacy'                     |         0|\n|monmgt     |NAME contains 'money' and 'management'                       |         0|\n|keywords   |fined, finlit, or monmgt is TRUE                             |         0|\n|fincounsel |NTEEFINAL is 'P51'                                           |         0|\n|FINED      |keywords or NTEEFINAL is TRUE                                |         0|\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": "2018",
  "temporalCoverage": "2000 - 2015",
  "spatialCoverage": "United States",
  "keywords": ["NAME", "State", "FISYR", "NTEEFINAL", "EXPS", "fined", "finlit", "monmgt", "keywords", "fincounsel", "FINED"],
  "@context": "http://schema.org/",
  "@type": "Dataset",
  "variableMeasured": [
    {
      "name": "NAME",
      "description": "Name of organization",
      "@type": "propertyValue"
    },
    {
      "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": "FISYR",
      "description": "Fiscal year",
      "@type": "propertyValue"
    },
    {
      "name": "NTEEFINAL",
      "description": "Final National  Taxonomy  of  Exempt  Entities  (NTEE)  code",
      "@type": "propertyValue"
    },
    {
      "name": "EXPS",
      "description": "Total expenses",
      "@type": "propertyValue"
    },
    {
      "name": "fined",
      "description": "NAME contains 'financial' and 'education'",
      "@type": "propertyValue"
    },
    {
      "name": "finlit",
      "description": "NAME contains 'financial' and 'literacy'",
      "@type": "propertyValue"
    },
    {
      "name": "monmgt",
      "description": "NAME contains 'money' and 'management'",
      "@type": "propertyValue"
    },
    {
      "name": "keywords",
      "description": "fined, finlit, or monmgt is TRUE",
      "@type": "propertyValue"
    },
    {
      "name": "fincounsel",
      "description": "NTEEFINAL is 'P51'",
      "@type": "propertyValue"
    },
    {
      "name": "FINED",
      "description": "keywords or NTEEFINAL is TRUE",
      "@type": "propertyValue"
    }
  ]
}`