names

26 rows where place_id = 646450

✎ 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
3890941 1987234 1987234 defendant Maye Thomas yeoman 646450 646450 Maye, Thomas, of Wadhurst, yeoman 1
4314956 2135343 2135343 defendant Bayley Roger smith 646450 646450 Bayley, Roger, of Wadhurst, smith 0
4364830 2152474 2152474 defendant Olyfe William husbandman 646450 646450 Olyfe, William, of Wadhurst, husbandman 2
4405572 2166435 2166435 defendant Baker Joseph yeoman 646450 646450 Baker, Joseph, of Wadhurst, yeoman 0
4405573 2166435 2166435 defendant Laffam alias Laughton Abraham yeoman 646450 646450 Laffam alias Laughton, Abraham, of Wadhurst, yeoman 1
4405575 2166436 2166436 defendant Laffam alias Laugham Abraham yeoman 646450 646450 Laffam alias Laugham, Abraham, of Wadhurst, yeoman 0
4687513 2261687 2261687 defendant Coresley William yeoman 646450 646450 Coresley, William, of Wadhurst, yeoman 0
4696333 2264334 2264334 defendant Kynchewode Richard tanner 646450 646450 Kynchewode, Richard, of Wadhurst, tanner 3
4696338 2264334 2264334 defendant Thurgote Thomas husbandman 646450 646450 Thurgote, Thomas, of Wadhurst, husbandman 8
4706010 2267253 2267253 defendant Sparwe John   646450 646450 Sparwe, John, of Wadhurst, lock smith 0
4706011 2267253 2267253 defendant Sparwe Thomas   646450 646450 Sparwe, Thomas, of Wadhurst, wheel wright 1
4706012 2267253 2267253 defendant Benge Thomas   646450 646450 Benge, Thomas, of Wadhurst, lock smith 2
4707764 2267796 2267796 defendant Shotyngherst John husbandman 646450 646450 Shotyngherst, John, of Wadhurst, husbandman 1
4760991 2283783 2283783 plaintiff Deraunt William   646450 646450 Deraunt, William, of Wadhurst 0
4769114 2286316 2286316 defendant Steeke Thomas   646450 646450 Steeke, Thomas, of Wadhurst, nail maker or glove maker 20
4769504 2286442 2286442 defendant Meleward John husbandman 646450 646450 Meleward, John, of Wadhurst, husbandman 0
4772837 2287474 2287474 defendant Erle Thomas husbandman 646450 646450 Erle, Thomas, of Wadhurst, husbandman 0
4829954 2305412 2305412 defendant Steelde Thomas   646450 646450 Steelde, Thomas, of Wadhurst, nail maker 2
4834661 2306843 2306843 defendant Pope Thomas husbandman 646450 646450 Pope, Thomas, of Wadhurst, husbandman 0
4845667 2310158 2310158 defendant atte Mille Richard husbandman 646450 646450 atte Mille, Richard, of Wadhurst, husbandman 0
4998728 2356507 2356507 defendant Freke William husbandman 646450 646450 Freke, William, of Wadhurst, husbandman 2
5199032 2415468 2415468 defendant Turk William butcher 646450 646450 Turk, William, of Wadhurst, butcher 0
5203401 2416756 2416756 defendant Leveshoth Robert   646450 646450 Leveshoth, Robert, of Wadhurst, blade smith 1
5369813 2466148 2466148 defendant Cretynden Simon   646450 646450 Cretynden, Simon, of Wadhurst, administrators of 3
5369815 2466148 2466148 defendant Crotynden Thomas laborer 646450 646450 Crotynden, Thomas, of Wadhurst, laborer 5
5443707 2488041 2488041 defendant Leneshethe John smith 646450 646450 Leneshethe, John, of Wadhurst, smith 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);