names

35 rows where place_id = 621885

✎ 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
3744095 1940050 1940050 defendant Bottall William carpenter 621885 621885 Bottall, William, of Orsett, carpenter 0
3746606 1940854 1940854 defendant Bottell William husbandman 621885 621885 Bottell, William, of Orsett, husbandman 0
3749557 1941774 1941774 defendant Bottell William carpenter 621885 621885 Bottell, William, of Orsett, carpenter 0
3749558 1941774 1941774 defendant Stuard John husbandman 621885 621885 Stuard, John, of Orsett, husbandman 1
3756800 1944099 1944099 plaintiff Balden John   621885 621885 Balden, John, of Orsett 0
3763111 1946094 1946094 defendant Palmer Edward yeoman 621885 621885 Palmer, Edward, of Orsett, yeoman 2
3787903 1954007 1954007 defendant Whyte John husbandman 621885 621885 Whyte, John, of Orsett, husbandman 1
3789077 1954394 1954394 defendant Kendall Edward shoemaker 621885 621885 Kendall, Edward, of Orsett, shoemaker 0
3805052 1959522 1959522 defendant Blakemore John husbandman 621885 621885 Blakemore, John, of Orsett, husbandman 1
3826467 1966126 1966126 defendant Hethe John shoemaker 621885 621885 Hethe, John, of Orsett, shoemaker 0
3835004 1968888 1968888 defendant Kendall Edward shoemaker 621885 621885 Kendall, Edward, of Orsett, shoemaker 1
3835007 1968889 1968889 defendant Kendalle Edward shoemaker 621885 621885 Kendalle, Edward, of Orsett, shoemaker 1
3838134 1969842 1969842 defendant Tayler John tailor 621885 621885 Tayler, John, of Orsett, tailor 0
3871058 1980572 1980572 defendant Gervys John barber 621885 621885 Gervys, John, of Orsett, barber 0
3872994 1981184 1981184 defendant Clerke Thomas yeoman 621885 621885 Clerke, Thomas, of Orsett, yeoman 0
3873001 1981185 1981185 defendant Clerke Thomas yeoman 621885 621885 Clerke, Thomas, of Orsett, yeoman 0
3877648 1982765 1982765 defendant Banester William yeoman 621885 621885 Banester, William, of Orsett, yeoman 0
4056873 2044839 2044839 defendant Garrett Richard husbandman 621885 621885 Garrett, Richard, of Orsett, husbandman 0
4215551 2100936 2100936 defendant Cooke Robert yeoman 621885 621885 Cooke, Robert, of Orsett, yeoman 1
4241744 2110225 2110225 defendant Cooke Robert yeoman 621885 621885 Cooke, Robert, of Orsett, yeoman 1
4248707 2112553 2112553 defendant White George yeoman 621885 621885 White, George, of Orsett, yeoman 1
4276273 2121644 2121644 defendant Wittam Robert tanner 621885 621885 Wittam, Robert, of Orsett, tanner 0
4281414 2123405 2123405 defendant Robichut William yeoman 621885 621885 Robichut, William, of Orsett, yeoman 0
4282669 2123842 2123842 defendant Wittam Robert tanner 621885 621885 Wittam, Robert, of Orsett, tanner 0
4352487 2148106 2148106 defendant Robichut William yeoman 621885 621885 Robichut, William, of Orsett, yeoman 0
4378339 2157325 2157325 defendant Cock Robert yeoman 621885 621885 Cock, Robert, of Orsett, yeoman 0
4398277 2164004 2164004 defendant Scott Henry smith 621885 621885 Scott, Henry, of Orsett, smith 0
4398278 2164004 2164004 defendant Cooke William husbandman 621885 621885 Cooke, William, of Orsett, husbandman 1
4408695 2167503 2167503 defendant Robiaunte William yeoman 621885 621885 Robiaunte, William, of Orsett, yeoman 0
4408697 2167503 2167503 defendant Lowe Humphrey husbandman 621885 621885 Lowe, Humphrey, of Orsett, husbandman 2
4408922 2167585 2167585 defendant Robiaunte William yeoman 621885 621885 Robiaunte, William, of Orsett, yeoman 1
4408924 2167586 2167586 defendant Roviaunte William yeoman 621885 621885 Roviaunte, William, of Orsett, yeoman 0
5089260 2383228 2383228 defendant Saukyn William husbandman 621885 621885 Saukyn, William, of Orsett, husbandman 2
5089261 2383228 2383228 defendant Baker John husbandman 621885 621885 Baker, John, of Orsett, husbandman 3
5089262 2383228 2383228 defendant Nicoll Thomas husbandman 621885 621885 Nicoll, Thomas, of Orsett, husbandman 4

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