names

26 rows where place_id = 635892

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3827865 1966581 1966581 defendant Strangman Edward gent 635892 635892 Strangman, Edward, of Rayle, gent 0
3992338 2022026 2022026 defendant Andrewe or Andrewe Thomas yeoman 635892 635892 Andrewe or Andrewe, Thomas, of Rayle, yeoman 3
4523001 2207525 2207525 defendant Chapman John   635892 635892 Chapman, John, of Rayle 0
5070906 2377793 2377793 defendant Fullam Walter husbandman 635892 635892 Fullam, Walter, of Rayle, husbandman 3
5119723 2392206 2392206 defendant Fulham Walter chandler 635892 635892 Fulham, Walter, of Rayle, chandler 2
5135060 2396751 2396751 defendant Colyns William skinner 635892 635892 Colyns, William, of Rayle, skinner 0
5155145 2402654 2402654 defendant Colyns William skinner 635892 635892 Colyns, William, of Rayle, skinner 0
5171892 2407494 2407494 defendant Collyns William skinner 635892 635892 Collyns, William, of Rayle, skinner 0
5190649 2413011 2413011 defendant Colyns William skinner 635892 635892 Colyns, William, of Rayle, skinner 0
5254039 2431381 2431381 defendant Halle Thomas chapman 635892 635892 Halle, Thomas, of Rayle, chapman 3
5312964 2448908 2448908 defendant Hoberd John lborer 635892 635892 Hoberd, John, of Rayle, lborer 1
5327854 2453398 2453398 defendant Saykyn John husbandman 635892 635892 Saykyn, John, of Rayle, husbandman 0
5327855 2453398 2453398 defendant Hoberd John laborer 635892 635892 Hoberd, John, of Rayle, laborer 1
5327856 2453398 2453398 defendant Thorn John tailor 635892 635892 Thorn, John, of Rayle, tailor 2
5328517 2453605 2453605 defendant Lopham John carpenter 635892 635892 Lopham, John, of Rayle, carpenter 2
5398512 2474632 2474632 defendant Colyns Thomas Chapman 635892 635892 Colyns, Thomas, of Rayle, Chapman 0
5411342 2478352 2478352 defendant Colyns Thomas chapman 635892 635892 Colyns, Thomas, of Rayle, chapman 0
5425587 2482631 2482631 defendant Colyns Thomas chapman 635892 635892 Colyns, Thomas, of Rayle, chapman 0
5425589 2482632 2482632 defendant Colyns Thomas chapman 635892 635892 Colyns, Thomas, of Rayle, chapman 0
5444008 2488126 2488126 defendant Colyns Thomas chapman 635892 635892 Colyns, Thomas, of Rayle, chapman 0
5456720 2491933 2491933 defendant Colyns Thomas chapman 635892 635892 Colyns, Thomas, of Rayle, chapman 0
5456722 2491934 2491934 defendant Colyns Thomas chapman 635892 635892 Colyns, Thomas, of Rayle, chapman 0
5465229 2494505 2494505 defendant Couper William laborer 635892 635892 Couper, William, of Rayle, laborer 0
5465230 2494505 2494505 defendant Ponde Richard husbandman 635892 635892 Ponde, Richard, of Rayle, husbandman 1
5465232 2494505 2494505 defendant Wode John butcher 635892 635892 Wode, John, of Rayle, butcher 3
5508015 2507401 2507401 defendant Botell John husbandman 635892 635892 Botell, John, of Rayle, 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);