names

24 rows where place_id = 648415

✎ 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
3901470 1990714 1990714 defendant Mayewe Richard husbandman 648415 648415 Mayewe, Richard, of Brokley, husbandman 1
3901474 1990715 1990715 defendant Mayewe Joan widow 648415 648415 Mayewe, Joan, of Brokley, widow 0
3901475 1990715 1990715 defendant Maywe Richard husbandman 648415 648415 Maywe, Richard, of Brokley, husbandman 1
3914044 1995041 1995041 defendant Mahewe Richard husbandman 648415 648415 Mahewe, Richard, of Brokley, husbandman 0
3918557 1996533 1996533 defendant Heyward William husbandman 648415 648415 Heyward, William, of Brokley, husbandman 1
3922405 1997810 1997810 defendant Hyvell Edmund husbandman 648415 648415 Hyvell, Edmund, of Brokley, husbandman 5
3923276 1998095 1998095 defendant Mayhowe Richard husbandman 648415 648415 Mayhowe, Richard, of Brokley, husbandman 3
4685140 2260954 2260954 defendant Maylyn William (legal representative) 648415 648415 Maylyn, William, of Brokley, executrix of 3
4788674 2292512 2292512 defendant Alcok John clerk 648415 648415 Alcok, John, of Brokley, clerk 2
4800508 2296339 2296339 defendant Gascoigne William gent 648415 648415 Gascoigne, William, of Brokley, gent 1
4824171 2303634 2303634 defendant Lullesyate William husbandman 648415 648415 Lullesyate, William, of Brokley, husbandman 2
4909086 2329382 2329382 plaintiff Balt William   648415 648415 Balt, William, of Brokley 0
4909087 2329382 2329382 defendant Foderynghey Gerard gent 648415 648415 Foderynghey, Gerard, of Brokley, gent 0
4916787 2331757 2331757 defendant Galt John   648415 648415 Galt, John, of Brokley, parson 0
4916788 2331757 2331757 defendant Galt William husbandman 648415 648415 Galt, William, of Brokley, husbandman 1
4942252 2339567 2339567 defendant Galt William husbandman 648415 648415 Galt, William, of Brokley, husbandman 1
4942963 2339774 2339774 defendant Foderynghey Gerard gent 648415 648415 Foderynghey, Gerard, of Brokley, gent 0
5023942 2363915 2363915 defendant Fodryngey Gerard gent 648415 648415 Fodryngey, Gerard, of Brokley, gent 0
5035615 2367274 2367274 defendant Barry Robert clerk 648415 648415 Barry, Robert, of Brokley, clerk 7
5104290 2387675 2387675 defendant Copsy Roger husbandman 648415 648415 Copsy, Roger, of Brokley, husbandman 0
5104293 2387676 2387676 defendant Copsy Roger husbandman 648415 648415 Copsy, Roger, of Brokley, husbandman 0
5220050 2421573 2421573 defendant Clyvedon Alice widow 648415 648415 Clyvedon, Alice, of Brokley, widow 2
5235958 2426100 2426100 defendant Rungton John husbandman 648415 648415 Rungton, John, of Brokley, husbandman 0
5314320 2449301 2449301 defendant Boule John husbandman 648415 648415 Boule, John, of Brokley, husbandman: Elsyng, Stephen, of Brokley, husbandmanGyle, Roger, of Westle, husbandman 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);