names

32 rows where place_id = 720743

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643457 1908381 1908381 defendant Songer Robert yeoman 720743 720743 Songer, Robert, of Tolleshunt Knights, yeoman 0
3706939 1928455 1928455 plaintiff Kyngesman John yeoman 720743 720743 Kyngesman, John, of Tolleshunt Mager, yeoman 0
3901881 1990854 1990854 defendant Norden Henry husbandman 720743 720743 Norden, Henry, of Tolleshunt Knight, husbandman 1
4236179 2108223 2108223 defendant Lowe John husbandman 720743 720743 Lowe, John, of Tolleshunt, husbandman 0
4279856 2122869 2122869 defendant Fulke Thomas clerk 720743 720743 Fulke, Thomas, of Tolleshunt Knights, clerk 1
4445164 2183457 2183457 defendant Boys John   720743 720743 Boys, John, of Tolleshunt 0
4445167 2183458 2183458 defendant Boys John   720743 720743 Boys, John, of Tolleshunt 0
4659362 2248788 2248788 defendant Merke John husbandman 720743 720743 Merke, John, of Tolleshunt Manger, husbandman 0
4659369 2248790 2248790 defendant Clyfford John husbandman 720743 720743 Clyfford, John, of Tolleshunt Manger, husbandman 0
4660127 2249014 2249014 defendant atte Hull Richard yeoman 720743 720743 atte Hull, Richard, of Tolleshunt, yeoman 0
4660130 2249014 2249014 defendant Jurdon John herder 720743 720743 Jurdon, John, of Tolleshunt, herder 3
4660131 2249014 2249014 defendant Hedyman John herder 720743 720743 Hedyman, John, of Tolleshunt, herder 4
4660133 2249014 2249014 defendant Judde Thomas yeoman 720743 720743 Judde, Thomas, of Tolleshunt, yeoman 6
4703462 2266465 2266465 plaintiff Hervy John husbandman 720743 720743 Hervy, John, of Tolleshunt Manger, husbandman 0
4799830 2296129 2296129 defendant Perot Peter husbandman 720743 720743 Perot, Peter, of Tolleshunt, husbandman 1
5134024 2396448 2396448 defendant Hedych John yeoman 720743 720743 Hedych, John, of Tolleshunt Maunger, yeoman 1
5134029 2396449 2396449 defendant Hedych John yeoman 720743 720743 Hedych, John, of Tolleshunt Maunger, yeoman 1
5144129 2399435 2399435 defendant Doget Robert husbandman 720743 720743 Doget, Robert, of Tolleshunt Knights, husbandman 1
5165072 2405528 2405528 defendant Doget Robert husbandman 720743 720743 Doget, Robert, of Tolleshunt Knights, husbandman 1
5178778 2409515 2409515 defendant Doget Robert husbandman 720743 720743 Doget, Robert, of Tolleshunt Knights, husbandman 1
5235871 2426071 2426071 defendant Paternoster John husbandman 720743 720743 Paternoster, John, of Tolleshunt, husbandman 0
5235872 2426071 2426071 defendant Cukkoo John husbandman 720743 720743 Cukkoo, John, of Tolleshunt Chenaler, husbandman 1
5268773 2435984 2435984 defendant Melhouse John waterman 720743 720743 Melhouse, John, of Tolleshunt, waterman 0
5282379 2439908 2439908 defendant Wynter Thomas timbermonger 720743 720743 Wynter, Thomas, of Tolleshunt Knight, timbermonger 1
5333360 2455051 2455051 defendant Merke John yeoman 720743 720743 Merke, John, of Tolleshunt, yeoman 0
5350136 2460167 2460167 defendant Fuller Thomas yeoman 720743 720743 Fuller, Thomas, of Tolleshunt Mauger, yeoman 0
5584000 2530067 2530067 defendant Songer Robert husbandman 720743 720743 Songer, Robert, of Tolleshunt, husbandman 0
5584002 2530068 2530068 defendant Songer Robert husbandman 720743 720743 Songer, Robert, of Tolleshunt, husbandman 0
5584004 2530068 2530068 defendant Colbeyn John husbandman 720743 720743 Colbeyn, John, of Tolleshunt, husbandman 2
5584005 2530068 2530068 defendant Mellons John husbandman 720743 720743 Mellons, John, of Tolleshunt, husbandman 3
5584006 2530068 2530068 defendant Essex John husbandman 720743 720743 Essex, John, of Tolleshunt, husbandman 4
5584892 2530353 2530353 plaintiff Higham Thomas esq 720743 720743 Higham, Thomas, of Tolleshunt, esq 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);