names

37 rows where place_id = 611390

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3688234 1922471 1922471 defendant Broke Thomas grocer 611390 611390 Broke, Thomas, of Harwiche, grocer 0
3789950 1954682 1954682 defendant Sakke John mariner 611390 611390 Sakke, John, of Harwiche, mariner 1
3821349 1964568 1964568 defendant Legge Robert fishmonger 611390 611390 Legge, Robert, of Harwiche, fishmonger 0
3843279 1971431 1971431 defendant Jeffson John merchant 611390 611390 Jeffson, John, of Harwiche, merchant 0
3848842 1973229 1973229 plaintiff Knyght William   611390 611390 Knyght, William, of Harwiche 0
3852905 1974523 1974523 defendant Roger John butcher 611390 611390 Roger, John, of Harwiche, butcher 0
3858720 1976398 1976398 defendant Clayce William barber 611390 611390 Clayce, William, of Harwiche, barber 0
3909542 1993495 1993495 defendant Peyntor alias Andrewson William yeoman 611390 611390 Peyntor alias Andrewson, William, of Harwiche, yeoman 1
3933646 2001542 2001542 defendant Peete Richard mariner 611390 611390 Peete, Richard, of Harwiche, mariner 0
3976918 2016493 2016493 defendant Andrewes John mariner 611390 611390 Andrewes, John, of Harwiche, mariner 3
3976919 2016493 2016493 defendant Harte Robert mariner 611390 611390 Harte, Robert, of Harwiche, mariner 4
4024204 2033359 2033359 defendant Tayler William mariner 611390 611390 Tayler, William, of Harwiche, or of Thorpe, Essex, mariner 0
4059841 2045913 2045913 defendant Graye John mariner 611390 611390 Graye, John, of Harwiche, mariner 0
4082413 2054017 2054017 defendant Daye Robert butcher 611390 611390 Daye, Robert, of Harwiche, butcher 0
4082414 2054017 2054017 defendant Kinge Richard butcher 611390 611390 Kinge, Richard, of Harwiche, butcher 1
4093496 2057989 2057989 defendant Phillippes Henry   611390 611390 Phillippes, Henry, of Harwiche, anchor smith 1
4099028 2059978 2059978 defendant Wheler John mercer 611390 611390 Wheler, John, of Harwiche, mercer 1
4127677 2070190 2070190 defendant Stephen Mary widow 611390 611390 Stephen, Mary, of Harwiche, widow 0
4170022 2085007 2085007 defendant Harsnett Seth baker 611390 611390 Harsnett, Seth, of Harwiche, baker 0
4175617 2086942 2086942 defendant Sacke Thomas beer brewer 611390 611390 Sacke, Thomas, of Harwiche, beer brewer 0
4185164 2090317 2090317 defendant Harsnett Seth yeoman 611390 611390 Harsnett, Seth, of Harwiche, yeoman 0
4185967 2090580 2090580 defendant Bardwell Augustine carpenter 611390 611390 Bardwell, Augustine, of Harwiche, carpenter 0
4274694 2121092 2121092 defendant Brett Thomas, senior joiner 611390 611390 Brett, Thomas, senior, of Harwiche, joiner 2
4276424 2121698 2121698 defendant Stutton George butcher 611390 611390 Stutton, George, of Harwiche, butcher 0
4276426 2121698 2121698 defendant Bacon William butcher 611390 611390 Bacon, William, of Harwiche, butcher 2
4278428 2122390 2122390 defendant More Thomas   611390 611390 More, Thomas, of Harwiche, sailor 1
4279561 2122767 2122767 defendant Bushe Robert husbandman 611390 611390 Bushe, Robert, of Harwiche, husbandman 1
4282027 2123614 2123614 defendant Haukyn Roger   611390 611390 Haukyn, Roger, of Harwiche, Essex, sailor 0
4282028 2123614 2123614 defendant Cooper Roger   611390 611390 Cooper, Roger, of Harwiche, sailor 1
4282537 2123795 2123795 defendant Dey Alice widow 611390 611390 Dey, Alice, of Harwiche, widow 2
5335143 2455580 2455580 defendant Bayle William mariner 611390 611390 Bayle, William, of Harwiche, mariner 1
5335144 2455580 2455580 defendant Smyth Thomas mariner 611390 611390 Smyth, Thomas, of Harwiche, mariner 2
5335145 2455580 2455580 defendant Est John mariner 611390 611390 Est, John, of Harwiche, mariner 3
5465214 2494498 2494498 defendant Parker William mariner 611390 611390 Parker, William, of Harwiche, mariner 1
5487460 2501143 2501143 defendant Bonde Thomas yeoman 611390 611390 Bonde, Thomas, of Harwiche, yeoman 9
5487461 2501143 2501143 defendant Elys John yeoman 611390 611390 Elys, John, of Harwiche, yeoman 10
5573974 2526952 2526952 defendant Pyers William yeoman 611390 611390 Pyers, William, of Harwiche, yeoman 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);