uniform_resource_participant (table) Content

uniform_resource_participant (table) Schema


DCLP1-001-001	DCLP1	[['CLC', '2017-11-02', '2018-02-23']]	M	White	41	28.4730594	5.7	T1D	Treatment	UVA001
DCLP1-001-002	DCLP1	[['SAP', '2017-11-04', '2018-02-21']]	M	White	20	26.50647188	7.1	T1D	Control	UVA001
DCLP1-001-003	DCLP1	[['SAP', '2017-11-17', '2018-03-16']]	F	White	48	41.19544958	6.4	T1D	Control	UVA001
DCLP1-001-004	DCLP1	[['CLC', '2017-11-17', '2018-03-16']]	F	White	55	33.64295049	6.9	T1D	Treatment	UVA001
DCLP1-001-005	DCLP1	[['CLC', '2017-11-27', '2018-03-06']]	M	White	27	24.77771852	7.9	T1D	Treatment	UVA001
DCLP1-001-006	DCLP1	[['SAP', '2017-12-13', '2018-04-12']]	F	White	42	30.57667754	7.4	T1D	Control	UVA001
DCLP1-001-007	DCLP1	[['SAP', '2017-11-28', '2018-03-14']]	F	White	30	22.91914575	6	T1D	Control	UVA001
DCLP1-001-008	DCLP1	[['CLC', '2017-11-29', '2018-03-12']]	F	Asian	18	26.83099724	8.8	T1D	Treatment	UVA001
DCLP1-001-009	DCLP1	[['CLC', '2018-01-11', '2018-05-17']]	F	White	68	35.87824544	7.3	T1D	Treatment	UVA001
DCLP1-001-011	DCLP1	[['SAP', '2018-01-13', '2018-01-27']]	M	White	17	21.21784223	8.7	T1D	Control	UVA001
DCLP1-001-012	DCLP1	[['CLC', '2018-01-16', '2018-05-03']]	M	White	19	22.79556581	8.7	T1D	Treatment	UVA001
DCLP1-001-013	DCLP1	[['CLC', '2018-01-18', '2018-05-11']]	F	White	17	31.23140988	7.4	T1D	Treatment	UVA001
DCLP1-001-014	DCLP1	[['SAP', '2018-01-24', '2018-04-28']]	F	White	47	28.98114344	7.5	T1D	Control	UVA001
DCLP1-001-015	DCLP1	[['CLC', '2018-02-09', '2018-06-13']]	F	White	24	26.97697083	8.6	T1D	Treatment	UVA001
DCLP1-001-016	DCLP1	[['CLC', '2018-02-09', '2018-06-04']]	F	White	21	21.9708625	7.8	T1D	Treatment	UVA001
DCLP1-001-017	DCLP1	[['SAP', '2018-02-09', '2018-06-01']]	M	White	37	30.06385557	7.7	T1D	Control	UVA001
DCLP1-001-018	DCLP1	[['SAP', '2018-01-25', '2018-05-11']]	F	White	20	29.48972782	8.4	T1D	Control	UVA001
DCLP1-001-019	DCLP1	[['SAP', '2018-02-02', '2018-05-11']]	F	Other	14	24.21875	7.7	T1D	Control	UVA001
DCLP1-001-020	DCLP1	[['CLC', '2018-02-01', '2018-05-25']]	M	Asian	14	17.2879069	9.3	T1D	Treatment	UVA001
DCLP1-002-001	DCLP1	[['SAP', '2017-11-14', '2018-03-02']]	F	White	27	23.06852168	6.7	T1D	Control	UVA001
DCLP1-002-002	DCLP1	[['SAP', '2017-11-14', '2018-02-27']]	M	White	25	24.28345564	6.6	T1D	Control	UVA001
DCLP1-002-003	DCLP1	[['CLC', '2017-11-19', '2018-03-02']]	F	White	27	27.0443552	7	T1D	Treatment	UVA001
DCLP1-002-004	DCLP1	[['CLC', '2017-11-20', '2018-03-02']]	F	White	16	26.92256151	6.1	T1D	Treatment	UVA001
DCLP1-002-005	DCLP1	[['CLC', '2017-11-22', '2018-03-12']]	M	White	48	28.83105905	6.5	T1D	Treatment	UVA001
DCLP1-002-006	DCLP1	[['CLC', '2017-12-14', '2018-05-14']]	F	White	22	30.08979592	8.1	T1D	Treatment	UVA001
DCLP1-002-007	DCLP1	[['SAP', '2017-12-04', '2018-03-19']]	F	White	17	20.76256758	8.4	T1D	Control	UVA001
DCLP1-002-008	DCLP1	[['SAP', '2018-01-16', '2018-05-08']]	M	White	28	28.69212118	7.9	T1D	Control	UVA001
DCLP1-002-009	DCLP1	[['SAP', '2018-01-03', '2018-05-31']]	F	White	18	25.78973814	8.4	T1D	Control	UVA001
DCLP1-002-010	DCLP1	[['SAP', '2017-12-23', '2018-04-06']]	M	White	25	30.10529093	7.3	T1D	Control	UVA001
DCLP1-002-011	DCLP1	[['CLC', '2017-12-27', '2018-04-12']]	M		20	34.15208488	7.3	T1D	Treatment	UVA001
DCLP1-002-012	DCLP1	[['SAP', '2018-01-10', '2018-05-01']]	M	White	21	26.32532303	7.6	T1D	Control	UVA001
DCLP1-002-013	DCLP1	[['SAP', '2018-02-05', '2018-06-11']]	F	White	15	24.2056933	7.5	T1D	Control	UVA001
DCLP1-002-014	DCLP1	[['SAP', '2018-02-09', '2018-06-14']]	F	Asian	15	24.94031221	8.5	T1D	Control	UVA001
DCLP1-002-015	DCLP1	[['CLC', '2018-02-01', '2018-05-16']]	F	White	37	28.14074258	8.3	T1D	Treatment	UVA001
DCLP1-002-016	DCLP1	[['CLC', '2018-02-14', '2018-06-06']]	F	White	15	31.04741518	8.4	T1D	Treatment	UVA001
DCLP1-002-017	DCLP1	[['CLC', '2018-03-20', '2018-07-19']]	M	White	17	18.09869653	8.4	T1D	Treatment	UVA001
DCLP1-002-018	DCLP1	[['CLC', '2018-03-20', '2018-07-20']]	F	White	16	31.62693747	9.4	T1D	Treatment	UVA001
DCLP1-003-001	DCLP1	[['CLC', '2017-11-14', '2018-03-19']]	M	White	62	24.96345137	6	T1D	Treatment	UVA001
DCLP1-003-002	DCLP1	[['SAP', '2017-11-17', '2018-03-16']]	M	White	72	23.50201924	7.4	T1D	Control	UVA001
DCLP1-003-003	DCLP1	[['CLC', '2017-11-03', '2018-02-16']]	F	White	43	17.87654372	6.9	T1D	Treatment	UVA001
DCLP1-003-004	DCLP1	[['SAP', '2017-11-06', '2018-02-20']]	M	White	16	21.91358025	8.5	T1D	Control	UVA001
DCLP1-003-005	DCLP1	[['SAP', '2017-11-13', '2018-03-01']]	M	White	51	31.67275384	6.1	T1D	Control	UVA001
DCLP1-003-006	DCLP1	[['CLC', '2017-11-15', '2018-03-01']]	M	White	36	26.53610695	5.8	T1D	Treatment	UVA001
DCLP1-003-007	DCLP1	[['SAP', '2017-11-17', '2018-03-01']]	F	White	31	28.4765625	7.1	T1D	Control	UVA001
DCLP1-003-008	DCLP1	[['SAP', '2017-12-04', '2018-04-10']]	M	White	75	31.4850296	7.7	T1D	Control	UVA001
DCLP1-003-009	DCLP1	[['CLC', '2017-11-21', '2018-03-08']]	M	White	31	26.31293403	7.1	T1D	Treatment	UVA001
DCLP1-003-010	DCLP1	[['CLC', '2017-12-07', '2018-03-30']]	F	White	56	29.54755309	6.6	T1D	Treatment	UVA001
DCLP1-003-011	DCLP1	[['CLC', '2017-11-23', '2018-03-08']]	F	White	67	25.76571346	6.1	T1D	Treatment	UVA001
DCLP1-003-012	DCLP1	[['SAP', '2017-12-02', '2018-03-16']]	M	White	38	30.04081633	8.3	T1D	Control	UVA001
DCLP1-003-013	DCLP1	[['SAP', '2017-12-22', '2018-04-24']]	M	White	69	25.21768984	6.9	T1D	Control	UVA001

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/uniform_resource_participant.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'.