names

32 rows where place_id = 622517

✎ 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
3747457 1941119 1941119 defendant Stalworthy Alexander husbandman 622517 622517 Stalworthy, Alexander, of Sternefeld, husbandman 0
3748275 1941388 1941388 defendant Stalworthy Alexander husbandman 622517 622517 Stalworthy, Alexander, of Sternefeld, husbandman 0
3761255 1945522 1945522 defendant Stalworthy Alexander husbandman 622517 622517 Stalworthy, Alexander, of Sternefeld, husbandman 0
3909623 1993525 1993525 defendant Grene Thomas   622517 622517 Grene, Thomas, of Sternefeld, tallow chandler 0
3913947 1995011 1995011 defendant Grene Thomas   622517 622517 Grene, Thomas, of Sternefeld, tallow chandler 0
3913948 1995011 1995011 defendant Askettell Lawrence husbandman 622517 622517 Askettell, Lawrence, of Sternefeld, husbandman 1
3932122 2001047 2001047 defendant Stalworthye John hsubandman 622517 622517 Stalworthye, John, of Sternefeld, hsubandman 0
3943431 2004817 2004817 defendant Cawston William tailor 622517 622517 (Cawston, William, of Sternefeld, tailor 3
3955325 2008932 2008932 defendant Rackham Robert husbandman 622517 622517 Rackham, Robert, of Sternefeld, husbandman 1
3955326 2008932 2008932 defendant Newson Thomas husbandman 622517 622517 Newson, Thomas, of Sternefeld, husbandman 2
3956665 2009396 2009396 defendant Stalworthy John husbandman 622517 622517 Stalworthy, John, of Sternefeld, husbandman 0
3956666 2009396 2009396 defendant Stalworthy Robert husbandman 622517 622517 Stalworthy, Robert, of Sternefeld, husbandman 1
4043393 2040100 2040100 plaintiff Poll Stephen   622517 622517 Poll, Stephen, of Sternefeld 0
4630962 2240576 2240576 plaintiff Swyft John   622517 622517 Swyft, John, of Sternefeld 0
4640251 2243265 2243265 plaintiff Deye William   622517 622517 Deye, William, of Sternefeld 0
4721157 2271951 2271951 defendant Kirkeby John laborer 622517 622517 Kirkeby, John, of Sternefeld, laborer 3
5314436 2449343 2449343 defendant Geffrey Thomas yeoman 622517 622517 Geffrey, Thomas, of Sternefeld, yeoman 4
5317599 2450351 2450351 defendant Kyrkeby Thomas butcher 622517 622517 Kyrkeby, Thomas, of Sternefeld, butcher 0
5319837 2451026 2451026 defendant Jaffrey Thomas   622517 622517 Jaffrey, Thomas, of Sternefeld 1
5413708 2479026 2479026 defendant Kenge Rose widow 622517 622517 Kenge, Rose, of Sternefeld, widow 2
5413711 2479026 2479026 defendant Asketyll Richard husbandman 622517 622517 Asketyll, Richard, of Sternefeld, husbandman 5
5413712 2479026 2479026 defendant Lynde John tanner 622517 622517 Lynde, John, of Sternefeld, tanner 6
5431218 2484281 2484281 plaintiff Lynde John   622517 622517 Lynde, John, of Sternefeld 1
5433442 2484960 2484960 defendant Gefferey Thomas yeoman 622517 622517 Gefferey, Thomas, of Sternefeld, yeoman 2
5447440 2489122 2489122 defendant Jefferey Thomas yeoman 622517 622517 Jefferey, Thomas, of Sternefeld, yeoman 2
5447740 2489202 2489202 plaintiff H_ John   622517 622517 H_, John, of Sternefeld 1
5451914 2490454 2490454 defendant Lynde John tanner 622517 622517 Lynde, John, of Sternefeld, tanner 0
5460122 2492961 2492961 plaintiff Lynde John   622517 622517 Lynde, John, of Sternefeld 1
5460125 2492962 2492962 plaintiff Lynde John   622517 622517 Lynde, John, of Sternefeld 1
5460128 2492963 2492963 plaintiff Lynde John   622517 622517 Lynde, John, of Sternefeld 1
5463889 2494116 2494116 defendant Lynde John tanner 622517 622517 Lynde, John, of Sternefeld, tanner 0
5473056 2496896 2496896 defendant Jefferey Thomas yeoman 622517 622517 Jefferey, Thomas, of Sternefeld, yeoman 2

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);