names

15 rows where place_id = 604667

✎ 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
3658851 1913024 1913024 plaintiff Mody John husbandman 604667 604667 Mody, John, of Drynghowe, husbandman 4
4767746 2285890 2285890 defendant Rese Robert husbandman 604667 604667 Rese, Robert, of Drynghowe, husbandman 4
4792124 2293636 2293636 defendant Rose Robert husbandman 604667 604667 Rose, Robert, of Drynghowe, husbandman 4
4948766 2341595 2341595 defendant Crosse William husbandman 604667 604667 Crosse, William, of Drynghowe, husbandman 1
5135420 2396870 2396870 defendant Carter John husbandman 604667 604667 Carter, John, of Drynghowe, husbandman 0
5155661 2402814 2402814 defendant Carter Joan widow 604667 604667 (Carter, Joan, of Drynghowe, widow 1
5155662 2402814 2402814 defendant Carter John husbandman 604667 604667 Carter, John, of Drynghowe, husbandman 2
5172190 2407589 2407589 defendant Carter John widow 604667 604667 (Carter, John, of Drynghowe, widow 1
5172191 2407589 2407589 defendant Carter Joan husbandman 604667 604667 Carter, Joan, of Drynghowe, husbandman 2
5191411 2413228 2413228 defendant Carter Joan widow 604667 604667 (Carter, Joan, of Drynghowe, widow 1
5191412 2413228 2413228 defendant Carter John husbandman 604667 604667 Carter, John, of Drynghowe, husbandman 2
5470693 2496155 2496155 defendant Symondeson John husbandman 604667 604667 Symondeson, John, of Drynghowe, husbandman 0
5470694 2496155 2496155 defendant Scanceby Thomas husbandman 604667 604667 Scanceby, Thomas, of Drynghowe, husbandman 1
5482027 2499554 2499554 defendant Symondson John husbandman 604667 604667 Symondson, John, of Drynghowe, husbandman 0
5482028 2499554 2499554 defendant Stanceby Thomas husbandman 604667 604667 Stanceby, Thomas, of Drynghowe, husbandman 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);