names

33 rows where place_id = 592559

✎ 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
3608072 1870177 1870177 defendant Farwell John yeoman 592559 592559 Farwell, John, of testerton, yeoman 1
3608290 1870250 1870250 defendant Farewell John yeoman 592559 592559 Farewell, John, of Testerton, yeoman 0
3617074 1872964 1872964 plaintiff Farewell John yeoman 592559 592559 Farewell, John, of Testerton, yeoman 0
3748546 1941478 1941478 defendant Dowman Ralph husbandman 592559 592559 Dowman, Ralph, of Testerton, husbandman 3
3985015 2019399 2019399 plaintiff Touneshend Thomas esq 592559 592559 Touneshend, Thomas, of Testerton, esq 0
4052707 2043398 2043398 defendant Tounesend Thomas esq 592559 592559 Tounesend, Thomas, of Testerton, esq 2
4060128 2046023 2046023 defendant Touneshende John gent 592559 592559 Touneshende, John, of Testerton, gent 0
4525682 2208329 2208329 defendant Gery Richard   592559 592559 Gery, Richard, of Testerton, parson 5
4582227 2225880 2225880 defendant Hony John   592559 592559 Hony, John, of Testerton 2
4693370 2263428 2263428 defendant Hervy Thomas clerk 592559 592559 Hervy, Thomas, of Testerton, clerk 0
4745690 2279252 2279252 defendant Hervy Thomas   592559 592559 Hervy, Thomas, of of Testerton, parson 0
4745691 2279252 2279252 defendant Styberde Richard   592559 592559 Styberde, Richard, of Testerton, wright 1
4755324 2282054 2282054 defendant Wryghte Richard yeoman 592559 592559 Wryghte, Richard, of Testerton, yeoman 0
4759105 2283195 2283195 defendant Wryght Richard husbandman 592559 592559 Wryght, Richard, of Testerton, husbandman 1
4781206 2290134 2290134 defendant Wryght Richard husbandman 592559 592559 Wryght, Richard, of Testerton, husbandman 1
4853627 2312551 2312551 defendant Farwell Thomas yeoman 592559 592559 Farwell, Thomas, of Testerton, yeoman 0
4911160 2330000 2330000 defendant Hervy Thomas clerk 592559 592559 with Hervy, Thomas, of Testerton, clerk 14
5082267 2381188 2381188 defendant Farewell Thomas yeoman 592559 592559 Farewell, Thomas, of Testerton, yeoman 1
5211208 2419007 2419007 defendant Farewell Thomas husbandman 592559 592559 Farewell, Thomas, of Testerton, husbandman 1
5231207 2424727 2424727 defendant Crosse Richard husbandman 592559 592559 Crosse, Richard, of Testerton, husbandman 0
5238298 2426784 2426784 defendant Whythed Robert clerk 592559 592559 Whythed, Robert, of Testerton, clerk 0
5238299 2426784 2426784 defendant Wryght Robert yeoman 592559 592559 Wryght, Robert, of Testerton, yeoman 1
5238300 2426784 2426784 defendant Baxster Hugh husbandman 592559 592559 Baxster, Hugh, of Testerton, husbandman 2
5273062 2437196 2437196 defendant Wryght Robert husbandman 592559 592559 Wryght, Robert, of Testerton, husbandman 3
5288643 2441699 2441699 defendant Wryght Robert husbandman 592559 592559 Wryght, Robert, of Testerton, husbandman 2
5316978 2450159 2450159 defendant Wryght Robert husbandman 592559 592559 Wryght, Robert, of Testerton, husbandman 0
5316979 2450159 2450159 defendant Holand Richard yeoman 592559 592559 Holand, Richard, of Testerton, yeoman 1
5335455 2455674 2455674 defendant Farewell Robert husbandman 592559 592559 Farewell, Robert, of Testerton, husbandman 3
5556659 2521902 2521902 defendant Farwell John yeoman 592559 592559 Farwell, John, of Testerton, yeoman 2
5556664 2521904 2521904 defendant Farwell John yeoman 592559 592559 Farwell, John, of Testerton, yeoman 0
5564667 2524251 2524251 defendant Geyton Robert husbandman 592559 592559 Geyton, Robert, of Testerton, husbandman 2
5565114 2524382 2524382 defendant Farewell John husbandman 592559 592559 Farewell, John, of Testerton, husbandman 4
5603719 2536030 2536030 defendant Farwell John yeoman 592559 592559 Farwell, John, of Testerton, 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);