names

43 rows where place_id = 595531

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620903 1874101 1874101 plaintiff Kellegh Thomas chaplain 595531 595531 Kellegh, Thomas, of Blyston, chaplain 1
3620905 1874101 1874101 defendant Hokke Thomas husbandman 595531 595531 Hokke, Thomas, of Blyston, husbandman 1
3744714 1940240 1940240 defendant Martyn Robert yeoman 595531 595531 Martyn, Robert, of Blyston, yeoman 0
3753441 1943015 1943015 defendant Dawe Nicholas husbandman 595531 595531 Dawe, Nicholas, of Blyston, husbandman 0
3832969 1968231 1968231 defendant John John, junior husbandman 595531 595531 John, John, junior, of Blyston, husbandman 2
3832971 1968231 1968231 defendant Hawkyn Thomas husbandman 595531 595531 Hawkyn, Thomas, of Blyston, husbandman 4
3832972 1968231 1968231 defendant Thome Nicholas miller 595531 595531 Thome, Nicholas, of Blyston, miller 5
3832973 1968231 1968231 defendant Harvy John husbandman 595531 595531 Harvy, John, of Blyston, husbandman 6
3847165 1972668 1972668 defendant Ley John husbandman 595531 595531 Ley, John, of Blyston, husbandman 0
4475974 2193155 2193155 defendant Lankelly Richard   595531 595531 Lankelly, Richard, of Blyston 3
4475990 2193157 2193157 defendant Lankelly Richard   595531 595531 Lankelly, Richard, of Blyston 3
4693446 2263451 2263451 defendant Trenref John   595531 595531 Trenref, John, of Blyston, tyn blower or tin blower 0
4697496 2264703 2264703 defendant Cakwade Richard fuller 595531 595531 Cakwade, Richard, of Blyston, fuller 0
4715332 2270130 2270130 plaintiff Wall John, sen   595531 595531 Wall, John, sen, of Blyston 0
4717094 2270676 2270676 defendant Garth Thomas   595531 595531 Garth, Thomas, of Blyston, parson 1
4717102 2270678 2270678 defendant Carthu Thomas   595531 595531 Carthu, Thomas, of Blyston, parson 2
4769841 2286543 2286543 defendant Beane John   595531 595531 Beane, John, of Blyston, tin man 2
4769842 2286543 2286543 defendant Wal_ John   595531 595531 Wal_, John, of Blyston, tin man 3
4793381 2294032 2294032 plaintiff Broun John   595531 595531 Broun, John, of Blyston 1
4939405 2338707 2338707 defendant Olyver Henry yeoman 595531 595531 Olyver, Henry, of Blyston, yeoman 1
4948910 2341643 2341643 defendant Robyn Henry husbandman 595531 595531 Robyn, Henry, of Blyston, husbandman 0
4948911 2341643 2341643 defendant Gyllowe Richard husbandman 595531 595531 Gyllowe, Richard, of Blyston, husbandman 1
4948912 2341643 2341643 defendant Hobbe Henry husbandman 595531 595531 Hobbe, Henry, of Blyston, husbandman 2
4948913 2341643 2341643 defendant Bodynyell John husbandman 595531 595531 Bodynyell, John, of Blyston, husbandman 3
4965096 2346485 2346485 defendant Olyver Henry yeoman 595531 595531 Olyver, Henry, of Blyston, yeoman 0
5063882 2375730 2375730 defendant Olyver William husbandman 595531 595531 Olyver, William, of Blyston, husbandman 0
5063883 2375730 2375730 defendant Langeston John husbandman 595531 595531 Langeston, John, of Blyston, husbandman 1
5063884 2375730 2375730 defendant Walke Thomas yeoman 595531 595531 Walke, Thomas, of Blyston, yeoman 2
5063885 2375730 2375730 defendant Pengelly Herbert husbandman 595531 595531 Pengelly, Herbert, of Blyston, husbandman 3
5063887 2375731 2375731 defendant Olyver William husbandman 595531 595531 Olyver, William, of Blyston, husbandman 0
5063888 2375731 2375731 defendant Langeston John husbandman 595531 595531 Langeston, John, of Blyston, husbandman 1
5063889 2375731 2375731 defendant Walke Thomas yeoman 595531 595531 Walke, Thomas, of Blyston, yeoman 2
5063890 2375731 2375731 defendant Pengelly Hervy husbandman 595531 595531 Pengelly, Hervy, of Blyston, husbandman 3
5065214 2376131 2376131 defendant Hobbe John tailor 595531 595531 Hobbe, John, of Blyston, tailor 2
5102031 2387020 2387020 defendant Langeston Thomas yeoman 595531 595531 Langeston, Thomas, of Blyston, yeoman 2
5102036 2387021 2387021 defendant Langeston Thomas yeoman 595531 595531 Langeston, Thomas, of Blyston, yeoman 2
5139522 2398046 2398046 defendant Brewode Robert husbandman 595531 595531 Brewode, Robert, of Blyston, husbandman 1
5148774 2400763 2400763 defendant Durfold Thomas   595531 595531 Durfold, Thomas, of Blyston, franklin 0
5148775 2400763 2400763 defendant Stappe Thomas   595531 595531 Stappe, Thomas, of Blyston 1
5487692 2501208 2501208 defendant Hobbe William husbandman 595531 595531 Hobbe, William, of Blyston, husbandman 3
5487693 2501208 2501208 defendant Lyghtfote Robert husbandman 595531 595531 Lyghtfote, Robert, of Blyston, husbandman 4
5487696 2501208 2501208 defendant Cok Thomas yeoman 595531 595531 Cok, Thomas, of Blyston, yeoman 7
5502574 2505724 2505724 defendant Pontsyde Thomas clerk 595531 595531 Pontsyde, Thomas, of Blyston, clerk 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);