names

44 rows where place_id = 780326

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4667464 2255546 2255546 defendant Baxster Robert husbandman 780326 780326 Baxster, Robert, of Burgh in le Merssh, husbandman 0
4703720 2266541 2266541 defendant Westmels William husbandman 780326 780326 Westmels, William, of Burgh in le Merssh, husbandman 0
4855614 2313122 2313122 defendant Carter William   780326 780326 Carter, William, of Burgh in le Merssh, servant 0
4864394 2315843 2315843 defendant Helwys John husbandman 780326 780326 Helwys, John, of Burgh in le Merssh, husbandman 1
4957612 2344249 2344249 defendant Massyngberd Robert husbandman 780326 780326 Massyngberd, Robert, of Burgh in le Merssh, husbandman 1
4967020 2347069 2347069 defendant Massyngberd Robert yeoman 780326 780326 Massyngberd, Robert, of Burgh in le Merssh, yeoman 0
4976838 2350024 2350024 defendant Tutte John husbandman 780326 780326 Tutte, John, of Burgh in le Merssh, husbandman 1
4976839 2350024 2350024 defendant Tutte William husbandman 780326 780326 Tutte, William, of Burgh in le Merssh, husbandman 2
4981869 2351498 2351498 defendant Hamond Alexander butcher 780326 780326 Hamond, Alexander, of Burgh in le Merssh, butcher 0
4984061 2352165 2352165 defendant Massyngberd Robert husbandman 780326 780326 Massyngberd, Robert, of Burgh in le Merssh, husbandman 0
5020532 2362893 2362893 defendant Massyngberd Robert yeoman 780326 780326 Massyngberd, Robert, of Burgh in le Merssh, yeoman 0
5022611 2363519 2363519 defendant Depdale John husbandman 780326 780326 Depdale, John, of Burgh in le Merssh, husbandman 0
5023130 2363667 2363667 defendant Whaytecroft Thomas husbandman 780326 780326 Whaytecroft, Thomas, of Burgh in le Merssh, husbandman 0
5023131 2363667 2363667 defendant Massyngberd Robert husbandman 780326 780326 Massyngberd, Robert, of Burgh in le Merssh, husbandman 1
5023132 2363667 2363667 defendant atte Halle John   780326 780326 atte Halle, John, of Burgh in le Merssh, court holder 2
5027041 2364779 2364779 defendant Fulnetby Hugh gent 780326 780326 Fulnetby, Hugh, of Burgh in Le Merssh, gent 0
5027042 2364779 2364779 defendant Byllesby John gent 780326 780326 Byllesby, John, of Burgh in Le Merssh, gent 1
5027043 2364779 2364779 defendant Hamond Alexander butcher 780326 780326 together with Hamond, Alexander, of Burgh in Le Merssh, butcher 2
5032994 2366539 2366539 defendant Massyngberd Robert, junior yeoman 780326 780326 Massyngberd, Robert, junior, of Burgh in le Merssh, yeoman 0
5034135 2366849 2366849 defendant atte Halle alias Wylcokson John jhusbandman 780326 780326 atte Halle alias Wylcokson, John, of Burgh in le Merssh, jhusbandman 0
5038192 2368057 2368057 defendant Massyngberd Robert gent 780326 780326 Massyngberd, Robert, of Burgh in le Merssh, gent 0
5058058 2373978 2373978 defendant Newedyk Richard yeoman 780326 780326 Newedyk, Richard, of Burgh in le Merssh, yeoman 0
5058059 2373978 2373978 defendant Carter John, senior husbandman 780326 780326 Carter, John, senior, of Burgh in le Merssh, husbandman 1
5059613 2374444 2374444 defendant Coweton William husbandman 780326 780326 Coweton, William, of Burgh in le Merssh, husbandman 2
5059675 2374457 2374457 defendant Newedyk Richard yeoman 780326 780326 Newedyk, Richard, of Burgh in le Merssh, yeoman 0
5072738 2378330 2378330 defendant Carter John, senior husbandman 780326 780326 Carter, John, senior, of Burgh in le Merssh, husbandman 0
5081404 2380943 2380943 defendant Newedyk Richard husbandman 780326 780326 Newedyk, Richard, of Burgh in le Merssh, husbandman 1
5101151 2386750 2386750 plaintiff Arnowe William   780326 780326 Arnowe, William, of Burgh in le Merssh 0
5101153 2386750 2386750 defendant Masyngnerde Robert husbandman 780326 780326 Masyngnerde, Robert, of Burgh in le Merssh, husbandman 1
5103316 2387400 2387400 defendant Beveregge Robert laborer 780326 780326 Beveregge, Robert, of Burgh in le Merssh, laborer 2
5109136 2389094 2389094 defendant Gowke William husbandman 780326 780326 Gowke, William, of Burgh in le Merssh, husbandman 5
5216102 2420440 2420440 defendant Newedyk Richard husbandman 780326 780326 Newedyk, Richard, of Burgh in le Merssh, husbandman 1
5218002 2420999 2420999 defendant Fysshe Thomas   780326 780326 Fysshe, Thomas, of Burgh in le Merssh, wright 0
5219074 2421309 2421309 defendant Arnowe William husbandman 780326 780326 Arnowe, William, of Burgh in le Merssh, husbandman 5
5219092 2421311 2421311 defendant Hamond Alexander butcher 780326 780326 Hamond, Alexander, of Burgh in le Merssh, butcher 1
5219529 2421441 2421441 defendant Clare John husbandman 780326 780326 Clare, John, of Burgh in le Merssh, husbandman 0
5236129 2426151 2426151 defendant Bekyngham Henry husbandman 780326 780326 Bekyngham, Henry, of Burgh in le Merssh, husbandman 3
5261724 2433776 2433776 defendant Stokton Richard husbandman 780326 780326 Stokton, Richard, of Burgh in le Merssh, husbandman 0
5261963 2433850 2433850 defendant Doughty Richard husbandman 780326 780326 Doughty, Richard, of Burgh in le Merssh, husbandman 0
5285115 2440671 2440671 defendant Carter John courser 780326 780326 Carter, John, of Burgh in le Merssh, courser 0
5285116 2440671 2440671 defendant Broun Hugh husbandman 780326 780326 Broun, Hugh, of Burgh in le Merssh, husbandman 1
5313368 2449038 2449038 defendant Hamond John butcher 780326 780326 Hamond, John, of Burgh in le Merssh, butcher 0
5347981 2459509 2459509 defendant Wyter John husbandman 780326 780326 Wyter, John, of Burgh in le Merssh, husbandman 0
5348366 2459632 2459632 defendant Cheyles Simon fuller 780326 780326 Cheyles, Simon, of Burgh in le Merssh, fuller 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);