names

12 rows where place_id = 600642

✎ 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
3641893 1907918 1907918 defendant Archer John baker 600642 600642 Archer, John, of Okam, baker 1
3695223 1924724 1924724 plaintiff Plavys William brasier 600642 600642 Plavys, William, of Okam, brasier 0
4015248 2030146 2030146 plaintiff Smyth Clement gent 600642 600642 Smyth, Clement, of Okam, gent 0
4015250 2030147 2030147 plaintiff Smyth Clement gent 600642 600642 Smyth, Clement, of Okam, gent 0
4690807 2262660 2262660 plaintiff Flore Roger   600642 600642 Flore, Roger, of Okam 3
4690817 2262661 2262661 plaintiff Flore Roger   600642 600642 Flore, Roger, of Okam 3
5383995 2470510 2470510 defendant Lyre John clerk 600642 600642 Lyre, John, of Okam, clerk 0
5504746 2506403 2506403 defendant Harryson Richard yeoman 600642 600642 Harryson, Richard, of Okam, yeoman 0
5504747 2506403 2506403 defendant Perte William yeoman 600642 600642 Perte, William, of Okam, yeoman 1
5570079 2525824 2525824 defendant Blakeburne William husbandman 600642 600642 Blakeburne, William, of Okam, husbandman 0
5623559 2551303 2551303 defendant Swet Roger husbandman 600642 600642 Swet, Roger, of Okam, husbandman 0
5623560 2551303 2551303 defendant Plummer Richard plumber 600642 600642 Plummer, Richard, of Okam, plumber 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);