names

19 rows where place_id = 624429

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3758098 1944518 1944518 defendant Curedon John husbandman 624429 624429 Curedon, John, of Longeford, husbandman 0
4708344 2267982 2267982 defendant Yaneworth Thomas husbandman 624429 624429 Yaneworth, Thomas, of Longeford, husbandman 2
4763284 2284504 2284504 defendant Walys Richard husbandman 624429 624429 Walys, Richard, of Longeford, husbandman 4
4771694 2287123 2287123 defendant Yanworth Thomas husbandman 624429 624429 Yanworth, Thomas, of Longeford, husbandman 0
4835282 2307033 2307033 defendant Mabley Edmund yeoman 624429 624429 Mabley, Edmund, of Longeford, yeoman 1
4927421 2335008 2335008 defendant Wallewayn William (legal representative) 624429 624429 Wallewayn, William, of Longeford, gent, executors of 0
4927422 2335008 2335008 defendant Welden William gent 624429 624429 (Welden, William, of Longeford, gent 1
5229607 2424276 2424276 defendant Herberd Richard husbandman 624429 624429 Herberd, Richard, of Longeford, husbandman 0
5311140 2448361 2448361 defendant Tanner John yeoman 624429 624429 Tanner, John, of Longeford, yeoman 3
5317689 2450380 2450380 defendant Roberd John miller 624429 624429 Roberd, John, of Longeford, miller 0
5317690 2450380 2450380 defendant Tanner John yeoman 624429 624429 Tanner, John, of Longeford, yeoman 1
5317693 2450381 2450381 defendant Roberd John miller 624429 624429 Roberd, John, of Longeford, miller 0
5317694 2450381 2450381 defendant Tanner John yeoman 624429 624429 Tanner, John, of Longeford, yeoman 1
5433007 2484836 2484836 defendant Vowell William gent 624429 624429 Vowell, William, of Longeford Lester, gent 2
5554300 2521296 2521296 defendant Damerell Philip husbandman 624429 624429 Damerell, Philip, of Longeford Leyster, husbandman 0
5632094 2554061 2554061 defendant Grenehull John, junior ploughman 624429 624429 Grenehull, John, junior, of Longeford, ploughman 0
5632102 2554063 2554063 defendant Lambard Walter husbandman 624429 624429 Lambard, Walter, of Longeford, husbandman 0
5632103 2554063 2554063 defendant Holberewe John husbandman 624429 624429 Holberewe, John, of Longeford, husbandman 1
5632104 2554063 2554063 defendant Walssheman Morgan ploughman 624429 624429 Walssheman, Morgan, of Longeford, ploughman 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);