names

26 rows where place_id = 629086

✎ 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
3786207 1953480 1953480 defendant Atlynson William husbandman 629086 629086 Atlynson, William, of Catwyk, husbandman 0
4500675 2200828 2200828 defendant Veile Amandus   629086 629086 Veile, Amandus, of Catwyk 0
4646888 2245151 2245151 defendant Kirkeby Thomas   629086 629086 Kirkeby, Thomas, of Catwyk 2
4723710 2272721 2272721 plaintiff Doune John (legal representative) 629086 629086 Doune, John, of Catwyk, executor of 0
4723715 2272721 2272721 defendant Doune or Donne John   629086 629086 Doune or Donne, John, of Catwyk, husbandman, son of Stephen 3
4748082 2279950 2279950 defendant Hert Robert husbandman 629086 629086 Hert, Robert, of Catwyk, husbandman 2
4769914 2286562 2286562 defendant Otryngham John master & clerk 629086 629086 Otryngham, John, of Catwyk, master & clerk 0
4775845 2288446 2288446 defendant Kyrkby Thomas yeoman 629086 629086 Kyrkby, Thomas, of Catwyk, yeoman 0
4794685 2294475 2294475 defendant Otryngham John clerk 629086 629086 Otryngham, John, of Catwyk, clerk 1
4801780 2296739 2296739 defendant Kirkby Thomas yeoman 629086 629086 Kirkby, Thomas, of Catwyk, yeoman 0
4814939 2300782 2300782 defendant Pacok Alan   629086 629086 Pacok, Alan, of Catwyk 0
4821395 2302775 2302775 defendant Vele Robert husbandman 629086 629086 Vele, Robert, of Catwyk, husbandman 2
4851670 2311955 2311955 defendant Doune William husbandman 629086 629086 Doune, William, of Catwyk, husbandman 2
4854206 2312724 2312724 defendant Burton William miller 629086 629086 Burton, William, of Catwyk, miller 0
4918546 2332317 2332317 defendant Melton Thomas gent 629086 629086 Melton, Thomas, of Catwyk, gent 1
4947867 2341314 2341314 defendant Reme John   629086 629086 Reme, John, of Catwyk, cartwright 0
4966342 2346867 2346867 defendant Goldsmyth Stephen husbandman 629086 629086 Goldsmyth, Stephen, of Catwyk, husbandman 0
5048691 2371245 2371245 defendant Veel Thomas gent 629086 629086 Veel, Thomas, of Catwyk, gent 3
5048699 2371247 2371247 plaintiff Veel Thomas gent 629086 629086 Veel, Thomas, of Catwyk, gent 3
5057636 2373851 2373851 defendant Pacok Alan husbandman 629086 629086 Pacok, Alan, of Catwyk, husbandman 6
5198828 2415410 2415410 defendant Pecoke Alan husbandman 629086 629086 Pecoke, Alan, of Catwyk, husbandman 1
5231910 2424906 2424906 defendant Appilton John husbandman 629086 629086 Appilton, John, of Catwyk, husbandman 0
5231911 2424906 2424906 defendant Appilton Henry husbandman 629086 629086 Appilton, Henry, of Catwyk, husbandman 1
5231912 2424906 2424906 defendant Brankley Thomas husbandman 629086 629086 Brankley, Thomas, of Catwyk, husbandman 2
5251336 2430517 2430517 defendant Nevill Richard yeoman 629086 629086 Nevill, Richard, of Catwyk, yeoman 5
5301285 2445337 2445337 defendant Pecok William husbandman 629086 629086 Pecok, William, of Catwyk, husbandman 3

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