names

52 rows where place_id = 604281

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657471 1912598 1912598 defendant Bremyngham   smith 604281 604281 Bremyngham, [vacat], of Warwickshire, smith 0
4452525 2185789 2185789 defendant Bartlemen Thomas chaplain 604281 604281 Bartlemen, Thomas, of Warwickshire, chaplain 0
4452527 2185790 2185790 defendant Bartelmen Thomas chaplain 604281 604281 Bartelmen, Thomas, of Warwickshire, chaplain 0
4453501 2186102 2186102 defendant Hore Thomas   604281 604281 Hore, Thomas, of Warwickshire 1
4453504 2186103 2186103 defendant Chore Thomas   604281 604281 Chore, Thomas, of Warwickshire 1
4491318 2197972 2197972 defendant Weston Richard   604281 604281 (Weston, Richard, of Warwickshire 1
4491322 2197973 2197973 defendant Weston Richard   604281 604281 (Weston, Richard, of Warwickshire 1
4498291 2200122 2200122 defendant Russell William   604281 604281 Russell, William, of Warwickshire 2
4512700 2204404 2204404 defendant Boule William   604281 604281 Boule, William, of Warwickshire 0
4512703 2204405 2204405 defendant Boule William   604281 604281 Boule, William, of Warwickshire 0
4523182 2207580 2207580 defendant Speneye Guy or Gideon esq 604281 604281 Speneye, Guy or Gideon, of Warwickshire, esq 0
4546219 2214762 2214762 defendant Baret John   604281 604281 Baret, John, of Warwickshire 4
4559858 2219034 2219034 defendant Brasebrigge Richard esq 604281 604281 Brasebrigge, Richard, of Warwickshire, esq 0
4569724 2222114 2222114 defendant Southam Thomas   604281 604281 Southam, Thomas, of Warwickshire 3
4574825 2223652 2223652 plaintiff Blaket John   604281 604281 Blaket, John, of Warwickshire, formerly sheriff 0
4580866 2225497 2225497 defendant Fremond Thomas   604281 604281 Fremond, Thomas, of Warwickshire 0
4580867 2225497 2225497 defendant Fremond John   604281 604281 Fremond, John, of Warwickshire 1
4580868 2225497 2225497 defendant Fremond Nicholas weaver 604281 604281 Fremond, Nicholas, of Warwickshire, weaver 2
4580870 2225498 2225498 defendant Fremond Thomas   604281 604281 Fremond, Thomas, of Warwickshire 0
4580871 2225498 2225498 defendant Fremond John   604281 604281 Fremond, John, of Warwickshire 1
4580872 2225498 2225498 defendant Fremond Nicholas weaver 604281 604281 Fremond, Nicholas, of Warwickshire, weaver 2
4591120 2228579 2228579 defendant Brasebrigge Ralph   604281 604281 Brasebrigge, Ralph, of Warwickshire, knight 0
4594130 2229427 2229427 defendant Brasbregge Ralph   604281 604281 Brasbregge, Ralph, of Warwickshire, knight 0
4594914 2229663 2229663 defendant Brasbregge Ralph   604281 604281 Brasbregge, Ralph, of Warwickshire, knight 0
4594916 2229664 2229664 defendant Brasebrigge Ralph   604281 604281 Brasebrigge, Ralph, of Warwickshire, knight 0
4594918 2229665 2229665 defendant Brasebrigge Ralph   604281 604281 Brasebrigge, Ralph, of Warwickshire, knight 0
4595341 2229794 2229794 defendant Clynton William esq 604281 604281 Clynton, William, of Warwickshire, esq 2
4595353 2229796 2229796 defendant Clynton William esq 604281 604281 Clynton, William, of Warwickshire, esq 2
4598112 2230659 2230659 defendant Acon Geoffrey   604281 604281 Acon, Geoffrey, of Warwickshire 2
4600395 2231349 2231349 defendant del Halle Hugh   604281 604281 del Halle, Hugh, of Warwickshire 4
4606099 2233022 2233022 defendant Bosevill William   604281 604281 Bosevill, William, of Warwickshire 1
4606106 2233023 2233023 defendant Bosevill William   604281 604281 Bosevill, William, of Warwickshire 1
4617240 2236403 2236403 defendant Archer Henry esq 604281 604281 Archer, Henry, of Warwickshire, esq 1
4617440 2236466 2236466 plaintiff Gower Thomas   604281 604281 Gower, Thomas, of Warwickshire 0
4619710 2237150 2237150 defendant More William   604281 604281 More, William, of Warwickshire 0
4629352 2240112 2240112 defendant Walsche Thomas   604281 604281 Walsche, Thomas, of Warwickshire 0
4630743 2240509 2240509 defendant Marchall Richard   604281 604281 Marchall, Richard, of Warwickshire 0
4631734 2240809 2240809 defendant Wybbe John   604281 604281 Wybbe, John, of Warwickshire 0
4631736 2240810 2240810 defendant Wybbe John   604281 604281 Wybbe, John, of Warwickshire 0
4640687 2243381 2243381 defendant Durant John   604281 604281 Durant, John, of Warwickshire 0
4640797 2243410 2243410 defendant Grene Thomas esq 604281 604281 Grene, Thomas, of Warwickshire, esq 1
4646656 2245086 2245086 defendant Clynton William   604281 604281 Clynton, William, of Warwickshire, knight, formerly esquire 0
4650427 2246144 2246144 defendant Barton William   604281 604281 Barton, William, of Warwickshire 2
4726863 2273669 2273669 plaintiff Harewell John esq 604281 604281 Harewell, John, of Warwickshire, esq 0
4746199 2279384 2279384 plaintiff Harewell John esq 604281 604281 Harewell, John, of Warwickshire, esq 0
5131187 2395612 2395612 plaintiff Fylongley Henry   604281 604281 Fylongley, Henry, of Warwickshire, sheriff 0
5133950 2396428 2396428 defendant Rathebon John carpenter 604281 604281 Rathebon, John, of Warwickshire, carpenter 0
5386177 2471110 2471110 defendant Mounford Simon   604281 604281 Mounford, Simon, of Warwickshire 1
5409261 2477737 2477737 plaintiff Beaufitz John   604281 604281 Beaufitz, John, of Warwickshire & Leicester, sheriff 0
5409828 2477906 2477906 defendant Porter Robert gent 604281 604281 Porter, Robert, of Warwickshire, gent 2
5613099 2547874 2547874 defendant Macy Robert   604281 604281 Macy, Robert, of Warwickshire, esquire 0
5629229 2553117 2553117 defendant Barbour John, junior   604281 604281 Barbour, John, junior, of Warwickshire 0

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