names

12 rows where place_id = 791188

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4722545 2272365 2272365 defendant Cobeham William gent 791188 791188 Cobeham, William, of Hoo St Mary, gent 0
4798875 2295823 2295823 defendant Shirwode John chaplain 791188 791188 Shirwode, John, of Hoo St Mary, chaplain 2
5055547 2373239 2373239 defendant Alton William gent 791188 791188 Alton, William, of Hoo St Mary, gent 0
5055548 2373239 2373239 defendant Alton John clerk 791188 791188 Alton, John, of Hoo St Mary, clerk 1
5055550 2373239 2373239 defendant Spycer Henry laborer 791188 791188 Spycer, Henry, of Hoo St Mary, laborer 3
5055551 2373239 2373239 defendant Fraunceys Thomas laborer 791188 791188 Fraunceys, Thomas, of Hoo St Mary, laborer 4
5055553 2373239 2373239 defendant Raffe John clerk 791188 791188 Raffe, John, of Hoo St Mary, clerk 6
5055556 2373239 2373239 defendant Alton Adam laborer 791188 791188 Alton, Adam, of Hoo St Mary, laborer 9
5055557 2373239 2373239 defendant Wayte Stephen laborer 791188 791188 Wayte, Stephen, of Hoo St Mary, laborer 10
5055558 2373239 2373239 defendant Wayte John laborer 791188 791188 Wayte, John, of Hoo St Mary, laborer 11
5185503 2411510 2411510 defendant Fryday John husbandman 791188 791188 Fryday, John, of Hoo St Mary, husbandman 0
5229923 2424369 2424369 defendant Nicholas William gent 791188 791188 Nicholas, William, of Hoo St Mary, 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);