names

34 rows where place_id = 612330

✎ 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
3681064 1920153 1920153 defendant Joys Thomas   612330 612330 Joys, Thomas, of Nassyngton, mason 0
3692717 1923910 1923910 defendant Foster John yeoman 612330 612330 Foster, John, of Nassyngton, yeoman 1
3720156 1932581 1932581 defendant Emley William butcher 612330 612330 Emley, William, of Nassyngton, butcher 0
3727526 1934888 1934888 defendant Breyn Richard sawyer 612330 612330 Breyn, Richard, of Nassyngton, sawyer 0
3846914 1972572 1972572 defendant Emlyn John clerk 612330 612330 Emlyn, John, of Nassyngton, clerk 2
3947926 2006339 2006339 plaintiff Core Richard gent 612330 612330 Core, Richard, of Nassyngton, gent 0
4538756 2212393 2212393 defendant Bernard Richard   612330 612330 Bernard, Richard, of Nassyngton 2
4546736 2214905 2214905 defendant Bryon William   612330 612330 Bryon, William, of Nassyngton 2
4582337 2225918 2225918 defendant Chaumbour William   612330 612330 Chaumbour, William, of Nassyngton 0
4628050 2239695 2239695 defendant Fyssher Richard   612330 612330 Fyssher, Richard, of Nassyngton 0
4669775 2256247 2256247 defendant Lorde Agnes widow 612330 612330 Lorde, Agnes, of Nassyngton, widow 0
4683991 2260601 2260601 defendant Bernard Richard husbandman 612330 612330 Bernard, Richard, of Nassyngton, husbandman 1
4740617 2277772 2277772 defendant Bolyon Robert husbandman 612330 612330 Bolyon, Robert, of Nassyngton, husbandman 0
4762604 2284283 2284283 defendant Bolyon Philip husbandman 612330 612330 Bolyon, Philip, of Nassyngton, husbandman 0
4788003 2292316 2292316 defendant Bolyon Robert husbandman 612330 612330 Bolyon, Robert, of Nassyngton, husbandman 0
4788004 2292316 2292316 defendant Taillour William husbandman 612330 612330 Taillour, William, of Nassyngton, husbandman 1
4788005 2292316 2292316 defendant Cook Simon husbandman 612330 612330 Cook, Simon, of Nassyngton, husbandman 2
4828984 2305107 2305107 defendant Reyncok William husbandman 612330 612330 Reyncok, William, of Nassyngton, husbandman 0
4889998 2323655 2323655 defendant Middelton John yeoman 612330 612330 Middelton, John, of Nassyngton, yeoman 3
4890332 2323744 2323744 defendant Sayton John yeoman 612330 612330 Sayton, John, of Nassyngton, yeoman 2
4908460 2329199 2329199 defendant Kesteven John   612330 612330 Kesteven, John, of Nassyngton, groom 0
4966653 2346960 2346960 defendant Middelton John husbandman 612330 612330 Middelton, John, of Nassyngton, husbandman 4
5004375 2358176 2358176 defendant Middelton John yeoman 612330 612330 Middelton, John, of Nassyngton, yeoman 0
5009745 2359731 2359731 defendant Middelton John yeoman 612330 612330 Middelton, John, of Nassyngton, yeoman 0
5009746 2359731 2359731 defendant Mydelton John yeoman 612330 612330 Mydelton, John, of Nassyngton, yeoman 1
5102838 2387248 2387248 defendant Greneham Geoffrey yeoman 612330 612330 Greneham, Geoffrey, of Nassyngton, yeoman 0
5102839 2387248 2387248 defendant Bolton William tailor 612330 612330 Bolton, William, of Nassyngton, tailor 1
5112839 2390151 2390151 defendant Chaumberleyn Stephen husbandman 612330 612330 Chaumberleyn, Stephen, of Nassyngton, husbandman 0
5112840 2390151 2390151 defendant Chaumberleyn Robert husbandman 612330 612330 Chaumberleyn, Robert, of Nassyngton, husbandman 1
5260417 2433387 2433387 defendant Ousteby Thomas clerk 612330 612330 Ousteby, Thomas, of Nassyngton, clerk 0
5321755 2451580 2451580 defendant Grenham Geoffrey husbandman 612330 612330 Grenham, Geoffrey, of Nassyngton, husbandman 1
5322104 2451682 2451682 defendant Lyndesey Thomas chaplain 612330 612330 Lyndesey, Thomas, of Nassyngton, chaplain 4
5348053 2459532 2459532 defendant Grenham Geoffrey husbandman 612330 612330 Grenham, Geoffrey, of Nassyngton, husbandman 0
5348056 2459533 2459533 defendant Grenham Geoffrey husbandman 612330 612330 Grenham, Geoffrey, of Nassyngton, 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);