这是一个详细的财政部和社会资本合作项目信息数据库，共包含有9,947个项目信息，每个信息记录中有区域标识符，项目唯一标识符，城市代码，城市名称，区号，地区名称，省代码，省名称，项目简介，项目名称，所属行业，项目种类，行业代码，投资总额，预览级别，项目编号，项目状态，分数，发布时间，代理单位，创建单位，发起单位，负责部门，项目介绍，联系人，电话，手机，合作时间，运作方式，回报机制，开始时间和采购方式。除此之外，该数据库中还包含有10,655个项目详情，196,481个项目准备阶段详情和40,528个项目分数。项目详情中有公司代码，贡献，缴费率，资本和公司名称；项目准备阶段详情有年份，项目编号，比率，a预算，b预算和c预算以及项目得数中指标名称，项目编号，评分标准，得分结果和权重。
该财政部和社会资本合作项目信息数据库共有5个表。
This is a database of cooperation projects infomation by ministry of finance & social capital with 9,947 project records. Each record is comprised of project rid, project uid, city code, city name, dist code, province code, province name, project description, project name, industry, project type, industry code, total investment, project no, project status, score, publish time, agency, creation unit, sponsoring unit, responsible department, project introduction, contact person, telephone, cell phone, cooperation time, mode of operation, reward mechanism, startting time and purchasing method.
In addition to this table project, there are 3 important tables mostly related with these projects, they are project detail having 10,655 records with company code, project id, contribution, contribution rate, capital and company name in each; project predetail having 196,481 records with year, project id, ratio, a budget, b budget & c budget in each and project score having 40,528 records with indicator name, project id, score result, score standard and weight in each.
The whole cooperation projects infomation by ministry of finance & social capital data set has 5 tables.
| Name | n3_lyz_cpppc_org |
|---|---|
| Data | 87.12M (+ 0B) |
| Tables | 5 (+ 0) |
| Columns | 61 (+ 0) |
| Table Rows | 267,558 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| project | 9,947 | project_rid |
100%
|
| project_uid |
100%
|
||
| city_code |
97.87%
|
||
| city_name |
97.87%
|
||
| dist_code |
76.49%
|
||
| dist_name |
76.49%
|
||
| province_code |
100%
|
||
| province_name |
100%
|
||
| xiangmu_jianjie |
100%
|
||
| project_name |
99.99%
|
||
| suoshu_hangye |
100%
|
||
| xiangmu_zhonglei |
100%
|
||
| industry_code |
100%
|
||
| touzi_zonge |
100%
|
||
| preview_levels |
0%
|
||
| project_no |
100%
|
||
| project_status |
100%
|
||
| project_type |
100%
|
||
| score |
100%
|
||
| publish_time |
100%
|
||
| daili_danwei |
100%
|
||
| chuangjian_danwei |
100%
|
||
| faqi_danwei |
100%
|
||
| fuze_bumen |
31.58%
|
||
| xiangmu_jieshao |
99.94%
|
||
| contactor |
100%
|
||
| tel |
100%
|
||
| mobile |
100%
|
||
| hezuo_shijian |
100%
|
||
| yunzuo_fangshi |
99.99%
|
||
| huibao_jizhi |
99.99%
|
||
| start_time |
100%
|
||
| caigou_fangshi |
100%
|
||
| project_b | 9,947 | project_rid |
100%
|
| project_detail | 10,655 | company_code |
100%
|
| project_id |
100%
|
||
| contribution |
100%
|
||
| contribution_rate |
99.99%
|
||
| capital |
99.52%
|
||
| company_name |
100%
|
||
| project_predetail | 196,481 | year |
100%
|
| project_id |
100%
|
||
| ratio |
100%
|
||
| a_budget |
100%
|
||
| b_budget |
100%
|
||
| c_budget |
100%
|
||
| project_score | 40,528 | indicator_name |
100%
|
| project_id |
100%
|
||
| score_result |
99.65%
|
||
| score_standard |
98.57%
|
||
| weight |
99.96%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
