names

64 rows where place_id = 587754

✎ 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
3592348 1865222 1865222 defendant Daldy John pewterer 587754 587754 Daldy, John, of Byllyngford, pewterer 3
3642777 1908188 1908188 defendant Dogdon Edward yeoman 587754 587754 Dogdon, Edward, of Byllyngford, yeoman 8
3663469 1914500 1914500 defendant Balamond John   587754 587754 Balamond, John, of Byllyngford, shepherd 1
3696589 1925166 1925166 defendant Feltwell Robert yeoman 587754 587754 Feltwell, Robert, of Byllyngford, yeoman 0
3715901 1931258 1931258 defendant Barton John clerk 587754 587754 Barton, John, of Byllyngford, clerk 0
3737885 1938069 1938069 defendant Feltwell John, junior pewterer 587754 587754 Feltwell, John, junior, of Byllyngford, pewterer 0
3755048 1943529 1943529 defendant Tolle Robert husbandman 587754 587754 Tolle, Robert, of Byllyngford, husbandman 1
3811789 1961587 1961587 defendant Stegyll Robert husbandman 587754 587754 Stegyll, Robert, of Byllyngford, husbandman 2
3815147 1962657 1962657 defendant Gayton Thomas chaplain 587754 587754 Gayton, Thomas, of Byllyngford, chaplain 2
3818670 1963743 1963743 defendant Darmyng Patrick yeoman 587754 587754 Darmyng, Patrick, of Byllyngford, yeoman 0
3818671 1963743 1963743 defendant Sturston Nicholas husbandman 587754 587754 Sturston, Nicholas, of Byllyngford, husbandman 1
3830314 1967375 1967375 defendant Gates John butcher 587754 587754 Gates, John, of Byllyngford, butcher 0
3857974 1976141 1976141 plaintiff Bealys Edward yeoman 587754 587754 Bealys, Edward, of Byllyngford, yeoman 0
3857977 1976142 1976142 plaintiff Bealys Edward yeoman 587754 587754 Bealys, Edward, of Byllyngford, yeoman 0
3872150 1980916 1980916 defendant Fytte Richard husbandman 587754 587754 Fytte, Richard, of Byllyngford, husbandman 1
3872256 1980945 1980945 plaintiff Belys Edmund   587754 587754 Belys, Edmund, of Byllyngford 0
3885456 1985392 1985392 plaintiff Beales Edward   587754 587754 Beales, Edward, of Byllyngford 0
3885463 1985394 1985394 defendant Fytte William laborer 587754 587754 Fytte, William, of Byllyngford, laborer 0
3899252 1989961 1989961 plaintiff Bealys Edward   587754 587754 Bealys, Edward, of Byllyngford 0
3913339 1994796 1994796 plaintiff Bealys Edmund   587754 587754 Bealys, Edmund, of Byllyngford 0
3944673 2005236 2005236 plaintiff Beales Edmund (legal representative) 587754 587754 Beales, Edmund, of Byllyngford, executors of 0
3944678 2005237 2005237 plaintiff Beales Edmund (legal representative) 587754 587754 Beales, Edmund, of Byllyngford, executors of 0
3944777 2005271 2005271 defendant Turner John tailor 587754 587754 Turner, John, of Byllyngford, tailor 4
3986929 2020068 2020068 defendant Clawdell Elizabeth widow 587754 587754 Clawdell, Elizabeth, of Byllyngford, widow 0
3996690 2023579 2023579 defendant Tompson Andrew husbandman 587754 587754 Tompson, Andrew, of Byllyngford, husbandman 3
4148040 2077447 2077447 defendant Brese Edmund tailor 587754 587754 Brese, Edmund, of Byllyngford, tailor 1
4284192 2124395 2124395 defendant Clarke John laborer 587754 587754 Clarke, John, of Byllyngford, laborer 1
4437517 2176489 2176489 defendant Pyles John   587754 587754 Pyles, John, of Byllyngford 1
4546242 2214769 2214769 plaintiff Curson William   587754 587754 Curson, William, of Byllyngford 6
4873287 2318598 2318598 defendant Swanbek Walter laborer 587754 587754 Swanbek, Walter, of Byllyngford, laborer 1
4873288 2318598 2318598 defendant Childe John laborer 587754 587754 Childe, John, of Byllyngford, laborer 2
4890935 2323911 2323911 plaintiff Codlyng Joan   587754 587754 Codlyng, Joan, of Byllyngford 5
4890939 2323911 2323911 plaintiff Codlyng Roger, senior   587754 587754 Codlyng, Roger, senior, of Byllyngford 9
4890940 2323911 2323911 plaintiff Codlyng Roger, junior   587754 587754 Codlyng, Roger, junior, of Byllyngford 10
4890941 2323911 2323911 plaintiff Codlyng Simon   587754 587754 Codlyng, Simon, of Byllyngford 11
4890942 2323911 2323911 plaintiff Codlyng Thomas   587754 587754 Codlyng, Thomas, of Byllyngford 12
4890943 2323911 2323911 plaintiff Codlyng Adam   587754 587754 Codlyng, Adam, of Byllyngford 13
4890950 2323911 2323911 plaintiff Codlyng Margaret   587754 587754 Codlyng, Margaret, of Byllyngford 20
4890953 2323911 2323911 plaintiff Codlyng Katherine   587754 587754 Codlyng, Katherine, of Byllyngford 23
4947348 2341165 2341165 defendant Yardle Hugh (legal representative) 587754 587754 Yardle, Hugh, of Byllyngford, executors of 0
4947350 2341165 2341165 defendant Yardlee Joan widow 587754 587754 Yardlee, Joan, of Byllyngford, widow 2
5012063 2360376 2360376 defendant Childer John husbandman 587754 587754 Childer, John, of Byllyngford, husbandman 1
5074207 2378770 2378770 defendant Broun Henry tailor 587754 587754 Broun, Henry, of Byllyngford, tailor 1
5074208 2378770 2378770 defendant Rose Robert tailor 587754 587754 Rose, Robert, of Byllyngford, tailor 2
5124544 2393642 2393642 plaintiff -erdele Hugh   587754 587754 -erdele, Hugh, of Byllyngford 0
5150352 2401233 2401233 defendant Thurstone Robert husbandman 587754 587754 Thurstone, Robert, of Byllyngford, husbandman 0
5160807 2404256 2404256 defendant Lyng Thomas (legal representative) 587754 587754 Lyng, Thomas, of Byllyngford, gent, executors of 4
5165892 2405769 2405769 defendant Wafyn William clerk 587754 587754 Wafyn, William, of Byllyngford, clerk 0
5183490 2410909 2410909 defendant Jerbrigge Adam husbandman 587754 587754 Jerbrigge, Adam, of Byllyngford, husbandman 0
5234956 2425804 2425804 defendant Ludham Hugh husbandman 587754 587754 Ludham, Hugh, of Byllyngford, husbandman 0
5234957 2425804 2425804 defendant Codlyng Adam husbandman 587754 587754 Codlyng, Adam, of Byllyngford, husbandman 1
5350973 2460417 2460417 defendant Crome John husbandman 587754 587754 Crome, John, of Byllyngford, husbandman 2
5380217 2469390 2469390 defendant Crome John yeoman 587754 587754 Crome, John, of Byllyngford, yeoman 0
5380537 2469485 2469485 defendant Crome John   587754 587754 Crome, John, of Byllyngford 0
5389008 2471910 2471910 defendant Brome John yeoman 587754 587754 Brome, John, of Byllyngford, yeoman 0
5401705 2475546 2475546 defendant Crome Joh yeoman 587754 587754 Crome, Joh, of Byllyngford, yeoman 0
5401707 2475547 2475547 defendant Crome John   587754 587754 Crome, John, of Byllyngford 0
5419809 2480840 2480840 defendant Crome John yeoman 587754 587754 Crome, John, of Byllyngford, yeoman 0
5435833 2485659 2485659 defendant Pefaker Richard yeoman 587754 587754 Pefaker, Richard, of Byllyngford, yeoman 1
5435834 2485659 2485659 defendant Crome John yeoman 587754 587754 Crome, John, of Byllyngford, yeoman 2
5475845 2497779 2497779 defendant Crome John yeoman 587754 587754 Crome, John, of Byllyngford, yeoman 0
5517985 2510469 2510469 defendant Smyth alias Bailly Thomas chapman 587754 587754 Smyth alias Bailly, Thomas, of Byllyngford, chapman 3
5589159 2531616 2531616 defendant Curson Thomas esq 587754 587754 Curson, Thomas, of Byllyngford, esq 0
5596456 2533803 2533803 defendant Martyn Thomas husbandman 587754 587754 Martyn, Thomas, of Byllyngford, 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);