names

50 rows where place_id = 602198

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648920 1910051 1910051 plaintiff Parker Margaret widow 602198 602198 Parker, Margaret, of Chepyng Faryngdon, widow 0
3662866 1914299 1914299 defendant Draper Robert yeoman 602198 602198 Draper, Robert, of Chepyng Faryngdon, yeoman 2
3662867 1914299 1914299 defendant Seward John (legal representative) 602198 602198 Seward, John, of Chepyng Faryngdon, roper, executrix of 3
3662868 1914299 1914299 defendant Seward Agnes widow 602198 602198 Seward, Agnes, of Chepyng Faryngdon, widow 4
3703720 1927444 1927444 defendant Coksetur Thomas husbandman 602198 602198 Coksetur, Thomas, of Chepyng Faryngdon, husbandman 0
3703722 1927445 1927445 defendant Coksetur Thomas husbandman 602198 602198 Coksetur, Thomas, of Chepyng Faryngdon, husbandman 0
3868301 1979639 1979639 defendant Hykkys William baker 602198 602198 Hykkys, William, of Chepyng Faryngdon, baker 2
4651125 2246354 2246354 defendant Olyver John cordwainer 602198 602198 Olyver, John, of Chepyng Faryngdon, cordwainer 0
4651127 2246354 2246354 defendant Baret John cordwainer 602198 602198 Baret, John, of Chepyng Faryngdon, cordwainer 2
4861918 2315106 2315106 defendant Sely John yeoman 602198 602198 Sely, John, of Chepyng Faryngdon, yeoman 0
4861919 2315106 2315106 defendant Hunte William yeoman 602198 602198 Hunte, William, of Chepyng Faryngdon, yeoman 1
4861920 2315106 2315106 defendant Rome Stephen shoemaker 602198 602198 Rome, Stephen, of Chepyng Faryngdon, shoemaker 2
4883748 2321827 2321827 defendant Cely Petronilla widow 602198 602198 Cely, Petronilla, of Chepyng Faryngdon, widow 1
4909739 2329568 2329568 defendant Dylderwell Richard (legal representative) 602198 602198 Dylderwell, Richard, of Chepyng Faryngdon, executor of 2
4909740 2329568 2329568 defendant Moyne John husbandman 602198 602198 Moyne, John, of Chepyng Faryngdon, husbandman 3
4909747 2329570 2329570 defendant Bilderwell Richard (legal representative) 602198 602198 Bilderwell, Richard, of Chepyng Faryngdon, executor of 2
4909748 2329570 2329570 defendant Moyne John husbandman 602198 602198 Moyne, John, of Chepyng Faryngdon, husbandman 3
4957020 2344058 2344058 defendant Bailly Thomas   602198 602198 Bailly, Thomas, of Chepyng Faryngdon, bailiff 1
4957021 2344058 2344058 defendant Belcher John currier 602198 602198 Belcher, John, of Chepyng Faryngdon, currier 2
4957022 2344058 2344058 defendant Cutler John   602198 602198 Cutler, John, of Chepyng Faryngdon, mason 3
4957023 2344058 2344058 defendant Olyvere Thomas husbandman 602198 602198 Olyvere, Thomas, of Chepyng Faryngdon, husbandman 4
4957024 2344058 2344058 defendant Abram William peddler 602198 602198 Abram, William, of Chepyng Faryngdon, peddler 5
4957025 2344058 2344058 defendant Bestele Robert husbandman 602198 602198 Bestele, Robert, of Chepyng Faryngdon, husbandman 6
4957026 2344058 2344058 defendant Shepeherd Thomas husbandman 602198 602198 Shepeherd, Thomas, of Chepyng Faryngdon, husbandman 7
4957027 2344058 2344058 defendant Smyth John smith 602198 602198 Smyth, John, of Chepyng Faryngdon, smith 8
4957028 2344058 2344058 defendant Moyn John husbandman 602198 602198 Moyn, John, of Chepyng Faryngdon, husbandman 9
4957029 2344058 2344058 defendant Bathe Thomas husbandman 602198 602198 Bathe, Thomas, of Chepyng Faryngdon, husbandman 10
4957030 2344058 2344058 defendant Bourn John fisher 602198 602198 Bourn, John, of Chepyng Faryngdon, fisher 11
4957031 2344058 2344058 defendant Pervaunt or Pernaunt William husbandman 602198 602198 Pervaunt or Pernaunt, William, of Chepyng Faryngdon, husbandman 12
4957032 2344058 2344058 defendant Parker John husbandman 602198 602198 Parker, John, of Chepyng Faryngdon, husbandman 13
5022266 2363407 2363407 defendant Andrewe Richard fuller 602198 602198 Andrewe, Richard, of Chepyng Faryngdon, fuller 1
5037590 2367867 2367867 defendant Smerte William chapman 602198 602198 Smerte, William, of Chepyng Faryngdon, chapman 0
5037591 2367867 2367867 defendant Clynche Nicholas husbandman 602198 602198 Clynche, Nicholas, of Chepyng Faryngdon, husbandman 1
5056036 2373377 2373377 defendant Bathe Thomas husbandman 602198 602198 Bathe, Thomas, of Chepyng Faryngdon, husbandman 0
5081356 2380929 2380929 defendant Hall Richard chapman 602198 602198 Hall, Richard, of Chepyng Faryngdon, chapman 0
5081357 2380929 2380929 defendant Clerk William husbandman 602198 602198 Clerk, William, of Chepyng Faryngdon, husbandman 1
5106029 2388201 2388201 defendant Moyn Robert mercer 602198 602198 Moyn, Robert,of Chepyng Faryngdon, mercer 0
5117473 2391544 2391544 defendant Rogger alias Sclatter John yeoman 602198 602198 Rogger alias Sclatter, John, of Chepyng Faryngdon, yeoman 3
5117479 2391545 2391545 defendant Rogger alias Sclatter John yeoman 602198 602198 Rogger alias Sclatter, John, of Chepyng Faryngdon, yeoman 3
5129791 2395200 2395200 defendant Broton John husbandman 602198 602198 Broton, John, of Chepyng Faryngdon, husbandman 1
5133238 2396206 2396206 defendant Trunchard Thomas husbandman 602198 602198 Trunchard, Thomas, of Chepyng Faryngdon, husbandman 0
5138854 2397866 2397866 defendant Moyne Robert mercer 602198 602198 Moyne, Robert, of Chepyng Faryngdon, mercer 0
5138855 2397866 2397866 defendant Cokkys Richard draper 602198 602198 Cokkys, Richard, of Chepyng Faryngdon, draper 1
5245866 2428954 2428954 defendant Richard William husbandman 602198 602198 Richard, William, of Chepyng Faryngdon, husbandman 1
5274917 2437749 2437749 defendant Draper Thomas husbandman 602198 602198 Draper, Thomas, of Chepyng Faryngdon, husbandman 0
5324424 2452389 2452389 defendant Draper Thomas yeoman 602198 602198 Draper, Thomas, of Chepyng Faryngdon, yeoman 2
5502962 2505837 2505837 defendant Draper Robert   602198 602198 Draper, Robert, of Chepyng Faryngdon, his son 1
5505211 2506539 2506539 defendant Maydman Thomas fuller 602198 602198 Maydman, Thomas, of Chepyng Faryngdon, fuller 0
5521924 2511673 2511673 defendant Malter Henry mercer 602198 602198 Malter, Henry, of Chepyng Faryngdon, mercer 0
5523381 2512144 2512144 defendant Waterman Robert glover 602198 602198 Waterman, Robert, of Chepyng Faryngdon, glover 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);