names

35 rows where place_id = 651195

✎ 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
3916293 1995832 1995832 defendant Langdale William gent 651195 651195 Langdale, William, of Scardburgh, gent 1
3956752 2009430 2009430 plaintiff Pacoke Gregory merchant 651195 651195 Pacoke, Gregory, of Scardburgh, merchant 0
4476692 2193368 2193368 defendant Longlt John   651195 651195 Longlt, John, of Scardburgh 3
4495487 2199269 2199269 plaintiff Carethorp Thomas   651195 651195 Carethorp, Thomas, of Scardburgh, on his own account 0
4538067 2212187 2212187 defendant Mauby Richard de   651195 651195 Mauby, Richard de, of Scardburgh 0
4542931 2213683 2213683 plaintiff Anlaby or Aulaby John de   651195 651195 Anlaby or Aulaby, John de, of Scardburgh 0
4563676 2220205 2220205 defendant Litster Richard   651195 651195 Litster, Richard, of Scardburgh 1
4628046 2239694 2239694 plaintiff Ryselay John   651195 651195 Ryselay, John, of Scardburgh 0
4628517 2239842 2239842 plaintiff Scot John   651195 651195 Scot, John, of Scardburgh 0
4628519 2239842 2239842 defendant Coke John   651195 651195 Coke, John, of Scardburgh 0
4628892 2239966 2239966 defendant Wryght Maud   651195 651195 Wryght, Maud, of Scardburgh, formerly wife of Robert 0
4645212 2244671 2244671 plaintiff Mossedale John   651195 651195 Mossedale, John, of Scardburgh 0
4647173 2245224 2245224 plaintiff Ryselay John   651195 651195 Ryselay, John, of Scardburgh 0
4648650 2245660 2245660 plaintiff Tailour Adam   651195 651195 Tailour, Adam, of Scardburgh 0
4650409 2246142 2246142 defendant Billarclyf William   651195 651195 Billarclyf, William, of Scardburgh 1
4650410 2246142 2246142 defendant Castell John clerk 651195 651195 Castell, John, of Scardburgh, clerk 2
4703734 2266547 2266547 defendant Simme Robert   651195 651195 Simme, Robert, of Scardburgh, ship wright 1
4709492 2268325 2268325 plaintiff Percy William   651195 651195 Percy, William, of Scardburgh 0
4712623 2269266 2269266 defendant Carethorp Thomas   651195 651195 Carethorp, Thomas, of Scardburgh 0
4789143 2292657 2292657 defendant Besyngby John, junior merchant 651195 651195 Besyngby, John, junior, of Scardburgh, merchant 0
4828070 2304822 2304822 defendant Baumburgh John tailor 651195 651195 Baumburgh, John, of Scardburgh, tailor 2
4851620 2311942 2311942 defendant Pyvell Michael merchant 651195 651195 Pyvell, Michael, of Scardburgh, merchant 0
4851621 2311942 2311942 defendant Danyell Richard merchant 651195 651195 Danyell, Richard, of Scardburgh, merchant 1
4851622 2311942 2311942 defendant Gysburgh Thomas merchant 651195 651195 Gysburgh, Thomas, of Scardburgh, merchant 2
4879562 2320534 2320534 defendant Danyell Richard merchant 651195 651195 Danyell, Richard, of Scardburgh, merchant 1
4879563 2320534 2320534 defendant Gysburgh Thomas merchant 651195 651195 Gysburgh, Thomas, of Scardburgh, merchant 2
4879566 2320535 2320535 defendant Danyell Richard merchant 651195 651195 Danyell, Richard, of Scardburgh, merchant 1
4879567 2320535 2320535 defendant Gisburgh Thomas merchant 651195 651195 Gisburgh, Thomas, of Scardburgh, merchant 2
4879611 2320547 2320547 defendant Danyell Richard merchant 651195 651195 Danyell, Richard, of Scardburgh, merchant 1
4879612 2320547 2320547 defendant Gisburgh Thomas merchant 651195 651195 Gisburgh, Thomas, of Scardburgh, merchant 2
4927322 2334976 2334976 defendant Hervy John panyer man 651195 651195 Hervy, John, of Scardburgh, panyer man 1
4980593 2351136 2351136 defendant Carethorp Robert gent 651195 651195 Carethorp, Robert, of Scardburgh, gent 0
5212161 2419295 2419295 defendant (not given) John rector of Wark alias Scott 651195 651195 Wark alias Scott, John, of Scardburgh, rector of Staple, Soms 1
5213386 2419645 2419645 plaintiff Boles Lawrence (legal representative) 651195 651195 Boles, Lawrence, of Scardburgh, executors of 0
5220193 2421605 2421605 defendant Carvour John fletcher 651195 651195 Carvour, John, of Scardburgh, fletcher 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);