names

20 rows where place_id = 610044

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3681690 1920369 1920369 defendant Awdelet John gent 610044 610044 Awdelet, John, of Abington, Berks, gent 0
3966293 2012839 2012839 plaintiff Bostock Lionel   610044 610044 Bostock, Lionel, of Abington, Berks, woollen draper 0
4078313 2052543 2052543 defendant Smyth Thomas gent 610044 610044 Smyth, Thomas, of Abington, Berks, gent 1
4081228 2053594 2053594 defendant Hollandum Robert clerk 610044 610044 Hollandum, Robert, of Abington, Berks, clerk 0
4089209 2056427 2056427 defendant Craft William chapman 610044 610044 Craft, William, of Abington, Berks, chapman 0
4094615 2058411 2058411 defendant Deyos John grocer 610044 610044 Deyos, John, of Abington, Berks, or of Lempster, Herefs, grocer 0
4131880 2071714 2071714 defendant Fysher John chapman 610044 610044 Fysher, John, of Abington, Berks, chapman 0
4162400 2082408 2082408 defendant Cordell Thomas chapman 610044 610044 Cordell, Thomas, of Abington, Berks, chapman 3
4191033 2092428 2092428 defendant Fysher John chapman 610044 610044 Fysher, John, of Abington, Berks, chapman 0
4192947 2093098 2093098 defendant Rockell Thomas yeoman 610044 610044 Rockell, Thomas, of Abington, Berks, yeoman 1
4199100 2095241 2095241 defendant Daye Arthur chapman 610044 610044 Daye, Arthur, of Abington, Berks, chapman 0
4208102 2098392 2098392 defendant Parris David painter 610044 610044 Parris, David, of Abington, Berks, painter 1
4210336 2099170 2099170 defendant Jennens William draper 610044 610044 Jennens, William, of Abington, Berks, draper 0
4267562 2118784 2118784 defendant Ayres Richard chapman 610044 610044 Ayres, Richard, of Abington, Berks, chapman 0
4293880 2127881 2127881 defendant Fisher John grocer 610044 610044 Fisher, John, of Abington, Berks, yeoman, grocer 1
4307494 2132759 2132759 defendant Wirye Robert fuller 610044 610044 Wirye, Robert, of Abington, Berks, fuller 2
4326758 2139303 2139303 defendant Selwood Christopher chapman 610044 610044 Selwood, Christopher, of Abington, Berks, chapman 0
4348279 2146650 2146650 defendant Francklyn Anthony blacksmith 610044 610044 Francklyn, Anthony, of Abington, Berks, blacksmith 0
4351040 2147618 2147618 defendant Francklyn Anthony blacksmith 610044 610044 Francklyn, Anthony, of Abington, Berks, blacksmith 0
4404067 2165929 2165929 defendant Sellwood Christopher chapman 610044 610044 Sellwood, Christopher, of Abington, Berks, chapman 2

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