names

35 rows where place_id = 690093

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4083401 2054344 2054344 defendant Cave Richard husbandman 690093 690093 Cave, Richard, of Halton Holgate, husbandman 0
4139783 2074588 2074588 defendant Thorye Thomas yeoman 690093 690093 Thorye, Thomas, of Halton Holgate, yeoman 0
4163485 2082754 2082754 defendant Crooke Benett yeoman 690093 690093 Crooke, Benett, of Halton Holgate, yeoman 0
4228947 2105606 2105606 defendant Lerry John butcher 690093 690093 Lerry, John, of Halton Holgate, or of Legsbye, butcher 0
4231667 2106578 2106578 defendant Howson John   690093 690093 Howson, John, of Halton Holgate clerk 1
4234255 2107517 2107517 defendant Smyth Andrew laborer 690093 690093 Smyth, Andrew, of Halton Holgate, laborer 1
4234256 2107517 2107517 defendant Corye William gent 690093 690093 Corye, William, of Halton Holgate, gent 2
4234259 2107518 2107518 defendant Overey Thomas gent 690093 690093 Overey, Thomas, of Halton Holgate, gent 0
4234350 2107551 2107551 defendant Pickeringe John yeoman 690093 690093 Pickeringe, John, of Halton Holgate, yeoman 1
4234351 2107551 2107551 defendant Hobson Thomas tailor 690093 690093 Hobson, Thomas, of Halton Holgate, tailor 2
4234956 2107777 2107777 defendant Cave Richard yeoman 690093 690093 Cave, Richard, of Halton Holgate, yeoman 0
4237362 2108656 2108656 defendant Grene John yeoman 690093 690093 Grene, John, of Halton Holgate, yeoman 0
4239266 2109355 2109355 defendant Hobson Thomas tailor 690093 690093 Hobson, Thomas, of Halton Holgate, tailor 2
4253112 2114038 2114038 defendant Pickeringe Thomas merchant 690093 690093 Pickeringe, Thomas, of Halton Holgate, merchant 0
4253113 2114038 2114038 defendant Pickeringe John yeoman 690093 690093 Pickeringe, John, of Halton Holgate, yeoman 1
4253114 2114038 2114038 defendant Hobson Thomas tailor 690093 690093 Hobson, Thomas, of Halton Holgate, tailor 2
4261517 2116814 2116814 defendant Pickeringe Thomas yeoman 690093 690093 Pickeringe, Thomas, of Halton Holgate, merchant, yeoman 0
4261518 2116814 2116814 defendant Hobson Thomas tailor 690093 690093 Hobson, Thomas, of Halton Holgate, tailor 1
4275300 2121295 2121295 defendant Fenne Thomas yeoman 690093 690093 Fenne, Thomas, of Halton Holgate, yeoman 2
4275350 2121314 2121314 defendant Thorne Thomas, junior yeoman 690093 690093 Thorne, Thomas, junior, of Halton Holgate, yeoman 0
4275351 2121314 2121314 defendant Pickeringe John yeoman 690093 690093 Pickeringe, John, of Halton Holgate, yeoman 1
4276077 2121581 2121581 defendant Covell John yeoman 690093 690093 Covell, John, of Halton Holgate, yeoman 0
4276078 2121581 2121581 defendant Covell Elizabeth widow 690093 690093 Elizabeth his wife, alias Elizabeth Melson, of Halton Holgate, widow 1
4280616 2123127 2123127 defendant Covell John yeoman 690093 690093 Covell, John, of Halton Holgate, yeoman 1
4283471 2124124 2124124 defendant Donyll John yeoman 690093 690093 Donyll, John, of Halton Holgate, yeoman 2
4292047 2127229 2127229 defendant Overey Thomas yeoman 690093 690093 Overey, Thomas, of Halton Holgate, yeoman 0
4295179 2128360 2128360 defendant Thorne Thomas yeoman 690093 690093 Thorne, Thomas, of Halton Holgate, yeoman 0
4295180 2128360 2128360 defendant Covile John yeoman 690093 690093 Covile, John, of Halton Holgate, yeoman 1
4295181 2128360 2128360 defendant Pickeringe John yeoman 690093 690093 Pickeringe, John, of Halton Holgate, yeoman 2
4342268 2144576 2144576 defendant Pickeringe John yeoman 690093 690093 Pickeringe, John, of Halton Holgate, yeoman 0
4343958 2145164 2145164 defendant Pickeringe John gent 690093 690093 Pickeringe, John, of Halton Holgate, yeoman, or of Jalton juxta Spilsbye, gent 0
4345745 2145781 2145781 defendant Pickeringe John yeoman 690093 690093 Pickeringe, John, of Halton Holgate, yeoman 0
4348364 2146679 2146679 defendant Langlay William laborer 690093 690093 Langlay, William, of Halton Holgate, laborer 0
4365971 2152868 2152868 defendant Pickering John yeoman 690093 690093 Pickering, John, of Halton Holgate, yeoman 0
4389781 2161205 2161205 defendant Anton John yeoman 690093 690093 Anton, John, of Halton Holgate, yeoman 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);