uniform_resource_participant (table) Content

uniform_resource_participant (table) Schema


DCLP1-003-014	DCLP1	[['CLC', '2018-01-03', '2018-05-03']]	M	White	70	30.51922315	7.4	T1D	Treatment	UVA001
DCLP1-003-015	DCLP1	[['CLC', '2018-01-19', '2018-05-23']]	M		47	34.02756404	9.8	T1D	Treatment	UVA001
DCLP1-003-016	DCLP1	[['SAP', '2018-01-25', '2018-05-10']]	M	White	46	27.92484504	7.9	T1D	Control	UVA001
DCLP1-003-017	DCLP1	[['CLC', '2018-02-20', '2018-06-19']]	M		26	25.24421414	10.1	T1D	Treatment	UVA001
DCLP1-003-019	DCLP1	[['SAP', '2018-02-24', '2018-06-11']]	M	Black	29	21.64129082	6.7	T1D	Control	UVA001
DCLP1-004-001	DCLP1	[['CLC', '2017-11-03', '2018-02-22']]	F	White	43	24.62862813	8.4	T1D	Treatment	UVA001
DCLP1-004-002	DCLP1	[['SAP', '2017-11-02', '2018-02-12']]	F	White	44	25.17121446	6.5	T1D	Control	UVA001
DCLP1-004-003	DCLP1	[['SAP', '2017-11-06', '2018-02-14']]	M	White	29	24.02444882	6.5	T1D	Control	UVA001
DCLP1-004-004	DCLP1	[['SAP', '2017-11-13', '2018-02-22']]	F	White	46	22.35102593	6.5	T1D	Control	UVA001
DCLP1-004-005	DCLP1	[['CLC', '2017-11-15', '2018-02-22']]	F	White	41	30.71579671	6.4	T1D	Treatment	UVA001
DCLP1-004-006	DCLP1	[['CLC', '2017-11-20', '2018-03-05']]	F	Other	39	21.62390131	6.4	T1D	Treatment	UVA001
DCLP1-004-007	DCLP1	[['CLC', '2017-12-15', '2018-05-02']]	F	White	46	26.07211634	7.2	T1D	Treatment	UVA001
DCLP1-004-008	DCLP1	[['SAP', '2017-12-14', '2018-04-12']]	M	White	27	25.28470616	7.8	T1D	Control	UVA001
DCLP1-004-009	DCLP1	[['CLC', '2017-11-30', '2018-03-16']]	M	White	42	25.94232234	6.9	T1D	Treatment	UVA001
DCLP1-004-010	DCLP1	[['SAP', '2017-12-03', '2018-03-22']]	M	White	29	31.49288889	7.2	T1D	Control	UVA001
DCLP1-004-011	DCLP1	[['SAP', '2017-12-20', '2018-04-23']]	F	White	21	23.91883029	7.7	T1D	Control	UVA001
DCLP1-004-012	DCLP1	[['SAP', '2018-01-02', '2018-05-21']]	M	White	28	31.63732217	9.3	T1D	Control	UVA001
DCLP1-004-013	DCLP1	[['CLC', '2017-12-21', '2018-03-28']]	F	White	56	22.96414742	6.7	T1D	Treatment	UVA001
DCLP1-004-014	DCLP1	[['CLC', '2017-12-25', '2018-04-17']]	F	White	25	37.12877426	8.4	T1D	Treatment	UVA001
DCLP1-004-015	DCLP1	[['CLC', '2018-01-11', '2018-05-11']]	F	White	24	35.54148826	7.9	T1D	Treatment	UVA001
DCLP1-004-016	DCLP1	[['SAP', '2018-02-01', '2018-05-22']]	F	White	53	21.77826553	6.5	T1D	Control	UVA001
DCLP1-004-017	DCLP1	[['SAP', '2018-02-21', '2018-07-02']]	F	White	28	26.99059835	8.6	T1D	Control	UVA001
DCLP1-004-018	DCLP1	[['CLC', '2018-02-22', '2018-06-27']]	F	Asian	26	22.12325991	8.3	T1D	Treatment	UVA001
DCLP1-005-001	DCLP1	[['SAP', '2017-11-03', '2018-02-21']]	F	White	41	25.59652387	7.7	T1D	Control	UVA001
DCLP1-005-002	DCLP1	[['SAP', '2017-11-21', '2018-03-20']]	M	White	40	22.20682704	6.4	T1D	Control	UVA001
DCLP1-005-003	DCLP1	[['CLC', '2017-11-08', '2018-02-21']]	M	Black	31	24.48616668	7.2	T1D	Treatment	UVA001
DCLP1-005-004	DCLP1	[['SAP', '2017-11-24', '2018-03-23']]	F	Asian	32	24.43960681	7.8	T1D	Control	UVA001
DCLP1-005-005	DCLP1	[['SAP', '2017-12-02', '2018-03-30']]	M	White	38	26.29684164	7.2	T1D	Control	UVA001
DCLP1-005-006	DCLP1	[['SAP', '2017-12-14', '2018-05-11']]	M	White	42	24.24976371	7	T1D	Control	UVA001
DCLP1-005-007	DCLP1	[['CLC', '2017-12-04', '2018-03-29']]	F	White	31	22.49906649	6.6	T1D	Treatment	UVA001
DCLP1-005-008	DCLP1	[['CLC', '2017-12-03', '2018-03-30']]	F	White	35	28.80107717	8	T1D	Treatment	UVA001
DCLP1-005-009	DCLP1	[['CLC', '2017-12-05', '2018-03-23']]	M	White	27	24.39932954	8.6	T1D	Treatment	UVA001
DCLP1-005-010	DCLP1	[['SAP', '2017-12-18', '2018-04-03']]	M	White	36	27.29100833	8.6	T1D	Control	UVA001
DCLP1-005-011	DCLP1	[['CLC', '2017-12-24', '2018-04-09']]	M	White	51	29.11235389	8.2	T1D	Treatment	UVA001
DCLP1-005-012	DCLP1	[['CLC', '2017-12-25', '2018-05-09']]	M	White	62	29.88723834	7.6	T1D	Treatment	UVA001
DCLP1-005-013	DCLP1	[['SAP', '2018-02-06', '2018-06-08']]	F	White	41	21.05570092	9.5	T1D	Control	UVA001
DCLP1-005-014	DCLP1	[['SAP', '2018-01-23', '2018-05-11']]	F	White	31	19.75860353	9.2	T1D	Control	UVA001
DCLP1-005-015	DCLP1	[['SAP', '2018-02-22', '2018-06-22']]	M	White	25	26.72455151	7	T1D	Control	UVA001
DCLP1-005-016	DCLP1	[['CLC', '2018-02-08', '2018-05-25']]	F	White	58	38.45617031	7.6	T1D	Treatment	UVA001
DCLP1-005-017	DCLP1	[['CLC', '2018-02-28', '2018-06-27']]	M	White	26	27.92553192	8.3	T1D	Treatment	UVA001
DCLP1-005-018	DCLP1	[['CLC', '2018-02-14', '2018-05-31']]	F	White	27	54.33283519	7.4	T1D	Treatment	UVA001
DCLP1-006-001	DCLP1	[['CLC', '2017-11-07', '2018-02-16']]	M	White	17	28.982007	7.6	T1D	Treatment	UVA001
DCLP1-006-002	DCLP1	[['SAP', '2017-11-15', '2018-02-22']]	M	White	17	21.11311984	8.1	T1D	Control	UVA001
DCLP1-006-003	DCLP1	[['SAP', '2017-12-07', '2018-04-12']]	M	Other	31	39.54438227	8.2	T1D	Control	UVA001
DCLP1-006-004	DCLP1	[['SAP', '2017-11-24', '2018-03-15']]	F	White	37	23.8482149	6.9	T1D	Control	UVA001
DCLP1-006-005	DCLP1	[['CLC', '2017-11-23', '2018-03-08']]	M	White	16	19.85408058	6.9	T1D	Treatment	UVA001
DCLP1-006-006	DCLP1	[['CLC', '2017-12-07', '2018-02-28']]	M	White	22	23.63844946	6.8	T1D	Treatment	UVA001
DCLP1-006-008	DCLP1	[['CLC', '2017-12-22', '2018-04-20']]	M	White	31	23.03691766	7.6	T1D	Treatment	UVA001
DCLP1-006-009	DCLP1	[['CLC', '2017-12-28', '2018-05-09']]	F	Other	22	20.19866289	7.5	T1D	Treatment	UVA001
DCLP1-006-010	DCLP1	[['SAP', '2018-02-01', '2018-06-01']]	F	White	17	25.08788625	7.5	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'.