names

41 rows where place_id = 764702

✎ 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
4508641 2203180 2203180 defendant Hopshort Richard   764702 764702 Hopshort, Richard, of Garmethorp 2
4523380 2207633 2207633 defendant Rumbald Robert   764702 764702 Rumbald, Robert, of Garmethorp 0
4541844 2213339 2213339 defendant Hopshort Richard   764702 764702 Hopshort, Richard, of Garmethorp 0
4813605 2300360 2300360 defendant Penyngton Thomas husbandman 764702 764702 Penyngton, Thomas, of Garmethorp, husbandman 0
5012036 2360370 2360370 defendant Dyconson Robert, sen yeoman 764702 764702 Dyconson, Robert, sen, of Garmethorp, yeoman 0
5042101 2369244 2369244 defendant Turpyn Robert husbandman 764702 764702 Turpyn, Robert, of Garmethorp, husbandman 3
5045253 2370208 2370208 defendant Palmer John milner 764702 764702 Palmer, John, of Garmethorp, milner 2
5056519 2373529 2373529 defendant Dyconson Robert yeoman 764702 764702 Dyconson, Robert, of Garmethorp, yeoman 4
5095519 2385107 2385107 defendant Lee John husbandman 764702 764702 Lee, John, of Garmethorp, husbandman 0
5095520 2385107 2385107 defendant Diconson Robert, junior husbandman 764702 764702 Diconson, Robert, junior, of Garmethorp, husbandman 1
5095521 2385107 2385107 defendant Couper John husbandman 764702 764702 Couper, John, of Garmethorp, husbandman 2
5139346 2397997 2397997 defendant Palmer Ivo laborer 764702 764702 Palmer, Ivo, of Garmethorp, laborer 0
5139349 2397998 2397998 defendant Palmer Ivo laborer 764702 764702 Palmer, Ivo, of Garmethorp, laborer 0
5190424 2412943 2412943 defendant Wharman William   764702 764702 Wharman, William, of Garmethorp, parish clerk 2
5240541 2427446 2427446 defendant Halwys Walter laborer 764702 764702 (Halwys, Walter, of Garmethorp, laborer 4
5240542 2427446 2427446 defendant Trayll Agnes widow 764702 764702 Trayll, Agnes, of of Garmethorp, widow 5
5244209 2428502 2428502 plaintiff Penyngton John (legal representative) 764702 764702 Penyngton, John, of Garmethorp, executor of 0
5244211 2428502 2428502 defendant Trayle John (legal representative) 764702 764702 Trayle, John, of Garmethorp, executors of 0
5244212 2428502 2428502 defendant Blankney William clerk 764702 764702 (Blankney, William, of Garmethorp, clerk 1
5244215 2428502 2428502 defendant Trayle Joan widow 764702 764702 Trayle, Joan, of Garmethorp, widow 4
5244216 2428502 2428502 defendant Loydon William thatcher 764702 764702 Loydon, William, of Garmethorp, thatcher 5
5244220 2428502 2428502 defendant Helwys Walter laborer 764702 764702 Helwys, Walter, of Garmethorp, laborer 9
5244221 2428503 2428503 plaintiff Penyngton John (legal representative) 764702 764702 Penyngton, John, of Garmethorp, executor of 0
5244228 2428504 2428504 plaintiff Penyngton John (legal representative) 764702 764702 Penyngton, John, of Garmethorp, executor of 0
5244235 2428505 2428505 plaintiff Penyngton John (legal representative) 764702 764702 Penyngton, John, of Garmethorp, executor of 0
5244237 2428505 2428505 defendant Trayle John (legal representative) 764702 764702 Trayle, John, of Garmethorp, executors of 0
5244238 2428505 2428505 defendant Blounkeney William clerk 764702 764702 (Blounkeney, William, of Garmethorp, clerk 1
5244240 2428505 2428505 defendant Garnon Robert husbandman 764702 764702 Garnon, Robert, of Garmethorp, husbandman 3
5244241 2428505 2428505 defendant Trayle Joan widow 764702 764702 Trayle, Joan, of Garmethorp, widow 4
5244242 2428505 2428505 defendant Leydon William thatcher 764702 764702 Leydon, William, of Garmethorp, thatcher 5
5244246 2428505 2428505 defendant Helwys Walter laborer 764702 764702 Helwys, Walter, of Garmethorp, laborer 9
5287457 2441356 2441356 defendant Kynge Robert husbandman 764702 764702 Kynge, Robert, of Garmethorp, husbandman 0
5287461 2441356 2441356 defendant Hampton William yeoman 764702 764702 Hampton, William, of Garmethorp, yeoman 4
5287465 2441357 2441357 defendant Kynge Robert husbandman 764702 764702 Kynge, Robert, of Garmethorp, husbandman 0
5287468 2441357 2441357 defendant Hampton William yeoman 764702 764702 Hampton, William, of Garmethorp, yeoman 3
5308761 2447659 2447659 defendant Palmer John husbandman 764702 764702 Palmer, John, of Garmethorp, husbandman 0
5311719 2448527 2448527 defendant Assheton William miller 764702 764702 Assheton, William, of Garmethorp, miller 0
5311732 2448530 2448530 defendant Taillour John tailor 764702 764702 Taillour, John, of Garmethorp, tailor 1
5326351 2452968 2452968 defendant Jacson Alan husbandman 764702 764702 Jacson, Alan, of Garmethorp, husbandman 3
5355558 2461809 2461809 defendant Brather John laborer 764702 764702 Brather, John, of Garmethorp, laborer 1
5484502 2500283 2500283 defendant Duffeld Hugh yeoman 764702 764702 Duffeld, Hugh, of Garmethorp, yeoman 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);