names

35 rows where place_id = 610836

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3685491 1921614 1921614 defendant Wake William gent 610836 610836 Wake, William, of Wykyn, gent 4
3696074 1924998 1924998 defendant Wake William gent 610836 610836 Wake, William, of Wykyn, gent 0
3720656 1932749 1932749 defendant Appryse Richard drover 610836 610836 Appryse, Richard, of Wykyn, drover 0
3733201 1936616 1936616 defendant Peyton Anne widow 610836 610836 Peyton, Anne, of Wykyn, widow 1
3914552 1995212 1995212 defendant Stokkyng John husbandman 610836 610836 Stokkyng, John, of Wykyn, husbandman 0
3914553 1995212 1995212 defendant Root Peter husbandman 610836 610836 Root, Peter, of Wykyn, husbandman 1
3914554 1995212 1995212 defendant Orwell William husbandman 610836 610836 Orwell, William, of Wykyn, husbandman 2
3914555 1995212 1995212 defendant Elys William husbandman 610836 610836 Elys, William, of Wykyn, husbandman 3
3914556 1995212 1995212 defendant Messynger Leonard husbandman 610836 610836 Messynger, Leonard, of Wykyn, husbandman 4
3921986 1997698 1997698 defendant Fletcher Roger husbandman 610836 610836 Fletcher, Roger, of Wykyn, husbandman 1
4034359 2036961 2036961 defendant Wyghtman Thomas yeoman 610836 610836 Wyghtman, Thomas, of Wykyn, yeoman 1
4530910 2209961 2209961 defendant Baille Richard   610836 610836 Baille, Richard, of Wykyn 0
4543032 2213711 2213711 defendant Augere John   610836 610836 Augere, John, of Wykyn 0
4543033 2213711 2213711 defendant Gayne Thomas   610836 610836 Gayne, Thomas, of Wykyn 1
4543034 2213711 2213711 defendant Newyn William   610836 610836 Newyn, William, of Wykyn 2
4718168 2271021 2271021 plaintiff attte Lathe Joan   610836 610836 attte Lathe, Joan, of Wykyn 0
4721504 2272055 2272055 defendant Glover Robert   610836 610836 Glover, Robert, of Wykyn, servant 0
4725923 2273395 2273395 plaintiff Godman John   610836 610836 Godman, John, of Wykyn 0
4931314 2336173 2336173 defendant Hypgame Thomas carter 610836 610836 Hypgame, Thomas, of Wykyn, carter 0
4942848 2339735 2339735 plaintiff Fycche William   610836 610836 Fycche, William, of Wykyn 0
4970147 2348022 2348022 defendant Fyche William husbandman 610836 610836 Fyche, William, of Wykyn, husbandman 0
5021322 2363142 2363142 defendant Tommys John husbandman 610836 610836 Tommys, John, of Wykyn, husbandman 0
5021323 2363142 2363142 defendant Cottyswold Thomas   610836 610836 Cottyswold, Thomas, of Wykyn, servant 1
5148222 2400621 2400621 defendant Anabill Thomas husbandman 610836 610836 Anabill, Thomas, of Wykyn, husbandman 2
5148223 2400621 2400621 defendant Vykarrs Roger husbandman 610836 610836 Vykarrs, Roger, of Wykyn, husbandman 3
5148224 2400621 2400621 defendant Prentys William husbandman 610836 610836 Prentys, William, of Wykyn, husbandman 4
5148225 2400621 2400621 defendant Prentys John husbandman 610836 610836 Prentys, John, of Wykyn, husbandman 5
5183168 2410815 2410815 defendant Prentys John husbandman 610836 610836 Prentys, John, of Wykyn, husbandman 3
5203770 2416853 2416853 defendant Vykars Roger husbandman 610836 610836 Vykars, Roger, of Wykyn, husbandman 1
5203771 2416853 2416853 defendant Prentys William husbandman 610836 610836 Prentys, William, of Wykyn, husbandman 2
5203772 2416853 2416853 defendant Prentys John husbandman 610836 610836 Prentys, John, of Wykyn, husbandman 3
5289512 2441934 2441934 defendant Archer Thomas husbandman 610836 610836 Archer, Thomas, of Wykyn, husbandman 3
5324180 2452319 2452319 defendant Costall Thomas fisher 610836 610836 Costall, Thomas, of Wykyn, fisher 1
5361174 2463522 2463522 defendant Kyng William husbandman 610836 610836 Kyng, William, of Wykyn, husbandman 0
5373327 2467255 2467255 defendant Frankton Thomas husbandman 610836 610836 Frankton, Thomas, of Wykyn, husbandman 2

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