names

34 rows where place_id = 588713

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595338 1866174 1866174 defendant Taillour John husbandman 588713 588713 Taillour, John, of Harley, husbandman 0
3595339 1866174 1866174 defendant Whythynton Thomas husbandman 588713 588713 Whythynton, Thomas, of Harley, husbandman 1
3595340 1866174 1866174 defendant Crompe William husbandman 588713 588713 Crompe, William, of Harley, husbandman 2
3598158 1867053 1867053 defendant Butler Thomas yeoman 588713 588713 Butler, Thomas, of Harley, yeoman 0
3648100 1909799 1909799 defendant Hethcote Nicholas yeoman 588713 588713 Hethcote, Nicholas, of Harley, yeoman 2
3805976 1959805 1959805 defendant Decon Humphrey yeoman 588713 588713 Decon, Humphrey, of Harley, yeoman 0
3805977 1959805 1959805 defendant Bayley alias Blakewey Thomas yeoman 588713 588713 Bayley alias Blakewey, Thomas, of Harley, yeoman 1
3805978 1959805 1959805 defendant Lee Richard husbandman 588713 588713 Lee, Richard, of Harley, husbandman 2
3955081 2008841 2008841 defendant Hyll Richard yeoman or "deyman" 588713 588713 Hyll, Richard, of Harley, or of Wollaston, yeoman or "deyman" 0
4048374 2041864 2041864 plaintiff Taylor Edward, senior   588713 588713 Taylor, Edward, senior, of Harley 0
4048377 2041865 2041865 plaintiff Taylor Edward, senior yeoman 588713 588713 Taylor, Edward, senior, of Harley, yeoman 0
4089516 2056537 2056537 defendant Selman alias Collyns Roger husbandman 588713 588713 Selman alias Collyns, Roger, of Harley, husbandman 0
4100150 2060386 2060386 defendant Bell Michael clerk 588713 588713 Bell, Michael, of Harley, clerk 0
4100152 2060387 2060387 defendant Collyns alias Selman Roger husbandman 588713 588713 Collyns alias Selman, Roger, of Harley, husbandman 0
4254704 2114564 2114564 defendant Jurden John husbandman 588713 588713 Jurden, John, of Harley, husbandman 0
4320555 2137281 2137281 defendant Heathcott Roland yeoman 588713 588713 Heathcott, Roland, of Harley, yeoman 2
4351192 2147666 2147666 defendant Betchcott Thomas (legal representative) 588713 588713 Betchcott, Thomas, of Harley, yeoman, administratrix of 0
4351193 2147666 2147666 defendant Betchcott Anne widow 588713 588713 Betchcott, Anne, of Harley, widow 1
4375257 2156205 2156205 defendant Betchcott Thomas (legal representative) 588713 588713 Betchcott, Thomas, of Harley, yeoman, administratrix of 0
4375258 2156205 2156205 defendant Betchcott Anne yeoman 588713 588713 Betchcott, Anne, of Harley, yeoman 1
4382314 2158784 2158784 defendant Eves William smith 588713 588713 Eves, William, of Harley, or of Wokingham, Berks, smith 0
4444939 2183390 2183390 plaintiff Stapulford William   588713 588713 Stapulford, William, of Harley, parson of the church 1
4585780 2226973 2226973 defendant Donyngton William   588713 588713 Donyngton, William, of Harley 1
4732764 2275423 2275423 defendant Wyke John yeoman 588713 588713 Wyke, John, of Harley, yeoman 2
5143193 2399144 2399144 defendant Broke Thomas yeoman 588713 588713 Broke, Thomas, of Harley, yeoman 1
5164544 2405363 2405363 defendant Broke Thomas yeoman 588713 588713 Broke, Thomas, of Harley, yeoman 1
5469330 2495757 2495757 defendant Boteler Thomas   588713 588713 Boteler, Thomas, of Harley, mason 1
5477783 2498374 2498374 defendant Hardyng William husbandman 588713 588713 Hardyng, William, of Harley, husbandman 2
5480495 2499138 2499138 defendant Mason alias Boteler Thomas yeoman 588713 588713 Mason alias Boteler, Thomas, of Harley, yeoman 0
5527490 2513180 2513180 defendant Cristofer William husbandman 588713 588713 Cristofer, William, of Harley, husbandman 0
5527491 2513180 2513180 defendant Tayllour William husbandman 588713 588713 Tayllour, William, of Harley, husbandman 1
5527495 2513180 2513180 defendant Dorset William husbandman 588713 588713 Dorset, William, of Harley, husbandman 5
5527498 2513180 2513180 defendant Sprotte William husbandman 588713 588713 Sprotte, William, of Harley, husbandman 8
5631548 2553878 2553878 defendant Wyke John husbandman 588713 588713 Wyke, John, of Harley, 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);