names

22 rows where place_id = 599281

✎ 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
3636094 1906080 1906080 defendant Apken Thomas husbandman 599281 599281 Apken, Thomas, of Thelnetham, husbandman 0
3842943 1971327 1971327 defendant Hardy John husbandman 599281 599281 Hardy, John, of Thelnetham, husbandman 0
4123412 2068677 2068677 defendant Buckenham or Bucknam Edmund esq 599281 599281 Buckenham or Bucknam, Edmund, of Thelnetham, esq 0
4123415 2068678 2068678 defendant Duckenham Edmund esq 599281 599281 Duckenham, Edmund, of Thelnetham, esq 0
4459377 2187985 2187985 defendant Heyward John   599281 599281 Heyward, John, of Thelnetham 1
4546201 2214758 2214758 defendant Wade John   599281 599281 Wade, John, of Thelnetham, parson 0
4551338 2216356 2216356 defendant Wade John   599281 599281 Wade, John, of Thelnetham, parson 0
4567500 2221393 2221393 plaintiff Lopham John   599281 599281 Lopham, John, of Thelnetham 4
4694462 2263762 2263762 defendant Skynnere Thomas tailor 599281 599281 Skynnere, Thomas, of Thelnetham, tailor 1
4956208 2343820 2343820 plaintiff Rookwode William esq 599281 599281 Rookwode, William, of Thelnetham, esq 4
4966364 2346873 2346873 defendant Gladewyn Thomas yeoman 599281 599281 Gladewyn, Thomas, of Thelnetham, yeoman 2
5013869 2360908 2360908 defendant Cace Stephen husbandman 599281 599281 Cace, Stephen, of Thelnetham, husbandman 0
5015091 2361297 2361297 defendant Cace Stephen husbandman 599281 599281 Cace, Stephen, of Thelnetham, husbandman 0
5082641 2381314 2381314 defendant Payn Robert yeoman 599281 599281 Payn, Robert, of Thelnetham, yeoman 1
5482506 2499710 2499710 defendant Symond Thomas husbandman 599281 599281 Symond, Thomas, of Thelnetham, husbandman 2
5495030 2503411 2503411 defendant Hardy Thomas husbandman 599281 599281 Hardy, Thomas, of Thelnetham, husbandman 0
5495031 2503411 2503411 defendant Hardy Nicholas laborer 599281 599281 Hardy, Nicholas, of Thelnetham, laborer 1
5495032 2503411 2503411 defendant Hardy Thomas laborer 599281 599281 Hardy, Thomas, of Thelnetham, laborer 2
5495033 2503411 2503411 defendant Hardy William laborer 599281 599281 Hardy, William, of Thelnetham, laborer 3
5496895 2504001 2504001 defendant Batman John husbandman 599281 599281 Batman, John, of Thelnetham, husbandman 1
5540076 2517020 2517020 defendant Hardy Nicholas (legal representative) 599281 599281 Hardy, Nicholas, of Thelnetham, yeoman, executrix of 0
5540077 2517020 2517020 defendant Hardy Katherine widow 599281 599281 Hardy, Katherine, of Thelnetham, widow 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);