names

28 rows where place_id = 592195

✎ 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
3606895 1869821 1869821 defendant Flykke Richard husbandman 592195 592195 Flykke, Richard, of Haddeley, husbandman 1
3677393 1918980 1918980 defendant Baynard Stephen fuller 592195 592195 Baynard, Stephen, of Haddeley, fuller 0
3677394 1918980 1918980 defendant Wyllyams John butcher 592195 592195 Wyllyams, John, of Haddeley, butcher 1
3762429 1945892 1945892 defendant Mannyng William husbandman 592195 592195 Mannyng, William, of Haddeley, husbandman 3
3797049 1956958 1956958 plaintiff Freman John   592195 592195 Freman, John, of Haddeley 0
4463719 2189341 2189341 defendant Dyer Robert   592195 592195 Dyer, Robert, of Haddeley 3
4463728 2189342 2189342 defendant Dyer Robert   592195 592195 Dyer, Robert, of Haddeley 3
4585012 2226739 2226739 defendant E_ John   592195 592195 E_, John, of Haddeley 3
4585013 2226739 2226739 defendant Huntyngfeld John   592195 592195 Huntyngfeld, John, of Haddeley 4
4585014 2226739 2226739 defendant Kempston Mary   592195 592195 Kempston, Mary, of Haddeley 5
4641187 2243513 2243513 defendant Baker William   592195 592195 Baker, William, of Haddeley 1
4683329 2260390 2260390 defendant Fuller John fuller 592195 592195 (Fuller, John, of Haddeley, fuller 1
4683330 2260390 2260390 defendant Hillary Robert dyer 592195 592195 Hillary, Robert, of Haddeley, dyer 2
4753071 2281349 2281349 defendant Wynlove John dyer 592195 592195 Wynlove, John, of Haddeley, dyer 0
4808805 2298921 2298921 defendant Hauche--- John chapman 592195 592195 Hauche---, John, of Haddeley, chapman 0
4808806 2298921 2298921 defendant Lacy John chapman 592195 592195 Lacy, John, of Haddeley, chapman 1
4808807 2298921 2298921 defendant Wade Thomas chapman 592195 592195 Wade, Thomas, of Haddeley, chapman 2
4919884 2332727 2332727 defendant Lovell Morris yeoman 592195 592195 Lovell, Morris, of Haddeley, yeoman 0
5015779 2361501 2361501 defendant Hillary William gent 592195 592195 together with Hillary, William, of Haddeley, gent 1
5015781 2361502 2361502 defendant Hillary William gent 592195 592195 Hillary, William, of Haddeley, gent 0
5088294 2382950 2382950 defendant Stuke Robert merchant 592195 592195 Stuke, Robert, of Haddeley, merchant 0
5097691 2385750 2385750 defendant Blowebolle Thomas fuller 592195 592195 Blowebolle, Thomas, of Haddeley, fuller 1
5357037 2462262 2462262 defendant Loder Thomas husbandman 592195 592195 Loder, Thomas, of Haddeley, husbandman 0
5412251 2478618 2478618 defendant Cokston Henry husbandman 592195 592195 Cokston, Henry, of Haddeley, husbandman 1
5412252 2478618 2478618 defendant Bona_ Mathew laborer 592195 592195 Bona_, Mathew, of Haddeley, laborer 2
5549383 2519870 2519870 defendant Blount Phiip gent 592195 592195 Blount, Phiip, of Haddeley, gent 1
5615679 2548693 2548693 defendant Corbet Robert   592195 592195 Corbet, Robert, of Haddeley, knight 0
5615899 2548773 2548773 plaintiff Bacoun Robert   592195 592195 Bacoun, Robert, of Haddeley 1

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