names

31 rows where place_id = 589744

✎ 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
3598597 1867187 1867187 defendant Broun William clerk 589744 589744 Broun, William, of Thormondby, clerk 0
3598598 1867187 1867187 defendant Whitby Richard husbandman 589744 589744 Whitby, Richard, of Thormondby, husbandman 1
3598660 1867204 1867204 defendant Broun William clerk 589744 589744 Broun, William, of Thormondby, clerk 0
3598661 1867204 1867204 defendant Whytby Richard husbandman 589744 589744 Whytby, Richard, of Thormondby, husbandman 1
3733002 1936544 1936544 defendant Hosteler John laborer 589744 589744 Hosteler, John, of Thormondby, laborer 1
3733003 1936544 1936544 defendant Herryson Richard laborer 589744 589744 Herryson, Richard, of Thormondby, laborer 2
4418851 2170761 2170761 defendant Fluyreld William   589744 589744 Fluyreld, William, of Thormondby 0
4654216 2247201 2247201 defendant Blamfront Thomas yeoman 589744 589744 Blamfront, Thomas, of Thormondby, yeoman 1
4654219 2247201 2247201 defendant Creesse John laborer 589744 589744 Creesse, John, of Thormondby, laborer 4
4654221 2247201 2247201 defendant Blamfront John yeoman 589744 589744 Blamfront, John, of Thormondby, yeoman 6
4752593 2281220 2281220 defendant Brounknave John husbandman 589744 589744 Brounknave, John, of Thormondby, husbandman 0
4788904 2292582 2292582 defendant Sothill Richard yeoman 589744 589744 Sothill, Richard, of Thormondby, yeoman 3
4789496 2292782 2292782 plaintiff Suthill Richard   589744 589744 Suthill, Richard, of Thormondby 3
4961796 2345491 2345491 defendant Perkynson John husbandman 589744 589744 Perkynson, John, of Thormondby, husbandman 5
4961797 2345491 2345491 defendant Perkynson William husbandman 589744 589744 Perkynson, William, of Thormondby, husbandman 6
4961798 2345491 2345491 defendant Perkynson Thomas husbandman 589744 589744 Perkynson, Thomas, of Thormondby, husbandman 7
4961799 2345491 2345491 defendant Staynsby John husbandman 589744 589744 Staynsby, John, of Thormondby, husbandman 8
4988384 2353497 2353497 defendant Osbern John fishmonger 589744 589744 Osbern, John, of Thormondby, fishmonger 1
4988392 2353499 2353499 defendant Thormondby Robert   589744 589744 together with Thormondby, Robert, of Thormondby, franklin 1
4988403 2353499 2353499 defendant Thormondby Robert fishmonger 589744 589744 Thormondby, Robert, of Thormondby, fishmonger 12
4988418 2353501 2353501 defendant Wade Thomas husbandman 589744 589744 Wade, Thomas, of Thormondby, husbandman 5
4988430 2353501 2353501 defendant Thormondby Robert   589744 589744 Thormondby, Robert, of Thormondby, franklin 17
4995893 2355619 2355619 defendant Esshedale Thomas husbandman 589744 589744 Esshedale, Thomas, of Thormondby, husbandman 0
4995895 2355620 2355620 defendant Esshedale Thomas husbandman 589744 589744 Esshedale, Thomas, of Thormondby, husbandman 0
4999221 2356639 2356639 defendant Carter Nicholas husbandman 589744 589744 Carter, Nicholas, of Thormondby, husbandman 0
5015595 2361443 2361443 defendant Barett Robert husbandman 589744 589744 Barett, Robert, of Thormondby, husbandman 21
5015596 2361443 2361443 defendant Esshedal Thomas husbandman 589744 589744 Esshedal, Thomas, of Thormondby, husbandman 22
5036122 2367418 2367418 defendant Thormondby Robert   589744 589744 Thormondby, Robert, of Thormondby, gent, King's collector in North Riding 1
5039474 2368458 2368458 defendant Thormondby Robert   589744 589744 Thormondby, Robert, of Thormondby, franklin 0
5039936 2368588 2368588 defendant Baret Robert husbandman 589744 589744 Baret, Robert, of Thormondby, husbandman 1
5039975 2368600 2368600 defendant Baret Robert husbandman 589744 589744 Baret, Robert, of Thormondby, husbandman 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);