names

28 rows where place_id = 599845

✎ 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
3638507 1906858 1906858 defendant Leche Thomas husbandman 599845 599845 Leche, Thomas, of West Bekham, husbandman 5
3638514 1906859 1906859 defendant Leche Thomas husbandman 599845 599845 Leche, Thomas, of West Bekham, husbandman 5
3651961 1910958 1910958 defendant Leche Thomas husbandman 599845 599845 Leche, Thomas, of West Bekham, husbandman 5
3652012 1910979 1910979 defendant Shepherd John yeoman 599845 599845 Shepherd, John, of West Bekham, yeoman 1
3663479 1914503 1914503 defendant Doughty John husbandman 599845 599845 Doughty, John, of West Bekham, husbandman 1
3682441 1920609 1920609 defendant Dowty Thomas husbandman 599845 599845 Dowty, Thomas, of West Bekham, husbandman 2
3697592 1925469 1925469 defendant Dow- Thomas husbandman 599845 599845 Dow-, Thomas, of West Bekham, husbandman 2
3707078 1928502 1928502 defendant Pestell Simon husbandman 599845 599845 Pestell, Simon, of West Bekham, husbandman 0
3707079 1928502 1928502 defendant Pestell John husbandman 599845 599845 Pestell, John, of West Bekham, husbandman 1
3735509 1937345 1937345 defendant Pestell Simon husbandman 599845 599845 Pestell, Simon, of West Bekham, husbandman 1
3765816 1946973 1946973 defendant Shepherd Stephen husbandman 599845 599845 Shepherd, Stephen, of West Bekham, husbandman 0
3837939 1969779 1969779 defendant Botoll Adam husbandman 599845 599845 Botoll, Adam, of West Bekham, husbandman 1
3866624 1979067 1979067 defendant Buttoll Adam (legal representative) 599845 599845 Buttoll, Adam, of West Bekham, executors of 0
3866625 1979067 1979067 defendant Shepperd John husbandman 599845 599845 (Shepperd, John, of West Bekham, husbandman 1
4746122 2279362 2279362 defendant Shepherd William yeoman 599845 599845 Shepherd, William, of West Bekham, yeoman 1
4831219 2305794 2305794 defendant Shepherd William yeoman 599845 599845 Shepherd, William, of West Bekham, yeoman 1
5092541 2384196 2384196 defendant Shepherd William yeoman 599845 599845 Shepherd, William, of West Bekham, yeoman 1
5093843 2384599 2384599 defendant Benet Nicholas clerk 599845 599845 Benet, Nicholas, of West Bekham, clerk 1
5206596 2417662 2417662 defendant Shepherd John husbandman 599845 599845 Shepherd, John, of West Bekham, husbandman 4
5230927 2424653 2424653 defendant Macke William laborer 599845 599845 Macke, William, of West Bekham, laborer 1
5320478 2451208 2451208 plaintiff Jory Nicholas   599845 599845 Jory, Nicholas, of West Bekham 0
5364202 2464461 2464461 plaintiff (illegible) Nicholas   599845 599845 ---, Nicholas, of West Bekham 0
5376576 2468274 2468274 plaintiff Shepherd Nicholas   599845 599845 Shepherd, Nicholas, of West Bekham 0
5587755 2531189 2531189 defendant Pestell Simon husbandman 599845 599845 Pestell, Simon, of West Bekham, husbandman 0
5587756 2531189 2531189 defendant Lussher Alexander   599845 599845 Lussher, Alexander, of West Bekham, shepherd 1
5587757 2531189 2531189 defendant Shepherd William, junior husbandman 599845 599845 Shepherd, William, junior, of West Bekham, husbandman 2
5604045 2536127 2536127 defendant Shephard John husbandman 599845 599845 Shephard, John, of West Bekham, husbandman 1
5609474 2537859 2537859 plaintiff Shepherd Nicholas   599845 599845 Shepherd, Nicholas, of West Bekham 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);