Pennsylvania · 345 institutions

Table coverage

Name: CourseShelf publish 59: Pennsylvania table coverage
Creator: KSAWorks

Every table in the CourseShelf database, with the rows it holds for Pennsylvania, how many institutions have any, how many of its columns carry a CTDL term and a CEDS element, and, column by column, how many of its rows carry a value. A table at 0 is listed, never hidden.

Area	Table	Rows	Institutions	Reached through	CTDL	CEDS	Fields filled
Policies	academic_policy	3,384	170	institution	0 / 19	0 / 19	18 of 19 columns carry a value capture_file 3,384 of 3,384 catalog_year 3,302 of 3,384 current_version 3,384 of 3,384 first_edition_seen 3,163 of 3,384 key_from 30 of 3,384 last_edition_seen 3,163 of 3,384 organization_id 3,384 of 3,384 page_number 1,213 of 3,384 policy_id 3,384 of 3,384 policy_section 3,384 of 3,384 policy_text 3,384 of 3,384 policy_title 2,006 of 3,384 record_key 3,384 of 3,384 school 0 of 3,384 source_catalog_name 830 of 3,384 source_count 3,384 of 3,384 source_url 3,384 of 3,384 version_count 3,384 of 3,384 year 3,384 of 3,384
	academic_policy_version	0	0	institution	0 / 19	0 / 19
Programs	academic_program	20,521	136	institution	12 / 49	7 / 49	43 of 49 columns carry a value award_credential_class 11,823 of 20,521 award_ipeds_levels 11,823 of 20,521 award_title 15,511 of 20,521 capture_file 20,521 of 20,521 catalog_id 19,920 of 20,521 catalog_year 20,296 of 20,521 cip_candidates 12,656 of 20,521 cip_closest_mutual 4,474 of 20,521 cip_code 6,751 of 20,521 cip_family_inferred 142 of 20,521 cip_match_score 20,010 of 20,521 cip_printed 25 of 20,521 cip_source 20,521 of 20,521 college 2,887 of 20,521 concentration 1,177 of 20,521 courseatlas_program_id 0 of 20,521 credit_unit 0 of 20,521 credits_max 4,188 of 20,521 credits_min 4,188 of 20,521 credits_required 4,192 of 20,521 current_version 20,521 of 20,521 delivery_type 0 of 20,521 description 15,247 of 20,521 first_edition_seen 20,115 of 20,521 key_from 271 of 20,521 last_edition_seen 20,115 of 20,521 major 7,148 of 20,521 major_minor_id 6,751 of 20,521 minor 5,035 of 20,521 name 20,521 of 20,521 normal_length 240 of 20,521 organization_id 20,521 of 20,521 parent_program_id 796 of 20,521 parent_program_key 806 of 20,521 program_code 1,024 of 20,521 program_concentration_type 20,487 of 20,521 program_id 20,521 of 20,521 program_key 20,250 of 20,521 program_length_hours 0 of 20,521 program_source 20,521 of 20,521 record_key 20,521 of 20,521 school 0 of 20,521 source_catalog_name 5,350 of 20,521 source_count 20,521 of 20,521 source_url 20,521 of 20,521 term 0 of 20,521 uid 20,521 of 20,521 version_count 20,521 of 20,521 year 20,521 of 20,521
	academic_program_fts	no route		not per school	0 / 4	0 / 4
	academic_program_fts_config	no route		not per school	0 / 2	0 / 2
	academic_program_fts_content	no route		not per school	0 / 5	0 / 5
	academic_program_fts_data	no route		not per school	0 / 2	0 / 2
	academic_program_fts_docsize	no route		not per school	0 / 2	0 / 2
	academic_program_fts_idx	no route		not per school	0 / 3	0 / 3
	academic_program_version	0	0	institution	12 / 49	7 / 49
Agreements	agreement	480	116	institution	1 / 24	0 / 24	18 of 24 columns carry a value agreement_id 480 of 480 agreement_type 480 of 480 agreement_type_as_printed 33 of 480 capture_file 480 of 480 current_version 480 of 480 edition_lineage 0 of 480 effective_end 0 of 480 effective_start 0 of 480 first_edition_seen 456 of 480 instrument_key 2 of 480 key_from 33 of 480 key_identity 480 of 480 last_edition_seen 456 of 480 organization_id 480 of 480 record_key 480 of 480 school 0 of 480 source_catalog_name 93 of 480 source_count 480 of 480 source_url 480 of 480 status 0 of 480 title 480 of 480 uid 0 of 480 version_count 480 of 480 year 480 of 480
Agreements	agreement_party	8	7	institution	0 / 7	0 / 7	7 of 7 columns carry a value agreement_id 8 of 8 identity 8 of 8 org_kind 8 of 8 org_name 8 of 8 organization_id 8 of 8 position 8 of 8 role 2 of 8
	agreement_party_version	0	0	institution	0 / 9	0 / 9
	agreement_signatory	0	0	institution	0 / 7	0 / 7
	agreement_signatory_version	0	0	institution	0 / 9	0 / 9
Agreements	agreement_spine	169	3	via agreement	0 / 8	0 / 8	8 of 8 columns carry a value agreement_id 169 of 169 assigned_by 169 of 169 category 71 of 169 heading 70 of 169 pages 169 of 169 position 169 of 169 term 169 of 169 text 169 of 169
	agreement_spine_version	no route		not per school	0 / 10	0 / 10
	agreement_type_term	no route		not per school	1 / 7	0 / 7
	agreement_version	0	0	institution	1 / 22	0 / 22
	build_info	no route		not per school	0 / 8	0 / 8
Catalogs	catalog	340	243	institution	1 / 8	1 / 8	8 of 8 columns carry a value bytes 340 of 340 captured_at 340 of 340 catalog_id 340 of 340 catalog_year 89 of 340 format 340 of 340 owner_organization_id 340 of 340 sha256 340 of 340 source_url 340 of 340
	certification_cip	0	0	via industry_certification	1 / 3	0 / 3
	certification_occupation	0	0	via industry_certification	1 / 2	1 / 2
	certification_renewal	0	0	via industry_certification	0 / 3	0 / 3
	certification_requirement	0	0	via industry_certification	0 / 3	0 / 3
Checklists	checklist	19,540	135	institution	8 / 37	8 / 37	27 of 37 columns carry a value agreement_id 0 of 19,540 assembly_note 19,540 of 19,540 award_title 19,540 of 19,540 capture_file 19,540 of 19,540 catalog_year 19,315 of 19,540 checklist_id 19,540 of 19,540 checklist_type 19,540 of 19,540 cip_code 6,474 of 19,540 cip_source 6,474 of 19,540 credential_class 0 of 19,540 credit_unit 0 of 19,540 credits_computed 14,573 of 19,540 credits_max 0 of 19,540 credits_min 0 of 19,540 credits_published 4,190 of 19,540 current_version 19,540 of 19,540 description 0 of 19,540 effective_end 0 of 19,540 effective_start 0 of 19,540 first_edition_seen 19,134 of 19,540 key_from 271 of 19,540 last_edition_seen 19,134 of 19,540 organization_id 19,540 of 19,540 program_id 19,260 of 19,540 program_key 19,269 of 19,540 program_link_method 19,260 of 19,540 program_name 19,540 of 19,540 record_key 19,540 of 19,540 school 0 of 19,540 soc_code 0 of 19,540 source_catalog_name 4,854 of 19,540 source_count 19,540 of 19,540 source_url 19,540 of 19,540 uid 19,540 of 19,540 ungathered_note 19,269 of 19,540 version_count 19,540 of 19,540 year 19,540 of 19,540
Checklists	checklist_certification	0	0	via requirement_item > requirement_group > checklist	0 / 5	0 / 5
Checklists	checklist_note	101,146	57	via checklist	0 / 3	0 / 3	3 of 3 columns carry a value checklist_id 101,146 of 101,146 note_text 101,146 of 101,146 position 101,146 of 101,146
	checklist_note_version	no route		not per school	0 / 5	0 / 5
Checklists	checklist_occupation	0	0	via checklist	0 / 3	0 / 3
Checklists	checklist_outcome	707	3	via checklist	0 / 3	0 / 3	3 of 3 columns carry a value checklist_id 707 of 707 outcome_text 707 of 707 position 707 of 707
	checklist_outcome_version	no route		not per school	0 / 5	0 / 5
Checklists	checklist_party	0	0	institution	0 / 5	0 / 5
	checklist_version	0	0	institution	8 / 37	8 / 37
	cip_code	no route		not per school	1 / 14	2 / 14
	cip_edition_crosswalk	no route		not per school	0 / 8	4 / 8
	cip_soc	no route		not per school	2 / 7	2 / 7
Comparability	comparability	1,567	63	institution	1 / 50	0 / 50	29 of 50 columns carry a value acceptance 0 of 1,567 acceptance_as_printed 0 of 1,567 agreement_id 0 of 1,567 applicability_link 15 of 1,567 applicability_scope 822 of 1,567 applies_to_program 15 of 1,567 as_held 1,567 of 1,567 bundle_type 1,567 of 1,567 capture_file 1,567 of 1,567 catalog_year 1,554 of 1,567 checklist_id 0 of 1,567 checklist_key 0 of 1,567 collegeboard_check 627 of 1,567 collegeboard_courses 139 of 1,567 collegeboard_min_score 139 of 1,567 comparability_id 1,567 of 1,567 condition_text 18 of 1,567 course_connective 43 of 1,567 course_level 0 of 1,567 course_sequence 0 of 1,567 credit_unit 0 of 1,567 credits_applied 0 of 1,567 credits_awarded_max 0 of 1,567 credits_awarded_min 0 of 1,567 credits_awarded_published 197 of 1,567 current_version 1,567 of 1,567 effective_end 0 of 1,567 effective_start 0 of 1,567 exam_code 0 of 1,567 exam_program 627 of 1,567 first_edition_seen 1,537 of 1,567 gen_ed_category 0 of 1,567 key_from 16 of 1,567 last_edition_seen 1,537 of 1,567 match_confidence 0 of 1,567 pathway_id 940 of 1,567 policy_shape 627 of 1,567 receiving_organization_id 1,567 of 1,567 record_key 1,567 of 1,567 requirement_group 0 of 1,567 requirement_group_id 0 of 1,567 school 0 of 1,567 source_approved_at 0 of 1,567 source_authority 1,567 of 1,567 source_catalog_name 219 of 1,567 source_count 1,567 of 1,567 source_revised_at 0 of 1,567 source_url 1,567 of 1,567 version_count 1,567 of 1,567 year 1,567 of 1,567
Comparability	comparability_source	1,552	62	via comparability	1 / 10	0 / 10	6 of 10 columns carry a value comparability_id 1,552 of 1,552 learning_unit_id 0 of 1,552 learning_unit_key 0 of 1,552 minimum_grade 548 of 1,552 position 1,552 of 1,552 sending_org_name 1,281 of 1,552 sending_organization_id 0 of 1,552 source_kind 925 of 1,552 source_unit_ref 0 of 1,552 unit_text 1,436 of 1,552
	comparability_source_version	no route		not per school	1 / 12	0 / 12
Comparability	comparability_substitute	1,487	23	via comparability	1 / 8	0 / 8	7 of 8 columns carry a value comparability_id 1,487 of 1,487 credits 507 of 1,487 learning_unit_id 1,156 of 1,487 learning_unit_key 15 of 1,487 position 1,487 of 1,487 receiving_org_name 768 of 1,487 source_unit_ref 0 of 1,487 unit_text 1,487 of 1,487
	comparability_substitute_version	no route		not per school	1 / 10	0 / 10
	comparability_version	no route		not per school	1 / 48	0 / 48
	comparable_member	0	0	via learning_unit	1 / 5	0 / 5
	field_of_study_outcome	no route		not per school	4 / 33	1 / 33
	framework_code	0	0	institution	0 / 18	0 / 18
	framework_code_version	0	0	institution	0 / 18	0 / 18
Certifications	industry_certification	0	0	institution	6 / 19	4 / 19
Catalogs	institution_catalog	384	262	institution	0 / 3	0 / 3	3 of 3 columns carry a value catalog_id 384 of 384 organization_id 384 of 384 shared_from_organization_id 40 of 384
	ipeds_completion	29,472	314	institution	0 / 11	3 / 11	9 of 11 columns carry a value awlevel 29,472 of 29,472 cip_code 29,472 of 29,472 completers 29,472 of 29,472 completers_flag 29,472 of 29,472 ipeds_year 29,472 of 29,472 majornum 29,472 of 29,472 organization_id 29,472 of 29,472 reference_source 29,472 of 29,472 retired_at 0 of 29,472 retired_by_source 0 of 29,472 unitid 29,472 of 29,472
Courses	learning_unit	232,749	166	institution	7 / 36	6 / 36	29 of 36 columns carry a value capture_file 232,749 of 232,749 catalog_year 224,291 of 232,749 cip_code 0 of 232,749 code_alias 0 of 232,749 created_from 72 of 232,749 created_reason 72 of 232,749 credit_basis 0 of 232,749 credit_unit 156,999 of 232,749 credits_max 176,245 of 232,749 credits_min 176,245 of 232,749 credits_published 176,279 of 232,749 current_version 232,749 of 232,749 description 190,467 of 232,749 first_edition_seen 209,827 of 232,749 key_from 232,749 of 232,749 last_edition_seen 209,827 of 232,749 learning_unit_id 232,749 of 232,749 limitations 0 of 232,749 near_match 14 of 232,749 organization_id 232,749 of 232,749 record_key 232,749 of 232,749 repeatable 14,972 of 232,749 repeatable_max 0 of 232,749 resolution_tried 72 of 232,749 school 0 of 232,749 source_catalog_name 68,879 of 232,749 source_count 232,749 of 232,749 source_url 232,749 of 232,749 subject_abbreviation 231,203 of 232,749 title 232,686 of 232,749 transferability 0 of 232,749 uid 232,749 of 232,749 unit_code 231,204 of 232,749 unit_type 232,749 of 232,749 version_count 232,749 of 232,749 year 232,749 of 232,749
Courses	learning_unit_alias	245	21	via learning_unit	1 / 4	0 / 4	4 of 4 columns carry a value alias_learning_unit_id 199 of 245 alias_text 245 of 245 learning_unit_id 245 of 245 position 245 of 245
	learning_unit_alias_version	no route		not per school	1 / 6	0 / 6
Courses	learning_unit_articulation	0	0	via learning_unit	1 / 4	0 / 4
	learning_unit_articulation_version	no route		not per school	1 / 6	0 / 6
Frameworks	learning_unit_framework	0	0	institution	0 / 20	0 / 20
	learning_unit_framework_version	0	0	institution	0 / 20	0 / 20
	learning_unit_fts	no route		not per school	0 / 3	0 / 3
	learning_unit_fts_config	no route		not per school	0 / 2	0 / 2
	learning_unit_fts_content	no route		not per school	0 / 4	0 / 4
	learning_unit_fts_data	no route		not per school	0 / 2	0 / 2
	learning_unit_fts_docsize	no route		not per school	0 / 2	0 / 2
	learning_unit_fts_idx	no route		not per school	0 / 3	0 / 3
Courses	learning_unit_hours	0	0	via learning_unit	0 / 5	0 / 5
	learning_unit_hours_version	no route		not per school	0 / 7	0 / 7
Courses	learning_unit_offering	0	0	via learning_unit	0 / 3	0 / 3
	learning_unit_offering_version	no route		not per school	0 / 5	0 / 5
Courses	learning_unit_outcome	0	0	via learning_unit	0 / 3	0 / 3
	learning_unit_outcome_version	no route		not per school	0 / 5	0 / 5
Courses	learning_unit_requisite	22,411	80	via learning_unit	1 / 5	0 / 5	4 of 5 columns carry a value learning_unit_id 22,411 of 22,411 position 22,411 of 22,411 requisite_text 22,411 of 22,411 requisite_type 22,411 of 22,411 target_learning_unit_id 0 of 22,411
	learning_unit_requisite_version	no route		not per school	1 / 7	0 / 7
	learning_unit_version	0	0	institution	7 / 36	5 / 36
	load_partition	no route		not per school	0 / 15	0 / 15
	major_minor	no route		not per school	1 / 12	1 / 12
	major_minor_change	no route		not per school	0 / 8	0 / 8
	major_minor_level	no route		not per school	0 / 12	2 / 12
	major_minor_program_link	0	0	institution	0 / 10	0 / 10
	model_binding	no route		not per school	0 / 9	0 / 9
	organization	345	345	institution	6 / 10	2 / 10	8 of 10 columns carry a value ipeds_unit_id 344 of 345 legal_name 0 of 345 mission_statement 0 of 345 name 345 of 345 operational_status 5 of 345 operational_status_note 1 of 345 organization_id 345 of 345 organization_type 1 of 345 sector 345 of 345 uid 345 of 345
Accreditation	organization_accreditation	0	0	institution	1 / 9	3 / 9
	organization_address	345	345	institution	3 / 12	3 / 12	5 of 12 columns carry a value address_type 345 of 345 campus_name 0 of 345 city 344 of 345 country 0 of 345 county 0 of 345 latitude 0 of 345 longitude 0 of 345 organization_id 345 of 345 position 345 of 345 postal_code 0 of 345 state 345 of 345 street 0 of 345
Academic calendar	organization_calendar	0	0	institution	0 / 7	0 / 7
	organization_contact	0	0	institution	1 / 6	1 / 6
	organization_cost	1,736	290	institution	1 / 11	1 / 11	8 of 11 columns carry a value amount 1,736 of 1,736 basis 1,736 of 1,736 capture_file 1,736 of 1,736 cost_type 1,736 of 1,736 cost_year 0 of 1,736 organization_id 1,736 of 1,736 position 1,736 of 1,736 reference_source 1,736 of 1,736 retired_at 0 of 1,736 retired_by_source 0 of 1,736 source_url 1,736 of 1,736
	organization_event	8	7	institution	0 / 10	0 / 10	10 of 10 columns carry a value detail_json 8 of 8 evidence 8 of 8 holding_json 6 of 8 kind 8 of 8 note 1 of 8 observed_at 8 of 8 org_id 8 of 8 position 8 of 8 recorded_by 8 of 8 source 8 of 8
	organization_identifier	688	344	institution	1 / 4	1 / 4	4 of 4 columns carry a value identifier_source 688 of 688 identifier_system 688 of 688 identifier_value 688 of 688 organization_id 688 of 688
References	organization_reference	0	0	institution	0 / 11	0 / 11
	organization_relationship	1	1	institution	1 / 5	1 / 5	5 of 5 columns carry a value observed_at 1 of 1 organization_id 1 of 1 related_org_id 1 of 1 relationship_type 1 of 1 source 1 of 1
	organization_website	340	340	institution	1 / 5	1 / 5	4 of 5 columns carry a value catalog_format 0 of 340 organization_id 340 of 340 position 340 of 340 web_address 340 of 340 web_role 340 of 340
Pathways	pathway	784	28	institution	2 / 29	0 / 29	19 of 29 columns carry a value agreement_id 0 of 784 agreement_named 0 of 784 capture_file 784 of 784 checklist_id 0 of 784 cip_code 13 of 784 current_version 784 of 784 edition_lineage 0 of 784 effective_end 0 of 784 effective_start 0 of 784 first_edition_seen 76 of 784 instrument_key 19 of 784 key_from 756 of 784 key_identity 784 of 784 last_edition_seen 76 of 784 organization_id 784 of 784 pathway_id 784 of 784 pathway_type 784 of 784 perspective 4 of 784 publisher_organization_id 784 of 784 record_key 784 of 784 school 0 of 784 source_catalog_name 0 of 784 source_count 784 of 784 source_url 784 of 784 status 0 of 784 title 784 of 784 uid 0 of 784 version_count 784 of 784 year 784 of 784
	pathway_contact	0	0	institution	0 / 5	0 / 5
	pathway_version	0	0	institution	2 / 27	0 / 27
	person	no route		not per school	1 / 10	4 / 10
Programs	program_identifier	0	0	via academic_program	0 / 3	0 / 3
Programs	program_offering	0	0	via academic_program	0 / 5	0 / 5
Programs	program_subject	129,063	132	via academic_program	0 / 3	0 / 3	3 of 3 columns carry a value items 129,063 of 129,063 program_id 129,063 of 129,063 subject 129,063 of 129,063
	record_id_alias	no route		not per school	0 / 6	0 / 6
	record_source	no route		not per school	0 / 22	0 / 22
	reference_change	no route		not per school	0 / 8	0 / 8
	reference_source	no route		not per school	0 / 10	0 / 10
Checklists	requirement_alternative	25,652	63	via requirement_item > requirement_group > checklist	1 / 4	0 / 4	3 of 4 columns carry a value item_id 25,652 of 25,652 name 25,652 of 25,652 position 25,652 of 25,652 target_learning_unit_id 0 of 25,652
	requirement_alternative_version	no route		not per school	1 / 6	0 / 6
Checklists	requirement_group	140,752	135	via checklist	2 / 6	1 / 6	4 of 6 columns carry a value attachment_rule 0 of 140,752 checklist_id 140,752 of 140,752 group_category 12,091 of 140,752 group_heading 140,458 of 140,752 group_id 140,752 of 140,752 required_choice_count 0 of 140,752
	requirement_group_version	no route		not per school	2 / 9	1 / 9
Checklists	requirement_item	825,903	135	via requirement_group > checklist	3 / 13	2 / 13	9 of 13 columns carry a value credit_unit 0 of 825,903 credits_max 0 of 825,903 credits_min 0 of 825,903 credits_published 435,713 of 825,903 description 0 of 825,903 group_id 825,903 of 825,903 item_code 749,707 of 825,903 item_id 825,903 of 825,903 item_title 817,311 of 825,903 link_method 392,871 of 825,903 published 825,903 of 825,903 source_url 825,903 of 825,903 target_learning_unit_id 392,871 of 825,903
	requirement_item_version	no route		not per school	3 / 16	2 / 16
	schema_info	no route		not per school	0 / 3	0 / 3
	transfer_framework	no route		not per school	0 / 18	0 / 18
	transfer_framework_version	no route		not per school	0 / 18	0 / 18

Read from CourseShelf publish 59 · CTDL: columns bound or coded in model_binding · CEDS: columns with a sourced element · Fields: rows carrying a value, per column