names

27 rows where place_id = 642098

✎ 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
3794948 1956285 1956285 plaintiff Colclough Robert (legal representative) 642098 642098 Colclough, Robert, of Forton, executrix of 0
3865779 1978783 1978783 defendant Penne John gent 642098 642098 Penne, John, of Forton, gent 0
3865781 1978784 1978784 defendant Penne Philip gent 642098 642098 Penne, Philip, of Forton, gent 0
3979706 2017495 2017495 defendant Jerves John laborer 642098 642098 Jerves, John, of Forton, laborer 0
3995866 2023270 2023270 defendant Lowe Roger husbandman 642098 642098 together with Lowe, Roger, of Forton, husbandman 1
4327976 2139678 2139678 defendant Gough or Gor John yeoman 642098 642098 Gough or Gor, John, of Forton, yeoman 1
4332310 2141099 2141099 defendant Bold Brian husbandman 642098 642098 Bold, Brian, of Forton, husbandman 0
4384877 2159630 2159630 defendant Bishoppe Richard salter 642098 642098 Bishoppe, Richard, of Forton, salter 2
4595060 2229712 2229712 defendant Weston John   642098 642098 Weston, John, of Forton 0
4637995 2242646 2242646 defendant Corley William   642098 642098 Corley, William, of Forton, parson 2
4757952 2282865 2282865 plaintiff Brugge William   642098 642098 Brugge, William, of Forton 0
4757957 2282866 2282866 plaintiff Brugge William   642098 642098 Brugge, William, of Forton 0
4928590 2335373 2335373 plaintiff Smyth William   642098 642098 Smyth, William, of Forton 0
5137026 2397344 2397344 defendant Milleburne Simon esq 642098 642098 Milleburne, Simon, of Forton, esq 0
5137028 2397345 2397345 defendant Milleburne Simon esq 642098 642098 Milleburne, Simon, of Forton, esq 0
5157860 2403425 2403425 defendant Milleburne Simon esq 642098 642098 Milleburne, Simon, of Forton, esq, formerly of Larkestoke, Wilts, esq 0
5193480 2413822 2413822 defendant Milleburne Simon esq 642098 642098 Milleburne, Simon, of Forton, esq 0
5213114 2419569 2419569 defendant Webbe William husbandman 642098 642098 Webbe, William, of Forton, husbandman 1
5213116 2419569 2419569 defendant Thomson Thomas   642098 642098 Thomson, Thomas, of Forton, cartwright 3
5219761 2421504 2421504 defendant Steyne John husbandman 642098 642098 Steyne, John, of Forton, husbandman 1
5316077 2449882 2449882 defendant Weston John husbandman 642098 642098 Weston, John, of Forton, husbandman 1
5316078 2449882 2449882 defendant Fonten Mathew husbandman 642098 642098 Fonten, Mathew, of Forton, husbandman 2
5564860 2524308 2524308 defendant Betonson Thomas clerk 642098 642098 Betonson, Thomas, of Forton, clerk 3
5564861 2524308 2524308 defendant Geslyng John husbandman 642098 642098 Geslyng, John, of Forton, husbandman 4
5578573 2528368 2528368 defendant Blakemore John husbandman 642098 642098 Blakemore, John, of Forton, husbandman 1
5578574 2528368 2528368 defendant Parys William husbandman 642098 642098 Parys, William, of Forton, husbandman 2
5592461 2532627 2532627 defendant Colclogh Joan widow 642098 642098 Colclogh, Joan, of Forton, widow 5

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