names

15 rows where place_id = 761519

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4479645 2194297 2194297 defendant Hoker Hugh   761519 761519 Hoker, Hugh, of Halghton 2
4581271 2225609 2225609 defendant Hachet Edmund chaplain 761519 761519 Hachet, Edmund, of Halghton, chaplain 0
4643711 2244261 2244261 defendant Hord William   761519 761519 Hord, William, of Halghton 1
4671821 2256833 2256833 defendant Huchenson Philip husbandman 761519 761519 Huchenson, Philip, of Halghton, husbandman 3
4703849 2266583 2266583 defendant Dalley John yeoman 761519 761519 Dalley, John, of Halghton, yeoman 0
4726550 2273581 2273581 plaintiff Wylde John   761519 761519 Wylde, John, of Halghton, parson 2
4726554 2273582 2273582 plaintiff Wylde John   761519 761519 Wylde, John, of Halghton, parson 2
4737977 2276983 2276983 defendant Dudle William husbandman 761519 761519 Dudle, William, of Halghton, husbandman 2
4864787 2315961 2315961 plaintiff Frauncys Robert   761519 761519 Frauncys, Robert, of Halghton 0
4877599 2319951 2319951 defendant Bovyle or Bonyle Thomas esq 761519 761519 Bovyle or Bonyle, Thomas, of Halghton, esq 0
4964440 2346274 2346274 defendant Meghton Thomas husbandman 761519 761519 Meghton, Thomas, of Halghton, husbandman 11
5143703 2399289 2399289 defendant Aspeley William husbandman 761519 761519 Aspeley, William, of Halghton, husbandman 10
5319116 2450811 2450811 defendant Harecourt John esq 761519 761519 Harecourt, John, of Halghton, esq 0
5319118 2450812 2450812 defendant Harecourt John esq 761519 761519 Harecourt, John, of Halghton, esq 0
5368223 2465686 2465686 defendant Brenewey Richard gent 761519 761519 Brenewey, Richard, of Halghton, gent 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);