participant_dashboard_cached (table) Content

participant_dashboard_cached (table) Schema


DCLP1	DCLP1-001-001	M	41	Treatment	5.7	DEXCOM G4 or G5	cgm_tracing.csv	88.7	1.06	8.92	1.15	0.17	9.98	1.32	116.0	28.65	12.12	99	2017-11-02	2018-02-23	86.84
DCLP1	DCLP1-001-002	M	20	Control	7.1	DEXCOM G6	cgm_tracing.csv	58.42	9.54	27.08	3.81	1.14	36.62	4.96	121.0	39.39	49.5	62	2017-11-04	2018-02-21	56.36
DCLP1	DCLP1-001-003	F	48	Control	6.4	DEXCOM G6	cgm_tracing.csv	63.72	7.84	26.61	1.45	0.39	34.45	1.84	121.0	34.64	38.47	93	2017-11-17	2018-03-16	77.5
DCLP1	DCLP1-001-004	F	55	Treatment	6.9	DEXCOM G4 or G5	cgm_tracing.csv	71.14	5.39	20.4	1.89	1.19	25.78	3.07	119.0	34.89	33.03	93	2017-11-17	2018-03-16	77.5
DCLP1	DCLP1-001-005	M	27	Treatment	7.9	DEXCOM G4 or G5	cgm_tracing.csv	50.86	17.4	26.94	3.36	1.45	44.34	4.8	123.0	42.07	61.79	71	2017-11-27	2018-03-06	71.0
DCLP1	DCLP1-001-006	F	42	Control	7.4	DEXCOM G6	cgm_tracing.csv	51.56	12.58	35.31	0.46	0.1	47.89	0.55	124.0	32.13	49.75	93	2017-12-13	2018-04-12	76.86
DCLP1	DCLP1-001-007	F	30	Control	6	DEXCOM G6	cgm_tracing.csv	63.58	6.96	26.91	1.95	0.6	33.87	2.54	120.0	34.75	39.13	92	2017-11-28	2018-03-14	85.98
DCLP1	DCLP1-001-008	F	18	Treatment	8.8	DEXCOM G4 or G5	cgm_tracing.csv	57.17	12.26	29.53	0.86	0.17	41.79	1.03	123.0	34.37	45.82	90	2017-11-29	2018-03-12	86.54
DCLP1	DCLP1-001-009	F	68	Treatment	7.3	DEXCOM G4 or G5	cgm_tracing.csv	68.09	8.19	22.07	1.25	0.39	30.26	1.64	120.0	37.34	34.94	96	2018-01-11	2018-05-17	75.59
DCLP1	DCLP1-001-011	M	17	Control	8.7	DEXCOM G6	cgm_tracing.csv	64.93	10.08	20.42	3.02	1.55	30.5	4.57	120.0	43.18	44.35	15	2018-01-13	2018-01-27	100.0
DCLP1	DCLP1-001-012	M	19	Treatment	8.7	DEXCOM G4 or G5	cgm_tracing.csv	49.3	20.97	28.11	1.1	0.51	49.08	1.62	125.0	40.29	60.22	88	2018-01-16	2018-05-03	81.48
DCLP1	DCLP1-001-013	F	17	Treatment	7.4	DEXCOM G4 or G5	cgm_tracing.csv	55.82	13.41	30.11	0.5	0.16	43.52	0.66	123.0	35.31	47.22	98	2018-01-18	2018-05-11	85.96
DCLP1	DCLP1-001-014	F	47	Control	7.5	DEXCOM G6	cgm_tracing.csv	54.59	16.76	27.8	0.76	0.08	44.56	0.85	124.0	37.76	51.14	63	2018-01-24	2018-04-28	66.32
DCLP1	DCLP1-001-015	F	24	Treatment	8.6	DEXCOM G4 or G5	cgm_tracing.csv	42.52	30.58	26.36	0.47	0.06	56.94	0.53	128.0	40.24	71.34	94	2018-02-09	2018-06-13	75.2
DCLP1	DCLP1-001-016	F	21	Treatment	7.8	DEXCOM G4 or G5	cgm_tracing.csv	63.13	13.17	21.49	1.62	0.6	34.66	2.22	121.0	41.41	43.94	85	2018-02-09	2018-06-04	73.28
DCLP1	DCLP1-001-017	M	37	Control	7.7	DEXCOM G6	cgm_tracing.csv	48.23	16.91	32.78	1.7	0.37	49.7	2.07	124.0	36.16	58.47	67	2018-02-09	2018-06-01	59.29
DCLP1	DCLP1-001-018	F	20	Control	8.4	DEXCOM G6	cgm_tracing.csv	49.21	16.85	28.99	2.8	2.16	45.84	4.95	123.0	42.36	63.33	91	2018-01-25	2018-05-11	85.05
DCLP1	DCLP1-001-019	F	14	Control	7.7	DEXCOM G6	cgm_tracing.csv	44.2	23.43	30.84	1.28	0.25	54.27	1.53	126.0	40.11	65.97	85	2018-02-02	2018-05-11	85.86
DCLP1	DCLP1-001-020	M	14	Treatment	9.3	DEXCOM G4 or G5	cgm_tracing.csv	41.68	27.62	29.78	0.72	0.19	57.41	0.92	127.0	36.93	70.34	96	2018-02-01	2018-05-25	84.21
DCLP1	DCLP1-002-001	F	27	Control	6.7	DEXCOM G6	cgm_tracing.csv	63.42	7.73	27.07	1.63	0.15	34.8	1.79	121.0	35.03	38.41	86	2017-11-14	2018-03-02	78.9
DCLP1	DCLP1-002-002	M	25	Control	6.6	DEXCOM G6	cgm_tracing.csv	82.15	2.05	13.92	1.56	0.32	15.97	1.88	117.0	31.93	19.11	91	2017-11-14	2018-02-27	85.85
DCLP1	DCLP1-002-003	F	27	Treatment	7	DEXCOM G4 or G5	cgm_tracing.csv	60.65	10.33	22.22	4.2	2.6	32.55	6.8	120.0	43.69	52.18	88	2017-11-19	2018-03-02	84.62
DCLP1	DCLP1-002-004	F	16	Treatment	6.1	DEXCOM G4 or G5	cgm_tracing.csv	74.92	3.15	21.09	0.76	0.08	24.24	0.84	119.0	30.93	23.99	89	2017-11-20	2018-03-02	86.41
DCLP1	DCLP1-002-005	M	48	Treatment	6.5	DEXCOM G4 or G5	cgm_tracing.csv	69.91	4.62	22.84	1.79	0.84	27.46	2.63	120.0	33.44	32.49	59	2017-11-22	2018-03-12	53.15
DCLP1	DCLP1-002-006	F	22	Treatment	8.1	DEXCOM G4 or G5	cgm_tracing.csv	55.69	14.24	28.4	1.06	0.62	42.64	1.67	123.0	36.51	49.89	95	2017-12-14	2018-05-14	62.5
DCLP1	DCLP1-002-007	F	17	Control	8.4	DEXCOM G6	cgm_tracing.csv	41.38	21.4	36.47	0.53	0.22	57.87	0.75	126.0	33.6	65.35	87	2017-12-04	2018-03-19	82.08
DCLP1	DCLP1-002-008	M	28	Control	7.9	DEXCOM G6	cgm_tracing.csv	61.46	10.48	24.72	2.47	0.87	35.2	3.33	121.0	39.2	45.07	92	2018-01-16	2018-05-08	81.42
DCLP1	DCLP1-002-009	F	18	Control	8.4	DEXCOM G6	cgm_tracing.csv	38.06	31.62	25.82	3.23	1.27	57.44	4.5	127.0	44.3	82.81	96	2018-01-03	2018-05-31	64.43
DCLP1	DCLP1-002-010	M	25	Control	7.3	DEXCOM G6	cgm_tracing.csv	59.84	7.81	28.39	2.86	1.1	36.2	3.96	121.0	37.38	45.38	87	2017-12-23	2018-04-06	82.86
DCLP1	DCLP1-002-011	M	20	Treatment	7.3	DEXCOM G4 or G5	cgm_tracing.csv	62.46	9.19	24.78	2.86	0.72	33.97	3.57	121.0	38.05	43.53	90	2017-12-27	2018-04-12	84.11
DCLP1	DCLP1-002-012	M	21	Control	7.6	DEXCOM G6	cgm_tracing.csv	49.76	22.67	21.12	4.75	1.7	43.79	6.45	124.0	49.98	69.67	54	2018-01-10	2018-05-01	48.21
DCLP1	DCLP1-002-013	F	15	Control	7.5	DEXCOM G6	cgm_tracing.csv	60.47	8.76	24.02	4.3	2.45	32.79	6.74	120.0	41.48	50.89	95	2018-02-05	2018-06-11	74.8
DCLP1	DCLP1-002-014	F	15	Control	8.5	DEXCOM G6	cgm_tracing.csv	54.09	13.72	28.74	2.59	0.86	42.46	3.45	122.0	40.09	53.73	103	2018-02-09	2018-06-14	81.75
DCLP1	DCLP1-002-015	F	37	Treatment	8.3	DEXCOM G4 or G5	cgm_tracing.csv	57.47	14.08	24.79	2.37	1.29	38.87	3.66	122.0	42.67	51.92	86	2018-02-01	2018-05-16	81.9
DCLP1	DCLP1-002-016	F	15	Treatment	8.4	DEXCOM G4 or G5	cgm_tracing.csv	51.95	20.77	24.82	1.91	0.55	45.59	2.46	125.0	43.19	59.32	99	2018-02-14	2018-06-06	87.61
DCLP1	DCLP1-002-017	M	17	Treatment	8.4	DEXCOM G4 or G5	cgm_tracing.csv	63.04	13.08	20.09	2.68	1.11	33.17	3.79	121.0	45.23	46.76	92	2018-03-20	2018-07-19	75.41
DCLP1	DCLP1-002-018	F	16	Treatment	9.4	DEXCOM G4 or G5	cgm_tracing.csv	59.32	16.78	20.07	2.73	1.1	36.85	3.83	122.0	47.54	52.76	85	2018-03-20	2018-07-20	69.11
DCLP1	DCLP1-003-001	M	62	Treatment	6	DEXCOM G4 or G5	cgm_tracing.csv	90.18	0.43	5.61	3.16	0.61	6.05	3.78	114.0	29.14	14.62	96	2017-11-14	2018-03-19	76.19
DCLP1	DCLP1-003-002	M	72	Control	7.4	DEXCOM G6	cgm_tracing.csv	56.27	10.0	32.61	0.78	0.34	42.61	1.12	122.0	32.48	44.97	93	2017-11-17	2018-03-16	77.5
DCLP1	DCLP1-003-003	F	43	Treatment	6.9	DEXCOM G4 or G5	cgm_tracing.csv	76.66	4.07	18.25	1.01	0.01	22.32	1.02	118.0	33.62	23.57	93	2017-11-03	2018-02-16	87.74
DCLP1	DCLP1-003-004	M	16	Control	8.5	DEXCOM G6	cgm_tracing.csv	53.54	14.63	27.3	3.61	0.92	41.93	4.53	122.0	42.26	56.67	92	2017-11-06	2018-02-20	85.98
DCLP1	DCLP1-003-005	M	51	Control	6.1	DEXCOM G6	cgm_tracing.csv	77.79	1.97	13.4	5.24	1.61	15.36	6.85	116.0	36.25	31.27	93	2017-11-13	2018-03-01	85.32
DCLP1	DCLP1-003-006	M	36	Treatment	5.8	DEXCOM G4 or G5	cgm_tracing.csv	73.88	4.27	16.79	3.87	1.2	21.06	5.06	117.0	38.17	33.13	95	2017-11-15	2018-03-01	88.79
DCLP1	DCLP1-003-007	F	31	Control	7.1	DEXCOM G6	cgm_tracing.csv	59.73	4.29	35.94	0.04	0.0	40.24	0.04	123.0	22.55	35.71	90	2017-11-17	2018-03-01	85.71
DCLP1	DCLP1-003-008	M	75	Control	7.7	DEXCOM G6	cgm_tracing.csv	74.74	2.84	17.5	4.23	0.69	20.34	4.92	117.0	36.18	30.77	92	2017-12-04	2018-04-10	71.88
DCLP1	DCLP1-003-009	M	31	Treatment	7.1	DEXCOM G4 or G5	cgm_tracing.csv	69.43	6.01	22.83	1.52	0.2	28.85	1.72	120.0	34.11	32.13	93	2017-11-21	2018-03-08	86.11
DCLP1	DCLP1-003-010	F	56	Treatment	6.6	DEXCOM G4 or G5	cgm_tracing.csv	74.56	4.38	17.69	2.03	1.33	22.07	3.36	119.0	35.45	30.03	87	2017-12-07	2018-03-30	76.32
DCLP1	DCLP1-003-011	F	67	Treatment	6.1	DEXCOM G4 or G5	cgm_tracing.csv	72.58	4.68	19.62	2.4	0.72	24.3	3.12	119.0	35.82	31.1	94	2017-11-23	2018-03-08	88.68
DCLP1	DCLP1-003-012	M	38	Control	8.3	DEXCOM G6	cgm_tracing.csv	31.11	30.44	38.35	0.05	0.05	68.79	0.09	129.0	29.72	79.64	87	2017-12-02	2018-03-16	82.86
DCLP1	DCLP1-003-013	M	69	Control	6.9	DEXCOM G6	cgm_tracing.csv	68.68	5.24	23.72	1.97	0.39	28.96	2.36	120.0	33.7	33.27	85	2017-12-22	2018-04-24	68.55

Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

Error in query number 6:

Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:

            SELECT 'text' AS component,
                (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
                                                                                                                                                   ⬆️
                '(Page ' || $current_page || ' of ' || $total_pages || ') ' ||

Backtrace

sql parser error: Expected: END, found: ' ||
                ' at Line: 42, Column: 149

"console/content/table/participant_dashboard_cached.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.

You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.