`github.participation`

pass

Get the weekly commit count

Requires owner and repo. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

owner, repo captured 2026-08-31 07:32:28Zmedian 46505 ms

Verdict: TRUE

All variants returned rows on ≥2 trials, 0 errors.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	42286 ms	44056 ms	45826 ms	[1, 1]
realistic	2	44568 ms	46505 ms	48442 ms	[1, 1]
edge	2	38668 ms	38708 ms	38748 ms	[1, 1]

Latency per trial

minimalmedian 44056ms

scale: 0–45826 ms

realisticmedian 46505ms

scale: 0–48442 ms

edgemedian 38708ms

scale: 0–38748 ms

Probe variants — every command + output

minimal2 trials

min 42286ms · median 44056ms · max 45826ms · rows 1,1

smallest valid query

Command

SELECT * FROM github.participation WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 1

Trials + output

trial 1·45826ms·rows 1isError=false

First row (click to expand JSON)

{
  "all": "[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,522,637,459,338,301,345,166,266,226,170,224,198,213,523,262,342,315,501,314,270,310,208,85,338,230,120,151,101,107,97,61,102,75]",
  "owner": "[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]",
  "repo": "opencode"
}

columns (3)

allownerrepo

trial 2·42286ms·rows 1isError=false

First row (click to expand JSON)

{
  "all": "[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,522,637,459,338,301,345,166,266,226,170,224,198,213,523,262,342,315,501,314,270,310,208,85,338,230,120,151,101,107,97,61,102,75]",
  "owner": "[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]",
  "repo": "opencode"
}

columns (3)

allownerrepo

realistic2 trials

min 44568ms · median 46505ms · max 48442ms · rows 1,1

typical user query

Command

SELECT * FROM github.participation WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 25

Trials + output

trial 1·48442ms·rows 1isError=false

First row (click to expand JSON)

{
  "all": "[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,522,637,459,338,301,345,166,266,226,170,224,198,213,523,262,342,315,501,314,270,310,208,85,338,230,120,151,101,107,97,61,102,75]",
  "owner": "[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]",
  "repo": "opencode"
}

columns (3)

allownerrepo

trial 2·44568ms·rows 1isError=false

First row (click to expand JSON)

{
  "all": "[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,522,637,459,338,301,345,166,266,226,170,224,198,213,523,262,342,315,501,314,270,310,208,85,338,230,120,151,101,107,97,61,102,75]",
  "owner": "[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]",
  "repo": "opencode"
}

columns (3)

allownerrepo

edge2 trials

min 38668ms · median 38708ms · max 38748ms · rows 1,1

edge: larger limit

Command

SELECT * FROM github.participation WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 200

Trials + output

trial 1·38748ms·rows 1isError=false

First row (click to expand JSON)

{
  "all": "[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,522,637,459,338,301,345,166,266,226,170,224,198,213,523,262,342,315,501,314,270,310,208,85,338,230,120,151,101,107,97,61,102,75]",
  "owner": "[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]",
  "repo": "opencode"
}

columns (3)

allownerrepo

trial 2·38668ms·rows 1isError=false

First row (click to expand JSON)

{
  "all": "[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,522,637,459,338,301,345,166,266,226,170,224,198,213,523,262,342,315,501,314,270,310,208,85,338,230,120,151,101,107,97,61,102,75]",
  "owner": "[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]",
  "repo": "opencode"
}

columns (3)

allownerrepo

All returned rowsacross all non-errored trials · filterable · paginated

6 rows stored · 6 returned · page 1/1


1	0	[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,52…	[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,…	opencode
2	1	[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,52…	[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,…	opencode
1	2	[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,52…	[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,…	opencode
2	3	[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,52…	[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,…	opencode
1	4	[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,52…	[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,…	opencode
2	5	[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613,467,320,375,336,52…	[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,…	opencode

Column profile

3 columns actually returned by coral. Catalog claims "2 required filter(s)": "owner, repo". Click a column to drill in.

#	Column	Inferred type	Non-null	Sample value(s)
1	all	string	6	`"[124,123,142,112,122,132,131,130,256,286,183,292,242,262,613"`
2	owner	string	6	`"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0"`
3	repo	string	6	`"opencode"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	45826ms	1	ok	all, owner, repo
minimal	t2	42286ms	1	ok	all, owner, repo
realistic	t1	48442ms	1	ok	all, owner, repo
realistic	t2	44568ms	1	ok	all, owner, repo
edge	t1	38748ms	1	ok	all, owner, repo
edge	t2	38668ms	1	ok	all, owner, repo

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires owner and repo. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

Columns coral returned (3)

allownerrepo

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T07:32:28Z

JSON record: reports/github/tables/participation.json

first_run_at: 2026-08-31T07:32:28Z

last_retried_at: 2026-08-31T07:32:28Z

retry_count: 0

View version history →