names

19 rows where place_id = 614451

✎ 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
3703728 1927447 1927447 defendant Lambert Robert husbandman 614451 614451 Lambert, Robert, of Nethercote, husbandman 0
3737152 1937853 1937853 defendant Atkyns Nicholas husbandman 614451 614451 Atkyns, Nicholas, of Nethercote, husbandman 0
3908239 1993053 1993053 defendant Hochyns Richard husbandman 614451 614451 Hochyns, Richard, of Nethercote, husbandman 0
3908240 1993053 1993053 defendant Robertys John husbandman 614451 614451 Robertys, John, of Nethercote, husbandman 1
3908241 1993053 1993053 defendant Kene William husbandman 614451 614451 Kene, William, of Nethercote, husbandman 2
3908242 1993053 1993053 defendant Curteys Alexander husbandman 614451 614451 Curteys, Alexander, of Nethercote, husbandman 3
4010182 2028408 2028408 defendant Atkyns John husbandman 614451 614451 Atkyns, John, of Nethercote, husbandman 3
4424387 2172470 2172470 plaintiff Hynkeleye Roger de   614451 614451 Hynkeleye, Roger de, of Nethercote 0
4594683 2229589 2229589 defendant Somere Alexander   614451 614451 Somere, Alexander, of Nethercote 0
4604747 2232652 2232652 defendant Fermore John   614451 614451 togther with Fermore, John, of Nethercote 1
4610062 2234232 2234232 defendant Hogekyns Thomas   614451 614451 Hogekyns, Thomas, of Nethercote 0
4678324 2258829 2258829 defendant Ormont John ploughman 614451 614451 Ormont, John, of Nethercote, ploughman 0
4735175 2276148 2276148 defendant Cokkes Peter husbandman 614451 614451 Cokkes, Peter, of Nethercote, husbandman 1
4827654 2304698 2304698 defendant Wolf John husbandman 614451 614451 Wolf, John, of Nethercote, husbandman 0
4859560 2314361 2314361 defendant Ormond John husbandman 614451 614451 Ormond, John, of Nethercote, husbandman 0
5295580 2443696 2443696 defendant Makernes Richard yeoman 614451 614451 Makernes, Richard, of Nethercote, yeoman 3
5310316 2448116 2448116 defendant Makernes Richard yeoman 614451 614451 Makernes, Richard, of Nethercote, yeoman 3
5327573 2453320 2453320 defendant Makernes Richard yeoman 614451 614451 Makernes, Richard, of Nethercote, yeoman 3
5429023 2483601 2483601 defendant Payn Thomas husbandman 614451 614451 Payn, Thomas, of Nethercote, husbandman 1

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);