names

37 rows where place_id = 587912

✎ 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
3592800 1865361 1865361 defendant Burges Thomas husbandman 587912 587912 Burges, Thomas, of Donton, husbandman 0
3592801 1865361 1865361 defendant Brian Richard husbandman 587912 587912 Brian, Richard, of Donton, husbandman 1
3592802 1865361 1865361 defendant Orpod John husbandman 587912 587912 Orpod, John, of Donton, husbandman 2
3592803 1865361 1865361 defendant Orpod William husbandman 587912 587912 Orpod, William, of Donton, husbandman 3
3592805 1865361 1865361 defendant Orpod Thomas husbandman 587912 587912 Orpod, Thomas, of Donton, husbandman 5
3638627 1906896 1906896 defendant Serle Thomas husbandman 587912 587912 Serle, Thomas, of Donton, husbandman 0
3638628 1906896 1906896 defendant Garnet Simon laborer 587912 587912 Garnet, Simon, of Donton, laborer 1
3678537 1919345 1919345 defendant Sutton Agnes widow 587912 587912 Sutton, Agnes, of Donton, widow 3
3782065 1952144 1952144 defendant Carneton Ralph husbandman 587912 587912 Carneton, Ralph, of Donton, husbandman 0
3977553 2016720 2016720 plaintiff London Richard yeoman 587912 587912 London, Richard, of Donton, yeoman 0
4029102 2035054 2035054 defendant Jenyson Thomas yeoman 587912 587912 Jenyson, Thomas, of Donton, yeoman 0
4029109 2035056 2035056 defendant Jenyson Thomas yeoman 587912 587912 Jenyson, Thomas, of Donton, yeoman 0
4029115 2035057 2035057 defendant Jenyson Thomas yeoman 587912 587912 Jenyson, Thomas, of Donton, yeoman 2
4029120 2035058 2035058 defendant Jenyson Thomas yeoman 587912 587912 Jenyson, Thomas, of Donton, yeoman 2
4756592 2282424 2282424 defendant Hygon John laborer 587912 587912 Hygon, John, of Donton, laborer 0
4756593 2282424 2282424 defendant Barbour John, sen barber 587912 587912 Barbour, John, sen, of Donton, barber 1
4785969 2291650 2291650 defendant Wryght William husbandman 587912 587912 Wryght, William, of Donton, husbandman 0
4785970 2291650 2291650 defendant Barbour William husbandman 587912 587912 Barbour, William, of Donton, husbandman 1
4785971 2291650 2291650 defendant Flesshe Thomas husbandman 587912 587912 Flesshe, Thomas, of Donton, husbandman 2
4791725 2293508 2293508 defendant Fole Robert clerk 587912 587912 Fole, Robert, of Donton, clerk 0
4870721 2317820 2317820 defendant Wryght William husbandman 587912 587912 Wryght, William, of Donton, husbandman 1
4910019 2329659 2329659 plaintiff Bereford John   587912 587912 Bereford, John, of Donton 0
4962604 2345719 2345719 plaintiff Browne John   587912 587912 Browne, John, of Donton 0
4972157 2348614 2348614 defendant Kerewyn John (legal representative) 587912 587912 Kerewyn, John, of Donton, husbandman, executors of 0
4972159 2348614 2348614 defendant Kerewyn William, junior husbandman 587912 587912 Kerewyn, William, junior, of Donton, husbandman 2
5001457 2357315 2357315 defendant Ruggeley Nicholas gent 587912 587912 Ruggeley, Nicholas, of Donton, gent 0
5218441 2421123 2421123 defendant Knoppyng John husbandman 587912 587912 Knoppyng, John, of Donton, husbandman 0
5397191 2474281 2474281 defendant Collyngrygge William yeoman 587912 587912 Collyngrygge, William, of Donton, yeoman 2
5430773 2484144 2484144 defendant Hole Edmund yeoman 587912 587912 Hole, Edmund, of Donton, yeoman 4
5487656 2501198 2501198 defendant Barbour John husbandman 587912 587912 Barbour, John, of Donton, husbandman 2
5491318 2502291 2502291 defendant Ball John husbandman 587912 587912 Ball, John, of Donton, husbandman 0
5491320 2502292 2502292 defendant Warboys William husbandman 587912 587912 Warboys, William, of Donton, husbandman 0
5561609 2523382 2523382 defendant Pygot Thomas, senior husbandman 587912 587912 Pygot, Thomas, senior, of Donton, husbandman 0
5604352 2536225 2536225 defendant Knottysford William clerk 587912 587912 Knottysford, William, of Donton, clerk 0
5604353 2536225 2536225 defendant Knottysford Humphrey husbandman 587912 587912 Knottysford, Humphrey, of Donton, husbandman 1
5623638 2551330 2551330 defendant Rycher William husbandman 587912 587912 Rycher, William, of Donton, husbandman 0
5626064 2552114 2552114 defendant Mereworthe John husbandman 587912 587912 Mereworthe, John, of Donton, husbandman 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);