names

23 rows where place_id = 600172

✎ 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
3640027 1907333 1907333 defendant Holdepe Simon husbandman 600172 600172 Holdepe, Simon, of Kyngesclere, Hants, husbandman 0
3733468 1936710 1936710 defendant Wydmore William yeoman 600172 600172 Wydmore, William, of Kyngesclere, Hants, yeoman 0
3741277 1939131 1939131 defendant Edwardys Nicholas yeoman 600172 600172 Edwardys, Nicholas, of Kyngesclere, Hants, yeoman 0
3834085 1968600 1968600 defendant Bever John yeoman 600172 600172 Bever, John, of Kyngesclere, Hants, yeoman 0
3870087 1980237 1980237 defendant Wygmore Thomas husbandman 600172 600172 Wygmore, Thomas, of Kyngesclere, Hants, husbandman 0
3888557 1986431 1986431 defendant Arnold Thomas chapman 600172 600172 Arnold, Thomas, of Kyngesclere, Hants, chapman 2
3974996 2015817 2015817 defendant Hollowey Richard innholder 600172 600172 Hollowey, Richard, of Kyngesclere, Hants, innholder 0
4169783 2084926 2084926 defendant Wrenne Richard tanner 600172 600172 Wrenne, Richard, of Kyngesclere, Hants, tanner 0
4818058 2301724 2301724 defendant Cathefranche William husbandman 600172 600172 Cathefranche, William, of Kyngesclere, Hants, husbandman 0
4860483 2314640 2314640 defendant Badcok William   600172 600172 Badcok, William, of Kyngesclere, Hants, kersey weaver 3
4941640 2339405 2339405 defendant Mote Robert chapman 600172 600172 Mote, Robert, of Kyngesclere, Hants, chapman 0
5016551 2361735 2361735 defendant Graslade Walter yeoman 600172 600172 Graslade, Walter, of Kyngesclere, Hants, yeoman 2
5021110 2363069 2363069 defendant James alias Carter Roger laborer 600172 600172 James alias Carter, Roger, of Kyngesclere, Hants, laborer 2
5030359 2365753 2365753 defendant Seman Isabel widow 600172 600172 Seman, Isabel, of Kyngesclere, Hants, widow 1
5031082 2365964 2365964 defendant Smyth Richard smith 600172 600172 Smyth, Richard, of Kyngesclere, Hants, smith 0
5031083 2365964 2365964 defendant Brounesdon Robert cooper 600172 600172 Brounesdon, Robert, of Kyngesclere, Hants, cooper 1
5050086 2371647 2371647 defendant Palmer Hugh chapman 600172 600172 Palmer, Hugh, of Kyngesclere, Hants, chapman 3
5068273 2377015 2377015 defendant Fauconer Richard esq 600172 600172 Fauconer, Richard, of Kyngesclere, Hants, gent, son of Fauconer, William, of Kyngesclere, esq 0
5097063 2385574 2385574 defendant Palmer Hugh chapman 600172 600172 Palmer, Hugh, of Kyngesclere, Hants, chapman 0
5098740 2386060 2386060 defendant Rounston John   600172 600172 Rounston, John, of Kyngesclere, Hants, bailoff 1
5290387 2442192 2442192 defendant Faukener Thomas gent 600172 600172 Faukener, Thomas, of Kyngesclere, Hants, gent 0
5576297 2527644 2527644 defendant Saunsum Thomas yeoman 600172 600172 Saunsum, Thomas, of Kyngesclere, Hants, yeoman 3
5580066 2528846 2528846 defendant Stacy John mercer 600172 600172 Stacy, John, of Kyngesclere, Hants, mercer 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);