names

30 rows where place_id = 615705

✎ 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
3710308 1929540 1929540 defendant Sparowe George husbandman 615705 615705 Sparowe, George, of Chigwell, Essex, husbandman 3
3710314 1929541 1929541 defendant Sparowe George husbandman 615705 615705 Sparowe, George, of Chigwell, Essex, husbandman 3
3909955 1993635 1993635 defendant Sparrowe George husbandman 615705 615705 Sparrowe, George, of Chigwell, Essex, husbandman 0
3944544 2005192 2005192 defendant Huttoft Anne widow 615705 615705 Huttoft, Anne, of Chigwell, Essex, widow 1
3947584 2006218 2006218 defendant Losell Mathew gent 615705 615705 Losell, Mathew, of Chigwell, Essex, gent 0
3947723 2006265 2006265 defendant Lawsell Mathew yeoman 615705 615705 Lawsell, Mathew, of Chigwell, Essex, yeoman 0
3947725 2006266 2006266 defendant Lawsell Mathew yeoman 615705 615705 Lawsell, Mathew, of Chigwell, Essex, yeoman 0
3947727 2006267 2006267 defendant Lawsell Mathew yeoman 615705 615705 Lawsell, Mathew, of Chigwell, Essex, yeoman 0
3947729 2006268 2006268 defendant Lawsell Mathew yeoman 615705 615705 Lawsell, Mathew, of Chigwell, Essex, yeoman 0
3985351 2019519 2019519 defendant Grene Chad yeoman 615705 615705 Grene, Chad, of Chigwell, Essex, yeoman 0
3985354 2019520 2019520 defendant Hill Nicholas yeoman 615705 615705 Hill, Nicholas, of Chigwell, Essex, yeoman 0
4149282 2077875 2077875 defendant Dawg John husbandman 615705 615705 Dawg, John, of Chigwell, Essex, husbandman 0
4213032 2100082 2100082 defendant Fuller John husbandman 615705 615705 Fuller, John, of Chigwell, Essex, husbandman 3
4294109 2127972 2127972 defendant Dawes Robert yeoman 615705 615705 Dawes, Robert, of Chigwell, Essex, yeoman 3
4338539 2143231 2143231 defendant Stannart John husbandman 615705 615705 Stannart, John, of Chigwell, Essex, husbandman 0
4343340 2144943 2144943 defendant Spackman Robert yeoman 615705 615705 Spackman, Robert, of Chigwell, Essex, yeoman 0
4361836 2151395 2151395 defendant Stannart John husbandman 615705 615705 Stannart, John, of Chigwell, Essex, husbandman 0
4377816 2157136 2157136 defendant Collsill Mary widow 615705 615705 Collsill, Mary, of Chigwell, Essex, widow 1
4852141 2312099 2312099 defendant Wrytele Eleanor widow 615705 615705 Wrytele, Eleanor, of Chigwell, Essex, widow 1
4929479 2335638 2335638 defendant Banbury Thomas husbandman 615705 615705 Banbury, Thomas, of Chigwell, Essex, husbandman 0
5155036 2402627 2402627 defendant Barker Richard husbandman 615705 615705 Barker, Richard, of Chigwell, Essex, husbandman 2
5155038 2402627 2402627 defendant Robynson William husbandman 615705 615705 Robynson, William, of Chigwell, Essex, husbandman 4
5171830 2407479 2407479 defendant Barker Richard husbandman 615705 615705 Barker, Richard, of Chigwell, Essex, husbandman 2
5190222 2412880 2412880 defendant Robynson William husbandman 615705 615705 Robynson, William, of Chigwell, Essex, husbandman 0
5190580 2412990 2412990 defendant Barker Richard husbandman 615705 615705 Barker, Richard, of Chigwell, Essex, husbandman 2
5190582 2412990 2412990 defendant Robynson William husbandman 615705 615705 Robynson, William, of Chigwell, Essex, husbandman 4
5190590 2412992 2412992 defendant Barker Richard husbandman 615705 615705 Barker, Richard, of Chigwell, Essex, husbandman 2
5315560 2449720 2449720 defendant Rote John husbandman 615705 615705 Rote, John, of Chigwell, Essex, husbandman 0
5360895 2463435 2463435 defendant Rolffe Richard (legal representative) 615705 615705 Rolffe, Richard, of Chigwell, Essex, smith, executors of 3
5530792 2514149 2514149 defendant Sewall William gent 615705 615705 Sewall, William, of Chigwell, Essex, 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);