names

32 rows where place_id = 587026

✎ 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
3590285 1864606 1864606 defendant Archer Edmund husbandman 587026 587026 Archer, Edmund, of Goldale, husbandman 0
3704943 1927838 1927838 defendant Evers Lionel gent 587026 587026 Evers, Lionel, of Goldale, gent 0
4530006 2209674 2209674 defendant Broun William   587026 587026 Broun, William, of Goldale 1
4534717 2211134 2211134 defendant Broune William   587026 587026 Broune, William, of Goldale 0
4560438 2219205 2219205 defendant Broune William   587026 587026 Broune, William, of Goldale 0
4580083 2225259 2225259 defendant Broune William   587026 587026 Broune, William, of Goldale 0
4690230 2262501 2262501 defendant Storre Thomas husbandman 587026 587026 Storre, Thomas, of Goldale, husbandman 0
4733818 2275756 2275756 defendant Broun William husbandman 587026 587026 Broun, William, of Goldale, husbandman 0
4854570 2312812 2312812 defendant Goldale John   587026 587026 Goldale, John, of Goldale 0
4854582 2312814 2312814 defendant Sclater William husbandman 587026 587026 Sclater, William, of Goldale, husbandman 0
4854583 2312814 2312814 defendant Lawe Thomas husbandman 587026 587026 Lawe, Thomas, of Goldale, husbandman 1
4854584 2312814 2312814 defendant Nicoll William husbandman 587026 587026 Nicoll, William, of Goldale, husbandman 2
4854585 2312814 2312814 defendant Estoft John husbandman 587026 587026 Estoft, John, of Goldale, husbandman 3
4854586 2312814 2312814 defendant Mollyng John husbandman 587026 587026 Mollyng, John, of Goldale, husbandman 4
4928962 2335484 2335484 defendant Yole John carpenter 587026 587026 Yole, John, of Goldale, carpenter 2
4973874 2349146 2349146 defendant Nicoll John, senior husbandman 587026 587026 Nicoll, John, senior, of Goldale, husbandman 0
4975565 2349647 2349647 defendant Estofte John husbandman 587026 587026 Estofte, John, of Goldale, husbandman 2
4975566 2349647 2349647 defendant Estofte Thomas laborer 587026 587026 Estofte, Thomas, of Goldale, laborer 3
5010067 2359813 2359813 defendant Balderston John husbandman 587026 587026 Balderston, John, of Goldale, husbandman 0
5010069 2359814 2359814 defendant Herryson Richard laborer 587026 587026 Herryson, Richard, of Goldale, laborer 0
5010070 2359814 2359814 defendant Coke John husbandman 587026 587026 Coke, John, of Goldale, husbandman 1
5010071 2359814 2359814 defendant Rowhall John de laborer 587026 587026 Rowhall, John de, of Goldale, laborer 2
5010080 2359815 2359815 defendant Herryson Thomas husbandman 587026 587026 Herryson, Thomas, of Goldale, husbandman 0
5029676 2365549 2365549 defendant Boldyrston John yeoman 587026 587026 Boldyrston, John, of Goldale, yeoman 0
5113246 2390269 2390269 defendant Balderdon John husbandman 587026 587026 Balderdon, John, of Goldale, husbandman 1
5315815 2449801 2449801 defendant Harryson Richard husbandman 587026 587026 Harryson, Richard, of Goldale, husbandman 8
5315816 2449801 2449801 defendant Kereby William husbandman 587026 587026 Kereby, William, of Goldale, husbandman 9
5333115 2454974 2454974 defendant Harryson Richard husbandman 587026 587026 Harryson, Richard, of Goldale, husbandman 6
5333116 2454974 2454974 defendant Kereby William husbandman 587026 587026 Kereby, William, of Goldale, husbandman 7
5437882 2486264 2486264 defendant Waldyng Richard fisher 587026 587026 Waldyng, Richard, of Goldale, fisher 0
5437883 2486264 2486264 defendant Wyndilok Thomas yeoman 587026 587026 Wyndilok, Thomas, of Goldale, yeoman 1
5595255 2533466 2533466 defendant Evers Lionel gent 587026 587026 Evers, Lionel, of Goldale, gent 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);