names

196 rows where place_id = 587387

✎ 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
3591265 1864893 1864893 defendant Crotche John husbandman 587387 587387 Crotche, John, of Boton, husbandman 1
3596169 1866432 1866432 defendant Marchaunt John clerk 587387 587387 Marchaunt, John, of Boton, clerk 0
3614221 1872115 1872115 defendant Marchaunt John clerk 587387 587387 Marchaunt, John, of Boton, clerk 0
3630104 1904264 1904264 defendant Shyllyng John (legal representative) 587387 587387 Shyllyng, John, of Boton, yeoman, executor of 0
3718546 1932079 1932079 defendant Baxter William husbandman 587387 587387 Baxter, William, of Boton, husbandman 1
3748997 1941618 1941618 plaintiff Harward Robert esq 587387 587387 Harward, Robert, of Boton, esq 0
3750014 1941921 1941921 defendant Horsman John gent 587387 587387 Horsman, John, of Boton, gent 3
3758754 1944727 1944727 plaintiff Calthorp Henry (legal representative) 587387 587387 Calthorp, Henry, of Boton, esq, executor of 0
3758759 1944728 1944728 plaintiff Calthorp Henry (legal representative) 587387 587387 Calthorp, Henry, of Boton, esq, executor of 0
3763877 1946345 1946345 plaintiff Herward Robert gent 587387 587387 Herward, Robert, of Boton, gent 0
3764312 1946499 1946499 defendant Shellyng Roger husbandman 587387 587387 Shellyng, Roger, of Boton, husbandman 0
3781904 1952088 1952088 plaintiff Herward Robert gent 587387 587387 Herward, Robert, of Boton, gent 0
3798308 1957370 1957370 plaintiff Harward Robert gent 587387 587387 Harward, Robert, of Boton, gent 0
3815714 1962833 1962833 plaintiff Harward Robert gent 587387 587387 Harward, Robert, of Boton, gent 0
3816044 1962918 1962918 plaintiff Herward Robert gent 587387 587387 Herward, Robert, of Boton, gent 0
3816046 1962919 1962919 plaintiff Herward Robert gent 587387 587387 Herward, Robert, of Boton, gent 0
3847561 1972805 1972805 plaintiff Herward Robert, senior gent 587387 587387 Herward, Robert, senior, of Boton, gent 0
3862670 1977710 1977710 plaintiff Harward Robert gent 587387 587387 Harward, Robert, of Boton, gent 0
3862675 1977711 1977711 plaintiff Harward Robert gent 587387 587387 Harward, Robert, of Boton, gent 0
3895136 1988583 1988583 defendant Andrewe Thomas gent 587387 587387 Andrewe, Thomas, of Boton, gent 1
3904236 1991662 1991662 plaintiff Harward Henry gent 587387 587387 Harward, Henry, of Boton, gent 0
3904245 1991665 1991665 plaintiff Harwarde Henry gent 587387 587387 Harwarde, Henry, of Boton, gent 0
3906617 1992507 1992507 defendant Girney William gent 587387 587387 Girney, William, of Boton, gent 0
3918895 1996641 1996641 defendant Shillyng John yeoman 587387 587387 Shillyng, John, of Boton, yeoman 0
3943375 2004799 2004799 defendant Elwyne John butcher 587387 587387 Elwyne, John, of Boton, butcher 5
3944055 2005031 2005031 defendant Harward Thomas gent 587387 587387 Harward, Thomas, of Boton, gent 0
3944374 2005128 2005128 defendant Harward Thomas   587387 587387 Harward, Thomas, of Boton gent 0
3949354 2006846 2006846 defendant Harward Thomas gent 587387 587387 Harward, Thomas, of Boton, gent 0
3972819 2015066 2015066 defendant Croche John woolman 587387 587387 Croche, John, of Boton, woolman 0
4003421 2025986 2025986 defendant Fenton Edward clerk 587387 587387 Fenton, Edward, of Boton, clerk 0
4015051 2030076 2030076 defendant Harward Thomas gent 587387 587387 Harward, Thomas, of Boton, gent 2
4044708 2040555 2040555 defendant Croche John   587387 587387 Croche, John, of Boton, wool chapman 0
4044711 2040556 2040556 defendant Shakell Peter yeoman 587387 587387 Shakell, Peter, of Boton, yeoman 1
4044712 2040556 2040556 defendant Crocke John   587387 587387 Crocke, John, of Boton, wool chapman 2
4045423 2040814 2040814 defendant Shackell Peter yeoman 587387 587387 Shackell, Peter, of Boton, yeoman 0
4094891 2058504 2058504 defendant Pearne William gent 587387 587387 Pearne, William, of Boton, gent 0
4119013 2067083 2067083 defendant Arnold William gent 587387 587387 Arnold, William, of Boton, gent 0
4167347 2084079 2084079 defendant Arnold William gent 587387 587387 Arnold, William, of Boton, gent 0
4195848 2094103 2094103 defendant Crotche William   587387 587387 Crotche, William, of Boton, wool chapman 0
4208149 2098405 2098405 defendant Frary Christopher husbandman 587387 587387 Frary, Christopher, of Boton, or of Goodale Barnyngham, husbandman 0
4453641 2186151 2186151 defendant Letys John   587387 587387 Letys, John, of Boton 0
4459136 2187904 2187904 defendant Seman John   587387 587387 Seman, John, of Boton 1
4464969 2189710 2189710 defendant Rose Thomas   587387 587387 Rose, Thomas, of Boton 14
4465722 2189950 2189950 defendant Rose Thoams   587387 587387 Rose, Thoams, of Boton 6
4465724 2189950 2189950 defendant Sauser John   587387 587387 Sauser, John, of Boton 8
4476713 2193376 2193376 defendant Payn John   587387 587387 with Payn, John, of Boton 1
4486482 2196482 2196482 defendant Saucer John   587387 587387 Saucer, John, of Boton 1
4513730 2204724 2204724 defendant Waleys Thomas   587387 587387 Waleys, Thomas, of Boton 0
4525664 2208328 2208328 defendant Lenge Richard   587387 587387 Lenge, Richard, of Boton 6
4644071 2244364 2244364 defendant Cady John   587387 587387 Cady, John, of Boton 0
4659049 2248700 2248700 defendant Petevyn Roger yeoman 587387 587387 Petevyn, Roger, of Boton, yeoman 0
4663453 2250046 2250046 defendant Cady John yeoman 587387 587387 Cady, John, of Boton, yeoman 0
4682017 2259993 2259993 defendant Hovel Thomas butcher 587387 587387 Hovel, Thomas, of Boton, butcher 0
4687829 2261761 2261761 defendant Hovell Thomas husbandman 587387 587387 Hovell, Thomas, of Boton, husbandman 4
4718782 2271218 2271218 defendant Henk Richard flaxman 587387 587387 Henk, Richard, of Boton, flaxman 0
4727314 2273795 2273795 defendant Marchaunt John yeoman 587387 587387 Marchaunt, John, of Boton, yeoman 3
4745829 2279285 2279285 defendant Etton Robert yeoman 587387 587387 Etton, Robert, of Boton, yeoman 4
4746435 2279452 2279452 plaintiff Henk or Heuk Richard   587387 587387 Henk or Heuk, Richard, of Boton, on his own account 0
4746438 2279452 2279452 defendant Marchaunt John yeoman 587387 587387 Marchaunt, John, of Boton, yeoman 2
4761634 2283984 2283984 defendant Populton John husbandman 587387 587387 Populton, John, of Boton, husbandman 0
4795751 2294823 2294823 defendant Chapman John mercer 587387 587387 Chapman, John, of Boton, mercer 0
4810263 2299355 2299355 defendant Henke Robert husbandman 587387 587387 Henke, Robert, of Boton, husbandman 0
4848591 2311033 2311033 defendant Henk Richard yeoman 587387 587387 Henk, Richard, of Boton, yeoman 0
4897827 2325984 2325984 defendant Catys John husbandman 587387 587387 Catys, John, of Boton, husbandman 1
4897828 2325984 2325984 defendant Qwippe Peter husbandman 587387 587387 Qwippe, Peter, of Boton, husbandman 2
4897860 2325992 2325992 defendant Carter Robert mercer 587387 587387 Carter, Robert, of Boton, mercer 1
4901166 2326979 2326979 defendant Smyth Andrew smith 587387 587387 Smyth, Andrew, of Boton, smith 10
4902520 2327405 2327405 defendant Heweke Richard husbandman 587387 587387 Heweke, Richard, of Boton, husbandman 0
4953481 2343009 2343009 defendant Heweke Richard yeoman 587387 587387 Heweke, Richard, of Boton, yeoman 2
4970532 2348131 2348131 defendant Partryk John husbandman 587387 587387 Partryk, John, of Boton, husbandman 0
4970536 2348131 2348131 defendant Wygod Richard husbandman 587387 587387 Wygod, Richard, of Boton, husbandman 4
4987930 2353355 2353355 defendant Wright William husbandman 587387 587387 Wright, William, of Boton, husbandman 1
4989081 2353672 2353672 defendant Wryte William husbandman 587387 587387 Wryte, William, of Boton, husbandman 2
5001682 2357387 2357387 defendant Cake Nicholas husbandman 587387 587387 Cake, Nicholas, of Boton, husbandman 0
5004997 2358359 2358359 defendant Crede Thomas husbandman 587387 587387 Crede, Thomas, of Boton, husbandman 0
5007631 2359133 2359133 defendant Shillyng John husbandman 587387 587387 Shillyng, John, of boton, husbandman 0
5016312 2361661 2361661 defendant Crede John laborer 587387 587387 Crede, John, of Boton, laborer 0
5016313 2361661 2361661 defendant Cake Nicholas husbandman 587387 587387 Cake, Nicholas, of Boton, husbandman 1
5031388 2366036 2366036 defendant Catys John husbandman 587387 587387 Catys, John, of Boton, husbandman 3
5031530 2366081 2366081 defendant Brede John husbandman 587387 587387 Brede, John, of Boton, husbandman 3
5040867 2368886 2368886 plaintiff Catys John   587387 587387 Catys, John, of Boton 0
5059088 2374282 2374282 defendant Lyng Thomas husbandman 587387 587387 Lyng, Thomas, of Boton, husbandman 2
5061559 2375048 2375048 defendant Crede John husbandman 587387 587387 Crede, John, of Boton, husbandman 0
5061560 2375048 2375048 defendant Shillyng Roger husbandman 587387 587387 Shillyng, Roger, of Boton, husbandman 1
5065645 2376253 2376253 plaintiff Marchaunt John clerk 587387 587387 Marchaunt, John, of Boton, clerk 0
5070447 2377653 2377653 defendant Henke John yeoman 587387 587387 Henke, John, of Boton, yeoman 1
5074614 2378909 2378909 defendant Marchawn alias Aleynes John clerk 587387 587387 Marchawn alias Aleynes, John, of Boton, ,clerk 0
5075042 2379036 2379036 defendant Carter John yeoman 587387 587387 Carter, John, of Boton, yeoman 3
5075043 2379036 2379036 defendant Crede Thomas husbandman 587387 587387 Crede, Thomas, of Boton, husbandman 4
5078312 2380004 2380004 defendant Shillyng Roger husbandman 587387 587387 Shillyng, Roger, of Boton, husbandman 0
5087650 2382776 2382776 defendant Lyng Thomas husbandman 587387 587387 Lyng, Thomas, of Boton, husbandman 0
5087654 2382777 2382777 defendant Lyng Thomas husbandman 587387 587387 Lyng, Thomas, of Boton, husbandman 2
5092134 2384075 2384075 defendant Lyng Thomas gent 587387 587387 Lyng, Thomas, of Boton, gent 5
5094650 2384848 2384848 defendant Marchaunt John clerk 587387 587387 Marchaunt, John, of Boton, clerk 1
5100245 2386515 2386515 defendant Marchaunt John chaplain 587387 587387 Marchaunt, John, of Boton, clerk, or of Wychyngham St Mary, chaplain 0
5103415 2387426 2387426 defendant Heweke John yeoman 587387 587387 Heweke, John, of Boton, yeoman 0
5114449 2390624 2390624 plaintiff Lyng Thomas   587387 587387 Lyng, Thomas, of Boton 0
5114450 2390624 2390624 defendant Marchaunt John clerk 587387 587387 Marchaunt, John, of Boton, clerk 0
5117219 2391466 2391466 defendant Marchaunt John clerk 587387 587387 Marchaunt, John, of Boton, clerk 0
5117220 2391466 2391466 defendant Crede Thomas husbandman 587387 587387 Crede, Thomas, of Boton, husbandman 1

Next page

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