names

46 rows where place_id = 616814

✎ 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
3659220 1913140 1913140 plaintiff Gefferey John (legal representative) 616814 616814 Gefferey, John, of Dulverton, executrix of 0
3716288 1931387 1931387 defendant Wolcote William husbandman 616814 616814 Wolcote, William, of Dulverton, husbandman 0
3716289 1931387 1931387 defendant William Alice widow 616814 616814 William, Alice, of Dulverton, widow 1
3716290 1931387 1931387 defendant Chylcote Christopher husbandman 616814 616814 Chylcote, Christopher, of Dulverton, husbandman 2
3716291 1931387 1931387 defendant Chylcote Thomas husbandman 616814 616814 Chylcote, Thomas, of Dulverton, husbandman 3
3716292 1931387 1931387 defendant Chylcote John husbandman 616814 616814 Chylcote, John, of Dulverton, husbandman 4
3760592 1945312 1945312 defendant Wyllyams Robert husbandman 616814 616814 Wyllyams, Robert, of Dulverton, husbandman 0
3791489 1955176 1955176 defendant Wyllyams Robert husbandman 616814 616814 Wyllyams, Robert, of Dulverton, husbandman 0
3943260 2004765 2004765 defendant Skynner Richard yeoman 616814 616814 Skynner, Richard, of Dulverton, yeoman 3
3992840 2022192 2022192 defendant Glosse William   616814 616814 Glosse, William, of Dulverton, groom 0
4113505 2065111 2065111 plaintiff Sydenham John esq 616814 616814 Sydenham, John, of Dulverton, esq 0
4150683 2078378 2078378 defendant Glasse John husbandman 616814 616814 Glasse, John, of Dulverton, husbandman 0
4208831 2098633 2098633 defendant Rawyns John husbandman 616814 616814 Rawyns, John, of Dulverton, husbandman 2
4261384 2116772 2116772 defendant Hurley Richard husbandman 616814 616814 Hurley, Richard, of Dulverton, husbandman 0
4313238 2134739 2134739 defendant Holwill John husbandman 616814 616814 Holwill, John, of Dulverton, husbandman 0
4359791 2150664 2150664 defendant Tucker alias Atwere John weaver 616814 616814 Tucker alias Atwere, John, of Dulverton, weaver 1
4359792 2150664 2150664 defendant Tucker alias Atwere Peter weaver 616814 616814 Tucker alias Atwere, Peter, of Dulverton, weaver 2
4409705 2167846 2167846 defendant Case Thomas yeoman 616814 616814 Case, Thomas, of Dulverton, yeoman 1
4444970 2183400 2183400 defendant Jacson Thomas   616814 616814 Jacson, Thomas, of Dulverton 5
4487895 2196932 2196932 defendant Knyghtcote John   616814 616814 Knyghtcote, John, of Dulverton 0
4556195 2217880 2217880 defendant Helebrigge Alice   616814 616814 Helebrigge, Alice, of Dulverton 2
4567374 2221354 2221354 defendant Glosse John   616814 616814 Glosse, John, of Dulverton 0
4567378 2221356 2221356 defendant Glosse John   616814 616814 Glosse, John, of Dulverton 0
4567379 2221356 2221356 defendant Harpyston William   616814 616814 Harpyston, William, of Dulverton 1
4640328 2243286 2243286 defendant Sydenham Robert   616814 616814 Sydenham, Robert, of Dulverton 0
4657665 2248285 2248285 defendant Sydenham Robert   616814 616814 Sydenham, Robert, of Dulverton 5
4660889 2249230 2249230 defendant Sydenham Robert gent 616814 616814 Sydenham, Robert, of Dulverton, gent 1
4688378 2261932 2261932 defendant Hoper John   616814 616814 Hoper, John, of Dulverton, vicar 0
4688380 2261933 2261933 defendant Hoper John   616814 616814 Hoper, John, of Dulverton, vicar 0
4688381 2261933 2261933 defendant Hoper Robert yeoman 616814 616814 Hoper, Robert, of Dulverton, yeoman 1
4688382 2261933 2261933 defendant Combe John yeoman 616814 616814 Combe, John, of Dulverton, yeoman 2
4688383 2261933 2261933 defendant Leystowe John   616814 616814 Leystowe, John, of Dulverton, holy water clerk 3
4822518 2303116 2303116 defendant Hille William husbandman 616814 616814 Hille, William, of Dulverton, husbandman 3
4839247 2308202 2308202 defendant Rothenassh Robert baker 616814 616814 Rothenassh, Robert, of Dulverton, baker 0
4839248 2308202 2308202 defendant Turnour Thomas   616814 616814 Turnour, Thomas, of Dulverton, mason 1
4839249 2308202 2308202 defendant Hurdecombe Peter husbandman 616814 616814 Hurdecombe, Peter, of Dulverton, husbandman 2
4895607 2325297 2325297 defendant Halswell John husbandman 616814 616814 Halswell, John, of Dulverton, husbandman 0
4895610 2325298 2325298 defendant Halswell John husbandman 616814 616814 Halswell, John, of Dulverton, husbandman 0
4989216 2353708 2353708 defendant Pecheman John skinner 616814 616814 Pecheman, John, of Dulverton, skinner 2
5032331 2366335 2366335 defendant Childecote John husbandman 616814 616814 Childecote, John, of Dulverton, husbandman 1
5034941 2367078 2367078 defendant Slade William husbandman 616814 616814 Slade, William, of Dulverton, husbandman 0
5034942 2367078 2367078 defendant Pytte John husbandman 616814 616814 Pytte, John, of Dulverton, husbandman 1
5034943 2367078 2367078 defendant atte Spyre Geoffrey husbandman 616814 616814 atte Spyre, Geoffrey, of Dulverton, husbandman 2
5348915 2459790 2459790 defendant Touker John tucker 616814 616814 Touker, John, of Dulverton, tucker 1
5348916 2459790 2459790 defendant Geffreys William shoemaker 616814 616814 Geffreys, William, of Dulverton, shoemaker 2
5633097 2554357 2554357 defendant Bryt John husbandman 616814 616814 Bryt, John, of Dulverton, husbandman 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);