names

25 rows where place_id = 612540

✎ 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
3693815 1924264 1924264 defendant Stone William husbandman 612540 612540 Stone, William, of Henbury, husbandman 0
3805099 1959536 1959536 defendant Welsheman William husbandman 612540 612540 Welsheman, William, of Henbury, husbandman 0
3820378 1964252 1964252 defendant Bondy Robert husbandman 612540 612540 Bondy, Robert, of Henbury, husbandman 0
3915705 1995628 1995628 defendant Eton Thomas husbandman 612540 612540 Eton, Thomas, of Henbury, husbandman 0
3917204 1996115 1996115 defendant Wedon Edmund husbandman 612540 612540 Wedon, Edmund, of Henbury, husbandman 0
3917206 1996115 1996115 defendant Wasshebare John husbandman 612540 612540 Wasshebare, John, of Henbury, husbandman 2
3917207 1996115 1996115 defendant Wass- William husbandman 612540 612540 Wass-, William, of Henbury, husbandman 3
3917208 1996115 1996115 defendant Samson William husbandman 612540 612540 Samson, William, of Henbury, husbandman 4
3917209 1996115 1996115 defendant Wele William husbandman 612540 612540 Wele, William, of Henbury, husbandman 5
3917210 1996115 1996115 defendant Wesley John husbandman 612540 612540 Wesley, John, of Henbury, husbandman 6
3931203 2000726 2000726 plaintiff Davenport John esq 612540 612540 Davenport, John, of Henbury, esq 0
3984517 2019219 2019219 defendant Jones alias Jeyne Evan husbandman 612540 612540 Jones alias Jeyne, Evan, of Henbury, husbandman 0
4108469 2063284 2063284 defendant Hort Richard yeoman 612540 612540 Hort, Richard, of Henbury, yeoman 1
4207070 2098018 2098018 defendant Horte Richard husbandman 612540 612540 Horte, Richard, of Henbury, husbandman 1
4219997 2102496 2102496 defendant Darbye William yeoman 612540 612540 Darbye, William, of Henbury, yeoman 2
4232294 2106801 2106801 defendant Horte Thomas husbandman 612540 612540 Horte, Thomas, of Henbury, husbandman 0
4249980 2112973 2112973 defendant Horte Thomas husbandman 612540 612540 Horte, Thomas, of Henbury, husbandman 0
4295835 2128604 2128604 defendant Davenport William   612540 612540 Davenport, William, of Henbury, or of Gewyte, Cheshire, gent, son of Randolph 0
4371676 2154927 2154927 defendant Morton Thomas gent 612540 612540 Morton, Thomas, of Henbury, gent 0
4410314 2168046 2168046 defendant Dyer Thomas yeoman 612540 612540 Dyer, Thomas, of Henbury, yeoman 0
5058840 2374209 2374209 defendant Bamfeld or Bainfeld Thomas gent 612540 612540 Bamfeld or Bainfeld, Thomas, of Henbury, gent 0
5279044 2438980 2438980 defendant Hamond Robert husbandman 612540 612540 Hamond, Robert, of Henbury, husbandman 1
5503152 2505898 2505898 defendant Horewell John chaplain 612540 612540 Horewell, John, of Henbury, chaplain 0
5503159 2505898 2505898 defendant Mattoke Thomas husbandman 612540 612540 Mattoke, Thomas, of Henbury, husbandman 7
5503161 2505898 2505898 defendant Harper John husbandman 612540 612540 Harper, John, of Henbury, husbandman 9

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);