names

26 rows where place_id = 601110

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643900 1908522 1908522 defendant Brody John husbandman 601110 601110 Brody, John, of Wydford, husbandman 4
3666414 1915446 1915446 defendant Sampford John husbandman 601110 601110 Sampford, John, of Wydford, husbandman 2
3680936 1920118 1920118 defendant Clovell William clerk 601110 601110 Clovell, William, of Wydford, clerk 4
3712383 1930190 1930190 defendant Eltoft Thomas laborer 601110 601110 Eltoft, Thomas, of Wydford, laborer 7
3760537 1945299 1945299 defendant Barbour John husbandman 601110 601110 Barbour, John, of Wydford, husbandman 1
3785365 1953209 1953209 defendant Elyot John husbandman 601110 601110 Elyot, John, of Wydford, husbandman 0
3799659 1957814 1957814 defendant Barbour John laborer 601110 601110 Barbour, John, of Wydford, laborer 5
3799669 1957816 1957816 defendant Barbour John laborer 601110 601110 Barbour, John, of Wydford, laborer 5
3826378 1966098 1966098 defendant Laurance Robert laborer 601110 601110 Laurance, Robert, of Wydford, laborer 1
3865600 1978711 1978711 defendant Bull Richard yeoman 601110 601110 Bull, Richard, of Wydford, yeoman 0
3911349 1994113 1994113 defendant Malt Robert husbandman 601110 601110 Malt, Robert, of Wydford, husbandman 0
3918661 1996568 1996568 defendant Broun John husbandman 601110 601110 (Broun, John, of Wydford, husbandman 1
3921335 1997478 1997478 defendant Spencer Richard smith 601110 601110 Spencer, Richard, of Wydford, smith 0
4234683 2107678 2107678 defendant Hayes Ralph yeoman 601110 601110 Hayes, Ralph, of Wydford, yeoman 1
4239237 2109347 2109347 defendant Wheler Richard yeoman 601110 601110 Wheler, Richard, of Wydford, yeoman 0
4278610 2122452 2122452 defendant Cooke John husbandman 601110 601110 Cooke, John, of Wydford, husbandman 1
4543758 2213940 2213940 defendant Cok_ Walter   601110 601110 Cok_, Walter, of Wydford 0
4556283 2217907 2217907 defendant Clerk Walter   601110 601110 Clerk, Walter, of Wydford 2
5062329 2375295 2375295 defendant Shelford Thomas clerk 601110 601110 Shelford, Thomas, of Wydford, clerk 0
5068087 2376960 2376960 defendant Bode John farmer 601110 601110 Bode, John, of Wydford, farmer 0
5392842 2473026 2473026 defendant Malkele John clerk 601110 601110 Malkele, John, of Wydford, clerk 0
5428374 2483411 2483411 defendant Crowe Edmund yeoman 601110 601110 Crowe, Edmund, of Wydford, yeoman 0
5428721 2483503 2483503 defendant Reed Henry laborer 601110 601110 Reed, Henry, of Wydford, laborer 0
5478211 2498510 2498510 defendant Stysted Robert husbandman 601110 601110 Stysted, Robert, of Wydford, husbandman 0
5483135 2499895 2499895 defendant Leugore or Lengore John husbandman 601110 601110 Leugore or Lengore, John, of Wydford, husbandman 0
5582280 2529532 2529532 defendant Frost Joan widow 601110 601110 Frost, Joan, of Wydford, widow 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);