names

28 rows where place_id = 598479

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632675 1905035 1905035 defendant Gabett Richard husbandman 598479 598479 Gabett, Richard, of Acton Burnell, husbandman 0
3676840 1918796 1918796 defendant Brereton Richard gent 598479 598479 Brereton, Richard, of Acton Burnell, gent 0
3676852 1918801 1918801 defendant Brereton Richard gent 598479 598479 Brereton, Richard, of Acton Burnell, gent 0
3834245 1968653 1968653 defendant Gyttyns Roger husbandman 598479 598479 Gyttyns, Roger, of Acton Burnell, husbandman 0
3863533 1977999 1977999 defendant Hockenyll William gent 598479 598479 Hockenyll, William, of Acton Burnell, gent 1
3863534 1977999 1977999 defendant Bokenall Thomas yeoman 598479 598479 Bokenall, Thomas, of Acton Burnell, yeoman 2
3863535 1977999 1977999 defendant Horton John yeoman 598479 598479 Horton, John, of Acton Burnell, yeoman 3
3863536 1977999 1977999 defendant Hancoke John yeoman 598479 598479 Hancoke, John, of Acton Burnell, yeoman 4
3863537 1977999 1977999 defendant Gyttyns Roger yeoman 598479 598479 Gyttyns, Roger, of Acton Burnell, yeoman 5
3894342 1988324 1988324 defendant Wykys James   598479 598479 Wykys, James, of Acton Burnell, gent, servant to John Dudley 0
4566388 2221058 2221058 defendant Turnour Roger le   598479 598479 Turnour, Roger le, of Acton Burnell 1
4746664 2279515 2279515 defendant Campyon Roger butcher 598479 598479 Campyon, Roger, of Acton Burnell, butcher 0
4796971 2295209 2295209 defendant Madeley Thomas husbandman 598479 598479 Madeley, Thomas, of Acton Burnell, husbandman 2
4815951 2301080 2301080 defendant Caghley John yeoman 598479 598479 Caghley, John, of Acton Burnell, yeoman 1
4905536 2328329 2328329 defendant Phippes Roger carpenter 598479 598479 Phippes, Roger, of Acton Burnell, carpenter 0
4964420 2346271 2346271 defendant Caughley John husbandman 598479 598479 Caughley, John, of Acton Burnell, husbandman 3
4964433 2346274 2346274 defendant Philippes Roger husbandman 598479 598479 Philippes, Roger, of Acton Burnell, husbandman 4
5000168 2356930 2356930 defendant Pheppes Roger carpenter 598479 598479 Pheppes, Roger, of Acton Burnell, carpenter 1
5023094 2363663 2363663 defendant Caughley John husbandman 598479 598479 Caughley, John, of Acton Burnell, husbandman 0
5110914 2389587 2389587 defendant Turnour William husbandman 598479 598479 Turnour, William, of Acton Burnell, husbandman 4
5110919 2389588 2389588 defendant Turnour William husbandman 598479 598479 Turnour, William, of Acton Burnell, husbandman 3
5317511 2450323 2450323 defendant Adams John yeoman 598479 598479 Adams, John, of Acton Burnell, yeoman 0
5317512 2450323 2450323 defendant Adams William yeoman 598479 598479 Adams, William, of Acton Burnell, yeoman 1
5364278 2464487 2464487 plaintiff Adams John   598479 598479 Adams, John, of Acton Burnell 0
5467602 2495239 2495239 plaintiff Broke Alice yeoman 598479 598479 Broke, Alice, of Acton Burnell, formerly wife of Geoffrey, yeoman 0
5467603 2495239 2495239 defendant Adams William yeoman 598479 598479 Adams, William, of Acton Burnell, yeoman 0
5467605 2495239 2495239 defendant Slendon Richard   598479 598479 Slendon, Richard, of Acton Burnell 2
5467608 2495240 2495240 plaintiff Broke Alice yeoman 598479 598479 Broke, Alice, of Acton Burnell, formerly wife of Geoffrey, yeoman 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);