names

35 rows where place_id = 601605

✎ 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
3646202 1909205 1909205 defendant Fletcher Thomas yeoman 601605 601605 Fletcher, Thomas, of Hill, yeoman 0
3657443 1912587 1912587 defendant Maltman John husbandman 601605 601605 Maltman, John, of Hill, husbandman 0
3947386 2006160 2006160 defendant Cloppam Henry husbandman 601605 601605 Cloppam, Henry, of Hill, husbandman 1
4068962 2049188 2049188 defendant Over John, senior yeoman 601605 601605 Over, John, senior, of Hill, yeoman 0
4113650 2065166 2065166 defendant Tatnall Thomas gent 601605 601605 Tatnall, Thomas, of Hill, or of Chessardyn, gent 0
4121721 2068066 2068066 defendant Rogers William   601605 601605 Rogers, William, of Hill, mason 1
4193946 2093443 2093443 defendant Asburner Thomas husbandman 601605 601605 Asburner, Thomas, of Hill, Cumber, husbandman 1
4226640 2104794 2104794 defendant Dethick William gent 601605 601605 Dethick, William, of Hill, or of Obden, Worcs, gent 0
4232209 2106769 2106769 defendant Garland Edward yeoman 601605 601605 (Garland, Edward, of Hill, yeoman 1
4232210 2106769 2106769 defendant Tilladam Joan spinster 601605 601605 Tilladam, Joan, of Hill, spinster 2
4238110 2108933 2108933 defendant Garlande John butcher 601605 601605 Garlande, John, of Hill, butcher 0
4240526 2109815 2109815 defendant Garlande John butcher 601605 601605 Garlande, John, of Hill, butcher 0
4267063 2118625 2118625 defendant Dethicke William gent 601605 601605 Dethicke, William, of Hill, or of Obden, Worcs, gent 0
4337292 2142775 2142775 defendant Blysse John   601605 601605 Blysse, John, of Hill, Warks husbandman 0
4392020 2161958 2161958 defendant Mordaunt John   601605 601605 Mordaunt, John, of Hill, gent, his son 1
4392021 2161958 2161958 defendant Prude Edward gent 601605 601605 Prude, Edward, of Hill, gent 2
4397191 2163635 2163635 defendant Tibbott Richard husbandman 601605 601605 Tibbott, Richard, of Hill, husbandman 0
4397864 2163863 2163863 defendant Parnell Hugh yeoman 601605 601605 Parnell, Hugh, of Hill, yeoman 1
4397865 2163863 2163863 defendant Thorne Edward weaver 601605 601605 Thorne, Edward, of Hill, weaver 2
4564561 2220475 2220475 defendant Maistre John   601605 601605 Maistre, John, of Hill 0
4564562 2220475 2220475 defendant Park William   601605 601605 Park, William, of Hill 1
4586562 2227206 2227206 defendant Fountenay Thomas   601605 601605 Fountenay, Thomas, of Hill 2
4618117 2236677 2236677 plaintiff Hall John   601605 601605 Hall, John, of Hill 0
4680914 2259655 2259655 defendant Boterhall William husbandman 601605 601605 Boterhall, William, of Hill, husbandman 1
4946646 2340951 2340951 defendant Thwaytes John gent 601605 601605 Thwaytes, John, of Hill, gent 0
5027019 2364774 2364774 defendant Hill Edward esq 601605 601605 Hill, Edward, of Hill, esq 0
5072115 2378149 2378149 defendant Sparowe Thomas husbandman 601605 601605 Sparowe, Thomas, of Hill, husbandman 3
5081369 2380934 2380934 plaintiff Crosse John   601605 601605 Crosse, John, of Hill 0
5231795 2424872 2424872 defendant Parys Thomas fuller 601605 601605 Parys, Thomas, of Hill, fuller 0
5345315 2458707 2458707 defendant Warmyngton William husbandman 601605 601605 Warmyngton, William, of Hill, husbandman 2
5375709 2467993 2467993 defendant Hill Richard husbandman 601605 601605 Hill, Richard, of Hill, husbandman 1
5458567 2492457 2492457 plaintiff Freman John   601605 601605 Freman, John, of Hill by Rider 0
5470202 2496005 2496005 plaintiff Freman John   601605 601605 Freman, John, of Hill by Rider or Ryther 0
5505158 2506522 2506522 defendant Stronge John husbandman 601605 601605 Stronge, John, of Hill, husbandman 0
5580287 2528920 2528920 defendant Petyt John husbandman 601605 601605 Petyt, John, of Hill, husbandman 4

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