names

49 rows where place_id = 607996

✎ 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
3671780 1917165 1917165 defendant Gagney Richard roper 607996 607996 Gagney, Richard, of Parva Snoryng, roper 0
3680761 1920064 1920064 plaintiff Rychardson William   607996 607996 Rychardson, William, of Parva Snoryng 0
3710658 1929654 1929654 plaintiff Smyth Robert clerk 607996 607996 Smyth, Robert, of Parva Snoryng, clerk 0
3710722 1929674 1929674 defendant Nobell Richard tailor 607996 607996 Nobell, Richard, of Parva Snoryng, tailor 0
3711868 1930027 1930027 defendant Narburgh John husbandman 607996 607996 Narburgh, John, of Parva Snoryng, husbandman 1
3762725 1945983 1945983 defendant Rychardson William husbandman 607996 607996 Rychardson, William, of Parva Snoryng, husbandman 0
3782813 1952372 1952372 defendant Chesteney John husbandman 607996 607996 Chesteney, John, of Parva Snoryng, husbandman 0
3812816 1961906 1961906 defendant Gogney Richard husbandman 607996 607996 Gogney, Richard, of Parva Snoryng, husbandman 0
3812826 1961909 1961909 defendant Gogney Richard husbandman 607996 607996 Gogney, Richard, of Parva Snoryng, husbandman 0
3819592 1964004 1964004 defendant Chamberleyn Stephen husbandman 607996 607996 Chamberleyn, Stephen, of Parva Snoryng, husbandman 0
3819593 1964004 1964004 defendant Chesteny John husbandman 607996 607996 Chesteny, John, of Parva Snoryng, husbandman 1
3820901 1964432 1964432 defendant Gognay Richard roper 607996 607996 Gognay, Richard, of Parva Snoryng, roper 0
3855293 1975291 1975291 defendant Danyell Thomas thatcher 607996 607996 Danyell, Thomas, of Parva Snoryng, thatcher 1
3960671 2010832 2010832 defendant Nycholas William husbandman 607996 607996 Nycholas, William, of Parva Snoryng, husbandman 0
3960677 2010834 2010834 defendant Nycholas William husbandman 607996 607996 Nycholas, William, of Parva Snoryng, husbandman 0
4041800 2039549 2039549 plaintiff Nycholas Thomas yeoman 607996 607996 Nycholas, Thomas, of Parva Snoryng, yeoman 0
4041801 2039549 2039549 defendant Sheryngham Denis yeoman 607996 607996 Sheryngham, Denis, of Parva Snoryng, yeoman 0
4352224 2148012 2148012 defendant Leake Robert yeoman 607996 607996 Leake, Robert, of Parva Snoryng, yeoman 0
4352225 2148012 2148012 defendant Symond alias Semans James, junior yeoman 607996 607996 Symond alias Semans, James, junior, of Parva Snoryng, yeoman 1
4405358 2166371 2166371 defendant Leake Robert yeoman 607996 607996 Leake, Robert, of Parva Snoryng, yeoman 0
4405359 2166371 2166371 defendant Symond or Semans James, junior yeoman 607996 607996 Symond or Semans, James, junior, of Parva Snoryng, yeoman 1
4947252 2341129 2341129 defendant Harpour William husbandman 607996 607996 Harpour, William, of Parva Snoryng, husbandman 1
4952396 2342672 2342672 defendant Bryght John husbandman 607996 607996 Bryght, John, of Parva Snoryng, husbandman 1
4956196 2343818 2343818 defendant Clerk John yeoman 607996 607996 Clerk, John, of Parva Snoryng, yeoman 0
4956197 2343818 2343818 defendant Marchall Thomas husbandman 607996 607996 Marchall, Thomas, of Parva Snoryng, husbandman 1
4962114 2345576 2345576 defendant Bysshop Roger husbandman 607996 607996 Bysshop, Roger, of Parva Snoryng, husbandman 0
4962115 2345576 2345576 defendant Bright John husbandman 607996 607996 Bright, John, of Parva Snoryng, husbandman 1
4984858 2352399 2352399 defendant Harpour William husbandman 607996 607996 Harpour, William, of Parva Snoryng, husbandman 2
5062027 2375200 2375200 plaintiff Harpore William yeoman 607996 607996 Harpore, William, of Parva Snoryng, yeoman 0
5075319 2379117 2379117 defendant Harpour William husbandman 607996 607996 Harpour, William, of Parva Snoryng, husbandman 0
5082454 2381251 2381251 defendant Harpour William husbandman 607996 607996 Harpour, William, of Parva Snoryng, husbandman 0
5086073 2382318 2382318 plaintiff Harpore William yeoman 607996 607996 Harpore, William, of Parva Snoryng, yeoman 0
5094497 2384798 2384798 defendant Nele Thomas husbandman 607996 607996 Nele, Thomas, of Parva Snoryng, husbandman 0
5107471 2388614 2388614 defendant Harpour William husbandman 607996 607996 Harpour, William, of Parva Snoryng, husbandman 0
5111438 2389738 2389738 defendant Harpour William husbandman 607996 607996 Harpour, William, of Parva Snoryng, husbandman 0
5245537 2428853 2428853 defendant Gilberte John husbandman 607996 607996 Gilberte, John, of Parva Snoryng, husbandman 1
5245538 2428853 2428853 defendant Bakton Henry husbandman 607996 607996 Bakton, Henry, of Parva Snoryng, husbandman 2
5245539 2428853 2428853 defendant Crane John husbandman 607996 607996 Crane, John, of Parva Snoryng, husbandman 3
5278670 2438866 2438866 defendant Maryot John   607996 607996 Maryot, John, of Parva Snoryng, shepherd 0
5278671 2438866 2438866 defendant Bryght James   607996 607996 Bryght, James, of Parva Snoryng, shepherd 1
5286969 2441195 2441195 defendant Clerk John husbandman 607996 607996 Clerk, John, of Parva Snoryng, husbandman 2
5292842 2442899 2442899 defendant Mosse Walter baker 607996 607996 Mosse, Walter, of Parva Snoryng, baker 3
5323377 2452067 2452067 defendant Strete Nicholas husbandman 607996 607996 Strete, Nicholas, of Parva Snoryng, husbandman 2
5332315 2454730 2454730 defendant Gogeney John husbandman 607996 607996 Gogeney, John, of Parva Snoryng, husbandman 1
5343128 2458041 2458041 defendant Systern Henry yeoman 607996 607996 Systern, Henry, of Parva Snoryng, yeoman 0
5343617 2458187 2458187 defendant Gogney John husbandman 607996 607996 Gogney, John, of Parva Snoryng, husbandman 0
5349984 2460125 2460125 plaintiff Clerk Thomas (legal representative) 607996 607996 Clerk, Thomas, of Parva Snoryng, executor of 0
5580869 2529091 2529091 defendant Sawer Nicholas husbandman 607996 607996 Sawer, Nicholas, of Parva Snoryng, husbandman 7
5605345 2536550 2536550 defendant Sawyer Nicholas carpenter 607996 607996 Sawyer, Nicholas, of Parva Snoryng, carpenter 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);