names

26 rows where place_id = 821477

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4915800 2331440 2331440 defendant Danyles William gent 821477 821477 Danyles, William, of Badston, gent 0
5034418 2366926 2366926 defendant Davylle or Danylle William esq 821477 821477 Davylle or Danylle, William, of Badston, esq 0
5049365 2371443 2371443 defendant Danyls William gent 821477 821477 Danyls, William, of Badston, gent 0
5065091 2376090 2376090 defendant Chiltron William yeoman 821477 821477 Chiltron, William, of Badston, yeoman 0
5106855 2388432 2388432 defendant Frank Richard gent 821477 821477 Frank, Richard, of Badston, gent 0
5343159 2458051 2458051 defendant Franke Richard yeoman 821477 821477 Franke, Richard, of Badston, yeoman 0
5371708 2466739 2466739 defendant Franke Richard   821477 821477 Franke, Richard, of Badston, franklin 0
5373661 2467360 2467360 defendant Frank Richard merchant 821477 821477 Frank, Richard, of Badston, merchant 0
5386416 2471186 2471186 defendant Perigge Richard husbandman 821477 821477 Perigge, Richard, of Badston, husbandman 1
5398699 2474694 2474694 defendant Partrygge Richard husbandman 821477 821477 Partrygge, Richard, of Badston, husbandman 1
5398705 2474696 2474696 defendant Partrygge Richard husbandman 821477 821477 Partrygge, Richard, of Badston, husbandman 1
5437179 2486057 2486057 defendant Bastard Ralph husbandman 821477 821477 Bastard, Ralph, of Badston, husbandman 0
5437180 2486057 2486057 defendant Skynner John fisher 821477 821477 Skynner, John, of Badston, fisher 1
5437337 2486112 2486112 defendant Martyn William fisher 821477 821477 Martyn, William, of Badston, fisher 0
5437338 2486112 2486112 defendant Martyn John fisher 821477 821477 Martyn, John, of Badston, fisher 1
5444448 2488246 2488246 defendant Partrigge Richard husbandman 821477 821477 Partrigge, Richard, of Badston, husbandman 0
5451747 2490397 2490397 defendant Martyn William fishmonger 821477 821477 Martyn, William, of Badston, fishmonger 0
5451748 2490397 2490397 defendant Martyn John fishmonger 821477 821477 Martyn, John, of Badston, fishmonger 1
5451765 2490402 2490402 defendant Martyn William fishmonger 821477 821477 Martyn, William, of Badston, fishmonger 0
5451766 2490402 2490402 defendant Martyn John fishmonger 821477 821477 Martyn, John, of Badston, fishmonger 1
5455755 2491621 2491621 defendant Patriche Richard yeoman 821477 821477 Patriche, Richard, of Badston, yeoman 0
5457177 2492043 2492043 defendant Partrigge Richard husbandman 821477 821477 Partrigge, Richard, of Badston, husbandman 1
5463699 2494058 2494058 defendant Martyn William fisher 821477 821477 Martyn, William, of Badston, fisher 0
5463700 2494058 2494058 defendant Martyn John fisher 821477 821477 Martyn, John, of Badston, fisher 1
5463702 2494059 2494059 defendant Martyn William fisher 821477 821477 Martyn, William, of Badston, fisher 0
5463703 2494059 2494059 defendant Martyn John fisher 821477 821477 Martyn, John, of Badston, fisher 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);