names

53 rows where place_id = 607697

✎ 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
3670460 1916718 1916718 defendant Jakson Thomas carpenter 607697 607697 Jakson, Thomas, of Helmesley, carpenter 0
3789776 1954634 1954634 defendant Bawde Ralph yeoman 607697 607697 Bawde, Ralph, of Helmesley, yeoman 0
3925641 1998887 1998887 plaintiff Wright Robert gent 607697 607697 Wright, Robert, of Helmesley, gent 0
3925642 1998887 1998887 defendant Williamson Christopher yeoman 607697 607697 Williamson, Christopher, of Helmesley, yeoman 0
3981730 2018225 2018225 defendant Hamleton Ralph shoemaker 607697 607697 Hamleton, Ralph, of Helmesley, shoemaker 0
4037684 2038128 2038128 defendant Bentley William yeoman 607697 607697 Bentley, William, of Helmesley, yeoman 0
4061136 2046392 2046392 plaintiff Downynge John yeoman 607697 607697 Downynge, John, of Helmesley, yeoman 0
4146950 2077081 2077081 defendant Rucke Richard yeoman 607697 607697 Rucke, Richard, of Helmesley, yeoman 2
4179778 2088402 2088402 defendant Greathead George vintner 607697 607697 Greathead, George, of Helmesley, vintner 0
4259676 2116210 2116210 defendant Longe William yeoman 607697 607697 Longe, William, of Helmesley, yeoman 2
4259681 2116211 2116211 defendant Longe William yeoman 607697 607697 Longe, William, of Helmesley, yeoman 2
4289166 2126180 2126180 defendant Warde Thomas tanner 607697 607697 Warde, Thomas, of Helmesley, tanner 0
4289168 2126181 2126181 defendant Warde Thomas tanner 607697 607697 Warde, Thomas, of Helmesley, tanner 0
4350348 2147383 2147383 defendant Kettlewell Edward husbandman 607697 607697 Kettlewell, Edward, of Helmesley, husbandman 0
4350352 2147385 2147385 defendant Johnson George yeoman 607697 607697 Johnson, George, of Helmesley, yeoman 0
4386789 2160251 2160251 defendant Buttrye John chapman 607697 607697 Buttrye, John, of Helmesley, chapman 1
4392619 2162153 2162153 defendant Buttrie John chapman 607697 607697 Buttrie, John, of Helmesley, chapman 0
4392620 2162153 2162153 defendant Storte alias Pustwithe George chapman 607697 607697 Storte alias Pustwithe, George, of Helmesley, chapman 1
4392621 2162153 2162153 defendant Goodyon Peter chapman 607697 607697 Goodyon, Peter, of Helmesley, chapman 2
4397906 2163877 2163877 defendant Hekdon Richard tanner 607697 607697 Hekdon, Richard, of Helmesley, tanner 0
4459844 2188133 2188133 plaintiff Saweton William   607697 607697 Saweton, William, of Helmesley 0
4561825 2219634 2219634 plaintiff Perstehay John   607697 607697 Perstehay, John, of Helmesley 0
4577056 2224333 2224333 defendant del Hall Stephen shoemaker 607697 607697 del Hall, Stephen, of Helmesley, shoemaker 0
4621962 2237846 2237846 defendant Smyth John   607697 607697 Smyth, John, of Helmesley 3
4662309 2249686 2249686 plaintiff Forster Robert   607697 607697 Forster, Robert, of Helmesley 0
4677562 2258595 2258595 defendant Forester Robert yeoman 607697 607697 Forester, Robert, of Helmesley, yeoman 0
4684411 2260730 2260730 defendant Overton Thomas yeoman 607697 607697 Overton, Thomas, of Helmesley, yeoman 0
4684420 2260731 2260731 defendant Overton Thomas yeoman 607697 607697 Overton, Thomas, of Helmesley, yeoman 0
4734245 2275887 2275887 plaintiff Salton William   607697 607697 Salton, William, of Helmesley 0
4734246 2275887 2275887 defendant Webster Thomas weaver 607697 607697 Webster, Thomas, of Helmesley, weaver 0
4806611 2298278 2298278 defendant Godewyn John butcher 607697 607697 Godewyn, John, of Helmesley, butcher 0
4808822 2298926 2298926 defendant Danby John butcher 607697 607697 Danby, John, of Helmesley, butcher 2
4810775 2299494 2299494 defendant Howesson Richard butcher 607697 607697 Howesson, Richard, of Helmesley, butcher 0
4824046 2303596 2303596 defendant Gudwyn William baker 607697 607697 Gudwyn, William, of Helmesley, baker 1
4878041 2320086 2320086 defendant Lokton John narker 607697 607697 Lokton, John, of Helmesley, narker 2
4895930 2325393 2325393 defendant Clay John gent 607697 607697 Clay, John, of Helmesley, gent 0
4898834 2326279 2326279 defendant Danby John butcher 607697 607697 Danby, John, of Helmesley, butcher 0
4901495 2327071 2327071 defendant Clay John gent 607697 607697 Clay, John, of Helmesley, gent 0
4913890 2330850 2330850 defendant de Lese John husbandman 607697 607697 de Lese, John, of Helmesley, husbandman 4
4931819 2336338 2336338 defendant Barbour Thomas barber 607697 607697 Barbour, Thomas, of Helmesley, barber 0
4957489 2344210 2344210 defendant Herton William yeoman 607697 607697 Herton, William, of Helmesley, yeoman 0
4957497 2344212 2344212 defendant Turnay William (legal representative) 607697 607697 Turnay, William, of Helmesley, executors of 0
4957499 2344212 2344212 defendant Skynner Robert glover 607697 607697 Skynner, Robert, of Helmesley, glover 2
4957500 2344212 2344212 defendant Homerton William barker 607697 607697 Homerton, William, of Helmesley, barker 3
4957501 2344212 2344212 defendant Barton William tailor 607697 607697 Barton, William, of Helmesley, tailor 4
5032626 2366425 2366425 defendant Pever Thomas chapman 607697 607697 Pever, Thomas, of Helmesley, chapman 2
5049631 2371514 2371514 defendant Paver Thomas mercer 607697 607697 Paver, Thomas, of Helmesley, mercer 0
5200209 2415819 2415819 defendant Hode John yeoman 607697 607697 Hode, John, of Helmesley, yeoman 0
5239107 2427029 2427029 defendant Tyndale William chapman 607697 607697 Tyndale, William, of Helmesley, chapman 6
5336056 2455861 2455861 defendant Kyrke William yeoman 607697 607697 Kyrke, William, of Helmesley, yeoman 1
5336057 2455861 2455861 defendant Chaloner Thomas fisher 607697 607697 Chaloner, Thomas, of Helmesley, fisher 2
5492858 2502774 2502774 defendant Brabayn Robert yeoman 607697 607697 Brabayn, Robert, of Helmesley, yeoman 0
5502176 2505606 2505606 defendant Penyman John dyer 607697 607697 (Penyman, John, of Helmesley, dyer 1

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