names

35 rows where place_id = 608635

✎ 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
3674602 1918108 1918108 defendant Dans William husbandman 608635 608635 Dans, William, of Defford, husbandman 0
3674603 1918108 1918108 defendant Dame Annes William husbandman 608635 608635 Dame Annes, William, of Defford, husbandman 1
3675940 1918510 1918510 defendant Fytchet John yeoman 608635 608635 Fytchet, John, of Defford, yeoman 2
3676823 1918790 1918790 defendant Clark Thomas husbandman 608635 608635 Clark, Thomas, of Defford, husbandman 0
3680333 1919926 1919926 defendant Knyght Thomas husbandman 608635 608635 Knyght, Thomas, of Defford, husbandman 0
3680334 1919926 1919926 defendant Knyght Richard husbandman 608635 608635 Knyght, Richard, of Defford, husbandman 1
3694241 1924401 1924401 plaintiff Myddelton William   608635 608635 Myddelton, William, of Defford 0
3716669 1931508 1931508 defendant Knyght John husbandman 608635 608635 Knyght, John, of Defford, husbandman 2
3716967 1931594 1931594 defendant Fychet John husbandman 608635 608635 Fychet, John, of Defford, husbandman 0
3728385 1935121 1935121 defendant Pykeryng William yeoman 608635 608635 Pykeryng, William, of Defford, yeoman 1
3773234 1949336 1949336 defendant Demeannes William husbandman 608635 608635 Demeannes, William, of Defford, husbandman 2
3774601 1949783 1949783 defendant Dameanneys William husbandman 608635 608635 Dameanneys, William, of Defford, husbandman 1
3776252 1950318 1950318 defendant Dameannesm William husbandman 608635 608635 Dameannesm William, of Defford, husbandman 3
3776253 1950318 1950318 defendant Wright Philip husbandman 608635 608635 Wright, Philip, of Defford, husbandman 4
3784166 1952829 1952829 defendant Hill James husbandman 608635 608635 Hill, James, of Defford, husbandman 0
3791460 1955165 1955165 defendant Damannes William husbandman 608635 608635 Damannes, William, of Defford, husbandman 1
3848457 1973097 1973097 defendant Pykke John husbandman 608635 608635 Pykke, John, of Defford, husbandman 0
4301679 2130707 2130707 defendant Tustean Thomas yeoman 608635 608635 Tustean, Thomas, of Defford, yeoman 1
4464363 2189523 2189523 defendant Wodhale Thomas   608635 608635 Wodhale, Thomas, of Defford 0
4825607 2304051 2304051 defendant Forster Nicholas yeoman 608635 608635 Forster, Nicholas, of Defford, yeoman 3
4875772 2319385 2319385 defendant Martyn John husbandman 608635 608635 Martyn, John, of Defford, husbandman 2
4875773 2319385 2319385 defendant Martyn Thomas husbandman 608635 608635 Martyn, Thomas, of Defford, husbandman 3
4883822 2321847 2321847 defendant Martyn John yeoman 608635 608635 Martyn, John, of Defford, yeoman 0
4913733 2330795 2330795 defendant Martyn John drover 608635 608635 Martyn, John, of Defford, drover 1
4982391 2351652 2351652 defendant Noteho Robert yeoman 608635 608635 Noteho, Robert, of Defford, yeoman 0
5125696 2394004 2394004 defendant Harewell Roger esq 608635 608635 Harewell, Roger, of Defford, esq 1
5213246 2419607 2419607 defendant Mapulbek Robert husbandman 608635 608635 Mapulbek, Robert, of Defford, husbandman 1
5274847 2437724 2437724 defendant Daunce John husbandman 608635 608635 Daunce, John, of Defford, husbandman 0
5316074 2449881 2449881 defendant Syde Richard yeoman 608635 608635 Syde, Richard, of Defford, yeoman 4
5509926 2507945 2507945 defendant Daunce John, senior husbandman 608635 608635 Daunce, John, senior, of Defford, husbandman 0
5551220 2520387 2520387 defendant Daunse Robert husbandman 608635 608635 Daunse, Robert, of Defford, husbandman 0
5553307 2521004 2521004 defendant Tayllour William husbandman 608635 608635 Tayllour, William, of Defford, husbandman 0
5554109 2521242 2521242 defendant Lee John husbandman 608635 608635 Lee, John, of Defford, husbandman 0
5554110 2521242 2521242 defendant Knygh Richard husbandman 608635 608635 Knygh, Richard, of Defford, husbandman 1
5620715 2550347 2550347 plaintiff Shelton William   608635 608635 Shelton, William, of Defford 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);