names

21 rows where place_id = 758237

✎ 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
4420499 2171318 2171318 defendant Palmer Richard   758237 758237 Palmer, Richard, of Berneston, parson 2
4420512 2171319 2171319 defendant Palmer Richard   758237 758237 Palmer, Richard, of Berneston, parson 2
4421231 2171534 2171534 defendant atte Wode Bartholomew   758237 758237 atte Wode, Bartholomew, of Berneston, son of John 0
4452437 2185757 2185757 defendant Smyth John   758237 758237 Smyth, John, of Berneston 2
4482847 2195339 2195339 plaintiff Mounceux Joan   758237 758237 Mounceux, Joan, of Berneston, formerly wife of John 0
4482869 2195346 2195346 plaintiff Mounteux Joan   758237 758237 Mounteux, Joan, of Berneston, formerly wife of John Mounceux 0
4494042 2198823 2198823 plaintiff Berneston Thomas de   758237 758237 Berneston, Thomas de, of Berneston, parson 0
4511542 2204059 2204059 plaintiff Berneston Thomas de   758237 758237 Berneston, Thomas de, of Berneston, parson 0
4560107 2219104 2219104 plaintiff Mounceux Joan   758237 758237 Mounceux, Joan, of Berneston, formerly wife of John 0
4563469 2220145 2220145 defendant Stobat John   758237 758237 Stobat, John, of Berneston 2
4624074 2238507 2238507 plaintiff Mounceux John   758237 758237 Mounceux, John, of Berneston 0
4806763 2298326 2298326 defendant Alwyn John   758237 758237 Alwyn, John, of Berneston, mason 0
4886598 2322672 2322672 defendant Bochard John husbandman 758237 758237 Bochard, John, of Berneston, husbandman 0
4985183 2352498 2352498 defendant Bolle William husbandman 758237 758237 Bolle, William, of Berneston, husbandman 0
5159084 2403770 2403770 defendant Hulstok Thomas husbandman 758237 758237 Hulstok, Thomas, of Berneston, husbandman 0
5174629 2408280 2408280 defendant Hulstok Thomas husbandman 758237 758237 Hulstok, Thomas, of Berneston, husbandman 0
5175272 2408460 2408460 defendant None Stephen yeoman 758237 758237 None, Stephen, of Berneston, yeoman 0
5253085 2431071 2431071 defendant Heylok Richard husbandman 758237 758237 Heylok, Richard, of Berneston, husbandman 1
5376340 2468197 2468197 defendant Browene Thomas husbandman 758237 758237 Browene, Thomas, of Berneston, husbandman 0
5410796 2478176 2478176 defendant Browene Thomas husbandman 758237 758237 Browene, Thomas, of Berneston, husbandman 1
5424885 2482405 2482405 defendant Browne Thomas husbandman 758237 758237 Browne, Thomas, of Berneston, 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);