names

17 rows where place_id = 589888

✎ 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
3599129 1867364 1867364 defendant Thomlynson John yeoman 589888 589888 Thomlynson, John, of Staynburn, yeoman 2
3624509 1875201 1875201 defendant Clyfton William laborer 589888 589888 Clyfton, William, of Staynburn, laborer 0
4512446 2204333 2204333 defendant Robynson John   589888 589888 Robynson, John, of Staynburn 2
4797328 2295336 2295336 defendant Paweson William husbandman 589888 589888 Paweson, William, of Staynburn, husbandman 0
4854382 2312770 2312770 defendant Nante John husbandman 589888 589888 Nante, John, of Staynburn, husbandman 1
4854383 2312770 2312770 defendant Hessay Robert husbandman 589888 589888 Hessay, Robert, of Staynburn, husbandman 2
4854384 2312770 2312770 defendant Robynson John husbandman 589888 589888 Robynson, John, of Staynburn, husbandman 3
5117403 2391522 2391522 defendant Pollan William yeoman 589888 589888 Pollan, William, of Staynburn, yeoman 0
5224426 2422817 2422817 defendant Forest John husbandman 589888 589888 Forest, John, of Staynburn, husbandman 10
5224440 2422818 2422818 defendant Forest John husbandman 589888 589888 Forest, John, of Staynburn, husbandman 10
5247058 2429300 2429300 defendant Forest Robert laborer 589888 589888 Forest, Robert, of Staynburn, laborer 1
5337428 2456267 2456267 defendant Wylson John yeoman 589888 589888 Wylson, John, of Staynburn, Cumber, yeoman 3
5381122 2469658 2469658 defendant Dybbes Richard   589888 589888 Dybbes, Richard, of Staynburn 0
5381123 2469658 2469658 defendant Dybbes William laborer 589888 589888 Dybbes, William, of Staynburn, laborer 1
5387652 2471534 2471534 defendant Dybbes Richard laborer 589888 589888 Dybbes, Richard, of Staynburn, laborer 0
5387653 2471534 2471534 defendant Dybbes Percival laborer 589888 589888 Dybbes, Percival, of Staynburn, laborer 1
5518334 2510561 2510561 defendant Diconson Richard husbandman 589888 589888 Diconson, Richard, of Staynburn, husbandman 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);