names

16 rows where place_id = 612471

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3693460 1924167 1924167 defendant Hilder Thomas (legal representative) 612471 612471 Hilder, Thomas, of Kyngeston juxta Lewes, husbandman, executor of 0
3693461 1924167 1924167 defendant Hilder John yeoman 612471 612471 Hilder, John, of Kyngeston juxta Lewes, yeoman 1
3724049 1933806 1933806 defendant Austen William husbandman 612471 612471 Austen, William, of Kyngeston juxta Lewes, husbandman 0
3736350 1937611 1937611 defendant Wodde John husbandman 612471 612471 Wodde, John, of Kyngeston juxta Lewes, husbandman 0
3736351 1937611 1937611 defendant Bukholt John husbandman 612471 612471 Bukholt, John, of Kyngeston juxta Lewes, husbandman 1
3850355 1973700 1973700 defendant Waterman John husbandman 612471 612471 Waterman, John, of Kyngeston juxta Lewes, husbandman 0
3850356 1973700 1973700 defendant Peckeden Thomas husbandman 612471 612471 Peckeden, Thomas, of Kyngeston juxta Lewes, husbandman 1
4375579 2156322 2156322 defendant Towner John yeoman 612471 612471 Towner, John, of Kyngeston juxta lewes, yeoman 1
4855766 2313178 2313178 defendant Howell John husbandman 612471 612471 Howell, John, of Kyngeston juxta Lewes, husbandman 0
4855767 2313178 2313178 defendant Kyllesle Robert husbandman 612471 612471 Kyllesle, Robert, of Kyngeston juxta Lewes, husbandman 1
4855768 2313178 2313178 defendant Pycombe Robert husbandman 612471 612471 Pycombe, Robert, of Kyngeston juxta Lewes, husbandman 2
5312513 2448780 2448780 defendant Andrewe Roger clerk 612471 612471 Andrewe, Roger, of Kyngeston juxta Lewes, or of Hammessay, clerk 0
5312563 2448790 2448790 defendant Andrewe Roger clerk 612471 612471 Andrewe, Roger, of Kyngeston juxta Lewes, or of Hammessey, clerk 0
5312565 2448791 2448791 defendant Andrewe Roger clerk 612471 612471 Andrewe, Roger, of Kyngeston juxta Lewes, or of Hammessay, clerk 0
5317795 2450409 2450409 defendant Byshop John husbandman 612471 612471 Byshop, John, of Kyngeston juxta Lewes, husbandman 0
5534432 2515312 2515312 defendant Hylder Thomas husbandman 612471 612471 Hylder, Thomas, of Kyngeston juxta Lewes, 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);