names

22 rows where place_id = 586522

✎ 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
3588946 1864193 1864193 defendant Drawele Robert husbandman 586522 586522 Drawele, Robert, of Horsey, husbandman 7
3627789 1903550 1903550 defendant Whylter John husbandman 586522 586522 Whylter, John, of Horsey, husbandman 0
3752435 1942684 1942684 plaintiff Quylter William   586522 586522 Quylter, William, of Horsey 0
3752436 1942684 1942684 defendant Wrentham John husbandman 586522 586522 Wrentham, John, of Horsey, husbandman 0
3839546 1970293 1970293 defendant Wrentham John butcher 586522 586522 Wrentham, John, of Horsey, butcher 0
3959708 2010486 2010486 defendant Lownde John husbandman 586522 586522 Lownde, John, of Horsey, husbandman 0
3959709 2010486 2010486 defendant Kyng Edmund husbandman 586522 586522 Kyng, Edmund, of Horsey, husbandman 1
3959772 2010511 2010511 defendant Lownd John husbandman 586522 586522 Lownd, John, of Horsey, husbandman 0
3959773 2010511 2010511 defendant Kynge Edmund husbandman 586522 586522 Kynge, Edmund, of Horsey, husbandman 1
4075422 2051512 2051512 defendant Robinson John husbandman 586522 586522 Robinson, John, of Horsey, husbandman 1
4174324 2086481 2086481 defendant Elwyn John husbandman 586522 586522 (Elwyn, John, of Horsey, husbandman 4
4245317 2111414 2111414 defendant Chesse William, junior husbandman 586522 586522 Chesse, William, junior, of Horsey, husbandman 0
4245322 2111415 2111415 defendant Chesse William, junior husbandman 586522 586522 Chesse, William, junior, of Horsey, husbandman 0
4335095 2142010 2142010 defendant Lawnde George husbandman 586522 586522 Lawnde, George, of Horsey, husbandman 1
4335096 2142010 2142010 defendant Chesse William husbandman 586522 586522 Chesse, William, of Horsey, husbandman 2
4335097 2142010 2142010 defendant Skipp Anthony husbandman 586522 586522 Skipp, Anthony, of Horsey, husbandman 3
4348023 2146561 2146561 defendant Robynson John husbandman 586522 586522 Robynson, John, of Horsey, husbandman 0
4395498 2163077 2163077 defendant Robinson John husbandman 586522 586522 Robinson, John, of Horsey, husbandman 0
4395500 2163077 2163077 defendant Lawes Robert husbandman 586522 586522 Lawes, Robert, of Horsey, husbandman 2
5000411 2356988 2356988 defendant Dallyng Gilbert laborer 586522 586522 Dallyng, Gilbert, of Horsey, laborer 0
5021025 2363047 2363047 defendant Howelot William yeoman 586522 586522 Howelot, William, of Horsey, yeoman 2
5062288 2375282 2375282 defendant Drawale Richard yeoman 586522 586522 Drawale, Richard, of Horsey, yeoman 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);