names

12 rows where place_id = 756155

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4434697 2175615 2175615 defendant Mourton John   756155 756155 Mourton, John, of Garsyndon 0
4450306 2185055 2185055 plaintiff Hanvyle John   756155 756155 Hanvyle, John, of Garsyndon 0
4450721 2185186 2185186 plaintiff Hauvile John   756155 756155 Hauvile, John, of Garsyndon 0
4581204 2225599 2225599 defendant Harper Roger   756155 756155 Harper, Roger, of Garsyndon 5
4581214 2225599 2225599 defendant Smyth John   756155 756155 Smyth, John, of Garsyndon 15
4581220 2225599 2225599 defendant Barbour William   756155 756155 Barbour, William, of Garsyndon 21
4581222 2225599 2225599 defendant Clerk Nicholas   756155 756155 Clerk, Nicholas, of Garsyndon 23
4581223 2225599 2225599 defendant Hayward Hugh   756155 756155 Hayward, Hugh, of Garsyndon 24
4581226 2225599 2225599 defendant Bocher Richard   756155 756155 Bocher, Richard, of Garsyndon 27
4581235 2225599 2225599 defendant Smyth William   756155 756155 Smyth, William, of Garsyndon 36
4581239 2225599 2225599 defendant Clerk John   756155 756155 Clerk, John, of Garsyndon 40
4718672 2271179 2271179 defendant Hyckys John, sen butcher 756155 756155 Hyckys, John, sen, of Garsyndon, butcher 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);