names

28 rows where place_id = 589672

✎ 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
3598375 1867121 1867121 defendant Webbe Thomas laborer 589672 589672 Webbe, Thomas, of Dunchurche, laborer 1
3629835 1904183 1904183 defendant Belche Thomas husbandman 589672 589672 Belche, Thomas, of Dunchurche, husbandman 0
3634155 1905483 1905483 defendant Dixson Oliver baker 589672 589672 Dixson, Oliver, of Dunchurche, baker 0
3687109 1922140 1922140 defendant Jarrard James yeoman 589672 589672 Jarrard, James, of Dunchurche, yeoman 0
3693340 1924130 1924130 defendant Lytley William yeoman 589672 589672 Lytley, William, of Dunchurche, yeoman 0
3744132 1940064 1940064 defendant Jarard James yeoman 589672 589672 Jarard, James, of Dunchurche, yeoman 2
3745001 1940342 1940342 defendant Gerrard James yeoman 589672 589672 Gerrard, James, of Dunchurche, yeoman 1
3766215 1947083 1947083 defendant Jerard James yeoman 589672 589672 Jerard, James, of Dunchurche, yeoman 0
3771563 1948803 1948803 defendant Burton Agnes spinster 589672 589672 Burton, Agnes, of Dunchurche, spinster 0
3856317 1975594 1975594 defendant Ball Robert baker 589672 589672 Ball, Robert, of Dunchurche, baker 2
3922448 1997825 1997825 defendant Alen John innholder 589672 589672 Alen, John, of Dunchurche, innholder 0
4062198 2046768 2046768 defendant Oldams Henry weaver 589672 589672 Oldams, Henry, of Dunchurche, weaver 0
4062199 2046768 2046768 defendant Oldams William weaver 589672 589672 Oldams, William, of Dunchurche, weaver 1
4127158 2070002 2070002 defendant Bethell Humphrey yeoman 589672 589672 Bethell, Humphrey, of Dunchurche, yeoman 0
4143513 2075890 2075890 defendant Collens Richard butcher 589672 589672 Collens, Richard, of Dunchurche, butcher 0
4151010 2078483 2078483 defendant Bithell Humphrey innholder 589672 589672 Bithell, Humphrey, of Dunchurche, innholder 0
4213392 2100201 2100201 defendant Collens Richard yeoman 589672 589672 Collens, Richard, of Dunchurche, yeoman 2
4222956 2103521 2103521 defendant Collyns Elizabeth widow 589672 589672 Collyns, Elizabeth, of Dunchurche, widow 0
4222957 2103521 2103521 defendant Bradshawe Thomas laborer 589672 589672 Bradshawe, Thomas, of Dunchurche, laborer 1
4222958 2103521 2103521 defendant Purden Thomas laborer 589672 589672 Purden, Thomas, of Dunchurche, laborer 2
4225209 2104286 2104286 plaintiff Collyns Elizabeth widow 589672 589672 Collyns, Elizabeth, of Dunchurche, widow 0
4233394 2107194 2107194 plaintiff Collins Elizabeth widow 589672 589672 Collins, Elizabeth, of Dunchurche, widow 0
4325601 2138937 2138937 defendant Edmond henry husbandman 589672 589672 Edmond, henry, of Dunchurche, husbandman 3
5497653 2504241 2504241 defendant Melton Nicholas husbandman 589672 589672 Melton, Nicholas, of Dunchurche, husbandman 4
5497659 2504242 2504242 defendant Melton Nicholas husbandman 589672 589672 Melton, Nicholas, of Dunchurche, husbandman 4
5568962 2525474 2525474 defendant Skynner John smith 589672 589672 Skynner, John, of Dunchurche, smith 0
5586694 2530877 2530877 defendant Skynner John husbandman 589672 589672 Skynner, John, of Dunchurche, husbandman 0
5590932 2532140 2532140 defendant Skynner John smith 589672 589672 Skynner, John, of Dunchurche, smith 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);