names

49 rows where place_id = 609160

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3677262 1918936 1918936 defendant Burrell John husbandman 609160 609160 Burrell, John, of Dockyng, husbandman 0
3775159 1949964 1949964 defendant Lambard Thomas butcher 609160 609160 Lambard, Thomas, of Dockyng, butcher 0
3836766 1969398 1969398 defendant Houghton Roger yeoman 609160 609160 Houghton, Roger, of Dockyng, yeoman 0
3836767 1969398 1969398 defendant Warner Thomas yeoman 609160 609160 Warner, Thomas, of Dockyng, yeoman 1
3881115 1983954 1983954 defendant Warner Robert yeoman 609160 609160 Warner, Robert, of Dockyng, yeoman 0
3891170 1987312 1987312 defendant Oghton Roger   609160 609160 Oghton, Roger, of Dockyng 1
3944221 2005083 2005083 defendant Aleyne Humphrey husbandman 609160 609160 Aleyne, Humphrey, of Dockyng, husbandman 0
3946758 2005934 2005934 defendant Cryspe Roger husbandman 609160 609160 Cryspe, Roger, of Dockyng, husbandman 0
3946760 2005935 2005935 defendant Cryspede Roger husbandman 609160 609160 Cryspede, Roger, of Dockyng, husbandman 0
3962936 2011634 2011634 defendant Mundes William yeoman or merchant 609160 609160 Mundes, William, of Dockyng, yeoman or merchant 0
3975265 2015918 2015918 defendant Wandham alias Barvell John husbandman 609160 609160 Wandham alias Barvell, John, of Dockyng, husbandman 0
4009121 2028028 2028028 plaintiff Myddlebrook Richard husbandman 609160 609160 Myddlebrook, Richard, of Dockyng, husbandman 0
4019154 2031588 2031588 plaintiff Warner alias Jenyson Alice widow 609160 609160 Warner alias Jenyson, Alice, of Dockyng, widow 0
4019156 2031589 2031589 plaintiff Warner Alice widow 609160 609160 Warner, Alice, of Dockyng, widow 0
4033623 2036674 2036674 defendant Allen Edmund husbandman 609160 609160 Allen, Edmund, of Dockyng, husbandman 0
4042890 2039934 2039934 defendant Wandham alias Barvell John husbandman 609160 609160 Wandham alias Barvell, John, of Dockyng, husbandman 0
4050254 2042519 2042519 plaintiff Warner John yeoman 609160 609160 Warner, John, of Dockyng, yeoman 0
4052371 2043269 2043269 defendant Graye John husbandman 609160 609160 Graye, John, of Dockyng, husbandman 0
4080353 2053286 2053286 defendant Cryspe Roger yeoman 609160 609160 Cryspe, Roger, of Dockyng, yeoman 0
4178330 2087891 2087891 defendant Rychers John yeoman 609160 609160 Rychers, John, of Dockyng, yeoman 2
4404823 2166180 2166180 defendant Hawtrey George husbandman 609160 609160 Hawtrey, George, of Dockyng, husbandman 2
4507092 2202686 2202686 defendant Wylby Nicholas   609160 609160 Wylby, Nicholas, of Dockyng 0
4580029 2225240 2225240 defendant Bryd Richard   609160 609160 Bryd, Richard, of Dockyng 0
4725858 2273374 2273374 defendant Wayn Richard husbandman 609160 609160 Wayn, Richard, of Dockyng, husbandman 0
4729363 2274402 2274402 plaintiff Lavenham John   609160 609160 Lavenham, John, of Dockyng 0
4855002 2312917 2312917 defendant Wylly John yeoman 609160 609160 Wylly, John, of Dockyng, yeoman 3
5052993 2372490 2372490 defendant Warner John yeoman 609160 609160 Warner, John, of Dockyng, yeoman 3
5099886 2386403 2386403 defendant Warner John husbandman 609160 609160 Warner, John, of Dockyng, husbandman 0
5100158 2386488 2386488 plaintiff Wylly John   609160 609160 Wylly, John, of Dockyng 0
5101951 2386992 2386992 plaintiff Lawys alias Ferrour William   609160 609160 Lawys alias Ferrour, William, of Dockyng 1
5110788 2389553 2389553 defendant Ferrour William yeoman 609160 609160 Ferrour, William, of Dockyng, yeoman 1
5118245 2391775 2391775 defendant Ferrour William yeoman 609160 609160 Ferrour, William, of Dockyng, yeoman 1
5125622 2393984 2393984 plaintiff Lawys alias Ferrour William   609160 609160 Lawys alias Ferrour, William, of Dockyng 1
5128453 2394795 2394795 defendant Ferrour William yeoman 609160 609160 Ferrour, William, of Dockyng, yeoman 8
5142597 2398963 2398963 defendant Warner John husbandman 609160 609160 Warner, John, of Dockyng, husbandman 0
5147550 2400423 2400423 defendant Ferrour William yeoman 609160 609160 Ferrour, William, of Dockyng, yeoman 8
5163980 2405203 2405203 defendant Warner John husbandman 609160 609160 Warner, John, of Dockyng, husbandman 0
5167199 2406139 2406139 defendant Ferrour William yeoman 609160 609160 Ferrour, William, of Dockyng, yeoman 5
5272128 2436931 2436931 defendant Ferrour John yeoman 609160 609160 Ferrour, John, of Dockyng, yeoman 0
5272129 2436931 2436931 defendant Taverner Richard butcher 609160 609160 Taverner, Richard, of Dockyng, butcher 1
5286698 2441120 2441120 defendant Taverner Richard butcher 609160 609160 Taverner, Richard, of Dockyng, butcher 0
5286699 2441120 2441120 defendant Ferrour John, senior yeoman 609160 609160 Ferrour, John, senior, of Dockyng, yeoman 1
5286706 2441121 2441121 defendant Taverner Richard butcher 609160 609160 Taverner, Richard, of Dockyng, butcher 0
5286707 2441121 2441121 defendant Ferrour John, senior yeoman 609160 609160 Ferrour, John, senior, of Dockyng, yeoman 1
5374843 2467727 2467727 defendant Warner John, senior husbandman 609160 609160 Warner, John, senior, of Dockyng, husbandman 1
5377992 2468696 2468696 defendant Houghton John yeoman 609160 609160 Houghton, John, of Dockyng, yeoman 0
5429080 2483624 2483624 defendant Houghton Robert husbandman 609160 609160 Houghton, Robert, of Dockyng, husbandman 4
5463610 2494031 2494031 defendant Warner William husbandman 609160 609160 Warner, William, of Dockyng, husbandman 0
5606788 2537009 2537009 defendant Warner Thomas husbandman 609160 609160 Warner, Thomas, of Dockyng, husbandman 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);