names

21 rows where place_id = 597893

✎ 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
3630269 1904315 1904315 defendant Palmer John yeoman 597893 597893 Palmer, John, of Wonerssh, yeoman 2
3750577 1942098 1942098 defendant Johnson Charles yeoman 597893 597893 Johnson, Charles, of Wonerssh, yeoman 3
4645581 2244777 2244777 plaintiff Northo John   597893 597893 Northo, John, of Wonerssh 0
4705600 2267122 2267122 defendant Dorry John chapman 597893 597893 Dorry, John, of Wonerssh, chapman 1
4718151 2271014 2271014 defendant Tangle John husbandman 597893 597893 Tangle, John, of Wonerssh, husbandman 1
4757466 2282712 2282712 plaintiff Markewyk John   597893 597893 Markewyk, John, of Wonerssh, vicar 2
5169242 2406743 2406743 defendant Borden John yeoman 597893 597893 Borden, John, of Wonerssh, yeoman 0
5186241 2411726 2411726 defendant Borden John yeoman 597893 597893 Borden, John, of Wonerssh, yeoman 0
5252738 2430964 2430964 defendant Elyot Thomas gent 597893 597893 Elyot, Thomas, of Wonerssh, gent 0
5381258 2469693 2469693 defendant Elyott Richard gent 597893 597893 Elyott, Richard, of Wonerssh, gent 1
5388092 2471654 2471654 defendant Elyott Richard gent 597893 597893 Elyott, Richard, of Wonerssh, gent 1
5423925 2482108 2482108 defendant Shirlok William husbandman 597893 597893 Shirlok, William, of Wonerssh, husbandman 2
5423929 2482109 2482109 defendant Shirlok William husbandman 597893 597893 Shirlok, William, of Wonerssh, husbandman 2
5424351 2482247 2482247 defendant Shirlok William husbandman 597893 597893 Shirlok, William, of Wonerssh, husbandman 2
5439131 2486628 2486628 defendant Shirlok William husbandman 597893 597893 Shirlok, William, of Wonerssh, husbandman 1
5443023 2487821 2487821 defendant Shirlok William husbandman 597893 597893 Shirlok, William, of Wonerssh, husbandman 2
5490924 2502187 2502187 defendant Strete William carpenter 597893 597893 Strete, William, of Wonerssh, carpenter 0
5490925 2502187 2502187 defendant Strete Thomas tailor 597893 597893 Strete, Thomas, of Wonerssh, tailor 1
5508562 2507544 2507544 defendant Slycherst John yeoman 597893 597893 Slycherst, John, of Wonerssh, yeoman 0
5508563 2507544 2507544 defendant Forder Nicholas yeoman 597893 597893 Forder, Nicholas, of Wonerssh, yeoman 1
5538447 2516508 2516508 defendant Smether John capenter 597893 597893 Smether, John, of Wonerssh, capenter 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);