names

33 rows where place_id = 763615

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4498815 2200263 2200263 defendant Cutrote Richard   763615 763615 Cutrote, Richard, of Storteford, Herts 0
4641874 2243730 2243730 defendant Kere Thomas   763615 763615 Kere, Thomas, of Storteford, Herts 0
4650257 2246096 2246096 defendant Kere Thomas   763615 763615 Kere, Thomas, of Storteford, Herts 0
4686529 2261394 2261394 defendant Kere Thomas yeoman 763615 763615 Kere, Thomas, of Storteford, Herts, yeoman 1
4696049 2264251 2264251 defendant Salesbury John   763615 763615 Salesbury, John, of Storteford, Herts, parson 0
4696057 2264252 2264252 defendant Salesbury John   763615 763615 together with Salesbury, John, of Storteford, Herts, parson 2
4696061 2264253 2264253 defendant Salesbury John   763615 763615 Salesbury, John, of Storteford, Herts, parson 0
4696067 2264254 2264254 defendant Salesbury John   763615 763615 Salesbury, John, of Storteford, Herts, parson 0
4696071 2264255 2264255 defendant Salesbury John   763615 763615 Salesbury, John, of Storteford, Herts, parson 0
4812509 2300027 2300027 defendant Bedell John tiler 763615 763615 Bedell, John, of Storteford, Herts, tiler 0
4812512 2300028 2300028 defendant Bedell John tiler 763615 763615 Bedell, John, of Storteford, Herts, tiler 0
4820150 2302376 2302376 defendant Goos John   763615 763615 Goos, John, of Storteford, Herts, tallow chandler 2
4848871 2311113 2311113 defendant Kere Thomas husbandman 763615 763615 Kere, Thomas, of Storteford, Herts, husbandman 0
4855603 2313117 2313117 defendant Parkok Robert cordwainer 763615 763615 Parkok, Robert, of Storteford, Herts, cordwainer 2
4874864 2319080 2319080 defendant Cristemasse John chapman 763615 763615 Cristemasse, John, of Storteford, Herts, chapman 0
4874868 2319081 2319081 defendant Cristemesse John chapman 763615 763615 Cristemesse, John, of Storteford, Herts, chapman 0
4903448 2327686 2327686 defendant Panfeld Richard draper 763615 763615 Panfeld, Richard, of Storteford, Herts, draper 0
4905568 2328341 2328341 defendant Kere Thomas yeoman 763615 763615 Kere, Thomas, of Storteford, Herts, yeoman 1
4906199 2328530 2328530 defendant Panfeld Richard draper 763615 763615 Panfeld, Richard, of Storteford, Herts, draper 2
4912279 2330340 2330340 defendant Snoryng John chaplain 763615 763615 Snoryng, John, of Storteford, Herts, chaplain 0
4912281 2330341 2330341 defendant Snoryng John chaplain 763615 763615 Snoryng, John, of Storteford, Herts, chaplain 0
4922798 2333544 2333544 defendant Ferrour William baker 763615 763615 Ferrour, William, of Storteford, Herts, baker 1
4922801 2333545 2333545 defendant Ferrour William baker 763615 763615 Ferrour, William, of Storteford, Herts, baker 1
4934582 2337207 2337207 defendant Panfeld Richard draper 763615 763615 Panfeld, Richard, of Storteford, Herts, draper 2
4935455 2337483 2337483 defendant Thurskill John butcher 763615 763615 Thurskill, John, of Storteford, Herts, butcher 0
5044152 2369877 2369877 plaintiff (not given) William   763615 763615 Blank, William, of Storteford, Herts 1
5120120 2392322 2392322 defendant Belam John, senior glover 763615 763615 Belam, John, senior, of Storteford, Herts, glover 0
5215114 2420144 2420144 defendant Illyger William husbandman 763615 763615 Illyger, William, of Storteford, Herts, husbandman 2
5217841 2420949 2420949 defendant Thurkyld John butcher 763615 763615 Thurkyld, John, of Storteford, Herts, butcher 1
5233472 2425381 2425381 defendant Illyger William husbandman 763615 763615 Illyger, William, of Storteford, Herts, husbandman 2
5234555 2425694 2425694 defendant Waleys William husbandman 763615 763615 Waleys, William, of Storteford, Herts, husbandman 0
5234578 2425698 2425698 defendant Jogyn John husbandman 763615 763615 Jogyn, John, of Storteford, Herts, husbandman 4
5346775 2459150 2459150 defendant Palmer Thomas, senior butcher 763615 763615 Palmer, Thomas, senior, of Storteford, Herts, butcher 1

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