names

38 rows where place_id = 594076

✎ 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
3614338 1872138 1872138 defendant Trewechylde John husbandman 594076 594076 Trewechylde, John, of Chigwell, or of Stapleford, husbandman 4
3614483 1872177 1872177 defendant Broke John husbandman 594076 594076 Broke, John, of Chigwell, husbandman 1
3614486 1872177 1872177 defendant Harr John husbandman 594076 594076 Harr, John, of Chigwell, husbandman 4
3710309 1929540 1929540 defendant Coke Thomas gent 594076 594076 Coke, Thomas, of Chigwell, gent 4
3710315 1929541 1929541 defendant Coke Thomas gent 594076 594076 Coke, Thomas, of Chigwell, gent 4
3842378 1971149 1971149 defendant Baker William carpenter 594076 594076 Baker, William, of Chigwell, carpenter 0
3934431 2001810 2001810 defendant Swete William husbandman 594076 594076 Swete, William, of Chigwell, husbandman 0
3934432 2001810 2001810 defendant Fuller Thomas husbandman 594076 594076 Fuller, Thomas, of Chigwell, husbandman 1
3947585 2006218 2006218 defendant Herde John husbandman 594076 594076 Herde, John, of Chigwell, husbandman 1
4338540 2143231 2143231 defendant Engleton Edward husbandman 594076 594076 Engleton, Edward, of Chigwell, husbandman 1
4338541 2143231 2143231 defendant Hayett Nicholas husbandman 594076 594076 Hayett, Nicholas, of Chigwell, husbandman 2
4343341 2144943 2144943 defendant Spackman Thomas yeoman 594076 594076 Spackman, Thomas, of Chigwell, yeoman 1
4361837 2151395 2151395 defendant Ingleton Edward husbandman 594076 594076 Ingleton, Edward, of Chigwell, husbandman 1
4361838 2151395 2151395 defendant Hayatt Nicholas husbandman 594076 594076 Hayatt, Nicholas, of Chigwell, husbandman 2
4384425 2159481 2159481 defendant Saltmarshe Thomas yeoman 594076 594076 Saltmarshe, Thomas, of Chigwell, yeoman 2
4600493 2231377 2231377 defendant Passelewe John   594076 594076 Passelewe, John, of Chigwell 0
4775713 2288401 2288401 defendant Rudham Walter hunter 594076 594076 Rudham, Walter, of Chigwell, hunter 0
5162623 2404790 2404790 defendant Rote William husbandman 594076 594076 Rote, William, of Chigwell, husbandman 0
5184417 2411180 2411180 defendant Hille Peter husbandman 594076 594076 Hille, Peter, of Chigwell, husbandman 1
5204310 2417014 2417014 defendant Hill Peter husbandman 594076 594076 Hill, Peter, of Chigwell, husbandman 1
5209945 2418641 2418641 defendant Smyth Peter (legal representative) 594076 594076 Smyth, Peter, of Chigwell, executors of 0
5221824 2422081 2422081 defendant Fulham Peter yeoman 594076 594076 Fulham, Peter, of Chigwell, yeoman 2
5228237 2423866 2423866 defendant Fulham Peter yeoman 594076 594076 Fulham, Peter, of Chigwell, yeoman 2
5297434 2444251 2444251 defendant Rote John yeoman 594076 594076 Rote, John, of Chigwell, yeoman 2
5300626 2445149 2445149 defendant Rote John yeoman 594076 594076 Rote, John, of Chigwell, yeoman 1
5300963 2445239 2445239 defendant _te John yeoman 594076 594076 _te, John, of Chigwell, yeoman 1
5530793 2514149 2514149 defendant Forster Francis gent 594076 594076 Forster, Francis, of Chigwell, gent 1
5530794 2514149 2514149 defendant Fulham Richard yeoman 594076 594076 Fulham, Richard, of Chigwell, yeoman 2
5574803 2527199 2527199 defendant Cokke Richard   594076 594076 Cokke, Richard, of Chigwell, administrators of 1
5574804 2527199 2527199 defendant Stacy Edward yeoman 594076 594076 (Stacy, Edward, of Chigwell, yeoman 2
5588074 2531282 2531282 defendant Broun Robert   594076 594076 Broun, Robert, of Chigwell 0
5589987 2531852 2531852 defendant Cokke Richard   594076 594076 Cokke, Richard, of Chigwell, administrators of 1
5589988 2531852 2531852 defendant Stacy Edward yeoman 594076 594076 (Stacy, Edward, of Chigwell, yeoman 2
5600882 2535163 2535163 defendant Trappys Andrew yeoman 594076 594076 Trappys, Andrew, of Chigwell, yeoman 0
5600883 2535163 2535163 defendant Hasylwode Edward laborer 594076 594076 Hasylwode, Edward, of Chigwell, laborer 1
5602699 2535722 2535722 plaintiff More Reginald   594076 594076 More, Reginald, of Chigwell, administrators of 0
5602702 2535722 2535722 defendant Trappys Andrew yeoman 594076 594076 Trappys, Andrew, of Chigwell, yeoman 0
5606115 2536803 2536803 defendant Truechyld John butcher 594076 594076 Truechyld, John, of Chigwell, butcher 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);