names

76 rows where place_id = 604056

✎ 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
3656699 1912347 1912347 defendant Wharff Thomas mercer 604056 604056 Wharff, Thomas, of Hornse, mercer 0
4500503 2200778 2200778 defendant Barker Thomas   604056 604056 Barker, Thomas, of Hornse 0
4518591 2206186 2206186 defendant Smyth Robert   604056 604056 Smyth, Robert, of Hornse 0
4536379 2211663 2211663 plaintiff St Quintin Anthony de   604056 604056 St Quintin, Anthony de, of Hornse, parson 0
4536382 2211664 2211664 plaintiff St Quintin Anthony de   604056 604056 St Quintin, Anthony de, of Hornse, parson of the church 0
4536679 2211750 2211750 defendant Lelle William   604056 604056 Lelle, William, of Hornse 0
4595968 2229991 2229991 defendant Vawesour John   604056 604056 Vawesour, John, of Hornse 0
4598767 2230846 2230846 plaintiff St Quintin Anthony de   604056 604056 St Quintin, Anthony de, of Hornse, parson 0
4603224 2232214 2232214 defendant Cle John   604056 604056 Cle, John, of Hornse 7
4605166 2232782 2232782 plaintiff Aony John   604056 604056 Aony, John, of Hornse 0
4606754 2233227 2233227 plaintiff Hardy John   604056 604056 Hardy, John, of Hornse, warden of the fabric of the church 1
4609175 2233974 2233974 plaintiff Broun Thomas   604056 604056 Broun, Thomas, of Hornse 0
4631938 2240872 2240872 defendant Smyth Thomas   604056 604056 Smyth, Thomas, of Hornse 0
4674179 2257532 2257532 plaintiff Doune John   604056 604056 Doune, John, of Hornse 0
4674181 2257533 2257533 plaintiff Doune John   604056 604056 Doune, John, of Hornse 0
4723708 2272720 2272720 plaintiff Doune or Donne John   604056 604056 Doune or Donne, John, of Hornse 0
4745046 2279064 2279064 defendant Batteman Robert husbandman 604056 604056 Batteman, Robert, of Hornse, husbandman 2
4750481 2280623 2280623 defendant Metham Robert gent 604056 604056 Metham, Robert, of Hornse, gent 0
4751772 2281009 2281009 plaintiff St Quentin Anthony de   604056 604056 St Quentin, Anthony de, of Hornse, parson 0
4776193 2288547 2288547 defendant St Quintin Anthony   604056 604056 St Quintin, Anthony, of Hornse, parson 3
4781834 2290334 2290334 defendant Skynner Robert skinner 604056 604056 Skynner, Robert, of Hornse, skinner 0
4786024 2291667 2291667 defendant Broune William tailor 604056 604056 Broune, William, of Hornse, tailor 8
4786026 2291667 2291667 defendant Bose William husbandman 604056 604056 Bose, William, of Hornse, husbandman 10
4807830 2298634 2298634 defendant Wryght John laborer 604056 604056 Wryght, John, of Hornse, laborer 0
4813236 2300254 2300254 defendant Milner Robert butcher 604056 604056 Milner, Robert, of Hornse, butcher 0
4815543 2300967 2300967 plaintiff Lay William   604056 604056 Lay, William, of Hornse, vicar 0
4821322 2302748 2302748 defendant Bladsmyth John   604056 604056 Bladsmyth, John, of Hornse, blade smith 0
4821391 2302774 2302774 defendant St Quinitin Anthony de   604056 604056 St Quinitin, Anthony de, of Hornse, parson 0
4822592 2303142 2303142 defendant Milnere Robert butcher 604056 604056 Milnere, Robert, of Hornse, butcher 0
4825812 2304110 2304110 defendant Chaumberleyn Thomas chaplain 604056 604056 Chaumberleyn, Thomas, of Hornse, chaplain 0
4850482 2311609 2311609 defendant Broun William tanner 604056 604056 Broun, William, of Hornse, tanner 0
4875268 2319217 2319217 defendant Lyndesey Robert yeoman 604056 604056 Lyndesey, Robert, of Hornse, yeoman 2
4875269 2319217 2319217 defendant Docheman John cordwainer 604056 604056 Docheman, John, of Hornse, cordwainer 3
4887685 2322977 2322977 defendant Milner Robert butcher 604056 604056 Milner, Robert, of Hornse, butcher 2
4900427 2326778 2326778 defendant Colynson William   604056 604056 Colynson, William, of Hornse 0
4900504 2326800 2326800 defendant Bette Agnes widow 604056 604056 Bette, Agnes, of Hornse, widow 1
4923626 2333824 2333824 defendant Theker John thatcher 604056 604056 Theker, John, of Hornse, thatcher 2
4926929 2334851 2334851 defendant Milner Robert butcher 604056 604056 Milner, Robert, of Hornse, butcher 0
4927321 2334976 2334976 defendant Metham John yeoman 604056 604056 Metham, John, of Hornse, yeoman 0
4935247 2337426 2337426 defendant Benet or Denet William weaver 604056 604056 Benet or Denet, William, of Hornse, weaver 1
4970597 2348147 2348147 plaintiff Herman William butcher 604056 604056 Herman, William, of Hornse, butcher 0
4970598 2348147 2348147 defendant Oweston Maud widow 604056 604056 Oweston, Maud, of Hornse, widow 0
4973171 2348909 2348909 defendant Milner John butcher 604056 604056 Milner, John, of Hornse, butcher 2
4973174 2348909 2348909 defendant Lyndesey Robert husbandman 604056 604056 Lyndesey, Robert, of Hornse, husbandman 5
4974525 2349344 2349344 defendant Broune William barker 604056 604056 Broune, William, of Hornse, barker 0
4974526 2349344 2349344 defendant Tele Reginald barber 604056 604056 Tele, Reginald, of Hornse, barber 1
4974530 2349345 2349345 defendant Clyfton William weaver 604056 604056 Clyfton, William, of Hornse, weaver 0
4990088 2353944 2353944 defendant Cutteler Richard shoemaker 604056 604056 Cutteler, Richard, of Hornse, shoemaker 2
5001214 2357236 2357236 defendant Conyngeston Henry chapman 604056 604056 Conyngeston, Henry, of Hornse, chapman 2
5001876 2357448 2357448 defendant Conyngston Henry chapman 604056 604056 Conyngston, Henry, of Hornse, chapman 3
5001877 2357448 2357448 defendant Outeswyk Maud widow 604056 604056 Outeswyk, Maud, of Hornse, widow 4
5064094 2375798 2375798 defendant Lekenfeld John miller 604056 604056 Lekenfeld, John, of Hornse, miller 0
5096142 2385311 2385311 defendant Conyngston Agnes widow 604056 604056 Conyngston, Agnes, of Hornse, widow 0
5096143 2385311 2385311 defendant Herman Peter husbandman 604056 604056 Herman, Peter, of Hornse, husbandman 1
5097077 2385577 2385577 defendant Metham John (legal representative) 604056 604056 Metham, John, of Hornse, executrix of 0
5097078 2385577 2385577 defendant Metham Isabel widow 604056 604056 Metham, Isabel, of Hornse, widow 1
5101274 2386781 2386781 defendant Conyngston or Covyngston Henry (legal representative) 604056 604056 Conyngston or Covyngston, Henry, of Hornse, executors of 4
5101275 2386781 2386781 defendant Hornby George husbandman 604056 604056 Hornby, George, of Hornse, husbandman 5
5114978 2390796 2390796 defendant Welburne Thomas smith 604056 604056 Welburne, Thomas, of Hornse, smith 4
5137532 2397491 2397491 defendant Cutler Richard chapman 604056 604056 Cutler, Richard, of Hornse, chapman 0
5137534 2397491 2397491 defendant Loveday William husbandman 604056 604056 Loveday, William, of Hornse, husbandman 2
5137535 2397491 2397491 defendant Weyngham John husbandman 604056 604056 Weyngham, John, of Hornse, husbandman 3
5158186 2403515 2403515 defendant Cutler Richard chapman 604056 604056 Cutler, Richard, of Hornse, chapman 0
5158188 2403515 2403515 defendant Loveday William husbandman 604056 604056 Loveday, William, of Hornse, husbandman 2
5158189 2403515 2403515 defendant Weyngham John husbandman 604056 604056 Weyngham, John, of Hornse, husbandman 3
5166914 2406050 2406050 defendant Milner John miller 604056 604056 Milner, John, of Hornse, miller 0
5166915 2406050 2406050 defendant Scot Peter weaver 604056 604056 Scot, Peter, of Hornse, weaver 1
5173859 2408052 2408052 defendant Cutler Richard chapman 604056 604056 Cutler, Richard, of Hornse, chapman 0
5173861 2408052 2408052 defendant Loveday William husbandman 604056 604056 Loveday, William, of Hornse, husbandman 2
5173862 2408052 2408052 defendant Weyngham John husbandman 604056 604056 Weyngham, John, of Hornse, husbandman 3
5194026 2413988 2413988 defendant Cutler Richard chapman 604056 604056 Cutler, Richard, of Hornse, chapman 0
5194028 2413988 2413988 defendant Loveday William husbandman 604056 604056 Loveday, William, of Hornse, husbandman 2
5194029 2413988 2413988 defendant Wyngham John husbandman 604056 604056 Wyngham, John, of Hornse, husbandman 3
5247563 2429443 2429443 defendant Wilson James husbandman 604056 604056 Wilson, James, of Hornse, husbandman 1
5247564 2429443 2429443 defendant Dugilby William miller 604056 604056 Dugilby, William, of Hornse, miller 2
5632051 2554046 2554046 defendant Wyngham William husbandman 604056 604056 Wyngham, William, of Hornse, husbandman 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);