2020返程人员筛查分类统计表
发布时间：2020-06-03 09:05:40 影响了： 人
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 返城人员筛查分类统计表 |
|
| 说明：本表格为部分智能化的人员信息管理工具表格。其中，部分信息根据身份证号自动生成，包括性别、出生日期、年龄、籍贯均为根据身份证号自动提取信息与数据。已返乡天数、已经隔离天数的数据为自动生成，如果来自湖北，填入“是”时会自动显示黄色，如果隔离天数超过或等于14天，会显示绿色，当日体温超过或等于37.3，会自动显示红色提示。第一行的数据统计全部为自动生成，但是前提是要在“所属类型”所在列，通过下拉菜单输入不同类型。注：表格中带有函数公式的单元格，请勿填入数据。 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 今天是 |
2020/3/3 |
星期日 |
|
确诊病例 |
3 |
疑似病例 |
5 |
密切接触人员 |
8 |
待观察人员 |
6 |
其他 |
12 |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 序号 |
姓名 |
返城日期 |
已经返城天数 |
来源地区 |
是否来自湖北 |
当日体温记录 |
所属类型 |
身份证号 |
性别 |
出生日期 |
年龄 |
籍贯 |
详细家庭住址/返城后住址 |
联系电话 |
所属小区及社区 |
乘坐车辆/航班 |
行踪记录 |
是否隔离中 |
隔离起始日期 |
已经隔离天数 |
隔离场所 |
备注 |
|
| |
|
2020/1/28 |
35 天 |
|
是 |
37.50 |
疑似病例 |
|
|
|
|
|
|
|
|
|
|
|
2020/1/15 |
48 天 |
|
|
|
| |
|
2020/1/29 |
34 天 |
|
不是 |
36.50 |
密切接触人员 |
|
|
|
|
|
|
|
|
|
|
|
2020/1/29 |
34 天 |
|
|
|
| |
|
2020/1/30 |
33 天 |
|
不是 |
36.90 |
待观察人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
2020/1/31 |
32 天 |
|
是 |
37.30 |
密切接触人员 |
|
|
|
|
|
|
|
|
|
|
|
2020/2/1 |
31 天 |
|
|
|
| |
|
2020/2/1 |
31 天 |
|
|
|
密切接触人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
2020/2/2 |
30 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
2020/2/3 |
29 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
2020/2/4 |
28 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
2020/2/5 |
27 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
2020/1/29 |
34 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员11 |
2020/1/28 |
35 天 |
|
|
|
确诊病例 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员12 |
2020/1/29 |
34 天 |
|
|
|
确诊病例 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员13 |
2020/1/30 |
33 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员14 |
2020/1/31 |
32 天 |
|
|
|
密切接触人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员15 |
2020/2/1 |
31 天 |
|
|
|
密切接触人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员16 |
2020/2/2 |
30 天 |
|
|
|
疑似病例 |
|
|
|
|
|
|
|
|
|
|
|
2020/2/1 |
31 天 |
|
|
|
| |
人员17 |
2020/2/3 |
29 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员18 |
2020/2/4 |
28 天 |
|
|
|
疑似病例 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员19 |
2020/1/28 |
35 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员20 |
2020/1/29 |
34 天 |
|
|
|
待观察人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员21 |
2020/1/30 |
33 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员22 |
2020/1/31 |
32 天 |
|
|
|
确诊病例 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员23 |
2020/2/1 |
31 天 |
|
|
|
疑似病例 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员24 |
2020/2/2 |
30 天 |
|
|
|
疑似病例 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员25 |
2020/2/3 |
29 天 |
|
|
|
密切接触人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员26 |
2020/2/4 |
28 天 |
|
|
|
密切接触人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员27 |
2020/2/5 |
27 天 |
|
|
|
密切接触人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员28 |
2020/1/29 |
34 天 |
|
|
|
待观察人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员29 |
2020/1/28 |
35 天 |
|
|
|
待观察人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员30 |
2020/1/29 |
34 天 |
|
|
|
待观察人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员31 |
2020/1/30 |
33 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员32 |
2020/1/31 |
32 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员33 |
2020/1/28 |
35 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员34 |
2020/1/29 |
34 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员35 |
2020/1/30 |
33 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员36 |
2020/1/31 |
32 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员37 |
2020/2/1 |
31 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员38 |
2020/2/2 |
30 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员39 |
2020/2/3 |
29 天 |
|
|
|
待观察人员 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员40 |
2020/2/4 |
28 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员41 |
2020/2/5 |
27 天 |
|
|
|
其他 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员42 |
2020/1/29 |
34 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员43 |
2020/1/28 |
35 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员44 |
2020/1/29 |
34 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员45 |
2020/1/30 |
33 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员46 |
2020/1/31 |
32 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员47 |
2020/1/28 |
35 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员48 |
2020/1/29 |
34 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员49 |
2020/1/30 |
33 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员50 |
2020/1/31 |
32 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员51 |
2020/2/1 |
31 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员52 |
2020/2/2 |
30 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员53 |
2020/2/3 |
29 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员54 |
2020/2/4 |
28 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员55 |
2020/2/5 |
27 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员56 |
2020/1/29 |
34 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员57 |
2020/1/28 |
35 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员58 |
2020/1/29 |
34 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员59 |
2020/1/30 |
33 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员60 |
2020/1/31 |
32 天 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员61 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员62 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员63 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员64 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员65 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员66 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
人员67 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
