names

27 rows where place_id = 586738

✎ 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
3589498 1864351 1864351 defendant Burman Richard husbandman 586738 586738 Burman, Richard, of Alston, husbandman 0
3686293 1921868 1921868 defendant Clerke Thomas mercer 586738 586738 Clerke, Thomas, of Alston, mercer 0
3724571 1933968 1933968 defendant Rede Henry tailor 586738 586738 Rede, Henry, of Alston, tailor 1
3888405 1986383 1986383 defendant Saunders alias Ferehere William husbandman 586738 586738 Saunders alias Ferehere, William, of Alston, husbandman 0
3893358 1988012 1988012 defendant Bacon John husbandman 586738 586738 Bacon, John, of Alston, husbandman 0
3893359 1988012 1988012 defendant Hay John husbandman 586738 586738 Hay, John, of Alston, husbandman 1
3893360 1988012 1988012 defendant Warde Geoffrey husbandman 586738 586738 Warde, Geoffrey, of Alston, husbandman 2
3893361 1988012 1988012 defendant Ryve Edward husbandman 586738 586738 Ryve, Edward, of Alston, husbandman 3
3893362 1988012 1988012 defendant Alcoke Thomas husbandman 586738 586738 Alcoke, Thomas, of Alston, husbandman 4
3902503 1991068 1991068 defendant Ferehere William husbandman 586738 586738 Ferehere, William, of Alston, husbandman 0
3907855 1992916 1992916 defendant Wellyns William drover 586738 586738 Wellyns, William, of Alston, drover 0
3912310 1994448 1994448 defendant Wellyns William drover 586738 586738 Wellyns, William, of Alston, drover 0
3912823 1994621 1994621 defendant Peers John yeoman 586738 586738 Peers, John, of Alston, yeoman 1
3930800 2000647 2000647 defendant Hilton Thomas gent 586738 586738 Hilton, Thomas, of Alston, gent 0
3992917 2022221 2022221 defendant Caldwall Richard yeoman 586738 586738 Caldwall, Richard, of Alston, yeoman 1
4333875 2141614 2141614 defendant Oxton Edward yeoman 586738 586738 Oxton, Edward, of Alston, yeoman 3
4617888 2236596 2236596 defendant Dautre William   586738 586738 Dautre, William, of Alston 1
4638660 2242843 2242843 defendant Derent Thomas   586738 586738 Derent, Thomas, of Alston 0
4729677 2274494 2274494 defendant Man John husbandman 586738 586738 Man, John, of Alston, husbandman 0
4805124 2297805 2297805 defendant Phelips alias White John husbandman 586738 586738 Phelips alias White, John, of Alston, husbandman 1
4893642 2324711 2324711 defendant Haukeswade Henry   586738 586738 Haukeswade, Henry, of Alston, wright 0
4893644 2324711 2324711 defendant Haukeswade John laborer 586738 586738 Haukeswade, John, of Alston, laborer 2
4902857 2327509 2327509 defendant Westlond William husbandman 586738 586738 Westlond, William, of Alston, husbandman 0
4902858 2327509 2327509 defendant Westlond John husbandman 586738 586738 Westlond, John, of Alston, husbandman 1
4966615 2346948 2346948 defendant Harryes John husbandman 586738 586738 Harryes, John, of Alston, husbandman 0
5086391 2382415 2382415 defendant Piers John husbandman 586738 586738 Piers, John, of Alston, husbandman 0
5521718 2511607 2511607 defendant Herbery Oliver husbandman 586738 586738 Herbery, Oliver, of Alston, 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);