names

23 rows where place_id = 605161

✎ 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
3660608 1913578 1913578 defendant Bechom Edward yeoman 605161 605161 Bechom, Edward, of East Greenwich, Kent, yeoman 2
3660609 1913578 1913578 defendant Willet John yeoman 605161 605161 Willet, John, of East Greenwich, Kent, yeoman 3
3663419 1914485 1914485 defendant Johnson John yeoman 605161 605161 Johnson, John, of East Greenwich, Kent, yeoman 0
3664272 1914778 1914778 defendant Tebs Edmund yeoman 605161 605161 (Tebs, Edmund, of East Greenwich, Kent, yeoman 1
3938304 2003150 2003150 plaintiff Probis Hugh (legal representative) 605161 605161 Probis, Hugh, of East Greenwich, Kent, yeoman, executors of 0
3942404 2004471 2004471 defendant Hossey Lawrence   605161 605161 Hossey, Lawrence, of East Greenwich, Kent 1
3942881 2004621 2004621 defendant Cooke William gent 605161 605161 Cooke, William, of East Greenwich, Kent, gent 3
4716438 2270459 2270459 defendant Byle John   605161 605161 Byle, John, of East Greenwich, Kent, horse dealer 1
4716911 2270621 2270621 defendant Byle John   605161 605161 Byle, John, of East Greenwich, Kent, cosour, formerly of London 1
4773978 2287844 2287844 defendant Mundene Nicholas yeoman 605161 605161 Mundene, Nicholas, of East Greenwich, Kent, yeoman 0
4807984 2298678 2298678 defendant Buk John husbandman 605161 605161 Buk, John, of East Greenwich, Kent, husbandman 0
4838321 2307902 2307902 defendant Whitelyng William clerk 605161 605161 Whitelyng, William, of East Greenwich, Kent, clerk 0
4985645 2352621 2352621 defendant Aleyn Thomas yeoman 605161 605161 Aleyn, Thomas, of East Greenwich, Kent, yeoman 1
4985649 2352622 2352622 defendant Aleyn Thomas yeoman 605161 605161 Aleyn, Thomas, of East Greenwich, Kent, yeoman 1
4997915 2356235 2356235 defendant Neuman John brewer 605161 605161 Neuman, John, of East Greenwich, Kent, brewer 1
5170843 2407196 2407196 defendant Cheseman Thomas gent 605161 605161 Cheseman, Thomas, of East Greenwich, Kent, gent 0
5184588 2411239 2411239 defendant Style Richard husbandman 605161 605161 Style, Richard, of East Greenwich, Kent, husbandman 0
5188870 2412477 2412477 defendant Cheseman Thomas gent 605161 605161 Cheseman, Thomas, of East Greenwich, Kent, gent 0
5188872 2412478 2412478 defendant Cheseman Thomas gent 605161 605161 Cheseman, Thomas, of East Greenwich, Kent, gent 0
5204415 2417040 2417040 defendant Style Richard husbandman 605161 605161 together with Style, Richard, of East Greenwich, Kent, husbandman 1
5206279 2417570 2417570 defendant Cheseman Thomas gent 605161 605161 Cheseman, Thomas, of East Greenwich, Kent, gent 0
5276033 2438064 2438064 defendant Pope Robert husbandman 605161 605161 Pope, Robert, of East Greenwich, Kent, husbandman 2
5305859 2446745 2446745 defendant Cok Roger gent 605161 605161 Cok, Roger, of East Greenwich, Kent, gent 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);