names

19 rows where place_id = 652504

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3924134 1998382 1998382 defendant Bayly Walter clothier 652504 652504 Bayly, Walter, of Devyse, Wilts, clothier 2
4036850 2037862 2037862 defendant Gryffyn John draper 652504 652504 Gryffyn, John, of Devyse, Wilts, draper 0
4203719 2096858 2096858 defendant Gordrye Robert chapman 652504 652504 Gordrye, Robert, of Devyse, Wilts, chapman 2
4300172 2130160 2130160 defendant Flower Martin gent 652504 652504 Flower, Martin, of Devyse, Wilts, gent 0
4786437 2291804 2291804 defendant Bouker John yeoman 652504 652504 Bouker, John, of Devyse, Wilts, yeoman 0
4964095 2346172 2346172 defendant Elys Augustine yeoman 652504 652504 Elys, Augustine, of Devyse, Wilts, yeoman 2
5012805 2360577 2360577 defendant Bowyer Roger chapman 652504 652504 Bowyer, Roger, of Devyse, Wilts, chapman 0
5031407 2366044 2366044 defendant Wastell William clothman 652504 652504 Wastell, William, of Devyse, Wilts, clothman 0
5031412 2366045 2366045 defendant Estmond John weaver 652504 652504 Estmond, John, of Devyse, Wilts, weaver 0
5094726 2384868 2384868 defendant Hendelove William weaver 652504 652504 Hendelove, William, of Devyse, Wilts, weaver 0
5217715 2420910 2420910 defendant Reynold John clothier 652504 652504 Reynold, John, of Devyse, Wilts, clothier 14
5261073 2433576 2433576 defendant Notlyn John, senior laborer 652504 652504 Notlyn, John, senior, of Devyse, Wilts, laborer 0
5261074 2433576 2433576 defendant Notlyn John, junior laborer 652504 652504 Notlyn, John, junior, of Devyse, Wilts, laborer 1
5263265 2434256 2434256 defendant Bernard John clothmaker 652504 652504 Bernard, John, of Devyse, Wilts, clothmaker 1
5286071 2440934 2440934 defendant Hethe Thomas chapman 652504 652504 Hethe, Thomas, of Devyse, Wilts, chapman 0
5380040 2469343 2469343 defendant Gilbard William weaver 652504 652504 Gilbard, William, of Devyse, Wilts, weaver 0
5493754 2503039 2503039 defendant Haukyns George clothier 652504 652504 Haukyns, George, of Devyse, Wilts, clothier 4
5536405 2515876 2515876 defendant Lymbury Richard clothier 652504 652504 Lymbury, Richard, of Devyse, Wilts, clothier 0
5624927 2551731 2551731 defendant Sherman John weaver 652504 652504 Sherman, John, of Devyse, Wilts, weaver 2

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