names

27 rows where place_id = 615143

✎ 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
3707378 1928598 1928598 defendant Alys John husbandman 615143 615143 Alys, John, of South Clyfton, husbandman 0
3727005 1934713 1934713 defendant Ursewhyte Richard husbandman 615143 615143 Ursewhyte, Richard, of South Clyfton, husbandman 0
3791287 1955107 1955107 defendant Pepe Ralph husbandman 615143 615143 Pepe, Ralph, of South Clyfton, husbandman 3
3864380 1978283 1978283 defendant Mason Thomas husbandman 615143 615143 Mason, Thomas, of South Clyfton, husbandman 0
3864382 1978284 1978284 defendant Mason Thomas husbandman 615143 615143 Mason, Thomas, of South Clyfton, husbandman 0
3899532 1990059 1990059 defendant Collet John yeoman 615143 615143 Collet, John, of South Clyfton, yeoman 0
3899533 1990059 1990059 defendant Howeson Alexander yeoman 615143 615143 Howeson, Alexander, of South Clyfton, yeoman 1
3946739 2005927 2005927 defendant Fotoft George husbandman 615143 615143 Fotoft, George, of South Clyfton, husbandman 0
4165111 2083304 2083304 defendant Stowe Robert yeoman 615143 615143 Stowe, Robert, of South Clyfton, yeoman 0
4458191 2187600 2187600 plaintiff Pye John   615143 615143 Pye, John, of South Clyfton 0
4833089 2306367 2306367 defendant Clerk William fisherman 615143 615143 Clerk, William, of South Clyfton, fisherman 1
4859976 2314488 2314488 defendant Clerk William fisher 615143 615143 Clerk, William, of South Clyfton, fisher 1
4872129 2318244 2318244 defendant Barowe John butcher 615143 615143 Barowe, John, of South Clyfton, butcher 2
4878198 2320132 2320132 defendant Howson Thomas husbandman 615143 615143 Howson, Thomas, of South Clyfton, husbandman 1
4878199 2320132 2320132 defendant Boron William husbandman 615143 615143 Boron, William, of South Clyfton, husbandman 2
4894176 2324870 2324870 defendant Adam John laborer 615143 615143 Adam, John, of South Clyfton, laborer 8
4986924 2353031 2353031 defendant Adam John husbandman 615143 615143 Adam, John, of South Clyfton, husbandman 0
5091508 2383908 2383908 defendant Hoker Thomas husbandman 615143 615143 Hoker, Thomas, of South Clyfton, husbandman 0
5156475 2403049 2403049 defendant Hoker Thomas, sen husbandman 615143 615143 Hoker, Thomas, sen, of South Clyfton, husbandman 2
5172670 2407734 2407734 defendant Hoker Thomas, sen husbandman 615143 615143 Hoker, Thomas, sen, of South Clyfton, husbandman 2
5192341 2413497 2413497 defendant Hoker Thomas, sen husbandman 615143 615143 Hoker, Thomas, sen, of South Clyfton, husbandman 2
5293426 2443048 2443048 defendant Dymmok John yeoman 615143 615143 Dymmok, John, of South Clyfton, yeoman 3
5295976 2443810 2443810 defendant Dymmok John gent 615143 615143 Dymmok, John, of South Clyfton, gent 0
5295980 2443811 2443811 defendant Dymmok John gent 615143 615143 Dymmok, John, of South Clyfton, gent 0
5347638 2459417 2459417 defendant Hoker Thomas husbandman 615143 615143 Hoker, Thomas, of South Clyfton, husbandman 0
5347645 2459418 2459418 defendant Hoker Thomas husbandman 615143 615143 Hoker, Thomas, of South Clyfton, husbandman 0
5423015 2481832 2481832 defendant Hoker Thomas yeoman 615143 615143 Hoker, Thomas, of South Clyfton, yeoman 2

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