names

42 rows where place_id = 654153

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3931316 2000764 2000764 defendant Smythe Thomas merchant 654153 654153 Smythe, Thomas, of Lincoln, Lincs, merchant 0
4669015 2256015 2256015 defendant London John chapman 654153 654153 London, John, of Lincoln, Lincs, chapman 0
4676889 2258390 2258390 defendant Thorp William merchant 654153 654153 Thorp, William, of Lincoln, Lincs, merchant 2
4682927 2260276 2260276 defendant Chadworth Robert currier 654153 654153 Chadworth, Robert, of Lincoln, Lincs, currier 0
4697564 2264725 2264725 defendant Haget John   654153 654153 Haget, John, of Lincoln, Lincs, canon of the cathedral church of the BM, formerly parson of Nymeton Regis, Devon 0
4742116 2278185 2278185 defendant Holme Robert merchant 654153 654153 Holme, Robert, of Lincoln, Lincs, merchant 0
4749679 2280391 2280391 defendant Ledenham William merchant 654153 654153 Ledenham, William, of Lincoln, Lincs, merchant 2
4802287 2296905 2296905 defendant Farforth John   654153 654153 Farforth, John, of Lincoln, Lincs, mason 0
4815513 2300956 2300956 defendant Copeiay Edward chapman 654153 654153 Copeiay, Edward, of Lincoln, Lincs, chapman 2
4835214 2307013 2307013 defendant Burn John mercer 654153 654153 Burn, John, of Lincoln, Lincs, mercer 3
4998019 2356268 2356268 defendant Rede Gilbert   654153 654153 Rede, Gilbert, of Lincoln, Lincs, arrow maker 0
5008695 2359436 2359436 defendant Eman Richard yeoman 654153 654153 Eman, Richard, of Lincoln, Lincs, yeoman 0
5152854 2401976 2401976 defendant Carberton John merchant 654153 654153 Carberton, John, of Lincoln, Lincs, merchant 0
5170411 2407075 2407075 defendant Wytham William clerk 654153 654153 Wytham, William, of Lincoln, Lincs, clerk 0
5191548 2413269 2413269 defendant Wadhill Thomas   654153 654153 Wadhill, Thomas, of Lincoln, Lincs, bell maker 3
5271967 2436884 2436884 defendant Dene Richard chaplain 654153 654153 Dene, Richard, of Lincoln, Lincs, chaplain 0
5302741 2445802 2445802 defendant Marshall William yeoman 654153 654153 Marshall, William, of Lincoln, Lincs, yeoman 0
5308779 2447665 2447665 defendant Kyrkeham Robert chapman 654153 654153 Kyrkeham, Robert, of Lincoln, Lincs, chapman 1
5308782 2447666 2447666 defendant Kyrkeham Robert chapman 654153 654153 Kyrkeham, Robert, of Lincoln, Lincs, chapman 1
5394533 2473496 2473496 defendant Horne John broker 654153 654153 Horne, John, of Lincoln, Lincs, broker 0
5412199 2478601 2478601 defendant Bylby William yeoman 654153 654153 Bylby, William, of Lincoln, Lincs, yeoman 0
5414278 2479204 2479204 defendant Perkyn William draper 654153 654153 Perkyn, William, of Lincoln, Lincs, draper 0
5415706 2479640 2479640 defendant Grantham Robert gent 654153 654153 Grantham, Robert, of Lincoln, Lincs, gent 0
5419854 2480853 2480853 defendant Martyn William gent 654153 654153 Martyn, William, of Lincoln, Lincs, gent 3
5420982 2481205 2481205 defendant Horne John broker 654153 654153 Horne, John, of Lincoln, Lincs, broker 0
5428205 2483375 2483375 defendant Saynton John gent 654153 654153 Saynton, John, of Lincoln, Lincs, gent 1
5428242 2483379 2483379 defendant Barforth Thomas yeoman 654153 654153 Barforth, Thomas, of Lincoln, Lincs, yeoman 0
5428261 2483381 2483381 defendant Saynton John gent 654153 654153 Saynton, John, of Lincoln, Lincs, gent 1
5428272 2483382 2483382 defendant Barforth Thomas yeoman 654153 654153 Barforth, Thomas, of Lincoln, Lincs, yeoman 0
5428282 2483383 2483383 defendant Saynton John gent 654153 654153 Saynton, John, of Lincoln, Lincs, gent 1
5432183 2484592 2484592 defendant Reed William butcher 654153 654153 Reed, William, of Lincoln, Lincs, butcher 0
5432187 2484594 2484594 defendant Wolhous Ralph fishmonger 654153 654153 Wolhous, Ralph, of Lincoln, Lincs, fishmonger 0
5433424 2484954 2484954 defendant Hokam John fishmonger 654153 654153 Hokam, John, of Lincoln, Lincs, fishmonger 0
5438144 2486343 2486343 defendant Batty John mercer 654153 654153 Batty, John, of Lincoln, Lincs, mercer 3
5438387 2486413 2486413 defendant Martyn William gent 654153 654153 Martyn, William, of Lincoln, Lincs, gent 3
5441599 2487405 2487405 defendant Waddesworth Thomas butcher 654153 654153 Waddesworth, Thomas, of Lincoln, Lincs, butcher 0
5448549 2489464 2489464 defendant Boston John mercer 654153 654153 Boston, John, of Lincoln, Lincs, mercer 1
5452272 2490555 2490555 defendant Batte John mercer 654153 654153 Batte, John, of Lincoln, Lincs, mercer 3
5452278 2490556 2490556 defendant Batte John mercer 654153 654153 Batte, John, of Lincoln, Lincs, mercer 3
5460848 2493192 2493192 defendant Boston John mercer 654153 654153 Boston, John, of Lincoln, Lincs, mercer 0
5470062 2495961 2495961 defendant Barkworth Thomas yeoman 654153 654153 Barkworth, Thomas, of Lincoln, Lincs, yeoman 0
5470653 2496141 2496141 defendant Hunte William   654153 654153 Hunte, William, of Lincoln, Lincs, coverlet weaver 4

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