names

13 rows where place_id = 872558

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5316372 2449981 2449981 defendant Ingram Brian chaplain 872558 872558 Ingram, Brian, of North Grymston, chaplain 1
5323596 2452141 2452141 defendant Tylman Emma spinster 872558 872558 Tylman, Emma, of North Grymston, spinster 0
5338541 2456622 2456622 defendant Blake Peter walker 872558 872558 Blake, Peter, of North Grymston, walker 0
5338543 2456623 2456623 defendant Blake Peter walker 872558 872558 Blake, Peter, of North Grymston, walker 0
5338545 2456624 2456624 defendant Clerkson Richard husbandman 872558 872558 Clerkson, Richard, of North Grymston, husbandman 0
5338547 2456625 2456625 defendant Clerkson William husbandman 872558 872558 Clerkson, William, of North Grymston, husbandman 0
5347345 2459332 2459332 defendant Ingram Brian clerk 872558 872558 Ingram, Brian, of North Grymston, clerk 0
5347350 2459332 2459332 defendant Bateman William sawyer 872558 872558 Bateman, William, of North Grymston, sawyer 5
5536258 2515832 2515832 defendant Bygod Peter esq 872558 872558 Bygod, Peter, of North Grymston, esq 0
5536259 2515832 2515832 defendant Ingram Richard yeoman 872558 872558 Ingram, Richard, of North Grymston, yeoman 1
5536260 2515832 2515832 defendant Hall Thomas yeoman 872558 872558 Hall, Thomas, of North Grymston, yeoman 2
5536261 2515832 2515832 defendant Curward William husbandman 872558 872558 Curward, William, of North Grymston, husbandman 3
5536262 2515832 2515832 defendant Hall Adam husbandman 872558 872558 Hall, Adam, of North Grymston, husbandman 4

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