names

13 rows where place_id = 607460

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3669363 1916355 1916355 defendant Wyllys John laborer 607460 607460 Wyllys, John, of Ryver, laborer 3
3806755 1960013 1960013 defendant Wrake George yeoman 607460 607460 Wrake, George, of Ryver, yeoman 0
3808885 1960658 1960658 defendant Yonge John miner 607460 607460 Yonge, John, of Ryver, miner 5
3808886 1960658 1960658 defendant Buntyng Ellen spinster 607460 607460 Buntyng, Ellen, of Ryver, spinster 6
3824904 1965668 1965668 plaintiff Wolcy William (legal representative) 607460 607460 Wolcy, William, of Ryver, executor of 0
3831226 1967654 1967654 defendant Yong John miner 607460 607460 Yong, John, of Ryver, miner 2
4687126 2261578 2261578 defendant Chapman John yeoman 607460 607460 Chapman, John, of Ryver, yeoman 0
4760541 2283648 2283648 defendant Cotcher alias Pylton John weaver 607460 607460 Cotcher alias Pylton, John, of Ryver, near Dover, weaver 0
5268913 2436018 2436018 defendant Rowebethum John husbandman 607460 607460 Rowebethum, John, of Ryver, husbandman 17
5268914 2436018 2436018 defendant Willer William husbandman 607460 607460 Willer, William, of Ryver, husbandman 18
5268915 2436018 2436018 defendant Cowehope Robert husbandman 607460 607460 Cowehope, Robert, of Ryver, husbandman 19
5435574 2485578 2485578 defendant Salter Robert husbandman 607460 607460 Salter, Robert, of Ryver or River, husbandman 1
5441090 2487246 2487246 defendant Salier Robert husbandman 607460 607460 Salier, Robert, of Ryver, 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);