names

53 rows where place_id = 604390

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657859 1912707 1912707 defendant Gylbert George husbandman 604390 604390 Gylbert, George, of Ampthill, husbandman 0
3732160 1936294 1936294 defendant Gilbert Anne widow 604390 604390 (Gilbert, Anne, of Ampthill, widow 1
3732161 1936294 1936294 defendant Russell Thomas butcher 604390 604390 Russell, Thomas, of Ampthill, butcher 2
3760048 1945139 1945139 defendant Boughton William husbandman 604390 604390 Boughton, William, of Ampthill, husbandman 0
3898139 1989585 1989585 defendant Russell Edward butcher 604390 604390 Russell, Edward, of Ampthill, butcher 2
4267465 2118752 2118752 defendant Lyle Richard yeoman 604390 604390 Lyle, Richard, of Ampthill, yeoman 1
4303850 2131478 2131478 defendant Burrowes Humphrey yeoman 604390 604390 Burrowes, Humphrey, of Ampthill, yeoman 2
4307255 2132676 2132676 defendant Hood George yeoman 604390 604390 Hood, George, of Ampthill, yeoman 1
4359924 2150713 2150713 defendant Woodward Edward chapman 604390 604390 Woodward, Edward, of Ampthill, chapman 0
4412325 2168711 2168711 defendant Beard Thomas chapman 604390 604390 Beard, Thomas, of Ampthill, chapman 0
4704817 2266886 2266886 plaintiff Jurdon John   604390 604390 Jurdon, John, of Ampthill 0
4704819 2266887 2266887 plaintiff Jurdon John   604390 604390 Jurdon, John, of Ampthill 0
4704825 2266888 2266888 plaintiff Jurdon John   604390 604390 Jurdon, John, of Ampthill 0
4712942 2269362 2269362 defendant Ampthull John husbandman 604390 604390 Ampthull, John, of Ampthill, husbandman 0
4735624 2276293 2276293 plaintiff Stephenes William   604390 604390 Stephenes, William, of Ampthill 0
4737271 2276775 2276775 defendant atte Chirche Roger husbandman 604390 604390 atte Chirche, Roger, of Ampthill, husbandman 1
4771686 2287121 2287121 plaintiff Shephird John   604390 604390 Shephird, John, of Ampthill 0
4813441 2300317 2300317 plaintiff Hichecok William   604390 604390 Hichecok, William, of Ampthill 0
4882723 2321514 2321514 plaintiff Alford Adam   604390 604390 Alford, Adam, of Ampthill 0
4896445 2325556 2325556 defendant Wodecok George husbandman 604390 604390 (Wodecok, George, of Ampthill, husbandman 1
4905723 2328391 2328391 plaintiff Alford Adam   604390 604390 Alford, Adam, of Ampthill 0
4931665 2336292 2336292 plaintiff Burrych Thomas husbandman 604390 604390 (Burrych, Thomas, of Ampthill, husbandman 1
4931860 2336352 2336352 defendant Burrych Thomas husbandman 604390 604390 (Burrych, Thomas, of Ampthill, husbandman 1
4959006 2344659 2344659 plaintiff Aldebury Richard   604390 604390 Aldebury, Richard, of Ampthill 0
5022698 2363548 2363548 defendant Caunvyle William plumber 604390 604390 Caunvyle, William, of Ampthill, plumber 2
5044013 2369836 2369836 defendant Bekyrstaff John smith 604390 604390 Bekyrstaff, John, of Ampthill, smith 0
5090980 2383758 2383758 defendant Alford Adam (legal representative) 604390 604390 Alford, Adam, of Ampthill, esq, executors of 0
5090982 2383758 2383758 defendant Gerveys John esq 604390 604390 Gerveys, John, of Ampthill, esq 2
5090983 2383758 2383758 defendant Pounde William yeoman 604390 604390 Pounde, William, of Ampthill, yeoman 3
5090984 2383758 2383758 defendant Borych William yeoman 604390 604390 Borych, William, of Ampthill, yeoman 4
5090986 2383759 2383759 defendant Alford Adam (legal representative) 604390 604390 Alford, Adam, of Ampthill, esq, executors of 0
5090988 2383759 2383759 defendant Gerveys John esq 604390 604390 Gerveys, John, of Ampthill, esq 2
5090989 2383759 2383759 defendant Pounde William yeoman 604390 604390 Pounde, William, of Ampthill, yeoman 3
5090990 2383759 2383759 defendant Borych William yeoman 604390 604390 Borych, William, of Ampthill, yeoman 4
5110978 2389605 2389605 defendant Tylere Henry   604390 604390 Tylere, Henry, of Ampthill, tile maker 0
5110979 2389605 2389605 defendant Hertyshyll Thomas   604390 604390 Hertyshyll, Thomas, of Ampthill, tile maker 1
5165996 2405797 2405797 defendant Twyngge John carpenter 604390 604390 Twyngge, John, of Ampthill, carpenter 2
5165997 2405797 2405797 defendant Ryder John husbandman 604390 604390 Ryder, John, of Ampthill, husbandman 3
5165998 2405797 2405797 defendant Malerbe Henry husbandman 604390 604390 Malerbe, Henry, of Ampthill, husbandman 4
5180744 2410108 2410108 defendant Twyngge John carpenter 604390 604390 Twyngge, John, of Ampthill, carpenter 2
5180745 2410108 2410108 defendant Ryder Peter husbandman 604390 604390 Ryder, Peter, of Ampthill, husbandman 3
5180746 2410108 2410108 defendant Malerbe Henry husbandman 604390 604390 Malerbe, Henry, of Ampthill, husbandman 4
5180751 2410109 2410109 defendant Twyngge John carpenter 604390 604390 Twyngge, John, of Ampthill, carpenter 2
5180752 2410109 2410109 defendant Ryder Peter husbandman 604390 604390 Ryder, Peter, of Ampthill, husbandman 3
5180753 2410109 2410109 defendant Malerbe Henry husbandman 604390 604390 Malerbe, Henry, of Ampthill, husbandman 4
5260889 2433527 2433527 defendant Grey Edmund   604390 604390 Grey, Edmund, of Ampthill, knight, Earl of Kent, Lord Grey of Ruthyn 0
5260893 2433528 2433528 defendant Grey Edmund   604390 604390 Grey, Edmund, of Ampthill, knight, Earl of Kent, Lord Grey of Ruthyn 0
5279070 2438986 2438986 defendant FitzHugh William gent 604390 604390 FitzHugh, William, of Ampthill, gent 1
5279074 2438987 2438987 defendant FitzHugh William gent 604390 604390 FitzHugh, William, of Ampthill, gent 1
5359705 2463073 2463073 defendant Malerbe Henry   604390 604390 Malerbe, Henry, of Ampthill, tallow chandler 2
5482087 2499577 2499577 defendant Hopkyns John yeoman 604390 604390 Hopkyns, John, of Ampthill, yeoman 0
5482089 2499578 2499578 defendant Hopkyns John yeoman 604390 604390 Hopkyns, John, of Ampthill, yeoman 0
5602337 2535627 2535627 defendant Davy John butcher 604390 604390 Davy, John, of Ampthill, butcher 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);