names

33 rows where place_id = 620663

✎ 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
3736904 1937796 1937796 defendant Chapman William husbandman 620663 620663 Chapman, William, of Claynes, husbandman 1
3736905 1937796 1937796 defendant Hutton John, senior husbandman 620663 620663 Hutton, John, senior, of Claynes, husbandman 2
3736906 1937796 1937796 defendant Hutton John, junior husbandman 620663 620663 Hutton, John, junior, of Claynes, husbandman 3
3736907 1937796 1937796 defendant Hewis John, senior husbandman 620663 620663 Hewis, John, senior, of Claynes, husbandman 4
3736908 1937796 1937796 defendant Werkman Thomas laborer 620663 620663 Werkman, Thomas, of Claynes, laborer 5
3751412 1942356 1942356 defendant Alford Robert husbandman 620663 620663 Alford, Robert, of Claynes, husbandman 0
3764600 1946586 1946586 defendant Harrys Richard husbandman 620663 620663 Harrys, Richard, of Claynes, husbandman 0
3812240 1961731 1961731 defendant Chylde Richard yeoman 620663 620663 Chylde, Richard, of Claynes, yeoman 2
3845443 1972134 1972134 plaintiff Ferne Thomas   620663 620663 Ferne, Thomas, of Claynes 0
3889605 1986753 1986753 defendant Haynes Thomas miller 620663 620663 Haynes, Thomas, of Claynes, miller 3
3933626 2001534 2001534 defendant Pynner Richard husbandman 620663 620663 Pynner, Richard, of Claynes, husbandman 0
3933627 2001534 2001534 defendant Werne Edward yeoman 620663 620663 Werne, Edward, of Claynes, yeoman 1
3958703 2010118 2010118 defendant Prestode John yeoman 620663 620663 Prestode, John, of Claynes, yeoman 0
3958704 2010118 2010118 defendant Prestode Hugh husbandman 620663 620663 Prestode, Hugh, of Claynes, husbandman 1
3977856 2016827 2016827 defendant Wythy Jasper husbandman 620663 620663 Wythy, Jasper, of Claynes, husbandman 0
3977858 2016828 2016828 defendant Wythy Jasper husbandman 620663 620663 Wythy, Jasper, of Claynes, husbandman 0
4000941 2025106 2025106 defendant Cox William husbandman 620663 620663 Cox, William, of Claynes, husbandman 1
4323521 2138286 2138286 defendant Yarnolde John husbandman 620663 620663 Yarnolde John, of Claynes, husbandman 3
4351156 2147653 2147653 defendant Chapman Richard yeoman 620663 620663 Chapman, Richard, of Claynes, yeoman 0
4375240 2156198 2156198 defendant Chapman Richard yeoman 620663 620663 Chapman, Richard, of Claynes, yeoman 0
4383951 2159338 2159338 defendant Poyner Thomas yeoman 620663 620663 Poyner, Thomas, of Claynes, yeoman 0
4383953 2159339 2159339 defendant Coxe William gent 620663 620663 Coxe, William, of Claynes, gent 0
4394493 2162754 2162754 defendant Wolmer Thomas yeoman 620663 620663 Wolmer, Thomas, of Claynes, or of Barbon, yeoman 0
4404007 2165910 2165910 defendant Chapman Richard yeoman 620663 620663 Chapman, Richard, of Claynes, yeoman 0
4431991 2174786 2174786 defendant Curteys John   620663 620663 Curteys, John, of Claynes 1
4566570 2221115 2221115 defendant Otour Hugh   620663 620663 Otour, Hugh, of Claynes 0
4775735 2288407 2288407 defendant Tyley Nicholas husbandman 620663 620663 Tyley, Nicholas, of Claynes, husbandman 4
4981634 2351421 2351421 defendant Cossyll William husbandman 620663 620663 Cossyll, William, of Claynes, husbandman 4
5537072 2516079 2516079 defendant Acton Richard gent 620663 620663 Acton, Richard, of Claynes, gent 0
5596939 2533956 2533956 defendant Acton Margaret widow 620663 620663 Acton, Margaret, of Claynes, widow 3
5599062 2534589 2534589 defendant Comyns Thomas husbandman 620663 620663 Comyns, Thomas, of Claynes, husbandman 5
5599063 2534589 2534589 defendant Wethey John husbandman 620663 620663 Wethey, John, of Claynes, husbandman 6
5599066 2534589 2534589 defendant Meryman John husbandman 620663 620663 Meryman, John, of Claynes, husbandman 9

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);