names

23 rows where place_id = 741298

✎ 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
4344631 2145400 2145400 defendant Johnson Henry yeoman 741298 741298 Johnson, Henry, of Ledsham, yeoman 5
4381671 2158551 2158551 defendant Burman Thomas husbandman 741298 741298 Burman, Thomas, of Ledsham, husbandman 6
4381672 2158551 2158551 defendant Arthington Robert husbandman 741298 741298 Arthington, Robert, of Ledsham, husbandman 7
4381673 2158551 2158551 defendant Wilburne John husbandman 741298 741298 Wilburne, John, of Ledsham, husbandman 8
4381674 2158551 2158551 defendant Hunter John husbandman 741298 741298 Hunter, John, of Ledsham, husbandman 9
4381675 2158551 2158551 defendant Gillyam Robert husbandman 741298 741298 Gillyam, Robert, of Ledsham, husbandman 10
4381676 2158551 2158551 defendant Belhouse William husbandman 741298 741298 Belhouse, William, of Ledsham, husbandman 11
4381677 2158551 2158551 defendant Wilburne Robert husbandman 741298 741298 Wilburne, Robert, of Ledsham, husbandman 12
4381678 2158551 2158551 defendant Johnson Thomas husbandman 741298 741298 Johnson, Thomas, of Ledsham, husbandman 13
4381679 2158551 2158551 defendant Wilburne William husbandman 741298 741298 Wilburne, William, of Ledsham, husbandman 14
4381680 2158551 2158551 defendant Ashton Robert husbandman 741298 741298 Ashton, Robert, of Ledsham, husbandman 15
4381682 2158552 2158552 defendant Wilburne William husbandman 741298 741298 Wilburne, William, of Ledsham, husbandman 0
4381683 2158552 2158552 defendant Ashton James husbandman 741298 741298 Ashton, James, of Ledsham, husbandman 1
4381684 2158552 2158552 defendant Ashton Robert husbandman 741298 741298 Ashton, Robert, of Ledsham, husbandman 2
4381685 2158552 2158552 defendant Leake Robert husbandman 741298 741298 Leake, Robert, of Ledsham, husbandman 3
4381687 2158553 2158553 defendant Belhouse William husbandman 741298 741298 Belhouse, William, of Ledsham, husbandman 0
4381688 2158553 2158553 defendant Wilburne Robert husbandman 741298 741298 Wilburne, Robert, of Ledsham, husbandman 1
4381689 2158553 2158553 defendant Johnson Thomas husbandman 741298 741298 Johnson, Thomas, of Ledsham, husbandman 2
4381690 2158553 2158553 defendant Gilliam Robert husbandman 741298 741298 Gilliam, Robert, of Ledsham, husbandman 3
4381692 2158554 2158554 defendant Burman Thomas husbandman 741298 741298 Burman, Thomas, of Ledsham, husbandman 0
4381693 2158554 2158554 defendant Arthington Robert husbandman 741298 741298 Arthington, Robert, of Ledsham, husbandman 1
4381694 2158554 2158554 defendant Hunter John husbandman 741298 741298 Hunter, John, of Ledsham, husbandman 2
4381695 2158554 2158554 defendant Wilburne John husbandman 741298 741298 Wilburne, John, of Ledsham, 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);