names

23 rows where place_id = 597315

✎ 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
3628047 1903625 1903625 defendant Bulwer Roger yeoman 597315 597315 Bulwer, Roger, of Wode Dallyng, yeoman 0
3628048 1903625 1903625 defendant Hynde Richard husbandman 597315 597315 Hynde, Richard, of Wode Dallyng, husbandman 1
4444551 2183271 2183271 plaintiff Colby Adam de   597315 597315 Colby, Adam de, of Wode Dallyng, vicar 0
4555971 2217807 2217807 defendant Bygot Simon   597315 597315 Bygot, Simon, of Wode Dallyng 0
4619828 2237178 2237178 defendant Foster William   597315 597315 Foster, William, of Wode Dallyng 0
4623159 2238217 2238217 defendant Bokkyng Robert   597315 597315 Bokkyng, Robert, of Wode Dallyng 0
4706538 2267424 2267424 defendant Wodecroft Richard yeoman 597315 597315 Wodecroft, Richard, of Wode Dallyng, yeoman 0
4707844 2267823 2267823 defendant Smyth Richard smith 597315 597315 Smyth, Richard, of Wode Dallyng, smith 0
4731330 2274999 2274999 defendant Wodecroft Richard yeoman 597315 597315 Wodecroft, Richard, of Wode Dallyng, yeoman 0
4731331 2274999 2274999 defendant Smyth Richard smith 597315 597315 Smyth, Richard, of Wode Dallyng, smith 1
4731332 2274999 2274999 defendant Calthorp Thomas husbandman 597315 597315 Calthorp, Thomas, of Wode Dallyng, husbandman 2
4768561 2286147 2286147 plaintiff Neweman Nicholas   597315 597315 Neweman, Nicholas, of Wode Dallyng 0
4817569 2301585 2301585 defendant Wodecroft Richard yeoman 597315 597315 Wodecroft, Richard, of Wode Dallyng, yeoman 1
4829902 2305396 2305396 defendant Wodecroft Richard yeoman 597315 597315 Wodecroft, Richard, of Wode Dallyng, yeoman 0
4829903 2305396 2305396 defendant Wodecroft Peter yeoman 597315 597315 Wodecroft, Peter, of Wode Dallyng, yeoman 1
4842636 2309232 2309232 defendant Reede Robert husbandman 597315 597315 Reede, Robert, of Wode Dallyng, husbandman 3
4842637 2309232 2309232 defendant Wodecroft Richard husbandman 597315 597315 Wodecroft, Richard, of Wode Dallyng, husbandman 4
4916346 2331614 2331614 plaintiff Bulwere Roger   597315 597315 Bulwere, Roger, of Wode Dallyng 1
4916353 2331616 2331616 plaintiff Bulwere Roger   597315 597315 Bulwere, Roger, of Wode Dallyng 1
5008125 2359261 2359261 defendant Mony Simon yeoman 597315 597315 Mony, Simon, of Wode Dallyng, yeoman 0
5109213 2389119 2389119 defendant Gerveys Thomas husbandman 597315 597315 Gerveys, Thomas, of Wode Dallyng, husbandman 1
5415531 2479585 2479585 defendant Bray Richard butcher 597315 597315 Bray, Richard, of Wode Dallyng, butcher 0
5415534 2479586 2479586 defendant Tray Richard butcher 597315 597315 Tray, Richard, of Wode Dallyng, butcher 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);