names

29 rows where place_id = 774130

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4608456 2233751 2233751 defendant Blaunchard John   774130 774130 Blaunchard, John, of Bowedon 2
4710427 2268616 2268616 defendant Canon Thomas husbandman 774130 774130 Canon, Thomas, of Bowedon, husbandman 0
4712332 2269171 2269171 defendant Roworth Robert husbandman 774130 774130 Roworth, Robert, of Bowedon, husbandman 0
4747208 2279687 2279687 defendant Molt Thomas yeoman 774130 774130 Molt, Thomas, of Bowedon, yeoman 0
4747210 2279688 2279688 defendant Molt Thomas yeoman 774130 774130 Molt, Thomas, of Bowedon, yeoman 0
4776835 2288743 2288743 defendant Mold Robert husbandman 774130 774130 Mold, Robert, of Bowedon, husbandman 1
4780332 2289847 2289847 defendant Thurston Thomas dyer 774130 774130 Thurston, Thomas, of Bowedon, dyer 2
4824008 2303584 2303584 defendant Dekyn Richard husbandman 774130 774130 Dekyn, Richard, of Bowedon, husbandman 0
4857962 2313859 2313859 defendant Shapwyk John gent 774130 774130 Shapwyk, John, of Bowedon, gent 0
4868409 2317091 2317091 defendant Ingold John husbandman 774130 774130 Ingold, John, of Bowedon, husbandman 0
4868411 2317091 2317091 defendant Dekyn Thomas husbandman 774130 774130 Dekyn, Thomas, of Bowedon, husbandman 2
4882879 2321561 2321561 defendant Shapwyk John gent 774130 774130 Shapwyk, John, of Bowedon, gent 0
4888067 2323070 2323070 defendant Shapwyk John gent 774130 774130 Shapwyk, John, of Bowedon, gent 0
4905355 2328266 2328266 defendant de Hendford William esq 774130 774130 de Hendford, William, of Bowedon, esq 0
4905356 2328266 2328266 defendant Browne Nicholas forester 774130 774130 Browne, Nicholas, of Bowedon, forester 1
4940449 2339037 2339037 defendant Honford William esq 774130 774130 Honford, William, of Bowedon, esq 0
4950747 2342202 2342202 defendant Penels Joan   774130 774130 Penels, Joan, of Bowedon, widow of Penels, Thomas 0
4995395 2355464 2355464 defendant Shapwyke John gent 774130 774130 Shapwyke, John, of Bowedon, gent 0
5007685 2359144 2359144 defendant Kyrk Hugh yeoman 774130 774130 Kyrk, Hugh, of Bowedon, yeoman 5
5007686 2359144 2359144 defendant Ryssheham Christopher yeoman 774130 774130 Ryssheham, Christopher, of Bowedon, yeoman 6
5007687 2359144 2359144 defendant Goulden John yeoman 774130 774130 Goulden, John,of Bowedon, yeoman 7
5007689 2359144 2359144 defendant Barlowe Ralph yeoman 774130 774130 Barlowe, Ralph, of Bowedon, yeoman 9
5007690 2359144 2359144 defendant Shert Hugh yeoman 774130 774130 Shert, Hugh, of Bowedon, yeoman 10
5187217 2411989 2411989 defendant Raynold Thomas husbandman 774130 774130 Raynold, Thomas, of Bowedon, husbandman 1
5220586 2421715 2421715 defendant Billyngton John husbandman 774130 774130 Billyngton, John, of Bowedon, husbandman 2
5296506 2443968 2443968 defendant Aleyn William yeoman 774130 774130 Aleyn, William, of Bowedon, yeoman 2
5478655 2498644 2498644 defendant Alyn William yeoman 774130 774130 Alyn, William, of Bowedon, yeoman 4
5478662 2498645 2498645 defendant Alyn William yeoman 774130 774130 Alyn, William, of Bowedon, yeoman 4
5546805 2519070 2519070 defendant Taillour John yeoman 774130 774130 Taillour, John, of Bowedon, yeoman 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);