names

27 rows where place_id = 624811

✎ 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
3760439 1945268 1945268 defendant Bruster William yeoman 624811 624811 Bruster, William, of Asfordby, yeoman 0
3900012 1990222 1990222 defendant Brokysby Richard clerk 624811 624811 Brokysby, Richard, of Asfordby, clerk 0
4455633 2186772 2186772 defendant Bedyngton John de   624811 624811 Bedyngton, John de, of Asfordby 0
4533426 2210724 2210724 defendant Lokyngton William de   624811 624811 Lokyngton, William de, of Asfordby 0
4569747 2222122 2222122 defendant Asfordby William   624811 624811 Asfordby, William, of Asfordby 1
4585600 2226920 2226920 defendant Kirkeby Thomas   624811 624811 Kirkeby, Thomas, of Asfordby 0
4734500 2275957 2275957 defendant Pratte Richard yeoman 624811 624811 Pratte, Richard, of Asfordby, yeoman 2
4734501 2275957 2275957 defendant Bynnyngton Thomas husbandman 624811 624811 Bynnyngton, Thomas, of Asfordby, husbandman 3
4777544 2288972 2288972 defendant Gybons Thomas husbandman 624811 624811 Gybons, Thomas, of Asfordby, husbandman 0
4777545 2288972 2288972 defendant Halle Robert husbandman 624811 624811 Halle, Robert, of Asfordby, husbandman 1
4777546 2288972 2288972 defendant Shelde John weaver 624811 624811 Shelde, John, of Asfordby, weaver 2
4804633 2297643 2297643 plaintiff Bosse Thomas   624811 624811 Bosse, Thomas, of Asfordby 0
4908387 2329178 2329178 defendant Swyne John husbandman 624811 624811 Swyne, John, of Asfordby, husbandman 0
4909648 2329547 2329547 defendant Wyllughby William gent 624811 624811 Wyllughby, William, of Asfordby, gent 0
4915970 2331492 2331492 defendant Wyllughby William gent 624811 624811 Wyllughby, William, of Asfordby, gent 0
4932467 2336550 2336550 defendant Willughby William gent 624811 624811 Willughby, William, of Asfordby, gent 0
4934913 2337322 2337322 defendant Dygby John yeoman 624811 624811 Dygby, John, of Asfordby, yeoman 0
4987276 2353144 2353144 defendant Carter Thomas husbandman 624811 624811 Carter, Thomas, of Asfordby, husbandman 3
5042286 2369297 2369297 defendant Barker William husbandman 624811 624811 Barker, William, of Asfordby, husbandman 0
5134317 2396534 2396534 defendant Tayllour John husbandman 624811 624811 Tayllour, John, of Asfordby, husbandman 0
5134318 2396534 2396534 defendant Taylour Thomas husbandman 624811 624811 Taylour, Thomas, of Asfordby, husbandman 1
5154082 2402352 2402352 defendant Tayllour John husbandman 624811 624811 Tayllour, John, of Asfordby, husbandman 0
5154083 2402352 2402352 defendant Taylour Thomas husbandman 624811 624811 Taylour, Thomas, of Asfordby, husbandman 1
5411013 2478249 2478249 defendant Barnes Richard gent 624811 624811 Barnes, Richard, of Asfordby, gent 0
5456441 2491848 2491848 defendant Barnes Richard gent 624811 624811 Barnes, Richard, of Asfordby, gent 0
5637048 2555536 2555536 defendant Mory William husbandman 624811 624811 Mory, William, of Asfordby, husbandman 2
5637049 2555536 2555536 defendant Alwyne Ralph husbandman 624811 624811 Alwyne, Ralph, of Asfordby, 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);