names

51 rows where place_id = 595178

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619263 1873628 1873628 defendant Bylette John husbandman 595178 595178 Bylette, John, of Weton, husbandman 0
3619264 1873628 1873628 defendant Smyth William husbandman 595178 595178 Smyth, William, of Weton, husbandman 1
3746986 1940977 1940977 defendant Hothome William esq 595178 595178 Hothome, William, of Weton, esq 0
3746987 1940977 1940977 defendant Dunne Thomas yeoman 595178 595178 Dunne, Thomas, of Weton, yeoman 1
4086401 2055415 2055415 defendant Coye Robert husbandman 595178 595178 Coye, Robert, of Weton, husbandman 0
4086402 2055415 2055415 defendant Coye William husbandman 595178 595178 Coye, William, of Weton, husbandman 1
4087037 2055657 2055657 defendant Robynson Ambrose husbandman 595178 595178 Robynson, Ambrose, of Weton, husbandman 0
4091786 2057355 2057355 defendant Ingle William husbandman 595178 595178 Ingle, William, of Weton, husbandman 0
4475702 2193079 2193079 defendant Wro Henry   595178 595178 Wro, Henry, of Weton 1
4648475 2245603 2245603 defendant Hundesley Simon   595178 595178 Hundesley, Simon, of Weton 0
4649010 2245757 2245757 defendant Hundesley Simon   595178 595178 Hundesley, Simon, of Weton 2
4669768 2256245 2256245 defendant Thriske Thomas husbndman 595178 595178 Thriske, Thomas, of Weton, husbndman 0
4670269 2256407 2256407 defendant Roscelyn John husbandman 595178 595178 Roscelyn, John, of Weton, husbandman 0
4670270 2256407 2256407 defendant Colson John husbandman 595178 595178 Colson, John, of Weton, husbandman 1
4670271 2256407 2256407 defendant Bate John husbandman 595178 595178 Bate, John, of Weton, husbandman 2
4670272 2256407 2256407 defendant West of Robert husbandman 595178 595178 West, of Robert, of Weton, husbandman 3
4699821 2265390 2265390 defendant Colston Thomas laborer 595178 595178 Colston, Thomas, of Weton, laborer 1
4699822 2265390 2265390 defendant Colston John laborer 595178 595178 Colston, John, of Weton, laborer 2
4699823 2265390 2265390 defendant Roscelyn John laborer 595178 595178 Roscelyn, John, of Weton, laborer 3
4699824 2265390 2265390 defendant West John laborer 595178 595178 West, John, of Weton, laborer 4
4745081 2279073 2279073 defendant Webster Robert husbandman 595178 595178 Webster, Robert, of Weton, husbandman 0
4745082 2279073 2279073 defendant Essh John de husbandman 595178 595178 Essh, John de, of Weton, husbandman 1
4745083 2279073 2279073 defendant Hessay Thomas husbandman 595178 595178 Hessay, Thomas, of Weton, husbandman 2
4745084 2279073 2279073 defendant Essh William husbandman 595178 595178 Essh, William, of Weton, husbandman 3
4745086 2279073 2279073 defendant Skalwra John husbandman 595178 595178 Skalwra, John, of Weton, husbandman 5
4745087 2279073 2279073 defendant Skalwra William husbandman 595178 595178 Skalwra, William, of Weton, husbandman 6
4750866 2280737 2280737 defendant Lound Richard de esq 595178 595178 Lound, Richard de, of Weton, esq 0
4821174 2302702 2302702 defendant Lound Alexander de gent 595178 595178 Lound, Alexander de, of Weton, gent 0
4832789 2306275 2306275 defendant Goddysbroke Thomas gent 595178 595178 Goddysbroke, Thomas, of Weton, gent 12
4859696 2314400 2314400 defendant Goddesbroke Thomas gent 595178 595178 Goddesbroke, Thomas, of Weton, gent 17
4867938 2316941 2316941 defendant Hardelok William husbandman 595178 595178 Hardelok, William, of Weton, husbandman 0
4869617 2317459 2317459 defendant Godesbruke Thomas gent 595178 595178 Godesbruke, Thomas, of Weton, gent 0
4870924 2317881 2317881 defendant Godesbroke Thomas gent 595178 595178 Godesbroke, Thomas, of Weton, gent 0
4878727 2320284 2320284 defendant de Newesom Walter husbandman 595178 595178 de Newesom, Walter, of Weton, husbandman 6
4885962 2322474 2322474 defendant Bolsore Thomas husbandman 595178 595178 Bolsore, Thomas, of Weton, husbandman 2
4901068 2326960 2326960 defendant Goddesbroke Thomas gent 595178 595178 Goddesbroke, Thomas, of Weton, gent 0
5292286 2442746 2442746 defendant Neusom Robert husbandman 595178 595178 Neusom, Robert, of Weton, husbandman 4
5292287 2442746 2442746 defendant Fleccher John husbandman 595178 595178 Fleccher, John, of Weton, husbandman 5
5292288 2442746 2442746 defendant Fleccher Richard husbandman 595178 595178 Fleccher, Richard, of Weton, husbandman 6
5512071 2508635 2508635 defendant Nightyngale William husbandman 595178 595178 Nightyngale, William, of Weton, husbandman 1
5512072 2508635 2508635 defendant Lounde Christopher husbandman 595178 595178 Lounde, Christopher, of Weton, husbandman 2
5512073 2508635 2508635 defendant Lounde John husbandman 595178 595178 Lounde, John, of Weton, husbandman 3
5512074 2508635 2508635 defendant Lounde Richard husbandman 595178 595178 Lounde, Richard, of Weton, husbandman 4
5596737 2533898 2533898 defendant Nightingale John husbandman 595178 595178 Nightingale, John, of Weton, husbandman 0
5600661 2535096 2535096 defendant Suttell Richard husbandman 595178 595178 Suttell, Richard, of Weton, husbandman 7
5600662 2535096 2535096 defendant Knyghtson John husbandman 595178 595178 Knyghtson, John, of Weton, husbandman 8
5600663 2535096 2535096 defendant Fletcher John husbandman 595178 595178 Fletcher, John, of Weton, husbandman 9
5600675 2535097 2535097 defendant Suttell Richard husbandman 595178 595178 Suttell, Richard, of Weton, husbandman 7
5600676 2535097 2535097 defendant Knyghtson John husbandman 595178 595178 Knyghtson, John, of Weton, husbandman 8
5600677 2535097 2535097 defendant Fletcher John husbandman 595178 595178 Fletcher, John, of Weton, husbandman 9
5636044 2555232 2555232 defendant Hundesley Simon yeoman 595178 595178 Hundesley, Simon, of Weton, yeoman 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);