names

49 rows where place_id = 593201

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610893 1871079 1871079 defendant Trayford Edward yeoman 593201 593201 Trayford, Edward, of Chygwell, yeoman 0
3614484 1872177 1872177 defendant Thakwra Robert husbandman 593201 593201 Thakwra, Robert, of Chygwell, husbandman 2
3614485 1872177 1872177 defendant Fulham Thomas, junior husbandman 593201 593201 Fulham, Thomas, junior, of Chygwell, husbandman 3
3626381 1903109 1903109 defendant Cooke William gent 593201 593201 Cooke, William, of Chygwell, gent 0
3642885 1908225 1908225 defendant Coke William gent 593201 593201 Coke, William, of Chygwell, gent 0
3644506 1908700 1908700 defendant Consedwe Richard yeoman 593201 593201 Consedwe, Richard, of Chygwell, yeoman 2
3644512 1908701 1908701 defendant Consedewe Richard yeoman 593201 593201 Consedewe, Richard, of Chygwell, yeoman 2
3644518 1908702 1908702 defendant Consedewe Richard yeoman 593201 593201 Consedewe, Richard, of Chygwell, yeoman 2
3648805 1910015 1910015 defendant Norwiche Robert gent 593201 593201 Norwiche, Robert, of Chygwell, gent 1
3657237 1912526 1912526 defendant Aleyn Edward gent 593201 593201 Aleyn, Edward, of Chygwell, gent 1
3669264 1916325 1916325 defendant Truchylde John husbandman 593201 593201 Truchylde, John, of Chygwell, husbandman 0
3687058 1922124 1922124 defendant Truchyld John butcher 593201 593201 Truchyld, John, of Chygwell, butcher 1
3707074 1928501 1928501 defendant Fulham Edward yeoman 593201 593201 Fulham, Edward, of Chygwell, yeoman 0
3707075 1928501 1928501 defendant Dey Thomas husbandman 593201 593201 Dey, Thomas, of Chygwell, husbandman 1
3720551 1932710 1932710 defendant Dodde John husbandman 593201 593201 Dodde, John, of Chygwell, husbandman 0
3720552 1932710 1932710 defendant Fulham William husbandman 593201 593201 Fulham, William, of Chygwell, husbandman 1
3720553 1932710 1932710 defendant Nevell George husbandman 593201 593201 Nevell, George, of Chygwell, husbandman 2
3755624 1943716 1943716 defendant Wyberd John husbandman 593201 593201 Wyberd, John, of Chygwell, husbandman 4
3759828 1945070 1945070 defendant Trewchyld John butcher 593201 593201 Trewchyld, John, of Chygwell, butcher 3
3762037 1945771 1945771 defendant Fulham William husbandman 593201 593201 Fulham, William, of Chygwell, husbandman 0
3762038 1945771 1945771 defendant Harryson Edward husbandman 593201 593201 Harryson, Edward, of Chygwell, husbandman 1
3762039 1945771 1945771 defendant A Dey Thomas husbandman 593201 593201 A Dey, Thomas, of Chygwell, husbandman 2
3773589 1949452 1949452 defendant Thurgood John husbandman 593201 593201 Thurgood, John, of Chygwell, husbandman 1
3799570 1957786 1957786 defendant Trewchyld John butcher 593201 593201 Trewchyld, John, of Chygwell, butcher 0
3807741 1960309 1960309 defendant Trewchylde John, senior butcher 593201 593201 Trewchylde, John, senior, of Chygwell, butcher 1
3812125 1961703 1961703 defendant Cowper Edmund butcher 593201 593201 Cowper, Edmund, of Chygwell, butcher 2
3840815 1970696 1970696 defendant Grene Thomas yeoman 593201 593201 Grene, Thomas, of Chygwell, yeoman 1
3840822 1970699 1970699 defendant Grene Thomas yeoman 593201 593201 Grene, Thomas, of Chygwell, yeoman 1
3853024 1974565 1974565 defendant Trewchilde John butcher 593201 593201 Trewchilde, John, of Chygwell, butcher 1
3853025 1974565 1974565 defendant Sparrowe George husbandman 593201 593201 Sparrowe, George, of Chygwell, husbandman 2
3857784 1976073 1976073 defendant Holmes Thomas husbandman 593201 593201 Holmes, Thomas, of Chygwell, husbandman 1
3867456 1979351 1979351 defendant Trewchyld John butcher 593201 593201 Trewchyld, John, of Chygwell, butcher 0
3867457 1979351 1979351 defendant Sparrowe George husbandman 593201 593201 Sparrowe, George, of Chygwell, husbandman 1
3884502 1985090 1985090 plaintiff Alayn Edward (legal representative) 593201 593201 Alayn, Edward, of Chygwell, gent, executors of 0
3916826 1995992 1995992 defendant Cowper William   593201 593201 Cowper, William, of Chygwell, cook 1
3922920 1997969 1997969 plaintiff Scott George gent 593201 593201 Scott, George, of Chygwell, gent 0
3922921 1997969 1997969 defendant Sparrowe George husbandman 593201 593201 Sparrowe, George, of Chygwell, husbandman 0
4561946 2219668 2219668 defendant Boynauntre John   593201 593201 Boynauntre, John, of Chygwell 4
4682767 2260229 2260229 defendant Blok William farmer 593201 593201 Blok, William, of Chygwell, farmer 0
4793484 2294070 2294070 defendant Castell John pulter 593201 593201 Castell, John, of Chygwell, pulter 4
4925749 2334488 2334488 defendant Turnour Richard husbandman 593201 593201 Turnour, Richard, of Chygwell, husbandman 0
5379836 2469279 2469279 defendant Spylman John husbandman 593201 593201 Spylman, John, of Chygwell, husbandman 0
5387139 2471391 2471391 defendant Stylman John husbandman 593201 593201 Stylman, John, of Chygwell, husbandman 0
5412356 2478640 2478640 defendant Roote Richard husbandman 593201 593201 Roote, Richard, of Chygwell, husbandman 4
5523035 2512031 2512031 defendant Truchilde John butcher 593201 593201 Truchilde, John, of Chygwell, butcher 0
5527674 2513236 2513236 defendant Fulham William yeoman 593201 593201 Fulham, William, of Chygwell, yeoman 0
5527675 2513236 2513236 defendant Fulham Thomas husbandman 593201 593201 Fulham, Thomas, of Chygwell, husbandman 1
5551005 2520321 2520321 defendant Broun Christopher husbandman 593201 593201 Broun, Christopher, of Chygwell, husbandman 0
5551006 2520321 2520321 defendant Broun Thomas husbandman 593201 593201 Broun, Thomas, of Chygwell, husbandman 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);