names

33 rows where place_id = 630504

✎ 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
3794786 1956244 1956244 defendant Haldenby Richard gent 630504 630504 Haldenby, Richard, of Adlyngflete, gent 1
3927692 1999599 1999599 defendant Markham John husbandman 630504 630504 Markham, John, of Adlyngflete, husbandman 0
3927694 1999600 1999600 defendant Markham John husbandman 630504 630504 Markham, John, of Adlyngflete, husbandman 0
3981537 2018155 2018155 defendant Smythe Thomas fishmonger 630504 630504 Smythe, Thomas, of Adlyngflete, fishmonger 3
4018135 2031207 2031207 defendant Gunsonne Robert yeoman 630504 630504 Gunsonne, Robert, of Adlyngflete, yeoman 0
4280823 2123197 2123197 defendant Gypsey Robert husbandman 630504 630504 Gypsey, Robert, of Adlyngflete, husbandman 0
4598261 2230694 2230694 defendant Stokwyth Jacob   630504 630504 Stokwyth, Jacob, of Adlyngflete 0
4661459 2249413 2249413 defendant Hustewaite John gent 630504 630504 Hustewaite, John, of Adlyngflete, gent 0
4801099 2296534 2296534 defendant Russell John husbandman 630504 630504 Russell, John, of Adlyngflete, husbandman 0
4801100 2296534 2296534 defendant Alcoke Thomas husbandman 630504 630504 Alcoke, Thomas, of Adlyngflete, husbandman 1
4880172 2320711 2320711 plaintiff Warner Robert   630504 630504 Warner, Robert, of Adlyngflete 0
4927819 2335136 2335136 defendant Husthwayte William gent 630504 630504 Husthwayte, William, of Adlyngflete, gent 0
4927820 2335136 2335136 defendant Graunte John husbandman 630504 630504 Graunte, John, of Adlyngflete, husbandman 1
4927821 2335136 2335136 defendant Crosby Hugh husbandman 630504 630504 Crosby, Hugh, of Adlyngflete, husbandman 2
4927823 2335137 2335137 defendant Ufflete William gent 630504 630504 Ufflete, William, of Adlyngflete, gent 0
4927825 2335137 2335137 defendant Gaukeman William butcher 630504 630504 Gaukeman, William, of Adlyngflete, butcher 2
4970742 2348191 2348191 defendant Smyth John husbandman 630504 630504 Smyth, John, of Adlyngflete, husbandman 2
4974705 2349403 2349403 defendant Bradley Hugh smith 630504 630504 Bradley, Hugh, of Adlyngflete, smith 0
5050397 2371742 2371742 defendant Qwokman William butcher 630504 630504 Qwokman, William, of Adlyngflete, butcher 0
5057267 2373742 2373742 defendant Forster Robert yeoman 630504 630504 Forster, Robert, of Adlyngflete, yeoman 0
5058766 2374187 2374187 defendant Forster Robert yeoman 630504 630504 Forster, Robert, of Adlyngflete, yeoman 0
5069109 2377253 2377253 plaintiff Pyrle Richard (legal representative) 630504 630504 Pyrle, Richard, of Adlyngflete, executor of 0
5094056 2384657 2384657 defendant Cokeman William butcher 630504 630504 Cokeman, William, of Adlyngflete, butcher 1
5117571 2391572 2391572 defendant Fostere Robert yeoman 630504 630504 Fostere, Robert, of Adlyngflete, yeoman 0
5117576 2391574 2391574 defendant Fostere Robert yeoman 630504 630504 Fostere, Robert, of Adlyngflete, yeoman 0
5185156 2411404 2411404 defendant Forster Robert yeoman 630504 630504 Forster, Robert, of Adlyngflete, yeoman 1
5236292 2426203 2426203 defendant Baker Thomas husbandman 630504 630504 Baker, Thomas, of Adlyngflete, husbandman 0
5236293 2426203 2426203 defendant Baker Robert butcher 630504 630504 Baker, Robert, of Adlyngflete, butcher 1
5240071 2427296 2427296 defendant Baker Thomas husbandman 630504 630504 Baker, Thomas, of Adlyngflete, husbandman 0
5240072 2427296 2427296 defendant Baker Robert husbandman 630504 630504 Baker, Robert, of Adlyngflete, husbandman 1
5476463 2497962 2497962 defendant Alygode John husbandman 630504 630504 Alygode, John, of Adlyngflete, husbandman 0
5532913 2514835 2514835 defendant Marskham Hugh husbandman 630504 630504 Marskham, Hugh, of Adlyngflete, husbandman 1
5532914 2514835 2514835 defendant Pynder Robert husbandman 630504 630504 Pynder, Robert, of Adlyngflete, husbandman 2

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