names

15 rows where place_id = 615847

✎ 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
3711067 1929772 1929772 defendant Hyll William husbandman 615847 615847 Hyll, William, of Byrley, husbandman 0
3711068 1929772 1929772 defendant Caldwall John husbandman 615847 615847 Caldwall, John, of Byrley, husbandman 1
3789515 1954546 1954546 defendant Durrant John clerk 615847 615847 Durrant, John, of Byrley, clerk 1
3805650 1959711 1959711 defendant Durrant John clerk 615847 615847 Durrant, John, of Byrley, clerk 1
3871009 1980556 1980556 defendant ap Roger John husbandman 615847 615847 ap Roger, John, of Byrley, husbandman 1
3885384 1985365 1985365 defendant Wynston Thomas gent 615847 615847 Wynston, Thomas, of Byrley, gent 4
3911524 1994171 1994171 defendant Walker alias Grenhyll Roger husbandman 615847 615847 Walker alias Grenhyll, Roger, of Byrley, husbandman 2
3925632 1998883 1998883 defendant Carpynter John yeoman 615847 615847 Carpynter, John, of Byrley, yeoman 1
3932103 2001042 2001042 defendant Farnole John husbandman 615847 615847 Farnole, John, of Byrley, husbandman 0
3982870 2018649 2018649 defendant Rogers Geoffrey husbandman 615847 615847 Rogers, Geoffrey, of Byrley, husbandman 0
4032388 2036245 2036245 defendant Heynes Geoffrey yeoman 615847 615847 Heynes, Geoffrey, of Byrley, yeoman 17
4032408 2036248 2036248 defendant Rogers Geoffrey yeoman 615847 615847 Rogers, Geoffrey, of Byrley, yeoman 14
4036640 2037786 2037786 defendant Rogers Geoffrey yeoman 615847 615847 Rogers, Geoffrey, of Byrley, yeoman 0
4513566 2204666 2204666 plaintiff Broun John   615847 615847 Broun, John, of Byrley 0
4536968 2211833 2211833 defendant Hopkynson Robert   615847 615847 Hopkynson, Robert, of Byrley 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);