names

27 rows where place_id = 586370

✎ 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
3588538 1864059 1864059 defendant Weston Thomas potter 586370 586370 Weston, Thomas, of Leyndon, potter 1
3614268 1872127 1872127 defendant Rawelyn John yeoman 586370 586370 Rawelyn, John, of Leyndon, yeoman 2
3619788 1873762 1873762 defendant Breton James chaplain 586370 586370 Breton, James, of Leyndon, chaplain 1
3734706 1937103 1937103 defendant Thressher Richard husbandman 586370 586370 Thressher, Richard, of Leyndon, husbandman 0
3775782 1950175 1950175 defendant Love Richard broker 586370 586370 Love, Richard, of Leyndon, broker 0
4553845 2217125 2217125 plaintiff Gobyon William   586370 586370 Gobyon, William, of Leyndon 0
4590728 2228453 2228453 defendant Gobyon William   586370 586370 Gobyon, William, of Leyndon 0
4607063 2233321 2233321 defendant Gobyon Wiliam   586370 586370 Gobyon, Wiliam, of Leyndon 0
4628459 2239823 2239823 defendant Heyward Robert   586370 586370 Heyward, Robert, of Leyndon 0
4628461 2239823 2239823 defendant Pathir John   586370 586370 Pathir, John, of Leyndon 2
4855595 2313115 2313115 defendant Ferthyng Thomas husbandman 586370 586370 Ferthyng, Thomas, of Leyndon, husbandman 0
4855596 2313115 2313115 defendant Grygyll William husbandman 586370 586370 Grygyll, William, of Leyndon, husbandman 1
5017968 2362137 2362137 defendant Gregyll William yeoman 586370 586370 Gregyll, William, of Leyndon, yeoman 0
5022308 2363419 2363419 defendant atte Maad Stephen husbandman 586370 586370 atte Maad, Stephen, of Leyndon, husbandman 0
5101690 2386914 2386914 defendant Toplay alias Topclyff John yeoman 586370 586370 Toplay alias Topclyff, John, of Leyndon, yeoman 0
5130359 2395368 2395368 defendant Gregill Stephen husbandman 586370 586370 Gregill, Stephen, of Leyndon, husbandman 0
5144131 2399436 2399436 defendant Sawser Robert clerk 586370 586370 Sawser, Robert, of Leyndon, clerk 0
5146553 2400130 2400130 plaintiff Campe John   586370 586370 Campe, John, of Leyndon 0
5146558 2400131 2400131 plaintiff Campe John   586370 586370 Campe, John, of Leyndon 0
5165081 2405532 2405532 defendant Sawser Robert clerk 586370 586370 Sawser, Robert, of Leyndon, clerk 0
5178745 2409503 2409503 defendant Topley John yeoman 586370 586370 Topley, John, of Leyndon, yeoman 0
5178772 2409514 2409514 defendant Sawser Robert clerk 586370 586370 Sawser, Robert, of Leyndon, clerk 0
5181508 2410334 2410334 plaintiff Campe John   586370 586370 Campe, John, of Leyndon 0
5202955 2416627 2416627 plaintiff Campe John   586370 586370 Campe, John, of Leyndon 0
5229432 2424217 2424217 defendant Gregyll Stephen yeoman 586370 586370 Gregyll, Stephen, of Leyndon, yeoman 1
5229435 2424218 2424218 defendant Gregell Stephen yeoman 586370 586370 Gregell, Stephen, of Leyndon, yeoman 1
5468770 2495587 2495587 defendant Weston Thomas husbandman 586370 586370 Weston, Thomas, of Leyndon, husbandman 1

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