names

16 rows where place_id = 756540

✎ 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
4438582 2181357 2181357 defendant Rokeby Peter   756540 756540 Rokeby, Peter, of Creek 1
4442490 2182599 2182599 plaintiff Bukyngham Henry   756540 756540 Bukyngham, Henry, of Creek, on his own account 0
4442491 2182599 2182599 defendant Rokeby Peter   756540 756540 Rokeby, Peter, of Creek 0
4496164 2199476 2199476 defendant Rokeby Richard   756540 756540 Rokeby, Richard, of Creek 0
4496167 2199477 2199477 defendant Turnour William   756540 756540 Turnour, William, of Creek 0
4603786 2232367 2232367 defendant Vynter Thomas   756540 756540 Vynter, Thomas, of Creek 2
4625947 2239069 2239069 plaintiff Piers Walter   756540 756540 Piers, Walter, of Creek, parson 0
4684641 2260795 2260795 defendant Hanynton John husbandman 756540 756540 Hanynton, John, of Creek, husbandman 0
4725722 2273333 2273333 defendant Rokeby Richard husbandman 756540 756540 Rokeby, Richard, of Creek, husbandman 0
4877963 2320061 2320061 defendant Brydbury Thomas husbandman 756540 756540 Brydbury, Thomas, of Creek, husbandman 0
4920641 2332971 2332971 defendant Robart Robert husbandman 756540 756540 Robart, Robert, of Creek, husbandman 1
5023339 2363732 2363732 defendant Bowyer William husbandman 756540 756540 Bowyer, William, of Creek, husbandman 4
5249559 2429987 2429987 defendant Dunkele Henry yeoman 756540 756540 Dunkele, Henry, of Creek, yeoman 0
5284215 2440403 2440403 defendant Williams Richard husbandman 756540 756540 Williams, Richard, of Creek, husbandman 0
5284217 2440404 2440404 defendant Williams Richard husbandman 756540 756540 Williams, Richard, of Creek, husbandman 0
5612282 2547586 2547586 defendant Rokeby Peter de   756540 756540 Rokeby, Peter de, of Creek 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);