names

17 rows where place_id = 618809

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3726514 1934557 1934557 defendant Robynson John   618809 618809 Robynson, John, of Styxwold 1
3726537 1934557 1934557 defendant Pye John husbandman 618809 618809 Pye, John, of Styxwold, husbandman 24
3771807 1948881 1948881 defendant Robynson John clerk 618809 618809 Robynson, John, of Styxwold, clerk 1
3771809 1948881 1948881 defendant Swyne William husbandman 618809 618809 Swyne, William, of Styxwold, husbandman 3
3771810 1948881 1948881 defendant Cramlynton Anthony husbandman 618809 618809 Cramlynton, Anthony, of Styxwold, husbandman 4
3771811 1948881 1948881 defendant Sage John husbandman 618809 618809 Sage, John, of Styxwold, husbandman 5
3771812 1948881 1948881 defendant Robynson Thomas husbandman 618809 618809 Robynson, Thomas, of Styxwold, husbandman 6
3771813 1948881 1948881 defendant Wylson George husbandman 618809 618809 Wylson, George, of Styxwold, husbandman 7
3771814 1948881 1948881 defendant Bawdewyn Thomas husbandman 618809 618809 Bawdewyn, Thomas, of Styxwold, husbandman 8
3888327 1986359 1986359 defendant Wilson James yeoman 618809 618809 Wilson, James, of Styxwold, yeoman 0
3907187 1992695 1992695 defendant Wylson James yeoman 618809 618809 Wylson, James, of Styxwold, yeoman 2
4006257 2027016 2027016 defendant Kylbeck Christopher yeoman 618809 618809 Kylbeck, Christopher, of Styxwold, yeoman 0
4025453 2033764 2033764 defendant Hodshon Anthony laborer 618809 618809 Hodshon, Anthony, of Styxwold, laborer 0
5576515 2527703 2527703 defendant Dey William husbandman 618809 618809 Dey, William, of Styxwold, husbandman 0
5576516 2527703 2527703 defendant Chapman John husbandman 618809 618809 Chapman, John, of Styxwold, husbandman 1
5576517 2527703 2527703 defendant Gray Christopher husbandman 618809 618809 Gray, Christopher, of Styxwold, husbandman 2
5576524 2527705 2527705 defendant Aveson Alexander clerk 618809 618809 Aveson, Alexander, of Styxwold, clerk 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);