names

43 rows where place_id = 586706

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589428 1864332 1864332 defendant Freston John butcher 586706 586706 Freston, John, of Alcetur, butcher 0
3589429 1864332 1864332 defendant Wrangham Thomas glasier 586706 586706 Wrangham, Thomas, of Alcetur, glasier 1
3607797 1870090 1870090 defendant Freston John butcher 586706 586706 Freston, John, of Alcetur, butcher 0
3625937 1902969 1902969 defendant Felowes Richard shoemaker 586706 586706 Felowes, Richard, of Alcetur, shoemaker 0
3625938 1902969 1902969 defendant Style John laborer 586706 586706 Style, John, of Alcetur, laborer 1
3625939 1902969 1902969 defendant Hall Roger laborer 586706 586706 Hall, Roger, of Alcetur, laborer 2
3629912 1904210 1904210 defendant Shawe John, senior (legal representative) 586706 586706 Shawe, John, senior, of Alcetur, yeoman, executrix of 0
3639543 1907177 1907177 defendant Felowys Richard shoemaker 586706 586706 Felowys, Richard, of Alcetur, shoemaker 0
3639544 1907177 1907177 defendant Syle John laborer 586706 586706 Syle, John, of Alcetur, laborer 1
3639545 1907177 1907177 defendant Style Thomas laborer 586706 586706 Style, Thomas, of Alcetur, laborer 2
3639546 1907177 1907177 defendant Half Roger laborer 586706 586706 Half, Roger, of Alcetur, laborer 3
3650239 1910446 1910446 defendant Elmes Thomas mercer 586706 586706 Elmes, Thomas, of Alcetur, mercer 0
3678704 1919406 1919406 defendant Marche Humphrey wheeler 586706 586706 Marche, Humphrey, of Alcetur, wheeler 0
3678705 1919406 1919406 defendant Hobdey Thomas draper 586706 586706 Hobdey, Thomas, of Alcetur, draper 1
3678706 1919406 1919406 defendant Broune John butcher 586706 586706 Broune, John, of Alcetur, butcher 2
3678707 1919406 1919406 defendant Howse Robert fuller 586706 586706 Howse, Robert, of Alcetur, fuller 3
3678708 1919406 1919406 defendant Tyse John butcher 586706 586706 Tyse, John, of Alcetur, butcher 4
3717780 1931863 1931863 defendant Ireland Adam butcher 586706 586706 Ireland, Adam, of Alcetur, butcher 0
3717781 1931863 1931863 defendant Broun John husbandman 586706 586706 Broun, John, of Alcetur, husbandman 1
3731402 1936043 1936043 defendant Baker Richard baker 586706 586706 Baker, Richard, of Alcetur, baker 1
3779323 1951255 1951255 defendant Stanley William yeoman 586706 586706 Stanley, William, of Alcetur, yeoman 2
3873214 1981257 1981257 defendant Broun John butcher 586706 586706 Broun, John, of Alcetur, butcher 0
3881584 1984103 1984103 defendant Bonnour Thomas, junior yeoman 586706 586706 Bonnour, Thomas, junior, of Alcetur, yeoman 1
3930295 2000480 2000480 defendant Madley William butcher 586706 586706 Madley, William, of Alcetur, butcher 0
3937225 2002781 2002781 defendant Webster William yeoman 586706 586706 Webster, William, of Alcetur, yeoman 0
4832740 2306263 2306263 defendant Chapmon Ralph husbandman 586706 586706 Chapmon, Ralph, of Alcetur, husbandman 1
4859645 2314390 2314390 defendant Chap- Ralph husbandman 586706 586706 Chap-, Ralph, of Alcetur, husbandman 0
5078946 2380188 2380188 defendant Tandy William yeoman 586706 586706 Tandy, William, of Alcetur, yeoman 0
5078968 2380192 2380192 defendant Tandy William yeoman 586706 586706 Tandy, William, of Alcetur, yeoman 0
5313463 2449057 2449057 defendant Skynner Henry barker 586706 586706 Skynner, Henry, of Alcetur, barker 0
5330179 2454102 2454102 defendant Hasylholt Richard yeoman 586706 586706 Hasylholt, Richard, of Alcetur, yeoman 0
5330180 2454102 2454102 defendant Hasylholt William yeoman 586706 586706 Hasylholt, William, of Alcetur, yeoman 1
5330181 2454102 2454102 defendant Huntyngdon John laborer 586706 586706 Huntyngdon, John, of Alcetur, laborer 2
5330182 2454102 2454102 defendant Russheton Alexander yeoman 586706 586706 Russheton, Alexander, of Alcetur, yeoman 3
5349023 2459823 2459823 defendant Beryman Henry husbandman 586706 586706 Beryman, Henry, of Alcetur, husbandman 4
5374496 2467627 2467627 defendant Wodcoke Emma widow 586706 586706 Wodcoke, Emma, of Alcetur, widow 1
5409047 2477670 2477670 defendant Smyth Thomas chapman 586706 586706 Smyth, Thomas, of Alcetur, chapman 0
5422443 2481659 2481659 defendant Smyth Thomas chapman 586706 586706 Smyth, Thomas, of Alcetur, chapman 0
5422445 2481660 2481660 defendant Smyth Thomas chapman 586706 586706 Smyth, Thomas, of Alcetur, chapman 0
5422447 2481661 2481661 defendant Smyth Thomas chapman 586706 586706 Smyth, Thomas, of Alcetur, chapman 0
5500031 2504964 2504964 defendant Haydon Robert   586706 586706 Haydon, Robert, of Alcetur, vestment maker 1
5500034 2504965 2504965 defendant Haydok Robert   586706 586706 Haydok, Robert, of Alcetur, vestment maker 1
5583509 2529913 2529913 defendant Shawe John gent 586706 586706 Shawe, John, of Alcetur, gent 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);