names

29 rows where place_id = 615690

✎ 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
3710234 1929517 1929517 defendant Jakson Robert husbandman 615690 615690 Jakson, Robert, of Rednes, husbandman 0
3710235 1929517 1929517 defendant Parrot Thomas husbandman 615690 615690 Parrot, Thomas, of Rednes, husbandman 1
3828683 1966849 1966849 defendant Coke William husbandman 615690 615690 Coke, William, of Rednes, husbandman 1
3916202 1995806 1995806 defendant Grosier Richard husbandman 615690 615690 Grosier, Richard, of Rednes, husbandman 0
4005932 2026895 2026895 defendant Lounde Elizabeth widow 615690 615690 Lounde, Elizabeth, of Rednes, widow 0
4085129 2054964 2054964 defendant Lunde Robert gent 615690 615690 Lunde, Robert, of Rednes, gent 0
4089247 2056440 2056440 defendant Kidson John badger or retailer 615690 615690 Kidson, John, of Rednes, badger or retailer 0
4100078 2060359 2060359 defendant Lunde Richard yeoman 615690 615690 Lunde, Richard, of Rednes, yeoman 0
4101081 2060700 2060700 defendant Hunson Thomas yeoman 615690 615690 Hunson, Thomas, of Rednes, or of Garthrop, Lincs, yeoman 0
4101082 2060700 2060700 defendant Kydson John   615690 615690 Kydson, John, of Rednes, tapistry maker 1
4101087 2060702 2060702 defendant Kydson John chapman 615690 615690 Kydson, John, of Rednes, chapman 1
4102679 2061256 2061256 defendant Kidson John badger or retailer 615690 615690 Kidson, John, of Rednes, badger or retailer 2
4104452 2061877 2061877 defendant Kydson John chapman 615690 615690 Kydson, John, of Rednes, chapman 0
4104513 2061896 2061896 defendant Kydson John chapman 615690 615690 Kydson, John, of Rednes, chapman 0
4185187 2090326 2090326 defendant Beall Henry husbandman 615690 615690 Beall, Henry, of Rednes, husbandman 0
4217328 2101556 2101556 defendant Prince William yeoman 615690 615690 Prince, William, of Rednes, yeoman 0
4658224 2248453 2248453 defendant Godfrey John husbandman 615690 615690 Godfrey, John, of Rednes, husbandman 0
4658225 2248453 2248453 defendant Henryson John husbandman 615690 615690 Henryson, John, of Rednes, husbandman 1
4776129 2288532 2288532 defendant Webster John weaver 615690 615690 Webster, John, of Rednes, weaver 0
4776130 2288532 2288532 defendant Gudefer Richard husbandman 615690 615690 Gudefer, Richard, of Rednes, husbandman 1
4805650 2297975 2297975 defendant Fyssher John husbandman 615690 615690 Fyssher, John, of Rednes, husbandman 2
5057855 2373919 2373919 defendant Wode William laborer 615690 615690 Wode, William, of Rednes, laborer 0
5271652 2436805 2436805 defendant Jakkelyn Nicholas   615690 615690 Jakkelyn, Nicholas, of Rednes 0
5382903 2470176 2470176 defendant Bar Geoffrey yeoman 615690 615690 Bar, Geoffrey, of Rednes, yeoman 4
5393752 2473273 2473273 defendant Bar Geoffrey yeoman 615690 615690 Bar, Geoffrey, of Rednes, yeoman 3
5393758 2473274 2473274 defendant Bar Geoffrey yeoman 615690 615690 Bar, Geoffrey, of Rednes, yeoman 3
5547943 2519428 2519428 defendant Aunger Alexander gent 615690 615690 Aunger, Alexander, of Rednes, gent 0
5558483 2522427 2522427 defendant Aunger Alexander gent 615690 615690 Aunger, Alexander, of Rednes, gent 0
5587498 2531105 2531105 defendant Pygas Robert yeoman 615690 615690 Pygas, Robert, of Rednes, yeoman 1

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