names

31 rows where place_id = 615007

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3706628 1928358 1928358 defendant Appulgarth John yeoman 615007 615007 Appulgarth, John, of Ratheby, yeoman 0
3706629 1928358 1928358 defendant Smyth Robert, senior yeoman 615007 615007 Smyth, Robert, senior, of Ratheby, yeoman 1
3706630 1928358 1928358 defendant Smyth Robert, junior yeoman 615007 615007 Smyth, Robert, junior, of Ratheby, yeoman 2
3706631 1928358 1928358 defendant Saunderson Richard yeoman 615007 615007 Saunderson, Richard, of Ratheby, yeoman 3
3738144 1938145 1938145 defendant Roke Alan yeoman 615007 615007 Roke, Alan, of Ratheby, yeoman 1
3738145 1938145 1938145 defendant Harstrung alias Harst Robert yeoman 615007 615007 Harstrung alias Harst, Robert, of Ratheby, yeoman 2
3836198 1969235 1969235 defendant Ratheby Geoffrey gent 615007 615007 Ratheby, Geoffrey, of Ratheby, gent 0
3849722 1973500 1973500 defendant Lyndesey John gent 615007 615007 Lyndesey, John, of Ratheby, gent 0
3852852 1974500 1974500 defendant Lyndesey Godfrey gent 615007 615007 (Lyndesey, Godfrey, of Ratheby, gent 1
3888332 1986360 1986360 defendant Bowes John yeoman 615007 615007 Bowes, John, of Ratheby, yeoman 1
3916849 1996000 1996000 defendant Porter John husbandman 615007 615007 Porter, John, of Ratheby, husbandman 3
4566986 2221235 2221235 defendant Bradle John   615007 615007 Bradle, John, of Ratheby 0
4575638 2223893 2223893 plaintiff Bradele John   615007 615007 Bradele, John, of Ratheby, administrators of 0
4575640 2223893 2223893 plaintiff Dale John   615007 615007 Dale, John, of Ratheby, parson 2
4614558 2235561 2235561 plaintiff Eland Robert   615007 615007 Eland, Robert, of Ratheby 1
4695545 2264090 2264090 defendant Ratheby Thomas husbandman 615007 615007 Ratheby, Thomas, of Ratheby, husbandman 3
4745368 2279154 2279154 defendant Walton William de husbandman 615007 615007 Walton, William de, of Ratheby, husbandman 0
4764077 2284753 2284753 defendant Ratheby Thomas husbandman 615007 615007 Ratheby, Thomas, of Ratheby, husbandman 1
4790211 2293022 2293022 defendant Ratheby Thomas husbandman 615007 615007 Ratheby, Thomas, of Ratheby, husbandman 1
4790212 2293022 2293022 defendant Walth- William husbandman 615007 615007 Walth-, William, of Ratheby, husbandman 2
4872219 2318272 2318272 defendant Eland Robert   615007 615007 Eland, Robert, of Ratheby 3
5101709 2386922 2386922 defendant Nicoll alias Brewer Thomas husbandman 615007 615007 Nicoll alias Brewer, Thomas, of Ratheby, husbandman 0
5364267 2464484 2464484 defendant Eland Robert gent 615007 615007 Eland, Robert, of Ratheby, gent 0
5364272 2464485 2464485 defendant Eland Robert gent 615007 615007 Eland, Robert,of Ratheby, gent 0
5412522 2478692 2478692 defendant Crappe Richard yeoman 615007 615007 Crappe, Richard, of Ratheby, yeoman 2
5427362 2483127 2483127 defendant Crappe Richard yeoman 615007 615007 Crappe, Richard, of Ratheby, yeoman 2
5445156 2488440 2488440 defendant Crappe Richard yeoman 615007 615007 Crappe, Richard, of Ratheby, yeoman 2
5457819 2492235 2492235 defendant Crapper Richard yeoman 615007 615007 Crapper, Richard, of Ratheby, yeoman 2
5503466 2505994 2505994 defendant Hochonson John yeoman 615007 615007 Hochonson, John, of Ratheby, yeoman 3
5563703 2523992 2523992 defendant Goce William clerk 615007 615007 Goce, William, of Ratheby, clerk 1
5631961 2554021 2554021 defendant Huchonson Richard husbandman 615007 615007 Huchonson, Richard, of Ratheby, husbandman 0

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);