names

23 rows where place_id = 754435

✎ 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
4416922 2170163 2170163 defendant Diestere Thomas le   754435 754435 Diestere, Thomas le, of Baunebury, son of John 0
4420138 2171198 2171198 defendant Walsshe Walter le   754435 754435 Walsshe, Walter le, of Baunebury 0
4420141 2171199 2171199 defendant Walsshe Walter le   754435 754435 Walsshe, Walter le, of Baunebury 0
4480849 2194680 2194680 defendant Danvers Richard   754435 754435 Danvers, Richard, of Baunebury 1
4493501 2198671 2198671 defendant Cokke John cardmaker 754435 754435 Cokke, John, of Baunebury, cardmaker 0
4526447 2208550 2208550 defendant Scot John   754435 754435 Scot, John, of Baunebury 0
4530404 2209800 2209800 defendant Blakwell John   754435 754435 Blakwell, John, of Baunebury 0
4532454 2210417 2210417 plaintiff Prior William   754435 754435 Prior, William, of Baunebury 0
4548285 2215405 2215405 defendant Napton John   754435 754435 Napton, John, of Baunebury 0
4550261 2216028 2216028 defendant Goldryng Thomas   754435 754435 Goldryng, Thomas, of Baunebury 1
4565179 2220681 2220681 defendant Daly Thomas   754435 754435 Daly, Thomas, of Baunebury 0
4579909 2225204 2225204 defendant Harpour John   754435 754435 Harpour, John, of Baunebury 1
4613452 2235223 2235223 plaintiff Danvers Richard   754435 754435 Danvers, Richard, of Baunebury 0
4613457 2235223 2235223 defendant Umfrey Richard   754435 754435 Umfrey, Richard, of Baunebury 4
4613459 2235224 2235224 plaintiff Danvers Richard   754435 754435 Danvers, Richard, of Baunebury 0
4821647 2302849 2302849 defendant Maryner Richard glover 754435 754435 Maryner, Richard, of Baunebury, glover 0
4822713 2303181 2303181 defendant Maryner Richard glover 754435 754435 Maryner, Richard, of Baunebury, glover 0
4853759 2312589 2312589 plaintiff Danvers John esq 754435 754435 Danvers, John, of Baunebury, esq 1
5040737 2368843 2368843 plaintiff Cappon William draper 754435 754435 Cappon, William, of Baunebury, draper 0
5144796 2399630 2399630 defendant Asshwell Thomas   754435 754435 Asshwell, Thomas, of Baunebury 0
5146677 2400167 2400167 plaintiff Capron William draper 754435 754435 Capron, William, of Baunebury, draper 0
5146679 2400167 2400167 defendant Baker Alice widow 754435 754435 Baker, Alice, of Baunebury, widow 1
5447991 2489283 2489283 plaintiff Kyng Thomas hosier 754435 754435 Kyng, Thomas, of Baunebury, hosier 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);